ESC meeting minutes: 2024-04-04

[Miklos Vajna <vmiklos@xxxxxxxxxxxxx>]

* Present:
    + Cloph, Hossein, Michael W, Olivier, Caolan, Ilmari, Jonathan, Michael S, Stephan, Xisco, Miklos, Heiko, Thorsten

* Completed Action Items:

* Pending Action Items:

* Release Engineering update (Cloph)
    + 7.6: 7.6.7 RC1 week 16
    + 24.2: 24.2.3 RC1 week 15

* Welcome Jonathan Clark

    - New RTL/CTL/CJK developer

    - working for TDF

    - reviewing bug backlog currently

    - preferred IRC nick? :-) (Xisco)

      - jclark or so


* Documentation (Olivier)
    + New Help
       + Some CSS fixes (JJ)
    + Helpcontents2
       + Fixes and updates (D. MAddern)
       + Housekeeping some "D'oh! you found a bug" (ohallot)
       + Updates on hyphenation pages ( L. Nemetz)
    + Guides
       + WIP
       + xml:id (https://docs.oasis-open.org/office/OpenDocument/v1.3/os/part3-schema/OpenDocument-v1.3-os-part3-schema.html#__RefHeading__1419430_253892949)
          + Is it implemented/used in LO?
          + It's implement in Writer, but only for a fraction of the elements allowed by the schema (Michael S)
          + should work for <text:p> and other metadata-related ones
          + see https://wiki.documentfoundation.org/Documentation/DevGuide/OfficeDev/RDF_metadata#RDF_metadata
          + bottom of the page has the details, can generate an ID using the API / by a macro
          + would be helpful for translation as well (Olivier)
          + also on the TDF wiki these days (Thorsten)
    + API website looks outdated, it's on 7.4 (Olivier)
      + https://api.libreoffice.org/
AI: Cloph to update this

    + Bugzilla Documentation statistics
        269(269) bugs open
    + Updates:
        BZ changes   1 week   1 month    3 months   12 months
           created      8(-4)    52(-9)     88(3)     229(-2)
         commented     15(0)    102(-15)   242(3)     893(-2)
          resolved      1(-6)    20(-6)     38(-2)    117(-4)
    + top 10 contributors:
          Pierre F made 30 changes in 1 month, and 30 changes in 1 year
          Olivier Hallot made 29 changes in 1 month, and 260 changes in 1 year
          Stéphane Guillou made 18 changes in 1 month, and 262 changes in 1 year
          Adolfo Jayme Barrientos made 17 changes in 1 month, and 23 changes in 1 year
          Ilmari Lauhakangas made 14 changes in 1 month, and 92 changes in 1 year
          Vernon, Stuart Foote made 14 changes in 1 month, and 83 changes in 1 year
          Heiko Tietze made 13 changes in 1 month, and 94 changes in 1 year
          Kaganski, Mike made 12 changes in 1 month, and 67 changes in 1 year
          *UNKNOWN* made 11 changes in 1 month, and 11 changes in 1 year
          Dione Maddern made 10 changes in 1 month, and 21 changes in 1 year

* UX Update (Heiko)
    + Bugzilla (topicUI) statistics
        246(246) (topicUI) bugs open, 41(41) (needsUXEval) needs to be evaluated by the UXteam
    + Updates:
        BZ changes   1 week    1 month    3 months   12 months
             added      4(-5)     18(-1)     20(0)       30(-1)
         commented     50(-41)   265(-10)   536(37)    2029(18)
           removed      1(1)       1(1)       1(1)       13(0)
          resolved      8(1)      28(3)      80(5)      313(3)
    + top 10 contributors:
          Stéphane Guillou made 112 changes in 1 month, and 665 changes in 1 year
          Heiko Tietze made 95 changes in 1 month, and 1153 changes in 1 year
          Vernon, Stuart Foote made 59 changes in 1 month, and 287 changes in 1 year
          Eyal Rozenberg made 29 changes in 1 month, and 170 changes in 1 year
          Kaganski, Mike made 25 changes in 1 month, and 118 changes in 1 year
          Justin Luth made 18 changes in 1 month, and 140 changes in 1 year
          Patrick Luby made 17 changes in 1 month, and 24 changes in 1 year
          Devansh Varshney made 16 changes in 1 month, and 20 changes in 1 year
          Ady made 12 changes in 1 month, and 134 changes in 1 year
          m.a.riosv made 12 changes in 1 month, and 62 changes in 1 year
    + [Bug 160505] Implement "recency" navigation for Calc module and make available
           from TB or Sidebar Navigator
    + [Bug 160249] Support marking text as having an arbitrary language
    + [Bug 160452] Calc: default anchor everything to CELL
    + [Bug 160447] styles: allow us to copy, clone styles, plz
    + [Bug 160441] F11 Stylist deck -- provide a user's "favorite" style grouping for
           each style category
    + [Bug 160445] change default of Settings > Application Colors > Custom Colors >
           Automatic from "Light" to "System Theme"
      + https://fosstodon.org/@libodesign/112201034714884916
    + [Bug 160442] export "style sheets" and import them -- a long way to go yet,
           isn't it?
    + [Bug 160411] Support an "XY+Value" scatter plot chart type
    + [Bug 160350] Replies to comment are in reverse order
    + [Bug 160349] Add toolbar icons to change UI and scheme to switch Light/Dark
    + [Bug 160324] Column resize handle touch-target too small
 -> + [Bug 35694] "Page number" automatic field stops counting before last page if
           offset >0 (see comment 22)
           + already has input from Mike K
 -> + [Bug 160317] Pressing Tab with partially selected numbered paragraphs deletes
           content instead of changing level

* Crash Testing (Caolan)
    + 28(+18) import failure, 1(-7) export failures
    + 3 coverity issues
    + 10 ossfuzz issues
      + sc HTML one keeps finding problems
    + runtime gone from 3-4 days to 1.5 days for a crashtest run

* Crash Reporting (Xisco)
    + 7.6.5.2    6336(+0)
    + 7.6.6.3    43(+0)
    + 24.2.0.3    13858(+741)
    + 24.2.1.2    8152(+1706)
    + 24.2.2.2    458(+0)

    -> signatures in https://crashreport.libreoffice.org/stats/version/24.2.2.2 not resolved

* Mentoring (Hossein)
 + New draft blog post:
   Crash fixes part 3 - Testing crashes
   https://dev.blog.documentfoundation.org/?p=1130&preview=1&_ppp=a4fbc3aacc
          committer...   1 week     1 month     3 months   12 months
                  open      76(1)      155(-4)     175(11)     175(11)
               reviews     456(6)     1590(-24)   4070(78)   12514(202)
                merged     250(-15)   1087(-88)   3433(17)   12472(62)
             abandoned       6(-7)      52(-23)    170(-9)     663(-3)
           own commits     177(11)     732(-58)   2250(-8)    9292(8)
        review commits      75(2)      322(-9)     956(21)    3060(49)
        contributor...   1 week    1 month      3 months   12 months
                  open      60(11)    102(13)      106(13)     106(13)
               reviews     830(14)   2892(-188)   8064(62)   29820(136)
                merged      67(40)    153(24)      368(35)    1836(26)
             abandoned       5(-4)     23(-40)     287(-4)     684(-2)
           own commits      58(16)    181(17)      457(34)    1109(48)
        review commits       0(0)       0(0)         0(0)        0(0)
    + easyHack statistics:
       needsDevEval 8(8)   needsUXEval 1(1)   cleanup_comments 333(333)
       total 414(414)   assigned 30(30)   open 349(349)
    + top 10 contributors:
          Pierre F made 24 patches in 1 month, and 24 patches in 1 year
          LeSasse made 19 patches in 1 month, and 19 patches in 1 year
          Rafał Dobrakowski made 10 patches in 1 month, and 15 patches in 1 year
          Armin Le Grand (allotropia) made 10 patches in 1 month, and 88 patches in 1 year
          Ritobroto Mukherjee made 9 patches in 1 month, and 9 patches in 1 year
          Stéphane Guillou made 8 patches in 1 month, and 62 patches in 1 year
          Dione Maddern made 6 patches in 1 month, and 30 patches in 1 year
          Bogdan B made 5 patches in 1 month, and 22 patches in 1 year
          Xuan Chen made 3 patches in 1 month, and 5 patches in 1 year
          Sujatro Bhadra made 3 patches in 1 month, and 3 patches in 1 year
    + top 10 reviewers:
          Vajna, Miklos made 120 review comments in 1 month, and 1092 in 1 year
          Adolfo Jayme Barrientos made 118 review comments in 1 month, and 490 in 1 year
          Nabet, Julien made 114 review comments in 1 month, and 972 in 1 year
          Grandin, Noel made 110 review comments in 1 month, and 706 in 1 year
          Caolán McNamara made 108 review comments in 1 month, and 1342 in 1 year
          Olivier Hallot made 84 review comments in 1 month, and 360 in 1 year
          Christian Lohmaier made 74 review comments in 1 month, and 374 in 1 year
          Ilmari Lauhakangas made 74 review comments in 1 month, and 488 in 1 year
          Hossein made 66 review comments in 1 month, and 304 in 1 year
          Xisco Fauli made 66 review comments in 1 month, and 780 in 1 year
    + Patches automatically abandoned:
        tdf#144563 Omit unnecessary suffixes from cross-references to numbered ( Troy Rollo )
            - https://gerrit.libreoffice.org/#/c/152854
        sal: osl::File allow to create files in sandbox ( Michael Meeks )
            - https://gerrit.libreoffice.org/#/c/160250
        xmlsecurity nss certdb debug ( Michael Stahl )
            - https://gerrit.libreoffice.org/#/c/162578
    + big CONGRATULATIONS to contributors who have at least 1 merged patch, since last report:
          Aaron Bourdeaux
          AntonyDas Nadar (Collabora)
          Glen Campbell
          LeSasse
          Sahil Gautam
          Vil C

* Outreachy (Ilmari)
    + Khushi's patch for Quick Find in Sidebar ready to merge codewise
      + soon to get this over the finish line

* GSoC (Ilmari)
    + https://summerofcode.withgoogle.com/programs/2024/organizations/libreoffice
    + https://wiki.documentfoundation.org/Development/GSoC/2024
    + April 24: project rankings due
    + Patch review help appreciated: https://wiki.documentfoundation.org/Development/gerrit/CommonQueries

* Commit Access

* Developer Certification (Stephan/Miklos/László/Gabriel)
  + resting since: 0 weeks (limit: 20 weeks)

* Jenkins / CI update (Cloph)
gerrit_android_aarch64     jobs: 173 ok: 169 ko:   1 fail ratio: 0.58% mean_ok:   9 ( 14) median_ok:   6 (  8)
gerrit_android_arm         jobs: 173 ok: 171 ko:   2 fail ratio: 1.16% mean_ok:   8 ( 13) median_ok:   6 (  8)
gerrit_android_x86         jobs: 174 ok: 167 ko:   3 fail ratio: 1.72% mean_ok:   9 ( 13) median_ok:   6 (  8)
gerrit_android_x86_64      jobs: 174 ok: 173 ko:   1 fail ratio: 0.57% mean_ok:   8 ( 13) median_ok:   6 (  7)
gerrit_linux_clang_dbgutil jobs: 346 ok: 297 ko:  45 fail ratio: 13.01% mean_ok:  33 ( 38) median_ok:  27 ( 33)
gerrit_linux_gcc_release   jobs: 423 ok: 332 ko:  62 fail ratio: 14.66% mean_ok:  16 ( 19) median_ok:  14 ( 15)
gerrit_mac                 jobs: 341 ok: 316 ko:  16 fail ratio: 4.69% mean_ok:  53 ( 53) median_ok:  49 ( 49)
gerrit_windows             jobs: 350 ok: 301 ko:  34 fail ratio: 9.71% mean_ok:  64 ( 93) median_ok:  68 ( 71)
gerrit_master_ml           jobs: 429 ok: 256 ko: 130 fail ratio: 30.30% mean_ok: 108 (108) median_ok:  89 ( 90)
gerrit_master              jobs:  29 ok:  16 ko:   8 fail ratio: 27.59% mean_ok:  74 ( 74) median_ok:  69 ( 69)
gerrit_master_seq          jobs: 398 ok: 241 ko: 119 fail ratio: 29.90% mean_ok: 110 (110) median_ok:  91 ( 91)
   + tests that failed more than twice in last seven days
      3 CppunitTest_vcl_cjk                gerrit_windows
      5 aborted by jenkins job timeout                gerrit_windows
      5 Killed by the kill-wrapper                gerrit_linux_clang_dbgutil
      9 CppunitTest_services                gerrit_linux_gcc_release
    + this week was mostly smooth sailing (Cloph)
      + Windows build times went up: 50 mins (in Feb) -> 65 mins
      + the first number is the actual building, the one in () includes the time waiting in the queue

* What’s cooking (Miklos)
    + A11y update (Michael W)
      + gtk4: implement new text interface methods for text/character extent handling,
        related GTK upstream fixes
      + Accerciser improvements
    + Working on a procedure to ease translation of guides (ODT documents) (ohallot)
      + so there would be no need to manually review what content needs updating

* Move of Jenkins to a different system (Cloph)
  + right now it's a VM on the TDF hypervisor
  + moving it to a cloud VM instead
  + also the external tarballs are problematic to be fetched for fdroid
    + where is that hosted? (Thorsten)
    + it was at SUSE, now it's just a VM (Cloph)
  + should be mostly invisible for the users, just some minutes of downtime (Cloph)

* COOL Days 2024 (Miklos)
  + https://www.collaboraoffice.com/cool-days-2024/  8th -> 10th April
  + LibreOffice Technology hackfest as part of it

* QA update (Xisco)
    + UNCONFIRMED: 1155 (+23)
        + enhancements: 282  (+2)
        + needsUXEval: 13 (+1)
        + haveBackTrace: 10 (-1)
        + needsDevAdvice: 44 (+0)
        + documentation:  3 (+1)
        + android:  0 (-1)
        + iOS:  0 (+0)
        + Online:  9 (+0)


    + Most pressing bugs:
     New:

    None


    + New high severity bugs of the week:
        None

* QA stats (Stéphane)
    + https://bugs.documentfoundation.org/page.cgi?id=weekly-bug-summary.html
      +115  -16 (-99) overall)
      many thanks to the top bug squashers:
       Stéphane Guillou (stragu) 21
       QA Administrators       11
       Caolán McNamara         9
       m_a_riosv               8
       Mike Kaganski           7
       Heiko Tietze            5
       V Stuart Foote          4
       Gabor Kelemen (allotropia) 3
       Rafael Lima             3
       Balázs Varga (allotropia) 2

    + top 10 bugs reporters:
       Tyler                   10
       Gabor Kelemen (allotropia) 5
       Michael Otto            5
       peter josvai            5
       Mike Kaganski           3
       Eyal Rozenberg          2
       Manfredi Marceca        2
       Regina Henschel         2
       Stéphane Guillou (stragu) 2
       Telesto                 2

    + top 10 bugs fixers:
       Caolán McNamara         9
       Kaganski, Mike          5
       Rafael Lima             3
       Stéphane Guillou        3
       Vernon, Stuart Foote    3
       Balazs Varga            2
       Heiko Tietze            2
       Henschel, Regina        2
       Kelemen, Gabor          2
       Patrick Luby            2

    + top 10 bugs confirmers:
       Stéphane Guillou        21
       *UNKNOWN*               13
       Heiko Tietze            5
       Kaganski, Mike          5
       m.a.riosv               4
       Nabet, Julien           3
       Robert Großkopf         2
       Bogaboga Man            1
       Dariusz                 1
       Gerald Pfeifer          1


* Bisected bugs open: keyword 'bisected'
   + more accurate - down to a single commit.
   + http://bit.ly/2dyIfDy
   +

     done by:
        Stéphane Guillou       6
        Michael Warner         1
        Raal                   1
        Timur                  1
        Xisco Fauli            1


* Bibisected bugs open: keyword 'bibisected'
   + http://bit.ly/2cSCXlS
   +

     done by:
        Stéphane Guillou       6
        Michael Warner         1
        Raal                   1
        Timur                  1
        Vernon, Stuart Foote   1
        Xisco Fauli            1


* all bugs tagged with 'regression'
   + 1243(-6) bugs open of 13283(+13) total 22(-2) high prio.

     done by:
        Stéphane Guillou       5
        Ady                    1
        Michael Warner         1
        m.a.riosv              1
        Vernon, Stuart Foote   1
        Xisco Fauli            1


* ~Component   count net * high severity regressions
   + http://bit.ly/1HWHb3E
     Writer        - 16(+0)
     Calc          - 2(-1)
     Impress       - 1(+0)
     LibreOffice   - 1(-1)
     UI            - 1(+0)

   by OS:
     All           - 18(-1)
     Linux         - 3(-1)
     Mac OS X      - 0(+0)
     Windows       - 1(+0)


* ~Component   count net * all regressions
   + http://bit.ly/1BUdI8i
     Writer: other            - 443(+0)
     Calc                     - 225(-1)
     Impress                  - 126(+1)
     LibreOffice              - 53(+0)
     Draw                     - 51(-1)
     Writer: docx filter      - 45(+0)
     Crashes                  - 42(-4)
     Base                     - 40(+0)
     UI                       - 37(+0)
     Borders                  - 36(+0)
     Writer: perf             - 35(+0)
     Writer: other filter     - 31(-1)
     Chart                    - 24(+0)
     Printing and PDF export  - 24(+0)
     RTL                      - 24(+0)
     filters and storage      - 22(+0)
     BASIC                    - 19(+0)
     Writer: doc filter       - 16(+0)
     graphics stack           - 13(-1)
     Formula Editor           - 7(+0)
     framework                - 3(+0)
     Extensions               - 2(+0)
     sdk                      - 2(+0)
     Linguistic               - 1(+0)