Uploaded image for project: 'Cost Management'
  1. Cost Management
  2. COST-2113

Sentry: OperationalError - out of shared memory

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Normal Normal
    • 2021Q4
    • None
    • None
    • False
    • False

      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.
      [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.

            hproctor HAP Proctor (Inactive)
            abaiken Ashley Morgan (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: