Re: pgAdmin - crashes when connection is lost. - Mailing list pgadmin-support

Hi Ashesh,

Can you put this on the TODO list (for you, or one of the team)? We
may not be easily able to solve all such cases without a major
rewrite, but if this scenario is reproducible on master, hopefully we
can at least eliminate this one.

Thanks.

On Wed, Jul 24, 2013 at 10:27 AM, Andrzej Zawadzki <zawadaa@wp.pl> wrote:
> 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 = <optimized out>
>         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 = <optimized out>
>         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



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

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