somehow i've managed to corrupt my db - the error was
./src/pager.c:1179: syncJournal: Assertion `pPager->nRec*pgSz+hdrSz==jSz' failed.
running PRAGMA integrity_check yields something like
carp:~/eg/ruby/rq/rq-0.1.2 > sqlite q 'PRAGMA integrity_check' | head *** in database main *** On page 43 cell 0: Key is out of order On tree page 41: initPage() returns error code 11 rowid 1 missing from index jobs_jid_idx rowid 2 missing from index jobs_jid_idx rowid 3 missing from index jobs_jid_idx rowid 4 missing from index jobs_jid_idx rowid 5 missing from index jobs_jid_idx rowid 6 missing from index jobs_finished_idx rowid 6 missing from index jobs_jid_idx
is there a way to recover?
-a
--
===============================================================================
| EMAIL :: Ara [dot] T [dot] Howard [at] noaa [dot] gov
| PHONE :: 303.497.6469
| A flower falls, even though we love it;
| and a weed grows, even though we do not love it. | --Dogen
===============================================================================
