Re: Bug in point releases 9.3.6 and 9.2.10?

From: Greg Stark <stark(at)mit(dot)edu>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: Peter Geoghegan <pg(at)heroku(dot)com>, Andres Freund <andres(at)2ndquadrant(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Bug in point releases 9.3.6 and 9.2.10?
Date: 2015-03-17 19:11:28
Message-ID: CAM-w4HMHoB0bSBVfcn6TXQmURfcWE2_+aJB6_Gwkajt-Rfp_=Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Well, when a database is first initdb'd that relation is in fact 0 bytes:

::***# select pg_relation_filenode(oid) from pg_class where relname =
'pg_auth_members';
┌──────────────────────┐
│ pg_relation_filenode │
├──────────────────────┤
│ 12610 │
└──────────────────────┘
(1 row)

$ find . -name 12610 -ls
131772 0 -rw------- 1 stark stark 0 Mar 3 18:52
./global/12610

So it's not surprising to find a 0-byte file there sometime. The question
is how the ALTER ROLE commands failed to extend it or why they're expecting
it to be non-zero when it is.

Is it possible the permissions on the file are wrong for some reason? The
symptoms would make sense if the directory had permissions that allowed
unlinking (for vacuum full) but the file didn't have "r" access for the
postgres user or SE rules blocked it from being read or something like that.

--
greg

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2015-03-17 19:11:58 Re: INSERT ... ON CONFLICT IGNORE (and UPDATE) 3.0
Previous Message Alvaro Herrera 2015-03-17 19:07:31 Re: Add LINE: hint when schemaname.typename is a non-existent schema