(Maybe) helpful data surrounding crashes
От | Erwin Brandstetter |
---|---|
Тема | (Maybe) helpful data surrounding crashes |
Дата | |
Msg-id | 47ED533F.3080704@falter.at обсуждение исходный текст |
Ответы |
Re: (Maybe) helpful data surrounding crashes
|
Список | pgadmin-hackers |
Hi developers! Hi Dave! Testing pgAdmin v.1.8.2 (Feb 5 2008), rev: 7050, on WinXP; host: pg 8.2.6 on Debian Etch I have been having occasional crashes with pgAdmin 1.8.x. I still cannot pin down the cause, it only happens like once on a busy day. They have something in common: always when I click on an object in the object browser. This time, after clicking on a schema (the first time since I connected to this database, other databases of the same "server connection"-object already open), while retrieving schema data. Maybe it is of relevance that I have 12 different "server connection"-objects in my object browser. Two of them were open before the crash. Other programs do not normally crash on this machine. This is the tail of my pgAdmin-Log before the crash: -- pgAdmin log start -- (...) 2008-03-28 19:09:27 QUERY : Set query (86.59.118.251:5432): SELECT oid, format_type(oid, typtypmod) AS typname FROM pg_type 2008-03-28 19:09:27 QUERY : Set query (86.59.118.251:5432): SELECT t.oid, t.*, format_type(t.oid, null) AS alias, pg_get_userbyid(t.typowner) as typeowner, e.typname as element, description, ct.oid AS taboid FROM pg_type t LEFT OUTER JOIN pg_type e ON e.oid=t.typelem LEFT OUTER JOIN pg_class ct ON ct.oid=t.typrelid AND ct.relkind <> 'c' LEFT OUTER JOIN pg_description des ON des.objoid=t.oid WHERE t.typtype != 'd' AND t.typname NOT LIKE E'\\_%%' AND t.typnamespace = 153217::oid AND ct.oid IS NULL ORDER BY t.typname 2008-03-28 19:09:27 QUERY : Set query (86.59.118.251:5432): SELECT c.oid, c.xmin, c.relname, pg_get_userbyid(c.relowner) AS viewowner, c.relacl, description, pg_get_viewdef(c.oid, true) AS definition FROM pg_class c LEFT OUTER JOIN pg_description des ON (des.objoid=c.oid and des.objsubid=0) WHERE ((c.relhasrules AND (EXISTS ( SELECT r.rulename FROM pg_rewrite r WHERE ((r.ev_class = c.oid) AND (bpchar(r.ev_type) = '1'::bpchar)) ))) OR (c.relkind = 'v'::char)) AND relnamespace = 153217::oid ORDER BY relname 2008-03-28 19:09:27 STATUS : Retrieving Schema details... (0.23 secs) -- pgAdmin log end -- BTW: 1 '%' is redundant here: ... t.typname NOT LIKE E'\\_%%' ... Regards Erwin
В списке pgadmin-hackers по дате отправления: