2026-05-02 05:44:26,342 - main - INFO - === Logging system initialized ===
2026-05-02 05:44:26,343 - main - INFO - Log file: logs/app_20260502_054426.log
2026-05-02 05:44:26,343 - main - INFO - Log level: INFO
2026-05-02 05:44:26,343 - main - INFO - Timestamp: 20260502_054426
2026-05-02 05:44:26,418 - main - INFO - Included router: routers.admin_dashboard.router
2026-05-02 05:44:26,463 - main - INFO - Included router: routers.agent_availability.router
2026-05-02 05:44:27,293 - main - INFO - Included router: routers.ai_ticket_summary.router
2026-05-02 05:44:27,311 - main - INFO - Included router: routers.aihub.router
2026-05-02 05:44:27,322 - main - INFO - Included router: routers.auth.router
2026-05-02 05:44:27,367 - main - INFO - Included router: routers.chat_analytics_daily.router
2026-05-02 05:44:27,406 - main - INFO - Included router: routers.chat_attachments.router
2026-05-02 05:44:27,468 - main - INFO - Included router: routers.chat_branding.router
2026-05-02 05:44:27,482 - main - INFO - Included router: routers.chat_branding_api.router
2026-05-02 05:44:27,533 - main - INFO - Included router: routers.chat_conversations.router
2026-05-02 05:44:27,644 - main - INFO - Included router: routers.chat_messages.router
2026-05-02 05:44:27,685 - main - INFO - Included router: routers.chat_routing_rules.router
2026-05-02 05:44:27,705 - main - INFO - Included router: routers.contact.router
2026-05-02 05:44:27,746 - main - INFO - Included router: routers.contact_inquiries.router
2026-05-02 05:44:27,748 - main - INFO - Included router: routers.health.router
2026-05-02 05:44:27,793 - main - INFO - Included router: routers.kb_article_feedback.router
2026-05-02 05:44:27,832 - main - INFO - Included router: routers.kb_articles.router
2026-05-02 05:44:27,876 - main - INFO - Included router: routers.notification_preferences.router
2026-05-02 05:44:27,921 - main - INFO - Included router: routers.notifications.router
2026-05-02 05:44:27,925 - main - INFO - Included router: routers.notifications_extras.router
2026-05-02 05:44:28,003 - main - INFO - Included router: routers.oauth.router
2026-05-02 05:44:28,088 - main - INFO - Included router: routers.plans.router
2026-05-02 05:44:28,109 - main - INFO - Included router: routers.role_management.router
2026-05-02 05:44:28,158 - main - INFO - Included router: routers.service_testimonials.router
2026-05-02 05:44:28,176 - main - INFO - Included router: routers.settings.router
2026-05-02 05:44:28,300 - main - INFO - Included router: routers.site_settings.router
2026-05-02 05:44:28,334 - main - INFO - Included router: routers.smtp_settings.router
2026-05-02 05:44:28,369 - main - INFO - Included router: routers.storage.router
2026-05-02 05:44:28,477 - main - INFO - Included router: routers.support_chat.router
2026-05-02 05:44:28,522 - main - INFO - Included router: routers.support_departments.router
2026-05-02 05:44:28,563 - main - INFO - Included router: routers.support_seats.router
2026-05-02 05:44:28,570 - main - INFO - Included router: routers.ticket_notifications_sync.router
2026-05-02 05:44:28,605 - main - INFO - Included router: routers.ticket_summaries.router
2026-05-02 05:44:28,644 - main - INFO - Included router: routers.ticket_sync_states.router
2026-05-02 05:44:28,651 - main - INFO - Included router: routers.user.router
2026-05-02 05:44:28,692 - main - INFO - Included router: routers.user_profiles.router
2026-05-02 05:44:28,726 - main - INFO - Included router: routers.user_roles.router
2026-05-02 05:44:28,744 - main - INFO - Included router: routers.whmcs.router
2026-05-02 05:44:28,798 - main - INFO - Included router: routers.whmcs_admin.router
2026-05-02 05:44:28,833 - main - INFO - Included router: routers.whmcs_extra.router
2026-05-02 05:44:28,834 - main - INFO - === Application startup initiated ===
2026-05-02 05:44:28,834 - services.database - INFO - Ignore creating tables
2026-05-02 05:44:28,834 - services.mock_data - INFO - Ignore initialize data
2026-05-02 05:44:28,834 - services.auth - INFO - Ignore initialize admin
2026-05-02 05:44:28,834 - main - INFO - === Application startup completed successfully ===
2026-05-02 05:44:37,718 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:44:37,718 - core.database - WARNING - Database session maker not available, attempting lazy initialization...
2026-05-02 05:44:37,718 - core.database - WARNING - Database not initialized, attempting lazy initialization...
2026-05-02 05:44:37,718 - core.database - INFO - Starting database initialization...
2026-05-02 05:44:37,718 - core.config - DEBUG - Read dynamic attribute database_url from environment variable DATABASE_URL
2026-05-02 05:44:37,718 - core.database - INFO - Normalizing database URL for async compatibility...
2026-05-02 05:44:37,719 - core.database - INFO - Creating async database engine...
2026-05-02 05:44:37,719 - core.database - INFO - Using QueuePool with connection pooling for non-Lambda environment
2026-05-02 05:44:37,864 - core.database - INFO - Database engine created successfully
2026-05-02 05:44:37,864 - core.database - INFO - Creating async session maker...
2026-05-02 05:44:37,864 - core.database - INFO - Async session maker created successfully
2026-05-02 05:44:37,864 - core.database - INFO - Database connection initialized successfully
2026-05-02 05:44:37,865 - core.database - DEBUG - [DB_OP] Starting create_tables
2026-05-02 05:44:37,865 - core.database - INFO - 🔧 Starting table creation...
2026-05-02 05:44:37,869 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-02 05:44:37,872 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:44:37,872 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-02 05:44:37,872 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 05:44:37,875 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:44:37,875 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-02 05:44:37,875 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 05:44:39,263 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 05:44:39,264 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.3923s
2026-05-02 05:44:39,265 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 05:44:39,265 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.3903s
2026-05-02 05:44:40,786 - core.database - INFO - Tables initialized successfully
2026-05-02 05:44:40,786 - core.database - DEBUG - [DB_OP] Create tables completed in 2.9215s
2026-05-02 05:44:40,849 - core.database - INFO - Lazy database initialization completed successfully
2026-05-02 05:44:40,850 - core.database - DEBUG - [DB_OP] Database session created successfully in 3.1320s
2026-05-02 05:44:41,296 - core.database - DEBUG - [DB_OP] Database session cleanup after 3.5783s
2026-05-02 05:45:37,701 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:45:37,701 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-05-02 05:45:38,147 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4458s
2026-05-02 05:46:21,345 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:46:21,346 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 05:46:21,346 - routers.service_testimonials - DEBUG - Querying service_testimonialss: query=None, sort=None, skip=0, limit=200, fields=None
2026-05-02 05:46:21,927 - routers.service_testimonials - DEBUG - Found 5 service_testimonialss
2026-05-02 05:46:21,928 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.5827s
2026-05-02 05:46:51,923 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:46:51,923 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0006s
2026-05-02 05:46:51,925 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-02 05:46:51,926 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:46:51,927 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-05-02 05:46:51,927 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 05:46:51,929 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:46:51,929 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-02 05:46:51,929 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 05:46:52,241 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3182s
2026-05-02 05:46:52,307 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 05:46:52,308 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3817s
2026-05-02 05:46:52,436 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 05:46:52,437 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.5080s
2026-05-02 05:46:52,871 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:46:52,871 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-02 05:46:53,188 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3178s
2026-05-02 05:47:19,351 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:47:19,351 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-02 05:47:19,358 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-02 05:47:19,363 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:47:19,363 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-05-02 05:47:19,363 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 05:47:19,365 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 05:47:19,365 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0001s
2026-05-02 05:47:19,365 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 05:47:19,672 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3207s
2026-05-02 05:47:19,744 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 05:47:19,745 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3826s
2026-05-02 05:47:19,746 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 05:47:19,747 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3821s
2026-05-02 05:47:54,122 - services.database - DEBUG - [DB_OP] Starting database close
2026-05-02 05:47:54,325 - core.database - INFO - Database connection closed and engine disposed
2026-05-02 05:47:54,325 - services.database - INFO - Database connections closed
2026-05-02 05:47:54,325 - services.database - DEBUG - [DB_OP] Database close completed in 0.2030s
