2026-05-03 01:42:13,207 - main - INFO - === Logging system initialized ===
2026-05-03 01:42:13,207 - main - INFO - Log file: logs/app_20260503_014213.log
2026-05-03 01:42:13,207 - main - INFO - Log level: INFO
2026-05-03 01:42:13,207 - main - INFO - Timestamp: 20260503_014213
2026-05-03 01:42:13,284 - main - INFO - Included router: routers.admin_dashboard.router
2026-05-03 01:42:13,323 - main - INFO - Included router: routers.admin_users.router
2026-05-03 01:42:13,375 - main - INFO - Included router: routers.agent_availability.router
2026-05-03 01:42:14,176 - main - INFO - Included router: routers.ai_ticket_summary.router
2026-05-03 01:42:14,199 - main - INFO - Included router: routers.aihub.router
2026-05-03 01:42:14,217 - main - INFO - Included router: routers.audit_log.router
2026-05-03 01:42:14,227 - main - INFO - Included router: routers.auth.router
2026-05-03 01:42:14,254 - main - INFO - Included router: routers.cache_settings.router
2026-05-03 01:42:14,305 - main - INFO - Included router: routers.carts.router
2026-05-03 01:42:14,353 - main - INFO - Included router: routers.chat_analytics_daily.router
2026-05-03 01:42:14,397 - main - INFO - Included router: routers.chat_attachments.router
2026-05-03 01:42:14,462 - main - INFO - Included router: routers.chat_branding.router
2026-05-03 01:42:14,482 - main - INFO - Included router: routers.chat_branding_api.router
2026-05-03 01:42:14,612 - main - INFO - Included router: routers.chat_conversations.router
2026-05-03 01:42:14,658 - main - INFO - Included router: routers.chat_messages.router
2026-05-03 01:42:14,697 - main - INFO - Included router: routers.chat_routing_rules.router
2026-05-03 01:42:14,721 - main - INFO - Included router: routers.contact.router
2026-05-03 01:42:14,760 - main - INFO - Included router: routers.contact_inquiries.router
2026-05-03 01:42:14,802 - main - INFO - Included router: routers.ecom_checkout.router
2026-05-03 01:42:14,806 - main - INFO - Included router: routers.health.router
2026-05-03 01:42:14,847 - main - INFO - Included router: routers.kb_article_feedback.router
2026-05-03 01:42:14,889 - main - INFO - Included router: routers.kb_articles.router
2026-05-03 01:42:14,901 - main - INFO - Included router: routers.local_auth.router
2026-05-03 01:42:14,947 - main - INFO - Included router: routers.notification_preferences.router
2026-05-03 01:42:14,990 - main - INFO - Included router: routers.notifications.router
2026-05-03 01:42:14,994 - main - INFO - Included router: routers.notifications_extras.router
2026-05-03 01:42:15,114 - main - INFO - Included router: routers.oauth.router
2026-05-03 01:42:15,295 - main - INFO - Included router: routers.order_items.router
2026-05-03 01:42:15,362 - main - INFO - Included router: routers.orders.router
2026-05-03 01:42:15,369 - main - INFO - Included router: routers.password_reset.router
2026-05-03 01:42:15,418 - main - INFO - Included router: routers.plans.router
2026-05-03 01:42:15,459 - main - INFO - Included router: routers.product_categories.router
2026-05-03 01:42:15,503 - main - INFO - Included router: routers.product_reviews.router
2026-05-03 01:42:15,558 - main - INFO - Included router: routers.products.router
2026-05-03 01:42:15,579 - main - INFO - Included router: routers.role_management.router
2026-05-03 01:42:15,619 - main - INFO - Included router: routers.service_testimonials.router
2026-05-03 01:42:15,638 - main - INFO - Included router: routers.settings.router
2026-05-03 01:42:15,673 - main - INFO - Included router: routers.site_settings.router
2026-05-03 01:42:15,707 - main - INFO - Included router: routers.smtp_settings.router
2026-05-03 01:42:15,742 - main - INFO - Included router: routers.storage.router
2026-05-03 01:42:15,998 - main - INFO - Included router: routers.support_chat.router
2026-05-03 01:42:16,117 - main - INFO - Included router: routers.support_departments.router
2026-05-03 01:42:16,161 - main - INFO - Included router: routers.support_seats.router
2026-05-03 01:42:16,168 - main - INFO - Included router: routers.ticket_notifications_sync.router
2026-05-03 01:42:16,205 - main - INFO - Included router: routers.ticket_summaries.router
2026-05-03 01:42:16,244 - main - INFO - Included router: routers.ticket_sync_states.router
2026-05-03 01:42:16,252 - main - INFO - Included router: routers.user.router
2026-05-03 01:42:16,294 - main - INFO - Included router: routers.user_profiles.router
2026-05-03 01:42:16,337 - main - INFO - Included router: routers.user_roles.router
2026-05-03 01:42:16,447 - main - INFO - Included router: routers.visitor_monitor.router
2026-05-03 01:42:16,456 - main - INFO - Included router: routers.visitor_tracking.router
2026-05-03 01:42:16,475 - main - INFO - Included router: routers.whmcs.router
2026-05-03 01:42:16,537 - main - INFO - Included router: routers.whmcs_admin.router
2026-05-03 01:42:16,578 - main - INFO - Included router: routers.whmcs_extra.router
2026-05-03 01:42:16,580 - main - INFO - === Application startup initiated ===
2026-05-03 01:42:16,581 - services.database - INFO - Ignore creating tables
2026-05-03 01:42:16,581 - services.mock_data - INFO - Ignore initialize data
2026-05-03 01:42:16,581 - services.auth - INFO - Ignore initialize admin
2026-05-03 01:42:16,581 - main - INFO - === Application startup completed successfully ===
2026-05-03 01:44:34,869 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-03 01:44:34,870 - core.database - WARNING - Database session maker not available, attempting lazy initialization...
2026-05-03 01:44:34,870 - core.database - WARNING - Database not initialized, attempting lazy initialization...
2026-05-03 01:44:34,870 - core.database - INFO - Starting database initialization...
2026-05-03 01:44:34,870 - core.config - DEBUG - Read dynamic attribute database_url from environment variable DATABASE_URL
2026-05-03 01:44:34,870 - core.database - INFO - Normalizing database URL for async compatibility...
2026-05-03 01:44:34,872 - core.database - INFO - Creating async database engine...
2026-05-03 01:44:34,873 - core.database - INFO - Using QueuePool with connection pooling for non-Lambda environment
2026-05-03 01:44:34,918 - core.database - INFO - Database engine created successfully
2026-05-03 01:44:34,919 - core.database - INFO - Creating async session maker...
2026-05-03 01:44:34,919 - core.database - INFO - Async session maker created successfully
2026-05-03 01:44:34,919 - core.database - INFO - Database connection initialized successfully
2026-05-03 01:44:34,919 - core.database - DEBUG - [DB_OP] Starting create_tables
2026-05-03 01:44:34,919 - core.database - INFO - 🔧 Starting table creation...
2026-05-03 01:44:34,924 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-03 01:44:34,927 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-03 01:44:34,927 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-03 01:44:34,928 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-03 01:44:34,933 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-03 01:44:34,933 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-03 01:44:35,004 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-03 01:44:35,005 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-03 01:44:35,005 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-03 01:44:36,212 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.2791s
2026-05-03 01:44:36,339 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-03 01:44:36,340 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.3359s
2026-05-03 01:44:36,341 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-03 01:44:36,342 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.4148s
2026-05-03 01:44:38,688 - core.database - INFO - Tables initialized successfully
2026-05-03 01:44:38,688 - core.database - DEBUG - [DB_OP] Create tables completed in 3.7691s
2026-05-03 01:44:38,752 - core.database - INFO - Lazy database initialization completed successfully
2026-05-03 01:44:38,752 - core.database - DEBUG - [DB_OP] Database session created successfully in 3.8829s
2026-05-03 01:44:39,777 - core.database - DEBUG - [DB_OP] Database session cleanup after 4.9075s
2026-05-03 01:45:00,948 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-03 01:45:00,949 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-03 01:45:00,982 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-03 01:45:00,983 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-03 01:45:00,983 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-03 01:45:00,985 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-03 01:45:00,985 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-03 01:45:00,986 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-03 01:45:00,987 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-03 01:45:00,987 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-03 01:45:00,987 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-03 01:45:01,425 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4421s
2026-05-03 01:45:01,489 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-03 01:45:01,489 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.5024s
2026-05-03 01:45:01,559 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-03 01:45:01,560 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.5751s
2026-05-03 01:45:01,834 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.8851s
2026-05-03 01:45:23,475 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-03 01:45:23,475 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-03 01:45:23,543 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-03 01:45:23,543 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-05-03 01:45:23,544 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-03 01:45:23,546 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-03 01:45:23,546 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-05-03 01:45:23,546 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-03 01:45:23,547 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-03 01:45:23,548 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-03 01:45:23,548 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-03 01:45:23,855 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3121s
2026-05-03 01:45:23,920 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-03 01:45:23,920 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3729s
2026-05-03 01:45:23,929 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-03 01:45:23,929 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3838s
2026-05-03 01:45:24,432 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.9572s
2026-05-03 01:45:35,541 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-03 01:45:35,542 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-03 01:45:35,855 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3134s
2026-05-03 01:45:50,687 - services.database - DEBUG - [DB_OP] Starting database close
2026-05-03 01:45:50,950 - core.database - INFO - Database connection closed and engine disposed
2026-05-03 01:45:50,950 - services.database - INFO - Database connections closed
2026-05-03 01:45:50,951 - services.database - DEBUG - [DB_OP] Database close completed in 0.2642s