RV: Assertion failure with MySQL 4.0.3/InnoDB

2002-09-23 Thread jesus

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




Re: Assertion failure with MySQL 4.0.3/InnoDB

2002-09-23 Thread Heikki Tuuri

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