Weekly Falcon Test Overview 2008-10-17

WFTO – reporting on a more frequent basis

since my last report from 2008-10-10 we fixed 3 Falcon related bugs. Compared to our last WFTO from 2008-10-10 we have no new test. Unfortunately two tests are failing/succeeding only sometimes. This means that we have six to eight failing tests, depending on the current phase of the moon.

Our latest failed/passed tests ratio is

  • 2.8% – 06/212 (this report)
  • 3.8% – 08/210 (last report)
  • 4.8% – 10/209 (report before last one)

WFTO 2008-10-17

News for this week:

  • Christopher Powers fixed
    • Bug#39846 Falcon: Concurrent online alter causes assertion in SRLUpdateIndex::append()
  • Olav Sandstaa fixed
    • Bug#38748 Deadlock in Falcon when running simple SELECT queries
  • Vladislav Vaintroub fixed
    • Bug#39951 Falcon: crash during crash recovery

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:

Posted in MySQL | Tagged , , , , , | Comments Off on Weekly Falcon Test Overview 2008-10-17

Weekly Falcon Test Overview 2008-10-10

WFTO, just for you!

since my last report from 2008-09-26 we fixed 12 Falcon related bugs. Compared to our last WFTO in 2008-09-26 we have one new test, we removed two tests, and two tests are not failing anymore. This means that we are at a failed/passed ratio of 3.8%. We are making a steady progress:

  • 3.8% – 08/210 (this report)
  • 4.8% – 10/209 (last report)
  • 7.5% – 15/198 (report before last one)

News for these weeks:

  • Chris Powers fixed
    • Bug#39706 Falcon recovery assertion in Cache::fetchPage for simple scenarios
    • Bug#39711 Running falcon_bug_34351_C shows increasing memory usage
    • Bug#39795 Falcon: Online add index does not support index with non-null columns
    • Bug#39796 Falcon: Reference count decrement not atomic
    • Bug#39845 Falcon: Concurrent online DROP INDEX causes assertion
  • Hakan Kuecuekyilmaz fixed
    • Bug#39574 Falcon asserts after crash in DataPage.cpp line 87
    • Bug#39692 Falcon allocates SectorCache even if falcon_use_sectorcache is OFF
    • Bug#39707 Falcon fails to start when –falcon-page-size=1K
  • Konstantin Osipov fixed
    • Bug#36473 Assertion “! is_set()” fails in Diagnostics_area::set_ok_status with Falcon
  • Olav Sandstaa fixed
    • Bug#39575 Falcon crashes during loading of large dataset
  • Sergey Vojtovich fixed
    • Bug#34892 Transaction handling in select_create::abort let’s Falcon fail
  • Vladislav Vaintroub fixed
    • Bug#39212 Falcon exception on recovery when one of the log files is empty

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:

Posted in MySQL | Tagged , , , , , , | Comments Off on Weekly Falcon Test Overview 2008-10-10

Weekly Falcon Test Overview 2008-09-26

WFTO is back in full effect – 2008-09-26

I had a  long summer holiday in August 2008 in Naples/Italy:

after that we had our yearly

This has also been a hot and long summer for our Falcon team and we made a great job by fixing around 58 bugs since my last report in June 2008.

We had quite a boost in our bug fixing rate after some new colleagues from Trondheim joined our Falcon team:

Back to our main topic: compared to our last WFTO in 2008-06-20 we have 6 new tests and 5 tests are not failing anymore. This means that we are at a failed/passed ratio of 4.8%. We are making a steady progress:

  • 4.8% – 10/209 (this report)
  • 7.5% – 15/198 (last report)
  • 8.9% – 17/190 (report before last one)

WFTO graph

News for these weeks:

  • Ann Harrison fixed
    • Bug#37343 Assertion in IndexNode::parseNode, ASSERT(key – (UCHAR*) indexNode < 14);
    • Bug#37344 Crash in IndexWalker::rebalanceDelete
    • Bug#37726 Falcon crash in WalkDeferred::getNext
  • Christopher Powers fixed
    • Bug#38043 Deadlock between server and falcon when executing concurrent ALTER + DML
    • Bug#38039 Assertion lockState == 0 failed in StorageTableShare::deleteTable SyncObject
    • Bug#38041 Bizarre errors when ALTER ADD/DROP KEY on Falcon tables
    • Bug#38044 Falcon crash in StorageTable::compareKey at StorageTable.cpp:412
    • Bug#38566 Falcon crash in RecordVersion::thaw at RecordVersion.cpp:421
    • Bug#39081 Falcon: segfault in StorageInterface::getDemographics()
    • Bug#39347 Falcon online add/drop unique index fails
    • Bug#39349 Falcon: Online drop index conflicts with other index operations
    • Bug#39350 Falcon: Releasing deferred indexes causes crash
    • Bug#39354 Falcon: Rename table corrupts index mapping
  • Jim Starkey fixed
    • Bug#34602 Falcon assertion in Transaction::commitNoUpdates line 364
    • Bug#36296 Falcon: commitNoUpdates is sleeping too often
  • Kelly Long fixed
    • Bug#37749 Falcon assertion at line 36 in file SectorBuffer.cpp
    • Bug#39296 LOAD DATA LOCAL INFILE leads to crash in Bdb::mark()
  • Kevin Lewis fixed
    • Bug#37587 falcon_bug_33404.test hangs forever
    • Bug#39025 Falcon writes key pages to Serial Log in wrong order.
    • Bug#39321 Falcon deadlock between Table::retireRecords and Database::retireRecords
  • Lars-Erik Bjørk fixed
    • Bug#36620 Legacy leftovers in Falcon startup I/O
    • Bug#36825 falcon_index_chill_threshold and falcon_record_chill_threshold have values in MB
    • Bug#36990 Remove unsupported ‘create tablespace’ parameters and falcon_initial_allocation
    • Bug#36991 falcon_max_transaction_backlog has no effect
    • Bug#38304 Data contents becomes NULL if column name in Falcon table uses accented letters
    • Bug#38377 Options falcon_serial_log_dir does not have any effect
  • Olav Sandstaa fixed
    • Bug#35932 Falcon crashes in Transaction::commitNoUpdates for simple SELECT queries
    • Bug#36410 Falcon crashes on 64 concurrent threads
    • Bug#37622 Falcon does not compile on Solaris 9 on SPARC using Sun Studio compiler
    • Bug#37679 Falcon does not compile on OpenSolaris/Nevada using the Sun Studio compiler
    • Bug#38535 AMD64 support for Falcon
    • Bug#38556 Linking error when building Falcon as a shared library using Sun Studio compiler
    • Bug#38766 Falcon hangs during start-up if compiled for 64 bit SPARC
    • Bug#38891 falcon is not supported on sparc
    • Bug#39181 Build error in MemoryManager.h in Pushbuild on sol10-sparc-a-max
  • Sergey Vojtovich fixed
    • Bug#29211 Falcon: information_schema has a falcon_tables view
    • Bug#33575 Backup: crash on shutdown if Falcon table
    • Bug#34705 FALCON_TABLES shows wrong TABLE_NAME
    • Bug#34706 FALCON_TABLES shows wrong information on temporary tables
    • Bug#37668 No error message if tables are created in Falcon tablespaces with special names
  • Vladislav Vaintroub fixed
    • Bug#22165 ALTER crash if two interleaving transactions
    • Bug#35072 Falcon crash in RecoveryObjects::findRecoveryObject, line 103
    • Bug#35939 Drift in Falcon row count reported by SHOW TABLE STATUS
    • Bug#35991 Falcon assertion on TRUNCATE in Section::getSectionPage Section.cpp line 198
    • Bug#37725 Falcon: assertion in waitForTransaction “waitingFor was not NULL”
    • Bug#38186 falcon_bug_31295 fails on pushbuild
    • Bug#38519 Falcon causes massive test failures in embedded mode
    • Bug#38594 Falcon crash in MemMgr and Sync object during exit of mysqld
    • Bug#38743 falcon.falcon_tablespace_priv fails randomly on Windows
    • Bug#38746 Falcon does not build on linux with valgrind enabled
    • Bug#38770 Falcon disregards datadir option and creates files in the current directory
    • Bug#38843 Falcon does not start if datadir is located on home directory on Solaris
    • Bug#38933 Falcon crash in Transaction::hasRecords during concurrent DDL
    • Bug#38947 UPDATE threads in endless Table::fetchForUpdate loop = livelock
    • Bug#39024 Crash in DeferredIndex::detachTransaction
    • Bug#39098 Falcon sometimes reports ‘Invalid serial log directory path’
    • Bug#39138 Falcon total database deletion after CREATE + DROP TABLESPACE + recovery
    • Bug#39421 Uncaught exception EOF in Falcon recovery on Windows

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:

Posted in MySQL | Tagged , , , , , | Comments Off on Weekly Falcon Test Overview 2008-09-26

MySQL 5.1 GA getting closer

MySQL 5.1 in production already, then there is a use case competition that may interest you.The MySQL 5.1 series has a new release candidate:

You can check the changes we made in detail here:

Of course, our list of open bugs for the upcoming 5.1.29 release is online as well:

We welcome and appreciate your feedback, bug reports, bug fixes,
patches etc.:

We also have an use case competition that may interest you, if you are using MySQL 5.1 in production already.

Happy testing!

Posted in MySQL | Tagged , , | Comments Off on MySQL 5.1 GA getting closer

Weekly Falcon Test Overview 2008-06-20

It has been almost a month since my last WFTO posting.

This time my delay was due to our migration from BitKeeper to Bazaar. You can read about the background and reasoning in our move to Bazaar in

An excellent introduction about using Bazaar with MySQL you will find at

Compared to our last WFTO we have 6 new tests and 2 tests are not failing anymore. This means that we are at a failed/passed ratio of 7.5%. We are making a steady progress:

  • 7.5% – 15/198 (this report)
  • 8.9% – 17/190 (last report)
  • 10.4% – 19/182 (report before last one)

News for these weeks:

  • Jim Starkey fixed
    • Bug#37517 falcon -DENGINE conflicts –with-ssl leading to build failure
  • Kevin Lewis fixed
    • Bug#36438 Falcon crash in Record::poke, line 823
  • Chris Powers fixed
    • Bug#36468 Falcon replication failure, engine reports HA_ERR_END_OF_FILE on slave
  • Vladislav Vaintroub fixed
    • Bug#37251 Livelock between UPDATE and DELETE threads
    • Bug#37080 Falcon deadlock on concurrent insert and truncate
    • Bug#36396 Assertion in IO::pread (on closed tablespace file)
  • Olav Sandstå fixed
    • Bug#36745 falcon crash on solaris
    • Bug#36703 Unknown symbol EncodedDataStream::decode when linking mysqld with Sun Studio
  • Hakan Küçükyılmaz fixed
    • Bug#37078 falcon_bug_26828 fails sometimes on Pushbuild

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:

Posted in MySQL | Tagged , , , | Comments Off on Weekly Falcon Test Overview 2008-06-20

Weekly Falcon Test Overview 2008-05-23

It has been a while since the last Weekly Falcon Test Overview, also called WFTO.

Our Falcon team was with the Falcon Developers Meeting in London last week. Other than that, I updated my workstation running the WFTO test suite from RHEL4 to RHEL5. This caused some delay in the weekly reporting.

The WFTO test suite now contains RHEL5 64-bit (native), Ubuntu 32-bit (vm), Windows 2003 Server 64-bit (vm), and Mac OS X/PPC 32-bit (native).

We have one new test case falcon_bug_36294 and three tests are not failing anymore.

News for these weeks:

  • Jim Starkey fixed
  • Kevin Lewis fixed
    • Bug#36097 Be sure the highWater index is set to zero when a record is thawed
    • Bug#36636 Move fsync out of the #ifdef HAVE_PREAD scope so that it works in either case.
    • Bug#36603 Adjust age group values to uint32
  • Vladislav Vaintroub fixed
    • Bug#36467 Falcon assertion in ha_partition.cc: virtual int ha_partition::extra()
  • Christopher Powers fixed
    • Bug#36330 Falcon DBT2 crash in Transaction::needToLock
  • Sergey Vojtovich fixed
    • Bug#33607 Falcon allows two mysqld instances to share a tablespace
    • Bug#33404 Falcon ignores partition-level TABLESPACE option
  • Hakan Küçükyılmaz fixed
    • Bug#36486 Falcon compilation fails on Solaris 10/x86
    • Bug#36400 Compiling Falcon on Solaris 10/x86 fails with Sun Studio 12

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:

Posted in MySQL | Tagged , , , | Comments Off on Weekly Falcon Test Overview 2008-05-23

