Postgres Pro
Downloads
Home   >   mailing lists

failed to unlink, Permission denied - Mailing list pgsql-general

From M S
Subject failed to unlink, Permission denied
Date
Msg-id 268074.94531.qm@web25014.mail.ukl.yahoo.com
Whole thread Raw
Responses Re: failed to unlink, Permission denied  ("Merlin Moncure" <mmoncure@gmail.com>)
List pgsql-general
Tree view 
Hi,



  I left our app on soak test overnight, it ran fine for some time but after a few hours I noticed the following
messagesrepeated in the log (the tmp filename changes, but the PlPgSql function which causes it does not). 



  2007-08-08 17:25:57 LOG:  failed to unlink "pg_tblspc/16403/16404/pgsql_tmp/pgsql_tmp5260.0": Permission denied

  2007-08-08 17:25:57 CONTEXT:  PL/pgSQL function "JobTargetNextUnsentGet" line 40 at for over select rows



  The PlPgSql function is just a SELECT with 2 INNER JOINS, an integer comparison WHERE clause, with an ORDER BY time
anda LIMIT 1. 



  Could anyone please suggest what could be behind this error?



  Postgres version 8.2.3

  Windows 2003 SP2


  I have checked the Changelog from 8.2.3-8.2.4 and nothing look relevant.



  Thanks.




      ___________________________________________________________
Yahoo! Answers - Got a question? Someone out there knows the answer. Try it
now.
http://uk.answers.yahoo.com/

pgsql-general by date:

Previous
From: Håkan Jacobsson
Date:
Subject: [JDBC] Restore database from zipped textfile (.sql) created by pg_dumpall
Next
From: Michal Paluchowski
Date:
Subject: Multiple operations when updating a view - works in Postgres, doesn't in the app