pgAdmin - crashes when connection is lost.

On 07.12.2012 10:29, Dave Page wrote:
> On Thu, Dec 6, 2012 at 11:32 PM, Andrzej Zawadzki <zawadaa@wp.pl> wrote:
>> BTW: why pgadmin crashes when I want renew connection after network
>> change or postgresql server restart - this is very old issue.
>> I observe it on Linux, Windows and Mac.
> That's been surprisingly difficult to fix, because of the amount of
> application state it affects. It should, for the most part, detect the
> situation and offer to reconnect and reset everything these days. If
> you can find a reproducible case where that doesn't happen, please
> report it with as many details as possible.
Hi,
after some time... ;-)
my friend, who very often change his location (laptop suspend) and uses
pgadmin very intensively ,complain about crashes when switching location.

He send me backtrace:

(gdb) thread apply all bt full

Thread 5 (Thread 0x7fffd96fd700 (LWP 9190)):
#0  0x00007ffff4b3219d in poll () at ../sysdeps/unix/syscall-template.S:81
No locals.
#1  0x00007ffff1f35194 in ?? () from /lib/x86_64-linux-gnu/libglib-2.0.so.0
No symbol table info available.
#2  0x00007ffff1f3529c in g_main_context_iteration () from
/lib/x86_64-linux-gnu/libglib-2.0.so.0
No symbol table info available.
#3  0x00007ffff1f352e9 in ?? () from /lib/x86_64-linux-gnu/libglib-2.0.so.0
No symbol table info available.
#4  0x00007ffff1f591d5 in ?? () from /lib/x86_64-linux-gnu/libglib-2.0.so.0
No symbol table info available.
#5  0x00007ffff4e08e0e in start_thread (arg=0x7fffd96fd700) at
pthread_create.c:311       __res = <optimized out>       pd = 0x7fffd96fd700       now = <optimized out>
unwind_buf= {cancel_jmp_buf = {{jmp_buf = {140736841373440,
 
7972335546361501811, 1, 140736858154800, 4096, 140736841373440,
-7972252945951958925, -7972350791820846989}, mask_was_saved = 0}},         priv = {pad = {0x0, 0x0, 0x0, 0x0}, data =
{prev= 0x0,
 
cleanup = 0x0, canceltype = 0}}}       not_first_call = 0       pagesize_m1 = <optimized out>       sp = <optimized
out>      freesize = <optimized out>       __PRETTY_FUNCTION__ = "start_thread"
 
#6  0x00007ffff4b3d93d in clone () at
../sysdeps/unix/sysv/linux/x86_64/clone.S:113
No locals.

Thread 2 (Thread 0x7fffdb11d700 (LWP 9187)):
#0  0x00007ffff4b3219d in poll () at ../sysdeps/unix/syscall-template.S:81
No locals.
#1  0x00007ffff1f35194 in ?? () from /lib/x86_64-linux-gnu/libglib-2.0.so.0
No symbol table info available.
#2  0x00007ffff1f355fa in g_main_loop_run () from
/lib/x86_64-linux-gnu/libglib-2.0.so.0
No symbol table info available.
#3  0x00007ffff3262cf6 in ?? () from
/usr/lib/x86_64-linux-gnu/libgio-2.0.so.0
No symbol table info available.
#4  0x00007ffff1f591d5 in ?? () from /lib/x86_64-linux-gnu/libglib-2.0.so.0
No symbol table info available.
#5  0x00007ffff4e08e0e in start_thread (arg=0x7fffdb11d700) at
pthread_create.c:311       __res = <optimized out>       pd = 0x7fffdb11d700       now = <optimized out>
unwind_buf= {cancel_jmp_buf = {{jmp_buf = {140736868767488,
 
7972335546361501811, 1, 140737488339344, 4096, 140736868767488,
-7972256639623833485, -7972350791820846989}, mask_was_saved = 0}},         priv = {pad = {0x0, 0x0, 0x0, 0x0}, data =
{prev= 0x0,
 
cleanup = 0x0, canceltype = 0}}}       not_first_call = 0       pagesize_m1 = <optimized out>       sp = <optimized
out>      freesize = <optimized out>       __PRETTY_FUNCTION__ = "start_thread"
 
#6  0x00007ffff4b3d93d in clone () at
../sysdeps/unix/sysv/linux/x86_64/clone.S:113
No locals.

Thread 1 (Thread 0x7ffff7fa9a00 (LWP 5522)):
#0  0x00007ffff4b3219d in poll () at ../sysdeps/unix/syscall-template.S:81
No locals.
#1  0x00007ffff584cb0e in ?? () from /usr/lib/libpq.so.5
No symbol table info available.
#2  0x00007ffff584cb90 in ?? () from /usr/lib/libpq.so.5
No symbol table info available.
#3  0x00007ffff584af79 in PQgetResult () from /usr/lib/libpq.so.5
No symbol table info available.
#4  0x00007ffff584b2ce in ?? () from /usr/lib/libpq.so.5
No symbol table info available.
#5  0x00000000004c0126 in pgConn::ExecuteSet (this=0x2aea500, sql=...)
at ./db/pgConn.cpp:785       qryRes = <optimized out>
#6  0x00000000007467b9 in pgDatabase::ExecuteSet (this=0x1cb3880,
sql=...) at ./schema/pgDatabase.cpp:359       set = 0x0
#7  0x000000000077ae84 in pgIndexBaseFactory::CreateObjects
(this=this@entry=0xe23ae0 <indexFactory>, coll=coll@entry=0x29bb270,
browser=browser@entry=0x1b05800, restriction=...)   at ./schema/pgIndex.cpp:560       collection = 0x29bb270
projoin= {<wxStringBase> = {static npos = 18446744073709551615,
 
m_pchData = 0x29e7e18 L"  LEFT OUTER JOIN pg_tablespace ta on
ta.oid=cls.reltablespace\n"}, <No data fields>}       index = 0x0       query = {<wxStringBase> = {static npos =
18446744073709551615,          m_pchData = 0x2bc9fb8 L"SELECT DISTINCT ON(cls.relname)
 
cls.oid, cls.relname as idxname, indrelid, indkey, indisclustered,
indisunique, indisprimary, n.nspname,\n       indnatts,
cls.reltablespace AS spcoid, spcname, tab.reln"...}, <No data fields>}       proname = {<wxStringBase> = {static npos =
18446744073709551615,
m_pchData = 0x1cac348 L"indnatts, cls.reltablespace AS spcoid, spcname,
"}, <No data fields>}       indexes = <optimized out>
#8  0x000000000077c296 in pgIndexFactory::CreateObjects (this=0xe23ae0
<indexFactory>, collection=0x29bb270, browser=0x1b05800,
restriction=...) at ./schema/pgIndex.cpp:654
No locals.
#9  0x0000000000731950 in pgCollection::ShowTreeDetail (this=0x29bb270,
browser=0x1b05800, form=<optimized out>, properties=0x0,
sqlPane=<optimized out>) at ./schema/pgCollection.cpp:139
No locals.
#10 0x00000000007cf6f7 in pgTable::AppendStuff
(this=this@entry=0x2bb4fd0, sql=..., browser=browser@entry=0x1b05800,
factory=...) at ./schema/pgTable.cpp:254       idxIt = {lastItem = {m_pItem = 0x0}, browser = 0x2bb4fd0, object
= 0xffffffffffffffff, cookie = 0x7fffffffd9f0}       obj = <optimized out>       tmp = {<wxStringBase> = {static npos =
18446744073709551615,
m_pchData = 0x1ca7ae8 L"\n"}, <No data fields>}       collection = 0x29bb270
#11 0x00000000007d251f in pgTable::GetSql (this=0x2bb4fd0,
browser=0x1b05800) at ./schema/pgTable.cpp:672       consCount = 1       constraints = 0x2bb5340       columns =
<optimizedout>       colDetails = {<wxStringBase> = {static npos =
 
18446744073709551615, m_pchData = 0x7ffff610cbb8 L""}, <No data fields>}       conDetails = {<wxStringBase> = {static
npos=
 
18446744073709551615, m_pchData = 0x7ffff610cbb8 L""}, <No data fields>}       cols_sql = {<wxStringBase> = {static
npos= 18446744073709551615,           m_pchData = 0x2a17ca8 L"  id serial NOT NULL,\n  name
 
character varying(255),\n  CONSTRAINT countries_pkey PRIMARY KEY (id)"},
<No data fields>}       columnPrivileges = {<wxStringBase> = {static npos =
18446744073709551615, m_pchData = 0x7ffff610cbb8 L""}, <No data fields>}       prevComment = {<wxStringBase> = {static
npos=
 
18446744073709551615, m_pchData = 0x7ffff610cbb8 L""}, <No data fields>}
#12 0x0000000000607cf8 in frmMain::setDisplay
(this=this@entry=0x1a19ff0, data=0x2bb4fd0, props=<optimized out>,
sqlbox=0x1b64230) at ./frm/events.cpp:522       conn = <optimized out>       i = <optimized out>       indivMenu =
<optimizedout>       server = <optimized out>
 
#13 0x000000000060824c in frmMain::execSelChange (this=0x1a19ff0,
item=..., currentNode=currentNode@entry=true) at ./frm/events.cpp:484       refresh = true
#14 0x00000000006086fe in frmMain::OnTreeSelChanged (this=<optimized
out>, event=...) at ./frm/events.cpp:375       event = <optimized out>       this = <optimized out>
#15 0x00007ffff60eb9c6 in
wxEvtHandler::ProcessEventIfMatches(wxEventTableEntryBase const&,
wxEvtHandler*, wxEvent&) () from
/usr/lib/x86_64-linux-gnu/libwx_baseu-2.8.so.0
No symbol table info available.
#16 0x00007ffff60ebb34 in wxEventHashTable::HandleEvent(wxEvent&,
wxEvtHandler*) () from /usr/lib/x86_64-linux-gnu/libwx_baseu-2.8.so.0
No symbol table info available.
#17 0x00007ffff60ebe57 in wxEvtHandler::ProcessEvent(wxEvent&) () from
/usr/lib/x86_64-linux-gnu/libwx_baseu-2.8.so.0
No symbol table info available.
#18 0x00007ffff60ebde0 in wxEvtHandler::ProcessEvent(wxEvent&) () from
/usr/lib/x86_64-linux-gnu/libwx_baseu-2.8.so.0
No symbol table info available.
#19 0x00007ffff6a58e29 in wxWindowBase::TryParent(wxEvent&) () from
/usr/lib/x86_64-linux-gnu/libwx_gtk2u_core-2.8.so.0
No symbol table info available.
#20 0x00007ffff60ebde0 in wxEvtHandler::ProcessEvent(wxEvent&) () from
/usr/lib/x86_64-linux-gnu/libwx_baseu-2.8.so.0
No symbol table info available.
#21 0x00007ffff6a7e7a5 in
wxScrollHelperEvtHandler::ProcessEvent(wxEvent&) () from
/usr/lib/x86_64-linux-gnu/libwx_gtk2u_core-2.8.so.0
No symbol table info available.
#22 0x00007ffff6a8a4b9 in wxGenericTreeCtrl::DoSelectItem(wxTreeItemId
const&, bool, bool) () from
/usr/lib/x86_64-linux-gnu/libwx_gtk2u_core-2.8.so.0
No symbol table info available.
#23 0x00007ffff6a8b329 in wxGenericTreeCtrl::SelectItem(wxTreeItemId
const&, bool) () from /usr/lib/x86_64-linux-gnu/libwx_gtk2u_core-2.8.so.0
No symbol table info available.
#24 0x00007ffff6a8cda8 in wxGenericTreeCtrl::OnInternalIdle() () from
/usr/lib/x86_64-linux-gnu/libwx_gtk2u_core-2.8.so.0
No symbol table info available.
#25 0x00007ffff69ed6df in wxAppBase::SendIdleEvents(wxWindow*,
wxIdleEvent&) () from /usr/lib/x86_64-linux-gnu/libwx_gtk2u_core-2.8.so.0
No symbol table info available.
#26 0x00007ffff69ed714 in wxAppBase::SendIdleEvents(wxWindow*,
wxIdleEvent&) () from /usr/lib/x86_64-linux-gnu/libwx_gtk2u_core-2.8.so.0
No symbol table info available.
#27 0x00007ffff69edbf4 in wxAppBase::ProcessIdle() () from
/usr/lib/x86_64-linux-gnu/libwx_gtk2u_core-2.8.so.0
No symbol table info available.
#28 0x00007ffff69714ae in ?? () from
/usr/lib/x86_64-linux-gnu/libwx_gtk2u_core-2.8.so.0
No symbol table info available.
#29 0x00007ffff1f34ea6 in g_main_context_dispatch () from
/lib/x86_64-linux-gnu/libglib-2.0.so.0
No symbol table info available.
#30 0x00007ffff1f351f8 in ?? () from /lib/x86_64-linux-gnu/libglib-2.0.so.0
No symbol table info available.
#31 0x00007ffff1f355fa in g_main_loop_run () from
/lib/x86_64-linux-gnu/libglib-2.0.so.0
No symbol table info available.
#32 0x00007ffff3af6257 in gtk_main () from
/usr/lib/x86_64-linux-gnu/libgtk-x11-2.0.so.0
No symbol table info available.
#33 0x00007ffff6984f98 in wxEventLoop::Run() () from
/usr/lib/x86_64-linux-gnu/libwx_gtk2u_core-2.8.so.0
No symbol table info available.
#34 0x00007ffff69ed99c in wxAppBase::MainLoop() () from
/usr/lib/x86_64-linux-gnu/libwx_gtk2u_core-2.8.so.0
No symbol table info available.
#35 0x00007ffff609d625 in wxEntry(int&, wchar_t**) () from
/usr/lib/x86_64-linux-gnu/libwx_baseu-2.8.so.0
No symbol table info available.
#36 0x0000000000440942 in main (argc=1, argv=<optimized out>) at
./pgAdmin3.cpp:120
No locals.

Sometimes if you have a few windows with queries it's not nice to got
such crash...
Is this backtrace helpful?

-- 
Andrzej Zawadzki