SigNoz is an open-source APM. It helps developers monitor their applications & troubleshoot problems, an open-source alternative to DataDog, NewRelic, etc.

SigNoz Community

Screenshot 2022-06-21 110437.png

Hi guys,
I'm facing this issue in query service, while composing up signoz, I had previously manually deleted user from db.

<@U03DCT4HCQY> which version of SigNoz are you on?

You can exec inside query-service container and remove duplicate organisation (preferably older org):
```docker exec -it query-service sh```
OR
```kubectl -n platform exec -it pod/my-release-signoz-query-service-0 -- sh```

Run the following:
```# install sqlite
apk update
apk add sqlite

# open sqlite with signoz.db
sqlite3 /var/lib/signoz/signoz.db

# (sqlite shell) check existing organizations
select * from organizations;

# (sqlite shell) delete duplicate organization
delete from organizations where name=duplicate-org-name;

# (sqlite shell) verify org deletion
select * from organizations;

# press CTRL + D to exit from sqlite shell
# safely exit from the query-service container
exit```

The problem is, I can't exec because the container keeps restarting

You will need to install `sqlite` locally in that scenerio.

And follow steps from "open sqlite with signoz.db"

Is there a way for me to hard reset the application, clearing the db entirely, without any installation?

If not, you can go ahead and delete `signoz.db` file.

Isn't the signoz.db created inside the container?

I won't be able to find the signoz.db locally because of the above reason right?

It is not, you can find signoz.db here =&gt; deploy/docker/clickhouse-setup/data/signoz/signoz.db

What's the status of Postgres support? I saw a pr for it and it would be super helpful 

We are currently working on it.

You can track the progress here:
<https://github.com/SigNoz/signoz/pull/1192>

Gotcha I saw it was about a month old without any changes recently so was just curious :relaxed:

I am not getting invite email sent by the admin. Correct address.

<@U033UMXBGLX> There is no email sent. You should ask admin to send you invite link and then you can create your password for login