please see the following snippet
Feb 27, 2006 6:23:51
.DMException: java.sql.SQLException: FATAL: terminating connection due to administrator command
.DMException: java.sql.SQLException: FATAL: terminating connection due to administrator command
this error message is in one of the log files, and because of the above
error the desired job does not get executed
i tried to see the postgreslog.
the log message around that time are as follows:
<2006-02-27 18:23:52 CST%>LOG: connection received:
host=localhost.localdomain port=33256
<2006-02-27 18:23:52 CST%authentication>LOG: connection authorized: user=sdc database=dbexpress
<2006-02-27 18:23:53 CST%>LOG: connection received: host=localhost.localdomain port=33258
<2006-02-27 18:23:53 CST%authentication>LOG: connection authorized: user=sdc database=dbexpress
<2006-02-27 18:30:41 CST%>LOG: connection received: host=[local] port=
<2006-02-27 18:30:41 CST%authentication>LOG: connection authorized: user=sdc database=dbexpress
<2006-02-27 18:30:42 CST%idle>LOG: disconnection: session time: 0:00:00.35 user=sdc database=dbexpress host=[local] port=
<2006-02-27 18:40:44 CST%idle>LOG: unexpected EOF on client connection
<
<2006-02-27 18:23:52 CST%authentication>LOG: connection authorized: user=sdc database=dbexpress
<2006-02-27 18:23:53 CST%>LOG: connection received: host=localhost.localdomain port=33258
<2006-02-27 18:23:53 CST%authentication>LOG: connection authorized: user=sdc database=dbexpress
<2006-02-27 18:30:41 CST%>LOG: connection received: host=[local] port=
<2006-02-27 18:30:41 CST%authentication>LOG: connection authorized: user=sdc database=dbexpress
<2006-02-27 18:30:42 CST%idle>LOG: disconnection: session time: 0:00:00.35 user=sdc database=dbexpress host=[local] port=
<2006-02-27 18:40:44 CST%idle>LOG: unexpected EOF on client connection
<
please note the lines in bold, is it because of this EOF on client
connection that ... the DMException is coming.
will be glad if any hints could be provided.
this is Postgres 8.0.0
thanks,
regards
Surabhi