Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.3(EOL)
-
None
-
Linux
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 |
|
Attachments
Issue Links
- relates to
-
-
- Closed
-
-
MDEV-16421 Make system tables crash safe
-
- Closed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Fix Version/s | 10.3 [ 22126 ] | |
| Assignee | Jacob Mathew [ jacob-mathew ] |
| 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 | |
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? {noformat} 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 | {noformat} |
| Link |
This issue relates to |
| Component/s | Authentication and Privilege System [ 13101 ] |
| Fix Version/s | 10.4 [ 22408 ] | |
| Fix Version/s | 10.3 [ 22126 ] |
| Link |
This issue relates to |
| Status | Open [ 1 ] | In Progress [ 3 ] |
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.
| Assignee | Jacob Mathew [ jacob-mathew ] | Kentoku [ kentoku ] |
| Status | In Progress [ 3 ] | In Review [ 10002 ] |
| Status | In Review [ 10002 ] | Stalled [ 10000 ] |
| Assignee | Kentoku [ kentoku ] | Jacob Mathew [ jacob-mathew ] |
| Fix Version/s | 10.4.0 [ 23115 ] | |
| Fix Version/s | 10.4 [ 22408 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Stalled [ 10000 ] | Closed [ 6 ] |
| Workflow | MariaDB v3 [ 87391 ] | MariaDB v4 [ 154406 ] |
| Zendesk Related Tickets | 177946 |
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.