June 2009 - developers - lists.mariadb.org

[Maria-developers] Query cache test failure in Buildbot for mariadb 5.1
by Kristian Nielsen 07 Jun '09

07 Jun '09

Hi, There is a query cache related failure seen in Buildbot: https://askmonty.org/buildbot/builders/hardy-amd64-dbg/builds/35/steps/test… main.query_cache_28249 [ fail ] Test ended at 2009-05-21 09:13:10 CURRENT_TEST: main.query_cache_28249 --- /home/archivist/archivist-amd64/archivist-amd64/build/mysql-test/r/query_cache_28249.result 2009-05-21 09:30:15.000000000 +0300 +++ /home/archivist/archivist-amd64/archivist-amd64/build/mysql-test/r/query_cache_28249.reject 2009-05-21 11:13:10.000000000 +0300 @@ -46,7 +46,6 @@ 1 0 2 0 3 0 -4 0 RESET QUERY CACHE; SELECT *, (SELECT COUNT(*) FROM t2) FROM t1; a (SELECT COUNT(*) FROM t2) mysqltest: Result length mismatch - saving '/home/archivist/archivist-amd64/archivist-amd64/build/mysql-test/var/1/log/main.query_cache_28249/' to '/home/archivist/archivist-amd64/archivist-amd64/build/mysql-test/var/log/main.query_cache_28249/' Retrying test, attempt(2/3)... main.query_cache_28249 [ retry-pass ] 509 Retrying test, attempt(3/3)... main.query_cache_28249 [ retry-pass ] 404 I checked the bug: http://bugs.mysql.com/bug.php?id=28249 It is about a race condition in query cache and MyISAM (and re-test in Buildbot shows that it is not 100% reproducible). I am thinking that perhaps the bug was re-introduced with Maria, or in any case that someone more familiar with the MyISAM or Maria code would be better at looking into it. Any takers? - Kristian.

2 2

Re: [Maria-developers] Query cache test failure in Buildbot
by Michael Widenius 07 Jun '09

07 Jun '09

In-Reply-To: <87hbzd5mfb.fsf(a)knielsen-hq.org> References: <87hbzd5mfb.fsf(a)knielsen-hq.org> X-Mailer: VM 7.17 under 21.5 (beta28) "fuki" (+CVS-20070806) XEmacs Lucid Reply-To: monty(a)askmonty.org FCC: ~/Mail/outbox --text follows this line-- Hi! >>>>> "Kristian" == Kristian Nielsen <knielsen(a)knielsen-hq.org> writes: Kristian> Hi, Kristian> There is a query cache related failure seen in Buildbot: Kristian> https://askmonty.org/buildbot/builders/hardy-amd64-dbg/builds/35/steps/test… Kristian> main.query_cache_28249 [ fail ] Kristian> Test ended at 2009-05-21 09:13:10 Kristian> CURRENT_TEST: main.query_cache_28249 Kristian> --- /home/archivist/archivist-amd64/archivist-amd64/build/mysql-test/r/query_cache_28249.result 2009-05-21 09:30:15.000000000 +0300 Kristian> +++ /home/archivist/archivist-amd64/archivist-amd64/build/mysql-test/r/query_cache_28249.reject 2009-05-21 11:13:10.000000000 +0300 Kristian> @@ -46,7 +46,6 @@ Kristian> 1 0 Kristian> 2 0 Kristian> 3 0 Kristian> -4 0 Kristian> RESET QUERY CACHE; Kristian> SELECT *, (SELECT COUNT(*) FROM t2) FROM t1; Kristian> a (SELECT COUNT(*) FROM t2) Kristian> mysqltest: Result length mismatch Kristian> - saving '/home/archivist/archivist-amd64/archivist-amd64/build/mysql-test/var/1/log/main.query_cache_28249/' to '/home/archivist/archivist-amd64/archivist-amd64/build/mysql-test/var/log/main.query_cache_28249/' Kristian> Retrying test, attempt(2/3)... Kristian> main.query_cache_28249 [ retry-pass ] 509 Kristian> Retrying test, attempt(3/3)... Kristian> main.query_cache_28249 [ retry-pass ] 404 Kristian> I checked the bug: Kristian> http://bugs.mysql.com/bug.php?id=28249 Kristian> It is about a race condition in query cache and MyISAM (and re-test in Kristian> Buildbot shows that it is not 100% reproducible). Kristian> I am thinking that perhaps the bug was re-introduced with Maria, or in any Kristian> case that someone more familiar with the MyISAM or Maria code would be better Kristian> at looking into it. Sanja, can you create a bug report in launchpad or worklog item to get this fixed? Regards, Monty

1 0

[Maria-developers] [Branch ~maria-captains/maria/5.1] Rev 2711: Added tests to cover more server code
by noreply＠launchpad.net 07 Jun '09

07 Jun '09

------------------------------------------------------------ revno: 2711 committer: Michael Widenius <monty(a)askmonty.org> branch nick: mysql-maria timestamp: Sun 2009-06-07 13:05:19 +0300 message: Added tests to cover more server code Author: Stewart Smith modified: mysql-test/r/alter_table.result mysql-test/r/limit.result mysql-test/t/alter_table.test mysql-test/t/limit.test === modified file 'mysql-test/r/alter_table.result' --- mysql-test/r/alter_table.result 2009-02-19 09:01:25 +0000 +++ mysql-test/r/alter_table.result 2009-06-07 10:05:19 +0000 @@ -1268,4 +1268,21 @@ 4 b 5 a DROP TABLE t1; +SET @save_sql_mode=@@sql_mode; +SET sql_mode=strict_all_tables; +CREATE TABLE t1 (a int NOT NULL default 42); +INSERT INTO t1 values (); +SELECT * FROM t1; +a +42 +ALTER TABLE t1 ALTER COLUMN a DROP DEFAULT; +INSERT INTO t1 values (); +ERROR HY000: Field 'a' doesn't have a default value +INSERT INTO t1 (a) VALUES (11); +SELECT * FROM t1 ORDER BY a; +a +11 +42 +DROP TABLE t1; +SET @@sql_mode=@save_sql_mode; End of 5.1 tests === modified file 'mysql-test/r/limit.result' --- mysql-test/r/limit.result 2008-10-15 21:34:51 +0000 +++ mysql-test/r/limit.result 2009-06-07 10:05:19 +0000 @@ -113,4 +113,36 @@ End of 5.0 tests select 1 as a limit 4294967296,10; a +CREATE TABLE t1 (a int PRIMARY KEY auto_increment); +INSERT INTO t1 VALUES (),(),(),(),(),(),(),(),(),(); +INSERT INTO t1 VALUES (),(),(),(),(),(),(),(),(),(); +SELECT a FROM t1 ORDER BY a LIMIT 10 OFFSET 1; +a +2 +3 +4 +5 +6 +7 +8 +9 +10 +11 +SELECT a FROM t1 ORDER BY a LIMIT 10 OFFSET 10; +a +11 +12 +13 +14 +15 +16 +17 +18 +19 +20 +SELECT a FROM t1 ORDER BY a LIMIT 2 OFFSET 14; +a +15 +16 +DROP TABLE t1; End of 5.1 tests === modified file 'mysql-test/t/alter_table.test' --- mysql-test/t/alter_table.test 2009-02-19 09:01:25 +0000 +++ mysql-test/t/alter_table.test 2009-06-07 10:05:19 +0000 @@ -1000,4 +1000,22 @@ SELECT * FROM t1; DROP TABLE t1; +# +# Test for ALTER column DROP DEFAULT +# + +SET @save_sql_mode=@@sql_mode; +SET sql_mode=strict_all_tables; + +CREATE TABLE t1 (a int NOT NULL default 42); +INSERT INTO t1 values (); +SELECT * FROM t1; +ALTER TABLE t1 ALTER COLUMN a DROP DEFAULT; +--error 1364 +INSERT INTO t1 values (); +INSERT INTO t1 (a) VALUES (11); +SELECT * FROM t1 ORDER BY a; +DROP TABLE t1; +SET @@sql_mode=@save_sql_mode; + --echo End of 5.1 tests === modified file 'mysql-test/t/limit.test' --- mysql-test/t/limit.test 2008-10-16 01:50:56 +0000 +++ mysql-test/t/limit.test 2009-06-07 10:05:19 +0000 @@ -102,4 +102,16 @@ select 1 as a limit 4294967296,10; +# +# Test for LIMIT X OFFSET Y +# + +CREATE TABLE t1 (a int PRIMARY KEY auto_increment); +INSERT INTO t1 VALUES (),(),(),(),(),(),(),(),(),(); +INSERT INTO t1 VALUES (),(),(),(),(),(),(),(),(),(); +SELECT a FROM t1 ORDER BY a LIMIT 10 OFFSET 1; +SELECT a FROM t1 ORDER BY a LIMIT 10 OFFSET 10; +SELECT a FROM t1 ORDER BY a LIMIT 2 OFFSET 14; +DROP TABLE t1; + --echo End of 5.1 tests -- lp:maria https://code.launchpad.net/~maria-captains/maria/5.1 Your team Maria developers is subscribed to branch lp:maria. To unsubscribe from this branch go to https://code.launchpad.net/~maria-captains/maria/5.1/+edit-subscription.

