Re: Help with hang on empty query (PG 7.3.2, psqlodbc-07.03.0200)

--- Steve Wampler <swampler@noao.edu> wrote:
>
> I recently upgraded a system from RedHat 8 to RedHat
> 9, which
> meant an upgrade of PG 7.2 to 7.3.2.  Several
> applications
> that are written in a language that relies upon dbc
> to access
> postgresql have stopped working.
>
> I've installed from source psqlodbc-07.03.0200
> (pthread
> and iodbc support).  From the logs it looks as
> though the
> connection is succeeding up to the point that an
> empty query is sent (dunno why the empty query is
> being
> sent - it appears to be part of the connection
> procedure).
> At this point the connection hangs - no messages, or
> errors.
> Killing the client program causes postgresql to log
> a:
>
>    LOG:  pq_recvbuf: unexpected EOF on client
> connection
>
> message.
>
> These programs had all been working with the odbc
> RPM that was
> available for 7.2.3, so I assume it's something to
> do with
> how I configured the build.
>
> (Can someone tell me why the odbc RPM was dropped
> with 7.3?)
>
> Thanks for any help!

Someone posted a similar problem to the list not long
ago.  Turned out to be a connection problem, i.e. they
could not connect to the server from the new client
machine at all.  Can you successfully connect and
issue queries from this machine using psql or any
other interface?

>
> Various logs and traces:
>
> odbc.trace:
>
>    SQLAllocEnv ( ... )
>    SQL_SUCCESS
>
>    SQLAllocConnect ( ... )
>    SQL_SUCCESS
>
>    SQLConnect ( ... )
>
> psqlodbc_swampler17169.log:
>
>    conn = 135226032, PGAPI_Connect(DSN='swampler',
> UID='swampler',
>          PWD='xxxxx')
>    Global Options: Version='07.03.0200', fetch=100,
> socket=4096,
>          unknown_sizes=0, max_varchar_size=254,
>           max_longvarchar_size=8190
>                 disable_optimizer=1, ksqo=1,
> unique_index=1,
>                           use_declarefetch=0
>                 text_as_longvarchar=1,
> unknowns_as_longvarchar=0,
>                           bools_as_char=1
> NAMEDATALEN=64
>                 extra_systable_prefixes='dd_;',
> conn_settings=''
>                          conn_encoding='OTHER'
>                 conn=135226032, query=' '
>
> mylog_swampler17169.log:
>
>     [1075229312]CC_connect: entering...
>     [1075229312]CC_connect(): DSN = 'swampler',
> server = 'weaver',
>            port = '5432', database = 'swampler',
> username = 'swampler',
>            password='xxxxx'
>     [1075229312]connecting to the server socket...
>     [1075229312]connection to the server socket
> succeeded.
>     [1075229312]sizeof startup packet = 292
>     [1075229312]sent the authentication block.
>     [1075229312]sent the authentication block
> successfully.
>     [1075229312]gonna do authentication
>     [1075229312]read 15,
> global_socket_buffersize=4096
>     [1075229312]auth got 'R'
>     [1075229312]areq = 0
>     [1075229312]auth got 'K'
>     [1075229312]auth got 'Z'
>     [1075229312]sending an empty query...
>     [1075229312]send_query(): conn=135226032,
> query=' '
>
> --
> Steve Wampler -- swampler@noao.edu
> Quantum materiae materietur marmota monax si marmota
>                     monax materiam possit materiari?
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org


__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree