Hi! I have the same problem in my new Red Hat 8.0 / Athlon 1.8 GHz laptop.
If I build MySQL-4.0.10 from source with ./BUILD/compile-pentium-debug it crashes in installing MySQL system tables. If I use a MySQL binary distro to install the system tables, then the mysqld I built may crash in mysqladmin shutdown or SHOW TABLES. I guess this is yet another problem with thread stack size overruns and the glibc in Red Hat 8.0, or a bug in gcc-3.2. MySQL AB's official binaries work fine. Regards, Heikki Innobase Oy sql query ................. Subject: Re: Red Hat 8.0 compile problems with 4.0.10 From: Mark Matthews Date: Sun, 16 Feb 2003 16:10:51 -0600 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Mark T. Dame wrote: > On 2/16/03 8:40 AM, Mark Matthews wrote: > >> -----BEGIN PGP SIGNED MESSAGE----- >> Hash: SHA1 >> >> Mark T. Dame wrote: >> >>> On 2/15/03 1:25 AM, Duncan Maitland wrote: >>> >>>> 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. >>> >>> >>> >>> >>> This is a "known" problem (in that I've seen several people post >>> about it, including myself), but I have not seen any answers other >>> than "use the binary distribution or binary RPMS". I have >>> successfully tested the RPM distribution, but I would prefer to use >>> the source. >>> >>> >>>> As far as I can tell this is a compiling or linking problem. >>> >>> >>> >>> >>> From what I've been able to figure out, the MySQL server will start >>> up, but when you attempt to connect to it, it seg vaults. I haven't >>> had time to track it down, but it doesn't appear to be a simple >>> resolver library problem, as I've seen suggested. Also, 4.0.10 is >>> increases the thread-stack size, supposedly to fix this (or maybe a >>> related) problem. It hasn't helped, as far as I can tell. >>> >>> Anyway, I would be interested in an answer to this as well. >> >> >> >> I just tried compiling and using MySQL-4.0.11 (from the BitKeeper >> repository) on RedHat 8.0, and this problem seems to have gone away: > > > Can you repeat the problem using 4.0.10? Nope. From a source install of MySQL-4.0.10 on RH-8.0: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 to server version: 4.0.10-gamma Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> status; - -------------- /usr/local/mysql/mysql-4.0.10/bin/mysql Ver 12.17 Distrib 4.0.10-gamma, for intel-linux (i686) Connection id: 3 Current database: Current user: [EMAIL PROTECTED] SSL: Not in use Current pager: stdout Using outfile: '' Server version: 4.0.10-gamma Protocol version: 10 Connection: 127.0.0.1 via TCP/IP Client characterset: latin1 Server characterset: latin1 TCP port: 3308 Uptime: 46 sec Threads: 1 Questions: 13 Slow queries: 0 Opens: 12 Flush tables: 1 Open tables: 1 Queries per second avg: 0.283 - -------------- mysql> show variables like '%stack%'; +---------------+--------+ | Variable_name | Value | +---------------+--------+ | thread_stack | 196608 | +---------------+--------+ 1 row in set (0.00 sec) mysql> It seems that the thread stack is set to 192K by default in 4.0.10. -Mark - -- MySQL 2003 Users Conference -> http://www.mysql.com/events/uc2003/ For technical support contracts, visit https://order.mysql.com/?ref=mmma __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mark Matthews <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA <___/ www.mysql.com --------------------------------------------------------------------- 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
