Re: tablecrash on MySQL-Max-4.0.16

Vidar writes:
> 
> Hi
> 
> system : rh9
> mysql :
> MySQL-devel-4.0.16-0
> MySQL-shared-4.0.16-0
> MySQL-Max-4.0.16-0
> MySQL-client-4.0.16-0
> MySQL-server-4.0.16-0
> 
> We have a table 
> > desc ezsession;
> +-----------------+------------------+------+-----+---------+-------+
> | Field           | Type             | Null | Key | Default | Extra |
> +-----------------+------------------+------+-----+---------+-------+
> | session_key     | varchar(32)      |      | PRI |         |       |
> | expiration_time | int(11) unsigned |      | MUL | 0       |       |
> | data            | text             |      |     |         |       |
> | cache_mask_1    | int(11)          |      |     | 0       |       |
> +-----------------+------------------+------+-----+---------+-------+
> 
> This table is very often read/written to (only plain select, insert and update 
> queries, no joins). But sometimes it crashes. I have uploaded 
> tablecrash_max4016_full_processlist.tar.gz to your ftp account
> 
> The table locks, so a restart of mysql and a "repair table ezsession;" is 
> needed in order to make the table work again.

[skip]

> PS
> This is definitively  NOT a "disk full" problem
> 
> -- 
> Vidar Langseid
> 

HI!

Where exactly on our ftp site did you upload the above process list ??

Can you just send the relevant snippet form it ??

We can not deduce based on the above where to look at all in order to
find a cause of the problem.

Also, what does it mean "table locks" ?? All MyISAM tables are locked
with our queries.

Also, with 4.0.15 and up, all corruption reports so far, were traced
back to hardware problems or to bad built binary. 

It is also unclear from your report whether you use our binary or not.

This does not mean that the above is not a bug, 

Only that this is not a fully repeatable test case which will enable
us to corrupt table in each of it's runs.

-- 

Sincerely,

-- 
For technical support contracts, go to https://order.mysql.com/?ref=msmi
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Mr. Sinisa Milivojevic <[email protected]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB
/_/  /_/\_, /___/\___\_\___/   Fulltime Developer and Support Coordinator
       <___/   www.mysql.com   Larnaca, Cyprus


-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]