Postgres Pro
Downloads
Home   >   mailing lists

Re: Corruption or wrong results with 14.10? - Mailing list pgsql-general

From Torsten Förtsch
Subject Re: Corruption or wrong results with 14.10?
Date
Msg-id CAKkG4_=OTSyzg2F-Z2MonVOqot+mVi6OEA0j8PqdotVcOuddnw@mail.gmail.com
Whole thread Raw
In response to Re: Corruption or wrong results with 14.10?  ("Daniel Westermann (DWE)" <daniel.westermann@dbi-services.com>)
Responses Re: Corruption or wrong results with 14.10?  (Jeremy Schneider <schneider@ardentperf.com>)
List pgsql-general
Tree view
On Thu, Nov 23, 2023 at 2:29 PM Daniel Westermann (DWE) <daniel.westermann@dbi-services.com> wrote:
smrdbprod=# select crart_id, chemin, count(*) from smrr_mgr.formula group by  crart_id, chemin having count(*) > 1;
  crart_id   | chemin | count
-------------+--------+-------
 35054630000 | @      |     2
  4737310000 | @      |     2
 10632380000 | @      |     2
 14680880000 | @      |     2
  4627230000 | @      |     2
 10993780000 | @      |     2
....

I think I know what I have to do.

If you have moved the database from a system with glibc <2.28 to >=2.28, that could be the reason.

pgsql-general by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: Configuration knobs & dials to speed up query optimization
Next
From: Adrian Klaver
Date:
Subject: Re: Inquiry Regarding Initial Seed for pgsql Protocol Fuzz Testing