[Bug 56679] New: Bugzilla seems flaky
https://bugs.winehq.org/show_bug.cgi?id=56679 Bug ID: 56679 Summary: Bugzilla seems flaky Product: WineHQ Bugzilla Version: unspecified Hardware: x86-64 OS: Linux Status: NEW Keywords: source Severity: normal Priority: P2 Component: bugzilla-unknown Assignee: wine-bugs(a)winehq.org Reporter: imwellcushtymelike(a)gmail.com CC: austinenglish(a)gmail.com Distribution: --- The bugzilla, and to a lesser extent the AppDB, is timing out pretty much all of the time. I've been linking bugs to the AppDB and noticed this has happened multiple times an hour for past few days, possibly weeks. Obviously the more you use it, the more you notice it. Sometimes you even get the Cloudflare notice that the server isn't responding, so it seems unlikely to be unique to me. It used to be pretty stable, so I don't know what changed. Querying DNS shows that different IP addresses are returned, presumably for load balancing. I don't know how to test this further... -- Do not reply to this email, post in Bugzilla using the above URL to reply. You are receiving this mail because: You are watching all bug changes.
https://bugs.winehq.org/show_bug.cgi?id=56679 --- Comment #1 from Ken Sharp <imwellcushtymelike(a)gmail.com> --- It may also be why we sometimes see identical duplicates logged. -- Do not reply to this email, post in Bugzilla using the above URL to reply. You are receiving this mail because: You are watching all bug changes.
https://bugs.winehq.org/show_bug.cgi?id=56679 Austin English <austinenglish(a)gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |jnewman(a)codeweavers.com -- Do not reply to this email, post in Bugzilla using the above URL to reply. You are receiving this mail because: You are watching all bug changes.
https://bugs.winehq.org/show_bug.cgi?id=56679 --- Comment #2 from Jeremy Newman <jnewman(a)codeweavers.com> --- I've done some tweaking, and will continue to tweak. I've increased the amount of RAM for the mysql VPS. I've also turned the query cache on (defaults to off). Hopefully these changes help. We also had an issue were bots looking for the old Wine-Staging tracker were being redirected to our bugzilla. This would cause the site to get hammered quite heavily when those bots would hit is. To fix that I've turned off the old dev.wine-staging.com A record in DNS. -- Do not reply to this email, post in Bugzilla using the above URL to reply. You are receiving this mail because: You are watching all bug changes.
https://bugs.winehq.org/show_bug.cgi?id=56679 Jeremy Newman <jnewman(a)codeweavers.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution|--- |FIXED --- Comment #3 from Jeremy Newman <jnewman(a)codeweavers.com> --- Bugzilla seems better now since I increased the RAM for MariaDB, and setup a SQL cache. Ideally to make it even better I'd split the AppDB off onto a different MariaDB VPS instance, freeing up resources for both. But the AppDB is written in such a way that make this impossible until that code is rewritten to truely allow the two databases to be on different hosts. Right now, there are AppDB,Bugzilla JOINs in some queries. Not only that, but the AppDB is horribly optimized. Many tables do not have proper indexes setup causing unnecessary thrashing of the DB. The SQL cache does help here a bit. Those issues can be setup as new bugs. Closing this one out. -- Do not reply to this email, post in Bugzilla using the above URL to reply. You are receiving this mail because: You are watching all bug changes.
https://bugs.winehq.org/show_bug.cgi?id=56679 Jeremy Newman <jnewman(a)codeweavers.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |CLOSED --- Comment #4 from Jeremy Newman <jnewman(a)codeweavers.com> --- Closing. -- Do not reply to this email, post in Bugzilla using the above URL to reply. You are receiving this mail because: You are watching all bug changes.
participants (1)
-
WineHQ Bugzilla