[downgraded]Database upgrade fail in backend 0.28 to 0.29

Have a MythTV related problem? Ask for help from other MythTV users here.

Moderator: Forum Moderators

Post Reply
User avatar
keepitsimpleengineer
Junior
Posts: 18
Joined: Fri Oct 03, 2014 9:53 pm
Location: Central California, U.S.A.
Contact:
United States of America

[downgraded]Database upgrade fail in backend 0.28 to 0.29

Post by keepitsimpleengineer » Tue Aug 08, 2017 3:44 pm

I upgraded on 16.04 Ubuntu from 0.28 to 0.29 using the repositories, and I think the database upgrade portion failed.

Clients cannot connect to backend and backend cannot start the database.

From console starting the backend:

Code: Select all

2017-08-08 08:06:30.200754 N  AutoExpire: CalcParams(): Max required Free Space: 200.0 GB w/freq: 15 min
2017-08-08 08:06:30.522258 I  Bonjour: Service registration complete: name 'Mythbackend on KISE-055' type '_mythbackend._tcp.' domain: 'local.'
2017-08-08 08:06:31.077985 C  MainServer: MainServer::HandleVersion - Client speaks protocol version 88 but we speak 91!
2017-08-08 08:06:31.078770 I  Control sock(1742760) disconnected
2017-08-08 08:06:31.080545 C  MainServer: MainServer::HandleVersion - Client speaks protocol version 88 but we speak 91!
2017-08-08 08:06:31.081065 I  Control sock(1735860) disconnected
:?: Unsure how to complete or restore the database...
Last edited by keepitsimpleengineer on Tue Aug 08, 2017 6:40 pm, edited 2 times in total.

User avatar
bill6502
Developer
Posts: 1289
Joined: Fri Feb 07, 2014 5:28 pm
United States of America

Re: Database upgrade fail in backend 0.28 to 0.29

Post by bill6502 » Tue Aug 08, 2017 5:10 pm

Hi,

Not sure what you by complete as there are no logs for a DB upgrade failure.
This should help you restore: https://www.mythtv.org/wiki/Database_Ba ... se_Restore

User avatar
keepitsimpleengineer
Junior
Posts: 18
Joined: Fri Oct 03, 2014 9:53 pm
Location: Central California, U.S.A.
Contact:
United States of America

Re: Database upgrade fail in backend 0.28 to 0.29

Post by keepitsimpleengineer » Tue Aug 08, 2017 5:24 pm

This should help you restore: https://www.mythtv.org/wiki/Database_Ba ... se_Restore
As per https://www.mythtv.org/wiki/Database_Ba ... se_Restore I tried this:

/usr/share/mythtv$ ./mythconverg_restore.pl --drop_database --create_database --directory /pvu/db_bu/ --filename mythconverg-1344-20170808050503.sql.gz

and got this result:

Code: Select all

Shall I upgrade this database? [yes]  yes
2017-08-08 09:32:21.659464 C  Upgrading to MythTV schema version 1345
2017-08-08 09:32:21.690326 C  Upgrading to MythTV schema version 1346
2017-08-08 09:32:21.736203 C  Upgrading to MythTV schema version 1347
2017-08-08 09:32:21.741109 C  Upgrading to MythTV schema version 1348
2017-08-08 09:32:21.872756 I  Database schema upgrade complete.
2017-08-08 09:32:21.873649 I  Loading en_us translation for module mythfrontend
2017-08-08 09:32:21.875720 N  MythBackend: Starting up as the master server.
Which still produced the "Client speaks protocol version 88 but we speak 91!" error when starting mythbackend. :(

Note:

Code: Select all

-rwxr-xr-x  1 root root 68606 Jul 14 01:05 mythconverg_restore.pl

User avatar
bill6502
Developer
Posts: 1289
Joined: Fri Feb 07, 2014 5:28 pm
United States of America

Re: Database upgrade fail in backend 0.28 to 0.29

Post by bill6502 » Tue Aug 08, 2017 5:31 pm

As long as v29 is installed, when the mythbackend (or mythtv-setup) is started,
then either will try to update the DB.

You need to revert to 0.28 and then restore the DB. Sorry, I don't have the instructions
for doing that.

User avatar
keepitsimpleengineer
Junior
Posts: 18
Joined: Fri Oct 03, 2014 9:53 pm
Location: Central California, U.S.A.
Contact:
United States of America

Re: Database upgrade fail in backend 0.28 to 0.29

Post by keepitsimpleengineer » Tue Aug 08, 2017 5:42 pm

bill6502 wrote:You need to revert to 0.28 and then restore the DB. Sorry, I don't have the instructions
for doing that.
I'm guessing uninstall 0.29, drop the 0.29 repositories, then reinstall mythtv..?

I'll give it a try

User avatar
keepitsimpleengineer
Junior
Posts: 18
Joined: Fri Oct 03, 2014 9:53 pm
Location: Central California, U.S.A.
Contact:
United States of America

Re: Database upgrade fail in backend 0.28 to 0.29

Post by keepitsimpleengineer » Tue Aug 08, 2017 6:33 pm

Successfully downgraded from 0.29 to 0.28

Code: Select all

# uninstalled 0.29, found correct name in dpkg.log
sudo apt-get autoremove mythtv-common
## disabled 0.29 repository using synaptic
sudo apt-get update
# verify 0.28 & not 0.29
apt-cache policy mythtv
# install 0.28
sudo apt-get install mythtv
# restore last database note "drop and create probably not necessary"
./mythconverg_restore.pl --drop_database --create_database --directory /pvu/db_bu/ --filename mythconverg-1344-20170808050503.sql.gz
]

Thanx bill6502..!

Post Reply