[SqueakDBX] Connection not Valid problem

Mariano Martinez Peck marianopeck at gmail.com
Thu Sep 24 15:15:07 UTC 2009 

On Thu, Sep 24, 2009 at 1:59 PM, John Toohey <jt at parspro.com> wrote:

> I'm currently trying to build openDBX on OSX. I've finally found the
> postgres client libs and include files, and I've run ./configure
> -with-backends="pgsql", but when I run make I get this error :-
>

Excellent you are giving SqueakDBX at least a try. The real thing is this:
The squeakDBX team is composed by 4 people. Only one has a Mac and he is
very busy with his work. I have ALL databases working on Linux and Windows.
And I have also prepared binaries for that because I can (dlls, .deb and
.rpm). But I cannot do it with Mac because I don't have a mac and I don't
know how binaries work on Mac. If you make it work, I would really love you
help me generating the binaries so that I can update them to OpenDBX
website.

Which OpenDBX version are you trying to compile? You should try 1.4.3.

Can you try configuring this way please ?

./configure --disable-utils --with-backends="pgsql"

If it works, I then explain you why that :)


Making all in po
> g++ -DHAVE_CONFIG_H -I. -I.. -I../lib
> -DLOCALEDIR=\"/usr/local/share/locale\"
> -DKEYWORDFILE=\"/usr/local/share/opendbx/keywords\"
> -I/opt/local/include/postgresql83  -g -O2 -MT odbx_sql-argmap.o -MD -MP -MF
> .deps/odbx_sql-argmap.Tpo -c -o odbx_sql-argmap.o `test -f 'argmap.cpp' ||
> echo './'`argmap.cpp
> mv -f .deps/odbx_sql-argmap.Tpo .deps/odbx_sql-argmap.Po
> g++ -DHAVE_CONFIG_H -I. -I.. -I../lib
> -DLOCALEDIR=\"/usr/local/share/locale\"
> -DKEYWORDFILE=\"/usr/local/share/opendbx/keywords\"
> -I/opt/local/include/postgresql83  -g -O2 -MT odbx_sql-commands.o -MD -MP
> -MF .deps/odbx_sql-commands.Tpo -c -o odbx_sql-commands.o `test -f
> 'commands.cpp' || echo './'`commands.cpp
> mv -f .deps/odbx_sql-commands.Tpo .deps/odbx_sql-commands.Po
> g++ -DHAVE_CONFIG_H -I. -I.. -I../lib
> -DLOCALEDIR=\"/usr/local/share/locale\"
> -DKEYWORDFILE=\"/usr/local/share/opendbx/keywords\"
> -I/opt/local/include/postgresql83  -g -O2 -MT odbx_sql-completion.o -MD -MP
> -MF .deps/odbx_sql-completion.Tpo -c -o odbx_sql-completion.o `test -f
> 'completion.cpp' || echo './'`completion.cpp
> mv -f .deps/odbx_sql-completion.Tpo .deps/odbx_sql-completion.Po
> g++ -DHAVE_CONFIG_H -I. -I.. -I../lib
> -DLOCALEDIR=\"/usr/local/share/locale\"
> -DKEYWORDFILE=\"/usr/local/share/opendbx/keywords\"
> -I/opt/local/include/postgresql83  -g -O2 -MT odbx_sql-odbx-sql.o -MD -MP
> -MF .deps/odbx_sql-odbx-sql.Tpo -c -o odbx_sql-odbx-sql.o `test -f
> 'odbx-sql.cpp' || echo './'`odbx-sql.cpp
> odbx-sql.cpp: In function 'int main(int, char**)':
> odbx-sql.cpp:228: error: invalid conversion from 'char* (*)(const char*,
> int)' to 'int (*)(const char*, int)'
> make[3]: *** [odbx_sql-odbx-sql.o] Error 1
> make[2]: *** [all-recursive] Error 1
> make[1]: *** [all-recursive] Error 1
> make: *** [all] Error 2
>
> Do you know of any pre-built binaries that will work on OSX?
>


I don't know, but I would love to have them!!!




>
> On Wed, Sep 23, 2009 at 23:09, Mariano Martinez Peck <
> marianopeck at gmail.com> wrote:
>
>>
>>
>> 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
>>>
>>>
>>>
>>
>
>
> --
> -JT
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.squeakfoundation.org/pipermail/squeakdbx/attachments/20090924/ca3051ee/attachment.htm

More information about the SqueakDBX mailing list