database is not accepting commands

From: reem <dailyemailr(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: database is not accepting commands
Date: 2017-05-16 08:28:40
Message-ID: 1494923320530-5961831.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Magnus Hagander 2017-05-16 08:38:40 Re: Help: Installing 9.6 breaks local connections to 9.2 on Centos 6.9
Previous Message Devrim Gündüz 2017-05-16 08:00:53 Re: Help: Installing 9.6 breaks local connections to 9.2 on Centos 6.9