Hi,<div><br></div><div>My app frequently losses the connection the Postgres, and throws a "Connection not Valid" exception. Unfortunately on the latest Pharo images, there is a bug that causes this to write the stack trace to disk, and then the image locks up. I think the socket on the PGConnection class is being closed or times out, and I need to know is there someway that I can debug this or if its a know issue. </div>
<div><br></div><div>I am using the latest Pharo image, with the latest Pharo-Glorp package, and the newest Postgres driver. I think this is the relevant part of the stack trace :-</div><div><br></div><div><div><br></div><div>
PGConnection(Object)>>error:</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>Receiver: a PGConnection</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>Arguments and temporary variables: </div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>aString: <span class="Apple-tab-span" style="white-space:pre"> </span>'Connection not valid'</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>Receiver's instance variables: </div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>trace: <span class="Apple-tab-span" style="white-space:pre"> </span>0</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>state: <span class="Apple-tab-span" style="white-space:pre"> </span>#Terminated</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>events: <span class="Apple-tab-span" style="white-space:pre"> </span>an OrderedCollection()</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>socket: <span class="Apple-tab-span" style="white-space:pre"> </span>nil</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>readBuffer: <span class="Apple-tab-span" style="white-space:pre"> </span>'PblankT idname$password6client...etc...</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>readIndex: <span class="Apple-tab-span" style="white-space:pre"> </span>384</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>lastReadIndex: <span class="Apple-tab-span" style="white-space:pre"> </span>384</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>writeBuffer: <span class="Apple-tab-span" style="white-space:pre"> </span>nil</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>processId: <span class="Apple-tab-span" style="white-space:pre"> </span>28132</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>secretKey: <span class="Apple-tab-span" style="white-space:pre"> </span>1795051851</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>sql: <span class="Apple-tab-span" style="white-space:pre"> </span>'SELECT <a href="http://t1.id">t1.id</a>, <a href="http://t1.name">t1.name</a>, t1.password, t1.client, t1.role, t1.mobile, t1.ema...etc...</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>functionCallOid: <span class="Apple-tab-span" style="white-space:pre"> </span>nil</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>functionCallArgs: <span class="Apple-tab-span" style="white-space:pre"> </span>nil</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>copyStream: <span class="Apple-tab-span" style="white-space:pre"> </span>nil</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>result: <span class="Apple-tab-span" style="white-space:pre"> </span>a PGResult</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>connectionArgs: <span class="Apple-tab-span" style="white-space:pre"> </span>a PGConnectionArgs</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>notificationSubscribers: <span class="Apple-tab-span" style="white-space:pre"> </span>nil</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>fieldConverters: <span class="Apple-tab-span" style="white-space:pre"> </span>an IdentityDictionary(16->[closure] in PGConnection class>>boo...etc...</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>sqlStringConverter: <span class="Apple-tab-span" style="white-space:pre"> </span>[closure] in PGConnection>>clientEncoding:</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>receivingTextConverter: <span class="Apple-tab-span" style="white-space:pre"> </span>an UTF8TextConverter</div>
<div><br></div><div>PGConnection>>execute:</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>Receiver: a PGConnection</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>Arguments and temporary variables: </div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>sqlString: <span class="Apple-tab-span" style="white-space:pre"> </span>'SELECT <a href="http://t1.id">t1.id</a>, t1.typename, t1.description, t1.selectioncount, t1.pr...etc...</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>Receiver's instance variables: </div><div><span class="Apple-tab-span" style="white-space:pre"> </span>trace: <span class="Apple-tab-span" style="white-space:pre"> </span>0</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>state: <span class="Apple-tab-span" style="white-space:pre"> </span>#Terminated</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>events: <span class="Apple-tab-span" style="white-space:pre"> </span>an OrderedCollection()</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>socket: <span class="Apple-tab-span" style="white-space:pre"> </span>nil</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>readBuffer: <span class="Apple-tab-span" style="white-space:pre"> </span>'PblankT idname$password6client...etc...</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>readIndex: <span class="Apple-tab-span" style="white-space:pre"> </span>384</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>lastReadIndex: <span class="Apple-tab-span" style="white-space:pre"> </span>384</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>writeBuffer: <span class="Apple-tab-span" style="white-space:pre"> </span>nil</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>processId: <span class="Apple-tab-span" style="white-space:pre"> </span>28132</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>secretKey: <span class="Apple-tab-span" style="white-space:pre"> </span>1795051851</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>sql: <span class="Apple-tab-span" style="white-space:pre"> </span>'SELECT <a href="http://t1.id">t1.id</a>, <a href="http://t1.name">t1.name</a>, t1.password, t1.client, t1.role, t1.mobile, t1.ema...etc...</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>functionCallOid: <span class="Apple-tab-span" style="white-space:pre"> </span>nil</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>functionCallArgs: <span class="Apple-tab-span" style="white-space:pre"> </span>nil</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>copyStream: <span class="Apple-tab-span" style="white-space:pre"> </span>nil</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>result: <span class="Apple-tab-span" style="white-space:pre"> </span>a PGResult</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>connectionArgs: <span class="Apple-tab-span" style="white-space:pre"> </span>a PGConnectionArgs</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>notificationSubscribers: <span class="Apple-tab-span" style="white-space:pre"> </span>nil</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>fieldConverters: <span class="Apple-tab-span" style="white-space:pre"> </span>an IdentityDictionary(16->[closure] in PGConnection class>>boo...etc...</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>sqlStringConverter: <span class="Apple-tab-span" style="white-space:pre"> </span>[closure] in PGConnection>>clientEncoding:</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>receivingTextConverter: <span class="Apple-tab-span" style="white-space:pre"> </span>an UTF8TextConverter</div>
<div><br></div><div>SqueakDatabaseAccessor>>basicExecuteSQLString:</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>Receiver: a SqueakDatabaseAccessor</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>Arguments and temporary variables: </div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>aString: <span class="Apple-tab-span" style="white-space:pre"> </span>'SELECT <a href="http://t1.id">t1.id</a>, t1.typename, t1.description, t1.selectioncount, t1.prio...etc...</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>result: <span class="Apple-tab-span" style="white-space:pre"> </span>nil</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>rowCollection: <span class="Apple-tab-span" style="white-space:pre"> </span>nil</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>Receiver's instance variables: </div><div><span class="Apple-tab-span" style="white-space:pre"> </span>connection: <span class="Apple-tab-span" style="white-space:pre"> </span>a PGConnection</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>currentLogin: <span class="Apple-tab-span" style="white-space:pre"> </span>a Login(a PostgreSQLPlatform, 'postgres', '847129', 'localhost_ju...etc...</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>logging: <span class="Apple-tab-span" style="white-space:pre"> </span>true</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>reusePreparedStatements: <span class="Apple-tab-span" style="white-space:pre"> </span>nil</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>deniedCommands: <span class="Apple-tab-span" style="white-space:pre"> </span>nil</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>mutex: <span class="Apple-tab-span" style="white-space:pre"> </span>a Semaphore()</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>dependents: <span class="Apple-tab-span" style="white-space:pre"> </span>nil</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>isInTransaction: <span class="Apple-tab-span" style="white-space:pre"> </span>false</div>
<div><br></div><div>Any help would be appreciated, as this is stopping me from going to a Beta test at the moment.</div><div><br></div><div>Thanks,</div><div><br></div><div><br></div><br>-- <br>-JT<br><br><br>
</div>