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

On Sat, 2003-11-08 at 16:33, Hiroshi Inoue wrote:
> > -----Original Message-----
> > From: Steve Wampler
> >
> > 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!
>
> Could you try to remove ENTER_CONN_CS in CC_send_query
> in connection.c and change all RETURN_AFTER_LEAVE_CS(self, ..)
> to "return ..(the 2nd parameter) "?

Hi Hiroshi,

Thanks for the suggestion. I get the same behavior, but
the mylog file has more information in it (the other logs
are unchanged):
-------------------------------------------------------
->cat mylog*
[1074087680]CC_connect: entering...
[1074087680]CC_connect(): DSN = 'swampler', server = 'weaver', port =
'5432', database = 'swampler', username = 'swampler', password='xxxxx'
[1074087680]connecting to the server socket...
[1074087680]connection to the server socket succeeded.
[1074087680]sizeof startup packet = 292
[1074087680]sent the authentication block.
[1074087680]sent the authentication block successfully.
[1074087680]gonna do authentication
[1074087680]read 15, global_socket_buffersize=4096
[1074087680]auth got 'R'
[1074087680]areq = 0
[1074087680]auth got 'K'
[1074087680]auth got 'Z'
[1074087680]sending an empty query...
[1074087680]send_query(): conn=134528568, query=' '
[1074087680]send_query: done sending query
[1074087680]in QR_Constructor
[1074087680]exit QR_Constructor
[1074087680]read 3, global_socket_buffersize=4096
[1074087680]send_query: got id = 'I'
[1074087680]send_query: got id = 'Z'
[1074087680]QResult: in DESTRUCTOR
[1074087680]QResult: free memory in, fcount=0
[1074087680]QResult: free memory out
[1074087680]QResult: exit DESTRUCTOR
[1074087680]empty query seems to be OK.
[1074087680]CC_lookup_pg_version: entering...
[1074087680]PGAPI_AllocStmt: entering...
[1074087680]**** PGAPI_AllocStmt: hdbc = 134528568, stmt = 134552160
[1074087680]CC_add_statement: self=134528568, stmt=134552160
[1074087680]PGAPI_ExecDirect: entering...
[1074087680]**** PGAPI_ExecDirect: hstmt=134552160, statement='select
version()'
[1074087680]PGAPI_ExecDirect: calling PGAPI_Execute...
[1074087680]PGAPI_Execute: entering...
[1074087680]PGAPI_Execute: clear errors...
[1074087680]recycle statement: self= 134552160
[1074087680]Exec_with_parameters_resolved: copying statement params:
trans_status=1, len=16, stmt='select version()'
[1074087680] stmt_with_params = 'select version()'
--------------------------------------------------------------
--
Steve Wampler -- swampler(at)noao(dot)edu
Quantum materiae materietur marmota monax si marmota
monax materiam possit materiari?