Uploaded image for project: 'Percona XtraDB Cluster'
  1. Percona XtraDB Cluster
  2. PXC-3366

Issues with MySQL upgrade from PXC 5.7 to PXC 8.0

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Priority: High
    • Resolution: Unresolved
    • Affects Version/s: 8.0.19-10
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Environment:

      Production

      Description

      I have setup a Percona XtraDB Cluster in 5.7 version and trying to upgrade to 8.0. I was trying to upgrade one node to 8.0 by swapping the Binaries from 5.7 to 8.0 and also XtraBackup from 2.4 to 8.0.

      I tried to restart the node using 8.0 binaries and the node started up and from the logs I see the upgrade was successfully as well. But when I login to upgraded node, show global variables and show global status does not return any result set even though if I manually select the variable using select @@variaable_name I get those values. Other than that the node looks operational and Galera replication is also working fine. 

      However, when I run xtrabackup to backup the DB's on the upgraded node, I get a error shown below. Because of this I am not able to upgrade the full cluster as when the newly upgraded node becomes the DONOR it fails to upgrade the other nodes and keep up with the cluster.

      "xtrabackup got signal 11 ; this could be because you hit a bug or data is corrupted. this error can also be caused by malfunctioning hardware. attempting to collect some information that could help diagnose the problem"

      This is impacting production and am stuck with this since almost a week.

        Attachments

        1. Xtrabackup_log.rtf
          4 kB
        2. error_log_snippet.rtf
          9 kB
        3. 80_mycnf.rtf
          5 kB
        4. pxc57_to_pxc8_upgrade
          17 kB
        5. PXC-3366_pxc57_pxc08_upgrade.test
          28 kB
        6. node2_my.cnf
          0.9 kB
        7. node1.my.cnf
          1 kB
        8. node3_pxc80_my.cnf
          1 kB
        9. my.cnf
          5 kB
        10. my.cnf
          5 kB
        11. pxc5730_my.cnf
          2 kB
        12. pxc8019_my.cnf
          2 kB
        13. pxc57_80_upgrade_mysql_1st_startup.log
          16 kB
        14. xtrabk_fails_for_pxc80.log
          3 kB

          Issue Links

            Activity

              People

              Assignee:
              zsolt.parragi Zsolt Parragi
              Reporter:
              bv.sunny Venkata Srinivas Bavirisetty
              Votes:
              1 Vote for this issue
              Watchers:
              7 Start watching this issue

                Dates

                Created:
                Updated:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - Not Specified
                  Not Specified
                  Logged:
                  Time Spent - 2 days, 2 hours
                  2d 2h

                    Smart Checklist