Slach

howto install this example?

mkdir -p /opt/clikchouse-backup-diff/
git clone https://gist.github.com/d6390005975b9643344e9ee935fa882a /opt/clikchouse-backup-diff/
chmod +x /opt/clikchouse-backup-diff/*.sh
cp -fv /opt/clikchouse-backup-diff/cron_example.txt /etc/cron.d/clickhouse_backup_diff
cp -fv /opt/clikchouse-backup-diff/clickhouse-backup-config-example.yml /etc/clickhouse-backup/config.yml

Slach

FROM yandex/clickhouse-server:${CLICKHOUSE_VERSION:-latest}

USER root
ARG UBUNTU_NAME=focal
ARG UBUNTU_VERSION=20.04

RUN echo "Begin ODBC install" && \
    #MySQL repo
    wget -qO- "http://keyserver.ubuntu.com/pks/lookup?op=get&search=0xa4a9406876fcbd3c456770c88c718d3b5072e1f5" | apt-key add - && \
    echo "deb http://repo.mysql.com/apt/ubuntu/ ${UBUNTU_NAME} mysql-8.0" >/etc/apt/sources.list.d/mysql-oracle.list && \

Slach

version: "3"
services:
  clickhouse:
    image: yandex/clickhouse-server:${CLICKHOUSE_VERSION:-latest}

Slach

version: "3"
services:
  mysql8:
    image: mysql:${MYSQL_VERSION:-latest}
    environment:
      - MYSQL_ALLOW_EMPTY_PASSWORD=1
    volumes:
      - ./mysql8_table.sql:/docker-entrypoint-initdb.d/mysql8_table.sql
      - ./mysql8_log_queries.conf:/etc/mysql/conf.d/mysql8_log_queries.conf
  clickhouse:

Slach

superset/
superset/clickhouse/
.idea/

Slach

Slach

ClickHouse 21.1.2 DROP TABLE default.test_repl ON CLUSTER 'default' SYNC failed for Atomic

Steps for reproduce

bash -x ./reproduce.sh

Expected Result

successfull drop table

Slach

. {
    hosts /etc/example.com {
        reload "200ms"
        fallthrough
    }
    forward . 127.0.0.11
    log
}

Slach

Steps to reproduce

for v in 20.3 20.4 20.5 20.6 20.7 20.8 20.9 20.10 latest; do CLICKHOUSE_VERSION=$v bash -c "docker-compose down && docker-compose up -d clickhouse && sleep 1 && docker-compose exec clickhouse bash -c 'clickhouse-client -mn < /queries.sql | grep -i bloom'"; done

Slach

Exception raised when we don't have data in table and have dictGet in WHERE clause steps to reproduce

docker-compose up -d
docker-compose exec clickhouse bash -c "clickhouse-client -mn --echo < /var/lib/clickhouse/user_files/success_query.sql"
docker-compose exec clickhouse bash -c "clickhouse-client -mn --echo < /var/lib/clickhouse/user_files/failed_query.sql"
diff failed_query.sql success_query.sql
less clickhouse-server.log