2026-05-01 10:23:32,132 - main - INFO - === Logging system initialized ===
2026-05-01 10:23:32,133 - main - INFO - Log file: logs/app_20260501_102332.log
2026-05-01 10:23:32,133 - main - INFO - Log level: INFO
2026-05-01 10:23:32,133 - main - INFO - Timestamp: 20260501_102332
2026-05-01 10:23:32,209 - main - INFO - Included router: routers.admin_dashboard.router
2026-05-01 10:23:32,266 - main - INFO - Included router: routers.agent_availability.router
2026-05-01 10:23:33,196 - main - INFO - Included router: routers.ai_ticket_summary.router
2026-05-01 10:23:33,222 - main - INFO - Included router: routers.aihub.router
2026-05-01 10:23:33,239 - main - INFO - Included router: routers.auth.router
2026-05-01 10:23:33,296 - main - INFO - Included router: routers.chat_analytics_daily.router
2026-05-01 10:23:33,351 - main - INFO - Included router: routers.chat_attachments.router
2026-05-01 10:23:33,426 - main - INFO - Included router: routers.chat_branding.router
2026-05-01 10:23:33,451 - main - INFO - Included router: routers.chat_branding_api.router
2026-05-01 10:23:33,509 - main - INFO - Included router: routers.chat_conversations.router
2026-05-01 10:23:33,704 - main - INFO - Included router: routers.chat_messages.router
2026-05-01 10:23:33,944 - main - INFO - Included router: routers.chat_routing_rules.router
2026-05-01 10:23:33,969 - main - INFO - Included router: routers.contact.router
2026-05-01 10:23:34,027 - main - INFO - Included router: routers.contact_inquiries.router
2026-05-01 10:23:34,029 - main - INFO - Included router: routers.health.router
2026-05-01 10:23:34,078 - main - INFO - Included router: routers.kb_articles.router
2026-05-01 10:23:34,132 - main - INFO - Included router: routers.notification_preferences.router
2026-05-01 10:23:34,193 - main - INFO - Included router: routers.notifications.router
2026-05-01 10:23:34,264 - main - INFO - Included router: routers.plans.router
2026-05-01 10:23:34,294 - main - INFO - Included router: routers.role_management.router
2026-05-01 10:23:34,322 - main - INFO - Included router: routers.settings.router
2026-05-01 10:23:34,365 - main - INFO - Included router: routers.site_settings.router
2026-05-01 10:23:34,419 - main - INFO - Included router: routers.smtp_settings.router
2026-05-01 10:23:34,464 - main - INFO - Included router: routers.storage.router
2026-05-01 10:23:34,805 - main - INFO - Included router: routers.support_chat.router
2026-05-01 10:23:34,849 - main - INFO - Included router: routers.support_departments.router
2026-05-01 10:23:34,901 - main - INFO - Included router: routers.support_seats.router
2026-05-01 10:23:34,915 - main - INFO - Included router: routers.ticket_notifications_sync.router
2026-05-01 10:23:34,982 - main - INFO - Included router: routers.ticket_summaries.router
2026-05-01 10:23:35,031 - main - INFO - Included router: routers.ticket_sync_states.router
2026-05-01 10:23:35,047 - main - INFO - Included router: routers.user.router
2026-05-01 10:23:35,095 - main - INFO - Included router: routers.user_profiles.router
2026-05-01 10:23:35,140 - main - INFO - Included router: routers.user_roles.router
2026-05-01 10:23:35,251 - main - INFO - Included router: routers.whmcs.router
2026-05-01 10:23:35,329 - main - INFO - Included router: routers.whmcs_admin.router
2026-05-01 10:23:35,379 - main - INFO - Included router: routers.whmcs_extra.router
2026-05-01 10:23:35,381 - main - INFO - === Application startup initiated ===
2026-05-01 10:23:35,382 - services.database - INFO - Ignore creating tables
2026-05-01 10:23:35,382 - services.mock_data - INFO - Ignore initialize data
2026-05-01 10:23:35,383 - services.auth - INFO - Ignore initialize admin
2026-05-01 10:23:35,383 - main - INFO - === Application startup completed successfully ===
2026-05-01 10:24:00,690 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 10:24:00,691 - core.database - WARNING - Database session maker not available, attempting lazy initialization...
2026-05-01 10:24:00,691 - core.database - WARNING - Database not initialized, attempting lazy initialization...
2026-05-01 10:24:00,691 - core.database - INFO - Starting database initialization...
2026-05-01 10:24:00,691 - core.config - DEBUG - Read dynamic attribute database_url from environment variable DATABASE_URL
2026-05-01 10:24:00,692 - core.database - INFO - Normalizing database URL for async compatibility...
2026-05-01 10:24:00,693 - core.database - INFO - Creating async database engine...
2026-05-01 10:24:00,693 - core.database - INFO - Using QueuePool with connection pooling for non-Lambda environment
2026-05-01 10:24:00,779 - core.database - INFO - Database engine created successfully
2026-05-01 10:24:00,780 - core.database - INFO - Creating async session maker...
2026-05-01 10:24:00,780 - core.database - INFO - Async session maker created successfully
2026-05-01 10:24:00,780 - core.database - INFO - Database connection initialized successfully
2026-05-01 10:24:00,780 - core.database - DEBUG - [DB_OP] Starting create_tables
2026-05-01 10:24:00,780 - core.database - INFO - 🔧 Starting table creation...
2026-05-01 10:24:00,790 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 10:24:00,791 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0011s
2026-05-01 10:24:00,791 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 10:24:00,797 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-01 10:24:00,800 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 10:24:00,800 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-05-01 10:24:00,801 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 10:24:02,212 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 10:24:02,213 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.4138s
2026-05-01 10:24:02,214 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 10:24:02,215 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.4255s
2026-05-01 10:24:03,475 - core.database - INFO - Tables initialized successfully
2026-05-01 10:24:03,476 - core.database - DEBUG - [DB_OP] Create tables completed in 2.6956s
2026-05-01 10:24:03,540 - core.database - INFO - Lazy database initialization completed successfully
2026-05-01 10:24:03,541 - core.database - DEBUG - [DB_OP] Database session created successfully in 2.8507s
2026-05-01 10:24:03,991 - core.database - DEBUG - [DB_OP] Database session cleanup after 3.3010s
2026-05-01 10:25:01,615 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 10:25:01,616 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0009s
2026-05-01 10:25:02,066 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4510s
2026-05-01 10:26:01,736 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 10:26:01,737 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-01 10:26:02,187 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4509s
2026-05-01 10:27:00,681 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 10:27:00,682 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0006s
2026-05-01 10:27:01,003 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3217s
2026-05-01 10:27:09,481 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 10:27:09,481 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-01 10:27:09,482 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 10:27:09,485 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-01 10:27:09,486 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 10:27:09,487 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0007s
2026-05-01 10:27:09,489 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 10:27:09,490 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-01 10:27:09,490 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 10:27:09,805 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3185s
2026-05-01 10:27:09,865 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 10:27:09,866 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3850s
2026-05-01 10:27:09,871 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 10:27:09,872 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3826s
2026-05-01 10:27:14,282 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 10:27:14,283 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0011s
2026-05-01 10:27:14,284 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 10:27:14,796 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 10:27:14,797 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.5150s
2026-05-01 10:28:09,491 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 10:28:09,492 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0007s
2026-05-01 10:28:09,812 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3208s
2026-05-01 10:29:09,493 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 10:29:09,494 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0006s
2026-05-01 10:29:09,940 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4473s
2026-05-01 10:30:10,055 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 10:30:10,056 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 10:30:10,377 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3220s
2026-05-01 10:31:25,487 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 10:31:25,488 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0008s
2026-05-01 10:31:25,488 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 10:31:25,492 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-01 10:31:25,493 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 10:31:25,495 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0013s
2026-05-01 10:31:25,495 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 10:31:25,497 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 10:31:25,498 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-01 10:31:25,880 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 10:31:25,881 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3881s
2026-05-01 10:31:25,946 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4491s
2026-05-01 10:31:26,002 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 10:31:26,004 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.5168s
2026-05-01 10:32:20,945 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 10:32:20,946 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0007s
2026-05-01 10:32:20,948 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-01 10:32:20,951 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 10:32:20,951 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-05-01 10:32:20,952 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 10:32:20,957 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 10:32:20,957 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-01 10:32:20,957 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 10:32:21,268 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3226s
2026-05-01 10:32:21,337 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 10:32:21,338 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3873s
2026-05-01 10:32:21,339 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 10:32:21,340 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3829s
2026-05-01 10:32:35,113 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 10:32:35,114 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0009s
2026-05-01 10:32:35,115 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 10:32:35,500 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 10:32:35,501 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3881s
2026-05-01 10:32:40,648 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 10:32:40,648 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0006s
2026-05-01 10:32:40,650 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-01 10:32:40,652 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 10:32:40,653 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0010s
2026-05-01 10:32:40,653 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 10:32:40,656 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 10:32:40,656 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 10:32:40,657 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 10:32:40,984 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3367s
2026-05-01 10:32:41,047 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 10:32:41,048 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3921s
2026-05-01 10:32:41,049 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 10:32:41,050 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3983s
2026-05-01 10:32:45,458 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 10:32:45,459 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-01 10:32:45,460 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 10:32:45,845 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 10:32:45,846 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3881s
2026-05-01 10:33:09,219 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 10:33:09,219 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 10:33:09,221 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-01 10:33:09,225 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 10:33:09,225 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 10:33:09,226 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 10:33:09,227 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 10:33:09,228 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-01 10:33:09,228 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 10:33:09,543 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3245s
2026-05-01 10:33:09,609 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 10:33:09,610 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3823s
2026-05-01 10:33:09,615 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 10:33:09,615 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3908s
2026-05-01 10:33:14,763 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 10:33:14,764 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0008s
2026-05-01 10:33:14,765 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 10:33:15,147 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 10:33:15,148 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3848s
2026-05-01 10:33:47,086 - services.database - DEBUG - [DB_OP] Starting database close
2026-05-01 10:33:47,288 - core.database - INFO - Database connection closed and engine disposed
2026-05-01 10:33:47,289 - services.database - INFO - Database connections closed
2026-05-01 10:33:47,289 - services.database - DEBUG - [DB_OP] Database close completed in 0.2034s