Resource deadlock avoided with PBXT and Maria 5.1.42

Bug #566394 reported by m00dawg
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
PBXT
Fix Committed
Undecided
Paul McCullagh

Bug Description

Importing the attached schema and attempting to restart MySQL yields the following:

Apr 19 03:38:37 mcp mysqld: 100419 03:38:37 [Error] DB-RECOVERY-mysql pthread_rwlock_t* xt_xlock_rwlock(thread_xt.cc:1644) errno (35): Resource deadlock avoided
Apr 19 03:38:37 mcp mysqld: 100419 03:38:37 [Error] DB-RECOVERY-mysql pthread_rwlock_t* xt_xlock_rwlock(thread_xt.cc:1644)

This was tested on Maria 5.1.42 and 5.1.44 with the same affect. I have not isolated which tables it is that is causing this (the entire attached schema contains all PBXT tables).

MySQL continues to run but never actually starts up (it refuses connections). In order to fix it I have to kill -9 mysqld_safe and mysqld. Running strace produces:

root@mcp:~# strace -f -p 12053
Process 12074 attached with 17 threads - interrupt to quit
[pid 12053] restart_syscall(<... resuming interrupted call ...> <unfinished ...>
[pid 12058] restart_syscall(<... resuming interrupted call ...> <unfinished ...>
[pid 12061] futex(0x7fba6227586c, FUTEX_WAIT_PRIVATE, 7, NULL <unfinished ...>
[pid 12057] restart_syscall(<... resuming interrupted call ...> <unfinished ...>
[pid 12060] futex(0x7fba622757ec, FUTEX_WAIT_PRIVATE, 1, NULL <unfinished ...>
[pid 12062] futex(0x7fba622758ec, FUTEX_WAIT_PRIVATE, 1, NULL <unfinished ...>
[pid 12063] futex(0x7fba6227596c, FUTEX_WAIT_PRIVATE, 1, NULL <unfinished ...>
[pid 12064] futex(0x7fba622759ec, FUTEX_WAIT_PRIVATE, 1, NULL <unfinished ...>
[pid 12065] futex(0x7fba62275a6c, FUTEX_WAIT_PRIVATE, 1, NULL <unfinished ...>
[pid 12066] futex(0x7fba62275aec, FUTEX_WAIT_PRIVATE, 3, NULL <unfinished ...>
[pid 12067] futex(0x7fba62275b6c, FUTEX_WAIT_PRIVATE, 3, NULL <unfinished ...>
[pid 12068] futex(0x7fba62275bec, FUTEX_WAIT_PRIVATE, 3, NULL <unfinished ...>
[pid 12069] futex(0x7fba62275c6c, FUTEX_WAIT_PRIVATE, 3, NULL <unfinished ...>
[pid 12071] select(0, NULL, NULL, NULL, {0, 460000} <unfinished ...>
[pid 12072] select(0, NULL, NULL, NULL, {0, 460000} <unfinished ...>
[pid 12073] futex(0x7fba61bea9bc, FUTEX_WAIT_PRIVATE, 3, NULL <unfinished ...>
[pid 12074] select(0, NULL, NULL, NULL, {8, 476000} <unfinished ...>
[pid 12053] <... restart_syscall resumed> ) = 0
[pid 12053] nanosleep({0, 100000000}, NULL) = 0
[pid 12053] nanosleep({0, 100000000}, NULL) = 0
[pid 12053] nanosleep({0, 100000000}, NULL) = 0
[pid 12053] nanosleep({0, 100000000}, <unfinished ...>
[pid 12072] <... select resumed> ) = 0 (Timeout)
[pid 12072] time(NULL) = 1271648579
[pid 12071] <... select resumed> ) = 0 (Timeout)
[pid 12071] time( <unfinished ...>
[pid 12072] select(0, NULL, NULL, NULL, {1, 0} <unfinished ...>
[pid 12071] <... time resumed> NULL) = 1271648579
[pid 12071] select(0, NULL, NULL, NULL, {1, 0} <unfinished ...>
[pid 12058] <... restart_syscall resumed> ) = -1 ETIMEDOUT (Connection timed out)
[pid 12058] time(NULL) = 1271648579
[pid 12058] futex(0x7fba61b65490, FUTEX_WAKE_PRIVATE, 1) = 0
[pid 12058] time(NULL) = 1271648579
[pid 12058] gettimeofday({1271648579, 70059}, NULL) = 0
[pid 12058] clock_gettime(CLOCK_REALTIME, {1271648579, 70059437}) = 0
[pid 12058] futex(0x7fba61b654bc, FUTEX_WAIT_PRIVATE, 1049, {0, 499999563} <unfinished ...>
[pid 12053] <... nanosleep resumed> NULL) = 0
[pid 12053] nanosleep({0, 100000000}, NULL) = 0
[pid 12053] nanosleep({0, 100000000}, <unfinished ...>

Tags: mariadb pbxt
Revision history for this message
m00dawg (tim-moocowproductions) wrote :
description: updated
Revision history for this message
Paul McCullagh (paul-mccullagh) wrote :

Hi Tim,

Thanks for the bug report. I will see if I can reproduce it.

Changed in pbxt:
assignee: nobody → Paul McCullagh (paul-mccullagh)
Changed in pbxt:
status: New → Confirmed
Revision history for this message
Paul McCullagh (paul-mccullagh) wrote :

This bug has been fixed in PBXT 1.0.11. The new version will be included in MariaDB 5.1.46.

Changed in pbxt:
status: Confirmed → Fix Committed
Revision history for this message
m00dawg (tim-moocowproductions) wrote :

Thanks for fixing this Paul! I upgraded to Maria 5.1.47 and am no longer running into this issue.

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.