update-pkgcache crashing with OOPS

[Paul Collins]

This seems to have been happening for about a week (alerting config is set to 192h):

2023-06-13 07:19:04 INFO Logging INFO and higher messages to /srv/launchpad.net/production-logs/update-pkgcache.log
2023-06-13 07:19:04 INFO Creating lockfile: /var/lock/launchpad-update-cache.lock
2023-06-13 07:19:09 INFO Updating ubuntu package counters
2023-06-13 07:19:39 INFO Updating ubuntu main archives
2023-06-13 07:19:39 INFO ubuntu mantic Primary Archive for Ubuntu starting
2023-06-13 07:25:13 INFO ubuntu lunar Primary Archive for Ubuntu starting
2023-06-13 07:31:11 INFO ubuntu kinetic Primary Archive for Ubuntu starting
2023-06-13 07:37:29 INFO ubuntu jammy Primary Archive for Ubuntu starting
2023-06-13 07:43:48 INFO ubuntu impish Primary Archive for Ubuntu starting
2023-06-13 07:43:48 INFO ubuntu hirsute Primary Archive for Ubuntu starting
2023-06-13 07:43:48 INFO ubuntu groovy Primary Archive for Ubuntu starting
2023-06-13 07:43:48 INFO ubuntu focal Primary Archive for Ubuntu starting
2023-06-13 07:53:25 INFO ubuntu eoan Primary Archive for Ubuntu starting
2023-06-13 07:53:25 INFO ubuntu disco Primary Archive for Ubuntu starting
2023-06-13 07:53:25 INFO ubuntu cosmic Primary Archive for Ubuntu starting
2023-06-13 07:53:25 INFO ubuntu bionic Primary Archive for Ubuntu starting
2023-06-13 08:03:14 INFO ubuntu artful Primary Archive for Ubuntu starting
2023-06-13 08:03:14 INFO ubuntu zesty Primary Archive for Ubuntu starting
2023-06-13 08:03:14 INFO ubuntu yakkety Primary Archive for Ubuntu starting
2023-06-13 08:03:14 INFO ubuntu xenial Primary Archive for Ubuntu starting
2023-06-13 08:11:32 INFO ubuntu wily Primary Archive for Ubuntu starting
2023-06-13 08:11:32 INFO ubuntu vivid Primary Archive for Ubuntu starting
2023-06-13 08:11:32 INFO ubuntu utopic Primary Archive for Ubuntu starting
2023-06-13 08:11:32 INFO ubuntu trusty Primary Archive for Ubuntu starting
2023-06-13 08:16:26 ERROR Unhandled exception
Traceback (most recent call last):
  File "/srv/launchpad.net/production/launchpad-rev-620cd5280e3a973662e263ebf9346837ed657a46/lib/lp/services/scripts/base.py", line 93, in log_unhandled_exceptions_func
    return func(self, *args, **kw)
  File "/srv/launchpad.net/production/launchpad-rev-620cd5280e3a973662e263ebf9346837ed657a46/lib/lp/services/scripts/base.py", line 371, in lock_and_run
    self.run(use_web_security=use_web_security, isolation=isolation)
  File "/srv/launchpad.net/production/launchpad-rev-620cd5280e3a973662e263ebf9346837ed657a46/lib/lp/services/scripts/base.py", line 93, in log_unhandled_exceptions_func
    return func(self, *args, **kw)
  File "/srv/launchpad.net/production/launchpad-rev-620cd5280e3a973662e263ebf9346837ed657a46/lib/lp/services/scripts/base.py", line 321, in run
    self.main()
  File "/srv/launchpad.net/production/launchpad-rev-620cd5280e3a973662e263ebf9346837ed657a46/lib/lp/soyuz/scripts/update_pkgcache.py", line 103, in main
    self.updateDistributionCache(distribution, archive)
  File "/srv/launchpad.net/production/launchpad-rev-620cd5280e3a973662e263ebf9346837ed657a46/lib/lp/soyuz/scripts/update_pkgcache.py", line 55, in updateDistributionCache
    self.updateDistroSeriesCache(distroseries, archive)
  File "/srv/launchpad.net/production/launchpad-rev-620cd5280e3a973662e263ebf9346837ed657a46/lib/lp/soyuz/scripts/update_pkgcache.py", line 84, in updateDistroSeriesCache
    distroseries, archive=archive, ztm=self.txn, log=self.logger
  File "/srv/launchpad.net/production/launchpad-rev-620cd5280e3a973662e263ebf9346837ed657a46/lib/lp/soyuz/model/distroseriespackagecache.py", line 270, in updateAll
    cls._update(distroseries, chunk, archive, log)
  File "/srv/launchpad.net/production/launchpad-rev-620cd5280e3a973662e263ebf9346837ed657a46/lib/lp/soyuz/model/distroseriespackagecache.py", line 211, in _update
    cache.summary = details[0][0]
IndexError: list index out of range
2023-06-13 08:16:26 INFO OOPS-32c3f24ef4d7dc53e3ee09e7f43bd832

[Colin Watson (cjwatson)]

I'm not sure what was going on here and it may still be worth fixing, but the current run seems to be getting a lot further without us having changed anything ...