2026-05-02 08:03:34,741 - main - INFO - === Logging system initialized ===
2026-05-02 08:03:34,741 - main - INFO - Log file: logs/app_20260502_080334.log
2026-05-02 08:03:34,741 - main - INFO - Log level: INFO
2026-05-02 08:03:34,741 - main - INFO - Timestamp: 20260502_080334
2026-05-02 08:03:34,822 - main - INFO - Included router: routers.admin_dashboard.router
2026-05-02 08:03:34,871 - main - INFO - Included router: routers.agent_availability.router
2026-05-02 08:03:36,121 - main - INFO - Included router: routers.ai_ticket_summary.router
2026-05-02 08:03:36,151 - main - INFO - Included router: routers.aihub.router
2026-05-02 08:03:36,169 - main - INFO - Included router: routers.auth.router
2026-05-02 08:03:36,438 - main - INFO - Included router: routers.carts.router
2026-05-02 08:03:36,492 - main - INFO - Included router: routers.chat_analytics_daily.router
2026-05-02 08:03:36,550 - main - INFO - Included router: routers.chat_attachments.router
2026-05-02 08:03:36,638 - main - INFO - Included router: routers.chat_branding.router
2026-05-02 08:03:36,656 - main - INFO - Included router: routers.chat_branding_api.router
2026-05-02 08:03:36,802 - main - INFO - Included router: routers.chat_conversations.router
2026-05-02 08:03:36,851 - main - INFO - Included router: routers.chat_messages.router
2026-05-02 08:03:36,900 - main - INFO - Included router: routers.chat_routing_rules.router
2026-05-02 08:03:36,929 - main - INFO - Included router: routers.contact.router
2026-05-02 08:03:36,973 - main - INFO - Included router: routers.contact_inquiries.router
2026-05-02 08:03:38,077 - main - INFO - Included router: routers.ecom_checkout.router
2026-05-02 08:03:38,081 - main - INFO - Included router: routers.health.router
2026-05-02 08:03:38,130 - main - INFO - Included router: routers.kb_article_feedback.router
2026-05-02 08:03:38,185 - main - INFO - Included router: routers.kb_articles.router
2026-05-02 08:03:38,236 - main - INFO - Included router: routers.notification_preferences.router
2026-05-02 08:03:38,290 - main - INFO - Included router: routers.notifications.router
2026-05-02 08:03:38,296 - main - INFO - Included router: routers.notifications_extras.router
2026-05-02 08:03:38,410 - main - INFO - Included router: routers.oauth.router
2026-05-02 08:03:38,511 - main - INFO - Included router: routers.order_items.router
2026-05-02 08:03:38,745 - main - INFO - Included router: routers.orders.router
2026-05-02 08:03:38,800 - main - INFO - Included router: routers.plans.router
2026-05-02 08:03:38,996 - main - INFO - Included router: routers.product_categories.router
2026-05-02 08:03:39,213 - main - INFO - Included router: routers.product_reviews.router
2026-05-02 08:03:39,314 - main - INFO - Included router: routers.products.router
2026-05-02 08:03:39,353 - main - INFO - Included router: routers.role_management.router
2026-05-02 08:03:39,407 - main - INFO - Included router: routers.service_testimonials.router
2026-05-02 08:03:39,430 - main - INFO - Included router: routers.settings.router
2026-05-02 08:03:39,471 - main - INFO - Included router: routers.site_settings.router
2026-05-02 08:03:39,515 - main - INFO - Included router: routers.smtp_settings.router
2026-05-02 08:03:39,557 - main - INFO - Included router: routers.storage.router
2026-05-02 08:03:39,674 - main - INFO - Included router: routers.support_chat.router
2026-05-02 08:03:39,713 - main - INFO - Included router: routers.support_departments.router
2026-05-02 08:03:39,901 - main - INFO - Included router: routers.support_seats.router
2026-05-02 08:03:39,924 - main - INFO - Included router: routers.ticket_notifications_sync.router
2026-05-02 08:03:39,976 - main - INFO - Included router: routers.ticket_summaries.router
2026-05-02 08:03:40,023 - main - INFO - Included router: routers.ticket_sync_states.router
2026-05-02 08:03:40,053 - main - INFO - Included router: routers.user.router
2026-05-02 08:03:40,114 - main - INFO - Included router: routers.user_profiles.router
2026-05-02 08:03:40,157 - main - INFO - Included router: routers.user_roles.router
2026-05-02 08:03:40,178 - main - INFO - Included router: routers.whmcs.router
2026-05-02 08:03:40,264 - main - INFO - Included router: routers.whmcs_admin.router
2026-05-02 08:03:40,314 - main - INFO - Included router: routers.whmcs_extra.router
2026-05-02 08:03:40,316 - main - INFO - === Application startup initiated ===
2026-05-02 08:03:40,316 - services.database - INFO - Ignore creating tables
2026-05-02 08:03:40,316 - services.mock_data - INFO - Ignore initialize data
2026-05-02 08:03:40,316 - services.auth - INFO - Ignore initialize admin
2026-05-02 08:03:40,316 - main - INFO - === Application startup completed successfully ===
2026-05-02 08:04:23,050 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 08:04:23,050 - core.database - WARNING - Database session maker not available, attempting lazy initialization...
2026-05-02 08:04:23,050 - core.database - WARNING - Database not initialized, attempting lazy initialization...
2026-05-02 08:04:23,051 - core.database - INFO - Starting database initialization...
2026-05-02 08:04:23,051 - core.config - DEBUG - Read dynamic attribute database_url from environment variable DATABASE_URL
2026-05-02 08:04:23,051 - core.database - INFO - Normalizing database URL for async compatibility...
2026-05-02 08:04:23,052 - core.database - INFO - Creating async database engine...
2026-05-02 08:04:23,052 - core.database - INFO - Using QueuePool with connection pooling for non-Lambda environment
2026-05-02 08:04:23,121 - core.database - INFO - Database engine created successfully
2026-05-02 08:04:23,121 - core.database - INFO - Creating async session maker...
2026-05-02 08:04:23,121 - core.database - INFO - Async session maker created successfully
2026-05-02 08:04:23,121 - core.database - INFO - Database connection initialized successfully
2026-05-02 08:04:23,121 - core.database - DEBUG - [DB_OP] Starting create_tables
2026-05-02 08:04:23,121 - core.database - INFO - 🔧 Starting table creation...
2026-05-02 08:04:26,394 - core.database - INFO - Tables initialized successfully
2026-05-02 08:04:26,395 - core.database - DEBUG - [DB_OP] Create tables completed in 3.2736s
2026-05-02 08:04:26,458 - core.database - INFO - Lazy database initialization completed successfully
2026-05-02 08:04:26,459 - core.database - DEBUG - [DB_OP] Database session created successfully in 3.4089s
2026-05-02 08:04:26,941 - core.database - DEBUG - [DB_OP] Database session cleanup after 3.8908s
2026-05-02 08:04:28,393 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 08:04:28,393 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-02 08:04:28,710 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3169s
2026-05-02 08:05:15,625 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 08:05:15,626 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 08:05:15,943 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3174s
2026-05-02 08:06:28,089 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 08:06:28,089 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 08:06:28,405 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3162s
2026-05-02 08:07:13,211 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 08:07:13,211 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 08:07:13,529 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3187s
2026-05-02 08:08:21,299 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 08:08:21,300 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0006s
2026-05-02 08:08:21,617 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3176s
2026-05-02 08:09:25,385 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 08:09:25,386 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 08:09:25,702 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3166s
2026-05-02 08:10:14,108 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 08:10:14,108 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 08:10:14,558 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4505s
2026-05-02 08:10:22,204 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 08:10:22,205 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 08:10:22,521 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3169s
2026-05-02 08:11:26,306 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 08:11:26,307 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 08:11:26,623 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3169s
2026-05-02 08:12:13,146 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 08:12:13,146 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 08:12:13,464 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3183s
2026-05-02 08:13:13,150 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 08:13:13,150 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 08:13:13,467 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3178s
2026-05-02 08:14:13,015 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 08:14:13,016 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0006s
2026-05-02 08:14:13,333 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3181s
2026-05-02 08:15:13,137 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 08:15:13,137 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 08:15:13,457 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3199s
2026-05-02 08:16:13,378 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 08:16:13,378 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-02 08:16:13,823 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4454s
2026-05-02 08:17:13,143 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 08:17:13,143 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 08:17:13,460 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3172s
2026-05-02 08:18:13,153 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 08:18:13,153 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-02 08:18:13,470 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3173s
2026-05-02 08:19:13,139 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 08:19:13,140 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0006s
2026-05-02 08:19:13,457 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3180s
2026-05-02 08:20:13,139 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 08:20:13,140 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0008s
2026-05-02 08:20:13,460 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3205s
2026-05-02 08:20:32,014 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 08:20:32,015 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-02 08:20:32,330 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3153s
2026-05-02 08:21:13,016 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 08:21:13,016 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0007s
2026-05-02 08:21:13,335 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3189s
2026-05-02 08:21:37,179 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 08:21:37,180 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 08:21:37,621 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4417s
2026-05-02 08:21:56,802 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 08:21:56,802 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-02 08:21:56,805 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-02 08:21:56,810 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 08:21:56,810 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 08:21:56,811 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 08:21:56,814 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 08:21:56,814 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 08:21:56,815 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 08:21:57,119 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3177s
2026-05-02 08:21:57,575 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 08:21:57,576 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.7658s
2026-05-02 08:21:57,595 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 08:21:57,596 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.7817s
2026-05-02 08:22:15,951 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 08:22:15,951 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-02 08:22:16,269 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3187s
2026-05-02 08:22:39,829 - services.database - DEBUG - [DB_OP] Starting database close
2026-05-02 08:22:40,034 - core.database - INFO - Database connection closed and engine disposed
2026-05-02 08:22:40,034 - services.database - INFO - Database connections closed
2026-05-02 08:22:40,034 - services.database - DEBUG - [DB_OP] Database close completed in 0.2054s