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-27 05:17:24.571
2025-06-27 05:17:24.582 act = <firebird.qa.plugin.Action object at [hex]>
2025-06-27 05:17:24.592 capsys = <_pytest.capture.CaptureFixture object at [hex]>
2025-06-27 05:17:24.600
2025-06-27 05:17:24.606 @pytest.mark.es_eds
2025-06-27 05:17:24.618 @pytest.mark.version('>=5.0')
2025-06-27 05:17:24.626 def test_1(act: Action, capsys):
2025-06-27 05:17:24.635
2025-06-27 05:17:24.645 init_sql = f"""
2025-06-27 05:17:24.653 set term ^;
2025-06-27 05:17:24.660 recreate table test(id int primary key, f01 int)
2025-06-27 05:17:24.671 -- recreate global temporary table test(id int primary key, f01 int) on commit preserve rows
2025-06-27 05:17:24.680 ^
2025-06-27 05:17:24.688 create or alter procedure sp_get_unlocked_rows_local returns(id int) as
2025-06-27 05:17:24.695 begin
2025-06-27 05:17:24.702 for
2025-06-27 05:17:24.710 {CHECK_SQL}
2025-06-27 05:17:24.717 into id
2025-06-27 05:17:24.724 do
2025-06-27 05:17:24.729 suspend;
2025-06-27 05:17:24.735 end
2025-06-27 05:17:24.742 ^
2025-06-27 05:17:24.748 create or alter procedure sp_get_unlocked_rows_remote returns(id int) as
2025-06-27 05:17:24.756 begin
2025-06-27 05:17:24.762 for
2025-06-27 05:17:24.768 execute statement '{CHECK_SQL}'
2025-06-27 05:17:24.774 on external 'localhost:' || rdb$get_context('SYSTEM', 'DB_NAME')
2025-06-27 05:17:24.781 as user '{act.db.user}' password '{act.db.password}'
2025-06-27 05:17:24.787 into id
2025-06-27 05:17:24.794 do
2025-06-27 05:17:24.803 suspend;
2025-06-27 05:17:24.809 end
2025-06-27 05:17:24.814 ^
2025-06-27 05:17:24.826 set term ;^
2025-06-27 05:17:24.837 commit;
2025-06-27 05:17:24.846
2025-06-27 05:17:24.860 insert into test(id, f01) select row_number()over(), 0 from rdb$types rows 10;
2025-06-27 05:17:24.869 commit;
2025-06-27 05:17:24.876 """
2025-06-27 05:17:24.882 act.isql(switches=['-q'], input = init_sql, combine_output = True)
2025-06-27 05:17:24.893 assert act.clean_stdout == ''
2025-06-27 05:17:24.905 act.reset()
2025-06-27 05:17:24.914
2025-06-27 05:17:24.921 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-27 05:17:24.927 tpb_wait_set = (TraLockResolution.NO_WAIT,TraLockResolution.WAIT)
2025-06-27 05:17:24.933 tpb_mode_set = (TraAccessMode.READ, TraAccessMode.WRITE)
2025-06-27 05:17:24.939 query_types_set = ('DSQL', 'PSQL_LOCAL', 'PSQL_REMOTE')
2025-06-27 05:17:24.945
2025-06-27 05:17:24.951 with act.db.connect() as con_rows_locker, act.db.connect() as con_free_seeker:
2025-06-27 05:17:24.963 con_rows_locker.execute_immediate('update test set f01 = 1 where id in (1,5,9)')
2025-06-27 05:17:24.974 for query_type in query_types_set:
2025-06-27 05:17:24.985 for x_mode in tpb_mode_set:
2025-06-27 05:17:24.998 for x_isol in tpb_isol_set:
2025-06-27 05:17:25.009 for x_wait in tpb_wait_set:
2025-06-27 05:17:25.019 skip_flag = x_isol in (Isolation.SERIALIZABLE,) and x_wait == TraLockResolution.WAIT
2025-06-27 05:17:25.031 if skip_flag:
2025-06-27 05:17:25.043
2025-06-27 05:17:25.055 #######################################
2025-06-27 05:17:25.064 ### D O N O T C H E C K ###
2025-06-27 05:17:25.073 #######################################
2025-06-27 05:17:25.081 #
2025-06-27 05:17:25.088 # 1. Isolation.SERIALIZABLE requires that the whole table must not be changed by anyone else.
2025-06-27 05:17:25.095 # 2. [WAS ACTUAL BEFORE GH-7810 FIXED; CURRENTLY REMAINS NEEDED FB 5.X]
2025-06-27 05:17:25.100 # Isolation.READ_COMMITTED_NO_RECORD_VERSION can not be used due to implementation details, see:
2025-06-27 05:17:25.104 # Adriano, 26-feb-2023, https://github.com/FirebirdSQL/firebird/pull/7350#issuecomment-1445408462
2025-06-27 05:17:25.109 # "WITH LOCK [SKIP LOCKED] needs a record read before, but this locked records cannot be read with NO RECORD VERSION.
2025-06-27 05:17:25.114 # Considering that this transaction mode is replaced by default I would only document it as in fact I don't think
2025-06-27 05:17:25.118 # there are anything we could do."
2025-06-27 05:17:25.122
2025-06-27 05:17:25.127 continue
2025-06-27 05:17:25.131
2025-06-27 05:17:25.136 custom_tpb = tpb(isolation = x_isol, access_mode = x_mode, lock_timeout = -1 if x_wait == TraLockResolution.WAIT else 0)
2025-06-27 05:17:25.140 #custom_tpb = TPB(isolation = x_isol, access_mode = x_mode, lock_timeout = 0).get_buffer()
2025-06-27 05:17:25.145 tx_free_seeker = con_free_seeker.transaction_manager(custom_tpb)
2025-06-27 05:17:25.149 cur_free_seeker = tx_free_seeker.cursor()
2025-06-27 05:17:25.153 tx_free_seeker.begin()
2025-06-27 05:17:25.158 try:
2025-06-27 05:17:25.162 print('\n')
2025-06-27 05:17:25.167 print(f'QUERY_TYPE = {query_type}, TIL = {x_isol.name}, ACCESS = {x_mode.name}, WAIT = {x_wait.name}:')
2025-06-27 05:17:25.171 if query_type == 'DSQL':
2025-06-27 05:17:25.176 cur_free_seeker.execute(f'{CHECK_SQL}')
2025-06-27 05:17:25.180 elif query_type == 'PSQL_LOCAL':
2025-06-27 05:17:25.185 cur_free_seeker.execute('select id from sp_get_unlocked_rows_local')
2025-06-27 05:17:25.190 elif query_type == 'PSQL_REMOTE':
2025-06-27 05:17:25.194 cur_free_seeker.execute('select id from sp_get_unlocked_rows_remote')
2025-06-27 05:17:25.199 for r in cur_free_seeker:
2025-06-27 05:17:25.203 print('ID='+str(r[0]))
2025-06-27 05:17:25.208 except DatabaseError as e:
2025-06-27 05:17:25.212 print(e.__str__())
2025-06-27 05:17:25.223 print(e.sqlcode)
2025-06-27 05:17:25.229 for g in e.gds_codes:
2025-06-27 05:17:25.240 print(g)
2025-06-27 05:17:25.249 finally:
2025-06-27 05:17:25.257 tx_free_seeker.rollback()
2025-06-27 05:17:25.266
2025-06-27 05:17:25.277 act.expected_stdout = expected_stdout
2025-06-27 05:17:25.287 act.stdout = capsys.readouterr().out
2025-06-27 05:17:25.296 > assert act.clean_stdout == act.clean_expected_stdout
2025-06-27 05:17:25.308 E assert
2025-06-27 05:17:25.316 E QUERY_TYPE = DSQL, TIL = SERIALIZABLE, ACCESS = READ, WAIT = NO_WAIT:
2025-06-27 05:17:25.323 E lock conflict on no wait transaction
2025-06-27 05:17:25.330 E - -Acquire lock for relation (TEST) failed
2025-06-27 05:17:25.337 E + -Acquire lock for relation ("PUBLIC"."TEST") failed
2025-06-27 05:17:25.350 E -901
2025-06-27 05:17:25.355 E 335544345
2025-06-27 05:17:25.360 E 335544382
2025-06-27 05:17:25.365 E QUERY_TYPE = DSQL, TIL = SNAPSHOT, ACCESS = READ, WAIT = NO_WAIT:
2025-06-27 05:17:25.370 E attempted update during read-only transaction
2025-06-27 05:17:25.374 E -817
2025-06-27 05:17:25.378 E 335544361
2025-06-27 05:17:25.383 E QUERY_TYPE = DSQL, TIL = SNAPSHOT, ACCESS = READ, WAIT = WAIT:
2025-06-27 05:17:25.391 E attempted update during read-only transaction
2025-06-27 05:17:25.399 E -817
2025-06-27 05:17:25.405 E 335544361
2025-06-27 05:17:25.411 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = NO_WAIT:
2025-06-27 05:17:25.416 E attempted update during read-only transaction
2025-06-27 05:17:25.428 E -817
2025-06-27 05:17:25.437 E 335544361
2025-06-27 05:17:25.443 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = WAIT:
2025-06-27 05:17:25.449 E attempted update during read-only transaction
2025-06-27 05:17:25.454 E -817
2025-06-27 05:17:25.460 E 335544361
2025-06-27 05:17:25.466 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
2025-06-27 05:17:25.472 E attempted update during read-only transaction
2025-06-27 05:17:25.479 E -817
2025-06-27 05:17:25.489 E 335544361
2025-06-27 05:17:25.497 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
2025-06-27 05:17:25.508 E attempted update during read-only transaction
2025-06-27 05:17:25.518 E -817
2025-06-27 05:17:25.526 E 335544361
2025-06-27 05:17:25.534 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
2025-06-27 05:17:25.541 E attempted update during read-only transaction
2025-06-27 05:17:25.546 E -817
2025-06-27 05:17:25.552 E 335544361
2025-06-27 05:17:25.558 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
2025-06-27 05:17:25.564 E attempted update during read-only transaction
2025-06-27 05:17:25.570 E -817
2025-06-27 05:17:25.575 E 335544361
2025-06-27 05:17:25.582 E QUERY_TYPE = DSQL, TIL = SERIALIZABLE, ACCESS = WRITE, WAIT = NO_WAIT:
2025-06-27 05:17:25.593 E lock conflict on no wait transaction
2025-06-27 05:17:25.604 E - -Acquire lock for relation (TEST) failed
2025-06-27 05:17:25.612 E + -Acquire lock for relation ("PUBLIC"."TEST") failed
2025-06-27 05:17:25.628 E -901
2025-06-27 05:17:25.637 E 335544345
2025-06-27 05:17:25.644 E 335544382
2025-06-27 05:17:25.651 E QUERY_TYPE = DSQL, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = NO_WAIT:
2025-06-27 05:17:25.659 E ID=2
2025-06-27 05:17:25.669 E ID=3
2025-06-27 05:17:25.677 E ID=4
2025-06-27 05:17:25.684 E ID=6
2025-06-27 05:17:25.689 E ID=7
2025-06-27 05:17:25.694 E ID=8
2025-06-27 05:17:25.700 E ID=10
2025-06-27 05:17:25.706 E QUERY_TYPE = DSQL, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = WAIT:
2025-06-27 05:17:25.711 E ID=2
2025-06-27 05:17:25.718 E ID=3
2025-06-27 05:17:25.727 E ID=4
2025-06-27 05:17:25.736 E ID=6
2025-06-27 05:17:25.743 E ID=7
2025-06-27 05:17:25.748 E ID=8
2025-06-27 05:17:25.758 E ID=10
2025-06-27 05:17:25.765 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = NO_WAIT:
2025-06-27 05:17:25.771 E ID=2
2025-06-27 05:17:25.777 E ID=3
2025-06-27 05:17:25.783 E ID=4
2025-06-27 05:17:25.790 E ID=6
2025-06-27 05:17:25.801 E ID=7
2025-06-27 05:17:25.810 E ID=8
2025-06-27 05:17:25.818 E ID=10
2025-06-27 05:17:25.825 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = WAIT:
2025-06-27 05:17:25.831 E ID=2
2025-06-27 05:17:25.838 E ID=3
2025-06-27 05:17:25.849 E ID=4
2025-06-27 05:17:25.859 E ID=6
2025-06-27 05:17:25.866 E ID=7
2025-06-27 05:17:25.872 E ID=8
2025-06-27 05:17:25.878 E ID=10
2025-06-27 05:17:25.885 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
2025-06-27 05:17:25.892 E ID=2
2025-06-27 05:17:25.898 E ID=3
2025-06-27 05:17:25.905 E ID=4
2025-06-27 05:17:25.911 E ID=6
2025-06-27 05:17:25.918 E ID=7
2025-06-27 05:17:25.925 E ID=8
2025-06-27 05:17:25.931 E ID=10
2025-06-27 05:17:25.939 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
2025-06-27 05:17:25.945 E ID=2
2025-06-27 05:17:25.957 E ID=3
2025-06-27 05:17:25.967 E ID=4
2025-06-27 05:17:25.976 E ID=6
2025-06-27 05:17:25.982 E ID=7
2025-06-27 05:17:25.988 E ID=8
2025-06-27 05:17:25.992 E ID=10
2025-06-27 05:17:25.997 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
2025-06-27 05:17:26.002 E ID=2
2025-06-27 05:17:26.006 E ID=3
2025-06-27 05:17:26.011 E ID=4
2025-06-27 05:17:26.016 E ID=6
2025-06-27 05:17:26.022 E ID=7
2025-06-27 05:17:26.027 E ID=8
2025-06-27 05:17:26.035 E ID=10
2025-06-27 05:17:26.046 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
2025-06-27 05:17:26.054 E ID=2
2025-06-27 05:17:26.061 E ID=3
2025-06-27 05:17:26.067 E ID=4
2025-06-27 05:17:26.072 E ID=6
2025-06-27 05:17:26.078 E ID=7
2025-06-27 05:17:26.084 E ID=8
2025-06-27 05:17:26.090 E ID=10
2025-06-27 05:17:26.096 E QUERY_TYPE = PSQL_LOCAL, TIL = SERIALIZABLE, ACCESS = READ, WAIT = NO_WAIT:
2025-06-27 05:17:26.106 E lock conflict on no wait transaction
2025-06-27 05:17:26.116 E - -Acquire lock for relation (TEST) failed
2025-06-27 05:17:26.126 E + -Acquire lock for relation ("PUBLIC"."TEST") failed
2025-06-27 05:17:26.141 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-06-27 05:17:26.147 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-06-27 05:17:26.153 E -901
2025-06-27 05:17:26.160 E 335544345
2025-06-27 05:17:26.166 E 335544382
2025-06-27 05:17:26.173 E 335544842
2025-06-27 05:17:26.179 E QUERY_TYPE = PSQL_LOCAL, TIL = SNAPSHOT, ACCESS = READ, WAIT = NO_WAIT:
2025-06-27 05:17:26.185 E attempted update during read-only transaction
2025-06-27 05:17:26.191 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-06-27 05:17:26.197 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-06-27 05:17:26.204 E -817
2025-06-27 05:17:26.210 E 335544361
2025-06-27 05:17:26.217 E 335544842
2025-06-27 05:17:26.224 E QUERY_TYPE = PSQL_LOCAL, TIL = SNAPSHOT, ACCESS = READ, WAIT = WAIT:
2025-06-27 05:17:26.231 E attempted update during read-only transaction
2025-06-27 05:17:26.237 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-06-27 05:17:26.248 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-06-27 05:17:26.257 E -817
2025-06-27 05:17:26.266 E 335544361
2025-06-27 05:17:26.273 E 335544842
2025-06-27 05:17:26.280 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = NO_WAIT:
2025-06-27 05:17:26.287 E attempted update during read-only transaction
2025-06-27 05:17:26.294 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-06-27 05:17:26.301 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-06-27 05:17:26.307 E -817
2025-06-27 05:17:26.314 E 335544361
2025-06-27 05:17:26.320 E 335544842
2025-06-27 05:17:26.328 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = WAIT:
2025-06-27 05:17:26.335 E attempted update during read-only transaction
2025-06-27 05:17:26.342 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-06-27 05:17:26.353 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-06-27 05:17:26.362 E -817
2025-06-27 05:17:26.368 E 335544361
2025-06-27 05:17:26.375 E 335544842
2025-06-27 05:17:26.386 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
2025-06-27 05:17:26.393 E attempted update during read-only transaction
2025-06-27 05:17:26.399 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-06-27 05:17:26.405 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-06-27 05:17:26.410 E -817
2025-06-27 05:17:26.416 E 335544361
2025-06-27 05:17:26.421 E 335544842
2025-06-27 05:17:26.427 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
2025-06-27 05:17:26.433 E attempted update during read-only transaction
2025-06-27 05:17:26.440 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-06-27 05:17:26.447 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-06-27 05:17:26.455 E -817
2025-06-27 05:17:26.466 E 335544361
2025-06-27 05:17:26.474 E 335544842
2025-06-27 05:17:26.481 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
2025-06-27 05:17:26.486 E attempted update during read-only transaction
2025-06-27 05:17:26.492 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-06-27 05:17:26.498 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-06-27 05:17:26.503 E -817
2025-06-27 05:17:26.509 E 335544361
2025-06-27 05:17:26.514 E 335544842
2025-06-27 05:17:26.520 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
2025-06-27 05:17:26.526 E attempted update during read-only transaction
2025-06-27 05:17:26.531 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-06-27 05:17:26.537 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-06-27 05:17:26.543 E -817
2025-06-27 05:17:26.548 E 335544361
2025-06-27 05:17:26.554 E 335544842
2025-06-27 05:17:26.560 E QUERY_TYPE = PSQL_LOCAL, TIL = SERIALIZABLE, ACCESS = WRITE, WAIT = NO_WAIT:
2025-06-27 05:17:26.565 E lock conflict on no wait transaction
2025-06-27 05:17:26.571 E - -Acquire lock for relation (TEST) failed
2025-06-27 05:17:26.577 E + -Acquire lock for relation ("PUBLIC"."TEST") failed
2025-06-27 05:17:26.588 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-06-27 05:17:26.594 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-06-27 05:17:26.599 E -901
2025-06-27 05:17:26.604 E 335544345
2025-06-27 05:17:26.608 E 335544382
2025-06-27 05:17:26.614 E 335544842
2025-06-27 05:17:26.620 E QUERY_TYPE = PSQL_LOCAL, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = NO_WAIT:
2025-06-27 05:17:26.625 E ID=2
2025-06-27 05:17:26.631 E ID=3
2025-06-27 05:17:26.637 E ID=4
2025-06-27 05:17:26.648 E ID=6
2025-06-27 05:17:26.657 E ID=7
2025-06-27 05:17:26.665 E ID=8
2025-06-27 05:17:26.671 E ID=10
2025-06-27 05:17:26.676 E QUERY_TYPE = PSQL_LOCAL, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = WAIT:
2025-06-27 05:17:26.681 E ID=2
2025-06-27 05:17:26.685 E ID=3
2025-06-27 05:17:26.690 E ID=4
2025-06-27 05:17:26.695 E ID=6
2025-06-27 05:17:26.700 E ID=7
2025-06-27 05:17:26.705 E ID=8
2025-06-27 05:17:26.711 E ID=10
2025-06-27 05:17:26.716 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = NO_WAIT:
2025-06-27 05:17:26.722 E ID=2
2025-06-27 05:17:26.732 E ID=3
2025-06-27 05:17:26.744 E ID=4
2025-06-27 05:17:26.756 E ID=6
2025-06-27 05:17:26.768 E ID=7
2025-06-27 05:17:26.777 E ID=8
2025-06-27 05:17:26.783 E ID=10
2025-06-27 05:17:26.789 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = WAIT:
2025-06-27 05:17:26.794 E ID=2
2025-06-27 05:17:26.799 E ID=3
2025-06-27 05:17:26.807 E ID=4
2025-06-27 05:17:26.818 E ID=6
2025-06-27 05:17:26.826 E ID=7
2025-06-27 05:17:26.832 E ID=8
2025-06-27 05:17:26.839 E ID=10
2025-06-27 05:17:26.845 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
2025-06-27 05:17:26.851 E ID=2
2025-06-27 05:17:26.856 E ID=3
2025-06-27 05:17:26.862 E ID=4
2025-06-27 05:17:26.867 E ID=6
2025-06-27 05:17:26.875 E ID=7
2025-06-27 05:17:26.886 E ID=8
2025-06-27 05:17:26.895 E ID=10
2025-06-27 05:17:26.902 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
2025-06-27 05:17:26.908 E ID=2
2025-06-27 05:17:26.914 E ID=3
2025-06-27 05:17:26.920 E ID=4
2025-06-27 05:17:26.929 E ID=6
2025-06-27 05:17:26.940 E ID=7
2025-06-27 05:17:26.947 E ID=8
2025-06-27 05:17:26.954 E ID=10
2025-06-27 05:17:26.959 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
2025-06-27 05:17:26.965 E ID=2
2025-06-27 05:17:26.971 E ID=3
2025-06-27 05:17:26.978 E ID=4
2025-06-27 05:17:26.990 E ID=6
2025-06-27 05:17:26.999 E ID=7
2025-06-27 05:17:27.006 E ID=8
2025-06-27 05:17:27.011 E ID=10
2025-06-27 05:17:27.016 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
2025-06-27 05:17:27.021 E ID=2
2025-06-27 05:17:27.027 E ID=3
2025-06-27 05:17:27.033 E ID=4
2025-06-27 05:17:27.039 E ID=6
2025-06-27 05:17:27.044 E ID=7
2025-06-27 05:17:27.049 E ID=8
2025-06-27 05:17:27.054 E ID=10
2025-06-27 05:17:27.060 E QUERY_TYPE = PSQL_REMOTE, TIL = SERIALIZABLE, ACCESS = READ, WAIT = NO_WAIT:
2025-06-27 05:17:27.067 E Execute statement error at isc_dsql_fetch :
2025-06-27 05:17:27.075 E 335544345 : lock conflict on no wait transaction
2025-06-27 05:17:27.084 E - 335544382 : Acquire lock for relation (TEST) failed
2025-06-27 05:17:27.091 E + 335544382 : Acquire lock for relation ("PUBLIC"."TEST") failed
2025-06-27 05:17:27.102 E Statement : select id from test order by id with lock skip locked
2025-06-27 05:17:27.107 E Data source : Firebird::localhost:
2025-06-27 05:17:27.112 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-06-27 05:17:27.118 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-06-27 05:17:27.124 E -901
2025-06-27 05:17:27.131 E 335544926
2025-06-27 05:17:27.142 E 335544842
2025-06-27 05:17:27.152 E QUERY_TYPE = PSQL_REMOTE, TIL = SNAPSHOT, ACCESS = READ, WAIT = NO_WAIT:
2025-06-27 05:17:27.161 E Execute statement error at isc_dsql_fetch :
2025-06-27 05:17:27.167 E 335544361 : attempted update during read-only transaction
2025-06-27 05:17:27.174 E Statement : select id from test order by id with lock skip locked
2025-06-27 05:17:27.180 E Data source : Firebird::localhost:
2025-06-27 05:17:27.187 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-06-27 05:17:27.195 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-06-27 05:17:27.205 E -901
2025-06-27 05:17:27.213 E 335544926
2025-06-27 05:17:27.219 E 335544842
2025-06-27 05:17:27.225 E QUERY_TYPE = PSQL_REMOTE, TIL = SNAPSHOT, ACCESS = READ, WAIT = WAIT:
2025-06-27 05:17:27.229 E Execute statement error at isc_dsql_fetch :
2025-06-27 05:17:27.234 E 335544361 : attempted update during read-only transaction
2025-06-27 05:17:27.239 E Statement : select id from test order by id with lock skip locked
2025-06-27 05:17:27.245 E Data source : Firebird::localhost:
2025-06-27 05:17:27.252 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-06-27 05:17:27.259 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-06-27 05:17:27.266 E -901
2025-06-27 05:17:27.276 E 335544926
2025-06-27 05:17:27.286 E 335544842
2025-06-27 05:17:27.293 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = NO_WAIT:
2025-06-27 05:17:27.298 E Execute statement error at isc_dsql_fetch :
2025-06-27 05:17:27.304 E 335544361 : attempted update during read-only transaction
2025-06-27 05:17:27.310 E Statement : select id from test order by id with lock skip locked
2025-06-27 05:17:27.315 E Data source : Firebird::localhost:
2025-06-27 05:17:27.321 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-06-27 05:17:27.327 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-06-27 05:17:27.333 E -901
2025-06-27 05:17:27.339 E 335544926
2025-06-27 05:17:27.346 E 335544842
2025-06-27 05:17:27.353 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = WAIT:
2025-06-27 05:17:27.359 E Execute statement error at isc_dsql_fetch :
2025-06-27 05:17:27.366 E 335544361 : attempted update during read-only transaction
2025-06-27 05:17:27.374 E Statement : select id from test order by id with lock skip locked
2025-06-27 05:17:27.383 E Data source : Firebird::localhost:
2025-06-27 05:17:27.389 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-06-27 05:17:27.395 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-06-27 05:17:27.401 E -901
2025-06-27 05:17:27.406 E 335544926
2025-06-27 05:17:27.412 E 335544842
2025-06-27 05:17:27.418 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
2025-06-27 05:17:27.422 E Execute statement error at isc_dsql_fetch :
2025-06-27 05:17:27.427 E 335544361 : attempted update during read-only transaction
2025-06-27 05:17:27.432 E Statement : select id from test order by id with lock skip locked
2025-06-27 05:17:27.439 E Data source : Firebird::localhost:
2025-06-27 05:17:27.446 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-06-27 05:17:27.451 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-06-27 05:17:27.456 E -901
2025-06-27 05:17:27.461 E 335544926
2025-06-27 05:17:27.465 E 335544842
2025-06-27 05:17:27.470 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
2025-06-27 05:17:27.475 E Execute statement error at isc_dsql_fetch :
2025-06-27 05:17:27.480 E 335544361 : attempted update during read-only transaction
2025-06-27 05:17:27.485 E Statement : select id from test order by id with lock skip locked
2025-06-27 05:17:27.490 E Data source : Firebird::localhost:
2025-06-27 05:17:27.494 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-06-27 05:17:27.499 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-06-27 05:17:27.504 E -901
2025-06-27 05:17:27.509 E 335544926
2025-06-27 05:17:27.514 E 335544842
2025-06-27 05:17:27.518 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
2025-06-27 05:17:27.523 E Execute statement error at isc_dsql_fetch :
2025-06-27 05:17:27.528 E 335544361 : attempted update during read-only transaction
2025-06-27 05:17:27.534 E Statement : select id from test order by id with lock skip locked
2025-06-27 05:17:27.539 E Data source : Firebird::localhost:
2025-06-27 05:17:27.545 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-06-27 05:17:27.551 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-06-27 05:17:27.559 E -901
2025-06-27 05:17:27.568 E 335544926
2025-06-27 05:17:27.577 E 335544842
2025-06-27 05:17:27.584 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
2025-06-27 05:17:27.591 E Execute statement error at isc_dsql_fetch :
2025-06-27 05:17:27.599 E 335544361 : attempted update during read-only transaction
2025-06-27 05:17:27.609 E Statement : select id from test order by id with lock skip locked
2025-06-27 05:17:27.619 E Data source : Firebird::localhost:
2025-06-27 05:17:27.625 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-06-27 05:17:27.635 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-06-27 05:17:27.643 E -901
2025-06-27 05:17:27.649 E 335544926
2025-06-27 05:17:27.654 E 335544842
2025-06-27 05:17:27.659 E QUERY_TYPE = PSQL_REMOTE, TIL = SERIALIZABLE, ACCESS = WRITE, WAIT = NO_WAIT:
2025-06-27 05:17:27.665 E Execute statement error at isc_dsql_fetch :
2025-06-27 05:17:27.670 E 335544345 : lock conflict on no wait transaction
2025-06-27 05:17:27.676 E - 335544382 : Acquire lock for relation (TEST) failed
2025-06-27 05:17:27.684 E + 335544382 : Acquire lock for relation ("PUBLIC"."TEST") failed
2025-06-27 05:17:27.706 E Statement : select id from test order by id with lock skip locked
2025-06-27 05:17:27.715 E Data source : Firebird::localhost:
2025-06-27 05:17:27.724 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-06-27 05:17:27.737 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-06-27 05:17:27.747 E -901
2025-06-27 05:17:27.754 E 335544926
2025-06-27 05:17:27.763 E 335544842
2025-06-27 05:17:27.773 E QUERY_TYPE = PSQL_REMOTE, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = NO_WAIT:
2025-06-27 05:17:27.785 E ID=2
2025-06-27 05:17:27.795 E ID=3
2025-06-27 05:17:27.802 E ID=4
2025-06-27 05:17:27.809 E ID=6
2025-06-27 05:17:27.815 E ID=7
2025-06-27 05:17:27.820 E ID=8
2025-06-27 05:17:27.825 E ID=10
2025-06-27 05:17:27.832 E QUERY_TYPE = PSQL_REMOTE, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = WAIT:
2025-06-27 05:17:27.837 E ID=2
2025-06-27 05:17:27.842 E ID=3
2025-06-27 05:17:27.854 E ID=4
2025-06-27 05:17:27.864 E ID=6
2025-06-27 05:17:27.873 E ID=7
2025-06-27 05:17:27.880 E ID=8
2025-06-27 05:17:27.886 E ID=10
2025-06-27 05:17:27.892 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = NO_WAIT:
2025-06-27 05:17:27.897 E ID=2
2025-06-27 05:17:27.902 E ID=3
2025-06-27 05:17:27.908 E ID=4
2025-06-27 05:17:27.913 E ID=6
2025-06-27 05:17:27.919 E ID=7
2025-06-27 05:17:27.926 E ID=8
2025-06-27 05:17:27.933 E ID=10
2025-06-27 05:17:27.941 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = WAIT:
2025-06-27 05:17:27.947 E ID=2
2025-06-27 05:17:27.955 E ID=3
2025-06-27 05:17:27.964 E ID=4
2025-06-27 05:17:27.969 E ID=6
2025-06-27 05:17:27.979 E ID=7
2025-06-27 05:17:27.986 E ID=8
2025-06-27 05:17:27.996 E ID=10
2025-06-27 05:17:28.006 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
2025-06-27 05:17:28.013 E ID=2
2025-06-27 05:17:28.019 E ID=3
2025-06-27 05:17:28.025 E ID=4
2025-06-27 05:17:28.029 E ID=6
2025-06-27 05:17:28.034 E ID=7
2025-06-27 05:17:28.039 E ID=8
2025-06-27 05:17:28.044 E ID=10
2025-06-27 05:17:28.050 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
2025-06-27 05:17:28.058 E ID=2
2025-06-27 05:17:28.068 E ID=3
2025-06-27 05:17:28.073 E ID=4
2025-06-27 05:17:28.077 E ID=6
2025-06-27 05:17:28.082 E ID=7
2025-06-27 05:17:28.087 E ID=8
2025-06-27 05:17:28.092 E ID=10
2025-06-27 05:17:28.103 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
2025-06-27 05:17:28.110 E ID=2
2025-06-27 05:17:28.116 E ID=3
2025-06-27 05:17:28.122 E ID=4
2025-06-27 05:17:28.128 E ID=6
2025-06-27 05:17:28.135 E ID=7
2025-06-27 05:17:28.143 E ID=8
2025-06-27 05:17:28.156 E ID=10
2025-06-27 05:17:28.172 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
2025-06-27 05:17:28.180 E ID=2
2025-06-27 05:17:28.188 E ID=3
2025-06-27 05:17:28.194 E ID=4
2025-06-27 05:17:28.201 E ID=6
2025-06-27 05:17:28.205 E ID=7
2025-06-27 05:17:28.210 E ID=8
2025-06-27 05:17:28.214 E ID=10
2025-06-27 05:17:28.219
2025-06-27 05:17:28.224 tests/bugs/gh_7350_test.py:544: AssertionError
2025-06-27 05:17:28.229 ---------------------------- Captured stdout setup -----------------------------
2025-06-27 05:17:28.235 Creating db: localhost:/var/tmp/qa_2024/test_11535/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
|