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 05:15:06.846
2025-06-27 05:15:06.854 act = <firebird.qa.plugin.Action object at [hex]>
2025-06-27 05:15:06.863 capsys = <_pytest.capture.CaptureFixture object at [hex]>
2025-06-27 05:15:06.871
2025-06-27 05:15:06.879 @pytest.mark.version('>=4.0')
2025-06-27 05:15:06.889 def test_1(act: Action, capsys):
2025-06-27 05:15:06.896 act.isql(switches=[], input=ddl_script)
2025-06-27 05:15:06.902
2025-06-27 05:15:06.909 drop_commands = [ 'drop procedure sp_test',
2025-06-27 05:15:06.915 'drop procedure sp_worker',
2025-06-27 05:15:06.922 'drop function fn_worker',
2025-06-27 05:15:06.928 'drop view v_test',
2025-06-27 05:15:06.935 'drop table test2',
2025-06-27 05:15:06.942 'drop index test1_id',
2025-06-27 05:15:06.953 'drop index test2_x'
2025-06-27 05:15:06.964 ]
2025-06-27 05:15:06.972
2025-06-27 05:15:06.979 tx_isol_lst = [ Isolation.READ_COMMITTED_NO_RECORD_VERSION,
2025-06-27 05:15:06.986 Isolation.READ_COMMITTED_RECORD_VERSION,
2025-06-27 05:15:06.995 Isolation.SNAPSHOT,
2025-06-27 05:15:07.006 Isolation.SERIALIZABLE,
2025-06-27 05:15:07.013 ]
2025-06-27 05:15:07.021 if act.is_version('>=4'):
2025-06-27 05:15:07.028 tx_isol_lst.append(Isolation.READ_COMMITTED_READ_CONSISTENCY)
2025-06-27 05:15:07.034
2025-06-27 05:15:07.041 # for any isolation mode attempt to drop object that is in use by another Tx must fail
2025-06-27 05:15:07.050 # with the same error message. We check all possible Tx isolation modes for that:
2025-06-27 05:15:07.056 for x_isol in tx_isol_lst:
2025-06-27 05:15:07.062
2025-06-27 05:15:07.067 with act.db.connect() as con1:
2025-06-27 05:15:07.072
2025-06-27 05:15:07.077 cur1 = con1.cursor()
2025-06-27 05:15:07.082 cur1.execute('select x from sp_test(21)').fetchall()
2025-06-27 05:15:07.089
2025-06-27 05:15:07.095 for cmd in drop_commands:
2025-06-27 05:15:07.100 with act.db.connect() as con2:
2025-06-27 05:15:07.105 custom_tpb = tpb(isolation = x_isol, lock_timeout=0)
2025-06-27 05:15:07.110 print(x_isol.name, cmd)
2025-06-27 05:15:07.116 tx2 = con2.transaction_manager(custom_tpb)
2025-06-27 05:15:07.121 tx2.begin()
2025-06-27 05:15:07.126 cur2 = tx2.cursor()
2025-06-27 05:15:07.137 try:
2025-06-27 05:15:07.145 cur2.execute(cmd) # this will PASS because of DDL nature
2025-06-27 05:15:07.152
2025-06-27 05:15:07.160 ##########################################################################
2025-06-27 05:15:07.165 ### We have to call commit() exactly by TRANSACTION object here. ###
2025-06-27 05:15:07.170 ### DO NOT use con2.commit() because this actually leads transaction ###
2025-06-27 05:15:07.176 ### to be 'silently rolled back', thus we will not get error messages! ###
2025-06-27 05:15:07.182 ##########################################################################
2025-06-27 05:15:07.187 tx2.commit() # <<< this lead to FAILED_COMMIT in the trace <<<
2025-06-27 05:15:07.192
2025-06-27 05:15:07.199 except Exception as e:
2025-06-27 05:15:07.208 print(e.__str__())
2025-06-27 05:15:07.218 print(e.gds_codes)
2025-06-27 05:15:07.227
2025-06-27 05:15:07.235 act.expected_stdout = f"""
2025-06-27 05:15:07.242 READ_COMMITTED_NO_RECORD_VERSION drop procedure sp_test
2025-06-27 05:15:07.255 lock conflict on no wait transaction
2025-06-27 05:15:07.262 -unsuccessful metadata update
2025-06-27 05:15:07.269 -object PROCEDURE "SP_TEST" is in use
2025-06-27 05:15:07.276 (335544345, 335544351, 335544453)
2025-06-27 05:15:07.281
2025-06-27 05:15:07.288 READ_COMMITTED_NO_RECORD_VERSION drop procedure sp_worker
2025-06-27 05:15:07.293 lock conflict on no wait transaction
2025-06-27 05:15:07.299 -unsuccessful metadata update
2025-06-27 05:15:07.304 -object PROCEDURE "SP_WORKER" is in use
2025-06-27 05:15:07.309 (335544345, 335544351, 335544453)
2025-06-27 05:15:07.314
2025-06-27 05:15:07.319 READ_COMMITTED_NO_RECORD_VERSION drop function fn_worker
2025-06-27 05:15:07.325 lock conflict on no wait transaction
2025-06-27 05:15:07.331 -unsuccessful metadata update
2025-06-27 05:15:07.337 -object FUNCTION "FN_WORKER" is in use
2025-06-27 05:15:07.343 (335544345, 335544351, 335544453)
2025-06-27 05:15:07.351
2025-06-27 05:15:07.363 READ_COMMITTED_NO_RECORD_VERSION drop view v_test
2025-06-27 05:15:07.374 lock conflict on no wait transaction
2025-06-27 05:15:07.384 -unsuccessful metadata update
2025-06-27 05:15:07.393 -object VIEW "V_TEST" is in use
2025-06-27 05:15:07.401 (335544345, 335544351, 335544453)
2025-06-27 05:15:07.408
2025-06-27 05:15:07.415 READ_COMMITTED_NO_RECORD_VERSION drop table test2
2025-06-27 05:15:07.424 lock conflict on no wait transaction
2025-06-27 05:15:07.432 -unsuccessful metadata update
2025-06-27 05:15:07.440 -object TABLE "TEST2" is in use
2025-06-27 05:15:07.448 (335544345, 335544351, 335544453)
2025-06-27 05:15:07.455
2025-06-27 05:15:07.461 READ_COMMITTED_NO_RECORD_VERSION drop index test1_id
2025-06-27 05:15:07.468 lock conflict on no wait transaction
2025-06-27 05:15:07.475 -unsuccessful metadata update
2025-06-27 05:15:07.483 -object INDEX "TEST1_ID" is in use
2025-06-27 05:15:07.494 (335544345, 335544351, 335544453)
2025-06-27 05:15:07.501
2025-06-27 05:15:07.508 READ_COMMITTED_NO_RECORD_VERSION drop index test2_x
2025-06-27 05:15:07.514 lock conflict on no wait transaction
2025-06-27 05:15:07.524 -unsuccessful metadata update
2025-06-27 05:15:07.534 -object INDEX "TEST2_X" is in use
2025-06-27 05:15:07.549 (335544345, 335544351, 335544453)
2025-06-27 05:15:07.558
2025-06-27 05:15:07.567 READ_COMMITTED_RECORD_VERSION drop procedure sp_test
2025-06-27 05:15:07.577 lock conflict on no wait transaction
2025-06-27 05:15:07.586 -unsuccessful metadata update
2025-06-27 05:15:07.592 -object PROCEDURE "SP_TEST" is in use
2025-06-27 05:15:07.598 (335544345, 335544351, 335544453)
2025-06-27 05:15:07.605
2025-06-27 05:15:07.615 READ_COMMITTED_RECORD_VERSION drop procedure sp_worker
2025-06-27 05:15:07.622 lock conflict on no wait transaction
2025-06-27 05:15:07.631 -unsuccessful metadata update
2025-06-27 05:15:07.641 -object PROCEDURE "SP_WORKER" is in use
2025-06-27 05:15:07.649 (335544345, 335544351, 335544453)
2025-06-27 05:15:07.656
2025-06-27 05:15:07.666 READ_COMMITTED_RECORD_VERSION drop function fn_worker
2025-06-27 05:15:07.675 lock conflict on no wait transaction
2025-06-27 05:15:07.683 -unsuccessful metadata update
2025-06-27 05:15:07.690 -object FUNCTION "FN_WORKER" is in use
2025-06-27 05:15:07.700 (335544345, 335544351, 335544453)
2025-06-27 05:15:07.709
2025-06-27 05:15:07.716 READ_COMMITTED_RECORD_VERSION drop view v_test
2025-06-27 05:15:07.722 lock conflict on no wait transaction
2025-06-27 05:15:07.732 -unsuccessful metadata update
2025-06-27 05:15:07.744 -object VIEW "V_TEST" is in use
2025-06-27 05:15:07.756 (335544345, 335544351, 335544453)
2025-06-27 05:15:07.767
2025-06-27 05:15:07.776 READ_COMMITTED_RECORD_VERSION drop table test2
2025-06-27 05:15:07.783 lock conflict on no wait transaction
2025-06-27 05:15:07.794 -unsuccessful metadata update
2025-06-27 05:15:07.804 -object TABLE "TEST2" is in use
2025-06-27 05:15:07.811 (335544345, 335544351, 335544453)
2025-06-27 05:15:07.819
2025-06-27 05:15:07.830 READ_COMMITTED_RECORD_VERSION drop index test1_id
2025-06-27 05:15:07.838 lock conflict on no wait transaction
2025-06-27 05:15:07.848 -unsuccessful metadata update
2025-06-27 05:15:07.859 -object INDEX "TEST1_ID" is in use
2025-06-27 05:15:07.871 (335544345, 335544351, 335544453)
2025-06-27 05:15:07.880
2025-06-27 05:15:07.888 READ_COMMITTED_RECORD_VERSION drop index test2_x
2025-06-27 05:15:07.895 lock conflict on no wait transaction
2025-06-27 05:15:07.907 -unsuccessful metadata update
2025-06-27 05:15:07.918 -object INDEX "TEST2_X" is in use
2025-06-27 05:15:07.927 (335544345, 335544351, 335544453)
2025-06-27 05:15:07.937
2025-06-27 05:15:07.948 SNAPSHOT drop procedure sp_test
2025-06-27 05:15:07.960 lock conflict on no wait transaction
2025-06-27 05:15:07.969 -unsuccessful metadata update
2025-06-27 05:15:07.977 -object PROCEDURE "SP_TEST" is in use
2025-06-27 05:15:07.983 (335544345, 335544351, 335544453)
2025-06-27 05:15:07.989
2025-06-27 05:15:07.995 SNAPSHOT drop procedure sp_worker
2025-06-27 05:15:08.001 lock conflict on no wait transaction
2025-06-27 05:15:08.010 -unsuccessful metadata update
2025-06-27 05:15:08.021 -object PROCEDURE "SP_WORKER" is in use
2025-06-27 05:15:08.031 (335544345, 335544351, 335544453)
2025-06-27 05:15:08.043
2025-06-27 05:15:08.051 SNAPSHOT drop function fn_worker
2025-06-27 05:15:08.058 lock conflict on no wait transaction
2025-06-27 05:15:08.067 -unsuccessful metadata update
2025-06-27 05:15:08.074 -object FUNCTION "FN_WORKER" is in use
2025-06-27 05:15:08.082 (335544345, 335544351, 335544453)
2025-06-27 05:15:08.093
2025-06-27 05:15:08.102 SNAPSHOT drop view v_test
2025-06-27 05:15:08.109 lock conflict on no wait transaction
2025-06-27 05:15:08.116 -unsuccessful metadata update
2025-06-27 05:15:08.122 -object VIEW "V_TEST" is in use
2025-06-27 05:15:08.133 (335544345, 335544351, 335544453)
2025-06-27 05:15:08.142
2025-06-27 05:15:08.151 SNAPSHOT drop table test2
2025-06-27 05:15:08.163 lock conflict on no wait transaction
2025-06-27 05:15:08.172 -unsuccessful metadata update
2025-06-27 05:15:08.180 -object TABLE "TEST2" is in use
2025-06-27 05:15:08.186 (335544345, 335544351, 335544453)
2025-06-27 05:15:08.192
2025-06-27 05:15:08.198 SNAPSHOT drop index test1_id
2025-06-27 05:15:08.203 lock conflict on no wait transaction
2025-06-27 05:15:08.211 -unsuccessful metadata update
2025-06-27 05:15:08.223 -object INDEX "TEST1_ID" is in use
2025-06-27 05:15:08.233 (335544345, 335544351, 335544453)
2025-06-27 05:15:08.246
2025-06-27 05:15:08.259 SNAPSHOT drop index test2_x
2025-06-27 05:15:08.269 lock conflict on no wait transaction
2025-06-27 05:15:08.279 -unsuccessful metadata update
2025-06-27 05:15:08.286 -object INDEX "TEST2_X" is in use
2025-06-27 05:15:08.298 (335544345, 335544351, 335544453)
2025-06-27 05:15:08.307
2025-06-27 05:15:08.315 SERIALIZABLE drop procedure sp_test
2025-06-27 05:15:08.328 lock conflict on no wait transaction
2025-06-27 05:15:08.337 -unsuccessful metadata update
2025-06-27 05:15:08.349 -object PROCEDURE "SP_TEST" is in use
2025-06-27 05:15:08.361 (335544345, 335544351, 335544453)
2025-06-27 05:15:08.374
2025-06-27 05:15:08.384 SERIALIZABLE drop procedure sp_worker
2025-06-27 05:15:08.393 lock conflict on no wait transaction
2025-06-27 05:15:08.401 -unsuccessful metadata update
2025-06-27 05:15:08.408 -object PROCEDURE "SP_WORKER" is in use
2025-06-27 05:15:08.413 (335544345, 335544351, 335544453)
2025-06-27 05:15:08.419
2025-06-27 05:15:08.425 SERIALIZABLE drop function fn_worker
2025-06-27 05:15:08.431 lock conflict on no wait transaction
2025-06-27 05:15:08.436 -unsuccessful metadata update
2025-06-27 05:15:08.442 -object FUNCTION "FN_WORKER" is in use
2025-06-27 05:15:08.448 (335544345, 335544351, 335544453)
2025-06-27 05:15:08.455
2025-06-27 05:15:08.466 SERIALIZABLE drop view v_test
2025-06-27 05:15:08.474 lock conflict on no wait transaction
2025-06-27 05:15:08.483 -unsuccessful metadata update
2025-06-27 05:15:08.494 -object VIEW "V_TEST" is in use
2025-06-27 05:15:08.504 (335544345, 335544351, 335544453)
2025-06-27 05:15:08.513
2025-06-27 05:15:08.521 SERIALIZABLE drop table test2
2025-06-27 05:15:08.527 lock conflict on no wait transaction
2025-06-27 05:15:08.532 -unsuccessful metadata update
2025-06-27 05:15:08.538 -object TABLE "TEST2" is in use
2025-06-27 05:15:08.543 (335544345, 335544351, 335544453)
2025-06-27 05:15:08.547
2025-06-27 05:15:08.553 SERIALIZABLE drop index test1_id
2025-06-27 05:15:08.562 lock conflict on no wait transaction
2025-06-27 05:15:08.567 -unsuccessful metadata update
2025-06-27 05:15:08.572 -object INDEX "TEST1_ID" is in use
2025-06-27 05:15:08.577 (335544345, 335544351, 335544453)
2025-06-27 05:15:08.589
2025-06-27 05:15:08.599 SERIALIZABLE drop index test2_x
2025-06-27 05:15:08.607 lock conflict on no wait transaction
2025-06-27 05:15:08.616 -unsuccessful metadata update
2025-06-27 05:15:08.623 -object INDEX "TEST2_X" is in use
2025-06-27 05:15:08.630 (335544345, 335544351, 335544453)
2025-06-27 05:15:08.636
2025-06-27 05:15:08.642 READ_COMMITTED_READ_CONSISTENCY drop procedure sp_test
2025-06-27 05:15:08.653 lock conflict on no wait transaction
2025-06-27 05:15:08.662 -unsuccessful metadata update
2025-06-27 05:15:08.672 -object PROCEDURE "SP_TEST" is in use
2025-06-27 05:15:08.683 (335544345, 335544351, 335544453)
2025-06-27 05:15:08.691
2025-06-27 05:15:08.699 READ_COMMITTED_READ_CONSISTENCY drop procedure sp_worker
2025-06-27 05:15:08.706 lock conflict on no wait transaction
2025-06-27 05:15:08.711 -unsuccessful metadata update
2025-06-27 05:15:08.717 -object PROCEDURE "SP_WORKER" is in use
2025-06-27 05:15:08.724 (335544345, 335544351, 335544453)
2025-06-27 05:15:08.730
2025-06-27 05:15:08.735 READ_COMMITTED_READ_CONSISTENCY drop function fn_worker
2025-06-27 05:15:08.741 lock conflict on no wait transaction
2025-06-27 05:15:08.745 -unsuccessful metadata update
2025-06-27 05:15:08.749 -object FUNCTION "FN_WORKER" is in use
2025-06-27 05:15:08.755 (335544345, 335544351, 335544453)
2025-06-27 05:15:08.762
2025-06-27 05:15:08.771 READ_COMMITTED_READ_CONSISTENCY drop view v_test
2025-06-27 05:15:08.779 lock conflict on no wait transaction
2025-06-27 05:15:08.786 -unsuccessful metadata update
2025-06-27 05:15:08.794 -object VIEW "V_TEST" is in use
2025-06-27 05:15:08.803 (335544345, 335544351, 335544453)
2025-06-27 05:15:08.811
2025-06-27 05:15:08.822 READ_COMMITTED_READ_CONSISTENCY drop table test2
2025-06-27 05:15:08.831 lock conflict on no wait transaction
2025-06-27 05:15:08.840 -unsuccessful metadata update
2025-06-27 05:15:08.848 -object TABLE "TEST2" is in use
2025-06-27 05:15:08.855 (335544345, 335544351, 335544453)
2025-06-27 05:15:08.863
2025-06-27 05:15:08.876 READ_COMMITTED_READ_CONSISTENCY drop index test1_id
2025-06-27 05:15:08.888 lock conflict on no wait transaction
2025-06-27 05:15:08.901 -unsuccessful metadata update
2025-06-27 05:15:08.911 -object INDEX "TEST1_ID" is in use
2025-06-27 05:15:08.919 (335544345, 335544351, 335544453)
2025-06-27 05:15:08.927
2025-06-27 05:15:08.937 READ_COMMITTED_READ_CONSISTENCY drop index test2_x
2025-06-27 05:15:08.945 lock conflict on no wait transaction
2025-06-27 05:15:08.955 -unsuccessful metadata update
2025-06-27 05:15:08.964 -object INDEX "TEST2_X" is in use
2025-06-27 05:15:08.972 (335544345, 335544351, 335544453)
2025-06-27 05:15:08.980 """
2025-06-27 05:15:08.986
2025-06-27 05:15:08.996 act.stdout = capsys.readouterr().out
2025-06-27 05:15:09.008 > assert act.clean_stdout == act.clean_expected_stdout
2025-06-27 05:15:09.019 E assert
2025-06-27 05:15:09.030 E READ_COMMITTED_NO_RECORD_VERSION drop procedure sp_test
2025-06-27 05:15:09.039 E lock conflict on no wait transaction
2025-06-27 05:15:09.046 E -unsuccessful metadata update
2025-06-27 05:15:09.051 E - -object PROCEDURE "SP_TEST" is in use
2025-06-27 05:15:09.057 E + -object PROCEDURE "PUBLIC"."SP_TEST" is in use
2025-06-27 05:15:09.069 E (335544345, 335544351, 335544453)
2025-06-27 05:15:09.074 E READ_COMMITTED_NO_RECORD_VERSION drop procedure sp_worker
2025-06-27 05:15:09.085 E lock conflict on no wait transaction
2025-06-27 05:15:09.093 E -unsuccessful metadata update
2025-06-27 05:15:09.100 E - -object PROCEDURE "SP_WORKER" is in use
2025-06-27 05:15:09.107 E + -object PROCEDURE "PUBLIC"."SP_WORKER" is in use
2025-06-27 05:15:09.127 E (335544345, 335544351, 335544453)
2025-06-27 05:15:09.136 E READ_COMMITTED_NO_RECORD_VERSION drop function fn_worker
2025-06-27 05:15:09.143 E lock conflict on no wait transaction
2025-06-27 05:15:09.151 E -unsuccessful metadata update
2025-06-27 05:15:09.160 E - -object FUNCTION "FN_WORKER" is in use
2025-06-27 05:15:09.169 E + -object FUNCTION "PUBLIC"."FN_WORKER" is in use
2025-06-27 05:15:09.188 E (335544345, 335544351, 335544453)
2025-06-27 05:15:09.197 E READ_COMMITTED_NO_RECORD_VERSION drop view v_test
2025-06-27 05:15:09.203 E lock conflict on no wait transaction
2025-06-27 05:15:09.211 E -unsuccessful metadata update
2025-06-27 05:15:09.220 E - -object VIEW "V_TEST" is in use
2025-06-27 05:15:09.229 E + -object VIEW "PUBLIC"."V_TEST" is in use
2025-06-27 05:15:09.242 E (335544345, 335544351, 335544453)
2025-06-27 05:15:09.252 E READ_COMMITTED_NO_RECORD_VERSION drop table test2
2025-06-27 05:15:09.261 E lock conflict on no wait transaction
2025-06-27 05:15:09.268 E -unsuccessful metadata update
2025-06-27 05:15:09.275 E - -object TABLE "TEST2" is in use
2025-06-27 05:15:09.283 E + -object TABLE "PUBLIC"."TEST2" is in use
2025-06-27 05:15:09.306 E (335544345, 335544351, 335544453)
2025-06-27 05:15:09.317 E READ_COMMITTED_NO_RECORD_VERSION drop index test1_id
2025-06-27 05:15:09.327 E lock conflict on no wait transaction
2025-06-27 05:15:09.334 E -unsuccessful metadata update
2025-06-27 05:15:09.342 E - -object INDEX "TEST1_ID" is in use
2025-06-27 05:15:09.352 E + -object INDEX "PUBLIC"."TEST1_ID" is in use
2025-06-27 05:15:09.366 E (335544345, 335544351, 335544453)
2025-06-27 05:15:09.377 E READ_COMMITTED_NO_RECORD_VERSION drop index test2_x
2025-06-27 05:15:09.386 E lock conflict on no wait transaction
2025-06-27 05:15:09.393 E -unsuccessful metadata update
2025-06-27 05:15:09.399 E - -object INDEX "TEST2_X" is in use
2025-06-27 05:15:09.406 E + -object INDEX "PUBLIC"."TEST2_X" is in use
2025-06-27 05:15:09.425 E (335544345, 335544351, 335544453)
2025-06-27 05:15:09.434 E READ_COMMITTED_RECORD_VERSION drop procedure sp_test
2025-06-27 05:15:09.441 E lock conflict on no wait transaction
2025-06-27 05:15:09.447 E -unsuccessful metadata update
2025-06-27 05:15:09.452 E - -object PROCEDURE "SP_TEST" is in use
2025-06-27 05:15:09.458 E + -object PROCEDURE "PUBLIC"."SP_TEST" is in use
2025-06-27 05:15:09.470 E (335544345, 335544351, 335544453)
2025-06-27 05:15:09.479 E READ_COMMITTED_RECORD_VERSION drop procedure sp_worker
2025-06-27 05:15:09.489 E lock conflict on no wait transaction
2025-06-27 05:15:09.497 E -unsuccessful metadata update
2025-06-27 05:15:09.507 E - -object PROCEDURE "SP_WORKER" is in use
2025-06-27 05:15:09.517 E + -object PROCEDURE "PUBLIC"."SP_WORKER" is in use
2025-06-27 05:15:09.531 E (335544345, 335544351, 335544453)
2025-06-27 05:15:09.536 E READ_COMMITTED_RECORD_VERSION drop function fn_worker
2025-06-27 05:15:09.542 E lock conflict on no wait transaction
2025-06-27 05:15:09.547 E -unsuccessful metadata update
2025-06-27 05:15:09.553 E - -object FUNCTION "FN_WORKER" is in use
2025-06-27 05:15:09.565 E + -object FUNCTION "PUBLIC"."FN_WORKER" is in use
2025-06-27 05:15:09.588 E (335544345, 335544351, 335544453)
2025-06-27 05:15:09.596 E READ_COMMITTED_RECORD_VERSION drop view v_test
2025-06-27 05:15:09.602 E lock conflict on no wait transaction
2025-06-27 05:15:09.611 E -unsuccessful metadata update
2025-06-27 05:15:09.623 E - -object VIEW "V_TEST" is in use
2025-06-27 05:15:09.632 E + -object VIEW "PUBLIC"."V_TEST" is in use
2025-06-27 05:15:09.645 E (335544345, 335544351, 335544453)
2025-06-27 05:15:09.651 E READ_COMMITTED_RECORD_VERSION drop table test2
2025-06-27 05:15:09.656 E lock conflict on no wait transaction
2025-06-27 05:15:09.668 E -unsuccessful metadata update
2025-06-27 05:15:09.678 E - -object TABLE "TEST2" is in use
2025-06-27 05:15:09.688 E + -object TABLE "PUBLIC"."TEST2" is in use
2025-06-27 05:15:09.711 E (335544345, 335544351, 335544453)
2025-06-27 05:15:09.722 E READ_COMMITTED_RECORD_VERSION drop index test1_id
2025-06-27 05:15:09.734 E lock conflict on no wait transaction
2025-06-27 05:15:09.744 E -unsuccessful metadata update
2025-06-27 05:15:09.757 E - -object INDEX "TEST1_ID" is in use
2025-06-27 05:15:09.768 E + -object INDEX "PUBLIC"."TEST1_ID" is in use
2025-06-27 05:15:09.785 E (335544345, 335544351, 335544453)
2025-06-27 05:15:09.795 E READ_COMMITTED_RECORD_VERSION drop index test2_x
2025-06-27 05:15:09.803 E lock conflict on no wait transaction
2025-06-27 05:15:09.813 E -unsuccessful metadata update
2025-06-27 05:15:09.825 E - -object INDEX "TEST2_X" is in use
2025-06-27 05:15:09.835 E + -object INDEX "PUBLIC"."TEST2_X" is in use
2025-06-27 05:15:09.858 E (335544345, 335544351, 335544453)
2025-06-27 05:15:09.870 E SNAPSHOT drop procedure sp_test
2025-06-27 05:15:09.881 E lock conflict on no wait transaction
2025-06-27 05:15:09.893 E -unsuccessful metadata update
2025-06-27 05:15:09.904 E - -object PROCEDURE "SP_TEST" is in use
2025-06-27 05:15:09.913 E + -object PROCEDURE "PUBLIC"."SP_TEST" is in use
2025-06-27 05:15:09.927 E (335544345, 335544351, 335544453)
2025-06-27 05:15:09.934 E SNAPSHOT drop procedure sp_worker
2025-06-27 05:15:09.940 E lock conflict on no wait transaction
2025-06-27 05:15:09.947 E -unsuccessful metadata update
2025-06-27 05:15:09.952 E - -object PROCEDURE "SP_WORKER" is in use
2025-06-27 05:15:09.958 E + -object PROCEDURE "PUBLIC"."SP_WORKER" is in use
2025-06-27 05:15:09.970 E (335544345, 335544351, 335544453)
2025-06-27 05:15:09.980 E SNAPSHOT drop function fn_worker
2025-06-27 05:15:09.991 E lock conflict on no wait transaction
2025-06-27 05:15:10.002 E -unsuccessful metadata update
2025-06-27 05:15:10.013 E - -object FUNCTION "FN_WORKER" is in use
2025-06-27 05:15:10.026 E + -object FUNCTION "PUBLIC"."FN_WORKER" is in use
2025-06-27 05:15:10.043 E (335544345, 335544351, 335544453)
2025-06-27 05:15:10.054 E SNAPSHOT drop view v_test
2025-06-27 05:15:10.064 E lock conflict on no wait transaction
2025-06-27 05:15:10.073 E -unsuccessful metadata update
2025-06-27 05:15:10.085 E - -object VIEW "V_TEST" is in use
2025-06-27 05:15:10.094 E + -object VIEW "PUBLIC"."V_TEST" is in use
2025-06-27 05:15:10.114 E (335544345, 335544351, 335544453)
2025-06-27 05:15:10.122 E SNAPSHOT drop table test2
2025-06-27 05:15:10.134 E lock conflict on no wait transaction
2025-06-27 05:15:10.147 E -unsuccessful metadata update
2025-06-27 05:15:10.157 E - -object TABLE "TEST2" is in use
2025-06-27 05:15:10.164 E + -object TABLE "PUBLIC"."TEST2" is in use
2025-06-27 05:15:10.177 E (335544345, 335544351, 335544453)
2025-06-27 05:15:10.185 E SNAPSHOT drop index test1_id
2025-06-27 05:15:10.190 E lock conflict on no wait transaction
2025-06-27 05:15:10.194 E -unsuccessful metadata update
2025-06-27 05:15:10.199 E - -object INDEX "TEST1_ID" is in use
2025-06-27 05:15:10.205 E + -object INDEX "PUBLIC"."TEST1_ID" is in use
2025-06-27 05:15:10.217 E (335544345, 335544351, 335544453)
2025-06-27 05:15:10.223 E SNAPSHOT drop index test2_x
2025-06-27 05:15:10.227 E lock conflict on no wait transaction
2025-06-27 05:15:10.232 E -unsuccessful metadata update
2025-06-27 05:15:10.238 E - -object INDEX "TEST2_X" is in use
2025-06-27 05:15:10.245 E + -object INDEX "PUBLIC"."TEST2_X" is in use
2025-06-27 05:15:10.258 E (335544345, 335544351, 335544453)
2025-06-27 05:15:10.265 E SERIALIZABLE drop procedure sp_test
2025-06-27 05:15:10.278 E lock conflict on no wait transaction
2025-06-27 05:15:10.288 E -unsuccessful metadata update
2025-06-27 05:15:10.296 E - -object PROCEDURE "SP_TEST" is in use
2025-06-27 05:15:10.303 E + -object PROCEDURE "PUBLIC"."SP_TEST" is in use
2025-06-27 05:15:10.315 E (335544345, 335544351, 335544453)
2025-06-27 05:15:10.323 E SERIALIZABLE drop procedure sp_worker
2025-06-27 05:15:10.329 E lock conflict on no wait transaction
2025-06-27 05:15:10.334 E -unsuccessful metadata update
2025-06-27 05:15:10.340 E - -object PROCEDURE "SP_WORKER" is in use
2025-06-27 05:15:10.346 E + -object PROCEDURE "PUBLIC"."SP_WORKER" is in use
2025-06-27 05:15:10.369 E (335544345, 335544351, 335544453)
2025-06-27 05:15:10.380 E SERIALIZABLE drop function fn_worker
2025-06-27 05:15:10.389 E lock conflict on no wait transaction
2025-06-27 05:15:10.397 E -unsuccessful metadata update
2025-06-27 05:15:10.405 E - -object FUNCTION "FN_WORKER" is in use
2025-06-27 05:15:10.411 E + -object FUNCTION "PUBLIC"."FN_WORKER" is in use
2025-06-27 05:15:10.426 E (335544345, 335544351, 335544453)
2025-06-27 05:15:10.437 E SERIALIZABLE drop view v_test
2025-06-27 05:15:10.448 E lock conflict on no wait transaction
2025-06-27 05:15:10.458 E -unsuccessful metadata update
2025-06-27 05:15:10.467 E - -object VIEW "V_TEST" is in use
2025-06-27 05:15:10.475 E + -object VIEW "PUBLIC"."V_TEST" is in use
2025-06-27 05:15:10.488 E (335544345, 335544351, 335544453)
2025-06-27 05:15:10.494 E SERIALIZABLE drop table test2
2025-06-27 05:15:10.500 E lock conflict on no wait transaction
2025-06-27 05:15:10.506 E -unsuccessful metadata update
2025-06-27 05:15:10.511 E - -object TABLE "TEST2" is in use
2025-06-27 05:15:10.519 E + -object TABLE "PUBLIC"."TEST2" is in use
2025-06-27 05:15:10.538 E (335544345, 335544351, 335544453)
2025-06-27 05:15:10.545 E SERIALIZABLE drop index test1_id
2025-06-27 05:15:10.551 E lock conflict on no wait transaction
2025-06-27 05:15:10.557 E -unsuccessful metadata update
2025-06-27 05:15:10.562 E - -object INDEX "TEST1_ID" is in use
2025-06-27 05:15:10.568 E + -object INDEX "PUBLIC"."TEST1_ID" is in use
2025-06-27 05:15:10.580 E (335544345, 335544351, 335544453)
2025-06-27 05:15:10.586 E SERIALIZABLE drop index test2_x
2025-06-27 05:15:10.596 E lock conflict on no wait transaction
2025-06-27 05:15:10.608 E -unsuccessful metadata update
2025-06-27 05:15:10.618 E - -object INDEX "TEST2_X" is in use
2025-06-27 05:15:10.626 E + -object INDEX "PUBLIC"."TEST2_X" is in use
2025-06-27 05:15:10.647 E (335544345, 335544351, 335544453)
2025-06-27 05:15:10.655 E READ_COMMITTED_READ_CONSISTENCY drop procedure sp_test
2025-06-27 05:15:10.663 E lock conflict on no wait transaction
2025-06-27 05:15:10.669 E -unsuccessful metadata update
2025-06-27 05:15:10.676 E - -object PROCEDURE "SP_TEST" is in use
2025-06-27 05:15:10.682 E + -object PROCEDURE "PUBLIC"."SP_TEST" is in use
2025-06-27 05:15:10.697 E (335544345, 335544351, 335544453)
2025-06-27 05:15:10.706 E READ_COMMITTED_READ_CONSISTENCY drop procedure sp_worker
2025-06-27 05:15:10.713 E lock conflict on no wait transaction
2025-06-27 05:15:10.723 E -unsuccessful metadata update
2025-06-27 05:15:10.736 E - -object PROCEDURE "SP_WORKER" is in use
2025-06-27 05:15:10.745 E + -object PROCEDURE "PUBLIC"."SP_WORKER" is in use
2025-06-27 05:15:10.759 E (335544345, 335544351, 335544453)
2025-06-27 05:15:10.766 E READ_COMMITTED_READ_CONSISTENCY drop function fn_worker
2025-06-27 05:15:10.777 E lock conflict on no wait transaction
2025-06-27 05:15:10.786 E -unsuccessful metadata update
2025-06-27 05:15:10.793 E - -object FUNCTION "FN_WORKER" is in use
2025-06-27 05:15:10.806 E + -object FUNCTION "PUBLIC"."FN_WORKER" is in use
2025-06-27 05:15:10.828 E (335544345, 335544351, 335544453)
2025-06-27 05:15:10.837 E READ_COMMITTED_READ_CONSISTENCY drop view v_test
2025-06-27 05:15:10.845 E lock conflict on no wait transaction
2025-06-27 05:15:10.856 E -unsuccessful metadata update
2025-06-27 05:15:10.865 E - -object VIEW "V_TEST" is in use
2025-06-27 05:15:10.873 E + -object VIEW "PUBLIC"."V_TEST" is in use
2025-06-27 05:15:10.885 E (335544345, 335544351, 335544453)
2025-06-27 05:15:10.891 E READ_COMMITTED_READ_CONSISTENCY drop table test2
2025-06-27 05:15:10.897 E lock conflict on no wait transaction
2025-06-27 05:15:10.903 E -unsuccessful metadata update
2025-06-27 05:15:10.911 E - -object TABLE "TEST2" is in use
2025-06-27 05:15:10.923 E + -object TABLE "PUBLIC"."TEST2" is in use
2025-06-27 05:15:10.936 E (335544345, 335544351, 335544453)
2025-06-27 05:15:10.941 E READ_COMMITTED_READ_CONSISTENCY drop index test1_id
2025-06-27 05:15:10.947 E lock conflict on no wait transaction
2025-06-27 05:15:10.952 E -unsuccessful metadata update
2025-06-27 05:15:10.958 E - -object INDEX "TEST1_ID" is in use
2025-06-27 05:15:10.964 E + -object INDEX "PUBLIC"."TEST1_ID" is in use
2025-06-27 05:15:10.981 E (335544345, 335544351, 335544453)
2025-06-27 05:15:10.990 E READ_COMMITTED_READ_CONSISTENCY drop index test2_x
2025-06-27 05:15:10.997 E lock conflict on no wait transaction
2025-06-27 05:15:11.004 E -unsuccessful metadata update
2025-06-27 05:15:11.010 E - -object INDEX "TEST2_X" is in use
2025-06-27 05:15:11.016 E + -object INDEX "PUBLIC"."TEST2_X" is in use
2025-06-27 05:15:11.032 E (335544345, 335544351, 335544453)
2025-06-27 05:15:11.042
2025-06-27 05:15:11.050 tests/bugs/core_4386_test.py:370: AssertionError
2025-06-27 05:15:11.057 ---------------------------- Captured stdout setup -----------------------------
2025-06-27 05:15:11.066 Creating db: localhost:/var/tmp/qa_2024/test_1836/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
|