[downgraded]Database upgrade fail in backend 0.28 to 0.29

[keepitsimpleengineer]

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...

[bill6502]

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

[keepitsimpleengineer]

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

[bill6502]

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.

[keepitsimpleengineer]

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

[keepitsimpleengineer]

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..!