Hi Facing issue with signoz

Question

Hi < C02271GFA4F|k8s operator helm> Facing issue with signoz query service prod signoz query service 0 0 1 CrashLoopBackOff 7 Upon checking logs I found ```2022 05 24T05 34 45 277Z FATAL query service main go 55 Failed to create server error 26 0 failed to initialize DB Found 2 organizations expected one or none main main``` Not sure If someone has created another org as admin access was given to a few people I can delete the organizations table but to do so I need to login to query service Is there a way to resolve this

Prashant Shahi · Answer

Hey Hima I think the issue is related to the previous solution where manual deletion of admin user was done < Vishal Sharma> could you help to resolve this

Hima Vyas · Answer

But that won t work directly here right As I am not able to get in the query service pod Ref solution for admin deletion <https signoz community slack com archives C01HWQ1R0BC p1652162248013329>

Hima Vyas · Answer

We have planned an internal demo of signoz for all our tech people If you can guide here quickly I have data of last 15 days and it was a working setup in prod I think someone tried to add an org or some changes from UI and after that query service pod is not starting up Apologies for an urgent request

Prashant Shahi · Answer

< Hima Vyas> we can get on a quick call huddle to resolve this if that works for you

Hima Vyas · Answer

Thanks a ton < Prashant Shahi> It s working for me Really appreciate

Prashant Shahi · Answer

That s great to hear tada