Re[2]: Trouble with mysql

[Peter Zaitsev <pz@xxxxxxxxx>]

Hello Michael,

Thursday, June 28, 2001, 11:41:57 PM, you wrote:

I'm getting this again and again with two tables which are used in
quite the same fation - some selects, often updates, rare inserts,  no
deletes:




mysql> repair table counter.quickstat;
+-------------------+--------+----------+----------------------------------------------+
| Table             | Op     | Msg_type | Msg_text                                     |
+-------------------+--------+----------+----------------------------------------------+
| counter.quickstat | repair | warning  | Number of rows changed from 168034 to 168022 |
| counter.quickstat | repair | status   | OK                                           |
+-------------------+--------+----------+----------------------------------------------+
2 rows in set (10.72 sec)

mysql> check table counter.counterlayers type=EXTENDED;
+-----------------------+-------+----------+-------------------------------------------------------+
| Table                 | Op    | Msg_type | Msg_text                                              |
+-----------------------+-------+----------+-------------------------------------------------------+
| counter.counterlayers | check | error    | Record-count is not ok; is 168138   Should be: 168181 |
| counter.counterlayers | check | warning  | Found 43 deleted blocks       Should be: 0            |
| counter.counterlayers | check | error    | Corrupt                                               |
+-----------------------+-------+----------+-------------------------------------------------------+
3 rows in set (2.51 sec)

mysql> repair table counter.counterlayers;                      
+-----------------------+--------+----------+----------------------------------------------+
| Table                 | Op     | Msg_type | Msg_text                                     |
+-----------------------+--------+----------+----------------------------------------------+
| counter.counterlayers | repair | warning  | Number of rows changed from 168181 to 168138 |
| counter.counterlayers | repair | status   | OK                                           |
+-----------------------+--------+----------+----------------------------------------------+
2 rows in set (1.55 sec)




MW> Any change you can start mysqld with --log-bin, so that you can verify
MW> this if this happens again?

It's allready running in such mode. I've checked the logs for delete
statements - there are not any of them.

Now I've started .38 version to check if it's mysql fault.




-- 
Best regards,
 Peter                            mailto:pz@xxxxxxxxx


---------------------------------------------------------------------
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-thread78167@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php