2026-05-02 05:27:48,454 - main - INFO - === Logging system initialized ===
2026-05-02 05:27:48,454 - main - INFO - Log file: logs/app_20260502_052748.log
2026-05-02 05:27:48,455 - main - INFO - Log level: INFO
2026-05-02 05:27:48,455 - main - INFO - Timestamp: 20260502_052748
2026-05-02 05:27:48,529 - main - INFO - Included router: routers.admin_dashboard.router
2026-05-02 05:27:48,576 - main - INFO - Included router: routers.agent_availability.router
2026-05-02 05:27:49,639 - main - INFO - Included router: routers.ai_ticket_summary.router
2026-05-02 05:27:49,659 - main - INFO - Included router: routers.aihub.router
2026-05-02 05:27:49,671 - main - INFO - Included router: routers.auth.router
2026-05-02 05:27:49,715 - main - INFO - Included router: routers.chat_analytics_daily.router
2026-05-02 05:27:49,759 - main - INFO - Included router: routers.chat_attachments.router
2026-05-02 05:27:49,821 - main - INFO - Included router: routers.chat_branding.router
2026-05-02 05:27:49,835 - main - INFO - Included router: routers.chat_branding_api.router
2026-05-02 05:27:49,885 - main - INFO - Included router: routers.chat_conversations.router
2026-05-02 05:27:49,995 - main - INFO - Included router: routers.chat_messages.router
2026-05-02 05:27:50,033 - main - INFO - Included router: routers.chat_routing_rules.router
2026-05-02 05:27:50,051 - main - INFO - Included router: routers.contact.router
2026-05-02 05:27:50,101 - main - INFO - Included router: routers.contact_inquiries.router
2026-05-02 05:27:50,105 - main - INFO - Included router: routers.health.router
2026-05-02 05:27:50,145 - main - INFO - Included router: routers.kb_article_feedback.router
2026-05-02 05:27:50,184 - main - INFO - Included router: routers.kb_articles.router
2026-05-02 05:27:50,226 - main - INFO - Included router: routers.notification_preferences.router
2026-05-02 05:27:50,271 - main - INFO - Included router: routers.notifications.router
2026-05-02 05:27:50,274 - main - INFO - Included router: routers.notifications_extras.router
2026-05-02 05:27:50,354 - main - INFO - Included router: routers.oauth.router
2026-05-02 05:27:50,401 - main - INFO - Included router: routers.plans.router
2026-05-02 05:27:50,424 - main - INFO - Included router: routers.role_management.router
2026-05-02 05:27:50,463 - main - INFO - Included router: routers.service_testimonials.router
2026-05-02 05:27:50,481 - main - INFO - Included router: routers.settings.router
2026-05-02 05:27:50,611 - main - INFO - Included router: routers.site_settings.router
2026-05-02 05:27:50,641 - main - INFO - Included router: routers.smtp_settings.router
2026-05-02 05:27:50,673 - main - INFO - Included router: routers.storage.router
2026-05-02 05:27:50,782 - main - INFO - Included router: routers.support_chat.router
2026-05-02 05:27:50,820 - main - INFO - Included router: routers.support_departments.router
2026-05-02 05:27:50,858 - main - INFO - Included router: routers.support_seats.router
2026-05-02 05:27:50,864 - main - INFO - Included router: routers.ticket_notifications_sync.router
2026-05-02 05:27:50,897 - main - INFO - Included router: routers.ticket_summaries.router
2026-05-02 05:27:50,933 - main - INFO - Included router: routers.ticket_sync_states.router
2026-05-02 05:27:50,940 - main - INFO - Included router: routers.user.router
2026-05-02 05:27:50,977 - main - INFO - Included router: routers.user_profiles.router
2026-05-02 05:27:51,010 - main - INFO - Included router: routers.user_roles.router
2026-05-02 05:27:51,026 - main - INFO - Included router: routers.whmcs.router
2026-05-02 05:27:51,098 - main - INFO - Included router: routers.whmcs_admin.router
2026-05-02 05:27:51,138 - main - INFO - Included router: routers.whmcs_extra.router
2026-05-02 05:27:51,139 - main - INFO - === Application startup initiated ===
2026-05-02 05:27:51,139 - services.database - INFO - Ignore creating tables
2026-05-02 05:27:51,139 - services.mock_data - INFO - Ignore initialize data
2026-05-02 05:27:51,139 - services.auth - INFO - Ignore initialize admin
2026-05-02 05:27:51,139 - main - INFO - === Application startup completed successfully ===
2026-05-02 05:27:58,713 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-02 05:27:58,715 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:27:58,715 - core.database - WARNING - Database session maker not available, attempting lazy initialization...
2026-05-02 05:27:58,715 - core.database - WARNING - Database not initialized, attempting lazy initialization...
2026-05-02 05:27:58,716 - core.database - INFO - Starting database initialization...
2026-05-02 05:27:58,716 - core.config - DEBUG - Read dynamic attribute database_url from environment variable DATABASE_URL
2026-05-02 05:27:58,716 - core.database - INFO - Normalizing database URL for async compatibility...
2026-05-02 05:27:58,717 - core.database - INFO - Creating async database engine...
2026-05-02 05:27:58,718 - core.database - INFO - Using QueuePool with connection pooling for non-Lambda environment
2026-05-02 05:27:58,967 - core.database - INFO - Database engine created successfully
2026-05-02 05:27:58,967 - core.database - INFO - Creating async session maker...
2026-05-02 05:27:58,968 - core.database - INFO - Async session maker created successfully
2026-05-02 05:27:58,968 - core.database - INFO - Database connection initialized successfully
2026-05-02 05:27:58,968 - core.database - DEBUG - [DB_OP] Starting create_tables
2026-05-02 05:27:58,968 - core.database - INFO - 🔧 Starting table creation...
2026-05-02 05:27:58,974 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:27:58,975 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-02 05:27:58,975 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 05:27:58,978 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:27:58,978 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-02 05:27:58,978 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 05:28:00,363 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 05:28:00,364 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.3860s
2026-05-02 05:28:00,365 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 05:28:00,365 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.3905s
2026-05-02 05:28:01,914 - core.database - INFO - Tables initialized successfully
2026-05-02 05:28:01,915 - core.database - DEBUG - [DB_OP] Create tables completed in 2.9467s
2026-05-02 05:28:01,978 - core.database - INFO - Lazy database initialization completed successfully
2026-05-02 05:28:01,979 - core.database - DEBUG - [DB_OP] Database session created successfully in 3.2642s
2026-05-02 05:28:02,440 - core.database - DEBUG - [DB_OP] Database session cleanup after 3.7248s
2026-05-02 05:28:58,749 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:28:58,749 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-05-02 05:28:59,206 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4570s
2026-05-02 05:29:28,837 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:29:28,837 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-05-02 05:29:28,838 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-02 05:29:28,839 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:29:28,840 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 05:29:28,841 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 05:29:28,844 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:29:28,845 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 05:29:28,845 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 05:29:29,222 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 05:29:29,223 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3836s
2026-05-02 05:29:29,227 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 05:29:29,227 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3834s
2026-05-02 05:29:29,283 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4456s
2026-05-02 05:29:41,657 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:29:41,657 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 05:29:41,690 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-02 05:29:41,694 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:29:41,695 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-02 05:29:41,696 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 05:29:41,698 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:29:41,698 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-02 05:29:41,698 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 05:29:41,973 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3160s
2026-05-02 05:29:42,077 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 05:29:42,078 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3832s
2026-05-02 05:29:42,208 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 05:29:42,209 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.5113s
2026-05-02 05:29:57,870 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:29:57,870 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-05-02 05:29:57,870 - routers.service_testimonials - DEBUG - Querying service_testimonialss: query=None, sort=None, skip=0, limit=200, fields=None
2026-05-02 05:29:58,376 - routers.service_testimonials - DEBUG - Found 5 service_testimonialss
2026-05-02 05:29:58,377 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.5072s
2026-05-02 05:30:32,120 - services.database - DEBUG - [DB_OP] Starting database close
2026-05-02 05:30:32,323 - core.database - INFO - Database connection closed and engine disposed
2026-05-02 05:30:32,324 - services.database - INFO - Database connections closed
2026-05-02 05:30:32,324 - services.database - DEBUG - [DB_OP] Database close completed in 0.2038s