pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Scott Marlowe <smarlowe@g2switchworks.com>
To: Federico Campoli <rotellaro@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Trouble with phpbb installation
Date: Wed, 03 May 2006 09:58:09 -0500
Message-ID: <1146668289.22037.31.camel@state.g2switchworks.com> (raw)
In-Reply-To: <a3e8e2210605011620j4cb28dbend17281b4c18cd464@mail.gmail.com>
References: <a3e8e2210605011620j4cb28dbend17281b4c18cd464@mail.gmail.com>

On Mon, 2006-05-01 at 18:20, Federico Campoli wrote:
> Hi.
> 
> Yesterday I've migrated a  PHPBB mysql database on a fresh install of
> postgresql 8.1.3 on a debian gnu/linux sarge 3.1.
> 
> The python script that migrate schema and data worked fine and I got
> all data on the my postgresql database.
> 
> But, when the number of phpbb connected users increase  (about 70-80),
> postgresql go crazy.
> 
> The number of postgres process increase too and not decrease when the
> php pages released the connection (I use not persistent connection on
> my php cofiguration).

This actually usually points to a problem in your web server with
crashing processes leaving postgresql children up not disconnecting
properly.

A quick fix is to set a REALLY low tcp_keepalive in the networking on
those machines, assuming you're using tcp/ip sockets to connect.  not
sure how to recover broken connections on local unix sockets.

> Changing the database parameter like checkpoint_timeout, write_mode 
> and shared_buffer has no effect on this strange situation.
> 
> I've noticed also that when the connected user increase after 70 the
> data are not commited immediately.

This is likely because those broken connections I mentioned above are
standing in the way of the actual, live connections.

Run top on the machine while this is happening and look for zombie
processes and such.  Note that the most common cause of a crashing
apache is having modules compile against one set of libs and apache
compile against another.

How was your php server built?  what version php is it, all that kind of
stuff might help us figure this out.



view thread (2+ messages)

Message-ID: <1146668289.22037.31.camel@state.g2switchworks.com>
Permalink:  ../1146668289.22037.31.camel@state.g2switchworks.com/
Also on:    postgresql.org/message-id/1146668289.22037.31.camel@state.g2switchworks.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: smarlowe@g2switchworks.com, rotellaro@gmail.com
  Subject: Re: Trouble with phpbb installation
  In-Reply-To: <1146668289.22037.31.camel@state.g2switchworks.com>
  References: <a3e8e2210605011620j4cb28dbend17281b4c18cd464@mail.gmail.com> <1146668289.22037.31.camel@state.g2switchworks.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox