Duplicate key exists in unique index

The test_dml_on_global_tbls is flaky and now failed with:

FAILED test/int/test_sql.py::test_dml_on_global_tbls - conftest.TarantoolError: ('ER_TUPLE_FOUND', 'Duplicate key exists in unique index "GLOBAL_T_pkey" in space "GLOBAL_T" with old tuple - [5, 1] and new tuple - [5, 1]', './src/box/memtx_tree.cc:1133')

See https://git.picodata.io/picodata/picodata/picodata/-/jobs/207220

added bug label

        # test reading subtree with motion
>       data = i1.retriable_sql("insert into global_t select count(*), 1 from t")
cluster    = Cluster("127.0.0.1", n=2)
data       = {'row_count': 4}
ddl        = {'row_count': 1}
i1         = Instance(i1, listen=127.0.0.1:4935 cluster=cluster-8-14)
i2         = Instance(i2, listen=127.0.0.1:4936 cluster=cluster-8-14)
test/int/test_sql.py:520: 

Подозреваю дело в retriable_sql, и наверняка тут замешан #785 (closed)

И еще !1101 (merged)

added 1 deleted label

marked this issue as related to #785 (closed)

assigned to @senya_volynets

Проблема вероятно в таймауте в котором запись завершилась успешно и вторая попытка падает с дубликатом. Нужно либо заиметь ON CONFLICT, либо заигнорить такую ошибку в retriable_sql. Ну и сам по себе retriable sql это подорожник от которого мы избавимся.

added triaged label

changed milestone to %24.6 - Plugins and Tiers

mentioned in merge request !1196 (merged)

added 1 deleted label

closed with merge request !1196 (merged)

changed milestone to %24.5 - Lowercase