I get the same error in my original process when starting another process which calls lock_detect on the same database. I suspect a problem with the python binding as the db_deadlock utility does not show the same behavior.<br>
<br><div class="gmail_quote">On Wed, Dec 3, 2008 at 8:58 PM, andrew <span dir="ltr"><<a href="mailto:andrew@reurbanise.co.nz">andrew@reurbanise.co.nz</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi All,<br>
<br>
I have a large-ish production database (1.6M objects) that usually gets<br>
accessed only for reads on writes on specific keys, for which it is nice<br>
and fast. However, I need to be able to do some adhoc queries on this<br>
data occasionally and I seem to be running into some problems doing<br>
that.<br>
<br>
My approach is simply to fetch all keys and then iterate through the<br>
keys, fetching the data for each key and then writing some of it to an<br>
output file. I want to do this while the database is still "up", i.e.,<br>
while a server process that allows access to the database via Pyro is<br>
still running. Unfortunately, when I run this scanning script (which<br>
takes minutes just to fetch all the keys) it seems to kill the Pyro<br>
process with:<br>
<br>
bsddb.db.DBRunRecoveryError: (-30978, 'DB_RUNRECOVERY: Fatal error, run<br>
database recovery -- PANIC: fatal region error detected; run recovery',<br>
'This error occured remotely (Pyro). Remote traceback is available.')<br>
<br>
My questions are:<br>
<br>
1. Is there a better way to do this ?<br>
2. Could it be some sort of locking problem ?<br>
3. Has anyone else done anything like this successfully ?<br>
<br>
Thanks for your help.<br>
<br>
Cheers, Andrew.<br>
<br>
_______________________________________________<br>
pybsddb mailing list<br>
<a href="mailto:pybsddb@argo.es">pybsddb@argo.es</a><br>
<a href="http://mailman.argo.es/listinfo/pybsddb" target="_blank">http://mailman.argo.es/listinfo/pybsddb</a><br>
<a href="http://www.argo.es/%7Ejcea/programacion/pybsddb.htm" target="_blank">http://www.argo.es/~jcea/programacion/pybsddb.htm</a><br>
</blockquote></div><br>