s**********o
发帖数: 14359 | 1 【 以下文字转载自 Dreamer 讨论区 】
发信人: Dreamer (不要问我从哪里来), 信区: Dreamer
标 题: A SQL query never stop running is bothering me: help needed!
关键字: SQL
发信站: BBS 未名空间站 (Thu Oct 18 15:02:34 2012, 美东)
Just now I issued a query to update a column's value.
The table is really big so it never stop running.
After waited for 40 minutes I tried to give up, so I canceled my query.
But what happening now is I can't query this table, all related queries will
hang there running.
And I can't detach the database and re attach it because the query seems is
still running even after I canceled it.
What should I do now besides waiting?
If I mess up this table, I'll in big trouble!
Help! | a9
发帖数: 21638 | 2 这应该转joke版啊。
will
【在 s**********o 的大作中提到】
: 【 以下文字转载自 Dreamer 讨论区 】
: 发信人: Dreamer (不要问我从哪里来), 信区: Dreamer
: 标 题: A SQL query never stop running is bothering me: help needed!
: 关键字: SQL
: 发信站: BBS 未名空间站 (Thu Oct 18 15:02:34 2012, 美东)
: Just now I issued a query to update a column's value.
: The table is really big so it never stop running.
: After waited for 40 minutes I tried to give up, so I canceled my query.
: But what happening now is I can't query this table, all related queries will
: hang there running.
| y*****g
发帖数: 677 | 3 this must a MS SQL server guy.
Sometime this happens. Usually you have to wait till it finishes.
Even you cancel, you still need to wait quite a bit of time for it to roll
back.
Do not 随便地KILL， |
|
