Wednesday, December 25, 2019

[google-cloud-sql-discuss] Postgres Vacuum problem

Hi, 

I can't work with the database other than the "select" statement. When I update or edit the table or column data it reports an error like this:

ERROR: database is not accepting commands to avoid wraparound data loss in database "xxx"
HINT
: Stop the postmaster and vacuum that database in single-user mode.
You might also need to commit or roll back old prepared transactions.

Table information:
Screenshot from 2019-12-25 23-05-50.png















It has been running for over 10 hours but does not see anything happening:
Screenshot from 2019-12-25 23-22-55.pngScreenshot from 2019-12-25 23-25-12.png


How do I know when the "VACUUM table" statement completes? Can I truncate that table?

Thanks a lot
Hung

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/38d2d1b6-cf4c-4787-90af-7bf13a6d6d1b%40googlegroups.com.

No comments:

Post a Comment