[MDEV-17068] mysql system table is marked as crashed and should be repaired after the server crashes or is killed Created: 2018-08-24 Updated: 2018-08-28 Resolved: 2018-08-28 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Server |
| Affects Version/s: | 10.3 |
| Fix Version/s: | 10.4.0 |
| Type: | Bug | Priority: | Major |
| Reporter: | Jacob Mathew (Inactive) | Assignee: | Michael Widenius |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Issue Links: |
|
||||||||
| Description |
|
The problem can be reproduced by creating a table that uses the Spider storage engine. The problem only involves the Spider node, so only that single node is needed to reproduce the problem. Start with an empty environment and set up the server as follows:
Install Spider as follows:
Execute the following SQL statements:
Kill the server and then restart it. In the event log, you will notice error messages like the following during the restart:
There are no messages that indicate that these system tables are automatically repaired. If you then kill and restart the server a second time, then no such error messages appear in the event log during the second restart. That might indicate the the system tables were in fact automatically repaired, but there are no messages regarding their automatic repair. I have also seen this problem reported on Spider system tables. However, with the current 10.3 code, the problem is reported most often on the mysql.servers and/or the mysql.func system tables. |
| Comments |
| Comment by Michael Widenius [ 2018-08-27 ] |
|
The mesage |
| Comment by Michael Widenius [ 2018-08-28 ] |
|