151-200 of 220 results (22ms)
2018-09-12
§
|
20:27 |
<zhuyifei1999_> |
backed up old db to /data/project/dump-2018-09-12.sql and restoring to new server T202588 |
[quarry] |
20:03 |
<zhuyifei1999_> |
set quarry-main-01 mariadb read-only T202588 |
[quarry] |
20:02 |
<zhuyifei1999_> |
stopped celery-quarry-worker on quarry-runner-0{1,2} T202588 |
[quarry] |
19:45 |
<zhuyifei1999_> |
created new quarry database and user in quarry-db-01.quarry.eqiad.wmflabs T202588 |
[quarry] |
2018-09-11
§
|
17:22 |
<zhuyifei1999_> |
doing another backup of main db: `sudo mysqldump quarry | sudo tee /data/project/dump-$(date '+%Y-%m-%d').sql > /dev/null` T202588 |
[quarry] |
17:14 |
<zhuyifei1999_> |
disabling puppet on quarry-main-01, quarry-runner-0{1,2} T202588 |
[quarry] |
2018-09-07
§
|
21:06 |
<zhuyifei1999_> |
reverted hotpatch, deployed till 3375dc3 |
[quarry] |
20:47 |
<zhuyifei1999_> |
hotpatch /etc/uwsgi/apps-enabled/quarry-web.ini processes 8 -> 1 for some gdb-ing |
[quarry] |
19:56 |
<framawiki> |
deployed 501695f to quarry-main-01 (T202588) |
[quarry] |
18:11 |
<framawiki> |
deployed 769cace to quarry-main-01 (T202588) |
[quarry] |
2018-08-24
§
|
21:21 |
<framawiki> |
deployed 4814d58 (T124625) to quarry-main-01 |
[quarry] |
2018-05-31
§
|
15:52 |
<zhuyifei1999_> |
live-patch `/srv/quarry/quarry/web/connections.py` on `quarry-main-01` and restart uwsgi |
[quarry] |
2018-05-07
§
|
22:40 |
<framawiki> |
deployed 24038e3 to quarry-main-01 |
[quarry] |
2018-05-04
§
|
02:05 |
<zhuyifei1999_> |
Deployed 6069904 |
[quarry] |
2018-05-02
§
|
18:23 |
<framawiki> |
deployed af2f7e6 to quarry-main-01 |
[quarry] |
18:04 |
<zhuyifei1999_> |
Deployed f4e86f1 and restarted everything |
[quarry] |
2018-04-24
§
|
21:36 |
<framawiki> |
removing old /srv/venv on quarry-main-01 T192731 |
[quarry] |
2018-04-23
§
|
22:50 |
<zhuyifei1999_> |
Does quarry only have an effective concurrency limit of 3, despite having a few dozen celery worker processes?! |
[quarry] |
22:46 |
<zhuyifei1999_> |
behaving abnormally. https://quarry.wmflabs.org/query/26629 has been queued for 16 mins... (hopefully) have some time to investigate |
[quarry] |
2018-04-18
§
|
23:21 |
<framawiki> |
deployed 02049d9 to quarry-main-01 |
[quarry] |
22:21 |
<zhuyifei1999_> |
+Framawiki project admin & Gerrit +2 |
[quarry] |
19:35 |
<zhuyifei1999_> |
deployed c6cd55e to quarry-main-01 |
[quarry] |
17:36 |
<zhuyifei1999_> |
deployed 8eeeff8 to quarry-main-01 |
[quarry] |
2018-04-17
§
|
22:59 |
<zhuyifei1999_> |
forgot to restart uwsgi on last deployment. restarted it now |
[quarry] |
00:34 |
<zhuyifei1999_> |
Deploy b5fd6b0 on quarry-main-01 |
[quarry] |
2018-03-24
§
|
03:21 |
<zhuyifei1999_> |
revert back to d9cc1c8 again on quarry-runner0{1,2} T188564 T190608 |
[quarry] |
2018-03-16
§
|
00:29 |
<zhuyifei1999_> |
deploying fc109c2 to both runners T188564 |
[quarry] |
2018-03-15
§
|
19:27 |
<zhuyifei1999_> |
switch back to d9cc1c8 on both hosts |
[quarry] |
16:29 |
<zhuyifei1999_> |
quarry-runner-02 is on d9cc1c8 |
[quarry] |
16:21 |
<zhuyifei1999_> |
installed python-dbg on quarry-runner-02 because it's so good |
[quarry] |
16:18 |
<zhuyifei1999_> |
depool quarry-runner-01 |
[quarry] |
15:56 |
<zhuyifei1999_> |
deploying d653400 to quarry-runner-0{1,2} T188564 |
[quarry] |
2018-03-01
§
|
18:41 |
<zhuyifei1999_> |
deploying d5e2845 to quarry-runner-01 & 02 |
[quarry] |
00:37 |
<zhuyifei1999_> |
`UPDATE query join query_revision on query.latest_rev_id = query_revision.id join query_run on latest_run_id = query_run.id SET status=1 where (status = 2 or status = 1) and query_run.timestamp <= DATE_ADD(NOW(), INTERVAL -1 HOUR);` 251 rows affected (1.81 sec) T139162 T172086 T188564 |
[quarry] |
2018-02-28
§
|
22:57 |
<zhuyifei1999_> |
killed two IO-intensive query saves |
[quarry] |
2018-02-09
§
|
01:06 |
<bd808> |
Removed TestingAccount2 at user request (T186289) |
[quarry] |
01:06 |
<bd808> |
Removed Yuvipanda at user request (T186289) |
[quarry] |
2018-01-02
§
|
10:52 |
<zhuyifei1999_> |
deploying d9cc1c8 to quarry-runner-01 & 02 T172143 |
[quarry] |
2017-12-13
§
|
19:19 |
<zhuyifei1999_> |
Deployed 62676f2 to quarry-main-01 and restarted uwsgi |
[quarry] |
2017-12-10
§
|
05:52 |
<zhuyifei1999_> |
deployed e835a46 to quarry-main-01 and restarted uwsgi T165169 |
[quarry] |
05:49 |
<zhuyifei1999_> |
quarry-main-01: `ALTER IGNORE TABLE star ADD UNIQUE INDEX star_user_query_index (user_id, query_id);` Records: 728 Duplicates: 17 Warnings: 0 T165169 |
[quarry] |
2017-12-05
§
|
18:56 |
<zhuyifei1999_> |
quarry-main-01: `MariaDB [quarry]> UPDATE user SET username = '-revi' WHERE username = 'Hym411';` T182064 |
[quarry] |
2017-10-02
§
|
05:15 |
<zhuyifei1999_> |
Deployed 644b293 to quarry-main-01 and restarted uwsgi |
[quarry] |
2017-09-26
§
|
04:08 |
<zhuyifei1999_> |
Restarting service 'uwsgi-quarry-web' on quarry-main-01, 'celery-quarry-worker' on quarry-runner-01 & quarry-runner-02 T176694 |
[quarry] |
03:59 |
<zhuyifei1999_> |
Switching REPLICA_HOST from 'enwiki.labsdb' to 'enwiki.analytics.db.svc.eqiad.wmflabs' T176694 (Executing `sudo -- sudo -u quarry sed -i 's/enwiki.labsdb/enwiki.analytics.db.svc.eqiad.wmflabs/' /srv/quarry/quarry/config.yaml` on all hosts) |
[quarry] |
2017-09-10
§
|
16:22 |
<zhuyifei1999_> |
Deployed a6173a2 on quarry-main-01 T175466 |
[quarry] |
2017-09-08
§
|
18:06 |
<zhuyifei1999_> |
Deployed d9e8a4a to quarry-main-01 T175285 |
[quarry] |
2017-09-06
§
|
00:05 |
<zhuyifei1999_> |
backup quarry main database to /data/project/dump-2017-09-05.sql because I fear it die :(. Executing `sudo mysqldump quarry | sudo tee /data/project/dump-2017-09-05.sql > /dev/null` |
[quarry] |
2017-08-11
§
|
11:12 |
<zhuyifei1999_> |
deployed 2834160 on quarry-main-01 |
[quarry] |
2017-08-01
§
|
12:51 |
<zhuyifei1999_> |
Deployed ba54a61 on quarry-main-01 T164390 |
[quarry] |