Uploaded image for project: 'mod-data-export-spring'
  1. mod-data-export-spring
  2. MODEXPS-21

Remove gen_random_uuid(), it fails in pgpool native replication

    XMLWordPrintable

    Details

    • Type: Story
    • Status: Open (View Workflow)
    • Priority: P4
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Labels:
    • Template:
    • Development Team:
      Firebird

      Description

      gen_random_uuid() creates a different UUID in each node of a replicated PostgreSQL environment when running Pgpool-II in native replication mode.
      This has been reported for mod-configuration and Pgpool-II replication in #sys-ops on Slack. From the Pgpool-II manual:
      https://www.pgpool.net/docs/latest/en/html/restrictions.html

      There is no guarantee that any data provided using a context-dependent mechanism (e.g. random number, transaction ID, OID, SERIAL, sequence), will be replicated correctly on multiple backends.

      RMB documentation mentions it in the upgrading guide for RMB 25 and in connection with "generateId": https://github.com/folio-org/raml-module-builder/#the-post-tenant-api

      Tasks:

      • Remove gen_random_uuid usage; use a hard-coded value, or generate UUID in Java
      • Remove "CREATE EXTENSION pgcrypto"

      Note:

      This doesn't affect Pgpool-II streaming replication mode, only Pgpool-II native replication mode.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              julianladisch Julian Ladisch
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated: