Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.
Original topic: 视图创建好后不能删除，也不能修改
[TiDB Usage Environment] Testing/PoC
[TiDB Version] 6.3.0
[Encountered Problem]
Unable to delete a view after it is created
[Reproduction Path] Steps taken that led to the problem
[Problem Phenomenon and Impact]
Creating and modifying views is a very normal operation, which has a serious impact on the development and runtime environment
[Attachments]
Is there too little log information? Is it stuck? Or is there any error message? What log information is there in the TiDB background?
Views can be modified. Try deleting it; it can be deleted.
First, show the error message you get when you execute the drop command, or is it just stuck?
admin show ddl jobs; take a look
Stuck and unresponsive, deleting or modifying the view also results in being stuck and unresponsive.
Using modify view or delete view both get stuck and do not move.
In what environment is this executed?
Stuck and unresponsive, deleting or modifying the view also gets stuck and unresponsive.
Stuck and unresponsive, deleting or modifying the view also results in being stuck and unresponsive, no errors reported, just continuously stuck.
admin show ddl jobs 30 to see if there are any other DDLs.
Check the TiDB logs for any error messages.
It feels like an issue with the tool… Is the window correct, the window for executing SQL?
There are still permissions, right?
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.
|
username: TiDBer_istshnCu
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: