|
[
Permalink
| « Hide
]
Vlad Khorsun added a comment - 29/Sep/11 07:44 AM
Transaction isolation level doesn't matters here
> Transaction isolation level doesn't matters here
yes, you're right: only 'NO WAIT" clause leads to this effect. The bug was introduced in FB 2.5 Beta 1 with fix for
Is not an important bug to include the fix in 2.5.1 that is not out at this moment?
It's too late, v2.5.1 is already signed for release.
This error affects only when modifying a field value of a table with a unique index or can i insert duplicated values in a unique key index?
> This error affects only when modifying a field value of a table with a unique index or can i insert duplicated values in a unique key index?
INSERT of dup. key in session #2 also could be done: SESSION #1: update t set f01=null; SESSION #2: commit; set transaction no wait; insert into t values(4,1); SESSION #1: rollback; SESSION #2: commit; SQL> select * from t; ID F01 ============ ============ 1 1 2 <null> 3 <null> 4 1 if you want fb 2.5.1 you can download a snapshot build
they should be ready soon with this fix ps I packaged 2.5.1 with this fix in Mageia, Fedora and EPEL (RHEL, Centos, Scientific Linux) I know the fix will be solved in next snapshot of 2.5.2, but it has been repeated in the forums not to use snapshot in production enviroments.
Any bug can appear in any kind of build - no matter is this build "official release" or no. There is no code without errors - I mean not FB only but all the software industry.
Currently all development of FB engine is carried by only FOUR men (compare with Oracle or MS, please :)). Obviously they can not test even 1% of all possible cases and so I think that any built of FB needs to be tested by us (as much as we can). May be, because my english is not my natural language, i have not explain well myself.
What i was trying to say is that if this is an important bug for production systems, and 2.5.1 is not out, and people is waiting 2.5.1 to upgrade from 1.X, 2.X, and may be 2.5.2 will be out in few months, and as Philippe says that some packages of 2.5.1 has this fix included, may be is better to delay a few days 2.5.1, and have it fixed. It was just a suggestion because i do not know how important is this bug for the production systems using firebird and if this can affects so much pepoble easily. I have used snapshots in production systems, because that snapshots solved problems that i have, but i have read in forums people that only uses official releases, and as i said, is waiting to update/upgrade to 2.5.1. On the oder side, i know that no system is perfect and i know and value the work is done, and i admire the work is done by FB developers. > if this is an important bug for production systems <...> may be is better to delay a few days 2.5.1
2.5.0, the OFFICIAL release of FB, has much more serious bugs! I talk about probability of index corruption on high-load systems, when message about 'missing entries' during validation of database appears in firebird.log. This bug occures in my PRODUCTION many times in 2010 and we have lost some money due to this. Second serious bug - Also I want mention about some good improvements that were implemented by Vlad & Dmitry in 2.5.1: ability to write into GTT inside RO transaction and some optimizer improvements. Without these improvement performance of my production would be much poor. There is no chance to get some built without errors. The question is how to reproduce these errors, report about them here and how quick FB-developers can fix them. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||