Report on MIX_ENV=dev mix phx.server on Debian Buster 10.0 version
$ MIX_ENV=prod mix phx.server
** (Code.LoadError) could not load /home/pleroma/pleroma/config/prod.secret.exs
(elixir) lib/code.ex:1147: Code.find_file/2
(elixir) lib/code.ex:706: Code.eval_file/2
(mix) lib/mix/config.ex:187: anonymous fn/2 in Mix.Config.__import__!/2
(elixir) lib/enum.ex:1925: Enum."-reduce/3-lists^foldl/2-0-"/3
(mix) lib/mix/config.ex:186: Mix.Config.__import__!/2
(stdlib) erl_eval.erl:680: :erl_eval.do_apply/6
(stdlib) erl_eval.erl:126: :erl_eval.exprs/5
$ MIX_ENV=dev mix phx.server
Compiling 254 files (.ex)
Compiling lib/pleroma/scheduled_activity_worker.ex (it's taking more than 15s)
Compiling lib/pleroma/web/activity_pub/views/user_view.ex (it's taking more than 15s)
Compiling lib/pleroma/web/activity_pub/views/object_view.ex (it's taking more than 15s)
Compiling lib/pleroma/plugs/set_user_session_id_plug.ex (it's taking more than 15s)
Compiling lib/pleroma/web/websub/websub_client_subscription.ex (it's taking more than 15s)
Compiling lib/pleroma/web/admin_api/views/config_view.ex (it's taking more than 15s)
Compiling lib/pleroma/web/mastodon_api/views/conversation_view.ex (it's taking more than 15s)
Compiling lib/pleroma/web/twitter_api/twitter_api_controller.ex (it's taking more than 15s)
Compiling lib/pleroma/web/media_proxy/media_proxy_controller.ex (it's taking more than 15s)
Compiling lib/pleroma/web/activity_pub/mrf/mention_policy.ex (it's taking more than 15s)
Compiling lib/pleroma/web/activity_pub/mrf/user_allowlist_policy.ex (it's taking more than 15s)
Compiling lib/pleroma/web/activity_pub/mrf/no_placeholder_text_policy.ex (it's taking more than 15s)
Compiling lib/pleroma/web/mastodon_api/views/list_view.ex (it's taking more than 15s)
Compiling lib/pleroma/plugs/rate_limiter.ex (it's taking more than 15s)
Compiling lib/pleroma/plugs/ensure_authenticated_plug.ex (it's taking more than 15s)
Compiling lib/pleroma/web/activity_pub/mrf/hellthread_policy.ex (it's taking more than 15s)
Compiling lib/pleroma/web/auth/pleroma_authenticator.ex (it's taking more than 15s)
Compiling lib/pleroma/web/activity_pub/mrf/drop_policy.ex (it's taking more than 15s)
Compiling lib/pleroma/signature.ex (it's taking more than 15s)
Compiling lib/pleroma/web/activity_pub/utils.ex (it's taking more than 15s)
Compiling lib/pleroma/password_reset_token.ex (it's taking more than 15s)
Compiling lib/pleroma/notification.ex (it's taking more than 15s)
Compiling lib/pleroma/web/activity_pub/activity_pub_controller.ex (it's taking more than 15s)
Compiling lib/pleroma/web/channels/user_socket.ex (it's taking more than 15s)
Compiling lib/pleroma/web/activity_pub/mrf/tag_policy.ex (it's taking more than 15s)
Compiling lib/pleroma/web/auth/ldap_authenticator.ex (it's taking more than 15s)
Compiling lib/pleroma/web/views/mailer/subscription_view.ex (it's taking more than 15s)
Compiling lib/pleroma/plugs/legacy_authentication_plug.ex (it's taking more than 15s)
Compiling lib/pleroma/web/mastodon_api/views/account_view.ex (it's taking more than 15s)
Compiling lib/pleroma/web/federator/publisher.ex (it's taking more than 15s)
Compiling lib/pleroma/web/mastodon_api/views/app_view.ex (it's taking more than 15s)
Compiling lib/pleroma/web/push/subscription.ex (it's taking more than 15s)
Compiling lib/pleroma/web/streamer.ex (it's taking more than 15s)
Compiling lib/pleroma/web/activity_pub/mrf/mediaproxy_warming_policy.ex (it's taking more than 15s)
Compiling lib/pleroma/web/twitter_api/views/password_view.ex (it's taking more than 15s)
Compiling lib/pleroma/web/mastodon_api/views/mastodon_view.ex (it's taking more than 15s)
Compiling lib/pleroma/web/oauth/fallback_controller.ex (it's taking more than 15s)
Compiling lib/pleroma/web/mastodon_api/views/filter_view.ex (it's taking more than 15s)
Compiling lib/pleroma/web/mastodon_api/subscription_controller.ex (it's taking more than 15s)
Compiling lib/pleroma/web/views/error_view.ex (it's taking more than 15s)
Compiling lib/pleroma/web/websub/websub.ex (it's taking more than 15s)
Compiling lib/pleroma/web/uploader_controller.ex (it's taking more than 15s)
Compiling lib/pleroma/web/mastodon_api/mastodon_api_controller.ex (it's taking more than 15s)
Compiling lib/pleroma/web/mongooseim/mongoose_im_controller.ex (it's taking more than 15s)
Compiling lib/pleroma/web/admin_api/views/account_view.ex (it's taking more than 15s)
Compiling lib/pleroma/web/controller_helper.ex (it's taking more than 15s)
Compiling lib/pleroma/web/mastodon_api/views/scheduled_activity_view.ex (it's taking more than 15s)
Compiling lib/pleroma/web/mastodon_api/views/status_view.ex (it's taking more than 15s)
Compiling lib/pleroma/web/twitter_api/controllers/password_controller.ex (it's taking more than 15s)
Compiling lib/pleroma/web/web_finger/web_finger_controller.ex (it's taking more than 15s)
Compiling lib/pleroma/web/oauth/oauth_view.ex (it's taking more than 15s)
Compiling lib/pleroma/web/views/layout_view.ex (it's taking more than 15s)
Compiling lib/pleroma/web/websub/websub_controller.ex (it's taking more than 15s)
Compiling lib/pleroma/web/mastodon_api/views/push_subscription_view.ex (it's taking more than 15s)
Compiling lib/pleroma/web/twitter_api/views/activity_view.ex (it's taking more than 15s)
Compiling lib/pleroma/web/twitter_api/views/user_view.ex (it's taking more than 15s)
Compiling lib/pleroma/web/mastodon_api/views/notification_view.ex (it's taking more than 15s)
Generated pleroma app
[debug] QUERY OK db=1.8ms decode=4.8ms queue=80.9ms
SELECT true FROM information_schema.tables WHERE table_name = $1 AND table_schema = current_schema() LIMIT 1 ["config"]
[info] Retry queue disabled
[debug] QUERY ERROR source="users" db=0.0ms queue=30.5ms
SELECT distinct split_part(u0."nickname", '@', 2) FROM "users" AS u0 WHERE (u0."local" != $1) [true]
[error] Process #PID<0.1965.0> raised an exception
** (Postgrex.Error) ERROR 42P01 (undefined_table) relation "users" does not exist
query: SELECT distinct split_part(u0."nickname", '@', 2) FROM "users" AS u0 WHERE (u0."local" != $1)
(ecto_sql) lib/ecto/adapters/sql.ex:618: Ecto.Adapters.SQL.raise_sql_call_error/1
(ecto_sql) lib/ecto/adapters/sql.ex:551: Ecto.Adapters.SQL.execute/5
(ecto) lib/ecto/repo/queryable.ex:153: Ecto.Repo.Queryable.execute/4
(ecto) lib/ecto/repo/queryable.ex:18: Ecto.Repo.Queryable.all/3
(pleroma) lib/pleroma/stats.ex:41: Pleroma.Stats.update_stats/0
[info] Running Pleroma.Web.Endpoint with cowboy 2.6.3 at 127.0.0.1:4000 (http)
[info] Access Pleroma.Web.Endpoint at https://pleroma.gnusocial.club
[info] Gopher server disabled
[debug] Tzdata polling for update.
[info] tzdata release in place is from a file last modified Tue, 26 Mar 2019 05:40:14 GMT. Release file on server was last modified Mon, 01 Jul 2019 16:50:25 GMT.
[debug] Tzdata downloading new data from https://data.iana.org/time-zones/tzdata-latest.tar.gz
[debug] Tzdata data downloaded. Release version 2019b.
[info] Tzdata has updated the release from 2019a to 2019b
[debug] Tzdata deleting ETS table for version 2019a
[debug] Tzdata deleting ETS table file for version 2019a
[debug] QUERY ERROR source="users" db=0.0ms queue=0.8ms
SELECT u0."id", u0."bio", u0."email", u0."name", u0."nickname", u0."password_hash", u0."following", u0."ap_id", u0."avatar", u0."local", u0."follower_address", u0."following_address", u0."tags", u0."last_refreshed_at", u0."last_digest_emailed_at", u0."info", u0."inserted_at", u0."updated_at" FROM "users" AS u0 WHERE (u0."ap_id" = $1) ["https://pleroma.gnusocial.club/internal/fetch"]
[error] Task #PID<0.1968.0> started from Pleroma.Supervisor terminating
** (Cachex.ExecutionError) ERROR 42P01 (undefined_table) relation "users" does not exist
query: SELECT u0."id", u0."bio", u0."email", u0."name", u0."nickname", u0."password_hash", u0."following", u0."ap_id", u0."avatar", u0."local", u0."follower_address", u0."following_address", u0."tags", u0."last_refreshed_at", u0."last_digest_emailed_at", u0."info", u0."inserted_at", u0."updated_at" FROM "users" AS u0 WHERE (u0."ap_id" = $1)
(cachex) lib/cachex.ex:1447: Cachex.unwrap_unsafe/1
(pleroma) lib/pleroma/user.ex:1239: Pleroma.User.get_or_create_service_actor_by_ap_id/2
(elixir) lib/task/supervised.ex:89: Task.Supervised.do_apply/2
(stdlib) proc_lib.erl:249: :proc_lib.init_p_do_apply/3
Function: &Pleroma.Web.ActivityPub.InternalFetchActor.init/0
Args: []
[debug] QUERY ERROR source="scheduled_activities" db=0.0ms queue=1.7ms
SELECT s0."id", s0."user_id", s0."scheduled_at", s0."params", s0."inserted_at", s0."updated_at" FROM "scheduled_activities" AS s0 WHERE (s0."scheduled_at" < $1) [~N[2019-08-14 11:47:10]]
[debug] Federator running refresh subscriptions
[debug] Refreshing subscriptions
[debug] QUERY ERROR source="websub_client_subscriptions" db=0.0ms queue=2.2ms
SELECT w0."id", w0."topic", w0."secret", w0."valid_until", w0."state", w0."subscribers", w0."hub", w0."user_id", w0."inserted_at", w0."updated_at" FROM "websub_client_subscriptions" AS w0 WHERE (w0."valid_until" < $1) [~N[2019-08-15 11:46:10.947416]]
[error] GenServer #PID<0.1960.0> terminating
** (Postgrex.Error) ERROR 42P01 (undefined_table) relation "scheduled_activities" does not exist
query: SELECT s0."id", s0."user_id", s0."scheduled_at", s0."params", s0."inserted_at", s0."updated_at" FROM "scheduled_activities" AS s0 WHERE (s0."scheduled_at" < $1)
(ecto_sql) lib/ecto/adapters/sql.ex:618: Ecto.Adapters.SQL.raise_sql_call_error/1
(ecto_sql) lib/ecto/adapters/sql.ex:551: Ecto.Adapters.SQL.execute/5
(ecto) lib/ecto/repo/queryable.ex:153: Ecto.Repo.Queryable.execute/4
(ecto) lib/ecto/repo/queryable.ex:18: Ecto.Repo.Queryable.all/3
(pleroma) lib/pleroma/scheduled_activity_worker.ex:46: Pleroma.ScheduledActivityWorker.handle_info/2
(stdlib) gen_server.erl:637: :gen_server.try_dispatch/4
(stdlib) gen_server.erl:711: :gen_server.handle_msg/6
(stdlib) proc_lib.erl:249: :proc_lib.init_p_do_apply/3
Last message: :perform
State: nil
[error] Task #PID<0.2100.0> started from PleromaJobQueue.Worker terminating
** (Postgrex.Error) ERROR 42P01 (undefined_table) relation "websub_client_subscriptions" does not exist
query: SELECT w0."id", w0."topic", w0."secret", w0."valid_until", w0."state", w0."subscribers", w0."hub", w0."user_id", w0."inserted_at", w0."updated_at" FROM "websub_client_subscriptions" AS w0 WHERE (w0."valid_until" < $1)
(ecto_sql) lib/ecto/adapters/sql.ex:618: Ecto.Adapters.SQL.raise_sql_call_error/1
(ecto_sql) lib/ecto/adapters/sql.ex:551: Ecto.Adapters.SQL.execute/5
(ecto) lib/ecto/repo/queryable.ex:153: Ecto.Repo.Queryable.execute/4
(ecto) lib/ecto/repo/queryable.ex:18: Ecto.Repo.Queryable.all/3
(pleroma) lib/pleroma/web/websub/websub.ex:284: Pleroma.Web.Websub.refresh_subscriptions/1
(pleroma) lib/pleroma/web/federator/federator.ex:67: Pleroma.Web.Federator.perform/1
(elixir) lib/task/supervised.ex:89: Task.Supervised.do_apply/2
(stdlib) proc_lib.erl:249: :proc_lib.init_p_do_apply/3
Function: #Function<3.126871548/0 in PleromaJobQueue.Worker.maybe_start_job/4>
Args: []
Edited by Jean Louis