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
