2026-05-02 05:36:23,680 - main - INFO - === Logging system initialized ===
2026-05-02 05:36:23,680 - main - INFO - Log file: logs/app_20260502_053623.log
2026-05-02 05:36:23,680 - main - INFO - Log level: INFO
2026-05-02 05:36:23,680 - main - INFO - Timestamp: 20260502_053623
2026-05-02 05:36:23,732 - main - INFO - Included router: routers.admin_dashboard.router
2026-05-02 05:36:23,768 - main - INFO - Included router: routers.agent_availability.router
2026-05-02 05:36:24,425 - main - INFO - Included router: routers.ai_ticket_summary.router
2026-05-02 05:36:24,442 - main - INFO - Included router: routers.aihub.router
2026-05-02 05:36:24,453 - main - INFO - Included router: routers.auth.router
2026-05-02 05:36:24,497 - main - INFO - Included router: routers.chat_analytics_daily.router
2026-05-02 05:36:24,536 - main - INFO - Included router: routers.chat_attachments.router
2026-05-02 05:36:24,596 - main - INFO - Included router: routers.chat_branding.router
2026-05-02 05:36:24,610 - main - INFO - Included router: routers.chat_branding_api.router
2026-05-02 05:36:24,659 - main - INFO - Included router: routers.chat_conversations.router
2026-05-02 05:36:24,766 - main - INFO - Included router: routers.chat_messages.router
2026-05-02 05:36:24,824 - main - INFO - Included router: routers.chat_routing_rules.router
2026-05-02 05:36:24,843 - main - INFO - Included router: routers.contact.router
2026-05-02 05:36:24,882 - main - INFO - Included router: routers.contact_inquiries.router
2026-05-02 05:36:24,884 - main - INFO - Included router: routers.health.router
2026-05-02 05:36:24,926 - main - INFO - Included router: routers.kb_article_feedback.router
2026-05-02 05:36:24,967 - main - INFO - Included router: routers.kb_articles.router
2026-05-02 05:36:25,012 - main - INFO - Included router: routers.notification_preferences.router
2026-05-02 05:36:25,070 - main - INFO - Included router: routers.notifications.router
2026-05-02 05:36:25,074 - main - INFO - Included router: routers.notifications_extras.router
2026-05-02 05:36:25,151 - main - INFO - Included router: routers.oauth.router
2026-05-02 05:36:25,194 - main - INFO - Included router: routers.plans.router
2026-05-02 05:36:25,216 - main - INFO - Included router: routers.role_management.router
2026-05-02 05:36:25,256 - main - INFO - Included router: routers.service_testimonials.router
2026-05-02 05:36:25,274 - main - INFO - Included router: routers.settings.router
2026-05-02 05:36:25,394 - main - INFO - Included router: routers.site_settings.router
2026-05-02 05:36:25,430 - main - INFO - Included router: routers.smtp_settings.router
2026-05-02 05:36:25,474 - main - INFO - Included router: routers.storage.router
2026-05-02 05:36:25,574 - main - INFO - Included router: routers.support_chat.router
2026-05-02 05:36:25,608 - main - INFO - Included router: routers.support_departments.router
2026-05-02 05:36:25,645 - main - INFO - Included router: routers.support_seats.router
2026-05-02 05:36:25,652 - main - INFO - Included router: routers.ticket_notifications_sync.router
2026-05-02 05:36:25,695 - main - INFO - Included router: routers.ticket_summaries.router
2026-05-02 05:36:25,734 - main - INFO - Included router: routers.ticket_sync_states.router
2026-05-02 05:36:25,742 - main - INFO - Included router: routers.user.router
2026-05-02 05:36:25,784 - main - INFO - Included router: routers.user_profiles.router
2026-05-02 05:36:25,823 - main - INFO - Included router: routers.user_roles.router
2026-05-02 05:36:25,841 - main - INFO - Included router: routers.whmcs.router
2026-05-02 05:36:25,897 - main - INFO - Included router: routers.whmcs_admin.router
2026-05-02 05:36:25,934 - main - INFO - Included router: routers.whmcs_extra.router
2026-05-02 05:36:25,935 - main - INFO - === Application startup initiated ===
2026-05-02 05:36:25,935 - services.database - INFO - Ignore creating tables
2026-05-02 05:36:25,936 - services.mock_data - INFO - Ignore initialize data
2026-05-02 05:36:25,936 - services.auth - INFO - Ignore initialize admin
2026-05-02 05:36:25,936 - main - INFO - === Application startup completed successfully ===
2026-05-02 05:36:34,541 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:36:34,542 - core.database - WARNING - Database session maker not available, attempting lazy initialization...
2026-05-02 05:36:34,542 - core.database - WARNING - Database not initialized, attempting lazy initialization...
2026-05-02 05:36:34,542 - core.database - INFO - Starting database initialization...
2026-05-02 05:36:34,542 - core.config - DEBUG - Read dynamic attribute database_url from environment variable DATABASE_URL
2026-05-02 05:36:34,542 - core.database - INFO - Normalizing database URL for async compatibility...
2026-05-02 05:36:34,543 - core.database - INFO - Creating async database engine...
2026-05-02 05:36:34,543 - core.database - INFO - Using QueuePool with connection pooling for non-Lambda environment
2026-05-02 05:36:34,782 - core.database - INFO - Database engine created successfully
2026-05-02 05:36:34,783 - core.database - INFO - Creating async session maker...
2026-05-02 05:36:34,783 - core.database - INFO - Async session maker created successfully
2026-05-02 05:36:34,783 - core.database - INFO - Database connection initialized successfully
2026-05-02 05:36:34,783 - core.database - DEBUG - [DB_OP] Starting create_tables
2026-05-02 05:36:34,783 - core.database - INFO - 🔧 Starting table creation...
2026-05-02 05:36:34,791 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-02 05:36:34,794 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:36:34,795 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-05-02 05:36:34,795 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 05:36:34,799 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:36:34,799 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-02 05:36:34,799 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 05:36:36,185 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 05:36:36,186 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.3868s
2026-05-02 05:36:36,186 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 05:36:36,187 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.3925s
2026-05-02 05:36:37,668 - core.database - INFO - Tables initialized successfully
2026-05-02 05:36:37,668 - core.database - DEBUG - [DB_OP] Create tables completed in 2.8852s
2026-05-02 05:36:37,730 - core.database - INFO - Lazy database initialization completed successfully
2026-05-02 05:36:37,731 - core.database - DEBUG - [DB_OP] Database session created successfully in 3.1892s
2026-05-02 05:36:38,170 - core.database - DEBUG - [DB_OP] Database session cleanup after 3.6287s
2026-05-02 05:37:34,548 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:37:34,548 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 05:37:34,993 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4448s
2026-05-02 05:38:44,450 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:38:44,450 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0007s
2026-05-02 05:38:44,890 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4407s
2026-05-02 05:39:24,972 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:39:24,973 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-05-02 05:39:24,974 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-02 05:39:24,975 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:39:24,975 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-02 05:39:24,975 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 05:39:24,977 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:39:24,977 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-02 05:39:24,978 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 05:39:25,286 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3140s
2026-05-02 05:39:25,355 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 05:39:25,356 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3818s
2026-05-02 05:39:25,480 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 05:39:25,480 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.5034s
2026-05-02 05:40:22,917 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:40:22,917 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-02 05:40:22,917 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 05:40:22,918 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-02 05:40:22,919 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:40:22,919 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0001s
2026-05-02 05:40:22,920 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:40:22,920 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-02 05:40:22,921 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 05:40:23,234 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3150s
2026-05-02 05:40:23,297 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 05:40:23,298 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3813s
2026-05-02 05:40:23,298 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 05:40:23,299 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3786s
2026-05-02 05:40:28,352 - services.database - DEBUG - [DB_OP] Starting database close
2026-05-02 05:40:28,549 - core.database - INFO - Database connection closed and engine disposed
2026-05-02 05:40:28,549 - services.database - INFO - Database connections closed
2026-05-02 05:40:28,549 - services.database - DEBUG - [DB_OP] Database close completed in 0.1978s