>Description:
I've tried several times to get mysql to install on my linux box, to
no avail. Everytime, the mysql_install_db script hangs when it tries
to run mysqld. Running mysqld by hand hangs the same way as well. I've
seen over a dozen reports of this on the mysql mailing list in the last
year and no real answers have ever been given.
------------- Output from mysql_install_db ----------------
[root]# scripts/mysql_install_db
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
------------- Output from ps ----------------
[root]# ps -elf | grep my
100 S root 19592 19173 0 69 0 - 548 wait4 10:26 pts/1 00:00:00
/bin/sh scripts/mysql_install_db
100 S root 19597 19592 0 69 0 - 5132 rt_sig 10:26 pts/1 00:00:00
./bin/mysqld --bootstrap --skip-grant-tables --basedir=. --datadir=./data
--skip
040 S root 19598 19597 0 69 0 - 5132 do_pol 10:26 pts/1 00:00:00
./bin/mysqld --bootstrap --skip-grant-tables --basedir=. --datadir=./data
--skip
040 S root 19599 19598 0 69 0 - 5132 rt_sig 10:26 pts/1 00:00:00
./bin/mysqld --bootstrap --skip-grant-tables --basedir=. --datadir=./data
--skip
100 S root 19603 19316 0 70 0 - 406 pipe_w 10:27 pts/2 00:00:00
grep my
------------- Output from last lines of strace ----------------
19255 clone(child_stack=0x83a8c38,
flags=CLONE_VM|CLONE_FS|CLONE_FILES|CLONE_SIGHAND) = 19256
19255 write(4, "\v\0\0\0\5\0\0\0\1\0\0\0\0\0\0\2\0\0\0\0/\0\0\0\20\27\0"
..., 148) = 148
19255 rt_sigprocmask(SIG_SETMASK, NULL, [HUP QUIT PIPE TERM TSTP RT_0],
8) = 0
19255 write(4, "[EMAIL PROTECTED]"
..., 148) = 148
19255 rt_sigprocmask(SIG_SETMASK, NULL, [HUP QUIT PIPE TERM TSTP RT_0],
8) = 0
19255 rt_sigsuspend([HUP QUIT PIPE TERM TSTP]
------------- End ----------------
A quick google search on rt_sigsuspend indicates that the pthreads
library may be at fault.
>How-To-Repeat:
scripts/mysql_install_db
>Fix:
>Submitter-Id: <submitter ID>
>Originator: root
>Organization:
>MySQL support: none
>Synopsis: mysql_install_db hangs
>Severity: critical
>Priority: high
>Category: mysql
>Class: sw-bug
>Release: mysql-4.0.11-gamma-standard (Official MySQL-standard binary)
>C compiler: 2.95.3
>C++ compiler: 2.95.3
>Environment:
System: Linux island.dyksterhouse.org 2.4.2-2 #1 Sun Apr 8 20:41:30 EDT 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-redhat-linux/2.96/specs
gcc version 2.96 20000731 (Red Hat Linux 7.1 2.96-81)
Compilation info: CC='gcc' CFLAGS='-O2 -mcpu=pentiumpro' CXX='gcc' CXXFLAGS='-O2
-mcpu=pentiumpro -felide-constructors' LDFLAGS='' ASFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 19 Feb 12 2002 /lib/libc.so.5 ->
/lib/libc.so.5.3.12
-rwx------ 1 root root 699832 Feb 12 2002 /lib/libc.so.5.3.12
lrwxrwxrwx 1 root root 13 Jul 26 2001 /lib/libc.so.6 -> libc-2.2.2.so
-rwxr-xr-x 1 root root 1236396 Apr 6 2001 /lib/libc-2.2.2.so
-rw-r--r-- 1 root root 26350254 Apr 6 2001 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Apr 6 2001 /usr/lib/libc.so
Configure command: ./configure '--prefix=/usr/local/mysql' '--with-comment=Official
MySQL-standard binary' '--with-extra-charsets=complex'
'--with-server-suffix=-standard' '--enable-thread-safe-client' '--enable-local-infile'
'--enable-assembler' '--disable-shared' '--with-client-ldflags=-all-static'
'--with-mysqld-ldflags=-all-static' '--with-innodb' 'CFLAGS=-O2 -mcpu=pentiumpro'
'CXXFLAGS=-O2 -mcpu=pentiumpro -felide-constructors' 'CXX=gcc'
---------------------------------------------------------------------
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
