>Description:
I have tried to install and run Mysql 3.23.32 source tarball with BerkeleyDB
3.2.3h. I also tried previous versions of Mysql (3.23.29, 27, 25) all with the
same result.
I have tried the following on 3 different systems which are detailed below.
I have tried the same configuration options on all systems, with
exactly the same result.
configure [options] ; make ; make install (Berkeley DB)
configure [options] ; make ; make install (Mysql)
mysql_install_db <- FAILED, mysqld crashes with Segmentation Fault.
Systems I have tried on (Mysql 3.23.32, BDB 3.2.3h):
1) Pentium 200Mhz MMX, 32 MB RAM, 4.3Gb & 1Gb IDE hdd, western digital
Slackware 7.0 from CDROM
2) AMD Athlon 650MHz 128 MB SDRAM, 20GB IDE hdd, Quantum
Slackware 7.0 from CDROM
3) Pentium III 550MHz, 128 MB SDRAM, 2x9.1GB SCSI hdd, Adaptec 78xx SCSI
Slackware 7.0 from CDROM
Note: system 2) has a complete Slackware 7.0 install, while 1) and 3) lack
emacs, tcl, tex, and all X-Windows related packages.
Note: all systems have been installed from a Slackware 7.0 CDROM made after a
bootable ISO image downloaded from a Slackware mirror site.
Note: same options were used for configure scripts on all systems.
Berkeley DB 3.2.3h :
tar -zxf db-3.2.3h.tar.gz
cd db-3.2.3h/build_unix
../dist/configure
make
make install
MySQL 3.23.32 :
tar -zxf mysql-3.23.32.tar.gz
cd mysql-3.23.32
./configure --prefix=/usr/local/mysql --enable-thread-safe-client \
--with-mysqld-user=mysql --without-debug
make
make install
cd /usr/local
useradd mysql
groupadd mysql
chown mysql.mysql mysql -R
cd mysql
bin/mysql_install_db
^^^^^^^^^^^^^^^^^^^^^^^^^^^ this fails with mysqld: Segmentation Fault.
running libexec/mysqld --skip-grant-tables fails with the
same error : Segmentation Fault.
I have already sent to the list the output of strace libexec/mysqld --bootstrap
--skip-grant-tables
(From [EMAIL PROTECTED] [Andrei B.] which I will not include here for size
and readability reasons)
On the list I also saw reports of this exact same problem by other people and
the output of mysql_install_db which I don't include here.
======================================
I have tried other options as follows and most of the possible
combinations of them:
Berkeley DB :
configure --enable-static (suggested in mysql online commented manual)
configure --enable-cxx
both of the above.
Mysql :
I always used --prefix=/usr/local/mysql and 90% of times --with-mysqld-user=mysql
configure --with-debug
configure --enable-static
configure --with-mysqld-ldflags
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ make failes: yes : no such file or directory
when generating the mysqld binary.
command looks like this:
cc some_binary.o yes -Lsome_libs [...] mysqld.c
--with-client-ldfags gives the same error when generating the mysql binary
configure --enable-static
removed some options from the original configure line. see above.
===============================================================
not using Berkeley BD.
Mysql as above.
make, install, same error.
===============================================================
Updating the linux system:
-glibc updated from 2.1.2 to 2.1.3 (package from Slackware current)
no change.
-kernel source tree and includes updated from 2.2.13 to 2.2.17 (package from
Slackware current)
server compiles and works OK, only if NOT USING BERKELEY DB.
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
>How-To-Repeat:
Step 0)
install a Slackware 7.0 distribution.
install BDB3.2.3h and Mysql 3.23.32 as follows:
Step 1)
Berkeley DB 3.2.3h :
tar -zxf db-3.2.3h.tar.gz
cd db-3.2.3h/build_unix
../dist/configure
make
make install
Step 2)
MySQL 3.23.32 :
tar -zxf mysql-3.23.32.tar.gz
cd mysql-3.23.32
./configure --prefix=/usr/local/mysql --enable-thread-safe-client \
--with-mysqld-user=mysql --without-debug
make
make install
cd /usr/local
useradd mysql
groupadd mysql
chown mysql.mysql mysql -R
cd mysql
bin/mysql_install_db
^^^^^^^^^^^^^^^^^^^^^^^ this fails with SIGSEGV.
====================================================================
Second variant :
====================================================================
Step 0)
install a Slackware 7.0 distribution.
install BDB3.2.3h and Mysql 3.23.32 as follows:
Step 1)
Berkeley DB 3.2.3h :
tar -zxf db-3.2.3h.tar.gz
cd db-3.2.3h/build_unix
../dist/configure
make
make install
Step 2)
MySQL 3.23.32 :
tar -zxf mysql-3.23.32.tar.gz
cd mysql-3.23.32
./configure --prefix=/usr/local/mysql --enable-thread-safe-client \
--with-mysqld-user=mysql --without-debug --with-mysqld-ldflags
make
^^^^^^^^^^^^^ this fails: make: yes : no such file or directory
when compiling the mysqld binary
>Fix:
None known.
Partial fix :
Step 0)
install a Slackware 7.0 distribution.
get glibc.tgz (version 2.1.3) from www.slackware.com
get lx2217.tgz (kernel 2.2.17)
get linuxinc.tgz (kernel includes version 2.2.17)
telinit 1
upgradepkg glibc.tgz
installpkg lx2217.tgz
installpkg linuxinc.tgz
telinit 3
(it is not necessary to compile the new kernel sources)
install Mysql 3.23.32 as follows:
(!!! Do not unpack the BDB source tarball)
Step 2)
MySQL 3.23.32 :
tar -zxf mysql-3.23.32.tar.gz
cd mysql-3.23.32
./configure --prefix=/usr/local/mysql --enable-thread-safe-client \
--with-mysqld-user=mysql --without-debug
make
make install
cd /usr/local
useradd mysql
groupadd mysql
chown mysql.mysql mysql -R
cd mysql
bin/mysql_install_db
bin/safe_mysqld
============== everything works just fine, but NO TRANZACTION SUPPORT =======
>Submitter-Id: Andrei Boros
>Originator: Andrei Boros
>Organization:
Societatea Romana de Radiodifuziune
(Romanian Radio Broadcasting Corporation)
>MySQL support: none (yet)
>Synopsis: MySQL and BDB compiled crashes with SIGSEGV
>Severity: critical
>Priority: high
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.32 (Source distribution)
>Environment:
System: Linux web 2.2.13 #3 Thu Mar 1 11:08:41 EET 2001 i686 unknown
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-slackware-linux/egcs-2.91.66/specs
gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 Mar 1 13:29 /lib/libc.so.6 -> libc-2.1.3.so
-rwxr-xr-x 1 root root 1008844 Sep 10 1999 /lib/libc-2.1.2.so
-rwxr-xr-x 1 root root 1014632 Sep 5 2000 /lib/libc-2.1.3.so
-rw-r--r-- 1 root root 20266642 Mar 20 2000 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Mar 20 2000 /usr/lib/libc.so
Configure command: ./configure --prefix=/usr/local/mysql --without-debug
--enable-thread-safe-client --with-mysqld-user=mysql
Perl: This is perl, version 5.005_03 built for i386-linux
---------------------------------------------------------------------
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
