- developers - lists.mariadb.org

[Maria-developers] Go for MariaDB 5.1.39 release
by Kristian Nielsen 14 Nov '09

14 Nov '09

I pushed the final fixes, including the merge of XtraDB, into the release branch: lp:~maria-captains/maria/5.1-release I tagged the latest revision with the tag tag:mariadb-5.1.39-beta Daniel, for the release notes please mark that this release is based on MySQL 5.1.39 and XtraDB 8 (which has InnoDB plugin 1.0.4 as base). Arjen, we are now go for final release build. Hopefully we can be ready for release Tuesday, which according to my information would allow Monty to announce the release at OpenSQL Camp. You can use tarbake51/sh tag:mariadb-5.1.39-beta lp:~maria-captains/maria/5.1-release to be 100% sure to grab the right revision for the release (or whatever variant fits your build infrastructure best). There is still the mysql_client_test failure on Ubuntu 9.10 Karmic. We need to fix this for the next MariaDB 5.1.41 release. There are also other failures seen in Buildbot, including - A number of sporadic test failures that occur only occasionally. - Windows test failures. - Solaris build failure and Mac test failures. - Test failures on non-max builds. For these reasons I think it is correct to still call this release only a Beta. We should fix these issues for 5.1.41, and if no serious new issues are reported on 5.1.39 I think we can plan for 5.1.41 to be a release candidate. - Kristian.

1 0

[Maria-developers] bzr commit into MariaDB 5.1, with Maria 1.5:maria branch (knielsen:2768)
by knielsen＠knielsen-hq.org 14 Nov '09

14 Nov '09

#At lp:maria 2768 knielsen(a)knielsen-hq.org 2009-11-14 XtraDB 8 after-merge fix: Fix windows build. modified: storage/xtradb/CMakeLists.txt === modified file 'storage/xtradb/CMakeLists.txt' --- a/storage/xtradb/CMakeLists.txt 2009-11-13 21:26:08 +0000 +++ b/storage/xtradb/CMakeLists.txt 2009-11-14 09:53:18 +0000 @@ -44,7 +44,7 @@ IF(MSVC AND $(WIN64)) PROPERTIES COMPILE_FLAGS -Od) ENDIF(MSVC AND $(WIN64)) -SET(INNODB_SOURCES btr/btr0btr.c btr/btr0cur.c btr/btr0pcur.c btr/btr0sea.c +SET(INNOBASE_SOURCES btr/btr0btr.c btr/btr0cur.c btr/btr0pcur.c btr/btr0sea.c buf/buf0buddy.c buf/buf0buf.c buf/buf0flu.c buf/buf0lru.c buf/buf0rea.c data/data0data.c data/data0type.c dict/dict0boot.c dict/dict0crea.c dict/dict0dict.c dict/dict0load.c dict/dict0mem.c

1 0

[Maria-developers] bzr commit into MariaDB 5.1, with Maria 1.5:maria branch (knielsen:2767)
by knielsen＠knielsen-hq.org 14 Nov '09

14 Nov '09

