2 @message |
assert
READ_COMMITTED_NO_RECORD_VERSION drop procedure sp_test
lock conflict on no wait transaction
-unsuccessful metadata update
- -object PROCEDURE "SP_TEST" is in use
+ -object PROCEDURE "PUBLIC"."SP_TEST" is in use
(335544345, 335544351, 335544453)
READ_COMMITTED_NO_RECORD_VERSION drop procedure sp_worker
lock conflict on no wait transaction
-unsuccessful metadata update
- -object PROCEDURE "SP_WORKER" is in use
+ -object PROCEDURE "PUBLIC"."SP_WORKER" is in use
(335544345, 335544351, 335544453)
READ_COMMITTED_NO_RECORD_VERSION drop function fn_worker
lock conflict on no wait transaction
-unsuccessful metadata update
- -object FUNCTION "FN_WORKER" is in use
+ -object FUNCTION "PUBLIC"."FN_WORKER" is in use
(335544345, 335544351, 335544453)
READ_COMMITTED_NO_RECORD_VERSION drop view v_test
lock conflict on no wait transaction
-unsuccessful metadata update
- -object VIEW "V_TEST" is in use
+ -object VIEW "PUBLIC"."V_TEST" is in use
(335544345, 335544351, 335544453)
READ_COMMITTED_NO_RECORD_VERSION drop table test2
lock conflict on no wait transaction
-unsuccessful metadata update
- -object TABLE "TEST2" is in use
+ -object TABLE "PUBLIC"."TEST2" is in use
(335544345, 335544351, 335544453)
READ_COMMITTED_NO_RECORD_VERSION drop index test1_id
lock conflict on no wait transaction
-unsuccessful metadata update
- -object INDEX "TEST1_ID" is in use
+ -object INDEX "PUBLIC"."TEST1_ID" is in use
(335544345, 335544351, 335544453)
READ_COMMITTED_NO_RECORD_VERSION drop index test2_x
lock conflict on no wait transaction
-unsuccessful metadata update
- -object INDEX "TEST2_X" is in use
+ -object INDEX "PUBLIC"."TEST2_X" is in use
(335544345, 335544351, 335544453)
READ_COMMITTED_RECORD_VERSION drop procedure sp_test
lock conflict on no wait transaction
-unsuccessful metadata update
- -object PROCEDURE "SP_TEST" is in use
+ -object PROCEDURE "PUBLIC"."SP_TEST" is in use
(335544345, 335544351, 335544453)
READ_COMMITTED_RECORD_VERSION drop procedure sp_worker
lock conflict on no wait transaction
-unsuccessful metadata update
- -object PROCEDURE "SP_WORKER" is in use
+ -object PROCEDURE "PUBLIC"."SP_WORKER" is in use
(335544345, 335544351, 335544453)
READ_COMMITTED_RECORD_VERSION drop function fn_worker
lock conflict on no wait transaction
-unsuccessful metadata update
- -object FUNCTION "FN_WORKER" is in use
+ -object FUNCTION "PUBLIC"."FN_WORKER" is in use
(335544345, 335544351, 335544453)
READ_COMMITTED_RECORD_VERSION drop view v_test
lock conflict on no wait transaction
-unsuccessful metadata update
- -object VIEW "V_TEST" is in use
+ -object VIEW "PUBLIC"."V_TEST" is in use
(335544345, 335544351, 335544453)
READ_COMMITTED_RECORD_VERSION drop table test2
lock conflict on no wait transaction
-unsuccessful metadata update
- -object TABLE "TEST2" is in use
+ -object TABLE "PUBLIC"."TEST2" is in use
(335544345, 335544351, 335544453)
READ_COMMITTED_RECORD_VERSION drop index test1_id
lock conflict on no wait transaction
-unsuccessful metadata update
- -object INDEX "TEST1_ID" is in use
+ -object INDEX "PUBLIC"."TEST1_ID" is in use
(335544345, 335544351, 335544453)
READ_COMMITTED_RECORD_VERSION drop index test2_x
lock conflict on no wait transaction
-unsuccessful metadata update
- -object INDEX "TEST2_X" is in use
+ -object INDEX "PUBLIC"."TEST2_X" is in use
(335544345, 335544351, 335544453)
SNAPSHOT drop procedure sp_test
lock conflict on no wait transaction
-unsuccessful metadata update
- -object PROCEDURE "SP_TEST" is in use
+ -object PROCEDURE "PUBLIC"."SP_TEST" is in use
(335544345, 335544351, 335544453)
SNAPSHOT drop procedure sp_worker
lock conflict on no wait transaction
-unsuccessful metadata update
- -object PROCEDURE "SP_WORKER" is in use
+ -object PROCEDURE "PUBLIC"."SP_WORKER" is in use
(335544345, 335544351, 335544453)
SNAPSHOT drop function fn_worker
lock conflict on no wait transaction
-unsuccessful metadata update
- -object FUNCTION "FN_WORKER" is in use
+ -object FUNCTION "PUBLIC"."FN_WORKER" is in use
(335544345, 335544351, 335544453)
SNAPSHOT drop view v_test
lock conflict on no wait transaction
-unsuccessful metadata update
- -object VIEW "V_TEST" is in use
+ -object VIEW "PUBLIC"."V_TEST" is in use
(335544345, 335544351, 335544453)
SNAPSHOT drop table test2
lock conflict on no wait transaction
-unsuccessful metadata update
- -object TABLE "TEST2" is in use
+ -object TABLE "PUBLIC"."TEST2" is in use
(335544345, 335544351, 335544453)
SNAPSHOT drop index test1_id
lock conflict on no wait transaction
-unsuccessful metadata update
- -object INDEX "TEST1_ID" is in use
+ -object INDEX "PUBLIC"."TEST1_ID" is in use
(335544345, 335544351, 335544453)
SNAPSHOT drop index test2_x
lock conflict on no wait transaction
-unsuccessful metadata update
- -object INDEX "TEST2_X" is in use
+ -object INDEX "PUBLIC"."TEST2_X" is in use
(335544345, 335544351, 335544453)
SERIALIZABLE drop procedure sp_test
lock conflict on no wait transaction
-unsuccessful metadata update
- -object PROCEDURE "SP_TEST" is in use
+ -object PROCEDURE "PUBLIC"."SP_TEST" is in use
(335544345, 335544351, 335544453)
SERIALIZABLE drop procedure sp_worker
lock conflict on no wait transaction
-unsuccessful metadata update
- -object PROCEDURE "SP_WORKER" is in use
+ -object PROCEDURE "PUBLIC"."SP_WORKER" is in use
(335544345, 335544351, 335544453)
SERIALIZABLE drop function fn_worker
lock conflict on no wait transaction
-unsuccessful metadata update
- -object FUNCTION "FN_WORKER" is in use
+ -object FUNCTION "PUBLIC"."FN_WORKER" is in use
(335544345, 335544351, 335544453)
SERIALIZABLE drop view v_test
lock conflict on no wait transaction
-unsuccessful metadata update
- -object VIEW "V_TEST" is in use
+ -object VIEW "PUBLIC"."V_TEST" is in use
(335544345, 335544351, 335544453)
SERIALIZABLE drop table test2
lock conflict on no wait transaction
-unsuccessful metadata update
- -object TABLE "TEST2" is in use
+ -object TABLE "PUBLIC"."TEST2" is in use
(335544345, 335544351, 335544453)
SERIALIZABLE drop index test1_id
lock conflict on no wait transaction
-unsuccessful metadata update
- -object INDEX "TEST1_ID" is in use
+ -object INDEX "PUBLIC"."TEST1_ID" is in use
(335544345, 335544351, 335544453)
SERIALIZABLE drop index test2_x
lock conflict on no wait transaction
-unsuccessful metadata update
- -object INDEX "TEST2_X" is in use
+ -object INDEX "PUBLIC"."TEST2_X" is in use
(335544345, 335544351, 335544453)
READ_COMMITTED_READ_CONSISTENCY drop procedure sp_test
lock conflict on no wait transaction
-unsuccessful metadata update
- -object PROCEDURE "SP_TEST" is in use
+ -object PROCEDURE "PUBLIC"."SP_TEST" is in use
(335544345, 335544351, 335544453)
READ_COMMITTED_READ_CONSISTENCY drop procedure sp_worker
lock conflict on no wait transaction
-unsuccessful metadata update
- -object PROCEDURE "SP_WORKER" is in use
+ -object PROCEDURE "PUBLIC"."SP_WORKER" is in use
(335544345, 335544351, 335544453)
READ_COMMITTED_READ_CONSISTENCY drop function fn_worker
lock conflict on no wait transaction
-unsuccessful metadata update
- -object FUNCTION "FN_WORKER" is in use
+ -object FUNCTION "PUBLIC"."FN_WORKER" is in use
(335544345, 335544351, 335544453)
READ_COMMITTED_READ_CONSISTENCY drop view v_test
lock conflict on no wait transaction
-unsuccessful metadata update
- -object VIEW "V_TEST" is in use
+ -object VIEW "PUBLIC"."V_TEST" is in use
(335544345, 335544351, 335544453)
READ_COMMITTED_READ_CONSISTENCY drop table test2
lock conflict on no wait transaction
-unsuccessful metadata update
- -object TABLE "TEST2" is in use
+ -object TABLE "PUBLIC"."TEST2" is in use
(335544345, 335544351, 335544453)
READ_COMMITTED_READ_CONSISTENCY drop index test1_id
lock conflict on no wait transaction
-unsuccessful metadata update
- -object INDEX "TEST1_ID" is in use
+ -object INDEX "PUBLIC"."TEST1_ID" is in use
(335544345, 335544351, 335544453)
READ_COMMITTED_READ_CONSISTENCY drop index test2_x
lock conflict on no wait transaction
-unsuccessful metadata update
- -object INDEX "TEST2_X" is in use
+ -object INDEX "PUBLIC"."TEST2_X" is in use
(335544345, 335544351, 335544453)
LOG DETAILS:
2025-06-28 06:38:15.715
2025-06-28 06:38:15.715 act = <firebird.qa.plugin.Action object at [hex]>
2025-06-28 06:38:15.716 capsys = <_pytest.capture.CaptureFixture object at [hex]>
2025-06-28 06:38:15.716
2025-06-28 06:38:15.716 @pytest.mark.version('>=4.0')
2025-06-28 06:38:15.716 def test_1(act: Action, capsys):
2025-06-28 06:38:15.716 act.isql(switches=[], input=ddl_script)
2025-06-28 06:38:15.716
2025-06-28 06:38:15.716 drop_commands = [ 'drop procedure sp_test',
2025-06-28 06:38:15.716 'drop procedure sp_worker',
2025-06-28 06:38:15.716 'drop function fn_worker',
2025-06-28 06:38:15.716 'drop view v_test',
2025-06-28 06:38:15.716 'drop table test2',
2025-06-28 06:38:15.716 'drop index test1_id',
2025-06-28 06:38:15.716 'drop index test2_x'
2025-06-28 06:38:15.716 ]
2025-06-28 06:38:15.716
2025-06-28 06:38:15.716 tx_isol_lst = [ Isolation.READ_COMMITTED_NO_RECORD_VERSION,
2025-06-28 06:38:15.716 Isolation.READ_COMMITTED_RECORD_VERSION,
2025-06-28 06:38:15.716 Isolation.SNAPSHOT,
2025-06-28 06:38:15.716 Isolation.SERIALIZABLE,
2025-06-28 06:38:15.716 ]
2025-06-28 06:38:15.717 if act.is_version('>=4'):
2025-06-28 06:38:15.717 tx_isol_lst.append(Isolation.READ_COMMITTED_READ_CONSISTENCY)
2025-06-28 06:38:15.717
2025-06-28 06:38:15.717 # for any isolation mode attempt to drop object that is in use by another Tx must fail
2025-06-28 06:38:15.717 # with the same error message. We check all possible Tx isolation modes for that:
2025-06-28 06:38:15.717 for x_isol in tx_isol_lst:
2025-06-28 06:38:15.717
2025-06-28 06:38:15.717 with act.db.connect() as con1:
2025-06-28 06:38:15.717
2025-06-28 06:38:15.717 cur1 = con1.cursor()
2025-06-28 06:38:15.717 cur1.execute('select x from sp_test(21)').fetchall()
2025-06-28 06:38:15.717
2025-06-28 06:38:15.717 for cmd in drop_commands:
2025-06-28 06:38:15.717 with act.db.connect() as con2:
2025-06-28 06:38:15.717 custom_tpb = tpb(isolation = x_isol, lock_timeout=0)
2025-06-28 06:38:15.717 print(x_isol.name, cmd)
2025-06-28 06:38:15.717 tx2 = con2.transaction_manager(custom_tpb)
2025-06-28 06:38:15.717 tx2.begin()
2025-06-28 06:38:15.717 cur2 = tx2.cursor()
2025-06-28 06:38:15.717 try:
2025-06-28 06:38:15.718 cur2.execute(cmd) # this will PASS because of DDL nature
2025-06-28 06:38:15.718
2025-06-28 06:38:15.718 ##########################################################################
2025-06-28 06:38:15.718 ### We have to call commit() exactly by TRANSACTION object here. ###
2025-06-28 06:38:15.718 ### DO NOT use con2.commit() because this actually leads transaction ###
2025-06-28 06:38:15.718 ### to be 'silently rolled back', thus we will not get error messages! ###
2025-06-28 06:38:15.718 ##########################################################################
2025-06-28 06:38:15.718 tx2.commit() # <<< this lead to FAILED_COMMIT in the trace <<<
2025-06-28 06:38:15.718
2025-06-28 06:38:15.718 except Exception as e:
2025-06-28 06:38:15.718 print(e.__str__())
2025-06-28 06:38:15.718 print(e.gds_codes)
2025-06-28 06:38:15.718
2025-06-28 06:38:15.718 act.expected_stdout = f"""
2025-06-28 06:38:15.718 READ_COMMITTED_NO_RECORD_VERSION drop procedure sp_test
2025-06-28 06:38:15.718 lock conflict on no wait transaction
2025-06-28 06:38:15.718 -unsuccessful metadata update
2025-06-28 06:38:15.718 -object PROCEDURE "SP_TEST" is in use
2025-06-28 06:38:15.718 (335544345, 335544351, 335544453)
2025-06-28 06:38:15.718
2025-06-28 06:38:15.718 READ_COMMITTED_NO_RECORD_VERSION drop procedure sp_worker
2025-06-28 06:38:15.719 lock conflict on no wait transaction
2025-06-28 06:38:15.719 -unsuccessful metadata update
2025-06-28 06:38:15.719 -object PROCEDURE "SP_WORKER" is in use
2025-06-28 06:38:15.719 (335544345, 335544351, 335544453)
2025-06-28 06:38:15.719
2025-06-28 06:38:15.719 READ_COMMITTED_NO_RECORD_VERSION drop function fn_worker
2025-06-28 06:38:15.719 lock conflict on no wait transaction
2025-06-28 06:38:15.719 -unsuccessful metadata update
2025-06-28 06:38:15.719 -object FUNCTION "FN_WORKER" is in use
2025-06-28 06:38:15.719 (335544345, 335544351, 335544453)
2025-06-28 06:38:15.719
2025-06-28 06:38:15.719 READ_COMMITTED_NO_RECORD_VERSION drop view v_test
2025-06-28 06:38:15.719 lock conflict on no wait transaction
2025-06-28 06:38:15.719 -unsuccessful metadata update
2025-06-28 06:38:15.719 -object VIEW "V_TEST" is in use
2025-06-28 06:38:15.719 (335544345, 335544351, 335544453)
2025-06-28 06:38:15.719
2025-06-28 06:38:15.719 READ_COMMITTED_NO_RECORD_VERSION drop table test2
2025-06-28 06:38:15.719 lock conflict on no wait transaction
2025-06-28 06:38:15.719 -unsuccessful metadata update
2025-06-28 06:38:15.720 -object TABLE "TEST2" is in use
2025-06-28 06:38:15.720 (335544345, 335544351, 335544453)
2025-06-28 06:38:15.720
2025-06-28 06:38:15.720 READ_COMMITTED_NO_RECORD_VERSION drop index test1_id
2025-06-28 06:38:15.720 lock conflict on no wait transaction
2025-06-28 06:38:15.720 -unsuccessful metadata update
2025-06-28 06:38:15.720 -object INDEX "TEST1_ID" is in use
2025-06-28 06:38:15.720 (335544345, 335544351, 335544453)
2025-06-28 06:38:15.720
2025-06-28 06:38:15.720 READ_COMMITTED_NO_RECORD_VERSION drop index test2_x
2025-06-28 06:38:15.720 lock conflict on no wait transaction
2025-06-28 06:38:15.720 -unsuccessful metadata update
2025-06-28 06:38:15.720 -object INDEX "TEST2_X" is in use
2025-06-28 06:38:15.720 (335544345, 335544351, 335544453)
2025-06-28 06:38:15.720
2025-06-28 06:38:15.720 READ_COMMITTED_RECORD_VERSION drop procedure sp_test
2025-06-28 06:38:15.720 lock conflict on no wait transaction
2025-06-28 06:38:15.720 -unsuccessful metadata update
2025-06-28 06:38:15.720 -object PROCEDURE "SP_TEST" is in use
2025-06-28 06:38:15.720 (335544345, 335544351, 335544453)
2025-06-28 06:38:15.720
2025-06-28 06:38:15.721 READ_COMMITTED_RECORD_VERSION drop procedure sp_worker
2025-06-28 06:38:15.721 lock conflict on no wait transaction
2025-06-28 06:38:15.721 -unsuccessful metadata update
2025-06-28 06:38:15.721 -object PROCEDURE "SP_WORKER" is in use
2025-06-28 06:38:15.721 (335544345, 335544351, 335544453)
2025-06-28 06:38:15.721
2025-06-28 06:38:15.721 READ_COMMITTED_RECORD_VERSION drop function fn_worker
2025-06-28 06:38:15.721 lock conflict on no wait transaction
2025-06-28 06:38:15.721 -unsuccessful metadata update
2025-06-28 06:38:15.721 -object FUNCTION "FN_WORKER" is in use
2025-06-28 06:38:15.721 (335544345, 335544351, 335544453)
2025-06-28 06:38:15.721
2025-06-28 06:38:15.721 READ_COMMITTED_RECORD_VERSION drop view v_test
2025-06-28 06:38:15.721 lock conflict on no wait transaction
2025-06-28 06:38:15.721 -unsuccessful metadata update
2025-06-28 06:38:15.721 -object VIEW "V_TEST" is in use
2025-06-28 06:38:15.721 (335544345, 335544351, 335544453)
2025-06-28 06:38:15.721
2025-06-28 06:38:15.721 READ_COMMITTED_RECORD_VERSION drop table test2
2025-06-28 06:38:15.721 lock conflict on no wait transaction
2025-06-28 06:38:15.721 -unsuccessful metadata update
2025-06-28 06:38:15.722 -object TABLE "TEST2" is in use
2025-06-28 06:38:15.722 (335544345, 335544351, 335544453)
2025-06-28 06:38:15.722
2025-06-28 06:38:15.722 READ_COMMITTED_RECORD_VERSION drop index test1_id
2025-06-28 06:38:15.722 lock conflict on no wait transaction
2025-06-28 06:38:15.722 -unsuccessful metadata update
2025-06-28 06:38:15.722 -object INDEX "TEST1_ID" is in use
2025-06-28 06:38:15.722 (335544345, 335544351, 335544453)
2025-06-28 06:38:15.722
2025-06-28 06:38:15.722 READ_COMMITTED_RECORD_VERSION drop index test2_x
2025-06-28 06:38:15.722 lock conflict on no wait transaction
2025-06-28 06:38:15.722 -unsuccessful metadata update
2025-06-28 06:38:15.722 -object INDEX "TEST2_X" is in use
2025-06-28 06:38:15.722 (335544345, 335544351, 335544453)
2025-06-28 06:38:15.722
2025-06-28 06:38:15.722 SNAPSHOT drop procedure sp_test
2025-06-28 06:38:15.722 lock conflict on no wait transaction
2025-06-28 06:38:15.722 -unsuccessful metadata update
2025-06-28 06:38:15.722 -object PROCEDURE "SP_TEST" is in use
2025-06-28 06:38:15.722 (335544345, 335544351, 335544453)
2025-06-28 06:38:15.723
2025-06-28 06:38:15.723 SNAPSHOT drop procedure sp_worker
2025-06-28 06:38:15.723 lock conflict on no wait transaction
2025-06-28 06:38:15.723 -unsuccessful metadata update
2025-06-28 06:38:15.723 -object PROCEDURE "SP_WORKER" is in use
2025-06-28 06:38:15.723 (335544345, 335544351, 335544453)
2025-06-28 06:38:15.723
2025-06-28 06:38:15.723 SNAPSHOT drop function fn_worker
2025-06-28 06:38:15.723 lock conflict on no wait transaction
2025-06-28 06:38:15.723 -unsuccessful metadata update
2025-06-28 06:38:15.723 -object FUNCTION "FN_WORKER" is in use
2025-06-28 06:38:15.723 (335544345, 335544351, 335544453)
2025-06-28 06:38:15.723
2025-06-28 06:38:15.723 SNAPSHOT drop view v_test
2025-06-28 06:38:15.723 lock conflict on no wait transaction
2025-06-28 06:38:15.723 -unsuccessful metadata update
2025-06-28 06:38:15.723 -object VIEW "V_TEST" is in use
2025-06-28 06:38:15.723 (335544345, 335544351, 335544453)
2025-06-28 06:38:15.723
2025-06-28 06:38:15.723 SNAPSHOT drop table test2
2025-06-28 06:38:15.724 lock conflict on no wait transaction
2025-06-28 06:38:15.724 -unsuccessful metadata update
2025-06-28 06:38:15.724 -object TABLE "TEST2" is in use
2025-06-28 06:38:15.724 (335544345, 335544351, 335544453)
2025-06-28 06:38:15.724
2025-06-28 06:38:15.724 SNAPSHOT drop index test1_id
2025-06-28 06:38:15.724 lock conflict on no wait transaction
2025-06-28 06:38:15.724 -unsuccessful metadata update
2025-06-28 06:38:15.724 -object INDEX "TEST1_ID" is in use
2025-06-28 06:38:15.724 (335544345, 335544351, 335544453)
2025-06-28 06:38:15.724
2025-06-28 06:38:15.724 SNAPSHOT drop index test2_x
2025-06-28 06:38:15.724 lock conflict on no wait transaction
2025-06-28 06:38:15.724 -unsuccessful metadata update
2025-06-28 06:38:15.724 -object INDEX "TEST2_X" is in use
2025-06-28 06:38:15.724 (335544345, 335544351, 335544453)
2025-06-28 06:38:15.724
2025-06-28 06:38:15.724 SERIALIZABLE drop procedure sp_test
2025-06-28 06:38:15.724 lock conflict on no wait transaction
2025-06-28 06:38:15.724 -unsuccessful metadata update
2025-06-28 06:38:15.725 -object PROCEDURE "SP_TEST" is in use
2025-06-28 06:38:15.725 (335544345, 335544351, 335544453)
2025-06-28 06:38:15.725
2025-06-28 06:38:15.725 SERIALIZABLE drop procedure sp_worker
2025-06-28 06:38:15.725 lock conflict on no wait transaction
2025-06-28 06:38:15.725 -unsuccessful metadata update
2025-06-28 06:38:15.725 -object PROCEDURE "SP_WORKER" is in use
2025-06-28 06:38:15.725 (335544345, 335544351, 335544453)
2025-06-28 06:38:15.725
2025-06-28 06:38:15.725 SERIALIZABLE drop function fn_worker
2025-06-28 06:38:15.725 lock conflict on no wait transaction
2025-06-28 06:38:15.725 -unsuccessful metadata update
2025-06-28 06:38:15.725 -object FUNCTION "FN_WORKER" is in use
2025-06-28 06:38:15.725 (335544345, 335544351, 335544453)
2025-06-28 06:38:15.725
2025-06-28 06:38:15.725 SERIALIZABLE drop view v_test
2025-06-28 06:38:15.725 lock conflict on no wait transaction
2025-06-28 06:38:15.725 -unsuccessful metadata update
2025-06-28 06:38:15.725 -object VIEW "V_TEST" is in use
2025-06-28 06:38:15.725 (335544345, 335544351, 335544453)
2025-06-28 06:38:15.725
2025-06-28 06:38:15.726 SERIALIZABLE drop table test2
2025-06-28 06:38:15.726 lock conflict on no wait transaction
2025-06-28 06:38:15.726 -unsuccessful metadata update
2025-06-28 06:38:15.726 -object TABLE "TEST2" is in use
2025-06-28 06:38:15.726 (335544345, 335544351, 335544453)
2025-06-28 06:38:15.726
2025-06-28 06:38:15.726 SERIALIZABLE drop index test1_id
2025-06-28 06:38:15.726 lock conflict on no wait transaction
2025-06-28 06:38:15.726 -unsuccessful metadata update
2025-06-28 06:38:15.726 -object INDEX "TEST1_ID" is in use
2025-06-28 06:38:15.726 (335544345, 335544351, 335544453)
2025-06-28 06:38:15.726
2025-06-28 06:38:15.726 SERIALIZABLE drop index test2_x
2025-06-28 06:38:15.726 lock conflict on no wait transaction
2025-06-28 06:38:15.726 -unsuccessful metadata update
2025-06-28 06:38:15.726 -object INDEX "TEST2_X" is in use
2025-06-28 06:38:15.726 (335544345, 335544351, 335544453)
2025-06-28 06:38:15.726
2025-06-28 06:38:15.726 READ_COMMITTED_READ_CONSISTENCY drop procedure sp_test
2025-06-28 06:38:15.726 lock conflict on no wait transaction
2025-06-28 06:38:15.727 -unsuccessful metadata update
2025-06-28 06:38:15.727 -object PROCEDURE "SP_TEST" is in use
2025-06-28 06:38:15.727 (335544345, 335544351, 335544453)
2025-06-28 06:38:15.727
2025-06-28 06:38:15.727 READ_COMMITTED_READ_CONSISTENCY drop procedure sp_worker
2025-06-28 06:38:15.727 lock conflict on no wait transaction
2025-06-28 06:38:15.727 -unsuccessful metadata update
2025-06-28 06:38:15.727 -object PROCEDURE "SP_WORKER" is in use
2025-06-28 06:38:15.727 (335544345, 335544351, 335544453)
2025-06-28 06:38:15.727
2025-06-28 06:38:15.727 READ_COMMITTED_READ_CONSISTENCY drop function fn_worker
2025-06-28 06:38:15.727 lock conflict on no wait transaction
2025-06-28 06:38:15.727 -unsuccessful metadata update
2025-06-28 06:38:15.727 -object FUNCTION "FN_WORKER" is in use
2025-06-28 06:38:15.727 (335544345, 335544351, 335544453)
2025-06-28 06:38:15.727
2025-06-28 06:38:15.727 READ_COMMITTED_READ_CONSISTENCY drop view v_test
2025-06-28 06:38:15.727 lock conflict on no wait transaction
2025-06-28 06:38:15.727 -unsuccessful metadata update
2025-06-28 06:38:15.727 -object VIEW "V_TEST" is in use
2025-06-28 06:38:15.727 (335544345, 335544351, 335544453)
2025-06-28 06:38:15.728
2025-06-28 06:38:15.728 READ_COMMITTED_READ_CONSISTENCY drop table test2
2025-06-28 06:38:15.728 lock conflict on no wait transaction
2025-06-28 06:38:15.728 -unsuccessful metadata update
2025-06-28 06:38:15.728 -object TABLE "TEST2" is in use
2025-06-28 06:38:15.728 (335544345, 335544351, 335544453)
2025-06-28 06:38:15.728
2025-06-28 06:38:15.728 READ_COMMITTED_READ_CONSISTENCY drop index test1_id
2025-06-28 06:38:15.728 lock conflict on no wait transaction
2025-06-28 06:38:15.728 -unsuccessful metadata update
2025-06-28 06:38:15.728 -object INDEX "TEST1_ID" is in use
2025-06-28 06:38:15.728 (335544345, 335544351, 335544453)
2025-06-28 06:38:15.728
2025-06-28 06:38:15.728 READ_COMMITTED_READ_CONSISTENCY drop index test2_x
2025-06-28 06:38:15.728 lock conflict on no wait transaction
2025-06-28 06:38:15.728 -unsuccessful metadata update
2025-06-28 06:38:15.728 -object INDEX "TEST2_X" is in use
2025-06-28 06:38:15.728 (335544345, 335544351, 335544453)
2025-06-28 06:38:15.728 """
2025-06-28 06:38:15.728
2025-06-28 06:38:15.729 act.stdout = capsys.readouterr().out
2025-06-28 06:38:15.729 > assert act.clean_stdout == act.clean_expected_stdout
2025-06-28 06:38:15.729 E assert
2025-06-28 06:38:15.729 E READ_COMMITTED_NO_RECORD_VERSION drop procedure sp_test
2025-06-28 06:38:15.729 E lock conflict on no wait transaction
2025-06-28 06:38:15.729 E -unsuccessful metadata update
2025-06-28 06:38:15.729 E - -object PROCEDURE "SP_TEST" is in use
2025-06-28 06:38:15.729 E + -object PROCEDURE "PUBLIC"."SP_TEST" is in use
2025-06-28 06:38:15.729 E (335544345, 335544351, 335544453)
2025-06-28 06:38:15.729 E READ_COMMITTED_NO_RECORD_VERSION drop procedure sp_worker
2025-06-28 06:38:15.729 E lock conflict on no wait transaction
2025-06-28 06:38:15.729 E -unsuccessful metadata update
2025-06-28 06:38:15.729 E - -object PROCEDURE "SP_WORKER" is in use
2025-06-28 06:38:15.729 E + -object PROCEDURE "PUBLIC"."SP_WORKER" is in use
2025-06-28 06:38:15.729 E (335544345, 335544351, 335544453)
2025-06-28 06:38:15.729 E READ_COMMITTED_NO_RECORD_VERSION drop function fn_worker
2025-06-28 06:38:15.729 E lock conflict on no wait transaction
2025-06-28 06:38:15.729 E -unsuccessful metadata update
2025-06-28 06:38:15.729 E - -object FUNCTION "FN_WORKER" is in use
2025-06-28 06:38:15.730 E + -object FUNCTION "PUBLIC"."FN_WORKER" is in use
2025-06-28 06:38:15.730 E (335544345, 335544351, 335544453)
2025-06-28 06:38:15.730 E READ_COMMITTED_NO_RECORD_VERSION drop view v_test
2025-06-28 06:38:15.730 E lock conflict on no wait transaction
2025-06-28 06:38:15.730 E -unsuccessful metadata update
2025-06-28 06:38:15.730 E - -object VIEW "V_TEST" is in use
2025-06-28 06:38:15.730 E + -object VIEW "PUBLIC"."V_TEST" is in use
2025-06-28 06:38:15.730 E (335544345, 335544351, 335544453)
2025-06-28 06:38:15.730 E READ_COMMITTED_NO_RECORD_VERSION drop table test2
2025-06-28 06:38:15.730 E lock conflict on no wait transaction
2025-06-28 06:38:15.730 E -unsuccessful metadata update
2025-06-28 06:38:15.730 E - -object TABLE "TEST2" is in use
2025-06-28 06:38:15.730 E + -object TABLE "PUBLIC"."TEST2" is in use
2025-06-28 06:38:15.730 E (335544345, 335544351, 335544453)
2025-06-28 06:38:15.730 E READ_COMMITTED_NO_RECORD_VERSION drop index test1_id
2025-06-28 06:38:15.730 E lock conflict on no wait transaction
2025-06-28 06:38:15.730 E -unsuccessful metadata update
2025-06-28 06:38:15.731 E - -object INDEX "TEST1_ID" is in use
2025-06-28 06:38:15.731 E + -object INDEX "PUBLIC"."TEST1_ID" is in use
2025-06-28 06:38:15.731 E (335544345, 335544351, 335544453)
2025-06-28 06:38:15.731 E READ_COMMITTED_NO_RECORD_VERSION drop index test2_x
2025-06-28 06:38:15.731 E lock conflict on no wait transaction
2025-06-28 06:38:15.731 E -unsuccessful metadata update
2025-06-28 06:38:15.731 E - -object INDEX "TEST2_X" is in use
2025-06-28 06:38:15.731 E + -object INDEX "PUBLIC"."TEST2_X" is in use
2025-06-28 06:38:15.731 E (335544345, 335544351, 335544453)
2025-06-28 06:38:15.731 E READ_COMMITTED_RECORD_VERSION drop procedure sp_test
2025-06-28 06:38:15.731 E lock conflict on no wait transaction
2025-06-28 06:38:15.731 E -unsuccessful metadata update
2025-06-28 06:38:15.731 E - -object PROCEDURE "SP_TEST" is in use
2025-06-28 06:38:15.731 E + -object PROCEDURE "PUBLIC"."SP_TEST" is in use
2025-06-28 06:38:15.731 E (335544345, 335544351, 335544453)
2025-06-28 06:38:15.731 E READ_COMMITTED_RECORD_VERSION drop procedure sp_worker
2025-06-28 06:38:15.731 E lock conflict on no wait transaction
2025-06-28 06:38:15.731 E -unsuccessful metadata update
2025-06-28 06:38:15.732 E - -object PROCEDURE "SP_WORKER" is in use
2025-06-28 06:38:15.732 E + -object PROCEDURE "PUBLIC"."SP_WORKER" is in use
2025-06-28 06:38:15.732 E (335544345, 335544351, 335544453)
2025-06-28 06:38:15.732 E READ_COMMITTED_RECORD_VERSION drop function fn_worker
2025-06-28 06:38:15.732 E lock conflict on no wait transaction
2025-06-28 06:38:15.732 E -unsuccessful metadata update
2025-06-28 06:38:15.732 E - -object FUNCTION "FN_WORKER" is in use
2025-06-28 06:38:15.732 E + -object FUNCTION "PUBLIC"."FN_WORKER" is in use
2025-06-28 06:38:15.732 E (335544345, 335544351, 335544453)
2025-06-28 06:38:15.732 E READ_COMMITTED_RECORD_VERSION drop view v_test
2025-06-28 06:38:15.732 E lock conflict on no wait transaction
2025-06-28 06:38:15.732 E -unsuccessful metadata update
2025-06-28 06:38:15.732 E - -object VIEW "V_TEST" is in use
2025-06-28 06:38:15.732 E + -object VIEW "PUBLIC"."V_TEST" is in use
2025-06-28 06:38:15.734 E (335544345, 335544351, 335544453)
2025-06-28 06:38:15.735 E READ_COMMITTED_RECORD_VERSION drop table test2
2025-06-28 06:38:15.735 E lock conflict on no wait transaction
2025-06-28 06:38:15.735 E -unsuccessful metadata update
2025-06-28 06:38:15.735 E - -object TABLE "TEST2" is in use
2025-06-28 06:38:15.735 E + -object TABLE "PUBLIC"."TEST2" is in use
2025-06-28 06:38:15.735 E (335544345, 335544351, 335544453)
2025-06-28 06:38:15.735 E READ_COMMITTED_RECORD_VERSION drop index test1_id
2025-06-28 06:38:15.735 E lock conflict on no wait transaction
2025-06-28 06:38:15.735 E -unsuccessful metadata update
2025-06-28 06:38:15.735 E - -object INDEX "TEST1_ID" is in use
2025-06-28 06:38:15.735 E + -object INDEX "PUBLIC"."TEST1_ID" is in use
2025-06-28 06:38:15.735 E (335544345, 335544351, 335544453)
2025-06-28 06:38:15.735 E READ_COMMITTED_RECORD_VERSION drop index test2_x
2025-06-28 06:38:15.735 E lock conflict on no wait transaction
2025-06-28 06:38:15.735 E -unsuccessful metadata update
2025-06-28 06:38:15.735 E - -object INDEX "TEST2_X" is in use
2025-06-28 06:38:15.735 E + -object INDEX "PUBLIC"."TEST2_X" is in use
2025-06-28 06:38:15.736 E (335544345, 335544351, 335544453)
2025-06-28 06:38:15.736 E SNAPSHOT drop procedure sp_test
2025-06-28 06:38:15.736 E lock conflict on no wait transaction
2025-06-28 06:38:15.736 E -unsuccessful metadata update
2025-06-28 06:38:15.736 E - -object PROCEDURE "SP_TEST" is in use
2025-06-28 06:38:15.736 E + -object PROCEDURE "PUBLIC"."SP_TEST" is in use
2025-06-28 06:38:15.736 E (335544345, 335544351, 335544453)
2025-06-28 06:38:15.736 E SNAPSHOT drop procedure sp_worker
2025-06-28 06:38:15.736 E lock conflict on no wait transaction
2025-06-28 06:38:15.736 E -unsuccessful metadata update
2025-06-28 06:38:15.736 E - -object PROCEDURE "SP_WORKER" is in use
2025-06-28 06:38:15.736 E + -object PROCEDURE "PUBLIC"."SP_WORKER" is in use
2025-06-28 06:38:15.736 E (335544345, 335544351, 335544453)
2025-06-28 06:38:15.736 E SNAPSHOT drop function fn_worker
2025-06-28 06:38:15.736 E lock conflict on no wait transaction
2025-06-28 06:38:15.736 E -unsuccessful metadata update
2025-06-28 06:38:15.736 E - -object FUNCTION "FN_WORKER" is in use
2025-06-28 06:38:15.736 E + -object FUNCTION "PUBLIC"."FN_WORKER" is in use
2025-06-28 06:38:15.737 E (335544345, 335544351, 335544453)
2025-06-28 06:38:15.737 E SNAPSHOT drop view v_test
2025-06-28 06:38:15.737 E lock conflict on no wait transaction
2025-06-28 06:38:15.737 E -unsuccessful metadata update
2025-06-28 06:38:15.737 E - -object VIEW "V_TEST" is in use
2025-06-28 06:38:15.737 E + -object VIEW "PUBLIC"."V_TEST" is in use
2025-06-28 06:38:15.737 E (335544345, 335544351, 335544453)
2025-06-28 06:38:15.737 E SNAPSHOT drop table test2
2025-06-28 06:38:15.737 E lock conflict on no wait transaction
2025-06-28 06:38:15.737 E -unsuccessful metadata update
2025-06-28 06:38:15.737 E - -object TABLE "TEST2" is in use
2025-06-28 06:38:15.737 E + -object TABLE "PUBLIC"."TEST2" is in use
2025-06-28 06:38:15.737 E (335544345, 335544351, 335544453)
2025-06-28 06:38:15.737 E SNAPSHOT drop index test1_id
2025-06-28 06:38:15.737 E lock conflict on no wait transaction
2025-06-28 06:38:15.737 E -unsuccessful metadata update
2025-06-28 06:38:15.737 E - -object INDEX "TEST1_ID" is in use
2025-06-28 06:38:15.737 E + -object INDEX "PUBLIC"."TEST1_ID" is in use
2025-06-28 06:38:15.738 E (335544345, 335544351, 335544453)
2025-06-28 06:38:15.738 E SNAPSHOT drop index test2_x
2025-06-28 06:38:15.738 E lock conflict on no wait transaction
2025-06-28 06:38:15.738 E -unsuccessful metadata update
2025-06-28 06:38:15.738 E - -object INDEX "TEST2_X" is in use
2025-06-28 06:38:15.738 E + -object INDEX "PUBLIC"."TEST2_X" is in use
2025-06-28 06:38:15.738 E (335544345, 335544351, 335544453)
2025-06-28 06:38:15.738 E SERIALIZABLE drop procedure sp_test
2025-06-28 06:38:15.738 E lock conflict on no wait transaction
2025-06-28 06:38:15.738 E -unsuccessful metadata update
2025-06-28 06:38:15.738 E - -object PROCEDURE "SP_TEST" is in use
2025-06-28 06:38:15.738 E + -object PROCEDURE "PUBLIC"."SP_TEST" is in use
2025-06-28 06:38:15.738 E (335544345, 335544351, 335544453)
2025-06-28 06:38:15.738 E SERIALIZABLE drop procedure sp_worker
2025-06-28 06:38:15.738 E lock conflict on no wait transaction
2025-06-28 06:38:15.738 E -unsuccessful metadata update
2025-06-28 06:38:15.738 E - -object PROCEDURE "SP_WORKER" is in use
2025-06-28 06:38:15.739 E + -object PROCEDURE "PUBLIC"."SP_WORKER" is in use
2025-06-28 06:38:15.739 E (335544345, 335544351, 335544453)
2025-06-28 06:38:15.739 E SERIALIZABLE drop function fn_worker
2025-06-28 06:38:15.739 E lock conflict on no wait transaction
2025-06-28 06:38:15.739 E -unsuccessful metadata update
2025-06-28 06:38:15.739 E - -object FUNCTION "FN_WORKER" is in use
2025-06-28 06:38:15.739 E + -object FUNCTION "PUBLIC"."FN_WORKER" is in use
2025-06-28 06:38:15.739 E (335544345, 335544351, 335544453)
2025-06-28 06:38:15.739 E SERIALIZABLE drop view v_test
2025-06-28 06:38:15.739 E lock conflict on no wait transaction
2025-06-28 06:38:15.739 E -unsuccessful metadata update
2025-06-28 06:38:15.739 E - -object VIEW "V_TEST" is in use
2025-06-28 06:38:15.739 E + -object VIEW "PUBLIC"."V_TEST" is in use
2025-06-28 06:38:15.739 E (335544345, 335544351, 335544453)
2025-06-28 06:38:15.739 E SERIALIZABLE drop table test2
2025-06-28 06:38:15.739 E lock conflict on no wait transaction
2025-06-28 06:38:15.739 E -unsuccessful metadata update
2025-06-28 06:38:15.739 E - -object TABLE "TEST2" is in use
2025-06-28 06:38:15.740 E + -object TABLE "PUBLIC"."TEST2" is in use
2025-06-28 06:38:15.740 E (335544345, 335544351, 335544453)
2025-06-28 06:38:15.740 E SERIALIZABLE drop index test1_id
2025-06-28 06:38:15.740 E lock conflict on no wait transaction
2025-06-28 06:38:15.740 E -unsuccessful metadata update
2025-06-28 06:38:15.740 E - -object INDEX "TEST1_ID" is in use
2025-06-28 06:38:15.740 E + -object INDEX "PUBLIC"."TEST1_ID" is in use
2025-06-28 06:38:15.740 E (335544345, 335544351, 335544453)
2025-06-28 06:38:15.740 E SERIALIZABLE drop index test2_x
2025-06-28 06:38:15.740 E lock conflict on no wait transaction
2025-06-28 06:38:15.740 E -unsuccessful metadata update
2025-06-28 06:38:15.740 E - -object INDEX "TEST2_X" is in use
2025-06-28 06:38:15.740 E + -object INDEX "PUBLIC"."TEST2_X" is in use
2025-06-28 06:38:15.740 E (335544345, 335544351, 335544453)
2025-06-28 06:38:15.740 E READ_COMMITTED_READ_CONSISTENCY drop procedure sp_test
2025-06-28 06:38:15.740 E lock conflict on no wait transaction
2025-06-28 06:38:15.740 E -unsuccessful metadata update
2025-06-28 06:38:15.741 E - -object PROCEDURE "SP_TEST" is in use
2025-06-28 06:38:15.741 E + -object PROCEDURE "PUBLIC"."SP_TEST" is in use
2025-06-28 06:38:15.741 E (335544345, 335544351, 335544453)
2025-06-28 06:38:15.741 E READ_COMMITTED_READ_CONSISTENCY drop procedure sp_worker
2025-06-28 06:38:15.741 E lock conflict on no wait transaction
2025-06-28 06:38:15.741 E -unsuccessful metadata update
2025-06-28 06:38:15.741 E - -object PROCEDURE "SP_WORKER" is in use
2025-06-28 06:38:15.741 E + -object PROCEDURE "PUBLIC"."SP_WORKER" is in use
2025-06-28 06:38:15.741 E (335544345, 335544351, 335544453)
2025-06-28 06:38:15.741 E READ_COMMITTED_READ_CONSISTENCY drop function fn_worker
2025-06-28 06:38:15.741 E lock conflict on no wait transaction
2025-06-28 06:38:15.741 E -unsuccessful metadata update
2025-06-28 06:38:15.741 E - -object FUNCTION "FN_WORKER" is in use
2025-06-28 06:38:15.741 E + -object FUNCTION "PUBLIC"."FN_WORKER" is in use
2025-06-28 06:38:15.741 E (335544345, 335544351, 335544453)
2025-06-28 06:38:15.741 E READ_COMMITTED_READ_CONSISTENCY drop view v_test
2025-06-28 06:38:15.741 E lock conflict on no wait transaction
2025-06-28 06:38:15.741 E -unsuccessful metadata update
2025-06-28 06:38:15.742 E - -object VIEW "V_TEST" is in use
2025-06-28 06:38:15.742 E + -object VIEW "PUBLIC"."V_TEST" is in use
2025-06-28 06:38:15.742 E (335544345, 335544351, 335544453)
2025-06-28 06:38:15.742 E READ_COMMITTED_READ_CONSISTENCY drop table test2
2025-06-28 06:38:15.742 E lock conflict on no wait transaction
2025-06-28 06:38:15.742 E -unsuccessful metadata update
2025-06-28 06:38:15.742 E - -object TABLE "TEST2" is in use
2025-06-28 06:38:15.742 E + -object TABLE "PUBLIC"."TEST2" is in use
2025-06-28 06:38:15.742 E (335544345, 335544351, 335544453)
2025-06-28 06:38:15.742 E READ_COMMITTED_READ_CONSISTENCY drop index test1_id
2025-06-28 06:38:15.742 E lock conflict on no wait transaction
2025-06-28 06:38:15.742 E -unsuccessful metadata update
2025-06-28 06:38:15.742 E - -object INDEX "TEST1_ID" is in use
2025-06-28 06:38:15.742 E + -object INDEX "PUBLIC"."TEST1_ID" is in use
2025-06-28 06:38:15.742 E (335544345, 335544351, 335544453)
2025-06-28 06:38:15.742 E READ_COMMITTED_READ_CONSISTENCY drop index test2_x
2025-06-28 06:38:15.742 E lock conflict on no wait transaction
2025-06-28 06:38:15.743 E -unsuccessful metadata update
2025-06-28 06:38:15.743 E - -object INDEX "TEST2_X" is in use
2025-06-28 06:38:15.743 E + -object INDEX "PUBLIC"."TEST2_X" is in use
2025-06-28 06:38:15.743 E (335544345, 335544351, 335544453)
2025-06-28 06:38:15.743
2025-06-28 06:38:15.743 tests\bugs\core_4386_test.py:370: AssertionError
2025-06-28 06:38:15.743 ---------------------------- Captured stdout setup ----------------------------
2025-06-28 06:38:15.743 Creating db: localhost:H:\QA\temp\qa2024.tmp\fbqa\test_1839\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.version('>=4.0')
def test_1(act: Action, capsys):
act.isql(switches=[], input=ddl_script)
drop_commands = [ 'drop procedure sp_test',
'drop procedure sp_worker',
'drop function fn_worker',
'drop view v_test',
'drop table test2',
'drop index test1_id',
'drop index test2_x'
]
tx_isol_lst = [ Isolation.READ_COMMITTED_NO_RECORD_VERSION,
Isolation.READ_COMMITTED_RECORD_VERSION,
Isolation.SNAPSHOT,
Isolation.SERIALIZABLE,
]
if act.is_version('>=4'):
tx_isol_lst.append(Isolation.READ_COMMITTED_READ_CONSISTENCY)
# for any isolation mode attempt to drop object that is in use by another Tx must fail
# with the same error message. We check all possible Tx isolation modes for that:
for x_isol in tx_isol_lst:
with act.db.connect() as con1:
cur1 = con1.cursor()
cur1.execute('select x from sp_test(21)').fetchall()
for cmd in drop_commands:
with act.db.connect() as con2:
custom_tpb = tpb(isolation = x_isol, lock_timeout=0)
print(x_isol.name, cmd)
tx2 = con2.transaction_manager(custom_tpb)
tx2.begin()
cur2 = tx2.cursor()
try:
cur2.execute(cmd) # this will PASS because of DDL nature
##########################################################################
### We have to call commit() exactly by TRANSACTION object here. ###
### DO NOT use con2.commit() because this actually leads transaction ###
### to be 'silently rolled back', thus we will not get error messages! ###
##########################################################################
tx2.commit() # <<< this lead to FAILED_COMMIT in the trace <<<
except Exception as e:
print(e.__str__())
print(e.gds_codes)
act.expected_stdout = f"""
READ_COMMITTED_NO_RECORD_VERSION drop procedure sp_test
lock conflict on no wait transaction
-unsuccessful metadata update
-object PROCEDURE "SP_TEST" is in use
(335544345, 335544351, 335544453)
READ_COMMITTED_NO_RECORD_VERSION drop procedure sp_worker
lock conflict on no wait transaction
-unsuccessful metadata update
-object PROCEDURE "SP_WORKER" is in use
(335544345, 335544351, 335544453)
READ_COMMITTED_NO_RECORD_VERSION drop function fn_worker
lock conflict on no wait transaction
-unsuccessful metadata update
-object FUNCTION "FN_WORKER" is in use
(335544345, 335544351, 335544453)
READ_COMMITTED_NO_RECORD_VERSION drop view v_test
lock conflict on no wait transaction
-unsuccessful metadata update
-object VIEW "V_TEST" is in use
(335544345, 335544351, 335544453)
READ_COMMITTED_NO_RECORD_VERSION drop table test2
lock conflict on no wait transaction
-unsuccessful metadata update
-object TABLE "TEST2" is in use
(335544345, 335544351, 335544453)
READ_COMMITTED_NO_RECORD_VERSION drop index test1_id
lock conflict on no wait transaction
-unsuccessful metadata update
-object INDEX "TEST1_ID" is in use
(335544345, 335544351, 335544453)
READ_COMMITTED_NO_RECORD_VERSION drop index test2_x
lock conflict on no wait transaction
-unsuccessful metadata update
-object INDEX "TEST2_X" is in use
(335544345, 335544351, 335544453)
READ_COMMITTED_RECORD_VERSION drop procedure sp_test
lock conflict on no wait transaction
-unsuccessful metadata update
-object PROCEDURE "SP_TEST" is in use
(335544345, 335544351, 335544453)
READ_COMMITTED_RECORD_VERSION drop procedure sp_worker
lock conflict on no wait transaction
-unsuccessful metadata update
-object PROCEDURE "SP_WORKER" is in use
(335544345, 335544351, 335544453)
READ_COMMITTED_RECORD_VERSION drop function fn_worker
lock conflict on no wait transaction
-unsuccessful metadata update
-object FUNCTION "FN_WORKER" is in use
(335544345, 335544351, 335544453)
READ_COMMITTED_RECORD_VERSION drop view v_test
lock conflict on no wait transaction
-unsuccessful metadata update
-object VIEW "V_TEST" is in use
(335544345, 335544351, 335544453)
READ_COMMITTED_RECORD_VERSION drop table test2
lock conflict on no wait transaction
-unsuccessful metadata update
-object TABLE "TEST2" is in use
(335544345, 335544351, 335544453)
READ_COMMITTED_RECORD_VERSION drop index test1_id
lock conflict on no wait transaction
-unsuccessful metadata update
-object INDEX "TEST1_ID" is in use
(335544345, 335544351, 335544453)
READ_COMMITTED_RECORD_VERSION drop index test2_x
lock conflict on no wait transaction
-unsuccessful metadata update
-object INDEX "TEST2_X" is in use
(335544345, 335544351, 335544453)
SNAPSHOT drop procedure sp_test
lock conflict on no wait transaction
-unsuccessful metadata update
-object PROCEDURE "SP_TEST" is in use
(335544345, 335544351, 335544453)
SNAPSHOT drop procedure sp_worker
lock conflict on no wait transaction
-unsuccessful metadata update
-object PROCEDURE "SP_WORKER" is in use
(335544345, 335544351, 335544453)
SNAPSHOT drop function fn_worker
lock conflict on no wait transaction
-unsuccessful metadata update
-object FUNCTION "FN_WORKER" is in use
(335544345, 335544351, 335544453)
SNAPSHOT drop view v_test
lock conflict on no wait transaction
-unsuccessful metadata update
-object VIEW "V_TEST" is in use
(335544345, 335544351, 335544453)
SNAPSHOT drop table test2
lock conflict on no wait transaction
-unsuccessful metadata update
-object TABLE "TEST2" is in use
(335544345, 335544351, 335544453)
SNAPSHOT drop index test1_id
lock conflict on no wait transaction
-unsuccessful metadata update
-object INDEX "TEST1_ID" is in use
(335544345, 335544351, 335544453)
SNAPSHOT drop index test2_x
lock conflict on no wait transaction
-unsuccessful metadata update
-object INDEX "TEST2_X" is in use
(335544345, 335544351, 335544453)
SERIALIZABLE drop procedure sp_test
lock conflict on no wait transaction
-unsuccessful metadata update
-object PROCEDURE "SP_TEST" is in use
(335544345, 335544351, 335544453)
SERIALIZABLE drop procedure sp_worker
lock conflict on no wait transaction
-unsuccessful metadata update
-object PROCEDURE "SP_WORKER" is in use
(335544345, 335544351, 335544453)
SERIALIZABLE drop function fn_worker
lock conflict on no wait transaction
-unsuccessful metadata update
-object FUNCTION "FN_WORKER" is in use
(335544345, 335544351, 335544453)
SERIALIZABLE drop view v_test
lock conflict on no wait transaction
-unsuccessful metadata update
-object VIEW "V_TEST" is in use
(335544345, 335544351, 335544453)
SERIALIZABLE drop table test2
lock conflict on no wait transaction
-unsuccessful metadata update
-object TABLE "TEST2" is in use
(335544345, 335544351, 335544453)
SERIALIZABLE drop index test1_id
lock conflict on no wait transaction
-unsuccessful metadata update
-object INDEX "TEST1_ID" is in use
(335544345, 335544351, 335544453)
SERIALIZABLE drop index test2_x
lock conflict on no wait transaction
-unsuccessful metadata update
-object INDEX "TEST2_X" is in use
(335544345, 335544351, 335544453)
READ_COMMITTED_READ_CONSISTENCY drop procedure sp_test
lock conflict on no wait transaction
-unsuccessful metadata update
-object PROCEDURE "SP_TEST" is in use
(335544345, 335544351, 335544453)
READ_COMMITTED_READ_CONSISTENCY drop procedure sp_worker
lock conflict on no wait transaction
-unsuccessful metadata update
-object PROCEDURE "SP_WORKER" is in use
(335544345, 335544351, 335544453)
READ_COMMITTED_READ_CONSISTENCY drop function fn_worker
lock conflict on no wait transaction
-unsuccessful metadata update
-object FUNCTION "FN_WORKER" is in use
(335544345, 335544351, 335544453)
READ_COMMITTED_READ_CONSISTENCY drop view v_test
lock conflict on no wait transaction
-unsuccessful metadata update
-object VIEW "V_TEST" is in use
(335544345, 335544351, 335544453)
READ_COMMITTED_READ_CONSISTENCY drop table test2
lock conflict on no wait transaction
-unsuccessful metadata update
-object TABLE "TEST2" is in use
(335544345, 335544351, 335544453)
READ_COMMITTED_READ_CONSISTENCY drop index test1_id
lock conflict on no wait transaction
-unsuccessful metadata update
-object INDEX "TEST1_ID" is in use
(335544345, 335544351, 335544453)
READ_COMMITTED_READ_CONSISTENCY drop index test2_x
lock conflict on no wait transaction
-unsuccessful metadata update
-object INDEX "TEST2_X" is in use
(335544345, 335544351, 335544453)
"""
act.stdout = capsys.readouterr().out
> assert act.clean_stdout == act.clean_expected_stdout
E assert
E READ_COMMITTED_NO_RECORD_VERSION drop procedure sp_test
E lock conflict on no wait transaction
E -unsuccessful metadata update
E - -object PROCEDURE "SP_TEST" is in use
E + -object PROCEDURE "PUBLIC"."SP_TEST" is in use
E (335544345, 335544351, 335544453)
E READ_COMMITTED_NO_RECORD_VERSION drop procedure sp_worker
E lock conflict on no wait transaction
E -unsuccessful metadata update
E - -object PROCEDURE "SP_WORKER" is in use
E + -object PROCEDURE "PUBLIC"."SP_WORKER" is in use
E (335544345, 335544351, 335544453)
E READ_COMMITTED_NO_RECORD_VERSION drop function fn_worker
E lock conflict on no wait transaction
E -unsuccessful metadata update
E - -object FUNCTION "FN_WORKER" is in use
E + -object FUNCTION "PUBLIC"."FN_WORKER" is in use
E (335544345, 335544351, 335544453)
E READ_COMMITTED_NO_RECORD_VERSION drop view v_test
E lock conflict on no wait transaction
E -unsuccessful metadata update
E - -object VIEW "V_TEST" is in use
E + -object VIEW "PUBLIC"."V_TEST" is in use
E (335544345, 335544351, 335544453)
E READ_COMMITTED_NO_RECORD_VERSION drop table test2
E lock conflict on no wait transaction
E -unsuccessful metadata update
E - -object TABLE "TEST2" is in use
E + -object TABLE "PUBLIC"."TEST2" is in use
E (335544345, 335544351, 335544453)
E READ_COMMITTED_NO_RECORD_VERSION drop index test1_id
E lock conflict on no wait transaction
E -unsuccessful metadata update
E - -object INDEX "TEST1_ID" is in use
E + -object INDEX "PUBLIC"."TEST1_ID" is in use
E (335544345, 335544351, 335544453)
E READ_COMMITTED_NO_RECORD_VERSION drop index test2_x
E lock conflict on no wait transaction
E -unsuccessful metadata update
E - -object INDEX "TEST2_X" is in use
E + -object INDEX "PUBLIC"."TEST2_X" is in use
E (335544345, 335544351, 335544453)
E READ_COMMITTED_RECORD_VERSION drop procedure sp_test
E lock conflict on no wait transaction
E -unsuccessful metadata update
E - -object PROCEDURE "SP_TEST" is in use
E + -object PROCEDURE "PUBLIC"."SP_TEST" is in use
E (335544345, 335544351, 335544453)
E READ_COMMITTED_RECORD_VERSION drop procedure sp_worker
E lock conflict on no wait transaction
E -unsuccessful metadata update
E - -object PROCEDURE "SP_WORKER" is in use
E + -object PROCEDURE "PUBLIC"."SP_WORKER" is in use
E (335544345, 335544351, 335544453)
E READ_COMMITTED_RECORD_VERSION drop function fn_worker
E lock conflict on no wait transaction
E -unsuccessful metadata update
E - -object FUNCTION "FN_WORKER" is in use
E + -object FUNCTION "PUBLIC"."FN_WORKER" is in use
E (335544345, 335544351, 335544453)
E READ_COMMITTED_RECORD_VERSION drop view v_test
E lock conflict on no wait transaction
E -unsuccessful metadata update
E - -object VIEW "V_TEST" is in use
E + -object VIEW "PUBLIC"."V_TEST" is in use
E (335544345, 335544351, 335544453)
E READ_COMMITTED_RECORD_VERSION drop table test2
E lock conflict on no wait transaction
E -unsuccessful metadata update
E - -object TABLE "TEST2" is in use
E + -object TABLE "PUBLIC"."TEST2" is in use
E (335544345, 335544351, 335544453)
E READ_COMMITTED_RECORD_VERSION drop index test1_id
E lock conflict on no wait transaction
E -unsuccessful metadata update
E - -object INDEX "TEST1_ID" is in use
E + -object INDEX "PUBLIC"."TEST1_ID" is in use
E (335544345, 335544351, 335544453)
E READ_COMMITTED_RECORD_VERSION drop index test2_x
E lock conflict on no wait transaction
E -unsuccessful metadata update
E - -object INDEX "TEST2_X" is in use
E + -object INDEX "PUBLIC"."TEST2_X" is in use
E (335544345, 335544351, 335544453)
E SNAPSHOT drop procedure sp_test
E lock conflict on no wait transaction
E -unsuccessful metadata update
E - -object PROCEDURE "SP_TEST" is in use
E + -object PROCEDURE "PUBLIC"."SP_TEST" is in use
E (335544345, 335544351, 335544453)
E SNAPSHOT drop procedure sp_worker
E lock conflict on no wait transaction
E -unsuccessful metadata update
E - -object PROCEDURE "SP_WORKER" is in use
E + -object PROCEDURE "PUBLIC"."SP_WORKER" is in use
E (335544345, 335544351, 335544453)
E SNAPSHOT drop function fn_worker
E lock conflict on no wait transaction
E -unsuccessful metadata update
E - -object FUNCTION "FN_WORKER" is in use
E + -object FUNCTION "PUBLIC"."FN_WORKER" is in use
E (335544345, 335544351, 335544453)
E SNAPSHOT drop view v_test
E lock conflict on no wait transaction
E -unsuccessful metadata update
E - -object VIEW "V_TEST" is in use
E + -object VIEW "PUBLIC"."V_TEST" is in use
E (335544345, 335544351, 335544453)
E SNAPSHOT drop table test2
E lock conflict on no wait transaction
E -unsuccessful metadata update
E - -object TABLE "TEST2" is in use
E + -object TABLE "PUBLIC"."TEST2" is in use
E (335544345, 335544351, 335544453)
E SNAPSHOT drop index test1_id
E lock conflict on no wait transaction
E -unsuccessful metadata update
E - -object INDEX "TEST1_ID" is in use
E + -object INDEX "PUBLIC"."TEST1_ID" is in use
E (335544345, 335544351, 335544453)
E SNAPSHOT drop index test2_x
E lock conflict on no wait transaction
E -unsuccessful metadata update
E - -object INDEX "TEST2_X" is in use
E + -object INDEX "PUBLIC"."TEST2_X" is in use
E (335544345, 335544351, 335544453)
E SERIALIZABLE drop procedure sp_test
E lock conflict on no wait transaction
E -unsuccessful metadata update
E - -object PROCEDURE "SP_TEST" is in use
E + -object PROCEDURE "PUBLIC"."SP_TEST" is in use
E (335544345, 335544351, 335544453)
E SERIALIZABLE drop procedure sp_worker
E lock conflict on no wait transaction
E -unsuccessful metadata update
E - -object PROCEDURE "SP_WORKER" is in use
E + -object PROCEDURE "PUBLIC"."SP_WORKER" is in use
E (335544345, 335544351, 335544453)
E SERIALIZABLE drop function fn_worker
E lock conflict on no wait transaction
E -unsuccessful metadata update
E - -object FUNCTION "FN_WORKER" is in use
E + -object FUNCTION "PUBLIC"."FN_WORKER" is in use
E (335544345, 335544351, 335544453)
E SERIALIZABLE drop view v_test
E lock conflict on no wait transaction
E -unsuccessful metadata update
E - -object VIEW "V_TEST" is in use
E + -object VIEW "PUBLIC"."V_TEST" is in use
E (335544345, 335544351, 335544453)
E SERIALIZABLE drop table test2
E lock conflict on no wait transaction
E -unsuccessful metadata update
E - -object TABLE "TEST2" is in use
E + -object TABLE "PUBLIC"."TEST2" is in use
E (335544345, 335544351, 335544453)
E SERIALIZABLE drop index test1_id
E lock conflict on no wait transaction
E -unsuccessful metadata update
E - -object INDEX "TEST1_ID" is in use
E + -object INDEX "PUBLIC"."TEST1_ID" is in use
E (335544345, 335544351, 335544453)
E SERIALIZABLE drop index test2_x
E lock conflict on no wait transaction
E -unsuccessful metadata update
E - -object INDEX "TEST2_X" is in use
E + -object INDEX "PUBLIC"."TEST2_X" is in use
E (335544345, 335544351, 335544453)
E READ_COMMITTED_READ_CONSISTENCY drop procedure sp_test
E lock conflict on no wait transaction
E -unsuccessful metadata update
E - -object PROCEDURE "SP_TEST" is in use
E + -object PROCEDURE "PUBLIC"."SP_TEST" is in use
E (335544345, 335544351, 335544453)
E READ_COMMITTED_READ_CONSISTENCY drop procedure sp_worker
E lock conflict on no wait transaction
E -unsuccessful metadata update
E - -object PROCEDURE "SP_WORKER" is in use
E + -object PROCEDURE "PUBLIC"."SP_WORKER" is in use
E (335544345, 335544351, 335544453)
E READ_COMMITTED_READ_CONSISTENCY drop function fn_worker
E lock conflict on no wait transaction
E -unsuccessful metadata update
E - -object FUNCTION "FN_WORKER" is in use
E + -object FUNCTION "PUBLIC"."FN_WORKER" is in use
E (335544345, 335544351, 335544453)
E READ_COMMITTED_READ_CONSISTENCY drop view v_test
E lock conflict on no wait transaction
E -unsuccessful metadata update
E - -object VIEW "V_TEST" is in use
E + -object VIEW "PUBLIC"."V_TEST" is in use
E (335544345, 335544351, 335544453)
E READ_COMMITTED_READ_CONSISTENCY drop table test2
E lock conflict on no wait transaction
E -unsuccessful metadata update
E - -object TABLE "TEST2" is in use
E + -object TABLE "PUBLIC"."TEST2" is in use
E (335544345, 335544351, 335544453)
E READ_COMMITTED_READ_CONSISTENCY drop index test1_id
E lock conflict on no wait transaction
E -unsuccessful metadata update
E - -object INDEX "TEST1_ID" is in use
E + -object INDEX "PUBLIC"."TEST1_ID" is in use
E (335544345, 335544351, 335544453)
E READ_COMMITTED_READ_CONSISTENCY drop index test2_x
E lock conflict on no wait transaction
E -unsuccessful metadata update
E - -object INDEX "TEST2_X" is in use
E + -object INDEX "PUBLIC"."TEST2_X" is in use
E (335544345, 335544351, 335544453)
tests\bugs\core_4386_test.py:370: AssertionError
|