On Wed, Jul 17, 2019 at 6:15 PM Strahil Nikolov <hunter86_bg@yahoo.com> wrote:
Hi Sandro,

It seems this issue is not related to current RC (earliest entry found for 02 Feb 2019).

I have followed RH Solution #3338001 (https://access.redhat.com/solutions/3338001) and last night I didn't have that event in the UI.

It seems that I still have exceptions in the logs like :
Exception in component tJDBCInput_3
org.postgresql.util.PSQLException: This connection has been closed.
        at org.postgresql.jdbc2.AbstractJdbc2Connection.checkClosed(AbstractJdbc2Connection.java:822)
        at org.postgresql.jdbc3.AbstractJdbc3Connection.createStatement(AbstractJdbc3Connection.java:229)
        at org.postgresql.jdbc2.AbstractJdbc2Connection.createStatement(AbstractJdbc2Connection.java:294)
        at ovirt_engine_dwh.dailytimekeepingjob_4_3.DailyTimeKeepingJob.tJDBCInput_3Process(DailyTimeKeepingJob.java:1331)
        at ovirt_engine_dwh.dailytimekeepingjob_4_3.DailyTimeKeepingJob.tPostjob_1Process(DailyTimeKeepingJob.java:1070)
        at ovirt_engine_dwh.dailytimekeepingjob_4_3.DailyTimeKeepingJob.runJobInTOS(DailyTimeKeepingJob.java:8784)
        at ovirt_engine_dwh.dailytimekeepingjob_4_3.DailyTimeKeepingJob.runJob(DailyTimeKeepingJob.java:8375)
        at ovirt_engine_dwh.parallelrun_4_3.ParallelRun.tInfiniteLoop_3Process(ParallelRun.java:3539)
        at ovirt_engine_dwh.parallelrun_4_3.ParallelRun.tJava_4Process(ParallelRun.java:3300)
        at ovirt_engine_dwh.parallelrun_4_3.ParallelRun$4.run(ParallelRun.java:5712)
2019-07-17 00:00:00|sykykw|ayRRMN|6ekzCe|OVIRT_ENGINE_DWH|DailyTimeKeepingJob|Default|6|Java Exception|tJDBCInput_3|org.postgresql.util.PSQLException:This connection has been closed.|1
Exception in component tJDBCInput_10
org.postgresql.util.PSQLException: This connection has been closed.
        at org.postgresql.jdbc2.AbstractJdbc2Connection.checkClosed(AbstractJdbc2Connection.java:822)
        at org.postgresql.jdbc3.AbstractJdbc3Connection.createStatement(AbstractJdbc3Connection.java:229)
        at org.postgresql.jdbc2.AbstractJdbc2Connection.createStatement(AbstractJdbc2Connection.java:294)
        at ovirt_engine_dwh.deletetimekeepingjob_4_3.DeleteTimeKeepingJob.tJDBCInput_10Process(DeleteTimeKeepingJob.java:1493)
        at ovirt_engine_dwh.deletetimekeepingjob_4_3.DeleteTimeKeepingJob.tPostjob_2Process(DeleteTimeKeepingJob.java:1232)
        at ovirt_engine_dwh.deletetimekeepingjob_4_3.DeleteTimeKeepingJob.runJobInTOS(DeleteTimeKeepingJob.java:11707)
        at ovirt_engine_dwh.deletetimekeepingjob_4_3.DeleteTimeKeepingJob.runJob(DeleteTimeKeepingJob.java:11308)
        at ovirt_engine_dwh.parallelrun_4_3.ParallelRun.tInfiniteLoop_6Process(ParallelRun.java:4174)
        at ovirt_engine_dwh.parallelrun_4_3.ParallelRun.tJava_5Process(ParallelRun.java:3716)
        at ovirt_engine_dwh.parallelrun_4_3.ParallelRun$5.run(ParallelRun.java:5758)
2019-07-17 03:00:01|QGmtgL|ayRRMN|6ekzCe|OVIRT_ENGINE_DWH|DeleteTimeKeepingJob|Default|6|Java Exception|tJDBCInput_10|org.postgresql.util.PSQLException:This connection has been closed.|1

I'm not sure how fatal are those, as this type of exceptions are logged for a lot of time - the earliest occurrence I found in the logs is for : 'etlVersion|4.2.4.3' from 2019-01-31 .


So , latest RC seems to be OK.

Thanks, changing subject accordingly.

Can you please check PG logs at the same times of these errors? Should be in /var/opt/rh/rh-postgresql10/lib/pgsql/data/log .

Thanks and best regards,
--
Didi