2 @message |
assert
QUERY_TYPE = DSQL, TIL = SERIALIZABLE, ACCESS = READ, WAIT = NO_WAIT:
lock conflict on no wait transaction
- -Acquire lock for relation (TEST) failed
+ -Acquire lock for relation ("PUBLIC"."TEST") failed
-901
335544345
335544382
QUERY_TYPE = DSQL, TIL = SNAPSHOT, ACCESS = READ, WAIT = NO_WAIT:
attempted update during read-only transaction
-817
335544361
QUERY_TYPE = DSQL, TIL = SNAPSHOT, ACCESS = READ, WAIT = WAIT:
attempted update during read-only transaction
-817
335544361
QUERY_TYPE = DSQL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = NO_WAIT:
attempted update during read-only transaction
-817
335544361
QUERY_TYPE = DSQL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = WAIT:
attempted update during read-only transaction
-817
335544361
QUERY_TYPE = DSQL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
attempted update during read-only transaction
-817
335544361
QUERY_TYPE = DSQL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
attempted update during read-only transaction
-817
335544361
QUERY_TYPE = DSQL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
attempted update during read-only transaction
-817
335544361
QUERY_TYPE = DSQL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
attempted update during read-only transaction
-817
335544361
QUERY_TYPE = DSQL, TIL = SERIALIZABLE, ACCESS = WRITE, WAIT = NO_WAIT:
lock conflict on no wait transaction
- -Acquire lock for relation (TEST) failed
+ -Acquire lock for relation ("PUBLIC"."TEST") failed
-901
335544345
335544382
QUERY_TYPE = DSQL, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = NO_WAIT:
ID=2
ID=3
ID=4
ID=6
ID=7
ID=8
ID=10
QUERY_TYPE = DSQL, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = WAIT:
ID=2
ID=3
ID=4
ID=6
ID=7
ID=8
ID=10
QUERY_TYPE = DSQL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = NO_WAIT:
ID=2
ID=3
ID=4
ID=6
ID=7
ID=8
ID=10
QUERY_TYPE = DSQL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = WAIT:
ID=2
ID=3
ID=4
ID=6
ID=7
ID=8
ID=10
QUERY_TYPE = DSQL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
ID=2
ID=3
ID=4
ID=6
ID=7
ID=8
ID=10
QUERY_TYPE = DSQL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
ID=2
ID=3
ID=4
ID=6
ID=7
ID=8
ID=10
QUERY_TYPE = DSQL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
ID=2
ID=3
ID=4
ID=6
ID=7
ID=8
ID=10
QUERY_TYPE = DSQL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
ID=2
ID=3
ID=4
ID=6
ID=7
ID=8
ID=10
QUERY_TYPE = PSQL_LOCAL, TIL = SERIALIZABLE, ACCESS = READ, WAIT = NO_WAIT:
lock conflict on no wait transaction
- -Acquire lock for relation (TEST) failed
+ -Acquire lock for relation ("PUBLIC"."TEST") failed
- -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
+ -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
-901
335544345
335544382
335544842
QUERY_TYPE = PSQL_LOCAL, TIL = SNAPSHOT, ACCESS = READ, WAIT = NO_WAIT:
attempted update during read-only transaction
- -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
+ -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
-817
335544361
335544842
QUERY_TYPE = PSQL_LOCAL, TIL = SNAPSHOT, ACCESS = READ, WAIT = WAIT:
attempted update during read-only transaction
- -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
+ -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
-817
335544361
335544842
QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = NO_WAIT:
attempted update during read-only transaction
- -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
+ -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
-817
335544361
335544842
QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = WAIT:
attempted update during read-only transaction
- -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
+ -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
-817
335544361
335544842
QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
attempted update during read-only transaction
- -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
+ -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
-817
335544361
335544842
QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
attempted update during read-only transaction
- -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
+ -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
-817
335544361
335544842
QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
attempted update during read-only transaction
- -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
+ -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
-817
335544361
335544842
QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
attempted update during read-only transaction
- -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
+ -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
-817
335544361
335544842
QUERY_TYPE = PSQL_LOCAL, TIL = SERIALIZABLE, ACCESS = WRITE, WAIT = NO_WAIT:
lock conflict on no wait transaction
- -Acquire lock for relation (TEST) failed
+ -Acquire lock for relation ("PUBLIC"."TEST") failed
- -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
+ -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
-901
335544345
335544382
335544842
QUERY_TYPE = PSQL_LOCAL, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = NO_WAIT:
ID=2
ID=3
ID=4
ID=6
ID=7
ID=8
ID=10
QUERY_TYPE = PSQL_LOCAL, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = WAIT:
ID=2
ID=3
ID=4
ID=6
ID=7
ID=8
ID=10
QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = NO_WAIT:
ID=2
ID=3
ID=4
ID=6
ID=7
ID=8
ID=10
QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = WAIT:
ID=2
ID=3
ID=4
ID=6
ID=7
ID=8
ID=10
QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
ID=2
ID=3
ID=4
ID=6
ID=7
ID=8
ID=10
QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
ID=2
ID=3
ID=4
ID=6
ID=7
ID=8
ID=10
QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
ID=2
ID=3
ID=4
ID=6
ID=7
ID=8
ID=10
QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
ID=2
ID=3
ID=4
ID=6
ID=7
ID=8
ID=10
QUERY_TYPE = PSQL_REMOTE, TIL = SERIALIZABLE, ACCESS = READ, WAIT = NO_WAIT:
Execute statement error at isc_dsql_fetch :
335544345 : lock conflict on no wait transaction
- 335544382 : Acquire lock for relation (TEST) failed
+ 335544382 : Acquire lock for relation ("PUBLIC"."TEST") failed
Statement : select id from test order by id with lock skip locked
Data source : Firebird::localhost:
- -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
+ -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
-901
335544926
335544842
QUERY_TYPE = PSQL_REMOTE, TIL = SNAPSHOT, ACCESS = READ, WAIT = NO_WAIT:
Execute statement error at isc_dsql_fetch :
335544361 : attempted update during read-only transaction
Statement : select id from test order by id with lock skip locked
Data source : Firebird::localhost:
- -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
+ -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
-901
335544926
335544842
QUERY_TYPE = PSQL_REMOTE, TIL = SNAPSHOT, ACCESS = READ, WAIT = WAIT:
Execute statement error at isc_dsql_fetch :
335544361 : attempted update during read-only transaction
Statement : select id from test order by id with lock skip locked
Data source : Firebird::localhost:
- -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
+ -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
-901
335544926
335544842
QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = NO_WAIT:
Execute statement error at isc_dsql_fetch :
335544361 : attempted update during read-only transaction
Statement : select id from test order by id with lock skip locked
Data source : Firebird::localhost:
- -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
+ -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
-901
335544926
335544842
QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = WAIT:
Execute statement error at isc_dsql_fetch :
335544361 : attempted update during read-only transaction
Statement : select id from test order by id with lock skip locked
Data source : Firebird::localhost:
- -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
+ -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
-901
335544926
335544842
QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
Execute statement error at isc_dsql_fetch :
335544361 : attempted update during read-only transaction
Statement : select id from test order by id with lock skip locked
Data source : Firebird::localhost:
- -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
+ -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
-901
335544926
335544842
QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
Execute statement error at isc_dsql_fetch :
335544361 : attempted update during read-only transaction
Statement : select id from test order by id with lock skip locked
Data source : Firebird::localhost:
- -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
+ -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
-901
335544926
335544842
QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
Execute statement error at isc_dsql_fetch :
335544361 : attempted update during read-only transaction
Statement : select id from test order by id with lock skip locked
Data source : Firebird::localhost:
- -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
+ -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
-901
335544926
335544842
QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
Execute statement error at isc_dsql_fetch :
335544361 : attempted update during read-only transaction
Statement : select id from test order by id with lock skip locked
Data source : Firebird::localhost:
- -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
+ -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
-901
335544926
335544842
QUERY_TYPE = PSQL_REMOTE, TIL = SERIALIZABLE, ACCESS = WRITE, WAIT = NO_WAIT:
Execute statement error at isc_dsql_fetch :
335544345 : lock conflict on no wait transaction
- 335544382 : Acquire lock for relation (TEST) failed
+ 335544382 : Acquire lock for relation ("PUBLIC"."TEST") failed
Statement : select id from test order by id with lock skip locked
Data source : Firebird::localhost:
- -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
+ -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
-901
335544926
335544842
QUERY_TYPE = PSQL_REMOTE, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = NO_WAIT:
ID=2
ID=3
ID=4
ID=6
ID=7
ID=8
ID=10
QUERY_TYPE = PSQL_REMOTE, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = WAIT:
ID=2
ID=3
ID=4
ID=6
ID=7
ID=8
ID=10
QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = NO_WAIT:
ID=2
ID=3
ID=4
ID=6
ID=7
ID=8
ID=10
QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = WAIT:
ID=2
ID=3
ID=4
ID=6
ID=7
ID=8
ID=10
QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
ID=2
ID=3
ID=4
ID=6
ID=7
ID=8
ID=10
QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
ID=2
ID=3
ID=4
ID=6
ID=7
ID=8
ID=10
QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
ID=2
ID=3
ID=4
ID=6
ID=7
ID=8
ID=10
QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
ID=2
ID=3
ID=4
ID=6
ID=7
ID=8
ID=10
LOG DETAILS:
2025-06-30 05:40:18.260
2025-06-30 05:40:18.269 act = <firebird.qa.plugin.Action object at [hex]>
2025-06-30 05:40:18.277 capsys = <_pytest.capture.CaptureFixture object at [hex]>
2025-06-30 05:40:18.284
2025-06-30 05:40:18.292 @pytest.mark.es_eds
2025-06-30 05:40:18.300 @pytest.mark.version('>=5.0')
2025-06-30 05:40:18.308 def test_1(act: Action, capsys):
2025-06-30 05:40:18.316
2025-06-30 05:40:18.324 init_sql = f"""
2025-06-30 05:40:18.332 set term ^;
2025-06-30 05:40:18.339 recreate table test(id int primary key, f01 int)
2025-06-30 05:40:18.348 -- recreate global temporary table test(id int primary key, f01 int) on commit preserve rows
2025-06-30 05:40:18.355 ^
2025-06-30 05:40:18.363 create or alter procedure sp_get_unlocked_rows_local returns(id int) as
2025-06-30 05:40:18.371 begin
2025-06-30 05:40:18.383 for
2025-06-30 05:40:18.391 {CHECK_SQL}
2025-06-30 05:40:18.398 into id
2025-06-30 05:40:18.405 do
2025-06-30 05:40:18.412 suspend;
2025-06-30 05:40:18.417 end
2025-06-30 05:40:18.422 ^
2025-06-30 05:40:18.428 create or alter procedure sp_get_unlocked_rows_remote returns(id int) as
2025-06-30 05:40:18.433 begin
2025-06-30 05:40:18.438 for
2025-06-30 05:40:18.444 execute statement '{CHECK_SQL}'
2025-06-30 05:40:18.451 on external 'localhost:' || rdb$get_context('SYSTEM', 'DB_NAME')
2025-06-30 05:40:18.458 as user '{act.db.user}' password '{act.db.password}'
2025-06-30 05:40:18.464 into id
2025-06-30 05:40:18.472 do
2025-06-30 05:40:18.479 suspend;
2025-06-30 05:40:18.487 end
2025-06-30 05:40:18.495 ^
2025-06-30 05:40:18.502 set term ;^
2025-06-30 05:40:18.510 commit;
2025-06-30 05:40:18.517
2025-06-30 05:40:18.525 insert into test(id, f01) select row_number()over(), 0 from rdb$types rows 10;
2025-06-30 05:40:18.533 commit;
2025-06-30 05:40:18.540 """
2025-06-30 05:40:18.546 act.isql(switches=['-q'], input = init_sql, combine_output = True)
2025-06-30 05:40:18.551 assert act.clean_stdout == ''
2025-06-30 05:40:18.557 act.reset()
2025-06-30 05:40:18.564
2025-06-30 05:40:18.572 tpb_isol_set = (Isolation.SERIALIZABLE, Isolation.SNAPSHOT, Isolation.READ_COMMITTED_READ_CONSISTENCY, Isolation.READ_COMMITTED_RECORD_VERSION, Isolation.READ_COMMITTED_NO_RECORD_VERSION)
2025-06-30 05:40:18.581 tpb_wait_set = (TraLockResolution.NO_WAIT,TraLockResolution.WAIT)
2025-06-30 05:40:18.589 tpb_mode_set = (TraAccessMode.READ, TraAccessMode.WRITE)
2025-06-30 05:40:18.597 query_types_set = ('DSQL', 'PSQL_LOCAL', 'PSQL_REMOTE')
2025-06-30 05:40:18.604
2025-06-30 05:40:18.613 with act.db.connect() as con_rows_locker, act.db.connect() as con_free_seeker:
2025-06-30 05:40:18.624 con_rows_locker.execute_immediate('update test set f01 = 1 where id in (1,5,9)')
2025-06-30 05:40:18.634 for query_type in query_types_set:
2025-06-30 05:40:18.644 for x_mode in tpb_mode_set:
2025-06-30 05:40:18.652 for x_isol in tpb_isol_set:
2025-06-30 05:40:18.658 for x_wait in tpb_wait_set:
2025-06-30 05:40:18.663 skip_flag = x_isol in (Isolation.SERIALIZABLE,) and x_wait == TraLockResolution.WAIT
2025-06-30 05:40:18.669 if skip_flag:
2025-06-30 05:40:18.674
2025-06-30 05:40:18.679 #######################################
2025-06-30 05:40:18.685 ### D O N O T C H E C K ###
2025-06-30 05:40:18.698 #######################################
2025-06-30 05:40:18.708 #
2025-06-30 05:40:18.717 # 1. Isolation.SERIALIZABLE requires that the whole table must not be changed by anyone else.
2025-06-30 05:40:18.725 # 2. [WAS ACTUAL BEFORE GH-7810 FIXED; CURRENTLY REMAINS NEEDED FB 5.X]
2025-06-30 05:40:18.734 # Isolation.READ_COMMITTED_NO_RECORD_VERSION can not be used due to implementation details, see:
2025-06-30 05:40:18.741 # Adriano, 26-feb-2023, https://github.com/FirebirdSQL/firebird/pull/7350#issuecomment-1445408462
2025-06-30 05:40:18.749 # "WITH LOCK [SKIP LOCKED] needs a record read before, but this locked records cannot be read with NO RECORD VERSION.
2025-06-30 05:40:18.758 # Considering that this transaction mode is replaced by default I would only document it as in fact I don't think
2025-06-30 05:40:18.768 # there are anything we could do."
2025-06-30 05:40:18.779
2025-06-30 05:40:18.788 continue
2025-06-30 05:40:18.795
2025-06-30 05:40:18.801 custom_tpb = tpb(isolation = x_isol, access_mode = x_mode, lock_timeout = -1 if x_wait == TraLockResolution.WAIT else 0)
2025-06-30 05:40:18.806 #custom_tpb = TPB(isolation = x_isol, access_mode = x_mode, lock_timeout = 0).get_buffer()
2025-06-30 05:40:18.813 tx_free_seeker = con_free_seeker.transaction_manager(custom_tpb)
2025-06-30 05:40:18.819 cur_free_seeker = tx_free_seeker.cursor()
2025-06-30 05:40:18.828 tx_free_seeker.begin()
2025-06-30 05:40:18.836 try:
2025-06-30 05:40:18.843 print('\n')
2025-06-30 05:40:18.855 print(f'QUERY_TYPE = {query_type}, TIL = {x_isol.name}, ACCESS = {x_mode.name}, WAIT = {x_wait.name}:')
2025-06-30 05:40:18.868 if query_type == 'DSQL':
2025-06-30 05:40:18.883 cur_free_seeker.execute(f'{CHECK_SQL}')
2025-06-30 05:40:18.896 elif query_type == 'PSQL_LOCAL':
2025-06-30 05:40:18.905 cur_free_seeker.execute('select id from sp_get_unlocked_rows_local')
2025-06-30 05:40:18.912 elif query_type == 'PSQL_REMOTE':
2025-06-30 05:40:18.919 cur_free_seeker.execute('select id from sp_get_unlocked_rows_remote')
2025-06-30 05:40:18.925 for r in cur_free_seeker:
2025-06-30 05:40:18.930 print('ID='+str(r[0]))
2025-06-30 05:40:18.939 except DatabaseError as e:
2025-06-30 05:40:18.947 print(e.__str__())
2025-06-30 05:40:18.955 print(e.sqlcode)
2025-06-30 05:40:18.963 for g in e.gds_codes:
2025-06-30 05:40:18.976 print(g)
2025-06-30 05:40:18.986 finally:
2025-06-30 05:40:18.993 tx_free_seeker.rollback()
2025-06-30 05:40:18.999
2025-06-30 05:40:19.005 act.expected_stdout = expected_stdout
2025-06-30 05:40:19.010 act.stdout = capsys.readouterr().out
2025-06-30 05:40:19.022 > assert act.clean_stdout == act.clean_expected_stdout
2025-06-30 05:40:19.032 E assert
2025-06-30 05:40:19.039 E QUERY_TYPE = DSQL, TIL = SERIALIZABLE, ACCESS = READ, WAIT = NO_WAIT:
2025-06-30 05:40:19.046 E lock conflict on no wait transaction
2025-06-30 05:40:19.053 E - -Acquire lock for relation (TEST) failed
2025-06-30 05:40:19.061 E + -Acquire lock for relation ("PUBLIC"."TEST") failed
2025-06-30 05:40:19.077 E -901
2025-06-30 05:40:19.088 E 335544345
2025-06-30 05:40:19.101 E 335544382
2025-06-30 05:40:19.109 E QUERY_TYPE = DSQL, TIL = SNAPSHOT, ACCESS = READ, WAIT = NO_WAIT:
2025-06-30 05:40:19.117 E attempted update during read-only transaction
2025-06-30 05:40:19.125 E -817
2025-06-30 05:40:19.132 E 335544361
2025-06-30 05:40:19.141 E QUERY_TYPE = DSQL, TIL = SNAPSHOT, ACCESS = READ, WAIT = WAIT:
2025-06-30 05:40:19.149 E attempted update during read-only transaction
2025-06-30 05:40:19.162 E -817
2025-06-30 05:40:19.171 E 335544361
2025-06-30 05:40:19.178 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = NO_WAIT:
2025-06-30 05:40:19.184 E attempted update during read-only transaction
2025-06-30 05:40:19.190 E -817
2025-06-30 05:40:19.197 E 335544361
2025-06-30 05:40:19.203 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = WAIT:
2025-06-30 05:40:19.210 E attempted update during read-only transaction
2025-06-30 05:40:19.216 E -817
2025-06-30 05:40:19.225 E 335544361
2025-06-30 05:40:19.234 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
2025-06-30 05:40:19.242 E attempted update during read-only transaction
2025-06-30 05:40:19.249 E -817
2025-06-30 05:40:19.258 E 335544361
2025-06-30 05:40:19.270 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
2025-06-30 05:40:19.279 E attempted update during read-only transaction
2025-06-30 05:40:19.286 E -817
2025-06-30 05:40:19.292 E 335544361
2025-06-30 05:40:19.299 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
2025-06-30 05:40:19.307 E attempted update during read-only transaction
2025-06-30 05:40:19.315 E -817
2025-06-30 05:40:19.322 E 335544361
2025-06-30 05:40:19.331 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
2025-06-30 05:40:19.339 E attempted update during read-only transaction
2025-06-30 05:40:19.344 E -817
2025-06-30 05:40:19.349 E 335544361
2025-06-30 05:40:19.354 E QUERY_TYPE = DSQL, TIL = SERIALIZABLE, ACCESS = WRITE, WAIT = NO_WAIT:
2025-06-30 05:40:19.361 E lock conflict on no wait transaction
2025-06-30 05:40:19.369 E - -Acquire lock for relation (TEST) failed
2025-06-30 05:40:19.377 E + -Acquire lock for relation ("PUBLIC"."TEST") failed
2025-06-30 05:40:19.390 E -901
2025-06-30 05:40:19.398 E 335544345
2025-06-30 05:40:19.410 E 335544382
2025-06-30 05:40:19.424 E QUERY_TYPE = DSQL, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = NO_WAIT:
2025-06-30 05:40:19.433 E ID=2
2025-06-30 05:40:19.442 E ID=3
2025-06-30 05:40:19.448 E ID=4
2025-06-30 05:40:19.453 E ID=6
2025-06-30 05:40:19.458 E ID=7
2025-06-30 05:40:19.464 E ID=8
2025-06-30 05:40:19.469 E ID=10
2025-06-30 05:40:19.474 E QUERY_TYPE = DSQL, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = WAIT:
2025-06-30 05:40:19.480 E ID=2
2025-06-30 05:40:19.485 E ID=3
2025-06-30 05:40:19.490 E ID=4
2025-06-30 05:40:19.503 E ID=6
2025-06-30 05:40:19.512 E ID=7
2025-06-30 05:40:19.521 E ID=8
2025-06-30 05:40:19.527 E ID=10
2025-06-30 05:40:19.533 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = NO_WAIT:
2025-06-30 05:40:19.538 E ID=2
2025-06-30 05:40:19.543 E ID=3
2025-06-30 05:40:19.549 E ID=4
2025-06-30 05:40:19.558 E ID=6
2025-06-30 05:40:19.564 E ID=7
2025-06-30 05:40:19.569 E ID=8
2025-06-30 05:40:19.574 E ID=10
2025-06-30 05:40:19.580 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = WAIT:
2025-06-30 05:40:19.586 E ID=2
2025-06-30 05:40:19.592 E ID=3
2025-06-30 05:40:19.599 E ID=4
2025-06-30 05:40:19.606 E ID=6
2025-06-30 05:40:19.614 E ID=7
2025-06-30 05:40:19.622 E ID=8
2025-06-30 05:40:19.629 E ID=10
2025-06-30 05:40:19.636 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
2025-06-30 05:40:19.647 E ID=2
2025-06-30 05:40:19.655 E ID=3
2025-06-30 05:40:19.663 E ID=4
2025-06-30 05:40:19.671 E ID=6
2025-06-30 05:40:19.679 E ID=7
2025-06-30 05:40:19.687 E ID=8
2025-06-30 05:40:19.695 E ID=10
2025-06-30 05:40:19.705 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
2025-06-30 05:40:19.717 E ID=2
2025-06-30 05:40:19.731 E ID=3
2025-06-30 05:40:19.740 E ID=4
2025-06-30 05:40:19.748 E ID=6
2025-06-30 05:40:19.756 E ID=7
2025-06-30 05:40:19.764 E ID=8
2025-06-30 05:40:19.770 E ID=10
2025-06-30 05:40:19.776 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
2025-06-30 05:40:19.782 E ID=2
2025-06-30 05:40:19.789 E ID=3
2025-06-30 05:40:19.797 E ID=4
2025-06-30 05:40:19.804 E ID=6
2025-06-30 05:40:19.809 E ID=7
2025-06-30 05:40:19.815 E ID=8
2025-06-30 05:40:19.820 E ID=10
2025-06-30 05:40:19.825 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
2025-06-30 05:40:19.831 E ID=2
2025-06-30 05:40:19.836 E ID=3
2025-06-30 05:40:19.841 E ID=4
2025-06-30 05:40:19.846 E ID=6
2025-06-30 05:40:19.851 E ID=7
2025-06-30 05:40:19.858 E ID=8
2025-06-30 05:40:19.865 E ID=10
2025-06-30 05:40:19.874 E QUERY_TYPE = PSQL_LOCAL, TIL = SERIALIZABLE, ACCESS = READ, WAIT = NO_WAIT:
2025-06-30 05:40:19.881 E lock conflict on no wait transaction
2025-06-30 05:40:19.894 E - -Acquire lock for relation (TEST) failed
2025-06-30 05:40:19.904 E + -Acquire lock for relation ("PUBLIC"."TEST") failed
2025-06-30 05:40:19.919 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-06-30 05:40:19.934 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-06-30 05:40:19.946 E -901
2025-06-30 05:40:19.959 E 335544345
2025-06-30 05:40:19.970 E 335544382
2025-06-30 05:40:19.978 E 335544842
2025-06-30 05:40:19.987 E QUERY_TYPE = PSQL_LOCAL, TIL = SNAPSHOT, ACCESS = READ, WAIT = NO_WAIT:
2025-06-30 05:40:19.993 E attempted update during read-only transaction
2025-06-30 05:40:20.000 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-06-30 05:40:20.006 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-06-30 05:40:20.013 E -817
2025-06-30 05:40:20.019 E 335544361
2025-06-30 05:40:20.026 E 335544842
2025-06-30 05:40:20.034 E QUERY_TYPE = PSQL_LOCAL, TIL = SNAPSHOT, ACCESS = READ, WAIT = WAIT:
2025-06-30 05:40:20.041 E attempted update during read-only transaction
2025-06-30 05:40:20.050 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-06-30 05:40:20.057 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-06-30 05:40:20.066 E -817
2025-06-30 05:40:20.076 E 335544361
2025-06-30 05:40:20.083 E 335544842
2025-06-30 05:40:20.091 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = NO_WAIT:
2025-06-30 05:40:20.098 E attempted update during read-only transaction
2025-06-30 05:40:20.104 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-06-30 05:40:20.111 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-06-30 05:40:20.120 E -817
2025-06-30 05:40:20.129 E 335544361
2025-06-30 05:40:20.136 E 335544842
2025-06-30 05:40:20.143 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = WAIT:
2025-06-30 05:40:20.150 E attempted update during read-only transaction
2025-06-30 05:40:20.159 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-06-30 05:40:20.171 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-06-30 05:40:20.182 E -817
2025-06-30 05:40:20.190 E 335544361
2025-06-30 05:40:20.196 E 335544842
2025-06-30 05:40:20.203 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
2025-06-30 05:40:20.211 E attempted update during read-only transaction
2025-06-30 05:40:20.222 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-06-30 05:40:20.231 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-06-30 05:40:20.240 E -817
2025-06-30 05:40:20.249 E 335544361
2025-06-30 05:40:20.256 E 335544842
2025-06-30 05:40:20.263 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
2025-06-30 05:40:20.270 E attempted update during read-only transaction
2025-06-30 05:40:20.277 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-06-30 05:40:20.283 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-06-30 05:40:20.296 E -817
2025-06-30 05:40:20.309 E 335544361
2025-06-30 05:40:20.321 E 335544842
2025-06-30 05:40:20.331 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
2025-06-30 05:40:20.341 E attempted update during read-only transaction
2025-06-30 05:40:20.355 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-06-30 05:40:20.366 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-06-30 05:40:20.374 E -817
2025-06-30 05:40:20.382 E 335544361
2025-06-30 05:40:20.394 E 335544842
2025-06-30 05:40:20.404 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
2025-06-30 05:40:20.412 E attempted update during read-only transaction
2025-06-30 05:40:20.419 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-06-30 05:40:20.426 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-06-30 05:40:20.432 E -817
2025-06-30 05:40:20.438 E 335544361
2025-06-30 05:40:20.444 E 335544842
2025-06-30 05:40:20.454 E QUERY_TYPE = PSQL_LOCAL, TIL = SERIALIZABLE, ACCESS = WRITE, WAIT = NO_WAIT:
2025-06-30 05:40:20.468 E lock conflict on no wait transaction
2025-06-30 05:40:20.478 E - -Acquire lock for relation (TEST) failed
2025-06-30 05:40:20.487 E + -Acquire lock for relation ("PUBLIC"."TEST") failed
2025-06-30 05:40:20.504 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-06-30 05:40:20.511 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-06-30 05:40:20.517 E -901
2025-06-30 05:40:20.524 E 335544345
2025-06-30 05:40:20.531 E 335544382
2025-06-30 05:40:20.545 E 335544842
2025-06-30 05:40:20.555 E QUERY_TYPE = PSQL_LOCAL, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = NO_WAIT:
2025-06-30 05:40:20.566 E ID=2
2025-06-30 05:40:20.574 E ID=3
2025-06-30 05:40:20.583 E ID=4
2025-06-30 05:40:20.591 E ID=6
2025-06-30 05:40:20.603 E ID=7
2025-06-30 05:40:20.611 E ID=8
2025-06-30 05:40:20.620 E ID=10
2025-06-30 05:40:20.629 E QUERY_TYPE = PSQL_LOCAL, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = WAIT:
2025-06-30 05:40:20.639 E ID=2
2025-06-30 05:40:20.651 E ID=3
2025-06-30 05:40:20.661 E ID=4
2025-06-30 05:40:20.669 E ID=6
2025-06-30 05:40:20.676 E ID=7
2025-06-30 05:40:20.687 E ID=8
2025-06-30 05:40:20.699 E ID=10
2025-06-30 05:40:20.709 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = NO_WAIT:
2025-06-30 05:40:20.720 E ID=2
2025-06-30 05:40:20.736 E ID=3
2025-06-30 05:40:20.747 E ID=4
2025-06-30 05:40:20.756 E ID=6
2025-06-30 05:40:20.763 E ID=7
2025-06-30 05:40:20.774 E ID=8
2025-06-30 05:40:20.783 E ID=10
2025-06-30 05:40:20.791 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = WAIT:
2025-06-30 05:40:20.804 E ID=2
2025-06-30 05:40:20.817 E ID=3
2025-06-30 05:40:20.827 E ID=4
2025-06-30 05:40:20.840 E ID=6
2025-06-30 05:40:20.852 E ID=7
2025-06-30 05:40:20.865 E ID=8
2025-06-30 05:40:20.876 E ID=10
2025-06-30 05:40:20.884 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
2025-06-30 05:40:20.893 E ID=2
2025-06-30 05:40:20.899 E ID=3
2025-06-30 05:40:20.905 E ID=4
2025-06-30 05:40:20.912 E ID=6
2025-06-30 05:40:20.920 E ID=7
2025-06-30 05:40:20.932 E ID=8
2025-06-30 05:40:20.943 E ID=10
2025-06-30 05:40:20.955 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
2025-06-30 05:40:20.966 E ID=2
2025-06-30 05:40:20.978 E ID=3
2025-06-30 05:40:20.990 E ID=4
2025-06-30 05:40:21.003 E ID=6
2025-06-30 05:40:21.015 E ID=7
2025-06-30 05:40:21.030 E ID=8
2025-06-30 05:40:21.040 E ID=10
2025-06-30 05:40:21.052 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
2025-06-30 05:40:21.065 E ID=2
2025-06-30 05:40:21.078 E ID=3
2025-06-30 05:40:21.089 E ID=4
2025-06-30 05:40:21.097 E ID=6
2025-06-30 05:40:21.107 E ID=7
2025-06-30 05:40:21.119 E ID=8
2025-06-30 05:40:21.128 E ID=10
2025-06-30 05:40:21.139 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
2025-06-30 05:40:21.149 E ID=2
2025-06-30 05:40:21.161 E ID=3
2025-06-30 05:40:21.171 E ID=4
2025-06-30 05:40:21.183 E ID=6
2025-06-30 05:40:21.192 E ID=7
2025-06-30 05:40:21.199 E ID=8
2025-06-30 05:40:21.207 E ID=10
2025-06-30 05:40:21.217 E QUERY_TYPE = PSQL_REMOTE, TIL = SERIALIZABLE, ACCESS = READ, WAIT = NO_WAIT:
2025-06-30 05:40:21.226 E Execute statement error at isc_dsql_fetch :
2025-06-30 05:40:21.234 E 335544345 : lock conflict on no wait transaction
2025-06-30 05:40:21.245 E - 335544382 : Acquire lock for relation (TEST) failed
2025-06-30 05:40:21.257 E + 335544382 : Acquire lock for relation ("PUBLIC"."TEST") failed
2025-06-30 05:40:21.277 E Statement : select id from test order by id with lock skip locked
2025-06-30 05:40:21.286 E Data source : Firebird::localhost:
2025-06-30 05:40:21.295 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-06-30 05:40:21.306 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-06-30 05:40:21.316 E -901
2025-06-30 05:40:21.323 E 335544926
2025-06-30 05:40:21.329 E 335544842
2025-06-30 05:40:21.335 E QUERY_TYPE = PSQL_REMOTE, TIL = SNAPSHOT, ACCESS = READ, WAIT = NO_WAIT:
2025-06-30 05:40:21.340 E Execute statement error at isc_dsql_fetch :
2025-06-30 05:40:21.344 E 335544361 : attempted update during read-only transaction
2025-06-30 05:40:21.351 E Statement : select id from test order by id with lock skip locked
2025-06-30 05:40:21.356 E Data source : Firebird::localhost:
2025-06-30 05:40:21.363 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-06-30 05:40:21.369 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-06-30 05:40:21.374 E -901
2025-06-30 05:40:21.380 E 335544926
2025-06-30 05:40:21.385 E 335544842
2025-06-30 05:40:21.397 E QUERY_TYPE = PSQL_REMOTE, TIL = SNAPSHOT, ACCESS = READ, WAIT = WAIT:
2025-06-30 05:40:21.409 E Execute statement error at isc_dsql_fetch :
2025-06-30 05:40:21.420 E 335544361 : attempted update during read-only transaction
2025-06-30 05:40:21.429 E Statement : select id from test order by id with lock skip locked
2025-06-30 05:40:21.439 E Data source : Firebird::localhost:
2025-06-30 05:40:21.449 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-06-30 05:40:21.462 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-06-30 05:40:21.475 E -901
2025-06-30 05:40:21.487 E 335544926
2025-06-30 05:40:21.499 E 335544842
2025-06-30 05:40:21.508 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = NO_WAIT:
2025-06-30 05:40:21.516 E Execute statement error at isc_dsql_fetch :
2025-06-30 05:40:21.530 E 335544361 : attempted update during read-only transaction
2025-06-30 05:40:21.541 E Statement : select id from test order by id with lock skip locked
2025-06-30 05:40:21.556 E Data source : Firebird::localhost:
2025-06-30 05:40:21.566 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-06-30 05:40:21.573 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-06-30 05:40:21.581 E -901
2025-06-30 05:40:21.588 E 335544926
2025-06-30 05:40:21.597 E 335544842
2025-06-30 05:40:21.608 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = WAIT:
2025-06-30 05:40:21.619 E Execute statement error at isc_dsql_fetch :
2025-06-30 05:40:21.627 E 335544361 : attempted update during read-only transaction
2025-06-30 05:40:21.634 E Statement : select id from test order by id with lock skip locked
2025-06-30 05:40:21.640 E Data source : Firebird::localhost:
2025-06-30 05:40:21.647 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-06-30 05:40:21.653 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-06-30 05:40:21.659 E -901
2025-06-30 05:40:21.667 E 335544926
2025-06-30 05:40:21.679 E 335544842
2025-06-30 05:40:21.693 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
2025-06-30 05:40:21.707 E Execute statement error at isc_dsql_fetch :
2025-06-30 05:40:21.717 E 335544361 : attempted update during read-only transaction
2025-06-30 05:40:21.724 E Statement : select id from test order by id with lock skip locked
2025-06-30 05:40:21.735 E Data source : Firebird::localhost:
2025-06-30 05:40:21.744 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-06-30 05:40:21.752 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-06-30 05:40:21.758 E -901
2025-06-30 05:40:21.768 E 335544926
2025-06-30 05:40:21.776 E 335544842
2025-06-30 05:40:21.785 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
2025-06-30 05:40:21.792 E Execute statement error at isc_dsql_fetch :
2025-06-30 05:40:21.798 E 335544361 : attempted update during read-only transaction
2025-06-30 05:40:21.805 E Statement : select id from test order by id with lock skip locked
2025-06-30 05:40:21.811 E Data source : Firebird::localhost:
2025-06-30 05:40:21.818 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-06-30 05:40:21.825 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-06-30 05:40:21.833 E -901
2025-06-30 05:40:21.848 E 335544926
2025-06-30 05:40:21.861 E 335544842
2025-06-30 05:40:21.874 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
2025-06-30 05:40:21.887 E Execute statement error at isc_dsql_fetch :
2025-06-30 05:40:21.896 E 335544361 : attempted update during read-only transaction
2025-06-30 05:40:21.905 E Statement : select id from test order by id with lock skip locked
2025-06-30 05:40:21.912 E Data source : Firebird::localhost:
2025-06-30 05:40:21.919 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-06-30 05:40:21.925 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-06-30 05:40:21.932 E -901
2025-06-30 05:40:21.938 E 335544926
2025-06-30 05:40:21.950 E 335544842
2025-06-30 05:40:21.963 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
2025-06-30 05:40:21.974 E Execute statement error at isc_dsql_fetch :
2025-06-30 05:40:21.981 E 335544361 : attempted update during read-only transaction
2025-06-30 05:40:21.987 E Statement : select id from test order by id with lock skip locked
2025-06-30 05:40:21.993 E Data source : Firebird::localhost:
2025-06-30 05:40:22.009 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-06-30 05:40:22.025 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-06-30 05:40:22.036 E -901
2025-06-30 05:40:22.045 E 335544926
2025-06-30 05:40:22.052 E 335544842
2025-06-30 05:40:22.059 E QUERY_TYPE = PSQL_REMOTE, TIL = SERIALIZABLE, ACCESS = WRITE, WAIT = NO_WAIT:
2025-06-30 05:40:22.064 E Execute statement error at isc_dsql_fetch :
2025-06-30 05:40:22.071 E 335544345 : lock conflict on no wait transaction
2025-06-30 05:40:22.078 E - 335544382 : Acquire lock for relation (TEST) failed
2025-06-30 05:40:22.085 E + 335544382 : Acquire lock for relation ("PUBLIC"."TEST") failed
2025-06-30 05:40:22.099 E Statement : select id from test order by id with lock skip locked
2025-06-30 05:40:22.106 E Data source : Firebird::localhost:
2025-06-30 05:40:22.113 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-06-30 05:40:22.119 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-06-30 05:40:22.125 E -901
2025-06-30 05:40:22.130 E 335544926
2025-06-30 05:40:22.135 E 335544842
2025-06-30 05:40:22.141 E QUERY_TYPE = PSQL_REMOTE, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = NO_WAIT:
2025-06-30 05:40:22.153 E ID=2
2025-06-30 05:40:22.163 E ID=3
2025-06-30 05:40:22.171 E ID=4
2025-06-30 05:40:22.179 E ID=6
2025-06-30 05:40:22.186 E ID=7
2025-06-30 05:40:22.196 E ID=8
2025-06-30 05:40:22.209 E ID=10
2025-06-30 05:40:22.218 E QUERY_TYPE = PSQL_REMOTE, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = WAIT:
2025-06-30 05:40:22.227 E ID=2
2025-06-30 05:40:22.233 E ID=3
2025-06-30 05:40:22.240 E ID=4
2025-06-30 05:40:22.247 E ID=6
2025-06-30 05:40:22.256 E ID=7
2025-06-30 05:40:22.268 E ID=8
2025-06-30 05:40:22.276 E ID=10
2025-06-30 05:40:22.284 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = NO_WAIT:
2025-06-30 05:40:22.295 E ID=2
2025-06-30 05:40:22.301 E ID=3
2025-06-30 05:40:22.306 E ID=4
2025-06-30 05:40:22.318 E ID=6
2025-06-30 05:40:22.329 E ID=7
2025-06-30 05:40:22.337 E ID=8
2025-06-30 05:40:22.350 E ID=10
2025-06-30 05:40:22.362 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = WAIT:
2025-06-30 05:40:22.373 E ID=2
2025-06-30 05:40:22.382 E ID=3
2025-06-30 05:40:22.395 E ID=4
2025-06-30 05:40:22.404 E ID=6
2025-06-30 05:40:22.413 E ID=7
2025-06-30 05:40:22.421 E ID=8
2025-06-30 05:40:22.427 E ID=10
2025-06-30 05:40:22.435 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
2025-06-30 05:40:22.440 E ID=2
2025-06-30 05:40:22.447 E ID=3
2025-06-30 05:40:22.459 E ID=4
2025-06-30 05:40:22.470 E ID=6
2025-06-30 05:40:22.480 E ID=7
2025-06-30 05:40:22.493 E ID=8
2025-06-30 05:40:22.505 E ID=10
2025-06-30 05:40:22.517 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
2025-06-30 05:40:22.531 E ID=2
2025-06-30 05:40:22.543 E ID=3
2025-06-30 05:40:22.552 E ID=4
2025-06-30 05:40:22.560 E ID=6
2025-06-30 05:40:22.566 E ID=7
2025-06-30 05:40:22.573 E ID=8
2025-06-30 05:40:22.580 E ID=10
2025-06-30 05:40:22.592 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
2025-06-30 05:40:22.603 E ID=2
2025-06-30 05:40:22.613 E ID=3
2025-06-30 05:40:22.626 E ID=4
2025-06-30 05:40:22.638 E ID=6
2025-06-30 05:40:22.656 E ID=7
2025-06-30 05:40:22.666 E ID=8
2025-06-30 05:40:22.675 E ID=10
2025-06-30 05:40:22.683 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
2025-06-30 05:40:22.690 E ID=2
2025-06-30 05:40:22.696 E ID=3
2025-06-30 05:40:22.701 E ID=4
2025-06-30 05:40:22.706 E ID=6
2025-06-30 05:40:22.711 E ID=7
2025-06-30 05:40:22.716 E ID=8
2025-06-30 05:40:22.724 E ID=10
2025-06-30 05:40:22.733
2025-06-30 05:40:22.743 tests/bugs/gh_7350_test.py:544: AssertionError
2025-06-30 05:40:22.756 ---------------------------- Captured stdout setup -----------------------------
2025-06-30 05:40:22.767 Creating db: localhost:/var/tmp/qa_2024/test_11542/test.fdb [page_size=None, sql_dialect=None, charset='NONE', user=SYSDBA, password=masterkey]
|
3 #text |
act = <firebird.qa.plugin.Action pytest object at [hex]>
capsys = <_pytest.capture.CaptureFixture pytest object at [hex]>
@pytest.mark.es_eds
@pytest.mark.version('>=5.0')
def test_1(act: Action, capsys):
init_sql = f"""
set term ^;
recreate table test(id int primary key, f01 int)
-- recreate global temporary table test(id int primary key, f01 int) on commit preserve rows
^
create or alter procedure sp_get_unlocked_rows_local returns(id int) as
begin
for
{CHECK_SQL}
into id
do
suspend;
end
^
create or alter procedure sp_get_unlocked_rows_remote returns(id int) as
begin
for
execute statement '{CHECK_SQL}'
on external 'localhost:' || rdb$get_context('SYSTEM', 'DB_NAME')
as user '{act.db.user}' password '{act.db.password}'
into id
do
suspend;
end
^
set term ;^
commit;
insert into test(id, f01) select row_number()over(), 0 from rdb$types rows 10;
commit;
"""
act.isql(switches=['-q'], input = init_sql, combine_output = True)
assert act.clean_stdout == ''
act.reset()
tpb_isol_set = (Isolation.SERIALIZABLE, Isolation.SNAPSHOT, Isolation.READ_COMMITTED_READ_CONSISTENCY, Isolation.READ_COMMITTED_RECORD_VERSION, Isolation.READ_COMMITTED_NO_RECORD_VERSION)
tpb_wait_set = (TraLockResolution.NO_WAIT,TraLockResolution.WAIT)
tpb_mode_set = (TraAccessMode.READ, TraAccessMode.WRITE)
query_types_set = ('DSQL', 'PSQL_LOCAL', 'PSQL_REMOTE')
with act.db.connect() as con_rows_locker, act.db.connect() as con_free_seeker:
con_rows_locker.execute_immediate('update test set f01 = 1 where id in (1,5,9)')
for query_type in query_types_set:
for x_mode in tpb_mode_set:
for x_isol in tpb_isol_set:
for x_wait in tpb_wait_set:
skip_flag = x_isol in (Isolation.SERIALIZABLE,) and x_wait == TraLockResolution.WAIT
if skip_flag:
#######################################
### D O N O T C H E C K ###
#######################################
#
# 1. Isolation.SERIALIZABLE requires that the whole table must not be changed by anyone else.
# 2. [WAS ACTUAL BEFORE GH-7810 FIXED; CURRENTLY REMAINS NEEDED FB 5.X]
# Isolation.READ_COMMITTED_NO_RECORD_VERSION can not be used due to implementation details, see:
# Adriano, 26-feb-2023, https://github.com/FirebirdSQL/firebird/pull/7350#issuecomment-1445408462
# "WITH LOCK [SKIP LOCKED] needs a record read before, but this locked records cannot be read with NO RECORD VERSION.
# Considering that this transaction mode is replaced by default I would only document it as in fact I don't think
# there are anything we could do."
continue
custom_tpb = tpb(isolation = x_isol, access_mode = x_mode, lock_timeout = -1 if x_wait == TraLockResolution.WAIT else 0)
#custom_tpb = TPB(isolation = x_isol, access_mode = x_mode, lock_timeout = 0).get_buffer()
tx_free_seeker = con_free_seeker.transaction_manager(custom_tpb)
cur_free_seeker = tx_free_seeker.cursor()
tx_free_seeker.begin()
try:
print('\n')
print(f'QUERY_TYPE = {query_type}, TIL = {x_isol.name}, ACCESS = {x_mode.name}, WAIT = {x_wait.name}:')
if query_type == 'DSQL':
cur_free_seeker.execute(f'{CHECK_SQL}')
elif query_type == 'PSQL_LOCAL':
cur_free_seeker.execute('select id from sp_get_unlocked_rows_local')
elif query_type == 'PSQL_REMOTE':
cur_free_seeker.execute('select id from sp_get_unlocked_rows_remote')
for r in cur_free_seeker:
print('ID='+str(r[0]))
except DatabaseError as e:
print(e.__str__())
print(e.sqlcode)
for g in e.gds_codes:
print(g)
finally:
tx_free_seeker.rollback()
act.expected_stdout = expected_stdout
act.stdout = capsys.readouterr().out
> assert act.clean_stdout == act.clean_expected_stdout
E assert
E QUERY_TYPE = DSQL, TIL = SERIALIZABLE, ACCESS = READ, WAIT = NO_WAIT:
E lock conflict on no wait transaction
E - -Acquire lock for relation (TEST) failed
E + -Acquire lock for relation ("PUBLIC"."TEST") failed
E -901
E 335544345
E 335544382
E QUERY_TYPE = DSQL, TIL = SNAPSHOT, ACCESS = READ, WAIT = NO_WAIT:
E attempted update during read-only transaction
E -817
E 335544361
E QUERY_TYPE = DSQL, TIL = SNAPSHOT, ACCESS = READ, WAIT = WAIT:
E attempted update during read-only transaction
E -817
E 335544361
E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = NO_WAIT:
E attempted update during read-only transaction
E -817
E 335544361
E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = WAIT:
E attempted update during read-only transaction
E -817
E 335544361
E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
E attempted update during read-only transaction
E -817
E 335544361
E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
E attempted update during read-only transaction
E -817
E 335544361
E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
E attempted update during read-only transaction
E -817
E 335544361
E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
E attempted update during read-only transaction
E -817
E 335544361
E QUERY_TYPE = DSQL, TIL = SERIALIZABLE, ACCESS = WRITE, WAIT = NO_WAIT:
E lock conflict on no wait transaction
E - -Acquire lock for relation (TEST) failed
E + -Acquire lock for relation ("PUBLIC"."TEST") failed
E -901
E 335544345
E 335544382
E QUERY_TYPE = DSQL, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = NO_WAIT:
E ID=2
E ID=3
E ID=4
E ID=6
E ID=7
E ID=8
E ID=10
E QUERY_TYPE = DSQL, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = WAIT:
E ID=2
E ID=3
E ID=4
E ID=6
E ID=7
E ID=8
E ID=10
E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = NO_WAIT:
E ID=2
E ID=3
E ID=4
E ID=6
E ID=7
E ID=8
E ID=10
E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = WAIT:
E ID=2
E ID=3
E ID=4
E ID=6
E ID=7
E ID=8
E ID=10
E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
E ID=2
E ID=3
E ID=4
E ID=6
E ID=7
E ID=8
E ID=10
E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
E ID=2
E ID=3
E ID=4
E ID=6
E ID=7
E ID=8
E ID=10
E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
E ID=2
E ID=3
E ID=4
E ID=6
E ID=7
E ID=8
E ID=10
E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
E ID=2
E ID=3
E ID=4
E ID=6
E ID=7
E ID=8
E ID=10
E QUERY_TYPE = PSQL_LOCAL, TIL = SERIALIZABLE, ACCESS = READ, WAIT = NO_WAIT:
E lock conflict on no wait transaction
E - -Acquire lock for relation (TEST) failed
E + -Acquire lock for relation ("PUBLIC"."TEST") failed
E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
E -901
E 335544345
E 335544382
E 335544842
E QUERY_TYPE = PSQL_LOCAL, TIL = SNAPSHOT, ACCESS = READ, WAIT = NO_WAIT:
E attempted update during read-only transaction
E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
E -817
E 335544361
E 335544842
E QUERY_TYPE = PSQL_LOCAL, TIL = SNAPSHOT, ACCESS = READ, WAIT = WAIT:
E attempted update during read-only transaction
E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
E -817
E 335544361
E 335544842
E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = NO_WAIT:
E attempted update during read-only transaction
E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
E -817
E 335544361
E 335544842
E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = WAIT:
E attempted update during read-only transaction
E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
E -817
E 335544361
E 335544842
E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
E attempted update during read-only transaction
E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
E -817
E 335544361
E 335544842
E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
E attempted update during read-only transaction
E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
E -817
E 335544361
E 335544842
E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
E attempted update during read-only transaction
E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
E -817
E 335544361
E 335544842
E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
E attempted update during read-only transaction
E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
E -817
E 335544361
E 335544842
E QUERY_TYPE = PSQL_LOCAL, TIL = SERIALIZABLE, ACCESS = WRITE, WAIT = NO_WAIT:
E lock conflict on no wait transaction
E - -Acquire lock for relation (TEST) failed
E + -Acquire lock for relation ("PUBLIC"."TEST") failed
E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
E -901
E 335544345
E 335544382
E 335544842
E QUERY_TYPE = PSQL_LOCAL, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = NO_WAIT:
E ID=2
E ID=3
E ID=4
E ID=6
E ID=7
E ID=8
E ID=10
E QUERY_TYPE = PSQL_LOCAL, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = WAIT:
E ID=2
E ID=3
E ID=4
E ID=6
E ID=7
E ID=8
E ID=10
E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = NO_WAIT:
E ID=2
E ID=3
E ID=4
E ID=6
E ID=7
E ID=8
E ID=10
E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = WAIT:
E ID=2
E ID=3
E ID=4
E ID=6
E ID=7
E ID=8
E ID=10
E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
E ID=2
E ID=3
E ID=4
E ID=6
E ID=7
E ID=8
E ID=10
E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
E ID=2
E ID=3
E ID=4
E ID=6
E ID=7
E ID=8
E ID=10
E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
E ID=2
E ID=3
E ID=4
E ID=6
E ID=7
E ID=8
E ID=10
E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
E ID=2
E ID=3
E ID=4
E ID=6
E ID=7
E ID=8
E ID=10
E QUERY_TYPE = PSQL_REMOTE, TIL = SERIALIZABLE, ACCESS = READ, WAIT = NO_WAIT:
E Execute statement error at isc_dsql_fetch :
E 335544345 : lock conflict on no wait transaction
E - 335544382 : Acquire lock for relation (TEST) failed
E + 335544382 : Acquire lock for relation ("PUBLIC"."TEST") failed
E Statement : select id from test order by id with lock skip locked
E Data source : Firebird::localhost:
E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
E -901
E 335544926
E 335544842
E QUERY_TYPE = PSQL_REMOTE, TIL = SNAPSHOT, ACCESS = READ, WAIT = NO_WAIT:
E Execute statement error at isc_dsql_fetch :
E 335544361 : attempted update during read-only transaction
E Statement : select id from test order by id with lock skip locked
E Data source : Firebird::localhost:
E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
E -901
E 335544926
E 335544842
E QUERY_TYPE = PSQL_REMOTE, TIL = SNAPSHOT, ACCESS = READ, WAIT = WAIT:
E Execute statement error at isc_dsql_fetch :
E 335544361 : attempted update during read-only transaction
E Statement : select id from test order by id with lock skip locked
E Data source : Firebird::localhost:
E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
E -901
E 335544926
E 335544842
E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = NO_WAIT:
E Execute statement error at isc_dsql_fetch :
E 335544361 : attempted update during read-only transaction
E Statement : select id from test order by id with lock skip locked
E Data source : Firebird::localhost:
E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
E -901
E 335544926
E 335544842
E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = WAIT:
E Execute statement error at isc_dsql_fetch :
E 335544361 : attempted update during read-only transaction
E Statement : select id from test order by id with lock skip locked
E Data source : Firebird::localhost:
E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
E -901
E 335544926
E 335544842
E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
E Execute statement error at isc_dsql_fetch :
E 335544361 : attempted update during read-only transaction
E Statement : select id from test order by id with lock skip locked
E Data source : Firebird::localhost:
E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
E -901
E 335544926
E 335544842
E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
E Execute statement error at isc_dsql_fetch :
E 335544361 : attempted update during read-only transaction
E Statement : select id from test order by id with lock skip locked
E Data source : Firebird::localhost:
E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
E -901
E 335544926
E 335544842
E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
E Execute statement error at isc_dsql_fetch :
E 335544361 : attempted update during read-only transaction
E Statement : select id from test order by id with lock skip locked
E Data source : Firebird::localhost:
E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
E -901
E 335544926
E 335544842
E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
E Execute statement error at isc_dsql_fetch :
E 335544361 : attempted update during read-only transaction
E Statement : select id from test order by id with lock skip locked
E Data source : Firebird::localhost:
E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
E -901
E 335544926
E 335544842
E QUERY_TYPE = PSQL_REMOTE, TIL = SERIALIZABLE, ACCESS = WRITE, WAIT = NO_WAIT:
E Execute statement error at isc_dsql_fetch :
E 335544345 : lock conflict on no wait transaction
E - 335544382 : Acquire lock for relation (TEST) failed
E + 335544382 : Acquire lock for relation ("PUBLIC"."TEST") failed
E Statement : select id from test order by id with lock skip locked
E Data source : Firebird::localhost:
E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
E -901
E 335544926
E 335544842
E QUERY_TYPE = PSQL_REMOTE, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = NO_WAIT:
E ID=2
E ID=3
E ID=4
E ID=6
E ID=7
E ID=8
E ID=10
E QUERY_TYPE = PSQL_REMOTE, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = WAIT:
E ID=2
E ID=3
E ID=4
E ID=6
E ID=7
E ID=8
E ID=10
E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = NO_WAIT:
E ID=2
E ID=3
E ID=4
E ID=6
E ID=7
E ID=8
E ID=10
E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = WAIT:
E ID=2
E ID=3
E ID=4
E ID=6
E ID=7
E ID=8
E ID=10
E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
E ID=2
E ID=3
E ID=4
E ID=6
E ID=7
E ID=8
E ID=10
E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
E ID=2
E ID=3
E ID=4
E ID=6
E ID=7
E ID=8
E ID=10
E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
E ID=2
E ID=3
E ID=4
E ID=6
E ID=7
E ID=8
E ID=10
E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
E ID=2
E ID=3
E ID=4
E ID=6
E ID=7
E ID=8
E ID=10
tests/bugs/gh_7350_test.py:544: AssertionError
|