gistfile1.txt

2020.08.07 10:47:28.265213 [ 1440 ] {} <Information> SentryWriter: Sending crash reports is disabled
2020.08.07 10:47:29.049967 [ 1440 ] {} <Information> : Starting ClickHouse 20.7.1.1 with revision 54437, build id: 6B6B94644A3E2A235068C211D37F04E26023F84D, PID 1440
2020.08.07 10:47:29.050329 [ 1440 ] {} <Information> : Set OOM score adjustment to 555
2020.08.07 10:47:29.050688 [ 1440 ] {} <Information> Application: starting up
2020.08.07 10:47:29.067010 [ 1440 ] {} <Warning> Application: Server was built in debug mode. It will work slowly.
2020.08.07 10:47:29.071078 [ 1440 ] {} <Information> StatusFile: Status file /home/avtokmakov/ch/test/atomic_tmp/status already exists - unclean restart. Contents:
PID: 658
Started at: 2020-08-07 10:42:54
Revision: 54437

2020.08.07 10:47:29.109239 [ 1440 ] {} <Information> Application: Setting max_server_memory_usage was set to 39.78 GiB (44.20 GiB available * 0.90 max_server_memory_usage_to_ram_ratio)
2020.08.07 10:47:29.109324 [ 1440 ] {} <Information> Application: Loading metadata from /home/avtokmakov/ch/test/atomic_tmp/
2020.08.07 10:47:29.148884 [ 1440 ] {} <Information> DatabaseOrdinary (system): Total 5 tables and 0 dictionaries.
2020.08.07 10:47:29.184691 [ 1446 ] {} <Information> BackgroundProcessingPool: Create BackgroundProcessingPool with 16 threads
2020.08.07 10:47:29.318048 [ 1440 ] {} <Information> DatabaseOrdinary (system): Starting up tables.
2020.08.07 10:47:29.337309 [ 1440 ] {} <Information> DatabaseOrdinary (default): Total 0 tables and 0 dictionaries.
2020.08.07 10:47:29.337397 [ 1440 ] {} <Information> DatabaseOrdinary (default): Starting up tables.
2020.08.07 10:47:29.341441 [ 1440 ] {} <Information> DatabaseOrdinary (test_database): Total 1 tables and 0 dictionaries.
2020.08.07 10:47:29.346543 [ 1440 ] {} <Information> DatabaseOrdinary (test_database): Starting up tables.
2020.08.07 10:47:29.347423 [ 1440 ] {} <Information> Application: MYSQL: Connecting to test_database@172.17.0.2:3306 as user root
2020.08.07 10:47:36.469094 [ 1440 ] {} <Error> Application: mysqlxx::ConnectionFailed
2020.08.07 10:47:36.990773 [ 1440 ] {} <Error> DatabaseMaterializeMySQL: Cannot load MySQL nested database stored objects.: Poco::Exception. Code: 1000, e.code() = 2002, e.displayText() = mysqlxx::ConnectionFailed: Can't connect to MySQL server on '172.17.0.2' (115) ((nullptr):0), Stack trace (when copying this message, always include the lines below):

0. /home/avtokmakov/ch/ClickHouse/build_debug/../contrib/libcxx/include/exception:129: std::exception::capture() @ 0xe9c1078 in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse
1. /home/avtokmakov/ch/ClickHouse/build_debug/../contrib/libcxx/include/exception:109: std::exception::exception() @ 0xe9c1045 in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse
2. /home/avtokmakov/ch/ClickHouse/build_debug/../contrib/poco/Foundation/src/Exception.cpp:27: Poco::Exception::Exception(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, int) @ 0x1aa26583 in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse
3. /home/avtokmakov/ch/ClickHouse/build_debug/../base/common/../mysqlxx/Exception.h:13: mysqlxx::Exception::Exception(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, int) @ 0x12c6952d in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse
4. /home/avtokmakov/ch/ClickHouse/build_debug/../base/mysqlxx/../mysqlxx/Exception.h:23: mysqlxx::ConnectionFailed::ConnectionFailed(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, int) @ 0x1a8b7d3d in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse
5. /home/avtokmakov/ch/ClickHouse/build_debug/../base/mysqlxx/Connection.cpp:112: mysqlxx::Connection::connect(char const*, char const*, char const*, char const*, unsigned int, char const*, char const*, char const*, char const*, unsigned int, unsigned int, bool) @ 0x1a8b6ddd in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse
6. /home/avtokmakov/ch/ClickHouse/build_debug/../base/mysqlxx/Pool.cpp:258: mysqlxx::Pool::allocConnection(bool) @ 0x1a8bd952 in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse
7. /home/avtokmakov/ch/ClickHouse/build_debug/../base/mysqlxx/Pool.cpp:240: mysqlxx::Pool::initialize() @ 0x1a8bd639 in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse
8. /home/avtokmakov/ch/ClickHouse/build_debug/../base/mysqlxx/Pool.cpp:126: mysqlxx::Pool::get() @ 0x1a8bd305 in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse
9. /home/avtokmakov/ch/ClickHouse/build_debug/../src/Databases/MySQL/MaterializeMySQLSyncThread.cpp:213: DB::MaterializeMySQLSyncThread::startSynchronization() @ 0x16aac131 in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse
10. /home/avtokmakov/ch/ClickHouse/build_debug/../src/Databases/MySQL/DatabaseMaterializeMySQL.cpp:73: DB::DatabaseMaterializeMySQL::loadStoredObjects(DB::Context&, bool, bool) @ 0x16a9e898 in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse
11. /home/avtokmakov/ch/ClickHouse/build_debug/../src/Interpreters/InterpreterCreateQuery.cpp:212: DB::InterpreterCreateQuery::createDatabase(DB::ASTCreateQuery&) @ 0x15d5ec89 in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse
12. /home/avtokmakov/ch/ClickHouse/build_debug/../src/Interpreters/InterpreterCreateQuery.cpp:857: DB::InterpreterCreateQuery::execute() @ 0x15d650d6 in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse
13. /home/avtokmakov/ch/ClickHouse/build_debug/../src/Interpreters/loadMetadata.cpp:43: DB::executeCreateQuery(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, DB::Context&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, bool) @ 0x15f79ccd in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse
14. /home/avtokmakov/ch/ClickHouse/build_debug/../src/Interpreters/loadMetadata.cpp:74: DB::loadDatabase(DB::Context&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, bool) @ 0x15f796f8 in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse
15. /home/avtokmakov/ch/ClickHouse/build_debug/../src/Interpreters/loadMetadata.cpp:131: DB::loadMetadata(DB::Context&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&) @ 0x15f79294 in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse
16. /home/avtokmakov/ch/ClickHouse/build_debug/../programs/server/Server.cpp:691: DB::Server::main(std::__1::vector<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> >, std::__1::allocator<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > > > const&) @ 0xea4769f in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse
17. /home/avtokmakov/ch/ClickHouse/build_debug/../contrib/poco/Util/src/Application.cpp:334: Poco::Util::Application::run() @ 0x1a98373f in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse
18. /home/avtokmakov/ch/ClickHouse/build_debug/../programs/server/Server.cpp:188: DB::Server::run() @ 0xea3c859 in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse
19. /home/avtokmakov/ch/ClickHouse/build_debug/../contrib/poco/Util/src/ServerApplication.cpp:611: Poco::Util::ServerApplication::run(int, char**) @ 0x1a99d0bf in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse
20. /home/avtokmakov/ch/ClickHouse/build_debug/../programs/server/Server.cpp:1186: mainEntryClickHouseServer(int, char**) @ 0xea5233b in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse
21. /home/avtokmakov/ch/ClickHouse/build_debug/../programs/main.cpp:324: main @ 0xe99b7d5 in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse
22. /build/glibc-2ORdQG/glibc-2.27/csu/../csu/libc-start.c:344: __libc_start_main @ 0x21b97 in /usr/lib/debug/lib/x86_64-linux-gnu/libc-2.27.so
23. _start @ 0xe99b47a in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse
 (version 20.7.1.1)
