2026-05-02 08:53:38,429 - main - INFO - === Logging system initialized ===
2026-05-02 08:53:38,430 - main - INFO - Log file: logs/app_20260502_085338.log
2026-05-02 08:53:38,430 - main - INFO - Log level: INFO
2026-05-02 08:53:38,430 - main - INFO - Timestamp: 20260502_085338
2026-05-02 08:53:38,507 - main - INFO - Included router: routers.admin_dashboard.router
2026-05-02 08:53:38,550 - main - INFO - Included router: routers.agent_availability.router
2026-05-02 08:53:39,566 - main - INFO - Included router: routers.ai_ticket_summary.router
2026-05-02 08:53:39,595 - main - INFO - Included router: routers.aihub.router
2026-05-02 08:53:39,614 - main - INFO - Included router: routers.auth.router
2026-05-02 08:53:39,660 - main - INFO - Included router: routers.carts.router
2026-05-02 08:53:39,711 - main - INFO - Included router: routers.chat_analytics_daily.router
2026-05-02 08:53:39,767 - main - INFO - Included router: routers.chat_attachments.router
2026-05-02 08:53:39,835 - main - INFO - Included router: routers.chat_branding.router
2026-05-02 08:53:39,849 - main - INFO - Included router: routers.chat_branding_api.router
2026-05-02 08:53:39,983 - main - INFO - Included router: routers.chat_conversations.router
2026-05-02 08:53:40,029 - main - INFO - Included router: routers.chat_messages.router
2026-05-02 08:53:40,078 - main - INFO - Included router: routers.chat_routing_rules.router
2026-05-02 08:53:40,103 - main - INFO - Included router: routers.contact.router
2026-05-02 08:53:40,145 - main - INFO - Included router: routers.contact_inquiries.router
2026-05-02 08:53:40,191 - main - INFO - Included router: routers.ecom_checkout.router
2026-05-02 08:53:40,193 - main - INFO - Included router: routers.health.router
2026-05-02 08:53:40,237 - main - INFO - Included router: routers.kb_article_feedback.router
2026-05-02 08:53:40,280 - main - INFO - Included router: routers.kb_articles.router
2026-05-02 08:53:40,330 - main - INFO - Included router: routers.notification_preferences.router
2026-05-02 08:53:40,380 - main - INFO - Included router: routers.notifications.router
2026-05-02 08:53:40,385 - main - INFO - Included router: routers.notifications_extras.router
2026-05-02 08:53:40,475 - main - INFO - Included router: routers.oauth.router
2026-05-02 08:53:40,522 - main - INFO - Included router: routers.order_items.router
2026-05-02 08:53:40,675 - main - INFO - Included router: routers.orders.router
2026-05-02 08:53:40,743 - main - INFO - Included router: routers.plans.router
2026-05-02 08:53:40,787 - main - INFO - Included router: routers.product_categories.router
2026-05-02 08:53:40,832 - main - INFO - Included router: routers.product_reviews.router
2026-05-02 08:53:40,885 - main - INFO - Included router: routers.products.router
2026-05-02 08:53:40,908 - main - INFO - Included router: routers.role_management.router
2026-05-02 08:53:40,953 - main - INFO - Included router: routers.service_testimonials.router
2026-05-02 08:53:40,973 - main - INFO - Included router: routers.settings.router
2026-05-02 08:53:41,010 - main - INFO - Included router: routers.site_settings.router
2026-05-02 08:53:41,082 - main - INFO - Included router: routers.smtp_settings.router
2026-05-02 08:53:41,120 - main - INFO - Included router: routers.storage.router
2026-05-02 08:53:41,248 - main - INFO - Included router: routers.support_chat.router
2026-05-02 08:53:41,289 - main - INFO - Included router: routers.support_departments.router
2026-05-02 08:53:41,467 - main - INFO - Included router: routers.support_seats.router
2026-05-02 08:53:41,475 - main - INFO - Included router: routers.ticket_notifications_sync.router
2026-05-02 08:53:41,512 - main - INFO - Included router: routers.ticket_summaries.router
2026-05-02 08:53:41,552 - main - INFO - Included router: routers.ticket_sync_states.router
2026-05-02 08:53:41,560 - main - INFO - Included router: routers.user.router
2026-05-02 08:53:41,603 - main - INFO - Included router: routers.user_profiles.router
2026-05-02 08:53:41,642 - main - INFO - Included router: routers.user_roles.router
2026-05-02 08:53:41,660 - main - INFO - Included router: routers.whmcs.router
2026-05-02 08:53:41,715 - main - INFO - Included router: routers.whmcs_admin.router
2026-05-02 08:53:41,757 - main - INFO - Included router: routers.whmcs_extra.router
2026-05-02 08:53:41,759 - main - INFO - === Application startup initiated ===
2026-05-02 08:53:41,759 - services.database - INFO - Ignore creating tables
2026-05-02 08:53:41,759 - services.mock_data - INFO - Ignore initialize data
2026-05-02 08:53:41,759 - services.auth - INFO - Ignore initialize admin
2026-05-02 08:53:41,759 - main - INFO - === Application startup completed successfully ===
2026-05-02 08:54:08,147 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 08:54:08,148 - core.database - WARNING - Database session maker not available, attempting lazy initialization...
2026-05-02 08:54:08,148 - core.database - WARNING - Database not initialized, attempting lazy initialization...
2026-05-02 08:54:08,148 - core.database - INFO - Starting database initialization...
2026-05-02 08:54:08,148 - core.config - DEBUG - Read dynamic attribute database_url from environment variable DATABASE_URL
2026-05-02 08:54:08,148 - core.database - INFO - Normalizing database URL for async compatibility...
2026-05-02 08:54:08,149 - core.database - INFO - Creating async database engine...
2026-05-02 08:54:08,150 - core.database - INFO - Using QueuePool with connection pooling for non-Lambda environment
2026-05-02 08:54:08,213 - core.database - INFO - Database engine created successfully
2026-05-02 08:54:08,214 - core.database - INFO - Creating async session maker...
2026-05-02 08:54:08,214 - core.database - INFO - Async session maker created successfully
2026-05-02 08:54:08,214 - core.database - INFO - Database connection initialized successfully
2026-05-02 08:54:08,215 - core.database - DEBUG - [DB_OP] Starting create_tables
2026-05-02 08:54:08,215 - core.database - INFO - 🔧 Starting table creation...
2026-05-02 08:54:08,222 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 08:54:08,223 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0007s
2026-05-02 08:54:08,224 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 08:54:08,229 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 08:54:08,229 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0006s
2026-05-02 08:54:08,230 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 08:54:08,235 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-02 08:54:09,628 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 08:54:09,629 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.4001s
2026-05-02 08:54:09,630 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 08:54:09,630 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.4075s
2026-05-02 08:54:11,523 - core.database - INFO - Tables initialized successfully
2026-05-02 08:54:11,523 - core.database - DEBUG - [DB_OP] Create tables completed in 3.3088s
2026-05-02 08:54:11,587 - core.database - INFO - Lazy database initialization completed successfully
2026-05-02 08:54:11,587 - core.database - DEBUG - [DB_OP] Database session created successfully in 3.4401s
2026-05-02 08:54:12,030 - core.database - DEBUG - [DB_OP] Database session cleanup after 3.8826s
2026-05-02 08:55:09,040 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 08:55:09,040 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-02 08:55:09,488 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4485s
2026-05-02 08:56:09,031 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 08:56:09,032 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-02 08:56:09,474 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4428s
2026-05-02 08:57:02,190 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 08:57:02,191 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0006s
2026-05-02 08:57:02,508 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3174s
2026-05-02 08:57:09,026 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 08:57:09,026 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-02 08:57:09,342 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3163s
2026-05-02 08:58:09,062 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 08:58:09,062 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 08:58:09,380 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3175s
2026-05-02 08:58:18,569 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 08:58:18,570 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 08:58:18,884 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3145s
2026-05-02 08:59:09,047 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 08:59:09,048 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 08:59:09,371 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3236s
2026-05-02 09:00:19,502 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 09:00:19,503 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-02 09:00:19,819 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3171s
2026-05-02 09:01:30,693 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 09:01:30,694 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 09:01:30,699 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-02 09:01:30,701 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 09:01:30,701 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-05-02 09:01:30,701 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 09:01:30,703 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 09:01:30,704 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0008s
2026-05-02 09:01:30,705 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 09:01:31,139 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4453s
2026-05-02 09:01:31,203 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 09:01:31,203 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.5029s
2026-05-02 09:01:31,335 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 09:01:31,335 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.6322s
2026-05-02 09:01:36,959 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 09:01:36,960 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 09:01:37,275 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3163s
2026-05-02 09:02:07,443 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 09:02:07,444 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0009s
2026-05-02 09:02:07,763 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3196s
2026-05-02 09:02:48,482 - services.database - DEBUG - [DB_OP] Starting database close
2026-05-02 09:02:48,680 - core.database - INFO - Database connection closed and engine disposed
2026-05-02 09:02:48,681 - services.database - INFO - Database connections closed
2026-05-02 09:02:48,681 - services.database - DEBUG - [DB_OP] Database close completed in 0.1991s