>Description:
We are running about 100 MySQL-database servers on a single
Machine.
The databases are usually accessed via a web-interface. For some
batch processing
we tried to do basically 'SELECT *' on some tables. This caused
the mysqld-Processed
to fail. 'safe_mysql' restarted the processes a limited number
of times.
Eventually all but three deamons died.
This is the stack trace of one of the deamons:
0x807b75f handle_segfault__Fi + 383
0x812bcaa pthread_sighandler + 154
0x8150974 chunk_realloc + 56
0x8150907 realloc + 787
0x811594e my_realloc + 46
0x80fae62 _mi_read_pack_info + 1026
0x80f1c11 mi_open + 3789
0x80c68ed open__9ha_myisamPCciUi + 25
0x80c2d11 ha_open__7handlerPCcii + 33
0x80975c0 openfrm__FPCcT0UiUiUiP8st_table + 5008
0x8093572 open_unireg_entry__FP3THDP8st_tablePCcN22b + 70
0x8092bca open_table__FP3THDPCcN21Pb + 978
0x809379a open_tables__FP3THDP13st_table_list + 86
0x80957c2 open_and_lock_tables__FP3THDP13st_table_list + 18
0x8081e58 mysql_execute_command__Fv + 604
0x8085ce6 mysql_parse__FP3THDPcUi + 210
0x808130d do_command__FP3THD + 1261
0x808080c handle_one_connection__FPv + 548
>How-To-Repeat:
One reexecuting the batch-script, the same problem occured.
>Fix:
None known.
>Submitter-Id: ??
>Originator:
>Organization:
Biomax AG
>MySQL support: none
>Synopsis: Segmentation fault
>Severity: serious
>Priority: high, of course
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.43 (Official MySQL binary)
>Environment:
<machine, os, target, libraries (multiple lines)>
System: Linux pseudo 2.2.18 #1 Tue Jan 22 15:55:44 CET 2002 i686 unknown
The same error occured also with Kernel version 2.4.6
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc
/usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i486-suse-linux/2.95.2/specs
gcc version 2.95.2 19991024 (release)
Compilation info: CC='gcc' CFLAGS='-O3 -mpentium ' CXX='gcc'
CXXFLAGS='-O3 -mpentium -felide-constructors' LDFLAGS='-static'
LIBC:
-rwxr-xr-x 1 root root 1382179 Jan 19 2001 /lib/libc.so.6
-rw-r--r-- 1 root root 2585872 Jan 19 2001 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Jan 19 2001 /usr/lib/libc.so
Configure command: ./configure --prefix=/usr/local/mysql
'--with-comment=Official MySQL binary' --with-extra-charsets=complex
--with-server-suffix= --enable-assembler
--with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static
--disable-shared
---------------------------------------------------------------------
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
