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
[EMAIL PROTECTED] 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: [EMAIL PROTECTED]
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 - [EMAIL PROTECTED]
--------------------------------------------------
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.
--------------------------------------------------
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
