[MDEV-29391] Index and data corruption Created: 2022-08-26  Updated: 2023-11-28

Status: Open
Project: MariaDB Server
Component/s: Data Manipulation - Insert, Storage Engine - Aria
Affects Version/s: 10.6.9
Fix Version/s: 10.6

Type: Bug Priority: Major
Reporter: Massimo Ciurleo Assignee: Michael Widenius
Resolution: Unresolved Votes: 0
Labels: crash
Environment:

Windows 10 and Windows Server 2019


Attachments: Text File log_create.txt     File log_err.err    
Issue Links:
Relates
relates to MDEV-16659 Assertion `anc_page->org_size == anc_... Stalled

 Description   

Good morning,
we have an error during insert.
We currently use version 10.5.13 and this problem does not occur.
Any later version crashes when the number of entries exceeds 100.
Our programs are written in VisualFoxpro 9 and we use MySql ODBC 5.1 Driver.
We used clean PCs (no MariaDB and ODBC installed).
The tables were populated with "LOAD DATA".
One of the tables that fails contains 9,787,650 rows for 6.3 Gb



 Comments   
Comment by Marko Mäkelä [ 2022-08-26 ]

The messages in log_err.err are pointing to ENGINE=Aria. A crash occurs during the execution of a DELETE statement:

mariadb-10.6.9

Version: '10.6.9-MariaDB'  socket: ''  port: 3306  mariadb.org binary distribution
2022-08-22 16:43:47 17 [ERROR] mysqld.exe: Table '.\app_gioiaspa_bfs_btob\ga_ag010__artesi' is marked as crashed and should be repaired
2022-08-22 16:43:47 17 [Warning] Checking table:   '.\app_gioiaspa_bfs_btob\ga_ag010__artesi'
2022-08-22 16:43:49 17 [ERROR] mysqld.exe: Table '.\app_gioiaspa_bfs_btob\ga_ag010__fatacc' is marked as crashed and should be repaired
2022-08-22 16:43:49 17 [Warning] Checking table:   '.\app_gioiaspa_bfs_btob\ga_ag010__fatacc'
2022-08-22 16:43:49 17 [ERROR] mysqld.exe: Table '.\app_gioiaspa_bfs_btob\ga_ag010__fatadd' is marked as crashed and should be repaired
2022-08-22 16:46:53 18 [ERROR] mysqld.exe: Got error '126 "Index is corrupted"' for '.\app_gioiaspa_bfs\app_1_movart.MAI'
220822 16:46:53 [ERROR] mysqld got exception 0xc0000005 ;
server.dll!my_free()[my_malloc.c:200]
server.dll!d_search()[ma_delete.c:529]
server.dll!d_search()[ma_delete.c:423]
server.dll!d_search()[ma_delete.c:423]
server.dll!_ma_ck_real_delete()[ma_delete.c:235]
server.dll!_ma_ck_delete()[ma_delete.c:184]
server.dll!maria_delete()[ma_delete.c:88]
server.dll!handler::ha_delete_row()[handler.cc:7714]
Query (0x17599d0d2de): DELETE  QUICK  FROM APP_GIOIASPA_BFS.APP_1_MOVART WHERE _ID_MOVART=9.77808400000000000e+006 

Generated at Thu Feb 08 10:08:13 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.