Schema change release: Today at 17h UTC

We’re going to start our schema change release process today at 17h UTC.

We anticipate having a short downtime of a few minutes as we”ll need to restart our database server. As usual, we’re not certain when we will start the downtime, but we’ll keep people posted about our progress in IRC and on Twitter.

Once we’re done with the release we will post instructions on this blog on how to upgrade any replicated instances of MusicBrainz you might be running.

Stay tuned!

Server update, 2017-04-10

This release brings feature parity with the pre-NGS edit search, thanks to work by yvanzo.

Note: The “My Vote” search condition has been replaced by “Voter,” with sub-condition “is me.”

The git tag is v-2017-04-10.

Sub-task

  • [MBS-2673] – Filter by voter
  • [MBS-3362] – Filter out own edits
  • [MBS-3665] – Inform users of appropriate formats to use for expired/created/closed time or edit/Id ranges
  • [MBS-3914] – Filter edit queue by subscribed editors
  • [MBS-5681] – Filter by vote

Bug

  • [MBS-9088] – Search for editor edits fails

Improvement

  • [MBS-9295] – Allow Baidu Baike URLs using current format

Server update, 2017-03-27

The ability of normal users to auto-edit their own release additions within an hour of entering them has been expanded to all entity types, not just releases. There’s also a new feature in the relationship editor dialog to control which relationship credits you’re changing. Thanks to yvanzo for working on those tickets.

We’ve also resolved some more URL cleanup/detection tickets, and fixed a bug in the release editor causing stub releases to get created. Zastai fixed our web service to respect the Accept: header for search requests (thanks!).

The git tag is v-2017-03-27 and the complete changelog is below.

Bug

  • [MBS-8578] – If the checkbox to copy a Medium’s artist credits to the Recording is ticked, the release editor creates a stub and fails to submit relationships/URLs and Mediums
  • [MBS-9258] – Web service search requests don’t pass Accept: header to search servlet
  • [MBS-9288] – “Change all relationship credits” for source entity has no effect
  • [MBS-9289] – Area places map doesn’t display
  • [MBS-9290] – “video channel” link type shouldn’t be restricted

Task

  • [MBS-9287] – Update the YouTube logo used in the sidebar

Improvement

  • [MBS-8134] – Allow unreviewed edits on new entries for a period of time
  • [MBS-8465] – Change similar relationship credits for on the page.
  • [MBS-8522] – Add Twitch.tv to video channel relation and video stream auto-selectors
  • [MBS-9291] – Add Dailymotion to video channel relation and video stream auto-selectors

Server update, 2017-03-13

Thanks to legoktm, loujin, reosarevok, Zastai, and the volunteer formerly known as yvanz for their contributions, which are listed below. The git tag is v-2017-03-13. (Apologies that the release came a day late.)

Bug

  • [MBS-8748] – Excessively long medium names cause horizontal scrolling
  • [MBS-8905] – Editing release events in a 1 hour delay should be auto
  • [MBS-8927] – Lowering release data quality in a 1 hour delay should be auto
  • [MBS-9120] – Adding a setlist or a time to an event that doesn’t have one should be an auto-edit
  • [MBS-9129] – JSON WS serializes ratings for Release
  • [MBS-9215] – No way to select entity type when creating new attribute
  • [MBS-9261] – WS/2 does not allow a search for URLs
  • [MBS-9263] – Transclusion Table on MB.o is broken
  • [MBS-9264] – Gulpfile fails on leaflet when compiling from source
  • [MBS-9266] – Subheader of area pages has extra comma and misses proper i18n
  • [MBS-9267] – Release page should display disambiguation comments for Works

New Feature

  • [MBS-9135] – Allow account admins to change usernames

Improvement

  • [MBS-8354] – Replacing hyphen-minus with em-dash should be an auto-edit
  • [MBS-9230] – Hook up MusicBrainz to Sentry (replacing Catalyst::Plugin::ErrorCatcher::Email)
  • [MBS-9255] – Show recordings length on a Work overview page
  • [MBS-9260] – Changing between version of an ellipsis should be an autoedit
  • [MBS-9268] – Hide empty columns in relationships table

May 2017 Schema Change Release: May 15, 2017

We have picked our set of tickets and the date for our May 2017 schema change release: May, 15th 2017. This will be a fairly standard and minor schema change release — we’re only tackling 3 tickets that affect downstream users and no other infrastructure changes.

Take a look at our  list of tickets for this schema change release. There really are only two tickets that will affect most of our downstream users:

  • MBS-8393: “Extend dynamic attributes to all entities” Currently our works have the concept of additional attributes which allows the community to decide which sorts of new attributes to apply to a work. (e.g. catalog numbers, rhythmic structures, etc) This ticket will implement these attributes to all of our entities. Also, this ticket will not change any of the existing database tables, it will only add new tables.
  • MBS-5452: “Support multiple lyric language values for works” Currently only one language or the special case “multiple languages” may be used to identify the language used in lyrics. This ticket allows more than one language to be specified for lyrics of a work.

The following tickets are special cases — they will not really affect our downstream users who do not have edit data loaded into their system. We are only including this change at the schema change release time in order to bring some older replicated systems up to date. If you do not use the edit data, then please ignore these tickets.

  • MBS-9271: “Prevent usernames from being reused” This ticket does not change the schema, but for sake of minimizing downstream disruption, we’re going to carry out this ticket during the schema change.
  • MBS-9274: “Fix the edit_note_idx_post_time_edit index in older setups to handle NULL post_time” This ticket fixes an SQL index on an edit related table.
  • MBS-9273: “Fix the a_ins_edit_note function in older setups to not populate edit_note_recipient for own notes” This ticket also fixes an SQL index on an edit related table.