1 0

[Maria-developers] bzr commit into MariaDB 5.1, with Maria 1.5:maria branch (monty:2711)
by Michael Widenius 07 Jun '09

07 Jun '09

#At lp:maria based on revid:monty@askmonty.org-20090605204623-ptvh44epiw0pyoj6 2711 Michael Widenius 2009-06-07 Added tests to cover more server code Author: Stewart Smith modified: mysql-test/r/alter_table.result mysql-test/r/limit.result mysql-test/t/alter_table.test mysql-test/t/limit.test per-file messages: mysql-test/r/alter_table.result Testing of ALTER TABLE .. DROP DEFAULT mysql-test/r/limit.result Testing of LIMIT ... OFFSET mysql-test/t/alter_table.test Testing of ALTER TABLE .. DROP DEFAULT mysql-test/t/limit.test Testing of LIMIT ... OFFSET === modified file 'mysql-test/r/alter_table.result' --- a/mysql-test/r/alter_table.result 2009-02-19 09:01:25 +0000 +++ b/mysql-test/r/alter_table.result 2009-06-07 10:05:19 +0000 @@ -1268,4 +1268,21 @@ a b 4 b 5 a DROP TABLE t1; +SET @save_sql_mode=@@sql_mode; +SET sql_mode=strict_all_tables; +CREATE TABLE t1 (a int NOT NULL default 42); +INSERT INTO t1 values (); +SELECT * FROM t1; +a +42 +ALTER TABLE t1 ALTER COLUMN a DROP DEFAULT; +INSERT INTO t1 values (); +ERROR HY000: Field 'a' doesn't have a default value +INSERT INTO t1 (a) VALUES (11); +SELECT * FROM t1 ORDER BY a; +a +11 +42 +DROP TABLE t1; +SET @@sql_mode=@save_sql_mode; End of 5.1 tests === modified file 'mysql-test/r/limit.result' --- a/mysql-test/r/limit.result 2008-10-15 21:34:51 +0000 +++ b/mysql-test/r/limit.result 2009-06-07 10:05:19 +0000 @@ -113,4 +113,36 @@ ERROR HY000: Incorrect arguments to EXEC End of 5.0 tests select 1 as a limit 4294967296,10; a +CREATE TABLE t1 (a int PRIMARY KEY auto_increment); +INSERT INTO t1 VALUES (),(),(),(),(),(),(),(),(),(); +INSERT INTO t1 VALUES (),(),(),(),(),(),(),(),(),(); +SELECT a FROM t1 ORDER BY a LIMIT 10 OFFSET 1; +a +2 +3 +4 +5 +6 +7 +8 +9 +10 +11 +SELECT a FROM t1 ORDER BY a LIMIT 10 OFFSET 10; +a +11 +12 +13 +14 +15 +16 +17 +18 +19 +20 +SELECT a FROM t1 ORDER BY a LIMIT 2 OFFSET 14; +a +15 +16 +DROP TABLE t1; End of 5.1 tests === modified file 'mysql-test/t/alter_table.test' --- a/mysql-test/t/alter_table.test 2009-02-19 09:01:25 +0000 +++ b/mysql-test/t/alter_table.test 2009-06-07 10:05:19 +0000 @@ -1000,4 +1000,22 @@ ALTER TABLE t1 MODIFY b ENUM('a', 'z', ' SELECT * FROM t1; DROP TABLE t1; +# +# Test for ALTER column DROP DEFAULT +# + +SET @save_sql_mode=@@sql_mode; +SET sql_mode=strict_all_tables; + +CREATE TABLE t1 (a int NOT NULL default 42); +INSERT INTO t1 values (); +SELECT * FROM t1; +ALTER TABLE t1 ALTER COLUMN a DROP DEFAULT; +--error 1364 +INSERT INTO t1 values (); +INSERT INTO t1 (a) VALUES (11); +SELECT * FROM t1 ORDER BY a; +DROP TABLE t1; +SET @@sql_mode=@save_sql_mode; + --echo End of 5.1 tests === modified file 'mysql-test/t/limit.test' --- a/mysql-test/t/limit.test 2008-10-16 01:50:56 +0000 +++ b/mysql-test/t/limit.test 2009-06-07 10:05:19 +0000 @@ -102,4 +102,16 @@ execute s using @a, @a; select 1 as a limit 4294967296,10; +# +# Test for LIMIT X OFFSET Y +# + +CREATE TABLE t1 (a int PRIMARY KEY auto_increment); +INSERT INTO t1 VALUES (),(),(),(),(),(),(),(),(),(); +INSERT INTO t1 VALUES (),(),(),(),(),(),(),(),(),(); +SELECT a FROM t1 ORDER BY a LIMIT 10 OFFSET 1; +SELECT a FROM t1 ORDER BY a LIMIT 10 OFFSET 10; +SELECT a FROM t1 ORDER BY a LIMIT 2 OFFSET 14; +DROP TABLE t1; + --echo End of 5.1 tests

