Some binlog_encryption tests intermittently failing on ppc64le-ubuntu-2110

binlog_encryption.encrypted_slave 'ctr,innodb,stmt' w12 [ fail ]

        Test ended at 2022-02-21 23:25:09

CURRENT_TEST: binlog_encryption.encrypted_slave

mysqltest: In included file "/home/buildbot/ppc64le-ubuntu-2110/build/mysql-test/suite/binlog_encryption/testdata.inc": 

included from /home/buildbot/ppc64le-ubuntu-2110/build/mysql-test/suite/binlog_encryption/encrypted_slave.test at line 39:

At line 169: query 'CALL proc_name_to_encrypt('file_name_to_encrypt',@useless_var_to_encrypt)' failed: ER_OPTION_PREVENTS_STATEMENT (1290): The MariaDB server is running with the --secure-file-priv option so it cannot execute this statement

The result from queries just before the failure was:

< snip >

WHILE counter_name_to_encrypt<12 DO

SELECT COUNT(*) INTO @cnt FROM innodb_table_name_to_encrypt;

INSERT INTO innodb_table_name_to_encrypt 

SELECT int_column_name_to_encrypt+@cnt, NOW(6), blob_column_name_to_encrypt, NULL, NULL

FROM innodb_table_name_to_encrypt

ORDER BY int_column_name_to_encrypt;

SET counter_name_to_encrypt = counter_name_to_encrypt+1;

END WHILE;

COMMIT;

END

$$

INSERT INTO myisam_table_name_to_encrypt

SELECT NULL, 'char_literal_to_encrypt', NULL, 'text_to_encrypt';

INSERT INTO myisam_table_name_to_encrypt (char_column_name_to_encrypt) 

SELECT char_column_name_to_encrypt FROM myisam_table_name_to_encrypt;

INSERT INTO myisam_table_name_to_encrypt (char_column_name_to_encrypt) 

SELECT char_column_name_to_encrypt FROM myisam_table_name_to_encrypt;

INSERT INTO myisam_table_name_to_encrypt (char_column_name_to_encrypt) 

SELECT char_column_name_to_encrypt FROM myisam_table_name_to_encrypt;

CALL proc_name_to_encrypt('file_name_to_encrypt',@useless_var_to_encrypt);