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

[Lazar, Alexey Vladimirovich]

Hi, Jeff.

I do not have a specific answer, but a few things I would do to troubleshoot:

* Review all the schema patches from the upgrade log table in the database and cross-reference with patch numbers in the upgrade and/or version-upgrade script folders. Anything missing?
* Grep through the schema upgrade folder and version-upgrade folder for the keywords that come up in your errors to see what/when was added or could be missing
* You may want to search through bugs and git repo

Generally, I found that is it more reliable to use minor version schema upgrade scripts up to the max “minor" version and then upgrading to the next “major” version.

Also, I found that when I encountered a “weird" error that is not generally known in the community, it was a local error. The two I have encountered were related to missing schema patches.

Just FYI, over the past couple years I have upgraded data all the way from 2.0 to 2.5 now and from 2.2 to 2.5 and have not seen this error.

I know this does not specifically answer your question directly, but I hope this helps a little.

Aleksey  

On 2014-03-30, at 11:42 , Jeff Green <jeff.green.ca at gmail.com> wrote:

> 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
> 
> _______________________________________________
> Evergreen-admin mailing list
> Evergreen-admin at list.evergreen-ils.org
> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-admin

Aleksey Lazar
IS Developer and Integrator - PALS
http://www.mnpals.org/