2 @message |
assert
checked_mode: table, STDLOG: Records affected: 3
checked_mode: table, STDLOG: ID
checked_mode: table, STDLOG:
checked_mode: table, STDLOG: 3
checked_mode: table, STDLOG: 4
checked_mode: table, STDLOG: 5
checked_mode: table, STDLOG: 6
checked_mode: table, STDLOG: 7
checked_mode: table, STDLOG: 8
checked_mode: table, STDLOG: Records affected: 6
checked_mode: table, STDLOG: OLD_ID OP SNAP_NO_RANK
checked_mode: table, STDLOG:
- checked_mode: table, STDLOG: 1 DEL 1
+ checked_mode: table, STDLOG: 1DEL 1
- checked_mode: table, STDLOG: 2 DEL 1
+ checked_mode: table, STDLOG: 2DEL 1
- checked_mode: table, STDLOG: 3 DEL 1
+ checked_mode: table, STDLOG: 3DEL 1
- checked_mode: table, STDLOG: 4 DEL 1
+ checked_mode: table, STDLOG: 4DEL 1
- checked_mode: table, STDLOG: -1 DEL 2
+ checked_mode: table, STDLOG: -1DEL 2
- checked_mode: table, STDLOG: 1 DEL 2
+ checked_mode: table, STDLOG: 1DEL 2
- checked_mode: table, STDLOG: 2 DEL 2
+ checked_mode: table, STDLOG: 2DEL 2
checked_mode: table, STDLOG: Records affected: 7
LOG DETAILS:
2025-07-02 06:07:36.965
2025-07-02 06:07:36.975 act = <firebird.qa.plugin.Action object at [hex]>
2025-07-02 06:07:36.984 fn_worker_sql = PosixPath('/var/tmp/qa_2024/test_12477/tmp_worker.sql')
2025-07-02 06:07:36.999 fn_worker_log = PosixPath('/var/tmp/qa_2024/test_12477/tmp_worker.log')
2025-07-02 06:07:37.010 fn_worker_err = PosixPath('/var/tmp/qa_2024/test_12477/tmp_worker.err')
2025-07-02 06:07:37.016 capsys = <_pytest.capture.CaptureFixture object at [hex]>
2025-07-02 06:07:37.022
2025-07-02 06:07:37.027 @pytest.mark.trace
2025-07-02 06:07:37.037 @pytest.mark.version('>=4.0.2')
2025-07-02 06:07:37.051 def test_1(act: Action, fn_worker_sql: Path, fn_worker_log: Path, fn_worker_err: Path, capsys):
2025-07-02 06:07:37.061 sql_init = (act.files_dir / 'read-consist-sttm-restart-DDL.sql').read_text()
2025-07-02 06:07:37.073
2025-07-02 06:07:37.084 for checked_mode in('table', 'view'):
2025-07-02 06:07:37.093 target_obj = 'test' if checked_mode == 'table' else 'v_test'
2025-07-02 06:07:37.103 SQL_TO_BE_RESTARTED = f'delete /* {SQL_TAG_THAT_WE_WAITING_FOR} */ from {target_obj} order by id rows ( iif(exists(select 1 from {target_obj} where id < 0), 3, 8 ) )'
2025-07-02 06:07:37.110
2025-07-02 06:07:37.120 # add rows with ID = 1,2,3,4,5:
2025-07-02 06:07:37.130 sql_addi = f'''
2025-07-02 06:07:37.137 set term ^;
2025-07-02 06:07:37.144 execute block as
2025-07-02 06:07:37.151 begin
2025-07-02 06:07:37.157 rdb$set_context('USER_SESSION', 'WHO', 'INIT_DATA');
2025-07-02 06:07:37.163 end
2025-07-02 06:07:37.168 ^
2025-07-02 06:07:37.174 set term ;^
2025-07-02 06:07:37.180 insert into {target_obj}(id, x)
2025-07-02 06:07:37.186 select row_number()over(),row_number()over()
2025-07-02 06:07:37.193 from rdb$types rows 5;
2025-07-02 06:07:37.199 commit;
2025-07-02 06:07:37.206 '''
2025-07-02 06:07:37.215
2025-07-02 06:07:37.223 act.isql(switches=['-q'], input = ''.join( (sql_init, sql_addi) ) )
2025-07-02 06:07:37.230 # ::: NOTE ::: We have to immediately quit if any error raised in prepare phase.
2025-07-02 06:07:37.237 # See also letter from dimitr, 01-feb-2022 14:46
2025-07-02 06:07:37.244 assert act.stderr == ''
2025-07-02 06:07:37.251 act.reset()
2025-07-02 06:07:37.258
2025-07-02 06:07:37.269
2025-07-02 06:07:37.279 trace_cfg_items = [
2025-07-02 06:07:37.287 'time_threshold = 0',
2025-07-02 06:07:37.294 'log_errors = true',
2025-07-02 06:07:37.302 'log_statement_start = true',
2025-07-02 06:07:37.313 'log_statement_finish = true',
2025-07-02 06:07:37.321 ]
2025-07-02 06:07:37.327
2025-07-02 06:07:37.335 with act.trace(db_events = trace_cfg_items, encoding=locale.getpreferredencoding()):
2025-07-02 06:07:37.342
2025-07-02 06:07:37.351 with act.db.connect() as con_lock_1, act.db.connect() as con_lock_2, act.db.connect() as con_monitoring:
2025-07-02 06:07:37.362
2025-07-02 06:07:37.372 tpb_monitoring = tpb(isolation=Isolation.READ_COMMITTED_RECORD_VERSION, lock_timeout=0)
2025-07-02 06:07:37.379 tx_monitoring = con_monitoring.transaction_manager(tpb_monitoring)
2025-07-02 06:07:37.385 cur_monitoring = tx_monitoring.cursor()
2025-07-02 06:07:37.390
2025-07-02 06:07:37.395 for i,c in enumerate((con_lock_1,con_lock_2)):
2025-07-02 06:07:37.400 sttm = f"execute block as begin rdb$set_context('USER_SESSION', 'WHO', 'LOCKER #{i+1}'); end"
2025-07-02 06:07:37.405 c.execute_immediate(sttm)
2025-07-02 06:07:37.410
2025-07-02 06:07:37.414 #########################
2025-07-02 06:07:37.419 ### L O C K E R - 1 ###
2025-07-02 06:07:37.424 #########################
2025-07-02 06:07:37.429 con_lock_1.execute_immediate( f'update {target_obj} set id=id where id = 5' )
2025-07-02 06:07:37.435
2025-07-02 06:07:37.440 worker_sql = f'''
2025-07-02 06:07:37.445 set list on;
2025-07-02 06:07:37.453 set autoddl off;
2025-07-02 06:07:37.459 set term ^;
2025-07-02 06:07:37.467 execute block returns (whoami varchar(30)) as
2025-07-02 06:07:37.475 begin
2025-07-02 06:07:37.486 whoami = 'WORKER'; -- , ATT#' || current_connection;
2025-07-02 06:07:37.493 rdb$set_context('USER_SESSION','WHO', whoami);
2025-07-02 06:07:37.499 -- suspend;
2025-07-02 06:07:37.506 end
2025-07-02 06:07:37.519 ^
2025-07-02 06:07:37.530 set term ;^
2025-07-02 06:07:37.540 commit;
2025-07-02 06:07:37.551 --set echo on;
2025-07-02 06:07:37.562 SET KEEP_TRAN_PARAMS ON;
2025-07-02 06:07:37.572 set transaction read committed read consistency;
2025-07-02 06:07:37.579 --select current_connection, current_transaction from rdb$database;
2025-07-02 06:07:37.585 set list off;
2025-07-02 06:07:37.590 set wng off;
2025-07-02 06:07:37.600 --set plan on;
2025-07-02 06:07:37.610 set count on;
2025-07-02 06:07:37.621
2025-07-02 06:07:37.632 -- delete from {target_obj} order by id rows ( iif(exists(select 1 from {target_obj} where id < 0), 3, 8 ) ); -- THIS MUST BE LOCKED
2025-07-02 06:07:37.643 {SQL_TO_BE_RESTARTED};
2025-07-02 06:07:37.657
2025-07-02 06:07:37.668 -- check results:
2025-07-02 06:07:37.677 -- ###############
2025-07-02 06:07:37.683
2025-07-02 06:07:37.697 select id from {target_obj} order by id; -- this will produce output only after all lockers do their commit/rollback
2025-07-02 06:07:37.710
2025-07-02 06:07:37.722 select v.old_id, v.op, v.snap_no_rank
2025-07-02 06:07:37.734 from v_worker_log v
2025-07-02 06:07:37.755 where v.op = 'del';
2025-07-02 06:07:37.765
2025-07-02 06:07:37.778 set width who 10;
2025-07-02 06:07:37.789 -- DO NOT check this! Values can differ here from one run to another!
2025-07-02 06:07:37.796 --select id, trn, who, old_id, new_id, op, rec_vers, global_cn, snap_no from tlog_done order by id;
2025-07-02 06:07:37.803
2025-07-02 06:07:37.810 rollback;
2025-07-02 06:07:37.816
2025-07-02 06:07:37.822 '''
2025-07-02 06:07:37.831 fn_worker_sql.write_text(worker_sql)
2025-07-02 06:07:37.842
2025-07-02 06:07:37.851 with fn_worker_log.open(mode='w') as hang_out, fn_worker_err.open(mode='w') as hang_err:
2025-07-02 06:07:37.861
2025-07-02 06:07:37.873 ############################################################################
2025-07-02 06:07:37.885 ### L A U N C H W O R K E R U S I N G I S Q L, A S Y N C. ###
2025-07-02 06:07:37.899 ############################################################################
2025-07-02 06:07:37.908 p_worker = subprocess.Popen([act.vars['isql'], '-i', str(fn_worker_sql),
2025-07-02 06:07:37.916 '-user', act.db.user,
2025-07-02 06:07:37.923 '-password', act.db.password,
2025-07-02 06:07:37.936 act.db.dsn
2025-07-02 06:07:37.951 ],
2025-07-02 06:07:37.961 stdout = hang_out,
2025-07-02 06:07:37.969 stderr = hang_err
2025-07-02 06:07:37.976 )
2025-07-02 06:07:37.982
2025-07-02 06:07:37.989 # NB: when ISQL will establish attach, first record that it must lock is ID = 1 -- see above SQL_TO_BE_RESTARTED
2025-07-02 06:07:37.995 # We must to ensure that this (worker) attachment has been really created and LOCKS this record:
2025-07-02 06:07:38.000 #
2025-07-02 06:07:38.006 wait_for_record_become_locked(tx_monitoring, cur_monitoring, f'update {target_obj} set id=id where id=1', SQL_TAG_THAT_WE_WAITING_FOR)
2025-07-02 06:07:38.010
2025-07-02 06:07:38.015
2025-07-02 06:07:38.020 #########################
2025-07-02 06:07:38.025 ### L O C K E R - 2 ###
2025-07-02 06:07:38.030 #########################
2025-07-02 06:07:38.036 con_lock_2.execute_immediate( f'insert into {target_obj}(id) values(6)' )
2025-07-02 06:07:38.041 con_lock_2.commit()
2025-07-02 06:07:38.046 con_lock_2.execute_immediate( f'update {target_obj} set id=id where id = 6' )
2025-07-02 06:07:38.051
2025-07-02 06:07:38.056 #########################
2025-07-02 06:07:38.065 ### L O C K E R - 1 ###
2025-07-02 06:07:38.071 #########################
2025-07-02 06:07:38.079 con_lock_1.commit() # releases record with ID = 5 ==> now it can be locked by worker.
2025-07-02 06:07:38.084
2025-07-02 06:07:38.089 # We have to WAIT HERE until worker will actually 'catch' just released record with ID = 5.
2025-07-02 06:07:38.101 #
2025-07-02 06:07:38.109 wait_for_record_become_locked(tx_monitoring, cur_monitoring, f'update {target_obj} set id=id where id=5', SQL_TAG_THAT_WE_WAITING_FOR)
2025-07-02 06:07:38.117 # If we come here then it means that record with ID = 5 for sure is locked by WORKER.
2025-07-02 06:07:38.123
2025-07-02 06:07:38.129
2025-07-02 06:07:38.135 con_lock_1.execute_immediate( f'insert into {target_obj}(id) values(7)' )
2025-07-02 06:07:38.143 con_lock_1.commit()
2025-07-02 06:07:38.153 con_lock_1.execute_immediate( f'update {target_obj} set id=id where id = 7' )
2025-07-02 06:07:38.162
2025-07-02 06:07:38.170
2025-07-02 06:07:38.180 #########################
2025-07-02 06:07:38.189 ### L O C K E R - 2 ###
2025-07-02 06:07:38.197 #########################
2025-07-02 06:07:38.204 con_lock_2.commit() # releases record with ID = 6 ==> now it can be locked by worker.
2025-07-02 06:07:38.210
2025-07-02 06:07:38.217 # We have to WAIT HERE until worker will actually 'catch' just released record with ID = 6:
2025-07-02 06:07:38.223 #
2025-07-02 06:07:38.231 wait_for_record_become_locked(tx_monitoring, cur_monitoring, f'update {target_obj} set id=id where id = 6', SQL_TAG_THAT_WE_WAITING_FOR)
2025-07-02 06:07:38.243 # If we come here then it means that record with ID = 6 for sure is locked by WORKER.
2025-07-02 06:07:38.252
2025-07-02 06:07:38.260
2025-07-02 06:07:38.268 con_lock_2.execute_immediate( f'insert into {target_obj}(id) values(8)' )
2025-07-02 06:07:38.275 con_lock_2.commit()
2025-07-02 06:07:38.281 con_lock_2.execute_immediate( f'update {target_obj} set id=id where id = 8' )
2025-07-02 06:07:38.287
2025-07-02 06:07:38.300 #########################
2025-07-02 06:07:38.311 ### L O C K E R - 1 ###
2025-07-02 06:07:38.320 #########################
2025-07-02 06:07:38.329 con_lock_1.commit() # releases record with ID = 7 ==> now it can be locked by worker.
2025-07-02 06:07:38.337
2025-07-02 06:07:38.344 # We have to WAIT HERE until worker will actually 'catch' just released record with ID = 7:
2025-07-02 06:07:38.350 #
2025-07-02 06:07:38.357 wait_for_record_become_locked(tx_monitoring, cur_monitoring, f'update {target_obj} set id=id where id = 7', SQL_TAG_THAT_WE_WAITING_FOR)
2025-07-02 06:07:38.369 # If we come here then it means that record with ID = 7 for sure is locked by WORKER.
2025-07-02 06:07:38.379
2025-07-02 06:07:38.388 con_lock_1.execute_immediate( f'insert into {target_obj}(id) values(-1)' )
2025-07-02 06:07:38.394 con_lock_1.commit()
2025-07-02 06:07:38.399
2025-07-02 06:07:38.406 con_lock_2.commit() # WORKER will complete his job after this
2025-07-02 06:07:38.412
2025-07-02 06:07:38.418 # Here we wait for ISQL complete its mission:
2025-07-02 06:07:38.424 p_worker.wait()
2025-07-02 06:07:38.429
2025-07-02 06:07:38.435 #< with act.db.connect()
2025-07-02 06:07:38.441
2025-07-02 06:07:38.447 for g in (fn_worker_log, fn_worker_err):
2025-07-02 06:07:38.455 with g.open() as f:
2025-07-02 06:07:38.466 for line in f:
2025-07-02 06:07:38.477 if line.split():
2025-07-02 06:07:38.489 if g == fn_worker_log:
2025-07-02 06:07:38.500 print(f'checked_mode: {checked_mode}, STDLOG: {line}')
2025-07-02 06:07:38.510 else:
2025-07-02 06:07:38.518 print(f'UNEXPECTED STDERR {line}')
2025-07-02 06:07:38.528
2025-07-02 06:07:38.540 expected_stdout_worker = f"""
2025-07-02 06:07:38.549 checked_mode: {checked_mode}, STDLOG: Records affected: 3
2025-07-02 06:07:38.555 checked_mode: {checked_mode}, STDLOG: ID
2025-07-02 06:07:38.560 checked_mode: {checked_mode}, STDLOG: =======
2025-07-02 06:07:38.565 checked_mode: {checked_mode}, STDLOG: 3
2025-07-02 06:07:38.571 checked_mode: {checked_mode}, STDLOG: 4
2025-07-02 06:07:38.576 checked_mode: {checked_mode}, STDLOG: 5
2025-07-02 06:07:38.581 checked_mode: {checked_mode}, STDLOG: 6
2025-07-02 06:07:38.585 checked_mode: {checked_mode}, STDLOG: 7
2025-07-02 06:07:38.590 checked_mode: {checked_mode}, STDLOG: 8
2025-07-02 06:07:38.594 checked_mode: {checked_mode}, STDLOG: Records affected: 6
2025-07-02 06:07:38.599 checked_mode: {checked_mode}, STDLOG: OLD_ID OP SNAP_NO_RANK
2025-07-02 06:07:38.604 checked_mode: {checked_mode}, STDLOG: ======= ====== =====================
2025-07-02 06:07:38.611 checked_mode: {checked_mode}, STDLOG: 1 DEL 1
2025-07-02 06:07:38.619 checked_mode: {checked_mode}, STDLOG: 2 DEL 1
2025-07-02 06:07:38.625 checked_mode: {checked_mode}, STDLOG: 3 DEL 1
2025-07-02 06:07:38.629 checked_mode: {checked_mode}, STDLOG: 4 DEL 1
2025-07-02 06:07:38.640 checked_mode: {checked_mode}, STDLOG: -1 DEL 2
2025-07-02 06:07:38.652 checked_mode: {checked_mode}, STDLOG: 1 DEL 2
2025-07-02 06:07:38.664 checked_mode: {checked_mode}, STDLOG: 2 DEL 2
2025-07-02 06:07:38.677 checked_mode: {checked_mode}, STDLOG: Records affected: 7
2025-07-02 06:07:38.686 """
2025-07-02 06:07:38.699
2025-07-02 06:07:38.709 act.expected_stdout = expected_stdout_worker
2025-07-02 06:07:38.716 act.stdout = capsys.readouterr().out
2025-07-02 06:07:38.722 > assert act.clean_stdout == act.clean_expected_stdout
2025-07-02 06:07:38.732 E assert
2025-07-02 06:07:38.742 E checked_mode: table, STDLOG: Records affected: 3
2025-07-02 06:07:38.751 E checked_mode: table, STDLOG: ID
2025-07-02 06:07:38.759 E checked_mode: table, STDLOG:
2025-07-02 06:07:38.768 E checked_mode: table, STDLOG: 3
2025-07-02 06:07:38.782 E checked_mode: table, STDLOG: 4
2025-07-02 06:07:38.791 E checked_mode: table, STDLOG: 5
2025-07-02 06:07:38.798 E checked_mode: table, STDLOG: 6
2025-07-02 06:07:38.804 E checked_mode: table, STDLOG: 7
2025-07-02 06:07:38.811 E checked_mode: table, STDLOG: 8
2025-07-02 06:07:38.819 E checked_mode: table, STDLOG: Records affected: 6
2025-07-02 06:07:38.826 E checked_mode: table, STDLOG: OLD_ID OP SNAP_NO_RANK
2025-07-02 06:07:38.832 E checked_mode: table, STDLOG:
2025-07-02 06:07:38.838 E - checked_mode: table, STDLOG: 1 DEL 1
2025-07-02 06:07:38.851 E + checked_mode: table, STDLOG: 1DEL 1
2025-07-02 06:07:38.859 E - checked_mode: table, STDLOG: 2 DEL 1
2025-07-02 06:07:38.873 E + checked_mode: table, STDLOG: 2DEL 1
2025-07-02 06:07:38.880 E - checked_mode: table, STDLOG: 3 DEL 1
2025-07-02 06:07:38.894 E + checked_mode: table, STDLOG: 3DEL 1
2025-07-02 06:07:38.903 E - checked_mode: table, STDLOG: 4 DEL 1
2025-07-02 06:07:38.920 E + checked_mode: table, STDLOG: 4DEL 1
2025-07-02 06:07:38.926 E - checked_mode: table, STDLOG: -1 DEL 2
2025-07-02 06:07:38.946 E + checked_mode: table, STDLOG: -1DEL 2
2025-07-02 06:07:38.957 E - checked_mode: table, STDLOG: 1 DEL 2
2025-07-02 06:07:38.977 E + checked_mode: table, STDLOG: 1DEL 2
2025-07-02 06:07:38.986 E - checked_mode: table, STDLOG: 2 DEL 2
2025-07-02 06:07:39.006 E + checked_mode: table, STDLOG: 2DEL 2
2025-07-02 06:07:39.015 E checked_mode: table, STDLOG: Records affected: 7
2025-07-02 06:07:39.024
2025-07-02 06:07:39.032 tests/functional/transactions/test_read_consist_sttm_restart_on_delete_01.py:447: AssertionError
2025-07-02 06:07:39.041 ---------------------------- Captured stdout setup -----------------------------
2025-07-02 06:07:39.052 Creating db: localhost:/var/tmp/qa_2024/test_12477/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]>
fn_worker_sql = PosixPath('/var/tmp/qa_2024/test_12477/tmp_worker.sql')
fn_worker_log = PosixPath('/var/tmp/qa_2024/test_12477/tmp_worker.log')
fn_worker_err = PosixPath('/var/tmp/qa_2024/test_12477/tmp_worker.err')
capsys = <_pytest.capture.CaptureFixture pytest object at [hex]>
@pytest.mark.trace
@pytest.mark.version('>=4.0.2')
def test_1(act: Action, fn_worker_sql: Path, fn_worker_log: Path, fn_worker_err: Path, capsys):
sql_init = (act.files_dir / 'read-consist-sttm-restart-DDL.sql').read_text()
for checked_mode in('table', 'view'):
target_obj = 'test' if checked_mode == 'table' else 'v_test'
SQL_TO_BE_RESTARTED = f'delete /* {SQL_TAG_THAT_WE_WAITING_FOR} */ from {target_obj} order by id rows ( iif(exists(select 1 from {target_obj} where id < 0), 3, 8 ) )'
# add rows with ID = 1,2,3,4,5:
sql_addi = f'''
set term ^;
execute block as
begin
rdb$set_context('USER_SESSION', 'WHO', 'INIT_DATA');
end
^
set term ;^
insert into {target_obj}(id, x)
select row_number()over(),row_number()over()
from rdb$types rows 5;
commit;
'''
act.isql(switches=['-q'], input = ''.join( (sql_init, sql_addi) ) )
# ::: NOTE ::: We have to immediately quit if any error raised in prepare phase.
# See also letter from dimitr, 01-feb-2022 14:46
assert act.stderr == ''
act.reset()
trace_cfg_items = [
'time_threshold = 0',
'log_errors = true',
'log_statement_start = true',
'log_statement_finish = true',
]
with act.trace(db_events = trace_cfg_items, encoding=locale.getpreferredencoding()):
with act.db.connect() as con_lock_1, act.db.connect() as con_lock_2, act.db.connect() as con_monitoring:
tpb_monitoring = tpb(isolation=Isolation.READ_COMMITTED_RECORD_VERSION, lock_timeout=0)
tx_monitoring = con_monitoring.transaction_manager(tpb_monitoring)
cur_monitoring = tx_monitoring.cursor()
for i,c in enumerate((con_lock_1,con_lock_2)):
sttm = f"execute block as begin rdb$set_context('USER_SESSION', 'WHO', 'LOCKER #{i+1}'); end"
c.execute_immediate(sttm)
#########################
### L O C K E R - 1 ###
#########################
con_lock_1.execute_immediate( f'update {target_obj} set id=id where id = 5' )
worker_sql = f'''
set list on;
set autoddl off;
set term ^;
execute block returns (whoami varchar(30)) as
begin
whoami = 'WORKER'; -- , ATT#' || current_connection;
rdb$set_context('USER_SESSION','WHO', whoami);
-- suspend;
end
^
set term ;^
commit;
--set echo on;
SET KEEP_TRAN_PARAMS ON;
set transaction read committed read consistency;
--select current_connection, current_transaction from rdb$database;
set list off;
set wng off;
--set plan on;
set count on;
-- delete from {target_obj} order by id rows ( iif(exists(select 1 from {target_obj} where id < 0), 3, 8 ) ); -- THIS MUST BE LOCKED
{SQL_TO_BE_RESTARTED};
-- check results:
-- ###############
select id from {target_obj} order by id; -- this will produce output only after all lockers do their commit/rollback
select v.old_id, v.op, v.snap_no_rank
from v_worker_log v
where v.op = 'del';
set width who 10;
-- DO NOT check this! Values can differ here from one run to another!
--select id, trn, who, old_id, new_id, op, rec_vers, global_cn, snap_no from tlog_done order by id;
rollback;
'''
fn_worker_sql.write_text(worker_sql)
with fn_worker_log.open(mode='w') as hang_out, fn_worker_err.open(mode='w') as hang_err:
############################################################################
### L A U N C H W O R K E R U S I N G I S Q L, A S Y N C. ###
############################################################################
p_worker = subprocess.Popen([act.vars['isql'], '-i', str(fn_worker_sql),
'-user', act.db.user,
'-password', act.db.password,
act.db.dsn
],
stdout = hang_out,
stderr = hang_err
)
# NB: when ISQL will establish attach, first record that it must lock is ID = 1 -- see above SQL_TO_BE_RESTARTED
# We must to ensure that this (worker) attachment has been really created and LOCKS this record:
#
wait_for_record_become_locked(tx_monitoring, cur_monitoring, f'update {target_obj} set id=id where id=1', SQL_TAG_THAT_WE_WAITING_FOR)
#########################
### L O C K E R - 2 ###
#########################
con_lock_2.execute_immediate( f'insert into {target_obj}(id) values(6)' )
con_lock_2.commit()
con_lock_2.execute_immediate( f'update {target_obj} set id=id where id = 6' )
#########################
### L O C K E R - 1 ###
#########################
con_lock_1.commit() # releases record with ID = 5 ==> now it can be locked by worker.
# We have to WAIT HERE until worker will actually 'catch' just released record with ID = 5.
#
wait_for_record_become_locked(tx_monitoring, cur_monitoring, f'update {target_obj} set id=id where id=5', SQL_TAG_THAT_WE_WAITING_FOR)
# If we come here then it means that record with ID = 5 for sure is locked by WORKER.
con_lock_1.execute_immediate( f'insert into {target_obj}(id) values(7)' )
con_lock_1.commit()
con_lock_1.execute_immediate( f'update {target_obj} set id=id where id = 7' )
#########################
### L O C K E R - 2 ###
#########################
con_lock_2.commit() # releases record with ID = 6 ==> now it can be locked by worker.
# We have to WAIT HERE until worker will actually 'catch' just released record with ID = 6:
#
wait_for_record_become_locked(tx_monitoring, cur_monitoring, f'update {target_obj} set id=id where id = 6', SQL_TAG_THAT_WE_WAITING_FOR)
# If we come here then it means that record with ID = 6 for sure is locked by WORKER.
con_lock_2.execute_immediate( f'insert into {target_obj}(id) values(8)' )
con_lock_2.commit()
con_lock_2.execute_immediate( f'update {target_obj} set id=id where id = 8' )
#########################
### L O C K E R - 1 ###
#########################
con_lock_1.commit() # releases record with ID = 7 ==> now it can be locked by worker.
# We have to WAIT HERE until worker will actually 'catch' just released record with ID = 7:
#
wait_for_record_become_locked(tx_monitoring, cur_monitoring, f'update {target_obj} set id=id where id = 7', SQL_TAG_THAT_WE_WAITING_FOR)
# If we come here then it means that record with ID = 7 for sure is locked by WORKER.
con_lock_1.execute_immediate( f'insert into {target_obj}(id) values(-1)' )
con_lock_1.commit()
con_lock_2.commit() # WORKER will complete his job after this
# Here we wait for ISQL complete its mission:
p_worker.wait()
#< with act.db.connect()
for g in (fn_worker_log, fn_worker_err):
with g.open() as f:
for line in f:
if line.split():
if g == fn_worker_log:
print(f'checked_mode: {checked_mode}, STDLOG: {line}')
else:
print(f'UNEXPECTED STDERR {line}')
expected_stdout_worker = f"""
checked_mode: {checked_mode}, STDLOG: Records affected: 3
checked_mode: {checked_mode}, STDLOG: ID
checked_mode: {checked_mode}, STDLOG: =======
checked_mode: {checked_mode}, STDLOG: 3
checked_mode: {checked_mode}, STDLOG: 4
checked_mode: {checked_mode}, STDLOG: 5
checked_mode: {checked_mode}, STDLOG: 6
checked_mode: {checked_mode}, STDLOG: 7
checked_mode: {checked_mode}, STDLOG: 8
checked_mode: {checked_mode}, STDLOG: Records affected: 6
checked_mode: {checked_mode}, STDLOG: OLD_ID OP SNAP_NO_RANK
checked_mode: {checked_mode}, STDLOG: ======= ====== =====================
checked_mode: {checked_mode}, STDLOG: 1 DEL 1
checked_mode: {checked_mode}, STDLOG: 2 DEL 1
checked_mode: {checked_mode}, STDLOG: 3 DEL 1
checked_mode: {checked_mode}, STDLOG: 4 DEL 1
checked_mode: {checked_mode}, STDLOG: -1 DEL 2
checked_mode: {checked_mode}, STDLOG: 1 DEL 2
checked_mode: {checked_mode}, STDLOG: 2 DEL 2
checked_mode: {checked_mode}, STDLOG: Records affected: 7
"""
act.expected_stdout = expected_stdout_worker
act.stdout = capsys.readouterr().out
> assert act.clean_stdout == act.clean_expected_stdout
E assert
E checked_mode: table, STDLOG: Records affected: 3
E checked_mode: table, STDLOG: ID
E checked_mode: table, STDLOG:
E checked_mode: table, STDLOG: 3
E checked_mode: table, STDLOG: 4
E checked_mode: table, STDLOG: 5
E checked_mode: table, STDLOG: 6
E checked_mode: table, STDLOG: 7
E checked_mode: table, STDLOG: 8
E checked_mode: table, STDLOG: Records affected: 6
E checked_mode: table, STDLOG: OLD_ID OP SNAP_NO_RANK
E checked_mode: table, STDLOG:
E - checked_mode: table, STDLOG: 1 DEL 1
E + checked_mode: table, STDLOG: 1DEL 1
E - checked_mode: table, STDLOG: 2 DEL 1
E + checked_mode: table, STDLOG: 2DEL 1
E - checked_mode: table, STDLOG: 3 DEL 1
E + checked_mode: table, STDLOG: 3DEL 1
E - checked_mode: table, STDLOG: 4 DEL 1
E + checked_mode: table, STDLOG: 4DEL 1
E - checked_mode: table, STDLOG: -1 DEL 2
E + checked_mode: table, STDLOG: -1DEL 2
E - checked_mode: table, STDLOG: 1 DEL 2
E + checked_mode: table, STDLOG: 1DEL 2
E - checked_mode: table, STDLOG: 2 DEL 2
E + checked_mode: table, STDLOG: 2DEL 2
E checked_mode: table, STDLOG: Records affected: 7
tests/functional/transactions/test_read_consist_sttm_restart_on_delete_01.py:447: AssertionError
|