Quick Links

TopMemoryContext - Configuration Mistake?

From:	Edoardo Innocenti <edoardo(dot)innocenti(at)savinodelbene(dot)com>
To:	pgsql-admin(at)postgresql(dot)org
Subject:	TopMemoryContext - Configuration Mistake?
Date:	2010-08-16 12:45:19
Message-ID:	4C6932DF.90102@savinodelbene.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-admin

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>

<meta http-equiv="content-type" content="text/html; charset=ISO-8859-15">
</head>
<body bgcolor="#ffffff" text="#000000">
I got the following error during a select query.<br>
<br>
May it be a config error, or is it a bug?<br>
<br>
TopMemoryContext: 186872 total in 15 blocks; 16544 free (41 chunks);
170328 used<br>
TopTransactionContext: 8192 total in 1 blocks; 7568 free (0 chunks);
624 used<br>
Type information cache: 24576 total in 2 blocks; 11888 free (5
chunks); 12688 used<br>
Operator class cache: 8192 total in 1 blocks; 1680 free (0 chunks);
6512 used<br>
Operator lookup cache: 24576 total in 2 blocks; 11888 free (5
chunks); 12688 used<br>
MessageContext: 2042626048 total in 256 blocks; 16072 free (7
chunks); 2042609976 used<br>
    JoinRelHashTable: 1040384 total in 7 blocks; 512384 free (12
chunks); 528000 used<br>
smgr relation table: 24576 total in 2 blocks; 9776 free (4 chunks);
14800 used<br>
TransactionAbortContext: 32768 total in 1 blocks; 32736 free (0
chunks); 32 used<br>
Portal hash: 8192 total in 1 blocks; 1680 free (0 chunks); 6512 used<br>
PortalMemory: 8192 total in 1 blocks; 8160 free (1 chunks); 32 used<br>
Relcache by OID: 24576 total in 2 blocks; 12832 free (3 chunks);
11744 used<br>
CacheMemoryContext: 2549344 total in 23 blocks; 986984 free (1
chunks); 1562360 used<br>
    gen_porti_sched_pkey: 2048 total in 1 blocks; 656 free (0 chunks);
1392 used<br>
    m_zondes_pkey: 2048 total in 1 blocks; 704 free (0 chunks); 1344
used<br>
    oevi_1: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used<br>
    oe_vessel_imbarco_pkey: 2048 total in 1 blocks; 632 free (0
chunks); 1416 used<br>
    m_zonmar_pkey: 2048 total in 1 blocks; 752 free (0 chunks); 1296
used<br>
    m_tipmer_pkey: 2048 total in 1 blocks; 752 free (0 chunks); 1296
used<br>
    m_cianav_pkey: 2048 total in 1 blocks; 656 free (0 chunks); 1392
used<br>
    oev_1: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used<br>
    oe_vessel_t_pkey: 2048 total in 1 blocks; 656 free (0 chunks); 1392
used<br>
    mmerca_cod_emb: 2048 total in 1 blocks; 752 free (0 chunks); 1296
used<br>
    m_merca_pkey: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used<br>
    m_aeropu_pkey: 2048 total in 1 blocks; 704 free (0 chunks); 1344
used<br>
    mcli_nome: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used<br>
    mcli_acro: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used<br>
    <m_cli_x1>: 2048 total in 1 blocks; 752 free (0 chunks); 1296
used<br>
    m_cli_pkey: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used<br>
    oec_2: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used<br>
    oec_1: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used<br>
    oe_container_booking_nr_progr_ctnr_azienda_key: 2048 total in 1
blocks; 632 free (0 chunks); 1416 used<br>
    oe_container_pkey: 2048 total in 1 blocks; 632 free (0 chunks);
1416 used<br>
    oem_x1: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used<br>
    oe_sped_m_pkey: 2048 total in 1 blocks; 632 free (0 chunks); 1416
used<br>
    ref_sales_pkey: 2048 total in 1 blocks; 440 free (0 chunks); 1608
used<br>
    oes_x7: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used<br>
    oes_x6: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used<br>
    oes_x5: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used<br>
    oes_x4: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used<br>
    oes_x3: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used<br>
    oes_x2: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used<br>
    oes_x1: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used<br>
    oe_sped_t_pkey: 2048 total in 1 blocks; 656 free (0 chunks); 1392
used<br>
    navig_save_pkey: 2048 total in 1 blocks; 656 free (0 chunks); 1392
used<br>
    navig_fields_pkey: 2048 total in 1 blocks; 632 free (0 chunks);
1416 used<br>
    navig_subarea_pkey: 2048 total in 1 blocks; 656 free (0 chunks);
1392 used<br>
    navig_area_pkey: 2048 total in 1 blocks; 752 free (0 chunks); 1296
