{"id":4745,"date":"2021-04-10T14:21:43","date_gmt":"2021-04-10T02:21:43","guid":{"rendered":"https:\/\/www.zoyinc.com\/?p=4745"},"modified":"2024-01-04T19:30:50","modified_gmt":"2024-01-04T06:30:50","slug":"mythtv-add-on-for-kodi-hangs-at-0","status":"publish","type":"post","link":"http:\/\/www.zoyinc.com\/?p=4745","title":{"rendered":"MythTV add-on for Kodi hangs at 0%"},"content":{"rendered":"\n<p>Around about the 26\/3\/2021 the Windows 10 MythTV add-on for Kodi stopped working. I had seen similar problem before, <a  href=\"https:\/\/www.zoyinc.com\/?p=4359\" data-type=\"post\" data-id=\"4359\">Kodi MythTV addon fails to load<\/a> except this time it didn&#8217;t load at all whereas previously it was stuck loading at around 40%.<\/p>\n\n\n\n<p>This time around it didn&#8217;t seem to connect to the MythTV server at all. When I tried to look at recordings, channels or recordings it just showed &#8220;PVR manager is starting up: 0%&#8221; with the spinning wheel to the right. It didn&#8217;t matter how long you waited it didn&#8217;t change.<\/p>\n\n\n\n<p>Looking in the Kodi log, with extra add-on debugging, there was no indication of what was wrong.<\/p>\n\n\n\n<p>This whole time MythTV server worked fine. It recorded programs fine, I could watch recordings from MythWeb. I could connect fine from Kodi on my Android phone, I could even run Myth front end, from the MythTV server, without any problems.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1053\" height=\"705\" src=\"https:\/\/www.zoyinc.com\/wp-content\/uploads\/2021\/04\/KodiMythTVAddonFailsLoad02.jpg\" alt=\"\" class=\"wp-image-4747\" style=\"width:558px;height:373px\" srcset=\"http:\/\/www.zoyinc.com\/wp-content\/uploads\/2021\/04\/KodiMythTVAddonFailsLoad02.jpg 1053w, http:\/\/www.zoyinc.com\/wp-content\/uploads\/2021\/04\/KodiMythTVAddonFailsLoad02-300x201.jpg 300w, http:\/\/www.zoyinc.com\/wp-content\/uploads\/2021\/04\/KodiMythTVAddonFailsLoad02-150x100.jpg 150w, http:\/\/www.zoyinc.com\/wp-content\/uploads\/2021\/04\/KodiMythTVAddonFailsLoad02-768x514.jpg 768w, http:\/\/www.zoyinc.com\/wp-content\/uploads\/2021\/04\/KodiMythTVAddonFailsLoad02-448x300.jpg 448w\" sizes=\"auto, (max-width: 1053px) 100vw, 1053px\" \/><\/figure>\n\n\n\n<h1 class=\"wp-block-heading\">My MythTV setup<\/h1>\n\n\n\n<p>My setup is described in <a  href=\"https:\/\/www.zoyinc.com\/?p=3885\" data-type=\"post\" data-id=\"3885\">MythTV on CentOS 7<\/a> with the infrastructure looking like:<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1181\" height=\"781\" src=\"http:\/\/www.zoyinc.com\/wp-content\/uploads\/2020\/05\/PortBasedVLANToESX04.jpg\" alt=\"\" class=\"wp-image-4229\" style=\"width:467px;height:308px\" srcset=\"http:\/\/www.zoyinc.com\/wp-content\/uploads\/2020\/05\/PortBasedVLANToESX04.jpg 1181w, http:\/\/www.zoyinc.com\/wp-content\/uploads\/2020\/05\/PortBasedVLANToESX04-150x99.jpg 150w, http:\/\/www.zoyinc.com\/wp-content\/uploads\/2020\/05\/PortBasedVLANToESX04-300x198.jpg 300w, http:\/\/www.zoyinc.com\/wp-content\/uploads\/2020\/05\/PortBasedVLANToESX04-768x508.jpg 768w, http:\/\/www.zoyinc.com\/wp-content\/uploads\/2020\/05\/PortBasedVLANToESX04-454x300.jpg 454w\" sizes=\"auto, (max-width: 1181px) 100vw, 1181px\" \/><\/figure>\n\n\n\n<h1 class=\"wp-block-heading\">Problem dates<\/h1>\n\n\n\n<p>24\/10\/2022<\/p>\n\n\n\n<p>First noticed when Shortland street latest episodes were missing. Did a restart and then MythTV didn&#8217;t even connect or at least TV didn&#8217;t show<\/p>\n\n\n\n<p>25\/03\/2022<\/p>\n\n\n\n<p>First noticed issues in the evening. I know it wasn&#8217;t a problem the night before. I did a restart of the backend MythTV server and the error persisted and I restarted the managed network switch and again the error persisted. I note that daylight savings is on 3\/4\/2022 at 3am. The recordings showing in listings ends on 1\/4\/2022 so not sure that matters &#8211; but worth noting. The fun begins &#8230;<\/p>\n\n\n\n<h1 class=\"wp-block-heading\">Diagnostics<\/h1>\n\n\n\n<p>I looked at my notes from the previous similar error and tried the ideas from it, but it didn&#8217;t make any difference. <\/p>\n\n\n\n<p>I have a daily backup of MythTV, including the database and file system. However because of my workload at work I didn&#8217;t get to look at the issue until over a week after the problem occurred so I didn&#8217;t have a backup just prior to the problem happening so I had to go back to my next most recent backup on 7\/6\/2020 &#8211; nearly a year old.<\/p>\n\n\n\n<p>Rolling back the DB nearly a year resolved the problem &#8211; fantastic. <\/p>\n\n\n\n<p>Next I went to a backup just prior to the problems, this was dated 30\/March\/2021. This also worked correctly. So clearly something happened in the DB between the 30th and now.<\/p>\n\n\n\n<p>It was great the earlier backups worked, but it didn&#8217;t explain the problem and didn&#8217;t give me any clues about what to do if it came up again or what to do to prevent it. Not to mention I would have lost a years recordings.<\/p>\n\n\n\n<p>I tried the following, individually, but none of them made any difference:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Cold start of SonicWall<\/li>\n\n\n\n<li>Cold start of ESXi host<\/li>\n\n\n\n<li>Stop Start of VM &#8211; as part of cold restart of ESX<\/li>\n\n\n\n<li>Cold restart of NetGear managed switch<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Kodi versions<\/h3>\n\n\n\n<p>Kodi 17, kodi-17.6-Krypton-x86.exe, which is 32 bit, works. However it doesn&#8217;t show existing recordings but live TV and recorded live TV work.<\/p>\n\n\n\n<p>Kodi 18 and 19 do not work. Kodi 18.6 32bit also doesn&#8217;t work.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Workaround<\/h2>\n\n\n\n<p>Before you start you should <strong>ensure you have a backup strategy<\/strong>. The below steps should not cause long term impacts if you keep to the tables and steps listed. However it is wise to have a backup plan anyways. For myself a backup of the VM is the easiest and most full proof back &#8211; part of this is because my DB is stored on the VM. Thus a VM backup captures everything except the recording files..<\/p>\n\n\n\n<p>It is also advisable, when testing this to do it at a time where you don&#8217;t have any critical recordings. If you need to go back to your backup you will need to remove any recordings that were made after the backup. Recordings made after the backup can easily be deleted using Windows explorer and simply deleting based on date\/time.<\/p>\n\n\n\n<p>First find out the time period where the problem is. In my case it was after the 1\/4\/2022<\/p>\n\n\n\n<p>Stop MythTV backend<\/p>\n\n\n\n<p>Stop Kodi and ensure that there aren&#8217;t any kodi.exe processes running. Use Windows task manager.<\/p>\n\n\n\n<p>Next delete only the epg file for Kodi. In my case this file was:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">C:\\Users\\Tony\\AppData\\Roaming\\Kodi\\userdata\\Database\\Epg12.db<\/pre>\n\n\n\n<p>My EPG file was &#8220;Epg12.db&#8221;, but you could find it has a different number like Epg13.db &#8211; you should delete whichever one you have. Kodi only uses one EPG file, it doesn&#8217;t work on multiples.<\/p>\n\n\n\n<p>Run the below SQL. In my case I use DBeaver for my MariaDB work, but you could use the command line mysql, your choice,<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:0.9rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#000000;--cbp-line-number-width:calc(1 * 0.6 * 0.9rem);line-height:1.4rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span role=\"button\" tabindex=\"0\" data-code=\"delete from mythconverg.program\nwhere starttime &gt; '2022-04-01 00:00:00'\nand starttime &lt; '2022-04-05 00:00:00';\ncommit;\" style=\"color:#000000;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki light-plus\" style=\"background-color: #FFFFFF\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #000000\">delete <\/span><span style=\"color: #A31515\">from<\/span><span style=\"color: #000000\"> <\/span><span style=\"color: #A31515\">mythconverg.program<\/span><\/span>\n<span class=\"line\"><span style=\"color: #000000\">where <\/span><span style=\"color: #A31515\">starttime<\/span><span style=\"color: #000000\"> &gt; <\/span><span style=\"color: #A31515\">&#39;2022-04-01 00:00:00&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #000000\">and <\/span><span style=\"color: #A31515\">starttime<\/span><span style=\"color: #000000\"> &lt; <\/span><span style=\"color: #A31515\">&#39;2022-04-05 00:00:00&#39;<\/span><span style=\"color: #000000\">;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #000000\">commit;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p>I had this problem on 24\/10\/2022 and was trying the workaround on 28\/10\/22. I found I needed to use the following query instead:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:0.9rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#000000;--cbp-line-number-width:calc(1 * 0.6 * 0.9rem);line-height:1.4rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span role=\"button\" tabindex=\"0\" data-code=\"delete from mythconverg.program\nwhere starttime &gt; '2022-10-24 00:00:00';\ncommit;\" style=\"color:#000000;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki light-plus\" style=\"background-color: #FFFFFF\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #000000\">delete <\/span><span style=\"color: #A31515\">from<\/span><span style=\"color: #000000\"> <\/span><span style=\"color: #A31515\">mythconverg.program<\/span><\/span>\n<span class=\"line\"><span style=\"color: #000000\">where <\/span><span style=\"color: #A31515\">starttime<\/span><span style=\"color: #000000\"> &gt; <\/span><span style=\"color: #A31515\">&#39;2022-10-24 00:00:00&#39;<\/span><span style=\"color: #000000\">;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #000000\">commit;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p>Restart MythTV backend and wait until MythWeb is working and you can see listings &#8211; this proves the backend is running.<\/p>\n\n\n\n<p>Start up Kodi &#8211; Do not use Live TV mode this may well break it again.<\/p>\n\n\n\n<h1 class=\"wp-block-heading\">Problems 25\/20\/2021<\/h1>\n\n\n\n<p>The problem has happened again but this time I have a good backup from 25\/9\/21 so a month ago.<\/p>\n\n\n\n<p>The problem happens for me in the Lounge were I have made no changes to Kodi and on my PC where I have been mucking about with Kodi. On my desktop I tried the latest Kodi, 19.3 and also 18.9. All did the same thing and hung at 0%<\/p>\n\n\n\n<p>So I unplugged my HDHR tuners from the network so they wouldn&#8217;t update EPG. Then I rolled back to the VM and DB of 25\/9\/21. When I started the old VM Kodi connected straight away. Then I installed Kodi 19.3 and it also worked. They found old recordings &#8211; I only testing playing recordings with one version of Kodi but it did work.<\/p>\n\n\n\n<p>Then I plugged in the HDHR tuners to the network and restarted the VM. Kodi now hangs at 0% when you go into &#8220;TV&#8221;. Additionally it won&#8217;t shutdown, just &#8220;Not responding&#8221; when you try to shutdown.<\/p>\n\n\n\n<p>Next steps, stop the mythbackend, disconnect the HDHR tuners from the network. Restarted mythbackend and tried to connect with Kodi, but again it hung at 0% and would not shutdown. Then I stopped mythbackend and truncated the EPG data by running:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:0.9rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#000000;--cbp-line-number-width:calc(1 * 0.6 * 0.9rem);line-height:1.4rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span role=\"button\" tabindex=\"0\" data-code=\"truncate table program;\" style=\"color:#000000;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki light-plus\" style=\"background-color: #FFFFFF\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #000000\">truncate <\/span><span style=\"color: #A31515\">table<\/span><span style=\"color: #000000\"> <\/span><span style=\"color: #A31515\">program<\/span><span style=\"color: #000000\">;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p>I then restarted mythbackend. I was able to instantly go to TV recordings and play one and also it shutdown nice and normally, without hanging. This was with Kodi 19.3<\/p>\n\n\n\n<p>Then I shutdown the VM, plugged in the HDHRs and restarted the VM. I was able to login and watch live TV and then it filled up the EPG listings<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Learnings<\/h2>\n\n\n\n<p>Its not just one channel that is the problem. If I run, then Kodi works fine:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:0.9rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#000000;--cbp-line-number-width:calc(1 * 0.6 * 0.9rem);line-height:1.4rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span role=\"button\" tabindex=\"0\" data-code=\"delete from mythconverg.program\nwhere starttime &gt; '2021-11-01 09:30:00'\nand starttime &lt; '2021-11-02 00:00:00'\nand chanid in (1005,1016,1015,1013,1001,1002,1003,1007,1008,1004,1006,1009,1010);\ncommit;\" style=\"color:#000000;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki light-plus\" style=\"background-color: #FFFFFF\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #000000\">delete <\/span><span style=\"color: #A31515\">from<\/span><span style=\"color: #000000\"> <\/span><span style=\"color: #A31515\">mythconverg.program<\/span><\/span>\n<span class=\"line\"><span style=\"color: #000000\">where <\/span><span style=\"color: #A31515\">starttime<\/span><span style=\"color: #000000\"> &gt; <\/span><span style=\"color: #A31515\">&#39;2021-11-01 09:30:00&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #000000\">and <\/span><span style=\"color: #A31515\">starttime<\/span><span style=\"color: #000000\"> &lt; <\/span><span style=\"color: #A31515\">&#39;2021-11-02 00:00:00&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #000000\">and <\/span><span style=\"color: #A31515\">chanid<\/span><span style=\"color: #000000\"> <\/span><span style=\"color: #A31515\">in<\/span><span style=\"color: #000000\"> (1005,1016,1015,1013,1001,1002,1003,1007,1008,1004,1006,1009,1010);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #000000\">commit;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p>On the other hand if I change the where clause to &#8220;and chanid in (1005,1016,1015,1013,1001,1002);&#8221; Kodi doesn&#8217;t work and equally if I change it to &#8220;and chanid in (1003,1007,1008,1004,1006,1009,1010);&#8221; it doesn&#8217;t work either. This seems to strongly suggest it is broken by multiple channels and thus multiple recordings<\/p>\n\n\n\n<h1 class=\"wp-block-heading\">Testing strategy<\/h1>\n\n\n\n<p>Because I didn&#8217;t want to break anything I stopped my MythTV VM server and moved the image under \/Current_Working_20210405&#8243; and then copied the VM folder to the original location. This ensured if there were any issues with copying the VM folder it would only impact the test instance of the VM.<\/p>\n\n\n\n<p>Secondly my recordings are on two NAS servers &#8220;NAS1&#8221; and &#8220;NAS2&#8221;. I renamed the existing &#8220;recordings&#8221; folder to &#8220;recordings &#8211; Current Recordings&#8221; and created a new folder called &#8220;recordings&#8221;.<\/p>\n\n\n\n<p>My primary Kodi device is the lounge PC. I tried to not use this but to rather use my desktop PC to check if things were working. This is because there is quite a bit on the filesystem of Kodi and it&#8217;s associated SQLite database. If you must use your equivalent of my lounge computer then ensure you backup everything under the following folders:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>C:\\Users\\Tony\\AppData\\Roaming\\Kodi<\/li>\n\n\n\n<li>C:\\Program Files\\Kodi <\/li>\n<\/ul>\n\n\n\n<p>So between the above measures I was able to test ideas with the confidence my original setup was intact.<\/p>\n\n\n\n<p>Steps<br>=====<br>Ensure all HDHR tuners are unplugged from the network<\/p>\n\n\n\n<p>Stop Kodi and cleanup<br>Ensure Kodi is not running &#8211; likely need to kill in task manager<br>Delete the Epg *.db and TV*.db files in C:\\Users\\Tony\\AppData\\Roaming\\Kodi\\userdata\\Database<\/p>\n\n\n\n<p>Stop MythTV and restore DB<br>systemctl stop mythbackend.service<br>mysql -u root -p<br>drop database mythconverg;<br>create database mythconverg;<br>exit;<br>mysql -f -u mythtv -p mythconverg &lt; \/var\/tmp\/MySQL_DB_Dump_#0_mythconverg_MythSvr2-20211025.dmp<br><br>Run SQL scripts to remove records. <br><br>Restart Myth<br>systemctl start mythbackend.service<br>Wait for recorded programs to show in MythWeb<br><br>Restart Kodi<br><\/p>\n\n\n\n<p>delete from mythconverg.program<br>where starttime &gt; &#8216;2021-11-01 09:30:00&#8217;<br>and chanid in (1005,1016,1015,1013,1001,1002,1003,1007,1008,1004,1006,1009,1010);<br>commit;<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>delete from mythconverg.program<br>where starttime &gt; &#8216;2021-11-01 09:30:00&#8217;<br>and starttime &lt; &#8216;2021-11-02 00:00:00&#8217;<br>and chanid in (1005,1016,1015,1013,1001,1002,1003,1007,1008,1004,1006,1009,1010);<br>commit;<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>delete from mythconverg.program<br>where starttime &gt; &#8216;2021-11-01 09:30:00&#8217;<br>and starttime &lt; &#8216;2021-11-02 00:00:00&#8217;<br>and chanid in (1005,1016,1015,1013,1001,1002,1003,1007,1008,1004,1006,1009,1010);<br>commit;<\/p>\n\n\n\n<p>delete from mythconverg.record;<br>commit;<\/p>\n\n\n\n<p>delete from mythconverg.program<br>where starttime &gt; &#8216;2021-11-01 09:30:00&#8217;<br>and starttime &lt; &#8216;2021-11-02 00:00:00&#8217;<br>and chanid in (1001,1002);<br>commit;<\/p>\n\n\n\n<p>select * from mythconverg.program<br>where starttime &gt; &#8216;2021-11-01 09:30:00&#8217;<br>and starttime &lt; &#8216;2021-11-02 00:00:00&#8217;<br>and chanid in (1001);<\/p>\n\n\n\n<p>delete from mythconverg.program;<\/p>\n\n\n\n<p>select * from mythconverg.program where starttime &gt; &#8216;2021-11-01 09:30:00&#8217; ORDER BY chanid ;<\/p>\n\n\n\n<p>select * from mythconverg.channel;<\/p>\n\n\n\n<p>select count(*) from mythconverg.program<\/p>\n\n\n\n<p>delete from mythconverg.program where starttime &gt; &#8216;2021-11-01 09:00:00&#8217;;<br>commit;<\/p>\n\n\n\n<p>select * from mythconverg.program where starttime &gt; &#8216;2021-11-01 09:00:00&#8217;;<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"545\" height=\"81\" src=\"https:\/\/www.zoyinc.com\/wp-content\/uploads\/2021\/10\/image-11.png\" alt=\"\" class=\"wp-image-4884\" srcset=\"http:\/\/www.zoyinc.com\/wp-content\/uploads\/2021\/10\/image-11.png 545w, http:\/\/www.zoyinc.com\/wp-content\/uploads\/2021\/10\/image-11-300x45.png 300w, http:\/\/www.zoyinc.com\/wp-content\/uploads\/2021\/10\/image-11-150x22.png 150w, http:\/\/www.zoyinc.com\/wp-content\/uploads\/2021\/10\/image-11-500x74.png 500w\" sizes=\"auto, (max-width: 545px) 100vw, 545px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><br>Where does &#8220;PVR manager is starting up:&#8221; come from<\/h2>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"491\" height=\"79\" src=\"https:\/\/www.zoyinc.com\/wp-content\/uploads\/2021\/10\/image-10.png\" alt=\"\" class=\"wp-image-4882\" srcset=\"http:\/\/www.zoyinc.com\/wp-content\/uploads\/2021\/10\/image-10.png 491w, http:\/\/www.zoyinc.com\/wp-content\/uploads\/2021\/10\/image-10-300x48.png 300w, http:\/\/www.zoyinc.com\/wp-content\/uploads\/2021\/10\/image-10-150x24.png 150w\" sizes=\"auto, (max-width: 491px) 100vw, 491px\" \/><\/figure>\n\n\n\n<p>This is actually defined in C++ source code for Kodi, see &#8220;Resources&#8221; link at the bottom of the page:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:0.9rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#000000;--cbp-line-number-width:calc(1 * 0.6 * 0.9rem);line-height:1.4rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span role=\"button\" tabindex=\"0\" data-code=\"\\xbmc-Leia\\addons\\resource.language.en_gb\\resources\\strings.po\" style=\"color:#000000;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki light-plus\" style=\"background-color: #FFFFFF\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #EE0000\">\\x<\/span><span style=\"color: #000000\">bmc-Leia<\/span><span style=\"color: #EE0000\">\\a<\/span><span style=\"color: #000000\">ddons<\/span><span style=\"color: #EE0000\">\\r<\/span><span style=\"color: #000000\">esource.language.en_gb<\/span><span style=\"color: #EE0000\">\\r<\/span><span style=\"color: #000000\">esources<\/span><span style=\"color: #EE0000\">\\s<\/span><span style=\"color: #000000\">trings.po<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p>Which looks like:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:0.9rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#000000;--cbp-line-number-width:calc(1 * 0.6 * 0.9rem);line-height:1.4rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span role=\"button\" tabindex=\"0\" data-code=\"#. label 'pvr starting up' for progress dialog text\n#: xbmc\/pvr\/PVRManager.cpp\n#: xbmc\/pvr\/windows\/GUIWindowPVRBase.cpp\nmsgctxt &quot;#19235&quot;\nmsgid &quot;PVR manager is starting up&quot;\nmsgstr &quot;&quot;\" style=\"color:#000000;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki light-plus\" style=\"background-color: #FFFFFF\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #008000\">#. label &#39;pvr starting up&#39; for progress dialog text<\/span><\/span>\n<span class=\"line\"><span style=\"color: #008000\">#: xbmc\/pvr\/PVRManager.cpp<\/span><\/span>\n<span class=\"line\"><span style=\"color: #008000\">#: xbmc\/pvr\/windows\/GUIWindowPVRBase.cpp<\/span><\/span>\n<span class=\"line\"><span style=\"color: #000000\">msgctxt <\/span><span style=\"color: #A31515\">&quot;#19235&quot;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #000000\">msgid <\/span><span style=\"color: #A31515\">&quot;PVR manager is starting up&quot;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #000000\">msgstr <\/span><span style=\"color: #A31515\">&quot;&quot;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p>This is then used on only a couple of places like<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:0.9rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#000000;--cbp-line-number-width:calc(1 * 0.6 * 0.9rem);line-height:1.4rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span role=\"button\" tabindex=\"0\" data-code=\"\\xbmc-Leia\\xbmc\\pvr\\windows\\GUIWindowPVRBase.cpp\" style=\"color:#000000;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki light-plus\" style=\"background-color: #FFFFFF\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #EE0000\">\\x<\/span><span style=\"color: #000000\">bmc-Leia<\/span><span style=\"color: #EE0000\">\\x<\/span><span style=\"color: #000000\">bmc<\/span><span style=\"color: #EE0000\">\\p<\/span><span style=\"color: #000000\">vr<\/span><span style=\"color: #EE0000\">\\w<\/span><span style=\"color: #000000\">indows<\/span><span style=\"color: #EE0000\">\\G<\/span><span style=\"color: #000000\">UIWindowPVRBase.cpp<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p>This doesn&#8217;t help a lot:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:0.9rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#000000;--cbp-line-number-width:calc(2 * 0.6 * 0.9rem);line-height:1.4rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span role=\"button\" tabindex=\"0\" data-code=\"void CGUIWindowPVRBase::OnInitWindow(void)\n{\n  SetProperty(&quot;IsRadio&quot;, m_bRadio ? &quot;true&quot; : &quot;&quot;);\n\n  if (InitChannelGroup())\n  {\n    m_channelGroupsSelector-&gt;Initialize(this, m_bRadio);\n\n    CGUIMediaWindow::OnInitWindow();\n\n    \/\/ mark item as selected by channel path\n    m_viewControl.SetSelectedItem(CServiceBroker::GetPVRManager().GUIActions()-&gt;GetSelectedItemPath(m_bRadio));\n\n    \/\/ This has to be done after base class OnInitWindow to restore correct selection\n    m_channelGroupsSelector-&gt;SelectChannelGroup(GetChannelGroup());\n  }\n  else\n  {\n    CGUIWindow::OnInitWindow(); \/\/ do not call CGUIMediaWindow as it will do a Refresh which in no case works in this state (no channelgroup!)\n    ShowProgressDialog(g_localizeStrings.Get(19235), 0); \/\/ PVR manager is starting up\n  }\n}\" style=\"color:#000000;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki light-plus\" style=\"background-color: #FFFFFF\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #000000\">void <\/span><span style=\"color: #A31515\">CGUIWindowPVRBase::OnInitWindow<\/span><span style=\"color: #000000\">(void)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #000000\">{<\/span><\/span>\n<span class=\"line\"><span style=\"color: #000000\">  SetProperty(&quot;IsRadio&quot;, <\/span><span style=\"color: #A31515\">m_bRadio<\/span><span style=\"color: #000000\"> <\/span><span style=\"color: #A31515\">?<\/span><span style=\"color: #000000\"> <\/span><span style=\"color: #A31515\">&quot;true&quot;<\/span><span style=\"color: #000000\"> <\/span><span style=\"color: #A31515\">:<\/span><span style=\"color: #000000\"> <\/span><span style=\"color: #A31515\">&quot;&quot;<\/span><span style=\"color: #000000\">);<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #000000\">  <\/span><span style=\"color: #AF00DB\">if<\/span><span style=\"color: #000000\"> (<\/span><span style=\"color: #795E26\">InitChannelGroup<\/span><span style=\"color: #000000\">())<\/span><\/span>\n<span class=\"line\"><span style=\"color: #000000\">  {<\/span><\/span>\n<span class=\"line\"><span style=\"color: #000000\">    m_channelGroupsSelector-&gt;Initialize(this, <\/span><span style=\"color: #A31515\">m_bRadio<\/span><span style=\"color: #000000\">);<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #000000\">    <\/span><span style=\"color: #795E26\">CGUIMediaWindow::OnInitWindow<\/span><span style=\"color: #000000\">();<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #000000\">    \/\/ mark item as selected by channel path<\/span><\/span>\n<span class=\"line\"><span style=\"color: #000000\">    m_viewControl.SetSelectedItem(CServiceBroker::GetPVRManager().GUIActions()-&gt;GetSelectedItemPath(m_bRadio));<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #000000\">    \/\/ This has to be done after base class OnInitWindow to restore correct selection<\/span><\/span>\n<span class=\"line\"><span style=\"color: #000000\">    m_channelGroupsSelector-&gt;SelectChannelGroup(GetChannelGroup());<\/span><\/span>\n<span class=\"line\"><span style=\"color: #000000\">  }<\/span><\/span>\n<span class=\"line\"><span style=\"color: #000000\">  <\/span><span style=\"color: #AF00DB\">else<\/span><\/span>\n<span class=\"line\"><span style=\"color: #000000\">  {<\/span><\/span>\n<span class=\"line\"><span style=\"color: #000000\">    <\/span><span style=\"color: #795E26\">CGUIWindow::OnInitWindow<\/span><span style=\"color: #000000\">(); \/\/ do not call CGUIMediaWindow as it will do a Refresh which in no case works in this state (no channelgroup!)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #000000\">    ShowProgressDialog(g_localizeStrings.Get(19235), 0); \/\/ PVR manager is starting up<\/span><\/span>\n<span class=\"line\"><span style=\"color: #000000\">  }<\/span><\/span>\n<span class=\"line\"><span style=\"color: #000000\">}<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Capturing packets to monitor requests to backend<\/h2>\n\n\n\n<p>I thought it might be really helpful to see what requests were being made as it looked like continuous requests were being made to the MythTV backend.<\/p>\n\n\n\n<p>To do this I looked at Fiddler but it didn&#8217;t really work really well so I used Wireshark and monitored ports 6543 and 6544 using the capture filter &#8220;port 6543 or 6544.<\/p>\n\n\n\n<p>I found that it seemed to make each api call once and did NOT make any further calls while it was hanging. It definately was not constantly calling the backend. There was also no evidence the responses were bad.<\/p>\n\n\n\n<p>If you enable debugging you will see in the Kodi logs calls like:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:0.9rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#000000;--cbp-line-number-width:calc(1 * 0.6 * 0.9rem);line-height:1.4rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span role=\"button\" tabindex=\"0\" data-code=\"2021-10-31 07:38:32.852 T:7524    DEBUG &lt;general&gt;: AddOnLog: pvr.mythtv: (CPPMyth)Myth::WSResponse::SendRequest: GET \/Dvr\/GetUpcomingList?StartIndex=0&amp;Count=100&amp;ShowAll=true HTTP\/1.1\n                                                   Host: 192.168.202.44:6544\n                                                   User-Agent: libcppmyth\/2.0\n                                                   Connection: close\n                                                   Accept: application\/json\n                                                   Accept-Charset: utf-8\n                                                   Accept-Encoding: gzip, deflate\" style=\"color:#000000;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki light-plus\" style=\"background-color: #FFFFFF\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #000000\">2021-10-31 <\/span><span style=\"color: #098658\">07<\/span><span style=\"color: #A31515\">:<\/span><span style=\"color: #098658\">38<\/span><span style=\"color: #A31515\">:<\/span><span style=\"color: #098658\">32.852<\/span><span style=\"color: #000000\"> <\/span><span style=\"color: #A31515\">T:<\/span><span style=\"color: #098658\">7524<\/span><span style=\"color: #000000\">    <\/span><span style=\"color: #A31515\">DEBUG<\/span><span style=\"color: #000000\"> &lt;<\/span><span style=\"color: #A31515\">genera<\/span><span style=\"color: #000000\">l&gt;<\/span><span style=\"color: #A31515\">:<\/span><span style=\"color: #000000\"> <\/span><span style=\"color: #A31515\">AddOnLog:<\/span><span style=\"color: #000000\"> <\/span><span style=\"color: #A31515\">pvr.mythtv:<\/span><span style=\"color: #000000\"> (CPPMyth)Myth::WSResponse::SendRequest: <\/span><span style=\"color: #A31515\">GET<\/span><span style=\"color: #000000\"> <\/span><span style=\"color: #A31515\">\/Dvr\/GetUpcomingList?StartIndex=<\/span><span style=\"color: #098658\">0<\/span><span style=\"color: #000000\">&amp;<\/span><span style=\"color: #001080\">Count<\/span><span style=\"color: #000000\">=<\/span><span style=\"color: #098658\">100<\/span><span style=\"color: #000000\">&amp;<\/span><span style=\"color: #001080\">ShowAll<\/span><span style=\"color: #000000\">=<\/span><span style=\"color: #0000FF\">true<\/span><span style=\"color: #000000\"> HTTP\/1.1<\/span><\/span>\n<span class=\"line\"><span style=\"color: #000000\">                                                   Host: <\/span><span style=\"color: #A31515\">192.168.202.44:<\/span><span style=\"color: #098658\">6544<\/span><\/span>\n<span class=\"line\"><span style=\"color: #000000\">                                                   User-Agent: <\/span><span style=\"color: #A31515\">libcppmyth\/<\/span><span style=\"color: #098658\">2.0<\/span><\/span>\n<span class=\"line\"><span style=\"color: #000000\">                                                   Connection: <\/span><span style=\"color: #A31515\">close<\/span><\/span>\n<span class=\"line\"><span style=\"color: #000000\">                                                   Accept: <\/span><span style=\"color: #A31515\">application\/json<\/span><\/span>\n<span class=\"line\"><span style=\"color: #000000\">                                                   Accept-Charset: <\/span><span style=\"color: #A31515\">utf-<\/span><span style=\"color: #098658\">8<\/span><\/span>\n<span class=\"line\"><span style=\"color: #000000\">                                                   Accept-Encoding: <\/span><span style=\"color: #A31515\">gzip,<\/span><span style=\"color: #000000\"> <\/span><span style=\"color: #A31515\">deflate<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h1 class=\"wp-block-heading\">The resolution<\/h1>\n\n\n\n<p>It seemed clear that the problem was in the database rather than the supporting infrastructure. The question was what was wrong.<\/p>\n\n\n\n<p>At this point I worked I was running the test VM which had a current copy of the database.<\/p>\n\n\n\n<p>I began by truncating all the tables that I thought might be related. Then once I found the effected tables I reduced the tables to be truncated to the bare minimum to resolve the problem<\/p>\n\n\n\n<p>Then rather than truncate I started deleting rows in the tables based on date &#8211; because it only stopped working at a particular date. This worked and I was able to reduce it to 3 tables and a handful of records<\/p>\n\n\n\n<p>The working query is below. Obviously you would have to work out the specifics for your environment:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:0.9rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#000000;--cbp-line-number-width:calc(1 * 0.6 * 0.9rem);line-height:1.4rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span role=\"button\" tabindex=\"0\" data-code=\"delete from mythconverg.record where recordid in (1157);\ndelete from mythconverg.program where starttime in ('2021-04-04 11:30:00');\ndelete from mythconverg.recorded where starttime  &gt; ('2021-04-01 00:00:00');\ncommit;\" style=\"color:#000000;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki light-plus\" style=\"background-color: #FFFFFF\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #0000FF\">delete<\/span><span style=\"color: #000000\"> <\/span><span style=\"color: #0000FF\">from<\/span><span style=\"color: #000000\"> mythconverg.record <\/span><span style=\"color: #0000FF\">where<\/span><span style=\"color: #000000\"> recordid <\/span><span style=\"color: #0000FF\">in<\/span><span style=\"color: #000000\"> (<\/span><span style=\"color: #098658\">1157<\/span><span style=\"color: #000000\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #0000FF\">delete<\/span><span style=\"color: #000000\"> <\/span><span style=\"color: #0000FF\">from<\/span><span style=\"color: #000000\"> mythconverg.program <\/span><span style=\"color: #0000FF\">where<\/span><span style=\"color: #000000\"> starttime <\/span><span style=\"color: #0000FF\">in<\/span><span style=\"color: #000000\"> (<\/span><span style=\"color: #A31515\">&#39;2021-04-04 11:30:00&#39;<\/span><span style=\"color: #000000\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #0000FF\">delete<\/span><span style=\"color: #000000\"> <\/span><span style=\"color: #0000FF\">from<\/span><span style=\"color: #000000\"> mythconverg.recorded <\/span><span style=\"color: #0000FF\">where<\/span><span style=\"color: #000000\"> starttime  &gt; (<\/span><span style=\"color: #A31515\">&#39;2021-04-01 00:00:00&#39;<\/span><span style=\"color: #000000\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #0000FF\">commit<\/span><span style=\"color: #000000\">;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p>For your info the rows that are being deleted look like the below. I have not been able to see any invalid or special characters that might cause a problem:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:0.9rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#000000;--cbp-line-number-width:calc(2 * 0.6 * 0.9rem);line-height:1.4rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span role=\"button\" tabindex=\"0\" data-code=\"select * from mythconverg.record where recordid in (1157);\n1157\t4\t0\t08:00:00\t2017-08-01\t08:30:00\t2017-08-01\tShortland Street\t\tJack meets a charmer. Michael's tempted to break the law. Nicole loses her grip.\t0\t0\tFilm\tDefault\t10\t1\t6\t1\t3\t25\tDefault\t8\t15\t\tcrid:\/\/tvnz.co.nz\/1026619\tcrid:\/\/tvnz.co.nz\/10469604\t\t0\t0\t0\t0\t0\t0\t0\t0\t3\t20:00:00\t736907\t0\t0\t0\tDefault\t0\t2021-04-05 06:57:00\t2021-04-01 11:56:55\t2021-04-01 12:53:54\tDefault\t184\t0\t1\n\nselect * from mythconverg.program where starttime in ('2021-04-04 11:30:00') and title like '%Inside%';\n1016\t2021-04-04 11:30:00\t2021-04-04 12:00:00\tInside Story\t\tG Beyond the headlines to the heart of the news of the day. Al Jazeera gets the Inside Story from some of the best minds in the Middle East and beyond.\t\tseries\t0\t0.0\t0\t\t0\t0\t0\t0\t0\t0\tcrid:\/\/www.aljazeera.com\/15241971\t\t\t\t\tcrid:\/\/www.aljazeera.com\/44546130\t0\t0\t1\t0\t0\t\t\t\t\t0\t0\t0\n\nselect * from mythconverg.recorded where starttime  &gt; ('2021-04-01 00:00:00');\n1002\t2021-04-01 11:57:00\t2021-04-01 12:50:05\tShortland Street\t\tPG Marty struggles to find a solution. Dawn marks her territory. Zara signs out.\t0\t0\tMovie\tmythsvr2\t0\t0\t0\t1\t0\tDefault\t1157\tcrid:\/\/tvnz.co.nz\/1031826a\tcrid:\/\/tvnz.co.nz\/10590196\t\t2021-04-02 01:50:05\t2882862312\t0.0\t0\t\t0\t0\t0\t0\t1.0\t10\t1002_20210401115700.ts\t2021-04-01 12:00:00\t2021-04-01 12:25:00\tDefault\tDefault\t1\t0\t0\tDefault\t\t1\t2030\tInput 1\n1003\t2021-04-02 04:57:00\t2021-04-02 06:04:06\tNewshub Live At 6pm\t\tNewshub Live At 6pm presents comprehensive coverage of global and local news.\t0\t0\tEntertainment\tmythsvr2\t0\t0\t0\t1\t0\tDefault\t1394\tcrid:\/\/tv3.co.nz\/68236\tcrid:\/\/tv3.co.nz\/t1048718\t\t2021-04-02 19:04:06\t3711027128\t0.0\t0\t\t0\t0\t0\t0\t1.0\t0\t1003_20210402045700.ts\t2021-04-02 05:00:00\t2021-04-02 06:00:00\tDefault\tDefault\t1\t0\t0\tDefault\t\t1\t2033\tInput 2\n1002\t2021-04-03 05:27:00\t2021-04-03 07:34:05\tMovie: Oddball\t\tAn eccentric chicken farmer, with the help of his granddaughter, trains his dog to protect a penguin sanctuary from fox attacks in an attempt to reunite his family and save their seaside town. (2015)\t0\t0\tMovie\tmythsvr2\t0\t0\t0\t0\t0\tDefault\t1907\t\tcrid:\/\/tvnz.co.nz\/10477867\t\t2021-04-03 20:34:05\t5912729908\t0.0\t0\t\t0\t0\t0\t0\t1.0\t0\t1002_20210403052700.ts\t2021-04-03 05:30:00\t2021-04-03 07:20:00\tDefault\tDefault\t1\t0\t0\tDefault\t\t1\t2035\tInput 1\n1003\t2021-04-03 04:57:00\t2021-04-03 06:04:05\tNewshub Live At 6pm\t\tNewshub Live At 6pm presents comprehensive coverage of global and local news.\t0\t0\tEntertainment\tmythsvr2\t0\t0\t0\t1\t0\tDefault\t1394\tcrid:\/\/tv3.co.nz\/68236\tcrid:\/\/tv3.co.nz\/t1048719\t\t2021-04-03 19:04:05\t3683758480\t0.0\t0\t\t0\t0\t0\t0\t1.0\t0\t1003_20210403045700.ts\t2021-04-03 05:00:00\t2021-04-03 06:00:00\tDefault\tDefault\t1\t0\t0\tDefault\t\t1\t2034\tInput 2\n1003\t2021-04-02 03:42:00\t2021-04-02 04:29:05\tTravels With The Bondi Vet\t\tG New Episode. Chris goes on the celebrity trail in LA, explores a mysterious ocean outcrop in his quest to become James Bond and visits a wildlife forest in the heart of Dublin. S3 Ep1\t0\t0\tEntertainment\tmythsvr2\t0\t0\t0\t0\t0\tDefault\t357\tcrid:\/\/tv3.co.nz\/67892\tcrid:\/\/tv3.co.nz\/t1042608\t\t2021-04-02 17:29:05\t2866085568\t0.0\t0\t\t0\t0\t0\t0\t1.0\t0\t1003_20210402034200.ts\t2021-04-02 03:45:00\t2021-04-02 04:15:00\tDefault\tDefault\t1\t0\t0\tDefault\t\t1\t2031\tInput 1\n1008\t2021-04-01 07:57:00\t2021-04-01 08:40:05\tGrand Designs NZ: Signature Series\t\tPG A site with a river running through it would put most people off. But not Harlem and Nicola who attempt to build a glass-house on a bridge over the water. S5 Ep2\t0\t0\t\tmythsvr2\t0\t0\t0\t0\t0\tDefault\t169\tcrid:\/\/tv3.co.nz\/56196\tcrid:\/\/tv3.co.nz\/t786095\t\t2021-04-01 21:40:05\t963187544\t0.0\t0\t\t0\t0\t0\t0\t1.0\t0\t1008_20210401075700.ts\t2021-04-01 07:30:00\t2021-04-01 08:30:00\tDefault\tDefault\t1\t0\t0\tDefault\t\t1\t2029\tInput 1\n1008\t2021-04-02 04:42:00\t2021-04-02 05:29:05\tTravels With The Bondi Vet\t\tG New Episode. Chris goes on the celebrity trail in LA, explores a mysterious ocean outcrop in his quest to become James Bond and visits a wildlife forest in the heart of Dublin. S3 Ep1\t0\t0\tEntertainment\tmythsvr2\t0\t0\t0\t0\t0\tDefault\t357\tcrid:\/\/tv3.co.nz\/67892\tcrid:\/\/tv3.co.nz\/t1042608\t\t2021-04-02 18:29:05\t1222027448\t0.0\t0\t\t0\t0\t0\t0\t1.0\t0\t1008_20210402044200.ts\t2021-04-02 04:45:00\t2021-04-02 05:15:00\tDefault\tDefault\t1\t0\t0\tDefault\t\t1\t2032\tInput 1\" style=\"color:#000000;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki light-plus\" style=\"background-color: #FFFFFF\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #0000FF\">select<\/span><span style=\"color: #000000\"> * <\/span><span style=\"color: #0000FF\">from<\/span><span style=\"color: #000000\"> mythconverg.record <\/span><span style=\"color: #0000FF\">where<\/span><span style=\"color: #000000\"> recordid <\/span><span style=\"color: #0000FF\">in<\/span><span style=\"color: #000000\"> (<\/span><span style=\"color: #098658\">1157<\/span><span style=\"color: #000000\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #098658\">1157<\/span><span style=\"color: #000000\">\t<\/span><span style=\"color: #098658\">4<\/span><span style=\"color: #000000\">\t<\/span><span style=\"color: #098658\">0<\/span><span style=\"color: #000000\">\t<\/span><span style=\"color: #098658\">08<\/span><span style=\"color: #000000\">:<\/span><span style=\"color: #098658\">00<\/span><span style=\"color: #000000\">:<\/span><span style=\"color: #098658\">00<\/span><span style=\"color: #000000\">\t<\/span><span style=\"color: #098658\">2017<\/span><span style=\"color: #000000\">-<\/span><span style=\"color: #098658\">08<\/span><span style=\"color: #000000\">-<\/span><span style=\"color: #098658\">01<\/span><span style=\"color: #000000\">\t<\/span><span style=\"color: #098658\">08<\/span><span style=\"color: #000000\">:<\/span><span style=\"color: #098658\">30<\/span><span style=\"color: #000000\">:<\/span><span style=\"color: #098658\">00<\/span><span style=\"color: #000000\">\t<\/span><span style=\"color: #098658\">2017<\/span><span style=\"color: #000000\">-<\/span><span style=\"color: #098658\">08<\/span><span style=\"color: #000000\">-<\/span><span style=\"color: #098658\">01<\/span><span style=\"color: #000000\">\tShortland Street\t\tJack meets a charmer. Michael<\/span><span style=\"color: #A31515\">&#39;s tempted to break the law. Nicole loses her grip.\t0\t0\tFilm\tDefault\t10\t1\t6\t1\t3\t25\tDefault\t8\t15\t\tcrid:\/\/tvnz.co.nz\/1026619\tcrid:\/\/tvnz.co.nz\/10469604\t\t0\t0\t0\t0\t0\t0\t0\t0\t3\t20:00:00\t736907\t0\t0\t0\tDefault\t0\t2021-04-05 06:57:00\t2021-04-01 11:56:55\t2021-04-01 12:53:54\tDefault\t184\t0\t1<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #A31515\">select * from mythconverg.program where starttime in (&#39;<\/span><span style=\"color: #098658\">2021<\/span><span style=\"color: #000000\">-<\/span><span style=\"color: #098658\">04<\/span><span style=\"color: #000000\">-<\/span><span style=\"color: #098658\">04<\/span><span style=\"color: #000000\"> <\/span><span style=\"color: #098658\">11<\/span><span style=\"color: #000000\">:<\/span><span style=\"color: #098658\">30<\/span><span style=\"color: #000000\">:<\/span><span style=\"color: #098658\">00<\/span><span style=\"color: #A31515\">&#39;) and title like &#39;<\/span><span style=\"color: #000000\">%Inside%<\/span><span style=\"color: #A31515\">&#39;;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #A31515\">1016\t2021-04-04 11:30:00\t2021-04-04 12:00:00\tInside Story\t\tG Beyond the headlines to the heart of the news of the day. Al Jazeera gets the Inside Story from some of the best minds in the Middle East and beyond.\t\tseries\t0\t0.0\t0\t\t0\t0\t0\t0\t0\t0\tcrid:\/\/www.aljazeera.com\/15241971\t\t\t\t\tcrid:\/\/www.aljazeera.com\/44546130\t0\t0\t1\t0\t0\t\t\t\t\t0\t0\t0<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #A31515\">select * from mythconverg.recorded where starttime  &gt; (&#39;<\/span><span style=\"color: #098658\">2021<\/span><span style=\"color: #000000\">-<\/span><span style=\"color: #098658\">04<\/span><span style=\"color: #000000\">-<\/span><span style=\"color: #098658\">01<\/span><span style=\"color: #000000\"> <\/span><span style=\"color: #098658\">00<\/span><span style=\"color: #000000\">:<\/span><span style=\"color: #098658\">00<\/span><span style=\"color: #000000\">:<\/span><span style=\"color: #098658\">00<\/span><span style=\"color: #A31515\">&#39;);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #A31515\">1002\t2021-04-01 11:57:00\t2021-04-01 12:50:05\tShortland Street\t\tPG Marty struggles to find a solution. Dawn marks her territory. Zara signs out.\t0\t0\tMovie\tmythsvr2\t0\t0\t0\t1\t0\tDefault\t1157\tcrid:\/\/tvnz.co.nz\/1031826a\tcrid:\/\/tvnz.co.nz\/10590196\t\t2021-04-02 01:50:05\t2882862312\t0.0\t0\t\t0\t0\t0\t0\t1.0\t10\t1002_20210401115700.ts\t2021-04-01 12:00:00\t2021-04-01 12:25:00\tDefault\tDefault\t1\t0\t0\tDefault\t\t1\t2030\tInput 1<\/span><\/span>\n<span class=\"line\"><span style=\"color: #A31515\">1003\t2021-04-02 04:57:00\t2021-04-02 06:04:06\tNewshub Live At 6pm\t\tNewshub Live At 6pm presents comprehensive coverage of global and local news.\t0\t0\tEntertainment\tmythsvr2\t0\t0\t0\t1\t0\tDefault\t1394\tcrid:\/\/tv3.co.nz\/68236\tcrid:\/\/tv3.co.nz\/t1048718\t\t2021-04-02 19:04:06\t3711027128\t0.0\t0\t\t0\t0\t0\t0\t1.0\t0\t1003_20210402045700.ts\t2021-04-02 05:00:00\t2021-04-02 06:00:00\tDefault\tDefault\t1\t0\t0\tDefault\t\t1\t2033\tInput 2<\/span><\/span>\n<span class=\"line\"><span style=\"color: #A31515\">1002\t2021-04-03 05:27:00\t2021-04-03 07:34:05\tMovie: Oddball\t\tAn eccentric chicken farmer, with the help of his granddaughter, trains his dog to protect a penguin sanctuary from fox attacks in an attempt to reunite his family and save their seaside town. (2015)\t0\t0\tMovie\tmythsvr2\t0\t0\t0\t0\t0\tDefault\t1907\t\tcrid:\/\/tvnz.co.nz\/10477867\t\t2021-04-03 20:34:05\t5912729908\t0.0\t0\t\t0\t0\t0\t0\t1.0\t0\t1002_20210403052700.ts\t2021-04-03 05:30:00\t2021-04-03 07:20:00\tDefault\tDefault\t1\t0\t0\tDefault\t\t1\t2035\tInput 1<\/span><\/span>\n<span class=\"line\"><span style=\"color: #A31515\">1003\t2021-04-03 04:57:00\t2021-04-03 06:04:05\tNewshub Live At 6pm\t\tNewshub Live At 6pm presents comprehensive coverage of global and local news.\t0\t0\tEntertainment\tmythsvr2\t0\t0\t0\t1\t0\tDefault\t1394\tcrid:\/\/tv3.co.nz\/68236\tcrid:\/\/tv3.co.nz\/t1048719\t\t2021-04-03 19:04:05\t3683758480\t0.0\t0\t\t0\t0\t0\t0\t1.0\t0\t1003_20210403045700.ts\t2021-04-03 05:00:00\t2021-04-03 06:00:00\tDefault\tDefault\t1\t0\t0\tDefault\t\t1\t2034\tInput 2<\/span><\/span>\n<span class=\"line\"><span style=\"color: #A31515\">1003\t2021-04-02 03:42:00\t2021-04-02 04:29:05\tTravels With The Bondi Vet\t\tG New Episode. Chris goes on the celebrity trail in LA, explores a mysterious ocean outcrop in his quest to become James Bond and visits a wildlife forest in the heart of Dublin. S3 Ep1\t0\t0\tEntertainment\tmythsvr2\t0\t0\t0\t0\t0\tDefault\t357\tcrid:\/\/tv3.co.nz\/67892\tcrid:\/\/tv3.co.nz\/t1042608\t\t2021-04-02 17:29:05\t2866085568\t0.0\t0\t\t0\t0\t0\t0\t1.0\t0\t1003_20210402034200.ts\t2021-04-02 03:45:00\t2021-04-02 04:15:00\tDefault\tDefault\t1\t0\t0\tDefault\t\t1\t2031\tInput 1<\/span><\/span>\n<span class=\"line\"><span style=\"color: #A31515\">1008\t2021-04-01 07:57:00\t2021-04-01 08:40:05\tGrand Designs NZ: Signature Series\t\tPG A site with a river running through it would put most people off. But not Harlem and Nicola who attempt to build a glass-house on a bridge over the water. S5 Ep2\t0\t0\t\tmythsvr2\t0\t0\t0\t0\t0\tDefault\t169\tcrid:\/\/tv3.co.nz\/56196\tcrid:\/\/tv3.co.nz\/t786095\t\t2021-04-01 21:40:05\t963187544\t0.0\t0\t\t0\t0\t0\t0\t1.0\t0\t1008_20210401075700.ts\t2021-04-01 07:30:00\t2021-04-01 08:30:00\tDefault\tDefault\t1\t0\t0\tDefault\t\t1\t2029\tInput 1<\/span><\/span>\n<span class=\"line\"><span style=\"color: #A31515\">1008\t2021-04-02 04:42:00\t2021-04-02 05:29:05\tTravels With The Bondi Vet\t\tG New Episode. Chris goes on the celebrity trail in LA, explores a mysterious ocean outcrop in his quest to become James Bond and visits a wildlife forest in the heart of Dublin. S3 Ep1\t0\t0\tEntertainment\tmythsvr2\t0\t0\t0\t0\t0\tDefault\t357\tcrid:\/\/tv3.co.nz\/67892\tcrid:\/\/tv3.co.nz\/t1042608\t\t2021-04-02 18:29:05\t1222027448\t0.0\t0\t\t0\t0\t0\t0\t1.0\t0\t1008_20210402044200.ts\t2021-04-02 04:45:00\t2021-04-02 05:15:00\tDefault\tDefault\t1\t0\t0\tDefault\t\t1\t2032\tInput 1<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Daylight savings &#8211; possible cause<\/h2>\n\n\n\n<p>Now I have a resolution that worked for me today, I still can&#8217;t absolutely say what caused the issue. Essentially I have to delete the most recent details in 3 tables, so it stinks of being a time related issue.<\/p>\n\n\n\n<p>The previous similar problem seems somewhat similar and after cleaning up the tables, in that instance, things worked again. And for that case the table that was truncated was the &#8220;program&#8221; table, which is one of the 3 tables we found this time around<\/p>\n\n\n\n<p>I documented the previous problem around November 3 last year. Daylight savings began on 27 of September 2020. Daylight savings ended April 4th 2021.<\/p>\n\n\n\n<p>My problems this time around occurred around the 26\/4\/2021 with daylight savings just slightly over 8 days away on the 4\/4\/2021. This ties in with the EPG because the EPG holds roughly 8 days of details, so potentially EPG issues could potentially show up 8 days before the recording. <\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Help and resources<\/h2>\n\n\n\n<p><strong>Kodi MythTV Forum<\/strong><br><a  href=\"https:\/\/forum.kodi.tv\/forumdisplay.php?fid=170\">https:\/\/forum.kodi.tv\/forumdisplay.php?fid=170<\/a><\/p>\n\n\n\n<p>Kodi source code<br><a  href=\"https:\/\/github.com\/xbmc\/xbmc\">https:\/\/github.com\/xbmc\/xbmc<\/a><\/p>\n\n\n","protected":false},"excerpt":{"rendered":"<p>Around about the 26\/3\/2021 the Windows 10 MythTV add-on for Kodi stopped working. I had seen similar problem before, Kodi MythTV addon fails to load except this time it didn&#8217;t load at all whereas previously it was stuck loading at around 40%. This time around it didn&#8217;t seem to connect to the MythTV server at [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":5819,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18],"tags":[714,709,708,168,710,712,298,94,713,174,461,715],"class_list":["post-4745","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mythtv","tag-add-on","tag-addon","tag-database-2","tag-hang","tag-koki","tag-mythtv","tag-setup","tag-table","tag-windows","tag-windows-10","tag-zero"],"_links":{"self":[{"href":"http:\/\/www.zoyinc.com\/index.php?rest_route=\/wp\/v2\/posts\/4745","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.zoyinc.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.zoyinc.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.zoyinc.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/www.zoyinc.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4745"}],"version-history":[{"count":47,"href":"http:\/\/www.zoyinc.com\/index.php?rest_route=\/wp\/v2\/posts\/4745\/revisions"}],"predecessor-version":[{"id":5821,"href":"http:\/\/www.zoyinc.com\/index.php?rest_route=\/wp\/v2\/posts\/4745\/revisions\/5821"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.zoyinc.com\/index.php?rest_route=\/wp\/v2\/media\/5819"}],"wp:attachment":[{"href":"http:\/\/www.zoyinc.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4745"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.zoyinc.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4745"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.zoyinc.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4745"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}