2026-05-02 19:47:28,749 - main - INFO - === Logging system initialized ===
2026-05-02 19:47:28,749 - main - INFO - Log file: logs/app_20260502_194728.log
2026-05-02 19:47:28,750 - main - INFO - Log level: INFO
2026-05-02 19:47:28,750 - main - INFO - Timestamp: 20260502_194728
2026-05-02 19:47:28,823 - main - INFO - Included router: routers.admin_dashboard.router
2026-05-02 19:47:28,864 - main - INFO - Included router: routers.admin_users.router
2026-05-02 19:47:28,905 - main - INFO - Included router: routers.agent_availability.router
2026-05-02 19:47:29,775 - main - INFO - Included router: routers.ai_ticket_summary.router
2026-05-02 19:47:29,795 - main - INFO - Included router: routers.aihub.router
2026-05-02 19:47:29,809 - main - INFO - Included router: routers.audit_log.router
2026-05-02 19:47:29,819 - main - INFO - Included router: routers.auth.router
2026-05-02 19:47:29,862 - main - INFO - Included router: routers.carts.router
2026-05-02 19:47:29,911 - main - INFO - Included router: routers.chat_analytics_daily.router
2026-05-02 19:47:29,956 - main - INFO - Included router: routers.chat_attachments.router
2026-05-02 19:47:30,022 - main - INFO - Included router: routers.chat_branding.router
2026-05-02 19:47:30,057 - main - INFO - Included router: routers.chat_branding_api.router
2026-05-02 19:47:30,218 - main - INFO - Included router: routers.chat_conversations.router
2026-05-02 19:47:30,281 - main - INFO - Included router: routers.chat_messages.router
2026-05-02 19:47:30,338 - main - INFO - Included router: routers.chat_routing_rules.router
2026-05-02 19:47:30,367 - main - INFO - Included router: routers.contact.router
2026-05-02 19:47:30,420 - main - INFO - Included router: routers.contact_inquiries.router
2026-05-02 19:47:30,483 - main - INFO - Included router: routers.ecom_checkout.router
2026-05-02 19:47:30,486 - main - INFO - Included router: routers.health.router
2026-05-02 19:47:30,535 - main - INFO - Included router: routers.kb_article_feedback.router
2026-05-02 19:47:30,582 - main - INFO - Included router: routers.kb_articles.router
2026-05-02 19:47:30,596 - main - INFO - Included router: routers.local_auth.router
2026-05-02 19:47:30,644 - main - INFO - Included router: routers.notification_preferences.router
2026-05-02 19:47:30,701 - main - INFO - Included router: routers.notifications.router
2026-05-02 19:47:30,706 - main - INFO - Included router: routers.notifications_extras.router
2026-05-02 19:47:30,806 - main - INFO - Included router: routers.oauth.router
2026-05-02 19:47:30,992 - main - INFO - Included router: routers.order_items.router
2026-05-02 19:47:31,092 - main - INFO - Included router: routers.orders.router
2026-05-02 19:47:31,098 - main - INFO - Included router: routers.password_reset.router
2026-05-02 19:47:31,152 - main - INFO - Included router: routers.plans.router
2026-05-02 19:47:31,200 - main - INFO - Included router: routers.product_categories.router
2026-05-02 19:47:31,250 - main - INFO - Included router: routers.product_reviews.router
2026-05-02 19:47:31,313 - main - INFO - Included router: routers.products.router
2026-05-02 19:47:31,336 - main - INFO - Included router: routers.role_management.router
2026-05-02 19:47:31,380 - main - INFO - Included router: routers.service_testimonials.router
2026-05-02 19:47:31,400 - main - INFO - Included router: routers.settings.router
2026-05-02 19:47:31,445 - main - INFO - Included router: routers.site_settings.router
2026-05-02 19:47:31,481 - main - INFO - Included router: routers.smtp_settings.router
2026-05-02 19:47:31,518 - main - INFO - Included router: routers.storage.router
2026-05-02 19:47:31,624 - main - INFO - Included router: routers.support_chat.router
2026-05-02 19:47:31,842 - main - INFO - Included router: routers.support_departments.router
2026-05-02 19:47:31,952 - main - INFO - Included router: routers.support_seats.router
2026-05-02 19:47:31,960 - main - INFO - Included router: routers.ticket_notifications_sync.router
2026-05-02 19:47:31,995 - main - INFO - Included router: routers.ticket_summaries.router
2026-05-02 19:47:32,032 - main - INFO - Included router: routers.ticket_sync_states.router
2026-05-02 19:47:32,041 - main - INFO - Included router: routers.user.router
2026-05-02 19:47:32,097 - main - INFO - Included router: routers.user_profiles.router
2026-05-02 19:47:32,133 - main - INFO - Included router: routers.user_roles.router
2026-05-02 19:47:32,152 - main - INFO - Included router: routers.whmcs.router
2026-05-02 19:47:32,209 - main - INFO - Included router: routers.whmcs_admin.router
2026-05-02 19:47:32,249 - main - INFO - Included router: routers.whmcs_extra.router
2026-05-02 19:47:32,251 - main - INFO - === Application startup initiated ===
2026-05-02 19:47:32,251 - services.database - INFO - Ignore creating tables
2026-05-02 19:47:32,251 - services.mock_data - INFO - Ignore initialize data
2026-05-02 19:47:32,251 - services.auth - INFO - Ignore initialize admin
2026-05-02 19:47:32,251 - main - INFO - === Application startup completed successfully ===
2026-05-02 19:47:35,777 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 19:47:35,777 - core.database - WARNING - Database session maker not available, attempting lazy initialization...
2026-05-02 19:47:35,777 - core.database - WARNING - Database not initialized, attempting lazy initialization...
2026-05-02 19:47:35,777 - core.database - INFO - Starting database initialization...
2026-05-02 19:47:35,777 - core.config - DEBUG - Read dynamic attribute database_url from environment variable DATABASE_URL
2026-05-02 19:47:35,778 - core.database - INFO - Normalizing database URL for async compatibility...
2026-05-02 19:47:35,779 - core.database - INFO - Creating async database engine...
2026-05-02 19:47:35,779 - core.database - INFO - Using QueuePool with connection pooling for non-Lambda environment
2026-05-02 19:47:35,831 - core.database - INFO - Database engine created successfully
2026-05-02 19:47:35,832 - core.database - INFO - Creating async session maker...
2026-05-02 19:47:35,832 - core.database - INFO - Async session maker created successfully
2026-05-02 19:47:35,832 - core.database - INFO - Database connection initialized successfully
2026-05-02 19:47:35,832 - core.database - DEBUG - [DB_OP] Starting create_tables
2026-05-02 19:47:35,832 - core.database - INFO - 🔧 Starting table creation...
2026-05-02 19:47:38,330 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 19:47:38,331 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-05-02 19:47:38,331 - routers.products - DEBUG - Querying productss: query={"is_active":true}, sort=-featured,-id, skip=0, limit=200, fields=None
2026-05-02 19:47:38,336 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 19:47:38,336 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-02 19:47:38,336 - routers.product_categories - DEBUG - Querying product_categoriess: query={"is_active":true}, sort=sort_order, skip=0, limit=100, fields=None
2026-05-02 19:47:39,114 - routers.products - DEBUG - Found 8 productss
2026-05-02 19:47:39,115 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.7844s
2026-05-02 19:47:39,116 - routers.product_categories - DEBUG - Found 5 product_categoriess
2026-05-02 19:47:39,116 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.7803s
2026-05-02 19:47:39,363 - core.database - INFO - Tables initialized successfully
2026-05-02 19:47:39,363 - core.database - DEBUG - [DB_OP] Create tables completed in 3.5312s
2026-05-02 19:47:39,374 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 19:47:39,374 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-02 19:47:39,426 - core.database - INFO - Lazy database initialization completed successfully
2026-05-02 19:47:39,427 - core.database - DEBUG - [DB_OP] Database session created successfully in 3.6503s
2026-05-02 19:47:39,428 - routers.service_testimonials - DEBUG - Querying service_testimonialss: query=None, sort=None, skip=0, limit=200, fields=None
2026-05-02 19:47:39,823 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4490s
2026-05-02 19:47:40,010 - routers.service_testimonials - DEBUG - Found 5 service_testimonialss
2026-05-02 19:47:40,011 - core.database - DEBUG - [DB_OP] Database session cleanup after 4.2344s
2026-05-02 19:47:43,621 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 19:47:43,622 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 19:47:43,622 - routers.products - DEBUG - Querying productss: query={"slug":"pro-wireless-headphones"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 19:47:43,626 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-02 19:47:44,197 - routers.products - DEBUG - Found 1 productss
2026-05-02 19:47:44,199 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.5776s
2026-05-02 19:47:44,433 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 19:47:44,434 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-02 19:47:44,434 - routers.product_reviews - DEBUG - Querying product_reviewss: query={"product_id":2,"is_approved":true}, sort=-id, skip=0, limit=50, fields=None
2026-05-02 19:47:44,950 - routers.product_reviews - DEBUG - Found 0 product_reviewss
2026-05-02 19:47:44,950 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.5169s
2026-05-02 19:48:08,227 - services.database - DEBUG - [DB_OP] Starting database close
2026-05-02 19:48:08,427 - core.database - INFO - Database connection closed and engine disposed
2026-05-02 19:48:08,427 - services.database - INFO - Database connections closed
2026-05-02 19:48:08,427 - services.database - DEBUG - [DB_OP] Database close completed in 0.2005s