Interesting, but it my cases, all the key does have values in the DB, yet Glorp sometimes returns a Proxy to my code, which then throws a DND exception when I access it as if its one of my objects.<br><br><div class="gmail_quote">
On Wed, May 11, 2011 at 11:02, 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;">
THanks. Probably is not related...but did you read this post:<br><br><a href="http://joachimtuchel.wordpress.com/2011/03/25/glorp-va-smalltalk-proxies-and-isnil/" target="_blank">http://joachimtuchel.wordpress.com/2011/03/25/glorp-va-smalltalk-proxies-and-isnil/</a><br>
<br>cheers<br><font color="#888888"><br>mariano</font><div><div></div><div class="h5"><br><br><div class="gmail_quote">On Wed, May 11, 2011 at 4:48 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">
<div>- Pharo-1.1.1--Latest update: #11414</div>- Posstgres 8.3.7<div>- 32 bit compiled OpenDBX from approx 12 months ago</div><div>- Headless Linux server running on EC2</div><div>- VM is 15.2f</div><div><br></div><div>What I often get it the debugger firing with Glorp errors because the Glorp proxy does not instantiate an object associated with a foreign key. I can usually get out of those, but often in the morning, the VM itself has gone down. Attached is a PharoDebug from this morning.</div>
<div><div></div><div>
<div><br></div><div><br></div><div><br><div class="gmail_quote">On Wed, May 11, 2011 at 10:26, 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 Wed, May 11, 2011 at 3:54 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">
Well the VM crashes, but I can't be sure if its because of the resume or something else.<div><div></div><div><br></div></div></blockquote></div><div><br>wow.... we will need more data in order to help there. <br>
Which Pharo/Squeak image, which VM ? which OS ? which OpenDBX version ? which database ? which version of SqueakDBX/ConfigurationOf ?<br><br>do you have the dump or console output of the crash ?<br><br>thanks<br><font color="#888888"><br>
Mariano<br>
</font></div><div><div></div><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><br><div class="gmail_quote">On Tue, May 10, 2011 at 15:04, 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 9:03 PM, John Toohey <span dir="ltr"><<a href="mailto:jt@parspro.com" target="_blank">jt@parspro.com</a>></span> wrote:<br>
</div><div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
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>
<div></div><div><div>
<br></div></div></div></blockquote></div><div><br>Ok....but if you resume... does it work finally ? I mean, if you do what you said, you fix your problem ?<br><br>thanks<br> </div><div><div></div><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><div><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" 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">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><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><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><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><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" 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>~JT<br><br><br>
</div>
</div></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><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" 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>~JT<br><br><br>
</div></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><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" 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>~JT<br><br><br>
</div>
</div></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><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>