2026-05-01 21:44:27,631 - main - INFO - === Logging system initialized ===
2026-05-01 21:44:27,632 - main - INFO - Log file: logs/app_20260501_214427.log
2026-05-01 21:44:27,632 - main - INFO - Log level: INFO
2026-05-01 21:44:27,632 - main - INFO - Timestamp: 20260501_214427
2026-05-01 21:44:27,712 - main - INFO - Included router: routers.admin_dashboard.router
2026-05-01 21:44:27,755 - main - INFO - Included router: routers.agent_availability.router
2026-05-01 21:44:28,569 - main - INFO - Included router: routers.ai_ticket_summary.router
2026-05-01 21:44:28,590 - main - INFO - Included router: routers.aihub.router
2026-05-01 21:44:28,608 - main - INFO - Included router: routers.auth.router
2026-05-01 21:44:28,667 - main - INFO - Included router: routers.chat_analytics_daily.router
2026-05-01 21:44:28,715 - main - INFO - Included router: routers.chat_attachments.router
2026-05-01 21:44:28,784 - main - INFO - Included router: routers.chat_branding.router
2026-05-01 21:44:28,803 - main - INFO - Included router: routers.chat_branding_api.router
2026-05-01 21:44:28,869 - main - INFO - Included router: routers.chat_conversations.router
2026-05-01 21:44:29,003 - main - INFO - Included router: routers.chat_messages.router
2026-05-01 21:44:29,078 - main - INFO - Included router: routers.chat_routing_rules.router
2026-05-01 21:44:29,105 - main - INFO - Included router: routers.contact.router
2026-05-01 21:44:29,158 - main - INFO - Included router: routers.contact_inquiries.router
2026-05-01 21:44:29,159 - main - INFO - Included router: routers.health.router
2026-05-01 21:44:29,205 - main - INFO - Included router: routers.kb_articles.router
2026-05-01 21:44:29,253 - main - INFO - Included router: routers.notification_preferences.router
2026-05-01 21:44:29,303 - main - INFO - Included router: routers.notifications.router
2026-05-01 21:44:29,313 - main - INFO - Included router: routers.notifications_extras.router
2026-05-01 21:44:29,406 - main - INFO - Included router: routers.oauth.router
2026-05-01 21:44:29,467 - main - INFO - Included router: routers.plans.router
2026-05-01 21:44:29,497 - main - INFO - Included router: routers.role_management.router
2026-05-01 21:44:29,521 - main - INFO - Included router: routers.settings.router
2026-05-01 21:44:29,567 - main - INFO - Included router: routers.site_settings.router
2026-05-01 21:44:29,624 - main - INFO - Included router: routers.smtp_settings.router
2026-05-01 21:44:29,671 - main - INFO - Included router: routers.storage.router
2026-05-01 21:44:29,931 - main - INFO - Included router: routers.support_chat.router
2026-05-01 21:44:29,995 - main - INFO - Included router: routers.support_departments.router
2026-05-01 21:44:30,047 - main - INFO - Included router: routers.support_seats.router
2026-05-01 21:44:30,056 - main - INFO - Included router: routers.ticket_notifications_sync.router
2026-05-01 21:44:30,096 - main - INFO - Included router: routers.ticket_summaries.router
2026-05-01 21:44:30,143 - main - INFO - Included router: routers.ticket_sync_states.router
2026-05-01 21:44:30,154 - main - INFO - Included router: routers.user.router
2026-05-01 21:44:30,204 - main - INFO - Included router: routers.user_profiles.router
2026-05-01 21:44:30,247 - main - INFO - Included router: routers.user_roles.router
2026-05-01 21:44:30,269 - main - INFO - Included router: routers.whmcs.router
2026-05-01 21:44:30,343 - main - INFO - Included router: routers.whmcs_admin.router
2026-05-01 21:44:30,397 - main - INFO - Included router: routers.whmcs_extra.router
2026-05-01 21:44:30,399 - main - INFO - === Application startup initiated ===
2026-05-01 21:44:30,399 - services.database - INFO - Ignore creating tables
2026-05-01 21:44:30,399 - services.mock_data - INFO - Ignore initialize data
2026-05-01 21:44:30,400 - services.auth - INFO - Ignore initialize admin
2026-05-01 21:44:30,400 - main - INFO - === Application startup completed successfully ===
2026-05-01 21:44:39,063 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:44:39,063 - core.database - WARNING - Database session maker not available, attempting lazy initialization...
2026-05-01 21:44:39,063 - core.database - WARNING - Database not initialized, attempting lazy initialization...
2026-05-01 21:44:39,063 - core.database - INFO - Starting database initialization...
2026-05-01 21:44:39,064 - core.config - DEBUG - Read dynamic attribute database_url from environment variable DATABASE_URL
2026-05-01 21:44:39,064 - core.database - INFO - Normalizing database URL for async compatibility...
2026-05-01 21:44:39,064 - core.database - INFO - Creating async database engine...
2026-05-01 21:44:39,065 - core.database - INFO - Using QueuePool with connection pooling for non-Lambda environment
2026-05-01 21:44:39,107 - core.database - INFO - Database engine created successfully
2026-05-01 21:44:39,107 - core.database - INFO - Creating async session maker...
2026-05-01 21:44:39,107 - core.database - INFO - Async session maker created successfully
2026-05-01 21:44:39,108 - core.database - INFO - Database connection initialized successfully
2026-05-01 21:44:39,108 - core.database - DEBUG - [DB_OP] Starting create_tables
2026-05-01 21:44:39,108 - core.database - INFO - 🔧 Starting table creation...
2026-05-01 21:44:39,113 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:44:39,114 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-05-01 21:44:39,117 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:44:39,117 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-05-01 21:44:39,118 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 21:44:39,122 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-01 21:44:40,435 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.3215s
2026-05-01 21:44:40,563 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 21:44:40,564 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.4469s
2026-05-01 21:44:41,988 - core.database - INFO - Tables initialized successfully
2026-05-01 21:44:41,988 - core.database - DEBUG - [DB_OP] Create tables completed in 2.8808s
2026-05-01 21:44:42,052 - core.database - INFO - Lazy database initialization completed successfully
2026-05-01 21:44:42,052 - core.database - DEBUG - [DB_OP] Database session created successfully in 2.9893s
2026-05-01 21:44:42,053 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 21:44:42,621 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 21:44:42,622 - core.database - DEBUG - [DB_OP] Database session cleanup after 3.5592s
2026-05-01 21:45:22,713 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:45:22,713 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0007s
2026-05-01 21:45:23,164 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4511s
2026-05-01 21:45:39,071 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:45:39,071 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-05-01 21:45:39,515 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4446s
2026-05-01 21:46:04,821 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:46:04,821 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 21:46:04,822 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-01 21:46:04,823 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:46:04,823 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-01 21:46:04,823 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 21:46:04,825 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:46:04,825 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-01 21:46:04,825 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 21:46:05,140 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3192s
2026-05-01 21:46:05,208 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 21:46:05,208 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3855s
2026-05-01 21:46:05,333 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 21:46:05,334 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.5092s
2026-05-01 21:46:23,724 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:46:23,725 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 21:46:24,045 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3204s
2026-05-01 21:47:04,832 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:47:04,832 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-01 21:47:05,155 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3231s
2026-05-01 21:47:15,101 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:47:15,101 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 21:47:15,102 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 21:47:15,104 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:47:15,104 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-01 21:47:15,105 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-01 21:47:15,106 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:47:15,106 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0001s
2026-05-01 21:47:15,107 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 21:47:15,483 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 21:47:15,484 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3832s
2026-05-01 21:47:15,489 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 21:47:15,490 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3835s
2026-05-01 21:47:15,700 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.5959s
2026-05-01 21:48:05,717 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:48:05,718 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-01 21:48:06,043 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3258s
2026-05-01 21:48:15,114 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:48:15,115 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 21:48:15,437 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3229s
2026-05-01 21:49:14,519 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:49:14,520 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 21:49:14,522 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:49:14,522 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-01 21:49:14,523 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 21:49:14,525 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-01 21:49:14,527 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:49:14,527 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-05-01 21:49:14,528 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 21:49:14,839 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3194s
2026-05-01 21:49:14,904 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 21:49:14,904 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3826s
2026-05-01 21:49:14,912 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 21:49:14,913 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3855s
2026-05-01 21:49:15,713 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:49:15,713 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-05-01 21:49:16,030 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3175s
2026-05-01 21:49:33,942 - services.database - DEBUG - [DB_OP] Starting database close
2026-05-01 21:49:34,142 - core.database - INFO - Database connection closed and engine disposed
2026-05-01 21:49:34,142 - services.database - INFO - Database connections closed
2026-05-01 21:49:34,143 - services.database - DEBUG - [DB_OP] Database close completed in 0.2002s