[MDEV-17402] slave_transaction_retry_errors="12701" won't be enabled Created: 2018-10-09  Updated: 2019-06-30  Resolved: 2019-06-28

Status: Closed
Project: MariaDB Server
Component/s: Configuration, Storage Engine - Spider
Affects Version/s: 10.3.10
Fix Version/s: 10.4.7

Type: Bug Priority: Major
Reporter: y-taka Assignee: Kentoku Shiba (Inactive)
Resolution: Fixed Votes: 0
Labels: None
Environment:

CentOS 7.4 / Virtual Server



 Description   

I installed SPIDER engine, and try to use below setting :

slave_transaction_retry_errors="1158,1159,1160,1161,12701,2013"

But only "12701" is not enabled.

[How to reproduce]

1) set up SPIDER engine

MariaDB [(none)]> source /usr/share/mysql/install_spider.sql

2) confirm that engine is installed

 
MariaDB [(none)]> show plugins;
+-------------------------------+----------+--------------------+--------------+---------+
| Name                          | Status   | Type               | Library      | License |
+-------------------------------+----------+--------------------+--------------+---------+
| binlog                        | ACTIVE   | STORAGE ENGINE     | NULL         | GPL     |
... cut ...
| SPIDER                        | ACTIVE   | STORAGE ENGINE     | ha_spider.so | GPL     |
| SPIDER_ALLOC_MEM              | ACTIVE   | INFORMATION SCHEMA | ha_spider.so | GPL     |
+-------------------------------+----------+--------------------+--------------+---------+
55 rows in set (0.003 sec)

3) add below setting to my.cnf and restart mysqld

[vagrant@server1 ~]$ sudo vi /etc/my.cnf
 
slave_transaction_retry_errors="1158,1159,1160,1161,12701,2013"
 
[vagrant@server1 ~]$ sudo systemctl restart mysql.service

4) check current slave_transaction_retry_errors variable

MariaDB [(none)]> show global variables like "slave_transaction%";
+----------------------------------+------------------------------------+
| Variable_name                    | Value                              |
+----------------------------------+------------------------------------+
| slave_transaction_retries        | 10                                 |
| slave_transaction_retry_errors   | 1213,1205,1158,1159,1160,1161,2013 |
| slave_transaction_retry_interval | 0                                  |
+----------------------------------+------------------------------------+
3 rows in set (0.002 sec)



 Comments   
Comment by Elena Stepanova [ 2018-10-09 ]

Where did you get error code 12701? What do you expect it to indicate?

Comment by y-taka [ 2018-10-09 ]

I have read below refference manual, and try the same setting.
12701 error seems the particular errno of SPIDER storage engine.

https://mariadb.com/kb/en/library/spider-storage-engine-overview/#some-server-variables-to-set-when-using-spider

Comment by Kentoku Shiba (Inactive) [ 2019-04-29 ]

willhan
error code 12701 is already included in default value, but other plugin specific error codes are ignored because of checking with ER_ERROR_LAST. ER_ERROR_LAST does not include plugin specific error codes. So I just removed it for fixing this issue. Please check the following commit.
df5d6b5

Comment by willhan [ 2019-06-28 ]

kentoku
It' Ok

Comment by Kentoku Shiba (Inactive) [ 2019-06-28 ]

willhan
Thank you for checking this.
I just merged.

Generated at Thu Feb 08 08:36:12 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.