The main one is the GlorpDatabaseReadError, and as its resumable, and a read error, I just want to retry it, until it succeeds. This is a production system, and having the debugger fire constantly, eventually messes up the entire image.<div>
<br><br><div class="gmail_quote">On Tue, May 10, 2011 at 14:23, 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">On Tue, May 10, 2011 at 5:03 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">
But as these exceptions </blockquote><div><br>which ones? I guess you are talking about GlorpDatabaseReadError<br> </div><div class="im"><blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204, 204, 204);padding-left:1ex">
are marked as Resumable, shouldn't it be enough for me to do :-</blockquote></div><div><br>I am not sure if I understood correctly. Can you explain a little more please?<br> </div><div class="im"><blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204, 204, 204);padding-left:1ex">
<div><div><span style="white-space:pre-wrap">        </span></div><div><span style="white-space:pre-wrap"></span>[</div>
<div><span style="white-space:pre-wrap">                </span>^aQuery executeWithParameters: #() in: self.</div><div><span style="white-space:pre-wrap">        </span>] </div><div><span style="white-space:pre-wrap">        </span>on: GlorpDatabaseReadError</div>
<div><span style="white-space:pre-wrap">        </span>do: [:ex | Transcript show: ex messageText;cr. ex resume]. </div></div></blockquote></div><div><br><br><br>thanks<br><font color="#888888"><br>Mariano<br><br> </font></div>
<div><div></div><div class="h5"><blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204, 204, 204);padding-left:1ex">
<div><div><div></div><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" target="_blank">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>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>
<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" 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><br><br clear="all"><br>-- <br></div></div>~JT<br><br><br>
</div>
<br>_______________________________________________<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></div></div><div><div></div><div class="h5"><br><br clear="all"><br>-- <br>Mariano<br><a href="http://marianopeck.wordpress.com" target="_blank">http://marianopeck.wordpress.com</a><br><br>
</div></div><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>