Bug 1981771

Summary: Adding RHV provider causes errors in web console
Product: Migration Toolkit for Virtualization Reporter: David Vaanunu <dvaanunu>
Component: InventoryAssignee: Jeff Ortel <jortel>
Status: CLOSED ERRATA QA Contact: Ilanit Stein <istein>
Severity: medium Docs Contact: Avital Pinnick <apinnick>
Priority: unspecified    
Version: 2.1.0CC: jortel
Target Milestone: ---   
Target Release: 2.1.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2021-08-26 07:09:25 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description David Vaanunu 2021-07-13 11:24:04 UTC
Description of problem:
While add RHV provider using UI, cause the MTV UI to be stuck with error

"Danger alert:Error loading providers from inventory API
500: Internal Server Error"

While try to use 'Migration plan' get error
"Error loading providers
500: Internal Server Error"

While try to use 'Mappings' get error
"Error loading provider inventory data
500: Internal Server Error"


RHV info (scale env): ~4700VMs, 265 Hosts

Version-Release number of selected component (if applicable):

MTV_2.1.0-27
How reproducible:


Steps to Reproduce:
1. Adding RHV provider
2. After ~10-15seconds can't use MTV UI
3.

Actual results:

Can use MTV UI for ~10 minutes

Expected results:

MTV UI should be available for use

Additional info:

inventory log:

{"level":"info","ts":1626087031.6307125,"logger":"web|provider","msg":"","sql":"\nSELECT\nCOUNT(*)\nFROM DataCenter\n;\n","params":null,"url":"/providers?detail=1","error":"database is locked","stacktrace":"\ngithub.com/konveyor/controller/pkg/inventory/model.Table.Count()\n\t/remote-source/deps/gomod/pkg/mod/github.com/konveyor/controller.6/pkg/inventory/model/table.go:605\ngithub.com/konveyor/controller/pkg/inventory/model.(*Client).Count()\n\t/remote-source/deps/gomod/pkg/mod/github.com/konveyor/controller.6/pkg/inventory/model/client.go:197\ngithub.com/konveyor/forklift-controller/pkg/controller/provider/web/ovirt.ProviderHandler.AddDerived()\n\t/remote-source/app/pkg/controller/provider/web/ovirt/provider.go:139\ngithub.com/konveyor/forklift-controller/pkg/controller/provider/web/ovirt.(*ProviderHandler).ListContent()\n\t/remote-source/app/pkg/controller/provider/web/ovirt/provider.go:115\ngithub.com/konveyor/forklift-controller/pkg/controller/provider/web.ProviderHandler.List()\n\t/remote-source/app/pkg/controller/provider/web/provider.go:97\ngithub.com/gin-gonic/gin.(*Context).Next()\n\t/remote-source/deps/gomod/pkg/mod/github.com/gin-gonic/gin.3/context.go:161\ngithub.com/gin-gonic/gin.RecoveryWithWriter.func1()\n\t/remote-source/deps/gomod/pkg/mod/github.com/gin-gonic/gin.3/recovery.go:83\ngithub.com/gin-gonic/gin.(*Context).Next()\n\t/remote-source/deps/gomod/pkg/mod/github.com/gin-gonic/gin.3/context.go:161\ngithub.com/gin-gonic/gin.LoggerWithConfig.func1()\n\t/remote-source/deps/gomod/pkg/mod/github.com/gin-gonic/gin.3/logger.go:241\ngithub.com/gin-gonic/gin.(*Context).Next()\n\t/remote-source/deps/gomod/pkg/mod/github.com/gin-gonic/gin.3/context.go:161\ngithub.com/gin-gonic/gin.(*Engine).handleHTTPRequest()\n\t/remote-source/deps/gomod/pkg/mod/github.com/gin-gonic/gin.3/gin.go:409\ngithub.com/gin-gonic/gin.(*Engine).ServeHTTP()\n\t/remote-source/deps/gomod/pkg/mod/github.com/gin-gonic/gin.3/gin.go:367\nnet/http.serverHandler.ServeHTTP()\n\t/usr/lib/golang/src/net/http/server.go:2855\nnet/http.(*conn).serve()\n\t/usr/lib/golang/src/net/http/server.go:1937\nruntime.goexit()\n\t/usr/lib/golang/src/runtime/asm_amd64.s:1374"}
[GIN] 2021/07/12 - 10:50:31 | 500 |  5.010971351s |   192.168.208.1 | GET      "/providers?detail=1"
[GIN] 2021/07/12 - 10:50:39 | 500 |  5.011393588s |   192.168.208.1 | GET      "/providers?detail=1"

Comment 2 David Vaanunu 2021-08-02 12:27:44 UTC
Verify with MTV build 2.1.0-31 (IIB:91929)
Using rhv-red01 env. (~6300 VMs, 265 hosts)

Comment 5 errata-xmlrpc 2021-08-26 07:09:25 UTC
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory (Migration Toolkit for Virtualization 2.1.0), and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://access.redhat.com/errata/RHEA-2021:3278