2026-05-02 07:01:21,755 - main - INFO - === Logging system initialized ===
2026-05-02 07:01:21,755 - main - INFO - Log file: logs/app_20260502_070121.log
2026-05-02 07:01:21,755 - main - INFO - Log level: INFO
2026-05-02 07:01:21,756 - main - INFO - Timestamp: 20260502_070121
2026-05-02 07:01:24,563 - main - INFO - Included router: routers.admin_dashboard.router
2026-05-02 07:01:24,678 - main - INFO - Included router: routers.agent_availability.router
2026-05-02 07:01:50,476 - main - INFO - Included router: routers.ai_ticket_summary.router
2026-05-02 07:01:50,824 - main - INFO - Included router: routers.aihub.router
2026-05-02 07:01:50,954 - main - INFO - Included router: routers.auth.router
2026-05-02 07:01:51,134 - main - INFO - Included router: routers.chat_analytics_daily.router
2026-05-02 07:01:51,237 - main - INFO - Included router: routers.chat_attachments.router
2026-05-02 07:01:51,482 - main - INFO - Included router: routers.chat_branding.router
2026-05-02 07:01:51,551 - main - INFO - Included router: routers.chat_branding_api.router
2026-05-02 07:01:51,714 - main - INFO - Included router: routers.chat_conversations.router
2026-05-02 07:01:51,903 - main - INFO - Included router: routers.chat_messages.router
2026-05-02 07:01:52,024 - main - INFO - Included router: routers.chat_routing_rules.router
2026-05-02 07:01:52,190 - main - INFO - Included router: routers.contact.router
2026-05-02 07:01:52,313 - main - INFO - Included router: routers.contact_inquiries.router
2026-05-02 07:01:52,370 - main - INFO - Included router: routers.health.router
2026-05-02 07:01:52,520 - main - INFO - Included router: routers.kb_article_feedback.router
2026-05-02 07:01:52,718 - main - INFO - Included router: routers.kb_articles.router
2026-05-02 07:01:52,873 - main - INFO - Included router: routers.notification_preferences.router
2026-05-02 07:01:53,015 - main - INFO - Included router: routers.notifications.router
2026-05-02 07:01:53,094 - main - INFO - Included router: routers.notifications_extras.router
2026-05-02 07:01:54,362 - main - INFO - Included router: routers.oauth.router
2026-05-02 07:01:54,506 - main - INFO - Included router: routers.plans.router
2026-05-02 07:01:54,555 - main - INFO - Included router: routers.role_management.router
2026-05-02 07:01:54,706 - main - INFO - Included router: routers.service_testimonials.router
2026-05-02 07:01:54,758 - main - INFO - Included router: routers.settings.router
2026-05-02 07:01:55,032 - main - INFO - Included router: routers.site_settings.router
2026-05-02 07:01:55,222 - main - INFO - Included router: routers.smtp_settings.router
2026-05-02 07:01:55,419 - main - INFO - Included router: routers.storage.router
2026-05-02 07:01:55,633 - main - INFO - Included router: routers.support_chat.router
2026-05-02 07:01:55,775 - main - INFO - Included router: routers.support_departments.router
2026-05-02 07:01:55,902 - main - INFO - Included router: routers.support_seats.router
2026-05-02 07:01:56,064 - main - INFO - Included router: routers.ticket_notifications_sync.router
2026-05-02 07:01:56,151 - main - INFO - Included router: routers.ticket_summaries.router
2026-05-02 07:01:56,359 - main - INFO - Included router: routers.ticket_sync_states.router
2026-05-02 07:01:56,443 - main - INFO - Included router: routers.user.router
2026-05-02 07:01:56,607 - main - INFO - Included router: routers.user_profiles.router
2026-05-02 07:01:56,696 - main - INFO - Included router: routers.user_roles.router
2026-05-02 07:01:56,716 - main - INFO - Included router: routers.whmcs.router
2026-05-02 07:01:56,785 - main - INFO - Included router: routers.whmcs_admin.router
2026-05-02 07:01:56,857 - main - INFO - Included router: routers.whmcs_extra.router
2026-05-02 07:01:56,859 - main - INFO - === Application startup initiated ===
2026-05-02 07:01:56,859 - services.database - INFO - Ignore creating tables
2026-05-02 07:01:56,860 - services.mock_data - INFO - Ignore initialize data
2026-05-02 07:01:56,860 - services.auth - INFO - Ignore initialize admin
2026-05-02 07:01:56,860 - main - INFO - === Application startup completed successfully ===
2026-05-02 07:02:07,546 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 07:02:07,546 - core.database - WARNING - Database session maker not available, attempting lazy initialization...
2026-05-02 07:02:07,546 - core.database - WARNING - Database not initialized, attempting lazy initialization...
2026-05-02 07:02:07,546 - core.database - INFO - Starting database initialization...
2026-05-02 07:02:07,546 - core.config - DEBUG - Read dynamic attribute database_url from environment variable DATABASE_URL
2026-05-02 07:02:07,547 - core.database - INFO - Normalizing database URL for async compatibility...
2026-05-02 07:02:07,547 - core.database - INFO - Creating async database engine...
2026-05-02 07:02:07,548 - core.database - INFO - Using QueuePool with connection pooling for non-Lambda environment
2026-05-02 07:02:07,745 - core.database - INFO - Database engine created successfully
2026-05-02 07:02:07,746 - core.database - INFO - Creating async session maker...
2026-05-02 07:02:07,746 - core.database - INFO - Async session maker created successfully
2026-05-02 07:02:07,746 - core.database - INFO - Database connection initialized successfully
2026-05-02 07:02:07,746 - core.database - DEBUG - [DB_OP] Starting create_tables
2026-05-02 07:02:07,746 - core.database - INFO - 🔧 Starting table creation...
2026-05-02 07:02:07,860 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-02 07:02:07,916 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 07:02:07,916 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 07:02:07,917 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 07:02:07,922 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 07:02:07,922 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-02 07:02:07,923 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 07:02:09,324 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 07:02:09,326 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.4102s
2026-05-02 07:02:09,328 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 07:02:09,329 - core.database - DEBUG - [DB_OP] Database session cleanup after 1.4071s
2026-05-02 07:02:10,917 - core.database - INFO - Tables initialized successfully
2026-05-02 07:02:10,917 - core.database - DEBUG - [DB_OP] Create tables completed in 3.1713s
2026-05-02 07:02:10,982 - core.database - INFO - Lazy database initialization completed successfully
2026-05-02 07:02:10,982 - core.database - DEBUG - [DB_OP] Database session created successfully in 3.4368s
2026-05-02 07:02:11,431 - core.database - DEBUG - [DB_OP] Database session cleanup after 3.8849s
2026-05-02 07:02:35,299 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 07:02:35,300 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-02 07:02:35,301 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-02 07:02:35,302 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 07:02:35,302 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-05-02 07:02:35,303 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 07:02:35,304 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 07:02:35,304 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0003s
2026-05-02 07:02:35,305 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 07:02:35,683 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 07:02:35,684 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3805s
2026-05-02 07:02:35,752 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4524s
2026-05-02 07:02:35,879 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 07:02:35,880 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.5776s
2026-05-02 07:03:07,539 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 07:03:07,540 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 07:03:07,858 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3190s
2026-05-02 07:03:12,079 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 07:03:12,080 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0006s
2026-05-02 07:03:12,087 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 07:03:12,087 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-02 07:03:12,087 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"branding"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 07:03:12,089 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 07:03:12,089 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0002s
2026-05-02 07:03:12,089 - routers.site_settings - DEBUG - Querying site_settingss: query={"key":"general"}, sort=None, skip=0, limit=1, fields=None
2026-05-02 07:03:12,090 - dependencies.auth - DEBUG - Authentication required for request GET /api/v1/auth/me
2026-05-02 07:03:12,403 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3232s
2026-05-02 07:03:12,468 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 07:03:12,469 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3800s
2026-05-02 07:03:12,473 - routers.site_settings - DEBUG - Found 0 site_settingss
2026-05-02 07:03:12,474 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3870s
2026-05-02 07:03:47,183 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 07:03:47,184 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 07:03:47,184 - routers.service_testimonials - DEBUG - Querying service_testimonialss: query=None, sort=None, skip=0, limit=200, fields=None
2026-05-02 07:03:47,703 - routers.service_testimonials - DEBUG - Found 5 service_testimonialss
2026-05-02 07:03:47,704 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.5203s
2026-05-02 07:04:12,106 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 07:04:12,106 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-02 07:04:12,425 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3192s
2026-05-02 07:05:13,013 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 07:05:13,013 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-02 07:05:13,400 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3874s
2026-05-02 07:06:12,074 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 07:06:12,075 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0008s
2026-05-02 07:06:12,398 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3243s
2026-05-02 07:07:13,004 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 07:07:13,004 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 07:07:13,453 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4489s
2026-05-02 07:08:13,020 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 07:08:13,020 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0008s
2026-05-02 07:08:13,476 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4559s
2026-05-02 07:09:13,022 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 07:09:13,022 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0006s
2026-05-02 07:09:13,472 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4501s
2026-05-02 07:10:13,006 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 07:10:13,006 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0006s
2026-05-02 07:10:13,326 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3198s
2026-05-02 07:11:13,998 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 07:11:13,999 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0004s
2026-05-02 07:11:14,320 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3215s
2026-05-02 07:12:13,217 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 07:12:13,218 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0006s
2026-05-02 07:12:13,540 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3224s
2026-05-02 07:13:13,139 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 07:13:13,139 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 07:13:13,585 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4459s
2026-05-02 07:14:12,994 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 07:14:12,994 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 07:14:13,446 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4518s
2026-05-02 07:15:13,006 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 07:15:13,006 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0007s
2026-05-02 07:15:13,459 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4535s
2026-05-02 07:16:13,169 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 07:16:13,170 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0007s
2026-05-02 07:16:13,487 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3178s
2026-05-02 07:17:12,984 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 07:17:12,984 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0006s
2026-05-02 07:17:13,304 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3206s
2026-05-02 07:18:12,987 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 07:18:12,988 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 07:18:13,319 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.3313s
2026-05-02 07:19:12,983 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 07:19:12,983 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0007s
2026-05-02 07:19:13,426 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4434s
2026-05-02 07:20:13,146 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 07:20:13,147 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0005s
2026-05-02 07:20:13,594 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4480s
2026-05-02 07:21:12,998 - core.database - DEBUG - [DB_OP] Starting get_db session creation
2026-05-02 07:21:12,998 - core.database - DEBUG - [DB_OP] Database session created successfully in 0.0006s
2026-05-02 07:21:13,449 - core.database - DEBUG - [DB_OP] Database session cleanup after 0.4510s
2026-05-02 07:22:08,870 - services.database - DEBUG - [DB_OP] Starting database close
2026-05-02 07:22:09,074 - core.database - INFO - Database connection closed and engine disposed
2026-05-02 07:22:09,074 - services.database - INFO - Database connections closed
2026-05-02 07:22:09,075 - services.database - DEBUG - [DB_OP] Database close completed in 0.2050s