[ovirt-users] Re: Some errors on the grafana dashboard

2021-11-02 Thread Tommy Sway 
Sorry , I have got the cause of the files :

/root/ovirt-dwh-backup/packaging/dbscripts/create_views_4_3.sql

/root/ovirt-dwh/packaging/dbscripts/create_views_4_3.sql

 

So, please just  focus only on other issues in my last mail.

 

Thanks.

 

From: Tommy Sway  
Sent: Wednesday, November 3, 2021 1:01 PM
To: 'Aviv Litman' ; users@ovirt.org
Subject: RE: Some errors on the grafana dashboard

 

1. connect to your engine machine
2. vi /usr/share/ovirt-engine/dbscripts/create_dwh_views.sql :

add the new line as described in the patch: 
https://gerrit.ovirt.org/#/c/ovirt-engine/+/114565/4/packaging/dbscripts/create_dwh_views.sql.

 

--- This step just add one line to the 
/usr/share/ovirt-engine/dbscripts/create_dwh_views.sql 87 line :

--- count_threads_as_cores AS count_threads_as_cores,

--- it’s OK.

 


3. connect to your dwh machine (if the engine and dwh are on the same machine 
then all files are in the same machine)

4. create or edit the files in the patch: 
https://gerrit.ovirt.org/#/c/ovirt-dwh/+/114568/, note that for you files named 
4_4 should be named 4_3
You can find the file's location with this command:
find / -name create_views_4_3.sql

 

 Should this step need to edit these files:

 



 

--- And there are many same name files as:

 

# find / -name create_views_4_3.sql

/root/ovirt-dwh-backup/packaging/dbscripts/create_views_4_3.sql

/root/ovirt-dwh/packaging/dbscripts/create_views_4_3.sql

/usr/share/ovirt-engine-dwh/dbscripts/create_views_4_3.sql

 

Do I need to change these files at the same time ？？

 

 

 


5. run engine-setup, or engine-setup --offline 

 

 

 

 

From: Aviv Litman mailto:alit...@redhat.com> > 
Sent: Monday, November 1, 2021 5:50 PM
To: Tommy Sway mailto:sz_cui...@163.com> >; users@ovirt.org 
 
Subject: Re: Some errors on the grafana dashboard

 

Hi Tommy,
You can apply  the patches by changing the relevant files in engine and dwh and 
run 'engine-setup' or 'engine-setup --offline' .

Steps:
1. connect to your engine machine
2. vi /usr/share/ovirt-engine/dbscripts/create_dwh_views.sql :

add the new line as described in the patch: 
https://gerrit.ovirt.org/#/c/ovirt-engine/+/114565/4/packaging/dbscripts/create_dwh_views.sql.
3. connect to your dwh machine (if the engine and dwh are on the same machine 
then all files are in the same machine)

4. create or edit the files in the patch: 
https://gerrit.ovirt.org/#/c/ovirt-dwh/+/114568/, note that for you files named 
4_4 should be named 4_3
You can find the file's location with this command:
find / -name create_views_4_3.sql
5. run engine-setup, or engine-setup --offline 
 
Let me know how it goes!

Thanks,
Aviv

 

 

On Mon, Nov 1, 2021 at 9:42 AM Tommy Sway mailto:sz_cui...@163.com> > wrote:

But how to apply the patches? 

 

Is some docs can guide me how to apply?

 

Thanks.

 

 

 

 

From: Aviv Litman mailto:alit...@redhat.com> > 
Sent: Sunday, October 3, 2021 10:08 PM
To: Tommy Sway mailto:sz_cui...@163.com> >
Subject: Re: Some errors on the grafana dashboard

 

Important note: do not to change the minimal version part in dwh 
ovirt-engine-dwh.spec.in   file.

 

On Sun, Oct 3, 2021 at 4:50 PM Aviv Litman mailto:alit...@redhat.com> > wrote:

Hi Tommy,
You can try to implement the patches I shared manually by changing the relevant 
files in engine and dwh and run engine-setup.

Let me know if you have any questions.

Thanks,
Aviv

 

On Sun, Sep 19, 2021 at 4:56 PM Tommy Sway mailto:sz_cui...@163.com> > wrote:

Thank you!

 

 

 

 

 

From: Aviv Litman mailto:alit...@redhat.com> > 
Sent: Sunday, September 19, 2021 3:04 PM
To: Tommy Sway mailto:sz_cui...@163.com> >
Subject: Re: Some errors on the grafana dashboard

 

