Skip to content
Snippets Groups Projects
This project is mirrored from https://github.com/metabrainz/musicbrainz-server. Pull mirroring updated .
  1. Dec 16, 2020
    • yvanzo's avatar
      Merge branch 'beta' into production · 0b277e2d
      yvanzo authored
      * beta:
        Update translations from Transifex
        Fix broken date formatter cache set
        Serialize AccountLayoutUserT for Subscribers.js
        Update translations from Transifex
        Fix load_first_release_date for empty recording lists
        Remove DBDefs import from definePluginConfig.js
        Update POT files using the production database
        Update translations from Transifex
        MBS-10634: Limit InstrumentsWithoutAnImage to StaticBrainz
        MBS-10590: Implement IROMBOOK images for instruments
        Set SameSite=None on beta cookie
        MBS-11241: Seed annotation, edit_note with textarea
        Avoid passing UnsanitizedEditorT to UserAccountLayout
        Make /admin/email-search accept POST only
        Fix incorrect test
        Test for sanitized editor data in dumps
        Serialize email/birth_date based on active user
        Pass only activeUserId to CollectionsEntityTypeSection
        Rename EditorPreferencesT to UnsanitizedEditorPreferencesT
        Rename SanitizedEditorT back to EditorT
        Detect unsanitized editor data in hydration props
        Editor::TO_JSON returns a sanitized editor
        Rename EditorT to UnsanitizedEditorT
        Fix performance issues with MBS-1424 implementation
        Update translations from Transifex
        Update POT files using the production database
        Use SameSite=Lax for login cookies (fixes MBS-11238)
        Add NONCE_SECRET to DBDefs.pm.ctmpl
        Update translations from Transifex
        Update POT files using the production database
        Store name in EditLinkType attributes
        MBS-1424: Add a "First release date" field to recordings
        MBS-8438: Only return event once in find_by methods
        MBS-11216: Split InstrumentsWithoutAnImage report
        MBS-11227: Ensure /release-group/merge also works
        MBS-11225: Autoselect IROMBOOK images
        Add ACTIVE_SCHEMA_SEQUENCE flag
        Update MB Solr to v3.3.1
        Add JSON entry for schema 26
        MBS-11188: Block odesli.co smart links
        Bump Flow to 0.138.0
        MBS-11224: Show clear message for releases with no media
        MBS-11223: Only try to load medium rels if they have tracks
        Syntax fixed by bitmap
        Allow external release editor seeding in user selected language
        Avoid "masks earlier declaration" warning
        MBS-11212:  Actually test qualities other than normal in WS
        MBS-11214: Don't group different link orders
        MBS-11169: Don't group different relationship credits
        MBS-11212: Serialize correct quality for JSON release
        Allow translating [removed] like elsewhere
        Add csrf_session_key field
        Add NONCE_SECRET
        Add seed confirmation page (resolves MBS-11092)
        Set SameSite=Strict on session, remember_login cookies
        set_csp_headers before returning the login form
        Move set_csp_headers to MusicBrainz::Server
        Merge global DBDefs/$c namespaces
        MBS-4555: Preserve POST parameters on login
        Move CSRF tokens to form layer
        Add CSRF token to linktype/delete
        Add CSRF token to linkattributetype/delete
        Move broken viewing_own_profile check
        Move generate_globals_script_nonce to Server.pm
        Merge Submit(Cancel) form(s) into Confirm
        Merge admin/edit_user forms
        Remove unused actions
        Remove unused ANNOTATION_LOCK_TIME
        RequireAuth instead of forward to /user/do_login
        MBS-11211: Convert the login page to React
        MBS-11210: Allow more subpaths for saisaibatake.ame-zaiku.com
        MBS-11207: Avoid double-encoding DBI errors
        Eslint fix: operator-assignment
        Hide cardinality and orderable direction if not in edit data
        MBS-10664: Allow more tags in expand2react
        Align comments with new code
        Add ReadOnlyFormT and make FormT rw
        Fix broken /lost-username link
        Add flow types to utility/dates.js
        Document how to disable entity caching
        Bump Flow to 0.137.0
        Add edit_data_type_info to DropFunctions.sql
        Clearer wording for cardinality headers
        MBS-11018: Convert Add Relationship Type edit to React
      v-2020-12-14
      0b277e2d
    • yvanzo's avatar
      Update translations from Transifex · 19e37b54
      yvanzo authored
      19e37b54
  2. Dec 09, 2020
  3. Dec 08, 2020
  4. Dec 07, 2020
  5. Dec 03, 2020
  6. Nov 30, 2020
  7. Nov 28, 2020
    • Michael Wiencek's avatar
      Merge branch 'master' into beta · 2047b745
      Michael Wiencek authored
      * master:
        Fix performance issues with MBS-1424 implementation (#1801)
      2047b745
    • Michael Wiencek's avatar
      Fix performance issues with MBS-1424 implementation (#1801) · f099c0e5
      Michael Wiencek authored
      After running the original upgrade script for MBS-1424 in production we
      started to observe an increase in 504s due to track insertions taking
      2-4 seconds or more. I traced this to the recording_release_dates view
      being slow, particularly joining against a union of the release_country
      and release_unknown_country tables.
      
      This commit adds a new materialized `release_first_release_date` table
      to store a union of the earliest release dates from `release_country`
      and `release_unknown_country`.
      
      To see where this matters, refer to the changes in the
      `set_recordings_first_release_dates` function. An example of the
      previous kind of subquery this would perform is:
      
      SELECT DISTINCT ON (recording)
             recording, year, month, day
        FROM recording_release_dates
       WHERE recording = ANY(ARRAY[1076099])
       ORDER BY recording, year NULLS LAST, month NULLS LAST, day NULLS LAST;
      
      which takes slightly under 4 seconds in production. The new subquery
      (using the release_date table) looks like this:
      
      SELECT DISTINCT ON (track.recording)
          track.recording,
          rd.year,
          rd.month,
          rd.day
        FROM track
        JOIN medium ON medium.id = track.medium
        LEFT JOIN release_first_release_date rd ON rd.release = medium.release
       WHERE track.recording = ANY(ARRAY[1076099])
       ORDER BY
        track.recording,
        rd.year NULLS LAST,
        rd.month NULLS LAST,
        rd.day NULLS LAST;
      
      and takes only ~0.66 ms by making use of an index scan on
      release_first_release_date_pkey.
      f099c0e5
    • Michael Wiencek's avatar
      Merge branch 'beta' · 5e23d46f
      Michael Wiencek authored
      * beta:
        Guard against undef editor in EditorOAuthToken
      5e23d46f
    • Michael Wiencek's avatar
      Merge branch 'production' into beta · 42f159a0
      Michael Wiencek authored
      * production:
        Guard against undef editor in EditorOAuthToken
      42f159a0
    • Michael Wiencek's avatar
      3d611a5a
  8. Nov 24, 2020
Loading