V2.0.0 fails with clean install #4166
Answered
by
ruslandoga
coderdiaz
asked this question in
Self-Hosted Support
-
Hey, I'm trying to install a new instance of plausible using the v2.0.0 branch but I'm having this issue. Processing configuration file '/etc/clickhouse-server/config.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/docker_related_config.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/logging.xml'.
Logging warning to /var/log/clickhouse-server/clickhouse-server.log
Logging errors to /var/log/clickhouse-server/clickhouse-server.err.log
2024.05.30 17:49:59.040292 [ 1 ] {} <Warning> Context: Linux threads max count is too low. Check /proc/sys/kernel/threads-max
2024.05.30 17:49:59.042653 [ 1 ] {} <Warning> Context: Available memory at server startup is too low (2GiB).
2024.05.30 17:50:00.553423 [ 294 ] {} <Error> plausible_events_db.ingest_counters (1b8cd44c-5907-4450-b669-146d833beb30): while loading part all_1_14235_7062 on path store/1b8/1b8cd44c-5907-4450-b669-146d833beb30/all_1_14235_7062: Code: 27. DB::ParsingException: Cannot parse input: expected 'columns format version: 1\n' at end of stream. (CANNOT_PARSE_INPUT_ASSERTION_FAILED), Stack trace (when copying this message, always include the lines below):
0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0xe1dc395 in /usr/bin/clickhouse
1. ? @ 0xe23aaa4 in /usr/bin/clickhouse
2. DB::throwAtAssertionFailed(char const*, DB::ReadBuffer&) @ 0xe23a9a1 in /usr/bin/clickhouse
3. DB::NamesAndTypesList::readText(DB::ReadBuffer&) @ 0x127e0138 in /usr/bin/clickhouse
4. DB::IMergeTreeDataPart::loadColumns(bool) @ 0x14485578 in /usr/bin/clickhouse
5. DB::IMergeTreeDataPart::loadColumnsChecksumsIndexes(bool, bool) @ 0x14484eaa in /usr/bin/clickhouse
6. DB::MergeTreeData::loadDataPart(DB::MergeTreePartInfo const&, String const&, std::shared_ptr<DB::IDisk> const&, DB::MergeTreeDataPartState, std::mutex&) @ 0x14502ff5 in /usr/bin/clickhouse
7. ? @ 0x14590784 in /usr/bin/clickhouse
8. ThreadPoolImpl<ThreadFromGlobalPoolImpl<false>>::worker(std::__list_iterator<ThreadFromGlobalPoolImpl<false>, void*>) @ 0xe2af905 in /usr/bin/clickhouse
9. void std::__function::__policy_invoker<void ()>::__call_impl<std::__function::__default_alloc_func<ThreadFromGlobalPoolImpl<false>::ThreadFromGlobalPoolImpl<void ThreadPoolImpl<ThreadFromGlobalPoolImpl<false>>::scheduleImpl<void>(std::function<void ()>, long, std::optional<unsigned long>, bool)::'lambda0'()>(void&&)::'lambda'(), void ()>>(std::__function::__policy_storage const*) @ 0xe2b2475 in /usr/bin/clickhouse
10. ThreadPoolImpl<std::thread>::worker(std::__list_iterator<std::thread, void*>) @ 0xe2ab6d3 in /usr/bin/clickhouse
11. ? @ 0xe2b1341 in /usr/bin/clickhouse
12. ? @ 0x7f7b5c731609 in ?
13. clone @ 0x7f7b5c656133 in ?
(version 23.3.7.5 (official build))
2024.05.30 17:50:00.554282 [ 294 ] {} <Error> plausible_events_db.ingest_counters (1b8cd44c-5907-4450-b669-146d833beb30): Detaching broken part /var/lib/clickhouse/store/1b8/1b8cd44c-5907-4450-b669-146d833beb30/all_1_14235_7062 (size: 0.00 B). If it happened after update, it is likely because of backward incompatibility. You need to resolve this manually
2024.05.30 17:50:00.602348 [ 1 ] {} <Warning> Application: Listen [::]:8123 failed: Poco::Exception. Code: 1000, e.code() = 0, DNS error: EAI: Address family for hostname not supported (version 23.3.7.5 (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>
2024.05.30 17:50:00.602884 [ 1 ] {} <Warning> Application: Listen [::]:9000 failed: Poco::Exception. Code: 1000, e.code() = 0, DNS error: EAI: Address family for hostname not supported (version 23.3.7.5 (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>
2024.05.30 17:50:00.603149 [ 1 ] {} <Warning> Application: Listen [::]:9004 failed: Poco::Exception. Code: 1000, e.code() = 0, DNS error: EAI: Address family for hostname not supported (version 23.3.7.5 (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>
2024.05.30 17:50:00.603510 [ 1 ] {} <Warning> Application: Listen [::]:9005 failed: Poco::Exception. Code: 1000, e.code() = 0, DNS error: EAI: Address family for hostname not supported (version 23.3.7.5 (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>
2024.05.30 17:50:00.681083 [ 1 ] {} <Warning> Application: Listen [::]:9009 failed: Poco::Exception. Code: 1000, e.code() = 0, DNS error: EAI: Address family for hostname not supported (version 23.3.7.5 (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>
2024.05.30 17:50:15.338519 [ 49 ] {d9eff382-c4d3-4f61-9cd8-b356812bb681} <Error> executeQuery: Code: 82. DB::Exception: Database plausible_events_db already exists. (DATABASE_ALREADY_EXISTS) (version 23.3.7.5 (official build)) (from 172.20.0.4:43036) (in query: CREATE DATABASE "plausible_events_db"), Stack trace (when copying this message, always include the lines below):
0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0xe1dc395 in /usr/bin/clickhouse
1. ? @ 0x8d65bc4 in /usr/bin/clickhouse
2. DB::InterpreterCreateQuery::createDatabase(DB::ASTCreateQuery&) @ 0x1366b2e2 in /usr/bin/clickhouse
3. DB::InterpreterCreateQuery::execute() @ 0x136891cd in /usr/bin/clickhouse
4. ? @ 0x13bf4307 in /usr/bin/clickhouse
5. DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, std::shared_ptr<DB::Context>, std::function<void (DB::QueryResultDetails const&)>, std::optional<DB::FormatSettings> const&) @ 0x13bfa0cc in /usr/bin/clickhouse
6. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional<DB::CurrentThread::QueryScope>&) @ 0x149708d3 in /usr/bin/clickhouse
7. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x14974bee in /usr/bin/clickhouse
8. DB::HTTPServerConnection::run() @ 0x149e367d in /usr/bin/clickhouse
9. Poco::Net::TCPServerConnection::start() @ 0x179217d4 in /usr/bin/clickhouse
10. Poco::Net::TCPServerDispatcher::run() @ 0x179229fb in /usr/bin/clickhouse
11. Poco::PooledThread::run() @ 0x17aaa287 in /usr/bin/clickhouse
12. Poco::ThreadImpl::runnableEntry(void*) @ 0x17aa7cbd in /usr/bin/clickhouse
13. ? @ 0x7f7b5c731609 in ?
14. clone @ 0x7f7b5c656133 in ?
2024.05.30 17:50:15.341566 [ 49 ] {d9eff382-c4d3-4f61-9cd8-b356812bb681} <Error> DynamicQueryHandler: Code: 82. DB::Exception: Database plausible_events_db already exists. (DATABASE_ALREADY_EXISTS), Stack trace (when copying this message, always include the lines below):
0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0xe1dc395 in /usr/bin/clickhouse
1. ? @ 0x8d65bc4 in /usr/bin/clickhouse
2. DB::InterpreterCreateQuery::createDatabase(DB::ASTCreateQuery&) @ 0x1366b2e2 in /usr/bin/clickhouse
3. DB::InterpreterCreateQuery::execute() @ 0x136891cd in /usr/bin/clickhouse
4. ? @ 0x13bf4307 in /usr/bin/clickhouse
5. DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, std::shared_ptr<DB::Context>, std::function<void (DB::QueryResultDetails const&)>, std::optional<DB::FormatSettings> const&) @ 0x13bfa0cc in /usr/bin/clickhouse
6. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional<DB::CurrentThread::QueryScope>&) @ 0x149708d3 in /usr/bin/clickhouse
7. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x14974bee in /usr/bin/clickhouse
8. DB::HTTPServerConnection::run() @ 0x149e367d in /usr/bin/clickhouse
9. Poco::Net::TCPServerConnection::start() @ 0x179217d4 in /usr/bin/clickhouse
10. Poco::Net::TCPServerDispatcher::run() @ 0x179229fb in /usr/bin/clickhouse
11. Poco::PooledThread::run() @ 0x17aaa287 in /usr/bin/clickhouse
12. Poco::ThreadImpl::runnableEntry(void*) @ 0x17aa7cbd in /usr/bin/clickhouse
13. ? @ 0x7f7b5c731609 in ?
14. clone @ 0x7f7b5c656133 in ?
(version 23.3.7.5 (official build)) Any idea how can I fix it? |
Beta Was this translation helpful? Give feedback.
Answered by
ruslandoga
May 30, 2024
Replies: 1 comment 1 reply
-
The error means ClickHouse cannot process a part on disk. If it's a fresh install, you can try nuking the volume and trying it again. |
Beta Was this translation helpful? Give feedback.
1 reply
Answer selected by
coderdiaz
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
👋 @coderdiaz
The error means ClickHouse cannot process a part on disk. If it's a fresh install, you can try nuking the volume and trying it again.