[MDEV-22733] XA PREPARE breaks MDL in pseudo_slave_mode=1 - Jira

Details

Type: Bug
Status: Stalled (View Workflow)
Priority: Critical
Resolution: Unresolved
Affects Version/s: 10.5.4, 10.6
Fix Version/s: 10.5, 10.6
Component/s: XA
Labels:

Description

USE test;

CREATE TABLE t(a INT);

XA START '0';

SET pseudo_slave_mode=1;

INSERT INTO t VALUES(7050+0.75);

XA PREPARE '0';

XA END '0';

XA PREPARE '0';

TRUNCATE TABLE t;

# Shutdown to observe hang (mysqladmin shutdown will hang)

Will cause 10.5.4 8569dac1ec9f6853a0b2f3ea9bcbda67644ead24 (dbg+opt) to hang. Earlier releases not affected.

Note the difference on the last command:

10.5.4 8569dac1ec9f6853a0b2f3ea9bcbda67644ead24
10.5.4>TRUNCATE TABLE t;
Query OK, 0 rows affected (0.013 sec)

10.4.14 ea7830eef48333e28f98a9b91f05a95735b465a3
10.4.14>TRUNCATE TABLE t;
ERROR 1399 (XAE07): XAER_RMFAIL: The command cannot be executed when global transaction is in the PREPARED state

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

threads1
77 kB
2020-05-29 10:36

Issue Links

blocks

MDEV-36022 InnoDB: Failing assertion: trx->roll_limit <= trx->undo_no in trx_rollback_start

Confirmed

is blocked by

MDEV-21602 CREATE TABLE…PRIMARY KEY…SELECT workaround causes DROP TABLE to ignore locks

Closed

is caused by

MDEV-742 LP:803649 - Xa recovery failed on client disconnection

Closed

relates to

MDEV-13564 TRUNCATE TABLE and undo tablespace truncation are not compatible with Mariabackup

Closed

MDEV-22769 Long semaphore wait upon DROP DATABASE with XA holding locks

Closed

MDEV-30941 ASAN: heap-use-after-free in std::__atomic_base from trx_t::commit_tables on XA COMMIT with pseudo_slave_mode enabled

Confirmed

MDEV-35046 SIGSEGV in list_delete in optimized builds when using pseudo_slave_mode

Closed

(2 relates to)

Activity

Ascending order - Click to sort in descending order

Roel Van de Paar created issue - 2020-05-28 02:13

Roel Van de Paar made changes - 2020-05-28 03:43

Field	Original Value	New Value
Summary	Hang on TRUNCATE after XA statements and pseudo_slave_mode=1	Hang on TRUNCATE after XA statements and pseudo_slave_mode=1 (on optimized builds)

Elena Stepanova made changes - 2020-05-29 10:36

Attachment

threads1 [ 52006 ]

Elena Stepanova made changes - 2020-06-02 00:16

Link

This issue relates to ~~MDEV-22769~~ [ ~~MDEV-22769~~ ]

Andrei Elkin made changes - 2020-06-04 09:40

Assignee

Andrei Elkin [ elkin ]

Marko Mäkelä [ marko ]

Marko Mäkelä made changes - 2020-06-04 09:57

Link

This issue relates to ~~MDEV-13564~~ [ ~~MDEV-13564~~ ]

Marko Mäkelä made changes - 2020-06-04 09:58

Fix Version/s		10.2 [ 14601 ]
Fix Version/s		10.3 [ 22126 ]
Fix Version/s		10.4 [ 22408 ]

Marko Mäkelä made changes - 2020-06-04 11:04

Link

This issue is caused by ~~MDEV-742~~ [ ~~MDEV-742~~ ]

Marko Mäkelä made changes - 2020-06-04 11:05

Fix Version/s	10.2 [ 14601 ]
Fix Version/s	10.3 [ 22126 ]
Fix Version/s	10.4 [ 22408 ]
Assignee	Marko Mäkelä [ marko ]	Andrei Elkin [ elkin ]

Marko Mäkelä made changes - 2020-06-04 11:05

Status

Open [ 1 ]

Confirmed [ 10101 ]

Andrei Elkin made changes - 2020-06-04 17:01

Assignee

Andrei Elkin [ elkin ]

Marko Mäkelä [ marko ]

Marko Mäkelä made changes - 2020-06-04 18:07

Status

Confirmed [ 10101 ]

In Progress [ 3 ]

Marko Mäkelä made changes - 2020-06-05 06:35

Link

This issue is caused by ~~MDEV-742~~ [ ~~MDEV-742~~ ]

