WFTO – the March 2009 report!

We did a quite good job in February/March 2009 and fixed a lot of bugs.

Since my last report from 2009-02-06 we fixed around 39 Falcon related bugs. Compared to our last WFTO from 2009-02-06 we have 6 new tests.

The development of our failed/passed tests ratio over time looks like:

• 0.80% – 2/249 (this report)
• 2.51% – 6/239 (last report)
• 1.69% – 4/237 (report before last one)

News for this week:

• Christopher Powers fixed
  • Bug#28178 Falcon ALTER TABLE ends up in “Unknown table ‘sql-xyz’
  • Bug#32838 Falcon; error 1296 : Got error 305 ‘record memory is exhausted’
  • Bug#33177 Table creation fails after error 305 and tablespace change
  • Bug#36442 Falcon: crash during optimize table
  • Bug#38375 Falcon crash in Record::isNull
  • Bug#39445 Falcon: Update fails following online add column
  • Bug#39670 Error on rename (errno: 121) from ALTER TABLE ADD KEY in concurrent test
  • Bug#42592 Falcon assertion (insert(NULL, record, record->recordNumber)) when backlogging
  • Bug#42651 Regression: falcon_bug_22169-big started to fail with error 305
  • Bug#42725 Exception when filling I_S.TABLESPACES by Falcon (backup.backup_timeout failure)
  • Bug#42830 Falcon Exception: ResultSet has been closed after recovery
  • Bug#43504 Falcon DBT2 crash in Table::rollbackRecord()

• Hakan Kuecuekyilmaz fixed
  • Bug#43182 Disabled falcon_unicode-big and falcon_blob_space-big

• Kevin Lewis fixed
  • Bug#34182 SELECT … FOR UPDATE does not lock when in subquery
  • Bug#42340 Falcon assertion (oldestVisible->state != recLock) in RecordLeaf::pruneRecords
  • Bug#42660 Falcon bug in SparseArray.h
  • Bug#42828 Falcon crash in Table::checkUniqueRecordVersion – transaction = 0x0
  • Bug#43200 Falcon crash at startup in Database::scavenge()

• Lars-Erik Bjørk fixed
  • Bug#23692 Falcon: searches fail if data is 0x00
  • Bug#33190 Falcon: DeferredIndex and IndexKey may sort slightly differently
  • Bug#33719 CREATE TABLE only accepts falcon_user tablespace in uppercase
  • Bug#34478 Falcon: search failure with varbinary = 0x00
  • Bug#38130 Falcon assertion in IndexNode::expandKey offset + length <= MAX_PHYSICAL_KEY_LEN
  • Bug#42341 Falcon assertion (key – (UCHAR*) indexNode < 14) in IndexNode::parseNode
  • Bug#43452 Wrong number of rows returned when using LIMIT
  • Bug#43488 Crash in Table::fetchForUpdate (update conflict) when using LIMIT query

• Olav Sandstaa fixed
  • Bug#36410 Falcon crashes on 64 concurrent threads
  • Bug#40155 [Falcon] Error: assertion (ret == 0) failed at line 80 in file Mutex.cpp
  • Bug#40274 Falcon assertion in Transaction::releaseDependencies at Transaction.cpp:792
  • Bug#40633 pushbuild failure: Falcon assertion “lockState == 0” failed in SyncObject.cpp
  • Bug#42568 Falcon: Crash in SyncObject::unlock at line 976 in SyncObject.cpp
  • Bug#43048 Falcon may crash during shutdown when running it embedded

• Vladislav Vaintroub fixed
  • Bug#35255 falcon_bug_22165.test fails with debug builds
  • Bug#41837 Falcon recovery error: page 102/0 wrong page type, expected 7 got 0
  • Bug#42745 Exception: can’t find table space during recovery
  • Bug#42344 Falcon recovery Exception: read error on page Invalid argument (22)
  • Bug#42478 Falcon crash in Database::updateSequence
  • Bug#42560 Falcon recovery error: page 411048/1 wrong page type, expected 5 got 7
  • Bug#42824 Falcon assertion (lockType == Exclusive) in Bdb::mark on REPAIR

These are the two failing test cases.

• falcon_bug_22154-big
• falcon_deadlock (this was fixed but a new problem showed up: Bug#43554)

What about you?

We are interested in you! Where do you use Falcon? What do you do with Falcon? Are there any features you want to see in Falcon? You can test Falcon and get famous by providing valuable bug reports or even test cases for Falcon!

Resources:

• The test language we use is described here: MySQL Test Framework
• List of Falcon related bugs you will find here: http://bugs.mysql.com/saved/FalconBugs
• A preview version of Falcon you will find here: http://forge.mysql.com/wiki/Falcon_Feature_Preview
• Our MySQL Forum dedicated to Falcon related questions is here: http://forums.mysql.com/list.php?133
• Our MySQL/Falcon related mailing list you will find here: http://lists.mysql.com/falcon
• To get latest Falcon source code, please see: http://dev.mysql.com/doc/refman/6.0/en/installing-source-tree.html
• We successfully compiled our sources on Linux 32-bit and 64-bit, FreeBSD 32-bit and 64-bit, Mac/Intel and Mac/PPC, Windows 32-bit and 64-bit, and Solaris/x86 and Solaris/SPARC.