I am confused.
I run a Slackware 7.0 system, with glibc (runtimes and source
libraries) upgraded to 2.1.3 from 2.1.2. Compiler is egcs 1.1.2 (gcc
2.91.66)
I have tested the following with this exact setup on 5 different
computers by now and I get random results:
mysql-3.23.32 source tarball used on all
berkeley-3.2.3h source tarball used on all
berkeleyDB : ./configure; make ; make install
mysqld: ./configure --prefix=/usr/local/mysql; make ;make install
-----------------------------------------------------------------------
Systems I've tested on:
- Pentium 200MMX, mb VIA VXPro 32MB DRAM
- Pentium II 350 Klamath, mb Intel BX, 128MB SDRAM 10ns PC100
- AMD Athlon 650, mb Asus K7M, 128MB SDRAM 10ns PC100
- Pentium III 550, mb HP (something), 128MB SDRAM
-----------------------------------------------------------------------
On all of the above systems: after compilation:
cd /usr/local/mysql
bin/mysql_install_db FAILED!!!
--------------------------- reason: mysqld - SIGSEGV segmentation
fault.
This error happens 50-100% of cases. I compile the server 2 days ago on
one system, it fails. I compile it again, same options on another
system, it works. I recompile with same options on the system that
failed 2 days ago, it works. Another try fails again.
-----------------------------------------------------------------------
Excluding BerkeleyDB from the server configuration will work in most
cases.
I was unable to reliably repeat any of the above. It works or fails
without apparent dependancy, except for the presence of BDB, which is
not a guarantee, just that it may not fail so often.
A succesfully compiled server works and seems stable. However this
unreliability is very disturbing.
Below I added the output of strace which I have only partially figured
out so far, but only increased my confusion
=======================================================================
execve("./mysqld", ["./mysqld", "--skip-grant-tables"], [/* 28 vars
*/]) = 0
brk(0) = 0x82605e0
open("/etc/ld.so.preload", O_RDONLY) = -1 ENOENT (No such file or
directory)
open("/etc/ld.so.cache", O_RDONLY) = 3
fstat(3, {st_mode=0, st_size=0, ...}) = 0
mmap(0, 7605, PROT_READ, MAP_PRIVATE, 3, 0) = 0x40014000
close(3) = 0
open("/lib/libdl.so.2", O_RDONLY) = 3
fstat(3, {st_mode=0, st_size=0, ...}) = 0
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3"..., 4096) = 4096
mmap(0, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) =
0x40016000
mmap(0, 12332, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x40017000
mprotect(0x40019000, 4140, PROT_NONE) = 0
mmap(0x40019000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3,
0x1000) = 0x40019000
mmap(0x4001a000, 44, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x4001a000
close(3) = 0
open("/usr/lib/libz.so.1", O_RDONLY) = 3
fstat(3, {st_mode=0, st_size=0, ...}) = 0
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3"..., 4096) = 4096
mmap(0, 57996, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x4001b000
mprotect(0x40027000, 8844, PROT_NONE) = 0
mmap(0x40027000, 12288, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3,
0xb000) = 0x40027000
close(3) = 0
open("/lib/libcrypt.so.1", O_RDONLY) = 3
fstat(3, {st_mode=0, st_size=0, ...}) = 0
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3"..., 4096) = 4096
mmap(0, 12864, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x4002a000
mprotect(0x4002d000, 576, PROT_NONE) = 0
mmap(0x4002d000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3,
0x2000) = 0x4002d000
close(3) = 0
open("/lib/libnsl.so.1", O_RDONLY) = 3
fstat(3, {st_mode=0, st_size=0, ...}) = 0
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3"..., 4096) = 4096
mmap(0, 85704, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x4002e000
mprotect(0x40040000, 11976, PROT_NONE) = 0
mmap(0x40040000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3,
0x11000) = 0x40040000
mmap(0x40041000, 7880, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x40041000
close(3) = 0
open("/lib/libpthread.so.0", O_RDONLY) = 3
fstat(3, {st_mode=0, st_size=0, ...}) = 0
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3"..., 4096) = 4096
mmap(0, 72920, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x40043000
mprotect(0x4004e000, 27864, PROT_NONE) = 0
mmap(0x4004e000, 28672, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3,
0xa000) = 0x4004e000
close(3) = 0
open("/usr/lib/libstdc++-libc6.1-1.so.2", O_RDONLY) = 3
fstat(3, {st_mode=0, st_size=0, ...}) = 0
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3"..., 4096) = 4096
mmap(0, 269136, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x40055000
mprotect(0x40089000, 56144, PROT_NONE) = 0
mmap(0x40089000, 49152, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3,
0x33000) = 0x40089000
mmap(0x40095000, 6992, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x40095000
close(3) = 0
open("/lib/libm.so.6", O_RDONLY) = 3
fstat(3, {st_mode=0, st_size=0, ...}) = 0
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3"..., 4096) = 4096
mmap(0, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) =
0x40097000
mmap(0, 113656, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x40098000
mprotect(0x400b3000, 3064, PROT_NONE) = 0
mmap(0x400b3000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3,
0x1a000) = 0x400b3000
close(3) = 0
open("/lib/libc.so.6", O_RDONLY) = 3
fstat(3, {st_mode=0, st_size=0, ...}) = 0
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3"..., 4096) = 4096
mmap(0, 955804, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x400b4000
mprotect(0x40196000, 30108, PROT_NONE) = 0
mmap(0x40196000, 16384, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3,
0xe1000) = 0x40196000
mmap(0x4019a000, 13724, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x4019a000
close(3) = 0
mprotect(0x400b4000, 925696, PROT_READ|PROT_WRITE) = 0
mprotect(0x400b4000, 925696, PROT_READ|PROT_EXEC) = 0
munmap(0x40014000, 7605) = 0
personality(PER_LINUX) = 0
getpid() = 17703
getpid() = 17703
getrlimit(RLIMIT_STACK, {rlim_cur=8192*1024, rlim_max=RLIM_INFINITY}) =
0
setrlimit(RLIMIT_STACK, {rlim_cur=2040*1024, rlim_max=RLIM_INFINITY}) =
0
uname({sys="Linux", node="web", ...}) = 0
rt_sigaction(0x20, 0xbffff858, 0, 0x8, 0x20) = 0
rt_sigaction(0x21, 0xbffff84c, 0, 0x8, 0x21) = 0
rt_sigaction(0x22, 0xbffff858, 0, 0x8, 0x22) = 0
rt_sigprocmask(0, 0xbffff930, 0, 0x8, 0) = 0
brk(0) = 0x82605e0
brk(0x8260610) = 0x8260610
brk(0x8261000) = 0x8261000
open("/etc/localtime", O_RDONLY) = 3
read(3, "TZif\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 44) = 44
read(3, "\267\260\322\10\271>\363`\271\357"..., 685) = 685
fstat(3, {st_mode=0, st_size=0, ...}) = 0
mmap(0, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) =
0x40014000
read(3, "\0\0\30x\0\0\0\0*0\1\4\0\0\34 \0"..., 4096) = 69
close(3) = 0
munmap(0x40014000, 4096) = 0
time(NULL) = 983455550
uname({sys="Linux", node="web", ...}) = 0
open("/etc/my.cnf", O_RDONLY|0x8000) = -1 ENOENT (No such file or
directory)
open("/usr/local/mysql-BDB/var/my.cnf", O_RDONLY|0x8000) = -1 ENOENT
(No such file or directory)
open("/root/.my.cnf", O_RDONLY|0x8000) = -1 ENOENT (No such file or
directory)
lstat("/usr/local/mysql-BDB", {st_mode=0, st_size=0, ...}) = 0
open("/usr/local/mysql-BDB/share/mysql/charsets/Index",
O_RDONLY|0x8000) = 3
fstat(3, {st_mode=0, st_size=0, ...}) = 0
mmap(0, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) =
0x40014000
read(3, "# sql/share/charsets/Index\n#\n#"..., 4096) = 549
brk(0x8263000) = 0x8263000
read(3, "", 4096) = 0
close(3) = 0
munmap(0x40014000, 4096) = 0
stat("/usr/local/mysql-BDB/share/mysql/charsets/big5.conf", 0xbffff4cc)
= -1 ENOENT (No such file or directory)
stat("/usr/local/mysql-BDB/share/mysql/charsets/czech.conf",
0xbffff4cc) = -1 ENOENT (No such file or directory)
stat("/usr/local/mysql-BDB/share/mysql/charsets/dec8.conf", {st_mode=0,
st_size=0, ...}) = 0
stat("/usr/local/mysql-BDB/share/mysql/charsets/dos.conf", {st_mode=0,
st_size=0, ...}) = 0
stat("/usr/local/mysql-BDB/share/mysql/charsets/german1.conf",
{st_mode=0, st_size=0, ...}) = 0
stat("/usr/local/mysql-BDB/share/mysql/charsets/hp8.conf", {st_mode=0,
st_size=0, ...}) = 0
stat("/usr/local/mysql-BDB/share/mysql/charsets/koi8_ru.conf",
{st_mode=0, st_size=0, ...}) = 0
stat("/usr/local/mysql-BDB/share/mysql/charsets/latin2.conf",
{st_mode=0, st_size=0, ...}) = 0
stat("/usr/local/mysql-BDB/share/mysql/charsets/swe7.conf", {st_mode=0,
st_size=0, ...}) = 0
stat("/usr/local/mysql-BDB/share/mysql/charsets/usa7.conf", {st_mode=0,
st_size=0, ...}) = 0
stat("/usr/local/mysql-BDB/share/mysql/charsets/ujis.conf", 0xbffff4cc)
= -1 ENOENT (No such file or directory)
stat("/usr/local/mysql-BDB/share/mysql/charsets/sjis.conf", 0xbffff4cc)
= -1 ENOENT (No such file or directory)
stat("/usr/local/mysql-BDB/share/mysql/charsets/cp1251.conf",
{st_mode=0, st_size=0, ...}) = 0
stat("/usr/local/mysql-BDB/share/mysql/charsets/danish.conf",
{st_mode=0, st_size=0, ...}) = 0
stat("/usr/local/mysql-BDB/share/mysql/charsets/hebrew.conf",
{st_mode=0, st_size=0, ...}) = 0
stat("/usr/local/mysql-BDB/share/mysql/charsets/win1251.conf",
{st_mode=0, st_size=0, ...}) = 0
stat("/usr/local/mysql-BDB/share/mysql/charsets/tis620.conf",
0xbffff4cc) = -1 ENOENT (No such file or directory)
stat("/usr/local/mysql-BDB/share/mysql/charsets/euc_kr.conf",
0xbffff4cc) = -1 ENOENT (No such file or directory)
stat("/usr/local/mysql-BDB/share/mysql/charsets/estonia.conf",
{st_mode=0, st_size=0, ...}) = 0
stat("/usr/local/mysql-BDB/share/mysql/charsets/hungarian.conf",
{st_mode=0, st_size=0, ...}) = 0
stat("/usr/local/mysql-BDB/share/mysql/charsets/koi8_ukr.conf",
{st_mode=0, st_size=0, ...}) = 0
stat("/usr/local/mysql-BDB/share/mysql/charsets/win1251ukr.conf",
{st_mode=0, st_size=0, ...}) = 0
stat("/usr/local/mysql-BDB/share/mysql/charsets/gb2312.conf",
0xbffff4cc) = -1 ENOENT (No such file or directory)
stat("/usr/local/mysql-BDB/share/mysql/charsets/greek.conf",
{st_mode=0, st_size=0, ...}) = 0
stat("/usr/local/mysql-BDB/share/mysql/charsets/win1250.conf",
{st_mode=0, st_size=0, ...}) = 0
stat("/usr/local/mysql-BDB/share/mysql/charsets/croat.conf",
{st_mode=0, st_size=0, ...}) = 0
stat("/usr/local/mysql-BDB/share/mysql/charsets/gbk.conf", 0xbffff4cc)
= -1 ENOENT (No such file or directory)
stat("/usr/local/mysql-BDB/share/mysql/charsets/cp1257.conf",
{st_mode=0, st_size=0, ...}) = 0
stat("/usr/local/mysql-BDB/share/mysql/charsets/latin5.conf",
{st_mode=0, st_size=0, ...}) = 0
sched_setscheduler(0x4527, 0, 0xbffff7cc, 0x4004e480, 0x400524e0) = -1
EINVAL (Invalid argument)
sched_get_priority_max(0, 0, 0x400548dc, 0xbffff7cc, 0x82572c0) = 0
sched_get_priority_min(0, 0, 0x400548dc, 0xbffff7cc, 0x82572c0) = 0
getrlimit(RLIMIT_NOFILE, {rlim_cur=1024, rlim_max=1024}) = 0
getpid() = 17703
time(NULL) = 983455550
open("/usr/local/mysql-BDB/share/mysql/english/errmsg.sys",
O_RDONLY|0x8000) = 3
read(3, "\376\376\2\1\1\0\327$\306\0\0\0\0"..., 32) = 32
brk(0x8266000) = 0x8266000
read(3, "\0\0\10\0\20\0\23\0\27\0>\0f\0\222"..., 396) = 396
read(3, "hashchk\0isamchk\0NO\0YES\0Can\'"..., 9431) = 9431
close(3) = 0
umask(06) = 022
chdir("/usr/local/mysql-BDB/var/") = 0
open("/etc/nsswitch.conf", O_RDONLY) = 3
fstat(3, {st_mode=0, st_size=0, ...}) = 0
mmap(0, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) =
0x40014000
read(3, "#\n# /etc/nsswitch.conf\n#\n# An"..., 4096) = 1108
read(3, "", 4096) = 0
close(3) = 0
munmap(0x40014000, 4096) = 0
open("/etc/ld.so.cache", O_RDONLY) = 3
fstat(3, {st_mode=0, st_size=0, ...}) = 0
mmap(0, 7605, PROT_READ, MAP_PRIVATE, 3, 0) = 0x40014000
close(3) = 0
open("/lib/libnss_db.so.2", O_RDONLY) = 3
fstat(3, {st_mode=0, st_size=0, ...}) = 0
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3"..., 4096) = 4096
mmap(0, 22156, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x4019e000
mprotect(0x401a3000, 1676, PROT_NONE) = 0
mmap(0x401a3000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3,
0x4000) = 0x401a3000
close(3) = 0
open("/lib/libdb.so.3", O_RDONLY) = 3
fstat(3, {st_mode=0, st_size=0, ...}) = 0
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3"..., 4096) = 4096
mmap(0, 233784, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x401a4000
mprotect(0x401dc000, 4408, PROT_NONE) = 0
mmap(0x401dc000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3,
0x37000) = 0x401dc000
close(3) = 0
open("/lib/libnss_files.so.2", O_RDONLY) = 3
fstat(3, {st_mode=0, st_size=0, ...}) = 0
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3"..., 4096) = 4096
mmap(0, 33516, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x401de000
mprotect(0x401e5000, 4844, PROT_NONE) = 0
mmap(0x401e5000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3,
0x6000) = 0x401e5000
close(3) = 0
munmap(0x40014000, 7605) = 0
--- SIGSEGV (Segmentation fault) ---
+++ killed by SIGSEGV +++
=======================================================================
In all cases, this is where it crashes.
Thank you in advance for your help
=====
ing. Andrei Boros
Centrul pt. Tehnologia Informatiei
Societatea Romana de Radiodifuziune
__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/
---------------------------------------------------------------------
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
