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