43 results (21ms)
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]
2017-07-31 §
16:31 <zhuyifei1999_> Repeated for quarry-main-01, but restarted uwsgi T146483 [quarry]
16:30 <zhuyifei1999_> Repeated for quarry-runner-02 [quarry]
16:28 <zhuyifei1999_> Restarted celery-quarry-worker on quarry-runner-01 T146483 [quarry]
16:22 <zhuyifei1999_> `zhuyifei1999@quarry-runner-01:/srv/quarry$ sudo git fetch; sudo git checkout 6447943` T146483 [quarry]
01:01 <zhuyifei1999_> `zhuyifei1999@quarry-main-01:/srv/quarry$ sudo git fetch; sudo git checkout 7dd8c60; sudo service uwsgi restart` T101424 [quarry]
2017-07-30 §
21:17 <zhuyifei1999_> `sudo service uwsgi restart` T76126 [quarry]
21:14 <zhuyifei1999_> `sudo git fetch; sudo git checkout 172eb7e` on /srv/quarry T76126 [quarry]
20:10 <zhuyifei1999_> Yuvi gave me access after I asked about T76126 [quarry]
2017-06-30 §
22:34 <bd808> Added BryanDavis (self) as project admin [quarry]
18:09 <bd808> Ran service uwsgi-quarry-web restart on quarry-main-01. People seeing intermittent 502s [quarry]
2017-06-26 §
18:33 <milimetric> Restarted celery workers on quarry-runner-01 and quarry-runner-02 (systemctl restart celery-quarry-worker.service) [quarry]
17:20 <madhuvishy> Add milimetric as project admin [quarry]
2017-01-19 §
12:07 <yuvipanda> run chown -R 998:998 quarry/ on labstore1004 [quarry]
2016-10-05 §
19:48 <mutante> quarry-runner-01 has a problem starting exim4 [quarry]
19:47 <mutante> merged gerrit 308313 - should definitely be no-op, but noticed that puppet is disabled on quarry-main-01 [quarry]
2016-10-04 §
19:33 <valhallasw`cloud> removed myself as admin [quarry]
2016-09-23 §
20:41 <yuvipanda> add halfak as projectadmin [quarry]
2016-05-08 §
21:35 <Krenair> restarted quarry-runner-01 to attempt to get the queue working again - new queries are going through but some old ones (from the last few hours) seem stuck [quarry]
2016-04-02 §
14:06 <valhallasw`cloud> systemctl restart celery-quarry-worker.service hangs. Will now reboot quarry-runner-02. [quarry]
14:02 <valhallasw`cloud> killed 100% CPU using process on quarry-runner-02 (ptrace suggested some sort of idle loop). Let's see if that has any effect. [quarry]