Thursday, February 28, 2008

New Forge: Missing the bug!

Forge 2.0 was announced yesterday, and Jay and I were bracing ourselves for an avalanche of bugs, which did not come.
When Bug#34916 (Login not working on new forge site) was reported, I thought nothing of it. It was simply the wrong environment. The reporter could not log in, because he did not have an account.

I explained the problem, and felt good about it.
Sometimes I experienced reporting a bug and being told that it was intended behavior, not a bug, read the manual, thanks for writing, and that was it. So dry and clueless. Not inspiring for a further analysis.
So I took some minutes to explain what had happened, before closing the bug with the fatal words.
And the reporter, Diego Medina, wrote back, saying that indeed he did not have an account on wiki, and thus there was no bug. However, he reported a lack of message on a failed login, which made me suspicious.
So I tried logging in with a non existing account, and I was refused. Then I tried my account, with a wrong password. To my surprise, I was admitted. Then I logged out and I logged in again as Jay Pipes, with a wrong password, of course, because I don't know it.
Bingo! The system accepted my login. I was logged in as Jay. So the Forge was not checking the password at all. Something must have gone awry during the latest bug fixes.
I alerted Jay (not before changing his profile to a "lazy guy", though!) and he fixed the vulnerability in a few minutes. Apparently nobody noticed.
I found out the security hole thanks to Diego's suggestion. He actually found the bug, but he did not realize how serious it was. I feel positive vibes because I triggered Diego's comment with my explanation.
Note to bug verifiers (not all of them, but someone): sometimes, being kind can win you back some benefits!
Thanks Diego, for sending me to the right direction!
Community, please keep testing the new Forge!

Testing the new MySQL Forge

As Jay just just announced, we are launching Forge 2.0. This is a one man show, and that man is Jay. He designed and implemented the new Forge (and the old one, for that matter) almost entirely on his own. He fixed countless bugs, and after much suffering the community can now experience the new look and feel and the new cool features.
Thanks, Jay!

Now, if you want to help, enjoy the new Forge and report problems in our bugs system. Let me show you the general picture first,a nd then we'll see what to test.

A quick tour

There are many new features in the Forge:

  • The login. In the old Forge, you had two logins, one for the main forge and one for the wiki. In the new one there is only one login. If you had an account, use your email address and the wiki password to access the Forge.
  • The people section gives information on the user, and a summary of his/her contributions;
  • All sections can get votes. You can enter a vote from 1 to five for any project, tool, worklog.
  • The old snippets section is now called tools and code, to better describe what it contains. The code supports more languages than before (86 of them, actually!).
  • Comments. You can comment on any object (project, tool, worklog), using some HTML and special code tags.
  • The wiki is fully integrated, with the same look and feel, and a shared toolbar.

(Actually, I made a mistake in the example shown in this picture. I should have written "<b>bold</b> text" but you got the idea)

A testing check list

The new Forge has passed many checks, but we are sure that we must have missed something. And we know about some known bugs that we have not had time to fix, but we will tackle soon. Your help is much appreciated. If you have experience with MediaWiki and want to share your experience in fixing similar problems, by all means drop me or Jay a line, and we will be grateful.
Everyone else, you can just go through the list below, and report bugs to bugs system (Category: MySQL Forge).
  • Log in
  • edit an existing project (if you have created one before)
  • edit an existing tool (again, if you have created one before)
  • add a tag to a worklog/project/tool/person
  • search by tag
  • add a comment, using HTML or code tags
  • vote for a project/tool/worklog
  • add a new project and add tags
  • add a new tool and add tags
  • switch to the wiki, search for pages that you know in the old wiki, check that they are correct;
  • edit a wiki page
  • create a new wiki page
  • create a new user, login with this new entity, and do all the above
If that does not look enough to you, run around, and try to break things. Don't worry. We'll reload the database and fix the contents if you mess up too much.
However, remember that this is still a test environment. Everything you do will be overwritten on Monday, when we put the new Forge in production. Thus, play with it, but save important contents in the old wiki.


If your login does not work, remove all cookies related to or and try again.
Remember that the new Forge uses the email address and the password of the old Forge wiki, not the main Forge.
One possible source of problems is when you had a different email address in the main forge and in the wiki. If that happened, we will be able to assign you ownership of the wiki pages you wrote, but not the projects and snippets. To fix that, go back to the old Forge and make sure that the email address used to login to the main forge matches the one used in the wiki, When we reload the database on Monday your previous work will be recognized. In the meantime, just create a fake account in the test forge, and enjoy the features!

Tuesday, February 26, 2008

