Re: DIAG [HY000] server closed the connection unexpectedly

From: "Jon Raiford" <Raiford(at)labware(dot)com>
To: "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>
Cc: "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>, pgsql-odbc-owner(at)postgresql(dot)org
Subject: Re: DIAG [HY000] server closed the connection unexpectedly
Date: 2016-10-21 17:52:51
Message-ID: OF8B9F15A7.552C0D7E-ON85258053.0061FE63-85258053.00623A2E@LocalDomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi Tsunakawa-san,

Here is an excerpt from my ODBC tracing on Windows. You can see that the
error is being reported as 08001 instead of 08S01:

v a14-135c ENTER SQLFetch
HSTMT 0x0026DBC0

v a14-135c EXIT SQLFetch with return code 100
(SQL_NO_DATA_FOUND)
HSTMT 0x0026DBC0

v a14-135c ENTER SQLFreeHandle
SQLSMALLINT 3 <SQL_HANDLE_STMT>
SQLHANDLE 0x0026DBC0

v a14-135c EXIT SQLFreeHandle with return code 0
(SQL_SUCCESS)
SQLSMALLINT 3 <SQL_HANDLE_STMT>
SQLHANDLE 0x0026DBC0

v a14-135c ENTER SQLEndTran
SQLSMALLINT 2 <SQL_HANDLE_DBC>
SQLHANDLE 0x0026CCC8
SQLSMALLINT 0

v a14-135c EXIT SQLEndTran with return code -1
(SQL_ERROR)
SQLSMALLINT 2 <SQL_HANDLE_DBC>
SQLHANDLE 0x0026CCC8
SQLSMALLINT 0

DIAG [08001] server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
(101)

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Tsunakawa, Takayuki 2016-10-24 03:02:08 Re: DIAG [HY000] server closed the connection unexpectedly
Previous Message Inoue, Hiroshi 2016-10-21 13:48:32 Re: xmin when linked tables are updated?