spla/appy
2
15
Fork
You've already forked appy
3

duplicate key value violates unique constraint "index_accounts_on_username_and_domain_lower #32

Closed
opened 2025年04月03日 19:02:20 +02:00 by spla · 0 comments
Owner
Copy link

when an unkown and non followed remote user replies followed remote user posts, appy throws this at activities.create:shared_inbox_create_activity:183:

duplicate key value violates unique constraint "index_accounts_on_username_and_domain_lower
DETAIL: Key (lower(username::text), COALESCE(lower(domain::text), ''::text))=(remote_unknown_user, remote_unkown_user_domain) already exists.

and after above, it throws this following error at libraries.asyncdb:save_status:3876:

insert or update on table "statuses" violates foreign key constraint "fk_account_id"
DETAIL: Key (account_id)=(0) is not present in table "accounts"
when an unkown and non followed remote user replies followed remote user posts, appy throws this at ```activities.create:shared_inbox_create_activity:183```: ``` duplicate key value violates unique constraint "index_accounts_on_username_and_domain_lower DETAIL: Key (lower(username::text), COALESCE(lower(domain::text), ''::text))=(remote_unknown_user, remote_unkown_user_domain) already exists. ``` and after above, it throws this following error at ```libraries.asyncdb:save_status:3876```: ``` insert or update on table "statuses" violates foreign key constraint "fk_account_id" DETAIL: Key (account_id)=(0) is not present in table "accounts" ```
spla referenced this issue from a commit 2025年04月17日 12:33:15 +02:00
Sign in to join this conversation.
No Branch/Tag specified
main
release/v0.1.1
release/v0.1
v0.5.0
v0.4.0
v0.3.0
v0.2.0
v0.1.1
v0.1
Milestone
Clear milestone
No items
No milestone
Projects
Clear projects
No items
No project
Assignees
Clear assignees
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
spla/appy#32
Reference in a new issue
spla/appy
No description provided.
Delete branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?