Vim and MySQL, anyone?

On the Dev Zone there is a quick poll about your favorite IDE. The results from day one show a surprising preference for a lightweight editor, which happens to be my favorite as well.

Perhaps it's just a chance of the initial poll. We'll see in the next days.
However, it may be a good association of lightweight products. MySQL is a small, ubiquitous database server, compared to other more heavy products that need to be distributed in DVD, and the Vi family (with my favorite vim) is also small and ubiquitous.
What I loved a lot while working as a consultant is the ability of using syntax highlighting even in the most basic environments (i.e. a ssh connection on a terminal emulator) and the availability of vim in every operating system.

What's your take? Cast a vote for your favorite development environment.

Saturday, February 23, 2008

Bug or not bug? A Falcon mystery solved

Bug#33184 looked like a tough nut to crack. The initial report was quite clear. Some tests failed on Mac OS X.

I initially assumed that our testing boxes did not include the platform I was using, and informed Hakan. He tested the suite on his box, and reported success.
Too bad. Being able to reproduce a bug is the first step towards its fix. So we exchanged notes on how we compiled the sources. It turned out that I was using the optimized build, while Hakan was using a build with debug options.
I tried with debug options, and indeed, the test suite passed. However, since users are likely to adopt the optimized build, the bug was still confirmed.
More time passed. Hakan made some changes, and the test suite passed in his box, but failed in mine.
Finally, Hakan found the problem. The test suite failed because of the default gcc compiler provided by Apple. Mac OS X 10.4 and 10.5 offer gcc 4.0.1 with Xcode. Apparently, as Hakan found out, there is a bug in the exception handling of Apple's gcc.
After upgrading to gcc 4.2.2, the test suite passed without errors.
Good job, Hakan!

Thursday, February 21, 2008

Spring cleaning in MySQL supported platforms

The MySQL Lifecycle Policy determines which versions are actively supported, and for which platforms such support applies.
The basic principle is that old versions are supported for a quite long, but definitely limited period, once they have been replaced by a newer GA version. For example, since the introduction of this policy, MySQL 3.23 and 4.0 have been retired.
The policy contains also provisions for a different kind of End of Life dismissal. When support for certain platforms has been discontinued by their vendors, of the platform is not widely used, MySQL reserves the right to stop building binaries and testing code on such obsolete platforms.
The reason is simple. While hardware can be bought and stored, time is a commodity in short supply, and there is only a given amount of time that our engineers can devote to testing and supporting multiple platforms.
Therefore, it makes sense to discontinue those platforms that have few users, and dedicate some valuable time to new, emerging platforms that are more popular and widely used.

For the above reasons, at the end of 2008, MySQL will discontinue some old platforms:
  • MAC OSX 10.3
  • HP-UX 11.00
  • SCO OpenServer (all versions)
  • QNX (all versions)
MySQL will continue to offer support to specific customers in these platforms, but the public builds will be abandoned as of December 31, 2008.

The above decision is based on some vendor end-of-life support, and on our surveys on platform usage.
The intention is to provide a better service to users and customers, by allowing our engineers to spend time on the more widely used systems.

Tuesday, February 19, 2008

Users Conference 2008 - latest schedule changes

If you plan to attend the MySQL Users Conference, hurry up! The early bird registration ends on February 26. It's your chance to save a few hundred dollars.
If you need some more reasons for attending, notice these late additions to the schedule:

The Falcon sessions were added just today, and my session is a replacement of "MySQL Proxy Wizardry" (but don't worry: some of its contents will be included in the MySQL Proxy Tutorial.
Did I mention that you should hurry up to save some bucks? Register now!

BTW, as a speaker, I can give a 20% discount to my friends. If you want to get one, please drop me a line by email at my_first_name AT mysql dot com.

Monday, February 18, 2008

On good coffee and acquisitions

When traveling to my parents town with my wife, we used to stop by a coffee shop on the highway, where a charming couple made good coffee with a smile. They were efficient and friendly. As soon as we were stepping out of the car, they were already preparing for our usual order (espresso and cappuccino), and they had always a joke or a funny comment for us.

Once we saw them dealing with two busloads of tourists, serving whatever they asked rapidly and cheerfully. This shop was a popular stop, always crowded.
It ended a few weeks ago. Someone decided that the location was profitable, and now the small shop has been replaced by a huge coffee+restaurant+amenities resort.
We stopped there, out of habit, shortly before my world trip. The crowd was thinner than usual. The charming couple was gone, replaced by a 4 people team, who sent us to queue at the cashier's before ordering. The coffee was awful, and the barista's attitude less than friendly. We were not impressed.
We went there again yesterday, just to give them another chance. The 4 people team has grown to 5, but the attitude and skillset have not improved. There were very few people, less than we had ever seen in that location. If you ask me, that resort is doomed. If there was any good business, it was because of the people running it, not because of a magical road junction that compelled travelers to stop there.
The lesson to learn here is simple: taking over a successful business without due thought to the people factor is risky, bordering on disastrous.
Sun seems to have this concept in mind. After the MySQL acquisition, they want to keep MySQL people in the right places. I am confident in the future, but a friendly reminder should not do any harm. :)