used<br>
    navig_left_table_pkey: 2048 total in 1 blocks; 752 free (0 chunks);
1296 used<br>
    gnp_cod_tipo_par: 2048 total in 1 blocks; 608 free (0 chunks); 1440
used<br>
    gen_param_pkey: 2048 total in 1 blocks; 632 free (0 chunks); 1416
used<br>
    glchart_groups_pk_gr: 2048 total in 1 blocks; 752 free (0 chunks);
1296 used<br>
    pg_attrdef_oid_index: 2048 total in 1 blocks; 752 free (0 chunks);
1296 used<br>
    empresa_pkey: 2048 total in 1 blocks; 704 free (0 chunks); 1344 used<br>
    pg_attrdef_adrelid_adnum_index: 2048 total in 1 blocks; 608 free (0
chunks); 1440 used<br>
    pg_index_indrelid_index: 2048 total in 1 blocks; 704 free (0
chunks); 1344 used<br>
    pg_ts_dict_oid_index: 3072 total in 2 blocks; 1744 free (3 chunks);
1328 used<br>
    pg_aggregate_fnoid_index: 3072 total in 2 blocks; 1696 free (2
chunks); 1376 used<br>
    pg_language_name_index: 3072 total in 2 blocks; 1744 free (3
chunks); 1328 used<br>
    pg_statistic_relid_att_index: 3072 total in 2 blocks; 1600 free (2
chunks); 1472 used<br>
    pg_ts_dict_dictname_index: 3072 total in 2 blocks; 1648 free (2
chunks); 1424 used<br>
    pg_namespace_nspname_index: 3072 total in 2 blocks; 1696 free (2
chunks); 1376 used<br>
    pg_opfamily_oid_index: 3072 total in 2 blocks; 1744 free (3
chunks); 1328 used<br>
    pg_opclass_oid_index: 3072 total in 2 blocks; 1696 free (2 chunks);
1376 used<br>
    pg_ts_parser_prsname_index: 3072 total in 2 blocks; 1648 free (2
chunks); 1424 used<br>
    pg_amop_fam_strat_index: 3072 total in 2 blocks; 1384 free (2
chunks); 1688 used<br>
    pg_opclass_am_name_nsp_index: 3072 total in 2 blocks; 1576 free (3
chunks); 1496 used<br>
    pg_trigger_tgrelid_tgname_index: 3072 total in 2 blocks; 1600 free
(2 chunks); 1472 used<br>
    pg_cast_source_target_index: 3072 total in 2 blocks; 1600 free (2
chunks); 1472 used<br>
    pg_auth_members_role_member_index: 3072 total in 2 blocks; 1648
free (2 chunks); 1424 used<br>
    pg_attribute_relid_attnum_index: 3072 total in 2 blocks; 1600 free
(2 chunks); 1472 used<br>
    pg_ts_config_cfgname_index: 3072 total in 2 blocks; 1648 free (2
chunks); 1424 used<br>
    pg_authid_oid_index: 3072 total in 2 blocks; 1696 free (2 chunks);
1376 used<br>
    pg_ts_config_oid_index: 3072 total in 2 blocks; 1744 free (3
chunks); 1328 used<br>
    pg_conversion_default_index: 3072 total in 2 blocks; 1432 free (3
chunks); 1640 used<br>
    pg_language_oid_index: 3072 total in 2 blocks; 1744 free (3
chunks); 1328 used<br>
    pg_enum_oid_index: 3072 total in 2 blocks; 1744 free (3 chunks);
1328 used<br>
    pg_proc_proname_args_nsp_index: 3072 total in 2 blocks; 1576 free
(3 chunks); 1496 used<br>
    pg_ts_parser_oid_index: 3072 total in 2 blocks; 1744 free (3
chunks); 1328 used<br>
    pg_database_oid_index: 3072 total in 2 blocks; 1696 free (2
chunks); 1376 used<br>
    pg_conversion_name_nsp_index: 3072 total in 2 blocks; 1648 free (2
chunks); 1424 used<br>
    pg_class_relname_nsp_index: 3072 total in 2 blocks; 1600 free (2
chunks); 1472 used<br>
    pg_attribute_relid_attnam_index: 3072 total in 2 blocks; 1648 free
(2 chunks); 1424 used<br>
    pg_class_oid_index: 3072 total in 2 blocks; 1696 free (2 chunks);
1376 used<br>
    pg_amproc_fam_proc_index: 3072 total in 2 blocks; 1384 free (2
chunks); 1688 used<br>
    pg_operator_oprname_l_r_n_index: 3072 total in 2 blocks; 1384 free
(2 chunks); 1688 used<br>
    pg_index_indexrelid_index: 3072 total in 2 blocks; 1696 free (2
chunks); 1376 used<br>
    pg_type_oid_index: 3072 total in 2 blocks; 1696 free (2 chunks);
1376 used<br>
    pg_rewrite_rel_rulename_index: 3072 total in 2 blocks; 1648 free (2
chunks); 1424 used<br>
    pg_authid_rolname_index: 3072 total in 2 blocks; 1696 free (2
chunks); 1376 used<br>
    pg_auth_members_member_role_index: 3072 total in 2 blocks; 1600
free (2 chunks); 1472 used<br>
    pg_enum_typid_label_index: 3072 total in 2 blocks; 1648 free (2
chunks); 1424 used<br>
    pg_constraint_oid_index: 3072 total in 2 blocks; 1744 free (3
chunks); 1328 used<br>
    pg_conversion_oid_index: 3072 total in 2 blocks; 1744 free (3
chunks); 1328 used<br>
    pg_ts_template_tmplname_index: 3072 total in 2 blocks; 1648 free (2
chunks); 1424 used<br>
    pg_ts_config_map_index: 3072 total in 2 blocks; 1624 free (3
chunks); 1448 used<br>
    pg_namespace_oid_index: 3072 total in 2 blocks; 1696 free (2
chunks); 1376 used<br>
    pg_type_typname_nsp_index: 3072 total in 2 blocks; 1600 free (2
chunks); 1472 used<br>
    pg_operator_oid_index: 3072 total in 2 blocks; 1696 free (2
chunks); 1376 used<br>
    pg_amop_opr_fam_index: 3072 total in 2 blocks; 1600 free (2
chunks); 1472 used<br>
    pg_proc_oid_index: 3072 total in 2 blocks; 1696 free (2 chunks);
1376 used<br>
    pg_opfamily_am_name_nsp_index: 3072 total in 2 blocks; 1624 free (3
chunks); 1448 used<br>
    pg_ts_template_oid_index: 3072 total in 2 blocks; 1744 free (3
chunks); 1328 used<br>
MdSmgr: 8192 total in 1 blocks; 5664 free (0 chunks); 2528 used<br>
LOCALLOCK hash: 24576 total in 2 blocks; 15984 free (5 chunks); 8592
used<br>
Timezones: 53584 total in 2 blocks; 3744 free (0 chunks); 49840 used<br>
ErrorContext: 24576 total in 3 blocks; 24480 free (18 chunks); 96 used<br>
2010-08-03 10:48:03 CEST [31005]: [658-1] ERROR: out of memory<br>
<br>
<div class="moz-signature">-- <br>
<title></title>
<pre class="moz-signature" cols="72"><font face="Verdana"><b><font
color="#000000">Edoardo Innocenti
</font></b><small><font color="#000000">Infrastructure Coordinator</font></small>
<font color="#000000">
<b>SDB Information Technology</b>
<small>Phone: +39.055.3811222
Fax: +39.055.5201411</small></font></font></pre>
</div>

<br>
<html>
<head>
<meta content="text/html; charset=ISO-8859-1" http-equiv="content-type">
<title>disclaimer-sdb</title>
</head>
<body>
<div style="text-align: center; width: 620px; font-family: Verdana;">
<small>
Utilizziamo i dati personali che la riguardano esclusivamente per nostre finalit&agrave amministrative e contabili, anche quando li comunichiamo a terzi. Informazioni dettagliate, anche in ordine al Suo diritto di accesso e agli altri Suoi diritti, sono riportate alla pagina <a href="http://www.savinodelbene.com/news/privacy.html">http://www.savinodelbene.com/news/privacy.html</a>
<br>
Se avete ricevuto questo messaggio per errore Vi preghiamo di ritornarlo al mittente eliminandolo assieme agli eventuali allegati, ai sensi art. 616 codice penale <a href="http://www.savinodelbene.com/codice_penale_616.html">http://www.savinodelbene.com/codice_penale_616.html</a>
<BR>
L'Azienda non si assume alcuna responsabilit&agrave giuridica qualora pervengano da questo indirizzo messaggi estranei all'attività lavorativa o contrari a norme.
</small>
</div>
</body>
</html>

</P>
</BODY>
</HTML>
<br>
</body>
</html>

Attachment	Content-Type	Size
unknown_filename	text/html	10.7 KB

Responses

Re: TopMemoryContext - Configuration Mistake? at 2010-08-16 15:59:14 from Tom Lane

Browse pgsql-admin by date

	From	Date	Subject
Next Message	Tom Lane	2010-08-16 15:59:14	Re: TopMemoryContext - Configuration Mistake?
Previous Message	Kenichiro Tanaka	2010-08-16 05:30:17	Re: Can't start server