2026-05-01 21:49:43,585 - main - INFO - === Logging system initialized ===
2026-05-01 21:49:43,585 - main - INFO - Log file: logs/app_20260501_214943.log
2026-05-01 21:49:43,585 - main - INFO - Log level: INFO
2026-05-01 21:49:43,585 - main - INFO - Timestamp: 20260501_214943
2026-05-01 21:49:43,867 - main - INFO - Included router: routers.admin_dashboard.router
2026-05-01 21:49:43,918 - main - INFO - Included router: routers.agent_availability.router
2026-05-01 21:49:47,561 - main - INFO - Included router: routers.ai_ticket_summary.router
2026-05-01 21:49:47,618 - main - INFO - Included router: routers.aihub.router
2026-05-01 21:49:47,638 - main - INFO - Included router: routers.auth.router
2026-05-01 21:49:47,701 - main - INFO - Included router: routers.chat_analytics_daily.router
2026-05-01 21:49:47,762 - main - INFO - Included router: routers.chat_attachments.router
2026-05-01 21:49:47,852 - main - INFO - Included router: routers.chat_branding.router
2026-05-01 21:49:47,882 - main - INFO - Included router: routers.chat_branding_api.router
2026-05-01 21:49:47,977 - main - INFO - Included router: routers.chat_conversations.router
2026-05-01 21:49:48,120 - main - INFO - Included router: routers.chat_messages.router
2026-05-01 21:49:48,415 - main - INFO - Included router: routers.chat_routing_rules.router
2026-05-01 21:49:48,462 - main - INFO - Included router: routers.contact.router
2026-05-01 21:49:48,520 - main - INFO - Included router: routers.contact_inquiries.router
2026-05-01 21:49:48,528 - main - INFO - Included router: routers.health.router
2026-05-01 21:49:48,589 - main - INFO - Included router: routers.kb_articles.router
2026-05-01 21:49:48,650 - main - INFO - Included router: routers.notification_preferences.router
2026-05-01 21:49:48,717 - main - INFO - Included router: routers.notifications.router
2026-05-01 21:49:48,727 - main - INFO - Included router: routers.notifications_extras.router
2026-05-01 21:49:48,848 - main - INFO - Included router: routers.oauth.router
2026-05-01 21:49:48,908 - main - INFO - Included router: routers.plans.router
2026-05-01 21:49:48,935 - main - INFO - Included router: routers.role_management.router
2026-05-01 21:49:48,961 - main - INFO - Included router: routers.settings.router
2026-05-01 21:49:49,015 - main - INFO - Included router: routers.site_settings.router
2026-05-01 21:49:49,088 - main - INFO - Included router: routers.smtp_settings.router
2026-05-01 21:49:49,137 - main - INFO - Included router: routers.storage.router
2026-05-01 21:49:49,366 - main - INFO - Included router: routers.support_chat.router
2026-05-01 21:49:49,414 - main - INFO - Included router: routers.support_departments.router
2026-05-01 21:49:49,467 - main - INFO - Included router: routers.support_seats.router
2026-05-01 21:49:49,481 - main - INFO - Included router: routers.ticket_notifications_sync.router
2026-05-01 21:49:49,539 - main - INFO - Included router: routers.ticket_summaries.router
2026-05-01 21:49:49,606 - main - INFO - Included router: routers.ticket_sync_states.router
2026-05-01 21:49:49,627 - main - INFO - Included router: routers.user.router
2026-05-01 21:49:49,684 - main - INFO - Included router: routers.user_profiles.router
2026-05-01 21:49:49,740 - main - INFO - Included router: routers.user_roles.router
2026-05-01 21:49:49,761 - main - INFO - Included router: routers.whmcs.router
2026-05-01 21:49:49,860 - main - INFO - Included router: routers.whmcs_admin.router
2026-05-01 21:49:49,911 - main - INFO - Included router: routers.whmcs_extra.router
2026-05-01 21:49:49,913 - main - INFO - === Application startup initiated ===
2026-05-01 21:49:49,914 - services.database - INFO - Ignore creating tables
2026-05-01 21:49:49,914 - services.mock_data - INFO - Ignore initialize data
2026-05-01 21:49:49,914 - services.auth - INFO - Ignore initialize admin
2026-05-01 21:49:49,914 - main - INFO - === Application startup completed successfully ===
2026-05-01 21:49:56,199 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:49:56,199 - core.database - WARNING - Database session maker not available, attempting lazy initialization...
2026-05-01 21:49:56,199 - core.database - WARNING - Database not initialized, attempting lazy initialization...
2026-05-01 21:49:56,199 - core.database - INFO - Starting database initialization...
2026-05-01 21:49:56,199 - core.config - DEBUG - Read dynamic attribute database_url from environment variable DATABASE_URL
2026-05-01 21:49:56,199 - core.database - INFO - Normalizing database URL for async compatibility...
2026-05-01 21:49:56,200 - core.database - INFO - Creating async database engine...
2026-05-01 21:49:56,200 - core.database - INFO - Using QueuePool with connection pooling for non-Lambda environment
2026-05-01 21:49:56,263 - core.database - INFO - Database engine created successfully
2026-05-01 21:49:56,264 - core.database - INFO - Creating async session maker...
2026-05-01 21:49:56,264 - core.database - INFO - Async session maker created successfully
2026-05-01 21:49:56,264 - core.database - INFO - Database connection initialized successfully
2026-05-01 21:49:56,264 - core.database - DEBUG - [DB_OP] Starting create_tables
2026-05-01 21:49:56,264 - core.database - INFO - 🔧 Starting table creation...
2026-05-01 21:49:56,270 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-01 21:49:56,274 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:49:56,274 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-05-01 21:49:56,274 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 21:49:56,278 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:49:56,278 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-05-01 21:49:56,279 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 21:49:57,657 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 21:49:57,657 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.3837s
2026-05-01 21:49:57,658 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 21:49:57,658 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.3800s
2026-05-01 21:49:57,746 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-01 21:49:57,747 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:49:57,748 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-05-01 21:49:57,750 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:49:57,751 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-05-01 21:49:57,751 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 21:49:57,752 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:49:57,753 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-01 21:49:57,753 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 21:49:58,279 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 21:49:58,279 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.5290s
2026-05-01 21:49:58,326 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.5787s
2026-05-01 21:49:58,638 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 21:49:58,639 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.8861s
2026-05-01 21:49:59,161 - core.database - INFO - Tables initialized successfully
2026-05-01 21:49:59,162 - core.database - DEBUG - [DB_OP] Create tables completed in 2.8973s
2026-05-01 21:49:59,225 - core.database - INFO - Lazy database initialization completed successfully
2026-05-01 21:49:59,226 - core.database - DEBUG - [DB_OP] Database session created successfully in 3.0272s
2026-05-01 21:49:59,609 - core.database - DEBUG - [DB_OP] Database session cleanup after 3.4104s
2026-05-01 21:50:15,715 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:50:15,716 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 21:50:16,035 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3202s
2026-05-01 21:50:39,736 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:50:39,736 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-01 21:50:39,738 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:50:39,738 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-01 21:50:39,739 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 21:50:39,740 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:50:39,740 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-01 21:50:39,740 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 21:50:39,742 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-01 21:50:40,122 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 21:50:40,123 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3830s
2026-05-01 21:50:40,182 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4463s
2026-05-01 21:50:40,308 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 21:50:40,308 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.5704s
2026-05-01 21:50:58,731 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 21:50:58,731 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0007s
2026-05-01 21:50:59,052 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3214s
2026-05-01 21:51:04,495 - services.database - DEBUG - [DB_OP] Starting database close
2026-05-01 21:51:04,780 - core.database - INFO - Database connection closed and engine disposed
2026-05-01 21:51:04,780 - services.database - INFO - Database connections closed
2026-05-01 21:51:04,780 - services.database - DEBUG - [DB_OP] Database close completed in 0.2854s