Skip site navigation (1) Skip section navigation (2)

Connection problem

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 (view raw or flat)
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

Responses

pgsql-general by date

Next:From: Merlin MoncureDate: 2008-05-30 13:37:13
Subject: Re: function cache effect still happening?
Previous:From: dvsDate: 2008-05-30 10:11:58
Subject: cannot use result of (insert .. returning)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group