Re: Unknown winsock error 10061 - Mailing list pgsql-bugs

When the server starts, it should also spew out the initial shmem
segment ID and address  - did you get them? They may go to stderr
rather than the log, because they're output so early in the startup. I
assume they're the same because one of the attaches seems to work
fine.

2009/7/8 Wojciech Strza=C5=82ka <wstrzalka@gmail.com>:
> And the result is:
>
> 2009-07-08 14:26:00 CEST PID:9612 DEBUG: =C2=A000000: forked new backend,=
 pid=3D8120 socket=3D948
> 2009-07-08 14:26:00 CEST PID:9612 LOCATION: =C2=A0BackendStartup, .\src\b=
ackend\postmaster\postmaster.c:3029
> *** Finished restoring shared memory vars in restore_backend_variables (k=
ey=3D256, addr=3D02400000)
> FATAL: =C2=A0could not reattach to shared memory (key=3D256, addr=3D02400=
000): 487
> 2009-07-08 14:26:00 CEST PID:9612 DEBUG: =C2=A000000: reaping dead proces=
ses
> 2009-07-08 14:26:00 CEST PID:9612 LOCATION: =C2=A0reaper, .\src\backend\p=
ostmaster\postmaster.c:2184
> 2009-07-08 14:26:00 CEST PID:9612 DEBUG: =C2=A000000: server process (PID=
 8120) exited with exit code 1
> 2009-07-08 14:26:00 CEST PID:9612 LOCATION: =C2=A0LogChildExit, .\src\bac=
kend\postmaster\postmaster.c:2653
> 2009-07-08 14:26:01 CEST PID:9612 DEBUG: =C2=A000000: forked new backend,=
 pid=3D9952 socket=3D948
> 2009-07-08 14:26:01 CEST PID:9612 LOCATION: =C2=A0BackendStartup, .\src\b=
ackend\postmaster\postmaster.c:3029
> *** Finished restoring shared memory vars in restore_backend_variables (k=
ey=3D256, addr=3D02400000)
> *** Finished reattaching shared memory segment in PGSharedMemoryReAttach =
(key=3D256, addr=3D02400000)
> 2009-07-08 14:26:01 CEST PID:9952 DEBUG: =C2=A000000: postgres child[9952=
]: starting with (
> 2009-07-08 14:26:01 CEST PID:9952 LOCATION: =C2=A0BackendRun, .\src\backe=
nd\postmaster\postmaster.c:3384
> 2009-07-08 14:26:01 CEST PID:9952 DEBUG: =C2=A000000: =C2=A0 =C2=A0 =C2=
=A0 =C2=A0postgres
> 2009-07-08 14:26:01 CEST PID:9952 LOCATION: =C2=A0BackendRun, .\src\backe=
nd\postmaster\postmaster.c:3387
> 2009-07-08 14:26:01 CEST PID:9952 DEBUG: =C2=A000000: =C2=A0 =C2=A0 =C2=
=A0 =C2=A0-v196608
> 2009-07-08 14:26:01 CEST PID:9952 LOCATION: =C2=A0BackendRun, .\src\backe=
nd\postmaster\postmaster.c:3387
> 2009-07-08 14:26:01 CEST PID:9952 DEBUG: =C2=A000000: =C2=A0 =C2=A0 =C2=
=A0 =C2=A0-y
> 2009-07-08 14:26:01 CEST PID:9952 LOCATION: =C2=A0BackendRun, .\src\backe=
nd\postmaster\postmaster.c:3387
> 2009-07-08 14:26:01 CEST PID:9952 DEBUG: =C2=A000000: =C2=A0 =C2=A0 =C2=
=A0 =C2=A0masterdb
> 2009-07-08 14:26:01 CEST PID:9952 LOCATION: =C2=A0BackendRun, .\src\backe=
nd\postmaster\postmaster.c:3387
> 2009-07-08 14:26:01 CEST PID:9952 DEBUG: =C2=A000000: )
> 2009-07-08 14:26:01 CEST PID:9952 LOCATION: =C2=A0BackendRun, .\src\backe=
nd\postmaster\postmaster.c:3389
> 2009-07-08 14:26:01 CEST PID:9952 DEBUG: =C2=A000000: InitPostgres
> 2009-07-08 14:26:01 CEST PID:9952 LOCATION: =C2=A0PostgresMain, .\src\bac=
kend\tcop\postgres.c:3333
> 2009-07-08 14:26:01 CEST PID:9952 DEBUG: =C2=A000000: my backend id is 5
> 2009-07-08 14:26:01 CEST PID:9952 LOCATION: =C2=A0SharedInvalBackendInit,=
 .\src\backend\storage\ipc\sinvaladt.c:316
> 2009-07-08 14:26:01 CEST PID:9952 DEBUG: =C2=A000000: StartTransaction
> 2009-07-08 14:26:01 CEST PID:9952 LOCATION: =C2=A0ShowTransactionState, .=
\src\backend\access\transam\xact.c:4073
> 2009-07-08 14:26:01 CEST PID:9952 DEBUG: =C2=A000000: name: unnamed; bloc=
kState: =C2=A0 =C2=A0 =C2=A0 DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0,=
 nestlvl: 1, children:
> 2009-07-08 14:26:01 CEST PID:9952 LOCATION: =C2=A0ShowTransactionStateRec=
, .\src\backend\access\transam\xact.c:4111
> 2009-07-08 14:26:01 CEST PID:9952 DEBUG: =C2=A000000: CommitTransaction
> 2009-07-08 14:26:01 CEST PID:9952 LOCATION: =C2=A0ShowTransactionState, .=
\src\backend\access\transam\xact.c:4073
> 2009-07-08 14:26:01 CEST PID:9952 DEBUG: =C2=A000000: name: unnamed; bloc=
kState: =C2=A0 =C2=A0 =C2=A0 STARTED; state: INPROGR, xid/subid/cid: 0/1/0,=
 nestlvl: 1, children:
> 2009-07-08 14:26:01 CEST PID:9952 LOCATION: =C2=A0ShowTransactionStateRec=
, .\src\backend\access\transam\xact.c:4111
> 2009-07-08 14:26:01 CEST PID:9952 DEBUG: =C2=A000000: parse <unnamed>: SH=
OW TRANSACTION ISOLATION LEVEL
> 2009-07-08 14:26:01 CEST PID:9952 LOCATION: =C2=A0exec_parse_message, .\s=
rc\backend\tcop\postgres.c:1117
> 2009-07-08 14:26:01 CEST PID:9952 STATEMENT: =C2=A0SHOW TRANSACTION ISOLA=
TION LEVEL
>
>
>
> --
> Pozdrowienia,
> =C2=A0Wojciech Strza=C5=82ka
>
>



--=20
Dave Page
EnterpriseDB UK:   http://www.enterprisedb.com