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

Kris J kris.jensen.knj at gmail.com
Fri Jan 11 03:20:14 UTC 2019


On Thu, Jan 10, 2019 at 9:24 PM Kris J <kris.jensen.knj at gmail.com> wrote:

>
>
> On Thu, Jan 10, 2019 at 7:02 PM Peter Bennett <pb.mythtv at gmail.com> wrote:
>
>>
>>
>> On 1/10/19 6:37 PM, Kris J wrote:
>> >
>> >
>> > On Thu, Jan 10, 2019 at 5:18 PM Peter Bennett <pb.mythtv at gmail.com
>> > <mailto:pb.mythtv at gmail.com>> wrote:
>> >
>> >
>> >
>> >     On 1/10/19 4:49 PM, Kris J wrote:
>> >>
>> >>
>> >>     On Thu, Jan 10, 2019 at 12:51 PM Kris J
>> >>     <kris.jensen.knj at gmail.com <mailto:kris.jensen.knj at gmail.com>>
>> wrote:
>> >>
>> >>
>> >>
>> >>         On Thu, Jan 10, 2019 at 10:52 AM Kris J
>> >>         <kris.jensen.knj at gmail.com
>> >>         <mailto:kris.jensen.knj at gmail.com>> wrote:
>> >>
>> >>
>> >>
>> >>             On Thu, Jan 10, 2019 at 10:48 AM Peter Bennett
>> >>             <pb.mythtv at gmail.com <mailto:pb.mythtv at gmail.com>> wrote:
>> >>
>> >>
>> >>
>> >>                 On 1/10/19 10:41 AM, Kris J wrote:
>> >>>
>> >>>
>> >>>                 On Thu, Jan 10, 2019 at 10:32 AM Peter Bennett
>> >>>                 <pb.mythtv at gmail.com <mailto:pb.mythtv at gmail.com>>
>> >>>                 wrote:
>> >>>
>> >>>
>> >>>
>> >>>                     On 1/10/19 10:21 AM, Kris J wrote:
>> >>>>
>> >>>>
>> >>>>                     On Wed, Jan 9, 2019 at 6:43 PM Peter Bennett
>> >>>>                     <pb.mythtv at gmail.com
>> >>>>                     <mailto:pb.mythtv at gmail.com>> wrote:
>> >>>>
>> >>>>
>> >>>>
>> >>>>                         On 1/9/19 1:47 PM, Kris J wrote:
>> >>>>>
>> >>>>>                         I can install either available 64bit
>> >>>>>                         packages from
>> >>>>>
>> https://dl.bintray.com/bennettpeter/generic/.
>> >>>>>                         The android fronted starts up with trying
>> >>>>>                         to connect to backend, it seems slow to
>> >>>>>                         find the backend (29.1+fixes) and
>> >>>>>                         sometimes fails. However after several
>> >>>>>                         try's it eventually connects. (using ETH)
>> >>>>>
>> >>>>>
>> >>>>>                         I can move about the frontend. However
>> >>>>>                         most end points in the menu lead to a
>> >>>>>                         loading screen that seems to hang the
>> >>>>>                         Nvshield, and requires a hard power off.
>> >>>>>
>> >>>>>
>> >>>>>                         I've been reading the user list and wiki
>> >>>>>                         for pointer. However it seems I'm the only
>> >>>>>                         one with this type of trouble. I see no
>> >>>>>                         other reports of this type so I must have
>> >>>>>                         missed something somewhere.
>> >>>>>
>> >>>>>
>> >>>>>                         Any pointers appreciated.
>> >>>>>
>> >>>>>                         Many thanks.
>> >>>>>
>> >>>>>
>> >>>>
>> >>>>                         I have not seen or heard of this behavior.
>> >>>>                         I assume you got as far as the main menu so
>> >>>>                         it must be successfully connecting to the
>> >>>>                         database and the backend.
>> >>>>
>> >>>>                         Have you gone into setup and set the audio
>> >>>>                         and video profile (or maybe it hangs even
>> >>>>                         before you can get there). If you have not
>> >>>>                         set these up and you are attempting
>> >>>>                         playback it will not work well.
>> >>>>
>> >>>>                         If you still have a problem you can get a
>> log.
>> >>>>
>> >>>>                         If you have adb installed and debug mode
>> >>>>                         activated, you can do this to get a log:
>> >>>>
>> >>>>                         On your linux machine, with the ip address
>> >>>>                         of the shield:
>> >>>>                         adb connect [ip address]
>> >>>>                         adb logcat mfe:D *:S |& tee android.log
>> >>>>
>> >>>>                         Then try starting mythfrontend and
>> >>>>                         navigating. If it is having errors you will
>> >>>>                         see them on the screen and in the
>> >>>>                         android.log file. This may give you an idea
>> >>>>                         of what is wrong.
>> >>>>
>> >>>>                         Peter
>> >>>>
>> >>>>
>> >>>>
>> >>>>                     Hi, Peter
>> >>>>
>> >>>>                     I don't see anything in the log
>> >>>>                     (https://pastebin.com/AuTgdVXk) that's a
>> >>>>                     obvious, other then minor font errors.
>> >>>>
>> >>>>                     The log stops when I navigate to
>> >>>>                     "setup/general" Then the load screen pops up
>> >>>>                     and the shield needed are power off.
>> >>>>
>> >>>>                     Many Thank for your time.
>> >>>>
>> >>>>
>> >>>                     The log looks normal. Which backend version are
>> >>>                     you using? Perhaps there is a problem with that.
>> >>>                     The android frontend will work with backend
>> >>>                     version 29 or later. Older versions will likely
>> >>>                     cause problems.
>> >>>
>> >>>                     _______________________________________________
>> >>>
>> >>>                 Backend package = mythtv-backend-master
>> >>>                 29.1+fixes.20181228.af5d819~ubuntu16.04.1
>> >>>
>> >>>                 And
>> >>>
>> >>>                 "m-user at MythServer:~/build$ mythbackend -v
>> >>>                 2019-01-10 10:35:20.003539 C  mythbackend version:
>> >>>                 [v29.1] www.mythtv.org <http://www.mythtv.org>
>> >>>                 2019-01-10 10:35:20.003567 C  Qt version: compile:
>> >>>                 5.5.1, runtime: 5.5.1"
>> >>>
>> >>>
>> >>>
>> >>>
>> >>                 I have no idea what the problem is. You could try
>> >>                 uninstalling and reinstalling, also try looking at a
>> >>                 full log. That gives messages from all applications
>> >>                 and android itself, there you can see things like
>> >>                 missing libraries:
>> >>
>> >>                 adb logcat |& tee tmp/android.log
>> >>
>> >>                 Peter
>> >>                 _______________________________________________
>> >>
>> >>
>> >>
>> >>             Ok thank for the logging tips.
>> >>
>> >>             I'll see if I can find anything meaningful to work off of.
>> >>
>> >>             Many Thanks again.
>> >>
>> >>
>> >>
>> >>
>> >>     So I noticed the backend log has some errors when the android
>> >>     frontend has the loading screen. :
>> >>
>> >>     Jan 10 16:10:07 MythServer mythbackend: mythbackend[1690]: I
>> >>     MythSocketThread(84) mainserver.cpp:7674 (connectionClosed)
>> >>     Playback sock(1b0a970) 'android-3a0785970c9ae7ba' disconnected
>> >>     Jan 10 16:10:07 MythServer mythbackend: mythbackend[1690]: I
>> >>     MythSocketThread(86) mainserver.cpp:7674 (connectionClosed)
>> >>     Monitor sock(1a69530) 'android-3a0785970c9ae7ba' disconnected
>> >>     Jan 10 16:10:07 MythServer mythbackend: mythbackend[1690]: E
>> >>     CoreContext mythdbcon.cpp:873 (prepare) Error preparing query:
>> >>     SELECT data FROM settings WHERE value = :KEY AND hostname =
>> :HOSTNAME
>> >>     Jan 10 16:10:07 MythServer mythbackend: mythbackend[1690]: E
>> >>     CoreContext mythdbcon.cpp:875 (prepare) Driver error was
>> >>     [2/2013]:#012QMYSQL3: Unable to prepare statement#012Database
>> >>     error was:#012Lost connection to MySQL server during query
>> >>     Jan 10 16:10:07 MythServer mythbackend: mythbackend[1690]: I
>> >>     CoreContext mythdbcon.cpp:263 (Reconnect) MySQL reconnected
>> >>     successfully
>> >>
>> >>     I don't have problems connecting with my other frontends and
>> >>     kodi's frontend connect fine on the same shield.
>> >>
>> >>     Still trying however.
>> >>
>> >>
>> >>
>> >
>> >     That looks like the root cause of the problem. I seem to remember
>> >     something like this being the result of having conflicting
>> >     versions of database software on client and server. Do you have
>> >     very old mysql server software?
>> >
>> >
>> >
>> >
>> > Hmm.. I seem to have old and new mysql packages installed on my myth
>> > server. I did a package search for "mysql" and found:
>> >
>> > libdbd-mysql-perl 4.033-1ubuntu0.1
>> > libmysqlclient18 5.5.62-0ubuntu0.14.04.1
>> > libmysqlclient20 5.7.24-0ubuntu0.16.04.1
>> > libqt4-sql-mysql 4.8.7+dfsg-5ubuntu2
>> > libqt5sql5-mysql 5.5.1+dfsg-16ubuntu7.5
>> > mysql-client 5.7.24-0ubuntu0.16.04.1 K-O
>> > mysql-client-5.7 5.7.24-0ubuntu0.16.04.1 K-O
>> > mysql-client-core-5.7 5.7.24-0ubuntu0.16.04.1
>> > mysql-common 5.7.24-0ubuntu0.16.04.1
>> > mysql-server 5.7.24-0ubuntu0.16.04.1
>> > mysql-server-5.7 5.7.24-0ubuntu0.16.04.1
>> > mysql-server-core-5.7 5.7.24-0ubuntu0.16.04.1
>> > php5-mysql 5.5.9+dfsg-1ubuntu4.26
>> > php7.0-mysql 7.0.32-0ubuntu0.16.04.1
>> > python-mysqldb 1.3.7-1build2
>> >
>> > So it's the lingering 5.5 mysql packages the cause?
>> >
>> > I'm sketchy when it comes to DB stuff. But I would think removing the
>> > older packages listed below would be ok. Yes?
>> > libmysqlclient18 5.5.62-0ubuntu0.14.04.1,
>> >  libqt4-sql-mysql 4.8.7+dfsg-5ubuntu2,
>> >  libqt5sql5-mysql 5.5.1+dfsg-16ubuntu7.5
>> >  php5-mysql 5.5.9+dfsg-1ubuntu4.26
>> >
>> >
>> >
>> >
>> >
>> I don't think that will make a difference, 5.7 is the version shipping
>> with ubuntu now. The only one important is mysql-server and you have 5.7
>> so that should be OK. The latest mysql is version 8. I am using mariadb
>> which is at version 10. It seems ubuntu ships newer versions of mariadb
>> than of mysql.
>>
>> Perhaps you have some network problem. Using ethernet try plugging it
>> differently, into a different router if possible. Also try different
>> cables.
>>
>>
>> _______________________________________________
>> mythtv-users mailing list
>> mythtv-users at mythtv.org
>> http://lists.mythtv.org/mailman/listinfo/mythtv-users
>> http://wiki.mythtv.org/Mailing_List_etiquette
>> MythTV Forums: https://forum.mythtv.org
>
>
>  I think you are correct about network issues. Looking though the mysql
> log's and they are filled with errors like such:
>
> 2019-01-08T18:12:32.196916Z 8808 [Note] Aborted connection 8808 to db:
> 'mythconverg' user: 'mythtv' host: 'localhost' (Unknown error)
> 2019-01-08T18:12:32.626207Z 8855 [Note] Aborted connection 8855 to db:
> 'mythconverg' user: 'mythtv' host: '192.168.0.15' (Got an error reading
> communication packets)
> 2019-01-08T18:12:33.792349Z 8858 [Note] Aborted connection 8858 to db:
> 'mythconverg' user: 'mythtv' host: '192.168.0.15' (Got an error reading
> communication packets)
> 2019-01-08T18:13:19.080825Z 8857 [Note] Aborted connection 8857 to db:
> 'mythconverg' user: 'mythtv' host: 'localhost' (Unknown error)
> 2019-01-08T18:15:59.133402Z 8910 [Note] Got an error reading communication
> packets
>
> hmmm....I'll have to test things on the network. Or maybe remake the
> server, in preparation of 0.30 release. With mariadb.
>
>
> Many thanks Peter
>

I think I track it down to DB corruption.
Running ( mysql -umythtv -p mythconverg -e 'status;' ) on my server shows:
--------------
mysql  Ver 14.14 Distrib 5.7.24, for Linux (x86_64) using  EditLine wrapper

Connection id:          11854
Current database:       mythconverg
Current user:           mythtv at localhost
SSL:                    Not in use
Current pager:          stdout
Using outfile:          ''
Using delimiter:        ;
Server version:         5.7.24-0ubuntu0.16.04.1 (Ubuntu)
Protocol version:       10
Connection:             Localhost via UNIX socket
Server characterset:    latin1
Db     characterset:    utf8
Client characterset:    utf8
Conn.  characterset:    utf8
UNIX socket:            /var/run/mysqld/mysqld.sock
Uptime:                 4 hours 2 min 39 sec

Threads: 46  Questions: 2801872  Slow queries: 0  Opens: 4221  Flush
tables: 1  Open tables: 128  Queries per second avg: 192.449
--------------

Searching for answers lead me to a old outdated wiki page that explains the
problem and how to fix the DB.
(https://www.mythtv.org/wiki/Fixing_Corrupt_Database_Encoding)

However I'm leery to apply the suggested fix as the page has been labeled
outdated.

Is the "Fixing the database corruption" entry still a viable fix for Mythtv
.29.1?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20190110/14dd13e9/attachment.html>


More information about the mythtv-users mailing list