[Evergreen-admin] Upgrade 2.2.0 to latest... Database error on 2.3-2.4.0 script

[Jeff Green]

Hi. I'm running into an issue upgrading EG 2.2.0 to the latest, and could
use some help on what to try next. The upgrade crashes during the 2.3-2.4.0
script, on the DROP EXTENSION tsearch2 command.

There was an IRC chat (
http://evergreen-ils.org/irc_logs/evergreen/2013-06/%23evergreen.27-Thu-2013.log)
about adding a couple statements. However, still got the same error.

I also tried DROP...CASCADE; but that created other errors later.

So, I rolled back to my previous snapshot (VM) and am asking for some
advice on how to proceed!  Any suggestions on what to do next?

Here's the error:
2014-02-28 13:48:30 PST ERROR: cannot drop extension tsearch2 because other
objects depend on it

Here's the statements I added immediately before the DROP EXTENSION
tsearch2:
DROP AGGREGATE agg_tsvector(tsvector);
DROP FUNCTION tsvector_concat(tsvector, tsvector);

Script is also throwing these errors:

psql:2.3-2.4.0-upgrade-db.sql:3996: ERROR:  text search configuration
"english_nostop" does not exist
psql:2.3-2.4.0-upgrade-db.sql:3997: ERROR:  text search configuration
"english_nostop" does not exist
psql:2.3-2.4.0-upgrade-db.sql:3998: ERROR:  text search configuration
"english_nostop" does not exist
psql:2.3-2.4.0-upgrade-db.sql:3999: ERROR:  text search configuration
"english_nostop" does not exist
psql:2.3-2.4.0-upgrade-db.sql:4000: ERROR:  text search configuration
"english_nostop" does not exist


Thanks!

-- 
Jeff Green
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.evergreen-ils.org/pipermail/evergreen-admin/attachments/20140330/55548f7b/attachment.html>