Hi All,

I have a very strange problem which I am not able to debug any further, so I kindly ask here for any advise to find the root cause of this issue.

I run a master-slave replication setup, both servers run on Debian Bookworm with the packages from the distro (10.11.4-MariaDB-1~deb12u1-log). There are two tables in two databases with the same setup (same shop software) and both suffer from recurring index corruption on the slave side. While the master server works without any issues, the slave machine stops replicating from time to time with the error:

  Last_Errno: 1712
  Last_Error: Error 'Index s_order_details is corrupted' on query. Default database: 'foobar_shop'. 
      Query: 'DELETE FROM s_order_details WHERE orderID='40007''

After rebuilding the index by running "alter table foobar_shop.s_order_details engine=innodb" I can restart the slave and it works again.

What I did so far:
Rebuild the whole slave from fresh SQL Dumps (twice!)
Changed replication to "Using_Gtid: Slave_Pos"
Reduced slave parallel threads

Settings as different from debian defaults

binlog_format = mixed
expire_logs_days = 1
max_binlog_size = 256M
slave_parallel_max_queued=524288
slave_parallel_threads=5
sync_binlog=0
sync_relay_log=0
innodb_flush_log_at_trx_commit=0

best regards

Oliver

-- 
Protect your environment -  close windows and adopt a penguin!