mysql error

Problems with the Windows version of XAMPP, questions, comments, and anything related.

mysql error

Postby cheposki » 23. May 2014 18:50

hi i have problem with mysql, he active and then go off this is my log please help

2014-05-23 12:42:46 812 [Note] Server socket created on IP: '::'.
2014-05-23 12:42:46 812 [Warning] InnoDB: Cannot open table mysql/slave_master_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2014-05-23 12:42:46 812 [Warning] Info table is not ready to be used. Table 'mysql.slave_master_info' cannot be opened.
2014-05-23 12:42:46 812 [Warning] InnoDB: Cannot open table mysql/slave_worker_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2014-05-23 12:42:46 812 [Warning] InnoDB: Cannot open table mysql/slave_relay_log_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2014-05-23 12:42:46 812 [Warning] Info table is not ready to be used. Table 'mysql.slave_relay_log_info' cannot be opened.
2014-05-23 12:42:46 812 [ERROR] Column count of mysql.events_waits_current is wrong. Expected 19, found 16. Created with MySQL 50525, now running 50616. Please use mysql_upgrade to fix this error.
2014-05-23 12:42:46 812 [ERROR] Column count of mysql.events_waits_history is wrong. Expected 19, found 16. Created with MySQL 50525, now running 50616. Please use mysql_upgrade to fix this error.
2014-05-23 12:42:46 812 [ERROR] Column count of mysql.events_waits_history_long is wrong. Expected 19, found 16. Created with MySQL 50525, now running 50616. Please use mysql_upgrade to fix this error.
2014-05-23 12:42:46 812 [ERROR] Incorrect definition of table performance_schema.events_waits_summary_by_thread_by_event_name: expected column 'THREAD_ID' at position 0 to have type bigint(20), found type int(11).
2014-05-23 12:42:46 812 [ERROR] Column count of mysql.file_summary_by_event_name is wrong. Expected 23, found 5. Created with MySQL 50525, now running 50616. Please use mysql_upgrade to fix this error.
2014-05-23 12:42:46 812 [ERROR] Column count of mysql.file_summary_by_instance is wrong. Expected 25, found 6. Created with MySQL 50525, now running 50616. Please use mysql_upgrade to fix this error.
2014-05-23 12:42:46 812 [ERROR] Incorrect definition of table performance_schema.mutex_instances: expected column 'LOCKED_BY_THREAD_ID' at position 2 to have type bigint(20), found type int(11).
2014-05-23 12:42:46 812 [ERROR] Incorrect definition of table performance_schema.rwlock_instances: expected column 'WRITE_LOCKED_BY_THREAD_ID' at position 2 to have type bigint(20), found type int(11).
2014-05-23 12:42:46 812 [ERROR] Column count of mysql.threads is wrong. Expected 14, found 3. Created with MySQL 50525, now running 50616. Please use mysql_upgrade to fix this error.
2014-05-23 12:42:46 812 [Note] Event Scheduler: Loaded 0 events
2014-05-23 12:42:46 812 [Note] C:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.6.16' socket: '' port: 3306 MySQL Community Server (GPL)
2014-05-23 12:42:46 131c InnoDB: Assertion failure in thread 4892 in file trx0purge.cc line 699
InnoDB: Failing assertion: purge_sys->iter.trx_no <= purge_sys->rseg->last_trx_no
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
cheposki
 
Posts: 1
Joined: 23. May 2014 18:47
XAMPP Version: 5.6.3
Operating System: windows 7 home edition

Re: mysql error

Postby saosangmo » 17. August 2014 20:21

hi,
I get the same error. How did you solved this problem?
thanks
saosangmo
 
Posts: 3
Joined: 27. February 2012 08:03
Location: Hanoi
XAMPP Version: 1.7.4
Operating System: Mac OS X 10.6.8


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 66 guests