[mythtv] [mythtv-commits] Ticket #4013: Prompt before upgrading database schema
Nigel Pearson
nigel at ind.tansu.com.au
Thu Sep 27 03:59:52 UTC 2007
On 27/09/2007, at 3:49 AM, Isaac Richards wrote:
>> If IGNORE_PROTO_VER_MISMATCH isn't defined
>> most things are still safe because they
>> cannot actually talk to the backend.
>
> That doesn't check the DB version, does it?
True, but it negates most of the risk for backends
that are old enough to have a lesser protocol.
Of course, there is still a large risk window
if DB version has changed lots since the last
backend protocol change.
I started a statictical analysis of this:
http://www.mythtv.org/wiki/index.php/DatabaseProtoTimeline
but didn't get very far.
>> If you are still uncomfortable, maybe a second
>> OkPopup after the user selects "Use old..." ?
>
> How about a command line option to connect,
> instead? --really-connect-to-old-db-version-i-know-it-might-break-
> everything
Heh. I thought IGNORE_PROTO_VER_MISMATCH was a long symbol!
>> Possible, although the current ability to upgrade
>> from several programs is a lot simpler?
>
> I suppose, but maybe check that, if run from the frontend,
> no backends (or at least the master) are currently running?
Sure.
I guess if mythtv-setup or mythbackend are prompting
the the upgrade, having mythfrontends using the DB
is equally risky.
(Nigel's brain suddenly explodes
from the combinatorial overload)
Now I realise why we hadn't done this before :-(
> And maybe a second level
> confirmation that the upgrade will happen?
Will do. That will also give me more room
so I can improve the warning message(s).
And I will make the "Use old schema" optional
(depending on a magic value in DBSchemaAutoUpgrade)
--
Nigel Pearson, nigel at ind.tansu.com.au| 4 8
Telstra Net. Eng., Sydney, Australia | 15 16
Office: 9202 3900 Fax: 9261 3912 | 23 42
Mobile: 0408 664435 Home: 9792 6998 | Lost
More information about the mythtv-dev
mailing list