Table bp_by_login doesn't exist. (version 20.6.4.44 (official build))

создавал через create dictionary

detach dictionary bp_by_login
attach dictionary bp_by_login
drop dictionary bp_by_login

Добрый вечер, а никто не сталкивался с 2020.08.28 17:14:08.394197 [ 23226 ] {} <Error> DynamicQueryHandler: Code: 24, e.displayText() = DB::Exception: Cannot write to ostream at offset 3145728: While executing Tab
SeparatedRowOutputFormat, Stack trace (when copying this message, always include the lines below):

0. Poco::Exception::Exception(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, int) @ 0xcc3083c in /usr/bin/clickhouse
1. DB::Exception::Exception(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, int) @ 0x5a54619 in /usr/bin/clickhouse
2. ? @ 0x57fb550 in /usr/bin/clickhouse
3. DB::WriteBufferFromHTTPServerResponse::nextImpl() @ 0xabb45fb in /usr/bin/clickhouse
4. DB::CompressedWriteBuffer::nextImpl() @ 0x9b7232f in /usr/bin/clickhouse
5. void DB::writeAnyEscapedString<(char)39, false>(char const*, char const*, DB::WriteBuffer&) @ 0x5a566ed in /usr/bin/clickhouse
6. DB::DataTypeNullable::serializeTextEscaped(DB::IColumn const&, unsigned long, DB::WriteBuffer&, DB::FormatSettings const&) const @ 0x9c212f5 in /usr/bin/clickhouse
7. DB::IRowOutputFormat::write(std::__1::vector<COW<DB::IColumn>::immutable_ptr<DB::IColumn>, std::__1::allocator<COW<DB::IColumn>::immutable_ptr<DB::IColumn> > > const&, uns
igned long) @ 0xa8be251 in /usr/bin/clickhouse
8. DB::IRowOutputFormat::consume(DB::Chunk) @ 0xa8be0fa in /usr/bin/clickhouse
9. DB::IOutputFormat::work() @ 0xa37f533 in /usr/bin/clickhouse
10. ? @ 0xa3661cf in /usr/bin/clickhouse
11. ? @ 0xa36b608 in /usr/bin/clickhouse
12. ? @ 0xa36c741 in /usr/bin/clickhouse
13. ThreadPoolImpl<std::__1::thread>::worker(std::__1::__list_iterator<std::__1::thread, void*>) @ 0x5a5e12d in /usr/bin/clickhouse
14. ? @ 0x5a5c7af in /usr/bin/clickhouse
15. start_thread @ 0x7ea5 in /usr/lib64/libpthread-2.17.so
16. __clone @ 0xfe8dd in /usr/lib64/libc-2.17.so
(version 20.5.4.40)

Работает пару дней и перестает. После перезапуска .. еще пару дней 🙂

Detach - Table bp_by_login doesn't exist. (version 20.6.4.44 (official build))
attach - Dictionary bp_by_login already exists. (version 20.6.4.44 (official build))
drop - Table bp_by_login doesn't exist. (version 20.6.4.44 (official build))

сколько памяти у сервера?
попробуйте 20.5.5.74

а как вы смогли удалить dictionary как таблицу (drop table)? в 20.3 например не дает

SQL Error [60]: ClickHouse exception, code: 60, host: clickhouse-01.net, port: 8123; Code: 60, e.displayText() = DB::Exception: Cannot detach dictionary schema.djtest as table, use DETACH DICTIONARY query. (version 20.3.11.97 (official build))

16Gb

а что делал поток [ 23226 ]
поищте в логе 23226 перед этим

а не, все верно, он пишет ошибку но что то ломает, теперь и у меня сломалось все =)

SQL Error [60]: ClickHouse exception, code: 60, host: clickhouse-01.net, port: 8123; Code: 60, e.displayText() = DB::Exception: Cannot detach dictionary schema.djtest as table, use DETACH DICTIONARY query. (version 20.3.11.97 (official build))

