Re: Help with hang on empty query (PG 7.3.2,

On Fri, 2003-11-07 at 09:05, Steve Wampler 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 odbc to access
> postgresql have stopped working.

I've now verified that the same hang occurs when using the
odbctest program that comes with libiodbc.

Can anyone suggest a way to track this down further?  Thanks!

> 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!
>
> 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?