2026-05-02 04:53:18,838 - main - INFO - === Logging system initialized ===
2026-05-02 04:53:18,838 - main - INFO - Log file: logs/app_20260502_045318.log
2026-05-02 04:53:18,838 - main - INFO - Log level: INFO
2026-05-02 04:53:18,838 - main - INFO - Timestamp: 20260502_045318
2026-05-02 04:53:18,911 - main - INFO - Included router: routers.admin_dashboard.router
2026-05-02 04:53:18,952 - main - INFO - Included router: routers.agent_availability.router
2026-05-02 04:53:19,748 - main - INFO - Included router: routers.ai_ticket_summary.router
2026-05-02 04:53:19,771 - main - INFO - Included router: routers.aihub.router
2026-05-02 04:53:19,785 - main - INFO - Included router: routers.auth.router
2026-05-02 04:53:19,836 - main - INFO - Included router: routers.chat_analytics_daily.router
2026-05-02 04:53:19,883 - main - INFO - Included router: routers.chat_attachments.router
2026-05-02 04:53:19,946 - main - INFO - Included router: routers.chat_branding.router
2026-05-02 04:53:19,959 - main - INFO - Included router: routers.chat_branding_api.router
2026-05-02 04:53:20,010 - main - INFO - Included router: routers.chat_conversations.router
2026-05-02 04:53:20,226 - main - INFO - Included router: routers.chat_messages.router
2026-05-02 04:53:20,273 - main - INFO - Included router: routers.chat_routing_rules.router
2026-05-02 04:53:20,300 - main - INFO - Included router: routers.contact.router
2026-05-02 04:53:20,346 - main - INFO - Included router: routers.contact_inquiries.router
2026-05-02 04:53:20,347 - main - INFO - Included router: routers.health.router
2026-05-02 04:53:20,389 - main - INFO - Included router: routers.kb_article_feedback.router
2026-05-02 04:53:20,431 - main - INFO - Included router: routers.kb_articles.router
2026-05-02 04:53:20,488 - main - INFO - Included router: routers.notification_preferences.router
2026-05-02 04:53:20,536 - main - INFO - Included router: routers.notifications.router
2026-05-02 04:53:20,541 - main - INFO - Included router: routers.notifications_extras.router
2026-05-02 04:53:20,626 - main - INFO - Included router: routers.oauth.router
2026-05-02 04:53:20,676 - main - INFO - Included router: routers.plans.router
2026-05-02 04:53:20,699 - main - INFO - Included router: routers.role_management.router
2026-05-02 04:53:20,725 - main - INFO - Included router: routers.settings.router
2026-05-02 04:53:20,762 - main - INFO - Included router: routers.site_settings.router
2026-05-02 04:53:20,793 - main - INFO - Included router: routers.smtp_settings.router
2026-05-02 04:53:20,919 - main - INFO - Included router: routers.storage.router
2026-05-02 04:53:21,022 - main - INFO - Included router: routers.support_chat.router
2026-05-02 04:53:21,083 - main - INFO - Included router: routers.support_departments.router
2026-05-02 04:53:21,124 - main - INFO - Included router: routers.support_seats.router
2026-05-02 04:53:21,131 - main - INFO - Included router: routers.ticket_notifications_sync.router
2026-05-02 04:53:21,166 - main - INFO - Included router: routers.ticket_summaries.router
2026-05-02 04:53:21,205 - main - INFO - Included router: routers.ticket_sync_states.router
2026-05-02 04:53:21,216 - main - INFO - Included router: routers.user.router
2026-05-02 04:53:21,257 - main - INFO - Included router: routers.user_profiles.router
2026-05-02 04:53:21,293 - main - INFO - Included router: routers.user_roles.router
2026-05-02 04:53:21,312 - main - INFO - Included router: routers.whmcs.router
2026-05-02 04:53:21,368 - main - INFO - Included router: routers.whmcs_admin.router
2026-05-02 04:53:21,404 - main - INFO - Included router: routers.whmcs_extra.router
2026-05-02 04:53:21,405 - main - INFO - === Application startup initiated ===
2026-05-02 04:53:21,405 - services.database - INFO - Ignore creating tables
2026-05-02 04:53:21,405 - services.mock_data - INFO - Ignore initialize data
2026-05-02 04:53:21,405 - services.auth - INFO - Ignore initialize admin
2026-05-02 04:53:21,405 - main - INFO - === Application startup completed successfully ===
2026-05-02 04:53:28,694 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 04:53:28,694 - core.database - WARNING - Database session maker not available, attempting lazy initialization...
2026-05-02 04:53:28,695 - core.database - WARNING - Database not initialized, attempting lazy initialization...
2026-05-02 04:53:28,695 - core.database - INFO - Starting database initialization...
2026-05-02 04:53:28,695 - core.config - DEBUG - Read dynamic attribute database_url from environment variable DATABASE_URL
2026-05-02 04:53:28,695 - core.database - INFO - Normalizing database URL for async compatibility...
2026-05-02 04:53:28,696 - core.database - INFO - Creating async database engine...
2026-05-02 04:53:28,696 - core.database - INFO - Using QueuePool with connection pooling for non-Lambda environment
2026-05-02 04:53:28,742 - core.database - INFO - Database engine created successfully
2026-05-02 04:53:28,742 - core.database - INFO - Creating async session maker...
2026-05-02 04:53:28,742 - core.database - INFO - Async session maker created successfully
2026-05-02 04:53:28,742 - core.database - INFO - Database connection initialized successfully
2026-05-02 04:53:28,742 - core.database - DEBUG - [DB_OP] Starting create_tables
2026-05-02 04:53:28,743 - core.database - INFO - 🔧 Starting table creation...
2026-05-02 04:53:28,747 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-02 04:53:28,751 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 04:53:28,751 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 04:53:28,752 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 04:53:28,755 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 04:53:28,756 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-02 04:53:28,756 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 04:53:30,262 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 04:53:30,262 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.5068s
2026-05-02 04:53:30,263 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 04:53:30,263 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.5126s
2026-05-02 04:53:31,646 - core.database - INFO - Tables initialized successfully
2026-05-02 04:53:31,647 - core.database - DEBUG - [DB_OP] Create tables completed in 2.9043s
2026-05-02 04:53:31,710 - core.database - INFO - Lazy database initialization completed successfully
2026-05-02 04:53:31,710 - core.database - DEBUG - [DB_OP] Database session created successfully in 3.0160s
2026-05-02 04:53:32,156 - core.database - DEBUG - [DB_OP] Database session cleanup after 3.4624s
2026-05-02 04:54:28,703 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 04:54:28,703 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 04:54:29,151 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4484s
2026-05-02 04:55:28,711 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 04:55:28,712 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-05-02 04:55:29,155 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4438s
2026-05-02 04:56:29,368 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 04:56:29,368 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-02 04:56:29,688 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3205s
2026-05-02 04:57:01,020 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 04:57:01,020 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-02 04:57:01,023 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-02 04:57:01,024 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 04:57:01,024 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-02 04:57:01,025 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 04:57:01,026 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 04:57:01,026 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-02 04:57:01,027 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 04:57:01,341 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3212s
2026-05-02 04:57:01,405 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 04:57:01,406 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3794s
2026-05-02 04:57:01,529 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 04:57:01,530 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.5056s
2026-05-02 04:58:02,704 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 04:58:02,704 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-02 04:58:03,025 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3214s
2026-05-02 04:59:01,033 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 04:59:01,033 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-05-02 04:59:01,476 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4430s
2026-05-02 05:00:04,493 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:00:04,493 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-02 05:00:04,810 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3173s
2026-05-02 05:00:19,291 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:00:19,291 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-02 05:00:19,292 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-02 05:00:19,294 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:00:19,294 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-02 05:00:19,294 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 05:00:19,295 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:00:19,296 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-02 05:00:19,296 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 05:00:19,673 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 05:00:19,674 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3789s
2026-05-02 05:00:19,675 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 05:00:19,675 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3817s
2026-05-02 05:00:19,739 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4482s
2026-05-02 05:00:33,205 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:00:33,205 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 05:00:33,208 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-02 05:00:33,210 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:00:33,210 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-02 05:00:33,211 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 05:00:33,213 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:00:33,213 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-02 05:00:33,214 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 05:00:33,593 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 05:00:33,594 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3843s
2026-05-02 05:00:33,595 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 05:00:33,596 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3824s
2026-05-02 05:00:33,646 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4413s
2026-05-02 05:01:21,307 - services.database - DEBUG - [DB_OP] Starting database close
2026-05-02 05:01:21,508 - core.database - INFO - Database connection closed and engine disposed
2026-05-02 05:01:21,508 - services.database - INFO - Database connections closed
2026-05-02 05:01:21,509 - services.database - DEBUG - [DB_OP] Database close completed in 0.2016s