Thread: Understanding 'could not read block'
Hi, I have a table of about 693 million rows (80gb) of position data (standard object,timestamp,position,etc). Every time I try to build some statistics by creating a table, such as: > create table pos_stats1 as > select id,year,month,count(1) from positions group by id,year,month; I get an error: > ERROR: could not read block 8519713 of temporary file: Permission denied I get a similar error sometimes on indexes. What problem am I hitting here? The drive and permissions all seem fine & the query runs for a long time before hitting this error. I've turned off virus scan & it seems to have no effect. Thanks. -- Windows Server 2003 PostgreSQL Version 8.3.0 -- View this message in context: http://www.nabble.com/Understanding-%27could-not-read-block%27-tp25563135p25563135.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
On Thu, Sep 24, 2009 at 1:14 PM, stevesub <steve.n@subwest.com> wrote:
Upgrade to 8.3.8
try switching off any antivirus software running.
Hi,
I have a table of about 693 million rows (80gb) of position data (standard
object,timestamp,position,etc).
Every time I try to build some statistics by creating a table, such as:
> create table pos_stats1 as
> select id,year,month,count(1) from positions group by id,year,month;
I get an error:
> ERROR: could not read block 8519713 of temporary file: Permission denied
I get a similar error sometimes on indexes. What problem am I hitting here?
The drive and permissions all seem fine & the query runs for a long time
before hitting this error. I've turned off virus scan & it seems to have no
effect.
Thanks.
--
Windows Server 2003
PostgreSQL Version 8.3.0
Upgrade to 8.3.8
try switching off any antivirus software running.
--
GJ
=?UTF-8?Q?Grzegorz_Ja=C5=9Bkiewicz?= <gryzman@gmail.com> writes: > On Thu, Sep 24, 2009 at 1:14 PM, stevesub <steve.n@subwest.com> wrote: >> I get an error: >> ERROR: could not read block 8519713 of temporary file: Permission denied > try switching off any antivirus software running. The usual advice is to actually *uninstall* whatever antivirus software you are running. Some of it is so broken that it keeps on rejecting things at random even when nominally turned off. My private advice is to get off Windows. regards, tom lane
On Thu, 2009-09-24 at 05:14 -0700, stevesub wrote: > Hi, > > I have a table of about 693 million rows (80gb) of position data (standard > object,timestamp,position,etc). > > Every time I try to build some statistics by creating a table, such as: > > create table pos_stats1 as > > select id,year,month,count(1) from positions group by id,year,month; > > I get an error: > > ERROR: could not read block 8519713 of temporary file: Permission denied > > I get a similar error sometimes on indexes. What problem am I hitting here? > The drive and permissions all seem fine & the query runs for a long time > before hitting this error. I've turned off virus scan & it seems to have no > effect. It means the permissions on the physical file are such that your postgres service user can't read them. Joshua D. Drake -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development, Engineering If the world pushes look it in the eye and GRR. Then push back harder. - Salamander
On Thu, 2009-09-24 at 05:14 -0700, stevesub wrote: > Hi, > > I have a table of about 693 million rows (80gb) of position data (standard > object,timestamp,position,etc). > > Every time I try to build some statistics by creating a table, such as: > > create table pos_stats1 as > > select id,year,month,count(1) from positions group by id,year,month; > > I get an error: > > ERROR: could not read block 8519713 of temporary file: Permission denied > > I get a similar error sometimes on indexes. What problem am I hitting here? > The drive and permissions all seem fine & the query runs for a long time > before hitting this error. I've turned off virus scan & it seems to have no > effect. It means the permissions on the physical file are such that your postgres service user can't read them. Joshua D. Drake -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development, Engineering If the world pushes look it in the eye and GRR. Then push back harder. - Salamander