2026-04-30 13:40:22,249 - main - INFO - === Logging system initialized ===
2026-04-30 13:40:22,249 - main - INFO - Log file: logs/app_20260430_134022.log
2026-04-30 13:40:22,250 - main - INFO - Log level: INFO
2026-04-30 13:40:22,251 - main - INFO - Timestamp: 20260430_134022
2026-04-30 13:40:22,349 - main - INFO - Included router: routers.admin_dashboard.router
2026-04-30 13:40:22,403 - main - INFO - Included router: routers.agent_availability.router
2026-04-30 13:40:23,572 - main - INFO - Included router: routers.ai_ticket_summary.router
2026-04-30 13:40:23,599 - main - INFO - Included router: routers.aihub.router
2026-04-30 13:40:23,615 - main - INFO - Included router: routers.auth.router
2026-04-30 13:40:23,668 - main - INFO - Included router: routers.chat_analytics_daily.router
2026-04-30 13:40:23,716 - main - INFO - Included router: routers.chat_attachments.router
2026-04-30 13:40:23,788 - main - INFO - Included router: routers.chat_branding.router
2026-04-30 13:40:23,804 - main - INFO - Included router: routers.chat_branding_api.router
2026-04-30 13:40:23,861 - main - INFO - Included router: routers.chat_conversations.router
2026-04-30 13:40:24,041 - main - INFO - Included router: routers.chat_messages.router
2026-04-30 13:40:24,087 - main - INFO - Included router: routers.chat_routing_rules.router
2026-04-30 13:40:24,107 - main - INFO - Included router: routers.contact.router
2026-04-30 13:40:24,149 - main - INFO - Included router: routers.contact_inquiries.router
2026-04-30 13:40:24,155 - main - INFO - Included router: routers.health.router
2026-04-30 13:40:24,205 - main - INFO - Included router: routers.kb_articles.router
2026-04-30 13:40:24,254 - main - INFO - Included router: routers.notification_preferences.router
2026-04-30 13:40:24,308 - main - INFO - Included router: routers.notifications.router
2026-04-30 13:40:24,369 - main - INFO - Included router: routers.plans.router
2026-04-30 13:40:24,552 - main - INFO - Included router: routers.settings.router
2026-04-30 13:40:24,595 - main - INFO - Included router: routers.site_settings.router
2026-04-30 13:40:24,635 - main - INFO - Included router: routers.smtp_settings.router
2026-04-30 13:40:24,674 - main - INFO - Included router: routers.storage.router
2026-04-30 13:40:24,882 - main - INFO - Included router: routers.support_chat.router
2026-04-30 13:40:25,045 - main - INFO - Included router: routers.support_departments.router
2026-04-30 13:40:25,085 - main - INFO - Included router: routers.support_seats.router
2026-04-30 13:40:25,094 - main - INFO - Included router: routers.ticket_notifications_sync.router
2026-04-30 13:40:25,134 - main - INFO - Included router: routers.ticket_summaries.router
2026-04-30 13:40:25,173 - main - INFO - Included router: routers.ticket_sync_states.router
2026-04-30 13:40:25,180 - main - INFO - Included router: routers.user.router
2026-04-30 13:40:25,221 - main - INFO - Included router: routers.user_profiles.router
2026-04-30 13:40:25,261 - main - INFO - Included router: routers.user_roles.router
2026-04-30 13:40:25,339 - main - INFO - Included router: routers.whmcs.router
2026-04-30 13:40:25,402 - main - INFO - Included router: routers.whmcs_admin.router
2026-04-30 13:40:25,441 - main - INFO - Included router: routers.whmcs_extra.router
2026-04-30 13:40:25,443 - main - INFO - === Application startup initiated ===
2026-04-30 13:40:25,443 - services.database - INFO - Ignore creating tables
2026-04-30 13:40:25,443 - services.mock_data - INFO - Ignore initialize data
2026-04-30 13:40:25,443 - services.auth - INFO - Ignore initialize admin
2026-04-30 13:40:25,443 - main - INFO - === Application startup completed successfully ===
2026-04-30 13:40:33,083 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:40:33,084 - core.database - WARNING - Database session maker not available, attempting lazy initialization...
2026-04-30 13:40:33,084 - core.database - WARNING - Database not initialized, attempting lazy initialization...
2026-04-30 13:40:33,084 - core.database - INFO - Starting database initialization...
2026-04-30 13:40:33,085 - core.config - DEBUG - Read dynamic attribute database_url from environment variable DATABASE_URL
2026-04-30 13:40:33,085 - core.database - INFO - Normalizing database URL for async compatibility...
2026-04-30 13:40:33,088 - core.database - INFO - Creating async database engine...
2026-04-30 13:40:33,088 - core.database - INFO - Using QueuePool with connection pooling for non-Lambda environment
2026-04-30 13:40:33,144 - core.database - INFO - Database engine created successfully
2026-04-30 13:40:33,144 - core.database - INFO - Creating async session maker...
2026-04-30 13:40:33,144 - core.database - INFO - Async session maker created successfully
2026-04-30 13:40:33,145 - core.database - INFO - Database connection initialized successfully
2026-04-30 13:40:33,145 - core.database - DEBUG - [DB_OP] Starting create_tables
2026-04-30 13:40:33,145 - core.database - INFO - 🔧 Starting table creation...
2026-04-30 13:40:33,150 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:40:33,150 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-04-30 13:40:33,151 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-04-30 13:40:33,157 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-04-30 13:40:33,160 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:40:33,160 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-04-30 13:40:34,374 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.2136s
2026-04-30 13:40:34,513 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-04-30 13:40:34,514 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.3643s
2026-04-30 13:40:35,692 - core.database - INFO - Tables initialized successfully
2026-04-30 13:40:35,693 - core.database - DEBUG - [DB_OP] Create tables completed in 2.5482s
2026-04-30 13:40:35,754 - core.database - INFO - Lazy database initialization completed successfully
2026-04-30 13:40:35,754 - core.database - DEBUG - [DB_OP] Database session created successfully in 2.6714s
2026-04-30 13:40:35,755 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-04-30 13:40:36,323 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-04-30 13:40:36,324 - core.database - DEBUG - [DB_OP] Database session cleanup after 3.2411s
2026-04-30 13:40:43,477 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/whmcs/me
2026-04-30 13:40:43,478 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-04-30 13:40:43,479 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:40:43,479 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-04-30 13:40:43,479 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-04-30 13:40:43,482 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:40:43,482 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-04-30 13:40:43,483 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:40:43,483 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-04-30 13:40:43,484 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-04-30 13:40:43,863 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-04-30 13:40:43,864 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3809s
2026-04-30 13:40:43,906 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4248s
2026-04-30 13:40:43,941 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-04-30 13:40:43,941 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4624s
2026-04-30 13:40:53,779 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:40:53,780 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0008s
2026-04-30 13:40:53,781 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-04-30 13:40:53,783 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:40:53,783 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-04-30 13:40:53,784 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-04-30 13:40:53,785 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-04-30 13:40:53,786 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:40:53,787 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0014s
2026-04-30 13:40:54,159 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-04-30 13:40:54,160 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3804s
2026-04-30 13:40:54,181 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3953s
2026-04-30 13:40:54,270 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-04-30 13:40:54,270 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4874s
2026-04-30 13:41:00,978 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:41:00,979 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-04-30 13:41:00,980 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-04-30 13:41:00,982 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:41:00,982 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-04-30 13:41:00,983 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-04-30 13:41:00,984 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:41:00,985 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-04-30 13:41:00,985 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-04-30 13:41:01,295 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3164s
2026-04-30 13:41:01,350 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-04-30 13:41:01,351 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3664s
2026-04-30 13:41:01,376 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-04-30 13:41:01,377 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3950s
2026-04-30 13:41:03,224 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:41:03,225 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-04-30 13:41:03,225 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-04-30 13:41:03,607 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-04-30 13:41:03,607 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3830s
2026-04-30 13:41:12,108 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:41:12,108 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-04-30 13:41:12,108 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"login_page"}, sort=None, skip=0, limit=1, fields=None
2026-04-30 13:41:12,110 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:41:12,110 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-04-30 13:41:12,110 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-04-30 13:41:12,476 - routers.site_settings - DEBUG - Found 1 site_settingss
2026-04-30 13:41:12,477 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3697s
2026-04-30 13:41:12,504 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-04-30 13:41:12,505 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3947s
2026-04-30 13:41:18,026 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:41:18,027 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-04-30 13:41:18,027 - routers.site_settings - DEBUG - Updating site_settings 1 with data: key='login_page' value_json='{"layout":"classic","welcomeTitle":"Welcome back to DoItEasy","welcomeSubtitle":"Manage hosting, VPS, domains and tickets from one premium dashboard.","backgroundUrl":"/assets/images/image-1.png","backgroundVideoUrl":"/assets/hero-servers-data.mp4","showSocialLogin":true,"showRememberMe":true,"showForgotPassword":true,"ctaLabel":"Sign In"}'
2026-04-30 13:41:18,969 - services.site_settings - INFO - Updated site_settings 1
2026-04-30 13:41:18,969 - routers.site_settings - INFO - Site_settings 1 updated successfully
2026-04-30 13:41:18,970 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.9434s
2026-04-30 13:41:29,109 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:41:29,110 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-04-30 13:41:29,111 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-04-30 13:41:29,112 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:41:29,113 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-04-30 13:41:29,114 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-04-30 13:41:29,115 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:41:29,116 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-04-30 13:41:29,116 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-04-30 13:41:29,437 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3279s
2026-04-30 13:41:29,481 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-04-30 13:41:29,482 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3666s
2026-04-30 13:41:29,490 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-04-30 13:41:29,491 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3785s
2026-04-30 13:42:29,759 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:42:29,759 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0006s
2026-04-30 13:42:30,091 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3322s
2026-04-30 13:43:29,743 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:43:29,744 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0006s
2026-04-30 13:43:30,051 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3072s
2026-04-30 13:44:29,738 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:44:29,738 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-04-30 13:44:30,058 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3204s
2026-04-30 13:45:16,353 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-04-30 13:45:16,358 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:45:16,359 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-04-30 13:45:16,359 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-04-30 13:45:16,361 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:45:16,361 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-04-30 13:45:16,362 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-04-30 13:45:16,393 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:45:16,395 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0019s
2026-04-30 13:45:16,715 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3223s
2026-04-30 13:45:16,728 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-04-30 13:45:16,729 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3677s
2026-04-30 13:45:16,754 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-04-30 13:45:16,754 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3958s
2026-04-30 13:46:16,744 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:46:16,745 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-04-30 13:46:17,187 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4429s
2026-04-30 13:47:32,856 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:47:32,856 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-04-30 13:47:33,281 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4258s
2026-04-30 13:48:34,835 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:48:34,836 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0009s
2026-04-30 13:48:35,298 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4623s
2026-04-30 13:49:59,853 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:49:59,854 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-04-30 13:50:00,172 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3189s
2026-04-30 13:51:32,757 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:51:32,758 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0006s
2026-04-30 13:51:33,064 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3068s
2026-04-30 13:52:16,754 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-04-30 13:52:16,755 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-04-30 13:52:17,083 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3285s
2026-04-30 13:55:07,803 - services.database - DEBUG - [DB_OP] Starting database close
2026-04-30 13:55:08,001 - core.database - INFO - Database connection closed and engine disposed
2026-04-30 13:55:08,001 - services.database - INFO - Database connections closed
2026-04-30 13:55:08,001 - services.database - DEBUG - [DB_OP] Database close completed in 0.1986s