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-29 05:34:24.573
2025-06-29 05:34:24.586 act = <firebird.qa.plugin.Action object at [hex]>
2025-06-29 05:34:24.598 capsys = <_pytest.capture.CaptureFixture object at [hex]>
2025-06-29 05:34:24.606
2025-06-29 05:34:24.613 @pytest.mark.es_eds
2025-06-29 05:34:24.619 @pytest.mark.version('>=5.0')
2025-06-29 05:34:24.626 def test_1(act: Action, capsys):
2025-06-29 05:34:24.632
2025-06-29 05:34:24.638 init_sql = f"""
2025-06-29 05:34:24.645 set term ^;
2025-06-29 05:34:24.651 recreate table test(id int primary key, f01 int)
2025-06-29 05:34:24.659 -- recreate global temporary table test(id int primary key, f01 int) on commit preserve rows
2025-06-29 05:34:24.670 ^
2025-06-29 05:34:24.680 create or alter procedure sp_get_unlocked_rows_local returns(id int) as
2025-06-29 05:34:24.687 begin
2025-06-29 05:34:24.695 for
2025-06-29 05:34:24.703 {CHECK_SQL}
2025-06-29 05:34:24.714 into id
2025-06-29 05:34:24.723 do
2025-06-29 05:34:24.730 suspend;
2025-06-29 05:34:24.741 end
2025-06-29 05:34:24.753 ^
2025-06-29 05:34:24.763 create or alter procedure sp_get_unlocked_rows_remote returns(id int) as
2025-06-29 05:34:24.770 begin
2025-06-29 05:34:24.778 for
2025-06-29 05:34:24.789 execute statement '{CHECK_SQL}'
2025-06-29 05:34:24.805 on external 'localhost:' || rdb$get_context('SYSTEM', 'DB_NAME')
2025-06-29 05:34:24.816 as user '{act.db.user}' password '{act.db.password}'
2025-06-29 05:34:24.830 into id
2025-06-29 05:34:24.841 do
2025-06-29 05:34:24.852 suspend;
2025-06-29 05:34:24.861 end
2025-06-29 05:34:24.869 ^
2025-06-29 05:34:24.875 set term ;^
2025-06-29 05:34:24.882 commit;
2025-06-29 05:34:24.901
2025-06-29 05:34:24.915 insert into test(id, f01) select row_number()over(), 0 from rdb$types rows 10;
2025-06-29 05:34:24.927 commit;
2025-06-29 05:34:24.940 """
2025-06-29 05:34:24.951 act.isql(switches=['-q'], input = init_sql, combine_output = True)
2025-06-29 05:34:24.960 assert act.clean_stdout == ''
2025-06-29 05:34:24.970 act.reset()
2025-06-29 05:34:24.977
2025-06-29 05:34:24.987 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-29 05:34:24.995 tpb_wait_set = (TraLockResolution.NO_WAIT,TraLockResolution.WAIT)
2025-06-29 05:34:25.004 tpb_mode_set = (TraAccessMode.READ, TraAccessMode.WRITE)
2025-06-29 05:34:25.012 query_types_set = ('DSQL', 'PSQL_LOCAL', 'PSQL_REMOTE')
2025-06-29 05:34:25.020
2025-06-29 05:34:25.028 with act.db.connect() as con_rows_locker, act.db.connect() as con_free_seeker:
2025-06-29 05:34:25.036 con_rows_locker.execute_immediate('update test set f01 = 1 where id in (1,5,9)')
2025-06-29 05:34:25.044 for query_type in query_types_set:
2025-06-29 05:34:25.052 for x_mode in tpb_mode_set:
2025-06-29 05:34:25.060 for x_isol in tpb_isol_set:
2025-06-29 05:34:25.068 for x_wait in tpb_wait_set:
2025-06-29 05:34:25.076 skip_flag = x_isol in (Isolation.SERIALIZABLE,) and x_wait == TraLockResolution.WAIT
2025-06-29 05:34:25.085 if skip_flag:
2025-06-29 05:34:25.092
2025-06-29 05:34:25.100 #######################################
2025-06-29 05:34:25.107 ### D O N O T C H E C K ###
2025-06-29 05:34:25.116 #######################################
2025-06-29 05:34:25.125 #
2025-06-29 05:34:25.134 # 1. Isolation.SERIALIZABLE requires that the whole table must not be changed by anyone else.
2025-06-29 05:34:25.142 # 2. [WAS ACTUAL BEFORE GH-7810 FIXED; CURRENTLY REMAINS NEEDED FB 5.X]
2025-06-29 05:34:25.148 # Isolation.READ_COMMITTED_NO_RECORD_VERSION can not be used due to implementation details, see:
2025-06-29 05:34:25.155 # Adriano, 26-feb-2023, https://github.com/FirebirdSQL/firebird/pull/7350#issuecomment-1445408462
2025-06-29 05:34:25.168 # "WITH LOCK [SKIP LOCKED] needs a record read before, but this locked records cannot be read with NO RECORD VERSION.
2025-06-29 05:34:25.178 # Considering that this transaction mode is replaced by default I would only document it as in fact I don't think
2025-06-29 05:34:25.185 # there are anything we could do."
2025-06-29 05:34:25.193
2025-06-29 05:34:25.200 continue
2025-06-29 05:34:25.206
2025-06-29 05:34:25.213 custom_tpb = tpb(isolation = x_isol, access_mode = x_mode, lock_timeout = -1 if x_wait == TraLockResolution.WAIT else 0)
2025-06-29 05:34:25.221 #custom_tpb = TPB(isolation = x_isol, access_mode = x_mode, lock_timeout = 0).get_buffer()
2025-06-29 05:34:25.230 tx_free_seeker = con_free_seeker.transaction_manager(custom_tpb)
2025-06-29 05:34:25.238 cur_free_seeker = tx_free_seeker.cursor()
2025-06-29 05:34:25.245 tx_free_seeker.begin()
2025-06-29 05:34:25.251 try:
2025-06-29 05:34:25.258 print('\n')
2025-06-29 05:34:25.267 print(f'QUERY_TYPE = {query_type}, TIL = {x_isol.name}, ACCESS = {x_mode.name}, WAIT = {x_wait.name}:')
2025-06-29 05:34:25.278 if query_type == 'DSQL':
2025-06-29 05:34:25.285 cur_free_seeker.execute(f'{CHECK_SQL}')
2025-06-29 05:34:25.292 elif query_type == 'PSQL_LOCAL':
2025-06-29 05:34:25.302 cur_free_seeker.execute('select id from sp_get_unlocked_rows_local')
2025-06-29 05:34:25.311 elif query_type == 'PSQL_REMOTE':
2025-06-29 05:34:25.319 cur_free_seeker.execute('select id from sp_get_unlocked_rows_remote')
2025-06-29 05:34:25.329 for r in cur_free_seeker:
2025-06-29 05:34:25.341 print('ID='+str(r[0]))
2025-06-29 05:34:25.353 except DatabaseError as e:
2025-06-29 05:34:25.363 print(e.__str__())
2025-06-29 05:34:25.372 print(e.sqlcode)
2025-06-29 05:34:25.382 for g in e.gds_codes:
2025-06-29 05:34:25.396 print(g)
2025-06-29 05:34:25.406 finally:
2025-06-29 05:34:25.417 tx_free_seeker.rollback()
2025-06-29 05:34:25.426
2025-06-29 05:34:25.438 act.expected_stdout = expected_stdout
2025-06-29 05:34:25.451 act.stdout = capsys.readouterr().out
2025-06-29 05:34:25.460 > assert act.clean_stdout == act.clean_expected_stdout
2025-06-29 05:34:25.469 E assert
2025-06-29 05:34:25.481 E QUERY_TYPE = DSQL, TIL = SERIALIZABLE, ACCESS = READ, WAIT = NO_WAIT:
2025-06-29 05:34:25.492 E lock conflict on no wait transaction
2025-06-29 05:34:25.505 E - -Acquire lock for relation (TEST) failed
2025-06-29 05:34:25.519 E + -Acquire lock for relation ("PUBLIC"."TEST") failed
2025-06-29 05:34:25.543 E -901
2025-06-29 05:34:25.553 E 335544345
2025-06-29 05:34:25.560 E 335544382
2025-06-29 05:34:25.568 E QUERY_TYPE = DSQL, TIL = SNAPSHOT, ACCESS = READ, WAIT = NO_WAIT:
2025-06-29 05:34:25.574 E attempted update during read-only transaction
2025-06-29 05:34:25.579 E -817
2025-06-29 05:34:25.583 E 335544361
2025-06-29 05:34:25.589 E QUERY_TYPE = DSQL, TIL = SNAPSHOT, ACCESS = READ, WAIT = WAIT:
2025-06-29 05:34:25.599 E attempted update during read-only transaction
2025-06-29 05:34:25.609 E -817
2025-06-29 05:34:25.615 E 335544361
2025-06-29 05:34:25.625 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = NO_WAIT:
2025-06-29 05:34:25.639 E attempted update during read-only transaction
2025-06-29 05:34:25.649 E -817
2025-06-29 05:34:25.658 E 335544361
2025-06-29 05:34:25.666 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = WAIT:
2025-06-29 05:34:25.673 E attempted update during read-only transaction
2025-06-29 05:34:25.679 E -817
2025-06-29 05:34:25.685 E 335544361
2025-06-29 05:34:25.692 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
2025-06-29 05:34:25.701 E attempted update during read-only transaction
2025-06-29 05:34:25.711 E -817
2025-06-29 05:34:25.723 E 335544361
2025-06-29 05:34:25.735 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
2025-06-29 05:34:25.746 E attempted update during read-only transaction
2025-06-29 05:34:25.759 E -817
2025-06-29 05:34:25.769 E 335544361
2025-06-29 05:34:25.778 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
2025-06-29 05:34:25.786 E attempted update during read-only transaction
2025-06-29 05:34:25.793 E -817
2025-06-29 05:34:25.799 E 335544361
2025-06-29 05:34:25.810 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
2025-06-29 05:34:25.822 E attempted update during read-only transaction
2025-06-29 05:34:25.830 E -817
2025-06-29 05:34:25.838 E 335544361
2025-06-29 05:34:25.845 E QUERY_TYPE = DSQL, TIL = SERIALIZABLE, ACCESS = WRITE, WAIT = NO_WAIT:
2025-06-29 05:34:25.853 E lock conflict on no wait transaction
2025-06-29 05:34:25.863 E - -Acquire lock for relation (TEST) failed
2025-06-29 05:34:25.877 E + -Acquire lock for relation ("PUBLIC"."TEST") failed
2025-06-29 05:34:25.893 E -901
2025-06-29 05:34:25.899 E 335544345
2025-06-29 05:34:25.904 E 335544382
2025-06-29 05:34:25.911 E QUERY_TYPE = DSQL, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = NO_WAIT:
2025-06-29 05:34:25.920 E ID=2
2025-06-29 05:34:25.931 E ID=3
2025-06-29 05:34:25.938 E ID=4
2025-06-29 05:34:25.944 E ID=6
2025-06-29 05:34:25.951 E ID=7
2025-06-29 05:34:25.957 E ID=8
2025-06-29 05:34:25.962 E ID=10
2025-06-29 05:34:25.967 E QUERY_TYPE = DSQL, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = WAIT:
2025-06-29 05:34:25.973 E ID=2
2025-06-29 05:34:25.978 E ID=3
2025-06-29 05:34:25.985 E ID=4
2025-06-29 05:34:25.992 E ID=6
2025-06-29 05:34:25.999 E ID=7
2025-06-29 05:34:26.004 E ID=8
2025-06-29 05:34:26.010 E ID=10
2025-06-29 05:34:26.016 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = NO_WAIT:
2025-06-29 05:34:26.021 E ID=2
2025-06-29 05:34:26.025 E ID=3
2025-06-29 05:34:26.030 E ID=4
2025-06-29 05:34:26.035 E ID=6
2025-06-29 05:34:26.040 E ID=7
2025-06-29 05:34:26.046 E ID=8
2025-06-29 05:34:26.053 E ID=10
2025-06-29 05:34:26.062 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = WAIT:
2025-06-29 05:34:26.073 E ID=2
2025-06-29 05:34:26.084 E ID=3
2025-06-29 05:34:26.092 E ID=4
2025-06-29 05:34:26.099 E ID=6
2025-06-29 05:34:26.107 E ID=7
2025-06-29 05:34:26.116 E ID=8
2025-06-29 05:34:26.123 E ID=10
2025-06-29 05:34:26.130 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
2025-06-29 05:34:26.136 E ID=2
2025-06-29 05:34:26.141 E ID=3
2025-06-29 05:34:26.150 E ID=4
2025-06-29 05:34:26.162 E ID=6
2025-06-29 05:34:26.171 E ID=7
2025-06-29 05:34:26.178 E ID=8
2025-06-29 05:34:26.186 E ID=10
2025-06-29 05:34:26.195 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
2025-06-29 05:34:26.204 E ID=2
2025-06-29 05:34:26.213 E ID=3
2025-06-29 05:34:26.222 E ID=4
2025-06-29 05:34:26.232 E ID=6
2025-06-29 05:34:26.240 E ID=7
2025-06-29 05:34:26.247 E ID=8
2025-06-29 05:34:26.255 E ID=10
2025-06-29 05:34:26.266 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
2025-06-29 05:34:26.275 E ID=2
2025-06-29 05:34:26.283 E ID=3
2025-06-29 05:34:26.290 E ID=4
2025-06-29 05:34:26.296 E ID=6
2025-06-29 05:34:26.304 E ID=7
2025-06-29 05:34:26.318 E ID=8
2025-06-29 05:34:26.328 E ID=10
2025-06-29 05:34:26.337 E QUERY_TYPE = DSQL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
2025-06-29 05:34:26.345 E ID=2
2025-06-29 05:34:26.353 E ID=3
2025-06-29 05:34:26.360 E ID=4
2025-06-29 05:34:26.367 E ID=6
2025-06-29 05:34:26.375 E ID=7
2025-06-29 05:34:26.382 E ID=8
2025-06-29 05:34:26.391 E ID=10
2025-06-29 05:34:26.404 E QUERY_TYPE = PSQL_LOCAL, TIL = SERIALIZABLE, ACCESS = READ, WAIT = NO_WAIT:
2025-06-29 05:34:26.413 E lock conflict on no wait transaction
2025-06-29 05:34:26.420 E - -Acquire lock for relation (TEST) failed
2025-06-29 05:34:26.426 E + -Acquire lock for relation ("PUBLIC"."TEST") failed
2025-06-29 05:34:26.438 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-06-29 05:34:26.444 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-06-29 05:34:26.449 E -901
2025-06-29 05:34:26.460 E 335544345
2025-06-29 05:34:26.472 E 335544382
2025-06-29 05:34:26.480 E 335544842
2025-06-29 05:34:26.487 E QUERY_TYPE = PSQL_LOCAL, TIL = SNAPSHOT, ACCESS = READ, WAIT = NO_WAIT:
2025-06-29 05:34:26.496 E attempted update during read-only transaction
2025-06-29 05:34:26.505 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-06-29 05:34:26.515 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-06-29 05:34:26.527 E -817
2025-06-29 05:34:26.534 E 335544361
2025-06-29 05:34:26.545 E 335544842
2025-06-29 05:34:26.554 E QUERY_TYPE = PSQL_LOCAL, TIL = SNAPSHOT, ACCESS = READ, WAIT = WAIT:
2025-06-29 05:34:26.566 E attempted update during read-only transaction
2025-06-29 05:34:26.576 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-06-29 05:34:26.584 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-06-29 05:34:26.592 E -817
2025-06-29 05:34:26.601 E 335544361
2025-06-29 05:34:26.611 E 335544842
2025-06-29 05:34:26.619 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = NO_WAIT:
2025-06-29 05:34:26.626 E attempted update during read-only transaction
2025-06-29 05:34:26.634 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-06-29 05:34:26.642 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-06-29 05:34:26.650 E -817
2025-06-29 05:34:26.655 E 335544361
2025-06-29 05:34:26.664 E 335544842
2025-06-29 05:34:26.674 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = WAIT:
2025-06-29 05:34:26.681 E attempted update during read-only transaction
2025-06-29 05:34:26.689 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-06-29 05:34:26.696 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-06-29 05:34:26.704 E -817
2025-06-29 05:34:26.712 E 335544361
2025-06-29 05:34:26.719 E 335544842
2025-06-29 05:34:26.727 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
2025-06-29 05:34:26.738 E attempted update during read-only transaction
2025-06-29 05:34:26.749 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-06-29 05:34:26.762 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-06-29 05:34:26.771 E -817
2025-06-29 05:34:26.778 E 335544361
2025-06-29 05:34:26.788 E 335544842
2025-06-29 05:34:26.801 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
2025-06-29 05:34:26.809 E attempted update during read-only transaction
2025-06-29 05:34:26.816 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-06-29 05:34:26.822 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-06-29 05:34:26.828 E -817
2025-06-29 05:34:26.835 E 335544361
2025-06-29 05:34:26.842 E 335544842
2025-06-29 05:34:26.848 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
2025-06-29 05:34:26.855 E attempted update during read-only transaction
2025-06-29 05:34:26.862 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-06-29 05:34:26.875 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-06-29 05:34:26.885 E -817
2025-06-29 05:34:26.893 E 335544361
2025-06-29 05:34:26.899 E 335544842
2025-06-29 05:34:26.905 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
2025-06-29 05:34:26.910 E attempted update during read-only transaction
2025-06-29 05:34:26.916 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-06-29 05:34:26.923 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-06-29 05:34:26.930 E -817
2025-06-29 05:34:26.937 E 335544361
2025-06-29 05:34:26.944 E 335544842
2025-06-29 05:34:26.952 E QUERY_TYPE = PSQL_LOCAL, TIL = SERIALIZABLE, ACCESS = WRITE, WAIT = NO_WAIT:
2025-06-29 05:34:26.960 E lock conflict on no wait transaction
2025-06-29 05:34:26.967 E - -Acquire lock for relation (TEST) failed
2025-06-29 05:34:26.975 E + -Acquire lock for relation ("PUBLIC"."TEST") failed
2025-06-29 05:34:26.991 E - -At procedure 'SP_GET_UNLOCKED_ROWS_LOCAL'
2025-06-29 05:34:27.000 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_LOCAL" line: 3, col: 13
2025-06-29 05:34:27.007 E -901
2025-06-29 05:34:27.014 E 335544345
2025-06-29 05:34:27.022 E 335544382
2025-06-29 05:34:27.029 E 335544842
2025-06-29 05:34:27.036 E QUERY_TYPE = PSQL_LOCAL, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = NO_WAIT:
2025-06-29 05:34:27.042 E ID=2
2025-06-29 05:34:27.049 E ID=3
2025-06-29 05:34:27.056 E ID=4
2025-06-29 05:34:27.063 E ID=6
2025-06-29 05:34:27.070 E ID=7
2025-06-29 05:34:27.077 E ID=8
2025-06-29 05:34:27.084 E ID=10
2025-06-29 05:34:27.091 E QUERY_TYPE = PSQL_LOCAL, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = WAIT:
2025-06-29 05:34:27.102 E ID=2
2025-06-29 05:34:27.110 E ID=3
2025-06-29 05:34:27.117 E ID=4
2025-06-29 05:34:27.124 E ID=6
2025-06-29 05:34:27.131 E ID=7
2025-06-29 05:34:27.139 E ID=8
2025-06-29 05:34:27.151 E ID=10
2025-06-29 05:34:27.163 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = NO_WAIT:
2025-06-29 05:34:27.172 E ID=2
2025-06-29 05:34:27.179 E ID=3
2025-06-29 05:34:27.185 E ID=4
2025-06-29 05:34:27.191 E ID=6
2025-06-29 05:34:27.197 E ID=7
2025-06-29 05:34:27.203 E ID=8
2025-06-29 05:34:27.209 E ID=10
2025-06-29 05:34:27.215 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = WAIT:
2025-06-29 05:34:27.224 E ID=2
2025-06-29 05:34:27.237 E ID=3
2025-06-29 05:34:27.248 E ID=4
2025-06-29 05:34:27.257 E ID=6
2025-06-29 05:34:27.264 E ID=7
2025-06-29 05:34:27.271 E ID=8
2025-06-29 05:34:27.279 E ID=10
2025-06-29 05:34:27.290 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
2025-06-29 05:34:27.300 E ID=2
2025-06-29 05:34:27.307 E ID=3
2025-06-29 05:34:27.313 E ID=4
2025-06-29 05:34:27.319 E ID=6
2025-06-29 05:34:27.327 E ID=7
2025-06-29 05:34:27.337 E ID=8
2025-06-29 05:34:27.345 E ID=10
2025-06-29 05:34:27.353 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
2025-06-29 05:34:27.359 E ID=2
2025-06-29 05:34:27.364 E ID=3
2025-06-29 05:34:27.369 E ID=4
2025-06-29 05:34:27.374 E ID=6
2025-06-29 05:34:27.379 E ID=7
2025-06-29 05:34:27.384 E ID=8
2025-06-29 05:34:27.390 E ID=10
2025-06-29 05:34:27.395 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
2025-06-29 05:34:27.408 E ID=2
2025-06-29 05:34:27.419 E ID=3
2025-06-29 05:34:27.429 E ID=4
2025-06-29 05:34:27.440 E ID=6
2025-06-29 05:34:27.452 E ID=7
2025-06-29 05:34:27.461 E ID=8
2025-06-29 05:34:27.472 E ID=10
2025-06-29 05:34:27.484 E QUERY_TYPE = PSQL_LOCAL, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
2025-06-29 05:34:27.493 E ID=2
2025-06-29 05:34:27.504 E ID=3
2025-06-29 05:34:27.515 E ID=4
2025-06-29 05:34:27.524 E ID=6
2025-06-29 05:34:27.531 E ID=7
2025-06-29 05:34:27.538 E ID=8
2025-06-29 05:34:27.550 E ID=10
2025-06-29 05:34:27.563 E QUERY_TYPE = PSQL_REMOTE, TIL = SERIALIZABLE, ACCESS = READ, WAIT = NO_WAIT:
2025-06-29 05:34:27.575 E Execute statement error at isc_dsql_fetch :
2025-06-29 05:34:27.588 E 335544345 : lock conflict on no wait transaction
2025-06-29 05:34:27.599 E - 335544382 : Acquire lock for relation (TEST) failed
2025-06-29 05:34:27.607 E + 335544382 : Acquire lock for relation ("PUBLIC"."TEST") failed
2025-06-29 05:34:27.622 E Statement : select id from test order by id with lock skip locked
2025-06-29 05:34:27.630 E Data source : Firebird::localhost:
2025-06-29 05:34:27.638 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-06-29 05:34:27.646 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-06-29 05:34:27.657 E -901
2025-06-29 05:34:27.666 E 335544926
2025-06-29 05:34:27.674 E 335544842
2025-06-29 05:34:27.681 E QUERY_TYPE = PSQL_REMOTE, TIL = SNAPSHOT, ACCESS = READ, WAIT = NO_WAIT:
2025-06-29 05:34:27.689 E Execute statement error at isc_dsql_fetch :
2025-06-29 05:34:27.697 E 335544361 : attempted update during read-only transaction
2025-06-29 05:34:27.705 E Statement : select id from test order by id with lock skip locked
2025-06-29 05:34:27.712 E Data source : Firebird::localhost:
2025-06-29 05:34:27.720 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-06-29 05:34:27.727 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-06-29 05:34:27.734 E -901
2025-06-29 05:34:27.741 E 335544926
2025-06-29 05:34:27.754 E 335544842
2025-06-29 05:34:27.763 E QUERY_TYPE = PSQL_REMOTE, TIL = SNAPSHOT, ACCESS = READ, WAIT = WAIT:
2025-06-29 05:34:27.770 E Execute statement error at isc_dsql_fetch :
2025-06-29 05:34:27.777 E 335544361 : attempted update during read-only transaction
2025-06-29 05:34:27.784 E Statement : select id from test order by id with lock skip locked
2025-06-29 05:34:27.791 E Data source : Firebird::localhost:
2025-06-29 05:34:27.799 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-06-29 05:34:27.807 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-06-29 05:34:27.815 E -901
2025-06-29 05:34:27.824 E 335544926
2025-06-29 05:34:27.831 E 335544842
2025-06-29 05:34:27.839 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = NO_WAIT:
2025-06-29 05:34:27.848 E Execute statement error at isc_dsql_fetch :
2025-06-29 05:34:27.856 E 335544361 : attempted update during read-only transaction
2025-06-29 05:34:27.863 E Statement : select id from test order by id with lock skip locked
2025-06-29 05:34:27.871 E Data source : Firebird::localhost:
2025-06-29 05:34:27.879 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-06-29 05:34:27.887 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-06-29 05:34:27.896 E -901
2025-06-29 05:34:27.907 E 335544926
2025-06-29 05:34:27.915 E 335544842
2025-06-29 05:34:27.924 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = READ, WAIT = WAIT:
2025-06-29 05:34:27.930 E Execute statement error at isc_dsql_fetch :
2025-06-29 05:34:27.939 E 335544361 : attempted update during read-only transaction
2025-06-29 05:34:27.946 E Statement : select id from test order by id with lock skip locked
2025-06-29 05:34:27.952 E Data source : Firebird::localhost:
2025-06-29 05:34:27.958 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-06-29 05:34:27.968 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-06-29 05:34:27.976 E -901
2025-06-29 05:34:27.982 E 335544926
2025-06-29 05:34:27.987 E 335544842
2025-06-29 05:34:27.992 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
2025-06-29 05:34:27.997 E Execute statement error at isc_dsql_fetch :
2025-06-29 05:34:28.002 E 335544361 : attempted update during read-only transaction
2025-06-29 05:34:28.008 E Statement : select id from test order by id with lock skip locked
2025-06-29 05:34:28.015 E Data source : Firebird::localhost:
2025-06-29 05:34:28.022 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-06-29 05:34:28.030 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-06-29 05:34:28.040 E -901
2025-06-29 05:34:28.048 E 335544926
2025-06-29 05:34:28.055 E 335544842
2025-06-29 05:34:28.061 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
2025-06-29 05:34:28.068 E Execute statement error at isc_dsql_fetch :
2025-06-29 05:34:28.075 E 335544361 : attempted update during read-only transaction
2025-06-29 05:34:28.083 E Statement : select id from test order by id with lock skip locked
2025-06-29 05:34:28.093 E Data source : Firebird::localhost:
2025-06-29 05:34:28.101 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-06-29 05:34:28.109 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-06-29 05:34:28.115 E -901
2025-06-29 05:34:28.120 E 335544926
2025-06-29 05:34:28.125 E 335544842
2025-06-29 05:34:28.130 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = NO_WAIT:
2025-06-29 05:34:28.135 E Execute statement error at isc_dsql_fetch :
2025-06-29 05:34:28.141 E 335544361 : attempted update during read-only transaction
2025-06-29 05:34:28.146 E Statement : select id from test order by id with lock skip locked
2025-06-29 05:34:28.151 E Data source : Firebird::localhost:
2025-06-29 05:34:28.156 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-06-29 05:34:28.161 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-06-29 05:34:28.167 E -901
2025-06-29 05:34:28.171 E 335544926
2025-06-29 05:34:28.176 E 335544842
2025-06-29 05:34:28.182 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = READ, WAIT = WAIT:
2025-06-29 05:34:28.188 E Execute statement error at isc_dsql_fetch :
2025-06-29 05:34:28.194 E 335544361 : attempted update during read-only transaction
2025-06-29 05:34:28.201 E Statement : select id from test order by id with lock skip locked
2025-06-29 05:34:28.207 E Data source : Firebird::localhost:
2025-06-29 05:34:28.215 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-06-29 05:34:28.226 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-06-29 05:34:28.233 E -901
2025-06-29 05:34:28.241 E 335544926
2025-06-29 05:34:28.248 E 335544842
2025-06-29 05:34:28.256 E QUERY_TYPE = PSQL_REMOTE, TIL = SERIALIZABLE, ACCESS = WRITE, WAIT = NO_WAIT:
2025-06-29 05:34:28.263 E Execute statement error at isc_dsql_fetch :
2025-06-29 05:34:28.271 E 335544345 : lock conflict on no wait transaction
2025-06-29 05:34:28.279 E - 335544382 : Acquire lock for relation (TEST) failed
2025-06-29 05:34:28.287 E + 335544382 : Acquire lock for relation ("PUBLIC"."TEST") failed
2025-06-29 05:34:28.302 E Statement : select id from test order by id with lock skip locked
2025-06-29 05:34:28.310 E Data source : Firebird::localhost:
2025-06-29 05:34:28.323 E - -At procedure 'SP_GET_UNLOCKED_ROWS_REMOTE'
2025-06-29 05:34:28.332 E + -At procedure "PUBLIC"."SP_GET_UNLOCKED_ROWS_REMOTE" line: 3, col: 13
2025-06-29 05:34:28.340 E -901
2025-06-29 05:34:28.347 E 335544926
2025-06-29 05:34:28.352 E 335544842
2025-06-29 05:34:28.357 E QUERY_TYPE = PSQL_REMOTE, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = NO_WAIT:
2025-06-29 05:34:28.362 E ID=2
2025-06-29 05:34:28.371 E ID=3
2025-06-29 05:34:28.380 E ID=4
2025-06-29 05:34:28.387 E ID=6
2025-06-29 05:34:28.395 E ID=7
2025-06-29 05:34:28.403 E ID=8
2025-06-29 05:34:28.415 E ID=10
2025-06-29 05:34:28.425 E QUERY_TYPE = PSQL_REMOTE, TIL = SNAPSHOT, ACCESS = WRITE, WAIT = WAIT:
2025-06-29 05:34:28.433 E ID=2
2025-06-29 05:34:28.441 E ID=3
2025-06-29 05:34:28.449 E ID=4
2025-06-29 05:34:28.457 E ID=6
2025-06-29 05:34:28.464 E ID=7
2025-06-29 05:34:28.472 E ID=8
2025-06-29 05:34:28.479 E ID=10
2025-06-29 05:34:28.488 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = NO_WAIT:
2025-06-29 05:34:28.500 E ID=2
2025-06-29 05:34:28.509 E ID=3
2025-06-29 05:34:28.522 E ID=4
2025-06-29 05:34:28.532 E ID=6
2025-06-29 05:34:28.540 E ID=7
2025-06-29 05:34:28.552 E ID=8
2025-06-29 05:34:28.562 E ID=10
2025-06-29 05:34:28.570 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_READ_CONSISTENCY, ACCESS = WRITE, WAIT = WAIT:
2025-06-29 05:34:28.577 E ID=2
2025-06-29 05:34:28.583 E ID=3
2025-06-29 05:34:28.590 E ID=4
2025-06-29 05:34:28.599 E ID=6
2025-06-29 05:34:28.608 E ID=7
2025-06-29 05:34:28.615 E ID=8
2025-06-29 05:34:28.627 E ID=10
2025-06-29 05:34:28.638 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
2025-06-29 05:34:28.645 E ID=2
2025-06-29 05:34:28.653 E ID=3
2025-06-29 05:34:28.661 E ID=4
2025-06-29 05:34:28.669 E ID=6
2025-06-29 05:34:28.680 E ID=7
2025-06-29 05:34:28.691 E ID=8
2025-06-29 05:34:28.699 E ID=10
2025-06-29 05:34:28.709 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
2025-06-29 05:34:28.720 E ID=2
2025-06-29 05:34:28.729 E ID=3
2025-06-29 05:34:28.735 E ID=4
2025-06-29 05:34:28.741 E ID=6
2025-06-29 05:34:28.746 E ID=7
2025-06-29 05:34:28.761 E ID=8
2025-06-29 05:34:28.770 E ID=10
2025-06-29 05:34:28.776 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = NO_WAIT:
2025-06-29 05:34:28.782 E ID=2
2025-06-29 05:34:28.790 E ID=3
2025-06-29 05:34:28.802 E ID=4
2025-06-29 05:34:28.810 E ID=6
2025-06-29 05:34:28.817 E ID=7
2025-06-29 05:34:28.824 E ID=8
2025-06-29 05:34:28.830 E ID=10
2025-06-29 05:34:28.838 E QUERY_TYPE = PSQL_REMOTE, TIL = READ_COMMITTED_NO_RECORD_VERSION, ACCESS = WRITE, WAIT = WAIT:
2025-06-29 05:34:28.848 E ID=2
2025-06-29 05:34:28.857 E ID=3
2025-06-29 05:34:28.863 E ID=4
2025-06-29 05:34:28.869 E ID=6
2025-06-29 05:34:28.875 E ID=7
2025-06-29 05:34:28.882 E ID=8
2025-06-29 05:34:28.888 E ID=10
2025-06-29 05:34:28.893
2025-06-29 05:34:28.904 tests/bugs/gh_7350_test.py:544: AssertionError
2025-06-29 05:34:28.914 ---------------------------- Captured stdout setup -----------------------------
2025-06-29 05:34:28.921 Creating db: localhost:/var/tmp/qa_2024/test_11539/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
|