2026-05-02 06:07:31,370 - main - INFO - === Logging system initialized ===
2026-05-02 06:07:31,370 - main - INFO - Log file: logs/app_20260502_060731.log
2026-05-02 06:07:31,370 - main - INFO - Log level: INFO
2026-05-02 06:07:31,371 - main - INFO - Timestamp: 20260502_060731
2026-05-02 06:07:31,423 - main - INFO - Included router: routers.admin_dashboard.router
2026-05-02 06:07:31,461 - main - INFO - Included router: routers.agent_availability.router
2026-05-02 06:07:32,317 - main - INFO - Included router: routers.ai_ticket_summary.router
2026-05-02 06:07:32,338 - main - INFO - Included router: routers.aihub.router
2026-05-02 06:07:32,355 - main - INFO - Included router: routers.auth.router
2026-05-02 06:07:32,404 - main - INFO - Included router: routers.chat_analytics_daily.router
2026-05-02 06:07:32,449 - main - INFO - Included router: routers.chat_attachments.router
2026-05-02 06:07:32,514 - main - INFO - Included router: routers.chat_branding.router
2026-05-02 06:07:32,529 - main - INFO - Included router: routers.chat_branding_api.router
2026-05-02 06:07:32,579 - main - INFO - Included router: routers.chat_conversations.router
2026-05-02 06:07:32,698 - main - INFO - Included router: routers.chat_messages.router
2026-05-02 06:07:32,741 - main - INFO - Included router: routers.chat_routing_rules.router
2026-05-02 06:07:32,761 - main - INFO - Included router: routers.contact.router
2026-05-02 06:07:32,799 - main - INFO - Included router: routers.contact_inquiries.router
2026-05-02 06:07:32,802 - main - INFO - Included router: routers.health.router
2026-05-02 06:07:32,844 - main - INFO - Included router: routers.kb_article_feedback.router
2026-05-02 06:07:32,888 - main - INFO - Included router: routers.kb_articles.router
2026-05-02 06:07:32,936 - main - INFO - Included router: routers.notification_preferences.router
2026-05-02 06:07:32,983 - main - INFO - Included router: routers.notifications.router
2026-05-02 06:07:32,990 - main - INFO - Included router: routers.notifications_extras.router
2026-05-02 06:07:33,107 - main - INFO - Included router: routers.oauth.router
2026-05-02 06:07:33,153 - main - INFO - Included router: routers.plans.router
2026-05-02 06:07:33,174 - main - INFO - Included router: routers.role_management.router
2026-05-02 06:07:33,217 - main - INFO - Included router: routers.service_testimonials.router
2026-05-02 06:07:33,236 - main - INFO - Included router: routers.settings.router
2026-05-02 06:07:33,479 - main - INFO - Included router: routers.site_settings.router
2026-05-02 06:07:33,526 - main - INFO - Included router: routers.smtp_settings.router
2026-05-02 06:07:33,566 - main - INFO - Included router: routers.storage.router
2026-05-02 06:07:33,671 - main - INFO - Included router: routers.support_chat.router
2026-05-02 06:07:33,712 - main - INFO - Included router: routers.support_departments.router
2026-05-02 06:07:33,755 - main - INFO - Included router: routers.support_seats.router
2026-05-02 06:07:33,764 - main - INFO - Included router: routers.ticket_notifications_sync.router
2026-05-02 06:07:33,799 - main - INFO - Included router: routers.ticket_summaries.router
2026-05-02 06:07:33,841 - main - INFO - Included router: routers.ticket_sync_states.router
2026-05-02 06:07:33,850 - main - INFO - Included router: routers.user.router
2026-05-02 06:07:33,892 - main - INFO - Included router: routers.user_profiles.router
2026-05-02 06:07:33,926 - main - INFO - Included router: routers.user_roles.router
2026-05-02 06:07:33,944 - main - INFO - Included router: routers.whmcs.router
2026-05-02 06:07:34,027 - main - INFO - Included router: routers.whmcs_admin.router
2026-05-02 06:07:34,075 - main - INFO - Included router: routers.whmcs_extra.router
2026-05-02 06:07:34,076 - main - INFO - === Application startup initiated ===
2026-05-02 06:07:34,076 - services.database - INFO - Ignore creating tables
2026-05-02 06:07:34,076 - services.mock_data - INFO - Ignore initialize data
2026-05-02 06:07:34,076 - services.auth - INFO - Ignore initialize admin
2026-05-02 06:07:34,077 - main - INFO - === Application startup completed successfully ===
2026-05-02 06:07:42,916 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 06:07:42,916 - core.database - WARNING - Database session maker not available, attempting lazy initialization...
2026-05-02 06:07:42,916 - core.database - WARNING - Database not initialized, attempting lazy initialization...
2026-05-02 06:07:42,916 - core.database - INFO - Starting database initialization...
2026-05-02 06:07:42,916 - core.config - DEBUG - Read dynamic attribute database_url from environment variable DATABASE_URL
2026-05-02 06:07:42,916 - core.database - INFO - Normalizing database URL for async compatibility...
2026-05-02 06:07:42,917 - core.database - INFO - Creating async database engine...
2026-05-02 06:07:42,917 - core.database - INFO - Using QueuePool with connection pooling for non-Lambda environment
2026-05-02 06:07:43,208 - core.database - INFO - Database engine created successfully
2026-05-02 06:07:43,208 - core.database - INFO - Creating async session maker...
2026-05-02 06:07:43,208 - core.database - INFO - Async session maker created successfully
2026-05-02 06:07:43,208 - core.database - INFO - Database connection initialized successfully
2026-05-02 06:07:43,208 - core.database - DEBUG - [DB_OP] Starting create_tables
2026-05-02 06:07:43,209 - core.database - INFO - 🔧 Starting table creation...
2026-05-02 06:07:43,217 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 06:07:43,217 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-02 06:07:43,218 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 06:07:43,223 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-02 06:07:43,225 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 06:07:43,225 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-02 06:07:43,225 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 06:07:44,630 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 06:07:44,631 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.4063s
2026-05-02 06:07:44,632 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 06:07:44,632 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.4156s
2026-05-02 06:07:46,130 - core.database - INFO - Tables initialized successfully
2026-05-02 06:07:46,130 - core.database - DEBUG - [DB_OP] Create tables completed in 2.9213s
2026-05-02 06:07:46,193 - core.database - INFO - Lazy database initialization completed successfully
2026-05-02 06:07:46,194 - core.database - DEBUG - [DB_OP] Database session created successfully in 3.2781s
2026-05-02 06:07:46,637 - core.database - DEBUG - [DB_OP] Database session cleanup after 3.7218s
2026-05-02 06:08:42,899 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 06:08:42,899 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 06:08:43,348 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4494s
2026-05-02 06:09:42,892 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 06:09:42,893 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0006s
2026-05-02 06:09:43,341 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4486s
2026-05-02 06:10:44,752 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 06:10:44,752 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 06:10:45,075 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3235s
2026-05-02 06:11:43,400 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 06:11:43,401 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 06:11:43,718 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3179s
2026-05-02 06:12:00,920 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 06:12:00,920 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-05-02 06:12:00,921 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-02 06:12:00,922 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 06:12:00,922 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-02 06:12:00,922 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 06:12:00,924 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 06:12:00,924 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-02 06:12:00,924 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 06:12:01,236 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3166s
2026-05-02 06:12:01,299 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 06:12:01,299 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3774s
2026-05-02 06:12:01,308 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 06:12:01,308 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3847s
2026-05-02 06:12:05,424 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 06:12:05,425 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-02 06:12:05,428 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 06:12:05,429 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-02 06:12:05,429 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 06:12:05,430 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-02 06:12:05,431 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 06:12:05,431 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-02 06:12:05,431 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 06:12:05,749 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3242s
2026-05-02 06:12:05,813 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 06:12:05,814 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3857s
2026-05-02 06:12:05,817 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 06:12:05,818 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3869s
2026-05-02 06:13:05,432 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 06:13:05,433 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0006s
2026-05-02 06:13:05,751 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3185s
2026-05-02 06:13:06,484 - services.database - DEBUG - [DB_OP] Starting database close
2026-05-02 06:13:06,681 - core.database - INFO - Database connection closed and engine disposed
2026-05-02 06:13:06,682 - services.database - INFO - Database connections closed
2026-05-02 06:13:06,682 - services.database - DEBUG - [DB_OP] Database close completed in 0.1979s