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
