https://bugzilla.wikimedia.org/show_bug.cgi?id=67602
--- Comment #7 from merl <[email protected]> --- After the change to mariadb10 nearly all of my script always failed with one of two different errors: ERROR 2013 (HY000): Lost connection to MySQL server during query ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction I solved this by prepending all sql scripts with SET SESSION tx_isolation='READ-UNCOMMITTED'; Sean also raised the lock timeout in between. I haven't checked if this makes my session based transaction isolation level change unnecessary. All scripts/queries using joins with commonswiki are running successful now. But i have not tested all scripts today. I'll make a complete report within the next two days. There seems at least a problem with two scripts querying wikidata only (wikidatawiki_p.wb_terms). I am still investigating in this problem. These had been running on s5.labsdb with mariadb5 without problems. -- You are receiving this mail because: You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
