Server update, 2014-07-07

Another fortnight, another release. A bit quiet this time for the summer and some vacations and holidays, but a few bugfixes, some refactoring, and the addition of browse by area in /ws/2. navap also found a security issue which allowed editing of collections by any user, which is not listed below. Thanks to nikki, bitmap, navap, and chirlu for their work on this release!

The git tag for this release is v-2014-07-07.

Bug

  • [MBS-7617] – Changing a URL’s link type on a series edit page doesn’t trigger any validation
  • [MBS-7672] – Relationship type dropdown is not ordered correctly
  • [MBS-7673] – Entity types are inconsistently ordered when adding a relationship
  • [MBS-7684] – Spurious closing </span> tags
  • [MBS-7691] – OZON.ru URLs are automatically edited to add partner=musicbrainz
  • [MBS-7696] – “This attribute type is only used for grouping, please select a subtype” when editing works
  • [MBS-7698] – Release editor asks for confirmation to leave even if there are no changes (but the release has URL relationships)
  • [MBS-7700] – Work attribute types are not sorted alphabetically
  • [MBS-7703] – Unused urls in l_series_url are not removed
  • [MBS-7707] – Work attributes are not sorted in the sidebar
  • [MBS-7713] – Percent signs not escaped in Wikipedia extract link to Wikipedia

Improvement

  • [MBS-7694] – link areas to other entities in the webservice

Task

  • [MBS-7702] – Reduce the duplication in link_* macros
  • [MBS-7704] – Factor out entity treeness into a role

New autumn schema change date: 17 November, 2014

Due to two conflicting summits in (our own and the GSoC Summit) around our usual schema change release date, we’ve decided to move the autumn schema change to 17 November, 2014. This will ensure that our developers are properly rested before attempting a hard task such as a schema change.

We hope this won’t cause too much trouble for everyone downstream.

Server update, 2014-06-23

It’s that exciting time again: another release of bug fixes and improvements. User-visible changes include a menu showing recently-used entities in autocomplete lookups (previously only available in the relationship editor), plus the display of other identities/legal names on artist pages. Thanks go to the MetaBrainz team and chirlu and nikki for their hard work on this release!

The git tag is v-2014-06-23.

Here’s the complete changelog:

Bug

  • [MBS-3537] – Add a unique constraint on medium (release, position)
  • [MBS-7149] – Relationship editor AR popup: only previously used *artists* are remembered
  • [MBS-7303] – Missing recordings in release (after updating the release)
  • [MBS-7405] – Inline search claims there are no results when the search returns an error
  • [MBS-7578] – Regression: Work types list is no longer sorted alphabetically
  • [MBS-7605] – Release editor allows invalid characters to sneak into the database
  • [MBS-7649] – Edit alias edits don’t display properly if the alias has since been removed
  • [MBS-7651] – Alias edits show no value for various fields
  • [MBS-7652] – edit_series_fk_edit and edit_series_fk_series are missing
  • [MBS-7653] – MB.utility.joinList should use the same logic/strings as the comma_list MACRO
  • [MBS-7665] – annotation edit changelog shows object reference ARRAY(0xa190008) instead of actual input text
  • [MBS-7666] – DBDefs.pm.sample is still at schema version 19
  • [MBS-7667] – GenerateSQLScripts doesn’t check for the existence of CreateTables.sql
  • [MBS-7669] – Whitespace not trimmed for series number in the relationship editor

Improvement

  • [MBS-1943] – Reorganize the sidebar to show the most important information first
  • [MBS-2474] – Display artist legal/performance name more prominently
  • [MBS-2602] – Show recent labels/artists in lookup popups
  • [MBS-6277] – Move release group relationships section for releases to the overview tab
  • [MBS-6731] – Add link to doc/Release/Format from Tracklist tab
  • [MBS-7668] – Add a stat for number of MBIDs known.

Server update, 2014-06-09

A day late in actually releasing it, but we have a new server release! Assorted bug fixes, improvements, and refactoring make up this release. Thanks to the MetaBrainz team and supplementary work from chirlu, reosarevok, and nikki. The git tag for this release is v-2014-06-09. The full list of fixed tickets:

Bug

  • [MBS-4669] – Webservice returns an ASIN that was added in a voted down edit
  • [MBS-5526] – Diff highlighting messes up descriptions in edit relationship type edits
  • [MBS-7455] – ISE for /ws/js/edit/preview: Error: Could not create MusicBrainz::Server::Edit::Release::DeleteReleaseLabel edit
  • [MBS-7552] – Entering a Series that requires disambig. changes the part of-numbering
  • [MBS-7574] – Regression. Can’t fill release group field by pasting URL
  • [MBS-7583] – Nonfunctional relationship page for instruments
  • [MBS-7584] – Double “Relationships” heading on label relationships page
  • [MBS-7585] – Missing series in subscriptions page
  • [MBS-7588] – ARRAY(0x1987d1c8) shown on add work edit
  • [MBS-7589] – Edit types in edit search are sorted in ASCII order
  • [MBS-7590] – Search results for instruments should strip markup from the description
  • [MBS-7604] – Whitespace+invalid character at the end of a string causes an ISE
  • [MBS-7608] – Internal server error looking up CD TOC with too large offsets
  • [MBS-7609] – “Refine this search” links breaks for entities with no entity filter in the edit search
  • [MBS-7611] – Internal server error loading annotation revision
  • [MBS-7614] – Relationship attributes are validated against the old link type
  • [MBS-7615] – Changes to URLs only are treated as no change
  • [MBS-7624] – Possible to create edits which add two unknown country release events
  • [MBS-7633] – l(‘Series’) is ambiguous
  • [MBS-7636] – Regression + data corruption: edit page swaps the direction of relationships