#At lp:maria 2767 knielsen(a)knielsen-hq.org 2009-11-14 XtraDB 8 after-merge fixes: fix forgotten manual merge of patch file. modified: mysql-test/include/index_merge2.inc mysql-test/r/index_merge_innodb.result mysql-test/r/index_merge_myisam.result === modified file 'mysql-test/include/index_merge2.inc' --- a/mysql-test/include/index_merge2.inc 2006-09-14 19:44:17 +0000 +++ b/mysql-test/include/index_merge2.inc 2009-11-14 01:15:03 +0000 @@ -122,12 +122,14 @@ insert into t1 (key1a, key1b, key2a, key analyze table t1; select count(*) from t1; +--replace_column 9 REF explain select count(*) from t1 where key1a = 2 and key1b is null and key2a = 2 and key2b is null; select count(*) from t1 where key1a = 2 and key1b is null and key2a = 2 and key2b is null; +--replace_column 9 REF explain select count(*) from t1 where key1a = 2 and key1b is null and key3a = 2 and key3b is null; === modified file 'mysql-test/r/index_merge_innodb.result' --- a/mysql-test/r/index_merge_innodb.result 2009-06-09 13:19:13 +0000 +++ b/mysql-test/r/index_merge_innodb.result 2009-11-14 01:15:03 +0000 @@ -111,7 +111,7 @@ count(*) explain select count(*) from t1 where key1a = 2 and key1b is null and key2a = 2 and key2b is null; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 index_merge i1,i2 i1,i2 10,10 NULL 3 Using intersect(i1,i2); Using where; Using index +1 SIMPLE t1 index_merge i1,i2 i1,i2 10,10 NULL REF Using intersect(i1,i2); Using where; Using index select count(*) from t1 where key1a = 2 and key1b is null and key2a = 2 and key2b is null; count(*) @@ -119,7 +119,7 @@ count(*) explain select count(*) from t1 where key1a = 2 and key1b is null and key3a = 2 and key3b is null; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 index_merge i1,i3 i1,i3 10,10 NULL 3 Using intersect(i1,i3); Using where; Using index +1 SIMPLE t1 index_merge i1,i3 i1,i3 10,10 NULL REF Using intersect(i1,i3); Using where; Using index select count(*) from t1 where key1a = 2 and key1b is null and key3a = 2 and key3b is null; count(*) === modified file 'mysql-test/r/index_merge_myisam.result' --- a/mysql-test/r/index_merge_myisam.result 2009-06-15 14:36:51 +0000 +++ b/mysql-test/r/index_merge_myisam.result 2009-11-14 01:15:03 +0000 @@ -945,7 +945,7 @@ count(*) explain select count(*) from t1 where key1a = 2 and key1b is null and key2a = 2 and key2b is null; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 index_merge i1,i2 i1,i2 10,10 NULL 2 Using intersect(i1,i2); Using where; Using index +1 SIMPLE t1 index_merge i1,i2 i1,i2 10,10 NULL REF Using intersect(i1,i2); Using where; Using index select count(*) from t1 where key1a = 2 and key1b is null and key2a = 2 and key2b is null; count(*) @@ -953,7 +953,7 @@ count(*) explain select count(*) from t1 where key1a = 2 and key1b is null and key3a = 2 and key3b is null; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 index_merge i1,i3 i1,i3 10,10 NULL 2 Using intersect(i1,i3); Using where; Using index +1 SIMPLE t1 index_merge i1,i3 i1,i3 10,10 NULL REF Using intersect(i1,i3); Using where; Using index select count(*) from t1 where key1a = 2 and key1b is null and key3a = 2 and key3b is null; count(*)

1 0

[Maria-developers] bzr commit into MariaDB 5.1, with Maria 1.5:maria branch (knielsen:2766)
by knielsen＠knielsen-hq.org 13 Nov '09

13 Nov '09

#At lp:maria 2766 knielsen(a)knielsen-hq.org 2009-11-13 XtraDB 8 after-merge fix: Add missing header to `make dist`. modified: storage/xtradb/Makefile.am === modified file 'storage/xtradb/Makefile.am' --- a/storage/xtradb/Makefile.am 2009-11-13 21:26:08 +0000 +++ b/storage/xtradb/Makefile.am 2009-11-13 22:53:04 +0000 @@ -78,6 +78,7 @@ noinst_HEADERS= \ include/fil0fil.h \ include/fsp0fsp.h \ include/fsp0fsp.ic \ + include/fsp0types.h \ include/fut0fut.h \ include/fut0fut.ic \ include/fut0lst.h \

1 0

[Maria-developers] bzr commit into MariaDB 5.1, with Maria 1.5:maria branch (knielsen:2765)
by knielsen＠knielsen-hq.org 13 Nov '09

13 Nov '09

#At lp:maria 2765 knielsen(a)knielsen-hq.org 2009-11-13 [merge] Merge XtraDB 8. modified: storage/federatedx/Makefile.am storage/federatedx/ha_federatedx.cc === modified file 'storage/federatedx/Makefile.am' --- a/storage/federatedx/Makefile.am 2009-11-01 15:09:55 +0000 +++ b/storage/federatedx/Makefile.am 2009-11-10 13:55:48 +0000 @@ -22,7 +22,6 @@ pkgplugin_LTLIBRARIES = @plugin_federate ha_federatedx_la_LDFLAGS = -module -rpath $(pkgplugindir) ha_federatedx_la_CXXFLAGS= $(AM_CFLAGS) -DMYSQL_DYNAMIC_PLUGIN ha_federatedx_la_CFLAGS = $(AM_CFLAGS) -DMYSQL_DYNAMIC_PLUGIN -ha_federatedx_la_SOURCES = ha_federatedx.cc EXTRA_LIBRARIES = libfederatedx.a === modified file 'storage/federatedx/ha_federatedx.cc' --- a/storage/federatedx/ha_federatedx.cc 2009-11-03 11:08:09 +0000 +++ b/storage/federatedx/ha_federatedx.cc 2009-11-10 08:35:39 +0000 @@ -390,8 +390,8 @@ int federatedx_db_init(void *p) DBUG_ENTER("federatedx_db_init"); handlerton *federatedx_hton= (handlerton *)p; federatedx_hton->state= SHOW_OPTION_YES; - /* This is no longer needed for plugin storage engines */ - federatedx_hton->db_type= DB_TYPE_DEFAULT; + /* Needed to work with old .frm files */ + federatedx_hton->db_type= DB_TYPE_FEDERATED_DB; federatedx_hton->savepoint_offset= sizeof(ulong); federatedx_hton->close_connection= ha_federatedx::disconnect; federatedx_hton->savepoint_set= ha_federatedx::savepoint_set;

