AkkomaGang/akkoma

Fork 112

Attempting to search to populated federated timeline fails #1061

New issue

Closed

opened 2026-02-13 02:42:35 +00:00 by unktheunk · 2 comments

unktheunk commented

2026-02-13 02:42:35 +00:00

Your setup

Docker

Extra details

Rootless podman with some minor modifications to the bash scipts and such

Version

3.17.0

PostgreSQL version

What were you trying to do?

Use the search function to populate the federated timeline

What did you expect to happen?

for the search bar to produce results

What actually happened?

Search bar does not produce any results

Logs

unk@pe1:~$ cd akkoma
unk@pe1:~/akkoma$ podman compose up
>>>> Executing external compose provider "/usr/bin/podman-compose". Please see podman-compose(1) for how to disable this message. <<<<

b7f6bde33e51df9d9ed8aede19f7e619c8a006d60f24b7723027ba1025160001
bf856678afc49b309c2a9f589d4c8758dd936eb652ed65e65978e43d4dfeb1a7
9f911dffe91ccceb1603786a35b22a632f7aae47b970c5797e7283432675ff63
[db]     |
[db]     | PostgreSQL Database directory appears to contain a database; Skipping initialization
[db]     |
[db]     | 2026-02-13 02:17:23.961 UTC [1] LOG:  starting PostgreSQL 15.15 (Debian 15.15-1.pgdg13+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 14.2.0-19) 14.2.0, 64-bit
[db]     | 2026-02-13 02:17:23.961 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
[db]     | 2026-02-13 02:17:23.961 UTC [1] LOG:  listening on IPv6 address "::", port 5432
[db]     | 2026-02-13 02:17:23.962 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
[db]     | 2026-02-13 02:17:23.966 UTC [24] LOG:  database system was shut down at 2026-02-12 21:09:25 UTC
[db]     | 2026-02-13 02:17:23.973 UTC [1] LOG:  database system is ready to accept connections
[akkoma] | -- Waiting for database...
[akkoma] | db:5432 - accepting connections
[akkoma] | -- Running migrations...
[akkoma] |
[akkoma] | 02:17:26.116 [info] Migrations already up
[akkoma] | -- Starting!
[akkoma] |
[akkoma] | 02:17:28.283 [notice]     :alarm_handler: {:set, {:system_memory_high_watermark, []}}
[akkoma] |
[akkoma] | 02:17:31.207 [info] Running Pleroma.Web.Endpoint with cowboy 2.14.2 at 0.0.0.0:4000 (http)
[akkoma] |
[akkoma] | 02:17:31.207 [info] Access Pleroma.Web.Endpoint at https://99finches.com
[db]     | 2026-02-13 02:17:36.395 UTC [41] ERROR:  duplicate key value violates unique constraint "users_nickname_index"
[db]     | 2026-02-13 02:17:36.395 UTC [41] DETAIL:  Key (nickname)=(internal.fetch) already exists.
[db]     | 2026-02-13 02:17:36.395 UTC [41] STATEMENT:  INSERT INTO "users" ("hide_followers_count","hide_follows","tags","follower_count","banner","following_count","no_rich_text","default_scope","also_known_as","pleroma_settings_store","avatar","is_suggested","raw_fields","is_admin","disclose_client","hide_favorites","local","password_reset_pending","allow_following_move","is_locked","hide_followers","background","permit_followback","hide_follows_count","is_active","show_role","email_notifications","bio","emoji","is_moderator","is_approved","skip_thread_containment","fields","ap_id","is_confirmed","actor_type","nickname","note_count","domain_blocks","invisible","accepts_direct_messages_from","pinned_objects","is_discoverable","id","inserted_at","updated_at") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46)
[akkoma] |
[akkoma] | 02:17:36.413 [error] Cannot create service actor: https://99finches.com/internal/fetch/.
[akkoma] | [nickname: {"has already been taken", [constraint: :unique, constraint_name: "users_nickname_index"]}]
[db]     | 2026-02-13 02:22:24.065 UTC [22] LOG:  checkpoint starting: time
[db]     | 2026-02-13 02:22:24.774 UTC [22] LOG:  checkpoint complete: wrote 11 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.704 s, sync=0.001 s, total=0.709 s; sync files=8, longest=0.001 s, average=0.001 s; distance=79 kB, estimate=79 kB
[db]     | 2026-02-13 02:26:08.843 UTC [39] ERROR:  duplicate key value violates unique constraint "users_nickname_index"
[db]     | 2026-02-13 02:26:08.843 UTC [39] DETAIL:  Key (nickname)=(internal.fetch) already exists.
[db]     | 2026-02-13 02:26:08.843 UTC [39] STATEMENT:  INSERT INTO "users" ("hide_followers_count","hide_follows","tags","follower_count","banner","following_count","no_rich_text","default_scope","also_known_as","pleroma_settings_store","avatar","is_suggested","raw_fields","is_admin","disclose_client","hide_favorites","local","password_reset_pending","allow_following_move","is_locked","hide_followers","background","permit_followback","hide_follows_count","is_active","show_role","email_notifications","bio","emoji","is_moderator","is_approved","skip_thread_containment","fields","ap_id","is_confirmed","actor_type","nickname","note_count","domain_blocks","invisible","accepts_direct_messages_from","pinned_objects","is_discoverable","id","inserted_at","updated_at") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46)
[akkoma] |
[akkoma] | 02:26:08.844 [error] Cannot create service actor: https://99finches.com/internal/fetch/.
[akkoma] | [nickname: {"has already been taken", [constraint: :unique, constraint_name: "users_nickname_index"]}]
[db]     | 2026-02-13 02:26:08.845 UTC [45] ERROR:  duplicate key value violates unique constraint "users_nickname_index"
[db]     | 2026-02-13 02:26:08.845 UTC [45] DETAIL:  Key (nickname)=(internal.fetch) already exists.
[db]     | 2026-02-13 02:26:08.845 UTC [45] STATEMENT:  INSERT INTO "users" ("hide_followers_count","hide_follows","tags","follower_count","banner","following_count","no_rich_text","default_scope","also_known_as","pleroma_settings_store","avatar","is_suggested","raw_fields","is_admin","disclose_client","hide_favorites","local","password_reset_pending","allow_following_move","is_locked","hide_followers","background","permit_followback","hide_follows_count","is_active","show_role","email_notifications","bio","emoji","is_moderator","is_approved","skip_thread_containment","fields","ap_id","is_confirmed","actor_type","nickname","note_count","domain_blocks","invisible","accepts_direct_messages_from","pinned_objects","is_discoverable","id","inserted_at","updated_at") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46)
[akkoma] |
[akkoma] | 02:26:08.845 [error] Cannot create service actor: https://99finches.com/internal/fetch/.
[akkoma] | [nickname: {"has already been taken", [constraint: :unique, constraint_name: "users_nickname_index"]}]
[akkoma] |
[akkoma] | 02:26:08.859 [error] Elixir.Pleroma.Web.MastodonAPI.SearchController search error: %FunctionClauseError{module: Pleroma.User.SigningKey, function: :load_key, arity: 1, kind: nil, args: nil, clauses: nil}
[db]     | 2026-02-13 02:26:08.901 UTC [43] ERROR:  duplicate key value violates unique constraint "users_nickname_index"
[db]     | 2026-02-13 02:26:08.901 UTC [43] DETAIL:  Key (nickname)=(internal.fetch) already exists.
[db]     | 2026-02-13 02:26:08.901 UTC [43] STATEMENT:  INSERT INTO "users" ("hide_followers_count","hide_follows","tags","follower_count","banner","following_count","no_rich_text","default_scope","also_known_as","pleroma_settings_store","avatar","is_suggested","raw_fields","is_admin","disclose_client","hide_favorites","local","password_reset_pending","allow_following_move","is_locked","hide_followers","background","permit_followback","hide_follows_count","is_active","show_role","email_notifications","bio","emoji","is_moderator","is_approved","skip_thread_containment","fields","ap_id","is_confirmed","actor_type","nickname","note_count","domain_blocks","invisible","accepts_direct_messages_from","pinned_objects","is_discoverable","id","inserted_at","updated_at") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46)
[akkoma] |
[akkoma] | 02:26:08.902 [error] Cannot create service actor: https://99finches.com/internal/fetch/.
[akkoma] | [nickname: {"has already been taken", [constraint: :unique, constraint_name: "users_nickname_index"]}]
[akkoma] |
[akkoma] | 02:26:08.902 [error] Elixir.Pleroma.Web.MastodonAPI.SearchController search error: %FunctionClauseError{module: Pleroma.User.SigningKey, function: :load_key, arity: 1, kind: nil, args: nil, clauses: nil}

