Upgrade from 5.5 to 5.6

[aaa ppp]

Hi,

I'm experimenting in LAB with cluster upgrade from 5.5 MySQL to 5.6 on Debian 7.

What I did:

1) Created APT repository for codership packages

2) Installed packages   with apt-get

3) Started MySQL server --> sudo mysqld --skip-grant-tables --user=mysql --wsrep-provider='none' &

4) Tried to run upgrade --> sudo mysql_upgrade -u root -p

But system table update is failing with error. No more detailed info.

#####################################

Looking for 'mysql' as: mysql

Looking for 'mysqlcheck' as: mysqlcheck

Error: Failed while fetching Server version! Could be due to unauthorized access.

FATAL ERROR: Upgrade failed

#############################

Maybe, someone knows how to fix it?

Thanks!

[Philip Stoev]

Hello,

The error message indicates that mysql_upgrade is unable to connect to
mysqld . Please see if you can connect to mysqld manually and that you are
able to issue a query such as "show variables like 'version'"

Philip Stoev

--
You received this message because you are subscribed to the Google Groups
"codership" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to codership-tea...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[aaa ppp]

Found problem! I forget to comment out this setting in my.cnf file --> #engine-condition-pushdown=1.

After commented out this setting upgrade was runned smoothly and galera was upgraded. :)

Thanks.