https://sentry.io/organizations/project-koku/issues/2826629390/?project=1822753&referrer=slack
https://sentry.io/organizations/project-koku/issues/2826635888/?project=1822753&referrer=slack
Looks like we need to update the max_locks_per_transaction parameter to be higher. Looking at the worker logs I see the following:
[2021-11-30 19:27:41,180] INFO b23a7fe5-a62a-41de-9e18-158f06692dba Populating monthly cost from 2021-11-01 00:00:00+00:00 to 2021-12-01 00:00:00+00:00.
[1;31m[2021-11-30 19:30:13,147] ERROR b23a7fe5-a62a-41de-9e18-158f06692dba Task failed: out of shared memory
HINT: You might need to increase max_locks_per_transaction.
Traceback (most recent call last):
File "/opt/app-root/lib64/python3.8/site-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
psycopg2.errors.OutOfMemory: out of shared memory
HINT: You might need to increase max_locks_per_transaction.
- mentioned on