MySQL Forums
Forum List  »  InnoDB

InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
Posted by: Jyothi hc
Date: February 06, 2013 01:47AM

Hi,

I took backup of database using mysqldump version 5.0.45 and restore the same database in mysql 5.6.9. I am getting the following error in mysql.err

130205 18:50:00 mysqld_safe mysqld from pid file /var/lib/mysql/Digitally_Upgraded_K12.pid ended
130206 11:38:06 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2013-02-06 11:38:09 0 [Warning] option 'max_allowed_packet': unsigned value 2147483648 adjusted to 1073741824
2013-02-06 11:38:09 0 [Warning] option 'max_allowed_packet': unsigned value 2147483648 adjusted to 1073741824
2013-02-06 11:38:09 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2013-02-06 11:38:09 2507 [Note] Plugin 'FEDERATED' is disabled.
2013-02-06 11:38:09 2507 [Warning] /usr/sbin/mysqld: ignoring option '--innodb-doublewrite' due to invalid value 'OFF'
2013-02-06 11:38:09 2507 [Warning] /usr/sbin/mysqld: ignoring option '--innodb-doublewrite' due to invalid value 'OFF'
2013-02-06 11:38:09 b77528e0 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2013-02-06 11:38:09 b77528e0 InnoDB: Warning: Setting innodb_checksums to OFF is DEPRECATED. This option may be removed in future releases. You should set innodb_checksum_algorithm=NONE instead.
2013-02-06 11:38:09 2507 [Note] InnoDB: The InnoDB memory heap is disabled
2013-02-06 11:38:09 2507 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2013-02-06 11:38:09 2507 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-02-06 11:38:09 2507 [Note] InnoDB: CPU does not support crc32 instructions
2013-02-06 11:38:09 2507 [Note] InnoDB: Using Linux native AIO
2013-02-06 11:38:09 2507 [Note] InnoDB: Initializing buffer pool, size = 256.0M
2013-02-06 11:38:09 2507 [Note] InnoDB: Completed initialization of buffer pool
2013-02-06 11:38:09 2507 [Note] InnoDB: Highest supported file format is Barracuda.
2013-02-06 11:38:11 2507 [Note] InnoDB: 128 rollback segment(s) are active.
2013-02-06 11:38:11 2507 [Note] InnoDB: Waiting for purge to start
2013-02-06 11:38:11 2507 [Note] InnoDB: 1.2.9 started; log sequence number 101558619
2013-02-06 11:38:11 2507 [Note] Server hostname (bind-address): '*'; port: 3306
2013-02-06 11:38:11 2507 [Note] IPv6 is available.
2013-02-06 11:38:11 2507 [Note] - '::' resolves to '::';
2013-02-06 11:38:11 2507 [Note] Server socket created on IP: '::'.
2013-02-06 11:38:12 2507 [Note] Event Scheduler: Loaded 0 events
2013-02-06 11:38:12 2507 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.9-rc-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
2013-02-06 11:40:13 99bffb70 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2013-02-06 11:40:13 99bffb70 InnoDB: Error: Fetch of persistent statistics requested for table "db"."table1" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
2013-02-06 11:40:13 99bceb70 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2013-02-06 11:40:13 99bceb70 table2: Error: Fetch of persistent statistics requested for table "db"."tbl_file_master" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
2013-02-06 11:40:14 99bffb70 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2013-02-06 11:40:14 99bffb70 InnoDB: Error: Fetch of persistent statistics requested for table "institution_content_master"."tbl_object_map_summary" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
2013-02-06 11:40:14 99bceb70 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.



And after restarting the VM, Mysql is crashing.. Any help appreciated.

Options: ReplyQuote


Subject
Views
Written By
Posted
InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
47054
February 06, 2013 01:47AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.