>Description:
Any issue of the 'show variables' command via the mysql client is causing the
mysql server to get a signal 10 on HP-UX 11. The text in the .err log is as follows:
mysqld got signal 10;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against 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
030203 17:32:20 mysqld restarted
>How-To-Repeat:
1. Install the mysql-3.23.55-hp-hpux11.11-hppa2.0w binary downloaded from
wwww.mysql.com.
2. Start the server.
3. mysql -u root
4. 'show variables'
>Fix:
>Submitter-Id: eaforbu
>Originator: Ezra Forbus (Wal-Mart Network Management)
>Organization:
Wal-Mart Stores, Inc.
>MySQL support: none
>Synopsis: SIGBUS from 'show variables' on HPUX11
>Severity: serious
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.55 (Official MySQL binary)
>Server: /u/data/net/netmgt/bin/mysqladmin Ver 8.23 Distrib 3.23.55, for hp-hpux11.11
>on hppa2.0w
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.55
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 1 min 32 sec
Threads: 1 Questions: 1 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0
Queries per second avg: 0.011
>Environment:
System: HP-UX netnnm3 B.11.00 U 9000/898 1613603361 unlimited-user license
Some paths: /u/data/net/netmgt/bin/perl /u/data/net/netmgt/bin/make
/u/data/net/netmgt/bin/gcc /usr/bin/cc
GCC: Reading specs from
/u/data/net/netmgt/bin/../lib/gcc-lib/hppa2.0w-hp-hpux11.00/3.0/specs
Configured with: ../gcc-3.0/configure --prefix=/u/data/net/netmgt/
--exec-prefix=/u/data/net/netmgt/ --with-gnu-as
Thread model: single
gcc version 3.0
Compilation info: CC='cc' CFLAGS='+DD64' CXX='aCC' CXXFLAGS='+DD64' LDFLAGS=''
LIBC:
lrwxr-xr-x 1 root sys 8 Jan 23 2002 /lib/libc.0 -> ./libc.1
-r-xr-xr-x 1 bin bin 1867776 May 2 2001 /lib/libc.1
-r-xr-xr-x 1 bin bin 1560576 Aug 12 22:06 /lib/libc.2
-r--r--r-- 1 bin bin 2187296 Aug 12 22:06 /lib/libc.a
lrwxr-xr-x 1 root sys 15 Jan 23 2002 /lib/libc.sl ->
/usr/lib/libc.2
lrwxr-xr-x 1 root sys 8 Jan 23 2002 /usr/lib/libc.0 -> ./libc.1
-r-xr-xr-x 1 bin bin 1867776 May 2 2001 /usr/lib/libc.1
-r-xr-xr-x 1 bin bin 1560576 Aug 12 22:06 /usr/lib/libc.2
-r--r--r-- 1 bin bin 2187296 Aug 12 22:06 /usr/lib/libc.a
lrwxr-xr-x 1 root sys 15 Jan 23 2002 /usr/lib/libc.sl ->
/usr/lib/libc.2
Configure command: ./configure '--prefix=/usr/local/mysql' '--with-comment=Official
MySQL binary' '--with-extra-charsets=complex' '--with-server-suffix='
'--enable-thread-safe-client' '--enable-local-infile' '--disable-shared'
'--without-innodb' 'CC=cc' 'CFLAGS=+DD64' 'CXXFLAGS=+DD64' 'CXX=aCC'
**********************************************************************
This email and any files transmitted with it are confidential
and intended solely for the individual or entity to
whom they are addressed. If you have received this email
in error destroy it immediately.
**********************************************************************
Wal-Mart Stores, Inc. Confidential
**********************************************************************
---------------------------------------------------------------------
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
