Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-12936

upgrade to 10.2.6 failed upon tables with virtual columns

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 10.2, 10.2.6
    • 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

            Activity

              People

              • Assignee:
                serg Sergei Golubchik
                Reporter:
                Pascal Pascal HOARAU
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: