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?
Show quoted text
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 1Any 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?
"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