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
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 |