Code: Select all
mythserver@mythserver-VirtualBox:~$ service mythtv-backend stop
mythserver@mythserver-VirtualBox:~/.mythtv$ ./mythconverg_restore.pl --drop_database --create_database --verbose
Configuring environment:
- username: mythserver
- HOME: /home/mythserver
- MYTHCONFDIR: /home/mythserver/.mythtv
Parsing configuration files:
- checking: /home/mythserver/.mythtv/config.xml
parsing: /home/mythserver/.mythtv/config.xml
- checking: /home/mythserver/.mythtv/backuprc
parsing: /home/mythserver/.mythtv/backuprc
Applying command-line arguments.
Checking configuration.
No filename specified. Attempting to find the newest database backup.
Using database backup file:
/home/NAS-Backup/MythTV/mythconverg-1317-20160820190232.sql.gz
Database Information:
DBHostName: localhost
DBPort: 3306
DBUserName: mythtv
DBPassword: XXX
DBName: mythconverg
DBSchemaVer:
DBBackupDirectory: /home/NAS-Backup/MythTV
DBBackupFilename: mythconverg-1317-20160820190232.sql.gz
drop_database: yes
create_database: yes
Executables:
mysql_client: mysql
uncompress: gzip -d
Miscellaneous:
partial_restore: no
restore_xmltvids: no
change_hostname: no
Checking database.
Preparing initial database.
Dropping database.
Creating database.
Setting database character set.
Found 0 tables in the database.
Backup file is compressed.
- Uncompressing backup file with IO::Uncompress::Gunzip.
Attempting to use supplied password for mysql command-line client.
Any [client] or [mysql] password specified in the MySQL options file will
take precedence.
Executing command:
'mysql' --defaults-extra-file='/tmp/H7oiCtfdgQ' --host='localhost' --port='3306' --user='mythtv' 'mythconverg'
mysql exited with status: 0
Restored 3700 of 3700 lines.
Successfully restored backup.
Found DBSchemaVer: 1317.
Setting database character set.
I click upgrade.
Code: Select all
Aug 20 21:27:54 mythserver-VirtualBox mythtv-setup.real: mythtv-setup[3820]: E CoreContext dbutil.cpp:604 (DoBackup) Backing up database with script: '/usr/share/mythtv/mythconverg_backup.pl'
Aug 20 21:28:02 mythserver-VirtualBox mythtv-setup.real: mythtv-setup[3820]: C CoreContext dbutil.cpp:625 (DoBackup) Database Backup complete.
Aug 20 21:28:02 mythserver-VirtualBox mythtv-setup.real: mythtv-setup[3820]: C CoreContext dbutil.cpp:656 (DoBackup) Backed up database to file: '/tmp/mythconverg-1317-20160821012754.sql.gz'
Aug 20 21:28:09 mythserver-VirtualBox mythtv-setup.real: mythtv-setup[3820]: C CoreContext dbcheck.cpp:437 (performActualUpdate) Upgrading to MythTV schema version 1318
Aug 20 21:28:09 mythserver-VirtualBox mythtv-setup.real: mythtv-setup[3820]: C CoreContext dbcheck.cpp:437 (performActualUpdate) Upgrading to MythTV schema version 1319
Aug 20 21:28:09 mythserver-VirtualBox mythtv-setup.real: mythtv-setup[3820]: C CoreContext dbcheck.cpp:437 (performActualUpdate) Upgrading to MythTV schema version 1320
Aug 20 21:28:10 mythserver-VirtualBox mythtv-setup.real: mythtv-setup[3820]: C CoreContext dbcheck.cpp:437 (performActualUpdate) Upgrading to MythTV schema version 1321
Aug 20 21:28:10 mythserver-VirtualBox mythtv-setup.real: mythtv-setup[3820]: C CoreContext dbcheck.cpp:437 (performActualUpdate) Upgrading to MythTV schema version 1322
Aug 20 21:28:10 mythserver-VirtualBox mythtv-setup.real: mythtv-setup[3820]: C CoreContext dbcheck.cpp:437 (performActualUpdate) Upgrading to MythTV schema version 1323
Aug 20 21:28:10 mythserver-VirtualBox mythtv-setup.real: mythtv-setup[3820]: C CoreContext dbcheck.cpp:437 (performActualUpdate) Upgrading to MythTV schema version 1324
Aug 20 21:28:10 mythserver-VirtualBox mythtv-setup.real: mythtv-setup[3820]: C CoreContext dbcheck.cpp:437 (performActualUpdate) Upgrading to MythTV schema version 1325
Aug 20 21:28:10 mythserver-VirtualBox mythtv-setup.real: mythtv-setup[3820]: C CoreContext dbcheck.cpp:437 (performActualUpdate) Upgrading to MythTV schema version 1326
Aug 20 21:28:10 mythserver-VirtualBox mythtv-setup.real: mythtv-setup[3820]: C CoreContext dbcheck.cpp:437 (performActualUpdate) Upgrading to MythTV schema version 1327
Aug 20 21:28:10 mythserver-VirtualBox mythtv-setup.real: mythtv-setup[3820]: C CoreContext dbcheck.cpp:437 (performActualUpdate) Upgrading to MythTV schema version 1328
Aug 20 21:28:10 mythserver-VirtualBox mythtv-setup.real: mythtv-setup[3820]: C CoreContext dbcheck.cpp:437 (performActualUpdate) Upgrading to MythTV schema version 1329
Aug 20 21:28:10 mythserver-VirtualBox mythtv-setup.real: mythtv-setup[3820]: C CoreContext dbcheck.cpp:437 (performActualUpdate) Upgrading to MythTV schema version 1330
mythserver@mythserver-VirtualBox:/var/log/mythtv$
If I interrupt the process and run myth-backend setup again it will say "Warning: MythTV wants to upgrade your database for the TV schema, from 1330 to 1344." and it will still hang at the first step (after backud up database, before starting anything else.
Code: Select all
Aug 20 21:48:04 mythserver-VirtualBox mythtv-setup.real: mythtv-setup[3824]: E CoreContext dbutil.cpp:604 (DoBackup) Backing up database with script: '/usr/share/mythtv/mythconverg_backup.pl'
Aug 20 21:48:13 mythserver-VirtualBox mythtv-setup.real: mythtv-setup[3824]: C CoreContext dbutil.cpp:625 (DoBackup) Database Backup complete.
Aug 20 21:48:13 mythserver-VirtualBox mythtv-setup.real: mythtv-setup[3824]: C CoreContext dbutil.cpp:656 (DoBackup) Backed up database to file: '/tmp/mythconverg-1330-20160821014804.sql.gz'
I have read lots of forums and tried to run /usr/share/doc/mythtv-backend/contrib/maintenance/optimize_mythdb.pl before backing up the database and I have tried restoring the oldest backup in the autobackup history to see if that made a difference. Still the same happens.
I started the upgrade process because the frontends were complaining that the backend was too old.
I am an experienced LInux user and would appreciate any ideas that you may have.
