[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[taler-sync] branch master updated: -fix issue with multiple dbinit runn
From: |
gnunet |
Subject: |
[taler-sync] branch master updated: -fix issue with multiple dbinit running concurrently |
Date: |
Sun, 27 Aug 2023 14:05:03 +0200 |
This is an automated email from the git hooks/post-receive script.
grothoff pushed a commit to branch master
in repository sync.
The following commit(s) were added to refs/heads/master by this push:
new 1239901 -fix issue with multiple dbinit running concurrently
new 5df3a02 Merge branch 'master' of git+ssh://git.taler.net/sync
1239901 is described below
commit 1239901f42403ce391a2853b199740f17735f421
Author: Christian Grothoff <grothoff@gnunet.org>
AuthorDate: Sun Aug 27 14:04:50 2023 +0200
-fix issue with multiple dbinit running concurrently
---
src/sync/sync-httpd_mhd.c | 2 +-
src/syncdb/versioning.sql | 7 ++++++-
2 files changed, 7 insertions(+), 2 deletions(-)
diff --git a/src/sync/sync-httpd_mhd.c b/src/sync/sync-httpd_mhd.c
index fa2344b..54b41f2 100644
--- a/src/sync/sync-httpd_mhd.c
+++ b/src/sync/sync-httpd_mhd.c
@@ -1,6 +1,6 @@
/*
This file is part of TALER
- Copyright (C) 2014, 2015, 2016 GNUnet e.V. and INRIA
+ Copyright (C) 2014, 2015, 2016 Taler Systems SA
TALER is free software; you can redistribute it and/or modify it under the
terms of the GNU Affero General Public License as published by the Free
Software
diff --git a/src/syncdb/versioning.sql b/src/syncdb/versioning.sql
index 116f409..c7fa812 100644
--- a/src/syncdb/versioning.sql
+++ b/src/syncdb/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.
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [taler-sync] branch master updated: -fix issue with multiple dbinit running concurrently,
gnunet <=