INFORMATION_SCHEMA.INNODB_LOCKS bug (and fix)
Kristian Nielsen
https://bugs.launchpad.net/maria/+bug/677407
The bug causes test failures in our Buildbot, so it is important for us to
include it in MariaDB. However, I wanted to coordinate with Percona-Server
developers before merging it in case you want to include it in Percona-Server
(I put BSD in the patch); also if you could take a look at the patch and point
out any problems, that would be much appreciated.
The bug is that there is a race condition in the code that is supposed to
restrict updates to the INNODB_LOCKS table to every 100 milliseconds (as
updating the table causes contention on the kernel_mutex). This makes it
possible for the table to not be updated for much longer than 100
milliseconds; if the table is queried sufficiently frequently, it will keep
returning the same old data. It is also possible for the table to be updated
too frequently if accessed simultaneously by many connections in parallel.
- Kristian.
Vadim Tkachenko
Thanks!
Bug assigned to Alexey and we will merge fix soon.
> --
> You received this message because you are subscribed to the Google Groups "Percona Dev" group.
> To post to this group, send email to perco...@googlegroups.com.
> To unsubscribe from this group, send email to percona-dev...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/percona-dev?hl=en.
>
>
>
--
Vadim Tkachenko, CTO, Percona Inc.
Phone +1-888-401-3403, Skype: vadimtk153
Schedule meeting: http://tungle.me/VadimTkachenko