Hi, Just for information - the stack trace gives:
0x808fdfc _Z15handle_segfaulti + 460 0x815adb8 __pthread_sighandler + 116 0x8171636 __strtol_internal + 1390 0x8098378 _Z17add_field_to_listPc16enum_field_typesS_S_jP4ItemS_P10st_typelib + 344 0x809aacb _Z7yyparsev + 3419 0x8092cdd _Z16handle_bootstrapPv + 669 /Brian > -----Original Message----- > From: Brian Ipsen [mailto:[EMAIL PROTECTED]] > Sent: 8. december 2002 20:47 > To: [EMAIL PROTECTED] > Subject: mysql_installdb crashes on RedHat 8.0 ? > > > Hi! > > I just compiled 3.23.53 on my RedHat 8.0 box - but when trying > to start the > mysql daemon, my init.d script tries to initialize the required > tables. But > this fails: > > Preparing db table > Preparing host table > Preparing user table > Preparing func table > Preparing tables_priv table > Preparing columns_priv table > Installing all prepared tables > 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=67104768 > record_buffer=1044480 > sort_buffer=4194296 > max_used_connections=0 > max_connections=100 > threads_connected=1 > It is possible that mysqld could use up to > key_buffer_size + (record_buffer + sort_buffer)*max_connections = 577131 K > bytes of memory > Hope that's ok, if not, decrease some variables in the equation > > Attempting backtrace. You can use the following information to find out > where mysqld died. If you see no messages after this, something went > terribly wrong... > Stack range sanity check OK, backtrace follows: > 0x808fdfc > 0x815adb8 > 0x8171636 > 0x8098378 > 0x809aacb > 0x8092cdd > Stack trace seems successful - bottom reached > Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow > instructions on how to resolve the stack trace. Resolved > stack trace is much more helpful in diagnosing the problem, so please do > resolve it > Trying to get some variables. > Some pointers may be invalid and cause the dump to abort... > thd->query at 0x8287580 = CREATE TABLE db ( Host char(60) > binary DEFAULT > '' NOT NULL, Db char(64) binary DEFAULT '' NOT NULL, User char(16) > binary DEFAULT '' NOT NULL, Select_priv enum('N','Y') DEFAULT 'N' NOT > NULL, Insert_priv enum('N','Y') DEFAULT 'N' NOT NULL, Update_priv > enum('N','Y') DEFAULT 'N' NOT NULL, Delete_priv enum('N','Y') > DEFAULT 'N' > NOT NULL, Create_priv enum('N','Y') DEFAULT 'N' NOT NULL, Drop_priv > enum('N','Y') DEFAULT 'N' NOT NULL, Grant_priv enum('N','Y') DEFAULT 'N' > NOT NULL, References_priv enum('N','Y') DEFAULT 'N' NOT NULL, > Index_priv > enum('N','Y') DEFAULT 'N' NOT NULL, Alter_priv enum('N','Y') DEFAULT 'N' > NOT NULL, PRIMARY KEY Host (Host,Db,User), KEY User (User) ) > comment='Database privileges' > thd->thread_id=1 > > Some info from mysqlbug: > > >Release: mysql-3.23.53 (Source distribution) > > >Environment: > <machine, os, target, libraries (multiple lines)> > System: Linux laforge.andebakken.dk 2.4.18-18.8.0 #1 Thu Nov 14 > 00:10:29 EST > 2002 i686 i686 i386 GNU/Linux > 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/3.2/specs > Configured with: > ../configure --prefix=/usr --mandir=/usr/share/man > --infodir=/usr/share/info > --enable-shared --enable-threads=posix > --disable-checking --host=i386-redhat-linux --with-system-zlib > --enable-__c > xa_atexit > Thread model: posix > gcc version 3.2 20020903 (Red Hat Linux 8.0 3.2-7) > Compilation info: CC='gcc' > CFLAGS='-static -march=i686 -mcpu=i686 -funroll-loops' CXX='g++' > CXXFLAGS='-static -march=i686 -mcpu=i > 686 -funroll-loops -felide-constructors -fno-exceptions -fno-rtti' > LDFLAGS='' > LIBC: > lrwxrwxrwx 1 root root 14 Dec 8 18:25 /lib/libc.so.6 -> > libc-2.2.93.so > -rwxr-xr-x 1 root root 1235468 Sep 6 01:12 > /lib/libc-2.2.93.so > -rw-r--r-- 1 root root 2233342 Sep 6 00:59 /usr/lib/libc.a > -rw-r--r-- 1 root root 178 Sep 6 00:50 /usr/lib/libc.so > Configure command: > ./configure --prefix=/opt/mysql --libexecdir=/usr/sbin > --localstatedir=/opt/ > mysql --sysconfdir=/etc --mandir=/usr > /share/man --disable-shared --with-mysqld-user=mysql > --with-unix-socket-path > =/var/lib/mysql/mysql.sock --with-client-ldflags=-all-static > --with-mysqld-l > dflags=-all-static --without-debug --without-docs --without-bench > 'CFLAGS=-static -march=i686 -mcpu=i686 -funrol l-loops' > 'CXXFLAGS=-static -march=i686 -mcpu=i686 -funroll-loops > -felide-constructors > -fno-exceptions -fno-rtti' > > Does anyone know how I get this problem solved ?? Using the > Redhat supplied > mysql is not good enough for me, sine I need to have my files located in > another manner. > > Regards, > > /Brian > > > --------------------------------------------------------------------- > 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 > > --------------------------------------------------------------------- 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