Bug #68783 | Mysql crashes and continues to respawn and crash again | ||
---|---|---|---|
Submitted: | 26 Mar 2013 17:39 | Modified: | 15 Apr 2013 5:46 |
Reporter: | Aram Mirzadeh | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: Installing | Severity: | S1 (Critical) |
Version: | 5.6.10 | OS: | Linux (CentOS 6.4 64bit) |
Assigned to: | CPU Architecture: | Any |
[26 Mar 2013 17:39]
Aram Mirzadeh
[27 Mar 2013 6:53]
MySQL Verification Team
Hello Aram, Thank you for the report. Can you start server with "skip-grant-tables" in the my.cnf and show us the structure of the mysql.user table? Regards, Umesh
[27 Mar 2013 8:43]
Aram Mirzadeh
mysql> desc user; +-----------------------+-----------------------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------------+-----------------------------------+------+-----+---------+-------+ | Host | char(60) | NO | PRI | | | | User | char(16) | NO | PRI | | | | Password | char(41) | NO | | | | | Select_priv | enum('N','Y') | NO | | N | | | Insert_priv | enum('N','Y') | NO | | N | | | Update_priv | enum('N','Y') | NO | | N | | | Delete_priv | enum('N','Y') | NO | | N | | | Create_priv | enum('N','Y') | NO | | N | | | Drop_priv | enum('N','Y') | NO | | N | | | Reload_priv | enum('N','Y') | NO | | N | | | Shutdown_priv | enum('N','Y') | NO | | N | | | Process_priv | enum('N','Y') | NO | | N | | | File_priv | enum('N','Y') | NO | | N | | | Grant_priv | enum('N','Y') | NO | | N | | | References_priv | enum('N','Y') | NO | | N | | | Index_priv | enum('N','Y') | NO | | N | | | Alter_priv | enum('N','Y') | NO | | N | | | Show_db_priv | enum('N','Y') | NO | | N | | | Super_priv | enum('N','Y') | NO | | N | | | Create_tmp_table_priv | enum('N','Y') | NO | | N | | | Lock_tables_priv | enum('N','Y') | NO | | N | | | Execute_priv | enum('N','Y') | NO | | N | | | Repl_slave_priv | enum('N','Y') | NO | | N | | | Repl_client_priv | enum('N','Y') | NO | | N | | | Create_view_priv | enum('N','Y') | NO | | N | | | Show_view_priv | enum('N','Y') | NO | | N | | | Create_routine_priv | enum('N','Y') | NO | | N | | | Alter_routine_priv | enum('N','Y') | NO | | N | | | Create_user_priv | enum('N','Y') | NO | | N | | | ssl_type | enum('','ANY','X509','SPECIFIED') | NO | | | | | ssl_cipher | blob | NO | | NULL | | | x509_issuer | blob | NO | | NULL | | | x509_subject | blob | NO | | NULL | | | max_questions | int(11) unsigned | NO | | 0 | | | max_updates | int(11) unsigned | NO | | 0 | | | max_connections | int(11) unsigned | NO | | 0 | | | max_user_connections | int(11) unsigned | NO | | 0 | | +-----------------------+-----------------------------------+------+-----+---------+-------+ 37 rows in set (0.00 sec)
[29 Mar 2013 12:41]
MySQL Verification Team
Thank you for the details. Looks like grant tables are messed up, probably a upgrade from 5.0 or something.The user table column counts matches with that of 5.0 version, How did you upgrade? mysql_upgrade should be executed each time you upgrade MySQL.. 5.0 user table - http://dev.mysql.com/doc/refman/5.0/en/grant-table-structure.html 5.6 user table - http://dev.mysql.com/doc/refman/5.6/en/grant-table-structure.html
[29 Mar 2013 20:30]
Aram Mirzadeh
mysqldump each database (including mysql) from source mysql < sql on new server mysql_upgrade
[15 Apr 2013 5:46]
MySQL Verification Team
Hello Aram, It seems that you are trying to upgrade from 5.0 to 5.6 and official documentation says (http://dev.mysql.com/doc/refman/5.6/en/upgrading.html) : "As a general rule, to upgrade from one release series to another, go to the next series rather than skipping a series. To upgrade from a release series previous to MySQL 5.5, upgrade to each successive release series in turn until you have reached MySQL 5.5, and then proceed with the upgrade to MySQL 5.6.". You are skipping couple of versions here in between. This issue has been identified by my senior colleague and reported in internal BugDB 16343542 This issue is observed if you start up 5.6.x and point it to a datadir containing system tables from 5.0.x, it just crashes.