public inbox for [email protected]
help / color / mirror / Atom feedFrom: Adrian Klaver <[email protected]>
To: Wim Rouquart <[email protected]>
To: [email protected] <[email protected]>
Subject: Re: Index (primary key) corrupt?
Date: Fri, 10 Oct 2025 08:03:04 -0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <AS2PR05MB10754F4A8BC2689D4E637869EEFEFA@AS2PR05MB10754.eurprd05.prod.outlook.com>
References: <AS2PR05MB1075477BA334D4DA262AD75BFEF16A@AS2PR05MB10754.eurprd05.prod.outlook.com>
<[email protected]>
<AS2PR05MB107548567EEDAAB3AF74A6C59EF11A@AS2PR05MB10754.eurprd05.prod.outlook.com>
<[email protected]>
<AS2PR05MB10754A51AB7FC85161189FF7CEF11A@AS2PR05MB10754.eurprd05.prod.outlook.com>
<[email protected]>
<AS2PR05MB10754F4A8BC2689D4E637869EEFEFA@AS2PR05MB10754.eurprd05.prod.outlook.com>
On 10/10/25 05:28, Wim Rouquart wrote:
> Internal
>
> Hi,
>
> Apologies for the late response, had other fish to fry...
>
> In response to your questions:
>
>> What is full(15.x) version of Postgres are you using?
>
> 15.14
>
>> Is it the community version or a fork or SaaS?
>
> Standard release indeed, running on RHAT8
>
>> What do you get for queries below?:
>
>> select * from pg_opclass where oid = 3124;
>
> |oid |opcmethod |opcname |opcnamespace|opcowner |opcfamily |opcintype |opcdefault |opckeytype
> |3124 |403 |int8_ops |11 |10 |1976 |20 |true |0
>
>> select * from pg_opclass where opcname = 'int8_ops';
>
> |oid |opcmethod |opcname |opcnamespace |opcowner |opcfamily |opcintype |opcdefault |opckeytype|
> |3124 |403 |int8_ops |11 |10 |1976 |20 |true |0 |
> |10021 |405 |int8_ops |11 |10 |1977 |20 |true |0 |
>
Was the above done before or after you did the reindex?
From original post:
"
When doing a pg_dump of one of our databases one of the tables primary
keys doesn't get exported. Pg_dump just skips this index, without any
warning whatsoever (verbose mode was used to doublecheck).
When doing a REINDEX the issue is fixed.
"
That would imply that after the successful REINDEX and dump some action
is taken that makes the index disappear.
What is the table used for?
Are there any sort of 'unusual' operations done on it?
--
Adrian Klaver
[email protected]
view thread (18+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: Index (primary key) corrupt?
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox