Re: Help with hang on empty query (PG 7.3.2,
От | Steve Wampler |
---|---|
Тема | Re: Help with hang on empty query (PG 7.3.2, |
Дата | |
Msg-id | 1068398142.12206.64.camel@weaver.tuc.noao.edu обсуждение исходный текст |
Ответ на | Re: Help with hang on empty query (PG 7.3.2, ("Hiroshi Inoue" <inoue@tpf.co.jp>) |
Ответы |
Re: Help with hang on empty query (PG 7.3.2,
(Steve Wampler <swampler@noao.edu>)
|
Список | pgsql-odbc |
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@noao.edu Quantum materiae materietur marmota monax si marmota monax materiam possit materiari?
В списке pgsql-odbc по дате отправления:
Следующее
От: "Markus Wollny"Дата:
Сообщение: S1010 function sequence error after ODBC-driver-upgrade