test: flaky sql/prepared.test.lua test #177

avtikhon · 2020-09-28T09:58:22Z

Tarantool version:
Tarantool 2.6.0-115-ge19b392f05
Target: Linux-x86_64-RelWithDebInfo
Build options: cmake . -DCMAKE_INSTALL_PREFIX=/usr/local -DENABLE_BACKTRACE=ON
Compiler: /usr/bin/cc /usr/bin/c++
C_FLAGS: -fexceptions -funwind-tables -fno-omit-frame-pointer -fno-stack-protector -fno-common -fopenmp -msse2 -std=c11 -Wall -Wextra -Wno-strict-aliasing -Wno-char-subscripts -Wno-format-truncation -Wno-gnu-alignof-expression -fno-gnu89-inline -Wno-cast-function-type -Werror
CXX_FLAGS: -fexceptions -funwind-tables -fno-omit-frame-pointer -fno-stack-protector -fno-common -fopenmp -msse2 -std=c++11 -Wall -Wextra -Wno-strict-aliasing -Wno-char-subscripts -Wno-format-truncation -Wno-invalid-offsetof -Wno-gnu-alignof-expression -Wno-cast-function-type -Werror

OS version:

Linux (Debian 9)
OSX 14

Bug description:

https://gitlab.com/tarantool/tarantool/-/jobs/759797573#L4078

artifacts.zip

results file checksum: 417a95fc995bbfbf7115bbde5c42028e

[013] --- sql/prepared.result	Sat Sep 26 20:53:36 2020
[013] +++ sql/prepared.reject	Sun Sep 27 23:39:11 2020
[013] @@ -409,6 +409,8 @@
[013]      assert(res ~= nil)
[013]  end;
[013]   | ---
[013] + | - error: '[string "if not is_remote then     res = s:execute()  ..."]:1: assertion
[013] + |     failed!'
[013]   | ...
[013]  test_run:cmd("setopt delimiter ''");
[013]   | ---
[013] @@ -416,7 +418,7 @@
[013]   | ...
[013]  unprepare(s.stmt_id)
[013]   | ---
[013] - | - null
[013] + | - error: Prepared statement with id 119053220 does not exist
[013]   | ...
[013]  
[013]  s = prepare("SELECT count(*), count(a - 3), max(b), abs(id) FROM test WHERE b = '3';")
[013] @@ -692,28 +694,40 @@
[013]  --
[013]  box.cfg{sql_cache_size = 0 }
[013]   | ---
[013] + | - error: 'Failed to prepare SQL statement: Can''t reduce memory limit for SQL prepared
[013] + |     statements: please, deallocate active statements'
[013]   | ...
[013]  assert(box.info.sql().cache.stmt_count == 0)
[013]   | ---
[013] - | - true
[013] + | - error: assertion failed!
[013]   | ...
[013]  assert(box.info.sql().cache.size == 0)
[013]   | ---
[013] - | - true
[013] + | - error: assertion failed!
[013]   | ...
[013]  prepare("SELECT a FROM test;")
[013]   | ---
[013] - | - error: 'Failed to prepare SQL statement: Memory limit for SQL prepared statements
[013] - |     has been reached. Please, deallocate active statements or increase SQL cache size.'
[013] + | - stmt_id: 482388757
[013] + |   execute: 'function: 0x40a20410'
[013] + |   params: []
[013] + |   unprepare: 'function: 0x40a20438'
[013] + |   metadata:
[013] + |   - name: A
[013] + |     type: number
[013] + |   param_count: 0
[013]   | ...
[013]  box.cfg{sql_cache_size = 0}
[013]   | ---
[013] + | - error: 'Failed to prepare SQL statement: Can''t reduce memory limit for SQL prepared
[013] + |     statements: please, deallocate active statements'
[013]   | ...
[013]  
[013]  -- Still with small size everything should work.
[013]  --
[013]  box.cfg{sql_cache_size = 1500}
[013]   | ---
[013] + | - error: 'Failed to prepare SQL statement: Can''t reduce memory limit for SQL prepared
[013] + |     statements: please, deallocate active statements'
[013]   | ...
[013]  
[013]  test_run:cmd("setopt delimiter ';'");
[013] @@ -735,12 +749,22 @@
[013]   | ...
[013]  assert(ok == false);
[013]   | ---
[013] - | - true
[013] + | - error: assertion failed!
[013]   | ...
[013]  res;
[013]   | ---
[013] - | - 'Failed to prepare SQL statement: Memory limit for SQL prepared statements has been
[013] - |   reached. Please, deallocate active statements or increase SQL cache size.'
[013] + | - stmt_id: 3383028125
[013] + |   execute: 'function: 0x40a262c8'
[013] + |   params: []
[013] + |   unprepare: 'function: 0x40a262f0'
[013] + |   metadata:
[013] + |   - name: ID
[013] + |     type: integer
[013] + |   - name: A
[013] + |     type: number
[013] + |   - name: B
[013] + |     type: string
[013] + |   param_count: 0
[013]   | ...
[013]  
[013]  -- Check that after fiber is dead, its session gets rid of
[013] @@ -754,6 +778,8 @@
[013]   | ...
[013]  box.cfg{sql_cache_size = 0};
[013]   | ---
[013] + | - error: 'Failed to prepare SQL statement: Can''t reduce memory limit for SQL prepared
[013] + |     statements: please, deallocate active statements'
[013]   | ...
[013]  box.cfg{sql_cache_size = 3000};
[013]   | ---
[013]

https://gitlab.com/tarantool/tarantool/-/jobs/760156440#L3991

artifacts.zip

results file checksum: 16472636b3dcd186007b89f76912fa12

[005] --- sql/prepared.result	Mon Sep 28 11:15:43 2020
[005] +++ sql/prepared.reject	Mon Sep 28 12:08:43 2020
[005] @@ -179,6 +179,8 @@
[005]      assert(res ~= nil)
[005]  end;
[005]   | ---
[005] + | - error: '[string "if not is_remote then     res = s:execute({1,..."]:1: assertion
[005] + |     failed!'
[005]   | ...
[005]  test_run:cmd("setopt delimiter ''");
[005]   | ---
[005] @@ -186,16 +188,16 @@
[005]   | ...
[005]  unprepare(s.stmt_id)
[005]   | ---
[005] - | - null
[005] + | - error: Prepared statement with id 3603193623 does not exist
[005]   | ...
[005]  
[005]  assert(box.info.sql().cache.stmt_count == 0)
[005]   | ---
[005] - | - true
[005] + | - error: assertion failed!
[005]   | ...
[005]  assert(box.info.sql().cache.size == 0)
[005]   | ---
[005] - | - true
[005] + | - error: assertion failed!
[005]   | ...
[005]  
[005]  -- Test preparation of different types of queries.
[005] @@ -692,28 +694,40 @@
[005]  --
[005]  box.cfg{sql_cache_size = 0 }
[005]   | ---
[005] + | - error: 'Failed to prepare SQL statement: Can''t reduce memory limit for SQL prepared
[005] + |     statements: please, deallocate active statements'
[005]   | ...
[005]  assert(box.info.sql().cache.stmt_count == 0)
[005]   | ---
[005] - | - true
[005] + | - error: assertion failed!
[005]   | ...
[005]  assert(box.info.sql().cache.size == 0)
[005]   | ---
[005] - | - true
[005] + | - error: assertion failed!
[005]   | ...
[005]  prepare("SELECT a FROM test;")
[005]   | ---
[005] - | - error: 'Failed to prepare SQL statement: Memory limit for SQL prepared statements
[005] - |     has been reached. Please, deallocate active statements or increase SQL cache size.'
[005] + | - stmt_id: 482388757
[005] + |   execute: 'function: 0x010d34b010'
[005] + |   params: []
[005] + |   unprepare: 'function: 0x010d34b048'
[005] + |   metadata:
[005] + |   - name: A
[005] + |     type: number
[005] + |   param_count: 0
[005]   | ...
[005]  box.cfg{sql_cache_size = 0}
[005]   | ---
[005] + | - error: 'Failed to prepare SQL statement: Can''t reduce memory limit for SQL prepared
[005] + |     statements: please, deallocate active statements'
[005]   | ...
[005]  
[005]  -- Still with small size everything should work.
[005]  --
[005]  box.cfg{sql_cache_size = 1500}
[005]   | ---
[005] + | - error: 'Failed to prepare SQL statement: Can''t reduce memory limit for SQL prepared
[005] + |     statements: please, deallocate active statements'
[005]   | ...
[005]  
[005]  test_run:cmd("setopt delimiter ';'");
[005] @@ -735,12 +749,22 @@
[005]   | ...
[005]  assert(ok == false);
[005]   | ---
[005] - | - true
[005] + | - error: assertion failed!
[005]   | ...
[005]  res;
[005]   | ---
[005] - | - 'Failed to prepare SQL statement: Memory limit for SQL prepared statements has been
[005] - |   reached. Please, deallocate active statements or increase SQL cache size.'
[005] + | - stmt_id: 3383028125
[005] + |   execute: 'function: 0x010d34cca8'
[005] + |   params: []
[005] + |   unprepare: 'function: 0x010d34cce0'
[005] + |   metadata:
[005] + |   - name: ID
[005] + |     type: integer
[005] + |   - name: A
[005] + |     type: number
[005] + |   - name: B
[005] + |     type: string
[005] + |   param_count: 0
[005]   | ...
[005]  
[005]  -- Check that after fiber is dead, its session gets rid of
[005] @@ -754,6 +778,8 @@
[005]   | ...
[005]  box.cfg{sql_cache_size = 0};
[005]   | ---
[005] + | - error: 'Failed to prepare SQL statement: Can''t reduce memory limit for SQL prepared
[005] + |     statements: please, deallocate active statements'
[005]   | ...
[005]  box.cfg{sql_cache_size = 3000};
[005]   | ---
[005] @@ -771,6 +797,8 @@
[005]  
[005]  s = prepare("SELECT id, SLEEP() FROM test;");
[005]   | ---
[005] + | - error: 'Failed to prepare SQL statement: Memory limit for SQL prepared statements
[005] + |     has been reached. Please, deallocate active statements or increase SQL cache size.'
[005]   | ...
[005]  assert(s ~= nil);
[005]   | ---
[005] @@ -794,12 +822,14 @@
[005]   | ...
[005]  f2:join();
[005]   | ---
[005] - | - true
[005] + | - false
[005] + | - 'Failed to prepare SQL statement: Memory limit for SQL prepared statements has been
[005] + |   reached. Please, deallocate active statements or increase SQL cache size.'
[005]   | ...
[005]  
[005]  unprepare(s.stmt_id);
[005]   | ---
[005] - | - null
[005] + | - error: Prepared statement with id 1495950315 does not exist
[005]   | ...
[005]  
[005]  -- Now during execution of one prepared statement, in another
[005] @@ -825,7 +855,9 @@
[005]   | ...
[005]  f2:join();
[005]   | ---
[005] - | - true
[005] + | - false
[005] + | - 'Failed to prepare SQL statement: Memory limit for SQL prepared statements has been
[005] + |   reached. Please, deallocate active statements or increase SQL cache size.'
[005]   | ...
[005]  
[005]  -- tarantool/tarantool#4825: make sure that values to be bound are erased after
[005] @@ -834,46 +866,24 @@
[005]  --
[005]  s = prepare('SELECT :a, :b, :c');
[005]   | ---
[005] + | - error: 'Failed to prepare SQL statement: Memory limit for SQL prepared statements
[005] + |     has been reached. Please, deallocate active statements or increase SQL cache size.'
[005]   | ...
[005]  execute(s.stmt_id, {{[':a'] = 1}, {[':b'] = 2}, {[':c'] = 3}});
[005]   | ---
[005] - | - metadata:
[005] - |   - name: COLUMN_1
[005] - |     type: integer
[005] - |   - name: COLUMN_2
[005] - |     type: integer
[005] - |   - name: COLUMN_3
[005] - |     type: integer
[005] - |   rows:
[005] - |   - [1, 2, 3]
[005] + | - error: Prepared statement with id 1495950315 does not exist
[005]   | ...
[005]  execute(s.stmt_id, {{[':a'] = 1}, {[':b'] = 2}});
[005]   | ---
[005] - | - metadata:
[005] - |   - name: COLUMN_1
[005] - |     type: integer
[005] - |   - name: COLUMN_2
[005] - |     type: integer
[005] - |   - name: COLUMN_3
[005] - |     type: boolean
[005] - |   rows:
[005] - |   - [1, 2, null]
[005] + | - error: Prepared statement with id 1495950315 does not exist
[005]   | ...
[005]  execute(s.stmt_id);
[005]   | ---
[005] - | - metadata:
[005] - |   - name: COLUMN_1
[005] - |     type: boolean
[005] - |   - name: COLUMN_2
[005] - |     type: boolean
[005] - |   - name: COLUMN_3
[005] - |     type: boolean
[005] - |   rows:
[005] - |   - [null, null, null]
[005] + | - error: Prepared statement with id 1495950315 does not exist
[005]   | ...
[005]  unprepare(s.stmt_id);
[005]   | ---
[005] - | - null
[005] + | - error: Prepared statement with id 1495950315 does not exist
[005]   | ...
[005]  
[005]  if is_remote then
[005]

Steps to reproduce:

Optional (but very desirable):

coredump
backtrace
netstat

The text was updated successfully, but these errors were encountered:

Added for tests with issues: app/fiber.test.lua gh-5341 app-tap/debug.test.lua gh-5346 app-tap/http_client.test.lua gh-5346 app-tap/inspector.test.lua gh-5346 box/gh-2763-session-credentials-update.test.lua gh-5363 box/hash_collation.test.lua gh-5247 box/lua.test.lua gh-5351 box/net.box_connect_triggers_gh-2858.test.lua gh-5247 box/net.box_incompatible_index-gh-1729.test.lua gh-5360 box/net.box_on_schema_reload-gh-1904.test.lua gh-5354 box/protocol.test.lua gh-5247 box/update.test.lua gh-5247 box-tap/net.box.test.lua gh-5346 replication/autobootstrap.test.lua gh-4533 replication/autobootstrap_guest.test.lua gh-4533 replication/ddl.test.lua gh-5337 replication/gh-3160-misc-heartbeats-on-master-changes.test.lua gh-4940 replication/gh-3247-misc-iproto-sequence-value-not-replicated.test.lua.test.lua gh-5357 replication/gh-3637-misc-error-on-replica-auth-fail.test.lua gh-5343 replication/long_row_timeout.test.lua gh-4351 replication/on_replace.test.lua gh-5344, gh-5349 replication/prune.test.lua gh-5361 replication/qsync_advanced.test.lua gh-5340 replication/qsync_basic.test.lua gh-5355 replication/replicaset_ro_mostly.test.lua gh-5342 replication/wal_rw_stress.test.lua gh-5347 replication-py/multi.test.py gh-5362 sql/prepared.test.lua test gh-5359 sql-tap/selectG.test.lua gh-5350 vinyl/ddl.test.lua gh-5338 vinyl/gh-3395-read-prepared-uncommitted.test.lua gh-5197 vinyl/iterator.test.lua gh-5336 vinyl/write_iterator_rand.test.lua gh-5356 xlog/panic_on_wal_error.test.lua gh-5348

Added for tests with issues: app/fiber.test.lua gh-5341 app-tap/debug.test.lua gh-5346 app-tap/http_client.test.lua gh-5346 app-tap/inspector.test.lua gh-5346 box/gh-2763-session-credentials-update.test.lua gh-5363 box/hash_collation.test.lua gh-5247 box/lua.test.lua gh-5351 box/net.box_connect_triggers_gh-2858.test.lua gh-5247 box/net.box_incompatible_index-gh-1729.test.lua gh-5360 box/net.box_on_schema_reload-gh-1904.test.lua gh-5354 box/protocol.test.lua gh-5247 box/update.test.lua gh-5247 box-tap/net.box.test.lua gh-5346 replication/autobootstrap.test.lua gh-4533 replication/autobootstrap_guest.test.lua gh-4533 replication/ddl.test.lua gh-5337 replication/gh-3160-misc-heartbeats-on-master-changes.test.lua gh-4940 replication/gh-3247-misc-iproto-sequence-value-not-replicated.test.lua.test.lua gh-5357 replication/gh-3637-misc-error-on-replica-auth-fail.test.lua gh-5343 replication/long_row_timeout.test.lua gh-4351 replication/on_replace.test.lua gh-5344, gh-5349 replication/prune.test.lua gh-5361 replication/qsync_advanced.test.lua gh-5340 replication/qsync_basic.test.lua gh-5355 replication/replicaset_ro_mostly.test.lua gh-5342 replication/wal_rw_stress.test.lua gh-5347 replication-py/multi.test.py gh-5362 sql/prepared.test.lua test gh-5359 sql-tap/selectG.test.lua gh-5350 vinyl/ddl.test.lua gh-5338 vinyl/gh-3395-read-prepared-uncommitted.test.lua gh-5197 vinyl/iterator.test.lua gh-5336 vinyl/write_iterator_rand.test.lua gh-5356 xlog/panic_on_wal_error.test.lua gh-5348 (cherry picked from commit 75ba744)

Added flaky tests results files checksums: box/access.test.lua gh-5373 gh-5411 box/hash_gh-1467.test.lua gh-5476 box/net.box_incorrect_iterator_gh-841.test.lua gh-5434 box-tap/session.storage.test.lua gh-5346 engine/tuple.test.lua gh-5480 replication/bootstrap_leader.test.lua gh-5478 replication/gh-3160-misc-heartbeats-on-master-changes.test.> gh-4940 replication/ddl.test.lua gh-5337 replication/election_qsync.test.lua gh-5430 replication/election_qsync_stress.test.lua gh-5395 replication/gh-5287-boot-anon.test.lua gh-5412 sql/prepared.test.lua gh-5359 sql/checks.test.lua gh-5477 sql/gh2808-inline-unique-persistency-check.test.lua gh-5479 swim/swim.test.lua gh-5403 vinyl/deferred_delete.test.lua gh-5089 vinyl/gh-4957-too-many-upserts.test.lua gh-5378 vinyl/gh-5141-invalid-vylog-file.test.lua gh-5141 vinyl/gc.test.lua gh-5474 vinyl/iterator.test.lua gh-5141 Removed: replication/gh-5426-election-on-off.test.lua gh-5433

Added flaky tests results files checksums: box/access.test.lua gh-5373 gh-5411 box/hash_gh-1467.test.lua gh-5476 box/net.box_incorrect_iterator_gh-841.test.lua gh-5434 box-tap/session.storage.test.lua gh-5346 engine/tuple.test.lua gh-5480 replication/bootstrap_leader.test.lua gh-5478 replication/gh-3160-misc-heartbeats-on-master-changes.test.> gh-4940 replication/ddl.test.lua gh-5337 replication/election_qsync.test.lua gh-5430 replication/election_qsync_stress.test.lua gh-5395 replication/gh-5287-boot-anon.test.lua gh-5412 replication/gh-5426-election-on-off.test.lua gh-5506 sql/prepared.test.lua gh-5359 sql/checks.test.lua gh-5477 sql/gh2808-inline-unique-persistency-check.test.lua gh-5479 swim/swim.test.lua gh-5403 vinyl/deferred_delete.test.lua gh-5089 vinyl/gh-4957-too-many-upserts.test.lua gh-5378 vinyl/gh-5141-invalid-vylog-file.test.lua gh-5141 vinyl/gc.test.lua gh-5474 vinyl/iterator.test.lua gh-5141 vinyl/replica_rejoin.test.lua gh-4985

Added flaky tests results files checksums: box/access.test.lua gh-5373 gh-5411 box/hash_gh-1467.test.lua gh-5476 box/net.box_incorrect_iterator_gh-841.test.lua gh-5434 box-tap/session.storage.test.lua gh-5346 engine/tuple.test.lua gh-5480 replication/bootstrap_leader.test.lua gh-5478 replication/gh-3160-misc-heartbeats-on-master-changes.test.> gh-4940 replication/ddl.test.lua gh-5337 replication/election_basic.test.lua gh-5368 replication/election_qsync.test.lua gh-5430 replication/election_qsync_stress.test.lua gh-5395 replication/gh-5287-boot-anon.test.lua gh-5412 replication/gh-5426-election-on-off.test.lua gh-5506 sql/prepared.test.lua gh-5359 sql/checks.test.lua gh-5477 sql/gh2808-inline-unique-persistency-check.test.lua gh-5479 swim/swim.test.lua gh-5403 vinyl/deferred_delete.test.lua gh-5089 vinyl/gh-4957-too-many-upserts.test.lua gh-5378 vinyl/gh-5141-invalid-vylog-file.test.lua gh-5141 vinyl/gc.test.lua gh-5474 vinyl/iterator.test.lua gh-5141 vinyl/replica_rejoin.test.lua gh-4985

Added flaky tests results files checksums: box/access.test.lua gh-5373 gh-5411 box/hash_gh-1467.test.lua gh-5476 box/net.box_incorrect_iterator_gh-841.test.lua gh-5434 box-tap/session.storage.test.lua gh-5346 engine/tuple.test.lua gh-5480 replication/bootstrap_leader.test.lua gh-5478 replication/gh-3160-misc-heartbeats-on-master-changes.test.> gh-4940 replication/ddl.test.lua gh-5337 replication/election_basic.test.lua gh-5368 replication/election_qsync.test.lua gh-5430 replication/election_qsync_stress.test.lua gh-5395 replication/gh-5287-boot-anon.test.lua gh-5412 replication/gh-5426-election-on-off.test.lua gh-5506 sql/prepared.test.lua gh-5359 sql/checks.test.lua gh-5477 sql/gh2808-inline-unique-persistency-check.test.lua gh-5479 swim/swim.test.lua gh-5403 vinyl/deferred_delete.test.lua gh-5089 vinyl/gh-4957-too-many-upserts.test.lua gh-5378 vinyl/gh-5141-invalid-vylog-file.test.lua gh-5141 vinyl/gc.test.lua gh-5474 vinyl/iterator.test.lua gh-5141 vinyl/replica_rejoin.test.lua gh-4985 vinyl/tx_gap_lock.test.lua gh-4309

Added flaky tests results files checksums: box/access.test.lua gh-5373 gh-5411 box/hash_gh-1467.test.lua gh-5476 box/net.box_incorrect_iterator_gh-841.test.lua gh-5434 box-tap/session.storage.test.lua gh-5346 engine/tuple.test.lua gh-5480 replication/bootstrap_leader.test.lua gh-5478 replication/gh-3160-misc-heartbeats-on-master-changes.test.> gh-4940 replication/ddl.test.lua gh-5337 replication/election_basic.test.lua gh-5368 replication/election_qsync.test.lua gh-5430 replication/election_qsync_stress.test.lua gh-5395 replication/gh-5287-boot-anon.test.lua gh-5412 replication/gh-5426-election-on-off.test.lua gh-5506 replication/prune.test.lua gh-5361 sql/prepared.test.lua gh-5359 sql/checks.test.lua gh-5477 sql/gh2808-inline-unique-persistency-check.test.lua gh-5479 swim/swim.test.lua gh-5403 vinyl/deferred_delete.test.lua gh-5089 vinyl/gh-4957-too-many-upserts.test.lua gh-5378 vinyl/gh-5141-invalid-vylog-file.test.lua gh-5141 vinyl/gc.test.lua gh-5474 vinyl/iterator.test.lua gh-5141 vinyl/replica_rejoin.test.lua gh-4985 vinyl/tx_gap_lock.test.lua gh-4309

Added flaky tests results files checksums: box/access.test.lua gh-5373 gh-5411 box/hash_gh-1467.test.lua gh-5476 box/net.box_incorrect_iterator_gh-841.test.lua gh-5434 box-tap/session.storage.test.lua gh-5346 engine/tuple.test.lua gh-5480 replication/bootstrap_leader.test.lua gh-5478 replication/gh-3160-misc-heartbeats-on-master-changes.test.> gh-4940 replication/ddl.test.lua gh-5337 replication/election_basic.test.lua gh-5368 replication/election_qsync.test.lua gh-5430 replication/election_qsync_stress.test.lua gh-5395 replication/gh-5287-boot-anon.test.lua gh-5412 replication/gh-5426-election-on-off.test.lua gh-5506 replication/prune.test.lua gh-5361 sql/prepared.test.lua gh-5359 sql/checks.test.lua gh-5477 sql/gh2808-inline-unique-persistency-check.test.lua gh-5479 swim/swim.test.lua gh-5403 vinyl/deferred_delete.test.lua gh-5089 vinyl/gh-4957-too-many-upserts.test.lua gh-5378 vinyl/gh-5141-invalid-vylog-file.test.lua gh-5141 vinyl/gc.test.lua gh-5474 vinyl/iterator.test.lua gh-5141 vinyl/replica_rejoin.test.lua gh-4985 vinyl/snapshot.test.lua gh-4984 vinyl/tx_gap_lock.test.lua gh-4309

Added flaky tests results files checksums: box/access.test.lua gh-5373 gh-5411 box/hash_gh-1467.test.lua gh-5476 box/net.box_incorrect_iterator_gh-841.test.lua gh-5434 box-tap/session.storage.test.lua gh-5346 engine/tuple.test.lua gh-5480 replication/bootstrap_leader.test.lua gh-5478 replication/gh-3160-misc-heartbeats-on-master-changes.test.> gh-4940 replication/ddl.test.lua gh-5337 replication/election_basic.test.lua gh-5368 replication/election_qsync.test.lua gh-5430 replication/election_qsync_stress.test.lua gh-5395 replication/gh-5287-boot-anon.test.lua gh-5412 replication/gh-5426-election-on-off.test.lua gh-5506 replication/prune.test.lua gh-5361 sql/prepared.test.lua gh-5359 sql/checks.test.lua gh-5477 sql/gh2808-inline-unique-persistency-check.test.lua gh-5479 swim/swim.test.lua gh-5403 vinyl/deferred_delete.test.lua gh-5089 vinyl/gh-4810-dump-during-index-build.test.lua gh-5031 vinyl/gh-4957-too-many-upserts.test.lua gh-5378 vinyl/gh-5141-invalid-vylog-file.test.lua gh-5141 vinyl/gc.test.lua gh-5474 vinyl/iterator.test.lua gh-5141 vinyl/replica_rejoin.test.lua gh-4985 vinyl/snapshot.test.lua gh-4984 vinyl/tx_gap_lock.test.lua gh-4309

Added flaky tests results files checksums: box/access.test.lua gh-5373 gh-5411 box/hash_gh-1467.test.lua gh-5476 box/net.box_incorrect_iterator_gh-841.test.lua gh-5434 box-tap/session.storage.test.lua gh-5346 engine/conflict.test.lua gh-5516 engine/tuple.test.lua gh-5480 replication/bootstrap_leader.test.lua gh-5478 replication/gh-3160-misc-heartbeats-on-master-changes.test.> gh-4940 replication/ddl.test.lua gh-5337 replication/election_basic.test.lua gh-5368 replication/election_qsync.test.lua gh-5430 replication/election_qsync_stress.test.lua gh-5395 replication/gh-5287-boot-anon.test.lua gh-5412 replication/gh-5426-election-on-off.test.lua gh-5506 replication/prune.test.lua gh-5361 sql/prepared.test.lua gh-5359 sql/checks.test.lua gh-5477 sql/gh2808-inline-unique-persistency-check.test.lua gh-5479 swim/swim.test.lua gh-5403 vinyl/deferred_delete.test.lua gh-5089 vinyl/gh-4810-dump-during-index-build.test.lua gh-5031 vinyl/gh-4957-too-many-upserts.test.lua gh-5378 vinyl/gh-5141-invalid-vylog-file.test.lua gh-5141 vinyl/gc.test.lua gh-5474 vinyl/iterator.test.lua gh-5141 vinyl/replica_rejoin.test.lua gh-4985 vinyl/snapshot.test.lua gh-4984 vinyl/tx_gap_lock.test.lua gh-4309

