Empty schedule when installing SVN MythTV
- user warning: Table './drupal_gding/cache_filter' is marked as crashed and should be repaired
query: SELECT data, created, headers, expire, serialized FROM cache_filter WHERE cid = '1:8f5686aa9ca6009b785606653dcf5bee' in /var/www/mythdora/html/includes/cache.inc on line 26.
- user warning: Table './drupal_gding/cache_filter' is marked as crashed and should be repaired
query: UPDATE cache_filter SET data = '<p>Hi,</p>\n<p>I installed MythDora 4.0 a few weeks ago and got it working in no time. Now, I\'d like to use the latest SVN MythTV, so I followed the instructions in the <a href=\"http://www.mythtv.org/wiki/index.php/Installing_MythTV_SVN_on_Fedora_Core\">MythTV wiki</a> and managed to install the MythTV 0.21 to a point where everything works (live TV, live recording, play old recordings) except scheduling.</p>\n<p>In MythWeb, I can see my Recording Schedules but the Upcoming Recordings is always empty. mythbackend --printsched always prints an empty list while mythbackend --testsched always prints a good list (see example below).</p>\n<p>I removed the \"old\" MythTV with:<br />\n<code><br />\nrpm -qa | grep myth | xargs rpm -e<br />\nrm -rf /lib/myth* /lib/libmyth* /include/mythtv /bin/myth* /share/mythtv\"<br />\n</code></p>\n<p>I\'m wondering if there\'s anything specific to MythDora that might be causing this problem, since I\'ve <a href=\"http://www.gossamer-threads.com/lists/mythtv/users/295670\">already asked on MythTV-Users</a> but couldn\'t find a solution.</p>\n<p>Thanks a lot,<br />\nGFK\'s</p>\n<p>[mythtv@pvr ~]$ mythbackend --resched<br />\n2007-10-15 16:27:42.570 Using runtime prefix = /usr/local<br />\n2007-10-15 16:27:42.704 New DB connection, total: 1<br />\n2007-10-15 16:27:42.714 Connected to database \'mythconverg\' at host: localhost<br />\n2007-10-15 16:27:42.731 Current Schema Version: 1160<br />\n2007-10-15 16:27:42.749 Connecting to backend server: 127.0.0.1:6543 (try 1 of 5)<br />\n2007-10-15 16:27:42.751 Using protocol version 31<br />\n2007-10-15 16:27:42.797 Connected to master for reschedule<br />\n[mythtv@pvr ~]$ mythbackend --printsched<br />\n2007-10-15 16:27:48.824 Using runtime prefix = /usr/local<br />\n2007-10-15 16:27:48.852 New DB connection, total: 1<br />\n2007-10-15 16:27:48.863 Connected to database \'mythconverg\' at host: localhost<br />\n2007-10-15 16:27:48.870 Current Schema Version: 1160<br />\n2007-10-15 16:27:48.875 New DB DataDirect connection<br />\n2007-10-15 16:27:48.876 Connected to database \'mythconverg\' at host: localhost<br />\n2007-10-15 16:27:48.913 Connecting to backend server: 127.0.0.1:6543 (try 1 of 5)<br />\n2007-10-15 16:27:48.915 Using protocol version 31<br />\nRetrieving Schedule from Master backend.<br />\n--- print list start ---<br />\nTitle - Subtitle Chan ChID Day Start End C I T N<br />\n--- print list end ---<br />\n[mythtv@pvr ~]$ mythbackend --testsched<br />\n2007-10-15 16:27:55.605 Using runtime prefix = /usr/local<br />\n2007-10-15 16:27:55.633 New DB connection, total: 1<br />\n2007-10-15 16:27:55.643 Connected to database \'mythconverg\' at host: localhost<br />\n2007-10-15 16:27:55.650 Current Schema Version: 1160<br />\n2007-10-15 16:27:55.654 New DB DataDirect connection<br />\n2007-10-15 16:27:55.655 Connected to database \'mythconverg\' at host: localhost<br />\nCalculating Schedule from database.<br />\nInputs, Card IDs, and Conflict info may be invalid if you have multiple tuners.<br />\n2007-10-15 16:27:59.576 Speculative scheduled 138 items in 3.90<br />\n--- print list start ---<br />\nTitle - Subtitle Chan ChID Day Start End C I T N<br />\nCops 204 1204 15 19:00-19:30 1 1 A 1<br />\nCops 204 1204 15 19:30-20:00 1 1 A 1<br />\n[...]<br />\n--- print list end ---</p>\n', created = 1368960835, expire = 1369047235, headers = '', serialized = 0 WHERE cid = '1:8f5686aa9ca6009b785606653dcf5bee' in /var/www/mythdora/html/includes/cache.inc on line 109.
- user warning: Table './drupal_gding/cache_filter' is marked as crashed and should be repaired
query: SELECT data, created, headers, expire, serialized FROM cache_filter WHERE cid = '1:8e8ad1262a6d567faa01c021d500f76e' in /var/www/mythdora/html/includes/cache.inc on line 26.
- user warning: Table './drupal_gding/cache_filter' is marked as crashed and should be repaired
query: UPDATE cache_filter SET data = '<p>Holy cow! After so many attempts at making this work, I checked out SVN on my dev PC and inserted some debugging infos. It didn\'t took too long to figure out that m_sched==0, which lead me to find out that mythbackend was \"Running as a slave backend.\"</p>\n<p>Searching the code for this message, I found out that this was caused by (masterip == myip) being false (programs/mythbackend/main.cpp line 567). All this caused by the fact that on the first page of the \"General\" settings of mythtv-setup I have set \"IP address for pvr\" to 10.10.16.5 and Master Server IP address to 127.0.0.1.</p>\n<p>Of course, all of this would have been avoided if I had read the help text in the page that says that I must use the same IPs in both fields. But I\'m way too smart to do that...</p>\n<p>Anyway, all is working fine now. It might be a good idea to print a warning when (masterip != myip) and (masterip == \"127.0.0.1\") because I think that this is never valid.</p>\n<p>Cheers,<br />\nGFK\'s</p>\n', created = 1368960835, expire = 1369047235, headers = '', serialized = 0 WHERE cid = '1:8e8ad1262a6d567faa01c021d500f76e' in /var/www/mythdora/html/includes/cache.inc on line 109.
- user warning: Table './drupal_gding/cache_filter' is marked as crashed and should be repaired
query: SELECT data, created, headers, expire, serialized FROM cache_filter WHERE cid = '1:50d6119d27e3c5aba865d21f36299ea1' in /var/www/mythdora/html/includes/cache.inc on line 26.
- user warning: Table './drupal_gding/cache_filter' is marked as crashed and should be repaired
query: UPDATE cache_filter SET data = '<p>Guillaume Filion<br />\n<a href=\"http://guillaume.filion.org/\">http://guillaume.filion.org/</a></p>\n', created = 1368960835, expire = 1369047235, headers = '', serialized = 0 WHERE cid = '1:50d6119d27e3c5aba865d21f36299ea1' in /var/www/mythdora/html/includes/cache.inc on line 109.
Submitted by gfk on October 15, 2007 - 5:16pm
Hi,
I installed MythDora 4.0 a few weeks ago and got it working in no time. Now, I'd like to use the latest SVN MythTV, so I followed the instructions in the MythTV wiki and managed to install the MythTV 0.21 to a point where everything works (live TV, live recording, play old recordings) except scheduling.
In MythWeb, I can see my Recording Schedules but the Upcoming Recordings is always empty. mythbackend --printsched always prints an empty list while mythbackend --testsched always prints a good list (see example below).
I removed the "old" MythTV with:
rpm -qa | grep myth | xargs rpm -e
rm -rf /lib/myth* /lib/libmyth* /include/mythtv /bin/myth* /share/mythtv"
I'm wondering if there's anything specific to MythDora that might be causing this problem, since I've already asked on MythTV-Users but couldn't find a solution.
Thanks a lot,
GFK's
[mythtv@pvr ~]$ mythbackend --resched
2007-10-15 16:27:42.570 Using runtime prefix = /usr/local
2007-10-15 16:27:42.704 New DB connection, total: 1
2007-10-15 16:27:42.714 Connected to database 'mythconverg' at host: localhost
2007-10-15 16:27:42.731 Current Schema Version: 1160
2007-10-15 16:27:42.749 Connecting to backend server: 127.0.0.1:6543 (try 1 of 5)
2007-10-15 16:27:42.751 Using protocol version 31
2007-10-15 16:27:42.797 Connected to master for reschedule
[mythtv@pvr ~]$ mythbackend --printsched
2007-10-15 16:27:48.824 Using runtime prefix = /usr/local
2007-10-15 16:27:48.852 New DB connection, total: 1
2007-10-15 16:27:48.863 Connected to database 'mythconverg' at host: localhost
2007-10-15 16:27:48.870 Current Schema Version: 1160
2007-10-15 16:27:48.875 New DB DataDirect connection
2007-10-15 16:27:48.876 Connected to database 'mythconverg' at host: localhost
2007-10-15 16:27:48.913 Connecting to backend server: 127.0.0.1:6543 (try 1 of 5)
2007-10-15 16:27:48.915 Using protocol version 31
Retrieving Schedule from Master backend.
--- print list start ---
Title - Subtitle Chan ChID Day Start End C I T N
--- print list end ---
[mythtv@pvr ~]$ mythbackend --testsched
2007-10-15 16:27:55.605 Using runtime prefix = /usr/local
2007-10-15 16:27:55.633 New DB connection, total: 1
2007-10-15 16:27:55.643 Connected to database 'mythconverg' at host: localhost
2007-10-15 16:27:55.650 Current Schema Version: 1160
2007-10-15 16:27:55.654 New DB DataDirect connection
2007-10-15 16:27:55.655 Connected to database 'mythconverg' at host: localhost
Calculating Schedule from database.
Inputs, Card IDs, and Conflict info may be invalid if you have multiple tuners.
2007-10-15 16:27:59.576 Speculative scheduled 138 items in 3.90
--- print list start ---
Title - Subtitle Chan ChID Day Start End C I T N
Cops 204 1204 15 19:00-19:30 1 1 A 1
Cops 204 1204 15 19:30-20:00 1 1 A 1
[...]
--- print list end ---
|
Solution! At last!
Holy cow! After so many attempts at making this work, I checked out SVN on my dev PC and inserted some debugging infos. It didn't took too long to figure out that m_sched==0, which lead me to find out that mythbackend was "Running as a slave backend."
Searching the code for this message, I found out that this was caused by (masterip == myip) being false (programs/mythbackend/main.cpp line 567). All this caused by the fact that on the first page of the "General" settings of mythtv-setup I have set "IP address for pvr" to 10.10.16.5 and Master Server IP address to 127.0.0.1.
Of course, all of this would have been avoided if I had read the help text in the page that says that I must use the same IPs in both fields. But I'm way too smart to do that...
Anyway, all is working fine now. It might be a good idea to print a warning when (masterip != myip) and (masterip == "127.0.0.1") because I think that this is never valid.
Cheers,
GFK's
Guillaume Filion
http://guillaume.filion.org/