> When trying to upgrade an XtraDB Cluster node from 5.5.24-23.6-log
> to 5.5.27-23.6-log, the mysql_upgrade step is getting stuck at
> "checking
> permissions" for "CREATE TABLE IF NOT EXISTS help_topic ...."

> Upgrade steps are as follows, using a tarball install:

> service mysql stop
> cd /usr/local
> rm mysql (removes soft link to version 5.5.24)
> tar -zxvf Percona-XtraDB-Cluster-5.5.27-23.6.356.Linux.x86_64.tar.gz
> ln -s Percona-XtraDB-Cluster-5.5.27-23.6.356.Linux.x86_64 mysql
> cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
> /usr/local/mysql/bin/mysqld --skip-grant-tables --user=mysql &
> /usr/local/mysql/bin/mysql_upgrade

> Has anyone run into this before in trying to upgrade XtraDB Cluster?

> Thanks
> Patrick

> Hi,

> When trying to upgrade an XtraDB Cluster node from 5.5.24-23.6-log
> to 5.5.27-23.6-log, the mysql_upgrade step is getting stuck at "checking
> permissions" for "CREATE TABLE IF NOT EXISTS help_topic ...."

> Upgrade steps are as follows, using a tarball install:

> service mysql stop
> cd /usr/local
> rm mysql (removes soft link to version 5.5.24)
> tar -zxvf Percona-XtraDB-Cluster-5.5.27-23.6.356.Linux.x86_64.tar.gz
> ln -s Percona-XtraDB-Cluster-5.5.27-23.6.356.Linux.x86_64 mysql
> cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
> /usr/local/mysql/bin/mysqld --skip-grant-tables --user=mysql &
> /usr/local/mysql/bin/mysql_upgrade

> | 67072 | dbadm       | localhost | mysql | Query   |    350 | checking
> permissions | CREATE TABLE IF NOT EXISTS help_topic ( help_topic_id int
> unsigned not null, name char(64) not null, |

> Has anyone run into this before in trying to upgrade XtraDB Cluster?

> Thanks
> Patrick