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-29 06:35:42.043
2025-06-29 06:35:42.043 act = <firebird.qa.plugin.Action object at [hex]>
2025-06-29 06:35:42.043 capsys = <_pytest.capture.CaptureFixture object at [hex]>
2025-06-29 06:35:42.043
2025-06-29 06:35:42.043 @pytest.mark.version('>=4.0')
2025-06-29 06:35:42.043 def test_1(act: Action, capsys):
2025-06-29 06:35:42.043 act.isql(switches=[], input=ddl_script)
2025-06-29 06:35:42.043
2025-06-29 06:35:42.043 drop_commands = [ 'drop procedure sp_test',
2025-06-29 06:35:42.043 'drop procedure sp_worker',
2025-06-29 06:35:42.043 'drop function fn_worker',
2025-06-29 06:35:42.043 'drop view v_test',
2025-06-29 06:35:42.043 'drop table test2',
2025-06-29 06:35:42.043 'drop index test1_id',
2025-06-29 06:35:42.043 'drop index test2_x'
2025-06-29 06:35:42.043 ]
2025-06-29 06:35:42.043
2025-06-29 06:35:42.044 tx_isol_lst = [ Isolation.READ_COMMITTED_NO_RECORD_VERSION,
2025-06-29 06:35:42.044 Isolation.READ_COMMITTED_RECORD_VERSION,
2025-06-29 06:35:42.044 Isolation.SNAPSHOT,
2025-06-29 06:35:42.044 Isolation.SERIALIZABLE,
2025-06-29 06:35:42.044 ]
2025-06-29 06:35:42.044 if act.is_version('>=4'):
2025-06-29 06:35:42.044 tx_isol_lst.append(Isolation.READ_COMMITTED_READ_CONSISTENCY)
2025-06-29 06:35:42.044
2025-06-29 06:35:42.044 # for any isolation mode attempt to drop object that is in use by another Tx must fail
2025-06-29 06:35:42.044 # with the same error message. We check all possible Tx isolation modes for that:
2025-06-29 06:35:42.044 for x_isol in tx_isol_lst:
2025-06-29 06:35:42.044
2025-06-29 06:35:42.044 with act.db.connect() as con1:
2025-06-29 06:35:42.044
2025-06-29 06:35:42.044 cur1 = con1.cursor()
2025-06-29 06:35:42.044 cur1.execute('select x from sp_test(21)').fetchall()
2025-06-29 06:35:42.044
2025-06-29 06:35:42.044 for cmd in drop_commands:
2025-06-29 06:35:42.044 with act.db.connect() as con2:
2025-06-29 06:35:42.044 custom_tpb = tpb(isolation = x_isol, lock_timeout=0)
2025-06-29 06:35:42.044 print(x_isol.name, cmd)
2025-06-29 06:35:42.045 tx2 = con2.transaction_manager(custom_tpb)
2025-06-29 06:35:42.045 tx2.begin()
2025-06-29 06:35:42.045 cur2 = tx2.cursor()
2025-06-29 06:35:42.045 try:
2025-06-29 06:35:42.045 cur2.execute(cmd) # this will PASS because of DDL nature
2025-06-29 06:35:42.045
2025-06-29 06:35:42.045 ##########################################################################
2025-06-29 06:35:42.045 ### We have to call commit() exactly by TRANSACTION object here. ###
2025-06-29 06:35:42.045 ### DO NOT use con2.commit() because this actually leads transaction ###
2025-06-29 06:35:42.045 ### to be 'silently rolled back', thus we will not get error messages! ###
2025-06-29 06:35:42.045 ##########################################################################
2025-06-29 06:35:42.045 tx2.commit() # <<< this lead to FAILED_COMMIT in the trace <<<
2025-06-29 06:35:42.045
2025-06-29 06:35:42.045 except Exception as e:
2025-06-29 06:35:42.045 print(e.__str__())
2025-06-29 06:35:42.045 print(e.gds_codes)
2025-06-29 06:35:42.045
2025-06-29 06:35:42.045 act.expected_stdout = f"""
2025-06-29 06:35:42.045 READ_COMMITTED_NO_RECORD_VERSION drop procedure sp_test
2025-06-29 06:35:42.046 lock conflict on no wait transaction
2025-06-29 06:35:42.046 -unsuccessful metadata update
2025-06-29 06:35:42.046 -object PROCEDURE "SP_TEST" is in use
2025-06-29 06:35:42.046 (335544345, 335544351, 335544453)
2025-06-29 06:35:42.046
2025-06-29 06:35:42.046 READ_COMMITTED_NO_RECORD_VERSION drop procedure sp_worker
2025-06-29 06:35:42.046 lock conflict on no wait transaction
2025-06-29 06:35:42.046 -unsuccessful metadata update
2025-06-29 06:35:42.046 -object PROCEDURE "SP_WORKER" is in use
2025-06-29 06:35:42.046 (335544345, 335544351, 335544453)
2025-06-29 06:35:42.046
2025-06-29 06:35:42.046 READ_COMMITTED_NO_RECORD_VERSION drop function fn_worker
2025-06-29 06:35:42.046 lock conflict on no wait transaction
2025-06-29 06:35:42.046 -unsuccessful metadata update
2025-06-29 06:35:42.046 -object FUNCTION "FN_WORKER" is in use
2025-06-29 06:35:42.046 (335544345, 335544351, 335544453)
2025-06-29 06:35:42.046
2025-06-29 06:35:42.046 READ_COMMITTED_NO_RECORD_VERSION drop view v_test
2025-06-29 06:35:42.046 lock conflict on no wait transaction
2025-06-29 06:35:42.046 -unsuccessful metadata update
2025-06-29 06:35:42.046 -object VIEW "V_TEST" is in use
2025-06-29 06:35:42.047 (335544345, 335544351, 335544453)
2025-06-29 06:35:42.047
2025-06-29 06:35:42.047 READ_COMMITTED_NO_RECORD_VERSION drop table test2
2025-06-29 06:35:42.047 lock conflict on no wait transaction
2025-06-29 06:35:42.047 -unsuccessful metadata update
2025-06-29 06:35:42.047 -object TABLE "TEST2" is in use
2025-06-29 06:35:42.047 (335544345, 335544351, 335544453)
2025-06-29 06:35:42.047
2025-06-29 06:35:42.047 READ_COMMITTED_NO_RECORD_VERSION drop index test1_id
2025-06-29 06:35:42.047 lock conflict on no wait transaction
2025-06-29 06:35:42.047 -unsuccessful metadata update
2025-06-29 06:35:42.047 -object INDEX "TEST1_ID" is in use
2025-06-29 06:35:42.047 (335544345, 335544351, 335544453)
2025-06-29 06:35:42.047
2025-06-29 06:35:42.047 READ_COMMITTED_NO_RECORD_VERSION drop index test2_x
2025-06-29 06:35:42.047 lock conflict on no wait transaction
2025-06-29 06:35:42.047 -unsuccessful metadata update
2025-06-29 06:35:42.047 -object INDEX "TEST2_X" is in use
2025-06-29 06:35:42.047 (335544345, 335544351, 335544453)
2025-06-29 06:35:42.047
2025-06-29 06:35:42.047 READ_COMMITTED_RECORD_VERSION drop procedure sp_test
2025-06-29 06:35:42.048 lock conflict on no wait transaction
2025-06-29 06:35:42.048 -unsuccessful metadata update
2025-06-29 06:35:42.048 -object PROCEDURE "SP_TEST" is in use
2025-06-29 06:35:42.048 (335544345, 335544351, 335544453)
2025-06-29 06:35:42.048
2025-06-29 06:35:42.048 READ_COMMITTED_RECORD_VERSION drop procedure sp_worker
2025-06-29 06:35:42.048 lock conflict on no wait transaction
2025-06-29 06:35:42.048 -unsuccessful metadata update
2025-06-29 06:35:42.048 -object PROCEDURE "SP_WORKER" is in use
2025-06-29 06:35:42.048 (335544345, 335544351, 335544453)
2025-06-29 06:35:42.048
2025-06-29 06:35:42.048 READ_COMMITTED_RECORD_VERSION drop function fn_worker
2025-06-29 06:35:42.048 lock conflict on no wait transaction
2025-06-29 06:35:42.048 -unsuccessful metadata update
2025-06-29 06:35:42.048 -object FUNCTION "FN_WORKER" is in use
2025-06-29 06:35:42.048 (335544345, 335544351, 335544453)
2025-06-29 06:35:42.048
2025-06-29 06:35:42.048 READ_COMMITTED_RECORD_VERSION drop view v_test
2025-06-29 06:35:42.048 lock conflict on no wait transaction
2025-06-29 06:35:42.048 -unsuccessful metadata update
2025-06-29 06:35:42.049 -object VIEW "V_TEST" is in use
2025-06-29 06:35:42.049 (335544345, 335544351, 335544453)
2025-06-29 06:35:42.049
2025-06-29 06:35:42.049 READ_COMMITTED_RECORD_VERSION drop table test2
2025-06-29 06:35:42.049 lock conflict on no wait transaction
2025-06-29 06:35:42.049 -unsuccessful metadata update
2025-06-29 06:35:42.049 -object TABLE "TEST2" is in use
2025-06-29 06:35:42.049 (335544345, 335544351, 335544453)
2025-06-29 06:35:42.049
2025-06-29 06:35:42.049 READ_COMMITTED_RECORD_VERSION drop index test1_id
2025-06-29 06:35:42.049 lock conflict on no wait transaction
2025-06-29 06:35:42.049 -unsuccessful metadata update
2025-06-29 06:35:42.049 -object INDEX "TEST1_ID" is in use
2025-06-29 06:35:42.049 (335544345, 335544351, 335544453)
2025-06-29 06:35:42.049
2025-06-29 06:35:42.049 READ_COMMITTED_RECORD_VERSION drop index test2_x
2025-06-29 06:35:42.049 lock conflict on no wait transaction
2025-06-29 06:35:42.049 -unsuccessful metadata update
2025-06-29 06:35:42.049 -object INDEX "TEST2_X" is in use
2025-06-29 06:35:42.049 (335544345, 335544351, 335544453)
2025-06-29 06:35:42.049
2025-06-29 06:35:42.050 SNAPSHOT drop procedure sp_test
2025-06-29 06:35:42.050 lock conflict on no wait transaction
2025-06-29 06:35:42.050 -unsuccessful metadata update
2025-06-29 06:35:42.050 -object PROCEDURE "SP_TEST" is in use
2025-06-29 06:35:42.050 (335544345, 335544351, 335544453)
2025-06-29 06:35:42.050
2025-06-29 06:35:42.050 SNAPSHOT drop procedure sp_worker
2025-06-29 06:35:42.050 lock conflict on no wait transaction
2025-06-29 06:35:42.050 -unsuccessful metadata update
2025-06-29 06:35:42.050 -object PROCEDURE "SP_WORKER" is in use
2025-06-29 06:35:42.050 (335544345, 335544351, 335544453)
2025-06-29 06:35:42.050
2025-06-29 06:35:42.050 SNAPSHOT drop function fn_worker
2025-06-29 06:35:42.050 lock conflict on no wait transaction
2025-06-29 06:35:42.050 -unsuccessful metadata update
2025-06-29 06:35:42.050 -object FUNCTION "FN_WORKER" is in use
2025-06-29 06:35:42.050 (335544345, 335544351, 335544453)
2025-06-29 06:35:42.050
2025-06-29 06:35:42.050 SNAPSHOT drop view v_test
2025-06-29 06:35:42.050 lock conflict on no wait transaction
2025-06-29 06:35:42.050 -unsuccessful metadata update
2025-06-29 06:35:42.051 -object VIEW "V_TEST" is in use
2025-06-29 06:35:42.051 (335544345, 335544351, 335544453)
2025-06-29 06:35:42.051
2025-06-29 06:35:42.051 SNAPSHOT drop table test2
2025-06-29 06:35:42.051 lock conflict on no wait transaction
2025-06-29 06:35:42.051 -unsuccessful metadata update
2025-06-29 06:35:42.051 -object TABLE "TEST2" is in use
2025-06-29 06:35:42.051 (335544345, 335544351, 335544453)
2025-06-29 06:35:42.051
2025-06-29 06:35:42.051 SNAPSHOT drop index test1_id
2025-06-29 06:35:42.051 lock conflict on no wait transaction
2025-06-29 06:35:42.051 -unsuccessful metadata update
2025-06-29 06:35:42.051 -object INDEX "TEST1_ID" is in use
2025-06-29 06:35:42.051 (335544345, 335544351, 335544453)
2025-06-29 06:35:42.051
2025-06-29 06:35:42.051 SNAPSHOT drop index test2_x
2025-06-29 06:35:42.051 lock conflict on no wait transaction
2025-06-29 06:35:42.051 -unsuccessful metadata update
2025-06-29 06:35:42.051 -object INDEX "TEST2_X" is in use
2025-06-29 06:35:42.051 (335544345, 335544351, 335544453)
2025-06-29 06:35:42.052
2025-06-29 06:35:42.052 SERIALIZABLE drop procedure sp_test
2025-06-29 06:35:42.052 lock conflict on no wait transaction
2025-06-29 06:35:42.052 -unsuccessful metadata update
2025-06-29 06:35:42.052 -object PROCEDURE "SP_TEST" is in use
2025-06-29 06:35:42.052 (335544345, 335544351, 335544453)
2025-06-29 06:35:42.052
2025-06-29 06:35:42.052 SERIALIZABLE drop procedure sp_worker
2025-06-29 06:35:42.052 lock conflict on no wait transaction
2025-06-29 06:35:42.052 -unsuccessful metadata update
2025-06-29 06:35:42.052 -object PROCEDURE "SP_WORKER" is in use
2025-06-29 06:35:42.052 (335544345, 335544351, 335544453)
2025-06-29 06:35:42.052
2025-06-29 06:35:42.052 SERIALIZABLE drop function fn_worker
2025-06-29 06:35:42.052 lock conflict on no wait transaction
2025-06-29 06:35:42.052 -unsuccessful metadata update
2025-06-29 06:35:42.052 -object FUNCTION "FN_WORKER" is in use
2025-06-29 06:35:42.052 (335544345, 335544351, 335544453)
2025-06-29 06:35:42.052
2025-06-29 06:35:42.053 SERIALIZABLE drop view v_test
2025-06-29 06:35:42.053 lock conflict on no wait transaction
2025-06-29 06:35:42.053 -unsuccessful metadata update
2025-06-29 06:35:42.053 -object VIEW "V_TEST" is in use
2025-06-29 06:35:42.053 (335544345, 335544351, 335544453)
2025-06-29 06:35:42.053
2025-06-29 06:35:42.053 SERIALIZABLE drop table test2
2025-06-29 06:35:42.053 lock conflict on no wait transaction
2025-06-29 06:35:42.053 -unsuccessful metadata update
2025-06-29 06:35:42.053 -object TABLE "TEST2" is in use
2025-06-29 06:35:42.053 (335544345, 335544351, 335544453)
2025-06-29 06:35:42.053
2025-06-29 06:35:42.053 SERIALIZABLE drop index test1_id
2025-06-29 06:35:42.053 lock conflict on no wait transaction
2025-06-29 06:35:42.053 -unsuccessful metadata update
2025-06-29 06:35:42.053 -object INDEX "TEST1_ID" is in use
2025-06-29 06:35:42.053 (335544345, 335544351, 335544453)
2025-06-29 06:35:42.053
2025-06-29 06:35:42.053 SERIALIZABLE drop index test2_x
2025-06-29 06:35:42.053 lock conflict on no wait transaction
2025-06-29 06:35:42.054 -unsuccessful metadata update
2025-06-29 06:35:42.054 -object INDEX "TEST2_X" is in use
2025-06-29 06:35:42.054 (335544345, 335544351, 335544453)
2025-06-29 06:35:42.054
2025-06-29 06:35:42.054 READ_COMMITTED_READ_CONSISTENCY drop procedure sp_test
2025-06-29 06:35:42.054 lock conflict on no wait transaction
2025-06-29 06:35:42.054 -unsuccessful metadata update
2025-06-29 06:35:42.054 -object PROCEDURE "SP_TEST" is in use
2025-06-29 06:35:42.054 (335544345, 335544351, 335544453)
2025-06-29 06:35:42.054
2025-06-29 06:35:42.054 READ_COMMITTED_READ_CONSISTENCY drop procedure sp_worker
2025-06-29 06:35:42.054 lock conflict on no wait transaction
2025-06-29 06:35:42.054 -unsuccessful metadata update
2025-06-29 06:35:42.054 -object PROCEDURE "SP_WORKER" is in use
2025-06-29 06:35:42.054 (335544345, 335544351, 335544453)
2025-06-29 06:35:42.054
2025-06-29 06:35:42.054 READ_COMMITTED_READ_CONSISTENCY drop function fn_worker
2025-06-29 06:35:42.054 lock conflict on no wait transaction
2025-06-29 06:35:42.054 -unsuccessful metadata update
2025-06-29 06:35:42.054 -object FUNCTION "FN_WORKER" is in use
2025-06-29 06:35:42.054 (335544345, 335544351, 335544453)
2025-06-29 06:35:42.055
2025-06-29 06:35:42.055 READ_COMMITTED_READ_CONSISTENCY drop view v_test
2025-06-29 06:35:42.055 lock conflict on no wait transaction
2025-06-29 06:35:42.055 -unsuccessful metadata update
2025-06-29 06:35:42.055 -object VIEW "V_TEST" is in use
2025-06-29 06:35:42.055 (335544345, 335544351, 335544453)
2025-06-29 06:35:42.055
2025-06-29 06:35:42.055 READ_COMMITTED_READ_CONSISTENCY drop table test2
2025-06-29 06:35:42.055 lock conflict on no wait transaction
2025-06-29 06:35:42.055 -unsuccessful metadata update
2025-06-29 06:35:42.055 -object TABLE "TEST2" is in use
2025-06-29 06:35:42.055 (335544345, 335544351, 335544453)
2025-06-29 06:35:42.055
2025-06-29 06:35:42.055 READ_COMMITTED_READ_CONSISTENCY drop index test1_id
2025-06-29 06:35:42.055 lock conflict on no wait transaction
2025-06-29 06:35:42.055 -unsuccessful metadata update
2025-06-29 06:35:42.055 -object INDEX "TEST1_ID" is in use
2025-06-29 06:35:42.055 (335544345, 335544351, 335544453)
2025-06-29 06:35:42.055
2025-06-29 06:35:42.055 READ_COMMITTED_READ_CONSISTENCY drop index test2_x
2025-06-29 06:35:42.056 lock conflict on no wait transaction
2025-06-29 06:35:42.056 -unsuccessful metadata update
2025-06-29 06:35:42.056 -object INDEX "TEST2_X" is in use
2025-06-29 06:35:42.056 (335544345, 335544351, 335544453)
2025-06-29 06:35:42.056 """
2025-06-29 06:35:42.056
2025-06-29 06:35:42.056 act.stdout = capsys.readouterr().out
2025-06-29 06:35:42.056 > assert act.clean_stdout == act.clean_expected_stdout
2025-06-29 06:35:42.056 E assert
2025-06-29 06:35:42.056 E READ_COMMITTED_NO_RECORD_VERSION drop procedure sp_test
2025-06-29 06:35:42.056 E lock conflict on no wait transaction
2025-06-29 06:35:42.056 E -unsuccessful metadata update
2025-06-29 06:35:42.056 E - -object PROCEDURE "SP_TEST" is in use
2025-06-29 06:35:42.056 E + -object PROCEDURE "PUBLIC"."SP_TEST" is in use
2025-06-29 06:35:42.056 E (335544345, 335544351, 335544453)
2025-06-29 06:35:42.056 E READ_COMMITTED_NO_RECORD_VERSION drop procedure sp_worker
2025-06-29 06:35:42.056 E lock conflict on no wait transaction
2025-06-29 06:35:42.056 E -unsuccessful metadata update
2025-06-29 06:35:42.056 E - -object PROCEDURE "SP_WORKER" is in use
2025-06-29 06:35:42.056 E + -object PROCEDURE "PUBLIC"."SP_WORKER" is in use
2025-06-29 06:35:42.057 E (335544345, 335544351, 335544453)
2025-06-29 06:35:42.057 E READ_COMMITTED_NO_RECORD_VERSION drop function fn_worker
2025-06-29 06:35:42.057 E lock conflict on no wait transaction
2025-06-29 06:35:42.057 E -unsuccessful metadata update
2025-06-29 06:35:42.057 E - -object FUNCTION "FN_WORKER" is in use
2025-06-29 06:35:42.057 E + -object FUNCTION "PUBLIC"."FN_WORKER" is in use
2025-06-29 06:35:42.057 E (335544345, 335544351, 335544453)
2025-06-29 06:35:42.057 E READ_COMMITTED_NO_RECORD_VERSION drop view v_test
2025-06-29 06:35:42.057 E lock conflict on no wait transaction
2025-06-29 06:35:42.057 E -unsuccessful metadata update
2025-06-29 06:35:42.057 E - -object VIEW "V_TEST" is in use
2025-06-29 06:35:42.057 E + -object VIEW "PUBLIC"."V_TEST" is in use
2025-06-29 06:35:42.057 E (335544345, 335544351, 335544453)
2025-06-29 06:35:42.057 E READ_COMMITTED_NO_RECORD_VERSION drop table test2
2025-06-29 06:35:42.057 E lock conflict on no wait transaction
2025-06-29 06:35:42.057 E -unsuccessful metadata update
2025-06-29 06:35:42.057 E - -object TABLE "TEST2" is in use
2025-06-29 06:35:42.057 E + -object TABLE "PUBLIC"."TEST2" is in use
2025-06-29 06:35:42.058 E (335544345, 335544351, 335544453)
2025-06-29 06:35:42.058 E READ_COMMITTED_NO_RECORD_VERSION drop index test1_id
2025-06-29 06:35:42.058 E lock conflict on no wait transaction
2025-06-29 06:35:42.058 E -unsuccessful metadata update
2025-06-29 06:35:42.058 E - -object INDEX "TEST1_ID" is in use
2025-06-29 06:35:42.058 E + -object INDEX "PUBLIC"."TEST1_ID" is in use
2025-06-29 06:35:42.058 E (335544345, 335544351, 335544453)
2025-06-29 06:35:42.058 E READ_COMMITTED_NO_RECORD_VERSION drop index test2_x
2025-06-29 06:35:42.058 E lock conflict on no wait transaction
2025-06-29 06:35:42.058 E -unsuccessful metadata update
2025-06-29 06:35:42.058 E - -object INDEX "TEST2_X" is in use
2025-06-29 06:35:42.058 E + -object INDEX "PUBLIC"."TEST2_X" is in use
2025-06-29 06:35:42.058 E (335544345, 335544351, 335544453)
2025-06-29 06:35:42.058 E READ_COMMITTED_RECORD_VERSION drop procedure sp_test
2025-06-29 06:35:42.058 E lock conflict on no wait transaction
2025-06-29 06:35:42.058 E -unsuccessful metadata update
2025-06-29 06:35:42.058 E - -object PROCEDURE "SP_TEST" is in use
2025-06-29 06:35:42.059 E + -object PROCEDURE "PUBLIC"."SP_TEST" is in use
2025-06-29 06:35:42.059 E (335544345, 335544351, 335544453)
2025-06-29 06:35:42.059 E READ_COMMITTED_RECORD_VERSION drop procedure sp_worker
2025-06-29 06:35:42.059 E lock conflict on no wait transaction
2025-06-29 06:35:42.059 E -unsuccessful metadata update
2025-06-29 06:35:42.059 E - -object PROCEDURE "SP_WORKER" is in use
2025-06-29 06:35:42.059 E + -object PROCEDURE "PUBLIC"."SP_WORKER" is in use
2025-06-29 06:35:42.059 E (335544345, 335544351, 335544453)
2025-06-29 06:35:42.059 E READ_COMMITTED_RECORD_VERSION drop function fn_worker
2025-06-29 06:35:42.059 E lock conflict on no wait transaction
2025-06-29 06:35:42.059 E -unsuccessful metadata update
2025-06-29 06:35:42.059 E - -object FUNCTION "FN_WORKER" is in use
2025-06-29 06:35:42.059 E + -object FUNCTION "PUBLIC"."FN_WORKER" is in use
2025-06-29 06:35:42.059 E (335544345, 335544351, 335544453)
2025-06-29 06:35:42.059 E READ_COMMITTED_RECORD_VERSION drop view v_test
2025-06-29 06:35:42.059 E lock conflict on no wait transaction
2025-06-29 06:35:42.059 E -unsuccessful metadata update
2025-06-29 06:35:42.059 E - -object VIEW "V_TEST" is in use
2025-06-29 06:35:42.060 E + -object VIEW "PUBLIC"."V_TEST" is in use
2025-06-29 06:35:42.060 E (335544345, 335544351, 335544453)
2025-06-29 06:35:42.060 E READ_COMMITTED_RECORD_VERSION drop table test2
2025-06-29 06:35:42.060 E lock conflict on no wait transaction
2025-06-29 06:35:42.060 E -unsuccessful metadata update
2025-06-29 06:35:42.060 E - -object TABLE "TEST2" is in use
2025-06-29 06:35:42.060 E + -object TABLE "PUBLIC"."TEST2" is in use
2025-06-29 06:35:42.060 E (335544345, 335544351, 335544453)
2025-06-29 06:35:42.060 E READ_COMMITTED_RECORD_VERSION drop index test1_id
2025-06-29 06:35:42.060 E lock conflict on no wait transaction
2025-06-29 06:35:42.060 E -unsuccessful metadata update
2025-06-29 06:35:42.060 E - -object INDEX "TEST1_ID" is in use
2025-06-29 06:35:42.060 E + -object INDEX "PUBLIC"."TEST1_ID" is in use
2025-06-29 06:35:42.060 E (335544345, 335544351, 335544453)
2025-06-29 06:35:42.060 E READ_COMMITTED_RECORD_VERSION drop index test2_x
2025-06-29 06:35:42.060 E lock conflict on no wait transaction
2025-06-29 06:35:42.060 E -unsuccessful metadata update
2025-06-29 06:35:42.061 E - -object INDEX "TEST2_X" is in use
2025-06-29 06:35:42.061 E + -object INDEX "PUBLIC"."TEST2_X" is in use
2025-06-29 06:35:42.061 E (335544345, 335544351, 335544453)
2025-06-29 06:35:42.061 E SNAPSHOT drop procedure sp_test
2025-06-29 06:35:42.061 E lock conflict on no wait transaction
2025-06-29 06:35:42.061 E -unsuccessful metadata update
2025-06-29 06:35:42.061 E - -object PROCEDURE "SP_TEST" is in use
2025-06-29 06:35:42.061 E + -object PROCEDURE "PUBLIC"."SP_TEST" is in use
2025-06-29 06:35:42.061 E (335544345, 335544351, 335544453)
2025-06-29 06:35:42.061 E SNAPSHOT drop procedure sp_worker
2025-06-29 06:35:42.061 E lock conflict on no wait transaction
2025-06-29 06:35:42.061 E -unsuccessful metadata update
2025-06-29 06:35:42.061 E - -object PROCEDURE "SP_WORKER" is in use
2025-06-29 06:35:42.061 E + -object PROCEDURE "PUBLIC"."SP_WORKER" is in use
2025-06-29 06:35:42.061 E (335544345, 335544351, 335544453)
2025-06-29 06:35:42.061 E SNAPSHOT drop function fn_worker
2025-06-29 06:35:42.061 E lock conflict on no wait transaction
2025-06-29 06:35:42.062 E -unsuccessful metadata update
2025-06-29 06:35:42.062 E - -object FUNCTION "FN_WORKER" is in use
2025-06-29 06:35:42.062 E + -object FUNCTION "PUBLIC"."FN_WORKER" is in use
2025-06-29 06:35:42.062 E (335544345, 335544351, 335544453)
2025-06-29 06:35:42.062 E SNAPSHOT drop view v_test
2025-06-29 06:35:42.062 E lock conflict on no wait transaction
2025-06-29 06:35:42.062 E -unsuccessful metadata update
2025-06-29 06:35:42.062 E - -object VIEW "V_TEST" is in use
2025-06-29 06:35:42.062 E + -object VIEW "PUBLIC"."V_TEST" is in use
2025-06-29 06:35:42.062 E (335544345, 335544351, 335544453)
2025-06-29 06:35:42.062 E SNAPSHOT drop table test2
2025-06-29 06:35:42.062 E lock conflict on no wait transaction
2025-06-29 06:35:42.062 E -unsuccessful metadata update
2025-06-29 06:35:42.062 E - -object TABLE "TEST2" is in use
2025-06-29 06:35:42.062 E + -object TABLE "PUBLIC"."TEST2" is in use
2025-06-29 06:35:42.062 E (335544345, 335544351, 335544453)
2025-06-29 06:35:42.062 E SNAPSHOT drop index test1_id
2025-06-29 06:35:42.063 E lock conflict on no wait transaction
2025-06-29 06:35:42.063 E -unsuccessful metadata update
2025-06-29 06:35:42.063 E - -object INDEX "TEST1_ID" is in use
2025-06-29 06:35:42.063 E + -object INDEX "PUBLIC"."TEST1_ID" is in use
2025-06-29 06:35:42.063 E (335544345, 335544351, 335544453)
2025-06-29 06:35:42.063 E SNAPSHOT drop index test2_x
2025-06-29 06:35:42.063 E lock conflict on no wait transaction
2025-06-29 06:35:42.063 E -unsuccessful metadata update
2025-06-29 06:35:42.063 E - -object INDEX "TEST2_X" is in use
2025-06-29 06:35:42.063 E + -object INDEX "PUBLIC"."TEST2_X" is in use
2025-06-29 06:35:42.063 E (335544345, 335544351, 335544453)
2025-06-29 06:35:42.063 E SERIALIZABLE drop procedure sp_test
2025-06-29 06:35:42.063 E lock conflict on no wait transaction
2025-06-29 06:35:42.063 E -unsuccessful metadata update
2025-06-29 06:35:42.063 E - -object PROCEDURE "SP_TEST" is in use
2025-06-29 06:35:42.063 E + -object PROCEDURE "PUBLIC"."SP_TEST" is in use
2025-06-29 06:35:42.063 E (335544345, 335544351, 335544453)
2025-06-29 06:35:42.063 E SERIALIZABLE drop procedure sp_worker
2025-06-29 06:35:42.064 E lock conflict on no wait transaction
2025-06-29 06:35:42.064 E -unsuccessful metadata update
2025-06-29 06:35:42.064 E - -object PROCEDURE "SP_WORKER" is in use
2025-06-29 06:35:42.064 E + -object PROCEDURE "PUBLIC"."SP_WORKER" is in use
2025-06-29 06:35:42.064 E (335544345, 335544351, 335544453)
2025-06-29 06:35:42.064 E SERIALIZABLE drop function fn_worker
2025-06-29 06:35:42.064 E lock conflict on no wait transaction
2025-06-29 06:35:42.064 E -unsuccessful metadata update
2025-06-29 06:35:42.064 E - -object FUNCTION "FN_WORKER" is in use
2025-06-29 06:35:42.064 E + -object FUNCTION "PUBLIC"."FN_WORKER" is in use
2025-06-29 06:35:42.064 E (335544345, 335544351, 335544453)
2025-06-29 06:35:42.064 E SERIALIZABLE drop view v_test
2025-06-29 06:35:42.064 E lock conflict on no wait transaction
2025-06-29 06:35:42.064 E -unsuccessful metadata update
2025-06-29 06:35:42.064 E - -object VIEW "V_TEST" is in use
2025-06-29 06:35:42.064 E + -object VIEW "PUBLIC"."V_TEST" is in use
2025-06-29 06:35:42.065 E (335544345, 335544351, 335544453)
2025-06-29 06:35:42.065 E SERIALIZABLE drop table test2
2025-06-29 06:35:42.065 E lock conflict on no wait transaction
2025-06-29 06:35:42.065 E -unsuccessful metadata update
2025-06-29 06:35:42.065 E - -object TABLE "TEST2" is in use
2025-06-29 06:35:42.065 E + -object TABLE "PUBLIC"."TEST2" is in use
2025-06-29 06:35:42.065 E (335544345, 335544351, 335544453)
2025-06-29 06:35:42.065 E SERIALIZABLE drop index test1_id
2025-06-29 06:35:42.065 E lock conflict on no wait transaction
2025-06-29 06:35:42.065 E -unsuccessful metadata update
2025-06-29 06:35:42.065 E - -object INDEX "TEST1_ID" is in use
2025-06-29 06:35:42.065 E + -object INDEX "PUBLIC"."TEST1_ID" is in use
2025-06-29 06:35:42.065 E (335544345, 335544351, 335544453)
2025-06-29 06:35:42.065 E SERIALIZABLE drop index test2_x
2025-06-29 06:35:42.065 E lock conflict on no wait transaction
2025-06-29 06:35:42.065 E -unsuccessful metadata update
2025-06-29 06:35:42.065 E - -object INDEX "TEST2_X" is in use
2025-06-29 06:35:42.065 E + -object INDEX "PUBLIC"."TEST2_X" is in use
2025-06-29 06:35:42.066 E (335544345, 335544351, 335544453)
2025-06-29 06:35:42.066 E READ_COMMITTED_READ_CONSISTENCY drop procedure sp_test
2025-06-29 06:35:42.066 E lock conflict on no wait transaction
2025-06-29 06:35:42.066 E -unsuccessful metadata update
2025-06-29 06:35:42.066 E - -object PROCEDURE "SP_TEST" is in use
2025-06-29 06:35:42.066 E + -object PROCEDURE "PUBLIC"."SP_TEST" is in use
2025-06-29 06:35:42.066 E (335544345, 335544351, 335544453)
2025-06-29 06:35:42.066 E READ_COMMITTED_READ_CONSISTENCY drop procedure sp_worker
2025-06-29 06:35:42.066 E lock conflict on no wait transaction
2025-06-29 06:35:42.066 E -unsuccessful metadata update
2025-06-29 06:35:42.066 E - -object PROCEDURE "SP_WORKER" is in use
2025-06-29 06:35:42.066 E + -object PROCEDURE "PUBLIC"."SP_WORKER" is in use
2025-06-29 06:35:42.066 E (335544345, 335544351, 335544453)
2025-06-29 06:35:42.066 E READ_COMMITTED_READ_CONSISTENCY drop function fn_worker
2025-06-29 06:35:42.066 E lock conflict on no wait transaction
2025-06-29 06:35:42.066 E -unsuccessful metadata update
2025-06-29 06:35:42.066 E - -object FUNCTION "FN_WORKER" is in use
2025-06-29 06:35:42.067 E + -object FUNCTION "PUBLIC"."FN_WORKER" is in use
2025-06-29 06:35:42.067 E (335544345, 335544351, 335544453)
2025-06-29 06:35:42.067 E READ_COMMITTED_READ_CONSISTENCY drop view v_test
2025-06-29 06:35:42.067 E lock conflict on no wait transaction
2025-06-29 06:35:42.067 E -unsuccessful metadata update
2025-06-29 06:35:42.067 E - -object VIEW "V_TEST" is in use
2025-06-29 06:35:42.067 E + -object VIEW "PUBLIC"."V_TEST" is in use
2025-06-29 06:35:42.067 E (335544345, 335544351, 335544453)
2025-06-29 06:35:42.067 E READ_COMMITTED_READ_CONSISTENCY drop table test2
2025-06-29 06:35:42.067 E lock conflict on no wait transaction
2025-06-29 06:35:42.067 E -unsuccessful metadata update
2025-06-29 06:35:42.067 E - -object TABLE "TEST2" is in use
2025-06-29 06:35:42.067 E + -object TABLE "PUBLIC"."TEST2" is in use
2025-06-29 06:35:42.067 E (335544345, 335544351, 335544453)
2025-06-29 06:35:42.067 E READ_COMMITTED_READ_CONSISTENCY drop index test1_id
2025-06-29 06:35:42.067 E lock conflict on no wait transaction
2025-06-29 06:35:42.067 E -unsuccessful metadata update
2025-06-29 06:35:42.067 E - -object INDEX "TEST1_ID" is in use
2025-06-29 06:35:42.068 E + -object INDEX "PUBLIC"."TEST1_ID" is in use
2025-06-29 06:35:42.068 E (335544345, 335544351, 335544453)
2025-06-29 06:35:42.068 E READ_COMMITTED_READ_CONSISTENCY drop index test2_x
2025-06-29 06:35:42.068 E lock conflict on no wait transaction
2025-06-29 06:35:42.068 E -unsuccessful metadata update
2025-06-29 06:35:42.068 E - -object INDEX "TEST2_X" is in use
2025-06-29 06:35:42.068 E + -object INDEX "PUBLIC"."TEST2_X" is in use
2025-06-29 06:35:42.068 E (335544345, 335544351, 335544453)
2025-06-29 06:35:42.068
2025-06-29 06:35:42.068 tests\bugs\core_4386_test.py:370: AssertionError
2025-06-29 06:35:42.068 ---------------------------- Captured stdout setup ----------------------------
2025-06-29 06:35:42.068 Creating db: localhost:H:\QA\temp\qa2024.tmp\fbqa\test_1841\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
|