2026-05-02 20:13:27,084 - main - INFO - === Logging system initialized ===
2026-05-02 20:13:27,084 - main - INFO - Log file: logs/app_20260502_201327.log
2026-05-02 20:13:27,084 - main - INFO - Log level: INFO
2026-05-02 20:13:27,084 - main - INFO - Timestamp: 20260502_201327
2026-05-02 20:13:27,159 - main - INFO - Included router: routers.admin_dashboard.router
2026-05-02 20:13:27,202 - main - INFO - Included router: routers.admin_users.router
2026-05-02 20:13:27,248 - main - INFO - Included router: routers.agent_availability.router
2026-05-02 20:13:28,170 - main - INFO - Included router: routers.ai_ticket_summary.router
2026-05-02 20:13:28,195 - main - INFO - Included router: routers.aihub.router
2026-05-02 20:13:28,212 - main - INFO - Included router: routers.audit_log.router
2026-05-02 20:13:28,223 - main - INFO - Included router: routers.auth.router
2026-05-02 20:13:28,245 - main - INFO - Included router: routers.cache_settings.router
2026-05-02 20:13:28,294 - main - INFO - Included router: routers.carts.router
2026-05-02 20:13:28,349 - main - INFO - Included router: routers.chat_analytics_daily.router
2026-05-02 20:13:28,397 - main - INFO - Included router: routers.chat_attachments.router
2026-05-02 20:13:28,464 - main - INFO - Included router: routers.chat_branding.router
2026-05-02 20:13:28,478 - main - INFO - Included router: routers.chat_branding_api.router
2026-05-02 20:13:28,628 - main - INFO - Included router: routers.chat_conversations.router
2026-05-02 20:13:28,676 - main - INFO - Included router: routers.chat_messages.router
2026-05-02 20:13:28,723 - main - INFO - Included router: routers.chat_routing_rules.router
2026-05-02 20:13:28,747 - main - INFO - Included router: routers.contact.router
2026-05-02 20:13:28,789 - main - INFO - Included router: routers.contact_inquiries.router
2026-05-02 20:13:28,841 - main - INFO - Included router: routers.ecom_checkout.router
2026-05-02 20:13:28,843 - main - INFO - Included router: routers.health.router
2026-05-02 20:13:28,888 - main - INFO - Included router: routers.kb_article_feedback.router
2026-05-02 20:13:28,933 - main - INFO - Included router: routers.kb_articles.router
2026-05-02 20:13:28,949 - main - INFO - Included router: routers.local_auth.router
2026-05-02 20:13:28,995 - main - INFO - Included router: routers.notification_preferences.router
2026-05-02 20:13:29,040 - main - INFO - Included router: routers.notifications.router
2026-05-02 20:13:29,044 - main - INFO - Included router: routers.notifications_extras.router
2026-05-02 20:13:29,129 - main - INFO - Included router: routers.oauth.router
2026-05-02 20:13:29,308 - main - INFO - Included router: routers.order_items.router
2026-05-02 20:13:29,396 - main - INFO - Included router: routers.orders.router
2026-05-02 20:13:29,403 - main - INFO - Included router: routers.password_reset.router
2026-05-02 20:13:29,460 - main - INFO - Included router: routers.plans.router
2026-05-02 20:13:29,507 - main - INFO - Included router: routers.product_categories.router
2026-05-02 20:13:29,566 - main - INFO - Included router: routers.product_reviews.router
2026-05-02 20:13:29,640 - main - INFO - Included router: routers.products.router
2026-05-02 20:13:29,671 - main - INFO - Included router: routers.role_management.router
2026-05-02 20:13:29,728 - main - INFO - Included router: routers.service_testimonials.router
2026-05-02 20:13:29,748 - main - INFO - Included router: routers.settings.router
2026-05-02 20:13:29,793 - main - INFO - Included router: routers.site_settings.router
2026-05-02 20:13:29,844 - main - INFO - Included router: routers.smtp_settings.router
2026-05-02 20:13:29,886 - main - INFO - Included router: routers.storage.router
2026-05-02 20:13:30,164 - main - INFO - Included router: routers.support_chat.router
2026-05-02 20:13:30,220 - main - INFO - Included router: routers.support_departments.router
2026-05-02 20:13:30,281 - main - INFO - Included router: routers.support_seats.router
2026-05-02 20:13:30,291 - main - INFO - Included router: routers.ticket_notifications_sync.router
2026-05-02 20:13:30,344 - main - INFO - Included router: routers.ticket_summaries.router
2026-05-02 20:13:30,388 - main - INFO - Included router: routers.ticket_sync_states.router
2026-05-02 20:13:30,402 - main - INFO - Included router: routers.user.router
2026-05-02 20:13:30,458 - main - INFO - Included router: routers.user_profiles.router
2026-05-02 20:13:30,498 - main - INFO - Included router: routers.user_roles.router
2026-05-02 20:13:30,516 - main - INFO - Included router: routers.whmcs.router
2026-05-02 20:13:30,572 - main - INFO - Included router: routers.whmcs_admin.router
2026-05-02 20:13:30,610 - main - INFO - Included router: routers.whmcs_extra.router
2026-05-02 20:13:30,612 - main - INFO - === Application startup initiated ===
2026-05-02 20:13:30,612 - services.database - INFO - Ignore creating tables
2026-05-02 20:13:30,612 - services.mock_data - INFO - Ignore initialize data
2026-05-02 20:13:30,612 - services.auth - INFO - Ignore initialize admin
2026-05-02 20:13:30,612 - main - INFO - === Application startup completed successfully ===
2026-05-02 20:17:07,317 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 20:17:07,317 - core.database - WARNING - Database session maker not available, attempting lazy initialization...
2026-05-02 20:17:07,317 - core.database - WARNING - Database not initialized, attempting lazy initialization...
2026-05-02 20:17:07,317 - core.database - INFO - Starting database initialization...
2026-05-02 20:17:07,318 - core.config - DEBUG - Read dynamic attribute database_url from environment variable DATABASE_URL
2026-05-02 20:17:07,318 - core.database - INFO - Normalizing database URL for async compatibility...
2026-05-02 20:17:07,319 - core.database - INFO - Creating async database engine...
2026-05-02 20:17:07,320 - core.database - INFO - Using QueuePool with connection pooling for non-Lambda environment
2026-05-02 20:17:07,383 - core.database - INFO - Database engine created successfully
2026-05-02 20:17:07,383 - core.database - INFO - Creating async session maker...
2026-05-02 20:17:07,383 - core.database - INFO - Async session maker created successfully
2026-05-02 20:17:07,383 - core.database - INFO - Database connection initialized successfully
2026-05-02 20:17:07,383 - core.database - DEBUG - [DB_OP] Starting create_tables
2026-05-02 20:17:07,384 - core.database - INFO - 🔧 Starting table creation...
2026-05-02 20:17:07,391 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-02 20:17:07,396 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 20:17:07,397 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-02 20:17:07,397 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 20:17:07,403 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 20:17:07,404 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-02 20:17:07,404 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 20:17:08,808 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 20:17:08,809 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.4063s
2026-05-02 20:17:08,811 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 20:17:08,811 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.4147s
2026-05-02 20:17:10,867 - core.database - INFO - Tables initialized successfully
2026-05-02 20:17:10,867 - core.database - DEBUG - [DB_OP] Create tables completed in 3.4840s
2026-05-02 20:17:10,936 - core.database - INFO - Lazy database initialization completed successfully
2026-05-02 20:17:10,937 - core.database - DEBUG - [DB_OP] Database session created successfully in 3.6197s
2026-05-02 20:17:11,381 - core.database - DEBUG - [DB_OP] Database session cleanup after 4.0642s
2026-05-02 20:17:24,671 - services.database - DEBUG - [DB_OP] Starting database close
2026-05-02 20:17:24,872 - core.database - INFO - Database connection closed and engine disposed
2026-05-02 20:17:24,872 - services.database - INFO - Database connections closed
2026-05-02 20:17:24,872 - services.database - DEBUG - [DB_OP] Database close completed in 0.2012s
