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


    • Bug
    • Status: Open
    • High
    • Resolution: Unresolved
    • 8.0.19-10
    • None
    • None
    • None
    • Production


      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.


        1. 80_mycnf.rtf
          5 kB
        2. error_log_snippet.rtf
          9 kB
        3. image-2021-05-06-15-12-20-040.png
          375 kB
        4. image-2021-05-06-15-12-22-824.png
          375 kB
        5. my.cnf
          5 kB
        6. my.cnf
          5 kB
        7. node1.my.cnf
          1 kB
        8. node2_my.cnf
          0.9 kB
        9. node3_pxc80_my.cnf
          1 kB
        10. PXC-3366_pxc57_pxc08_upgrade.test
          28 kB
        11. pxc57_80_upgrade_mysql_1st_startup.log
          16 kB
        12. pxc57_to_pxc8_upgrade
          17 kB
        13. pxc5730_my.cnf
          2 kB
        14. pxc8019_my.cnf
          2 kB
        15. Xtrabackup_log.rtf
          4 kB
        16. xtrabk_fails_for_pxc80.log
          3 kB

        Issue Links



              zsolt.parragi Zsolt Parragi
              bv.sunny Venkata Srinivas Bavirisetty
              1 Vote for this issue
              7 Start watching this issue



                Time Tracking

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

                  Smart Checklist