subject:"mysql sporadic crashes in find_item_in

mysql sporadic crashes in find_item_in_list

2002-12-22 Thread Paul P Komkoff Jr

Description:
Sometimes my hosting mysql server segfaulting
typical backtrace follows
0x80be1f8 handle_segfault + 424
0x4011e8d5 _end + 938550201
0x80dbf61 find_item_in_list__FP4ItemRt4List1Z4Item + 417
0x80ec0b0 find_order_in_list__FP3THDP13st_table_listP8st_orderRt4List1Z4ItemT3 + 248
0x80ef531 setup_order__FP3THDP13st_table_listRt4List1Z4ItemT2P8st_order + 49
0x80e0431 
mysql_select__FP3THDP13st_table_listRt4List1Z4ItemP4ItemP8st_orderT4T3T4UlP13select_result
 + 421
0x80ee8ec handle_select__FP3THDP6st_lexP13select_result + 92
0x80c760a mysql_execute_command__Fv + 934
0x80cac91 mysql_parse__FP3THDPcUi + 349
0x80c69a8 dispatch_command__F19enum_server_commandP3THDPcUi + 1280
0x80cc210 do_command__FP3THD + 92
0x80c5e38 handle_one_connection + 608
0x4011bb9c _end + 938538624
0x402ce1ea _end + 940317902

