[FOLIO-2848] Failed with upgrading mod-organizations-storage Created: 20/Oct/20  Updated: 22/Oct/20  Resolved: 22/Oct/20

Status: Closed
Project: FOLIO
Components: None
Affects versions: None
Fix versions: None

Type: Task Priority: P2
Reporter: Andrei Makaranka Assignee: Stanislav Miroshnichenko
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original estimate: Not Specified

Sprint:
Development Team: None

 Description   

Overview

Rancher environment need to be upgrade to the last versions all the modules (Snapshot). I started this upgrade from mod-organizations-storage and it failed

Requirement

  1. All previous stored data should be not lost in upgrading time.
  2. mod-organizations-storage as a result must be last version

Expected : mod-organizations-storage upgraded with last version
Actual :

WARNING: Doing LIKE search without index for organizations.jsonb->>'acqUnitIds', CQL >>> SQL: acqUnitIds <> [] >>> lower(f_unaccent(organizations.jsonb->>'acqUnitIds')) NOT LIKE lower(f_unaccent('[]'))

10/19/2020 3:54:37 PM %d [%thread] %-5level %logger - %msg%n io.vertx.pgclient.PgException: function get_tsvector(text) does not exist

Stanislav Miroshnichenko Could you please help with that?



 Comments   
Comment by Stanislav Miroshnichenko [ 22/Oct/20 ]

Upgraded Helm to v3 to avoid such issues in future.

To resolve such issues go to App upgrade menu, set 'postJob.enabled = true' and 'repository.tag' to upper version and start upgrade.
Check module version is upgraded (curl -sL -w '\n' -D - https://thunderjet-okapi.ci.folio.org/_/proxy/tenants/diku/modules).

Generated at Thu Feb 08 23:23:41 UTC 2024 using Jira 1001.0.0-SNAPSHOT#100246-sha1:7a5c50119eb0633d306e14180817ddef5e80c75d.