Thread: Question about aborting
Dear Author! I need to know that which ways I have to abort a runaway query/stored procedure. As I saw, pgAdmin CAN abourt my own queries. It is ok. But what's happens when: - somebody (not me) started a query that have too less filter, and becomes unlimited - I started a query or stored proc what is buggy, and gets into infinitive state because of wrong loops, but the TCP socket disconnected by a failure, or wifi problem, so my session killed by the server As I saw, pgAdmin have a monitoring tool which show me these queries. But have some tool in the pgAdmin with I can abort these runaway statements? Thanks for your help: dd
On Wed, 2011-07-06 at 16:09 +0200, Durumdara wrote: > Dear Author! > > I need to know that which ways I have to abort a runaway query/stored procedure. > > As I saw, pgAdmin CAN abourt my own queries. > It is ok. > > But what's happens when: > - somebody (not me) started a query that have too less filter, and > becomes unlimited > - I started a query or stored proc what is buggy, and gets into > infinitive state because of wrong loops, but the TCP socket > disconnected by a failure, or wifi problem, so my session killed by > the server > > As I saw, pgAdmin have a monitoring tool which show me these queries. > > But have some tool in the pgAdmin with I can abort these runaway statements? > The server status tool can help you stop runaway queries. There's a button for that in the toolbar. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com
Hi! I'm very-very thanks for it! I was so tired yesterday, and I don't clicked on any connections, so the buttons were greyed, and I could not see that there are buttons. :-) Client "start" column is too short. May you can save the columns width to preserve the good size. Thanks and regards: dd 2011/7/6 Guillaume Lelarge <guillaume@lelarge.info>: > On Wed, 2011-07-06 at 16:09 +0200, Durumdara wrote: >> Dear Author! >> >> I need to know that which ways I have to abort a runaway query/stored procedure. >> >> As I saw, pgAdmin CAN abourt my own queries. >> It is ok. >> >> But what's happens when: >> - somebody (not me) started a query that have too less filter, and >> becomes unlimited >> - I started a query or stored proc what is buggy, and gets into >> infinitive state because of wrong loops, but the TCP socket >> disconnected by a failure, or wifi problem, so my session killed by >> the server >> >> As I saw, pgAdmin have a monitoring tool which show me these queries. >> >> But have some tool in the pgAdmin with I can abort these runaway statements? >> > > The server status tool can help you stop runaway queries. There's a > button for that in the toolbar. > > > -- > Guillaume > http://blog.guillaume.lelarge.info > http://www.dalibo.com > >
On Thu, 2011-07-07 at 09:22 +0200, Durumdara wrote: > Hi! > > I'm very-very thanks for it! > I was so tired yesterday, and I don't clicked on any connections, so > the buttons were greyed, and I could not see that there are buttons. > :-) > > Client "start" column is too short. May you can save the columns width > to preserve the good size. > IIRC, 1.14 does already that. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com
Hi! Thank you very much! I everytime forget to check new version. You could do some "check new version on internet" function. This can run once per week. :-) Thanks: dd 2011/7/7 Guillaume Lelarge <guillaume@lelarge.info>: > On Thu, 2011-07-07 at 09:22 +0200, Durumdara wrote: >> Hi! >> >> I'm very-very thanks for it! >> I was so tired yesterday, and I don't clicked on any connections, so >> the buttons were greyed, and I could not see that there are buttons. >> :-) >> >> Client "start" column is too short. May you can save the columns width >> to preserve the good size. >> > > IIRC, 1.14 does already that. > > > -- > Guillaume > http://blog.guillaume.lelarge.info > http://www.dalibo.com > >
On Thu, 2011-07-07 at 14:57 +0200, Durumdara wrote: > Hi! > > Thank you very much! I everytime forget to check new version. > > You could do some "check new version on internet" function. > This can run once per week. :-) > Yeah, that's something I would like to have. I know how to do most of this, but there are still details that prevent me from doing it (and time also unfortunately). I added a ticket to remind me this (http://code.pgadmin.org/trac/ticket/326). -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com