[MDEV-36161] [ERROR] InnoDB: tried to purge non-delete-marked record in index with encrypted tables - Jira

Details

Type: Bug
Status: Needs Feedback (View Workflow)
Priority: Major
Resolution: Unresolved
Affects Version/s: 10.11.10
Fix Version/s: 10.11
Component/s: None
Labels:
None

Description

IT happens on char() columns and ENCRYPTED`=YES

2025-02-23  1:15:15 0 [ERROR] InnoDB: tried to purge non-delete-marked record in index `IDX_MAS_ACCOUNT_NO` of table `lms`.`EOD_TXN`: tuple: TUPLE (info_bits=0, 3 fields): {[10]0011267904(0x30303131323637393034),[30]20240223:1842621212:0011267904(0x32303234303232333A313834323632313231323A30303131323637393034),[8]NO SWEEP(0x4E4F205357454550)}, record: COMPACT RECORD(info_bits=0, 3 fields): {[10]0011267904(0x30303131323637393034),[30]20240223:1842621212:0011267904(0x32303234303232333A313834323632313231323A30303131323637393034),[8]NO SWEEP(0x4E4F205357454550)}

2025-02-23  1:15:15 0 [ERROR] InnoDB: Flagged corruption of `IDX_MAS_ACCOUNT_NO` in table `lms`.`EOD_TXN` in purge

2025-02-23  1:15:16 0 [ERROR] InnoDB: tried to purge non-delete-marked record in index `IND_TXN_SEQ` of table `lms`.`DTD_TXN`: tuple: TUPLE (info_bits=0, 3 fields): {[3]003(0x303033),[42]668000521080590000000084872074012800010000(0x363638303030353231303830353930303030303030303834383732303734303132383030303130303030),[24]000521080590000000084872(0x303030353231303830353930303030303030303834383732)}, record: COMPACT RECORD(info_bits=0, 3 fields): {[3]003(0x303033),[42]668000521080590000000084872074012800010000(0x363638303030353231303830353930303030303030303834383732303734303132383030303130303030),[24]000521080590000000084872(0x303030353231303830353930303030303030303834383732)}

2025-02-23  1:15:16 0 [ERROR] InnoDB: Flagged corruption of `IND_TXN_SEQ` in table `lms`.`DTD_TXN` in purge

2025-02-23  1:15:19 0 [ERROR] InnoDB: Unable to purge a record

InnoDB: tuple DATA TUPLE: 3 fields;

 0: len 0; hex ; asc ;;

 1: len 62; hex 373839303137383930315f32303234303232305f44544430365f4630335f32745a51383450566d536f36535578344c4e65534b6930373430383336303030; asc 7890178901_20240220_DTD06_F03_2tZQ84PVmSo6SUx4LNeSKi0740836000;;

 2: len 24; hex 303032363131303632353237303030303030343139353131; asc 002611062527000000419511;;

InnoDB: record PHYSICAL RECORD: n_fields 3; compact format; info bits 0

 0: len 0; hex ; asc ;;

 1: len 30; hex 373839303137383930315f32303234303232305f44544430365f4630335f; asc 7890178901_20240220_DTD06_F03_; (total 62 bytes);

 2: len 24; hex 303032363131303632353237303030303030343139353131; asc 002611062527000000419511;;

space 2465 offset 43037 (168 records, index id 2034)

InnoDB: Submit a detailed bug report to https://jira.mariadb.org/

2025-02-23  1:15:19 0 [ERROR] InnoDB: Unable to purge a record

InnoDB: tuple DATA TUPLE: 3 fields;

 0: len 0; hex ; asc ;;

 1: len 62; hex 373839303137383930315f32303234303232305f44544430365f4630335f32774c6f414378765646326e687479755464444e4c3730373430383431373030; asc 7890178901_20240220_DTD06_F03_2wLoACxvVF2nhtyuTdDNL70740841700;;

 2: len 24; hex 303032363131303632353237303030303030343139353639; asc 002611062527000000419569;;

InnoDB: record PHYSICAL RECORD: n_fields 3; compact format; info bits 0

 0: len 0; hex ; asc ;;

 1: len 30; hex 373839303137383930315f32303234303232305f44544430365f4630335f; asc 7890178901_20240220_DTD06_F03_; (total 62 bytes);

 2: len 24; hex 303032363131303632353237303030303030343139353639; asc 002611062527000000419569;;

space 2465 offset 43037 (168 records, index id 2034)

InnoDB: Submit a detailed bug report to https://jira.mariadb.org/

2025-02-23  1:15:19 0 [ERROR] InnoDB: Unable to purge a record

InnoDB: tuple DATA TUPLE: 3 fields;

 0: len 0; hex ; asc ;;

 1: len 63; hex 373839303137383930315f32303234303232305f44544430365f4630335f33326858583734427932517675734275535a596a78693037343031383136373030; asc 7890178901_20240220_DTD06_F03_32hXX74By2QvusBuSZYjxi07401816700;;

 2: len 24; hex 303032363131303632353237303030303030343139383830; asc 002611062527000000419880;;

InnoDB: record PHYSICAL RECORD: n_fields 3; compact format; info bits 0

 0: len 0; hex ; asc ;;

 1: len 30; hex 373839303137383930315f32303234303232305f44544430365f4630335f; asc 7890178901_20240220_DTD06_F03_; (total 63 bytes);

 2: len 24; hex 303032363131303632353237303030303030343139383830; asc 002611062527000000419880;;

space 2465 offset 43037 (168 records, index id 2034)

InnoDB: Submit a detailed bug report to https://jira.mariadb.org/

2025-02-23  1:15:19 0 [ERROR] InnoDB: Unable to purge a record

InnoDB: tuple DATA TUPLE: 3 fields;

 0: len 0; hex ; asc ;;

 1: len 63; hex 373839303137383930315f32303234303232305f44544430365f4630335f33655067514e4a567a64664b4d416e677445646370683037343032313834343030; asc 7890178901_20240220_DTD06_F03_3ePgQNJVzdfKMAngtEdcph07402184400;;

 2: len 24; hex 303032363131303632353237303030303030343139353537; asc 002611062527000000419557;;

InnoDB: record PHYSICAL RECORD: n_fields 3; compact format; info bits 0

 0: len 0; hex ; asc ;;

 1: len 30; hex 373839303137383930315f32303234303232305f44544430365f4630335f; asc 7890178901_20240220_DTD06_F03_; (total 63 bytes);

 2: len 24; hex 303032363131303632353237303030303030343139353537; asc 002611062527000000419557;;

space 2465 offset 43037 (168 records, index id 2034)

InnoDB: Submit a detailed bug report to https://jira.mariadb.org/

2025-02-23  1:15:19 0 [ERROR] InnoDB: Unable to purge a record

InnoDB: tuple DATA TUPLE: 3 fields;

 0: len 0; hex ; asc ;;

 1: len 62; hex 373839303137383930315f32303234303232305f44544430365f4630335f334a73486a7338413533767a4d50346b51534769746b30373430363734313030; asc 7890178901_20240220_DTD06_F03_3JsHjs8A53vzMP4kQSGitk0740674100;;

 2: len 24; hex 303032363131303632353237303030303030343139333532; asc 002611062527000000419352;;

InnoDB: record PHYSICAL RECORD: n_fields 3; compact format; info bits 0

 0: len 0; hex ; asc ;;

 1: len 30; hex 373839303137383930315f32303234303232305f44544430365f4630335f; asc 7890178901_20240220_DTD06_F03_; (total 62 bytes);

 2: len 24; hex 303032363131303632353237303030303030343139333532; asc 002611062527000000419352;;

space 2465 offset 43037 (168 records, index id 2034)

InnoDB: Submit a detailed bug report to https://jira.mariadb.org/

2025-02-23  1:15:19 0 [ERROR] InnoDB: Unable to purge a record

InnoDB: tuple DATA TUPLE: 3 fields;

 0: len 0; hex ; asc ;;

 1: len 63; hex 373839303137383930315f32303234303232305f44544430365f4630335f334b7a435272714e584157347233636d776e693573703037343031303031323030; asc 7890178901_20240220_DTD06_F03_3KzCRrqNXAW4r3cmwni5sp07401001200;;

 2: len 24; hex 303032363131303632353237303030303030343139383137; asc 002611062527000000419817;;

InnoDB: record PHYSICAL RECORD: n_fields 3; compact format; info bits 0

 0: len 0; hex ; asc ;;

 1: len 30; hex 373839303137383930315f32303234303232305f44544430365f4630335f; asc 7890178901_20240220_DTD06_F03_; (total 63 bytes);

 2: len 24; hex 303032363131303632353237303030303030343139383137; asc 002611062527000000419817;;

space 2465 offset 43037 (168 records, index id 2034)

InnoDB: Submit a detailed bug report to https://jira.mariadb.org/

2025-02-23  1:15:19 0 [ERROR] InnoDB: Unable to purge a record

InnoDB: tuple DATA TUPLE: 3 fields;

 0: len 0; hex ; asc ;;

 1: len 63; hex 373839303137383930315f32303234303232305f44544430365f4630335f336d574c487334417559593237484239326b61366d463037343031363938393030; asc 7890178901_20240220_DTD06_F03_3mWLHs4AuYY27HB92ka6mF07401698900;;

 2: len 24; hex 303032363131303632353237303030303030343139363330; asc 002611062527000000419630;;

InnoDB: record PHYSICAL RECORD: n_fields 3; compact format; info bits 0

 0: len 0; hex ; asc ;;

 1: len 30; hex 373839303137383930315f32303234303232305f44544430365f4630335f; asc 7890178901_20240220_DTD06_F03_; (total 63 bytes);

 2: len 24; hex 303032363131303632353237303030303030343139363330; asc 002611062527000000419630;;

space 2465 offset 43037 (168 records, index id 2034)

InnoDB: Submit a detailed bug report to https://jira.mariadb.org/

2025-02-23  1:15:19 0 [ERROR] InnoDB: Unable to purge a record

InnoDB: tuple DATA TUPLE: 3 fields;

 0: len 0; hex ; asc ;;

 1: len 63; hex 373839303137383930315f32303234303232305f44544430365f4630335f334e77426862553272325735633333726a667479777a3037343031373730373030; asc 7890178901_20240220_DTD06_F03_3NwBhbU2r2W5c33rjftywz07401770700;;

 2: len 24; hex 303032363131303632353237303030303030343139353430; asc 002611062527000000419540;;

InnoDB: record PHYSICAL RECORD: n_fields 3; compact format; info bits 0

 0: len 0; hex ; asc ;;

 1: len 30; hex 373839303137383930315f32303234303232305f44544430365f4630335f; asc 7890178901_20240220_DTD06_F03_; (total 63 bytes);

 2: len 24; hex 303032363131303632353237303030303030343139353430; asc 002611062527000000419540;;

space 2465 offset 43037 (168 records, index id 2034)

InnoDB: Submit a detailed bug report to https://jira.mariadb.org/

2025-02-23  1:15:19 0 [ERROR] InnoDB: Unable to purge a record

InnoDB: tuple DATA TUPLE: 3 fields;

 0: len 0; hex ; asc ;;

 1: len 62; hex 373839303137383930315f32303234303232305f44544430365f4630335f33535a6d7a4351796e666962666d72566f58575a357330373430383039313030; asc 7890178901_20240220_DTD06_F03_3SZmzCQynfibfmrVoXWZ5s0740809100;;

 2: len 24; hex 303032363131303632353237303030303030343139343132; asc 002611062527000000419412;;

InnoDB: record PHYSICAL RECORD: n_fields 3; compact format; info bits 0

 0: len 0; hex ; asc ;;

 1: len 30; hex 373839303137383930315f32303234303232305f44544430365f4630335f; asc 7890178901_20240220_DTD06_F03_; (total 62 bytes);

 2: len 24; hex 303032363131303632353237303030303030343139343132; asc 002611062527000000419412;;

space 2465 offset 43037 (168 records, index id 2034)

InnoDB: Submit a detailed bug report to https://jira.mariadb.org/

2025-02-23  1:15:19 0 [ERROR] InnoDB: Unable to purge a record

InnoDB: tuple DATA TUPLE: 3 fields;

 0: len 0; hex ; asc ;;

 1: len 62; hex 373839303137383930315f32303234303232305f44544430365f4630335f3358654e726a727073775a61546537596e564d6d735130373430383336303030; asc 7890178901_20240220_DTD06_F03_3XeNrjrpswZaTe7YnVMmsQ0740836000;;

 2: len 24; hex 303032363131303632353237303030303030343139343937; asc 002611062527000000419497;;

InnoDB: record PHYSICAL RECORD: n_fields 3; compact format; info bits 0

 0: len 0; hex ; asc ;;

 1: len 30; hex 373839303137383930315f32303234303232305f44544430365f4630335f; asc 7890178901_20240220_DTD06_F03_; (total 62 bytes);

 2: len 24; hex 303032363131303632353237303030303030343139343937; asc 002611062527000000419497;;

space 2465 offset 43037 (168 records, index id 2034)

InnoDB: Submit a detailed bug report to https://jira.mariadb.org/

2025-02-23  1:15:19 0 [ERROR] InnoDB: Unable to purge a record

InnoDB: tuple DATA TUPLE: 3 fields;

 0: len 0; hex ; asc ;;

 1: len 62; hex 373839303137383930315f32303234303232305f44544430365f4630335f3432695032416671775243755453573351633766395730373430383336303030; asc 7890178901_20240220_DTD06_F03_42iP2AfqwRCuTSW3Qc7f9W0740836000;;

 2: len 24; hex 303032363131303632353237303030303030343139353031; asc 002611062527000000419501;;

InnoDB: record PHYSICAL RECORD: n_fields 3; compact format; info bits 0

 0: len 0; hex ; asc ;;

 1: len 30; hex 373839303137383930315f32303234303232305f44544430365f4630335f; asc 7890178901_20240220_DTD06_F03_; (total 62 bytes);

 2: len 24; hex 303032363131303632353237303030303030343139353031; asc 002611062527000000419501;;

space 2465 offset 43037 (168 records, index id 2034)

InnoDB: Submit a detailed bug report to https://jira.mariadb.org/

2025-02-23  1:15:19 0 [ERROR] InnoDB: Unable to purge a record

InnoDB: tuple DATA TUPLE: 3 fields;

 0: len 0; hex ; asc ;;

 1: len 63; hex 373839303137383930315f32303234303232305f44544430365f4630335f34436267527078466f6b41336b77714d6235696559343037343031313134393030; asc 7890178901_20240220_DTD06_F03_4CbgRpxFokA3kwqMb5ieY407401114900;;

 2: len 24; hex 303032363131303632353237303030303030343139323830; asc 002611062527000000419280;;

InnoDB: record PHYSICAL RECORD: n_fields 3; compact format; info bits 0

 0: len 0; hex ; asc ;;

 1: len 30; hex 373839303137383930315f32303234303232305f44544430365f4630335f; asc 7890178901_20240220_DTD06_F03_; (total 63 bytes);

 2: len 24; hex 303032363131303632353237303030303030343139323830; asc 002611062527000000419280;;

space 2465 offset 43037 (168 records, index id 2034)

InnoDB: Submit a detailed bug report to https://jira.mariadb.org/

2025-02-23  1:15:19 0 [ERROR] InnoDB: Unable to purge a record

InnoDB: tuple DATA TUPLE: 3 fields;

 0: len 0; hex ; asc ;;

 1: len 63; hex 373839303137383930315f32303234303232305f44544430365f4630335f3447324b6e4a65467134714a674e6f4432415a5050593037343031323431383030; asc 7890178901_20240220_DTD06_F03_4G2KnJeFq4qJgNoD2AZPPY07401241800;;

 2: len 24; hex 303032363131303632353237303030303030343139353333; asc 002611062527000000419533;;

InnoDB: record PHYSICAL RECORD: n_fields 3; compact format; info bits 0

 0: len 0; hex ; asc ;;

 1: len 30; hex 373839303137383930315f32303234303232305f44544430365f4630335f; asc 7890178901_20240220_DTD06_F03_; (total 63 bytes);

 2: len 24; hex 303032363131303632353237303030303030343139353333; asc 002611062527000000419533;;

space 2465 offset 43037 (168 records, index id 2034)

InnoDB: Submit a detailed bug report to https://jira.mariadb.org/

2025-02-23  1:15:19 0 [ERROR] InnoDB: Unable to purge a record

InnoDB: tuple DATA TUPLE: 3 fields;

 0: len 0; hex ; asc ;;

 1: len 63; hex 373839303137383930315f32303234303232305f44544430365f4630335f34487846646763616669397070697439654d4a5164513037343032313530363030; asc 7890178901_20240220_DTD06_F03_4HxFdgcafi9ppit9eMJQdQ07402150600;;

 2: len 24; hex 303032363131303632353237303030303030343139333534; asc 002611062527000000419354;;

InnoDB: record PHYSICAL RECORD: n_fields 3; compact format; info bits 0

 0: len 0; hex ; asc ;;

 1: len 30; hex 373839303137383930315f32303234303232305f44544430365f4630335f; asc 7890178901_20240220_DTD06_F03_; (total 63 bytes);

 2: len 24; hex 303032363131303632353237303030303030343139333534; asc 002611062527000000419354;;

space 2465 offset 43037 (168 records, index id 2034)

InnoDB: Submit a detailed bug report to https://jira.mariadb.org/

2025-02-23  1:15:19 0 [ERROR] InnoDB: Unable to purge a record

InnoDB: tuple DATA TUPLE: 3 fields;

 0: len 0; hex ; asc ;;

 1: len 62; hex 373839303137383930315f32303234303232305f44544430365f4630335f344b6743683652644c4c756d4b6358374c724a47765430373430383133363030; asc 7890178901_20240220_DTD06_F03_4KgCh6RdLLumKcX7LrJGvT0740813600;;

 2: len 24; hex 303032363131303632353237303030303030343139343434; asc 002611062527000000419444;;

InnoDB: record PHYSICAL RECORD: n_fields 3; compact format; info bits 0

 0: len 0; hex ; asc ;;

 1: len 30; hex 373839303137383930315f32303234303232305f44544430365f4630335f; asc 7890178901_20240220_DTD06_F03_; (total 62 bytes);

 2: len 24; hex 303032363131303632353237303030303030343139343434; asc 002611062527000000419444;;

space 2465 offset 43037 (168 records, index id 2034)

InnoDB: Submit a detailed bug report to https://jira.mariadb.org/

2025-02-23  1:15:19 0 [ERROR] InnoDB: Unable to purge a record

InnoDB: tuple DATA TUPLE: 3 fields;

 0: len 0; hex ; asc ;;

 1: len 62; hex 373839303137383930315f32303234303232305f44544430365f4630335f344b6e5170563374654d45636756796b4d374154524c30373430383535313030; asc 7890178901_20240220_DTD06_F03_4KnQpV3teMEcgVykM7ATRL0740855100;;

 2: len 24; hex 303032363131303632353237303030303030343139363638; asc 002611062527000000419668;;

InnoDB: record PHYSICAL RECORD: n_fields 3; compact format; info bits 0

 0: len 0; hex ; asc ;;

 1: len 30; hex 373839303137383930315f32303234303232305f44544430365f4630335f; asc 7890178901_20240220_DTD06_F03_; (total 62 bytes);

 2: len 24; hex 303032363131303632353237303030303030343139363638; asc 002611062527000000419668;;

space 2465 offset 43037 (168 records, index id 2034)

InnoDB: Submit a detailed bug report to https://jira.mariadb.org/

2025-02-23  1:15:19 0 [ERROR] InnoDB: Unable to purge a record

InnoDB: tuple DATA TUPLE: 3 fields;

 0: len 0; hex ; asc ;;

 1: len 62; hex 373839303137383930315f32303234303232305f44544430365f4630335f346d753741745739786e51675962706339436f47644830373430373936363030; asc 7890178901_20240220_DTD06_F03_4mu7AtW9xnQgYbpc9CoGdH0740796600;;

 2: len 24; hex 303032363131303632353237303030303030343139333839; asc 002611062527000000419389;;

InnoDB: record PHYSICAL RECORD: n_fields 3; compact format; info bits 0

 0: len 0; hex ; asc ;;

 1: len 30; hex 373839303137383930315f32303234303232305f44544430365f4630335f; asc 7890178901_20240220_DTD06_F03_; (total 62 bytes);

 2: len 24; hex 303032363131303632353237303030303030343139333839; asc 002611062527000000419389;;

space 2465 offset 43037 (168 records, index id 2034)

InnoDB: Submit a detailed bug report to https://jira.mariadb.org/

2025-02-23  1:15:19 0 [ERROR] InnoDB: Unable to purge a record

InnoDB: tuple DATA TUPLE: 3 fields;

 0: len 0; hex ; asc ;;

 1: len 63; hex 373839303137383930315f32303234303232305f44544430365f4630335f34524d53686658547069654a6b334578444d4b5544743037343031383535393030; asc 7890178901_20240220_DTD06_F03_4RMShfXTpieJk3ExDMKUDt07401855900;;

 2: len 24; hex 303032363131303632353237303030303030343139333933; asc 002611062527000000419393;;

InnoDB: record PHYSICAL RECORD: n_fields 3; compact format; info bits 0

 0: len 0; hex ; asc ;;

 1: len 30; hex 373839303137383930315f32303234303232305f44544430365f4630335f; asc 7890178901_20240220_DTD06_F03_; (total 63 bytes);

 2: len 24; hex 303032363131303632353237303030303030343139333933; asc 002611062527000000419393;;

space 2465 offset 43037 (168 records, index id 2034)

InnoDB: Submit a detailed bug report to https://jira.mariadb.org/

2025-02-23  1:15:19 0 [ERROR] InnoDB: Unable to purge a record

InnoDB: tuple DATA TUPLE: 3 fields;

 0: len 0; hex ; asc ;;

 1: len 63; hex 373839303137383930315f32303234303232305f44544430365f4630335f34784538434c4e6737443765765155547345486a4d6f3037343031313733363030; asc 7890178901_20240220_DTD06_F03_4xE8CLNg7D7evQUTsEHjMo07401173600;;

 2: len 24; hex 303032363131303632353237303030303030343139363739; asc 002611062527000000419679;;

InnoDB: record PHYSICAL RECORD: n_fields 3; compact format; info bits 0

 0: len 0; hex ; asc ;;

 1: len 30; hex 373839303137383930315f32303234303232305f44544430365f4630335f; asc 7890178901_20240220_DTD06_F03_; (total 63 bytes);

 2: len 24; hex 303032363131303632353237303030303030343139363739; asc 002611062527000000419679;;

space 2465 offset 43037 (168 records, index id 2034)

InnoDB: Submit a detailed bug report to https://jira.mariadb.org/

2025-02-23  1:15:19 0 [ERROR] InnoDB: Unable to purge a record

InnoDB: tuple DATA TUPLE: 3 fields;

 0: len 0; hex ; asc ;;

 1: len 63; hex 373839303137383930315f32303234303232305f44544430365f4630335f34784a487632484d337677396b6436716752543277593037343036373830363030; asc 7890178901_20240220_DTD06_F03_4xJHv2HM3vw9kd6qgRT2wY07406780600;;

 2: len 24; hex 303032363131303632353237303030303030343139353839; asc 002611062527000000419589;;

InnoDB: record PHYSICAL RECORD: n_fields 3; compact format; info bits 0

 0: len 0; hex ; asc ;;

 1: len 30; hex 373839303137383930315f32303234303232305f44544430365f4630335f; asc 7890178901_20240220_DTD06_F03_; (total 63 bytes);

 2: len 24; hex 303032363131303632353237303030303030343139353839; asc 002611062527000000419589;;

space 2465 offset 43037 (168 records, index id 2034)

InnoDB: Submit a detailed bug report to https://jira.mariadb.org/

2025-02-23  1:15:19 0 [ERROR] InnoDB: Unable to purge a record

InnoDB: tuple DATA TUPLE: 3 fields;

 0: len 0; hex ; asc ;;

 1: len 63; hex 373839303137383930315f32303234303232305f44544430365f4630335f34594c57365136576e364357714e4b434c55676255693037343031303639363030; asc 7890178901_20240220_DTD06_F03_4YLW6Q6Wn6CWqNKCLUgbUi07401069600;;

 2: len 24; hex 303032363131303632353237303030303030343139353139; asc 002611062527000000419519;;

InnoDB: record PHYSICAL RECORD: n_fields 3; compact format; info bits 0

 0: len 0; hex ; asc ;;

 1: len 30; hex 373839303137383930315f32303234303232305f44544430365f4630335f; asc 7890178901_20240220_DTD06_F03_; (total 63 bytes);

 2: len 24; hex 303032363131303632353237303030303030343139353139; asc 002611062527000000419519;;

space 2465 offset 43037 (168 records, index id 2034)

InnoDB: Submit a detailed bug report to https://jira.mariadb.org/

2025-02-23  1:15:19 0 [ERROR] InnoDB: Unable to purge a record

InnoDB: tuple DATA TUPLE: 3 fields;

 0: len 3; hex 545250; asc TRP;;

 1: len 62; hex 373839303137383930315f32303234303231395f424f4430305f4630335f68646161433966676677586f76766551634637504a7930373430323133383933; asc 7890178901_20240219_BOD00_F03_hdaaC9fgfwXovveQcF7PJy0740213893;;

 2: len 24; hex 303032363132393532303131303030303030353032393032; asc 002612952011000000502902;;

InnoDB: record PHYSICAL RECORD: n_fields 3; compact format; info bits 0

 0: len 3; hex 545250; asc TRP;;

 1: len 30; hex 373839303137383930315f32303234303231395f424f4430305f4630335f; asc 7890178901_20240219_BOD00_F03_; (total 62 bytes);

 2: len 24; hex 303032363132393532303131303030303030353032393032; asc 002612952011000000502902;;

space 2465 offset 43276 (165 records, index id 2030)

InnoDB: Submit a detailed bug report to https://jira.mariadb.org/

2025-02-23  1:15:19 0 [ERROR] InnoDB: Unable to purge a record

InnoDB: tuple DATA TUPLE: 3 fields;

 0: len 3; hex 545250; asc TRP;;

 1: len 62; hex 373839303137383930315f32303234303231395f424f4430305f4630335f68744350724d6d6a666e3575527032784e415a58777630373430343139343430; asc 7890178901_20240219_BOD00_F03_htCPrMmjfn5uRp2xNAZXwv0740419440;;

 2: len 24; hex 303032363132393532303131303030303030353032393031; asc 002612952011000000502901;;

 space 2465 offset 43276 (165 records, index id 2030)

InnoDB: Submit a detailed bug report to https://jira.mariadb.org/

2025-02-23  1:15:19 0 [ERROR] InnoDB: tried to purge non-delete-marked record in index `IND_CORP_CODE` of table `lms`.`DTD_TXN`: tuple: TUPLE (info_bits=0, 3 fields): {[3]TRP(0x545250),[62]7890178901_20240220_DTD06_F03_eFNgqwATKW8ESWExZ3a5HA0740813600(0x373839303137383930315F32303234303232305F44544430365F4630335F65464E67717741544B573845535745785A336135484130373430383133363030),[24]002611062527000000419448(0x303032363131303632353237303030303030343139343438)}, record: COMPACT RECORD(info_bits=0, 3 fields): {[3]TRP(0x545250),[62]7890178901_20240220_DTD06_F03_eFNgqwATKW8ESWExZ3a5HA0740813600(0x373839303137383930315F32303234303232305F44544430365F4630335F65464E67717741544B573845535745785A336135484130373430383133363030),[24]002611062527000000419448(0x303032363131303632353237303030303030343139343438)}

2025-02-23  1:15:19 0 [ERROR] InnoDB: Flagged corruption of `IND_CORP_CODE` in table `lms`.`DTD_TXN` in purge

No reproducable testcase , yet

Attachments

Activity

Ascending order - Click to sort in descending order

Richard Stracke created issue - 2025-02-25 10:51

Elena Stepanova made changes - 2025-02-25 11:32

Field	Original Value	New Value
Status	Open [ 1 ]	Needs Feedback [ 10501 ]

JiraAutomate made changes - 2025-02-26 06:35

Fix Version/s		10.5 [ 23123 ]
Fix Version/s		10.6 [ 24028 ]

Julien Fritsch made changes - 2025-02-26 07:41

Fix Version/s

10.11 [ 27614 ]

Julien Fritsch made changes - 2025-02-26 07:41

Fix Version/s	10.5 [ 23123 ]
Fix Version/s	10.6 [ 24028 ]

People

Assignee:: Unassigned

Reporter:: Richard Stracke

Votes:: 0 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 2025-02-25 10:51

Updated:: 2025-02-26 07:41

Git Integration

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

MariaDB Server