precompiled version db can't imgrate to compiled db [compiled by elixir 1.15.7 or later]
This is my build log. https://web.archive.org/web/20231204032554/https://build.malacology.net/api/pkg/pleroma/log/1698812320
Following is my running log, but I use what you compile, things run well, but for what I compiled, sth face problems, is this the issue that I previously use pre-build binary, now I use compiled binary?
It seems that the db generated from OTP release can't imgrate to the binary what I compiled
Renew log can be checked here https://web.archive.org/web/20231204032515/http://fars.ee/kHDY still [debug] for days.
Jun 02 04:04:07 helix systemd[1]: pleroma.service: Found left-over process 497 (epmd) in control group while starting unit. Ignoring.
Jun 02 04:04:07 helix systemd[1]: This usually indicates unclean termination of a previous run, or service implementation deficiencies.
Jun 02 04:04:07 helix systemd[1]: Started Pleroma social network.
Jun 02 04:04:10 helix pleroma[1783]: [notice] :alarm_handler: {:set, {:system_memory_high_watermark, []}}
Jun 02 04:04:10 helix pleroma[1783]: [info] Function passed as a handler with ID "pleroma-logger" is local function.
Jun 02 04:04:10 helix pleroma[1783]: This mean that it is either anonymous function or capture of function without module specified. That may cause performance penalty when calling such handler. For more details see note in `telemetry:attach/4` documentation.
Jun 02 04:04:10 helix pleroma[1783]: https://hexdocs.pm/telemetry/telemetry.html#attach-4
Jun 02 04:04:11 helix pleroma[1783]: [debug] QUERY OK source="columns" db=7.1ms queue=12.7ms idle=0.0ms
Jun 02 04:04:11 helix pleroma[1783]: SELECT TRUE FROM "information_schema"."columns" AS c0 WHERE (c0."table_name" = 'objects') AND (c0."column_name" = 'fts_content') LIMIT 1 []
Jun 02 04:04:11 helix pleroma[1783]: [info] Function passed as a handler with ID "telemetry_web__event_handler" is local function.
Jun 02 04:04:11 helix pleroma[1783]: This mean that it is either anonymous function or capture of function without module specified. That may cause performance penalty when calling such handler. For more details see note in `telemetry:attach/4` documentation.
Jun 02 04:04:11 helix pleroma[1783]: https://hexdocs.pm/telemetry/telemetry.html#attach-4
Jun 02 04:04:11 helix pleroma[1783]: [debug] Elixir.Pleroma.Web.ActivityPub.MRF.MediaProxyWarmingPolicy is excluded from config descriptions, because does not implement `config_description/0` method.
Jun 02 04:04:11 helix pleroma[1783]: [debug] Elixir.Pleroma.Web.ActivityPub.MRF.ForceMentionsInContent is excluded from config descriptions, because does not implement `config_description/0` method.
Jun 02 04:04:11 helix pleroma[1783]: [debug] Elixir.Pleroma.Web.ActivityPub.MRF.DropPolicy is excluded from config descriptions, because does not implement `config_description/0` method.
Jun 02 04:04:11 helix pleroma[1783]: [debug] Elixir.Pleroma.Web.ActivityPub.MRF.TagPolicy is excluded from config descriptions, because does not implement `config_description/0` method.
Jun 02 04:04:11 helix pleroma[1783]: [debug] Elixir.Pleroma.Web.ActivityPub.MRF.NoPlaceholderTextPolicy is excluded from config descriptions, because does not implement `config_description/0` method.
Jun 02 04:04:11 helix pleroma[1783]: [debug] Elixir.Pleroma.Web.ActivityPub.MRF.ForceBotUnlistedPolicy is excluded from config descriptions, because does not implement `config_description/0` method.
Jun 02 04:04:11 helix pleroma[1783]: [debug] Elixir.Pleroma.Web.ActivityPub.MRF.EnsureRePrepended is excluded from config descriptions, because does not implement `config_description/0` method.
Jun 02 04:04:11 helix pleroma[1783]: [debug] Elixir.Pleroma.Web.ActivityPub.MRF.AntiLinkSpamPolicy is excluded from config descriptions, because does not implement `config_description/0` method.
Jun 02 04:04:11 helix pleroma[1783]: [debug] Elixir.Pleroma.Web.ActivityPub.MRF.AntiFollowbotPolicy is excluded from config descriptions, because does not implement `config_description/0` method.
Jun 02 04:04:11 helix pleroma[1783]: [debug] Elixir.Pleroma.Web.ActivityPub.MRF.FollowBotPolicy is excluded from config descriptions, because does not implement `config_description/0` method.
Jun 02 04:04:11 helix pleroma[1783]: [debug] Elixir.Pleroma.Web.ActivityPub.MRF.NoEmptyPolicy is excluded from config descriptions, because does not implement `config_description/0` method.
Jun 02 04:04:11 helix pleroma[1783]: [debug] Elixir.Pleroma.Web.ActivityPub.MRF.UserAllowListPolicy is excluded from config descriptions, because does not implement `config_description/0` method.
Jun 02 04:04:11 helix pleroma[1783]: [debug] Elixir.Pleroma.Web.ActivityPub.MRF.NoOpPolicy is excluded from config descriptions, because does not implement `config_description/0` method.
Jun 02 04:04:11 helix pleroma[1783]: [debug] QUERY OK source="config" db=3.2ms queue=7.1ms idle=0.0ms
Jun 02 04:04:11 helix pleroma[1783]: SELECT c0."id", c0."key", c0."group", c0."value", c0."inserted_at", c0."updated_at" FROM "config" AS c0 []
Jun 02 04:04:11 helix pleroma[1783]: [info] Function passed as a handler with ID "oban-monitor-failure" is local function.
Jun 02 04:04:11 helix pleroma[1783]: This mean that it is either anonymous function or capture of function without module specified. That may cause performance penalty when calling such handler. For more details see note in `telemetry:attach/4` documentation.
Jun 02 04:04:11 helix pleroma[1783]: https://hexdocs.pm/telemetry/telemetry.html#attach-4
Jun 02 04:04:11 helix pleroma[1783]: [info] Function passed as a handler with ID "oban-monitor-success" is local function.
Jun 02 04:04:11 helix pleroma[1783]: This mean that it is either anonymous function or capture of function without module specified. That may cause performance penalty when calling such handler. For more details see note in `telemetry:attach/4` documentation.
Jun 02 04:04:11 helix pleroma[1783]: https://hexdocs.pm/telemetry/telemetry.html#attach-4
Jun 02 04:04:11 helix pleroma[1783]: [debug] QUERY OK source="data_migrations" db=0.8ms queue=2.5ms idle=44.5ms
Jun 02 04:04:11 helix pleroma[1783]: SELECT d0."id", d0."name", d0."state", d0."feature_lock", d0."params", d0."data", d0."inserted_at", d0."updated_at" FROM "data_migrations" AS d0 WHERE (d0."name" = $1) ["populate_hashtags_table"]
Jun 02 04:04:11 helix pleroma[1783]: [debug] QUERY OK source="data_migrations" db=0.9ms queue=3.4ms idle=44.9ms
Jun 02 04:04:11 helix pleroma[1783]: SELECT d0."id", d0."name", d0."state", d0."feature_lock", d0."params", d0."data", d0."inserted_at", d0."updated_at" FROM "data_migrations" AS d0 WHERE (d0."name" = $1) ["delete_context_objects"]
Jun 02 04:04:11 helix pleroma[1783]: [debug] QUERY OK source="data_migrations" db=2.0ms queue=0.1ms idle=40.4ms
Jun 02 04:04:11 helix pleroma[1783]: SELECT d0."id", d0."name", d0."state", d0."feature_lock", d0."params", d0."data", d0."inserted_at", d0."updated_at" FROM "data_migrations" AS d0 WHERE (d0."name" = $1) ["delete_context_objects"]
Jun 02 04:04:11 helix pleroma[1783]: [debug] QUERY OK source="data_migrations" db=3.7ms idle=46.8ms
Jun 02 04:04:11 helix pleroma[1783]: SELECT d0."id", d0."name", d0."state", d0."feature_lock", d0."params", d0."data", d0."inserted_at", d0."updated_at" FROM "data_migrations" AS d0 WHERE (d0."name" = $1) ["populate_hashtags_table"]
Jun 02 04:04:11 helix pleroma[1783]: [info] Gopher server disabled
Jun 02 04:04:11 helix pleroma[1783]: [debug] QUERY OK db=0.2ms queue=0.5ms idle=40.8ms
Jun 02 04:04:11 helix pleroma[1783]: show server_version []
Jun 02 04:04:11 helix pleroma[1783]: [debug] QUERY OK source="users" db=457.1ms decode=0.1ms queue=2.8ms idle=18.8ms
Jun 02 04:04:11 helix pleroma[1783]: SELECT distinct split_part(u0."nickname", '@', 2) FROM "users" AS u0 WHERE (u0."local" != $1) [true]
Jun 02 04:04:11 helix pleroma[1783]: [debug] QUERY OK source="users" db=4.5ms queue=1.4ms idle=466.6ms
Jun 02 04:04:11 helix pleroma[1783]: SELECT sum(u0."note_count") FROM "users" AS u0 WHERE (NOT (u0."nickname" IS NULL)) AND (NOT (u0."nickname" LIKE 'internal.%')) AND (u0."local" = $1) [true]
Jun 02 04:04:11 helix pleroma[1783]: [debug] QUERY OK source="users" db=2.4ms queue=1.0ms idle=472.6ms
Jun 02 04:04:11 helix pleroma[1783]: SELECT count(u0."id") FROM "users" AS u0 WHERE (u0."is_active" = TRUE) AND (u0."local" = TRUE) AND (NOT (u0."nickname" IS NULL)) AND (NOT (u0."invisible")) []
Jun 02 04:04:13 helix pleroma[1783]: [debug] Tzdata polling for update.
Jun 02 04:04:13 helix pleroma[1783]: [debug] Tzdata polling shows the loaded tz database is up to date.
Jun 02 04:04:16 helix pleroma[1783]: [debug] QUERY OK source="users" db=6.1ms queue=3.1ms idle=1052.9ms
Jun 02 04:04:16 helix pleroma[1783]: SELECT u0."id", u0."bio", u0."raw_bio", u0."email", u0."name", u0."nickname", u0."password_hash", u0."keys", u0."public_key", u0."ap_id", u0."avatar", u0."local", u0."follower_address", u0."following_address", u0."featured_address", u0."tags", u0."last_refreshed_at", u0."last_digest_emailed_at", u0."banner", u0."background", u0."note_count", u0."follower_count", u0."following_count", u0."is_locked", u0."is_confirmed", u0."password_reset_pending", u0."is_approved", u0."registration_reason", u0."confirmation_token", u0."default_scope", u0."domain_blocks", u0."is_active", u0."no_rich_text", u0."ap_enabled", u0."is_moderator", u0."is_admin", u0."show_role", u0."uri", u0."hide_followers_count", u0."hide_follows_count", u0."hide_followers", u0."hide_follows", u0."hide_favorites", u0."email_notifications", u0."mascot", u0."emoji", u0."pleroma_settings_store", u0."fields", u0."raw_fields", u0."is_discoverable", u0."invisible", u0."allow_following_move", u0."skip_thread_containment", u0."actor_type", u0."also_known_as", u0."inbox", u0."shared_inbox", u0."accepts_chat_messages", u0."last_active_at", u0."disclose_client", u0."pinned_objects", u0."is_suggested", u0."last_status_at", u0."birthday", u0."show_birthday", u0."language", u0."notification_settings", u0."blocks", u0."mutes", u0."muted_reblogs", u0."muted_notifications", u0."subscribers", u0."multi_factor_authentication_settings", u0."inserted_at", u0."updated_at" FROM "users" AS u0 WHERE (u0."ap_id" = $1) ["https://social.malacology.net/internal/fetch"]
Jun 02 04:05:12 helix pleroma[1783]: [debug] QUERY OK source="users" db=445.1ms queue=0.1ms idle=1172.6ms
Jun 02 04:05:12 helix pleroma[1783]: SELECT distinct split_part(u0."nickname", '@', 2) FROM "users" AS u0 WHERE (u0."local" != $1) [true]
Jun 02 04:05:12 helix pleroma[1783]: [debug] QUERY OK source="users" db=0.8ms idle=943.6ms
Jun 02 04:05:12 helix pleroma[1783]: SELECT sum(u0."note_count") FROM "users" AS u0 WHERE (NOT (u0."nickname" IS NULL)) AND (NOT (u0."nickname" LIKE 'internal.%')) AND (u0."local" = $1) [true]
Jun 02 04:05:12 helix pleroma[1783]: [debug] QUERY OK source="users" db=0.8ms idle=944.5ms
Jun 02 04:05:12 helix pleroma[1783]: SELECT count(u0."id") FROM "users" AS u0 WHERE (u0."is_active" = TRUE) AND (u0."local" = TRUE) AND (NOT (u0."nickname" IS NULL)) AND (NOT (u0."invisible")) []
Jun 02 04:06:12 helix pleroma[1783]: [debug] QUERY OK source="users" db=415.7ms queue=0.1ms idle=1340.5ms
Jun 02 04:06:12 helix pleroma[1783]: SELECT distinct split_part(u0."nickname", '@', 2) FROM "users" AS u0 WHERE (u0."local" != $1) [true]
Jun 02 04:06:12 helix pleroma[1783]: [debug] QUERY OK source="users" db=2.8ms idle=1362.5ms
Jun 02 04:06:12 helix pleroma[1783]: SELECT sum(u0."note_count") FROM "users" AS u0 WHERE (NOT (u0."nickname" IS NULL)) AND (NOT (u0."nickname" LIKE 'internal.%')) AND (u0."local" = $1) [true]
Jun 02 04:06:12 helix pleroma[1783]: [debug] QUERY OK source="users" db=2.3ms idle=1365.5ms
Jun 02 04:06:12 helix pleroma[1783]: SELECT count(u0."id") FROM "users" AS u0 WHERE (u0."is_active" = TRUE) AND (u0."local" = TRUE) AND (NOT (u0."nickname" IS NULL)) AND (NOT (u0."invisible")) []
my nginx here
proxy_cache_path /tmp/pleroma-media-cache levels=1:2 keys_zone=pleroma_media_cache:10m max_size=10g
inactive=720m use_temp_path=off;
server {
listen 443 ssl http2;
listen [::]:443 ssl http2;
server_name MY_DOMAIN;
include /etc/nginx/custom/ssl.conf;
access_log /var/log/nginx/access.log;
gzip_vary on;
gzip_proxied any;
gzip_comp_level 6;
gzip_buffers 16 8k;
gzip_http_version 1.1;
gzip_types text/plain text/css application/json application/javascript text/xml application/xml application/xml+rss text/javascript application/activity+json application/atom+xml;
location / {
# if you do not want remote frontends to be able to access your Pleroma backend
# server, remove these lines.
add_header 'Access-Control-Allow-Origin' '*' always;
add_header 'Access-Control-Allow-Methods' 'POST, PUT, DELETE, GET, PATCH, OPTIONS' always;
add_header 'Access-Control-Allow-Headers' 'Authorization, Content-Type, Idempotency-Key' always;
add_header 'Access-Control-Expose-Headers' 'Link, X-RateLimit-Reset, X-RateLimit-Limit, X-RateLimit-Remaining, X-Request-Id' always;
if ($request_method = OPTIONS) {
return 204;
}
# stop removing lines here.
add_header X-XSS-Protection "1; mode=block";
add_header X-Permitted-Cross-Domain-Policies none;
add_header X-Frame-Options DENY;
add_header X-Content-Type-Options nosniff;
add_header Referrer-Policy same-origin;
add_header X-Download-Options noopen;
# Uncomment this only after you get HTTPS working.
add_header Strict-Transport-Security "max-age=31536000; includeSubDomains";
proxy_http_version 1.1;
proxy_set_header Upgrade $http_upgrade;
proxy_set_header Connection "upgrade";
proxy_set_header Host $http_host;
proxy_pass http://localhost:4000;
client_max_body_size 16m;
}
location /proxy {
proxy_cache pleroma_media_cache;
proxy_cache_lock on;
proxy_ignore_client_abort on;
proxy_pass http://localhost:4000;
}
}
my ufw rule, as previously work well, I am sure there is no problem
80/tcp ALLOW Anywhere
443/tcp ALLOW Anywhere
4000/tcp ALLOW Anywhere
my nginx error is here
2023/12/04 10:56:06 [error] 70603#70603: *13 connect() failed (111: Connection refused) while connecting to upstream, client: 172.69.195.81, server: social.malacology.net, request: "GET / HTTP/2.0", upstream: "http://[::1]:4000/", host: "social.malacology.net"
2023/12/04 10:56:06 [error] 70603#70603: *13 connect() failed (111: Connection refused) while connecting to upstream, client: 172.69.195.81, server: social.malacology.net, request: "GET / HTTP/2.0", upstream: "http://127.0.0.1:4000/", host: "social.malacology.net"
2023/12/04 10:56:07 [error] 70603#70603: *18 no live upstreams while connecting to upstream, client: 172.69.194.3, server: social.malacology.net, request: "GET /favicon.ico HTTP/2.0", upstream: "http://localhost/favicon.ico", host: "social.malacology.net", referrer: "https://social.malacology.net/"
2023/12/04 10:56:27 [error] 70603#70603: *33 connect() failed (111: Connection refused) while connecting to upstream, client: 172.69.60.151, server: social.malacology.net, request: "POST /inbox HTTP/2.0", upstream: "http://127.0.0.1:4000/inbox", host: "social.malacology.net"
2023/12/04 10:56:27 [error] 70603#70603: *33 connect() failed (111: Connection refused) while connecting to upstream, client: 172.69.60.151, server: social.malacology.net, request: "POST /inbox HTTP/2.0", upstream: "http://[::1]:4000/inbox", host: "social.malacology.net"
2023/12/04 10:56:47 [error] 70603#70603: *13 connect() failed (111: Connection refused) while connecting to upstream, client: 172.69.195.81, server: social.malacology.net, request: "GET / HTTP/2.0", upstream: "http://127.0.0.1:4000/", host: "social.malacology.net"
2023/12/04 10:56:47 [error] 70603#70603: *13 connect() failed (111: Connection refused) while connecting to upstream, client: 172.69.195.81, server: social.malacology.net, request: "GET / HTTP/2.0", upstream: "http://[::1]:4000/", host: "social.malacology.net"
2023/12/04 10:56:48 [error] 70603#70603: *18 no live upstreams while connecting to upstream, client: 172.69.194.3, server: social.malacology.net, request: "GET /favicon.ico HTTP/2.0", upstream: "http://localhost/favicon.ico", host: "social.malacology.net", referrer: "https://social.malacology.net/"
2023/12/04 10:56:53 [error] 70603#70603: *50 no live upstreams while connecting to upstream, client: 172.70.123.111, server: social.malacology.net, request: "POST /inbox HTTP/2.0", upstream: "http://localhost/inbox", host: "social.malacology.net"
Edited by Kuoi Z