[MDEV-37523] [ERROR] mysql_ha_read: Got error 146 when reading table 't' - Jira

XML

Word

Printable

Details

Type: Bug
Status: Open (View Workflow)
Priority: Major
Resolution: Unresolved
Affects Version/s: 10.6, 10.11, 11.4, 11.8, 12.1, 12.2, 12.0.2
Fix Version/s: 10.6, 10.11, 11.4, 11.8, 12.1
Component/s: XA
Labels:
None

Bug Category:
Can result in unexpected behaviour

Description

Getting a error in mysql.err log

CREATE TABLE t (c INT,c2 INT) PARTITION BY HASH (c);

XA START '0';

SET SESSION pseudo_slave_mode=ON;

INSERT INTO t VALUES (0,0);

XA END '0';

XA PREPARE '0';

HANDLER t OPEN;

HANDLER t READ NEXT;

Bug Detection Matrix
Rel o/d Build Commit UniqueID observed
CS 10.6 dbg 210825 8dae7150b28a568491385d8166ed92944e0cc7ed GOT_ERROR\|Got error 146\|when reading table
CS 10.6 opt 210825 8dae7150b28a568491385d8166ed92944e0cc7ed GOT_ERROR\|Got error 146\|when reading table
CS 10.11 dbg 080825 d66a74acb84109ca960680f02cd8113012f2f1de GOT_ERROR\|Got error 146\|when reading table
CS 10.11 opt 080825 d66a74acb84109ca960680f02cd8113012f2f1de GOT_ERROR\|Got error 146\|when reading table
CS 11.4 dbg 080825 03b31c0bd99390c1984f19a19f22dd6e77b7692e GOT_ERROR\|Got error 146\|when reading table
CS 11.4 opt 080825 03b31c0bd99390c1984f19a19f22dd6e77b7692e GOT_ERROR\|Got error 146\|when reading table
CS 11.8 dbg 080825 1a446ccc48528e88a3cd6cd1d1ec9e7492d342ca GOT_ERROR\|Got error 146\|when reading table
CS 11.8 opt 080825 1a446ccc48528e88a3cd6cd1d1ec9e7492d342ca GOT_ERROR\|Got error 146\|when reading table
CS 12.0 dbg 080825 aab83aecdca15738d114cf5a2f223f1d12e4e6bd GOT_ERROR\|Got error 146\|when reading table
CS 12.0 opt 080825 aab83aecdca15738d114cf5a2f223f1d12e4e6bd GOT_ERROR\|Got error 146\|when reading table
CS 12.1 dbg 080825 033471a367b4c60b7262e64f43f46b02e95b9d74 GOT_ERROR\|Got error 146\|when reading table
CS 12.1 opt 080825 033471a367b4c60b7262e64f43f46b02e95b9d74 GOT_ERROR\|Got error 146\|when reading table
CS 12.2 dbg 080825 e02f4d7e311e214ea62ff2e59599849e229f4165 GOT_ERROR\|Got error 146\|when reading table
CS 12.2 opt 080825 e02f4d7e311e214ea62ff2e59599849e229f4165 GOT_ERROR\|Got error 146\|when reading table
ES 10.5 dbg 080825 70586522eacf09d04d49962072e14325a75d8155 GOT_ERROR\|Got error 146\|when reading table
ES 10.5 opt 080825 70586522eacf09d04d49962072e14325a75d8155 GOT_ERROR\|Got error 146\|when reading table
ES 10.6 dbg 080825 9b794f34b48fb7eee490b6da44edc0f33a947447 GOT_ERROR\|Got error 146\|when reading table
ES 10.6 opt 080825 9b794f34b48fb7eee490b6da44edc0f33a947447 GOT_ERROR\|Got error 146\|when reading table
ES 11.4 dbg 080825 a1c03ccd54b582e75506687ee19b273ca897f261 GOT_ERROR\|Got error 146\|when reading table
ES 11.4 opt 080825 a1c03ccd54b582e75506687ee19b273ca897f261 GOT_ERROR\|Got error 146\|when reading table
ES 11.8 dbg 080825 4cdf75ab6ba37d4e7e208690785e880ed3176f2f GOT_ERROR\|Got error 146\|when reading table
ES 11.8 opt 080825 4cdf75ab6ba37d4e7e208690785e880ed3176f2f GOT_ERROR\|Got error 146\|when reading table

Attachments

Issue Links

relates to

MDEV-22733 XA PREPARE breaks MDL in pseudo_slave_mode=1

In Progress

Activity

People

Assignee:: Andrei Elkin

Reporter:: Saahil Alam

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2025-08-28 18:02

Updated:: 5 days ago 07:52

Git Integration

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