From: | Peter Geoghegan <pg(at)bowt(dot)ie> |
---|---|
To: | Ibrahim Edib Kokdemir <kokdemir(at)gmail(dot)com> |
Cc: | pgsql-general General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: invalid memory alloc request size 576460752438159360 |
Date: | 2017-12-31 13:58:48 |
Message-ID: | CAH2-WznMfKEFZOitiTWio2f8Rqu2QK6u88uiK3uxqipJWOsz+w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Sun, Dec 31, 2017 at 1:50 PM, Ibrahim Edib Kokdemir
<kokdemir(at)gmail(dot)com> wrote:> * write_cache is disabled
> * there is no incorrect work_mem parameter setting.
> * logical dump is working, (maybe) no curruption in data.
> * there is streaming replication, we do not repeat the error in the
> replicas. (replicas in different minor versions, 9.6.4, 9.6.3 accordingly)
> * we have large_object field, logical_dump also works with large_objects
> fields.
>
> Any idea?
This is very likely to be corruption. It's important to determine the
cause and extent of this corruption. I suggest using amcheck for this,
which is available for those Postgres versions from:
https://github.com/petergeoghegan/amcheck
Note that there are Debian and Redhat packages available.
You'll definitely want to use the "heapallindexed" option here, at
least for primary key indexes (pass "pg_index.indisprimary" as
"heapallindexed" argument, while generalizing from the example SQL
query for bt_index_check()). This process has a good chance of
isolating the problem, especially if you let this list see any errors
raised by the tool.
--
Peter Geoghegan
From | Date | Subject | |
---|---|---|---|
Next Message | Stephen Frost | 2017-12-31 16:33:40 | Re: Does PostgreSQL check database integrity at startup? |
Previous Message | Ibrahim Edib Kokdemir | 2017-12-31 13:50:45 | invalid memory alloc request size 576460752438159360 |