Is it possible to stop query execution on db server when process that start to run that query killed?

Questions / Help
1

Hello all!
I have process (actually Task) that start an sql transaction, but for some reason (client disconnect) process stopped.
It would be cool if there is a way to stop execution of query on db server.
Thanks

2

Maybe you can ABORT the transaction in terminate/2 genserver callback. Or maybe you can use Ecto.Multi somehow.

3

You can use YourAppName.Repo.rollback/1 to stop a database transaction that is in progress.

1 Like
4

It will be what i’m really needed but method Ecto.Repo — Ecto v3.11.1 returns value or error.
So, there are no identificator/pid for transaction.
An example:
Starting task that start transaction:
{:ok, pid} = Task.Supervisor.start_child(:db_worker, fn → “select sleep(15) from user” end)
Wnen i shutdown task by pid, query still running on the server. And it seems that there is no way to stop it