binlog_encryption.encrypted_master fails - Failed to sync slave SQL thread with slave IO thread

        {

            "test_name": "binlog_encryption.encrypted_master",

            "fail_count": 9,

            "fail_url": "https://buildbot.mariadb.org/cr/api/testfailures/?test_name=binlog_encryption.encrypted_master&min_date=2026-09-11T00%3A00%3A00&limit=100&sort_order=desc&max_date=2026-09-18T00%3A00%3A00",

            "branches": {

                "11.8": {

                    "failure_count": 3,

                    "distinct_failure_texts": [

                        {

                            "builder_name": "s390x-ubuntu-2204-debug",

                            "commit": "5c30108c0e84a9dc0c93c07106de7f1d8aa2ac25",

                            "branch": "11.8",

                            "dt": "2026-09-16T20:45:36Z",

                            "test_name": "binlog_encryption.encrypted_master",

                            "info_text": "",

                            "failure_text": "binlog_encryption.encrypted_master 'cbc,mix' w1 [ fail ]\n        Test ended at 2026-09-16 19:01:30\n\nCURRENT_TEST: binlog_encryption.encrypted_master\nmysqltest: In included file \"./include/sync_slave_sql_with_io.inc\": \nincluded from /home/buildbot/s390x-ubuntu-2204-debug/build/mysql-test/suite/binlog_encryption/encrypted_master.test at line 164:\nAt line 46: Failed to sync slave SQL thread with slave IO thread.\n\nThe result from queries just before the failure was:\n< snip >\nmaster-bin.000005\t114370\tAnnotate_rows\t1\t114472\tDELETE FROM aria_table_name_to_encrypt ORDER BY int_column_name_to_encrypt LIMIT 10\nmaster-bin.000005\t114472\tTable_map\t1\t114567\ttable_id: 80 (database_name_to_encrypt.aria_table_name_to_encrypt)\nmaster-bin.000005\t114567\tDelete_rows_v1\t1\t114646\ttable_id: 80 flags: STMT_END_F\nmaster-bin.000005\t114646\tQuery\t1\t114735\tCOMMIT\nmaster-bin.000005\t114735\tGtid\t1\t114773\tGTID 0-1-140\nmaster-bin.000005\t114773\tQuery\t1\t114906\tuse `database_name_to_encrypt`; ANALYZE TABLE myisam_table_name_to_encrypt\nmaster-bin.000005\t114906\tGtid\t1\t114944\tGTID 0-1-141\nmaster-bin.000005\t114944\tQuery\t1\t115087\tuse `database_name_to_encrypt`; RENAME USER user_name_to_encrypt to new_user_name_to_encrypt\nmaster-bin.000005\t115087\tGtid\t1\t115125\tGTID 0-1-142\nmaster-bin.000005\t115125\tQuery\t1\t115273\tuse `database_name_to_encrypt`; REVOKE ALL PRIVILEGES, GRANT OPTION FROM new_user_name_to_encrypt\nmaster-bin.000005\t115273\tGtid\t1\t115311\tGTID 0-1-143\nmaster-bin.000005\t115311\tQuery\t1\t115441\tDROP DATABASE database_name_to_encrypt\nmaster-bin.000005\t115441\tGtid\t1\t115479\tGTID 0-1-144\nmaster-bin.000005\t115479\tQuery\t1\t115572\tDROP USER new_user_name_to_encrypt\n\n**** SHOW RELAYLOG EVENTS on server_1 ****\nrelaylog_name = 'No such row'\nSHOW RELAYLOG EVENTS IN 'No such row' LIMIT 200;\nLog_name\tPos\tEvent_type\tServer_id\tEnd_log_pos\tInfo\nconnection server_2;\n\nMore results from queries before failure can be found in /home/buildbot/s390x-ubuntu-2204-debug/build/mysql-test/var/1/log/encrypted_master.log\n\n - saving '/home/buildbot/s390x-ubuntu-2204-debug/build/mysql-test/var/1/log/binlog_encryption.encrypted_master-cbc,mix/' to '/home/buildbot/s390x-ubuntu-2204-debug/build/mysql-test/var/log/binlog_encryption.encrypted_master-cbc,mix/'\n\nRetrying test binlog_encryption.encrypted_master, attempt(2/3)...\n"

                        }

                    ]

                },

                "13.1": {

                    "failure_count": 6,

                    "distinct_failure_texts": [

                        {

                            "builder_name": "s390x-ubuntu-2204-debug",

                            "commit": "964bb87001bb652dd9dcb992d7db367b3ba7f68e",

                            "branch": "13.1",

                            "dt": "2026-09-15T13:21:44Z",

                            "test_name": "binlog_encryption.encrypted_master",

                            "info_text": "",

                            "failure_text": "binlog_encryption.encrypted_master 'cbc,mix' w9 [ fail ]\n        Test ended at 2026-09-15 11:38:15\n\nCURRENT_TEST: binlog_encryption.encrypted_master\nmysqltest: In included file \"./include/sync_slave_sql_with_io.inc\": \nincluded from /home/buildbot/s390x-ubuntu-2204-debug/build/mysql-test/suite/binlog_encryption/encrypted_master.test at line 164:\nAt line 46: Failed to sync slave SQL thread with slave IO thread.\n\nThe result from queries just before the failure was:\n< snip >\nmaster-bin.000005\t113573\tAnnotate_rows\t1\t113675\tDELETE FROM aria_table_name_to_encrypt ORDER BY int_column_name_to_encrypt LIMIT 10\nmaster-bin.000005\t113675\tTable_map\t1\t113770\ttable_id: 80 (database_name_to_encrypt.aria_table_name_to_encrypt)\nmaster-bin.000005\t113770\tDelete_rows_v1\t1\t113849\ttable_id: 80 flags: STMT_END_F\nmaster-bin.000005\t113849\tQuery\t1\t113938\tCOMMIT\nmaster-bin.000005\t113938\tGtid\t1\t113976\tGTID 0-1-132\nmaster-bin.000005\t113976\tQuery\t1\t114109\tuse `database_name_to_encrypt`; ANALYZE TABLE myisam_table_name_to_encrypt\nmaster-bin.000005\t114109\tGtid\t1\t114147\tGTID 0-1-133\nmaster-bin.000005\t114147\tQuery\t1\t114290\tuse `database_name_to_encrypt`; RENAME USER user_name_to_encrypt to new_user_name_to_encrypt\nmaster-bin.000005\t114290\tGtid\t1\t114328\tGTID 0-1-134\nmaster-bin.000005\t114328\tQuery\t1\t114476\tuse `database_name_to_encrypt`; REVOKE ALL PRIVILEGES, GRANT OPTION FROM new_user_name_to_encrypt\nmaster-bin.000005\t114476\tGtid\t1\t114514\tGTID 0-1-135\nmaster-bin.000005\t114514\tQuery\t1\t114644\tDROP DATABASE database_name_to_encrypt\nmaster-bin.000005\t114644\tGtid\t1\t114682\tGTID 0-1-136\nmaster-bin.000005\t114682\tQuery\t1\t114775\tDROP USER new_user_name_to_encrypt\n\n**** SHOW RELAYLOG EVENTS on server_1 ****\nrelaylog_name = 'No such row'\nSHOW RELAYLOG EVENTS IN 'No such row' LIMIT 200;\nLog_name\tPos\tEvent_type\tServer_id\tEnd_log_pos\tInfo\nconnection server_2;\n\nMore results from queries before failure can be found in /home/buildbot/s390x-ubuntu-2204-debug/build/mysql-test/var/9/log/encrypted_master.log\n\n - saving '/home/buildbot/s390x-ubuntu-2204-debug/build/mysql-test/var/9/log/binlog_encryption.encrypted_master-cbc,mix/' to '/home/buildbot/s390x-ubuntu-2204-debug/build/mysql-test/var/log/binlog_encryption.encrypted_master-cbc,mix/'\n\nRetrying test binlog_encryption.encrypted_master, attempt(2/3)...\n"

                        }

                    ]

                }

            }

        }