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.

0 comments
#linux #fsync #postgresql
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

1
The Beautiful Web
Jens Oliver Meiert • 2 votes
2
When your coding agent doesn’t understand your project, you’ll get junk
Benjamin Cane • 1 votes
3
LLM Use in the Python Source Code
Miguel Grinberg • 1 votes
4
Wagon’s algorithm in Python
John D. Cook • 1 votes
5
An example conversation with Claude Code
Dumm Zeuch • 1 votes