Josh,

I implemented that change to the labkey.xml. We're still seeing hundreds of errors like the following. Our sys admin noted that the errors kickoff at 2:00 when the site maintenance tasks are scheduled. We're still investigating, but if you can think of other possible solutions let us know.

Thanks,

bront


ERROR Table 2015-01-26 10:42:03,663 DavCrawler : SQL [15033]
    SELECT Path, LastCrawled, NextCrawl
    FROM search.CrawlCollections
    WHERE NextCrawl < ? AND (LastCrawled IS NULL OR LastCrawled < ?) ORDER BY NextCrawl
    LIMIT 100
    ?[1] Mon Jan 26 10:42:03 EST 2015
    ?[2] Mon Jan 26 10:12:03 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-26 10:42:03,663 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
    at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:124)
    at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:322)
    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:109)
    at org.labkey.api.data.SqlExecutingSelector.getResultSet(SqlExecutingSelector.java:156)
    at org.labkey.api.data.SqlExecutingSelector.getResultSet(SqlExecutingSelector.java:140)
    at org.labkey.api.data.SqlExecutingSelector.getResultSet(SqlExecutingSelector.java:135)
    at org.labkey.search.model.SavePaths.getPaths(SavePaths.java:308)
    at org.labkey.search.model.DavCrawler.findSomeWork(DavCrawler.java:529)
    at org.labkey.search.model.DavCrawler$1.run(DavCrawler.java:496)
Caused by: org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
    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.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)