Lost connection to MySQL server during query when executing 'CHECK TABLE ...

Spacedust - 08-01-2010 13:49
Lost connection to MySQL server during query when executing 'CHECK TABLE ...
mysql_upgrade -p

leci chwilę i potem:

Kod: mysqlcheck: Got error: 2013: Lost connection to MySQL server during query when executing 'CHECK TABLE ... FOR UPGRADE' MySQL to 5.1.42 - system to CentOS 5.4 64-bit

meto - 08-01-2010 17:27
Zobacz jaki masz timeout na połączeniach. Wydaje mi się że serwer sam zrywa połaczenie. Pokaż my.cnf

Spacedust - 08-01-2010 18:25
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
old_passwords=1
tmp_table_size=32M
max_heap_table_size=32M
table_cache=32K
thread_cache_size=1K
query_cache_size=32M
query_cache_limit=512M
concurrent_insert=2
key_buffer_size=32M
max_connections=200
join_buffer_size=64M
skip-innodb
wait_timeout=30
max_allowed_packet=8M

# To allow mysqld to connect to a MySQL Cluster management daemon, uncomment
# these lines and adjust the connectstring as needed.
#ndbcluster
#ndb-connectstring="nodeid=4;host=localhost:1186"

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[ndbd]
# If you are running a MySQL Cluster storage daemon (ndbd) on this machine,
# adjust its connection to the management daemon here.
# Note: ndbd init script requires this to include nodeid!
connect-string="nodeid=2;host=localhost:1186"

[ndb_mgm]
# connection string for MySQL Cluster management tool
connect-string="host=localhost:1186"

ollerm - 08-01-2010 18:29
Kod: wait_timeout=30 timeout możesz zakomentować, albo zwiększyć

a
Kod: max_allowed_packet=8M zwiększ sobie do 16M

Spacedust - 08-01-2010 18:37
Niestety nie pomogło.

To samo miejsce i FATAL ERROR: Upgrade failed

Zgłosiłem bug do MySQL.

ollerm - 08-01-2010 18:48
A sprawdzałeś logi? Może tam coś więcej będzie..

Spacedust - 08-01-2010 19:16
Kod: 100108 19:19:17 [ERROR] Column count of mysql.db is wrong. Expected 22, found 20. Created with MySQL 50089, now running 50142. Please use mysql_upgrade to fix this error.
100108 19:19:17 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.

ollerm - 08-01-2010 19:25
a to ciekawe. Mysql sypnął ci sie po jakimś rozjechaniu FSa czy jak?

Spacedust - 08-01-2010 20:12
Może tak, ale działa ;>

Spacedust - 08-01-2010 21:51
Update: jedna baza się rozwaliła i powodowała taki dziwny błąd.