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
