[mythtv] [mythtv-commits] mythtv commit: r17970 by nigel

Nigel Pearson nigel at ind.tansu.com.au
Tue Jul 29 06:39:44 UTC 2008


> DBUtil::lockSchema() only returns false if there was an error locking
> the schemalock table.  If it tries to lock and is blocked by another
> existing lock, then the SQL lock command blocks waiting for the lock
> to succeed.

Damn. No, that isn't quite what I was expecting.
Thanks for the code review.


Blocking is OK for now, but in the long term
something like this might be better:

bool DBUtil::isSchemaLocked(void)
...
     query.exec('SHOW OPEN TABLES');
...
         if (query.value(1) == 'schemalock' &&
             query.value(2) == 1)
             return true;


--
Nigel Pearson, nigel at ind.tansu.com.au|"Smart mice ... varmints
Telstra Net. Eng., Sydney, Australia | used vector formulas.
Office: 9202 3900    Fax:  9261 3912 |   How'd you catch them?
Mobile: 0408 664435  Home: 9792 6998 | Smart cheese.





More information about the mythtv-dev mailing list