2012-11-17, 18:55
Good morning,
I have a tested MythTV 0.26 frontend/backend setup on my Linux boxes.
Record/playback is good. EPG operates fine on frontend. All is well.
Been working to integrate OpenELEC into this network over the past week.
I can see channel lists and logos from backend. Live/recorded playback works.
I cannot get the EPG on OpenELEC to turn up, despite trying multiple nightlies and settings.
All I get is blank display boxes where I think EPG information would be displayed.
My RPi platform has been otherwise stable for weeks. These errors are reproducible.
I have EPG working reliably on my Linux frontend, and through the MythWeb interface.
I have never been able to get EPG up on the RPi platform.
Currently running OpenELEC devel-20121117112034-r12493 w/ mythc 0.5.0 plugin.
Is this functionality broken for everyone?
I think the plugin is choking on the backend database, but not sure how to proceed.
When I run Settings->LiveTV->EPG->Reset EPG Database
I get the following logs, which appear to point to my problem:
I have uploaded a complete log trace here:
https://docs.google.com/open?id=0B-ImKPf...TlxOGhrMFE
Can someone point me in the right direction? Thanks in advance - I’m stumped.
I have a tested MythTV 0.26 frontend/backend setup on my Linux boxes.
Record/playback is good. EPG operates fine on frontend. All is well.
Been working to integrate OpenELEC into this network over the past week.
I can see channel lists and logos from backend. Live/recorded playback works.
I cannot get the EPG on OpenELEC to turn up, despite trying multiple nightlies and settings.
All I get is blank display boxes where I think EPG information would be displayed.
My RPi platform has been otherwise stable for weeks. These errors are reproducible.
I have EPG working reliably on my Linux frontend, and through the MythWeb interface.
I have never been able to get EPG up on the RPi platform.
Currently running OpenELEC devel-20121117112034-r12493 w/ mythc 0.5.0 plugin.
Is this functionality broken for everyone?
I think the plugin is choking on the backend database, but not sure how to proceed.
When I run Settings->LiveTV->EPG->Reset EPG Database
I get the following logs, which appear to point to my problem:
Quote:10:30:32 T:2847929440 ERROR: AddOnLog: MythTV cmyth PVR Client: LibCMyth: (cmyth)cmyth_mysql_query_result: mysql_query(SELECT program.chanid, UNIX_TIMESTAMP(CONVERT_TZ(program.starttime, 'UTC', 'SYSTEM')), UNIX_TIMESTAMP(CONVERT_TZ(program.endtime, 'UTC', 'SYSTEM')), program.title, program.description, program.subtitle, program.programid, program.seriesid, program.category, channel.channum, channel.callsign, channel.name, channel.sourceid FROM program INNER JOIN channel ON program.chanid=channel.chanid WHERE channel.visible = 1 AND ((program.endtime > CONVERT_TZ(FROM_UNIXTIME(1353166231),'SYSTEM','UTC') AND program.endtime < CONVERT_TZ(FROM_UNIXTIME(1353429031),'SYSTEM','UTC')) OR (program.starttime >= CONVERT_TZ(FROM_UNIXTIME(1353166231),'SYSTEM','UTC') AND program.starttime <= CONVERT_TZ(FROM_UNIXTIME(1353429031),'SYSTEM','UTC')) OR (program.starttime <= CONVERT_TZ(FROM_UNIXTIME(1353166231),'SYSTEM','UTC') AND program.endtime >= CONVERT_TZ(FROM_UNIXTIME(1353429031),'SYSTEM','UTC'))) ORDER BY (channel.channum + 0), program.starttime ASC) Failed: Incorrect key file for table '/tmp/#sql_b55_0.MYI'; try to repair it
10:30:32 T:2847929440 ERROR: AddOnLog: MythTV cmyth PVR Client: LibCMyth: (cmyth)cmyth_mysql_get_guide, finalisation/execution of query failed!
10:30:32 T:2847929440 ERROR: AddOnLog: MythTV cmyth PVR Client: LibCMyth: (cmyth)cmyth_mysql_query_result: mysql_query(SELECT program.chanid, UNIX_TIMESTAMP(CONVERT_TZ(program.starttime, 'UTC', 'SYSTEM')), UNIX_TIMESTAMP(CONVERT_TZ(program.endtime, 'UTC', 'SYSTEM')), program.title, program.description, program.subtitle, program.programid, program.seriesid, program.category, channel.channum, channel.callsign, channel.name, channel.sourceid FROM program INNER JOIN channel ON program.chanid=channel.chanid WHERE channel.visible = 1 AND ((program.endtime > CONVERT_TZ(FROM_UNIXTIME(1353166231),'SYSTEM','UTC') AND program.endtime < CONVERT_TZ(FROM_UNIXTIME(1353429031),'SYSTEM','UTC')) OR (program.starttime >= CONVERT_TZ(FROM_UNIXTIME(1353166231),'SYSTEM','UTC') AND program.starttime <= CONVERT_TZ(FROM_UNIXTIME(1353429031),'SYSTEM','UTC')) OR (program.starttime <= CONVERT_TZ(FROM_UNIXTIME(1353166231),'SYSTEM','UTC') AND program.endtime >= CONVERT_TZ(FROM_UNIXTIME(1353429031),'SYSTEM','UTC'))) ORDER BY (channel.channum + 0), program.starttime ASC) Failed: Got error 28 from storage engine
10:30:32 T:2847929440 ERROR: AddOnLog: MythTV cmyth PVR Client: LibCMyth: (cmyth)cmyth_mysql_get_guide, finalisation/execution of query failed!
10:30:39 T:2862224480 ERROR: AddOnLog: MythTV cmyth PVR Client: LibCMyth: (cmyth)cmyth_conn_connect_path: reply ('ERROR') is not 'OK'
10:30:39 T:2862224480 ERROR: AddOnLog: MythTV cmyth PVR Client: CacheFile: NULL file provided
I have uploaded a complete log trace here:
https://docs.google.com/open?id=0B-ImKPf...TlxOGhrMFE
Can someone point me in the right direction? Thanks in advance - I’m stumped.