2.5.0 build from source: '/opt/pleroma/lib/crypt-0.4.3/priv/crypt.so: undefined symbol: crypt'"
Environment
- Installation type (OTP or From Source): OTP, Compile from source by myself
- Pleroma version (could be found in the "Version" tab of settings in Pleroma-FE): 2.5.0
- Elixir version (
elixir -vfor from source installations, N/A for OTP): 1.14.0 - Operating system: ArchLinux
- PostgreSQL version (
psql -V): 15.1
Bug description
My build command is that
cd git_repo_tag_2.5.0
mix local.hex --force
mix local.rebar --force
mix deps.get
mix deps.get --only prod
mkdir /opt/pleroma
mix release --path /opt/pleroma After it's built I configure it. With the configuration below, I successfully run the official OTP release but fail with my build OTP. I already installed libxcrypt-compat and libxcrypt
sudo -Hu pleroma /opt/pleroma/bin/pleroma_ctl instance gen --output "/etc/pleroma/config.exs" --output-psql "/tmp/setup_otp_db.psql" --uploads-dir "/var/lib/pleroma/uploads" --static-dir "/var/lib/pleroma/static" --dbname "pleroma" --dbuser "pleroma"
sudo -Hu postgres psql -f "/tmp/setup_otp_db.psql"
sudo -Hu pleroma /opt/pleroma/bin/pleroma_ctl migratethe error log is here
Feb 11 21:54:53 helix pleroma[2934]: crasher:
Feb 11 21:54:53 helix pleroma[2934]: initial call: application_master:init/4
Feb 11 21:54:53 helix pleroma[2934]: pid: <0.3557.0>
Feb 11 21:54:53 helix pleroma[2934]: registered_name: []
Feb 11 21:54:53 helix pleroma[2934]: exception exit: {{shutdown,
Feb 11 21:54:53 helix pleroma[2934]: {failed_to_start_child,kernel_safe_sup,
Feb 11 21:54:53 helix pleroma[2934]: {on_load_function_failed,crypt,
Feb 11 21:54:53 helix pleroma[2934]: {error,
Feb 11 21:54:53 helix pleroma[2934]: {load_failed,
Feb 11 21:54:53 helix pleroma[2934]: "Failed to load NIF library: '/opt/pleroma/lib/crypt-0.4.3/priv/crypt.so: undefined symbol: crypt'"}}}}},
Feb 11 21:54:53 helix pleroma[2934]: {kernel,start,[normal,[]]}}
Feb 11 21:54:53 helix pleroma[2934]: in function application_master:init/4 (application_master.erl, line 142)
Feb 11 21:54:53 helix pleroma[2934]: ancestors: [<0.3556.0>]
Feb 11 21:54:53 helix pleroma[2934]: message_queue_len: 1
Feb 11 21:54:53 helix pleroma[2934]: messages: [{'EXIT',<0.3558.0>,normal}]
Feb 11 21:54:53 helix pleroma[2934]: links: [<0.3556.0>,<0.3555.0>]
Feb 11 21:54:53 helix pleroma[2934]: dictionary: []
Feb 11 21:54:53 helix pleroma[2934]: trap_exit: true
Feb 11 21:54:53 helix pleroma[2934]: status: running
Feb 11 21:54:53 helix pleroma[2934]: heap_size: 987
Feb 11 21:54:53 helix pleroma[2934]: stack_size: 28
Feb 11 21:54:53 helix pleroma[2934]: reductions: 182
Feb 11 21:54:53 helix pleroma[2934]: neighbours:
Feb 11 21:54:53 helix pleroma[2934]:
Feb 11 21:54:53 helix pleroma[2934]: =INFO REPORT==== 11-Feb-2023::21:54:53.824740 ===
Feb 11 21:54:53 helix pleroma[2934]: application: kernel
Feb 11 21:54:53 helix pleroma[2934]: exited: {{shutdown,
Feb 11 21:54:53 helix pleroma[2934]: {failed_to_start_child,kernel_safe_sup,
Feb 11 21:54:53 helix pleroma[2934]: {on_load_function_failed,crypt,
Feb 11 21:54:53 helix pleroma[2934]: {error,
Feb 11 21:54:53 helix pleroma[2934]: {load_failed,
Feb 11 21:54:53 helix pleroma[2934]: "Failed to load NIF library: '/opt/pleroma/lib/crypt-0.4.3/priv/crypt.so: undefined symbol: crypt'"}}}}},
Feb 11 21:54:53 helix pleroma[2934]: {kernel,start,[normal,[]]}}
Feb 11 21:54:53 helix pleroma[2934]: type: permanent
Feb 11 21:54:53 helix pleroma[2934]:
Feb 11 21:54:54 helix pleroma[2934]: {"Kernel pid terminated",application_controller,"{application_start_failure,kernel,{{shutdown,{failed_to_start_child,kernel_safe_sup,{on_load_function_failed,crypt,{error,{load_failed,\"Failed to load NIF library: '/opt/pleroma/lib/crypt-0.4.3/priv/crypt.so: undefined symbol: crypt'\"}}}}},{kernel,start,[normal,[]]}}}"}
Feb 11 21:54:54 helix pleroma[2934]: Kernel pid terminated (application_controller) ({application_start_failure,kernel,{{shutdown,{failed_to_start_child,kernel_safe_sup,{on_load_function_failed,crypt,{error,{load_failed,"Failed to load NIF library: '/opt/pleroma/lib/crypt-0.4.3/priv/crypt.so: undefined symbol: crypt'"}}}}},{kernel,start,[normal,[]]}}})
Feb 11 21:54:54 helix pleroma[2934]:
Feb 11 21:54:54 helix pleroma[2934]: Crash dump is being written to: erl_crash.dump...done
Feb 11 21:54:54 helix systemd[1]: pleroma.service: Main process exited, code=exited, status=1/FAILURE
Feb 11 21:54:54 helix systemd[1]: pleroma.service: Failed with result 'exit-code'.
Feb 11 21:54:54 helix systemd[1]: pleroma.service: Unit process 450 (epmd) remains running after unit stopped.
Feb 11 21:54:54 helix systemd[1]: pleroma.service: Consumed 5.104s CPU time.
Feb 11 21:54:54 helix systemd[1]: pleroma.service: Scheduled restart job, restart counter is at 37.
Feb 11 21:54:54 helix systemd[1]: Stopped Pleroma social network.
Feb 11 21:54:54 helix systemd[1]: pleroma.service: Consumed 5.104s CPU time.
Feb 11 21:54:54 helix systemd[1]: pleroma.service: Found left-over process 450 (epmd) in control group while starting unit. Ignoring.
Feb 11 21:54:54 helix systemd[1]: This usually indicates unclean termination of a previous run, or service implementation deficiencies.
Feb 11 21:54:54 helix systemd[1]: Started Pleroma social network.
Feb 11 21:54:55 helix systemd[1]: Stopping Pleroma social network...
Feb 11 21:54:56 helix pleroma[3065]: --rpc-eval : RPC failed with reason :nodedown
Feb 11 21:54:56 helix systemd[1]: pleroma.service: Control process exited, code=exited, status=1/FAILURE
Feb 11 21:54:58 helix pleroma[3007]: =SUPERVISOR REPORT==== 11-Feb-2023::21:54:58.407014 ===
Feb 11 21:54:58 helix pleroma[3007]: supervisor: {local,kernel_sup}
Feb 11 21:54:58 helix pleroma[3007]: errorContext: start_error
Feb 11 21:54:58 helix pleroma[3007]: reason: {on_load_function_failed,crypt,
Feb 11 21:54:58 helix pleroma[3007]: {error,
Feb 11 21:54:58 helix pleroma[3007]: {load_failed,
Feb 11 21:54:58 helix pleroma[3007]: "Failed to load NIF library: '/opt/pleroma/lib/crypt-0.4.3/priv/crypt.so: undefined symbol: crypt'"}}}
Feb 11 21:54:58 helix pleroma[3007]: offender: [{pid,undefined},
Feb 11 21:54:58 helix pleroma[3007]: {id,kernel_safe_sup},
Feb 11 21:54:58 helix pleroma[3007]: {mfargs,{supervisor,start_link,
Feb 11 21:54:58 helix pleroma[3007]: [{local,kernel_safe_sup},kernel,safe]}},
Feb 11 21:54:58 helix pleroma[3007]: {restart_type,permanent},
Feb 11 21:54:58 helix pleroma[3007]: {significant,false},
Feb 11 21:54:58 helix pleroma[3007]: {shutdown,infinity},
Feb 11 21:54:58 helix pleroma[3007]: {child_type,supervisor}]
Feb 11 21:54:58 helix pleroma[3007]:
Feb 11 21:54:58 helix pleroma[3007]: =CRASH REPORT==== 11-Feb-2023::21:54:58.409484 ===
Feb 11 21:54:58 helix pleroma[3007]: crasher:
Feb 11 21:54:58 helix pleroma[3007]: initial call: supervisor:kernel/1
Feb 11 21:54:58 helix pleroma[3007]: pid: <0.3585.0>
Feb 11 21:54:58 helix pleroma[3007]: registered_name: []
Feb 11 21:54:58 helix pleroma[3007]: exception exit: {on_load_function_failed,crypt,
Feb 11 21:54:58 helix pleroma[3007]: {error,
Feb 11 21:54:58 helix pleroma[3007]: {load_failed,
Feb 11 21:54:58 helix pleroma[3007]: "Failed to load NIF library: '/opt/pleroma/lib/crypt-0.4.3/priv/crypt.so: undefined symbol: crypt'"}}}
Feb 11 21:54:58 helix pleroma[3007]: in function init:run_on_load_handlers/0
Feb 11 21:54:58 helix pleroma[3007]: in call from kernel:init/1 (kernel.erl, line 196)
Feb 11 21:54:58 helix pleroma[3007]: in call from supervisor:init/1 (supervisor.erl, line 330)
Feb 11 21:54:58 helix pleroma[3007]: in call from gen_server:init_it/2 (gen_server.erl, line 851)
Feb 11 21:54:58 helix pleroma[3007]: in call from gen_server:init_it/6 (gen_server.erl, line 814)
Feb 11 21:54:58 helix pleroma[3007]: ancestors: [kernel_sup,<0.3558.0>]
Feb 11 21:54:58 helix pleroma[3007]: message_queue_len: 0
Feb 11 21:54:58 helix pleroma[3007]: messages: []
Feb 11 21:54:58 helix pleroma[3007]: links: [<0.3560.0>]
Feb 11 21:54:58 helix pleroma[3007]: dictionary: []
Feb 11 21:54:58 helix pleroma[3007]: trap_exit: true
Feb 11 21:54:58 helix pleroma[3007]: status: running
Feb 11 21:54:58 helix pleroma[3007]: heap_size: 610
Feb 11 21:54:58 helix pleroma[3007]: stack_size: 28
Feb 11 21:54:58 helix pleroma[3007]: reductions: 213
Feb 11 21:54:58 helix pleroma[3007]: neighbours:
Feb 11 21:54:58 helix pleroma[3007]:
Feb 11 21:54:59 helix pleroma[3007]: =CRASH REPORT==== 11-Feb-2023::21:54:59.412397 ===
Feb 11 21:54:59 helix pleroma[3007]: crasher:
Feb 11 21:54:59 helix pleroma[3007]: initial call: application_master:init/4
Feb 11 21:54:59 helix pleroma[3007]: pid: <0.3557.0>
Feb 11 21:54:59 helix pleroma[3007]: registered_name: []
Feb 11 21:54:59 helix pleroma[3007]: exception exit: {{shutdown,
Feb 11 21:54:59 helix pleroma[3007]: {failed_to_start_child,kernel_safe_sup,
Feb 11 21:54:59 helix pleroma[3007]: {on_load_function_failed,crypt,
Feb 11 21:54:59 helix pleroma[3007]: {error,
Feb 11 21:54:59 helix pleroma[3007]: {load_failed,
Feb 11 21:54:59 helix pleroma[3007]: "Failed to load NIF library: '/opt/pleroma/lib/crypt-0.4.3/priv/crypt.so: undefined symbol: crypt'"}}}}},
Feb 11 21:54:59 helix pleroma[3007]: {kernel,start,[normal,[]]}}
Feb 11 21:54:59 helix pleroma[3007]: in function application_master:init/4 (application_master.erl, line 142)
Feb 11 21:54:59 helix pleroma[3007]: ancestors: [<0.3556.0>]
Feb 11 21:54:59 helix pleroma[3007]: message_queue_len: 1
Feb 11 21:54:59 helix pleroma[3007]: messages: [{'EXIT',<0.3558.0>,normal}]
Feb 11 21:54:59 helix pleroma[3007]: links: [<0.3556.0>,<0.3555.0>]
Feb 11 21:54:59 helix pleroma[3007]: dictionary: []
Feb 11 21:54:59 helix pleroma[3007]: trap_exit: true
Feb 11 21:54:59 helix pleroma[3007]: status: running
Feb 11 21:54:59 helix pleroma[3007]: heap_size: 987
Feb 11 21:54:59 helix pleroma[3007]: stack_size: 28
Feb 11 21:54:59 helix pleroma[3007]: reductions: 182
Feb 11 21:54:59 helix pleroma[3007]: neighbours:
Feb 11 21:54:59 helix pleroma[3007]:
Feb 11 21:54:59 helix pleroma[3007]: =INFO REPORT==== 11-Feb-2023::21:54:59.415243 ===
Feb 11 21:54:59 helix pleroma[3007]: application: kernel
Feb 11 21:54:59 helix pleroma[3007]: exited: {{shutdown,
Feb 11 21:54:59 helix pleroma[3007]: {failed_to_start_child,kernel_safe_sup,
Feb 11 21:54:59 helix pleroma[3007]: {on_load_function_failed,crypt,
Feb 11 21:54:59 helix pleroma[3007]: {error,
Feb 11 21:54:59 helix pleroma[3007]: {load_failed,
Feb 11 21:54:59 helix pleroma[3007]: "Failed to load NIF library: '/opt/pleroma/lib/crypt-0.4.3/priv/crypt.so: undefined symbol: crypt'"}}}}},
Feb 11 21:54:59 helix pleroma[3007]: {kernel,start,[normal,[]]}}
Feb 11 21:54:59 helix pleroma[3007]: type: permanent
Feb 11 21:54:59 helix pleroma[3007]:
Feb 11 21:54:59 helix pleroma[3007]: {"Kernel pid terminated",application_controller,"{application_start_failure,kernel,{{shutdown,{failed_to_start_child,kernel_safe_sup,{on_load_function_failed,crypt,{error,{load_failed,\"Failed to load NIF library: '/opt/pleroma/lib/crypt-0.4.3/priv/crypt.so: undefined symbol: crypt'\"}}}}},{kernel,start,[normal,[]]}}}"}
Feb 11 21:54:59 helix pleroma[3007]: Kernel pid terminated (application_controller) ({application_start_failure,kernel,{{shutdown,{failed_to_start_child,kernel_safe_sup,{on_load_function_failed,crypt,{error,{load_failed,"Failed to load NIF library: '/opt/pleroma/lib/crypt-0.4.3/priv/crypt.so: undefined symbol: crypt'"}}}}},{kernel,start,[normal,[]]}}})
Feb 11 21:54:59 helix pleroma[3007]:
Feb 11 21:55:00 helix pleroma[3007]: Crash dump is being written to: erl_crash.dump...done
Feb 11 21:55:00 helix systemd[1]: pleroma.service: Main process exited, code=exited, status=1/FAILURE
Feb 11 21:55:00 helix systemd[1]: pleroma.service: Failed with result 'exit-code'.
Feb 11 21:55:00 helix systemd[1]: pleroma.service: Unit process 450 (epmd) remains running after unit stopped.
Feb 11 21:55:00 helix systemd[1]: Stopped Pleroma social network.
Feb 11 21:55:00 helix systemd[1]: pleroma.service: Consumed 5.701s CPU time.I even try to mv official OTP crypt.so to this path, the log is here with web 502
Feb 11 21:57:59 helix systemd[1]: Started Pleroma social network.
Feb 11 21:58:02 helix pleroma[3517]: [notice] :alarm_handler: {:set, {:system_memory_high_watermark, []}}
Feb 11 21:58:03 helix pleroma[3517]: [info] Function passed as a handler with ID "pleroma-logger" is local function.
Feb 11 21:58:03 helix pleroma[3517]: 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.
Feb 11 21:58:03 helix pleroma[3517]: https://hexdocs.pm/telemetry/telemetry.html#attach-4
Feb 11 21:58:03 helix pleroma[3517]: [debug] QUERY OK source="columns" db=6.6ms queue=8.2ms idle=0.0ms
Feb 11 21:58:03 helix pleroma[3517]: SELECT TRUE FROM "information_schema"."columns" AS c0 WHERE (c0."table_name" = 'objects') AND (c0."column_name" = 'fts_content') LIMIT 1 []
Feb 11 21:58:03 helix pleroma[3517]: [info] Function passed as a handler with ID "telemetry_web__event_handler" is local function.
Feb 11 21:58:03 helix pleroma[3517]: 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.
Feb 11 21:58:03 helix pleroma[3517]: https://hexdocs.pm/telemetry/telemetry.html#attach-4
Feb 11 21:58:03 helix pleroma[3517]: [debug] Elixir.Pleroma.Web.ActivityPub.MRF.MediaProxyWarmingPolicy is excluded from config descriptions, because does not implement `config_description/0` method.
Feb 11 21:58:03 helix pleroma[3517]: [debug] Elixir.Pleroma.Web.ActivityPub.MRF.ForceMentionsInContent is excluded from config descriptions, because does not implement `config_description/0` method.
Feb 11 21:58:03 helix pleroma[3517]: [debug] Elixir.Pleroma.Web.ActivityPub.MRF.DropPolicy is excluded from config descriptions, because does not implement `config_description/0` method.
Feb 11 21:58:03 helix pleroma[3517]: [debug] Elixir.Pleroma.Web.ActivityPub.MRF.TagPolicy is excluded from config descriptions, because does not implement `config_description/0` method.
Feb 11 21:58:03 helix pleroma[3517]: [debug] Elixir.Pleroma.Web.ActivityPub.MRF.NoPlaceholderTextPolicy is excluded from config descriptions, because does not implement `config_description/0` method.
Feb 11 21:58:03 helix pleroma[3517]: [debug] Elixir.Pleroma.Web.ActivityPub.MRF.ForceBotUnlistedPolicy is excluded from config descriptions, because does not implement `config_description/0` method.
Feb 11 21:58:03 helix pleroma[3517]: [debug] Elixir.Pleroma.Web.ActivityPub.MRF.EnsureRePrepended is excluded from config descriptions, because does not implement `config_description/0` method.
Feb 11 21:58:03 helix pleroma[3517]: [debug] Elixir.Pleroma.Web.ActivityPub.MRF.AntiLinkSpamPolicy is excluded from config descriptions, because does not implement `config_description/0` method.
Feb 11 21:58:03 helix pleroma[3517]: [debug] Elixir.Pleroma.Web.ActivityPub.MRF.AntiFollowbotPolicy is excluded from config descriptions, because does not implement `config_description/0` method.
Feb 11 21:58:03 helix pleroma[3517]: [debug] Elixir.Pleroma.Web.ActivityPub.MRF.FollowBotPolicy is excluded from config descriptions, because does not implement `config_description/0` method.
Feb 11 21:58:03 helix pleroma[3517]: [debug] Elixir.Pleroma.Web.ActivityPub.MRF.NoEmptyPolicy is excluded from config descriptions, because does not implement `config_description/0` method.
Feb 11 21:58:03 helix pleroma[3517]: [debug] Elixir.Pleroma.Web.ActivityPub.MRF.UserAllowListPolicy is excluded from config descriptions, because does not implement `config_description/0` method.
Feb 11 21:58:03 helix pleroma[3517]: [debug] Elixir.Pleroma.Web.ActivityPub.MRF.NoOpPolicy is excluded from config descriptions, because does not implement `config_description/0` method.
Feb 11 21:58:03 helix pleroma[3517]: [debug] QUERY OK source="config" db=6.0ms queue=28.0ms idle=0.0ms
Feb 11 21:58:03 helix pleroma[3517]: SELECT c0."id", c0."key", c0."group", c0."value", c0."inserted_at", c0."updated_at" FROM "config" AS c0 []
Feb 11 21:58:03 helix pleroma[3517]: [info] Function passed as a handler with ID "oban-monitor-failure" is local function.
Feb 11 21:58:03 helix pleroma[3517]: 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.
Feb 11 21:58:03 helix pleroma[3517]: https://hexdocs.pm/telemetry/telemetry.html#attach-4
Feb 11 21:58:03 helix pleroma[3517]: [info] Function passed as a handler with ID "oban-monitor-success" is local function.
Feb 11 21:58:03 helix pleroma[3517]: 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.
Feb 11 21:58:03 helix pleroma[3517]: https://hexdocs.pm/telemetry/telemetry.html#attach-4
Feb 11 21:58:03 helix pleroma[3517]: [debug] QUERY OK source="data_migrations" db=0.8ms queue=1.3ms idle=45.2ms
Feb 11 21:58:03 helix pleroma[3517]: 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"]
Feb 11 21:58:03 helix pleroma[3517]: [info] Gopher server disabled
Feb 11 21:58:03 helix pleroma[3517]: [debug] QUERY OK db=0.2ms queue=0.3ms idle=44.1ms
Feb 11 21:58:03 helix pleroma[3517]: show server_version []
Feb 11 21:58:03 helix pleroma[3517]: [debug] QUERY OK source="data_migrations" db=2.5ms queue=2.5ms idle=42.8ms
Feb 11 21:58:03 helix pleroma[3517]: 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"]
Feb 11 21:58:03 helix pleroma[3517]: [debug] QUERY OK source="data_migrations" db=1.8ms queue=0.3ms idle=44.2ms
Feb 11 21:58:03 helix pleroma[3517]: 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"]
Feb 11 21:58:03 helix pleroma[3517]: [debug] QUERY OK source="data_migrations" db=5.2ms queue=0.5ms idle=44.5ms
Feb 11 21:58:03 helix pleroma[3517]: 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"]
Feb 11 21:58:04 helix pleroma[3517]: [debug] QUERY OK source="users" db=469.7ms decode=0.2ms queue=1.9ms idle=24.7ms
Feb 11 21:58:04 helix pleroma[3517]: SELECT distinct split_part(u0."nickname", '@', 2) FROM "users" AS u0 WHERE (u0."local" != $1) [true]
Feb 11 21:58:04 helix pleroma[3517]: [debug] QUERY OK source="users" db=7.1ms queue=1.9ms idle=486.4ms
Feb 11 21:58:04 helix pleroma[3517]: 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]
Feb 11 21:58:04 helix pleroma[3517]: [debug] QUERY OK source="users" db=2.3ms queue=1.1ms idle=494.4ms
Feb 11 21:58:04 helix pleroma[3517]: 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")) []
Feb 11 21:58:08 helix pleroma[3517]: [debug] QUERY OK source="users" db=95.5ms queue=1.2ms idle=1068.6ms
Feb 11 21:58:08 helix pleroma[3517]: 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"]
Feb 11 21:59:04 helix pleroma[3517]: [debug] QUERY OK source="users" db=418.4ms queue=0.1ms idle=888.4ms
Feb 11 21:59:04 helix pleroma[3517]: SELECT distinct split_part(u0."nickname", '@', 2) FROM "users" AS u0 WHERE (u0."local" != $1) [true]
Feb 11 21:59:04 helix pleroma[3517]: [debug] QUERY OK source="users" db=5.3ms idle=952.2ms
Feb 11 21:59:04 helix pleroma[3517]: 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]
Feb 11 21:59:04 helix pleroma[3517]: [debug] QUERY OK source="users" db=2.4ms idle=957.8ms
Feb 11 21:59:04 helix pleroma[3517]: 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")) []
Feb 11 22:00:05 helix pleroma[3517]: [debug] QUERY OK source="users" db=428.4ms idle=1960.1ms
Feb 11 22:00:05 helix pleroma[3517]: SELECT distinct split_part(u0."nickname", '@', 2) FROM "users" AS u0 WHERE (u0."local" != $1) [true]
Feb 11 22:00:05 helix pleroma[3517]: [debug] QUERY OK source="users" db=3.0ms idle=1390.0ms
Feb 11 22:00:05 helix pleroma[3517]: 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]
Feb 11 22:00:05 helix pleroma[3517]: [debug] QUERY OK source="users" db=2.8ms idle=1393.2ms
Feb 11 22:00:05 helix pleroma[3517]: 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")) []
Feb 11 22:01:05 helix pleroma[3517]: [debug] QUERY OK source="users" db=411.1ms decode=0.2ms idle=1397.9ms
Feb 11 22:01:05 helix pleroma[3517]: SELECT distinct split_part(u0."nickname", '@', 2) FROM "users" AS u0 WHERE (u0."local" != $1) [true]
Feb 11 22:01:05 helix pleroma[3517]: [debug] QUERY OK source="users" db=4.9ms idle=1810.6ms
Feb 11 22:01:05 helix pleroma[3517]: 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]
Feb 11 22:01:05 helix pleroma[3517]: [debug] QUERY OK source="users" db=2.6ms queue=0.1ms idle=1815.7ms
Feb 11 22:01:05 helix pleroma[3517]: 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")) []
Feb 11 22:02:05 helix pleroma[3517]: [debug] QUERY OK source="users" db=457.2ms queue=0.2ms idle=1818.0ms
Feb 11 22:02:05 helix pleroma[3517]: SELECT distinct split_part(u0."nickname", '@', 2) FROM "users" AS u0 WHERE (u0."local" != $1) [true]
Feb 11 22:02:05 helix pleroma[3517]: [debug] QUERY OK source="users" db=3.1ms idle=1278.5ms
Feb 11 22:02:05 helix pleroma[3517]: 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]
Feb 11 22:02:05 helix pleroma[3517]: [debug] QUERY OK source="users" db=1.3ms idle=1210.7ms
Feb 11 22:02:05 helix pleroma[3517]: 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")) []
Feb 11 22:03:06 helix pleroma[3517]: [debug] QUERY OK source="users" db=407.3ms queue=0.1ms idle=957.8ms
Feb 11 22:03:06 helix pleroma[3517]: SELECT distinct split_part(u0."nickname", '@', 2) FROM "users" AS u0 WHERE (u0."local" != $1) [true]
Feb 11 22:03:06 helix pleroma[3517]: [debug] QUERY OK source="users" db=2.8ms idle=691.6ms
Feb 11 22:03:06 helix pleroma[3517]: 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]
Feb 11 22:03:06 helix pleroma[3517]: [debug] QUERY OK source="users" db=0.6ms idle=694.4ms
Feb 11 22:03:06 helix pleroma[3517]: 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")) []
Feb 11 22:04:06 helix pleroma[3517]: [debug] QUERY OK source="users" db=477.1ms idle=695.7ms
Feb 11 22:04:06 helix pleroma[3517]: SELECT distinct split_part(u0."nickname", '@', 2) FROM "users" AS u0 WHERE (u0."local" != $1) [true]
Feb 11 22:04:06 helix pleroma[3517]: [debug] QUERY OK source="users" db=3.3ms queue=0.2ms idle=1174.4ms
Feb 11 22:04:06 helix pleroma[3517]: 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]
Feb 11 22:04:06 helix pleroma[3517]: [debug] QUERY OK source="users" db=1.3ms queue=0.1ms idle=1177.9ms
Feb 11 22:04:06 helix pleroma[3517]: 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")) []
Feb 11 22:05:07 helix pleroma[3517]: [debug] QUERY OK source="users" db=412.5ms queue=0.1ms idle=1180.5ms
Feb 11 22:05:07 helix pleroma[3517]: SELECT distinct split_part(u0."nickname", '@', 2) FROM "users" AS u0 WHERE (u0."local" != $1) [true]
Feb 11 22:05:07 helix pleroma[3517]: [debug] QUERY OK source="users" db=1.1ms idle=1595.5ms
Feb 11 22:05:07 helix pleroma[3517]: 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]
Feb 11 22:05:07 helix pleroma[3517]: [debug] QUERY OK source="users" db=0.9ms idle=1596.8ms
Feb 11 22:05:07 helix pleroma[3517]: 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")) []
Feb 11 22:06:07 helix pleroma[3517]: [debug] QUERY OK source="users" db=733.7ms decode=0.1ms queue=0.1ms idle=1594.2ms
Feb 11 22:06:07 helix pleroma[3517]: SELECT distinct split_part(u0."nickname", '@', 2) FROM "users" AS u0 WHERE (u0."local" != $1) [true]
Feb 11 22:06:07 helix pleroma[3517]: [debug] QUERY OK source="users" db=1.3ms idle=1329.9ms
Feb 11 22:06:07 helix pleroma[3517]: 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]
Feb 11 22:06:07 helix pleroma[3517]: [debug] QUERY OK source="users" db=0.9ms idle=1331.5ms
Feb 11 22:06:07 helix pleroma[3517]: 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")) []
Feb 11 22:07:08 helix pleroma[3517]: [debug] QUERY OK source="users" db=417.2ms queue=0.1ms idle=1333.6ms
Feb 11 22:07:08 helix pleroma[3517]: SELECT distinct split_part(u0."nickname", '@', 2) FROM "users" AS u0 WHERE (u0."local" != $1) [true]
Feb 11 22:07:08 helix pleroma[3517]: [debug] QUERY OK source="users" db=1.3ms idle=1752.4ms
Feb 11 22:07:08 helix pleroma[3517]: 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]
Feb 11 22:07:08 helix pleroma[3517]: [debug] QUERY OK source="users" db=1.1ms idle=1753.9ms
Feb 11 22:07:08 helix pleroma[3517]: 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")) []
Feb 11 22:08:08 helix pleroma[3517]: [debug] QUERY OK source="users" db=414.1ms idle=1754.7ms
Feb 11 22:08:08 helix pleroma[3517]: SELECT distinct split_part(u0."nickname", '@', 2) FROM "users" AS u0 WHERE (u0."local" != $1) [true]
Feb 11 22:08:08 helix pleroma[3517]: [debug] QUERY OK source="users" db=3.2ms idle=1170.9ms
Feb 11 22:08:08 helix pleroma[3517]: 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]
Feb 11 22:08:08 helix pleroma[3517]: [debug] QUERY OK source="users" db=1.3ms idle=1174.4ms
Feb 11 22:08:08 helix pleroma[3517]: 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")) []
Feb 11 22:09:09 helix pleroma[3517]: [debug] QUERY OK source="users" db=459.7ms idle=1175.7ms
Feb 11 22:09:09 helix pleroma[3517]: SELECT distinct split_part(u0."nickname", '@', 2) FROM "users" AS u0 WHERE (u0."local" != $1) [true]
Feb 11 22:09:09 helix pleroma[3517]: [debug] QUERY OK source="users" db=1.4ms queue=0.1ms idle=1636.6ms
Feb 11 22:09:09 helix pleroma[3517]: 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]
Feb 11 22:09:09 helix pleroma[3517]: [debug] QUERY OK source="users" db=1.2ms idle=1638.2ms
Feb 11 22:09:09 helix pleroma[3517]: 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")) []
Feb 11 22:10:09 helix pleroma[3517]: [debug] QUERY OK source="users" db=413.7ms decode=1.1ms queue=0.1ms idle=1453.2ms
Feb 11 22:10:09 helix pleroma[3517]: SELECT distinct split_part(u0."nickname", '@', 2) FROM "users" AS u0 WHERE (u0."local" != $1) [true]
Feb 11 22:10:09 helix pleroma[3517]: [debug] QUERY OK source="users" db=1.7ms idle=1056.5ms
Feb 11 22:10:09 helix pleroma[3517]: 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]
Feb 11 22:10:09 helix pleroma[3517]: [debug] QUERY OK source="users" db=0.9ms idle=1058.5ms
Feb 11 22:10:09 helix pleroma[3517]: 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")) []
Feb 11 22:11:10 helix pleroma[3517]: [debug] QUERY OK source="users" db=405.9ms queue=0.1ms idle=1060.6ms
Feb 11 22:11:10 helix pleroma[3517]: SELECT distinct split_part(u0."nickname", '@', 2) FROM "users" AS u0 WHERE (u0."local" != $1) [true]
Feb 11 22:11:10 helix pleroma[3517]: [debug] QUERY OK source="users" db=2.0ms idle=1468.7ms
Feb 11 22:11:10 helix pleroma[3517]: 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]
Feb 11 22:11:10 helix pleroma[3517]: [debug] QUERY OK source="users" db=1.0ms idle=1470.9ms
Feb 11 22:11:10 helix pleroma[3517]: 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")) []
Feb 11 22:12:10 helix pleroma[3517]: [debug] QUERY OK source="users" db=431.1ms decode=0.1ms queue=0.1ms idle=1472.4ms
Feb 11 22:12:10 helix pleroma[3517]: SELECT distinct split_part(u0."nickname", '@', 2) FROM "users" AS u0 WHERE (u0."local" != $1) [true]
Feb 11 22:12:10 helix pleroma[3517]: [debug] QUERY OK source="users" db=3.3ms idle=1905.6ms
Feb 11 22:12:10 helix pleroma[3517]: 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]
Feb 11 22:12:10 helix pleroma[3517]: [debug] QUERY OK source="users" db=0.9ms idle=1909.2ms
Feb 11 22:12:10 helix pleroma[3517]: 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")) []
Feb 11 22:13:10 helix pleroma[3517]: [debug] QUERY OK source="users" db=411.0ms queue=0.3ms idle=1911.6ms
Feb 11 22:13:10 helix pleroma[3517]: SELECT distinct split_part(u0."nickname", '@', 2) FROM "users" AS u0 WHERE (u0."local" != $1) [true]
Feb 11 22:13:10 helix pleroma[3517]: [debug] QUERY OK source="users" db=1.7ms idle=1324.4ms
Feb 11 22:13:10 helix pleroma[3517]: 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]
Feb 11 22:13:10 helix pleroma[3517]: [debug] QUERY OK source="users" db=0.9ms idle=1326.3ms
Feb 11 22:13:10 helix pleroma[3517]: 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")) []
Feb 11 22:14:11 helix pleroma[3517]: [debug] QUERY OK source="users" db=404.2ms idle=1328.0ms
Feb 11 22:14:11 helix pleroma[3517]: SELECT distinct split_part(u0."nickname", '@', 2) FROM "users" AS u0 WHERE (u0."local" != $1) [true]
Feb 11 22:14:11 helix pleroma[3517]: [debug] QUERY OK source="users" db=1.1ms queue=0.1ms idle=1733.6ms
Feb 11 22:14:11 helix pleroma[3517]: 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]
Feb 11 22:14:11 helix pleroma[3517]: [debug] QUERY OK source="users" db=0.9ms idle=1735.0ms
Feb 11 22:14:11 helix pleroma[3517]: 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")) []
Feb 11 22:15:11 helix pleroma[3517]: [debug] QUERY OK source="users" db=433.1ms idle=1737.3ms
Feb 11 22:15:11 helix pleroma[3517]: SELECT distinct split_part(u0."nickname", '@', 2) FROM "users" AS u0 WHERE (u0."local" != $1) [true]
Feb 11 22:15:11 helix pleroma[3517]: [debug] QUERY OK source="users" db=1.0ms idle=1171.8ms
Feb 11 22:15:11 helix pleroma[3517]: 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]
Feb 11 22:15:11 helix pleroma[3517]: [debug] QUERY OK source="users" db=0.8ms queue=0.2ms idle=1173.0ms
Feb 11 22:15:11 helix pleroma[3517]: 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")) []
Feb 11 22:16:02 helix systemd[1]: Stopping Pleroma social network...
Feb 11 22:16:03 helix pleroma[3517]: [notice] SIGTERM received - shutting down
Feb 11 22:16:03 helix pleroma[3580]: [os_mon] memory supervisor port (memsup): Erlang has closed
Feb 11 22:16:03 helix pleroma[3517]: [notice] :alarm_handler: {:clear, :system_memory_high_watermark}
Feb 11 22:16:03 helix pleroma[3581]: [os_mon] cpu supervisor port (cpu_sup): Erlang has closed
Feb 11 22:16:17 helix systemd[1]: pleroma.service: Deactivated successfully.
Feb 11 22:16:17 helix systemd[1]: pleroma.service: Unit process 3549 (epmd) remains running after unit stopped.
Feb 11 22:16:17 helix systemd[1]: Stopped Pleroma social network.
Feb 11 22:16:17 helix systemd[1]: pleroma.service: Consumed 26.472s CPU time.Edited by Kuoi Z