AllocSetAlloc() error message - Mailing list pgsql-general
From | Medi Montaseri |
---|---|
Subject | AllocSetAlloc() error message |
Date | |
Msg-id | 3E430E7E.1080904@intransa.com Whole thread Raw |
Responses |
Re: AllocSetAlloc() error message
|
List | pgsql-general |
Can someone shed some light on this error message for me (please). This is a 7.2.3 debug level 2 output, and my config is 2003-02-06 16:15:44 [645] ERROR: Memory exhausted in AllocSetAlloc(1073741820) vacuum_mem = 1048576 # 1 Meg Based on the source code src/backend/utils/mmgr/aset.c this is more like a warning than an error. /opt/intransa/postgresql/bin/postmaster child[645]: starting with (postgres -d2 -v131072 -p storageprocessor ) 2003-02-06 16:15:44 [645] DEBUG: InitPostgres 2003-02-06 16:15:44 [645] DEBUG: StartTransactionCommand 2003-02-06 16:15:44 [645] DEBUG: query: VACUUM ANALYZE 2003-02-06 16:15:44 [645] DEBUG: ProcessUtility: VACUUM ANALYZE 2003-02-06 16:15:44 [645] DEBUG: --Relation pg_type-- TopMemoryContext: 24600 total in 3 blocks; 16520 free (5 chunks); 8080 used TopTransactionContext: 8192 total in 1 blocks; 8176 free (0 chunks); 16 used DeferredTriggerXact: 0 total in 0 blocks; 0 free (0 chunks); 0 used TransactionCommandContext: 8192 total in 1 blocks; 8080 free (14 chunks); 112 used QueryContext: 8192 total in 1 blocks; 7504 free (1 chunks); 688 used Vacuum: 8192 total in 1 blocks; 6736 free (0 chunks); 1456 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; 82264 free (10 chunks); 171688 used pg_type_typname_index: 1024 total in 1 blocks; 680 free (0 chunks); 344 used pg_type_oid_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_shadow_usesysid_index: 1024 total in 1 blocks; 680 free (0 chunks); 344 used pg_shadow_usename_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_amop_opc_strategy_index: 1024 total in 1 blocks; 392 free (0 chunks); 632 used pg_amproc_opc_procnum_index: 1024 total in 1 blocks; 392 free (0 chunks); 632 used pg_class_relname_index: 1024 total in 1 blocks; 680 free (0 chunks); 344 used pg_operator_oid_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_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; 4560 free (0 chunks); 3632 used DynaHashTable: 8192 total in 1 blocks; 4560 free (0 chunks); 3632 used DynaHashTable: 8192 total in 1 blocks; 3024 free (0 chunks); 5168 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 2003-02-06 16:15:44 [645] ERROR: Memory exhausted in AllocSetAlloc(1073741820) 2003-02-06 16:15:44 [645] DEBUG: AbortCurrentTransaction 2003-02-06 16:15:44 [645] DEBUG: proc_exit(0) 2003-02-06 16:15:44 [645] DEBUG: shmem_exit(0) 2003-02-06 16:15:44 [645] DEBUG: exit(0) 2003-02-06 16:15:44 [3843] DEBUG: StartTransactionCommand 2003-02-06 16:15:44 [3843] DEBUG: query: SELECT count(*) from AlertsTable 2003-02-06 16:15:44 [3843] DEBUG: ProcessQuery 2003-02-06 16:15:44 [3808] DEBUG: reaping dead processes 2003-02-06 16:15:44 [3808] DEBUG: child process (pid 645) exited with exit code 0 2003-02-06 16:15:44 [3843] DEBUG: CommitTransactionCommand 2003-02-06 16:15:44 [3843] DEBUG: StartTransactionCommand 2003-02-06 16:15:44 [3843] DEBUG: query: INSERT INTO AlertsTable VALUES ('00:06:5B:0F:40
pgsql-general by date: