[mythtv-users] Myth is automatically cancelling recordings?

Ben Dash ben_dash at yahoo.com
Sat Jun 24 15:31:03 UTC 2006


--- Robert Johnston wrote:
> On 6/23/06, Ben Dash <ben_dash at yahoo.com> wrote:
> > --- Marco Nelissen wrote:
> > > Could it be that 0.19 is smarter (or
> > > perhaps
> > > dumber) than 0.18 in that regard, and is not
> > > recording repeats?
> > I can convince Myth that I really do want to
> record a
> > show blah blah
> > Is there any way to get MySQL to give me a trace
> to
> > see what rom/table is being updated when I
> selected
> > "Preview schedule changes"?
> Yes. but you can also get Myth to tell you. Try
> running MythFrontend
> with -v db (Or is it -v database. One of those two
> will work, and will
> report every query run by the frontend).

Perfect, thanks!  The command is:
mythfrontend -v database

---SQL output---
2006-06-24 10:19:38.535 New DB scheduler connection
2006-06-24 10:19:38.541 Connected to database
'mythconverg' at host: beta
2006-06-24 10:19:38.542 MSqlQuery: SELECT
GET_LOCK('DiffSchedule', 2);
2006-06-24 10:19:38.595 MSqlQuery: DROP TABLE IF
EXISTS record_tmp;
2006-06-24 10:19:38.637 MSqlQuery: CREATE TABLE
record_tmp SELECT * FROM record;2006-06-24
10:19:38.659 MSqlQuery: SELECT * FROM record_tmp WHERE
recordid = 44;2006-06-24 10:19:38.660 MSqlQuery:
UPDATE record_tmp SET recordid = 44, chanid = '1026'
WHERE recordid = 44;
2006-06-24 10:19:38.662 MSqlQuery: SELECT * FROM
record_tmp WHERE recordid = 44;2006-06-24 10:19:38.663
MSqlQuery: UPDATE record_tmp SET recordid = 44,
station = 'CSPAN' WHERE recordid = 44;
2006-06-24 10:19:38.664 MSqlQuery: SELECT * FROM
record_tmp WHERE recordid = 44;2006-06-24 10:19:38.666
MSqlQuery: UPDATE record_tmp SET recordid = 44, title
= 'British House of Commons' WHERE recordid = 44;
2006-06-24 10:19:38.668 MSqlQuery: SELECT * FROM
record_tmp WHERE recordid = 44;2006-06-24 10:19:38.669
MSqlQuery: UPDATE record_tmp SET recordid = 44,
subtitle = '' WHERE recordid = 44;
2006-06-24 10:19:38.670 MSqlQuery: SELECT * FROM
record_tmp WHERE recordid = 44;2006-06-24 10:19:38.671
MSqlQuery: UPDATE record_tmp SET recordid = 44,
description = 'Coverage of the British House of
Commons, with prime minister response-time.' WHERE
recordid = 44;
2006-06-24 10:19:38.672 MSqlQuery: SELECT * FROM
record_tmp WHERE recordid = 44;2006-06-24 10:19:38.673
MSqlQuery: UPDATE record_tmp SET recordid = 44,
starttime = '00:00:00' WHERE recordid = 44;
2006-06-24 10:19:38.675 MSqlQuery: SELECT * FROM
record_tmp WHERE recordid = 44;2006-06-24 10:19:38.675
MSqlQuery: UPDATE record_tmp SET recordid = 44,
endtime = '00:00:00' WHERE recordid = 44;
2006-06-24 10:19:38.677 MSqlQuery: SELECT * FROM
record_tmp WHERE recordid = 44;2006-06-24 10:19:38.678
MSqlQuery: UPDATE record_tmp SET recordid = 44,
startdate = '2006-06-24' WHERE recordid = 44;
2006-06-24 10:19:38.679 MSqlQuery: SELECT * FROM
record_tmp WHERE recordid = 44;2006-06-24 10:19:38.680
MSqlQuery: UPDATE record_tmp SET recordid = 44,
enddate = '2006-06-24' WHERE recordid = 44;
2006-06-24 10:19:38.681 MSqlQuery: SELECT * FROM
record_tmp WHERE recordid = 44;2006-06-24 10:19:38.682
MSqlQuery: UPDATE record_tmp SET recordid = 44,
category = 'Talk' WHERE recordid = 44;
2006-06-24 10:19:38.683 MSqlQuery: SELECT * FROM
record_tmp WHERE recordid = 44;2006-06-24 10:19:38.684
MSqlQuery: UPDATE record_tmp SET recordid = 44,
seriesid = 'SH400507' WHERE recordid = 44;
2006-06-24 10:19:38.685 MSqlQuery: SELECT * FROM
record_tmp WHERE recordid = 44;2006-06-24 10:19:38.686
MSqlQuery: UPDATE record_tmp SET recordid = 44,
programid = 'SH4005070000' WHERE recordid = 44;
2006-06-24 10:19:38.687 MSqlQuery: SELECT * FROM
record_tmp WHERE recordid = 44;2006-06-24 10:19:38.688
MSqlQuery: UPDATE record_tmp SET recordid = 44, findid
= '0' WHERE recordid = 44;
2006-06-24 10:19:38.690 MSqlQuery: SELECT * FROM
record_tmp WHERE recordid = 44;2006-06-24 10:19:38.691
MSqlQuery: UPDATE record_tmp SET recordid = 44, type =
'10' WHERE recordid = 44;
2006-06-24 10:19:38.692 MSqlQuery: SELECT * FROM
record_tmp WHERE recordid = 44;2006-06-24 10:19:38.693
MSqlQuery: UPDATE record_tmp SET recordid = 44,
recpriority = '0' WHERE recordid = 44;
2006-06-24 10:19:38.694 MSqlQuery: SELECT * FROM
record_tmp WHERE recordid = 44;2006-06-24 10:19:38.695
MSqlQuery: UPDATE record_tmp SET recordid = 44,
startoffset = '0' WHERE recordid = 44;
2006-06-24 10:19:38.696 MSqlQuery: SELECT * FROM
record_tmp WHERE recordid = 44;2006-06-24 10:19:38.697
MSqlQuery: UPDATE record_tmp SET recordid = 44,
endoffset = '0' WHERE recordid = 44;
2006-06-24 10:19:38.698 MSqlQuery: SELECT * FROM
record_tmp WHERE recordid = 44;2006-06-24 10:19:38.699
MSqlQuery: UPDATE record_tmp SET recordid = 44,
dupmethod = '1' WHERE recordid = 44;
2006-06-24 10:19:38.700 MSqlQuery: SELECT * FROM
record_tmp WHERE recordid = 44;2006-06-24 10:19:38.701
MSqlQuery: UPDATE record_tmp SET recordid = 44, dupin
= '15' WHERE recordid = 44;
2006-06-24 10:19:38.703 MSqlQuery: SELECT * FROM
record_tmp WHERE recordid = 44;2006-06-24 10:19:38.703
MSqlQuery: UPDATE record_tmp SET recordid = 44,
inactive = '0' WHERE recordid = 44;
2006-06-24 10:19:38.705 MSqlQuery: SELECT * FROM
record_tmp WHERE recordid = 44;2006-06-24 10:19:38.705
MSqlQuery: UPDATE record_tmp SET recordid = 44,
profile = 'Default' WHERE recordid = 44;
2006-06-24 10:19:38.707 MSqlQuery: SELECT * FROM
record_tmp WHERE recordid = 44;2006-06-24 10:19:38.708
MSqlQuery: UPDATE record_tmp SET recordid = 44,
recgroup = 'Default' WHERE recordid = 44;
2006-06-24 10:19:38.709 MSqlQuery: SELECT * FROM
record_tmp WHERE recordid = 44;2006-06-24 10:19:38.710
MSqlQuery: UPDATE record_tmp SET recordid = 44,
playgroup = 'Default' WHERE recordid = 44;
2006-06-24 10:19:38.726 MSqlQuery: SELECT * FROM
record_tmp WHERE recordid = 44;2006-06-24 10:19:38.727
MSqlQuery: UPDATE record_tmp SET recordid = 44,
autoexpire = '1' WHERE recordid = 44;
2006-06-24 10:19:38.728 MSqlQuery: SELECT * FROM
record_tmp WHERE recordid = 44;2006-06-24 10:19:38.729
MSqlQuery: UPDATE record_tmp SET recordid = 44,
maxepisodes = '0' WHERE recordid = 44;
2006-06-24 10:19:38.730 MSqlQuery: SELECT * FROM
record_tmp WHERE recordid = 44;2006-06-24 10:19:38.731
MSqlQuery: UPDATE record_tmp SET recordid = 44,
maxnewest = '0' WHERE recordid = 44;
2006-06-24 10:19:38.732 MSqlQuery: SELECT * FROM
record_tmp WHERE recordid = 44;2006-06-24 10:19:38.733
MSqlQuery: UPDATE record_tmp SET recordid = 44,
autocommflag = '1' WHERE recordid = 44;
2006-06-24 10:19:38.734 MSqlQuery: SELECT * FROM
record_tmp WHERE recordid = 44;2006-06-24 10:19:38.735
MSqlQuery: UPDATE record_tmp SET recordid = 44,
autotranscode = '0' WHERE recordid = 44;
2006-06-24 10:19:38.739 MSqlQuery: SELECT * FROM
record_tmp WHERE recordid = 44;2006-06-24 10:19:38.741
MSqlQuery: UPDATE record_tmp SET recordid = 44,
transcoder = '0' WHERE recordid = 44;
2006-06-24 10:19:38.742 MSqlQuery: SELECT * FROM
record_tmp WHERE recordid = 44;2006-06-24 10:19:38.743
MSqlQuery: UPDATE record_tmp SET recordid = 44,
autouserjob1 = '0' WHERE recordid = 44;
2006-06-24 10:19:38.744 MSqlQuery: SELECT * FROM
record_tmp WHERE recordid = 44;2006-06-24 10:19:38.745
MSqlQuery: UPDATE record_tmp SET recordid = 44,
autouserjob2 = '0' WHERE recordid = 44;
2006-06-24 10:19:38.747 MSqlQuery: SELECT * FROM
record_tmp WHERE recordid = 44;2006-06-24 10:19:38.747
MSqlQuery: UPDATE record_tmp SET recordid = 44,
autouserjob3 = '0' WHERE recordid = 44;
2006-06-24 10:19:38.749 MSqlQuery: SELECT * FROM
record_tmp WHERE recordid = 44;2006-06-24 10:19:38.750
MSqlQuery: UPDATE record_tmp SET recordid = 44,
autouserjob4 = '0' WHERE recordid = 44;
2006-06-24 10:19:39.922 MSqlQuery: SELECT
RELEASE_LOCK('DiffSchedule');
2006-06-24 10:19:40.315 MSqlQuery: SELECT icon FROM
channel WHERE chanid = '1026' ;
2006-06-24 10:19:40.326 MSqlQuery: SELECT icon FROM
channel WHERE chanid = '1026' ;
---end SQL output---

Hmmm, there's a whole lot of Selects and Updates going
on, record_tmp and record tables I guess that one of
the updates must have created the required row in a
table that had been deleted for some reason.  The big
question is why would the row have been deleted?  It
seems, possibly, to coincide with the 2 week program
schedule/guide data period... maybe.  Maybe not.

Ben

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 


More information about the mythtv-users mailing list