Skip site navigation (1) Skip section navigation (2)

Re: Why would queries fail with 'could not stat file' after CLUSTER?

From: Sashbeer Bhandari <sashbeer(at)gmail(dot)com>
To: David Schnur <dnschnur(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Why would queries fail with 'could not stat file' after CLUSTER?
Date: 2012-04-10 04:30:24
Message-ID: CAP7MvVEjJGnfsLjDgEGwo0sFyTY-3dM4BrJsW_MTG+K1FfN8XQ@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
Hi
Good Morning,

I am using Postgresql DB 8.2 and my encoding is in SQL_ASCII ,. I want to
convert it in UTF8, Please help me it.


Thanks

Sashbeer

On Mon, Apr 9, 2012 at 9:42 PM, David Schnur <dnschnur(at)gmail(dot)com> wrote:

> The software I develop bundles a Postgres 8.3.15 database for storage.
>  Several users are reporting errors like this:
>
> ProgrammingError: could not stat file "base/16384/52212305.1": Permission
> denied
>
> I'm unable to reproduce this myself, but it's clearly a real issue.  The
> response to all previous reports of this that I can find was 'check your
> permissions'.  I had the user who reported this most recently do that, and
> can't see any permissions issue.  There is no AV, backup or indexing task
> that should be accessing the cluster.  The problem appears exclusively on
> Windows, though that might be a coincidence, since most of our users are on
> Windows.  A directory listing a few hours after the error shows no file
> with that name.
>
> Virtually all instances of the problem happen during our weekly
> maintenance task.  It CLUSTERs about 10-15 tables, then runs various
> queries, including selecting pg_database_size and selecting reltuples from
> pg_class, to assess the database's contents.  The errors happen when
> running these queries; the CLUSTERs themselves always succeed.  Those same
> queries are run successfully at other times during the week, without the
> preceding CLUSTERs.
>
> Is this a bug?  How might I collect more information without shipping the
> user a new build?  The Postgres log, at least at notice level, doesn't
> appear to show anything more useful than the error message.
>
> Thanks,
>
> David
>

In response to

Responses

pgsql-admin by date

Next:From: Kiruba suthanDate: 2012-04-10 05:51:54
Subject: Giant Postgresql Database Cluster Folder
Previous:From: RaghavendraDate: 2012-04-09 17:06:08
Subject: Re: Why would queries fail with 'could not stat file' after CLUSTER?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group