Have you tried ismchk/myismchk?
----- Original Message -----
From: "Artem Krsheminsky" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 11, 2001 2:01
Subject: simpe select return not all rows - and flush
> Hi
>
> i'm newbie and have the problem -
> sometimes after some INSERT and also sometimes just from nothing
> simple SELECT begin work not properly - it returns not all rows in the
table
> that must.
> in most cases FLUSH TABLES help, but yesterday it won't help - SELECT
> continue return empty result, until i restart mysql
>
> i looked into error log and found next for last case:
>
> bdb: Log sequence error: page LSN 1:2043982; previous LSN 1 2074929
> 010608 21:12:22 bdb: Log sequence error: page LSN 1:2043982; previous
LSN
> 1 2077028
> 010608 21:12:22 bdb: ./fly_db/airports.db: close: 2 blocks left pinned
>
> anyway after restart table data looked right and database work fine
>
> and nothing for prevoius cases where flush tables worked well
>
> i searched throught the mailing lists, but i don't found anything that can
> help me to understand the problem
>
> should i use flush table after every insert ?
> should i use variable in my.cnf to order mysql flush tables pereodicaly?
> or something else?
>
> also i do not found any help how to understand the error messages from BDB
> and what to do in this case?
>
> thnx
>
>
> ---------------------------------------------------------------------
> 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 <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php