Added flaky tests results files checksums: box/access.test.lua gh-5373 gh-5411 box/hash_gh-1467.test.lua gh-5476 box/iterator.test.lua gh-5523 box/net.box_incorrect_iterator_gh-841.test.lua gh-5434 box-tap/session.storage.test.lua gh-5346 engine/conflict.test.lua gh-5516 engine/tuple.test.lua gh-5480 replication/bootstrap_leader.test.lua gh-5478 replication/gh-3160-misc-heartbeats-on-master-changes.test.> gh-4940 replication/ddl.test.lua gh-5337 replication/election_basic.test.lua gh-5368 replication/election_qsync.test.lua gh-5430 replication/election_qsync_stress.test.lua gh-5395 replication/gh-5287-boot-anon.test.lua gh-5412 replication/gh-5426-election-on-off.test.lua gh-5506 replication/prune.test.lua gh-5361 replication/rebootstrap.test.lua gh-5524 sql/prepared.test.lua gh-5359 sql/checks.test.lua gh-5477 sql/gh2808-inline-unique-persistency-check.test.lua gh-5479 swim/swim.test.lua gh-5403 vinyl/deferred_delete.test.lua gh-5089 vinyl/gh-4810-dump-during-index-build.test.lua gh-5031 vinyl/gh-4957-too-many-upserts.test.lua gh-5378 vinyl/gh-5141-invalid-vylog-file.test.lua gh-5141 vinyl/gc.test.lua gh-5474 vinyl/iterator.test.lua gh-5141 vinyl/replica_rejoin.test.lua gh-4985 vinyl/snapshot.test.lua gh-4984 vinyl/tx_gap_lock.test.lua gh-4309

Added flaky tests results files checksums: box/access.test.lua gh-5373 gh-5411 box/cfg.test.lua gh-5530 box/hash_gh-1467.test.lua gh-5476 box/iterator.test.lua gh-5523 box/net.box_incorrect_iterator_gh-841.test.lua gh-5434 box/tree_pk_multipart.test.lua gh-5528 box-tap/session.storage.test.lua gh-5346 engine/conflict.test.lua gh-5516 engine/tuple.test.lua gh-5480 replication/bootstrap_leader.test.lua gh-5478 replication/gh-3160-misc-heartbeats-on-master-changes.test.> gh-4940 replication/ddl.test.lua gh-5337 replication/election_basic.test.lua gh-5368 replication/election_qsync.test.lua gh-5430 replication/election_qsync_stress.test.lua gh-5395 replication/gh-5287-boot-anon.test.lua gh-5412 replication/gh-5426-election-on-off.test.lua gh-5506 replication/prune.test.lua gh-5361 replication/rebootstrap.test.lua gh-5524 sql/prepared.test.lua gh-5359 sql/checks.test.lua gh-5477 sql/gh2808-inline-unique-persistency-check.test.lua gh-5479 swim/swim.test.lua gh-5403 vinyl/deferred_delete.test.lua gh-5089 vinyl/gh-4810-dump-during-index-build.test.lua gh-5031 vinyl/gh-4957-too-many-upserts.test.lua gh-5378 vinyl/gh-5141-invalid-vylog-file.test.lua gh-5141 vinyl/gc.test.lua gh-5474 vinyl/iterator.test.lua gh-5141 vinyl/replica_rejoin.test.lua gh-4985 vinyl/snapshot.test.lua gh-4984 vinyl/tx_gap_lock.test.lua gh-4309

Added flaky tests results files checksums: app-tap/tarantoolctl.test.lua gh-5059 box/access.test.lua gh-5373 gh-5411 box/cfg.test.lua gh-5530 box/hash_gh-1467.test.lua gh-5476 box/iterator.test.lua gh-5523 box/net.box_count_inconsistent_gh-3262.test.lua gh-5532 box/net.box_incorrect_iterator_gh-841.test.lua gh-5434 box/tree_pk_multipart.test.lua gh-5528 box-tap/session.storage.test.lua gh-5346 engine/conflict.test.lua gh-5516 engine/tuple.test.lua gh-5480 replication/bootstrap_leader.test.lua gh-5478 replication/gh-3160-misc-heartbeats-on-master-changes.test.> gh-4940 replication/ddl.test.lua gh-5337 replication/election_basic.test.lua gh-5368 replication/election_qsync.test.lua gh-5430 replication/election_qsync_stress.test.lua gh-5395 replication/gh-5287-boot-anon.test.lua gh-5412 replication/gh-5426-election-on-off.test.lua gh-5506 replication/prune.test.lua gh-5361 replication/rebootstrap.test.lua gh-5524 replication/sync.test.lua gh-3835 sql/prepared.test.lua gh-5359 sql/checks.test.lua gh-5477 sql/gh2808-inline-unique-persistency-check.test.lua gh-5479 swim/swim.test.lua gh-5403 vinyl/deferred_delete.test.lua gh-5089 vinyl/gh-4810-dump-during-index-build.test.lua gh-5031 vinyl/gh-4957-too-many-upserts.test.lua gh-5378 vinyl/gh-5141-invalid-vylog-file.test.lua gh-5141 vinyl/gc.test.lua gh-5474 vinyl/iterator.test.lua gh-5141 vinyl/replica_rejoin.test.lua gh-4985 vinyl/snapshot.test.lua gh-4984 vinyl/tx_gap_lock.test.lua gh-4309

Added flaky tests results files checksums: app-tap/tarantoolctl.test.lua gh-5059 box/access.test.lua gh-5373 gh-5411 box/before_replace.test.lua gh-5546 box/cfg.test.lua gh-5530 box/hash_gh-1467.test.lua gh-5476 box/iterator.test.lua gh-5523 box/net.box_count_inconsistent_gh-3262.test.lua gh-5532 box/net.box_gibberish_gh-3900.test.lua gh-5548 box/net.box_incorrect_iterator_gh-841.test.lua gh-5434 box/net.box_iproto_hangs_gh-3464.test.lua gh-5548 box/net.box_schema_change_gh-2666.test.lua gh-5547 box/select.test.lua gh-5548 box/tree_pk_multipart.test.lua gh-5528 box-tap/session.storage.test.lua gh-5346 engine/conflict.test.lua gh-5516 engine/tuple.test.lua gh-5480 replication/bootstrap_leader.test.lua gh-5478 replication/gh-3160-misc-heartbeats-on-master-changes.test.> gh-4940 replication/ddl.test.lua gh-5337 replication/election_basic.test.lua gh-5368 replication/election_qsync.test.lua gh-5430 replication/election_qsync_stress.test.lua gh-5395 replication/gh-5287-boot-anon.test.lua gh-5412 replication/gh-5426-election-on-off.test.lua gh-5506 replication/prune.test.lua gh-5361 replication/rebootstrap.test.lua gh-5524 replication/sync.test.lua gh-3835 sql/prepared.test.lua gh-5359 sql/checks.test.lua gh-5477 sql/gh2808-inline-unique-persistency-check.test.lua gh-5479 swim/swim.test.lua gh-5403 vinyl/deferred_delete.test.lua gh-5089 vinyl/errinj_tx.test.lua gh-5539 vinyl/gh-4810-dump-during-index-build.test.lua gh-5031 vinyl/gh-4957-too-many-upserts.test.lua gh-5378 vinyl/gh-5141-invalid-vylog-file.test.lua gh-5141 vinyl/gc.test.lua gh-5474 vinyl/iterator.test.lua gh-5141 vinyl/replica_rejoin.test.lua gh-4985 vinyl/snapshot.test.lua gh-4984 vinyl/tx_gap_lock.test.lua gh-4309

Added flaky tests results files checksums: app-tap/logger.test.lua gh-5346 app-tap/tarantoolctl.test.lua gh-5059 box/access.test.lua gh-5373 gh-5411 box/alter.test.lua gh-5557 box/before_replace.test.lua gh-5546 box/cfg.test.lua gh-5530 box/ddl_collation_deleted_gh-3290.test.lua gh-5555 box/hash_gh-1467.test.lua gh-5476 box/iterator.test.lua gh-5523 box/net.box_count_inconsistent_gh-3262.test.lua gh-5532 box/net.box_field_names_gh-2978.test.lua gh-5554 box/net.box_get_connection_object.test.lua gh-5549 box/net.box_gibberish_gh-3900.test.lua gh-5548 box/net.box_incorrect_iterator_gh-841.test.lua gh-5434 box/net.box_index_unique_flag_gh-4091.test.lua gh-5551 box/net.box_iproto_hangs_gh-3464.test.lua gh-5548 box/net.box_reload_schema_gh-636.test.lua gh-5550 box/net.box_schema_change_gh-2666.test.lua gh-5547 box/schema_reload.test.lua gh-5552 box/select.test.lua gh-5548 box/tree_pk_multipart.test.lua gh-5528 gh-5556 box-tap/gh-4231-box-execute-locking.test.lua gh-5558 box-tap/session.test.lua gh-5346 box-tap/session.storage.test.lua gh-5346 engine/conflict.test.lua gh-5516 engine/tuple.test.lua gh-5480 replication/bootstrap_leader.test.lua gh-5478 replication/gh-3160-misc-heartbeats-on-master-changes.test.> gh-4940 replication/ddl.test.lua gh-5337 replication/election_basic.test.lua gh-5368 replication/election_qsync.test.lua gh-5430 replication/election_qsync_stress.test.lua gh-5395 replication/gh-5287-boot-anon.test.lua gh-5412 replication/gh-5426-election-on-off.test.lua gh-5506 replication/prune.test.lua gh-5361 replication/rebootstrap.test.lua gh-5524 replication/sync.test.lua gh-3835 sql/prepared.test.lua gh-5359 sql/checks.test.lua gh-5477 sql/gh2808-inline-unique-persistency-check.test.lua gh-5479 swim/swim.test.lua gh-5403 vinyl/deferred_delete.test.lua gh-5089 vinyl/errinj_tx.test.lua gh-5539 vinyl/gh-4810-dump-during-index-build.test.lua gh-5031 vinyl/gh-4957-too-many-upserts.test.lua gh-5378 vinyl/gh-5141-invalid-vylog-file.test.lua gh-5141 vinyl/gc.test.lua gh-5474 vinyl/iterator.test.lua gh-5141 vinyl/replica_rejoin.test.lua gh-4985 vinyl/snapshot.test.lua gh-4984 vinyl/tx_gap_lock.test.lua gh-4309

Added flaky tests results files checksums: app-tap/logger.test.lua gh-5346 app-tap/tarantoolctl.test.lua gh-5059 box/access.test.lua gh-5373 gh-5411 box/alter.test.lua gh-5557 box/before_replace.test.lua gh-5546 box/cfg.test.lua gh-5530 box/ddl_collation_deleted_gh-3290.test.lua gh-5555 box/hash_gh-1467.test.lua gh-5476 box/iterator.test.lua gh-5523 box/net.box_connect_timeout_gh-2054.test.lua gh-5548 box/net.box_count_inconsistent_gh-3262.test.lua gh-5532 box/net.box_field_names_gh-2978.test.lua gh-5554 box/net.box_get_connection_object.test.lua gh-5549 box/net.box_gibberish_gh-3900.test.lua gh-5548 box/net.box_incorrect_iterator_gh-841.test.lua gh-5434 box/net.box_index_unique_flag_gh-4091.test.lua gh-5551 box/net.box_iproto_hangs_gh-3464.test.lua gh-5548 box/net.box_reload_schema_gh-636.test.lua gh-5550 box/net.box_schema_change_gh-2666.test.lua gh-5547 box/schema_reload.test.lua gh-5552 box/select.test.lua gh-5548 box/tree_pk_multipart.test.lua gh-5528 gh-5556 box-tap/gh-4231-box-execute-locking.test.lua gh-5558 box-tap/session.test.lua gh-5346 box-tap/session.storage.test.lua gh-5346 engine/conflict.test.lua gh-5516 engine/tuple.test.lua gh-5480 replication/bootstrap_leader.test.lua gh-5478 replication/gh-3160-misc-heartbeats-on-master-changes.test.> gh-4940 replication/ddl.test.lua gh-5337 replication/election_basic.test.lua gh-5368 replication/election_qsync.test.lua gh-5430 replication/election_qsync_stress.test.lua gh-5395 replication/gh-5287-boot-anon.test.lua gh-5412 replication/gh-5426-election-on-off.test.lua gh-5506 replication/prune.test.lua gh-5361 replication/rebootstrap.test.lua gh-5524 replication/sync.test.lua gh-3835 sql/prepared.test.lua gh-5359 sql/checks.test.lua gh-5477 sql/gh2808-inline-unique-persistency-check.test.lua gh-5479 swim/swim.test.lua gh-5403 vinyl/deferred_delete.test.lua gh-5089 vinyl/errinj_tx.test.lua gh-5539 vinyl/gh-4810-dump-during-index-build.test.lua gh-5031 vinyl/gh-4957-too-many-upserts.test.lua gh-5378 vinyl/gh-5141-invalid-vylog-file.test.lua gh-5141 vinyl/gc.test.lua gh-5474 vinyl/iterator.test.lua gh-5141 vinyl/replica_rejoin.test.lua gh-4985 vinyl/snapshot.test.lua gh-4984 vinyl/tx_gap_lock.test.lua gh-4309 t

Added flaky tests results files checksums: app-tap/logger.test.lua gh-5346 app-tap/tarantoolctl.test.lua gh-5059 box/access.test.lua gh-5373 gh-5411 box/alter.test.lua gh-5557 box/before_replace.test.lua gh-5546 box/cfg.test.lua gh-5530 box/ddl_collation_deleted_gh-3290.test.lua gh-5555 box/hash_gh-1467.test.lua gh-5476 box/iterator.test.lua gh-5523 box/net.box_connect_timeout_gh-2054.test.lua gh-5548 box/net.box_count_inconsistent_gh-3262.test.lua gh-5532 box/net.box_field_names_gh-2978.test.lua gh-5554 box/net.box_get_connection_object.test.lua gh-5549 box/net.box_gibberish_gh-3900.test.lua gh-5548 box/net.box_incorrect_iterator_gh-841.test.lua gh-5434 box/net.box_index_unique_flag_gh-4091.test.lua gh-5551 box/net.box_iproto_hangs_gh-3464.test.lua gh-5548 box/net.box_reload_schema_gh-636.test.lua gh-5550 box/net.box_schema_change_gh-2666.test.lua gh-5547 box/schema_reload.test.lua gh-5552 box/select.test.lua gh-5548 box/tree_pk_multipart.test.lua gh-5528 gh-5556 box-tap/gh-4231-box-execute-locking.test.lua gh-5558 box-tap/session.test.lua gh-5346 box-tap/session.storage.test.lua gh-5346 engine/conflict.test.lua gh-5516 engine/tuple.test.lua gh-5480 replication/bootstrap_leader.test.lua gh-5478 replication/gh-3160-misc-heartbeats-on-master-changes.test.> gh-4940 replication/ddl.test.lua gh-5337 replication/election_basic.test.lua gh-5368 replication/election_qsync.test.lua gh-5430 replication/election_qsync_stress.test.lua gh-5395 replication/gh-5287-boot-anon.test.lua gh-5412 replication/gh-5426-election-on-off.test.lua gh-5506 replication/prune.test.lua gh-5361 replication/rebootstrap.test.lua gh-5524 replication/sync.test.lua gh-3835 sql/prepared.test.lua gh-5359 sql/checks.test.lua gh-5477 sql/gh2808-inline-unique-persistency-check.test.lua gh-5479 swim/swim.test.lua gh-5403 vinyl/deferred_delete.test.lua gh-5089 vinyl/errinj_tx.test.lua gh-5539 vinyl/gh-4810-dump-during-index-build.test.lua gh-5031 vinyl/gh-4957-too-many-upserts.test.lua gh-5378 vinyl/gh-5141-invalid-vylog-file.test.lua gh-5141 vinyl/gc.test.lua gh-5474 vinyl/iterator.test.lua gh-5141 vinyl/replica_rejoin.test.lua gh-4985 vinyl/snapshot.test.lua gh-4984 vinyl/tx_gap_lock.test.lua gh-4309

Added flaky tests results files checksums: app-tap/logger.test.lua gh-5346 app-tap/tarantoolctl.test.lua gh-5059 box/access.test.lua gh-5373 gh-5411 box/alter.test.lua gh-5557 box/before_replace.test.lua gh-5546 box/cfg.test.lua gh-5530 box/ddl_call_twice_gh-2336.test.lua gh-5560 box/ddl_collation_deleted_gh-3290.test.lua gh-5555 box/hash_gh-1467.test.lua gh-5476 gh-5504 box/iterator.test.lua gh-5523 box/leak.test.lua gh-5548 box/net.box_connect_timeout_gh-2054.test.lua gh-5548 box/net.box_count_inconsistent_gh-3262.test.lua gh-5532 box/net.box_field_names_gh-2978.test.lua gh-5554 box/net.box_get_connection_object.test.lua gh-5549 box/net.box_gibberish_gh-3900.test.lua gh-5548 box/net.box_incorrect_iterator_gh-841.test.lua gh-5434 box/net.box_index_unique_flag_gh-4091.test.lua gh-5551 box/net.box_iproto_hangs_gh-3464.test.lua gh-5548 box/net.box_reload_schema_gh-636.test.lua gh-5550 box/net.box_schema_change_gh-2666.test.lua gh-5547 box/on_shutdown.test.lua gh-5562 box/schema_reload.test.lua gh-5552 box/select.test.lua gh-5548 box/tree_pk_multipart.test.lua gh-5528 gh-5556 box-tap/gh-4231-box-execute-locking.test.lua gh-5558 box-tap/session.test.lua gh-5346 box-tap/session.storage.test.lua gh-5346 engine/conflict.test.lua gh-5516 engine/tuple.test.lua gh-5480 replication/bootstrap_leader.test.lua gh-5478 replication/box_set_replication_stress.test.lua gh-4992 replication/gh-3160-misc-heartbeats-on-master-changes.test.> gh-4940 replication/ddl.test.lua gh-5337 replication/election_basic.test.lua gh-5368 replication/election_qsync.test.lua gh-5430 replication/election_qsync_stress.test.lua gh-5395 replication/gh-5287-boot-anon.test.lua gh-5412 replication/gh-5426-election-on-off.test.lua gh-5506 replication/prune.test.lua gh-5361 replication/rebootstrap.test.lua gh-5524 replication/show_error_on_disconnect.test.lua gh-5371 replication/sync.test.lua gh-3835 replication/transaction.test.lua gh-5563 sql/prepared.test.lua gh-5359 sql/checks.test.lua gh-5477 sql/gh2808-inline-unique-persistency-check.test.lua gh-5479 swim/swim.test.lua gh-5403 gh-5561 vinyl/deferred_delete.test.lua gh-5089 vinyl/errinj_tx.test.lua gh-5539 vinyl/gh-4810-dump-during-index-build.test.lua gh-5031 vinyl/gh-4957-too-many-upserts.test.lua gh-5378 vinyl/gh-5141-invalid-vylog-file.test.lua gh-5141 vinyl/gc.test.lua gh-5474 vinyl/iterator.test.lua gh-5141 vinyl/replica_rejoin.test.lua gh-4985 vinyl/snapshot.test.lua gh-4984 vinyl/tx_gap_lock.test.lua gh-4309 xlog/panic_on_broken_lsn.test.lua gh-4991

