Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

8.3.0: vacuum full analyze: "invalid memory alloc request size"


  • From: Tomas Szepe <szepe(at)pinerecords(dot)com>
  • To: pgsql-bugs(at)postgresql(dot)org
  • Subject: 8.3.0: vacuum full analyze: "invalid memory alloc request size"
  • Date: Sat, 9 Feb 2008 12:52:21 +0100
  • Message-id: <20080209115221(dot)GA27757(at)louise(dot)pinerecords(dot)com>

Hello,

Trying to run "vacuum full analyze" on a ~200MB UTF8 database fails with:

fs=> vacuum full analyze;
WARNING:  skipping "pg_authid" --- only table or database owner can vacuum it
WARNING:  skipping "pg_database" --- only table or database owner can vacuum it
WARNING:  skipping "pg_shdepend" --- only table or database owner can vacuum it
WARNING:  skipping "pg_shdescription" --- only table or database owner can vacuum it
WARNING:  skipping "pg_auth_members" --- only table or database owner can vacuum it
ERROR:  invalid memory alloc request size 4294965504

But not always, sometimes it goes through w/o a problem:

fs=> vacuum full analyze;
WARNING:  skipping "pg_authid" --- only table or database owner can vacuum it
WARNING:  skipping "pg_database" --- only table or database owner can vacuum it
WARNING:  skipping "pg_shdepend" --- only table or database owner can vacuum it
WARNING:  skipping "pg_shdescription" --- only table or database owner can vacuum it
WARNING:  skipping "pg_auth_members" --- only table or database owner can vacuum it
WARNING:  skipping "pg_tablespace" --- only table or database owner can vacuum it
WARNING:  skipping "pg_pltemplate" --- only table or database owner can vacuum it
VACUUM

This is on x86 Linux.  8.2.6 does not exhibit the problem, or at least I haven't
run into it.  What info do I need to submit so that this can be tracked down?

Best regards,
-- 
Tomas Szepe <szepe(at)pinerecords(dot)com>



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group