crashes of mysql-4.0.3-BK

Hi,
I had a look after a long while on our linux mysql server
and found in errorlog file some stack traces:

0x806ebdb handle_segfault__Fi + 447
0x8261718 pthread_sighandler + 184
0x828cfa3 memcpy + 51
0x8229390 _mi_pack_get_block_info + 316
0x8228211 _mi_read_pack_record + 53
0x8221ba8 mi_rkey + 520
0x80c19bf index_read_idx__9ha_myisamPcUiPCcUi16ha_rkey_function + 59
0x8099f02 join_read_const__FP13st_join_table + 102
0x8099cf9 join_read_const_table__FP13st_join_tableP11st_position + 85
0x8092b20 make_join_statistics__FP4JOINP13st_table_listP4ItemP16st_dyn amic_array + 2096
0x809102d mysql_select__FP3THDP13st_table_listRt4List1Z4ItemP4ItemP8st _orderT4T3T4UlP13select_result + 1997
0x8090826 handle_select__FP3THDP6st_lexP13select_result + 102
0x807888a mysql_execute_command__Fv + 950
0x807c76a mysql_parse__FP3THDPcUi + 146
0x807799b dispatch_command__F19enum_server_commandP3THDPcUi + 1447
0x80773e5 do_command__FP3THD + 93
0x8076c2e handle_one_connection__FPv + 674
0x825edfc pthread_start_thread + 204
0x82941fa thread_start + 4

thd->query at 0xc4dbff0 = select code,contig_data_code from known3d_data where id=13797

How-To-Repeat:

Those other two crashes have same stacktrace and were caused by same SQL query.
We have Ver 4.0.3-beta for pc-linux-gnu on i686, if I remember right
it's a bitkeeper snapshot just after you have fixed "show open tables".
Binaries have timestamp Aug 24 16:39.

I'll upgrade to 4.0.4, but maybe you want to have brief look at this.
Linux 2.4.20-pre5-ac1 #1 SMP

--
Martin Mokrejs ,
PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs
MIPS / Institute for Bioinformatics
GSF - National Research Center for Environment and Health
Ingolstaedter Landstrasse 1, D-85764 Neuherberg, Germany
tel.: +49-89-3187 3683 , fax: +49-89-3187 3585


------------------------------------------------------------ ---------
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 bugs-thread12715@lists.mysql.com
To unsubscribe, e-mail

Re: crashes of mysql-4.0.3-BK

=3D?iso-8859-2?Q?Martin_MOKREJ=3DA9?=3D writes:
> Hi,
> I had a look after a long while on our linux mysql server
> and found in errorlog file some stack traces:
>

[skip]
=20
> I'll upgrade to 4.0.4, but maybe you want to have brief look at this.=

> Linux 2.4.20-pre5-ac1 #1 SMP
>=20
> --=20
> Martin Mokrejs ,
> PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs
> MIPS / Institute for Bioinformatics
> GSF - National Research Center for Environment and Health
> Ingolstaedter Landstrasse 1, D-85764 Neuherberg, Germany
> tel.: +49-89-3187 3683 , fax:=A0+49-89-3187 3585
>=20

There was a similar crash reported recently which should be fixed
today in our BK 4.0 repository.

We would be gratefull if you could get tomorrow our latest code and
test if it works now.

--=20
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic >
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ 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 bugs-thread12719@lists.mysql.com
To unsubscribe, e-mail

Re: crashes of mysql-4.0.3-BK

Hi!

>>>>> "Sinisa" == Sinisa Milivojevic writes:

Sinisa> =3D?iso-8859-2?Q?Martin_MOKREJ=3DA9?=3D writes:
>> Hi,
>> I had a look after a long while on our linux mysql server
>> and found in errorlog file some stack traces:
>>=20

Sinisa> [skip]
=20
>> I'll upgrade to 4.0.4, but maybe you want to have brief look at this=
..
>> Linux 2.4.20-pre5-ac1 #1 SMP
>>=20
>> --=20
>> Martin Mokrejs ,
>> PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs
>> MIPS / Institute for Bioinformatics
>> GSF - National Research Center for Environment and Health
>> Ingolstaedter Landstrasse 1, D-85764 Neuherberg, Germany
>> tel.: +49-89-3187 3683 , fax:=A0+49-89-3187 3585
>>=20

