view data causes pgadmin to hang or die

From: Miha Radej <miha(dot)radej(at)siix(dot)com>
To: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: view data causes pgadmin to hang or die
Date: 2006-03-24 12:49:19
Message-ID: 4423EACF.1020602@siix.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

hi!

i have a table with 204 rows of data which contain about 700k of text
alltogether. when i tried to use "view data" in the table, pgadmin
either crashes or hangs, no apparent pattern so far. in pgadmin log, set
to debug, there is nothing to indicate the problem. but according to it
(and to pgsql log) it seems pgadmin gets the data, then sends a query to
get the column names. here are the last lines from pgsql log:

DNEVNIK: statement: SELECT oid, * FROM problematic_table ORDER BY oid ASC
DNEVNIK: statement: SELECT n.nspname AS nspname, relname, t.typname,
nt.nspname AS typnspname, attname, attnum, COALESCE(b.oid, t.oid) AS
basetype, atthasdef, adsrc,
CASE WHEN t.typbasetype::oid=0 THEN att.atttypmod else
t.typtypmod END AS typmod,
CASE WHEN t.typbasetype::oid=0 THEN att.attlen else
t.typlen END AS typlen
FROM pg_attribute att
JOIN pg_type t ON t.oid=att.atttypid
JOIN pg_namespace nt ON nt.oid=t.typnamespace
JOIN pg_class c ON c.oid=attrelid
JOIN pg_namespace n ON n.oid=relnamespace
LEFT OUTER JOIN pg_type b ON b.oid=t.typbasetype
LEFT OUTER JOIN pg_attrdef def ON adrelid=attrelid AND
adnum=attnum
WHERE attnum > 0 AND NOT attisdropped AND attrelid=56359::oid
ORDER BY attnum
DNEVNIK: unexpected EOF on client connection

dnevnik = log

i'm guessing pgadmin gets the data, asks for the column names and then
has problems displaying the data.

if i copy&paste the queries into the query tool, it works without
problems (on all pgadmin versions i've tried this on), the data displays
very fast.

i am using pgadmin3, compiled from cvs, revision 5056, on opensuse 10.0.
the same happened with pgadmin3 1.4.x for debian (used on kubuntu 5.10)
and revision 5056 built on the same kubuntu.

i tried building the latest revision (5057) but it fails with the
following error, on both kubuntu and suse:

if g++ -DHAVE_CONFIG_H -I. -I. -I..
-DDATA_DIR=\"/usr/local/pgadmin-svn/share/pgadmin3/\" -Wall
-Wno-non-virtual-dtor -I../src/include -I../src/agent/include
-I../src/slony/include -I/usr/include/pgsql -DSSL
-I/usr/lib/wx/include/gtk2-unicode-release-2.6 -I/usr/include/wx-2.6
-DGTK_NO_CHECK_CASTS -D__WXGTK__ -D_FILE_OFFSET_BITS=64 -D_LARGE_FILES
-D_LARGEFILE_SOURCE=1 -DNO_GCC_PRAGMA -O2 -I/usr/include/libxml2
-DDATA_DIR=\"/usr/local/pgadmin-svn/share/pgadmin3/\" -Wall
-Wno-non-virtual-dtor -I../src/include -I../src/agent/include
-I../src/slony/include -MT ctlSQLBox.o -MD -MP -MF
".deps/ctlSQLBox.Tpo" -c -o ctlSQLBox.o `test -f './ctl/ctlSQLBox.cpp'
|| echo './'`./ctl/ctlSQLBox.cpp; \
then mv -f ".deps/ctlSQLBox.Tpo" ".deps/ctlSQLBox.Po"; else rm -f
".deps/ctlSQLBox.Tpo"; exit 1; fi
make[2]: *** No rule to make target `ctl/ctlSQLGrid.cpp', needed by
`ctlSQLGrid.o'. Stop.
make[2]: Leaving directory `/net/programs/pgadmin-svn/pgadmin3/src'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/net/programs/pgadmin-svn/pgadmin3'
make: *** [all] Error 2

i cannot provide the table structure or data unfortunately but if you
need any more information, i'd be happy to try to provide it.

regards,
Miha

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Devrim GUNDUZ 2006-03-25 22:06:54 1.4.2 RPMS for FC4/5
Previous Message Dave Page 2006-03-24 08:53:51 Re: Anyone got an Intel Mac yet?