ESC meeting minutes: 2019-09-05

* Present:
    + Stephan, Michael W., Thorsten, Xisco, Gabriel, Michael S., Heiko, Christian,
      Caolán, Kendy, Olivier

* Completed Action Items:
    + Change behavior of Previous/Next Change commands:
      look at https://gerrit.libreoffice.org/#/c/76719/, decide if it’s safe
      or not (Kendy)
    + Talk to Markus about showing just dll name in crash reporting (Xisco)
      [ problem was with 6.5; but now we have 6.6 etc., not a problem any more ]

* Pending Action Items:
    + Check with Italo wrt. LibOCon Hackfest wiki page (Sophie)

* Release Engineering update (Christian)
    + 6.2.7 & 6.3.1 released as final earlier today
    + will there be 6.2.8? (Caolán)
        + yes, as planned, it will be an additional release (Christian)
        + RC in end of Sep, final in Oct
    + 6.3.2 rc1 later today
      + new signing cert for windows, private key on smartcard, hence
        https://gerrit.libreoffice.org/#/c/78649/ for changing msi signing
        anyone doing signed windows builds is welcome to have a look
    + Remotes
    + Android viewer
       + uploading a 64bit version – the new requirement
    + Online
    + daily builds status
      + Linux solved completely
      + Windows / macOS needs integration into Jenkins
     + old signing certificate expires by the end of September
       + new cert will be from a new CA
       + be aware, some virus scanners may warn

* Documentation (Olivier)
    + New Help
       + Investigating tweaks in Codemirror as plugin for gerrit.
       + Investigating xapian, RFE submitted to xapian.org
           + for indexing and searching
    + Help content2
       + updates (LibreOfficiant)
    + GSDOC
       + Defining outline of LOOL Guide w/ Tech Writer
    + Guides
       + Stalled. Vacations?

* UX Update (Heiko)
    + Bugzilla (topicUI) statistics
        235(235) (topicUI) bugs open, 219(219) (needsUXEval) needs to be evaluated by the UXteam
    + Updates:
        BZ changes   1 week    1 month     3 months   12 months  
             added      7(0)      25(-4)      47(-1)      90(-1) 
         commented     38(-58)   249(-144)   680(-19)   1736(-14)
           removed      0(0)       0(0)        1(0)       18(-1) 
          resolved      6(-1)     28(-10)     59(4)      160(4)  
    + top 10 contributors:
          Heiko Tietze made 143 changes in 1 month, and 400 changes in 1 year
          Thomas Lendo made 82 changes in 1 month, and 307 changes in 1 year
          Xisco Faulí made 46 changes in 1 month, and 299 changes in 1 year
          Buovjaga made 45 changes in 1 month, and 85 changes in 1 year
          Foote, V Stuart made 45 changes in 1 month, and 267 changes in 1 year
          Dieter Praas made 36 changes in 1 month, and 186 changes in 1 year
          Kainz, Andreas made 15 changes in 1 month, and 196 changes in 1 year
          Roman Kuznetsov made 13 changes in 1 month, and 255 changes in 1 year
          Henschel, Regina made 11 changes in 1 month, and 36 changes in 1 year
          Markus Elfring made 10 changes in 1 month, and 15 changes in 1 year

    + New tickets with needsUXEval Aug/30-Sep/05
    
      * Please Provide Better Defaults for Placing Pictures in LO Writer
        + https://bugs.documentfoundation.org/show_bug.cgi?id=127220 
      * Toggle baseline grid from menu
        + https://bugs.documentfoundation.org/show_bug.cgi?id=127280 
      * Add available options to View menu
        + https://bugs.documentfoundation.org/show_bug.cgi?id=127289 
      => wfm, wf, dup 

      * RTL Insert Cell shifts cells dialog text needs to indicate opposite
        direction
        + https://bugs.documentfoundation.org/show_bug.cgi?id=125868 
      * Making tips of the day specific to the kind of document created
        + https://bugs.documentfoundation.org/show_bug.cgi?id=127294 
      * Register-true with better labelling
        + https://bugs.documentfoundation.org/show_bug.cgi?id=127279 
      * Copy word stats to clipboard as HTML table
        + https://bugs.documentfoundation.org/show_bug.cgi?id=127313 
      * Improve use of line dash definitions with rounded dots/dashes
        + https://bugs.documentfoundation.org/show_bug.cgi?id=127348 
      * Search-Function: Make comments searchable by default, if shown.
        + https://bugs.documentfoundation.org/show_bug.cgi?id=127324 
      => new, unconfirmed, in discussion

   -> * Redaction object opacity is not 100%
        + https://bugs.documentfoundation.org/show_bug.cgi?id=126915 
      * Move Insert->QR Code to Insert->Object->QR Code
        + https://bugs.documentfoundation.org/show_bug.cgi?id=127277 
      * Percent Stacked image in Chart Wizard is wrong for most Icon styles
        + https://bugs.documentfoundation.org/show_bug.cgi?id=126796 
      => decided, assigned

