Re: Issue with pg_dump due to Schema OID Error

HI Adrian,
I did additional tests and I can reproduce the problem also without the
extensions.
I did the test multiple time with a script that I put as attachment
(wholetest.sh).
I added also the file log_different_run.txt that contains the results of
some test and the times it takes to reproduce.

BR
Renzo

On Thu, Dec 19, 2024 at 9:42 PM Renzo Dani <arons7(at)gmail(dot)com> wrote:

> Hi Adrian,
> Thanks for the test, I installed also version 17.2 and test with a fresh
> newly created db.
> At the beginning I cannot reproduce the problem as well.
> Than I start adding the extension we use, one after one, and testing in
> between.
>
> I found out that the problem appear immediately as soon as I add the
> extension pg_stat_statements:
>
> create extension pg_stat_statements WITH SCHEMA public;
>
> alter system set shared_preload_libraries = 'pg_stat_statements';
>
> Can you maybe test as well with this extension?
> the other that I installed before that are: pgcrypto and pg_prewarm.
>
> here the current installed one:
>
> dbtest=# \dx
> List of installed extensions
> Name | Version | Schema |
> Description
>
> --------------------+---------+------------+------------------------------------------------------------------------
> pg_prewarm | 1.2 | public | prewarm relation data
> pg_stat_statements | 1.11 | public | track planning and execution
> statistics of all SQL statements executed
> pgcrypto | 1.3 | public | cryptographic functions
> plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
> (4 rows)
>
> dbtest=# select version();
> version
>
>
> ------------------------------------------------------------------------------------------------------------------
> PostgreSQL 17.2 reda build on x86_64-pc-linux-gnu, compiled by gcc
> (Ubuntu 13.3.0-6ubuntu2~24.04) 13.3.0, 64-bit
> (1 row)
>
>
> I'll do some additional tests.
>
> BR
> Renzo
>
>
>
> On Thu, Dec 19, 2024 at 6:21 PM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
> wrote:
>
>> On 12/19/24 08:50, Adrian Klaver wrote:
>> > On 12/19/24 08:46, Renzo Dani wrote:
>> >
>> > Again.
>> >
>> > Reply to list also using Reply All.
>> > Ccing list.
>> >
>> >> Hi Adrian,
>> >> here a new version of the script that I just tested produce the same
>> >> problem.
>> >> The script do not rely now on any additional relation than the ones
>> >> defined into the script.
>>
>> I could not replicate using Ubuntu 22.04 and Postgres 16.6.
>>
>> From your original post:
>>
>> "I reproduced the problem on PostgreSQL versions 16.1 and 17.1."
>>
>> The latest bug fixes of each are 16.6 and 17.2. I would upgrade to those
>> and then try again.
>>
>> >>
>> >> BR
>> >> Renzo
>> >>
>>
>> --
>> Adrian Klaver
>> adrian(dot)klaver(at)aklaver(dot)com
>>
>>