Re: [GENERAL] What could cause CREATE TEMP... "could not read block" error?

Chris Richards wrote: [had corruption in pg_depend indexes] > I've observed the problem on other than the "pg_depend" table. A normal table > (called "blocks") had > the problem. A "REINDEX TABLE blocks" did not fix the problem, however a > "VACUUM FULL" did "fix" it. Did you dump/remove cluster

Re: [GENERAL] What could cause CREATE TEMP... "could not read block" error?

> Are you running the latest minor release for your PostgreSQL version? No. 9.3.9 whereas the lastest is 9.3.10 > Were there any crashes recently? No[*]. See comments below about LVM snapshots. > Do you have "fsync = on"? Yes. > Did you make sure that you have a reliable storage system? RAID

Re: [GENERAL] What could cause CREATE TEMP... "could not read block" error?

Chris Richards wrote: > Adrian is correct. This worked by itself whereas using it in the creation of > the temporary table > failed. > mdb-> SELECT pq.* FROM policyqueue AS pq > mdb-> JOIN seed_progress AS sp ON pq.id =sp.polidx; > > I checked the query Albe suggested; there were

Re: [GENERAL] What could cause CREATE TEMP... "could not read block" error?

On 11/20/2015 07:26 AM, Chris Richards wrote: Adrian is correct. This worked by itself whereas using it in the creation of the temporary table failed. mdb-> SELECT pq.* FROM policyqueue AS pq mdb-> JOIN seed_progress AS sp ON pq.id =sp.polidx; I checked the query Albe suggested;

Re: [GENERAL] What could cause CREATE TEMP... "could not read block" error?

Adrian is correct. This worked by itself whereas using it in the creation of the temporary table failed. mdb-> SELECT pq.* FROM policyqueue AS pq mdb-> JOIN seed_progress AS sp ON pq.id=sp.polidx; I checked the query Albe suggested; there were two `relfilenode`s (11936 and 11937) that exhibited t

Re: [GENERAL] What could cause CREATE TEMP... "could not read block" error?

On 11/18/2015 04:31 PM, Chris Richards wrote: Howdy. I have two tables that I'm joining together and using the result to create a temporary table. Performing the join operation works fine; it produces 0 rows (as expected). If I prepend "CREATE TEMP tmp_policyqueue AS" to the SELECT then it genera

Re: [GENERAL] What could cause CREATE TEMP... "could not read block" error?

On 11/20/2015 06:18 AM, Albe Laurenz wrote: Chris Richards wrote: Howdy. I have two tables that I'm joining together and using the result to create a temporary table. Performing the join operation works fine; it produces 0 rows (as expected). If I prepend "CREATE TEMP tmp_policyqueue AS" to th

Re: [GENERAL] What could cause CREATE TEMP... "could not read block" error?

Chris Richards wrote: > Howdy. I have two tables that I'm joining together and using the result to > create a temporary table. > Performing the join operation works fine; it produces 0 rows (as expected). > If I prepend "CREATE TEMP > tmp_policyqueue AS" to the SELECT then it generates this error

[GENERAL] What could cause CREATE TEMP... "could not read block" error?

Howdy. I have two tables that I'm joining together and using the result to create a temporary table. Performing the join operation works fine; it produces 0 rows (as expected). If I prepend "CREATE TEMP tmp_policyqueue AS" to the SELECT then it generates this error: ERROR: could not read block 39