151-200 of 220 results (20ms)
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]