Rebuilding schedulesdirect mysql DB?

Rebuilding schedulesdirect mysql DB?

Postby jimyth » Sun Jan 18, 2015 11:10 pm

I used mythtv_backup and restore to move to a new machine but mfdb-json apparently uses a separate database which I didn't dump before migration. I still have the DB files but I don't know how to restore it.

What's the best method of rebuilding or recreating the DB so the mfdb-json grabber works correctly again?

the utility gives me the following
The following lineups are in your account at Schedules Direct:

ââââââââ¬âââââââââââââââââââââ¬âââââââââââââââââââââ¬ââââââââââââââââââââââââââ¬ââââââââ
âNumberâLineup âServer modified âMythTV videosource updateâStatus â
ââââââââ¼âââââââââââââââââââââ¼âââââââââââââââââââââ¼ââââââââââââââââââââââââââ¼ââââââââ¤
â1 âCAN-0009356-DEFAULT â2015-01-16T21:51:41Zâ2015-01-16T21:51:41Z â â
ââââââââ¼âââââââââââââââââââââ¼âââââââââââââââââââââ¼ââââââââââââââââââââââââââ¼ââââââââ¤
â2 âCAN-0009356-X â2015-01-17T14:04:14Zâ2015-01-17T14:04:14Z â â
ââââââââ¼âââââââââââââââââââââ¼âââââââââââââââââââââ¼ââââââââââââââââââââââââââ¼ââââââââ¤
â3 âCAN-OTA-V5S2N4 â2015-01-16T21:51:50Zâ2015-01-16T21:51:50Z â â
ââââââââ´âââââââââââââââââââââ´âââââââââââââââââââââ´ââââââââââââââââââââââââââ´ââââââââ

MythTV local videosources:
sourceid: 5 name: Air Schedules Direct lineup: CAN-OTA-V5S2N4
sourceid: 6 name: Shaw Schedules Direct lineup: CAN-0009356-DEFAULT
sourceid: 7 name: Digital Schedules Direct lineup: CAN-0009356-X

but mfdb-json run aborts with
2015-01-19 01:10:43:1000 / 1261
2015-01-19 01:10:43:1100 / 1261
2015-01-19 01:10:43:1200 / 1261
2015-01-19 01:10:43:Completed local database program updates.
2015-01-19 01:10:43:Inserting schedules.
2015-01-19 01:10:46:Fatal error in insertSchedules:No stationID:

I've tried link and update functions in the utility but it doesn't seem to help.
jimyth
 
Posts: 3
Joined: Tue Oct 28, 2014 8:09 pm

Re: Rebuilding schedulesdirect mysql DB?

Postby rkulagow » Mon Jan 19, 2015 9:11 am

I believe that error is actually due to an upstream issue that we're having right now that's corrupting the data. I'm looking into it.
rkulagow
SD Staff
 
Posts: 911
Joined: Tue Aug 14, 2007 3:15 pm

Re: Rebuilding schedulesdirect mysql DB?

Postby jimyth » Mon Jan 19, 2015 10:52 am

I completely removed the sources and lineups and re-added them.


After that when I run the mfdb-json I get a number of "Adding 70817 to retry queue. Count is 1"
The count never increases although the code is supposed to abort after 10 tries.
Looks like line 454 resets it everytime.
$addToRetryQueue = array(); // Otherwise we may never exit.

Are the upstream problems also causing that?