This is it — really minor this time around. If you have any questions, feel free to post them in the comments or on the tickets themselves.

 

Server update, 2017-02-27

Mostly a bug-fix release, with a few small improvements. Thanks a lot to yvanz, reosarevok, loujin, and ferbncode for their contributions. The git tag is v-2017-02-27.

Bug

  • [MBS-8931] – invalid ISRC creates Internal Server Error
  • [MBS-9214] – Cover art types tick boxes are listed with scrollbars in Opera 42 Stable
  • [MBS-9219] – [Multiple languages] (Basic) is automatically added when editing/saving an editor profile
  • [MBS-9246] – Tool-tips displaying “undefined” text
  • [MBS-9250] – Places map displays over header menus
  • [MBS-9252] – Setup using INSTALL.md: cpanfile missing entry Plack::Middleware::Debug

Task

  • [MBS-9211] – Add autoselect, clean-up, and validation + sidebar for LiveFans URLs

Improvement

  • [MBS-9166] – Remove “early” from Guess Case
  • [MBS-9176] – Add Release Group page shouldn’t display the artist tabs
  • [MBS-9237] – Don’t immediately fill back the default AC while editor is typing
  • [MBS-9254] – Show place dates on the Places list for areas

Server update, 2017-02-13

New features include a map of places contained in an area, thanks to work by loujine, and a report of instruments without an image, thanks to yvanz.

More URL cleanup fixes were submitted by yvanz, and a display bug with the locale drop-down was fixed by chirlu. Thanks again to all who contributed this release.

The git tag is v-2017-02-13.

Sub-task

  • [MBS-9062] – Correct play.spotify.com → open.spotify.com

Bug

  • [MBS-8168] – Statistics for label types are missing from the stats pages
  • [MBS-8236] – Recognise classicalarchives.com/artist/… URLs
  • [MBS-9168] – Specific locales aren’t indented
  • [MBS-9224] – The gulpfile sometimes produces a corrupt rev-manifest bundle
  • [MBS-9229] – Regression: No longer able to add www.bandsintown.com URLs
  • [MBS-9232] – Pinterest URL cleanup adds a second /

New Feature

  • [MBS-7795] – Display a map in Areas that shows all the places contained in the area.
  • [MBS-9193] – Report instruments with neither image nor Wikidata item

Improvement

  • [MBS-8249] – Standardise and validate Spotify URLs

Server update, 2017-01-30

We have many more URL display, cleanup, and auto-selection fixes thanks to yvanz, and one from GCI student anshuman73. A bug with browse requests for instruments and series in our web service has been fixed by Zastai. Thanks to jonathonwiebe, too, for correcting an outdated link in our INSTALL file.

The git tag for today’s release is v-2017-01-30.

Sub-task

  • [MBS-9195] – Convert data.bnf.fr URLs into catalogue.bnf.fr ones

Bug

  • [MBS-9128] – Unwanted “list” argument is not removed from YouTube URLs
  • [MBS-9173] – JSON browse requests for instruments and series fail

Task

  • [MBS-8998] – Display CPDL score links on the sidebar
  • [MBS-9194] – Add a bunch of sites to the “other database” whitelist

Improvement

  • [MBS-7734] – Improve Facebook URL clean up
  • [MBS-8365] – Add autoselect, clean-up, and validation for Pinterest URLs
  • [MBS-8390] – Add autoselect, clean-up, and validation + sidebar display for Bandsintown URLs
  • [MBS-9002] – Disable and tick the “ended” checkbox when the end date field is filled
  • [MBS-9159] – Enable URL cleanup for Instagram URLs
  • [MBS-9181] – Improve ReverbNation URL cleanup

Libdiscid 0.6.2 and python-discid 1.1.1 released

Libdiscid 0.6.2 includes these changes:

  • ISRC and MCN support on BSD (Zastai)
  • LIB-60: fix make check for default device on generic/unknown platform
  • make Doxygen output reproducible (no timestamps; Sebastinas)
  • remove newline for Linux device “1” from proc (Zastai)

The download can be found at http://musicbrainz.org/doc/libdiscid.

Python-discid 1.1.1 includes these changes:

The download can be found at https://python-discid.readthedocs.org/.

Server update, 2017-01-16

Thanks to chirlu, yvanz, and GCI students anshuman73, tigranl, and dpmittal for their contributions to today’s release. The git tag is v-2017-01-16 and the changelog is below.

Bug

  • [MBS-9175] – Attach TOC: Certain mediums with matching track count not shown when searching by artist
  • [MBS-9180] – Near-identical duplicates of common-xxx.js
  • [MBS-9186] – Gulpfile fails to build scripts in website containers
  • [MBS-9196] – Wikidocs redirects are broken
  • [MBS-9198] – Drop-down arrow in the top search missing in Firefox

Task

  • [MBS-7307] – Add LinkedIn URLs to sidebar
  • [MBS-8828] – Add Songkick URLs to the sidebar
  • [MBS-8851] – Add link to the blog on the footer
  • [MBS-8995] – Add ReverbNation links to the sidebar
  • [MBS-9143] – Remove the FreeDB search option

Improvement

  • [MBS-1319] – Special capitalization of dotted/dotless i/ı in Turkish
  • [MBS-8868] – Display label logo for Wikimedia Commons url-relationship