Search Postgresql Archives

Re: failed to unlink, Permission denied

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I have reproduced this.

I'll upgrade to 8.2.4 and report back after my long weekend.

Cheers.

----- Original Message ----
From: M S <arthur_ringworn@xxxxxxxxxxx>
To: pgsql-general@xxxxxxxxxxxxxx
Sent: Thursday, 9 August, 2007 1:54:17 PM
Subject: Re:  failed to unlink, Permission denied

> no, but  (IMO) 8.2.4 is a required upgrade....so you should be testing
that.
Understood, I'll try an upgrade after my repeat tests have finished.

> The server is unable to delete a file (specifically, a  temporary
> table created for sorting).  Have you considered any running services
> that may acquire a lock on the table (windows is famous for this).
There is the possibility of other threads inserting into the same table, but wouldn't that be a problem according to my understanding of MVCC. There are no LOCK TABLE statements on this table.
I can't think of any programs which would be locking the files (antivirus or other), but I'll have a look.

> This may also suggest you need to look at the work_mem setting, but
> this is not the issue at hand.
Interesting, I'll pass that on.

> is the error repeatable?
I'm running the tests again with 8.2.3 to get an idea.

Cheers for the help!







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

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq





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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux