Hello, Had a problem with the engine server, the clock changed to 2026 and now I don't have any report on the dashboard. The version is 4.2.3.8-1.el7 Any idea? Thanks -- Jose Ferradeira http://www.logicworks.pt
Most probably the dwh is far in the future. The following is not the correct procedure , but it works: ssh root@engine su - postgres source /opt/rh/rh-postgresql10/enable psql engine engine=# select * from dwh_history_timekeeping ; Best Regards, Strahil Nikolov В понеделник, 18 януари 2021 г., 19:22:51 Гринуич+2, José Ferradeira via Users <users@ovirt.org> написа: Hello, Had a problem with the engine server, the clock changed to 2026 and now I don't have any report on the dashboard. The version is 4.2.3.8-1.el7 Any idea? Thanks -- ________________________________ Jose Ferradeira http://www.logicworks.pt _______________________________________________ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-leave@ovirt.org Privacy Statement: https://www.ovirt.org/privacy-policy.html oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/ List Archives: https://lists.ovirt.org/archives/list/users@ovirt.org/message/KPW5FFKG3AI6EI...
Hello, # su - postgres -bash-4.2$ source /opt/rh/rh-postgresql10/enable -bash: /opt/rh/rh-postgresql10/enable: No such file or directory -bash-4.2$ psql engine -bash: psql: command not found -bash-4.2$ What am I doing wrong? Thanks José De: "Strahil Nikolov" <hunter86_bg@yahoo.com> Para: "users" <users@ovirt.org>, suporte@logicworks.pt Enviadas: Segunda-feira, 18 De Janeiro de 2021 19:16:17 Assunto: Re: [ovirt-users] Ovirt reporting dashboard not working Most probably the dwh is far in the future. The following is not the correct procedure , but it works: ssh root@engine su - postgres source /opt/rh/rh-postgresql10/enable psql engine engine=# select * from dwh_history_timekeeping ; Best Regards, Strahil Nikolov В понеделник, 18 януари 2021 г., 19:22:51 Гринуич+2, José Ferradeira via Users <users@ovirt.org> написа: Hello, Had a problem with the engine server, the clock changed to 2026 and now I don't have any report on the dashboard. The version is 4.2.3.8-1.el7 Any idea? Thanks -- ________________________________ Jose Ferradeira http://www.logicworks.pt _______________________________________________ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-leave@ovirt.org Privacy Statement: https://www.ovirt.org/privacy-policy.html oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/ List Archives: https://lists.ovirt.org/archives/list/users@ovirt.org/message/KPW5FFKG3AI6EI...
The postgres is older than 10: postgresql-jdbc-9.2.1002-6.el7_5.noarch postgresql-libs-9.2.23-3.el7_4.x86_64 rh-postgresql95-postgresql-server-9.5.9-4.el7.x86_64 rh-postgresql95-runtime-2.2-2.el7.x86_64 rh-postgresql95-postgresql-9.5.9-4.el7.x86_64 rh-postgresql95-postgresql-contrib-9.5.9-4.el7.x86_64 rh-postgresql95-postgresql-libs-9.5.9-4.el7.x86_64 collectd-postgresql-5.8.0-3.el7.x86_64 Should I use this instead: su - postgres scl enable rh-postgresql95 bash psql Thanks José De: suporte@logicworks.pt Para: "Strahil Nikolov" <hunter86_bg@yahoo.com> Cc: "users" <users@ovirt.org> Enviadas: Sexta-feira, 22 De Janeiro de 2021 16:39:04 Assunto: Re: [ovirt-users] Ovirt reporting dashboard not working Hello, # su - postgres -bash-4.2$ source /opt/rh/rh-postgresql10/enable -bash: /opt/rh/rh-postgresql10/enable: No such file or directory -bash-4.2$ psql engine -bash: psql: command not found -bash-4.2$ What am I doing wrong? Thanks José De: "Strahil Nikolov" <hunter86_bg@yahoo.com> Para: "users" <users@ovirt.org>, suporte@logicworks.pt Enviadas: Segunda-feira, 18 De Janeiro de 2021 19:16:17 Assunto: Re: [ovirt-users] Ovirt reporting dashboard not working Most probably the dwh is far in the future. The following is not the correct procedure , but it works: ssh root@engine su - postgres source /opt/rh/rh-postgresql10/enable psql engine engine=# select * from dwh_history_timekeeping ; Best Regards, Strahil Nikolov В понеделник, 18 януари 2021 г., 19:22:51 Гринуич+2, José Ferradeira via Users <users@ovirt.org> написа: Hello, Had a problem with the engine server, the clock changed to 2026 and now I don't have any report on the dashboard. The version is 4.2.3.8-1.el7 Any idea? Thanks -- ________________________________ Jose Ferradeira http://www.logicworks.pt _______________________________________________ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-leave@ovirt.org Privacy Statement: https://www.ovirt.org/privacy-policy.html oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/ List Archives: https://lists.ovirt.org/archives/list/users@ovirt.org/message/KPW5FFKG3AI6EI...
Try using the 'source /opt/rh/rh-postgresql95/enable' Best Regards,Strahil Nikolov В 19:53 +0000 на 22.01.2021 (пт), José Ferradeira via Users написа:
The postgres is older than 10: postgresql-jdbc-9.2.1002-6.el7_5.noarch postgresql-libs-9.2.23-3.el7_4.x86_64 rh-postgresql95-postgresql-server-9.5.9-4.el7.x86_64 rh-postgresql95-runtime-2.2-2.el7.x86_64 rh-postgresql95-postgresql-9.5.9-4.el7.x86_64 rh-postgresql95-postgresql-contrib-9.5.9-4.el7.x86_64 rh-postgresql95-postgresql-libs-9.5.9-4.el7.x86_64 collectd-postgresql-5.8.0-3.el7.x86_64
Should I use this instead: su - postgresscl enable rh-postgresql95 bashpsql Thanks
José De: suporte@logicworks.pt Para: "Strahil Nikolov" <hunter86_bg@yahoo.com> Cc: "users" <users@ovirt.org> Enviadas: Sexta-feira, 22 De Janeiro de 2021 16:39:04 Assunto: Re: [ovirt-users] Ovirt reporting dashboard not working
Hello,
# su - postgres -bash-4.2$ source /opt/rh/rh-postgresql10/enable -bash: /opt/rh/rh-postgresql10/enable: No such file or directory -bash-4.2$ psql engine -bash: psql: command not found -bash-4.2$
What am I doing wrong?
Thanks
José
De: "Strahil Nikolov" <hunter86_bg@yahoo.com> Para: "users" <users@ovirt.org>, suporte@logicworks.pt Enviadas: Segunda-feira, 18 De Janeiro de 2021 19:16:17 Assunto: Re: [ovirt-users] Ovirt reporting dashboard not working
Most probably the dwh is far in the future.
The following is not the correct procedure , but it works:
ssh root@engine su - postgres source /opt/rh/rh-postgresql10/enable psql engine
engine=# select * from dwh_history_timekeeping ;
Best Regards, Strahil Nikolov
В понеделник, 18 януари 2021 г., 19:22:51 Гринуич+2, José Ferradeira via Users <users@ovirt.org> написа:
Hello,
Had a problem with the engine server, the clock changed to 2026 and now I don't have any report on the dashboard. The version is 4.2.3.8-1.el7
Any idea?
Thanks
_______________________________________________Users mailing list -- users@ovirt.org To unsubscribe send an email to users-leave@ovirt.org Privacy Statement: https://www.ovirt.org/privacy-policy.html oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/ List Archives: https://lists.ovirt.org/archives/list/users@ovirt.org/message/6YETINUGJEPAZS...
That worked there are 4 lines with dates 2026-03-26. What should I do? I'm not an expert in postgresql thanks De: "Strahil Nikolov" <hunter86_bg@yahoo.com> Para: suporte@logicworks.pt Cc: "users" <users@ovirt.org> Enviadas: Sábado, 23 De Janeiro de 2021 13:20:32 Assunto: Re: [ovirt-users] Re: Ovirt reporting dashboard not working Try using the 'source /opt/rh/rh-postgresql95/enable' Best Regards, Strahil Nikolov В 19:53 +0000 на 22.01.2021 (пт), José Ferradeira via Users написа: The postgres is older than 10: postgresql-jdbc-9.2.1002-6.el7_5.noarch postgresql-libs-9.2.23-3.el7_4.x86_64 rh-postgresql95-postgresql-server-9.5.9-4.el7.x86_64 rh-postgresql95-runtime-2.2-2.el7.x86_64 rh-postgresql95-postgresql-9.5.9-4.el7.x86_64 rh-postgresql95-postgresql-contrib-9.5.9-4.el7.x86_64 rh-postgresql95-postgresql-libs-9.5.9-4.el7.x86_64 collectd-postgresql-5.8.0-3.el7.x86_64 Should I use this instead: su - postgres scl enable rh-postgresql95 bash psql Thanks José De: suporte@logicworks.pt Para: "Strahil Nikolov" <hunter86_bg@yahoo.com> Cc: "users" <users@ovirt.org> Enviadas: Sexta-feira, 22 De Janeiro de 2021 16:39:04 Assunto: Re: [ovirt-users] Ovirt reporting dashboard not working Hello, # su - postgres -bash-4.2$ source /opt/rh/rh-postgresql10/enable -bash: /opt/rh/rh-postgresql10/enable: No such file or directory -bash-4.2$ psql engine -bash: psql: command not found -bash-4.2$ What am I doing wrong? Thanks José De: "Strahil Nikolov" <hunter86_bg@yahoo.com> Para: "users" <users@ovirt.org>, suporte@logicworks.pt Enviadas: Segunda-feira, 18 De Janeiro de 2021 19:16:17 Assunto: Re: [ovirt-users] Ovirt reporting dashboard not working Most probably the dwh is far in the future. The following is not the correct procedure , but it works: ssh root@engine su - postgres source /opt/rh/rh-postgresql10/enable psql engine engine=# select * from dwh_history_timekeeping ; Best Regards, Strahil Nikolov В понеделник, 18 януари 2021 г., 19:22:51 Гринуич+2, José Ferradeira via Users <users@ovirt.org> написа: Hello, Had a problem with the engine server, the clock changed to 2026 and now I don't have any report on the dashboard. The version is 4.2.3.8-1.el7 Any idea? Thanks _______________________________________________ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-leave@ovirt.org Privacy Statement: https://www.ovirt.org/privacy-policy.html oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/ List Archives: https://lists.ovirt.org/archives/list/users@ovirt.org/message/6YETINUGJEPAZS...
Should I use this to delete the year 2026 from the rows? DELETE FROM dwh_history_timekeeping WHERE EXTRACT(year FROM "date") = 2026; thanks José De: "José Ferradeira via Users" <users@ovirt.org> Para: "Strahil Nikolov" <hunter86_bg@yahoo.com> Cc: "users" <users@ovirt.org> Enviadas: Segunda-feira, 25 De Janeiro de 2021 18:17:50 Assunto: [ovirt-users] Re: Ovirt reporting dashboard not working That worked there are 4 lines with dates 2026-03-26. What should I do? I'm not an expert in postgresql thanks De: "Strahil Nikolov" <hunter86_bg@yahoo.com> Para: suporte@logicworks.pt Cc: "users" <users@ovirt.org> Enviadas: Sábado, 23 De Janeiro de 2021 13:20:32 Assunto: Re: [ovirt-users] Re: Ovirt reporting dashboard not working Try using the 'source /opt/rh/rh-postgresql95/enable' Best Regards, Strahil Nikolov В 19:53 +0000 на 22.01.2021 (пт), José Ferradeira via Users написа: The postgres is older than 10: postgresql-jdbc-9.2.1002-6.el7_5.noarch postgresql-libs-9.2.23-3.el7_4.x86_64 rh-postgresql95-postgresql-server-9.5.9-4.el7.x86_64 rh-postgresql95-runtime-2.2-2.el7.x86_64 rh-postgresql95-postgresql-9.5.9-4.el7.x86_64 rh-postgresql95-postgresql-contrib-9.5.9-4.el7.x86_64 rh-postgresql95-postgresql-libs-9.5.9-4.el7.x86_64 collectd-postgresql-5.8.0-3.el7.x86_64 Should I use this instead: su - postgres scl enable rh-postgresql95 bash psql Thanks José De: suporte@logicworks.pt Para: "Strahil Nikolov" <hunter86_bg@yahoo.com> Cc: "users" <users@ovirt.org> Enviadas: Sexta-feira, 22 De Janeiro de 2021 16:39:04 Assunto: Re: [ovirt-users] Ovirt reporting dashboard not working Hello, # su - postgres -bash-4.2$ source /opt/rh/rh-postgresql10/enable -bash: /opt/rh/rh-postgresql10/enable: No such file or directory -bash-4.2$ psql engine -bash: psql: command not found -bash-4.2$ What am I doing wrong? Thanks José De: "Strahil Nikolov" <hunter86_bg@yahoo.com> Para: "users" <users@ovirt.org>, suporte@logicworks.pt Enviadas: Segunda-feira, 18 De Janeiro de 2021 19:16:17 Assunto: Re: [ovirt-users] Ovirt reporting dashboard not working Most probably the dwh is far in the future. The following is not the correct procedure , but it works: ssh root@engine su - postgres source /opt/rh/rh-postgresql10/enable psql engine engine=# select * from dwh_history_timekeeping ; Best Regards, Strahil Nikolov В понеделник, 18 януари 2021 г., 19:22:51 Гринуич+2, José Ferradeira via Users <users@ovirt.org> написа: Hello, Had a problem with the engine server, the clock changed to 2026 and now I don't have any report on the dashboard. The version is 4.2.3.8-1.el7 Any idea? Thanks _______________________________________________ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-leave@ovirt.org Privacy Statement: https://www.ovirt.org/privacy-policy.html oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/ List Archives: https://lists.ovirt.org/archives/list/users@ovirt.org/message/6YETINUGJEPAZS... _______________________________________________ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-leave@ovirt.org Privacy Statement: https://www.ovirt.org/privacy-policy.html oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/ List Archives: https://lists.ovirt.org/archives/list/users@ovirt.org/message/KG34CLI5MIUT7O...
Nope, just update it (this is just an example, check postgresql docu for the UPDATE statement):UPDATE dwh_history_timekeeping SET lastSampling = '2021-01-26 11 11:00:01.131+00'; Same for all fields having the time in the future. Bedt Regards,Strahil Nikolov Sent from Yahoo Mail on Android On Tue, Jan 26, 2021 at 19:38, José Ferradeira via Users<users@ovirt.org> wrote: _______________________________________________ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-leave@ovirt.org Privacy Statement: https://www.ovirt.org/privacy-policy.html oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/ List Archives: https://lists.ovirt.org/archives/list/users@ovirt.org/message/RDMSESARKHEGCV...
It worked for me , but my HE is 4.3.10. Best Regards,Strahil Nikolov В 16:39 +0000 на 22.01.2021 (пт), José Ferradeira via Users написа:
Hello,
# su - postgres -bash-4.2$ source /opt/rh/rh-postgresql10/enable -bash: /opt/rh/rh-postgresql10/enable: No such file or directory -bash-4.2$ psql engine -bash: psql: command not found -bash-4.2$
What am I doing wrong?
Thanks
José
De: "Strahil Nikolov" <hunter86_bg@yahoo.com> Para: "users" <users@ovirt.org>, suporte@logicworks.pt Enviadas: Segunda-feira, 18 De Janeiro de 2021 19:16:17 Assunto: Re: [ovirt-users] Ovirt reporting dashboard not working
Most probably the dwh is far in the future.
The following is not the correct procedure , but it works:
ssh root@engine su - postgres source /opt/rh/rh-postgresql10/enable psql engine
engine=# select * from dwh_history_timekeeping ;
Best Regards, Strahil Nikolov
В понеделник, 18 януари 2021 г., 19:22:51 Гринуич+2, José Ferradeira via Users <users@ovirt.org> написа:
Hello,
Had a problem with the engine server, the clock changed to 2026 and now I don't have any report on the dashboard. The version is 4.2.3.8-1.el7
Any idea?
Thanks
_______________________________________________Users mailing list -- users@ovirt.org To unsubscribe send an email to users-leave@ovirt.org Privacy Statement: https://www.ovirt.org/privacy-policy.html oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/ List Archives: https://lists.ovirt.org/archives/list/users@ovirt.org/message/XFLUOHFPYPYRID...
participants (2)
-
Strahil Nikolov -
suporte＠logicworks.pt