MySQL Forums
Forum List  »  Merge Storage Engine

merge table crash
Posted by: li kong
Date: March 21, 2009 12:40AM

I am using merge tables select rows, there are 6 tables under this merge table.
after insert or delete some data in sub tables, the merge table will crash on query.

I try to use the same sql in mysql client, always crashed.
after repair the sub tables, still crashed.

But if I use the subtables in sql, it did not crash.

May some one help me find out how to fix this?

Is this a bug?

Thanks

here is the log:
[0x697c6e]
[0x4bbdb2]
[0x62e670]
[0x64d1e2]
[0x676097]
[0x5a827a]
[0x591f67]
[0x59143d]
[0x5913b7]
[0x51dc50]
[0x525e59]
[0x52c09d]
[0x53cc27]
[0x53e548]
[0x53ee79]
[0x4c643c]
[0x4cb90e]
[0x4d1b58]
[0x4d1f43]
[0x4d30f4]
[0x4c3dd7]
[0x62afe7]
[0x721db9]
090321 12:05:45 - 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=4294967296
read_buffer_size=33554432
max_used_connections=3
max_threads=151
threads_connected=3
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 14091772 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

thd: 0x197f0040
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...
stack_bottom = 0x4164ef60 thread_stack 0x40000
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0x197fb0c0 = SELECT count(*) FROM zfa_ic_inventory A WHERE A.CORP_ID=1 AND A.TABLE_TYPE=1
thd->thread_id=2
thd->killed=NOT_KILLED
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
090321 12:05:45 mysqld_safe Number of processes running now: 0
090321 12:05:45 mysqld_safe mysqld restarted
090321 12:05:46 [Warning] Storage engine 'SPHINX' has conflicting typecode. Assigning value 42.
090321 12:05:46 [Note] Event Scheduler: Loaded 0 events
090321 12:05:46 [Note] /data/mysql_new/libexec/mysqld: ready for connections.
Version: '5.1.32' socket: '/tmp/mysql.sock' port: 33066 Source distribution

Options: ReplyQuote


Subject
Views
Written By
Posted
merge table crash
11733
March 21, 2009 12:40AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.