N2WS-21092 - S3 cleanup fails with Out of range value

N2WS-21092 - S3 cleanup fails with Out of range value

Issue:

Cleanup is failing with below error in the cpm_server logs
ERROR:  other_maintenance_tasks(handlers.py:2003)  Failed running S3 cleanup for disabled policies, encountered an exception
Traceback (most recent call last):
  File "/opt/n2wsoftware/python/lib/python3.7/site-packages/django/db/backends/utils.py", line 84, in _execute
    return self.cursor.execute(sql, params)
  File "/opt/n2wsoftware/python/lib/python3.7/site-packages/django/db/backends/mysql/base.py", line 73, in execute
    return self.cursor.execute(query, args)
  File "/opt/n2wsoftware/python/lib/python3.7/site-packages/MySQLdb/cursors.py", line 206, in execute
    res = self._query(query)
  File "/opt/n2wsoftware/python/lib/python3.7/site-packages/MySQLdb/cursors.py", line 312, in _query
    db.query(q)
  File "/opt/n2wsoftware/python/lib/python3.7/site-packages/MySQLdb/connections.py", line 224, in query
    _mysql.connection.query(self, query)
MySQLdb._exceptions.DataError: (1264, "Out of range value for column 'total_transfer_size' at row 1")


Solution:
Patch for v4.1.1a is available and attached to this KB. 



Click here to go back to the Release notes: Release notes for the latest v4.1.x CPM release