2026-05-02 22:52:45,745 - main - INFO - === Logging system initialized ===
2026-05-02 22:52:45,745 - main - INFO - Log file: logs/app_20260502_225245.log
2026-05-02 22:52:45,745 - main - INFO - Log level: INFO
2026-05-02 22:52:45,745 - main - INFO - Timestamp: 20260502_225245
2026-05-02 22:52:45,814 - main - INFO - Included router: routers.admin_dashboard.router
2026-05-02 22:52:45,854 - main - INFO - Included router: routers.admin_users.router
2026-05-02 22:52:45,891 - main - INFO - Included router: routers.agent_availability.router
2026-05-02 22:52:46,858 - main - INFO - Included router: routers.ai_ticket_summary.router
2026-05-02 22:52:46,893 - main - INFO - Included router: routers.aihub.router
2026-05-02 22:52:46,916 - main - INFO - Included router: routers.audit_log.router
2026-05-02 22:52:46,933 - main - INFO - Included router: routers.auth.router
2026-05-02 22:52:46,956 - main - INFO - Included router: routers.cache_settings.router
2026-05-02 22:52:47,005 - main - INFO - Included router: routers.carts.router
2026-05-02 22:52:47,079 - main - INFO - Included router: routers.chat_analytics_daily.router
2026-05-02 22:52:47,126 - main - INFO - Included router: routers.chat_attachments.router
2026-05-02 22:52:47,199 - main - INFO - Included router: routers.chat_branding.router
2026-05-02 22:52:47,219 - main - INFO - Included router: routers.chat_branding_api.router
2026-05-02 22:52:47,360 - main - INFO - Included router: routers.chat_conversations.router
2026-05-02 22:52:47,403 - main - INFO - Included router: routers.chat_messages.router
2026-05-02 22:52:47,449 - main - INFO - Included router: routers.chat_routing_rules.router
2026-05-02 22:52:47,474 - main - INFO - Included router: routers.contact.router
2026-05-02 22:52:47,516 - main - INFO - Included router: routers.contact_inquiries.router
2026-05-02 22:52:47,567 - main - INFO - Included router: routers.ecom_checkout.router
2026-05-02 22:52:47,569 - main - INFO - Included router: routers.health.router
2026-05-02 22:52:47,615 - main - INFO - Included router: routers.kb_article_feedback.router
2026-05-02 22:52:47,662 - main - INFO - Included router: routers.kb_articles.router
2026-05-02 22:52:47,682 - main - INFO - Included router: routers.local_auth.router
2026-05-02 22:52:47,736 - main - INFO - Included router: routers.notification_preferences.router
2026-05-02 22:52:47,785 - main - INFO - Included router: routers.notifications.router
2026-05-02 22:52:47,792 - main - INFO - Included router: routers.notifications_extras.router
2026-05-02 22:52:47,894 - main - INFO - Included router: routers.oauth.router
2026-05-02 22:52:48,101 - main - INFO - Included router: routers.order_items.router
2026-05-02 22:52:48,161 - main - INFO - Included router: routers.orders.router
2026-05-02 22:52:48,169 - main - INFO - Included router: routers.password_reset.router
2026-05-02 22:52:48,224 - main - INFO - Included router: routers.plans.router
2026-05-02 22:52:48,268 - main - INFO - Included router: routers.product_categories.router
2026-05-02 22:52:48,320 - main - INFO - Included router: routers.product_reviews.router
2026-05-02 22:52:48,381 - main - INFO - Included router: routers.products.router
2026-05-02 22:52:48,407 - main - INFO - Included router: routers.role_management.router
2026-05-02 22:52:48,455 - main - INFO - Included router: routers.service_testimonials.router
2026-05-02 22:52:48,474 - main - INFO - Included router: routers.settings.router
2026-05-02 22:52:48,530 - main - INFO - Included router: routers.site_settings.router
2026-05-02 22:52:48,574 - main - INFO - Included router: routers.smtp_settings.router
2026-05-02 22:52:48,616 - main - INFO - Included router: routers.storage.router
2026-05-02 22:52:48,928 - main - INFO - Included router: routers.support_chat.router
2026-05-02 22:52:48,964 - main - INFO - Included router: routers.support_departments.router
2026-05-02 22:52:49,006 - main - INFO - Included router: routers.support_seats.router
2026-05-02 22:52:49,050 - main - INFO - Included router: routers.ticket_notifications_sync.router
2026-05-02 22:52:49,090 - main - INFO - Included router: routers.ticket_summaries.router
2026-05-02 22:52:49,131 - main - INFO - Included router: routers.ticket_sync_states.router
2026-05-02 22:52:49,145 - main - INFO - Included router: routers.user.router
2026-05-02 22:52:49,188 - main - INFO - Included router: routers.user_profiles.router
2026-05-02 22:52:49,224 - main - INFO - Included router: routers.user_roles.router
2026-05-02 22:52:49,314 - main - INFO - Included router: routers.visitor_monitor.router
2026-05-02 22:52:49,324 - main - INFO - Included router: routers.visitor_tracking.router
2026-05-02 22:52:49,344 - main - INFO - Included router: routers.whmcs.router
2026-05-02 22:52:49,414 - main - INFO - Included router: routers.whmcs_admin.router
2026-05-02 22:52:49,451 - main - INFO - Included router: routers.whmcs_extra.router
2026-05-02 22:52:49,452 - main - INFO - === Application startup initiated ===
2026-05-02 22:52:49,452 - services.database - INFO - Ignore creating tables
2026-05-02 22:52:49,453 - services.mock_data - INFO - Ignore initialize data
2026-05-02 22:52:49,453 - services.auth - INFO - Ignore initialize admin
2026-05-02 22:52:49,453 - main - INFO - === Application startup completed successfully ===
2026-05-02 22:52:52,441 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 22:52:52,441 - core.database - WARNING - Database session maker not available, attempting lazy initialization...
2026-05-02 22:52:52,441 - core.database - WARNING - Database not initialized, attempting lazy initialization...
2026-05-02 22:52:52,441 - core.database - INFO - Starting database initialization...
2026-05-02 22:52:52,441 - core.config - DEBUG - Read dynamic attribute database_url from environment variable DATABASE_URL
2026-05-02 22:52:52,441 - core.database - INFO - Normalizing database URL for async compatibility...
2026-05-02 22:52:52,442 - core.database - INFO - Creating async database engine...
2026-05-02 22:52:52,442 - core.database - INFO - Using QueuePool with connection pooling for non-Lambda environment
2026-05-02 22:52:52,488 - core.database - INFO - Database engine created successfully
2026-05-02 22:52:52,489 - core.database - INFO - Creating async session maker...
2026-05-02 22:52:52,489 - core.database - INFO - Async session maker created successfully
2026-05-02 22:52:52,489 - core.database - INFO - Database connection initialized successfully
2026-05-02 22:52:52,489 - core.database - DEBUG - [DB_OP] Starting create_tables
2026-05-02 22:52:52,489 - core.database - INFO - 🔧 Starting table creation...
2026-05-02 22:52:52,494 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 22:52:52,494 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-02 22:52:52,499 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-02 22:52:52,502 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 22:52:52,502 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-02 22:52:52,502 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 22:52:52,505 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 22:52:52,505 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-02 22:52:52,505 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 22:52:53,801 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.3071s
2026-05-02 22:52:53,922 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 22:52:53,923 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.4179s
2026-05-02 22:52:53,926 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 22:52:53,927 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.4252s
2026-05-02 22:52:56,275 - core.database - INFO - Tables initialized successfully
2026-05-02 22:52:56,276 - core.database - DEBUG - [DB_OP] Create tables completed in 3.7870s
2026-05-02 22:52:56,340 - core.database - INFO - Lazy database initialization completed successfully
2026-05-02 22:52:56,341 - core.database - DEBUG - [DB_OP] Database session created successfully in 3.9001s
2026-05-02 22:52:56,341 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/admin/cache
2026-05-02 22:52:56,341 - 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 22:52:56,346 - core.database - DEBUG - [DB_OP] Database session cleanup after 3.9056s
2026-05-02 22:52:56,347 - 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 22:53:18,630 - services.database - DEBUG - [DB_OP] Starting database close
2026-05-02 22:53:18,896 - core.database - INFO - Database connection closed and engine disposed
2026-05-02 22:53:18,896 - services.database - INFO - Database connections closed
2026-05-02 22:53:18,896 - services.database - DEBUG - [DB_OP] Database close completed in 0.2667s
