Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.3.10
-
None
-
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) |