It's happening at 6:00 AM UTC every time. So maybe Theymos can get up at midnight once and check all webhosting scripts and/or cronjobs which are talking to the DB to find the culprit.
Theymos wrote this:
It seems to always happen at around the same time, so I suppose it's probably some automated maintenance process messing something up, but I don't have anything running at this time, so I wonder if it's something in the web-host's networking infrastructure, or something like that. It's difficult to diagnose, since it happens rarely, and usually when I'm sleeping.
I'll use my
deleted posts archive to see gaps between posts, starting at post 63 million (October 17). I'll only show gaps larger than 3 minutes between posts (which could mean the server was inaccessible, but it could also mean there simply were no new posts for 3 minutes).
186 seconds between posts at
6300/63006744.html Tue Oct 17 00:08:26 UTC 2023
186 seconds between posts at
6300/63006749.html Tue Oct 17 00:17:02 UTC 2023
246 seconds between posts at
6300/63006776.html Tue Oct 17 00:42:50 UTC 2023
216 seconds between posts at
6300/63006959.html Tue Oct 17 02:07:19 UTC 2023
216 seconds between posts at
6300/63007520.html Tue Oct 17 05:34:25 UTC 2023
234 seconds between posts at
6301/63012218.html Wed Oct 18 00:22:49 UTC 2023
198 seconds between posts at
6301/63017579.html Wed Oct 18 22:06:37 UTC 2023
186 seconds between posts at
6301/63018064.html Thu Oct 19 00:02:49 UTC 2023
259 seconds between posts at
6301/63018293.html Thu Oct 19 01:45:32 UTC 2023
187 seconds between posts at
6301/63018547.html Thu Oct 19 03:50:50 UTC 2023
187 seconds between posts at
6302/63023712.html Fri Oct 20 00:52:02 UTC 2023
229 seconds between posts at
6302/63024251.html Fri Oct 20 04:21:56 UTC 2023
359 seconds between posts at
6302/63028944.html Sat Oct 21 00:42:55 UTC 2023
186 seconds between posts at
6302/63028967.html Sat Oct 21 01:01:20 UTC 2023
270 seconds between posts at
6302/63029016.html Sat Oct 21 01:38:08 UTC 2023
282 seconds between posts at
6303/63033797.html Sun Oct 22 01:44:31 UTC 2023
216 seconds between posts at
6303/63033842.html Sun Oct 22 02:16:13 UTC 2023
215 seconds between posts at
6303/63034137.html Sun Oct 22 04:37:55 UTC 2023
258 seconds between posts at
6303/63038660.html Mon Oct 23 00:17:25 UTC 2023
198 seconds between posts at
6304/63049868.html Wed Oct 25 01:16:19 UTC 2023
222 seconds between posts at
6305/63055527.html Thu Oct 26 00:10:50 UTC 2023
198 seconds between posts at
6305/63055614.html Thu Oct 26 01:09:49 UTC 2023
186 seconds between posts at
6305/63055827.html Thu Oct 26 03:04:44 UTC 2023
186 seconds between posts at
6305/63055901.html Thu Oct 26 03:47:56 UTC 2023
205 seconds between posts at
6306/63060564.html Fri Oct 27 01:12:20 UTC 2023
275 seconds between posts at
6306/63060578.html Fri Oct 27 01:22:25 UTC 2023
204 seconds between posts at
6306/63060666.html Fri Oct 27 02:04:43 UTC 2023
594 seconds between posts at
6306/63060861.html Fri Oct 27 03:54:43 UTC 2023
239 seconds between posts at
6306/63065809.html Sat Oct 28 02:07:43 UTC 2023
341 seconds between posts at
6307/63070434.html Sun Oct 29 00:54:31 UTC 2023
181 seconds between posts at
6307/63070449.html Sun Oct 29 01:08:20 UTC 2023
289 seconds between posts at
6307/63070585.html Sun Oct 29 02:43:38 UTC 2023
269 seconds between posts at
6307/63075227.html Mon Oct 30 00:09:37 UTC 2023
186 seconds between posts at
6307/63075426.html Mon Oct 30 01:55:37 UTC 2023
187 seconds between posts at
6308/63080180.html Mon Oct 30 22:50:02 UTC 2023
209 seconds between posts at
6308/63080470.html Tue Oct 31 00:58:43 UTC 2023
234 seconds between posts at
6308/63085944.html Wed Nov 1 03:05:07 UTC 2023
193 seconds between posts at
6308/63086275.html Wed Nov 1 05:25:32 UTC 2023
2334 seconds between posts at
6308/63086374.html Wed Nov 1 06:44:44 UTC 2023
198 seconds between posts at
6309/63091070.html Thu Nov 2 01:20:08 UTC 2023
311 seconds between posts at
6309/63091674.html Thu Nov 2 06:06:43 UTC 2023
181 seconds between posts at
6309/63091884.html Thu Nov 2 07:05:02 UTC 2023
205 seconds between posts at
6309/63096299.html Fri Nov 3 00:44:38 UTC 2023
228 seconds between posts at
6309/63096436.html Fri Nov 3 02:00:31 UTC 2023
185 seconds between posts at
6309/63096459.html Fri Nov 3 02:15:25 UTC 2023
186 seconds between posts at
6309/63096462.html Fri Nov 3 02:18:49 UTC 2023
197 seconds between posts at
6310/63101573.html Sat Nov 4 01:24:31 UTC 2023
197 seconds between posts at
6310/63101607.html Sat Nov 4 01:53:37 UTC 2023
204 seconds between posts at
6310/63101929.html Sat Nov 4 04:24:55 UTC 2023
276 seconds between posts at
6310/63106327.html Sun Nov 5 00:13:01 UTC 2023
329 seconds between posts at
6310/63106437.html Sun Nov 5 01:11:37 UTC 2023
264 seconds between posts at
6310/63106462.html Sun Nov 5 01:34:19 UTC 2023
193 seconds between posts at
6311/63111491.html Mon Nov 6 00:35:02 UTC 2023
227 seconds between posts at
6311/63111755.html Mon Nov 6 02:59:31 UTC 2023
185 seconds between posts at
6313/63132878.html Fri Nov 10 00:43:49 UTC 2023
185 seconds between posts at
6313/63132951.html Fri Nov 10 01:14:43 UTC 2023
6041 seconds between posts at
6313/63133565.html Fri Nov 10 07:45:31 UTC 2023
Most of those are at UTC night, but
Ninjastic Space's graph confirms users are less active at that time, so there could be many false positives in my list.
Note to self for updates: see find_gaps_between_posts_to_track_server_downtime.txt