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
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 |