IETF
tools@jabber.ietf.org
Wednesday, October 27, 2021< ^ >
Room Configuration
Room Occupants

GMT+0
[16:04:58] Chatroom is created
[16:04:58] Chatroom is started
[16:04:58] Glen (AMS IT) joins the room
Room Configuration
[16:05:16] Chatroom configuration modified
[16:07:14] Kesara Rathnayake_web_429 joins the room
[16:07:14] Robert Sparks_web_548 joins the room
[16:07:14] Michael Richardson_web_716 joins the room
[16:07:14] Lars Eggert_web_428 joins the room
[16:07:14] Ryan Cross_web_889 joins the room
[16:07:14] Jim Fenton_web_891 joins the room
[16:07:14] Jennifer Richards_web_424 joins the room
[16:07:14] Carsten Bormann_web_732 joins the room
[16:07:28] <Lars Eggert_web_428> ping
[16:07:32] <Glen (AMS IT)> Ack
[16:07:47] alexamirante joins the room
[16:08:23] alexamirante leaves the room
[16:09:07] cabo joins the room
[16:09:11] Nicolas Giard_web_807 joins the room
[16:09:16] Kesara Rathnayake_web_429 leaves the room
[16:09:18] <cabo> Hello
[16:09:26] <Glen (AMS IT)> Hello
[16:09:43] Glen (AMS IT) leaves the room
[16:09:46] Kesara Rathnayake_web_908 joins the room
[16:09:50] Russ Housley_web_544 joins the room
[16:10:38] <Michael Richardson_web_716> is Robert's message about this, with his research on tools-discuss?  Or am I looking in the wrong place?
[16:11:22] <Jim Fenton_web_891> Check his message to the codesprints list on the 12th
[16:11:52] <Jim Fenton_web_891> Subj: "Resources to help with the performance codesprint..."
[16:21:25] <Robert Sparks_web_548> https://notes.ietf.org/notes-ietf-interim-2021-tools-01-tools
[16:22:35] <Lars Eggert_web_428> is the hedgedoc integration working for others? spins for me without showing anything else
[16:23:11] <cabo> Lars: WFM
[16:23:39] <cabo> Strike that.  Works for me in separate browser.
[16:24:16] <Kesara Rathnayake_web_908> "Note Taking Tool" on meetecho is offline for me
[16:26:31] <Lars Eggert_web_428> it works in a new tab, but not in the integrated view
[16:29:55] <Jim Fenton_web_891> Hedgedoc works,but what integration do you mean?
[16:30:16] <Lars Eggert_web_428> the pen icon on the top right of the meetecho window
[16:33:12] <Robert Sparks_web_548> https://scoutapm.com/apps/348226/endpoints/aWV0Zi5ncm91cC52aWV3cy53Z19jaGFydGVyc19ieV9hY3Jvbnlt
[16:33:54] <Robert Sparks_web_548> https://scoutapm.com/apps/348226/endpoints/aWV0Zi5ncm91cC52aWV3cy53Z19jaGFydGVyc19ieV9hY3Jvbnlt?section=traces
[16:34:25] <Jim Fenton_web_891> Yeah, CodiMD integration is just spinning, showing as offline
[16:34:44] <Jim Fenton_web_891> (browser = Firefox)
[16:36:14] <cabo> Internet-Drafts submitted during the last 7 days — 11592 pages
[16:36:24] <cabo> https://datatracker.ietf.org/doc/recent
[16:42:50] Russ Housley_web_544 leaves the room
[16:42:58] Russ Housley_web_694 joins the room
[16:47:12] <cabo> Is the cache indexed by cookie?
[16:48:46] <Michael Richardson_web_716> https://datatracker.ietf.org/wg/1wg-charters-by-acronym.txt
[16:50:17] <Lars Eggert_web_428> @robert https://github.com/BurntSushi/ripgrep is your friend
[16:54:14] <cabo> Error parsing header X-XSS-Protection: 1; mode=block, 1; mode=block: expected semicolon at character position 14. The default protections will be applied.
[16:55:42] <Kesara Rathnayake_web_908> https://www.ietf.org/ietf-ftp/ietf/ points to that 1wg-summary-by-acronym.txt
[16:55:45] <cabo> Indeed, no caching on /doc/recent, always takes 29 s for me
[16:56:53] Robert Sparks_web_548 leaves the room
[16:58:33] Robert Sparks_web_664 joins the room
[16:58:50] <cabo> Need to drop for an hour, sorry
[16:59:10] Carsten Bormann_web_732 leaves the room
[17:01:22] Jack_web_987 joins the room
[17:01:57] Dave Anderson_web_581 joins the room
[17:03:51] <Michael Richardson_web_716> https://scoutapm.com/apps/348226/endpoints/Q29udHJvbGxlci9pZXRmLmRvYy52aWV3c19kb2MuZG9jdW1lbnRfbWFpbg==/trace/365516643?nplusone=13869.988§ion=allocations&version=1
[17:03:56] <Michael Richardson_web_716> might be what we are looking at.
[17:05:20] <Jim Fenton_web_891> hmm, that link doesn't work for me
[17:08:07] Jennifer Richards_web_424 leaves the room
[17:12:22] <Michael Richardson_web_716> datatracker.ietf.org/doc/draft-faltstrom-base45/
[17:12:37] <Michael Richardson_web_716> or /doc/draft-bradner-key-words/02/
[17:12:45] Michael Richardson_web_716 leaves the room
[17:12:51] Michael Richardson_web_482 joins the room
[17:13:03] <Michael Richardson_web_482> I reloaded, because my audio was shit.
[17:14:28] <Jim Fenton_web_891> I need to run for a brief medical appointment, back soon. Will stay in Meetecho but muted.
[17:19:13] Éric Vyncke_web_688 joins the room
[17:24:58] <Éric Vyncke_web_688> What are the ScoutAPM credentials ?
[17:25:26] <Michael Richardson_web_482> You need to be invited by Robert.
[17:26:41] <Robert Sparks_web_664> We are moving to zoom for a little bit:
[17:26:44] <Robert Sparks_web_664> We'll be here:
[17:26:45] <Robert Sparks_web_664> https://ietf.zoom.us/j/83225195383?pwd=eWduZHlmM1RXSDZpWEhvVHpNTnZvUT09
[17:26:58] Robert Sparks_web_664 leaves the room
[17:27:08] Russ Housley_web_694 leaves the room
[17:27:17] Dave Anderson_web_581 leaves the room
[17:27:20] Jack_web_987 leaves the room
[17:29:37] Éric Vyncke_web_688 leaves the room
[17:36:52] Kesara Rathnayake_web_908 leaves the room
[17:43:25] <Michael Richardson_web_482> I have to disconnect for a bit.
[17:43:31] Michael Richardson_web_482 leaves the room
[17:51:26] Jay Daley_web_846 joins the room
[17:56:51] Éric Vyncke_web_945 joins the room
[17:57:11] Robert Sparks_web_141 joins the room
[17:57:15] Kesara Rathnayake_web_376 joins the room
[17:57:31] <Robert Sparks_web_141> We are back here.
[18:13:54] <Robert Sparks_web_141> https://scoutapm.com/apps/348226/endpoints/aWV0Zi5pcHIudmlld3MuYnlfZHJhZnRfcmVjdXJzaXZlX3R4dA==
[18:15:11] <Robert Sparks_web_141> https://trac.ietf.org/trac/ietfdb/browser/tags/7.39.0/ietf/ipr/views.py#L461
[18:28:52] Lars Eggert_web_428 leaves the room
[18:28:59] Jay Daley_web_846 leaves the room
[18:35:48] <Ryan Cross_web_889> https://trac.ietf.org/trac/ietfdb/changeset/10272/
[18:39:39] Jay Daley_web_516 joins the room
[18:40:09] <Jay Daley_web_516> I'm back
[18:45:59] <Éric Vyncke_web_945> Installing the CodeSprint environment... installing the DB takes forever, so, quitting the call for today.
[18:46:07] <Éric Vyncke_web_945> See you tomorrow when a better set-up ;-)
[18:46:21] Éric Vyncke_web_945 leaves the room
[19:00:31] <Kesara Rathnayake_web_376> AFK
[19:05:48] Jay Daley_web_516 leaves the room
[19:08:17] <Robert Sparks_web_141> In [21]: doc = Document.objects.get(docalias__name='rfc2119')
In [22]: q = RelatedDocHistory.objects.filter(target__docs=doc, relationship='refnorm').select_related('source')
In [23]: print(q.query)
SELECT `doc_relateddochistory`.`id`, `doc_relateddochistory`.`source_id`, `doc_relateddochistory`.`target_id`, `doc_relateddochistory`.`relationship_id`, `doc_dochistory`.`id`, `doc_dochistory`.`time`, `doc_dochistory`.`type_id`, `doc_dochistory`.`title`, `doc_dochistory`.`stream_id`, `doc_dochistory`.`group_id`, `doc_dochistory`.`abstract`, `doc_dochistory`.`rev`, `doc_dochistory`.`pages`, `doc_dochistory`.`words`, `doc_dochistory`.`order`, `doc_dochistory`.`intended_std_level_id`, `doc_dochistory`.`std_level_id`, `doc_dochistory`.`ad_id`, `doc_dochistory`.`shepherd_id`, `doc_dochistory`.`expires`, `doc_dochistory`.`notify`, `doc_dochistory`.`external_url`, `doc_dochistory`.`uploaded_filename`, `doc_dochistory`.`note`, `doc_dochistory`.`internal_comments`, `doc_dochistory`.`doc_id`, `doc_dochistory`.`name` FROM `doc_relateddochistory` INNER JOIN `doc_docalias` ON (`doc_relateddochistory`.`target_id` = `doc_docalias`.`id`) INNER JOIN `doc_docalias_docs` ON (`doc_docalias`.`id` = `doc_docalias_docs`.`docalias_id`) INNER JOIN `doc_dochistory` ON (`doc_relateddochistory`.`source_id` = `doc_dochistory`.`id`) WHERE (`doc_relateddochistory`.`relationship_id` = refnorm AND `doc_docalias_docs`.`document_id` = 18589)
In [24]: q.explain()
Out[24]: '1 SIMPLE doc_docalias_docs ref doc_docalias_docs_docalias_id_document_id_0289170b_uniq,doc_docalias_docs_document_id_6d370a96 doc_docalias_docs_document_id_6d370a96 4 const 3 \n1 SIMPLE doc_docalias eq_ref PRIMARY PRIMARY 4 ietf_utf8.doc_docalias_docs.docalias_id 1 Using index\n1 SIMPLE doc_relateddochistory ref doc_relateddochistory_89f89e85,doc_relateddochistory_6e90f4fe,doc_relateddochistory_target2_id_6069e45a doc_relateddochistory_target2_id_6069e45a 4 ietf_utf8.doc_docalias_docs.docalias_id 93 Using where\n1 SIMPLE doc_dochistory eq_ref PRIMARY PRIMARY 4 ietf_utf8.doc_relateddochistory.source_id 1 '
[19:23:16] <Kesara Rathnayake_web_376> I'm looking at ietf.doc.views_search.search looks like dt has default limit of 200 results but the query goes and grabs all the documents.
[19:26:01] <Kesara Rathnayake_web_376> I have to step out now.
[19:49:51] <Robert Sparks_web_141> can someone summarize what ryan said?
[19:56:47] <Robert Sparks_web_141> (env) rjsparks@unformal 7.39.1.dev0 % ietf/manage.py dbshell
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 64
Server version: 10.5.12-MariaDB Source distribution
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [ietf_utf8]> show indexes for doc_relateddochistory;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'for doc_relateddochistory' at line 1
MariaDB [ietf_utf8]> show indexes from doc_relateddochistory;
[19:56:58] <Robert Sparks_web_141> ietf/manage.py dbshell
[19:57:12] <Robert Sparks_web_141> MariaDB [ietf_utf8]> show indexes from doc_relateddochistory;
[19:59:10] Robert Sparks_web_141 leaves the room
[19:59:13] Ryan Cross_web_889 leaves the room
[19:59:14] Nicolas Giard_web_807 leaves the room
[19:59:18] Jim Fenton_web_891 leaves the room
[19:59:33] Kesara Rathnayake_web_376 leaves the room
[20:24:28] RjS joins the room
Powered by ejabberd - robust, scalable and extensible XMPP server Powered by Erlang Valid XHTML 1.0 Transitional Valid CSS!