[mythtv-users] mythweb program lists missing data on some channels

[Jim Abernathy]

On 7/28/20 12:45 AM, Stephen Worthington wrote:
> On Mon, 27 Jul 2020 22:59:28 -0400, you wrote:
>
>> On 7/27/20 10:05 PM, Stephen Worthington wrote:
>>> On Mon, 27 Jul 2020 18:32:47 -0400, you wrote:
>>>
>>>> On Mon, Jul 27, 2020 at 6:27 PM James Abernathy <jfabernathy at gmail.com>
>>>> wrote:
>>>>
>>>>> On Mon, Jul 27, 2020 at 5:54 PM Mark Perkins <perkins1724 at hotmail.com>
>>>>> wrote:
>>>>>
>>>>>> ------------------------------
>>>>>> *From:* James Abernathy <jfabernathy at gmail.com>
>>>>>> *Sent:* Tuesday, 28 July 2020 6:30 am
>>>>>> *To:* Discussion about MythTV
>>>>>> *Subject:* [mythtv-users] mythweb program lists missing data on some
>>>>>> channels
>>>>>>
>>>>>> I have the latest mythtv v31 update and I looked at mythweb to check
>>>>>> something and noticed quite a few stations with No Data in the guide.  I
>>>>>> fired up mythfrontend and there was no problem there. The stations all have
>>>>>> data.
>>>>>>
>>>>>> I tried on another computer and got the same results.
>>>>>>
>>>>>> Jim A
>>>>>>
>>>>>>
>>>>>> Out of curiosity does the newer webfrontend show the missing data or not?
>>>>>>
>>>>>>
>>>>>> Sorry, I have no idea what the newer webfrontend is?  Is it a part of v31?
>>>>> JIm A
>>>>>
>>>> My bad, I found webfrontend.  http://192.168.0.250:6544/
>>>> <http://192.168.0.250:6544/#>  got it for me.
>>>>
>>>> The guide is fine there. So the only issue is with mythweb
>>>>
>>>> Jim A
>>> That suggests a PHP problem.  Have a look for error messages in the
>>> Apache log files in /var/log/apache2 and maybe also syslog.  It is not
>>> unlikely that you will have to configure a larger RAM buffer or
>>> something like that.
>> Here's the error.log:
>>
>> [Mon Jul 27 14:09:37.615173 2020] [mpm_prefork:notice] [pid 2294]
>> AH00169: caught SIGTERM, shutting down
>> [Mon Jul 27 14:11:12.948604 2020] [mpm_prefork:notice] [pid 2254]
>> AH00163: Apache/2.4.29 (Ubuntu) configured -- resuming normal operations
>> [Mon Jul 27 14:11:12.989288 2020] [core:notice] [pid 2254] AH00094:
>> Command line: '/usr/sbin/apache2'
>> [Mon Jul 27 14:36:00.416729 2020] [php7:error] [pid 2499] [client
>> 192.168.0.26:48586] PHP Fatal error:  Allowed memory size of 67108864
>> bytes exhausted (tried to allocate 16384 bytes) in
>> /usr/share/mythtv/mythweb/classes/Database/Query/mysqlicompat.php on
>> line 68, referer: http://192.168.0.250/mythweb/tv/list
>> [Mon Jul 27 14:36:00.418363 2020] [php7:warn] [pid 2499] [client
>> 192.168.0.26:48586] PHP Warning:  Unknown: Cannot call session save
>> handler in a recursive manner in Unknown on line 0, referer:
>> http://192.168.0.250/mythweb/tv/list
>>
>> Jim A
> I got the same sort of error caused by too many recordings.  I fixed
> it by creating this file:
>
> root at mypvr:/etc/php/7.2/apache2/conf.d# cat 21-mythweb-jsw.ini
> memory_limit = 256M

I created that file and rebooted. No change; still errors and missing 
data in the Program listings. It's strange. It's missing data for 
channels 4.1, 4.3, 4.4. 5.1, 5.2, 11.1, 17.1, but had data for 4.2, 5.3, 
11.2, 11.3, etc.

Also I only have about 39 channels of data from SchedulesDirect provided 
by tv_grab_zz_sdjson_sqlite. Also I don't have a lot of current 
recordings, and compared to a lot of you guys, I don't have a very large 
database. It's currently on 10.2 MB as measured by the size of the 
overnight backup file.

Jim A