2026-05-01 21:22:58,132 - main - INFO - === Logging system initialized ===
2026-05-01 21:22:58,132 - main - INFO - Log file: logs/app_20260501_212258.log
2026-05-01 21:22:58,132 - main - INFO - Log level: INFO
2026-05-01 21:22:58,132 - main - INFO - Timestamp: 20260501_212258
2026-05-01 21:22:58,193 - main - INFO - Included router: routers.admin_dashboard.router
2026-05-01 21:22:58,233 - main - INFO - Included router: routers.agent_availability.router
2026-05-01 21:22:58,836 - main - INFO - Included router: routers.ai_ticket_summary.router
2026-05-01 21:22:58,854 - main - INFO - Included router: routers.aihub.router
2026-05-01 21:22:58,866 - main - INFO - Included router: routers.auth.router
2026-05-01 21:22:58,916 - main - INFO - Included router: routers.chat_analytics_daily.router
2026-05-01 21:22:58,957 - main - INFO - Included router: routers.chat_attachments.router
2026-05-01 21:22:59,020 - main - INFO - Included router: routers.chat_branding.router
2026-05-01 21:22:59,046 - main - INFO - Included router: routers.chat_branding_api.router
2026-05-01 21:22:59,100 - main - INFO - Included router: routers.chat_conversations.router
2026-05-01 21:22:59,236 - main - INFO - Included router: routers.chat_messages.router
2026-05-01 21:22:59,279 - main - INFO - Included router: routers.chat_routing_rules.router
2026-05-01 21:22:59,302 - main - INFO - Included router: routers.contact.router
2026-05-01 21:22:59,345 - main - INFO - Included router: routers.contact_inquiries.router
2026-05-01 21:22:59,347 - main - INFO - Included router: routers.health.router
2026-05-01 21:22:59,388 - main - INFO - Included router: routers.kb_articles.router
2026-05-01 21:22:59,434 - main - INFO - Included router: routers.notification_preferences.router
2026-05-01 21:22:59,482 - main - INFO - Included router: routers.notifications.router
2026-05-01 21:22:59,488 - main - INFO - Included router: routers.notifications_extras.router
2026-05-01 21:22:59,579 - main - INFO - Included router: routers.oauth.router
2026-05-01 21:22:59,638 - main - INFO - Included router: routers.plans.router
2026-05-01 21:22:59,669 - main - INFO - Included router: routers.role_management.router
2026-05-01 21:22:59,694 - main - INFO - Included router: routers.settings.router
2026-05-01 21:22:59,745 - main - INFO - Included router: routers.site_settings.router
2026-05-01 21:22:59,801 - main - INFO - Included router: routers.smtp_settings.router
2026-05-01 21:22:59,850 - main - INFO - Included router: routers.storage.router
2026-05-01 21:23:00,095 - main - INFO - Included router: routers.support_chat.router
2026-05-01 21:23:00,170 - main - INFO - Included router: routers.support_departments.router
2026-05-01 21:23:00,222 - main - INFO - Included router: routers.support_seats.router
2026-05-01 21:23:00,235 - main - INFO - Included router: routers.ticket_notifications_sync.router
2026-05-01 21:23:00,280 - main - INFO - Included router: routers.ticket_summaries.router
2026-05-01 21:23:00,326 - main - INFO - Included router: routers.ticket_sync_states.router
2026-05-01 21:23:00,338 - main - INFO - Included router: routers.user.router
2026-05-01 21:23:00,392 - main - INFO - Included router: routers.user_profiles.router
2026-05-01 21:23:00,439 - main - INFO - Included router: routers.user_roles.router
2026-05-01 21:23:00,459 - main - INFO - Included router: routers.whmcs.router
2026-05-01 21:23:00,528 - main - INFO - Included router: routers.whmcs_admin.router
2026-05-01 21:23:00,578 - main - INFO - Included router: routers.whmcs_extra.router
2026-05-01 21:23:00,582 - main - INFO - === Application startup initiated ===
2026-05-01 21:23:00,583 - services.database - INFO - Ignore creating tables
2026-05-01 21:23:00,584 - services.mock_data - INFO - Ignore initialize data
2026-05-01 21:23:00,584 - services.auth - INFO - Ignore initialize admin
2026-05-01 21:23:00,585 - main - INFO - === Application startup completed successfully ===
2026-05-01 21:23:08,486 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-01 21:23:08,489 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:23:08,489 - core.database - WARNING - Database session maker not available, attempting lazy initialization...
2026-05-01 21:23:08,490 - core.database - WARNING - Database not initialized, attempting lazy initialization...
2026-05-01 21:23:08,490 - core.database - INFO - Starting database initialization...
2026-05-01 21:23:08,490 - core.config - DEBUG - Read dynamic attribute database_url from environment variable DATABASE_URL
2026-05-01 21:23:08,490 - core.database - INFO - Normalizing database URL for async compatibility...
2026-05-01 21:23:08,491 - core.database - INFO - Creating async database engine...
2026-05-01 21:23:08,491 - core.database - INFO - Using QueuePool with connection pooling for non-Lambda environment
2026-05-01 21:23:08,538 - core.database - INFO - Database engine created successfully
2026-05-01 21:23:08,539 - core.database - INFO - Creating async session maker...
2026-05-01 21:23:08,539 - core.database - INFO - Async session maker created successfully
2026-05-01 21:23:08,539 - core.database - INFO - Database connection initialized successfully
2026-05-01 21:23:08,539 - core.database - DEBUG - [DB_OP] Starting create_tables
2026-05-01 21:23:08,539 - core.database - INFO - 🔧 Starting table creation...
2026-05-01 21:23:08,545 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:23:08,546 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-01 21:23:08,549 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:23:08,550 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-05-01 21:23:08,550 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 21:23:09,816 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.2705s
2026-05-01 21:23:09,943 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 21:23:09,943 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.3941s
2026-05-01 21:23:11,385 - core.database - INFO - Tables initialized successfully
2026-05-01 21:23:11,386 - core.database - DEBUG - [DB_OP] Create tables completed in 2.8467s
2026-05-01 21:23:11,449 - core.database - INFO - Lazy database initialization completed successfully
2026-05-01 21:23:11,450 - core.database - DEBUG - [DB_OP] Database session created successfully in 2.9606s
2026-05-01 21:23:11,451 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 21:23:12,019 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 21:23:12,019 - core.database - DEBUG - [DB_OP] Database session cleanup after 3.5301s
2026-05-01 21:23:30,710 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:23:30,711 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-01 21:23:31,153 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4432s
2026-05-01 21:23:41,713 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:23:41,713 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 21:23:42,158 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4447s
2026-05-01 21:24:08,509 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:24:08,509 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 21:24:08,826 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3173s
2026-05-01 21:24:31,707 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:24:31,708 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0006s
2026-05-01 21:24:32,022 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3147s
2026-05-01 21:24:42,708 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:24:42,709 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-01 21:24:43,028 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3200s
2026-05-01 21:25:09,364 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:25:09,364 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-01 21:25:09,682 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3179s
2026-05-01 21:25:32,699 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:25:32,700 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 21:25:33,016 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3170s
2026-05-01 21:25:43,712 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:25:43,712 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 21:25:44,031 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3189s
2026-05-01 21:26:08,506 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:26:08,507 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 21:26:08,823 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3163s
2026-05-01 21:26:33,706 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:26:33,707 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 21:26:34,024 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3174s
2026-05-01 21:26:44,705 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:26:44,705 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 21:26:45,025 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3198s
2026-05-01 21:27:09,179 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:27:09,180 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 21:27:09,496 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3171s
2026-05-01 21:27:20,079 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:27:20,081 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0021s
2026-05-01 21:27:20,083 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 21:27:20,464 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 21:27:20,465 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3855s
2026-05-01 21:27:34,715 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:27:34,716 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 21:27:35,036 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3201s
2026-05-01 21:27:45,710 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:27:45,711 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-01 21:27:46,028 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3182s
2026-05-01 21:28:13,186 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:28:13,187 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 21:28:13,513 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3264s
2026-05-01 21:28:21,204 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:28:21,205 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 21:28:21,206 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-01 21:28:21,207 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:28:21,207 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-01 21:28:21,208 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 21:28:21,209 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:28:21,210 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-01 21:28:21,210 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 21:28:21,524 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3200s
2026-05-01 21:28:21,586 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 21:28:21,587 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3773s
2026-05-01 21:28:21,714 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 21:28:21,715 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.5079s
2026-05-01 21:28:22,058 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:28:22,059 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-01 21:28:22,061 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:28:22,061 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-05-01 21:28:22,061 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 21:28:22,064 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:28:22,064 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-05-01 21:28:22,064 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 21:28:22,066 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-01 21:28:22,377 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3182s
2026-05-01 21:28:22,439 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 21:28:22,440 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3793s
2026-05-01 21:28:22,441 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 21:28:22,442 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3782s
2026-05-01 21:28:35,712 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:28:35,713 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0007s
2026-05-01 21:28:36,035 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3230s
2026-05-01 21:28:46,707 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:28:46,707 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 21:28:47,147 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4406s
2026-05-01 21:29:22,079 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:29:22,079 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 21:29:22,396 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3176s
2026-05-01 21:29:26,974 - services.database - DEBUG - [DB_OP] Starting database close
2026-05-01 21:29:27,175 - core.database - INFO - Database connection closed and engine disposed
2026-05-01 21:29:27,175 - services.database - INFO - Database connections closed
2026-05-01 21:29:27,175 - services.database - DEBUG - [DB_OP] Database close completed in 0.2011s