[2020-12-23 19:17:32,948] - [INFO] - write pid 5464 ...
[2020-12-23 19:17:32,954] - [INFO] - server start, listening on port 8008
[2020-12-23 19:17:37,549] - [ERROR] - Uncaught exception POST /data/pitcher_panel/channel (::1)
HTTPServerRequest(protocol='http', host='localhost:8008', method='POST', uri='/data/pitcher_panel/channel', version='HTTP/1.1', remote_ip='::1')
Traceback (most recent call last):
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\tornado\web.py", line 1702, in _execute
    result = method(*self.path_args, **self.path_kwargs)
  File "D:\code\QcWebServer\handlers\PitcherPanel.py", line 24, in post
    data=get_pitcher_panel_channel(pitcher, channel, start, end, page, page_size, order_by, order)
  File "D:\code\QcWebServer\data_manage\pitcher_panel.py", line 31, in get_pitcher_panel_channel
    data=ck.execute(sql)
  File "D:\code\QcWebServer\model\DataBaseUtils.py", line 61, in execute
    return self.client.execute(sql)
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\clickhouse_driver\client.py", line 252, in execute
    columnar=columnar
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\clickhouse_driver\client.py", line 447, in process_ordinary_query
    columnar=columnar)
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\clickhouse_driver\client.py", line 113, in receive_result
    return result.get_result()
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\clickhouse_driver\result.py", line 50, in get_result
    for packet in self.packet_generator:
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\clickhouse_driver\client.py", line 129, in packet_generator
    packet = self.receive_packet()
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\clickhouse_driver\client.py", line 146, in receive_packet
    raise packet.exception
clickhouse_driver.errors.ServerException: Code: 62.
DB::Exception: Syntax error: failed at position 605 (line 11, col 44): dt>='2020-12-22' and dt<='2020-12-22'   and pitcher="陈冲"  order by desc dt limit 1,10 . Expected one of: AND, OR, alias, UNION ALL, token, AS, WITH, HAVING, LIMIT, SETTINGS, FORMAT, NOT, BETWEEN, LIKE, IS, NOT LIKE, IN, NOT IN, GLOBAL IN, GLOBAL NOT IN, Comma, Dot, Arrow, QuestionMark, ORDER BY, INTO OUTFILE, GROUP BY. Stack trace:

0. /server/clickhouse_build/../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) @ 0xc0390cc in /clickhouse/bin/clickhouse
1. /server/clickhouse_build/../src/Common/Exception.cpp:29: DB::Exception::Exception(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, int) @ 0x5066519 in /clickhouse/bin/clickhouse
2. /server/clickhouse_build/../src/Parsers/parseQuery.cpp:310: DB::parseQuery(DB::IParser&, char const*, char const*, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, unsigned long, unsigned long) (.cold) @ 0x4db0714 in /clickhouse/bin/clickhouse
3. /server/clickhouse_build/../src/Interpreters/executeQuery.cpp:287: DB::executeQueryImpl(char const*, char const*, DB::Context&, bool, DB::QueryProcessingStage::Enum, bool, DB::ReadBuffer*, bool) @ 0x8f06380 in /clickhouse/bin/clickhouse
4. /server/clickhouse_build/../src/Interpreters/executeQuery.cpp:718: DB::executeQuery(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, DB::Context&, bool, DB::QueryProcessingStage::Enum, bool, bool) @ 0x8f0a0dd in /clickhouse/bin/clickhouse
5. /server/clickhouse_build/../programs/server/TCPHandler.cpp:257: DB::TCPHandler::runImpl() @ 0x50c1029 in /clickhouse/bin/clickhouse
6. /server/clickhouse_build/../programs/server/TCPHandler.cpp:1252: DB::TCPHandler::run() @ 0x50c1f2c in /clickhouse/bin/clickhouse
7. /server/clickhouse_build/../contrib/poco/Net/src/TCPServerConnection.cpp:57: Poco::Net::TCPServerConnection::start() @ 0x9e54827 in /clickhouse/bin/clickhouse
8. /server/clickhouse_build/../contrib/libcxx/include/atomic:856: Poco::Net::TCPServerDispatcher::run() @ 0x9e54c1d in /clickhouse/bin/clickhouse
9. /server/clickhouse_build/../contrib/poco/Foundation/include/Poco/Mutex_STD.h:132: Poco::PooledThread::run() @ 0xc0ab67f in /clickhouse/bin/clickhouse
10. /server/clickhouse_build/../contrib/poco/Foundation/include/Poco/AutoPtr.h:205: Poco::ThreadImpl::runnableEntry(void*) @ 0xc0a8748 in /clickhouse/bin/clickhouse
11. /server/clickhouse_build/../contrib/libcxx/include/memory:2615: void* std::__1::__thread_proxy<std::__1::tuple<std::__1::unique_ptr<std::__1::__thread_struct, std::__1::default_delete<std::__1::__thread_struct> >, void* (*)(void*), Poco::ThreadImpl*> >(void*) @ 0xc0a9fe9 in /clickhouse/bin/clickhouse
12. start_thread @ 0x76db in /lib/x86_64-linux-gnu/libpthread-2.27.so
13. clone @ 0x121a3f in /lib/x86_64-linux-gnu/libc-2.27.so

[2020-12-23 19:17:37,573] - [ERROR] - 500 POST /data/pitcher_panel/channel (::1) 275.75ms
[2020-12-23 19:18:12,975] - [INFO] - D:\code\QcWebServer\data_manage\pitcher_panel.py modified; restarting server
[2020-12-23 19:18:13,939] - [INFO] - write pid 1536 ...
[2020-12-23 19:18:13,947] - [INFO] - server start, listening on port 8008
[2020-12-23 19:18:14,008] - [ERROR] - Uncaught exception POST /data/pitcher_panel/channel (127.0.0.1)
HTTPServerRequest(protocol='http', host='localhost:8008', method='POST', uri='/data/pitcher_panel/channel', version='HTTP/1.1', remote_ip='127.0.0.1')
Traceback (most recent call last):
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\tornado\web.py", line 1702, in _execute
    result = method(*self.path_args, **self.path_kwargs)
  File "D:\code\QcWebServer\handlers\PitcherPanel.py", line 24, in post
    data=get_pitcher_panel_channel(pitcher, channel, start, end, page, page_size, order_by, order)
  File "D:\code\QcWebServer\data_manage\pitcher_panel.py", line 30, in get_pitcher_panel_channel
    print(sql)
OSError: [Errno 22] Invalid argument
[2020-12-23 19:18:14,010] - [ERROR] - 500 POST /data/pitcher_panel/channel (127.0.0.1) 2.03ms
[2020-12-23 19:18:23,514] - [ERROR] - Uncaught exception POST /data/pitcher_panel/channel (127.0.0.1)
HTTPServerRequest(protocol='http', host='localhost:8008', method='POST', uri='/data/pitcher_panel/channel', version='HTTP/1.1', remote_ip='127.0.0.1')
Traceback (most recent call last):
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\tornado\web.py", line 1702, in _execute
    result = method(*self.path_args, **self.path_kwargs)
  File "D:\code\QcWebServer\handlers\PitcherPanel.py", line 24, in post
    data=get_pitcher_panel_channel(pitcher, channel, start, end, page, page_size, order_by, order)
  File "D:\code\QcWebServer\data_manage\pitcher_panel.py", line 30, in get_pitcher_panel_channel
    print(sql)
OSError: [Errno 22] Invalid argument
[2020-12-23 19:18:23,515] - [ERROR] - 500 POST /data/pitcher_panel/channel (127.0.0.1) 1.00ms
[2020-12-23 19:18:29,172] - [INFO] - write pid 4820 ...
[2020-12-23 19:18:33,210] - [INFO] - write pid 4548 ...
[2020-12-23 19:24:03,509] - [INFO] - write pid 20328 ...
[2020-12-23 19:24:03,516] - [INFO] - server start, listening on port 8008
[2020-12-23 19:24:08,478] - [ERROR] - Uncaught exception POST /data/pitcher_panel/channel (::1)
HTTPServerRequest(protocol='http', host='localhost:8008', method='POST', uri='/data/pitcher_panel/channel', version='HTTP/1.1', remote_ip='::1')
Traceback (most recent call last):
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\tornado\web.py", line 1702, in _execute
    result = method(*self.path_args, **self.path_kwargs)
  File "D:\code\QcWebServer\handlers\PitcherPanel.py", line 24, in post
    data=get_pitcher_panel_channel(pitcher, channel, start, end, page, page_size, order_by, order)
  File "D:\code\QcWebServer\data_manage\pitcher_panel.py", line 31, in get_pitcher_panel_channel
    data=ck.execute(sql)
  File "D:\code\QcWebServer\model\DataBaseUtils.py", line 61, in execute
    return self.client.execute(sql)
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\clickhouse_driver\client.py", line 252, in execute
    columnar=columnar
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\clickhouse_driver\client.py", line 447, in process_ordinary_query
    columnar=columnar)
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\clickhouse_driver\client.py", line 113, in receive_result
    return result.get_result()
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\clickhouse_driver\result.py", line 50, in get_result
    for packet in self.packet_generator:
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\clickhouse_driver\client.py", line 129, in packet_generator
    packet = self.receive_packet()
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\clickhouse_driver\client.py", line 146, in receive_packet
    raise packet.exception
clickhouse_driver.errors.ServerException: Code: 62.
DB::Exception: Syntax error: failed at position 677 (line 11, col 116): dt limit 1,10 . Expected one of: AND, OR, alias, UNION ALL, token, AS, LIMIT, SETTINGS, FORMAT, NOT, BETWEEN, LIKE, IS, NOT LIKE, IN, NOT IN, GLOBAL IN, GLOBAL NOT IN, Comma, Dot, Arrow, QuestionMark, INTO OUTFILE. Stack trace:

0. /server/clickhouse_build/../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) @ 0xc0390cc in /clickhouse/bin/clickhouse
1. /server/clickhouse_build/../src/Common/Exception.cpp:29: DB::Exception::Exception(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, int) @ 0x5066519 in /clickhouse/bin/clickhouse
2. /server/clickhouse_build/../src/Parsers/parseQuery.cpp:310: DB::parseQuery(DB::IParser&, char const*, char const*, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, unsigned long, unsigned long) (.cold) @ 0x4db0714 in /clickhouse/bin/clickhouse
3. /server/clickhouse_build/../src/Interpreters/executeQuery.cpp:287: DB::executeQueryImpl(char const*, char const*, DB::Context&, bool, DB::QueryProcessingStage::Enum, bool, DB::ReadBuffer*, bool) @ 0x8f06380 in /clickhouse/bin/clickhouse
4. /server/clickhouse_build/../src/Interpreters/executeQuery.cpp:718: DB::executeQuery(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, DB::Context&, bool, DB::QueryProcessingStage::Enum, bool, bool) @ 0x8f0a0dd in /clickhouse/bin/clickhouse
5. /server/clickhouse_build/../programs/server/TCPHandler.cpp:257: DB::TCPHandler::runImpl() @ 0x50c1029 in /clickhouse/bin/clickhouse
6. /server/clickhouse_build/../programs/server/TCPHandler.cpp:1252: DB::TCPHandler::run() @ 0x50c1f2c in /clickhouse/bin/clickhouse
7. /server/clickhouse_build/../contrib/poco/Net/src/TCPServerConnection.cpp:57: Poco::Net::TCPServerConnection::start() @ 0x9e54827 in /clickhouse/bin/clickhouse
8. /server/clickhouse_build/../contrib/libcxx/include/atomic:856: Poco::Net::TCPServerDispatcher::run() @ 0x9e54c1d in /clickhouse/bin/clickhouse
9. /server/clickhouse_build/../contrib/poco/Foundation/include/Poco/Mutex_STD.h:132: Poco::PooledThread::run() @ 0xc0ab67f in /clickhouse/bin/clickhouse
10. /server/clickhouse_build/../contrib/poco/Foundation/include/Poco/AutoPtr.h:205: Poco::ThreadImpl::runnableEntry(void*) @ 0xc0a8748 in /clickhouse/bin/clickhouse
11. /server/clickhouse_build/../contrib/libcxx/include/memory:2615: void* std::__1::__thread_proxy<std::__1::tuple<std::__1::unique_ptr<std::__1::__thread_struct, std::__1::default_delete<std::__1::__thread_struct> >, void* (*)(void*), Poco::ThreadImpl*> >(void*) @ 0xc0a9fe9 in /clickhouse/bin/clickhouse
12. start_thread @ 0x76db in /lib/x86_64-linux-gnu/libpthread-2.27.so
13. clone @ 0x121a3f in /lib/x86_64-linux-gnu/libc-2.27.so

[2020-12-23 19:24:08,495] - [ERROR] - 500 POST /data/pitcher_panel/channel (::1) 404.54ms
[2020-12-23 19:25:27,019] - [INFO] - D:\code\QcWebServer\handlers\PitcherPanel.py modified; restarting server
[2020-12-23 19:25:27,980] - [INFO] - write pid 2636 ...
[2020-12-23 19:25:27,986] - [INFO] - server start, listening on port 8008
[2020-12-23 19:25:28,542] - [ERROR] - Uncaught exception POST /data/pitcher_panel/channel (::1)
HTTPServerRequest(protocol='http', host='localhost:8008', method='POST', uri='/data/pitcher_panel/channel', version='HTTP/1.1', remote_ip='::1')
Traceback (most recent call last):
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\tornado\web.py", line 1702, in _execute
    result = method(*self.path_args, **self.path_kwargs)
  File "D:\code\QcWebServer\handlers\PitcherPanel.py", line 24, in post
    data=get_pitcher_panel_channel(pitcher, channel, start, end, page, page_size, order_by, order)
  File "D:\code\QcWebServer\data_manage\pitcher_panel.py", line 30, in get_pitcher_panel_channel
    print(sql)
OSError: [Errno 22] Invalid argument
[2020-12-23 19:25:28,544] - [ERROR] - 500 POST /data/pitcher_panel/channel (::1) 2.99ms
[2020-12-23 19:25:33,457] - [INFO] - write pid 10868 ...
[2020-12-23 19:26:00,647] - [INFO] - write pid 7276 ...
[2020-12-23 19:26:00,653] - [INFO] - server start, listening on port 8008
[2020-12-23 19:26:03,805] - [ERROR] - Uncaught exception POST /data/pitcher_panel/channel (::1)
HTTPServerRequest(protocol='http', host='localhost:8008', method='POST', uri='/data/pitcher_panel/channel', version='HTTP/1.1', remote_ip='::1')
Traceback (most recent call last):
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\tornado\web.py", line 1702, in _execute
    result = method(*self.path_args, **self.path_kwargs)
  File "D:\code\QcWebServer\handlers\PitcherPanel.py", line 24, in post
    data=get_pitcher_panel_channel(pitcher, channel, start, end, page, page_size, order_by, order)
  File "D:\code\QcWebServer\data_manage\pitcher_panel.py", line 31, in get_pitcher_panel_channel
    data=ck.execute(sql)
  File "D:\code\QcWebServer\model\DataBaseUtils.py", line 61, in execute
    return self.client.execute(sql)
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\clickhouse_driver\client.py", line 252, in execute
    columnar=columnar
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\clickhouse_driver\client.py", line 447, in process_ordinary_query
    columnar=columnar)
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\clickhouse_driver\client.py", line 113, in receive_result
    return result.get_result()
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\clickhouse_driver\result.py", line 50, in get_result
    for packet in self.packet_generator:
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\clickhouse_driver\client.py", line 129, in packet_generator
    packet = self.receive_packet()
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\clickhouse_driver\client.py", line 146, in receive_packet
    raise packet.exception
clickhouse_driver.errors.ServerException: Code: 47.
DB::Exception: Missing columns: '陈冲' while processing query: 'SELECT channel, stage, platform, book, dt, cost, first_order_amount, if(cost = 0, 0, round(first_order_amount / cost, 4)) AS first_roi, first_order_user, first_order_count, if(first_order_user = 0, 0, round(cost / first_order_user, 2)) AS first_per_cost, view_count, click_count, follow_user, if(click_count = 0, 0, round(follow_user / click_count, 4)) AS follow_rate, if(follow_user = 0, 0, round(cost / follow_user, 2)) AS follow_per_cost, total_cost, if(total_cost = 0, 0, round(total_amount / total_cost, 4)) AS back_rate FROM dw_daily_channel WHERE (dt >= '2020-12-22') AND (dt <= '2020-12-22') AND (pitcher = `陈冲`) ORDER BY dt DESC LIMIT 1, 10', required columns: 'first_order_amount' 'dt' 'platform' 'stage' 'pitcher' 'cost' 'channel' 'follow_user' 'first_order_user' 'first_order_count' 'book' 'click_count' 'view_count' 'total_amount' 'total_cost' '陈冲', source columns: 'total_amount' 'web_view_count' 'dt' 'reg_order_user' 'total_cost' 'click_count' 'view_count' 'reg_order_count' 'first_order_amount' 'reg_order_amount' 'stage' 'order_amount' 'order_user' 'order_count' 'book' 'web_order_count' 'follow_user' 'channel' 'platform' 'first_order_count' 'first_order_user' 'cost' 'pitcher' 'platform_view_count' 'reg_order_amount30'. Stack trace:

0. /server/clickhouse_build/../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) @ 0xc0390cc in /clickhouse/bin/clickhouse
1. /server/clickhouse_build/../src/Common/Exception.cpp:29: DB::Exception::Exception(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, int) @ 0x5066519 in /clickhouse/bin/clickhouse
2. /server/clickhouse_build/../contrib/libcxx/include/string:2134: DB::SyntaxAnalyzerResult::collectUsedColumns(std::__1::shared_ptr<DB::IAST> const&) (.cold) @ 0x4c72e66 in /clickhouse/bin/clickhouse
3. /server/clickhouse_build/../contrib/libcxx/include/new:251: DB::SyntaxAnalyzer::analyzeSelect(std::__1::shared_ptr<DB::IAST>&, DB::SyntaxAnalyzerResult&&, DB::SelectQueryOptions const&, std::__1::vector<DB::TableWithColumnNamesAndTypes, std::__1::allocator<DB::TableWithColumnNamesAndTypes> > const&, 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&) const @ 0x8ecb84f in /clickhouse/bin/clickhouse
4. /server/clickhouse_build/../src/Interpreters/InterpreterSelectQuery.cpp:300: DB::InterpreterSelectQuery::InterpreterSelectQuery(std::__1::shared_ptr<DB::IAST> const&, DB::Context const&, std::__1::shared_ptr<DB::IBlockInputStream> const&, std::__1::optional<DB::Pipe>, std::__1::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, 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&)::'lambda'(bool)::operator()(bool) const @ 0x8d3bf75 in /clickhouse/bin/clickhouse
5. /server/clickhouse_build/../src/Interpreters/InterpreterSelectQuery.cpp:374: DB::InterpreterSelectQuery::InterpreterSelectQuery(std::__1::shared_ptr<DB::IAST> const&, DB::Context const&, std::__1::shared_ptr<DB::IBlockInputStream> const&, std::__1::optional<DB::Pipe>, std::__1::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, 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&) @ 0x8d3d282 in /clickhouse/bin/clickhouse
6. /server/clickhouse_build/../src/Interpreters/InterpreterSelectQuery.cpp:167: DB::InterpreterSelectQuery::InterpreterSelectQuery(std::__1::shared_ptr<DB::IAST> const&, DB::Context const&, DB::SelectQueryOptions const&, 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&) @ 0x8d3e7e5 in /clickhouse/bin/clickhouse
7. /server/clickhouse_build/../contrib/libcxx/include/vector:1681: DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::__1::shared_ptr<DB::IAST> const&, DB::Context const&, DB::SelectQueryOptions const&, 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&) @ 0x8d78c96 in /clickhouse/bin/clickhouse
8. /server/clickhouse_build/../contrib/libcxx/include/vector:461: DB::InterpreterFactory::get(std::__1::shared_ptr<DB::IAST>&, DB::Context&, DB::QueryProcessingStage::Enum) @ 0x8d1b7f4 in /clickhouse/bin/clickhouse
9. /server/clickhouse_build/../src/Interpreters/executeQuery.cpp:406: DB::executeQueryImpl(char const*, char const*, DB::Context&, bool, DB::QueryProcessingStage::Enum, bool, DB::ReadBuffer*, bool) @ 0x8f06b06 in /clickhouse/bin/clickhouse
10. /server/clickhouse_build/../src/Interpreters/executeQuery.cpp:718: DB::executeQuery(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, DB::Context&, bool, DB::QueryProcessingStage::Enum, bool, bool) @ 0x8f0a0dd in /clickhouse/bin/clickhouse
11. /server/clickhouse_build/../programs/server/TCPHandler.cpp:257: DB::TCPHandler::runImpl() @ 0x50c1029 in /clickhouse/bin/clickhouse
12. /server/clickhouse_build/../programs/server/TCPHandler.cpp:1252: DB::TCPHandler::run() @ 0x50c1f2c in /clickhouse/bin/clickhouse
13. /server/clickhouse_build/../contrib/poco/Net/src/TCPServerConnection.cpp:57: Poco::Net::TCPServerConnection::start() @ 0x9e54827 in /clickhouse/bin/clickhouse
14. /server/clickhouse_build/../contrib/libcxx/include/atomic:856: Poco::Net::TCPServerDispatcher::run() @ 0x9e54c1d in /clickhouse/bin/clickhouse
15. /server/clickhouse_build/../contrib/poco/Foundation/include/Poco/Mutex_STD.h:132: Poco::PooledThread::run() @ 0xc0ab67f in /clickhouse/bin/clickhouse
16. /server/clickhouse_build/../contrib/poco/Foundation/include/Poco/AutoPtr.h:205: Poco::ThreadImpl::runnableEntry(void*) @ 0xc0a8748 in /clickhouse/bin/clickhouse
17. /server/clickhouse_build/../contrib/libcxx/include/memory:2615: void* std::__1::__thread_proxy<std::__1::tuple<std::__1::unique_ptr<std::__1::__thread_struct, std::__1::default_delete<std::__1::__thread_struct> >, void* (*)(void*), Poco::ThreadImpl*> >(void*) @ 0xc0a9fe9 in /clickhouse/bin/clickhouse
18. start_thread @ 0x76db in /lib/x86_64-linux-gnu/libpthread-2.27.so
19. clone @ 0x121a3f in /lib/x86_64-linux-gnu/libc-2.27.so

