Re: DIAG [HY000] server closed the connection unexpectedly

Hi, Jon, Inoue-san,

Inoue-san,
The attached patch is rebased on HEAD.

Jon,

From: Jon Raiford [mailto:Raiford(at)labware(dot)com]
> Yes, I can see that the code does answer 08S01, however it is being reported
> as 08001 to the application. This can be seen even in the ODBC trace. I'm
> not sure why it is changed. Maybe this is a symptom of a bigger problem?

Didn't the 08001 get returned after you failed to reconnect? As follows, I got 08S01 when I killed backend while it was running an SQL statement (e.g. SELECT pg_sleep(1000)).

[isql command of unixODBC]
$ isql -v postgres
...
SQL> select pg_sleep(1000);
[ISQL]ERROR: Could not SQLExecute
[08S01]server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
;
The connection has been lost
SQL>

[my test app using SQLExecDirect]
08S01: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
;
The connection has been lost

Regards
Takayuki Tsunakawa