MySQL 5.0.18 crashes

------_=_NextPart_001_01C6297E.7582BED9
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I need a little help with MySQL 5.0.18.
Its been running for about a week now and it has crashed every day, =
serveral times within a few hours just to run fine the rest of the day =
etc..
=20
I have checked the MyISAM tables serveraltimes and run the testscripts =
thats in the package.
I have also activated log and tried to run the ~10 last queries without =
any problem.
=20
The stacktrace is almost identical each crash and the first is a =
segfault?! if it is what is causing it?
=20
Hera are the last 2 stacktraces:
==================== =====3D=
==================== =====3D=
=======3D
0x81536e8 handle_segfault + 356
0x4ff3ac45 _end + 1201650805
0x8144541 _ZNK12Field_string4typeEv + 13
0x81a4689 _Z18create_ref_for_keyP4JOINP13st_join_tableP8keyuse_ty + 717
0x81a4326 _Z20get_best_combinationP4JOIN + 306
0x819ad18 =
_Z20make_join_statisticsP4JOINP13st_table_listP4ItemP16st_dy namic_array =
+ 2092
0x8191fb6 _ZN4JOIN8optimizeEv + 750
0x8195226 =
_Z12mysql_selectP3THDPPP4ItemP13st_table_listjR4ListIS1_ES2_ jP8st_orderSB=
_S2_SB_mP13select_resultP18st_select_lex_unitP13st_sel +
130
0x819135e _Z13handle_selectP3THDP6st_lexP13select_resultm + 234
0x8167301 _Z21mysql_execute_commandP3THD + 585
0x816e176 _Z11mysql_parseP3THDPcj + 306
0x8165c3e _Z16dispatch_command19enum_server_commandP3THDPcj + 1178
0x8165769 _Z10do_commandP3THD + 129
0x8164c71 handle_one_connection + 609
0x4ff34ca3 _end + 1201626323
0x500c9c97 _end + 1203285191
==================== =====3D=
==================== =====3D=
=======3D
0x81536e8 handle_segfault + 356
0x435aac45 _end + 990297205
0x8144541 _ZNK12Field_string4typeEv + 13
0x81a4689 _Z18create_ref_for_keyP4JOINP13st_join_tableP8keyuse_ty + 717
0x81a4326 _Z20get_best_combinationP4JOIN + 306
0x819ad18 =
_Z20make_join_statisticsP4JOINP13st_table_listP4ItemP16st_dy namic_array =
+ 2092
0x8191fb6 _ZN4JOIN8optimizeEv + 750
0x8195226 =
_Z12mysql_selectP3THDPPP4ItemP13st_table_listjR4ListIS1_ES2_ jP8st_orderSB=
_S2_SB_mP13select_resultP18st_select_lex_unitP13st_sel +
130
0x819135e _Z13handle_selectP3THDP6st_lexP13select_resultm + 234
0x8167301 _Z21mysql_execute_commandP3THD + 585
0x816e176 _Z11mysql_parseP3THDPcj + 306
0x8165c3e _Z16dispatch_command19enum_server_commandP3THDPcj + 1178
0x8165769 _Z10do_commandP3THD + 129
0x8164c71 handle_one_connection + 609
0x435a4ca3 _end + 990272723
0x43739c97 _end + 991931591
==================== =====3D=
==================== =====3D=
=======3D
=20
/Erik

=20


------_=_NextPart_001_01C6297E.7582BED9--

Re: MySQL 5.0.18 crashes

Hi Eric,

> I need a little help with MySQL 5.0.18.
> Its been running for about a week now and it has crashed every day,
serveral times within a few hours just to run fine the rest of the day etc..

> I have checked the MyISAM tables serveraltimes and run the testscripts
thats in the package.
> I have also activated log and tried to run the ~10 last queries without
any problem.

Please, open a bug report about this problem at http://bugs.mysql.com (or
just send me bug # if you did it already).

As I understood, you had enabled general query log. Have you found the exact
query that gives you this crash?

Please, upload the appropriate part of your error log and you my.cnf file to
the bug report. We'll try to figure out possible reasons for this bug there.

Last question: is it a fresh installation of 5.0.18 or you had upgraded it
from 4.x.y?

Best regards,

--
Valeriy Kravchuk, Support Engineer
MySQL AB, Kiev, Ukraine, www.mysql.com

Are you MySQL certified? www.mysql.com/certification


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org