· 7 years ago · Feb 22, 2019, 09:04 AM
1>±> sudo python2 runner --binary $(git rev-parse --show-toplevel)/build/dbms/programs/clickhouse --clickhouse-root $(git rev-parse --show-toplevel) test_graphite_merge_tree
2Start tests
3============================= test session starts ==============================
4platform linux2 -- Python 2.7.15rc1, pytest-4.1.1, py-1.7.0, pluggy-0.8.1
5rootdir: /ClickHouse/dbms/tests/integration, inifile: pytest.ini
6collected 7 items
7
8test_graphite_merge_tree/test.py FEEEEEEE [100%]
9
10==================================== ERRORS ====================================
11__________________ ERROR at teardown of test_rollup_versions ___________________
12
13started_cluster = <helpers.cluster.ClickHouseCluster instance at 0x7f4642230cb0>
14
15 @pytest.fixture
16 def graphite_table(started_cluster):
17 instance.query('''
18 DROP TABLE IF EXISTS test.graphite;
19 CREATE TABLE test.graphite
20 (metric String, value Float64, timestamp UInt32, date Date, updated UInt32)
21 ENGINE = GraphiteMergeTree('graphite_rollup')
22 PARTITION BY date
23 ORDER BY (metric, timestamp)
24 SETTINGS index_granularity=8192;
25 ''')
26
27 yield
28
29> instance.query('DROP TABLE test.graphite')
30
31test_graphite_merge_tree/test.py:41:
32_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
33helpers/cluster.py:436: in query
34 return self.client.query(sql, stdin, timeout, settings, user, ignore_error)
35helpers/client.py:21: in query
36 return self.get_query_request(sql, stdin=stdin, timeout=timeout, settings=settings, user=user, ignore_error=ignore_error).get_answer()
37_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
38
39self = <helpers.client.CommandRequest instance at 0x7f463e738638>
40
41 def get_answer(self):
42 self.process.wait()
43 self.stdout_file.seek(0)
44 self.stderr_file.seek(0)
45
46 stdout = self.stdout_file.read()
47 stderr = self.stderr_file.read()
48
49 if self.timer is not None and not self.process_finished_before_timeout and not self.ignore_error:
50 raise QueryTimeoutExceedException('Client timed out!')
51
52 if (self.process.returncode != 0 or stderr) and not self.ignore_error:
53> raise QueryRuntimeException('Client failed! Return code: {}, stderr: {}'.format(self.process.returncode, stderr))
54E QueryRuntimeException: Client failed! Return code: 210, stderr: Code: 210. DB::NetException: Net Exception: No route to host (172.20.0.2:9000)
55
56helpers/client.py:89: QueryRuntimeException
57---------------------------- Captured stdout setup -----------------------------
58latest: Pulling from yandex/clickhouse-integration-test
59Digest: sha256:158b6cef108a9d87354e1195faab4d286196a07e1664130126e031e48483b2bd
60Status: Downloaded newer image for yandex/clickhouse-integration-test:latest
61---------------------------- Captured stderr setup -----------------------------
62Removing network clickhouse_default
63Network clickhouse_default not found.
64Some networks were defined but are not used by any service: app_net
65Creating network "roottestgraphitemergetree_default" with the default driver
66Pulling instance (yandex/clickhouse-integration-test:)...
67Creating roottestgraphitemergetree_instance_1 ... done
68
69__________________ ERROR at setup of test_rollup_aggregation ___________________
70
71started_cluster = <helpers.cluster.ClickHouseCluster instance at 0x7f4642230cb0>
72
73 @pytest.fixture
74 def graphite_table(started_cluster):
75 instance.query('''
76 DROP TABLE IF EXISTS test.graphite;
77 CREATE TABLE test.graphite
78 (metric String, value Float64, timestamp UInt32, date Date, updated UInt32)
79 ENGINE = GraphiteMergeTree('graphite_rollup')
80 PARTITION BY date
81 ORDER BY (metric, timestamp)
82 SETTINGS index_granularity=8192;
83> ''')
84
85test_graphite_merge_tree/test.py:37:
86_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
87helpers/cluster.py:436: in query
88 return self.client.query(sql, stdin, timeout, settings, user, ignore_error)
89helpers/client.py:21: in query
90 return self.get_query_request(sql, stdin=stdin, timeout=timeout, settings=settings, user=user, ignore_error=ignore_error).get_answer()
91_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
92
93self = <helpers.client.CommandRequest instance at 0x7f463e7634d0>
94
95 def get_answer(self):
96 self.process.wait()
97 self.stdout_file.seek(0)
98 self.stderr_file.seek(0)
99
100 stdout = self.stdout_file.read()
101 stderr = self.stderr_file.read()
102
103 if self.timer is not None and not self.process_finished_before_timeout and not self.ignore_error:
104 raise QueryTimeoutExceedException('Client timed out!')
105
106 if (self.process.returncode != 0 or stderr) and not self.ignore_error:
107> raise QueryRuntimeException('Client failed! Return code: {}, stderr: {}'.format(self.process.returncode, stderr))
108E QueryRuntimeException: Client failed! Return code: 210, stderr: Code: 210. DB::NetException: Net Exception: No route to host (172.20.0.2:9000)
109
110helpers/client.py:89: QueryRuntimeException
111_________________ ERROR at setup of test_rollup_aggregation_2 __________________
112
113started_cluster = <helpers.cluster.ClickHouseCluster instance at 0x7f4642230cb0>
114
115 @pytest.fixture
116 def graphite_table(started_cluster):
117 instance.query('''
118 DROP TABLE IF EXISTS test.graphite;
119 CREATE TABLE test.graphite
120 (metric String, value Float64, timestamp UInt32, date Date, updated UInt32)
121 ENGINE = GraphiteMergeTree('graphite_rollup')
122 PARTITION BY date
123 ORDER BY (metric, timestamp)
124 SETTINGS index_granularity=8192;
125> ''')
126
127test_graphite_merge_tree/test.py:37:
128_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
129helpers/cluster.py:436: in query
130 return self.client.query(sql, stdin, timeout, settings, user, ignore_error)
131helpers/client.py:21: in query
132 return self.get_query_request(sql, stdin=stdin, timeout=timeout, settings=settings, user=user, ignore_error=ignore_error).get_answer()
133_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
134
135self = <helpers.client.CommandRequest instance at 0x7f463e6e35f0>
136
137 def get_answer(self):
138 self.process.wait()
139 self.stdout_file.seek(0)
140 self.stderr_file.seek(0)
141
142 stdout = self.stdout_file.read()
143 stderr = self.stderr_file.read()
144
145 if self.timer is not None and not self.process_finished_before_timeout and not self.ignore_error:
146 raise QueryTimeoutExceedException('Client timed out!')
147
148 if (self.process.returncode != 0 or stderr) and not self.ignore_error:
149> raise QueryRuntimeException('Client failed! Return code: {}, stderr: {}'.format(self.process.returncode, stderr))
150E QueryRuntimeException: Client failed! Return code: 210, stderr: Code: 210. DB::NetException: Net Exception: No route to host (172.20.0.2:9000)
151
152helpers/client.py:89: QueryRuntimeException
153______________ ERROR at setup of test_multiple_paths_and_versions ______________
154
155started_cluster = <helpers.cluster.ClickHouseCluster instance at 0x7f4642230cb0>
156
157 @pytest.fixture
158 def graphite_table(started_cluster):
159 instance.query('''
160 DROP TABLE IF EXISTS test.graphite;
161 CREATE TABLE test.graphite
162 (metric String, value Float64, timestamp UInt32, date Date, updated UInt32)
163 ENGINE = GraphiteMergeTree('graphite_rollup')
164 PARTITION BY date
165 ORDER BY (metric, timestamp)
166 SETTINGS index_granularity=8192;
167> ''')
168
169test_graphite_merge_tree/test.py:37:
170_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
171helpers/cluster.py:436: in query
172 return self.client.query(sql, stdin, timeout, settings, user, ignore_error)
173helpers/client.py:21: in query
174 return self.get_query_request(sql, stdin=stdin, timeout=timeout, settings=settings, user=user, ignore_error=ignore_error).get_answer()
175_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
176
177self = <helpers.client.CommandRequest instance at 0x7f463e752c20>
178
179 def get_answer(self):
180 self.process.wait()
181 self.stdout_file.seek(0)
182 self.stderr_file.seek(0)
183
184 stdout = self.stdout_file.read()
185 stderr = self.stderr_file.read()
186
187 if self.timer is not None and not self.process_finished_before_timeout and not self.ignore_error:
188 raise QueryTimeoutExceedException('Client timed out!')
189
190 if (self.process.returncode != 0 or stderr) and not self.ignore_error:
191> raise QueryRuntimeException('Client failed! Return code: {}, stderr: {}'.format(self.process.returncode, stderr))
192E QueryRuntimeException: Client failed! Return code: 210, stderr: Code: 210. DB::NetException: Net Exception: No route to host (172.20.0.2:9000)
193
194helpers/client.py:89: QueryRuntimeException
195________________ ERROR at setup of test_multiple_output_blocks _________________
196
197started_cluster = <helpers.cluster.ClickHouseCluster instance at 0x7f4642230cb0>
198
199 @pytest.fixture
200 def graphite_table(started_cluster):
201 instance.query('''
202 DROP TABLE IF EXISTS test.graphite;
203 CREATE TABLE test.graphite
204 (metric String, value Float64, timestamp UInt32, date Date, updated UInt32)
205 ENGINE = GraphiteMergeTree('graphite_rollup')
206 PARTITION BY date
207 ORDER BY (metric, timestamp)
208 SETTINGS index_granularity=8192;
209> ''')
210
211test_graphite_merge_tree/test.py:37:
212_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
213helpers/cluster.py:436: in query
214 return self.client.query(sql, stdin, timeout, settings, user, ignore_error)
215helpers/client.py:21: in query
216 return self.get_query_request(sql, stdin=stdin, timeout=timeout, settings=settings, user=user, ignore_error=ignore_error).get_answer()
217_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
218
219self = <helpers.client.CommandRequest instance at 0x7f463e68b200>
220
221 def get_answer(self):
222 self.process.wait()
223 self.stdout_file.seek(0)
224 self.stderr_file.seek(0)
225
226 stdout = self.stdout_file.read()
227 stderr = self.stderr_file.read()
228
229 if self.timer is not None and not self.process_finished_before_timeout and not self.ignore_error:
230 raise QueryTimeoutExceedException('Client timed out!')
231
232 if (self.process.returncode != 0 or stderr) and not self.ignore_error:
233> raise QueryRuntimeException('Client failed! Return code: {}, stderr: {}'.format(self.process.returncode, stderr))
234E QueryRuntimeException: Client failed! Return code: 210, stderr: Code: 210. DB::NetException: Net Exception: No route to host (172.20.0.2:9000)
235
236helpers/client.py:89: QueryRuntimeException
237____________ ERROR at setup of test_paths_not_matching_any_pattern _____________
238
239started_cluster = <helpers.cluster.ClickHouseCluster instance at 0x7f4642230cb0>
240
241 @pytest.fixture
242 def graphite_table(started_cluster):
243 instance.query('''
244 DROP TABLE IF EXISTS test.graphite;
245 CREATE TABLE test.graphite
246 (metric String, value Float64, timestamp UInt32, date Date, updated UInt32)
247 ENGINE = GraphiteMergeTree('graphite_rollup')
248 PARTITION BY date
249 ORDER BY (metric, timestamp)
250 SETTINGS index_granularity=8192;
251> ''')
252
253test_graphite_merge_tree/test.py:37:
254_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
255helpers/cluster.py:436: in query
256 return self.client.query(sql, stdin, timeout, settings, user, ignore_error)
257helpers/client.py:21: in query
258 return self.get_query_request(sql, stdin=stdin, timeout=timeout, settings=settings, user=user, ignore_error=ignore_error).get_answer()
259_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
260
261self = <helpers.client.CommandRequest instance at 0x7f463e72f2d8>
262
263 def get_answer(self):
264 self.process.wait()
265 self.stdout_file.seek(0)
266 self.stderr_file.seek(0)
267
268 stdout = self.stdout_file.read()
269 stderr = self.stderr_file.read()
270
271 if self.timer is not None and not self.process_finished_before_timeout and not self.ignore_error:
272 raise QueryTimeoutExceedException('Client timed out!')
273
274 if (self.process.returncode != 0 or stderr) and not self.ignore_error:
275> raise QueryRuntimeException('Client failed! Return code: {}, stderr: {}'.format(self.process.returncode, stderr))
276E QueryRuntimeException: Client failed! Return code: 210, stderr: Code: 210. DB::NetException: Net Exception: No route to host (172.20.0.2:9000)
277
278helpers/client.py:89: QueryRuntimeException
279_________________ ERROR at setup of test_path_dangling_pointer _________________
280
281started_cluster = <helpers.cluster.ClickHouseCluster instance at 0x7f4642230cb0>
282
283 @pytest.fixture
284 def graphite_table(started_cluster):
285 instance.query('''
286 DROP TABLE IF EXISTS test.graphite;
287 CREATE TABLE test.graphite
288 (metric String, value Float64, timestamp UInt32, date Date, updated UInt32)
289 ENGINE = GraphiteMergeTree('graphite_rollup')
290 PARTITION BY date
291 ORDER BY (metric, timestamp)
292 SETTINGS index_granularity=8192;
293> ''')
294
295test_graphite_merge_tree/test.py:37:
296_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
297helpers/cluster.py:436: in query
298 return self.client.query(sql, stdin, timeout, settings, user, ignore_error)
299helpers/client.py:21: in query
300 return self.get_query_request(sql, stdin=stdin, timeout=timeout, settings=settings, user=user, ignore_error=ignore_error).get_answer()
301_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
302
303self = <helpers.client.CommandRequest instance at 0x7f463e6812d8>
304
305 def get_answer(self):
306 self.process.wait()
307 self.stdout_file.seek(0)
308 self.stderr_file.seek(0)
309
310 stdout = self.stdout_file.read()
311 stderr = self.stderr_file.read()
312
313 if self.timer is not None and not self.process_finished_before_timeout and not self.ignore_error:
314 raise QueryTimeoutExceedException('Client timed out!')
315
316 if (self.process.returncode != 0 or stderr) and not self.ignore_error:
317> raise QueryRuntimeException('Client failed! Return code: {}, stderr: {}'.format(self.process.returncode, stderr))
318E QueryRuntimeException: Client failed! Return code: 210, stderr: Code: 210. DB::NetException: Net Exception: No route to host (172.20.0.2:9000)
319
320helpers/client.py:89: QueryRuntimeException
321=================================== FAILURES ===================================
322_____________________________ test_rollup_versions _____________________________
323
324graphite_table = None
325
326 def test_rollup_versions(graphite_table):
327 timestamp = int(time.time())
328 rounded_timestamp = timestamp - timestamp % 60
329 date = datetime.date.today().isoformat()
330
331 q = instance.query
332
333 # Insert rows with timestamps relative to the current time so that the
334 # first retention clause is active.
335 # Two parts are created.
336 q('''
337 INSERT INTO test.graphite (metric, value, timestamp, date, updated)
338 VALUES ('one_min.x1', 100, {timestamp}, '{date}', 1);
339 INSERT INTO test.graphite (metric, value, timestamp, date, updated)
340 VALUES ('one_min.x1', 200, {timestamp}, '{date}', 2);
341 '''.format(timestamp=timestamp, date=date))
342
343 expected1 = '''\
344 one_min.x1 100 {timestamp} {date} 1
345 one_min.x1 200 {timestamp} {date} 2
346 '''.format(timestamp=timestamp, date=date)
347
348 assert TSV(
349 q('SELECT * FROM test.graphite ORDER BY updated')
350 ) == TSV(expected1)
351
352> q('OPTIMIZE TABLE test.graphite')
353
354test_graphite_merge_tree/test.py:70:
355_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
356helpers/cluster.py:436: in query
357 return self.client.query(sql, stdin, timeout, settings, user, ignore_error)
358helpers/client.py:21: in query
359 return self.get_query_request(sql, stdin=stdin, timeout=timeout, settings=settings, user=user, ignore_error=ignore_error).get_answer()
360_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
361
362self = <helpers.client.CommandRequest instance at 0x7f463ebc5290>
363
364 def get_answer(self):
365 self.process.wait()
366 self.stdout_file.seek(0)
367 self.stderr_file.seek(0)
368
369 stdout = self.stdout_file.read()
370 stderr = self.stderr_file.read()
371
372 if self.timer is not None and not self.process_finished_before_timeout and not self.ignore_error:
373 raise QueryTimeoutExceedException('Client timed out!')
374
375 if (self.process.returncode != 0 or stderr) and not self.ignore_error:
376> raise QueryRuntimeException('Client failed! Return code: {}, stderr: {}'.format(self.process.returncode, stderr))
377E QueryRuntimeException: Client failed! Return code: 32, stderr: Error on processing query: OPTIMIZE TABLE test.graphite
378E Code: 32, e.displayText() = DB::Exception: Attempt to read after eof: while receiving packet from 172.20.0.2:9000, Stack trace:
379E
380E 0. /clickhouse(StackTrace::StackTrace()+0x16) [0x6801a96]
381E 1. /clickhouse(DB::Exception::Exception(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&, int)+0x22) [0x2e4a3b2]
382E 2. /clickhouse(DB::throwReadAfterEOF()+0x4d) [0x2e4a41d]
383E 3. /clickhouse(DB::readVarUInt(unsigned long&, DB::ReadBuffer&)+0x345) [0x2e5bfb5]
384E 4. /clickhouse(DB::Connection::receivePacket()+0x400) [0x6051f40]
385E 5. /clickhouse(DB::Client::receiveAndProcessPacket()+0x3c) [0x2eb940c]
386E 6. /clickhouse(DB::Client::receiveResult()+0x190) [0x2ebb4f0]
387E 7. /clickhouse(DB::Client::processSingleQuery(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&, std::shared_ptr<DB::IAST>)+0x402) [0x2ebbf32]
388E 8. /clickhouse(DB::Client::process(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&)+0x342) [0x2ebc742]
389E 9. /clickhouse(DB::Client::mainImpl()+0x10b5) [0x2ebf145]
390E 10. /clickhouse(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&)+0x28) [0x2e318f8]
391E 11. /clickhouse(Poco::Util::Application::run()+0x35) [0x693d905]
392E 12. /clickhouse(mainEntryClickHouseClient(int, char**)+0x8e0) [0x2e760b0]
393E 13. /clickhouse(main+0x1df) [0x2e2a24f]
394E 14. /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xe7) [0x7fa7094c8b97]
395E 15. /clickhouse(_start+0x2a) [0x2e4666a]
396
397helpers/client.py:89: QueryRuntimeException
398---------------------------- Captured stdout setup -----------------------------
399latest: Pulling from yandex/clickhouse-integration-test
400Digest: sha256:158b6cef108a9d87354e1195faab4d286196a07e1664130126e031e48483b2bd
401Status: Downloaded newer image for yandex/clickhouse-integration-test:latest
402---------------------------- Captured stderr setup -----------------------------
403Removing network clickhouse_default
404Network clickhouse_default not found.
405Some networks were defined but are not used by any service: app_net
406Creating network "roottestgraphitemergetree_default" with the default driver
407Pulling instance (yandex/clickhouse-integration-test:)...
408Creating roottestgraphitemergetree_instance_1 ... done
409
410=============================== warnings summary ===============================
411/usr/local/lib/python2.7/dist-packages/psycopg2/__init__.py:144
412 /usr/local/lib/python2.7/dist-packages/psycopg2/__init__.py:144: UserWarning: The psycopg2 wheel package will be renamed from release 2.8; in order to keep installing from binary please use "pip install psycopg2-binary" instead. For details see: <http://initd.org/psycopg/docs/install.html#binary-install-from-pypi>.
413 """)
414
415-- Docs: https://docs.pytest.org/en/latest/warnings.html
416================ 1 failed, 1 warnings, 7 error in 90.16 seconds ================
417clickhouse_integration_tests
418Traceback (most recent call last):
419 File "runner", line 99, in <module>
420 subprocess.check_call(cmd, shell=True)
421 File "/usr/lib/python2.7/subprocess.py", line 190, in check_call
422 raise CalledProcessError(retcode, cmd)
423subprocess.CalledProcessError: Command 'docker run --net=host --name clickhouse_integration_tests --user=root --privileged --volume=/usr/bin/clickhouse-odbc-bridge:/clickhouse-odbc-bridge --volume=/home/felixoid/OPT/Felixoid/github/yandex/ClickHouse/build/dbms/programs/clickhouse:/clickhouse --volume=/home/felixoid/OPT/Felixoid/github/yandex/ClickHouse/dbms/programs/server:/clickhouse-config --volume=/home/felixoid/OPT/Felixoid/github/yandex/ClickHouse:/ClickHouse -e PYTEST_OPTS='test_graphite_merge_tree' yandex/clickhouse-integration-tests-runner ' returned non-zero exit status 1