2026-05-02 05:22:24,645 - main - INFO - === Logging system initialized ===
2026-05-02 05:22:24,646 - main - INFO - Log file: logs/app_20260502_052224.log
2026-05-02 05:22:24,646 - main - INFO - Log level: INFO
2026-05-02 05:22:24,646 - main - INFO - Timestamp: 20260502_052224
2026-05-02 05:22:24,708 - main - INFO - Included router: routers.admin_dashboard.router
2026-05-02 05:22:24,753 - main - INFO - Included router: routers.agent_availability.router
2026-05-02 05:22:25,535 - main - INFO - Included router: routers.ai_ticket_summary.router
2026-05-02 05:22:25,561 - main - INFO - Included router: routers.aihub.router
2026-05-02 05:22:25,576 - main - INFO - Included router: routers.auth.router
2026-05-02 05:22:25,627 - main - INFO - Included router: routers.chat_analytics_daily.router
2026-05-02 05:22:25,672 - main - INFO - Included router: routers.chat_attachments.router
2026-05-02 05:22:25,739 - main - INFO - Included router: routers.chat_branding.router
2026-05-02 05:22:25,757 - main - INFO - Included router: routers.chat_branding_api.router
2026-05-02 05:22:25,811 - main - INFO - Included router: routers.chat_conversations.router
2026-05-02 05:22:25,980 - main - INFO - Included router: routers.chat_messages.router
2026-05-02 05:22:26,022 - main - INFO - Included router: routers.chat_routing_rules.router
2026-05-02 05:22:26,059 - main - INFO - Included router: routers.contact.router
2026-05-02 05:22:26,102 - main - INFO - Included router: routers.contact_inquiries.router
2026-05-02 05:22:26,104 - main - INFO - Included router: routers.health.router
2026-05-02 05:22:26,146 - main - INFO - Included router: routers.kb_article_feedback.router
2026-05-02 05:22:26,189 - main - INFO - Included router: routers.kb_articles.router
2026-05-02 05:22:26,233 - main - INFO - Included router: routers.notification_preferences.router
2026-05-02 05:22:26,293 - main - INFO - Included router: routers.notifications.router
2026-05-02 05:22:26,298 - main - INFO - Included router: routers.notifications_extras.router
2026-05-02 05:22:26,387 - main - INFO - Included router: routers.oauth.router
2026-05-02 05:22:26,433 - main - INFO - Included router: routers.plans.router
2026-05-02 05:22:26,457 - main - INFO - Included router: routers.role_management.router
2026-05-02 05:22:26,677 - main - INFO - Included router: routers.service_testimonials.router
2026-05-02 05:22:26,702 - main - INFO - Included router: routers.settings.router
2026-05-02 05:22:26,910 - main - INFO - Included router: routers.site_settings.router
2026-05-02 05:22:26,942 - main - INFO - Included router: routers.smtp_settings.router
2026-05-02 05:22:26,979 - main - INFO - Included router: routers.storage.router
2026-05-02 05:22:27,086 - main - INFO - Included router: routers.support_chat.router
2026-05-02 05:22:27,337 - main - INFO - Included router: routers.support_departments.router
2026-05-02 05:22:27,379 - main - INFO - Included router: routers.support_seats.router
2026-05-02 05:22:27,387 - main - INFO - Included router: routers.ticket_notifications_sync.router
2026-05-02 05:22:27,424 - main - INFO - Included router: routers.ticket_summaries.router
2026-05-02 05:22:27,464 - main - INFO - Included router: routers.ticket_sync_states.router
2026-05-02 05:22:27,472 - main - INFO - Included router: routers.user.router
2026-05-02 05:22:27,518 - main - INFO - Included router: routers.user_profiles.router
2026-05-02 05:22:27,559 - main - INFO - Included router: routers.user_roles.router
2026-05-02 05:22:27,578 - main - INFO - Included router: routers.whmcs.router
2026-05-02 05:22:27,637 - main - INFO - Included router: routers.whmcs_admin.router
2026-05-02 05:22:27,676 - main - INFO - Included router: routers.whmcs_extra.router
2026-05-02 05:22:27,678 - main - INFO - === Application startup initiated ===
2026-05-02 05:22:27,678 - services.database - INFO - Ignore creating tables
2026-05-02 05:22:27,678 - services.mock_data - INFO - Ignore initialize data
2026-05-02 05:22:27,678 - services.auth - INFO - Ignore initialize admin
2026-05-02 05:22:27,678 - main - INFO - === Application startup completed successfully ===
2026-05-02 05:22:35,988 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:22:35,988 - core.database - WARNING - Database session maker not available, attempting lazy initialization...
2026-05-02 05:22:35,988 - core.database - WARNING - Database not initialized, attempting lazy initialization...
2026-05-02 05:22:35,988 - core.database - INFO - Starting database initialization...
2026-05-02 05:22:35,989 - core.config - DEBUG - Read dynamic attribute database_url from environment variable DATABASE_URL
2026-05-02 05:22:35,989 - core.database - INFO - Normalizing database URL for async compatibility...
2026-05-02 05:22:35,990 - core.database - INFO - Creating async database engine...
2026-05-02 05:22:35,990 - core.database - INFO - Using QueuePool with connection pooling for non-Lambda environment
2026-05-02 05:22:36,192 - core.database - INFO - Database engine created successfully
2026-05-02 05:22:36,192 - core.database - INFO - Creating async session maker...
2026-05-02 05:22:36,192 - core.database - INFO - Async session maker created successfully
2026-05-02 05:22:36,193 - core.database - INFO - Database connection initialized successfully
2026-05-02 05:22:36,193 - core.database - DEBUG - [DB_OP] Starting create_tables
2026-05-02 05:22:36,193 - core.database - INFO - 🔧 Starting table creation...
2026-05-02 05:22:36,199 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-02 05:22:36,206 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:22:36,206 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-05-02 05:22:36,206 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 05:22:36,210 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:22:36,210 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-02 05:22:36,211 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 05:22:37,640 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 05:22:37,641 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.4352s
2026-05-02 05:22:37,642 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 05:22:37,642 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.4319s
2026-05-02 05:22:39,173 - core.database - INFO - Tables initialized successfully
2026-05-02 05:22:39,174 - core.database - DEBUG - [DB_OP] Create tables completed in 2.9810s
2026-05-02 05:22:39,238 - core.database - INFO - Lazy database initialization completed successfully
2026-05-02 05:22:39,238 - core.database - DEBUG - [DB_OP] Database session created successfully in 3.2502s
2026-05-02 05:22:39,687 - core.database - DEBUG - [DB_OP] Database session cleanup after 3.6990s
2026-05-02 05:23:18,533 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:23:18,533 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-05-02 05:23:18,534 - routers.service_testimonials - DEBUG - Querying service_testimonialss: query=None, sort=None, skip=0, limit=200, fields=None
2026-05-02 05:23:19,110 - routers.service_testimonials - DEBUG - Found 5 service_testimonialss
2026-05-02 05:23:19,111 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.5775s
2026-05-02 05:23:35,987 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:23:35,988 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 05:23:36,434 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4466s
2026-05-02 05:23:42,736 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:23:42,737 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-05-02 05:23:42,737 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 05:23:43,120 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 05:23:43,121 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3845s
2026-05-02 05:24:42,756 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:24:42,756 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-02 05:24:43,140 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3845s
2026-05-02 05:25:52,472 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:25:52,472 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 05:25:52,791 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3199s
2026-05-02 05:26:02,991 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:26:02,991 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0006s
2026-05-02 05:26:02,993 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-02 05:26:02,994 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:26:02,994 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-02 05:26:02,995 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 05:26:02,996 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:26:02,996 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-02 05:26:02,996 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 05:26:03,310 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3192s
2026-05-02 05:26:03,377 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 05:26:03,378 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3840s
2026-05-02 05:26:03,503 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 05:26:03,503 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.5075s
2026-05-02 05:26:41,602 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:26:41,602 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 05:26:41,604 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-02 05:26:41,605 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:26:41,605 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-02 05:26:41,605 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 05:26:41,606 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:26:41,606 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-02 05:26:41,607 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 05:26:41,922 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3200s
2026-05-02 05:26:41,987 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 05:26:41,988 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3815s
2026-05-02 05:26:41,989 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 05:26:41,989 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3842s
2026-05-02 05:26:47,011 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:26:47,011 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-02 05:26:47,329 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3185s
2026-05-02 05:26:53,339 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:26:53,339 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 05:26:53,348 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-02 05:26:53,353 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:26:53,353 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-05-02 05:26:53,353 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 05:26:53,357 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:26:53,357 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-05-02 05:26:53,357 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 05:26:53,661 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3222s
2026-05-02 05:26:53,737 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 05:26:53,738 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3816s
2026-05-02 05:26:53,739 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 05:26:53,739 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3869s
2026-05-02 05:27:04,691 - services.database - DEBUG - [DB_OP] Starting database close
2026-05-02 05:27:04,892 - core.database - INFO - Database connection closed and engine disposed
2026-05-02 05:27:04,893 - services.database - INFO - Database connections closed
2026-05-02 05:27:04,893 - services.database - DEBUG - [DB_OP] Database close completed in 0.2019s