-
Notifications
You must be signed in to change notification settings - Fork 8.3k
MaterializeMySQL Code: 46. DB::Exception: Received from localhost:9000. DB::Exception: Unknown function task_id #15187
Description
Describe the bug
version: 20.10.1.4699
I got this issue when access table after MaterializeMySQL database created , and found some tables not synchronized to CH from MySQL
How to reproduce
CREATE DATABASE credit_ga ENGINE = MaterializeMySQL('192.168.1.123:3306', 'credit_ga', 'root', '123456');
test-1-118.raipeng.com :) use credit_ga
test-1-118.raipeng.com :) SELECT *FROM aaa
SELECT *
FROM aaa
Received exception from server (version 20.10.1):
Code: 46. DB::Exception: Received from localhost:9000. DB::Exception: Unknown function task_id.
0 rows in set. Elapsed: 0.003 sec.
error log as below:
2020.09.23 17:27:57.140067 [ 22323 ] {} MaterializeMySQLSyncThread: Code: 46, e.displayText() = DB::Exception: Unknown function task_id, Stack trace (when copying this message, always include the lines below):
- Poco::Exception::Exception(std::__1::basic_string<char, std::__1::char_traits, std::__1::allocator > const&, int) @ 0x114fb850 in /usr/bin/clickhouse
- DB::Exception::Exception(std::__1::basic_string<char, std::__1::char_traits, std::__1::allocator > const&, int) @ 0x8367afd in /usr/bin/clickhouse
- ? @ 0xdd5051a in /usr/bin/clickhouse
- DB::FunctionFactory::get(std::__1::basic_string<char, std::__1::char_traits, std::__1::allocator > const&, DB::Context const&) const @ 0xdd4fdd5 in /usr/bin/clickhouse
- DB::ActionsMatcher::visit(DB::ASTFunction const&, std::__1::shared_ptrDB::IAST const&, DB::ActionsMatcher::Data&) @ 0xe44e00c in /usr/bin/clickhouse
- DB::ActionsMatcher::visit(DB::ASTFunction const&, std::__1::shared_ptrDB::IAST const&, DB::ActionsMatcher::Data&) @ 0xe44e169 in /usr/bin/clickhouse
- ? @ 0xe428873 in /usr/bin/clickhouse
- DB::ExpressionAnalyzer::getActions(bool, bool) @ 0xe42e147 in /usr/bin/clickhouse
- ? @ 0xe704160 in /usr/bin/clickhouse
- ? @ 0xe705add in /usr/bin/clickhouse
- DB::MySQLInterpreter::InterpreterCreateImpl::getRewrittenQueries(DB::MySQLParser::ASTCreateQuery const&, DB::Context const&, std::__1::basic_string<char, std::__1::char_traits, std::__1::allocator > const&, std::__1::basic_string<char, std::__1::char_traits, std::__1::allocator > const&) @ 0xe708b8b in /usr/bin/clickhouse
- DB::InterpreterExternalDDLQuery::execute() @ 0xe376835 in /usr/bin/clickhouse
- ? @ 0xe6e22bc in /usr/bin/clickhouse
- DB::executeQuery(std::__1::basic_string<char, std::__1::char_traits, std::__1::allocator > const&, DB::Context&, bool, DB::QueryProcessingStage::Enum, bool) @ 0xe6e41a1 in /usr/bin/clickhouse
- ? @ 0xe2d2664 in /usr/bin/clickhouse
- ? @ 0xe2ddb63 in /usr/bin/clickhouse
- ? @ 0xe2df273 in /usr/bin/clickhouse
- DB::commitMetadata(std::__1::function<void ()> const&, std::__1::basic_string<char, std::__1::char_traits, std::__1::allocator > const&, std::__1::basic_string<char, std::__1::char_traits, std::__1::allocator > const&) @ 0xe317429 in /usr/bin/clickhouse
- DB::MaterializeMetadata::transaction(DB::MySQLReplication::Position const&, std::__1::function<void ()> const&) @ 0xe31983e in /usr/bin/clickhouse
- DB::MaterializeMySQLSyncThread::prepareSynchronized(std::__1::basic_string<char, std::__1::char_traits, std::__1::allocator > const&) @ 0xe2d3d72 in /usr/bin/clickhouse
- DB::MaterializeMySQLSyncThread::synchronization(std::__1::basic_string<char, std::__1::char_traits, std::__1::allocator > const&) @ 0xe2dc17b in /usr/bin/clickhouse
- ? @ 0xe2dc6c6 in /usr/bin/clickhouse
- ThreadPoolImplstd::__1::thread::worker(std::__1::__list_iterator<std::__1::thread, void*>) @ 0x8395fcf in /usr/bin/clickhouse
- ? @ 0x83948f3 in /usr/bin/clickhouse
- start_thread @ 0x7ea5 in /usr/lib64/libpthread-2.17.so
- __clone @ 0xfe8dd in /usr/lib64/libc-2.17.so
(version 20.10.1.4699 (official build))