[2020-12-23 19:26:03,811] - [ERROR] - 500 POST /data/pitcher_panel/channel (::1) 263.66ms
[2020-12-23 19:26:42,204] - [INFO] - write pid 16860 ...
[2020-12-23 19:26:42,210] - [INFO] - server start, listening on port 8008
[2020-12-23 19:26:44,621] - [ERROR] - Uncaught exception POST /data/pitcher_panel/channel (::1)
HTTPServerRequest(protocol='http', host='localhost:8008', method='POST', uri='/data/pitcher_panel/channel', version='HTTP/1.1', remote_ip='::1')
Traceback (most recent call last):
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\tornado\web.py", line 1702, in _execute
    result = method(*self.path_args, **self.path_kwargs)
  File "D:\code\QcWebServer\handlers\PitcherPanel.py", line 24, in post
    data=get_pitcher_panel_channel(pitcher, channel, start, end, page, page_size, order_by, order)
  File "D:\code\QcWebServer\data_manage\pitcher_panel.py", line 31, in get_pitcher_panel_channel
    data=ck.execute(sql)
  File "D:\code\QcWebServer\model\DataBaseUtils.py", line 61, in execute
    return self.client.execute(sql)
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\clickhouse_driver\client.py", line 252, in execute
    columnar=columnar
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\clickhouse_driver\client.py", line 447, in process_ordinary_query
    columnar=columnar)
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\clickhouse_driver\client.py", line 113, in receive_result
    return result.get_result()
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\clickhouse_driver\result.py", line 50, in get_result
    for packet in self.packet_generator:
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\clickhouse_driver\client.py", line 129, in packet_generator
    packet = self.receive_packet()
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\clickhouse_driver\client.py", line 146, in receive_packet
    raise packet.exception
clickhouse_driver.errors.ServerException: Code: 47.
DB::Exception: Missing columns: '2020-12-22' '陈冲' while processing query: 'SELECT channel, stage, platform, book, dt, cost, first_order_amount, if(cost = 0, 0, round(first_order_amount / cost, 4)) AS first_roi, first_order_user, first_order_count, if(first_order_user = 0, 0, round(cost / first_order_user, 2)) AS first_per_cost, view_count, click_count, follow_user, if(click_count = 0, 0, round(follow_user / click_count, 4)) AS follow_rate, if(follow_user = 0, 0, round(cost / follow_user, 2)) AS follow_per_cost, total_cost, if(total_cost = 0, 0, round(total_amount / total_cost, 4)) AS back_rate FROM dw_daily_channel WHERE (dt >= `2020-12-22`) AND (dt <= `2020-12-22`) AND (pitcher = `陈冲`) ORDER BY dt DESC LIMIT 1, 10', required columns: 'first_order_amount' 'dt' 'platform' 'stage' 'channel' 'follow_user' 'cost' 'pitcher' 'first_order_user' 'first_order_count' 'book' 'click_count' 'view_count' 'total_cost' '陈冲' '2020-12-22' 'total_amount', source columns: 'total_amount' 'web_view_count' 'dt' 'reg_order_user' 'total_cost' 'click_count' 'view_count' 'reg_order_count' 'first_order_amount' 'reg_order_amount' 'stage' 'order_amount' 'order_user' 'order_count' 'book' 'web_order_count' 'follow_user' 'channel' 'platform' 'first_order_count' 'first_order_user' 'cost' 'pitcher' 'platform_view_count' 'reg_order_amount30'. Stack trace:

0. /server/clickhouse_build/../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) @ 0xc0390cc in /clickhouse/bin/clickhouse
1. /server/clickhouse_build/../src/Common/Exception.cpp:29: DB::Exception::Exception(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, int) @ 0x5066519 in /clickhouse/bin/clickhouse
2. /server/clickhouse_build/../contrib/libcxx/include/string:2134: DB::SyntaxAnalyzerResult::collectUsedColumns(std::__1::shared_ptr<DB::IAST> const&) (.cold) @ 0x4c72e66 in /clickhouse/bin/clickhouse
3. /server/clickhouse_build/../contrib/libcxx/include/new:251: DB::SyntaxAnalyzer::analyzeSelect(std::__1::shared_ptr<DB::IAST>&, DB::SyntaxAnalyzerResult&&, DB::SelectQueryOptions const&, std::__1::vector<DB::TableWithColumnNamesAndTypes, std::__1::allocator<DB::TableWithColumnNamesAndTypes> > const&, 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&) const @ 0x8ecb84f in /clickhouse/bin/clickhouse
4. /server/clickhouse_build/../src/Interpreters/InterpreterSelectQuery.cpp:300: DB::InterpreterSelectQuery::InterpreterSelectQuery(std::__1::shared_ptr<DB::IAST> const&, DB::Context const&, std::__1::shared_ptr<DB::IBlockInputStream> const&, std::__1::optional<DB::Pipe>, std::__1::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, 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&)::'lambda'(bool)::operator()(bool) const @ 0x8d3bf75 in /clickhouse/bin/clickhouse
5. /server/clickhouse_build/../src/Interpreters/InterpreterSelectQuery.cpp:374: DB::InterpreterSelectQuery::InterpreterSelectQuery(std::__1::shared_ptr<DB::IAST> const&, DB::Context const&, std::__1::shared_ptr<DB::IBlockInputStream> const&, std::__1::optional<DB::Pipe>, std::__1::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, 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&) @ 0x8d3d282 in /clickhouse/bin/clickhouse
6. /server/clickhouse_build/../src/Interpreters/InterpreterSelectQuery.cpp:167: DB::InterpreterSelectQuery::InterpreterSelectQuery(std::__1::shared_ptr<DB::IAST> const&, DB::Context const&, DB::SelectQueryOptions const&, 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&) @ 0x8d3e7e5 in /clickhouse/bin/clickhouse
7. /server/clickhouse_build/../contrib/libcxx/include/vector:1681: DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::__1::shared_ptr<DB::IAST> const&, DB::Context const&, DB::SelectQueryOptions const&, 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&) @ 0x8d78c96 in /clickhouse/bin/clickhouse
8. /server/clickhouse_build/../contrib/libcxx/include/vector:461: DB::InterpreterFactory::get(std::__1::shared_ptr<DB::IAST>&, DB::Context&, DB::QueryProcessingStage::Enum) @ 0x8d1b7f4 in /clickhouse/bin/clickhouse
9. /server/clickhouse_build/../src/Interpreters/executeQuery.cpp:406: DB::executeQueryImpl(char const*, char const*, DB::Context&, bool, DB::QueryProcessingStage::Enum, bool, DB::ReadBuffer*, bool) @ 0x8f06b06 in /clickhouse/bin/clickhouse
10. /server/clickhouse_build/../src/Interpreters/executeQuery.cpp:718: DB::executeQuery(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, DB::Context&, bool, DB::QueryProcessingStage::Enum, bool, bool) @ 0x8f0a0dd in /clickhouse/bin/clickhouse
11. /server/clickhouse_build/../programs/server/TCPHandler.cpp:257: DB::TCPHandler::runImpl() @ 0x50c1029 in /clickhouse/bin/clickhouse
12. /server/clickhouse_build/../programs/server/TCPHandler.cpp:1252: DB::TCPHandler::run() @ 0x50c1f2c in /clickhouse/bin/clickhouse
13. /server/clickhouse_build/../contrib/poco/Net/src/TCPServerConnection.cpp:57: Poco::Net::TCPServerConnection::start() @ 0x9e54827 in /clickhouse/bin/clickhouse
14. /server/clickhouse_build/../contrib/libcxx/include/atomic:856: Poco::Net::TCPServerDispatcher::run() @ 0x9e54c1d in /clickhouse/bin/clickhouse
15. /server/clickhouse_build/../contrib/poco/Foundation/include/Poco/Mutex_STD.h:132: Poco::PooledThread::run() @ 0xc0ab67f in /clickhouse/bin/clickhouse
16. /server/clickhouse_build/../contrib/poco/Foundation/include/Poco/AutoPtr.h:205: Poco::ThreadImpl::runnableEntry(void*) @ 0xc0a8748 in /clickhouse/bin/clickhouse
17. /server/clickhouse_build/../contrib/libcxx/include/memory:2615: void* std::__1::__thread_proxy<std::__1::tuple<std::__1::unique_ptr<std::__1::__thread_struct, std::__1::default_delete<std::__1::__thread_struct> >, void* (*)(void*), Poco::ThreadImpl*> >(void*) @ 0xc0a9fe9 in /clickhouse/bin/clickhouse
18. start_thread @ 0x76db in /lib/x86_64-linux-gnu/libpthread-2.27.so
19. clone @ 0x121a3f in /lib/x86_64-linux-gnu/libc-2.27.so

[2020-12-23 19:26:44,636] - [ERROR] - 500 POST /data/pitcher_panel/channel (::1) 136.14ms
[2020-12-23 19:30:40,582] - [INFO] - write pid 6184 ...
[2020-12-23 19:30:40,588] - [INFO] - server start, listening on port 8008
[2020-12-23 19:30:42,487] - [INFO] - 200 POST /data/pitcher_panel/channel (::1) 145.34ms
[2020-12-23 19:35:07,606] - [INFO] - D:\code\QcWebServer\data_manage\pitcher_panel.py modified; restarting server
[2020-12-23 19:35:08,564] - [INFO] - write pid 6424 ...
[2020-12-23 19:35:08,570] - [INFO] - server start, listening on port 8008
[2020-12-23 19:36:11,083] - [INFO] - D:\code\QcWebServer\model\DataBaseUtils.py modified; restarting server
[2020-12-23 19:36:11,937] - [INFO] - write pid 8032 ...
[2020-12-23 19:36:11,943] - [INFO] - server start, listening on port 8008
[2020-12-23 19:39:23,455] - [INFO] - D:\code\QcWebServer\data_manage\pitcher_panel.py modified; restarting server
[2020-12-23 19:39:23,963] - [INFO] - write pid 6332 ...
[2020-12-23 19:39:23,971] - [INFO] - server start, listening on port 8008
[2020-12-23 19:39:24,312] - [INFO] - write pid 5112 ...
[2020-12-23 19:39:27,145] - [INFO] - 200 POST /data/pitcher_panel/channel (::1) 215.21ms
[2020-12-23 19:39:55,231] - [INFO] - write pid 12364 ...
[2020-12-23 19:39:55,237] - [INFO] - server start, listening on port 8008
[2020-12-23 19:40:00,990] - [INFO] - 200 POST /data/pitcher_panel/channel (::1) 285.77ms
[2020-12-23 19:40:21,783] - [INFO] - write pid 7944 ...
[2020-12-23 19:40:21,788] - [INFO] - server start, listening on port 8008
[2020-12-23 19:40:23,448] - [INFO] - 200 POST /data/pitcher_panel/channel (::1) 202.31ms
[2020-12-23 19:42:46,796] - [INFO] - D:\code\QcWebServer\model\DataBaseUtils.py modified; restarting server
[2020-12-23 19:42:47,791] - [INFO] - write pid 18920 ...
[2020-12-23 19:42:47,797] - [INFO] - server start, listening on port 8008
[2020-12-23 19:43:21,803] - [INFO] - D:\code\QcWebServer\data_manage\pitcher_panel.py modified; restarting server
[2020-12-23 19:43:22,352] - [INFO] - write pid 6632 ...
[2020-12-23 19:43:22,359] - [INFO] - server start, listening on port 8008
[2020-12-23 19:43:22,689] - [INFO] - write pid 4480 ...
[2020-12-23 19:43:25,966] - [INFO] - 200 POST /data/pitcher_panel/channel (::1) 268.89ms
[2020-12-23 19:44:24,872] - [INFO] - D:\code\QcWebServer\data_manage\pitcher_panel.py modified; restarting server
[2020-12-23 19:44:26,021] - [INFO] - write pid 16204 ...
[2020-12-23 19:44:26,027] - [INFO] - server start, listening on port 8008
[2020-12-23 19:45:54,545] - [INFO] - D:\code\QcWebServer\data_manage\pitcher_panel.py modified; restarting server
[2020-12-23 19:45:55,338] - [INFO] - write pid 12688 ...
[2020-12-23 19:45:55,345] - [INFO] - server start, listening on port 8008
[2020-12-23 19:45:55,558] - [INFO] - write pid 16708 ...
[2020-12-23 19:45:58,489] - [INFO] - 200 POST /data/pitcher_panel/channel (::1) 346.39ms
[2020-12-23 19:49:37,259] - [INFO] - write pid 6328 ...
[2020-12-23 19:49:37,266] - [INFO] - server start, listening on port 8008
[2020-12-23 19:49:42,886] - [ERROR] - Uncaught exception POST /data/pitcher_panel/channel (::1)
HTTPServerRequest(protocol='http', host='localhost:8008', method='POST', uri='/data/pitcher_panel/channel', version='HTTP/1.1', remote_ip='::1')
Traceback (most recent call last):
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\tornado\web.py", line 1702, in _execute
    result = method(*self.path_args, **self.path_kwargs)
  File "D:\code\QcWebServer\handlers\PitcherPanel.py", line 25, in post
    self.write_json(data)
  File "D:\code\QcWebServer\handlers\HandlerBase.py", line 27, in write_json
    self.write(json.dumps({'status': {'msg': msg, "RetCode": status_code}, 'data': data}))
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\simplejson\__init__.py", line 395, in dumps
    return _default_encoder.encode(obj)
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\simplejson\encoder.py", line 296, in encode
    chunks = self.iterencode(o, _one_shot=True)
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\simplejson\encoder.py", line 378, in iterencode
    return _iterencode(o, 0)
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\simplejson\encoder.py", line 273, in default
    o.__class__.__name__)
TypeError: Object of type date is not JSON serializable
[2020-12-23 19:49:42,916] - [ERROR] - 500 POST /data/pitcher_panel/channel (::1) 183.47ms
[2020-12-23 19:49:57,133] - [INFO] - write pid 15184 ...
[2020-12-23 19:49:57,140] - [INFO] - server start, listening on port 8008
[2020-12-23 19:49:58,286] - [ERROR] - Uncaught exception POST /data/pitcher_panel/channel (::1)
HTTPServerRequest(protocol='http', host='localhost:8008', method='POST', uri='/data/pitcher_panel/channel', version='HTTP/1.1', remote_ip='::1')
Traceback (most recent call last):
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\tornado\web.py", line 1702, in _execute
    result = method(*self.path_args, **self.path_kwargs)
  File "D:\code\QcWebServer\handlers\PitcherPanel.py", line 26, in post
    self.write_json(data)
  File "D:\code\QcWebServer\handlers\HandlerBase.py", line 27, in write_json
    self.write(json.dumps({'status': {'msg': msg, "RetCode": status_code}, 'data': data}))
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\simplejson\__init__.py", line 395, in dumps
    return _default_encoder.encode(obj)
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\simplejson\encoder.py", line 296, in encode
    chunks = self.iterencode(o, _one_shot=True)
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\simplejson\encoder.py", line 378, in iterencode
    return _iterencode(o, 0)
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\simplejson\encoder.py", line 273, in default
    o.__class__.__name__)
TypeError: Object of type date is not JSON serializable
[2020-12-23 19:49:58,297] - [ERROR] - 500 POST /data/pitcher_panel/channel (::1) 126.21ms
[2020-12-23 19:51:29,672] - [INFO] - D:\code\QcWebServer\data_manage\pitcher_panel.py modified; restarting server
[2020-12-23 19:51:30,644] - [INFO] - write pid 12132 ...
[2020-12-23 19:51:30,650] - [INFO] - server start, listening on port 8008
[2020-12-23 19:52:23,664] - [INFO] - D:\code\QcWebServer\data_manage\pitcher_panel.py modified; restarting server
[2020-12-23 19:52:24,620] - [INFO] - write pid 19096 ...
[2020-12-23 19:52:24,621] - [INFO] - write pid 12080 ...
[2020-12-23 19:52:24,625] - [INFO] - server start, listening on port 8008
[2020-12-23 19:52:51,508] - [INFO] - write pid 13880 ...
[2020-12-23 19:52:51,514] - [INFO] - server start, listening on port 8008
[2020-12-23 19:52:54,781] - [INFO] - 200 POST /data/pitcher_panel/channel (::1) 508.10ms
[2020-12-23 19:55:43,528] - [INFO] - D:\code\QcWebServer\data_manage\pitcher_panel.py modified; restarting server
[2020-12-23 19:55:44,492] - [INFO] - write pid 12320 ...
[2020-12-23 19:55:44,499] - [INFO] - server start, listening on port 8008
[2020-12-23 19:58:17,520] - [INFO] - D:\code\QcWebServer\data_manage\pitcher_panel.py modified; restarting server
[2020-12-23 19:58:18,487] - [INFO] - write pid 4128 ...
[2020-12-23 19:58:18,495] - [INFO] - server start, listening on port 8008
[2020-12-23 20:02:35,001] - [INFO] - D:\code\QcWebServer\data_manage\pitcher_panel.py modified; restarting server
[2020-12-23 20:02:35,878] - [INFO] - write pid 18664 ...
[2020-12-23 20:02:35,883] - [INFO] - server start, listening on port 8008
[2020-12-23 20:02:35,959] - [INFO] - write pid 10916 ...
[2020-12-23 20:02:39,826] - [INFO] - 200 POST /data/pitcher_panel/channel (::1) 585.77ms
[2020-12-23 20:03:14,904] - [INFO] - D:\code\QcWebServer\handlers\PitcherPanel.py modified; restarting server
[2020-12-23 20:03:15,819] - [INFO] - write pid 704 ...
[2020-12-23 20:03:15,825] - [INFO] - server start, listening on port 8008
[2020-12-23 20:05:45,846] - [INFO] - D:\code\QcWebServer\handlers\PitcherPanel.py modified; restarting server
[2020-12-23 20:37:34,098] - [INFO] - write pid 3468 ...
[2020-12-23 20:37:34,104] - [INFO] - server start, listening on port 8008
[2020-12-23 20:38:32,270] - [ERROR] - Uncaught exception POST /data/pitcher_panel/daily (::1)
HTTPServerRequest(protocol='http', host='localhost:8008', method='POST', uri='/data/pitcher_panel/daily', version='HTTP/1.1', remote_ip='::1')
Traceback (most recent call last):
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\tornado\web.py", line 1702, in _execute
    result = method(*self.path_args, **self.path_kwargs)
  File "D:\code\QcWebServer\handlers\PitcherPanel.py", line 41, in post
    data = get_pitcher_panel_daily(pitcher, start, end, page, page_size, order_by, order)
  File "D:\code\QcWebServer\data_manage\pitcher_panel.py", line 62, in get_pitcher_panel_daily
    data = ck.execute(sql)
  File "D:\code\QcWebServer\model\DataBaseUtils.py", line 62, in execute
    return self.client.execute(sql)
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\clickhouse_driver\client.py", line 252, in execute
    columnar=columnar
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\clickhouse_driver\client.py", line 447, in process_ordinary_query
    columnar=columnar)
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\clickhouse_driver\client.py", line 113, in receive_result
    return result.get_result()
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\clickhouse_driver\result.py", line 50, in get_result
    for packet in self.packet_generator:
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\clickhouse_driver\client.py", line 129, in packet_generator
    packet = self.receive_packet()
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\clickhouse_driver\client.py", line 146, in receive_packet
    raise packet.exception
clickhouse_driver.errors.ServerException: Code: 215.
DB::Exception: Column `dt` is not under aggregate function and not in GROUP BY. Stack trace:

0. /server/clickhouse_build/../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) @ 0xc0390cc in /clickhouse/bin/clickhouse
1. /server/clickhouse_build/../src/Common/Exception.cpp:29: DB::Exception::Exception(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, int) @ 0x5066519 in /clickhouse/bin/clickhouse
2. /server/clickhouse_build/../contrib/libcxx/include/string:2134: DB::ActionsMatcher::visit(DB::ASTIdentifier const&, std::__1::shared_ptr<DB::IAST> const&, DB::ActionsMatcher::Data&) (.cold) @ 0x4d9416e in /clickhouse/bin/clickhouse
3. /server/clickhouse_build/../contrib/libcxx/include/memory:3826: DB::InDepthNodeVisitor<DB::ActionsMatcher, true, std::__1::shared_ptr<DB::IAST> const>::visit(std::__1::shared_ptr<DB::IAST> const&) @ 0x98c4bb5 in /clickhouse/bin/clickhouse
4. /server/clickhouse_build/../src/Interpreters/InDepthNodeVisitor.h:45: DB::InDepthNodeVisitor<DB::ActionsMatcher, true, std::__1::shared_ptr<DB::IAST> const>::visit(std::__1::shared_ptr<DB::IAST> const&) @ 0x98c4bf3 in /clickhouse/bin/clickhouse
5. /server/clickhouse_build/../src/Interpreters/InDepthNodeVisitor.h:45: DB::ExpressionAnalyzer::getRootActions(std::__1::shared_ptr<DB::IAST> const&, bool, std::__1::shared_ptr<DB::ExpressionActions>&, bool) (.constprop.0) @ 0x98b9c3b in /clickhouse/bin/clickhouse
6. /server/clickhouse_build/../src/Interpreters/ExpressionAnalyzer.cpp:798: DB::SelectQueryExpressionAnalyzer::appendOrderBy(DB::ExpressionActionsChain&, bool, bool, std::__1::vector<std::__1::shared_ptr<DB::ExpressionActions>, std::__1::allocator<std::__1::shared_ptr<DB::ExpressionActions> > >&) @ 0x98bb8bb in /clickhouse/bin/clickhouse
7. /server/clickhouse_build/../src/Interpreters/ExpressionAnalyzer.cpp:1089: DB::ExpressionAnalysisResult::ExpressionAnalysisResult(DB::SelectQueryExpressionAnalyzer&, bool, bool, bool, std::__1::shared_ptr<DB::FilterInfo> const&, DB::Block const&) @ 0x98c38ea in /clickhouse/bin/clickhouse
8. /server/clickhouse_build/../src/Interpreters/ExpressionAnalyzer.h:164: DB::InterpreterSelectQuery::getSampleBlockImpl(bool) @ 0x8d3af27 in /clickhouse/bin/clickhouse
9. /server/clickhouse_build/../src/Interpreters/InterpreterSelectQuery.cpp:300: DB::InterpreterSelectQuery::InterpreterSelectQuery(std::__1::shared_ptr<DB::IAST> const&, DB::Context const&, std::__1::shared_ptr<DB::IBlockInputStream> const&, std::__1::optional<DB::Pipe>, std::__1::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, 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&)::'lambda'(bool)::operator()(bool) const @ 0x8d3c66b in /clickhouse/bin/clickhouse
10. /server/clickhouse_build/../src/Interpreters/InterpreterSelectQuery.cpp:374: DB::InterpreterSelectQuery::InterpreterSelectQuery(std::__1::shared_ptr<DB::IAST> const&, DB::Context const&, std::__1::shared_ptr<DB::IBlockInputStream> const&, std::__1::optional<DB::Pipe>, std::__1::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, 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&) @ 0x8d3d282 in /clickhouse/bin/clickhouse
11. /server/clickhouse_build/../src/Interpreters/InterpreterSelectQuery.cpp:167: DB::InterpreterSelectQuery::InterpreterSelectQuery(std::__1::shared_ptr<DB::IAST> const&, DB::Context const&, DB::SelectQueryOptions const&, 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&) @ 0x8d3e7e5 in /clickhouse/bin/clickhouse
12. /server/clickhouse_build/../contrib/libcxx/include/vector:1681: DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::__1::shared_ptr<DB::IAST> const&, DB::Context const&, DB::SelectQueryOptions const&, 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&) @ 0x8d78c96 in /clickhouse/bin/clickhouse
13. /server/clickhouse_build/../contrib/libcxx/include/vector:461: DB::InterpreterFactory::get(std::__1::shared_ptr<DB::IAST>&, DB::Context&, DB::QueryProcessingStage::Enum) @ 0x8d1b7f4 in /clickhouse/bin/clickhouse
14. /server/clickhouse_build/../src/Interpreters/executeQuery.cpp:406: DB::executeQueryImpl(char const*, char const*, DB::Context&, bool, DB::QueryProcessingStage::Enum, bool, DB::ReadBuffer*, bool) @ 0x8f06b06 in /clickhouse/bin/clickhouse
15. /server/clickhouse_build/../src/Interpreters/executeQuery.cpp:718: DB::executeQuery(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, DB::Context&, bool, DB::QueryProcessingStage::Enum, bool, bool) @ 0x8f0a0dd in /clickhouse/bin/clickhouse
16. /server/clickhouse_build/../programs/server/TCPHandler.cpp:257: DB::TCPHandler::runImpl() @ 0x50c1029 in /clickhouse/bin/clickhouse
17. /server/clickhouse_build/../programs/server/TCPHandler.cpp:1252: DB::TCPHandler::run() @ 0x50c1f2c in /clickhouse/bin/clickhouse
18. /server/clickhouse_build/../contrib/poco/Net/src/TCPServerConnection.cpp:57: Poco::Net::TCPServerConnection::start() @ 0x9e54827 in /clickhouse/bin/clickhouse
19. /server/clickhouse_build/../contrib/libcxx/include/atomic:856: Poco::Net::TCPServerDispatcher::run() @ 0x9e54c1d in /clickhouse/bin/clickhouse
20. /server/clickhouse_build/../contrib/poco/Foundation/include/Poco/Mutex_STD.h:132: Poco::PooledThread::run() @ 0xc0ab67f in /clickhouse/bin/clickhouse
21. /server/clickhouse_build/../contrib/poco/Foundation/include/Poco/AutoPtr.h:205: Poco::ThreadImpl::runnableEntry(void*) @ 0xc0a8748 in /clickhouse/bin/clickhouse
22. /server/clickhouse_build/../contrib/libcxx/include/memory:2615: void* std::__1::__thread_proxy<std::__1::tuple<std::__1::unique_ptr<std::__1::__thread_struct, std::__1::default_delete<std::__1::__thread_struct> >, void* (*)(void*), Poco::ThreadImpl*> >(void*) @ 0xc0a9fe9 in /clickhouse/bin/clickhouse
23. start_thread @ 0x76db in /lib/x86_64-linux-gnu/libpthread-2.27.so
24. clone @ 0x121a3f in /lib/x86_64-linux-gnu/libc-2.27.so

[2020-12-23 20:38:32,286] - [ERROR] - 500 POST /data/pitcher_panel/daily (::1) 322.47ms
[2020-12-23 20:39:42,605] - [INFO] - write pid 17236 ...
[2020-12-23 20:39:42,610] - [INFO] - server start, listening on port 8008
[2020-12-23 20:39:44,100] - [ERROR] - Uncaught exception POST /data/pitcher_panel/daily (::1)
HTTPServerRequest(protocol='http', host='localhost:8008', method='POST', uri='/data/pitcher_panel/daily', version='HTTP/1.1', remote_ip='::1')
Traceback (most recent call last):
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\tornado\web.py", line 1702, in _execute
    result = method(*self.path_args, **self.path_kwargs)
  File "D:\code\QcWebServer\handlers\PitcherPanel.py", line 41, in post
    data = get_pitcher_panel_daily(pitcher, start, end, page, page_size, order_by, order)
  File "D:\code\QcWebServer\data_manage\pitcher_panel.py", line 62, in get_pitcher_panel_daily
    data = ck.execute(sql)
  File "D:\code\QcWebServer\model\DataBaseUtils.py", line 62, in execute
    return self.client.execute(sql)
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\clickhouse_driver\client.py", line 252, in execute
    columnar=columnar
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\clickhouse_driver\client.py", line 447, in process_ordinary_query
    columnar=columnar)
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\clickhouse_driver\client.py", line 113, in receive_result
    return result.get_result()
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\clickhouse_driver\result.py", line 50, in get_result
    for packet in self.packet_generator:
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\clickhouse_driver\client.py", line 129, in packet_generator
    packet = self.receive_packet()
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\clickhouse_driver\client.py", line 146, in receive_packet
    raise packet.exception
clickhouse_driver.errors.ServerException: Code: 62.
DB::Exception: Syntax error: failed at position 81 (line 3, col 21): (sum(cost),2) cost,
                round(sum(first_order_amount),2) first_order_amount,
               if(cost=0,0,round(first_order_amount/cost,4)) first_roi . Expected one of: UNION ALL, token, FROM, PREWHERE, WHERE, WITH, HAVING, LIMIT, SETTINGS, FORMAT, Comma, ORDER BY, INTO OUTFILE, GROUP BY. Stack trace:

0. /server/clickhouse_build/../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) @ 0xc0390cc in /clickhouse/bin/clickhouse
1. /server/clickhouse_build/../src/Common/Exception.cpp:29: DB::Exception::Exception(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, int) @ 0x5066519 in /clickhouse/bin/clickhouse
2. /server/clickhouse_build/../src/Parsers/parseQuery.cpp:310: DB::parseQuery(DB::IParser&, char const*, char const*, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, unsigned long, unsigned long) (.cold) @ 0x4db0714 in /clickhouse/bin/clickhouse
3. /server/clickhouse_build/../src/Interpreters/executeQuery.cpp:287: DB::executeQueryImpl(char const*, char const*, DB::Context&, bool, DB::QueryProcessingStage::Enum, bool, DB::ReadBuffer*, bool) @ 0x8f06380 in /clickhouse/bin/clickhouse
4. /server/clickhouse_build/../src/Interpreters/executeQuery.cpp:718: DB::executeQuery(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, DB::Context&, bool, DB::QueryProcessingStage::Enum, bool, bool) @ 0x8f0a0dd in /clickhouse/bin/clickhouse
5. /server/clickhouse_build/../programs/server/TCPHandler.cpp:257: DB::TCPHandler::runImpl() @ 0x50c1029 in /clickhouse/bin/clickhouse
6. /server/clickhouse_build/../programs/server/TCPHandler.cpp:1252: DB::TCPHandler::run() @ 0x50c1f2c in /clickhouse/bin/clickhouse
7. /server/clickhouse_build/../contrib/poco/Net/src/TCPServerConnection.cpp:57: Poco::Net::TCPServerConnection::start() @ 0x9e54827 in /clickhouse/bin/clickhouse
8. /server/clickhouse_build/../contrib/libcxx/include/atomic:856: Poco::Net::TCPServerDispatcher::run() @ 0x9e54c1d in /clickhouse/bin/clickhouse
9. /server/clickhouse_build/../contrib/poco/Foundation/include/Poco/Mutex_STD.h:132: Poco::PooledThread::run() @ 0xc0ab67f in /clickhouse/bin/clickhouse
10. /server/clickhouse_build/../contrib/poco/Foundation/include/Poco/AutoPtr.h:205: Poco::ThreadImpl::runnableEntry(void*) @ 0xc0a8748 in /clickhouse/bin/clickhouse
11. /server/clickhouse_build/../contrib/libcxx/include/memory:2615: void* std::__1::__thread_proxy<std::__1::tuple<std::__1::unique_ptr<std::__1::__thread_struct, std::__1::default_delete<std::__1::__thread_struct> >, void* (*)(void*), Poco::ThreadImpl*> >(void*) @ 0xc0a9fe9 in /clickhouse/bin/clickhouse
12. start_thread @ 0x76db in /lib/x86_64-linux-gnu/libpthread-2.27.so
13. clone @ 0x121a3f in /lib/x86_64-linux-gnu/libc-2.27.so

[2020-12-23 20:39:44,120] - [ERROR] - 500 POST /data/pitcher_panel/daily (::1) 136.05ms
[2020-12-23 20:40:50,058] - [INFO] - write pid 16120 ...
[2020-12-23 20:40:50,065] - [INFO] - server start, listening on port 8008
[2020-12-23 20:40:51,767] - [ERROR] - Uncaught exception POST /data/pitcher_panel/daily (::1)
HTTPServerRequest(protocol='http', host='localhost:8008', method='POST', uri='/data/pitcher_panel/daily', version='HTTP/1.1', remote_ip='::1')
Traceback (most recent call last):
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\tornado\web.py", line 1702, in _execute
    result = method(*self.path_args, **self.path_kwargs)
  File "D:\code\QcWebServer\handlers\PitcherPanel.py", line 41, in post
    data = get_pitcher_panel_daily(pitcher, start, end, page, page_size, order_by, order)
  File "D:\code\QcWebServer\data_manage\pitcher_panel.py", line 62, in get_pitcher_panel_daily
    data = ck.execute(sql)
  File "D:\code\QcWebServer\model\DataBaseUtils.py", line 62, in execute
    return self.client.execute(sql)
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\clickhouse_driver\client.py", line 252, in execute
    columnar=columnar
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\clickhouse_driver\client.py", line 447, in process_ordinary_query
    columnar=columnar)
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\clickhouse_driver\client.py", line 113, in receive_result
    return result.get_result()
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\clickhouse_driver\result.py", line 50, in get_result
    for packet in self.packet_generator:
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\clickhouse_driver\client.py", line 129, in packet_generator
    packet = self.receive_packet()
  File "D:\workspace\py_env\QcWebServer-LLP_2JqD\lib\site-packages\clickhouse_driver\client.py", line 146, in receive_packet
    raise packet.exception
clickhouse_driver.errors.ServerException: Code: 62.
DB::Exception: Syntax error: failed at position 81 (line 3, col 21): (sum(cost),2) cost,
                round(sum(first_order_amount),2) first_order_amount,
               if(cost=0,0,round(first_order_amount/cost,4)) first_roi . Expected one of: UNION ALL, token, FROM, PREWHERE, WHERE, WITH, HAVING, LIMIT, SETTINGS, FORMAT, Comma, ORDER BY, INTO OUTFILE, GROUP BY. Stack trace:

0. /server/clickhouse_build/../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) @ 0xc0390cc in /clickhouse/bin/clickhouse
1. /server/clickhouse_build/../src/Common/Exception.cpp:29: DB::Exception::Exception(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, int) @ 0x5066519 in /clickhouse/bin/clickhouse
2. /server/clickhouse_build/../src/Parsers/parseQuery.cpp:310: DB::parseQuery(DB::IParser&, char const*, char const*, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, unsigned long, unsigned long) (.cold) @ 0x4db0714 in /clickhouse/bin/clickhouse
3. /server/clickhouse_build/../src/Interpreters/executeQuery.cpp:287: DB::executeQueryImpl(char const*, char const*, DB::Context&, bool, DB::QueryProcessingStage::Enum, bool, DB::ReadBuffer*, bool) @ 0x8f06380 in /clickhouse/bin/clickhouse
4. /server/clickhouse_build/../src/Interpreters/executeQuery.cpp:718: DB::executeQuery(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, DB::Context&, bool, DB::QueryProcessingStage::Enum, bool, bool) @ 0x8f0a0dd in /clickhouse/bin/clickhouse
5. /server/clickhouse_build/../programs/server/TCPHandler.cpp:257: DB::TCPHandler::runImpl() @ 0x50c1029 in /clickhouse/bin/clickhouse
6. /server/clickhouse_build/../programs/server/TCPHandler.cpp:1252: DB::TCPHandler::run() @ 0x50c1f2c in /clickhouse/bin/clickhouse
7. /server/clickhouse_build/../contrib/poco/Net/src/TCPServerConnection.cpp:57: Poco::Net::TCPServerConnection::start() @ 0x9e54827 in /clickhouse/bin/clickhouse
8. /server/clickhouse_build/../contrib/libcxx/include/atomic:856: Poco::Net::TCPServerDispatcher::run() @ 0x9e54c1d in /clickhouse/bin/clickhouse
9. /server/clickhouse_build/../contrib/poco/Foundation/include/Poco/Mutex_STD.h:132: Poco::PooledThread::run() @ 0xc0ab67f in /clickhouse/bin/clickhouse
10. /server/clickhouse_build/../contrib/poco/Foundation/include/Poco/AutoPtr.h:205: Poco::ThreadImpl::runnableEntry(void*) @ 0xc0a8748 in /clickhouse/bin/clickhouse
11. /server/clickhouse_build/../contrib/libcxx/include/memory:2615: void* std::__1::__thread_proxy<std::__1::tuple<std::__1::unique_ptr<std::__1::__thread_struct, std::__1::default_delete<std::__1::__thread_struct> >, void* (*)(void*), Poco::ThreadImpl*> >(void*) @ 0xc0a9fe9 in /clickhouse/bin/clickhouse
12. start_thread @ 0x76db in /lib/x86_64-linux-gnu/libpthread-2.27.so
13. clone @ 0x121a3f in /lib/x86_64-linux-gnu/libc-2.27.so

[2020-12-23 20:40:51,786] - [ERROR] - 500 POST /data/pitcher_panel/daily (::1) 133.47ms
[2020-12-23 20:42:16,015] - [INFO] - write pid 19792 ...
[2020-12-23 20:42:16,021] - [INFO] - server start, listening on port 8008
[2020-12-23 20:42:17,936] - [INFO] - 200 POST /data/pitcher_panel/daily (::1) 129.64ms
[2020-12-23 20:42:41,242] - [INFO] - 200 POST /data/pitcher_panel/daily (::1) 38.12ms
[2020-12-23 20:45:48,037] - [INFO] - D:\code\QcWebServer\handlers\PitcherPanel.py modified; restarting server