51-100 of 154 results (7ms)
2018-11-05 §
17:40 <zhuyifei1999_> set db read-only `FLUSH TABLES WITH READ LOCK; SET GLOBAL read_only = 1;` T207677 [quarry]
17:24 <zhuyifei1999_> shutting down all workers `sudo kill -TERM $(systemctl show -p MainPID celery-quarry-worker.service | cut -d= -f2)` T207677 [quarry]
2018-11-04 §
22:24 <zhuyifei1999_> checked out FETCH_HEAD 8c065d0, previous head was 71643b6 on quarry-web-01 [quarry]
17:37 <framawiki> deployed c10fc32 and 71643b6 on quarry-web-01 [quarry]
2018-10-21 §
16:19 <zhuyifei1999_> deployed 99db770 to workers T126888 [quarry]
2018-10-15 §
18:52 <framawiki> deployed c1dfde7 on quarry-web-01, quarry-worker-0{1,2} T126888 [quarry]
2018-10-06 §
16:30 <framawiki> deployed 8550956 on quarry-web-01 [quarry]
2018-09-26 §
13:24 <zhuyifei1999_> restarted mariadb on -db-01 after max_allowed_packet fix [quarry]
2018-09-25 §
12:09 <arturo> make myself projectadmin [quarry]
2018-09-24 §
22:33 <framawiki> manually clear queries and resultsets where userid=3214 T205286 [quarry]
22:31 <framawiki> `update query_run set status=3 where id=290865;` on quarry-db-01 to mark a ghost query as killed on the ui [quarry]
21:50 <framawiki> `select * from query_run where id=290865;` on quarry-db-01 to mark a ghost query as killed on the ui [quarry]
17:54 <framawiki> quarry-db-01: `INSERT INTO user_group (user_id, group_name) VALUES (3214, "blocked");` T205286 [quarry]
17:53 <framawiki> deployed 028a292 on quarry-web-01 T205286 T104322 [quarry]
2018-09-23 §
16:56 <zhuyifei1999_> deployed till e74f575 on -web-01, T202588 T205153 [quarry]
2018-09-21 §
19:29 <framawiki> deployed 4b01077 on quarry-web-01 T204964 [quarry]
2018-09-19 §
16:57 <framawiki> deployed 4994570 to quarry-web-01 T204805 [quarry]
2018-09-17 §
20:06 <framawiki> deployed till e59152e T192696 T204432 T204226 T204430 to quarry-web-01 [quarry]
17:40 <framawiki> deployed e8e6e02 to quarry-web-01 T73064 [quarry]
2018-09-16 §
16:28 <zhuyifei1999_> Deployed till 2081a97 on -web-01 T204435 [quarry]
2018-09-13 §
22:09 <zhuyifei1999_> purging stuffs created by labs_debrepo T153615 [quarry]
21:40 <zhuyifei1999_> deployed 8b4bde0 to quarry-web-01 T204277 [quarry]
19:19 <framawiki> deleted legacy instances quarry-main-01 and quarry-runner-0{1,2}, migration is over T202588 [quarry]
19:10 <framawiki> copy /var/log/nginx from legacy main-01 to /data/project/nginx-logs-legacy-20180913-framawiki for further analysis T202588 T197256 [quarry]
2018-09-12 §
21:21 <zhuyifei1999_> unset read-only again on new database [quarry]
21:15 <zhuyifei1999_> `sudo chown quarry:quarry /data/project/quarry/ -Rv` T202588 [quarry]
21:13 <zhuyifei1999_> set read-only again on new database because new quarry's UID is 498 T202588 [quarry]
21:10 <zhuyifei1999_> unset read-only again on new database [quarry]
21:09 <zhuyifei1999_> rm'ed /var/lib/mysql on -db-01, we are using /srv/sqldata/ now, and if something goes really better have a loud failure [quarry]
21:03 <zhuyifei1999_> deployed 8b4bde0 to -web-01 T204161 [quarry]
21:01 <zhuyifei1999_> deployed 461e56c [quarry]
20:45 <zhuyifei1999_> set read-only again on new database due to a bug in worker code [quarry]
20:42 <zhuyifei1999_> unset read-only on new database T202588 [quarry]
20:41 <framawiki> switched quarry.wmflabs.org proxy to new quarry-web-01.quarry.eqiad.wmflabs [quarry]
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]