# Xtrabackup failing on SHOW GLOBAL VARIABLES

**URL:** <https://forums.percona.com/t/xtrabackup-failing-on-show-global-variables/25206>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [September 15, 2023, 12:46pm UTC](https://forums.percona.com/t/xtrabackup-failing-on-show-global-variables/25206 "2023-09-15T12:46:31Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![crimson\_pirate](https://avatars.discourse-cdn.com/v4/letter/c/a698b9/32.png) [@crimson\_pirate](https://forums.percona.com/u/crimson_pirate)\
**Post date:** [September 15, 2023, 12:46pm UTC](https://forums.percona.com/t/xtrabackup-failing-on-show-global-variables/25206/1 "2023-09-15T12:46:31Z")

</div>

Hello,

We have recently upgraded our Percona XTRADB 5.7 cluster running on rhel7 with the following packages

Percona-XtraDB-Cluster-client-57-5.7.43-31.65.1.el7.x86\_64  
Percona-XtraDB-Cluster-shared-57-5.7.43-31.65.1.el7.x86\_64  
Percona-XtraDB-Cluster-server-57-5.7.43-31.65.1.el7.x86\_64

After the upgrades we started to get the following error when running Xtrabackups:

```auto
Error: failed to fetch query result SHOW GLOBAL VARIABLES LIKE 'wsrep_sync_wait': Native table 'performance_schema'.'global_variables' has the wrong structure

```

When running a query against GLOBAL VARIABLES we get a similiar error

```auto
mysql> show global variables;
ERROR 1682 (HY000): Native table 'performance_schema'.'global_variables' has the wrong structure
mysql>

```

How do we resolve this? I saw a similar bug mentioned in [5.6.17-66.0 performance schema issues](https://forums.percona.com/t/5-6-17-66-0-performance-schema-issues/3544)

---

<div class="post-metadata">

**Author:** ![Ivan\_Groenewold](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ivan_groenewold/32/6299_2.png) [@Ivan\_Groenewold](https://forums.percona.com/u/Ivan_Groenewold)\
**Post date:** [September 15, 2023, 12:54pm UTC](https://forums.percona.com/t/xtrabackup-failing-on-show-global-variables/25206/2 "2023-09-15T12:54:46Z")

</div>

Hi, did you run [mysql\_upgrade](https://dev.mysql.com/doc/refman/5.7/en/mysql-upgrade.html) script as part of your upgrade process? it seems some of the internal tables did not get updated. You will need to run that script and restart the server to fix it.

---

<div class="post-metadata">

**Author:** ![crimson\_pirate](https://avatars.discourse-cdn.com/v4/letter/c/a698b9/32.png) [@crimson\_pirate](https://forums.percona.com/u/crimson_pirate)\
**Post date:** [September 18, 2023, 10:11am UTC](https://forums.percona.com/t/xtrabackup-failing-on-show-global-variables/25206/3 "2023-09-18T10:11:24Z")

</div>

That part seems to have been missed with our yum upgrade. Running mysql\_upgrade on all nodes and restarting them seems to have resolved the issue. thanks