From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | reem <dailyemailr(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: database is not accepting commands |
Date: | 2017-05-16 15:03:55 |
Message-ID: | e3b11dce-f7a0-212f-ef06-c3d45df3353e@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 05/16/2017 01:28 AM, reem wrote:
> We have 1.5 TB database that's shown an error and block all commands.
> The error is :
> "ERROR: database is not accepting commands to avoid wraparound data loss in
> database "dbname"
> HINT: Stop the postmaster and use a standalone backend to vacuum that
> database.
> You might also need to commit or roll back old prepared transactions."
>
> I tried to do vacuum in the backend mode. Also I tried to set
> zero_damaged_pages = on then do the vacuum again but same error appeared.
> The error appeared after two hours of vacuuming where verbose shows passing
> tables.
Postgres version?
So was all the above done in the standalone backend?
>
> The cause of error could be :
> 1- a lot of insertion queries for not existing table
> or
> 2- truncating data with 40 GB in a week,
> we used to do that but this is the first time we had this error.
> also, autovacuume is turned on.
>
> Please , I need help or any suggestion?
>
>
>
>
>
>
> --
> View this message in context: http://www.postgresql-archive.org/database-is-not-accepting-commands-tp5961831.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Eric Hill | 2017-05-16 15:08:00 | Re: storing large files in database - performance |
Previous Message | Adrian Klaver | 2017-05-16 14:58:41 | Re: EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 4 - compilation issues on RHEL 7.2 |