[MDEV-16250] Spider system tables are MyISAM and needs repair after a crash Created: 2018-05-22  Updated: 2020-08-25  Resolved: 2018-08-28

Status: Closed
Project: MariaDB Server
Component/s: Authentication and Privilege System, Storage Engine - Spider
Affects Version/s: 10.3
Fix Version/s: 10.4.0

Type: Bug Priority: Major
Reporter: Mattias Jonsson Assignee: Jacob Mathew (Inactive)
Resolution: Fixed Votes: 0
Labels: None
Environment:

Linux

Issue Links:
Relates
relates to MDEV-17068 mysql system table is marked as crash... Closed
relates to MDEV-16421 Make system tables crash safe Closed

 Description   

If a crash occurs during the use of a spider table, the system tables for spiders needs to be repaired.

Maybe the system tables for spider should be crash safe?

show warnings;
 
+-------+-------+------------------------------------------------------------------------------+
 
| Level | Code  | Message                                                                      |
 
+-------+-------+------------------------------------------------------------------------------+
 
| Error |   145 | Table './mysql/spider_tables' is marked as crashed and should be repaired    |
 
| Error |  1034 | 1 client is using or hasn't closed the table properly                        |
 
| Error |   145 | Table './mysql/spider_table_sts' is marked as crashed and should be repaired |
 
| Error |  1034 | 1 client is using or hasn't closed the table properly                        |
 
| Error |   145 | Table './mysql/spider_table_crd' is marked as crashed and should be repaired |



 Comments   
Comment by Jacob Mathew (Inactive) [ 2018-08-20 ]

The standard system tables in the mysql database that use MyISAM are being converted to transactional Aria tables in 10.4.0, via the related task MDEV-16421. That is therefore the best time for the Spider system tables to be converted as well to transactional Aria tables.

Comment by Jacob Mathew (Inactive) [ 2018-08-27 ]

During a server restart that follows a server crash, there may be error messages that indicate that certain system tables, including Spider system tables, are marked as crashed and may be corrupted. Upon checking the
system tables that are marked as crashed, it may be found that there is no corruption that needs repair. However, the error messages that are issued imply that the user needs to nevertheless manually repair the system tables that were marked as crashed. These issues have been moved to a separate bug MDEV-17068.

MDEV-16250 addresses the work to make the Spider system tables crash safe in 10.4 by using the Aria storage engine.

Comment by Jacob Mathew (Inactive) [ 2018-08-27 ]

Kentoku, please review my fix in commit 73fac2a on my branch.

Comment by Kentoku Shiba (Inactive) [ 2018-08-28 ]

It's ok to push. Thanks.

Comment by Jacob Mathew (Inactive) [ 2018-08-28 ]

Fix is pushed to 10.4.

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