[Evergreen-admin] Evergreen-admin Digest, Vol 15, Issue 2

[Jeff Green]

Bumping this to see if anyone can help...


On Mon, Mar 31, 2014 at 9:00 AM, <
evergreen-admin-request at list.evergreen-ils.org> wrote:

> Send Evergreen-admin mailing list submissions to
>         evergreen-admin at list.evergreen-ils.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
>
> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-admin
>
> or, via email, send a message with subject or body 'help' to
>         evergreen-admin-request at list.evergreen-ils.org
>
> You can reach the person managing the list at
>         evergreen-admin-owner at list.evergreen-ils.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Evergreen-admin digest..."
>
>
> Today's Topics:
>
>    1. Upgrade 2.2.0 to latest... Database error on      2.3-2.4.0 script
>       (Jeff Green)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Sun, 30 Mar 2014 09:42:56 -0700
> From: Jeff Green <jeff.green.ca at gmail.com>
> To: "<evergreen-admin at list.evergreen-ils.org>"
>         <evergreen-admin at list.evergreen-ils.org>
> Subject: [Evergreen-admin] Upgrade 2.2.0 to latest... Database error
>         on      2.3-2.4.0 script
> Message-ID:
>         <
> CAMNpBqo+wfWJdXZbFXMd++094jOhTUU_fqDbdEjMMd_mj-qzOg at mail.gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> 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-0001.html
> >
>
> ------------------------------
>
> _______________________________________________
> Evergreen-admin mailing list
> Evergreen-admin at list.evergreen-ils.org
> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-admin
>
>
> End of Evergreen-admin Digest, Vol 15, Issue 2
> **********************************************
>



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