<br><br><div class="gmail_quote">On Mon, Dec 3, 2012 at 8:57 AM, Michael T. Dean <span dir="ltr"><<a href="mailto:mtdean@thirdcontact.com" target="_blank">mtdean@thirdcontact.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div class="HOEnZb"><div class="h5">On 11/22/2012 08:10 AM, Stefan G. Weichinger wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
I run media-tv/mythtv-0.25.2_<u></u>p20120825 on a 64 bit gentoo host.<br>
It's a backend only, one PCIe DVB-S card with 2 tuners ...<br>
<br>
Every night I run some xmltv-job to pull in program data with<br>
tv_grab_eu_epgdata.<br>
<br>
The user mythtv pulls in that stuff, an hour later root runs<br>
mythfilldatabase to push up that data into the mythtv-mysql-DB.<br>
<br>
It seems that this crashes mythbackend ... so I now run those commands<br>
manually to see what happens.<br>
<br>
I get right now (example, I don't listen to "Schlager" ;-) ):<br>
<br>
2012-11-22 14:07:05.668667 E DB Error (Marking first showings):<br>
Query was:<br>
UPDATE program set first = 1 WHERE starttime = ? AND title = ? AND<br>
subtitle = ? AND LEFT(description, 1024) = ?<br>
Bindings were:<br>
:PARTDESC="20.00 / 21.00 / 22.00 / 23.00 Nachrichten, Wetter",<br>
:STARTTIME=2012-11-12T19:05:<u></u>00, :SUBTITLE="",<br>
:TITLE="Bayern plus - Die schönsten Schlager und Melodien"<br>
Driver error was [2/1213]:<br>
QMYSQL3: Unable to execute statement<br>
Database error was:<br>
Deadlock found when trying to get lock; try restarting transaction<br>
<br>
<br>
-<br>
<br>
Might such an issue crash the backend at night?<br>
<br>
that "WHERE starttime = ? AND title = ?" ... I understand that this<br>
can't work. Maybe a broken xml-file coming from xmltv?<br>
</blockquote>
<br></div></div>
That's actually fine--it's just the way we log things.<div class="im"><br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
I'd be happy to get some hints how to proceed on this.<br>
<br>
</blockquote>
<br></div>
The problem is almost definitely that you're running MySQL with some unsupported (meaning untested) configuration and it's causing the problems.<br>
<br>
My best guess is that you're using InnoDB storage engine (which isn't supported) and that, coupled with the specific data you're getting from mythfilldatabase (and, potentially, some other factors), results in the deadlock.<br>
<br>
If you use MythTV 0.26 to create a brand new database, it should create tables using the proper MySQL storage engine, regardless of your MySQL configuration. Doing this will cause you to lose all of your configuration and previous history. You could use a partial restore to restore your old recording information (the only non-recreatable information), but note that you must use a same-versioned database backup (i.e. you'll need to upgrade to 0.26, first, then back up your database, then create the new database and do a partial restore): <a href="http://www.mythtv.org/wiki/Database_Backup_and_Restore#Partial_restore_of_a_backup" target="_blank">http://www.mythtv.org/wiki/<u></u>Database_Backup_and_Restore#<u></u>Partial_restore_of_a_backup</a><br>
<br>
Mike<div class="HOEnZb"><div class="h5"><br>
______________________________<u></u>_________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.org</a><br>
<a href="http://www.mythtv.org/mailman/listinfo/mythtv-users" target="_blank">http://www.mythtv.org/mailman/<u></u>listinfo/mythtv-users</a><br></div></div></blockquote><div><br>Mike:<br><br>FYI - The default table type for mysql 5.5 and on is innodb. I am guessing this is a non-issue for MythTV as it probably specifies the table type to myisam, but it is the direction they are going.<br>
<br>Dan <br></div></div><br>