Всем привет, обновил clickhouse на локальном компьютере, теперь он не

поднимается, валится с ошибкой:

2023.11.15 10:53:11.735595 [ 8069 ] {} <Error> Application: Code: 48. DB::Exception: Data directory for system database exists, but metadata file does not. Probably you are trying to upgrade from version older than 20.7. If so, you should upgrade through intermediate version. (NOT_IMPLEMENTED), Stack trace (when copying this message, always include the lines below):

0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000cdcda77 in /usr/bin/clickhouse
1. DB::Exception::Exception<String const&>(int, FormatStringHelperImpl<std::type_identity<String const&>::type>, String const&) @ 0x000000000799d10d in /usr/bin/clickhouse
2. DB::checkUnsupportedVersion(std::shared_ptr<DB::Context>, String const&) @ 0x0000000012bff470 in /usr/bin/clickhouse
3. DB::loadSystemDatabaseImpl(std::shared_ptr<DB::Context>, String const&, String const&) @ 0x0000000012c07dcb in /usr/bin/clickhouse
4. DB::loadMetadataSystem(std::shared_ptr<DB::Context>) @ 0x0000000012c06d7e in /usr/bin/clickhouse
5. DB::Server::main(std::vector<String, std::allocator<String>> const&) @ 0x000000000ce6d9c5 in /usr/bin/clickhouse
6. Poco::Util::Application::run() @ 0x000000001659a566 in /usr/bin/clickhouse
7. DB::Server::run() @ 0x000000000ce5cbbe in /usr/bin/clickhouse
8. Poco::Util::ServerApplication::run(int, char**) @ 0x00000000165a92d9 in /usr/bin/clickhouse
9. mainEntryClickHouseServer(int, char**) @ 0x000000000ce59aaa in /usr/bin/clickhouse
10. main @ 0x00000000073b7a3a in /usr/bin/clickhouse
11. ? @ 0x00007fc7100230b3 in ?
12. _start @ 0x000000000658f5ae in /usr/bin/clickhouse

а с какой версии то обновляли?? ошибку правильно говорит вообще? ls -la /var/lib/clickhouse/metadata/ покажите?

C 18.6 которая ubuntu поставила через apt-get install, дальше качал deb пакеты из репозитория и ставил через dpkg

ух...очень старая версия ... =) сделайте ```echo "ATTACH DATABASE system UUID '3ee5356d-80aa-4bcb-84fd-c7058e2079c3' ENGINE = Atomic' > /var/lib/clickhouse/metadata/system.sql` вместо dpkg -i лучше было подключить просто официальный репозиторий https://clickhouse.com/docs/en/install#setup-the-debian-repository

DB::Exception: Directory /var/lib/clickhouse/metadata/system exists: while loading database `system` from path /var/lib/clickhouse/metadata/system. (FILE_ALREADY_EXISTS), Stack trace (when copying this message, always include the lines below):

rm -rf /var/lib/clickhouse/metadata/system

Вернулась старая ошибка: Data directory for system database exists, but metadata file does not. Probably you are trying to upgrade from version older than 20.7. If so, you should upgrade through intermediate version. (NOT_IMPLEMENTED), Stack trace (when copying this message, always include the lines below):

ls -la /var/lib/clickhouse/metadata rm -rf /var/lib/clickhouse/data/system

Стикер

chown clickhouse:clickhouse -R /var/lib/clickhouse

Та-же самая ошибка

ls -la /var/lib/clickhouse/data/

Стикер

rm -rf /var/lib/clickhouse/data/system

Потом в логах та-же ошибка, возможно из-за того что у меня базы есть старые с версии 18

какая конкретно ошибка? можете уже начать текстом расшарить информаацию... а то картинки эти бесят потому что база system в metadata уже создалась 18е база по идее может сконвертироваться в современный формат...

2023.11.15 11:13:33.058559 [ 20259 ] {} <Error> Application: Code: 48. DB::Exception: Data directory for default database exists, but metadata file does not. Probably you are trying to upgrade from version older than 20.7. If so, you should upgrade through intermediate version. (NOT_IMPLEMENTED), Stack trace (when copying this message, always include the lines below): 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000cdcda77 in /usr/bin/clickhouse 1. DB::Exception::Exception<String const&>(int, FormatStringHelperImpl<std::type_identity<String const&>::type>, String const&) @ 0x000000000799d10d in /usr/bin/clickhouse 2. DB::checkUnsupportedVersion(std::shared_ptr<DB::Context>, String const&) @ 0x0000000012bff470 in /usr/bin/clickhouse 3. DB::loadMetadata(std::shared_ptr<DB::Context>, String const&) @ 0x0000000012bfd737 in /usr/bin/clickhouse 4. DB::Server::main(std::vector<String, std::allocator<String>> const&) @ 0x000000000ce6ddfa in /usr/bin/clickhouse 5. Poco::Util::Application::run() @ 0x000000001659a566 in /usr/bin/clickhouse 6. DB::Server::run() @ 0x000000000ce5cbbe in /usr/bin/clickhouse 7. Poco::Util::ServerApplication::run(int, char**) @ 0x00000000165a92d9 in /usr/bin/clickhouse 8. mainEntryClickHouseServer(int, char**) @ 0x000000000ce59aaa in /usr/bin/clickhouse 9. main @ 0x00000000073b7a3a in /usr/bin/clickhouse 10. ? @ 0x00007f34422e00b3 in ? 11. _start @ 0x000000000658f5ae in /usr/bin/clickhouse (version 23.10.3.5 (official build))

cat "ATTACH DATABASE default ENGINE=Ordinary" > /var/lib/clickhouse/metadata/default.sql