Here's the log with all the retry stationIDs the never complete.
2015-01-19 17:26:36:Retrying schedule fetch for the following:
2015-01-19 17:26:36:StationID: 70817
2015-01-19 17:26:36:StationID: 70815
2015-01-19 17:26:36:StationID: 70975
2015-01-19 17:26:36:StationID: 70989
2015-01-19 17:26:36:StationID: 70992
2015-01-19 17:26:36:StationID: 70993
2015-01-19 17:26:36:StationID: 70986
2015-01-19 17:26:36:StationID: 70814
2015-01-19 17:26:36:StationID: 71150
2015-01-19 17:26:36:StationID: 71151
2015-01-19 17:26:36:StationID: 71208
2015-01-19 17:26:36:StationID: 71209
2015-01-19 17:26:36:StationID: 71205
2015-01-19 17:26:36:StationID: 71218
2015-01-19 17:26:36:StationID: 71219
2015-01-19 17:26:36:StationID: 71221
2015-01-19 17:26:36:StationID: 71216
2015-01-19 17:26:36:StationID: 74289
2015-01-19 17:26:36:StationID: 74292
2015-01-19 17:26:36:StationID: 74408
2015-01-19 17:26:36:StationID: 71144
2015-01-19 17:26:36:StationID: 71149
2015-01-19 17:26:36:StationID: 71130
2015-01-19 17:26:36:StationID: 71131
2015-01-19 17:26:36:StationID: 71143
2015-01-19 17:26:36:StationID: 71115
2015-01-19 17:26:36:StationID: 71210
2015-01-19 17:26:36:StationID: 71117
2015-01-19 17:26:36:StationID: 71212
2015-01-19 17:26:36:StationID: 71119
2015-01-19 17:26:36:StationID: 71127
2015-01-19 17:26:36:StationID: 71128
2015-01-19 17:26:36:StationID: 71040
2015-01-19 17:26:36:StationID: 71036
2015-01-19 17:26:36:StationID: 71037
2015-01-19 17:26:36:StationID: 71039
2015-01-19 17:26:36:StationID: 71035
2015-01-19 17:26:36:StationID: 71053
2015-01-19 17:26:36:StationID: 71052
2015-01-19 17:26:36:StationID: 71030
2015-01-19 17:26:36:StationID: 71031
2015-01-19 17:26:36:StationID: 71032
2015-01-19 17:26:36:StationID: 71027
2015-01-19 17:26:36:StationID: 71025
2015-01-19 17:26:36:StationID: 71026
2015-01-19 17:26:36:StationID: 70984
2015-01-19 17:26:36:StationID: 70983
2015-01-19 17:26:36:StationID: 70981
2015-01-19 17:26:36:StationID: 70979
2015-01-19 17:26:36:StationID: 70987
2015-01-19 17:26:36:StationID: 70818
2015-01-19 17:26:36:StationID: 70819
2015-01-19 17:26:36:StationID: 70824
2015-01-19 17:26:36:StationID: 70811
2015-01-19 17:26:36:StationID: 70812
2015-01-19 17:26:36:StationID: 70813
2015-01-19 17:26:36:StationID: 66284
2015-01-19 17:26:36:StationID: 80598
2015-01-19 17:26:36:StationID: 81496
2015-01-19 17:26:36:StationID: 20724
2015-01-19 17:26:36:StationID: 20723
2015-01-19 17:26:36:StationID: 90133
2015-01-19 17:26:36:StationID: 90135
2015-01-19 17:26:36:StationID: 89262
2015-01-19 17:26:36:StationID: 14781
2015-01-19 17:26:36:65 schedules to download.
2015-01-19 17:26:38:Writing to /tmp/mfdb_schedules_8gSGgT/schedule.json
2015-01-19 17:26:38:Parsing schedule for stationID:53711
2015-01-19 17:26:38:Parsing schedule for stationID:19134
2015-01-19 17:26:38:Parsing schedule for stationID:19521
2015-01-19 17:26:38:Parsing schedule for stationID:75473
2015-01-19 17:26:38:Parsing schedule for stationID:56194
2015-01-19 17:26:38:Adding 70817 to retry queue. Count is 1
...
jimyth
 
Posts: 3
Joined: Tue Oct 28, 2014 8:09 pm

Re: Rebuilding schedulesdirect mysql DB?

Postby rkulagow » Mon Jan 19, 2015 12:35 pm

Two separate issues. The data should now be available. The retry loop issue is something that I'll need to fix.
rkulagow
SD Staff
 
Posts: 911
Joined: Tue Aug 14, 2007 3:15 pm


Return to Developer

Who is online

Users browsing this forum: No registered users and 6 guests

cron