There is a nice demo of MySQL Bug 13510739 on Eric Romang's blog
I've published this blog to make this content available on
planet.mysql.com.
I just want to share about a strange behavior of one of our MySQL
server yesterday.
This server is a 5.1.50 MySQL server on debian 4.0 (Yes, I know…)
When a “mysqld got signal 6” error occurred yesterday,
the MySQL server crashed and didn’t want to restart.
Then, I found these informations in the error log file :
/usr/local/mysql/bin/mysqld: File '*** glibc detected *** malloc():memory corruption: 0x00002aac2d5ab460 ***' not found (Errcode: 2) 120306 17:19:47 [ERROR] Failed to open log (file '*** glibc detected *** malloc():memory corruption: 0x00002aac2d5ab460 ***', errno 2) 120306 17:19:47 [ERROR] Could not open log file 120306 17:19:47 [ERROR] Can't init tc log 120306 17:19:47 [ERROR] Aborting
120306 17:19:47 InnoDB: Starting shutdown... 120306 17:19:53 InnoDB: Shutdown completed; log sequence number 55 1061584593 120306 17:19:53 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete
Great, let see …
[Read more]Some days ago while I’m looking for what are saying about a mysql.com server down I found a twitter bug:
Is not a big deal, to repeat this bug you must follow these steps:
1. Find any term, in this case “mysql.com” then in results looking for a word that have the search term as a part of them (ex dev.mysql.com) and select the a part or entire word:
2. Press Ctrl + C, some HTML codes appear from nowhere:
3. Do it again and again, you will see an strange twit like this:
I’m using Firefox 8.0 under Ubuntu, but you will …
[Read more]For those who saw my previous post about the crashing (regression) bug with SELECT COUNT(DISTINCT) on InnoDB with Primary Key (PK), you’ll be interested to know my test case does not crash in 5.5.18 (which was just released).
I’ve only tested my test case thus far, but it seems fine.
Unfortunately, the fix is not mentioned in the 5.5.18 changelogs though.
And there is no mention (yet, anyway) of a fix in the bug report I filed (though it was designated a ‘duplicate’, so it wouldn’t necessarily be updated).
I’m trying to get confirmation from the MySQL Dev Team on this (via the bug report), and will update this post if/when I hear anything.
I’ll also perform some of the …
[Read more]If you’re using MySQL and SSL, you might want to glance over this article and give your setup a quick test.
I’ve uncovered an alarming bug in 5.5 where one could gain access to your MySQL instance just knowing the username and password (not having any SSL certificate, key, etc.)!
Of course, I’ve filed a bug about it here:
http://bugs.mysql.com/bug.php?id=62743
It’s been over 4 days now, and not one comment from the MySQL Bug/Dev Team.
So once again, I feel the need to share this bug with the public, in case you are using SSL with 5.5, and think your connections are secure, or that only users with the certs/key could gain access.
For SSL Users, you’ll already have this set up, but for those who don’t, I’ve simply got mysqld (5.5.15 and 5.5.16 thus far) running with the following options:
ssl-ca = …[Read more]
In 5.5, a crashing, regression bug exists if you use SELECT COUNT(DISTINCT) *and* one of the WHERE operands is in the Primary Key (or just a unique index).
This simple crash (if only one row is in the table) will crash mysqld.
Of course I’ve filed a bug report, but that has been nearly 3 months and no updates yet.
Here is the bug I filed (which you won’t be able to view):
http://bugs.mysql.com/bug.php?id=61842
Really, the only thing that happened to my bug report was that it was designated a duplicate of another bug (which we also cannot view):
http://bugs.mysql.com/bug.php?id=61101
Based on the id, and the submitted dates of bugs 61100 and 61102, this initial bug (61101) was filed on May 9, 2011. So, in fact, this bug has been present for over …
[Read more]We wanted to optimize and test backups for one of our new large scale setup before we could finalize on the backup plan. Our challenge was the data volume was almost 30x more than our normal volumes. Since this involved large volume of data we thought this might be a good candidate to test incremental backups. We wrote a wrapper script to save the states between full backups and incremental backups and did some tests with smaller data sets. It worked perfectly fine. The version of xtrabackup we were testing was 1.6.2.
The incremental backups were completing well within 30minutes. We set out to test what would happen if the amount of incremental diff was large. While doing this test, we started getting backup failures with the following error
20110726_225312.log-110727 00:56:10
innobackupex: Starting to backup .frm, .MRG, .MYD,
.MYI,
20110726_225312.log-innobackupex: …
(at least since MySQL 5.1.42)
alter table t1 force;
Pretty neat huh? In fact, in Drizzle this will end up doing a copying alter table. Not useful.
There’s an over four year old bug report in MySQL (Bug#24091).
I’m just going to remove that bit from the parser in Drizzle – it makes no sense.
Today I discovered that you are unable to compile the current stable PHP version 5.3.4 with yesterday’s MySQL 5.5.8 GA release. I was able to download the current MySQL 5.1.54 and compile without issue.
You can find all the gory details in Bug #58987 however I was able to edit a number of MySQL include file to get a build. Does this mean it’s a MySQL packaging problem or a PHP problem I don’t know, but I would hope that Oracle in the testing phase of a GA release test this against popular programming languages starting with the LAMP stack to ensure compatibility such as what I uncovered.
Drizzle still has a number of quirks inherited from the MySQL Storage Engine API (e.g. BLOBs, row buffer, CREATE SELECT and lack of DDL transaction boundaries, key tuple format). One of the things we fixed a long time ago was to have proper methods for StorageEngines to be called for: startTransaction, startStatement, endStatement, commit and rollback.
If you’ve had to implement a transactional storage engine in MySQL you will be well aware of the pattern of “in every …
[Read more]