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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly