The following bug has been logged online:
Bug reference: 4081
Logged by: Pavel Alexei
Email address: pa@msys.md
PostgreSQL version: 8.2.7
Operating system: Windows XP SP2
Description: Running Postgres as Windows service vs regular
applications
Details:
I faced with problem connecting to Postgres running as Windows service.
After installing I tried to connect using pgAdmin, but Iâve got errors
regarding troubles in connecting and found next errors in logfile:
>connection received: host=127.0.0.1 port=13683
>could not receive data from client: An operation was attempted on something
that is not a socket.
>incomplete startup packet
I found through Google a lot of messages, several people had same problem.
But I didnât find solution. The only advice was to launch Postgres as
simple application (pg_ctl.exe start instead runservice). It was worked for
me too. But I decided to get understood problem.
I tried to get more details and raised all logging parameters in
configuration file to debug5 (âclient_min_messagesâ,
âlog_min_messagesâ, âlog_min_error_statementâ), but after this
errors disappeared. I turned back all parameters and got same errors. After
several experiments I got ârightâ target. If I put
âlog_min_messagesâ to debug2 or higher (2-5) everything is ok. But is
enough to set this parameter to debug1 or lower and Iâve got same problem.
Very strange thing to be coincidence.
Logfile with log_min_messages = debug1
2008-04-01 16:42:24 LOG: database system was shut down at 2008-04-01
16:42:23
2008-04-01 16:42:24 LOG: checkpoint record is at 0/173E990
2008-04-01 16:42:24 LOG: redo record is at 0/173E990; undo record is at
0/0; shutdown TRUE
2008-04-01 16:42:24 LOG: next transaction ID: 0/24871; next OID: 25829
2008-04-01 16:42:24 LOG: next MultiXactId: 1; next MultiXactOffset: 0
2008-04-01 16:42:24 LOG: database system is ready
2008-04-01 16:42:24 DEBUG: transaction ID wrap limit is 2147484171,
limited by database "postgres"
2008-04-01 16:42:33 [unknown] [unknown] LOG: connection received:
host=127.0.0.1 port=13682
2008-04-01 16:42:33 postgres lua authenticationLOG: connection authorized:
user=lua database=postgres
2008-04-01 16:42:33 [unknown] [unknown] LOG: connection received:
host=127.0.0.1 port=13683
2008-04-01 16:42:33 [unknown] [unknown] LOG: could not receive data from
client: An operation was attempted on something that is not a socket.
2008-04-01 16:42:33 [unknown] [unknown] LOG: incomplete startup packet
2008-04-01 16:42:35 [unknown] [unknown] LOG: connection received:
host=127.0.0.1 port=13684
2008-04-01 16:42:35 lua lua authenticationLOG: connection authorized:
user=lua database=lua
2008-04-01 16:42:50 LOG: received fast shutdown request
2008-04-01 16:42:50 LOG: aborting any active transactions
2008-04-01 16:42:50 lua lua idleFATAL: terminating connection due to
administrator command
2008-04-01 16:42:50 postgres lua idleFATAL: terminating connection due to
administrator command
2008-04-01 16:42:50 postgres lua idleLOG: disconnection: session time:
0:00:17.081 user=lua database=postgres host=127.0.0.1 port=13682
2008-04-01 16:42:50 lua lua idleLOG: disconnection: session time:
0:00:15.440 user=lua database=lua host=127.0.0.1 port=13684
2008-04-01 16:42:50 LOG: shutting down
2008-04-01 16:42:50 LOG: database system is shut down
2008-04-01 16:42:51 LOG: logger shutting down
Logfile with log_min_messages = debug2
2008-04-01 16:42:52 LOG: database system was shut down at 2008-04-01
16:42:50
2008-04-01 16:42:52 LOG: checkpoint record is at 0/173E9E0
2008-04-01 16:42:52 LOG: redo record is at 0/173E9E0; undo record is at
0/0; shutdown TRUE
2008-04-01 16:42:52 LOG: next transaction ID: 0/24910; next OID: 25829
2008-04-01 16:42:52 LOG: next MultiXactId: 1; next MultiXactOffset: 0
2008-04-01 16:42:52 LOG: database system is ready
2008-04-01 16:42:52 DEBUG: transaction ID wrap limit is 2147484171,
limited by database "postgres"
2008-04-01 16:43:11 DEBUG: forked new backend, pid=6856 socket=1368
2008-04-01 16:43:12 [unknown] [unknown] LOG: connection received:
host=127.0.0.1 port=13686
2008-04-01 16:43:12 postgres lua authenticationLOG: connection authorized:
user=lua database=postgres
2008-04-01 16:43:12 DEBUG: forked new backend, pid=4464 socket=1380
2008-04-01 16:43:12 [unknown] [unknown] LOG: connection received:
host=127.0.0.1 port=13687
2008-04-01 16:43:12 lua lua authenticationLOG: connection authorized:
user=lua database=lua