Обсуждение: pgAdmin v1.22.0 keeps freezing and crashing

I'm running Windows 7  64-bit and had recently upgraded to pgAdmin v1.22.0.
It seems though that quite frequently when I run a long-running query,
pgAdmin freezes.
Also if for example I restart my PostgreSQL service while I am connected,
pgAdmin crashes.

I've since been forced to downgrade back to pgAdmin 1.20.

My husband has the same issue on his computer, though could be how we have
our setups configured in a similar way.

I did talk to someone else who said when she was running the PostGIS
shp2pgsql-gui plugin  on v1.22.0 it would crash (windows 7 32-bit), 
so she reverted too back to v1.20 and problem went away.


Thanks,
Regina

<div style="color:#000; background-color:#fff; font-family:Courier New, courier, monaco, monospace,
sans-serif;font-size:24px"><divdir="ltr" id="yui_3_16_0_1_1453584792538_4166">I'm not an expert, but believe the
problemis that</div><div dir="ltr" id="yui_3_16_0_1_1453584792538_4227">PgAdmin v1.22 does not play nice with any
version<br /></div><div dir="ltr" id="yui_3_16_0_1_1453584792538_4253">of Windows other than Windows 10.</div><div
dir="ltr"id="yui_3_16_0_1_1453584792538_4293"><br /></div><div dir="ltr" id="yui_3_16_0_1_1453584792538_4294">Currently
Iam using with on Windows 10 with no problem.</div><div dir="ltr" id="yui_3_16_0_1_1453584792538_4295"><br /></div><div
dir="ltr"id="yui_3_16_0_1_1453584792538_4165"><span id="yui_3_16_0_1_1453584792538_4297">I know that is not what you
wantto hear, but I did want to <br /></span></div><div dir="ltr" id="yui_3_16_0_1_1453584792538_4299"><span
id="yui_3_16_0_1_1453584792538_4298">provideyou with at least my feedback.</span></div><div
id="yui_3_16_0_1_1453584792538_4164"> </div><divclass="signature" id="yui_3_16_0_1_1453584792538_4152"><div
id="RTEContent"><fontid="yui_3_16_0_1_1453584792538_4162" size="4"><span id="yui_3_16_0_1_1453584792538_4163"
style="font-weight:bold;font-family:arial;color:rgb(0,0, 255);">Melvin Davidson </span></font><br /><br /><font
id="yui_3_16_0_1_1453584792538_4151"size="3" style="font-weight:bold;"><span id="yui_3_16_0_1_1453584792538_4150"
style="color:rgb(128,0, 255);">I reserve the right to fantasize.  Whether or not you </span><br style="color:rgb(128,
0,255);" /><span id="yui_3_16_0_1_1453584792538_4159" style="color:rgb(128, 0, 255);">wish to share my fantasy is
entirelyup to you. </span><img data-id="f7c51518-db93-cdf2-ac67-be2196f920e1"
src="http://us.i1.yimg.com/us.yimg.com/i/mesg/tsmileys2/01.gif"style="color:rgb(128, 0, 255);" /><br /><br
/>www.youtube.com/unusedhero<brstyle="color:rgb(128, 0, 255);" /></font><br /><font
id="yui_3_16_0_1_1453584792538_4301"size="3"><span id="yui_3_16_0_1_1453584792538_4300"
style="font-weight:bold;font-family:courier;">FolkAlley - All Folk - 24 Hours a day </span><span
style="font-weight:bold;font-family:courier;"><br/>www.folkalley.com<br /><br /></span></font></div></div><br /><div
class="qtdSeparateBR"id="yui_3_16_0_1_1453584792538_4210"><br /><br /></div><div class="yahoo_quoted"
id="yui_3_16_0_1_1453584792538_4207"style="display: block;"><div id="yui_3_16_0_1_1453584792538_4206"
style="font-family:Courier New, courier, monaco, monospace, sans-serif; font-size: 24px;"><div
id="yui_3_16_0_1_1453584792538_4205"style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande,
sans-serif;font-size: 16px;"><div dir="ltr" id="yui_3_16_0_1_1453584792538_4209"><font face="Arial" size="2"><hr
size="1"/><b><span style="font-weight:bold;">From:</span></b> Regina Obe <lr@pcorp.us><br /><b><span
style="font-weight:bold;">To:</span></b> pgadmin-support@postgresql.org <br /><b><span style="font-weight:
bold;">Sent:</span></b>Saturday, January 23, 2016 3:49 PM<br /><b><span style="font-weight: bold;">Subject:</span></b>
[pgadmin-support]pgAdmin v1.22.0 keeps freezing and crashing<br /></font></div><div class="y_msg_container"
id="yui_3_16_0_1_1453584792538_4204"><br/>I'm running Windows 7  64-bit and had recently upgraded to pgAdmin
v1.22.0.<br/>It seems though that quite frequently when I run a long-running query,<br />pgAdmin freezes.<br />Also if
forexample I restart my PostgreSQL service while I am connected,<br />pgAdmin crashes.<br /><br />I've since been
forcedto downgrade back to pgAdmin 1.20.<br /><br />My husband has the same issue on his computer, though could be how
wehave<br />our setups configured in a similar way.<br /><br />I did talk to someone else who said when she was running
thePostGIS<br />shp2pgsql-gui plugin  on v1.22.0 it would crash (windows 7 32-bit), <br />so she reverted too back to
v1.20and problem went away.<br /><br /><br />Thanks,<br />Regina<br /><br /><br /><br /><br />-- <br />Sent via
pgadmin-supportmailing list (<a href="mailto:pgadmin-support@postgresql.org"
ymailto="mailto:pgadmin-support@postgresql.org">pgadmin-support@postgresql.org</a>)<br/>To make changes to your
subscription:<br/><a href="http://www.postgresql.org/mailpref/pgadmin-support"
target="_blank">http://www.postgresql.org/mailpref/pgadmin-support</a><br/><br /><br /></div></div></div></div></div> 

