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.
--------------------------------------------------
