On Thu, Jul 18, 2019 at 6:11 PM Strahil Nikolov <[email protected]> wrote: > > Thanks Didi, > > I have checked the log and I don't see anything related to that time. > > /var/log/ovirt-engine-dwh/ovirt-engine-dwhd.log: > 2019-07-18 > 03:00:01|rzhdBd|ayRRMN|6ekzCe|OVIRT_ENGINE_DWH|DeleteTimeKeepingJob|Default|6|Java > Exception|tJDBCInput_10|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-18 > 03:01:16|CoHZYa|ayRRMN|6ekzCe|OVIRT_ENGINE_DWH|DeleteTimeKeepingJob|Default|6|Java > Exception|tJDBCInput_10|org.postgresql.util.PSQLException:This connection > has been closed.|1 > (END) > > > In the correlated logs there is nothing for that time. > Last info is found in > /var/opt/rh/rh-postgresql10/lib/pgsql/data/log/postgresql-07.log: > > 2019-07-15 20:27:07.927 UTC LOG: worker process: logical replication > launcher (PID 1618) exited with exit code 1 > 2019-07-15 20:27:07.929 UTC LOG: shutting down > 2019-07-15 20:27:08.608 UTC LOG: database system is shut down > 2019-07-15 20:29:00.155 UTC LOG: database system was shut down at 2019-07-15 > 20:27:08 UTC > 2019-07-15 20:29:00.299 UTC LOG: database system is ready to accept > connections > 2019-07-15 20:45:43.057 UTC LOG: using stale statistics instead of current > ones because stats collector is not responding > 2019-07-15 20:45:53.307 UTC LOG: using stale statistics instead of current > ones because stats collector is not responding > 2019-07-16 12:03:11.820 UTC LOG: unexpected EOF on client connection with an > open transaction > > > Do you know a way to enable debug logs , so I can further investigate > 'OVIRT_ENGINE_DWH|DeleteTimeKeepingJob|Default|6|Java > Exception|tJDBCInput_10|org.postgresql.util.PSQLException:This connection has > been closed.|1' exception ?
No idea, adding Shirly. Best regards, > > > Best Regards, > Strahil Nikolov > > > > В четвъртък, 18 юли 2019 г., 09:39:42 ч. Гринуич+3, Yedidyah Bar David > <[email protected]> написа: > > > On Wed, Jul 17, 2019 at 6:15 PM Strahil Nikolov <[email protected]> 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 > > _______________________________________________ > Users mailing list -- [email protected] > To unsubscribe send an email to [email protected] > Privacy Statement: https://www.ovirt.org/site/privacy-policy/ > oVirt Code of Conduct: > https://www.ovirt.org/community/about/community-guidelines/ > List Archives: > https://lists.ovirt.org/archives/list/[email protected]/message/KGH43M7NKHZ5AYF5V2ONR26T4COXSTJH/ > -- Didi _______________________________________________ Users mailing list -- [email protected] To unsubscribe send an email to [email protected] Privacy Statement: https://www.ovirt.org/site/privacy-policy/ oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/ List Archives: https://lists.ovirt.org/archives/list/[email protected]/message/FAR5KQM47LEYM4MUOIIJRODQPEYGOBB7/
