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

From: Chris Richards <chris(at)infiniteio(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: What could cause CREATE TEMP... "could not read block" error?
Date: 2015-11-19 00:31:15
Message-ID: CAOan6Tk-JqXiYEoVDdzoh5vAqwB8Mc_efRSHtkWALmDA3pvaYA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 in file "base/16391/11937": read only 0 of
8192 bytes

$ psql
psql (9.3.9)
mdb=> CREATE TEMP TABLE tmp_policyqueue AS
mdb-> SELECT pq.* FROM policyqueue AS pq
mdb-> JOIN seed_progress AS sp ON pq.id=sp.polidx;
ERROR: could not read block 40 in file "base/16391/11937": read only 0 of
8192 bytes

You'll also observe that the block number is changing each time I execute
the command. I know very little about postgres internal structure so it may
be irrelevant. I've left my database in this state should extra information
be needed.

Thanks for any assist.

Chris

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jonathan Vanasco 2015-11-19 01:10:00 controlling memory management with regard to a specific query (or groups of connections)
Previous Message Adrian Klaver 2015-11-19 00:05:49 Re: postgres zeroization of dead tuples ? i.e scrubbing dead tuples with sensitive data.