But as these exceptions are marked as Resumable, shouldn't it be enough for me to do :-<div><div><span class="Apple-tab-span" style="white-space:pre"> </span></div><div><span class="Apple-tab-span" style="white-space:pre"></span>[</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>^aQuery executeWithParameters: #() in: self.</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>] </div><div><span class="Apple-tab-span" style="white-space:pre"> </span>on: GlorpDatabaseReadError</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>do: [:ex | Transcript show: ex messageText;cr. ex resume]. </div><br><div class="gmail_quote">On Tue, May 10, 2011 at 10:39, Mariano Martinez Peck <span dir="ltr"><<a href="mailto:marianopeck@gmail.com">marianopeck@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><br><br><div class="gmail_quote"><div class="im">On Tue, May 10, 2011 at 4:31 PM, John Toohey <span dir="ltr"><<a href="mailto:jt@parspro.com" target="_blank">jt@parspro.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
I get this error a lot when my system is under load. According to the pgsql docs, I should do this, <span style="border-collapse:collapse;font-family:Verdana, Geneva, Helvetica, Arial, sans-serif;font-size:13px"><span>"PQgetResult must be called repeatedly until it returns a null pointer, </span><br>
<span></span></span> </blockquote><blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204, 204, 204);padding-left:1ex"><span style="border-collapse:collapse;font-family:Verdana,Geneva,Helvetica,Arial,sans-serif;font-size:13px"><span><b style="background-color:rgb(255, 255, 102)">indicating</b> that the <b style="background-color:rgb(255, 255, 102);background-repeat:initial initial">command</b> <b style="background-color:rgb(255, 255, 102);background-repeat:initial initial">is</b> done." </span></span><div>
<font face="Verdana, Geneva, Helvetica, Arial, sans-serif"><span style="border-collapse:collapse"><br></span></font></div></blockquote></div><div><br>This is weird...it should not happen while using SqueakDBX. <br>If you see DBXConnection >> execute:<br>
<br>just at the beginning we do:<br><br> | aResult |<br> self isOpen ifFalse: <br> [ OpenDBXDriverError signal: 'You cannot execute a query if the connection is not open' ].<br> self releasePreviousResult.<br>
<br><br>that method #releasePreviousResult that exactly that. If you didn't finish iterating all returns in your last query, we do it for you in the next query. Of course, we also do that while closing the connection.<br>
So...I cannot image how you can get that :( <br>Probably something with the pool and Glorp ?<br> </div><blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204, 204, 204);padding-left:1ex">
<div class="im">
<div><font face="Verdana, Geneva, Helvetica, Arial, sans-serif"><span style="border-collapse:collapse">
</span></font></div><div><span></span><font face="Verdana, Geneva, Helvetica, Arial, sans-serif"><span style="border-collapse:collapse">How do I handle this type of error in GlorpDBX? I'm using Pharo 1.2 and the Glorp/DBX build that was available when that was released. <br clear="all">
</span></font><br>-- <br>~JT<br><br><br>
</div>
<br></div>_______________________________________________<br>
SqueakDBX mailing list<br>
<a href="mailto:SqueakDBX@lists.squeakfoundation.org" target="_blank">SqueakDBX@lists.squeakfoundation.org</a><br>
<a href="http://lists.squeakfoundation.org/mailman/listinfo/squeakdbx" target="_blank">http://lists.squeakfoundation.org/mailman/listinfo/squeakdbx</a><br>
<br></blockquote></div><font color="#888888"><br><br clear="all"><br>-- <br>Mariano<br><a href="http://marianopeck.wordpress.com" target="_blank">http://marianopeck.wordpress.com</a><br><br>
</font><br>_______________________________________________<br>
SqueakDBX mailing list<br>
<a href="mailto:SqueakDBX@lists.squeakfoundation.org">SqueakDBX@lists.squeakfoundation.org</a><br>
<a href="http://lists.squeakfoundation.org/mailman/listinfo/squeakdbx" target="_blank">http://lists.squeakfoundation.org/mailman/listinfo/squeakdbx</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br>~JT<br><br><br>
</div>