Re: Strange error message - Mailing list pgsql-general

On Wed, Aug 02, 2006 at 09:34:25AM +0200, Christian Rengstl wrote:
> it seems as if in /pg_xlog/archive_status the respective file
> 0000000100000020000000D2.ready was not changed to
> 0000000100000020000000D2.done. Can this be done manually? About the
> persmission denied error i still have absolutely no clue!

It's not done, so why should it be marked done? It says quite clearly
in the logs that it failed (error 1).

As for the permission denied, that file has to exist, just look more
carefully. This is usually caused by broken anti-virus software, but it
could really be a permission problem... Don't forget that /'s are path
seperators too, so it's under the 1663 subdirectory.

Hope this helps,

>
> "Christian Rengstl" <Christian.Rengstl@klinik.uni-regensburg.de> wrote on 08/02/06 9:27 am:
> > Hi everyone,
> >
> > can please somebody let me know what this error message is supposed to
> > mean:
> > ERROR:  could not open relation 1663/16858/9469857: Permission denied
> >
> > Strange thing about it is that i do not have a relation with that name.
> > This somehow seems to go along with this other strange error message:
> > 2006-08-01 05:08:22 LOG:  archived transaction log file
> > "0000000100000020000000D2"
> > 2006-08-01 05:11:47 LOG:  archived transaction log file
> > "0000000100000020000000D3"
> > 2006-08-01 06:06:32 LOG:  archive command "copy
> > pg_xlog\0000000100000020000000D2
> > C:\Archiv\DBArchiv\0000000100000020000000D2" failed: return code 1
> > 2006-08-01 06:06:33 LOG:  archive command "copy
> > pg_xlog\0000000100000020000000D2
> > C:\Archiv\DBArchiv\0000000100000020000000D2" failed: return code
> > 1 2006-08-01 06:06:34 LOG:  archive command "copy
> > pg_xlog\0000000100000020000000D2
> > C:\Archiv\DBArchiv\0000000100000020000000D2" failed: return code 1
> >  2006-08-01 06:06:34 WARNING:  transaction log file
> > "0000000100000020000000D2" could not be archived: too many failures
> >
> > Postgre copied the file 0000000100000020000000D2 to the specified
> > directory and now it says it can't be copied...I really, really don't
> > get it!
> >
> > --
> > Christian Rengstl M.A.
> > Klinik und Poliklinik für Innere Medizin II
> > Kardiologie - Forschung
> > Universitätsklinikum Regensburg
> > B3 1.388
> > Franz-Josef-Strauss-Allee 11
> > 93053 Regensburg
> > Tel.: +49-941-944-7230
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 2: Don't 'kill -9' the postmaster
>
>
> --
> Christian Rengstl M.A.
> Klinik und Poliklinik für Innere Medizin II
> Kardiologie - Forschung
> Universitätsklinikum Regensburg
> B3 1.388
> Franz-Josef-Strauss-Allee 11
> 93053 Regensburg
> Tel.: +49-941-944-7230
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>        choose an index scan if your joining column's datatypes do not
>        match

--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.