2026-05-02 05:34:06,628 - main - INFO - === Logging system initialized ===
2026-05-02 05:34:06,628 - main - INFO - Log file: logs/app_20260502_053406.log
2026-05-02 05:34:06,629 - main - INFO - Log level: INFO
2026-05-02 05:34:06,629 - main - INFO - Timestamp: 20260502_053406
2026-05-02 05:34:06,695 - main - INFO - Included router: routers.admin_dashboard.router
2026-05-02 05:34:06,737 - main - INFO - Included router: routers.agent_availability.router
2026-05-02 05:34:07,581 - main - INFO - Included router: routers.ai_ticket_summary.router
2026-05-02 05:34:07,600 - main - INFO - Included router: routers.aihub.router
2026-05-02 05:34:07,613 - main - INFO - Included router: routers.auth.router
2026-05-02 05:34:07,657 - main - INFO - Included router: routers.chat_analytics_daily.router
2026-05-02 05:34:07,719 - main - INFO - Included router: routers.chat_attachments.router
2026-05-02 05:34:07,792 - main - INFO - Included router: routers.chat_branding.router
2026-05-02 05:34:07,807 - main - INFO - Included router: routers.chat_branding_api.router
2026-05-02 05:34:07,861 - main - INFO - Included router: routers.chat_conversations.router
2026-05-02 05:34:07,976 - main - INFO - Included router: routers.chat_messages.router
2026-05-02 05:34:08,019 - main - INFO - Included router: routers.chat_routing_rules.router
2026-05-02 05:34:08,054 - main - INFO - Included router: routers.contact.router
2026-05-02 05:34:08,095 - main - INFO - Included router: routers.contact_inquiries.router
2026-05-02 05:34:08,097 - main - INFO - Included router: routers.health.router
2026-05-02 05:34:08,142 - main - INFO - Included router: routers.kb_article_feedback.router
2026-05-02 05:34:08,186 - main - INFO - Included router: routers.kb_articles.router
2026-05-02 05:34:08,229 - main - INFO - Included router: routers.notification_preferences.router
2026-05-02 05:34:08,273 - main - INFO - Included router: routers.notifications.router
2026-05-02 05:34:08,277 - main - INFO - Included router: routers.notifications_extras.router
2026-05-02 05:34:08,355 - main - INFO - Included router: routers.oauth.router
2026-05-02 05:34:08,407 - main - INFO - Included router: routers.plans.router
2026-05-02 05:34:08,430 - main - INFO - Included router: routers.role_management.router
2026-05-02 05:34:08,471 - main - INFO - Included router: routers.service_testimonials.router
2026-05-02 05:34:08,489 - main - INFO - Included router: routers.settings.router
2026-05-02 05:34:08,724 - main - INFO - Included router: routers.site_settings.router
2026-05-02 05:34:08,778 - main - INFO - Included router: routers.smtp_settings.router
2026-05-02 05:34:08,812 - main - INFO - Included router: routers.storage.router
2026-05-02 05:34:08,919 - main - INFO - Included router: routers.support_chat.router
2026-05-02 05:34:08,955 - main - INFO - Included router: routers.support_departments.router
2026-05-02 05:34:08,996 - main - INFO - Included router: routers.support_seats.router
2026-05-02 05:34:09,005 - main - INFO - Included router: routers.ticket_notifications_sync.router
2026-05-02 05:34:09,091 - main - INFO - Included router: routers.ticket_summaries.router
2026-05-02 05:34:09,133 - main - INFO - Included router: routers.ticket_sync_states.router
2026-05-02 05:34:09,142 - main - INFO - Included router: routers.user.router
2026-05-02 05:34:09,192 - main - INFO - Included router: routers.user_profiles.router
2026-05-02 05:34:09,240 - main - INFO - Included router: routers.user_roles.router
2026-05-02 05:34:09,260 - main - INFO - Included router: routers.whmcs.router
2026-05-02 05:34:09,325 - main - INFO - Included router: routers.whmcs_admin.router
2026-05-02 05:34:09,370 - main - INFO - Included router: routers.whmcs_extra.router
2026-05-02 05:34:09,372 - main - INFO - === Application startup initiated ===
2026-05-02 05:34:09,372 - services.database - INFO - Ignore creating tables
2026-05-02 05:34:09,372 - services.mock_data - INFO - Ignore initialize data
2026-05-02 05:34:09,373 - services.auth - INFO - Ignore initialize admin
2026-05-02 05:34:09,373 - main - INFO - === Application startup completed successfully ===
2026-05-02 05:34:28,331 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:34:28,332 - core.database - WARNING - Database session maker not available, attempting lazy initialization...
2026-05-02 05:34:28,332 - core.database - WARNING - Database not initialized, attempting lazy initialization...
2026-05-02 05:34:28,332 - core.database - INFO - Starting database initialization...
2026-05-02 05:34:28,332 - core.config - DEBUG - Read dynamic attribute database_url from environment variable DATABASE_URL
2026-05-02 05:34:28,332 - core.database - INFO - Normalizing database URL for async compatibility...
2026-05-02 05:34:28,333 - core.database - INFO - Creating async database engine...
2026-05-02 05:34:28,333 - core.database - INFO - Using QueuePool with connection pooling for non-Lambda environment
2026-05-02 05:34:28,477 - core.database - INFO - Database engine created successfully
2026-05-02 05:34:28,477 - core.database - INFO - Creating async session maker...
2026-05-02 05:34:28,477 - core.database - INFO - Async session maker created successfully
2026-05-02 05:34:28,477 - core.database - INFO - Database connection initialized successfully
2026-05-02 05:34:28,478 - core.database - DEBUG - [DB_OP] Starting create_tables
2026-05-02 05:34:28,478 - core.database - INFO - 🔧 Starting table creation...
2026-05-02 05:34:28,482 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-02 05:34:28,484 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:34:28,484 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-02 05:34:28,485 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 05:34:28,487 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:34:28,487 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0001s
2026-05-02 05:34:28,487 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 05:34:29,873 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 05:34:29,873 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.3892s
2026-05-02 05:34:29,874 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 05:34:29,874 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.3871s
2026-05-02 05:34:31,409 - core.database - INFO - Tables initialized successfully
2026-05-02 05:34:31,410 - core.database - DEBUG - [DB_OP] Create tables completed in 2.9321s
2026-05-02 05:34:31,473 - core.database - INFO - Lazy database initialization completed successfully
2026-05-02 05:34:31,474 - core.database - DEBUG - [DB_OP] Database session created successfully in 3.1425s
2026-05-02 05:34:31,929 - core.database - DEBUG - [DB_OP] Database session cleanup after 3.5980s
2026-05-02 05:35:14,028 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:35:14,029 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-02 05:35:14,030 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-02 05:35:14,031 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:35:14,031 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-02 05:35:14,031 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 05:35:14,033 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:35:14,033 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-02 05:35:14,033 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 05:35:14,413 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 05:35:14,414 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3815s
2026-05-02 05:35:14,475 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4464s
2026-05-02 05:35:14,607 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 05:35:14,607 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.5767s
2026-05-02 05:35:21,790 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-02 05:35:21,796 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:35:21,797 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-05-02 05:35:21,798 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:35:21,798 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0001s
2026-05-02 05:35:21,799 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 05:35:21,800 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:35:21,800 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0001s
2026-05-02 05:35:21,800 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 05:35:22,112 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3156s
2026-05-02 05:35:22,179 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 05:35:22,179 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3809s
2026-05-02 05:35:22,179 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 05:35:22,180 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3800s
2026-05-02 05:36:16,105 - services.database - DEBUG - [DB_OP] Starting database close
2026-05-02 05:36:16,353 - core.database - INFO - Database connection closed and engine disposed
2026-05-02 05:36:16,353 - services.database - INFO - Database connections closed
2026-05-02 05:36:16,353 - services.database - DEBUG - [DB_OP] Database close completed in 0.2482s
