2026-05-02 09:47:06,322 - main - INFO - === Logging system initialized ===
2026-05-02 09:47:06,322 - main - INFO - Log file: logs/app_20260502_094706.log
2026-05-02 09:47:06,322 - main - INFO - Log level: INFO
2026-05-02 09:47:06,322 - main - INFO - Timestamp: 20260502_094706
2026-05-02 09:47:06,393 - main - INFO - Included router: routers.admin_dashboard.router
2026-05-02 09:47:06,434 - main - INFO - Included router: routers.agent_availability.router
2026-05-02 09:47:07,316 - main - INFO - Included router: routers.ai_ticket_summary.router
2026-05-02 09:47:07,336 - main - INFO - Included router: routers.aihub.router
2026-05-02 09:47:07,350 - main - INFO - Included router: routers.auth.router
2026-05-02 09:47:07,394 - main - INFO - Included router: routers.carts.router
2026-05-02 09:47:07,439 - main - INFO - Included router: routers.chat_analytics_daily.router
2026-05-02 09:47:07,482 - main - INFO - Included router: routers.chat_attachments.router
2026-05-02 09:47:07,544 - main - INFO - Included router: routers.chat_branding.router
2026-05-02 09:47:07,559 - main - INFO - Included router: routers.chat_branding_api.router
2026-05-02 09:47:07,703 - main - INFO - Included router: routers.chat_conversations.router
2026-05-02 09:47:07,763 - main - INFO - Included router: routers.chat_messages.router
2026-05-02 09:47:07,808 - main - INFO - Included router: routers.chat_routing_rules.router
2026-05-02 09:47:07,829 - main - INFO - Included router: routers.contact.router
2026-05-02 09:47:07,872 - main - INFO - Included router: routers.contact_inquiries.router
2026-05-02 09:47:07,917 - main - INFO - Included router: routers.ecom_checkout.router
2026-05-02 09:47:07,919 - main - INFO - Included router: routers.health.router
2026-05-02 09:47:07,971 - main - INFO - Included router: routers.kb_article_feedback.router
2026-05-02 09:47:08,018 - main - INFO - Included router: routers.kb_articles.router
2026-05-02 09:47:08,091 - main - INFO - Included router: routers.notification_preferences.router
2026-05-02 09:47:08,153 - main - INFO - Included router: routers.notifications.router
2026-05-02 09:47:08,158 - main - INFO - Included router: routers.notifications_extras.router
2026-05-02 09:47:08,263 - main - INFO - Included router: routers.oauth.router
2026-05-02 09:47:08,315 - main - INFO - Included router: routers.order_items.router
2026-05-02 09:47:08,511 - main - INFO - Included router: routers.orders.router
2026-05-02 09:47:08,574 - main - INFO - Included router: routers.plans.router
2026-05-02 09:47:08,616 - main - INFO - Included router: routers.product_categories.router
2026-05-02 09:47:08,666 - main - INFO - Included router: routers.product_reviews.router
2026-05-02 09:47:08,722 - main - INFO - Included router: routers.products.router
2026-05-02 09:47:08,745 - main - INFO - Included router: routers.role_management.router
2026-05-02 09:47:08,787 - main - INFO - Included router: routers.service_testimonials.router
2026-05-02 09:47:08,806 - main - INFO - Included router: routers.settings.router
2026-05-02 09:47:08,848 - main - INFO - Included router: routers.site_settings.router
2026-05-02 09:47:08,887 - main - INFO - Included router: routers.smtp_settings.router
2026-05-02 09:47:08,938 - main - INFO - Included router: routers.storage.router
2026-05-02 09:47:09,046 - main - INFO - Included router: routers.support_chat.router
2026-05-02 09:47:09,085 - main - INFO - Included router: routers.support_departments.router
2026-05-02 09:47:09,289 - main - INFO - Included router: routers.support_seats.router
2026-05-02 09:47:09,296 - main - INFO - Included router: routers.ticket_notifications_sync.router
2026-05-02 09:47:09,342 - main - INFO - Included router: routers.ticket_summaries.router
2026-05-02 09:47:09,384 - main - INFO - Included router: routers.ticket_sync_states.router
2026-05-02 09:47:09,392 - main - INFO - Included router: routers.user.router
2026-05-02 09:47:09,434 - main - INFO - Included router: routers.user_profiles.router
2026-05-02 09:47:09,476 - main - INFO - Included router: routers.user_roles.router
2026-05-02 09:47:09,499 - main - INFO - Included router: routers.whmcs.router
2026-05-02 09:47:09,567 - main - INFO - Included router: routers.whmcs_admin.router
2026-05-02 09:47:09,606 - main - INFO - Included router: routers.whmcs_extra.router
2026-05-02 09:47:09,608 - main - INFO - === Application startup initiated ===
2026-05-02 09:47:09,608 - services.database - INFO - Ignore creating tables
2026-05-02 09:47:09,608 - services.mock_data - INFO - Ignore initialize data
2026-05-02 09:47:09,608 - services.auth - INFO - Ignore initialize admin
2026-05-02 09:47:09,609 - main - INFO - === Application startup completed successfully ===
2026-05-02 09:48:20,857 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 09:48:20,858 - core.database - WARNING - Database session maker not available, attempting lazy initialization...
2026-05-02 09:48:20,858 - core.database - WARNING - Database not initialized, attempting lazy initialization...
2026-05-02 09:48:20,858 - core.database - INFO - Starting database initialization...
2026-05-02 09:48:20,858 - core.config - DEBUG - Read dynamic attribute database_url from environment variable DATABASE_URL
2026-05-02 09:48:20,858 - core.database - INFO - Normalizing database URL for async compatibility...
2026-05-02 09:48:20,860 - core.database - INFO - Creating async database engine...
2026-05-02 09:48:20,860 - core.database - INFO - Using QueuePool with connection pooling for non-Lambda environment
2026-05-02 09:48:20,921 - core.database - INFO - Database engine created successfully
2026-05-02 09:48:20,922 - core.database - INFO - Creating async session maker...
2026-05-02 09:48:20,922 - core.database - INFO - Async session maker created successfully
2026-05-02 09:48:20,922 - core.database - INFO - Database connection initialized successfully
2026-05-02 09:48:20,922 - core.database - DEBUG - [DB_OP] Starting create_tables
2026-05-02 09:48:20,922 - core.database - INFO - 🔧 Starting table creation...
2026-05-02 09:48:20,930 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 09:48:20,930 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0006s
2026-05-02 09:48:20,931 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 09:48:20,935 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 09:48:20,935 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-02 09:48:20,935 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 09:48:20,939 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-02 09:48:22,329 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 09:48:22,330 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.3953s
2026-05-02 09:48:22,332 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 09:48:22,333 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.4030s
2026-05-02 09:48:24,232 - core.database - INFO - Tables initialized successfully
2026-05-02 09:48:24,233 - core.database - DEBUG - [DB_OP] Create tables completed in 3.3107s
2026-05-02 09:48:24,296 - core.database - INFO - Lazy database initialization completed successfully
2026-05-02 09:48:24,297 - core.database - DEBUG - [DB_OP] Database session created successfully in 3.4392s
2026-05-02 09:48:24,738 - core.database - DEBUG - [DB_OP] Database session cleanup after 3.8809s
2026-05-02 09:49:21,053 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 09:49:21,053 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-02 09:49:21,499 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4465s
2026-05-02 09:50:21,047 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 09:50:21,047 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-02 09:50:21,491 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4440s
2026-05-02 09:51:21,043 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 09:51:21,043 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-02 09:51:21,370 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3267s
2026-05-02 09:52:21,047 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 09:52:21,048 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0006s
2026-05-02 09:52:21,366 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3190s
2026-05-02 09:53:21,043 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 09:53:21,044 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 09:53:21,362 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3184s
2026-05-02 09:54:21,048 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 09:54:21,049 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 09:54:21,493 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4450s
2026-05-02 09:56:13,064 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 09:56:13,064 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 09:56:13,508 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4443s
2026-05-02 09:57:13,281 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 09:57:13,282 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 09:57:13,724 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4426s
2026-05-02 09:58:13,060 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 09:58:13,060 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-02 09:58:13,376 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3163s
2026-05-02 09:59:13,060 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 09:59:13,060 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-02 09:59:13,379 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3190s
2026-05-02 10:00:13,287 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 10:00:13,287 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0007s
2026-05-02 10:00:13,607 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3200s
2026-05-02 10:01:13,062 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 10:01:13,063 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-02 10:01:13,508 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4454s
2026-05-02 10:02:13,069 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 10:02:13,069 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 10:02:13,516 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4466s
2026-05-02 10:03:13,064 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 10:03:13,065 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 10:03:13,512 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4479s
2026-05-02 10:04:13,060 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 10:04:13,060 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-02 10:04:13,376 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3158s
2026-05-02 10:05:13,063 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 10:05:13,063 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-02 10:05:13,382 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3190s
2026-05-02 10:05:39,005 - services.database - DEBUG - [DB_OP] Starting database close
2026-05-02 10:05:39,224 - core.database - INFO - Database connection closed and engine disposed
2026-05-02 10:05:39,225 - services.database - INFO - Database connections closed
2026-05-02 10:05:39,225 - services.database - DEBUG - [DB_OP] Database close completed in 0.2196s