Skip to content

[export] Avoid postgres error with too many locks per transaction

Øyvind Evju requested to merge 1947-improve-export-script-3 into dev

Description

Rollback session in loop to avoid hitting postgres error of out of shared memory.

Related issues

Notes to review (code/docs/QA)

Tests

General

  • Tests have been added that prove my fix is effective or that my feature works
  • Related tests have been modified/removed

Hypothesis testing:

  • Soak testing has been done
  • Distribution between positive / negative cases has been checked

Database

  • Includes changes to database schema
  • Includes necessary database migrations

Configuration

  • Includes changes to configuration
  • Includes configuration migration instructions in documentation

Closes #1947 (closed)

Merge request reports