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.|1Exception in component
tJDBCInput_10org.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 12019-07-15 20:27:07.929 UTC LOG: shutting
down2019-07-15 20:27:08.608 UTC LOG: database system is shut down2019-07-15
20:29:00.155 UTC LOG: database system was shut down at 2019-07-15 20:27:08
UTC2019-07-15 20:29:00.299 UTC LOG: database system is ready to accept
connections2019-07-15 20:45:43.057 UTC LOG: using stale statistics instead of
current ones because stats collector is not responding2019-07-15 20:45:53.307
UTC LOG: using stale statistics instead of current ones because stats
collector is not responding2019-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 ?
Best Regards,Strahil Nikolov
В четвъртък, 18 юли 2019 г., 09:39:42 ч. Гринуич+3, Yedidyah Bar David
<d...@redhat.com> написа:
On Wed, Jul 17, 2019 at 6:15 PM Strahil Nikolov <hunter86...@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_3org.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.|1Exception in component
tJDBCInput_10org.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 -- users@ovirt.org
To unsubscribe send an email to users-le...@ovirt.org
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/users@ovirt.org/message/KGH43M7NKHZ5AYF5V2ONR26T4COXSTJH/
_______________________________________________
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-le...@ovirt.org
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/users@ovirt.org/message/DXQCU6OQYP5KCN4CPLQGHYR65N62EGCY/
