<div dir="ltr">A workaround (which I had to use) is to ensure that any cursor you're going to join has at least one result (via count(), I think it was), only join those that do, and be sure to test for the case of having no such cursors.<br>
<br><div class="gmail_quote">On Mon, Oct 20, 2008 at 7:57 PM, Sury Soni <span dir="ltr"><<a href="mailto:ssoni@nextdigital.com">ssoni@nextdigital.com</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;">
<div link="blue" vlink="purple" lang="EN-AU">
<div>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">Hi All,</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">I am having issue in using joined cursor for indexed
database.</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">When, there are no records for given joined cursor, ideally,
jonedCursor.get(0) should return None or raise some exception.</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">But, in my case, I am getting </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">(-30975, 'DB_RUNRECOVERY: Fatal error, run database recovery
-- PANIC: Invalid argument')</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">Traceback (most recent call last):</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> File "dbNode.py", line 71, in next</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> data = self.joinedCursor.get(0)</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">Later, </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">Exception in destroy: (-30975, 'DB_RUNRECOVERY: Fatal
error, run database recovery -- PANIC: fatal region error detected; run
recovery')</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">Traceback (most recent call last):</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> File "dbNode.py", line 91, in destroy</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> self.joinedCursor.close()</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">Is there any quick fix solution I can do?</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">If these exceptions are getting raised due to some other
replication related issue, there is no mechanism I can get that error code and
handle the error accordingly.</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">When I look into the source code, I can see following
comments around this join function wrapper API.</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> /* FIXME: this is a buggy
interface. The returned cursor</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> contains internal
references to the passed in cursors</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> but does not hold
python references to them or prevent</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> them from being closed
prematurely. This can cause</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> python to crash when
things are done in the wrong order. */</span></font></p>
<p><font color="silver" face="Arial" size="1"><span style="font-size: 9pt; font-family: Arial; color: silver;">____________________________________<br>
Sury Prakash Soni<br>
Developer</span></font><font color="silver"><span style="color: silver;"><br>
</span></font><font color="silver" face="Arial" size="1"><span style="font-size: 9pt; font-family: Arial; color: silver;">____________________________________<br>
<br>
<b><span style="font-weight: bold;">Next Digital<br>
</span></b>Level 8, 15 William St,
Melbourne <br>
VIC 3000 Australia<br>
<i><b><i><font face="Arial"><span style="font-family: Arial; font-weight: bold;">p</span></font></i></b></i>
+61 3 8612 6888<br>
<i><b><i><font face="Arial"><span style="font-family: Arial; font-weight: bold;">f</span></font></i></b></i>
+61 3 8612 6899<br>
<i><b><i><font face="Arial"><span style="font-family: Arial; font-weight: bold;">m 0</span></font></i></b></i>433
661 327<br>
</span></font><font color="silver"><span style="color: silver;"><a href="mailto:ssoni@nextdigital.com" title="mailto:rmarshall@nextdigital.com
mailto:agoldman@nextdigital.com" target="_blank"><font title="mailto:rmarshall@nextdigital.com" color="#0066cc" face="Arial" size="1"><span title="mailto:rmarshall@nextdigital.com"><span style="font-size: 9pt; font-family: Arial; color: rgb(0, 102, 204);">ssoni@nextdigital.com</span></span></font></a></span></font><font color="#0066cc" face="Arial"><span style="font-family: Arial; color: rgb(0, 102, 204);"><br>
</span></font><font color="silver"><span style="color: silver;"><a href="http://www.nextdigital.com/" title="http://www.nextdigital.com/" target="_blank"><font title="http://www.nextdigital.com/" color="#0066cc" face="Arial" size="1"><span title="http://www.nextdigital.com/"><span style="font-size: 9pt; font-family: Arial; color: rgb(0, 102, 204);">www.nextdigital.com</span></span></font></a></span></font><font color="silver" face="Arial"><span style="font-family: Arial; color: silver;"><br>
</span></font><font color="silver" face="Arial" size="1"><span style="font-size: 9pt; font-family: Arial; color: silver;">____________________________________</span></font><font color="silver"><span style="color: silver;"><br>
<br>
</span></font><font color="gray" face="Arial" size="1"><span style="font-size: 7pt; font-family: Arial; color: gray;">This email and any attachments are intended only
for the use of the recipient and may be confidential and/or legally privileged.
Next Digital Group Pty Ltd ("Next Digital") disclaims liability for
any errors, omissions, viruses, loss and/or damage arising from using, opening
or transmitting this email. If you are not the intended recipient you must not
use, interfere with, disclose, copy or retain this email and you should notify
the sender immediately by return email or by contacting Next Digital by
telephone on +61 3 8612 6888.</span></font><font color="silver"><span style="color: silver;"></span></font></p>
<p><font face="Times New Roman" size="3"><span style="font-size: 12pt;"> </span></font></p>
</div>
</div>
<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></div>