[mythtv] Ticket #8679: mythfrontend deletes settings when db connection is "weak" (was Re: Please unlock ticket)

Thomas Börkel thomas at boerkel.de
Mon Jul 26 20:27:06 UTC 2010


On 26.07.2010 19:28, Michael T. Dean wrote:

>> If the database schema was broken, what it ever run without errors?
> Yes, until it hit the code that issued the SQL that won't work with your
> schema.

OK, so why would it issue this code only once a month during start of
the frontend?

Anyway, since I activated -v database now, maybe this will reveal something.

> On an unrelated note, (but just to make the point that broken schemas
> aren't noticed immediately) this is exactly why we recommend against
> users doing things to the DB.  When someone breaks the DB (either the
> data or the schema), they create a ticking time bomb.  Generally, by the
> time they notice a failure, it's been long enough that they no longer
> suspect that the "fixing" they did is what caused it.

That's right.

Is there any way that one can compare the schema to the "correct" schema?


More information about the mythtv-dev mailing list