public inbox for [email protected]
help / color / mirror / Atom feedFrom: Kouber Saparev <[email protected]>
To: Bertrand Drouvot <[email protected]>
Cc: [email protected]
Cc: Michael Paquier <[email protected]>
Subject: Re: BF mamba failure
Date: Fri, 11 Oct 2024 11:07:29 +0300
Message-ID: <CAN4RuQtMHbVjWX-0sHOmVUxpsbMDX0tMndvfmNk-+ak4QBUWJg@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CAA4eK1KxuMVyAryz_Vk5yq3ejgKYcL6F45Hj9ZnMNBS-g+PuZg@mail.gmail.com>
<[email protected]>
<172854117093.1162.5418906857588663992.pgcf@coridan.postgresql.org>
<[email protected]>
На чт, 10.10.2024 г. в 17:42 Bertrand Drouvot <[email protected]>
написа:
>
> Does the error message looks like (added in [1]):
>
> "
> trying to drop stats entry already dropped: kind=%s dboid=%u objoid=%u
> refcount=%u",
> "
>
> by any chance? If so, would you mind to share it?
>
> Regards,
>
> [1]: https://postgr.es/c/d92573adcb
Unfortunately not, we are running 15.4 and planning to upgrade very soon.
Is the patch mentioned already merged in PostgreSQL 16?
The last lines in the log are:
2024-09-22 07:33:53.913 UTC,,,223214,,64e79dc1.367ee,3255151,,2023-08-24
18:13:21 UTC,1/0,0,FATAL,XX000,"can only drop stats once",,,,,"WAL redo at
45F8F/DB943818 for Transaction/COMMIT: 2024-09-22 07:24:49.603408+00;
dropped stats: 2/16420/3237787065 2/16420/3237787064 2/16420/3237787061;
inval msgs: catcache 32 catcache 7 catcache 6 catcache 7 catcache 6
catcache 55 catcache 54 catcache 7 catcache 6 catcache 7 catcache 6
catcache 7 catcache 6 catcache 7 catcache 6 catcache 7 catcache 6 catcache
7 catcache 6 catcache 7 catcache 6 catcache 7 catcache 6 catcache 7
catcache 6 catcache 55 catcache 54 catcache 80 catcache 79 catcache 80
catcache 79 catcache 7 catcache 6 catcache 7 catcache 6 catcache 7 catcache
6 catcache 7 catcache 6 catcache 7 catcache 6 catcache 7 catcache 6
catcache 7 catcache 6 catcache 7 catcache 6 catcache 7 catcache 6 catcache
7 catcache 6 catcache 7 catcache 6 catcache 7 catcache 6 catcache 7
catcache 6 catcache 7 catcache 6 catcache 7 catcache 6 catcache 7 catcache
6 catcache 55 catcache 54 relcache 3237787065 relcache 3237787064 snapshot
2608 relcache 3237787064 snapshot 2608 snapshot 2608 snapshot 2608 relcache
3237787061 snapshot 2608 snapshot 1214",,,,"","startup",,0
2024-09-22 07:33:54.501 UTC,,,223207,,64e79dc0.367e7,1423,,2023-08-24
18:13:20 UTC,,0,LOG,00000,"startup process (PID 223214) exited with exit
code 1",,,,,,,,,"","postmaster",,0
2024-09-22 07:33:54.501 UTC,,,223207,,64e79dc0.367e7,1424,,2023-08-24
18:13:20 UTC,,0,LOG,00000,"terminating any other active server
processes",,,,,,,,,"","postmaster",,0
2024-09-22 07:33:55.398 UTC,,,223207,,64e79dc0.367e7,1425,,2023-08-24
18:13:20 UTC,,0,LOG,00000,"shutting down due to startup process
failure",,,,,,,,,"","postmaster",,0
2024-09-22 07:33:56.697 UTC,,,223207,,64e79dc0.367e7,1426,,2023-08-24
18:13:20 UTC,,0,LOG,00000,"database system is shut
down",,,,,,,,,"","postmaster",,0
--
Kouber
view thread (2+ messages)
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], [email protected]
Subject: Re: BF mamba failure
In-Reply-To: <CAN4RuQtMHbVjWX-0sHOmVUxpsbMDX0tMndvfmNk-+ak4QBUWJg@mail.gmail.com>
* 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