2020.08.07 10:47:36.991449 [ 1440 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 16 threads
2020.08.07 10:47:36.992738 [ 1440 ] {} <Information> Application: It looks like the process has no CAP_SYS_NICE capability, the setting 'os_thread_priority' will have no effect. It could happen due to incorrect ClickHouse package installation. You could resolve the problem manually with 'sudo setcap cap_sys_nice=+ep /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse'. Note that it will not work on 'nosuid' mounted filesystems.
2020.08.07 10:47:36.994135 [ 1440 ] {} <Information> Application: Listening for http://[::]:8123
2020.08.07 10:47:36.996663 [ 1440 ] {} <Information> Application: Listening for https://[::]:8443
2020.08.07 10:47:36.996911 [ 1440 ] {} <Information> Application: Listening for connections with native protocol (tcp): [::]:9000
2020.08.07 10:47:36.997126 [ 1440 ] {} <Information> Application: Listening for connections with secure native protocol (tcp_secure): [::]:9440
2020.08.07 10:47:36.997424 [ 1440 ] {} <Information> Application: Listening for replica communication (interserver): http://[::]:9009
2020.08.07 10:47:36.997911 [ 1440 ] {} <Information> Application: Available RAM: 44.20 GiB; physical cores: 56; logical cores: 56.
2020.08.07 10:47:36.997990 [ 1440 ] {} <Information> Application: Ready for connections.
2020.08.07 10:49:53.222138 [ 1563 ] {891d68d0-e8e0-4d1c-8c2e-6da856406d75} <Information> executeQuery: Read 6 rows, 78.00 B in 0.025072777 sec., 239 rows/sec., 3.04 KiB/sec.
2020.08.07 10:49:53.226457 [ 1563 ] {} <Information> TCPHandler: Processed in 0.030704416 sec.
2020.08.07 10:50:06.521665 [ 1563 ] {e4fc0c08-14ec-4131-8de2-c7b8bd455d8a} <Information> executeQuery: Read 4 rows, 654.00 B in 0.004734438 sec., 844 rows/sec., 134.90 KiB/sec.
2020.08.07 10:50:06.522339 [ 1563 ] {} <Information> TCPHandler: Processed in 0.006557201 sec.
^C2020.08.07 10:50:14.486737 [ 1443 ] {} <Information> Application: Received termination signal (Interrupt)
2020.08.07 10:50:15.211494 [ 1440 ] {} <Information> Application: Closed all listening sockets. Waiting for 1 outstanding connections.
2020.08.07 10:50:16.532603 [ 1563 ] {} <Information> TCPHandler: Done processing connection.
2020.08.07 10:50:16.613152 [ 1440 ] {} <Information> Application: Closed connections.
2020.08.07 10:50:16.617621 [ 1440 ] {} <Information> Application: Shutting down storages.
2020.08.07 10:50:22.021350 [ 2043 ] {} <Fatal> BaseDaemon: ########################################
2020.08.07 10:50:22.021593 [ 2043 ] {} <Fatal> BaseDaemon: (version 20.7.1.1, build id: 6B6B94644A3E2A235068C211D37F04E26023F84D) (from thread 1440) (no query) Received signal Segmentation fault (11)
2020.08.07 10:50:22.021791 [ 2043 ] {} <Fatal> BaseDaemon: Address: NULL pointer. Access: read. Address not mapped to object.
2020.08.07 10:50:22.021947 [ 2043 ] {} <Fatal> BaseDaemon: Stack trace: 0xe9d518c 0xe9d5165 0xe9d5139 0xe9d35a9 0xe9d399c 0x16aa9686 0x16a9e9a9 0x15a08d5c 0x15a0bf9d 0x159a7f9b 0x159a0a78 0xea5a149 0xea59d3d 0xea522e5 0xea4b778 0x1a98373f 0xea3c859 0x1a99d0bf 0xea5233b 0xe99b7d5 0x7f5971231b97 0xe99b47a
2020.08.07 10:50:22.022453 [ 2043 ] {} <Fatal> BaseDaemon: 4. /home/avtokmakov/ch/ClickHouse/build_debug/../contrib/libcxx/include/memory:3821: std::__1::shared_ptr<Poco::Event>::get() const @ 0xe9d518c in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse
2020.08.07 10:50:22.022737 [ 2043 ] {} <Fatal> BaseDaemon: 5. /home/avtokmakov/ch/ClickHouse/build_debug/../contrib/libcxx/include/memory:3832: std::__1::shared_ptr<Poco::Event>::operator bool() const @ 0xe9d5165 in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse
2020.08.07 10:50:22.022978 [ 2043 ] {} <Fatal> BaseDaemon: 6. /home/avtokmakov/ch/ClickHouse/build_debug/../contrib/libcxx/include/memory:4493: bool std::__1::operator!=<Poco::Event>(std::__1::shared_ptr<Poco::Event> const&, std::nullptr_t) @ 0xe9d5139 in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse
2020.08.07 10:50:22.023209 [ 2043 ] {} <Fatal> BaseDaemon: 7. /home/avtokmakov/ch/ClickHouse/build_debug/../src/Common/ThreadPool.h:219: ThreadFromGlobalPool::joinable() const @ 0xe9d35a9 in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse
2020.08.07 10:50:22.023413 [ 2043 ] {} <Fatal> BaseDaemon: 8. /home/avtokmakov/ch/ClickHouse/build_debug/../src/Common/ThreadPool.h:203: ThreadFromGlobalPool::join() @ 0xe9d399c in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse
2020.08.07 10:50:22.054583 [ 2043 ] {} <Fatal> BaseDaemon: 9. /home/avtokmakov/ch/ClickHouse/build_debug/../src/Databases/MySQL/MaterializeMySQLSyncThread.cpp:209: DB::MaterializeMySQLSyncThread::stopSynchronization() @ 0x16aa9686 in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse
2020.08.07 10:50:22.085532 [ 2043 ] {} <Fatal> BaseDaemon: 10. /home/avtokmakov/ch/ClickHouse/build_debug/../src/Databases/MySQL/DatabaseMaterializeMySQL.cpp:86: DB::DatabaseMaterializeMySQL::shutdown() @ 0x16a9e9a9 in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse
2020.08.07 10:50:22.109522 [ 2043 ] {} <Fatal> BaseDaemon: 11. /home/avtokmakov/ch/ClickHouse/build_debug/../src/Interpreters/DatabaseCatalog.cpp:146: DB::DatabaseCatalog::shutdownImpl() @ 0x15a08d5c in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse
2020.08.07 10:50:22.133460 [ 2043 ] {} <Fatal> BaseDaemon: 12. /home/avtokmakov/ch/ClickHouse/build_debug/../src/Interpreters/DatabaseCatalog.cpp:478: DB::DatabaseCatalog::shutdown() @ 0x15a0bf9d in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse
2020.08.07 10:50:22.157434 [ 2043 ] {} <Fatal> BaseDaemon: 13. /home/avtokmakov/ch/ClickHouse/build_debug/../src/Interpreters/Context.cpp:426: DB::ContextShared::shutdown() @ 0x159a7f9b in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse
2020.08.07 10:50:22.180887 [ 2043 ] {} <Fatal> BaseDaemon: 14. /home/avtokmakov/ch/ClickHouse/build_debug/../src/Interpreters/Context.cpp:1956: DB::Context::shutdown() @ 0x159a0a78 in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse
2020.08.07 10:50:22.181777 [ 2043 ] {} <Fatal> BaseDaemon: 15. /home/avtokmakov/ch/ClickHouse/build_debug/../programs/server/Server.cpp:383: DB::Server::main(std::__1::vector<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> >, std::__1::allocator<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > > > const&)::$_12::operator()() const @ 0xea5a149 in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse
2020.08.07 10:50:22.182778 [ 2043 ] {} <Fatal> BaseDaemon: 16. /home/avtokmakov/ch/ClickHouse/build_debug/../base/common/../ext/scope_guard.h:98: ext::basic_scope_guard<DB::Server::main(std::__1::vector<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> >, std::__1::allocator<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > > > const&)::$_12>::invoke() @ 0xea59d3d in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse
2020.08.07 10:50:22.183515 [ 2043 ] {} <Fatal> BaseDaemon: 17. /home/avtokmakov/ch/ClickHouse/build_debug/../base/common/../ext/scope_guard.h:47: ext::basic_scope_guard<DB::Server::main(std::__1::vector<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> >, std::__1::allocator<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > > > const&)::$_12>::~basic_scope_guard() @ 0xea522e5 in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse
2020.08.07 10:50:22.184143 [ 2043 ] {} <Fatal> BaseDaemon: 18. /home/avtokmakov/ch/ClickHouse/build_debug/../programs/server/Server.cpp:1175: DB::Server::main(std::__1::vector<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> >, std::__1::allocator<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > > > const&) @ 0xea4b778 in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse
2020.08.07 10:50:22.220039 [ 2043 ] {} <Fatal> BaseDaemon: 19. /home/avtokmakov/ch/ClickHouse/build_debug/../contrib/poco/Util/src/Application.cpp:334: Poco::Util::Application::run() @ 0x1a98373f in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse
2020.08.07 10:50:22.220520 [ 2043 ] {} <Fatal> BaseDaemon: 20. /home/avtokmakov/ch/ClickHouse/build_debug/../programs/server/Server.cpp:188: DB::Server::run() @ 0xea3c859 in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse
2020.08.07 10:50:22.256422 [ 2043 ] {} <Fatal> BaseDaemon: 21. /home/avtokmakov/ch/ClickHouse/build_debug/../contrib/poco/Util/src/ServerApplication.cpp:611: Poco::Util::ServerApplication::run(int, char**) @ 0x1a99d0bf in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse
2020.08.07 10:50:22.257184 [ 2043 ] {} <Fatal> BaseDaemon: 22. /home/avtokmakov/ch/ClickHouse/build_debug/../programs/server/Server.cpp:1186: mainEntryClickHouseServer(int, char**) @ 0xea5233b in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse
2020.08.07 10:50:22.257323 [ 2043 ] {} <Fatal> BaseDaemon: 23. /home/avtokmakov/ch/ClickHouse/build_debug/../programs/main.cpp:324: main @ 0xe99b7d5 in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse
2020.08.07 10:50:22.257474 [ 2043 ] {} <Fatal> BaseDaemon: 24. /build/glibc-2ORdQG/glibc-2.27/csu/../csu/libc-start.c:344: __libc_start_main @ 0x21b97 in /usr/lib/debug/lib/x86_64-linux-gnu/libc-2.27.so
2020.08.07 10:50:22.295207 [ 2043 ] {} <Fatal> BaseDaemon: 25. _start @ 0xe99b47a in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse
2020.08.07 10:50:22.295346 [ 2043 ] {} <Information> SentryWriter: Not sending crash report
Segmentation fault