# Problems After Upgrade to 5.6 **URL:** \ **Category:** Other MySQL® Questions\ **Created:** [March 25, 2014, 7:12am UTC](https://forums.percona.com/t/problems-after-upgrade-to-5-6/3359 "2014-03-25T07:12:28Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![iAnathema](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ianathema/32/1002_2.png) [@iAnathema](https://forums.percona.com/u/iAnathema)\ **Post date:** [March 25, 2014, 7:12am UTC](https://forums.percona.com/t/problems-after-upgrade-to-5-6/3359/1 "2014-03-25T07:12:28Z")
I had problems after upgrading to version 5.6 This is Error Log: 140325 13:29:40 mysqld\_safe Starting mysqld daemon with databases from /var/lib/mysql/ 140325 13:29:40 [ERROR] Can’t find messagefile ‘/usr/share/percona-server/errmsg.sys’ 140325 13:29:40 [Note] Plugin ‘FEDERATED’ is disabled. 140325 13:29:40 InnoDB: The InnoDB memory heap is disabled 140325 13:29:40 InnoDB: Mutexes and rw\_locks use GCC atomic builtins 140325 13:29:40 InnoDB: Compressed tables use zlib 1.2.3.4 140325 13:29:40 InnoDB: Using Linux native AIO 140325 13:29:40 InnoDB: Initializing buffer pool, size = 1.0G 140325 13:29:40 InnoDB: Completed initialization of buffer pool 140325 13:29:40 InnoDB: highest supported file format is Barracuda. 140325 13:29:41 InnoDB: Waiting for the background threads to start 140325 13:29:41 InnoDB: Warning: table ‘mysql/innodb\_index\_stats’ InnoDB: in InnoDB data dictionary has unknown flags 50. 140325 13:29:42 InnoDB: Warning: table ‘mysql/innodb\_table\_stats’ InnoDB: in InnoDB data dictionary has unknown flags 50. 140325 13:29:42 Percona XtraDB ([http://www.percona.com](http://www.percona.com)) 5.5.36-34.1-34.1 started; log sequence number 26926465548 140325 13:29:42 [ERROR] Aborting 140325 13:29:42 InnoDB: Starting shutdown… 140325 13:29:47 InnoDB: Shutdown completed; log sequence number 26926465548 140325 13:29:47 [Note] 140325 13:29:47 mysqld\_safe mysqld from pid file /var/lib/mysql/mysql.pid ended After downgrade to previous version, the problem persists. Ubuntu 12.04. my.cnf # Generated by Percona Configuration Wizard ([http://tools.percona.com/](http://tools.percona.com/)) version REL5-20120208 [mysql] # CLIENT port = 3306 socket = /var/lib/mysql/mysql.sock [mysqld] # GENERAL user = mysql default-storage-engine = InnoDB pid-file = /var/lib/mysql/mysql.pid # MyISAM key-buffer-size = 32M myisam-recover-options = FORCE,BACKUP # SAFETY max-allowed-packet = 16M max-connect-errors = 1000000 # DATA STORAGE datadir = /var/lib/mysql/ # BINARY LOGGING log-bin = /var/lib/mysql/mysql-bin expire-logs-days = 7 sync-binlog = 1 # CACHES AND LIMITS tmp-table-size = 32M max-heap-table-size = 32M query-cache-type = 1 query-cache-size = 64M max-connections = 100 thread-cache-size = 16 open-files-limit = 65535 table-definition-cache = 4096 table-open-cache = 4096 # INNODB innodb-flush-method = O\_DIRECT innodb-log-files-in-group = 2 innodb-log-file-size = 128M innodb-flush-log-at-trx-commit = 1 innodb-file-per-table = 1 innodb-buffer-pool-size = 1G # LOGGING log-error = /var/lib/mysql/mysql-error.log log-queries-not-using-indexes = 1 slow-query-log = 1 slow-query-log-file = /var/lib/mysql/mysql-slow.log ---
**Author:** ![niljoshi](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/niljoshi/32/16889_2.png) [@niljoshi](https://forums.percona.com/u/niljoshi)\ **Post date:** [March 31, 2014, 7:13am UTC](https://forums.percona.com/t/problems-after-upgrade-to-5-6/3359/2 "2014-03-31T07:13:28Z")
Hi, Can you provide the steps how you have upgraded the server? After upgrade to 5.6, have you run mysql\_upgrade? can you provide mysql\_upgrade log? ---
**Author:** ![borice](https://avatars.discourse-cdn.com/v4/letter/b/7feea3/32.png) [@borice](https://forums.percona.com/u/borice)\ **Post date:** [April 1, 2014, 4:59pm UTC](https://forums.percona.com/t/problems-after-upgrade-to-5-6/3359/3 "2014-04-01T16:59:51Z")
Hi, I am seeing the same message in the MySQL log: > [@](#): > > 2014-04-01 17:16:03 7f4b758d1700 InnoDB: Warning: table ‘mysql/innodb\_index\_stats’ > InnoDB: in InnoDB data dictionary has unknown flags 50. > 2014-04-01 17:16:03 7f4b758d1700 InnoDB: Warning: table ‘mysql/innodb\_table\_stats’ > InnoDB: in InnoDB data dictionary has unknown flags 50. I was using the Codership version of MySQL 5.6 (with Galera) and decided to switch to XtraDB cluster… Before installing XtraDB from the Percona APT repository, I made sure to remove all the previous mysql and galera packages from the system. After installing XtraDB, those warning messages started appearing in the log. The database seems to otherwise be fine… I have tried running the mysql\_upgrade, and it completed successfully, with no error or warning being shown on the console (but that didn’t fix the warnings from the logs). What are these warnings? I can’t seem to find any info about what they mean… Thanks for your help! -Boris ---
**Author:** ![niljoshi](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/niljoshi/32/16889_2.png) [@niljoshi](https://forums.percona.com/u/niljoshi)\ **Post date:** [April 2, 2014, 8:30am UTC](https://forums.percona.com/t/problems-after-upgrade-to-5-6/3359/4 "2014-04-02T08:30:08Z")
Hi, So currently which version you are using? 5.5 or 5.6? You issue might be related to this but I’m not sure. [url][MySQL Bugs: #67179: mysql system tables innodb\_table\_stats,slave\_master\_info not accessible on clean](http://bugs.mysql.com/bug.php?id=67179%5B/url%5D) Can you give me the steps how it can be repeatable? if you have better test case then I would suggest to file a bug. [url][https://bugs.launchpad.net/percona-xtradb-cluster/[/url]](https://bugs.launchpad.net/percona-xtradb-cluster/%5B/url%5D) ---
**Author:** ![nekatreven](https://avatars.discourse-cdn.com/v4/letter/n/a6a055/32.png) [@nekatreven](https://forums.percona.com/u/nekatreven)\ **Post date:** [April 4, 2014, 5:38pm UTC](https://forums.percona.com/t/problems-after-upgrade-to-5-6/3359/5 "2014-04-04T17:38:09Z")
[url][https://bugs.launchpad.net/percona-server/+bug/1302882[/url]](https://bugs.launchpad.net/percona-server/+bug/1302882%5B/url%5D)