[Bug 56679] New: Bugzilla seems flaky

[WineHQ Bugzilla]

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: [e-mail]
          Reporter: [e-mail]
                CC: [e-mail]
      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...

[Bug 56679] Bugzilla seems flaky

[WineHQ Bugzilla]

https://bugs.winehq.org/show_bug.cgi?id=56679

--- Comment #1 from Ken Sharp  ---
It may also be why we sometimes see identical duplicates logged.

[Bug 56679] Bugzilla seems flaky

[WineHQ Bugzilla]

https://bugs.winehq.org/show_bug.cgi?id=56679

Austin English  changed:

What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[e-mail]

[Bug 56679] Bugzilla seems flaky

[WineHQ Bugzilla]

https://bugs.winehq.org/show_bug.cgi?id=56679

--- Comment #2 from Jeremy Newman  ---
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.

[Bug 56679] Bugzilla seems flaky

[WineHQ Bugzilla]

https://bugs.winehq.org/show_bug.cgi?id=56679

Jeremy Newman  changed:

What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|---                         |FIXED

--- Comment #3 from Jeremy Newman  ---
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.

[Bug 56679] Bugzilla seems flaky

[WineHQ Bugzilla]

https://bugs.winehq.org/show_bug.cgi?id=56679

Jeremy Newman  changed:

What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |CLOSED

--- Comment #4 from Jeremy Newman  ---
Closing.