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-03 05:18:40.491
2025-07-03 05:18:40.496 act = <firebird.qa.plugin.Action object at [hex]>
2025-07-03 05:18:40.502 capsys = <_pytest.capture.CaptureFixture object at [hex]>
2025-07-03 05:18:40.508
2025-07-03 05:18:40.513 @pytest.mark.es_eds
2025-07-03 05:18:40.519 @pytest.mark.version('>=5.0')
2025-07-03 05:18:40.525 def test_1(act: Action, capsys):
2025-07-03 05:18:40.530
2025-07-03 05:18:40.535 init_sql = f"""
2025-07-03 05:18:40.541 set term ^;
2025-07-03 05:18:40.547 recreate table test(id int primary key, f01 int)
2025-07-03 05:18:40.553 -- recreate global temporary table test(id int primary key, f01 int) on commit preserve rows
2025-07-03 05:18:40.558 ^
2025-07-03 05:18:40.564 create or alter procedure sp_get_unlocked_rows_local returns(id int) as
2025-07-03 05:18:40.570 begin
2025-07-03 05:18:40.576 for
2025-07-03 05:18:40.581 {CHECK_SQL}
2025-07-03 05:18:40.586 into id
2025-07-03 05:18:40.594 do
2025-07-03 05:18:40.601 suspend;
2025-07-03 05:18:40.608 end
2025-07-03 05:18:40.615 ^
2025-07-03 05:18:40.621 create or alter procedure sp_get_unlocked_rows_remote returns(id int) as
2025-07-03 05:18:40.627 begin
2025-07-03 05:18:40.633 for
2025-07-03 05:18:40.638 execute statement '{CHECK_SQL}'
2025-07-03 05:18:40.642 on external 'localhost:' || rdb$get_context('SYSTEM', 'DB_NAME')
2025-07-03 05:18:40.647 as user '{act.db.user}' password '{act.db.password}'
2025-07-03 05:18:40.652 into id
2025-07-03 05:18:40.657 do
2025-07-03 05:18:40.662 suspend;
2025-07-03 05:18:40.668 end
2025-07-03 05:18:40.673 ^
2025-07-03 05:18:40.679 set term ;^
2025-07-03 05:18:40.685 commit;
2025-07-03 05:18:40.690
2025-07-03 05:18:40.701 insert into test(id, f01) select row_number()over(), 0 from rdb$types rows 10;
2025-07-03 05:18:40.713 commit;
2025-07-03 05:18:40.723 """
2025-07-03 05:18:40.732 act.isql(switches=['-q'], input = init_sql, combine_output = True)
2025-07-03 05:18:40.738 assert act.clean_stdout == ''
2025-07-03 05:18:40.749 act.reset()
2025-07-03 05:18:40.758
2025-07-03 05:18:40.765 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-03 05:18:40.772 tpb_wait_set = (TraLockResolution.NO_WAIT,TraLockResolution.WAIT)
2025-07-03 05:18:40.778 tpb_mode_set = (TraAccessMode.READ, TraAccessMode.WRITE)
2025-07-03 05:18:40.785 query_types_set = ('DSQL', 'PSQL_LOCAL', 'PSQL_REMOTE')
2025-07-03 05:18:40.793
2025-07-03 05:18:40.805 with act.db.connect() as con_rows_locker, act.db.connect() as con_free_seeker:
2025-07-03 05:18:40.817 con_rows_locker.execute_immediate('update test set f01 = 1 where id in (1,5,9)')
2025-07-03 05:18:40.828 for query_type in query_types_set:
2025-07-03 05:18:40.843 for x_mode in tpb_mode_set:
2025-07-03 05:18:40.854 for x_isol in tpb_isol_set:
2025-07-03 05:18:40.862 for x_wait in tpb_wait_set:
2025-07-03 05:18:40.870 skip_flag = x_isol in (Isolation.SERIALIZABLE,) and x_wait == TraLockResolution.WAIT
2025-07-03 05:18:40.878 if skip_flag:
2025-07-03 05:18:40.885
2025-07-03 05:18:40.891 #######################################
2025-07-03 05:18:40.898 ### D O N O T C H E C K ###
2025-07-03 05:18:40.904 #######################################
2025-07-03 05:18:40.910 #
2025-07-03 05:18:40.919 # 1. Isolation.SERIALIZABLE requires that the whole table must not be changed by anyone else.
2025-07-03 05:18:40.927 # 2. [WAS ACTUAL BEFORE GH-7810 FIXED; CURRENTLY REMAINS NEEDED FB 5.X]
2025-07-03 05:18:40.934 # Isolation.READ_COMMITTED_NO_RECORD_VERSION can not be used due to implementation details, see:
2025-07-03 05:18:40.941 # Adriano, 26-feb-2023, https://github.com/FirebirdSQL/firebird/pull/7350#issuecomment-1445408462
2025-07-03 05:18:40.949 # "WITH LOCK [SKIP LOCKED] needs a record read before, but this locked records cannot be read with NO RECORD VERSION.
2025-07-03 05:18:40.957 # Considering that this transaction mode is replaced by default I would only document it as in fact I don't think
2025-07-03 05:18:40.963 # there are anything we could do."
2025-07-03 05:18:40.968
2025-07-03 05:18:40.974 continue
2025-07-03 05:18:40.980
2025-07-03 05:18:40.992 custom_tpb = tpb(isolation = x_isol, access_mode = x_mode, lock_timeout = -1 if x_wait == TraLockResolution.WAIT else 0)
2025-07-03 05:18:41.003 #custom_tpb = TPB(isolation = x_isol, access_mode = x_mode, lock_timeout = 0).get_buffer()
2025-07-03 05:18:41.010 tx_free_seeker = con_free_seeker.transaction_manager(custom_tpb)
2025-07-03 05:18:41.019 cur_free_seeker = tx_free_seeker.cursor()
2025-07-03 05:18:41.030 tx_free_seeker.begin()
2025-07-03 05:18:41.039 try:
2025-07-03 05:18:41.046 print('\n')
2025-07-03 05:18:41.057 print(f'QUERY_TYPE = {query_type}, TIL = {x_isol.name}, ACCESS = {x_mode.name}, WAIT = {x_wait.name}:')
2025-07-03 05:18:41.066 if query_type == 'DSQL':
2025-07-03 05:18:41.075 cur_free_seeker.execute(f'{CHECK_SQL}')
2025-07-03 05:18:41.089 elif query_type == 'PSQL_LOCAL':
2025-07-03 05:18:41.098 cur_free_seeker.execute('select id from sp_get_unlocked_rows_local')
2025-07-03 05:18:41.105 elif query_type == 'PSQL_REMOTE':
2025-07-03 05:18:41.117 cur_free_seeker.execute('select id from sp_get_unlocked_rows_remote')
2025-07-03 05:18:41.126 for r in cur_free_seeker:
2025-07-03 05:18:41.134 print('ID='+str(r[0]))
2025-07-03 05:18:41.141 except DatabaseError as e:
2025-07-03 05:18:41.147 print(e.__str__())
2025-07-03 05:18:41.152 print(e.sqlcode)
2025-07-03 05:18:41.158 for g in e.gds_codes:
2025-07-03 05:18:41.164 print(g)
2025-07-03 05:18:41.170 finally:
2025-07-03 05:18:41.176 tx_free_seeker.rollback()
2025-07-03 05:18:41.182
2025-07-03 05:18:41.187 act.expected_stdout = expected_stdout
2025-07-03 05:18:41.194 act.stdout = capsys.readouterr().out
2025-07-03 05:18:41.200 > assert act.clean_stdout == act.clean_expected_stdout
2025-07-03 05:18:41.205 E assert
2025-07-03 05:18:41.211 E QUERY_TYPE = DSQL, TIL = SERIALIZABLE, ACCESS = READ, WAIT = NO_WAIT:
2025-07-03 05:18:41.217 E lock conflict on no wait transaction
2025-07-03 05:18:41.223 E - -Acquire lock for relation (TEST) failed
2025-07-03 05:18:41.231 E + -Acquire lock for relation ("PUBLIC"."TEST") failed
2025-07-03 05:18:41.252 E -901
2025-07-03 05:18:41.260 E 335544345
2025-07-03 05:18:41.266 E 335544382
2025-07-03 05:18:41.271 E QUERY_TYPE = DSQL, TIL = SNAPSHOT, ACCESS = READ, WAIT = NO_WAIT:
2025-07-03 05:18:41.276 E attempted update during read-only transaction
2025-07-03 05:18:41.281 E -817
2025-07-03 05:18:41.286 E 335544361
2025-07-03 05:18:41.294 E QUERY_TYPE = DSQL, TIL = SNAPSHOT, ACCESS = READ, WAIT = WAIT:
2025-07-03 05:18:41.303 E attempted update during read-only transaction
2025-07-03 05:18:41.309 E -817
2025-07-03 05:18:41.314 E 335544361
2025-07-03 05:18:41.327 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = NO_WAIT:
2025-07-03 05:18:41.337 E attempted update during read-only transaction
2025-07-03 05:18:41.345 E -817
2025-07-03 05:18:41.352 E 335544361
2025-07-03 05:18:41.358 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = WAIT:
2025-07-03 05:18:41.363 E attempted update during read-only transaction
2025-07-03 05:18:41.369 E -817
2025-07-03 05:18:41.374 E 335544361
2025-07-03 05:18:41.380 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
2025-07-03 05:18:41.386 E attempted update during read-only transaction
2025-07-03 05:18:41.393 E -817
2025-07-03 05:18:41.402 E 335544361
2025-07-03 05:18:41.416 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
2025-07-03 05:18:41.424 E attempted update during read-only transaction
2025-07-03 05:18:41.431 E -817
2025-07-03 05:18:41.438 E 335544361
2025-07-03 05:18:41.445 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
2025-07-03 05:18:41.452 E attempted update during read-only transaction
2025-07-03 05:18:41.459 E -817
2025-07-03 05:18:41.465 E 335544361
2025-07-03 05:18:41.470 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
2025-07-03 05:18:41.475 E attempted update during read-only transaction
2025-07-03 05:18:41.480 E -817
2025-07-03 05:18:41.484 E 335544361
2025-07-03 05:18:41.489 E QUERY_TYPE = DSQL, TIL = SERIALIZABLE, ACCESS = WRITE, WAIT = NO_WAIT:
2025-07-03 05:18:41.494 E lock conflict on no wait transaction
2025-07-03 05:18:41.498 E - -Acquire lock for relation (TEST) failed
2025-07-03 05:18:41.504 E + -Acquire lock for relation ("PUBLIC"."TEST") failed
2025-07-03 05:18:41.515 E -901
2025-07-03 05:18:41.523 E 335544345
2025-07-03 05:18:41.536 E 335544382
2025-07-03 05:18:41.544 E QUERY_TYPE = DSQL, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = NO_WAIT:
2025-07-03 05:18:41.551 E ID=2
2025-07-03 05:18:41.558 E ID=3
2025-07-03 05:18:41.567 E ID=4
2025-07-03 05:18:41.575 E ID=6
2025-07-03 05:18:41.583 E ID=7
2025-07-03 05:18:41.589 E ID=8
2025-07-03 05:18:41.597 E ID=10
2025-07-03 05:18:41.603 E QUERY_TYPE = DSQL, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = WAIT:
2025-07-03 05:18:41.610 E ID=2
2025-07-03 05:18:41.614 E ID=3
2025-07-03 05:18:41.620 E ID=4
2025-07-03 05:18:41.627 E ID=6
2025-07-03 05:18:41.638 E ID=7
2025-07-03 05:18:41.647 E ID=8
2025-07-03 05:18:41.655 E ID=10
2025-07-03 05:18:41.662 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = NO_WAIT:
2025-07-03 05:18:41.668 E ID=2
2025-07-03 05:18:41.675 E ID=3
2025-07-03 05:18:41.682 E ID=4
2025-07-03 05:18:41.689 E ID=6
2025-07-03 05:18:41.696 E ID=7
2025-07-03 05:18:41.703 E ID=8
2025-07-03 05:18:41.711 E ID=10
2025-07-03 05:18:41.724 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = WAIT:
2025-07-03 05:18:41.734 E ID=2
2025-07-03 05:18:41.744 E ID=3
2025-07-03 05:18:41.751 E ID=4
2025-07-03 05:18:41.759 E ID=6
2025-07-03 05:18:41.767 E ID=7
2025-07-03 05:18:41.773 E ID=8
2025-07-03 05:18:41.780 E ID=10
2025-07-03 05:18:41.787 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
2025-07-03 05:18:41.794 E ID=2
2025-07-03 05:18:41.805 E ID=3
2025-07-03 05:18:41.815 E ID=4
2025-07-03 05:18:41.823 E ID=6
2025-07-03 05:18:41.831 E ID=7
2025-07-03 05:18:41.839 E ID=8
2025-07-03 05:18:41.850 E ID=10
2025-07-03 05:18:41.859 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
2025-07-03 05:18:41.871 E ID=2
2025-07-03 05:18:41.881 E ID=3
2025-07-03 05:18:41.891 E ID=4
2025-07-03 05:18:41.903 E ID=6
2025-07-03 05:18:41.916 E ID=7
2025-07-03 05:18:41.925 E ID=8
2025-07-03 05:18:41.938 E ID=10
2025-07-03 05:18:41.946 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
2025-07-03 05:18:41.954 E ID=2
2025-07-03 05:18:41.963 E ID=3
2025-07-03 05:18:41.975 E ID=4
2025-07-03 05:18:41.985 E ID=6
2025-07-03 05:18:41.997 E ID=7
2025-07-03 05:18:42.007 E ID=8
2025-07-03 05:18:42.015 E ID=10
2025-07-03 05:18:42.022 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
2025-07-03 05:18:42.033 E ID=2
2025-07-03 05:18:42.045 E ID=3
2025-07-03 05:18:42.055 E ID=4
2025-07-03 05:18:42.062 E ID=6
2025-07-03 05:18:42.069 E ID=7
2025-07-03 05:18:42.075 E ID=8
2025-07-03 05:18:42.083 E ID=10
2025-07-03 05:18:42.091 E QUERY_TYPE = PSQL_LOCAL, TIL = SERIALIZABLE, ACCESS = READ, WAIT = NO_WAIT:
2025-07-03 05:18:42.098 E lock conflict on no wait transaction
2025-07-03 05:18:42.104 E - -Acquire lock for relation (TEST) failed
2025-07-03 05:18:42.112 E + -Acquire lock for relation ("PUBLIC"."TEST") failed
2025-07-03 05:18:42.126 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-07-03 05:18:42.131 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-07-03 05:18:42.140 E -901
2025-07-03 05:18:42.147 E 335544345
2025-07-03 05:18:42.155 E 335544382
2025-07-03 05:18:42.165 E 335544842
2025-07-03 05:18:42.176 E QUERY_TYPE = PSQL_LOCAL, TIL = SNAPSHOT, ACCESS = READ, WAIT = NO_WAIT:
2025-07-03 05:18:42.185 E attempted update during read-only transaction
2025-07-03 05:18:42.193 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-07-03 05:18:42.200 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-07-03 05:18:42.206 E -817
2025-07-03 05:18:42.212 E 335544361
2025-07-03 05:18:42.217 E 335544842
2025-07-03 05:18:42.222 E QUERY_TYPE = PSQL_LOCAL, TIL = SNAPSHOT, ACCESS = READ, WAIT = WAIT:
2025-07-03 05:18:42.227 E attempted update during read-only transaction
2025-07-03 05:18:42.233 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-07-03 05:18:42.239 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-07-03 05:18:42.246 E -817
2025-07-03 05:18:42.252 E 335544361
2025-07-03 05:18:42.258 E 335544842
2025-07-03 05:18:42.265 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = NO_WAIT:
2025-07-03 05:18:42.277 E attempted update during read-only transaction
2025-07-03 05:18:42.286 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-07-03 05:18:42.292 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-07-03 05:18:42.298 E -817
2025-07-03 05:18:42.304 E 335544361
2025-07-03 05:18:42.310 E 335544842
2025-07-03 05:18:42.316 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = WAIT:
2025-07-03 05:18:42.323 E attempted update during read-only transaction
2025-07-03 05:18:42.337 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-07-03 05:18:42.348 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-07-03 05:18:42.358 E -817
2025-07-03 05:18:42.370 E 335544361
2025-07-03 05:18:42.381 E 335544842
2025-07-03 05:18:42.393 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
2025-07-03 05:18:42.403 E attempted update during read-only transaction
2025-07-03 05:18:42.412 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-07-03 05:18:42.424 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-07-03 05:18:42.437 E -817
2025-07-03 05:18:42.447 E 335544361
2025-07-03 05:18:42.455 E 335544842
2025-07-03 05:18:42.462 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
2025-07-03 05:18:42.474 E attempted update during read-only transaction
2025-07-03 05:18:42.483 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-07-03 05:18:42.490 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-07-03 05:18:42.499 E -817
2025-07-03 05:18:42.509 E 335544361
2025-07-03 05:18:42.517 E 335544842
2025-07-03 05:18:42.524 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
2025-07-03 05:18:42.530 E attempted update during read-only transaction
2025-07-03 05:18:42.538 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-07-03 05:18:42.546 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-07-03 05:18:42.552 E -817
2025-07-03 05:18:42.558 E 335544361
2025-07-03 05:18:42.563 E 335544842
2025-07-03 05:18:42.569 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
2025-07-03 05:18:42.574 E attempted update during read-only transaction
2025-07-03 05:18:42.579 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-07-03 05:18:42.585 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-07-03 05:18:42.590 E -817
2025-07-03 05:18:42.601 E 335544361
2025-07-03 05:18:42.611 E 335544842
2025-07-03 05:18:42.620 E QUERY_TYPE = PSQL_LOCAL, TIL = SERIALIZABLE, ACCESS = WRITE, WAIT = NO_WAIT:
2025-07-03 05:18:42.627 E lock conflict on no wait transaction
2025-07-03 05:18:42.634 E - -Acquire lock for relation (TEST) failed
2025-07-03 05:18:42.645 E + -Acquire lock for relation ("PUBLIC"."TEST") failed
2025-07-03 05:18:42.659 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-07-03 05:18:42.669 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-07-03 05:18:42.679 E -901
2025-07-03 05:18:42.685 E 335544345
2025-07-03 05:18:42.695 E 335544382
2025-07-03 05:18:42.703 E 335544842
2025-07-03 05:18:42.710 E QUERY_TYPE = PSQL_LOCAL, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = NO_WAIT:
2025-07-03 05:18:42.717 E ID=2
2025-07-03 05:18:42.722 E ID=3
2025-07-03 05:18:42.732 E ID=4
2025-07-03 05:18:42.742 E ID=6
2025-07-03 05:18:42.753 E ID=7
2025-07-03 05:18:42.763 E ID=8
2025-07-03 05:18:42.770 E ID=10
2025-07-03 05:18:42.778 E QUERY_TYPE = PSQL_LOCAL, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = WAIT:
2025-07-03 05:18:42.790 E ID=2
2025-07-03 05:18:42.800 E ID=3
2025-07-03 05:18:42.810 E ID=4
2025-07-03 05:18:42.819 E ID=6
2025-07-03 05:18:42.826 E ID=7
2025-07-03 05:18:42.836 E ID=8
2025-07-03 05:18:42.844 E ID=10
2025-07-03 05:18:42.852 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = NO_WAIT:
2025-07-03 05:18:42.859 E ID=2
2025-07-03 05:18:42.864 E ID=3
2025-07-03 05:18:42.870 E ID=4
2025-07-03 05:18:42.880 E ID=6
2025-07-03 05:18:42.891 E ID=7
2025-07-03 05:18:42.902 E ID=8
2025-07-03 05:18:42.913 E ID=10
2025-07-03 05:18:42.924 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = WAIT:
2025-07-03 05:18:42.933 E ID=2
2025-07-03 05:18:42.940 E ID=3
2025-07-03 05:18:42.947 E ID=4
2025-07-03 05:18:42.955 E ID=6
2025-07-03 05:18:42.965 E ID=7
2025-07-03 05:18:42.974 E ID=8
2025-07-03 05:18:42.981 E ID=10
2025-07-03 05:18:42.988 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
2025-07-03 05:18:42.994 E ID=2
2025-07-03 05:18:42.999 E ID=3
2025-07-03 05:18:43.006 E ID=4
2025-07-03 05:18:43.018 E ID=6
2025-07-03 05:18:43.031 E ID=7
2025-07-03 05:18:43.040 E ID=8
2025-07-03 05:18:43.050 E ID=10
2025-07-03 05:18:43.062 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
2025-07-03 05:18:43.073 E ID=2
2025-07-03 05:18:43.085 E ID=3
2025-07-03 05:18:43.094 E ID=4
2025-07-03 05:18:43.106 E ID=6
2025-07-03 05:18:43.117 E ID=7
2025-07-03 05:18:43.127 E ID=8
2025-07-03 05:18:43.139 E ID=10
2025-07-03 05:18:43.149 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
2025-07-03 05:18:43.158 E ID=2
2025-07-03 05:18:43.165 E ID=3
2025-07-03 05:18:43.172 E ID=4
2025-07-03 05:18:43.179 E ID=6
2025-07-03 05:18:43.187 E ID=7
2025-07-03 05:18:43.198 E ID=8
2025-07-03 05:18:43.206 E ID=10
2025-07-03 05:18:43.212 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
2025-07-03 05:18:43.218 E ID=2
2025-07-03 05:18:43.226 E ID=3
2025-07-03 05:18:43.235 E ID=4
2025-07-03 05:18:43.244 E ID=6
2025-07-03 05:18:43.249 E ID=7
2025-07-03 05:18:43.255 E ID=8
2025-07-03 05:18:43.260 E ID=10
2025-07-03 05:18:43.266 E QUERY_TYPE = PSQL_REMOTE, TIL = SERIALIZABLE, ACCESS = READ, WAIT = NO_WAIT:
2025-07-03 05:18:43.272 E Execute statement error at isc_dsql_fetch :
2025-07-03 05:18:43.277 E 335544345 : lock conflict on no wait transaction
2025-07-03 05:18:43.284 E - 335544382 : Acquire lock for relation (TEST) failed
2025-07-03 05:18:43.290 E + 335544382 : Acquire lock for relation ("PUBLIC"."TEST") failed
2025-07-03 05:18:43.303 E Statement : select id from test order by id with lock skip locked
2025-07-03 05:18:43.314 E Data source : Firebird::localhost:
2025-07-03 05:18:43.322 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-07-03 05:18:43.334 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-07-03 05:18:43.344 E -901
2025-07-03 05:18:43.356 E 335544926
2025-07-03 05:18:43.366 E 335544842
2025-07-03 05:18:43.375 E QUERY_TYPE = PSQL_REMOTE, TIL = SNAPSHOT, ACCESS = READ, WAIT = NO_WAIT:
2025-07-03 05:18:43.381 E Execute statement error at isc_dsql_fetch :
2025-07-03 05:18:43.388 E 335544361 : attempted update during read-only transaction
2025-07-03 05:18:43.394 E Statement : select id from test order by id with lock skip locked
2025-07-03 05:18:43.400 E Data source : Firebird::localhost:
2025-07-03 05:18:43.406 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-07-03 05:18:43.412 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-07-03 05:18:43.421 E -901
2025-07-03 05:18:43.427 E 335544926
2025-07-03 05:18:43.434 E 335544842
2025-07-03 05:18:43.441 E QUERY_TYPE = PSQL_REMOTE, TIL = SNAPSHOT, ACCESS = READ, WAIT = WAIT:
2025-07-03 05:18:43.447 E Execute statement error at isc_dsql_fetch :
2025-07-03 05:18:43.453 E 335544361 : attempted update during read-only transaction
2025-07-03 05:18:43.458 E Statement : select id from test order by id with lock skip locked
2025-07-03 05:18:43.464 E Data source : Firebird::localhost:
2025-07-03 05:18:43.469 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-07-03 05:18:43.475 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-07-03 05:18:43.481 E -901
2025-07-03 05:18:43.486 E 335544926
2025-07-03 05:18:43.493 E 335544842
2025-07-03 05:18:43.500 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = NO_WAIT:
2025-07-03 05:18:43.506 E Execute statement error at isc_dsql_fetch :
2025-07-03 05:18:43.514 E 335544361 : attempted update during read-only transaction
2025-07-03 05:18:43.521 E Statement : select id from test order by id with lock skip locked
2025-07-03 05:18:43.528 E Data source : Firebird::localhost:
2025-07-03 05:18:43.533 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-07-03 05:18:43.539 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-07-03 05:18:43.546 E -901
2025-07-03 05:18:43.552 E 335544926
2025-07-03 05:18:43.559 E 335544842
2025-07-03 05:18:43.565 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = WAIT:
2025-07-03 05:18:43.571 E Execute statement error at isc_dsql_fetch :
2025-07-03 05:18:43.577 E 335544361 : attempted update during read-only transaction
2025-07-03 05:18:43.583 E Statement : select id from test order by id with lock skip locked
2025-07-03 05:18:43.591 E Data source : Firebird::localhost:
2025-07-03 05:18:43.602 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-07-03 05:18:43.609 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-07-03 05:18:43.615 E -901
2025-07-03 05:18:43.621 E 335544926
2025-07-03 05:18:43.627 E 335544842
2025-07-03 05:18:43.634 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
2025-07-03 05:18:43.645 E Execute statement error at isc_dsql_fetch :
2025-07-03 05:18:43.653 E 335544361 : attempted update during read-only transaction
2025-07-03 05:18:43.660 E Statement : select id from test order by id with lock skip locked
2025-07-03 05:18:43.666 E Data source : Firebird::localhost:
2025-07-03 05:18:43.672 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-07-03 05:18:43.678 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-07-03 05:18:43.683 E -901
2025-07-03 05:18:43.691 E 335544926
2025-07-03 05:18:43.701 E 335544842
2025-07-03 05:18:43.710 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
2025-07-03 05:18:43.718 E Execute statement error at isc_dsql_fetch :
2025-07-03 05:18:43.725 E 335544361 : attempted update during read-only transaction
2025-07-03 05:18:43.732 E Statement : select id from test order by id with lock skip locked
2025-07-03 05:18:43.739 E Data source : Firebird::localhost:
2025-07-03 05:18:43.745 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-07-03 05:18:43.752 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-07-03 05:18:43.757 E -901
2025-07-03 05:18:43.763 E 335544926
2025-07-03 05:18:43.769 E 335544842
2025-07-03 05:18:43.775 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
2025-07-03 05:18:43.781 E Execute statement error at isc_dsql_fetch :
2025-07-03 05:18:43.787 E 335544361 : attempted update during read-only transaction
2025-07-03 05:18:43.793 E Statement : select id from test order by id with lock skip locked
2025-07-03 05:18:43.799 E Data source : Firebird::localhost:
2025-07-03 05:18:43.806 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-07-03 05:18:43.812 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-07-03 05:18:43.819 E -901
2025-07-03 05:18:43.829 E 335544926
2025-07-03 05:18:43.837 E 335544842
2025-07-03 05:18:43.846 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
2025-07-03 05:18:43.857 E Execute statement error at isc_dsql_fetch :
2025-07-03 05:18:43.868 E 335544361 : attempted update during read-only transaction
2025-07-03 05:18:43.876 E Statement : select id from test order by id with lock skip locked
2025-07-03 05:18:43.883 E Data source : Firebird::localhost:
2025-07-03 05:18:43.890 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-07-03 05:18:43.903 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-07-03 05:18:43.912 E -901
2025-07-03 05:18:43.919 E 335544926
2025-07-03 05:18:43.925 E 335544842
2025-07-03 05:18:43.932 E QUERY_TYPE = PSQL_REMOTE, TIL = SERIALIZABLE, ACCESS = WRITE, WAIT = NO_WAIT:
2025-07-03 05:18:43.938 E Execute statement error at isc_dsql_fetch :
2025-07-03 05:18:43.944 E 335544345 : lock conflict on no wait transaction
2025-07-03 05:18:43.950 E - 335544382 : Acquire lock for relation (TEST) failed
2025-07-03 05:18:43.956 E + 335544382 : Acquire lock for relation ("PUBLIC"."TEST") failed
2025-07-03 05:18:43.967 E Statement : select id from test order by id with lock skip locked
2025-07-03 05:18:43.973 E Data source : Firebird::localhost:
2025-07-03 05:18:43.979 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-07-03 05:18:43.985 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-07-03 05:18:43.990 E -901
2025-07-03 05:18:43.997 E 335544926
2025-07-03 05:18:44.004 E 335544842
2025-07-03 05:18:44.011 E QUERY_TYPE = PSQL_REMOTE, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = NO_WAIT:
2025-07-03 05:18:44.018 E ID=2
2025-07-03 05:18:44.029 E ID=3
2025-07-03 05:18:44.039 E ID=4
2025-07-03 05:18:44.048 E ID=6
2025-07-03 05:18:44.055 E ID=7
2025-07-03 05:18:44.061 E ID=8
2025-07-03 05:18:44.067 E ID=10
2025-07-03 05:18:44.073 E QUERY_TYPE = PSQL_REMOTE, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = WAIT:
2025-07-03 05:18:44.079 E ID=2
2025-07-03 05:18:44.085 E ID=3
2025-07-03 05:18:44.091 E ID=4
2025-07-03 05:18:44.096 E ID=6
2025-07-03 05:18:44.102 E ID=7
2025-07-03 05:18:44.108 E ID=8
2025-07-03 05:18:44.115 E ID=10
2025-07-03 05:18:44.127 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = NO_WAIT:
2025-07-03 05:18:44.134 E ID=2
2025-07-03 05:18:44.143 E ID=3
2025-07-03 05:18:44.151 E ID=4
2025-07-03 05:18:44.160 E ID=6
2025-07-03 05:18:44.167 E ID=7
2025-07-03 05:18:44.176 E ID=8
2025-07-03 05:18:44.184 E ID=10
2025-07-03 05:18:44.191 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = WAIT:
2025-07-03 05:18:44.198 E ID=2
2025-07-03 05:18:44.204 E ID=3
2025-07-03 05:18:44.210 E ID=4
2025-07-03 05:18:44.215 E ID=6
2025-07-03 05:18:44.219 E ID=7
2025-07-03 05:18:44.224 E ID=8
2025-07-03 05:18:44.229 E ID=10
2025-07-03 05:18:44.234 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
2025-07-03 05:18:44.239 E ID=2
2025-07-03 05:18:44.245 E ID=3
2025-07-03 05:18:44.250 E ID=4
2025-07-03 05:18:44.256 E ID=6
2025-07-03 05:18:44.261 E ID=7
2025-07-03 05:18:44.267 E ID=8
2025-07-03 05:18:44.273 E ID=10
2025-07-03 05:18:44.280 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
2025-07-03 05:18:44.287 E ID=2
2025-07-03 05:18:44.294 E ID=3
2025-07-03 05:18:44.305 E ID=4
2025-07-03 05:18:44.313 E ID=6
2025-07-03 05:18:44.319 E ID=7
2025-07-03 05:18:44.325 E ID=8
2025-07-03 05:18:44.331 E ID=10
2025-07-03 05:18:44.339 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
2025-07-03 05:18:44.347 E ID=2
2025-07-03 05:18:44.355 E ID=3
2025-07-03 05:18:44.362 E ID=4
2025-07-03 05:18:44.367 E ID=6
2025-07-03 05:18:44.373 E ID=7
2025-07-03 05:18:44.378 E ID=8
2025-07-03 05:18:44.383 E ID=10
2025-07-03 05:18:44.389 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
2025-07-03 05:18:44.394 E ID=2
2025-07-03 05:18:44.398 E ID=3
2025-07-03 05:18:44.403 E ID=4
2025-07-03 05:18:44.407 E ID=6
2025-07-03 05:18:44.415 E ID=7
2025-07-03 05:18:44.425 E ID=8
2025-07-03 05:18:44.433 E ID=10
2025-07-03 05:18:44.439
2025-07-03 05:18:44.445 tests/bugs/gh_7350_test.py:544: AssertionError
2025-07-03 05:18:44.455 ---------------------------- Captured stdout setup -----------------------------
2025-07-03 05:18:44.465 Creating db: localhost:/var/tmp/qa_2024/test_11543/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
|