2026-05-02 08:29:42,590 - main - INFO - === Logging system initialized ===
2026-05-02 08:29:42,591 - main - INFO - Log file: logs/app_20260502_082942.log
2026-05-02 08:29:42,591 - main - INFO - Log level: INFO
2026-05-02 08:29:42,591 - main - INFO - Timestamp: 20260502_082942
2026-05-02 08:29:42,652 - main - INFO - Included router: routers.admin_dashboard.router
2026-05-02 08:29:42,713 - main - INFO - Included router: routers.agent_availability.router
2026-05-02 08:29:43,516 - main - INFO - Included router: routers.ai_ticket_summary.router
2026-05-02 08:29:43,539 - main - INFO - Included router: routers.aihub.router
2026-05-02 08:29:43,553 - main - INFO - Included router: routers.auth.router
2026-05-02 08:29:43,603 - main - INFO - Included router: routers.carts.router
2026-05-02 08:29:43,659 - main - INFO - Included router: routers.chat_analytics_daily.router
2026-05-02 08:29:43,709 - main - INFO - Included router: routers.chat_attachments.router
2026-05-02 08:29:43,777 - main - INFO - Included router: routers.chat_branding.router
2026-05-02 08:29:43,792 - main - INFO - Included router: routers.chat_branding_api.router
2026-05-02 08:29:43,932 - main - INFO - Included router: routers.chat_conversations.router
2026-05-02 08:29:43,976 - main - INFO - Included router: routers.chat_messages.router
2026-05-02 08:29:44,019 - main - INFO - Included router: routers.chat_routing_rules.router
2026-05-02 08:29:44,064 - main - INFO - Included router: routers.contact.router
2026-05-02 08:29:44,107 - main - INFO - Included router: routers.contact_inquiries.router
2026-05-02 08:29:44,153 - main - INFO - Included router: routers.ecom_checkout.router
2026-05-02 08:29:44,156 - main - INFO - Included router: routers.health.router
2026-05-02 08:29:44,207 - main - INFO - Included router: routers.kb_article_feedback.router
2026-05-02 08:29:44,255 - main - INFO - Included router: routers.kb_articles.router
2026-05-02 08:29:44,301 - main - INFO - Included router: routers.notification_preferences.router
2026-05-02 08:29:44,353 - main - INFO - Included router: routers.notifications.router
2026-05-02 08:29:44,358 - main - INFO - Included router: routers.notifications_extras.router
2026-05-02 08:29:44,471 - main - INFO - Included router: routers.oauth.router
2026-05-02 08:29:44,530 - main - INFO - Included router: routers.order_items.router
2026-05-02 08:29:44,759 - main - INFO - Included router: routers.orders.router
2026-05-02 08:29:44,831 - main - INFO - Included router: routers.plans.router
2026-05-02 08:29:44,884 - main - INFO - Included router: routers.product_categories.router
2026-05-02 08:29:44,939 - main - INFO - Included router: routers.product_reviews.router
2026-05-02 08:29:45,014 - main - INFO - Included router: routers.products.router
2026-05-02 08:29:45,068 - main - INFO - Included router: routers.role_management.router
2026-05-02 08:29:45,127 - main - INFO - Included router: routers.service_testimonials.router
2026-05-02 08:29:45,189 - main - INFO - Included router: routers.settings.router
2026-05-02 08:29:45,237 - main - INFO - Included router: routers.site_settings.router
2026-05-02 08:29:45,281 - main - INFO - Included router: routers.smtp_settings.router
2026-05-02 08:29:45,328 - main - INFO - Included router: routers.storage.router
2026-05-02 08:29:45,457 - main - INFO - Included router: routers.support_chat.router
2026-05-02 08:29:45,501 - main - INFO - Included router: routers.support_departments.router
2026-05-02 08:29:45,680 - main - INFO - Included router: routers.support_seats.router
2026-05-02 08:29:45,687 - main - INFO - Included router: routers.ticket_notifications_sync.router
2026-05-02 08:29:45,727 - main - INFO - Included router: routers.ticket_summaries.router
2026-05-02 08:29:45,960 - main - INFO - Included router: routers.ticket_sync_states.router
2026-05-02 08:29:45,969 - main - INFO - Included router: routers.user.router
2026-05-02 08:29:46,015 - main - INFO - Included router: routers.user_profiles.router
2026-05-02 08:29:46,076 - main - INFO - Included router: routers.user_roles.router
2026-05-02 08:29:46,094 - main - INFO - Included router: routers.whmcs.router
2026-05-02 08:29:46,160 - main - INFO - Included router: routers.whmcs_admin.router
2026-05-02 08:29:46,198 - main - INFO - Included router: routers.whmcs_extra.router
2026-05-02 08:29:46,200 - main - INFO - === Application startup initiated ===
2026-05-02 08:29:46,200 - services.database - INFO - Ignore creating tables
2026-05-02 08:29:46,200 - services.mock_data - INFO - Ignore initialize data
2026-05-02 08:29:46,200 - services.auth - INFO - Ignore initialize admin
2026-05-02 08:29:46,201 - main - INFO - === Application startup completed successfully ===
2026-05-02 08:30:18,912 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-02 08:30:18,915 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 08:30:18,915 - core.database - WARNING - Database session maker not available, attempting lazy initialization...
2026-05-02 08:30:18,915 - core.database - WARNING - Database not initialized, attempting lazy initialization...
2026-05-02 08:30:18,915 - core.database - INFO - Starting database initialization...
2026-05-02 08:30:18,915 - core.config - DEBUG - Read dynamic attribute database_url from environment variable DATABASE_URL
2026-05-02 08:30:18,916 - core.database - INFO - Normalizing database URL for async compatibility...
2026-05-02 08:30:18,917 - core.database - INFO - Creating async database engine...
2026-05-02 08:30:18,917 - core.database - INFO - Using QueuePool with connection pooling for non-Lambda environment
2026-05-02 08:30:18,972 - core.database - INFO - Database engine created successfully
2026-05-02 08:30:18,972 - core.database - INFO - Creating async session maker...
2026-05-02 08:30:18,973 - core.database - INFO - Async session maker created successfully
2026-05-02 08:30:18,973 - core.database - INFO - Database connection initialized successfully
2026-05-02 08:30:18,973 - core.database - DEBUG - [DB_OP] Starting create_tables
2026-05-02 08:30:18,973 - core.database - INFO - 🔧 Starting table creation...
2026-05-02 08:30:18,980 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 08:30:18,981 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-05-02 08:30:18,981 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 08:30:18,985 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 08:30:18,985 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-02 08:30:18,986 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 08:30:20,392 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 08:30:20,393 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.4125s
2026-05-02 08:30:20,394 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 08:30:20,394 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.4089s
2026-05-02 08:30:22,319 - core.database - INFO - Tables initialized successfully
2026-05-02 08:30:22,320 - core.database - DEBUG - [DB_OP] Create tables completed in 3.3471s
2026-05-02 08:30:22,384 - core.database - INFO - Lazy database initialization completed successfully
2026-05-02 08:30:22,384 - core.database - DEBUG - [DB_OP] Database session created successfully in 3.4694s
2026-05-02 08:30:22,838 - core.database - DEBUG - [DB_OP] Database session cleanup after 3.9233s
2026-05-02 08:31:19,176 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 08:31:19,176 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-02 08:31:19,621 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4456s
2026-05-02 08:32:19,150 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 08:32:19,151 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0006s
2026-05-02 08:32:19,600 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4502s
2026-05-02 08:33:19,148 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 08:33:19,149 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 08:33:19,465 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3167s
2026-05-02 08:34:19,370 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 08:34:19,370 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-02 08:34:19,689 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3192s
2026-05-02 08:35:19,149 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 08:35:19,149 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-02 08:35:19,473 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3238s
2026-05-02 08:36:19,096 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 08:36:19,097 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 08:36:19,540 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4434s
2026-05-02 08:36:52,722 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 08:36:52,722 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-02 08:36:53,166 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4444s
2026-05-02 08:38:15,744 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 08:38:15,745 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0007s
2026-05-02 08:38:16,194 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4494s
2026-05-02 08:38:34,289 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 08:38:34,289 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-02 08:38:34,604 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3150s
2026-05-02 08:38:52,914 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 08:38:52,915 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0012s
2026-05-02 08:38:52,917 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-02 08:38:52,919 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 08:38:52,920 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-05-02 08:38:52,920 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 08:38:52,923 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 08:38:52,923 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-02 08:38:52,923 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 08:38:53,234 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3204s
2026-05-02 08:38:53,303 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 08:38:53,304 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3809s
2026-05-02 08:38:53,433 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 08:38:53,433 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.5143s
2026-05-02 08:39:52,397 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 08:39:52,397 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 08:39:52,719 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3226s
2026-05-02 08:40:01,927 - services.database - DEBUG - [DB_OP] Starting database close
2026-05-02 08:40:02,125 - core.database - INFO - Database connection closed and engine disposed
2026-05-02 08:40:02,126 - services.database - INFO - Database connections closed
2026-05-02 08:40:02,126 - services.database - DEBUG - [DB_OP] Database close completed in 0.1989s
