|
얼마전 서버를 4.0 대에서 -> 5.0.15 버전으로 업그레이드를 한
후 잘 사용하던 중
언제가부터 에러로그를 보니 서버가 저절로 restart 되고
있었습니다.
에러로그는 다음과 같습니다.
---------------
mysqld got signal 11;
This could be because you hit a bug. It is also possible that this
binary
or one of the libraries it was linked against is corrupt,
improperly built,
or misconfigured. This error can also be caused by malfunctioning
hardware.
We will try our best to scrape up some info that will hopefully
help diagnose
the problem, but since we have already crashed, something is
definitely wrong
and this may fail.
key_buffer_size=16777216
read_buffer_size=258048
max_used_connections=8
max_connections=600
threads_connected=8
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size +
sort_buffer_size)*max_connections = 474779 K
bytes of memory
Hope that's ok; if not, decrease some variables in the
equation.
051229 10:04:14 mysqld restarted
051229 10:04:14 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the
doublewrite
InnoDB: buffer...
051229 10:04:14 InnoDB: Starting log scan based on checkpoint
at
InnoDB: log sequence number 0 52369.
InnoDB: Doing recovery: scanned up to log sequence number 0
52369
InnoDB: Last MySQL binlog file position 0 398569, file name
./mysql-bin.001974
051229 10:04:14 InnoDB: Started; log sequence number 0 52369
051229 10:04:14 [Note] Recovering after a crash using
mysql-bin
051229 10:04:14 [Note] Starting crash recovery...
051229 10:04:14 [Note] Crash recovery finished.
051229 10:04:14 [Note] /usr/local/mysql_jp/libexec/mysqld: ready
for connections.
Version: '5.0.15-log' socket:
'/usr/local/etc/mysql_jp/mysql_jp.sock' port: 3306 FreeBSD port:
mysql-server-5.0.15
--------------------
혹시 값을 조정하면 될 수 있지 않을까 하는 생각에
max_connections값을 조정해 보았는데
더더욱 많이 restart 되더군요..
restart 되는 시점의 slow log를 보았는데 별반 이상한 점을
발견하기 어려웠습니다.
------ slow log ---------
/usr/local/mysql_jp/libexec/mysqld, Version: 5.0.15-log. started
with:
Tcp port: 3306 Unix socket:
/usr/local/etc/mysql_jp/mysql_jp.sock
Time Id Command Argument
-----------------------
역시 binary log에도 별 이상한 점은 발견되지 않았구요..
어떠한 하드웨어적 트러블인건지..
무슨 원인인지 감이 안잡히네요..
혹시 이 문제에 대해 조금이나 겪어보신 분 있으시면 정보 공유 좀
부탁드리겠습니다.
|
