From: | Yuri Niyazov <yuri(at)academia(dot)edu> |
---|---|
To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Upgrading from Postgresql 9.3.8 to 9.6.10 |
Date: | 2019-03-26 05:51:09 |
Message-ID: | CACuBw0i+mWJHT5-wO+SnERiED-oEGGSFkxw_M+4dGbnNm5VgAw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
We have an old cluster, running 9.3.8, that we are trying to upgrade to
9.6.10.
After running pg_upgrade and starting the server, and testing some common
queries against it, we experienced the following error:
PG::IndexCorrupted: ERROR: index "table_pkey" contains unexpected zero page
at block 17021871 HINT: Please REINDEX it.
So, if I am reading this correctly, there is an index that 9.3.8 created,
and it recognizes that index as OK, but 9.6.10 thinks that index is
corrupt. Since this happened on one index, it seems reasonable to assume
that this could happen on any index in that database, and we need to
reindex the entire database.
Now, this is a live application, and we would like to minimize continuous
downtime (multiple short downtimes are fine), so what we are considering
doing is a manual reindex: for each index, create a new one, and then drop
the old one, and after all that, upgrade.
However, we are leery of doing this reindexing using 9.3.8, since it's
already demonstrated itself to be unreliable.
Which version should we use to reindex? Just the latest 9.3.X? Was there a
known bug with older versions missing corrupted pages in indices?
PS: Just in case I am glaringly doing something wrong:
Here's our mechanism of doing the upgrade: we create a streaming replica
from a basebackup, and then at some point turn off writes to the primary,
convert the replica to another primary, and then run pg_upgrade on this new
primary.
From | Date | Subject | |
---|---|---|---|
Next Message | Ron | 2019-03-26 06:14:32 | Re: Upgrading from Postgresql 9.3.8 to 9.6.10 |
Previous Message | Shreeyansh Dba | 2019-03-26 02:14:41 | Re: Monitoring hot standby replication for failure |