Re: Upgrading XtraDB Cluster from 5.5.23 to 5.5.27 - checking permissions issue

[Alex Yurchenko]

On 2012-09-20 17:49, Patrick wrote:
> 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

This is just a guess, but perhaps you should add --wsrep_provider=none
to mysqld command line options there...

> | 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

--
Alexey Yurchenko,
Codership Oy, www.codership.com
Skype: alexey.yurchenko, Phone: +358-400-516-011

[Patrick]

Thanks Alexy - --wsrep_provider=none did the trick.

Patrick

On Thursday, September 20, 2012 10:49:30 AM UTC-4, Patrick wrote:

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