Added flaky tests results files checksums: app-tap/logger.test.lua gh-5346 app-tap/tarantoolctl.test.lua gh-5059 box/access.test.lua gh-5373 gh-5411 box/alter.test.lua gh-5557 box/before_replace.test.lua gh-5546 box/cfg.test.lua gh-5530 box/ddl_call_twice_gh-2336.test.lua gh-5560 box/ddl_collation_deleted_gh-3290.test.lua gh-5555 box/hash_gh-1467.test.lua gh-5476 gh-5504 box/iterator.test.lua gh-5523 box/leak.test.lua gh-5548 box/net.box_connect_timeout_gh-2054.test.lua gh-5548 box/net.box_count_inconsistent_gh-3262.test.lua gh-5532 box/net.box_field_names_gh-2978.test.lua gh-5554 box/net.box_get_connection_object.test.lua gh-5549 box/net.box_gibberish_gh-3900.test.lua gh-5548 box/net.box_incorrect_iterator_gh-841.test.lua gh-5434 box/net.box_index_unique_flag_gh-4091.test.lua gh-5551 box/net.box_iproto_hangs_gh-3464.test.lua gh-5548 box/net.box_log_corrupted_rows_gh-4040.test.lua gh-5548 box/net.box_reload_schema_gh-636.test.lua gh-5550 box/net.box_schema_change_gh-2666.test.lua gh-5547 box/on_shutdown.test.lua gh-5562 box/schema_reload.test.lua gh-5552 box/select.test.lua gh-5548 box/tree_pk_multipart.test.lua gh-5528 gh-5556 box-tap/gh-4231-box-execute-locking.test.lua gh-5558 box-tap/session.test.lua gh-5346 box-tap/session.storage.test.lua gh-5346 engine/conflict.test.lua gh-5516 engine/tuple.test.lua gh-5480 replication/bootstrap_leader.test.lua gh-5478 replication/box_set_replication_stress.test.lua gh-4992 replication/gh-3160-misc-heartbeats-on-master-changes.test.> gh-4940 replication/ddl.test.lua gh-5337 replication/election_basic.test.lua gh-5368 replication/election_qsync.test.lua gh-5430 replication/election_qsync_stress.test.lua gh-5395 replication/gh-5287-boot-anon.test.lua gh-5412 replication/gh-5426-election-on-off.test.lua gh-5506 replication/prune.test.lua gh-5361 replication/rebootstrap.test.lua gh-5524 replication/show_error_on_disconnect.test.lua gh-5371 replication/sync.test.lua gh-3835 replication/transaction.test.lua gh-5563 sql/prepared.test.lua gh-5359 sql/checks.test.lua gh-5477 sql/gh2808-inline-unique-persistency-check.test.lua gh-5479 swim/swim.test.lua gh-5403 gh-5561 vinyl/deferred_delete.test.lua gh-5089 vinyl/errinj_tx.test.lua gh-5539 vinyl/gh-4810-dump-during-index-build.test.lua gh-5031 vinyl/gh-4957-too-many-upserts.test.lua gh-5378 vinyl/gh-5141-invalid-vylog-file.test.lua gh-5141 vinyl/gc.test.lua gh-5474 vinyl/iterator.test.lua gh-5141 vinyl/replica_rejoin.test.lua gh-4985 vinyl/snapshot.test.lua gh-4984 vinyl/tx_gap_lock.test.lua gh-4309 xlog/panic_on_broken_lsn.test.lua gh-4991

Added flaky tests results files checksums: app-tap/logger.test.lua gh-5346 app-tap/tarantoolctl.test.lua gh-5059 box/access.test.lua gh-5373 gh-5411 box/alter.test.lua gh-5557 box/before_replace.test.lua gh-5546 box/cfg.test.lua gh-5530 box/ddl_call_twice_gh-2336.test.lua gh-5560 box/ddl_collation_deleted_gh-3290.test.lua gh-5555 box/gh-4703-on_shutdown-bug.test.lua gh-5560 box/hash_gh-1467.test.lua gh-5476 gh-5504 box/iterator.test.lua gh-5523 box/leak.test.lua gh-5548 box/net.box_connect_timeout_gh-2054.test.lua gh-5548 box/net.box_count_inconsistent_gh-3262.test.lua gh-5532 box/net.box_field_names_gh-2978.test.lua gh-5554 box/net.box_get_connection_object.test.lua gh-5549 box/net.box_gibberish_gh-3900.test.lua gh-5548 box/net.box_incorrect_iterator_gh-841.test.lua gh-5434 box/net.box_index_unique_flag_gh-4091.test.lua gh-5551 box/net.box_iproto_hangs_gh-3464.test.lua gh-5548 box/net.box_log_corrupted_rows_gh-4040.test.lua gh-5548 box/net.box_reload_schema_gh-636.test.lua gh-5550 box/net.box_schema_change_gh-2666.test.lua gh-5547 box/on_shutdown.test.lua gh-5562 box/schema_reload.test.lua gh-5552 box/select.test.lua gh-5548 box/tree_pk_multipart.test.lua gh-5528 gh-5556 box-tap/gh-4231-box-execute-locking.test.lua gh-5558 box-tap/session.test.lua gh-5346 box-tap/session.storage.test.lua gh-5346 engine/conflict.test.lua gh-5516 engine/tuple.test.lua gh-5480 replication/bootstrap_leader.test.lua gh-5478 replication/box_set_replication_stress.test.lua gh-4992 replication/gh-3160-misc-heartbeats-on-master-changes.test.> gh-4940 replication/ddl.test.lua gh-5337 replication/election_basic.test.lua gh-5368 replication/election_qsync.test.lua gh-5430 replication/election_qsync_stress.test.lua gh-5395 replication/gh-5287-boot-anon.test.lua gh-5412 replication/gh-5426-election-on-off.test.lua gh-5506 replication/prune.test.lua gh-5361 replication/rebootstrap.test.lua gh-5524 replication/show_error_on_disconnect.test.lua gh-5371 replication/sync.test.lua gh-3835 replication/transaction.test.lua gh-5563 sql/prepared.test.lua gh-5359 sql/checks.test.lua gh-5477 sql/gh2808-inline-unique-persistency-check.test.lua gh-5479 swim/swim.test.lua gh-5403 gh-5561 vinyl/deferred_delete.test.lua gh-5089 vinyl/errinj_tx.test.lua gh-5539 vinyl/gh-4810-dump-during-index-build.test.lua gh-5031 vinyl/gh-4957-too-many-upserts.test.lua gh-5378 vinyl/gh-5141-invalid-vylog-file.test.lua gh-5141 vinyl/gc.test.lua gh-5474 vinyl/iterator.test.lua gh-5141 vinyl/replica_rejoin.test.lua gh-4985 vinyl/snapshot.test.lua gh-4984 vinyl/tx_gap_lock.test.lua gh-4309 xlog/panic_on_broken_lsn.test.lua gh-4991

