| From: | Luca Ferrari <fluca1978(at)gmail(dot)com> |
|---|---|
| To: | Ibrahim Edib Kokdemir <kokdemir(at)gmail(dot)com> |
| Cc: | pgsql-general General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: FATAL: invalid page in block 0 of relation global/1262 |
| Date: | 2019-07-12 16:55:19 |
| Message-ID: | CAKoxK+7tzFhkiQTwSNnM9HwK1Lym+NgzimLHMonx46w4Mboo4A@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Jul 12, 2019 at 5:22 PM Ibrahim Edib Kokdemir
<kokdemir(at)gmail(dot)com> wrote:
>
> Hi,
> I upgraded my cluster from 9.6 to 11 with pg_upgrade hardlink parameter two days ago. Since then it has been working great as v11. Today while running heavy update queries on it, I got the "FATAL: invalid page in block 0 of relation global/1262" message and server crushed.
> Hard reset and trying to start, it start but shows the same error message and do not let me to connect. "psql: FATAL: invalid page in block 0 of relation global/1262". I read that the filenode 1262 is for pg_database table.
>
The error message is indicating there is a page checksum error, i.e.,
the filesystem got corrupted.
I'm not aware of any way of turning it off without re-initdbing
(<https://www.postgresql.org/docs/11/app-initdb.html>).
Sorry, but seems to me a good backup is required to fix it.
Luca
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Luca Ferrari | 2019-07-12 17:02:58 | Re: Issue: Creating Symlink for data directory of postgresql in CentOS7 |
| Previous Message | Ibrahim Edib Kokdemir | 2019-07-12 15:21:42 | FATAL: invalid page in block 0 of relation global/1262 |