| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Rick Weber <riweber(at)akamai(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: open_sync fails |
| Date: | 2008-07-24 14:24:24 |
| Message-ID: | 20080724142424.GC9094@alvh.no-ip.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rick Weber | 2008-07-24 14:30:52 | Re: open_sync fails |
| Previous Message | Tom Lane | 2008-07-24 14:21:19 | Re: open_sync fails |