Re: pg_upgrade and wraparound

On 06/10/2018 02:45 PM, Alexander Shutyaev wrote:

Comments inline.

> The error log is like this. Here's its tail:

Is this the regular Postgres log or the pg_upgrade log which should be 
something like pg_upgrade_server.log?


> pg_restore: [archiver (db)] could not execute query: ERROR:  database is 
> not accepting commands to avoid wraparound data loss in database with OID 0
> HINT:  Stop the postmaster and vacuum that database in single-user mode.

How did you get into the 10 cluster to report on the database OID's and 
names?

> You might also need to commit or roll back old prepared transactions.
>      Command was: ALTER LARGE OBJECT 1740737402 OWNER TO bof_user;
> 
> Before that there is a lot of similar messages - the only things 
> chainging are the "executing BLOB nnn" number and "must be vacuumed 
> within nnn transactions" number.
> 

Which database has the large objects?

> As for the prepared transactions - no, I don't have them, our 
> application doesn't use this functionality.

Did you check this view to confirm?:

https://www.postgresql.org/docs/10/static/view-pg-prepared-xacts.html

Just trying to eliminate possibilities.



-- 
Adrian Klaver
adrian.klaver@aklaver.com