Exception SqlError {sqlState = "42P01", sqlExecStatus = FatalError, sqlErrorMsg = "relation \"utxo_view\" does not exist", sqlErrorDetail = "", sqlErrorHint = ""} while handling request Request {requestMethod = "GET", httpVersion = HTTP/1.1, rawPathInfo = "/ada-holder/get-voting-power/e1a98e2fd401ec7d79116f658dd73b22dcbe65af05afb272db55bc934c", rawQueryString = "", requestHeaders = [("Host","be.gov.tools"),("X-Request-ID","bf835ef5d61d9a46403235e086812b93"),("X-Real-IP","49.205.242.123"),("X-Forwarded-For","49.205.242.123"),("X-Forwarded-Host","be.gov.tools"),("X-Forwarded-Port","443"),("X-Forwarded-Proto","https"),("X-Forwarded-Scheme","https"),("X-Scheme","https"),("sec-ch-ua-platform","\"macOS\""),("user-agent","Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36"),("accept","application/json, text/plain, */*"),("sec-ch-ua","\"Google Chrome\";v=\"131\", \"Chromium\";v=\"131\", \"Not_A Brand\";v=\"24\""),("sec-ch-ua-mobile","?0"),("origin","https://gov.tools"),("sec-fetch-site","same-site"),("sec-fetch-mode","cors"),("sec-fetch-dest","empty"),("referer","https://gov.tools/"),("accept-encoding","gzip, deflate, br, zstd"),("accept-language","en-US,en;q=0.9"),("priority","u=1, i")], isSecure = False, remoteHost = 10.0.43.78:54208, pathInfo = ["ada-holder","get-voting-power","e1a98e2fd401ec7d79116f658dd73b22dcbe65af05afb272db55bc934c"], queryString = [], requestBody = <IO ByteString>, vault = <Vault>, requestBodyLength = KnownLength 0, requestHeaderHost = Just "be.gov.tools", requestHeaderRange = Nothing}
So to fix that we need to ensure that table exist and on the code level, we need to handle that exception in any case where SQL execution fails.
Sentry Issue: GOVTOOL-BACKEND-18X
This bug is caused by missing
utxo_viewtable from which we calculate the ada holder voting power.So to fix that we need to ensure that table exist and on the code level, we need to handle that exception in any case where SQL execution fails.