[mythtv-users] Running mythfrontend with mysql 5.5 client against mybackend using 5.7

Jean-Yves Avenard jyavenard at gmail.com
Fri Dec 2 10:10:03 UTC 2016


On 2 December 2016 at 21:04, Jean-Yves Avenard <jyavenard at gmail.com> wrote:
> On 2 December 2016 at 20:10, Yann Lehmann <aristide at free-it.ch> wrote:
>> I have migrated my backend to 16.04 recently (fresh 0.28 install with
>> restore of a 0.27 database, comming from Ubuntu 14.04) and switched to
>> MariaDB instead of MySQL.
>>
>
> yes..
>
> good news for me.
>
> I uninstalled mysql 5.7 (both client and server). Restored a backup
> from earlier today (mysql database) then restored the mythconverg from
> last night. Install MariaDB.
>
> All good.
>
> So mythtv doesn't work with mysql 5.7 by the look of things.
>
> Currently sitting in the plane,5 minutes from takeoff... Who knew
 backups and installing new package could be that stressful !
>
> Now plenty of stuff broken by the 16.04 upgrade, but I can do that
> tomorrow from abroad.

still something not quite right:

Dec  2 21:06:42 mediaserver-surrey1 mythbackend: mythbackend[14225]: N
DeleteThread mainserver.cpp:2448 (DeleteRecordedFiles)
DeleteRecordedFiles - recording id 9921 filename
/external/recordings/1010_20161202100015.ts
Dec  2 21:06:42 mediaserver-surrey1 mythbackend: mythbackend[14225]: N
DeleteThread mainserver.cpp:2526 (DoDeleteInDB) DoDeleteINDB -
recording id 9921 (chanid 1010 at 2016-12-02T10:00:15Z)
Dec  2 21:06:48 mediaserver-surrey1 mythbackend: mythbackend[14225]: N
DeleteThread mainserver.cpp:2448 (DeleteRecordedFiles)
DeleteRecordedFiles - recording id 9922 filename
/external/recordings/1010_20161202100039.ts
Dec  2 21:06:48 mediaserver-surrey1 mythbackend: mythbackend[14225]: E
DeleteThread mythdb.cpp:183 (DBError) DB Error (RecordedFiles
deletion):#012Query was:#012SELECT basename, hostname, storagegroup
FROM recordedfile WHERE recordedid = ?;#012Bindings
were:#012:RECORDEDID=9922#012No error type from QSqlError?  Strange...
Dec  2 21:06:48 mediaserver-surrey1 mythbackend: mythbackend[14225]: E
DeleteThread mainserver.cpp:2460 (DeleteRecordedFiles) MainServer:
Error querying recordedfiles for recording id 9922 filename
/external/recordings/1010_20161202100039.ts.


that's after watching live tv via mythavtest on one of the 14.04 machine.

wonder what's going on there.


More information about the mythtv-users mailing list