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 05:55:56.071
2025-07-02 05:55:56.082 act = <firebird.qa.plugin.Action object at [hex]>
2025-07-02 05:55:56.091 capsys = <_pytest.capture.CaptureFixture object at [hex]>
2025-07-02 05:55:56.097
2025-07-02 05:55:56.104 @pytest.mark.es_eds
2025-07-02 05:55:56.111 @pytest.mark.version('>=5.0')
2025-07-02 05:55:56.117 def test_1(act: Action, capsys):
2025-07-02 05:55:56.125
2025-07-02 05:55:56.138 init_sql = f"""
2025-07-02 05:55:56.150 set term ^;
2025-07-02 05:55:56.159 recreate table test(id int primary key, f01 int)
2025-07-02 05:55:56.167 -- recreate global temporary table test(id int primary key, f01 int) on commit preserve rows
2025-07-02 05:55:56.175 ^
2025-07-02 05:55:56.184 create or alter procedure sp_get_unlocked_rows_local returns(id int) as
2025-07-02 05:55:56.196 begin
2025-07-02 05:55:56.204 for
2025-07-02 05:55:56.212 {CHECK_SQL}
2025-07-02 05:55:56.218 into id
2025-07-02 05:55:56.223 do
2025-07-02 05:55:56.227 suspend;
2025-07-02 05:55:56.232 end
2025-07-02 05:55:56.237 ^
2025-07-02 05:55:56.241 create or alter procedure sp_get_unlocked_rows_remote returns(id int) as
2025-07-02 05:55:56.247 begin
2025-07-02 05:55:56.252 for
2025-07-02 05:55:56.260 execute statement '{CHECK_SQL}'
2025-07-02 05:55:56.268 on external 'localhost:' || rdb$get_context('SYSTEM', 'DB_NAME')
2025-07-02 05:55:56.274 as user '{act.db.user}' password '{act.db.password}'
2025-07-02 05:55:56.282 into id
2025-07-02 05:55:56.291 do
2025-07-02 05:55:56.300 suspend;
2025-07-02 05:55:56.308 end
2025-07-02 05:55:56.314 ^
2025-07-02 05:55:56.324 set term ;^
2025-07-02 05:55:56.334 commit;
2025-07-02 05:55:56.343
2025-07-02 05:55:56.354 insert into test(id, f01) select row_number()over(), 0 from rdb$types rows 10;
2025-07-02 05:55:56.364 commit;
2025-07-02 05:55:56.372 """
2025-07-02 05:55:56.380 act.isql(switches=['-q'], input = init_sql, combine_output = True)
2025-07-02 05:55:56.392 assert act.clean_stdout == ''
2025-07-02 05:55:56.401 act.reset()
2025-07-02 05:55:56.409
2025-07-02 05:55:56.418 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 05:55:56.429 tpb_wait_set = (TraLockResolution.NO_WAIT,TraLockResolution.WAIT)
2025-07-02 05:55:56.437 tpb_mode_set = (TraAccessMode.READ, TraAccessMode.WRITE)
2025-07-02 05:55:56.444 query_types_set = ('DSQL', 'PSQL_LOCAL', 'PSQL_REMOTE')
2025-07-02 05:55:56.450
2025-07-02 05:55:56.458 with act.db.connect() as con_rows_locker, act.db.connect() as con_free_seeker:
2025-07-02 05:55:56.464 con_rows_locker.execute_immediate('update test set f01 = 1 where id in (1,5,9)')
2025-07-02 05:55:56.470 for query_type in query_types_set:
2025-07-02 05:55:56.480 for x_mode in tpb_mode_set:
2025-07-02 05:55:56.486 for x_isol in tpb_isol_set:
2025-07-02 05:55:56.493 for x_wait in tpb_wait_set:
2025-07-02 05:55:56.499 skip_flag = x_isol in (Isolation.SERIALIZABLE,) and x_wait == TraLockResolution.WAIT
2025-07-02 05:55:56.512 if skip_flag:
2025-07-02 05:55:56.524
2025-07-02 05:55:56.538 #######################################
2025-07-02 05:55:56.549 ### D O N O T C H E C K ###
2025-07-02 05:55:56.562 #######################################
2025-07-02 05:55:56.572 #
2025-07-02 05:55:56.581 # 1. Isolation.SERIALIZABLE requires that the whole table must not be changed by anyone else.
2025-07-02 05:55:56.589 # 2. [WAS ACTUAL BEFORE GH-7810 FIXED; CURRENTLY REMAINS NEEDED FB 5.X]
2025-07-02 05:55:56.597 # Isolation.READ_COMMITTED_NO_RECORD_VERSION can not be used due to implementation details, see:
2025-07-02 05:55:56.609 # Adriano, 26-feb-2023, https://github.com/FirebirdSQL/firebird/pull/7350#issuecomment-1445408462
2025-07-02 05:55:56.618 # "WITH LOCK [SKIP LOCKED] needs a record read before, but this locked records cannot be read with NO RECORD VERSION.
2025-07-02 05:55:56.627 # Considering that this transaction mode is replaced by default I would only document it as in fact I don't think
2025-07-02 05:55:56.633 # there are anything we could do."
2025-07-02 05:55:56.639
2025-07-02 05:55:56.645 continue
2025-07-02 05:55:56.650
2025-07-02 05:55:56.657 custom_tpb = tpb(isolation = x_isol, access_mode = x_mode, lock_timeout = -1 if x_wait == TraLockResolution.WAIT else 0)
2025-07-02 05:55:56.663 #custom_tpb = TPB(isolation = x_isol, access_mode = x_mode, lock_timeout = 0).get_buffer()
2025-07-02 05:55:56.670 tx_free_seeker = con_free_seeker.transaction_manager(custom_tpb)
2025-07-02 05:55:56.676 cur_free_seeker = tx_free_seeker.cursor()
2025-07-02 05:55:56.683 tx_free_seeker.begin()
2025-07-02 05:55:56.691 try:
2025-07-02 05:55:56.702 print('\n')
2025-07-02 05:55:56.712 print(f'QUERY_TYPE = {query_type}, TIL = {x_isol.name}, ACCESS = {x_mode.name}, WAIT = {x_wait.name}:')
2025-07-02 05:55:56.721 if query_type == 'DSQL':
2025-07-02 05:55:56.728 cur_free_seeker.execute(f'{CHECK_SQL}')
2025-07-02 05:55:56.736 elif query_type == 'PSQL_LOCAL':
2025-07-02 05:55:56.742 cur_free_seeker.execute('select id from sp_get_unlocked_rows_local')
2025-07-02 05:55:56.748 elif query_type == 'PSQL_REMOTE':
2025-07-02 05:55:56.755 cur_free_seeker.execute('select id from sp_get_unlocked_rows_remote')
2025-07-02 05:55:56.761 for r in cur_free_seeker:
2025-07-02 05:55:56.768 print('ID='+str(r[0]))
2025-07-02 05:55:56.775 except DatabaseError as e:
2025-07-02 05:55:56.781 print(e.__str__())
2025-07-02 05:55:56.787 print(e.sqlcode)
2025-07-02 05:55:56.795 for g in e.gds_codes:
2025-07-02 05:55:56.805 print(g)
2025-07-02 05:55:56.814 finally:
2025-07-02 05:55:56.825 tx_free_seeker.rollback()
2025-07-02 05:55:56.836
2025-07-02 05:55:56.844 act.expected_stdout = expected_stdout
2025-07-02 05:55:56.852 act.stdout = capsys.readouterr().out
2025-07-02 05:55:56.859 > assert act.clean_stdout == act.clean_expected_stdout
2025-07-02 05:55:56.865 E assert
2025-07-02 05:55:56.870 E QUERY_TYPE = DSQL, TIL = SERIALIZABLE, ACCESS = READ, WAIT = NO_WAIT:
2025-07-02 05:55:56.875 E lock conflict on no wait transaction
2025-07-02 05:55:56.881 E - -Acquire lock for relation (TEST) failed
2025-07-02 05:55:56.887 E + -Acquire lock for relation ("PUBLIC"."TEST") failed
2025-07-02 05:55:56.904 E -901
2025-07-02 05:55:56.912 E 335544345
2025-07-02 05:55:56.918 E 335544382
2025-07-02 05:55:56.923 E QUERY_TYPE = DSQL, TIL = SNAPSHOT, ACCESS = READ, WAIT = NO_WAIT:
2025-07-02 05:55:56.934 E attempted update during read-only transaction
2025-07-02 05:55:56.944 E -817
2025-07-02 05:55:56.951 E 335544361
2025-07-02 05:55:56.963 E QUERY_TYPE = DSQL, TIL = SNAPSHOT, ACCESS = READ, WAIT = WAIT:
2025-07-02 05:55:56.976 E attempted update during read-only transaction
2025-07-02 05:55:56.985 E -817
2025-07-02 05:55:56.994 E 335544361
2025-07-02 05:55:57.001 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = NO_WAIT:
2025-07-02 05:55:57.009 E attempted update during read-only transaction
2025-07-02 05:55:57.014 E -817
2025-07-02 05:55:57.027 E 335544361
2025-07-02 05:55:57.037 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = WAIT:
2025-07-02 05:55:57.047 E attempted update during read-only transaction
2025-07-02 05:55:57.055 E -817
2025-07-02 05:55:57.063 E 335544361
2025-07-02 05:55:57.070 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
2025-07-02 05:55:57.077 E attempted update during read-only transaction
2025-07-02 05:55:57.083 E -817
2025-07-02 05:55:57.090 E 335544361
2025-07-02 05:55:57.097 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
2025-07-02 05:55:57.103 E attempted update during read-only transaction
2025-07-02 05:55:57.108 E -817
2025-07-02 05:55:57.113 E 335544361
2025-07-02 05:55:57.118 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
2025-07-02 05:55:57.124 E attempted update during read-only transaction
2025-07-02 05:55:57.129 E -817
2025-07-02 05:55:57.135 E 335544361
2025-07-02 05:55:57.141 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
2025-07-02 05:55:57.154 E attempted update during read-only transaction
2025-07-02 05:55:57.166 E -817
2025-07-02 05:55:57.175 E 335544361
2025-07-02 05:55:57.183 E QUERY_TYPE = DSQL, TIL = SERIALIZABLE, ACCESS = WRITE, WAIT = NO_WAIT:
2025-07-02 05:55:57.191 E lock conflict on no wait transaction
2025-07-02 05:55:57.198 E - -Acquire lock for relation (TEST) failed
2025-07-02 05:55:57.208 E + -Acquire lock for relation ("PUBLIC"."TEST") failed
2025-07-02 05:55:57.224 E -901
2025-07-02 05:55:57.232 E 335544345
2025-07-02 05:55:57.245 E 335544382
2025-07-02 05:55:57.256 E QUERY_TYPE = DSQL, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = NO_WAIT:
2025-07-02 05:55:57.265 E ID=2
2025-07-02 05:55:57.273 E ID=3
2025-07-02 05:55:57.280 E ID=4
2025-07-02 05:55:57.287 E ID=6
2025-07-02 05:55:57.293 E ID=7
2025-07-02 05:55:57.298 E ID=8
2025-07-02 05:55:57.309 E ID=10
2025-07-02 05:55:57.318 E QUERY_TYPE = DSQL, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = WAIT:
2025-07-02 05:55:57.326 E ID=2
2025-07-02 05:55:57.336 E ID=3
2025-07-02 05:55:57.344 E ID=4
2025-07-02 05:55:57.352 E ID=6
2025-07-02 05:55:57.360 E ID=7
2025-07-02 05:55:57.367 E ID=8
2025-07-02 05:55:57.373 E ID=10
2025-07-02 05:55:57.384 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = NO_WAIT:
2025-07-02 05:55:57.392 E ID=2
2025-07-02 05:55:57.398 E ID=3
2025-07-02 05:55:57.404 E ID=4
2025-07-02 05:55:57.414 E ID=6
2025-07-02 05:55:57.427 E ID=7
2025-07-02 05:55:57.437 E ID=8
2025-07-02 05:55:57.445 E ID=10
2025-07-02 05:55:57.451 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = WAIT:
2025-07-02 05:55:57.456 E ID=2
2025-07-02 05:55:57.461 E ID=3
2025-07-02 05:55:57.466 E ID=4
2025-07-02 05:55:57.470 E ID=6
2025-07-02 05:55:57.475 E ID=7
2025-07-02 05:55:57.480 E ID=8
2025-07-02 05:55:57.484 E ID=10
2025-07-02 05:55:57.489 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
2025-07-02 05:55:57.502 E ID=2
2025-07-02 05:55:57.512 E ID=3
2025-07-02 05:55:57.519 E ID=4
2025-07-02 05:55:57.526 E ID=6
2025-07-02 05:55:57.536 E ID=7
2025-07-02 05:55:57.546 E ID=8
2025-07-02 05:55:57.554 E ID=10
2025-07-02 05:55:57.563 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
2025-07-02 05:55:57.572 E ID=2
2025-07-02 05:55:57.578 E ID=3
2025-07-02 05:55:57.589 E ID=4
2025-07-02 05:55:57.602 E ID=6
2025-07-02 05:55:57.613 E ID=7
2025-07-02 05:55:57.625 E ID=8
2025-07-02 05:55:57.635 E ID=10
2025-07-02 05:55:57.646 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
2025-07-02 05:55:57.659 E ID=2
2025-07-02 05:55:57.669 E ID=3
2025-07-02 05:55:57.679 E ID=4
2025-07-02 05:55:57.689 E ID=6
2025-07-02 05:55:57.700 E ID=7
2025-07-02 05:55:57.714 E ID=8
2025-07-02 05:55:57.724 E ID=10
2025-07-02 05:55:57.738 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
2025-07-02 05:55:57.748 E ID=2
2025-07-02 05:55:57.756 E ID=3
2025-07-02 05:55:57.763 E ID=4
2025-07-02 05:55:57.769 E ID=6
2025-07-02 05:55:57.775 E ID=7
2025-07-02 05:55:57.781 E ID=8
2025-07-02 05:55:57.787 E ID=10
2025-07-02 05:55:57.793 E QUERY_TYPE = PSQL_LOCAL, TIL = SERIALIZABLE, ACCESS = READ, WAIT = NO_WAIT:
2025-07-02 05:55:57.800 E lock conflict on no wait transaction
2025-07-02 05:55:57.806 E - -Acquire lock for relation (TEST) failed
2025-07-02 05:55:57.816 E + -Acquire lock for relation ("PUBLIC"."TEST") failed
2025-07-02 05:55:57.838 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-07-02 05:55:57.851 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-07-02 05:55:57.863 E -901
2025-07-02 05:55:57.877 E 335544345
2025-07-02 05:55:57.887 E 335544382
2025-07-02 05:55:57.894 E 335544842
2025-07-02 05:55:57.905 E QUERY_TYPE = PSQL_LOCAL, TIL = SNAPSHOT, ACCESS = READ, WAIT = NO_WAIT:
2025-07-02 05:55:57.915 E attempted update during read-only transaction
2025-07-02 05:55:57.922 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-07-02 05:55:57.929 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-07-02 05:55:57.935 E -817
2025-07-02 05:55:57.941 E 335544361
2025-07-02 05:55:57.947 E 335544842
2025-07-02 05:55:57.955 E QUERY_TYPE = PSQL_LOCAL, TIL = SNAPSHOT, ACCESS = READ, WAIT = WAIT:
2025-07-02 05:55:57.968 E attempted update during read-only transaction
2025-07-02 05:55:57.977 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-07-02 05:55:57.985 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-07-02 05:55:57.992 E -817
2025-07-02 05:55:57.998 E 335544361
2025-07-02 05:55:58.010 E 335544842
2025-07-02 05:55:58.022 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = NO_WAIT:
2025-07-02 05:55:58.030 E attempted update during read-only transaction
2025-07-02 05:55:58.038 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-07-02 05:55:58.045 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-07-02 05:55:58.051 E -817
2025-07-02 05:55:58.057 E 335544361
2025-07-02 05:55:58.063 E 335544842
2025-07-02 05:55:58.070 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = WAIT:
2025-07-02 05:55:58.083 E attempted update during read-only transaction
2025-07-02 05:55:58.091 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-07-02 05:55:58.101 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-07-02 05:55:58.109 E -817
2025-07-02 05:55:58.116 E 335544361
2025-07-02 05:55:58.123 E 335544842
2025-07-02 05:55:58.129 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
2025-07-02 05:55:58.136 E attempted update during read-only transaction
2025-07-02 05:55:58.142 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-07-02 05:55:58.148 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-07-02 05:55:58.155 E -817
2025-07-02 05:55:58.161 E 335544361
2025-07-02 05:55:58.166 E 335544842
2025-07-02 05:55:58.174 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
2025-07-02 05:55:58.185 E attempted update during read-only transaction
2025-07-02 05:55:58.195 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-07-02 05:55:58.204 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-07-02 05:55:58.211 E -817
2025-07-02 05:55:58.218 E 335544361
2025-07-02 05:55:58.225 E 335544842
2025-07-02 05:55:58.231 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
2025-07-02 05:55:58.236 E attempted update during read-only transaction
2025-07-02 05:55:58.242 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-07-02 05:55:58.248 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-07-02 05:55:58.254 E -817
2025-07-02 05:55:58.262 E 335544361
2025-07-02 05:55:58.268 E 335544842
2025-07-02 05:55:58.274 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
2025-07-02 05:55:58.282 E attempted update during read-only transaction
2025-07-02 05:55:58.293 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-07-02 05:55:58.302 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-07-02 05:55:58.309 E -817
2025-07-02 05:55:58.315 E 335544361
2025-07-02 05:55:58.321 E 335544842
2025-07-02 05:55:58.328 E QUERY_TYPE = PSQL_LOCAL, TIL = SERIALIZABLE, ACCESS = WRITE, WAIT = NO_WAIT:
2025-07-02 05:55:58.336 E lock conflict on no wait transaction
2025-07-02 05:55:58.344 E - -Acquire lock for relation (TEST) failed
2025-07-02 05:55:58.353 E + -Acquire lock for relation ("PUBLIC"."TEST") failed
2025-07-02 05:55:58.365 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-07-02 05:55:58.376 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-07-02 05:55:58.387 E -901
2025-07-02 05:55:58.396 E 335544345
2025-07-02 05:55:58.405 E 335544382
2025-07-02 05:55:58.412 E 335544842
2025-07-02 05:55:58.418 E QUERY_TYPE = PSQL_LOCAL, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = NO_WAIT:
2025-07-02 05:55:58.429 E ID=2
2025-07-02 05:55:58.438 E ID=3
2025-07-02 05:55:58.446 E ID=4
2025-07-02 05:55:58.453 E ID=6
2025-07-02 05:55:58.462 E ID=7
2025-07-02 05:55:58.470 E ID=8
2025-07-02 05:55:58.481 E ID=10
2025-07-02 05:55:58.491 E QUERY_TYPE = PSQL_LOCAL, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = WAIT:
2025-07-02 05:55:58.499 E ID=2
2025-07-02 05:55:58.506 E ID=3
2025-07-02 05:55:58.516 E ID=4
2025-07-02 05:55:58.526 E ID=6
2025-07-02 05:55:58.540 E ID=7
2025-07-02 05:55:58.551 E ID=8
2025-07-02 05:55:58.561 E ID=10
2025-07-02 05:55:58.571 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = NO_WAIT:
2025-07-02 05:55:58.585 E ID=2
2025-07-02 05:55:58.594 E ID=3
2025-07-02 05:55:58.604 E ID=4
2025-07-02 05:55:58.612 E ID=6
2025-07-02 05:55:58.619 E ID=7
2025-07-02 05:55:58.625 E ID=8
2025-07-02 05:55:58.639 E ID=10
2025-07-02 05:55:58.648 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = WAIT:
2025-07-02 05:55:58.655 E ID=2
2025-07-02 05:55:58.668 E ID=3
2025-07-02 05:55:58.677 E ID=4
2025-07-02 05:55:58.686 E ID=6
2025-07-02 05:55:58.698 E ID=7
2025-07-02 05:55:58.708 E ID=8
2025-07-02 05:55:58.717 E ID=10
2025-07-02 05:55:58.728 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
2025-07-02 05:55:58.738 E ID=2
2025-07-02 05:55:58.748 E ID=3
2025-07-02 05:55:58.755 E ID=4
2025-07-02 05:55:58.768 E ID=6
2025-07-02 05:55:58.782 E ID=7
2025-07-02 05:55:58.796 E ID=8
2025-07-02 05:55:58.806 E ID=10
2025-07-02 05:55:58.817 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
2025-07-02 05:55:58.829 E ID=2
2025-07-02 05:55:58.839 E ID=3
2025-07-02 05:55:58.848 E ID=4
2025-07-02 05:55:58.854 E ID=6
2025-07-02 05:55:58.861 E ID=7
2025-07-02 05:55:58.866 E ID=8
2025-07-02 05:55:58.872 E ID=10
2025-07-02 05:55:58.883 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
2025-07-02 05:55:58.894 E ID=2
2025-07-02 05:55:58.900 E ID=3
2025-07-02 05:55:58.912 E ID=4
2025-07-02 05:55:58.922 E ID=6
2025-07-02 05:55:58.933 E ID=7
2025-07-02 05:55:58.944 E ID=8
2025-07-02 05:55:58.955 E ID=10
2025-07-02 05:55:58.967 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
2025-07-02 05:55:58.978 E ID=2
2025-07-02 05:55:58.992 E ID=3
2025-07-02 05:55:59.001 E ID=4
2025-07-02 05:55:59.008 E ID=6
2025-07-02 05:55:59.014 E ID=7
2025-07-02 05:55:59.019 E ID=8
2025-07-02 05:55:59.027 E ID=10
2025-07-02 05:55:59.039 E QUERY_TYPE = PSQL_REMOTE, TIL = SERIALIZABLE, ACCESS = READ, WAIT = NO_WAIT:
2025-07-02 05:55:59.048 E Execute statement error at isc_dsql_fetch :
2025-07-02 05:55:59.057 E 335544345 : lock conflict on no wait transaction
2025-07-02 05:55:59.064 E - 335544382 : Acquire lock for relation (TEST) failed
2025-07-02 05:55:59.074 E + 335544382 : Acquire lock for relation ("PUBLIC"."TEST") failed
2025-07-02 05:55:59.095 E Statement : select id from test order by id with lock skip locked
2025-07-02 05:55:59.104 E Data source : Firebird::localhost:
2025-07-02 05:55:59.116 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-07-02 05:55:59.128 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-07-02 05:55:59.138 E -901
2025-07-02 05:55:59.150 E 335544926
2025-07-02 05:55:59.160 E 335544842
2025-07-02 05:55:59.167 E QUERY_TYPE = PSQL_REMOTE, TIL = SNAPSHOT, ACCESS = READ, WAIT = NO_WAIT:
2025-07-02 05:55:59.174 E Execute statement error at isc_dsql_fetch :
2025-07-02 05:55:59.181 E 335544361 : attempted update during read-only transaction
2025-07-02 05:55:59.187 E Statement : select id from test order by id with lock skip locked
2025-07-02 05:55:59.194 E Data source : Firebird::localhost:
2025-07-02 05:55:59.205 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-07-02 05:55:59.218 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-07-02 05:55:59.224 E -901
2025-07-02 05:55:59.238 E 335544926
2025-07-02 05:55:59.250 E 335544842
2025-07-02 05:55:59.261 E QUERY_TYPE = PSQL_REMOTE, TIL = SNAPSHOT, ACCESS = READ, WAIT = WAIT:
2025-07-02 05:55:59.275 E Execute statement error at isc_dsql_fetch :
2025-07-02 05:55:59.284 E 335544361 : attempted update during read-only transaction
2025-07-02 05:55:59.299 E Statement : select id from test order by id with lock skip locked
2025-07-02 05:55:59.310 E Data source : Firebird::localhost:
2025-07-02 05:55:59.320 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-07-02 05:55:59.330 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-07-02 05:55:59.344 E -901
2025-07-02 05:55:59.355 E 335544926
2025-07-02 05:55:59.365 E 335544842
2025-07-02 05:55:59.378 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = NO_WAIT:
2025-07-02 05:55:59.386 E Execute statement error at isc_dsql_fetch :
2025-07-02 05:55:59.395 E 335544361 : attempted update during read-only transaction
2025-07-02 05:55:59.402 E Statement : select id from test order by id with lock skip locked
2025-07-02 05:55:59.416 E Data source : Firebird::localhost:
2025-07-02 05:55:59.425 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-07-02 05:55:59.434 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-07-02 05:55:59.447 E -901
2025-07-02 05:55:59.457 E 335544926
2025-07-02 05:55:59.464 E 335544842
2025-07-02 05:55:59.475 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = WAIT:
2025-07-02 05:55:59.490 E Execute statement error at isc_dsql_fetch :
2025-07-02 05:55:59.502 E 335544361 : attempted update during read-only transaction
2025-07-02 05:55:59.510 E Statement : select id from test order by id with lock skip locked
2025-07-02 05:55:59.517 E Data source : Firebird::localhost:
2025-07-02 05:55:59.525 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-07-02 05:55:59.532 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-07-02 05:55:59.538 E -901
2025-07-02 05:55:59.545 E 335544926
2025-07-02 05:55:59.553 E 335544842
2025-07-02 05:55:59.563 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
2025-07-02 05:55:59.571 E Execute statement error at isc_dsql_fetch :
2025-07-02 05:55:59.579 E 335544361 : attempted update during read-only transaction
2025-07-02 05:55:59.586 E Statement : select id from test order by id with lock skip locked
2025-07-02 05:55:59.594 E Data source : Firebird::localhost:
2025-07-02 05:55:59.605 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-07-02 05:55:59.614 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-07-02 05:55:59.621 E -901
2025-07-02 05:55:59.627 E 335544926
2025-07-02 05:55:59.636 E 335544842
2025-07-02 05:55:59.648 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
2025-07-02 05:55:59.656 E Execute statement error at isc_dsql_fetch :
2025-07-02 05:55:59.666 E 335544361 : attempted update during read-only transaction
2025-07-02 05:55:59.679 E Statement : select id from test order by id with lock skip locked
2025-07-02 05:55:59.690 E Data source : Firebird::localhost:
2025-07-02 05:55:59.698 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-07-02 05:55:59.709 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-07-02 05:55:59.717 E -901
2025-07-02 05:55:59.724 E 335544926
2025-07-02 05:55:59.735 E 335544842
2025-07-02 05:55:59.746 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
2025-07-02 05:55:59.755 E Execute statement error at isc_dsql_fetch :
2025-07-02 05:55:59.763 E 335544361 : attempted update during read-only transaction
2025-07-02 05:55:59.771 E Statement : select id from test order by id with lock skip locked
2025-07-02 05:55:59.777 E Data source : Firebird::localhost:
2025-07-02 05:55:59.784 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-07-02 05:55:59.790 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-07-02 05:55:59.796 E -901
2025-07-02 05:55:59.803 E 335544926
2025-07-02 05:55:59.809 E 335544842
2025-07-02 05:55:59.818 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
2025-07-02 05:55:59.830 E Execute statement error at isc_dsql_fetch :
2025-07-02 05:55:59.839 E 335544361 : attempted update during read-only transaction
2025-07-02 05:55:59.847 E Statement : select id from test order by id with lock skip locked
2025-07-02 05:55:59.855 E Data source : Firebird::localhost:
2025-07-02 05:55:59.868 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-07-02 05:55:59.877 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-07-02 05:55:59.889 E -901
2025-07-02 05:55:59.899 E 335544926
2025-07-02 05:55:59.907 E 335544842
2025-07-02 05:55:59.914 E QUERY_TYPE = PSQL_REMOTE, TIL = SERIALIZABLE, ACCESS = WRITE, WAIT = NO_WAIT:
2025-07-02 05:55:59.919 E Execute statement error at isc_dsql_fetch :
2025-07-02 05:55:59.926 E 335544345 : lock conflict on no wait transaction
2025-07-02 05:55:59.933 E - 335544382 : Acquire lock for relation (TEST) failed
2025-07-02 05:55:59.941 E + 335544382 : Acquire lock for relation ("PUBLIC"."TEST") failed
2025-07-02 05:55:59.953 E Statement : select id from test order by id with lock skip locked
2025-07-02 05:55:59.959 E Data source : Firebird::localhost:
2025-07-02 05:55:59.967 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-07-02 05:55:59.974 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-07-02 05:55:59.984 E -901
2025-07-02 05:55:59.992 E 335544926
2025-07-02 05:55:59.998 E 335544842
2025-07-02 05:56:00.004 E QUERY_TYPE = PSQL_REMOTE, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = NO_WAIT:
2025-07-02 05:56:00.009 E ID=2
2025-07-02 05:56:00.014 E ID=3
2025-07-02 05:56:00.019 E ID=4
2025-07-02 05:56:00.027 E ID=6
2025-07-02 05:56:00.035 E ID=7
2025-07-02 05:56:00.042 E ID=8
2025-07-02 05:56:00.047 E ID=10
2025-07-02 05:56:00.053 E QUERY_TYPE = PSQL_REMOTE, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = WAIT:
2025-07-02 05:56:00.059 E ID=2
2025-07-02 05:56:00.067 E ID=3
2025-07-02 05:56:00.077 E ID=4
2025-07-02 05:56:00.087 E ID=6
2025-07-02 05:56:00.097 E ID=7
2025-07-02 05:56:00.110 E ID=8
2025-07-02 05:56:00.121 E ID=10
2025-07-02 05:56:00.134 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = NO_WAIT:
2025-07-02 05:56:00.145 E ID=2
2025-07-02 05:56:00.152 E ID=3
2025-07-02 05:56:00.158 E ID=4
2025-07-02 05:56:00.165 E ID=6
2025-07-02 05:56:00.174 E ID=7
2025-07-02 05:56:00.182 E ID=8
2025-07-02 05:56:00.193 E ID=10
2025-07-02 05:56:00.202 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = WAIT:
2025-07-02 05:56:00.210 E ID=2
2025-07-02 05:56:00.221 E ID=3
2025-07-02 05:56:00.233 E ID=4
2025-07-02 05:56:00.246 E ID=6
2025-07-02 05:56:00.257 E ID=7
2025-07-02 05:56:00.266 E ID=8
2025-07-02 05:56:00.275 E ID=10
2025-07-02 05:56:00.289 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
2025-07-02 05:56:00.301 E ID=2
2025-07-02 05:56:00.311 E ID=3
2025-07-02 05:56:00.319 E ID=4
2025-07-02 05:56:00.327 E ID=6
2025-07-02 05:56:00.335 E ID=7
2025-07-02 05:56:00.341 E ID=8
2025-07-02 05:56:00.354 E ID=10
2025-07-02 05:56:00.364 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
2025-07-02 05:56:00.378 E ID=2
2025-07-02 05:56:00.386 E ID=3
2025-07-02 05:56:00.395 E ID=4
2025-07-02 05:56:00.403 E ID=6
2025-07-02 05:56:00.408 E ID=7
2025-07-02 05:56:00.418 E ID=8
2025-07-02 05:56:00.426 E ID=10
2025-07-02 05:56:00.435 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
2025-07-02 05:56:00.444 E ID=2
2025-07-02 05:56:00.453 E ID=3
2025-07-02 05:56:00.460 E ID=4
2025-07-02 05:56:00.465 E ID=6
2025-07-02 05:56:00.471 E ID=7
2025-07-02 05:56:00.478 E ID=8
2025-07-02 05:56:00.484 E ID=10
2025-07-02 05:56:00.492 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
2025-07-02 05:56:00.500 E ID=2
2025-07-02 05:56:00.507 E ID=3
2025-07-02 05:56:00.514 E ID=4
2025-07-02 05:56:00.522 E ID=6
2025-07-02 05:56:00.535 E ID=7
2025-07-02 05:56:00.544 E ID=8
2025-07-02 05:56:00.557 E ID=10
2025-07-02 05:56:00.566
2025-07-02 05:56:00.575 tests/bugs/gh_7350_test.py:544: AssertionError
2025-07-02 05:56:00.583 ---------------------------- Captured stdout setup -----------------------------
2025-07-02 05:56:00.590 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
|