Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Hackers > Re: the un-vacu...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 9 of 16 Topic 9559 of 10406
Post > Topic >>

Re: the un-vacuumable table

by andrew.george.hammond@[EMAIL PROTECTED] ("Andrew Hammond") Jul 3, 2008 at 03:16 PM

On Thu, Jul 3, 2008 at 2:35 PM, Tom Lane <tgl@[EMAIL PROTECTED]
> wrote:
> "Andrew Hammond" <andrew.george.hammond@[EMAIL PROTECTED]
> writes:
>> Does anyone else have any suggestions about what I can do to diagnose
this?
>
> The whole thing is pretty mystifying, especially the ENOSPC write
> failure on what seems like it couldn't have been a full disk.

Yes, I've passed along the task of explaining why PG thought the disk
was full to the sysadmin responsible for the box. I'll post the answer
here, when and if we have one.

>> Jun 27 15:54:31 qadb2 postgres[92519]: [44-1] PANIC:  could not open
>> relation 1663/16386/679439393: No such file or directory
>
> I don't think anyone asked before --- after the restore fails with the
> above, does the directory $PGDATA/base/16386/ exist?  Although WAL
> recovery should attempt to create missing files, I think it won't
> try to create missing directories.

The directory exists (and the 679439393 file does not).

Andrew

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
 




 16 Posts in Topic:
the un-vacuumable table
andrew.george.hammond@[EM  2008-06-25 00:40:35 
Re: the un-vacuumable table
heikki@[EMAIL PROTECTED]   2008-06-25 12:58:04 
Re: the un-vacuumable table
andrew.george.hammond@[EM  2008-06-25 09:57:55 
Re: the un-vacuumable table
andrew.george.hammond@[EM  2008-06-27 16:31:05 
Re: the un-vacuumable table
tgl@[EMAIL PROTECTED] (T  2008-06-27 23:14:36 
Re: the un-vacuumable table
andrew.george.hammond@[EM  2008-06-30 19:20:50 
Re: the un-vacuumable table
andrew.george.hammond@[EM  2008-07-03 13:42:30 
Re: the un-vacuumable table
tgl@[EMAIL PROTECTED] (T  2008-07-03 17:35:23 
Re: the un-vacuumable table
andrew.george.hammond@[EM  2008-07-03 15:16:32 
Re: the un-vacuumable table
tgl@[EMAIL PROTECTED] (T  2008-07-03 18:47:51 
Re: the un-vacuumable table
andrew.george.hammond@[EM  2008-07-03 22:57:36 
Re: the un-vacuumable table
stark@[EMAIL PROTECTED]   2008-07-04 09:20:59 
Re: the un-vacuumable table
andrew.george.hammond@[EM  2008-07-07 12:00:12 
Re: the un-vacuumable table
tgl@[EMAIL PROTECTED] (T  2008-07-07 15:33:10 
Re: the un-vacuumable table
andrew.george.hammond@[EM  2008-07-07 14:08:03 
Re: the un-vacuumable table
andrew.george.hammond@[EM  2008-07-07 15:04:47 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Mon Oct 13 2:25:25 CDT 2008.