[mythtv-users] Scheduled recordings disappearing

[Scott Minneman]

I'm not sure where the mythfilldatabase log is, but the mythbackend log 
has this for every grab that mythfilldatabase does:

Retrieving datadirect data...
Grabbing data for Sat Mar 5 2005 offset 13
 From : Fri Mar 18 05:00:00 2005 To : Sat Mar 19 05:00:00 2005 (UTC)
Your subscription expires on 05/20/05 05:19:53
Grab complete.  Actual data from Fri Mar 18 05:00:00 2005 to Fri Mar 18 
23:59:59 2005 (UTC)
Clearing data for source...
Clearing from Fri Mar 18 00:00:00 2005 to Fri Mar 18 18:59:59 2005 
(localtime)
Data for source cleared...
Main temp tables populated.  Updating myth channels...
Updating icons for sourceid: 1
Channels updated..  Updating programs...
Adjusting program database end times...
0 replacements made.
Marking repeats...found 4486
Unmarking repeats from grabber that fall within our new episode 
window...found 11
2005-03-05 02:10:34.636 Connecting to backend server: 192.168.0.110:6543 
(try 1 of 5)
2005-03-05 02:10:34.646 Using protocol version 14
DB Error (UpdateMatches):
Query was:
INSERT INTO recordmatch (recordid, chanid, starttime) SELECT 
record.recordid, program.chanid, prog$
AND program.subtitle REGEXP "(Orioles|Nationals|)"
 AND ((record.type = 4 OR record.type = 6 OR record.type = 9 OR 
record.type = 10)  OR  ((record.st$
Driver error was [2/1139]:
QMYSQL3: Unable to execute query
Database error was:
Got error 'empty (sub)expression' from regexp

And sure enough, my entire Scheduled Recordings screen was cleared out.  
Not only the baseball games are cleared out -- everything is, even the 
shows that I manually set using "Record only this showing."

Here's the output of the mysql query:

*************************** 1. row ***************************
       type: 4
      title: MLB%Baseball:Orioles:::: (Power Search)
description: AND program.title LIKE "%MLB%Baseball%" AND 
program.subtitle LIKE "%Orioles%"
*************************** 2. row ***************************
       type: 4
      title: MLB (Power Search)
description: AND program.title LIKE "MLB%Baseball"
AND program.subtitle REGEXP "(Orioles|Nationals|)"

*************************** 3. row ***************************
       type: 4
      title: MLB%Baseball:Nationals:::: (Power Search)
description: AND program.title LIKE "%MLB%Baseball%" AND 
program.subtitle LIKE "%Nationals%"
*************************** 4. row ***************************
       type: 4
      title: South Park::::: (Power Search)
description: AND program.title LIKE "%South Park%"
4 rows in set (0.00 sec)

(Note:  I notice that I have duplicative rules.  If you can tell me how 
to delete number 2, I'd be most grateful -- I don't know the first thing 
about mysql commands.)

Scott



Bruce Markey wrote:

> Scott Minneman wrote:
>
>> That's the method I used to set it up.  I followed all of those 
>> instructions exactly, and it works for the rest of that day, but 
>> clears out after that.
>>
>> I run mythfilldatabase at night, so I think that's the culprit.  Not 
>> running mythdatabase, however, is obviously not an option.  I could 
>> reduce its run frequency, but resetting my search rules once a week 
>> is only marginally less of a hassle than resetting them once a day.
>
>
> You shouldn't have to reset the rules. If the schedule is correct
> when add a search rule it should be okay any other time the
> scheduler runs. The logs for mythfilldatabase and the master backend
> should have clues if something went wrong. Look for error messages
> and also check for the lines that say how many items where scheduled.
>
> 2005-03-04 06:41:59.496 Reschedule requested for id -1.
> 2005-03-04 06:42:05.502 Scheduled 378 items in 3.9 = 2.98 match + 0.88 
> place
>
> If it had items before but then zero when mythfilldatabase runs,
> that would be a problem. Also, you can try running mythfilldatabase
> from the command line to see if that causes a problem.
>
> So, was the schedule okay after you first set the rule? Is the
> schedule okay when you restart the master backend? When the schedule
> is blank, does running "mythbackend --resched" from another shell
> fix the problem? If this does happen when mythfilldatabase runs, is
> there show information in the Program Guide?
>
> If it does seem to be related to having search rules, could you sent
> the output of:
>
> $ mysql -u mythtv -pmythtv mythconverg
> mysql> select type,title,description from record where search=1\G
>
> --  bjm
>
>------------------------------------------------------------------------
>
>_______________________________________________
>mythtv-users mailing list
>mythtv-users at mythtv.org
>http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>  
>

-- 

Scott Minneman
J.D. Candidate, 2007
The George Washington University Law School