<div dir="ltr">Bumping this to see if anyone can help...</div><div class="gmail_extra"><br><br><div class="gmail_quote">On Mon, Mar 31, 2014 at 9:00 AM, <span dir="ltr"><<a href="mailto:evergreen-admin-request@list.evergreen-ils.org" target="_blank">evergreen-admin-request@list.evergreen-ils.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Send Evergreen-admin mailing list submissions to<br>
<a href="mailto:evergreen-admin@list.evergreen-ils.org">evergreen-admin@list.evergreen-ils.org</a><br>
<br>
To subscribe or unsubscribe via the World Wide Web, visit<br>
<a href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-admin" target="_blank">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-admin</a><br>
<br>
or, via email, send a message with subject or body 'help' to<br>
<a href="mailto:evergreen-admin-request@list.evergreen-ils.org">evergreen-admin-request@list.evergreen-ils.org</a><br>
<br>
You can reach the person managing the list at<br>
<a href="mailto:evergreen-admin-owner@list.evergreen-ils.org">evergreen-admin-owner@list.evergreen-ils.org</a><br>
<br>
When replying, please edit your Subject line so it is more specific<br>
than "Re: Contents of Evergreen-admin digest..."<br>
<br>
<br>
Today's Topics:<br>
<br>
1. Upgrade 2.2.0 to latest... Database error on 2.3-2.4.0 script<br>
(Jeff Green)<br>
<br>
<br>
----------------------------------------------------------------------<br>
<br>
Message: 1<br>
Date: Sun, 30 Mar 2014 09:42:56 -0700<br>
From: Jeff Green <<a href="mailto:jeff.green.ca@gmail.com">jeff.green.ca@gmail.com</a>><br>
To: "<<a href="mailto:evergreen-admin@list.evergreen-ils.org">evergreen-admin@list.evergreen-ils.org</a>>"<br>
<<a href="mailto:evergreen-admin@list.evergreen-ils.org">evergreen-admin@list.evergreen-ils.org</a>><br>
Subject: [Evergreen-admin] Upgrade 2.2.0 to latest... Database error<br>
on 2.3-2.4.0 script<br>
Message-ID:<br>
<<a href="mailto:CAMNpBqo%2BwfWJdXZbFXMd%2B%2B094jOhTUU_fqDbdEjMMd_mj-qzOg@mail.gmail.com">CAMNpBqo+wfWJdXZbFXMd++094jOhTUU_fqDbdEjMMd_mj-qzOg@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
Hi. I'm running into an issue upgrading EG 2.2.0 to the latest, and could<br>
use some help on what to try next. The upgrade crashes during the 2.3-2.4.0<br>
script, on the DROP EXTENSION tsearch2 command.<br>
<br>
There was an IRC chat (<br>
<a href="http://evergreen-ils.org/irc_logs/evergreen/2013-06/%23evergreen.27-Thu-2013.log" target="_blank">http://evergreen-ils.org/irc_logs/evergreen/2013-06/%23evergreen.27-Thu-2013.log</a>)<br>
about adding a couple statements. However, still got the same error.<br>
<br>
I also tried DROP...CASCADE; but that created other errors later.<br>
<br>
So, I rolled back to my previous snapshot (VM) and am asking for some<br>
advice on how to proceed! Any suggestions on what to do next?<br>
<br>
Here's the error:<br>
2014-02-28 13:48:30 PST ERROR: cannot drop extension tsearch2 because other<br>
objects depend on it<br>
<br>
Here's the statements I added immediately before the DROP EXTENSION<br>
tsearch2:<br>
DROP AGGREGATE agg_tsvector(tsvector);<br>
DROP FUNCTION tsvector_concat(tsvector, tsvector);<br>
<br>
Script is also throwing these errors:<br>
<br>
psql:2.3-2.4.0-upgrade-db.sql:3996: ERROR: text search configuration<br>
"english_nostop" does not exist<br>
psql:2.3-2.4.0-upgrade-db.sql:3997: ERROR: text search configuration<br>
"english_nostop" does not exist<br>
psql:2.3-2.4.0-upgrade-db.sql:3998: ERROR: text search configuration<br>
"english_nostop" does not exist<br>
psql:2.3-2.4.0-upgrade-db.sql:3999: ERROR: text search configuration<br>
"english_nostop" does not exist<br>
psql:2.3-2.4.0-upgrade-db.sql:4000: ERROR: text search configuration<br>
"english_nostop" does not exist<br>
<br>
<br>
Thanks!<br>
<br>
--<br>
Jeff Green<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://list.evergreen-ils.org/pipermail/evergreen-admin/attachments/20140330/55548f7b/attachment-0001.html" target="_blank">http://list.evergreen-ils.org/pipermail/evergreen-admin/attachments/20140330/55548f7b/attachment-0001.html</a>><br>
<br>
------------------------------<br>
<br>
_______________________________________________<br>
Evergreen-admin mailing list<br>
<a href="mailto:Evergreen-admin@list.evergreen-ils.org">Evergreen-admin@list.evergreen-ils.org</a><br>
<a href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-admin" target="_blank">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-admin</a><br>
<br>
<br>
End of Evergreen-admin Digest, Vol 15, Issue 2<br>
**********************************************<br>
</blockquote></div><br><br clear="all"><div><br></div>-- <br>Jeff Green<br><br>
</div>