Understanding fsync error

From: Heatsink Admin <admin(at)heatsinksoftware(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Understanding fsync error
Date: 2006-07-13 13:55:55
Message-ID: 20060713135555.52414.qmail@web402.biz.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I'm getting more and more errors in the postgres log along the lines of :

2006-06-26 14:53:40 LOG: could not fsync segment 0 of relation 1663/16672/50807554: Permission denied
2006-06-26 14:53:40 ERROR: storage sync failed on magnetic disk: Permission denied

I'm pretty sure that I don't have any anti-virus, or other software running that could cause a file lock. The errors sometimes stop after a few minutes by themselves, but sometimes continue for hours - then stop when postgres is bounced. Theres more detail on this here http://groups.google.com/group/pgsql.general/browse_thread/thread/136494356086c702/ceaa221943c224b4?q=Steven+Ridgway&rnum=1#ceaa221943c224b4

Maybe I could understand this better if I could trace the error back to a specific table/index etc. When I get the error eg "... relation 1663/16672/50807554" I can see a file under the postgres data area whos name is the last number - but how do I trace whats in that file? Is there some way of doing this using system tables or something else? And what do the first two numbers in the error represent?

Many thanks for any light anyone can shed on this.

- Barry

Browse pgsql-general by date

  From Date Subject
Next Message Richard Broersma Jr 2006-07-13 14:11:55 Re: VPD
Previous Message Adrian Klaver 2006-07-13 13:52:46 Re: =???UTF-8?Q?re: How to insert .xls files into