https://github.com/osquery/osquery logo
#fleet
Title
# fleet
s

SK

10/06/2021, 9:09 AM
Hello all, in 4.3.1 when I try to open the Policies page I get below error, how can I fix this?
t

Tomas Touceda

10/06/2021, 10:38 AM
hello, could you check the devtools on the network tab to see what API is failing? also logs from fleet serve would be useful. The usual suspect in these cases is migrations that haven't run
g

Gavin

10/06/2021, 10:39 AM
4.3.1 still had the update every checkin bug which was fixed in 4.3.2 resulting in the DB growing and then a timeout which I had.
s

SK

10/06/2021, 12:55 PM
I will upgrade to 4.3.2 and check if issue is solved, will also take a look in the devtools @Tomas Touceda @Gavin Thanks
r

ryan

10/06/2021, 1:15 PM
4.3.2 resolved this for me too
s

SK

10/06/2021, 1:24 PM
Thanks for the info @ryan will upgrade asap 😉
After upgrading to 4.4.0 I still see same issue and cannot create a policy. Also noticed
prepare db
takes quite some minutes to complete, not sure if it is succesfull. Any way to troubleshoot this?
t

Tomas Touceda

10/07/2021, 2:40 PM
yes, please share logs for fleet serve and also the API call in the network tab in dev tools from your browser to see what the error is
s

SK

10/07/2021, 2:48 PM
Checking the dev tools seems to make it quite clear 😮
Copy code
{
  "message": "Validation Failed",
  "errors": [
    {
      "name": "base",
      "reason": "Error 1146: Table 'db.policies' doesn't exist"
    }
  ]
}
Status 422 No Reason Phrase
t

Tomas Touceda

10/07/2021, 2:50 PM
so the migrations haven't finished correctly, are you running any fleet instances while you are doing the prepare?
s

SK

10/07/2021, 2:54 PM
Will need to check, maybe forgot one online before updating, will test it now see if that helps the issue.
prepare db
solved it for me, probably the last time didn't go well
t

Tomas Touceda

10/07/2021, 3:22 PM
great!
5 Views