The new wiki will be public.
Description
Description
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | Ladsgroup | T249506 Create Wiktionary Konkani | |||
| Resolved | Andrew | T250706 Prepare and check storage layer for gomwiktionary |
Event Timeline
Comment Actions
Thanks for the heads up - let us know when the database is created so we can sanitize it
Comment Actions
Sanitization is in place, waiting on a complete private data check before handing it over to Cloud for view creation.
Comment Actions
Private data check passed.
I've created gomwiktionary_p, and given the labsdbuser role a grant to it. This is now ready for cloud-services-team to create the views.
Comment Actions
cloud-services-team please create the views also on db1141 (temporary host replacing labsdb1011)
Comment Actions
I always feel like I'm flying blind when I do this, but I've run the steps on https://wikitech.wikimedia.org/wiki/Add_a_wiki#Cloud_Services and this DB is now visible on Quarry. I think that means we're done.
Comment Actions
This needs to be run on labsdb1011 as well. The reason why it needs to be run there is because it is being recovered from several crashes
Comment Actions
I've run maintain-replica-indexes and maintain-views on labsdb1011; the maintain_meta_p command fails:
andrew@labsdb1011:~$ sudo /usr/local/sbin/maintain-meta_p --databases gomwiktionary
/usr/lib/python2.7/dist-packages/pymysql/cursors.py:166: Warning: (1007, u"Can't create database 'meta_p'; database exists")
result = self._query(query)
/usr/lib/python2.7/dist-packages/pymysql/cursors.py:166: Warning: (1050, u"Table 'wiki' already exists")
result = self._query(query)
Traceback (most recent call last):
File "/usr/local/sbin/maintain-meta_p", line 375, in <module>
main()
File "/usr/local/sbin/maintain-meta_p", line 194, in main
seed_schema(ops)
File "/usr/local/sbin/maintain-meta_p", line 102, in seed_schema
FROM meta_p.wiki;""")
File "/usr/local/sbin/maintain-meta_p", line 44, in write_execute
self.cursor.execute(query)
File "/usr/lib/python2.7/dist-packages/pymysql/cursors.py", line 166, in execute
result = self._query(query)
File "/usr/lib/python2.7/dist-packages/pymysql/cursors.py", line 322, in _query
conn.query(q)
File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 852, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 1053, in _read_query_result
result.read()
File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 1336, in read
first_packet = self.connection._read_packet()
File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 1010, in _read_packet
packet.check_error()
File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 393, in check_error
err.raise_mysql_exception(self._data)
File "/usr/lib/python2.7/dist-packages/pymysql/err.py", line 107, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.InternalError: (1347, u"'meta_p.legacy' is not VIEW")Comment Actions
labsdb1011 is still reimporting lots of data, so maybe we should wait till it is already finished - some moving pieces for that script might not be ready yet.
Comment Actions
Yeah, ETA will be more than a week unfortunately :(
I will comment on this tag when ready. Thank you!