Re: view data causes pgadmin to hang or die

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