[MacPorts] #72328: buildbot: Processing Failed

[MacPorts]

#72328: buildbot: Processing Failed
-----------------------------+---------------------
  Reporter:  ryandesign      |      Owner:  admin@…
      Type:  defect          |     Status:  closed
  Priority:  Normal          |  Milestone:
 Component:  server/hosting  |    Version:
Resolution:  fixed           |   Keywords:
      Port:                  |
-----------------------------+---------------------
Changes (by ryandesign):

 * status:  new => closed
 * resolution:   => fixed


Comment:

 Unsurprisingly the database fails an integrity check:

 {{{
 $ sudo -u buildbot sqlite3 state.sqlite "pragma integrity_check;"
 *** in database main ***
 Tree 13 page 408664: btreeInitPage() returns error code 11
 Tree 13 page 408628: btreeInitPage() returns error code 11
 wrong # of entries in index ix_buildrequest_claims_objectid
 wrong # of entries in index ix_buildrequest_claims_brid
 Error: stepping, database disk image is malformed (11)
 }}}

 I've restored yesterday's backup and re-sent webhooks from the past seven
 hours.

 Builds are currently waiting on the mirroring step which is updating its
 copy of the PortIndex. That PortIndex appears to have gotten corrputed;
 large portions of it are nulls. Just to be safe I'll delete the mirroring
 task's whole git clone and kill the mirroring task. The next one should
 check out a new git clone and build a new PortIndex from scratch, which
 will take some time.

-- 
Ticket URL: <https://trac.macports.org/ticket/72328#comment:2>
MacPorts <https://www.macports.org/>
Ports system for macOS