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

Hi, Zardosht!

On Apr 09, Zardosht Kasheff wrote:
No. It was fixed in MariaDB 5.1 almost two years ago.

Regards,
Sergei

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

On Mon, 9 Apr 2012 11:32:59 -0400, Zardosht Kasheff <zardosht (AT) gmail (DOT) com> wrote:
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

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

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 <serg (AT) askmonty (DOT) org> wrote:
--
MySQL Internals Mailing List
For list archives: http://lists.mysql.com/internals
To unsubscribe: http://lists.mysql.com/internals

Hi, Zardosht!

On Apr 09, Zardosht Kasheff wrote:
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

Sergei

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