Thread: Strange error message
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
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! "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
am 02.08.2006, um 9:27:22 +0200 mailte Christian Rengstl folgendes: > 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! My guess: Access Denied on the filesystem for the postgres-User. PS.: Windows, right? HTH, Andreas -- Andreas Kretschmer (Kontakt: siehe Header) Heynitz: 035242/47215, D1: 0160/7141639 GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net === Schollglas Unternehmensgruppe ===
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.
Attachment
Unfortunately it's windows, but nevertheless it worked now for weeks and suddenly the postgre user should not be able tocopy anymore? Besides, the file was copied and then disappeared from the pg_xlog directory, nevertheless postgre kept tryingto copy the very same file. "A. Kretschmer" <andreas.kretschmer@schollglas.com> wrote on 08/02/06 9:40 am: > am 02.08.2006, um 9:27:22 +0200 mailte Christian Rengstl folgendes: >> 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! > > My guess: Access Denied on the filesystem for the postgres-User. > > PS.: Windows, right? > > HTH, Andreas > -- > Andreas Kretschmer (Kontakt: siehe Header) > Heynitz: 035242/47215, D1: 0160/7141639 > GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net > === Schollglas Unternehmensgruppe === > > ---------------------------(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
The thing is that the very same file was copied to the specified directory. Martijn van Oosterhout <kleptog@svana.org> wrote on 08/02/06 9:43 am: > 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. -- 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
Disk full or otherwise problems with the disk? I remember I saw somthing similiar some months ago and the reason was (AFAIR) something like a full partition or a partitionset to readonly, or a broken mountpoint because of hardware errors. With Linux, not MSW. Regards, Frank On Wed, 02 Aug 2006 09:44:54 +0200 "Christian Rengstl" <Christian.Rengstl@klinik.uni-regensburg.de> thought long, then satdown and wrote: > Unfortunately it's windows, but nevertheless it worked now for weeks and suddenly the postgre user should not be able tocopy anymore? Besides, the file was copied and then disappeared from the pg_xlog directory, nevertheless postgre kept tryingto copy the very same file. > > "A. Kretschmer" <andreas.kretschmer@schollglas.com> wrote on 08/02/06 9:40 am: > > am 02.08.2006, um 9:27:22 +0200 mailte Christian Rengstl folgendes: > >> 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! > > > > My guess: Access Denied on the filesystem for the postgres-User. > > > > PS.: Windows, right? > > > > HTH, Andreas > > -- > > Andreas Kretschmer (Kontakt: siehe Header) > > Heynitz: 035242/47215, D1: 0160/7141639 > > GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net > > === Schollglas Unternehmensgruppe === > -- > 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 -- Frank Finner Invenius - Lösungen mit Linux Köpfchenstraße 36 57072 Siegen Telefon: 0271 231 8606 Mail: frank.finner@invenius.de Telefax: 0271 231 8608 Web: http://www.invenius.de Key fingerprint = 90DF FF40 582E 6D6B BADF 6E6A A74E 67E4 E788 2651
Attachment
"Christian Rengstl" <Christian.Rengstl@klinik.uni-regensburg.de> writes:
> Unfortunately it's windows, but nevertheless it worked now for weeks
> and suddenly the postgre user should not be able to copy anymore?
Broken anti-virus software. We've seen essentially identical reports
before ...
regards, tom lane