2026-05-01 10:33:57,742 - main - INFO - === Logging system initialized ===
2026-05-01 10:33:57,742 - main - INFO - Log file: logs/app_20260501_103357.log
2026-05-01 10:33:57,742 - main - INFO - Log level: INFO
2026-05-01 10:33:57,742 - main - INFO - Timestamp: 20260501_103357
2026-05-01 10:33:57,831 - main - INFO - Included router: routers.admin_dashboard.router
2026-05-01 10:33:57,878 - main - INFO - Included router: routers.agent_availability.router
2026-05-01 10:33:58,861 - main - INFO - Included router: routers.ai_ticket_summary.router
2026-05-01 10:33:58,889 - main - INFO - Included router: routers.aihub.router
2026-05-01 10:33:58,907 - main - INFO - Included router: routers.auth.router
2026-05-01 10:33:58,967 - main - INFO - Included router: routers.chat_analytics_daily.router
2026-05-01 10:33:59,023 - main - INFO - Included router: routers.chat_attachments.router
2026-05-01 10:33:59,117 - main - INFO - Included router: routers.chat_branding.router
2026-05-01 10:33:59,135 - main - INFO - Included router: routers.chat_branding_api.router
2026-05-01 10:33:59,195 - main - INFO - Included router: routers.chat_conversations.router
2026-05-01 10:33:59,349 - main - INFO - Included router: routers.chat_messages.router
2026-05-01 10:33:59,411 - main - INFO - Included router: routers.chat_routing_rules.router
2026-05-01 10:33:59,438 - main - INFO - Included router: routers.contact.router
2026-05-01 10:33:59,495 - main - INFO - Included router: routers.contact_inquiries.router
2026-05-01 10:33:59,499 - main - INFO - Included router: routers.health.router
2026-05-01 10:33:59,553 - main - INFO - Included router: routers.kb_articles.router
2026-05-01 10:33:59,614 - main - INFO - Included router: routers.notification_preferences.router
2026-05-01 10:33:59,675 - main - INFO - Included router: routers.notifications.router
2026-05-01 10:33:59,737 - main - INFO - Included router: routers.plans.router
2026-05-01 10:33:59,764 - main - INFO - Included router: routers.role_management.router
2026-05-01 10:33:59,794 - main - INFO - Included router: routers.settings.router
2026-05-01 10:33:59,841 - main - INFO - Included router: routers.site_settings.router
2026-05-01 10:33:59,879 - main - INFO - Included router: routers.smtp_settings.router
2026-05-01 10:33:59,929 - main - INFO - Included router: routers.storage.router
2026-05-01 10:34:00,249 - main - INFO - Included router: routers.support_chat.router
2026-05-01 10:34:00,317 - main - INFO - Included router: routers.support_departments.router
2026-05-01 10:34:00,364 - main - INFO - Included router: routers.support_seats.router
2026-05-01 10:34:00,372 - main - INFO - Included router: routers.ticket_notifications_sync.router
2026-05-01 10:34:00,410 - main - INFO - Included router: routers.ticket_summaries.router
2026-05-01 10:34:00,464 - main - INFO - Included router: routers.ticket_sync_states.router
2026-05-01 10:34:00,475 - main - INFO - Included router: routers.user.router
2026-05-01 10:34:00,522 - main - INFO - Included router: routers.user_profiles.router
2026-05-01 10:34:00,562 - main - INFO - Included router: routers.user_roles.router
2026-05-01 10:34:00,660 - main - INFO - Included router: routers.whmcs.router
2026-05-01 10:34:00,720 - main - INFO - Included router: routers.whmcs_admin.router
2026-05-01 10:34:00,769 - main - INFO - Included router: routers.whmcs_extra.router
2026-05-01 10:34:00,771 - main - INFO - === Application startup initiated ===
2026-05-01 10:34:00,771 - services.database - INFO - Ignore creating tables
2026-05-01 10:34:00,771 - services.mock_data - INFO - Ignore initialize data
2026-05-01 10:34:00,771 - services.auth - INFO - Ignore initialize admin
2026-05-01 10:34:00,771 - main - INFO - === Application startup completed successfully ===
2026-05-01 10:34:09,474 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 10:34:09,474 - core.database - WARNING - Database session maker not available, attempting lazy initialization...
2026-05-01 10:34:09,475 - core.database - WARNING - Database not initialized, attempting lazy initialization...
2026-05-01 10:34:09,475 - core.database - INFO - Starting database initialization...
2026-05-01 10:34:09,475 - core.config - DEBUG - Read dynamic attribute database_url from environment variable DATABASE_URL
2026-05-01 10:34:09,476 - core.database - INFO - Normalizing database URL for async compatibility...
2026-05-01 10:34:09,478 - core.database - INFO - Creating async database engine...
2026-05-01 10:34:09,479 - core.database - INFO - Using QueuePool with connection pooling for non-Lambda environment
2026-05-01 10:34:09,529 - core.database - INFO - Database engine created successfully
2026-05-01 10:34:09,530 - core.database - INFO - Creating async session maker...
2026-05-01 10:34:09,530 - core.database - INFO - Async session maker created successfully
2026-05-01 10:34:09,530 - core.database - INFO - Database connection initialized successfully
2026-05-01 10:34:09,531 - core.database - DEBUG - [DB_OP] Starting create_tables
2026-05-01 10:34:09,532 - core.database - INFO - 🔧 Starting table creation...
2026-05-01 10:34:09,538 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-01 10:34:09,544 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 10:34:09,544 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-05-01 10:34:09,545 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 10:34:09,548 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 10:34:09,549 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 10:34:09,549 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 10:34:10,934 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 10:34:10,935 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.3912s
2026-05-01 10:34:10,937 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 10:34:10,938 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.3901s
2026-05-01 10:34:12,215 - core.database - INFO - Tables initialized successfully
2026-05-01 10:34:12,216 - core.database - DEBUG - [DB_OP] Create tables completed in 2.6847s
2026-05-01 10:34:12,280 - core.database - INFO - Lazy database initialization completed successfully
2026-05-01 10:34:12,280 - core.database - DEBUG - [DB_OP] Database session created successfully in 2.8064s
2026-05-01 10:34:12,725 - core.database - DEBUG - [DB_OP] Database session cleanup after 3.2509s
2026-05-01 10:35:09,451 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 10:35:09,452 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0007s
2026-05-01 10:35:09,897 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4459s
2026-05-01 10:36:09,458 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 10:36:09,458 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-01 10:36:09,906 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4489s
2026-05-01 10:37:09,452 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 10:37:09,453 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0006s
2026-05-01 10:37:09,770 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3177s
2026-05-01 10:38:09,451 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 10:38:09,452 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-01 10:38:09,775 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3236s
2026-05-01 10:39:09,465 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 10:39:09,466 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0007s
2026-05-01 10:39:09,786 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3209s
2026-05-01 10:40:09,454 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 10:40:09,455 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0006s
2026-05-01 10:40:09,899 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4445s
2026-05-01 10:41:09,451 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 10:41:09,452 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0006s
2026-05-01 10:41:09,897 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4458s
2026-05-01 10:42:09,462 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 10:42:09,462 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-01 10:42:09,908 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4463s
2026-05-01 10:43:09,469 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 10:43:09,470 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0007s
2026-05-01 10:43:09,787 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3181s
2026-05-01 10:44:09,455 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 10:44:09,455 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0006s
2026-05-01 10:44:09,774 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3197s
2026-05-01 10:45:09,473 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 10:45:09,474 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0010s
2026-05-01 10:45:09,795 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3216s
2026-05-01 10:46:09,452 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 10:46:09,453 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0007s
2026-05-01 10:46:09,896 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4434s
2026-05-01 10:47:09,789 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 10:47:09,789 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0006s
2026-05-01 10:47:10,236 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4471s
2026-05-01 10:49:02,283 - services.database - DEBUG - [DB_OP] Starting database close
2026-05-01 10:49:02,485 - core.database - INFO - Database connection closed and engine disposed
2026-05-01 10:49:02,485 - services.database - INFO - Database connections closed
2026-05-01 10:49:02,485 - services.database - DEBUG - [DB_OP] Database close completed in 0.2023s