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

Re: 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: Re: view data causes pgadmin to hang or die
Date: 2006-03-28 07:27:27
Message-ID: 4428E55F.5060700@siix.com (view raw or flat)
Thread:
Lists: pgadmin-hackers
Hi!

I'm sorry for bumping this but if it is possible, it would be great if 
the described problem can be resolved. Even hints as to what I may be 
doing wrong would help a lot :-)

Thank you,
Miha

Miha Radej wrote:
> 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

In response to

pgadmin-hackers by date

Next:From: Dave PageDate: 2006-03-29 09:14:01
Subject: Re: view data causes pgadmin to hang or die
Previous:From: Dave PageDate: 2006-03-27 16:51:05
Subject: Re: pgadmin.log

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