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
https://phabricator.wikimedia.org/T178661

EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/

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
_______________________________________________
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

Reply via email to