Обсуждение: 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.

=?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