2026-05-02 21:44:30,357 - main - INFO - === Logging system initialized ===
2026-05-02 21:44:30,358 - main - INFO - Log file: logs/app_20260502_214430.log
2026-05-02 21:44:30,358 - main - INFO - Log level: INFO
2026-05-02 21:44:30,358 - main - INFO - Timestamp: 20260502_214430
2026-05-02 21:44:32,078 - main - INFO - Included router: routers.admin_dashboard.router
2026-05-02 21:44:33,514 - main - INFO - Included router: routers.admin_users.router
2026-05-02 21:44:33,760 - main - INFO - Included router: routers.agent_availability.router
2026-05-02 21:44:59,792 - main - INFO - Included router: routers.ai_ticket_summary.router
2026-05-02 21:44:59,969 - main - INFO - Included router: routers.aihub.router
2026-05-02 21:45:00,135 - main - INFO - Included router: routers.audit_log.router
2026-05-02 21:45:00,201 - main - INFO - Included router: routers.auth.router
2026-05-02 21:45:00,248 - main - INFO - Included router: routers.cache_settings.router
2026-05-02 21:45:00,515 - main - INFO - Included router: routers.carts.router
2026-05-02 21:45:00,835 - main - INFO - Included router: routers.chat_analytics_daily.router
2026-05-02 21:45:00,934 - main - INFO - Included router: routers.chat_attachments.router
2026-05-02 21:45:01,170 - main - INFO - Included router: routers.chat_branding.router
2026-05-02 21:45:02,597 - main - INFO - Included router: routers.chat_branding_api.router
2026-05-02 21:45:02,888 - main - INFO - Included router: routers.chat_conversations.router
2026-05-02 21:45:02,975 - main - INFO - Included router: routers.chat_messages.router
2026-05-02 21:45:03,081 - main - INFO - Included router: routers.chat_routing_rules.router
2026-05-02 21:45:03,265 - main - INFO - Included router: routers.contact.router
2026-05-02 21:45:03,403 - main - INFO - Included router: routers.contact_inquiries.router
2026-05-02 21:45:04,599 - main - INFO - Included router: routers.ecom_checkout.router
2026-05-02 21:45:04,640 - main - INFO - Included router: routers.health.router
2026-05-02 21:45:04,828 - main - INFO - Included router: routers.kb_article_feedback.router
2026-05-02 21:45:05,114 - main - INFO - Included router: routers.kb_articles.router
2026-05-02 21:45:05,352 - main - INFO - Included router: routers.local_auth.router
2026-05-02 21:45:05,463 - main - INFO - Included router: routers.notification_preferences.router
2026-05-02 21:45:05,594 - main - INFO - Included router: routers.notifications.router
2026-05-02 21:45:05,628 - main - INFO - Included router: routers.notifications_extras.router
2026-05-02 21:45:05,911 - main - INFO - Included router: routers.oauth.router
2026-05-02 21:45:06,206 - main - INFO - Included router: routers.order_items.router
2026-05-02 21:45:06,393 - main - INFO - Included router: routers.orders.router
2026-05-02 21:45:06,474 - main - INFO - Included router: routers.password_reset.router
2026-05-02 21:45:06,633 - main - INFO - Included router: routers.plans.router
2026-05-02 21:45:06,759 - main - INFO - Included router: routers.product_categories.router
2026-05-02 21:45:08,018 - main - INFO - Included router: routers.product_reviews.router
2026-05-02 21:45:08,224 - main - INFO - Included router: routers.products.router
2026-05-02 21:45:08,294 - main - INFO - Included router: routers.role_management.router
2026-05-02 21:45:08,454 - main - INFO - Included router: routers.service_testimonials.router
2026-05-02 21:45:08,564 - main - INFO - Included router: routers.settings.router
2026-05-02 21:45:08,663 - main - INFO - Included router: routers.site_settings.router
2026-05-02 21:45:08,836 - main - INFO - Included router: routers.smtp_settings.router
2026-05-02 21:45:08,976 - main - INFO - Included router: routers.storage.router
2026-05-02 21:45:09,377 - main - INFO - Included router: routers.support_chat.router
2026-05-02 21:45:09,553 - main - INFO - Included router: routers.support_departments.router
2026-05-02 21:45:09,738 - main - INFO - Included router: routers.support_seats.router
2026-05-02 21:45:09,875 - main - INFO - Included router: routers.ticket_notifications_sync.router
2026-05-02 21:45:09,992 - main - INFO - Included router: routers.ticket_summaries.router
2026-05-02 21:45:10,101 - main - INFO - Included router: routers.ticket_sync_states.router
2026-05-02 21:45:10,197 - main - INFO - Included router: routers.user.router
2026-05-02 21:45:10,291 - main - INFO - Included router: routers.user_profiles.router
2026-05-02 21:45:10,458 - main - INFO - Included router: routers.user_roles.router
2026-05-02 21:45:10,476 - main - INFO - Included router: routers.whmcs.router
2026-05-02 21:45:10,569 - main - INFO - Included router: routers.whmcs_admin.router
2026-05-02 21:45:10,638 - main - INFO - Included router: routers.whmcs_extra.router
2026-05-02 21:45:10,640 - main - INFO - === Application startup initiated ===
2026-05-02 21:45:10,640 - services.database - INFO - Ignore creating tables
2026-05-02 21:45:10,640 - services.mock_data - INFO - Ignore initialize data
2026-05-02 21:45:10,640 - services.auth - INFO - Ignore initialize admin
2026-05-02 21:45:10,641 - main - INFO - === Application startup completed successfully ===
2026-05-02 21:45:17,184 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 21:45:17,184 - core.database - WARNING - Database session maker not available, attempting lazy initialization...
2026-05-02 21:45:17,185 - core.database - WARNING - Database not initialized, attempting lazy initialization...
2026-05-02 21:45:17,185 - core.database - INFO - Starting database initialization...
2026-05-02 21:45:17,185 - core.config - DEBUG - Read dynamic attribute database_url from environment variable DATABASE_URL
2026-05-02 21:45:17,185 - core.database - INFO - Normalizing database URL for async compatibility...
2026-05-02 21:45:17,186 - core.database - INFO - Creating async database engine...
2026-05-02 21:45:17,187 - core.database - INFO - Using QueuePool with connection pooling for non-Lambda environment
2026-05-02 21:45:17,232 - core.database - INFO - Database engine created successfully
2026-05-02 21:45:17,232 - core.database - INFO - Creating async session maker...
2026-05-02 21:45:17,232 - core.database - INFO - Async session maker created successfully
2026-05-02 21:45:17,233 - core.database - INFO - Database connection initialized successfully
2026-05-02 21:45:17,233 - core.database - DEBUG - [DB_OP] Starting create_tables
2026-05-02 21:45:17,233 - core.database - INFO - 🔧 Starting table creation...
2026-05-02 21:45:17,241 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 21:45:17,241 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-05-02 21:45:17,247 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-02 21:45:17,251 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 21:45:17,251 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-02 21:45:17,251 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 21:45:17,254 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 21:45:17,254 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-02 21:45:17,254 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 21:45:18,531 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.2908s
2026-05-02 21:45:18,658 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 21:45:18,658 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.4076s
2026-05-02 21:45:18,682 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 21:45:18,682 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.4287s
2026-05-02 21:45:19,643 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 21:45:19,643 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-05-02 21:45:19,644 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-02 21:45:19,645 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 21:45:19,646 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-02 21:45:19,646 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 21:45:19,647 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 21:45:19,647 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-02 21:45:19,648 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 21:45:20,023 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3805s
2026-05-02 21:45:20,087 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 21:45:20,088 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4411s
2026-05-02 21:45:20,089 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 21:45:20,089 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4438s
2026-05-02 21:45:20,765 - core.database - INFO - Tables initialized successfully
2026-05-02 21:45:20,765 - core.database - DEBUG - [DB_OP] Create tables completed in 3.5328s
2026-05-02 21:45:20,829 - core.database - INFO - Lazy database initialization completed successfully
2026-05-02 21:45:20,830 - core.database - DEBUG - [DB_OP] Database session created successfully in 3.6460s
2026-05-02 21:45:20,831 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/admin/cache
2026-05-02 21:45:20,831 - 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 21:45:20,971 - core.database - DEBUG - [DB_OP] Database session cleanup after 3.7871s
2026-05-02 21:45:20,971 - 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 21:45:50,946 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 21:45:50,947 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0008s
2026-05-02 21:45:50,949 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-02 21:45:50,951 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 21:45:50,951 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-02 21:45:50,951 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 21:45:50,953 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 21:45:50,953 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-02 21:45:50,953 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 21:45:51,265 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3184s
2026-05-02 21:45:51,329 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 21:45:51,330 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3791s
2026-05-02 21:45:51,333 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 21:45:51,333 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3805s
2026-05-02 21:45:51,450 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 21:45:51,450 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 21:45:51,450 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 21:45:51,452 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-02 21:45:51,453 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 21:45:51,453 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-02 21:45:51,454 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 21:45:51,454 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-02 21:45:51,455 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 21:45:51,770 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3167s
2026-05-02 21:45:51,832 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 21:45:51,833 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3783s
2026-05-02 21:45:52,026 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 21:45:52,027 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.5768s
2026-05-02 21:46:17,068 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 21:46:17,068 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-02 21:46:17,452 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3844s
2026-05-02 21:46:27,106 - services.database - DEBUG - [DB_OP] Starting database close
2026-05-02 21:46:27,374 - core.database - INFO - Database connection closed and engine disposed
2026-05-02 21:46:27,374 - services.database - INFO - Database connections closed
2026-05-02 21:46:27,375 - services.database - DEBUG - [DB_OP] Database close completed in 0.2687s
