[MDEV-6199] mysql_upgrade causes errors after MariaDB 5.5 to 10.0 upgrade - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Minor
Resolution: Not a Bug
Affects Version/s: 10.0.10
Fix Version/s: N/A
Component/s: Storage Engine - InnoDB
Labels:
- upstream
Environment:
RHEL5,Linux

Description

Running mysql_upgrade after a 5.5 to 10.0 upgrade causes lots of notices in the errorlog (one per table), below is one example:

2014-05-02 14:29:34 2ba01e3bb940 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.

2014-05-02 14:29:34 2ba01e3bb940 InnoDB: Error: Fetch of persistent statistics requested for table "db"."tbl" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.

Suggested fix:
I reckon that the mysql system tables should be upgraded first, before any other databases.

Attachments

Activity

People

Assignee:: Unassigned

Reporter:: Arjen Lentz

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2014-05-02 07:35

Updated:: 2015-04-03 17:14

Resolved:: 2015-04-03 17:14

Git Integration

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