Re: [Maria-developers] Galera-10.0 still does not work with rollbacks

2013-09-27 Thread seppo . jaakola
Quoting Jan Lindström jplin...@mariadb.org: Seppo, Hi, What means: 30925 15:10:36 [ERROR] Slave SQL: Could not execute Update_rows event on table test.table10_key_pk_parts_2_int_autoinc; Can't find record in 'table10_key_pk_parts_2_int_autoinc', Error_code: 1032; handler error

[Maria-developers] MySQL bug affects mariaDB

2013-09-27 Thread Peter Laursen
I think the 'mysql' client with MariaDB has a similar problem as it has with MySQL - refer? http://bugs.mysql.com/bug.php?id=70443 MariaDB installer installs my.ini to /datadir - what with MariaDB is a subfolder to /basedir. The server will look for it correctly as the registry key defining the

Re: [Maria-developers] Galera-10.0 still does not work with rollbacks

2013-09-27 Thread seppo . jaakola
Quoting Kristian Nielsen kniel...@knielsen-hq.org: Jan Lindström jplin...@mariadb.org writes: The point I do not understant is at ha_savepoint we have again: if ((err= ht-savepoint_set(ht, thd, (uchar *)(sv+1)+ht-savepoint_offset))) (gdb) p *sv $3 = {prev = 0xa5a5a5a5a5a5a5a5, name =

Re: [Maria-developers] Galera-10.0 still does not work with rollbacks

2013-09-27 Thread Kristian Nielsen
seppo.jaak...@codership.com writes: Did I understand it right that the problem is with ROLLBACK TO SAVEPOINT..., where the designated savepoint does not exist? Did you No. It is a very simple issue. The beginning of binlog_savepoint_set() reads: #ifdef WITH_WSREP if

[Maria-developers] [GSoC] Request for code review

2013-09-27 Thread QIU Shuang
Hi Sergei, This is Shuang, a participant for GSoC 2013 Kerberize MariaDB project. I want to ask the community to review the code before requesting for pull and send the MCA. How could I send the codes? In a diff file? or from other approaches? Thank you very much and best regards! Sincerely,

Re: [Maria-developers] [GSoC] Request for code review

2013-09-27 Thread Sergei Golubchik
Hi, QIU! On Sep 27, QIU Shuang wrote: This is Shuang, a participant for GSoC 2013 Kerberize MariaDB project. I want to ask the community to review the code before requesting for pull and send the MCA. How could I send the codes? In a diff file? or from other approaches? Do you have a tree on

Re: [Maria-developers] Questions re MDEV-4736 and MDEV-4739 (was Re: Spider's installation sql file)

2013-09-27 Thread Sergey Vojtovich
Hi Kentoku, On Wed, Sep 25, 2013 at 02:53:17AM +0900, kentoku wrote: Hi Sergey, The above should have been fixed back in the beginning of 2012. Which MariaDB revision are you testing with? It's same as lp:~kentokushiba/maria/10.0.4-spider-3.0. That's very strange. How did you build it and

Re: [Maria-developers] Galera-10.0 still does not work with rollbacks

2013-09-27 Thread Jan Lindström
Hi, I think I solved this issue by #ifdef WITH_WSREP if (!wsrep_emulate_bin_log) binlog_trans_log_truncate(thd, *(my_off_t*)sv); #endif This avoids using the uninitialized memory in Galera, this was error in merge.

Re: [Maria-developers] [GSoC] Request for code review

2013-09-27 Thread QIU Shuang
Hi Sergei, Do you have a tree on launchpad with your code? Yes, I have. Here is the URL to my branch: https://code.launchpad.net/~qiush-summer/maria/krb_auth_plugin. Then the easiest way would be to propose a merge of your tree into mariadb. See https://help.launchpad.net/Code/Review I've

Re: [Maria-developers] Questions re MDEV-4736 and MDEV-4739 (was Re: Spider's installation sql file)

2013-09-27 Thread kentoku
Hi Sergey, The above should have been fixed back in the beginning of 2012. Which MariaDB revision are you testing with? It's same as lp:~kentokushiba/maria/10.0.4-spider-3.0. That's very strange. How did you build it and what command line options did you use (including those that are

[Maria-developers] [GSoC] MariaDB Contributor Agreement for Kerberos Authentication Plugin

2013-09-27 Thread QIU Shuang
Hi community, I declare that all the work done so far (and future) on the project Kerberize MariaDB is licenced by the new BSD Lisence. Please contact me if any problems with the license. Thank you all and best regards! Sincerely, Shuang___ Mailing

Re: [Maria-developers] Questions re MDEV-4736 and MDEV-4739 (was Re: Spider's installation sql file)

2013-09-27 Thread Sergey Vojtovich
Hi Kentoku, BUILD/compile-amd64-debug-max cd mysql-test cat t/AAA.test --source include/have_innodb.inc install soname 'ha_spider.so'; --connection default eval CREATE TABLE t1 (a INT) ENGINE=InnoDB; --connect (con1,localhost,root,,) XA START 'xa1'; INSERT INTO t1 (a) VALUES (1),(2); XA END

[Maria-developers] EXPLAIN INSERT in MySQL - not useful after all?

2013-09-27 Thread Sergei Petrunia
Hi, Among the topics of yesterday's optimizer call was the question of what is the point of EXPLAIN INSERT. The point was that INSERT doesn't need a query plan. Somebody has mentioned that perhaps, EXPLAIN INSERT could show results of partition pruning. This doesn't seem to be the case:

Re: [Maria-developers] EXPLAIN INSERT in MySQL - not useful after all?

2013-09-27 Thread Jean Weisbuch
Could it be of use for the INSERT ... SELECT ... queries? Sergei Petrunia pser...@askmonty.org wrote: Hi, Among the topics of yesterday's optimizer call was the question of what is the point of EXPLAIN INSERT. The point was that INSERT doesn't need a query plan. Somebody has mentioned that

Re: [Maria-developers] EXPLAIN INSERT in MySQL - not useful after all?

2013-09-27 Thread Giuseppe Maxia
It looks like a bug.The partition pruning kicks just fine for UPDATEsshow create table t2p\G*** 1. row *** Table: t2pCreate Table: CREATE TABLE `t2p` ( `a` int(11) DEFAULT NULL, `b` int(11) DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=latin1/*!50100

Re: [Maria-developers] EXPLAIN INSERT in MySQL - not useful after all?

2013-09-27 Thread Sergei Petrunia
I agree that for INSERT .. SELECT, EXPLAIN is useful - it shows query plan of the SELECT part. I was wondering specifically about the INSERT ... VALUES (...) syntax. I was just checking EXPLAIN in Maria vs EXPLAIN in MySQL, and could not find what is the rationale for EXPLAIN INSERT ... VALUES.

Re: [Maria-developers] MySQL bug affects mariaDB

2013-09-27 Thread Vladislav Vaintroub
The command line clients are not services, and they are not started with --defaults-file, this is correct. But 1.We install shortcut to mysql client and shortcut does have --defaults-file , and the default-file points to the right place, i.e whenever you installed the mysql server

Re: [Maria-developers] MySQL bug affects mariaDB

2013-09-27 Thread Peter Laursen
Thanks wlad for explanation, but this applies to 'shortcuts' (in start menu) only I think, as I understand your reply. If I navigate ('cd ..') to the /datadir where my.ini resides and launch 'mysql' from commnd line I will need to specify --defaults-file on the command line, right? If not the

Re: [Maria-developers] [Maria-discuss] MySQL bug affects mariaDB

2013-09-27 Thread Vladislav Vaintroub
Justin, I appreciate your opinion, and if MySQL on Windows would not support multiple versions running on the same machine, I would agree. But since we (and/or generations of programmers before me) chose to support multiple version of MySQL coexisting on the same machine, and I did not want to

Re: [Maria-developers] MySQL bug affects mariaDB

2013-09-27 Thread Vladislav Vaintroub
Current directory does not play any role in choosing defaults file. You indeed need either to specify –defauilts-file, or set MYSQL_HOME, or the bdefault logic of finding my.ini will apply On the other hand, I rarely find myself in need to use my.ini for clients. In doubt, I provide –port ,

Re: [Maria-developers] [Maria-discuss] MySQL bug affects mariaDB

2013-09-27 Thread Peter Laursen
On Windows multiple MySQL servers run (if only they have distinct basedir, datadir, port (and/or pipe) and service name). This is how Windows manages servides (daemons) simply! And BTW: this is the reason why Windows is a comfortable platform for application testing if you want to test an

Re: [Maria-developers] MySQL bug affects mariaDB

2013-09-27 Thread Peter Laursen
I rarely find myself in need to use my.ini for clients. Not me either except for max_allowed_packet (what is implemented in both server and client) that user want to set to INSERT table rows with photographs (.jpg's typically) to a table. And the 'mysql' command line client has a default