I am having trouble compiling a custom mysqld (version 4.0.10) under Red Hat 8.0 - I did email this list a few weeks ago and I have tried a few things since then but I am asking again in the hope that someone more knowledgeable might be able to help.
As far as I can tell this is a compiling or linking problem. System information: The system is a dual AMD Athlon MP 1800+ on a Tyan S2466 mainboard with 1GB ram and 1GB swap. The system is using an Adaptec 2400A ATA RAID card. Operating system: Standard installation of Red Hat Linux 8.0 - kernel is 2.4.18-14smp My configure line: ./configure --prefix=/usr/local/mysql-4.0.10 --localstatedir=/home/database/mysql-4.0.10 --enable-assembler --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --enable-thread-safe-client --with-extra-charsets=complex --with-debug --with-tcp-port=3307 --with-unix-socket-path=/tmp/mysql-4.0.10.sock The problem surfaces when the mysql_install_db script attempts to install the prepared grant tables. Output is as follows: [root@jupiter mysql-4.0.10-gamma]# ./scripts/mysql_install_db --defaults-file=/etc/mysql/mysql-4.0.10.cnf 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 against 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=268435456 read_buffer_size=1044480 sort_buffer_size=1048568 max_used_connections=0 max_connections=100 threads_connected=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 466543 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=0x83e3718 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... Cannot determine thread, fp=0xbf5fefb8, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x8089d51 0x823f280 0x825dc8d 0x822fe03 0x80ab6de 0x8095113 0x823a6d5 0x827669a ./scripts/mysql_install_db: line 1: 18414 Segmentation fault /usr/local/mysql-4.0.10/libexec/mysqld --defaults-file=/etc/mysql/mysql-4.0.10.cnf --log --debug --bootstrap --skip-grant-tables --basedir=/usr/local/mysql-4.0.10 --datadir=/home/database/mysql-4.0.10 --skip-innodb --skip-bdb Installation of grant tables failed! Examine the logs in /home/database/mysql-4.0.10 for more information. You can also try to start the mysqld daemon with: /usr/local/mysql-4.0.10/libexec/mysqld --skip-grant & You can use the command line tool /usr/local/mysql-4.0.10/bin/mysql to connect to the mysql database and look at the grant tables: shell> /usr/local/mysql-4.0.10/bin/mysql -u root mysql mysql> show tables Try 'mysqld --help' if you have problems with paths. Using --log gives you a log in /home/database/mysql-4.0.10 that may be helpful. The latest information about MySQL is available on the web at http://www.mysql.com Please consult the MySQL manual section: 'Problems running mysql_install_db', and the manual section that describes problems on your OS. Another information source is the MySQL email archive. Please check all of the above before mailing us! And if you do mail us, you MUST use the /usr/local/mysql-4.0.10/bin/mysqlbug script! [root@jupiter mysql-4.0.10-gamma]# The stack trace resolved as follows: 0x8089d51 handle_segfault + 431 0x823f280 __pthread_sighandler + 116 0x825dc8d vfprintf + 8057 0x822fe03 _db_doprnt_ + 189 0x80ab6de _Z19close_thread_tablesP3THDb + 290 0x8095113 handle_bootstrap + 779 0x823a6d5 pthread_start_thread + 177 0x827669a thread_start + 4 If anyone has any ideas, or even better, if anyone has a solution to this problem then please reply to this post. Many thanks, Duncan Maitland [EMAIL PROTECTED] --------------------------------------------------------------------- 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