1 0

[Maria-developers] Progress (by Sanja): Avoid flushing keycache to disk in case of DROPping table (53)
by worklog-noreply＠askmonty.org 13 Nov '09

13 Nov '09

----------------------------------------------------------------------- WORKLOG TASK -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- TASK...........: Avoid flushing keycache to disk in case of DROPping table CREATION DATE..: Thu, 27 Aug 2009, 11:12 SUPERVISOR.....: Monty IMPLEMENTOR....: Sanja COPIES TO......: CATEGORY.......: Server-Sprint TASK ID........: 53 (http://askmonty.org/worklog/?tid=53) VERSION........: Server-5.0 STATUS.........: Complete PRIORITY.......: 60 WORKED HOURS...: 21 ESTIMATE.......: 0 (hours remain) ORIG. ESTIMATE.: 24 PROGRESS NOTES: -=-=(Sanja - Fri, 13 Nov 2009, 10:55)=-=- Ported to maria 5.1 _ maria and partitioning support added and tested Worked 2 hours and estimate 0 hours remain (original estimate increased by 2 hours). -=-=(Sanja - Fri, 13 Nov 2009, 00:24)=-=- Ported to mysql 5.1 and tested Worked 5 hours and estimate 0 hours remain (original estimate increased by 5 hours). -=-=(Sanja - Tue, 06 Oct 2009, 12:30)=-=- Status updated. --- /tmp/wklog.53.old.27223 2009-10-06 12:30:38.000000000 +0300 +++ /tmp/wklog.53.new.27223 2009-10-06 12:30:38.000000000 +0300 @@ -1 +1 @@ -Assigned +Complete -=-=(Sanja - Tue, 06 Oct 2009, 12:30)=-=- After review fixes and tests. Worked 1 hour and estimate 0 hours remain (original estimate decreased by 10 hours). -=-=(Sanja - Thu, 03 Sep 2009, 19:43)=-=- New patch and its testing Worked 8 hours and estimate 11 hours remain (original estimate unchanged). -=-=(Sanja - Tue, 01 Sep 2009, 15:20)=-=- moving to 5.0 part1 Worked 2 hours and estimate 19 hours remain (original estimate unchanged). -=-=(Sanja - Tue, 01 Sep 2009, 15:19)=-=- first patch Worked 3 hours and estimate 21 hours remain (original estimate unchanged). -=-=(Sanja - Thu, 27 Aug 2009, 11:15)=-=- High-Level Specification modified. --- /tmp/wklog.53.old.23490 2009-08-27 11:15:24.000000000 +0300 +++ /tmp/wklog.53.new.23490 2009-08-27 11:15:24.000000000 +0300 @@ -1 +1,3 @@ - +To make special handler call 'prepare to drop' which mark table as changed (in +case of server crash just before removing table it force table to be repaired) +then flush keycache without writing on disk. DESCRIPTION: When DROP TABLE executed keycache flushed to disk before removing table which is wasting of resources. So better to have table removed from keycache without writing changes on disk. HIGH-LEVEL SPECIFICATION: To make special handler call 'prepare to drop' which mark table as changed (in case of server crash just before removing table it force table to be repaired) then flush keycache without writing on disk. ESTIMATED WORK TIME ESTIMATED COMPLETION DATE ----------------------------------------------------------------------- WorkLog (v3.5.9)

1 0

[Maria-developers] Progress (by Sanja): Avoid flushing keycache to disk in case of DROPping table (53)
by worklog-noreply＠askmonty.org 13 Nov '09

13 Nov '09

----------------------------------------------------------------------- WORKLOG TASK -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- TASK...........: Avoid flushing keycache to disk in case of DROPping table CREATION DATE..: Thu, 27 Aug 2009, 11:12 SUPERVISOR.....: Monty IMPLEMENTOR....: Sanja COPIES TO......: CATEGORY.......: Server-Sprint TASK ID........: 53 (http://askmonty.org/worklog/?tid=53) VERSION........: Server-5.0 STATUS.........: Complete PRIORITY.......: 60 WORKED HOURS...: 21 ESTIMATE.......: 0 (hours remain) ORIG. ESTIMATE.: 24 PROGRESS NOTES: -=-=(Sanja - Fri, 13 Nov 2009, 10:55)=-=- Ported to maria 5.1 _ maria and partitioning support added and tested Worked 2 hours and estimate 0 hours remain (original estimate increased by 2 hours). -=-=(Sanja - Fri, 13 Nov 2009, 00:24)=-=- Ported to mysql 5.1 and tested Worked 5 hours and estimate 0 hours remain (original estimate increased by 5 hours). -=-=(Sanja - Tue, 06 Oct 2009, 12:30)=-=- Status updated. --- /tmp/wklog.53.old.27223 2009-10-06 12:30:38.000000000 +0300 +++ /tmp/wklog.53.new.27223 2009-10-06 12:30:38.000000000 +0300 @@ -1 +1 @@ -Assigned +Complete -=-=(Sanja - Tue, 06 Oct 2009, 12:30)=-=- After review fixes and tests. Worked 1 hour and estimate 0 hours remain (original estimate decreased by 10 hours). -=-=(Sanja - Thu, 03 Sep 2009, 19:43)=-=- New patch and its testing Worked 8 hours and estimate 11 hours remain (original estimate unchanged). -=-=(Sanja - Tue, 01 Sep 2009, 15:20)=-=- moving to 5.0 part1 Worked 2 hours and estimate 19 hours remain (original estimate unchanged). -=-=(Sanja - Tue, 01 Sep 2009, 15:19)=-=- first patch Worked 3 hours and estimate 21 hours remain (original estimate unchanged). -=-=(Sanja - Thu, 27 Aug 2009, 11:15)=-=- High-Level Specification modified. --- /tmp/wklog.53.old.23490 2009-08-27 11:15:24.000000000 +0300 +++ /tmp/wklog.53.new.23490 2009-08-27 11:15:24.000000000 +0300 @@ -1 +1,3 @@ - +To make special handler call 'prepare to drop' which mark table as changed (in +case of server crash just before removing table it force table to be repaired) +then flush keycache without writing on disk. DESCRIPTION: When DROP TABLE executed keycache flushed to disk before removing table which is wasting of resources. So better to have table removed from keycache without writing changes on disk. HIGH-LEVEL SPECIFICATION: To make special handler call 'prepare to drop' which mark table as changed (in case of server crash just before removing table it force table to be repaired) then flush keycache without writing on disk. ESTIMATED WORK TIME ESTIMATED COMPLETION DATE ----------------------------------------------------------------------- WorkLog (v3.5.9)

1 0

[Maria-developers] Progress (by Sanja): Avoid flushing keycache to disk in case of DROPping table (53)
by worklog-noreply＠askmonty.org 12 Nov '09

12 Nov '09

----------------------------------------------------------------------- WORKLOG TASK -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- TASK...........: Avoid flushing keycache to disk in case of DROPping table CREATION DATE..: Thu, 27 Aug 2009, 11:12 SUPERVISOR.....: Monty IMPLEMENTOR....: Sanja COPIES TO......: CATEGORY.......: Server-Sprint TASK ID........: 53 (http://askmonty.org/worklog/?tid=53) VERSION........: Server-5.0 STATUS.........: Complete PRIORITY.......: 60 WORKED HOURS...: 19 ESTIMATE.......: 0 (hours remain) ORIG. ESTIMATE.: 24 PROGRESS NOTES: -=-=(Sanja - Fri, 13 Nov 2009, 00:24)=-=- Ported to mysql 5.1 and tested Worked 5 hours and estimate 0 hours remain (original estimate increased by 5 hours). -=-=(Sanja - Tue, 06 Oct 2009, 12:30)=-=- Status updated. --- /tmp/wklog.53.old.27223 2009-10-06 12:30:38.000000000 +0300 +++ /tmp/wklog.53.new.27223 2009-10-06 12:30:38.000000000 +0300 @@ -1 +1 @@ -Assigned +Complete -=-=(Sanja - Tue, 06 Oct 2009, 12:30)=-=- After review fixes and tests. Worked 1 hour and estimate 0 hours remain (original estimate decreased by 10 hours). -=-=(Sanja - Thu, 03 Sep 2009, 19:43)=-=- New patch and its testing Worked 8 hours and estimate 11 hours remain (original estimate unchanged). -=-=(Sanja - Tue, 01 Sep 2009, 15:20)=-=- moving to 5.0 part1 Worked 2 hours and estimate 19 hours remain (original estimate unchanged). -=-=(Sanja - Tue, 01 Sep 2009, 15:19)=-=- first patch Worked 3 hours and estimate 21 hours remain (original estimate unchanged). -=-=(Sanja - Thu, 27 Aug 2009, 11:15)=-=- High-Level Specification modified. --- /tmp/wklog.53.old.23490 2009-08-27 11:15:24.000000000 +0300 +++ /tmp/wklog.53.new.23490 2009-08-27 11:15:24.000000000 +0300 @@ -1 +1,3 @@ - +To make special handler call 'prepare to drop' which mark table as changed (in +case of server crash just before removing table it force table to be repaired) +then flush keycache without writing on disk. DESCRIPTION: When DROP TABLE executed keycache flushed to disk before removing table which is wasting of resources. So better to have table removed from keycache without writing changes on disk. HIGH-LEVEL SPECIFICATION: To make special handler call 'prepare to drop' which mark table as changed (in case of server crash just before removing table it force table to be repaired) then flush keycache without writing on disk. ESTIMATED WORK TIME ESTIMATED COMPLETION DATE ----------------------------------------------------------------------- WorkLog (v3.5.9)

1 0

[Maria-developers] Progress (by Sanja): Avoid flushing keycache to disk in case of DROPping table (53)
by worklog-noreply＠askmonty.org 12 Nov '09

12 Nov '09

----------------------------------------------------------------------- WORKLOG TASK -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- TASK...........: Avoid flushing keycache to disk in case of DROPping table CREATION DATE..: Thu, 27 Aug 2009, 11:12 SUPERVISOR.....: Monty IMPLEMENTOR....: Sanja COPIES TO......: CATEGORY.......: Server-Sprint TASK ID........: 53 (http://askmonty.org/worklog/?tid=53) VERSION........: Server-5.0 STATUS.........: Complete PRIORITY.......: 60 WORKED HOURS...: 19 ESTIMATE.......: 0 (hours remain) ORIG. ESTIMATE.: 24 PROGRESS NOTES: -=-=(Sanja - Fri, 13 Nov 2009, 00:24)=-=- Ported to mysql 5.1 and tested Worked 5 hours and estimate 0 hours remain (original estimate increased by 5 hours). -=-=(Sanja - Tue, 06 Oct 2009, 12:30)=-=- Status updated. --- /tmp/wklog.53.old.27223 2009-10-06 12:30:38.000000000 +0300 +++ /tmp/wklog.53.new.27223 2009-10-06 12:30:38.000000000 +0300 @@ -1 +1 @@ -Assigned +Complete -=-=(Sanja - Tue, 06 Oct 2009, 12:30)=-=- After review fixes and tests. Worked 1 hour and estimate 0 hours remain (original estimate decreased by 10 hours). -=-=(Sanja - Thu, 03 Sep 2009, 19:43)=-=- New patch and its testing Worked 8 hours and estimate 11 hours remain (original estimate unchanged). -=-=(Sanja - Tue, 01 Sep 2009, 15:20)=-=- moving to 5.0 part1 Worked 2 hours and estimate 19 hours remain (original estimate unchanged). -=-=(Sanja - Tue, 01 Sep 2009, 15:19)=-=- first patch Worked 3 hours and estimate 21 hours remain (original estimate unchanged). -=-=(Sanja - Thu, 27 Aug 2009, 11:15)=-=- High-Level Specification modified. --- /tmp/wklog.53.old.23490 2009-08-27 11:15:24.000000000 +0300 +++ /tmp/wklog.53.new.23490 2009-08-27 11:15:24.000000000 +0300 @@ -1 +1,3 @@ - +To make special handler call 'prepare to drop' which mark table as changed (in +case of server crash just before removing table it force table to be repaired) +then flush keycache without writing on disk. DESCRIPTION: When DROP TABLE executed keycache flushed to disk before removing table which is wasting of resources. So better to have table removed from keycache without writing changes on disk. HIGH-LEVEL SPECIFICATION: To make special handler call 'prepare to drop' which mark table as changed (in case of server crash just before removing table it force table to be repaired) then flush keycache without writing on disk. ESTIMATED WORK TIME ESTIMATED COMPLETION DATE ----------------------------------------------------------------------- WorkLog (v3.5.9)

1 0

[Maria-developers] Launchpad bugs don't have dependencies?
by Henrik Ingo 12 Nov '09

12 Nov '09

I think I have even asked this before, but since I still don't believe it's true: Is there no way that one Launchpad bug can depend on another bug? henrik -- email: henrik.ingo(a)avoinelama.fi tel: +358-40-5697354 www: www.avoinelama.fi/~hingo book: www.openlife.cc

1 0