Last modified: 2012-12-12 16:04:04 UTC
The wiki give me this message when I'm trying to save after editing some pages: ---------- S'ha produït un error de sintaxi en una consulta a la base de dades. Açò podria indicar un error en el programari. La darrera consulta que s'ha intentat fer ha estat: (consulta SQL oculta) des de la funció «SMW::updateDatasmw_atts2». L'error de retorn ha estat «1205: Lock wait timeout exceeded; try restarting transaction (95.211.14.38) --------- This is in catalan (the wiki language), the translation could be: --------- There was a syntax error in a query to database. This may indicate a bug in the software. The last attempted database query was: (hidden SQL query) from the function «SMW::updateDatasmw_atts2». The returned error was «1205: Lock wait timeout exceeded; try restarting transaction (95.211.14.38) --------- I'm feeling that this happen after runing 'php SMW_refreshData.php -v' from shell. Maybe with the pages created by users during it. These pages hasn't properties when I click the browse properties link (and the page contain templates with property settings). After several hours the problem disappears. PHP 5.2.6-1+lenny8 (apache2handler) MYSQL 5.0.51a-24+lenny2 MW 1.17.0 SMW 1.6.1 SF 2.4-alpha r109396 More version info: http://lletra.uoc.edu/viquilletra/Especial:Versi%C3%B3
We currently get this error frequently in connection with updating a larger set of SMW records (about 100,000) using runJobs.php. A template was changed which makes various SMW assignments in the form "[[property name::value]]". runJobs.php refreshes the data and the error obviously occurs when such SMW-assignments are refreshed. If a page is affected by the error, no SMW assignments (and also no category assignments) are made, unless the page is saved again manually. Typically, the error message with runJobs.php looks as follows: A database query syntax error has occurred. The last attempted database query was: "INSERT INTO `smw_atts2` (s_id,p_id,value_xsd,value_num) VALUES ('13359','63','non-target effects/fate in environm.',''), ('13359','68','2003',''),('13359','66','Environmental Entomology',''),('13359','65','270','270'),('13359','69','32 (2)',''), ('13359','81','2003','2003'),('13359','57','biocontrol - natural enemies',''),('13359','29','2011/2/14T08:56:18','2455606.8724306')" from within function "SMW::updateDatasmw_atts2". Database returned error "1213: Deadlock found when trying to get lock; try restarting transaction (localhost)" The error appears very irregularly. It may occur after a few records are refreshed, after 50 or 100 records, or after several thousand records. We also observe this error sometimes if pages with such SMW assignments are modified and saved manually. In such cases again no SMW assignments are made but the same pages save correctly including the SMW assignments when the SAVE is repeated. PHP 5.3.16-1~dotdeb.0 (apache2handle) MYSQL 5.1.63-0+squeeze1 MW 1.18.1 SMW 1.7.1 Semantic Forms 2.3.2 (r106345) More version info: http://wiki.pestinfo.org/wiki/Special:Version With thanks in advance for looking into this.
The smw_atts2 table (part of SQLStore2) is no longer in use for SMW 1.8/SQLStore3 and unless a similar problem can be reported in connection with SMW 1.8/SQLStore3, this bug is put to be resolved as development/support on SQLStore2 has been closed. Please feel free to reopen this bug again if it applies to SMW 1.8/SQLStore3.
Marking WONTFIX as per http://lists.wikimedia.org/pipermail/wikitech-l/2012-November/064240.html I don't think there is going to be any support for SQLStore2. Also this bug seems to be caused by deadlocks in transactions but we aren't using any transactions in SQLStore2 as per my knowledge.
