Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 790CA2B2868 for ; Mon, 25 Jun 2012 12:01:03 -0300 (ADT) Received: from mail-ee0-f46.google.com ([74.125.83.46]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SjAmj-0003As-Ba for pgsql-admin@postgresql.org; Mon, 25 Jun 2012 15:01:02 +0000 Received: by eeit10 with SMTP id t10so1266397eei.19 for ; Mon, 25 Jun 2012 08:00:46 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type:x-gm-message-state; bh=dFJD5ZnOecsU4HK+a4ybi47zvhXQRnOLiAMXGmdxRNg=; b=bLQjXEZ//uol8x4uOzDzdEjfIZ+ax6nRs/NO0JVjgZQRHvprjDtwwkZFNXgeudLFVi xlhzrh2qMcu6HfPN+1OEiXfohMm0zyLabrFd5/Cg/RoAmp2M+siXGeWKFJD5AWCJ2ZmD IVq+byQ6wzEuBjQIrf++GrM6WlatmGsij2+mOmBlONqK2f/edXgglLLti1Tz9Pw+bA2H d7WHJxDckLRHiUYfYYKGBoStovlYYyRAk16EiWnX1CHk0Hr2oa5AdLr6J5ynE/cJ+C/b JpRhn1L9EpJ6oCqxKBp1oJNtoasC++Ptut+K3u9FNEjvMT5kn6kQo/GoBfD8uKtyw8HN CGIQ== MIME-Version: 1.0 Received: by 10.152.146.67 with SMTP id ta3mr12431057lab.27.1340636446701; Mon, 25 Jun 2012 08:00:46 -0700 (PDT) Received: by 10.112.86.33 with HTTP; Mon, 25 Jun 2012 08:00:46 -0700 (PDT) In-Reply-To: References: Date: Mon, 25 Jun 2012 09:00:46 -0600 Message-ID: Subject: Re: terminating autovacuum process due to administrator command From: Radovan Jablonovsky To: Albe Laurenz Cc: pgsql-admin@postgresql.org Content-Type: multipart/alternative; boundary=e89a8f22c72b2db7f604c34d3fe1 X-Gm-Message-State: ALoCoQkSqdxdfRaAfsWDP/2OcNNsC7kjGqNcETww3Ei9Az+Pi54o7L68Lq2F3s/RpPBUotuCKarP X-Pg-Spam-Score: -2.6 (--) X-Archive-Number: 201206/115 X-Sequence-Number: 39706 --e89a8f22c72b2db7f604c34d3fe1 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Thanks for response, How were the connections refused (error message)? 2012-06-13 13:45:38.809 MDT [25172]: [1-1] FATAL: remaining connection slots are reserved for non-replication superuser connections 2012-06-13 13:45:38.889 MDT [25173]: [1-1] FATAL: remaining connection slots are reserved for non-replication superuser connections 2012-06-13 13:45:38.895 MDT [25174]: [1-1] FATAL: remaining connection slots are reserved for non-replication superuser connections Could it be that there are already max_connections sessions? max_connection was set to 600, when issue occurred the db server had 85 connection and server was under medium load. Server details: We're running postgres 9.1.1 linux x64 centos 5.8 aspdata=3D# select version(); version ---------------------------------------------------------------------------= ------------------------------------ PostgreSQL 9.1.1 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-52), 64-bit We currently have 1 DB we use for multiple independent tenant schemas. The database size is current 56227005240 bytes as reported by pg_database_size. There are 557 schemas each with about 1300 objects (760 tables 520 views). On Mon, Jun 25, 2012 at 2:03 AM, Albe Laurenz wrot= e: > Radovan Jablonovsky wrote: > > Could you please help with this peculiar problem? > > > > > > In PostgreSQL log occurred this message: > > > > 2012-06-13 12:58:45.876 MDT [17536]: [1-1] FATAL: terminating > autovacuum process due to administrator > > command > > The server worked for 48 minutes after and then it started refuse > non-superuser connections, which > > effectively rendered it unusable for client applications. > > What could cause this behaviour? > > You gave very little information. > > How were the connections refused (error message)? > Could it be that there are already max_connections sessions? > > Yours, > Laurenz Albe > --=20 *Radovan Jablonovsky* | SaaS DBA | Phone 1-403-262-6519 (ext. 256) | Fax 1-403-233-8046**** * Replicon | Hassle-Free Time & Expense Management Software - 7,300 Customers - 70 Countries www.replicon.com | facebook | twitter | blog | contact us We are hiring! | search jobs * --e89a8f22c72b2db7f604c34d3fe1 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
Thanks for response,

How were the connections= refused (error message)?=A0
2012-06-13 13:45:38.809 MDT [25= 172]: [1-1] FATAL: =A0remaining connection slots are reserved for non-repli= cation superuser connections
2012-06-13 13:45:38.889 MDT [25173]: [1-1] FATAL: =A0remaining connect= ion slots are reserved for non-replication superuser connections
= 2012-06-13 13:45:38.895 MDT [25174]: [1-1] FATAL: =A0remaining connection s= lots are reserved for non-replication superuser connections

Could it be that there are already max_connections sessions?= =A0max_connection was set to 600, when issue occurred the db server had 85 = connection and server was under medium load.

Server details:
We're running postgres 9.1.1 linux x64 c= entos 5.8

aspdata=3D# select versi=
on();
                                                    version
---------------------------------------------------------------------------=
------------------------------------
 PostgreSQL 9.1.1 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.1.2
20080704 (Red Hat 4.1.2-52), 64-bit


We currently have 1 DB we use for multiple independent tenant schemas. The
database size is current 56227005240 bytes as reported by pg_database_size.
There are 557 schemas each with about 1300 objects (760 tables 520 views).<=
/font>

On Mon, Jun 25, 2012 at 2:03 AM,= Albe Laurenz <laurenz.albe@wien.gv.at> wrote:
Rado= van Jablonovsky wrote:
> Could you please help with this peculiar problem?
>
>
> In PostgreSQL log occurred this message:
>
> 2012-06-13 12:58:45.876 MDT [17536]: [1-1] FATAL: =A0terminating
autovacuum process due to administrator
> command
> The server =A0worked for 48 minutes after and then it started refuse non-superuser connections, which
> effectively rendered it unusable for client applications.
> What could cause this behaviour?

You gave very little information.

How were the connections refused (error message)?
Could it be that there are already max_connections sessions?

Yours,
Laurenz Albe



--

Radovan Jablonovsky=A0| SaaS DBA | Phone=A01-403-262-6519=A0(ext. 256) | Fax=A01-403-233-8046<= /span>


Replicon=A0| Hassle-Free Time & Expense Management S= oftware - 7,300 Customers - 70 Countries
www.replicon.com=A0|=A0facebook=A0|=A0twitter=A0|=A0blog=A0|=A0conta= ct us

We are hiring!=A0|=A0search jobs


--e89a8f22c72b2db7f604c34d3fe1--