Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.2.6, 10.2.8, 5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL)
-
Windows 10 Home 64bit
-
10.2.10, 5.5.58
Description
Partitions get corrupted: internal error 160.
Unable to repair (with Alter table).
Symptom: The AutoIncrement value goes wild (from a few thousand, to numbers with 20+ digits).
Viewing an allegedly uncorrupted partition shows extremely distorted data.
Fault appears to follow adding a new partition (partitions by date) although the new
partition is for a future date, so not yet used.
Only fix discovered, so far, is to drop the table.
Not yet isolated the exact trigger.
Tables schema: ARIA ROW_FORMAT=PAGE TRANSACTIONAL=1 PAGE_CHECKSUM=1
(FYI: same application code using MyISAM does not fail)
What causes internal error 160?
Attachments
Activity
| Field | Original Value | New Value |
|---|---|---|
| Affects Version/s | 10.2.8 [ 22544 ] |
| Labels | aria partitioning | aria need_feedback partitioning |
| Labels | aria need_feedback partitioning | aria partitioning |
| Fix Version/s | 5.5 [ 15800 ] | |
| Fix Version/s | 10.0 [ 16000 ] | |
| Fix Version/s | 10.1 [ 16100 ] | |
| Fix Version/s | 10.2 [ 14601 ] | |
| Affects Version/s | 5.5 [ 15800 ] | |
| Affects Version/s | 10.0 [ 16000 ] | |
| Affects Version/s | 10.1 [ 16100 ] | |
| Affects Version/s | 10.2 [ 14601 ] | |
| Assignee | Sergei Golubchik [ serg ] |
| Status | Open [ 1 ] | Confirmed [ 10101 ] |
| Sprint | 10.2.10 [ 183 ] |
| Status | Confirmed [ 10101 ] | In Progress [ 3 ] |
| Status | In Progress [ 3 ] | Stalled [ 10000 ] |
| Sprint | 10.2.10 [ 183 ] | 10.2.10, 5.5.58 [ 183, 197 ] |
| Fix Version/s | 5.5.58 [ 22540 ] | |
| Fix Version/s | 10.0.33 [ 22552 ] | |
| Fix Version/s | 10.1.29 [ 22636 ] | |
| Fix Version/s | 10.2.10 [ 22615 ] | |
| Fix Version/s | 10.2 [ 14601 ] | |
| Fix Version/s | 5.5 [ 15800 ] | |
| Fix Version/s | 10.0 [ 16000 ] | |
| Fix Version/s | 10.1 [ 16100 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Stalled [ 10000 ] | Closed [ 6 ] |
| Workflow | MariaDB v3 [ 82831 ] | MariaDB v4 [ 152905 ] |