[MDEV-8572] corrupted table and stale .TMM file during optimize - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Duplicate
Affects Version/s: 10.0.19
Fix Version/s: N/A
Component/s: Admin statements, Storage Engine - Aria, Storage Engine - MyISAM
Labels:
None
Environment:
Linux CentOS release 6.4 (Final) on Rhev 3.3 Vm

Description

Hi,
we migrated all db server form mysql 5.1 to mariadb 10.0.19 and now we found randomly after optimize of all dbs weekly with command
mysqlcheck --auto-repair --flush -Ao
we find a corrupted myisam tables (before optimize we are sure that tables are ok because no log is present in optimize log that warn about problem on table) and a relative .tmm file.
We have to delete .tmm file and repair the table because if mysqlcheck pass skip this tables
Thank you very much

Attachments

Activity

People

Assignee:: Unassigned

Reporter:: Fustini

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2015-08-05 16:13

Updated:: 2015-08-06 17:34

Resolved:: 2015-08-06 17:34

Git Integration

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