mysqladmin generates a segmentation error

[Jim Francis]

From: jim
To: [EMAIL PROTECTED]
Subject: mysqladmin generates a segmentation error

Description:

getting segmentation error during execution of mysqladmin
have recompiled using gcc3 with all the flags suggested

in detail:
tried to initialize with
safe_mysql &
mysqladmin -u root -h Jungles.au --password xxxxxx

error log follows:

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=16773120
record_buffer=131072
sort_buffer=524280
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 = 80379 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:
0x80890dc
0x8146e83
0x8169bbb
0x8166d94
0x816e83c
0x816d8bf
0x808f51f
0x808e3da
::
and here are the results of resolving the stack trace
0x80890dc _Z15handle_segfaulti + 460
0x8146e83 __pthread_sighandler + 115
0x8169bbb __printf_fp + 123
0x8166d94 vfprintf + 7492
0x816e83c vsprintf + 124
0x816d8bf sprintf + 31
0x808f51f _Z10do_commandP3THD + 3055
0x808e3da _Z21handle_one_connectionPv + 842
error log continues
::
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...

Number of processes running now: 1
mysqld process hanging, pid 29200 - killed
021107 10:59:44 mysqld restarted
/usr/libexec/mysqld: ready for connections
<precise description of the problem (multiple lines)>

How-To-Repeat:

	make sure mysqld is really dead with killall
       safe_mysqld &
       mysqldadmin -u root -h Jungles.au --password xxxxxx

Fix:

Submitter-Id:	Jim Francis <submitter ID>
Originator:	as above
Organization:  Corus Consulting

<organization of PR author (multiple lines)>

MySQL support: none
Synopsis: mysqladmin generates a segmentation error Severity: critical Priority: high
Category: mysql
Class: sw-bug
Release: mysql-3.23.53 (Source distribution)
Server: /usr/bin/mysqladmin Ver 8.23 Distrib 3.23.53, 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		3.23.53-log
Protocol version	10
Connection		Localhost via UNIX socket
UNIX socket		/tmp/mysql.sock
Lost			

Environment:

<machine, os, target, libraries (multiple lines)>
System: Linux Jungles.au 2.4.18 #1 Thu Sep 5 04:56:51 EST 2002 i686 unknown
Architecture: i686

Some paths: /usr/bin/perl /usr/bin/make

Compilation info: CC='gcc' CFLAGS=' -O2 ' CXX='g++' CXXFLAGS=' -O2 ' LDFLAGS=' -Wl,-rpath-link,/usr/gcc-3.2/lib'
LIBC: lrwxrwxrwx 1 root root 13 Oct 15 07:34 /lib/libc.so.6 -> libc-2.3.1.so
-rwxr-xr-x 1 root root 1495992 Oct 15 07:34 /lib/libc-2.3.1.so
-rw-r--r-- 1 root root 2543104 Oct 15 07:32 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Oct 15 07:32 /usr/lib/libc.so
Configure command: ./configure --prefix=/usr --without-bench --enable-assembler --with-mysqld-ldflags=-all-static --localstatedir=/var/lib/mysql 'CFLAGS= -O2 ' 'CXXFLAGS= -O2 ' 'LDFLAGS= -Wl,-rpath-link,/usr/gcc-3.2/lib'




---------------------------------------------------------------------
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