안녕하세요..
mysql서버를 운영중에 메모리 에러가 발생했습니다..
기존 서버에서 3년 정도 운영후에 새서버로 이전한지 한 6개월 정도 되어 갑니다.
그리고 운영중에 이 에러가 발생한건 처음입니다.
에러 메세지는 다음과 같습니다.
------------------------------------
071129 8:31:01 - 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=6442450944
read_buffer_size=4190208
max_used_connections=1028
max_connections=2048
threads_connected=4
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 31449072 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
thd=0x2bd7a626d0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
Cannot determine thread, fp=0x400, backtrace may not be correct.
Bogus stack limit or frame pointer, fp=0x400, stack_bottom=0x479d0000, thread_stack=196608, aborting backtrace.
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0x2bdacceb70 is invalid pointer
thd->thread_id=187731897
The manual page at http://www.mysql.com/doc/en/Crashing.html contains
information that should help you find out what is causing the crash.
Number of processes running now: 0
071129 08:31:01 mysqld restarted
071129 8:31:02 [ERROR] /data/local/mysql/bin/mysqld: Table './mysql/user' is marked as crashed and should be repaired
071129 8:31:02 [Warning] Checking table: './mysql/user'
071129 8:31:02 [ERROR] 1 client is using or hasn't closed the table properly
----------------------------------------------------
운영하드웨어 스펙은 Dell PowerEdge 2950(quad-core) 에 cent4.5버전을 사용중입니다.
메모리는
[root@db1 data]# free -m
total used free shared buffers cached
Mem: 16030 10185 5845 0 750 5059
-/+ buffers/cache: 4375 11655
Swap: 0 0 0
문제가 생긴 시점의 시스템 하드웨어적인 부하는 그런건 sar로 본봐로는 거의 없었고요. 그
시점대에 클론으로 정산처리를 하고 있었는데.. 잘못된 쿼리로 이런 문제가 발생할수 있나요??
|