>Description:
Running mysqld (built from NetBSD's pkgsrc, normally reliable),
I find that the initial install works, but attempts to restart
the server later fail with signal 4!
>How-To-Repeat:
Install server. Stop and restart server.
>Fix:
Never reboot or restart server.
>Submitter-Id: <submitter ID>
>Originator:
>Organization:
>MySQL support: none
>Synopsis: mysqld gets SIGILL when restarted after initial load
>Severity: critical
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-5.0.24 (Source distribution)
>C compiler: gcc (GCC) 3.3.3 (NetBSD nb3 20040520)
>C++ compiler: g++ (GCC) 3.3.3 (NetBSD nb3 20040520)
>Environment:
System: NetBSD ch1.cheetah.net 3.0.0_STABLE NetBSD 3.0.0_STABLE (CHEETAH64) #0:
Sat Feb 4 16:16:48 PST 2006 root@:/usr/src/sys/arch/amd64/compile/CHEETAH64
amd64
Some paths: /usr/pkg/bin/perl /usr/bin/make /usr/pkg/bin/gmake /usr/bin/gcc
/usr/bin/cc
GCC: Using built-in specs.
Configured with:
/home/nick/work/netbsd/src/tools/gcc/../../gnu/dist/gcc/configure
--enable-long-long --disable-multilib --enable-threads --disable-symvers
--build=i386-unknown-netbsdelf2.0. --host=x86_64--netbsd --target=x86_64--netbsd
Thread model: posix
gcc version 3.3.3 (NetBSD nb3 20040520)
Compilation info: CC='cc' CFLAGS='-O2 -DUSE_OLD_FUNCTIONS -I/usr/include'
CXX='c++' CXXFLAGS='-O2 -DUSE_OLD_FUNCTIONS -I/usr/include'
LDFLAGS='-Wl,-R/usr/pkg/lib/mysql -L/usr/lib -Wl,-R/usr/lib -Wl,-R/usr/pkg/lib'
ASFLAGS=''
LIBC:
lrwxr-xr-x 1 root wheel 16 Dec 18 2005 /lib/libc.so -> libc.so.12.128.2
lrwxr-xr-x 1 root wheel 16 Dec 18 2005 /lib/libc.so.12 -> libc.so.12.128.2
-r--r--r-- 1 root wheel 1065082 Dec 18 2005 /lib/libc.so.12.128.2
-r--r--r-- 1 root wheel 2684418 Dec 18 2005 /usr/lib/libc.a
lrwxr-xr-x 1 root wheel 21 Dec 18 2005 /usr/lib/libc.so ->
/lib/libc.so.12.128.2
lrwxr-xr-x 1 root wheel 21 Dec 18 2005 /usr/lib/libc.so.12 ->
/lib/libc.so.12.128.2
lrwxr-xr-x 1 root wheel 21 Dec 18 2005 /usr/lib/libc.so.12.128.2 ->
/lib/libc.so.12.128.2
Configure command: ./configure '--localstatedir=/var/mysql'
'--with-named-z-libs=z' '--without-libwrap' '--with-named-curses-libs=-lcurses
-ltermcap' '--without-readline' '--without-libedit' '--without-docs'
'--disable-dependency-tracking' '--without-debug' '--without-bench'
'--with-low-memory' '--with-openssl=/usr' '--with-zlib-dir=/usr' '--with-vio'
'--with-charset=latin1' '--with-extra-charsets=all' '--without-extra-tools'
'--without-server' '--enable-thread-safe-client' '--prefix=/usr/pkg'
'--host=x86_64--netbsd' '--infodir=/usr/pkg/info' '--mandir=/usr/pkg/man'
'CC=cc' 'CFLAGS=-O2 -DUSE_OLD_FUNCTIONS -I/usr/include' 'CPPFLAGS=-Dunix
-I/usr/include' 'CXXFLAGS=-O2 -DUSE_OLD_FUNCTIONS -I/usr/include' 'CXX=c++'
'F77=f77' 'FFLAGS=-O' 'LDFLAGS=-Wl,-R/usr/pkg/lib/mysql -L/usr/lib
-Wl,-R/usr/lib -Wl,-R/usr/pkg/lib' 'host_alias=x86_64--netbsd'
Error file:
064708 14:47:33 Starting mysqld daemon with databases from /var/mysql
064708 14:47:33 mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
060808 14:47:33 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
060808 14:47:33 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
060808 14:47:34 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
060808 14:47:34 InnoDB: Started; log sequence number 0 0
060808 14:47:34 [Note] /usr/pkg/libexec/mysqld: ready for connections.
Version: '5.0.24' socket: '/tmp/mysql.sock' port: 3306 Source distribution
060808 14:50:44 [Note] /usr/pkg/libexec/mysqld: Normal shutdown
060808 14:50:44 InnoDB: Starting shutdown...
060808 14:50:47 InnoDB: Shutdown completed; log sequence number 0 43655
060808 14:50:47 [Note] /usr/pkg/libexec/mysqld: Shutdown complete
065008 14:50:47 STOPPING server from pid file /var/mysql/ch1.cheetah.net.pid
065008 14:50:47 mysqld ended
065008 14:50:48 Starting mysqld daemon with databases from /var/mysql
065008 14:50:48 mysqld started
mysqld got signal 4;
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=0
read_buffer_size=131072
max_used_connections=0
max_connections=100
threads_connected=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections =
217599 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
065008 14:50:48 STOPPING server from pid file /var/mysql/ch1.cheetah.net.pid
065008 14:50:48 mysqld ended
---
Attempts to backtrace yield only:
(gdb) bt
#0 0x000000000065eded in getsockname ()
#1 0x00000000005ed0e2 in getsockname ()
#2 0x000000000059f0ce in getsockname ()
#3 0x0000000000590364 in getsockname ()
#4 0x0000000000533c3e in getsockname ()
#5 0x000000000052a0b3 in getsockname ()
#6 0x000000000048e076 in getsockname ()
#7 0x000000000048e6d7 in getsockname ()
#8 0x0000000000406568 in getsockname ()
which makes no sense at all.
-s
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