Пользуюсь DBeaver.  Просто в списке таблиц выбрал и через контекстное меню удалил.

правда у меня detach dictionary отработал без проблем

/clickhouse/data/metadata/<dbname>/<dictionaryname>.sql

файл естть?

Не могу сказать, Не имею доступа. Нужно просить админа, а он уже убежал.

2020.08.28 17:14:08.353646 [ 23226 ] {8bdbd26b-cb74-47ce-a73e-ca377979165f} <Error> executeQuery: Code: 24, e.displayText() = DB::Exception: Cannot write to ostream at offset 3145728: While executing TabSeparatedRowOutputFormat (version 20.5.4.40) (from 10.5.4.116:63962) (in query: select * from policy inner join ( select POLICY_ID,max(ENDORSEMENT_LAST_EFFECTIVE_DATE) ENDORSEMENT_LAST_EFFECTIVE_DATE from ( select * from policy where ((STATUS='Действующий' or STATUS='Действует' or POLICY_END_DATE > '2020-07-28')) ) t group by POLICY_ID ) tt using(POLICY_ID,ENDORSEMENT_LAST_EFFECTIVE_DATE) order by POLICY_ID limit 1 by POLICY_ID limit 86498 offset 259494 FORMAT TabSeparatedWithNamesAndTypes;), Stack trace (when copying this message, always include the lines below):

0. Poco::Exception::Exception(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, int) @ 0xcc3083c in /usr/bin/clickhouse
1. DB::Exception::Exception(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, int) @ 0x5a54619 in /usr/bin/clickhouse
2. ? @ 0x57fb550 in /usr/bin/clickhouse
3. DB::WriteBufferFromHTTPServerResponse::nextImpl() @ 0xabb45fb in /usr/bin/clickhouse
4. DB::CompressedWriteBuffer::nextImpl() @ 0x9b7232f in /usr/bin/clickhouse
5. void DB::writeAnyEscapedString<(char)39, false>(char const*, char const*, DB::WriteBuffer&) @ 0x5a566ed in /usr/bin/clickhouse
6. DB::DataTypeNullable::serializeTextEscaped(DB::IColumn const&, unsigned long, DB::WriteBuffer&, DB::FormatSettings const&) const @ 0x9c212f5 in /usr/bin/clickhouse
7. DB::IRowOutputFormat::write(std::__1::vector<COW<DB::IColumn>::immutable_ptr<DB::IColumn>, std::__1::allocator<COW<DB::IColumn>::immutable_ptr<DB::IColumn> > > const&, unsigned long) @ 0xa8be251 in /usr/bin/clickhouse
8. DB::IRowOutputFormat::consume(DB::Chunk) @ 0xa8be0fa in /usr/bin/clickhouse
9. DB::IOutputFormat::work() @ 0xa37f533 in /usr/bin/clickhouse
10. ? @ 0xa3661cf in /usr/bin/clickhouse
11. ? @ 0xa36b608 in /usr/bin/clickhouse
12. ? @ 0xa36c741 in /usr/bin/clickhouse
13. ThreadPoolImpl<std::__1::thread>::worker(std::__1::__list_iterator<std::__1::thread, void*>) @ 0x5a5e12d in /usr/bin/clickhouse
14. ? @ 0x5a5c7af in /usr/bin/clickhouse
15. start_thread @ 0x7ea5 in /usr/lib64/libpthread-2.17.so
16. __clone @ 0xfe8dd in /usr/lib64/libc-2.17.so

а free -h в линуксе что показывает?

total        used        free      shared  buff/cache   available
Mem:            15G        4,4G        7,3G        327M        3,8G         10G
Swap:          511M        511M          0B

select * from system.dictionaries d where name like 'dictname';
а здесь видно после дропа?

вообще это все таки баг, вы бы тикет завели...

Есть в dictionaries, и даже видно что работает, дата обновления меняется.