[mythtv-users] mythbackend not responding on port 6543
Stephen Worthington
stephen_agent at jsw.gen.nz
Thu Nov 17 15:39:43 UTC 2016
On Thu, 17 Nov 2016 06:24:11 -0800, you wrote:
>On Wed, Nov 16, 2016 at 10:11 PM, Stephen Worthington <
>stephen_agent at jsw.gen.nz> wrote:
>
>> On Wed, 16 Nov 2016 20:55:35 -0800, you wrote:
>>
>> >On Wed, Nov 16, 2016 at 6:59 PM, Stephen Worthington <
>> >stephen_agent at jsw.gen.nz> wrote:
>> >
>> >> On Tue, 15 Nov 2016 07:04:34 -0800, you wrote:
>> >>
>> >> >On Tue, Nov 15, 2016 at 5:41 AM, Stephen Worthington <
>> >> >stephen_agent at jsw.gen.nz> wrote:
>> >> >
>> >> >> On Tue, 15 Nov 2016 01:33:53 +1300, you wrote:
>> >> >>
>> >> >> The conclusion I reached from this is that the problem is related to
>> >> >> my database somehow, rather than the versions of any software I am
>> >> >> running. Something about my current database triggers the problem.
>> >> >>
>> >> >>
>> >> >It might be enlightening to do a dump and diff of the settings table
>> from
>> >> >your working vs. non-working backups.
>> >> >
>> >> >Karl
>> >>
>> >> Thanks for the idea. Doing it with database tables is a just a *bit*
>> >> more difficult than using the diff command, but I worked it out. So
>> >> can anyone see any problems in the diff? I can not.
>> >>
>> >> If you can not read it properly in your email program, I have also put
>> >> it in a file on my web server:
>> >>
>> >> http://www.jsw.gen.nz/mythtv/6543/settings_diff.txt
>> >>
>> >> MariaDB [mythconverg]> select hostname,value,data from (select
>> >> s.hostname,s.value,s.data from settings s union all select
>> >> o.hostname,o.value,o.data from settings_old o) t where hostname is
>> >> null or hostname='mypvr' group by hostname,value having count(*)=1
>> >> order by hostname,value;
>> [snip]
>> >I was thinking of something conceptually simpler, like doing a select on
>> >each settings table, dumping the results to a text file and then diff'ing
>> >the two files (an ORDER BY clause could help there). Since your statement
>> >is doing a union, it doesn't show the differences (if any).
>> >
>> >Karl
>>
>> Yes, it does show the differences. It is using a sneaky sql trick
>> from this page:
>>
>>
>> http://www.mysqltutorial.org/compare-two-tables-to-find-
>> unmatched-records-mysql.aspx
>>
>> Trying to do a text diff of tables is quite difficult, due to the
>> variable length of fields and the way the output table is formatted to
>> accommodate only the longest actual length of a field. You have to do
>> fixed length formatting on all fields to have a chance for a text diff
>> to work.
>>
>
>Ah, I forgot about variable column widths. The "union all" confused me. Is
>there any way to identify which row goes with which table? I wonder if you
>could add a constant to the select string such as:
>select hostname,value,data from (select "s1",s.hostname,s.value,s.data from
>settings s union all select "s2, o.hostname,o.value,o.data from
>settings_old o) t where hostname is null or hostname='mypvr' group by
>hostname,value having count(*)=1 order by hostname,value;
>
>Karl
You read my mind - I was just trying exactly that when your email
arrived. Unfortunately, it does not work:
MariaDB [mythconverg]> select hostname,value,data from (select
'settings',s.hostname,s.value,s.data from settings s union all select
'settings_old',o.hostname,o.value,o.data from settings_old o) t where
hostname is null or hostname='mypvr' group by hostname,value having
count(*)=1 order by hostname,value;
+----------+----------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------+
| hostname | value | data |
+----------+----------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------+
| NULL | BrowserDBSchemaVer | 1002 |
| NULL | Country | NZ |
| NULL | Language | en_GB |
| NULL | MovieGrabber | metadata/Movie/tmdb3.py |
| NULL | MusicStreamListModified | 2016-02-10T13:20:13Z |
| NULL | recommend_enabled | |
| NULL | recommend_key | REQUIRED |
| NULL | recommend_server | http://myth-recommendations.aws.af.cm/ |
| NULL | TelevisionGrabber | metadata/Television/ttvdb.py |
| mypvr | AllowLinkLocal | 1 |
| mypvr | AllowTagWriting | 1 |
| mypvr | DailyArtworkUpdates | 0 |
| mypvr | EventCmdLivetvStarted | /usr/local/bin/mythsgu event LivetvStarted |
| mypvr | EventCmdMasterShutdown | /usr/local/bin/mythsgu event MasterShutdown |
| mypvr | EventCmdMasterStarted | /usr/local/bin/mythsgu event MasterStarted |
| mypvr | EventCmdPlayPaused | /usr/local/bin/mythsgu event PlayPaused |
| mypvr | EventCmdPlayStarted | /usr/local/bin/mythsgu event PlayStarted |
| mypvr | EventCmdPlayStopped | /usr/local/bin/mythsgu event PlayStopped |
| mypvr | EventCmdPlayUnpaused | /usr/local/bin/mythsgu event PlayUnpaused |
| mypvr | EventCmdRecDeleted | /usr/local/bin/event_test.sh %HOSTNAME% %CHANID% %DIR% %FILE% %PROGSTARTISOUTC% %PROGENDISOUTC% %STARTTIMEISOUTC% %ENDTIMEISOUTC% %RECGROUP% %TITLE% |
| mypvr | EventCmdRecExpired | /usr/local/bin/mythsgu event RecExpired %FILE% |
| mypvr | EventCmdRecFinished | /usr/local/bin/mythsgu event RecFinished |
| mypvr | EventCmdRecPending | /usr/local/bin/mythsgu event RecPending |
| mypvr | EventCmdRecStarted | /usr/local/bin/mythsgu event RecStarted |
| mypvr | EventCmdSchedulerRan | /usr/local/bin/mythsgu event SchedulerRan |
| mypvr | GalleryDirCaption | 1 |
| mypvr | GalleryImageCaption | 1 |
| mypvr | JobAllowMetadata | 1 |
| mypvr | MusicJumpPointAction | stop |
| mypvr | MusicScannerLastRunEnd | 2016-07-24T14:24:01Z |
| mypvr | MusicScannerLastRunStart | 2016-07-24T14:24:01Z |
| mypvr | MusicScannerLastRunStatus | success - total tracks found: 118 (unchanged: 108, added: 10, removed: 0, updated 0) - total coverart found: 9 (unchanged: 1, added: 8, removed: 0, updated 0) |
| mypvr | mythgame.MetadataGrabber | |
| mypvr | mythvideo.folder_view_1 | 0 |
| mypvr | mythvideoDefaultBrowse | -1 |
| mypvr | mythvideoDefaultCast | -1 |
| mypvr | mythvideoDefaultCategory | -1 |
| mypvr | mythvideoDefaultCountry | -1 |
| mypvr | mythvideoDefaultCoverFile | -1 |
| mypvr | mythvideoDefaultFilter | ty9 - |
| mypvr | mythvideoDefaultGenre | -1 |
| mypvr | mythvideoDefaultInetRef | -1 |
| mypvr | mythvideoDefaultOrderby | 0 |
| mypvr | mythvideoDefaultRuntime | -2 |
| mypvr | mythvideoDefaultUserrating | -1 |
| mypvr | mythvideoDefaultWatched | -1 |
| mypvr | mythvideoDefaultYear | -1 |
| mypvr | ResumeModeEditor | 0 |
| mypvr | ResumeModePlayback | 3 |
| mypvr | ResumeModeRadio | 2 |
+----------+----------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------+
50 rows in set (0.04 sec)
I need to read up on how unions work and see if there a way to make it
work.
More information about the mythtv-users
mailing list