https://bugzilla.wikimedia.org/show_bug.cgi?id=35375
Bernhard Zelazny <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected], | |[email protected] --- Comment #1 from Bernhard Zelazny <[email protected]> 2012-08-31 13:04:42 UTC --- 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. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
