(Maybe) helpful data surrounding crashes

From: Erwin Brandstetter <brandstetter(at)falter(dot)at>
To: pgadmin-hackers(at)postgresql(dot)org
Subject: (Maybe) helpful data surrounding crashes
Date: 2008-03-28 20:21:19
Message-ID: 47ED533F.3080704@falter.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message svn 2008-03-31 13:22:15 SVN Commit by dpage: r7207 - trunk/www/development
Previous Message Erwin Brandstetter 2008-03-28 20:16:28 Errors & notices in pgAdmin log-files broken