[pgsql-jp: 27566] create tableの呼び出し失敗について

Fang GW fanggw @ sunjapan.co.jp
2002年 10月 7日 (月) 16:16:58 JST


突然大変なことになりました。

create table または create sequenceができない状態になりました。
(select、drop、insert、alterなどはOKです)

Linux            :   Redhat 7.0J,  Kernel 2.2.16-22
PostgreSQL   : 7.2.1

【スクリプト】
create table test ( f1 char(10) );

【エラーメッセージ1】
TopMemoryContext: 24600 total in 3 blocks; 15768 free (4 chunks); 8832 used
TopTransactionContext: 8192 total in 1 blocks; 7136 free (0 chunks); 1056 used
DeferredTriggerXact: 0 total in 0 blocks; 0 free (0 chunks); 0 used
TransactionCommandContext: 577757184 total in 80 blocks; 2832 free (75 chunks); 577754352 used
QueryContext: 8192 total in 1 blocks; 7496 free (1 chunks); 696 used
DeferredTriggerSession: 0 total in 0 blocks; 0 free (0 chunks); 0 used
PortalMemory: 8192 total in 1 blocks; 8176 free (0 chunks); 16 used
CacheMemoryContext: 253952 total in 5 blocks; 34136 free (7 chunks); 219816 used
pg_attribute_relid_attnam_index: 1024 total in 1 blocks; 392 free (0 chunks); 632 used
pg_type_typname_index: 1024 total in 1 blocks; 680 free (0 chunks); 344 used
pg_amop_opc_opr_index: 1024 total in 1 blocks; 392 free (0 chunks); 632 used
pg_statistic_relid_att_index: 1024 total in 1 blocks; 392 free (0 chunks); 632 used
pg_shadow_usesysid_index: 1024 total in 1 blocks; 680 free (0 chunks); 344 used
pg_index_indrelid_index: 1024 total in 1 blocks; 680 free (0 chunks); 344 used
pg_operator_oprname_l_r_k_index: 2072 total in 2 blocks; 848 free (0 chunks); 1224 used
pg_user: 5120 total in 5 blocks; 912 free (0 chunks); 4208 used
pg_type_oid_index: 1024 total in 1 blocks; 680 free (0 chunks); 344 used
pg_proc_oid_index: 1024 total in 1 blocks; 680 free (0 chunks); 344 used
pg_proc_proname_narg_type_index: 1024 total in 1 blocks; 392 free (0 chunks); 632 used
pg_amop_opc_strategy_index: 1024 total in 1 blocks; 392 free (0 chunks); 632 used
pg_operator_oid_index: 1024 total in 1 blocks; 680 free (0 chunks); 344 used
pg_amproc_opc_procnum_index: 1024 total in 1 blocks; 392 free (0 chunks); 632 used
pg_shadow_usename_index: 1024 total in 1 blocks; 680 free (0 chunks); 344 used
pg_index_indexrelid_index: 1024 total in 1 blocks; 680 free (0 chunks); 344 used
pg_trigger_tgrelid_index: 1024 total in 1 blocks; 680 free (0 chunks); 344 used
pg_class_oid_index: 1024 total in 1 blocks; 680 free (0 chunks); 344 used
pg_class_relname_index: 1024 total in 1 blocks; 680 free (0 chunks); 344 used
pg_attribute_relid_attnum_index: 1024 total in 1 blocks; 392 free (0 chunks); 632 used
MdSmgr: 8192 total in 1 blocks; 6120 free (0 chunks); 2072 used
DynaHash: 8192 total in 1 blocks; 7216 free (0 chunks); 976 used
DynaHashTable: 8192 total in 1 blocks; 6112 free (0 chunks); 2080 used
DynaHashTable: 8192 total in 1 blocks; 4040 free (0 chunks); 4152 used
DynaHashTable: 8192 total in 1 blocks; 4040 free (0 chunks); 4152 used
DynaHashTable: 8192 total in 1 blocks; 968 free (0 chunks); 7224 used
DynaHashTable: 8192 total in 1 blocks; 8176 free (0 chunks); 16 used
DynaHashTable: 8192 total in 1 blocks; 8176 free (0 chunks); 16 used
DynaHashTable: 8192 total in 1 blocks; 8176 free (0 chunks); 16 used
DynaHashTable: 8192 total in 1 blocks; 8176 free (0 chunks); 16 used
DynaHashTable: 8192 total in 1 blocks; 8176 free (0 chunks); 16 used
ErrorContext: 8192 total in 1 blocks; 8176 free (0 chunks); 16 used
ERROR:  Memory exhausted in AllocSetAlloc(20)

【エラーメッセージ2】
ERROR:  cannot open segment 1 of relation pg_attribute_relid_attnam_index (target block 4063255): ??????????????????????




pgsql-jp メーリングリストの案内