2026-05-02 05:40:36,740 - main - INFO - === Logging system initialized ===
2026-05-02 05:40:36,741 - main - INFO - Log file: logs/app_20260502_054036.log
2026-05-02 05:40:36,741 - main - INFO - Log level: INFO
2026-05-02 05:40:36,741 - main - INFO - Timestamp: 20260502_054036
2026-05-02 05:40:36,799 - main - INFO - Included router: routers.admin_dashboard.router
2026-05-02 05:40:36,842 - main - INFO - Included router: routers.agent_availability.router
2026-05-02 05:40:37,592 - main - INFO - Included router: routers.ai_ticket_summary.router
2026-05-02 05:40:37,611 - main - INFO - Included router: routers.aihub.router
2026-05-02 05:40:37,622 - main - INFO - Included router: routers.auth.router
2026-05-02 05:40:37,665 - main - INFO - Included router: routers.chat_analytics_daily.router
2026-05-02 05:40:37,705 - main - INFO - Included router: routers.chat_attachments.router
2026-05-02 05:40:37,768 - main - INFO - Included router: routers.chat_branding.router
2026-05-02 05:40:37,782 - main - INFO - Included router: routers.chat_branding_api.router
2026-05-02 05:40:37,830 - main - INFO - Included router: routers.chat_conversations.router
2026-05-02 05:40:37,945 - main - INFO - Included router: routers.chat_messages.router
2026-05-02 05:40:37,985 - main - INFO - Included router: routers.chat_routing_rules.router
2026-05-02 05:40:38,003 - main - INFO - Included router: routers.contact.router
2026-05-02 05:40:38,079 - main - INFO - Included router: routers.contact_inquiries.router
2026-05-02 05:40:38,091 - main - INFO - Included router: routers.health.router
2026-05-02 05:40:38,132 - main - INFO - Included router: routers.kb_article_feedback.router
2026-05-02 05:40:38,171 - main - INFO - Included router: routers.kb_articles.router
2026-05-02 05:40:38,213 - main - INFO - Included router: routers.notification_preferences.router
2026-05-02 05:40:38,257 - main - INFO - Included router: routers.notifications.router
2026-05-02 05:40:38,260 - main - INFO - Included router: routers.notifications_extras.router
2026-05-02 05:40:38,358 - main - INFO - Included router: routers.oauth.router
2026-05-02 05:40:38,403 - main - INFO - Included router: routers.plans.router
2026-05-02 05:40:38,427 - main - INFO - Included router: routers.role_management.router
2026-05-02 05:40:38,475 - main - INFO - Included router: routers.service_testimonials.router
2026-05-02 05:40:38,495 - main - INFO - Included router: routers.settings.router
2026-05-02 05:40:38,739 - main - INFO - Included router: routers.site_settings.router
2026-05-02 05:40:38,775 - main - INFO - Included router: routers.smtp_settings.router
2026-05-02 05:40:38,806 - main - INFO - Included router: routers.storage.router
2026-05-02 05:40:38,906 - main - INFO - Included router: routers.support_chat.router
2026-05-02 05:40:38,942 - main - INFO - Included router: routers.support_departments.router
2026-05-02 05:40:38,985 - main - INFO - Included router: routers.support_seats.router
2026-05-02 05:40:38,994 - main - INFO - Included router: routers.ticket_notifications_sync.router
2026-05-02 05:40:39,038 - main - INFO - Included router: routers.ticket_summaries.router
2026-05-02 05:40:39,095 - main - INFO - Included router: routers.ticket_sync_states.router
2026-05-02 05:40:39,104 - main - INFO - Included router: routers.user.router
2026-05-02 05:40:39,148 - main - INFO - Included router: routers.user_profiles.router
2026-05-02 05:40:39,181 - main - INFO - Included router: routers.user_roles.router
2026-05-02 05:40:39,198 - main - INFO - Included router: routers.whmcs.router
2026-05-02 05:40:39,252 - main - INFO - Included router: routers.whmcs_admin.router
2026-05-02 05:40:39,286 - main - INFO - Included router: routers.whmcs_extra.router
2026-05-02 05:40:39,288 - main - INFO - === Application startup initiated ===
2026-05-02 05:40:39,288 - services.database - INFO - Ignore creating tables
2026-05-02 05:40:39,288 - services.mock_data - INFO - Ignore initialize data
2026-05-02 05:40:39,288 - services.auth - INFO - Ignore initialize admin
2026-05-02 05:40:39,288 - main - INFO - === Application startup completed successfully ===
2026-05-02 05:40:46,347 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:40:46,347 - core.database - WARNING - Database session maker not available, attempting lazy initialization...
2026-05-02 05:40:46,347 - core.database - WARNING - Database not initialized, attempting lazy initialization...
2026-05-02 05:40:46,347 - core.database - INFO - Starting database initialization...
2026-05-02 05:40:46,347 - core.config - DEBUG - Read dynamic attribute database_url from environment variable DATABASE_URL
2026-05-02 05:40:46,347 - core.database - INFO - Normalizing database URL for async compatibility...
2026-05-02 05:40:46,348 - core.database - INFO - Creating async database engine...
2026-05-02 05:40:46,348 - core.database - INFO - Using QueuePool with connection pooling for non-Lambda environment
2026-05-02 05:40:46,493 - core.database - INFO - Database engine created successfully
2026-05-02 05:40:46,494 - core.database - INFO - Creating async session maker...
2026-05-02 05:40:46,494 - core.database - INFO - Async session maker created successfully
2026-05-02 05:40:46,494 - core.database - INFO - Database connection initialized successfully
2026-05-02 05:40:46,494 - core.database - DEBUG - [DB_OP] Starting create_tables
2026-05-02 05:40:46,494 - core.database - INFO - 🔧 Starting table creation...
2026-05-02 05:40:46,499 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:40:46,499 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-02 05:40:46,499 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 05:40:46,506 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-02 05:40:46,507 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:40:46,507 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0001s
2026-05-02 05:40:46,508 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 05:40:47,921 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 05:40:47,922 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.4150s
2026-05-02 05:40:47,924 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 05:40:47,924 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.4256s
2026-05-02 05:40:49,453 - core.database - INFO - Tables initialized successfully
2026-05-02 05:40:49,454 - core.database - DEBUG - [DB_OP] Create tables completed in 2.9598s
2026-05-02 05:40:49,517 - core.database - INFO - Lazy database initialization completed successfully
2026-05-02 05:40:49,518 - core.database - DEBUG - [DB_OP] Database session created successfully in 3.1714s
2026-05-02 05:40:49,963 - core.database - DEBUG - [DB_OP] Database session cleanup after 3.6164s
2026-05-02 05:41:46,331 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:41:46,331 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 05:41:46,779 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4485s
2026-05-02 05:42:46,341 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:42:46,341 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 05:42:46,787 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4464s
2026-05-02 05:43:14,509 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:43:14,510 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-02 05:43:14,511 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-02 05:43:14,512 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:43:14,512 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-05-02 05:43:14,513 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 05:43:14,514 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:43:14,514 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-02 05:43:14,515 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 05:43:14,825 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3156s
2026-05-02 05:43:14,897 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 05:43:14,898 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3863s
2026-05-02 05:43:15,024 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 05:43:15,025 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.5104s
2026-05-02 05:43:20,821 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:43:20,821 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-05-02 05:43:20,831 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-02 05:43:20,832 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:43:20,832 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-02 05:43:20,833 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 05:43:20,834 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:43:20,834 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-02 05:43:20,834 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 05:43:21,136 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3153s
2026-05-02 05:43:21,214 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 05:43:21,214 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3802s
2026-05-02 05:43:21,214 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 05:43:21,215 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3828s
2026-05-02 05:44:18,741 - services.database - DEBUG - [DB_OP] Starting database close
2026-05-02 05:44:18,952 - core.database - INFO - Database connection closed and engine disposed
2026-05-02 05:44:18,952 - services.database - INFO - Database connections closed
2026-05-02 05:44:18,953 - services.database - DEBUG - [DB_OP] Database close completed in 0.2116s