On 23/01/2016 21:37, Melvin Davidson wrote:
> I'm not an expert, but believe the problem is that
> PgAdmin v1.22 does not play nice with any version
> of Windows other than Windows 10.
> 
> Currently I am using with on Windows 10 with no problem.

I'm running it on Windows 7 (64-bit) without any problem (so far anyway;
fairly light use).

Ray.


-- 
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

On Sat, Jan 23, 2016 at 8:49 PM, Regina Obe <lr@pcorp.us> wrote:
> I'm running Windows 7  64-bit and had recently upgraded to pgAdmin v1.22.0.
> It seems though that quite frequently when I run a long-running query,
> pgAdmin freezes.

Does you machine go to sleep or anything like that when it crashes?

> Also if for example I restart my PostgreSQL service while I am connected,
> pgAdmin crashes.

Yeah, pgAdmin 3 has never handled that well. That's one of the things
that's being fixed in pgAdmin 4.

> I've since been forced to downgrade back to pgAdmin 1.20.
>
> My husband has the same issue on his computer, though could be how we have
> our setups configured in a similar way.
>
> I did talk to someone else who said when she was running the PostGIS
> shp2pgsql-gui plugin  on v1.22.0 it would crash (windows 7 32-bit),
> so she reverted too back to v1.20 and problem went away.

Oh? The plugins are simply tools that are launched in their own
processes - and that code hasn't changed since 1.20. Does it crash
immediately? Is it pgAdmin or the plugin that crashes?

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

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

> -----Original Message-----
> From: Dave Page [mailto:dpage@pgadmin.org]
> Sent: Monday, January 25, 2016 4:11 AM
> To: Regina Obe <lr@pcorp.us>
> Cc: pgAdmin Support <pgadmin-support@postgresql.org>
> Subject: Re: [pgadmin-support] pgAdmin v1.22.0 keeps freezing and crashing

> On Sat, Jan 23, 2016 at 8:49 PM, Regina Obe <lr@pcorp.us> wrote:
> I'm running Windows 7  64-bit and had recently upgraded to pgAdmin v1.22.0.
> It seems though that quite frequently when I run a long-running query,
> pgAdmin freezes.

> Does you machine go to sleep or anything like that when it crashes?
No

>> I've since been forced to downgrade back to pgAdmin 1.20.
>>
>> My husband has the same issue on his computer, though could be how we
>> have our setups configured in a similar way.
>>
>> I did talk to someone else who said when she was running the PostGIS
>> shp2pgsql-gui plugin  on v1.22.0 it would crash (windows 7 32-bit), so
>>  she reverted too back to v1.20 and problem went away.

> Oh? The plugins are simply tools that are launched in their own processes - and that code hasn't changed since 1.20.
Doesit crash immediately? Is it pgAdmin or the plugin that crashes? 

Well the postgis-gui plugin is compiled with mingw64 and is  the one distributed with PostGIS 2.2 one (not that it
matterssince that code has not changed in a while). I have to test this myself.  My friend was using a Windows 7 32-bit
andthe screen she showed me, it gave some sort of VC++ debug error before it crashed (so doesn't seem like it is
crashingin the plugin though the error does suggest that) 
As I recall, I think she got as far as the PostGIS-GUI (shp2pgsql-gui) showing her the list of tables and it was when
sheproceeded to export was when it crashed. 
Again I'll have to check this for myself, since she only sent me a screen shot.  Attached is the screen shot she sent
me. She said when she uninstalled 1.22 and reinstalled 1.20 things were okay. 
I usually just use the shp2pgsql command line since it's more efficient for larger tables and I can script it.

Thanks,
Regina