Improvement

  • [MBS-1377] – Turn relationships with multiple instrument/vocal attributes into multiple relationships
  • [MBS-7541] – Add Series to the statistics
  • [MBS-7542] – Add instruments to statistics
  • [MBS-7595] – Discid edits should show release artist
  • [MBS-7618] – fullexport generation must complete before replication packets are copied, resulting in temporary but several-hour gaps in the available replication packets
  • [MBS-7621] – Treat non-free-text work attribute types with no options as grouping types
  • [MBS-7631] – Make instrument relationships link back to the instrument entity pages

New Feature

  • [MBS-4825] – Normalize blogspot URLs

Task

  • [MBS-7499] – Add vkdb.jp to the otherdbs whitelist
  • [MBS-7571] – Factor out lists of entities in the code

May 2014 virtual machines released

I’m pleased to announce that we’ve just released the May 2014 Virtual Machine images of the MusicBrainz server!

If you’d like to direct download or BitTorrent download these images, head on over to our Server Setup page.

There have been no real changes to the setup of the VM images — we still publish a VirtualBox and a VMWare image. The instructions for using the VMs haven’t changed; the latest data and the May 26th version of the software are loaded on these images.

Have fun!

Server update, 2014-05-26

We’re back with another release on the heels of our schema change. This release includes some fixes that were hot-fixed to the production servers late the other week as well as some that have gone through the usual beta process. As such, most of the changes have to do with new or changed features of that release, plus some assorted refactoring and other bugfixes. Thanks to chirlu, nikki, and the rest of the MetaBrainz team for their hard work on this release!

Happy series editing!

The git tag for this release is v-2014-05-26.

The full list of fixed tickets, as usual:

Bug

  • [MBS-6181] – Deleted editors may be nominated for auto-editorship
  • [MBS-6309] – Search results don’t have a score column anymore after a few pages
  • [MBS-7354] – Internal Server Error in mini relationship editor when a relationship has been removed
  • [MBS-7513] – Uploading PDF cover art requires the user to switch to the “All files” filetype in the file selection dialog
  • [MBS-7514] – New accounts may be called “Deleted Editor #nnn”
  • [MBS-7516] – Age of 0 not displayed in user profiles
  • [MBS-7519] – “PDF file” labels displayed on top of image previews
  • [MBS-7530] – Caught exception in MusicBrainz::Server::Controller::Series->add_alias “The edit could not be created.
  • [MBS-7532] – ISE: Undefined value when relating Release Groups to an ordered Series
  • [MBS-7533] – Can’t create a new series from inline search
  • [MBS-7538] – Regression: Not possible to edit URL relationship attributes
  • [MBS-7539] – series. numbering elements is not auto-edit while setting automatic is
  • [MBS-7543] – “Cancel” does not cancel changes made in mini-relationship-editor for instrument-performer ARs
  • [MBS-7544] – Grouping link types are selectable in the release editor
  • [MBS-7545] – Release editor creates empty URL edits if you just change the release name
  • [MBS-7548] – Automatic series ordering doesn’t work correctly
  • [MBS-7549] – Regression: Release Editor URL seeding does not work anymore
  • [MBS-7550] – Regression: Editor search is broken
  • [MBS-7555] – ISE when changing series order numbering
  • [MBS-7556] – URL cleanup broken on edit URL pages
  • [MBS-7558] – Relationship-editor shows “The end date cannot preceed the begin date” incorrectly
  • [MBS-7559] – Sort name guess case is missing from series alias pages
  • [MBS-7561] – Relationship editor doesn’t show the count of selected recordings
  • [MBS-7562] – Regression: Error trying to unset a label in “edit release label”
  • [MBS-7563] – Multiple failures on “edit label”
  • [MBS-7570] – Add series and instruments as linkable entities in annotations
  • [MBS-7576] – Not possible to add relationships to a non-label from a label edit page
  • [MBS-7579] – Error while trying to add a release
  • [MBS-7593] – Regression: Seeding URLs to mini-relationship editor is broken
  • [MBS-7597] – Replacing recording-work relationship in relationship editor fails
  • [MBS-7599] – Relationship editor doesn’t load relationships for some recordings
  • [MBS-7600] – Firefox: “Edit Note” does not show Add Release Label if the annotation gets removed
  • [MBS-7603] – Replication trigger missing for link_attribute_text_value table

Improvement

  • [MBS-7493] – Redirected MBID pages, slave/beta servers, and non-preferred scheme should use rel=canonical to link to the main site
  • [MBS-7517] – Deleted editors should appear as “deleted”, not as “Limited User”
  • [MBS-7567] – Provide “copy/sort” bubble for all alias sortnames
  • [MBS-7575] – Support creating/editing URL relationships with the /relationship-editor endpoint
  • [MBS-7596] – The relationship editor dialog should work on a copy of the relationship until the dialog is accepted
  • [MBS-7619] – admin/config.sh means configuration is split between files (and since checked-in complicates customization)

Task

  • [MBS-7547] – Remove MAC authentication for WS

Brief downtime this Friday/Saturday, at 2 UTC (19 PDT/22 EDT/4 CEST)

As some of you with slave databases may have noticed, we made a slight error and excluded some of the new tables from our schema change in replication (tracked by MBS-7603).

Luckily, the tables in question are presently quite small, meaning that if we act now we can add them without needing a formal schema change release (by simply replicating out the changes). Less luckily, this process requires taking some very heavy locks on the ‘series’ database table, so we’ve chosen to have a small amount of downtime to run the script, at (or shortly after) the time mentioned in the title, which also gives us a chance to restart our database server to incorporate some extensions we’d intended but failed to add during the schema change release last week.

We don’t foresee this process taking more than a few minutes, and no action should be necessary for downstream data users.