[SqueakDBX] Connection not Valid problem

[John Toohey]

Hi,
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.

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 :-


PGConnection(Object)>>error:
Receiver: a PGConnection
Arguments and temporary variables:
aString: 'Connection not valid'
Receiver's instance variables:
trace: 0
state: #Terminated
events: an OrderedCollection()
socket: nil
readBuffer: 'PblankTid￿￿name￿$password￿6client...etc...
readIndex: 384
lastReadIndex: 384
writeBuffer: nil
processId: 28132
secretKey: 1795051851
sql: 'SELECT t1.id, t1.name, t1.password, t1.client, t1.role, t1.mobile,
t1.ema...etc...
functionCallOid: nil
functionCallArgs: nil
copyStream: nil
result: a PGResult
connectionArgs: a PGConnectionArgs
notificationSubscribers: nil
fieldConverters: an IdentityDictionary(16->[closure] in PGConnection
class>>boo...etc...
sqlStringConverter: [closure] in PGConnection>>clientEncoding:
receivingTextConverter: an UTF8TextConverter

PGConnection>>execute:
Receiver: a PGConnection
Arguments and temporary variables:
sqlString: 'SELECT t1.id, t1.typename, t1.description, t1.selectioncount,
t1.pr...etc...
Receiver's instance variables:
trace: 0
state: #Terminated
events: an OrderedCollection()
socket: nil
readBuffer: 'PblankTid￿￿name￿$password￿6client...etc...
readIndex: 384
lastReadIndex: 384
writeBuffer: nil
processId: 28132
secretKey: 1795051851
sql: 'SELECT t1.id, t1.name, t1.password, t1.client, t1.role, t1.mobile,
t1.ema...etc...
functionCallOid: nil
functionCallArgs: nil
copyStream: nil
result: a PGResult
connectionArgs: a PGConnectionArgs
notificationSubscribers: nil
fieldConverters: an IdentityDictionary(16->[closure] in PGConnection
class>>boo...etc...
sqlStringConverter: [closure] in PGConnection>>clientEncoding:
receivingTextConverter: an UTF8TextConverter

SqueakDatabaseAccessor>>basicExecuteSQLString:
Receiver: a SqueakDatabaseAccessor
Arguments and temporary variables:
aString: 'SELECT t1.id, t1.typename, t1.description, t1.selectioncount,
t1.prio...etc...
result: nil
rowCollection: nil
Receiver's instance variables:
connection: a PGConnection
currentLogin: a Login(a PostgreSQLPlatform, 'postgres', '847129',
'localhost_ju...etc...
logging: true
reusePreparedStatements: nil
deniedCommands: nil
mutex: a Semaphore()
dependents: nil
isInTransaction: false

Any help would be appreciated, as this is stopping me from going to a Beta
test at the moment.

Thanks,



-- 
-JT
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.squeakfoundation.org/pipermail/squeakdbx/attachments/20090923/00c75b25/attachment.htm