[mythtv-users] Leanfront stopped working

David Engel david at istwok.net
Mon Feb 7 21:21:54 UTC 2022


On Mon, Feb 07, 2022 at 10:59:12PM +0530, Rajil Saraswat wrote:
> On Mon, 7 Feb 2022 at 22:42, Rajil Saraswat <rajil.s at gmail.com> wrote:
> 
> > Hello,
> >
> > I have mythtv/focal,now 2:31.0+fixes.20200323 installed and working fine
> > with leanfront. Unfortunately, it does not play livetv anymore.
> > Mythtvbackend throws up an error,
> >
> > Feb  7 22:33:46 mythvm mythbackend: mythbackend[530191]: I Scheduler
> > scheduler.cpp:2308 (HandleReschedule) Reschedule requested for MATCH 192 0
> > 0 - SaveRule LiveTV 2022-02-07
> > Feb  7 22:33:46 mythvm mythbackend: mythbackend[530191]: E Scheduler
> > mythdbcon.cpp:843 (prepare) Error preparing query: DELETE recordmatch FROM
> > recordmatch, channel WHERE recordmatch.chanid = channel.chanid AND
> > recordmatch.recordid = :RECORDID
> > Feb  7 22:33:46 mythvm mythbackend: mythbackend[530191]: E Scheduler
> > mythdbcon.cpp:845 (prepare) Driver error was [2/0]:#012QMYSQL3: Unable to
> > prepare statement#012Database error was:#012
> >
> > The leanback version file is 20220202-leanfront-release-v0-333-gaeea3cf.apk
> >
> > The complete log is at https://pastebin.com/qVG2UvCU
> >
> > Is there anyway to fix this?
> >
> > Thanks
> >
> 
> Nevermind, a change in LiveTV order fixed it.

That shouldn't fix the database error.  Can you undo your "fix" and
see if it still fails?  If it does, can you send the entire log?  You
might need to add "database" to the logging, i.e. -v general,database.

Also, are you sure your recordmatch table wasn't marked crashed and
was either manually or automatically repaired?  With default, MySQL
settings, tables unfortunately crash occasionally.

David
-- 
David Engel
david at istwok.net


More information about the mythtv-users mailing list