Uploaded image for project: 'MusicBrainz Server'
  1. MusicBrainz Server
  2. MBS-5473

Upgrade script fails due to missing function

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: Schema change, 2012-10-15
    • Fix Version/s: 2012-10-29
    • Component/s: Scripts
    • Labels:
      None

      Description

      When trying to upgrade to the 2012-10-15 schema change release, I get the following error:

      mbserver@mbserver-ngs:~/musicbrainz-server$ carton exec – ./upgrade.sh
      Wed Oct 17 11:05:29 BST 2012 : Downloading cover art archive metadata
      Wed Oct 17 11:05:39 BST 2012 : Catching up with cover_art_archive schema
      Wed Oct 17 11:06:08 BST 2012 : Updating sequence values
      Wed Oct 17 11:06:18 BST 2012 : Dropping broken indexes
      Wed Oct 17 11:06:22 BST 2012 : Applying admin/sql/updates/20120220-merge-duplicate-credits.sql
      BEGIN
      SELECT
      SELECT
      ERROR: function controlled_for_whitespace(character varying) does not exist
      LINE 5: WHERE NOT controlled_for_whitespace(artist_name.name);
      ^
      HINT: No function matches the given name and argument types. You might need to add explicit type casts.

      The last time the database structure will have been changed on this machine will be the last schema change release.

        Attachments

          Activity

            People

            • Assignee:
              ianmcorvidae Ian McEwen
              Reporter:
              adhawkins Andy Hawkins
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Packages

                Version Package
                2012-10-29