{
    "timestamp": "2026-09-15 04:00:06",
    "level": "INFO",
    "message": "[syncCourseTypes] Hoàn thành toàn bộ. Tổng = 1"
}
{
    "timestamp": "2026-09-15 04:00:06",
    "level": "INFO",
    "message": "[syncCourses] Hoàn thành toàn bộ. Tổng = 1"
}
{
    "timestamp": "2026-09-15 04:00:06",
    "level": "INFO",
    "message": "[syncStudents] Hoàn thành toàn bộ. Tổng = 5"
}
{
    "timestamp": "2026-09-15 04:00:06",
    "level": "INFO",
    "message": "[syncCourseStudents] Hoàn thành toàn bộ. Tổng = 1"
}
{
    "timestamp": "2026-09-15 04:00:06",
    "level": "INFO",
    "message": "[syncStudentScores] Hoàn thành toàn bộ. Tổng = 13"
}
{
    "timestamp": "2026-09-15 04:00:08",
    "level": "INFO",
    "message": "[syncUserAssignments] Hoàn thành toàn bộ. Tổng = 1"
}
{
    "timestamp": "2026-09-15 04:00:08",
    "level": "INFO",
    "message": "[mirrorToZeus] Bắt đầu mirror dữ liệu sang Zeus (isSync = 183)..."
}
{
    "timestamp": "2026-09-15 04:00:08",
    "level": "ERROR",
    "message": "[mirrorToZeus] Bắt catch ngoại lệ bảng lcms_course_types chi tiết:",
    "context": {
        "msg": "SQLSTATE[HY000] [1049] Unknown database 'ZEUS_speakup' (Connection: zeus, SQL: insert into `lcms_course_types` (`coutyp_created_at`, `coutyp_id`, `coutyp_is_sync`, `coutyp_name`, `coutyp_updated_at`) values (2026-08-12 02:19:35, 8, 183, Easy PASS, 2026-08-12 02:19:35) on duplicate key update `coutyp_name` = values(`coutyp_name`), `coutyp_is_sync` = values(`coutyp_is_sync`), `coutyp_updated_at` = values(`coutyp_updated_at`))",
        "trace": "#0 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Database\/Connection.php(779): Illuminate\\Database\\Connection->runQueryCallback()\n#1 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Database\/Connection.php(584): Illuminate\\Database\\Connection->run()\n#2 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Database\/Query\/Builder.php(3917): Illuminate\\Database\\Connection->affectingStatement()\n#3 \/var\/www\/html\/lms_hocmai\/app\/Console\/Commands\/LmsDailySyncCommand.php(599): Illuminate\\Database\\Query\\Builder->upsert()\n#4 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Database\/Concerns\/BuildsQueries.php(59): App\\Console\\Commands\\LmsDailySyncCommand->App\\Console\\Commands\\{closure}()\n#5 \/var\/www\/html\/lms_hocmai\/app\/Console\/Commands\/LmsDailySyncCommand.php(589): Illuminate\\Database\\Query\\Builder->chunk()\n#6 \/var\/www\/html\/lms_hocmai\/app\/Console\/Commands\/LmsDailySyncCommand.php(125): App\\Console\\Commands\\LmsDailySyncCommand->mirrorToZeus()\n#7 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Container\/BoundMethod.php(36): App\\Console\\Commands\\LmsDailySyncCommand->handle()\n#8 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Container\/Util.php(43): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#9 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Container\/BoundMethod.php(95): Illuminate\\Container\\Util::unwrapIfClosure()\n#10 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Container\/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()\n#11 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Container\/Container.php(696): Illuminate\\Container\\BoundMethod::call()\n#12 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Console\/Command.php(213): Illuminate\\Container\\Container->call()\n#13 \/var\/www\/html\/lms_hocmai\/vendor\/symfony\/console\/Command\/Command.php(341): Illuminate\\Console\\Command->execute()\n#14 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Console\/Command.php(182): Symfony\\Component\\Console\\Command\\Command->run()\n#15 \/var\/www\/html\/lms_hocmai\/vendor\/symfony\/console\/Application.php(1117): Illuminate\\Console\\Command->run()\n#16 \/var\/www\/html\/lms_hocmai\/vendor\/symfony\/console\/Application.php(356): Symfony\\Component\\Console\\Application->doRunCommand()\n#17 \/var\/www\/html\/lms_hocmai\/vendor\/symfony\/console\/Application.php(195): Symfony\\Component\\Console\\Application->doRun()\n#18 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Foundation\/Console\/Kernel.php(198): Symfony\\Component\\Console\\Application->run()\n#19 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Foundation\/Application.php(1235): Illuminate\\Foundation\\Console\\Kernel->handle()\n#20 \/var\/www\/html\/lms_hocmai\/artisan(13): Illuminate\\Foundation\\Application->handleCommand()\n#21 {main}"
    }
}
{
    "timestamp": "2026-09-15 04:00:08",
    "level": "ERROR",
    "message": "[mirrorToZeus] Bắt catch ngoại lệ bảng lcms_students chi tiết:",
    "context": {
        "msg": "SQLSTATE[HY000] [1049] Unknown database 'ZEUS_speakup' (Connection: zeus, SQL: insert into `lcms_students` (`stu_created_at`, `stu_dob`, `stu_email`, `stu_gender`, `stu_id`, `stu_is_sync`, `stu_name`, `stu_phone`, `stu_updated_at`, `stu_user_id`, `stu_username`) values (2024-12-26 10:19:37, 2025-03-03, kienp2901@gmail.com, Male, 1, 183, Kiên Phạm, 0394859392, 2026-09-15 01:17:49, 485, SPW71652694), (2025-12-09 04:23:01, ?, haibh@ican.vn, Male, 75, 183, Hải Bùi Hoàng, ?, 2026-09-14 08:03:36, 225, hai.buihoang.haibh), (2026-09-04 09:39:22, ?, vmn0412209@gmail.com, ?, 4302, 183, Ngọc Vũ, 84-973542666, 2026-09-12 10:55:55, ?, stu000gip), (2026-09-04 09:39:23, ?, Hangkienruby@gmail.com, ?, 4303, 183, Thư Vũ, 84-941129229, 2026-09-12 10:55:55, ?, stu000h2z), (2026-09-04 09:39:25, ?, dangkhiem711@gmail.com, ?, 4304, 183, Khiêm Đặng, 84-965146905, 2026-09-12 10:55:55, ?, stu000fbi) on duplicate key update `stu_name` = values(`stu_name`), `stu_email` = values(`stu_email`), `stu_username` = values(`stu_username`), `stu_user_id` = values(`stu_user_id`), `stu_phone` = values(`stu_phone`), `stu_dob` = values(`stu_dob`), `stu_gender` = values(`stu_gender`), `stu_is_sync` = values(`stu_is_sync`), `stu_updated_at` = values(`stu_updated_at`))",
        "trace": "#0 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Database\/Connection.php(779): Illuminate\\Database\\Connection->runQueryCallback()\n#1 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Database\/Connection.php(584): Illuminate\\Database\\Connection->run()\n#2 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Database\/Query\/Builder.php(3917): Illuminate\\Database\\Connection->affectingStatement()\n#3 \/var\/www\/html\/lms_hocmai\/app\/Console\/Commands\/LmsDailySyncCommand.php(599): Illuminate\\Database\\Query\\Builder->upsert()\n#4 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Database\/Concerns\/BuildsQueries.php(59): App\\Console\\Commands\\LmsDailySyncCommand->App\\Console\\Commands\\{closure}()\n#5 \/var\/www\/html\/lms_hocmai\/app\/Console\/Commands\/LmsDailySyncCommand.php(589): Illuminate\\Database\\Query\\Builder->chunk()\n#6 \/var\/www\/html\/lms_hocmai\/app\/Console\/Commands\/LmsDailySyncCommand.php(125): App\\Console\\Commands\\LmsDailySyncCommand->mirrorToZeus()\n#7 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Container\/BoundMethod.php(36): App\\Console\\Commands\\LmsDailySyncCommand->handle()\n#8 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Container\/Util.php(43): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#9 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Container\/BoundMethod.php(95): Illuminate\\Container\\Util::unwrapIfClosure()\n#10 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Container\/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()\n#11 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Container\/Container.php(696): Illuminate\\Container\\BoundMethod::call()\n#12 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Console\/Command.php(213): Illuminate\\Container\\Container->call()\n#13 \/var\/www\/html\/lms_hocmai\/vendor\/symfony\/console\/Command\/Command.php(341): Illuminate\\Console\\Command->execute()\n#14 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Console\/Command.php(182): Symfony\\Component\\Console\\Command\\Command->run()\n#15 \/var\/www\/html\/lms_hocmai\/vendor\/symfony\/console\/Application.php(1117): Illuminate\\Console\\Command->run()\n#16 \/var\/www\/html\/lms_hocmai\/vendor\/symfony\/console\/Application.php(356): Symfony\\Component\\Console\\Application->doRunCommand()\n#17 \/var\/www\/html\/lms_hocmai\/vendor\/symfony\/console\/Application.php(195): Symfony\\Component\\Console\\Application->doRun()\n#18 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Foundation\/Console\/Kernel.php(198): Symfony\\Component\\Console\\Application->run()\n#19 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Foundation\/Application.php(1235): Illuminate\\Foundation\\Console\\Kernel->handle()\n#20 \/var\/www\/html\/lms_hocmai\/artisan(13): Illuminate\\Foundation\\Application->handleCommand()\n#21 {main}"
    }
}
{
    "timestamp": "2026-09-15 04:00:08",
    "level": "ERROR",
    "message": "[mirrorToZeus] Bắt catch ngoại lệ bảng lcms_courses chi tiết:",
    "context": {
        "msg": "SQLSTATE[HY000] [1049] Unknown database 'ZEUS_speakup' (Connection: zeus, SQL: insert into `lcms_courses` (`cou_created_at`, `cou_id`, `cou_is_sync`, `cou_last_round`, `cou_moodle_id`, `cou_name`, `cou_parent_id`, `cou_quiz_setting_type`, `cou_section_type`, `cou_total_round`, `cou_type`, `cou_type_id`, `cou_updated_at`, `cou_visible`) values (2026-09-10 03:45:28, 5498, 183, ?, 5811, Mini Test nhập điểm 4 kỹ năng, 5497, 19, ?, 0, quiz, ?, 2026-09-11 03:40:34, 1) on duplicate key update `cou_moodle_id` = values(`cou_moodle_id`), `cou_name` = values(`cou_name`), `cou_type` = values(`cou_type`), `cou_parent_id` = values(`cou_parent_id`), `cou_total_round` = values(`cou_total_round`), `cou_last_round` = values(`cou_last_round`), `cou_section_type` = values(`cou_section_type`), `cou_quiz_setting_type` = values(`cou_quiz_setting_type`), `cou_type_id` = values(`cou_type_id`), `cou_visible` = values(`cou_visible`), `cou_is_sync` = values(`cou_is_sync`), `cou_updated_at` = values(`cou_updated_at`))",
        "trace": "#0 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Database\/Connection.php(779): Illuminate\\Database\\Connection->runQueryCallback()\n#1 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Database\/Connection.php(584): Illuminate\\Database\\Connection->run()\n#2 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Database\/Query\/Builder.php(3917): Illuminate\\Database\\Connection->affectingStatement()\n#3 \/var\/www\/html\/lms_hocmai\/app\/Console\/Commands\/LmsDailySyncCommand.php(599): Illuminate\\Database\\Query\\Builder->upsert()\n#4 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Database\/Concerns\/BuildsQueries.php(59): App\\Console\\Commands\\LmsDailySyncCommand->App\\Console\\Commands\\{closure}()\n#5 \/var\/www\/html\/lms_hocmai\/app\/Console\/Commands\/LmsDailySyncCommand.php(589): Illuminate\\Database\\Query\\Builder->chunk()\n#6 \/var\/www\/html\/lms_hocmai\/app\/Console\/Commands\/LmsDailySyncCommand.php(125): App\\Console\\Commands\\LmsDailySyncCommand->mirrorToZeus()\n#7 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Container\/BoundMethod.php(36): App\\Console\\Commands\\LmsDailySyncCommand->handle()\n#8 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Container\/Util.php(43): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#9 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Container\/BoundMethod.php(95): Illuminate\\Container\\Util::unwrapIfClosure()\n#10 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Container\/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()\n#11 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Container\/Container.php(696): Illuminate\\Container\\BoundMethod::call()\n#12 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Console\/Command.php(213): Illuminate\\Container\\Container->call()\n#13 \/var\/www\/html\/lms_hocmai\/vendor\/symfony\/console\/Command\/Command.php(341): Illuminate\\Console\\Command->execute()\n#14 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Console\/Command.php(182): Symfony\\Component\\Console\\Command\\Command->run()\n#15 \/var\/www\/html\/lms_hocmai\/vendor\/symfony\/console\/Application.php(1117): Illuminate\\Console\\Command->run()\n#16 \/var\/www\/html\/lms_hocmai\/vendor\/symfony\/console\/Application.php(356): Symfony\\Component\\Console\\Application->doRunCommand()\n#17 \/var\/www\/html\/lms_hocmai\/vendor\/symfony\/console\/Application.php(195): Symfony\\Component\\Console\\Application->doRun()\n#18 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Foundation\/Console\/Kernel.php(198): Symfony\\Component\\Console\\Application->run()\n#19 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Foundation\/Application.php(1235): Illuminate\\Foundation\\Console\\Kernel->handle()\n#20 \/var\/www\/html\/lms_hocmai\/artisan(13): Illuminate\\Foundation\\Application->handleCommand()\n#21 {main}"
    }
}
{
    "timestamp": "2026-09-15 04:00:08",
    "level": "ERROR",
    "message": "[mirrorToZeus] Bắt catch ngoại lệ bảng lcms_course_student chi tiết:",
    "context": {
        "msg": "SQLSTATE[HY000] [1049] Unknown database 'ZEUS_speakup' (Connection: zeus, SQL: insert into `lcms_course_student` (`coustu_course_end`, `coustu_course_id`, `coustu_created_at`, `coustu_id`, `coustu_is_sync`, `coustu_student_id`, `coustu_updated_at`, `coustu_user_id`) values (?, 5476, 2026-09-11 03:40:24, 5796, 183, 1, 2026-09-11 03:40:24, 485) on duplicate key update `coustu_student_id` = values(`coustu_student_id`), `coustu_user_id` = values(`coustu_user_id`), `coustu_course_id` = values(`coustu_course_id`), `coustu_course_end` = values(`coustu_course_end`), `coustu_is_sync` = values(`coustu_is_sync`), `coustu_updated_at` = values(`coustu_updated_at`))",
        "trace": "#0 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Database\/Connection.php(779): Illuminate\\Database\\Connection->runQueryCallback()\n#1 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Database\/Connection.php(584): Illuminate\\Database\\Connection->run()\n#2 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Database\/Query\/Builder.php(3917): Illuminate\\Database\\Connection->affectingStatement()\n#3 \/var\/www\/html\/lms_hocmai\/app\/Console\/Commands\/LmsDailySyncCommand.php(599): Illuminate\\Database\\Query\\Builder->upsert()\n#4 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Database\/Concerns\/BuildsQueries.php(59): App\\Console\\Commands\\LmsDailySyncCommand->App\\Console\\Commands\\{closure}()\n#5 \/var\/www\/html\/lms_hocmai\/app\/Console\/Commands\/LmsDailySyncCommand.php(589): Illuminate\\Database\\Query\\Builder->chunk()\n#6 \/var\/www\/html\/lms_hocmai\/app\/Console\/Commands\/LmsDailySyncCommand.php(125): App\\Console\\Commands\\LmsDailySyncCommand->mirrorToZeus()\n#7 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Container\/BoundMethod.php(36): App\\Console\\Commands\\LmsDailySyncCommand->handle()\n#8 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Container\/Util.php(43): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#9 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Container\/BoundMethod.php(95): Illuminate\\Container\\Util::unwrapIfClosure()\n#10 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Container\/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()\n#11 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Container\/Container.php(696): Illuminate\\Container\\BoundMethod::call()\n#12 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Console\/Command.php(213): Illuminate\\Container\\Container->call()\n#13 \/var\/www\/html\/lms_hocmai\/vendor\/symfony\/console\/Command\/Command.php(341): Illuminate\\Console\\Command->execute()\n#14 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Console\/Command.php(182): Symfony\\Component\\Console\\Command\\Command->run()\n#15 \/var\/www\/html\/lms_hocmai\/vendor\/symfony\/console\/Application.php(1117): Illuminate\\Console\\Command->run()\n#16 \/var\/www\/html\/lms_hocmai\/vendor\/symfony\/console\/Application.php(356): Symfony\\Component\\Console\\Application->doRunCommand()\n#17 \/var\/www\/html\/lms_hocmai\/vendor\/symfony\/console\/Application.php(195): Symfony\\Component\\Console\\Application->doRun()\n#18 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Foundation\/Console\/Kernel.php(198): Symfony\\Component\\Console\\Application->run()\n#19 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Foundation\/Application.php(1235): Illuminate\\Foundation\\Console\\Kernel->handle()\n#20 \/var\/www\/html\/lms_hocmai\/artisan(13): Illuminate\\Foundation\\Application->handleCommand()\n#21 {main}"
    }
}
{
    "timestamp": "2026-09-15 04:00:08",
    "level": "ERROR",
    "message": "[mirrorToZeus] Bắt catch ngoại lệ bảng lcms_student_scores chi tiết:",
    "context": {
        "msg": "SQLSTATE[HY000] [1049] Unknown database 'ZEUS_speakup' (Connection: zeus, SQL: insert into `lcms_student_scores` (`stusco_course_id`, `stusco_created_at`, `stusco_history_contest_id`, `stusco_id`, `stusco_is_sync`, `stusco_mock_contest_id`, `stusco_overall_score`, `stusco_score_status`, `stusco_student_id`, `stusco_updated_at`, `stusco_user_id`) values (569, 2026-09-05 07:00:14, 6a9bbdfeae5cd04a23b08717, 5900, 183, 712, 0, 0, 1, 2026-09-15 01:25:20, 485), (569, 2026-09-05 09:05:36, 6a9bdb60ae5cd04a23b0874f, 5904, 183, 712, 0.2, 0, 1, 2026-09-15 01:25:20, 485), (569, 2026-09-05 09:08:13, 6a9bdbfdae5cd04a23b08796, 5905, 183, 712, 0, 0, 1, 2026-09-15 01:25:20, 485), (569, 2026-09-05 09:09:59, 6a9bdc67ae5cd04a23b087d1, 5906, 183, 712, 0, 0, 1, 2026-09-15 01:25:20, 485), (569, 2026-09-05 09:11:03, 6a9bdca7ae5cd04a23b0880c, 5907, 183, 712, 0.2, 0, 1, 2026-09-15 01:25:20, 485), (569, 2026-09-05 09:12:39, 6a9bdd07ae5cd04a23b0884e, 5908, 183, 712, 1.3, 0, 1, 2026-09-15 01:25:20, 485), (569, 2026-09-05 09:13:04, 6a9bdd20ae5cd04a23b0888c, 5909, 183, 712, 1.3, 0, 1, 2026-09-15 01:25:20, 485), (569, 2026-09-05 09:16:20, 6a9bdde4ae5cd04a23b088c2, 5910, 183, 712, 0, 0, 1, 2026-09-15 01:25:20, 485), (569, 2026-09-05 09:19:10, 6a9bde8eae5cd04a23b088f2, 5911, 183, 712, -1, 0, 1, 2026-09-15 01:25:20, 485), (5498, 2026-09-11 04:46:13, ?, 5915, 183, ?, 3.5, 0, 1947, 2026-09-11 04:46:13, 450), (569, 2026-09-15 01:22:47, 6aa89de7ae5cd04a23b0896a, 5916, 183, 712, 0.2, 0, 1, 2026-09-15 01:25:20, 485), (569, 2026-09-15 01:25:22, 6aa89e82ae5cd04a23b089b5, 5917, 183, 712, -1, 0, 1, 2026-09-15 01:31:06, 485), (569, 2026-09-15 01:34:04, 6aa8a08cae5cd04a23b08a14, 5918, 183, 712, -1, 0, 1, 2026-09-15 01:45:00, 485) on duplicate key update `stusco_student_id` = values(`stusco_student_id`), `stusco_user_id` = values(`stusco_user_id`), `stusco_course_id` = values(`stusco_course_id`), `stusco_mock_contest_id` = values(`stusco_mock_contest_id`), `stusco_score_status` = values(`stusco_score_status`), `stusco_history_contest_id` = values(`stusco_history_contest_id`), `stusco_overall_score` = values(`stusco_overall_score`), `stusco_is_sync` = values(`stusco_is_sync`), `stusco_updated_at` = values(`stusco_updated_at`))",
        "trace": "#0 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Database\/Connection.php(779): Illuminate\\Database\\Connection->runQueryCallback()\n#1 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Database\/Connection.php(584): Illuminate\\Database\\Connection->run()\n#2 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Database\/Query\/Builder.php(3917): Illuminate\\Database\\Connection->affectingStatement()\n#3 \/var\/www\/html\/lms_hocmai\/app\/Console\/Commands\/LmsDailySyncCommand.php(599): Illuminate\\Database\\Query\\Builder->upsert()\n#4 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Database\/Concerns\/BuildsQueries.php(59): App\\Console\\Commands\\LmsDailySyncCommand->App\\Console\\Commands\\{closure}()\n#5 \/var\/www\/html\/lms_hocmai\/app\/Console\/Commands\/LmsDailySyncCommand.php(589): Illuminate\\Database\\Query\\Builder->chunk()\n#6 \/var\/www\/html\/lms_hocmai\/app\/Console\/Commands\/LmsDailySyncCommand.php(125): App\\Console\\Commands\\LmsDailySyncCommand->mirrorToZeus()\n#7 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Container\/BoundMethod.php(36): App\\Console\\Commands\\LmsDailySyncCommand->handle()\n#8 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Container\/Util.php(43): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#9 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Container\/BoundMethod.php(95): Illuminate\\Container\\Util::unwrapIfClosure()\n#10 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Container\/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()\n#11 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Container\/Container.php(696): Illuminate\\Container\\BoundMethod::call()\n#12 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Console\/Command.php(213): Illuminate\\Container\\Container->call()\n#13 \/var\/www\/html\/lms_hocmai\/vendor\/symfony\/console\/Command\/Command.php(341): Illuminate\\Console\\Command->execute()\n#14 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Console\/Command.php(182): Symfony\\Component\\Console\\Command\\Command->run()\n#15 \/var\/www\/html\/lms_hocmai\/vendor\/symfony\/console\/Application.php(1117): Illuminate\\Console\\Command->run()\n#16 \/var\/www\/html\/lms_hocmai\/vendor\/symfony\/console\/Application.php(356): Symfony\\Component\\Console\\Application->doRunCommand()\n#17 \/var\/www\/html\/lms_hocmai\/vendor\/symfony\/console\/Application.php(195): Symfony\\Component\\Console\\Application->doRun()\n#18 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Foundation\/Console\/Kernel.php(198): Symfony\\Component\\Console\\Application->run()\n#19 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Foundation\/Application.php(1235): Illuminate\\Foundation\\Console\\Kernel->handle()\n#20 \/var\/www\/html\/lms_hocmai\/artisan(13): Illuminate\\Foundation\\Application->handleCommand()\n#21 {main}"
    }
}
{
    "timestamp": "2026-09-15 04:00:08",
    "level": "ERROR",
    "message": "[mirrorToZeus] Bắt catch ngoại lệ bảng lcms_user_assignments chi tiết:",
    "context": {
        "msg": "SQLSTATE[HY000] [1049] Unknown database 'ZEUS_speakup' (Connection: zeus, SQL: insert into `lcms_user_assignments` (`usrasi_completion_state`, `usrasi_completion_time`, `usrasi_course_id`, `usrasi_created_at`, `usrasi_id`, `usrasi_is_cron`, `usrasi_is_sync`, `usrasi_payload_data`, `usrasi_response_data`, `usrasi_section_id`, `usrasi_student_id`, `usrasi_updated_at`, `usrasi_zeus_id`) values (1, 2026-09-10 11:39:06, 5036, 2026-08-03 11:00:03, 211, 1, 183, {\"auto_assigned\": true, \"source_section_id\": 1851}, {\"course\": {\"id\": 226, \"name\": \"[Center] Easy IELTS 25 - Foundation\"}, \"section\": {\"id\": 1840, \"name\": \"Lesson 3 - Unit 1 - Writing\"}, \"auto_assigned_from\": 1851}, 5039, 4152, 2026-09-13 02:00:21, 557) on duplicate key update `usrasi_course_id` = values(`usrasi_course_id`), `usrasi_section_id` = values(`usrasi_section_id`), `usrasi_zeus_id` = values(`usrasi_zeus_id`), `usrasi_student_id` = values(`usrasi_student_id`), `usrasi_completion_time` = values(`usrasi_completion_time`), `usrasi_completion_state` = values(`usrasi_completion_state`), `usrasi_payload_data` = values(`usrasi_payload_data`), `usrasi_response_data` = values(`usrasi_response_data`), `usrasi_is_cron` = values(`usrasi_is_cron`), `usrasi_is_sync` = values(`usrasi_is_sync`), `usrasi_updated_at` = values(`usrasi_updated_at`))",
        "trace": "#0 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Database\/Connection.php(779): Illuminate\\Database\\Connection->runQueryCallback()\n#1 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Database\/Connection.php(584): Illuminate\\Database\\Connection->run()\n#2 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Database\/Query\/Builder.php(3917): Illuminate\\Database\\Connection->affectingStatement()\n#3 \/var\/www\/html\/lms_hocmai\/app\/Console\/Commands\/LmsDailySyncCommand.php(599): Illuminate\\Database\\Query\\Builder->upsert()\n#4 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Database\/Concerns\/BuildsQueries.php(59): App\\Console\\Commands\\LmsDailySyncCommand->App\\Console\\Commands\\{closure}()\n#5 \/var\/www\/html\/lms_hocmai\/app\/Console\/Commands\/LmsDailySyncCommand.php(589): Illuminate\\Database\\Query\\Builder->chunk()\n#6 \/var\/www\/html\/lms_hocmai\/app\/Console\/Commands\/LmsDailySyncCommand.php(125): App\\Console\\Commands\\LmsDailySyncCommand->mirrorToZeus()\n#7 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Container\/BoundMethod.php(36): App\\Console\\Commands\\LmsDailySyncCommand->handle()\n#8 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Container\/Util.php(43): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#9 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Container\/BoundMethod.php(95): Illuminate\\Container\\Util::unwrapIfClosure()\n#10 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Container\/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()\n#11 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Container\/Container.php(696): Illuminate\\Container\\BoundMethod::call()\n#12 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Console\/Command.php(213): Illuminate\\Container\\Container->call()\n#13 \/var\/www\/html\/lms_hocmai\/vendor\/symfony\/console\/Command\/Command.php(341): Illuminate\\Console\\Command->execute()\n#14 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Console\/Command.php(182): Symfony\\Component\\Console\\Command\\Command->run()\n#15 \/var\/www\/html\/lms_hocmai\/vendor\/symfony\/console\/Application.php(1117): Illuminate\\Console\\Command->run()\n#16 \/var\/www\/html\/lms_hocmai\/vendor\/symfony\/console\/Application.php(356): Symfony\\Component\\Console\\Application->doRunCommand()\n#17 \/var\/www\/html\/lms_hocmai\/vendor\/symfony\/console\/Application.php(195): Symfony\\Component\\Console\\Application->doRun()\n#18 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Foundation\/Console\/Kernel.php(198): Symfony\\Component\\Console\\Application->run()\n#19 \/var\/www\/html\/lms_hocmai\/vendor\/laravel\/framework\/src\/Illuminate\/Foundation\/Application.php(1235): Illuminate\\Foundation\\Console\\Kernel->handle()\n#20 \/var\/www\/html\/lms_hocmai\/artisan(13): Illuminate\\Foundation\\Application->handleCommand()\n#21 {main}"
    }
}
{
    "timestamp": "2026-09-15 04:00:08",
    "level": "INFO",
    "message": "[mirrorToZeus] Xong tất cả. Tổng = 0"
}
{
    "timestamp": "2026-09-15 04:00:08",
    "level": "INFO",
    "message": "[LmsDailySync] Hoàn thành",
    "context": {
        "tenantCode": "ICC",
        "isSync": 183,
        "elapsed_s": -2.985409,
        "syncCourseTypes": {
            "synced": 1
        },
        "syncCourses": {
            "synced": 1
        },
        "syncStudents": {
            "synced": 5
        },
        "syncCourseStudents": {
            "synced": 1
        },
        "syncStudentScores": {
            "synced": 13
        },
        "syncUserAssignments": {
            "synced": 1
        },
        "mirrorToZeus": {
            "synced": 0,
            "error": "Mirror lcms_course_types lỗi: SQLSTATE[HY000] [1049] Unknown database 'ZEUS_speakup' (Connection: zeus, SQL: insert into `lcms_course_types` (`coutyp_created_at`, `coutyp_id`, `coutyp_is_sync`, `coutyp_name`, `coutyp_updated_at`) values (2026-08-12 02:19:35, 8, 183, Easy PASS, 2026-08-12 02:19:35) on duplicate key update `coutyp_name` = values(`coutyp_name`), `coutyp_is_sync` = values(`coutyp_is_sync`), `coutyp_updated_at` = values(`coutyp_updated_at`)) | Mirror lcms_students lỗi: SQLSTATE[HY000] [1049] Unknown database 'ZEUS_speakup' (Connection: zeus, SQL: insert into `lcms_students` (`stu_created_at`, `stu_dob`, `stu_email`, `stu_gender`, `stu_id`, `stu_is_sync`, `stu_name`, `stu_phone`, `stu_updated_at`, `stu_user_id`, `stu_username`) values (2024-12-26 10:19:37, 2025-03-03, kienp2901@gmail.com, Male, 1, 183, Kiên Phạm, 0394859392, 2026-09-15 01:17:49, 485, SPW71652694), (2025-12-09 04:23:01, ?, haibh@ican.vn, Male, 75, 183, Hải Bùi Hoàng, ?, 2026-09-14 08:03:36, 225, hai.buihoang.haibh), (2026-09-04 09:39:22, ?, vmn0412209@gmail.com, ?, 4302, 183, Ngọc Vũ, 84-973542666, 2026-09-12 10:55:55, ?, stu000gip), (2026-09-04 09:39:23, ?, Hangkienruby@gmail.com, ?, 4303, 183, Thư Vũ, 84-941129229, 2026-09-12 10:55:55, ?, stu000h2z), (2026-09-04 09:39:25, ?, dangkhiem711@gmail.com, ?, 4304, 183, Khiêm Đặng, 84-965146905, 2026-09-12 10:55:55, ?, stu000fbi) on duplicate key update `stu_name` = values(`stu_name`), `stu_email` = values(`stu_email`), `stu_username` = values(`stu_username`), `stu_user_id` = values(`stu_user_id`), `stu_phone` = values(`stu_phone`), `stu_dob` = values(`stu_dob`), `stu_gender` = values(`stu_gender`), `stu_is_sync` = values(`stu_is_sync`), `stu_updated_at` = values(`stu_updated_at`)) | Mirror lcms_courses lỗi: SQLSTATE[HY000] [1049] Unknown database 'ZEUS_speakup' (Connection: zeus, SQL: insert into `lcms_courses` (`cou_created_at`, `cou_id`, `cou_is_sync`, `cou_last_round`, `cou_moodle_id`, `cou_name`, `cou_parent_id`, `cou_quiz_setting_type`, `cou_section_type`, `cou_total_round`, `cou_type`, `cou_type_id`, `cou_updated_at`, `cou_visible`) values (2026-09-10 03:45:28, 5498, 183, ?, 5811, Mini Test nhập điểm 4 kỹ năng, 5497, 19, ?, 0, quiz, ?, 2026-09-11 03:40:34, 1) on duplicate key update `cou_moodle_id` = values(`cou_moodle_id`), `cou_name` = values(`cou_name`), `cou_type` = values(`cou_type`), `cou_parent_id` = values(`cou_parent_id`), `cou_total_round` = values(`cou_total_round`), `cou_last_round` = values(`cou_last_round`), `cou_section_type` = values(`cou_section_type`), `cou_quiz_setting_type` = values(`cou_quiz_setting_type`), `cou_type_id` = values(`cou_type_id`), `cou_visible` = values(`cou_visible`), `cou_is_sync` = values(`cou_is_sync`), `cou_updated_at` = values(`cou_updated_at`)) | Mirror lcms_course_student lỗi: SQLSTATE[HY000] [1049] Unknown database 'ZEUS_speakup' (Connection: zeus, SQL: insert into `lcms_course_student` (`coustu_course_end`, `coustu_course_id`, `coustu_created_at`, `coustu_id`, `coustu_is_sync`, `coustu_student_id`, `coustu_updated_at`, `coustu_user_id`) values (?, 5476, 2026-09-11 03:40:24, 5796, 183, 1, 2026-09-11 03:40:24, 485) on duplicate key update `coustu_student_id` = values(`coustu_student_id`), `coustu_user_id` = values(`coustu_user_id`), `coustu_course_id` = values(`coustu_course_id`), `coustu_course_end` = values(`coustu_course_end`), `coustu_is_sync` = values(`coustu_is_sync`), `coustu_updated_at` = values(`coustu_updated_at`)) | Mirror lcms_student_scores lỗi: SQLSTATE[HY000] [1049] Unknown database 'ZEUS_speakup' (Connection: zeus, SQL: insert into `lcms_student_scores` (`stusco_course_id`, `stusco_created_at`, `stusco_history_contest_id`, `stusco_id`, `stusco_is_sync`, `stusco_mock_contest_id`, `stusco_overall_score`, `stusco_score_status`, `stusco_student_id`, `stusco_updated_at`, `stusco_user_id`) values (569, 2026-09-05 07:00:14, 6a9bbdfeae5cd04a23b08717, 5900, 183, 712, 0, 0, 1, 2026-09-15 01:25:20, 485), (569, 2026-09-05 09:05:36, 6a9bdb60ae5cd04a23b0874f, 5904, 183, 712, 0.2, 0, 1, 2026-09-15 01:25:20, 485), (569, 2026-09-05 09:08:13, 6a9bdbfdae5cd04a23b08796, 5905, 183, 712, 0, 0, 1, 2026-09-15 01:25:20, 485), (569, 2026-09-05 09:09:59, 6a9bdc67ae5cd04a23b087d1, 5906, 183, 712, 0, 0, 1, 2026-09-15 01:25:20, 485), (569, 2026-09-05 09:11:03, 6a9bdca7ae5cd04a23b0880c, 5907, 183, 712, 0.2, 0, 1, 2026-09-15 01:25:20, 485), (569, 2026-09-05 09:12:39, 6a9bdd07ae5cd04a23b0884e, 5908, 183, 712, 1.3, 0, 1, 2026-09-15 01:25:20, 485), (569, 2026-09-05 09:13:04, 6a9bdd20ae5cd04a23b0888c, 5909, 183, 712, 1.3, 0, 1, 2026-09-15 01:25:20, 485), (569, 2026-09-05 09:16:20, 6a9bdde4ae5cd04a23b088c2, 5910, 183, 712, 0, 0, 1, 2026-09-15 01:25:20, 485), (569, 2026-09-05 09:19:10, 6a9bde8eae5cd04a23b088f2, 5911, 183, 712, -1, 0, 1, 2026-09-15 01:25:20, 485), (5498, 2026-09-11 04:46:13, ?, 5915, 183, ?, 3.5, 0, 1947, 2026-09-11 04:46:13, 450), (569, 2026-09-15 01:22:47, 6aa89de7ae5cd04a23b0896a, 5916, 183, 712, 0.2, 0, 1, 2026-09-15 01:25:20, 485), (569, 2026-09-15 01:25:22, 6aa89e82ae5cd04a23b089b5, 5917, 183, 712, -1, 0, 1, 2026-09-15 01:31:06, 485), (569, 2026-09-15 01:34:04, 6aa8a08cae5cd04a23b08a14, 5918, 183, 712, -1, 0, 1, 2026-09-15 01:45:00, 485) on duplicate key update `stusco_student_id` = values(`stusco_student_id`), `stusco_user_id` = values(`stusco_user_id`), `stusco_course_id` = values(`stusco_course_id`), `stusco_mock_contest_id` = values(`stusco_mock_contest_id`), `stusco_score_status` = values(`stusco_score_status`), `stusco_history_contest_id` = values(`stusco_history_contest_id`), `stusco_overall_score` = values(`stusco_overall_score`), `stusco_is_sync` = values(`stusco_is_sync`), `stusco_updated_at` = values(`stusco_updated_at`)) | Mirror lcms_user_assignments lỗi: SQLSTATE[HY000] [1049] Unknown database 'ZEUS_speakup' (Connection: zeus, SQL: insert into `lcms_user_assignments` (`usrasi_completion_state`, `usrasi_completion_time`, `usrasi_course_id`, `usrasi_created_at`, `usrasi_id`, `usrasi_is_cron`, `usrasi_is_sync`, `usrasi_payload_data`, `usrasi_response_data`, `usrasi_section_id`, `usrasi_student_id`, `usrasi_updated_at`, `usrasi_zeus_id`) values (1, 2026-09-10 11:39:06, 5036, 2026-08-03 11:00:03, 211, 1, 183, {\"auto_assigned\": true, \"source_section_id\": 1851}, {\"course\": {\"id\": 226, \"name\": \"[Center] Easy IELTS 25 - Foundation\"}, \"section\": {\"id\": 1840, \"name\": \"Lesson 3 - Unit 1 - Writing\"}, \"auto_assigned_from\": 1851}, 5039, 4152, 2026-09-13 02:00:21, 557) on duplicate key update `usrasi_course_id` = values(`usrasi_course_id`), `usrasi_section_id` = values(`usrasi_section_id`), `usrasi_zeus_id` = values(`usrasi_zeus_id`), `usrasi_student_id` = values(`usrasi_student_id`), `usrasi_completion_time` = values(`usrasi_completion_time`), `usrasi_completion_state` = values(`usrasi_completion_state`), `usrasi_payload_data` = values(`usrasi_payload_data`), `usrasi_response_data` = values(`usrasi_response_data`), `usrasi_is_cron` = values(`usrasi_is_cron`), `usrasi_is_sync` = values(`usrasi_is_sync`), `usrasi_updated_at` = values(`usrasi_updated_at`))"
        }
    }
}