ArcadeDB Version:

24.6.1

Using a transaction (BEGIN ... COMMIT) and a backup (BACKUP DATABASE) right afterwards in SQLscript,
frequently a "pending transaction" error is logged. Thus, I propose a new SQLscript command WAIT, which pauses until all pending transactions are completed.

Expected behavior

SQLscript:

BEGIN;
something
COMMIT;
WAIT;
BACKUP DATABASE;

Current behavior

SQLscript:

BEGIN;
something
COMMIT;
BACKUP DATABASE;

Log:

SEVER [BackupDatabaseStatement] Found pending transaction. Rolling it back before the backup...