>Description:
No problems during compilation. Nonetheless
the server won't start at all. Been unable to execute
mysql_install_db --force after installation.
hostname.err:
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=524252
max_used_connections=0
max_connections=100
threads_connected=0
It is possible that mysqld could use up to
key_buffer_size + (record_buffer + sort_buffer)*max_connections = 80376 K
bytes of memory
Hope that's ok, if not, decrease some variables in the equation
>How-To-Repeat:
upgrade to netbsd-current; apply netbsd-patches to mysql-src; make
make install; safe_mysqld --user=mysql
>Fix:
>Submitter-Id: <submitter ID>
>Originator:
>Organization:
>MySQL support: none
>Synopsis: mysql-server crashing on startup
>Severity:
>Priority:
>Category: mysql
>Class:
>Release: mysql-3.23.49 (Source distribution)
>Environment:
System: NetBSD 1.6_BETA4
cpu0: Intel Pentium III (Coppermine) (686-class), 800.07 MHz
cpu0: I-cache 16 KB 32b/line 4-way, D-cache 16 KB 32b/line 2-way
cpu0: L2 cache 256 KB 32b/line 8-way
cpu0: features 387f9ff<FPU,VME,DE,PSE,TSC,MSR,PAE,MCE,CX8,SEP,MTRR>
cpu0: features 387f9ff<PGE,MCA,CMOV,FGPAT,PSE36,PN,MMX>
cpu0: features 387f9ff<FXSR,SSE>
cpu0: serial number 0000-0686-0001-B128-B299-DF2C
total memory = 511 MB
avail memory = 470 MB
using 6144 buffers containing 26292 KB of memory
swapctl -l:
Device 512-blocks Used Avail Capacity Priority
/dev/raid1a 524160 0 524160 0% 0
RAID autoconfigure
Configuring raid1: ecc...
Some paths: /usr/bin/perl /usr/bin/make /usr/pkg/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Using builtin specs.
gcc version 2.95.3 20010315 (release) (NetBSD nb2)
Compilation info: CC='gcc' CFLAGS='-g -O3' CXX='gcc' CXXFLAGS='-g -O3
-felide-constructors -fno-exceptions -fno-rtti' LDFLAGS=''
LIBC:
-r--r--r-- 1 root wheel 1344510 Jul 12 15:52 /usr/lib/libc.a
lrwxrwxr-x 1 root wheel 13 Jul 13 20:50 /usr/lib/libc.so -> libc.so.12.83
lrwxrwxr-x 1 root wheel 13 Jul 13 20:50 /usr/lib/libc.so.12 -> libc.so.12.83
-r--r--r-- 1 root wheel 685044 Jun 10 18:41 /usr/lib/libc.so.12.62.1
-r--r--r-- 1 root wheel 699791 Jul 12 16:14 /usr/lib/libc.so.12.83
Configure command: ./configure --prefix=/usr/local/mysql --with-debug=full
---------------------------------------------------------------------------------------
gdb sessions:
gdb /usr/local/libexec/mysqld /usr/local/mysql/var/mysqld.core:
GNU gdb 5.0nb1
Copyright 2000 Free Software Foundation, Inc.
GDB is free software, covered by the GNU General Public License, and you are
welcome to change it and/or distribute copies of it under certain conditions.
Type "show copying" to see the conditions.
There is absolutely no warranty for GDB. Type "show warranty" for details.
This GDB was configured as "i386--netbsdelf"...
core was generated by `mysqld'.
Program terminated with signal 11, Segmentation fault.
Reading symbols from /usr/libexec/ld.elf_so...done.
Loaded symbols for /usr/libexec/ld.elf_so
Reading symbols from /usr/lib/libz.so.0...done.
Loaded symbols for /usr/lib/libz.so.0
Reading symbols from /usr/lib/libcrypt.so.0...done.
Loaded symbols for /usr/lib/libcrypt.so.0
Reading symbols from /usr/lib/libm.so.0...done.
Loaded symbols for /usr/lib/libm.so.0
Reading symbols from /usr/lib/libc.so.12...done.
Loaded symbols for /usr/lib/libc.so.12
#0 0x48269a4f in kill () from /usr/lib/libc.so.12
(gdb) backtrace full
#0 0x48269a4f in kill () from /usr/lib/libc.so.12 # [ /usr/lib/libc.so.12 ->
libc.so.12.83 ]
No symbol table info available.
#1 0x8159f3d in pthread_sig_process ()
at /usr/local/src/mysql-3.23.49/mit-pthreads/pthreads/sig.c:135
vector = (void (*)(void)) 0x81d9510
i = 11
j = 136156668
#2 0x8157f36 in __cleanup_after_resume ()
at /usr/local/src/mysql-3.23.49/mit-pthreads/pthreads/signal.c:559
No locals.
#3 0x8158043 in pthread_sched_resume ()
at /usr/local/src/mysql-3.23.49/mit-pthreads/pthreads/signal.c:536
No locals.
#4 0x815b5be in pthread_kill (pthread=0x81d9510, sig=11)
at /usr/local/src/mysql-3.23.49/mit-pthreads/pthreads/pthread_kill.c:91
pthread = (struct pthread *) 0x81d9510
sig = 11
pthread_ptr = (struct pthread **) 0x0
#5 0x80f6418 in write_core (sig=11) at stacktrace.c:220
sig = 11
#6 0x807f554 in handle_segfault (sig=11) at mysqld.cc:1287
sig = 11
#7 0xbfbfdfdc in ()
---Type <return> to continue, or q <return> to quit---
No symbol table info available.cktrace full
#0 0x48269a4f in kill () from /usr/lib/libc.so.12
No symbol table info available.
#1 0x8159f3d in pthread_sig_process ()
at /usr/local/src/mysql-3.23.49/mit-pthreads/pthreads/sig.c:135
vector = (void (*)(void)) 0x81d9510
i = 11
j = 136156668
#2 0x8157f36 in __cleanup_after_resume ()
at /usr/local/src/mysql-3.23.49/mit-pthreads/pthreads/signal.c:559
No locals.
#3 0x8158043 in pthread_sched_resume ()
at /usr/local/src/mysql-3.23.49/mit-pthreads/pthreads/signal.c:536
No locals.
#4 0x815b5be in pthread_kill (pthread=0x81d9510, sig=11)
at /usr/local/src/mysql-3.23.49/mit-pthreads/pthreads/pthread_kill.c:91
pthread = (struct pthread *) 0x81d9510
sig = 11
pthread_ptr = (struct pthread **) 0x0
#5 0x80f6418 in write_core (sig=11) at stacktrace.c:220
sig = 11
#6 0x807f554 in handle_segfault (sig=11) at mysqld.cc:1287
sig = 11
#7 0xbfbfdfdc in ?? ()
-----------------------------------------------------------------------
gdb /usr/local/libexec/mysqld:
GNU gdb 5.0nb1
Copyright 2000 Free Software Foundation, Inc.
GDB is free software, covered by the GNU General Public License, and you are
welcome to change it and/or distribute copies of it under certain conditions.
Type "show copying" to see the conditions.
There is absolutely no warranty for GDB. Type "show warranty" for details.
This GDB was configured as "i386--netbsdelf"...
(gdb) run
Starting program: /usr/local/mysql/libexec/mysqld
Program received signal SIGSEGV, Segmentation fault.
0x0 in ?? ()
(gdb) backtrace full
#0 0x0 in ?? ()
No symbol table info available.
#1 0x81574d6 in pthread_create (thread=0x81d9910, attr=0x0,
start_routine=0xbfbfd74c, arg=0x8158043)
at /usr/local/src/mysql-3.23.49/mit-pthreads/pthreads/pthread.c:255
thread = (pthread_t *) 0x81d9964
attr = (pthread_attr_t *) 0xbfbfd778
new_thread = 0x81d9910
retval = 134739992
---------------------------------------------------------------------
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
