Re: [GENERAL] database is not accepting commands - Mailing list pgsql-general
On Tue, May 16, 2017 at 11:03 AM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
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.klaver@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
As Adrian requested:
PostgreSQL Version?
O/S?
Did you ?
A. Stop PostgreSQL
B.postgres --single -D <path_to_data>
C
VACUUMDB -f -d <your_db_name>
VACUUMDB -f -d <your_db_name>
OR
VACUUMDB -f -a
D. Restart PostgreSQL normally
--
Melvin Davidson
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
pgsql-general by date: