From: | "A B" <gentosaker(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Connection problem |
Date: | 2008-05-30 12:49:20 |
Message-ID: | dbbf25900805300549j7ef0612dr125b5fbdcc39457b@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I get a lot of
Error server closed the connection unexpectedly This probably means
the server terminated abnormally before or while processing the
request.
and I think I need some help finding out what is the problem. Any
suggestions on where to start? I think I have maximum logging on
(debug5) but prior to the crash I get no log. I connect to the server
with php/apache and I use pg_pconnect to get persistent connections.
The first log message for a working request to the server says:
LOG: 00000: connection received: host=[local]
LOCATION: BackendInitialize, postmaster.c:2755
DEBUG: 00000: forked new backend, pid=6961 socket=8
LOCATION: BackendStartup, postmaster.c:2581
DEBUG: 00000: received password packet
LOCATION: recv_password_packet, auth.c:940
LOG: 00000: connection authorized: user=myuser database=mydb
LOCATION: BackendInitialize, postmaster.c:2825
DEBUG: 00000: postmaster child[6961]: starting with (
LOCATION: BackendRun, postmaster.c:2925
DEBUG: 00000: postgres
LOCATION: BackendRun, postmaster.c:2928
DEBUG: 00000: -v196608
LOCATION: BackendRun, postmaster.c:2928
DEBUG: 00000: -y
LOCATION: BackendRun, postmaster.c:2928
DEBUG: 00000: mydb
LOCATION: BackendRun, postmaster.c:2928
DEBUG: 00000: )
LOCATION: BackendRun, postmaster.c:2930
DEBUG: 00000: InitPostgres
LOCATION: PostgresMain, postgres.c:3142
DEBUG: 00000: StartTransaction
LOCATION: ShowTransactionState, xact.c:4001
DEBUG: 00000: name: unnamed; blockState: DEFAULT; state:
INPROGR, xid/subid/cid: 8513010/1/0, nestlvl: 1, children: <>
LOCATION: ShowTransactionStateRec, xact.c:4026
DEBUG: 00000: CommitTransaction
LOCATION: ShowTransactionState, xact.c:4001
DEBUG: 00000: name: unnamed; blockState: STARTED; state:
INPROGR, xid/subid/cid: 8513010/1/0, nestlvl: 1, children: <>
LOCATION: ShowTransactionStateRec, xact.c:4026
DEBUG: 00000: StartTransactionCommand
LOCATION: start_xact_command, postgres.c:2200
STATEMENT: SELECT count(*) FROM Users
DEBUG: 00000: StartTransaction
LOCATION: ShowTransactionState, xact.c:4001
From | Date | Subject | |
---|---|---|---|
Next Message | Merlin Moncure | 2008-05-30 13:37:13 | Re: function cache effect still happening? |
Previous Message | dvs | 2008-05-30 10:11:58 | cannot use result of (insert .. returning) |