Questions tagged [kill]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1 vote
0 answers
296 views

MariaDB: Terminate long-running clearnup process?

This is a follow up to my previous question about a long-running INSERT SELECT query that may have exceeded the max_statement_time and was Killed. It has been in the Reset for next command state for 3....
Chris Cox's user avatar
7 votes
2 answers
715 views

Does killed session appears in Query Store?

Is there any option to see killed sessions in Query Store? I am asking, because we have an additional tool which is terminating sessions if they take more than 30 minutes to run (KILL command). I ...
adam.g's user avatar
  • 295
1 vote
0 answers
814 views

Process with Command 'Killed' and State 'Executing'. Not getting killed

Last day, when I ran a count(*) query on a table. It didn't provide any results. It ran forever even. So I tried killing those queries (I have tried it multiple times). As I'm using AWS RDS, I killed ...
Neron Joseph's user avatar
1 vote
1 answer
1k views

Kill concurrent materialized view refresh PID

Concurrent refreshes of materialized views don't have a record in pg_stat_activity, other than the initial (~immediately completing) query to start them. Is there some other way to obtain the PID, in ...
OJFord's user avatar
  • 115
2 votes
1 answer
836 views

Process was intentionally killed - now the process is still showing in "show processlist "

We had a MariaDB long-running process (40 hours), so I killed the thread. But, the thread is still there, with: showing Command as Killed. a State of Unlocking tables. Info is insert into ... What ...
David Rogers's user avatar
8 votes
4 answers
2k views

Delete statement not responding to Kill session command

Four days ago a user ran the command below on a table with 400,000,000 rows. It's still running and the log file is increasing in size. delete from [table-name] This table does have a foreign key ...
David Woakes's user avatar
2 votes
2 answers
6k views

Queries on large database kill connection to the server, works with LIMIT

I'm trying to run queries on a large-ish database without killing the connection to the server. I'm using Postgres 12.1 on a mac with 16gb of memory, and about 40gb of free disk. The database is ...
doeeehunt's user avatar
2 votes
1 answer
2k views

How to immediately terminate a SPID with a very long rollback time estimated?

I have a script to restore a database from a backup. Prior to the restore command, it has: set single_user with rollback immediate The script seemed to be hanging here. I used sp_who2 to find out a ...
youcantryreachingme's user avatar
5 votes
1 answer
467 views

Kill infinite loop plperl

How can I kill session with infinite looped plperl function? Both pg_terminate_backend and pg_cancel_backend had no effect. kill -1 pid did nothing as well and kill -9 pid crashed server.
Łukasz Kamiński's user avatar
4 votes
3 answers
13k views

Grant permission to KILL connections (sessions) for certain databases only?

For a SQL Server on a VM/physical box (not Azure SQL database!) Is this possible to grant KILL permission, but in a way that grantee can kill connections only for certain databases ? I would not ...
Aleksey Vitsko's user avatar
1 vote
2 answers
17k views

Cleanup of Oracle killed session

I killed a session ALTER SYSTEM KILL SESSION '123,456' IMMEDIATE; But it remains in v$session for 10 days, although an attached process is absent in v$processes. SELECT s.username, s.osuser,...
diziaq's user avatar
  • 131
0 votes
3 answers
305 views

after executing a back up cmd (via query) how to kill it

I have a big database (150 GB) that needs a back up and I don't have space in current machine, so I am pointing it to the different box which has space. After executing the cmd, it is executing the ...
Harris Hilton's user avatar
6 votes
1 answer
5k views

Using TCP keepalive for terminating orphan postgres queries not working

Problem: A user of some application executes a report which involves a heavy sql query. After some minutes, the user then quits the application (or even worse, the app crashes, or the connection to ...
Federico Cristina's user avatar
1 vote
1 answer
2k views

what is "killcursors: found 0 of 1" from mongodb.log with replicaset?

This is output of mloginfo log --distinct. What does killcursors mean exactly and what's the DBA action? We use latest mongod in a 3 node replicaset. With a search engine i found only on mongodb-user ...
Sybil's user avatar
  • 2,448
0 votes
2 answers
11k views

KILLED/ROLLBACK query doesn't stop running

I've tried to kill a query on ms sql server management studio. Now it has the status killed/rollback. When I use: kill 74 with statusonly it doesn't make any progress. It is still at 0%. How can I ...
Ezra P.'s user avatar
9 votes
1 answer
15k views

How to terminate a suspended SQL Server transaction waiting for IO_COMPLETION?

We have a transaction that has been running for more than 5 hours. We are running out of disk space. The session has been killed but it is still waiting for IO_COMPLETION. Actually the wait_type just ...
Tarzan's user avatar
  • 529
4 votes
1 answer
6k views

How to stop the execution of a long running insert query?

I've executed an INSERT INTO ... SELECT as a job on my MySQL instance and then I realized that number of records that is selected by the WHERE condition is more than my patience. It's already taken 12 ...
Mehran's user avatar
  • 145
3 votes
2 answers
8k views

Linux command to kill all MySQL sessions from a specific User?

How can i kill all sessions from a user in mysql using a linux command line command? I have a user that is using all on my database connections and insted of killing one by one i want to make a ...
user_bump's user avatar
3 votes
0 answers
2k views

Understanding how sys.dm_exec_requests represents queries being rolled back

I'm not sure whether this was an actual problem or just a normal situation where I needed to wait for rollback to finish. In either case, some insight would be appreciated. Background details I ...
James Lupolt's user avatar
  • 4,248