2026-05-02 11:04:58,890 - main - INFO - === Logging system initialized ===
2026-05-02 11:04:58,890 - main - INFO - Log file: logs/app_20260502_110458.log
2026-05-02 11:04:58,890 - main - INFO - Log level: INFO
2026-05-02 11:04:58,891 - main - INFO - Timestamp: 20260502_110458
2026-05-02 11:04:58,978 - main - INFO - Included router: routers.admin_dashboard.router
2026-05-02 11:04:59,023 - main - INFO - Included router: routers.agent_availability.router
2026-05-02 11:05:00,108 - main - INFO - Included router: routers.ai_ticket_summary.router
2026-05-02 11:05:00,148 - main - INFO - Included router: routers.aihub.router
2026-05-02 11:05:00,165 - main - INFO - Included router: routers.auth.router
2026-05-02 11:05:00,221 - main - INFO - Included router: routers.carts.router
2026-05-02 11:05:00,278 - main - INFO - Included router: routers.chat_analytics_daily.router
2026-05-02 11:05:00,338 - main - INFO - Included router: routers.chat_attachments.router
2026-05-02 11:05:00,412 - main - INFO - Included router: routers.chat_branding.router
2026-05-02 11:05:00,434 - main - INFO - Included router: routers.chat_branding_api.router
2026-05-02 11:05:00,620 - main - INFO - Included router: routers.chat_conversations.router
2026-05-02 11:05:00,683 - main - INFO - Included router: routers.chat_messages.router
2026-05-02 11:05:00,737 - main - INFO - Included router: routers.chat_routing_rules.router
2026-05-02 11:05:00,763 - main - INFO - Included router: routers.contact.router
2026-05-02 11:05:00,808 - main - INFO - Included router: routers.contact_inquiries.router
2026-05-02 11:05:00,857 - main - INFO - Included router: routers.ecom_checkout.router
2026-05-02 11:05:00,860 - main - INFO - Included router: routers.health.router
2026-05-02 11:05:00,909 - main - INFO - Included router: routers.kb_article_feedback.router
2026-05-02 11:05:00,956 - main - INFO - Included router: routers.kb_articles.router
2026-05-02 11:05:01,016 - main - INFO - Included router: routers.notification_preferences.router
2026-05-02 11:05:01,104 - main - INFO - Included router: routers.notifications.router
2026-05-02 11:05:01,112 - main - INFO - Included router: routers.notifications_extras.router
2026-05-02 11:05:01,220 - main - INFO - Included router: routers.oauth.router
2026-05-02 11:05:01,271 - main - INFO - Included router: routers.order_items.router
2026-05-02 11:05:01,440 - main - INFO - Included router: routers.orders.router
2026-05-02 11:05:01,509 - main - INFO - Included router: routers.plans.router
2026-05-02 11:05:01,560 - main - INFO - Included router: routers.product_categories.router
2026-05-02 11:05:01,620 - main - INFO - Included router: routers.product_reviews.router
2026-05-02 11:05:01,681 - main - INFO - Included router: routers.products.router
2026-05-02 11:05:01,712 - main - INFO - Included router: routers.role_management.router
2026-05-02 11:05:01,760 - main - INFO - Included router: routers.service_testimonials.router
2026-05-02 11:05:01,782 - main - INFO - Included router: routers.settings.router
2026-05-02 11:05:01,831 - main - INFO - Included router: routers.site_settings.router
2026-05-02 11:05:01,882 - main - INFO - Included router: routers.smtp_settings.router
2026-05-02 11:05:01,926 - main - INFO - Included router: routers.storage.router
2026-05-02 11:05:02,042 - main - INFO - Included router: routers.support_chat.router
2026-05-02 11:05:02,079 - main - INFO - Included router: routers.support_departments.router
2026-05-02 11:05:02,244 - main - INFO - Included router: routers.support_seats.router
2026-05-02 11:05:02,259 - main - INFO - Included router: routers.ticket_notifications_sync.router
2026-05-02 11:05:02,298 - main - INFO - Included router: routers.ticket_summaries.router
2026-05-02 11:05:02,372 - main - INFO - Included router: routers.ticket_sync_states.router
2026-05-02 11:05:02,382 - main - INFO - Included router: routers.user.router
2026-05-02 11:05:02,426 - main - INFO - Included router: routers.user_profiles.router
2026-05-02 11:05:02,462 - main - INFO - Included router: routers.user_roles.router
2026-05-02 11:05:02,481 - main - INFO - Included router: routers.whmcs.router
2026-05-02 11:05:02,542 - main - INFO - Included router: routers.whmcs_admin.router
2026-05-02 11:05:02,581 - main - INFO - Included router: routers.whmcs_extra.router
2026-05-02 11:05:02,582 - main - INFO - === Application startup initiated ===
2026-05-02 11:05:02,583 - services.database - INFO - Ignore creating tables
2026-05-02 11:05:02,583 - services.mock_data - INFO - Ignore initialize data
2026-05-02 11:05:02,583 - services.auth - INFO - Ignore initialize admin
2026-05-02 11:05:02,583 - main - INFO - === Application startup completed successfully ===
2026-05-02 11:07:20,057 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-02 11:07:20,061 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 11:07:20,061 - core.database - WARNING - Database session maker not available, attempting lazy initialization...
2026-05-02 11:07:20,061 - core.database - WARNING - Database not initialized, attempting lazy initialization...
2026-05-02 11:07:20,061 - core.database - INFO - Starting database initialization...
2026-05-02 11:07:20,061 - core.config - DEBUG - Read dynamic attribute database_url from environment variable DATABASE_URL
2026-05-02 11:07:20,062 - core.database - INFO - Normalizing database URL for async compatibility...
2026-05-02 11:07:20,063 - core.database - INFO - Creating async database engine...
2026-05-02 11:07:20,063 - core.database - INFO - Using QueuePool with connection pooling for non-Lambda environment
2026-05-02 11:07:20,126 - core.database - INFO - Database engine created successfully
2026-05-02 11:07:20,127 - core.database - INFO - Creating async session maker...
2026-05-02 11:07:20,127 - core.database - INFO - Async session maker created successfully
2026-05-02 11:07:20,127 - core.database - INFO - Database connection initialized successfully
2026-05-02 11:07:20,127 - core.database - DEBUG - [DB_OP] Starting create_tables
2026-05-02 11:07:20,127 - core.database - INFO - 🔧 Starting table creation...
2026-05-02 11:07:20,133 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 11:07:20,133 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-02 11:07:20,133 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 11:07:20,194 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 11:07:20,194 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-02 11:07:21,460 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.2668s
2026-05-02 11:07:21,586 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 11:07:21,587 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.4542s
2026-05-02 11:07:23,487 - core.database - INFO - Tables initialized successfully
2026-05-02 11:07:23,487 - core.database - DEBUG - [DB_OP] Create tables completed in 3.3604s
2026-05-02 11:07:23,551 - core.database - INFO - Lazy database initialization completed successfully
2026-05-02 11:07:23,551 - core.database - DEBUG - [DB_OP] Database session created successfully in 3.4906s
2026-05-02 11:07:23,552 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 11:07:24,125 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 11:07:24,126 - core.database - DEBUG - [DB_OP] Database session cleanup after 4.0655s
2026-05-02 11:07:42,972 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 11:07:42,972 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0006s
2026-05-02 11:07:42,974 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 11:07:42,974 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 11:07:42,975 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 11:07:42,977 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-02 11:07:43,007 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 11:07:43,007 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-02 11:07:43,007 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 11:07:43,407 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 11:07:43,408 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4014s
2026-05-02 11:07:43,419 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4476s
2026-05-02 11:07:43,572 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 11:07:43,573 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.5989s
2026-05-02 11:08:20,118 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 11:08:20,119 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-02 11:08:20,438 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3200s
2026-05-02 11:08:39,239 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 11:08:39,240 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0010s
2026-05-02 11:08:39,241 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 11:08:39,243 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 11:08:39,243 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-02 11:08:39,244 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 11:08:39,244 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-02 11:08:39,244 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 11:08:39,246 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-02 11:08:39,623 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3807s
2026-05-02 11:08:39,624 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 11:08:39,625 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3855s
2026-05-02 11:08:39,626 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 11:08:39,626 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3824s
2026-05-02 11:09:39,549 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-02 11:09:39,550 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 11:09:39,551 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-05-02 11:09:39,551 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 11:09:39,554 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 11:09:39,554 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-02 11:09:39,556 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 11:09:39,556 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-05-02 11:09:39,557 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 11:09:39,872 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3178s
2026-05-02 11:09:39,934 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 11:09:39,935 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3845s
2026-05-02 11:09:39,938 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 11:09:39,938 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3822s
2026-05-02 11:10:40,097 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 11:10:40,097 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 11:10:40,418 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3210s
2026-05-02 11:11:40,086 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 11:11:40,087 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0008s
2026-05-02 11:11:40,405 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3187s
2026-05-02 11:34:39,205 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 11:34:39,206 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0010s
2026-05-02 11:34:39,208 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-02 11:34:39,210 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 11:34:39,210 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-02 11:34:39,210 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 11:34:39,214 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 11:34:39,214 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-02 11:34:39,215 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 11:34:40,416 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.2110s
2026-05-02 11:34:40,563 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 11:34:40,564 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.3498s
2026-05-02 11:34:40,565 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 11:34:40,565 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.3553s
2026-05-02 11:35:06,840 - services.database - DEBUG - [DB_OP] Starting database close
2026-05-02 11:35:07,040 - core.database - INFO - Database connection closed and engine disposed
2026-05-02 11:35:07,040 - services.database - INFO - Database connections closed
2026-05-02 11:35:07,040 - services.database - DEBUG - [DB_OP] Database close completed in 0.1999s