<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<!DOCTYPE bugzilla SYSTEM "https://bugzilla.yoctoproject.org/page.cgi?id=bugzilla.dtd">

<bugzilla version="5.0.6"
          urlbase="https://bugzilla.yoctoproject.org/"
          
          maintainer="it-coreprojects-helpdesk@linuxfoundation.org"
>

    <bug>
          <bug_id>10589</bug_id>
          
          <creation_ts>2016-11-03 09:50:27 +0000</creation_ts>
          <short_desc>Bugzilla can&apos;t be reliably accessed at ~08:45 UTC each day</short_desc>
          <delta_ts>2016-11-05 03:40:19 +0000</delta_ts>
          <reporter_accessible>1</reporter_accessible>
          <cclist_accessible>1</cclist_accessible>
          <classification_id>5</classification_id>
          <classification>Infrastructure</classification>
          <product>Bugzilla</product>
          <component>bugzilla</component>
          <version>unspecified</version>
          <rep_platform>x86</rep_platform>
          <op_sys>Multiple</op_sys>
          <bug_status>RESOLVED</bug_status>
          <resolution>FIXED</resolution>
          
          
          <bug_file_loc></bug_file_loc>
          <status_whiteboard></status_whiteboard>
          <keywords></keywords>
          <priority>Medium+</priority>
          <bug_severity>normal</bug_severity>
          <target_milestone>Q4</target_milestone>
          
          
          <everconfirmed>1</everconfirmed>
          <reporter name="Joshua Lock">joshuagloe</reporter>
          <assigned_to name="Michael Halstead">mhalstead</assigned_to>
          <cc>infras.bug.watcher</cc>
    
    <cc>Infras.watcher</cc>
    
    <cc>randy.macleod</cc>
    
    <cc>richard.purdie</cc>
          
          
          <cf_os>---</cf_os>
          <cf_regression_type>---</cf_regression_type>
          
          <cf_docchange>No (bug/feature does not impact docs)</cf_docchange>

      

      

      

          <comment_sort_order>oldest_to_newest</comment_sort_order>  
          <long_desc isprivate="0" >
    <commentid>67883</commentid>
    <comment_count>0</comment_count>
    <who name="Joshua Lock">joshuagloe</who>
    <bug_when>2016-11-03 09:50:27 +0000</bug_when>
    <thetext>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.

&quot;undef error - DBD::mysql::st execute failed: Got error 28 from storage engine....&quot;

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.</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>67965</commentid>
    <comment_count>1</comment_count>
    <who name="Joshua Lock">joshuagloe</who>
    <bug_when>2016-11-04 09:11:22 +0000</bug_when>
    <thetext>FWIW the window of unavailability is quite long. I was unable to access bugzilla from ~08:45 - ~09:10</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>68013</commentid>
    <comment_count>2</comment_count>
    <who name="Michael Halstead">mhalstead</who>
    <bug_when>2016-11-05 03:40:19 +0000</bug_when>
    <thetext>I&apos;ve altered the backup strategy. Bugzilla now stays online during the backup process. I&apos;ve also moved it to 5AM UTC where the performance hit will trouble fewer users.</thetext>
  </long_desc>
      
      

    </bug>

</bugzilla>