* Crash Reporting (Caolan)    
    + 2 import failure, 2(+2) export failures
    + 35 coverity issues
    + Google / ossfuzz: no significant change
    + 6.2.7 and 6.3.1 will attempt to treat calls of macros equivalent
      to presence of macros

* Crash Reporting (Xisco)
    + https://crashreport.libreoffice.org/stats/version/6.2.5.2
        + (+178) 2366 2188 1865 1808 3000 2274 748 0
    + https://crashreport.libreoffice.org/stats/version/6.2.6.2
        + (+198) 509 311 246 12 0 
    + https://crashreport.libreoffice.org/stats/version/6.3.0.4
        + (+700) 6967 6267 4942 2052 0
        + many crashes related to the dynamic amount of columns
        + Mike Kaganski has fixed that, should go lower again

* Hackfests & Events (Sophie)
    + Google Mentor summit happening in Europe end of October
       + could be a fall-back for European meetup
       + Cafe Netzwerk / CIB office or something.
       + one slot for Mentor Summit available
       + call for Munich volunteers to organize something around this?
         (Thorsten)
          + https://wiki.documentfoundation.org/Hackfest/Muenchen2019 
         + Mentor summit is Oct. 19th-20th, something around that weekend
           would be perfect
         + suggestion to have a small hackfest in Munich, before or after the 
           GSoC summit,
           + proposal either before: 15/16/17/18th of Oct
               + works better for Michael W.
           + or after: 24/25th  of Oct
               + works better for Heiko
           + Heiko setting up a wiki page for this
               + <url>
   + hope to have one each quarter.

* Conference (Sophie)
   + committee evaluated talks, speakers should be notified by now
   + Italo working on the program, will be available later this week

* GSOC 2019 (Thorsten/Xisco/Moggi/Heiko)
   + Project page:
    https://summerofcode.withgoogle.com/organizations/5557591040589824/
   + Mentor Summit: Michael M & Thorsten going, event is Oct 19th and 20th in Munich
   + 100% success rate this time
   + wrap-up blogpost would be great
   + GSoC panel at the conference – on Thursday (Thorsten)

* mentoring/easyhack update
          committer...   1 week       1 month      3 months      12 months    
                  open       50(-44)      98(-59)      106(-57)      117(-57) 
               reviews     1126(-102)   5090(-338)   15163(-201)   53873(-173)
                merged      279(-54)    1366(-90)     4405(-21)    16115(0)   
             abandoned       14(8)        61(-8)       221(-1)       847(4)   
           own commits      185(-76)    1094(-142)    3369(-69)    14819(-68) 
        review commits       59(-6)      405(-6)      1171(-25)     4155(-33) 
        contributor...   1 week     1 month    3 months    12 months  
                  open       7(-10)    30(-10)     31(-12)     32(-12)
               reviews     260(44)    774(26)    1346(79)    3000(95) 
                merged      13(-15)    79(8)      188(3)      913(-8) 
             abandoned       5(-3)     21(-52)    165(-2)     361(-3) 
           own commits      17(-8)     92(7)      203(6)      964(-4) 
        review commits       0(0)       0(0)        0(0)        0(0)  
    + easyHack statistics:
       needsDevEval 6(6)   needsUXEval 0(0)   cleanup_comments 195(195)   
       total 241(241)   assigned 5(5)   open 222(222)   
    + top 10 contributors:
          shubham goyal made 12 patches in 1 month, and 34 patches in 1 year
          Scott Clarke made 9 patches in 1 month, and 10 patches in 1 year
          LibreOfficiant made 8 patches in 1 month, and 50 patches in 1 year
          Balazs Varga made 8 patches in 1 month, and 47 patches in 1 year
          Adrien Ollier made 6 patches in 1 month, and 20 patches in 1 year
          Tünde Tóth made 5 patches in 1 month, and 20 patches in 1 year
          nd101 made 3 patches in 1 month, and 6 patches in 1 year
          Szabolcs Tóth made 3 patches in 1 month, and 3 patches in 1 year
          DrRobotto made 2 patches in 1 month, and 10 patches in 1 year
          Vipul Gupta made 2 patches in 1 month, and 2 patches in 1 year
    + top 10 reviewers:
          Jenkins CollaboraOffice made 481 review comments in 1 month, and 768 in 1 year
          Nabet, Julien made 314 review comments in 1 month, and 2313 in 1 year
          Michael Stahl made 227 review comments in 1 month, and 1411 in 1 year
          McNamara, Caolán made 177 review comments in 1 month, and 1200 in 1 year
          Behrens, Thorsten made 155 review comments in 1 month, and 1651 in 1 year
          Xisco Faulí made 131 review comments in 1 month, and 936 in 1 year
          Mehrbrodt, Samuel made 116 review comments in 1 month, and 557 in 1 year
          Bergmann, Stephan made 116 review comments in 1 month, and 985 in 1 year
          Vajna, Miklos made 113 review comments in 1 month, and 1476 in 1 year
          Kaganski, Mike made 101 review comments in 1 month, and 680 in 1 year
    + big CONGRATULATIONS to contributors who have at least 1 merged patch, since last report:
          Nicolas Fella nicolas.fella@gmx.de 
          Pedro Pinto da Silva pedro.silva@collabora.com 
          Tim Bartlett github@tim.bartletts.id.au

* Commit Access
    + None

* Developer Certification (Stephan/Bjoern/Kendy/Thorsten)
    + sleep 5 weeks

* Jenkins / CI update (Christian)
    from:Thu Aug 29 14:02:34 2019
    master linux rel  jobs: 152 ok: 152 ko:   0 fail ratio:  0.00 % break:   0 broken duration: 
0.00%
    master linux dbg  jobs:  91 ok:  88 ko:   2 fail ratio:  2.20 % break:   2 broken duration: 
0.66%
    master mac rel    jobs:  87 ok:  87 ko:   0 fail ratio:  0.00 % break:   0 broken duration: 
0.00%
    master mac dbg    jobs:  93 ok:  90 ko:   3 fail ratio:  3.23 % break:   3 broken duration: 
3.17%
    master win rel    jobs:  75 ok:  67 ko:   8 fail ratio: 10.67 % break:   7 broken duration: 
9.71%
    master win dbg    jobs:  84 ok:  79 ko:   5 fail ratio:  5.95 % break:   5 broken duration: 
4.20%
    master win64 dbg  jobs:  79 ok:  70 ko:   9 fail ratio: 11.39 % break:   8 broken 
duration:12.20%
    lo-5.3 mac        jobs:   0 ok:   0 ko:   0 fail ratio:  0.00 % break:   0 broken duration: 
0.00%
    lo-5.4 mac        jobs:   0 ok:   0 ko:   0 fail ratio:  0.00 % break:   0 broken duration: 
