Re: open_sync fails - Mailing list pgsql-general

From Rick Weber
Subject Re: open_sync fails
Date
Msg-id 4888921C.7000108@akamai.com
Whole thread Raw
In response to Re: open_sync fails  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-general
Definitely believable.  It gives me an internal avenue to chase down.

Thanks

--Rick



Alvaro Herrera wrote:
Rick Weber wrote:
 
While working on tuning my database, I was experimenting with changing  
the wal_sync_method to try to find the optimal value.  The really odd  
thing is when I switch to open_sync (O_SYNC), Postgres immediately fails  
and gives me an error message of:

2008-07-22 11:22:37 UTC 19411 akamai [local] PANIC:  could not write to  
log file 101, segment 40 at offset 12558336, length 2097152: No space left on device   
Sounds like a kernel bug to me, particularly because the segment is most
likely already 16 MB in length; we're only rewriting the contents, not
enlarging it.  Perhaps the kernel wanted to report a problem and chose
the wrong errno.
 
Attachment

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: open_sync fails
Next
From: "Scott Marlowe"
Date:
Subject: Re: php + postgresql