Re: [Maria-developers] xa transaction cause replication broken

2013-05-01 Thread Sergei Golubchik
Hi, jhx1008! On May 02, Sergei Golubchik wrote: > Hi, jhx1008! > > This also looks very much like a bug to me. > Could you please report it at mariadb.org/jira ? Thanks! Just for the reference - in case anyone on the list is following, it's https://mariadb.atlassian.net/browse/MDEV-4470 > On M

Re: [Maria-developers] xa transaction cause replication broken

2013-05-01 Thread Sergei Golubchik
Hi, jhx1008! This also looks very much like a bug to me. Could you please report it at mariadb.org/jira ? On May 02, jhx1008 wrote: > hello > I have another problem witch seems like a bug(Server version: > 5.5.5-10.0.2-MariaDB-log MariaDB Server). > the problem is about the replication for the x

Re: [Maria-developers] is this a bug?

2013-05-01 Thread Alexander Barkov
Hi, On 05/02/2013 06:42 AM, jhx1008 wrote: Thanks for all the replies, to fix it maybe need a new syntax, does mariadb has any plan to fix it? 2013-05-02 We'll fix INSERTs (like the one in your example) to work fine by the next release, and also think about more tricky cases. -

Re: [Maria-developers] Documentation about GTID

2013-05-01 Thread Kristian Nielsen
Giuseppe Maxia writes: > I was using: > > CHANGE MASTER TO master_gtid_pos=1; > ERROR 1064 (42000): You have an error in your SQL syntax; check the manual > that corresponds to your MariaDB server version for the right syntax to use > near 'master_gtid_pos=1' at line 1 Ok, thanks. > I will ha

[Maria-developers] xa transaction cause replication broken

2013-05-01 Thread jhx1008
hello I have another problem witch seems like a bug(Server version: 5.5.5-10.0.2-MariaDB-log MariaDB Server). the problem is about the replication for the xa transactions when the master crashed and then restarted. I know when we do a transaction, the queries will be stored in the binlog cache,

Re: [Maria-developers] is this a bug?

2013-05-01 Thread jhx1008
Thanks for all the replies, to fix it maybe need a new syntax, does mariadb has any plan to fix it? 2013-05-02 jhx1008 @netease 发件人:Alexander Barkov 发送时间:2013-04-30 13:37 主题:Re: [Maria-developers] is this a bug? 收件人:"Jeremy Cole" 抄送:"jhx1008","maria-developers" Hello, This is definitel

Re: [Maria-developers] Documentation about GTID

2013-05-01 Thread Giuseppe Maxia
Kristian, Thanks for your answer. The reason for the error I mentioned before is that I used a different syntax which I found in one of the WL. instead of CHANGE MASTER TO MASTER_USE_GTID=1; I was using: CHANGE MASTER TO master_gtid_pos=1; ERROR 1064 (42000): You have an error in your SQL syn

Re: [Maria-developers] Documentation about GTID

2013-05-01 Thread Kristian Nielsen
Giuseppe Maxia writes: > The only documentation I found is the worklog. Yes, docs will come of course, but they are not written yet. As Pavel mentioned, there are some changes compared to original design, that were done as a result of QA to fix some potential issues with the user experience. >

Re: [Maria-developers] Documentation about GTID

2013-05-01 Thread Giuseppe Maxia
Hi, Thanks for the quick answer. However, neither of the suggested syntax works with the build currently released. Moreover, since the commit comment mentions multiple masters, it would be nice to have some documentation that explains what to expect when using GTID and multiple masters. Cheer

Re: [Maria-developers] Documentation about GTID

2013-05-01 Thread Pavel Ivanov
This was changed on the way (http://bazaar.launchpad.net/~maria-captains/maria/10.0-mdev26/revision/3554). Instead of "CHANGE MASTER TO master_gtid_pos=auto" you need to use "CHANGE MASTER TO master_use_gtid=1". If you want to actually set gtid_pos you need to set @@global.gtid_pos. Pavel On Wed,

[Maria-developers] Documentation about GTID

2013-05-01 Thread Giuseppe Maxia
Hi! I am testing MariaDB 10.0.2, and I am interested in GTID. The only documentation I found is the worklog. Without docs at hand, I tried something: slave1 [localhost] {msandbox} ((none)) > CHANGE MASTER TO master_gtid_pos=''; ERROR 1064 (42000): You have an error in your SQL syntax; check the

Re: [Maria-developers] GTIDs, events sequence and alternate futures

2013-05-01 Thread Pavel Ivanov
Thank you Kristian. On Wed, May 1, 2013 at 8:19 AM, Kristian Nielsen wrote: > Pavel Ivanov writes: > >> What will happen with MariaDB if sem-sync master is enabled, some >> transactions is completed, but before it gets any semi-sync acks all >> slaves get disconnected? Will this transaction be r

Re: [Maria-developers] GTIDs, events sequence and alternate futures

2013-05-01 Thread Kristian Nielsen
Pavel Ivanov writes: > What will happen with MariaDB if sem-sync master is enabled, some > transactions is completed, but before it gets any semi-sync acks all > slaves get disconnected? Will this transaction be rolled back? Or it > will be left committed basically creating an alternate future?

Re: [Maria-developers] is this a bug?

2013-05-01 Thread Sergei Golubchik
Hi, Alexander! Could you report this bug and fix it, please? On Apr 30, Alexander Barkov wrote: > Hello, > > This is definitely a bug. > > 0x is a MySQL extension, and it's a hybrid thing. > It can behave as a number and a string depending on context. > > Binary log could use the X'' n

Re: [Maria-developers] GTIDs, events sequence and alternate futures

2013-05-01 Thread Pavel Ivanov
Thank you. I need this info to make sure that our tools work properly. They need to determine which slave is further in the replication stream than others (which apparently can be achieved by simple comparison of sequence number) and detect if slaves have alternate futures. The latter can happen no

Re: [Maria-developers] GTIDs, events sequence and alternate futures

2013-05-01 Thread Kristian Nielsen
Pavel Ivanov writes: > As I understand GTID is constructed as - id>-. Is it guaranteed that sequence numbers are > always increasing inside the domain id? So The intention is that the user/DBA should configure things so that there is only ever one active master for each domain_id. If this is don