Weekly Falcon Test Overview 2008-04-25

This week we added six new tests to the Falcon test suite. We had six tests, which where labeled as big tests. Big test means here, that the runtime or the resource requirements of that test are higher than usual. As our internal test systems are running steady integration tests on a 24/7 basis, we have to make a trade off and limit the test resource requirements to get an acceptable test throughput. However, from time to time these big tests should be run. In the Falcon team we agreed on running these tests in our Weekly Falcon Test Overview (WFTO) cycles.

We also see that there are two tests, which are not failing anymore. We disabled two tests, which will not be fixed in any near future:

  • falcon_bug_22166.test Test for case-sensitive identifiers.
  • falcon_bug_22187.test Test for Foreign Key. Useless as long we don’t have a general FK support from MySQL server side. Please note that Falcon does support FK. It’s just that we at MySQL are working on a general FK support for all storage engines.

News for this week:

  • Jim Starkey made a change in commitNoUpdate related to Bug#34602 and Bug#36296. He worked on BLOB performance enhancement, online add column, and online native backup.
  • Kevin Lewis pushed his changes for syncPrior code.
  • Chris Powers worked on Bug#36269: Thread stalls during DBT2 run.
  • Vladislav Vaintroub worked on fixing various Falcon and MySQL related bugs.
  • Hakan Kuecuekyilmaz did test case reorganizations.

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:

Posted in MySQL | Tagged , , , , | 3 Comments

Weekly Falcon Test Overview 2008-04-18

At MySQL we run a whole regression test suite on various platforms after each code “push”. If you are coming from CVS or SVN and alike, then think about a “commit” when we say “push”.

The test language we use is described here: MySQL Test Framework

We at the Falcon team wanted to see our progression in terms of bugs fixed, so for over 18 months we additionally are running Falcon related tests on a weekly basis. With lot’s of teams working on MySQL sometimes there are tests, which fail in rather random fashion. Such tests are usually disabled, so that other teams don’t get distracted. For our Weekly Falcon Test Overview we enable all disabled test, to see where we are.

I will try to do a public weekly report about the status of Falcon along with the Weekly Falcon Test Overview results, bugs we have fixed, and noteworthy news.

Last week we saw this bug fixes for Falcon:

  • Jim Starkey fixed couple of bugs.
  • Sergey Vojtovich fixed this tablespace related bugs: BUG#33723, BUG#34048, and BUG#34617.
  • Vladislav Vaintroub was very busy hunting down a duplicate key bug we saw lately in Falcon.

As we are an Open Source company, our bug system is open to all: http://bugs.mysql.com/

If you are interested in Falcon related bugs, you can use our saved search at: http://bugs.mysql.com/saved/FalconBugs

As a special add-on for fans of numbers and statistics, here is the list of the Falcon test overview status in plain text:

2006-09-01 Failed 30/67 tests, 55.22% were successful.
2006-09-15 Failed 28/75 tests, 62.67% were successful.
2006-09-22 Failed 30/76 tests, 60.53% were successful.
2006-09-29 Failed 26/77 tests, 66.23% were successful.
2006-10-06 Failed 26/79 tests, 67.09% were successful.
2006-10-13 Failed 25/83 tests, 69.88% were successful.
2006-10-20 Failed 26/83 tests, 68.67% were successful.
2006-10-27 Failed 28/88 tests, 68.18% were successful.
2006-11-03 Failed 31/92 tests, 66.30% were successful.
2006-11-10 Failed 31/99 tests, 68.69% were successful.
2006-11-17 Failed 26/101 tests, 74.26% were successful.
2006-11-24 Failed 26/102 tests, 74.51% were successful.
2006-12-01 Failed 25/102 tests, 75.49% were successful.
2006-12-08 Failed 25/105 tests, 76.19% were successful.
2006-12-15 Failed 22/106 tests, 79.25% were successful.
2006-12-22 Failed 23/107 tests, 78.50% were successful.
2006-12-29 Failed 24/107 tests, 77.57% were successful.
2007-01-05 Failed 24/107 tests, 77.57% were successful.
2007-01-12 Failed 25/110 tests, 77.27% were successful.
2007-01-19 Failed 26/110 tests, 76.36% were successful.
2007-01-26 Failed 23/110 tests, 79.09% were successful.
2007-02-02 Failed 22/110 tests, 80.00% were successful.
2007-02-11 Failed 22/110 tests, 80.00% were successful.
2007-02-16 Failed 23/114 tests, 79.82% were successful.
2007-02-23 Failed 27/123 tests, 78.05% were successful.
2007-03-02 Failed 27/123 tests, 78.05% were successful.
2007-03-10 Failed 43/127 tests, 66.14% were successful.
2007-03-17 Failed 30/127 tests, 76.38% were successful.
2007-03-24 Failed 29/129 tests, 77.52% were successful.
2007-04-15 Failed 28/132 tests, 78.79% were successful.
2007-04-20 Failed 32/142 tests, 77.46% were successful.
2007-04-27 Failed 28/145 tests, 80.69% were successful.
2007-05-04 Failed 30/148 tests, 79.73% were successful.
2007-05-11 Failed 27/148 tests, 81.76% were successful.
2007-05-18 Failed 26/149 tests, 82.55% were successful.
2007-05-25 Failed 33/150 tests, 78.00% were successful.
2007-06-01 Failed 32/155 tests, 79.35% were successful.
2007-06-08 Failed 29/155 tests, 81.29% were successful.
2007-07-06 Failed 23/158 tests, 85.44% were successful.
2007-07-13 Failed 19/159 tests, 88.05% were successful.
2007-07-20 Failed 20/159 tests, 87.42% were successful.
2007-07-27 Failed 20/160 tests, 87.50% were successful.
2007-08-03 Failed 20/161 tests, 87.58% were successful.
2007-09-07 Failed 24/170 tests, 85.88% were successful.
2007-09-14 Failed 29/172 tests, 83.14% were successful.
2007-09-21 Failed 28/172 tests, 83.72% were successful.
2008-01-10 Failed 21/185 tests, 88.65% were successful.
2008-01-24 Failed 21/185 tests, 88.65% were successful.
2008-02-01 Failed 22/185 tests, 88.11% were successful.
2008-02-28 Failed 17/191 tests, 91.10% were successful.
2008-03-13 Failed 21/194 tests, 89.18% were successful.
2008-03-20 Failed 21/194 tests, 89.18% were successful.
2008-03-28 Failed 19/189 tests, 89.95% were successful.
2008-04-04 Failed 21/194 tests, 89.18% were successful.
Posted in MySQL | Tagged , , , , | Comments Off on Weekly Falcon Test Overview 2008-04-18

Falcon Feature Preview 6.0.5 available

Again some time past by since our last 6.0.4 release of Falcon.

This Feature Preview is intended to allow the community to test some important performance improvements to the Falcon Database. The performance changes are listed below along with key bug fixes.

Several performance improvements were made in this release:

  • Supernodes
  • Thread signaling

As always you can find out details about our Falcon 6.0.5 Feature Preview at MySQL Forge.

Download is here: http://downloads.mysql.com/forge/falcon_feature_preview/

Your feedback on Falcon is highly welcome. Happy testing!

Posted in MySQL | Tagged , , , | Comments Off on Falcon Feature Preview 6.0.5 available

MySQL 6.0.4 Alpha has been released!

Dear Falconers,

MySQL 6.0.4-alpha, a new version of the MySQL database system including
the Falcon transactional storage engine (now at beta stage), has been released. The main page for MySQL 6.0 is at:

http://www.mysql.com/mysql60/

If you are new to the Falcon storage engine and need more information,
please read the Falcon Evaluation Guide at:

http://www.mysql.com/why-mysql/white-papers/falcon-getting-started.php

and the Falcon White Paper at:

http://www.mysql.com/why-mysql/white-papers/storage-engines-falcon.php

MySQL 6.0.4-alpha is available in source and binary form for a number
of platforms from our download pages at

http://dev.mysql.com/downloads/mysql/6.0.html

and mirror sites. Note that not all mirror sites may be up to date at
this point in time, so if you can’t find this version on some mirror,
please try again later or choose another download site.

We welcome and appreciate your feedback, bug reports, bug fixes,
patches etc.:

http://forge.mysql.com/wiki/Contributing

The change list is extremely long. Therefore I did not c&p’ed it here. You can view it online at:
http://dev.mysql.com/doc/refman/6.0/en/news-6-0-4.html

Posted in MySQL | Tagged , , , | 2 Comments