2026-05-01 21:18:41,592 - main - INFO - === Logging system initialized ===
2026-05-01 21:18:41,592 - main - INFO - Log file: logs/app_20260501_211841.log
2026-05-01 21:18:41,592 - main - INFO - Log level: INFO
2026-05-01 21:18:41,592 - main - INFO - Timestamp: 20260501_211841
2026-05-01 21:18:41,649 - main - INFO - Included router: routers.admin_dashboard.router
2026-05-01 21:18:41,692 - main - INFO - Included router: routers.agent_availability.router
2026-05-01 21:18:42,418 - main - INFO - Included router: routers.ai_ticket_summary.router
2026-05-01 21:18:42,438 - main - INFO - Included router: routers.aihub.router
2026-05-01 21:18:42,451 - main - INFO - Included router: routers.auth.router
2026-05-01 21:18:42,499 - main - INFO - Included router: routers.chat_analytics_daily.router
2026-05-01 21:18:42,542 - main - INFO - Included router: routers.chat_attachments.router
2026-05-01 21:18:42,601 - main - INFO - Included router: routers.chat_branding.router
2026-05-01 21:18:42,617 - main - INFO - Included router: routers.chat_branding_api.router
2026-05-01 21:18:42,667 - main - INFO - Included router: routers.chat_conversations.router
2026-05-01 21:18:42,786 - main - INFO - Included router: routers.chat_messages.router
2026-05-01 21:18:42,827 - main - INFO - Included router: routers.chat_routing_rules.router
2026-05-01 21:18:42,846 - main - INFO - Included router: routers.contact.router
2026-05-01 21:18:42,884 - main - INFO - Included router: routers.contact_inquiries.router
2026-05-01 21:18:42,885 - main - INFO - Included router: routers.health.router
2026-05-01 21:18:42,925 - main - INFO - Included router: routers.kb_articles.router
2026-05-01 21:18:42,969 - main - INFO - Included router: routers.notification_preferences.router
2026-05-01 21:18:43,012 - main - INFO - Included router: routers.notifications.router
2026-05-01 21:18:43,034 - main - INFO - Included router: routers.notifications_extras.router
2026-05-01 21:18:43,113 - main - INFO - Included router: routers.oauth.router
2026-05-01 21:18:43,162 - main - INFO - Included router: routers.plans.router
2026-05-01 21:18:43,186 - main - INFO - Included router: routers.role_management.router
2026-05-01 21:18:43,204 - main - INFO - Included router: routers.settings.router
2026-05-01 21:18:43,246 - main - INFO - Included router: routers.site_settings.router
2026-05-01 21:18:43,282 - main - INFO - Included router: routers.smtp_settings.router
2026-05-01 21:18:43,318 - main - INFO - Included router: routers.storage.router
2026-05-01 21:18:43,527 - main - INFO - Included router: routers.support_chat.router
2026-05-01 21:18:43,577 - main - INFO - Included router: routers.support_departments.router
2026-05-01 21:18:43,618 - main - INFO - Included router: routers.support_seats.router
2026-05-01 21:18:43,626 - main - INFO - Included router: routers.ticket_notifications_sync.router
2026-05-01 21:18:43,666 - main - INFO - Included router: routers.ticket_summaries.router
2026-05-01 21:18:43,706 - main - INFO - Included router: routers.ticket_sync_states.router
2026-05-01 21:18:43,714 - main - INFO - Included router: routers.user.router
2026-05-01 21:18:43,757 - main - INFO - Included router: routers.user_profiles.router
2026-05-01 21:18:43,793 - main - INFO - Included router: routers.user_roles.router
2026-05-01 21:18:43,813 - main - INFO - Included router: routers.whmcs.router
2026-05-01 21:18:43,878 - main - INFO - Included router: routers.whmcs_admin.router
2026-05-01 21:18:43,919 - main - INFO - Included router: routers.whmcs_extra.router
2026-05-01 21:18:43,921 - main - INFO - === Application startup initiated ===
2026-05-01 21:18:43,921 - services.database - INFO - Ignore creating tables
2026-05-01 21:18:43,921 - services.mock_data - INFO - Ignore initialize data
2026-05-01 21:18:43,921 - services.auth - INFO - Ignore initialize admin
2026-05-01 21:18:43,921 - main - INFO - === Application startup completed successfully ===
2026-05-01 21:18:51,656 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-01 21:18:51,659 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:18:51,660 - core.database - WARNING - Database session maker not available, attempting lazy initialization...
2026-05-01 21:18:51,660 - core.database - WARNING - Database not initialized, attempting lazy initialization...
2026-05-01 21:18:51,660 - core.database - INFO - Starting database initialization...
2026-05-01 21:18:51,660 - core.config - DEBUG - Read dynamic attribute database_url from environment variable DATABASE_URL
2026-05-01 21:18:51,660 - core.database - INFO - Normalizing database URL for async compatibility...
2026-05-01 21:18:51,661 - core.database - INFO - Creating async database engine...
2026-05-01 21:18:51,662 - core.database - INFO - Using QueuePool with connection pooling for non-Lambda environment
2026-05-01 21:18:51,716 - core.database - INFO - Database engine created successfully
2026-05-01 21:18:51,716 - core.database - INFO - Creating async session maker...
2026-05-01 21:18:51,716 - core.database - INFO - Async session maker created successfully
2026-05-01 21:18:51,716 - core.database - INFO - Database connection initialized successfully
2026-05-01 21:18:51,716 - core.database - DEBUG - [DB_OP] Starting create_tables
2026-05-01 21:18:51,716 - core.database - INFO - 🔧 Starting table creation...
2026-05-01 21:18:51,722 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:18:51,722 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-01 21:18:51,726 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:18:51,726 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-05-01 21:18:51,726 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 21:18:53,007 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.2853s
2026-05-01 21:18:53,139 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 21:18:53,140 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.4144s
2026-05-01 21:18:54,547 - core.database - INFO - Tables initialized successfully
2026-05-01 21:18:54,547 - core.database - DEBUG - [DB_OP] Create tables completed in 2.8309s
2026-05-01 21:18:54,610 - core.database - INFO - Lazy database initialization completed successfully
2026-05-01 21:18:54,611 - core.database - DEBUG - [DB_OP] Database session created successfully in 2.9514s
2026-05-01 21:18:54,611 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 21:18:55,192 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 21:18:55,192 - core.database - DEBUG - [DB_OP] Database session cleanup after 3.5332s
2026-05-01 21:19:26,710 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:19:26,711 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 21:19:27,156 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4453s
2026-05-01 21:19:37,708 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:19:37,709 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0009s
2026-05-01 21:19:38,155 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4468s
2026-05-01 21:19:51,658 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:19:51,659 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0007s
2026-05-01 21:19:51,978 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3202s
2026-05-01 21:20:27,717 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:20:27,718 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-01 21:20:28,035 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3172s
2026-05-01 21:20:38,712 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:20:38,712 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0008s
2026-05-01 21:20:39,030 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3182s
2026-05-01 21:20:51,676 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:20:51,676 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 21:20:51,995 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3187s
2026-05-01 21:21:28,715 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:21:28,716 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0006s
2026-05-01 21:21:29,034 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3184s
2026-05-01 21:21:39,703 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:21:39,704 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-01 21:21:40,023 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3201s
2026-05-01 21:21:46,108 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:21:46,109 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-05-01 21:21:46,110 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-01 21:21:46,116 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:21:46,116 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-05-01 21:21:46,116 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 21:21:46,122 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:21:46,122 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 21:21:46,123 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 21:21:46,429 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3203s
2026-05-01 21:21:46,496 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 21:21:46,497 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3812s
2026-05-01 21:21:46,629 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 21:21:46,631 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.5088s
2026-05-01 21:21:48,119 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:21:48,120 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-01 21:21:48,120 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 21:21:48,121 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:21:48,122 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-01 21:21:48,122 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-01 21:21:48,123 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:21:48,123 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-01 21:21:48,124 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 21:21:48,437 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3158s
2026-05-01 21:21:48,502 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 21:21:48,503 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3837s
2026-05-01 21:21:48,518 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 21:21:48,519 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3960s
2026-05-01 21:22:21,133 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-01 21:22:21,135 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:22:21,135 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-01 21:22:21,135 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 21:22:21,137 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:22:21,137 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-01 21:22:21,138 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:22:21,138 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-01 21:22:21,139 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 21:22:21,455 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3181s
2026-05-01 21:22:21,517 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 21:22:21,518 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3835s
2026-05-01 21:22:21,519 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 21:22:21,519 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3811s
2026-05-01 21:22:29,796 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:22:29,796 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0006s
2026-05-01 21:22:30,115 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3191s
2026-05-01 21:22:40,706 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:22:40,706 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 21:22:41,023 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3169s
2026-05-01 21:22:47,265 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-01 21:22:47,266 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:22:47,266 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-05-01 21:22:47,268 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:22:47,269 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-01 21:22:47,269 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 21:22:47,270 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:22:47,270 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-01 21:22:47,271 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 21:22:47,586 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3203s
2026-05-01 21:22:47,652 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 21:22:47,653 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3829s
2026-05-01 21:22:47,653 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 21:22:47,654 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3852s
2026-05-01 21:22:50,030 - services.database - DEBUG - [DB_OP] Starting database close
2026-05-01 21:22:50,233 - core.database - INFO - Database connection closed and engine disposed
2026-05-01 21:22:50,234 - services.database - INFO - Database connections closed
2026-05-01 21:22:50,234 - services.database - DEBUG - [DB_OP] Database close completed in 0.2039s