Tom Lane wrote: > Stefan Kaltenbrunner <[EMAIL PROTECTED]> writes: > >>ERROR: could not access status of transaction 0 >>DETAIL: could not create file >>/var/databases/postgres/data/pg_subtrans/57DA<<: File exists > > >>and seems to be generated in backend/access/transam/slru.c >>it looks like we got those(with changing filenames) about 5 times during >>the last 2 months mostly during low-utilisation times (on this >>particular database - not on the server itself). > > > Hm ... can you check exactly what set of filenames exists in > pg_subtrans/ when this happens? Is it always referencing pg_subtrans/, > or are there similar complains about pg_clog/ ?
it always complains about pg_subtrans/ , as for finding out what files are in that directory when that happens - I will try to put something in place that monitors the direcory. However it might take a while until we get a result out of this since I cannot reproduce this issue at will and it only happens rarely :-( Stefan ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq