Significance of numbers in server errors?
I'm wondering if there's a description anywhere of the significance of number
reported in errors; for example I've recently run into this error:
ERROR: could not read block 132 of relation 1663/16430/1249: read only 0 of
8192 bytes
From some documentation I've read
(http://etutorials.org/SQL/Postgresql/Part+I+General+PostgreSQL+Use/Chapter+4.+Performance/How+PostgreSQL+Organizes+Data/)
I know the second is the database's directory, the last is the pg_attribute
table (in this example), but I haven't figured out what the first is.
Additionally, is that format usually consistent across errors? For example,
would the number in this error relate to the same values:
ERROR: could not open relation 1663/16430/16868: No such file or directory
On 4 March 2011 23:15, Sebastien Boisvert <sebastienboisvert@yahoo.com> wrote:
I know the second is the database's directory, the last is the pg_attribute
table (in this example), but I haven't figured out what the first is.
I think that the first is probably the tablespace:
postgres=# select oid,* from pg_tablespace;
-[ RECORD 1 ]-----------
oid | 1663
spcname | pg_default
spcowner | 10
spclocation |
spcacl |
spcoptions |
-[ RECORD 2 ]-----------
oid | 1664
spcname | pg_global
spcowner | 10
spclocation |
spcacl |
spcoptions |
--
Regards,
Peter Geoghegan