[MDEV-30978] On slave XA COMMIT/XA ROLLBACK fail to return an error in read-only mode - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Affects Version/s: 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 10.11, 11.0(EOL), 11.1(EOL)
Fix Version/s: 10.5.22, 10.6.15, 10.9.8, 10.10.6, 10.11.5, 11.0.3, 11.1.2
Component/s: Replication, XA
Labels:
- server
- xa

Description

On slave , Non-super users can able to execute XA COMMIT/XA ROLLBACK.
slave fails to return an error in read-only mode. It causes the slave to break replication when gtid_strict_mode is enabled.

On Master:

MariaDB [test]> select @@read_only;

+-------------+

| @@read_only |

+-------------+

|           0 |

+-------------+

1 row in set (0.000 sec)

MariaDB [test]> XA START 'MyXA';

Query OK, 0 rows affected (0.001 sec)

MariaDB [test]> INSERT INTO test.t1 VALUES(1);

Query OK, 1 row affected (0.001 sec)

MariaDB [test]> XA END 'MyXA';

Query OK, 0 rows affected (0.000 sec)

MariaDB [test]> XA PREPARE 'MyXA';

Query OK, 0 rows affected (0.003 sec)

On slave:

MariaDB [(none)]> select @@read_only;

+-------------+

| @@read_only |

+-------------+

|           1 |

+-------------+

1 row in set (0.001 sec)

MariaDB [test]> show grants;

+---------------------------------------------------------------------------------------------------------+

| Grants for app_user@%                                                                                   |

+---------------------------------------------------------------------------------------------------------+

| GRANT USAGE ON *.* TO "app_user"@"%" IDENTIFIED BY PASSWORD '*8232A1298A49F710DBEE0B330C42EEC825D4190A' |

| GRANT SELECT, INSERT, UPDATE, DELETE ON "test".* TO "app_user"@"%"                                      |

+---------------------------------------------------------------------------------------------------------+

2 rows in set (0.001 sec)

MariaDB [(none)]> XA COMMIT 'MyXA';

Query OK, 0 rows affected (0.004 sec)

on Slave:

MariaDB [test]> select @@read_only;

+-------------+

| @@read_only |

+-------------+

|           1 |

+-------------+

1 row in set (0.000 sec)

MariaDB [test]> show grants;

+---------------------------------------------------------------------------------------------------------+

| Grants for app_user@%                                                                                   |

+---------------------------------------------------------------------------------------------------------+

| GRANT USAGE ON *.* TO "app_user"@"%" IDENTIFIED BY PASSWORD '*8232A1298A49F710DBEE0B330C42EEC825D4190A' |

| GRANT SELECT, INSERT, UPDATE, DELETE ON "test".* TO "app_user"@"%"                                      |

+---------------------------------------------------------------------------------------------------------+

2 rows in set (0.001 sec)

MariaDB [test]> XA ROLLBACK 'MyXA';

Query OK, 0 rows affected (0.005 sec)

Attachments

Activity

Ascending order - Click to sort in descending order

Pandikrishnan Gurusamy created issue - 2023-03-31 07:53

Pandikrishnan Gurusamy made changes - 2023-03-31 07:54

Field	Original Value	New Value
Component/s		XA [ 12400 ]

Pandikrishnan Gurusamy made changes - 2023-03-31 07:54

Fix Version/s	10.3 [ 22126 ]
Fix Version/s	10.4 [ 22408 ]
Fix Version/s	10.5 [ 23123 ]
Fix Version/s	10.6 [ 24028 ]

Pandikrishnan Gurusamy made changes - 2023-03-31 07:54

Affects Version/s		10.3 [ 22126 ]
Affects Version/s		10.4 [ 22408 ]
Affects Version/s		10.5 [ 23123 ]
Affects Version/s		10.6 [ 24028 ]

Pandikrishnan Gurusamy made changes - 2023-03-31 07:58

Description

On slave XA COMMIT/XA ROLLBACK fail to return an error in read-only mode. It cause slave to break replication when gtid_strict_mode is enable.

On Master:
{code}
MariaDB [test]> select @@read_only;
+-------------+
| @@read_only |
+-------------+
| 0 |
+-------------+
1 row in set (0.000 sec)
MariaDB [test]> XA START 'MyXA';
Query OK, 0 rows affected (0.001 sec)

MariaDB [test]> INSERT INTO test.t1 VALUES(1);
Query OK, 1 row affected (0.001 sec)

MariaDB [test]> XA END 'MyXA';
Query OK, 0 rows affected (0.000 sec)

MariaDB [test]> XA PREPARE 'MyXA';
Query OK, 0 rows affected (0.003 sec)
{code}

On slave:
{code}
MariaDB [(none)]> select @@read_only;
+-------------+
| @@read_only |
+-------------+
| 1 |
+-------------+
1 row in set (0.001 sec)

MariaDB [(none)]> XA COMMIT 'MyXA';
Query OK, 0 rows affected (0.004 sec)

{code}

On slave , Non-super users can able to execute XA COMMIT/XA ROLLBACK.
slave fails to return an error in read-only mode. It causes the slave to break replication when gtid_strict_mode is enabled.

On Master:
{code}
MariaDB [test]> select @@read_only;
+-------------+
| @@read_only |
+-------------+
| 0 |
+-------------+
1 row in set (0.000 sec)
MariaDB [test]> XA START 'MyXA';
Query OK, 0 rows affected (0.001 sec)

MariaDB [test]> INSERT INTO test.t1 VALUES(1);
Query OK, 1 row affected (0.001 sec)

MariaDB [test]> XA END 'MyXA';
Query OK, 0 rows affected (0.000 sec)

MariaDB [test]> XA PREPARE 'MyXA';
Query OK, 0 rows affected (0.003 sec)
{code}

On slave:
{code}
MariaDB [(none)]> select @@read_only;
+-------------+
| @@read_only |
+-------------+
| 1 |
+-------------+
1 row in set (0.001 sec)

MariaDB [test]> show grants;
+---------------------------------------------------------------------------------------------------------+
| Grants for app_user@% |
+---------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO "app_user"@"%" IDENTIFIED BY PASSWORD '*8232A1298A49F710DBEE0B330C42EEC825D4190A' |
| GRANT SELECT, INSERT, UPDATE, DELETE ON "test".* TO "app_user"@"%" |
+---------------------------------------------------------------------------------------------------------+
2 rows in set (0.001 sec)

MariaDB [(none)]> XA COMMIT 'MyXA';
Query OK, 0 rows affected (0.004 sec)

{code}

on Slave:

{code}

MariaDB [test]> select @@read_only;
+-------------+
| @@read_only |
+-------------+
| 1 |
+-------------+
1 row in set (0.000 sec)

MariaDB [test]> show grants;
+---------------------------------------------------------------------------------------------------------+
| Grants for app_user@% |
+---------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO "app_user"@"%" IDENTIFIED BY PASSWORD '*8232A1298A49F710DBEE0B330C42EEC825D4190A' |
| GRANT SELECT, INSERT, UPDATE, DELETE ON "test".* TO "app_user"@"%" |
+---------------------------------------------------------------------------------------------------------+
2 rows in set (0.001 sec)

MariaDB [test]> XA ROLLBACK 'MyXA';
Query OK, 0 rows affected (0.005 sec)

{code}

Pandikrishnan Gurusamy made changes - 2023-03-31 07:59

Assignee

Andrei Elkin [ elkin ]

Julien Fritsch made changes - 2023-03-31 16:39

Fix Version/s		10.4 [ 22408 ]
Fix Version/s		10.5 [ 23123 ]
Fix Version/s		10.6 [ 24028 ]
Fix Version/s		10.3 [ 22126 ]

Julien Fritsch made changes - 2023-04-04 15:35

Status

Open [ 1 ]

Needs Feedback [ 10501 ]

Valerii Kravchuk made changes - 2023-04-04 15:42

Status

Needs Feedback [ 10501 ]

Open [ 1 ]

Julien Fritsch made changes - 2023-04-04 16:25

Status

Open [ 1 ]

Confirmed [ 10101 ]

Julien Fritsch made changes - 2023-04-07 07:34

Priority

Major [ 3 ]

Critical [ 2 ]

Julien Fritsch made changes - 2023-04-27 13:46

Fix Version/s

10.3 [ 22126 ]

Andrei Elkin made changes - 2023-05-16 12:07

Status

Confirmed [ 10101 ]

In Progress [ 3 ]

Julien Fritsch made changes - 2023-06-21 07:43

Assignee

Andrei Elkin [ elkin ]

Brandon Nesterenko [ JIRAUSER48702 ]

Brandon Nesterenko made changes - 2023-06-22 14:29

Affects Version/s		10.7 [ 24805 ]
Affects Version/s		10.8 [ 26121 ]
Affects Version/s		10.9 [ 26905 ]
Affects Version/s		10.10 [ 27530 ]
Affects Version/s		10.11 [ 27614 ]
Affects Version/s		11.0 [ 28320 ]
Affects Version/s		11.1 [ 28549 ]
Affects Version/s	10.3 [ 22126 ]
Affects Version/s	10.4 [ 22408 ]

Brandon Nesterenko made changes - 2023-06-22 14:30

Fix Version/s

10.4 [ 22408 ]

Brandon Nesterenko made changes - 2023-06-26 17:16

Assignee	Brandon Nesterenko [ JIRAUSER48702 ]	Andrei Elkin [ elkin ]
Status	In Progress [ 3 ]	In Review [ 10002 ]

Ralf Gebhardt made changes - 2023-07-06 09:42

Link

This issue blocks TODO-4054 [ TODO-4054 ]

Brandon Nesterenko made changes - 2023-07-11 17:37

Assignee

Andrei Elkin [ elkin ]

Brandon Nesterenko [ JIRAUSER48702 ]

Brandon Nesterenko made changes - 2023-07-11 17:40

issue.field.resolutiondate

2023-07-11 17:40:09.0

2023-07-11 17:40:09.257

Brandon Nesterenko made changes - 2023-07-11 17:40

Component/s		Replication [ 10100 ]
Fix Version/s		10.5.22 [ 29011 ]
Fix Version/s		10.6.15 [ 29013 ]
Fix Version/s		10.9.8 [ 29015 ]
Fix Version/s		10.10.6 [ 29017 ]
Fix Version/s		10.11.5 [ 29019 ]
Fix Version/s		11.0.3 [ 28920 ]
Fix Version/s		11.1.2 [ 28921 ]
Fix Version/s	10.5 [ 23123 ]
Fix Version/s	10.6 [ 24028 ]
Resolution		Fixed [ 1 ]
Status	In Review [ 10002 ]	Closed [ 6 ]

Andrei Elkin made changes - 2023-07-13 07:23

Labels

replication

server xa

Jira Automation (IT) made changes - 2024-07-04 01:12

Zendesk Related Tickets

115837

People

Assignee:: Brandon Nesterenko

Reporter:: Pandikrishnan Gurusamy

Votes:: 1 Vote for this issue

Watchers:: 6 Start watching this issue

Dates

Created:: 2023-03-31 07:53

Updated:: 2024-07-07 19:37

Resolved:: 2023-07-11 17:40

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server

Details

Description

Attachments

Activity

People

Dates

Git Integration