Re: [ovirt-users] ETL service sampling has encountered an error. Please consult the service log for more details.
Hi Nicolas, These are DWH error. I see in engine.log that around the time you are referring to there are many connectipn errors to the postgresql database. When DWH is unable to connect to the engine database and error is sent to the ovirt-engine-history.log. I don't see the error you are referring to in the engine.log. The DWH samples every 20 second for statistics that are used to create the ovirt dashboards. If there is a problem with the postgres connection then the hourly aggregation of the samples failed too. I see that first postgres connection error started at 2017-04-20 11:06:04,162+01 ERROR . I see the problem with the database is still not fixed. Please check for the reason your database connection keeps closing. Best regards, -- SHIRLY RADCO BI SOFTWARE ENGINEER, Red Hat Israel <https://www.redhat.com/> sra...@redhat.com <https://red.ht/sig> <https://redhat.com/summit> On Thu, Apr 20, 2017 at 2:12 PM, wrote: > Hi, > > We're using oVirt 4.1.1.8 (upgraded yesterday) and since it has been > showing some strange errors I'd like to know about: > > ETL service sampling has encountered an error. Please consult the > service log for more details. > > I'm attaching the engine log FWIW. This message showed up at 11:07:04 but > in the log I see the exceptions started 1 minute ago. > > Also, at 11:07:58 this event showed up: > > Engine server is not responding. > > And at 11:12:58 it seems to recover: > > Engine server is up and running. > > At 12:00:00 this message showed up: > > ETL service aggregation to hourly tables has encountered an error. > Please consult the service log for more details. > > But relative to this one I see nothing in logs. > > Could someone clarify what these error messages mean? > > Thanks. > ___ > Users mailing list > Users@ovirt.org > http://lists.ovirt.org/mailman/listinfo/users > > ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] oVirt 4.1.2 and rubygem-fluent-plugin packages missing
Hi, These package are required for oVirt Metrics. We added in 4.1.3 as part of the setup script to also install these packages if they are missing. You are not required to manually install them. Best regards, -- SHIRLY RADCO BI SOFTWARE ENGINEER, Red Hat Israel <https://www.redhat.com/> sra...@redhat.com <https://red.ht/sig> <https://redhat.com/summit> On Tue, Jul 4, 2017 at 3:24 PM, Gianluca Cecchi wrote: > > Hello, > an environment with engine in 4.1.2 and 3 hosts too (updated all from > 4.0.5 3 days ago). > In web admin gui the 3 hosts keep the symbol that there are updates > available. > > In events message board I have > > Check for available updates on host ovirt01.localdomain.local was > completed successfully with message 'found updates for packages > rubygem-fluent-plugin-collectd-nest-0.1.3-1.el7, > rubygem-fluent-plugin-viaq_data_model-0.0.3-1.el7'. > > But on host: > > [root@ovirt01 qemu]# yum update > Loaded plugins: fastestmirror, langpacks > Loading mirror speeds from cached hostfile > * base: it.centos.contactlab.it > * epel: mirror.spreitzer.ch > * extras: it.centos.contactlab.it > * ovirt-4.1: ftp.nluug.nl > * ovirt-4.1-epel: mirror.spreitzer.ch > * updates: it.centos.contactlab.it > No packages marked for update > [root@ovirt01 qemu]# > > And > [root@ovirt01 qemu]# rpm -q rubygem-fluent-plugin-collectd-nest > rubygem-fluent-plugin-viaq_data_model > package rubygem-fluent-plugin-collectd-nest is not installed > package rubygem-fluent-plugin-viaq_data_model is not installed > [root@ovirt01 qemu]# > > Is it a bug in 4.1.2? Or should I manually install these two packages? > > Thanks, > Gianluca > > ___ > Users mailing list > Users@ovirt.org > http://lists.ovirt.org/mailman/listinfo/users > > ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] Ovirt Engine Reports oVirt >= 4
Hi Victor, oVirt reports is not available since v4.0. The oVirt DWH is available, can be queried by external reporting solutions that support sql queries. We are currently working on a the new metrics store solution for oVirt. Please see: http://www.ovirt.org/develop/release-management/features/engine/metrics-store/ http://www.ovirt.org/develop/release-management/features/engine/metrics-store-collected-metrics Best regards, -- SHIRLY RADCO BI SOFTWARE ENGINEER, Red Hat Israel <https://www.redhat.com/> sra...@redhat.com <https://red.ht/sig> <https://redhat.com/summit> On Wed, Jul 19, 2017 at 6:57 AM, Victor José Acosta Domínguez < vic.a...@gmail.com> wrote: > Hello everyone, quick question, is ovirt-engine-reports deprecated on > oVirt >= 4? > > Because i don't find ovirt-engine-reports package on oVirt's 4 repo. > > > Regards > > Victor Acosta > > > > ___ > Users mailing list > Users@ovirt.org > http://lists.ovirt.org/mailman/listinfo/users > > ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] ovirt reports
Hi Mahdi, oVirt reports has been deprecated in 4.0. We are working on the new oVirt metrics store solution. Please see http://www.ovirt.org/develop/release-management/features/metrics/metrics-store/ Best regards, -- SHIRLY RADCO BI SOFTWARE ENGINEER Red Hat Israel <https://www.redhat.com/> <https://red.ht/sig> TRIED. TESTED. TRUSTED. <https://redhat.com/trusted> On Mon, Aug 21, 2017 at 2:20 PM, Mahdi Adnan wrote: > Hi, > > > Im looking into getting reports out of ovirt, the documentation is not > clear on how to get started with reporting, and the link to ovirt reports > is broken; > > http://www.ovirt.org/documentation/how-to/reports/dwh/Ovirt_Reports# > documentation how to reports dwh Ovirt Reports > > > Any idea how to get data from DWH ? > > > -- > > Respectfully > *Mahdi A. Mahdi* > > > ___ > Users mailing list > Users@ovirt.org > http://lists.ovirt.org/mailman/listinfo/users > > ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] Is this guide still valid?data-warehouse
Hi John, Please review these pages. Not sure what happened there Best, -- SHIRLY RADCO BI SOFTWARE ENGINEER Red Hat Israel <https://www.redhat.com/> <https://red.ht/sig> TRIED. TESTED. TRUSTED. <https://redhat.com/trusted> -- Forwarded message -- From: Arman Khalatyan Date: Mon, Sep 25, 2017 at 11:39 AM Subject: [ovirt-users] Is this guide still valid?data-warehouse To: users Dear Ovirt documents maintainers is this document still valid? https://www.ovirt.org/documentation/data-warehouse/Data_Warehouse_Guide/ When I go one level up it is bringing an empty page: https://www.ovirt.org/documentation/data-warehouse/ Thanks, Arman. ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] Is this guide still valid?data-warehouse
Hello Arman, Reports was deprecated in 4.0. DWH is now installed by default with oVirt engine. You can refer to https://www.ovirt.org/documentation/how-to/reports/dwh/ You can change its scale to save longer period of time if you want https://www.ovirt.org/documentation/data-warehouse/Changing_the_Data_Warehouse_Sampling_Scale/ and attach a reports solution that supports sql. I'll update the docs with the information about reports and fix the links. Thank you for reaching out on this issue. We are currently also working on adding oVirt Metrics solution that you can read about at https://www.ovirt.org/develop/release-management/features/metrics/metrics-store/ It is still in development stages. Best regards, -- SHIRLY RADCO BI SOFTWARE ENGINEER Red Hat Israel <https://www.redhat.com/> <https://red.ht/sig> TRIED. TESTED. TRUSTED. <https://redhat.com/trusted> On Mon, Sep 25, 2017 at 11:39 AM, Arman Khalatyan wrote: > Dear Ovirt documents maintainers is this document still valid? > https://www.ovirt.org/documentation/data-warehouse/Data_Warehouse_Guide/ > When I go one level up it is bringing an empty page: > https://www.ovirt.org/documentation/data-warehouse/ > > Thanks, > Arman. > > ___ > Users mailing list > Users@ovirt.org > http://lists.ovirt.org/mailman/listinfo/users > > ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] Is this guide still valid?data-warehouse
-- SHIRLY RADCO BI SOFTWARE ENGINEER Red Hat Israel <https://www.redhat.com/> <https://red.ht/sig> TRIED. TESTED. TRUSTED. <https://redhat.com/trusted> On Wed, Sep 27, 2017 at 4:26 PM, Arman Khalatyan wrote: > Thank you for clarification, > So in the future you are going to push everything to kibana as a storage, > what about dashboards or some kind of reports views. > Are you going to provide some reports templates as before in dwh in 3.0.6 > eg heatmaps etc..? > Templates for monitoring.Yes. > From the https://www.ovirt.org/develop/release-management/ > features/metrics/metrics-store-installation/ one need to install > OpenShift+kibana, Why then openshift not Ovirt?? > Openshift will run elasticsearch, fluentd, kibana, curator. This is the platform that was chosen as the common metrics and logging solution at this point. > > On Wed, Sep 27, 2017 at 9:56 AM, Shirly Radco wrote: > >> Hello Arman, >> >> Reports was deprecated in 4.0. >> >> DWH is now installed by default with oVirt engine. >> You can refer to https://www.ovirt.org/documentation/how-to/reports/dwh/ >> >> You can change its scale to save longer period of time if you want >> https://www.ovirt.org/documentation/data-warehouse/Changing_ >> the_Data_Warehouse_Sampling_Scale/ >> and attach a reports solution that supports sql. >> >> I'll update the docs with the information about reports and fix the links. >> >> Thank you for reaching out on this issue. >> >> We are currently also working on adding oVirt Metrics solution that you >> can read about at >> https://www.ovirt.org/develop/release-management/features/me >> trics/metrics-store/ >> It is still in development stages. >> >> Best regards, >> >> -- >> >> SHIRLY RADCO >> >> BI SOFTWARE ENGINEER >> >> Red Hat Israel <https://www.redhat.com/> >> <https://red.ht/sig> >> TRIED. TESTED. TRUSTED. <https://redhat.com/trusted> >> >> On Mon, Sep 25, 2017 at 11:39 AM, Arman Khalatyan >> wrote: >> >>> Dear Ovirt documents maintainers is this document still valid? >>> https://www.ovirt.org/documentation/data-warehouse/Data_Warehouse_Guide/ >>> When I go one level up it is bringing an empty page: >>> https://www.ovirt.org/documentation/data-warehouse/ >>> >>> Thanks, >>> Arman. >>> >>> ___ >>> Users mailing list >>> Users@ovirt.org >>> http://lists.ovirt.org/mailman/listinfo/users >>> >>> >> > ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] Can you update the wiki about how to setup ovirt reports development?
Hi, Just wonted to give you an update I'm correctly working on updating http://www.ovirt.org/How_to_setup_a_oVirt_Reports_development_environment and http://www.ovirt.org/How_to_setup_a_oVirt_DWH_development_environment Best regards, --- Shirly Radco BI Software Engineer Red Hat Israel Ltd. - Original Message - > From: "张亚琪" > To: users@ovirt.org > Sent: Wednesday, November 12, 2014 4:42:03 AM > Subject: [ovirt-users] Can you update the wiki about how to setup ovirt > reports development? > > hi all , > I am trying to view the ovirt-reports code based on the version of 3.5. And > it's necessary that setting up the reports development. But the wiki of > http://www.ovirt.org/How_to_setup_a_oVirt_Reports_development_environment > had become obsolete. So would you share the right method of how to setup a > ovirt reports development environment based on 3.5 version? Thank u for > consideration. > > ___ > Users mailing list > Users@ovirt.org > http://lists.ovirt.org/mailman/listinfo/users > ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] No utilization data on Ovirt report 3.4
Hi Chandrahasa, Please provide me with a few details. 1. Is the dwh service running (ovirt-engine-dwhd) ? 2. What version of rpms are installed ? rpm -qa |grep ovirt 3. Is the data collected correctly to the history database? you can check specifically in v3_4_statistics_vms_resources_usage_samples, v3_4_statistics_vms_resources_usage_hourly, v3_4_statistics_vms_resources_usage_daily 4. Can you see other reports? 5. Please attach the dwh and reports logs if you see errors there (at /var/log/) Best regards, --- Shirly Radco BI Software Engineer Red Hat Israel Ltd. - Original Message - > From: "Chandrahasa S" > To: users@ovirt.org > Sent: Wednesday, November 19, 2014 12:17:21 PM > Subject: [ovirt-users] No utilization data on Ovirt report 3.4 > > Dear Expert, > > I have upgraded my ovirt to 3.4, now Ovirt Report portal is opening but I > could not see any utilization data. It says no data available. > > Screen shot attached below. > > > > > Thanks & Regards > Chandrahasa S > > > =-=-= > Notice: The information contained in this e-mail > message and/or attachments to it may contain > confidential or privileged information. If you are > not the intended recipient, any dissemination, use, > review, distribution, printing or copying of the > information contained in this e-mail message > and/or attachments to it are strictly prohibited. If > you have received this communication in error, > please notify us by reply e-mail or telephone and > immediately and permanently delete the message > and any attachments. Thank you > > > > ___ > Users mailing list > Users@ovirt.org > http://lists.ovirt.org/mailman/listinfo/users > ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] Billing solution
Hi Nikos,
Currently there is no billing solution, but you can open an RFE bug for it.
Please write in the description the use case and requirements in detail,
of how you would like to see this implemented.
Best regards,
---
Shirly Radco
BI Software Engineer
Red Hat Israel Ltd.
- Original Message -
> From: "Nikos Zaharioudakis"
> To: users@ovirt.org
> Sent: Thursday, November 20, 2014 12:26:47 PM
> Subject: [ovirt-users] Billing solution
>
>
> Hi list,
>
> Is there a recommendation for any billing solution or the end user just have
> to take the reports / create custom from the data-warehouse reporting
> portal?
> Of course I guess there is the option to ask over the API, but if someone has
> invented the wheel ...
>
> Best,
>
> Nikos
>
> 3
> Zaharioudakis Nikos, RHC{A,DS,E,VA,X,I}, VCP(4,5},VCI, Mentor VCI, Zimbra
> Instructor
> https://www.redhat.com/wapps/training/certification/verify.html?certNumber=100-001-262&isSearch=False&verify=Verify
> Public Calendar :
> https://www.google.com/calendar/embed?src=nzahar%40gmail.com&ctz=Europe/Athens
> +30 694 720 40 63
> http://zimbra.wikidot.com/zimbra-installations-in-greece
>
> ___
> Users mailing list
> Users@ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
>
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] No utilization data on Ovirt report 3.4
Hi, Please try to restart the VM by performing a shut down or power off, power on, and verify that the service is started by running. sudo systemctl status ovirt-guest-agent.service Please update me if the data is now being collected to the history database. You can check v3_6_statistics_vms_resources_usage_hourly view. Best regards, --- Shirly Radco BI Software Engineer Red Hat Israel Ltd. - Original Message - > From: "Scott Worthington" > To: users@ovirt.org > Sent: Thursday, November 20, 2014 4:14:07 PM > Subject: Re: [ovirt-users] No utilization data on Ovirt report 3.4 > > On 11/19/2014 7:29 AM, Shirly Radco wrote: > > Hi Chandrahasa, > > > > Please provide me with a few details. > > > > 1. Is the dwh service running (ovirt-engine-dwhd) ? > > > > 2. What version of rpms are installed ? rpm -qa |grep ovirt > > > > 3. Is the data collected correctly to the history database? > > you can check specifically in > > v3_4_statistics_vms_resources_usage_samples, > > v3_4_statistics_vms_resources_usage_hourly, > > v3_4_statistics_vms_resources_usage_daily > > > > 4. Can you see other reports? > > > > 5. Please attach the dwh and reports logs if you see errors there (at > > /var/log/) > > > > Best regards, > > --- > > Shirly Radco > > BI Software Engineer > > Red Hat Israel Ltd. > > I had a similar problem with a fresh install of oVirt 3.5.0 on RHEL 6.6 bare > metal. I installed the Engine, then DWH and Reports on the same host. > > Oddly, reports for Hosts worked, but reports for for Virtual Machines did not > collect data (for example, report BR10C = Resource Usage of Virtual Machine > --- by Hour of Day). > > I looked at logs DHW, vdsm, engine, etc logs, and I did not see any errors > relating to database connectivity, pollers not collecting data, etc. The > service ovirt-engine-dwhd was running. > > So, yesterday, I made the assumption that perhaps there was a problem with > the > installer and re-ran "engine-setup". This morning, I checked the report > BR10C, and the graphs for "CPU Usage by Hour of Day", "Memory Usage by Hour > of > Day" now have bar graphs (they work!). > > However, the "Top Five Busiest Disks Usage by Hour of Day" and "Top Three > Businest Network Interfaces Usage" report "No Data Available". The VM does > have the oVirt 3.5 guest software installed. > > How do I troubleshoot the "No Data Available" for 'Disk Usage' and 'Network > Interfaces'? > > Output of my re-running of engine-setup: > > # engine-setup > [ INFO ] Stage: Initializing > [ INFO ] Stage: Environment setup > Configuration files: > ['/etc/ovirt-engine-setup.conf.d/10-packaging-jboss.conf', > '/etc/ovirt-engine-setup.conf.d/10-packaging.conf', > '/etc/ovirt-engine-setup.conf.d/20-setup-ovirt-post.conf'] > Log file: > /var/log/ovirt-engine/setup/ovirt-engine-setup-20141119085759-rah3nk.log > Version: otopi-1.3.0 (otopi-1.3.0-1.el6) > [ INFO ] Stage: Environment packages setup > [ INFO ] Stage: Programs detection > [ INFO ] Stage: Environment setup > [ INFO ] Stage: Environment customization > > --== PRODUCT OPTIONS ==-- > > > --== PACKAGES ==-- > > [ INFO ] Checking for product updates... > [ INFO ] No product updates found > > --== ALL IN ONE CONFIGURATION ==-- > > > --== NETWORK CONFIGURATION ==-- > > Setup can automatically configure the firewall on this system. > Note: automatic configuration of the firewall may overwrite current > settings. > Do you want Setup to configure the firewall? (Yes, No) [Yes]: No > > --== DATABASE CONFIGURATION ==-- > > The detected DWH database size is 99 MB. > Setup can backup the existing database. The time and space required > for the database backup depend on its size. This process takes time, and in > some cases (for instance, when the size is few GBs) may take several hours to > complete. > If you choose to not back up the database, and Setup later fails > for > some reason, it will not be able to restore the database and all DWH data > will > be lost. > Would you like to backup the existing database before upgrading it? > (Yes, No) [Yes]: Yes > > --== OVIRT ENGINE CONFIGURATION ==-- > > Skipping storing options as database already prepared > > --== PKI CONFIGURATION ==-- > > > --== APACHE CON
Re: [ovirt-users] Can you update the wiki about how to setup ovirt reports development?
Hi, The documents are now updated. Best regards, --- Shirly Radco BI Software Engineer Red Hat Israel Ltd. - Original Message - > From: "张亚琪" > To: "Shirly Radco" > Cc: users@ovirt.org > Sent: Wednesday, November 19, 2014 12:43:56 PM > Subject: Re: [ovirt-users] Can you update the wiki about how to setup ovirt > reports development? > > Perfect. Thank you, Shirly. > > 2014-11-19 18:03 GMT+08:00 Shirly Radco : > > > Hi, > > > > Just wonted to give you an update I'm correctly working on updating > > > > http://www.ovirt.org/How_to_setup_a_oVirt_Reports_development_environment > > and > > http://www.ovirt.org/How_to_setup_a_oVirt_DWH_development_environment > > > > Best regards, > > --- > > Shirly Radco > > BI Software Engineer > > Red Hat Israel Ltd. > > > > > > - Original Message - > > > From: "张亚琪" > > > To: users@ovirt.org > > > Sent: Wednesday, November 12, 2014 4:42:03 AM > > > Subject: [ovirt-users] Can you update the wiki about how to setup ovirt > > reports development? > > > > > > hi all , > > > I am trying to view the ovirt-reports code based on the version of 3.5. > > And > > > it's necessary that setting up the reports development. But the wiki of > > > > > http://www.ovirt.org/How_to_setup_a_oVirt_Reports_development_environment > > > had become obsolete. So would you share the right method of how to setup > > a > > > ovirt reports development environment based on 3.5 version? Thank u for > > > consideration. > > > > > > ___ > > > Users mailing list > > > Users@ovirt.org > > > http://lists.ovirt.org/mailman/listinfo/users > > > > > > ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] Billing solution
Hi Nikos,
Did you open a bug for this issue?
Best regards,
---
Shirly Radco
BI Software Engineer
Red Hat Israel Ltd.
- Original Message -
> From: "Nikos Zaharioudakis"
> To: "Dan Kenigsberg"
> Cc: "Shirly Radco" , users@ovirt.org
> Sent: Thursday, November 20, 2014 3:36:24 PM
> Subject: Re: [ovirt-users] Billing solution
>
> Hi Dan (et all),
>
> you know that the customers are always unsatisfied:-(
>
> The first important stuff would be to have in place the metrics of
> consumption of the
> resources some hoster "sell" to a customer. So usage metrics on
> CPU / RAM / DISK / Network (over provisioned or not is another story)
> There is an aspect on actual usage versus provisioned usage.
> {vm provisioned 10 GB of RAM bus os+app uses just 5 GB of them etc)
> But let's keep it simple.
>
> Should we have the usage reference then a GUI that the can define
> the cost plans, would be ideal. A way to query if possible that
> database, would ease existing ERPs and invoicing software to
> produce / send invoices. This is for mostly post paid use cases.
>
> For prepaid situations, there must be some regular accounting that
> will stop the service through our current API. It sounds a bit scaring to
> actually shutdown the provisioned vm. So at least on first step stop the
> networking
> I guess that the base is to create a separate database that will keep the
> consumed metrics, so that customers could actually use it to
> enforce some business logic. (as explained above).
> Should there be a minimal gui that could a small hoster create
> his owns plans and perhaps issue some "invoice" would be ideal.
> Since there are a number of open source billing systems out there,
> perhaps the integration is not that complicated. A second thought would
> be to extend the data ware house gui to create the "invoice" outputs
> as most of the usage info is there.
> I know that ovirt is supposed to be a virtualization solution and not
> a full monty billing system.
>
> Thanks for reading so far.
>
> Nikos
>
>
> Nikos
>
> 3
> Zaharioudakis Nikos, RHC{A,DS,E,VA,X,I}, VCP(4,5},VCI, Mentor VCI, Zimbra
> Instructor
> https://www.redhat.com/wapps/training/certification/verify.html?certNumber=100-001-262&isSearch=False&verify=Verify
> Public Calendar :
> https://www.google.com/calendar/embed?src=nzahar%40gmail.com&ctz=Europe/Athens
> +30 694 720 40 63
> http://zimbra.wikidot.com/zimbra-installations-in-greece
>
> 2014-11-20 15:08 GMT+02:00 Dan Kenigsberg :
>
> > On Thu, Nov 20, 2014 at 02:20:46PM +0200, Nikos Zaharioudakis wrote:
> > > Brilliant,
> > >
> > > Thanks for the info gents
> > > Looking forward for 3.6 then :-)
> >
> > Just waiting may not be enough: I'd love to understand what are the
> > metrics you'd like to use for billing.
> >
> > I mentioned cummulative values of network, storage, and cpu per VM. Can
> > you consider anything else? The latter two are begging for an RFE to be
> > open, as well as the report-centric RFE requested by Shirly.
> >
>
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] No utilization data on Ovirt report 3.4
Hi Scott, Chandrahasa, Did you manage to resolve this issue? Best regards, --- Shirly Radco BI Software Engineer Red Hat Israel Ltd. - Original Message - > From: "Shirly Radco" > To: "Scott Worthington" > Cc: users@ovirt.org > Sent: Sunday, November 23, 2014 11:14:05 AM > Subject: Re: [ovirt-users] No utilization data on Ovirt report 3.4 > > Hi, > > Please try to restart the VM by performing a shut down or power off, power > on, and verify that the service is started by running. > > sudo systemctl status ovirt-guest-agent.service > > Please update me if the data is now being collected to the history database. > > You can check v3_6_statistics_vms_resources_usage_hourly view. > > Best regards, > --- > Shirly Radco > BI Software Engineer > Red Hat Israel Ltd. > > > - Original Message - > > From: "Scott Worthington" > > To: users@ovirt.org > > Sent: Thursday, November 20, 2014 4:14:07 PM > > Subject: Re: [ovirt-users] No utilization data on Ovirt report 3.4 > > > > On 11/19/2014 7:29 AM, Shirly Radco wrote: > > > Hi Chandrahasa, > > > > > > Please provide me with a few details. > > > > > > 1. Is the dwh service running (ovirt-engine-dwhd) ? > > > > > > 2. What version of rpms are installed ? rpm -qa |grep ovirt > > > > > > 3. Is the data collected correctly to the history database? > > > you can check specifically in > > > v3_4_statistics_vms_resources_usage_samples, > > > v3_4_statistics_vms_resources_usage_hourly, > > > v3_4_statistics_vms_resources_usage_daily > > > > > > 4. Can you see other reports? > > > > > > 5. Please attach the dwh and reports logs if you see errors there (at > > > /var/log/) > > > > > > Best regards, > > > --- > > > Shirly Radco > > > BI Software Engineer > > > Red Hat Israel Ltd. > > > > I had a similar problem with a fresh install of oVirt 3.5.0 on RHEL 6.6 > > bare > > metal. I installed the Engine, then DWH and Reports on the same host. > > > > Oddly, reports for Hosts worked, but reports for for Virtual Machines did > > not > > collect data (for example, report BR10C = Resource Usage of Virtual Machine > > --- by Hour of Day). > > > > I looked at logs DHW, vdsm, engine, etc logs, and I did not see any errors > > relating to database connectivity, pollers not collecting data, etc. The > > service ovirt-engine-dwhd was running. > > > > So, yesterday, I made the assumption that perhaps there was a problem with > > the > > installer and re-ran "engine-setup". This morning, I checked the report > > BR10C, and the graphs for "CPU Usage by Hour of Day", "Memory Usage by Hour > > of > > Day" now have bar graphs (they work!). > > > > However, the "Top Five Busiest Disks Usage by Hour of Day" and "Top Three > > Businest Network Interfaces Usage" report "No Data Available". The VM does > > have the oVirt 3.5 guest software installed. > > > > How do I troubleshoot the "No Data Available" for 'Disk Usage' and 'Network > > Interfaces'? > > > > Output of my re-running of engine-setup: > > > > # engine-setup > > [ INFO ] Stage: Initializing > > [ INFO ] Stage: Environment setup > > Configuration files: > > ['/etc/ovirt-engine-setup.conf.d/10-packaging-jboss.conf', > > '/etc/ovirt-engine-setup.conf.d/10-packaging.conf', > > '/etc/ovirt-engine-setup.conf.d/20-setup-ovirt-post.conf'] > > Log file: > > /var/log/ovirt-engine/setup/ovirt-engine-setup-20141119085759-rah3nk.log > > Version: otopi-1.3.0 (otopi-1.3.0-1.el6) > > [ INFO ] Stage: Environment packages setup > > [ INFO ] Stage: Programs detection > > [ INFO ] Stage: Environment setup > > [ INFO ] Stage: Environment customization > > > > --== PRODUCT OPTIONS ==-- > > > > > > --== PACKAGES ==-- > > > > [ INFO ] Checking for product updates... > > [ INFO ] No product updates found > > > > --== ALL IN ONE CONFIGURATION ==-- > > > > > > --== NETWORK CONFIGURATION ==-- > > > > Setup can automatically configure the firewall on this system. > > Note: automatic configuration of the firewall may overwrite > > current > > settings. > >
Re: [ovirt-users] ovirt report portal question
Hi Tibor, You can't make your own queries using the reports portal, but you can query directly from the ovirt_egine_history database using the API views. There are the v3_5_statistics_vms_disks_resources_usage_samples /hourly /daily views, They include vm disks usage data. And join them with the other relevant views like v3_5_configuration_history_vms and v3_5_configuration_history_vms_disks. We also plan on adding in 3.6 the vms disk usage including templates and snapshots. Best regards, --- Shirly Radco BI Software Engineer Red Hat Israel Ltd. - Original Message - > From: "Demeter Tibor" > To: "users@ovirt.org List" > Sent: Thursday, November 27, 2014 5:26:12 PM > Subject: [ovirt-users] ovirt report portal question > > > Hi all, > > How can I make own querys in engine reports? > > I would like to see the CONSUMED disk usage of a VM /day or /month. > > Is it possible? > Thanks in advance, > > Tibor > > > > ___ > Users mailing list > Users@ovirt.org > http://lists.ovirt.org/mailman/listinfo/users > ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] ovirt report portal question
Hi Tibor, You need to know sql in order to create the data sets that the reports are based on. Best regards, --- Shirly Radco BI Software Engineer Red Hat Israel Ltd. - Original Message - > From: "Demeter Tibor" > To: "Yaniv Dary" > Cc: "users@ovirt.org List" , "Shirly Radco" > > Sent: Monday, December 1, 2014 12:48:58 PM > Subject: Re: [ovirt-users] ovirt report portal question > > Hi, > > I'm sorry for my last email:( I didn't see your emails. > > Thank you for the tips. > > Need to know programming for use jasper studio? > > Thanks > > Tibor > > > > > > - Eredeti üzenet - > > You can use JasperReports Studio to create reports and they will be saved > > if > > you use the "Saved Reports" folder. > > You can find guide to use this tool in the JasperSoft community website. > > > > > > > > > > Yaniv > > > > - Original Message - > > > From: "Shirly Radco" > > > To: "Demeter Tibor" > > > Cc: "users@ovirt.org List" , "Yaniv Dary" > > > > > > Sent: Sunday, November 30, 2014 10:54:42 AM > > > Subject: Re: [ovirt-users] ovirt report portal question > > > > > > Hi Tibor, > > > > > > > > > You can't make your own queries using the reports portal, > > > but you can query directly from the ovirt_egine_history database using > > > the > > > API views. > > > > > > There are the v3_5_statistics_vms_disks_resources_usage_samples /hourly > > > /daily views, They include vm disks usage data. > > > And join them with the other relevant views like > > > v3_5_configuration_history_vms > > > and v3_5_configuration_history_vms_disks. > > > > > > > > > We also plan on adding in 3.6 the vms disk usage including templates and > > > snapshots. > > > > > > Best regards, > > > --- > > > Shirly Radco > > > BI Software Engineer > > > Red Hat Israel Ltd. > > > > > > > > > - Original Message - > > > > From: "Demeter Tibor" > > > > To: "users@ovirt.org List" > > > > Sent: Thursday, November 27, 2014 5:26:12 PM > > > > Subject: [ovirt-users] ovirt report portal question > > > > > > > > > > > > Hi all, > > > > > > > > How can I make own querys in engine reports? > > > > > > > > I would like to see the CONSUMED disk usage of a VM /day or /month. > > > > > > > > Is it possible? > > > > Thanks in advance, > > > > > > > > Tibor > > > > > > > > > > > > > > > > ___ > > > > Users mailing list > > > > Users@ovirt.org > > > > http://lists.ovirt.org/mailman/listinfo/users > > > > > > > > > > ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] Ovirt 3.5 report install
Hi Juan, Please send us your logs located at /var/logs. Is the message you get exactly the same as in the bug? Best regards, --- Shirly Radco BI Software Engineer Red Hat Israel Ltd. - Original Message - > From: "Juan Carlos YJ. Lin" > To: users@ovirt.org > Sent: Sunday, January 4, 2015 3:49:18 AM > Subject: [ovirt-users] Ovirt 3.5 report install > > I have a issue on install ovirt-reports in 3rd server same as shown > https://bugzilla.redhat.com/show_bug.cgi?id=1150498 > But the bug saids is fixed, how I can apply the fix? > > > Juan Carlos Lin > Unisoft S.A. > +595-993-288330 > > > System-wide Disclaimer --- > "Antes de imprimir, recuérdese de su compromiso con el Medio Ambiente" > "Aviso: Este mensaje es dirigido para su destinatario y contiene > informaciones que no pueden ser usadas por otras personas que no sean su(s) > destinatario(s). La retransmisión del contenido no está autorizada fuera del > contexto de su envío y a quien corresponde. El uso no autorizado de la > información en este mensaje se halla penado por las leyes vigentes en todo > el mundo. Si ha recibido este mensaje por error, por favor bórrala y > notifique al remitente en la brevedad posible. El contenido de este mensaje > no es responsabilidad de la Empresa y debe ser atribuido siempre a su autor. > Gracias." > > ___ > Users mailing list > Users@ovirt.org > http://lists.ovirt.org/mailman/listinfo/users > ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] No utilization data collected Ovirt reports 3.5.1
Hi Punit, What reports are you trying to view? Can you maybe attach also a screenshot? Do you have running ovirt-guest-agent service running on your vms? Best, --- Shirly Radco BI Software Engineer Red Hat Israel Ltd. - Original Message - > From: "Punit Dambiwal" > To: users@ovirt.org, "Martin Pavlik" > Sent: Saturday, January 31, 2015 5:51:09 PM > Subject: [ovirt-users] No utilization data collected Ovirt reports 3.5.1 > > Hi, > > I have updated Ovirt 3.5 to Ovirt 3.5.1...engine,dwh and reports on the same > server...and added 5 hostnode...i have created some vm's but no utilization > data collected by reports server > > i haven't seen any error in the reports and dwh logs > > Thanks, > Punit > > ___ > Users mailing list > Users@ovirt.org > http://lists.ovirt.org/mailman/listinfo/users > ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] dwh not receiving any data
Hi David, It means that for some reason user with user_id ab932902-cead-4435-a2b6-8b88576feab6 was not added to users_details_history. And this is why the etl can't update the vm_samples_history table on the ovirt_engine_history database. Please check if this user_id ab932902-cead-4435-a2b6-8b88576feab6 exists in the "dwh_users_history_view" or in the users table in the engine database. Select * From dwh_users_history_view Where user_id = 'ab932902-cead-4435-a2b6-8b88576feab6'; Best regards, --- Shirly Radco BI Software Engineer Red Hat Israel Ltd. - Original Message - > From: "David van zeebroeck" > To: users@ovirt.org > Sent: Thursday, January 29, 2015 5:10:01 PM > Subject: [ovirt-users] dwh not receiving any data > > hi > we are running ovirt 3.5.1 and we are trying to setup the dwh part > install and setup appears to run fine but when starting the service we see > following error in the log file : > > 2015-01-29 16:06:26|ETL Service Started > Exception in component tJDBCOutput_5 > org.postgresql.util.PSQLException: ERROR: insert or update on table > "vm_samples_history" violates foreign key constraint > "vm_samples_history_current_user_id_fkey" > Detail: Key (current_user_id)=(ab932902-cead-4435-a2b6-8b88576feab6) is not > present in table "users_details_history". > at > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062) > at > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795) > at > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) > at > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479) > at > org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367) > at > org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321) > at > ovirt_engine_dwh.statisticssync_3_5.StatisticsSync.tJDBCInput_10Process(StatisticsSync.java:10482) > at > ovirt_engine_dwh.statisticssync_3_5.StatisticsSync$6.run(StatisticsSync.java:17437) > Exception in component tJDBCOutput_6 > org.postgresql.util.PSQLException: ERROR: current transaction is aborted, > commands ignored until end of transaction block > at > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062) > at > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795) > at > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) > at > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479) > at > org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367) > at > org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321) > at > ovirt_engine_dwh.statisticssync_3_5.StatisticsSync.tJDBCInput_12Process(StatisticsSync.java:12689) > at > ovirt_engine_dwh.statisticssync_3_5.StatisticsSync$7.run(StatisticsSync.java:17483) > Exception in component tJDBCOutput_7 > org.postgresql.util.PSQLException: ERROR: current transaction is aborted, > commands ignored until end of transaction block > at > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062) > at > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795) > at > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) > at > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479) > at > org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367) > at > org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321) > at > ovirt_engine_dwh.statisticssync_3_5.StatisticsSync.tJDBCInput_18Process(StatisticsSync.java:14806) > at > ovirt_engine_dwh.statisticssync_3_5.StatisticsSync$8.run(StatisticsSync.java:17529) > Exception in component tJDBCOutput_4 > org.postgresql.util.PSQLException: ERROR: current transaction is aborted, > commands ignored until end of transaction block > at > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062) > at > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795) > at > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) > at > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479) > at > org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367) > at > org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement
Re: [ovirt-users] dwh not receiving any data
Hi David, Please update me on what you found. Best regards, --- Shirly Radco BI Software Engineer Red Hat Israel Ltd. - Original Message - > From: "Shirly Radco" > To: "David van zeebroeck" > Cc: users@ovirt.org > Sent: Sunday, February 1, 2015 11:24:10 AM > Subject: Re: [ovirt-users] dwh not receiving any data > > Hi David, > > It means that for some reason user with user_id > ab932902-cead-4435-a2b6-8b88576feab6 > was not added to users_details_history. > And this is why the etl can't update the vm_samples_history table on the > ovirt_engine_history database. > > Please check if this user_id ab932902-cead-4435-a2b6-8b88576feab6 exists in > the "dwh_users_history_view" or in the users table in the engine database. > > Select * From dwh_users_history_view > Where user_id = 'ab932902-cead-4435-a2b6-8b88576feab6'; > > Best regards, > --- > Shirly Radco > BI Software Engineer > Red Hat Israel Ltd. > > > - Original Message - > > From: "David van zeebroeck" > > To: users@ovirt.org > > Sent: Thursday, January 29, 2015 5:10:01 PM > > Subject: [ovirt-users] dwh not receiving any data > > > > hi > > we are running ovirt 3.5.1 and we are trying to setup the dwh part > > install and setup appears to run fine but when starting the service we see > > following error in the log file : > > > > 2015-01-29 16:06:26|ETL Service Started > > Exception in component tJDBCOutput_5 > > org.postgresql.util.PSQLException: ERROR: insert or update on table > > "vm_samples_history" violates foreign key constraint > > "vm_samples_history_current_user_id_fkey" > > Detail: Key (current_user_id)=(ab932902-cead-4435-a2b6-8b88576feab6) is not > > present in table "users_details_history". > > at > > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062) > > at > > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795) > > at > > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) > > at > > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479) > > at > > org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367) > > at > > org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321) > > at > > ovirt_engine_dwh.statisticssync_3_5.StatisticsSync.tJDBCInput_10Process(StatisticsSync.java:10482) > > at > > ovirt_engine_dwh.statisticssync_3_5.StatisticsSync$6.run(StatisticsSync.java:17437) > > Exception in component tJDBCOutput_6 > > org.postgresql.util.PSQLException: ERROR: current transaction is aborted, > > commands ignored until end of transaction block > > at > > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062) > > at > > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795) > > at > > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) > > at > > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479) > > at > > org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367) > > at > > org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321) > > at > > ovirt_engine_dwh.statisticssync_3_5.StatisticsSync.tJDBCInput_12Process(StatisticsSync.java:12689) > > at > > ovirt_engine_dwh.statisticssync_3_5.StatisticsSync$7.run(StatisticsSync.java:17483) > > Exception in component tJDBCOutput_7 > > org.postgresql.util.PSQLException: ERROR: current transaction is aborted, > > commands ignored until end of transaction block > > at > > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062) > > at > > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795) > > at > > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) > > at > > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479) > > at > > org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367) > > at > > org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321) > > at > > ovirt_engine_dwh.statisticssync_3_5.StatisticsSync.tJDBCInput_18Process(StatisticsSync.java:14806) > > at > > ovirt_engine_dwh.statisticssync_3_5.Stat
Re: [ovirt-users] dwh not receiving any data
Hi, If any of you can send me the engine and ovirt_engine_dwh dump, I will upload them in my development environment and see what is the issue. Best regards, --- Shirly Radco BI Software Engineer Red Hat Israel Ltd. - Original Message - > From: "Shirly Radco" > To: "David van zeebroeck" > Cc: users@ovirt.org > Sent: Monday, February 2, 2015 1:04:24 PM > Subject: Re: [ovirt-users] dwh not receiving any data > > Hi David, > > Please update me on what you found. > > Best regards, > --- > Shirly Radco > BI Software Engineer > Red Hat Israel Ltd. > > > - Original Message - > > From: "Shirly Radco" > > To: "David van zeebroeck" > > Cc: users@ovirt.org > > Sent: Sunday, February 1, 2015 11:24:10 AM > > Subject: Re: [ovirt-users] dwh not receiving any data > > > > Hi David, > > > > It means that for some reason user with user_id > > ab932902-cead-4435-a2b6-8b88576feab6 > > was not added to users_details_history. > > And this is why the etl can't update the vm_samples_history table on the > > ovirt_engine_history database. > > > > Please check if this user_id ab932902-cead-4435-a2b6-8b88576feab6 exists in > > the "dwh_users_history_view" or in the users table in the engine database. > > > > Select * From dwh_users_history_view > > Where user_id = 'ab932902-cead-4435-a2b6-8b88576feab6'; > > > > Best regards, > > --- > > Shirly Radco > > BI Software Engineer > > Red Hat Israel Ltd. > > > > > > - Original Message - > > > From: "David van zeebroeck" > > > To: users@ovirt.org > > > Sent: Thursday, January 29, 2015 5:10:01 PM > > > Subject: [ovirt-users] dwh not receiving any data > > > > > > hi > > > we are running ovirt 3.5.1 and we are trying to setup the dwh part > > > install and setup appears to run fine but when starting the service we > > > see > > > following error in the log file : > > > > > > 2015-01-29 16:06:26|ETL Service Started > > > Exception in component tJDBCOutput_5 > > > org.postgresql.util.PSQLException: ERROR: insert or update on table > > > "vm_samples_history" violates foreign key constraint > > > "vm_samples_history_current_user_id_fkey" > > > Detail: Key (current_user_id)=(ab932902-cead-4435-a2b6-8b88576feab6) is > > > not > > > present in table "users_details_history". > > > at > > > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062) > > > at > > > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795) > > > at > > > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) > > > at > > > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479) > > > at > > > org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367) > > > at > > > org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321) > > > at > > > ovirt_engine_dwh.statisticssync_3_5.StatisticsSync.tJDBCInput_10Process(StatisticsSync.java:10482) > > > at > > > ovirt_engine_dwh.statisticssync_3_5.StatisticsSync$6.run(StatisticsSync.java:17437) > > > Exception in component tJDBCOutput_6 > > > org.postgresql.util.PSQLException: ERROR: current transaction is aborted, > > > commands ignored until end of transaction block > > > at > > > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062) > > > at > > > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795) > > > at > > > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) > > > at > > > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479) > > > at > > > org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367) > > > at > > > org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321) > > > at > > > ovirt_engine_dwh.statisticssync_3_5.StatisticsSync.tJDBCInput_12Process(StatisticsSync.java:12689) > > > at > > > ovirt_engine_dwh.statisticssync_3_5.StatisticsSync$7.run(StatisticsSync.java:17483) > > > Exception in component tJDBCOutput_7 > > > org.postgresql.u
Re: [ovirt-users] dwh not receiving any data
Hi Punit, Please send me first the logs so we can see if this is still the same issue. /var/log/ovirt-engine /var/log/ovirt-engine-dwh /var/log/ovirt-engine-reports Best regards, --- Shirly Radco BI Software Engineer Red Hat Israel Ltd. - Original Message - > From: "Punit Dambiwal" > To: "Shirly Radco" > Cc: "David van zeebroeck" , "Joop" > , users@ovirt.org > Sent: Tuesday, February 3, 2015 5:50:57 AM > Subject: Re: [ovirt-users] dwh not receiving any data > > Hi Shirly, > > It seems resolved but actually notagain after 12 hours it stopped > working... > > [image: Inline image 1] > [image: Inline image 3] > > It stopped working after 5:00 AMyesterday (2nd Feb) started at evening > 17:00 PM...and stopped today 3rd Feb 5:00 AM > > [image: Inline image 4] > > Please let me know how i can take the dump of engine and dwh to you > > Thanks, > Punit > > On Tue, Feb 3, 2015 at 9:34 AM, Punit Dambiwal wrote: > > > Hi, > > > > My issue resolved by remove the dwh and reports and reinstall > > again..also i found that my server time was correct and updated but the > > postgresql time was different form the server time.above two changes > > made it work... > > > > Thanks, > > punit > > > > On Mon, Feb 2, 2015 at 8:25 PM, Shirly Radco wrote: > > > >> Hi, > >> > >> If any of you can send me the engine and ovirt_engine_dwh dump, > >> I will upload them in my development environment and see what is the > >> issue. > >> > >> Best regards, > >> --- > >> Shirly Radco > >> BI Software Engineer > >> Red Hat Israel Ltd. > >> > >> > >> - Original Message - > >> > From: "Shirly Radco" > >> > To: "David van zeebroeck" > >> > Cc: users@ovirt.org > >> > Sent: Monday, February 2, 2015 1:04:24 PM > >> > Subject: Re: [ovirt-users] dwh not receiving any data > >> > > >> > Hi David, > >> > > >> > Please update me on what you found. > >> > > >> > Best regards, > >> > --- > >> > Shirly Radco > >> > BI Software Engineer > >> > Red Hat Israel Ltd. > >> > > >> > > >> > - Original Message - > >> > > From: "Shirly Radco" > >> > > To: "David van zeebroeck" > >> > > Cc: users@ovirt.org > >> > > Sent: Sunday, February 1, 2015 11:24:10 AM > >> > > Subject: Re: [ovirt-users] dwh not receiving any data > >> > > > >> > > Hi David, > >> > > > >> > > It means that for some reason user with user_id > >> > > ab932902-cead-4435-a2b6-8b88576feab6 > >> > > was not added to users_details_history. > >> > > And this is why the etl can't update the vm_samples_history table on > >> the > >> > > ovirt_engine_history database. > >> > > > >> > > Please check if this user_id ab932902-cead-4435-a2b6-8b88576feab6 > >> exists in > >> > > the "dwh_users_history_view" or in the users table in the engine > >> database. > >> > > > >> > > Select * From dwh_users_history_view > >> > > Where user_id = 'ab932902-cead-4435-a2b6-8b88576feab6'; > >> > > > >> > > Best regards, > >> > > --- > >> > > Shirly Radco > >> > > BI Software Engineer > >> > > Red Hat Israel Ltd. > >> > > > >> > > > >> > > - Original Message - > >> > > > From: "David van zeebroeck" > >> > > > To: users@ovirt.org > >> > > > Sent: Thursday, January 29, 2015 5:10:01 PM > >> > > > Subject: [ovirt-users] dwh not receiving any data > >> > > > > >> > > > hi > >> > > > we are running ovirt 3.5.1 and we are trying to setup the dwh part > >> > > > install and setup appears to run fine but when starting the service > >> we > >> > > > see > >> > > > following error in the log file : > >> > > > > >> > > > 2015-01-29 16:06:26|ETL Service Started > >> > > > Exception in component tJDBCOutput_5 > >> > > > org.postgresql.u
Re: [ovirt-users] dwh not receiving any data
Please attach all logs under the mentioned folders. Best, --- Shirly Radco BI Software Engineer Red Hat Israel Ltd. - Original Message - > From: "Punit Dambiwal" > To: "Shirly Radco" > Cc: "David van zeebroeck" , "Joop" > , users@ovirt.org > Sent: Tuesday, February 3, 2015 8:31:42 AM > Subject: Re: [ovirt-users] dwh not receiving any data > > Hi Shirly, > > Please find the attached log files... > > On Tue, Feb 3, 2015 at 1:56 PM, Shirly Radco wrote: > > > Hi Punit, > > > > Please send me first the logs so we can see if this is still the same > > issue. > > /var/log/ovirt-engine > > /var/log/ovirt-engine-dwh > > /var/log/ovirt-engine-reports > > > > Best regards, > > --- > > Shirly Radco > > BI Software Engineer > > Red Hat Israel Ltd. > > > > > > - Original Message - > > > From: "Punit Dambiwal" > > > To: "Shirly Radco" > > > Cc: "David van zeebroeck" , "Joop" < > > jvdw...@xs4all.nl>, users@ovirt.org > > > Sent: Tuesday, February 3, 2015 5:50:57 AM > > > Subject: Re: [ovirt-users] dwh not receiving any data > > > > > > Hi Shirly, > > > > > > It seems resolved but actually notagain after 12 hours it stopped > > > working... > > > > > > [image: Inline image 1] > > > [image: Inline image 3] > > > > > > It stopped working after 5:00 AMyesterday (2nd Feb) started at > > evening > > > 17:00 PM...and stopped today 3rd Feb 5:00 AM > > > > > > [image: Inline image 4] > > > > > > Please let me know how i can take the dump of engine and dwh to you > > > > > > Thanks, > > > Punit > > > > > > On Tue, Feb 3, 2015 at 9:34 AM, Punit Dambiwal > > wrote: > > > > > > > Hi, > > > > > > > > My issue resolved by remove the dwh and reports and reinstall > > > > again..also i found that my server time was correct and updated > > but the > > > > postgresql time was different form the server time.above two > > changes > > > > made it work... > > > > > > > > Thanks, > > > > punit > > > > > > > > On Mon, Feb 2, 2015 at 8:25 PM, Shirly Radco > > wrote: > > > > > > > >> Hi, > > > >> > > > >> If any of you can send me the engine and ovirt_engine_dwh dump, > > > >> I will upload them in my development environment and see what is the > > > >> issue. > > > >> > > > >> Best regards, > > > >> --- > > > >> Shirly Radco > > > >> BI Software Engineer > > > >> Red Hat Israel Ltd. > > > >> > > > >> > > > >> - Original Message - > > > >> > From: "Shirly Radco" > > > >> > To: "David van zeebroeck" > > > >> > Cc: users@ovirt.org > > > >> > Sent: Monday, February 2, 2015 1:04:24 PM > > > >> > Subject: Re: [ovirt-users] dwh not receiving any data > > > >> > > > > >> > Hi David, > > > >> > > > > >> > Please update me on what you found. > > > >> > > > > >> > Best regards, > > > >> > --- > > > >> > Shirly Radco > > > >> > BI Software Engineer > > > >> > Red Hat Israel Ltd. > > > >> > > > > >> > > > > >> > - Original Message - > > > >> > > From: "Shirly Radco" > > > >> > > To: "David van zeebroeck" > > > >> > > Cc: users@ovirt.org > > > >> > > Sent: Sunday, February 1, 2015 11:24:10 AM > > > >> > > Subject: Re: [ovirt-users] dwh not receiving any data > > > >> > > > > > >> > > Hi David, > > > >> > > > > > >> > > It means that for some reason user with user_id > > > >> > > ab932902-cead-4435-a2b6-8b88576feab6 > > > >> > > was not added to users_details_history. > > > >> > > And this is why the etl can't update the vm_samples_history table > > on > > > >> the > > > >> > > ovirt_engine_history d
Re: [ovirt-users] dwh not receiving any data
Hi, After researching this issue it seams that this is a one time error that should be resolved after a minute. Can you please share with me: 1. if you keep getting this error after a minute ? 2. if you can currently log to your ovirt-engine-history database and see if you see in the vm_samples_history table new up to date samples? Thank you for sharing and helping with this issue. Best regards, --- Shirly Radco BI Software Engineer Red Hat Israel Ltd. - Original Message - > From: "Punit Dambiwal" > To: "Joop" > Cc: users@ovirt.org > Sent: Monday, February 2, 2015 10:32:21 AM > Subject: Re: [ovirt-users] dwh not receiving any data > > Hi, > > I am also facing the same issue with ovirt reports and DWHstill didn't > find any way to solve itis there any body from community can help... > > On Sun, Feb 1, 2015 at 10:42 PM, Joop < jvdw...@xs4all.nl > wrote: > > > On 1-2-2015 10:24, Shirly Radco wrote: > > Hi David, > > > > It means that for some reason user with user_id > > ab932902-cead-4435-a2b6-8b88576feab6 > > was not added to users_details_history. > > And this is why the etl can't update the vm_samples_history table on the > > ovirt_engine_history database. > > > > Please check if this user_id ab932902-cead-4435-a2b6-8b88576feab6 exists in > > the "dwh_users_history_view" or in the users table in the engine database. > > > > Select * From dwh_users_history_view > > Where user_id = 'ab932902-cead-4435-a2b6-8b88576feab6'; > > > > > I suspect I have the same problem. Upgraded (3.5.0->3.5.1) my test > instance at home at look at some reports but saw no new data. Thought is > was just me and had no time to check things out but will do when I have > a bit of time and report back. > > Regards, > > Joop > > ___ > Users mailing list > Users@ovirt.org > http://lists.ovirt.org/mailman/listinfo/users > > > ___ > Users mailing list > Users@ovirt.org > http://lists.ovirt.org/mailman/listinfo/users > ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] dwh not receiving any data
Hi Punit, We are aware of time issue with the way China time is being dealt differently in Postgres and Java and will work to fix this. This is the reason we recommend for now to use UTC time for the servers. Best regards, --- Shirly Radco BI Software Engineer Red Hat Israel Ltd. - Original Message - > From: "Punit Dambiwal" > To: "noc" > Cc: users@ovirt.org > Sent: Friday, February 6, 2015 10:12:38 AM > Subject: Re: [ovirt-users] dwh not receiving any data > > Yes...you are right but earlier my server date is behind the > lasthouraggr.such as the server time is "3:00" AM but when i check the > "lasthouraggr" in the database it was 14:00..it should be 1:00 AM...that's > why i manually updated it... > > As name suggested lasthouraggr that means it should be lower then your > current server time... > > Thanks, > Punit > > On Fri, Feb 6, 2015 at 3:52 PM, noc < n...@nieuwland.nl > wrote: > > > On 6-2-2015 3:15, Punit Dambiwal wrote: > > Hi, > > > > I have solve this issue by manually updated the time of the > > "lastHourAggr" in the ovirt_engine_history database...as it was > > running with wrong timeafter update it's ok > > > > - > I'm sorry but I seem to have no problem after all. If I look at the > report @09:00 then I'll see that it plots data upto about 07:00 and that > is what threw me off. I checked the reports about an hour after upgrading. > > Joop > > ___ > Users mailing list > Users@ovirt.org > http://lists.ovirt.org/mailman/listinfo/users > > > ___ > Users mailing list > Users@ovirt.org > http://lists.ovirt.org/mailman/listinfo/users > ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] DWH Question
Hi Koen, I believe you can use this query: SELECT v3_5_latest_configuration_hosts_interfaces.vlan_id, v3_5_latest_configuration_hosts.host_id, v3_5_statistics_vms_resources_usage_samples.vm_id FROM v3_5_latest_configuration_hosts_interfaces LEFT JOIN v3_5_latest_configuration_hosts ON v3_5_latest_configuration_hosts_interfaces.host_id = v3_5_latest_configuration_hosts.host_id LEFT JOIN v3_5_statistics_vms_resources_usage_samples ON v3_5_latest_configuration_hosts.history_id = v3_5_statistics_vms_resources_usage_samples.current_host_configuration_version LEFT JOIN v3_5_latest_configuration_vms ON v3_5_latest_configuration_vms.history_id = v3_5_statistics_vms_resources_usage_samples.vm_configuration_version LEFT JOIN v3_5_latest_configuration_vms_interfaces ON v3_5_latest_configuration_vms.history_id = v3_5_latest_configuration_vms_interfaces.vm_configuration_version WHERE v3_5_statistics_vms_resources_usage_samples.vm_status = 1 AND v3_5_latest_configuration_hosts_interfaces.vlan_id IS NOT NULL AND v3_5_latest_configuration_vms_interfaces.logical_network_name = v3_5_latest_configuration_hosts_interfaces.logical_network_name GROUP BY v3_5_latest_configuration_hosts_interfaces.vlan_id, v3_5_latest_configuration_hosts.host_id, v3_5_statistics_vms_resources_usage_samples.vm_id ORDER BY v3_5_latest_configuration_hosts_interfaces.vlan_id, v3_5_latest_configuration_hosts.host_id, v3_5_statistics_vms_resources_usage_samples.vm_id If you need more details please let me know. Best regards, --- Shirly Radco BI Software Engineer Red Hat Israel Ltd. - Original Message - > From: "Koen Vanoppen" > To: users@ovirt.org > Sent: Friday, March 13, 2015 9:17:29 AM > Subject: [ovirt-users] DWH Question > > Dear all, > > Is it possible to pull a list of all VMS who are in vlanX? > > Kind regards, > > Koen > > ___ > Users mailing list > Users@ovirt.org > http://lists.ovirt.org/mailman/listinfo/users > ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
[ovirt-users] oVirt 3.5 test day 2 results
Hi, I tested 557125 - internationalize exitMessage; use meaningful exitCode These are the tests I made : power off from inside the guest - VM testexitmessage is down. Exit message: User shut down from within the guest ID 61 power off from inside the admin portal - VM testexitmessage powered off by admin (Host: yanivs) (Reason: Not Specified). ID 33 shotdown from inside the admin portal - VM shutdown initiated by admin on VM testexitmessage (Host: yanivs) (Reason: Not Specified) ID73 VM testexitmessage is down. Exit message: User shut down from within the guest ID61 shotdown from inside the guest - VM testexitmessage is down. Exit message: User shut down from within the guest ID 61 reboot from guest - no exit reason. In espanol shotdown from inside the admin portal - VM shutdown initiated by admin on VM testexitmessage (Host: yanivs) (Reason: Not Specified). ID 73 VM testexitmessage is down. Exit message: User shut down from within the guest ID 61 In Deutsch power off from inside the admin portal - VM testexitmessage powered off by admin (Host: yanivs) (Reason: Not Specified). ID 33 Conclutions: 1. I don't see translations for local langueges for the events in the admin portal. 2. In case of shotdown from inside the admin portal we get 2 messages instead of one. The second one(ID61) is incorrect. Best regards, --- Shirly Radco BI Software Engineer Red Hat Israel Ltd. ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] Reporting tool for Ovirt not available / not working
Hi Chandrahasa, We already sent you an email where we tried to get further details about your problem, But did not get any response back from you. You should reach out to the community, but we can't help unless you respond back with required details. So please try helping us help you. There is not point in this negative approach. Please provide us with details about your reporting problem. 1. What version are you on? 2. Did you install the ovirt-dwh and ovirt-reports and run engine-setup? 3. Please explain what exactly is not working. Can you log into the reports portal? 4. Send us the logs: located at : /var/logs/ovirt-engine /var/logs/ovirt-engine-dwh /var/logs/ovirt-engine-reports Best Regards, --- Shirly Radco BI Software Engineer Red Hat Israel Ltd. - Original Message - > From: "Chandrahasa S" > To: users@ovirt.org > Sent: Tuesday, September 16, 2014 11:15:42 AM > Subject: [ovirt-users] Reporting tool for Ovirt not available / not working > > Dear All, > > We see lots happening on Ovirt overall enhancement, but nothing could see on > Ovirt reporting part. > > Its very difficult to go with Ovirt without having visibility on resource > utilization of each component in Ovirt. > > Is Ovirt project in right path ?? > > Regards, > Chandrahasa S > Tata Consultancy Services > Data Center- ( Non STPI) > 2nd Pokharan Road, > Subash Nagar , > Mumbai - 400601,Maharashtra > India > Ph:- +91 22 677-81825 > Buzz:- 4221825 > Mailto: chandrahas...@tcs.com > Website: http://www.tcs.com > > Experience certainty. IT Services > Business Solutions > Consulting > > > > =-=-= > Notice: The information contained in this e-mail > message and/or attachments to it may contain > confidential or privileged information. If you are > not the intended recipient, any dissemination, use, > review, distribution, printing or copying of the > information contained in this e-mail message > and/or attachments to it are strictly prohibited. If > you have received this communication in error, > please notify us by reply e-mail or telephone and > immediately and permanently delete the message > and any attachments. Thank you > > > > ___ > Users mailing list > Users@ovirt.org > http://lists.ovirt.org/mailman/listinfo/users > ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] Reporting tool for Ovirt not available / not working
Hi Chandrahasa, I'm pleased to tell you that this is a known issue and it was already fixed on 3.4.3. You can see bug https://bugzilla.redhat.com/show_bug.cgi?id=1123876. Please upgrade to current release and let us know if you have any more issues. Best regards, --- Shirly Radco BI Software Engineer Red Hat Israel Ltd. - Original Message - > From: "Chandrahasa S" > To: "Shirly Radco" > Cc: users@ovirt.org > Sent: Tuesday, September 16, 2014 5:18:15 PM > Subject: Re: [ovirt-users] Reporting tool for Ovirt not available / not > working > > 1. What version are you on? > 3.4 > 2. Did you install the ovirt-dwh and ovirt-reports and run engine-setup? > Yes > 3. Please explain what exactly is not working. Can you log into the > reports portal? > Portal is Opening, for example if I want to generate report below one > :- > > > > It gives below wizard > > > Its not allowing to enter any data here. > > When I click OK, it gives below screen with no data. > > > > > > 4. Send us the logs: > located at : /var/logs/ovirt-engine > /var/logs/ovirt-engine-dwh > /var/logs/ovirt-engine-reports > > > > > > Chandra > > > From: Shirly Radco > To: Chandrahasa S > Cc: users@ovirt.org > Date: 09/16/2014 02:12 PM > Subject: Re: [ovirt-users] Reporting tool for Ovirt not available / > not working > > > > Hi Chandrahasa, > > We already sent you an email where we tried to get further details about > your problem, > But did not get any response back from you. > > You should reach out to the community, but we can't help unless you > respond back with required details. > So please try helping us help you. There is not point in this negative > approach. > > Please provide us with details about your reporting problem. > > 1. What version are you on? > 2. Did you install the ovirt-dwh and ovirt-reports and run engine-setup? > 3. Please explain what exactly is not working. Can you log into the > reports portal? > 4. Send us the logs: > located at : /var/logs/ovirt-engine > /var/logs/ovirt-engine-dwh > /var/logs/ovirt-engine-reports > > Best Regards, > --- > Shirly Radco > BI Software Engineer > Red Hat Israel Ltd. > > > - Original Message - > > From: "Chandrahasa S" > > To: users@ovirt.org > > Sent: Tuesday, September 16, 2014 11:15:42 AM > > Subject: [ovirt-users] Reporting tool for Ovirt not available / not > working > > > > Dear All, > > > > We see lots happening on Ovirt overall enhancement, but nothing could > see on > > Ovirt reporting part. > > > > Its very difficult to go with Ovirt without having visibility on > resource > > utilization of each component in Ovirt. > > > > Is Ovirt project in right path ?? > > > > > > > > > > > > =-=-= > > > > > > > > ___ > > Users mailing list > > Users@ovirt.org > > http://lists.ovirt.org/mailman/listinfo/users > > > > ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] How to increase detail in displayed reports
Hi Grzegorz, You can connect to the history database and use the sql api available history views for querying and generating reports, using the ireport or other reporting tools. You can also refer to the reports jrxml files to see the queries used for each available report. There is documentation for most of the available views at https://access.redhat.com/documentation/en-US/Red_Hat_Enterprise_Virtualization/3.3/html/Administration_Guide/sect-Statistics_History_Views.html Note: This is for a older version and might not be fully updated. Best regards, --- Shirly Radco BI Software Engineer Red Hat Israel Ltd. - Original Message - > From: "Grzegorz Szypa" > To: users@ovirt.org > Sent: Friday, September 19, 2014 5:32:49 PM > Subject: [ovirt-users] How to increase detail in displayed reports > > How to increase detail in displayed reports, for example. Network report? > > Can Defining your own reports, if yes, how to do it? > > -- > G.Sz. > > ___ > Users mailing list > Users@ovirt.org > http://lists.ovirt.org/mailman/listinfo/users > ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] oVirt monitoring
Hi Ryan, You can use oVirt reports and dwh packages that collects historical data and provides reports that enable you to monitor the system currently and over time. http://www.ovirt.org/Ovirt_Reports Best regards, --- Shirly Radco BI Software Engineer Red Hat Israel Ltd. - Original Message - > From: "Mooli Tayer" > To: "Ryan Nix" > Cc: users@ovirt.org > Sent: Saturday, October 18, 2014 8:27:30 PM > Subject: Re: [ovirt-users] oVirt monitoring > > Hi Ryan, > > 1.) The Nagios integration page seems to be back up. > > 2.) For monitoring of events available in oVirt-engine's audit log, > It is possible to register for both email and snmp trap notifications[1]. > > A portion of these events are related to managed resources. > > Trap notifications allow integration with monitoring systems. > See: [1], [2] and [3]. > > [1] http://www.ovirt.org/Features/engine-snmp > [2] http://www.ovirt.org/Features/configuration-event-subscribers > [3] https://bugzilla.redhat.com/show_bug.cgi?id=1136818 > This RFE allows easier integration with monitoring systems and should > be available soon. Some work with snmptt can achieve the same result. > > Regards, > Mooli Tayer. > > - Original Message - > > Hello, > > > > I was looking for something to monitor the resources managed by oVirt and > > not > > necessarily oVirt itself. It looks like there is a page on Nagios > > integration, however, I'm getting a 503 when trying to access the site. > > http://www.ovirt.org/Features/Nagios_Integration > > > > Does anyone have any recommendations on monitoring resources managed by > > oVirt? > > > > Thanks, > > > > Ryn > > > > ___ > > Users mailing list > > Users@ovirt.org > > http://lists.ovirt.org/mailman/listinfo/users > > > ___ > Users mailing list > Users@ovirt.org > http://lists.ovirt.org/mailman/listinfo/users > ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] report portal tutorial
Hi, What do you require? If you need how to use the reports portal then, since we use the JasperReports you can use the http://community.jaspersoft.com/documentation?version=9036 Please let me know if you need further details. Best regards, --- Shirly Radco RHEVM oVirt DWH & Reports BI Software Engineer Red Hat Israel Ltd. - Original Message - > From: "alireza sadeh seighalan" > To: users@ovirt.org > Sent: Saturday, January 23, 2016 4:43:28 PM > Subject: [ovirt-users] report portal tutorial > > hi everyone > > is there any good document for report portal administration?thanks in advance > > ___ > Users mailing list > Users@ovirt.org > http://lists.ovirt.org/mailman/listinfo/users > ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] ovirt reports
Hi Fernando, Please check guest agent is running on all hosts. Please also check if you see data from recent days in table "host_hourly_history". Best regards, Shirly Radco Shirly Radco BI Software Engineer Red Hat Israel Ltd. 34 Jerusalem Road Building A, 4th floor Ra'anana, Israel 4350109 On Tue, Apr 5, 2016 at 9:02 AM, Yedidyah Bar David wrote: > On Mon, Apr 4, 2016 at 8:53 PM, Fernando Fuentes > wrote: > > Didi, > > > > As requested. > > > > > > [root@ovirt-dev ~]# service ovirt-engine-dwhd status > > ovirt-engine-dwhd (pid 32410) is running... > > [root@ovirt-dev ~]# > > > > The log is over at pastebin to prevent a huge email/ > > > > http://pastebin.com/hPcYCKVE > > > > Hope that is ok. > > The log looks mostly ok to me. > > Was this a normal, default setup? > > Please post the output of: > > su - postgres -c 'psql -c \\l' > > su - postgres -c "psql -c 'SELECT pg_database.datname, > pg_size_pretty(pg_database_size(pg_database.datname)) FROM > pg_database'" > > su - postgres -c "psql ovirt_engine_reports -c 'select > connectionurl,username from jijdbcdatasource'" > > grep DATABASE /etc/ovirt-engine/engine.conf.d/* > /etc/ovirt-engine-dwh/ovirt-engine-dwhd.conf.d/* > > grep dbName /var/lib/ovirt-engine-reports/build-conf/master.properties > > Adding Shirly. > -- > Didi > ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] ovirt reports
Hi, No. You don't need to reinstall. There should be a cron job that restarts the dwh service after it is down for an hour. Didi, In what cases it will not start? Best regards, Shirly Shirly Radco BI Software Engineer Red Hat Israel Ltd. 34 Jerusalem Road Building A, 4th floor Ra'anana, Israel 4350109 On Tue, Apr 5, 2016 at 6:49 PM, Fernando Fuentes wrote: > Team, > > Digging deaper I found that I do have data and create reports up to Oct of > 2015 Somewhere in Nov 2015 it stop hence why I cant see recent data. > A good note to the list is that November is right around the month I did > the update to 3.5.4.2-1.el6 > Do I have to re-installovirt-engine-reports? > > Regards, > > -- > Fernando Fuentes > ffuen...@txweather.org > http://www.txweather.org > > > > On Tue, Apr 5, 2016, at 10:23 AM, Fernando Fuentes wrote: > > As requested all dumps and info are at: > > http://pastebin.com/RMSP8HFB > > All systems are running the guest agent. > > Regards, > > -- > Fernando Fuentes > ffuen...@txweather.org > http://www.txweather.org > > > > On Tue, Apr 5, 2016, at 03:38 AM, Shirly Radco wrote: > > Hi Fernando, > > Please check guest agent is running on all hosts. > Please also check if you see data from recent days in table > "host_hourly_history". > > Best regards, > Shirly Radco > > > > Shirly Radco > BI Software Engineer > Red Hat Israel Ltd. > 34 Jerusalem Road > Building A, 4th floor > Ra'anana, Israel 4350109 > > > On Tue, Apr 5, 2016 at 9:02 AM, Yedidyah Bar David > wrote: > > On Mon, Apr 4, 2016 at 8:53 PM, Fernando Fuentes > wrote: > > Didi, > > > > As requested. > > > > > > [root@ovirt-dev ~]# service ovirt-engine-dwhd status > > ovirt-engine-dwhd (pid 32410) is running... > > [root@ovirt-dev ~]# > > > > The log is over at pastebin to prevent a huge email/ > > > > http://pastebin.com/hPcYCKVE > > > > Hope that is ok. > > The log looks mostly ok to me. > > Was this a normal, default setup? > > Please post the output of: > > su - postgres -c 'psql -c \\l' > > su - postgres -c "psql -c 'SELECT pg_database.datname, > pg_size_pretty(pg_database_size(pg_database.datname)) FROM > pg_database'" > > su - postgres -c "psql ovirt_engine_reports -c 'select > connectionurl,username from jijdbcdatasource'" > > grep DATABASE /etc/ovirt-engine/engine.conf.d/* > /etc/ovirt-engine-dwh/ovirt-engine-dwhd.conf.d/* > > grep dbName /var/lib/ovirt-engine-reports/build-conf/master.properties > > Adding Shirly. > -- > Didi > > > *___* > Users mailing list > Users@ovirt.org > http://lists.ovirt.org/mailman/listinfo/users > > > > ___ > Users mailing list > Users@ovirt.org > http://lists.ovirt.org/mailman/listinfo/users > > ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] ovirt reports
I believe that dwh was killed and not stopped correctly by service stop, and therefore did not exit cleanly. This is why it did not send an exit message to the log and did not update the engine that dwh is not running. Best, Shirly Shirly Radco BI Software Engineer Red Hat Israel Ltd. 34 Jerusalem Road Building A, 4th floor Ra'anana, Israel 4350109 On Wed, Apr 6, 2016 at 10:08 AM, Yedidyah Bar David wrote: > On Wed, Apr 6, 2016 at 9:51 AM, Shirly Radco wrote: > > Hi, > > > > No. You don't need to reinstall. > > > > There should be a cron job that restarts the dwh service after it is down > > for an hour. > > Didi, In what cases it will not start? > > The log, posted earlier in this thread, seems to show it's actually > running: > > > > > Best regards, > > Shirly > > > > Shirly Radco > > BI Software Engineer > > Red Hat Israel Ltd. > > 34 Jerusalem Road > > Building A, 4th floor > > Ra'anana, Israel 4350109 > > > > > > On Tue, Apr 5, 2016 at 6:49 PM, Fernando Fuentes > > wrote: > >> > >> Team, > >> > >> Digging deaper I found that I do have data and create reports up to Oct > of > >> 2015 Somewhere in Nov 2015 it stop hence why I cant see recent data. > >> A good note to the list is that November is right around the month I did > >> the update to 3.5.4.2-1.el6 > >> Do I have to re-installovirt-engine-reports? > >> > >> Regards, > >> > >> -- > >> Fernando Fuentes > >> ffuen...@txweather.org > >> http://www.txweather.org > >> > >> > >> > >> On Tue, Apr 5, 2016, at 10:23 AM, Fernando Fuentes wrote: > >> > >> As requested all dumps and info are at: > >> > >> http://pastebin.com/RMSP8HFB > >> > >> All systems are running the guest agent. > >> > >> Regards, > >> > >> -- > >> Fernando Fuentes > >> ffuen...@txweather.org > >> http://www.txweather.org > >> > >> > >> > >> On Tue, Apr 5, 2016, at 03:38 AM, Shirly Radco wrote: > >> > >> Hi Fernando, > >> > >> Please check guest agent is running on all hosts. > >> Please also check if you see data from recent days in table > >> "host_hourly_history". > >> > >> Best regards, > >> Shirly Radco > >> > >> > >> > >> Shirly Radco > >> BI Software Engineer > >> Red Hat Israel Ltd. > >> 34 Jerusalem Road > >> Building A, 4th floor > >> Ra'anana, Israel 4350109 > >> > >> > >> On Tue, Apr 5, 2016 at 9:02 AM, Yedidyah Bar David > >> wrote: > >> > >> On Mon, Apr 4, 2016 at 8:53 PM, Fernando Fuentes > >> wrote: > >> > Didi, > >> > > >> > As requested. > >> > > >> > > >> > [root@ovirt-dev ~]# service ovirt-engine-dwhd status > >> > ovirt-engine-dwhd (pid 32410) is running... > >> > [root@ovirt-dev ~]# > >> > > >> > The log is over at pastebin to prevent a huge email/ > >> > > >> > http://pastebin.com/hPcYCKVE > >> > > >> > Hope that is ok. > >> > >> The log looks mostly ok to me. > > The end of it looked like this: > > 2015-11-01 > 02:00:29|YigZCz|UkJGNp|IMHBxO|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|5|tWarn|tWarn_1|Can > not sample data, oVirt Engine is not updating the statistics. Please > check your oVirt Engine status.|9704 > 2016-04-03 14:57:41|ETL Service Stopped > 2016-04-03 15:12:41|ETL Service Started > > From this, I understood that: > 1. Many months ago, either there was some problem (e.g. dwhd could not > connect to engine db, or not see updates there, or whatever) or simply > there was no new data (engine was down, or simply nothing changed (is > this possible?)). > 2. Then things became ok for several months (or at least, nothing > caused dwhd to say otherwise) > 3. Then dwhd was restarted, perhaps for an upgrade, and still no new > errors. > > Fernando: Do you still only get empty reports? > > >> > >> Was this a normal, default setup? > >> > >> Please post the output of: > >> > >> su - postgres -c 'psql -c \\l' > >> > >> su - postgres -c "psql -c 'SELECT pg_database.datname, > >> pg_size_pretty(pg_database_size(pg_database.datname)) FROM > >> pg_database'" > >> > >> su - postgres -c "psql ovirt_engine_reports -c 'select > >> connectionurl,username from jijdbcdatasource'" > >> > >> grep DATABASE /etc/ovirt-engine/engine.conf.d/* > >> /etc/ovirt-engine-dwh/ovirt-engine-dwhd.conf.d/* > >> > >> grep dbName /var/lib/ovirt-engine-reports/build-conf/master.properties > >> > >> Adding Shirly. > >> -- > >> Didi > >> > >> > >> ___ > >> Users mailing list > >> Users@ovirt.org > >> http://lists.ovirt.org/mailman/listinfo/users > >> > >> > >> > >> ___ > >> Users mailing list > >> Users@ovirt.org > >> http://lists.ovirt.org/mailman/listinfo/users > >> > > > > > > -- > Didi > ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] ovirt reports
Hi, Please check now again if you see data from recent days in table "host_hourly_history". What reports are you running and for which period? Are all reports related to host empty? Can you please attach screenshots? Best regards, Shirly Radco Shirly Radco BI Software Engineer Red Hat Israel Ltd. 34 Jerusalem Road Building A, 4th floor Ra'anana, Israel 4350109 On Wed, Apr 6, 2016 at 8:55 PM, Fernando Fuentes wrote: > Didi, > > Yes. I still get empty reports. :( > > -- > Fernando Fuentes > ffuen...@txweather.org > http://www.txweather.org > > On Wed, Apr 6, 2016, at 02:08 AM, Yedidyah Bar David wrote: > > On Wed, Apr 6, 2016 at 9:51 AM, Shirly Radco wrote: > > > Hi, > > > > > > No. You don't need to reinstall. > > > > > > There should be a cron job that restarts the dwh service after it is > down > > > for an hour. > > > Didi, In what cases it will not start? > > > > The log, posted earlier in this thread, seems to show it's actually > > running: > > > > > > > > Best regards, > > > Shirly > > > > > > Shirly Radco > > > BI Software Engineer > > > Red Hat Israel Ltd. > > > 34 Jerusalem Road > > > Building A, 4th floor > > > Ra'anana, Israel 4350109 > > > > > > > > > On Tue, Apr 5, 2016 at 6:49 PM, Fernando Fuentes > > > > wrote: > > >> > > >> Team, > > >> > > >> Digging deaper I found that I do have data and create reports up to > Oct of > > >> 2015 Somewhere in Nov 2015 it stop hence why I cant see recent > data. > > >> A good note to the list is that November is right around the month I > did > > >> the update to 3.5.4.2-1.el6 > > >> Do I have to re-installovirt-engine-reports? > > >> > > >> Regards, > > >> > > >> -- > > >> Fernando Fuentes > > >> ffuen...@txweather.org > > >> http://www.txweather.org > > >> > > >> > > >> > > >> On Tue, Apr 5, 2016, at 10:23 AM, Fernando Fuentes wrote: > > >> > > >> As requested all dumps and info are at: > > >> > > >> http://pastebin.com/RMSP8HFB > > >> > > >> All systems are running the guest agent. > > >> > > >> Regards, > > >> > > >> -- > > >> Fernando Fuentes > > >> ffuen...@txweather.org > > >> http://www.txweather.org > > >> > > >> > > >> > > >> On Tue, Apr 5, 2016, at 03:38 AM, Shirly Radco wrote: > > >> > > >> Hi Fernando, > > >> > > >> Please check guest agent is running on all hosts. > > >> Please also check if you see data from recent days in table > > >> "host_hourly_history". > > >> > > >> Best regards, > > >> Shirly Radco > > >> > > >> > > >> > > >> Shirly Radco > > >> BI Software Engineer > > >> Red Hat Israel Ltd. > > >> 34 Jerusalem Road > > >> Building A, 4th floor > > >> Ra'anana, Israel 4350109 > > >> > > >> > > >> On Tue, Apr 5, 2016 at 9:02 AM, Yedidyah Bar David > > >> wrote: > > >> > > >> On Mon, Apr 4, 2016 at 8:53 PM, Fernando Fuentes < > ffuen...@darktcp.net> > > >> wrote: > > >> > Didi, > > >> > > > >> > As requested. > > >> > > > >> > > > >> > [root@ovirt-dev ~]# service ovirt-engine-dwhd status > > >> > ovirt-engine-dwhd (pid 32410) is running... > > >> > [root@ovirt-dev ~]# > > >> > > > >> > The log is over at pastebin to prevent a huge email/ > > >> > > > >> > http://pastebin.com/hPcYCKVE > > >> > > > >> > Hope that is ok. > > >> > > >> The log looks mostly ok to me. > > > > The end of it looked like this: > > > > 2015-11-01 > > > 02:00:29|YigZCz|UkJGNp|IMHBxO|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|5|tWarn|tWarn_1|Can > > not sample data, oVirt Engine is not updating the statistics. Please > > check your oVirt Engine status.|9704 > > 2016-04-03 14:57:41|ETL Service Stopped > > 2016-04-03 15:12:41|ETL Service Started > > > > From thi
Re: [ovirt-users] 3.6 upgrade issue
Hi, In oreder to figure out the problem please open a bug detailing the error you get. The exact version you are trying to upgrade to and attach the ovirt-engine-dwh.log and the engine-setup log. Thank you, Shirly Radco BI Software Engineer Red Hat Israel Ltd. 34 Jerusalem Road Building A, 4th floor Ra'anana, Israel 4350109 On Tue, Apr 26, 2016 at 9:28 PM, gregor wrote: > Hi, > > today I tried to upgrade from 3.6.4 to 3.6.5, as usual with > engine-setup. This time it gives me an schema update error and after > this the database is corrupt and gives me the same error you get. > > Did you create a bug entry? > I'm tired of creating bugs for oVirt. Every time I touch oVirt I hit 1-5 > bugs, it's so time consuming :-( > > cheers > gregor > > On 22/10/15 14:24, Yaniv Dary wrote: > > History database has a issue. Can you add logs? maybe open a bug? > > > > Yaniv Dary Technical Product Manager Red Hat Israel Ltd. 34 Jerusalem > > Road Building A, 4th floor Ra'anana, Israel 4350109 Tel : +972 (9) > > 7692306 8272306 Email: yd...@redhat.com <mailto:yd...@redhat.com> IRC : > > ydary > > > > > > On Tue, Sep 29, 2015 at 4:45 PM, Jon Archer > <mailto:j...@rosslug.org.uk>> wrote: > > > > Hi all, > > > > Wonder if anyone can shed any light on an error i'm seeing while > > running engine-setup. > > > > If just upgraded the packages to the latest 3.6 ones today (from > > 3.5), run engine-setup, answered the questions, confirming install > > then get presented with: > > [ INFO ] Cleaning async tasks and compensations > > [ INFO ] Unlocking existing entities > > [ INFO ] Checking the Engine database consistency > > [ INFO ] Stage: Transaction setup > > [ INFO ] Stopping engine service > > [ INFO ] Stopping ovirt-fence-kdump-listener service > > [ INFO ] Stopping websocket-proxy service > > [ INFO ] Stage: Misc configuration > > [ INFO ] Stage: Package installation > > [ INFO ] Stage: Misc configuration > > [ ERROR ] Failed to execute stage 'Misc configuration': function > > getdwhhistorytimekeepingbyvarname(unknown) does not exist LINE 2: > > select * from GetDwhHistoryTimekeepingByVarName( > >^ HINT: No function matches the given name > > and argument types. You might need to add explicit type casts. > > [ INFO ] Yum Performing yum transaction rollback > > [ INFO ] Stage: Clean up > > Log file is located at > > > /var/log/ovirt-engine/setup/ovirt-engine-setup-20150929144137-7u5rhg.log > > [ INFO ] Generating answer file > > '/var/lib/ovirt-engine/setup/answers/20150929144215-setup.conf' > > [ INFO ] Stage: Pre-termination > > [ INFO ] Stage: Termination > > [ ERROR ] Execution of setup failed > > > > > > Any ideas, where to look to fix things? > > > > Thanks > > > > Jon > > ___ > > Users mailing list > > Users@ovirt.org <mailto:Users@ovirt.org> > > http://lists.ovirt.org/mailman/listinfo/users > > > > > > > > > > ___ > > Users mailing list > > Users@ovirt.org > > http://lists.ovirt.org/mailman/listinfo/users > > > ___ > Users mailing list > Users@ovirt.org > http://lists.ovirt.org/mailman/listinfo/users > ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] Not Updating Statistics
Hi Fernando, Melissa What version are you using for engine and dwh? https://bugzilla.redhat.com/show_bug.cgi?id=1344935 Versions: ovirt-engine-dwh-setup-4.0.2-1.el7ev.noarch ovirt-engine-setup-4.0.2.6-0.1.el7ev.noarch should not have this issue. Please update me if you still have this issue and attach the ovirt-engine-dwh log. Best regards, Shirly Radco BI Software Engineer Red Hat Israel Ltd. 34 Jerusalem Road Building A, 4th floor Ra'anana, Israel 4350109 On Sat, Aug 20, 2016 at 9:11 PM, Fernando Fuentes wrote: > Team, > > This is still an issue on my env. :( > > 2016-08-20 09:04:56|pIlSG1|2EMUyU|snSJCy|OVIRT_ENGINE_DWH| > SampleTimeKeepingJob|Default|5|tWarn|tWarn_1|Can not sample data, oVirt > Engine is not updating the statistics. Please check your oVirt Engine > status.|9704 > 2016-08-20 10:57:42|3ZzN5z|2EMUyU|snSJCy|OVIRT_ENGINE_DWH| > SampleTimeKeepingJob|Default|5|tWarn|tWarn_1|Can not sample data, oVirt > Engine is not updating the statistics. Please check your oVirt Engine > status.|9704 > 2016-08-20 11:31:33|reczvL|2EMUyU|snSJCy|OVIRT_ENGINE_DWH| > SampleTimeKeepingJob|Default|5|tWarn|tWarn_1|Can not sample data, oVirt > Engine is not updating the statistics. Please check your oVirt Engine > status.|9704 > > Any ideas? > > Thanks for the help! > > -- > Fernando Fuentes > ffuen...@txweather.org > http://www.txweather.org > > > > On Thu, Aug 18, 2016, at 01:35 PM, Fernando Fuentes wrote: > > I am having similar issues though my problem only started after recovering > my DWH DB. > But the errors are the sames as posted below. > > Any ideas? > > Regards, > > -- > Fernando Fuentes > ffuen...@txweather.org > http://www.txweather.org > > > > On Wed, Aug 17, 2016, at 08:47 AM, Sandro Bonazzola wrote: > > Adding Shirly > > On Wed, Aug 17, 2016 at 3:30 PM, Melissa Mesler > wrote: > > All, we are running Ovirt 4.0 on CentOS 7. We have some errors in our > dwh log. Look at the following: > > 2016-08-16 > 13:28:51|mFKcbP|2EMUyU|snSJCy|OVIRT_ENGINE_DWH|SampleTimeKee > pingJob|Default|5|tWarn|tWarn_1|Can > not sample data, oVirt Engine is not updating the statistics. Please > check your oVirt Engine status.|9704 > 2016-08-16 > 19:31:00|dgTmvI|2EMUyU|snSJCy|OVIRT_ENGINE_DWH|SampleTimeKee > pingJob|Default|5|tWarn|tWarn_1|Can > not sample data, oVirt Engine is not updating the statistics. Please > check your oVirt Engine status.|9704 > 2016-08-16 > 23:19:28|ByUf8M|2EMUyU|snSJCy|OVIRT_ENGINE_DWH|SampleTimeKee > pingJob|Default|5|tWarn|tWarn_1|Can > not sample data, oVirt Engine is not updating the statistics. Please > check your oVirt Engine status.|9704 > 2016-08-17 > 00:27:59|jzRGar|2EMUyU|snSJCy|OVIRT_ENGINE_DWH|SampleTimeKee > pingJob|Default|5|tWarn|tWarn_1|Can > not sample data, oVirt Engine is not updating the statistics. Please > check your oVirt Engine status.|9704 > 2016-08-17 > 02:55:01|WZ7M9t|2EMUyU|snSJCy|OVIRT_ENGINE_DWH|SampleTimeKee > pingJob|Default|5|tWarn|tWarn_1|Can > not sample data, oVirt Engine is not updating the statistics. Please > check your oVirt Engine status.|9704 > 2016-08-17 > 04:12:06|Q237ie|2EMUyU|snSJCy|OVIRT_ENGINE_DWH|SampleTimeKee > pingJob|Default|5|tWarn|tWarn_1|Can > not sample data, oVirt Engine is not updating the statistics. Please > check your oVirt Engine status.|9704 > 2016-08-17 > 04:46:12|8COWHX|2EMUyU|snSJCy|OVIRT_ENGINE_DWH|SampleTimeKee > pingJob|Default|5|tWarn|tWarn_1|Can > not sample data, oVirt Engine is not updating the statistics. Please > check your oVirt Engine status.|9704 > > What does this mean? > ___ > Users mailing list > Users@ovirt.org > http://lists.ovirt.org/mailman/listinfo/users > > > > > -- > Sandro Bonazzola > Better technology. Faster innovation. Powered by community collaboration. > See how it works at redhat.com > *___* > Users mailing list > Users@ovirt.org > http://lists.ovirt.org/mailman/listinfo/users > > > *___* > Users mailing list > Users@ovirt.org > http://lists.ovirt.org/mailman/listinfo/users > > > ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] ETL service sampling
The ETL sampling process collects the configurations and statistics for the new dashboards. The engine has a heartbeat that should update every 15 seconds. Sampling runs every 20 seconds. If the engine is busy and the heartbeat does not update for some reason , the dwh will send an error. It compares the last sync with the heartbeat. Heartbeat should be newer than the last sync... Best, Shirly Radco On Aug 24, 2016 12:03 PM, "knarra" wrote: > Hi All, > > I see the event below getting logged in the events tab . What is > this event related to ? Why does this get logged as an error ? > ETL service sampling has encountered an error. Please consult the service > log for more details. > > Thanks > kasturi > > ___ > Users mailing list > Users@ovirt.org > http://lists.ovirt.org/mailman/listinfo/users > > ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] Could not fetch dashboard data. Please ensure that data warehouse is properly installed and configured.
Hi, Did you install ovirt-engine-dwh during the upgrade? Was it installed before? If it is installed , Can you please check the ovirt-engine-dwh.log file for errors? If not, It must be installed in order to view the Dashboards. It is collecting the statistics used for the dashboards. Best regards, Shirly Radco BI Software Engineer Red Hat Israel Ltd. 34 Jerusalem Road Building A, 4th floor Ra'anana, Israel 4350109 On Thu, Aug 25, 2016 at 9:28 AM, Maton, Brett wrote: > I've just upgraded Ovirt3.6 to 4.0.2 and I can't get the dashboard to work. > > The dashboard page displays this error: > > Could not fetch dashboard data. Please ensure that data warehouse is > properly installed and configured. > > Running on CentOS 7.2 > PostgreSQL server 9.5.4 (remote) > > I see these errors being generated in engine.log when I try to display the > dash board > > ERROR [org.ovirt.engine.ui.frontend.server.dashboard.DashboardDataServlet] > (default task-6) [] Unable to retrieve dashboard data: > org.ovirt.engine.ui.frontend.server.dashboard.DashboardDataException: > Error while running SQL query > at > org.ovirt.engine.ui.frontend.server.dashboard.dao.BaseDao.runQuery(BaseDao.java:60) > [frontend.jar:] > at org.ovirt.engine.ui.frontend.server.dashboard.dao.HostDwhDao. > getTotalCpuMemCount(HostDwhDao.java:78) [frontend.jar:] > ... > Caused by: javax.resource.ResourceException: IJ031083: Wrong driver class > [org.postgresql.Driver] for this connection URL [None] > at org.jboss.jca.adapters.jdbc.local. > LocalManagedConnectionFactory.createLocalManagedConnection( > LocalManagedConnectionFactory.java:321) > ... 66 more > > > > > Google returned some hints that it's probably the postgresql java version, > I did have 9.4.xxx installed bu have since downgraded to > postgresql-jdbc-9.2.1002-5 > > I checked the class path generated by dwh-classpath.sh which seems to be > using the correct JDBC driver. > > # /usr/share/ovirt-engine-dwh/bin/dwh-classpath.sh run > :/usr/share/java/dom4j.jar:/usr/share/java/apache-commons- > collections.jar:/usr/share/java/postgresql-jdbc.jar > > # rpm -qf /usr/share/java/postgresql-jdbc.jar > postgresql-jdbc-9.2.1002-5.el7.noarch > > > Any suggestions on what to try next? > > ___ > Users mailing list > Users@ovirt.org > http://lists.ovirt.org/mailman/listinfo/users > > ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] Limit DWH database size
Another option is to set the DWH_SAMPLING back to 60 and restart dwh. This will lower the granularity of the dashboard calculations. The dwh db size grow since now it samples the statistics every 15 seconds instead of once a minute. Best regards, Shirly Radco On Sep 1, 2016 19:29, wrote: > Hi Didi, > > El 2016-09-01 14:02, Yedidyah Bar David escribió: > >> On Thu, Sep 1, 2016 at 3:26 PM, Sandro Bonazzola >> wrote: >> >> Didi, Shirly, can you help here? >>> >>> On Thu, Sep 1, 2016 at 8:52 AM, wrote: >>> >>> Hi, >>>> >>>> Since we upgraded to 4.0.x, DWH's PostgreSQL database is getting >>>> really huge. Is there a clean way to limit its size, like setting >>>> a maximal retention time for DWH data? >>>> >>> >> Earlier today replied to a similar question, search list archives for >> "Change Engine History Logging from Advanched to Basic". >> >> > Just to confirm: I already have basic DWH configured, and the content of > /etc/ovirt-engine-dwh/ovirt-engine-dwhd.conf.d/10-setup-scale.conf is: > > DWH_TABLES_KEEP_SAMPLES=24 > DWH_TABLES_KEEP_HOURLY=720 > DWH_TABLES_KEEP_DAILY=0 > > So according to [1] regarding "DWH_TABLES_KEEP_HOURLY": > > The number of hours that hourly data is stored. The default is 60 days. > Hourly data more than two days old is aggregated into dailydata. > > if I reduce that value to say 240 (10 days), any older entry from that > should be erased upon a DWH restart, right? > > Thanks. > > [1]: https://access.redhat.com/documentation/en-US/Red_Hat_Enterp > rise_Virtualization/3.6/pdf/Reports_and_Data_Warehouse_ > Guide/Red_Hat_Enterprise_Virtualization-3.6-Reports_ > and_Data_Warehouse_Guide-en-US.pdf > > Best, >> >> >> >> Thanks. >>>> ___ >>>> Users mailing list >>>> Users@ovirt.org >>>> http://lists.ovirt.org/mailman/listinfo/users [1] >>>> >>> >>> -- >>> >>> Sandro Bonazzola >>> Better technology. Faster innovation. Powered by community >>> collaboration. >>> See how it works at redhat.com [2] >>> >>> [3] >>> >> >> -- >> >> Didi >> >> >> Links: >> -- >> [1] http://lists.ovirt.org/mailman/listinfo/users >> [2] http://redhat.com >> [3] https://www.redhat.com/it/about/events/red-hat-open-source-day-2016 >> > ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] Ovirt 4.0.5 reporting dashboard not working.
Hi Andrea, Please try to restart the dwh service. It is the service that collects the samples data from the engine database to a data warehouse, ovirt_engine_history. run: service ovirt-engine-dwhd restart and send me the log again. If data is still not collected to ovirt_engine_history db I'll need you to open a bug so we can follow on this there. Best regards, Shirly Radco BI Software Engineer Red Hat Israel Ltd. 34 Jerusalem Road Building A, 4th floor Ra'anana, Israel 4350109 On Wed, Dec 7, 2016 at 5:43 PM, Andrea Ghelardi wrote: > Hello group, > > I noticed that my dashboard does not show little colored “cubes” which > show storage CPU and RAM usage history status. > > Attached an image and logs from /var/log/ovirt-engine-dwh/ > ovirt-engine-dwhd.log > > Here’s an extract: > > > > Exception in component tJDBCInput_5 > > org.postgresql.util.PSQLException: ERROR: smallint out of range > > at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse( > QueryExecutorImpl.java:2157) > > at org.postgresql.core.v3.QueryExecutorImpl.processResults( > QueryExecutorImpl.java:1886) > > at org.postgresql.core.v3.QueryExecutorImpl.execute( > QueryExecutorImpl.java:255) > > 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.statisticssync_4_0.StatisticsSync.tJDBCInput_ > 5Process(StatisticsSync.java:4056) > > at ovirt_engine_dwh.statisticssync_4_0.StatisticsSync$3.run( > StatisticsSync.java:15979) > > Exception in component tJDBCInput_8 > > org.postgresql.util.PSQLException: ERROR: current transaction is aborted, > commands ignored until end of transaction block > > at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse( > QueryExecutorImpl.java:2157) > > at org.postgresql.core.v3.QueryExecutorImpl.processResults( > QueryExecutorImpl.java:1886) > > at org.postgresql.core.v3.QueryExecutorImpl.execute( > QueryExecutorImpl.java:255) > > 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.statisticssync_4_0.StatisticsSync.tJDBCInput_ > 8Process(StatisticsSync.java:5991) > > at ovirt_engine_dwh.statisticssync_4_0.StatisticsSync$4.run( > StatisticsSync.java:16025) > > 2016-11-27 > 14:27:40|tm1tT6|GCXnuH|0jajaj|OVIRT_ENGINE_DWH|StatisticsSync|Default|6|Java > Exception|tJDBCInput_5|org.postgresql.util.PSQLException:ERROR: smallint > out of range|1 > > > > This is a quite fresh new installation, and restarting engine VM > (hosted-engine –vm-stop + hosted-engine –vm-start) does not fix the problem. > > Ovirt is behaving normally. > > > > Any clue? > > Cheers > > Andrea > > > > ___ > Users mailing list > Users@ovirt.org > http://lists.ovirt.org/mailman/listinfo/users > > ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] Request for feedback on your db vacuum status
Hi Baptiste, Thank you very much for your reply. I understand that you updated your DWH to collect every 60 seconds instead of 20. I'm the oVirt DWH maintainer and I would really appreciate if you can share what led you to this decision? And some details on your setup. Do you have it installed on the same machine as the engine or on a remote one? Is your database remote or local? What is the scale of you environment ? Number of hosts/vms... This will may help us with the bug Roy mentioned. Best regards, Shirly Radco BI Software Engineer Red Hat Israel Ltd. 34 Jerusalem Road Building A, 4th floor Ra'anana, Israel 4350109 On Thu, Dec 8, 2016 at 5:01 PM, Baptiste Agasse < baptiste.aga...@lyra-network.com> wrote: > > > - Le 8 Déc 16, à 15:18, Roy Golan a écrit : > > Hi all, > > Following the thread about vacuum tool [1] I would like to gather some > feedback about your deployment's db vacuum status The info is completely > anonymous and function running it is a read only reporting one and should > have little or no effect on the db. > > The result can be pretty verbose but again will not disclose sensitive > info. Anyway review it before pasting it. It should look something like > that(a snippet of one table): > > INFO: vacuuming "pg_catalog.pg_ts_template" > INFO: index "pg_ts_template_tmplname_index" now contains 5 row versions > in 2 pages > DETAIL: 0 index row versions were removed. > 0 index pages have been deleted, 0 are currently reusable. > CPU 0.00s/0.00u sec elapsed 0.00 sec. > > > 1. sudo su - postgres -c "psql engine -c 'vacuum verbose'" &> > /tmp/vacuum.log > > 2. review the /tmp/vacuum.log > > 3. paste it to http://paste.fedoraproject.org/ and reply with the link > here > > > [1] http://lists.ovirt.org/pipermail/devel/2016-December/014484.html > > > Thanks, > Roy > > ___ > Users mailing list > Users@ovirt.org > http://lists.ovirt.org/mailman/listinfo/users > > > http://paste.fedoraproject.org/501769/48120789/ > > But, we run a full vacuum about one month ago that have free about 8GB of > space and we set DWH_SAMPLING=60 to decrease data size of DWH (install is ~ > 1y and half old, updated from 3.5 to 3.6 to 4.0). > > Have a nice day. > > Regards. > > -- > Baptiste > > > ___ > Users mailing list > Users@ovirt.org > http://lists.ovirt.org/mailman/listinfo/users > > ___ Users mailing list Users@ovirt.org http://lists.phx.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] Ovirt 4.0.5 reporting dashboard not working.
Best regards, Shirly Radco BI Software Engineer Red Hat Israel Ltd. 34 Jerusalem Road Building A, 4th floor Ra'anana, Israel 4350109 On Mon, Dec 19, 2016 at 10:33 AM, Andrea Ghelardi wrote: > Hello Shirly, > > I restarted dwh service as per your suggestion with no success. > > > > Here a sample of DWH log: > > 2016-12-14 12:31:55|kdcGa9|GCXnuH|PIv06L|OVIRT_ENGINE_DWH| > SampleTimeKeepingJob|Default|5|tWarn|tWarn_1|Can not sample data, oVirt > Engine is not updating the statistics. Please check your oVirt Engine > status.|9704 > > 2016-12-14 12:32:20|ncjn2O|GCXnuH|PIv06L|OVIRT_ENGINE_DWH| > SampleTimeKeepingJob|Default|5|tWarn|tWarn_1|Can not sample data, oVirt > Engine is not updating the statistics. Please check your oVirt Engine > status.|9704 > > 2016-12-14 15:52:37|Xx2zzb|GCXnuH|PIv06L|OVIRT_ENGINE_DWH| > SampleTimeKeepingJob|Default|5|tWarn|tWarn_1|Can not sample data, oVirt > Engine is not updating the statistics. Please check your oVirt Engine > status.|9704 > > 2016-12-16 17:39:13|ETL Service Stopped > > 2016-12-16 17:39:14|ETL Service Started > > ovirtEngineDbDriverClass|org.postgresql.Driver > > ovirtEngineHistoryDbJdbcConnection|jdbc:postgresql:// > localhost:5432/ovirt_engine_history?sslfactory=org.postgresql.ssl. > NonValidatingFactory > > hoursToKeepDaily|0 > > hoursToKeepHourly|720 > > ovirtEngineDbPassword|** > > runDeleteTime|3 > > ovirtEngineDbJdbcConnection|jdbc:postgresql://localhost: > 5432/engine?sslfactory=org.postgresql.ssl.NonValidatingFactory > > runInterleave|20 > > limitRows|limit 1000 > > ovirtEngineHistoryDbUser|ovirt_engine_history > > ovirtEngineDbUser|engine > > deleteIncrement|10 > > timeBetweenErrorEvents|30 > > hoursToKeepSamples|24 > > deleteMultiplier|1000 > > lastErrorSent|2011-07-03 12:46:47.00 > > etlVersion|4.0.5 > > dwhAggregationDebug|false > > dwhUuid|a18846e6-d188-4170-8549-aeb1c54fa390 > > ovirtEngineHistoryDbDriverClass|org.postgresql.Driver > > ovirtEngineHistoryDbPassword|** > > > > > > And here a sample of Engine.log > > > > 2016-12-19 04:32:05,939 WARN > [org.ovirt.engine.core.vdsbroker.irsbroker.IrsProxyData] > (DefaultQuartzScheduler5) [53791585] Domain > '05c01989-18a1-4a45-9ed6-76c6badc728a:intel2-dstore04' > report isn't an actual report > > 2016-12-19 04:32:05,939 WARN > [org.ovirt.engine.core.vdsbroker.irsbroker.IrsProxyData] > (DefaultQuartzScheduler5) [53791585] Domain > 'f0d8ea03-17ab-4feb-bbf8-408e0550fc29:boole2-dstore1' > report isn't an actual report > > Tal , Allon, Can you please update on what does this engine log error mean? > > > > > So apparently DWH is working, but that “report isn't an actual report” is > quite obscure to me. > Did you start seeing data in the dashboard? I need to clarify that (almost) all these storages are iscsi SAN hosted and > have been detached from Ovirt3 installation and IMPORTED into Ovirt4. > > > > Could you suggest for next step? > > Thanks > > Andrea > > > > *From:* Shirly Radco [mailto:sra...@redhat.com] > *Sent:* Thursday, December 8, 2016 10:22 AM > *To:* Andrea Ghelardi > *Cc:* users > *Subject:* Re: [ovirt-users] Ovirt 4.0.5 reporting dashboard not working. > > > > Hi Andrea, > > > > Please try to restart the dwh service. > > It is the service that collects the samples data from the engine database > to a data warehouse, ovirt_engine_history. > > run: > > > > service ovirt-engine-dwhd restart > > > > and send me the log again. > > > > If data is still not collected to ovirt_engine_history db I'll need you to > open a bug so we can follow on this there. > > > Best regards, > > Shirly Radco > > BI Software Engineer > > Red Hat Israel Ltd. > > 34 Jerusalem Road > > Building A, 4th floor > > Ra'anana, Israel 4350109 > > > > On Wed, Dec 7, 2016 at 5:43 PM, Andrea Ghelardi > wrote: > > Hello group, > > I noticed that my dashboard does not show little colored “cubes” which > show storage CPU and RAM usage history status. > > Attached an image and logs from /var/log/ovirt-engine-dwh/ > ovirt-engine-dwhd.log > > Here’s an extract: > > > > Exception in component tJDBCInput_5 > > org.postgresql.util.PSQLException: ERROR: smallint out of range > > at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse( > QueryExecutorImpl.java:2157) > > at org.postgresql.core.v3.QueryExecutorImpl.processResults( > QueryExecutorImpl.java:1886)
Re: [ovirt-users] Large DWH Database, how to empty
No. But the delete process might have kicked in. How long does you environment exist? Best regards, Shirly Radco BI Software Engineer Red Hat Israel Ltd. 34 Jerusalem Road Building A, 4th floor Ra'anana, Israel 4350109 On Sun, Jan 8, 2017 at 2:42 PM, Matt . wrote: > Hi, > > OK thanks! I saw that after upgrading to 4.0.5 from 4.0.4 the DB > already dropped with around 500MB directly and is now at 2GB smaller. > > Does this sounds familiar to you with other settings in 4.0.5 ? > > > Thanks, > > Matt > > > > 2017-01-08 10:45 GMT+01:00 Shirly Radco : > > No. That will corrupt your database. > > > > Are you using the full dwh or the smaller version for the dashboards? > > > > Please set the delete thresholds to save less data and the data older > then > > the time you set will be deleted. > > Add a file to /ovirt-engine-dwhd.conf.d/ > > update_time_to_keep_records.conf > > > > Add these lines with the new configurations. The numbers represent the > hours > > to keep the data. > > > > DWH_TABLES_KEEP_SAMPLES=24 > > DWH_TABLES_KEEP_HOURLY=1440 > > DWH_TABLES_KEEP_DAILY=43800 > > > > > > These are the configurations for a full dwh. > > > > The smaller version configurations are: > > DWH_TABLES_KEEP_SAMPLES=24 > > DWH_TABLES_KEEP_HOURLY=720 > > DWH_TABLES_KEEP_DAILY=0 > > > > The delete process by default at 3am every day (DWH_DELETE_JOB_HOUR=3) > > > > Best regards, > > > > Shirly Radco > > > > BI Software Engineer > > Red Hat Israel Ltd. > > 34 Jerusalem Road > > Building A, 4th floor > > Ra'anana, Israel 4350109 > > > > > > On Fri, Jan 6, 2017 at 6:35 PM, Matt . wrote: > >> > >> Hi, > >> > >> I seem to have some large database for the DWH logging and I wonder > >> how I can empty it safely. > >> > >> Can I just simply empty the database ? > >> > >> Have a good weekend! > >> > >> Cheers, > >> > >> Matt > >> ___ > >> Users mailing list > >> Users@ovirt.org > >> http://lists.ovirt.org/mailman/listinfo/users > > > > > ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] DWH URL in 4.0.6 ??
DWH is still available and be queried by external sql based reporting
solutions.
We are currently working on a new metrics store solution.
Best regards,
Shirly Radco
BI Software Engineer
Red Hat Israel Ltd.
34 Jerusalem Road
Building A, 4th floor
Ra'anana, Israel 4350109
On Fri, Jan 13, 2017 at 6:36 PM, Alexander Wels wrote:
> On Friday, January 13, 2017 9:30:09 AM EST Devin Acosta wrote:
> > I upgraded to the latest 4.0.6 and show that the Data Ware House process
> is
> > running, did they change how you access the GUI for it?
> >
> > Going to: https://{fqdn}/ovirt-engine-reports/
> > no longer functions on any of my deployments?
>
> The DWH reports are no longer available in oVirt since 4.0. The process is
> running because the dashboard uses the data to generate its data. But the
> reports are gone.
>
> ___
> Users mailing list
> Users@ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
>
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] oVirt Reports
oVirt reports is not available since v4.0. The oVirt DWH is available, can be queried by external reporting solutions that support sql queries. We are currently working on a new metrics store solution for oVirt. Best regards, Shirly Radco BI Software Engineer Red Hat Israel Ltd. 34 Jerusalem Road Building A, 4th floor Ra'anana, Israel 4350109 On Thu, Jan 12, 2017 at 12:44 PM, Marcin Michta wrote: > Hi, > > Someone can tell me what kind of informations I can get from ovirt > reports? oVirt web page is poor about it. > Screenshots will be helpful. > > Thank you, > Marcin > > -- > > > --- > The information in this email is confidential and may be legally > privileged, it may contain information that is confidential in CodiLime Sp. > z o. o. It is intended solely for the addressee. Any access to this email > by third parties is unauthorized. If you are not the intended recipient of > this message, any disclosure, copying, distribution or any action > undertaken or neglected in reliance thereon is prohibited and may result in > your liability for damages. > ___ > Users mailing list > Users@ovirt.org > http://lists.ovirt.org/mailman/listinfo/users > ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] Ovirt 4.0.5 reporting dashboard not working.
Hi Andrea, I believe that dwh not working is unrelated to what Liron mentioned. Please open a bug on ovirt-dwh and attach the dwh log and ovirt_engine_dwh db dump, dashboard screenshot. I will check what is the reason that data is not collected. Best regards, Shirly Radco BI Software Engineer Red Hat Israel Ltd. 34 Jerusalem Road Building A, 4th floor Ra'anana, Israel 4350109 On Tue, Jan 17, 2017 at 6:21 PM, Andrea Ghelardi wrote: > Hello Liron, > Thank you for your reply. > > So basically our DWH is not creating reports because vdsm is too slow in > collecting results? > I understand the message logged in engine is informational instead of > warning, but still DWH is not working. > Do you have any additional hint about what to check? > > Cheers > AG > > -Original Message- > From: Liron Aravot [mailto:lara...@redhat.com] > Sent: Tuesday, January 17, 2017 2:30 PM > To: Tal Nisan > Cc: Shirly Radco ; users ; Andrea > Ghelardi > Subject: Re: [ovirt-users] Ovirt 4.0.5 reporting dashboard not working. > > When a host is "connected" to a storage pool it monitors the active pool > domains. When the domain monitoring results are reported back from the > host, the first monitor run may haven't finished yet. In that case the > returned status from vdsm is a dummy status and not an actual result - when > getting such a status the engine logs it. > We should change that log print to INFO rather then WARN. > > On Tue, Dec 20, 2016 at 12:17 PM, Tal Nisan wrote: > > Liron, can you please check why does this "report isn't an actual > > report" is appearing in the log? > > > > On Mon, Dec 19, 2016 at 10:33 AM, Andrea Ghelardi > > wrote: > >> > >> Hello Shirly, > >> > >> I restarted dwh service as per your suggestion with no success. > >> > >> > >> > >> Here a sample of DWH log: > >> > >> 2016-12-14 > >> 12:31:55|kdcGa9|GCXnuH|PIv06L|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|D > >> efault|5|tWarn|tWarn_1|Can not sample data, oVirt Engine is not > >> updating the statistics. Please check your oVirt Engine status.|9704 > >> > >> 2016-12-14 > >> 12:32:20|ncjn2O|GCXnuH|PIv06L|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|D > >> efault|5|tWarn|tWarn_1|Can not sample data, oVirt Engine is not > >> updating the statistics. Please check your oVirt Engine status.|9704 > >> > >> 2016-12-14 > >> 15:52:37|Xx2zzb|GCXnuH|PIv06L|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|D > >> efault|5|tWarn|tWarn_1|Can not sample data, oVirt Engine is not > >> updating the statistics. Please check your oVirt Engine status.|9704 > >> > >> 2016-12-16 17:39:13|ETL Service Stopped > >> > >> 2016-12-16 17:39:14|ETL Service Started > >> > >> ovirtEngineDbDriverClass|org.postgresql.Driver > >> > >> > >> ovirtEngineHistoryDbJdbcConnection|jdbc:postgresql://localhost:5432/o > >> ovirtEngineHistoryDbJdbcConnection|virt_engine_history?sslfactory=org > >> ovirtEngineHistoryDbJdbcConnection|.postgresql.ssl.NonValidatingFacto > >> ovirtEngineHistoryDbJdbcConnection|ry > >> > >> hoursToKeepDaily|0 > >> > >> hoursToKeepHourly|720 > >> > >> ovirtEngineDbPassword|** > >> > >> runDeleteTime|3 > >> > >> > >> ovirtEngineDbJdbcConnection|jdbc:postgresql://localhost:5432/engine?s > >> ovirtEngineDbJdbcConnection|slfactory=org.postgresql.ssl.NonValidatin > >> ovirtEngineDbJdbcConnection|gFactory > >> > >> runInterleave|20 > >> > >> limitRows|limit 1000 > >> > >> ovirtEngineHistoryDbUser|ovirt_engine_history > >> > >> ovirtEngineDbUser|engine > >> > >> deleteIncrement|10 > >> > >> timeBetweenErrorEvents|30 > >> > >> hoursToKeepSamples|24 > >> > >> deleteMultiplier|1000 > >> > >> lastErrorSent|2011-07-03 12:46:47.00 > >> > >> etlVersion|4.0.5 > >> > >> dwhAggregationDebug|false > >> > >> dwhUuid|a18846e6-d188-4170-8549-aeb1c54fa390 > >> > >> ovirtEngineHistoryDbDriverClass|org.postgresql.Driver > >> > >> ovirtEngineHistoryDbPassword|** > >> > >> > >> > >> > >> > >> And here a sample of Engine.log > >> > >> > >> > >> 2016-12-19 04:32:05,939 WARN > >> [org.ovirt.engine.core.vdsbroker.irsbroker.IrsProxyData] > &g
Re: [ovirt-users] Large DWH Database, how to empty
Hi, We don't update the ovirt-engine-dwhd.conf directly. You need to add the new file to /ovirt-engine-dwhd.conf.d/ with the lines DWH_TABLES_KEEP_SAMPLES= DWH_TABLES_KEEP_HOURLY= DWH_TABLES_KEEP_DAILY=0 and set the values for how much time you want the data to be kept. Keep in mind that the dashboards use the information from the samples and hourly tables for the last 24 hours. This file will overwrite the default configurations after you restart ovirt-engine-dwhd. Best regards, Shirly Radco BI Software Engineer Red Hat Israel Ltd. 34 Jerusalem Road Building A, 4th floor Ra'anana, Israel 4350109 On Tue, Jan 24, 2017 at 11:43 AM, Matt . wrote: > Shirly, > > I'm checking this out and aren't you sure the file is > update_time_to_keep_records.conf and not ovirt-engine-dwhd.conf ? > > 2017-01-09 14:01 GMT+01:00 Matt . : > > I think it did. Cluster exists 4 years now, hosted engine 7 months. > > > > 2017-01-08 13:50 GMT+01:00 Shirly Radco : > >> No. But the delete process might have kicked in. > >> How long does you environment exist? > >> > >> Best regards, > >> > >> Shirly Radco > >> > >> BI Software Engineer > >> Red Hat Israel Ltd. > >> 34 Jerusalem Road > >> Building A, 4th floor > >> Ra'anana, Israel 4350109 > >> > >> > >> On Sun, Jan 8, 2017 at 2:42 PM, Matt . wrote: > >>> > >>> Hi, > >>> > >>> OK thanks! I saw that after upgrading to 4.0.5 from 4.0.4 the DB > >>> already dropped with around 500MB directly and is now at 2GB smaller. > >>> > >>> Does this sounds familiar to you with other settings in 4.0.5 ? > >>> > >>> > >>> Thanks, > >>> > >>> Matt > >>> > >>> > >>> > >>> 2017-01-08 10:45 GMT+01:00 Shirly Radco : > >>> > No. That will corrupt your database. > >>> > > >>> > Are you using the full dwh or the smaller version for the dashboards? > >>> > > >>> > Please set the delete thresholds to save less data and the data older > >>> > then > >>> > the time you set will be deleted. > >>> > Add a file to /ovirt-engine-dwhd.conf.d/ > >>> > update_time_to_keep_records.conf > >>> > > >>> > Add these lines with the new configurations. The numbers represent > the > >>> > hours > >>> > to keep the data. > >>> > > >>> > DWH_TABLES_KEEP_SAMPLES=24 > >>> > DWH_TABLES_KEEP_HOURLY=1440 > >>> > DWH_TABLES_KEEP_DAILY=43800 > >>> > > >>> > > >>> > These are the configurations for a full dwh. > >>> > > >>> > The smaller version configurations are: > >>> > DWH_TABLES_KEEP_SAMPLES=24 > >>> > DWH_TABLES_KEEP_HOURLY=720 > >>> > DWH_TABLES_KEEP_DAILY=0 > >>> > > >>> > The delete process by default at 3am every day > (DWH_DELETE_JOB_HOUR=3) > >>> > > >>> > Best regards, > >>> > > >>> > Shirly Radco > >>> > > >>> > BI Software Engineer > >>> > Red Hat Israel Ltd. > >>> > 34 Jerusalem Road > >>> > Building A, 4th floor > >>> > Ra'anana, Israel 4350109 > >>> > > >>> > > >>> > On Fri, Jan 6, 2017 at 6:35 PM, Matt . > wrote: > >>> >> > >>> >> Hi, > >>> >> > >>> >> I seem to have some large database for the DWH logging and I wonder > >>> >> how I can empty it safely. > >>> >> > >>> >> Can I just simply empty the database ? > >>> >> > >>> >> Have a good weekend! > >>> >> > >>> >> Cheers, > >>> >> > >>> >> Matt > >>> >> ___ > >>> >> Users mailing list > >>> >> Users@ovirt.org > >>> >> http://lists.ovirt.org/mailman/listinfo/users > >>> > > >>> > > >> > >> > ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] Large DWH Database, how to empty
Please see at the to of this section: "The following is a list of options for configuring application settings for the Data Warehouse service. These options are available in the /usr/share/ovirt-engine-dwh/services/ovirt-engine-dwhd/ovirt-engine-dwhd.conf file. *Configure any changes to the default values in an override file under /etc/ovirt-engine-dwh/ovirt-engine-dwhd.conf.d/. Restart the Data Warehouse service after saving the changes."* So you need to add a file under */etc/ovirt-engine-dwh/ovirt-engine-dwhd.conf.d/* The file name is not important. It should end with ".conf" Best regards, Shirly Radco BI Software Engineer Red Hat Israel Ltd. 34 Jerusalem Road Building A, 4th floor Ra'anana, Israel 4350109 On Wed, Jan 25, 2017 at 1:06 PM, Matt . wrote: > Hi Shirly, > > The reason why I ask is because the explanation here: > > https://access.redhat.com/documentation/en/red-hat- > virtualization/4.0/single/data-warehouse-guide/# > Application_Settings_for_the_Data_Warehouse_service_in_ > ovirt-engine-dwhd.conf > > > 2017-01-24 10:49 GMT+01:00 Shirly Radco : > > Hi, > > > > We don't update the ovirt-engine-dwhd.conf directly. > > > > You need to add the new file to /ovirt-engine-dwhd.conf.d/ with the > lines > > DWH_TABLES_KEEP_SAMPLES= > > DWH_TABLES_KEEP_HOURLY= > > DWH_TABLES_KEEP_DAILY=0 > > > > and set the values for how much time you want the data to be kept. > > Keep in mind that the dashboards use the information from the samples and > > hourly tables for the last 24 hours. > > > > This file will overwrite the default configurations after you restart > > ovirt-engine-dwhd. > > > > > > > > Best regards, > > > > Shirly Radco > > > > BI Software Engineer > > Red Hat Israel Ltd. > > 34 Jerusalem Road > > Building A, 4th floor > > Ra'anana, Israel 4350109 > > > > > > On Tue, Jan 24, 2017 at 11:43 AM, Matt . wrote: > >> > >> Shirly, > >> > >> I'm checking this out and aren't you sure the file is > >> update_time_to_keep_records.conf and not ovirt-engine-dwhd.conf ? > >> > >> 2017-01-09 14:01 GMT+01:00 Matt . : > >> > I think it did. Cluster exists 4 years now, hosted engine 7 months. > >> > > >> > 2017-01-08 13:50 GMT+01:00 Shirly Radco : > >> >> No. But the delete process might have kicked in. > >> >> How long does you environment exist? > >> >> > >> >> Best regards, > >> >> > >> >> Shirly Radco > >> >> > >> >> BI Software Engineer > >> >> Red Hat Israel Ltd. > >> >> 34 Jerusalem Road > >> >> Building A, 4th floor > >> >> Ra'anana, Israel 4350109 > >> >> > >> >> > >> >> On Sun, Jan 8, 2017 at 2:42 PM, Matt . > wrote: > >> >>> > >> >>> Hi, > >> >>> > >> >>> OK thanks! I saw that after upgrading to 4.0.5 from 4.0.4 the DB > >> >>> already dropped with around 500MB directly and is now at 2GB > smaller. > >> >>> > >> >>> Does this sounds familiar to you with other settings in 4.0.5 ? > >> >>> > >> >>> > >> >>> Thanks, > >> >>> > >> >>> Matt > >> >>> > >> >>> > >> >>> > >> >>> 2017-01-08 10:45 GMT+01:00 Shirly Radco : > >> >>> > No. That will corrupt your database. > >> >>> > > >> >>> > Are you using the full dwh or the smaller version for the > >> >>> > dashboards? > >> >>> > > >> >>> > Please set the delete thresholds to save less data and the data > >> >>> > older > >> >>> > then > >> >>> > the time you set will be deleted. > >> >>> > Add a file to /ovirt-engine-dwhd.conf.d/ > >> >>> > update_time_to_keep_records.conf > >> >>> > > >> >>> > Add these lines with the new configurations. The numbers represent > >> >>> > the > >> >>> > hours > >> >>> > to keep the data. > >> >>> > > >> >>> > DWH_TABLES_KEEP_SAMPLES=24 > >> >>> > DWH_TABLES_KEEP_HOURLY=1440 > >> >>> > DWH_TABLES_KEEP_DAILY=43800 > >> >>
Re: [ovirt-users] ETL service sampling has encountered an error
Hi, This in a known issue. We have a bug targeted to 4.2 for this. https://bugzilla.redhat.com/show_bug.cgi?id=137 This error means that the dwh tried to reach the engine database and for some reason the heartbeat of the engine did not update since the last dwh sync. Best regards, Shirly Radco BI Software Engineer Red Hat Israel Ltd. 34 Jerusalem Road Building A, 4th floor Ra'anana, Israel 4350109 On Tue, Feb 21, 2017 at 11:17 PM, Christophe TREFOIS < christophe.tref...@uni.lu> wrote: > Dear all, > > Since upgrading to 4.0.6, we see this error in the engine events tab and > were wondering how to fix it. > > ovirt-engine-dwh.log > > — > 2017-02-20 22:01:00|zPHx4s|6nXgTp|ygadfe|OVIRT_ENGINE_DWH| > SampleTimeKeepingJob|Default|5|tWarn|tWarn_1|Can not sample data, oVirt > Engine is not updating the statistics. Please check your oVirt Engine > status.|9704 > — > > And in engine log the only error I see (repeated) since yesterday is > > 65366:2017-02-21 22:13:34,357 ERROR [org.ovirt.engine.core. > vdsbroker.vdsbroker.VdsBrokerObjectsBuilder] (DefaultQuartzScheduler10) > [2dc75859] null architecture type, replacing with x86_64, %s > > Any advice on where to start is welcome. > > Kind regards, > Christophe > ___ > Users mailing list > Users@ovirt.org > http://lists.ovirt.org/mailman/listinfo/users > ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] oVirt 4.1 Dashboard
Hi, Please attach ovirt-engine-dwh logs and a screenshot. Best regards, Shirly Radco BI Software Engineer Red Hat Israel Ltd. 34 Jerusalem Road Building A, 4th floor Ra'anana, Israel 4350109 On Tue, Mar 7, 2017 at 11:41 AM, Arsène Gschwind wrote: > Please find engine.log attached > > On 03/07/2017 10:06 AM, Oved Ourfali wrote: > > > > On Tue, Mar 7, 2017 at 10:57 AM, Arsène Gschwind < > arsene.gschw...@unibas.ch> wrote: > >> Hi, >> >> I've update our oVirt installation 3.6 --> 4.0 --> 4.1, everything went >> smooth except update some of the hosts which i could update after several >> hour playing around. >> >> We greatly appreciate the dashboard in 4.1 but we see the information >> missing: >> >>1. On the cluster block in the upper part we see the amount of >>clusters but no Status (N/A) >> >> > The reason there is no status there is that in oVirt there is no cluster > status (look at the cluster main-tab, for example). > We only have statuses for objects like DCs, Hosts, VMs, SDs (well, maybe > we have for some more, but not clusters...). > We decided to include clusters in the inventory part anyway, for user > visibility, and provide access to the clusters main tab by pressing the > link. > > > >> >>1. On the lower part at "Cluster Utilization" and "Storage >>Utilization" we don't have any information at all. >> >> Where does this information come from? DWH service is up and running >> > The inventory part is taken from the engine. > All the rest is taken from DWH. > You can start with sharing the engine logs here. > Shirly - any other logs or information you think is required? > > > >> Where do I have have to investigate further to find out what is >> missing/not working? >> >> Let me know if you need further information. >> >> Rgds, >> Arsène >> >> ___ >> Users mailing list >> Users@ovirt.org >> http://lists.ovirt.org/mailman/listinfo/users >> >> > > ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] DWH reports in 4.X ?
Hi Eduardo, DWH still exists, and if you have a reports tool that supports sql you can use it with it. Reports was deprecated in 3.6. We are now working on adding a new metrics store solution for oVirt. For more details you can have a look at: http://www.ovirt.org/develop/release-management/features/ engine/metrics-store/ Currently in 4.1 the hosts and engine include Collectd and Fluentd. In 4.2 we expect to have the metrics store ready. You can try setting up the metrics store side from upstream for now. https://github.com/sradco/ovirt-metrics-conf <https://github.com/sradco/ovirt-metrics-conf> <https://github.com/sradco/ovirt-metrics-conf> The Fluent and Collectd configuration are handled at: https://github.com/oVirt/ovirt-engine-metrics Best regards, Shirly Radco BI Software Engineer Red Hat Israel Ltd. 34 Jerusalem Road Building A, 4th floor Ra'anana, Israel 4350109 On Tue, Mar 7, 2017 at 12:29 PM, Eduardo Mayoral wrote: > > Hi, > > I see the DWH reports disappeared in 3.5 or maybe 3.6, there seems > to be no substitute por 4.X > > Is there some alternative to have some pre-made reports from the DWH > on 4.X ? Maybe not something on the oVirt project itself but from > someone on the community? > > Thanks in advance! > > -- > Eduardo Mayoral Jimeno (emayo...@arsys.es) > Administrador de sistemas. Departamento de Plataformas. Arsys internet. > +34 941 620 145 ext. 5153 > > ___ > Users mailing list > Users@ovirt.org > http://lists.ovirt.org/mailman/listinfo/users > ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] DWH reports in 4.X ?
Yes. We are working to integrate our engine and vdsm logs as well. Hope you will find it helpful and would appreciate your input once we have the metrics store in production. -- Shirly Radco BI Software Engineer Red Hat Israel Ltd. On Wed, Mar 8, 2017 at 4:44 PM, Eduardo Mayoral wrote: > Thanks for your answer! > > Looks certainly interesting. I am using collectd with virt plugin + carbon > + graphite + grafana for performance graphs of the hosts and the VMs right > now ( oVirt 4.1 with nodes in CentOS 7.3) > > I like the idea of using fluentd for this instead of a relational > database. Will it handle metrics and logs as well? I am asking because of > the kibana component. > > Best regards, > > Eduardo Mayoral Jimeno (emayo...@arsys.es) > Administrador de sistemas. Departamento de Plataformas. Arsys internet.+34 > 941 620 145 ext. 5153 <+34%20941%2062%2001%2045> > > On 08/03/17 14:51, Shirly Radco wrote: > > Hi Eduardo, > > DWH still exists, and if you have a reports tool that supports sql you can > use it with it. > Reports was deprecated in 3.6. > > We are now working on adding a new metrics store solution for oVirt. > > For more details you can have a look at: > http://www.ovirt.org/develop/release-management/features/eng > ine/metrics-store/ > > Currently in 4.1 the hosts and engine include Collectd and Fluentd. > In 4.2 we expect to have the metrics store ready. > > You can try setting up the metrics store side from upstream for now. > https://github.com/sradco/ovirt-metrics-conf > > <https://github.com/sradco/ovirt-metrics-conf> > > <https://github.com/sradco/ovirt-metrics-conf> > The Fluent and Collectd configuration are handled at: > https://github.com/oVirt/ovirt-engine-metrics > > > Best regards, > > Shirly Radco > > BI Software Engineer > Red Hat Israel Ltd. > 34 Jerusalem Road > Building A, 4th floor > Ra'anana, Israel 4350109 > > > On Tue, Mar 7, 2017 at 12:29 PM, Eduardo Mayoral > wrote: > >> >> Hi, >> >> I see the DWH reports disappeared in 3.5 or maybe 3.6, there seems >> to be no substitute por 4.X >> >> Is there some alternative to have some pre-made reports from the DWH >> on 4.X ? Maybe not something on the oVirt project itself but from >> someone on the community? >> >> Thanks in advance! >> >> -- >> Eduardo Mayoral Jimeno (emayo...@arsys.es) >> Administrador de sistemas. Departamento de Plataformas. Arsys internet. >> +34 941 620 145 ext. 5153 >> >> ___ >> Users mailing list >> Users@ovirt.org >> http://lists.ovirt.org/mailman/listinfo/users >> > > > ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] oVirt 4.1 Dashboard
Hi, Please open a bug so we can better track you issue. As far as I can see from the screenshot the dwh does collect the samples, but do not aggregate it to hourly tables. 1. I see that you installed the full dwh. Did it work correctly in the past? Did you use the reports and was able to use them? 2. Please attach the ovirt_engine_history db dump and the dwh log and screenshot to the bug and state the versions of the engine and dwh. Best regards, -- Shirly Radco BI Software Engineer Red Hat Israel Ltd. On Mon, Mar 13, 2017 at 2:12 PM, Arsène Gschwind wrote: > Hi, > > I'm wondering if you could identify something. I've investigate on my side > but couldn't find any problem but for some reason it seams DWH is not > collecting data. > > Thanks a lot for any hint/help > > Rgds, > Arsène > > On 03/07/2017 11:04 AM, Arsène Gschwind wrote: > > Please find files attached > > On 03/07/2017 10:48 AM, Shirly Radco wrote: > > Hi, > > Please attach ovirt-engine-dwh logs and a screenshot. > > Best regards, > > Shirly Radco > > BI Software Engineer > Red Hat Israel Ltd. > 34 Jerusalem Road > Building A, 4th floor > Ra'anana, Israel 4350109 > > > On Tue, Mar 7, 2017 at 11:41 AM, Arsène Gschwind < > arsene.gschw...@unibas.ch> wrote: > >> Please find engine.log attached >> >> On 03/07/2017 10:06 AM, Oved Ourfali wrote: >> >> >> >> On Tue, Mar 7, 2017 at 10:57 AM, Arsène Gschwind < >> arsene.gschw...@unibas.ch> wrote: >> >>> Hi, >>> >>> I've update our oVirt installation 3.6 --> 4.0 --> 4.1, everything went >>> smooth except update some of the hosts which i could update after several >>> hour playing around. >>> >>> We greatly appreciate the dashboard in 4.1 but we see the information >>> missing: >>> >>>1. On the cluster block in the upper part we see the amount of >>>clusters but no Status (N/A) >>> >>> >> The reason there is no status there is that in oVirt there is no cluster >> status (look at the cluster main-tab, for example). >> We only have statuses for objects like DCs, Hosts, VMs, SDs (well, maybe >> we have for some more, but not clusters...). >> We decided to include clusters in the inventory part anyway, for user >> visibility, and provide access to the clusters main tab by pressing the >> link. >> >> >> >>> >>>1. On the lower part at "Cluster Utilization" and "Storage >>>Utilization" we don't have any information at all. >>> >>> Where does this information come from? DWH service is up and running >>> >> The inventory part is taken from the engine. >> All the rest is taken from DWH. >> You can start with sharing the engine logs here. >> Shirly - any other logs or information you think is required? >> >> >> >>> Where do I have have to investigate further to find out what is >>> missing/not working? >>> >>> Let me know if you need further information. >>> >>> Rgds, >>> Arsène >>> >>> ___ >>> Users mailing list >>> Users@ovirt.org >>> http://lists.ovirt.org/mailman/listinfo/users >>> >>> >> >> > > > ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] oVirt 4.1 Dashboard
Hi, I will try and find what causes this issue and fix it. We usually encounter this issue when the environment is not in utc (we recommend utc). -- Shirly Radco BI Software Engineer Red Hat Israel Ltd. On Wed, Mar 15, 2017 at 1:02 PM, Andrea Ghelardi < andrea.ghela...@iongroup.com> wrote: > Cheers J > > @Shirley: being this the second report of the same issue, probably there > is really a bug/problem somewhere? > > AG > > > > *From:* users-boun...@ovirt.org [mailto:users-boun...@ovirt.org] *On > Behalf Of *Arsène Gschwind > *Sent:* Wednesday, March 15, 2017 8:22 AM > *To:* Shirly Radco > *Cc:* users > *Subject:* Re: [ovirt-users] oVirt 4.1 Dashboard > > > > Hi, > > When creating the bug report I've found a similar bug > https://bugzilla.redhat.com/show_bug.cgi?id=1414379. I've tried the > provided solution and it did work for me, now the Dashboard shows > everything. > > Thanks a lot for your help. > > Regards, > Arsène > > > > On 03/13/2017 08:26 PM, Shirly Radco wrote: > > Hi, > > > > Please open a bug so we can better track you issue. > > As far as I can see from the screenshot the dwh does collect the samples, > but do not aggregate it to hourly tables. > > 1. I see that you installed the full dwh. Did it work correctly in the > past? Did you use the reports and was able to use them? > > 2. Please attach the ovirt_engine_history db dump and the dwh log and > screenshot to the bug and state the versions of the engine and dwh. > > > > Best regards, > > > -- > > Shirly Radco > > BI Software Engineer > > Red Hat Israel Ltd. > > > > On Mon, Mar 13, 2017 at 2:12 PM, Arsène Gschwind < > arsene.gschw...@unibas.ch> wrote: > > Hi, > > I'm wondering if you could identify something. I've investigate on my side > but couldn't find any problem but for some reason it seams DWH is not > collecting data. > > Thanks a lot for any hint/help > > Rgds, > Arsène > > > > On 03/07/2017 11:04 AM, Arsène Gschwind wrote: > > Please find files attached > > > > On 03/07/2017 10:48 AM, Shirly Radco wrote: > > Hi, > > > > Please attach ovirt-engine-dwh logs and a screenshot. > > > Best regards, > > Shirly Radco > > BI Software Engineer > > Red Hat Israel Ltd. > > 34 Jerusalem Road > > Building A, 4th floor > > Ra'anana, Israel 4350109 > > > > On Tue, Mar 7, 2017 at 11:41 AM, Arsène Gschwind < > arsene.gschw...@unibas.ch> wrote: > > Please find engine.log attached > > > > On 03/07/2017 10:06 AM, Oved Ourfali wrote: > > > > > > On Tue, Mar 7, 2017 at 10:57 AM, Arsène Gschwind < > arsene.gschw...@unibas.ch> wrote: > > Hi, > > I've update our oVirt installation 3.6 --> 4.0 --> 4.1, everything went > smooth except update some of the hosts which i could update after several > hour playing around. > > We greatly appreciate the dashboard in 4.1 but we see the information > missing: > >1. On the cluster block in the upper part we see the amount of >clusters but no Status (N/A) > > > > The reason there is no status there is that in oVirt there is no cluster > status (look at the cluster main-tab, for example). > > We only have statuses for objects like DCs, Hosts, VMs, SDs (well, maybe > we have for some more, but not clusters...). > > We decided to include clusters in the inventory part anyway, for user > visibility, and provide access to the clusters main tab by pressing the > link. > > > > > > >1. On the lower part at "Cluster Utilization" and "Storage >Utilization" we don't have any information at all. > > Where does this information come from? DWH service is up and running > > The inventory part is taken from the engine. > > All the rest is taken from DWH. > > You can start with sharing the engine logs here. > > Shirly - any other logs or information you think is required? > > > > > > Where do I have have to investigate further to find out what is > missing/not working? > > Let me know if you need further information. > > Rgds, > Arsène > > > ___ > Users mailing list > Users@ovirt.org > http://lists.ovirt.org/mailman/listinfo/users > > > > > > > > > > > > > > > ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] engine-reports portal and cpu cores
H Alexandr, The vCores are the logical cpu cores, and if you has more vCores than Host Cores it means that you have over allocation for the hosts. So, if on a specific vm one of the cores will be on 100% usage than all the vms using this core will show 100% as well. Best, --- Shirly Radco BI Software Engineer Red Hat Israel Ltd. - Original Message - > From: "Alexandr Krivulya" > To: users@ovirt.org > Sent: Tuesday, May 12, 2015 3:30:32 PM > Subject: [ovirt-users] engine-reports portal and cpu cores > > Hello, > why we have in reports host cores but not logical cpu cores? For example > in "Cluster Capacity Vs. Usage" report I always have more vCores then > Host Cores. > Thank you. > ___ > Users mailing list > Users@ovirt.org > http://lists.ovirt.org/mailman/listinfo/users > ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] report option gone missing
Hi Rik, The ovirt-engine-dwhd process is responsible for collecting the data from the engine to the oviry_engine_history database where samples data is stored and then aggregated to Hourly and daily. If this service is running and there are no errors in the log then you should be able to see up to date data in the statistics tables in the history database (They end with samples/hourly/daily). Please check these table are up to date. http://www.ovirt.org/Ovirt_DWH The ovirt-engine-reportsd is the service of the reports server. If it is running and it is configured with a FQDN you should be able to log in through http://FQDN:8090/jasperserver/ If you want to remove the reports you can just run $yum remove ovirt-engine-reports and run $ engine-setup and when you install it again $ yum install ovirt-engine-reports run again $ engine-setup to configure the reports. http://www.ovirt.org/Ovirt_Reports Please let me know how it goes. Best regards, --- Shirly Radco BI Software Engineer Red Hat Israel Ltd. - Original Message - > From: "Rik Theys" > To: users@ovirt.org > Sent: Thursday, November 19, 2015 5:35:52 PM > Subject: Re: [ovirt-users] report option gone missing > > Hi, > > I was able to login on the ovirt-engine-reports web application as > 'admin' but don't see any reports there. > > What is the procedure to fully remove the reporting from the system and > start anew? Will a remove of the package automatically clean up the > databases and such? > > Rik > > On 11/19/2015 04:25 PM, Rik Theys wrote: > > Hi, > > > > At some point I had the oVirt reporting configured on my engine and it > > worked. I had a "reports" option in the menu and could generate > > reports for various resources. > > > > At some point I've noticed that the "reports" option was no longer > > there but did not have time to investigate. I believe it happened when > > I migrated the engine host from CentOS 6 to 7 using engine-backup and > > restore. > > > > How can I debug this? > > > > In the ovirt-engine-dwh log I used to see the following error: > > > > Exception in component tJDBCRollback_4 > > org.postgresql.util.PSQLException: FATAL: terminating connection due > > to administrator command > > at > > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157) > > at > > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886) > > at > > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) > > at > > org.postgresql.jdbc2.AbstractJdbc2Connection.executeTransactionCommand(AbstractJdbc2Connection.java:793) > > at > > org.postgresql.jdbc2.AbstractJdbc2Connection.rollback(AbstractJdbc2Connection.java:846) > > at > > ovirt_engine_dwh.historyetl_3_5.HistoryETL.tJDBCRollback_4Process(HistoryETL.java:2079) > > at > > ovirt_engine_dwh.historyetl_3_5.HistoryETL.tJDBCRollback_3Process(HistoryETL.java:1997) > > at > > ovirt_engine_dwh.historyetl_3_5.HistoryETL.tJDBCRollback_2Process(HistoryETL.java:1882) > > at > > ovirt_engine_dwh.historyetl_3_5.HistoryETL.tJDBCRollback_1Process(HistoryETL.java:1767) > > at > > ovirt_engine_dwh.historyetl_3_5.HistoryETL.tPostjob_1Process(HistoryETL.java:1647) > > at > > ovirt_engine_dwh.historyetl_3_5.HistoryETL.runJobInTOS(HistoryETL.java:10785) > > at > > ovirt_engine_dwh.historyetl_3_5.HistoryETL.main(HistoryETL.java:10277) > > 2015-11-19 > > 15:42:02|rza8ri|rza8ri|rza8ri|OVIRT_ENGINE_DWH|HistoryETL|Default|6|Java > > Exception|tJDBCRollback_4|org.postgresql.util.PSQLException:FATAL: term > > > > But after rebooting the engine host it now only lists 'Service Started'. > > > > The ovirt-engine-reportsd is also running. > > > > Which of these two processes (reportsd vs dwhd) is generating the > > reports (and showing it in the engine admin interface)? > > > > In /var/log/ovirt-engine-reports, the reports.log file is empty, the > > server.log reports Deployed ovirt-engine-reports.war as the last line > > (without any obvious errors). Only jasperserver.log shows: > > > > 015-11-19 15:41:53,304 ERROR DiskStorageFactory,MSC service thread > > 1-2:948 - Could not flush disk cache. Initial cause was > > /tmp/dataSnapshots/snapshot%0043ontents.index (No such file or directory) > > java.io.FileNotFoundException: > > /tmp/dataSnapshots/snapshot%0043ontents.index (No such file or directory) > > at jav
[ovirt-users] Re: metrics
Hi, No. For oVirt the RH subscription details are not required. Please read the configuration files description carefully. If you feel they are not clear enough, please let me know by opening a bug in bugzilla. Thank you. Regards, -- Shirly Radco BI Principal Software Engineer Red Hat <https://www.redhat.com/> <https://www.redhat.com/> On Thu, Nov 14, 2019 at 6:21 PM wrote: > Hi, > > I'm trying to install metrics for Version 4.3.6.7-1.el7 > Do I need a RH subscription to downloading the RHEL guest image? > (qcow_url:) > > Thanks > > -- > -- > Jose Ferradeira > http://www.logicworks.pt > ___ > 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/45EEILEJWLZTNQKNYCVP7J34MEE7CHCQ/ > ___ 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/QFUVD2WI3IITX43IXWRRQDHAGRYDRBJZ/
[ovirt-users] Re: metrics
--
Shirly Radco
BI Principal Software Engineer
Red Hat <https://www.redhat.com/>
<https://www.redhat.com/>
On Fri, Nov 15, 2019 at 7:34 PM wrote:
> Ok, found this
> https://github.com/oVirt/ovirt-ansible-image-template/pull/47
> and change
>
> retries: "{{ (disk_resize_timeout / 3) | int }}"
> delay: 3
>
> to
>
> retries: 60
> delay: 3
>
> in
> /usr/share/ansible/roles/ovirt.image-template/tasks/qcow2_image.yml
>
> but now I'm stuck in here:
>
> TASK [/usr/share/ansible/roles/oVirt.metrics/roles/oVirt.origin-on-ovirt :
> Collect oVirt VM facts]
> *
> FAILED - RETRYING: Collect oVirt VM facts (5 retries left).
> FAILED - RETRYING: Collect oVirt VM facts (4 retries left).
> FAILED - RETRYING: Collect oVirt VM facts (3 retries left).
> FAILED - RETRYING: Collect oVirt VM facts (2 retries left).
> FAILED - RETRYING: Collect oVirt VM facts (1 retries left).
> fatal: [localhost]: FAILED! => {"attempts": 5, "censored": "the output has
> been hidden due to the fact that 'no_log: true' was specified for this
> result", "changed": false}
>
There is probably something wrong with your engine credentials.
You try setting ANSIBLE_DEBUG to true to debug this issue.
ANSIBLE_DEBUG ignores np_log so please keep in mind that your password will
be readable and you might want to delete the log once you finish.
> after the creation of metrics-store-installer VM
>
>
>
> --
> *De: *supo...@logicworks.pt
> *Para: *"Jayme"
> *Cc: *"users"
> *Enviadas: *Sexta-feira, 15 De Novembro de 2019 16:11:25
> *Assunto: *[ovirt-users] Re: metrics
>
> Well, I did a mistake when copying the metrics-store-config.yml
>
> But now I'm getting this error
> ..
> FAILED - RETRYING: Wait for resize (1 retries left)
> fatal: [localhost]: FAILED! => {"attempts": 40, "changed": false, "disk":
> {"actual_size": 942409728, "alias": "centos76", "backup": "none",
> "content_type": "data",
> "description": "", "disk_profile": {"href":
> "/ovirt-engine/api/diskprofiles/13b70c52-8265-4cd2-aac0-3497750bd03b",
> "id": "13b70c52-8265-4cd2-aac0-3497750bd03b"},
> "format": "cow", "href":
> "/ovirt-engine/api/disks/2abbe5f5-7534-4d6e-bd91-9ce1c135de13", "id":
> "2abbe5f5-7534-4d6e-bd91-9ce1c135de13", "image_id":
> "ad50f9c0-1b07-43fb-bea2-9f38d6e22acd", "name": "centos76", "permissions":
> [], "propagate_errors": false, "provisioned_size": 8589934592,
> "qcow_version": "qcow2_v2",
> "quota": {"href":
> "/ovirt-engine/api/datacenters/e2c375e0-929e-11e9-969e-0013f7d1bb52/quotas/f3f4eefc-929e-11e9-b3a6-0013f7d1bb52",
> "id":
> "f3f4eefc-929e-11e9-b3a6-0013f7d1bb52"}, "shareable": false, "sparse":
> true, "statistics": [], "status": "ok", "storage_domains":
> [{"href":
> "/ovirt-engine/api/storagedomains/156168f1-3905-4514-b7c1-817e39718ba6",
> "id": "156168f1-3905-4514-b7c1-817e39718ba6"}],
> "storage_type": "image", "total_size": 942409728, "wipe_after_delete":
> false}, "id": "2abbe5f5-7534-4d6e-bd91-9ce1c135de13"}
>
> --
> *De: *supo...@logicworks.pt
> *Para: *"Jayme"
> *Cc: *"users"
> *Enviadas: *Sexta-feira, 15 De Novembro de 2019 10:29:06
> *Assunto: *[ovirt-users] Re: metrics
>
> Hello,
>
> Still nothing happens. I'm a little lost here.
> I'm getting this message when running
> ./configure_ovirt_machines_for_metrics.sh
> --playbook=ovirt-metrics-store-installation.yml --
> ask-vault-pass
>
> changed: [localhost -> localhost] => {
> "msg": "oVirt Metrics store is not configured. This host will not be
> configured to send metrics"
> }
>
> I think this is the problem?
> Any idea?
>
> Thanks a lot
>
> José
>
> --
> *De: *"Jayme"
> *Para: *supo...@logicworks.pt
> *Cc: *"users"
> *Enviadas: *Quinta-feira, 14 De Novembro de 2019 18:06:51
> *Assunto: *Re: [ovirt-users] metrics
>
> this should do it:
> https://cloud.centos.org/centos/7/images/CentOS-7-x86_64-GenericCloud.
[ovirt-users] Re: metrics
Hi,
Did you try running the playbook with the ANSIBLE_DEBUG=1 ? It should show
you the issue in the log that
is located under /var/log/ovirt-engine/ansible/ .
Best,
Shirly
On Mon, Nov 18, 2019 at 7:56 PM wrote:
> Hello,
>
> I attached the log. Cannot figure it out where is the issue.
>
> Any idea?
>
> Thanks
>
> José
>
> ----------
> *De: *"Shirly Radco"
> *Para: *supo...@logicworks.pt
> *Cc: *"Jayme" , "users"
> *Enviadas: *Segunda-feira, 18 De Novembro de 2019 10:24:28
> *Assunto: *Re: [ovirt-users] Re: metrics
>
>
> --
>
>
> Shirly Radco
>
> BI Principal Software Engineer
>
> Red Hat <https://www.redhat.com/>
>
>
> <https://www.redhat.com/>
>
>
> On Fri, Nov 15, 2019 at 7:34 PM wrote:
>
>> Ok, found this
>> https://github.com/oVirt/ovirt-ansible-image-template/pull/47
>> and change
>>
>> retries: "{{ (disk_resize_timeout / 3) | int }}"
>> delay: 3
>>
>> to
>>
>> retries: 60
>> delay: 3
>>
>> in
>> /usr/share/ansible/roles/ovirt.image-template/tasks/qcow2_image.yml
>>
>> but now I'm stuck in here:
>>
>> TASK [/usr/share/ansible/roles/oVirt.metrics/roles/oVirt.origin-on-ovirt
>> : Collect oVirt VM facts]
>> *
>> FAILED - RETRYING: Collect oVirt VM facts (5 retries left).
>> FAILED - RETRYING: Collect oVirt VM facts (4 retries left).
>> FAILED - RETRYING: Collect oVirt VM facts (3 retries left).
>> FAILED - RETRYING: Collect oVirt VM facts (2 retries left).
>> FAILED - RETRYING: Collect oVirt VM facts (1 retries left).
>> fatal: [localhost]: FAILED! => {"attempts": 5, "censored": "the output
>> has been hidden due to the fact that 'no_log: true' was specified for this
>> result", "changed": false}
>>
>
> There is probably something wrong with your engine credentials.
> You try setting ANSIBLE_DEBUG to true to debug this issue.
> ANSIBLE_DEBUG ignores np_log so please keep in mind that your password
> will be readable and you might want to delete the log once you finish.
>
>
>>
>> after the creation of metrics-store-installer VM
>>
>>
>>
>> --
>> *De: *supo...@logicworks.pt
>> *Para: *"Jayme"
>> *Cc: *"users"
>> *Enviadas: *Sexta-feira, 15 De Novembro de 2019 16:11:25
>> *Assunto: *[ovirt-users] Re: metrics
>>
>> Well, I did a mistake when copying the metrics-store-config.yml
>>
>> But now I'm getting this error
>> ..
>> FAILED - RETRYING: Wait for resize (1 retries left)
>> fatal: [localhost]: FAILED! => {"attempts": 40, "changed": false, "disk":
>> {"actual_size": 942409728, "alias": "centos76", "backup": "none",
>> "content_type": "data",
>> "description": "", "disk_profile": {"href":
>> "/ovirt-engine/api/diskprofiles/13b70c52-8265-4cd2-aac0-3497750bd03b",
>> "id": "13b70c52-8265-4cd2-aac0-3497750bd03b"},
>> "format": "cow", "href":
>> "/ovirt-engine/api/disks/2abbe5f5-7534-4d6e-bd91-9ce1c135de13", "id":
>> "2abbe5f5-7534-4d6e-bd91-9ce1c135de13", "image_id":
>> "ad50f9c0-1b07-43fb-bea2-9f38d6e22acd", "name": "centos76",
>> "permissions": [], "propagate_errors": false, "provisioned_size":
>> 8589934592, "qcow_version": "qcow2_v2",
>> "quota": {"href":
>> "/ovirt-engine/api/datacenters/e2c375e0-929e-11e9-969e-0013f7d1bb52/quotas/f3f4eefc-929e-11e9-b3a6-0013f7d1bb52",
>> "id":
>> "f3f4eefc-929e-11e9-b3a6-0013f7d1bb52"}, "shareable": false, "sparse":
>> true, "statistics": [], "status": "ok", "storage_domains":
>> [{"href":
>> "/ovirt-engine/api/storagedomains/156168f1-3905-4514-b7c1-817e39718ba6",
>> "id": "156168f1-3905-4514-b7c1-817e39718ba6"}],
>> "storage_type": "image", "total_size": 942409728, "wipe_after_delete":
>> false}, "id": "2abbe5f5-7534-4d6e-bd91-9ce1c135de13"}
>>
>> --
>> *De: *supo...@logicworks.pt
>> *Para: *"
[ovirt-users] Re: metrics
On Wed, Nov 20, 2019 at 5:46 PM wrote:
> Hi,
>
> I overcame this problem after configuring an hostname on
> metrics-store-installer, add a static IP and add this host to /etc/hosts on
> the engine.
>
I'm happy to hear that!
Please note that adding the hot to /etc/hosts can be done by setting the
"create_host_entry" to true
in the metrics-store-config.yml
Best,
Shirly
>
> --
> *De: *supo...@logicworks.pt
> *Para: *"Shirly Radco"
> *Cc: *"users"
> *Enviadas: *Terça-feira, 19 De Novembro de 2019 17:08:10
> *Assunto: *[ovirt-users] Re: metrics
>
> Hello,
>
> Still cannot find it.
>
> # echo $ANSIBLE_DEBUG
> 1
>
> I just find this:
>
> 2019-11-19 16:25:50,264 p=root u=6462 | ok: [localhost]
> 2019-11-19 16:25:50,296 p=root u=6462 | TASK
> [/usr/share/ansible/roles/oVirt.metrics/roles/oVirt.origin-on-ovirt :
> Collect oVirt VM facts]
>
> 2019-11-19 16:30:54,647 p=root u=6462 | fatal: [localhost]: FAILED! =>
> {"attempts": 5, "censored": "the output has been hidden due to the fact
> that 'no_log: true' was specified for this result", "changed": false}
> 2019-11-19 16:30:54,679 p=root u=6462 | TASK
> [/usr/share/ansible/roles/oVirt.metrics/roles/oVirt.origin-on-ovirt :
> Logout from oVirt]
> *
> 2019-11-19 16:30:55,074 p=root u=6462 | ok: [localhost]
> 2019-11-19 16:30:55,107 p=root u=6462 | TASK
> [oVirt.metrics/roles/oVirt.metrics-store-installation : Delete
> engine_id_rsa.pub]
>
>
>
> Maybe I'm missing something?
>
> --
> *De: *"Shirly Radco"
> *Para: *supo...@logicworks.pt
> *Cc: *"Jayme" , "users"
> *Enviadas: *Terça-feira, 19 De Novembro de 2019 14:01:20
> *Assunto: *Re: [ovirt-users] Re: metrics
>
> Hi,
>
> Did you try running the playbook with the ANSIBLE_DEBUG=1 ? It should show
> you the issue in the log that
> is located under /var/log/ovirt-engine/ansible/ .
>
> Best,
>
> Shirly
>
>
>
> On Mon, Nov 18, 2019 at 7:56 PM wrote:
>
>> Hello,
>>
>> I attached the log. Cannot figure it out where is the issue.
>>
>> Any idea?
>>
>> Thanks
>>
>> José
>>
>> --
>> *De: *"Shirly Radco"
>> *Para: *supo...@logicworks.pt
>> *Cc: *"Jayme" , "users"
>> *Enviadas: *Segunda-feira, 18 De Novembro de 2019 10:24:28
>> *Assunto: *Re: [ovirt-users] Re: metrics
>>
>>
>> --
>>
>>
>> Shirly Radco
>>
>> BI Principal Software Engineer
>>
>> Red Hat <https://www.redhat.com/>
>>
>>
>> <https://www.redhat.com/>
>>
>>
>> On Fri, Nov 15, 2019 at 7:34 PM wrote:
>>
>>> Ok, found this
>>> https://github.com/oVirt/ovirt-ansible-image-template/pull/47
>>> and change
>>>
>>> retries: "{{ (disk_resize_timeout / 3) | int }}"
>>> delay: 3
>>>
>>> to
>>>
>>> retries: 60
>>> delay: 3
>>>
>>> in
>>> /usr/share/ansible/roles/ovirt.image-template/tasks/qcow2_image.yml
>>>
>>> but now I'm stuck in here:
>>>
>>> TASK [/usr/share/ansible/roles/oVirt.metrics/roles/oVirt.origin-on-ovirt
>>> : Collect oVirt VM facts]
>>> *
>>> FAILED - RETRYING: Collect oVirt VM facts (5 retries left).
>>> FAILED - RETRYING: Collect oVirt VM facts (4 retries left).
>>> FAILED - RETRYING: Collect oVirt VM facts (3 retries left).
>>> FAILED - RETRYING: Collect oVirt VM facts (2 retries left).
>>> FAILED - RETRYING: Collect oVirt VM facts (1 retries left).
>>> fatal: [localhost]: FAILED! => {"attempts": 5, "censored": "the output
>>> has been hidden due to the fact that 'no_log: true' was specified for this
>>> result", "changed": false}
>>>
>>
>> There is probably something wrong with your engine credentials.
>> You try setting ANSIBLE_DEBUG to true to debug this issue.
>> ANSIBLE_DEBUG ignores np_log so please keep in mind that your password
>> will be readable and you might want to delete the log once you finish.
>>
>>
>>>
>>> after the creation of metrics-store-in
[ovirt-users] Re: Metrics
There is a bug with ansible 2.8.
There is already a patch that needs to be tested,
https://gerrit.ovirt.org/#/c/105813
--
Shirly Radco
BI Principal Software Engineer
Red Hat <https://www.redhat.com/>
<https://www.redhat.com/>
On Fri, Dec 27, 2019 at 10:51 PM wrote:
> Hello. I'm trying to deploy the metrics store and the ansible run fails
> at "TASK
> [/usr/share/ansible/roles/oVirt.metrics/roles/oVirt.origin-on-ovirt :
> Collect oVirt VM facts]"
>
> I've tried adding the -vvv and ANSIBLE_DEBUG=1, but that isn't giving me
> any additional information on why it is failing.
>
> fatal: [localhost]: FAILED! => {
> "attempts": 5,
> "censored": "the output has been hidden due to the fact that 'no_log:
> true' was specified for this result",
> "changed": false
> }
>
> When I edit the playbook and set no_log: true, the output is shown, but
> the resulting log shows that the "ansible_facts.ovirt_vms[0].fqdn"
> dictionary key does not exist.
>
> What is the best way to work around this issue?
>
> Thanks, Greg
> ___
> 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/RL5EZUNJ5OPHCZ4CSQBF34XQGCJ6CGUR/
>
___
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/UR4W34KZFYCO3PYVDR3KEB7FQ6REJQFM/
[ovirt-users] Re: metrics-store installation
You are correct. The user is `admin` and the password is what you specified
in the secure_vars.yaml.
You can try the following:
log into the master0 vm
run:
# name: Log into logging project
oc project openshift-logging
# name: Create admin user
oc create user admin
# name: Create an Identity with identity provider allow_all
oc create identity allow_all:admin
# name: Create a user/identity mapping for the created user and identity
oc create useridentitymapping allow_all:admin admin
# name: Binds the admin role to specified users for all projects in the
cluster
oc adm policy add-cluster-role-to-user cluster-admin admin
# name: Assign the password immediately without login
oc login --username=admin --password={{ openshift_logging_admin_password
}}
Best,
--
Shirly Radco
BI Principal Software Engineer
Red Hat <https://www.redhat.com/>
<https://www.redhat.com/>
On Thu, Feb 20, 2020 at 11:22 AM Christoph Köhler <
koeh...@luis.uni-hannover.de> wrote:
> Hello!
>
> I have installed metrics store along this documentation:
>
>
> https://ovirt.org/documentation/metrics-install-guide/Installing_Metrics_Store.html
>
> Everything went fine without errors, so I have now the login page in my
> browser. The Problem is that the credentials for login seems to be not
> taken over. The user should be 'admin' and the password is given at the
> beginning in secure_vars.yaml.
>
> Does anyone have an idea what to do now?
>
> Greetings!
> Chris
> ___
> 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/TWWAC43EXXVNCWEXRNNWFH7UFC2C53UB/
>
___
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/FJVWEP4MEECCZMPSHFIYAU7SOI7VCJTN/
[ovirt-users] Re: dashboard data empty
Hi, Have you tried to restart DWH ? systemctl restart ovirt-engine-dwhd If this doesn't work, please send me the ovirt-engine-dwhd.log. Best, -- Shirly Radco BI Principal Software Engineer Red Hat <https://www.redhat.com/> <https://www.redhat.com/> On Thu, Feb 20, 2020 at 7:31 PM Fabrizio Cardarello wrote: > What do you suggest? Could concern the heap size? > > Il gio 20 feb 2020, 17:11 Ritesh Chikatwar ha > scritto: > >> I think this because resultset is not able to map the database value to >> entity. You can error it's bad value for the type short. I guess the the >> value passed for short variable is more then it can store. >> >> On Thu, Feb 20, 2020, 2:56 PM Fabrizio wrote: >> >>> Hello everyone. >>> I intalled 4 node with hosted engine, everything works fine exept the >>> dashboard. it doesn't collect any data and is always empty of information. >>> searching around I found out that the problem could be the dwh service, >>> inside the log there is an error: >>> >>> ## log file >>> 2020-02-19 17:46:14|ETL Service Started >>> ovirtEngineDbDriverClass|org.postgresql.Driver >>> >>> ovirtEngineHistoryDbJdbcConnection|jdbc:postgresql://localhost:5432/ovirt_engine_history?sslfactory=org.postgresql.ssl.NonValidatingFactory >>> hoursToKeepDaily|0 >>> hoursToKeepHourly|720 >>> ovirtEngineDbPassword|** >>> runDeleteTime|3 >>> >>> ovirtEngineDbJdbcConnection|jdbc:postgresql://localhost:5432/engine?sslfactory=org.postgresql.ssl.NonValidatingFactory >>> runInterleave|60 >>> limitRows|limit 1000 >>> ovirtEngineHistoryDbUser|ovirt_engine_history >>> ovirtEngineDbUser|engine >>> deleteIncrement|10 >>> timeBetweenErrorEvents|30 >>> hoursToKeepSamples|24 >>> deleteMultiplier|1000 >>> lastErrorSent|2011-07-03 12:46:47.00 >>> etlVersion|4.3.8 >>> dwhAggregationDebug|false >>> dwhUuid|5c4ffc1b-928f-4d06-a40f-bb34ba11c7f2 >>> ovirtEngineHistoryDbDriverClass|org.postgresql.Driver >>> ovirtEngineHistoryDbPassword|** >>> Exception in component tJDBCInput_2 >>> org.postgresql.util.PSQLException: Bad value for type short : 201905 >>> at >>> org.postgresql.jdbc2.AbstractJdbc2ResultSet.getShort(AbstractJdbc2ResultSet.java:2098) >>> at >>> ovirt_engine_dwh.osenumupdate_4_3.OsEnumUpdate.tJDBCInput_2Process(OsEnumUpdate.java:2354) >>> at >>> ovirt_engine_dwh.osenumupdate_4_3.OsEnumUpdate.tRowGenerator_1Process(OsEnumUpdate.java:1921) >>> at >>> ovirt_engine_dwh.osenumupdate_4_3.OsEnumUpdate.tJDBCInput_4Process(OsEnumUpdate.java:1376) >>> at >>> ovirt_engine_dwh.osenumupdate_4_3.OsEnumUpdate.tJDBCConnection_1Process(OsEnumUpdate.java:873) >>> at >>> ovirt_engine_dwh.osenumupdate_4_3.OsEnumUpdate.tJDBCConnection_2Process(OsEnumUpdate.java:736) >>> at >>> ovirt_engine_dwh.osenumupdate_4_3.OsEnumUpdate.runJobInTOS(OsEnumUpdate.java:4396) >>> at >>> ovirt_engine_dwh.osenumupdate_4_3.OsEnumUpdate.runJob(OsEnumUpdate.java:4099) >>> at >>> ovirt_engine_dwh.samplerunjobs_4_3.SampleRunJobs.tRunJob_4Process(SampleRunJobs.java:947) >>> at >>> ovirt_engine_dwh.samplerunjobs_4_3.SampleRunJobs.tJDBCConnection_2Process(SampleRunJobs.java:767) >>> at >>> ovirt_engine_dwh.samplerunjobs_4_3.SampleRunJobs.tJDBCConnection_1Process(SampleRunJobs.java:642) >>> at >>> ovirt_engine_dwh.samplerunjobs_4_3.SampleRunJobs$2.run(SampleRunJobs.java:2683) >>> >>> ## SERVICE STATUS >>> ● ovirt-engine-dwhd.service - oVirt Engine Data Warehouse >>>Loaded: loaded (/usr/lib/systemd/system/ovirt-engine-dwhd.service; >>> enabled; vendor preset: disabled) >>>Active: active (running) since Wed 2020-02-19 17:46:14 CET; 16h ago >>> Main PID: 6425 (ovirt-engine-dw) >>>CGroup: /system.slice/ovirt-engine-dwhd.service >>>├─6425 /usr/bin/python >>> /usr/share/ovirt-engine-dwh/services/ovirt-engine-dwhd/ovirt-engine-dwhd.py >>> --redirect-output --systemd=notify start >>>└─6512 ovirt-engine-dwhd >>> -Dorg.ovirt.engine.dwh.settings=/tmp/tmparNn_x/settings.properties -Xms1g >>> -Xmx1g -classpath >>> /usr/share/ovirt-engine-dwh/lib/*::/usr/share/java/dom4j.jar:/usr/share/java/apache-commons-collections.jar:/usr/share/java/postgresql-jdbc.jar >>> ovirt_engine_dwh.his
Re: [ovirt-users] oVirt 4.2.0 is now generally available
-- SHIRLY RADCO BI SOFTWARE ENGINEER Red Hat Israel <https://www.redhat.com/> <https://red.ht/sig> TRIED. TESTED. TRUSTED. <https://redhat.com/trusted> On Sat, Dec 23, 2017 at 12:35 PM, Christophe TREFOIS < christophe.tref...@uni.lu> wrote: > Hi, > > Is it possible to include metrics store into an existing ELK stack? > We support our server side, if you have issues on your setup will not be able to help, but it is possible. The oVirt metrics store setup also includes the index templates for elasticsearch for metrics and logs. You will need to create them by yourself if you plan to use your own setup. Best, Shirly > > Thanks, > > -- > > Dr Christophe Trefois, Dipl.-Ing. > Technical Specialist / Post-Doc > > UNIVERSITÉ DU LUXEMBOURG > > LUXEMBOURG CENTRE FOR SYSTEMS BIOMEDICINE > Campus Belval | House of Biomedicine > 6, avenue du Swing > L-4367 Belvaux > T: +352 46 66 44 6124 <+352%2046%2066%2044%206124> > F: +352 46 66 44 6949 <+352%2046%2066%2044%206949> > http://www.uni.lu/lcsb > > [image: Facebook] <https://www.facebook.com/trefex> [image: Twitter] > <https://twitter.com/Trefex> [image: Google Plus] > <https://plus.google.com/+ChristopheTrefois/> [image: Linkedin] > <https://www.linkedin.com/in/trefoischristophe> [image: skype] > <http://skype:Trefex?call> > > > This message is confidential and may contain privileged information. > It is intended for the named recipient only. > If you receive it in error please notify me and permanently delete the > original message and any copies. > > > > On 20 Dec 2017, at 10:40, Sandro Bonazzola wrote: > > The oVirt project is excited to announce the general availability of oVirt > 4.2.0, as of December 20, 2017. > > This release unleashes an altogether more powerful and flexible open > source virtualization solution that encompasses over 1000 individual > changes and a wide range of enhancements across the engine, storage, > network, user interface, and analytics. > > Key features include: > > - A redesigned Administration Portal, with an improved user-interface > - A new VM portal for non-admin users, for a more streamlined experience > - High Performance virtual machine type, for easy optimization of high > performance workloads. > - oVirt metrics store, a new monitoring solution providing complete > infrastructure visibility > - Support for virtual machine connectivity via software-defined networks > - oVirt now supports Nvidia vGPU > - The ovirt-ansible-roles set of packages helps users with common > administration tasks > - Virt-v2v now supports Debian/Ubuntu and EL and Windows-based virtual > machines > > For more information about these and other features, check out the oVirt > 4.2.0 blog post <https://ovirt.org/blog/2017/12/ovirt-4.2.0-now-ga/>. > > This release is available now on x86_64 architecture for: > * Red Hat Enterprise Linux 7.4 or later > * CentOS Linux (or similar) 7.4 or later > > This release supports Hypervisor Hosts on x86_64 and ppc64le (with 4.1 > cluster compatibility only) architectures for: > * Red Hat Enterprise Linux 7.4 or later > * CentOS Linux (or similar) 7.4 or later > * oVirt Node 4.2 (available for x86_64 only) > > See the release notes [3] for installation / upgrade instructions and a > list of new features and bugs fixed. > > If you’re managing more than one oVirt instance, OpenShift Origin or RDO > we also recommend to try ManageIQ <http://manageiq.org/>. > > > Notes: > - oVirt Appliance is already available. > - oVirt Node is already available [4] > - oVirt Windows Guest Tools iso is already available [4] > > Additional Resources: > * Read more about the oVirt 4.2.0 release highlights: > http://www.ovirt.org/release/4.2.0/ > * Get more oVirt project updates on Twitter: https://twitter.com/ovirt > * Check out the latest project news on the oVirt blog: > http://www.ovirt.org/blog/ > > > [1] https://www.ovirt.org/community/ > [2] https://bugzilla.redhat.com/enter_bug.cgi?classification=oVirt > [3] http://www.ovirt.org/release/4.2.0/ > [4] http://resources.ovirt.org/pub/ovirt-4.2/iso/ > > -- > SANDRO BONAZZOLA > > ASSOCIATE MANAGER, SOFTWARE ENGINEERING, EMEA ENG VIRTUALIZATION R&D > Red Hat EMEA <https://www.redhat.com/> > <https://red.ht/sig> > TRIED. TESTED. TRUSTED. <https://redhat.com/trusted> > > ___ > Users mailing list > Users@ovirt.org > http://lists.ovirt.org/mailman/listinfo/users > > > > ___ > Users mailing list > Users@ovirt.org > http://lists.ovirt.org/mailman/listinfo/users > > ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
[ovirt-users] New post on oVirt blog: Build oVirt Reports Using Grafana
Hello everyone, A new oVirt blog post has been published, on how to build oVirt reports using Grafana. This allows connecting to oVirt DWH and create dashboards for System, Hosts, VMs, Storage domains etc. See https://ovirt.org/blog/2018/01/ovirt-report-using-grafana/ for the full post. For more information you can contact me. Best regards, -- SHIRLY RADCO BI SeNIOR SOFTWARE ENGINEER Red Hat Israel <https://www.redhat.com/> <https://red.ht/sig> TRIED. TESTED. TRUSTED. <https://redhat.com/trusted> ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] New post on oVirt blog: Build oVirt Reports Using Grafana
Hi, Did you manage to connect Grafana to DWH? Best regards, -- SHIRLY RADCO BI SOFTWARE ENGINEER Red Hat Israel  TRIED. TESTED. TRUSTED. On Jan 22, 2018 20:10, "Andrei V" wrote: > On 01/22/2018 06:37 PM, Roy Golan wrote: > > We ship postgres 9.5 through the Software Collection. Its missing from > your > > path by default, so in order to run psql you need to: > > > > su - postgres > > scl enable rh-postgresql95 -- psql engine engine > > scl enable rh-postgresql95 -- psql engine engine > psql: FATAL: Peer authentication failed for user "engine" > > Sorry, should it be:? > scl enable rh-postgresql95 -- psql engine > > Do I need to re-enter everything for read-only oVirt DWH user ? > > > > > On Mon, 22 Jan 2018 at 18:19 wrote: > > > >> On 22 Jan 2018, at 18:09, Mikhail Krasnobaev wrote: > >> > >> Good day, > >> > >> i had the same issue, you can try running the commands directly from > >> postgres user: > >> su - postgres > >> And the run the commands from blog post. > >> > >> > >> I did everything as user postgres, otherwise it doesn’t work at all. > >> > >> > >> Best regards, > >> > >> Mikhail. > >> > >> 17:58, 22 января 2018 г., Andrei V : > >> > >> Hi ! > >> > >> Thanks a lot for excellent addition ! > >> > >> I’ve got a problem with connecting Grafana to oVirt 4.2 > >> Followed this instruction and created read-only user usrmonovirt > >> # > >> https://www.ovirt.org/documentation/data-warehouse/ > Allowing_Read_Only_Access_to_the_History_Database/ > >> > >> However, from Grafana login is is always failed: > >> pq: Ident authentication failed for user “usrmonovirt" > >> host = localhost:5432, database = ovirt_engine_history, SSL = disable > >> > >> Reset password with another or even NULL don’t help, still can’t > connect. > >> psql -U postgres -c "ALTER ROLE usrmonovirt WITH PASSWORD ‘mypassword';" > >> -d ovirt_engine_history > >> psql -U postgres -c "ALTER ROLE usrmonovirt WITH PASSWORD NULL;” -d > >> ovirt_engine_history > >> > >> What went wrong? I can’t understand. > >> > >> PS. Looks like oVirt engine spawns PostgreSQL with its own data dir, > >> standard restart via systemcll returns an error (data dir is empty). Yet > >> "ps -aux | grep postgres" shows process is running. > >> > >> Thanks in advance for any suggestion(s). > >> > >> > >> On 21 Jan 2018, at 14:21, Shirly Radco wrote: > >> > >> Hello everyone, > >> > >> A new oVirt blog post has been published, on how to build oVirt reports > >> using Grafana. > >> This allows connecting to oVirt DWH and create dashboards for System, > >> Hosts, VMs, Storage domains etc. > >> > >> See https://ovirt.org/blog/2018/01/ovirt-report-using-grafana/ for the > >> full post. > >> > >> For more information you can contact me. > >> > >> Best regards, > >> > >> -- > >> > >> SHIRLY RADCO > >> > >> BI SeNIOR SOFTWARE ENGINEER > >> Red Hat Israel <https://www.redhat.com/> > >> <https://red.ht/sig> > >> TRIED. TESTED. TRUSTED. <https://redhat.com/trusted> > >> ___ > >> Users mailing list > >> Users@ovirt.org > >> http://lists.ovirt.org/mailman/listinfo/users > >> > >> > >> ___ > >> Users mailing list > >> Users@ovirt.org > >> http://lists.ovirt.org/mailman/listinfo/users > >> > >> > >> > >> Sent from Yandex.Mail for mobile: http://m.ya.ru/ymail > >> > >> ___ > >> Users mailing list > >> Users@ovirt.org > >> http://lists.ovirt.org/mailman/listinfo/users > >> > > ___ > Users mailing list > Users@ovirt.org > http://lists.ovirt.org/mailman/listinfo/users > ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] Any monitoring tool provided?
-- SHIRLY RADCO BI SeNIOR SOFTWARE ENGINEER Red Hat Israel <https://www.redhat.com/> <https://red.ht/sig> TRIED. TESTED. TRUSTED. <https://redhat.com/trusted> On Fri, Mar 23, 2018 at 10:29 PM, Marcelo Leandro wrote: > Hello, > > I am try this how to: > > https://www.ovirt.org/develop/release-management/features/ > metrics/metrics-store-installation/ > > but when i run this command: > /usr/share/ovirt-engine-metrics/setup/ansible/ > configure_ovirt_machines_for_metrics.sh --playbook=ovirt- > metrics-store-installation.yml > > I am had this error mensagem: > ansible-playbook: error: no such option: --playbook > > my version: > > ovirt-engine-metrics-1.0.8-1.el7.centos.noarch > Hi, You are using an old rpm. Please upgrade to latest, ovirt-engine-metrics-1.1.3.3-1.el7.centos.noarch I also added some documentation that is still in pull request: Add Viaq installation guide to the oVirt metrics store repo - https://github.com/oVirt/ovirt-site/pull/1551 - This one is meaningful. I introduced a lot of automation that save time when installing. Add prerequisites for installing OpenShift Logging - https://github.com/oVirt/ovirt-site/pull/1561 Added how to import dashboards examples to kibana - https://github.com/oVirt/ovirt-site/pull/1559 Please review them.I'll try to get them merged asap. > > Anyone can help me? > > > 2018-03-22 16:28 GMT-03:00 Christopher Cox : > >> On 03/21/2018 10:41 PM, Terry hey wrote: >> >>> Dear all, >>> >>> Now, we can just read how many storage used, cpu usage on ovirt >>> dashboard. >>> But is there any monitoring tool for monitoring virtual machine time to >>> time? >>> If yes, could you guys give me the procedure? >>> >> >> A possible option, for a full OS with network connectivity, is to monitor >> the VM like you would any other host. >> >> We use omd/check_mk. >> >> Right now there isn't an oVirt specific monitor plugin for check_mk. >> >> I know what I said is probably pretty obvious, but just in case. >> >> ___ >> Users mailing list >> Users@ovirt.org >> http://lists.ovirt.org/mailman/listinfo/users >> > > > ___ > Users mailing list > Users@ovirt.org > http://lists.ovirt.org/mailman/listinfo/users > > ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] Any monitoring tool provided?
It is possible to use DWH with Grafana to get VMs stats. https://www.ovirt.org/blog/2018/01/ovirt-report-using-grafana/ Relevant views are with the following prefixes: v4_2_statistics_vms_* v4_2_latest_configuration_vms* v4_2_configuration_history_vms* They are all available also in earlier versions but the prefix will be different, like v4_1_* for 4.1. Another option is our new real time monitoring solution , which is based on OpenShift and Elasticearch, Kibana and Fluentd. https://ovirt.org/blog/2017/12/ovirt-metrics-store -- SHIRLY RADCO BI SeNIOR SOFTWARE ENGINEER Red Hat Israel <https://www.redhat.com/> <https://red.ht/sig> TRIED. TESTED. TRUSTED. <https://redhat.com/trusted> On Thu, Mar 22, 2018 at 5:41 AM, Terry hey wrote: > Dear all, > > Now, we can just read how many storage used, cpu usage on ovirt dashboard. > But is there any monitoring tool for monitoring virtual machine time to > time? > If yes, could you guys give me the procedure? > > > Regards > Terry > > ___ > Users mailing list > Users@ovirt.org > http://lists.ovirt.org/mailman/listinfo/users > > ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] Any monitoring tool provided?
-- SHIRLY RADCO BI SeNIOR SOFTWARE ENGINEER Red Hat Israel <https://www.redhat.com/> <https://red.ht/sig> TRIED. TESTED. TRUSTED. <https://redhat.com/trusted> On Tue, Mar 27, 2018 at 8:32 AM, Nicolas Vaye wrote: > Hi Shirly, > > I'm trying to install ovirt metric store with ViaQ on Origin. > > And on https://github.com/oVirt/ovirt-site/pull/1551/files, you mention > **WARNING** DO NOT INSTALL `libvirt` on the OpenShift machine! > > > on my VM "metric store", i requested rpm for libvirt and here are the > results : > > [root@ometricstore<mailto:root@ometricstore> .ssh]# rpm -qa | grep libvirt > libvirt-daemon-driver-secret-3.2.0-14.el7_4.9.x86_64 > libvirt-daemon-driver-storage-core-3.2.0-14.el7_4.9.x86_64 > libvirt-daemon-driver-storage-logical-3.2.0-14.el7_4.9.x86_64 > libvirt-daemon-config-network-3.2.0-14.el7_4.9.x86_64 > libvirt-gconfig-1.0.0-1.el7.x86_64 > libvirt-daemon-driver-storage-disk-3.2.0-14.el7_4.9.x86_64 > libvirt-glib-1.0.0-1.el7.x86_64 > libvirt-libs-3.2.0-14.el7_4.9.x86_64 > libvirt-daemon-driver-nwfilter-3.2.0-14.el7_4.9.x86_64 > libvirt-daemon-driver-storage-gluster-3.2.0-14.el7_4.9.x86_64 > libvirt-daemon-driver-storage-rbd-3.2.0-14.el7_4.9.x86_64 > libvirt-gobject-1.0.0-1.el7.x86_64 > libvirt-daemon-driver-interface-3.2.0-14.el7_4.9.x86_64 > libvirt-daemon-driver-storage-scsi-3.2.0-14.el7_4.9.x86_64 > libvirt-daemon-driver-qemu-3.2.0-14.el7_4.9.x86_64 > libvirt-daemon-kvm-3.2.0-14.el7_4.9.x86_64 > libvirt-daemon-3.2.0-14.el7_4.9.x86_64 > libvirt-daemon-driver-network-3.2.0-14.el7_4.9.x86_64 > libvirt-daemon-driver-storage-iscsi-3.2.0-14.el7_4.9.x86_64 > libvirt-daemon-driver-nodedev-3.2.0-14.el7_4.9.x86_64 > libvirt-daemon-driver-storage-mpath-3.2.0-14.el7_4.9.x86_64 > libvirt-daemon-driver-storage-3.2.0-14.el7_4.9.x86_64 > > should i remove all this package ? > Yes. You will need to remove them. > > > Also on the web page https://www.ovirt.org/develop/ > release-management/features/metrics/metrics-store-installation/#run-ovirt- > metrics-store-installation-playbook, you mention > > /usr/share/ovirt-engine-metrics/setup/ansible/configure_ovirt_hosts_for_metrics.sh > --playbook=ovirt-metrics-store-installation.yml > I apologise for that. It is indeed a documentation bug. Its should be /usr/share/ovirt-engine-metrics/setup/ansible/configure_ovirt_machines_for_metrics.sh --playbook=ovirt-metrics-store-installation.yml as you mentioned. I'll fix it asap. > > > But on my hosted engine 4.2.1.7 with > ovirt-engine-metrics-1.1.3.3-1.el7.centos.noarch, > i notice that the script > > configure_ovirt_hosts_for_metrics.sh doesn't exist but there is a > configure_ovirt_machines_for_metrics.sh script. > > Is it the good one ? > > > > Next, you mention : > Allow connections on the following ports/protocols: > > > + * tcp ports 22, 80, 443, 8443 (openshift console), 9200 (Elasticsearch) > > > following by > > ViaQ on Origin requires these [Yum Repos](centos7-viaq.repo). > > > > > > > > > > > +You will need to install the following packages: docker, > iptables-services. > > > That means that i must uninstall firewalld ? And the ports/protocols will > be managed by iptables-services ? > No , you can just open the ports in firewalld. > > What is the command to allow connections on tcp ports 22,80, 443 etc ? > To open a Port on CentOS/RHEL 7 run sudo firewall-cmd --zone=public --add-port=80/tcp --permanent for each port and sudo firewall-cmd --reload Check the updated rules with: firewall-cmd --list-all > > Is it managed automatically with docker or openshift or other program ? > The metrics store is managed by OpenShift. > > > Thanks for all. > > > Nicolas VAYE > > > ---- Message initial > > Date: Sun, 25 Mar 2018 12:01:23 +0300 > Objet: Re: [ovirt-users] Any monitoring tool provided? > Cc: users mailto:users%20%3cus...@ovirt.org%3e>> > À: Marcelo Leandro mailto:Marcelo%20Leandro%20% > 3cmarcelol...@gmail.com%3e>> > De: Shirly Radco mailto:Shir > ly%20radco%20%3csra...@redhat.com%3e>> > > > > -- > > SHIRLY RADCO > > BI SeNIOR SOFTWARE ENGINEER > > Red Hat Israel<https://www.redhat.com/> > > [https://www.redhat.com/files/brand/email/sig-redhat.png] tps://red.ht/sig> > TRIED. TESTED. TRUSTED.<https://redhat.com/trusted> > > > On Fri, Mar 23, 2018 at 10:29 PM, Marcelo Leandro <mailto:marcelol...@gmail.com>> wrote: > Hello, > > I am try this how to: > > https://www.ovirt.org/develop/release-management/features/ > metrics/metrics-store-installation/ > > but when i run this c
Re: [ovirt-users] Any monitoring tool provided?
Adding Rich Megginson.
--
SHIRLY RADCO
BI SeNIOR SOFTWARE ENGINEER
Red Hat Israel <https://www.redhat.com/>
<https://red.ht/sig>
TRIED. TESTED. TRUSTED. <https://redhat.com/trusted>
On Wed, Mar 28, 2018 at 1:10 AM, Nicolas Vaye
wrote:
> OK, i have removed all libvirt-* packages
>
> i have seen that in the playbook, firewalld will be disable and iptables
> manage the firewall.
>
> I have a problem because my metric server was behind a proxy web and when
> i run
>
> ANSIBLE_LOG_PATH=/tmp/ansible.log ansible-playbook -vvv -e
> @/root/vars.yaml -i /root/ansible-inventory-origin-37-aio
> playbooks/byo/config.yml
>
> i get
>
>
> CHECK [memory_availability : localhost] **
>
> **
>
> fatal: [localhost]: FAILED! => {
>
> "changed": false,
>
> "checks": {
>
> "disk_availability": {},
>
> "docker_image_availability": {
>
> "failed": true,
>
> "failures": [
>
> [
>
> "OpenShiftCheckException",
>
> "One or more required container images are not
> available:\ncockpit/kubernetes:latest,\n
> openshift/origin-deployer:latest,\n
> openshift/origin-docker-registry:latest,\n
> openshift/origin-haproxy-router:latest,\n
> openshift/origin-pod:latest\nChecked with: skopeo inspect
> [--tls-verify=false] [--creds=:]
> docker:///\nDefault
> registries searched: docker.io\nFailed connecting to: docker.io\n"
>
> ]
>
> ],
>
> "msg": "One or more required container images are not
> available:\ncockpit/kubernetes:latest,\n
> openshift/origin-deployer:latest,\n
> openshift/origin-docker-registry:latest,\n
> openshift/origin-haproxy-router:latest,\n
> openshift/origin-pod:latest\nChecked with: skopeo inspect
> [--tls-verify=false] [--creds=:]
> docker:///\nDefault
> registries searched: docker.io\nFailed connecting to: docker.io\n"
>
> },
>
> "docker_storage": {
>
> "skipped": true,
>
> "skipped_reason": "Disabled by user request"
>
> },
>
> "memory_availability": {},
>
> "package_availability": {
>
> "changed": false,
>
> "invocation": {
>
> "module_args": {
>
> "packages": [
>
> "PyYAML",
>
> "bash-completion",
>
> "bind",
>
> "ceph-common",
>
> "cockpit-bridge",
>
> "cockpit-docker",
>
> "cockpit-system",
>
> "cockpit-ws",
>
> "dnsmasq",
>
> "docker",
>
> "etcd",
>
> "firewalld",
>
> "flannel",
>
> "glusterfs-fuse",
>
> "httpd-tools",
>
> "iptables",
>
> "iptables-services",
>
> "iscsi-initiator-utils",
>
> "libselinux-python",
>
> "nfs-utils",
>
> "ntp",
>
> "openssl",
>
> "origin",
>
> "origin-clients",
>
> "origin-master",
>
> "origin-node",
>
> "origin-sdn-ovs",
>
> "pyparted",
>
> "python-httplib2",
>
> "yum-utils"
>
> ]
>
> }
>
> }
>
> },
>
> "package_version": {
>
> "skipped": true,
>
> "skipped_reason": "Disabled by user request"
>
> }
>
> },
>
> &qu
Re: [ovirt-users] Any monitoring tool provided?
Hi Peter, Using the oVirt API will add load on the engine and may affect the engine performance. We have the DWH that collectd metrics and configuration data about the hosts and vms and can be used along with Grafana. We also added the oVirt metrics store that collects the metrics directly from the host about the hosts and vms and from the engine about the machine itself and postgres db. This was done in order to lower the load on the engine. We also collect the engine.log and vdsm.log. The metrics are collected to Elasticsearch and can be visualised in Kibana and Grafana and are collected in 10 sec interval that give you almost real time view. I would love to hear why you prefer using Zabbix for collecting the metrics data. Best regards, -- SHIRLY RADCO BI SeNIOR SOFTWARE ENGINEER Red Hat Israel <https://www.redhat.com/> <https://red.ht/sig> TRIED. TESTED. TRUSTED. <https://redhat.com/trusted> On Wed, Mar 28, 2018 at 5:38 PM, Peter Hudec wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA256 > > I have working proof-of-concept. There still could be bug in > templates and not all parameters are monitored, but HOST and VM > discovery is working. > > I will try to share it on github. At this moment I have some > performance issues, since it's using the zabbix-agent which needs to > for a new process for each query ;( > > Peter > > On 26/03/2018 08:13, Peter Hudec wrote: > > Yes, template and python > > > > at this moment I understand oVirt API. I needed to write own small > > SDK, since the oVirt SDK is using SSO for login, that means it do > > some additional requests for login process. There is no option to > > use Basic Auth. The SESSION reuse could be useful, but I do no > > want to add more > > > > First I need to understand some basics from Zabbix Discovery > > Rules / Host Prototypes. I would like to have VM as separate hosts > > in Zabbix, like VMWare does. The other stuff is quite easy. > > > > There plugin for nagios/icinga if someone using this monitoring > > tool https://github.com/ovido/check_rhev3 > > > > On 26/03/2018 08:02, Alex K wrote: > >> Hi Peter, > > > >> This is interesting. Is it going to be a template with an > >> external python script? > > > >> Alex > > > >> On Mon, Mar 26, 2018, 08:50 Peter Hudec >> <mailto:phu...@cnc.sk>> wrote: > > > >> Hi Terry, > > > >> I started to work on ZABBIX integration based on oVirt API. > >> Basically it should be like VmWare integration in ZABBIX with > >> full hosts/vms discovery and statistic gathering. > > > >> The API provides for each statistics service for NIC, VM as wall > >> CPU and MEM utilization. > > > >> There is also solution based on reading data from VDSM to > >> prometheus > >> http://rmohr.github.io/virtualization/2016/04/12/monitor-your-ovirt-d > a > > > >> > >> > ta > > > > > > center-with-prometheus > >> <http://rmohr.github.io/virtualization/2016/04/12/monitor-your-ovirt- > d > > > >> > >> > atacenter-with-prometheus>. > > > > > > > >> Peter > > > >> On 22/03/2018 04:41, Terry hey wrote: > >>> Dear all, > > > >>> Now, we can just read how many storage used, cpu usage on > >>> ovirt dashboard. But is there any monitoring tool for > >>> monitoring virtual machine time to time? If yes, could you guys > >>> give me the procedure? > > > > > > > >>> Regards Terry > > > > > >>> ___ Users mailing > >>> list Users@ovirt.org <mailto:Users@ovirt.org> > >> http://lists.ovirt.org/mailman/listinfo/users > > > > > > > >> ___ Users mailing > >> list Users@ovirt.org <mailto:Users@ovirt.org> > >> http://lists.ovirt.org/mailman/listinfo/users > > > > > > > > - -- > *Peter Hudec* > Infraštruktúrny architekt > phu...@cnc.sk <mailto:phu...@cnc.sk> > > *CNC, a.s.* > Borská 6, 841 04 Bratislava > Recepcia: +421 2 35 000 100 > > Mobil:+421 905 997 203 > *www.cnc.sk* <http:///www.cnc.sk> > > -BEGIN PGP SIGNATURE- > > iQJCBAEBCAAsFiEEqSUbhuEwhryifNeVQnvVWOJ35BAFAlq7qPsOHHBodWRlY0Bj > bmMuc2sACgkQQnvVWOJ35BDXzw/8ChApssWNkM0HiixYESQP+lgxJeHqHYgvBbrQ > DTfiOfTXrWDLIXn7LQdtt7IH4LtTDEwLcGBFSQCTUuX7W6y6Uj5y9pkcGLrtFYuP > g1yBEPuqO3RB2QoR6FLlEy
Re: [ovirt-users] Engine reports
Hi Peter,
The installation instructions currently support OpenShift 3.6.
I'm now working on updating them to support 3.9.
You currently have 3.10 installed.
Please install OpenShift 3.9 using this repository
https://github.com/ViaQ/Main/blob/master/centos7-viaq.repo
And add the following file to your vm
Run:
vi /root/ansible-inventory-origin-39-aio
Add:
--
[OSEv3:children]
nodes
masters
etcd
[OSEv3:vars]
ansible_connection=local
openshift_release=v3.9
openshift_logging_install_logging=true
short_version=3.9
openshift_deployment_type=origin
openshift_master_identity_providers=[{'mappingMethod': 'lookup',
'challenge': 'true', 'login': 'true', 'kind':
'AllowAllPasswordIdentityProvider', 'name': 'allow_all'}]
# bug - doesn't use correct tag
openshift_logging_image_version=v3.9
openshift_logging_elasticsearch_proxy_image_version=v1.0.0
openshift_logging_es_allow_external=True
openshift_logging_use_mux=True
openshift_logging_mux_allow_external=True
openshift_logging_mux_file_buffer_storage_type=hostmount
openshift_logging_elasticsearch_storage_type=hostmount
openshift_logging_elasticsearch_hostmount_path=/var/lib/elasticsearch
[nodes]
localhost storage=True openshift_node_labels="{'region': 'infra'}"
openshift_schedulable=True
[masters]
localhost storage=True openshift_node_labels="{'region': 'infra'}"
openshift_schedulable=True
[etcd]
localhost storage=True openshift_node_labels="{'region': 'infra'}"
openshift_schedulable=True
Save and exit.
***Please make sure that you use /var as your Elasticsearch persistent
storage directory.
And when you run the OpenShift ansible (
https://www.ovirt.org/develop/release-management/features/metrics/setting-up-viaq-logging/#running-ansible)
use the file you just created like this:
# cd /usr/share/ansible/openshift-ansible
# (or wherever you cloned the git repo if using git)
ANSIBLE_LOG_PATH=/tmp/ansible.log ansible-playbook -vvv -e @/root/vars.yaml
-i /root/*ansible-inventory-origin-39-aio* playbooks/byo/config.yml
Best regards,
--
SHIRLY RADCO
BI SeNIOR SOFTWARE ENGINEER
Red Hat Israel <https://www.redhat.com/>
<https://red.ht/sig>
TRIED. TESTED. TRUSTED. <https://redhat.com/trusted>
On Wed, Apr 4, 2018 at 12:17 PM, Peter Hudec wrote:
> Tried to install ovirt metrics, but got error
>
> ANSIBLE_LOG_PATH=/tmp/ansible.log ansible-playbook -vvv -e
> @/root/vars.yaml -i /root/ansible-inventory-origin-37-aio
> playbooks/byo/config.yml
>
> 1. Hosts:localhost
> Play: Determine openshift_version to configure on first master
> Task: For an RPM install, abort when the release requested does
> not match the available version.
> Message: You requested openshift_release 3.7, which is not matched by
>the latest OpenShift RPM we detected as origin-3.10.0
>on host localhost.
>We will only install the latest RPMs, so please ensure
> you are getting the release
>you expect. You may need to adjust your Ansible
> inventory, modify the repositories
>available on the host, or run the appropriate OpenShift
> upgrade playbook.
>
> regards
> Peter
>
>
> On 04/04/2018 09:13, Fred Rolland wrote:
> > Hi,
> >
> > Check these links:
> >
> > https://ovirt.org/blog/2018/01/ovirt-report-using-grafana/
> > https://ovirt.org/develop/release-management/features/
> metrics/metrics-store/
> >
> > Regards,
> > Fred
> >
> > On Tue, Apr 3, 2018 at 9:38 AM, Anantha Raghava
> > mailto:rag...@exzatechconsulting.com>>
> > wrote:
> >
> > Hi,
> >
> > I see that oVirt DWH is installed with Version 4.2.x. Now, how do I
> > take the reports? I version 3.5, we had Jasper reports module using
> > which we could take utilization reports. Can we do something similar
> > here?
> >
> > --
> >
> > Thanks & Regards,
> >
> >
> > Anantha Raghava
> >
> >
> > Do not print this e-mail unless required. Save Paper & trees.
> >
> >
> > ___
> > Users mailing list
> > Users@ovirt.org <mailto:Users@ovirt.org>
> > http://lists.ovirt.org/mailman/listinfo/users
> > <http://lists.ovirt.org/mailman/listinfo/users>
> >
> >
> >
> >
> > ___
> > Users mailing list
> > Users@ovirt.org
> > http://lists.ovirt.org/mailman/listinfo/users
> >
>
>
> --
> *Peter Hudec*
> Infraštruktúrny architekt
> phu...@cnc.sk <mailto:phu...@cnc.sk>
>
> *CNC, a.s.*
> Borská 6, 841 04 Bratislava
> Recepcia: +421 2 35 000 100
>
> Mobil:+421 905 997 203
> *www.cnc.sk* <http:///www.cnc.sk>
>
> ___
> Users mailing list
> Users@ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
>
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] Engine reports
Adding Nicolas since he hit the same issue.
--
SHIRLY RADCO
BI SeNIOR SOFTWARE ENGINEER
Red Hat Israel <https://www.redhat.com/>
<https://red.ht/sig>
TRIED. TESTED. TRUSTED. <https://redhat.com/trusted>
On Wed, Apr 4, 2018 at 3:17 PM, Shirly Radco wrote:
> Hi Peter,
>
> The installation instructions currently support OpenShift 3.6.
>
> I'm now working on updating them to support 3.9.
>
> You currently have 3.10 installed.
>
> Please install OpenShift 3.9 using this repository
> https://github.com/ViaQ/Main/blob/master/centos7-viaq.repo
>
> And add the following file to your vm
>
> Run:
> vi /root/ansible-inventory-origin-39-aio
>
> Add:
>
> --
> [OSEv3:children]
> nodes
> masters
> etcd
>
> [OSEv3:vars]
> ansible_connection=local
> openshift_release=v3.9
> openshift_logging_install_logging=true
> short_version=3.9
> openshift_deployment_type=origin
> openshift_master_identity_providers=[{'mappingMethod': 'lookup',
> 'challenge': 'true', 'login': 'true', 'kind': '
> AllowAllPasswordIdentityProvider', 'name': 'allow_all'}]
> # bug - doesn't use correct tag
> openshift_logging_image_version=v3.9
> openshift_logging_elasticsearch_proxy_image_version=v1.0.0
>
> openshift_logging_es_allow_external=True
> openshift_logging_use_mux=True
> openshift_logging_mux_allow_external=True
> openshift_logging_mux_file_buffer_storage_type=hostmount
> openshift_logging_elasticsearch_storage_type=hostmount
> openshift_logging_elasticsearch_hostmount_path=/var/lib/elasticsearch
>
> [nodes]
> localhost storage=True openshift_node_labels="{'region': 'infra'}"
> openshift_schedulable=True
>
> [masters]
> localhost storage=True openshift_node_labels="{'region': 'infra'}"
> openshift_schedulable=True
>
> [etcd]
> localhost storage=True openshift_node_labels="{'region': 'infra'}"
> openshift_schedulable=True
>
>
>
>
> Save and exit.
>
>
> ***Please make sure that you use /var as your Elasticsearch persistent
> storage directory.
>
> And when you run the OpenShift ansible (https://www.ovirt.org/
> develop/release-management/features/metrics/setting-up-
> viaq-logging/#running-ansible) use the file you just created like this:
>
> # cd /usr/share/ansible/openshift-ansible
> # (or wherever you cloned the git repo if using git)
> ANSIBLE_LOG_PATH=/tmp/ansible.log ansible-playbook -vvv -e
> @/root/vars.yaml -i /root/*ansible-inventory-origin-39-aio*
> playbooks/byo/config.yml
>
> Best regards,
>
> --
>
> SHIRLY RADCO
>
> BI SeNIOR SOFTWARE ENGINEER
>
> Red Hat Israel <https://www.redhat.com/>
> <https://red.ht/sig>
> TRIED. TESTED. TRUSTED. <https://redhat.com/trusted>
>
> On Wed, Apr 4, 2018 at 12:17 PM, Peter Hudec wrote:
>
>> Tried to install ovirt metrics, but got error
>>
>> ANSIBLE_LOG_PATH=/tmp/ansible.log ansible-playbook -vvv -e
>> @/root/vars.yaml -i /root/ansible-inventory-origin-37-aio
>> playbooks/byo/config.yml
>>
>> 1. Hosts:localhost
>> Play: Determine openshift_version to configure on first master
>> Task: For an RPM install, abort when the release requested does
>> not match the available version.
>> Message: You requested openshift_release 3.7, which is not matched
>> by
>>the latest OpenShift RPM we detected as origin-3.10.0
>>on host localhost.
>>We will only install the latest RPMs, so please ensure
>> you are getting the release
>>you expect. You may need to adjust your Ansible
>> inventory, modify the repositories
>>available on the host, or run the appropriate OpenShift
>> upgrade playbook.
>>
>> regards
>> Peter
>>
>>
>> On 04/04/2018 09:13, Fred Rolland wrote:
>> > Hi,
>> >
>> > Check these links:
>> >
>> > https://ovirt.org/blog/2018/01/ovirt-report-using-grafana/
>> > https://ovirt.org/develop/release-management/features/metric
>> s/metrics-store/
>> >
>> > Regards,
>> > Fred
>> >
>> > On Tue, Apr 3, 2018 at 9:38 AM, Anantha Raghava
>> > mailto:rag...@exzatechconsulting.com>>
>> > wrote:
>> >
>> > Hi,
>> >
>> > I see that oVirt DWH is installed with Version 4.2.x. Now, how do I
>> > take the reports? I version 3.5,
Re: [ovirt-users] Engine reports
--
SHIRLY RADCO
BI SeNIOR SOFTWARE ENGINEER
Red Hat Israel <https://www.redhat.com/>
<https://red.ht/sig>
TRIED. TESTED. TRUSTED. <https://redhat.com/trusted>
On Wed, Apr 4, 2018 at 5:07 PM, Peter Hudec wrote:
> almost the same issue, the versio for openshoft release changed to 3.9
>
> Failure summary:
>
>
> 1. Hosts:localhost
> Play: Determine openshift_version to configure on first master
> Task: For an RPM install, abort when the release requested does
> not match the available version.
> Message: You requested openshift_release 3.9, which is not matched by
>the latest OpenShift RPM we detected as origin-3.10.0
>on host localhost.
>We will only install the latest RPMs, so please ensure
> you are getting the release
>you expect. You may need to adjust your Ansible
> inventory, modify the repositories
>available on the host, or run the appropriate OpenShift
> upgrade playbook.
>
>
What is the rpm version installed of OpenShift origin?
Do you perhaps have another repo that includes the OpenShift origin-3.10.0?
> On 04/04/2018 14:18, Shirly Radco wrote:
> > Adding Nicolas since he hit the same issue.
> >
> > --
> >
> > SHIRLY RADCO
> >
> > BI SeNIOR SOFTWARE ENGINEER
> >
> > Red Hat Israel <https://www.redhat.com/>
> >
> > <https://red.ht/sig>
> > TRIED. TESTED. TRUSTED. <https://redhat.com/trusted>
> >
> >
> > On Wed, Apr 4, 2018 at 3:17 PM, Shirly Radco > <mailto:sra...@redhat.com>> wrote:
> >
> > Hi Peter,
> >
> > The installation instructions currently support OpenShift 3.6.
> >
> > I'm now working on updating them to support 3.9.
> >
> > You currently have 3.10 installed.
> >
> > Please install OpenShift 3.9 using this repository
> > https://github.com/ViaQ/Main/blob/master/centos7-viaq.repo
> > <https://github.com/ViaQ/Main/blob/master/centos7-viaq.repo>
> >
> > And add the following file to your vm
> >
> > Run:
> > vi /root/ansible-inventory-origin-39-aio
> >
> > Add:
> >
> > --
> > [OSEv3:children]
> > nodes
> > masters
> > etcd
> >
> > [OSEv3:vars]
> > ansible_connection=local
> > openshift_release=v3.9
> > openshift_logging_install_logging=true
> > short_version=3.9
> > openshift_deployment_type=origin
> > openshift_master_identity_providers=[{'mappingMethod': 'lookup',
> > 'challenge': 'true', 'login': 'true', 'kind':
> > 'AllowAllPasswordIdentityProvider', 'name': 'allow_all'}]
> > # bug - doesn't use correct tag
> > openshift_logging_image_version=v3.9
> > openshift_logging_elasticsearch_proxy_image_version=v1.0.0
> >
> > openshift_logging_es_allow_external=True
> > openshift_logging_use_mux=True
> > openshift_logging_mux_allow_external=True
> > openshift_logging_mux_file_buffer_storage_type=hostmount
> > openshift_logging_elasticsearch_storage_type=hostmount
> > openshift_logging_elasticsearch_hostmount_path=/
> var/lib/elasticsearch
> >
> > [nodes]
> > localhost storage=True openshift_node_labels="{'region': 'infra'}"
> > openshift_schedulable=True
> >
> > [masters]
> > localhost storage=True openshift_node_labels="{'region': 'infra'}"
> > openshift_schedulable=True
> >
> > [etcd]
> > localhost storage=True openshift_node_labels="{'region': 'infra'}"
> > openshift_schedulable=True
> >
> >
> >
> >
> > Save and exit.
> >
> >
> > ***Please make sure that you use /var as your Elasticsearch
> > persistent storage directory.
> >
> > And when you run the OpenShift ansible
> > (https://www.ovirt.org/develop/release-management/
> features/metrics/setting-up-viaq-logging/#running-ansible
> > <https://www.ovirt.org/develop/release-management/
> features/metrics/setting-up-viaq-logging/#running-ansible>)
> > use the file you just created like this:
> >
> > # cd /usr/share/ansible/openshift-ansible
> > # (or wherever you cloned the git repo if using git)
> > ANSIBLE_LOG_PATH=/tm
Re: [ovirt-users] Engine reports
Hi, I have a updated the installation instructions for installing OpenShift 3.9, based on Rich's work , for the oVirt use case. Please make sure where you get the 3.10 rpm and disable that repo. This is the PR that includes the metrics store installation of OpenShift 3.9 https://github.com/sradco/ovirt-site/blob/74f1e772c8ca75d4b9e57a3c02cce49c5030f7f7/source/develop/release-management/features/metrics/setting-up-viaq-logging.html.md It should be merged soon, but you can use it to install. Please make sure to add the ansible-inventory-origin-39-aio file as described below. These are required parameters for the ansible playbook. Best regards, -- SHIRLY RADCO BI SeNIOR SOFTWARE ENGINEER Red Hat Israel <https://www.redhat.com/> <https://red.ht/sig> TRIED. TESTED. TRUSTED. <https://redhat.com/trusted> On Wed, Apr 4, 2018 at 5:41 PM, Rich Megginson wrote: > I'm sorry. I misunderstood the request. > > We are in the process of updating the instructions for installing viaq > logging based on upstream origin 3.9 - https://github.com/ViaQ/Main/p > ull/37 > > In the meantime, you can follow along on that PR, and we will have > instructions very soon. > > > On 04/04/2018 08:26 AM, Rich Megginson wrote: > >> On 04/04/2018 08:22 AM, Shirly Radco wrote: >> >>> >>> >>> -- >>> >>> SHIRLY RADCO >>> >>> BI SeNIOR SOFTWARE ENGINEER >>> >>> Red Hat Israel <https://www.redhat.com/> >>> >>> <https://red.ht/sig> >>> TRIED. TESTED. TRUSTED. <https://redhat.com/trusted> >>> >>> >>> On Wed, Apr 4, 2018 at 5:07 PM, Peter Hudec >> phu...@cnc.sk>> wrote: >>> >>> almost the same issue, the versio for openshoft release changed to >>> 3.9 >>> >>> Failure summary: >>> >>> >>> 1. Hosts:localhost >>> Play: Determine openshift_version to configure on first >>> master >>> Task: For an RPM install, abort when the release >>> requested does >>> not match the available version. >>> Message: You requested openshift_release 3.9, which is not >>> matched by >>>the latest OpenShift RPM we detected as origin-3.10.0 >>>on host localhost. >>>We will only install the latest RPMs, so please ensure >>> you are getting the release >>>you expect. You may need to adjust your Ansible >>> inventory, modify the repositories >>>available on the host, or run the appropriate >>> OpenShift >>> upgrade playbook. >>> >>> >>> What is the rpm version installed of OpenShift origin? >>> Do you perhaps have another repo that includes the OpenShift >>> origin-3.10.0? >>> >> >> origin is the upstream version of OpenShift, which is unsupported. >> >> sudo repoquery -i origin >> >> This will tell you which repo it came from >> >> You will need to disable that repo and uninstall any packages which came >> from that repo >> >> Another mystery is why it is trying to install origin in the first >> place. openshift-ansible with openshift_deployment_type=openshift-enterprise >> should not try to install origin, it should install packages with names >> like atomic-openshift-master, atomic-openshift-node, etc. >> >> >>> >>> >>> On 04/04/2018 14:18, Shirly Radco wrote: >>> > Adding Nicolas since he hit the same issue. >>> > >>> > -- >>> > >>> > SHIRLY RADCO >>> > >>> > BI SeNIOR SOFTWARE ENGINEER >>> > >>> > Red Hat Israel <https://www.redhat.com/> >>> > >>> > <https://red.ht/sig> >>> > TRIED. TESTED. TRUSTED. <https://redhat.com/trusted> >>> > >>> > >>> > On Wed, Apr 4, 2018 at 3:17 PM, Shirly Radco >> <mailto:sra...@redhat.com> >>> > <mailto:sra...@redhat.com <mailto:sra...@redhat.com>>> wrote: >>> > >>> > Hi Peter, >>> > >>> > The installation instructions currently support OpenShift 3.6. >>> > >>> > I'm now working on updating them to support 3.9. >>> > >>> > You currently have 3.10 installed
Re: [ovirt-users] ansible failure during host install
Hi,
What version of ovirt-engine-metrics are you using?
Did you already setup the OpenShift based metrics store to connect to?
Have you configured /etc/ovirt-engine-metrics/config.yml?
--
SHIRLY RADCO
BI SENIOR SOFTWARE ENGINEER
Red Hat Israel
TRIED. TESTED. TRUSTED.
On Thu, Apr 12, 2018, 21:35 Young, Matthew (Numerical Algorithms Group) <
matthew.you...@bp.com> wrote:
> Hello all,
>
>
>
> I have been working on adding a new host to an oVirt cluster. The
> installation is failing in the ansible portion, specifically installing the
> ansible elasticsearch ca cert. I have no experience with ansible. Does
> anyone know what is causing this issue? Or how to create this ca cert?
>
>
>
> from ansible log
>
> …
>
> 2018-04-12 09:32:18,114 p=56616 u=ovirt | TASK
> [oVirt.ovirt-fluentd/fluentd-setup : Create fluentd.conf] *
>
> 2018-04-12 09:32:18,730 p=56616 u=ovirt | ok: [10.222.10.156] => {
>
> "changed": false,
>
> "checksum": "c9f88b60cd12ab8e3f3ffce1ae07654c89b06ef6",
>
> "gid": 0,
>
> "group": "root",
>
> "mode": "0640",
>
> "owner": "root",
>
> "path": "/etc/fluentd/fluent.conf",
>
> "secontext": "system_u:object_r:etc_t:s0",
>
> "size": 58,
>
> "state": "file",
>
> "uid": 0
>
> }
>
> 2018-04-12 09:32:18,739 p=56616 u=ovirt | TASK
> [oVirt.ovirt-fluentd/fluentd-setup : Install fluentd certificate] *
>
> 2018-04-12 09:32:18,759 p=56616 u=ovirt | skipping: [10.222.10.156] => {
>
> "changed": false,
>
> "skip_reason": "Conditional result was False"
>
> }
>
> 2018-04-12 09:32:18,768 p=56616 u=ovirt | TASK
> [oVirt.ovirt-fluentd/fluentd-setup : Install fluentd elasticsearch CA
> certificate] ***
>
> 2018-04-12 09:32:18,810 p=56616 u=ovirt | fatal: [10.222.10.156]: FAILED!
> => {
>
> "changed": false
>
> }
>
>
>
> MSG:
>
>
>
> src (or content) is required
>
>
>
> 2018-04-12 09:32:18,812 p=56616 u=ovirt | PLAY RECAP
> *
>
> 2018-04-12 09:32:18,812 p=56616 u=ovirt | 10.222.10.156 :
> ok=33 changed=4unreachable=0failed=1
>
>
>
>
> ___
> Users mailing list
> Users@ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
>
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] ansible failure during host install
If you did not install the Openshift based metrics store you need to remove
the /etc/ovirt-engine-metrics-config.yml file.
It is only required while setting up the metrics store.
This should fix you host install issue, ansible will skip the roles related
to the metrics configuration on the host.
If you are interested in setting up the metrics store you can have a look
at
https://www.ovirt.org/develop/release-management/features/metrics/metrics-store/
--
SHIRLY RADCO
BI SeNIOR SOFTWARE ENGINEER
Red Hat Israel <https://www.redhat.com/>
<https://red.ht/sig>
TRIED. TESTED. TRUSTED. <https://redhat.com/trusted>
On Fri, May 4, 2018 at 1:20 AM, Young, Matthew (Numerical Algorithms Group)
wrote:
> I’ve gotten past that error with “oc delete route/docker-registry” before
> restart the playbook
>
>
>
> Matt
>
>
>
> *From:* Young, Matthew (Numerical Algorithms Group)
> *Sent:* Thursday, May 3, 2018 4:02 PM
> *To:* 'Shirly Radco'
> *Cc:* users
> *Subject:* RE: [ovirt-users] ansible failure during host install
>
>
>
> Ovirt-engine-metrics v1.1.3.4
>
>
>
> /etc/ovirt-engine-metrics/config.yml:
>
> ovirt_env_name: data-science-sandbox
>
> fluentd_elasticsearch_host: ovirt-metrics.datasci.bp.com
>
> ovirt_elasticsearch_mounted_storage_path: /data
>
>
>
> I have not gotten the openshift based metrics store running. It is
> consistently timing out while performing “TASK [openshift_hosted :
> Configure a passthrough route for docker-registry].”
>
> Failure summary:
>
> 1. Hosts:localhost
>
> Play: Create Hosted Resources - registry
>
> Task: Configure a passthrough route for docker-registry
>
> Message: {u'cmd': u'/usr/bin/oc replace -f
> /tmp/docker-registry-DtGZqz --force -n default', u'returncode': 1,
> u'results': {}, u'stderr': u'error: timed out waiting for the condition\n',
> u'stdout': u'route "docker-registry" deleted\n'}
>
>
>
> Matt Young
>
>
>
> *From:* Shirly Radco
> *Sent:* Thursday, April 12, 2018 4:04 PM
> *To:* Young, Matthew (Numerical Algorithms Group)
> *Cc:* users
> *Subject:* Re: [ovirt-users] ansible failure during host install
>
>
>
> Hi,
>
>
>
> What version of ovirt-engine-metrics are you using?
>
>
>
> Did you already setup the OpenShift based metrics store to connect to?
>
>
>
> Have you configured /etc/ovirt-engine-metrics/config.yml?
>
>
>
> --
>
> SHIRLY RADCO
>
> BI SENIOR SOFTWARE ENGINEER
>
> Red Hat Israel
>
>
> TRIED. TESTED. TRUSTED.
>
>
>
>
>
> On Thu, Apr 12, 2018, 21:35 Young, Matthew (Numerical Algorithms Group) <
> matthew.you...@bp.com> wrote:
>
> Hello all,
>
>
>
> I have been working on adding a new host to an oVirt cluster. The
> installation is failing in the ansible portion, specifically installing the
> ansible elasticsearch ca cert. I have no experience with ansible. Does
> anyone know what is causing this issue? Or how to create this ca cert?
>
>
>
> from ansible log
>
> …
>
> 2018-04-12 09:32:18,114 p=56616 u=ovirt | TASK
> [oVirt.ovirt-fluentd/fluentd-setup : Create fluentd.conf]
> *
>
> 2018-04-12 09:32:18,730 p=56616 u=ovirt | ok: [10.222.10.156] => {
>
> "changed": false,
>
> "checksum": "c9f88b60cd12ab8e3f3ffce1ae07654c89b06ef6",
>
> "gid": 0,
>
> "group": "root",
>
> "mode": "0640",
>
> "owner": "root",
>
> "path": "/etc/fluentd/fluent.conf",
>
> "secontext": "system_u:object_r:etc_t:s0",
>
> "size": 58,
>
> "state": "file",
>
> "uid": 0
>
> }
>
> 2018-04-12 09:32:18,739 p=56616 u=ovirt | TASK
> [oVirt.ovirt-fluentd/fluentd-setup : Install fluentd certificate]
> *
>
> 2018-04-12 09:32:18,759 p=56616 u=ovirt | skipping: [10.222.10.156] => {
>
> "changed": false,
>
> "skip_reason": "Conditional result was False"
>
> }
>
> 2018-04-12 09:32:18,768 p=56616 u=ovirt | TASK
> [oVirt.ovirt-fluentd/fluentd-setup : Install fluentd elasticsearch CA
> certificate] ***
>
> 2018-04-12 09:32:18,810 p=56616 u=ovirt | fatal: [10.222.10.156]: FAILED!
> => {
>
> "changed": false
>
> }
>
>
>
> MSG:
>
>
>
> src (or content) is required
>
>
>
> 2018-04-12 09:32:18,812 p=56616 u=ovirt | PLAY RECAP
> *
>
> 2018-04-12 09:32:18,812 p=56616 u=ovirt | 10.222.10.156 :
> ok=33 changed=4unreachable=0failed=1
>
>
>
>
>
> ___
> Users mailing list
> Users@ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
>
>
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] ansible failure during host install
--
SHIRLY RADCO
BI SeNIOR SOFTWARE ENGINEER
Red Hat Israel <https://www.redhat.com/>
<https://red.ht/sig>
TRIED. TESTED. TRUSTED. <https://redhat.com/trusted>
On Sun, May 6, 2018 at 12:47 PM, Shirly Radco wrote:
> If you did not install the Openshift based metrics store you need to
> remove the /etc/ovirt-engine-metrics-config.yml file.
>
Sorry. Remove /etc/ovirt-engine-metrics/config.yml
It is only required while setting up the metrics store.
>
> This should fix you host install issue, ansible will skip the roles
> related to the metrics configuration on the host.
> If you are interested in setting up the metrics store you can have a look
> at https://www.ovirt.org/develop/release-management/
> features/metrics/metrics-store/
>
> --
>
> SHIRLY RADCO
>
> BI SeNIOR SOFTWARE ENGINEER
>
> Red Hat Israel <https://www.redhat.com/>
> <https://red.ht/sig>
> TRIED. TESTED. TRUSTED. <https://redhat.com/trusted>
>
> On Fri, May 4, 2018 at 1:20 AM, Young, Matthew (Numerical Algorithms
> Group) wrote:
>
>> I’ve gotten past that error with “oc delete route/docker-registry” before
>> restart the playbook
>>
>>
>>
>> Matt
>>
>>
>>
>> *From:* Young, Matthew (Numerical Algorithms Group)
>> *Sent:* Thursday, May 3, 2018 4:02 PM
>> *To:* 'Shirly Radco'
>> *Cc:* users
>> *Subject:* RE: [ovirt-users] ansible failure during host install
>>
>>
>>
>> Ovirt-engine-metrics v1.1.3.4
>>
>>
>>
>> /etc/ovirt-engine-metrics/config.yml:
>>
>> ovirt_env_name: data-science-sandbox
>>
>> fluentd_elasticsearch_host: ovirt-metrics.datasci.bp.com
>>
>> ovirt_elasticsearch_mounted_storage_path: /data
>>
>>
>>
>> I have not gotten the openshift based metrics store running. It is
>> consistently timing out while performing “TASK [openshift_hosted :
>> Configure a passthrough route for docker-registry].”
>>
>> Failure summary:
>>
>> 1. Hosts:localhost
>>
>> Play: Create Hosted Resources - registry
>>
>> Task: Configure a passthrough route for docker-registry
>>
>> Message: {u'cmd': u'/usr/bin/oc replace -f
>> /tmp/docker-registry-DtGZqz --force -n default', u'returncode': 1,
>> u'results': {}, u'stderr': u'error: timed out waiting for the condition\n',
>> u'stdout': u'route "docker-registry" deleted\n'}
>>
>>
>>
>> Matt Young
>>
>>
>>
>> *From:* Shirly Radco
>> *Sent:* Thursday, April 12, 2018 4:04 PM
>> *To:* Young, Matthew (Numerical Algorithms Group)
>> *Cc:* users
>> *Subject:* Re: [ovirt-users] ansible failure during host install
>>
>>
>>
>> Hi,
>>
>>
>>
>> What version of ovirt-engine-metrics are you using?
>>
>>
>>
>> Did you already setup the OpenShift based metrics store to connect to?
>>
>>
>>
>> Have you configured /etc/ovirt-engine-metrics/config.yml?
>>
>>
>>
>> --
>>
>> SHIRLY RADCO
>>
>> BI SENIOR SOFTWARE ENGINEER
>>
>> Red Hat Israel
>>
>>
>> TRIED. TESTED. TRUSTED.
>>
>>
>>
>>
>>
>> On Thu, Apr 12, 2018, 21:35 Young, Matthew (Numerical Algorithms Group) <
>> matthew.you...@bp.com> wrote:
>>
>> Hello all,
>>
>>
>>
>> I have been working on adding a new host to an oVirt cluster. The
>> installation is failing in the ansible portion, specifically installing the
>> ansible elasticsearch ca cert. I have no experience with ansible. Does
>> anyone know what is causing this issue? Or how to create this ca cert?
>>
>>
>>
>> from ansible log
>>
>> …
>>
>> 2018-04-12 09:32:18,114 p=56616 u=ovirt | TASK
>> [oVirt.ovirt-fluentd/fluentd-setup : Create fluentd.conf]
>> *
>>
>> 2018-04-12 09:32:18,730 p=56616 u=ovirt | ok: [10.222.10.156] => {
>>
>> "changed": false,
>>
>> "checksum": "c9f88b60cd12ab8e3f3ffce1ae07654c89b06ef6",
>>
>> "gid": 0,
>>
>> "group": "root",
>>
>> "mode": "0640",
>>
>> "owner": "root",
>>
>> "path": "/etc/fluentd/fluent.conf",
>>
>> "secontext": "system_u:object_r:etc_t:s0",
&g
[ovirt-users] Re: data flow for statistics for hosts and vms
Hi Peter, The dwh views do not change, we support legacy views fro 3.6, so we recommend using DWH to get the statistics you want. It is possible to connect grafana directly with DWH if that interest you. Also, We have a new feature called "oVirt metrics store" that collectd many statistics using and logs using fluentd to a central Elasticsearch and Kibana. I can elaborate on that if you want. Best, -- SHIRLY RADCO BI SeNIOR SOFTWARE ENGINEER Red Hat Israel <https://www.redhat.com/> <https://red.ht/sig> TRIED. TESTED. TRUSTED. <https://redhat.com/trusted> On Tue, May 15, 2018 at 4:23 PM, Peter Hudec wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA512 > > Hi, > > I'm trying to understand the flow how the stats from the VM and HOSTS > are imported into the engine. > > On each host there is VDSM. Using the vsdm-client I'm able to get HOST > and VM stats > > vdsm-client Host getAllVmStats > vdsm-client Host getStats > > Are the hosts pushing the data to the engine or vice versa? On the > engine side there is java based vdsm-jsonrpc client so I guess the > data are pulled from the hosts to the engine database. > > Yes. Engine pulls the stats from the hosts every 15 seconds. > And of course the question is which component on engine side is > getting/requesting the data. > > I'm trying to get the stat less painless as query the API. > Maybe the engine/dwh database could help but the scheme could change > between releases, isn't it. or the engine DB. > > regards > Peter > > - -- > *Peter Hudec* > Infraštruktúrny architekt > phu...@cnc.sk <mailto:phu...@cnc.sk> > > *CNC, a.s.* > Borská 6, 841 04 Bratislava > Recepcia: +421 2 35 000 100 > > Mobil:+421 905 997 203 > *www.cnc.sk* <http:///www.cnc.sk> > > -BEGIN PGP SIGNATURE- > > iQIzBAEBCgAdFiEEqSUbhuEwhryifNeVQnvVWOJ35BAFAlr63zYACgkQQnvVWOJ3 > 5BC1BxAApSg29lv1KohiVeJNsFdF4i77e2H77drLe9Ffq1kg/+VESh6+ggeZIH1U > W5e06PJeifoZbtWL2enaJsml9JZM/3kvqU5TC93sR8chvhfRo3GXS50tWCEe5b0R > UPdpjgyYipN+i3Xibl/YxHMu9fwpFIH+VY+JWn70Dz5pjvgwn71ogCcRUA6Itvom > 700Pwv4yV31hWyE6qXiWOth0Rfey3+QkEXtNhRrEOHeAzpNABS5Zixjocr9c5xhz > AdLkUAGVvEQEYy/Nzyv8A8KRSY1z63Ijyv5hgQIpGkKfbXhRYrotY6EeqdJ6PYsF > tQvkjjT+kJ5SBYClK/et9X4y2ZMe+4YX7lrsZnk8V/Oj3YYw2y1XlvXcrt0pZlHA > G9QIhcn/chtBTslGOW0t4B603YRykausunc9XXq1IGKNyLHb/lrDiDh+x2dCg5vT > sGJE/gQffSNSwk5oFBlG2U9aOgWvZ8m3nVCDdGo+1a9fc/KR8toQi9axsiIMVYb/ > dzbDmaYlXbKNwWdVirftTetxuwn44j2Kgv4b048ZmGwTvwc79UuoS8H9hv9LlBM6 > 7E7iqaGfKbExg0/EMZurd90P62zn8nIGnYEJUrxVU3aJ4E2gWflfSelYMymNtE+u > aZAMxvK6gILQP2n45AVkKOTacQwX07QCzlvJ2sL4gNzQQ+UL52c= > =RNAH > -END PGP SIGNATURE- > ___ > Users mailing list -- users@ovirt.org > To unsubscribe send an email to users-le...@ovirt.org > ___ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-le...@ovirt.org
[ovirt-users] Re: oVirt reports using Grafana
Hi, I just wanted to update that I will off course retest the documentation and update it as soon as I can. Thank you for engaging and pointing out these issues. I want it working for you as fast and easiest as possible. Best regards, -- SHIRLY RADCO BI SENIOR SOFTWARE ENGINEER Red Hat Israel TRIED. TESTED. TRUSTED. On Fri, May 18, 2018, 09:22 Karli Sjöberg wrote: > On Thu, 2018-05-17 at 10:37 -0700, Vincent Royer wrote: > > These are the same issues I ran into. I did get it working, look up > > my post history and you'll find some solutions to the errors > > Big thanks, now I understand what the problem was! > > But I must say, after reading that thread, I´m actually more interested > in setting up the metrics store as it seems you get way more data out > of it without having to access the database directly. The point being, > the less manual stuff you do to alter the original setup in the engine, > the less issues you are going to have later on, with upgrades and such. > > /K > > > > > On Thu, May 17, 2018, 1:01 AM Sandro Bonazzola, > > wrote: > > > Shirly, can you please update the blog post pointing to an updated > > > documentation page? > > > > > > 2018-05-17 9:35 GMT+02:00 Karli Sjöberg : > > > > Heya! > > > > > > > > I've been whishing for reports in oVirt ever since the old > > > > 'Jasper > > > > Reports' was removed. For an Enterprise, having pretty graphs to > > > > look > > > > at is a must. > > > > > > > > Searching the subject, I've found this[*] and have managed to get > > > > it > > > > installed OK but having issues trying to follow the guide setting > > > > it > > > > up. > > > > > > > > First of all, I think the guide should have at least mentioned > > > > that > > > > 'pg_hba.conf' needs to be edited for the read only user to be > > > > able to > > > > connect to the database, I scratched my head around that for a > > > > while > > > > before I got it. > > > > > > > > When I first type in the query example, I got syntax errors: > > > > 'pq: syntax error at or near "$"'. I continued anyways since I > > > > figured > > > > it would be solved at a later point, which turned out to be true, > > > > since > > > > the next step is to use the "Templating feature" to add > > > > variables. > > > > > > > > Unfortunately this doesn't go so well, even though I followed the > > > > instructions very carefully. After hitting save on the first > > > > variable I > > > > am rewarded with the error message: > > > > 'Template variables could not be initialized: pq: column "en_us" > > > > does > > > > not exist.' > > > > > > > > Are the queries stated in the guide still correct? This is for > > > > 'user_locale': > > > > "SELECT DISTINCT language_code from enum_translator" > > > > > > > > [*]:https://www.ovirt.org/blog/2018/01/ovirt-report-using-grafana > > > > / > > > > > > > > TIA > > > > /K > > > > ___ > > > > Users mailing list -- users@ovirt.org > > > > To unsubscribe send an email to users-le...@ovirt.org > > > > > > > > > ___ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-le...@ovirt.org
[ovirt-users] Re: oVirt reports using Grafana
-- SHIRLY RADCO BI SENIOR SOFTWARE ENGINEER Red Hat Israel TRIED. TESTED. TRUSTED. On Fri, May 18, 2018, 16:02 Vincent Royer wrote: > Yes I agree, because the database contains so many version specific > pointers, all of them will stop working when you upgrade. So that's no good! > Not sure what you mean. The DWH views are stable and we currently support 3.6 and above views. It means you do not have to update the version of the view. Also DWH is pretty stable. So you should not expect many changes. > If you ever get something decent working with Grafana, I'd be very > interested. I'm still not happy with the integration with the engine > history database, I was never really able to get predictable output from > it, and spent way too many hours messing around with it. > Ill try and add a few more meaningful examples if that will help. Is the problem is how to join the tables together? > > On Thu, May 17, 2018 at 11:21 PM Karli Sjöberg > wrote: > >> On Thu, 2018-05-17 at 10:37 -0700, Vincent Royer wrote: >> > These are the same issues I ran into. I did get it working, look up >> > my post history and you'll find some solutions to the errors >> >> Big thanks, now I understand what the problem was! >> >> But I must say, after reading that thread, I´m actually more interested >> in setting up the metrics store as it seems you get way more data out >> of it without having to access the database directly. The point being, >> the less manual stuff you do to alter the original setup in the engine, >> the less issues you are going to have later on, with upgrades and such. >> >> /K >> >> > >> > On Thu, May 17, 2018, 1:01 AM Sandro Bonazzola, >> > wrote: >> > > Shirly, can you please update the blog post pointing to an updated >> > > documentation page? >> > > >> > > 2018-05-17 9:35 GMT+02:00 Karli Sjöberg : >> > > > Heya! >> > > > >> > > > I've been whishing for reports in oVirt ever since the old >> > > > 'Jasper >> > > > Reports' was removed. For an Enterprise, having pretty graphs to >> > > > look >> > > > at is a must. >> > > > >> > > > Searching the subject, I've found this[*] and have managed to get >> > > > it >> > > > installed OK but having issues trying to follow the guide setting >> > > > it >> > > > up. >> > > > >> > > > First of all, I think the guide should have at least mentioned >> > > > that >> > > > 'pg_hba.conf' needs to be edited for the read only user to be >> > > > able to >> > > > connect to the database, I scratched my head around that for a >> > > > while >> > > > before I got it. >> > > > >> > > > When I first type in the query example, I got syntax errors: >> > > > 'pq: syntax error at or near "$"'. I continued anyways since I >> > > > figured >> > > > it would be solved at a later point, which turned out to be true, >> > > > since >> > > > the next step is to use the "Templating feature" to add >> > > > variables. >> > > > >> > > > Unfortunately this doesn't go so well, even though I followed the >> > > > instructions very carefully. After hitting save on the first >> > > > variable I >> > > > am rewarded with the error message: >> > > > 'Template variables could not be initialized: pq: column "en_us" >> > > > does >> > > > not exist.' >> > > > >> > > > Are the queries stated in the guide still correct? This is for >> > > > 'user_locale': >> > > > "SELECT DISTINCT language_code from enum_translator" >> > > > >> > > > [*]:https://www.ovirt.org/blog/2018/01/ovirt-report-using-grafana >> > > > / >> > > > >> > > > TIA >> > > > /K >> > > > ___ >> > > > Users mailing list -- users@ovirt.org >> > > > To unsubscribe send an email to users-le...@ovirt.org >> > > >> > > >> > > > > ___ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-le...@ovirt.org
[ovirt-users] Re: oVirt 4.1 ETL service sampling has encounterd an error
Hi, This was fixed in https://bugzilla.redhat.com/show_bug.cgi?id=1541924 in version 4.2.2. I believe you can update manually the history_id field in tables - vm_interface_daily_history, vm_interface_hourly_history, vm_interface_samples_history from integer to bigint and it should fix the issue, but I did not test on 4.1. like in: https://gerrit.ovirt.org/#/c/87139/4/packaging/dbscripts/upgrade/04_02_0020__updated_vm_interface_history_id_to_bigint.sql Best, -- SHIRLY RADCO BI SeNIOR SOFTWARE ENGINEER Red Hat Israel <https://www.redhat.com/> <https://red.ht/sig> TRIED. TESTED. TRUSTED. <https://redhat.com/trusted> On Tue, Jun 5, 2018 at 2:28 PM, Staniforth, Paul < p.stanifo...@leedsbeckett.ac.uk> wrote: > Hello, > > > our oVirt 4.1 system has had a DWH error since around 4am this morning, > > > It comes up with the error > > > ETL service sampling has encountered an error. Please consult the service > log for more details > > > in the ovirt-engine-dwh.log > > > 2018-06-05 > 12:00:18|QXiOTi|gAp8Q4|Cz1F21|OVIRT_ENGINE_DWH|SampleRunJobs|Default|6|Java > Exception|tRunJob_5|java.lang.RuntimeException:Child job running failed|1 > Exception in component tRunJob_1 > java.lang.RuntimeException: Child job running failed > at ovirt_engine_dwh.sampletimekeepingjob_4_1. > SampleTimeKeepingJob.tRunJob_1Process(SampleTimeKeepingJob.java:6067) > at ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJob. > tJDBCInput_2Process(SampleTimeKeepingJob.java:5809) > at ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJob. > tJDBCConnection_1Process(SampleTimeKeepingJob.java:) > at ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJob. > tJDBCConnection_2Process(SampleTimeKeepingJob.java:4319) > at ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJob. > tRowGenerator_2Process(SampleTimeKeepingJob.java:4188) > at ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJob. > tJDBCInput_3Process(SampleTimeKeepingJob.java:3593) > at ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJob. > tJDBCInput_5Process(SampleTimeKeepingJob.java:2977) > at ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJob. > tJDBCInput_4Process(SampleTimeKeepingJob.java:2295) > at ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJob. > tJDBCConnection_3Process(SampleTimeKeepingJob.java:1649) > at ovirt_engine_dwh.sampletimekeepingjob_4_1. > SampleTimeKeepingJob$2.run(SampleTimeKeepingJob.java:11363) > > > and in the postgres log there is > > > ERROR: integer out of range > STATEMENT: INSERT INTO vm_interface_samples_history (history_datetime,vm_ > interface_id,receive_rate_percent,transmit_rate_percent, > vm_interface_configuration_version,received_total_byte,transmitted_total_byte) > VALUES ($1,$2,$3,$4,$5,$6,$7) > ERROR: current transaction is aborted, commands ignored until end of > transaction block > > > Thanks, > > Paul S. > To view the terms under which this email is distributed, please go to:- > http://disclaimer.leedsbeckett.ac.uk/disclaimer/disclaimer.html > > > ___ > 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/C6MLPVLJDKQ7AQLSPJ7Q3QVDAAFDZWUA/ > > ___ 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/RJDTXECMC6NWYMK7LWGL3CV4T2QGKKDU/
[ovirt-users] Re: oVirt 4.1 ETL service sampling has encounterd an error
In that case there is a workaround but I would recommend upgrading to 4.2
if you can.
I did not test the workaround:
You can add to /usr/share/ovirt-engine-dwh/packaging/dbscripts/upgrade/
a file called
04_01_0025__updated_vm_interface_history_id_to_bigint.sql
with the same content as in my patch:
_
-- Update vm_interface_* statistics table history_id to bigint
SELECT fn_db_change_column_type('vm_interface_daily_history', 'history_id',
'integer', 'bigint');
SELECT fn_db_change_column_type('vm_interface_hourly_history',
'history_id', 'integer', 'bigint');
SELECT fn_db_change_column_type('vm_interface_samples_history',
'history_id', 'integer', 'bigint');
_____
and run engine-setup
engine-setup drops all views, makes the updates to the db and recreates the
views.
--
SHIRLY RADCO
BI SeNIOR SOFTWARE ENGINEER
Red Hat Israel <https://www.redhat.com/>
<https://red.ht/sig>
TRIED. TESTED. TRUSTED. <https://redhat.com/trusted>
On Wed, Jun 6, 2018 at 1:04 PM, Staniforth, Paul <
p.stanifo...@leedsbeckett.ac.uk> wrote:
> Sorry was looking at the engine database, rather than
> ovirt_engine_history database.
>
>
> When running
>
>
> SELECT fn_db_change_column_type('vm_interface_daily_history',
> 'history_id', 'integer', 'bigint');
>
>
> I get
>
>
>
> ERROR: cannot alter type of a column used by a view or rule
> DETAIL: rule _RETURN on view v4_1_statistics_vms_
> interfaces_resources_usage_daily depends on column "history_id"
> CONTEXT: SQL statement "ALTER TABLE vm_interface_daily_history ALTER
> COLUMN history_id TYPE bigint"
> PL/pgSQL function fn_db_change_column_type(character varying,character
> varying,character varying,character varying) line 9 at EXECUTE statement
>
>
> Thanks,
>
> Paul S.
> --
> *From:* Staniforth, Paul
> *Sent:* 06 June 2018 09:57
> *To:* Shirly Radco
>
> *Cc:* users@ovirt.org
> *Subject:* Re: [ovirt-users] oVirt 4.1 ETL service sampling has
> encounterd an error
>
>
> Thanks Shirly,
>
> unfortunately Microsoft sent your reply to my Junk
> Email folder so I have only noticed it today.
>
> Is there any instructions on how to run the script? I can't find any
> tables or views with the vm_interface_daily_history, etc columns.
>
>
> I'm not a database expert.
>
>
> Regards,
>
>Paul S.
>
>
> --
> *From:* Shirly Radco
> *Sent:* 05 June 2018 14:52
> *To:* Staniforth, Paul
> *Cc:* users@ovirt.org
> *Subject:* Re: [ovirt-users] oVirt 4.1 ETL service sampling has
> encounterd an error
>
> Hi,
>
> This was fixed in https://bugzilla.redhat.com/show_bug.cgi?id=1541924
> in version 4.2.2.
>
>
> I believe you can update manually the history_id field in tables -
> vm_interface_daily_history, vm_interface_hourly_history,
> vm_interface_samples_history
> from integer to bigint and it should fix the issue, but I did not test on
> 4.1.
>
> like in:
> https://gerrit.ovirt.org/#/c/87139/4/packaging/dbscripts/
> upgrade/04_02_0020__updated_vm_interface_history_id_to_bigint.sql
>
>
> Best,
>
> --
>
> SHIRLY RADCO
>
> BI SeNIOR SOFTWARE ENGINEER
>
> Red Hat Israel <https://www.redhat.com/>
> <https://red.ht/sig>
> TRIED. TESTED. TRUSTED. <https://redhat.com/trusted>
>
> On Tue, Jun 5, 2018 at 2:28 PM, Staniforth, Paul <
> p.stanifo...@leedsbeckett.ac.uk> wrote:
>
>> Hello,
>>
>>
>> our oVirt 4.1 system has had a DWH error since around 4am this morning,
>>
>>
>> It comes up with the error
>>
>>
>> ETL service sampling has encountered an error. Please consult the service
>> log for more details
>>
>>
>> in the ovirt-engine-dwh.log
>>
>>
>> 2018-06-05
>> 12:00:18|QXiOTi|gAp8Q4|Cz1F21|OVIRT_ENGINE_DWH|SampleRunJobs|Default|6|Java
>> Exception|tRunJob_5|java.lang.RuntimeException:Child job running failed|1
>> Exception in component tRunJob_1
>> java.lang.RuntimeException: Child job running failed
>> at ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJ
>> ob.tRunJob_1Process(SampleTimeKeepingJob.java:6067)
>> at ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJ
>> ob.tJDBCInput_2Process(SampleTimeKeepingJob.java:5809)
>> at ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJ
>> ob.tJDBCConnection_1Process(SampleTimeKeepingJob.java:)
>> at ovirt_
[ovirt-users] oVirt Metrics
Dear users, I would love to get some feedback if someone has tried to install and use the oVirt metrics store, released in 4.2, for collecting metrics and logs, based on Elasticsearch, Kibana, Collectd and Fluentd on top of OpenShift. https://www.ovirt.org/develop/release-management/features/metrics/metrics-store/ How did the installation go? Are you actively using it? And any other feedback would be much appreciated. Best regards, -- SHIRLY RADCO BI SeNIOR SOFTWARE ENGINEER Red Hat Israel <https://www.redhat.com/> <https://red.ht/sig> TRIED. TESTED. TRUSTED. <https://redhat.com/trusted> ___ 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/3G2M3Q35UQZLOHDRAEBMX2INPDAQCOHO/
[ovirt-users] Re: oVirt Metrics
Hi, No need to install agents in the vms. Collectd virt plugin reports the statistics about the vms from the host. Best regards, -- SHIRLY RADCO BI SeNIOR SOFTWARE ENGINEER Red Hat Israel <https://www.redhat.com/> <https://red.ht/sig> TRIED. TESTED. TRUSTED. <https://redhat.com/trusted> On Mon, Jun 11, 2018 at 3:26 PM, Marcelo Leandro wrote: > Hello, > Good morning Shirley. > I am have one doubt , for collecting metrics need install agents in vms?. > > Very thanks. > > Marcelo Leandro > ___ 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/64PYX3BLICDZITRVOF5ROY2RAD3WHTS4/
[ovirt-users] Re: oVirt Metrics
There is an option to log to the OpenShift admin portal. It is located at https://:8443 and same user and password. -- SHIRLY RADCO BI SeNIOR SOFTWARE ENGINEER Red Hat Israel <https://www.redhat.com/> <https://red.ht/sig> TRIED. TESTED. TRUSTED. <https://redhat.com/trusted> On Mon, Jun 11, 2018 at 9:13 PM, Karli Sjöberg wrote: > > > On Jun 11, 2018 19:00, Yaniv Kaul wrote: > > > > On Mon, Jun 11, 2018, 6:59 PM Karli Sjöberg wrote: > > > > On Jun 11, 2018 13:59, Shirly Radco wrote: > > Dear users, > > I would love to get some feedback if someone has tried to install and use > the oVirt metrics store, released in 4.2, for collecting metrics and logs, > based on Elasticsearch, Kibana, Collectd and Fluentd on top of OpenShift. > https://www.ovirt.org/develop/release-management/features/ > metrics/metrics-store/ > > How did the installation go? Are you actively using it? > And any other feedback would be much appreciated. > > Best regards, > > -- > > SHIRLY RADCO > > BI SeNIOR SOFTWARE ENGINEER > > Red Hat Israel <https://www.redhat.com/> > <https://red.ht/sig> > TRIED. TESTED. TRUSTED. <https://redhat.com/trusted> > ___ > 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/3G2M3Q35UQZLOHDRAEBMX2INPDAQCOHO/ > > > I have, and while I can say that it works, it was far from easy! I can't > remember all of the gotchas I had to go through but most of them stemmed > from the fact that I tested it all on a three node oVirt HCI cluster that > was actually VM's with nested virtualization, which meant fairly limited > resources but eventually got it working. > > Being completely new to OpenShift, a guide that needs more work is the > single sign on from oVirt to OS. The instructions are way too unclear for > me, and wrapping your head around how the login and permissions system > works in OS took a while, to create an equal 'admin' account to log in with. > > Second, isn't OS just an above layer of kubernetes under it, or is that a > misunderstanding on my part? If it is though, where is the administration > page for Kubernetes in all of that? I'm thinking in the sense of how you > can add more nodes to continue building a larger cluster for containers. > > > OpenShift is much more than just Kubernetes, but specifically this > instance should be used solely for metrics and logging and is therefore > specifically installed as an all-in-one installation. > Y. > > > OK, yeah, for sure! But is there no Kubernetes console in this all-in-one > installation? > > /K > > > > But once everything was setup and able to log in to the Kibana interface > and loading up the dashboards you've made, I was really impressed with how > much data you got visualized for free. Thumbs up! > > /K > ___ > 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/CWMPCP3ZRT2CR56IVNG6JS7EMNVFSN3W/ > > > ___ 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/ZQHVJ2BPTY7I5QP5ZEII3Y5XHRSE7Y2F/
[ovirt-users] Re: oVirt Metrics
Hi Rich,
Are you families with this OpenShift installation issue?
Best,
--
SHIRLY RADCO
BI SeNIOR SOFTWARE ENGINEER
Red Hat Israel <https://www.redhat.com/>
<https://red.ht/sig>
TRIED. TESTED. TRUSTED. <https://redhat.com/trusted>
On Mon, Jun 11, 2018 at 4:20 PM, Carlos Rodrigues wrote:
> Hi,
>
> i'm trying to install oVirt Metrics following the installation guide (h
> ttps://www.ovirt.org/develop/release-
> management/features/metrics/metrics-store-installation/) but i have
> some issues running deploy cluster from here https://www.ovirt.org/deve
> lop/release-management/features/metrics/setting-up-viaq-logging/
>
> cd /usr/share/ansible/openshift-ansible
> # (or wherever you cloned the git repo if using git)
> ANSIBLE_LOG_PATH=/tmp/ansible.log ansible-playbook -vvv -e
> @/root/vars.yaml -i /root/ansible-inventory-origin-39-aio
> playbooks/deploy_cluster.yml
>
> I fails on Web console installation:
>
> 2018-06-06 19:48:24,020 p=17586 u=root | [DEPRECATION WARNING]: Using
> tests as filters is deprecated. Instead of using
> `result|version_compare` instead use `result is version_compare`. This
> feature
> will be removed in version 2.9.
> Deprecation warnings can be disabled by setting
> deprecation_warnings=False in ansible.cfg.
> 2018-06-06 19:48:24,135 p=17586 u=root | Using module file
> /usr/lib/python2.7/site-packages/ansible/modules/commands/command.py
> 2018-06-06 19:48:27,093 p=17586 u=root | fatal: [localhost]: FAILED!
> => {
> "changed": true,
> "cmd": [
> "oc",
> "logs",
> "deployment/webconsole",
> "--tail=50",
> "--config=/tmp/console-ansible-C8XDuW/admin.kubeconfig",
> "-n",
> "openshift-web-console"
> ],
> "delta": "0:00:01.567694",
> "end": "2018-06-06 19:48:26.706407",
> "invocation": {
> "module_args": {
> "_raw_params": "oc logs deployment/webconsole --tail=50 --
> config=/tmp/console-ansible-C8XDuW/admin.kubeconfig -n openshift-web-
> console",
> "_uses_shell": false,
> "chdir": null,
> "creates": null,
> "executable": null,
> "removes": null,
> "stdin": null,
> "warn": true
> }
>
> },
> "msg": "non-zero return code",
> "rc": 1,
> "start": "2018-06-06 19:48:25.138713",
> "stderr": "Error from server (BadRequest): container \"webconsole\"
> in pod \"webconsole-84466b9d97-s4x28\" is waiting to start:
> ContainerCreating",
> "stderr_lines": [
> "Error from server (BadRequest): container \"webconsole\" in
> pod \"webconsole-84466b9d97-s4x28\" is waiting to start:
> ContainerCreating"
> ],
> "stdout": "",
> "stdout_lines": []
> }
> 2018-06-06 19:48:27,097 p=17586 u=root | ...ignoring
>
> Regards,
> Carlos Rodrigues
>
> On Mon, 2018-06-11 at 13:30 +0300, Shirly Radco wrote:
> > Dear users,
> >
> > I would love to get some feedback if someone has tried to install and
> > use the oVirt metrics store, released in 4.2, for collecting metrics
> > and logs, based on Elasticsearch, Kibana, Collectd and Fluentd on top
> > of OpenShift.
> > https://www.ovirt.org/develop/release-management/features/metrics/met
> > rics-store/
> >
> > How did the installation go? Are you actively using it?
> > And any other feedback would be much appreciated.
> >
> > Best regards,
> > --
> > SHIRLY RADCO
> > BI SENIOR SOFTWARE ENGINEER
> > Red Hat Israel
> > TRIED. TESTED. TRUSTED.
> > ___
> > 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/communit
> > y-guidelines/
> > List Archives: https://lists.ovirt.org/archives/list/users@ovirt.org/
> > message/3G2M3Q35UQZLOHDRAEBMX2INPDAQCOHO/
> --
> Carlos Rodrigues
>
> Engenheiro de Software Sénior
>
> Eurotux Informática, S.A. | www.eurotux.com
> (t) +351 253 680 300 (m) +351 911 926 110
>
___
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/BVOYKXXR7MYSD5V5HLREZDLXFEBS7OHR/
[ovirt-users] Re: oVirt Metrics
--
SHIRLY RADCO
BI SeNIOR SOFTWARE ENGINEER
Red Hat Israel <https://www.redhat.com/>
<https://red.ht/sig>
TRIED. TESTED. TRUSTED. <https://redhat.com/trusted>
On Tue, Jun 12, 2018 at 11:43 AM, Shirly Radco wrote:
> Hi Rich,
>
> Are you families with this OpenShift installation issue?
>
familiar*
>
> Best,
>
> --
>
> SHIRLY RADCO
>
> BI SeNIOR SOFTWARE ENGINEER
>
> Red Hat Israel <https://www.redhat.com/>
> <https://red.ht/sig>
> TRIED. TESTED. TRUSTED. <https://redhat.com/trusted>
>
> On Mon, Jun 11, 2018 at 4:20 PM, Carlos Rodrigues
> wrote:
>
>> Hi,
>>
>> i'm trying to install oVirt Metrics following the installation guide (h
>> ttps://www.ovirt.org/develop/release-
>> management/features/metrics/metrics-store-installation/) but i have
>> some issues running deploy cluster from here https://www.ovirt.org/deve
>> lop/release-management/features/metrics/setting-up-viaq-logging/
>> <https://www.ovirt.org/develop/release-management/features/metrics/setting-up-viaq-logging/>
>>
>> cd /usr/share/ansible/openshift-ansible
>> # (or wherever you cloned the git repo if using git)
>> ANSIBLE_LOG_PATH=/tmp/ansible.log ansible-playbook -vvv -e
>> @/root/vars.yaml -i /root/ansible-inventory-origin-39-aio
>> playbooks/deploy_cluster.yml
>>
>> I fails on Web console installation:
>>
>> 2018-06-06 19:48:24,020 p=17586 u=root | [DEPRECATION WARNING]: Using
>> tests as filters is deprecated. Instead of using
>> `result|version_compare` instead use `result is version_compare`. This
>> feature
>> will be removed in version 2.9.
>> Deprecation warnings can be disabled by setting
>> deprecation_warnings=False in ansible.cfg.
>> 2018-06-06 19:48:24,135 p=17586 u=root | Using module file
>> /usr/lib/python2.7/site-packages/ansible/modules/commands/command.py
>> 2018-06-06 19:48:27,093 p=17586 u=root | fatal: [localhost]: FAILED!
>> => {
>> "changed": true,
>> "cmd": [
>> "oc",
>> "logs",
>> "deployment/webconsole",
>> "--tail=50",
>> "--config=/tmp/console-ansible-C8XDuW/admin.kubeconfig",
>> "-n",
>> "openshift-web-console"
>> ],
>> "delta": "0:00:01.567694",
>> "end": "2018-06-06 19:48:26.706407",
>> "invocation": {
>> "module_args": {
>> "_raw_params": "oc logs deployment/webconsole --tail=50 --
>> config=/tmp/console-ansible-C8XDuW/admin.kubeconfig -n openshift-web-
>> console",
>> "_uses_shell": false,
>> "chdir": null,
>> "creates": null,
>> "executable": null,
>> "removes": null,
>> "stdin": null,
>> "warn": true
>> }
>>
>> },
>> "msg": "non-zero return code",
>> "rc": 1,
>> "start": "2018-06-06 19:48:25.138713",
>> "stderr": "Error from server (BadRequest): container \"webconsole\"
>> in pod \"webconsole-84466b9d97-s4x28\" is waiting to start:
>> ContainerCreating",
>> "stderr_lines": [
>> "Error from server (BadRequest): container \"webconsole\" in
>> pod \"webconsole-84466b9d97-s4x28\" is waiting to start:
>> ContainerCreating"
>> ],
>> "stdout": "",
>> "stdout_lines": []
>> }
>> 2018-06-06 19:48:27,097 p=17586 u=root | ...ignoring
>>
>> Regards,
>> Carlos Rodrigues
>>
>> On Mon, 2018-06-11 at 13:30 +0300, Shirly Radco wrote:
>> > Dear users,
>> >
>> > I would love to get some feedback if someone has tried to install and
>> > use the oVirt metrics store, released in 4.2, for collecting metrics
>> > and logs, based on Elasticsearch, Kibana, Collectd and Fluentd on top
>> > of OpenShift.
>> > https://www.ovirt.org/develop/release-management/features/metrics/met
>> > rics-store/
>> >
>> > How did the installation go? Are you actively using it?
>> > And any other feedback would be much appreciated.
>> >
>> > Best regards,
>> > --
>> > SHIRLY RADCO
>> > BI SENIOR SOFTWARE ENGINEER
>> > Red Hat Israel
>> > TRIED. TESTED. TRUSTED.
>> > ___
>> > 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/communit
>> > y-guidelines/
>> > List Archives: https://lists.ovirt.org/archives/list/users@ovirt.org/
>> > message/3G2M3Q35UQZLOHDRAEBMX2INPDAQCOHO/
>> --
>> Carlos Rodrigues
>>
>> Engenheiro de Software Sénior
>>
>> Eurotux Informática, S.A. | www.eurotux.com
>> (t) +351 253 680 300 (m) +351 911 926 110
>>
>
>
___
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/6JEGRG4OVFG4TLMDHQFTWUPY5YXE4EYW/
[ovirt-users] Re: oVirt Metrics
It includes the metrics for the vms using the collectd virt plugin. CPU, Memory, disk IO etc. Best regards, -- SHIRLY RADCO BI SeNIOR SOFTWARE ENGINEER Red Hat Israel <https://www.redhat.com/> <https://red.ht/sig> TRIED. TESTED. TRUSTED. <https://redhat.com/trusted> On Thu, Jun 14, 2018 at 12:53 PM, maoz zadok wrote: > Does it provides metrics for the guest? like CPU, Memory, disk IO etc? > > On Mon, Jun 11, 2018 at 2:57 PM Shirly Radco wrote: > >> Dear users, >> >> I would love to get some feedback if someone has tried to install and use >> the oVirt metrics store, released in 4.2, for collecting metrics and logs, >> based on Elasticsearch, Kibana, Collectd and Fluentd on top of OpenShift. >> https://www.ovirt.org/develop/release-management/features/ >> metrics/metrics-store/ >> >> How did the installation go? Are you actively using it? >> And any other feedback would be much appreciated. >> >> Best regards, >> >> -- >> >> SHIRLY RADCO >> >> BI SeNIOR SOFTWARE ENGINEER >> >> Red Hat Israel <https://www.redhat.com/> >> <https://red.ht/sig> >> TRIED. TESTED. TRUSTED. <https://redhat.com/trusted> >> ___ >> 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/3G2M3Q35UQZLOHDRAEBMX2INPDAQCOHO/ >> > ___ 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/PG5DKZEH2INKKHA52EFWNB6UK7VLASDB/
[ovirt-users] Re: metrics
Hi, I see there is an OpenShift bug about this issue https://bugzilla.redhat.com/show_bug.cgi?id=1589629 "Bug 1589629 - Install logging/metrics failed at TASK [Validate openshift_node_groups and openshift_node_group_name]" I see there is a workaround https://bugzilla.redhat.com/show_bug.cgi?id=1589629#c2 to add to ansible-inventory-origin-39-aio that is in your metrics store machine at the root directory skip_sanity_checks=true Are you experiencing this in 3.9 ? The bug is open on 3.10. Bset, -- SHIRLY RADCO BI SeNIOR SOFTWARE ENGINEER Red Hat Israel <https://www.redhat.com/> <https://red.ht/sig> TRIED. TESTED. TRUSTED. <https://redhat.com/trusted> On Thu, Jun 21, 2018 at 7:15 PM, wrote: > Hi, > > I'm trying to configure oVirt metrics but when i run > > # ANSIBLE_LOG_PATH=/tmp/ansible.log ansible-playbook -vvv -e > @/root/vars.yaml -i /root/ansible-inventory-origin-39-aio > playbooks/deploy_cluster.yml > > i always get this error: > > Failure summary: > > > 1. Hosts: localhost > Play: Verify Requirements > Task: Validate openshift_node_groups and openshift_node_group_name > Message: last_checked_host: localhost, last_checked_var: > openshift_node_group_name;openshift_node_group_name must be defined for > all nodes > > > What am I missing here? > > Thanks > > > > -- > -- > Jose Ferradeira > http://www.logicworks.pt > > ___ > 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/QQMEHPYZUWZSZURSBLCSL4PLDW374K34/ > > ___ 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/QDKVOKGW5YWH6OIYYCB2FU7VTN5QI6KD/
[ovirt-users] Re: Antwort: Re: vacuumdb: could not connect to database ovirt_engine_history
Hi, Please share your history_configuration table content in ovirt_engine_history db: SELECT * FROM history_configuration; the date and time you run this query and the ovirt_engine_dwh.log -- SHIRLY RADCO BI SeNIOR SOFTWARE ENGINEER Red Hat Israel <https://www.redhat.com/> <https://red.ht/sig> TRIED. TESTED. TRUSTED. <https://redhat.com/trusted> On Fri, Jun 29, 2018 at 9:06 AM, wrote: > Hi Roy, well db is alive : > > > su - postgres -c 'scl enable rh-postgresql95 -- psql ovirt_engine_history' > psql (9.5.9) > Type "help" for help. > > ovirt_engine_history=# \dt > List of relations > Schema | Name| Type |Owner > +---+---+--- > --- > public | calendar | table | ovirt_engine_history > public | cluster_configuration | table | ovirt_engine_history > public | datacenter_configuration | table | ovirt_engine_history > public | datacenter_storage_domain_map | table | ovirt_engine_history > public | enum_translator | table | ovirt_engine_history > public | history_configuration | table | ovirt_engine_history > public | host_configuration| table | ovirt_engine_history > public | host_daily_history| table | ovirt_engine_history > public | host_hourly_history | table | ovirt_engine_history > public | host_interface_configuration | table | ovirt_engine_history > public | host_interface_daily_history | table | ovirt_engine_history > public | host_interface_hourly_history | table | ovirt_engine_history > public | host_interface_samples_history| table | ovirt_engine_history > public | host_samples_history | table | ovirt_engine_history > public | schema_version| table | ovirt_engine_history > public | statistics_vms_users_usage_daily | table | ovirt_engine_history > public | statistics_vms_users_usage_hourly | table | ovirt_engine_history > public | storage_domain_configuration | table | ovirt_engine_history > public | storage_domain_daily_history | table | ovirt_engine_history > public | storage_domain_hourly_history | table | ovirt_engine_history > public | storage_domain_samples_history| table | ovirt_engine_history > public | tag_details | table | ovirt_engine_history > public | tag_relations_history | table | ovirt_engine_history > public | users_details_history | table | ovirt_engine_history > public | vm_configuration | table | ovirt_engine_history > public | vm_daily_history | table | ovirt_engine_history > public | vm_device_history | table | ovirt_engine_history > public | vm_disk_configuration | table | ovirt_engine_history > public | vm_disk_daily_history | table | ovirt_engine_history > public | vm_disk_hourly_history| table | ovirt_engine_history > public | vm_disk_samples_history | table | ovirt_engine_history > public | vm_disks_usage_daily_history | table | ovirt_engine_history > public | vm_disks_usage_hourly_history | table | ovirt_engine_history > public | vm_disks_usage_samples_history| table | ovirt_engine_history > public | vm_hourly_history | table | ovirt_engine_history > public | vm_interface_configuration| table | ovirt_engine_history > public | vm_interface_daily_history| table | ovirt_engine_history > public | vm_interface_hourly_history | table | ovirt_engine_history > public | vm_interface_samples_history | table | ovirt_engine_history > public | vm_samples_history| table | ovirt_engine_history > (40 rows) > > ovirt_engine_history=# > > > > > > > Von:"Roy Golan" > An:emanuel.santosvar...@mahle.com, > Kopie:users@ovirt.org > Datum:28.06.2018 17:37 > Betreff:Re: [ovirt-users] vacuumdb: could not connect to database > ovirt_engine_history > -- > > > > > > On Thu, 28 Jun 2018 at 18:06 <*emanuel.santosvar...@mahle.com* > > wrote: > ..trying to update from 4.2.3 to 4.2.4 engine-setup fails with the > following error: > > --snip > 2018-06-28 16:26:45,507+0200 DEBUG otopi.plugins.ovirt_engine_ > setup.ovirt_engine_dwh.db.vacuum plugin.execute:926 execute-output: > ['/usr/share/ovirt-engine-dwh/bin/dwh-vacuum.sh', '-f', '-v'] stderr: > vacuumdb: could not connect to database ovirt_engine_history: FATAL: > password a
[ovirt-users] Re: Antwort: Re: vacuumdb: could not connect to database ovirt_engine_history
Hi Didi, Can you please have a look? Thanks, -- SHIRLY RADCO BI SeNIOR SOFTWARE ENGINEER Red Hat Israel <https://www.redhat.com/> <https://red.ht/sig> TRIED. TESTED. TRUSTED. <https://redhat.com/trusted> On Tue, Jul 3, 2018 at 2:20 PM, wrote: > Hi Shirly, > > here you are: > > --snip > ovirt_engine_history=# SELECT * FROM history_configuration; > var_name | var_value | var_datetime > ---+---+ > default_language | en_US | > firstSync | false | 2018-04-09 15:52:00+02 > MinimalETLVersion | 4.2.0 | > lastHourAggr | | 2018-07-03 12:00:00+02 > HourlyAggFailed | false | > lastDayAggr | | 2018-07-02 00:00:00+02 > (6 rows) > > ovirt_engine_history=# > --snap > > date > Tue Jul 3 13:16:27 CEST 2018 > > Thanky you, > Ema > > > > > Von:"Shirly Radco" > An:emanuel.santosvar...@mahle.com, > Kopie:"Roy Golan" , "users" > Datum:03.07.2018 12:37 > Betreff:Re: [ovirt-users] Antwort: Re: vacuumdb: could not > connect to database ovirt_engine_history > -- > > > > Hi, > > Please share your history_configuration table content > in ovirt_engine_history db: > > SELECT * FROM history_configuration; > > the date and time you run this query > > and the ovirt_engine_dwh.log > > > > > > -- > *SHIRLY RADCO* > BI SeNIOR SOFTWARE ENGINEER > Red Hat Israel <https://www.redhat.com/> > > <https://red.ht/sig> *TRIED. TESTED. TRUSTED.* > <https://redhat.com/trusted> > > > On Fri, Jun 29, 2018 at 9:06 AM, <*emanuel.santosvar...@mahle.com* > > wrote: > Hi Roy, well db is alive : > > > su - postgres -c 'scl enable rh-postgresql95 -- psql ovirt_engine_history' > psql (9.5.9) > Type "help" for help. > > ovirt_engine_history=# \dt > List of relations > Schema | Name| Type |Owner > +---+---+--- > --- > public | calendar | table | ovirt_engine_history > public | cluster_configuration | table | ovirt_engine_history > public | datacenter_configuration | table | ovirt_engine_history > public | datacenter_storage_domain_map | table | ovirt_engine_history > public | enum_translator | table | ovirt_engine_history > public | history_configuration | table | ovirt_engine_history > public | host_configuration| table | ovirt_engine_history > public | host_daily_history| table | ovirt_engine_history > public | host_hourly_history | table | ovirt_engine_history > public | host_interface_configuration | table | ovirt_engine_history > public | host_interface_daily_history | table | ovirt_engine_history > public | host_interface_hourly_history | table | ovirt_engine_history > public | host_interface_samples_history| table | ovirt_engine_history > public | host_samples_history | table | ovirt_engine_history > public | schema_version| table | ovirt_engine_history > public | statistics_vms_users_usage_daily | table | ovirt_engine_history > public | statistics_vms_users_usage_hourly | table | ovirt_engine_history > public | storage_domain_configuration | table | ovirt_engine_history > public | storage_domain_daily_history | table | ovirt_engine_history > public | storage_domain_hourly_history | table | ovirt_engine_history > public | storage_domain_samples_history| table | ovirt_engine_history > public | tag_details | table | ovirt_engine_history > public | tag_relations_history | table | ovirt_engine_history > public | users_details_history | table | ovirt_engine_history > public | vm_configuration | table | ovirt_engine_history > public | vm_daily_history | table | ovirt_engine_history > public | vm_device_history | table | ovirt_engine_history > public | vm_disk_configuration | table | ovirt_engine_history > public | vm_disk_daily_history | table | ovirt_engine_history > public | vm_disk_hourly_history| table | ovirt_engine_history > public | vm_disk_samples_history | table | ovirt_engine_history > public | vm_disks_usage_daily_history | table | ovirt_engine_history > public | vm_disks_usage_hourly_history | table | ovirt_engine_history >
[ovirt-users] Re: oVirt reports using Grafana
Hello, I have updated the blog "Build oVirt Reports Using Grafana" , I used latest Grafana. https://ovirt.org/blog/2018/06/ovirt-report-using-grafana/ It was also tested by our QE. Thank you for your input on this issue and I hope this blog will make it easier for you to use Grafana with oVirt DWH and get the statistics that you need. Best regards, -- SHIRLY RADCO BI SENIOR SOFTWARE ENGINEER Red Hat Israel <https://www.redhat.com/> <https://red.ht/sig> TRIED. TESTED. TRUSTED. <https://redhat.com/trusted> On Wed, May 23, 2018 at 11:37 AM, Alejandro Cortina < alejandro.corti...@gmail.com> wrote: > Hi Shirly, > > I went through your instructions just yesterday and they work but some > troubleshooting was needed. This is what I have found: > > * When adding the graph I also got syntax errors: '*pq: syntax error at > or near "$"'*, maybe add an "ignore this error" line to the docs would be > an improvement > * I am new to grafana then I could not understand about templating. Took > me a few *trips* to http://docs.grafana.org/reference/templating/ to > understand it. Maybe some simple instructions would make experience better. > * Regarding tremplating: > > cluster_name > - fails: SELECT cluster_name FROM v4_2_configuration_history_clusters > WHERE datacenter_id = $datacenter_id > - not fail: SELECT cluster_name FROM v4_2_configuration_history_clusters > WHERE datacenter_id='$datacenter_id' > > cluster_id > - fails: SELECT cluster_id FROM v4_2_configuration_history_clusters WHERE > datacenter_id = $datacenter_id > - not fail: SELECT cluster_id FROM v4_2_configuration_history_clusters > WHERE datacenter_id ='$datacenter_id' > > there are many more. > > * Modifying DB, even DWH views are stable I think it would be better to > instruct to make backup. > > Regarding modifying DB, Is it possible to revert these changes? > > Thanks! > > On Tue, May 22, 2018 at 6:09 PM, Shirly Radco wrote: > >> >> >> -- >> >> SHIRLY RADCO >> >> BI SENIOR SOFTWARE ENGINEER >> >> Red Hat Israel >> >> >> TRIED. TESTED. TRUSTED. >> >> >> >> On Fri, May 18, 2018, 16:02 Vincent Royer wrote: >> >>> Yes I agree, because the database contains so many version specific >>> pointers, all of them will stop working when you upgrade. So that's no good! >>> >> >> Not sure what you mean. The DWH views are stable and we currently >> support 3.6 and above views. It means you do not have to update the version >> of the view. >> Also DWH is pretty stable. So you should not expect many changes. >> >> >>> If you ever get something decent working with Grafana, I'd be very >>> interested. I'm still not happy with the integration with the engine >>> history database, I was never really able to get predictable output from >>> it, and spent way too many hours messing around with it. >>> >> >> Ill try and add a few more meaningful examples if that will help. >> >> Is the problem is how to join the tables together? >> >> >>> >>> On Thu, May 17, 2018 at 11:21 PM Karli Sjöberg >>> wrote: >>> >>>> On Thu, 2018-05-17 at 10:37 -0700, Vincent Royer wrote: >>>> > These are the same issues I ran into. I did get it working, look up >>>> > my post history and you'll find some solutions to the errors >>>> >>>> Big thanks, now I understand what the problem was! >>>> >>>> But I must say, after reading that thread, I´m actually more interested >>>> in setting up the metrics store as it seems you get way more data out >>>> of it without having to access the database directly. The point being, >>>> the less manual stuff you do to alter the original setup in the engine, >>>> the less issues you are going to have later on, with upgrades and such. >>>> >>>> /K >>>> >>>> > >>>> > On Thu, May 17, 2018, 1:01 AM Sandro Bonazzola, >>>> > wrote: >>>> > > Shirly, can you please update the blog post pointing to an updated >>>> > > documentation page? >>>> > > >>>> > > 2018-05-17 9:35 GMT+02:00 Karli Sjöberg : >>>> > > > Heya! >>>> > > > >>>> > > > I've been whishing for reports in oVirt ever since the old >>>> > > > 'Jasper >>>> > > > Reports' was removed. For an Enterprise, ha
[ovirt-users] Re: oVirt Metrics
Hi, I'm so happy you managed to get it working for you. I'm aware of the ansible version issue and the Openshift team is working to fix it. Currently ansible 2.5.5 and 2.5.6 seem to be working ok. Yes. You can add to the /etc/ovirt-engine-metrics/config.yml collectd_interval: 20 (The default is 10 seconds) And rerun the /usr/share/ovirt-engine-metrics/setup/ansible/configure_ovirt_machines_for_metrics.sh This will update the collection interval on all your machines. In addition, If there are metrics you do not wish to collect you can update the collectd config files in /usr/share/ansible/roles/oVirt.metrics/roles/oVirt.ovirt-collectd/ovirt-host/templates/ and /usr/share/ansible/roles/oVirt.metrics/roles/oVirt.ovirt-collectd/ovirt-engine/templates/ and rerun the /usr/share/ovirt-engine-metrics/setup/ansible/configure_ovirt_machines_for_metrics.sh We would like to add aggregations in the future for long term storage. Currently we set the curator to save 3 days of metrics data. since metrics consume lots of disk space. Logs are kept for a month by default. After that the curator deletes the old indexes. You can update the curator but that will affect the disk size you will need. This is the documentation for curator update and general info about curator: https://docs.openshift.com/container-platform/3.9/install_config/aggregate_logging.html#configuring-curator https://docs.openshift.com/container-platform/3.9/install_config/aggregate_logging.html#aggregate-logging-creating-the-curator-configuration I hope this will help you. Best regards, -- SHIRLY RADCO BI SENIOR SOFTWARE ENGINEER Red Hat Israel <https://www.redhat.com/> <https://red.ht/sig> TRIED. TESTED. TRUSTED. <https://redhat.com/trusted> On Tue, Jul 17, 2018 at 9:04 AM, wrote: > I did set it up yesterday and I intent to use it. Setup worked ok on > Centos 7.5. Only problem was with depency of ansible for > centos-openshift-origin39-candidate, which I had to deactivate from > repos. It did work though and I am getting reports now. Anyway is there a > way to "relax" the amount of data collected, say make collection every 20 > seconds instead of 10 seconds (I think that is the default.) Is there a way > to get keep data for specific amount of time say 1 year and then discard > the older data and vacuum the database ? > > Thank you and redhat for all your efforts on providing such a fine product. > Regards > George Vasilopoulos > ___ > 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/ZEMUFIGU46H5LHS5IIIR4M54YWJNYY7N/ > ___ 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/3OENF54ILEGBHFPKNOO3QCT3BLC5HWKX/
[ovirt-users] Re: metrics
Also, I believe that you need for now to install ansible 2.5.5 or 2.5.6 due to OpenShift bug. -- SHIRLY RADCO BI SENIOR SOFTWARE ENGINEER Red Hat Israel <https://www.redhat.com/> <https://red.ht/sig> TRIED. TESTED. TRUSTED. <https://redhat.com/trusted> On Thu, Jul 19, 2018 at 5:37 PM, Rich Megginson wrote: > do you have http://cbs.centos.org/repos/paas7-openshift-origin39-candida > te/x86_64/os/Packages/ as one of your yum repos? > > What does "yum search atomic-openshift" show? > > On 07/19/2018 08:06 AM, supo...@logicworks.pt wrote: > >> Hi, >> >> I'm still facing this issue >> >> Still this error: >> 1. Hosts:localhost >> Play: Determine openshift_version to configure on first master >> Task: openshift_version : fail >> Message: Package atomic-openshift not found >> >> What i have installed: >> openshift-ansible-3.9.0-0.53.0.git.1.af49d87.el7.noarch >> ansible-2.6.1-1.el7.noarch >> atomic-openshift-utils-3.9.0-0.53.0.git.1.af49d87.el7.noarch >> CentOS Linux release 7.5.1804 (Core) >> >> Any help? >> >> Thanks >> >> José >> >> >> >> >> *De: *"Rich Megginson" >> *Para: *"Shirly Radco" , supo...@logicworks.pt >> *Cc: *"users" >> *Enviadas: *Segunda-feira, 25 De Junho de 2018 22:02:59 >> *Assunto: *Re: [ovirt-users] metrics >> >> >> On 06/24/2018 01:10 AM, Shirly Radco wrote: >> > Hi, >> > >> > I see there is an OpenShift bug about this issue >> > https://bugzilla.redhat.com/show_bug.cgi?id=1589629 >> > "Bug 1589629 - Install logging/metrics failed at TASK [Validate >> > openshift_node_groups and openshift_node_group_name]" >> >> AFAIK, this only affects OpenShift 3.10 and later. >> >> > >> > >> > I see there is a workaround >> > https://bugzilla.redhat.com/show_bug.cgi?id=1589629#c2 >> > >> > to add to ansible-inventory-origin-39-aio that is in your metrics >> > store machine at the root directory >> > skip_sanity_checks=true >> > >> > Are you experiencing this in 3.9 ? The bug is open on 3.10. >> > >> > Bset, >> > >> > -- >> > >> > SHIRLY RADCO >> > >> > BI SeNIOR SOFTWARE ENGINEER >> > >> > Red Hat Israel <https://www.redhat.com/> >> > >> > <https://red.ht/sig> >> > TRIED. TESTED. TRUSTED. <https://redhat.com/trusted> >> > >> > >> > On Thu, Jun 21, 2018 at 7:15 PM, > > <mailto:supo...@logicworks.pt>> wrote: >> > >> > Hi, >> > >> > I'm trying to configure oVirt metrics but when i run >> > >> > # ANSIBLE_LOG_PATH=/tmp/ansible.log ansible-playbook -vvv -e >> > @/root/vars.yaml -i /root/ansible-inventory-origin-39-aio >> > playbooks/deploy_cluster.yml >> > >> > i always get this error: >> > >> > Failure summary: >> > >> > >> > 1. Hosts: localhost >> > Play: Verify Requirements >> > Task: Validate openshift_node_groups and openshift_node_group_name >> > Message: last_checked_host: localhost, last_checked_var: >> > openshift_node_group_name;openshift_node_group_name must be >> > defined for all nodes >> > >> > >> > What am I missing here? >> > >> > Thanks >> > >> > >> > >> > -- >> > >> >> > Jose Ferradeira >> > http://www.logicworks.pt >> > >> > ___ >> > Users mailing list -- users@ovirt.org <mailto:users@ovirt.org> >> > To unsubscribe send an email to users-le...@ovirt.org >> > <mailto:users-le...@ovirt.org> >> > Privacy Statement: https://www.ovirt.org/site/privacy-policy/ >> > <https://www.ovirt.org/site/privacy-policy/> >> > oVirt Code of Conduct: >> > https://www.ovirt.org/community/about/community-guidelines/ >> > <https://www.ovirt.org/community/about/community-guidelines/> >> > List Archives: >> > https://lists.ovirt.org/archives/list/users@ovirt.org/messag >> e/QQMEHPYZUWZSZURSBLCSL4PLDW374K34/ >> > <https://lists.ovirt.org/archives/list/users@ovirt.org/messa >> ge/QQMEHPYZUWZSZURSBLCSL4PLDW374K34/> >> > >> > >> > > > ___ 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/VCFIAX6Y7YHSF7P6WHX5W4OCU45QSTPO/
[ovirt-users] Re: metrics
-- SHIRLY RADCO BI SENIOR SOFTWARE ENGINEER Red Hat Israel <https://www.redhat.com/> <https://red.ht/sig> TRIED. TESTED. TRUSTED. <https://redhat.com/trusted> On Thu, Jul 19, 2018 at 6:22 PM, Rich Megginson wrote: > Shirly, does the ovirt metrics ansible playbooks install and configure the > openshift repos from https://github.com/ViaQ/Main/b > lob/master/centos7-viaq.repo ? > A copy of it: https://www.ovirt.org/develop/release-management/features/metrics/centos7-viaq.repo > > Please try ansible 2.5 > > On 07/19/2018 09:15 AM, supo...@logicworks.pt wrote: > >> Sorry, wrong server >> >> >> >> # yum search atomic-openshift >> ... >> === N/S matched: atomic-openshift >> >> atomic-openshift-utils.noarch : Atomic OpenShift Utilities >> >> >> # yum repolist >> repo id repo >> name status >> base/7/x86_64CentOS-7 - >> Base9911 >> centos-gluster312/7/x86_64 CentOS-7 - Gluster >> 3.12 214 >> centos-openshift-origin CentOS OpenShift >> Origin 185 >> centos-opstools-release/7/x86_64 CentOS-7 - OpsTools - >> release 623 >> centos-ovirt42/7/x86_64 CentOS-7 - oVirt >> 4.2446 >> centos-qemu-ev/7/x86_64 CentOS-7 - QEMU >> EV 59 >> extras/7/x86_64 CentOS-7 - >> Extras 363 >> origin-repo Origin >> RPMs 12 >> updates/7/x86_64 CentOS-7 - >> Updates 970 >> >> >> *De: *supo...@logicworks.pt >> *Para: *"Shirly Radco" >> *Cc: *"Rich Megginson" , "users" >> *Enviadas: *Quinta-feira, 19 De Julho de 2018 16:09:48 >> *Assunto: *Re: [ovirt-users] metrics >> >> # yum search atomic-openshift >> Warning: No matches found for: atomic-openshift >> No matches found >> >> # yum repolist >> repo id repo name >> status >> !base/7/x86_64 CentOS-7 - >> Base 9911 >> !centos-sclo-rh-release/x86_64 CentOS-7 - SCLo >> rh 7514 >> !extras/7/x86_64CentOS-7 - >> Extras313 >> !ovirt-4.2/7Latest oVirt 4.2 Release >> 1670+101 >> !ovirt-4.2-centos-gluster312/x86_64 CentOS-7 - Gluster >> 3.12 189 >> !ovirt-4.2-centos-opstools/x86_64 CentOS-7 - OpsTools - >> release493 >> !ovirt-4.2-centos-ovirt42/x86_64CentOS-7 - oVirt >> 4.2 379 >> !ovirt-4.2-centos-qemu-ev/x86_64CentOS-7 - QEMU >> EV55 >> !ovirt-4.2-epel/x86_64 Extra Packages for Enterprise Li >> 12585+12335 >> !ovirt-4.2-virtio-win-latestvirtio-win builds roughly >> matchi 37 >> !updates/7/x86_64 CentOS-7 - >> Updates 695 >> >> >> >> >> *De: *"Shirly Radco" >> *Para: *"Rich Megginson" >> *Cc: *supo...@logicworks.pt, "users" >> *Enviadas: *Quinta-feira, 19 De Julho de 2018 16:02:52 >> *Assunto: *Re: [ovirt-users] metrics >> >> Also, I believe that you need for now to install ansible 2.5.5 or 2.5.6 >> due to OpenShift bug. >> >> -- >> >> SHIRLY RADCO >> >> BI SENIOR SOFTWARE ENGINEER >> >> Red Hat Israel <https://www.redhat.com/> >> >> <https://red.ht/sig> >> >> TRIED. TESTED. TRUSTED. <https://redhat.com/trusted> >> >> >> On Thu, Jul 19, 2018 at 5:37 PM, Rich Megginson > <mailto:rmegg...@redhat.com>> wrote: >> >> do you have >> http://cbs.centos.org/repos/paas7-openshift-origin39-candida >> te/x86_64/os/Packages/ >> as one of your yum repos? >> >> What does "yum search atomic-openshift" s
[ovirt-users] Re: metrics
I believe these issues should be opened and tracked on github OpenShift
Origin https://github.com/openshift/origin/issues.
Best,
--
SHIRLY RADCO
BI SENIOR SOFTWARE ENGINEER
Red Hat Israel <https://www.redhat.com/>
<https://red.ht/sig>
TRIED. TESTED. TRUSTED. <https://redhat.com/trusted>
On Mon, Jul 23, 2018 at 6:44 PM, Rich Megginson wrote:
> We're working on it. Not sure what the problem is, but it looks like
> openshift origin 3.9 is just broken right now - due to a combination of
> ansible and openshift-ansible problems.
>
> Shirly, where should bugs be filed in order to track this?
>
>
> On 07/23/2018 09:29 AM, supo...@logicworks.pt wrote:
>
>> Hi,
>>
>> When I Run Ansible using the prerequisites.yml playbookI get this error:
>>
>> fatal: [localhost]: FAILED! => {
>>
>> "attempts": 3,
>>
>> "changed": false,
>>
>> "invocation": {
>>
>> "module_args": {
>>
>> "allow_downgrade": false,
>>
>> "conf_file": null,
>>
>> "disable_gpg_check": false,
>>
>> "disable_plugin": [],
>>
>> "disablerepo": null,
>>
>> "enable_plugin": [],
>>
>> "enablerepo": null,
>>
>> "exclude": null,
>>
>> "install_repoquery": true,
>>
>> "installroot": "/",
>>
>> "list": null,
>>
>> "name": [
>>
>> "atomic-openshift-docker-excluder*"
>>
>> ],
>>
>> "security": false,
>>
>> "skip_broken": false,
>>
>> "state": "present",
>>
>> "update_cache": false,
>>
>> "update_only": false,
>>
>> "validate_certs": true
>>
>> }
>>
>> },
>>
>> "msg": "No package matching 'atomic-openshift-docker-excluder*' found
>> available, installed or updated",
>>
>> "rc": 126,
>>
>> "results": [
>>
>> "No package matching 'atomic-openshift-docker-excluder*' found
>> available, installed or updated"
>>
>> ]
>>
>> }
>>
>> to retry, use: --limit @/usr/share/ansible/openshift-
>> ansible/playbooks/prerequisites.retry
>>
>>
>> PLAY RECAP
>>
>> **
>>
>> localhost : ok=58 changed=2 unreachable=0 failed=1
>>
>>
>>
>> INSTALLER STATUS **
>>
>> **
>>
>> Initialization : Complete (0:00:22)
>>
>>
>>
>>
>>
>> Can I live with this error or is something I need to correct?
>>
>>
>> Thanks
>>
>>
>>
>> *De: *supo...@logicworks.pt
>> *Para: *"Shirly Radco"
>> *Cc: *"Rich Megginson" , "users"
>> *Enviadas: *Sexta-feira, 20 De Julho de 2018 13:19:37
>> *Assunto: *[ovirt-users] Re: metrics
>>
>>
>> Hi,
>>
>> Still the same error after installing ansible 2.5.5 and repo:
>>
>> 1. Hosts:localhost
>> Play: Determine openshift_version to configure on first master
>> Task: openshift_version : fail
>> Message: Package 'atomic-openshift-3.9*' not found
>>
>> # yum search atomic-openshift
>> ...
>> N/S matched: atomic-openshift
>> =
>> atomic-openshift-utils.noarch : Atomic OpenShift Utilities
>>
>> # rpm -q atomic-openshift-utils
>> atomic-openshift-utils-3.9.32-1.git.1.970d147.el7.noarch
>>
>> # rpm -q ansible
>> ansible-2.5.5-1.el7.noarch
>>
>> openshift-ansible-3.9.32-1.git.1.970d147.el7.noarch
>>
>> # cat /etc/yum.repos.d/centos7-viaq.repo
>> [centos-openshift-origin]
>> name=CentOS OpenShift Origin
>> baseurl=http://mirror.centos.org/centos/7/paas/x86_64/openshift-origin/
>> enabled=1
>> gpgcheck=1
>> gpgkey=https://tdawson.fedorapeople.org/centos/RPM-GPG-KEY-
>> CentOS-SIG-PaaS
>>
>> [centos-openshift-common-candidate]
>> name=CentOS OpenShift Common Candidate
>> baseurl=https://cbs
[ovirt-users] Re: Metrics in Kibana not working
Hi, There is probably a file in collectd.d or rsyslog.d directories that prevents them from working as expected. Can you please list the files you have? If you have the libvirt.conf file, what is its content? If you can't reopen a bug in Bugzilla then you can create a new what and add the old as a dependent bug or add it in the comment. Best, -- Shirly Radco BI Principal Software Engineer Red Hat <https://www.redhat.com/> <https://www.redhat.com/> On Thu, Jul 9, 2020 at 9:32 PM Guillaume Pavese < guillaume.pav...@interactiv-group.com> wrote: > Trying to use the provided visualizations/Dashboards for ovirt metrics in > Kibana. > Using ovirt 4.3.7, with ovirt-engine-metrics 1.3.7-1 and latest > rsylog-8.24.0-52 and collectd-5.10.0-2 > I am receiving data in indexes and some fields are present. A few graph > work, but most don't and I am getting a lot of errors like theses : > > Error in visualisation[esaggs] > "field" is a required parameter > > - On my hosts I can see the following collectd errors: > > systemd[1]: Starting Collectd statistics daemon... > collectd[21629]: plugin_load: plugin "disk" successfully loaded. > ... > collectd[21629]: plugin_load: plugin "network" successfully loaded. > collectd[21629]: Systemd detected, trying to signal readiness. > systemd[1]: Started Collectd statistics daemon. > collectd[21629]: virt plugin: reader virt-0 initialized > collectd[21629]: Initialization complete, entering read-loop. > collectd[21629]: write_syslog plugin: send failed with status -1 > (Connection reset by peer) > collectd[21629]: write_syslog plugin: error with ws_send_message > > > - And the following rsyslog ones : > > systemd[1]: Starting System Logging Service... > rsyslogd[210059]: [origin software="rsyslogd" > swVersion="8.24.0-52.el7_8.2" x-pid="210059" x-info=" > http://www.rsyslog.com";] start > systemd[1]: Started System Logging Service. > rsyslogd[210059]: command 'SystemLogSocketName' is currently not permitted > - did you already set it via a RainerScript command (v6+ config)? > [v8.24.0-52.el7_8.2 try http://www.rsyslog.com/e/ ] > > I think that this is this bug : > https://bugzilla.redhat.com/show_bug.cgi?id=1732918 > However it's CLOSED INSUFFICIENT_DATA with last message being "Closing > with insufficient data. Please reopen if you can provide needed info." > > Is my understanding correct that only RedHat employees can reopen closed > bugs? I have encountered quite a lot of situations where I'm facing an > issue covered by such a closed bug with a "please reopen if you can provide > info" msg, but frustratingly not being able to do so... > > > Guillaume Pavese > Ingénieur Système et Réseau > Interactiv-Group > > Ce message et toutes les pièces jointes (ci-après le “message”) sont > établis à l’intention exclusive de ses destinataires et sont confidentiels. > Si vous recevez ce message par erreur, merci de le détruire et d’en avertir > immédiatement l’expéditeur. Toute utilisation de ce message non conforme a > sa destination, toute diffusion ou toute publication, totale ou partielle, > est interdite, sauf autorisation expresse. L’internet ne permettant pas > d’assurer l’intégrité de ce message . Interactiv-group (et ses filiales) > décline(nt) toute responsabilité au titre de ce message, dans l’hypothèse > ou il aurait été modifié. IT, ES, UK. > <https://interactiv-group.com/disclaimer.html> > ___ > Users mailing list -- users@ovirt.org > To unsubscribe send an email to users-le...@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/2F52SRDCO6FLHAG7WQDYIAWECZOKI2HV/ > ___ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-le...@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/CMZWKXSXKJC656TM6P7JGCKORHVHYMRG/
