0001-sql-lock-wcs_meta-table-during-schema-update-57017.patch

Benjamin Dauvergne, 28 septembre 2021 09:36

Voir les différences: en ligne côte à côte

Subject: [PATCH] sql: lock wcs_meta table during schema update (#57017)

It's only done for do_formdef_table and migrate, for do_formdef_table a
timeout is set to 10 seconds, for migrate the lock will wait
indefinitely (or less if a timeout is set in postgresql configuration,
but the default is 0, which means no timeout).

 wcs/sql.py | 11 +++++++++++
 1 file changed, 11 insertions(+)

         return get_publisher().pgconn
     def lock_wcs_meta(timeout=0):
         conn, cur = get_connection_and_cursor()
         do_meta_table(conn, cur, insert_current_sql_level=False)
         if timeout:
             cur.execute('SET LOCAL lock_timeout = %s', [timeout])
         cur.execute('LOCK wcs_meta')
     def cleanup_connection():
         if hasattr(get_publisher(), 'pgconn') and get_publisher().pgconn is not None:
             get_publisher().pgconn.close()
-...
     @guard_postgres
     def do_formdef_tables(formdef, conn=None, cur=None, rebuild_views=False, rebuild_global_views=True):
         lock_wcs_meta(timeout=10000)
         if formdef.id is None:
             return []
-...
     @guard_postgres
     def migrate():
         lock_wcs_meta()
         conn, cur = get_connection_and_cursor()
         sql_level = get_sql_level(conn, cur)
         if sql_level < 0:
+    -

Projet

Général

Profil

Produits Entr'ouvert » w.c.s.

0001-sql-lock-wcs_meta-table-during-schema-update-57017.patch