Wow! Thank You so much for pointing me these!
-- Marcin Koziej GPG key: https://go.cahoots.pl/gpg/ Ϟ Twitter: @movonw ‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐ On Thursday, November 14, 2019 2:31 PM, Simon King <si...@simonking.org.uk> wrote: > For what it's worth, you can read how the mysql command line does it here: > > https://github.com/mysql/mysql-server/blob/8.0/client/mysql.cc#L1484 > > On Thu, Nov 14, 2019 at 1:21 PM Simon King si...@simonking.org.uk wrote: > > > According to > > https://dev.mysql.com/doc/refman/8.0/en/information-functions.html#function_connection-id, > > "SELECT connection_id()" should give you the answer. > > Simon > > On Thu, Nov 14, 2019 at 12:13 PM Marcin Koziej mar...@cahoots.pl wrote: > > > > > I don't know how to do this using other DBAPIs, but I thought that if > > > command line mysql client has such behaviour, it should be possible also > > > using the library. > > > I was thinking about finding the process in SHOW PROCESSLIST and killing > > > it, but it seems hacky and I am not sure if I can find the correct > > > process (what if the same user is running another query concurrently?). > > > Does SQLAlchemy store last command pid maybe? > > > -- > > > Marcin Koziej > > > GPG key: https://go.cahoots.pl/gpg/ Ϟ Twitter: @movonw > > > ‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐ > > > On Thursday, November 14, 2019 12:37 PM, Simon King > > > si...@simonking.org.uk wrote: > > > > > > > I'm not sure this is even possible. Ignoring SQLAlchemy, do you know > > > > how you would do it using any MySQL DBAPI library (mysqlclient, > > > > PyMySQL, etc.)? > > > > Maybe you could do something creative where you capture the PID when > > > > the connection is created, and on Ctrl-C, send a "KILL pid" command. I > > > > don't know if you can send new commands on a connection while it is > > > > executing a query, so you might need to use a new connection. > > > > Simon > > > > On Thu, Nov 14, 2019 at 8:24 AM Marcin Koziej mar...@cahoots.pl wrote: > > > > > > > > > (Crossposting from Stackoverflow, where I unfortunately didn't get > > > > > any answers: > > > > > https://stackoverflow.com/questions/58837864/sqlalchemty-how-to-kill-a-mysql-process-on-keyboard-interrupt > > > > > ) > > > > > Hello! > > > > > I'm using SQLAlchemy 1.3.10 to run a bunch of SQL statements on > > > > > Percona Server 5.7.27. I do not use the ORM functionality. My problem > > > > > is that I cannot abort the running SQL statement from > > > > > KeyboardInterrupt handler, after hitting Ctrl-C. > > > > > My usage is as follows: > > > > > engine = create_engine(...) > > > > > connection = engine.connect() > > > > > with connection.begin() as transaction: > > > > > try: > > > > > res = connection.execute(text(sql)) > > > > > except KeyboardInterrupt as ctrlc: > > > > > print('You pressed ctrl-c') > > > > > transaction.rollback() > > > > > sys.exit(1) > > > > > Pressing Ctrl-c stops the script but leaves the query running in > > > > > MySQL server, and i have to kill it manually using KILL pid. > > > > > I've tried to call connection.close() as well, but without result. > > > > > How can I kill such running query on keyboard interrupt? > > > > > Best regards, > > > > > Marcin Koziej > > > > > > > > > > ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ > > > > > > > > > > SQLAlchemy - > > > > > The Python SQL Toolkit and Object Relational Mapper > > > > > http://www.sqlalchemy.org/ > > > > > To post example code, please provide an MCVE: Minimal, Complete, and > > > > > Verifiable Example. See http://stackoverflow.com/help/mcve for a full > > > > > description. > > > > > > > > > > You received this message because you are subscribed to the Google > > > > > Groups "sqlalchemy" group. > > > > > To unsubscribe from this group and stop receiving emails from it, > > > > > send an email to sqlalchemy+unsubscr...@googlegroups.com. > > > > > To view this discussion on the web visit > > > > > https://groups.google.com/d/msgid/sqlalchemy/426f7140-d078-41fa-81d7-a5a6aabb2a7f%40googlegroups.com. > > > > > > > > -- > > > > SQLAlchemy - > > > > The Python SQL Toolkit and Object Relational Mapper > > > > http://www.sqlalchemy.org/ > > > > To post example code, please provide an MCVE: Minimal, Complete, and > > > > Verifiable Example. See http://stackoverflow.com/help/mcve for a full > > > > description. > > > > > > > > You received this message because you are subscribed to a topic in the > > > > Google Groups "sqlalchemy" group. > > > > To unsubscribe from this topic, visit > > > > https://groups.google.com/d/topic/sqlalchemy/Wv6xGeBLrjg/unsubscribe. > > > > To unsubscribe from this group and all its topics, send an email to > > > > sqlalchemy+unsubscr...@googlegroups.com. > > > > To view this discussion on the web visit > > > > https://groups.google.com/d/msgid/sqlalchemy/CAFHwexewtrjbv%2BYLcDgx0y1o0Sg3o6qO56Oyxf7OEvUyprzRJQ%40mail.gmail.com. > > > > > > -- > > > SQLAlchemy - > > > The Python SQL Toolkit and Object Relational Mapper > > > http://www.sqlalchemy.org/ > > > > > > To post example code, please provide an MCVE: Minimal, Complete, and > > > Verifiable Example. See http://stackoverflow.com/help/mcve for a full > > > description. > > > > > > -------------------------------------------------------------------------------------------------------------------------------------------------------- > > > > > > You received this message because you are subscribed to the Google Groups > > > "sqlalchemy" group. > > > To unsubscribe from this group and stop receiving emails from it, send an > > > email to sqlalchemy+unsubscr...@googlegroups.com. > > > To view this discussion on the web visit > > > https://groups.google.com/d/msgid/sqlalchemy/YVEyBt4_-K_PvH4mN4Kc8d-CQyxe85bUy_6kXx668ub5FvPkR82zrxfkYlTHHW2ptapq1z-QRoX9fGqWzGvmkt9RqusI6Ow65cQTZO4x4EA%3D%40cahoots.pl. > > -- > > SQLAlchemy - > The Python SQL Toolkit and Object Relational Mapper > > http://www.sqlalchemy.org/ > > To post example code, please provide an MCVE: Minimal, Complete, and > Verifiable Example. See http://stackoverflow.com/help/mcve for a full > description. > > ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ > > You received this message because you are subscribed to a topic in the Google > Groups "sqlalchemy" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/sqlalchemy/Wv6xGeBLrjg/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > sqlalchemy+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/sqlalchemy/CAFHwexeyBfxZwXd4JET1Vo-bkHkhD0c7JkYQ5TdK1%2BD5YQ9W0g%40mail.gmail.com. -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/HT7JXMTKQU1ZF5wGBWBOhxPB6OwhsySHB4gDRyGVcLMCLDCObkausJtAShHC5asubXgllr3k5t77XH7z5WX1awvL7ekcWeSKu4SCaoSjIms%3D%40cahoots.pl.
