Dan Luu 3/28/2018

Fsyncgate: errors on fsync are unrecovarable

Read Original

This article archives the 'fsyncgate' email thread where Craig Ringer details a critical PostgreSQL flaw. The issue involves PostgreSQL incorrectly handling fsync() EIO errors, particularly on XFS, by retrying failed syncs. This can lead to completed checkpoints despite unwritten data, resulting in potential data loss. The post argues PostgreSQL should PANIC on fsync failures to ensure data safety.

Fsyncgate: errors on fsync are unrecovarable

Comments

No comments yet

Be the first to share your thoughts!

Browser Extension

Get instant access to AllDevBlogs from your browser

Top of the Week

No top articles yet