Jose,

if this occurs in an SQL query of type

... ORDER BY primarykey DESC

then this is probably the bug which is fixed in upcoming 4.0.4.

I hope 4.0.4 will be released in a few days.

Best regards,

Heikki
Innobase Oy

----- Original Message -----
From: ""jesus"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Monday, September 23, 2002 6:00 PM
Subject: RV: Assertion failure with MySQL 4.0.3/InnoDB


> Hello,
>
> Recently I have installed MySQL-Max 4.0.3 in my production server, and
> in the error log I found the following message (or very similar) several
> times:
>
> "InnoDB: Assertion failure in thread xxx in file btr0pcur.c line
> 203"
>
> Why takes place this crash?
>
> NOTE: Querys associated to crash dump are very trivial SELECT's that
> work OK in 3.23.52. The only similarity among them is the use of "ORDER
> BY DESC".
>
>
> Best regards,
>
>
> José Ceferino Ortega
>
> ---------------------------------------------------------------------
> 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
>
>



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

Reply via email to