SHARE
TWEET

Untitled

mr_felixoid Feb 22nd, 2019 61 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. >±> CLICKHOUSE_TESTS_SERVER_BIN_PATH=$(git rev-parse --show-toplevel)/build/dbms/programs/clickhouse pytest2 test_graphite_merge_tree/test.py                              
  2. ==================================================================================== test session starts =====================================================================================
  3. platform linux2 -- Python 2.7.15, pytest-4.3.0, py-1.7.0, pluggy-0.8.1
  4. rootdir: /home/felixoid/OPT/Felixoid/github/yandex/ClickHouse/dbms/tests/integration, inifile: pytest.ini
  5. collected 7 items                                                                                                                                                                            
  6.  
  7. test_graphite_merge_tree/test.py FEEEEEEE                                                                                                                                              [100%]
  8.  
  9. =========================================================================================== ERRORS ===========================================================================================
  10. _________________________________________________________________________ ERROR at teardown of test_rollup_versions __________________________________________________________________________
  11.  
  12. started_cluster = <helpers.cluster.ClickHouseCluster instance at 0x7fbfd966d7e8>
  13.  
  14.     @pytest.fixture
  15.     def graphite_table(started_cluster):
  16.         instance.query('''
  17.     DROP TABLE IF EXISTS test.graphite;
  18.     CREATE TABLE test.graphite
  19.         (metric String, value Float64, timestamp UInt32, date Date, updated UInt32)
  20.         ENGINE = GraphiteMergeTree('graphite_rollup')
  21.         PARTITION BY date
  22.         ORDER BY (metric, timestamp)
  23.         SETTINGS index_granularity=8192;
  24.     ''')
  25.    
  26.         yield
  27.    
  28. >       instance.query('DROP TABLE test.graphite')
  29.  
  30. test_graphite_merge_tree/test.py:41:
  31. _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
  32. helpers/cluster.py:436: in query
  33.     return self.client.query(sql, stdin, timeout, settings, user, ignore_error)
  34. helpers/client.py:21: in query
  35.     return self.get_query_request(sql, stdin=stdin, timeout=timeout, settings=settings, user=user, ignore_error=ignore_error).get_answer()
  36. _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
  37.  
  38. self = <helpers.client.CommandRequest instance at 0x7fbfd791f050>
  39.  
  40.     def get_answer(self):
  41.         self.process.wait()
  42.         self.stdout_file.seek(0)
  43.         self.stderr_file.seek(0)
  44.    
  45.         stdout = self.stdout_file.read()
  46.         stderr = self.stderr_file.read()
  47.    
  48.         if self.timer is not None and not self.process_finished_before_timeout and not self.ignore_error:
  49.             raise QueryTimeoutExceedException('Client timed out!')
  50.    
  51.         if (self.process.returncode != 0 or stderr) and not self.ignore_error:
  52. >           raise QueryRuntimeException('Client failed! Return code: {}, stderr: {}'.format(self.process.returncode, stderr))
  53. E           QueryRuntimeException: Client failed! Return code: 210, stderr: Code: 210. DB::NetException: Net Exception: No route to host (192.168.64.2:9000)
  54.  
  55. helpers/client.py:89: QueryRuntimeException
  56. ----------------------------------------------------------------------------------- Captured stderr setup ------------------------------------------------------------------------------------
  57. Removing network clickhouse_default
  58. Network clickhouse_default not found.
  59. Some networks were defined but are not used by any service: app_net
  60. Creating network "felixoidtestgraphitemergetree_default" with the default driver
  61. Creating felixoidtestgraphitemergetree_instance_1 ... done
  62.  
  63. _________________________________________________________________________ ERROR at setup of test_rollup_aggregation __________________________________________________________________________
  64.  
  65. started_cluster = <helpers.cluster.ClickHouseCluster instance at 0x7fbfd966d7e8>
  66.  
  67.     @pytest.fixture
  68.     def graphite_table(started_cluster):
  69.         instance.query('''
  70.     DROP TABLE IF EXISTS test.graphite;
  71.     CREATE TABLE test.graphite
  72.         (metric String, value Float64, timestamp UInt32, date Date, updated UInt32)
  73.         ENGINE = GraphiteMergeTree('graphite_rollup')
  74.         PARTITION BY date
  75.         ORDER BY (metric, timestamp)
  76.         SETTINGS index_granularity=8192;
  77. >   ''')
  78.  
  79. test_graphite_merge_tree/test.py:37:
  80. _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
  81. helpers/cluster.py:436: in query
  82.     return self.client.query(sql, stdin, timeout, settings, user, ignore_error)
  83. helpers/client.py:21: in query
  84.     return self.get_query_request(sql, stdin=stdin, timeout=timeout, settings=settings, user=user, ignore_error=ignore_error).get_answer()
  85. _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
  86.  
  87. self = <helpers.client.CommandRequest instance at 0x7fbfd7c19170>
  88.  
  89.     def get_answer(self):
  90.         self.process.wait()
  91.         self.stdout_file.seek(0)
  92.         self.stderr_file.seek(0)
  93.    
  94.         stdout = self.stdout_file.read()
  95.         stderr = self.stderr_file.read()
  96.    
  97.         if self.timer is not None and not self.process_finished_before_timeout and not self.ignore_error:
  98.             raise QueryTimeoutExceedException('Client timed out!')
  99.    
  100.         if (self.process.returncode != 0 or stderr) and not self.ignore_error:
  101. >           raise QueryRuntimeException('Client failed! Return code: {}, stderr: {}'.format(self.process.returncode, stderr))
  102. E           QueryRuntimeException: Client failed! Return code: 210, stderr: Code: 210. DB::NetException: Net Exception: No route to host (192.168.64.2:9000)
  103.  
  104. helpers/client.py:89: QueryRuntimeException
  105. ________________________________________________________________________ ERROR at setup of test_rollup_aggregation_2 _________________________________________________________________________
  106.  
  107. started_cluster = <helpers.cluster.ClickHouseCluster instance at 0x7fbfd966d7e8>
  108.  
  109.     @pytest.fixture
  110.     def graphite_table(started_cluster):
  111.         instance.query('''
  112.     DROP TABLE IF EXISTS test.graphite;
  113.     CREATE TABLE test.graphite
  114.         (metric String, value Float64, timestamp UInt32, date Date, updated UInt32)
  115.         ENGINE = GraphiteMergeTree('graphite_rollup')
  116.         PARTITION BY date
  117.         ORDER BY (metric, timestamp)
  118.         SETTINGS index_granularity=8192;
  119. >   ''')
  120.  
  121. test_graphite_merge_tree/test.py:37:
  122. _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
  123. helpers/cluster.py:436: in query
  124.     return self.client.query(sql, stdin, timeout, settings, user, ignore_error)
  125. helpers/client.py:21: in query
  126.     return self.get_query_request(sql, stdin=stdin, timeout=timeout, settings=settings, user=user, ignore_error=ignore_error).get_answer()
  127. _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
  128.  
  129. self = <helpers.client.CommandRequest instance at 0x7fbfd7921050>
  130.  
  131.     def get_answer(self):
  132.         self.process.wait()
  133.         self.stdout_file.seek(0)
  134.         self.stderr_file.seek(0)
  135.    
  136.         stdout = self.stdout_file.read()
  137.         stderr = self.stderr_file.read()
  138.    
  139.         if self.timer is not None and not self.process_finished_before_timeout and not self.ignore_error:
  140.             raise QueryTimeoutExceedException('Client timed out!')
  141.    
  142.         if (self.process.returncode != 0 or stderr) and not self.ignore_error:
  143. >           raise QueryRuntimeException('Client failed! Return code: {}, stderr: {}'.format(self.process.returncode, stderr))
  144. E           QueryRuntimeException: Client failed! Return code: 210, stderr: Code: 210. DB::NetException: Net Exception: No route to host (192.168.64.2:9000)
  145.  
  146. helpers/client.py:89: QueryRuntimeException
  147. _____________________________________________________________________ ERROR at setup of test_multiple_paths_and_versions _____________________________________________________________________
  148.  
  149. started_cluster = <helpers.cluster.ClickHouseCluster instance at 0x7fbfd966d7e8>
  150.  
  151.     @pytest.fixture
  152.     def graphite_table(started_cluster):
  153.         instance.query('''
  154.     DROP TABLE IF EXISTS test.graphite;
  155.     CREATE TABLE test.graphite
  156.         (metric String, value Float64, timestamp UInt32, date Date, updated UInt32)
  157.         ENGINE = GraphiteMergeTree('graphite_rollup')
  158.         PARTITION BY date
  159.         ORDER BY (metric, timestamp)
  160.         SETTINGS index_granularity=8192;
  161. >   ''')
  162.  
  163. test_graphite_merge_tree/test.py:37:
  164. _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
  165. helpers/cluster.py:436: in query
  166.     return self.client.query(sql, stdin, timeout, settings, user, ignore_error)
  167. helpers/client.py:21: in query
  168.     return self.get_query_request(sql, stdin=stdin, timeout=timeout, settings=settings, user=user, ignore_error=ignore_error).get_answer()
  169. _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
  170.  
  171. self = <helpers.client.CommandRequest instance at 0x7fbfd792a050>
  172.  
  173.     def get_answer(self):
  174.         self.process.wait()
  175.         self.stdout_file.seek(0)
  176.         self.stderr_file.seek(0)
  177.    
  178.         stdout = self.stdout_file.read()
  179.         stderr = self.stderr_file.read()
  180.    
  181.         if self.timer is not None and not self.process_finished_before_timeout and not self.ignore_error:
  182.             raise QueryTimeoutExceedException('Client timed out!')
  183.    
  184.         if (self.process.returncode != 0 or stderr) and not self.ignore_error:
  185. >           raise QueryRuntimeException('Client failed! Return code: {}, stderr: {}'.format(self.process.returncode, stderr))
  186. E           QueryRuntimeException: Client failed! Return code: 210, stderr: Code: 210. DB::NetException: Net Exception: No route to host (192.168.64.2:9000)
  187.  
  188. helpers/client.py:89: QueryRuntimeException
  189. _______________________________________________________________________ ERROR at setup of test_multiple_output_blocks ________________________________________________________________________
  190.  
  191. started_cluster = <helpers.cluster.ClickHouseCluster instance at 0x7fbfd966d7e8>
  192.  
  193.     @pytest.fixture
  194.     def graphite_table(started_cluster):
  195.         instance.query('''
  196.     DROP TABLE IF EXISTS test.graphite;
  197.     CREATE TABLE test.graphite
  198.         (metric String, value Float64, timestamp UInt32, date Date, updated UInt32)
  199.         ENGINE = GraphiteMergeTree('graphite_rollup')
  200.         PARTITION BY date
  201.         ORDER BY (metric, timestamp)
  202.         SETTINGS index_granularity=8192;
  203. >   ''')
  204.  
  205. test_graphite_merge_tree/test.py:37:
  206. _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
  207. helpers/cluster.py:436: in query
  208.     return self.client.query(sql, stdin, timeout, settings, user, ignore_error)
  209. helpers/client.py:21: in query
  210.     return self.get_query_request(sql, stdin=stdin, timeout=timeout, settings=settings, user=user, ignore_error=ignore_error).get_answer()
  211. _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
  212.  
  213. self = <helpers.client.CommandRequest instance at 0x7fbfd791f050>
  214.  
  215.     def get_answer(self):
  216.         self.process.wait()
  217.         self.stdout_file.seek(0)
  218.         self.stderr_file.seek(0)
  219.    
  220.         stdout = self.stdout_file.read()
  221.         stderr = self.stderr_file.read()
  222.    
  223.         if self.timer is not None and not self.process_finished_before_timeout and not self.ignore_error:
  224.             raise QueryTimeoutExceedException('Client timed out!')
  225.    
  226.         if (self.process.returncode != 0 or stderr) and not self.ignore_error:
  227. >           raise QueryRuntimeException('Client failed! Return code: {}, stderr: {}'.format(self.process.returncode, stderr))
  228. E           QueryRuntimeException: Client failed! Return code: 210, stderr: Code: 210. DB::NetException: Net Exception: No route to host (192.168.64.2:9000)
  229.  
  230. helpers/client.py:89: QueryRuntimeException
  231. ___________________________________________________________________ ERROR at setup of test_paths_not_matching_any_pattern ____________________________________________________________________
  232.  
  233. started_cluster = <helpers.cluster.ClickHouseCluster instance at 0x7fbfd966d7e8>
  234.  
  235.     @pytest.fixture
  236.     def graphite_table(started_cluster):
  237.         instance.query('''
  238.     DROP TABLE IF EXISTS test.graphite;
  239.     CREATE TABLE test.graphite
  240.         (metric String, value Float64, timestamp UInt32, date Date, updated UInt32)
  241.         ENGINE = GraphiteMergeTree('graphite_rollup')
  242.         PARTITION BY date
  243.         ORDER BY (metric, timestamp)
  244.         SETTINGS index_granularity=8192;
  245. >   ''')
  246.  
  247. test_graphite_merge_tree/test.py:37:
  248. _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
  249. helpers/cluster.py:436: in query
  250.     return self.client.query(sql, stdin, timeout, settings, user, ignore_error)
  251. helpers/client.py:21: in query
  252.     return self.get_query_request(sql, stdin=stdin, timeout=timeout, settings=settings, user=user, ignore_error=ignore_error).get_answer()
  253. _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
  254.  
  255. self = <helpers.client.CommandRequest instance at 0x7fbfd79297a0>
  256.  
  257.     def get_answer(self):
  258.         self.process.wait()
  259.         self.stdout_file.seek(0)
  260.         self.stderr_file.seek(0)
  261.    
  262.         stdout = self.stdout_file.read()
  263.         stderr = self.stderr_file.read()
  264.    
  265.         if self.timer is not None and not self.process_finished_before_timeout and not self.ignore_error:
  266.             raise QueryTimeoutExceedException('Client timed out!')
  267.    
  268.         if (self.process.returncode != 0 or stderr) and not self.ignore_error:
  269. >           raise QueryRuntimeException('Client failed! Return code: {}, stderr: {}'.format(self.process.returncode, stderr))
  270. E           QueryRuntimeException: Client failed! Return code: 210, stderr: Code: 210. DB::NetException: Net Exception: No route to host (192.168.64.2:9000)
  271.  
  272. helpers/client.py:89: QueryRuntimeException
  273. ________________________________________________________________________ ERROR at setup of test_path_dangling_pointer ________________________________________________________________________
  274.  
  275. started_cluster = <helpers.cluster.ClickHouseCluster instance at 0x7fbfd966d7e8>
  276.  
  277.     @pytest.fixture
  278.     def graphite_table(started_cluster):
  279.         instance.query('''
  280.     DROP TABLE IF EXISTS test.graphite;
  281.     CREATE TABLE test.graphite
  282.         (metric String, value Float64, timestamp UInt32, date Date, updated UInt32)
  283.         ENGINE = GraphiteMergeTree('graphite_rollup')
  284.         PARTITION BY date
  285.         ORDER BY (metric, timestamp)
  286.         SETTINGS index_granularity=8192;
  287. >   ''')
  288.  
  289. test_graphite_merge_tree/test.py:37:
  290. _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
  291. helpers/cluster.py:436: in query
  292.     return self.client.query(sql, stdin, timeout, settings, user, ignore_error)
  293. helpers/client.py:21: in query
  294.     return self.get_query_request(sql, stdin=stdin, timeout=timeout, settings=settings, user=user, ignore_error=ignore_error).get_answer()
  295. _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
  296.  
  297. self = <helpers.client.CommandRequest instance at 0x7fbfd7921d88>
  298.  
  299.     def get_answer(self):
  300.         self.process.wait()
  301.         self.stdout_file.seek(0)
  302.         self.stderr_file.seek(0)
  303.    
  304.         stdout = self.stdout_file.read()
  305.         stderr = self.stderr_file.read()
  306.    
  307.         if self.timer is not None and not self.process_finished_before_timeout and not self.ignore_error:
  308.             raise QueryTimeoutExceedException('Client timed out!')
  309.    
  310.         if (self.process.returncode != 0 or stderr) and not self.ignore_error:
  311. >           raise QueryRuntimeException('Client failed! Return code: {}, stderr: {}'.format(self.process.returncode, stderr))
  312. E           QueryRuntimeException: Client failed! Return code: 210, stderr: Code: 210. DB::NetException: Net Exception: No route to host (192.168.64.2:9000)
  313.  
  314. helpers/client.py:89: QueryRuntimeException
  315. ========================================================================================== FAILURES ==========================================================================================
  316. ____________________________________________________________________________________ test_rollup_versions ____________________________________________________________________________________
  317.  
  318. graphite_table = None
  319.  
  320.     def test_rollup_versions(graphite_table):
  321.         timestamp = int(time.time())
  322.         rounded_timestamp = timestamp - timestamp % 60
  323.         date = datetime.date.today().isoformat()
  324.    
  325.         q = instance.query
  326.    
  327.         # Insert rows with timestamps relative to the current time so that the
  328.         # first retention clause is active.
  329.         # Two parts are created.
  330.         q('''
  331.     INSERT INTO test.graphite (metric, value, timestamp, date, updated)
  332.           VALUES ('one_min.x1', 100, {timestamp}, '{date}', 1);
  333.     INSERT INTO test.graphite (metric, value, timestamp, date, updated)
  334.           VALUES ('one_min.x1', 200, {timestamp}, '{date}', 2);
  335.     '''.format(timestamp=timestamp, date=date))
  336.    
  337.         expected1 = '''\
  338.     one_min.x1  100 {timestamp} {date}  1
  339.     one_min.x1  200 {timestamp} {date}  2
  340.     '''.format(timestamp=timestamp, date=date)
  341.    
  342.         assert TSV(
  343.             q('SELECT * FROM test.graphite ORDER BY updated')
  344.         ) == TSV(expected1)
  345.    
  346. >       q('OPTIMIZE TABLE test.graphite')
  347.  
  348. test_graphite_merge_tree/test.py:70:
  349. _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
  350. helpers/cluster.py:436: in query
  351.     return self.client.query(sql, stdin, timeout, settings, user, ignore_error)
  352. helpers/client.py:21: in query
  353.     return self.get_query_request(sql, stdin=stdin, timeout=timeout, settings=settings, user=user, ignore_error=ignore_error).get_answer()
  354. _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
  355.  
  356. self = <helpers.client.CommandRequest instance at 0x7fbfd7a8c290>
  357.  
  358.     def get_answer(self):
  359.         self.process.wait()
  360.         self.stdout_file.seek(0)
  361.         self.stderr_file.seek(0)
  362.    
  363.         stdout = self.stdout_file.read()
  364.         stderr = self.stderr_file.read()
  365.    
  366.         if self.timer is not None and not self.process_finished_before_timeout and not self.ignore_error:
  367.             raise QueryTimeoutExceedException('Client timed out!')
  368.    
  369.         if (self.process.returncode != 0 or stderr) and not self.ignore_error:
  370. >           raise QueryRuntimeException('Client failed! Return code: {}, stderr: {}'.format(self.process.returncode, stderr))
  371. E           QueryRuntimeException: Client failed! Return code: 32, stderr: Error on processing query: OPTIMIZE TABLE test.graphite
  372. E           Code: 32, e.displayText() = DB::Exception: Attempt to read after eof: while receiving packet from 192.168.64.2:9000, e.what() = DB::Exception, Stack trace:
  373. E          
  374. E           0. /usr/lib/libclickhouse.so.19.1(StackTrace::StackTrace()+0x17) [0x7fd894a7a477]
  375. E           1. /usr/bin/clickhouse-client(DB::Exception::Exception(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&, int)+0x28) [0x561edd2da548]
  376. E           2. /usr/bin/clickhouse-client(DB::throwReadAfterEOF()+0x56) [0x561edd2da886]
  377. E           3. /usr/lib/libclickhouse.so.19.1(DB::Connection::receivePacket()+0xebe) [0x7fd89493020e]
  378. E           4. /usr/bin/clickhouse-client(DB::Client::receiveAndProcessPacket()+0x3d) [0x561edd33a24d]
  379. E           5. /usr/bin/clickhouse-client(DB::Client::processSingleQuery(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&, std::shared_ptr<DB::IAST>)+0x653) [0x561edd33c6c3]
  380. E           6. /usr/bin/clickhouse-client(DB::Client::process(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&)+0x1d0) [0x561edd33ce30]
  381. E           7. /usr/bin/clickhouse-client(DB::Client::mainImpl()+0x1283) [0x561edd33f993]
  382. E           8. /usr/bin/clickhouse-client(DB::Client::main(std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&)+0x26) [0x561edd2cf616]
  383. E           9. /usr/lib/libclickhouse.so.19.1(Poco::Util::Application::run()+0x35) [0x7fd894ecb985]
  384. E           10. /usr/bin/clickhouse-client(mainEntryClickHouseClient(int, char**)+0x4b) [0x561edd2ff2bb]
  385. E           11. /usr/bin/clickhouse-client(main+0x29e) [0x561edd2c989e]
  386. E           12. /usr/lib/libc.so.6(__libc_start_main+0xf3) [0x7fd893615223]
  387. E           13. /usr/bin/clickhouse-client(_start+0x2e) [0x561edd2d71ee]
  388.  
  389. helpers/client.py:89: QueryRuntimeException
  390. ----------------------------------------------------------------------------------- Captured stderr setup ------------------------------------------------------------------------------------
  391. Removing network clickhouse_default
  392. Network clickhouse_default not found.
  393. Some networks were defined but are not used by any service: app_net
  394. Creating network "felixoidtestgraphitemergetree_default" with the default driver
  395. Creating felixoidtestgraphitemergetree_instance_1 ... done
  396.  
  397. ============================================================================= 1 failed, 7 error in 40.99 seconds =============================================================================
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top