Re: pgAdmin ver 1.10 freezing all too frequently

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Ok. please disregard that last one... :)

This is the last output of valgrind before I had to kill pgadmin:

==671== Thread 2:
==671== Syscall param write(buf) points to uninitialised byte(s)
==671==    at 0xBC4F4B: (within /lib/libpthread-2.10.1.so)
==671==    by 0x6149EE: BIO_write (in /usr/lib/libcrypto.so.0.9.8k)
==671==    by 0x742F93: ssl3_write_pending (in /usr/lib/libssl.so.0.9.8k)
==671==    by 0x743350: (within /usr/lib/libssl.so.0.9.8k)
==671==    by 0x743688: ssl3_write_bytes (in /usr/lib/libssl.so.0.9.8k)
==671==    by 0x7408A0: ssl3_write (in /usr/lib/libssl.so.0.9.8k)
==671==    by 0x7538B8: SSL_write (in /usr/lib/libssl.so.0.9.8k)
==671==    by 0x4B5995C: (within /usr/lib/libpq.so.5.1)
==671==    by 0x4B51316: (within /usr/lib/libpq.so.5.1)
==671==    by 0x4B4EBE7: PQsendQuery (in /usr/lib/libpq.so.5.1)
==671==    by 0x80D337B: pgQueryThread::execute() (pgQueryThread.cpp:104)
==671==    by 0x80D3A34: pgQueryThread::Entry() (pgQueryThread.cpp:210)
==671==  Address 0x933685d is 5 bytes inside a block of size 18,698
alloc'd
==671==    at 0x4006F3D: malloc (vg_replace_malloc.c:207)
==671==    by 0x6A05CD: (within /usr/lib/libcrypto.so.0.9.8k)
==671==    by 0x6A0C5B: CRYPTO_malloc (in /usr/lib/libcrypto.so.0.9.8k)
==671==    by 0x744BF8: ssl3_setup_buffers (in /usr/lib/libssl.so.0.9.8k)
==671==    by 0x73FDEF: ssl3_connect (in /usr/lib/libssl.so.0.9.8k)
==671==    by 0x753CA9: SSL_connect (in /usr/lib/libssl.so.0.9.8k)
==671==    by 0x4B59EFA: (within /usr/lib/libpq.so.5.1)
==671==    by 0x4B4A165: PQconnectPoll (in /usr/lib/libpq.so.5.1)
==671==    by 0x4B4AD67: (within /usr/lib/libpq.so.5.1)
==671==    by 0x4B4D342: PQconnectdb (in /usr/lib/libpq.so.5.1)
==671==    by 0x80CC832: pgConn::pgConn(wxString const&, wxString
const&, wxString const&, wxString const&, int, int, unsigned long)
(pgConn.cpp:175)
==671==    by 0x82F8778: pgServer::CreateConn(wxString, unsigned long)
(pgServer.cpp:140)
- --671-- memcheck GC: 131072 nodes, 114351 survivors ( 87.2%)
- --671-- memcheck GC: increase table size to 262144
Killed


At this point the app is irresponsive after I tried to access another
of the DB's objects..

Please tell me what more can I do on this end... ;)

BR,
Pedro Doria Meunier





On 11/11/2009 06:57 PM, Pedro Doria Meunier wrote:
> Hi Dave
>
> Did as you asked...
>
> problem: ./pgadmin3: error while loading shared libraries:
> libwx_gtk2ud_stc-2.8.so.0: cannot open shared object file: No such
> file or directory (on execution, after compilation)
>
> This library is nowhere to be found...
>
> Do you by any change have a debug-enable version of pgadmin3 on
> your hands? ;)
>
> BR, Pedro Doria Meunier
>
> On 11/11/2009 03:39 PM, Dave Page wrote:
>> On Wed, Nov 11, 2009 at 3:36 PM, Pedro Doria Meunier
>> <pdoria@netmadeira.com> wrote:
>>> -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
>>>
>>> I'm "glad" :] I'm not alone in this...
>>>
>>> It's definitely not the router. It's something else...
>>>
>>> For instance:
>>>
>>> - - One opens a table. leave it be for some time and the next
>>> operation freezes pgAdmin, especially if one tries to open
>>> another database object (or another database).
>>>
>>> - - If the SAME object is closed and then re-opened, no matter
>>> what time it takes, it opens without a problem.
>>>
>>> I use pgAdmin *intensively* and it's becoming *inpractical* to
>>> work with it to my great sorrow...
>>>
>>> I sure hope the gurus come up with a fix for this... ;)
>
>> Being completely unable to reproduce the problem makes that
>> extremely unlikely I'm afraid.
>
>> Can you reproduce the problem with a debug-enabled build, and
>> then attach a debugger and get a backtrace?
>
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/

iEYEARECAAYFAkr7F+IACgkQ2FH5GXCfxAu5NwCdFdY0s37PXJN4GkG4UEyYyzKD
IaEAn2zjsByg761rXDTF5u09zRU3em99
=fJnB
-----END PGP SIGNATURE-----