0.00%
    master gerrit lin jobs: 380 ok: 295 ko:  19 fail ratio:  5.00% time for ok: mean:  24 median:  
23
    master gerrit plg jobs: 381 ok: 280 ko:  37 fail ratio:  9.71% time for ok: mean:  36 median:  
31
    master gerrit win jobs: 395 ok: 270 ko:  36 fail ratio:  9.11% time for ok: mean:  56 median:  
59
    master gerrit mac jobs: 382 ok: 279 ko:  34 fail ratio:  8.90% time for ok: mean:  49 median:  
32
    master gerrit all jobs: 336 ok: 209 ko:  95 fail ratio: 28.27% time for ok: mean:  79 median:  
65  
   + https://dev-www.libreoffice.org/tmp/gerrit_190905.html 
   + tests that failed more than twice in last seven days:
      3 CppunitTest_sc_filters_test
      3 CppunitTest_sw_uwriter
      3 JunitTest_dbaccess_unoapi
      3 JunitTest_jurt_remote
      3 UITest_writer_dialogs

* l10n (Sophie)
   + weblate instance is in live testing period
       + people using it & reporting inconveniences (Christian)

* Firebird migration from hsqldb as experimental in 6.3 ( Xisco )
    + Done in master: 
https://cgit.freedesktop.org/libreoffice/core/commit/?id=2252aba08121566e834dc530f31339e15bd94dec
    + 
http://document-foundation-mail-archive.969070.n3.nabble.com/About-putting-back-Firebird-experimental-td4265392.html
    + agree
        + no reason to have experimental in master, but not experimental
          in 6.3 (Michael S., Xisco)
    + how is that with databases already created in 6.3? (Caolan)
        + not about the engine, but about the migration (Xisco)
        + agree – migration should be experimental in 6.3 (Caolan)
    + the problems are known already (Michael S.)
    => make it experimental in 6.3, keep it experimental in master
AI:     + backport the patch to 6.3 (Xisco)

* QA update (Xisco)

    + Please help flesh out the monthly reports:
          https://nextcloud.documentfoundation.org/s/2qbepFYXXan4ief

    + UNCONFIRMED: 532 (+0)
        + enhancements: 62  (-8)
        + needsUXEval: 0 (-6)
        + haveBackTrace: 3 (-1)
        + needsDevAdvice: 15 (-1)
        + documentation:  4 (+1)
        + android:  14 (-1)
        + iOS:  6 (-3)
        + Online:  15 (-1)

    + Most pressing bugs:
     New:
        + CRASH: Closing LibreOffice after deleting a chart
            + https://bugs.documentfoundation.org/show_bug.cgi?id=127306
               + Samuel ?
     Old:
        + HSQLDB to Firebird automated migration failure when IDENTITY sequence has altered start 
number
            + https://bugs.documentfoundation.org/show_bug.cgi?id=127040

       + After Update to 6.1.4 on macOS fonts are blurred on retina display (xcode 10)
           + https://bugs.documentfoundation.org/show_bug.cgi?id=122218

       + button flashing - mouse wheel zooming breaks 
           + https://bugs.documentfoundation.org/show_bug.cgi?id=121963 
               + Armin ?

     Fixed:


    + New high severity bugs of the week:
        + FILEOPEN: DOCX: Some shapes are not displayed
            + https://bugs.documentfoundation.org/show_bug.cgi?id=123435
            + Thosten ?
        + LibreOffice freezes in attempt to open specific docx-file
            + https://bugs.documentfoundation.org/show_bug.cgi?id=125460
            + Thosten ?

