Hi, Compilation of mysql 3.23.55 fails ONLY when using "--with-mysqld-ldflags=-all-static" results in broken mysqld. Segmentation fault? ----
Resolving stack trace: 0x808f4d4 _Z15handle_segfaulti + 404 0x81bc67a __pthread_sighandler + 122 0x81ceb4d __strtol_internal + 1421 0x8096cf6 _Z17add_field_to_listPc16enum_field_typesS_S_jP4ItemS_P10st_typelib + 310 0x8099310 _Z7yyparsev + 3376 0x8091f48 _Z16handle_bootstrapPv + 648 ---- If compiled with dynamic libraries, it works fine. Some info: >uname -a Linux atlas 2.4.20 #1 Sat Feb 1 10:39:59 CET 2003 i586 unknown glibc with libpthreads 2.3.1 > gcc -v Reading specs from /usr/lib/gcc-lib/i586-pc-linux-gnu/3.2.1/specs Configured with: ./configure --prefix=/usr --sysconfdir=/etc --localstatedir=/var --enable-threads=posix --with-gnu-ld --enable-shared --enable-languages=c,c++ Thread model: posix gcc version 3.2.1 Compilation options: CFLAGS="-O3 -mcpu=k6-2" CXX=gcc CXXFLAGS="-O3 -mcpu=k6-2 -felide-constructors -fno-exceptions -fno-rtti" ./configure --prefix=/usr/mysql --enable-thread-safe-client --enable-local-infile --enable-assembler --with-berkeley-db --with-gnu-ld --libdir=/usr/lib --includedir=/usr/include --mandir=/usr/man --with-client-ldflags=-all-static --with-mysqld-ldflags=-all-static --disable-shared No errors, and compilation successfull. But mysqld is broken: When running "mysqld_install_db": --------- > ./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 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=8388600 record_buffer=131072 sort_buffer=2097144 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 = 225791 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: 0x808f4d4 0x81bc4ba 0x81ce98d 0x8096cf6 0x8099310 0x8091f48 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 0x8312678 = 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 Successfully dumped variables, if you ran with --log, take a look at the details of what thread 1 did to cause the crash. In some cases of really bad corruption, the values shown above may be invalid ... ---------- Resolving stack trace: 0x808f4d4 _Z15handle_segfaulti + 404 0x81bc67a __pthread_sighandler + 122 0x81ceb4d __strtol_internal + 1421 0x8096cf6 _Z17add_field_to_listPc16enum_field_typesS_S_jP4ItemS_P10st_typelib + 310 0x8099310 _Z7yyparsev + 3376 0x8091f48 _Z16handle_bootstrapPv + 648 Any help would be apreciated. Thanks --------------------------------------------------------------------- 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