[Xapian-discuss] database error

Frank J Bruzzaniti frank.bruzzaniti at gmail.com
Tue Feb 17 23:47:28 GMT 2009


Guys,

I had just patched my code to take advantage of last_mod.  Not sure if 
it had anything to do with it but I couldn't access my default database 
"default" with omega. 

My setup:

xapian 1.10
OpenSuse 11.1

I merge 2 databases into 1 to create default.

I tried to get some diagnostics via delve and xapian-check which I've 
posted bellow.  On deletion and recreation of default it came good.
I've kept a copy of the bad database just incase you want me to do any 
further diagnostics.

support at axis:/opt/omega/data> delve default
Error opening database `default': DatabaseCorruptError: Cannot open 
tables at consistent revisions



support at axis:/opt/omega/data> xapian-check default_bad
record:
baseB blocksize=8K items=31057 lastblock=1350 revision=1 levels=2 root=588
B-tree checked okay
record table structure checked OK

termlist:
baseB blocksize=8K items=31057 lastblock=80706 revision=1 levels=2 root=592
B-tree checked okay
termlist table structure checked OK

postlist:
baseB blocksize=8K items=29278706 lastblock=185479 revision=1 levels=3 
root=182039
B-tree checked okay
postlist table structure checked OK

position:
baseB blocksize=8K items=34484849 lastblock=135091 revision=1 levels=2 
root=467
B-tree checked okay
position table structure checked OK

value:
baseB blocksize=8K items=31057 lastblock=137 revision=1 levels=1 root=2
B-tree checked okay
value table structure checked OK

spelling:
Lazily created, and not yet used.

synonym:
Lazily created, and not yet used.

No errors found




More information about the Xapian-discuss mailing list