[01:11:16] Analytics-EventLogging, Database: db1046 innodb signal 6 abort and restart - https://phabricator.wikimedia.org/T104748#1426083 (Springle) NEW a:Springle [08:41:40] Quarry: SELECT command denied to user for table 'logging_userindex' - https://phabricator.wikimedia.org/T99414#1426333 (Nemo_bis) Thanks. I got confused by the fact that the two names are equivalent when using `sql`. [15:19:39] (PS1) Yuvipanda: Make loading config.yaml optional [analytics/quarry/web] - https://gerrit.wikimedia.org/r/222766 [15:19:41] (PS1) Yuvipanda: Provide more usable defaults in default_config.yaml [analytics/quarry/web] - https://gerrit.wikimedia.org/r/222767 [15:19:43] (PS1) Yuvipanda: Add vagrant support! [analytics/quarry/web] - https://gerrit.wikimedia.org/r/222768 [15:21:52] (CR) Yuvipanda: [C: 2] Bump requests version to one that works ok without SSL3 [analytics/quarry/web] - https://gerrit.wikimedia.org/r/222705 (owner: Yuvipanda) [15:21:58] (Merged) jenkins-bot: Bump requests version to one that works ok without SSL3 [analytics/quarry/web] - https://gerrit.wikimedia.org/r/222705 (owner: Yuvipanda) [15:22:00] (CR) Yuvipanda: [C: 2] Make quarry.wsgi listen on all interfaces when run manually [analytics/quarry/web] - https://gerrit.wikimedia.org/r/222706 (owner: Yuvipanda) [15:22:06] (Merged) jenkins-bot: Make quarry.wsgi listen on all interfaces when run manually [analytics/quarry/web] - https://gerrit.wikimedia.org/r/222706 (owner: Yuvipanda) [15:22:09] (CR) Yuvipanda: [C: 2] Make tables.sql idempotent and fix stupid extra , [analytics/quarry/web] - https://gerrit.wikimedia.org/r/222707 (owner: Yuvipanda) [15:22:14] (Merged) jenkins-bot: Make tables.sql idempotent and fix stupid extra , [analytics/quarry/web] - https://gerrit.wikimedia.org/r/222707 (owner: Yuvipanda) [15:22:17] (CR) Yuvipanda: [C: 2] Make loading config.yaml optional [analytics/quarry/web] - https://gerrit.wikimedia.org/r/222766 (owner: Yuvipanda) [15:22:23] (Merged) jenkins-bot: Make loading config.yaml optional [analytics/quarry/web] - https://gerrit.wikimedia.org/r/222766 (owner: Yuvipanda) [15:22:25] (CR) Yuvipanda: [C: 2] Provide more usable defaults in default_config.yaml [analytics/quarry/web] - https://gerrit.wikimedia.org/r/222767 (owner: Yuvipanda) [15:22:30] (Merged) jenkins-bot: Provide more usable defaults in default_config.yaml [analytics/quarry/web] - https://gerrit.wikimedia.org/r/222767 (owner: Yuvipanda) [15:23:14] (PS2) Yuvipanda: Add vagrant support! [analytics/quarry/web] - https://gerrit.wikimedia.org/r/222768 [15:23:27] (CR) Yuvipanda: [C: 2] Add vagrant support! [analytics/quarry/web] - https://gerrit.wikimedia.org/r/222768 (owner: Yuvipanda) [15:23:33] (Merged) jenkins-bot: Add vagrant support! [analytics/quarry/web] - https://gerrit.wikimedia.org/r/222768 (owner: Yuvipanda) [15:31:46] (PS2) Yuvipanda: Add VIM mode [analytics/quarry/web] - https://gerrit.wikimedia.org/r/197076 (owner: Milimetric) [15:33:37] (PS1) Yuvipanda: Upgrade CodeMirror to latest (5.4) [analytics/quarry/web] - https://gerrit.wikimedia.org/r/222769 [15:35:41] (CR) Yuvipanda: [C: 2] Upgrade CodeMirror to latest (5.4) [analytics/quarry/web] - https://gerrit.wikimedia.org/r/222769 (owner: Yuvipanda) [15:35:46] (Merged) jenkins-bot: Upgrade CodeMirror to latest (5.4) [analytics/quarry/web] - https://gerrit.wikimedia.org/r/222769 (owner: Yuvipanda) [15:42:07] Quarry: Quarry's indentation function is not completely functional - https://phabricator.wikimedia.org/T101424#1426532 (yuvipanda) So this is using the sql mode of the codemirror code editor, and this seems to be that one's behavior. I guess possible options are: # Turn off autoindent for everyone # Make it... [15:43:12] Quarry: Suggested Feature: Put title of the query into the HTML title for page - https://phabricator.wikimedia.org/T99449#1426536 (yuvipanda) Open>Resolved a:yuvipanda This was done a while ago :) [15:44:29] (PS1) Yuvipanda: Use 'this' rather than 'your' to indicate query status [analytics/quarry/web] - https://gerrit.wikimedia.org/r/222771 (https://phabricator.wikimedia.org/T103275) [15:44:39] (CR) Yuvipanda: [C: 2] Use 'this' rather than 'your' to indicate query status [analytics/quarry/web] - https://gerrit.wikimedia.org/r/222771 (https://phabricator.wikimedia.org/T103275) (owner: Yuvipanda) [15:44:45] (Merged) jenkins-bot: Use 'this' rather than 'your' to indicate query status [analytics/quarry/web] - https://gerrit.wikimedia.org/r/222771 (https://phabricator.wikimedia.org/T103275) (owner: Yuvipanda) [16:00:43] Quarry, Easy, Patch-For-Review: String "Your query is currently executing" should be "This query..." - https://phabricator.wikimedia.org/T103275#1426547 (yuvipanda) Open>Resolved a:yuvipanda Fixed! Thank you for reporting it! [16:22:15] Quarry: Raise query limits - https://phabricator.wikimedia.org/T74342#1426565 (yuvipanda) Note that current limit is 20mins instead of 10 [16:24:02] Quarry: Allow published query titles to be searched or filtered by tag - https://phabricator.wikimedia.org/T90509#1426572 (yuvipanda) [17:02:02] (PS1) Yuvipanda: Added support for json-lines output format [analytics/quarry/web] - https://gerrit.wikimedia.org/r/222773 (https://phabricator.wikimedia.org/T98492) [17:02:41] (CR) Yuvipanda: [C: 2] Added support for json-lines output format [analytics/quarry/web] - https://gerrit.wikimedia.org/r/222773 (https://phabricator.wikimedia.org/T98492) (owner: Yuvipanda) [17:02:47] (Merged) jenkins-bot: Added support for json-lines output format [analytics/quarry/web] - https://gerrit.wikimedia.org/r/222773 (https://phabricator.wikimedia.org/T98492) (owner: Yuvipanda) [17:06:04] (PS1) Yuvipanda: Upgrade version of nunjucks [analytics/quarry/web] - https://gerrit.wikimedia.org/r/222774 [17:06:55] (CR) Yuvipanda: [C: 2] Upgrade version of nunjucks [analytics/quarry/web] - https://gerrit.wikimedia.org/r/222774 (owner: Yuvipanda) [17:07:00] (Merged) jenkins-bot: Upgrade version of nunjucks [analytics/quarry/web] - https://gerrit.wikimedia.org/r/222774 (owner: Yuvipanda) [17:09:03] Quarry, Patch-For-Review: JSON output should be one row per JSON blob - https://phabricator.wikimedia.org/T98492#1426586 (yuvipanda) Open>Resolved a:yuvipanda This has been implemented as the 'json lines' output format. [17:10:30] Quarry: Make query URLs have a sluggified version of the title in them - https://phabricator.wikimedia.org/T75885#1426595 (yuvipanda) Yeah, we totally should - don't think there's any other way to do this. [17:10:37] Quarry: Make query URLs have a sluggified version of the title in them - https://phabricator.wikimedia.org/T75885#1426596 (yuvipanda) p:Triage>Normal [17:13:30] Quarry, Patch-For-Review: Remember filters: "All queries", "Published queries", etc. chosen by user in recent queries page - https://phabricator.wikimedia.org/T76084#1426599 (yuvipanda) [17:14:14] Quarry: Build a vagrant box for Quarry dev - https://phabricator.wikimedia.org/T71193#1426605 (yuvipanda) Open>Resolved There's a Vagrantfile in the repo now :) [17:23:33] (PS1) Yuvipanda: Do not sort by first column by default [analytics/quarry/web] - https://gerrit.wikimedia.org/r/222775 (https://phabricator.wikimedia.org/T87829) [17:23:53] (CR) Yuvipanda: [C: 2] Do not sort by first column by default [analytics/quarry/web] - https://gerrit.wikimedia.org/r/222775 (https://phabricator.wikimedia.org/T87829) (owner: Yuvipanda) [17:23:59] (Merged) jenkins-bot: Do not sort by first column by default [analytics/quarry/web] - https://gerrit.wikimedia.org/r/222775 (https://phabricator.wikimedia.org/T87829) (owner: Yuvipanda) [17:25:18] Quarry, Patch-For-Review: Quarry does not respect ORDER BY sort order in result set - https://phabricator.wikimedia.org/T87829#1426614 (yuvipanda) Open>Resolved a:yuvipanda Just fixed it :) Thanks for reporting the issue, and apologies for such late resolution. [17:26:46] Quarry: Unicode in query results in strange behavior - https://phabricator.wikimedia.org/T71224#742694 (yuvipanda) Is this still happening? [17:26:55] Quarry, Patch-For-Review: Excel does not recognize Quarry CSV output as UTF-8 - https://phabricator.wikimedia.org/T76126#1426626 (valhallasw) UTF-8 with BOM also works fine, and should be easier to implement. [18:04:51] Quarry: Number of queries shown in profile is wrong - https://phabricator.wikimedia.org/T86512#1426673 (yuvipanda) This seems to be a somewhat strange sqlalchemy issue... [19:04:44] (PS1) Yuvipanda: Moved login, logout related code into a blueprint [analytics/quarry/web] - https://gerrit.wikimedia.org/r/222841 [19:04:49] (CR) jenkins-bot: [V: -1] Moved login, logout related code into a blueprint [analytics/quarry/web] - https://gerrit.wikimedia.org/r/222841 (owner: Yuvipanda) [19:08:29] (PS2) Yuvipanda: Moved login, logout related code into a blueprint [analytics/quarry/web] - https://gerrit.wikimedia.org/r/222841 [19:14:22] (PS1) Yuvipanda: Move template helpers to new blueprint [analytics/quarry/web] - https://gerrit.wikimedia.org/r/222843 [19:44:30] (CR) Yuvipanda: [C: 2] Moved login, logout related code into a blueprint [analytics/quarry/web] - https://gerrit.wikimedia.org/r/222841 (owner: Yuvipanda) [19:44:35] (Merged) jenkins-bot: Moved login, logout related code into a blueprint [analytics/quarry/web] - https://gerrit.wikimedia.org/r/222841 (owner: Yuvipanda) [19:46:15] (CR) Yuvipanda: [C: 2] Move template helpers to new blueprint [analytics/quarry/web] - https://gerrit.wikimedia.org/r/222843 (owner: Yuvipanda) [19:46:20] (Merged) jenkins-bot: Move template helpers to new blueprint [analytics/quarry/web] - https://gerrit.wikimedia.org/r/222843 (owner: Yuvipanda) [20:25:05] Quarry: WMF employees use an internal Quarry instance to share data & sample queries - https://phabricator.wikimedia.org/T75142#1426761 (Krenair) Why do we need an internal WMF-only instance of Quarry? [20:32:50] Quarry: WMF employees use an internal Quarry instance to share data & sample queries - https://phabricator.wikimedia.org/T75142#1426765 (yuvipanda) Labsdb is redacted but internal analytics store isn't. [20:36:37] Quarry: WMF employees use an internal Quarry instance to share data & sample queries - https://phabricator.wikimedia.org/T75142#1426769 (Krenair) So you're going to provide all WMF employees (and presumably contractors etc. as well?) with access to all the research data via some sort of corp Quarry instance? [20:39:11] Quarry: WMF employees use an internal Quarry instance to share data & sample queries - https://phabricator.wikimedia.org/T75142#1426770 (yuvipanda) Such a thing has been proposed, primarily for eventlogging information. It would be for anyone with enough clearance to access it. Currently nobody is spending t... [20:44:04] Quarry: WMF employees use an internal Quarry instance to share data & sample queries - https://phabricator.wikimedia.org/T75142#1426778 (Krenair) So actually it wouldn't be just for WMF employees, it would actually be something in production that some of the groups defined in puppet get access to (via SSH pr... [20:47:55] Quarry: WMF employees use an internal Quarry instance to share data & sample queries - https://phabricator.wikimedia.org/T75142#1426780 (yuvipanda) There already exists such a group (researchers I think?) so this might piggy back off it. Or not - we don't know. Will be determined if / when someone starts wor... [20:50:22] Quarry: WMF employees use an internal Quarry instance to share data & sample queries - https://phabricator.wikimedia.org/T75142#1426783 (Krenair) That was the group I had in mind, I know for a fact it's not 100% WMF employees. Will adjust the title. [20:52:19] Quarry: Build an internal Quarry instance to share data & sample queries between researchers (and other analytics users?) - https://phabricator.wikimedia.org/T75142#1426785 (Krenair)