List:General Discussion« Previous MessageNext Message »
From:Natalino Picone Date:November 4 2005 3:03pm
Subject:Re: INSERT DELAYED crash in 5.0.15
View as plain text  
I also have the same problem upgrading from 4.1.15 to 5.0.15; this query 
  hang mysql:
INSERT DELAYED INTO phpads_adstats SET clicks = 0, views = 1, day = 
NOW(), hour = HOUR(NOW()), bannerid = '97', zoneid = '15', source = ''

This is happening with every linux mysql 5.0.15 binary distribuition 
(dynamic, static & debug).

here is the stack trace

0x809d632 handle_segfault + 430
0x82d74c8 pthread_sighandler + 184
0x808d519 store__15Field_varstringPCcUiP15charset_info_st + 245
0x80530ea save_in_field__11Item_stringP5Fieldb + 86
0x80d55a8 fill_record__FP3THDRt4List1Z4ItemT1b + 112
0x80d5620 
fill_record_n_invoke_before_triggers__FP3THDRt4List1Z4ItemT1bP19Table_triggers_list14trg_event_type

+ 40
0x80f5266 
mysql_insert__FP3THDP13st_table_listRt4List1Z4ItemRt4List1Zt4List1Z4ItemT2T215enum_duplicatesb

+ 1366
0x80b04a1 mysql_execute_command__FP3THD + 7405
0x80b53ba mysql_parse__FP3THDPcUi + 286
0x80ad283 dispatch_command__F19enum_server_commandP3THDPcUi + 1747
0x80acba3 do_command__FP3THD + 195
0x80ac104 handle_one_connection + 764
0x82d4c7c pthread_start_thread + 220
0x82fe57a thread_start + 4


Kind Regards,
Nat


gem@stripped wrote:
>> Description:
> 	I have a 1M hit a day web server that logs ad hits to mysql.  Always
>         been solid as a rock.  Most recently on mysql 4.1.14.  We upgraded
>         our backup servers to 5.0.15, no problem.  We upgraded the live
>         server and the mysqld crashes about once a second.
> 
> 	Here is the SQL that crashes it:
> 
> INSERT DELAYED INTO views 
> SET ad_id='4', 
>     host='pool-68-239-6-162.bos.east.verizon.net',
>     ip='1156515490'
> 
> 
>         Remove the DELAYED and no problems.
> 
> 	Here is a stack trace:
> 
> 0x81876bc handle_segfault + 668
> 0xb7f6edfd _end + -1348763991
> 0xb7d6b307 _end + -1350876237
> 0x816994e _ZN15Field_varstring5storeEPKcjP15charset_info_st + 206
> 0x81043d7 _ZN11Item_string13save_in_fieldEP5Fieldb + 87
> 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
> 0xb7f67463 _end + -1348795121
> 0xb7dccd64 _end + -1350476272
> 
> 
>> How-To-Repeat:
> 	Dunno, needs a high load.
> 
>> Fix:
> 	Dunno.  Never had mysql problems before.
> 
>> Submitter-Id:	<submitter ID>
>> Originator:	gem@stripped
>> Organization:  Rellim
>> MySQL support: none 
>> Synopsis:	INSERT DELAYED crash
>> 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'
> 
> 

-- 
--------------------------------------------------
Natalino Picone - nat@stripped
--------------------------------------------------
It's a horrible thing to be on top of the world and then to lose it and 
try to get it back.
It's a whole lot harder the second time.
--------------------------------------------------
Thread
INSERT DELAYED crash in 5.0.15gem4 Nov
  • Re: INSERT DELAYED crash in 5.0.15Natalino Picone4 Nov