Hi Tommy,
There was a bug in the way we calculate hosts CPU: we didn't consider the 
count_threads_as_cores option in the calculation.
The count_threads_as_cores column is available only from ovirt-engine 4.4.6.7 
version, and ovirt-dwh 4.4.7.

Patches:

ovirt-engine  

ovirt-dwh  

So you have to update the version to 4.4.7.
I will also add a note in the Blog.

Feel free to contact me if you have more questions.

Best,
Aviv  

 

On Tue, Sep 14, 2021 at 11:38 AM Tommy Sway mailto:sz_cui...@163.com> > wrote:

Hello!

 

I used the JSON file you provided and imported grafana. Before importing, I 
replaced the version, because the version of my system is 4.3.

$ find . -type f -name "*dashboard.json" -exec sed -i -e 's/v4_4_/v4_3_/g' {} \;

However, most of the reports are normal, but some reports have similar errors: 

 

pq: column "count_threads_as_cores" does not exist

Object

status:400

statusText:"Bad Request"

data:Object

results:Object

message:"pq: column "count_threads_as_cores" does not exist"

message:"pq: column "count_threads_as_cores" does not exist"

 

Many of the other reports worked fine, with only a

[ovirt-users] Re: Some errors on the grafana dashboard

2021-11-02 Thread Tommy Sway 
1. connect to your engine machine
2. vi /usr/share/ovirt-engine/dbscripts/create_dwh_views.sql :

add the new line as described in the patch: 
https://gerrit.ovirt.org/#/c/ovirt-engine/+/114565/4/packaging/dbscripts/create_dwh_views.sql.

 

--- This step just add one line to the 
/usr/share/ovirt-engine/dbscripts/create_dwh_views.sql 87 line :

--- count_threads_as_cores AS count_threads_as_cores,

--- it’s OK.

 


3. connect to your dwh machine (if the engine and dwh are on the same machine 
then all files are in the same machine)

4. create or edit the files in the patch: 
https://gerrit.ovirt.org/#/c/ovirt-dwh/+/114568/, note that for you files named 
4_4 should be named 4_3
You can find the file's location with this command:
find / -name create_views_4_3.sql

 

 Should this step need to edit these files:

 



 

--- And there are many same name files as:

 

# find / -name create_views_4_3.sql

/root/ovirt-dwh-backup/packaging/dbscripts/create_views_4_3.sql

/root/ovirt-dwh/packaging/dbscripts/create_views_4_3.sql

/usr/share/ovirt-engine-dwh/dbscripts/create_views_4_3.sql

 

Do I need to change these files at the same time ？？

 

 

 


5. run engine-setup, or engine-setup --offline 

 

 

 

 

From: Aviv Litman  
Sent: Monday, November 1, 2021 5:50 PM
To: Tommy Sway ; users@ovirt.org
Subject: Re: Some errors on the grafana dashboard

 

Hi Tommy,
You can apply  the patches by changing the relevant files in engine and dwh and 
run 'engine-setup' or 'engine-setup --offline' .

Steps:
1. connect to your engine machine
2. vi /usr/share/ovirt-engine/dbscripts/create_dwh_views.sql :

add the new line as described in the patch: 
https://gerrit.ovirt.org/#/c/ovirt-engine/+/114565/4/packaging/dbscripts/create_dwh_views.sql.
3. connect to your dwh machine (if the engine and dwh are on the same machine 
then all files are in the same machine)

4. create or edit the files in the patch: 
https://gerrit.ovirt.org/#/c/ovirt-dwh/+/114568/, note that for you files named 
4_4 should be named 4_3
You can find the file's location with this command:
find / -name create_views_4_3.sql
5. run engine-setup, or engine-setup --offline 
 
Let me know how it goes!

Thanks,
Aviv

 

 

On Mon, Nov 1, 2021 at 9:42 AM Tommy Sway mailto:sz_cui...@163.com> > wrote:

But how to apply the patches? 

 

Is some docs can guide me how to apply?

 

Thanks.

 

 

 

 

From: Aviv Litman mailto:alit...@redhat.com> > 
Sent: Sunday, October 3, 2021 10:08 PM
To: Tommy Sway mailto:sz_cui...@163.com> >
Subject: Re: Some errors on the grafana dashboard

 

Important note: do not to change the minimal version part in dwh 
ovirt-engine-dwh.spec.in   file.

 

On Sun, Oct 3, 2021 at 4:50 PM Aviv Litman mailto:alit...@redhat.com> > wrote:

Hi Tommy,
You can try to implement the patches I shared manually by changing the relevant 
files in engine and dwh and run engine-setup.

