mysql 3.23.55 broken if compiled with -all-static

mysql 3.23.55 broken if compiled with -all-static

Post by Carlo » Wed, 19 Feb 2003 03:58:47


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
 _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=

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=
the problem, but since we have already crashed, something is definitely=
and this may fail

It is possible that mysqld could use up to
key_buffer_size + (record_buffer + sort_buffer)*max_connections =3D 225791=
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:
Stack trace seems successful - bottom reached
Please read 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'

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
 _Z17add_field_to_listPc16enum_field_typesS_S_jP4ItemS_P10st_typelib + 310
0x8099310 _Z7yyparsev + 3376
0x8091f48 _Z16handle_bootstrapPv + 648

Any help would be apreciated.


Before posting, please check:   (the manual)           (the list archive)

Trouble unsubscribing? Try:


1. Cannot Restore MySQL 3.23.37 dump to Mysql 3.23.55

Content-Type: text/plain;
Content-Transfer-Encoding: quoted-printable

Im trying to restore a database dumb taken from a Sun Cobalt RAQ4 =
running Mysql 3.23.37 and restore it to a new Dell PowerEdge running =
Redhat 7.3 with Mysql 3.23.55.

I have tried from both the command line and using phpmyadmin
With Command line /usr/bin/mysql database -uuser -ppassword < =
/var/lib/mysql/mysql_database2003_0320.sql I get an error 1054 relating =
to a Colum count and field "net" which do not appear in the database =


This E-Mail is intended only for the=20
use of the individual or entity to which it is addressed and=20
may contain information that is privileged, confidential and=20
exempt from disclosure under applicable law.=20
If you have received this communication in error, please=20
do not distribute and delete the original message. =20
Please notify the sender by E-Mail at the address shown.=20
Thank you for your compliance.


2. Need advice on good 2-300$ ink jet printer..

3. RAND() Problems in mysql version 3.23.54 and 3.23.55 (linux)

4. Speech compression with GSM

5. mysql upgrade from 3.23.47 to 3.23.55 on Sun OS 5.8

6. Desktop Icons quit working

7. RAND() Problems in mysql version 3.23.54 and 3.23.55 (linux)

8. Umax Astra 2000u and driver problems

9. Compiling 3.23.55

10. MYSQL 3.23.55 Install Issues

11. MySQL 3.23.55 compilation errors

12. Possibly bug in InnoDB with mysql 3.23.55

13. MySQL 4.0 Slave to 3.23.55 master Replication