Severity

I cannot use the software

Have you searched for this issue?

I have double-checked and have not found this issue mentioned anywhere.

### Your setup Docker ### Extra details Rootless podman with some minor modifications to the bash scipts and such ### Version 3.17.0 ### PostgreSQL version 15 ### What were you trying to do? Use the search function to populate the federated timeline ### What did you expect to happen? for the search bar to produce results ### What actually happened? Search bar does not produce any results ### Logs ```shell unk@pe1:~$ cd akkoma unk@pe1:~/akkoma$ podman compose up >>>> Executing external compose provider "/usr/bin/podman-compose". Please see podman-compose(1) for how to disable this message. <<<< b7f6bde33e51df9d9ed8aede19f7e619c8a006d60f24b7723027ba1025160001 bf856678afc49b309c2a9f589d4c8758dd936eb652ed65e65978e43d4dfeb1a7 9f911dffe91ccceb1603786a35b22a632f7aae47b970c5797e7283432675ff63 [db] | [db] | PostgreSQL Database directory appears to contain a database; Skipping initialization [db] | [db] | 2026-02-13 02:17:23.961 UTC [1] LOG: starting PostgreSQL 15.15 (Debian 15.15-1.pgdg13+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 14.2.0-19) 14.2.0, 64-bit [db] | 2026-02-13 02:17:23.961 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432 [db] | 2026-02-13 02:17:23.961 UTC [1] LOG: listening on IPv6 address "::", port 5432 [db] | 2026-02-13 02:17:23.962 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" [db] | 2026-02-13 02:17:23.966 UTC [24] LOG: database system was shut down at 2026-02-12 21:09:25 UTC [db] | 2026-02-13 02:17:23.973 UTC [1] LOG: database system is ready to accept connections [akkoma] | -- Waiting for database... [akkoma] | db:5432 - accepting connections [akkoma] | -- Running migrations... [akkoma] | [akkoma] | 02:17:26.116 [info] Migrations already up [akkoma] | -- Starting! [akkoma] | [akkoma] | 02:17:28.283 [notice] :alarm_handler: {:set, {:system_memory_high_watermark, []}} [akkoma] | [akkoma] | 02:17:31.207 [info] Running Pleroma.Web.Endpoint with cowboy 2.14.2 at 0.0.0.0:4000 (http) [akkoma] | [akkoma] | 02:17:31.207 [info] Access Pleroma.Web.Endpoint at https://99finches.com [db] | 2026-02-13 02:17:36.395 UTC [41] ERROR: duplicate key value violates unique constraint "users_nickname_index" [db] | 2026-02-13 02:17:36.395 UTC [41] DETAIL: Key (nickname)=(internal.fetch) already exists. [db] | 2026-02-13 02:17:36.395 UTC [41] STATEMENT: INSERT INTO "users" ("hide_followers_count","hide_follows","tags","follower_count","banner","following_count","no_rich_text","default_scope","also_known_as","pleroma_settings_store","avatar","is_suggested","raw_fields","is_admin","disclose_client","hide_favorites","local","password_reset_pending","allow_following_move","is_locked","hide_followers","background","permit_followback","hide_follows_count","is_active","show_role","email_notifications","bio","emoji","is_moderator","is_approved","skip_thread_containment","fields","ap_id","is_confirmed","actor_type","nickname","note_count","domain_blocks","invisible","accepts_direct_messages_from","pinned_objects","is_discoverable","id","inserted_at","updated_at") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46) [akkoma] | [akkoma] | 02:17:36.413 [error] Cannot create service actor: https://99finches.com/internal/fetch/. [akkoma] | [nickname: {"has already been taken", [constraint: :unique, constraint_name: "users_nickname_index"]}] [db] | 2026-02-13 02:22:24.065 UTC [22] LOG: checkpoint starting: time [db] | 2026-02-13 02:22:24.774 UTC [22] LOG: checkpoint complete: wrote 11 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.704 s, sync=0.001 s, total=0.709 s; sync files=8, longest=0.001 s, average=0.001 s; distance=79 kB, estimate=79 kB [db] | 2026-02-13 02:26:08.843 UTC [39] ERROR: duplicate key value violates unique constraint "users_nickname_index" [db] | 2026-02-13 02:26:08.843 UTC [39] DETAIL: Key (nickname)=(internal.fetch) already exists. [db] | 2026-02-13 02:26:08.843 UTC [39] STATEMENT: INSERT INTO "users" ("hide_followers_count","hide_follows","tags","follower_count","banner","following_count","no_rich_text","default_scope","also_known_as","pleroma_settings_store","avatar","is_suggested","raw_fields","is_admin","disclose_client","hide_favorites","local","password_reset_pending","allow_following_move","is_locked","hide_followers","background","permit_followback","hide_follows_count","is_active","show_role","email_notifications","bio","emoji","is_moderator","is_approved","skip_thread_containment","fields","ap_id","is_confirmed","actor_type","nickname","note_count","domain_blocks","invisible","accepts_direct_messages_from","pinned_objects","is_discoverable","id","inserted_at","updated_at") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46) [akkoma] | [akkoma] | 02:26:08.844 [error] Cannot create service actor: https://99finches.com/internal/fetch/. [akkoma] | [nickname: {"has already been taken", [constraint: :unique, constraint_name: "users_nickname_index"]}] [db] | 2026-02-13 02:26:08.845 UTC [45] ERROR: duplicate key value violates unique constraint "users_nickname_index" [db] | 2026-02-13 02:26:08.845 UTC [45] DETAIL: Key (nickname)=(internal.fetch) already exists. [db] | 2026-02-13 02:26:08.845 UTC [45] STATEMENT: INSERT INTO "users" ("hide_followers_count","hide_follows","tags","follower_count","banner","following_count","no_rich_text","default_scope","also_known_as","pleroma_settings_store","avatar","is_suggested","raw_fields","is_admin","disclose_client","hide_favorites","local","password_reset_pending","allow_following_move","is_locked","hide_followers","background","permit_followback","hide_follows_count","is_active","show_role","email_notifications","bio","emoji","is_moderator","is_approved","skip_thread_containment","fields","ap_id","is_confirmed","actor_type","nickname","note_count","domain_blocks","invisible","accepts_direct_messages_from","pinned_objects","is_discoverable","id","inserted_at","updated_at") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46) [akkoma] | [akkoma] | 02:26:08.845 [error] Cannot create service actor: https://99finches.com/internal/fetch/. [akkoma] | [nickname: {"has already been taken", [constraint: :unique, constraint_name: "users_nickname_index"]}] [akkoma] | [akkoma] | 02:26:08.859 [error] Elixir.Pleroma.Web.MastodonAPI.SearchController search error: %FunctionClauseError{module: Pleroma.User.SigningKey, function: :load_key, arity: 1, kind: nil, args: nil, clauses: nil} [db] | 2026-02-13 02:26:08.901 UTC [43] ERROR: duplicate key value violates unique constraint "users_nickname_index" [db] | 2026-02-13 02:26:08.901 UTC [43] DETAIL: Key (nickname)=(internal.fetch) already exists. [db] | 2026-02-13 02:26:08.901 UTC [43] STATEMENT: INSERT INTO "users" ("hide_followers_count","hide_follows","tags","follower_count","banner","following_count","no_rich_text","default_scope","also_known_as","pleroma_settings_store","avatar","is_suggested","raw_fields","is_admin","disclose_client","hide_favorites","local","password_reset_pending","allow_following_move","is_locked","hide_followers","background","permit_followback","hide_follows_count","is_active","show_role","email_notifications","bio","emoji","is_moderator","is_approved","skip_thread_containment","fields","ap_id","is_confirmed","actor_type","nickname","note_count","domain_blocks","invisible","accepts_direct_messages_from","pinned_objects","is_discoverable","id","inserted_at","updated_at") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45,$46) [akkoma] | [akkoma] | 02:26:08.902 [error] Cannot create service actor: https://99finches.com/internal/fetch/. [akkoma] | [nickname: {"has already been taken", [constraint: :unique, constraint_name: "users_nickname_index"]}] [akkoma] | [akkoma] | 02:26:08.902 [error] Elixir.Pleroma.Web.MastodonAPI.SearchController search error: %FunctionClauseError{module: Pleroma.User.SigningKey, function: :load_key, arity: 1, kind: nil, args: nil, clauses: nil} ``` ### Severity I cannot use the software ### Have you searched for this issue? - [x] I have double-checked and have not found this issue mentioned anywhere.

