GJ8WSUhV

1➜  integration git:(8e1d6edc0c) ✗ ./runner --binary $HOME/ClickHouse/build/dbms/programs/clickhouse --bridge-binary $HOME/ClickHouse/build/dbms/programs/clickhouse-odbc-bridge --configs-dir $HOME/ClickHouse/dbms/programs/server/ 'test_odbc_interaction -ss'
2clickhouse_integration_tests_volume
3Start tests
4============================= test session starts =============================
5platform linux2 -- Python 2.7.15+, pytest-4.6.3, py-1.8.0, pluggy-0.12.0
6rootdir: /ClickHouse/dbms/tests/integration, inifile: pytest.ini
7plugins: timeout-1.3.3
8timeout: 600.0s
9timeout method: signal
10timeout func_only: False
11collected 8 items                                                             
12
13test_odbc_interaction/test.py Removing network clickhouse_default
14WARNING: Network clickhouse_default not found.
15Removing instances dir /ClickHouse/dbms/tests/integration/test_odbc_interaction/_instances
16Creating network "roottestodbcinteraction_default" with the default driver
17Creating roottestodbcinteraction_mysql1_1 ... done
18Can't connect to MySQL (2013, 'Lost connection to MySQL server during query')
19Can't connect to MySQL (2013, 'Lost connection to MySQL server during query')
20Can't connect to MySQL (2013, 'Lost connection to MySQL server during query')
21Can't connect to MySQL (2013, 'Lost connection to MySQL server during query')
22Can't connect to MySQL (2013, 'Lost connection to MySQL server during query')
23Can't connect to MySQL (2013, 'Lost connection to MySQL server during query')
24Can't connect to MySQL (2013, 'Lost connection to MySQL server during query')
25Can't connect to MySQL (2013, 'Lost connection to MySQL server during query')
26Can't connect to MySQL (2013, 'Lost connection to MySQL server during query')
27Can't connect to MySQL (2013, 'Lost connection to MySQL server during query')
28Can't connect to MySQL (2013, 'Lost connection to MySQL server during query')
29Can't connect to MySQL (2013, 'Lost connection to MySQL server during query')
30Can't connect to MySQL (2013, 'Lost connection to MySQL server during query')
31Can't connect to MySQL (2013, 'Lost connection to MySQL server during query')
32Can't connect to MySQL (2013, 'Lost connection to MySQL server during query')
33Can't connect to MySQL (2013, 'Lost connection to MySQL server during query')
34Can't connect to MySQL (2013, 'Lost connection to MySQL server during query')
35Can't connect to MySQL (2013, 'Lost connection to MySQL server during query')
36Can't connect to MySQL (2013, 'Lost connection to MySQL server during query')
37Can't connect to MySQL (2013, 'Lost connection to MySQL server during query')
38Can't connect to MySQL (2013, 'Lost connection to MySQL server during query')
39Can't connect to MySQL (2013, 'Lost connection to MySQL server during query')
40Mysql Started
41WARNING: Found orphan containers (roottestodbcinteraction_mysql1_1) for this project. If you removed or renamed this service in your compose file, you can run this command with the --remove-orphans flag to clean it up.
42Creating roottestodbcinteraction_postgres1_1 ... done
43Can't connect to Postgres server closed the connection unexpectedly
44	This probably means the server terminated abnormally
45	before or while processing the request.
46
47Can't connect to Postgres server closed the connection unexpectedly
48	This probably means the server terminated abnormally
49	before or while processing the request.
50
51Can't connect to Postgres server closed the connection unexpectedly
52	This probably means the server terminated abnormally
53	before or while processing the request.
54
55Postgres Started
56Starting roottestodbcinteraction_mysql1_1    ... done
57Starting roottestodbcinteraction_postgres1_1 ... done
58Creating roottestodbcinteraction_node1_1     ... done
59Timed out while waiting for instance `node1' with ip address 172.18.0.4 to start. Container status: running
60Killing roottestodbcinteraction_node1_1     ... done
61Killing roottestodbcinteraction_postgres1_1 ... done
62Killing roottestodbcinteraction_mysql1_1    ... done
63Removing roottestodbcinteraction_node1_1     ... done
64Removing roottestodbcinteraction_postgres1_1 ... done
65Removing roottestodbcinteraction_mysql1_1    ... done
66Removing network roottestodbcinteraction_default
67EEEEEEEE
68
69=================================== ERRORS ====================================
70______________ ERROR at setup of test_mysql_simple_select_works _______________
71
72    @pytest.fixture(scope="module")
73    def started_cluster():
74        try:
75            cluster.start()
76            sqlite_db = node1.odbc_drivers["SQLite3"]["Database"]
77    
78            print "sqlite data received"
79            node1.exec_in_container(["bash", "-c", "echo 'CREATE TABLE t1(x INTEGER PRIMARY KEY ASC, y, z);' | sqlite3 {}".format(sqlite_db)], privileged=True, user='root')
80            node1.exec_in_container(["bash", "-c", "echo 'CREATE TABLE t2(X INTEGER PRIMARY KEY ASC, Y, Z);' | sqlite3 {}".format(sqlite_db)], privileged=True, user='root')
81            node1.exec_in_container(["bash", "-c", "echo 'CREATE TABLE t3(X INTEGER PRIMARY KEY ASC, Y, Z);' | sqlite3 {}".format(sqlite_db)], privileged=True, user='root')
82            node1.exec_in_container(["bash", "-c", "echo 'CREATE TABLE t4(X INTEGER PRIMARY KEY ASC, Y, Z);' | sqlite3 {}".format(sqlite_db)], privileged=True, user='root')
83            print "sqlite tables created"
84            mysql_conn = get_mysql_conn()
85            print "mysql connection received"
86            ## create mysql db and table
87            create_mysql_db(mysql_conn, 'clickhouse')
88            print "mysql database created"
89    
90            postgres_conn = get_postgres_conn()
91            print "postgres connection received"
92    
93            create_postgres_db(postgres_conn, 'clickhouse')
94            print "postgres db created"
95    
96            cursor = postgres_conn.cursor()
97            cursor.execute("create table if not exists clickhouse.test_table (column1 int primary key, column2 varchar(40) not null)")
98    
99            yield cluster
100    
101        except Exception as ex:
102            print(ex)
103>           raise ex
104E           Exception: Timed out while waiting for instance `node1' with ip address 172.18.0.4 to start. Container status: running
105
106test_odbc_interaction/test.py:79: Exception
107_________ ERROR at setup of test_sqlite_simple_select_function_works __________
108
109    @pytest.fixture(scope="module")
110    def started_cluster():
111        try:
112            cluster.start()
113            sqlite_db = node1.odbc_drivers["SQLite3"]["Database"]
114    
115            print "sqlite data received"
116            node1.exec_in_container(["bash", "-c", "echo 'CREATE TABLE t1(x INTEGER PRIMARY KEY ASC, y, z);' | sqlite3 {}".format(sqlite_db)], privileged=True, user='root')
117            node1.exec_in_container(["bash", "-c", "echo 'CREATE TABLE t2(X INTEGER PRIMARY KEY ASC, Y, Z);' | sqlite3 {}".format(sqlite_db)], privileged=True, user='root')
118            node1.exec_in_container(["bash", "-c", "echo 'CREATE TABLE t3(X INTEGER PRIMARY KEY ASC, Y, Z);' | sqlite3 {}".format(sqlite_db)], privileged=True, user='root')
119            node1.exec_in_container(["bash", "-c", "echo 'CREATE TABLE t4(X INTEGER PRIMARY KEY ASC, Y, Z);' | sqlite3 {}".format(sqlite_db)], privileged=True, user='root')
120            print "sqlite tables created"
121            mysql_conn = get_mysql_conn()
122            print "mysql connection received"
123            ## create mysql db and table
124            create_mysql_db(mysql_conn, 'clickhouse')
125            print "mysql database created"
126    
127            postgres_conn = get_postgres_conn()
128            print "postgres connection received"
129    
130            create_postgres_db(postgres_conn, 'clickhouse')
131            print "postgres db created"
132    
133            cursor = postgres_conn.cursor()
134            cursor.execute("create table if not exists clickhouse.test_table (column1 int primary key, column2 varchar(40) not null)")
135    
136            yield cluster
137    
138        except Exception as ex:
139            print(ex)
140>           raise ex
141E           Exception: Timed out while waiting for instance `node1' with ip address 172.18.0.4 to start. Container status: running
142
143test_odbc_interaction/test.py:79: Exception
144__________ ERROR at setup of test_sqlite_simple_select_storage_works __________
145
146    @pytest.fixture(scope="module")
147    def started_cluster():
148        try:
149            cluster.start()
150            sqlite_db = node1.odbc_drivers["SQLite3"]["Database"]
151    
152            print "sqlite data received"
153            node1.exec_in_container(["bash", "-c", "echo 'CREATE TABLE t1(x INTEGER PRIMARY KEY ASC, y, z);' | sqlite3 {}".format(sqlite_db)], privileged=True, user='root')
154            node1.exec_in_container(["bash", "-c", "echo 'CREATE TABLE t2(X INTEGER PRIMARY KEY ASC, Y, Z);' | sqlite3 {}".format(sqlite_db)], privileged=True, user='root')
155            node1.exec_in_container(["bash", "-c", "echo 'CREATE TABLE t3(X INTEGER PRIMARY KEY ASC, Y, Z);' | sqlite3 {}".format(sqlite_db)], privileged=True, user='root')
156            node1.exec_in_container(["bash", "-c", "echo 'CREATE TABLE t4(X INTEGER PRIMARY KEY ASC, Y, Z);' | sqlite3 {}".format(sqlite_db)], privileged=True, user='root')
157            print "sqlite tables created"
158            mysql_conn = get_mysql_conn()
159            print "mysql connection received"
160            ## create mysql db and table
161            create_mysql_db(mysql_conn, 'clickhouse')
162            print "mysql database created"
163    
164            postgres_conn = get_postgres_conn()
165            print "postgres connection received"
166    
167            create_postgres_db(postgres_conn, 'clickhouse')
168            print "postgres db created"
169    
170            cursor = postgres_conn.cursor()
171            cursor.execute("create table if not exists clickhouse.test_table (column1 int primary key, column2 varchar(40) not null)")
172    
173            yield cluster
174    
175        except Exception as ex:
176            print(ex)
177>           raise ex
178E           Exception: Timed out while waiting for instance `node1' with ip address 172.18.0.4 to start. Container status: running
179
180test_odbc_interaction/test.py:79: Exception
181____________ ERROR at setup of test_sqlite_odbc_hashed_dictionary _____________
182
183    @pytest.fixture(scope="module")
184    def started_cluster():
185        try:
186            cluster.start()
187            sqlite_db = node1.odbc_drivers["SQLite3"]["Database"]
188    
189            print "sqlite data received"
190            node1.exec_in_container(["bash", "-c", "echo 'CREATE TABLE t1(x INTEGER PRIMARY KEY ASC, y, z);' | sqlite3 {}".format(sqlite_db)], privileged=True, user='root')
191            node1.exec_in_container(["bash", "-c", "echo 'CREATE TABLE t2(X INTEGER PRIMARY KEY ASC, Y, Z);' | sqlite3 {}".format(sqlite_db)], privileged=True, user='root')
192            node1.exec_in_container(["bash", "-c", "echo 'CREATE TABLE t3(X INTEGER PRIMARY KEY ASC, Y, Z);' | sqlite3 {}".format(sqlite_db)], privileged=True, user='root')
193            node1.exec_in_container(["bash", "-c", "echo 'CREATE TABLE t4(X INTEGER PRIMARY KEY ASC, Y, Z);' | sqlite3 {}".format(sqlite_db)], privileged=True, user='root')
194            print "sqlite tables created"
195            mysql_conn = get_mysql_conn()
196            print "mysql connection received"
197            ## create mysql db and table
198            create_mysql_db(mysql_conn, 'clickhouse')
199            print "mysql database created"
200    
201            postgres_conn = get_postgres_conn()
202            print "postgres connection received"
203    
204            create_postgres_db(postgres_conn, 'clickhouse')
205            print "postgres db created"
206    
207            cursor = postgres_conn.cursor()
208            cursor.execute("create table if not exists clickhouse.test_table (column1 int primary key, column2 varchar(40) not null)")
209    
210            yield cluster
211    
212        except Exception as ex:
213            print(ex)
214>           raise ex
215E           Exception: Timed out while waiting for instance `node1' with ip address 172.18.0.4 to start. Container status: running
216
217test_odbc_interaction/test.py:79: Exception
218____________ ERROR at setup of test_sqlite_odbc_cached_dictionary _____________
219
220    @pytest.fixture(scope="module")
221    def started_cluster():
222        try:
223            cluster.start()
224            sqlite_db = node1.odbc_drivers["SQLite3"]["Database"]
225    
226            print "sqlite data received"
227            node1.exec_in_container(["bash", "-c", "echo 'CREATE TABLE t1(x INTEGER PRIMARY KEY ASC, y, z);' | sqlite3 {}".format(sqlite_db)], privileged=True, user='root')
228            node1.exec_in_container(["bash", "-c", "echo 'CREATE TABLE t2(X INTEGER PRIMARY KEY ASC, Y, Z);' | sqlite3 {}".format(sqlite_db)], privileged=True, user='root')
229            node1.exec_in_container(["bash", "-c", "echo 'CREATE TABLE t3(X INTEGER PRIMARY KEY ASC, Y, Z);' | sqlite3 {}".format(sqlite_db)], privileged=True, user='root')
230            node1.exec_in_container(["bash", "-c", "echo 'CREATE TABLE t4(X INTEGER PRIMARY KEY ASC, Y, Z);' | sqlite3 {}".format(sqlite_db)], privileged=True, user='root')
231            print "sqlite tables created"
232            mysql_conn = get_mysql_conn()
233            print "mysql connection received"
234            ## create mysql db and table
235            create_mysql_db(mysql_conn, 'clickhouse')
236            print "mysql database created"
237    
238            postgres_conn = get_postgres_conn()
239            print "postgres connection received"
240    
241            create_postgres_db(postgres_conn, 'clickhouse')
242            print "postgres db created"
243    
244            cursor = postgres_conn.cursor()
245            cursor.execute("create table if not exists clickhouse.test_table (column1 int primary key, column2 varchar(40) not null)")
246    
247            yield cluster
248    
249        except Exception as ex:
250            print(ex)
251>           raise ex
252E           Exception: Timed out while waiting for instance `node1' with ip address 172.18.0.4 to start. Container status: running
253
254test_odbc_interaction/test.py:79: Exception
255_____ ERROR at setup of test_postgres_odbc_hached_dictionary_with_schema ______
256
257    @pytest.fixture(scope="module")
258    def started_cluster():
259        try:
260            cluster.start()
261            sqlite_db = node1.odbc_drivers["SQLite3"]["Database"]
262    
263            print "sqlite data received"
264            node1.exec_in_container(["bash", "-c", "echo 'CREATE TABLE t1(x INTEGER PRIMARY KEY ASC, y, z);' | sqlite3 {}".format(sqlite_db)], privileged=True, user='root')
265            node1.exec_in_container(["bash", "-c", "echo 'CREATE TABLE t2(X INTEGER PRIMARY KEY ASC, Y, Z);' | sqlite3 {}".format(sqlite_db)], privileged=True, user='root')
266            node1.exec_in_container(["bash", "-c", "echo 'CREATE TABLE t3(X INTEGER PRIMARY KEY ASC, Y, Z);' | sqlite3 {}".format(sqlite_db)], privileged=True, user='root')
267            node1.exec_in_container(["bash", "-c", "echo 'CREATE TABLE t4(X INTEGER PRIMARY KEY ASC, Y, Z);' | sqlite3 {}".format(sqlite_db)], privileged=True, user='root')
268            print "sqlite tables created"
269            mysql_conn = get_mysql_conn()
270            print "mysql connection received"
271            ## create mysql db and table
272            create_mysql_db(mysql_conn, 'clickhouse')
273            print "mysql database created"
274    
275            postgres_conn = get_postgres_conn()
276            print "postgres connection received"
277    
278            create_postgres_db(postgres_conn, 'clickhouse')
279            print "postgres db created"
280    
281            cursor = postgres_conn.cursor()
282            cursor.execute("create table if not exists clickhouse.test_table (column1 int primary key, column2 varchar(40) not null)")
283    
284            yield cluster
285    
286        except Exception as ex:
287            print(ex)
288>           raise ex
289E           Exception: Timed out while waiting for instance `node1' with ip address 172.18.0.4 to start. Container status: running
290
291test_odbc_interaction/test.py:79: Exception
292_ ERROR at setup of test_postgres_odbc_hached_dictionary_no_tty_pipe_overflow _
293
294    @pytest.fixture(scope="module")
295    def started_cluster():
296        try:
297            cluster.start()
298            sqlite_db = node1.odbc_drivers["SQLite3"]["Database"]
299    
300            print "sqlite data received"
301            node1.exec_in_container(["bash", "-c", "echo 'CREATE TABLE t1(x INTEGER PRIMARY KEY ASC, y, z);' | sqlite3 {}".format(sqlite_db)], privileged=True, user='root')
302            node1.exec_in_container(["bash", "-c", "echo 'CREATE TABLE t2(X INTEGER PRIMARY KEY ASC, Y, Z);' | sqlite3 {}".format(sqlite_db)], privileged=True, user='root')
303            node1.exec_in_container(["bash", "-c", "echo 'CREATE TABLE t3(X INTEGER PRIMARY KEY ASC, Y, Z);' | sqlite3 {}".format(sqlite_db)], privileged=True, user='root')
304            node1.exec_in_container(["bash", "-c", "echo 'CREATE TABLE t4(X INTEGER PRIMARY KEY ASC, Y, Z);' | sqlite3 {}".format(sqlite_db)], privileged=True, user='root')
305            print "sqlite tables created"
306            mysql_conn = get_mysql_conn()
307            print "mysql connection received"
308            ## create mysql db and table
309            create_mysql_db(mysql_conn, 'clickhouse')
310            print "mysql database created"
311    
312            postgres_conn = get_postgres_conn()
313            print "postgres connection received"
314    
315            create_postgres_db(postgres_conn, 'clickhouse')
316            print "postgres db created"
317    
318            cursor = postgres_conn.cursor()
319            cursor.execute("create table if not exists clickhouse.test_table (column1 int primary key, column2 varchar(40) not null)")
320    
321            yield cluster
322    
323        except Exception as ex:
324            print(ex)
325>           raise ex
326E           Exception: Timed out while waiting for instance `node1' with ip address 172.18.0.4 to start. Container status: running
327
328test_odbc_interaction/test.py:79: Exception
329_______________ ERROR at setup of test_bridge_dies_with_parent ________________
330
331    @pytest.fixture(scope="module")
332    def started_cluster():
333        try:
334            cluster.start()
335            sqlite_db = node1.odbc_drivers["SQLite3"]["Database"]
336    
337            print "sqlite data received"
338            node1.exec_in_container(["bash", "-c", "echo 'CREATE TABLE t1(x INTEGER PRIMARY KEY ASC, y, z);' | sqlite3 {}".format(sqlite_db)], privileged=True, user='root')
339            node1.exec_in_container(["bash", "-c", "echo 'CREATE TABLE t2(X INTEGER PRIMARY KEY ASC, Y, Z);' | sqlite3 {}".format(sqlite_db)], privileged=True, user='root')
340            node1.exec_in_container(["bash", "-c", "echo 'CREATE TABLE t3(X INTEGER PRIMARY KEY ASC, Y, Z);' | sqlite3 {}".format(sqlite_db)], privileged=True, user='root')
341            node1.exec_in_container(["bash", "-c", "echo 'CREATE TABLE t4(X INTEGER PRIMARY KEY ASC, Y, Z);' | sqlite3 {}".format(sqlite_db)], privileged=True, user='root')
342            print "sqlite tables created"
343            mysql_conn = get_mysql_conn()
344            print "mysql connection received"
345            ## create mysql db and table
346            create_mysql_db(mysql_conn, 'clickhouse')
347            print "mysql database created"
348    
349            postgres_conn = get_postgres_conn()
350            print "postgres connection received"
351    
352            create_postgres_db(postgres_conn, 'clickhouse')
353            print "postgres db created"
354    
355            cursor = postgres_conn.cursor()
356            cursor.execute("create table if not exists clickhouse.test_table (column1 int primary key, column2 varchar(40) not null)")
357    
358            yield cluster
359    
360        except Exception as ex:
361            print(ex)
362>           raise ex
363E           Exception: Timed out while waiting for instance `node1' with ip address 172.18.0.4 to start. Container status: running
364
365test_odbc_interaction/test.py:79: Exception
366============================== warnings summary ===============================
367/usr/local/lib/python2.7/dist-packages/psycopg2/__init__.py:144
368  /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>.
369    """)
370
371-- Docs: https://docs.pytest.org/en/latest/warnings.html
372==================== 1 warnings, 8 error in 36.09 seconds =====================
373Traceback (most recent call last):
374  File "./runner", line 110, in <module>
375    subprocess.check_call(cmd, shell=True)
376  File "/usr/lib/python3.7/subprocess.py", line 347, in check_call
377    raise CalledProcessError(retcode, cmd)
378subprocess.CalledProcessError: Command 'docker run --net=host -it --rm --name clickhouse_integration_tests --privileged --volume=/home/val/ClickHouse/build/dbms/programs/clickhouse-odbc-bridge:/clickhouse-odbc-bridge --volume=/home/val/ClickHouse/build/dbms/programs/clickhouse:/clickhouse         --volume=/home/val/ClickHouse/dbms/programs/server/:/clickhouse-config --volume=/home/val/ClickHouse:/ClickHouse --volume=clickhouse_integration_tests_volume:/var/lib/docker -e PYTEST_OPTS='test_odbc_interaction -ss' yandex/clickhouse-integration-tests-runner ' returned non-zero exit status 1.