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-07-01 05:53:55.119
2025-07-01 05:53:55.126 act = <firebird.qa.plugin.Action object at [hex]>
2025-07-01 05:53:55.136 capsys = <_pytest.capture.CaptureFixture object at [hex]>
2025-07-01 05:53:55.143
2025-07-01 05:53:55.155 @pytest.mark.es_eds
2025-07-01 05:53:55.165 @pytest.mark.version('>=5.0')
2025-07-01 05:53:55.173 def test_1(act: Action, capsys):
2025-07-01 05:53:55.180
2025-07-01 05:53:55.186 init_sql = f"""
2025-07-01 05:53:55.196 set term ^;
2025-07-01 05:53:55.205 recreate table test(id int primary key, f01 int)
2025-07-01 05:53:55.211 -- recreate global temporary table test(id int primary key, f01 int) on commit preserve rows
2025-07-01 05:53:55.220 ^
2025-07-01 05:53:55.229 create or alter procedure sp_get_unlocked_rows_local returns(id int) as
2025-07-01 05:53:55.236 begin
2025-07-01 05:53:55.243 for
2025-07-01 05:53:55.252 {CHECK_SQL}
2025-07-01 05:53:55.262 into id
2025-07-01 05:53:55.270 do
2025-07-01 05:53:55.277 suspend;
2025-07-01 05:53:55.288 end
2025-07-01 05:53:55.299 ^
2025-07-01 05:53:55.307 create or alter procedure sp_get_unlocked_rows_remote returns(id int) as
2025-07-01 05:53:55.318 begin
2025-07-01 05:53:55.326 for
2025-07-01 05:53:55.333 execute statement '{CHECK_SQL}'
2025-07-01 05:53:55.344 on external 'localhost:' || rdb$get_context('SYSTEM', 'DB_NAME')
2025-07-01 05:53:55.356 as user '{act.db.user}' password '{act.db.password}'
2025-07-01 05:53:55.369 into id
2025-07-01 05:53:55.381 do
2025-07-01 05:53:55.394 suspend;
2025-07-01 05:53:55.405 end
2025-07-01 05:53:55.417 ^
2025-07-01 05:53:55.430 set term ;^
2025-07-01 05:53:55.441 commit;
2025-07-01 05:53:55.451
2025-07-01 05:53:55.462 insert into test(id, f01) select row_number()over(), 0 from rdb$types rows 10;
2025-07-01 05:53:55.474 commit;
2025-07-01 05:53:55.485 """
2025-07-01 05:53:55.493 act.isql(switches=['-q'], input = init_sql, combine_output = True)
2025-07-01 05:53:55.506 assert act.clean_stdout == ''
2025-07-01 05:53:55.516 act.reset()
2025-07-01 05:53:55.525
2025-07-01 05:53:55.535 tpb_isol_set = (Isolation.SERIALIZABLE, Isolation.SNAPSHOT, Isolation.READ_COMMITTED_READ_CONSISTENCY, Isolation.READ_COMMITTED_RECORD_VERSION, Isolation.READ_COMMITTED_NO_RECORD_VERSION)
2025-07-01 05:53:55.543 tpb_wait_set = (TraLockResolution.NO_WAIT,TraLockResolution.WAIT)
2025-07-01 05:53:55.550 tpb_mode_set = (TraAccessMode.READ, TraAccessMode.WRITE)
2025-07-01 05:53:55.557 query_types_set = ('DSQL', 'PSQL_LOCAL', 'PSQL_REMOTE')
2025-07-01 05:53:55.570
2025-07-01 05:53:55.581 with act.db.connect() as con_rows_locker, act.db.connect() as con_free_seeker:
2025-07-01 05:53:55.589 con_rows_locker.execute_immediate('update test set f01 = 1 where id in (1,5,9)')
2025-07-01 05:53:55.600 for query_type in query_types_set:
2025-07-01 05:53:55.608 for x_mode in tpb_mode_set:
2025-07-01 05:53:55.614 for x_isol in tpb_isol_set:
2025-07-01 05:53:55.620 for x_wait in tpb_wait_set:
2025-07-01 05:53:55.627 skip_flag = x_isol in (Isolation.SERIALIZABLE,) and x_wait == TraLockResolution.WAIT
2025-07-01 05:53:55.635 if skip_flag:
2025-07-01 05:53:55.642
2025-07-01 05:53:55.648 #######################################
2025-07-01 05:53:55.655 ### D O N O T C H E C K ###
2025-07-01 05:53:55.663 #######################################
2025-07-01 05:53:55.669 #
2025-07-01 05:53:55.676 # 1. Isolation.SERIALIZABLE requires that the whole table must not be changed by anyone else.
2025-07-01 05:53:55.683 # 2. [WAS ACTUAL BEFORE GH-7810 FIXED; CURRENTLY REMAINS NEEDED FB 5.X]
2025-07-01 05:53:55.693 # Isolation.READ_COMMITTED_NO_RECORD_VERSION can not be used due to implementation details, see:
2025-07-01 05:53:55.706 # Adriano, 26-feb-2023, https://github.com/FirebirdSQL/firebird/pull/7350#issuecomment-1445408462
2025-07-01 05:53:55.713 # "WITH LOCK [SKIP LOCKED] needs a record read before, but this locked records cannot be read with NO RECORD VERSION.
2025-07-01 05:53:55.720 # Considering that this transaction mode is replaced by default I would only document it as in fact I don't think
2025-07-01 05:53:55.725 # there are anything we could do."
2025-07-01 05:53:55.731
2025-07-01 05:53:55.737 continue
2025-07-01 05:53:55.742
2025-07-01 05:53:55.748 custom_tpb = tpb(isolation = x_isol, access_mode = x_mode, lock_timeout = -1 if x_wait == TraLockResolution.WAIT else 0)
2025-07-01 05:53:55.754 #custom_tpb = TPB(isolation = x_isol, access_mode = x_mode, lock_timeout = 0).get_buffer()
2025-07-01 05:53:55.760 tx_free_seeker = con_free_seeker.transaction_manager(custom_tpb)
2025-07-01 05:53:55.766 cur_free_seeker = tx_free_seeker.cursor()
2025-07-01 05:53:55.772 tx_free_seeker.begin()
2025-07-01 05:53:55.778 try:
2025-07-01 05:53:55.788 print('\n')
2025-07-01 05:53:55.798 print(f'QUERY_TYPE = {query_type}, TIL = {x_isol.name}, ACCESS = {x_mode.name}, WAIT = {x_wait.name}:')
2025-07-01 05:53:55.806 if query_type == 'DSQL':
2025-07-01 05:53:55.817 cur_free_seeker.execute(f'{CHECK_SQL}')
2025-07-01 05:53:55.829 elif query_type == 'PSQL_LOCAL':
2025-07-01 05:53:55.840 cur_free_seeker.execute('select id from sp_get_unlocked_rows_local')
2025-07-01 05:53:55.851 elif query_type == 'PSQL_REMOTE':
2025-07-01 05:53:55.861 cur_free_seeker.execute('select id from sp_get_unlocked_rows_remote')
2025-07-01 05:53:55.871 for r in cur_free_seeker:
2025-07-01 05:53:55.878 print('ID='+str(r[0]))
2025-07-01 05:53:55.886 except DatabaseError as e:
2025-07-01 05:53:55.893 print(e.__str__())
2025-07-01 05:53:55.899 print(e.sqlcode)
2025-07-01 05:53:55.905 for g in e.gds_codes:
2025-07-01 05:53:55.911 print(g)
2025-07-01 05:53:55.916 finally:
2025-07-01 05:53:55.922 tx_free_seeker.rollback()
2025-07-01 05:53:55.931
2025-07-01 05:53:55.939 act.expected_stdout = expected_stdout
2025-07-01 05:53:55.951 act.stdout = capsys.readouterr().out
2025-07-01 05:53:55.960 > assert act.clean_stdout == act.clean_expected_stdout
2025-07-01 05:53:55.967 E assert
2025-07-01 05:53:55.974 E QUERY_TYPE = DSQL, TIL = SERIALIZABLE, ACCESS = READ, WAIT = NO_WAIT:
2025-07-01 05:53:55.981 E lock conflict on no wait transaction
2025-07-01 05:53:55.987 E - -Acquire lock for relation (TEST) failed
2025-07-01 05:53:55.992 E + -Acquire lock for relation ("PUBLIC"."TEST") failed
2025-07-01 05:53:56.004 E -901
2025-07-01 05:53:56.010 E 335544345
2025-07-01 05:53:56.015 E 335544382
2025-07-01 05:53:56.021 E QUERY_TYPE = DSQL, TIL = SNAPSHOT, ACCESS = READ, WAIT = NO_WAIT:
2025-07-01 05:53:56.026 E attempted update during read-only transaction
2025-07-01 05:53:56.032 E -817
2025-07-01 05:53:56.038 E 335544361
2025-07-01 05:53:56.044 E QUERY_TYPE = DSQL, TIL = SNAPSHOT, ACCESS = READ, WAIT = WAIT:
2025-07-01 05:53:56.051 E attempted update during read-only transaction
2025-07-01 05:53:56.056 E -817
2025-07-01 05:53:56.062 E 335544361
2025-07-01 05:53:56.068 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = NO_WAIT:
2025-07-01 05:53:56.073 E attempted update during read-only transaction
2025-07-01 05:53:56.079 E -817
2025-07-01 05:53:56.084 E 335544361
2025-07-01 05:53:56.090 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = WAIT:
2025-07-01 05:53:56.096 E attempted update during read-only transaction
2025-07-01 05:53:56.101 E -817
2025-07-01 05:53:56.107 E 335544361
2025-07-01 05:53:56.120 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
2025-07-01 05:53:56.131 E attempted update during read-only transaction
2025-07-01 05:53:56.143 E -817
2025-07-01 05:53:56.154 E 335544361
2025-07-01 05:53:56.163 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
2025-07-01 05:53:56.171 E attempted update during read-only transaction
2025-07-01 05:53:56.179 E -817
2025-07-01 05:53:56.190 E 335544361
2025-07-01 05:53:56.199 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
2025-07-01 05:53:56.206 E attempted update during read-only transaction
2025-07-01 05:53:56.218 E -817
2025-07-01 05:53:56.227 E 335544361
2025-07-01 05:53:56.235 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
2025-07-01 05:53:56.242 E attempted update during read-only transaction
2025-07-01 05:53:56.248 E -817
2025-07-01 05:53:56.253 E 335544361
2025-07-01 05:53:56.259 E QUERY_TYPE = DSQL, TIL = SERIALIZABLE, ACCESS = WRITE, WAIT = NO_WAIT:
2025-07-01 05:53:56.268 E lock conflict on no wait transaction
2025-07-01 05:53:56.278 E - -Acquire lock for relation (TEST) failed
2025-07-01 05:53:56.286 E + -Acquire lock for relation ("PUBLIC"."TEST") failed
2025-07-01 05:53:56.308 E -901
2025-07-01 05:53:56.317 E 335544345
2025-07-01 05:53:56.324 E 335544382
2025-07-01 05:53:56.332 E QUERY_TYPE = DSQL, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = NO_WAIT:
2025-07-01 05:53:56.338 E ID=2
2025-07-01 05:53:56.344 E ID=3
2025-07-01 05:53:56.350 E ID=4
2025-07-01 05:53:56.355 E ID=6
2025-07-01 05:53:56.362 E ID=7
2025-07-01 05:53:56.373 E ID=8
2025-07-01 05:53:56.385 E ID=10
2025-07-01 05:53:56.396 E QUERY_TYPE = DSQL, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = WAIT:
2025-07-01 05:53:56.408 E ID=2
2025-07-01 05:53:56.420 E ID=3
2025-07-01 05:53:56.432 E ID=4
2025-07-01 05:53:56.444 E ID=6
2025-07-01 05:53:56.453 E ID=7
2025-07-01 05:53:56.461 E ID=8
2025-07-01 05:53:56.467 E ID=10
2025-07-01 05:53:56.474 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = NO_WAIT:
2025-07-01 05:53:56.480 E ID=2
2025-07-01 05:53:56.487 E ID=3
2025-07-01 05:53:56.497 E ID=4
2025-07-01 05:53:56.508 E ID=6
2025-07-01 05:53:56.519 E ID=7
2025-07-01 05:53:56.531 E ID=8
2025-07-01 05:53:56.543 E ID=10
2025-07-01 05:53:56.551 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = WAIT:
2025-07-01 05:53:56.557 E ID=2
2025-07-01 05:53:56.563 E ID=3
2025-07-01 05:53:56.569 E ID=4
2025-07-01 05:53:56.574 E ID=6
2025-07-01 05:53:56.583 E ID=7
2025-07-01 05:53:56.594 E ID=8
2025-07-01 05:53:56.602 E ID=10
2025-07-01 05:53:56.608 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
2025-07-01 05:53:56.614 E ID=2
2025-07-01 05:53:56.619 E ID=3
2025-07-01 05:53:56.624 E ID=4
2025-07-01 05:53:56.629 E ID=6
2025-07-01 05:53:56.634 E ID=7
2025-07-01 05:53:56.639 E ID=8
2025-07-01 05:53:56.645 E ID=10
2025-07-01 05:53:56.651 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
2025-07-01 05:53:56.658 E ID=2
2025-07-01 05:53:56.666 E ID=3
2025-07-01 05:53:56.672 E ID=4
2025-07-01 05:53:56.678 E ID=6
2025-07-01 05:53:56.685 E ID=7
2025-07-01 05:53:56.691 E ID=8
2025-07-01 05:53:56.697 E ID=10
2025-07-01 05:53:56.705 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
2025-07-01 05:53:56.711 E ID=2
2025-07-01 05:53:56.718 E ID=3
2025-07-01 05:53:56.727 E ID=4
2025-07-01 05:53:56.738 E ID=6
2025-07-01 05:53:56.745 E ID=7
2025-07-01 05:53:56.750 E ID=8
2025-07-01 05:53:56.756 E ID=10
2025-07-01 05:53:56.763 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
2025-07-01 05:53:56.772 E ID=2
2025-07-01 05:53:56.780 E ID=3
2025-07-01 05:53:56.787 E ID=4
2025-07-01 05:53:56.795 E ID=6
2025-07-01 05:53:56.805 E ID=7
2025-07-01 05:53:56.813 E ID=8
2025-07-01 05:53:56.819 E ID=10
2025-07-01 05:53:56.827 E QUERY_TYPE = PSQL_LOCAL, TIL = SERIALIZABLE, ACCESS = READ, WAIT = NO_WAIT:
2025-07-01 05:53:56.834 E lock conflict on no wait transaction
2025-07-01 05:53:56.843 E - -Acquire lock for relation (TEST) failed
2025-07-01 05:53:56.854 E + -Acquire lock for relation ("PUBLIC"."TEST") failed
2025-07-01 05:53:56.870 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-07-01 05:53:56.876 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-07-01 05:53:56.881 E -901
2025-07-01 05:53:56.885 E 335544345
2025-07-01 05:53:56.891 E 335544382
2025-07-01 05:53:56.897 E 335544842
2025-07-01 05:53:56.903 E QUERY_TYPE = PSQL_LOCAL, TIL = SNAPSHOT, ACCESS = READ, WAIT = NO_WAIT:
2025-07-01 05:53:56.909 E attempted update during read-only transaction
2025-07-01 05:53:56.917 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-07-01 05:53:56.923 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-07-01 05:53:56.929 E -817
2025-07-01 05:53:56.934 E 335544361
2025-07-01 05:53:56.941 E 335544842
2025-07-01 05:53:56.949 E QUERY_TYPE = PSQL_LOCAL, TIL = SNAPSHOT, ACCESS = READ, WAIT = WAIT:
2025-07-01 05:53:56.958 E attempted update during read-only transaction
2025-07-01 05:53:56.966 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-07-01 05:53:56.973 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-07-01 05:53:56.980 E -817
2025-07-01 05:53:56.987 E 335544361
2025-07-01 05:53:56.994 E 335544842
2025-07-01 05:53:57.003 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = NO_WAIT:
2025-07-01 05:53:57.010 E attempted update during read-only transaction
2025-07-01 05:53:57.018 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-07-01 05:53:57.026 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-07-01 05:53:57.033 E -817
2025-07-01 05:53:57.040 E 335544361
2025-07-01 05:53:57.044 E 335544842
2025-07-01 05:53:57.049 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = WAIT:
2025-07-01 05:53:57.054 E attempted update during read-only transaction
2025-07-01 05:53:57.059 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-07-01 05:53:57.064 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-07-01 05:53:57.068 E -817
2025-07-01 05:53:57.073 E 335544361
2025-07-01 05:53:57.078 E 335544842
2025-07-01 05:53:57.083 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
2025-07-01 05:53:57.087 E attempted update during read-only transaction
2025-07-01 05:53:57.092 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-07-01 05:53:57.096 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-07-01 05:53:57.100 E -817
2025-07-01 05:53:57.105 E 335544361
2025-07-01 05:53:57.109 E 335544842
2025-07-01 05:53:57.116 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
2025-07-01 05:53:57.122 E attempted update during read-only transaction
2025-07-01 05:53:57.129 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-07-01 05:53:57.138 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-07-01 05:53:57.147 E -817
2025-07-01 05:53:57.155 E 335544361
2025-07-01 05:53:57.162 E 335544842
2025-07-01 05:53:57.171 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
2025-07-01 05:53:57.177 E attempted update during read-only transaction
2025-07-01 05:53:57.182 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-07-01 05:53:57.187 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-07-01 05:53:57.192 E -817
2025-07-01 05:53:57.202 E 335544361
2025-07-01 05:53:57.211 E 335544842
2025-07-01 05:53:57.217 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
2025-07-01 05:53:57.223 E attempted update during read-only transaction
2025-07-01 05:53:57.227 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-07-01 05:53:57.232 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-07-01 05:53:57.237 E -817
2025-07-01 05:53:57.242 E 335544361
2025-07-01 05:53:57.246 E 335544842
2025-07-01 05:53:57.251 E QUERY_TYPE = PSQL_LOCAL, TIL = SERIALIZABLE, ACCESS = WRITE, WAIT = NO_WAIT:
2025-07-01 05:53:57.256 E lock conflict on no wait transaction
2025-07-01 05:53:57.261 E - -Acquire lock for relation (TEST) failed
2025-07-01 05:53:57.265 E + -Acquire lock for relation ("PUBLIC"."TEST") failed
2025-07-01 05:53:57.275 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-07-01 05:53:57.280 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-07-01 05:53:57.284 E -901
2025-07-01 05:53:57.290 E 335544345
2025-07-01 05:53:57.296 E 335544382
2025-07-01 05:53:57.301 E 335544842
2025-07-01 05:53:57.307 E QUERY_TYPE = PSQL_LOCAL, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = NO_WAIT:
2025-07-01 05:53:57.314 E ID=2
2025-07-01 05:53:57.320 E ID=3
2025-07-01 05:53:57.325 E ID=4
2025-07-01 05:53:57.331 E ID=6
2025-07-01 05:53:57.336 E ID=7
2025-07-01 05:53:57.342 E ID=8
2025-07-01 05:53:57.348 E ID=10
2025-07-01 05:53:57.354 E QUERY_TYPE = PSQL_LOCAL, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = WAIT:
2025-07-01 05:53:57.359 E ID=2
2025-07-01 05:53:57.367 E ID=3
2025-07-01 05:53:57.378 E ID=4
2025-07-01 05:53:57.386 E ID=6
2025-07-01 05:53:57.393 E ID=7
2025-07-01 05:53:57.399 E ID=8
2025-07-01 05:53:57.404 E ID=10
2025-07-01 05:53:57.410 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = NO_WAIT:
2025-07-01 05:53:57.416 E ID=2
2025-07-01 05:53:57.425 E ID=3
2025-07-01 05:53:57.433 E ID=4
2025-07-01 05:53:57.440 E ID=6
2025-07-01 05:53:57.445 E ID=7
2025-07-01 05:53:57.452 E ID=8
2025-07-01 05:53:57.458 E ID=10
2025-07-01 05:53:57.465 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = WAIT:
2025-07-01 05:53:57.472 E ID=2
2025-07-01 05:53:57.479 E ID=3
2025-07-01 05:53:57.487 E ID=4
2025-07-01 05:53:57.498 E ID=6
2025-07-01 05:53:57.508 E ID=7
2025-07-01 05:53:57.516 E ID=8
2025-07-01 05:53:57.528 E ID=10
2025-07-01 05:53:57.541 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
2025-07-01 05:53:57.552 E ID=2
2025-07-01 05:53:57.561 E ID=3
2025-07-01 05:53:57.568 E ID=4
2025-07-01 05:53:57.575 E ID=6
2025-07-01 05:53:57.587 E ID=7
2025-07-01 05:53:57.595 E ID=8
2025-07-01 05:53:57.604 E ID=10
2025-07-01 05:53:57.614 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
2025-07-01 05:53:57.622 E ID=2
2025-07-01 05:53:57.632 E ID=3
2025-07-01 05:53:57.638 E ID=4
2025-07-01 05:53:57.644 E ID=6
2025-07-01 05:53:57.650 E ID=7
2025-07-01 05:53:57.657 E ID=8
2025-07-01 05:53:57.663 E ID=10
2025-07-01 05:53:57.672 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
2025-07-01 05:53:57.682 E ID=2
2025-07-01 05:53:57.690 E ID=3
2025-07-01 05:53:57.699 E ID=4
2025-07-01 05:53:57.710 E ID=6
2025-07-01 05:53:57.719 E ID=7
2025-07-01 05:53:57.726 E ID=8
2025-07-01 05:53:57.734 E ID=10
2025-07-01 05:53:57.745 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
2025-07-01 05:53:57.759 E ID=2
2025-07-01 05:53:57.769 E ID=3
2025-07-01 05:53:57.777 E ID=4
2025-07-01 05:53:57.784 E ID=6
2025-07-01 05:53:57.790 E ID=7
2025-07-01 05:53:57.795 E ID=8
2025-07-01 05:53:57.802 E ID=10
2025-07-01 05:53:57.814 E QUERY_TYPE = PSQL_REMOTE, TIL = SERIALIZABLE, ACCESS = READ, WAIT = NO_WAIT:
2025-07-01 05:53:57.826 E Execute statement error at isc_dsql_fetch :
2025-07-01 05:53:57.840 E 335544345 : lock conflict on no wait transaction
2025-07-01 05:53:57.852 E - 335544382 : Acquire lock for relation (TEST) failed
2025-07-01 05:53:57.867 E + 335544382 : Acquire lock for relation ("PUBLIC"."TEST") failed
2025-07-01 05:53:57.883 E Statement : select id from test order by id with lock skip locked
2025-07-01 05:53:57.891 E Data source : Firebird::localhost:
2025-07-01 05:53:57.898 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-07-01 05:53:57.904 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-07-01 05:53:57.910 E -901
2025-07-01 05:53:57.914 E 335544926
2025-07-01 05:53:57.919 E 335544842
2025-07-01 05:53:57.925 E QUERY_TYPE = PSQL_REMOTE, TIL = SNAPSHOT, ACCESS = READ, WAIT = NO_WAIT:
2025-07-01 05:53:57.931 E Execute statement error at isc_dsql_fetch :
2025-07-01 05:53:57.936 E 335544361 : attempted update during read-only transaction
2025-07-01 05:53:57.941 E Statement : select id from test order by id with lock skip locked
2025-07-01 05:53:57.946 E Data source : Firebird::localhost:
2025-07-01 05:53:57.952 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-07-01 05:53:57.958 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-07-01 05:53:57.971 E -901
2025-07-01 05:53:57.979 E 335544926
2025-07-01 05:53:57.987 E 335544842
2025-07-01 05:53:57.994 E QUERY_TYPE = PSQL_REMOTE, TIL = SNAPSHOT, ACCESS = READ, WAIT = WAIT:
2025-07-01 05:53:58.004 E Execute statement error at isc_dsql_fetch :
2025-07-01 05:53:58.010 E 335544361 : attempted update during read-only transaction
2025-07-01 05:53:58.016 E Statement : select id from test order by id with lock skip locked
2025-07-01 05:53:58.022 E Data source : Firebird::localhost:
2025-07-01 05:53:58.033 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-07-01 05:53:58.043 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-07-01 05:53:58.051 E -901
2025-07-01 05:53:58.059 E 335544926
2025-07-01 05:53:58.070 E 335544842
2025-07-01 05:53:58.079 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = NO_WAIT:
2025-07-01 05:53:58.087 E Execute statement error at isc_dsql_fetch :
2025-07-01 05:53:58.100 E 335544361 : attempted update during read-only transaction
2025-07-01 05:53:58.112 E Statement : select id from test order by id with lock skip locked
2025-07-01 05:53:58.121 E Data source : Firebird::localhost:
2025-07-01 05:53:58.129 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-07-01 05:53:58.139 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-07-01 05:53:58.148 E -901
2025-07-01 05:53:58.157 E 335544926
2025-07-01 05:53:58.166 E 335544842
2025-07-01 05:53:58.171 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = WAIT:
2025-07-01 05:53:58.176 E Execute statement error at isc_dsql_fetch :
2025-07-01 05:53:58.182 E 335544361 : attempted update during read-only transaction
2025-07-01 05:53:58.189 E Statement : select id from test order by id with lock skip locked
2025-07-01 05:53:58.196 E Data source : Firebird::localhost:
2025-07-01 05:53:58.202 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-07-01 05:53:58.206 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-07-01 05:53:58.211 E -901
2025-07-01 05:53:58.216 E 335544926
2025-07-01 05:53:58.223 E 335544842
2025-07-01 05:53:58.231 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
2025-07-01 05:53:58.239 E Execute statement error at isc_dsql_fetch :
2025-07-01 05:53:58.248 E 335544361 : attempted update during read-only transaction
2025-07-01 05:53:58.259 E Statement : select id from test order by id with lock skip locked
2025-07-01 05:53:58.268 E Data source : Firebird::localhost:
2025-07-01 05:53:58.276 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-07-01 05:53:58.283 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-07-01 05:53:58.289 E -901
2025-07-01 05:53:58.301 E 335544926
2025-07-01 05:53:58.312 E 335544842
2025-07-01 05:53:58.323 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
2025-07-01 05:53:58.335 E Execute statement error at isc_dsql_fetch :
2025-07-01 05:53:58.348 E 335544361 : attempted update during read-only transaction
2025-07-01 05:53:58.356 E Statement : select id from test order by id with lock skip locked
2025-07-01 05:53:58.362 E Data source : Firebird::localhost:
2025-07-01 05:53:58.374 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-07-01 05:53:58.384 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-07-01 05:53:58.393 E -901
2025-07-01 05:53:58.403 E 335544926
2025-07-01 05:53:58.415 E 335544842
2025-07-01 05:53:58.424 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
2025-07-01 05:53:58.433 E Execute statement error at isc_dsql_fetch :
2025-07-01 05:53:58.445 E 335544361 : attempted update during read-only transaction
2025-07-01 05:53:58.459 E Statement : select id from test order by id with lock skip locked
2025-07-01 05:53:58.472 E Data source : Firebird::localhost:
2025-07-01 05:53:58.480 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-07-01 05:53:58.486 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-07-01 05:53:58.492 E -901
2025-07-01 05:53:58.497 E 335544926
2025-07-01 05:53:58.503 E 335544842
2025-07-01 05:53:58.509 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
2025-07-01 05:53:58.514 E Execute statement error at isc_dsql_fetch :
2025-07-01 05:53:58.522 E 335544361 : attempted update during read-only transaction
2025-07-01 05:53:58.531 E Statement : select id from test order by id with lock skip locked
2025-07-01 05:53:58.537 E Data source : Firebird::localhost:
2025-07-01 05:53:58.543 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-07-01 05:53:58.550 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-07-01 05:53:58.556 E -901
2025-07-01 05:53:58.561 E 335544926
2025-07-01 05:53:58.571 E 335544842
2025-07-01 05:53:58.582 E QUERY_TYPE = PSQL_REMOTE, TIL = SERIALIZABLE, ACCESS = WRITE, WAIT = NO_WAIT:
2025-07-01 05:53:58.593 E Execute statement error at isc_dsql_fetch :
2025-07-01 05:53:58.606 E 335544345 : lock conflict on no wait transaction
2025-07-01 05:53:58.616 E - 335544382 : Acquire lock for relation (TEST) failed
2025-07-01 05:53:58.624 E + 335544382 : Acquire lock for relation ("PUBLIC"."TEST") failed
2025-07-01 05:53:58.638 E Statement : select id from test order by id with lock skip locked
2025-07-01 05:53:58.649 E Data source : Firebird::localhost:
2025-07-01 05:53:58.659 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-07-01 05:53:58.669 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-07-01 05:53:58.676 E -901
2025-07-01 05:53:58.686 E 335544926
2025-07-01 05:53:58.698 E 335544842
2025-07-01 05:53:58.710 E QUERY_TYPE = PSQL_REMOTE, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = NO_WAIT:
2025-07-01 05:53:58.718 E ID=2
2025-07-01 05:53:58.724 E ID=3
2025-07-01 05:53:58.729 E ID=4
2025-07-01 05:53:58.734 E ID=6
2025-07-01 05:53:58.739 E ID=7
2025-07-01 05:53:58.743 E ID=8
2025-07-01 05:53:58.751 E ID=10
2025-07-01 05:53:58.761 E QUERY_TYPE = PSQL_REMOTE, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = WAIT:
2025-07-01 05:53:58.771 E ID=2
2025-07-01 05:53:58.782 E ID=3
2025-07-01 05:53:58.793 E ID=4
2025-07-01 05:53:58.803 E ID=6
2025-07-01 05:53:58.811 E ID=7
2025-07-01 05:53:58.818 E ID=8
2025-07-01 05:53:58.829 E ID=10
2025-07-01 05:53:58.839 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = NO_WAIT:
2025-07-01 05:53:58.847 E ID=2
2025-07-01 05:53:58.855 E ID=3
2025-07-01 05:53:58.863 E ID=4
2025-07-01 05:53:58.874 E ID=6
2025-07-01 05:53:58.883 E ID=7
2025-07-01 05:53:58.892 E ID=8
2025-07-01 05:53:58.903 E ID=10
2025-07-01 05:53:58.910 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = WAIT:
2025-07-01 05:53:58.916 E ID=2
2025-07-01 05:53:58.922 E ID=3
2025-07-01 05:53:58.928 E ID=4
2025-07-01 05:53:58.935 E ID=6
2025-07-01 05:53:58.944 E ID=7
2025-07-01 05:53:58.954 E ID=8
2025-07-01 05:53:58.961 E ID=10
2025-07-01 05:53:58.968 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
2025-07-01 05:53:58.975 E ID=2
2025-07-01 05:53:58.983 E ID=3
2025-07-01 05:53:58.995 E ID=4
2025-07-01 05:53:59.005 E ID=6
2025-07-01 05:53:59.012 E ID=7
2025-07-01 05:53:59.018 E ID=8
2025-07-01 05:53:59.023 E ID=10
2025-07-01 05:53:59.030 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
2025-07-01 05:53:59.036 E ID=2
2025-07-01 05:53:59.041 E ID=3
2025-07-01 05:53:59.049 E ID=4
2025-07-01 05:53:59.055 E ID=6
2025-07-01 05:53:59.061 E ID=7
2025-07-01 05:53:59.067 E ID=8
2025-07-01 05:53:59.073 E ID=10
2025-07-01 05:53:59.079 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
2025-07-01 05:53:59.084 E ID=2
2025-07-01 05:53:59.093 E ID=3
2025-07-01 05:53:59.105 E ID=4
2025-07-01 05:53:59.116 E ID=6
2025-07-01 05:53:59.130 E ID=7
2025-07-01 05:53:59.138 E ID=8
2025-07-01 05:53:59.147 E ID=10
2025-07-01 05:53:59.154 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
2025-07-01 05:53:59.160 E ID=2
2025-07-01 05:53:59.167 E ID=3
2025-07-01 05:53:59.175 E ID=4
2025-07-01 05:53:59.183 E ID=6
2025-07-01 05:53:59.193 E ID=7
2025-07-01 05:53:59.204 E ID=8
2025-07-01 05:53:59.216 E ID=10
2025-07-01 05:53:59.225
2025-07-01 05:53:59.235 tests/bugs/gh_7350_test.py:544: AssertionError
2025-07-01 05:53:59.247 ---------------------------- Captured stdout setup -----------------------------
2025-07-01 05:53:59.255 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
|