Can't create replicated table without ZooKeeper.

[Олег Облеухов]

Hello, I have a problem:

:) CREATE TABLE default.graphite ( Path String,  Value Float64,  Time UInt32,  Date Date,  Timestamp UInt32) ENGINE = ReplicatedMergeTree('/clickhouse_perftest/tables/03/graphite', 'r1', Date, (Path, Time), 8192);

CREATE TABLE default.graphite

(

    Path String,

    Value Float64,

    Time UInt32,

    Date Date,

    Timestamp UInt32

) ENGINE = ReplicatedMergeTree('/clickhouse_perftest/tables/03/graphite', 'r1', Date, (Path, Time), 8192)

Received exception from server:

Code: 225. DB::Exception: Received from localhost:9000, 127.0.0.1. DB::Exception: Can't create replicated table without ZooKeeper.

Я уже конфиг и так и сяк крутил, не понимаю:

        <zookeeper incl="zookeeper-servers" optional="true" />

        <zookeeper-servers>

            <node>

                <host>zk01</host>

                <port>2181</port>

            </node>

            <node>

                <host>zk02</host>

                <port>2181</port>

            </node>

            <node>

                <host>zk03</host>

                <port>2181</port>

            </node>

        </zookeeper-servers>

root@staging-graphite-db03:~# telnet zk03 2181

Trying 10.21.2.6...

Connected to zk03

Escape character is '^]'.

^]

telnet> Connection closed.

root@staging-graphite-db03:~# telnet zk02 2181

Trying 10.21.2.5...

Connected to zk02

Escape character is '^]'.

^]

telnet> Connection closed.

root@staging-graphite-db03:~# telnet zk01 2181

Trying 10.21.2.4...

Connected to zk01

Escape character is '^]'.

^]

telnet> Connection closed.

[Олег Облеухов]

Ok, the answer is quite simple:

Config <zookeeper-servers> needs to be defined in /etc/metrika.xml or I need to use <zookeeper> instead.

четверг, 4 августа 2016 г., 23:34:01 UTC+2 пользователь Олег Облеухов написал: