| chasemp added a comment. |
In T178661#3725222, @bd808 wrote:Actually we probably just need maintain-views --databases wikidatawiki --clean rather than all wikis.
labsdb1010:~# maintain-views --databases wikidatawiki --clean --replace-all
2017-11-15 20:30:05,262 INFO Full views for wikidatawiki:
2017-11-15 20:30:05,264 INFO [abuse_filter_action]
2017-11-15 20:30:05,285 INFO [babel]
2017-11-15 20:30:05,289 INFO [category]
2017-11-15 20:30:05,292 INFO [categorylinks]
2017-11-15 20:30:05,296 INFO [change_tag]
2017-11-15 20:30:05,342 INFO [externallinks]
2017-11-15 20:30:05,371 INFO [geo_tags]
2017-11-15 20:30:05,379 INFO [global_block_whitelist]
2017-11-15 20:30:05,384 INFO [image]
2017-11-15 20:30:05,387 INFO [imagelinks]
2017-11-15 20:30:05,393 INFO [interwiki]
2017-11-15 20:30:05,396 INFO [iwlinks]
2017-11-15 20:30:05,399 INFO [l10n_cache]
2017-11-15 20:30:05,402 INFO [langlinks]
2017-11-15 20:30:05,409 INFO [linter]
2017-11-15 20:30:05,416 INFO [math]
2017-11-15 20:30:05,419 INFO [module_deps]
2017-11-15 20:30:05,422 INFO [msg_resource_links]
2017-11-15 20:30:05,428 INFO [ores_classification]
2017-11-15 20:30:05,431 INFO [ores_model]
2017-11-15 20:30:05,434 INFO [page]
2017-11-15 20:30:05,441 INFO [pagelinks]
2017-11-15 20:30:05,451 INFO [page_props]
2017-11-15 20:30:05,454 INFO [page_restrictions]
2017-11-15 20:30:05,469 INFO [protected_titles]
2017-11-15 20:30:05,475 INFO [redirect]
2017-11-15 20:30:05,480 INFO [site_identifiers]
2017-11-15 20:30:05,484 INFO [sites]
2017-11-15 20:30:05,488 INFO [site_stats]
2017-11-15 20:30:05,492 INFO [tag_summary]
2017-11-15 20:30:05,496 INFO [templatelinks]
2017-11-15 20:30:05,499 INFO [transcode]
2017-11-15 20:30:05,503 INFO [updatelog]
2017-11-15 20:30:05,509 INFO [user_former_groups]
2017-11-15 20:30:05,513 INFO [user_groups]
2017-11-15 20:30:05,518 INFO [valid_tag]
2017-11-15 20:30:05,533 INFO [globalblocks]
2017-11-15 20:30:05,542 INFO [wb_changes]
2017-11-15 20:30:05,555 INFO [wb_changes_dispatch]
2017-11-15 20:30:05,559 INFO [wb_changes_subscription]
2017-11-15 20:30:05,562 INFO [wb_id_counters]
2017-11-15 20:30:05,566 INFO [wb_items_per_site]
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 166, in execute
result = self._query(query)
File "/usr/lib/python3/dist-packages/pymysql/cursors.py", line 322, in _query
conn.query(q)
File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 852, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 1053, in _read_query_result
result.read()
File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 1336, in read
first_packet = self.connection._read_packet()
File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 1010, in _read_packet
packet.check_error()
File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 393, in check_error
err.raise_mysql_exception(self._data)
File "/usr/lib/python3/dist-packages/pymysql/err.py", line 107, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.InternalError: (1205, 'Lock wait timeout exceeded; try restarting transaction')TASK DETAIL
EMAIL PREFERENCES
To: chasemp
Cc: bd808, chasemp, Magnus, hoo, daniel, jcrespo, Marostegui, Aklapper, Ladsgroup, Lahi, aborrero, GoranSMilovanovic, QZanden, Tbscho, JJMC89, Luke081515, Wikidata-bugs, aude, Gryllida, scfc, Mbch331, Krenair
Cc: bd808, chasemp, Magnus, hoo, daniel, jcrespo, Marostegui, Aklapper, Ladsgroup, Lahi, aborrero, 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
