Marostegui added a comment. |
However, wikidatawiki keeps failing for the transaction time
[root@labsdb1003 13:56 /root] # maintain-views --databases wikidatawiki --clean --replace-all --mysql-socket /tmp/mysql.sock 2017-11-20 13:56:30,327 INFO Full views for wikidatawiki: 2017-11-20 13:56:30,328 INFO [abuse_filter_action] 2017-11-20 13:56:30,363 INFO [babel] 2017-11-20 13:56:30,367 INFO [category] 2017-11-20 13:56:30,386 INFO [categorylinks] 2017-11-20 13:56:30,393 INFO [change_tag] 2017-11-20 13:56:30,455 INFO [externallinks] 2017-11-20 13:56:30,481 INFO [geo_tags] 2017-11-20 13:56:30,500 INFO [global_block_whitelist] 2017-11-20 13:56:30,509 INFO [image] 2017-11-20 13:56:30,524 INFO [imagelinks] 2017-11-20 13:56:30,531 INFO [interwiki] 2017-11-20 13:56:30,536 INFO [iwlinks] 2017-11-20 13:56:30,541 INFO [l10n_cache] 2017-11-20 13:56:30,572 INFO [langlinks] 2017-11-20 13:56:30,580 INFO [linter] 2017-11-20 13:56:30,586 INFO [math] 2017-11-20 13:56:30,602 INFO [module_deps] 2017-11-20 13:56:30,604 INFO [msg_resource_links] 2017-11-20 13:56:30,611 INFO [ores_classification] 2017-11-20 13:56:30,614 INFO [ores_model] 2017-11-20 13:56:30,639 INFO [page]
Traceback (most recent call last): File "/usr/local/sbin/maintain-views", line 452, in <module> ops.execute(fullviews, customviews) File "/usr/local/sbin/maintain-views", line 272, in execute self.do_fullview(view) File "/usr/local/sbin/maintain-views", line 125, in do_fullview """.format(self.definer, self.db_p, view, self.db)) File "/usr/local/sbin/maintain-views", line 53, in write_execute self.cursor.execute(query) File "/usr/lib/python3/dist-packages/pymysql/cursors.py", line 158, in execute result = self._query(query) File "/usr/lib/python3/dist-packages/pymysql/cursors.py", line 308, in _query conn.query(q) File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 820, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 1002, in _read_query_result result.read() File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 1285, in read first_packet = self.connection._read_packet() File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 966, in _read_packet packet.check_error() File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 394, in check_error err.raise_mysql_exception(self._data) File "/usr/lib/python3/dist-packages/pymysql/err.py", line 120, in raise_mysql_exception _check_mysql_exception(errinfo) File "/usr/lib/python3/dist-packages/pymysql/err.py", line 115, in _check_mysql_exception raise InternalError(errno, errorvalue) pymysql.err.InternalError: (1205, 'Lock wait timeout exceeded; try restarting transaction')
TASK DETAIL
EMAIL PREFERENCES
To: chasemp, Marostegui
Cc: bd808, chasemp, Magnus, hoo, daniel, jcrespo, Marostegui, Aklapper, Ladsgroup, Lahi, aborrero, Gq86, GoranSMilovanovic, QZanden, Tbscho, JJMC89, Luke081515, Wikidata-bugs, aude, Gryllida, scfc, Mbch331, Krenair
Cc: bd808, chasemp, Magnus, hoo, daniel, jcrespo, Marostegui, Aklapper, Ladsgroup, Lahi, aborrero, Gq86, GoranSMilovanovic, QZanden, Tbscho, JJMC89, Luke081515, Wikidata-bugs, aude, Gryllida, scfc, Mbch331, Krenair
_______________________________________________ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs