Understanding fsync error

Поиск
Список
Период
Сортировка
От Heatsink Admin
Тема Understanding fsync error
Дата
Msg-id 20060713135555.52414.qmail@web402.biz.mail.mud.yahoo.com
обсуждение исходный текст
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: "Nikolay Samokhvalov"
Дата:
Сообщение: Strange behaviour of RULE (selecting last inserted ID of 'sequenced' column)
Следующее
От: Tony Caduto
Дата:
Сообщение: Re: Trying to connect to an Oracle instance...