From 83597f2b1587994f0193d1d4dfaa20d1ad017d90 Mon Sep 17 00:00:00 2001 From: Kyr Shatskyy Date: Mon, 25 Aug 2025 15:50:49 +0200 Subject: [PATCH] docs/laptop/targets.sql: add semicolon to commit Apparently semicolon needed after transaction, otherwise it gets stuck in a transaction queue and locks the table Signed-off-by: Kyr Shatskyy --- docs/laptop/targets.sql | 5 ++--- 1 file changed, 2 insertions(+), 3 deletions(-) diff --git a/docs/laptop/targets.sql b/docs/laptop/targets.sql index 8e9517629..2165c1922 100644 --- a/docs/laptop/targets.sql +++ b/docs/laptop/targets.sql @@ -1,9 +1,8 @@ -begin transaction; +begin; insert into nodes (name, machine_type, is_vm, locked, up) values ('localhost', 'libvirt', false, true, true); insert into nodes (name, machine_type, is_vm, locked, up, mac_address, vm_host_id) values ('target-00.local', 'vps', true, false, false, '52:54:00:00:00:00', (select id from nodes where name='localhost')), ('target-01.local', 'vps', true, false, false, '52:54:00:00:00:01', (select id from nodes where name='localhost')), ('target-02.local', 'vps', true, false, false, '52:54:00:00:00:02', (select id from nodes where name='localhost')), ('target-03.local', 'vps', true, false, false, '52:54:00:00:00:03', (select id from nodes where name='localhost')); -commit transaction - +commit; -- 2.47.3