On Mon, Jan 25, 2016 at 9:40 AM, Regina Obe <lr@pcorp.us> wrote:
>> -----Original Message-----
>> From: Dave Page [mailto:dpage@pgadmin.org]
>> Sent: Monday, January 25, 2016 4:11 AM
>> To: Regina Obe <lr@pcorp.us>
>> Cc: pgAdmin Support <pgadmin-support@postgresql.org>
>> Subject: Re: [pgadmin-support] pgAdmin v1.22.0 keeps freezing and crashing
>
>> On Sat, Jan 23, 2016 at 8:49 PM, Regina Obe <lr@pcorp.us> wrote:
>> I'm running Windows 7  64-bit and had recently upgraded to pgAdmin v1.22.0.
>> It seems though that quite frequently when I run a long-running query,
>> pgAdmin freezes.
>
>> Does you machine go to sleep or anything like that when it crashes?
> No
>
>>> I've since been forced to downgrade back to pgAdmin 1.20.
>>>
>>> My husband has the same issue on his computer, though could be how we
>>> have our setups configured in a similar way.
>>>
>>> I did talk to someone else who said when she was running the PostGIS
>>> shp2pgsql-gui plugin  on v1.22.0 it would crash (windows 7 32-bit), so
>>>  she reverted too back to v1.20 and problem went away.
>
>> Oh? The plugins are simply tools that are launched in their own processes - and that code hasn't changed since 1.20.
Doesit crash immediately? Is it pgAdmin or the plugin that crashes?
 
>
> Well the postgis-gui plugin is compiled with mingw64 and is  the one distributed with PostGIS 2.2 one (not that it
matterssince that code has not changed in a while).
 
>  I have to test this myself.  My friend was using a Windows 7 32-bit and the screen she showed me, it gave some sort
ofVC++ debug error before it crashed (so doesn't seem like it is crashing in the plugin though the error does suggest
that)
> As I recall, I think she got as far as the PostGIS-GUI (shp2pgsql-gui) showing her the list of tables and it was when
sheproceeded to export was when it crashed.
 
> Again I'll have to check this for myself, since she only sent me a screen shot.  Attached is the screen shot she sent
me. She said when she uninstalled 1.22 and reinstalled 1.20 things were okay.
 
> I usually just use the shp2pgsql command line since it's more efficient for larger tables and I can script it.

Ahh, well that crash is clearly not in the pgAdmin code. Could
shp2pgsql be using pgAdmin's libpq and related libraries?


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

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

>  Ahh, well that crash is clearly not in the pgAdmin code. Could shp2pgsql be using pgAdmin's libpq and related
libraries?

Yes shp2pgsql-gui  does use pgAdmin's libpq and related libraries

On Mon, Jan 25, 2016 at 11:03 AM, Regina Obe <lr@pcorp.us> wrote:
>
>>  Ahh, well that crash is clearly not in the pgAdmin code. Could shp2pgsql be using pgAdmin's libpq and related
libraries?
>
> Yes shp2pgsql-gui  does use pgAdmin's libpq and related libraries

Perhaps an incompatibility there? Do you know if it was built against
the 9.5 versions?

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

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

Yes built against 9.5.  Though keep in mind I'm not really concerned about that.  That's just a possibly related data
point.

I'm concerned about random freezing  when running  queries in SQL Window that are say longer than 1 minute, which
doesn'tinvolve any plugins, just pgAdmin 1.22.0. 

I asked my husband who is more affected by it than I am and he said when he runs a long enough query like a 1 minute or
longerquery it freezes his other applications, like his Outlook for example. 
So he reverted back to pgAdmin 1.20 to avoid the problem.


Thanks,
Regina



-----Original Message-----
From: Dave Page [mailto:dpage@pgadmin.org]
Sent: Monday, January 25, 2016 6:05 AM
To: Regina Obe <lr@pcorp.us>
Cc: pgAdmin Support <pgadmin-support@postgresql.org>
Subject: Re: [pgadmin-support] pgAdmin v1.22.0 keeps freezing and crashing

On Mon, Jan 25, 2016 at 11:03 AM, Regina Obe <lr@pcorp.us> wrote:
>
>>  Ahh, well that crash is clearly not in the pgAdmin code. Could shp2pgsql be using pgAdmin's libpq and related
libraries?
>
> Yes shp2pgsql-gui  does use pgAdmin's libpq and related libraries

Perhaps an incompatibility there? Do you know if it was built against the 9.5 versions?

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

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

On Mon, Jan 25, 2016 at 11:54 AM, Regina Obe <lr@pcorp.us> wrote:
> Yes built against 9.5.  Though keep in mind I'm not really concerned about that.  That's just a possibly related data
point.
>
> I'm concerned about random freezing  when running  queries in SQL Window that are say longer than 1 minute, which
doesn'tinvolve any plugins, just pgAdmin 1.22.0.
 
>
> I asked my husband who is more affected by it than I am and he said when he runs a long enough query like a 1 minute
orlonger query it freezes his other applications, like his Outlook for example.
 
> So he reverted back to pgAdmin 1.20 to avoid the problem.

If you put a copy of the 1.22 binary in a directory with copies of the
1.20 libpq/libssl etc, does it still crash?


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

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