[MDEV-13937] Aria engine: Internal Error 160 after partition handling - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Affects Version/s: 10.2.6, 10.2.8, 5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL)
Fix Version/s: 5.5.58, 10.0.33, 10.1.29, 10.2.10
Component/s: Partitioning, Storage Engine - Aria
Labels:
- aria
- partitioning
Environment:
Windows 10 Home 64bit

Sprint:
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

People

Assignee:: Sergei Golubchik

Reporter:: Andy Middleton

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2017-09-28 11:23

Updated:: 2017-10-17 06:02

Resolved:: 2017-10-17 06:02

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.