Added flaky tests results files checksums: app-tap/logger.test.lua gh-5346 app-tap/tarantoolctl.test.lua gh-5059 box/access.test.lua gh-5373 gh-5411 box/alter.test.lua gh-5557 box/before_replace.test.lua gh-5546 box/cfg.test.lua gh-5530 box/ddl_call_twice_gh-2336.test.lua gh-5560 box/ddl_collation_deleted_gh-3290.test.lua gh-5555 box/gh-4703-on_shutdown-bug.test.lua gh-5560 box/hash_gh-1467.test.lua gh-5476 gh-5504 box/iterator.test.lua gh-5523 box/leak.test.lua gh-5548 box/net.box_connect_timeout_gh-2054.test.lua gh-5548 box/net.box_count_inconsistent_gh-3262.test.lua gh-5532 box/net.box_field_names_gh-2978.test.lua gh-5554 box/net.box_get_connection_object.test.lua gh-5549 box/net.box_gibberish_gh-3900.test.lua gh-5548 box/net.box_incorrect_iterator_gh-841.test.lua gh-5434 box/net.box_index_unique_flag_gh-4091.test.lua gh-5551 box/net.box_iproto_hangs_gh-3464.test.lua gh-5548 box/net.box_log_corrupted_rows_gh-4040.test.lua gh-5548 box/net.box_reload_schema_gh-636.test.lua gh-5550 box/net.box_schema_change_gh-2666.test.lua gh-5547 box/on_shutdown.test.lua gh-5562 box/schema_reload.test.lua gh-5552 box/select.test.lua gh-5548 box/tree_pk_multipart.test.lua gh-5528 gh-5556 box-tap/gh-4231-box-execute-locking.test.lua gh-5558 box-tap/session.test.lua gh-5346 box-tap/session.storage.test.lua gh-5346 engine/conflict.test.lua gh-5516 engine/tuple.test.lua gh-5480 replication/bootstrap_leader.test.lua gh-5478 replication/box_set_replication_stress.test.lua gh-4992 replication/gh-3160-misc-heartbeats-on-master-changes.test.> gh-4940 replication/ddl.test.lua gh-5337 replication/election_basic.test.lua gh-5368 replication/election_qsync.test.lua gh-5430 replication/election_qsync_stress.test.lua gh-5395 replication/gh-5287-boot-anon.test.lua gh-5412 replication/gh-5426-election-on-off.test.lua gh-5506 replication/prune.test.lua gh-5361 replication/rebootstrap.test.lua gh-5524 replication/show_error_on_disconnect.test.lua gh-5371 replication/sync.test.lua gh-3835 replication/transaction.test.lua gh-5563 sql/prepared.test.lua gh-5359 sql/checks.test.lua gh-5477 sql/gh2808-inline-unique-persistency-check.test.lua gh-5479 swim/swim.test.lua gh-5403 gh-5561 vinyl/deferred_delete.test.lua gh-5089 vinyl/errinj_tx.test.lua gh-5539 vinyl/gh-4810-dump-during-index-build.test.lua gh-5031 vinyl/gh-4957-too-many-upserts.test.lua gh-5378 vinyl/gh-5141-invalid-vylog-file.test.lua gh-5141 vinyl/gc.test.lua gh-5474 vinyl/iterator.test.lua gh-5141 vinyl/replica_rejoin.test.lua gh-4985 vinyl/snapshot.test.lua gh-4984 vinyl/tx_gap_lock.test.lua gh-4309 xlog/panic_on_broken_lsn.test.lua gh-4991 (cherry picked from commit a79ba0f)

Added flaky tests results files checksums: app-tap/logger.test.lua gh-5346 app-tap/tarantoolctl.test.lua gh-5059 box/access.test.lua gh-5373 gh-5411 box/alter.test.lua gh-5557 box/before_replace.test.lua gh-5546 box/cfg.test.lua gh-5530 box/ddl_call_twice_gh-2336.test.lua gh-5560 box/ddl_collation_deleted_gh-3290.test.lua gh-5555 box/gh-4703-on_shutdown-bug.test.lua gh-5560 box/hash_gh-1467.test.lua gh-5476 gh-5504 box/iterator.test.lua gh-5523 box/leak.test.lua gh-5548 box/net.box_connect_timeout_gh-2054.test.lua gh-5548 box/net.box_count_inconsistent_gh-3262.test.lua gh-5532 box/net.box_field_names_gh-2978.test.lua gh-5554 box/net.box_get_connection_object.test.lua gh-5549 box/net.box_gibberish_gh-3900.test.lua gh-5548 box/net.box_incorrect_iterator_gh-841.test.lua gh-5434 box/net.box_index_unique_flag_gh-4091.test.lua gh-5551 box/net.box_iproto_hangs_gh-3464.test.lua gh-5548 box/net.box_log_corrupted_rows_gh-4040.test.lua gh-5548 box/net.box_reload_schema_gh-636.test.lua gh-5550 box/net.box_schema_change_gh-2666.test.lua gh-5547 box/on_shutdown.test.lua gh-5562 box/schema_reload.test.lua gh-5552 box/select.test.lua gh-5548 box/tree_pk_multipart.test.lua gh-5528 gh-5556 box-tap/gh-4231-box-execute-locking.test.lua gh-5558 box-tap/session.test.lua gh-5346 box-tap/session.storage.test.lua gh-5346 engine/conflict.test.lua gh-5516 engine/tuple.test.lua gh-5480 replication/bootstrap_leader.test.lua gh-5478 replication/box_set_replication_stress.test.lua gh-4992 replication/gh-3160-misc-heartbeats-on-master-changes.test.> gh-4940 replication/ddl.test.lua gh-5337 replication/election_basic.test.lua gh-5368 replication/election_qsync.test.lua gh-5430 replication/election_qsync_stress.test.lua gh-5395 replication/gh-5287-boot-anon.test.lua gh-5412 replication/gh-5426-election-on-off.test.lua gh-5506 replication/prune.test.lua gh-5361 replication/rebootstrap.test.lua gh-5524 replication/show_error_on_disconnect.test.lua gh-5371 replication/sync.test.lua gh-3835 replication/transaction.test.lua gh-5563 sql/prepared.test.lua gh-5359 sql/checks.test.lua gh-5477 sql/gh2808-inline-unique-persistency-check.test.lua gh-5479 swim/swim.test.lua gh-5403 gh-5561 vinyl/deferred_delete.test.lua gh-5089 vinyl/errinj_tx.test.lua gh-5539 vinyl/gh-4810-dump-during-index-build.test.lua gh-5031 vinyl/gh-4957-too-many-upserts.test.lua gh-5378 vinyl/gh-5141-invalid-vylog-file.test.lua gh-5141 vinyl/gc.test.lua gh-5474 vinyl/iterator.test.lua gh-5141 vinyl/replica_rejoin.test.lua gh-4985 vinyl/snapshot.test.lua gh-4984 vinyl/tx_gap_lock.test.lua gh-4309 xlog/panic_on_broken_lsn.test.lua gh-4991

Added flaky tests results files checksums: app-tap/logger.test.lua gh-5346 app-tap/tarantoolctl.test.lua gh-5059 box/access.test.lua gh-5373 gh-5411 box/alter.test.lua gh-5557 box/before_replace.test.lua gh-5546 box/cfg.test.lua gh-5530 box/ddl_call_twice_gh-2336.test.lua gh-5560 box/ddl_collation_deleted_gh-3290.test.lua gh-5555 box/gh-4703-on_shutdown-bug.test.lua gh-5560 box/hash_gh-1467.test.lua gh-5476 gh-5504 box/iterator.test.lua gh-5523 box/leak.test.lua gh-5548 box/net.box_connect_timeout_gh-2054.test.lua gh-5548 box/net.box_count_inconsistent_gh-3262.test.lua gh-5532 box/net.box_field_names_gh-2978.test.lua gh-5554 box/net.box_get_connection_object.test.lua gh-5549 box/net.box_gibberish_gh-3900.test.lua gh-5548 box/net.box_incorrect_iterator_gh-841.test.lua gh-5434 box/net.box_index_unique_flag_gh-4091.test.lua gh-5551 box/net.box_iproto_hangs_gh-3464.test.lua gh-5548 box/net.box_log_corrupted_rows_gh-4040.test.lua gh-5548 box/net.box_reload_schema_gh-636.test.lua gh-5550 box/net.box_schema_change_gh-2666.test.lua gh-5547 box/on_shutdown.test.lua gh-5562 box/schema_reload.test.lua gh-5552 box/select.test.lua gh-5548 box/tree_pk_multipart.test.lua gh-5528 gh-5556 box-tap/gh-4231-box-execute-locking.test.lua gh-5558 box-tap/session.test.lua gh-5346 box-tap/session.storage.test.lua gh-5346 engine/conflict.test.lua gh-5516 engine/tuple.test.lua gh-5480 replication/bootstrap_leader.test.lua gh-5478 replication/box_set_replication_stress.test.lua gh-4992 replication/gh-3160-misc-heartbeats-on-master-changes.test.> gh-4940 replication/ddl.test.lua gh-5337 replication/election_basic.test.lua gh-5368 replication/election_qsync.test.lua gh-5430 replication/election_qsync_stress.test.lua gh-5395 replication/gh-5287-boot-anon.test.lua gh-5412 replication/gh-5426-election-on-off.test.lua gh-5506 replication/prune.test.lua gh-5361 replication/rebootstrap.test.lua gh-5524 replication/show_error_on_disconnect.test.lua gh-5371 replication/sync.test.lua gh-3835 replication/transaction.test.lua gh-5563 sql/prepared.test.lua gh-5359 sql/checks.test.lua gh-5477 sql/gh2808-inline-unique-persistency-check.test.lua gh-5479 swim/swim.test.lua gh-5403 gh-5561 vinyl/deferred_delete.test.lua gh-5089 vinyl/errinj_tx.test.lua gh-5539 vinyl/gh-4810-dump-during-index-build.test.lua gh-5031 vinyl/gh-4957-too-many-upserts.test.lua gh-5378 vinyl/gh-5141-invalid-vylog-file.test.lua gh-5141 vinyl/gc.test.lua gh-5474 vinyl/iterator.test.lua gh-5141 vinyl/replica_rejoin.test.lua gh-4985 vinyl/snapshot.test.lua gh-4984 vinyl/tx_gap_lock.test.lua gh-4309 xlog/panic_on_broken_lsn.test.lua gh-4991 (cherry picked from commit a79ba0f)

