Clean up mx-puppet-discord and Synapse database #113

New issue

Closed

opened 2022-02-19 21:40:36 +00:00 by a · 4 comments

a commented

2022-02-19 21:40:36 +00:00

Owner

After a mx-puppet-discord update, it's not working anymore, so I think we just need to clean up the Synapse database.

a added the

bug

label 2022-02-19 21:40:36 +00:00

a self-assigned this 2022-02-19 21:40:36 +00:00

a added this to the (deleted) project 2022-02-19 21:40:36 +00:00

a commented

2022-02-19 23:29:23 +00:00

Author

Owner

I cleaned up the users table of the database but I don't want to touch anything else to avoid breaking it.

I cleaned up the `users` table of the database but I don't want to touch anything else to avoid breaking it.

a started working 2022-02-19 23:29:26 +00:00

a commented

2022-02-20 01:02:12 +00:00

Author

Owner

Uh oh, I cleaned out the users table and now I'm getting [bot-sdk-Appservice] error: Encountered error registering user:

Uh oh, I cleaned out the users table and now I'm getting `[bot-sdk-Appservice] error: Encountered error registering user:`

a stopped working 2022-02-20 01:02:20 +00:00

1h 32min 54s

a commented

2022-02-20 01:40:00 +00:00

Author

Owner

psycopg2.errors.UniqueViolation: duplicate key value violates unique constraint "profiles_user_id_key"
                                         DETAIL:  Key (user_id)=(_discordpuppet_bot) already exists.

Yeah I think I screwed something up even more badly now.

``` psycopg2.errors.UniqueViolation: duplicate key value violates unique constraint "profiles_user_id_key" DETAIL: Key (user_id)=(_discordpuppet_bot) already exists. ``` Yeah I think I screwed something up even more badly now.

a started working 2022-02-20 01:41:48 +00:00

a closed this issue

2022-02-20 01:48:10 +00:00

a stopped working 2022-02-20 01:48:10 +00:00

6min 22s

a commented

2022-02-20 01:50:07 +00:00

Author

Owner

Now there are just a few warnings such as [bot-sdk-Appservice] warn: Error registering user: User ID is in use and [RoomSync] warn: No OP in room and [UserSync] warn: Room MXID not found that still show up, but I can troubleshoot those later.

Now there are just a few warnings such as `[bot-sdk-Appservice] warn: Error registering user: User ID is in use` and `[RoomSync] warn: No OP in room` and `[UserSync] warn: Room MXID not found` that still show up, but I can troubleshoot those later.