2026-05-02 11:52:43,119 - main - INFO - === Logging system initialized ===
2026-05-02 11:52:43,120 - main - INFO - Log file: logs/app_20260502_115243.log
2026-05-02 11:52:43,120 - main - INFO - Log level: INFO
2026-05-02 11:52:43,120 - main - INFO - Timestamp: 20260502_115243
2026-05-02 11:52:43,182 - main - INFO - Included router: routers.admin_dashboard.router
2026-05-02 11:52:43,216 - main - INFO - Included router: routers.admin_users.router
2026-05-02 11:52:43,256 - main - INFO - Included router: routers.agent_availability.router
2026-05-02 11:52:43,998 - main - INFO - Included router: routers.ai_ticket_summary.router
2026-05-02 11:52:44,046 - main - INFO - Included router: routers.aihub.router
2026-05-02 11:52:44,058 - main - INFO - Included router: routers.auth.router
2026-05-02 11:52:44,102 - main - INFO - Included router: routers.carts.router
2026-05-02 11:52:44,151 - main - INFO - Included router: routers.chat_analytics_daily.router
2026-05-02 11:52:44,193 - main - INFO - Included router: routers.chat_attachments.router
2026-05-02 11:52:44,264 - main - INFO - Included router: routers.chat_branding.router
2026-05-02 11:52:44,279 - main - INFO - Included router: routers.chat_branding_api.router
2026-05-02 11:52:44,405 - main - INFO - Included router: routers.chat_conversations.router
2026-05-02 11:52:44,452 - main - INFO - Included router: routers.chat_messages.router
2026-05-02 11:52:44,500 - main - INFO - Included router: routers.chat_routing_rules.router
2026-05-02 11:52:44,527 - main - INFO - Included router: routers.contact.router
2026-05-02 11:52:44,570 - main - INFO - Included router: routers.contact_inquiries.router
2026-05-02 11:52:44,625 - main - INFO - Included router: routers.ecom_checkout.router
2026-05-02 11:52:44,649 - main - INFO - Included router: routers.health.router
2026-05-02 11:52:44,709 - main - INFO - Included router: routers.kb_article_feedback.router
2026-05-02 11:52:44,759 - main - INFO - Included router: routers.kb_articles.router
2026-05-02 11:52:44,784 - main - INFO - Included router: routers.local_auth.router
2026-05-02 11:52:44,842 - main - INFO - Included router: routers.notification_preferences.router
2026-05-02 11:52:44,902 - main - INFO - Included router: routers.notifications.router
2026-05-02 11:52:44,909 - main - INFO - Included router: routers.notifications_extras.router
2026-05-02 11:52:45,030 - main - INFO - Included router: routers.oauth.router
2026-05-02 11:52:45,101 - main - INFO - Included router: routers.order_items.router
2026-05-02 11:52:45,320 - main - INFO - Included router: routers.orders.router
2026-05-02 11:52:45,331 - main - INFO - Included router: routers.password_reset.router
2026-05-02 11:52:45,391 - main - INFO - Included router: routers.plans.router
2026-05-02 11:52:45,447 - main - INFO - Included router: routers.product_categories.router
2026-05-02 11:52:45,507 - main - INFO - Included router: routers.product_reviews.router
2026-05-02 11:52:45,572 - main - INFO - Included router: routers.products.router
2026-05-02 11:52:45,597 - main - INFO - Included router: routers.role_management.router
2026-05-02 11:52:45,651 - main - INFO - Included router: routers.service_testimonials.router
2026-05-02 11:52:45,677 - main - INFO - Included router: routers.settings.router
2026-05-02 11:52:45,731 - main - INFO - Included router: routers.site_settings.router
2026-05-02 11:52:45,776 - main - INFO - Included router: routers.smtp_settings.router
2026-05-02 11:52:45,822 - main - INFO - Included router: routers.storage.router
2026-05-02 11:52:45,936 - main - INFO - Included router: routers.support_chat.router
2026-05-02 11:52:46,134 - main - INFO - Included router: routers.support_departments.router
2026-05-02 11:52:46,193 - main - INFO - Included router: routers.support_seats.router
2026-05-02 11:52:46,200 - main - INFO - Included router: routers.ticket_notifications_sync.router
2026-05-02 11:52:46,236 - main - INFO - Included router: routers.ticket_summaries.router
2026-05-02 11:52:46,274 - main - INFO - Included router: routers.ticket_sync_states.router
2026-05-02 11:52:46,283 - main - INFO - Included router: routers.user.router
2026-05-02 11:52:46,325 - main - INFO - Included router: routers.user_profiles.router
2026-05-02 11:52:46,362 - main - INFO - Included router: routers.user_roles.router
2026-05-02 11:52:46,381 - main - INFO - Included router: routers.whmcs.router
2026-05-02 11:52:46,440 - main - INFO - Included router: routers.whmcs_admin.router
2026-05-02 11:52:46,482 - main - INFO - Included router: routers.whmcs_extra.router
2026-05-02 11:52:46,485 - main - INFO - === Application startup initiated ===
2026-05-02 11:52:46,486 - services.database - INFO - Ignore creating tables
2026-05-02 11:52:46,486 - services.mock_data - INFO - Ignore initialize data
2026-05-02 11:52:46,486 - services.auth - INFO - Ignore initialize admin
2026-05-02 11:52:46,486 - main - INFO - === Application startup completed successfully ===
2026-05-02 11:57:11,311 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 11:57:11,311 - core.database - WARNING - Database session maker not available, attempting lazy initialization...
2026-05-02 11:57:11,311 - core.database - WARNING - Database not initialized, attempting lazy initialization...
2026-05-02 11:57:11,311 - core.database - INFO - Starting database initialization...
2026-05-02 11:57:11,312 - core.config - DEBUG - Read dynamic attribute database_url from environment variable DATABASE_URL
2026-05-02 11:57:11,312 - core.database - INFO - Normalizing database URL for async compatibility...
2026-05-02 11:57:11,313 - core.database - INFO - Creating async database engine...
2026-05-02 11:57:11,313 - core.database - INFO - Using QueuePool with connection pooling for non-Lambda environment
2026-05-02 11:57:11,383 - core.database - INFO - Database engine created successfully
2026-05-02 11:57:11,383 - core.database - INFO - Creating async session maker...
2026-05-02 11:57:11,383 - core.database - INFO - Async session maker created successfully
2026-05-02 11:57:11,384 - core.database - INFO - Database connection initialized successfully
2026-05-02 11:57:11,384 - core.database - DEBUG - [DB_OP] Starting create_tables
2026-05-02 11:57:11,384 - core.database - INFO - 🔧 Starting table creation...
2026-05-02 11:57:11,391 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-02 11:57:11,396 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 11:57:11,396 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 11:57:11,397 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 11:57:11,402 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 11:57:11,403 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0006s
2026-05-02 11:57:11,403 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 11:57:12,813 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 11:57:12,814 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.4184s
2026-05-02 11:57:12,816 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 11:57:12,816 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.4144s
2026-05-02 11:57:14,803 - core.database - INFO - Tables initialized successfully
2026-05-02 11:57:14,803 - core.database - DEBUG - [DB_OP] Create tables completed in 3.4194s
2026-05-02 11:57:14,868 - core.database - INFO - Lazy database initialization completed successfully
2026-05-02 11:57:14,868 - core.database - DEBUG - [DB_OP] Database session created successfully in 3.5576s
2026-05-02 11:57:15,314 - core.database - DEBUG - [DB_OP] Database session cleanup after 4.0034s
2026-05-02 11:58:17,701 - services.database - DEBUG - [DB_OP] Starting database close
2026-05-02 11:58:17,898 - core.database - INFO - Database connection closed and engine disposed
2026-05-02 11:58:17,899 - services.database - INFO - Database connections closed
2026-05-02 11:58:17,899 - services.database - DEBUG - [DB_OP] Database close completed in 0.1979s