Richard,
----- Original Message -----
From: "Richard F. Rebel" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, June 04, 2003 8:38 PM
Subject: Re: RH 8.0 InnoDB: Assertion failure in thread 122911
infilemem0pool.c line 477
> Hello Heikki,
>
> On Wed, 2003-06-04 at 13:26, Heikki Tuuri wrote:
>
> > the memory deallocation seems to happen usually in
> >
> > "
> > if (prebuilt->blob_heap != NULL) {
> > mem_heap_free(prebuilt->blob_heap);
> > prebuilt->blob_heap = NULL;
> > }
> > "
> >
> > select MEET, count(*)
> > from RATINGS_WHENU
> > where MEET in ('N','Y')
> > and SITE = '63'
> > group by MEET
> >
> > You have BLOBs in the table? How big are they? What does SHOW CREATE
TABLE
> > give as the table definition?
> >
>
> mysql> show create table RATINGS_WHENU\G
> *************************** 1. row ***************************
> Table: RATINGS_WHENU
> Create Table: CREATE TABLE `RATINGS_WHENU` (
> `ID` int(11) NOT NULL auto_increment,
> `SITE` int(11) default NULL,
> `CLIENT_ID` varchar(64) default NULL,
> `STOCK` char(1) default NULL,
> `NAVIGATE` char(1) default NULL,
> `TIMELY` char(1) default NULL,
> `AGAIN` char(1) default NULL,
> `CUSTOMER` char(1) default NULL,
> `ENTERED_TIME` datetime default NULL,
> `FEEDBACK` text,
> `LAST_UPDATE` timestamp(14) NOT NULL,
> `MEET` char(1) default NULL,
> `CONTACTED` char(1) default NULL,
> `COMPLETE` char(1) default NULL,
> `SELECTION` char(1) default NULL,
> `PRICING` char(1) default NULL,
> PRIMARY KEY (`ID`)
> ) TYPE=InnoDB
> 1 row in set (0.02 sec)
>
> No blobs.
hmm... maybe mysqld is reporting a wrong query in a crash. Do you have any
BLOB (or TEXT) tables and what kind of queries you run on them? How big are
the BLOBs if any?
The hex dump looked like parts of some long CHAR or TEXT fiels.
By the way, you do not have an index on 'SITE' in the table. An index might
speed up your queries.
...
> Best,
>
> Richard
Regards,
Heikki
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