some queries from errorlog:
thd-query at 0x8236fd0 = SELECT * FROM _search WHERE (LOWER(keywords) LIKE LOWER('% 
ÃÎÐÎÄÑÊÎÅ %') AND LOWER(keywords) LIKE LOWE
R('% ÓÏÐÀÂËÅÍÈÅ %') AND LOWER(keywords) LIKE LOWER('% ÐÎÑÑÈÈ %') AND LOWER(keywords) 
LIKE LOWER('%  %')) OR (LOWER(CONCAT(' ',ti
tle,' ')) LIKE LOWER('% ÃÎÐÎÄÑÊÎÅ %') AND LOWER(CONCAT(' ',title,' ')) LIKE LOWER('% 
ÓÏÐÀÂËÅÍÈÅ %') AND LOWER(CONCAT(' ',title,'
 ')) LIKE LOWER('% ÐÎÑÑÈÈ %') AND LOWER(CONCAT(' ',title,' ')) LIKE LOWER('%  %')) 
ORDER BY lm DESC

thd-query at 0x8733a08 = SELECT * FROM _search WHERE (LOWER(keywords) LIKE LOWER('% 
ËÅÍÈÍ %')) OR (LOWER(CONCAT(' ',title,' '))
 LIKE LOWER('% ËÅÍÈÍ %')) ORDER BY lm DESC

thd-query at 0x87409a8 = SELECT * FROM _search WHERE (LOWER(keywords) LIKE LOWER('% 
ÀÍÀËÈÇ %') AND LOWER(keywords) LIKE LOWER('
% ÌÓÇÛÊÀËÜÍÎÃÎ %') AND LOWER(keywords) LIKE LOWER('% ÏÐÎÈÇÂÅÄÅÍÈß %')) OR 
(LOWER(CONCAT(' ',title,' ')) LIKE LOWER('% ÀÍÀËÈÇ %')
 AND LOWER(CONCAT(' ',title,' ')) LIKE LOWER('% ÌÓÇÛÊÀËÜÍÎÃÎ %') AND LOWER(CONCAT(' 
',title,' ')) LIKE LOWER('% ÏÐÎÈÇÂÅÄÅÍÈß %')
) ORDER BY lm DESC


How-To-Repeat:
Not researched yet
Fix:
Not known yet

Submitter-Id:  submitter ID
Originator:
Organization:
MySQL support: none
Synopsis:  pseudprandom mysqld segfaults in find_item_in_list
Severity:  serious
Category:  mysql
Class: sw-bug
Release:   mysql-4.0.5, mysql-4.0-1.1482 (cset 1.1482 as from 
bk://work.mysql.com:7001)

Environment:

System: Linux netstat 2.4.20-s7 #2 SMP ðÔÎ äÅË 13 18:51:21 MSK 2002 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-lib/i386-redhat-linux/2.96/specs
gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-98)
Compilation info: CC='gcc'  CFLAGS=''  CXX='g++'  CXXFLAGS=''  LDFLAGS=''  ASFLAGS=''
LIBC:
lrwxrwxrwx1 root root   13 áÐÒ 25  2002 /lib/libc.so.6 - libc-2.2.4.so
-rwxr-xr-x1 root root  1282588 óÅÎ  4  2001 /lib/libc-2.2.4.so
-rw-r--r--1 root root 27304836 óÅÎ  4  2001 /usr/lib/libc.a
-rw-r--r--1 root root  178 óÅÎ  4  2001 /usr/lib/libc.so
Configure command: ./configure '--prefix=/usr/local/mysql' '--enable-static=no' 
'--with-server-suffix' '--enable-thread-safe-client' '--enable-assembler' 
'--with-raid' '--with-mysqld-user=mysql' '--without-debug' '--with-comment' 
'--with-mysqlfs' '--with-vio' '--with-openssl' '--with-charset=cp1251' 
'--with-extra-charsets=all' '--without-innodb'


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

mysql sporadic crashes in find_item_in_list

2002-12-21 Thread Paul P Komkoff Jr

Description:
Sometimes my hosting mysql server segfaulting
typical backtrace follows
0x80be1f8 handle_segfault + 424
0x4011e8d5 _end + 938550201
0x80dbf61 find_item_in_list__FP4ItemRt4List1Z4Item + 417
0x80ec0b0 find_order_in_list__FP3THDP13st_table_listP8st_orderRt4List1Z4ItemT3 + 248
0x80ef531 setup_order__FP3THDP13st_table_listRt4List1Z4ItemT2P8st_order + 49
0x80e0431 
mysql_select__FP3THDP13st_table_listRt4List1Z4ItemP4ItemP8st_orderT4T3T4UlP13select_result
 + 421
0x80ee8ec handle_select__FP3THDP6st_lexP13select_result + 92
0x80c760a mysql_execute_command__Fv + 934
0x80cac91 mysql_parse__FP3THDPcUi + 349
0x80c69a8 dispatch_command__F19enum_server_commandP3THDPcUi + 1280
0x80cc210 do_command__FP3THD + 92
0x80c5e38 handle_one_connection + 608
0x4011bb9c _end + 938538624
0x402ce1ea _end + 940317902

some queries from errorlog:
thd-query at 0x8236fd0 = SELECT * FROM _search WHERE (LOWER(keywords) LIKE LOWER('% 
ÃÎÐÎÄÑÊÎÅ %') AND LOWER(keywords) LIKE LOWE
R('% ÓÏÐÀÂËÅÍÈÅ %') AND LOWER(keywords) LIKE LOWER('% ÐÎÑÑÈÈ %') AND LOWER(keywords) 
LIKE LOWER('%  %')) OR (LOWER(CONCAT(' ',ti
tle,' ')) LIKE LOWER('% ÃÎÐÎÄÑÊÎÅ %') AND LOWER(CONCAT(' ',title,' ')) LIKE LOWER('% 
ÓÏÐÀÂËÅÍÈÅ %') AND LOWER(CONCAT(' ',title,'
 ')) LIKE LOWER('% ÐÎÑÑÈÈ %') AND LOWER(CONCAT(' ',title,' ')) LIKE LOWER('%  %')) 
ORDER BY lm DESC

thd-query at 0x8733a08 = SELECT * FROM _search WHERE (LOWER(keywords) LIKE LOWER('% 
ËÅÍÈÍ %')) OR (LOWER(CONCAT(' ',title,' '))
 LIKE LOWER('% ËÅÍÈÍ %')) ORDER BY lm DESC

thd-query at 0x87409a8 = SELECT * FROM _search WHERE (LOWER(keywords) LIKE LOWER('% 
ÀÍÀËÈÇ %') AND LOWER(keywords) LIKE LOWER('
% ÌÓÇÛÊÀËÜÍÎÃÎ %') AND LOWER(keywords) LIKE LOWER('% ÏÐÎÈÇÂÅÄÅÍÈß %')) OR 
(LOWER(CONCAT(' ',title,' ')) LIKE LOWER('% ÀÍÀËÈÇ %')
 AND LOWER(CONCAT(' ',title,' ')) LIKE LOWER('% ÌÓÇÛÊÀËÜÍÎÃÎ %') AND LOWER(CONCAT(' 
',title,' ')) LIKE LOWER('% ÏÐÎÈÇÂÅÄÅÍÈß %')
) ORDER BY lm DESC


How-To-Repeat:
Not researched yet
Fix:
Not known yet

Submitter-Id:  submitter ID
Originator:
Organization:
MySQL support: none
Synopsis:  pseudprandom mysqld segfaults in find_item_in_list
Severity:  serious
Category:  mysql
Class: sw-bug
Release:   mysql-4.0.5, mysql-4.0-1.1482 (cset 1.1482 as from 
bk://work.mysql.com:7001)

Environment:

System: Linux netstat 2.4.20-s7 #2 SMP ðÔÎ äÅË 13 18:51:21 MSK 2002 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-lib/i386-redhat-linux/2.96/specs
gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-98)
Compilation info: CC='gcc'  CFLAGS=''  CXX='g++'  CXXFLAGS=''  LDFLAGS=''  ASFLAGS=''
LIBC: 
lrwxrwxrwx1 root root   13 áÐÒ 25  2002 /lib/libc.so.6 - libc-2.2.4.so
-rwxr-xr-x1 root root  1282588 óÅÎ  4  2001 /lib/libc-2.2.4.so
-rw-r--r--1 root root 27304836 óÅÎ  4  2001 /usr/lib/libc.a
-rw-r--r--1 root root  178 óÅÎ  4  2001 /usr/lib/libc.so
Configure command: ./configure '--prefix=/usr/local/mysql' '--enable-static=no' 
'--with-server-suffix' '--enable-thread-safe-client' '--enable-assembler' 
'--with-raid' '--with-mysqld-user=mysql' '--without-debug' '--with-comment' 
'--with-mysqlfs' '--with-vio' '--with-openssl' '--with-charset=cp1251' 
'--with-extra-charsets=all' '--without-innodb'


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

mysql sporadic crashes in find_item_in_list

2002-12-21 Thread Paul P Komkoff Jr

Description:
Sometimes my hosting mysql server segfaulting
typical backtrace follows
0x80be1f8 handle_segfault + 424
0x4011e8d5 _end + 938550201
0x80dbf61 find_item_in_list__FP4ItemRt4List1Z4Item + 417
0x80ec0b0 find_order_in_list__FP3THDP13st_table_listP8st_orderRt4List1Z4ItemT3 + 248
0x80ef531 setup_order__FP3THDP13st_table_listRt4List1Z4ItemT2P8st_order + 49
0x80e0431 
mysql_select__FP3THDP13st_table_listRt4List1Z4ItemP4ItemP8st_orderT4T3T4UlP13select_result
 + 421
0x80ee8ec handle_select__FP3THDP6st_lexP13select_result + 92
0x80c760a mysql_execute_command__Fv + 934
0x80cac91 mysql_parse__FP3THDPcUi + 349
0x80c69a8 dispatch_command__F19enum_server_commandP3THDPcUi + 1280
0x80cc210 do_command__FP3THD + 92
0x80c5e38 handle_one_connection + 608
0x4011bb9c _end + 938538624
0x402ce1ea _end + 940317902

some queries from errorlog:
thd-query at 0x8236fd0 = SELECT * FROM _search WHERE (LOWER(keywords) LIKE LOWER('% 
ÃÎÐÎÄÑÊÎÅ %') AND LOWER(keywords) LIKE LOWE
R('% ÓÏÐÀÂËÅÍÈÅ %') AND LOWER(keywords) LIKE LOWER('% ÐÎÑÑÈÈ %') AND LOWER(keywords) 
LIKE LOWER('%  %')) OR (LOWER(CONCAT(' ',ti
tle,' ')) LIKE LOWER('% ÃÎÐÎÄÑÊÎÅ %') AND LOWER(CONCAT(' ',title,' ')) LIKE LOWER('% 
ÓÏÐÀÂËÅÍÈÅ %') AND LOWER(CONCAT(' ',title,'
 ')) LIKE LOWER('% ÐÎÑÑÈÈ %') AND LOWER(CONCAT(' ',title,' ')) LIKE LOWER('%  %')) 
ORDER BY lm DESC

thd-query at 0x8733a08 = SELECT * FROM _search WHERE (LOWER(keywords) LIKE LOWER('% 
ËÅÍÈÍ %')) OR (LOWER(CONCAT(' ',title,' '))
 LIKE LOWER('% ËÅÍÈÍ %')) ORDER BY lm DESC

thd-query at 0x87409a8 = SELECT * FROM _search WHERE (LOWER(keywords) LIKE LOWER('% 
ÀÍÀËÈÇ %') AND LOWER(keywords) LIKE LOWER('
% ÌÓÇÛÊÀËÜÍÎÃÎ %') AND LOWER(keywords) LIKE LOWER('% ÏÐÎÈÇÂÅÄÅÍÈß %')) OR 
(LOWER(CONCAT(' ',title,' ')) LIKE LOWER('% ÀÍÀËÈÇ %')
 AND LOWER(CONCAT(' ',title,' ')) LIKE LOWER('% ÌÓÇÛÊÀËÜÍÎÃÎ %') AND LOWER(CONCAT(' 
',title,' ')) LIKE LOWER('% ÏÐÎÈÇÂÅÄÅÍÈß %')
) ORDER BY lm DESC


How-To-Repeat:
Not researched yet
Fix:
Not known yet

Submitter-Id:  submitter ID
Originator:
Organization:
MySQL support: none
Synopsis:  pseudprandom mysqld segfaults in find_item_in_list
Severity:  serious
Category:  mysql
Class: sw-bug
Release:   mysql-4.0.5, mysql-4.0-1.1482 (cset 1.1482 as from 
bk://work.mysql.com:7001)

Environment:

System: Linux netstat 2.4.20-s7 #2 SMP ðÔÎ äÅË 13 18:51:21 MSK 2002 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-lib/i386-redhat-linux/2.96/specs
gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-98)
Compilation info: CC='gcc'  CFLAGS=''  CXX='g++'  CXXFLAGS=''  LDFLAGS=''  ASFLAGS=''
LIBC:
lrwxrwxrwx1 root root   13 áÐÒ 25  2002 /lib/libc.so.6 - libc-2.2.4.so
-rwxr-xr-x1 root root  1282588 óÅÎ  4  2001 /lib/libc-2.2.4.so
-rw-r--r--1 root root 27304836 óÅÎ  4  2001 /usr/lib/libc.a
-rw-r--r--1 root root  178 óÅÎ  4  2001 /usr/lib/libc.so
Configure command: ./configure '--prefix=/usr/local/mysql' '--enable-static=no' 
'--with-server-suffix' '--enable-thread-safe-client' '--enable-assembler' 
'--with-raid' '--with-mysqld-user=mysql' '--without-debug' '--with-comment' 
'--with-mysqlfs' '--with-vio' '--with-openssl' '--with-charset=cp1251' 
'--with-extra-charsets=all' '--without-innodb'


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

mysql sporadic crashes in find_item_in_list

2002-12-21 Thread Paul P Komkoff Jr

Description:
Sometimes my hosting mysql server segfaulting
typical backtrace follows
0x80be1f8 handle_segfault + 424
0x4011e8d5 _end + 938550201
0x80dbf61 find_item_in_list__FP4ItemRt4List1Z4Item + 417
0x80ec0b0 find_order_in_list__FP3THDP13st_table_listP8st_orderRt4List1Z4ItemT3 + 248
0x80ef531 setup_order__FP3THDP13st_table_listRt4List1Z4ItemT2P8st_order + 49
0x80e0431 
mysql_select__FP3THDP13st_table_listRt4List1Z4ItemP4ItemP8st_orderT4T3T4UlP13select_result
 + 421
0x80ee8ec handle_select__FP3THDP6st_lexP13select_result + 92
0x80c760a mysql_execute_command__Fv + 934
0x80cac91 mysql_parse__FP3THDPcUi + 349
0x80c69a8 dispatch_command__F19enum_server_commandP3THDPcUi + 1280
0x80cc210 do_command__FP3THD + 92
0x80c5e38 handle_one_connection + 608
0x4011bb9c _end + 938538624
0x402ce1ea _end + 940317902

some queries from errorlog:
thd-query at 0x8236fd0 = SELECT * FROM _search WHERE (LOWER(keywords) LIKE LOWER('% 
ÃÎÐÎÄÑÊÎÅ %') AND LOWER(keywords) LIKE LOWE
R('% ÓÏÐÀÂËÅÍÈÅ %') AND LOWER(keywords) LIKE LOWER('% ÐÎÑÑÈÈ %') AND LOWER(keywords) 
LIKE LOWER('%  %')) OR (LOWER(CONCAT(' ',ti
tle,' ')) LIKE LOWER('% ÃÎÐÎÄÑÊÎÅ %') AND LOWER(CONCAT(' ',title,' ')) LIKE LOWER('% 
ÓÏÐÀÂËÅÍÈÅ %') AND LOWER(CONCAT(' ',title,'
 ')) LIKE LOWER('% ÐÎÑÑÈÈ %') AND LOWER(CONCAT(' ',title,' ')) LIKE LOWER('%  %')) 
ORDER BY lm DESC

thd-query at 0x8733a08 = SELECT * FROM _search WHERE (LOWER(keywords) LIKE LOWER('% 
ËÅÍÈÍ %')) OR (LOWER(CONCAT(' ',title,' '))
 LIKE LOWER('% ËÅÍÈÍ %')) ORDER BY lm DESC

thd-query at 0x87409a8 = SELECT * FROM _search WHERE (LOWER(keywords) LIKE LOWER('% 
ÀÍÀËÈÇ %') AND LOWER(keywords) LIKE LOWER('
% ÌÓÇÛÊÀËÜÍÎÃÎ %') AND LOWER(keywords) LIKE LOWER('% ÏÐÎÈÇÂÅÄÅÍÈß %')) OR 
(LOWER(CONCAT(' ',title,' ')) LIKE LOWER('% ÀÍÀËÈÇ %')
 AND LOWER(CONCAT(' ',title,' ')) LIKE LOWER('% ÌÓÇÛÊÀËÜÍÎÃÎ %') AND LOWER(CONCAT(' 
',title,' ')) LIKE LOWER('% ÏÐÎÈÇÂÅÄÅÍÈß %')
) ORDER BY lm DESC


How-To-Repeat:
Not researched yet
Fix:
Not known yet

Submitter-Id:  submitter ID
Originator:
Organization:
MySQL support: none
Synopsis:  pseudprandom mysqld segfaults in find_item_in_list
Severity:  serious
Category:  mysql
Class: sw-bug
Release:   mysql-4.0.5, mysql-4.0-1.1482 (cset 1.1482 as from 
bk://work.mysql.com:7001)

Environment:

System: Linux netstat 2.4.20-s7 #2 SMP ðÔÎ äÅË 13 18:51:21 MSK 2002 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-lib/i386-redhat-linux/2.96/specs
gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-98)
Compilation info: CC='gcc'  CFLAGS=''  CXX='g++'  CXXFLAGS=''  LDFLAGS=''  ASFLAGS=''
LIBC:
lrwxrwxrwx1 root root   13 áÐÒ 25  2002 /lib/libc.so.6 - libc-2.2.4.so
-rwxr-xr-x1 root root  1282588 óÅÎ  4  2001 /lib/libc-2.2.4.so
-rw-r--r--1 root root 27304836 óÅÎ  4  2001 /usr/lib/libc.a
-rw-r--r--1 root root  178 óÅÎ  4  2001 /usr/lib/libc.so
Configure command: ./configure '--prefix=/usr/local/mysql' '--enable-static=no' 
'--with-server-suffix' '--enable-thread-safe-client' '--enable-assembler' 
'--with-raid' '--with-mysqld-user=mysql' '--without-debug' '--with-comment' 
'--with-mysqlfs' '--with-vio' '--with-openssl' '--with-charset=cp1251' 
'--with-extra-charsets=all' '--without-innodb'


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

mysql sporadic crashes in find_item_in_list

mysql sporadic crashes in find_item_in_list

mysql sporadic crashes in find_item_in_list

mysql sporadic crashes in find_item_in_list

4 matches

Site Navigation

Mail list logo

Footer information