Yet again one of our replicas died. Should I file a bug report or something, what should we do in order to prevent it? Restart the database every month/week or so?...
2025-09-09 12:08:10.688 UTC,,,1510554,,67b3d8bc.170c9a,337,,2025-02-18 00:47:56 UTC,8111/0,0,FATAL,XX000,"trying to drop stats entry already dropped: kind=relation dboid=16420 objoid=767325170 refcount=2" ,,,,,"WAL redo at 66E4F/74A0F210 for Transaction/COMMIT: 2025-09-09 12:08:10.657171+00; dropped stats: 2/16420/767325174 2/16420/767325173 2/16420/767325170 2/16420/767325192 2/16420/767325191 2/16420/767 325189 2/16420/767325186 2/16420/767325198 2/16420/767325197 2/16420/767325196 2/16420/767325193; inval msgs: catcache 80 catcache 79 catcache 80 catcache 79 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 55 catcache 54 catcache 7 catcache 6 catc ache 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 7 catcache 6 catcache 7 catcache 6 catcache 32 catcache 55 catcache 54 catcache 55 catcache 54 catcache 55 catcache 54 catcache 32 catcache 7 catcache 6 catcache 7 catcache 6 catcache 55 catcache 54 catc ache 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 5 5 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 55 catcache 54 catcache 80 catcache 79 catcache 80 catcache 79 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 55 catcache 54 catcache 7 catcache 6 catcache 7 catcache 6 catcache 7 catcache 6 catcache 7 c atcache 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 7 catcache 6 catcache 7 catcache 6 catcache 32 catc ache 55 catcache 54 catcache 55 catcache 54 catcache 55 catcache 54 catcache 55 catcache 54 catcache 7 catcache 6 catcache 32 catcache 55 catcache 54 catcache 55 catcache 54 catcache 32 catcache 7 catcach e 6 catcache 55 catcache 54 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 55 catcache 54 catcache 80 catcache 79 catcache 8 0 catcache 79 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 c atcache 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 catca che 6 catcache 7 catcache 6 catcache 55 catcache 54 catcache 7 catcache 6 catcache 7 catcache 6 catcache 32 catcache 55 catcache 54 catcache 55 catcache 54 catcache 55 catcache 54 catcache 55 catcache 54 catcache 7 catcache 6 catcache 32 catcache 55 catcache 54 catcache 55 catcache 54 catcache 32 catcache 7 catcache 6 catcache 55 catcache 54 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 c atcache 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 c atcache 6 catcache 7 catcache 6 catcache 7 catcache 6 catcache 55 catcache 54 snapshot 2608 relcache 767325170 snapshot 1214 relcache 767325173 relcache 767325174 relcache 767325173 snapshot 2608 relcache 767325173 relcache 767325174 relcache 767325170 snapshot 2608 relcache 767325174 relcache 767325173 snapshot 2608 relcache 767325173 snapshot 2608 snapshot 2608 snapshot 2608 relcache 767325170 snapshot 2608 snapshot 1214 snapshot 2608 relcache 767325186 snapshot 1214 relcache 767325189 relcache 767325191 relcache 767325189 snapshot 2608 relcache 767325189 relcache 767325191 relcache 767325186 snapshot 2 608 relcache 767325192 relcache 767325186 snapshot 2608 relcache 767325186 relcache 767325192 relcache 767325192 relcache 767325186 snapshot 2608 relcache 767325191 relcache 767325189 snapshot 2608 relcac he 767325189 snapshot 2608 snapshot 2608 snapshot 2608 relcache 767325186 snapshot 2608 snapshot 1214 snapshot 2608 relcache 767325193 snapshot 1214 relcache 767325196 relcache 767325197 relcache 76732519 6 snapshot 2608 relcache 767325196 relcache 767325197 relcache 767325193 snapshot 2608 relcache 767325198 relcache 767325193 snapshot 2608 relcache 767325193 relcache 767325198 relcache 767325198 relcache 767325193 snapshot 2608 relcache 767325197 relcache 767325196 snapshot 2608 relcache 767325196 snapshot 2608 snapshot 2608 snapshot 2608 relcache 767325193 snapshot 2608 snapshot 1214",,,,"","startup",,0 На пт, 8.08.2025 г. в 12:04 Kouber Saparev <[email protected]> написа: > Indeed, nothing exotic about our replication. > > As for the object 4169049057, I am not able to find it anywhere in the > catalogs. Perhaps it was something that was dropped in the meantime. > > На чт, 7.08.2025 г. в 2:18 Michael Paquier <[email protected]> написа: > >> On Mon, Aug 04, 2025 at 01:00:35PM +0300, Kouber Saparev wrote: >> > We just had the same sudden replica shutdown, this time with version >> 17.3. >> > >> > 2025-08-02 22:10:02.229 UTC,,,473966,,67b3d76c.73b6e,14,,2025-02-18 >> > 00:42:20 UTC,8111/0,0,FATAL,XX000,"trying to drop stats entry already >> > dropped: kind=relation dboid=16420 objoid=4169049057 >> refcount=1",,,,,"WAL >> > redo at 6337E/9FF275E8 for Transaction/COMMIT: 2025-08-02 >> >> You are close to wraparound for this relation. Is that vanilla >> streaming replication with heap? >> -- >> Michael >> >
