[mythtv-users] strange sql logs in backend logfile

[Mike Perkins]

brad dreisbach wrote:
> 
> On Apr 24, 2009, at 8:55 AM, David Watkins wrote:
> 
>>> No error type from QSqlError?  Strange...
>>
>> In my experience that error normally means that the connection to the
>> database has been lost, though if everything else is working that
>> seems unlikely.
> 
> 
> hrmmm....I turned on some extra logging flags and am seeing this over 
> and over
> again:
> 
> 2009-04-24 09:27:43.534 MSqlQuery::exec() "SELECT data FROM settings 
> WHERE value = 'WakeUpThreshold' AND hostname = 'backend.domain.com' ;"
> 2009-04-24 09:27:43.536 MSqlQuery::exec() "SELECT data FROM settings 
> WHERE value = 'WakeUpThreshold' AND hostname IS NULL;"
> 
> could this be overloading mysql?  am I missing a setting in the settings 
> table?
> 
You might have a single borked table in your db. That would cause the localised 
errors while allowing the rest to function normally.

-- 

Mike Perkins