[mythtv-users] MySQL related BE deadlocks - collective wisdom needed

warpme warpme at o2.pl
Wed Jul 27 09:48:22 UTC 2011


Well,
Having 30min Yesterday evening I recompile BE with above 2 lines commented in mythdbconn.cpp.
Unfortunately today I had deadlock again. This time it was in scheduler. Trace is again well known:

Thread 20 (Thread 0xaab0bb70 (LWP 31981)):
#0  0xb7839424 in __kernel_vsyscall ()
#1  0xb67d781b in read () from /lib/libpthread.so.0
#2  0xb1be1ba8 in vio_read () from /usr/lib/libmysqlclient_r.so.16
#3  0xb1be1c0b in vio_read_buff () from /usr/lib/libmysqlclient_r.so.16
#4  0xb1be2bb0 in ?? () from /usr/lib/libmysqlclient_r.so.16
#5  0xb1be371b in my_net_read () from /usr/lib/libmysqlclient_r.so.16
#6  0xb1bdc124 in cli_safe_read () from /usr/lib/libmysqlclient_r.so.16
#7  0xb1baf8e9 in cli_read_prepare_result () from /usr/lib/libmysqlclient_r.so.16
#8  0xb1bafc7a in mysql_stmt_prepare () from /usr/lib/libmysqlclient_r.so.16
#9  0xb1d7bf78 in ?? () from /usr/lib/qt/plugins/sqldrivers/libqsqlmysql.so
#10 0xb65256aa in QSqlResult::savePrepare(QString const&) () from /usr/lib/libQtSql.so.4
#11 0xb65175e2 in QSqlQuery::prepare(QString const&) () from /usr/lib/libQtSql.so.4
#12 0xb6cf9b70 in MSqlQuery::prepare (this=0xaab0aa48, query=...) at mythdbcon.cpp:757
#13 0xb6a45c06 in ProgramInfo::QueryMplexID (this=0x98552a10) at programinfo.cpp:2241
#14 0x080d9c81 in Scheduler::FindNextConflict (this=0x9e92fe0, cardlist=..., p=0x98552a10, j=..., openEnd=0)
    at scheduler.cpp:973
#15 0x080da22b in Scheduler::FindConflict (this=0x9e92fe0, reclists=..., p=0x98552a10, openend=0) at scheduler.cpp:1005
#16 0x080dabdb in Scheduler::TryAnotherShowing (this=0x9e92fe0, p=0x985532e0, samePriority=false, preserveLive=false)
    at scheduler.cpp:1162
#17 0x080dc0ad in Scheduler::MoveHigherRecords (this=0x9e92fe0, move_this=true) at scheduler.cpp:1331
#18 0x080dba8b in Scheduler::SchedNewRecords (this=0x9e92fe0) at scheduler.cpp:1279
#19 0x080d48b2 in Scheduler::FillRecordList (this=0x9e92fe0) at scheduler.cpp:372
#20 0x080e028b in Scheduler::HandleReschedule (this=0x9e92fe0) at scheduler.cpp:2046
#21 0x080df269 in Scheduler::run (this=0x9e92fe0) at scheduler.cpp:1826
#22 0xb56e5843 in ?? () from /usr/lib/libQtCore.so.4
#23 0xb67d0c77 in start_thread () from /lib/libpthread.so.0
#24 0xb54b8c6e in clone () from /lib/libc.so.6

Damn - I'm out of ideas....
 


More information about the mythtv-users mailing list