Strange error message

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/

Unfortunately it's windows, but nevertheless it worked now for weeks and suddenly the postgre user should not be able to copy anymore? Besides, the file was copied and then disappeared from the pg_xlog directory, nevertheless postgre kept trying to 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 partition set 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 sat down and wrote:

Unfortunately it's windows, but nevertheless it worked now for weeks and suddenly the postgre user should not be able to copy anymore? Besides, the file was copied and then disappeared from the pg_xlog directory, nevertheless postgre kept trying to 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

"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