unktheunk added the

bug

label

2026-02-13 02:42:35 +00:00

Oneric commented

2026-02-13 12:51:54 +00:00

Owner

[db]     | 2026-02-13 02:17:36.395 UTC [41] ERROR:  duplicate key value violates unique constraint "users_nickname_index"
[db]     | 2026-02-13 02:17:36.395 UTC [41] DETAIL:  Key (nickname)=(internal.fetch) already exists.

[akkoma] | 02:17:36.413 [error] Cannot create service actor: https://99finches.com/internal/fetch/.
[akkoma] | [nickname: {"has already been taken", [constraint: :unique, constraint_name: "users_nickname_index"]}]

The database of your instance is messed up. Either you manually did some funny SQL modifications or you changed the endpoint URL of the instance after having already run it.
Now an instance actor exists in your db, but the properties don't match what’s expected of the current config and thus it won’t be found. Since it is present though a new one also cannot be created. Without an instance actor you cannot fetch anything.

You’ll have to manually fix this (delete the old actor and everything connected to it) as well as all other existing db discrepancies, or start anew.

``` [db] | 2026-02-13 02:17:36.395 UTC [41] ERROR: duplicate key value violates unique constraint "users_nickname_index" [db] | 2026-02-13 02:17:36.395 UTC [41] DETAIL: Key (nickname)=(internal.fetch) already exists. [akkoma] | 02:17:36.413 [error] Cannot create service actor: https://99finches.com/internal/fetch/. [akkoma] | [nickname: {"has already been taken", [constraint: :unique, constraint_name: "users_nickname_index"]}] ``` The database of your instance is messed up. Either you manually did some funny SQL modifications or you changed the endpoint URL of the instance after having already run it. Now an instance actor exists in your db, but the properties don't match what’s expected of the current config and thus it won’t be found. Since it _is_ present though a new one also cannot be created. Without an instance actor you cannot fetch anything. You’ll have to manually fix this *(delete the old actor and everything connected to it)* as well as all other existing db discrepancies, or start anew.

Oneric removed the

bug

label

2026-02-13 12:52:11 +00:00

Oneric changed title from ~~[bug] Attempting to search to populated federated timeline fails~~ to Attempting to search to populated federated timeline fails

2026-02-13 12:52:23 +00:00

Oneric added the

broken setup

label

2026-02-13 12:54:58 +00:00

unktheunk commented

2026-02-15 02:40:37 +00:00

Author

redoing the install worked. Thanks for your help

unktheunk closed this issue

2026-02-15 02:40:38 +00:00