Let me know if you have any questions.

Thanks,
Aviv

 

On Sun, Sep 19, 2021 at 4:56 PM Tommy Sway mailto:sz_cui...@163.com> > wrote:

Thank you!

 

 

 

 

 

From: Aviv Litman mailto:alit...@redhat.com> > 
Sent: Sunday, September 19, 2021 3:04 PM
To: Tommy Sway mailto:sz_cui...@163.com> >
Subject: Re: Some errors on the grafana dashboard

 

Hi Tommy,
There was a bug in the way we calculate hosts CPU: we didn't consider the 
count_threads_as_cores option in the calculation.
The count_threads_as_cores column is available only from ovirt-engine 4.4.6.7 
version, and ovirt-dwh 4.4.7.

Patches:

ovirt-engine  

ovirt-dwh  

So you have to update the version to 4.4.7.
I will also add a note in the Blog.

Feel free to contact me if you have more questions.

Best,
Aviv  

 

On Tue, Sep 14, 2021 at 11:38 AM Tommy Sway mailto:sz_cui...@163.com> > wrote:

Hello!

 

I used the JSON file you provided and imported grafana. Before importing, I 
replaced the version, because the version of my system is 4.3.

$ find . -type f -name "*dashboard.json" -exec sed -i -e 's/v4_4_/v4_3_/g' {} \;

However, most of the reports are normal, but some reports have similar errors: 

 

pq: column "count_threads_as_cores" does not exist

Object

status:400

statusText:"Bad Request"

data:Object

results:Object

message:"pq: column "count_threads_as_cores" does not exist"

message:"pq: column "count_threads_as_cores" does not exist"

 

Many of the other reports worked fine, with only a few similar errors.

Is this caused by version incompatibility?

After all, 4.4 in the original document was replaced with 4.3 before the import.

 

Thank you!

 

 

___
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:

[ovirt-users] Re: question about engine deployment success rate

2021-11-02 Thread Strahil Nikolov via Users 
40-50% is low. Usually it should be above 90% but some versions are more buggy 
than others (depending on the version).
4.3.10 is the latest 4.3 version and is the only supported for migration to 
4.4/4.5, so consider altering the deployment process.
When an engine constantly restarts -> put it in global maintenance and connect 
to the HE (either via the 'hosted-engine' or ssh). Then you can investigate 
further.As the deployment uses Ansible - it should be fully idempotent.
Best Regards,Strahil Nikolov
 
 
  On Mon, Nov 1, 2021 at 13:34, Henning Sprang wrote: 
  Hi,
Thanks for your reply.

If you say "The process could get some polishing" - does it mean you
confirm that it is somewhat normal to have a success rate of 40-50%?

I inherited this project and have been told I should to use 4.3.9 so
far because that's the version other parts of the system have been
tested with.
But I can check what is necessary to upgrade the PXE/Kickstart bare
metal OS+ovirt install to 4.3.10 if that is promising to make it more
reliable.

The symptoms I observed where changing between the deployment process
seeming not to be able to transfer the "LocalHostedEngine" VM to the
glusterFS storage to become a "HostedEngine", and the other seems to
be when the engine is already up and running, but never being really
connected to the Ovirt system, continuously restarting, and also
showing XFS filesystem errors in it's dmesg output.

There is a whole lot of output, but none that I can identify as
telling me something like "X is wrong, check the config of service Y
please".
The log of the main deployment script says in it's logfile "please
look at the logfile..." and states it's own filename.

Do you need any specific log file or config?
I have to get them from my next failed install then.

Thanks,
Henning

