Re: [Firebird-devel] PostgreSQL vs. fsync error
On 2/18/19 12:57 PM, Omacht András wrote: Yes. Always on all databases (~500 pieces on that server). (Filesystem is ext3.) András -Original Message- From: Alex Peshkoff via Firebird-devel Sent: Monday, February 18, 2019 10:45 AM To: firebird-devel@lists.sourceforge.net Cc: Alex Peshkoff Subject: Re: [Firebird-devel] PostgreSQL vs. fsync error On 2/17/19 10:35 AM, Omacht András wrote: Dear Developers, https://wiki.postgresql.org/wiki/Fsync_Errors Firebird can be also involved in the problem? Perodically we have corrupted databases on linux (85% wrong page type). And this cannot be reproduced for ages. Currently we are running FB 2.5.8 on 4.1.12 kernel. Is 'forced writes' set for you DB? In that case fsync should not affect your databases, as far as I understand with O_SYNC open flag it's just no op. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] PostgreSQL vs. fsync error
Yes. Always on all databases (~500 pieces on that server). (Filesystem is ext3.) András -Original Message- From: Alex Peshkoff via Firebird-devel Sent: Monday, February 18, 2019 10:45 AM To: firebird-devel@lists.sourceforge.net Cc: Alex Peshkoff Subject: Re: [Firebird-devel] PostgreSQL vs. fsync error On 2/17/19 10:35 AM, Omacht András wrote: > Dear Developers, > > https://wiki.postgresql.org/wiki/Fsync_Errors > > Firebird can be also involved in the problem? > > Perodically we have corrupted databases on linux (85% wrong page > type). And this cannot be reproduced for ages. Currently we are > running FB 2.5.8 on 4.1.12 kernel. > Is 'forced writes' set for you DB? Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] PostgreSQL vs. fsync error
On 2/17/19 10:35 AM, Omacht András wrote: Dear Developers, https://wiki.postgresql.org/wiki/Fsync_Errors Firebird can be also involved in the problem? Perodically we have corrupted databases on linux (85% wrong page type). And this cannot be reproduced for ages. Currently we are running FB 2.5.8 on 4.1.12 kernel. Is 'forced writes' set for you DB? Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] PostgreSQL vs. fsync error
Dear Developers, https://wiki.postgresql.org/wiki/Fsync_Errors Firebird can be also involved in the problem? Perodically we have corrupted databases on linux (85% wrong page type). And this cannot be reproduced for ages. Currently we are running FB 2.5.8 on 4.1.12 kernel. Thanks. Andras Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel