[mythtv-users] Trying Nvshield android package, unsuccessfully. Pointers needed.

Tue Mar 12 04:23:49 UTC 2019

On Mon, Mar 11, 2019 at 4:12 AM Kris J <kris.jensen.knj at gmail.com> wrote:
>
> >On Sun, Mar 10, 2019 at 10:18 AM Peter Bennett <pb.mythtv at gmail.com> wrote:
>> On 3/9/19 9:51 PM, myth tv wrote:
>> > Hi,
>> >
>> > I was wondering whether you resolved the Shield vs mysql 5.7 issues.
>> > Looking through the thread, it seems I am experiencing somewhat
>> > similar issues with random hangs from Shield connected to mythbackend
>> > server running mysql 5.7. (Ubuntu 18.04)
>> > Other remote frontends don't have an issue nor does the frontend
>> > running on the same PC as the master backend.
>> > Hangs seem to be related to mysql errors in the shields adb log.
>> > Did you change to mariadb? or was it a hardware issue?
>> >
>> > Andrew
>> I am not aware of any mysql problems with Shield. Can you paste the
>> error messages into the email? I am using Mariadb 10.1 with no problems.
>>
>> When does it hang? During playback or other times?
>> _______________________________________________
>>
Peter, mythfrontend hangs randomly. Can take 3 minutes or 300 minutes.
Can be with watching recordings or even while still in the menu.

Below is the log from the shield (filtered for mfe) from mythfrontend
startup at 20:40:58 until the freeze at 21:46:06
(There is no specific error in the log at the time it freezes.)

