dhis2-devs team mailing list archive

[Morten Olav Hansen <morten@xxxxxxxxx>]

Hard to know without having more info, but did you check your disk space?
I/O error could mean that there is no available space on the drive

-- 
Morten Olav Hansen
Senior Engineer, DHIS 2
University of Oslo
http://www.dhis2.org

On Fri, Aug 5, 2016 at 8:38 AM, Gichangi John <gichangijohn3@xxxxxxxxx>
wrote:

> 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.c
> reateIndexes(DefaultAnalyticsTableService.java:291)
> at org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.u
> pdate(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.DelegatingErrorHandli
> ngRunnable.run(DelegatingErrorHandlingRunnable.java:54)
> at org.springframework.scheduling.concurrent.ReschedulingRunnab
> le.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$ScheduledFu
> tureTask.access$201(ScheduledThreadPoolExecutor.java:180)
> at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFu
> tureTask.run(ScheduledThreadPoolExecutor.java:293)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPool
> Executor.java:1142)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoo
> lExecutor.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.SQLStateSQLExceptionTransla
> tor.doTranslate(SQLStateSQLExceptionTranslator.java:105)
> at org.springframework.jdbc.s
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>