>Description:
<Seems everytime I do a queary on the mysql server it just crashes out and
restarts
displays this "/usr/local/mysql/bin/safe_mysqld: line 273: 3078 Segmentation
fault "
and also the below in the log file
[root@dev mysql-test]# ./mysql-test-run
Installing Test Databases
Removing Stale Files
Installing Master Databases
mysqld got signal 11;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked agaist is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help diagnose
the problem, but since we have already crashed, something is definitely wrong
and this may fail
key_buffer_size=8388600
record_buffer=131072
sort_buffer=2097144
max_used_connections=0
max_connections=100
threads_connected=1
It is possible that mysqld could use up to
key_buffer_size + (record_buffer + sort_buffer)*max_connections = 225791 K
bytes of memory
Hope that's ok, if not, decrease some variables in the equation
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
Stack range sanity check OK, backtrace follows:
0x808478e
0x8131730
0x8142ac6
0x808bc59
0x808e166
0x8086edb
Stack trace seems successful - bottom reached
Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow
instructions on how to resolve the stack trace.
Resolved
stack trace is much more helpful in diagnosing the problem, so please do
resolve it
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0x82528f0 = CREATE TABLE db ( Host char(60) DEFAULT '' NOT NULL, Db
char(64) DEFAULT '' NOT NULL, User
char(16) DEFAULT '' NOT NULL, Select_priv enum('N','Y') DEFAULT 'N' NOT NULL,
Insert_priv enum('N','Y') DEFAULT 'N' NOT
NULL, Update_priv enum('N','Y') DEFAULT 'N' NOT NULL, Delete_priv enum('N','Y')
DEFAULT 'N' NOT NULL, Create_priv
enum('N','Y') DEFAULT 'N' NOT NULL, Drop_priv enum('N','Y') DEFAULT 'N' NOT NULL,
Grant_priv enum('N','Y') DEFAULT 'N'
NOT NULL, References_priv enum('N','Y') DEFAULT 'N' NOT NULL, Index_priv
enum('N','Y') DEFAULT 'N' NOT NULL, Alter_priv
enum('N','Y') DEFAULT 'N' NOT NULL, PRIMARY KEY Host (Host,Db,User), KEY User (User) )
comment='Database privileges'
thd->thread_id=1
Successfully dumped variables, if you ran with --log, take a look at the
details of what thread 1 did to cause the crash. In some cases of really
bad corruption, the values shown above may be invalid
The manual page at http://www.mysql.com/doc/C/r/Crashing.html contains
information that should help you find out what is causing the crash
I did a stack follow up on it to reveal this
[root@dev tmp]# /usr/local/mysql/bin/resolve_stack_dump -s /tmp/mysqld.sym -n
mysqld.stack
0x808478e _Z15handle_segfaulti + 398
0x8131730 __pthread_sighandler + 116
0x8142ac6 __strtol_internal + 1390
0x808bc59 _Z17add_field_to_listPc16enum_field_typesS_S_jP4ItemS_P10st_typelib + 313
0x808e166 _Z7yyparsev + 3358
0x8086edb _Z16handle_bootstrapPv + 687
>
>How-To-Repeat:
<Well any query really, even the ones in scripts that came with the mysql
source distro>
>Fix:
>Submitter-Id: <submitter ID>
>Originator: Nick Clewer
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis: <Mysql crashing>
>Severity:
>Priority:
>Category: mysql
>Class:
>Release: mysql-3.23.53 (Source distribution)
>Environment:
System: Linux dev.webinteractive.com.au 2.4.18-14 #1 Wed Sep 4 13:35:50 EDT 2002 i686
i686 i386 GNU/Linux
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/i386-redhat-linux/3.2/specs
Configured with: ../configure --prefix=/usr --mandir=/usr/share/man
--infodir=/usr/share/info --enable-shared --enable-threads=posix --disable-checking
--host=i386-redhat-linux --with-system-zlib --enable-__cxa_atexit
Thread model: posix
gcc version 3.2 20020903 (Red Hat Linux 8.0 3.2-7)
Compilation info: CC='gcc' CFLAGS='-O3' CXX='gcc' CXXFLAGS='-O3
-felide-constructors -fno-exceptions -fno-rtti' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 14 Oct 16 2002 /lib/libc.so.6 ->
libc-2.2.93.so
-rwxr-xr-x 1 root root 1235468 Sep 6 09:12 /lib/libc-2.2.93.so
-rw-r--r-- 1 root root 2233342 Sep 6 08:59 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Sep 6 08:50 /usr/lib/libc.so
Configure command: ./configure --prefix=/usr/local/mysql --enable-assembler
--with-mysqld-ldflags=-all-static --localstatedir=/var/lib/mysql CFLAGS=-O3
'CXXFLAGS=-O3 -felide-constructors -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
