[MDEV-27976] InnoDB: Clustered record for sec rec not found index Created: 2022-03-01  Updated: 2022-04-03  Resolved: 2022-04-03

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Reteimprese Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: None


 Description   

2022-03-01 18:23:50 12215 [ERROR] InnoDB: Clustered record for sec rec not found index `mapinfo` of table `reteimpr_geo`.`MAPS`
InnoDB: sec index record PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 30; hex 556a6c7859545a764d6c6c4e633051784d7a4254576b77316430356d6254; asc UjlxYTZvMllNc0QxMzBTWkw1d05mbT; (total 204 bytes);
1: len 4; hex 000001c5; asc ;;

InnoDB: clust index record PHYSICAL RECORD: n_fields 1; compact format; info bits 0
0: len 8; hex 696e66696d756d00; asc infimum ;;

TRANSACTION (0x7f03c81c2130), ACTIVE 8 sec starting index read
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
MariaDB thread id 12215, OS thread handle 139515168564992, query id 826157 localhost root Sending data
SELECT * FROM `MAPS` ORDER BY `mapinfo` DESC LIMIT 0, 25

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

 Comments   
Comment by Marko Mäkelä [ 2022-03-01 ]

Which version of MariaDB Server is this?

Does the corruption persist if you rebuild the database from the scratch using innodb_change_buffering=none (MDEV-27734)? Is mapinfo a virtual column?

To only repair this corrupted index, you may try the following:

ALTER TABLE reteimpr_geo.MAPS DROP INDEX mapinfo;
 
ALTER TABLE reteimpr_geo.MAPS ADD INDEX(mapinfo);

Generated at Thu Feb 08 09:57:04 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.