2026-05-02 09:21:16,620 - main - INFO - === Logging system initialized ===
2026-05-02 09:21:16,620 - main - INFO - Log file: logs/app_20260502_092116.log
2026-05-02 09:21:16,621 - main - INFO - Log level: INFO
2026-05-02 09:21:16,621 - main - INFO - Timestamp: 20260502_092116
2026-05-02 09:21:16,688 - main - INFO - Included router: routers.admin_dashboard.router
2026-05-02 09:21:16,728 - main - INFO - Included router: routers.agent_availability.router
2026-05-02 09:21:17,569 - main - INFO - Included router: routers.ai_ticket_summary.router
2026-05-02 09:21:17,593 - main - INFO - Included router: routers.aihub.router
2026-05-02 09:21:17,606 - main - INFO - Included router: routers.auth.router
2026-05-02 09:21:17,650 - main - INFO - Included router: routers.carts.router
2026-05-02 09:21:17,698 - main - INFO - Included router: routers.chat_analytics_daily.router
2026-05-02 09:21:17,748 - main - INFO - Included router: routers.chat_attachments.router
2026-05-02 09:21:17,825 - main - INFO - Included router: routers.chat_branding.router
2026-05-02 09:21:17,844 - main - INFO - Included router: routers.chat_branding_api.router
2026-05-02 09:21:17,985 - main - INFO - Included router: routers.chat_conversations.router
2026-05-02 09:21:18,031 - main - INFO - Included router: routers.chat_messages.router
2026-05-02 09:21:18,076 - main - INFO - Included router: routers.chat_routing_rules.router
2026-05-02 09:21:18,104 - main - INFO - Included router: routers.contact.router
2026-05-02 09:21:18,150 - main - INFO - Included router: routers.contact_inquiries.router
2026-05-02 09:21:18,196 - main - INFO - Included router: routers.ecom_checkout.router
2026-05-02 09:21:18,198 - main - INFO - Included router: routers.health.router
2026-05-02 09:21:18,247 - main - INFO - Included router: routers.kb_article_feedback.router
2026-05-02 09:21:18,287 - main - INFO - Included router: routers.kb_articles.router
2026-05-02 09:21:18,336 - main - INFO - Included router: routers.notification_preferences.router
2026-05-02 09:21:18,387 - main - INFO - Included router: routers.notifications.router
2026-05-02 09:21:18,393 - main - INFO - Included router: routers.notifications_extras.router
2026-05-02 09:21:18,493 - main - INFO - Included router: routers.oauth.router
2026-05-02 09:21:18,540 - main - INFO - Included router: routers.order_items.router
2026-05-02 09:21:18,727 - main - INFO - Included router: routers.orders.router
2026-05-02 09:21:18,794 - main - INFO - Included router: routers.plans.router
2026-05-02 09:21:18,836 - main - INFO - Included router: routers.product_categories.router
2026-05-02 09:21:18,881 - main - INFO - Included router: routers.product_reviews.router
2026-05-02 09:21:18,951 - main - INFO - Included router: routers.products.router
2026-05-02 09:21:18,983 - main - INFO - Included router: routers.role_management.router
2026-05-02 09:21:19,039 - main - INFO - Included router: routers.service_testimonials.router
2026-05-02 09:21:19,068 - main - INFO - Included router: routers.settings.router
2026-05-02 09:21:19,116 - main - INFO - Included router: routers.site_settings.router
2026-05-02 09:21:19,160 - main - INFO - Included router: routers.smtp_settings.router
2026-05-02 09:21:19,202 - main - INFO - Included router: routers.storage.router
2026-05-02 09:21:19,313 - main - INFO - Included router: routers.support_chat.router
2026-05-02 09:21:19,358 - main - INFO - Included router: routers.support_departments.router
2026-05-02 09:21:19,583 - main - INFO - Included router: routers.support_seats.router
2026-05-02 09:21:19,612 - main - INFO - Included router: routers.ticket_notifications_sync.router
2026-05-02 09:21:19,660 - main - INFO - Included router: routers.ticket_summaries.router
2026-05-02 09:21:19,709 - main - INFO - Included router: routers.ticket_sync_states.router
2026-05-02 09:21:19,719 - main - INFO - Included router: routers.user.router
2026-05-02 09:21:19,768 - main - INFO - Included router: routers.user_profiles.router
2026-05-02 09:21:19,809 - main - INFO - Included router: routers.user_roles.router
2026-05-02 09:21:19,830 - main - INFO - Included router: routers.whmcs.router
2026-05-02 09:21:19,901 - main - INFO - Included router: routers.whmcs_admin.router
2026-05-02 09:21:19,944 - main - INFO - Included router: routers.whmcs_extra.router
2026-05-02 09:21:19,946 - main - INFO - === Application startup initiated ===
2026-05-02 09:21:19,946 - services.database - INFO - Ignore creating tables
2026-05-02 09:21:19,946 - services.mock_data - INFO - Ignore initialize data
2026-05-02 09:21:19,946 - services.auth - INFO - Ignore initialize admin
2026-05-02 09:21:19,946 - main - INFO - === Application startup completed successfully ===
2026-05-02 09:21:46,174 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 09:21:46,174 - core.database - WARNING - Database session maker not available, attempting lazy initialization...
2026-05-02 09:21:46,174 - core.database - WARNING - Database not initialized, attempting lazy initialization...
2026-05-02 09:21:46,174 - core.database - INFO - Starting database initialization...
2026-05-02 09:21:46,174 - core.config - DEBUG - Read dynamic attribute database_url from environment variable DATABASE_URL
2026-05-02 09:21:46,174 - core.database - INFO - Normalizing database URL for async compatibility...
2026-05-02 09:21:46,175 - core.database - INFO - Creating async database engine...
2026-05-02 09:21:46,175 - core.database - INFO - Using QueuePool with connection pooling for non-Lambda environment
2026-05-02 09:21:46,216 - core.database - INFO - Database engine created successfully
2026-05-02 09:21:46,216 - core.database - INFO - Creating async session maker...
2026-05-02 09:21:46,217 - core.database - INFO - Async session maker created successfully
2026-05-02 09:21:46,217 - core.database - INFO - Database connection initialized successfully
2026-05-02 09:21:46,217 - core.database - DEBUG - [DB_OP] Starting create_tables
2026-05-02 09:21:46,217 - core.database - INFO - 🔧 Starting table creation...
2026-05-02 09:21:46,222 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-02 09:21:46,223 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 09:21:46,223 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-02 09:21:46,224 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 09:21:46,227 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 09:21:46,227 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0001s
2026-05-02 09:21:47,486 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.2589s
2026-05-02 09:21:47,617 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 09:21:47,618 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.3951s
2026-05-02 09:21:49,477 - core.database - INFO - Tables initialized successfully
2026-05-02 09:21:49,477 - core.database - DEBUG - [DB_OP] Create tables completed in 3.2605s
2026-05-02 09:21:49,541 - core.database - INFO - Lazy database initialization completed successfully
2026-05-02 09:21:49,541 - core.database - DEBUG - [DB_OP] Database session created successfully in 3.3672s
2026-05-02 09:21:49,541 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 09:21:50,109 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 09:21:50,109 - core.database - DEBUG - [DB_OP] Database session cleanup after 3.9357s
2026-05-02 09:22:47,046 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 09:22:47,046 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 09:22:47,492 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4465s
2026-05-02 09:23:47,045 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 09:23:47,045 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-02 09:23:47,488 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4435s
2026-05-02 09:24:47,200 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 09:24:47,201 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 09:24:47,517 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3164s
2026-05-02 09:25:47,046 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 09:25:47,046 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-02 09:25:47,364 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3187s
2026-05-02 09:26:47,049 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 09:26:47,050 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 09:26:47,367 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3173s
2026-05-02 09:27:47,050 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 09:27:47,051 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 09:27:47,492 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4420s
2026-05-02 09:29:13,063 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 09:29:13,064 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 09:29:13,508 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4446s
2026-05-02 09:30:13,069 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 09:30:13,069 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 09:30:13,512 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4432s
2026-05-02 09:31:13,062 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 09:31:13,063 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-02 09:31:13,383 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3208s
2026-05-02 09:32:13,218 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 09:32:13,218 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-02 09:32:13,556 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3386s
2026-05-02 09:33:13,166 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 09:33:13,167 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0007s
2026-05-02 09:33:13,484 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3180s
2026-05-02 09:34:13,060 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 09:34:13,060 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 09:34:13,502 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4418s
2026-05-02 09:35:53,782 - services.database - DEBUG - [DB_OP] Starting database close
2026-05-02 09:35:53,981 - core.database - INFO - Database connection closed and engine disposed
2026-05-02 09:35:53,981 - services.database - INFO - Database connections closed
2026-05-02 09:35:53,981 - services.database - DEBUG - [DB_OP] Database close completed in 0.1994s
