2026-05-01 21:11:30,111 - main - INFO - === Logging system initialized ===
2026-05-01 21:11:30,111 - main - INFO - Log file: logs/app_20260501_211130.log
2026-05-01 21:11:30,111 - main - INFO - Log level: INFO
2026-05-01 21:11:30,112 - main - INFO - Timestamp: 20260501_211130
2026-05-01 21:11:30,198 - main - INFO - Included router: routers.admin_dashboard.router
2026-05-01 21:11:30,253 - main - INFO - Included router: routers.agent_availability.router
2026-05-01 21:11:31,113 - main - INFO - Included router: routers.ai_ticket_summary.router
2026-05-01 21:11:31,131 - main - INFO - Included router: routers.aihub.router
2026-05-01 21:11:31,147 - main - INFO - Included router: routers.auth.router
2026-05-01 21:11:31,203 - main - INFO - Included router: routers.chat_analytics_daily.router
2026-05-01 21:11:31,251 - main - INFO - Included router: routers.chat_attachments.router
2026-05-01 21:11:31,316 - main - INFO - Included router: routers.chat_branding.router
2026-05-01 21:11:31,330 - main - INFO - Included router: routers.chat_branding_api.router
2026-05-01 21:11:31,380 - main - INFO - Included router: routers.chat_conversations.router
2026-05-01 21:11:31,505 - main - INFO - Included router: routers.chat_messages.router
2026-05-01 21:11:31,548 - main - INFO - Included router: routers.chat_routing_rules.router
2026-05-01 21:11:31,572 - main - INFO - Included router: routers.contact.router
2026-05-01 21:11:31,617 - main - INFO - Included router: routers.contact_inquiries.router
2026-05-01 21:11:31,619 - main - INFO - Included router: routers.health.router
2026-05-01 21:11:31,663 - main - INFO - Included router: routers.kb_articles.router
2026-05-01 21:11:31,708 - main - INFO - Included router: routers.notification_preferences.router
2026-05-01 21:11:31,766 - main - INFO - Included router: routers.notifications.router
2026-05-01 21:11:31,772 - main - INFO - Included router: routers.notifications_extras.router
2026-05-01 21:11:31,859 - main - INFO - Included router: routers.oauth.router
2026-05-01 21:11:31,907 - main - INFO - Included router: routers.plans.router
2026-05-01 21:11:31,933 - main - INFO - Included router: routers.role_management.router
2026-05-01 21:11:31,954 - main - INFO - Included router: routers.settings.router
2026-05-01 21:11:31,992 - main - INFO - Included router: routers.site_settings.router
2026-05-01 21:11:32,059 - main - INFO - Included router: routers.smtp_settings.router
2026-05-01 21:11:32,098 - main - INFO - Included router: routers.storage.router
2026-05-01 21:11:32,346 - main - INFO - Included router: routers.support_chat.router
2026-05-01 21:11:32,404 - main - INFO - Included router: routers.support_departments.router
2026-05-01 21:11:32,448 - main - INFO - Included router: routers.support_seats.router
2026-05-01 21:11:32,455 - main - INFO - Included router: routers.ticket_notifications_sync.router
2026-05-01 21:11:32,490 - main - INFO - Included router: routers.ticket_summaries.router
2026-05-01 21:11:32,530 - main - INFO - Included router: routers.ticket_sync_states.router
2026-05-01 21:11:32,539 - main - INFO - Included router: routers.user.router
2026-05-01 21:11:32,584 - main - INFO - Included router: routers.user_profiles.router
2026-05-01 21:11:32,620 - main - INFO - Included router: routers.user_roles.router
2026-05-01 21:11:32,639 - main - INFO - Included router: routers.whmcs.router
2026-05-01 21:11:32,699 - main - INFO - Included router: routers.whmcs_admin.router
2026-05-01 21:11:32,738 - main - INFO - Included router: routers.whmcs_extra.router
2026-05-01 21:11:32,739 - main - INFO - === Application startup initiated ===
2026-05-01 21:11:32,739 - services.database - INFO - Ignore creating tables
2026-05-01 21:11:32,739 - services.mock_data - INFO - Ignore initialize data
2026-05-01 21:11:32,739 - services.auth - INFO - Ignore initialize admin
2026-05-01 21:11:32,740 - main - INFO - === Application startup completed successfully ===
2026-05-01 21:11:58,554 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-01 21:11:58,556 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:11:58,556 - core.database - WARNING - Database session maker not available, attempting lazy initialization...
2026-05-01 21:11:58,556 - core.database - WARNING - Database not initialized, attempting lazy initialization...
2026-05-01 21:11:58,557 - core.database - INFO - Starting database initialization...
2026-05-01 21:11:58,557 - core.config - DEBUG - Read dynamic attribute database_url from environment variable DATABASE_URL
2026-05-01 21:11:58,557 - core.database - INFO - Normalizing database URL for async compatibility...
2026-05-01 21:11:58,558 - core.database - INFO - Creating async database engine...
2026-05-01 21:11:58,558 - core.database - INFO - Using QueuePool with connection pooling for non-Lambda environment
2026-05-01 21:11:58,604 - core.database - INFO - Database engine created successfully
2026-05-01 21:11:58,605 - core.database - INFO - Creating async session maker...
2026-05-01 21:11:58,605 - core.database - INFO - Async session maker created successfully
2026-05-01 21:11:58,605 - core.database - INFO - Database connection initialized successfully
2026-05-01 21:11:58,605 - core.database - DEBUG - [DB_OP] Starting create_tables
2026-05-01 21:11:58,605 - core.database - INFO - 🔧 Starting table creation...
2026-05-01 21:11:58,612 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:11:58,612 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-05-01 21:11:58,613 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 21:11:58,617 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:11:58,617 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-01 21:11:58,617 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 21:12:00,003 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 21:12:00,004 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.3875s
2026-05-01 21:12:00,005 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 21:12:00,005 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.3929s
2026-05-01 21:12:01,424 - core.database - INFO - Tables initialized successfully
2026-05-01 21:12:01,425 - core.database - DEBUG - [DB_OP] Create tables completed in 2.8198s
2026-05-01 21:12:01,488 - core.database - INFO - Lazy database initialization completed successfully
2026-05-01 21:12:01,488 - core.database - DEBUG - [DB_OP] Database session created successfully in 2.9323s
2026-05-01 21:12:01,932 - core.database - DEBUG - [DB_OP] Database session cleanup after 3.3756s
2026-05-01 21:12:21,259 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:12:21,259 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 21:12:21,702 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4428s
2026-05-01 21:12:30,696 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:12:30,696 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 21:12:31,141 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4449s
2026-05-01 21:12:58,824 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:12:58,824 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 21:12:59,141 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3169s
2026-05-01 21:13:21,254 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:13:21,255 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0009s
2026-05-01 21:13:21,572 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3179s
2026-05-01 21:13:31,701 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:13:31,702 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0006s
2026-05-01 21:13:32,019 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3182s
2026-05-01 21:13:59,499 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:13:59,499 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 21:13:59,500 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 21:13:59,502 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:13:59,502 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-01 21:13:59,503 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-01 21:13:59,504 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:13:59,504 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-01 21:13:59,505 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 21:13:59,826 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3239s
2026-05-01 21:13:59,881 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 21:13:59,881 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3825s
2026-05-01 21:14:00,017 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 21:14:00,018 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.5141s
2026-05-01 21:14:21,707 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:14:21,707 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 21:14:22,024 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3169s
2026-05-01 21:14:32,703 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:14:32,704 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0008s
2026-05-01 21:14:33,022 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3193s
2026-05-01 21:14:59,515 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:14:59,516 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 21:14:59,834 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3186s
2026-05-01 21:15:22,712 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:15:22,713 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0006s
2026-05-01 21:15:23,031 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3192s
2026-05-01 21:15:33,708 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:15:33,708 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0006s
2026-05-01 21:15:34,024 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3162s
2026-05-01 21:15:59,519 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:15:59,520 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 21:15:59,837 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3180s
2026-05-01 21:16:23,703 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:16:23,703 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-01 21:16:24,021 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3186s
2026-05-01 21:16:34,732 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:16:34,732 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 21:16:35,051 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3188s
2026-05-01 21:16:59,520 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:16:59,521 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0007s
2026-05-01 21:16:59,839 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3192s
2026-05-01 21:17:24,715 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:17:24,715 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 21:17:25,163 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4482s
2026-05-01 21:17:30,630 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:17:30,630 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-01 21:17:30,632 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-01 21:17:30,633 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:17:30,633 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 21:17:30,634 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 21:17:30,637 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:17:30,637 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-01 21:17:30,637 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 21:17:31,018 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 21:17:31,019 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3820s
2026-05-01 21:17:31,021 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 21:17:31,021 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3888s
2026-05-01 21:17:31,086 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4561s
2026-05-01 21:17:35,705 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:17:35,706 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0006s
2026-05-01 21:17:35,949 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:17:35,949 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 21:17:35,949 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 21:17:35,951 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:17:35,951 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-01 21:17:35,951 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 21:17:35,953 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-01 21:17:36,023 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3183s
2026-05-01 21:17:36,250 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:17:36,250 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 21:17:36,329 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 21:17:36,330 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3786s
2026-05-01 21:17:36,458 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 21:17:36,458 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.5098s
2026-05-01 21:17:36,567 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3174s
2026-05-01 21:18:25,715 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:18:25,715 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 21:18:26,032 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3174s
2026-05-01 21:18:33,194 - services.database - DEBUG - [DB_OP] Starting database close
2026-05-01 21:18:33,394 - core.database - INFO - Database connection closed and engine disposed
2026-05-01 21:18:33,394 - services.database - INFO - Database connections closed
2026-05-01 21:18:33,395 - services.database - DEBUG - [DB_OP] Database close completed in 0.2011s