restore table error: wrong number of deleted records

[Thomas Walter]

Hi!

Has anybody run into this?
We backed up a MyISAM Table using "BACKUP TABLE" while other
processes created a larger load of INSERTs, DELETEs, UPDATEs,
and SELECTs against this table.
BACKUP TABLE returned with "OK".
We generated several backups of the same table at different times.
Upon restoring them, for some of these backups we got following
error messages:
| sqltest1.sim | repair  | error    | Couldn't fix table with quick recovery: Found 
wrong number of deleted records |
| sqltest1.sim | repair  | error    | Run recovery again without -q                    
                             |
| sqltest1.sim | restore | status   | OK
After that, the table seemed to be usable again without further
action from our side. Anyway, we wonder why the messages occur.
We are pretty sure that we did all the Locking and Flushing correctly
according to the Manual.
This occurred with MySQL Versions 3.23.52 and 4.0.13 on SuSE Linux 8.1

Thanks in advance for any help!

Thomas

--
SIGOS Systemintegration GmbH
 - TESTING IS OUR COMPETENCE -
Fon +49 911 95168-0
www.sigos.de
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]