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-27 06:37:13.396
2025-06-27 06:37:13.396 act = <firebird.qa.plugin.Action object at [hex]>
2025-06-27 06:37:13.396 capsys = <_pytest.capture.CaptureFixture object at [hex]>
2025-06-27 06:37:13.396
2025-06-27 06:37:13.396 @pytest.mark.version('>=4.0')
2025-06-27 06:37:13.396 def test_1(act: Action, capsys):
2025-06-27 06:37:13.396 act.isql(switches=[], input=ddl_script)
2025-06-27 06:37:13.396
2025-06-27 06:37:13.396 drop_commands = [ 'drop procedure sp_test',
2025-06-27 06:37:13.396 'drop procedure sp_worker',
2025-06-27 06:37:13.396 'drop function fn_worker',
2025-06-27 06:37:13.396 'drop view v_test',
2025-06-27 06:37:13.396 'drop table test2',
2025-06-27 06:37:13.396 'drop index test1_id',
2025-06-27 06:37:13.397 'drop index test2_x'
2025-06-27 06:37:13.397 ]
2025-06-27 06:37:13.397
2025-06-27 06:37:13.397 tx_isol_lst = [ Isolation.READ_COMMITTED_NO_RECORD_VERSION,
2025-06-27 06:37:13.397 Isolation.READ_COMMITTED_RECORD_VERSION,
2025-06-27 06:37:13.397 Isolation.SNAPSHOT,
2025-06-27 06:37:13.397 Isolation.SERIALIZABLE,
2025-06-27 06:37:13.397 ]
2025-06-27 06:37:13.397 if act.is_version('>=4'):
2025-06-27 06:37:13.397 tx_isol_lst.append(Isolation.READ_COMMITTED_READ_CONSISTENCY)
2025-06-27 06:37:13.397
2025-06-27 06:37:13.397 # for any isolation mode attempt to drop object that is in use by another Tx must fail
2025-06-27 06:37:13.397 # with the same error message. We check all possible Tx isolation modes for that:
2025-06-27 06:37:13.397 for x_isol in tx_isol_lst:
2025-06-27 06:37:13.397
2025-06-27 06:37:13.397 with act.db.connect() as con1:
2025-06-27 06:37:13.398
2025-06-27 06:37:13.398 cur1 = con1.cursor()
2025-06-27 06:37:13.398 cur1.execute('select x from sp_test(21)').fetchall()
2025-06-27 06:37:13.398
2025-06-27 06:37:13.398 for cmd in drop_commands:
2025-06-27 06:37:13.398 with act.db.connect() as con2:
2025-06-27 06:37:13.398 custom_tpb = tpb(isolation = x_isol, lock_timeout=0)
2025-06-27 06:37:13.398 print(x_isol.name, cmd)
2025-06-27 06:37:13.398 tx2 = con2.transaction_manager(custom_tpb)
2025-06-27 06:37:13.398 tx2.begin()
2025-06-27 06:37:13.398 cur2 = tx2.cursor()
2025-06-27 06:37:13.398 try:
2025-06-27 06:37:13.398 cur2.execute(cmd) # this will PASS because of DDL nature
2025-06-27 06:37:13.398
2025-06-27 06:37:13.398 ##########################################################################
2025-06-27 06:37:13.398 ### We have to call commit() exactly by TRANSACTION object here. ###
2025-06-27 06:37:13.399 ### DO NOT use con2.commit() because this actually leads transaction ###
2025-06-27 06:37:13.399 ### to be 'silently rolled back', thus we will not get error messages! ###
2025-06-27 06:37:13.399 ##########################################################################
2025-06-27 06:37:13.399 tx2.commit() # <<< this lead to FAILED_COMMIT in the trace <<<
2025-06-27 06:37:13.399
2025-06-27 06:37:13.399 except Exception as e:
2025-06-27 06:37:13.399 print(e.__str__())
2025-06-27 06:37:13.399 print(e.gds_codes)
2025-06-27 06:37:13.399
2025-06-27 06:37:13.399 act.expected_stdout = f"""
2025-06-27 06:37:13.399 READ_COMMITTED_NO_RECORD_VERSION drop procedure sp_test
2025-06-27 06:37:13.399 lock conflict on no wait transaction
2025-06-27 06:37:13.399 -unsuccessful metadata update
2025-06-27 06:37:13.399 -object PROCEDURE "SP_TEST" is in use
2025-06-27 06:37:13.399 (335544345, 335544351, 335544453)
2025-06-27 06:37:13.399
2025-06-27 06:37:13.399 READ_COMMITTED_NO_RECORD_VERSION drop procedure sp_worker
2025-06-27 06:37:13.400 lock conflict on no wait transaction
2025-06-27 06:37:13.400 -unsuccessful metadata update
2025-06-27 06:37:13.400 -object PROCEDURE "SP_WORKER" is in use
2025-06-27 06:37:13.400 (335544345, 335544351, 335544453)
2025-06-27 06:37:13.400
2025-06-27 06:37:13.400 READ_COMMITTED_NO_RECORD_VERSION drop function fn_worker
2025-06-27 06:37:13.400 lock conflict on no wait transaction
2025-06-27 06:37:13.400 -unsuccessful metadata update
2025-06-27 06:37:13.400 -object FUNCTION "FN_WORKER" is in use
2025-06-27 06:37:13.400 (335544345, 335544351, 335544453)
2025-06-27 06:37:13.400
2025-06-27 06:37:13.400 READ_COMMITTED_NO_RECORD_VERSION drop view v_test
2025-06-27 06:37:13.400 lock conflict on no wait transaction
2025-06-27 06:37:13.400 -unsuccessful metadata update
2025-06-27 06:37:13.400 -object VIEW "V_TEST" is in use
2025-06-27 06:37:13.401 (335544345, 335544351, 335544453)
2025-06-27 06:37:13.401
2025-06-27 06:37:13.401 READ_COMMITTED_NO_RECORD_VERSION drop table test2
2025-06-27 06:37:13.401 lock conflict on no wait transaction
2025-06-27 06:37:13.401 -unsuccessful metadata update
2025-06-27 06:37:13.401 -object TABLE "TEST2" is in use
2025-06-27 06:37:13.401 (335544345, 335544351, 335544453)
2025-06-27 06:37:13.401
2025-06-27 06:37:13.401 READ_COMMITTED_NO_RECORD_VERSION drop index test1_id
2025-06-27 06:37:13.401 lock conflict on no wait transaction
2025-06-27 06:37:13.401 -unsuccessful metadata update
2025-06-27 06:37:13.401 -object INDEX "TEST1_ID" is in use
2025-06-27 06:37:13.401 (335544345, 335544351, 335544453)
2025-06-27 06:37:13.401
2025-06-27 06:37:13.401 READ_COMMITTED_NO_RECORD_VERSION drop index test2_x
2025-06-27 06:37:13.401 lock conflict on no wait transaction
2025-06-27 06:37:13.402 -unsuccessful metadata update
2025-06-27 06:37:13.402 -object INDEX "TEST2_X" is in use
2025-06-27 06:37:13.402 (335544345, 335544351, 335544453)
2025-06-27 06:37:13.402
2025-06-27 06:37:13.402 READ_COMMITTED_RECORD_VERSION drop procedure sp_test
2025-06-27 06:37:13.402 lock conflict on no wait transaction
2025-06-27 06:37:13.402 -unsuccessful metadata update
2025-06-27 06:37:13.402 -object PROCEDURE "SP_TEST" is in use
2025-06-27 06:37:13.402 (335544345, 335544351, 335544453)
2025-06-27 06:37:13.402
2025-06-27 06:37:13.402 READ_COMMITTED_RECORD_VERSION drop procedure sp_worker
2025-06-27 06:37:13.402 lock conflict on no wait transaction
2025-06-27 06:37:13.402 -unsuccessful metadata update
2025-06-27 06:37:13.402 -object PROCEDURE "SP_WORKER" is in use
2025-06-27 06:37:13.402 (335544345, 335544351, 335544453)
2025-06-27 06:37:13.403
2025-06-27 06:37:13.403 READ_COMMITTED_RECORD_VERSION drop function fn_worker
2025-06-27 06:37:13.403 lock conflict on no wait transaction
2025-06-27 06:37:13.403 -unsuccessful metadata update
2025-06-27 06:37:13.403 -object FUNCTION "FN_WORKER" is in use
2025-06-27 06:37:13.403 (335544345, 335544351, 335544453)
2025-06-27 06:37:13.403
2025-06-27 06:37:13.403 READ_COMMITTED_RECORD_VERSION drop view v_test
2025-06-27 06:37:13.403 lock conflict on no wait transaction
2025-06-27 06:37:13.403 -unsuccessful metadata update
2025-06-27 06:37:13.403 -object VIEW "V_TEST" is in use
2025-06-27 06:37:13.403 (335544345, 335544351, 335544453)
2025-06-27 06:37:13.403
2025-06-27 06:37:13.403 READ_COMMITTED_RECORD_VERSION drop table test2
2025-06-27 06:37:13.403 lock conflict on no wait transaction
2025-06-27 06:37:13.404 -unsuccessful metadata update
2025-06-27 06:37:13.404 -object TABLE "TEST2" is in use
2025-06-27 06:37:13.404 (335544345, 335544351, 335544453)
2025-06-27 06:37:13.404
2025-06-27 06:37:13.404 READ_COMMITTED_RECORD_VERSION drop index test1_id
2025-06-27 06:37:13.404 lock conflict on no wait transaction
2025-06-27 06:37:13.404 -unsuccessful metadata update
2025-06-27 06:37:13.404 -object INDEX "TEST1_ID" is in use
2025-06-27 06:37:13.404 (335544345, 335544351, 335544453)
2025-06-27 06:37:13.404
2025-06-27 06:37:13.404 READ_COMMITTED_RECORD_VERSION drop index test2_x
2025-06-27 06:37:13.404 lock conflict on no wait transaction
2025-06-27 06:37:13.404 -unsuccessful metadata update
2025-06-27 06:37:13.404 -object INDEX "TEST2_X" is in use
2025-06-27 06:37:13.405 (335544345, 335544351, 335544453)
2025-06-27 06:37:13.405
2025-06-27 06:37:13.405 SNAPSHOT drop procedure sp_test
2025-06-27 06:37:13.405 lock conflict on no wait transaction
2025-06-27 06:37:13.405 -unsuccessful metadata update
2025-06-27 06:37:13.405 -object PROCEDURE "SP_TEST" is in use
2025-06-27 06:37:13.405 (335544345, 335544351, 335544453)
2025-06-27 06:37:13.405
2025-06-27 06:37:13.405 SNAPSHOT drop procedure sp_worker
2025-06-27 06:37:13.405 lock conflict on no wait transaction
2025-06-27 06:37:13.405 -unsuccessful metadata update
2025-06-27 06:37:13.405 -object PROCEDURE "SP_WORKER" is in use
2025-06-27 06:37:13.405 (335544345, 335544351, 335544453)
2025-06-27 06:37:13.405
2025-06-27 06:37:13.405 SNAPSHOT drop function fn_worker
2025-06-27 06:37:13.406 lock conflict on no wait transaction
2025-06-27 06:37:13.406 -unsuccessful metadata update
2025-06-27 06:37:13.406 -object FUNCTION "FN_WORKER" is in use
2025-06-27 06:37:13.406 (335544345, 335544351, 335544453)
2025-06-27 06:37:13.406
2025-06-27 06:37:13.406 SNAPSHOT drop view v_test
2025-06-27 06:37:13.406 lock conflict on no wait transaction
2025-06-27 06:37:13.406 -unsuccessful metadata update
2025-06-27 06:37:13.406 -object VIEW "V_TEST" is in use
2025-06-27 06:37:13.406 (335544345, 335544351, 335544453)
2025-06-27 06:37:13.406
2025-06-27 06:37:13.406 SNAPSHOT drop table test2
2025-06-27 06:37:13.406 lock conflict on no wait transaction
2025-06-27 06:37:13.406 -unsuccessful metadata update
2025-06-27 06:37:13.406 -object TABLE "TEST2" is in use
2025-06-27 06:37:13.407 (335544345, 335544351, 335544453)
2025-06-27 06:37:13.407
2025-06-27 06:37:13.407 SNAPSHOT drop index test1_id
2025-06-27 06:37:13.407 lock conflict on no wait transaction
2025-06-27 06:37:13.407 -unsuccessful metadata update
2025-06-27 06:37:13.407 -object INDEX "TEST1_ID" is in use
2025-06-27 06:37:13.407 (335544345, 335544351, 335544453)
2025-06-27 06:37:13.407
2025-06-27 06:37:13.407 SNAPSHOT drop index test2_x
2025-06-27 06:37:13.407 lock conflict on no wait transaction
2025-06-27 06:37:13.407 -unsuccessful metadata update
2025-06-27 06:37:13.407 -object INDEX "TEST2_X" is in use
2025-06-27 06:37:13.407 (335544345, 335544351, 335544453)
2025-06-27 06:37:13.407
2025-06-27 06:37:13.407 SERIALIZABLE drop procedure sp_test
2025-06-27 06:37:13.408 lock conflict on no wait transaction
2025-06-27 06:37:13.408 -unsuccessful metadata update
2025-06-27 06:37:13.408 -object PROCEDURE "SP_TEST" is in use
2025-06-27 06:37:13.408 (335544345, 335544351, 335544453)
2025-06-27 06:37:13.408
2025-06-27 06:37:13.408 SERIALIZABLE drop procedure sp_worker
2025-06-27 06:37:13.408 lock conflict on no wait transaction
2025-06-27 06:37:13.408 -unsuccessful metadata update
2025-06-27 06:37:13.408 -object PROCEDURE "SP_WORKER" is in use
2025-06-27 06:37:13.408 (335544345, 335544351, 335544453)
2025-06-27 06:37:13.408
2025-06-27 06:37:13.408 SERIALIZABLE drop function fn_worker
2025-06-27 06:37:13.408 lock conflict on no wait transaction
2025-06-27 06:37:13.408 -unsuccessful metadata update
2025-06-27 06:37:13.408 -object FUNCTION "FN_WORKER" is in use
2025-06-27 06:37:13.409 (335544345, 335544351, 335544453)
2025-06-27 06:37:13.409
2025-06-27 06:37:13.409 SERIALIZABLE drop view v_test
2025-06-27 06:37:13.409 lock conflict on no wait transaction
2025-06-27 06:37:13.409 -unsuccessful metadata update
2025-06-27 06:37:13.409 -object VIEW "V_TEST" is in use
2025-06-27 06:37:13.409 (335544345, 335544351, 335544453)
2025-06-27 06:37:13.409
2025-06-27 06:37:13.409 SERIALIZABLE drop table test2
2025-06-27 06:37:13.409 lock conflict on no wait transaction
2025-06-27 06:37:13.409 -unsuccessful metadata update
2025-06-27 06:37:13.409 -object TABLE "TEST2" is in use
2025-06-27 06:37:13.409 (335544345, 335544351, 335544453)
2025-06-27 06:37:13.409
2025-06-27 06:37:13.409 SERIALIZABLE drop index test1_id
2025-06-27 06:37:13.410 lock conflict on no wait transaction
2025-06-27 06:37:13.410 -unsuccessful metadata update
2025-06-27 06:37:13.410 -object INDEX "TEST1_ID" is in use
2025-06-27 06:37:13.410 (335544345, 335544351, 335544453)
2025-06-27 06:37:13.410
2025-06-27 06:37:13.410 SERIALIZABLE drop index test2_x
2025-06-27 06:37:13.410 lock conflict on no wait transaction
2025-06-27 06:37:13.410 -unsuccessful metadata update
2025-06-27 06:37:13.410 -object INDEX "TEST2_X" is in use
2025-06-27 06:37:13.410 (335544345, 335544351, 335544453)
2025-06-27 06:37:13.410
2025-06-27 06:37:13.410 READ_COMMITTED_READ_CONSISTENCY drop procedure sp_test
2025-06-27 06:37:13.410 lock conflict on no wait transaction
2025-06-27 06:37:13.410 -unsuccessful metadata update
2025-06-27 06:37:13.410 -object PROCEDURE "SP_TEST" is in use
2025-06-27 06:37:13.410 (335544345, 335544351, 335544453)
2025-06-27 06:37:13.411
2025-06-27 06:37:13.411 READ_COMMITTED_READ_CONSISTENCY drop procedure sp_worker
2025-06-27 06:37:13.411 lock conflict on no wait transaction
2025-06-27 06:37:13.411 -unsuccessful metadata update
2025-06-27 06:37:13.411 -object PROCEDURE "SP_WORKER" is in use
2025-06-27 06:37:13.411 (335544345, 335544351, 335544453)
2025-06-27 06:37:13.411
2025-06-27 06:37:13.411 READ_COMMITTED_READ_CONSISTENCY drop function fn_worker
2025-06-27 06:37:13.411 lock conflict on no wait transaction
2025-06-27 06:37:13.411 -unsuccessful metadata update
2025-06-27 06:37:13.411 -object FUNCTION "FN_WORKER" is in use
2025-06-27 06:37:13.411 (335544345, 335544351, 335544453)
2025-06-27 06:37:13.411
2025-06-27 06:37:13.412 READ_COMMITTED_READ_CONSISTENCY drop view v_test
2025-06-27 06:37:13.412 lock conflict on no wait transaction
2025-06-27 06:37:13.412 -unsuccessful metadata update
2025-06-27 06:37:13.412 -object VIEW "V_TEST" is in use
2025-06-27 06:37:13.412 (335544345, 335544351, 335544453)
2025-06-27 06:37:13.412
2025-06-27 06:37:13.412 READ_COMMITTED_READ_CONSISTENCY drop table test2
2025-06-27 06:37:13.412 lock conflict on no wait transaction
2025-06-27 06:37:13.412 -unsuccessful metadata update
2025-06-27 06:37:13.412 -object TABLE "TEST2" is in use
2025-06-27 06:37:13.412 (335544345, 335544351, 335544453)
2025-06-27 06:37:13.412
2025-06-27 06:37:13.412 READ_COMMITTED_READ_CONSISTENCY drop index test1_id
2025-06-27 06:37:13.412 lock conflict on no wait transaction
2025-06-27 06:37:13.412 -unsuccessful metadata update
2025-06-27 06:37:13.413 -object INDEX "TEST1_ID" is in use
2025-06-27 06:37:13.413 (335544345, 335544351, 335544453)
2025-06-27 06:37:13.413
2025-06-27 06:37:13.413 READ_COMMITTED_READ_CONSISTENCY drop index test2_x
2025-06-27 06:37:13.413 lock conflict on no wait transaction
2025-06-27 06:37:13.413 -unsuccessful metadata update
2025-06-27 06:37:13.413 -object INDEX "TEST2_X" is in use
2025-06-27 06:37:13.413 (335544345, 335544351, 335544453)
2025-06-27 06:37:13.413 """
2025-06-27 06:37:13.413
2025-06-27 06:37:13.413 act.stdout = capsys.readouterr().out
2025-06-27 06:37:13.413 > assert act.clean_stdout == act.clean_expected_stdout
2025-06-27 06:37:13.413 E assert
2025-06-27 06:37:13.413 E READ_COMMITTED_NO_RECORD_VERSION drop procedure sp_test
2025-06-27 06:37:13.413 E lock conflict on no wait transaction
2025-06-27 06:37:13.414 E -unsuccessful metadata update
2025-06-27 06:37:13.414 E - -object PROCEDURE "SP_TEST" is in use
2025-06-27 06:37:13.414 E + -object PROCEDURE "PUBLIC"."SP_TEST" is in use
2025-06-27 06:37:13.414 E (335544345, 335544351, 335544453)
2025-06-27 06:37:13.414 E READ_COMMITTED_NO_RECORD_VERSION drop procedure sp_worker
2025-06-27 06:37:13.414 E lock conflict on no wait transaction
2025-06-27 06:37:13.414 E -unsuccessful metadata update
2025-06-27 06:37:13.414 E - -object PROCEDURE "SP_WORKER" is in use
2025-06-27 06:37:13.414 E + -object PROCEDURE "PUBLIC"."SP_WORKER" is in use
2025-06-27 06:37:13.414 E (335544345, 335544351, 335544453)
2025-06-27 06:37:13.414 E READ_COMMITTED_NO_RECORD_VERSION drop function fn_worker
2025-06-27 06:37:13.414 E lock conflict on no wait transaction
2025-06-27 06:37:13.414 E -unsuccessful metadata update
2025-06-27 06:37:13.415 E - -object FUNCTION "FN_WORKER" is in use
2025-06-27 06:37:13.415 E + -object FUNCTION "PUBLIC"."FN_WORKER" is in use
2025-06-27 06:37:13.415 E (335544345, 335544351, 335544453)
2025-06-27 06:37:13.415 E READ_COMMITTED_NO_RECORD_VERSION drop view v_test
2025-06-27 06:37:13.415 E lock conflict on no wait transaction
2025-06-27 06:37:13.415 E -unsuccessful metadata update
2025-06-27 06:37:13.415 E - -object VIEW "V_TEST" is in use
2025-06-27 06:37:13.415 E + -object VIEW "PUBLIC"."V_TEST" is in use
2025-06-27 06:37:13.415 E (335544345, 335544351, 335544453)
2025-06-27 06:37:13.415 E READ_COMMITTED_NO_RECORD_VERSION drop table test2
2025-06-27 06:37:13.415 E lock conflict on no wait transaction
2025-06-27 06:37:13.415 E -unsuccessful metadata update
2025-06-27 06:37:13.415 E - -object TABLE "TEST2" is in use
2025-06-27 06:37:13.416 E + -object TABLE "PUBLIC"."TEST2" is in use
2025-06-27 06:37:13.416 E (335544345, 335544351, 335544453)
2025-06-27 06:37:13.416 E READ_COMMITTED_NO_RECORD_VERSION drop index test1_id
2025-06-27 06:37:13.416 E lock conflict on no wait transaction
2025-06-27 06:37:13.416 E -unsuccessful metadata update
2025-06-27 06:37:13.416 E - -object INDEX "TEST1_ID" is in use
2025-06-27 06:37:13.416 E + -object INDEX "PUBLIC"."TEST1_ID" is in use
2025-06-27 06:37:13.416 E (335544345, 335544351, 335544453)
2025-06-27 06:37:13.416 E READ_COMMITTED_NO_RECORD_VERSION drop index test2_x
2025-06-27 06:37:13.416 E lock conflict on no wait transaction
2025-06-27 06:37:13.416 E -unsuccessful metadata update
2025-06-27 06:37:13.416 E - -object INDEX "TEST2_X" is in use
2025-06-27 06:37:13.416 E + -object INDEX "PUBLIC"."TEST2_X" is in use
2025-06-27 06:37:13.417 E (335544345, 335544351, 335544453)
2025-06-27 06:37:13.417 E READ_COMMITTED_RECORD_VERSION drop procedure sp_test
2025-06-27 06:37:13.417 E lock conflict on no wait transaction
2025-06-27 06:37:13.417 E -unsuccessful metadata update
2025-06-27 06:37:13.417 E - -object PROCEDURE "SP_TEST" is in use
2025-06-27 06:37:13.417 E + -object PROCEDURE "PUBLIC"."SP_TEST" is in use
2025-06-27 06:37:13.417 E (335544345, 335544351, 335544453)
2025-06-27 06:37:13.417 E READ_COMMITTED_RECORD_VERSION drop procedure sp_worker
2025-06-27 06:37:13.417 E lock conflict on no wait transaction
2025-06-27 06:37:13.417 E -unsuccessful metadata update
2025-06-27 06:37:13.417 E - -object PROCEDURE "SP_WORKER" is in use
2025-06-27 06:37:13.417 E + -object PROCEDURE "PUBLIC"."SP_WORKER" is in use
2025-06-27 06:37:13.418 E (335544345, 335544351, 335544453)
2025-06-27 06:37:13.418 E READ_COMMITTED_RECORD_VERSION drop function fn_worker
2025-06-27 06:37:13.418 E lock conflict on no wait transaction
2025-06-27 06:37:13.418 E -unsuccessful metadata update
2025-06-27 06:37:13.418 E - -object FUNCTION "FN_WORKER" is in use
2025-06-27 06:37:13.418 E + -object FUNCTION "PUBLIC"."FN_WORKER" is in use
2025-06-27 06:37:13.418 E (335544345, 335544351, 335544453)
2025-06-27 06:37:13.418 E READ_COMMITTED_RECORD_VERSION drop view v_test
2025-06-27 06:37:13.418 E lock conflict on no wait transaction
2025-06-27 06:37:13.418 E -unsuccessful metadata update
2025-06-27 06:37:13.418 E - -object VIEW "V_TEST" is in use
2025-06-27 06:37:13.418 E + -object VIEW "PUBLIC"."V_TEST" is in use
2025-06-27 06:37:13.419 E (335544345, 335544351, 335544453)
2025-06-27 06:37:13.419 E READ_COMMITTED_RECORD_VERSION drop table test2
2025-06-27 06:37:13.419 E lock conflict on no wait transaction
2025-06-27 06:37:13.419 E -unsuccessful metadata update
2025-06-27 06:37:13.419 E - -object TABLE "TEST2" is in use
2025-06-27 06:37:13.419 E + -object TABLE "PUBLIC"."TEST2" is in use
2025-06-27 06:37:13.419 E (335544345, 335544351, 335544453)
2025-06-27 06:37:13.419 E READ_COMMITTED_RECORD_VERSION drop index test1_id
2025-06-27 06:37:13.419 E lock conflict on no wait transaction
2025-06-27 06:37:13.419 E -unsuccessful metadata update
2025-06-27 06:37:13.419 E - -object INDEX "TEST1_ID" is in use
2025-06-27 06:37:13.419 E + -object INDEX "PUBLIC"."TEST1_ID" is in use
2025-06-27 06:37:13.419 E (335544345, 335544351, 335544453)
2025-06-27 06:37:13.419 E READ_COMMITTED_RECORD_VERSION drop index test2_x
2025-06-27 06:37:13.420 E lock conflict on no wait transaction
2025-06-27 06:37:13.420 E -unsuccessful metadata update
2025-06-27 06:37:13.420 E - -object INDEX "TEST2_X" is in use
2025-06-27 06:37:13.420 E + -object INDEX "PUBLIC"."TEST2_X" is in use
2025-06-27 06:37:13.420 E (335544345, 335544351, 335544453)
2025-06-27 06:37:13.420 E SNAPSHOT drop procedure sp_test
2025-06-27 06:37:13.420 E lock conflict on no wait transaction
2025-06-27 06:37:13.420 E -unsuccessful metadata update
2025-06-27 06:37:13.420 E - -object PROCEDURE "SP_TEST" is in use
2025-06-27 06:37:13.420 E + -object PROCEDURE "PUBLIC"."SP_TEST" is in use
2025-06-27 06:37:13.420 E (335544345, 335544351, 335544453)
2025-06-27 06:37:13.420 E SNAPSHOT drop procedure sp_worker
2025-06-27 06:37:13.420 E lock conflict on no wait transaction
2025-06-27 06:37:13.420 E -unsuccessful metadata update
2025-06-27 06:37:13.420 E - -object PROCEDURE "SP_WORKER" is in use
2025-06-27 06:37:13.421 E + -object PROCEDURE "PUBLIC"."SP_WORKER" is in use
2025-06-27 06:37:13.421 E (335544345, 335544351, 335544453)
2025-06-27 06:37:13.421 E SNAPSHOT drop function fn_worker
2025-06-27 06:37:13.421 E lock conflict on no wait transaction
2025-06-27 06:37:13.421 E -unsuccessful metadata update
2025-06-27 06:37:13.421 E - -object FUNCTION "FN_WORKER" is in use
2025-06-27 06:37:13.421 E + -object FUNCTION "PUBLIC"."FN_WORKER" is in use
2025-06-27 06:37:13.421 E (335544345, 335544351, 335544453)
2025-06-27 06:37:13.421 E SNAPSHOT drop view v_test
2025-06-27 06:37:13.421 E lock conflict on no wait transaction
2025-06-27 06:37:13.421 E -unsuccessful metadata update
2025-06-27 06:37:13.421 E - -object VIEW "V_TEST" is in use
2025-06-27 06:37:13.421 E + -object VIEW "PUBLIC"."V_TEST" is in use
2025-06-27 06:37:13.422 E (335544345, 335544351, 335544453)
2025-06-27 06:37:13.422 E SNAPSHOT drop table test2
2025-06-27 06:37:13.422 E lock conflict on no wait transaction
2025-06-27 06:37:13.422 E -unsuccessful metadata update
2025-06-27 06:37:13.422 E - -object TABLE "TEST2" is in use
2025-06-27 06:37:13.422 E + -object TABLE "PUBLIC"."TEST2" is in use
2025-06-27 06:37:13.422 E (335544345, 335544351, 335544453)
2025-06-27 06:37:13.422 E SNAPSHOT drop index test1_id
2025-06-27 06:37:13.422 E lock conflict on no wait transaction
2025-06-27 06:37:13.422 E -unsuccessful metadata update
2025-06-27 06:37:13.422 E - -object INDEX "TEST1_ID" is in use
2025-06-27 06:37:13.422 E + -object INDEX "PUBLIC"."TEST1_ID" is in use
2025-06-27 06:37:13.423 E (335544345, 335544351, 335544453)
2025-06-27 06:37:13.423 E SNAPSHOT drop index test2_x
2025-06-27 06:37:13.423 E lock conflict on no wait transaction
2025-06-27 06:37:13.423 E -unsuccessful metadata update
2025-06-27 06:37:13.423 E - -object INDEX "TEST2_X" is in use
2025-06-27 06:37:13.423 E + -object INDEX "PUBLIC"."TEST2_X" is in use
2025-06-27 06:37:13.423 E (335544345, 335544351, 335544453)
2025-06-27 06:37:13.423 E SERIALIZABLE drop procedure sp_test
2025-06-27 06:37:13.423 E lock conflict on no wait transaction
2025-06-27 06:37:13.423 E -unsuccessful metadata update
2025-06-27 06:37:13.423 E - -object PROCEDURE "SP_TEST" is in use
2025-06-27 06:37:13.423 E + -object PROCEDURE "PUBLIC"."SP_TEST" is in use
2025-06-27 06:37:13.423 E (335544345, 335544351, 335544453)
2025-06-27 06:37:13.423 E SERIALIZABLE drop procedure sp_worker
2025-06-27 06:37:13.424 E lock conflict on no wait transaction
2025-06-27 06:37:13.424 E -unsuccessful metadata update
2025-06-27 06:37:13.424 E - -object PROCEDURE "SP_WORKER" is in use
2025-06-27 06:37:13.424 E + -object PROCEDURE "PUBLIC"."SP_WORKER" is in use
2025-06-27 06:37:13.424 E (335544345, 335544351, 335544453)
2025-06-27 06:37:13.424 E SERIALIZABLE drop function fn_worker
2025-06-27 06:37:13.424 E lock conflict on no wait transaction
2025-06-27 06:37:13.424 E -unsuccessful metadata update
2025-06-27 06:37:13.424 E - -object FUNCTION "FN_WORKER" is in use
2025-06-27 06:37:13.424 E + -object FUNCTION "PUBLIC"."FN_WORKER" is in use
2025-06-27 06:37:13.424 E (335544345, 335544351, 335544453)
2025-06-27 06:37:13.424 E SERIALIZABLE drop view v_test
2025-06-27 06:37:13.424 E lock conflict on no wait transaction
2025-06-27 06:37:13.424 E -unsuccessful metadata update
2025-06-27 06:37:13.425 E - -object VIEW "V_TEST" is in use
2025-06-27 06:37:13.425 E + -object VIEW "PUBLIC"."V_TEST" is in use
2025-06-27 06:37:13.425 E (335544345, 335544351, 335544453)
2025-06-27 06:37:13.425 E SERIALIZABLE drop table test2
2025-06-27 06:37:13.425 E lock conflict on no wait transaction
2025-06-27 06:37:13.425 E -unsuccessful metadata update
2025-06-27 06:37:13.425 E - -object TABLE "TEST2" is in use
2025-06-27 06:37:13.425 E + -object TABLE "PUBLIC"."TEST2" is in use
2025-06-27 06:37:13.425 E (335544345, 335544351, 335544453)
2025-06-27 06:37:13.425 E SERIALIZABLE drop index test1_id
2025-06-27 06:37:13.425 E lock conflict on no wait transaction
2025-06-27 06:37:13.425 E -unsuccessful metadata update
2025-06-27 06:37:13.425 E - -object INDEX "TEST1_ID" is in use
2025-06-27 06:37:13.425 E + -object INDEX "PUBLIC"."TEST1_ID" is in use
2025-06-27 06:37:13.426 E (335544345, 335544351, 335544453)
2025-06-27 06:37:13.426 E SERIALIZABLE drop index test2_x
2025-06-27 06:37:13.426 E lock conflict on no wait transaction
2025-06-27 06:37:13.426 E -unsuccessful metadata update
2025-06-27 06:37:13.426 E - -object INDEX "TEST2_X" is in use
2025-06-27 06:37:13.426 E + -object INDEX "PUBLIC"."TEST2_X" is in use
2025-06-27 06:37:13.426 E (335544345, 335544351, 335544453)
2025-06-27 06:37:13.426 E READ_COMMITTED_READ_CONSISTENCY drop procedure sp_test
2025-06-27 06:37:13.426 E lock conflict on no wait transaction
2025-06-27 06:37:13.426 E -unsuccessful metadata update
2025-06-27 06:37:13.426 E - -object PROCEDURE "SP_TEST" is in use
2025-06-27 06:37:13.426 E + -object PROCEDURE "PUBLIC"."SP_TEST" is in use
2025-06-27 06:37:13.427 E (335544345, 335544351, 335544453)
2025-06-27 06:37:13.427 E READ_COMMITTED_READ_CONSISTENCY drop procedure sp_worker
2025-06-27 06:37:13.427 E lock conflict on no wait transaction
2025-06-27 06:37:13.427 E -unsuccessful metadata update
2025-06-27 06:37:13.427 E - -object PROCEDURE "SP_WORKER" is in use
2025-06-27 06:37:13.427 E + -object PROCEDURE "PUBLIC"."SP_WORKER" is in use
2025-06-27 06:37:13.427 E (335544345, 335544351, 335544453)
2025-06-27 06:37:13.427 E READ_COMMITTED_READ_CONSISTENCY drop function fn_worker
2025-06-27 06:37:13.427 E lock conflict on no wait transaction
2025-06-27 06:37:13.427 E -unsuccessful metadata update
2025-06-27 06:37:13.427 E - -object FUNCTION "FN_WORKER" is in use
2025-06-27 06:37:13.427 E + -object FUNCTION "PUBLIC"."FN_WORKER" is in use
2025-06-27 06:37:13.427 E (335544345, 335544351, 335544453)
2025-06-27 06:37:13.428 E READ_COMMITTED_READ_CONSISTENCY drop view v_test
2025-06-27 06:37:13.428 E lock conflict on no wait transaction
2025-06-27 06:37:13.428 E -unsuccessful metadata update
2025-06-27 06:37:13.428 E - -object VIEW "V_TEST" is in use
2025-06-27 06:37:13.428 E + -object VIEW "PUBLIC"."V_TEST" is in use
2025-06-27 06:37:13.428 E (335544345, 335544351, 335544453)
2025-06-27 06:37:13.428 E READ_COMMITTED_READ_CONSISTENCY drop table test2
2025-06-27 06:37:13.428 E lock conflict on no wait transaction
2025-06-27 06:37:13.428 E -unsuccessful metadata update
2025-06-27 06:37:13.428 E - -object TABLE "TEST2" is in use
2025-06-27 06:37:13.428 E + -object TABLE "PUBLIC"."TEST2" is in use
2025-06-27 06:37:13.428 E (335544345, 335544351, 335544453)
2025-06-27 06:37:13.428 E READ_COMMITTED_READ_CONSISTENCY drop index test1_id
2025-06-27 06:37:13.428 E lock conflict on no wait transaction
2025-06-27 06:37:13.429 E -unsuccessful metadata update
2025-06-27 06:37:13.429 E - -object INDEX "TEST1_ID" is in use
2025-06-27 06:37:13.429 E + -object INDEX "PUBLIC"."TEST1_ID" is in use
2025-06-27 06:37:13.429 E (335544345, 335544351, 335544453)
2025-06-27 06:37:13.429 E READ_COMMITTED_READ_CONSISTENCY drop index test2_x
2025-06-27 06:37:13.429 E lock conflict on no wait transaction
2025-06-27 06:37:13.429 E -unsuccessful metadata update
2025-06-27 06:37:13.429 E - -object INDEX "TEST2_X" is in use
2025-06-27 06:37:13.429 E + -object INDEX "PUBLIC"."TEST2_X" is in use
2025-06-27 06:37:13.429 E (335544345, 335544351, 335544453)
2025-06-27 06:37:13.429
2025-06-27 06:37:13.429 tests\bugs\core_4386_test.py:370: AssertionError
2025-06-27 06:37:13.429 ---------------------------- Captured stdout setup ----------------------------
2025-06-27 06:37:13.429 Creating db: localhost:H:\QA\temp\qa2024.tmp\fbqa\test_1837\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
|