bash -x ./reproduce.sh
successfull drop table
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 && \ |
version: "3" | |
services: | |
clickhouse: | |
image: yandex/clickhouse-server:${CLICKHOUSE_VERSION:-latest} |
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: |
. { | |
hosts /etc/example.com { | |
reload "200ms" | |
fallthrough | |
} | |
forward . 127.0.0.11 | |
log | |
} |
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
2020.08.24 13:44:17.013175 [ 1 ] {} <Information> : Starting ClickHouse 20.4.9.110 with revision 54434, PID 1 | |
2020.08.24 13:44:17.019023 [ 1 ] {} <Information> Application: starting up | |
2020.08.24 13:44:17.028135 [ 1 ] {} <Debug> Application: rlimit on number of file descriptors is 1048576 | |
2020.08.24 13:44:17.028193 [ 1 ] {} <Debug> Application: Initializing DateLUT. | |
2020.08.24 13:44:17.028247 [ 1 ] {} <Debug> Application: Setting up /var/lib/clickhouse/tmp/ to store temporary data in it | |
2020.08.24 13:44:17.028938 [ 1 ] {} <Debug> Application: Configuration parameter 'interserver_http_host' doesn't exist or exists and empty. Will use 'chi-test-cluster-for-alerts-default-0-0-0.chi-test-cluster-for-alerts-default-0-0.test.svc.cluster.local' as replica host. | |
2020.08.24 13:44:17.033778 [ 1 ] {} <Debug> ConfigReloader: Loading config '/etc/clickhouse-server/users.xml' | |
2020.08.24 13:44:17.041703 [ 1 ] {} <Warning> Access(disk): File /var/lib/clickhouse/access/users.list doesn't exist |
steps to reproduce
docker-compose down
docker-compose run clickhouse