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

Upgrade script fails due to missing function

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Normal Normal
    • 2012-10-29
    • Schema change, 2012-10-15
    • Scripts
    • None

      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.

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

              Created:
              Updated:
              Resolved:

                Version Package
                2012-10-29