You are browsing a read-only backup copy of Wikitech. The live site can be found at wikitech.wikimedia.org

Nova Resource:Quarry/SAL: Revision history

Jump to navigation Jump to search

Diff selection: Mark the radio buttons of the revisions to compare and hit enter or the button at the bottom.
Legend: (cur) = difference with latest revision, (prev) = difference with preceding revision, m = minor edit.

10 August 2022

  • curprev 13:5913:59, 10 August 2022imported>Stashbot 26,684 bytes +250 Rook: 821344: api: return consistently | https://gerrit.wikimedia.org/r/c/analytics/quarry/web/+/821344

8 August 2022

  • curprev 16:4416:44, 8 August 2022imported>Stashbot 26,434 bytes +148 Rook: Escape '|' from wikitable output c456f3ce007b9fae44e59677c4a7fcdf38564e67 T308362

6 July 2022

  • curprev 08:4008:40, 6 July 2022imported>Stashbot 26,286 bytes +145 dcaro: rebooting worker-04 due to being unable to ssh to it (things started segfaulting, then too much work for irq)

23 June 2022

  • curprev 10:2310:23, 23 June 2022imported>Stashbot 26,141 bytes +148 Rook: 807534: Introduce black formatting to quarry | https://gerrit.wikimedia.org/r/c/analytics/quarry/web/+/807534

22 June 2022

  • curprev 20:5020:50, 22 June 2022imported>Stashbot 25,993 bytes +149 Rook: 806474: Get non-coincidental history entries. | https://gerrit.wikimedia.org/r/c/analytics/quarry/web/+/806474

21 June 2022

  • curprev 11:4811:48, 21 June 2022imported>Stashbot 25,844 bytes +152 Rook: 806504: Show username on 404 page when logged in | https://gerrit.wikimedia.org/r/c/analytics/quarry/web/+/806504

16 June 2022

  • curprev 21:1321:13, 16 June 2022imported>Stashbot 25,692 bytes +193 Rook: 806271: Prettify User not found page | https://gerrit.wikimedia.org/r/c/analytics/quarry/web/+/806271 8002e6f06c64568441d7fc5ddc70ea2525a4c6fb

6 June 2022

  • curprev 15:4915:49, 6 June 2022imported>Stashbot 25,499 bytes +207 Rook: 791669: Update stop status directly and catch error | https://gerrit.wikimedia.org/r/c/analytics/quarry/web/+/791669 57a0e45dfe5d4736e79dff07e0054fb511aca718

17 May 2022

  • curprev 12:2312:23, 17 May 2022imported>Stashbot 25,292 bytes +411 Rook: Deploying: 791606: Return 404 on query ids that do not exist | https://gerrit.wikimedia.org/r/c/analytics/quarry/web/+/791606 e19b0a5e706f7e853f66b0d376c43cd499d8a0e2

16 May 2022

  • curprev 17:3217:32, 16 May 2022imported>Stashbot 24,881 bytes +827 Rook: 788438: Use vars.qrun_id when stopping query | https://gerrit.wikimedia.org/r/c/analytics/quarry/web/+/788438 43f7f0c9f56ac01f1a92b200769ddbe782055381

18 April 2022

  • curprev 18:3418:34, 18 April 2022imported>Stashbot 24,054 bytes +193 Rook: update phab links to prefilled ticket https://phabricator.wikimedia.org/T303028

4 April 2022

25 March 2022

  • curprev 12:0412:04, 25 March 2022imported>Stashbot 23,806 bytes +136 dcaro: rebooting quarry-worker-04.quarry.eqiad1.wikimedia.cloud due to stuck nfs (T304681)

21 March 2022

20 February 2022

  • curprev 19:4919:49, 20 February 2022imported>Stashbot 23,578 bytes +265 andrewbogott: moving nfs service from quarry-nfs-1 (bullseye) to quarry-nfs-2 (buster), testing to see if T302154 is a kernal or nfs-version issue

19 February 2022

11 February 2022

  • curprev 21:1121:11, 11 February 2022imported>Stashbot 23,233 bytes +120 andrewbogott: switching shared nfs project dir (again) to internal nfs server quarry-nfs-1

10 February 2022

29 January 2022

  • curprev 23:4223:42, 29 January 2022imported>Stashbot 23,025 bytes +109 taavi: deploying https://gerrit.wikimedia.org/r/c/analytics/quarry/web/+/749756/

27 September 2021

7 September 2021

3 September 2021

  • curprev 17:3917:39, 3 September 2021imported>Stashbot 22,732 bytes +233 andrewbogott: restarting celery workers and reloading web UI to pick up timeout changes

1 September 2021

  • curprev 21:5621:56, 1 September 2021imported>Stashbot 22,499 bytes +292 andrewbogott: switched /srv/quarry to branch 'master' on quarry-worker-03, quarry-worker-04, quarry-web-02

16 August 2021

  • curprev 10:2510:25, 16 August 2021imported>Stashbot 22,207 bytes +314 dcaro: Reverting deploy of T287471 - saved queries fail to show the DB field, will open a task

6 May 2021

  • curprev 17:5717:57, 6 May 2021imported>Stashbot 21,893 bytes +229 bstorm: restarting web service to remove banner for wikireplicas upgrade

23 April 2021

  • curprev 18:5118:51, 23 April 2021imported>Stashbot 21,664 bytes +126 Framawiki: ran apt updates without issues on all 4 servers. T266386 looks fixed.

7 April 2021

2 April 2021

  • curprev 09:0509:05, 2 April 2021imported>Stashbot 21,455 bytes +87 Framawiki: shutdown quarry-dev server, normally unused now

26 March 2021

  • curprev 19:2719:27, 26 March 2021imported>Stashbot 21,368 bytes +122 bstorm: deploying changes to the replica class and restarting things T278544

25 March 2021

23 March 2021

  • curprev 21:4521:45, 23 March 2021imported>Stashbot 20,940 bytes +624 bstorm: restarting quarry services for the meta_p and centralauth issue T264254

20 February 2021

  • curprev 13:1813:18, 20 February 2021imported>Stashbot 20,316 bytes +261 wm-bot: framawiki: Deployed f51f9a9 on -web-01 T275277 (not yet merged)

15 February 2021

  • curprev 19:2419:24, 15 February 2021imported>Stashbot 20,055 bytes +411 Reedy: stash'd patch saved to quarry-web-01.quarry.eqiad1.wikimedia.cloud:/root/T274815.patch T274815

12 February 2021

15 December 2020

  • curprev 17:4317:43, 15 December 2020imported>Stashbot 19,561 bytes +681 Reedy: quarry-worker-02 `systemctl restart uwsgi-quarry-web.service` again, after pulling patch for T270195

20 October 2020

  • curprev 16:1116:11, 20 October 2020imported>Stashbot 18,880 bytes +237 bstorm: restarted mariadb on quarry-db-01 so it pointed to the right data directory

3 September 2020

  • curprev 17:1417:14, 3 September 2020imported>Stashbot 18,643 bytes +226 Framawiki: `framawiki@quarry-web-01:/tmp$ find /tmp/* -mtime +360 -user www-data -exec sudo rm -v {} \;` 775 files deleted for 10G. Again. T261909

8 July 2020

  • curprev 19:2319:23, 8 July 2020imported>Stashbot 18,417 bytes +195 Framawiki: `framawiki@quarry-web-01:/tmp$ find /tmp/* -mtime +360 -user www-data -exec sudo rm -v {} \;` 778 files deleted for 10G.

6 March 2020

  • curprev 19:3219:32, 6 March 2020imported>Stashbot 18,222 bytes +147 zhuyifei1999_: changed to analytics replica for database queries and restarted celery workers T246970

26 February 2020

14 January 2020

1 January 2020

14 November 2019

  • curprev 21:5921:59, 14 November 2019imported>Stashbot 17,588 bytes +199 zhuyifei1999_: `zhuyifei1999@quarry-web-01:/tmp$ find /tmp/* -mtime +360 -user www-data -exec sudo rm -v {} \;` T238375

19 October 2019

  • curprev 15:3915:39, 19 October 2019imported>Stashbot 17,389 bytes +279 wm-bot: framawiki: Deployed 90a1bef on -web-01 (`query-status.html: fix compiled.js`)

2 October 2019

  • curprev 17:2017:20, 2 October 2019imported>Stashbot 17,110 bytes +92 mutante: - mariadb::packages should now work on buster too, fyi

1 October 2019

28 June 2019

21 June 2019

14 June 2019

25 May 2019

  • curprev 12:5812:58, 25 May 2019imported>Stashbot 16,588 bytes +2,432 framawiki: block spammer `INSERT INTO user_group (user_id, group_name) VALUES (3765, "blocked");`

24 December 2018

2 December 2018

27 November 2018

  • curprev 18:5418:54, 27 November 2018imported>Stashbot 13,836 bytes +117 zhuyifei1999_: triggered OOM killer on quarry-worker-02 9 times T188564

16 November 2018

12 November 2018

5 November 2018

  • curprev 18:4918:49, 5 November 2018imported>Stashbot 13,473 bytes +874 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 = 0) and query_run.timestamp <= DATE_ADD(NOW(), INTERVAL -30 MINUTE);`...

4 November 2018

  • curprev 22:2422:24, 4 November 2018imported>Stashbot 12,599 bytes +227 zhuyifei1999_: checked out FETCH_HEAD 8c065d0, previous head was 71643b6 on quarry-web-01

21 October 2018

15 October 2018

  • curprev 18:5218:52, 15 October 2018imported>Stashbot 12,265 bytes +131 framawiki: deployed c1dfde7 on quarry-web-01, quarry-worker-0{1,2} T126888

6 October 2018

26 September 2018

  • curprev 13:2413:24, 26 September 2018imported>Stashbot 12,050 bytes +1,128 zhuyifei1999_: restarted mariadb on -db-01 after max_allowed_packet fix

17 September 2018

  • curprev 20:0620:06, 17 September 2018imported>Stashbot 10,922 bytes +4,536 framawiki: deployed till e59152e T192696 T204432 T204226 T204430 to quarry-web-01

16 March 2018

  • curprev 00:2900:29, 16 March 2018imported>Stashbot 6,386 bytes +502 zhuyifei1999_: deploying fc109c2 to both runners T188564

1 March 2018

  • curprev 18:4118:41, 1 March 2018imported>Stashbot 5,884 bytes +77 zhuyifei1999_: deploying d5e2845 to quarry-runner-01 & 02
  • curprev 00:3700:37, 1 March 2018imported>Stashbot 5,807 bytes +460 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...

9 February 2018

2 January 2018

  • curprev 10:5210:52, 2 January 2018imported>Stashbot 5,169 bytes +122 zhuyifei1999_: deploying d9cc1c8 to quarry-runner-01 & 02 T172143

13 December 2017

  • curprev 19:1919:19, 13 December 2017imported>Stashbot 5,047 bytes +109 zhuyifei1999_: Deployed 62676f2 to quarry-main-01 and restarted uwsgi

10 December 2017

  • curprev 05:5205:52, 10 December 2017imported>Stashbot 4,938 bytes +327 zhuyifei1999_: deployed e835a46 to quarry-main-01 and restarted uwsgi T165169

5 December 2017

  • curprev 18:5618:56, 5 December 2017imported>Stashbot 4,611 bytes +166 zhuyifei1999_: quarry-main-01: `MariaDB [quarry]> UPDATE user SET username = '-revi' WHERE username = 'Hym411';` T182064

2 October 2017

  • curprev 05:1505:15, 2 October 2017imported>Stashbot 4,445 bytes +109 zhuyifei1999_: Deployed 644b293 to quarry-main-01 and restarted uwsgi

26 September 2017

  • curprev 04:0804:08, 26 September 2017imported>Stashbot 4,336 bytes +467 zhuyifei1999_: Restarting service 'uwsgi-quarry-web' on quarry-main-01, 'celery-quarry-worker' on quarry-runner-01 & quarry-runner-02 T176694

10 September 2017

8 September 2017

6 September 2017

  • curprev 00:0500:05, 6 September 2017imported>Stashbot 3,641 bytes +229 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`

11 August 2017

1 August 2017

  • curprev 12:5112:51, 1 August 2017imported>Stashbot 3,323 bytes +114 zhuyifei1999_: Deployed ba54a61 on quarry-main-01 T164390

31 July 2017

  • curprev 16:3116:31, 31 July 2017imported>Stashbot 3,209 bytes +384 zhuyifei1999_: Repeated for quarry-main-01, but restarted uwsgi T146483
  • curprev 01:0101:01, 31 July 2017imported>Stashbot 2,825 bytes +467 zhuyifei1999_: `zhuyifei1999@quarry-main-01:/srv/quarry$ sudo git fetch; sudo git checkout 7dd8c60; sudo service uwsgi restart` T101424

30 June 2017

26 June 2017

  • curprev 18:3318:33, 26 June 2017imported>Stashbot 2,179 bytes +207 milimetric: Restarted celery workers on quarry-runner-01 and quarry-runner-02 (systemctl restart celery-quarry-worker.service)

19 January 2017

  • curprev 12:0712:07, 19 January 2017imported>Stashbot 1,972 bytes +1,972 yuvipanda: run chown -R 998:998 quarry/ on labstore1004