I’m using ColumnStore 11.1.4-MariaDB-1:11.1.4+maria~deb12 and while I’m doing many inserts (one by one) I gained this type of error:

1815 - Internal error: CAL0001: Insert Failed: MCS-2009: Unable to perform the insert operation because DMLProc batchinsert with PID 1360617 is currently holding the table lock for session 316.

And I tried to make all INSERT queries like

START TRANSACTION ;

INSERT INTO transactions (id, park_id, event_at, category_id, amount, description, driver_id)
VALUES
  ( 5465425840062, 2, '2021-11-30 07:33:25', 'partner_ride_fee', -88.4, 'Комиссия партнёра по заказу', 'db8b4a66d9904b0ca3677cd945e7a45b');

COMMIT;

to iniate transaction and commit it, but now I’m stuck with this error:

CAL0001: Insert Failed: a BRM Begin copy error.

while executing this:

START TRANSACTION;
INSERT INTO transactions ( id, park_id, event_at, category_id, amount, description, driver_id, order_id, short_order_id, dispatcher_name )
VALUES
  ( 15549683950031, 1, '2024-05-15 09:14:39', 'platform_ride_fee', - 82, 
  'Комиссия сервиса по заказу Общеобразовательная средняя школа №130, Шымкент, микрорайон Астана', '355f17ac1c5b5884033ae4a8f4334200', '4a20286d4cdec7d28ee3f192ab36b075', 12214134, NULL); 
COMMIT;

Is there any suggestions how can I prevent errors while inserts are executing? Should I do something like

INSERT transactions ( id, park_id, event_at, category_id, amount, description, driver_id, order_id, short_order_id, dispatcher_name )
     VALUES (),
            (),
            ()

instead? Or what?