[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