Error received by LabKey

LabKey Support Forum (Inactive)
Error received by LabKey jlumpe  2015-05-11 17:07
Status: Closed
 
Error received by LabKey:

org.springframework.jdbc.BadSqlGrammarException: ExecutingSelector; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: relation "core.usersearchterms" does not exist
  Position: 322
    at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:276)
    at org.labkey.api.data.ExceptionFramework$1.translate(ExceptionFramework.java:37)
    at org.labkey.api.data.ExceptionFramework$1.translate(ExceptionFramework.java:31)
    at org.labkey.api.data.SqlExecutingSelector$ExecutingResultSetFactory.handleSqlException(SqlExecutingSelector.java:443)
    at org.labkey.api.data.BaseSelector.handleResultSet(BaseSelector.java:263)
    at org.labkey.api.data.SqlExecutingSelector.getResultSet(SqlExecutingSelector.java:121)
    at org.labkey.api.data.SqlExecutingSelector.getResultSet(SqlExecutingSelector.java:156)
    at org.labkey.wiki.WikiManager.indexWikiContainerFast(WikiManager.java:648)
    at org.labkey.wiki.WikiManager.indexWikis(WikiManager.java:614)
    at org.labkey.wiki.WikiModule$1.run(WikiModule.java:218)
    at org.labkey.search.model.AbstractSearchService$5.run(AbstractSearchService.java:901)
    at java.lang.Thread.run(Unknown Source)
Caused by: org.postgresql.util.PSQLException: ERROR: relation "core.usersearchterms" does not exist
  Position: 322
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:419)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:304)
    at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
    at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
    at org.labkey.api.data.dialect.StatementWrapper.executeQuery(StatementWrapper.java:603)
    at org.labkey.api.data.SqlExecutingSelector$ExecutingResultSetFactory.executeQuery(SqlExecutingSelector.java:384)
    at org.labkey.api.data.SqlExecutingSelector$ExecutingResultSetFactory.getResultSet(SqlExecutingSelector.java:324)
    at org.labkey.api.data.BaseSelector.handleResultSet(BaseSelector.java:249)
    ... 7 more
 
 
Jon (LabKey DevOps) responded:  2015-05-11 17:12
Hi Jared,

We received an error message from your system and wanted to let you know about it.

The error above occurs when an update is not allowed to finish, typically due to rebooting a server or some other type of interruption. You can fix this by going to the recreateViews.view page with your browser (the URL should look like http://<domain>/labkey/admin/recreateViews.view). That view will provide you the option to recreate all views and fix the problem from there.

Regards,

Jon
 
jlumpe responded:  2015-05-11 17:18
Hi Jon,

Thanks for the response on this. The error actually happened because I accidentally ran "DROP SCHEMA core CASCADE" in the wrong database, haha. I think a reinstall is probably necessary but I'm not actually using LabKey right now anyways. I would have deleted this thread but I'm not actually sure how to.

Jared
 
Jon (LabKey DevOps) responded:  2015-05-11 17:21
Hi Jared,

Thanks for letting us know. We'll consider this closed.

Regards,

Jon