[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

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.



On Mon, Apr 9, 2012 at 9:42 PM, David Schnur <dnschnur@xxxxxxxxx> 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.



[Index of Archives]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

Powered by Linux