Re: InnoDB: Assertion failure in file ha_innodb.cc line 2180...

2002-09-26 Thread Jocelyn Fournier
;[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; > <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Thursday, September 26, 2002 9:53 PM > Subject: Re: InnoDB: Assertion failure in file ha

Re: InnoDB: Assertion failure in file ha_innodb.cc line 2180...

2002-09-26 Thread Heikki Tuuri
<[EMAIL PROTECTED]> Sent: Thursday, September 26, 2002 9:53 PM Subject: Re: InnoDB: Assertion failure in file ha_innodb.cc line 2180... > Heikki, Jeremy, > > FYI, I've just tested latest pull (including Monty's patch) without Heikki > 1.1318 changeset (Remove the flag HA_N

Re: InnoDB: Assertion failure in file ha_innodb.cc line 2180...

2002-09-26 Thread Jocelyn Fournier
r 26, 2002 8:39 PM > Subject: Re: InnoDB: Assertion failure in file ha_innodb.cc line 2180... > > > > Jeremy, > > > > ----- Original Message - > > From: "Jeremy Zawodny" <[EMAIL PROTECTED]> > > To: "Heikki Tuuri" <[EMAIL PROTECTED]&

Re: InnoDB: Assertion failure in file ha_innodb.cc line 2180...

2002-09-26 Thread Jocelyn Fournier
L PROTECTED]> To: <[EMAIL PROTECTED]> Cc: "Jocelyn Fournier" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, September 26, 2002 8:39 PM Subject: Re: InnoDB

Re: InnoDB: Assertion failure in file ha_innodb.cc line 2180...

2002-09-26 Thread Heikki Tuuri
;[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, September 26, 2002 8:25 PM Subject: Re: InnoDB: Assertion failure in file ha_innodb.cc line 2180... > On Wed, Sep 25, 2002 at 09:43:13PM +0300, Heikki Tuuri wrote: > > Jocelyn, > > > > below the latest patch whi

Re: InnoDB: Assertion failure in file ha_innodb.cc line 2180...

2002-09-26 Thread Jeremy Zawodny
On Wed, Sep 25, 2002 at 09:43:13PM +0300, Heikki Tuuri wrote: > Jocelyn, > > below the latest patch which puts the code as it was in 4.0.3. Some LIKE > 'abc%' ... DESC queries may return wrong results, but this is the best we > can get to 4.0.4. > > I have to ask Monty about the use of HA_READ_P

Re: InnoDB: Assertion failure in file ha_innodb.cc line 2180...

2002-09-25 Thread Heikki Tuuri
hat search flag. - Original Message - From: "Jocelyn Fournier" <[EMAIL PROTECTED]> To: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, September 25, 2002 9:04 PM Subject: Re: InnoDB: Assertion failure in

Re: InnoDB: Assertion failure in file ha_innodb.cc line 2180...

2002-09-25 Thread Jocelyn Fournier
, Jocelyn - Original Message - From: "Heikki Tuuri" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, September 25, 2002 7:09 PM Subject: Re: InnoDB: Assertion failure in file ha_innodb.cc line 21

Re: InnoDB: Assertion failure in file ha_innodb.cc line 2180...

2002-09-25 Thread Jeremy Zawodny
On Wed, Sep 25, 2002 at 08:09:08PM +0300, Heikki Tuuri wrote: > Jeremy, Jocelyn, > > can you try the following this patch? I'm building a new binary row. > The flag which bans MySQL using a descending cursor to calculate > > column LIKE 'jhghj%' ORDER BY column DESC > > queries was apparently

Re: InnoDB: Assertion failure in file ha_innodb.cc line 2180...

2002-09-25 Thread Heikki Tuuri
uint max_record_length() const { return HA_MAX_REC_LENGTH; } uint max_keys() const { return MAX_KEY; } - Original Message - From: "Jeremy Zawodny" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, September 25, 2002 6

Re: InnoDB: Assertion failure in file ha_innodb.cc line 2180...

2002-09-25 Thread Jocelyn Fournier
2002 5:19 PM Subject: InnoDB: Assertion failure in file ha_innodb.cc line 2180... > Heikki and others, > > One of my slaves is dying frequently. It runs MySQL 4.0.4 (pulled > yesterday) on FreeBSD. I'm getting an assertion failure on line 2180, > which appears to be: > >

InnoDB: Assertion failure in file ha_innodb.cc line 2180...

2002-09-25 Thread Jeremy Zawodny
Heikki and others, One of my slaves is dying frequently. It runs MySQL 4.0.4 (pulled yesterday) on FreeBSD. I'm getting an assertion failure on line 2180, which appears to be: case HA_READ_PREFIX_LAST: ut_a(0); return(PAGE_CUR_LE); What can I do to help debug this? Thanks, Jeremy -- J