Skip to content

fix

fix #8

GitHub Actions / JUnit Test Report failed Jul 5, 2023 in 0s

8 tests run, 7 passed, 0 skipped, 1 failed.

Annotations

Check failure on line 1 in ch-monitoring tool

See this annotation in the file changed.

@github-actions github-actions / JUnit Test Report

ch-monitoring tool.Check Geobase

408 Client Error: Request Time-out for url: http://127.0.0.1:32792/?wait_end_of_query=1&query=CREATE+DATABASE+IF+NOT+EXISTS+test+ON+CLUSTER+%27cluster%27
Raw output
Failing step: Given we have executed queries on clickhouse01 ... failed in 5.347s
  """
  CREATE DATABASE IF NOT EXISTS test ON CLUSTER 'cluster';
  
  CREATE TABLE IF NOT EXISTS test.table_01 ON CLUSTER 'cluster' (n Int32)
  ENGINE = ReplicatedMergeTree('/tables/table_01', '{replica}') PARTITION BY n ORDER BY n;
  
  CREATE TABLE IF NOT EXISTS test.dtable_01 ON CLUSTER 'cluster' AS test.table_01
  ENGINE = Distributed('cluster', 'test', 'table_01', n);
  
  INSERT INTO test.dtable_01 (n) SELECT number FROM system.numbers LIMIT 10;
  
  CREATE TABLE IF NOT EXISTS test.test_unfreeze (id int, name String) ENGINE=MergeTree() ORDER BY id SETTINGS storage_policy='object_storage';
  INSERT INTO test.test_unfreeze VALUES(5, 'hello');
  """
Location: features/monrun.feature:10
Traceback (most recent call last):
  File "/opt/hostedtoolcache/Python/3.10.12/x64/lib/python3.10/site-packages/behave/model.py", line 1329, in run
    match.run(runner.context)
  File "/opt/hostedtoolcache/Python/3.10.12/x64/lib/python3.10/site-packages/behave/matchers.py", line 98, in run
    self.func(context, *args, **kwargs)
  File "steps/clickhouse.py", line 37, in step_clickhouse_queries
    ch_client.execute(query)
  File "/home/runner/work/ch-tools/ch-tools/tests/modules/clickhouse.py", line 44, in execute
    self._query("POST", query=query)
  File "/home/runner/work/ch-tools/ch-tools/tests/modules/clickhouse.py", line 157, in _query
    response.raise_for_status()
  File "/opt/hostedtoolcache/Python/3.10.12/x64/lib/python3.10/site-packages/requests/models.py", line 1021, in raise_for_status
    raise HTTPError(http_error_msg, response=self)
requests.exceptions.HTTPError: 408 Client Error: Request Time-out for url: http://127.0.0.1:32792/?wait_end_of_query=1&query=CREATE+DATABASE+IF+NOT+EXISTS+test+ON+CLUSTER+%27cluster%27

Captured logging:
INFO:kazoo.client:Connecting to 127.0.0.1(127.0.0.1):32787, use_ssl: False
WARNING:kazoo.client:Connection dropped: socket connection error: Connection reset by peer
INFO:kazoo.client:Connecting to 127.0.0.1(127.0.0.1):32787, use_ssl: False
WARNING:kazoo.client:Connection dropped: socket connection error: Connection reset by peer
INFO:kazoo.client:Connecting to 127.0.0.1(127.0.0.1):32787, use_ssl: False
WARNING:kazoo.client:Connection dropped: socket connection broken
INFO:kazoo.client:Connecting to 127.0.0.1(127.0.0.1):32787, use_ssl: False
WARNING:kazoo.client:Connection dropped: socket connection broken
INFO:kazoo.client:Connecting to 127.0.0.1(127.0.0.1):32787, use_ssl: False
WARNING:kazoo.client:Connection dropped: socket connection error: Connection reset by peer
INFO:kazoo.client:Connecting to 127.0.0.1(127.0.0.1):32787, use_ssl: False
INFO:kazoo.client:Zookeeper connection established, state: CONNECTED
INFO:kazoo.client:Closing connection to 127.0.0.1:32787
INFO:kazoo.client:Zookeeper session closed, state: CLOSED
CRITICAL:root:Error while performing request: Code: 159. DB::Exception: Watching task /clickhouse/task_queue/ddl/query-0000000000 is executing longer than distributed_ddl_task_timeout (=5) seconds. There are 1 unfinished hosts (0 of them are currently active), they are going to execute the query in background. (TIMEOUT_EXCEEDED) (version 23.6.1.1524 (official build))