Olá boa tarde 2009/1/28 Guilherme Vianna de Aguiar <[email protected]>
> Boa tarde, > > houve um erro no Postgres de uma das maquinas aqui da empresa. > > > > Depois de um tempo que a aplicação está rodando dá o erro de falta de > memória. O banco não chega a cair. > > O log: > > > > 22:33:55.471 BRDTERROR: out of memory > > Operator class cache: 8192 total in 1 blocks; 3848 free (0 chunks); 4344 > used > > PL/PgSQL function context: 8192 total in 1 blocks; 2472 free (9 chunks); > 5720 used > > Rendezvous variable hash: 8192 total in 1 blocks; 3848 free (0 chunks); > 4344 used > > PLpgSQL function cache: 24328 total in 2 blocks; 5904 free (0 chunks); > 18424 used > > Record information cache: 8192 total in 1 blocks; 1800 free (0 chunks); > 6392 used > > TopTransactionContext: 8192 total in 1 blocks; 7312 free (0 chunks); 880 > used > > ExecutorState: 8192 total in 1 blocks; 6832 free (0 chunks); 1360 used > > ExprContext: 8192 total in 1 blocks; 8176 free (0 chunks); 16 used > > SPI Exec: 8192 total in 1 blocks; 7992 free (0 chunks); 200 used > > ExecutorState: 73856 total in 5 blocks; 26064 free (5 chunks); 47792 > used > > TIDBitmap: 24576 total in 2 blocks; 2800 free (8 chunks); 21776 > used > > ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used > > ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used > > ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used > > ExprContext: 8192 total in 1 blocks; 8160 free (0 chunks); 32 used > > AggContext: 8192 total in 1 blocks; 8104 free (0 chunks); 88 used > > TupleHashTable: 8192 total in 1 blocks; 5704 free (0 chunks); > 2488 used > > ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used > > ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used > > ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used > > SPI Proc: 8192 total in 1 blocks; 6632 free (2 chunks); 1560 used > > MessageContext: 8192 total in 1 blocks; 7072 free (0 chunks); 1120 used > > CFuncHash: 8192 total in 1 blocks; 4936 free (0 chunks); 3256 used > > MbProcContext: 1024 total in 1 blocks; 928 free (7 chunks); 96 used > > smgr relation table: 8192 total in 1 blocks; 2808 free (0 chunks); 5384 > used > > TransactionAbortContext: 32768 total in 1 blocks; 32752 free (0 chunks); > 16 used > > Portal hash: 8192 total in 1 blocks; 3912 free (0 chunks); 4280 used > > PortalMemory: 8192 total in 1 blocks; 8040 free (0 chunks); 152 used > > PortalHeapMemory: 15360 total in 4 blocks; 3400 free (0 chunks); 11960 > used > > ExecutorState: 8192 total in 1 blocks; 712 free (6 chunks); 7480 used > > ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used > > Relcache by OID: 8192 total in 1 blocks; 3376 free (0 chunks); 4816 used > > CacheMemoryContext: 667472 total in 20 blocks; 202696 free (0 chunks); > 464776 used > > CachedPlan: 15360 total in 4 blocks; 2856 free (0 chunks); 12504 used > > CachedPlanSource: 3072 total in 2 blocks; 624 free (0 chunks); 2448 > used > > SPI Plan: 1024 total in 1 blocks; 904 free (0 chunks); 120 used > > idx_UNIQ_mo_queue: 1024 total in 1 blocks; 72 free (0 chunks); 952 used > > mo_queue_idx_lote: 1024 total in 1 blocks; 344 free (0 chunks); 680 > used > > idx_mo_queue=processed: 1024 total in 1 blocks; 304 free (0 chunks); > 720 used > > idx_mo_queue=importer_host: 1024 total in 1 blocks; 344 free (0 > chunks); 680 used > > mo_queue_pkey: 1024 total in 1 blocks; 344 free (0 chunks); 680 used > > pg_index_indrelid_index: 1024 total in 1 blocks; 304 free (0 chunks); > 720 used > > pg_attrdef_adrelid_adnum_index: 1024 total in 1 blocks; 240 free (0 > chunks); 784 used > > CachedPlan: 1024 total in 1 blocks; 528 free (0 chunks); 496 used > > CachedPlanSource: 3072 total in 2 blocks; 2000 free (3 chunks); 1072 > used > > SPI Plan: 1024 total in 1 blocks; 928 free (0 chunks); 96 used > > unnamed prepared statement: 24576 total in 2 blocks; 3576 free (6 > chunks); 21000 used > > pg_ts_dict_oid_index: 1024 total in 1 blocks; 344 free (0 chunks); 680 > used > > pg_aggregate_fnoid_index: 1024 total in 1 blocks; 344 free (0 chunks); > 680 used > > pg_language_name_index: 1024 total in 1 blocks; 344 free (0 chunks); > 680 used > > pg_statistic_relid_att_index: 1024 total in 1 blocks; 240 free (0 > chunks); 784 used > > pg_ts_dict_dictname_index: 1024 total in 1 blocks; 280 free (0 chunks); > 744 used > > pg_namespace_nspname_index: 1024 total in 1 blocks; 304 free (0 > chunks); 720 used > > pg_opfamily_oid_index: 1024 total in 1 blocks; 344 free (0 chunks); 680 > used > > pg_opclass_oid_index: 1024 total in 1 blocks; 304 free (0 chunks); 720 > used > > pg_ts_parser_prsname_index: 1024 total in 1 blocks; 280 free (0 > chunks); 744 used > > pg_amop_fam_strat_index: 1024 total in 1 blocks; 88 free (0 chunks); > 936 used > > > > LOCALLOCK hash: 8192 total in 1 blocks; 3912 free (0 chunks); 4280 used > > Timezones: 48616 total in 2 blocks; 5968 free (0 chunks); 42648 used > > ErrorContext: 8192 total in 1 blocks; 8176 free (4 chunks); 16 used > > Verifica os teus discos se não estão cheios, principalmente onde está o data e os indices. Isso tá com cara de disco cheio. -- Marcelo Costa www.marcelocosta.net ------------------------------------------------- "Os muito poderosos e os muito estúpidos possuem uma coisa em comum. Ao invés de alterarem as suas visões para se ajustarem aos fatos do mundo, eles alteram os fatos para ajustá-los às suas visões.", Doctor Who.
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
