Thread: Prevent loss of query text when pgAdmin crashes or freezes

Prevent loss of query text when pgAdmin crashes or freezes

From
Evan Martin
Date:
I often have multiple SQL query windows open in pgAdmin (v1.14.3 on 
Windows 7 x64). From time to time pgAdmin will crash or freeze (become 
unresponsive) and would have to be killed. When this happens all unsaved 
query text is lost, which is extremely frustrating. It's by far the 
biggest problem for me in using pgAdmin.

Please implement some way to recover the query text from such crashes. 
Ideally something like what Firefox or Chrome do: when restarted after a 
crash they offer the option to restore previous windows (including form 
data, at least in Chrome). This would require that pgAdmin saves query 
text in the background on a regular basis (at least before running any 
query).

Another great way to mitigate this would be to run each SQL query window 
in a separate process, so it could crash without bringing down the rest. 
However, the main pgAdmin process could crash, too, and this should not 
kill the query window processes without allowing data to be saved.

Regards,

Evan


Re: Prevent loss of query text when pgAdmin crashes or freezes

From
Guillaume Lelarge
Date:
On Mon, 2012-07-02 at 12:32 +1000, Evan Martin wrote:
> I often have multiple SQL query windows open in pgAdmin (v1.14.3 on 
> Windows 7 x64). From time to time pgAdmin will crash or freeze (become 
> unresponsive) and would have to be killed. When this happens all unsaved 
> query text is lost, which is extremely frustrating. It's by far the 
> biggest problem for me in using pgAdmin.
> 
> Please implement some way to recover the query text from such crashes. 
> Ideally something like what Firefox or Chrome do: when restarted after a 
> crash they offer the option to restore previous windows (including form 
> data, at least in Chrome). This would require that pgAdmin saves query 
> text in the background on a regular basis (at least before running any 
> query).
> 
> Another great way to mitigate this would be to run each SQL query window 
> in a separate process, so it could crash without bringing down the rest. 
> However, the main pgAdmin process could crash, too, and this should not 
> kill the query window processes without allowing data to be saved.
> 

I though we already had this in our TODO list, but I can't find it. So I
added it.

Thanks for the idea.


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com



Re: Prevent loss of query text when pgAdmin crashes or freezes

From
Dave Page
Date:
On Mon, Jul 2, 2012 at 9:44 PM, Guillaume Lelarge
<guillaume@lelarge.info> wrote:
> On Mon, 2012-07-02 at 12:32 +1000, Evan Martin wrote:
>> I often have multiple SQL query windows open in pgAdmin (v1.14.3 on
>> Windows 7 x64). From time to time pgAdmin will crash or freeze (become
>> unresponsive) and would have to be killed. When this happens all unsaved
>> query text is lost, which is extremely frustrating. It's by far the
>> biggest problem for me in using pgAdmin.
>>
>> Please implement some way to recover the query text from such crashes.
>> Ideally something like what Firefox or Chrome do: when restarted after a
>> crash they offer the option to restore previous windows (including form
>> data, at least in Chrome). This would require that pgAdmin saves query
>> text in the background on a regular basis (at least before running any
>> query).
>>
>> Another great way to mitigate this would be to run each SQL query window
>> in a separate process, so it could crash without bringing down the rest.
>> However, the main pgAdmin process could crash, too, and this should not
>> kill the query window processes without allowing data to be saved.
>>
>
> I though we already had this in our TODO list, but I can't find it. So I
> added it.

I'd far rather see the bug fixed, but without any details that seems
tricky. FWIW, I use pgAdmin on Windows and Mac daily, and don't run
into crashes or hangs.


-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


Re: Prevent loss of query text when pgAdmin crashes or freezes

From
Michal Kozusznik
Date:
pgAdmin crashes from time to time when connection is lost. For example 
when using notebook, with pgAdmin, you often change networks, hibernate, 
suspend, using direct connection or VPN etc
Such changes break connections to databases. I found that closing 
pgAdmin is quicker solution than reconnecting (see bellow). But closing 
it while in this state, often causes pgAdmin crash.

About reconnection: I'm curious when this feature will be finally 
finished. Some, let's say, prototype has been implemented some time ago, 
but using it is annoying. After disconnection, you have to confirm five 
times the need of reconnection when using object browser. When using 
query window, you have run command twice: after asking for reconnection, 
command end up with error; second run finally works.
Currently if I'm connected to multiple databases and lost connection, 
killing pgadmin is fastest way to reconnect ;)
> I'd far rather see the bug fixed, but without any details that seems
> tricky. FWIW, I use pgAdmin on Windows and Mac daily, and don't run
> into crashes or hangs.
>
>




Re: Prevent loss of query text when pgAdmin crashes or freezes

From
Evan Martin
Date:
Fixing the bug and implementing this are not mutually exclusive. Of 
course, it should be fixed, but that's just one bug. I've experienced at 
least 3 different kinds of crashes. This is about mitigating the impact 
of all crashing bugs, which is important, because they will never be 
eliminated completely.

Thanks for adding it to the TODO list, Guillaume. I'll post separately 
about this particular crash if I can reproduce it reliably.

Regards,
Evan

On 3/07/2012 6:28 PM, Dave Page wrote:
> On Mon, Jul 2, 2012 at 9:44 PM, Guillaume Lelarge
> <guillaume@lelarge.info> wrote:
>>
>> I though we already had this in our TODO list, but I can't find it. So I
>> added it.
> I'd far rather see the bug fixed, but without any details that seems
> tricky. FWIW, I use pgAdmin on Windows and Mac daily, and don't run
> into crashes or hangs.
>


Re: Prevent loss of query text when pgAdmin crashes or freezes

From
Dave Page
Date:
On Tue, Jul 3, 2012 at 9:58 AM, Michal Kozusznik
<kozusznik.michal@ifortuna.cz> wrote:
> pgAdmin crashes from time to time when connection is lost. For example when
> using notebook, with pgAdmin, you often change networks, hibernate, suspend,
> using direct connection or VPN etc
> Such changes break connections to databases. I found that closing pgAdmin is
> quicker solution than reconnecting (see bellow). But closing it while in
> this state, often causes pgAdmin crash.
>
> About reconnection: I'm curious when this feature will be finally finished.
> Some, let's say, prototype has been implemented some time ago, but using it
> is annoying. After disconnection, you have to confirm five times the need of
> reconnection when using object browser. When using query window, you have
> run command twice: after asking for reconnection, command end up with error;
> second run finally works.

Rewriting the connection management code to deal with this is far from
a trivial task. It's dependent on someone finding the time to do it.

-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


Re: Prevent loss of query text when pgAdmin crashes or freezes

From
Vik Reykja
Date:
On Tue, Jul 3, 2012 at 12:55 PM, Evan Martin <span dir="ltr"><<a href="mailto:postgresql@realityexists.net"
target="_blank">postgresql@realityexists.net</a>></span>wrote:<br /><div class="gmail_quote"><blockquote
class="gmail_quote"style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"> Fixing the bug and
implementingthis are not mutually exclusive. Of course, it should be fixed, but that's just one bug. I've experienced
atleast 3 different kinds of crashes. This is about mitigating the impact of all crashing bugs, which is important,
becausethey will never be eliminated completely.</blockquote></div><br />Especially if the crash has nothing to do with
pgAdmin(like Windows itself crashing).<br /> 

Re: Prevent loss of query text when pgAdmin crashes or freezes

From
Michal Kozusznik
Date:
<div class="moz-cite-prefix">Please, don't start discussion about windows against linux stability.<br /> I'm working on
W7and I really don't remember if it crashed even once.<br /> I have a collogue who sit next to me, and he also reports
pgadmincrash often. <br /> We suspect that pgadmin has problems with manage disconnections.<br /><br /> Dne 3.7.2012
15:52,Vik Reykja napsal(a):<br /></div><blockquote
cite="mid:CALDgxVuAd+0FsQtAGMs9BskN43tb3W8oiZQgqox+8tfuOLB3=Q@mail.gmail.com"type="cite"> On Tue, Jul 3, 2012 at 12:55
PM,Evan Martin <span dir="ltr"><<a href="mailto:postgresql@realityexists.net" moz-do-not-send="true"
target="_blank">postgresql@realityexists.net</a>></span>wrote:<br /><div class="gmail_quote"><blockquote
class="gmail_quote"style="margin:0 0 0         .8ex;border-left:1px #ccc solid;padding-left:1ex"> Fixing the bug and
implementingthis are not mutually exclusive. Of course, it should be fixed, but that's just one bug. I've experienced
atleast 3 different kinds of crashes. This is about mitigating the impact of all crashing bugs, which is important,
becausethey will never be eliminated completely.</blockquote></div><br /> Especially if the crash has nothing to do
withpgAdmin (like Windows itself crashing).<br /></blockquote><br /><br /><br /> 

Re: Prevent loss of query text when pgAdmin crashes or freezes

From
Michal Kozusznik
Date:
<div class="moz-cite-prefix">I meant a colleague working with Linux <br /><br /> Dne 3.7.2012 16:22, Michal Kozusznik
napsal(a):<br/></div><blockquote cite="mid:4FF30010.4010304@ifortuna.cz" type="cite"><div
class="moz-cite-prefix">Please,don't start discussion about windows against linux stability.<br /> I'm working on W7
andI really don't remember if it crashed even once.<br /> I have a collogue who sit next to me, and he also reports
pgadmincrash often. <br /> We suspect that pgadmin has problems with manage disconnections.<br /><br /> Dne 3.7.2012
15:52,Vik Reykja napsal(a):<br /></div><blockquote
cite="mid:CALDgxVuAd+0FsQtAGMs9BskN43tb3W8oiZQgqox+8tfuOLB3=Q@mail.gmail.com"type="cite"> On Tue, Jul 3, 2012 at 12:55
PM,Evan Martin <span dir="ltr"><<a href="mailto:postgresql@realityexists.net" moz-do-not-send="true"
target="_blank">postgresql@realityexists.net</a>></span>wrote:<br /><div class="gmail_quote"><blockquote
class="gmail_quote"style="margin:0 0 0           .8ex;border-left:1px #ccc solid;padding-left:1ex"> Fixing the bug and
implementingthis are not mutually exclusive. Of course, it should be fixed, but that's just one bug. I've experienced
atleast 3 different kinds of crashes. This is about mitigating the impact of all crashing bugs, which is important,
becausethey will never be eliminated completely.</blockquote></div><br /> Especially if the crash has nothing to do
withpgAdmin (like Windows itself crashing).<br /></blockquote><br /><br /><br /></blockquote><br /><br /> 

Re: Prevent loss of query text when pgAdmin crashes or freezes

From
Vik Reykja
Date:
On Tue, Jul 3, 2012 at 4:22 PM, Michal Kozusznik <kozusznik.michal@ifortuna.cz> wrote:
Please, don't start discussion about windows against linux stability. I'm working on W7 and I really don't remember if it crashed even once.

Please don't top post.

I don't believe I said anything about linux.  You reported using Windows, I also use Windows, it sometimes crashes on me and I lose my work.  That's somewhat my own fault for not saving often enough, but if pgAdmin knew how to recover for me, I'd be happy.

This is not a flame war.
 
I have a collogue who sit next to me, and he also reports pgadmin crash often.
We suspect that pgadmin has problems with manage disconnections.

It certainly does, but that is only one of the ways for a crash.
 

Dne 3.7.2012 15:52, Vik Reykja napsal(a):
On Tue, Jul 3, 2012 at 12:55 PM, Evan Martin <postgresql@realityexists.net> wrote:
Fixing the bug and implementing this are not mutually exclusive. Of course, it should be fixed, but that's just one bug. I've experienced at least 3 different kinds of crashes. This is about mitigating the impact of all crashing bugs, which is important, because they will never be eliminated completely.

Especially if the crash has nothing to do with pgAdmin (like Windows itself crashing).