Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

multiple storage engines supporting XA

1 view
Skip to first unread message

Zardosht Kasheff

unread,
Apr 9, 2012, 11:32:59 AM4/9/12
to
Hello all,

I am trying to add XA for our storage engine in 5.1.61, and am running
into http://bugs.mysql.com/bug.php?id=47134.

Does anyone have experience with adding a storage engine (in addition
to InnoDB) that supports XA to MySQL? Does 5.5 have this problem?
MariaDB?

Does MySQL work when multiple engines support XA? Commenters in the
bug report expressed doubts.

Thanks
-Zardosht

--
MySQL Internals Mailing List
For list archives: http://lists.mysql.com/internals
To unsubscribe: http://lists.mysql.com/internals

Sergei Golubchik

unread,
Apr 9, 2012, 12:01:11 PM4/9/12
to
Hi, Zardosht!

On Apr 09, Zardosht Kasheff wrote:
> I am trying to add XA for our storage engine in 5.1.61, and am running
> into http://bugs.mysql.com/bug.php?id=47134.
>
> Does anyone have experience with adding a storage engine (in addition
> to InnoDB) that supports XA to MySQL? Does 5.5 have this problem?
> MariaDB?

No. It was fixed in MariaDB 5.1 almost two years ago.

Regards,
Sergei

Stewart Smith

unread,
Apr 9, 2012, 12:03:54 PM4/9/12
to
On Mon, 9 Apr 2012 11:32:59 -0400, Zardosht Kasheff <zard...@gmail.com> wrote:
> Hello all,
>
> I am trying to add XA for our storage engine in 5.1.61, and am running
> into http://bugs.mysql.com/bug.php?id=47134.
>
> Does anyone have experience with adding a storage engine (in addition
> to InnoDB) that supports XA to MySQL? Does 5.5 have this problem?
> MariaDB?
>
> Does MySQL work when multiple engines support XA? Commenters in the
> bug report expressed doubts.

It looks like Sergei has fixed it in MariaDB a long time ago, but I
don't see it fixed in MySQL (the Falcon team also hit this many years
ago too).

I don't predict that anyone at Oracle will look at these bugs anytime
soon.

Honestly, in this case, go use MariaDB if you don't want to have to
patch the server.

--
Stewart Smith

Zardosht Kasheff

unread,
Apr 9, 2012, 1:12:09 PM4/9/12
to
Hello Sergei,

Is there a patch available for this? Also, was this the only issue to
fix in order to get MariaDB working with multiple XA supporting
storage engines?

Thanks
-Zardosht

On Mon, Apr 9, 2012 at 12:01 PM, Sergei Golubchik <se...@askmonty.org> wrote:
> Hi, Zardosht!
>
> On Apr 09, Zardosht Kasheff wrote:
>> I am trying to add XA for our storage engine in 5.1.61, and am running
>> into http://bugs.mysql.com/bug.php?id=47134.
>>
>> Does anyone have experience with adding a storage engine (in addition
>> to InnoDB) that supports XA to MySQL? Does 5.5 have this problem?
>> MariaDB?
>
> No. It was fixed in MariaDB 5.1 almost two years ago.
>
> Regards,
> Sergei

Sergei Golubchik

unread,
Apr 9, 2012, 3:16:19 PM4/9/12
to
Hi, Zardosht!

On Apr 09, Zardosht Kasheff wrote:
> Hello Sergei,
>
> Is there a patch available for this? Also, was this the only issue to
> fix in order to get MariaDB working with multiple XA supporting
> storage engines?

No, I just fixed it in MariaDB. But, of course, you can extract the
patch with bzr.

There were two issues. After I fixed the first one - a crash - a second
one started showing up. Incorrect mutex locking order (that can cause
deadlocks). It was found by MariaDB built-in mutex deadlock detector,
in MySQL it would've slipped in unnoticed.
This bug is fixed too, of course.

https://bugs.launchpad.net/maria/+bug/544173
https://bugs.launchpad.net/maria/+bug/578117
0 new messages