Thread: vacuum: invalid memory alloc request size 2684354556

vacuum: invalid memory alloc request size 2684354556

From
"Anita Lederer"
Date:
Hi,

i have
- PostgreSQL 8.1.3 on x86_64-unknown-linux-gnu, compiled by GCC gcc
(GCC) 3.3.5 20050117 (prerelease) (SuSE Linux)
- 2 services running, one on port 5432 and another one on port 5431.

vacuum fails in every way i tried (psql, pgadmin, autovac, jdbc;
single table, whole database) but analyze and vacuum full works fine.
it doesn't matter which server or which database i try.

the message i get is:
  FEHLER:  invalid memory alloc request size 2684354556

i already got exactly the same exception with 8.1.1, i've got an
update from 8.1.1 to 8.1.3 on monday.
the exception apears to be unchanged.

the server crashed quite often.

and i have some lines from my logfile

15001 : 2006-03-23 12:08:04.554 CETDEBUG:  00000: StartTransactionCommand
15001 : 2006-03-23 12:08:04.554 CETORT:  start_xact_command, postgres.c:1981
15001 : 2006-03-23 12:08:04.554 CETDEBUG:  00000: StartTransaction
15001 : 2006-03-23 12:08:04.554 CETORT:  ShowTransactionState, xact.c:3930
15001 : 2006-03-23 12:08:04.554 CETDEBUG:  00000: name: unnamed;
blockState:       DEFAULT; state: INPROGR, xid/subid/cid:
17598150/1/0, nestlvl: 1, children: <>
15001 : 2006-03-23 12:08:04.554 CETORT:  ShowTransactionStateRec, xact.c:39=
55
15001 : 2006-03-23 12:08:04.554 CETLOG:  00000: Anweisung: vacuum data.vers=
ion ;
15001 : 2006-03-23 12:08:04.555 CETORT:  log_after_parse, postgres.c:603
15001 : 2006-03-23 12:08:04.555 CETDEBUG:  00000: parse tree:
15001 : 2006-03-23 12:08:04.555 CETDETAIL:  {QUERY :commandType 5
:querySource 0 :canSetTag true :utilityStmt ?
        :resultRelation 0 :into <> :hasAggs false :hasSubLinks false :rtabl=
e <>
        :jointree <> :rowMarks <> :forUpdate false :rowNoWait false
:targetList <>
        :groupClause <> :havingQual <> :distinctClause <> :sortClause
<> :limitOffset
        <> :limitCount <> :setOperations <> :resultRelations <>}

15001 : 2006-03-23 12:08:04.555 CETORT:  elog_node_display, print.c:86
15001 : 2006-03-23 12:08:04.555 CETDEBUG:  00000: ProcessUtility
15001 : 2006-03-23 12:08:04.555 CETORT:  PortalRunUtility, pquery.c:952
15001 : 2006-03-23 12:08:04.558 CETDEBUG:  00000: CommitTransaction
15001 : 2006-03-23 12:08:04.558 CETORT:  ShowTransactionState, xact.c:3930
15001 : 2006-03-23 12:08:04.558 CETDEBUG:  00000: name: unnamed;
blockState:       STARTED; state: INPROGR, xid/subid/cid:
17598150/1/0, nestlvl: 1, children: <>
15001 : 2006-03-23 12:08:04.558 CETORT:  ShowTransactionStateRec, xact.c:39=
55
15001 : 2006-03-23 12:08:04.558 CETDEBUG:  00000: StartTransaction
15001 : 2006-03-23 12:08:04.558 CETORT:  ShowTransactionState, xact.c:3930
15001 : 2006-03-23 12:08:04.558 CETDEBUG:  00000: name: unnamed;
blockState:       DEFAULT; state: INPROGR, xid/subid/cid:
17598151/1/0, nestlvl: 1, children: <>
15001 : 2006-03-23 12:08:04.558 CETORT:  ShowTransactionStateRec, xact.c:39=
55
15001 : 2006-03-23 12:08:04.558 CETDEBUG:  00000: vacuume =BBdata.version=
=AB
15001 : 2006-03-23 12:08:04.558 CETORT:  lazy_scan_heap, vacuumlazy.c:221
15001 : 2006-03-23 12:08:04.558 CETFEHLER:  XX000: invalid memory
alloc request size 2684354556
15001 : 2006-03-23 12:08:04.558 CETORT:  MemoryContextAlloc, mcxt.c:505

i have little where to look for any further information so please give
me some hints.

Thanks,

Anita