{
    "timestamp": "2026-09-28 04:00:04",
    "level": "INFO",
    "message": "[syncCourseTypes] Hoàn thành toàn bộ. Tổng = 1"
}
{
    "timestamp": "2026-09-28 04:00:04",
    "level": "INFO",
    "message": "[syncCourses] Hoàn thành toàn bộ. Tổng = 3"
}
{
    "timestamp": "2026-09-28 04:00:04",
    "level": "INFO",
    "message": "[syncStudents] Hoàn thành toàn bộ. Tổng = 4"
}
{
    "timestamp": "2026-09-28 04:00:04",
    "level": "INFO",
    "message": "[syncCourseStudents] Hoàn thành toàn bộ. Tổng = 2"
}
{
    "timestamp": "2026-09-28 04:00:04",
    "level": "INFO",
    "message": "[syncStudentScores] Hoàn thành toàn bộ. Tổng = 1"
}
{
    "timestamp": "2026-09-28 04:00:04",
    "level": "INFO",
    "message": "[syncUserAssignments] Hoàn thành toàn bộ. Tổng = 1"
}
{
    "timestamp": "2026-09-28 04:00:04",
    "level": "INFO",
    "message": "[mirrorToZeus] Bắt đầu mirror dữ liệu sang Zeus (isSync = 196)..."
}
{
    "timestamp": "2026-09-28 04:00:04",
    "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, 196, 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-28 04:00:04",
    "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 (2026-07-02 09:05:31, ?, hs7@hocmai.vn, Male, 4026, 196, HỌC SINH BẢY, , 2026-09-27 13:57:19, 500, SPW45689802), (2026-07-16 09:27:50, ?, than47771@gmail.com, Female, 4149, 196, Văn C Nguyễn, ?, 2026-09-27 14:01:51, 559, SPW99527860), (2026-09-15 23:08:32, ?, giangnam1502@gmail.com, ?, 4372, 196, Khanh Lương, 84-976017905, 2026-09-26 16:22:28, ?, stu000djy), (2026-09-15 23:08:33, ?, thudao.02042017t@gmail.com, ?, 4373, 196, Nghị Lưu, 84-386659714, 2026-09-26 16:22:28, ?, stu000syw) 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-28 04:00:04",
    "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-25 04:40:49, 5527, 196, ?, 5832, CMS Video 5, 5318, ?, ?, ?, cmsvideo, ?, 2026-09-25 04:40:50, 1), (2026-09-25 04:40:50, 5528, 196, ?, 5833, File 15, 5318, ?, ?, ?, resource, ?, 2026-09-25 04:40:50, 1), (2026-09-25 04:40:50, 5529, 196, ?, 5834, Url 6, 5318, ?, ?, ?, url, ?, 2026-09-25 04:40:50, 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-28 04:00:04",
    "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 (2029-07-28 14:46:54, 5063, 2026-07-28 14:46:54, 5636, 196, 4202, 2026-09-18 07:55:40, 568), (2027-09-27 14:01:51, 887, 2026-09-27 14:01:51, 8026, 196, 4149, 2026-09-27 14:01:51, 559) 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-28 04:00:04",
    "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 (4877, 2026-09-25 08:33:35, 6ab631dfc15d29ff7a33e679, 6054, 196, 807, -1, 0, 22, 2026-09-26 02:30:04, 248) 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-28 04:00:04",
    "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-24 17:00:06, 153, 2026-09-24 10:00:15, 259, 1, 196, {\"batch\": true, \"course_id\": 100, \"batch_uuid\": \"4ea4b8b1-43d8-4736-b74f-e9993a8ec940\", \"section_id\": 200, \"start_date\": null, \"zeus_user_id\": \"438\", \"x_tenant_code\": \"ICC\", \"completion_time\": \"2026-09-24 17:00:06\", \"course_id_resolved_from_section\": true}, {\"course\": {\"id\": 100, \"name\": \"IELTS Classroom - Introduction (2B)\"}, \"section\": {\"id\": 200, \"name\": \"Unit 1 - Lesson 1: Daily life\"}}, 154, 3774, 2026-09-24 10:00:36, 438) 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-28 04:00:04",
    "level": "INFO",
    "message": "[mirrorToZeus] Xong tất cả. Tổng = 0"
}
{
    "timestamp": "2026-09-28 04:00:04",
    "level": "INFO",
    "message": "[LmsDailySync] Hoàn thành",
    "context": {
        "tenantCode": "ICC",
        "isSync": 196,
        "elapsed_s": -0.760955,
        "syncCourseTypes": {
            "synced": 1
        },
        "syncCourses": {
            "synced": 3
        },
        "syncStudents": {
            "synced": 4
        },
        "syncCourseStudents": {
            "synced": 2
        },
        "syncStudentScores": {
            "synced": 1
        },
        "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, 196, 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 (2026-07-02 09:05:31, ?, hs7@hocmai.vn, Male, 4026, 196, HỌC SINH BẢY, , 2026-09-27 13:57:19, 500, SPW45689802), (2026-07-16 09:27:50, ?, than47771@gmail.com, Female, 4149, 196, Văn C Nguyễn, ?, 2026-09-27 14:01:51, 559, SPW99527860), (2026-09-15 23:08:32, ?, giangnam1502@gmail.com, ?, 4372, 196, Khanh Lương, 84-976017905, 2026-09-26 16:22:28, ?, stu000djy), (2026-09-15 23:08:33, ?, thudao.02042017t@gmail.com, ?, 4373, 196, Nghị Lưu, 84-386659714, 2026-09-26 16:22:28, ?, stu000syw) 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-25 04:40:49, 5527, 196, ?, 5832, CMS Video 5, 5318, ?, ?, ?, cmsvideo, ?, 2026-09-25 04:40:50, 1), (2026-09-25 04:40:50, 5528, 196, ?, 5833, File 15, 5318, ?, ?, ?, resource, ?, 2026-09-25 04:40:50, 1), (2026-09-25 04:40:50, 5529, 196, ?, 5834, Url 6, 5318, ?, ?, ?, url, ?, 2026-09-25 04:40:50, 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 (2029-07-28 14:46:54, 5063, 2026-07-28 14:46:54, 5636, 196, 4202, 2026-09-18 07:55:40, 568), (2027-09-27 14:01:51, 887, 2026-09-27 14:01:51, 8026, 196, 4149, 2026-09-27 14:01:51, 559) 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 (4877, 2026-09-25 08:33:35, 6ab631dfc15d29ff7a33e679, 6054, 196, 807, -1, 0, 22, 2026-09-26 02:30:04, 248) 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-24 17:00:06, 153, 2026-09-24 10:00:15, 259, 1, 196, {\"batch\": true, \"course_id\": 100, \"batch_uuid\": \"4ea4b8b1-43d8-4736-b74f-e9993a8ec940\", \"section_id\": 200, \"start_date\": null, \"zeus_user_id\": \"438\", \"x_tenant_code\": \"ICC\", \"completion_time\": \"2026-09-24 17:00:06\", \"course_id_resolved_from_section\": true}, {\"course\": {\"id\": 100, \"name\": \"IELTS Classroom - Introduction (2B)\"}, \"section\": {\"id\": 200, \"name\": \"Unit 1 - Lesson 1: Daily life\"}}, 154, 3774, 2026-09-24 10:00:36, 438) 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`))"
        }
    }
}
