[mythtv-users] Database fails to upgrade

[David Highley]

"Paul Harrison wrote:"
> 
> On 15/10/17 05:16, David Highley wrote:
> 
> > After upgrading to Mythtv version 29 via rpmfusion packages for Fedora
> > the backend will not run because the database upgrade is failing with a
> > log message about invalid sql. From the log file below:
> >
> > 2017-10-13 03:45:08.076380 C [16990/16990] CoreContext dbcheck.cpp:437 (performActualUpdate) - Upgrading to MythTV schema version 1347
> > 2017-10-13 03:45:08.076484 E [16990/16990] CoreContext dbcheck.cpp:411 (performUpdateSeries) - DB Error (Performing database upgrade):
> > Query was: @�^F^B
> > Error was: Driver error was [2/1064]:
> > QMYSQL: Unable to execute query
> > Database error was:
> > You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '@�^F^B' at line 1
> >
> > 2017-10-13 03:45:08.076490 E [16990/16990] CoreContext dbcheck.cpp:519 (UpgradeTVDatabaseSchema) - Database schema upgrade failed.
> > 2017-10-13 03:45:08.076671 E [16990/16990] CoreContext main_helpers.cpp:571 (run_backend) - Couldn't upgrade database to new schema
> >
> 
> The query looks very strange!
> 
> Try shutting the backend down then run 'mythtv-setup -v database:debug' 
> (you may have to ensure you use the same user the backend uses so it 
> picks up the correct config.xml). Hopefully that will narrow down which 
> query that is (there are a few in the 1347 update).

That fixed it. It complained that it could not back up the database as I
ran as a different user, no interactive login for mythtv user. It
prompted to do the upgrade and it worked.

> 
> Paul H.
> _______________________________________________
> 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
>