List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:June 8 2001 8:03pm
Subject:Re: ISAMCHK error
View as plain text  
Never run isamchk with the server running.

Joan Vidal wrote:

> I can't believe MySQL is behaviouring that way and giving that kind of errors.
> I've tried MySQL versions 3.23.33 and 3.22.27 both in Solaris and RedHat linux,
> all with the same results.
> 
> Can anyone please help?
> 
> Thx in advance,
>     Joan
> 
> The tests consists in:
> * creating a table,
> * to insert 2 registers,
> * to erase 1 register,
> * and... in this point of it annoys everything.
>   TO PASS a ISAMCHK with option - r (to repair).
>   Once I throw this, the table is in a error state.
>   When I passed a SELECT count(*) gives 1 registry us,
>   and if we happened a SELECT * says that this vacia to us.
> 
> (To see results down)
> 
> 
> 
> 
> TEST:
> 
> DROP TABLE prueba;
> CREATE TABLE prueba (id bigint not null,nom varchar(100));
> INSERT INTO prueba VALUES (1,'ONE');
> INSERT INTO prueba VALUES (2,'TWO');
> DELETE FROM prueba WHERE id<2;
> select * from prueba;
> select count(*) from prueba;
> 
> 
> Exit MySQL and run :
> isamchk -r /D3/mysql.tables/joan/prueba
> 
> 
> Mysql:
> select * from prueba;
> select count(*) from prueba;
> 
> 
> 
> 
> 
> 
> 
> 
> 
> [root]# mysql test
> mysql> DROP TABLE prueba;
> Query OK, 0 rows affected (0.03 sec)
> 
> mysql> CREATE TABLE prueba (id bigint not null,nom varchar(100));
> Query OK, 0 rows affected (0.03 sec)
> 
> mysql> INSERT INTO prueba VALUES (1,'ONE');
> Query OK, 1 row affected (0.00 sec)
> 
> mysql> INSERT INTO prueba VALUES (2,'TWO');
> Query OK, 1 row affected (0.00 sec)
> 
> mysql> DELETE FROM prueba WHERE id<2;
> Query OK, 1 row affected (0.01 sec)
> 
> mysql> select * from prueba;
> +----+------+
> | id | nom  |
> +----+------+
> |  2 | TWO  |
> +----+------+
> 1 row in set (0.00 sec)
> 
> mysql> select count(*) from prueba;
> +----------+
> | count(*) |
> +----------+
> |        1 |
> +----------+
> 1 row in set (0.00 sec)
> 
> 
> [root]# isamchk -r prueba
> - recovering ISAM-table 'prueba.ISM'
> Data records: 1
> 
> 
> 
> ANY RECORDS IN DATABASE,
> BUT count(*) is 1.
> 
> [root]# mysql test
> mysql> select * from prueba;
> Empty set (0.00 sec)
> 
> mysql> select count(*) from prueba;
> +----------+
> | count(*) |
> +----------+
> |        1 |
> +----------+
> 1 row in set (0.00 sec)
> 
> mysql> 
> 
> 
> 
> ---------------------------------------------------------------------
> 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 <mysql-thread76018@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-- 
Gerald L. Clark
gerald_clark@stripped

Thread
ISAMCHK errorJoan Vidal8 Jun
  • Re: ISAMCHK errorGerald Clark8 Jun