Bug #123931 for ClickHouse: Enter query of "SELECT CAST(1 AS Enum8);" brings down clickhouse-server

Thu Dec 21 18:44:02 2017 yigang.fu [...] clover.com - Ticket created

Subject:	Enter query of "SELECT CAST(1 AS Enum8);" brings down clickhouse-server
Date:	Thu, 21 Dec 2017 15:43:51 -0800
To:	bug-ClickHouse [...] rt.cpan.org
From:	Yigang Fu <yigang.fu [...] clover.com>

We installed clickhouse in docker container on a Centos 7 server. Entering query "SELECT CAST(1 AS Enum8)" in clickhouse-client brings down the clickhouse-server in container. It is also noticed that a clickhouse-server daemon is started directly. clickhouse-client -m ClickHouse client version 1.1.54310. Connecting to localhost:9000. Connected to ClickHouse server version 1.1.54310. :) select cast(1 as Enum8); SELECT CAST(1 AS Enum8) Exception on client: Code: 32. DB::Exception: Attempt to read after eof: while receiving packet from localhost:9000, 127.0.0.1 Connecting to localhost:9000. Code: 210. DB::NetException: Connection reset by peer: while reading from socket (127.0.0.1:9000) [james.fu@p933.dev ~]$ ps -ef | grep clickhouse clickho+ 223057 1 0 07:00 ? 00:00:00 clickhouse-server --daemon --pid-file=/var/run/clickhouse-server/clickhouse-server.pid --config-file=/etc/clickhouse-server/config.xml james.fu 223857 205065 0 07:00 pts/0 00:00:00 grep --color=auto clickhouse Normally: ps -ef | grep clickhouse james.fu 209491 194928 0 23:42 pts/0 00:00:00 grep --color=auto *clickhouse* 105 982153 982136 0 19:26 ? 00:00:17 /usr/bin/*clickhouse*-server --config=/etc/*clickhouse*-server/config.xml Is there anyone else having sam eissue? Thanks. James

Fri Dec 22 01:59:10 2017 ELCAMLOST [...] cpan.org - Correspondence added

Hi! This issue is not related with Perl Module. You should post it in clickhouse bug tracker on github https://github.com/yandex/ClickHouse/issues On Thu Dec 21 18:44:02 2017, yigang.fu@clover.com wrote: Show quoted text

> We installed clickhouse in docker container on a Centos 7 server. Entering > query "SELECT CAST(1 AS Enum8)" in clickhouse-client brings down the > clickhouse-server in container. It is also noticed that a clickhouse-server > daemon is started directly. > > clickhouse-client -m > ClickHouse client version 1.1.54310. > Connecting to localhost:9000. > Connected to ClickHouse server version 1.1.54310. > :) select cast(1 as Enum8); > > SELECT CAST(1 AS Enum8) > > Exception on client: > Code: 32. DB::Exception: Attempt to read after eof: while receiving packet > from localhost:9000, 127.0.0.1 > > Connecting to localhost:9000. > Code: 210. DB::NetException: Connection reset by peer: while reading from > socket (127.0.0.1:9000) > > [james.fu@p933.dev ~]$ ps -ef | grep clickhouse > clickho+ 223057 1 0 07:00 ? 00:00:00 clickhouse-server --daemon > --pid-file=/var/run/clickhouse-server/clickhouse-server.pid > --config-file=/etc/clickhouse-server/config.xml > james.fu 223857 205065 0 07:00 pts/0 00:00:00 grep --color=auto clickhouse > > > Normally: > > ps -ef | grep clickhouse > > james.fu 209491 194928 0 23:42 pts/0 00:00:00 grep --color=auto > *clickhouse* > > 105 982153 982136 0 19:26 ? 00:00:17 > /usr/bin/*clickhouse*-server > --config=/etc/*clickhouse*-server/config.xml > > > Is there anyone else having sam eissue? > > > Thanks. > > > James

Fri Dec 22 01:59:11 2017 The RT System itself - Status changed from 'new' to 'open'

Fri Dec 22 01:59:11 2017 ELCAMLOST [...] cpan.org - Status changed from 'open' to 'rejected'