core dump
От | John Liu |
---|---|
Тема | core dump |
Дата | |
Msg-id | NDBBKKKHILOHGHNKGOCEMELAGGAA.johnl@emrx.com обсуждение исходный текст |
Ответы |
Re: core dump
Re: core dump |
Список | pgsql-general |
I've two questions, they may or may not be related - 1. I copied the entire data directory [including postgresql.conf, base, ...] from postgreSQL 7.3.2 (AIX4.3) to the installation postgreSQL 7.3.4 (AIX5.1), the same filesystem setup. I didn't do an dump/reload process since the copy process is faster. Is it OK to take this shortcut in postgreSQL? any side-effects? 2. The copied database with 7.3.4 pgsql and 7.3.2 data dir seems running OK. But when I run the following query it causes core dump - psql -d emrxdbs -At -F '|' -c "select cdi, doctypeid, getdatatype(doctypeid) from document;" >out but the above query works on the older AIX4.3 postgreSQL7.3.2, and if I run the following query it works on new AIX5.1 - psql -d emrxdbs -At -F '|' -c "select cdi, doctypeid, getdatatype(doctypeid) from document limit 10;" >out strings core indicates some memory issues, but the new AIX5.1 has far more memory than the old AIX4.3 - ... SELECT relname FROM pg_catalog.pg_listener WHERE substr(relname,1,%d)='%s' UNION SELECT '*'::name pgSELECT relname FROM pg_catalog.pg_class WHERE relkind='r' and substr(relname,1,%d)='%s' and pg_catalog.pg_t able_is_visible(oid) UNION SELECT 'FULL'::name UNION SELECT 'ANALYZE'::name format Tborder Wexpanded VERnull fieldsep tuples_only title ATtableattr LLpager EXrecordsep IBMout of memory ISELECT c1.relname FROM pg_catalog.pg_class c1, pg_catalog.pg_class c2, pg_catalog.pg_index i WHERE c1.oid=i. indrelid and i.indexrelid=c2.oid and c2.relname='%s' and pg_catalog.pg_table_is_visible(c2.oid) BINARY ... IBM\out IBM\s I\write I%s LIMIT %d; out of memory ION_ERROR_STOP IBIGNOREEOF IBQUIET IB\q IUse "\q" to leave %s. IECHO IBMall abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789_ %.*s%s%s IBM IBMSINGLELINE @(#)61 1.14 src/bos/usr/ccs/lib/libc/__threads_init.c, libcthrd, bos510 7/11/00 12:04:14 set client_encoding to '%s' xrealloc xmalloc %s: out of virtual memory ... Any thoughts? thanks. johnl
В списке pgsql-general по дате отправления: