Uncategorized SQLException for SQL

LabKey Support Forum (Inactive)
Uncategorized SQLException for SQL bront  2015-01-12 11:03
Status: Closed
 
I will forward the labkey.log file, but from what I can see there are hundreds of errors that look like this:

 SELECT Path, LastCrawled, NextCrawl
    FROM search.CrawlCollections
    WHERE NextCrawl < ? AND (LastCrawled IS NULL OR LastCrawled < ?) ORDER BY NextCrawl
    LIMIT 100
    ?[1] Mon Jan 12 09:33:04 EST 2015
    ?[2] Mon Jan 12 09:03:04 EST 2015

    org.labkey.api.data.SqlExecutingSelector$ExecutingResultSetFactory.handleSqlException(SqlExecutingSelector.java:438)
    org.labkey.api.data.BaseSelector.handleResultSet(BaseSelector.java:263)
    org.labkey.api.data.SqlExecutingSelector.getResultSet(SqlExecutingSelector.java:109)
    org.labkey.api.data.SqlExecutingSelector.getResultSet(SqlExecutingSelector.java:156)
    org.labkey.api.data.SqlExecutingSelector.getResultSet(SqlExecutingSelector.java:140)
ERROR DavCrawler 2015-01-12 09:33:04,471 DavCrawler : Unexpected error
org.springframework.jdbc.UncategorizedSQLException: ExecutingSelector; uncategorized SQLException for SQL []; SQL state [25P02]; error code [0]; ERROR: current transaction is aborted, commands ignored until end of transaction block; nested exception is org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
 

Many thanks,

bront