[MDEV-12936] upgrade to 10.2.6 failed upon tables with virtual columns - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Blocker
Resolution: Fixed
Affects Version/s: 10.2.6, 10.2(EOL)
Fix Version/s: 10.2.7
Component/s: Server, Virtual Columns
Labels:
None
Environment:
centos 7.3

Description

2 types of errors on mysql_upgrade from 10.1.23 to 10.2.6

1/
jbm.conf_client_settings
Error : Function or expression 'AUTO_INCREMENT' cannot be used in the UNTYPED clause of `pk`
error : Corrupt

2/
jbm_adobe_campaign.bl_kpi_demo
Error : Table 'jbm_adobe_campaign.bl_kpi_demo' doesn't exist in engine
status : Operation failed

tail -100 /var/log/mysql_errors.log 2017-05-27 20:51:04 139656884177152 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2017-05-27 20:51:04 139656884177152 [Note] Plugin 'FEEDBACK' is disabled.
2017-05-27 20:51:04 139656884177152 [ERROR] Unknown/unsupported storage engine: InnoDB
2017-05-27 20:51:04 139656884177152 [ERROR] Aborting

Attachments

Issue Links

relates to

MDEV-13320 virtual columns fail when expression references auto increment column

Closed

MDEV-17199 Assertion `pos < table->n_v_def' failed in dict_table_get_nth_v_col after upgrade from 10.1/10.0 to 10.2

Closed

Activity

People

Assignee:: Sergei Golubchik

Reporter:: Pascal HOARAU

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2017-05-27 19:27

Updated:: 2018-12-20 07:06

Resolved:: 2017-07-05 15:22

Git Integration

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