Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.5(EOL), 10.0(EOL), 10.1(EOL)
Description
I'm not sure on which operation the file was created (assuming mysqloptimize), but assume you have this temp file.
You restart the server.
You can repair this table by hand, everything looks fine. If you have a cron job that does a mysqloptimize -A at nighty, this operation fails, the table is marked as crashed. You get the message "... is marked as crashed and last (automatic?) repair failed" inside the log.
No automatic repair will work. Doing a repair by hand, will work, but will not remove the temp file, as it is not removed by a full server restart.
Attachments
Issue Links
Activity
| Labels | need_feedback |
| Labels | need_feedback |
| Status | Open [ 1 ] | Confirmed [ 10101 ] |
| Component/s | Admin statements [ 11400 ] |
| Affects Version/s | 10.1 [ 16100 ] | |
| Affects Version/s | 10.0 [ 16000 ] | |
| Affects Version/s | 5.5 [ 15800 ] |
| Fix Version/s | 10.1 [ 16100 ] | |
| Fix Version/s | 10.0 [ 16000 ] |
| Assignee | Michael Widenius [ monty ] | |
| Labels | upstream | |
| Priority | Critical [ 2 ] | Major [ 3 ] |
| Status | Confirmed [ 10101 ] | In Progress [ 3 ] |
| Fix Version/s | 10.0.21 [ 19406 ] | |
| Fix Version/s | 10.0 [ 16000 ] | |
| Fix Version/s | 10.1 [ 16100 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | In Progress [ 3 ] | Closed [ 6 ] |
| Resolution | Fixed [ 1 ] | |
| Status | Closed [ 6 ] | Stalled [ 10000 ] |
| Component/s | Storage Engine - Aria [ 10126 ] | |
| Component/s | Storage Engine - MyISAM [ 10600 ] | |
| Fix Version/s | 10.1.6 [ 19401 ] | |
| Fix Version/s | 10.0.21 [ 19406 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Stalled [ 10000 ] | Closed [ 6 ] |
| Link |
This issue includes |
| Link |
This issue includes |
| Workflow | MariaDB v3 [ 70648 ] | MariaDB v4 [ 149377 ] |