mysql is down please help me :(

shahab

Verified User
Joined
Aug 4, 2014
Messages
72
Hello mysql server is down.
and when i want to run ./buid mysql get this error:

Repairing tables
mysql.gtid_slave_pos
Error : Table 'mysql.gtid_slave_pos' doesn't exist
status : Operation failed
mysql.innodb_index_stats
Error : Table 'mysql.innodb_index_stats' doesn't exist
status : Operation failed
mysql.innodb_table_stats
Error : Table 'mysql.innodb_table_stats' doesn't exist
status : Operation failed
Running 'mysql_fix_privilege_tables'...
Warning: Using a password on the command line interface can be insecure.
ERROR 1146 (42S02) at line 62: Table 'mysql.innodb_table_stats' doesn't exist
ERROR 1243 (HY000) at line 63: Unknown prepared statement handler (stmt) given to EXECUTE
ERROR 1243 (HY000) at line 64: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE
ERROR 1146 (42S02) at line 66: Table 'mysql.innodb_index_stats' doesn't exist
ERROR 1243 (HY000) at line 67: Unknown prepared statement handler (stmt) given to EXECUTE
ERROR 1243 (HY000) at line 68: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE
ERROR 1146 (42S02) at line 1904: Table 'mysql.innodb_table_stats' doesn't exist
ERROR 1146 (42S02) at line 1908: Table 'mysql.innodb_index_stats' doesn't exist
FATAL ERROR: Upgrade failed
cp: '/usr/lib/libmysqlclient.so' and '/usr/lib/mysql/libmysqlclient.so' are the same file
cp: '/usr/lib/libmysqlclient.so.18' and '/usr/lib/mysql/libmysqlclient.so.18' are the same file
Restarting MySQL.

please help me,

my.cnf is:


[mysqld]
local-infile=0
skip-locking
query_cache_limit=1M
query_cache_size=32M
query_cache_type=1
max_connections=500
interactive_timeout=100
wait_timeout=100
connect_timeout=10
thread_cache_size=128
key_buffer=16M
join_buffer=1M
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=2M
read_buffer_size=2M
max_connect_errors=10
# Try number of CPU's*2 for thread_concurrency
thread_concurrency=2
myisam_sort_buffer_size=64M
server-id=1
 
Last edited:
Thanks.

I used mysql 5.6.

"https://stackoverflow.com/questions/37856155/mysql-upgrade-failed-innodb-tables-doesnt-exist" not solved:(

I get this error my mysql error logs


2018-11-15 07:14:03 20688 [Warning] InnoDB: Cannot open table novin_inst4/settings 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.
2018-11-15 07:14:04 20688 [Warning] InnoDB: Cannot open table novin_inst4/settings 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.
2018-11-15 07:14:04 20688 [Warning] InnoDB: Cannot open table novin_inst4/settings 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.
181115 07:14:32 mysqld_safe Logging to '/var/lib/mysql/hostname.err'.
181115 07:14:32 mysqld_safe A mysqld process already exists
181115 07:14:34 mysqld_safe Logging to '/var/lib/mysql/hostname.err'.
181115 07:14:34 mysqld_safe A mysqld process already exists
2018-11-15 07:14:41 20688 [Warning] InnoDB: Cannot open table ones_db/wp_woocommerce_ir 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.
181115 07:14:43 mysqld_safe Logging to '/var/lib/mysql/hostname.err'.
181115 07:14:43 mysqld_safe A mysqld process already exists
 
Back
Top