Sinisa> There was a similar crash reported recently which should be fix=
ed
Sinisa> today in our BK 4.0 repository.

Sinisa is almost right :)

I have just fixed this in the 3.23 repository. I will tomorrow (it's
3.00 AM here now) merge this to the 4.0 repository and push it.
So please wait until tomorrow evening before trying the new bk code...

Regards,
Monty

--=20
For technical support contracts, goto https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Michael Widenius
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO
/_/ /_/\_, /___/\___\_\___/ Helsinki, Finland
<___/ 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 bugs-thread12727@lists.mysql.com
To unsubscribe, e-mail

Re: crashes of mysql-4.0.3-BK

Hi,
so I'm trying to test current BK tree, but have the following problem:

/scratch/mysql-4.0$ aclocal
aclocal: configure.in: 164: macro `AM_PROG_LIBTOOL' not found in library
aclocal: configure.in: 450: macro `AM_PROG_AS' not found in library
/scratch/mysql-4.0$ aclocal --version
aclocal (GNU automake) 1.4-p6

Copyright (C) 1999, 2001 Free Software Foundation, Inc.
This is free software; see the source for copying conditions. There is NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

Written by Tom Tromey
/scratch/mysql-4.0$ autoheader
WARNING: Using auxiliary files such as `acconfig.h', `config.h.bot'
WARNING: and `config.h.top', to define templates for `config.h.in'
WARNING: is deprecated and discouraged.

WARNING: Using the third argument of `AC_DEFINE' and
WARNING: `AC_DEFINE_UNQUOTED' allows to define a template without
WARNING: `acconfig.h':

WARNING: AC_DEFINE([NEED_MAIN], 1,
WARNING: [Define if a function `main' is needed.])

WARNING: More sophisticated templates can also be produced, see the
WARNING: documentation.
configure.in:2429: error: `os2/Makefile' is already registered with AC_CONFIG_FILES.
autoconf/status.m4:844: AC_CONFIG_FILES is expanded from...
configure.in:2429: the top level
autom4te: /usr/bin/m4 failed with exit status: 1
autoheader: /usr/bin/autom4te failed with exit status: 1
/scratch/mysql-4.0$ autoheader --version
autoheader (GNU Autoconf) 2.54
Written by Roland McGrath and Akim Demaille.

Copyright 2002 Free Software Foundation, Inc.
This is free software; see the source for copying conditions. There is NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
/scratch/mysql-4.0$


--
Martin Mokrejs ,
PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs
MIPS / Institute for Bioinformatics
GSF - National Research Center for Environment and Health
Ingolstaedter Landstrasse 1, D-85764 Neuherberg, Germany
tel.: +49-89-3187 3683 , fax: +49-89-3187 3585


------------------------------------------------------------ ---------
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 bugs-thread12771@lists.mysql.com
To unsubscribe, e-mail

Re: crashes of mysql-4.0.3-BK

Hi!

>>>>> "Martin" == Martin MOKREJ writes:

Martin> Hi,
Martin> so I'm trying to test current BK tree, but have the following problem:

Martin> /scratch/mysql-4.0$ aclocal
Martin> aclocal: configure.in: 164: macro `AM_PROG_LIBTOOL' not found in library
Martin> aclocal: configure.in: 450: macro `AM_PROG_AS' not found in library
Martin> /scratch/mysql-4.0$ aclocal --version
Martin> aclocal (GNU automake) 1.4-p6

For MySQL 4.0 and 4.1 you need automate 1.5.

We plan to soon update also MySQL 3.23 to automake 1.5
....

Regards,
Monty
CTO of MySQL AB

------------------------------------------------------------ ---------
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 bugs-thread12785@lists.mysql.com
To unsubscribe, e-mail

Re: crashes of mysql-4.0.3-BK

On Fri, 18 Oct 2002, Michael Widenius wrote:

>
> Hi!
>
> >>>>> "Martin" == Martin MOKREJ writes:
>
> Martin> Hi,
> Martin> so I'm trying to test current BK tree, but have the following problem:
>
> Martin> /scratch/mysql-4.0$ aclocal
> Martin> aclocal: configure.in: 164: macro `AM_PROG_LIBTOOL' not found in library
> Martin> aclocal: configure.in: 450: macro `AM_PROG_AS' not found in library
> Martin> /scratch/mysql-4.0$ aclocal --version
> Martin> aclocal (GNU automake) 1.4-p6
>
> For MySQL 4.0 and 4.1 you need automate 1.5.

/scratch/mysql-4.0# hash -r
/scratch/mysql-4.0# aclocal
/scratch/mysql-4.0# autoheader
WARNING: Using auxiliary files such as `acconfig.h', `config.h.bot'
WARNING: and `config.h.top', to define templates for `config.h.in'
WARNING: is deprecated and discouraged.

