Bret Miller wrote:
I used to have problems with bayes locking and journaling. When it
finally corrupted the database, I decided it was time to put
it into a
real SQL database instead of using DB_File. Haven't had a
single problem
with bayes CPU or locking since.
Maybe it's time you consider using MySQL?
Bret
Well, if it solves the problem I'm ready to try almost anything. :)
The way you put your words tells me that the problem IS a
corrupt database.
Can we be certain? And is there any way fo fix it until I can
get MySQL up 'n running?
If the database is corrupted, it should say so. In my case, it wouldn't
expire, learn, sync, or use the db_file database because it ended up
corrupted somehow. I could have restored it from backup, but chose to
simply delete it and start over with SQL.
...
Bret
Well, I've let "sa-learn --force-expire --showdots" run for 19 hours now
(even on a separate machine), 100% cpu util all the time, and not a
single dot has appeared on the screen.
If I can't get to understand how to use db_recover, wiping is the next step.
Regards,
Andreas