Totktonada · 2021-11-26T09:49:03Z

My attempt to reproduce on 2.10.0-beta1-281-ge8765ba5c (Linux/amd64):

Build:

$ cmake . -DCMAKE_BUILD_TYPE=Debug -DENABLE_BACKTRACE=ON -DENABLE_DIST=ON -DENABLE_FEEDBACK_DAEMON=OFF -DENABLE_BUNDLED_LIBCURL=OFF -DENABLE_FEEDBACK_DAEMON=OFF && make -j

Enable in parallel:

diff --git a/test/sql/suite.ini b/test/sql/suite.ini
index 6c24a7ea4..e3e3f4cb6 100644
--- a/test/sql/suite.ini
+++ b/test/sql/suite.ini
@@ -15,10 +15,6 @@ fragile = {
         "func-recreate.test.lua": {
             "issues": [ "gh-4384" ]
         },
-        "prepared.test.lua": {
-            "issues": [ "gh-5359" ],
-            "checksums": [ "417a95fc995bbfbf7115bbde5c42028e", "16472636b3dcd186007b89f76912fa12", "7a76ead31624e6e017f1e7b816c00cfe" ]
-        },
         "checks.test.lua": {
             "issues": [ "gh-5477" ],
             "checksums": [ "0d7ddbb3d34c38745104fbbaf03f8e1f" ]

Run:

$ ./test/test-run.py $(yes sql/prepared.test.lua | head -n 500)

Result (first miscompare):

sql/prepared.test.lua                           local           [ fail ]

Test failed! Result content mismatch:
--- sql/prepared.result	Fri Sep 17 01:54:04 2021
+++ var/rejects/sql/prepared.reject	Fri Nov 26 12:42:53 2021
@@ -416,7 +416,7 @@
  | ...
 unprepare(s.stmt_id)
  | ---
- | - null
+ | - error: Prepared statement with id 119053220 does not exist
  | ...
 
 s = prepare("SELECT count(*), count(id - 3), max(b), abs(id) FROM test WHERE b = '3';")

Result (full)

sql/prepared.test.lua                           local           [ fail ]

Test failed! Result content mismatch:
--- sql/prepared.result	Fri Sep 17 01:54:04 2021
+++ var/rejects/sql/prepared.reject	Fri Nov 26 12:42:53 2021
@@ -416,7 +416,7 @@
  | ...
 unprepare(s.stmt_id)
  | ---
- | - null
+ | - error: Prepared statement with id 119053220 does not exist
  | ...
 
 s = prepare("SELECT count(*), count(id - 3), max(b), abs(id) FROM test WHERE b = '3';")
@@ -692,28 +692,40 @@
 --
 box.cfg{sql_cache_size = 0 }
  | ---
+ | - error: 'Failed to prepare SQL statement: Can''t reduce memory limit for SQL prepared
+ |     statements: please, deallocate active statements'
  | ...
 assert(box.info.sql().cache.stmt_count == 0)
  | ---
- | - true
+ | - error: assertion failed!
  | ...
 assert(box.info.sql().cache.size == 0)
  | ---
- | - true
+ | - error: assertion failed!
  | ...
 prepare("SELECT a FROM test;")
  | ---
- | - error: 'Failed to prepare SQL statement: Memory limit for SQL prepared statements
- |     has been reached. Please, deallocate active statements or increase SQL cache size.'
+ | - stmt_id: 482388757
+ |   execute: 'function: 0x40414d70'
+ |   params: []
+ |   unprepare: 'function: 0x40414d98'
+ |   metadata:
+ |   - name: A
+ |     type: number
+ |   param_count: 0
  | ...
 box.cfg{sql_cache_size = 0}
  | ---
+ | - error: 'Failed to prepare SQL statement: Can''t reduce memory limit for SQL prepared
+ |     statements: please, deallocate active statements'
  | ...
 
 -- Still with small size everything should work.
 --
 box.cfg{sql_cache_size = 1500}
  | ---
+ | - error: 'Failed to prepare SQL statement: Can''t reduce memory limit for SQL prepared
+ |     statements: please, deallocate active statements'
  | ...
 
 test_run:cmd("setopt delimiter ';'");
@@ -735,12 +747,22 @@
  | ...
 assert(ok == false);
  | ---
- | - true
+ | - error: assertion failed!
  | ...
 res;
  | ---
- | - 'Failed to prepare SQL statement: Memory limit for SQL prepared statements has been
- |   reached. Please, deallocate active statements or increase SQL cache size.'
+ | - stmt_id: 3383028125
+ |   execute: 'function: 0x4041b320'
+ |   params: []
+ |   unprepare: 'function: 0x4041b348'
+ |   metadata:
+ |   - name: ID
+ |     type: integer
+ |   - name: A
+ |     type: number
+ |   - name: B
+ |     type: string
+ |   param_count: 0
  | ...
 
 -- Check that after fiber is dead, its session gets rid of
@@ -754,6 +776,8 @@
  | ...
 box.cfg{sql_cache_size = 0};
  | ---
+ | - error: 'Failed to prepare SQL statement: Can''t reduce memory limit for SQL prepared
+ |     statements: please, deallocate active statements'
  | ...
 box.cfg{sql_cache_size = 3000};
  | ---
@@ -771,6 +795,8 @@
 
 s = prepare("SELECT id, SLEEP() FROM test;");
  | ---
+ | - error: 'Failed to prepare SQL statement: Memory limit for SQL prepared statements
+ |     has been reached. Please, deallocate active statements or increase SQL cache size.'
  | ...
 assert(s ~= nil);
  | ---
@@ -794,12 +820,14 @@
  | ...
 f2:join();
  | ---
- | - true
+ | - false
+ | - 'Failed to prepare SQL statement: Memory limit for SQL prepared statements has been
+ |   reached. Please, deallocate active statements or increase SQL cache size.'
  | ...
 
 unprepare(s.stmt_id);
  | ---
- | - null
+ | - error: Prepared statement with id 1495950315 does not exist
  | ...
 
 -- Now during execution of one prepared statement, in another
@@ -825,7 +853,9 @@
  | ...
 f2:join();
  | ---
- | - true
+ | - false
+ | - 'Failed to prepare SQL statement: Memory limit for SQL prepared statements has been
+ |   reached. Please, deallocate active statements or increase SQL cache size.'
  | ...
 
 -- tarantool/tarantool#4825: make sure that values to be bound are erased after
@@ -834,46 +864,24 @@
 --
 s = prepare('SELECT :a, :b, :c');
  | ---
+ | - error: 'Failed to prepare SQL statement: Memory limit for SQL prepared statements
+ |     has been reached. Please, deallocate active statements or increase SQL cache size.'
  | ...
 execute(s.stmt_id, {{[':a'] = 1}, {[':b'] = 2}, {[':c'] = 3}});
  | ---
- | - metadata:
- |   - name: COLUMN_1
- |     type: integer
- |   - name: COLUMN_2
- |     type: integer
- |   - name: COLUMN_3
- |     type: integer
- |   rows:
- |   - [1, 2, 3]
+ | - error: Prepared statement with id 1495950315 does not exist
  | ...
 execute(s.stmt_id, {{[':a'] = 1}, {[':b'] = 2}});
  | ---
- | - metadata:
- |   - name: COLUMN_1
- |     type: integer
- |   - name: COLUMN_2
- |     type: integer
- |   - name: COLUMN_3
- |     type: boolean
- |   rows:
- |   - [1, 2, null]
+ | - error: Prepared statement with id 1495950315 does not exist
  | ...
 execute(s.stmt_id);
  | ---
- | - metadata:
- |   - name: COLUMN_1
- |     type: boolean
- |   - name: COLUMN_2
- |     type: boolean
- |   - name: COLUMN_3
- |     type: boolean
- |   rows:
- |   - [null, null, null]
+ | - error: Prepared statement with id 1495950315 does not exist
  | ...
 unprepare(s.stmt_id);
  | ---
- | - null
+ | - error: Prepared statement with id 1495950315 does not exist
  | ...
 
 if is_remote then

avtikhon added qa flaky test labels Sep 28, 2020

avtikhon self-assigned this Sep 28, 2020

ImeevMA self-assigned this Nov 26, 2021

ImeevMA added the teamL label Nov 26, 2021

kyukhin unassigned avtikhon Nov 29, 2021

NickVolynkin mentioned this issue Mar 15, 2022

List of flaky test issues in Tarantool #153

Open

ylobankov transferred this issue from tarantool/tarantool Apr 15, 2022

igormunkin added sql SQL-related issue and removed teamL labels Sep 15, 2022

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

test: flaky sql/prepared.test.lua test #177

test: flaky sql/prepared.test.lua test #177

avtikhon commented Sep 28, 2020

Totktonada commented Nov 26, 2021

test: flaky sql/prepared.test.lua test #177

test: flaky sql/prepared.test.lua test #177

Comments

avtikhon commented Sep 28, 2020

results file checksum: 417a95fc995bbfbf7115bbde5c42028e

results file checksum: 16472636b3dcd186007b89f76912fa12

Totktonada commented Nov 26, 2021