On Sat, Oct 30, 2021 at 7:29 PM Strahil Nikolov  wrote:
>
> Well, it (the install process)requires some polishing. Any reason not to use 
> 4.3.10 ? This is the only supported version for migration to 4.4
>
>
> Can you share what were the errors ?
>
>
> Best Regards,
> Strahil Nikolov
>
> On Sat, Oct 30, 2021 at 20:25, Henning Sprang
>  wrote:
> Hi Strahil,
>
> Thanks for your reply!
>
> Since we are using 4.3.9 from the installation ISO, issues regarding CentOS 8 
> rolling releases do not apply here.
> We will do that upgrade sooner or later, but then i would try to do local yum 
> repository mirrors that are always snapshots. More or less how you suggest…
>
> So my success rate of 4 in 10 attempts has nothing to do with changing 
> package or Ovirt versions.
>
> It happens when applying exactly the same procedure, scripts, installation 
> media, on the exact same machine.
> So the input is always the same, but the result is at least 2 different error 
> states in 6 cases, and only 4 times a working system.
>
> I would like to understand if that is normal and everybody needs their 
> handful of attempts to deploy the engine until it succeeds or if this is a 
> sign that we still do something wrong that we need to track down and fix.
>
> Thanks,
> Henning
>
>
> On Sat 30. Oct 2021 at 14:31, Strahil Nikolov  wrote:
>
> If you want to increase your deployment success, you will need to use 
> repository management and freeze your OS & oVirt repos to a working level .
> For example if you use RHEL 8.4 and current level of oVirt - you will have 
> dependency issues until RHEL 8.5 is released.
>
> Once this happens and your build succeeds, you will lock your repos and 
> deploy from them again.Once you test each 'batch' of repos and confirm they 
> work for you -> you will create a new set of repos ...
>
> oVirt is dynamic project with new features constantly comming up (and 
> sometimes go away).
>
> Another approach is to use the ovirt Node image which is based on CentOS 
> Stream and is validated in the dev infrastructure .
>
>
> Best Regards,
> Strahil Nikolov
>
> On Wed, Oct 27, 2021 at 21:39, Henning Sprang
>  wrote:
>
> Hello,
>
> I've just inherited a project where we need to bring a prototype of a
> small Ovirt system (single node or 3 node hyperconverged, with
> glusterFS on the same machine, a bunch of different VM's ) running in
> an industrial machine into serial production.
>
> This means, we want to build a new 1 or 3 node Ovirt system each day
> up until 3 times a day.
>
> In my tests so far, the failure rate of the Ovirt engine deployment
> (via the included scripts as well as the web UI) turns out to be
> pretty high - it's between 40-60%, meaning until we have a running
> system, we would have to try the installation and/or final engine
> deployment about 2-4 times until we are successful.
>
> So far I could not identify clear error messages that let me tell how
> to fix the problem.
>
> Before going into details of the errors I would like to ask if people
> deeper into Ovirt would consider this a somewhat normal success rate,
> or if this indicates we are doing something generally wrong and we
> should definitely

[ovirt-users] Re: c9s - early?

2021-11-02 Thread Sandro Bonazzola 
Il giorno mar 2 nov 2021 alle ore 11:14 lejeczek via Users 
ha scritto:

> hi guys.
>
> Though CentOS Stream 9 is available these are its early days
> - may I ask @devel - how far away oVirt is from this new
> CStream?
>

We are working on it:
https://www.ovirt.org/develop/release-management/features/integration/centos-9-stream-support.html
(ignore the outdated stuff warning)
It would be great having feedback / testing on real hardware for it.


>
> many thanks, L.
> ___
> 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/PZL6Y4UH3GVMOM3VDSFPAFE7N5AILNNE/
>


-- 

Sandro Bonazzola

MANAGER, SOFTWARE ENGINEERING, EMEA R RHV

Red Hat EMEA 

sbona...@redhat.com


*Red Hat respects your work life balance. Therefore there is no need to
answer this email out of your office hours.*
___
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/UUXXAGRBC752AO7D5BTORFNT2YXQCA44/

[ovirt-users] c9s - early?

2021-11-02 Thread lejeczek via Users 

hi guys.

Though CentOS Stream 9 is available these are its early days 
- may I ask @devel - how far away oVirt is from this new 
CStream?


many thanks, L.
___
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/PZL6Y4UH3GVMOM3VDSFPAFE7N5AILNNE/

[ovirt-users] Re: The Engine VM (/32) and this host (/32) will not be in the same IP subnet.

2021-11-02 Thread Sina Owolabi 
In another rip-and-replace adventure, of multiple, where the vm refuses to
leave the libvirt stage more than once, I stopped in the middle of things
to make dhcp mark the random MAC address with the IP I needed the vm to
have.
Then for some reason (still don’t know why) the installation completed
successfully.
Hopefully I can move on from there without issue.
Very wary of trying again from scratch.

On Thu, 28 Oct 2021 at 11:55, Sina Owolabi  wrote:

> Ok I managed to continue choosing DHCP, which interestingly, it took
> an IP from the 10.200.30.0/23 subnet.
> I saw a lot of selinux AVC issues in journalctl, but I didnt see the
> install process end and the screen was obscured with multiple network
> messages.
> Is it ok to ssh in and make it static?
> Am I allowed to make local changes inside it?
> Because its not resolving to the IP address DNS has for it (
> 10.200.30.10/23).
> I would also like to make it an IPA client and such.
>
> On Wed, Oct 27, 2021 at 9:56 PM Sina Owolabi 
> wrote:
> >
> > Rejected:
> >
> >   How should the engine VM network be configured? (DHCP,
> > Static)[DHCP]: Static
> >   Please enter the IP address to be used for the engine VM []:
> > 10.200.30.10/23
> > [ ERROR ] Failed to execute stage 'Environment customization':
> > IPAddress() does not support netmasks or subnet prefixes! See
> > documentation for details.
> > [ INFO  ] Stage: Clean up
> > [ INFO  ] Cleaning temporary resources
> >
> > On Wed, Oct 27, 2021 at 9:53 PM Alex McWhirter  wrote:
> > >
> > > On 2021-10-27 16:09, Sina Owolabi wrote:
> > > > Its really weird.
> > > > Just tried again, with  the same failure, on a freshly reinstalled
> > > > CentOS 8.
> > > > Server has a number of vlan interfaces, on a physical interface
> > > > enp2s0f1, all in the defined notation,
> > > > one vlan interface has an IP, 10.200.10.3/23,
> > > > Second physical interface enp2s0f0 is configured for 10.200.30.3/23,
> > > > is the interface with a gateway and DNS, and the router can provide
> > > > other IPs with DHCP here, and which I hope to have ovirtmgmt on.
> > > > I run hosted-engine --deploy, I select the gateway for the enp2s0f1
> > > > vlan (10.200.10.1).
> > > >
> > > > Please indicate the gateway IP address [10.200.30.1]: 10.200.10.1
> > > > Please indicate a nic to set ovirtmgmt bridge on (enp2s0f1,
> > > > enp2s0f1.1014, enp2s0f1.1016, enp2s0f1.1015, enp2s0f1.1005, enp2s0f0)
> > > > [enp2s0f1.1014]: enp2s0f0
> > > >   Please specify which way the network connectivity should be
> > > > checked (ping, dns, tcp, none) [dns]:dns
> > > >   How should the engine VM network be configured? (DHCP,
> > > > Static)[DHCP]: Static
> > > >   Please enter the IP address to be used for the engine VM
> []:
> > > > 10.200.30.10
> > > > [ ERROR ] The Engine VM (10.200.30.10/32) and this host
> > > > (10.200.30.3/32) will not be in the same IP subnet.
> > > >  Static routing configuration are not supported on automatic
> > > > VM configuration.
> > > >
> > > > What can I try differently?
> > > >
> > >
> > > Try setting the subnet with the engine IP.
> > >
> > > I.E. instead of 10.200.30.10 do 10.200.30.10/23
> >
> >
> >
> > --
> >
> > cordially yours,
> >
> > Sina Owolabi
> >
> > +2348176469061
>
>
>
> --
>
> cordially yours,
>
> Sina Owolabi
>
> +2348176469061
>
-- 
Sent from MetroMail
___
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/EF6PSNJFTK4YGT4C3LTWZOTH3AZEHTJQ/

[ovirt-users] New Install. 3 node HCI using 4.4.8 ISO

2021-11-02 Thread shane . krenz 
Hello everyone. First time posting. Sorry if this is already been spoken to... 
I didn't see anything with a quick search that I did. 

3 nodes running dual E5-2600 series V4 CPUs with 256G memory in a Hybrid 
storage config.  2x 1.9TB SSDs and 6x 600G SAS spinners attached to a SAS/SATA 
HBA. 4x 1G ports. 
During initial boot from the 4.4.8. ISO oVirt installer I set static IPs, added 
DNS entries and copied ssh keys copied to each host.

First issue with deploying the cluster was complaining about partitions found 
on sdb even though I reclaimed and deleted everything on all drives. Ended up 
zero'ing the drives and started over. Then sdb was on the filter list. So I 
edited the LVM.conf file.  now I am stuck on "Gluster brick_t is invalid, must 
be a file or device"  No idea what to do about that one. 

 Also, I am not sure if its actually pulling in the 600G 10k drives into the 
mix at all.  How would I confirm this?

First 1.9TB SSD drive Is where I am installing the OS.  Should I change this to 
some other drive or usb stick and have the 2x SSDs as cache and all spinners as 
capacity data?  not sure how all that is supposed to work as I am not too 
familiar with Gluster. 

I know Nutanix and vSAN pretty well.  I wanted to try oVirt.  I am having a 
MUCH harder time with initial setup.  I appreciate any help / suggestions on 
best practice for my hardware setup. 
___
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/W4AATE4UKLN5PLTV6RPAUMIIEWDE6KYX/