[mythtv-users] mythbackend 0.25 on gentoo: crashes with mythfilldatabase?
Stefan G. Weichinger
lists at xunil.at
Thu Nov 22 13:10:16 UTC 2012
I run media-tv/mythtv-0.25.2_p20120825 on a 64 bit gentoo host.
It's a backend only, one PCIe DVB-S card with 2 tuners ...
Every night I run some xmltv-job to pull in program data with
tv_grab_eu_epgdata.
The user mythtv pulls in that stuff, an hour later root runs
mythfilldatabase to push up that data into the mythtv-mysql-DB.
It seems that this crashes mythbackend ... so I now run those commands
manually to see what happens.
I get right now (example, I don't listen to "Schlager" ;-) ):
2012-11-22 14:07:05.668667 E DB Error (Marking first showings):
Query was:
UPDATE program set first = 1 WHERE starttime = ? AND title = ? AND
subtitle = ? AND LEFT(description, 1024) = ?
Bindings were:
:PARTDESC="20.00 / 21.00 / 22.00 / 23.00 Nachrichten, Wetter",
:STARTTIME=2012-11-12T19:05:00, :SUBTITLE="",
:TITLE="Bayern plus - Die schönsten Schlager und Melodien"
Driver error was [2/1213]:
QMYSQL3: Unable to execute statement
Database error was:
Deadlock found when trying to get lock; try restarting transaction
-
Might such an issue crash the backend at night?
that "WHERE starttime = ? AND title = ?" ... I understand that this
can't work. Maybe a broken xml-file coming from xmltv?
I'd be happy to get some hints how to proceed on this.
Thanks, Stefan
More information about the mythtv-users
mailing list