Kein Fernsehen mehr möglich

Moderators: dekarl, daschatten

Post Reply
mythTV-Nutzer
Junior
Posts: 22
Joined: Thu Dec 31, 2015 12:38 am
Germany

Kein Fernsehen mehr möglich

Post by mythTV-Nutzer »

Hallo alle miteinander,

ich hatte einen lauffähiges MythTV bis gestern Abend. Nun kann ich kein Fernsehprogramm mehr sehen. Aufgezeichnete Fernsehsendungen werden nicht mehr angezeigt. Videos anschauen geht aber noch.
Ich dachte, dass vielleicht die Datenbank kaputt gegangen ist und habe einen Sendersuchlauf gestartet. Dies hat problemlos funktioniert. Leider hat sich an dem Fehlerbild nichts geändert. Kann mir jemand sagen was hier passiert ist? An der Einstellung von MythTV wurde zum Zeitpunkt des auftreten des Fehlers nichts geändert. Wie kann ich das Problem beheben?


Das 'backend' gibt Fehlermeldungen aus. Hier ein Auszug der Fehlermeldungen:

Jan 13 23:23:12 lutz-System-Product-Name mythbackend: mythbackend[6408]: C thread_unknown mythcommandlineparser.cpp:2595 (ConfigureLogging) mythbackend version: fixes/0.27 [v0.27-193-g8ee257c] www.mythtv.org
Jan 13 23:23:12 lutz-System-Product-Name mythbackend: mythbackend[6408]: C thread_unknown mythcommandlineparser.cpp:2597 (ConfigureLogging) Qt version: compile: 4.8.6, runtime: 4.8.6
Jan 13 23:23:12 lutz-System-Product-Name mythbackend: mythbackend[6408]: N thread_unknown mythcommandlineparser.cpp:2599 (ConfigureLogging) Enabled verbose msgs: general
Jan 13 23:23:12 lutz-System-Product-Name mythbackend: mythbackend[6408]: N thread_unknown logging.cpp:914 (logStart) Setting Log Level to LOG_INFO
Jan 13 23:23:12 lutz-System-Product-Name mythbackend: mythbackend[6408]: I Logger logging.cpp:315 (run) Added logging to the console
Jan 13 23:23:12 lutz-System-Product-Name mythbackend: mythbackend[6408]: I thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup Interrupt handler
Jan 13 23:23:12 lutz-System-Product-Name mythbackend: mythbackend[6408]: I thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup Terminated handler
Jan 13 23:23:12 lutz-System-Product-Name mythbackend: mythbackend[6408]: I thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup Segmentation fault handler
Jan 13 23:23:12 lutz-System-Product-Name mythbackend: mythbackend[6408]: I thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup Aborted handler
Jan 13 23:23:12 lutz-System-Product-Name mythbackend: mythbackend[6408]: I thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup Bus error handler
Jan 13 23:23:12 lutz-System-Product-Name mythbackend: mythbackend[6408]: I thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup Floating point exception handler
Jan 13 23:23:12 lutz-System-Product-Name mythbackend: mythbackend[6408]: I thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup Illegal instruction handler
Jan 13 23:23:12 lutz-System-Product-Name mythbackend: mythbackend[6408]: I thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup Real-time signal 0 handler
Jan 13 23:23:12 lutz-System-Product-Name mythbackend: mythbackend[6408]: N thread_unknown mythdirs.cpp:55 (InitializeMythDirs) Using runtime prefix = /usr
Jan 13 23:23:12 lutz-System-Product-Name mythbackend: mythbackend[6408]: N thread_unknown mythdirs.cpp:68 (InitializeMythDirs) Using configuration directory = /home/mythtv/.mythtv
Jan 13 23:23:12 lutz-System-Product-Name mythbackend: mythbackend[6408]: I CoreContext mythcorecontext.cpp:254 (Init) Assumed character encoding: de_DE.UTF-8
Jan 13 23:23:12 lutz-System-Product-Name mythbackend: mythbackend[6408]: N CoreContext mythcontext.cpp:504 (LoadDatabaseSettings) Empty LocalHostName.
Jan 13 23:23:12 lutz-System-Product-Name mythbackend: mythbackend[6408]: I CoreContext mythcontext.cpp:512 (LoadDatabaseSettings) Using localhost value of lutz-System-Product-Name
Jan 13 23:23:12 lutz-System-Product-Name mythbackend: mythbackend[6408]: N CoreContext mythcorecontext.cpp:1328 (InitLocale) Setting QT default locale to de_US
Jan 13 23:23:12 lutz-System-Product-Name mythbackend: mythbackend[6408]: I CoreContext mythcorecontext.cpp:1361 (SaveLocaleDefaults) Current locale de_US
Jan 13 23:23:12 lutz-System-Product-Name mythbackend: mythbackend[6408]: E CoreContext mythlocale.cpp:108 (LoadDefaultsFromXML) No locale defaults file for de_US, skipping
Jan 13 23:23:12 lutz-System-Product-Name mythbackend: mythbackend[6408]: I CoreContext schemawizard.cpp:118 (Compare) Current MythTV Schema Version (DBSchemaVer): 1317
Jan 13 23:23:12 lutz-System-Product-Name mythbackend: mythbackend[6408]: I CoreContext mythtranslation.cpp:65 (load) Loading de translation for module mythfrontend
Jan 13 23:23:12 lutz-System-Product-Name mythbackend: mythbackend[6408]: N CoreContext main_helpers.cpp:582 (run_backend) MythBackend: Starting up as the master server.
Jan 13 23:23:12 lutz-System-Product-Name mythbackend: mythbackend[6408]: E CoreContext mythdb.cpp:183 (DBError) DB Error (Updating record basename):#012Query was:#012#012Driver error was [2/144]:#012QMYSQL: Unable to execute query#012Database error was:#012Table './mythconverg/recorded' is marked as crashed and last (automatic?) repair failed
Jan 13 23:23:12 lutz-System-Product-Name mythbackend: mythbackend[6408]: I LogForward loggingserver.cpp:1372 (forwardMessage) New Client: (#1)
Jan 13 23:23:12 lutz-System-Product-Name mythbackend: mythbackend[6408]: I LogForward loggingserver.cpp:295 (SyslogLogger) Added syslogging
Jan 13 23:23:16 lutz-System-Product-Name mythbackend: mythbackend[6408]: E CoreContext mythdbcon.cpp:837 (prepare) Error preparing query: SELECT DISTINCT LEFT(programid, LOCATE('/', programid)) FROM recorded WHERE programid <> ''
Jan 13 23:23:16 lutz-System-Product-Name mythbackend: mythbackend[6408]: E CoreContext mythdbcon.cpp:839 (prepare) Driver error was [2/144]:#012QMYSQL3: Unable to prepare statement#012Database error was:#012Table './mythconverg/recorded' is marked as crashed and last (automatic?) repair failed
Jan 13 23:23:16 lutz-System-Product-Name mythbackend: mythbackend[6408]: E CoreContext mythdb.cpp:183 (DBError) DB Error (CheckProgramIDAuthorities):#012Query was:#012SELECT DISTINCT LEFT(programid, LOCATE('/', programid)) FROM recorded WHERE programid <> ''#012No error type from QSqlError? Strange...
Jan 13 23:23:16 lutz-System-Product-Name mythbackend: mythbackend[6408]: I CoreContext programinfo.cpp:2136 (CheckProgramIDAuthorities) Found 0 distinct programid authorities
Jan 13 23:23:16 lutz-System-Product-Name mythbackend: mythbackend[6408]: I CoreContext housekeeper.cpp:582 (RegisterTask) Registering HouseKeeperTask 'LogClean'.
Jan 13 23:23:16 lutz-System-Product-Name mythbackend: mythbackend[6408]: I CoreContext housekeeper.cpp:582 (RegisterTask) Registering HouseKeeperTask 'DBCleanup'.
Jan 13 23:23:16 lutz-System-Product-Name mythbackend: mythbackend[6408]: I Scheduler mythdbcon.cpp:436 (getStaticCon) New static DB connectionSchedCon
Jan 13 23:23:16 lutz-System-Product-Name mythbackend: mythbackend[6408]: I CoreContext housekeeper.cpp:582 (RegisterTask) Registering HouseKeeperTask 'ThemeUpdateNotifications'.
Jan 13 23:23:16 lutz-System-Product-Name mythbackend: mythbackend[6408]: I CoreContext housekeeper.cpp:582 (RegisterTask) Registering HouseKeeperTask 'RecordedArtworkUpdate'.
Jan 13 23:23:16 lutz-System-Product-Name mythbackend: mythbackend[6408]: I CoreContext housekeeper.cpp:582 (RegisterTask) Registering HouseKeeperTask 'MythFillDB'.
Jan 13 23:23:16 lutz-System-Product-Name mythbackend: mythbackend[6408]: I CoreContext housekeeper.cpp:582 (RegisterTask) Registering HouseKeeperTask 'JobQueueRecover'.
Jan 13 23:23:16 lutz-System-Product-Name mythbackend: mythbackend[6408]: I CoreContext housekeeper.cpp:582 (RegisterTask) Registering HouseKeeperTask 'HardwareProfiler'.
Jan 13 23:23:16 lutz-System-Product-Name mythbackend: mythbackend[6408]: I CoreContext housekeeper.cpp:655 (Start) Starting HouseKeeper.
Jan 13 23:23:16 lutz-System-Product-Name mythbackend: mythbackend[6408]: E JobQueue mythdbcon.cpp:837 (prepare) Error preparing query: SELECT j.id, j.chanid, j.starttime, j.inserttime, j.type, j.cmds, j.flags, j.status, j.statustime, j.hostname, j.args, j.comment, r.endtime, j.schedruntime FROM jobqueue j LEFT JOIN recorded r ON j.chanid = r.chanid AND j.starttime = r.starttime ORDER BY j.schedruntime, j.id;
Jan 13 23:23:16 lutz-System-Product-Name mythbackend: mythbackend[6408]: E JobQueue mythdbcon.cpp:839 (prepare) Driver error was [2/144]:#012QMYSQL3: Unable to prepare statement#012Database error was:#012Table './mythconverg/recorded' is marked as crashed and last (automatic?) repair failed
Jan 13 23:23:16 lutz-System-Product-Name mythbackend: mythbackend[6408]: E JobQueue mythdb.cpp:183 (DBError) DB Error (Error in JobQueue::GetJobs(), Unable to query list of Jobs in Queue.):#012Query was:#012SELECT j.id, j.chanid, j.starttime, j.inserttime, j.type, j.cmds, j.flags, j.status, j.statustime, j.hostname, j.args, j.comment, r.endtime, j.schedruntime FROM jobqueue j LEFT JOIN recorded r ON j.chanid = r.chanid AND j.starttime = r.starttime ORDER BY j.schedruntime, j.id;#012Driver error was [2/144]:#012QMYSQL: Unable to execute query#012Database error was:#012Table './mythconverg/recorded' is marked as crashed and last (automatic?) repair failed
Jan 13 23:23:16 lutz-System-Product-Name mythbackend: mythbackend[6408]: I CoreContext serverpool.cpp:399 (listen) Listening on TCP 127.0.0.1:6544
Jan 13 23:23:16 lutz-System-Product-Name mythbackend: mythbackend[6408]: I CoreContext serverpool.cpp:399 (listen) Listening on TCP 192.168.178.36:6544
Jan 13 23:23:16 lutz-System-Product-Name mythbackend: mythbackend[6408]: I CoreContext serverpool.cpp:399 (listen) Listening on TCP [::1]:6544
Jan 13 23:23:16 lutz-System-Product-Name mythbackend: mythbackend[6408]: I CoreContext serverpool.cpp:399 (listen) Listening on TCP [fe80::222:15ff:fef0:e0df%eth0]:6544
Jan 13 23:23:17 lutz-System-Product-Name mythbackend: mythbackend[6408]: I CoreContext main_helpers.cpp:668 (run_backend) Main::Registering HttpStatus Extension
Jan 13 23:23:17 lutz-System-Product-Name mythbackend: mythbackend[6408]: I CoreContext serverpool.cpp:399 (listen) Listening on TCP 127.0.0.1:6543
Jan 13 23:23:17 lutz-System-Product-Name mythbackend: mythbackend[6408]: I CoreContext serverpool.cpp:399 (listen) Listening on TCP 192.168.178.36:6543
Jan 13 23:23:17 lutz-System-Product-Name mythbackend: mythbackend[6408]: I CoreContext serverpool.cpp:399 (listen) Listening on TCP [::1]:6543
Jan 13 23:23:17 lutz-System-Product-Name mythbackend: mythbackend[6408]: I CoreContext serverpool.cpp:399 (listen) Listening on TCP [fe80::222:15ff:fef0:e0df%eth0]:6543
Jan 13 23:23:17 lutz-System-Product-Name mythbackend: mythbackend[6408]: N CoreContext autoexpire.cpp:264 (CalcParams) AutoExpire: CalcParams(): Max required Free Space: 1.0 GB w/freq: 15 min
Jan 13 23:23:18 lutz-System-Product-Name mythbackend: mythbackend[6408]: I CoreContext bonjourregister.cpp:118 (BonjourCallback) Bonjour: Service registration complete: name 'Mythbackend on lutz-System-Product-Name' type '_mythbackend._tcp.' domain: 'local.'
Jan 13 23:23:19 lutz-System-Product-Name mythbackend: mythbackend[6408]: I Scheduler scheduler.cpp:2098 (HandleReschedule) Reschedule requested for MATCH 0 0 0 - SchedulerInit
Jan 13 23:23:19 lutz-System-Product-Name mythbackend: mythbackend[6408]: E Scheduler mythdbcon.cpp:837 (prepare) Error preparing query: CREATE TEMPORARY TABLE sched_temp_recorded LIKE recorded;
Jan 13 23:23:19 lutz-System-Product-Name mythbackend: mythbackend[6408]: E Scheduler mythdbcon.cpp:839 (prepare) Driver error was [2/144]:#012QMYSQL3: Unable to prepare statement#012Database error was:#012Table './mythconverg/recorded' is marked as crashed and last (automatic?) repair failed
Jan 13 23:23:19 lutz-System-Product-Name mythbackend: mythbackend[6408]: E Scheduler mythdb.cpp:183 (DBError) DB Error (Creating sched_temp_recorded table):#012Query was:#012CREATE TEMPORARY TABLE sched_temp_recorded LIKE recorded;#012No error type from QSqlError? Strange...
Jan 13 23:23:19 lutz-System-Product-Name mythbackend: mythbackend[6408]: E Scheduler mythdbcon.cpp:837 (prepare) Error preparing query: UPDATE recordmatch INNER JOIN sched_temp_record ON (recordmatch.recordid = sched_temp_record.recordid) INNER JOIN program p ON (recordmatch.chanid = p.chanid AND recordmatch.starttime = p.starttime AND recordmatch.manualid = p.manualid) LEFT JOIN oldrecorded ON ( sched_temp_record.dupmethod > 1 AND oldrecorded.duplicate <> 0 AND p.title = oldrecorded.title AND p.generic = 0 AND ( (p.programid <> '' AND p.programid = oldrecorded.programid) OR ( (p.programid = '' OR oldrecorded.programid = '') AND (((sched_temp_record.dupmethod & 0x02) = 0) OR (p.subtitle <> '' AND p.subtitle = oldrecorded.subtitle)) AND (((sched_temp_record.dupmethod & 0x04) = 0) OR (p.description <> '' AND p.description = oldrecorded.description)) AND (((sched_temp_record.dupmethod & 0x08) = 0) OR (p.subtitle <> '' AND (p.subtitle = oldrecorded.subtitle OR (oldrecorded.subtitle = '' AND p.subtitle = oldrecorded.description))) OR (p.subtitle = '' AND p.description <> '' AND (p.description = oldrecorded.subtitle OR (oldrecorded.subtitle = '' AND p.description = oldrecorded.description)))) ) ) ) LEFT JOIN sched_temp_recorded recorded ON ( sched_temp_record.dupmethod > 1 AND recorded.duplicate <> 0 AND p.title = recorded.title AND p.generic = 0 AND recorded.recgroup NOT IN ('LiveTV','Deleted') AND ( (p.programid <> '' AND p.programid = recorded.programid) OR ( (p.programid = '' OR recorded.programid = '') AND (((sched_temp_record.dupmethod & 0x02) = 0) OR (p.subtitle <> '' AND p.subtitle = recorded.subtitle)) AND (((sch
Jan 13 23:23:19 lutz-System-Product-Name mythbackend: mythbackend[6408]: E Scheduler mythdbcon.cpp:839 (prepare) Driver error was [2/1146]:#012QMYSQL3: Unable to prepare statement#012Database error was:#012Table 'mythconverg.sched_temp_recorded' doesn't exist
Jan 13 23:23:19 lutz-System-Product-Name mythbackend: mythbackend[6408]: E Scheduler mythdb.cpp:183 (DBError) DB Error (UpdateDuplicates):#012Query was:#012UPDATE recordmatch INNER JOIN sched_temp_record ON (recordmatch.recordid = sched_temp_record.recordid) INNER JOIN program p ON (recordmatch.chanid = p.chanid AND recordmatch.starttime = p.starttime AND recordmatch.manualid = p.manualid) LEFT JOIN oldrecorded ON ( sched_temp_record.dupmethod > 1 AND oldrecorded.duplicate <> 0 AND p.title = oldrecorded.title AND p.generic = 0 AND ( (p.programid <> '' AND p.programid = oldrecorded.programid) OR ( (p.programid = '' OR oldrecorded.programid = '') AND (((sched_temp_record.dupmethod & 0x02) = 0) OR (p.subtitle <> '' AND p.subtitle = oldrecorded.subtitle)) AND (((sched_temp_record.dupmethod & 0x04) = 0) OR (p.description <> '' AND p.description = oldrecorded.description)) AND (((sched_temp_record.dupmethod & 0x08) = 0) OR (p.subtitle <> '' AND (p.subtitle = oldrecorded.subtitle OR (oldrecorded.subtitle = '' AND p.subtitle = oldrecorded.description))) OR (p.subtitle = '' AND p.description <> '' AND (p.description = oldrecorded.subtitle OR (oldrecorded.subtitle = '' AND p.description = oldrecorded.description)))) ) ) ) LEFT JOIN sched_temp_recorded recorded ON ( sched_temp_record.dupmethod > 1 AND recorded.duplicate <> 0 AND p.title = recorded.title AND p.generic = 0 AND recorded.recgroup NOT IN ('LiveTV','Deleted') AND ( (p.programid <> '' AND p.programid = recorded.programid) OR ( (p.programid = '' OR recorded.programid = '') AND (((sched_temp_record.dupmethod & 0x02) = 0) OR (p.subtitle <> '' AND p.subtitle = recorded.subtitle))
Jan 13 23:23:19 lutz-System-Product-Name mythbackend: mythbackend[6408]: I Scheduler scheduler.cpp:2211 (HandleReschedule) Scheduled 0 items in 0.0 = 0.01 match + 0.00 check + 0.02 place
Jan 13 23:23:19 lutz-System-Product-Name mythbackend: mythbackend[6408]: I Scheduler scheduler.cpp:2278 (HandleRunSchedulerStartup) Scheduler: Seem to be woken up by USER
Jan 13 23:23:26 lutz-System-Product-Name mythbackend: mythbackend[6408]: E JobQueue mythdbcon.cpp:837 (prepare) Error preparing query: SELECT j.id, j.chanid, j.starttime, j.inserttime, j.type, j.cmds, j.flags, j.status, j.statustime, j.hostname, j.args, j.comment, r.endtime, j.schedruntime FROM jobqueue j LEFT JOIN recorded r ON j.chanid = r.chanid AND j.starttime = r.starttime ORDER BY j.schedruntime, j.id;
Jan 13 23:23:26 lutz-System-Product-Name mythbackend: mythbackend[6408]: E JobQueue mythdbcon.cpp:839 (prepare) Driver error was [2/144]:#012QMYSQL3: Unable to prepare statement#012Database error was:#012Table './mythconverg/recorded' is marked as crashed and last (automatic?) repair failed
Jan 13 23:23:26 lutz-System-Product-Name mythbackend: mythbackend[6408]: E JobQueue mythdb.cpp:183 (DBError) DB Error (Error in JobQueue::GetJobs(), Unable to query list of Jobs in Queue.):#012Query was:#012SELECT j.id, j.chanid, j.starttime, j.inserttime, j.type, j.cmds, j.flags, j.status, j.statustime, j.hostname, j.args, j.comment, r.endtime, j.schedruntime FROM jobqueue j LEFT JOIN recorded r ON j.chanid = r.chanid AND j.starttime = r.starttime ORDER BY j.schedruntime, j.id;#012Driver error was [2/144]:#012QMYSQL: Unable to execute query#012Database error was:#012Table './mythconverg/recorded' is marked as crashed and last (automatic?) repair failed
Jan 13 23:23:39 lutz-System-Product-Name mythbackend: mythbackend[6408]: I ProcessRequest mainserver.cpp:1420 (HandleAnnounce) MainServer::ANN Monitor
Jan 13 23:23:39 lutz-System-Product-Name mythbackend: mythbackend[6408]: I ProcessRequest mainserver.cpp:1422 (HandleAnnounce) adding: lutz-System-Product-Name as a client (events: 0)
Jan 13 23:23:40 lutz-System-Product-Name mythbackend: mythbackend[6408]: I ProcessRequest mainserver.cpp:1420 (HandleAnnounce) MainServer::ANN Monitor
Jan 13 23:23:40 lutz-System-Product-Name mythbackend: mythbackend[6408]: I ProcessRequest mainserver.cpp:1422 (HandleAnnounce) adding: lutz-System-Product-Name as a client (events: 1)
Jan 13 23:23:40 lutz-System-Product-Name mythbackend: mythbackend[6408]: I Scheduler scheduler.cpp:2098 (HandleReschedule) Reschedule requested for MATCH 0 0 0 - MythFillDatabase
Jan 13 23:23:40 lutz-System-Product-Name mythbackend: mythbackend[6408]: E Scheduler mythdbcon.cpp:837 (prepare) Error preparing query: CREATE TEMPORARY TABLE sched_temp_recorded LIKE recorded;
Jan 13 23:23:40 lutz-System-Product-Name mythbackend: mythbackend[6408]: E Scheduler mythdbcon.cpp:839 (prepare) Driver error was [2/144]:#012QMYSQL3: Unable to prepare statement#012Database error was:#012Table './mythconverg/recorded' is marked as crashed and last (automatic?) repair failed
Jan 13 23:23:40 lutz-System-Product-Name mythbackend: mythbackend[6408]: E Scheduler mythdb.cpp:183 (DBError) DB Error (Creating sched_temp_recorded table):#012Query was:#012CREATE TEMPORARY TABLE sched_temp_recorded LIKE recorded;#012No error type from QSqlError? Strange...
Jan 13 23:23:40 lutz-System-Product-Name mythbackend: mythbackend[6408]: E Scheduler mythdbcon.cpp:837 (prepare) Error preparing query: UPDATE recordmatch INNER JOIN sched_temp_record ON (recordmatch.recordid = sched_temp_record.recordid) INNER JOIN program p ON (recordmatch.chanid = p.chanid AND recordmatch.starttime = p.starttime AND recordmatch.manualid = p.manualid) LEFT JOIN oldrecorded ON ( sched_temp_record.dupmethod > 1 AND oldrecorded.duplicate <> 0 AND p.title = oldrecorded.title AND p.generic = 0 AND ( (p.programid <> '' AND p.programid = oldrecorded.programid) OR ( (p.programid = '' OR oldrecorded.programid = '') AND (((sched_temp_record.dupmethod & 0x02) = 0) OR (p.subtitle <> '' AND p.subtitle = oldrecorded.subtitle)) AND (((sched_temp_record.dupmethod & 0x04) = 0) OR (p.description <> '' AND p.description = oldrecorded.description)) AND (((sched_temp_record.dupmethod & 0x08) = 0) OR (p.subtitle <> '' AND (p.subtitle = oldrecorded.subtitle OR (oldrecorded.subtitle = '' AND p.subtitle = oldrecorded.description))) OR (p.subtitle = '' AND p.description <> '' AND (p.description = oldrecorded.subtitle OR (oldrecorded.subtitle = '' AND p.description = oldrecorded.description)))) ) ) ) LEFT JOIN sched_temp_recorded recorded ON ( sched_temp_record.dupmethod > 1 AND recorded.duplicate <> 0 AND p.title = recorded.title AND p.generic = 0 AND recorded.recgroup NOT IN ('LiveTV','Deleted') AND ( (p.programid <> '' AND p.programid = recorded.programid) OR ( (p.programid = '' OR recorded.programid = '') AND (((sched_temp_record.dupmethod & 0x02) = 0) OR (p.subtitle <> '' AND p.subtitle = recorded.subtitle)) AND (((sch
Jan 13 23:23:40 lutz-System-Product-Name mythbackend: mythbackend[6408]: E Scheduler mythdbcon.cpp:839 (prepare) Driver error was [2/1146]:#012QMYSQL3: Unable to prepare statement#012Database error was:#012Table 'mythconverg.sched_temp_recorded' doesn't exist
Jan 13 23:23:40 lutz-System-Product-Name mythbackend: mythbackend[6408]: E Scheduler mythdb.cpp:183 (DBError) DB Error (UpdateDuplicates):#012Query was:#012UPDATE recordmatch INNER JOIN sched_temp_record ON (recordmatch.recordid = sched_temp_record.recordid) INNER JOIN program p ON (recordmatch.chanid = p.chanid AND recordmatch.starttime = p.starttime AND recordmatch.manualid = p.manualid) LEFT JOIN oldrecorded ON ( sched_temp_record.dupmethod > 1 AND oldrecorded.duplicate <> 0 AND p.title = oldrecorded.title AND p.generic = 0 AND ( (p.programid <> '' AND p.programid = oldrecorded.programid) OR ( (p.programid = '' OR oldrecorded.programid = '') AND (((sched_temp_record.dupmethod & 0x02) = 0) OR (p.subtitle <> '' AND p.subtitle = oldrecorded.subtitle)) AND (((sched_temp_record.dupmethod & 0x04) = 0) OR (p.description <> '' AND p.description = oldrecorded.description)) AND (((sched_temp_record.dupmethod & 0x08) = 0) OR (p.subtitle <> '' AND (p.subtitle = oldrecorded.subtitle OR (oldrecorded.subtitle = '' AND p.subtitle = oldrecorded.description))) OR (p.subtitle = '' AND p.description <> '' AND (p.description = oldrecorded.subtitle OR (oldrecorded.subtitle = '' AND p.description = oldrecorded.description)))) ) ) ) LEFT JOIN sched_temp_recorded recorded ON ( sched_temp_record.dupmethod > 1 AND recorded.duplicate <> 0 AND p.title = recorded.title AND p.generic = 0 AND recorded.recgroup NOT IN ('LiveTV','Deleted') AND ( (p.programid <> '' AND p.programid = recorded.programid) OR ( (p.programid = '' OR recorded.programid = '') AND (((sched_temp_record.dupmethod & 0x02) = 0) OR (p.subtitle <> '' AND p.subtitle = recorded.subtitle))
Jan 13 23:23:40 lutz-System-Product-Name mythbackend: mythbackend[6408]: I Scheduler scheduler.cpp:2211 (HandleReschedule) Scheduled 0 items in 0.0 = 0.01 match + 0.00 check + 0.01 place
Jan 13 23:23:59 lutz-System-Product-Name mythbackend: mythbackend[6408]: I ProcessRequest mainserver.cpp:1420 (HandleAnnounce) MainServer::ANN Monitor
Jan 13 23:23:59 lutz-System-Product-Name mythbackend: mythbackend[6408]: I ProcessRequest mainserver.cpp:1422 (HandleAnnounce) adding: lutz-System-Product-Name as a client (events: 0)
Jan 13 23:23:59 lutz-System-Product-Name mythbackend: mythbackend[6408]: I ProcessRequest mainserver.cpp:1420 (HandleAnnounce) MainServer::ANN Monitor
Jan 13 23:23:59 lutz-System-Product-Name mythbackend: mythbackend[6408]: I ProcessRequest mainserver.cpp:1422 (HandleAnnounce) adding: lutz-System-Product-Name as a client (events: 1)
Jan 13 23:24:10 lutz-System-Product-Name mythbackend: mythbackend[6408]: I ProcessRequest mainserver.cpp:1420 (HandleAnnounce) MainServer::ANN Playback
Jan 13 23:24:10 lutz-System-Product-Name mythbackend: mythbackend[6408]: I ProcessRequest mainserver.cpp:1422 (HandleAnnounce) adding: lutz-System-Product-Name as a client (events: 0)
Jan 13 23:24:10 lutz-System-Product-Name mythbackend: mythbackend[6408]: I TVRecEvent tv_rec.cpp:1050 (HandleStateChange) TVRec[1]: Changing from None to WatchingLiveTV
Jan 13 23:24:10 lutz-System-Product-Name mythbackend: mythbackend[6408]: I TVRecEvent tv_rec.cpp:3602 (TuningCheckForHWChange) TVRec[1]: HW Tuner: 1->1
Jan 13 23:24:12 lutz-System-Product-Name mythbackend: mythbackend[6408]: N CoreContext autoexpire.cpp:264 (CalcParams) AutoExpire: CalcParams(): Max required Free Space: 3.0 GB w/freq: 14 min
Jan 13 23:24:12 lutz-System-Product-Name mythbackend: mythbackend[6408]: E TVRecEvent mythdbcon.cpp:837 (prepare) Error preparing query: UPDATE recorded SET recgroup = :RECGROUP WHERE chanid = :CHANID AND starttime = :START ;
Jan 13 23:24:12 lutz-System-Product-Name mythbackend: mythbackend[6408]: E TVRecEvent mythdbcon.cpp:839 (prepare) Driver error was [2/144]:#012QMYSQL3: Unable to prepare statement#012Database error was:#012Table './mythconverg/recorded' is marked as crashed and last (automatic?) repair failed
Jan 13 23:24:12 lutz-System-Product-Name mythbackend: mythbackend[6408]: E TVRecEvent mythdb.cpp:183 (DBError) DB Error (RecGroup update):#012Query was:#012UPDATE recorded SET recgroup = :RECGROUP WHERE chanid = :CHANID AND starttime = :START ;#012Bindings were:#012:CHANID=12160, :RECGROUP="LiveTV", :START=2016-01-13T22:24:12Z#012Driver error was [2/1064]:#012QMYSQL: Unable to execute query#012Database error was:#012You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':RECGROUP WHERE chanid = :CHANID AND starttime = :START' at line 1
Jan 13 23:24:12 lutz-System-Product-Name mythbackend: mythbackend[6408]: E TVRecEvent mythdb.cpp:183 (DBError) DB Error (InsertProgram -- lock):#012Query was:#012#012Driver error was [2/144]:#012QMYSQL: Unable to execute query#012Database error was:#012Table './mythconverg/recorded' is marked as crashed and last (automatic?) repair failed
Jan 13 23:24:12 lutz-System-Product-Name mythbackend: mythbackend[6408]: E TVRecEvent recordinginfo.cpp:843 (StartedRecording) Couldn't insert program
Jan 13 23:24:12 lutz-System-Product-Name mythbackend: mythbackend[6408]: E TVRecEvent mythdbcon.cpp:837 (prepare) Error preparing query: SELECT recgroup FROM recorded WHERE chanid = :CHANID AND starttime = :START
Jan 13 23:24:12 lutz-System-Product-Name mythbackend: mythbackend[6408]: E TVRecEvent mythdbcon.cpp:839 (prepare) Driver error was [2/144]:#012QMYSQL3: Unable to prepare statement#012Database error was:#012Table './mythconverg/recorded' is marked as crashed and last (automatic?) repair failed
Jan 13 23:24:12 lutz-System-Product-Name mythbackend: mythbackend[6408]: E TVRecEvent threadedfilewriter.cpp:129 (Open) TFW(12160_20160113222502.mpg:-1): Opening file '12160_20160113222502.mpg'.#012#011#011#011eno: Permission denied (13)
Jan 13 23:24:12 lutz-System-Product-Name mythbackend: mythbackend[6408]: E TVRecEvent tv_rec.cpp:4518 (GetProgramRingBufferForLiveTV) TVRec[1]: RingBuffer '12160_20160113222502.mpg' not open...
Jan 13 23:24:12 lutz-System-Product-Name mythbackend: mythbackend[6408]: E TVRecEvent tv_rec.cpp:4555 (CreateLiveTVRingBuffer) TVRec[1]: CreateLiveTVRingBuffer(11160) failed
Jan 13 23:24:12 lutz-System-Product-Name mythbackend: mythbackend[6408]: E TVRecEvent tv_rec.cpp:3831 (TuningFrequency) TVRec[1]: Failed to create RingBuffer 1
Jan 13 23:24:12 lutz-System-Product-Name mythbackend: mythbackend[6408]: I TVRecEvent tv_rec.cpp:1050 (HandleStateChange) TVRec[1]: Changing from WatchingLiveTV to None
Jan 13 23:24:12 lutz-System-Product-Name mythbackend: mythbackend[6408]: E CoreContext mythdbcon.cpp:837 (prepare) Error preparing query: SELECT r.title, r.subtitle, r.description, r.season, r.episode, r.category, r.chanid, c.channum, c.callsign, c.name, c.outputfilters,r.recgroup, r.playgroup, r.storagegroup, r.basename, r.hostname, r.recpriority, r.seriesid, r.programid, r.inetref, r.filesize, r.progstart, r.progend, r.stars, r.starttime, r.endtime, p.airdate+0, r.originalairdate, r.lastmodified, r.recordid, c.commmethod, r.commflagged, r.previouslyshown, r.transcoder, r.transcoded, r.deletepending, r.preserve, r.cutlist, r.autoexpire, r.editing, r.bookmark, r.watched, p.audioprop+0, p.videoprop+0, p.subtitletypes+0, r.findid, rec.dupin, rec.dupmethod, p.syndicatedepisodenumber, p.partnumber, p.parttotal FROM recorded AS r LEFT JOIN channel AS c ON (r.chanid = c.chanid) LEFT JOIN recordedprogram AS p ON (r.chanid = p.chanid AND r.progstart = p.starttime) LEFT JOIN record AS rec ON (r.recordid = rec.recordid) WHERE r.chanid = :CHANID AND r.starttime = :RECSTARTTS
Jan 13 23:24:12 lutz-System-Product-Name mythbackend: mythbackend[6408]: E CoreContext mythdbcon.cpp:839 (prepare) Driver error was [2/144]:#012QMYSQL3: Unable to prepare statement#012Database error was:#012Table './mythconverg/recorded' is marked as crashed and last (automatic?) repair failed
Jan 13 23:24:12 lutz-System-Product-Name mythbackend: mythbackend[6408]: E CoreContext mythdb.cpp:183 (DBError) DB Error (LoadProgramFromRecorded):#012Query was:#012SELECT r.title, r.subtitle, r.description, r.season, r.episode, r.category, r.chanid, c.channum, c.callsign, c.name, c.outputfilters,r.recgroup, r.playgroup, r.storagegroup, r.basename, r.hostname, r.recpriority, r.seriesid, r.programid, r.inetref, r.filesize, r.progstart, r.progend, r.stars, r.starttime, r.endtime, p.airdate+0, r.originalairdate, r.lastmodified, r.recordid, c.commmethod, r.commflagged, r.previouslyshown, r.transcoder, r.transcoded, r.deletepending, r.preserve, r.cutlist, r.autoexpire, r.editing, r.bookmark, r.watched, p.audioprop+0, p.videoprop+0, p.subtitletypes+0, r.findid, rec.dupin, rec.dupmethod, p.syndicatedepisodenumber, p.partnumber, p.parttotal FROM recorded AS r LEFT JOIN channel AS c ON (r.chanid = c.chanid) LEFT JOIN recordedprogram AS p ON (r.chanid = p.chanid AND r.progstart = p.starttime) LEFT JOIN record AS rec ON (r.recordid = rec.recordid) WHERE r.chanid = :CHANID AND r.starttime = :RECSTARTTS#012Bindings were:#012:CHANID=12160, :RECSTARTTS=2016-01-13T22:24:12Z#012Driver error was [2/1064]:#012QMYSQL: Unable to execute query#012Database error was:#012You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':CHANID AND r.starttime = :RECSTARTTS' at line 1
Jan 13 23:24:20 lutz-System-Product-Name mythbackend: mythbackend[6408]: I ProcessRequest mainserver.cpp:1420 (HandleAnnounce) MainServer::ANN Playback
Jan 13 23:24:20 lutz-System-Product-Name mythbackend: mythbackend[6408]: I ProcessRequest mainserver.cpp:1422 (HandleAnnounce) adding: lutz-system-product-name as a client (events: 0)
Jan 13 23:24:20 lutz-System-Product-Name mythbackend: mythbackend[6408]: I ProcessRequest mainserver.cpp:1538 (HandleAnnounce) MainServer::HandleAnnounce FileTransfer
Jan 13 23:24:20 lutz-System-Product-Name mythbackend: mythbackend[6408]: I ProcessRequest mainserver.cpp:1540 (HandleAnnounce) adding: lutz-system-product-name as a remote file transfer
Jan 13 23:24:20 lutz-System-Product-Name mythbackend: mythbackend[6408]: E ProcessRequest mythdbcon.cpp:837 (prepare) Error preparing query: SELECT chanid, starttime FROM recorded WHERE basename = :BASENAME
Jan 13 23:24:20 lutz-System-Product-Name mythbackend: mythbackend[6408]: E ProcessRequest mythdbcon.cpp:839 (prepare) Driver error was [2/144]:#012QMYSQL3: Unable to prepare statement#012Database error was:#012Table './mythconverg/recorded' is marked as crashed and last (automatic?) repair failed
Jan 13 23:24:20 lutz-System-Product-Name mythbackend: mythbackend[6408]: E ProcessRequest mythdbcon.cpp:837 (prepare) Error preparing query: SELECT chanid, starttime FROM recorded WHERE basename = :BASENAME
Jan 13 23:24:20 lutz-System-Product-Name mythbackend: mythbackend[6408]: E ProcessRequest mythdbcon.cpp:839 (prepare) Driver error was [2/144]:#012QMYSQL3: Unable to prepare statement#012Database error was:#012Table './mythconverg/recorded' is marked as crashed and last (automatic?) repair failed
Jan 13 23:24:26 lutz-System-Product-Name mythbackend: mythbackend[6408]: E JobQueue mythdbcon.cpp:837 (prepare) Error preparing query: SELECT j.id, j.chanid, j.starttime, j.inserttime, j.type, j.cmds, j.flags, j.status, j.statustime, j.hostname, j.args, j.comment, r.endtime, j.schedruntime FROM jobqueue j LEFT JOIN recorded r ON j.chanid = r.chanid AND j.starttime = r.starttime ORDER BY j.schedruntime, j.id;
Jan 13 23:24:26 lutz-System-Product-Name mythbackend: mythbackend[6408]: E JobQueue mythdbcon.cpp:839 (prepare) Driver error was [2/144]:#012QMYSQL3: Unable to prepare statement#012Database error was:#012Table './mythconverg/recorded' is marked as crashed and last (automatic?) repair failed
Jan 13 23:24:26 lutz-System-Product-Name mythbackend: mythbackend[6408]: E JobQueue mythdb.cpp:183 (DBError) DB Error (Error in JobQueue::GetJobs(), Unable to query list of Jobs in Queue.):#012Query was:#012SELECT j.id, j.chanid, j.starttime, j.inserttime, j.type, j.cmds, j.flags, j.status, j.statustime, j.hostname, j.args, j.comment, r.endtime, j.schedruntime FROM jobqueue j LEFT JOIN recorded r ON j.chanid = r.chanid AND j.starttime = r.starttime ORDER BY j.schedruntime, j.id;#012Driver error was [2/144]:#012QMYSQL: Unable to execute query#012Database error was:#012Table './mythconverg/recorded' is marked as crashed and last (automatic?) repair failed
Jan 13 23:24:35 lutz-System-Product-Name mythbackend: mythbackend[6408]: E ProcessRequest mythdbcon.cpp:837 (prepare) Error preparing query: SELECT r.title, r.subtitle, r.description, r.season, r.episode, r.category, r.chanid, c.channum, c.callsign, c.name, c.outputfilters,r.recgroup, r.playgroup, r.storagegroup, r.basename, r.hostname, r.recpriority, r.seriesid, r.programid, r.inetref, r.filesize, r.progstart, r.progend, r.stars, r.starttime, r.endtime, p.airdate+0, r.originalairdate, r.lastmodified, r.recordid, c.commmethod, r.commflagged, r.previouslyshown, r.transcoder, r.transcoded, r.deletepending, r.preserve, r.cutlist, r.autoexpire, r.editing, r.bookmark, r.watched, p.audioprop+0, p.videoprop+0, p.subtitletypes+0, r.findid, rec.dupin, rec.dupmethod, p.syndicatedepisodenumber, p.partnumber, p.parttotal FROM recorded AS r LEFT JOIN channel AS c ON (r.chanid = c.chanid) LEFT JOIN recordedprogram AS p ON (r.chanid = p.chanid AND r.progstart = p.starttime) LEFT JOIN record AS rec ON (r.recordid = rec.recordid)
Jan 13 23:24:35 lutz-System-Product-Name mythbackend: mythbackend[6408]: E ProcessRequest mythdbcon.cpp:839 (prepare) Driver error was [2/144]:#012QMYSQL3: Unable to prepare statement#012Database error was:#012Table './mythconverg/recorded' is marked as crashed and last (automatic?) repair failed
Jan 13 23:24:35 lutz-System-Product-Name mythbackend: mythbackend[6408]: E ProcessRequest mythdb.cpp:183 (DBError) DB Error (ProgramList::FromRecorded):#012Query was:#012SELECT r.title, r.subtitle, r.description, r.season, r.episode, r.category, r.chanid, c.channum, c.callsign, c.name, c.outputfilters,r.recgroup, r.playgroup, r.storagegroup, r.basename, r.hostname, r.recpriority, r.seriesid, r.programid, r.inetref, r.filesize, r.progstart, r.progend, r.stars, r.starttime, r.endtime, p.airdate+0, r.originalairdate, r.lastmodified, r.recordid, c.commmethod, r.commflagged, r.previouslyshown, r.transcoder, r.transcoded, r.deletepending, r.preserve, r.cutlist, r.autoexpire, r.editing, r.bookmark, r.watched, p.audioprop+0, p.videoprop+0, p.subtitletypes+0, r.findid, rec.dupin, rec.dupmethod, p.syndicatedepisodenumber, p.partnumber, p.parttotal FROM recorded AS r LEFT JOIN channel AS c ON (r.chanid = c.chanid) LEFT JOIN recordedprogram AS p ON (r.chanid = p.chanid AND r.progstart = p.starttime) LEFT JOIN record AS rec ON (r.recordid = rec.recordid) #012Driver error was [2/144]:#012QMYSQL: Unable to execute query#012Database error was:#012Table './mythconverg/recorded' is marked as crashed and last (automatic?) repair failed
Jan 13 23:24:36 lutz-System-Product-Name mythbackend: mythbackend[6408]: N Expire autoexpire.cpp:264 (CalcParams) AutoExpire: CalcParams(): Max required Free Space: 1.0 GB w/freq: 15 min
Jan 13 23:24:36 lutz-System-Product-Name mythbackend: mythbackend[6408]: E Expire mythdbcon.cpp:837 (prepare) Error preparing query: SELECT recorded.chanid, starttime FROM recorded LEFT JOIN channel ON recorded.chanid = channel.chanid WHERE recgroup = 'LiveTV' AND endtime < DATE_ADD(starttime, INTERVAL '2' MINUTE) AND endtime <= DATE_ADD(NOW(), INTERVAL '-1' MINUTE) AND deletepending = 0 ORDER BY autoexpire DESC, starttime ASC
Jan 13 23:24:36 lutz-System-Product-Name mythbackend: mythbackend[6408]: E Expire mythdbcon.cpp:839 (prepare) Driver error was [2/144]:#012QMYSQL3: Unable to prepare statement#012Database error was:#012Table './mythconverg/recorded' is marked as crashed and last (automatic?) repair failed
Jan 13 23:24:36 lutz-System-Product-Name mythbackend: mythbackend[6408]: E Expire mythdbcon.cpp:837 (prepare) Error preparing query: SELECT recorded.chanid, starttime FROM recorded LEFT JOIN channel ON recorded.chanid = channel.chanid WHERE recgroup = 'LiveTV' AND endtime <= DATE_ADD(NOW(), INTERVAL '-1' DAY) AND deletepending = 0 ORDER BY autoexpire DESC, starttime ASC
Jan 13 23:24:36 lutz-System-Product-Name mythbackend: mythbackend[6408]: E Expire mythdbcon.cpp:839 (prepare) Driver error was [2/144]:#012QMYSQL3: Unable to prepare statement#012Database error was:#012Table './mythconverg/recorded' is marked as crashed and last (automatic?) repair failed
Jan 13 23:24:36 lutz-System-Product-Name mythbackend: mythbackend[6408]: E Expire mythdbcon.cpp:837 (prepare) Error preparing query: SELECT recorded.chanid, starttime FROM recorded LEFT JOIN channel ON recorded.chanid = channel.chanid WHERE recgroup = 'Deleted' AND lastmodified <= DATE_ADD(NOW(), INTERVAL '-5' MINUTE) AND deletepending = 0 ORDER BY autoexpire DESC, lastmodified ASC
Jan 13 23:24:36 lutz-System-Product-Name mythbackend: mythbackend[6408]: E Expire mythdbcon.cpp:839 (prepare) Driver error was [2/144]:#012QMYSQL3: Unable to prepare statement#012Database error was:#012Table './mythconverg/recorded' is marked as crashed and last (automatic?) repair failed
Jan 13 23:24:36 lutz-System-Product-Name mythbackend: mythbackend[6408]: E Expire mythdbcon.cpp:837 (prepare) Error preparing query: SELECT recorded.chanid, starttime FROM recorded LEFT JOIN channel ON recorded.chanid = channel.chanid WHERE recgroup = 'Deleted' AND deletepending = 0 ORDER BY autoexpire DESC, lastmodified ASC
Jan 13 23:24:36 lutz-System-Product-Name mythbackend: mythbackend[6408]: E Expire mythdbcon.cpp:839 (prepare) Driver error was [2/144]:#012QMYSQL3: Unable to prepare statement#012Database error was:#012Table './mythconverg/recorded' is marked as crashed and last (automatic?) repair failed
Jan 13 23:24:36 lutz-System-Product-Name mythbackend: mythbackend[6408]: E Expire mythdbcon.cpp:837 (prepare) Error preparing query: SELECT recorded.chanid, starttime FROM recorded LEFT JOIN channel ON recorded.chanid = channel.chanid WHERE autoexpire > 0 AND deletepending = 0 ORDER BY autoexpire DESC, recorded.recpriority ASC, starttime ASC
beppo
Senior
Posts: 159
Joined: Sun Feb 09, 2014 8:12 am
Germany

Re: Kein Fernsehen mehr möglich

Post by beppo »

Guten Morgen,

deine Datenbank hat was abgekriegt und startet nicht mehr.
Database error was:#012Table './mythconverg/recorded' is marked as crashed and last (automatic?) repair failed
Ich würde dich bitten, zwei Dinge zu prüfen. Einmal nachgucken ob du noch Speicherplatz auf deine Platten hast.
Terminal auf und den Befehl "df -h" ausführen ( ohne die "")
Wenn der dir sagt das du noch überall ausreichend Platz ist, kannst du mal versuchen die Datenband zu reparieren.
Mit dem Befehl: "mysqlcheck --repair mythconverg -p" aus dem Terminal gestartet, wird deine Datenbank repariert.
Wobei du da nach deinem root Passwort für die Datenbank gefragt wirst.

Wenn das auch nicht geholfen hat, dann meld dich noch mal mit den jeweiligen Fehlermeldungen.

Grüße Beppo
Viele Grüße Beppo
mythTV-Nutzer
Junior
Posts: 22
Joined: Thu Dec 31, 2015 12:38 am
Germany

Re: Kein Fernsehen mehr möglich

Post by mythTV-Nutzer »

Guten Abend Beppo,

recht herzlichen Dank für deine Hilfe. Die Datenbank konnte ich mit deiner Hilfe reparieren. Es kann wieder ferngesehen werden. Speicherplatz war ausreichend vorhanden.

Die Datenbank habe ich mit folgendem Befehl repariert:

mysqlcheck --repair mythconverg -p<Passwort der Datenbank> -u <Benutzername von mythtv>

Für die in spitzen Klammern stehenden Parameter müssen die entsprechenden Daten ohne spitze Klammern eingetragen werden.

Mit besten Grüßen
mythtv-Nutzer
Post Reply