04/08/2022, 3:22 AM
Hi everyone 👋 I just upgraded from fleet
, did all the DB migrations and everything is working except in the UI when navigating to the queries page (/queries/manage) I get
500: Oh, something went wrong. Please file an issue if you believe this is a bug.
all the api hits to the server are 200's. I can do everything from the command line without error including
fleetctl get queries --yaml
so this appears to be a UI bug. I'm getting this chrome console error:
Syntax error found near Column Identifier (WHERE Clause)
3:23 AM
"SyntaxError: Syntax error found near Column Identifier (WHERE Clause)
    at C (<https://fleet.quiq.sh/assets/bundle-81aa769e462f09d14dc5.js:31:485195>)
    at parse (<https://fleet.quiq.sh/assets/bundle-81aa769e462f09d14dc5.js:31:488961>)
    at o (<https://fleet.quiq.sh/assets/bundle-81aa769e462f09d14dc5.js:31:413777>)
    at <https://fleet.quiq.sh/assets/bundle-81aa769e462f09d14dc5.js:40:868794>
    at Bm (<https://fleet.quiq.sh/assets/bundle-81aa769e462f09d14dc5.js:40:868880>)
    at sg (<https://fleet.quiq.sh/assets/bundle-81aa769e462f09d14dc5.js:40:876544>)
    at <https://fleet.quiq.sh/assets/bundle-81aa769e462f09d14dc5.js:40:877013>
    at Array.map (<anonymous>)
    at <https://fleet.quiq.sh/assets/bundle-81aa769e462f09d14dc5.js:40:877006>
    at Object.po [as useMemo] (<https://fleet.quiq.sh/assets/bundle-81aa769e462f09d14dc5.js:48:61567>)"
3:27 AM
happy to gather more information if that's helpful or I can file a github issue
3:36 AM
Looks like that error is coming from this js module: https://www.npmjs.com/package/sqlite-parser
3:46 AM
Let me know if you have any ideas, or a way to see which of my queries it doesn't like.

Stephan M

04/08/2022, 4:40 AM
Not sure if it's the same issue but we recently ran into this as well and it was because one of our queries had a syntax error. This was gracefully handled in the past but with the latest version of fleet results in a 5xx. We also found that fleetctl will let you add a query with invalid syntax which then makes the UI fail. We removed the broken query from the queries table in the DB


04/08/2022, 5:37 AM
we have 300 queries any good way to narrow it down?
Tomas Touceda

Tomas Touceda

04/08/2022, 2:13 PM
hi ryan! sorry to hear you're having an issue with fleet. We are going to be looking into it


04/08/2022, 2:20 PM
Sounds great, thanks @Tomas Touceda! Let me know if you need any other information from me.
Luke Heath

Luke Heath

04/08/2022, 2:34 PM
@Stephan M Thanks for letting us know! I will look into this.