Report is failed with canceling statement due to conflict with recovery

0

Error:

2016-01-13 11:05:46,367 ERROR JRFillSubreport,pool-6-thread-16:870 - Fill 1: exception

net.sf.jasperreports.engine.JRException: Error executing SQL statement for: jobAidLessonUsageReport_JobAidLessonUsageDS_1449128890907_787958.at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:342)at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:168)                at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1129)at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:696)at net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:437)at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:523)at net.sf.jasperreports.engine.fill.BaseReportFiller.fill(BaseReportFiller.java:396)at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:734)at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:58)at net.sf.jasperreports.engine.fill.AbstractThreadSubreportRunner.run(AbstractThreadSubreportRunner.java:216)at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)at java.lang.Thread.run(Thread.java:722)

Caused by: org.postgresql.util.PSQLException: ERROR: canceling statement due to conflict with recovery Detail: User query might have needed to see row versions that must be removed.at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157)at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886)

                at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555)          at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417)at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:302)             at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:332)... 12 more2016-01-13 11:05:46,392 ERROR AsyncJasperPrintAccessor,pool-6-thread-16:315 - Error during report executionnet.sf.jasperreports.engine.JRRuntimeException: 

Regards,

Sanal

sanal.k's picture
Joined: Oct 21 2015 - 12:04am
Last seen: 3 years 7 months ago

1 Answer:

0

I'm assuming that this is a Standby Server and the query is a long one.

This situation is documented at http://www.postgresql.org/docs/9.0/static/hot-standby.html

 

djohnson53's picture
78835
Joined: May 25 2012 - 11:10am
Last seen: 11 hours 55 min ago
Feedback