i believe we tried upgrading the chart and signoz-query-service wont spin up correctly, alert yaml looks fine and is parsed, so why the crash?

You probably missed the migration? https://signoz.io/docs/operate/migration/upgrade-0.19/