MacOS M1 fresh install fail

[OptimusKoala]

Hi, I've juste clone the repo with:

$ git clone https://github.com/plausible/community-edition hosting

I have thoses errors in my 'hosting-plausible-1' and the container in in crash loop.

Running migrations for Elixir.Plausible.Repo
2024-05-28 13:37:11 ** (ArgumentError) could not call Module.put_attribute/3 because the module Plausible.Repo.Migrations.AddPageviews is already compiled
2024-05-28 13:37:11 (elixir 1.16.0) lib/module.ex:2360: Module.assert_not_readonly!/2
2024-05-28 13:37:11 (elixir 1.16.0) lib/module.ex:2041: Module.put_attribute/5
2024-05-28 13:37:11 lib/plausible-0.0.1/priv/repo/migrations/20181214201821_add_new_visitor_to_pageviews.exs:2: (module)

I'm running macOS 14.4.1 with M1 chip
Docker version: v4.30.0

[ruslandoga]

👋 @OptimusKoala

I wasn't able to reproduce this error on a fresh install on M2 mac.

Please share your docker-compose.yml, plausible-conf.env (with secrets redacted), and the Docker Compose commands you used.

[OptimusKoala]

I don't have any exit code, the log loop on the same stuff.

I use docker compose in:
Docker Compose version v2.27.0-desktop.2

[ruslandoga]

I don't have any exit code, the log loop on the same stuff.

Please remove restart: always and docker compose up again. If the container stops, check the exit code with docker inspect <container-id>

[ruslandoga]

You can get the container ID from docker ps -a

[ruslandoga]

I haven't been able to reproduce the error with docker-compose up either. I would suggest trying the installation from scratch. Make sure to remove all Plausible containers, volumes, and images first.

[OptimusKoala]

Here a part of docker inspect:

"State": {
            "Status": "exited",
            "Running": false,
            "Paused": false,
            "Restarting": false,
            "OOMKilled": false,
            "Dead": false,
            "Pid": 0,
            "ExitCode": 1,
            "Error": "",
            "StartedAt": "2024-05-28T12:44:45.115784466Z",
            "FinishedAt": "2024-05-28T12:44:57.64311568Z"
        },

Here's the full log with docker compose logs

plausible-1  | Loading plausible..
plausible-1  | Starting dependencies..
plausible-1  | Starting repos..
plausible-1  | create Plausible.Repo database if it doesn't exist
plausible-1  | 12:44:56.107 [error] Ch.Connection (#PID<0.175.0>) failed to connect: ** (Ch.Error) Code: 81. DB::Exception: Database plausible_events_db does not exist. (UNKNOWN_DATABASE) (version 24.3.3.102 (official build))
plausible-1  |
plausible-1  | 12:44:56.107 [error] Ch.Connection (#PID<0.174.0>) failed to connect: ** (Ch.Error) Code: 81. DB::Exception: Database plausible_events_db does not exist. (UNKNOWN_DATABASE) (version 24.3.3.102 (official build))
plausible-1  |
plausible-1  | 12:44:56.111 [error] Postgrex.Protocol (#PID<0.168.0>) failed to connect: ** (Postgrex.Error) FATAL 3D000 (invalid_catalog_name) database "plausible_db" does not exist
plausible-1  | 12:44:56.111 [error] Postgrex.Protocol (#PID<0.167.0>) failed to connect: ** (Postgrex.Error) FATAL 3D000 (invalid_catalog_name) database "plausible_db" does not exist
plausible-1  | create Plausible.IngestRepo database if it doesn't exist
plausible-1  | Creation of Db successful!
plausible-1  | Loading plausible..
plausible-1  | Starting dependencies..
plausible-1  | Starting repos..
plausible-1  | Running migrations for Elixir.Plausible.Repo
plausible-1  | ** (ArgumentError) could not call Module.put_attribute/3 because the module Plausible.Repo.Migrations.AddPageviews is already compiled
plausible-1  |     (elixir 1.16.0) lib/module.ex:2360: Module.assert_not_readonly!/2
plausible-1  |     (elixir 1.16.0) lib/module.ex:2041: Module.__put_attribute__/5
plausible-1  |     lib/plausible-0.0.1/priv/repo/migrations/20181214201821_add_new_visitor_to_pageviews.exs:2: (module)
plausible_db-1  | The files belonging to this database system will be owned by user "postgres".
plausible_db-1  | This user must also own the server process.
plausible_db-1  |
plausible_db-1  | The database cluster will be initialized with locale "en_US.utf8".
plausible_db-1  | The default database encoding has accordingly been set to "UTF8".
plausible_db-1         | The default text search configuration will be set to "english".
plausible_db-1         |
plausible_events_db-1  | Processing configuration file '/etc/clickhouse-server/config.xml'.
plausible_events_db-1  | Merging configuration file '/etc/clickhouse-server/config.d/docker_related_config.xml'.
plausible_events_db-1  | Merging configuration file '/etc/clickhouse-server/config.d/logging.xml'.
plausible_events_db-1  | Logging warning to /var/log/clickhouse-server/clickhouse-server.log
plausible_events_db-1  | Logging errors to /var/log/clickhouse-server/clickhouse-server.err.log
plausible_db-1         | Data page checksums are disabled.
plausible_db-1         |
plausible_db-1         | fixing permissions on existing directory /var/lib/postgresql/data ... ok
plausible_db-1         | creating subdirectories ... ok
plausible_db-1         | selecting dynamic shared memory implementation ... posix
plausible_events_db-1  | 2024.05.28 12:44:46.890441 [ 1 ] {} <Warning> Context: Linux transparent hugepages are set to "always". Check /sys/kernel/mm/transparent_hugepage/enabled
plausible_events_db-1  | 2024.05.28 12:44:46.891025 [ 1 ] {} <Warning> Context: Delay accounting is not enabled, OSIOWaitMicroseconds will not be gathered. You can enable it using `echo 1 > /proc/sys/kernel/task_delayacct` or by using sysctl.
plausible_events_db-1  | 2024.05.28 12:44:47.110329 [ 1 ] {} <Error> Application: Disabling cgroup memory observer because of an error during initialization: Code: 107. DB::Exception: Cannot find cgroups v1 or v2 current memory file. (FILE_DOESNT_EXIST), Stack trace (when copying this message, always include the lines below):
plausible_events_db-1  |
plausible_events_db-1  | 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000cbc851b
plausible_events_db-1  | 1. DB::Exception::Exception<>(int, FormatStringHelperImpl<>) @ 0x00000000076614c3
plausible_events_db-1  | 2. DB::CgroupsMemoryUsageObserver::CgroupsMemoryUsageObserver(std::chrono::duration<long long, std::ratio<1l, 1l>>) @ 0x000000000cce452e
plausible_events_db-1  | 3. DB::Server::main(std::vector<String, std::allocator<String>> const&) @ 0x000000000cd562bd
plausible_events_db-1  | 4. Poco::Util::Application::run() @ 0x0000000014ca8606
plausible_events_db-1  | 5. DB::Server::run() @ 0x000000000cd46671
plausible_events_db-1  | 6. Poco::Util::ServerApplication::run(int, char**) @ 0x0000000014cb14b9
plausible_events_db-1  | 7. mainEntryClickHouseServer(int, char**) @ 0x000000000cd4246a
plausible_events_db-1  | 8. main @ 0x0000000007651578
plausible_db-1         | selecting default max_connections ... 100
plausible_db-1         | selecting default shared_buffers ... 128MB
plausible_db-1         | selecting default time zone ... UTC
plausible_db-1         | creating configuration files ... ok
plausible_events_db-1  | 9. ? @ 0x00007fffff5d2083
plausible_events_db-1  | 10. _start @ 0x0000000005dee46e
plausible_events_db-1  |  (version 24.3.3.102 (official build))
plausible_db-1         | running bootstrap script ... ok
plausible_events_db-1  | 2024.05.28 12:44:47.159563 [ 1 ] {} <Warning> Application: Listen [::]:9009 failed: Poco::Exception. Code: 1000, e.code() = 0, DNS error: EAI: Address family for hostname not supported (version 24.3.3.102 (official build)). If it is an IPv6 or IPv4 address and your host has disabled IPv6 or IPv4, then consider to specify not disabled IPv4 or IPv6 address to listen in <listen_host> element of configuration file. Example for disabled IPv6: <listen_host>0.0.0.0</listen_host> . Example for disabled IPv4: <listen_host>::</listen_host>
plausible_events_db-1  | 2024.05.28 12:44:47.180861 [ 1 ] {} <Warning> Access(local_directory): File /var/lib/clickhouse/access/users.list doesn't exist
plausible_events_db-1  | 2024.05.28 12:44:47.180960 [ 1 ] {} <Warning> Access(local_directory): Recovering lists in directory /var/lib/clickhouse/access/
plausible_events_db-1  | 2024.05.28 12:44:47.326650 [ 1 ] {} <Warning> Application: Listen [::]:8123 failed: Poco::Exception. Code: 1000, e.code() = 0, DNS error: EAI: Address family for hostname not supported (version 24.3.3.102 (official build)). If it is an IPv6 or IPv4 address and your host has disabled IPv6 or IPv4, then consider to specify not disabled IPv4 or IPv6 address to listen in <listen_host> element of configuration file. Example for disabled IPv6: <listen_host>0.0.0.0</listen_host> . Example for disabled IPv4: <listen_host>::</listen_host>
plausible_events_db-1  | 2024.05.28 12:44:47.326842 [ 1 ] {} <Warning> Application: Listen [::]:9000 failed: Poco::Exception. Code: 1000, e.code() = 0, DNS error: EAI: Address family for hostname not supported (version 24.3.3.102 (official build)). If it is an IPv6 or IPv4 address and your host has disabled IPv6 or IPv4, then consider to specify not disabled IPv4 or IPv6 address to listen in <listen_host> element of configuration file. Example for disabled IPv6: <listen_host>0.0.0.0</listen_host> . Example for disabled IPv4: <listen_host>::</listen_host>
plausible_events_db-1  | 2024.05.28 12:44:47.327018 [ 1 ] {} <Warning> Application: Listen [::]:9004 failed: Poco::Exception. Code: 1000, e.code() = 0, DNS error: EAI: Address family for hostname not supported (version 24.3.3.102 (official build)). If it is an IPv6 or IPv4 address and your host has disabled IPv6 or IPv4, then consider to specify not disabled IPv4 or IPv6 address to listen in <listen_host> element of configuration file. Example for disabled IPv6: <listen_host>0.0.0.0</listen_host> . Example for disabled IPv4: <listen_host>::</listen_host>
plausible_events_db-1  | 2024.05.28 12:44:47.327156 [ 1 ] {} <Warning> Application: Listen [::]:9005 failed: Poco::Exception. Code: 1000, e.code() = 0, DNS error: EAI: Address family for hostname not supported (version 24.3.3.102 (official build)). If it is an IPv6 or IPv4 address and your host has disabled IPv6 or IPv4, then consider to specify not disabled IPv4 or IPv6 address to listen in <listen_host> element of configuration file. Example for disabled IPv6: <listen_host>0.0.0.0</listen_host> . Example for disabled IPv4: <listen_host>::</listen_host>
plausible_events_db-1  | 2024.05.28 12:44:56.050171 [ 48 ] {} <Error> DynamicQueryHandler: Code: 81. DB::Exception: Database plausible_events_db does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below):
plausible_events_db-1  |
plausible_events_db-1  | 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000cbc851b
plausible_events_db-1  | 1. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x0000000007654b03
plausible_events_db-1  | 2. DB::DatabaseCatalog::assertDatabaseExists(String const&) const @ 0x000000001055538e
plausible_events_db-1  | 3. DB::Context::setCurrentDatabase(String const&) @ 0x000000001049dc32
plausible_events_db-1  | 4. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional<DB::CurrentThread::QueryScope>&, StrongTypedef<unsigned long, ProfileEvents::EventTag> const&) @ 0x00000000122ef386
plausible_events_db-1  | 5. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&, StrongTypedef<unsigned long, ProfileEvents::EventTag> const&) @ 0x00000000122f4b34
plausible_events_db-1  | 6. DB::HTTPServerConnection::run() @ 0x00000000123740da
plausible_events_db-1  | 7. Poco::Net::TCPServerConnection::start() @ 0x0000000014c9b8d2
plausible_events_db-1  | 8. Poco::Net::TCPServerDispatcher::run() @ 0x0000000014c9c719
plausible_db-1         | sh: locale: not found
plausible_db-1         | 2024-05-28 12:44:45.673 UTC [30] WARNING:  no usable system locales were found
plausible_events_db-1  | 9. Poco::PooledThread::run() @ 0x0000000014d94e81
plausible_events_db-1  | 10. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000014d9341d
plausible_events_db-1  | 11. ? @ 0x00007fffff7a8609
plausible_events_db-1  | 12. ? @ 0x00007fffff6cd353
plausible_events_db-1  |  (version 24.3.3.102 (official build))
plausible_events_db-1  | 2024.05.28 12:44:56.050250 [ 49 ] {} <Error> DynamicQueryHandler: Code: 81. DB::Exception: Database plausible_events_db does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below):
plausible_events_db-1  |
plausible_events_db-1  | 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000cbc851b
plausible_events_db-1  | 1. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x0000000007654b03
plausible_events_db-1  | 2. DB::DatabaseCatalog::assertDatabaseExists(String const&) const @ 0x000000001055538e
plausible_db-1         | performing post-bootstrap initialization ... ok
plausible_db-1         | syncing data to disk ... ok
plausible_db-1         |
plausible_db-1         | initdb: warning: enabling "trust" authentication for local connections
plausible_db-1         | initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
plausible_db-1         |
plausible_db-1         | Success. You can now start the database server using:
plausible_db-1         |
plausible_db-1         |     pg_ctl -D /var/lib/postgresql/data -l logfile start
plausible_db-1         |
plausible_db-1         | waiting for server to start....2024-05-28 12:44:46.113 UTC [36] LOG:  starting PostgreSQL 16.3 on x86_64-pc-linux-musl, compiled by gcc (Alpine 13.2.1_git20240309) 13.2.1 20240309, 64-bit
plausible_db-1         | 2024-05-28 12:44:46.114 UTC [36] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
plausible_db-1         | 2024-05-28 12:44:46.120 UTC [39] LOG:  database system was shut down at 2024-05-28 12:44:45 UTC
plausible_db-1         | 2024-05-28 12:44:46.129 UTC [36] LOG:  database system is ready to accept connections
plausible_db-1         |  done
plausible_db-1         | server started
plausible_db-1         |
plausible_db-1         | /usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*
plausible_db-1         |
plausible_db-1         | waiting for server to shut down....2024-05-28 12:44:46.227 UTC [36] LOG:  received fast shutdown request
plausible_db-1         | 2024-05-28 12:44:46.229 UTC [36] LOG:  aborting any active transactions
plausible_db-1         | 2024-05-28 12:44:46.233 UTC [36] LOG:  background worker "logical replication launcher" (PID 42) exited with exit code 1
plausible_db-1         | 2024-05-28 12:44:46.235 UTC [37] LOG:  shutting down
plausible_db-1         | 2024-05-28 12:44:46.236 UTC [37] LOG:  checkpoint starting: shutdown immediate
plausible_db-1         | 2024-05-28 12:44:46.242 UTC [37] LOG:  checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.002 s, sync=0.001 s, total=0.007 s; sync files=2, longest=0.001 s, average=0.001 s; distance=0 kB, estimate=0 kB; lsn=0/14EFC28, redo lsn=0/14EFC28
plausible_db-1         | 2024-05-28 12:44:46.248 UTC [36] LOG:  database system is shut down
plausible_db-1         |  done
plausible_db-1         | server stopped
plausible_db-1         |
plausible_db-1         | PostgreSQL init process complete; ready for start up.
plausible_db-1         |
plausible_db-1         | 2024-05-28 12:44:46.378 UTC [1] LOG:  starting PostgreSQL 16.3 on x86_64-pc-linux-musl, compiled by gcc (Alpine 13.2.1_git20240309) 13.2.1 20240309, 64-bit
plausible_db-1         | 2024-05-28 12:44:46.380 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
plausible_db-1         | 2024-05-28 12:44:46.380 UTC [1] LOG:  listening on IPv6 address "::", port 5432
plausible_db-1         | 2024-05-28 12:44:46.382 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
plausible_db-1         | 2024-05-28 12:44:46.389 UTC [50] LOG:  database system was shut down at 2024-05-28 12:44:46 UTC
plausible_db-1         | 2024-05-28 12:44:46.400 UTC [1] LOG:  database system is ready to accept connections
plausible_db-1         | 2024-05-28 12:44:56.099 UTC [55] FATAL:  database "plausible_db" does not exist
plausible_db-1         | 2024-05-28 12:44:56.100 UTC [54] FATAL:  database "plausible_db" does not exist
plausible_events_db-1  | 3. DB::Context::setCurrentDatabase(String const&) @ 0x000000001049dc32
plausible_events_db-1  | 4. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional<DB::CurrentThread::QueryScope>&, StrongTypedef<unsigned long, ProfileEvents::EventTag> const&) @ 0x00000000122ef386
plausible_events_db-1  | 5. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&, StrongTypedef<unsigned long, ProfileEvents::EventTag> const&) @ 0x00000000122f4b34
plausible_events_db-1  | 6. DB::HTTPServerConnection::run() @ 0x00000000123740da
plausible_events_db-1  | 7. Poco::Net::TCPServerConnection::start() @ 0x0000000014c9b8d2
plausible_events_db-1  | 8. Poco::Net::TCPServerDispatcher::run() @ 0x0000000014c9c719
plausible_events_db-1  | 9. Poco::PooledThread::run() @ 0x0000000014d94e81
plausible_events_db-1  | 10. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000014d9341d
plausible_events_db-1  | 11. ? @ 0x00007fffff7a8609
plausible_events_db-1  | 12. ? @ 0x00007fffff6cd353
plausible_events_db-1  |  (version 24.3.3.102 (official build))

[udf2457]

@OptimusKoala did you ever find a solution ?