2026-05-01 10:18:25,136 - main - INFO - === Logging system initialized ===
2026-05-01 10:18:25,136 - main - INFO - Log file: logs/app_20260501_101825.log
2026-05-01 10:18:25,136 - main - INFO - Log level: INFO
2026-05-01 10:18:25,137 - main - INFO - Timestamp: 20260501_101825
2026-05-01 10:18:25,224 - main - INFO - Included router: routers.admin_dashboard.router
2026-05-01 10:18:25,272 - main - INFO - Included router: routers.agent_availability.router
2026-05-01 10:18:26,274 - main - INFO - Included router: routers.ai_ticket_summary.router
2026-05-01 10:18:26,301 - main - INFO - Included router: routers.aihub.router
2026-05-01 10:18:26,318 - main - INFO - Included router: routers.auth.router
2026-05-01 10:18:26,372 - main - INFO - Included router: routers.chat_analytics_daily.router
2026-05-01 10:18:26,430 - main - INFO - Included router: routers.chat_attachments.router
2026-05-01 10:18:26,499 - main - INFO - Included router: routers.chat_branding.router
2026-05-01 10:18:26,520 - main - INFO - Included router: routers.chat_branding_api.router
2026-05-01 10:18:26,581 - main - INFO - Included router: routers.chat_conversations.router
2026-05-01 10:18:26,712 - main - INFO - Included router: routers.chat_messages.router
2026-05-01 10:18:26,757 - main - INFO - Included router: routers.chat_routing_rules.router
2026-05-01 10:18:26,782 - main - INFO - Included router: routers.contact.router
2026-05-01 10:18:26,822 - main - INFO - Included router: routers.contact_inquiries.router
2026-05-01 10:18:26,824 - main - INFO - Included router: routers.health.router
2026-05-01 10:18:26,864 - main - INFO - Included router: routers.kb_articles.router
2026-05-01 10:18:26,923 - main - INFO - Included router: routers.notification_preferences.router
2026-05-01 10:18:26,980 - main - INFO - Included router: routers.notifications.router
2026-05-01 10:18:27,040 - main - INFO - Included router: routers.plans.router
2026-05-01 10:18:27,070 - main - INFO - Included router: routers.role_management.router
2026-05-01 10:18:27,094 - main - INFO - Included router: routers.settings.router
2026-05-01 10:18:27,136 - main - INFO - Included router: routers.site_settings.router
2026-05-01 10:18:27,171 - main - INFO - Included router: routers.smtp_settings.router
2026-05-01 10:18:27,207 - main - INFO - Included router: routers.storage.router
2026-05-01 10:18:27,533 - main - INFO - Included router: routers.support_chat.router
2026-05-01 10:18:27,611 - main - INFO - Included router: routers.support_departments.router
2026-05-01 10:18:27,660 - main - INFO - Included router: routers.support_seats.router
2026-05-01 10:18:27,669 - main - INFO - Included router: routers.ticket_notifications_sync.router
2026-05-01 10:18:27,705 - main - INFO - Included router: routers.ticket_summaries.router
2026-05-01 10:18:27,746 - main - INFO - Included router: routers.ticket_sync_states.router
2026-05-01 10:18:27,756 - main - INFO - Included router: routers.user.router
2026-05-01 10:18:27,806 - main - INFO - Included router: routers.user_profiles.router
2026-05-01 10:18:27,844 - main - INFO - Included router: routers.user_roles.router
2026-05-01 10:18:27,953 - main - INFO - Included router: routers.whmcs.router
2026-05-01 10:18:28,027 - main - INFO - Included router: routers.whmcs_admin.router
2026-05-01 10:18:28,088 - main - INFO - Included router: routers.whmcs_extra.router
2026-05-01 10:18:28,090 - main - INFO - === Application startup initiated ===
2026-05-01 10:18:28,091 - services.database - INFO - Ignore creating tables
2026-05-01 10:18:28,091 - services.mock_data - INFO - Ignore initialize data
2026-05-01 10:18:28,091 - services.auth - INFO - Ignore initialize admin
2026-05-01 10:18:28,091 - main - INFO - === Application startup completed successfully ===
2026-05-01 10:18:35,841 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 10:18:35,841 - core.database - WARNING - Database session maker not available, attempting lazy initialization...
2026-05-01 10:18:35,841 - core.database - WARNING - Database not initialized, attempting lazy initialization...
2026-05-01 10:18:35,841 - core.database - INFO - Starting database initialization...
2026-05-01 10:18:35,841 - core.config - DEBUG - Read dynamic attribute database_url from environment variable DATABASE_URL
2026-05-01 10:18:35,841 - core.database - INFO - Normalizing database URL for async compatibility...
2026-05-01 10:18:35,842 - core.database - INFO - Creating async database engine...
2026-05-01 10:18:35,843 - core.database - INFO - Using QueuePool with connection pooling for non-Lambda environment
2026-05-01 10:18:35,894 - core.database - INFO - Database engine created successfully
2026-05-01 10:18:35,895 - core.database - INFO - Creating async session maker...
2026-05-01 10:18:35,895 - core.database - INFO - Async session maker created successfully
2026-05-01 10:18:35,895 - core.database - INFO - Database connection initialized successfully
2026-05-01 10:18:35,895 - core.database - DEBUG - [DB_OP] Starting create_tables
2026-05-01 10:18:35,895 - core.database - INFO - 🔧 Starting table creation...
2026-05-01 10:18:35,901 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-01 10:18:35,907 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 10:18:35,908 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-01 10:18:35,908 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 10:18:35,912 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 10:18:35,912 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-01 10:18:35,912 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 10:18:37,304 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 10:18:37,305 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.3931s
2026-05-01 10:18:37,306 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 10:18:37,306 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.3991s
2026-05-01 10:18:38,590 - core.database - INFO - Tables initialized successfully
2026-05-01 10:18:38,591 - core.database - DEBUG - [DB_OP] Create tables completed in 2.6960s
2026-05-01 10:18:38,655 - core.database - INFO - Lazy database initialization completed successfully
2026-05-01 10:18:38,656 - core.database - DEBUG - [DB_OP] Database session created successfully in 2.8150s
2026-05-01 10:18:39,105 - core.database - DEBUG - [DB_OP] Database session cleanup after 3.2647s
2026-05-01 10:19:36,415 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 10:19:36,416 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-01 10:19:36,862 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4471s
2026-05-01 10:19:47,761 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 10:19:47,761 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0006s
2026-05-01 10:19:47,762 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"login_page"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 10:19:47,763 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 10:19:47,764 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-05-01 10:19:47,764 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 10:19:48,149 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 10:19:48,150 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3864s
2026-05-01 10:19:48,339 - routers.site_settings - DEBUG - Found 1 site_settingss
2026-05-01 10:19:48,340 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.5789s
2026-05-01 10:20:36,389 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 10:20:36,389 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0006s
2026-05-01 10:20:36,710 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3211s
2026-05-01 10:21:47,040 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 10:21:47,041 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0007s
2026-05-01 10:21:47,043 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-01 10:21:47,044 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 10:21:47,044 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-01 10:21:47,044 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 10:21:47,046 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 10:21:47,046 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 10:21:47,047 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 10:21:47,366 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3260s
2026-05-01 10:21:47,432 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 10:21:47,433 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3872s
2026-05-01 10:21:47,434 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 10:21:47,434 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3903s
2026-05-01 10:21:54,167 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 10:21:54,168 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-01 10:21:54,495 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3274s
2026-05-01 10:22:16,217 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 10:22:16,218 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0010s
2026-05-01 10:22:16,219 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 10:22:16,221 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 10:22:16,221 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-05-01 10:22:16,222 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-01 10:22:16,223 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 10:22:16,223 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-01 10:22:16,224 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 10:22:16,602 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 10:22:16,604 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3862s
2026-05-01 10:22:16,605 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3846s
2026-05-01 10:22:16,606 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 10:22:16,606 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3830s
2026-05-01 10:23:13,373 - services.database - DEBUG - [DB_OP] Starting database close
2026-05-01 10:23:13,575 - core.database - INFO - Database connection closed and engine disposed
2026-05-01 10:23:13,575 - services.database - INFO - Database connections closed
2026-05-01 10:23:13,575 - services.database - DEBUG - [DB_OP] Database close completed in 0.2022s