<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="country-region"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="City"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="address"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="Street"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:595.3pt 841.9pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-AU link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Hi All,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>I am having issue in using joined cursor for indexed
database.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>When, there are no records for given joined cursor, ideally,
jonedCursor.get(0) should return None or raise some exception.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>But, in my case, I am getting <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>(-30975, 'DB_RUNRECOVERY: Fatal error, run database recovery
-- PANIC: Invalid argument')<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Traceback (most recent call last):<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> File "dbNode.py", line 71, in next<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> data = self.joinedCursor.get(0)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Later, <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Exception in destroy: (-30975, 'DB_RUNRECOVERY: Fatal
error, run database recovery -- PANIC: fatal region error detected; run
recovery')<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Traceback (most recent call last):<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> File "dbNode.py", line 91, in destroy<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> self.joinedCursor.close()<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Is there any quick fix solution I can do?<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
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.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>When I look into the source code, I can see following
comments around this join function wrapper API.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> /* FIXME: this is a buggy
interface. The returned cursor<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> contains internal
references to the passed in cursors<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> but does not hold
python references to them or prevent<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> them from being closed
prematurely. This can cause<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> python to crash when
things are done in the wrong order. */<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><font
size=1 color=silver face=Arial><span style='font-size:9.0pt;font-family:Arial;
color:silver'>____________________________________<br>
Sury Prakash Soni<br>
Developer</span></font><font color=silver><span style='color:silver'><br>
</span></font><font size=1 color=silver face=Arial><span style='font-size:9.0pt;
font-family:Arial;color:silver'>____________________________________<br>
<br>
<b><span style='font-weight:bold'>Next Digital<br>
</span></b>Level 8, <st1:address w:st="on"><st1:Street w:st="on">15 William St</st1:Street>,
<st1:City w:st="on">Melbourne</st1:City></st1:address> <br>
VIC 3000 <st1:place w:st="on"><st1:country-region w:st="on">Australia</st1:country-region></st1:place><br>
<em><b><i><font face=Arial><span style='font-family:Arial;font-weight:bold'>p</span></font></i></b></em>
+61 3 8612 6888<br>
<em><b><i><font face=Arial><span style='font-family:Arial;font-weight:bold'>f</span></font></i></b></em>
+61 3 8612 6899<br>
<em><b><i><font face=Arial><span style='font-family:Arial;font-weight:bold'>m 0</span></font></i></b></em>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"><font
size=1 color="#0066cc" face=Arial title="mailto:rmarshall@nextdigital.com"><span
title="mailto:rmarshall@nextdigital.com"><span style='font-size:9.0pt;
font-family:Arial;color:#0066CC'>ssoni@nextdigital.com</span></span></font></a></span></font><font
color="#0066cc" face=Arial><span style='font-family:Arial;color:#0066CC'><br>
</span></font><font color=silver><span style='color:silver'><a
href="http://www.nextdigital.com/" title="http://www.nextdigital.com/"><font
size=1 color="#0066cc" face=Arial title="http://www.nextdigital.com/"><span
title="http://www.nextdigital.com/"><span style='font-size:9.0pt;font-family:
Arial;color:#0066CC'>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 size=1 color=silver face=Arial><span style='font-size:9.0pt;
font-family:Arial;color:silver'>____________________________________</span></font><font
color=silver><span style='color:silver'><br>
<br>
</span></font><font size=1 color=gray face=Arial><span style='font-size:7.0pt;
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'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
</body>
</html>