WARNING: Using the third argument of `AC_DEFINE' and
WARNING: `AC_DEFINE_UNQUOTED' allows to define a template without
WARNING: `acconfig.h':

WARNING: AC_DEFINE([NEED_MAIN], 1,
WARNING: [Define if a function `main' is needed.])

WARNING: More sophisticated templates can also be produced, see the
WARNING: documentation.
autoheader: `config.h.in' is unchanged
/scratch/mysql-4.0# autoconf
/scratch/mysql-4.0# automake
sql/Makefile.am:96: `YFLAGS' is a user variable, you should not override it;
sql/Makefile.am:96: use `AM_YFLAGS' instead.
/scratch/mysql-4.0# hash
hits command
1 /usr/local/bin/autoheader
1 /usr/local/bin/aclocal
1 /usr/local/bin/autoconf
1 /usr/local/bin/automake
/scratch/mysql-4.0# /usr/local/bin/automake --version
automake (GNU automake) 1.7
[...]

Is that clear?
--
Martin Mokrejs ,
PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs
MIPS / Institute for Bioinformatics
GSF - National Research Center for Environment and Health
Ingolstaedter Landstrasse 1, D-85764 Neuherberg, Germany
tel.: +49-89-3187 3683 , fax: +49-89-3187 3585


------------------------------------------------------------ ---------
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 bugs-thread12788@lists.mysql.com
To unsubscribe, e-mail

Re: crashes of mysql-4.0.3-BK

Hi!

>>>>> "Martin" == Martin MOKREJ writes:

Martin> On Fri, 18 Oct 2002, Michael Widenius wrote:
>>
>> Hi!
>>
>> >>>>> "Martin" == Martin MOKREJ writes:
>>
Martin> Hi,
Martin> so I'm trying to test current BK tree, but have the following problem:
>>
Martin> /scratch/mysql-4.0$ aclocal
Martin> aclocal: configure.in: 164: macro `AM_PROG_LIBTOOL' not found in library
Martin> aclocal: configure.in: 450: macro `AM_PROG_AS' not found in library
Martin> /scratch/mysql-4.0$ aclocal --version
Martin> aclocal (GNU automake) 1.4-p6
>>
>> For MySQL 4.0 and 4.1 you need automate 1.5.

Martin> /scratch/mysql-4.0# hash -r
Martin> /scratch/mysql-4.0# aclocal
Martin> /scratch/mysql-4.0# autoheader
Martin> WARNING: Using auxiliary files such as `acconfig.h', `config.h.bot'
Martin> WARNING: and `config.h.top', to define templates for `config.h.in'
Martin> WARNING: is deprecated and discouraged.




Martin> /scratch/mysql-4.0# /usr/local/bin/automake --version
Martin> automake (GNU automake) 1.7
Martin> [...]

Martin> Is that clear?

Yes; MySQL is not tested with automake 1.7; For MySQL 4.0 you have to
use automake 1.5, not 1.4 or 1.7.

Regards,
Monty

------------------------------------------------------------ ---------
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 bugs-thread12808@lists.mysql.com
To unsubscribe, e-mail