dhis2-devs team mailing list archive

[Gichangi John <gichangijohn3@xxxxxxxxx>]

Hi Team

Have been experiencing some failures during the analytics process. The
analytics logs indicates failure in creating index. What could be causing
this failure

System notification   2016-08-05
Analytics table process failed, please check the logs. Time:
2016-08-05T01:18:17.781+03:00. Application title: Kenya Health Information
System Message: Exception during execution Cause:
java.util.concurrent.ExecutionException:
org.springframework.dao.DataAccessResourceFailureException:
StatementCallback; SQL [create index "in_financialjuly_ax_2011_OPYkx" on
analytics_temp_2011 ("financialjuly")]; An I/O error occurred while sending
to the backend.; nested exception is org.postgresql.util.PSQLException: An
I/O error occurred while sending to the backend.
at java.util.concurrent.FutureTask.report(FutureTask.java:122)
at java.util.concurrent.FutureTask.get(FutureTask.java:192)
at org.hisp.dhis.commons.util.ConcurrentUtils.waitForCompletion(
ConcurrentUtils.java:53)
at org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.createIndexes(
DefaultAnalyticsTableService.java:291)
at org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.update(
DefaultAnalyticsTableService.java:138)
at org.hisp.dhis.analytics.table.scheduling.AnalyticsTableTask.
run(AnalyticsTableTask.java:142)
at org.hisp.dhis.scheduling.ScheduledTasks.run(ScheduledTasks.java:60)
at org.springframework.scheduling.support.DelegatingErrorHandlingRunnabl
e.run(DelegatingErrorHandlingRunnable.java:54)
at org.springframework.scheduling.concurrent.ReschedulingRunnable.run(
ReschedulingRunnable.java:81)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ScheduledThreadPoolExecutor$
ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(
ScheduledThreadPoolExecutor.java:293)
at java.util.concurrent.ThreadPoolExecutor.runWorker(
ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(
ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.springframework.dao.DataAccessResourceFailureException:
StatementCallback; SQL [create index "in_financialjuly_ax_2011_OPYkx" on
analytics_temp_2011 ("financialjuly")]; An I/O error occurred while sending
to the backend.; nested exception is org.postgresql.util.PSQLException: An
I/O error occurred while sending to the backend.
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator
.doTranslate(SQLStateSQLExceptionTranslator.java:105)
at org.springframework.jdbc.s