>Description:
INSERT DELAYED crashes my new mysqld. Here is the error log:
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=131072
max_used_connections=2
max_connections=200
threads_connected=2
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 144382
K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
thd=0x89a6ad0
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=0xbdffe178, backtrace may not be correct.
Stack range sanity check OK, backtrace follows:
0x81876bc
0xb7e92dfd
0x81043b9
0x81c9f79
0x81f39a6
0x81a4b9f
0x81a9113
0x81a9d3d
0x81ab594
0xb7e8b463
0xb7cf0d64
New value of fp=(nil) failed sanity check, terminating stack trace!
Please read http://dev.mysql.com/doc/mysql/en/Using_stack_trace.html and follow
instructions on how to resolve the stack trace. Resolved
stack trace is much more helpful in diagnosing the problem, so please do
resolve it
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0x896c8a8 = INSERT DELAYED INTO search
SET summary_id='1124898819.8519_9251', zip='', zipdist='0', city='',
county='', state='', total='0', last_name='',
cost='0', insurance='', duration='0', age_spec='0',
religion='0', ethnicity='0', modality='0',
therapist_gender='0',thrpst_type_id='0',
language='0', sexual_orient='0', pttotal='0',
issue='0', condn='0', partner_id='0'
thd->thread_id=4
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.
Here is the decoded stack dump:
0x81876bc handle_segfault + 668
0xb7e92dfd _end + -1349665111
0x81043b9 _ZN11Item_string13save_in_fieldEP5Fieldb + 57
0x81c9f79 _Z36fill_record_n_invoke_before_triggersP3THDR4ListI4ItemES4_bP19Table
_triggers_list14trg_event_type + 137
0x81f39a6 _Z12mysql_insertP3THDP13st_table_listR4ListI4ItemERS3_IS5_ES6_S6_15enu
m_duplicatesb + 3158
0x81a4b9f _Z21mysql_execute_commandP3THD + 25135
0x81a9113 _Z11mysql_parseP3THDPcj + 483
0x81a9d3d _Z16dispatch_command19enum_server_commandP3THDPcj + 2781
0x81ab594 handle_one_connection + 2340
0xb7e8b463 _end + -1349696241
0xb7cf0d64 _end + -1351377392
I have aplied this patch: /home/mydev/mysql-5.0-bug13707, it fixes my
last reported INSERT DELAYED, but not this one.
>How-To-Repeat:
Not exactly sure, but removeing the DELAYED in the above makes it
work fine.
>Fix:
Dunno.
>Submitter-Id: <submitter ID>
>Originator: [EMAIL PROTECTED]
>Organization: Rellim
>MySQL support: none
>Synopsis: ANother INSERT DELAYED bug
>Severity: serious
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-5.0.15 (Source distribution)
>C compiler: gcc (GCC) 3.4.4
>C++ compiler: g++ (GCC) 3.4.4
>Environment:
System: Linux cms 2.6.13.2 #3 SMP Wed Sep 28 17:25:36 PDT 2005 i686 unknown
Architecture: i686
Some paths: /usr/local/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc
/usr/bin/cc
GCC: Reading specs from /usr/lib/gcc/i686-pc-linux-gnu/3.4.4/specs
Configured with: /mnt/www3/usr/local/src/gcc-3.4.4/configure --prefix=/usr
--exec-prefix=/usr --enable-shared --disable-libgcj --disable-libf2c
Thread model: posix
gcc version 3.4.4
Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS=''
ASFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 Sep 20 2003 /lib/libc.so.6 ->
libc-2.3.1.so
-rwxr-xr-x 1 root root 1435624 Mar 4 2003 /lib/libc-2.3.1.so
-rw-r--r-- 1 root root 2425490 Mar 4 2003 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Mar 4 2003 /usr/lib/libc.so
Configure command: ./configure '--prefix=/usr/local/mysql' '--with-openssl'
'--enable-thread-safe-client' '--enable-assembler' '--enable-local-infile'
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
