2 @message |
assert
READ_COMMITTED_NO_RECORD_VERSION drop procedure sp_test
lock conflict on no wait transaction
-unsuccessful metadata update
- -object PROCEDURE "SP_TEST" is in use
+ -object PROCEDURE "PUBLIC"."SP_TEST" is in use
(335544345, 335544351, 335544453)
READ_COMMITTED_NO_RECORD_VERSION drop procedure sp_worker
lock conflict on no wait transaction
-unsuccessful metadata update
- -object PROCEDURE "SP_WORKER" is in use
+ -object PROCEDURE "PUBLIC"."SP_WORKER" is in use
(335544345, 335544351, 335544453)
READ_COMMITTED_NO_RECORD_VERSION drop function fn_worker
lock conflict on no wait transaction
-unsuccessful metadata update
- -object FUNCTION "FN_WORKER" is in use
+ -object FUNCTION "PUBLIC"."FN_WORKER" is in use
(335544345, 335544351, 335544453)
READ_COMMITTED_NO_RECORD_VERSION drop view v_test
lock conflict on no wait transaction
-unsuccessful metadata update
- -object VIEW "V_TEST" is in use
+ -object VIEW "PUBLIC"."V_TEST" is in use
(335544345, 335544351, 335544453)
READ_COMMITTED_NO_RECORD_VERSION drop table test2
lock conflict on no wait transaction
-unsuccessful metadata update
- -object TABLE "TEST2" is in use
+ -object TABLE "PUBLIC"."TEST2" is in use
(335544345, 335544351, 335544453)
READ_COMMITTED_NO_RECORD_VERSION drop index test1_id
lock conflict on no wait transaction
-unsuccessful metadata update
- -object INDEX "TEST1_ID" is in use
+ -object INDEX "PUBLIC"."TEST1_ID" is in use
(335544345, 335544351, 335544453)
READ_COMMITTED_NO_RECORD_VERSION drop index test2_x
lock conflict on no wait transaction
-unsuccessful metadata update
- -object INDEX "TEST2_X" is in use
+ -object INDEX "PUBLIC"."TEST2_X" is in use
(335544345, 335544351, 335544453)
READ_COMMITTED_RECORD_VERSION drop procedure sp_test
lock conflict on no wait transaction
-unsuccessful metadata update
- -object PROCEDURE "SP_TEST" is in use
+ -object PROCEDURE "PUBLIC"."SP_TEST" is in use
(335544345, 335544351, 335544453)
READ_COMMITTED_RECORD_VERSION drop procedure sp_worker
lock conflict on no wait transaction
-unsuccessful metadata update
- -object PROCEDURE "SP_WORKER" is in use
+ -object PROCEDURE "PUBLIC"."SP_WORKER" is in use
(335544345, 335544351, 335544453)
READ_COMMITTED_RECORD_VERSION drop function fn_worker
lock conflict on no wait transaction
-unsuccessful metadata update
- -object FUNCTION "FN_WORKER" is in use
+ -object FUNCTION "PUBLIC"."FN_WORKER" is in use
(335544345, 335544351, 335544453)
READ_COMMITTED_RECORD_VERSION drop view v_test
lock conflict on no wait transaction
-unsuccessful metadata update
- -object VIEW "V_TEST" is in use
+ -object VIEW "PUBLIC"."V_TEST" is in use
(335544345, 335544351, 335544453)
READ_COMMITTED_RECORD_VERSION drop table test2
lock conflict on no wait transaction
-unsuccessful metadata update
- -object TABLE "TEST2" is in use
+ -object TABLE "PUBLIC"."TEST2" is in use
(335544345, 335544351, 335544453)
READ_COMMITTED_RECORD_VERSION drop index test1_id
lock conflict on no wait transaction
-unsuccessful metadata update
- -object INDEX "TEST1_ID" is in use
+ -object INDEX "PUBLIC"."TEST1_ID" is in use
(335544345, 335544351, 335544453)
READ_COMMITTED_RECORD_VERSION drop index test2_x
lock conflict on no wait transaction
-unsuccessful metadata update
- -object INDEX "TEST2_X" is in use
+ -object INDEX "PUBLIC"."TEST2_X" is in use
(335544345, 335544351, 335544453)
SNAPSHOT drop procedure sp_test
lock conflict on no wait transaction
-unsuccessful metadata update
- -object PROCEDURE "SP_TEST" is in use
+ -object PROCEDURE "PUBLIC"."SP_TEST" is in use
(335544345, 335544351, 335544453)
SNAPSHOT drop procedure sp_worker
lock conflict on no wait transaction
-unsuccessful metadata update
- -object PROCEDURE "SP_WORKER" is in use
+ -object PROCEDURE "PUBLIC"."SP_WORKER" is in use
(335544345, 335544351, 335544453)
SNAPSHOT drop function fn_worker
lock conflict on no wait transaction
-unsuccessful metadata update
- -object FUNCTION "FN_WORKER" is in use
+ -object FUNCTION "PUBLIC"."FN_WORKER" is in use
(335544345, 335544351, 335544453)
SNAPSHOT drop view v_test
lock conflict on no wait transaction
-unsuccessful metadata update
- -object VIEW "V_TEST" is in use
+ -object VIEW "PUBLIC"."V_TEST" is in use
(335544345, 335544351, 335544453)
SNAPSHOT drop table test2
lock conflict on no wait transaction
-unsuccessful metadata update
- -object TABLE "TEST2" is in use
+ -object TABLE "PUBLIC"."TEST2" is in use
(335544345, 335544351, 335544453)
SNAPSHOT drop index test1_id
lock conflict on no wait transaction
-unsuccessful metadata update
- -object INDEX "TEST1_ID" is in use
+ -object INDEX "PUBLIC"."TEST1_ID" is in use
(335544345, 335544351, 335544453)
SNAPSHOT drop index test2_x
lock conflict on no wait transaction
-unsuccessful metadata update
- -object INDEX "TEST2_X" is in use
+ -object INDEX "PUBLIC"."TEST2_X" is in use
(335544345, 335544351, 335544453)
SERIALIZABLE drop procedure sp_test
lock conflict on no wait transaction
-unsuccessful metadata update
- -object PROCEDURE "SP_TEST" is in use
+ -object PROCEDURE "PUBLIC"."SP_TEST" is in use
(335544345, 335544351, 335544453)
SERIALIZABLE drop procedure sp_worker
lock conflict on no wait transaction
-unsuccessful metadata update
- -object PROCEDURE "SP_WORKER" is in use
+ -object PROCEDURE "PUBLIC"."SP_WORKER" is in use
(335544345, 335544351, 335544453)
SERIALIZABLE drop function fn_worker
lock conflict on no wait transaction
-unsuccessful metadata update
- -object FUNCTION "FN_WORKER" is in use
+ -object FUNCTION "PUBLIC"."FN_WORKER" is in use
(335544345, 335544351, 335544453)
SERIALIZABLE drop view v_test
lock conflict on no wait transaction
-unsuccessful metadata update
- -object VIEW "V_TEST" is in use
+ -object VIEW "PUBLIC"."V_TEST" is in use
(335544345, 335544351, 335544453)
SERIALIZABLE drop table test2
lock conflict on no wait transaction
-unsuccessful metadata update
- -object TABLE "TEST2" is in use
+ -object TABLE "PUBLIC"."TEST2" is in use
(335544345, 335544351, 335544453)
SERIALIZABLE drop index test1_id
lock conflict on no wait transaction
-unsuccessful metadata update
- -object INDEX "TEST1_ID" is in use
+ -object INDEX "PUBLIC"."TEST1_ID" is in use
(335544345, 335544351, 335544453)
SERIALIZABLE drop index test2_x
lock conflict on no wait transaction
-unsuccessful metadata update
- -object INDEX "TEST2_X" is in use
+ -object INDEX "PUBLIC"."TEST2_X" is in use
(335544345, 335544351, 335544453)
READ_COMMITTED_READ_CONSISTENCY drop procedure sp_test
lock conflict on no wait transaction
-unsuccessful metadata update
- -object PROCEDURE "SP_TEST" is in use
+ -object PROCEDURE "PUBLIC"."SP_TEST" is in use
(335544345, 335544351, 335544453)
READ_COMMITTED_READ_CONSISTENCY drop procedure sp_worker
lock conflict on no wait transaction
-unsuccessful metadata update
- -object PROCEDURE "SP_WORKER" is in use
+ -object PROCEDURE "PUBLIC"."SP_WORKER" is in use
(335544345, 335544351, 335544453)
READ_COMMITTED_READ_CONSISTENCY drop function fn_worker
lock conflict on no wait transaction
-unsuccessful metadata update
- -object FUNCTION "FN_WORKER" is in use
+ -object FUNCTION "PUBLIC"."FN_WORKER" is in use
(335544345, 335544351, 335544453)
READ_COMMITTED_READ_CONSISTENCY drop view v_test
lock conflict on no wait transaction
-unsuccessful metadata update
- -object VIEW "V_TEST" is in use
+ -object VIEW "PUBLIC"."V_TEST" is in use
(335544345, 335544351, 335544453)
READ_COMMITTED_READ_CONSISTENCY drop table test2
lock conflict on no wait transaction
-unsuccessful metadata update
- -object TABLE "TEST2" is in use
+ -object TABLE "PUBLIC"."TEST2" is in use
(335544345, 335544351, 335544453)
READ_COMMITTED_READ_CONSISTENCY drop index test1_id
lock conflict on no wait transaction
-unsuccessful metadata update
- -object INDEX "TEST1_ID" is in use
+ -object INDEX "PUBLIC"."TEST1_ID" is in use
(335544345, 335544351, 335544453)
READ_COMMITTED_READ_CONSISTENCY drop index test2_x
lock conflict on no wait transaction
-unsuccessful metadata update
- -object INDEX "TEST2_X" is in use
+ -object INDEX "PUBLIC"."TEST2_X" is in use
(335544345, 335544351, 335544453)
LOG DETAILS:
2025-06-28 05:13:53.489
2025-06-28 05:13:53.493 act = <firebird.qa.plugin.Action object at [hex]>
2025-06-28 05:13:53.497 capsys = <_pytest.capture.CaptureFixture object at [hex]>
2025-06-28 05:13:53.502
2025-06-28 05:13:53.506 @pytest.mark.version('>=4.0')
2025-06-28 05:13:53.511 def test_1(act: Action, capsys):
2025-06-28 05:13:53.515 act.isql(switches=[], input=ddl_script)
2025-06-28 05:13:53.519
2025-06-28 05:13:53.524 drop_commands = [ 'drop procedure sp_test',
2025-06-28 05:13:53.529 'drop procedure sp_worker',
2025-06-28 05:13:53.533 'drop function fn_worker',
2025-06-28 05:13:53.538 'drop view v_test',
2025-06-28 05:13:53.542 'drop table test2',
2025-06-28 05:13:53.546 'drop index test1_id',
2025-06-28 05:13:53.551 'drop index test2_x'
2025-06-28 05:13:53.555 ]
2025-06-28 05:13:53.560
2025-06-28 05:13:53.564 tx_isol_lst = [ Isolation.READ_COMMITTED_NO_RECORD_VERSION,
2025-06-28 05:13:53.569 Isolation.READ_COMMITTED_RECORD_VERSION,
2025-06-28 05:13:53.573 Isolation.SNAPSHOT,
2025-06-28 05:13:53.578 Isolation.SERIALIZABLE,
2025-06-28 05:13:53.582 ]
2025-06-28 05:13:53.587 if act.is_version('>=4'):
2025-06-28 05:13:53.591 tx_isol_lst.append(Isolation.READ_COMMITTED_READ_CONSISTENCY)
2025-06-28 05:13:53.596
2025-06-28 05:13:53.600 # for any isolation mode attempt to drop object that is in use by another Tx must fail
2025-06-28 05:13:53.605 # with the same error message. We check all possible Tx isolation modes for that:
2025-06-28 05:13:53.613 for x_isol in tx_isol_lst:
2025-06-28 05:13:53.622
2025-06-28 05:13:53.628 with act.db.connect() as con1:
2025-06-28 05:13:53.634
2025-06-28 05:13:53.640 cur1 = con1.cursor()
2025-06-28 05:13:53.648 cur1.execute('select x from sp_test(21)').fetchall()
2025-06-28 05:13:53.654
2025-06-28 05:13:53.660 for cmd in drop_commands:
2025-06-28 05:13:53.666 with act.db.connect() as con2:
2025-06-28 05:13:53.671 custom_tpb = tpb(isolation = x_isol, lock_timeout=0)
2025-06-28 05:13:53.677 print(x_isol.name, cmd)
2025-06-28 05:13:53.682 tx2 = con2.transaction_manager(custom_tpb)
2025-06-28 05:13:53.688 tx2.begin()
2025-06-28 05:13:53.694 cur2 = tx2.cursor()
2025-06-28 05:13:53.707 try:
2025-06-28 05:13:53.716 cur2.execute(cmd) # this will PASS because of DDL nature
2025-06-28 05:13:53.723
2025-06-28 05:13:53.729 ##########################################################################
2025-06-28 05:13:53.734 ### We have to call commit() exactly by TRANSACTION object here. ###
2025-06-28 05:13:53.739 ### DO NOT use con2.commit() because this actually leads transaction ###
2025-06-28 05:13:53.744 ### to be 'silently rolled back', thus we will not get error messages! ###
2025-06-28 05:13:53.749 ##########################################################################
2025-06-28 05:13:53.755 tx2.commit() # <<< this lead to FAILED_COMMIT in the trace <<<
2025-06-28 05:13:53.760
2025-06-28 05:13:53.766 except Exception as e:
2025-06-28 05:13:53.772 print(e.__str__())
2025-06-28 05:13:53.777 print(e.gds_codes)
2025-06-28 05:13:53.783
2025-06-28 05:13:53.788 act.expected_stdout = f"""
2025-06-28 05:13:53.794 READ_COMMITTED_NO_RECORD_VERSION drop procedure sp_test
2025-06-28 05:13:53.801 lock conflict on no wait transaction
2025-06-28 05:13:53.811 -unsuccessful metadata update
2025-06-28 05:13:53.821 -object PROCEDURE "SP_TEST" is in use
2025-06-28 05:13:53.834 (335544345, 335544351, 335544453)
2025-06-28 05:13:53.845
2025-06-28 05:13:53.854 READ_COMMITTED_NO_RECORD_VERSION drop procedure sp_worker
2025-06-28 05:13:53.862 lock conflict on no wait transaction
2025-06-28 05:13:53.870 -unsuccessful metadata update
2025-06-28 05:13:53.879 -object PROCEDURE "SP_WORKER" is in use
2025-06-28 05:13:53.886 (335544345, 335544351, 335544453)
2025-06-28 05:13:53.895
2025-06-28 05:13:53.902 READ_COMMITTED_NO_RECORD_VERSION drop function fn_worker
2025-06-28 05:13:53.909 lock conflict on no wait transaction
2025-06-28 05:13:53.920 -unsuccessful metadata update
2025-06-28 05:13:53.931 -object FUNCTION "FN_WORKER" is in use
2025-06-28 05:13:53.938 (335544345, 335544351, 335544453)
2025-06-28 05:13:53.947
2025-06-28 05:13:53.958 READ_COMMITTED_NO_RECORD_VERSION drop view v_test
2025-06-28 05:13:53.969 lock conflict on no wait transaction
2025-06-28 05:13:53.978 -unsuccessful metadata update
2025-06-28 05:13:53.991 -object VIEW "V_TEST" is in use
2025-06-28 05:13:54.002 (335544345, 335544351, 335544453)
2025-06-28 05:13:54.009
2025-06-28 05:13:54.015 READ_COMMITTED_NO_RECORD_VERSION drop table test2
2025-06-28 05:13:54.021 lock conflict on no wait transaction
2025-06-28 05:13:54.027 -unsuccessful metadata update
2025-06-28 05:13:54.034 -object TABLE "TEST2" is in use
2025-06-28 05:13:54.044 (335544345, 335544351, 335544453)
2025-06-28 05:13:54.053
2025-06-28 05:13:54.061 READ_COMMITTED_NO_RECORD_VERSION drop index test1_id
2025-06-28 05:13:54.067 lock conflict on no wait transaction
2025-06-28 05:13:54.072 -unsuccessful metadata update
2025-06-28 05:13:54.080 -object INDEX "TEST1_ID" is in use
2025-06-28 05:13:54.088 (335544345, 335544351, 335544453)
2025-06-28 05:13:54.093
2025-06-28 05:13:54.106 READ_COMMITTED_NO_RECORD_VERSION drop index test2_x
2025-06-28 05:13:54.117 lock conflict on no wait transaction
2025-06-28 05:13:54.126 -unsuccessful metadata update
2025-06-28 05:13:54.133 -object INDEX "TEST2_X" is in use
2025-06-28 05:13:54.139 (335544345, 335544351, 335544453)
2025-06-28 05:13:54.144
2025-06-28 05:13:54.150 READ_COMMITTED_RECORD_VERSION drop procedure sp_test
2025-06-28 05:13:54.155 lock conflict on no wait transaction
2025-06-28 05:13:54.161 -unsuccessful metadata update
2025-06-28 05:13:54.166 -object PROCEDURE "SP_TEST" is in use
2025-06-28 05:13:54.172 (335544345, 335544351, 335544453)
2025-06-28 05:13:54.178
2025-06-28 05:13:54.192 READ_COMMITTED_RECORD_VERSION drop procedure sp_worker
2025-06-28 05:13:54.203 lock conflict on no wait transaction
2025-06-28 05:13:54.212 -unsuccessful metadata update
2025-06-28 05:13:54.219 -object PROCEDURE "SP_WORKER" is in use
2025-06-28 05:13:54.231 (335544345, 335544351, 335544453)
2025-06-28 05:13:54.239
2025-06-28 05:13:54.247 READ_COMMITTED_RECORD_VERSION drop function fn_worker
2025-06-28 05:13:54.263 lock conflict on no wait transaction
2025-06-28 05:13:54.276 -unsuccessful metadata update
2025-06-28 05:13:54.289 -object FUNCTION "FN_WORKER" is in use
2025-06-28 05:13:54.300 (335544345, 335544351, 335544453)
2025-06-28 05:13:54.311
2025-06-28 05:13:54.323 READ_COMMITTED_RECORD_VERSION drop view v_test
2025-06-28 05:13:54.332 lock conflict on no wait transaction
2025-06-28 05:13:54.339 -unsuccessful metadata update
2025-06-28 05:13:54.346 -object VIEW "V_TEST" is in use
2025-06-28 05:13:54.354 (335544345, 335544351, 335544453)
2025-06-28 05:13:54.362
2025-06-28 05:13:54.372 READ_COMMITTED_RECORD_VERSION drop table test2
2025-06-28 05:13:54.383 lock conflict on no wait transaction
2025-06-28 05:13:54.392 -unsuccessful metadata update
2025-06-28 05:13:54.403 -object TABLE "TEST2" is in use
2025-06-28 05:13:54.412 (335544345, 335544351, 335544453)
2025-06-28 05:13:54.421
2025-06-28 05:13:54.434 READ_COMMITTED_RECORD_VERSION drop index test1_id
2025-06-28 05:13:54.446 lock conflict on no wait transaction
2025-06-28 05:13:54.455 -unsuccessful metadata update
2025-06-28 05:13:54.463 -object INDEX "TEST1_ID" is in use
2025-06-28 05:13:54.471 (335544345, 335544351, 335544453)
2025-06-28 05:13:54.478
2025-06-28 05:13:54.487 READ_COMMITTED_RECORD_VERSION drop index test2_x
2025-06-28 05:13:54.497 lock conflict on no wait transaction
2025-06-28 05:13:54.506 -unsuccessful metadata update
2025-06-28 05:13:54.514 -object INDEX "TEST2_X" is in use
2025-06-28 05:13:54.527 (335544345, 335544351, 335544453)
2025-06-28 05:13:54.540
2025-06-28 05:13:54.551 SNAPSHOT drop procedure sp_test
2025-06-28 05:13:54.564 lock conflict on no wait transaction
2025-06-28 05:13:54.574 -unsuccessful metadata update
2025-06-28 05:13:54.583 -object PROCEDURE "SP_TEST" is in use
2025-06-28 05:13:54.593 (335544345, 335544351, 335544453)
2025-06-28 05:13:54.605
2025-06-28 05:13:54.617 SNAPSHOT drop procedure sp_worker
2025-06-28 05:13:54.627 lock conflict on no wait transaction
2025-06-28 05:13:54.642 -unsuccessful metadata update
2025-06-28 05:13:54.651 -object PROCEDURE "SP_WORKER" is in use
2025-06-28 05:13:54.659 (335544345, 335544351, 335544453)
2025-06-28 05:13:54.668
2025-06-28 05:13:54.679 SNAPSHOT drop function fn_worker
2025-06-28 05:13:54.689 lock conflict on no wait transaction
2025-06-28 05:13:54.702 -unsuccessful metadata update
2025-06-28 05:13:54.713 -object FUNCTION "FN_WORKER" is in use
2025-06-28 05:13:54.721 (335544345, 335544351, 335544453)
2025-06-28 05:13:54.728
2025-06-28 05:13:54.739 SNAPSHOT drop view v_test
2025-06-28 05:13:54.750 lock conflict on no wait transaction
2025-06-28 05:13:54.759 -unsuccessful metadata update
2025-06-28 05:13:54.770 -object VIEW "V_TEST" is in use
2025-06-28 05:13:54.783 (335544345, 335544351, 335544453)
2025-06-28 05:13:54.795
2025-06-28 05:13:54.807 SNAPSHOT drop table test2
2025-06-28 05:13:54.816 lock conflict on no wait transaction
2025-06-28 05:13:54.825 -unsuccessful metadata update
2025-06-28 05:13:54.832 -object TABLE "TEST2" is in use
2025-06-28 05:13:54.840 (335544345, 335544351, 335544453)
2025-06-28 05:13:54.846
2025-06-28 05:13:54.855 SNAPSHOT drop index test1_id
2025-06-28 05:13:54.869 lock conflict on no wait transaction
2025-06-28 05:13:54.879 -unsuccessful metadata update
2025-06-28 05:13:54.888 -object INDEX "TEST1_ID" is in use
2025-06-28 05:13:54.896 (335544345, 335544351, 335544453)
2025-06-28 05:13:54.903
2025-06-28 05:13:54.911 SNAPSHOT drop index test2_x
2025-06-28 05:13:54.922 lock conflict on no wait transaction
2025-06-28 05:13:54.931 -unsuccessful metadata update
2025-06-28 05:13:54.939 -object INDEX "TEST2_X" is in use
2025-06-28 05:13:54.946 (335544345, 335544351, 335544453)
2025-06-28 05:13:54.952
2025-06-28 05:13:54.959 SERIALIZABLE drop procedure sp_test
2025-06-28 05:13:54.966 lock conflict on no wait transaction
2025-06-28 05:13:54.972 -unsuccessful metadata update
2025-06-28 05:13:54.978 -object PROCEDURE "SP_TEST" is in use
2025-06-28 05:13:54.985 (335544345, 335544351, 335544453)
2025-06-28 05:13:54.991
2025-06-28 05:13:54.996 SERIALIZABLE drop procedure sp_worker
2025-06-28 05:13:55.003 lock conflict on no wait transaction
2025-06-28 05:13:55.009 -unsuccessful metadata update
2025-06-28 05:13:55.018 -object PROCEDURE "SP_WORKER" is in use
2025-06-28 05:13:55.024 (335544345, 335544351, 335544453)
2025-06-28 05:13:55.031
2025-06-28 05:13:55.039 SERIALIZABLE drop function fn_worker
2025-06-28 05:13:55.046 lock conflict on no wait transaction
2025-06-28 05:13:55.052 -unsuccessful metadata update
2025-06-28 05:13:55.058 -object FUNCTION "FN_WORKER" is in use
2025-06-28 05:13:55.063 (335544345, 335544351, 335544453)
2025-06-28 05:13:55.071
2025-06-28 05:13:55.081 SERIALIZABLE drop view v_test
2025-06-28 05:13:55.089 lock conflict on no wait transaction
2025-06-28 05:13:55.096 -unsuccessful metadata update
2025-06-28 05:13:55.102 -object VIEW "V_TEST" is in use
2025-06-28 05:13:55.113 (335544345, 335544351, 335544453)
2025-06-28 05:13:55.123
2025-06-28 05:13:55.131 SERIALIZABLE drop table test2
2025-06-28 05:13:55.139 lock conflict on no wait transaction
2025-06-28 05:13:55.149 -unsuccessful metadata update
2025-06-28 05:13:55.161 -object TABLE "TEST2" is in use
2025-06-28 05:13:55.171 (335544345, 335544351, 335544453)
2025-06-28 05:13:55.180
2025-06-28 05:13:55.187 SERIALIZABLE drop index test1_id
2025-06-28 05:13:55.195 lock conflict on no wait transaction
2025-06-28 05:13:55.208 -unsuccessful metadata update
2025-06-28 05:13:55.217 -object INDEX "TEST1_ID" is in use
2025-06-28 05:13:55.224 (335544345, 335544351, 335544453)
2025-06-28 05:13:55.231
2025-06-28 05:13:55.237 SERIALIZABLE drop index test2_x
2025-06-28 05:13:55.243 lock conflict on no wait transaction
2025-06-28 05:13:55.248 -unsuccessful metadata update
2025-06-28 05:13:55.254 -object INDEX "TEST2_X" is in use
2025-06-28 05:13:55.264 (335544345, 335544351, 335544453)
2025-06-28 05:13:55.273
2025-06-28 05:13:55.281 READ_COMMITTED_READ_CONSISTENCY drop procedure sp_test
2025-06-28 05:13:55.287 lock conflict on no wait transaction
2025-06-28 05:13:55.293 -unsuccessful metadata update
2025-06-28 05:13:55.298 -object PROCEDURE "SP_TEST" is in use
2025-06-28 05:13:55.309 (335544345, 335544351, 335544453)
2025-06-28 05:13:55.318
2025-06-28 05:13:55.328 READ_COMMITTED_READ_CONSISTENCY drop procedure sp_worker
2025-06-28 05:13:55.336 lock conflict on no wait transaction
2025-06-28 05:13:55.342 -unsuccessful metadata update
2025-06-28 05:13:55.347 -object PROCEDURE "SP_WORKER" is in use
2025-06-28 05:13:55.353 (335544345, 335544351, 335544453)
2025-06-28 05:13:55.358
2025-06-28 05:13:55.362 READ_COMMITTED_READ_CONSISTENCY drop function fn_worker
2025-06-28 05:13:55.367 lock conflict on no wait transaction
2025-06-28 05:13:55.376 -unsuccessful metadata update
2025-06-28 05:13:55.385 -object FUNCTION "FN_WORKER" is in use
2025-06-28 05:13:55.393 (335544345, 335544351, 335544453)
2025-06-28 05:13:55.398
2025-06-28 05:13:55.404 READ_COMMITTED_READ_CONSISTENCY drop view v_test
2025-06-28 05:13:55.409 lock conflict on no wait transaction
2025-06-28 05:13:55.414 -unsuccessful metadata update
2025-06-28 05:13:55.419 -object VIEW "V_TEST" is in use
2025-06-28 05:13:55.426 (335544345, 335544351, 335544453)
2025-06-28 05:13:55.433
2025-06-28 05:13:55.438 READ_COMMITTED_READ_CONSISTENCY drop table test2
2025-06-28 05:13:55.443 lock conflict on no wait transaction
2025-06-28 05:13:55.448 -unsuccessful metadata update
2025-06-28 05:13:55.453 -object TABLE "TEST2" is in use
2025-06-28 05:13:55.459 (335544345, 335544351, 335544453)
2025-06-28 05:13:55.465
2025-06-28 05:13:55.471 READ_COMMITTED_READ_CONSISTENCY drop index test1_id
2025-06-28 05:13:55.476 lock conflict on no wait transaction
2025-06-28 05:13:55.482 -unsuccessful metadata update
2025-06-28 05:13:55.487 -object INDEX "TEST1_ID" is in use
2025-06-28 05:13:55.493 (335544345, 335544351, 335544453)
2025-06-28 05:13:55.498
2025-06-28 05:13:55.504 READ_COMMITTED_READ_CONSISTENCY drop index test2_x
2025-06-28 05:13:55.510 lock conflict on no wait transaction
2025-06-28 05:13:55.515 -unsuccessful metadata update
2025-06-28 05:13:55.521 -object INDEX "TEST2_X" is in use
2025-06-28 05:13:55.526 (335544345, 335544351, 335544453)
2025-06-28 05:13:55.531 """
2025-06-28 05:13:55.537
2025-06-28 05:13:55.545 act.stdout = capsys.readouterr().out
2025-06-28 05:13:55.555 > assert act.clean_stdout == act.clean_expected_stdout
2025-06-28 05:13:55.561 E assert
2025-06-28 05:13:55.567 E READ_COMMITTED_NO_RECORD_VERSION drop procedure sp_test
2025-06-28 05:13:55.579 E lock conflict on no wait transaction
2025-06-28 05:13:55.589 E -unsuccessful metadata update
2025-06-28 05:13:55.601 E - -object PROCEDURE "SP_TEST" is in use
2025-06-28 05:13:55.608 E + -object PROCEDURE "PUBLIC"."SP_TEST" is in use
2025-06-28 05:13:55.621 E (335544345, 335544351, 335544453)
2025-06-28 05:13:55.627 E READ_COMMITTED_NO_RECORD_VERSION drop procedure sp_worker
2025-06-28 05:13:55.632 E lock conflict on no wait transaction
2025-06-28 05:13:55.638 E -unsuccessful metadata update
2025-06-28 05:13:55.644 E - -object PROCEDURE "SP_WORKER" is in use
2025-06-28 05:13:55.650 E + -object PROCEDURE "PUBLIC"."SP_WORKER" is in use
2025-06-28 05:13:55.671 E (335544345, 335544351, 335544453)
2025-06-28 05:13:55.680 E READ_COMMITTED_NO_RECORD_VERSION drop function fn_worker
2025-06-28 05:13:55.686 E lock conflict on no wait transaction
2025-06-28 05:13:55.692 E -unsuccessful metadata update
2025-06-28 05:13:55.697 E - -object FUNCTION "FN_WORKER" is in use
2025-06-28 05:13:55.708 E + -object FUNCTION "PUBLIC"."FN_WORKER" is in use
2025-06-28 05:13:55.724 E (335544345, 335544351, 335544453)
2025-06-28 05:13:55.730 E READ_COMMITTED_NO_RECORD_VERSION drop view v_test
2025-06-28 05:13:55.736 E lock conflict on no wait transaction
2025-06-28 05:13:55.742 E -unsuccessful metadata update
2025-06-28 05:13:55.747 E - -object VIEW "V_TEST" is in use
2025-06-28 05:13:55.754 E + -object VIEW "PUBLIC"."V_TEST" is in use
2025-06-28 05:13:55.773 E (335544345, 335544351, 335544453)
2025-06-28 05:13:55.779 E READ_COMMITTED_NO_RECORD_VERSION drop table test2
2025-06-28 05:13:55.786 E lock conflict on no wait transaction
2025-06-28 05:13:55.791 E -unsuccessful metadata update
2025-06-28 05:13:55.796 E - -object TABLE "TEST2" is in use
2025-06-28 05:13:55.802 E + -object TABLE "PUBLIC"."TEST2" is in use
2025-06-28 05:13:55.813 E (335544345, 335544351, 335544453)
2025-06-28 05:13:55.819 E READ_COMMITTED_NO_RECORD_VERSION drop index test1_id
2025-06-28 05:13:55.825 E lock conflict on no wait transaction
2025-06-28 05:13:55.830 E -unsuccessful metadata update
2025-06-28 05:13:55.838 E - -object INDEX "TEST1_ID" is in use
2025-06-28 05:13:55.850 E + -object INDEX "PUBLIC"."TEST1_ID" is in use
2025-06-28 05:13:55.868 E (335544345, 335544351, 335544453)
2025-06-28 05:13:55.874 E READ_COMMITTED_NO_RECORD_VERSION drop index test2_x
2025-06-28 05:13:55.879 E lock conflict on no wait transaction
2025-06-28 05:13:55.884 E -unsuccessful metadata update
2025-06-28 05:13:55.888 E - -object INDEX "TEST2_X" is in use
2025-06-28 05:13:55.892 E + -object INDEX "PUBLIC"."TEST2_X" is in use
2025-06-28 05:13:55.903 E (335544345, 335544351, 335544453)
2025-06-28 05:13:55.911 E READ_COMMITTED_RECORD_VERSION drop procedure sp_test
2025-06-28 05:13:55.926 E lock conflict on no wait transaction
2025-06-28 05:13:55.937 E -unsuccessful metadata update
2025-06-28 05:13:55.945 E - -object PROCEDURE "SP_TEST" is in use
2025-06-28 05:13:55.952 E + -object PROCEDURE "PUBLIC"."SP_TEST" is in use
2025-06-28 05:13:55.964 E (335544345, 335544351, 335544453)
2025-06-28 05:13:55.969 E READ_COMMITTED_RECORD_VERSION drop procedure sp_worker
2025-06-28 05:13:55.974 E lock conflict on no wait transaction
2025-06-28 05:13:55.978 E -unsuccessful metadata update
2025-06-28 05:13:55.983 E - -object PROCEDURE "SP_WORKER" is in use
2025-06-28 05:13:55.988 E + -object PROCEDURE "PUBLIC"."SP_WORKER" is in use
2025-06-28 05:13:56.000 E (335544345, 335544351, 335544453)
2025-06-28 05:13:56.007 E READ_COMMITTED_RECORD_VERSION drop function fn_worker
2025-06-28 05:13:56.013 E lock conflict on no wait transaction
2025-06-28 05:13:56.019 E -unsuccessful metadata update
2025-06-28 05:13:56.026 E - -object FUNCTION "FN_WORKER" is in use
2025-06-28 05:13:56.032 E + -object FUNCTION "PUBLIC"."FN_WORKER" is in use
2025-06-28 05:13:56.051 E (335544345, 335544351, 335544453)
2025-06-28 05:13:56.061 E READ_COMMITTED_RECORD_VERSION drop view v_test
2025-06-28 05:13:56.069 E lock conflict on no wait transaction
2025-06-28 05:13:56.076 E -unsuccessful metadata update
2025-06-28 05:13:56.082 E - -object VIEW "V_TEST" is in use
2025-06-28 05:13:56.088 E + -object VIEW "PUBLIC"."V_TEST" is in use
2025-06-28 05:13:56.099 E (335544345, 335544351, 335544453)
2025-06-28 05:13:56.105 E READ_COMMITTED_RECORD_VERSION drop table test2
2025-06-28 05:13:56.110 E lock conflict on no wait transaction
2025-06-28 05:13:56.116 E -unsuccessful metadata update
2025-06-28 05:13:56.121 E - -object TABLE "TEST2" is in use
2025-06-28 05:13:56.127 E + -object TABLE "PUBLIC"."TEST2" is in use
2025-06-28 05:13:56.139 E (335544345, 335544351, 335544453)
2025-06-28 05:13:56.144 E READ_COMMITTED_RECORD_VERSION drop index test1_id
2025-06-28 05:13:56.150 E lock conflict on no wait transaction
2025-06-28 05:13:56.156 E -unsuccessful metadata update
2025-06-28 05:13:56.162 E - -object INDEX "TEST1_ID" is in use
2025-06-28 05:13:56.172 E + -object INDEX "PUBLIC"."TEST1_ID" is in use
2025-06-28 05:13:56.191 E (335544345, 335544351, 335544453)
2025-06-28 05:13:56.199 E READ_COMMITTED_RECORD_VERSION drop index test2_x
2025-06-28 05:13:56.205 E lock conflict on no wait transaction
2025-06-28 05:13:56.212 E -unsuccessful metadata update
2025-06-28 05:13:56.219 E - -object INDEX "TEST2_X" is in use
2025-06-28 05:13:56.229 E + -object INDEX "PUBLIC"."TEST2_X" is in use
2025-06-28 05:13:56.243 E (335544345, 335544351, 335544453)
2025-06-28 05:13:56.249 E SNAPSHOT drop procedure sp_test
2025-06-28 05:13:56.255 E lock conflict on no wait transaction
2025-06-28 05:13:56.260 E -unsuccessful metadata update
2025-06-28 05:13:56.266 E - -object PROCEDURE "SP_TEST" is in use
2025-06-28 05:13:56.272 E + -object PROCEDURE "PUBLIC"."SP_TEST" is in use
2025-06-28 05:13:56.283 E (335544345, 335544351, 335544453)
2025-06-28 05:13:56.289 E SNAPSHOT drop procedure sp_worker
2025-06-28 05:13:56.295 E lock conflict on no wait transaction
2025-06-28 05:13:56.301 E -unsuccessful metadata update
2025-06-28 05:13:56.306 E - -object PROCEDURE "SP_WORKER" is in use
2025-06-28 05:13:56.312 E + -object PROCEDURE "PUBLIC"."SP_WORKER" is in use
2025-06-28 05:13:56.323 E (335544345, 335544351, 335544453)
2025-06-28 05:13:56.329 E SNAPSHOT drop function fn_worker
2025-06-28 05:13:56.334 E lock conflict on no wait transaction
2025-06-28 05:13:56.343 E -unsuccessful metadata update
2025-06-28 05:13:56.355 E - -object FUNCTION "FN_WORKER" is in use
2025-06-28 05:13:56.363 E + -object FUNCTION "PUBLIC"."FN_WORKER" is in use
2025-06-28 05:13:56.377 E (335544345, 335544351, 335544453)
2025-06-28 05:13:56.383 E SNAPSHOT drop view v_test
2025-06-28 05:13:56.393 E lock conflict on no wait transaction
2025-06-28 05:13:56.403 E -unsuccessful metadata update
2025-06-28 05:13:56.410 E - -object VIEW "V_TEST" is in use
2025-06-28 05:13:56.420 E + -object VIEW "PUBLIC"."V_TEST" is in use
2025-06-28 05:13:56.438 E (335544345, 335544351, 335544453)
2025-06-28 05:13:56.446 E SNAPSHOT drop table test2
2025-06-28 05:13:56.457 E lock conflict on no wait transaction
2025-06-28 05:13:56.467 E -unsuccessful metadata update
2025-06-28 05:13:56.476 E - -object TABLE "TEST2" is in use
2025-06-28 05:13:56.484 E + -object TABLE "PUBLIC"."TEST2" is in use
2025-06-28 05:13:56.496 E (335544345, 335544351, 335544453)
2025-06-28 05:13:56.507 E SNAPSHOT drop index test1_id
2025-06-28 05:13:56.518 E lock conflict on no wait transaction
2025-06-28 05:13:56.527 E -unsuccessful metadata update
2025-06-28 05:13:56.535 E - -object INDEX "TEST1_ID" is in use
2025-06-28 05:13:56.547 E + -object INDEX "PUBLIC"."TEST1_ID" is in use
2025-06-28 05:13:56.568 E (335544345, 335544351, 335544453)
2025-06-28 05:13:56.575 E SNAPSHOT drop index test2_x
2025-06-28 05:13:56.582 E lock conflict on no wait transaction
2025-06-28 05:13:56.591 E -unsuccessful metadata update
2025-06-28 05:13:56.600 E - -object INDEX "TEST2_X" is in use
2025-06-28 05:13:56.608 E + -object INDEX "PUBLIC"."TEST2_X" is in use
2025-06-28 05:13:56.621 E (335544345, 335544351, 335544453)
2025-06-28 05:13:56.627 E SERIALIZABLE drop procedure sp_test
2025-06-28 05:13:56.635 E lock conflict on no wait transaction
2025-06-28 05:13:56.642 E -unsuccessful metadata update
2025-06-28 05:13:56.648 E - -object PROCEDURE "SP_TEST" is in use
2025-06-28 05:13:56.654 E + -object PROCEDURE "PUBLIC"."SP_TEST" is in use
2025-06-28 05:13:56.665 E (335544345, 335544351, 335544453)
2025-06-28 05:13:56.671 E SERIALIZABLE drop procedure sp_worker
2025-06-28 05:13:56.677 E lock conflict on no wait transaction
2025-06-28 05:13:56.683 E -unsuccessful metadata update
2025-06-28 05:13:56.692 E - -object PROCEDURE "SP_WORKER" is in use
2025-06-28 05:13:56.701 E + -object PROCEDURE "PUBLIC"."SP_WORKER" is in use
2025-06-28 05:13:56.712 E (335544345, 335544351, 335544453)
2025-06-28 05:13:56.717 E SERIALIZABLE drop function fn_worker
2025-06-28 05:13:56.723 E lock conflict on no wait transaction
2025-06-28 05:13:56.728 E -unsuccessful metadata update
2025-06-28 05:13:56.734 E - -object FUNCTION "FN_WORKER" is in use
2025-06-28 05:13:56.740 E + -object FUNCTION "PUBLIC"."FN_WORKER" is in use
2025-06-28 05:13:56.754 E (335544345, 335544351, 335544453)
2025-06-28 05:13:56.764 E SERIALIZABLE drop view v_test
2025-06-28 05:13:56.771 E lock conflict on no wait transaction
2025-06-28 05:13:56.779 E -unsuccessful metadata update
2025-06-28 05:13:56.791 E - -object VIEW "V_TEST" is in use
2025-06-28 05:13:56.803 E + -object VIEW "PUBLIC"."V_TEST" is in use
2025-06-28 05:13:56.819 E (335544345, 335544351, 335544453)
2025-06-28 05:13:56.825 E SERIALIZABLE drop table test2
2025-06-28 05:13:56.836 E lock conflict on no wait transaction
2025-06-28 05:13:56.846 E -unsuccessful metadata update
2025-06-28 05:13:56.852 E - -object TABLE "TEST2" is in use
2025-06-28 05:13:56.857 E + -object TABLE "PUBLIC"."TEST2" is in use
2025-06-28 05:13:56.867 E (335544345, 335544351, 335544453)
2025-06-28 05:13:56.871 E SERIALIZABLE drop index test1_id
2025-06-28 05:13:56.875 E lock conflict on no wait transaction
2025-06-28 05:13:56.880 E -unsuccessful metadata update
2025-06-28 05:13:56.884 E - -object INDEX "TEST1_ID" is in use
2025-06-28 05:13:56.894 E + -object INDEX "PUBLIC"."TEST1_ID" is in use
2025-06-28 05:13:56.906 E (335544345, 335544351, 335544453)
2025-06-28 05:13:56.911 E SERIALIZABLE drop index test2_x
2025-06-28 05:13:56.916 E lock conflict on no wait transaction
2025-06-28 05:13:56.920 E -unsuccessful metadata update
2025-06-28 05:13:56.926 E - -object INDEX "TEST2_X" is in use
2025-06-28 05:13:56.931 E + -object INDEX "PUBLIC"."TEST2_X" is in use
2025-06-28 05:13:56.941 E (335544345, 335544351, 335544453)
2025-06-28 05:13:56.945 E READ_COMMITTED_READ_CONSISTENCY drop procedure sp_test
2025-06-28 05:13:56.949 E lock conflict on no wait transaction
2025-06-28 05:13:56.954 E -unsuccessful metadata update
2025-06-28 05:13:56.958 E - -object PROCEDURE "SP_TEST" is in use
2025-06-28 05:13:56.962 E + -object PROCEDURE "PUBLIC"."SP_TEST" is in use
2025-06-28 05:13:56.971 E (335544345, 335544351, 335544453)
2025-06-28 05:13:56.976 E READ_COMMITTED_READ_CONSISTENCY drop procedure sp_worker
2025-06-28 05:13:56.980 E lock conflict on no wait transaction
2025-06-28 05:13:56.984 E -unsuccessful metadata update
2025-06-28 05:13:56.989 E - -object PROCEDURE "SP_WORKER" is in use
2025-06-28 05:13:56.993 E + -object PROCEDURE "PUBLIC"."SP_WORKER" is in use
2025-06-28 05:13:57.002 E (335544345, 335544351, 335544453)
2025-06-28 05:13:57.006 E READ_COMMITTED_READ_CONSISTENCY drop function fn_worker
2025-06-28 05:13:57.011 E lock conflict on no wait transaction
2025-06-28 05:13:57.015 E -unsuccessful metadata update
2025-06-28 05:13:57.019 E - -object FUNCTION "FN_WORKER" is in use
2025-06-28 05:13:57.024 E + -object FUNCTION "PUBLIC"."FN_WORKER" is in use
2025-06-28 05:13:57.032 E (335544345, 335544351, 335544453)
2025-06-28 05:13:57.037 E READ_COMMITTED_READ_CONSISTENCY drop view v_test
2025-06-28 05:13:57.041 E lock conflict on no wait transaction
2025-06-28 05:13:57.045 E -unsuccessful metadata update
2025-06-28 05:13:57.050 E - -object VIEW "V_TEST" is in use
2025-06-28 05:13:57.054 E + -object VIEW "PUBLIC"."V_TEST" is in use
2025-06-28 05:13:57.063 E (335544345, 335544351, 335544453)
2025-06-28 05:13:57.073 E READ_COMMITTED_READ_CONSISTENCY drop table test2
2025-06-28 05:13:57.082 E lock conflict on no wait transaction
2025-06-28 05:13:57.091 E -unsuccessful metadata update
2025-06-28 05:13:57.099 E - -object TABLE "TEST2" is in use
2025-06-28 05:13:57.105 E + -object TABLE "PUBLIC"."TEST2" is in use
2025-06-28 05:13:57.115 E (335544345, 335544351, 335544453)
2025-06-28 05:13:57.119 E READ_COMMITTED_READ_CONSISTENCY drop index test1_id
2025-06-28 05:13:57.123 E lock conflict on no wait transaction
2025-06-28 05:13:57.128 E -unsuccessful metadata update
2025-06-28 05:13:57.134 E - -object INDEX "TEST1_ID" is in use
2025-06-28 05:13:57.141 E + -object INDEX "PUBLIC"."TEST1_ID" is in use
2025-06-28 05:13:57.155 E (335544345, 335544351, 335544453)
2025-06-28 05:13:57.165 E READ_COMMITTED_READ_CONSISTENCY drop index test2_x
2025-06-28 05:13:57.172 E lock conflict on no wait transaction
2025-06-28 05:13:57.179 E -unsuccessful metadata update
2025-06-28 05:13:57.186 E - -object INDEX "TEST2_X" is in use
2025-06-28 05:13:57.196 E + -object INDEX "PUBLIC"."TEST2_X" is in use
2025-06-28 05:13:57.210 E (335544345, 335544351, 335544453)
2025-06-28 05:13:57.218
2025-06-28 05:13:57.226 tests/bugs/core_4386_test.py:370: AssertionError
2025-06-28 05:13:57.234 ---------------------------- Captured stdout setup -----------------------------
2025-06-28 05:13:57.246 Creating db: localhost:/var/tmp/qa_2024/test_1838/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
|