Skip site navigation (1) Skip section navigation (2)

(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 (view raw or flat)
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

pgadmin-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group