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-02 06:41:19.984
2025-07-02 06:41:19.984 act = <firebird.qa.plugin.Action object at [hex]>
2025-07-02 06:41:19.984 capsys = <_pytest.capture.CaptureFixture object at [hex]>
2025-07-02 06:41:19.984
2025-07-02 06:41:19.984 @pytest.mark.es_eds
2025-07-02 06:41:19.984 @pytest.mark.version('>=5.0')
2025-07-02 06:41:19.984 def test_1(act: Action, capsys):
2025-07-02 06:41:19.984
2025-07-02 06:41:19.984 init_sql = f"""
2025-07-02 06:41:19.984 set term ^;
2025-07-02 06:41:19.984 recreate table test(id int primary key, f01 int)
2025-07-02 06:41:19.984 -- recreate global temporary table test(id int primary key, f01 int) on commit preserve rows
2025-07-02 06:41:19.984 ^
2025-07-02 06:41:19.984 create or alter procedure sp_get_unlocked_rows_local returns(id int) as
2025-07-02 06:41:19.984 begin
2025-07-02 06:41:19.984 for
2025-07-02 06:41:19.984 {CHECK_SQL}
2025-07-02 06:41:19.984 into id
2025-07-02 06:41:19.984 do
2025-07-02 06:41:19.985 suspend;
2025-07-02 06:41:19.985 end
2025-07-02 06:41:19.985 ^
2025-07-02 06:41:19.985 create or alter procedure sp_get_unlocked_rows_remote returns(id int) as
2025-07-02 06:41:19.985 begin
2025-07-02 06:41:19.985 for
2025-07-02 06:41:19.985 execute statement '{CHECK_SQL}'
2025-07-02 06:41:19.985 on external 'localhost:' || rdb$get_context('SYSTEM', 'DB_NAME')
2025-07-02 06:41:19.985 as user '{act.db.user}' password '{act.db.password}'
2025-07-02 06:41:19.985 into id
2025-07-02 06:41:19.985 do
2025-07-02 06:41:19.985 suspend;
2025-07-02 06:41:19.985 end
2025-07-02 06:41:19.985 ^
2025-07-02 06:41:19.985 set term ;^
2025-07-02 06:41:19.985 commit;
2025-07-02 06:41:19.985
2025-07-02 06:41:19.985 insert into test(id, f01) select row_number()over(), 0 from rdb$types rows 10;
2025-07-02 06:41:19.986 commit;
2025-07-02 06:41:19.986 """
2025-07-02 06:41:19.986 act.isql(switches=['-q'], input = init_sql, combine_output = True)
2025-07-02 06:41:19.986 assert act.clean_stdout == ''
2025-07-02 06:41:19.986 act.reset()
2025-07-02 06:41:19.986
2025-07-02 06:41:19.986 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-02 06:41:19.986 tpb_wait_set = (TraLockResolution.NO_WAIT,TraLockResolution.WAIT)
2025-07-02 06:41:19.986 tpb_mode_set = (TraAccessMode.READ, TraAccessMode.WRITE)
2025-07-02 06:41:19.986 query_types_set = ('DSQL', 'PSQL_LOCAL', 'PSQL_REMOTE')
2025-07-02 06:41:19.986
2025-07-02 06:41:19.986 with act.db.connect() as con_rows_locker, act.db.connect() as con_free_seeker:
2025-07-02 06:41:19.986 con_rows_locker.execute_immediate('update test set f01 = 1 where id in (1,5,9)')
2025-07-02 06:41:19.986 for query_type in query_types_set:
2025-07-02 06:41:19.986 for x_mode in tpb_mode_set:
2025-07-02 06:41:19.986 for x_isol in tpb_isol_set:
2025-07-02 06:41:19.986 for x_wait in tpb_wait_set:
2025-07-02 06:41:19.986 skip_flag = x_isol in (Isolation.SERIALIZABLE,) and x_wait == TraLockResolution.WAIT
2025-07-02 06:41:19.987 if skip_flag:
2025-07-02 06:41:19.987
2025-07-02 06:41:19.987 #######################################
2025-07-02 06:41:19.987 ### D O N O T C H E C K ###
2025-07-02 06:41:19.987 #######################################
2025-07-02 06:41:19.987 #
2025-07-02 06:41:19.987 # 1. Isolation.SERIALIZABLE requires that the whole table must not be changed by anyone else.
2025-07-02 06:41:19.987 # 2. [WAS ACTUAL BEFORE GH-7810 FIXED; CURRENTLY REMAINS NEEDED FB 5.X]
2025-07-02 06:41:19.987 # Isolation.READ_COMMITTED_NO_RECORD_VERSION can not be used due to implementation details, see:
2025-07-02 06:41:19.987 # Adriano, 26-feb-2023, https://github.com/FirebirdSQL/firebird/pull/7350#issuecomment-1445408462
2025-07-02 06:41:19.987 # "WITH LOCK [SKIP LOCKED] needs a record read before, but this locked records cannot be read with NO RECORD VERSION.
2025-07-02 06:41:19.987 # Considering that this transaction mode is replaced by default I would only document it as in fact I don't think
2025-07-02 06:41:19.987 # there are anything we could do."
2025-07-02 06:41:19.987
2025-07-02 06:41:19.987 continue
2025-07-02 06:41:19.987
2025-07-02 06:41:19.988 custom_tpb = tpb(isolation = x_isol, access_mode = x_mode, lock_timeout = -1 if x_wait == TraLockResolution.WAIT else 0)
2025-07-02 06:41:19.988 #custom_tpb = TPB(isolation = x_isol, access_mode = x_mode, lock_timeout = 0).get_buffer()
2025-07-02 06:41:19.988 tx_free_seeker = con_free_seeker.transaction_manager(custom_tpb)
2025-07-02 06:41:19.988 cur_free_seeker = tx_free_seeker.cursor()
2025-07-02 06:41:19.988 tx_free_seeker.begin()
2025-07-02 06:41:19.988 try:
2025-07-02 06:41:19.988 print('\n')
2025-07-02 06:41:19.988 print(f'QUERY_TYPE = {query_type}, TIL = {x_isol.name}, ACCESS = {x_mode.name}, WAIT = {x_wait.name}:')
2025-07-02 06:41:19.988 if query_type == 'DSQL':
2025-07-02 06:41:19.988 cur_free_seeker.execute(f'{CHECK_SQL}')
2025-07-02 06:41:19.988 elif query_type == 'PSQL_LOCAL':
2025-07-02 06:41:19.988 cur_free_seeker.execute('select id from sp_get_unlocked_rows_local')
2025-07-02 06:41:19.988 elif query_type == 'PSQL_REMOTE':
2025-07-02 06:41:19.988 cur_free_seeker.execute('select id from sp_get_unlocked_rows_remote')
2025-07-02 06:41:19.988 for r in cur_free_seeker:
2025-07-02 06:41:19.988 print('ID='+str(r[0]))
2025-07-02 06:41:19.988 except DatabaseError as e:
2025-07-02 06:41:19.988 print(e.__str__())
2025-07-02 06:41:19.988 print(e.sqlcode)
2025-07-02 06:41:19.989 for g in e.gds_codes:
2025-07-02 06:41:19.989 print(g)
2025-07-02 06:41:19.989 finally:
2025-07-02 06:41:19.989 tx_free_seeker.rollback()
2025-07-02 06:41:19.989
2025-07-02 06:41:19.989 act.expected_stdout = expected_stdout
2025-07-02 06:41:19.989 act.stdout = capsys.readouterr().out
2025-07-02 06:41:19.989 > assert act.clean_stdout == act.clean_expected_stdout
2025-07-02 06:41:19.989 E assert
2025-07-02 06:41:19.989 E QUERY_TYPE = DSQL, TIL = SERIALIZABLE, ACCESS = READ, WAIT = NO_WAIT:
2025-07-02 06:41:19.989 E lock conflict on no wait transaction
2025-07-02 06:41:19.989 E - -Acquire lock for relation (TEST) failed
2025-07-02 06:41:19.989 E + -Acquire lock for relation ("PUBLIC"."TEST") failed
2025-07-02 06:41:19.989 E -901
2025-07-02 06:41:19.989 E 335544345
2025-07-02 06:41:19.989 E 335544382
2025-07-02 06:41:19.989 E QUERY_TYPE = DSQL, TIL = SNAPSHOT, ACCESS = READ, WAIT = NO_WAIT:
2025-07-02 06:41:19.989 E attempted update during read-only transaction
2025-07-02 06:41:19.990 E -817
2025-07-02 06:41:19.990 E 335544361
2025-07-02 06:41:19.990 E QUERY_TYPE = DSQL, TIL = SNAPSHOT, ACCESS = READ, WAIT = WAIT:
2025-07-02 06:41:19.990 E attempted update during read-only transaction
2025-07-02 06:41:19.990 E -817
2025-07-02 06:41:19.990 E 335544361
2025-07-02 06:41:19.990 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = NO_WAIT:
2025-07-02 06:41:19.990 E attempted update during read-only transaction
2025-07-02 06:41:19.990 E -817
2025-07-02 06:41:19.990 E 335544361
2025-07-02 06:41:19.990 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = WAIT:
2025-07-02 06:41:19.990 E attempted update during read-only transaction
2025-07-02 06:41:19.990 E -817
2025-07-02 06:41:19.990 E 335544361
2025-07-02 06:41:19.990 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
2025-07-02 06:41:19.990 E attempted update during read-only transaction
2025-07-02 06:41:19.990 E -817
2025-07-02 06:41:19.990 E 335544361
2025-07-02 06:41:19.990 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
2025-07-02 06:41:19.991 E attempted update during read-only transaction
2025-07-02 06:41:19.991 E -817
2025-07-02 06:41:19.991 E 335544361
2025-07-02 06:41:19.991 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
2025-07-02 06:41:19.991 E attempted update during read-only transaction
2025-07-02 06:41:19.991 E -817
2025-07-02 06:41:19.991 E 335544361
2025-07-02 06:41:19.991 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
2025-07-02 06:41:19.991 E attempted update during read-only transaction
2025-07-02 06:41:19.991 E -817
2025-07-02 06:41:19.991 E 335544361
2025-07-02 06:41:19.991 E QUERY_TYPE = DSQL, TIL = SERIALIZABLE, ACCESS = WRITE, WAIT = NO_WAIT:
2025-07-02 06:41:19.991 E lock conflict on no wait transaction
2025-07-02 06:41:19.991 E - -Acquire lock for relation (TEST) failed
2025-07-02 06:41:19.991 E + -Acquire lock for relation ("PUBLIC"."TEST") failed
2025-07-02 06:41:19.991 E -901
2025-07-02 06:41:19.991 E 335544345
2025-07-02 06:41:19.991 E 335544382
2025-07-02 06:41:19.991 E QUERY_TYPE = DSQL, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = NO_WAIT:
2025-07-02 06:41:19.992 E ID=2
2025-07-02 06:41:19.992 E ID=3
2025-07-02 06:41:19.992 E ID=4
2025-07-02 06:41:19.992 E ID=6
2025-07-02 06:41:19.992 E ID=7
2025-07-02 06:41:19.992 E ID=8
2025-07-02 06:41:19.992 E ID=10
2025-07-02 06:41:19.992 E QUERY_TYPE = DSQL, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = WAIT:
2025-07-02 06:41:19.992 E ID=2
2025-07-02 06:41:19.992 E ID=3
2025-07-02 06:41:19.992 E ID=4
2025-07-02 06:41:19.992 E ID=6
2025-07-02 06:41:19.992 E ID=7
2025-07-02 06:41:19.992 E ID=8
2025-07-02 06:41:19.992 E ID=10
2025-07-02 06:41:19.992 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = NO_WAIT:
2025-07-02 06:41:19.992 E ID=2
2025-07-02 06:41:19.992 E ID=3
2025-07-02 06:41:19.992 E ID=4
2025-07-02 06:41:19.992 E ID=6
2025-07-02 06:41:19.992 E ID=7
2025-07-02 06:41:19.993 E ID=8
2025-07-02 06:41:19.993 E ID=10
2025-07-02 06:41:19.993 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = WAIT:
2025-07-02 06:41:19.993 E ID=2
2025-07-02 06:41:19.993 E ID=3
2025-07-02 06:41:19.993 E ID=4
2025-07-02 06:41:19.993 E ID=6
2025-07-02 06:41:19.993 E ID=7
2025-07-02 06:41:19.993 E ID=8
2025-07-02 06:41:19.993 E ID=10
2025-07-02 06:41:19.993 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
2025-07-02 06:41:19.993 E ID=2
2025-07-02 06:41:19.993 E ID=3
2025-07-02 06:41:19.993 E ID=4
2025-07-02 06:41:19.993 E ID=6
2025-07-02 06:41:19.993 E ID=7
2025-07-02 06:41:19.993 E ID=8
2025-07-02 06:41:19.993 E ID=10
2025-07-02 06:41:19.993 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
2025-07-02 06:41:19.993 E ID=2
2025-07-02 06:41:19.994 E ID=3
2025-07-02 06:41:19.994 E ID=4
2025-07-02 06:41:19.994 E ID=6
2025-07-02 06:41:19.994 E ID=7
2025-07-02 06:41:19.994 E ID=8
2025-07-02 06:41:19.994 E ID=10
2025-07-02 06:41:19.994 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
2025-07-02 06:41:19.994 E ID=2
2025-07-02 06:41:19.994 E ID=3
2025-07-02 06:41:19.994 E ID=4
2025-07-02 06:41:19.994 E ID=6
2025-07-02 06:41:19.994 E ID=7
2025-07-02 06:41:19.994 E ID=8
2025-07-02 06:41:19.994 E ID=10
2025-07-02 06:41:19.994 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
2025-07-02 06:41:19.994 E ID=2
2025-07-02 06:41:19.994 E ID=3
2025-07-02 06:41:19.994 E ID=4
2025-07-02 06:41:19.994 E ID=6
2025-07-02 06:41:19.994 E ID=7
2025-07-02 06:41:19.994 E ID=8
2025-07-02 06:41:19.995 E ID=10
2025-07-02 06:41:19.995 E QUERY_TYPE = PSQL_LOCAL, TIL = SERIALIZABLE, ACCESS = READ, WAIT = NO_WAIT:
2025-07-02 06:41:19.995 E lock conflict on no wait transaction
2025-07-02 06:41:19.995 E - -Acquire lock for relation (TEST) failed
2025-07-02 06:41:19.995 E + -Acquire lock for relation ("PUBLIC"."TEST") failed
2025-07-02 06:41:19.995 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-07-02 06:41:19.995 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-07-02 06:41:19.995 E -901
2025-07-02 06:41:19.995 E 335544345
2025-07-02 06:41:19.995 E 335544382
2025-07-02 06:41:19.995 E 335544842
2025-07-02 06:41:19.995 E QUERY_TYPE = PSQL_LOCAL, TIL = SNAPSHOT, ACCESS = READ, WAIT = NO_WAIT:
2025-07-02 06:41:19.995 E attempted update during read-only transaction
2025-07-02 06:41:19.995 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-07-02 06:41:19.995 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-07-02 06:41:19.995 E -817
2025-07-02 06:41:19.995 E 335544361
2025-07-02 06:41:19.995 E 335544842
2025-07-02 06:41:19.995 E QUERY_TYPE = PSQL_LOCAL, TIL = SNAPSHOT, ACCESS = READ, WAIT = WAIT:
2025-07-02 06:41:19.996 E attempted update during read-only transaction
2025-07-02 06:41:19.996 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-07-02 06:41:19.996 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-07-02 06:41:19.996 E -817
2025-07-02 06:41:19.996 E 335544361
2025-07-02 06:41:19.996 E 335544842
2025-07-02 06:41:19.996 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = NO_WAIT:
2025-07-02 06:41:19.996 E attempted update during read-only transaction
2025-07-02 06:41:19.996 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-07-02 06:41:19.996 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-07-02 06:41:19.996 E -817
2025-07-02 06:41:19.996 E 335544361
2025-07-02 06:41:19.996 E 335544842
2025-07-02 06:41:19.996 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = WAIT:
2025-07-02 06:41:19.996 E attempted update during read-only transaction
2025-07-02 06:41:19.996 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-07-02 06:41:19.996 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-07-02 06:41:19.996 E -817
2025-07-02 06:41:19.996 E 335544361
2025-07-02 06:41:19.997 E 335544842
2025-07-02 06:41:19.997 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
2025-07-02 06:41:19.997 E attempted update during read-only transaction
2025-07-02 06:41:19.997 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-07-02 06:41:19.997 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-07-02 06:41:19.997 E -817
2025-07-02 06:41:19.997 E 335544361
2025-07-02 06:41:19.997 E 335544842
2025-07-02 06:41:19.997 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
2025-07-02 06:41:19.997 E attempted update during read-only transaction
2025-07-02 06:41:19.997 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-07-02 06:41:19.997 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-07-02 06:41:19.997 E -817
2025-07-02 06:41:19.997 E 335544361
2025-07-02 06:41:19.997 E 335544842
2025-07-02 06:41:19.997 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
2025-07-02 06:41:19.997 E attempted update during read-only transaction
2025-07-02 06:41:19.997 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-07-02 06:41:19.997 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-07-02 06:41:19.998 E -817
2025-07-02 06:41:19.998 E 335544361
2025-07-02 06:41:19.998 E 335544842
2025-07-02 06:41:19.998 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
2025-07-02 06:41:19.998 E attempted update during read-only transaction
2025-07-02 06:41:19.998 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-07-02 06:41:19.998 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-07-02 06:41:19.998 E -817
2025-07-02 06:41:19.998 E 335544361
2025-07-02 06:41:19.998 E 335544842
2025-07-02 06:41:19.998 E QUERY_TYPE = PSQL_LOCAL, TIL = SERIALIZABLE, ACCESS = WRITE, WAIT = NO_WAIT:
2025-07-02 06:41:19.998 E lock conflict on no wait transaction
2025-07-02 06:41:19.998 E - -Acquire lock for relation (TEST) failed
2025-07-02 06:41:19.998 E + -Acquire lock for relation ("PUBLIC"."TEST") failed
2025-07-02 06:41:19.998 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-07-02 06:41:19.998 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-07-02 06:41:19.998 E -901
2025-07-02 06:41:19.998 E 335544345
2025-07-02 06:41:19.999 E 335544382
2025-07-02 06:41:19.999 E 335544842
2025-07-02 06:41:19.999 E QUERY_TYPE = PSQL_LOCAL, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = NO_WAIT:
2025-07-02 06:41:19.999 E ID=2
2025-07-02 06:41:19.999 E ID=3
2025-07-02 06:41:19.999 E ID=4
2025-07-02 06:41:19.999 E ID=6
2025-07-02 06:41:19.999 E ID=7
2025-07-02 06:41:19.999 E ID=8
2025-07-02 06:41:19.999 E ID=10
2025-07-02 06:41:19.999 E QUERY_TYPE = PSQL_LOCAL, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = WAIT:
2025-07-02 06:41:19.999 E ID=2
2025-07-02 06:41:19.999 E ID=3
2025-07-02 06:41:19.999 E ID=4
2025-07-02 06:41:19.999 E ID=6
2025-07-02 06:41:19.999 E ID=7
2025-07-02 06:41:19.999 E ID=8
2025-07-02 06:41:19.999 E ID=10
2025-07-02 06:41:19.999 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = NO_WAIT:
2025-07-02 06:41:19.999 E ID=2
2025-07-02 06:41:20.000 E ID=3
2025-07-02 06:41:20.000 E ID=4
2025-07-02 06:41:20.000 E ID=6
2025-07-02 06:41:20.000 E ID=7
2025-07-02 06:41:20.000 E ID=8
2025-07-02 06:41:20.000 E ID=10
2025-07-02 06:41:20.000 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = WAIT:
2025-07-02 06:41:20.000 E ID=2
2025-07-02 06:41:20.000 E ID=3
2025-07-02 06:41:20.000 E ID=4
2025-07-02 06:41:20.000 E ID=6
2025-07-02 06:41:20.000 E ID=7
2025-07-02 06:41:20.000 E ID=8
2025-07-02 06:41:20.000 E ID=10
2025-07-02 06:41:20.000 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
2025-07-02 06:41:20.000 E ID=2
2025-07-02 06:41:20.000 E ID=3
2025-07-02 06:41:20.000 E ID=4
2025-07-02 06:41:20.000 E ID=6
2025-07-02 06:41:20.000 E ID=7
2025-07-02 06:41:20.001 E ID=8
2025-07-02 06:41:20.001 E ID=10
2025-07-02 06:41:20.001 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
2025-07-02 06:41:20.001 E ID=2
2025-07-02 06:41:20.001 E ID=3
2025-07-02 06:41:20.001 E ID=4
2025-07-02 06:41:20.001 E ID=6
2025-07-02 06:41:20.001 E ID=7
2025-07-02 06:41:20.001 E ID=8
2025-07-02 06:41:20.001 E ID=10
2025-07-02 06:41:20.001 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
2025-07-02 06:41:20.001 E ID=2
2025-07-02 06:41:20.001 E ID=3
2025-07-02 06:41:20.001 E ID=4
2025-07-02 06:41:20.001 E ID=6
2025-07-02 06:41:20.001 E ID=7
2025-07-02 06:41:20.001 E ID=8
2025-07-02 06:41:20.001 E ID=10
2025-07-02 06:41:20.001 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
2025-07-02 06:41:20.002 E ID=2
2025-07-02 06:41:20.002 E ID=3
2025-07-02 06:41:20.002 E ID=4
2025-07-02 06:41:20.002 E ID=6
2025-07-02 06:41:20.002 E ID=7
2025-07-02 06:41:20.002 E ID=8
2025-07-02 06:41:20.002 E ID=10
2025-07-02 06:41:20.002 E QUERY_TYPE = PSQL_REMOTE, TIL = SERIALIZABLE, ACCESS = READ, WAIT = NO_WAIT:
2025-07-02 06:41:20.002 E Execute statement error at isc_dsql_fetch :
2025-07-02 06:41:20.002 E 335544345 : lock conflict on no wait transaction
2025-07-02 06:41:20.002 E - 335544382 : Acquire lock for relation (TEST) failed
2025-07-02 06:41:20.002 E + 335544382 : Acquire lock for relation ("PUBLIC"."TEST") failed
2025-07-02 06:41:20.002 E Statement : select id from test order by id with lock skip locked
2025-07-02 06:41:20.002 E Data source : Firebird::localhost:
2025-07-02 06:41:20.002 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-07-02 06:41:20.002 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-07-02 06:41:20.002 E -901
2025-07-02 06:41:20.002 E 335544926
2025-07-02 06:41:20.002 E 335544842
2025-07-02 06:41:20.003 E QUERY_TYPE = PSQL_REMOTE, TIL = SNAPSHOT, ACCESS = READ, WAIT = NO_WAIT:
2025-07-02 06:41:20.003 E Execute statement error at isc_dsql_fetch :
2025-07-02 06:41:20.003 E 335544361 : attempted update during read-only transaction
2025-07-02 06:41:20.003 E Statement : select id from test order by id with lock skip locked
2025-07-02 06:41:20.003 E Data source : Firebird::localhost:
2025-07-02 06:41:20.003 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-07-02 06:41:20.003 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-07-02 06:41:20.003 E -901
2025-07-02 06:41:20.003 E 335544926
2025-07-02 06:41:20.003 E 335544842
2025-07-02 06:41:20.003 E QUERY_TYPE = PSQL_REMOTE, TIL = SNAPSHOT, ACCESS = READ, WAIT = WAIT:
2025-07-02 06:41:20.003 E Execute statement error at isc_dsql_fetch :
2025-07-02 06:41:20.003 E 335544361 : attempted update during read-only transaction
2025-07-02 06:41:20.003 E Statement : select id from test order by id with lock skip locked
2025-07-02 06:41:20.003 E Data source : Firebird::localhost:
2025-07-02 06:41:20.003 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-07-02 06:41:20.003 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-07-02 06:41:20.003 E -901
2025-07-02 06:41:20.003 E 335544926
2025-07-02 06:41:20.003 E 335544842
2025-07-02 06:41:20.003 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = NO_WAIT:
2025-07-02 06:41:20.004 E Execute statement error at isc_dsql_fetch :
2025-07-02 06:41:20.004 E 335544361 : attempted update during read-only transaction
2025-07-02 06:41:20.004 E Statement : select id from test order by id with lock skip locked
2025-07-02 06:41:20.004 E Data source : Firebird::localhost:
2025-07-02 06:41:20.004 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-07-02 06:41:20.004 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-07-02 06:41:20.004 E -901
2025-07-02 06:41:20.004 E 335544926
2025-07-02 06:41:20.004 E 335544842
2025-07-02 06:41:20.004 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = WAIT:
2025-07-02 06:41:20.004 E Execute statement error at isc_dsql_fetch :
2025-07-02 06:41:20.004 E 335544361 : attempted update during read-only transaction
2025-07-02 06:41:20.004 E Statement : select id from test order by id with lock skip locked
2025-07-02 06:41:20.004 E Data source : Firebird::localhost:
2025-07-02 06:41:20.004 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-07-02 06:41:20.004 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-07-02 06:41:20.004 E -901
2025-07-02 06:41:20.004 E 335544926
2025-07-02 06:41:20.004 E 335544842
2025-07-02 06:41:20.004 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
2025-07-02 06:41:20.005 E Execute statement error at isc_dsql_fetch :
2025-07-02 06:41:20.005 E 335544361 : attempted update during read-only transaction
2025-07-02 06:41:20.005 E Statement : select id from test order by id with lock skip locked
2025-07-02 06:41:20.005 E Data source : Firebird::localhost:
2025-07-02 06:41:20.005 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-07-02 06:41:20.005 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-07-02 06:41:20.005 E -901
2025-07-02 06:41:20.005 E 335544926
2025-07-02 06:41:20.005 E 335544842
2025-07-02 06:41:20.005 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
2025-07-02 06:41:20.005 E Execute statement error at isc_dsql_fetch :
2025-07-02 06:41:20.005 E 335544361 : attempted update during read-only transaction
2025-07-02 06:41:20.005 E Statement : select id from test order by id with lock skip locked
2025-07-02 06:41:20.005 E Data source : Firebird::localhost:
2025-07-02 06:41:20.005 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-07-02 06:41:20.005 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-07-02 06:41:20.005 E -901
2025-07-02 06:41:20.005 E 335544926
2025-07-02 06:41:20.005 E 335544842
2025-07-02 06:41:20.006 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
2025-07-02 06:41:20.006 E Execute statement error at isc_dsql_fetch :
2025-07-02 06:41:20.006 E 335544361 : attempted update during read-only transaction
2025-07-02 06:41:20.006 E Statement : select id from test order by id with lock skip locked
2025-07-02 06:41:20.006 E Data source : Firebird::localhost:
2025-07-02 06:41:20.006 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-07-02 06:41:20.006 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-07-02 06:41:20.006 E -901
2025-07-02 06:41:20.006 E 335544926
2025-07-02 06:41:20.006 E 335544842
2025-07-02 06:41:20.006 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
2025-07-02 06:41:20.006 E Execute statement error at isc_dsql_fetch :
2025-07-02 06:41:20.006 E 335544361 : attempted update during read-only transaction
2025-07-02 06:41:20.006 E Statement : select id from test order by id with lock skip locked
2025-07-02 06:41:20.006 E Data source : Firebird::localhost:
2025-07-02 06:41:20.006 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-07-02 06:41:20.006 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-07-02 06:41:20.006 E -901
2025-07-02 06:41:20.006 E 335544926
2025-07-02 06:41:20.006 E 335544842
2025-07-02 06:41:20.007 E QUERY_TYPE = PSQL_REMOTE, TIL = SERIALIZABLE, ACCESS = WRITE, WAIT = NO_WAIT:
2025-07-02 06:41:20.007 E Execute statement error at isc_dsql_fetch :
2025-07-02 06:41:20.007 E 335544345 : lock conflict on no wait transaction
2025-07-02 06:41:20.007 E - 335544382 : Acquire lock for relation (TEST) failed
2025-07-02 06:41:20.007 E + 335544382 : Acquire lock for relation ("PUBLIC"."TEST") failed
2025-07-02 06:41:20.007 E Statement : select id from test order by id with lock skip locked
2025-07-02 06:41:20.007 E Data source : Firebird::localhost:
2025-07-02 06:41:20.007 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-07-02 06:41:20.007 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-07-02 06:41:20.007 E -901
2025-07-02 06:41:20.007 E 335544926
2025-07-02 06:41:20.007 E 335544842
2025-07-02 06:41:20.007 E QUERY_TYPE = PSQL_REMOTE, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = NO_WAIT:
2025-07-02 06:41:20.007 E ID=2
2025-07-02 06:41:20.007 E ID=3
2025-07-02 06:41:20.007 E ID=4
2025-07-02 06:41:20.007 E ID=6
2025-07-02 06:41:20.007 E ID=7
2025-07-02 06:41:20.008 E ID=8
2025-07-02 06:41:20.008 E ID=10
2025-07-02 06:41:20.008 E QUERY_TYPE = PSQL_REMOTE, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = WAIT:
2025-07-02 06:41:20.008 E ID=2
2025-07-02 06:41:20.008 E ID=3
2025-07-02 06:41:20.008 E ID=4
2025-07-02 06:41:20.008 E ID=6
2025-07-02 06:41:20.008 E ID=7
2025-07-02 06:41:20.008 E ID=8
2025-07-02 06:41:20.008 E ID=10
2025-07-02 06:41:20.008 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = NO_WAIT:
2025-07-02 06:41:20.008 E ID=2
2025-07-02 06:41:20.008 E ID=3
2025-07-02 06:41:20.008 E ID=4
2025-07-02 06:41:20.008 E ID=6
2025-07-02 06:41:20.008 E ID=7
2025-07-02 06:41:20.008 E ID=8
2025-07-02 06:41:20.008 E ID=10
2025-07-02 06:41:20.008 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = WAIT:
2025-07-02 06:41:20.008 E ID=2
2025-07-02 06:41:20.009 E ID=3
2025-07-02 06:41:20.009 E ID=4
2025-07-02 06:41:20.009 E ID=6
2025-07-02 06:41:20.009 E ID=7
2025-07-02 06:41:20.009 E ID=8
2025-07-02 06:41:20.009 E ID=10
2025-07-02 06:41:20.009 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
2025-07-02 06:41:20.009 E ID=2
2025-07-02 06:41:20.009 E ID=3
2025-07-02 06:41:20.009 E ID=4
2025-07-02 06:41:20.009 E ID=6
2025-07-02 06:41:20.009 E ID=7
2025-07-02 06:41:20.009 E ID=8
2025-07-02 06:41:20.009 E ID=10
2025-07-02 06:41:20.009 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
2025-07-02 06:41:20.009 E ID=2
2025-07-02 06:41:20.009 E ID=3
2025-07-02 06:41:20.009 E ID=4
2025-07-02 06:41:20.009 E ID=6
2025-07-02 06:41:20.009 E ID=7
2025-07-02 06:41:20.009 E ID=8
2025-07-02 06:41:20.010 E ID=10
2025-07-02 06:41:20.010 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
2025-07-02 06:41:20.010 E ID=2
2025-07-02 06:41:20.010 E ID=3
2025-07-02 06:41:20.010 E ID=4
2025-07-02 06:41:20.010 E ID=6
2025-07-02 06:41:20.010 E ID=7
2025-07-02 06:41:20.010 E ID=8
2025-07-02 06:41:20.010 E ID=10
2025-07-02 06:41:20.010 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
2025-07-02 06:41:20.010 E ID=2
2025-07-02 06:41:20.010 E ID=3
2025-07-02 06:41:20.010 E ID=4
2025-07-02 06:41:20.010 E ID=6
2025-07-02 06:41:20.010 E ID=7
2025-07-02 06:41:20.010 E ID=8
2025-07-02 06:41:20.010 E ID=10
2025-07-02 06:41:20.010
2025-07-02 06:41:20.010 tests\bugs\gh_7350_test.py:544: AssertionError
2025-07-02 06:41:20.011 ---------------------------- Captured stdout setup ----------------------------
2025-07-02 06:41:20.011 Creating db: localhost:H:\QA\temp\qa2024.tmp\fbqa\test_11564\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
|