From 488c875393fa01fb3d9ff37750fcd851ee3ef94d Mon Sep 17 00:00:00 2001 From: "Suren A. Chilingaryan" Date: Mon, 29 Jul 2024 22:31:21 +0200 Subject: Ignore MySQL error 1062 (dublicate entries in unique column) as it breaks replication currently --- log.txt | 12 +++++++++++- setup/projects/adei/vars/mysql.yml | 2 +- 2 files changed, 12 insertions(+), 2 deletions(-) diff --git a/log.txt b/log.txt index 209b924..6b5de65 100644 --- a/log.txt +++ b/log.txt @@ -1 +1,11 @@ - - ipekatrin1: Replaced disak in section 9. LSI software reports all is OK, but hardware led indicates a error (red). Probably indicator is broken. +Hardware +-------- + - ipekatrin1: Replaced disk in section 9. LSI software reports all is OK, but hardware led indicates a error (red). Probably indicator is broken. + +Software +-------- + 2023.06.13 + - Instructed MySQL slave to ignore 1062 errors as well (I have skipped a few manually, but errors appeared non-stop) + - Also ADEI-KATRIN pod got stuck. Pod was running, but apache was stuck and not replying. This caused POD state to report 'not-ready' but for some reason it was still 'live' and pod was not restarted. + + \ No newline at end of file diff --git a/setup/projects/adei/vars/mysql.yml b/setup/projects/adei/vars/mysql.yml index bb0b7f2..9b17fd7 100644 --- a/setup/projects/adei/vars/mysql.yml +++ b/setup/projects/adei/vars/mysql.yml @@ -94,7 +94,7 @@ mysql: - { name: "MYSQL_INNODB_FLUSH_LOG_TYPE", value: "2" } - { name: "MYSQL_INNODB_FLUSH_LOG_TIMEOUT", value: "300" } - { name: "MYSQL_SLAVE_WORKERS", value: "16" } - - { name: "MYSQL_SLAVE_SKIP_ERRORS", value: "1007,1008,1050,1051,1054,1060,1061,1068,1094,1146,1304,1359,1476,1537" } + - { name: "MYSQL_SLAVE_SKIP_ERRORS", value: "1007,1008,1050,1051,1054,1060,1061,1062,1068,1094,1146,1304,1359,1476,1537" } - { name: "MYSQL_BINLOG_FORMAT", value: "ROW" } mappings: - { name: "adei_slave", mount: "/var/lib/mysql/data" } -- cgit v1.2.3