Comments (8)
ruslandoga
commented on July 20, 2024
1
Compose file looks fine, createdb is present. Could you please post more logs? And please use text and not images :)
from community-edition.
ruslandoga
commented on July 20, 2024
👋 @Sw0xy
Please show your docker-compose.yml
from community-edition.
Sw0xy
commented on July 20, 2024
👋
from community-edition.
Sw0xy
commented on July 20, 2024
plausible_events_db-1 | 2024.06.18 16:51:09.599832 [ 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.06.18 16:51:09.611795 [ 1 ] {} <Warning> Access(local_directory): File /var/lib/clickhouse/access/users.list doesn't exist
plausible_events_db-1 | 2024.06.18 16:51:09.613928 [ 1 ] {} <Warning> Access(local_directory): Recovering lists in directory /var/lib/clickhouse/access/
plausible_events_db-1 | 2024.06.18 16:51:09.696165 [ 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.06.18 16:51:09.696624 [ 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.06.18 16:51:09.696991 [ 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.06.18 16:51:09.697365 [ 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.06.18 16:51:19.174825 [ 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_events_db-1 | 9. Poco::PooledThread::run() @ 0x0000000014d94e81
plausible_events_db-1 | 10. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000014d9341d
plausible_events_db-1 | 11. ? @ 0x00007f12cadc6609
plausible_events_db-1 | 12. ? @ 0x00007f12caceb353
plausible_events_db-1 | (version 24.3.3.102 (official build))
plausible_events_db-1 | 2024.06.18 16:51:19.176498 [ 47 ] {} <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_events_db-1 | 9. Poco::PooledThread::run() @ 0x0000000014d94e81
plausible_events_db-1 | 10. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000014d9341d
plausible_events_db-1 | 11. ? @ 0x00007f12cadc6609
plausible_events_db-1 | 12. ? @ 0x00007f12caceb353
plausible_events_db-1 | (version 24.3.3.102 (official build))
from community-edition.
ruslandoga
commented on July 20, 2024
Please post logs from both plausible and plausible_events_db containers.
from community-edition.
Sw0xy
commented on July 20, 2024
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_events_db-1 | 2024.06.18 16:51:09.599832 [ 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.06.18 16:51:09.611795 [ 1 ] {} <Warning> Access(local_directory): File /var/lib/clickhouse/access/users.list doesn't exist
plausible_events_db-1 | 2024.06.18 16:51:09.613928 [ 1 ] {} <Warning> Access(local_directory): Recovering lists in directory /var/lib/clickhouse/access/
plausible_events_db-1 | 2024.06.18 16:51:09.696165 [ 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.06.18 16:51:09.696624 [ 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.06.18 16:51:09.696991 [ 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.06.18 16:51:09.697365 [ 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.06.18 16:51:19.174825 [ 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_events_db-1 | 9. Poco::PooledThread::run() @ 0x0000000014d94e81
plausible_events_db-1 | 10. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000014d9341d
plausible_events_db-1 | 11. ? @ 0x00007f12cadc6609
plausible_events_db-1 | 12. ? @ 0x00007f12caceb353
plausible_events_db-1 | (version 24.3.3.102 (official build))
plausible_events_db-1 | 2024.06.18 16:51:19.176498 [ 47 ] {} <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_events_db-1 | 9. Poco::PooledThread::run() @ 0x0000000014d94e81
plausible_events_db-1 | 10. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000014d9341d
plausible_events_db-1 | 11. ? @ 0x00007f12cadc6609
plausible_events_db-1 | 12. ? @ 0x00007f12caceb353
plausible_events_db-1 | (version 24.3.3.102 (official build))
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_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_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_db-1 | running bootstrap script ... ok
plausible_db-1 | sh: locale: not found
plausible_db-1 | 2024-06-18 16:51:09.645 UTC [29] WARNING: no usable system locales were found
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-06-18 16:51:10.469 UTC [35] 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-06-18 16:51:10.473 UTC [35] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
plausible_db-1 | 2024-06-18 16:51:10.483 UTC [38] LOG: database system was shut down at 2024-06-18 16:51:10 UTC
plausible_db-1 | 2024-06-18 16:51:10.493 UTC [35] 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 | 2024-06-18 16:51:10.567 UTC [35] LOG: received fast shutdown request
plausible_db-1 | waiting for server to shut down....2024-06-18 16:51:10.571 UTC [35] LOG: aborting any active transactions
plausible_db-1 | 2024-06-18 16:51:10.589 UTC [35] LOG: background worker "logical replication launcher" (PID 41) exited with exit code 1
plausible_db-1 | 2024-06-18 16:51:10.590 UTC [36] LOG: shutting down
plausible_db-1 | 2024-06-18 16:51:10.592 UTC [36] LOG: checkpoint starting: shutdown immediate
plausible_db-1 | 2024-06-18 16:51:10.607 UTC [36] LOG: checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.004 s, sync=0.002 s, total=0.017 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-06-18 16:51:10.615 UTC [35] 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-06-18 16:51:10.716 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-06-18 16:51:10.719 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
plausible_db-1 | 2024-06-18 16:51:10.719 UTC [1] LOG: listening on IPv6 address "::", port 5432
plausible_db-1 | 2024-06-18 16:51:10.724 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
plausible_db-1 | 2024-06-18 16:51:10.731 UTC [49] LOG: database system was shut down at 2024-06-18 16:51:10 UTC
plausible_db-1 | 2024-06-18 16:51:10.739 UTC [1] LOG: database system is ready to accept connections
plausible_db-1 | 2024-06-18 16:51:19.150 UTC [54] FATAL: database "plausible_db" does not exist
plausible_db-1 | 2024-06-18 16:51:19.154 UTC [53] FATAL: database "plausible_db" does not exist
plausible_db-1 | 2024-06-18 16:56:10.836 UTC [47] LOG: checkpoint starting: time
plausible_db-1 | 2024-06-18 16:58:09.104 UTC [47] LOG: checkpoint complete: wrote 1182 buffers (7.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=118.175 s, sync=0.056 s, total=118.271 s; sync files=591, longest=0.009 s, average=0.001 s; distance=6960 kB, estimate=6960 kB; lsn=0/1BBC190, redo lsn=0/1BBBE60
plausible_db-1 | 2024-06-18 17:01:10.211 UTC [47] LOG: checkpoint starting: time
plausible_db-1 | 2024-06-18 17:01:11.542 UTC [47] LOG: checkpoint complete: wrote 14 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.311 s, sync=0.005 s, total=1.331 s; sync files=9, longest=0.003 s, average=0.001 s; distance=9 kB, estimate=6265 kB; lsn=0/1BBE450, redo lsn=0/1BBE418
plausible_db-1 | 2024-06-18 17:06:10.640 UTC [47] LOG: checkpoint starting: time
plausible_db-1 | 2024-06-18 17:06:11.069 UTC [47] LOG: checkpoint complete: wrote 5 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.411 s, sync=0.005 s, total=0.430 s; sync files=7, longest=0.003 s, average=0.001 s; distance=12 kB, estimate=5640 kB; lsn=0/1BC1528, redo lsn=0/1BC14F0
plausible_db-1 | 2024-06-18 17:11:10.143 UTC [47] LOG: checkpoint starting: time
plausible_db-1 | 2024-06-18 17:11:10.161 UTC [47] LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.003 s, sync=0.002 s, total=0.019 s; sync files=1, longest=0.002 s, average=0.002 s; distance=2 kB, estimate=5076 kB; lsn=0/1BC1D30, redo lsn=0/1BC1CF8
plausible_db-1 | 2024-06-18 17:16:10.262 UTC [47] LOG: checkpoint starting: time
plausible_db-1 | 2024-06-18 17:16:11.295 UTC [47] LOG: checkpoint complete: wrote 11 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.010 s, sync=0.003 s, total=1.034 s; sync files=9, longest=0.002 s, average=0.001 s; distance=16 kB, estimate=4570 kB; lsn=0/1BC6018, redo lsn=0/1BC5FC8
plausible_db-1 | 2024-06-18 17:21:10.377 UTC [47] LOG: checkpoint starting: time
plausible_db-1 | 2024-06-18 17:21:10.502 UTC [47] LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.106 s, sync=0.004 s, total=0.125 s; sync files=2, longest=0.003 s, average=0.002 s; distance=8 kB, estimate=4114 kB; lsn=0/1BC8370, redo lsn=0/1BC8338
plausible_db-1 | 2024-06-18 17:26:10.580 UTC [47] LOG: checkpoint starting: time
plausible_db-1 | 2024-06-18 17:26:10.603 UTC [47] LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.007 s, sync=0.002 s, total=0.023 s; sync files=1, longest=0.002 s, average=0.002 s; distance=2 kB, estimate=3702 kB; lsn=0/1BC8B78, redo lsn=0/1BC8B40
plausible_db-1 | 2024-06-18 17:31:10.696 UTC [47] LOG: checkpoint starting: time
plausible_db-1 | 2024-06-18 17:31:11.721 UTC [47] LOG: checkpoint complete: wrote 11 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.008 s, sync=0.005 s, total=1.026 s; sync files=9, longest=0.003 s, average=0.001 s; distance=18 kB, estimate=3334 kB; lsn=0/1BCD5B0, redo lsn=0/1BCD578
plausible_db-1 | 2024-06-18 17:36:10.784 UTC [47] LOG: checkpoint starting: time
plausible_db-1 | 2024-06-18 17:36:10.803 UTC [47] LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.004 s, sync=0.002 s, total=0.020 s; sync files=1, longest=0.002 s, average=0.002 s; distance=2 kB, estimate=3001 kB; lsn=0/1BCDDB8, redo lsn=0/1BCDD80
plausible_db-1 | 2024-06-18 17:41:10.904 UTC [47] LOG: checkpoint starting: time
plausible_db-1 | 2024-06-18 17:41:11.126 UTC [47] LOG: checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.205 s, sync=0.004 s, total=0.222 s; sync files=3, longest=0.003 s, average=0.002 s; distance=11 kB, estimate=2702 kB; lsn=0/1BD0C10, redo lsn=0/1BD0BD8
plausible_db-1 | 2024-06-18 17:46:10.219 UTC [47] LOG: checkpoint starting: time
plausible_db-1 | 2024-06-18 17:46:11.143 UTC [47] LOG: checkpoint complete: wrote 10 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.908 s, sync=0.004 s, total=0.925 s; sync files=8, longest=0.003 s, average=0.001 s; distance=17 kB, estimate=2433 kB; lsn=0/1BD5048, redo lsn=0/1BD5010
plausible_db-1 | 2024-06-18 17:51:10.244 UTC [47] LOG: checkpoint starting: time
plausible_db-1 | 2024-06-18 17:51:10.264 UTC [47] LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.004 s, sync=0.002 s, total=0.021 s; sync files=1, longest=0.002 s, average=0.002 s; distance=2 kB, estimate=2190 kB; lsn=0/1BD5850, redo lsn=0/1BD5818
plausible_db-1 | 2024-06-18 17:56:10.365 UTC [47] LOG: checkpoint starting: time
plausible_db-1 | 2024-06-18 17:56:10.587 UTC [47] LOG: checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.204 s, sync=0.004 s, total=0.223 s; sync files=3, longest=0.003 s, average=0.002 s; distance=12 kB, estimate=1972 kB; lsn=0/1BD8918, redo lsn=0/1BD88E0
plausible_db-1 | 2024-06-18 18:01:10.688 UTC [47] LOG: checkpoint starting: time
plausible_db-1 | 2024-06-18 18:01:11.513 UTC [47] LOG: checkpoint complete: wrote 9 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.806 s, sync=0.005 s, total=0.825 s; sync files=7, longest=0.003 s, average=0.001 s; distance=18 kB, estimate=1777 kB; lsn=0/1BDD388, redo lsn=0/1BDD350
plausible_db-1 | 2024-06-18 18:06:10.610 UTC [47] LOG: checkpoint starting: time
plausible_db-1 | 2024-06-18 18:06:10.833 UTC [47] LOG: checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.205 s, sync=0.004 s, total=0.223 s; sync files=3, longest=0.003 s, average=0.002 s; distance=12 kB, estimate=1600 kB; lsn=0/1BE04C8, redo lsn=0/1BE0490
plausible_db-1 | 2024-06-18 18:11:10.932 UTC [47] LOG: checkpoint starting: time
plausible_db-1 | 2024-06-18 18:11:11.053 UTC [47] LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.105 s, sync=0.004 s, total=0.122 s; sync files=2, longest=0.003 s, average=0.002 s; distance=8 kB, estimate=1441 kB; lsn=0/1BE2820, redo lsn=0/1BE27E8
plausible_db-1 | 2024-06-18 18:16:10.142 UTC [47] LOG: checkpoint starting: time
plausible_db-1 | 2024-06-18 18:16:10.970 UTC [47] LOG: checkpoint complete: wrote 9 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.807 s, sync=0.005 s, total=0.828 s; sync files=7, longest=0.003 s, average=0.001 s; distance=11 kB, estimate=1298 kB; lsn=0/1BE56A0, redo lsn=0/1BE5668
plausible_db-1 | 2024-06-18 18:21:11.070 UTC [47] LOG: checkpoint starting: time
plausible_db-1 | 2024-06-18 18:21:11.294 UTC [47] LOG: checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.205 s, sync=0.004 s, total=0.224 s; sync files=3, longest=0.003 s, average=0.002 s; distance=13 kB, estimate=1170 kB; lsn=0/1BE8AB0, redo lsn=0/1BE8A78
plausible_db-1 | 2024-06-18 18:26:11.388 UTC [47] LOG: checkpoint starting: time
plausible_db-1 | 2024-06-18 18:26:11.408 UTC [47] LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.004 s, sync=0.002 s, total=0.021 s; sync files=1, longest=0.002 s, average=0.002 s; distance=2 kB, estimate=1053 kB; lsn=0/1BE92B8, redo lsn=0/1BE9280
plausible_db-1 | 2024-06-18 18:31:11.497 UTC [47] LOG: checkpoint starting: time
plausible_db-1 | 2024-06-18 18:31:12.522 UTC [47] LOG: checkpoint complete: wrote 11 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.008 s, sync=0.005 s, total=1.026 s; sync files=9, longest=0.003 s, average=0.001 s; distance=23 kB, estimate=950 kB; lsn=0/1BEF278, redo lsn=0/1BEF240
plausible_db-1 | 2024-06-18 18:36:11.623 UTC [47] LOG: checkpoint starting: time
plausible_db-1 | 2024-06-18 18:36:11.744 UTC [47] LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.104 s, sync=0.004 s, total=0.122 s; sync files=2, longest=0.003 s, average=0.002 s; distance=8 kB, estimate=856 kB; lsn=0/1BF1598, redo lsn=0/1BF1560
plausible_db-1 | 2024-06-18 18:41:11.844 UTC [47] LOG: checkpoint starting: time
plausible_db-1 | 2024-06-18 18:41:11.863 UTC [47] LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.004 s, sync=0.002 s, total=0.020 s; sync files=1, longest=0.002 s, average=0.002 s; distance=1 kB, estimate=770 kB; lsn=0/1BF1D78, redo lsn=0/1BF1D40
plausible_db-1 | 2024-06-18 18:46:11.940 UTC [47] LOG: checkpoint starting: time
plausible_db-1 | 2024-06-18 18:46:12.967 UTC [47] LOG: checkpoint complete: wrote 11 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.007 s, sync=0.007 s, total=1.027 s; sync files=9, longest=0.004 s, average=0.001 s; distance=25 kB, estimate=696 kB; lsn=0/1BF8498, redo lsn=0/1BF8460
plausible_db-1 | 2024-06-18 18:51:12.048 UTC [47] LOG: checkpoint starting: time
plausible_db-1 | 2024-06-18 18:51:12.066 UTC [47] LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.004 s, sync=0.002 s, total=0.018 s; sync files=1, longest=0.002 s, average=0.002 s; distance=2 kB, estimate=626 kB; lsn=0/1BF8CA0, redo lsn=0/1BF8C68
plausible_db-1 | 2024-06-18 18:56:12.166 UTC [47] LOG: checkpoint starting: time
plausible_db-1 | 2024-06-18 18:56:12.390 UTC [47] LOG: checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.205 s, sync=0.004 s, total=0.224 s; sync files=3, longest=0.003 s, average=0.002 s; distance=14 kB, estimate=565 kB; lsn=0/1BFC4A0, redo lsn=0/1BFC468
plausible_db-1 | 2024-06-18 19:01:12.464 UTC [47] LOG: checkpoint starting: time
plausible_db-1 | 2024-06-18 19:01:13.435 UTC [47] LOG: checkpoint complete: wrote 10 buffers (0.1%); 1 WAL file(s) added, 0 removed, 0 recycled; write=0.908 s, sync=0.005 s, total=0.972 s; sync files=8, longest=0.003 s, average=0.001 s; distance=26 kB, estimate=511 kB; lsn=0/1C02ED8, redo lsn=0/1C02EA0
plausible_db-1 | 2024-06-18 19:06:12.515 UTC [47] LOG: checkpoint starting: time
plausible_db-1 | 2024-06-18 19:06:12.532 UTC [47] LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.004 s, sync=0.002 s, total=0.018 s; sync files=1, longest=0.002 s, average=0.002 s; distance=2 kB, estimate=460 kB; lsn=0/1C036E0, redo lsn=0/1C036A8
plausible_db-1 | 2024-06-18 19:11:12.610 UTC [47] LOG: checkpoint starting: time
plausible_db-1 | 2024-06-18 19:11:12.835 UTC [47] LOG: checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.205 s, sync=0.004 s, total=0.225 s; sync files=3, longest=0.003 s, average=0.002 s; distance=14 kB, estimate=416 kB; lsn=0/1C071B0, redo lsn=0/1C07178
plausible_db-1 | 2024-06-18 19:16:12.932 UTC [47] LOG: checkpoint starting: time
plausible_db-1 | 2024-06-18 19:16:15.260 UTC [47] LOG: checkpoint complete: wrote 24 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=2.311 s, sync=0.006 s, total=2.329 s; sync files=14, longest=0.004 s, average=0.001 s; distance=45 kB, estimate=379 kB; lsn=0/1C128C0, redo lsn=0/1C12860
plausible_db-1 | 2024-06-18 19:21:12.339 UTC [47] LOG: checkpoint starting: time
plausible_db-1 | 2024-06-18 19:21:12.561 UTC [47] LOG: checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.205 s, sync=0.004 s, total=0.222 s; sync files=2, longest=0.003 s, average=0.002 s; distance=1 kB, estimate=341 kB; lsn=0/1C13078, redo lsn=0/1C13040
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 | 16:51:19.169 [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 | 16:51:19.169 [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 | 16:51:19.186 [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 | 16:51:19.186 [error] Ch.Connection (#PID<0.176.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 | 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 | Backfilling legacy site import across 0 sites (DRY RUN: false)...
plausible-1 | Finished backfilling sites.
plausible-1 | Adjusting end dates of 0 site imports (DRY RUN: false)...
plausible-1 | Finished adjusting end dates of site imports.
plausible-1 | Finished
plausible-1 | Running migrations for Elixir.Plausible.IngestRepo
plausible-1 | warning: code block contains unused literal "Migration adds a ALIAS columns needed to keep DB schema and api\nproperty naming in sync to reduce overhead in code.\n" (remove the literal or assign it to _ to avoid warnings)
plausible-1 | └─ lib/plausible-0.0.1/priv/ingest_repo/migrations/20240502115822_alias_api_prop_names.exs: Plausible.IngestRepo.Migrations.AliasApiPropNames (module)
plausible-1 |
plausible-1 | list-partitions Done!
plausible-1 |
plausible-1 | ------------------------------------------------------------------------------
plausible-1 | get-sessions-table-settings Done!
plausible-1 |
plausible-1 | ------------------------------------------------------------------------------
plausible-1 | drop-sessions-tmp-table Done!
plausible-1 |
plausible-1 | ------------------------------------------------------------------------------
plausible-1 | create-sessions-tmp-table Done!
plausible-1 |
plausible-1 | ------------------------------------------------------------------------------
plausible-1 | exchange-sessions-tables Done!
plausible-1 |
plausible-1 | ------------------------------------------------------------------------------
plausible-1 | Migration done!
plausible-1 | Migrations successful!
from community-edition.
ruslandoga
commented on July 20, 2024
plausible-1 | Migration done!
plausible-1 | Migrations successful!
Seems like everything's OK?
from community-edition.
Sw0xy
commented on July 20, 2024
Yeah, it works, but I wanted to make sure
from community-edition.
Related Issues (20)
- document TOTP_VAULT_KEY length requirement HOT 1
- add Bamboo.Mua + gmail app password guide HOT 1
- document extra config
- Web page is not accessible after deploy containers using docker composer HOT 1
- Is it possible to use GeoIP databases with additional information? HOT 4
- document docker compose override files
- Arm64 Images support HOT 2
- Upgrade from 1.5 to 2.1 RC resulted in data loss HOT 2
- CH volume for logs
- Feature Request: Expose custom JS API to detect unique user/visitor HOT 1
- Clickhouse version 23.3 no longer supported HOT 3
- document DATA_DIR HOT 1
- [error] <PID> running PlausibleWeb.Endpoint (connection stream id ) terminated | (Protocol.UndefinedError) protocol Jason.Encoder not implemented for HOT 5
- Raspberry Pi + Cloudflare tunnel issue while docker compose HOT 5
- Preview doesn't load HOT 2
- Plausible log in weekly/monthly email reports points to a HTTP 404 link HOT 3
- Caddy-gen doesn't support ARM
- External Postgres DB connection (with ssl, digitalocean) does not work HOT 7
- enable query_log in ClickHouse HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from community-edition.