2 @message |
assert
QUERY_TYPE = DSQL, TIL = SERIALIZABLE, ACCESS = READ, WAIT = NO_WAIT:
lock conflict on no wait transaction
- -Acquire lock for relation (TEST) failed
+ -Acquire lock for relation ("PUBLIC"."TEST") failed
-901
335544345
335544382
QUERY_TYPE = DSQL, TIL = SNAPSHOT, ACCESS = READ, WAIT = NO_WAIT:
attempted update during read-only transaction
-817
335544361
QUERY_TYPE = DSQL, TIL = SNAPSHOT, ACCESS = READ, WAIT = WAIT:
attempted update during read-only transaction
-817
335544361
QUERY_TYPE = DSQL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = NO_WAIT:
attempted update during read-only transaction
-817
335544361
QUERY_TYPE = DSQL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = WAIT:
attempted update during read-only transaction
-817
335544361
QUERY_TYPE = DSQL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
attempted update during read-only transaction
-817
335544361
QUERY_TYPE = DSQL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
attempted update during read-only transaction
-817
335544361
QUERY_TYPE = DSQL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
attempted update during read-only transaction
-817
335544361
QUERY_TYPE = DSQL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
attempted update during read-only transaction
-817
335544361
QUERY_TYPE = DSQL, TIL = SERIALIZABLE, ACCESS = WRITE, WAIT = NO_WAIT:
lock conflict on no wait transaction
- -Acquire lock for relation (TEST) failed
+ -Acquire lock for relation ("PUBLIC"."TEST") failed
-901
335544345
335544382
QUERY_TYPE = DSQL, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = NO_WAIT:
ID=2
ID=3
ID=4
ID=6
ID=7
ID=8
ID=10
QUERY_TYPE = DSQL, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = WAIT:
ID=2
ID=3
ID=4
ID=6
ID=7
ID=8
ID=10
QUERY_TYPE = DSQL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = NO_WAIT:
ID=2
ID=3
ID=4
ID=6
ID=7
ID=8
ID=10
QUERY_TYPE = DSQL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = WAIT:
ID=2
ID=3
ID=4
ID=6
ID=7
ID=8
ID=10
QUERY_TYPE = DSQL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
ID=2
ID=3
ID=4
ID=6
ID=7
ID=8
ID=10
QUERY_TYPE = DSQL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
ID=2
ID=3
ID=4
ID=6
ID=7
ID=8
ID=10
QUERY_TYPE = DSQL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
ID=2
ID=3
ID=4
ID=6
ID=7
ID=8
ID=10
QUERY_TYPE = DSQL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
ID=2
ID=3
ID=4
ID=6
ID=7
ID=8
ID=10
QUERY_TYPE = PSQL_LOCAL, TIL = SERIALIZABLE, ACCESS = READ, WAIT = NO_WAIT:
lock conflict on no wait transaction
- -Acquire lock for relation (TEST) failed
+ -Acquire lock for relation ("PUBLIC"."TEST") failed
- -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
+ -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
-901
335544345
335544382
335544842
QUERY_TYPE = PSQL_LOCAL, TIL = SNAPSHOT, ACCESS = READ, WAIT = NO_WAIT:
attempted update during read-only transaction
- -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
+ -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
-817
335544361
335544842
QUERY_TYPE = PSQL_LOCAL, TIL = SNAPSHOT, ACCESS = READ, WAIT = WAIT:
attempted update during read-only transaction
- -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
+ -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
-817
335544361
335544842
QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = NO_WAIT:
attempted update during read-only transaction
- -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
+ -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
-817
335544361
335544842
QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = WAIT:
attempted update during read-only transaction
- -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
+ -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
-817
335544361
335544842
QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
attempted update during read-only transaction
- -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
+ -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
-817
335544361
335544842
QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
attempted update during read-only transaction
- -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
+ -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
-817
335544361
335544842
QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
attempted update during read-only transaction
- -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
+ -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
-817
335544361
335544842
QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
attempted update during read-only transaction
- -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
+ -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
-817
335544361
335544842
QUERY_TYPE = PSQL_LOCAL, TIL = SERIALIZABLE, ACCESS = WRITE, WAIT = NO_WAIT:
lock conflict on no wait transaction
- -Acquire lock for relation (TEST) failed
+ -Acquire lock for relation ("PUBLIC"."TEST") failed
- -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
+ -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
-901
335544345
335544382
335544842
QUERY_TYPE = PSQL_LOCAL, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = NO_WAIT:
ID=2
ID=3
ID=4
ID=6
ID=7
ID=8
ID=10
QUERY_TYPE = PSQL_LOCAL, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = WAIT:
ID=2
ID=3
ID=4
ID=6
ID=7
ID=8
ID=10
QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = NO_WAIT:
ID=2
ID=3
ID=4
ID=6
ID=7
ID=8
ID=10
QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = WAIT:
ID=2
ID=3
ID=4
ID=6
ID=7
ID=8
ID=10
QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
ID=2
ID=3
ID=4
ID=6
ID=7
ID=8
ID=10
QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
ID=2
ID=3
ID=4
ID=6
ID=7
ID=8
ID=10
QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
ID=2
ID=3
ID=4
ID=6
ID=7
ID=8
ID=10
QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
ID=2
ID=3
ID=4
ID=6
ID=7
ID=8
ID=10
QUERY_TYPE = PSQL_REMOTE, TIL = SERIALIZABLE, ACCESS = READ, WAIT = NO_WAIT:
Execute statement error at isc_dsql_fetch :
335544345 : lock conflict on no wait transaction
- 335544382 : Acquire lock for relation (TEST) failed
+ 335544382 : Acquire lock for relation ("PUBLIC"."TEST") failed
Statement : select id from test order by id with lock skip locked
Data source : Firebird::localhost:
- -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
+ -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
-901
335544926
335544842
QUERY_TYPE = PSQL_REMOTE, TIL = SNAPSHOT, ACCESS = READ, WAIT = NO_WAIT:
Execute statement error at isc_dsql_fetch :
335544361 : attempted update during read-only transaction
Statement : select id from test order by id with lock skip locked
Data source : Firebird::localhost:
- -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
+ -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
-901
335544926
335544842
QUERY_TYPE = PSQL_REMOTE, TIL = SNAPSHOT, ACCESS = READ, WAIT = WAIT:
Execute statement error at isc_dsql_fetch :
335544361 : attempted update during read-only transaction
Statement : select id from test order by id with lock skip locked
Data source : Firebird::localhost:
- -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
+ -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
-901
335544926
335544842
QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = NO_WAIT:
Execute statement error at isc_dsql_fetch :
335544361 : attempted update during read-only transaction
Statement : select id from test order by id with lock skip locked
Data source : Firebird::localhost:
- -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
+ -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
-901
335544926
335544842
QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = WAIT:
Execute statement error at isc_dsql_fetch :
335544361 : attempted update during read-only transaction
Statement : select id from test order by id with lock skip locked
Data source : Firebird::localhost:
- -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
+ -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
-901
335544926
335544842
QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
Execute statement error at isc_dsql_fetch :
335544361 : attempted update during read-only transaction
Statement : select id from test order by id with lock skip locked
Data source : Firebird::localhost:
- -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
+ -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
-901
335544926
335544842
QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
Execute statement error at isc_dsql_fetch :
335544361 : attempted update during read-only transaction
Statement : select id from test order by id with lock skip locked
Data source : Firebird::localhost:
- -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
+ -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
-901
335544926
335544842
QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
Execute statement error at isc_dsql_fetch :
335544361 : attempted update during read-only transaction
Statement : select id from test order by id with lock skip locked
Data source : Firebird::localhost:
- -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
+ -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
-901
335544926
335544842
QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
Execute statement error at isc_dsql_fetch :
335544361 : attempted update during read-only transaction
Statement : select id from test order by id with lock skip locked
Data source : Firebird::localhost:
- -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
+ -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
-901
335544926
335544842
QUERY_TYPE = PSQL_REMOTE, TIL = SERIALIZABLE, ACCESS = WRITE, WAIT = NO_WAIT:
Execute statement error at isc_dsql_fetch :
335544345 : lock conflict on no wait transaction
- 335544382 : Acquire lock for relation (TEST) failed
+ 335544382 : Acquire lock for relation ("PUBLIC"."TEST") failed
Statement : select id from test order by id with lock skip locked
Data source : Firebird::localhost:
- -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
+ -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
-901
335544926
335544842
QUERY_TYPE = PSQL_REMOTE, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = NO_WAIT:
ID=2
ID=3
ID=4
ID=6
ID=7
ID=8
ID=10
QUERY_TYPE = PSQL_REMOTE, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = WAIT:
ID=2
ID=3
ID=4
ID=6
ID=7
ID=8
ID=10
QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = NO_WAIT:
ID=2
ID=3
ID=4
ID=6
ID=7
ID=8
ID=10
QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = WAIT:
ID=2
ID=3
ID=4
ID=6
ID=7
ID=8
ID=10
QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
ID=2
ID=3
ID=4
ID=6
ID=7
ID=8
ID=10
QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
ID=2
ID=3
ID=4
ID=6
ID=7
ID=8
ID=10
QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
ID=2
ID=3
ID=4
ID=6
ID=7
ID=8
ID=10
QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
ID=2
ID=3
ID=4
ID=6
ID=7
ID=8
ID=10
LOG DETAILS:
2025-06-28 05:16:13.457
2025-06-28 05:16:13.468 act = <firebird.qa.plugin.Action object at [hex]>
2025-06-28 05:16:13.474 capsys = <_pytest.capture.CaptureFixture object at [hex]>
2025-06-28 05:16:13.480
2025-06-28 05:16:13.485 @pytest.mark.es_eds
2025-06-28 05:16:13.491 @pytest.mark.version('>=5.0')
2025-06-28 05:16:13.497 def test_1(act: Action, capsys):
2025-06-28 05:16:13.503
2025-06-28 05:16:13.508 init_sql = f"""
2025-06-28 05:16:13.514 set term ^;
2025-06-28 05:16:13.520 recreate table test(id int primary key, f01 int)
2025-06-28 05:16:13.526 -- recreate global temporary table test(id int primary key, f01 int) on commit preserve rows
2025-06-28 05:16:13.532 ^
2025-06-28 05:16:13.539 create or alter procedure sp_get_unlocked_rows_local returns(id int) as
2025-06-28 05:16:13.545 begin
2025-06-28 05:16:13.552 for
2025-06-28 05:16:13.558 {CHECK_SQL}
2025-06-28 05:16:13.564 into id
2025-06-28 05:16:13.573 do
2025-06-28 05:16:13.584 suspend;
2025-06-28 05:16:13.592 end
2025-06-28 05:16:13.599 ^
2025-06-28 05:16:13.605 create or alter procedure sp_get_unlocked_rows_remote returns(id int) as
2025-06-28 05:16:13.609 begin
2025-06-28 05:16:13.614 for
2025-06-28 05:16:13.619 execute statement '{CHECK_SQL}'
2025-06-28 05:16:13.623 on external 'localhost:' || rdb$get_context('SYSTEM', 'DB_NAME')
2025-06-28 05:16:13.628 as user '{act.db.user}' password '{act.db.password}'
2025-06-28 05:16:13.632 into id
2025-06-28 05:16:13.637 do
2025-06-28 05:16:13.641 suspend;
2025-06-28 05:16:13.647 end
2025-06-28 05:16:13.655 ^
2025-06-28 05:16:13.665 set term ;^
2025-06-28 05:16:13.676 commit;
2025-06-28 05:16:13.685
2025-06-28 05:16:13.693 insert into test(id, f01) select row_number()over(), 0 from rdb$types rows 10;
2025-06-28 05:16:13.700 commit;
2025-06-28 05:16:13.706 """
2025-06-28 05:16:13.712 act.isql(switches=['-q'], input = init_sql, combine_output = True)
2025-06-28 05:16:13.718 assert act.clean_stdout == ''
2025-06-28 05:16:13.724 act.reset()
2025-06-28 05:16:13.731
2025-06-28 05:16:13.743 tpb_isol_set = (Isolation.SERIALIZABLE, Isolation.SNAPSHOT, Isolation.READ_COMMITTED_READ_CONSISTENCY, Isolation.READ_COMMITTED_RECORD_VERSION, Isolation.READ_COMMITTED_NO_RECORD_VERSION)
2025-06-28 05:16:13.752 tpb_wait_set = (TraLockResolution.NO_WAIT,TraLockResolution.WAIT)
2025-06-28 05:16:13.759 tpb_mode_set = (TraAccessMode.READ, TraAccessMode.WRITE)
2025-06-28 05:16:13.768 query_types_set = ('DSQL', 'PSQL_LOCAL', 'PSQL_REMOTE')
2025-06-28 05:16:13.779
2025-06-28 05:16:13.787 with act.db.connect() as con_rows_locker, act.db.connect() as con_free_seeker:
2025-06-28 05:16:13.792 con_rows_locker.execute_immediate('update test set f01 = 1 where id in (1,5,9)')
2025-06-28 05:16:13.799 for query_type in query_types_set:
2025-06-28 05:16:13.810 for x_mode in tpb_mode_set:
2025-06-28 05:16:13.823 for x_isol in tpb_isol_set:
2025-06-28 05:16:13.832 for x_wait in tpb_wait_set:
2025-06-28 05:16:13.841 skip_flag = x_isol in (Isolation.SERIALIZABLE,) and x_wait == TraLockResolution.WAIT
2025-06-28 05:16:13.849 if skip_flag:
2025-06-28 05:16:13.855
2025-06-28 05:16:13.861 #######################################
2025-06-28 05:16:13.867 ### D O N O T C H E C K ###
2025-06-28 05:16:13.874 #######################################
2025-06-28 05:16:13.881 #
2025-06-28 05:16:13.892 # 1. Isolation.SERIALIZABLE requires that the whole table must not be changed by anyone else.
2025-06-28 05:16:13.902 # 2. [WAS ACTUAL BEFORE GH-7810 FIXED; CURRENTLY REMAINS NEEDED FB 5.X]
2025-06-28 05:16:13.910 # Isolation.READ_COMMITTED_NO_RECORD_VERSION can not be used due to implementation details, see:
2025-06-28 05:16:13.921 # Adriano, 26-feb-2023, https://github.com/FirebirdSQL/firebird/pull/7350#issuecomment-1445408462
2025-06-28 05:16:13.932 # "WITH LOCK [SKIP LOCKED] needs a record read before, but this locked records cannot be read with NO RECORD VERSION.
2025-06-28 05:16:13.940 # Considering that this transaction mode is replaced by default I would only document it as in fact I don't think
2025-06-28 05:16:13.948 # there are anything we could do."
2025-06-28 05:16:13.955
2025-06-28 05:16:13.961 continue
2025-06-28 05:16:13.967
2025-06-28 05:16:13.975 custom_tpb = tpb(isolation = x_isol, access_mode = x_mode, lock_timeout = -1 if x_wait == TraLockResolution.WAIT else 0)
2025-06-28 05:16:13.986 #custom_tpb = TPB(isolation = x_isol, access_mode = x_mode, lock_timeout = 0).get_buffer()
2025-06-28 05:16:13.995 tx_free_seeker = con_free_seeker.transaction_manager(custom_tpb)
2025-06-28 05:16:14.003 cur_free_seeker = tx_free_seeker.cursor()
2025-06-28 05:16:14.011 tx_free_seeker.begin()
2025-06-28 05:16:14.017 try:
2025-06-28 05:16:14.026 print('\n')
2025-06-28 05:16:14.038 print(f'QUERY_TYPE = {query_type}, TIL = {x_isol.name}, ACCESS = {x_mode.name}, WAIT = {x_wait.name}:')
2025-06-28 05:16:14.047 if query_type == 'DSQL':
2025-06-28 05:16:14.056 cur_free_seeker.execute(f'{CHECK_SQL}')
2025-06-28 05:16:14.064 elif query_type == 'PSQL_LOCAL':
2025-06-28 05:16:14.072 cur_free_seeker.execute('select id from sp_get_unlocked_rows_local')
2025-06-28 05:16:14.079 elif query_type == 'PSQL_REMOTE':
2025-06-28 05:16:14.086 cur_free_seeker.execute('select id from sp_get_unlocked_rows_remote')
2025-06-28 05:16:14.092 for r in cur_free_seeker:
2025-06-28 05:16:14.099 print('ID='+str(r[0]))
2025-06-28 05:16:14.105 except DatabaseError as e:
2025-06-28 05:16:14.111 print(e.__str__())
2025-06-28 05:16:14.118 print(e.sqlcode)
2025-06-28 05:16:14.131 for g in e.gds_codes:
2025-06-28 05:16:14.141 print(g)
2025-06-28 05:16:14.148 finally:
2025-06-28 05:16:14.155 tx_free_seeker.rollback()
2025-06-28 05:16:14.161
2025-06-28 05:16:14.168 act.expected_stdout = expected_stdout
2025-06-28 05:16:14.175 act.stdout = capsys.readouterr().out
2025-06-28 05:16:14.182 > assert act.clean_stdout == act.clean_expected_stdout
2025-06-28 05:16:14.189 E assert
2025-06-28 05:16:14.194 E QUERY_TYPE = DSQL, TIL = SERIALIZABLE, ACCESS = READ, WAIT = NO_WAIT:
2025-06-28 05:16:14.199 E lock conflict on no wait transaction
2025-06-28 05:16:14.204 E - -Acquire lock for relation (TEST) failed
2025-06-28 05:16:14.209 E + -Acquire lock for relation ("PUBLIC"."TEST") failed
2025-06-28 05:16:14.219 E -901
2025-06-28 05:16:14.224 E 335544345
2025-06-28 05:16:14.229 E 335544382
2025-06-28 05:16:14.235 E QUERY_TYPE = DSQL, TIL = SNAPSHOT, ACCESS = READ, WAIT = NO_WAIT:
2025-06-28 05:16:14.241 E attempted update during read-only transaction
2025-06-28 05:16:14.247 E -817
2025-06-28 05:16:14.253 E 335544361
2025-06-28 05:16:14.260 E QUERY_TYPE = DSQL, TIL = SNAPSHOT, ACCESS = READ, WAIT = WAIT:
2025-06-28 05:16:14.267 E attempted update during read-only transaction
2025-06-28 05:16:14.273 E -817
2025-06-28 05:16:14.279 E 335544361
2025-06-28 05:16:14.286 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = NO_WAIT:
2025-06-28 05:16:14.296 E attempted update during read-only transaction
2025-06-28 05:16:14.310 E -817
2025-06-28 05:16:14.319 E 335544361
2025-06-28 05:16:14.328 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = WAIT:
2025-06-28 05:16:14.335 E attempted update during read-only transaction
2025-06-28 05:16:14.342 E -817
2025-06-28 05:16:14.349 E 335544361
2025-06-28 05:16:14.358 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
2025-06-28 05:16:14.368 E attempted update during read-only transaction
2025-06-28 05:16:14.376 E -817
2025-06-28 05:16:14.384 E 335544361
2025-06-28 05:16:14.391 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
2025-06-28 05:16:14.398 E attempted update during read-only transaction
2025-06-28 05:16:14.403 E -817
2025-06-28 05:16:14.408 E 335544361
2025-06-28 05:16:14.413 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
2025-06-28 05:16:14.418 E attempted update during read-only transaction
2025-06-28 05:16:14.423 E -817
2025-06-28 05:16:14.428 E 335544361
2025-06-28 05:16:14.433 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
2025-06-28 05:16:14.438 E attempted update during read-only transaction
2025-06-28 05:16:14.443 E -817
2025-06-28 05:16:14.447 E 335544361
2025-06-28 05:16:14.452 E QUERY_TYPE = DSQL, TIL = SERIALIZABLE, ACCESS = WRITE, WAIT = NO_WAIT:
2025-06-28 05:16:14.457 E lock conflict on no wait transaction
2025-06-28 05:16:14.462 E - -Acquire lock for relation (TEST) failed
2025-06-28 05:16:14.467 E + -Acquire lock for relation ("PUBLIC"."TEST") failed
2025-06-28 05:16:14.477 E -901
2025-06-28 05:16:14.481 E 335544345
2025-06-28 05:16:14.486 E 335544382
2025-06-28 05:16:14.491 E QUERY_TYPE = DSQL, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = NO_WAIT:
2025-06-28 05:16:14.496 E ID=2
2025-06-28 05:16:14.501 E ID=3
2025-06-28 05:16:14.505 E ID=4
2025-06-28 05:16:14.510 E ID=6
2025-06-28 05:16:14.514 E ID=7
2025-06-28 05:16:14.519 E ID=8
2025-06-28 05:16:14.523 E ID=10
2025-06-28 05:16:14.528 E QUERY_TYPE = DSQL, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = WAIT:
2025-06-28 05:16:14.533 E ID=2
2025-06-28 05:16:14.537 E ID=3
2025-06-28 05:16:14.542 E ID=4
2025-06-28 05:16:14.546 E ID=6
2025-06-28 05:16:14.551 E ID=7
2025-06-28 05:16:14.556 E ID=8
2025-06-28 05:16:14.560 E ID=10
2025-06-28 05:16:14.565 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = NO_WAIT:
2025-06-28 05:16:14.570 E ID=2
2025-06-28 05:16:14.574 E ID=3
2025-06-28 05:16:14.579 E ID=4
2025-06-28 05:16:14.583 E ID=6
2025-06-28 05:16:14.588 E ID=7
2025-06-28 05:16:14.592 E ID=8
2025-06-28 05:16:14.597 E ID=10
2025-06-28 05:16:14.602 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = WAIT:
2025-06-28 05:16:14.606 E ID=2
2025-06-28 05:16:14.611 E ID=3
2025-06-28 05:16:14.616 E ID=4
2025-06-28 05:16:14.620 E ID=6
2025-06-28 05:16:14.625 E ID=7
2025-06-28 05:16:14.630 E ID=8
2025-06-28 05:16:14.634 E ID=10
2025-06-28 05:16:14.641 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
2025-06-28 05:16:14.646 E ID=2
2025-06-28 05:16:14.651 E ID=3
2025-06-28 05:16:14.656 E ID=4
2025-06-28 05:16:14.660 E ID=6
2025-06-28 05:16:14.665 E ID=7
2025-06-28 05:16:14.671 E ID=8
2025-06-28 05:16:14.677 E ID=10
2025-06-28 05:16:14.689 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
2025-06-28 05:16:14.703 E ID=2
2025-06-28 05:16:14.713 E ID=3
2025-06-28 05:16:14.723 E ID=4
2025-06-28 05:16:14.735 E ID=6
2025-06-28 05:16:14.745 E ID=7
2025-06-28 05:16:14.751 E ID=8
2025-06-28 05:16:14.757 E ID=10
2025-06-28 05:16:14.762 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
2025-06-28 05:16:14.767 E ID=2
2025-06-28 05:16:14.771 E ID=3
2025-06-28 05:16:14.776 E ID=4
2025-06-28 05:16:14.781 E ID=6
2025-06-28 05:16:14.786 E ID=7
2025-06-28 05:16:14.791 E ID=8
2025-06-28 05:16:14.795 E ID=10
2025-06-28 05:16:14.800 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
2025-06-28 05:16:14.805 E ID=2
2025-06-28 05:16:14.810 E ID=3
2025-06-28 05:16:14.814 E ID=4
2025-06-28 05:16:14.819 E ID=6
2025-06-28 05:16:14.824 E ID=7
2025-06-28 05:16:14.828 E ID=8
2025-06-28 05:16:14.833 E ID=10
2025-06-28 05:16:14.838 E QUERY_TYPE = PSQL_LOCAL, TIL = SERIALIZABLE, ACCESS = READ, WAIT = NO_WAIT:
2025-06-28 05:16:14.843 E lock conflict on no wait transaction
2025-06-28 05:16:14.849 E - -Acquire lock for relation (TEST) failed
2025-06-28 05:16:14.863 E + -Acquire lock for relation ("PUBLIC"."TEST") failed
2025-06-28 05:16:14.879 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-06-28 05:16:14.886 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-06-28 05:16:14.898 E -901
2025-06-28 05:16:14.911 E 335544345
2025-06-28 05:16:14.922 E 335544382
2025-06-28 05:16:14.931 E 335544842
2025-06-28 05:16:14.940 E QUERY_TYPE = PSQL_LOCAL, TIL = SNAPSHOT, ACCESS = READ, WAIT = NO_WAIT:
2025-06-28 05:16:14.946 E attempted update during read-only transaction
2025-06-28 05:16:14.953 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-06-28 05:16:14.961 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-06-28 05:16:14.967 E -817
2025-06-28 05:16:14.972 E 335544361
2025-06-28 05:16:14.978 E 335544842
2025-06-28 05:16:14.983 E QUERY_TYPE = PSQL_LOCAL, TIL = SNAPSHOT, ACCESS = READ, WAIT = WAIT:
2025-06-28 05:16:14.989 E attempted update during read-only transaction
2025-06-28 05:16:14.994 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-06-28 05:16:15.004 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-06-28 05:16:15.016 E -817
2025-06-28 05:16:15.026 E 335544361
2025-06-28 05:16:15.033 E 335544842
2025-06-28 05:16:15.040 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = NO_WAIT:
2025-06-28 05:16:15.047 E attempted update during read-only transaction
2025-06-28 05:16:15.053 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-06-28 05:16:15.058 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-06-28 05:16:15.064 E -817
2025-06-28 05:16:15.070 E 335544361
2025-06-28 05:16:15.076 E 335544842
2025-06-28 05:16:15.081 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = WAIT:
2025-06-28 05:16:15.086 E attempted update during read-only transaction
2025-06-28 05:16:15.091 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-06-28 05:16:15.096 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-06-28 05:16:15.101 E -817
2025-06-28 05:16:15.106 E 335544361
2025-06-28 05:16:15.111 E 335544842
2025-06-28 05:16:15.116 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
2025-06-28 05:16:15.121 E attempted update during read-only transaction
2025-06-28 05:16:15.126 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-06-28 05:16:15.132 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-06-28 05:16:15.140 E -817
2025-06-28 05:16:15.152 E 335544361
2025-06-28 05:16:15.160 E 335544842
2025-06-28 05:16:15.170 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
2025-06-28 05:16:15.176 E attempted update during read-only transaction
2025-06-28 05:16:15.182 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-06-28 05:16:15.188 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-06-28 05:16:15.193 E -817
2025-06-28 05:16:15.204 E 335544361
2025-06-28 05:16:15.214 E 335544842
2025-06-28 05:16:15.224 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
2025-06-28 05:16:15.234 E attempted update during read-only transaction
2025-06-28 05:16:15.243 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-06-28 05:16:15.251 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-06-28 05:16:15.259 E -817
2025-06-28 05:16:15.270 E 335544361
2025-06-28 05:16:15.282 E 335544842
2025-06-28 05:16:15.293 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
2025-06-28 05:16:15.303 E attempted update during read-only transaction
2025-06-28 05:16:15.314 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-06-28 05:16:15.324 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-06-28 05:16:15.332 E -817
2025-06-28 05:16:15.340 E 335544361
2025-06-28 05:16:15.347 E 335544842
2025-06-28 05:16:15.355 E QUERY_TYPE = PSQL_LOCAL, TIL = SERIALIZABLE, ACCESS = WRITE, WAIT = NO_WAIT:
2025-06-28 05:16:15.363 E lock conflict on no wait transaction
2025-06-28 05:16:15.377 E - -Acquire lock for relation (TEST) failed
2025-06-28 05:16:15.389 E + -Acquire lock for relation ("PUBLIC"."TEST") failed
2025-06-28 05:16:15.412 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-06-28 05:16:15.420 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-06-28 05:16:15.426 E -901
2025-06-28 05:16:15.435 E 335544345
2025-06-28 05:16:15.447 E 335544382
2025-06-28 05:16:15.459 E 335544842
2025-06-28 05:16:15.467 E QUERY_TYPE = PSQL_LOCAL, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = NO_WAIT:
2025-06-28 05:16:15.474 E ID=2
2025-06-28 05:16:15.479 E ID=3
2025-06-28 05:16:15.485 E ID=4
2025-06-28 05:16:15.491 E ID=6
2025-06-28 05:16:15.498 E ID=7
2025-06-28 05:16:15.504 E ID=8
2025-06-28 05:16:15.511 E ID=10
2025-06-28 05:16:15.517 E QUERY_TYPE = PSQL_LOCAL, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = WAIT:
2025-06-28 05:16:15.522 E ID=2
2025-06-28 05:16:15.534 E ID=3
2025-06-28 05:16:15.547 E ID=4
2025-06-28 05:16:15.557 E ID=6
2025-06-28 05:16:15.566 E ID=7
2025-06-28 05:16:15.573 E ID=8
2025-06-28 05:16:15.583 E ID=10
2025-06-28 05:16:15.591 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = NO_WAIT:
2025-06-28 05:16:15.599 E ID=2
2025-06-28 05:16:15.606 E ID=3
2025-06-28 05:16:15.616 E ID=4
2025-06-28 05:16:15.625 E ID=6
2025-06-28 05:16:15.633 E ID=7
2025-06-28 05:16:15.640 E ID=8
2025-06-28 05:16:15.649 E ID=10
2025-06-28 05:16:15.659 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = WAIT:
2025-06-28 05:16:15.672 E ID=2
2025-06-28 05:16:15.681 E ID=3
2025-06-28 05:16:15.689 E ID=4
2025-06-28 05:16:15.695 E ID=6
2025-06-28 05:16:15.703 E ID=7
2025-06-28 05:16:15.713 E ID=8
2025-06-28 05:16:15.722 E ID=10
2025-06-28 05:16:15.730 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
2025-06-28 05:16:15.741 E ID=2
2025-06-28 05:16:15.751 E ID=3
2025-06-28 05:16:15.760 E ID=4
2025-06-28 05:16:15.767 E ID=6
2025-06-28 05:16:15.773 E ID=7
2025-06-28 05:16:15.779 E ID=8
2025-06-28 05:16:15.785 E ID=10
2025-06-28 05:16:15.791 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
2025-06-28 05:16:15.797 E ID=2
2025-06-28 05:16:15.802 E ID=3
2025-06-28 05:16:15.808 E ID=4
2025-06-28 05:16:15.813 E ID=6
2025-06-28 05:16:15.819 E ID=7
2025-06-28 05:16:15.830 E ID=8
2025-06-28 05:16:15.839 E ID=10
2025-06-28 05:16:15.848 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
2025-06-28 05:16:15.854 E ID=2
2025-06-28 05:16:15.863 E ID=3
2025-06-28 05:16:15.874 E ID=4
2025-06-28 05:16:15.882 E ID=6
2025-06-28 05:16:15.889 E ID=7
2025-06-28 05:16:15.895 E ID=8
2025-06-28 05:16:15.903 E ID=10
2025-06-28 05:16:15.913 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
2025-06-28 05:16:15.923 E ID=2
2025-06-28 05:16:15.933 E ID=3
2025-06-28 05:16:15.944 E ID=4
2025-06-28 05:16:15.953 E ID=6
2025-06-28 05:16:15.961 E ID=7
2025-06-28 05:16:15.968 E ID=8
2025-06-28 05:16:15.980 E ID=10
2025-06-28 05:16:15.993 E QUERY_TYPE = PSQL_REMOTE, TIL = SERIALIZABLE, ACCESS = READ, WAIT = NO_WAIT:
2025-06-28 05:16:16.006 E Execute statement error at isc_dsql_fetch :
2025-06-28 05:16:16.015 E 335544345 : lock conflict on no wait transaction
2025-06-28 05:16:16.024 E - 335544382 : Acquire lock for relation (TEST) failed
2025-06-28 05:16:16.031 E + 335544382 : Acquire lock for relation ("PUBLIC"."TEST") failed
2025-06-28 05:16:16.049 E Statement : select id from test order by id with lock skip locked
2025-06-28 05:16:16.059 E Data source : Firebird::localhost:
2025-06-28 05:16:16.067 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-06-28 05:16:16.076 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-06-28 05:16:16.083 E -901
2025-06-28 05:16:16.089 E 335544926
2025-06-28 05:16:16.096 E 335544842
2025-06-28 05:16:16.102 E QUERY_TYPE = PSQL_REMOTE, TIL = SNAPSHOT, ACCESS = READ, WAIT = NO_WAIT:
2025-06-28 05:16:16.109 E Execute statement error at isc_dsql_fetch :
2025-06-28 05:16:16.117 E 335544361 : attempted update during read-only transaction
2025-06-28 05:16:16.123 E Statement : select id from test order by id with lock skip locked
2025-06-28 05:16:16.130 E Data source : Firebird::localhost:
2025-06-28 05:16:16.143 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-06-28 05:16:16.153 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-06-28 05:16:16.160 E -901
2025-06-28 05:16:16.166 E 335544926
2025-06-28 05:16:16.171 E 335544842
2025-06-28 05:16:16.179 E QUERY_TYPE = PSQL_REMOTE, TIL = SNAPSHOT, ACCESS = READ, WAIT = WAIT:
2025-06-28 05:16:16.189 E Execute statement error at isc_dsql_fetch :
2025-06-28 05:16:16.198 E 335544361 : attempted update during read-only transaction
2025-06-28 05:16:16.205 E Statement : select id from test order by id with lock skip locked
2025-06-28 05:16:16.211 E Data source : Firebird::localhost:
2025-06-28 05:16:16.218 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-06-28 05:16:16.228 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-06-28 05:16:16.236 E -901
2025-06-28 05:16:16.243 E 335544926
2025-06-28 05:16:16.250 E 335544842
2025-06-28 05:16:16.258 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = NO_WAIT:
2025-06-28 05:16:16.267 E Execute statement error at isc_dsql_fetch :
2025-06-28 05:16:16.273 E 335544361 : attempted update during read-only transaction
2025-06-28 05:16:16.280 E Statement : select id from test order by id with lock skip locked
2025-06-28 05:16:16.287 E Data source : Firebird::localhost:
2025-06-28 05:16:16.293 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-06-28 05:16:16.298 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-06-28 05:16:16.303 E -901
2025-06-28 05:16:16.310 E 335544926
2025-06-28 05:16:16.321 E 335544842
2025-06-28 05:16:16.333 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = WAIT:
2025-06-28 05:16:16.343 E Execute statement error at isc_dsql_fetch :
2025-06-28 05:16:16.356 E 335544361 : attempted update during read-only transaction
2025-06-28 05:16:16.365 E Statement : select id from test order by id with lock skip locked
2025-06-28 05:16:16.373 E Data source : Firebird::localhost:
2025-06-28 05:16:16.381 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-06-28 05:16:16.388 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-06-28 05:16:16.394 E -901
2025-06-28 05:16:16.401 E 335544926
2025-06-28 05:16:16.408 E 335544842
2025-06-28 05:16:16.415 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
2025-06-28 05:16:16.423 E Execute statement error at isc_dsql_fetch :
2025-06-28 05:16:16.430 E 335544361 : attempted update during read-only transaction
2025-06-28 05:16:16.437 E Statement : select id from test order by id with lock skip locked
2025-06-28 05:16:16.446 E Data source : Firebird::localhost:
2025-06-28 05:16:16.453 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-06-28 05:16:16.461 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-06-28 05:16:16.467 E -901
2025-06-28 05:16:16.475 E 335544926
2025-06-28 05:16:16.486 E 335544842
2025-06-28 05:16:16.492 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
2025-06-28 05:16:16.500 E Execute statement error at isc_dsql_fetch :
2025-06-28 05:16:16.511 E 335544361 : attempted update during read-only transaction
2025-06-28 05:16:16.517 E Statement : select id from test order by id with lock skip locked
2025-06-28 05:16:16.523 E Data source : Firebird::localhost:
2025-06-28 05:16:16.528 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-06-28 05:16:16.535 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-06-28 05:16:16.542 E -901
2025-06-28 05:16:16.551 E 335544926
2025-06-28 05:16:16.563 E 335544842
2025-06-28 05:16:16.571 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
2025-06-28 05:16:16.577 E Execute statement error at isc_dsql_fetch :
2025-06-28 05:16:16.583 E 335544361 : attempted update during read-only transaction
2025-06-28 05:16:16.589 E Statement : select id from test order by id with lock skip locked
2025-06-28 05:16:16.596 E Data source : Firebird::localhost:
2025-06-28 05:16:16.603 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-06-28 05:16:16.611 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-06-28 05:16:16.619 E -901
2025-06-28 05:16:16.630 E 335544926
2025-06-28 05:16:16.643 E 335544842
2025-06-28 05:16:16.654 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
2025-06-28 05:16:16.666 E Execute statement error at isc_dsql_fetch :
2025-06-28 05:16:16.678 E 335544361 : attempted update during read-only transaction
2025-06-28 05:16:16.688 E Statement : select id from test order by id with lock skip locked
2025-06-28 05:16:16.696 E Data source : Firebird::localhost:
2025-06-28 05:16:16.708 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-06-28 05:16:16.719 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-06-28 05:16:16.729 E -901
2025-06-28 05:16:16.737 E 335544926
2025-06-28 05:16:16.744 E 335544842
2025-06-28 05:16:16.751 E QUERY_TYPE = PSQL_REMOTE, TIL = SERIALIZABLE, ACCESS = WRITE, WAIT = NO_WAIT:
2025-06-28 05:16:16.760 E Execute statement error at isc_dsql_fetch :
2025-06-28 05:16:16.773 E 335544345 : lock conflict on no wait transaction
2025-06-28 05:16:16.782 E - 335544382 : Acquire lock for relation (TEST) failed
2025-06-28 05:16:16.793 E + 335544382 : Acquire lock for relation ("PUBLIC"."TEST") failed
2025-06-28 05:16:16.811 E Statement : select id from test order by id with lock skip locked
2025-06-28 05:16:16.818 E Data source : Firebird::localhost:
2025-06-28 05:16:16.828 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-06-28 05:16:16.838 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-06-28 05:16:16.846 E -901
2025-06-28 05:16:16.853 E 335544926
2025-06-28 05:16:16.859 E 335544842
2025-06-28 05:16:16.865 E QUERY_TYPE = PSQL_REMOTE, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = NO_WAIT:
2025-06-28 05:16:16.871 E ID=2
2025-06-28 05:16:16.878 E ID=3
2025-06-28 05:16:16.883 E ID=4
2025-06-28 05:16:16.891 E ID=6
2025-06-28 05:16:16.904 E ID=7
2025-06-28 05:16:16.914 E ID=8
2025-06-28 05:16:16.926 E ID=10
2025-06-28 05:16:16.936 E QUERY_TYPE = PSQL_REMOTE, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = WAIT:
2025-06-28 05:16:16.943 E ID=2
2025-06-28 05:16:16.949 E ID=3
2025-06-28 05:16:16.956 E ID=4
2025-06-28 05:16:16.963 E ID=6
2025-06-28 05:16:16.973 E ID=7
2025-06-28 05:16:16.985 E ID=8
2025-06-28 05:16:16.994 E ID=10
2025-06-28 05:16:17.001 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = NO_WAIT:
2025-06-28 05:16:17.009 E ID=2
2025-06-28 05:16:17.015 E ID=3
2025-06-28 05:16:17.020 E ID=4
2025-06-28 05:16:17.025 E ID=6
2025-06-28 05:16:17.031 E ID=7
2025-06-28 05:16:17.036 E ID=8
2025-06-28 05:16:17.041 E ID=10
2025-06-28 05:16:17.049 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = WAIT:
2025-06-28 05:16:17.056 E ID=2
2025-06-28 05:16:17.062 E ID=3
2025-06-28 05:16:17.068 E ID=4
2025-06-28 05:16:17.073 E ID=6
2025-06-28 05:16:17.078 E ID=7
2025-06-28 05:16:17.084 E ID=8
2025-06-28 05:16:17.091 E ID=10
2025-06-28 05:16:17.097 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
2025-06-28 05:16:17.102 E ID=2
2025-06-28 05:16:17.107 E ID=3
2025-06-28 05:16:17.113 E ID=4
2025-06-28 05:16:17.118 E ID=6
2025-06-28 05:16:17.124 E ID=7
2025-06-28 05:16:17.130 E ID=8
2025-06-28 05:16:17.141 E ID=10
2025-06-28 05:16:17.151 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
2025-06-28 05:16:17.158 E ID=2
2025-06-28 05:16:17.165 E ID=3
2025-06-28 05:16:17.171 E ID=4
2025-06-28 05:16:17.177 E ID=6
2025-06-28 05:16:17.183 E ID=7
2025-06-28 05:16:17.189 E ID=8
2025-06-28 05:16:17.195 E ID=10
2025-06-28 05:16:17.200 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
2025-06-28 05:16:17.205 E ID=2
2025-06-28 05:16:17.211 E ID=3
2025-06-28 05:16:17.217 E ID=4
2025-06-28 05:16:17.223 E ID=6
2025-06-28 05:16:17.229 E ID=7
2025-06-28 05:16:17.243 E ID=8
2025-06-28 05:16:17.256 E ID=10
2025-06-28 05:16:17.268 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
2025-06-28 05:16:17.278 E ID=2
2025-06-28 05:16:17.285 E ID=3
2025-06-28 05:16:17.291 E ID=4
2025-06-28 05:16:17.300 E ID=6
2025-06-28 05:16:17.310 E ID=7
2025-06-28 05:16:17.319 E ID=8
2025-06-28 05:16:17.329 E ID=10
2025-06-28 05:16:17.337
2025-06-28 05:16:17.349 tests/bugs/gh_7350_test.py:544: AssertionError
2025-06-28 05:16:17.359 ---------------------------- Captured stdout setup -----------------------------
2025-06-28 05:16:17.370 Creating db: localhost:/var/tmp/qa_2024/test_11537/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
|