LinHES Forums
http://forum.linhes.org/

Confimring my database schema was updated
http://forum.linhes.org/viewtopic.php?f=22&t=24852
Page 1 of 1

Author:  jniffen [ Sat Jul 06, 2019 5:57 pm ]
Post subject:  Confimring my database schema was updated

Thanks to everyone involved in the creation of LinHES 8.6.1.

I upgraded from LinHES 8.5.2 to 8.6.1.this week.
Did run the process to remove the ca-certificate after the pacman process reported it was needed.

However, I did not see any indication that my database schema was needed to be updated.
I would like another set of eyes to confirm my DB was updated automatically.

Code:
grep -i schema /var/log/2019-07-02/<backenhostname>_mythbackend.log
the <backenhostname> is the hostname of the myth backend server.

I noticed the following
Current MythTV Schema Version (DBSchemaVer): <nnnn>
(performActualUpdate) Upgrading to MythTV schema version <nnnn>
(UpgradeTVDatabaseSchema) Database schema upgrade complete.
(Compare) Current MythTV Schema Version (DBSchemaVer): <nnnn>
The <nnnn> value will depend on the verson of MythTV before the update and the upgrade verion

2019-07-02T18:56:34.012665-05:00 mythbackend[2671]: I CoreContext schemawizard.cpp:120 (Compare) Current MythTV Schema Version (DBSchemaVer): 1348
2019-07-02T19:37:26.280269-05:00 mythbackend[2405]: I CoreContext schemawizard.cpp:120 (Compare) Current MythTV Schema Version (DBSchemaVer): 1348
2019-07-02T19:37:47.198757-05:00 mythbackend[2405]: C CoreContext dbcheck.cpp:448 (performActualUpdate) Upgrading to MythTV schema version 1349
2019-07-02T19:37:47.198889-05:00 mythbackend[2405]: C CoreContext dbcheck.cpp:448 (performActualUpdate) Upgrading to MythTV schema version 1350
2019-07-02T19:37:47.198997-05:00 mythbackend[2405]: I CoreContext dbcheck.cpp:541 (UpgradeTVDatabaseSchema) Database schema upgrade complete.
2019-07-02T19:44:36.133063-05:00 mythbackend[3280]: I CoreContext schemawizard.cpp:120 (Compare) Current MythTV Schema Version (DBSchemaVer): 1350
2019-07-02T20:20:17.648967-05:00 mythbackend[2445]: I CoreContext schemawizard.cpp:120 (Compare) Current MythTV Schema Version (DBSchemaVer): 1350
2019-07-02T20:20:53.085446-05:00 mythbackend[2847]: I CoreContext schemawizard.cpp:120 (Compare) Current MythTV Schema Version (DBSchemaVer): 1350
2019-07-02T20:21:17.500434-05:00 mythbackend[3011]: I CoreContext schemawizard.cpp:120 (Compare) Current MythTV Schema Version (DBSchemaVer): 1350
2019-07-02T20:28:14.763261-05:00 mythbackend[3559]: I CoreContext schemawizard.cpp:120 (Compare) Current MythTV Schema Version (DBSchemaVer): 1350


Am I correct in determining the data base schema updated from 1348 to 1349 then to 1350?

Thanks

Author:  mattbatt [ Sun Jul 07, 2019 9:40 pm ]
Post subject:  Re: Confimring my database schema was updated

I also could not find a simple command to tell me which schema version I'm currently on. If you read this file it says what version it thinks we are on, I can't say whether this is actually checked against the database or not.
Code:
nano /usr/lib/python2.7/site-packages/MythTV/static.py

# -*- coding: utf-8 -*-

"""
Contains any static and global variables for MythTV Python Bindings
"""

OWN_VERSION = (30,0,-1,0)
SCHEMA_VERSION = 1350
NVSCHEMA_VERSION = 1007
MUSICSCHEMA_VERSION = 1024
PROTO_VERSION = '91'
PROTO_TOKEN = 'BuzzOff'
BACKEND_SEP = '[]:[]'
INSTALL_PREFIX = '/usr'


Page 1 of 1 All times are UTC - 6 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/