2026-05-01 06:35:49,454 - main - INFO - === Logging system initialized ===
2026-05-01 06:35:49,454 - main - INFO - Log file: logs/app_20260501_063549.log
2026-05-01 06:35:49,455 - main - INFO - Log level: INFO
2026-05-01 06:35:49,455 - main - INFO - Timestamp: 20260501_063549
2026-05-01 06:35:49,806 - main - INFO - Included router: routers.admin_dashboard.router
2026-05-01 06:35:49,867 - main - INFO - Included router: routers.agent_availability.router
2026-05-01 06:35:50,875 - main - INFO - Included router: routers.ai_ticket_summary.router
2026-05-01 06:35:50,900 - main - INFO - Included router: routers.aihub.router
2026-05-01 06:35:50,922 - main - INFO - Included router: routers.auth.router
2026-05-01 06:35:50,977 - main - INFO - Included router: routers.chat_analytics_daily.router
2026-05-01 06:35:51,025 - main - INFO - Included router: routers.chat_attachments.router
2026-05-01 06:35:51,100 - main - INFO - Included router: routers.chat_branding.router
2026-05-01 06:35:51,119 - main - INFO - Included router: routers.chat_branding_api.router
2026-05-01 06:35:51,176 - main - INFO - Included router: routers.chat_conversations.router
2026-05-01 06:35:51,335 - main - INFO - Included router: routers.chat_messages.router
2026-05-01 06:35:51,385 - main - INFO - Included router: routers.chat_routing_rules.router
2026-05-01 06:35:51,421 - main - INFO - Included router: routers.contact.router
2026-05-01 06:35:51,476 - main - INFO - Included router: routers.contact_inquiries.router
2026-05-01 06:35:51,478 - main - INFO - Included router: routers.health.router
2026-05-01 06:35:51,531 - main - INFO - Included router: routers.kb_articles.router
2026-05-01 06:35:51,581 - main - INFO - Included router: routers.notification_preferences.router
2026-05-01 06:35:51,641 - main - INFO - Included router: routers.notifications.router
2026-05-01 06:35:51,702 - main - INFO - Included router: routers.plans.router
2026-05-01 06:35:51,725 - main - INFO - Included router: routers.settings.router
2026-05-01 06:35:51,768 - main - INFO - Included router: routers.site_settings.router
2026-05-01 06:35:51,822 - main - INFO - Included router: routers.smtp_settings.router
2026-05-01 06:35:51,866 - main - INFO - Included router: routers.storage.router
2026-05-01 06:35:52,007 - main - INFO - Included router: routers.support_chat.router
2026-05-01 06:35:52,203 - main - INFO - Included router: routers.support_departments.router
2026-05-01 06:35:52,260 - main - INFO - Included router: routers.support_seats.router
2026-05-01 06:35:52,270 - main - INFO - Included router: routers.ticket_notifications_sync.router
2026-05-01 06:35:52,310 - main - INFO - Included router: routers.ticket_summaries.router
2026-05-01 06:35:52,352 - main - INFO - Included router: routers.ticket_sync_states.router
2026-05-01 06:35:52,364 - main - INFO - Included router: routers.user.router
2026-05-01 06:35:52,410 - main - INFO - Included router: routers.user_profiles.router
2026-05-01 06:35:52,457 - main - INFO - Included router: routers.user_roles.router
2026-05-01 06:35:52,555 - main - INFO - Included router: routers.whmcs.router
2026-05-01 06:35:52,614 - main - INFO - Included router: routers.whmcs_admin.router
2026-05-01 06:35:52,650 - main - INFO - Included router: routers.whmcs_extra.router
2026-05-01 06:35:52,652 - main - INFO - === Application startup initiated ===
2026-05-01 06:35:52,652 - services.database - INFO - Ignore creating tables
2026-05-01 06:35:52,652 - services.mock_data - INFO - Ignore initialize data
2026-05-01 06:35:52,652 - services.auth - INFO - Ignore initialize admin
2026-05-01 06:35:52,653 - main - INFO - === Application startup completed successfully ===
2026-05-01 06:36:00,105 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 06:36:00,106 - core.database - WARNING - Database session maker not available, attempting lazy initialization...
2026-05-01 06:36:00,106 - core.database - WARNING - Database not initialized, attempting lazy initialization...
2026-05-01 06:36:00,106 - core.database - INFO - Starting database initialization...
2026-05-01 06:36:00,106 - core.config - DEBUG - Read dynamic attribute database_url from environment variable DATABASE_URL
2026-05-01 06:36:00,106 - core.database - INFO - Normalizing database URL for async compatibility...
2026-05-01 06:36:00,107 - core.database - INFO - Creating async database engine...
2026-05-01 06:36:00,108 - core.database - INFO - Using QueuePool with connection pooling for non-Lambda environment
2026-05-01 06:36:00,155 - core.database - INFO - Database engine created successfully
2026-05-01 06:36:00,155 - core.database - INFO - Creating async session maker...
2026-05-01 06:36:00,155 - core.database - INFO - Async session maker created successfully
2026-05-01 06:36:00,155 - core.database - INFO - Database connection initialized successfully
2026-05-01 06:36:00,156 - core.database - DEBUG - [DB_OP] Starting create_tables
2026-05-01 06:36:00,156 - core.database - INFO - 🔧 Starting table creation...
2026-05-01 06:36:00,164 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 06:36:00,164 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 06:36:00,164 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 06:36:00,171 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 06:36:00,171 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0007s
2026-05-01 06:36:00,172 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 06:36:00,177 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-01 06:36:01,556 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 06:36:01,557 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.3932s
2026-05-01 06:36:01,561 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 06:36:01,561 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.3908s
2026-05-01 06:36:02,857 - core.database - INFO - Tables initialized successfully
2026-05-01 06:36:02,857 - core.database - DEBUG - [DB_OP] Create tables completed in 2.7016s
2026-05-01 06:36:02,921 - core.database - INFO - Lazy database initialization completed successfully
2026-05-01 06:36:02,922 - core.database - DEBUG - [DB_OP] Database session created successfully in 2.8168s
2026-05-01 06:36:03,369 - core.database - DEBUG - [DB_OP] Database session cleanup after 3.2634s
2026-05-01 06:36:06,567 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 06:36:06,567 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0008s
2026-05-01 06:36:06,570 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 06:36:06,571 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0006s
2026-05-01 06:36:06,571 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 06:36:06,573 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 06:36:06,574 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-01 06:36:06,574 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 06:36:06,576 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-01 06:36:06,953 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 06:36:06,954 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3802s
2026-05-01 06:36:07,020 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4536s
2026-05-01 06:36:07,147 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 06:36:07,148 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.5776s
2026-05-01 06:36:10,254 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-01 06:36:10,256 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 06:36:10,257 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-05-01 06:36:10,258 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 06:36:10,259 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-01 06:36:10,259 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 06:36:10,260 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 06:36:10,260 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-01 06:36:10,261 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 06:36:10,572 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3153s
2026-05-01 06:36:10,641 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 06:36:10,642 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3820s
2026-05-01 06:36:10,643 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 06:36:10,643 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3851s
2026-05-01 06:36:23,597 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 06:36:23,597 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 06:36:23,598 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-01 06:36:23,599 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 06:36:23,600 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-01 06:36:23,600 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 06:36:23,601 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 06:36:23,601 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0001s
2026-05-01 06:36:23,601 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 06:36:23,912 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3156s
2026-05-01 06:36:23,991 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 06:36:23,992 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3926s
2026-05-01 06:36:24,002 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 06:36:24,003 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4014s
2026-05-01 06:36:26,715 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 06:36:26,716 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-01 06:36:26,716 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 06:36:26,717 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 06:36:26,718 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-01 06:36:26,718 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 06:36:26,719 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-01 06:36:26,720 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 06:36:26,720 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 06:36:27,039 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3191s
2026-05-01 06:36:27,096 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 06:36:27,097 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3816s
2026-05-01 06:36:27,100 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 06:36:27,100 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3829s
2026-05-01 06:36:29,336 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 06:36:29,336 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 06:36:29,336 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"security"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 06:36:29,722 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 06:36:29,723 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3873s
2026-05-01 06:36:33,776 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/admin/smtp-settings
2026-05-01 06:36:35,488 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 06:36:35,488 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-01 06:36:35,489 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"pricing_layout"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 06:36:35,869 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 06:36:35,870 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3822s
2026-05-01 06:36:38,045 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 06:36:38,046 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 06:36:38,046 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"users_roles"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 06:36:38,433 - routers.site_settings - DEBUG - Found 1 site_settingss
2026-05-01 06:36:38,435 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3892s
2026-05-01 06:36:39,256 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-01 06:36:39,257 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-01 06:36:39,257 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-01 06:36:39,643 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-01 06:36:39,644 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3875s
2026-05-01 06:36:44,834 - services.database - DEBUG - [DB_OP] Starting database close
2026-05-01 06:36:45,035 - core.database - INFO - Database connection closed and engine disposed
2026-05-01 06:36:45,035 - services.database - INFO - Database connections closed
2026-05-01 06:36:45,035 - services.database - DEBUG - [DB_OP] Database close completed in 0.2014s