[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

Marko Mäkelä added a comment - 2025-02-25 11:08

If there are no error messages about data page corruption, I don’t think that encryption is relevant for this bug. I don’t see any indexed virtual columns either.

The symptoms match a corruption caused by the InnoDB change buffer, specifically the scenario of ~~MDEV-32132~~, which was originally encountered and fixed as part of ~~MDEV-30009~~. Has innodb_change_buffering ever been enabled on this data directory? If yes, the corruption could have been introduced long before the server had been upgraded to 10.11.

You should be able to fix this corruption by running ALTER TABLE…FORCE or OPTIMIZE TABLE on each affected table. That will also assign a new tablespace ID and thus guarantee that any phantom entries in the change buffer will be detached from the table. Note: the change buffer was removed in MariaDB Server 11 by ~~MDEV-29694~~.

Marko Mäkelä added a comment - 2025-02-25 11:08 If there are no error messages about data page corruption, I don’t think that encryption is relevant for this bug. I don’t see any indexed virtual columns either. The symptoms match a corruption caused by the InnoDB change buffer, specifically the scenario of MDEV-32132 , which was originally encountered and fixed as part of MDEV-30009 . Has innodb_change_buffering ever been enabled on this data directory? If yes, the corruption could have been introduced long before the server had been upgraded to 10.11. You should be able to fix this corruption by running ALTER TABLE…FORCE or OPTIMIZE TABLE on each affected table. That will also assign a new tablespace ID and thus guarantee that any phantom entries in the change buffer will be detached from the table. Note: the change buffer was removed in MariaDB Server 11 by MDEV-29694 .

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.