Обсуждение: vacuumdb: vacuuming of database "testdonors" failed: ERROR: invalid memory alloc request size 3221225472

Hello,

Using community PostgreSQL 7.4.2 I have tried to vacuum this database to 
no avail. Everytime
I try I get this referenced errror. I even dumped and restored to a new 
database an get the same error.
I was also able to reindex the database but no help there.

Not much to say on google...

Databaes is about 50 megs of mostly text. Less than 5 megs in large objects.

Hardware/OS is:

Dual Athlon MP 2800
3 Gig ECC Ram
3Ware Hardware Raid
7 SATA Drives in a RAID 10 (1 hot spare).
Fedora Core 1

Any thoughts?

Sincerely,

Joshua D. Drake

-- 
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL

Without more information about what the data is, there is really no way to
even guess.

Can you make the database available so it can be looked at?

> Hello,
>
> Using community PostgreSQL 7.4.2 I have tried to vacuum this database to
> no avail. Everytime
> I try I get this referenced errror. I even dumped and restored to a new
> database an get the same error.
> I was also able to reindex the database but no help there.
>
> Not much to say on google...
>
> Databaes is about 50 megs of mostly text. Less than 5 megs in large
> objects.
>
> Hardware/OS is:
>
> Dual Athlon MP 2800
> 3 Gig ECC Ram
> 3Ware Hardware Raid
> 7 SATA Drives in a RAID 10 (1 hot spare).
> Fedora Core 1
>
> Any thoughts?
>
> Sincerely,
>
> Joshua D. Drake
>
> --
> Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
> Postgresql support, programming shared hosting and dedicated hosting.
> +1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
> PostgreSQL Replicator -- production quality replication for PostgreSQL
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org
>

"Joshua D. Drake" <jd@commandprompt.com> writes:
> Using community PostgreSQL 7.4.2 I have tried to vacuum this database
> to no avail. Everytime I try I get this referenced errror. I even
> dumped and restored to a new database an get the same error.

Hmm, how about a stack trace from the errfinish call?

If you feel gdb'ing it is out of your league, could you send me the
data dump off-list?
        regards, tom lane