slave_transaction_retry_errors

In 10.6 ES, 10.6 CS, 10.5 ES, 10.5 CS, 10.4 ES, 10.4 CS:

Tells the slave thread to retry transaction for replication when a query event returns an error from the provided list. Deadlock error, elapsed lock wait timeout, net read error, net read timeout, net write error, net write timeout, connect error and 2 types of lost connection error are automatically added to this list

In 10.3 ES, 10.3 CS:

Tells the slave thread to retry transaction for replication when a query event returns an error from the provided list. Deadlock and elapsed lock wait timeout errors are automatically added to this list

In 10.2 ES, 10.2 CS:

Not present

See also: System Variables for MariaDB Enterprise Server 10.6, in 10.6 CS, in 10.5 ES, in 10.5 CS, in 10.4 ES, in 10.4 CS, in 10.3 ES, in 10.3 CS, in 10.2 ES, and in 10.2 CS

DETAILS

PARAMETERS

Command-line

--slave_transaction_retry_errors=arg

Configuration file

Supported

Dynamic

No

Scope

Global

Data Type

VARCHAR

Default Value

"" (an empty string)

SKYSQL

Cloud

SkySQL Topology

ES Ver

Default

AWS

HA (Primary/Replica)

10.4

1158,1159,1160,1161,1205,1213,1429,2013,12701

AWS

HA (Primary/Replica)

10.5

1158,1159,1160,1161,1205,1213,1429,2013,12701

AWS

Transactional Standalone

10.4

1158,1159,1160,1161,1205,1213,1429,2013,12701

AWS

Transactional Standalone

10.5

1158,1159,1160,1161,1205,1213,1429,2013,12701

AWS

Distributed Transactions

10.5

Not present

GCP

ColumnStore

10.5

1158,1159,1160,1161,1205,1213,1429,2013,12701

GCP

ColumnStore Multi

10.5

1158,1159,1160,1161,1205,1213,1429,2013,12701

GCP

Galera

10.4

1158,1159,1160,1161,1205,1213,1429,2013,12701

GCP

Galera

10.5

1158,1159,1160,1161,1205,1213,1429,2013,12701

GCP

HA (Primary/Replica)

10.4

1158,1159,1160,1161,1205,1213,1429,2013,12701

GCP

HA (Primary/Replica)

10.5

1158,1159,1160,1161,1205,1213,1429,2013,12701

GCP

HTAP

10.5

1158,1159,1160,1161,1205,1213,1429,2013,12701

GCP

Transactional Standalone

10.4

1158,1159,1160,1161,1205,1213,1429,2013,12701

GCP

Transactional Standalone

10.5

1158,1159,1160,1161,1205,1213,1429,2013,12701

GCP

Distributed Transactions

10.5

Not present

See MariaDB SkySQL documentation to learn more about the MariaDB SkySQL database as a service.

CHANGE HISTORY

Release Series

History

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

10.6 Community

  • Present starting in MariaDB Community Server 10.6.0.

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1.

10.5 Community

  • Present starting in MariaDB Community Server 10.5.0.

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

10.4 Community

  • Present starting in MariaDB Community Server 10.4.0.

10.3 Enterprise

  • Present starting in MariaDB Enterprise Server 10.3.16-1.

10.3 Community

  • Added in MariaDB Community Server 10.3.3.

10.2 Enterprise

  • Not present.

10.2 Community

  • Not present.

EXTERNAL REFERENCES