Your message dated Thu, 19 Jan 2023 21:38:50 +0100 with message-id <0334570dd75f06b94c0a7e97213e61be9da6bc98.camel@debian.org> and subject line Re: Bug#1023540: snapshot.debian.org: 504 Gateway Time-out has caused the Debian Bug report #1023540, regarding snapshot.debian.org: 504 Gateway Time-out to be marked as done. This means that you claim that the problem has been dealt with. If this is not the case it is now your responsibility to reopen the Bug report if necessary, and/or fix the problem forthwith. (NB: If you are a system administrator and have no idea what this message is talking about, this may indicate a serious mail system misconfiguration somewhere. Please contact owner@bugs.debian.org immediately.) -- 1023540: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=1023540 Debian Bug Tracking System Contact owner@bugs.debian.org with problems
--- Begin Message ---
- To: Debian Bug Tracking System <submit@bugs.debian.org>
- Subject: snapshot.debian.org: 504 Gateway Time-out
- From: Vincent Lefevre <vincent@vinc17.net>
- Date: Sun, 6 Nov 2022 11:55:55 +0100
- Message-id: <20221106105555.GA261909@zira.vinc17.org>
Package: snapshot.debian.org Severity: important Since yesterday at least, snapshot.debian.org has returned the "504 Gateway Time-out" error, at least on https://snapshot.debian.org/package/gcc-12/12.2.0-7/ -- Vincent Lefèvre <vincent@vinc17.net> - Web: <https://www.vinc17.net/> 100% accessible validated (X)HTML - Blog: <https://www.vinc17.net/blog/> Work: CR INRIA - computer arithmetic / AriC project (LIP, ENS-Lyon)
--- End Message ---
--- Begin Message ---
- To: 1023540-done@bugs.debian.org
- Subject: Re: Bug#1023540: snapshot.debian.org: 504 Gateway Time-out
- From: Baptiste Beauplat <lyknode@debian.org>
- Date: Thu, 19 Jan 2023 21:38:50 +0100
- Message-id: <0334570dd75f06b94c0a7e97213e61be9da6bc98.camel@debian.org>
- In-reply-to: <[🔎] 20a465dad3e7fd515bbae140c11b580213139d3d.camel@debian.org>
- References: <20221106105555.GA261909@zira.vinc17.org> <[🔎] 20230117071641.7nithltrlgfdy5ty@pax.zz.de> <20221106105555.GA261909@zira.vinc17.org> <[🔎] 20a465dad3e7fd515bbae140c11b580213139d3d.camel@debian.org>
On Wed, 2023-01-18 at 20:43 +0100, Baptiste Beauplat wrote: > I've optimized the code and got very promising results (down from > ~2000 > SQL queries to 4 and from over a minute to 2s). > > I've created an MR here: > > https://salsa.debian.org/snapshot-team/snapshot/-/merge_requests/9 > > I'll let you know when this is merged and deployed. The patch has been deployed, and already I'm seeing much better timings on /packages pages. That should free-up resources to process all requests and resolve the 504 issues. I'll be monitoring the logs for the next few days but I think we should be good. Best, -- Baptiste BeauplatAttachment: signature.asc
Description: This is a digitally signed message part
--- End Message ---