2026-05-02 20:17:33,749 - main - INFO - === Logging system initialized ===
2026-05-02 20:17:33,750 - main - INFO - Log file: logs/app_20260502_201733.log
2026-05-02 20:17:33,750 - main - INFO - Log level: INFO
2026-05-02 20:17:33,750 - main - INFO - Timestamp: 20260502_201733
2026-05-02 20:17:33,824 - main - INFO - Included router: routers.admin_dashboard.router
2026-05-02 20:17:33,866 - main - INFO - Included router: routers.admin_users.router
2026-05-02 20:17:33,906 - main - INFO - Included router: routers.agent_availability.router
2026-05-02 20:17:35,073 - main - INFO - Included router: routers.ai_ticket_summary.router
2026-05-02 20:17:35,095 - main - INFO - Included router: routers.aihub.router
2026-05-02 20:17:35,129 - main - INFO - Included router: routers.audit_log.router
2026-05-02 20:17:35,143 - main - INFO - Included router: routers.auth.router
2026-05-02 20:17:35,172 - main - INFO - Included router: routers.cache_settings.router
2026-05-02 20:17:35,227 - main - INFO - Included router: routers.carts.router
2026-05-02 20:17:35,286 - main - INFO - Included router: routers.chat_analytics_daily.router
2026-05-02 20:17:35,337 - main - INFO - Included router: routers.chat_attachments.router
2026-05-02 20:17:35,418 - main - INFO - Included router: routers.chat_branding.router
2026-05-02 20:17:35,458 - main - INFO - Included router: routers.chat_branding_api.router
2026-05-02 20:17:35,621 - main - INFO - Included router: routers.chat_conversations.router
2026-05-02 20:17:35,678 - main - INFO - Included router: routers.chat_messages.router
2026-05-02 20:17:35,733 - main - INFO - Included router: routers.chat_routing_rules.router
2026-05-02 20:17:35,762 - main - INFO - Included router: routers.contact.router
2026-05-02 20:17:35,801 - main - INFO - Included router: routers.contact_inquiries.router
2026-05-02 20:17:35,860 - main - INFO - Included router: routers.ecom_checkout.router
2026-05-02 20:17:35,863 - main - INFO - Included router: routers.health.router
2026-05-02 20:17:35,907 - main - INFO - Included router: routers.kb_article_feedback.router
2026-05-02 20:17:35,955 - main - INFO - Included router: routers.kb_articles.router
2026-05-02 20:17:35,971 - main - INFO - Included router: routers.local_auth.router
2026-05-02 20:17:36,019 - main - INFO - Included router: routers.notification_preferences.router
2026-05-02 20:17:36,097 - main - INFO - Included router: routers.notifications.router
2026-05-02 20:17:36,101 - main - INFO - Included router: routers.notifications_extras.router
2026-05-02 20:17:36,205 - main - INFO - Included router: routers.oauth.router
2026-05-02 20:17:36,401 - main - INFO - Included router: routers.order_items.router
2026-05-02 20:17:36,482 - main - INFO - Included router: routers.orders.router
2026-05-02 20:17:36,490 - main - INFO - Included router: routers.password_reset.router
2026-05-02 20:17:36,544 - main - INFO - Included router: routers.plans.router
2026-05-02 20:17:36,592 - main - INFO - Included router: routers.product_categories.router
2026-05-02 20:17:36,641 - main - INFO - Included router: routers.product_reviews.router
2026-05-02 20:17:36,703 - main - INFO - Included router: routers.products.router
2026-05-02 20:17:36,740 - main - INFO - Included router: routers.role_management.router
2026-05-02 20:17:36,786 - main - INFO - Included router: routers.service_testimonials.router
2026-05-02 20:17:36,807 - main - INFO - Included router: routers.settings.router
2026-05-02 20:17:36,847 - main - INFO - Included router: routers.site_settings.router
2026-05-02 20:17:36,891 - main - INFO - Included router: routers.smtp_settings.router
2026-05-02 20:17:36,933 - main - INFO - Included router: routers.storage.router
2026-05-02 20:17:37,204 - main - INFO - Included router: routers.support_chat.router
2026-05-02 20:17:37,264 - main - INFO - Included router: routers.support_departments.router
2026-05-02 20:17:37,309 - main - INFO - Included router: routers.support_seats.router
2026-05-02 20:17:37,319 - main - INFO - Included router: routers.ticket_notifications_sync.router
2026-05-02 20:17:37,367 - main - INFO - Included router: routers.ticket_summaries.router
2026-05-02 20:17:37,409 - main - INFO - Included router: routers.ticket_sync_states.router
2026-05-02 20:17:37,418 - main - INFO - Included router: routers.user.router
2026-05-02 20:17:37,463 - main - INFO - Included router: routers.user_profiles.router
2026-05-02 20:17:37,499 - main - INFO - Included router: routers.user_roles.router
2026-05-02 20:17:37,516 - main - INFO - Included router: routers.whmcs.router
2026-05-02 20:17:37,580 - main - INFO - Included router: routers.whmcs_admin.router
2026-05-02 20:17:37,621 - main - INFO - Included router: routers.whmcs_extra.router
2026-05-02 20:17:37,622 - main - INFO - === Application startup initiated ===
2026-05-02 20:17:37,623 - services.database - INFO - Ignore creating tables
2026-05-02 20:17:37,623 - services.mock_data - INFO - Ignore initialize data
2026-05-02 20:17:37,623 - services.auth - INFO - Ignore initialize admin
2026-05-02 20:17:37,623 - main - INFO - === Application startup completed successfully ===
2026-05-02 20:17:41,187 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 20:17:41,187 - core.database - WARNING - Database session maker not available, attempting lazy initialization...
2026-05-02 20:17:41,187 - core.database - WARNING - Database not initialized, attempting lazy initialization...
2026-05-02 20:17:41,187 - core.database - INFO - Starting database initialization...
2026-05-02 20:17:41,187 - core.config - DEBUG - Read dynamic attribute database_url from environment variable DATABASE_URL
2026-05-02 20:17:41,187 - core.database - INFO - Normalizing database URL for async compatibility...
2026-05-02 20:17:41,188 - core.database - INFO - Creating async database engine...
2026-05-02 20:17:41,189 - core.database - INFO - Using QueuePool with connection pooling for non-Lambda environment
2026-05-02 20:17:41,237 - core.database - INFO - Database engine created successfully
2026-05-02 20:17:41,238 - core.database - INFO - Creating async session maker...
2026-05-02 20:17:41,238 - core.database - INFO - Async session maker created successfully
2026-05-02 20:17:41,238 - core.database - INFO - Database connection initialized successfully
2026-05-02 20:17:41,238 - core.database - DEBUG - [DB_OP] Starting create_tables
2026-05-02 20:17:41,238 - core.database - INFO - 🔧 Starting table creation...
2026-05-02 20:17:41,244 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 20:17:41,244 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-05-02 20:17:41,249 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-02 20:17:41,253 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 20:17:41,253 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-05-02 20:17:41,253 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 20:17:41,256 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 20:17:41,256 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-02 20:17:41,257 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 20:17:42,523 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.2788s
2026-05-02 20:17:42,648 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 20:17:42,649 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.3935s
2026-05-02 20:17:42,660 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 20:17:42,661 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.4084s
2026-05-02 20:17:44,716 - core.database - INFO - Tables initialized successfully
2026-05-02 20:17:44,716 - core.database - DEBUG - [DB_OP] Create tables completed in 3.4782s
2026-05-02 20:17:44,779 - core.database - INFO - Lazy database initialization completed successfully
2026-05-02 20:17:44,780 - core.database - DEBUG - [DB_OP] Database session created successfully in 3.5932s
2026-05-02 20:17:44,780 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/admin/cache
2026-05-02 20:17:44,780 - core.database - ERROR - Database session error: 401: Authentication credentials were not provided
Traceback (most recent call last):
  File "/workspace/app/backend/core/database.py", line 602, in get_db
    yield session
  File "/data/chats/99daa102ba1446f6aa2f99771f457055/.cache/python/lib/python3.10/site-packages/fastapi/routing.py", line 120, in app
    response = await f(request)
  File "/data/chats/99daa102ba1446f6aa2f99771f457055/.cache/python/lib/python3.10/site-packages/fastapi/routing.py", line 457, in app
    solved_result = await solve_dependencies(
  File "/data/chats/99daa102ba1446f6aa2f99771f457055/.cache/python/lib/python3.10/site-packages/fastapi/dependencies/utils.py", line 649, in solve_dependencies
    solved_result = await solve_dependencies(
  File "/data/chats/99daa102ba1446f6aa2f99771f457055/.cache/python/lib/python3.10/site-packages/fastapi/dependencies/utils.py", line 649, in solve_dependencies
    solved_result = await solve_dependencies(
  File "/data/chats/99daa102ba1446f6aa2f99771f457055/.cache/python/lib/python3.10/site-packages/fastapi/dependencies/utils.py", line 678, in solve_dependencies
    solved = await call(**solved_result.values)
  File "/workspace/app/backend/dependencies/auth.py", line 24, in get_bearer_token
    raise HTTPException(status_code=status.HTTP_401_UNAUTHORIZED, detail="Authentication credentials were not provided")
fastapi.exceptions.HTTPException: 401: Authentication credentials were not provided
2026-05-02 20:17:44,788 - core.database - DEBUG - [DB_OP] Database session cleanup after 3.6013s
2026-05-02 20:17:44,788 - core.database - ERROR - Failed to create database session: 401: Authentication credentials were not provided
Traceback (most recent call last):
  File "/workspace/app/backend/core/database.py", line 602, in get_db
    yield session
  File "/data/chats/99daa102ba1446f6aa2f99771f457055/.cache/python/lib/python3.10/site-packages/fastapi/routing.py", line 120, in app
    response = await f(request)
  File "/data/chats/99daa102ba1446f6aa2f99771f457055/.cache/python/lib/python3.10/site-packages/fastapi/routing.py", line 457, in app
    solved_result = await solve_dependencies(
  File "/data/chats/99daa102ba1446f6aa2f99771f457055/.cache/python/lib/python3.10/site-packages/fastapi/dependencies/utils.py", line 649, in solve_dependencies
    solved_result = await solve_dependencies(
  File "/data/chats/99daa102ba1446f6aa2f99771f457055/.cache/python/lib/python3.10/site-packages/fastapi/dependencies/utils.py", line 649, in solve_dependencies
    solved_result = await solve_dependencies(
  File "/data/chats/99daa102ba1446f6aa2f99771f457055/.cache/python/lib/python3.10/site-packages/fastapi/dependencies/utils.py", line 678, in solve_dependencies
    solved = await call(**solved_result.values)
  File "/workspace/app/backend/dependencies/auth.py", line 24, in get_bearer_token
    raise HTTPException(status_code=status.HTTP_401_UNAUTHORIZED, detail="Authentication credentials were not provided")
fastapi.exceptions.HTTPException: 401: Authentication credentials were not provided
2026-05-02 20:18:13,167 - services.database - DEBUG - [DB_OP] Starting database close
2026-05-02 20:18:13,433 - core.database - INFO - Database connection closed and engine disposed
2026-05-02 20:18:13,434 - services.database - INFO - Database connections closed
2026-05-02 20:18:13,434 - services.database - DEBUG - [DB_OP] Database close completed in 0.2668s