vacuum: invalid memory alloc request size 2684354556

From: "Anita Lederer" <anita(dot)lederer(at)googlemail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: vacuum: invalid memory alloc request size 2684354556
Date: 2006-03-23 11:27:06
Message-ID: df203430603230327j3ffcc96bg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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:3955
15001 : 2006-03-23 12:08:04.554 CETLOG: 00000: Anweisung: vacuum data.version ;
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 :rtable <>
: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:3955
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:3955
15001 : 2006-03-23 12:08:04.558 CETDEBUG: 00000: vacuume »data.version«
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

Browse pgsql-bugs by date

  From Date Subject
Next Message Davidson, Robert 2006-03-23 13:30:28 Re: [SQL] Function Parameters in GROUP BY clause cause errors
Previous Message Harco de Hilster 2006-03-23 09:09:41 vacuumdb: ERROR: invalid memory alloc request size 4294967292