Uploaded image for project: 'Red Hat 3scale API Management'
  1. Red Hat 3scale API Management
  2. THREESCALE-10216

When upgrading from 2.11 to 2.12 system-mysql could fail if "lost+found" directory exists into data

XMLWordPrintable

    • False
    • None
    • False
    • Not Started
    • Not Started
    • Not Started
    • Not Started
    • Not Started
    • Not Started

      When upgrading 3scale from a version using MySQL 5.7 to another version using MySQL 8.0 and there's a `lost+found` directory into `/var/lib/mysql/data`, MySQL will fail to upgrade.

      The workaround is simple, just remove this directory and if the upgrade doesn't proceed, remove the `system-mysql` deployment config to force the Operator to deploy a new one.

      In MySQL 5.7 we have:

      $ oc rsh dc/system-mysql cat /etc/opt/rh/rh-mysql57/my.cnf.d/10-mysql57.cnf
      [mysqld]
      
      # http://www.chriscalender.com/ignoring-the-lostfound-directory-in-your-datadir/
      ignore-db-dir=lost+found

      But in MySQL 8.0 we don't have any configuration with `ignore-db-dir=lost+found` directive.

            Unassigned Unassigned
            rhn-support-eazevedo Ernani Azevedo
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: