[SqueakDBX] Connection not Valid problem

Thu Sep 24 03:09:07 UTC 2009

On Wed, Sep 23, 2009 at 11:27 PM, John Toohey <jt at parspro.com> wrote:

> Hey,
> Thanks for looking into this for me. I'm just using Pharo as my app is
> using the beta of Seaside 3.0. I'm going to do as you suggested and put some
> debug statements in PGConnection, and see where that leads.
>
>
Ok, let us know what the problem was if you find it :)

> Is it a lot of changes from me to switch to DBX on Pharo?
>

No. Your application shouldn't have any changes. You application will use
just Glorp. But in this case Glorp won't use the native PostgreSQL driver,
but SqueakDBX with PostgreSQL.

> I assume there are no changes in my Glorp code, but what else do I need to
> do.
>

The only thing you must do is:

- Install the PostgreSQL client library (if you don't have it already
installed).
- Compile or Install (if you are in Linux you can use the .rpm or .deb)
OpenDBX with PostgreSQL,

You can read how to do it here: http://wiki.squeak.org/squeak/6129

You must do it only once. Once this is done, everything is easy and you can
take advantage of all the SqueakDBX features (
http://wiki.squeak.org/squeak/6106). OpenDBX works perfect with PostgreSQL
in Linux, Mac and Windows. We have also have GlorpDBX working with SqueakDBX
and PostgreSQL and it is very easy to install:

http://wiki.squeak.org/squeak/6130    (where it says GlorpDBX).

The only limitation we have right now is that we don't support large objects
(blob, clob, etc) yet.

If you try it and have any problem, please, let us know!!!

> I develop on OSX and deploy to Linux for production.
>
>
No problem.

Best,

Mariano

>
> On Wed, Sep 23, 2009 at 21:03, Mariano Martinez Peck <
> marianopeck at gmail.com> wrote:
>
>> I was thinking if you have the problem in Squeak also or just Pharo ?
>>
>>
>> On Wed, Sep 23, 2009 at 8:12 PM, Mariano Martinez Peck <
>> marianopeck at gmail.com> wrote:
>>
>>>
>>>
>>> On Wed, Sep 23, 2009 at 8:25 PM, John Toohey <jt at parspro.com> wrote:
>>>
>>>> Hi,
>>>>
>>>
>>>
>>> Hi John! This list is SqueakDBX related, so perhaps I am not the best one
>>> to help you. I just make Glorp and PostgreSQL native driver to work on
>>> Pharo. Actually, the only thing I did is to have all green tests. No more
>>> than that. I don't have a Glorp + native postgresql driver application.
>>> Anyway, I will try to help you ;)
>>>
>>>
>>>
>>>> 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.
>>>>
>>>
>>> you meat there is a Pharo bug that when there is a walkback and the
>>> stacktrace is written to disk, it freezes the image ?  is there a bug report
>>> of that ? Could you reproduce that ?
>>>
>>>
>>>>  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.
>>>>
>>>>
>>> Yes, that's probably the case. I can see in code that the error
>>> 'Connection not valid' when the connection is not connected or if it is nil.
>>> If you see your stacktrace, you can see that the socket variable is nil.
>>> That's why the error. Now, the question is why the socket is nil ?
>>>
>>> I looked for the code to see where can be the socket set to nil, and I
>>> found some places:  PGConnection stTerminalError:  , stTerminated
>>> Perhaps you can put a "self halt" in those methods and then debug them.
>>>
>>> The PGConnection seems to do a lot of "self log: 'XXXX'". So, perhaps you
>>> can have a Transcript opened to see that.
>>>
>>> Finally, why don't you give a try to GlorpDBX + SqueakDBX ?   It works
>>> pretty well and has good performance.
>>>
>>> I hope this helps. Remember I am not a native postgresql driver guru.
>>> Perhaps you can ask also in squeak-dev or pharo mailing lists.
>>>
>>> Best,
>>>
>>> Mariano
>>>
>>>
>>>>  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
>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> SqueakDBX mailing list
>>>> SqueakDBX at lists.squeakfoundation.org
>>>> http://lists.squeakfoundation.org/mailman/listinfo/squeakdbx
>>>>
>>>>
>>>
>>
>
>
> --
> -JT
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.squeakfoundation.org/pipermail/squeakdbx/attachments/20090924/871f629c/attachment.htm