From: | Justin Pryzby <pryzby(at)telsasoft(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | per-sesson errors after interrupting CLUSTER pg_attrdef |
Date: | 2017-10-20 00:01:27 |
Message-ID: | 20171020000127.GA14706@telsasoft.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
This was briefly scary but seems to have been limited to my psql session (no
other errors logged). Issue with catcache (?)
I realized that the backup job I'd kicked off was precluding the CLUSTER from
running, but that CLUSTER was still holding lock and stalling everything else
under the sun.
psql (10.0, server 9.6.5)
...
ts=# CLUSTER pg_attribute USING pg_attribute_relid_attnum_index ; ^CCancel request sent ERROR: canceling statement due to user request
ts=# \df qci_add*
ERROR: could not read block 8 in file "base/16400/999225102": read only 0 of 8192 bytes
ts=# \dt+ pg_att
ts=# \dt+ pg_attrdef
ERROR: could not read block 8 in file "base/16400/999225102": read only 0 of 8192 bytes
ts=# ^C
ts=# \q
postgres=# SELECT session_line ln, user_name, error_severity sev, left(message,66) , left(query,66) FROM postgres_log_2017_10_19_1700 WHERE session_id='59e93953.20c9' ORDER BY 1,2 DESC ;
ln | user_name | sev | left | left
----+-----------+-------+--------------------------------------------------------------------+--------------------------------------------------------------------
1 | pryzbyj | LOG | statement: CLUSTER pg_attribute USING pg_attribute_relid_attnum_in |
2 | pryzbyj | ERROR | canceling statement due to user request | CLUSTER pg_attribute USING pg_attribute_relid_attnum_index ;
3 | pryzbyj | LOG | statement: SELECT n.nspname as "Schema", +|
| | | p.proname as "Name", +|
| | | |
4 | pryzbyj | ERROR | could not read block 8 in file "base/16400/999225102": read only 0 | SELECT n.nspname as "Schema", +
| | | | p.proname as "Name", +
| | | | pg_catalog.
5 | pryzbyj | LOG | statement: SELECT pg_catalog.quote_ident(c.relname) FROM pg_catalo |
6 | pryzbyj | ERROR | could not read block 1 in file "base/16400/999225102": read only 0 | SELECT pg_catalog.quote_ident(c.relname) FROM pg_catalog.pg_class
7 | pryzbyj | LOG | statement: SELECT pg_catalog.quote_ident(c.relname) FROM pg_catalo |
8 | pryzbyj | ERROR | could not read block 1 in file "base/16400/999225102": read only 0 | SELECT pg_catalog.quote_ident(c.relname) FROM pg_catalog.pg_class
9 | pryzbyj | LOG | statement: SELECT pg_catalog.quote_ident(c.relname) FROM pg_catalo |
10 | pryzbyj | ERROR | could not read block 1 in file "base/16400/999225102": read only 0 | SELECT pg_catalog.quote_ident(c.relname) FROM pg_catalog.pg_class
11 | pryzbyj | LOG | statement: SELECT n.nspname as "Schema", +|
| | | c.relname as "Name", +|
| | | |
12 | pryzbyj | ERROR | could not read block 8 in file "base/16400/999225102": read only 0 | SELECT n.nspname as "Schema", +
| | | | c.relname as "Name", +
| | | | CASE c.relk
(12 rows)
From | Date | Subject | |
---|---|---|---|
Next Message | Amit Kapila | 2017-10-20 03:47:10 | Re: Pluggable storage |
Previous Message | Alexander Korotkov | 2017-10-19 22:01:51 | Re: CUBE seems a bit confused about ORDER BY |