Re: view data causes pgadmin to hang or die
От | Miha Radej |
---|---|
Тема | Re: view data causes pgadmin to hang or die |
Дата | |
Msg-id | 4428E55F.5060700@siix.com обсуждение исходный текст |
Ответ на | view data causes pgadmin to hang or die (Miha Radej <miha.radej@siix.com>) |
Список | 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
В списке pgadmin-hackers по дате отправления: