My Oracle Support Banner

OLVM: Event Reports Error "ETL service aggregation to hourly tables has encountered an error" (Doc ID 2766658.1)

Last updated on JUNE 21, 2022

Applies to:

Linux OS - Version Oracle Linux 7.9 and later
Linux x86-64
ELT(Extract/Transform/Load) service aggregation is a procedure to extract/transform/load metric data from engine db and store it to dwh(history) db.
This is not related to engine core operations, but just history/metric data, thus OLVM engine operation is not affected even if the error is logged

Symptoms

ovirt-engine-dwhd.log reports below error:

XXXX-03-XX 00:00:00|jKdQfP|V1S079|PR4T54|OVIRT_ENGINE_DWH|HourlyTimeKeepingJob|Default|5|tWarn|tWarn_1|XXXX-03-XX 00:00:00| ETL service aggregation to hourly tables has encountered an error. lastHourAgg value =Thu Mar 25 23:00:00 WIB 2021 and runTime = Fri Mar XX00:00:00 WIB XXXX .Please consult the service log for more details.|42
Exception in component tJDBCInput_3
org.postgresql.util.PSQLException: An I/O error occured while sending to the backend.
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:281)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:283)
at ovirt_engine_dwh.hourlytimekeepingjob_4_3.HourlyTimeKeepingJob.tJDBCInput_3Process(HourlyTimeKeepingJob.java:1528)
at ovirt_engine_dwh.hourlytimekeepingjob_4_3.HourlyTimeKeepingJob.tJDBCConnection_3Process(HourlyTimeKeepingJob.java:1258)
at ovirt_engine_dwh.hourlytimekeepingjob_4_3.HourlyTimeKeepingJob.tPostjob_1Process(HourlyTimeKeepingJob.java:1133)
at ovirt_engine_dwh.hourlytimekeepingjob_4_3.HourlyTimeKeepingJob.runJobInTOS(HourlyTimeKeepingJob.java:9507)
at ovirt_engine_dwh.hourlytimekeepingjob_4_3.HourlyTimeKeepingJob.runJob(HourlyTimeKeepingJob.java:9158)
at ovirt_engine_dwh.parallelrun_4_3.ParallelRun.tInfiniteLoop_2Process(ParallelRun.java:3123)
at ovirt_engine_dwh.parallelrun_4_3.ParallelRun.tJava_3Process(ParallelRun.java:2884)
at ovirt_engine_dwh.parallelrun_4_3.ParallelRun$3.run(ParallelRun.java:5666)
Caused by: java.io.IOException: Stream closed
at sun.nio.cs.StreamEncoder.ensureOpen(StreamEncoder.java:45)
at sun.nio.cs.StreamEncoder.flush(StreamEncoder.java:140)
at java.io.OutputStreamWriter.flush(OutputStreamWriter.java:229)
at org.postgresql.core.PGStream.flush(PGStream.java:517)
at org.postgresql.core.v3.QueryExecutorImpl.sendSync(QueryExecutorImpl.java:1141)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:254)
... 11 more
XXXX-03-XX 00:00:00|3sipe1|V1S079|PR4T54|OVIRT_ENGINE_DWH|HourlyTimeKeepingJob|Default|6|Java Exception|tJDBCInput_3|org.postgresql.util.PSQLException:An I/O error occured while sending to the backend.|1
XXXX-03-XX 00:00:00|o28EJA|V1S079|PR4T54|OVIRT_ENGINE_DWH|HourlyTimeKeepingJob|Default|5|tWarn|tWarn_1|2021-03-30 00:00:00| ETL service aggregation to hourly tables has encountered an error. lastHourAgg value =Mon Mar XX 23:00:00 WIB XXXX and runTime = Tue Mar 30 00:00:00 WIB XXXX .Please consult the service log for more details.|42



Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.