Issue Details (XML | Word | Printable)

Key: MBS-5473
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Normal Normal
Assignee: Ian McEwen
Reporter: Andy Hawkins
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
MusicBrainz Server

Upgrade script fails due to missing function

Created: 17/Oct/12 10:38 AM   Updated: 30/Oct/12 07:47 PM   Resolved: 30/Oct/12 07:47 PM
Component/s: Scripts
Affects Version/s: Schema change, 2012-10-15
Fix Version/s: 2012-10-29


 Description  « Hide

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.



Sort Order: Ascending order - Click to sort in descending order
nikki added a comment - 17/Oct/12 10:46 AM

Also reported on the blog - http://blog.musicbrainz.org/?p=1663


Ian McEwen added a comment - 30/Oct/12 07:47 PM

Fixed this last week, presumably missed marking it among the other eighty fires we had.