Bug 10589 - Bugzilla can't be reliably accessed at ~08:45 UTC each day
Summary: Bugzilla can't be reliably accessed at ~08:45 UTC each day
Status: RESOLVED FIXED
Alias: None
Product: Bugzilla
Classification: Infrastructure
Component: bugzilla (show other bugs)
Version: unspecified
Hardware: x86 Multiple
: Medium+ normal
Target Milestone: Q4
Assignee: Michael Halstead
QA Contact:
URL:
Whiteboard:
Depends on:
Blocks:
 
Reported: 2016-11-03 09:50 UTC by Joshua Lock
Modified: 2016-11-05 03:40 UTC (History)
4 users (show)

See Also:
OS type for building Yocto: ---
Type of Regression: ---
Verified:
Documentation change: No (bug/feature does not impact docs)

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Joshua Lock 2016-11-03 09:50:27 UTC 
Around 08:45 GMT/UTC each day we reliably run into errors accessing the Yocto Project Bugzilla.

The errors are error 28 from the storage engine, i.e.

"undef error - DBD::mysql::st execute failed: Got error 28 from storage engine...."

When I first saw this Michael suggested that this error seems to occur when the bugzilla database is being backed up and that we might want a new backup strategy.

As an interim solution it could be useful to move the backup earlier in the day, 08:45 UTC is when several of our contributors and users in Europe are already trying to access Bugzilla.
Comment 1 Joshua Lock 2016-11-04 09:11:22 UTC 
FWIW the window of unavailability is quite long. I was unable to access bugzilla from ~08:45 - ~09:10
Comment 2 Michael Halstead 2016-11-05 03:40:19 UTC 
I've altered the backup strategy. Bugzilla now stays online during the backup process. I've also moved it to 5AM UTC where the performance hit will trouble fewer users.