>Description:
Running a specific query makes the mysqld goeing away...
>How-To-Repeat:
Under the following URL you find a partial mysqldump to repeat the error:
http://1net.ch/mysqlerr/err.sql
>Fix:
>Submitter-Id: Jene
>Originator: Jene Novakovic
>Organization: 1 net GmbH
>MySQL support: none
>Synopsis: running query kills mysqld
>Severity: critical
>Priority: high
>Category: mysql
>Class: sw-bug
>Release: mysql-4.0.3-beta (Source distribution)
>Server: /usr/bin/mysqladmin Ver 8.37 Distrib 4.0.3-beta, for pc-linux-gnu on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 4.0.3-beta
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 2 min 19 sec
Threads: 303 Questions: 21928 Slow queries: 0 Opens: 87 Flush tables: 1 Open
tables: 81 Queries per second avg: 157.755
>Environment:
System: Linux db01 2.4.18-64GB-SMP #1 SMP Tue Jul 30 09:25:48 UTC 2002 i686 unknown
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.3/specs
gcc version 2.95.3 20010315 (SuSE)
Compilation info: CC='gcc' CFLAGS='-pipe -march=i686 -mpreferred-stack-boundary=4'
CXX='gcc' CXXFLAGS='-pipe -march=i686 -felide-constructors
-mpreferred-stack-boundary=4 -fno-exceptions -fno-rtti' LDFLAGS=''
LIBC:
-rwxr-xr-x 1 root root 1394302 Aug 10 19:55 /lib/libc.so.6
-rw-r--r-- 1 root root 25361748 Aug 10 19:24 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Aug 10 19:24 /usr/lib/libc.so
Configure command: ./configure --prefix=/usr --localstatedir=/local/mysql
--without-debug --enable-thread-safe-client --enable-assembler
--with-mysqld-user=mysql --enable-static --with-mysqld-ldflags=-all-static
--with-extra-charset=german1 --without-bench --without-docs 'CFLAGS=-pipe -march=i686
-mpreferred-stack-boundary=4' 'CXXFLAGS=-pipe -march=i686 -felide-constructors
-mpreferred-stack-boundary=4 -fno-exceptions -fno-rtti' CXX=gcc
---------------------------------------------------------------------
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