* QA stats
    + https://bugs.documentfoundation.org/page.cgi?id=weekly-bug-summary.html
      +128  +8 (-149) overall)
      many thanks to the top bug squashers:
       QA Administrators       37
       Julien Nabet            13
       Xisco Faulí             12
       Tor Lillqvist           9
       Thomas Lendo            6
       Mike Kaganski           5
       László Németh           5
       Timur                   5
       Caolán McNamara         5
       Heiko Tietze            4

    + top 10 bugs reporters:
       pedro.silva             8
       Roman Kuznetsov         5
       Thomas Lendo            4
       Regina Henschel         4
       Xisco Faulí             3
       Aron Budea              3
       laurens                 2
       Mike Kaganski           2
       shubhamgoyal            2
       Jean-Baptiste Faure     2

    + top 10 bugs fixers:
       Lillqvist, Tor          9
       Nabet, Julien           7
       Németh, László          5
       Vajna, Miklos           4
       McNamara, Caolán        4
       Adolfo Jayme Barrientos 3
       Kohei Yoshida           2
       Kaganski, Mike          1
       GerardF                 1
       Mehrbrodt, Samuel       1

    + top 10 bugs confirmers:
       Dieter Praas            22
       Xisco Faulí             20
       Heiko Tietze            13
       Nabet, Julien           6
       Alex Thurgood           6
       Raal                    5
       Brinzing, Oliver        5
       Foote, V Stuart         4
       Kaganski, Mike          4
       *UNKNOWN*               4


* Highest-Priority bugs (aka "MABs"):
   + http://bit.ly/2lJAAJI
     6.0 : 1/52 -     1 %  (+0)
     5.4 : 1/40 -     2 %  (+0)
     5.3 : 0/53 -     0 %  (+0)
     5.2 : 1/44 -     2 %  (+0)
     5.1 : 0/35 -     0 %  (+0)
     5.0 : 0/64 -     0 %  (+0)
     4.4 : 1/76 -     1 %  (+0)
     4.3 : 2/73 -     2 %  (+0)
     4.2 : 2/133 -    1 %  (+0)
     4.1 : 1/83 -     1 %  (+0)
     4.0 : 4/83 -     4 %  (+0)
     old : 6/244 -    2 %  (+0)


* Bisected bugs open: keyword 'bisected'
   + more accurate - down to a single commit.
   + http://bit.ly/2dyIfDy
   + 669/3516 671/3502 662/3483 665/3467 667/3443 658/3430 658/3430 

     done by:
        Xisco Faulí            8
        Terrence Enger         2
        Raal                   2
        Brinzing, Oliver       1
        Kelemen, Gabor         1
        Budea, Áron            1
 

* Bibisected bugs open: keyword 'bibisected'
   + http://bit.ly/2cSCXlS
   + 847/4330 851/4317 842/4298 845/4281 848/4257 839/4244 839/4244 

     done by:
        Xisco Faulí            8
        Raal                   2
        Terrence Enger         1
        Brinzing, Oliver       1
        Kelemen, Gabor         1
        Budea, Áron            1


* all bugs tagged with 'regression'
   + 1123(-1) bugs open of 8787(+21) total 4(+1) high prio.

     done by:
        Raal                   5
        Xisco Faulí            3
        Roman Kuznetsov        2
        Thomas Lendo           1
        Alex Thurgood          1
        Timur                  1
        Brinzing, Oliver       1
        Chambe, Damien         1
        Németh, László         1
        Kelemen, Gabor         1


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

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


* ~Component   count net * all regressions
   + http://bit.ly/1BUdI8i
     Writer: other            - 296(+3)
     Calc                     - 226(+2)
     Impress                  - 116(+0)
     Writer: docx filter      - 75(+0)
     LibreOffice              - 74(+0)
     Draw                     - 45(-1)
     UI                       - 43(-1)
     Borders                  - 39(-1)
     Base                     - 37(-2)
     Writer: doc filter       - 36(+1)
     Writer: perf             - 34(+0)
     Writer: other filter     - 30(+0)
     Crashes                  - 27(-1)
     graphics stack           - 26(+0)
     filters and storage      - 25(+0)
     RTL                      - 22(+0)
     Printing and PDF export  - 17(+1)
     BASIC                    - 17(-1)
     Chart                    - 15(-1)
     framework                - 2(+0)
     sdk                      - 1(+0)
     Linguistic               - 1(+0)
     Formula Editor           - 1(+0)