- developers - lists.mariadb.org

[Maria-developers] Difference between 0xHHHH and X'HHHH' hex literals
by Alexander Barkov 24 Apr '14

24 Apr '14

Hello Ian, I tried to explain in https://mariadb.atlassian.net/browse/MDEV-6092 to the complainer why it's not a bug. Can you please document the difference between the two hex notations and then close as "not a bug"? Thanks.

1 0

Re: [Maria-developers] bb01.mariadb.net
by Kristian Nielsen 23 Apr '14

23 Apr '14

Daniel Bartholomew <dbart(a)mariadb.com> writes: > Serg and Knielsen: I've got the box mostly configured I think, but > could be (very) wrong, so I wanted to give you a chance to make sure > everything looks good on it before I go ahead and add it to the It looks like it already mostly works. I noticed an error in a build though: https://buildbot.askmonty.org/buildbot/builders/kvm-tarbake-jaunty-x86/buil… The "kernel" log has this: ----------------------------------------------------------------------- /dev/sda1 contains a file system with errors, check forced. /dev/sda1: Entry 'pack-names' in /home/buildbot/.bzr/repository (3415) has an incorrect filetype (was 1, should be 2). /dev/sda1: UNEXPECTED INCONSISTENCY; RUN fsck MANUALLY. (i.e., without -a or -p options) ----------------------------------------------------------------------- One likely reason is a failed rsync step. This is the tarbake build; unlike most other virtual machines, this one is actually modified during a build. So it's quite possible that the rsync would go wrong if a tarbake build happened to run in the meantime. So just re-sync that particular VM, and that might solve the problem. Thanks for setting this up! - Kristian.

2 1

[Maria-developers] [GSoC] Accepted student ready to work : )
by Pablo Estrada 23 Apr '14

23 Apr '14

Hello Sergei, Elena and everyone, I'm Pablo, and I was selected as part of Google Summer of Code 2014 to work on the project "*Statistically optimize mysql-test runs by running less tests*". First of all, thank you very much for having selected me for the project. I am very excited to start reading, reviewing data and coding up. I see that Elena will be my mentor. Nice to meet you Elena : ) To begin with, I am focusing on the *Buildbot documentation*, to *(1)understand how the data is organized* inside it, and to *(2)*figure out *how to add the extra functionality* into the BuildBot. I want to get started with the data analysis, so it would be great if you could help me with the following things: 1. Sergei, you said you did a bit of research into this. Do you have your *previous results*, or *any papers* that you have read that you could suggest to me? 2. Can I get *access to the buildbot database* to look at the data? If not, can I get the E/R model, or any scheme of *how the data looks like?* - I understand that maybe the data is not just a single database. I am starting by *reading the buildbot documentation*, to understand how the stuff is organized in it. 3. *Any other information* that you consider useful for me to know? Any advice? And that's all I have for now. I'm looking forward to getting started! Regards Pablo

4 5

[Maria-developers] mdev6027 RLIKE: "." no longer matching new line (default_regex_flags)
by Alexander Barkov 23 Apr '14

23 Apr '14

Hello Serg, Please review a patch implementing a new system variable default_regex_flags, to address the remaining incompatibilities between PCRE and the old regex library. Greetings.

3 5

[Maria-developers] Proposal Acceptance - GSOC
by Puneet Dewan 22 Apr '14

22 Apr '14

Hi Everyone, I, Puneet Dewan have got accepted into Google Summer Of Code 2014. This is the first and the last time I applied for GSOC and getting accepted is *really motivating*. :) My Project is : *Support of UseServerPrepStmts to MariaDB Java Connector.* *Massimo* is my mentor. I will start working on the project after 25th April as my semester exams are going on. I am excited to be part of MariaDB and looking forward to contribute to the community. Regards Puneet.

1 0

[Maria-developers] [GSOC] Proposal accepted!
by sriram patil 22 Apr '14

22 Apr '14

Hi Sergei, Alexander and all, Thank you for accepting my proposal. This was the first time I applied for GSoC, so I was kind of nervous. I was selected to work on the project *"CREATE OR REPLACE, CREATE IF NOT EXISTS and DROP IF EXISTS" *as part of GSoC'14. My end semester exams are going on right now. I will be done with my exams and projects by 29th April. I am totally excited to get started. I have built the source code already. Have learnt a few things about the source code as you must have observed in my proposal. I will continue with the documentation and source code from 1st May. Is there anything else you want me to look into? Thanks, Sriram

1 0

Re: [Maria-developers] [Commits] Rev 4153: MDEV-5963: InnoDB: Assertion failure in file row0sel.cc line 2503 ... in file:///home/psergey/dev2/10.0-cp/
by Jan Lindström 18 Apr '14

18 Apr '14

Sergey, > === modified file 'sql/opt_range.cc' > --- a/sql/opt_range.cc 2014-04-01 16:59:51 +0000 > +++ b/sql/opt_range.cc 2014-04-18 10:07:54 +0000 > @@ -2181,7 +2181,7 @@ int QUICK_ROR_INTERSECT_SELECT::init_ror > quick->record= head->record[0]; > } > > - if (need_to_fetch_row && head->file->ha_rnd_init_with_error(1)) > + if (need_to_fetch_row && head->file->ha_rnd_init_with_error(false)) You had so nice and informative reason why this has to be like this, why not add big fat comment here ? > { > DBUG_PRINT("error", ("ROR index_merge rnd_init call failed")); > DBUG_RETURN(1); > @@ -2363,8 +2363,13 @@ int QUICK_ROR_UNION_SELECT::reset() > quick->save_last_pos(); > queue_insert(&queue, (uchar*)quick); > } > - > - if ((error= head->file->ha_rnd_init(1))) > + /* Prepare for ha_rnd_pos calls. */ > + if (head->file->inited && (error= head->file->ha_rnd_end())) > + { > + DBUG_PRINT("error", ("ROR index_merge rnd_end call failed")); > + DBUG_RETURN(error); > + } > + if ((error= head->file->ha_rnd_init(false))) > { > DBUG_PRINT("error", ("ROR index_merge rnd_init call failed")); > DBUG_RETURN(error); > > _______________________________________________ > R: -- -- Jan Lindström, Principal Engineer SkySQL - The MariaDB Company MariaDB | MaxScale | skype: jan_p_lindstrom www.skysql.com <http://www.skysql.com/> Twitter <http://twitter.com/skysql> Blog <http://www.skysql.com/blog/> Facebook <http://www.facebook.com/skysql> LinkedIn <http://www.linkedin.com/company/1214250> Google+ <https://plus.google.com/117544963211695643458/posts>

1 0

[Maria-developers] TokuDB disabled in Debian and Ubuntu - help me get it working?
by Otto Kekäläinen 18 Apr '14

18 Apr '14

Hello Rick, Last year I spent a lot of time packaging MariaDB 5.5 for Debian and finally this year it has landed in Ubuntu 14.04 and Debian testing. Unfortunately the Debian/Ubuntu version does not include TokuDB and I need your help to get it there. In 5.5.35 (I think) the TokuDB plugn was added to MariaDB but I had issues getting it build 100% correctly and I eventually dropped it (added build parameter -DWITHOUT_TOKUDB=true), as getting MariaDB in Debian at all was a bigger priority than getting it there with every possible plugin. The root cause seems to be that when Debian and Ubuntu packages are built in chroot environments (the build systems of Debian and Ubuntu use pbuilder/sbuilder systems, see https://en.wikipedia.org/wiki/Debian_build_toolchain#Isolated_build_environ…) the code that builds the plugin does not seem to correctly detect the CPU features. It seems to read the values from the build machine and not the inputted target values (in a cross-compile situation). There are two related issues that needs a solution: 1) Currenlty the code that checks what the architecture is (32-bit/64-bit) is the first lines of https://bazaar.launchpad.net/~maria-captains/maria/10.0/view/head:/storage/…. This works well for real and virtual machhines, but it does not seem to work in the pbuilder/sbuilder chroots, as CMAKE_SYSTEM_PROCESSOR always shows the chroot host CPU, not the cross-compile target CPU. Could you please investigate pbuilder/sbuilder and search for some solution that works for reliable target CPU checking? 2) When building TokuDB in Ubuntu (amd64) sbuilder environments something in crashes in the 'toku_os_get_processor_frequency' function. For this too, could you investigate the sbuilde chroot environment and figure out what goes on and how to fix it? Issue 2 has a bug report with the (a bit messy) debugging history documented: https://mariadb.atlassian.net/browse/MDEV-5618 Both of these issues requires learning a bit about sbuilder CPU things, so I assume it is most efficient if the same persons looks into both of these. Thanks! -- Check out our blog at http://seravo.fi/blog and follow @ottokekalainen

3 5

[Maria-developers] Ubuntu 14.04 and MariaDB
by Otto Kekäläinen 17 Apr '14

17 Apr '14

Ubuntu 14.04 was released today. >From https://wiki.ubuntu.com/TrustyTahr/ReleaseNotes#Ubuntu_Server "MySQL Ubuntu 14.04 LTS continues to provide official support for MySQL 5.5. Three other community supported alternatives of MySQL are also included: * MariaDB 5.5 - a drop in replacement for MySQL 5.5. * Percona XtraDB Cluster 5.5 - a Galera based Active/Active MySQL solution. * MySQL 5.6 - the next release of Oracle's MySQL. Note that upgrading to MySQL 5.6 is an automatic one way process; it is possible to downgrade manually - see the upstream documentation on details of how to perform this process." I have been working on 5.5.37 today, I hope to soon get it uploaded into Debian and then via security update process into Ubuntu too. -- Check out our blog at http://seravo.fi/blog and follow @ottokekalainen

1 0

Re: [Maria-developers] [GSoC] Student interested in "Optimize mysql-test runs" or adding SQL features
by Sergei Golubchik 17 Apr '14

17 Apr '14

Hi, Pablo! First: please always cc: maria-developers(a)lists.launchpad.net, don't send emails to me only. Now: On Mar 11, Pablo Estrada wrote: > Hello! > I am getting ready to submit my proposal. Is there any feedback for my > application document? Anything that would be good to add, remove, rephrase, > etc? Go on and submit it. There will be a comment form under your proposal, if I will want you to change something, I will leave my comments there. Please mention what tools/languages you think you'll be using. > Also, if I could see the data available (the history of test results), I > could write more in detail : ) Hm. Okay. Attached is the preprocessed table that I used two years ago. It lists test failures in buildbot in a given period of time. Columns are (as far as I remember): * time of the test run start * code branch that was tested * revision id that was tested - it's fake, our buildbot tables don't store revision id. I've constructed it from the set of changed files, revision number, etc. hopefully it's as unique as a real revision id * build number * platform where the tests were run * test type - basically, the set of tests to run and what protocol to use. one test may be run with different protocols * test name * test variant - or combination. certain tests may be run in many combinations Using tis file I tried to rearrange test execution order for every specific build number (using failure data from previous builds in the same table) to detect test failures as early as possible. I managed to have 90% of all test failures happening within first 10% of the tests. The goal of this project is to have something we can put back into buildbot, so that it could actually run only 10% of the tests, still having 90% probability of discovering a failure (or 20%, or 95%, whaveter). See also http://buildbot.askmonty.org/buildbot/ you can click on a link for any branch, for example, http://buildbot.askmonty.org/buildbot/grid?branch=10.0 then on any particular build, for example, http://buildbot.askmonty.org/buildbot/builders/kvm-fulltest/builds/2297 and on a stdio log for a particular test run: http://buildbot.askmonty.org/buildbot/builders/kvm-fulltest/builds/2297/ste… on these pages you'll see what a platform (builder) is, build number, test types, combinations, etc. Regards, Sergei

2 2