[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 14:16:58 UTC 2010


HI!

On 26.07.2010 02:22, Kevin Kuphal wrote:

> A quick perusal of the code shows me that those "delete settings" are
> part of the displayprofile configuration pages and normal for they way
> those settings are stored.
> 
> http://svn.mythtv.org/trac/browser/tags/release-0-23-1/mythtv/programs/mythfrontend/globalsettings.cpp
> 
> <http://svn.mythtv.org/trac/browser/tags/release-0-23-1/mythtv/programs/mythfrontend/globalsettings.cpp>(grep
> for DeleteDB)
> 
> and you'll see that it removes and saves settings and if you look up
> that code in libmythtv/videoprofilegroup.cpp you'll see that it indeed
> calls DELETE and INSERT statements and is doing nothing mailicious to
> your database and is not the source of your problem

I did not say, that the DELETEs are the source of the connection
problem. But they are responsible for a loss of settings (see title of
the ticket).

> The problem (at least according to your logs) is that mythfrontend, by
> virtual of the QT mysql library, has reported that your database is
> inaccessible and no longer has a connection to the database.  This
> either means 1) there is a problem in the mysql client library on your
> system) or 2) your mysql is crashing
> 
> I'd check out both of those scenarios.

Since there is nothing in the backend logs and I can "fix" the
connection problem by just restarting mythfrontend, I guess it is 1).

But that is not the point of my ticket.

The point is, that mythfrontend continues, after there was an apparent
severe MySQL failure when executing SELECTs. It just does not make sense
to continue in this case and to delete the displayprofiles and reset the
mythgallery settings.

Of course it is really strange, that the mysql client lib reports
failures for both the SELECTs and DELETEs, but in fact the DELETEs
succeeded. But that is another story.

Thomas



More information about the mythtv-dev mailing list