← Back to team overview

mahara-contributors team mailing list archive

[Bug 1913232] [NEW] Duplicate key value violates unique constraint "conf_fie_pk" on Docker start up

 

Public bug reported:

Mahara version: 21.04dev
OS: dockerized ubuntu:bionic
DB: Postgres (Docker image postgres:9.5)

When *restarting* a docker instance we are seeing this a lot.  It
appears to be related to "_cron_lock_*" columns.

mahara-db         | ERROR:  duplicate key value violates unique constraint "conf_fie_pk"
mahara-db         | DETAIL:  Key (field)=(_cron_lock_auth_saml_auth_saml_refresh_cron) already exists.
mahara-db         | STATEMENT:  INSERT INTO "config" ("field", "value") VALUES ( $1,  $2)
mahara-db         | ERROR:  duplicate key value violates unique constraint "conf_fie_pk"
mahara-db         | DETAIL:  Key (field)=(_cron_lock_auth_saml_auth_saml_refresh_cron) already exists.
mahara-db         | STATEMENT:  INSERT INTO "config" ("field", "value") VALUES ( $1,  $2)

** Affects: mahara
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
Matching subscriptions: Subscription for all Mahara Contributors -- please ask on #mahara-dev or mahara.org forum before editing or unsubscribing it!
https://bugs.launchpad.net/bugs/1913232

Title:
  Duplicate key value violates unique constraint "conf_fie_pk" on Docker
  start up

Status in Mahara:
  New

Bug description:
  Mahara version: 21.04dev
  OS: dockerized ubuntu:bionic
  DB: Postgres (Docker image postgres:9.5)

  When *restarting* a docker instance we are seeing this a lot.  It
  appears to be related to "_cron_lock_*" columns.

  mahara-db         | ERROR:  duplicate key value violates unique constraint "conf_fie_pk"
  mahara-db         | DETAIL:  Key (field)=(_cron_lock_auth_saml_auth_saml_refresh_cron) already exists.
  mahara-db         | STATEMENT:  INSERT INTO "config" ("field", "value") VALUES ( $1,  $2)
  mahara-db         | ERROR:  duplicate key value violates unique constraint "conf_fie_pk"
  mahara-db         | DETAIL:  Key (field)=(_cron_lock_auth_saml_auth_saml_refresh_cron) already exists.
  mahara-db         | STATEMENT:  INSERT INTO "config" ("field", "value") VALUES ( $1,  $2)

To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1913232/+subscriptions


Follow ups