[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