• Sign In
  1. Messages

Error while upgrading LabKey

LabKey Support Forum (Inactive)

View Message

view list print
Error while upgrading LabKey eva pujadas  2017-12-14 08:07
Status: Closed
 
Dear LabKey supporters,

We have upgraded our LabKey server from version 16.3 to 17.3.
First of all postgresql has been upgraded from version 9.3 to 9.6.
Then we have upgraded LabKey stepwise in the following way: from 16.3 to 17.1, from 17.1 to 17.2 and finally 17.2 to 17.3.
On the step when upgrading from 17.1 to 17.2 we got an SQL exception (see attached file with log message).
Do you know what could be the cause of it?

Another question, a practical one: would it have been possible to upgrade LabKey directly from version 16.3 to 17.3?

Thank you very much!
Eva
 
 
Jon (LabKey DevOps) responded:  2017-12-18 15:19
Hi Eva,

Thank you for providing the error.

The SQL error you're seeing is due to a bug that was fixed in a later version of LabKey. Unless you have a very large search index, you should be able to just clear the tables from your SQL database before you attempt the upgrade and then you would need to let the server rebuild the search index.

To clear your database tables, login as an admin to your SQL database and run the following:

DELETE FROM search.CrawlResources;

DELETE FROM search.CrawlCollections;

This should clear the indexes and then allow you to do the upgrade.

Regards,

Jon