[taler-anastasis] branch master updated: -fix issue with multiple dbinit running concurrently

[gnunet]

This is an automated email from the git hooks/post-receive script.

grothoff pushed a commit to branch master
in repository anastasis.

The following commit(s) were added to refs/heads/master by this push:
     new dd7567f  -fix issue with multiple dbinit running concurrently
dd7567f is described below

commit dd7567fd05b29004c6517963923deacadfbc0a73
Author: Christian Grothoff <grothoff@gnunet.org>
AuthorDate: Sun Aug 27 14:05:09 2023 +0200

    -fix issue with multiple dbinit running concurrently
---
 src/stasis/versioning.sql | 7 ++++++-
 1 file changed, 6 insertions(+), 1 deletion(-)

diff --git a/src/stasis/versioning.sql b/src/stasis/versioning.sql
index 116f409..c7fa812 100644
--- a/src/stasis/versioning.sql
+++ b/src/stasis/versioning.sql
@@ -146,12 +146,17 @@
 
 BEGIN;
 
+-- Added by Christian Grothoff to support concurrency, see
+-- 
https://stackoverflow.com/questions/29900845/create-schema-if-not-exists-raises-duplicate-key-error?rq=4
+LOCK TABLE pg_catalog.pg_namespace;
+
+
 -- This file adds versioning support to database it will be loaded to.
 -- It requires that PL/pgSQL is already loaded - will raise exception 
otherwise.
 -- All versioning "stuff" (tables, functions) is in "_v" schema.
 
 -- All functions are defined as 'RETURNS SETOF INT4' to be able to make them 
to RETURN literally nothing (0 rows).
--- >> RETURNS VOID<< IS similar, but it still outputs "empty line" in psql 
when calling.
+-- >> RETURNS VOID<< IS similar, but it still outputs "empty line" in psql 
when calling
 CREATE SCHEMA IF NOT EXISTS _v;
 COMMENT ON SCHEMA _v IS 'Schema for versioning data and functionality.';
 

-- 
To stop receiving notification emails like this one, please contact
gnunet@gnunet.org.