"Permission denied" failures occurring on Windows

Hello.

In spite of the fact that as it was outlined in the "change log" to PostgreSQL 8.2.2, the bug of the periodical "permission denied" error occurrence was fixed:

  "Fix bogus "permission denied" failures occurring on Windows due to attempts to fsync already-deleted files (Magnus, Tom)"

I still can observe such erroneous behavior in the latest release of PostgreSQL:

  select version();

  "PostgreSQL 8.2.3 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2 (mingw-special)"

 

Typical error message is the following:

  2007-03-16 22:21:08 ERROR:  could not open relation 16405/16406/2609: Permission denied

It seems that it occurs when DDL operator is performed.

This error occurs irrespective of option "fsync" value, though it seems that if "fsync=off" than the frequency error occurrence is less a little bit comparing to "fsync=on" case.

 

All other parameters in file postgresql.conf were not changed.

I have made a "clean" install of the latest release of PostgreSQL.

OS: Windows XP Pro SP2

 

As I can suppose, the problem which was discussed in the "[HACKERS] Idea for fixing the Windows fsync problem" has not been fixed yet.

Here are some typical error messages in files pg_log/*:

-------------------------------------------------------------------------------------------------------------

2007-03-19 18:57:22 LOG:  could not open temporary statistics file

"global/pgstat.tmp": Permission denied

2007-03-19 18:58:28 NOTICE:  Table does not exist:

part_MsgRoot_(2000-01-01 01:00)

2007-03-19 18:58:28 CONTEXT:  SQL statement "SELECT "andbDoPrepareView_sp"(  $1 ,  $2 ,  $3  )"

 

-------------------------------------------------------------------------------------------------------------

2007-03-19 19:08:39 ERROR:  could not open relation 16405/16406/21745:

Permission denied

2007-03-19 19:08:39 CONTEXT:  SQL statement "

    CREATE UNIQUE  INDEX "part_MsgPos2_(2007-01-01 02:00)_UTC_UID" ON

"part_MsgPos2_(2007-01-01 02:00)"

    (

        "UTC",

        "UID"

    );

    "

    PL/pgSQL function "andbCreatePartitionsForGroup_sp" line 32 at execute statement

 

-------------------------------------------------------------------------------------------------------------

2007-03-19 19:25:54 ERROR:  could not open relation 16405/16406/22479:

Permission denied

2007-03-19 19:25:54 CONTEXT:  SQL statement "ALTER TABLE

"part_MsgRoot_(2007-01-01 03:00)" ADD CHECK( "UTC" >= '2007-01-01 03:00:00' and "UTC" < '2007-01-01 04:00:00' )"

 

-------------------------------------------------------------------------------------------------------------

2007-03-19 19:25:56 ERROR:  could not open relation 16405/16406/22603:

Permission denied

2007-03-19 19:25:56 CONTEXT:  SQL statement "

    CREATE UNIQUE  INDEX "part_MsgOther2_(2007-01-01 03:00)_UTC_UID" ON

"part_MsgOther2_(2007-01-01 03:00)"

    (

        "UTC",

        "UID"

    );

    "

    PL/pgSQL function "andbCreatePartitionsForGroup_sp" line 32 at execute statement

 

-------------------------------------------------------------------------------------------------------------

2007-03-20 17:21:46 ERROR:  could not open relation 16405/16406/26881:

Permission denied

2007-03-20 17:21:46 CONTEXT:  SQL statement "ALTER TABLE "Billing" ADD CHECK( "UTC" IS NULL )"

    PL/pgSQL function "andbRegisterPartitionedTable_sp" line 6 at execute statement

 

-------------------------------------------------------------------------------------------------------------

Regards

Sergey Zubkovsky