2026-05-01 21:34:27,677 - main - INFO - === Logging system initialized ===
2026-05-01 21:34:27,677 - main - INFO - Log file: logs/app_20260501_213427.log
2026-05-01 21:34:27,678 - main - INFO - Log level: INFO
2026-05-01 21:34:27,678 - main - INFO - Timestamp: 20260501_213427
2026-05-01 21:34:27,767 - main - INFO - Included router: routers.admin_dashboard.router
2026-05-01 21:34:27,812 - main - INFO - Included router: routers.agent_availability.router
2026-05-01 21:34:28,822 - main - INFO - Included router: routers.ai_ticket_summary.router
2026-05-01 21:34:28,846 - main - INFO - Included router: routers.aihub.router
2026-05-01 21:34:28,863 - main - INFO - Included router: routers.auth.router
2026-05-01 21:34:28,912 - main - INFO - Included router: routers.chat_analytics_daily.router
2026-05-01 21:34:28,964 - main - INFO - Included router: routers.chat_attachments.router
2026-05-01 21:34:29,034 - main - INFO - Included router: routers.chat_branding.router
2026-05-01 21:34:29,058 - main - INFO - Included router: routers.chat_branding_api.router
2026-05-01 21:34:29,112 - main - INFO - Included router: routers.chat_conversations.router
2026-05-01 21:34:29,239 - main - INFO - Included router: routers.chat_messages.router
2026-05-01 21:34:29,280 - main - INFO - Included router: routers.chat_routing_rules.router
2026-05-01 21:34:29,311 - main - INFO - Included router: routers.contact.router
2026-05-01 21:34:29,359 - main - INFO - Included router: routers.contact_inquiries.router
2026-05-01 21:34:29,362 - main - INFO - Included router: routers.health.router
2026-05-01 21:34:29,416 - main - INFO - Included router: routers.kb_articles.router
2026-05-01 21:34:29,468 - main - INFO - Included router: routers.notification_preferences.router
2026-05-01 21:34:29,532 - main - INFO - Included router: routers.notifications.router
2026-05-01 21:34:29,538 - main - INFO - Included router: routers.notifications_extras.router
2026-05-01 21:34:29,648 - main - INFO - Included router: routers.oauth.router
2026-05-01 21:34:29,715 - main - INFO - Included router: routers.plans.router
2026-05-01 21:34:29,767 - main - INFO - Included router: routers.role_management.router
2026-05-01 21:34:29,789 - main - INFO - Included router: routers.settings.router
2026-05-01 21:34:29,848 - main - INFO - Included router: routers.site_settings.router
2026-05-01 21:34:29,914 - main - INFO - Included router: routers.smtp_settings.router
2026-05-01 21:34:29,961 - main - INFO - Included router: routers.storage.router
2026-05-01 21:34:30,232 - main - INFO - Included router: routers.support_chat.router
2026-05-01 21:34:30,281 - main - INFO - Included router: routers.support_departments.router
2026-05-01 21:34:30,326 - main - INFO - Included router: routers.support_seats.router
2026-05-01 21:34:30,338 - main - INFO - Included router: routers.ticket_notifications_sync.router
2026-05-01 21:34:30,384 - main - INFO - Included router: routers.ticket_summaries.router
2026-05-01 21:34:30,433 - main - INFO - Included router: routers.ticket_sync_states.router
2026-05-01 21:34:30,446 - main - INFO - Included router: routers.user.router
2026-05-01 21:34:30,502 - main - INFO - Included router: routers.user_profiles.router
2026-05-01 21:34:30,553 - main - INFO - Included router: routers.user_roles.router
2026-05-01 21:34:30,579 - main - INFO - Included router: routers.whmcs.router
2026-05-01 21:34:30,650 - main - INFO - Included router: routers.whmcs_admin.router
2026-05-01 21:34:30,704 - main - INFO - Included router: routers.whmcs_extra.router
2026-05-01 21:34:30,706 - main - INFO - === Application startup initiated ===
2026-05-01 21:34:30,706 - services.database - INFO - Ignore creating tables
2026-05-01 21:34:30,707 - services.mock_data - INFO - Ignore initialize data
2026-05-01 21:34:30,707 - services.auth - INFO - Ignore initialize admin
2026-05-01 21:34:30,708 - main - INFO - === Application startup completed successfully ===
2026-05-01 21:34:41,710 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:34:41,710 - core.database - WARNING - Database session maker not available, attempting lazy initialization...
2026-05-01 21:34:41,710 - core.database - WARNING - Database not initialized, attempting lazy initialization...
2026-05-01 21:34:41,710 - core.database - INFO - Starting database initialization...
2026-05-01 21:34:41,710 - core.config - DEBUG - Read dynamic attribute database_url from environment variable DATABASE_URL
2026-05-01 21:34:41,710 - core.database - INFO - Normalizing database URL for async compatibility...
2026-05-01 21:34:41,711 - core.database - INFO - Creating async database engine...
2026-05-01 21:34:41,712 - core.database - INFO - Using QueuePool with connection pooling for non-Lambda environment
2026-05-01 21:34:41,751 - core.database - INFO - Database engine created successfully
2026-05-01 21:34:41,751 - core.database - INFO - Creating async session maker...
2026-05-01 21:34:41,751 - core.database - INFO - Async session maker created successfully
2026-05-01 21:34:41,751 - core.database - INFO - Database connection initialized successfully
2026-05-01 21:34:41,751 - core.database - DEBUG - [DB_OP] Starting create_tables
2026-05-01 21:34:41,751 - core.database - INFO - 🔧 Starting table creation...
2026-05-01 21:34:44,532 - core.database - INFO - Tables initialized successfully
2026-05-01 21:34:44,532 - core.database - DEBUG - [DB_OP] Create tables completed in 2.7809s
2026-05-01 21:34:44,595 - core.database - INFO - Lazy database initialization completed successfully
2026-05-01 21:34:44,596 - core.database - DEBUG - [DB_OP] Database session created successfully in 2.8859s
2026-05-01 21:34:45,061 - core.database - DEBUG - [DB_OP] Database session cleanup after 3.3512s
2026-05-01 21:34:52,717 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:34:52,718 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 21:34:53,034 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3167s
2026-05-01 21:34:54,996 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:34:54,996 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-05-01 21:34:54,999 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:34:55,000 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-01 21:34:55,000 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 21:34:55,003 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-01 21:34:55,005 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:34:55,005 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-01 21:34:55,005 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 21:34:55,311 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3148s
2026-05-01 21:34:55,729 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 21:34:55,730 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.7306s
2026-05-01 21:34:55,752 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 21:34:55,752 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.7479s
2026-05-01 21:35:42,717 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:35:42,718 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0008s
2026-05-01 21:35:43,041 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3240s
2026-05-01 21:35:53,720 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:35:53,721 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-01 21:35:54,166 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4458s
2026-05-01 21:35:55,706 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:35:55,707 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-01 21:35:56,153 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4469s
2026-05-01 21:36:43,715 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:36:43,715 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 21:36:44,034 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3197s
2026-05-01 21:36:54,709 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:36:54,709 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 21:36:55,060 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3519s
2026-05-01 21:36:58,332 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:36:58,333 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 21:36:58,653 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3209s
2026-05-01 21:37:44,719 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:37:44,720 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0008s
2026-05-01 21:37:45,037 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3180s
2026-05-01 21:37:55,718 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:37:55,719 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 21:37:56,034 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3158s
2026-05-01 21:38:05,439 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:38:05,440 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-01 21:38:05,756 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3172s
2026-05-01 21:38:45,717 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:38:45,718 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 21:38:46,035 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3177s
2026-05-01 21:38:56,719 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:38:56,719 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 21:38:57,036 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3172s
2026-05-01 21:39:05,532 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:39:05,532 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-01 21:39:05,854 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3220s
2026-05-01 21:39:46,713 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:39:46,713 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 21:39:47,154 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4415s
2026-05-01 21:39:55,726 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:39:55,726 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0006s
2026-05-01 21:39:56,053 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3276s
2026-05-01 21:39:57,717 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:39:57,717 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-01 21:39:58,039 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3216s
2026-05-01 21:40:44,613 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:40:44,613 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-01 21:40:44,930 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3169s
2026-05-01 21:40:53,726 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:40:53,726 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 21:40:54,044 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3179s
2026-05-01 21:40:55,860 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:40:55,860 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 21:40:56,304 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4447s
2026-05-01 21:41:21,727 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:41:21,727 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 21:41:22,043 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3168s
2026-05-01 21:41:56,805 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:41:56,805 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-05-01 21:41:57,248 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4429s
2026-05-01 21:42:19,086 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:42:19,087 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-05-01 21:42:19,089 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-01 21:42:19,095 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:42:19,095 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-01 21:42:19,095 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 21:42:19,097 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:42:19,097 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0001s
2026-05-01 21:42:19,097 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 21:42:19,405 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3186s
2026-05-01 21:42:19,474 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 21:42:19,475 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3779s
2026-05-01 21:42:19,604 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 21:42:19,604 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.5093s
2026-05-01 21:42:22,720 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:42:22,720 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 21:42:23,036 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3164s
2026-05-01 21:42:52,176 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:42:52,176 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 21:42:52,178 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-01 21:42:52,180 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:42:52,180 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-05-01 21:42:52,181 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 21:42:52,184 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:42:52,185 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 21:42:52,185 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 21:42:52,494 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3181s
2026-05-01 21:42:52,563 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 21:42:52,563 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3834s
2026-05-01 21:42:52,566 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 21:42:52,566 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3821s
2026-05-01 21:43:14,821 - services.database - DEBUG - [DB_OP] Starting database close
2026-05-01 21:43:15,018 - core.database - INFO - Database connection closed and engine disposed
2026-05-01 21:43:15,019 - services.database - INFO - Database connections closed
2026-05-01 21:43:15,019 - services.database - DEBUG - [DB_OP] Database close completed in 0.1981s