Thursday, February 14, 2008

Chasing elusive bugs

Since the announcement of Maria, I have been trying to use the same crashing test with Falcon, to establish conclusively if its crash recovery features are as reliable as I hope.

I tried the same test used for Maria, and after a crash, Falcon did not recover nicely. In fact, the server crashed on restart. I have not been able to repeat that behavior on Linux. Actually, I did, on a remote server that is not available to me at the moment, using an earlier revision, and I am waiting until I am back home to do some more testing with the latest tree.
However, I managed to repeat the problem with Mac OS X.
I run this script on a 6.0.5 server:

set storage_engine=falcon;
drop table if exists t1;
create table t1 (id int, b longblob) ;
insert into t1 values (1, repeat('a',1000000));
insert into t1 select * from t1;
insert into t1 select * from t1;
insert into t1 select * from t1;
insert into t1 select * from t1;
insert into t1 select * from t1;
insert into t1 select * from t1;
insert into t1 select * from t1;
insert into t1 select * from t1;
insert into t1 select * from t1;

When the script reaches the last line (has loaded 128 records and it's inserting the next batch), I stop the server with a vicious kill -9.
Upon restarting, the system looks under control, and I run the command that was previously interrupted:

insert into t1 select * from t1;

Here, the server crashes. I have repeated the above steps several times, and it crashes consistently on Mac OS X. On Linux, which I have on a virtual machine only (I am still on the road!) I can't repeat the crash with the current revision.
So, this is a bug, no questions about that, but not a serious one, unless I manage to prove otherwise.
Perhaps this bug is related to Bug#33517. We'll see.
If anyone has noted something similar, please let me know.

Freedom to work anywhere, really!

Singapore. Last stop of my world tour. Shortly after my arrival, the new Lunar Year began. The year of the rat was happily celebrated, and its symbols can be seen everywhere in town.

In Singapore, the Freedom To Work Anywhere @ MySQL has a new meaning. Most of the town is connected via a free wireless net. While sitting on a public bench (in cool evenings) or while enjoying food and drinks at hawker centers and cafes, you can just fire up your laptop, connect to the free wireless, and start browsing. You will need to get a (free) username and password through your mobile, but you can live with it easily.
I am on vacation, so I am not "working from anywhere", but the ubiquity of the wireless connection was hard to resist!
By the way, in case you were wondering if the Sun acquisition has changed anything substantial regarding new jobs, it hasn't. MySQL is hiring! Yes. Still. And with a plan of hiring more. So, if you were thinking of sending your CV, you can do it!

Friday, February 08, 2008

From open source to open country

During the last day of the Linux Conference Australia, I and Colin had the choice between joining the crowd for the open day, or meeting a semi-private invitation from Greg Lehey a well known icon in the open source world. He organized a hackers barbecue in his very isolated place, and we could not resist. In his original invitation, Greg said that he lives "down the road", without specifying how long the road is. It turned out that it's a 90 minutes drive, which is an indication of the relative sense of distance that you get in Australia.

In the Australian bush, Greg leads a quiet life with his wife, his horses and dogs, and a few not so distant friends, dealing occasionally with stray kangaroos invading his fields, and brewing open source beer.
The barbecue met everybody's expectations, and so did Greg's famous home brewed beer, thus stimulating that sort of hacker talk that only good food and good company can generate. The subjects ranged from the origin of the hacker's word to the openness of languages, touching virtualization, databases, operating systems, embedded libraries, and user interfaces in the process.

After lunch, we were given a demonstration of the damages kangaroos can do, along with a visual recognition of their dumpings. The peek of the visit, however, came with the open source brewery, which is controlled by a FreeBSD box, in action since 2001.

On our way back, we stopped at a wildlife center, where we had close encounters with kangaroos and koalas, before reaching back to the civilized Melbourne, where Colin gave me a crash course on "how to have fun on weekends," but I won't disclose any of its contents. Suffice it to say that Colin approaches this matter with rare professionalism, and if you need advice, you must contact him directly.

Vote on Planet MySQL