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

Re: Connection problem

From: Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM>
To: A B <gentosaker(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Connection problem
Date: 2008-05-30 19:26:52
Message-ID: 484054FC.3040102@sun.com (view raw or flat)
Thread:
Lists: pgsql-general
Do you have any core dump? Stack trace should help.

	Zdenek

A B napsal(a):
> 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
> 


In response to

Responses

pgsql-general by date

Next:From: Zdenek KotalaDate: 2008-05-30 19:30:59
Subject: Re: Collate problem when using ORDER BY
Previous:From: Merlin MoncureDate: 2008-05-30 19:02:23
Subject: Re: Query planning configuration and solid state drives

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