[mythtv-users] Database fails to upgrade
dhighley at highley-recommended.com
Sun Oct 15 15:37:35 UTC 2017
"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
> MythTV Forums: https://forum.mythtv.org
More information about the mythtv-users