03-10 20:40:58.864 15002 15025 W mythfrontend: (null):0 ((null)):
Could not create collator: 4
03-10 20:40:58.918 15002 15029 I mfe     : TV::TV::TV()(): Creating TV object
03-10 20:40:58.918 15002 15029 I mfe     : Suspending idle timer
03-10 20:40:58.918 15002 15029 I mfe     : TV::bool TV::Init(bool)():
Created TvPlayWindow.
03-10 20:40:58.919 15002 15029 I mfe     : TV::void
TV::HandleStateChange(PlayerContext*, PlayerContext*)(): Attempting to
change from None to WatchingPreRecorded
03-10 20:40:59.119 15002 15029 I mfe     : AOSLES: Native Rate 44100
03-10 20:40:59.120 15002 15029 I mfe     : AudioPlayer: Enabling Audio
03-10 20:40:59.420 15002 15029 I mfe     : AFD: codec MP2 has 2 channels
03-10 20:40:59.420 15002 15029 I mfe     : AFD: Opened codec
0x235399f500, id(MP2) type(Audio)
03-10 20:40:59.420 15002 15029 I mfe     : AFD: Using ffmpeg for video decoding
03-10 20:40:59.421 15002 15029 I mfe     : AFD: Opened codec
0x235399fa00, id(MPEG2VIDEO) type(Video)
03-10 20:40:59.421 15002 15029 I mfe     : AOBase: Resampling from 48
kHz to 44 kHz with quality medium
03-10 20:40:59.421 15002 15029 I mfe     : AOBase: Opening audio
device 'OpenSLES:' ch 2(2) sr 44100 sf signed 16 bit reenc 0
03-10 20:40:59.722 15002 15029 I mfe     : DispInfo: rate:59.9401
h:1080 w:1920 xdpi:213 ydpi:213
03-10 20:40:59.722 15002 15029 I mfe     : GLVid: Using 'opengl' for
OpenGL video type
03-10 20:40:59.823 15002 15029 E mfe     : MythFontProperties: Failed
to load 'DejaVu Sans', got 'Roboto' instead
03-10 20:40:59.823 15002 15029 E mfe     :
Location: /data/user/0/org.mythtv.mythfrontend/files/themes/Mythbuntu/osd.xml
@ 5
03-10 20:40:59.823 15002 15029 E mfe     :                      Name:
'medium'  Type: 'fontdef'
03-10 20:40:59.823 15002 15029 E mfe     : MythFontProperties: Failed
to load 'DejaVu Sans', got 'Roboto' instead
03-10 20:40:59.823 15002 15029 E mfe     :
Location: /data/user/0/org.mythtv.mythfrontend/files/themes/Mythbuntu/osd.xml
@ 9
03-10 20:40:59.823 15002 15029 E mfe     :                      Name:
'file'    Type: 'fontdef'
03-10 20:40:59.823 15002 15029 I mfe     : DispInfo: rate:59.9401
h:1080 w:1920 xdpi:213 ydpi:213
03-10 20:40:59.824 15002 15029 I mfe     : DispInfo: rate:59.9401
h:1080 w:1920 xdpi:213 ydpi:213
03-10 20:40:59.824 15002 15029 I mfe     : Player(0): Video timing
method: USleep with busy wait
03-10 20:40:59.824 15002 15029 I mfe     : TV::bool
TV::StartPlayer(PlayerContext*, PlayerContext*, TVState)(): Created
player.
03-10 20:40:59.824 15002 15029 I mfe     : TV::void
TV::HandleStateChange(PlayerContext*, PlayerContext*)(): Changing from
None to WatchingPreRecorded
03-10 20:40:59.824 15002 15029 E mfe     : AFD: Unknown audio decoding error
03-10 20:40:59.824 15002 15029 E mfe     : DB Error (Selecting
channel/dtv_multiplex):
03-10 20:40:59.824 15002 15029 E mfe     : Query was:
03-10 20:40:59.824 15002 15029 E mfe     : SELECT sourceid FROM
channel WHERE chanid = ?
03-10 20:40:59.824 15002 15029 E mfe     : Bindings were:
03-10 20:40:59.824 15002 15029 E mfe     : :CHANID=7002
03-10 20:40:59.824 15002 15029 E mfe     : Driver error was [2/2000]:
03-10 20:40:59.824 15002 15029 E mfe     : QMYSQL3: Unable to execute statement
03-10 20:40:59.824 15002 15029 E mfe     : Database error was:
03-10 20:40:59.824 15002 15029 E mfe     : Unknown MySQL error
03-10 20:40:59.824 15002 15029 I mfe     : TV::void
TV::HandleStateChange(PlayerContext*, PlayerContext*)(): Main UI
disabled.
03-10 20:40:59.824 15002 15029 I mfe     : TV::static bool
TV::StartTV(ProgramInfo*, uint, const ChannelInfoList&)(): Entering
main playback loop.
03-10 20:40:59.824 15002 15029 I mfe     : ScreenSaverAndroid: disable
03-10 20:40:59.825 15002 15029 I mfe     : ScreenSaverAndroid: disable 1
03-10 20:40:59.825 15002 15029 I mfe     : MySQL reconnected successfully
03-10 20:40:59.925 15002 15029 I mfe     : MythCodecContext: Disabled
hardware decoder based deinterlacer.
03-10 20:40:59.925 15002 15029 I mfe     : Player(0): Waited 102ms for
video buffers AAAAAAAAAAAAAAAAAAAAAAAAAAAAAuLP
03-10 20:41:00.025 15002 15029 I mfe     : Player(0): Waited 206ms for
video buffers uAAAAAAAAAAAAAAAAAAAAAAAAAAAAuLP
03-10 20:41:00.126 15002 15029 I mfe     : Player(0): Waited 309ms for
video buffers UUuUULuAAAAAAAAAAAAAAAAAAAAAAUUP
03-10 20:41:01.027 15002 15029 I mfe     : TV::void
TV::HandleStateChange(PlayerContext*, PlayerContext*)(): Attempting to
change from WatchingPreRecorded to None
03-10 20:41:01.128 15002 15029 I mfe     : TV::void
TV::HandleStateChange(PlayerContext*, PlayerContext*)(): Changing from
WatchingPreRecorded to None
03-10 20:41:01.128 15002 15029 I mfe     : TV::static bool
TV::StartTV(ProgramInfo*, uint, const ChannelInfoList&)(): Exiting
main playback loop.
03-10 20:41:01.128 15002 15029 I mfe     : ScreenSaverAndroid: restore
03-10 20:41:01.128 15002 15029 I mfe     : ScreenSaverAndroid: restore 1
03-10 20:41:01.128 15002 15029 I mfe     : Resuming idle timer
03-10 20:41:33.069 15002 15029 I mfe     : TV::TV::TV()(): Creating TV object
03-10 20:41:33.069 15002 15029 I mfe     : Suspending idle timer
03-10 20:41:33.070 15002 15029 I mfe     : TV::bool TV::Init(bool)():
Created TvPlayWindow.
03-10 20:41:33.170 15002 15029 I mfe     : TV::void
TV::HandleStateChange(PlayerContext*, PlayerContext*)(): Attempting to
change from None to WatchingPreRecorded
03-10 20:41:33.274 15002 15029 I mfe     : AOSLES: Native Rate 44100
03-10 20:41:33.274 15002 15029 I mfe     : AudioPlayer: Enabling Audio
03-10 20:41:33.575 15002 15029 I mfe     : AFD: codec MP2 has 2 channels
03-10 20:41:33.575 15002 15029 I mfe     : AFD: Opened codec
0x2353a08300, id(MP2) type(Audio)
03-10 20:41:33.575 15002 15029 I mfe     : AFD: Using ffmpeg for video decoding
03-10 20:41:33.575 15002 15029 I mfe     : AFD: Opened codec
0x2353a07e00, id(MPEG2VIDEO) type(Video)
03-10 20:41:33.575 15002 15029 I mfe     : AOBase: Resampling from 48
kHz to 44 kHz with quality medium
03-10 20:41:33.576 15002 15029 I mfe     : AOBase: Opening audio
device 'OpenSLES:' ch 2(2) sr 44100 sf signed 16 bit reenc 0
03-10 20:41:34.277 15002 15029 I mfe     : DispInfo: rate:59.9401
h:1080 w:1920 xdpi:213 ydpi:213
03-10 20:41:34.277 15002 15029 I mfe     : GLVid: Using 'opengl' for
OpenGL video type
03-10 20:41:34.479 15002 15029 E mfe     : MythFontProperties: Failed
to load 'DejaVu Sans', got 'Roboto' instead
03-10 20:41:34.479 15002 15029 E mfe     :
Location: /data/user/0/org.mythtv.mythfrontend/files/themes/Mythbuntu/osd.xml
@ 5
03-10 20:41:34.479 15002 15029 E mfe     :                      Name:
'medium'  Type: 'fontdef'
03-10 20:41:34.479 15002 15029 E mfe     : MythFontProperties: Failed
to load 'DejaVu Sans', got 'Roboto' instead
03-10 20:41:34.479 15002 15029 E mfe     :
Location: /data/user/0/org.mythtv.mythfrontend/files/themes/Mythbuntu/osd.xml
@ 9
03-10 20:41:34.479 15002 15029 E mfe     :                      Name:
'file'    Type: 'fontdef'
03-10 20:41:34.479 15002 15029 I mfe     : DispInfo: rate:59.9401
h:1080 w:1920 xdpi:213 ydpi:213
03-10 20:41:34.579 15002 15029 I mfe     : DispInfo: rate:59.9401
h:1080 w:1920 xdpi:213 ydpi:213
03-10 20:41:34.579 15002 15029 I mfe     : Player(1): Video timing
method: USleep with busy wait
03-10 20:41:34.580 15002 15029 I mfe     : TV::bool
TV::StartPlayer(PlayerContext*, PlayerContext*, TVState)(): Created
player.
03-10 20:41:34.580 15002 15029 I mfe     : TV::void
TV::HandleStateChange(PlayerContext*, PlayerContext*)(): Changing from
None to WatchingPreRecorded
03-10 20:41:34.580 15002 15029 E mfe     : AFD: Unknown audio decoding error
03-10 20:41:34.580 15002 15029 I mfe     : TV::void
TV::HandleStateChange(PlayerContext*, PlayerContext*)(): Main UI
disabled.
03-10 20:41:34.580 15002 15029 I mfe     : TV::static bool
TV::StartTV(ProgramInfo*, uint, const ChannelInfoList&)(): Entering
main playback loop.
03-10 20:41:34.580 15002 15029 I mfe     : ScreenSaverAndroid: disable
03-10 20:41:34.581 15002 15029 I mfe     : ScreenSaverAndroid: disable 1
03-10 20:41:34.581 15002 15029 I mfe     : MythCodecContext: Disabled
hardware decoder based deinterlacer.
03-10 20:41:34.681 15002 15029 I mfe     : Player(1): Waited 105ms for
video buffers AAAAAAAAAAAAAAAAAAAAAAAAAAAAuLLP
03-10 20:41:34.781 15002 15029 I mfe     : Player(1): Waited 209ms for
video buffers ULAAAAAAAAAAAAAAAAAAAAAAAAAAUuAP
03-10 20:41:34.882 15002 15029 I mfe     : Player(1): Waited 313ms for
video buffers UUUUuUULAAAAAAAAAAAAAAAAAAAAUUAP
03-10 20:41:52.999 15002 15029 I mfe     : Running HouseKeeperTask
'HardwareProfiler'.
03-10 20:41:52.999 15002 15029 I mfe     : HouseKeeperTask
'HardwareProfiler' Failed.
03-10 20:59:47.956 15002 15029 E mfe     : DB Error (Error in
JobQueue::GetJobs(), Unable to query list of Jobs in Queue.):
03-10 20:59:47.956 15002 15029 E mfe     : Query was:
03-10 20:59:47.956 15002 15029 E mfe     : SELECT j.id, j.chanid,
j.starttime, j.inserttime, j.type, j.cmds, j.flags, j.status,
j.statustime, j.hostname, j.args, j.comment, r.endtime, j.schedruntime
FROM jobqueue j LEFT JOIN recorded r   ON j.chanid = r.chanid AND
j.starttime = r.starttime ORDER BY j.schedruntime, j.id;
03-10 20:59:47.956 15002 15029 E mfe     : Driver error was [2/2000]:
03-10 20:59:47.956 15002 15029 E mfe     : QMYSQL3: Unable to execute statement
03-10 20:59:47.956 15002 15029 E mfe     : Database error was:
03-10 20:59:47.956 15002 15029 E mfe     : Unknown MySQL error
03-10 21:00:07.976 15002 15029 I mfe     : MySQL reconnected successfully
03-10 21:06:08.139 15002 15029 E mfe     : DB Error (Error in
JobQueue::GetJobs(), Unable to query list of Jobs in Queue.):
03-10 21:06:08.139 15002 15029 E mfe     : Query was:
03-10 21:06:08.139 15002 15029 E mfe     : SELECT j.id, j.chanid,
j.starttime, j.inserttime, j.type, j.cmds, j.flags, j.status,
j.statustime, j.hostname, j.args, j.comment, r.endtime, j.schedruntime
FROM jobqueue j LEFT JOIN recorded r   ON j.chanid = r.chanid AND
j.starttime = r.starttime ORDER BY j.schedruntime, j.id;
03-10 21:06:08.139 15002 15029 E mfe     : Driver error was [2/2000]:
03-10 21:06:08.139 15002 15029 E mfe     : QMYSQL3: Unable to execute statement
03-10 21:06:08.139 15002 15029 E mfe     : Database error was:
03-10 21:06:08.139 15002 15029 E mfe     : Unknown MySQL error
03-10 21:06:28.159 15002 15029 I mfe     : MySQL reconnected successfully
03-10 21:07:08.099 15002 15029 E mfe     : DB Error (Error in
JobQueue::GetJobs(), Unable to query list of Jobs in Queue.):
03-10 21:07:08.099 15002 15029 E mfe     : Query was:
03-10 21:07:08.099 15002 15029 E mfe     : SELECT j.id, j.chanid,
j.starttime, j.inserttime, j.type, j.cmds, j.flags, j.status,
j.statustime, j.hostname, j.args, j.comment, r.endtime, j.schedruntime
FROM jobqueue j LEFT JOIN recorded r   ON j.chanid = r.chanid AND
j.starttime = r.starttime ORDER BY j.schedruntime, j.id;
03-10 21:07:08.099 15002 15029 E mfe     : Driver error was [2/2000]:
03-10 21:07:08.099 15002 15029 E mfe     : QMYSQL3: Unable to execute statement
03-10 21:07:08.099 15002 15029 E mfe     : Database error was:
03-10 21:07:08.099 15002 15029 E mfe     : Unknown MySQL error
03-10 21:08:08.160 15002 15029 E mfe     : DB Error (Error in
JobQueue::GetJobs(), Unable to query list of Jobs in Queue.):
03-10 21:08:08.160 15002 15029 E mfe     : Query was:
03-10 21:08:08.160 15002 15029 E mfe     : SELECT j.id, j.chanid,
j.starttime, j.inserttime, j.type, j.cmds, j.flags, j.status,
j.statustime, j.hostname, j.args, j.comment, r.endtime, j.schedruntime
FROM jobqueue j LEFT JOIN recorded r   ON j.chanid = r.chanid AND
j.starttime = r.starttime ORDER BY j.schedruntime, j.id;
03-10 21:08:08.160 15002 15029 E mfe     : Driver error was [2/2000]:
03-10 21:08:08.160 15002 15029 E mfe     : QMYSQL3: Unable to execute statement
03-10 21:08:08.160 15002 15029 E mfe     : Database error was:
03-10 21:08:08.160 15002 15029 E mfe     : Unknown MySQL error
03-10 21:09:27.040 15002 15029 I mfe     : Player(1): Waited 104ms for
video buffers AAAAAAAAAAAAuAAAAAALAALAAAAAAAAP
03-10 21:09:27.140 15002 15029 I mfe     : Player(1): Waited 208ms for
video buffers AAAAAAAAAAAAuAAAAAALAALAAAAAAAAP
03-10 21:09:27.240 15002 15029 I mfe     : Player(1): Waited 312ms for
video buffers AAAAAAAAAAAAUAUuAULUAAAAAUAAAAAP
03-10 21:09:27.341 15002 15029 I mfe     : Player(1): Waited 416ms for
video buffers AAAAAAAAAAAAUAUUAUUUUuAULUAAAUUP
03-10 21:09:28.442 15002 15029 E mfe     : AFD: Unknown audio decoding error
03-10 21:09:28.543 15002 15029 I mfe     : Player(1): Waited 105ms for
video buffers AAAAAALAALAUuAAAAAAAAAAAAAAAAAAP
03-10 21:09:28.643 15002 15029 I mfe     : Player(1): Waited 209ms for
video buffers AAAAAAuAAAAUUALAAAAAAAAAAAAAAAAP
03-10 21:09:28.743 15002 15029 I mfe     : Player(1): To see more
buffering messages use -v playback
03-10 21:09:32.047 15002 15029 E mfe     : AFD: Unknown audio decoding error
03-10 21:09:33.749 15002 15029 E mfe     : AFD: Unknown audio decoding error
03-10 21:09:35.050 15002 15029 E mfe     : AFD: Unknown audio decoding error
03-10 21:09:35.050 15002 15029 E mfe     : AFD: Unknown audio decoding error
03-10 21:46:06.745 15002 15029 I mfe     : ScreenSaverAndroid: restore

>
> Hi The O.P.
> No I did not remedy the issue. Tried for a week tweaking database setting did not help. And then I got side tracked, and a bit frustrated.
> To many things to do around the house ATM so this is on the very back burner.
>
> =/
>
> Kris.
>
Kris, thanks for the update.

Andrew