From: | Melvin Davidson <melvin6925(at)gmail(dot)com> |
---|---|
To: | DrakoRod <drakoflames(at)hotmail(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: postgres: dbname dbuser 9.9.9.9[2222] PARSE waiting |
Date: | 2017-06-27 20:25:36 |
Message-ID: | CANu8FiwsoMZipt4PJzM8Ng=KTb0EBiN7fdQ9jr_W9UQowsZzpQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, Jun 27, 2017 at 4:10 PM, DrakoRod <drakoflames(at)hotmail(dot)com> wrote:
> Hi folks.
>
> Today I had a problem with production's database PostgreSQL version
> 9.4.4.9.
> The server have max_connections set to 200, but today I reviewed
> pg_stat_activity and saw 199 active connections, obviously the server
> rejected any new connection and the production stopped.
>
> I saw another posts with a similar problems, but this was because the
> pg_xlog was full or disk does'nt write, but the directory and disk had no
> problems.
>
> I just canceled some SELECTs querys and the server returned to normality.
> Now a monitoring activity of server and I can see some backends like this:
>
> postgres 9737 23340 2 14:55 ? 00:00:15 postgres: dbname user
> 8.8.8.8[37082] idle in transaction
> postgres 9741 23340 9 14:55 ? 00:00:47 postgres: dbname user
> 8.8.8.8[54286] idle in transaction
>
> Any suggestions?
>
>
>
> -----
> Dame un poco de fe, eso me bastarĂ¡.
> Rozvo Ware Solutions
> --
> View this message in context: http://www.postgresql-archive.
> org/postgres-dbname-dbuser-9-9-9-9-2222-PARSE-waiting-tp5968923.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
*Are you asking how to track down the user using up all the connection?
With the information you provided that cannot. be down.*
*If you are asking how to prevent problems in the future, then install
Pg_Bouncer and use that to pool connections.https://pgbouncer.github.io/
<https://pgbouncer.github.io/>*
--
*Melvin Davidson*
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Geoghegan | 2017-06-27 20:30:16 | Re: insert on conflict |
Previous Message | DrakoRod | 2017-06-27 20:10:57 | postgres: dbname dbuser 9.9.9.9[2222] PARSE waiting |