Marko Mäkelä made changes - 2020-06-05 06:35

Status

In Progress [ 3 ]

Stalled [ 10000 ]

Marko Mäkelä made changes - 2020-06-05 06:38

Link

This issue relates to ~~MDEV-22769~~ [ ~~MDEV-22769~~ ]

Marko Mäkelä made changes - 2020-06-05 06:38

Assignee	Marko Mäkelä [ marko ]	Andrei Elkin [ elkin ]
Priority	Blocker [ 1 ]	Major [ 3 ]

Marko Mäkelä made changes - 2020-06-05 06:38

Link

This issue is caused by ~~MDEV-742~~ [ ~~MDEV-742~~ ]

Marko Mäkelä made changes - 2020-06-05 18:18

Link

This issue relates to ~~MDEV-22769~~ [ ~~MDEV-22769~~ ]

Andrei Elkin made changes - 2020-06-08 11:12

Fix Version/s		N/A [ 14700 ]
Fix Version/s	10.5 [ 23123 ]
Resolution		Duplicate [ 3 ]
Status	Stalled [ 10000 ]	Closed [ 6 ]

Marko Mäkelä made changes - 2020-06-08 12:11

Link

This issue duplicates ~~MDEV-21602~~ [ ~~MDEV-21602~~ ]

Marko Mäkelä made changes - 2020-06-08 12:12

Summary

Hang on TRUNCATE after XA statements and pseudo_slave_mode=1 (on optimized builds)

XA PREPARE breaks MDL in pseudo_slave_mode=1

Marko Mäkelä made changes - 2020-06-08 13:59

Resolution	Duplicate [ 3 ]
Status	Closed [ 6 ]	Stalled [ 10000 ]

Marko Mäkelä made changes - 2020-06-08 13:59

Link

This issue duplicates ~~MDEV-21602~~ [ ~~MDEV-21602~~ ]

Marko Mäkelä made changes - 2020-06-08 13:59

Link

This issue is blocked by ~~MDEV-21602~~ [ ~~MDEV-21602~~ ]

Elena Stepanova made changes - 2020-06-08 14:00

Assignee

Andrei Elkin [ elkin ]

Elena Stepanova [ elenst ]

Marko Mäkelä made changes - 2021-09-01 10:58

Labels

affects-tests not-10.1 not-10.2 not-10.3 not-10.4 regression

affects-tests not-10.1 not-10.2 not-10.3 not-10.4 not-10.6 regression regression-10.5

Marko Mäkelä made changes - 2021-09-01 11:31

Fix Version/s		10.5 [ 23123 ]
Fix Version/s		10.6 [ 24028 ]
Fix Version/s		10.7 [ 24805 ]
Fix Version/s	N/A [ 14700 ]
Affects Version/s		10.6 [ 24028 ]
Assignee	Elena Stepanova [ elenst ]	Andrei Elkin [ elkin ]
Labels	affects-tests not-10.1 not-10.2 not-10.3 not-10.4 not-10.6 regression regression-10.5	affects-tests not-10.1 not-10.2 not-10.3 not-10.4 regression regression-10.5

Julien Fritsch made changes - 2021-09-01 12:58

Priority

Major [ 3 ]

Critical [ 2 ]

Sergei Golubchik made changes - 2021-12-06 21:35

Workflow

MariaDB v3 [ 109238 ]

MariaDB v4 [ 143645 ]

Sergei Golubchik made changes - 2023-01-19 16:38

Priority

Critical [ 2 ]

Major [ 3 ]

Julien Fritsch made changes - 2023-03-03 17:29

Fix Version/s

10.7 [ 24805 ]

Roel Van de Paar made changes - 2023-03-29 21:25

Link

This issue relates to MDEV-30941 [ MDEV-30941 ]

Roel Van de Paar made changes - 2024-10-21 22:49

Link

This issue relates to ~~MDEV-35046~~ [ ~~MDEV-35046~~ ]

Marko Mäkelä made changes - 2025-02-04 09:45

Link

This issue blocks MDEV-36022 [ MDEV-36022 ]

JiraAutomate made changes - 2025-02-04 17:14

Priority

Major [ 3 ]

Critical [ 2 ]

People

Assignee:: Andrei Elkin

Reporter:: Roel Van de Paar

Votes:: 1 Vote for this issue

Watchers:: 8 Start watching this issue

Dates

Created:: 2020-05-28 02:13

Updated:: 2025-02-04 17:14

Git Integration

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

MariaDB Server

Details

Description

Attachments

Attachments

Issue Links

Activity

People

Dates

Git Integration