"Lost connection to MySQL server during query" in archivematica-storage-service logs

[Murilo Souza dos Santos]

Hello everyone,

I've been seeing the following error persistently in the archivematica-storage-service logs:

Traceback (most recent call last):
  File "/usr/lib/archivematica/storage-service/locations/models/async_manager.py", line 58, in _watchdog
    AsyncManager._watchdog_loop()
  File "/usr/lib/archivematica/storage-service/locations/models/async_manager.py", line 74, in _watchdog_loop
    ).delete()
  File "/usr/share/archivematica/virtualenvs/archivematica-storage-service/lib/python3.10/site-packages/django/db/models/query.py", line 746, in delete
    deleted, _rows_count = collector.delete()
  File "/usr/share/archivematica/virtualenvs/archivematica-storage-service/lib/python3.10/site-packages/django/db/models/deletion.py", line 400, in delete
    with transaction.atomic(using=self.using, savepoint=False):
  File "/usr/share/archivematica/virtualenvs/archivematica-storage-service/lib/python3.10/site-packages/django/db/transaction.py", line 207, in __enter__
    connection.set_autocommit(False, force_begin_transaction_with_broken_autocommit=True)
  File "/usr/share/archivematica/virtualenvs/archivematica-storage-service/lib/python3.10/site-packages/django/db/backends/base/base.py", line 415, in set_autocommit
    self._set_autocommit(autocommit)
  File "/usr/share/archivematica/virtualenvs/archivematica-storage-service/lib/python3.10/site-packages/django/db/backends/mysql/base.py", line 271, in _set_autocommit
    with self.wrap_database_errors:
  File "/usr/share/archivematica/virtualenvs/archivematica-storage-service/lib/python3.10/site-packages/django/db/utils.py", line 90, in __exit__
    raise dj_exc_value.with_traceback(traceback) from exc_value
  File "/usr/share/archivematica/virtualenvs/archivematica-storage-service/lib/python3.10/site-packages/django/db/backends/mysql/base.py", line 272, in _set_autocommit
    self.connection.autocommit(autocommit)
  File "/usr/share/archivematica/virtualenvs/archivematica-storage-service/lib/python3.10/site-packages/MySQLdb/connections.py", line 240, in autocommit
    _mysql.connection.autocommit(self, on)
django.db.utils.OperationalError: (2013, 'Lost connection to MySQL server during query')

After restarting the VM, the service started working again, but before that, I couldn’t even access the system version page (/administration/version/) or perform fixity tests.

Does anyone know what could cause this issue and how to prevent it from happening again?

Thanks in advance for any insights!

Murilo Souza