Thread: BUG #5679: pgAdminIII 1.12.0 hangs
The following bug has been logged online: Bug reference: 5679 Logged by: Henk Dekker Email address: hdekker@sparxsystems.com.au PostgreSQL version: 9.0.0 Operating system: Windows 7 64-bit Intel Core i7 - 8GB RAM. Description: pgAdminIII 1.12.0 hangs Details: When selecting the query tool, pgAdminIII hangs.
On 27/09/10 07:28, Henk Dekker wrote: > > The following bug has been logged online: > > Bug reference: 5679 > Logged by: Henk Dekker > Email address: hdekker@sparxsystems.com.au > PostgreSQL version: 9.0.0 > Operating system: Windows 7 64-bit Intel Core i7 - 8GB RAM. > Description: pgAdminIII 1.12.0 hangs > Details: > > When selecting the query tool, pgAdminIII hangs. That's odd. Can you give a more detailed step-by-step description of what you do, from launching PgAdmin III to the hang? Does PgAdmin III respond to the close box? Or do you have to End Task it? -- Craig Ringer Tech-related writing: http://soapyfrogs.blogspot.com/
Hi, =20 Thanks for the quick response. =20 Steps leading to hang... =20 1. Start pgAdminIII 2. Double-click localhost server node. 3. Select a database. 4. Click SQL on tool bar (also happens selecting Query Tool from Tools menu= or if I use keyboard shortcut Ctrl+E). 5. Wait cursor appears.=20 6. pgAdminIII title bar shows Not Responding. 7. Clicking Close box brings up Windows Close the Program dialog with detai= ls... =20 Description: A problem caused this program to stop interacting with Windows. Problem signature: Problem Event Name: AppHangB1 Application Name: pgAdmin3.exe Application Version: 1.12.0.99 Application Timestamp: 4c933665 Hang Signature: c917 Hang Type: 0 OS Version: 6.1.7600.2.0.0.256.4 Locale ID: 3081 Additional Hang Signature 1: c9170388cfd5f92aff4ee4abe3f214e6 Additional Hang Signature 2: ba0b Additional Hang Signature 3: ba0bf39aa404420c02aed970d6d989e4 Additional Hang Signature 4: c917 Additional Hang Signature 5: c9170388cfd5f92aff4ee4abe3f214e6 Additional Hang Signature 6: ba0b Additional Hang Signature 7: ba0bf39aa404420c02aed970d6d989e4 HTH =20 Henk Dekker Sparx Systems Pty Ltd support@sparxsystems.com.au http://www.sparxsystems.com.au <http://www.sparxsystems.com.au/>=20=20 =20 =20 ________________________________ From: Craig Ringer [mailto:craig@postnewspapers.com.au] Sent: Mon 27/09/2010 3:38 PM To: Henk Dekker Cc: pgsql-bugs@postgresql.org Subject: Re: [BUGS] BUG #5679: pgAdminIII 1.12.0 hangs On 27/09/10 07:28, Henk Dekker wrote: > > The following bug has been logged online: > > Bug reference: 5679 > Logged by: Henk Dekker > Email address: hdekker@sparxsystems.com.au > PostgreSQL version: 9.0.0 > Operating system: Windows 7 64-bit Intel Core i7 - 8GB RAM. > Description: pgAdminIII 1.12.0 hangs > Details: > > When selecting the query tool, pgAdminIII hangs. That's odd. Can you give a more detailed step-by-step description of what you do, from launching PgAdmin III to the hang? Does PgAdmin III respond to the close box? Or do you have to End Task it? -- Craig Ringer Tech-related writing: http://soapyfrogs.blogspot.com/
On 28/09/10 09:04, Henk Dekker wrote: > Hi, > > Thanks for the quick response. > > Steps leading to hang... OK. When you say "select a database", are you double-clicking on it to connect to that database? Does the red "x" disappear off it, showing it to be connected? Does the problem happen with any database? Or just one? Can you browse the contents of databases, create databases, and perform all other tasks fine? Is it *just* SQL editing that's failing? In your situation, I'd attach a debugger to PgAdmin III and see where it was hung. I don't know if the EnterpriseDB installer packages the .pdb files (debug information) for PgAdmin III, though, and without that a debugger on Windows is pretty useless. I'll have to check when I have access to Windows once I'm home if nobody can confirm sooner. -- Craig Ringer Tech-related writing: http://soapyfrogs.blogspot.com/
Please reply to the list, not just to me. I've CC'd the list in on my reply and preserved your message below, but it's best to CC the list in from the start. Just use "reply all" in your email program. Anyway: the fact that just SQL editing is failing is very odd. Do you have other 64-bit Windows 7 machines? And does the same thing happen on them too? I don't have access to 64-bit Windows 7, only 32-bit, so it's going to be hard for me to test this one out. Hopefully someone else on the list can step up and verify that the SQL editor works fine for them on win7 64-bit (or not) so we can proceed from there. > OK. When you say "select a database", are you double-clicking on it to > connect to that database? > Yes > > Does the red "x" disappear off it, showing it to be connected? > Yes > > Does the problem happen with any database? Or just one? > All databases on all servers > > Can you browse the contents of databases, create databases, and perform > all other tasks fine? Is it *just* SQL editing that's failing? > All other operations appear to be OK - just SQL editing. > > I've attached a document showing steps. -- Craig Ringer Tech-related writing: http://soapyfrogs.blogspot.com/
Hi, I'm having the same problem: Query Tool hangs pgAdminIII. I'm running Windows 7 and first experienced the problem with pgAdmin version 1.12.0 and postgresql 9.0.1. The bizarre thing is, the behavior persists even after a full reinstall (both programs uninstalled, registry keys deleted, net user account removed). I re-uninstalled the programs and upgraded to pgAdminIII 1.12.2 and postgresql 9.0.3-1, and the behavior persists. Any suggestions? I believe the behavior started after trying to run a very large (~100Mb) query, the product of xml2sql (to parse part of a wikipedia dump). But that doesn't explain the persistence after reinstall, since I also deleted all the log files (all I could find at least). Thanks in advance, Chris -- View this message in context: http://postgresql.1045698.n5.nabble.com/BUG-5679-pgAdminIII-1-12-0-hangs-tp2854737p3372675.html Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.
I too am experiencing this problem, which has only appeared today. I have been running queries against million-record sized tables...so it was using probably a bunch of memory. My entire computer froze mid-work as I was typing in a query (not running it), and I had to hard-reboot...now i can't run the query tool. Could it be a result of the hard-reboot? -- View this message in context: http://postgresql.1045698.n5.nabble.com/BUG-5679-pgAdminIII-1-12-0-hangs-tp2854737p3390239.html Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.
On Thu, Feb 17, 2011 at 5:05 PM, gunziptarball <jackson@rcgis.com> wrote: > > I too am experiencing this problem, which has only appeared today. =A0I h= ave > been running queries against million-record sized tables...so it was using > probably a bunch of memory. =A0My entire computer froze mid-work as I was > typing in a query (not running it), and I had to hard-reboot...now i can't > run the query tool. You probably need to try the pgadmin-support list: http://www.pgadmin.org/support/list.php This list is for bugs in core PostgreSQL. --=20 Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
Thank You, Sir, I have repaired this big currectly just by deleting the postgresql under the Application directory of my user under Document and Setting, that's perfect and clever, why You do post your name on the advice, that's smart. Email to: quanhaqub@yahoo.com Ha Le. -- View this message in context: http://postgresql.1045698.n5.nabble.com/BUG-5679-pgAdminIII-1-12-0-hangs-tp2854737p5473283.html Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.