Updating searchindex between 20120308183323 and 20120309183323 --- Waiting for lock --- A database error has occurred Query: SELECT lc_value FROM `vw_l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'deps' LIMIT 1 Function: LCStore_DB::get Error: 1100 Table 'vw_l10n_cache' was not locked with LOCK TABLES (mysql.zbase.temporalvagabonds.net)
I'm getting this error when running updateSearchIndex.php. I'm a bit of a novice when it comes to this stuff so I was wondering what should I be looking at to fix whatever this is?
On 09/03/12 19:40, P. Hightower wrote:
Updating searchindex between 20120308183323 and 20120309183323 --- Waiting for lock --- A database error has occurred Query: SELECT lc_value FROM `vw_l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'deps' LIMIT 1 Function: LCStore_DB::get Error: 1100 Table 'vw_l10n_cache' was not locked with LOCK TABLES (mysql.zbase.temporalvagabonds.net)
I'm getting this error when running updateSearchIndex.php. I'm a bit of a novice when it comes to this stuff so I was wondering what should I be looking at to fix whatever this is?
Do you know if it's a InnoDB or MyIsam table?
On Mar 14, 2012 12:02 PM, "P. Hightower" sgriobhadair@gmail.com wrote:
On 03/11/2012 08:04 PM, Platonides wrote:
Do you know if it's a InnoDB or MyIsam table?
Probaby, InnoDB, almost sure of that.
Try running
SHOW CREATE TABLE tablename\G
You should then see the engine name on the last line of output.
-Jeremy
mediawiki-l@lists.wikimedia.org