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 05:31:48.666
2025-06-29 05:31:48.678 act = <firebird.qa.plugin.Action object at [hex]>
2025-06-29 05:31:48.687 capsys = <_pytest.capture.CaptureFixture object at [hex]>
2025-06-29 05:31:48.694
2025-06-29 05:31:48.706 @pytest.mark.version('>=4.0')
2025-06-29 05:31:48.716 def test_1(act: Action, capsys):
2025-06-29 05:31:48.725 act.isql(switches=[], input=ddl_script)
2025-06-29 05:31:48.732
2025-06-29 05:31:48.741 drop_commands = [ 'drop procedure sp_test',
2025-06-29 05:31:48.754 'drop procedure sp_worker',
2025-06-29 05:31:48.764 'drop function fn_worker',
2025-06-29 05:31:48.774 'drop view v_test',
2025-06-29 05:31:48.786 'drop table test2',
2025-06-29 05:31:48.796 'drop index test1_id',
2025-06-29 05:31:48.804 'drop index test2_x'
2025-06-29 05:31:48.810 ]
2025-06-29 05:31:48.817
2025-06-29 05:31:48.823 tx_isol_lst = [ Isolation.READ_COMMITTED_NO_RECORD_VERSION,
2025-06-29 05:31:48.830 Isolation.READ_COMMITTED_RECORD_VERSION,
2025-06-29 05:31:48.836 Isolation.SNAPSHOT,
2025-06-29 05:31:48.843 Isolation.SERIALIZABLE,
2025-06-29 05:31:48.849 ]
2025-06-29 05:31:48.855 if act.is_version('>=4'):
2025-06-29 05:31:48.866 tx_isol_lst.append(Isolation.READ_COMMITTED_READ_CONSISTENCY)
2025-06-29 05:31:48.879
2025-06-29 05:31:48.890 # for any isolation mode attempt to drop object that is in use by another Tx must fail
2025-06-29 05:31:48.899 # with the same error message. We check all possible Tx isolation modes for that:
2025-06-29 05:31:48.906 for x_isol in tx_isol_lst:
2025-06-29 05:31:48.913
2025-06-29 05:31:48.918 with act.db.connect() as con1:
2025-06-29 05:31:48.923
2025-06-29 05:31:48.929 cur1 = con1.cursor()
2025-06-29 05:31:48.935 cur1.execute('select x from sp_test(21)').fetchall()
2025-06-29 05:31:48.940
2025-06-29 05:31:48.945 for cmd in drop_commands:
2025-06-29 05:31:48.951 with act.db.connect() as con2:
2025-06-29 05:31:48.956 custom_tpb = tpb(isolation = x_isol, lock_timeout=0)
2025-06-29 05:31:48.961 print(x_isol.name, cmd)
2025-06-29 05:31:48.968 tx2 = con2.transaction_manager(custom_tpb)
2025-06-29 05:31:48.973 tx2.begin()
2025-06-29 05:31:48.978 cur2 = tx2.cursor()
2025-06-29 05:31:48.983 try:
2025-06-29 05:31:48.989 cur2.execute(cmd) # this will PASS because of DDL nature
2025-06-29 05:31:48.994
2025-06-29 05:31:49.000 ##########################################################################
2025-06-29 05:31:49.007 ### We have to call commit() exactly by TRANSACTION object here. ###
2025-06-29 05:31:49.014 ### DO NOT use con2.commit() because this actually leads transaction ###
2025-06-29 05:31:49.021 ### to be 'silently rolled back', thus we will not get error messages! ###
2025-06-29 05:31:49.027 ##########################################################################
2025-06-29 05:31:49.035 tx2.commit() # <<< this lead to FAILED_COMMIT in the trace <<<
2025-06-29 05:31:49.047
2025-06-29 05:31:49.060 except Exception as e:
2025-06-29 05:31:49.074 print(e.__str__())
2025-06-29 05:31:49.083 print(e.gds_codes)
2025-06-29 05:31:49.091
2025-06-29 05:31:49.098 act.expected_stdout = f"""
2025-06-29 05:31:49.106 READ_COMMITTED_NO_RECORD_VERSION drop procedure sp_test
2025-06-29 05:31:49.114 lock conflict on no wait transaction
2025-06-29 05:31:49.121 -unsuccessful metadata update
2025-06-29 05:31:49.129 -object PROCEDURE "SP_TEST" is in use
2025-06-29 05:31:49.137 (335544345, 335544351, 335544453)
2025-06-29 05:31:49.143
2025-06-29 05:31:49.150 READ_COMMITTED_NO_RECORD_VERSION drop procedure sp_worker
2025-06-29 05:31:49.156 lock conflict on no wait transaction
2025-06-29 05:31:49.169 -unsuccessful metadata update
2025-06-29 05:31:49.183 -object PROCEDURE "SP_WORKER" is in use
2025-06-29 05:31:49.194 (335544345, 335544351, 335544453)
2025-06-29 05:31:49.206
2025-06-29 05:31:49.217 READ_COMMITTED_NO_RECORD_VERSION drop function fn_worker
2025-06-29 05:31:49.227 lock conflict on no wait transaction
2025-06-29 05:31:49.239 -unsuccessful metadata update
2025-06-29 05:31:49.247 -object FUNCTION "FN_WORKER" is in use
2025-06-29 05:31:49.255 (335544345, 335544351, 335544453)
2025-06-29 05:31:49.263
2025-06-29 05:31:49.274 READ_COMMITTED_NO_RECORD_VERSION drop view v_test
2025-06-29 05:31:49.285 lock conflict on no wait transaction
2025-06-29 05:31:49.292 -unsuccessful metadata update
2025-06-29 05:31:49.299 -object VIEW "V_TEST" is in use
2025-06-29 05:31:49.305 (335544345, 335544351, 335544453)
2025-06-29 05:31:49.311
2025-06-29 05:31:49.325 READ_COMMITTED_NO_RECORD_VERSION drop table test2
2025-06-29 05:31:49.336 lock conflict on no wait transaction
2025-06-29 05:31:49.344 -unsuccessful metadata update
2025-06-29 05:31:49.352 -object TABLE "TEST2" is in use
2025-06-29 05:31:49.360 (335544345, 335544351, 335544453)
2025-06-29 05:31:49.369
2025-06-29 05:31:49.376 READ_COMMITTED_NO_RECORD_VERSION drop index test1_id
2025-06-29 05:31:49.383 lock conflict on no wait transaction
2025-06-29 05:31:49.392 -unsuccessful metadata update
2025-06-29 05:31:49.402 -object INDEX "TEST1_ID" is in use
2025-06-29 05:31:49.413 (335544345, 335544351, 335544453)
2025-06-29 05:31:49.423
2025-06-29 05:31:49.434 READ_COMMITTED_NO_RECORD_VERSION drop index test2_x
2025-06-29 05:31:49.447 lock conflict on no wait transaction
2025-06-29 05:31:49.458 -unsuccessful metadata update
2025-06-29 05:31:49.467 -object INDEX "TEST2_X" is in use
2025-06-29 05:31:49.474 (335544345, 335544351, 335544453)
2025-06-29 05:31:49.482
2025-06-29 05:31:49.491 READ_COMMITTED_RECORD_VERSION drop procedure sp_test
2025-06-29 05:31:49.498 lock conflict on no wait transaction
2025-06-29 05:31:49.505 -unsuccessful metadata update
2025-06-29 05:31:49.512 -object PROCEDURE "SP_TEST" is in use
2025-06-29 05:31:49.519 (335544345, 335544351, 335544453)
2025-06-29 05:31:49.527
2025-06-29 05:31:49.536 READ_COMMITTED_RECORD_VERSION drop procedure sp_worker
2025-06-29 05:31:49.543 lock conflict on no wait transaction
2025-06-29 05:31:49.551 -unsuccessful metadata update
2025-06-29 05:31:49.560 -object PROCEDURE "SP_WORKER" is in use
2025-06-29 05:31:49.571 (335544345, 335544351, 335544453)
2025-06-29 05:31:49.581
2025-06-29 05:31:49.587 READ_COMMITTED_RECORD_VERSION drop function fn_worker
2025-06-29 05:31:49.596 lock conflict on no wait transaction
2025-06-29 05:31:49.606 -unsuccessful metadata update
2025-06-29 05:31:49.613 -object FUNCTION "FN_WORKER" is in use
2025-06-29 05:31:49.620 (335544345, 335544351, 335544453)
2025-06-29 05:31:49.628
2025-06-29 05:31:49.636 READ_COMMITTED_RECORD_VERSION drop view v_test
2025-06-29 05:31:49.644 lock conflict on no wait transaction
2025-06-29 05:31:49.652 -unsuccessful metadata update
2025-06-29 05:31:49.660 -object VIEW "V_TEST" is in use
2025-06-29 05:31:49.667 (335544345, 335544351, 335544453)
2025-06-29 05:31:49.675
2025-06-29 05:31:49.683 READ_COMMITTED_RECORD_VERSION drop table test2
2025-06-29 05:31:49.691 lock conflict on no wait transaction
2025-06-29 05:31:49.698 -unsuccessful metadata update
2025-06-29 05:31:49.710 -object TABLE "TEST2" is in use
2025-06-29 05:31:49.720 (335544345, 335544351, 335544453)
2025-06-29 05:31:49.728
2025-06-29 05:31:49.735 READ_COMMITTED_RECORD_VERSION drop index test1_id
2025-06-29 05:31:49.742 lock conflict on no wait transaction
2025-06-29 05:31:49.748 -unsuccessful metadata update
2025-06-29 05:31:49.755 -object INDEX "TEST1_ID" is in use
2025-06-29 05:31:49.762 (335544345, 335544351, 335544453)
2025-06-29 05:31:49.775
2025-06-29 05:31:49.785 READ_COMMITTED_RECORD_VERSION drop index test2_x
2025-06-29 05:31:49.795 lock conflict on no wait transaction
2025-06-29 05:31:49.807 -unsuccessful metadata update
2025-06-29 05:31:49.818 -object INDEX "TEST2_X" is in use
2025-06-29 05:31:49.830 (335544345, 335544351, 335544453)
2025-06-29 05:31:49.841
2025-06-29 05:31:49.851 SNAPSHOT drop procedure sp_test
2025-06-29 05:31:49.864 lock conflict on no wait transaction
2025-06-29 05:31:49.874 -unsuccessful metadata update
2025-06-29 05:31:49.887 -object PROCEDURE "SP_TEST" is in use
2025-06-29 05:31:49.900 (335544345, 335544351, 335544453)
2025-06-29 05:31:49.909
2025-06-29 05:31:49.923 SNAPSHOT drop procedure sp_worker
2025-06-29 05:31:49.935 lock conflict on no wait transaction
2025-06-29 05:31:49.944 -unsuccessful metadata update
2025-06-29 05:31:49.951 -object PROCEDURE "SP_WORKER" is in use
2025-06-29 05:31:49.957 (335544345, 335544351, 335544453)
2025-06-29 05:31:49.962
2025-06-29 05:31:49.966 SNAPSHOT drop function fn_worker
2025-06-29 05:31:49.971 lock conflict on no wait transaction
2025-06-29 05:31:49.976 -unsuccessful metadata update
2025-06-29 05:31:49.981 -object FUNCTION "FN_WORKER" is in use
2025-06-29 05:31:49.986 (335544345, 335544351, 335544453)
2025-06-29 05:31:49.992
2025-06-29 05:31:49.999 SNAPSHOT drop view v_test
2025-06-29 05:31:50.010 lock conflict on no wait transaction
2025-06-29 05:31:50.018 -unsuccessful metadata update
2025-06-29 05:31:50.027 -object VIEW "V_TEST" is in use
2025-06-29 05:31:50.038 (335544345, 335544351, 335544453)
2025-06-29 05:31:50.050
2025-06-29 05:31:50.059 SNAPSHOT drop table test2
2025-06-29 05:31:50.067 lock conflict on no wait transaction
2025-06-29 05:31:50.073 -unsuccessful metadata update
2025-06-29 05:31:50.079 -object TABLE "TEST2" is in use
2025-06-29 05:31:50.085 (335544345, 335544351, 335544453)
2025-06-29 05:31:50.090
2025-06-29 05:31:50.104 SNAPSHOT drop index test1_id
2025-06-29 05:31:50.111 lock conflict on no wait transaction
2025-06-29 05:31:50.117 -unsuccessful metadata update
2025-06-29 05:31:50.123 -object INDEX "TEST1_ID" is in use
2025-06-29 05:31:50.129 (335544345, 335544351, 335544453)
2025-06-29 05:31:50.135
2025-06-29 05:31:50.146 SNAPSHOT drop index test2_x
2025-06-29 05:31:50.157 lock conflict on no wait transaction
2025-06-29 05:31:50.170 -unsuccessful metadata update
2025-06-29 05:31:50.178 -object INDEX "TEST2_X" is in use
2025-06-29 05:31:50.192 (335544345, 335544351, 335544453)
2025-06-29 05:31:50.204
2025-06-29 05:31:50.218 SERIALIZABLE drop procedure sp_test
2025-06-29 05:31:50.227 lock conflict on no wait transaction
2025-06-29 05:31:50.234 -unsuccessful metadata update
2025-06-29 05:31:50.244 -object PROCEDURE "SP_TEST" is in use
2025-06-29 05:31:50.252 (335544345, 335544351, 335544453)
2025-06-29 05:31:50.259
2025-06-29 05:31:50.267 SERIALIZABLE drop procedure sp_worker
2025-06-29 05:31:50.275 lock conflict on no wait transaction
2025-06-29 05:31:50.282 -unsuccessful metadata update
2025-06-29 05:31:50.291 -object PROCEDURE "SP_WORKER" is in use
2025-06-29 05:31:50.301 (335544345, 335544351, 335544453)
2025-06-29 05:31:50.310
2025-06-29 05:31:50.316 SERIALIZABLE drop function fn_worker
2025-06-29 05:31:50.322 lock conflict on no wait transaction
2025-06-29 05:31:50.331 -unsuccessful metadata update
2025-06-29 05:31:50.344 -object FUNCTION "FN_WORKER" is in use
2025-06-29 05:31:50.352 (335544345, 335544351, 335544453)
2025-06-29 05:31:50.359
2025-06-29 05:31:50.369 SERIALIZABLE drop view v_test
2025-06-29 05:31:50.381 lock conflict on no wait transaction
2025-06-29 05:31:50.391 -unsuccessful metadata update
2025-06-29 05:31:50.399 -object VIEW "V_TEST" is in use
2025-06-29 05:31:50.406 (335544345, 335544351, 335544453)
2025-06-29 05:31:50.413
2025-06-29 05:31:50.419 SERIALIZABLE drop table test2
2025-06-29 05:31:50.435 lock conflict on no wait transaction
2025-06-29 05:31:50.450 -unsuccessful metadata update
2025-06-29 05:31:50.461 -object TABLE "TEST2" is in use
2025-06-29 05:31:50.474 (335544345, 335544351, 335544453)
2025-06-29 05:31:50.485
2025-06-29 05:31:50.499 SERIALIZABLE drop index test1_id
2025-06-29 05:31:50.514 lock conflict on no wait transaction
2025-06-29 05:31:50.525 -unsuccessful metadata update
2025-06-29 05:31:50.533 -object INDEX "TEST1_ID" is in use
2025-06-29 05:31:50.540 (335544345, 335544351, 335544453)
2025-06-29 05:31:50.557
2025-06-29 05:31:50.568 SERIALIZABLE drop index test2_x
2025-06-29 05:31:50.575 lock conflict on no wait transaction
2025-06-29 05:31:50.581 -unsuccessful metadata update
2025-06-29 05:31:50.587 -object INDEX "TEST2_X" is in use
2025-06-29 05:31:50.592 (335544345, 335544351, 335544453)
2025-06-29 05:31:50.597
2025-06-29 05:31:50.602 READ_COMMITTED_READ_CONSISTENCY drop procedure sp_test
2025-06-29 05:31:50.611 lock conflict on no wait transaction
2025-06-29 05:31:50.618 -unsuccessful metadata update
2025-06-29 05:31:50.625 -object PROCEDURE "SP_TEST" is in use
2025-06-29 05:31:50.630 (335544345, 335544351, 335544453)
2025-06-29 05:31:50.637
2025-06-29 05:31:50.650 READ_COMMITTED_READ_CONSISTENCY drop procedure sp_worker
2025-06-29 05:31:50.662 lock conflict on no wait transaction
2025-06-29 05:31:50.674 -unsuccessful metadata update
2025-06-29 05:31:50.684 -object PROCEDURE "SP_WORKER" is in use
2025-06-29 05:31:50.692 (335544345, 335544351, 335544453)
2025-06-29 05:31:50.699
2025-06-29 05:31:50.706 READ_COMMITTED_READ_CONSISTENCY drop function fn_worker
2025-06-29 05:31:50.721 lock conflict on no wait transaction
2025-06-29 05:31:50.734 -unsuccessful metadata update
2025-06-29 05:31:50.744 -object FUNCTION "FN_WORKER" is in use
2025-06-29 05:31:50.755 (335544345, 335544351, 335544453)
2025-06-29 05:31:50.764
2025-06-29 05:31:50.773 READ_COMMITTED_READ_CONSISTENCY drop view v_test
2025-06-29 05:31:50.781 lock conflict on no wait transaction
2025-06-29 05:31:50.789 -unsuccessful metadata update
2025-06-29 05:31:50.795 -object VIEW "V_TEST" is in use
2025-06-29 05:31:50.802 (335544345, 335544351, 335544453)
2025-06-29 05:31:50.808
2025-06-29 05:31:50.815 READ_COMMITTED_READ_CONSISTENCY drop table test2
2025-06-29 05:31:50.823 lock conflict on no wait transaction
2025-06-29 05:31:50.835 -unsuccessful metadata update
2025-06-29 05:31:50.843 -object TABLE "TEST2" is in use
2025-06-29 05:31:50.851 (335544345, 335544351, 335544453)
2025-06-29 05:31:50.860
2025-06-29 05:31:50.871 READ_COMMITTED_READ_CONSISTENCY drop index test1_id
2025-06-29 05:31:50.883 lock conflict on no wait transaction
2025-06-29 05:31:50.894 -unsuccessful metadata update
2025-06-29 05:31:50.903 -object INDEX "TEST1_ID" is in use
2025-06-29 05:31:50.913 (335544345, 335544351, 335544453)
2025-06-29 05:31:50.925
2025-06-29 05:31:50.935 READ_COMMITTED_READ_CONSISTENCY drop index test2_x
2025-06-29 05:31:50.947 lock conflict on no wait transaction
2025-06-29 05:31:50.956 -unsuccessful metadata update
2025-06-29 05:31:50.964 -object INDEX "TEST2_X" is in use
2025-06-29 05:31:50.977 (335544345, 335544351, 335544453)
2025-06-29 05:31:50.988 """
2025-06-29 05:31:51.000
2025-06-29 05:31:51.012 act.stdout = capsys.readouterr().out
2025-06-29 05:31:51.024 > assert act.clean_stdout == act.clean_expected_stdout
2025-06-29 05:31:51.038 E assert
2025-06-29 05:31:51.051 E READ_COMMITTED_NO_RECORD_VERSION drop procedure sp_test
2025-06-29 05:31:51.064 E lock conflict on no wait transaction
2025-06-29 05:31:51.075 E -unsuccessful metadata update
2025-06-29 05:31:51.088 E - -object PROCEDURE "SP_TEST" is in use
2025-06-29 05:31:51.096 E + -object PROCEDURE "PUBLIC"."SP_TEST" is in use
2025-06-29 05:31:51.109 E (335544345, 335544351, 335544453)
2025-06-29 05:31:51.115 E READ_COMMITTED_NO_RECORD_VERSION drop procedure sp_worker
2025-06-29 05:31:51.120 E lock conflict on no wait transaction
2025-06-29 05:31:51.126 E -unsuccessful metadata update
2025-06-29 05:31:51.131 E - -object PROCEDURE "SP_WORKER" is in use
2025-06-29 05:31:51.138 E + -object PROCEDURE "PUBLIC"."SP_WORKER" is in use
2025-06-29 05:31:51.148 E (335544345, 335544351, 335544453)
2025-06-29 05:31:51.153 E READ_COMMITTED_NO_RECORD_VERSION drop function fn_worker
2025-06-29 05:31:51.158 E lock conflict on no wait transaction
2025-06-29 05:31:51.164 E -unsuccessful metadata update
2025-06-29 05:31:51.171 E - -object FUNCTION "FN_WORKER" is in use
2025-06-29 05:31:51.178 E + -object FUNCTION "PUBLIC"."FN_WORKER" is in use
2025-06-29 05:31:51.198 E (335544345, 335544351, 335544453)
2025-06-29 05:31:51.207 E READ_COMMITTED_NO_RECORD_VERSION drop view v_test
2025-06-29 05:31:51.215 E lock conflict on no wait transaction
2025-06-29 05:31:51.221 E -unsuccessful metadata update
2025-06-29 05:31:51.226 E - -object VIEW "V_TEST" is in use
2025-06-29 05:31:51.235 E + -object VIEW "PUBLIC"."V_TEST" is in use
2025-06-29 05:31:51.257 E (335544345, 335544351, 335544453)
2025-06-29 05:31:51.266 E READ_COMMITTED_NO_RECORD_VERSION drop table test2
2025-06-29 05:31:51.273 E lock conflict on no wait transaction
2025-06-29 05:31:51.281 E -unsuccessful metadata update
2025-06-29 05:31:51.288 E - -object TABLE "TEST2" is in use
2025-06-29 05:31:51.295 E + -object TABLE "PUBLIC"."TEST2" is in use
2025-06-29 05:31:51.314 E (335544345, 335544351, 335544453)
2025-06-29 05:31:51.327 E READ_COMMITTED_NO_RECORD_VERSION drop index test1_id
2025-06-29 05:31:51.336 E lock conflict on no wait transaction
2025-06-29 05:31:51.344 E -unsuccessful metadata update
2025-06-29 05:31:51.352 E - -object INDEX "TEST1_ID" is in use
2025-06-29 05:31:51.359 E + -object INDEX "PUBLIC"."TEST1_ID" is in use
2025-06-29 05:31:51.376 E (335544345, 335544351, 335544453)
2025-06-29 05:31:51.386 E READ_COMMITTED_NO_RECORD_VERSION drop index test2_x
2025-06-29 05:31:51.398 E lock conflict on no wait transaction
2025-06-29 05:31:51.407 E -unsuccessful metadata update
2025-06-29 05:31:51.416 E - -object INDEX "TEST2_X" is in use
2025-06-29 05:31:51.423 E + -object INDEX "PUBLIC"."TEST2_X" is in use
2025-06-29 05:31:51.441 E (335544345, 335544351, 335544453)
2025-06-29 05:31:51.451 E READ_COMMITTED_RECORD_VERSION drop procedure sp_test
2025-06-29 05:31:51.463 E lock conflict on no wait transaction
2025-06-29 05:31:51.474 E -unsuccessful metadata update
2025-06-29 05:31:51.484 E - -object PROCEDURE "SP_TEST" is in use
2025-06-29 05:31:51.490 E + -object PROCEDURE "PUBLIC"."SP_TEST" is in use
2025-06-29 05:31:51.512 E (335544345, 335544351, 335544453)
2025-06-29 05:31:51.524 E READ_COMMITTED_RECORD_VERSION drop procedure sp_worker
2025-06-29 05:31:51.534 E lock conflict on no wait transaction
2025-06-29 05:31:51.541 E -unsuccessful metadata update
2025-06-29 05:31:51.551 E - -object PROCEDURE "SP_WORKER" is in use
2025-06-29 05:31:51.561 E + -object PROCEDURE "PUBLIC"."SP_WORKER" is in use
2025-06-29 05:31:51.576 E (335544345, 335544351, 335544453)
2025-06-29 05:31:51.583 E READ_COMMITTED_RECORD_VERSION drop function fn_worker
2025-06-29 05:31:51.590 E lock conflict on no wait transaction
2025-06-29 05:31:51.596 E -unsuccessful metadata update
2025-06-29 05:31:51.602 E - -object FUNCTION "FN_WORKER" is in use
2025-06-29 05:31:51.610 E + -object FUNCTION "PUBLIC"."FN_WORKER" is in use
2025-06-29 05:31:51.632 E (335544345, 335544351, 335544453)
2025-06-29 05:31:51.639 E READ_COMMITTED_RECORD_VERSION drop view v_test
2025-06-29 05:31:51.646 E lock conflict on no wait transaction
2025-06-29 05:31:51.657 E -unsuccessful metadata update
2025-06-29 05:31:51.666 E - -object VIEW "V_TEST" is in use
2025-06-29 05:31:51.676 E + -object VIEW "PUBLIC"."V_TEST" is in use
2025-06-29 05:31:51.693 E (335544345, 335544351, 335544453)
2025-06-29 05:31:51.700 E READ_COMMITTED_RECORD_VERSION drop table test2
2025-06-29 05:31:51.708 E lock conflict on no wait transaction
2025-06-29 05:31:51.715 E -unsuccessful metadata update
2025-06-29 05:31:51.723 E - -object TABLE "TEST2" is in use
2025-06-29 05:31:51.731 E + -object TABLE "PUBLIC"."TEST2" is in use
2025-06-29 05:31:51.752 E (335544345, 335544351, 335544453)
2025-06-29 05:31:51.762 E READ_COMMITTED_RECORD_VERSION drop index test1_id
2025-06-29 05:31:51.774 E lock conflict on no wait transaction
2025-06-29 05:31:51.782 E -unsuccessful metadata update
2025-06-29 05:31:51.793 E - -object INDEX "TEST1_ID" is in use
2025-06-29 05:31:51.803 E + -object INDEX "PUBLIC"."TEST1_ID" is in use
2025-06-29 05:31:51.817 E (335544345, 335544351, 335544453)
2025-06-29 05:31:51.823 E READ_COMMITTED_RECORD_VERSION drop index test2_x
2025-06-29 05:31:51.829 E lock conflict on no wait transaction
2025-06-29 05:31:51.835 E -unsuccessful metadata update
2025-06-29 05:31:51.845 E - -object INDEX "TEST2_X" is in use
2025-06-29 05:31:51.857 E + -object INDEX "PUBLIC"."TEST2_X" is in use
2025-06-29 05:31:51.880 E (335544345, 335544351, 335544453)
2025-06-29 05:31:51.888 E SNAPSHOT drop procedure sp_test
2025-06-29 05:31:51.896 E lock conflict on no wait transaction
2025-06-29 05:31:51.903 E -unsuccessful metadata update
2025-06-29 05:31:51.909 E - -object PROCEDURE "SP_TEST" is in use
2025-06-29 05:31:51.922 E + -object PROCEDURE "PUBLIC"."SP_TEST" is in use
2025-06-29 05:31:51.940 E (335544345, 335544351, 335544453)
2025-06-29 05:31:51.948 E SNAPSHOT drop procedure sp_worker
2025-06-29 05:31:51.957 E lock conflict on no wait transaction
2025-06-29 05:31:51.971 E -unsuccessful metadata update
2025-06-29 05:31:51.979 E - -object PROCEDURE "SP_WORKER" is in use
2025-06-29 05:31:51.986 E + -object PROCEDURE "PUBLIC"."SP_WORKER" is in use
2025-06-29 05:31:52.000 E (335544345, 335544351, 335544453)
2025-06-29 05:31:52.006 E SNAPSHOT drop function fn_worker
2025-06-29 05:31:52.016 E lock conflict on no wait transaction
2025-06-29 05:31:52.028 E -unsuccessful metadata update
2025-06-29 05:31:52.037 E - -object FUNCTION "FN_WORKER" is in use
2025-06-29 05:31:52.044 E + -object FUNCTION "PUBLIC"."FN_WORKER" is in use
2025-06-29 05:31:52.059 E (335544345, 335544351, 335544453)
2025-06-29 05:31:52.070 E SNAPSHOT drop view v_test
2025-06-29 05:31:52.078 E lock conflict on no wait transaction
2025-06-29 05:31:52.086 E -unsuccessful metadata update
2025-06-29 05:31:52.095 E - -object VIEW "V_TEST" is in use
2025-06-29 05:31:52.104 E + -object VIEW "PUBLIC"."V_TEST" is in use
2025-06-29 05:31:52.122 E (335544345, 335544351, 335544453)
2025-06-29 05:31:52.131 E SNAPSHOT drop table test2
2025-06-29 05:31:52.142 E lock conflict on no wait transaction
2025-06-29 05:31:52.151 E -unsuccessful metadata update
2025-06-29 05:31:52.165 E - -object TABLE "TEST2" is in use
2025-06-29 05:31:52.178 E + -object TABLE "PUBLIC"."TEST2" is in use
2025-06-29 05:31:52.193 E (335544345, 335544351, 335544453)
2025-06-29 05:31:52.199 E SNAPSHOT drop index test1_id
2025-06-29 05:31:52.206 E lock conflict on no wait transaction
2025-06-29 05:31:52.215 E -unsuccessful metadata update
2025-06-29 05:31:52.223 E - -object INDEX "TEST1_ID" is in use
2025-06-29 05:31:52.231 E + -object INDEX "PUBLIC"."TEST1_ID" is in use
2025-06-29 05:31:52.243 E (335544345, 335544351, 335544453)
2025-06-29 05:31:52.249 E SNAPSHOT drop index test2_x
2025-06-29 05:31:52.256 E lock conflict on no wait transaction
2025-06-29 05:31:52.262 E -unsuccessful metadata update
2025-06-29 05:31:52.269 E - -object INDEX "TEST2_X" is in use
2025-06-29 05:31:52.275 E + -object INDEX "PUBLIC"."TEST2_X" is in use
2025-06-29 05:31:52.287 E (335544345, 335544351, 335544453)
2025-06-29 05:31:52.294 E SERIALIZABLE drop procedure sp_test
2025-06-29 05:31:52.304 E lock conflict on no wait transaction
2025-06-29 05:31:52.316 E -unsuccessful metadata update
2025-06-29 05:31:52.330 E - -object PROCEDURE "SP_TEST" is in use
2025-06-29 05:31:52.341 E + -object PROCEDURE "PUBLIC"."SP_TEST" is in use
2025-06-29 05:31:52.356 E (335544345, 335544351, 335544453)
2025-06-29 05:31:52.363 E SERIALIZABLE drop procedure sp_worker
2025-06-29 05:31:52.370 E lock conflict on no wait transaction
2025-06-29 05:31:52.378 E -unsuccessful metadata update
2025-06-29 05:31:52.386 E - -object PROCEDURE "SP_WORKER" is in use
2025-06-29 05:31:52.396 E + -object PROCEDURE "PUBLIC"."SP_WORKER" is in use
2025-06-29 05:31:52.415 E (335544345, 335544351, 335544453)
2025-06-29 05:31:52.422 E SERIALIZABLE drop function fn_worker
2025-06-29 05:31:52.429 E lock conflict on no wait transaction
2025-06-29 05:31:52.435 E -unsuccessful metadata update
2025-06-29 05:31:52.444 E - -object FUNCTION "FN_WORKER" is in use
2025-06-29 05:31:52.455 E + -object FUNCTION "PUBLIC"."FN_WORKER" is in use
2025-06-29 05:31:52.475 E (335544345, 335544351, 335544453)
2025-06-29 05:31:52.481 E SERIALIZABLE drop view v_test
2025-06-29 05:31:52.487 E lock conflict on no wait transaction
2025-06-29 05:31:52.494 E -unsuccessful metadata update
2025-06-29 05:31:52.501 E - -object VIEW "V_TEST" is in use
2025-06-29 05:31:52.507 E + -object VIEW "PUBLIC"."V_TEST" is in use
2025-06-29 05:31:52.526 E (335544345, 335544351, 335544453)
2025-06-29 05:31:52.534 E SERIALIZABLE drop table test2
2025-06-29 05:31:52.541 E lock conflict on no wait transaction
2025-06-29 05:31:52.547 E -unsuccessful metadata update
2025-06-29 05:31:52.553 E - -object TABLE "TEST2" is in use
2025-06-29 05:31:52.560 E + -object TABLE "PUBLIC"."TEST2" is in use
2025-06-29 05:31:52.579 E (335544345, 335544351, 335544453)
2025-06-29 05:31:52.590 E SERIALIZABLE drop index test1_id
2025-06-29 05:31:52.602 E lock conflict on no wait transaction
2025-06-29 05:31:52.612 E -unsuccessful metadata update
2025-06-29 05:31:52.620 E - -object INDEX "TEST1_ID" is in use
2025-06-29 05:31:52.626 E + -object INDEX "PUBLIC"."TEST1_ID" is in use
2025-06-29 05:31:52.637 E (335544345, 335544351, 335544453)
2025-06-29 05:31:52.644 E SERIALIZABLE drop index test2_x
2025-06-29 05:31:52.652 E lock conflict on no wait transaction
2025-06-29 05:31:52.659 E -unsuccessful metadata update
2025-06-29 05:31:52.667 E - -object INDEX "TEST2_X" is in use
2025-06-29 05:31:52.675 E + -object INDEX "PUBLIC"."TEST2_X" is in use
2025-06-29 05:31:52.690 E (335544345, 335544351, 335544453)
2025-06-29 05:31:52.698 E READ_COMMITTED_READ_CONSISTENCY drop procedure sp_test
2025-06-29 05:31:52.707 E lock conflict on no wait transaction
2025-06-29 05:31:52.719 E -unsuccessful metadata update
2025-06-29 05:31:52.731 E - -object PROCEDURE "SP_TEST" is in use
2025-06-29 05:31:52.743 E + -object PROCEDURE "PUBLIC"."SP_TEST" is in use
2025-06-29 05:31:52.760 E (335544345, 335544351, 335544453)
2025-06-29 05:31:52.767 E READ_COMMITTED_READ_CONSISTENCY drop procedure sp_worker
2025-06-29 05:31:52.776 E lock conflict on no wait transaction
2025-06-29 05:31:52.786 E -unsuccessful metadata update
2025-06-29 05:31:52.798 E - -object PROCEDURE "SP_WORKER" is in use
2025-06-29 05:31:52.811 E + -object PROCEDURE "PUBLIC"."SP_WORKER" is in use
2025-06-29 05:31:52.833 E (335544345, 335544351, 335544453)
2025-06-29 05:31:52.845 E READ_COMMITTED_READ_CONSISTENCY drop function fn_worker
2025-06-29 05:31:52.855 E lock conflict on no wait transaction
2025-06-29 05:31:52.863 E -unsuccessful metadata update
2025-06-29 05:31:52.870 E - -object FUNCTION "FN_WORKER" is in use
2025-06-29 05:31:52.878 E + -object FUNCTION "PUBLIC"."FN_WORKER" is in use
2025-06-29 05:31:52.898 E (335544345, 335544351, 335544453)
2025-06-29 05:31:52.905 E READ_COMMITTED_READ_CONSISTENCY drop view v_test
2025-06-29 05:31:52.911 E lock conflict on no wait transaction
2025-06-29 05:31:52.919 E -unsuccessful metadata update
2025-06-29 05:31:52.931 E - -object VIEW "V_TEST" is in use
2025-06-29 05:31:52.940 E + -object VIEW "PUBLIC"."V_TEST" is in use
2025-06-29 05:31:52.957 E (335544345, 335544351, 335544453)
2025-06-29 05:31:52.963 E READ_COMMITTED_READ_CONSISTENCY drop table test2
2025-06-29 05:31:52.971 E lock conflict on no wait transaction
2025-06-29 05:31:52.982 E -unsuccessful metadata update
2025-06-29 05:31:52.992 E - -object TABLE "TEST2" is in use
2025-06-29 05:31:53.000 E + -object TABLE "PUBLIC"."TEST2" is in use
2025-06-29 05:31:53.020 E (335544345, 335544351, 335544453)
2025-06-29 05:31:53.027 E READ_COMMITTED_READ_CONSISTENCY drop index test1_id
2025-06-29 05:31:53.034 E lock conflict on no wait transaction
2025-06-29 05:31:53.041 E -unsuccessful metadata update
2025-06-29 05:31:53.047 E - -object INDEX "TEST1_ID" is in use
2025-06-29 05:31:53.053 E + -object INDEX "PUBLIC"."TEST1_ID" is in use
2025-06-29 05:31:53.067 E (335544345, 335544351, 335544453)
2025-06-29 05:31:53.073 E READ_COMMITTED_READ_CONSISTENCY drop index test2_x
2025-06-29 05:31:53.078 E lock conflict on no wait transaction
2025-06-29 05:31:53.084 E -unsuccessful metadata update
2025-06-29 05:31:53.090 E - -object INDEX "TEST2_X" is in use
2025-06-29 05:31:53.101 E + -object INDEX "PUBLIC"."TEST2_X" is in use
2025-06-29 05:31:53.121 E (335544345, 335544351, 335544453)
2025-06-29 05:31:53.131
2025-06-29 05:31:53.138 tests/bugs/core_4386_test.py:370: AssertionError
2025-06-29 05:31:53.146 ---------------------------- Captured stdout setup -----------------------------
2025-06-29 05:31:53.155 Creating db: localhost:/var/tmp/qa_2024/test_1840/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
|