1 0

[Maria-developers] Patches to consider to include
by Vadim Tkachenko 07 Jun '09

07 Jun '09

Hello, What do you think about including patches global_trx_ids, binlog event checksums and fixes to crash-proof slaves from https://code.launchpad.net/~jtolmer/mysql-server/global-trx-ids into tree ? -- Vadim Tkachenko, CTO Percona Inc. ICQ: 369-510-335, Skype: vadimtk153, Phone +1-888-401-3403 MySQL Performance Blog - http://www.mysqlperformanceblog.com MySQL Consulting http://www.percona.com/

6 9

[Maria-developers] New (by Monty): global transaction id (31)
by worklog-noreply＠askmonty.org 07 Jun '09

07 Jun '09

----------------------------------------------------------------------- WORKLOG TASK -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- TASK...........: global transaction id CREATION DATE..: Sun, 07 Jun 2009, 10:59 SUPERVISOR.....: Bothorsen IMPLEMENTOR....: COPIES TO......: CATEGORY.......: Server-BackLog TASK ID........: 31 (http://askmonty.org/worklog/?tid=31) VERSION........: Benchmarks-3.0 STATUS.........: Un-Assigned PRIORITY.......: 60 WORKED HOURS...: 0 ESTIMATE.......: 4 (hours remain) ORIG. ESTIMATE.: 4 PROGRESS NOTES: DESCRIPTION: Consider including patches global_trx_ids, binlog event checksums and fixes to crash-proof slaves from https://code.launchpad.net/~jtolmer/mysql-server/global-trx-ids First we should investigate if we can do this in a manner compatible with MySQL 5.1. We want to ensure that we keep a high compatibility between MariaDB and MySQL so that both can be a drop in replacement to each other when it comes to how data and logs are stored. ESTIMATED WORK TIME ESTIMATED COMPLETION DATE ----------------------------------------------------------------------- WorkLog (v3.5.9)

1 0

[Maria-developers] New (by Monty): global transaction id (31)
by worklog-noreply＠askmonty.org 07 Jun '09

07 Jun '09

----------------------------------------------------------------------- WORKLOG TASK -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- TASK...........: global transaction id CREATION DATE..: Sun, 07 Jun 2009, 10:59 SUPERVISOR.....: Bothorsen IMPLEMENTOR....: COPIES TO......: CATEGORY.......: Server-BackLog TASK ID........: 31 (http://askmonty.org/worklog/?tid=31) VERSION........: Benchmarks-3.0 STATUS.........: Un-Assigned PRIORITY.......: 60 WORKED HOURS...: 0 ESTIMATE.......: 4 (hours remain) ORIG. ESTIMATE.: 4 PROGRESS NOTES: DESCRIPTION: Consider including patches global_trx_ids, binlog event checksums and fixes to crash-proof slaves from https://code.launchpad.net/~jtolmer/mysql-server/global-trx-ids First we should investigate if we can do this in a manner compatible with MySQL 5.1. We want to ensure that we keep a high compatibility between MariaDB and MySQL so that both can be a drop in replacement to each other when it comes to how data and logs are stored. ESTIMATED WORK TIME ESTIMATED COMPLETION DATE ----------------------------------------------------------------------- WorkLog (v3.5.9)

1 0

[Maria-developers] Buildbot Idea
by Adam M. Dutko 06 Jun '09

06 Jun '09

Kristian, Maybe Linode.com or Slicehost.com would be interested in donating a few VPS boxes to Maria? I use Linode.com for a few things and they have a large selection of "distros." -Adam

2 1

[Maria-developers] microslow-innodb ported to 5.1
by Vadim Tkachenko 06 Jun '09

06 Jun '09

Hi, We already ported patch http://www.percona.com/mysql/5.0.77-b13/patches/microslow_innodb.patch (from list http://askmonty.org/wiki/index.php/MariaDB_versus_MySQL#What_kind_of_patche… ) to 5.1, so it will be easy to include it into MariaDB. I will propose merge soon, so let's do not duplicate work if you are going to look into this patch also. -- Vadim Tkachenko, CTO Percona Inc. ICQ: 369-510-335, Skype: vadimtk153, Phone +1-888-401-3403 MySQL Performance Blog - http://www.mysqlperformanceblog.com MySQL Consulting http://www.percona.com/

5 11

[Maria-developers] [Branch ~maria-captains/maria/5.1] Rev 2710: Fixed valgrind warnings on 64 bit x86 SuSE 11.1
by noreply＠launchpad.net 05 Jun '09

05 Jun '09

------------------------------------------------------------ revno: 2710 committer: Michael Widenius <monty(a)askmonty.org> branch nick: mysql-maria timestamp: Fri 2009-06-05 23:46:23 +0300 message: Fixed valgrind warnings on 64 bit x86 SuSE 11.1 modified: mysql-test/valgrind.supp === modified file 'mysql-test/valgrind.supp' --- mysql-test/valgrind.supp 2009-06-05 15:35:22 +0000 +++ mysql-test/valgrind.supp 2009-06-05 20:46:23 +0000 @@ -422,12 +422,25 @@ obj:/lib*/ld-*.so obj:/lib*/ld-*.so obj:/lib*/libdl-*.so - fun:_dl_close + fun:dlclose fun:_ZL15free_plugin_memP12st_plugin_dl fun:_ZL13plugin_dl_delPK19st_mysql_lex_string } { + dlclose memory loss from plugin variant 5 + Memcheck:Leak + fun:malloc + obj:/lib*/ld-*.so + obj:/lib*/ld-*.so + obj:/lib*/ld-*.so + obj:/lib*/ld-*.so + obj:/lib*/libdl-*.so + fun:dlclose + fun:_ZL15free_plugin_memP12st_plugin_dl +} + +{ dlopen / ptread_cancel_init memory loss on Suse Linux 10.3 32/64 bit ver 1 Memcheck:Leak fun:*alloc -- lp:maria https://code.launchpad.net/~maria-captains/maria/5.1 Your team Maria developers is subscribed to branch lp:maria. To unsubscribe from this branch go to https://code.launchpad.net/~maria-captains/maria/5.1/+edit-subscription.

1 0