Hi all, After upgrading *MariaDB from 10.2.33 to 10.6.19*, the *SQL Slave Thread* stops roughly every 10 minutes. This only started occurring *after the upgrade*. If I perform a *switchover*, the issue starts happening on the new standby as well. We've mined the *binary log * and found no pattern in the statements where it stops. There are *no errors shown* in slave status. When we run START SLAVE;, everything resumes normally. Currently, you're using a *cron job* to restart the SQL thread regularly. - What could be causing this? - What deeper analysis can be done? 2025-06-25 8:59:25 3152832 [Note] Slave SQL thread exiting, replication
stopped in log 'binlog.001765' at position 657303910, master: xxxx:3306 2025-06-25 9:10:23 3157451 [Note] Slave SQL thread exiting, replication stopped in log 'binlog.001765' at position 988146286, master: xxxx:3306 2025-06-25 9:20:29 3162364 [Note] Slave SQL thread exiting, replication stopped in log 'binlog.001766' at position 220961201, master: xxxx:3306 2025-06-25 9:30:44 3166935 [Note] Slave SQL thread exiting, replication stopped in log 'binlog.001766' at position 529729081, master: xxxx:3306 2025-06-25 9:41:26 3171556 [Note] Slave SQL thread exiting, replication stopped in log 'binlog.001766' at position 848593645, master: xxxx:3306 2025-06-25 10:02:46 3176393 [Note] Slave SQL thread exiting, replication stopped in log 'binlog.001767' at position 420380054, master: xxxx:3306 2025-06-25 10:13:56 3186023 [Note] Slave SQL thread exiting, replication stopped in log 'binlog.001767' at position 753631615, master: xxxx:3306 2025-06-25 10:24:32 3191029 [Note] Slave SQL thread exiting, replication stopped in log 'binlog.001767' at position 1072243011, master: xxxx:3306 2025-06-25 10:36:14 3195944 [Note] Slave SQL thread exiting, replication stopped in log 'binlog.001768' at position 345337292, master: xxxx:3306 2025-06-25 11:17:57 3201245 [Note] Slave SQL thread exiting, replication stopped in log 'binlog.001769' at position 481728557, master: xxxx:3306 2025-06-25 11:49:04 3219634 [Note] Slave SQL thread exiting, replication stopped in log 'binlog.001770' at position 277881467, master: xxxx:3306 2025-06-25 11:59:55 3233322 [Note] Slave SQL thread exiting, replication stopped in log 'binlog.001770' at position 562687566, master: xxxx:3306 2025-06-25 12:30:41 3237753 [Note] Slave SQL thread exiting, replication stopped in log 'binlog.001771' at position 278373954, master: xxxx:3306 2025-06-25 12:51:30 3250513 [Note] Slave SQL thread exiting, replication stopped in log 'binlog.001771' at position 796578679, master: xxxx:3306 2025-06-25 13:02:19 3259002 [Note] Slave SQL thread exiting, replication stopped in log 'binlog.001771' at position 1052723773, master: xxxx:3306 2025-06-25 13:55:51 3263370 [Note] Slave SQL thread exiting, replication stopped in log 'binlog.001773' at position 98331358, master: xxxx:3306 2025-06-25 14:39:13 3283845 [Note] Slave SQL thread exiting, replication stopped in log 'binlog.001773' at position 968704509, master: xxxx:3306 2025-06-25 14:49:38 3299620 [Note] Slave SQL thread exiting, replication stopped in log 'binlog.001774' at position 93970604, master: xxxx:3306 2025-06-25 15:01:35 3303181 [Note] Slave SQL thread exiting, replication stopped in log 'binlog.001774' at position 313622321, master: xxxx:3306 2025-06-25 15:33:48 3307316 [Note] Slave SQL thread exiting, replication stopped in log 'binlog.001774' at position 895518570, master: xxxx:3306 2025-06-25 16:26:06 3318376 [Note] Slave SQL thread exiting, replication stopped in log 'binlog.001775' at position 770087908, master: xxxx:3306 2025-06-25 17:08:48 3336364 [Note] Slave SQL thread exiting, replication stopped in log 'binlog.001776' at position 459626350, master: xxxx:3306 2025-06-25 17:29:58 3350747 [Note] Slave SQL thread exiting, replication stopped in log 'binlog.001776' at position 839271624, master: xxxx:3306 2025-06-25 18:02:42 3357922 [Note] Slave SQL thread exiting, replication stopped in log 'binlog.001777' at position 349932886, master: xxxx:3306 2025-06-25 18:23:19 3369124 [Note] Slave SQL thread exiting, replication stopped in log 'binlog.001777' at position 694190140, master: xxxx:3306 2025-06-25 18:54:53 3375957 [Note] Slave SQL thread exiting, replication stopped in log 'binlog.001778' at position 93981370, master: xxxx:3306 2025-06-25 19:15:51 3385736 [Note] Slave SQL thread exiting, replication stopped in log 'binlog.001778' at position 366703217, master: xxxx:3306
Thanks in advance