Why will corruption occur?
Sent from my iPad
On 27 Sep 2014, at 19:03, fabianoas...@gmail.com [firebird-support]
firebird-support@yahoogroups.com wrote:
Do not change to a SSD! Corruption will occur.
Em 27/09/2014 11:16, Doychin Bondzhev doyc...@dsoft-bg.com
[firebird-support]
Number of guaranteed writes is much lower on SSD. when FB tries to write
some write operations will fail and database will be corrupted.
Flash disks as pen drives and memory cards also.
Em 28/09/2014 04:53, Louis van Alphen lo...@nucleo.co.za
[firebird-support] firebird-support@yahoogroups.com
I`ve been using SSDs for quite some time - had major issues with a Kingston
model a while back, so I`ve kept away from them. Most my servers are with
Corsair Force 3 drives and doing fine (they are UPS protected, so power
outages don`t happen all that often) - haven`t had a corruption during
27.09.2014 21:01, abad...@tut.by [firebird-support] wrote:
Is bug http://tracker.firebirdsql.org/browse/CORE-2848 fixed in FB 2.5.3?
We have had this bug in two FB 2.5.2 classic server installs and it
still appears sometimes after updating to 2.5.3.
Did you migrate via backup/restore? It's a
We just deployed a new server RAID10 with 8 SSDs and want to make sure we dont
run into issues. I have scheduled a gbak every night, but that needs to be to
copied to other storage
Sent from my iPad
On 28 Sep 2014, at 12:57, Ivan Arabadzhiev intelru...@yahoo.com
[firebird-support]
Did you migrate via backup/restore? It's a requirement if you don't want
to see this issue in FB 2.5.3.
No, I have missed Vlad comment about it in
http://tracker.firebirdsql.org/browse/CORE-4372
http://tracker.firebirdsql.org/browse/CORE-4372
We will b/r databases as soon as possible, thanks.
Hi Sean, thanks for the contribution.
Some answers to your requests:
1) Logic of application.
It is a Microfocus Cobol legacy application, with latest (2014) x64 runtime.
The long time is obviously not relative to a simple sql command, but to the
overall execution.
We have developed a
Fabiano,
Number of guaranteed writes is much lower on SSD.
**Not true** for all SSD/flash based devices.
Certainly true for low end/consumer Flash/SATA devices.
when FB tries to write some write operations will fail and database will be
corrupted.
Again, not true, as a broad statement.
28.09.2014 16:19, abad...@tut.by wrote:
Also, is it possible to just delete all data from offending tables? If
all pages with records are cleared, shouldn`t it also get rid of record
fragments?
Delete and garbage collect (to really clear data pages).
Dmitry