Very Computer

Hi,

Compilation of mysql 3.23.55 fails ONLY when using=
 "--with-mysqld-ldflags=3D-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:

Quote:>uname -a

Linux atlas 2.4.20 #1 Sat Feb 1 10:39:59 CET 2003 i586 unknown

glibc with libpthreads 2.3.1

Quote:> gcc -v

Reading specs from /usr/lib/gcc-lib/i586-pc-linux-gnu/3.2.1/specs
Configured with: ./configure --prefix=3D/usr --sysconfdir=3D/etc=
 --localstatedir=3D/var --enable-threads=3Dposix --with-gnu-ld=
 --enable-shared --enable-languages=3Dc,c++
Thread model: posix
gcc version 3.2.1

Compilation options:
CFLAGS=3D"-O3 -mcpu=3Dk6-2" CXX=3Dgcc CXXFLAGS=3D"-O3 -mcpu=3Dk6-2=
 -felide-constructors -fno-exceptions -fno-rtti" ./configure=
 --prefix=3D/usr/mysql --enable-thread-safe-client --enable-local-infile=
 --enable-assembler --with-berkeley-db --with-gnu-ld --libdir=3D/usr/lib=
 --includedir=3D/usr/include --mandir=3D/usr/man=
 --with-client-ldflags=3D-all-static --with-mysqld-ldflags=3D-all-static=
 --disable-shared

No errors, and compilation successfull.

But mysqld is broken:
When running "mysqld_install_db":

---------

Quote:> ./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=3D8388600
record_buffer=3D131072
sort_buffer=3D2097144
max_used_connections=3D0
max_connections=3D100
threads_connected=3D1
It is possible that mysqld could use up to
key_buffer_size + (record_buffer + sort_buffer)*max_connections =3D 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 =3D  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=3D'Database privileges'
thd->thread_id=3D1

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)

Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php