Ignore MySQL error 1062 (dublicate entries in unique column) as it breaks replication currently

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" }