Не стартует сервер под Ubuntu 12
1,000 views
Skip to first unread message
1bitforce
Jun 24, 2016, 2:54:49 AM6/24/16
to ClickHouse
Ubuntu 12 под VirtualBox
При попытке запуска сервера
sudo service clickhouse-server start
получаем сообщение SSE 4.2 instruction set is not supported
При попытке запуска сервера
sudo clickhouse-server --config-file=/etc/clickhouse-server/config.xml
получаем:
Include not found: clickhouse_remote_servers
Include not found: clickhouse_compression
2016.06.24 11:52:00.552 [ 1 ] <Warning> Application: Logging to console
2016.06.24 11:52:00.589 [ 1 ] <Information> : Starting daemon with revision 53981
2016.06.24 11:52:00.589 [ 1 ] <Information> Application: starting up
2016.06.24 11:52:00.590 [ 1 ] <Debug> Application: Set rlimit on number of file descriptors to 4096 (was 1024)
2016.06.24 11:52:00.590 [ 1 ] <Debug> Application: Initializing DateLUT.
2016.06.24 11:52:00.590 [ 1 ] <Trace> Application: Initialized DateLUT.
deterministic_cache: unknown level/typenumber combo (2/1), cannot
deterministic_cache: recognize cache type
2016.06.24 11:52:00.591 [ 1 ] <Debug> Application: Configuration parameter 'interserver_http_host' doesn't exist or exists and empty. Will use 'alex-VirtualBox' as replica host.
2016.06.24 11:52:00.591 [ 1 ] <Debug> UsersConfigReloader: Loading users config
Include not found: networks
Include not found: networks
2016.06.24 11:52:00.593 [ 1 ] <Information> Application: Loading metadata.
2016.06.24 11:52:00.593 [ 1 ] <Information> DatabaseOrdinary (system): Total 0 tables.
2016.06.24 11:52:00.593 [ 1 ] <Information> DatabaseOrdinary (default): Total 0 tables.
2016.06.24 11:52:00.594 [ 1 ] <Debug> Application: Loaded metadata.
2016.06.24 11:52:00.595 [ 1 ] <Debug> Application: Closed all connections.
2016.06.24 11:52:00.595 [ 1 ] <Information> Application: Shutting down storages.
2016.06.24 11:52:00.595 [ 1 ] <Debug> Application: Shutted down storages.
2016.06.24 11:52:00.595 [ 1 ] <Debug> Application: Destroyed global context.
2016.06.24 11:52:02.594 [ 1 ] <Error> Application: DNS error: EAI: -9
2016.06.24 11:52:02.594 [ 1 ] <Information> Application: shutting down
2016.06.24 11:52:02.594 [ 1 ] <Debug> Application: Uninitializing subsystem: Logging Subsystem
Mike Eremin
Jun 24, 2016, 3:38:05 AM6/24/16
to ClickHouse
Прокиньте SSE с хоста в виртуалку
VBoxManage setextradata "Ubuntu" VBoxInternal/CPUM/SSE4.1 1
VBoxManage setextradata "Ubuntu" VBoxInternal/CPUM/SSE4.2 1
VBoxManage setextradata "Ubuntu" VBoxInternal/CPUM/SSE4.1 1
VBoxManage setextradata "Ubuntu" VBoxInternal/CPUM/SSE4.2 1
1bitforce
Jun 24, 2016, 5:31:21 AM6/24/16
to ClickHouse
Обновился до последней версии VirtualBox
переустановил ClickHouse
теперь при попытке запуска сервера
sudo service clickhouse-server start
пишет:
Start clickhouse-server service: No directory, logging in with HOME=/
DONE
Просмотр статуса демона показывает:
clickhouse-server: 1 of 1 processes unexpectedly terminated
При попытке запуска клиентской консоли:
ClickHouse client version 1.1.53981.
Connecting to localhost:9000.
Code: 210. DB::NetException: Connection refused: (localhost:9000, 127.0.0.1)
clickhouse-server.err.log:
2016.06.24 14:15:35.831 [ 1 ] <Error> Application: DNS error: EAI: -9
2016.06.24 14:17:08.393 [ 1 ] <Error> Application: DNS error: EAI: -9
2016.06.24 14:18:54.699 [ 1 ] <Error> Application: DNS error: EAI: -9
2016.06.24 14:20:03.868 [ 1 ] <Error> Application: DNS error: EAI: -9
2016.06.24 14:22:15.722 [ 1 ] <Error> Application: DNS error: EAI: -9
2016.06.24 14:23:37.685 [ 1 ] <Error> Application: DB::Exception: Cannot open file /opt/clickhouse/status, errno: 2, strerror: No such file or directory
clickhouse-server.log:
2016.06.24 14:15:26.066 [ 1 ] <Information> : Starting daemon with revision 53981
2016.06.24 14:15:33.219 [ 1 ] <Information> Application: starting up
2016.06.24 14:15:33.274 [ 1 ] <Debug> Application: rlimit on number of file descriptors is 262144
2016.06.24 14:15:33.274 [ 1 ] <Debug> Application: Initializing DateLUT.
2016.06.24 14:15:33.274 [ 1 ] <Trace> Application: Initialized DateLUT.
2016.06.24 14:15:33.757 [ 1 ] <Debug> Application: Configuration parameter 'interserver_http_host' doesn't exist or exists and empty. Will use 'alex-VirtualBox' as replica host.
2016.06.24 14:15:33.757 [ 1 ] <Debug> UsersConfigReloader: Loading users config
2016.06.24 14:15:33.851 [ 1 ] <Information> Application: Loading metadata.
2016.06.24 14:15:34.138 [ 1 ] <Information> DatabaseOrdinary (system): Total 0 tables.
2016.06.24 14:15:34.141 [ 1 ] <Information> DatabaseOrdinary (default): Total 0 tables.
2016.06.24 14:15:34.142 [ 1 ] <Debug> Application: Loaded metadata.
2016.06.24 14:15:34.466 [ 1 ] <Debug> Application: Closed all connections.
2016.06.24 14:15:34.466 [ 1 ] <Information> Application: Shutting down storages.
2016.06.24 14:15:34.466 [ 1 ] <Debug> Application: Shutted down storages.
2016.06.24 14:15:34.467 [ 1 ] <Debug> Application: Destroyed global context.
2016.06.24 14:15:35.831 [ 1 ] <Error> Application: DNS error: EAI: -9
2016.06.24 14:15:35.831 [ 1 ] <Information> Application: shutting down
2016.06.24 14:15:35.831 [ 1 ] <Debug> Application: Uninitializing subsystem: Logging Subsystem
2016.06.24 14:17:06.344 [ 1 ] <Information> : Starting daemon with revision 53981
2016.06.24 14:17:06.380 [ 1 ] <Information> Application: starting up
2016.06.24 14:17:06.380 [ 1 ] <Debug> Application: rlimit on number of file descriptors is 262144
2016.06.24 14:17:06.380 [ 1 ] <Debug> Application: Initializing DateLUT.
2016.06.24 14:17:06.380 [ 1 ] <Trace> Application: Initialized DateLUT.
2016.06.24 14:17:06.381 [ 1 ] <Debug> Application: Configuration parameter 'interserver_http_host' doesn't exist or exists and empty. Will use 'alex-VirtualBox' as replica host.
2016.06.24 14:17:06.381 [ 1 ] <Debug> UsersConfigReloader: Loading users config
2016.06.24 14:17:06.386 [ 1 ] <Information> Application: Loading metadata.
2016.06.24 14:17:06.386 [ 1 ] <Information> DatabaseOrdinary (system): Total 0 tables.
2016.06.24 14:17:06.386 [ 1 ] <Information> DatabaseOrdinary (default): Total 0 tables.
2016.06.24 14:17:06.387 [ 1 ] <Debug> Application: Loaded metadata.
2016.06.24 14:17:06.389 [ 1 ] <Debug> Application: Closed all connections.
2016.06.24 14:17:06.390 [ 1 ] <Information> Application: Shutting down storages.
2016.06.24 14:17:06.390 [ 1 ] <Debug> Application: Shutted down storages.
2016.06.24 14:17:06.390 [ 1 ] <Debug> Application: Destroyed global context.
2016.06.24 14:17:08.393 [ 1 ] <Error> Application: DNS error: EAI: -9
2016.06.24 14:17:08.393 [ 1 ] <Information> Application: shutting down
2016.06.24 14:17:08.393 [ 1 ] <Debug> Application: Uninitializing subsystem: Logging Subsystem
2016.06.24 14:18:52.655 [ 1 ] <Information> : Starting daemon with revision 53981
2016.06.24 14:18:52.694 [ 1 ] <Information> Application: starting up
2016.06.24 14:18:52.695 [ 1 ] <Debug> Application: rlimit on number of file descriptors is 262144
2016.06.24 14:18:52.695 [ 1 ] <Debug> Application: Initializing DateLUT.
2016.06.24 14:18:52.695 [ 1 ] <Trace> Application: Initialized DateLUT.
2016.06.24 14:18:52.695 [ 1 ] <Debug> Application: Configuration parameter 'interserver_http_host' doesn't exist or exists and empty. Will use 'alex-VirtualBox' as replica host.
2016.06.24 14:18:52.695 [ 1 ] <Debug> UsersConfigReloader: Loading users config
2016.06.24 14:18:52.696 [ 1 ] <Information> Application: Loading metadata.
2016.06.24 14:18:52.697 [ 1 ] <Information> DatabaseOrdinary (system): Total 0 tables.
2016.06.24 14:18:52.697 [ 1 ] <Information> DatabaseOrdinary (default): Total 0 tables.
2016.06.24 14:18:52.697 [ 1 ] <Debug> Application: Loaded metadata.
2016.06.24 14:18:52.698 [ 1 ] <Debug> Application: Closed all connections.
2016.06.24 14:18:52.698 [ 1 ] <Information> Application: Shutting down storages.
2016.06.24 14:18:52.698 [ 1 ] <Debug> Application: Shutted down storages.
2016.06.24 14:18:52.698 [ 1 ] <Debug> Application: Destroyed global context.
2016.06.24 14:18:54.699 [ 1 ] <Error> Application: DNS error: EAI: -9
2016.06.24 14:18:54.699 [ 1 ] <Information> Application: shutting down
2016.06.24 14:18:54.699 [ 1 ] <Debug> Application: Uninitializing subsystem: Logging Subsystem
2016.06.24 14:20:01.836 [ 1 ] <Information> : Starting daemon with revision 53981
2016.06.24 14:20:01.865 [ 1 ] <Information> Application: starting up
2016.06.24 14:20:01.865 [ 1 ] <Debug> Application: rlimit on number of file descriptors is 262144
2016.06.24 14:20:01.865 [ 1 ] <Debug> Application: Initializing DateLUT.
2016.06.24 14:20:01.865 [ 1 ] <Trace> Application: Initialized DateLUT.
2016.06.24 14:20:01.866 [ 1 ] <Debug> Application: Configuration parameter 'interserver_http_host' doesn't exist or exists and empty. Will use 'alex-VirtualBox' as replica host.
2016.06.24 14:20:01.866 [ 1 ] <Debug> UsersConfigReloader: Loading users config
2016.06.24 14:20:01.867 [ 1 ] <Information> Application: Loading metadata.
2016.06.24 14:20:01.867 [ 1 ] <Information> DatabaseOrdinary (system): Total 0 tables.
2016.06.24 14:20:01.867 [ 1 ] <Information> DatabaseOrdinary (default): Total 0 tables.
2016.06.24 14:20:01.867 [ 1 ] <Debug> Application: Loaded metadata.
2016.06.24 14:20:01.868 [ 1 ] <Debug> Application: Closed all connections.
2016.06.24 14:20:01.868 [ 1 ] <Information> Application: Shutting down storages.
2016.06.24 14:20:01.869 [ 1 ] <Debug> Application: Shutted down storages.
2016.06.24 14:20:01.869 [ 1 ] <Debug> Application: Destroyed global context.
2016.06.24 14:20:03.868 [ 1 ] <Error> Application: DNS error: EAI: -9
2016.06.24 14:20:03.868 [ 1 ] <Information> Application: shutting down
2016.06.24 14:20:03.868 [ 1 ] <Debug> Application: Uninitializing subsystem: Logging Subsystem
2016.06.24 14:22:13.639 [ 1 ] <Information> : Starting daemon with revision 53981
2016.06.24 14:22:13.710 [ 1 ] <Information> Application: starting up
2016.06.24 14:22:13.711 [ 1 ] <Debug> Application: rlimit on number of file descriptors is 262144
2016.06.24 14:22:13.711 [ 1 ] <Debug> Application: Initializing DateLUT.
2016.06.24 14:22:13.711 [ 1 ] <Trace> Application: Initialized DateLUT.
2016.06.24 14:22:13.720 [ 1 ] <Debug> Application: Configuration parameter 'interserver_http_host' doesn't exist or exists and empty. Will use 'alex-VirtualBox' as replica host.
2016.06.24 14:22:13.720 [ 1 ] <Debug> UsersConfigReloader: Loading users config
2016.06.24 14:22:13.721 [ 1 ] <Information> Application: Loading metadata.
2016.06.24 14:22:13.721 [ 1 ] <Information> DatabaseOrdinary (system): Total 0 tables.
2016.06.24 14:22:13.721 [ 1 ] <Information> DatabaseOrdinary (default): Total 0 tables.
2016.06.24 14:22:13.721 [ 1 ] <Debug> Application: Loaded metadata.
2016.06.24 14:22:13.723 [ 1 ] <Debug> Application: Closed all connections.
2016.06.24 14:22:13.723 [ 1 ] <Information> Application: Shutting down storages.
2016.06.24 14:22:13.723 [ 1 ] <Debug> Application: Shutted down storages.
2016.06.24 14:22:13.723 [ 1 ] <Debug> Application: Destroyed global context.
2016.06.24 14:22:15.722 [ 1 ] <Error> Application: DNS error: EAI: -9
2016.06.24 14:22:15.722 [ 1 ] <Information> Application: shutting down
2016.06.24 14:22:15.722 [ 1 ] <Debug> Application: Uninitializing subsystem: Logging Subsystem
2016.06.24 14:23:37.646 [ 1 ] <Information> : Starting daemon with revision 53981
2016.06.24 14:23:37.684 [ 1 ] <Information> Application: starting up
2016.06.24 14:23:37.685 [ 1 ] <Error> Application: DB::Exception: Cannot open file /opt/clickhouse/status, errno: 2, strerror: No such file or directory
2016.06.24 14:23:37.685 [ 1 ] <Information> Application: shutting down
2016.06.24 14:23:37.685 [ 1 ] <Debug> Application: Uninitializing subsystem: Logging Subsystem
В серверном конфиге ничего не изменялось, все по умолчанию
man...@gmail.com
Jun 24, 2016, 4:23:56 PM6/24/16
to ClickHouse
Привет. Это связано с отсутствием на сервере IPv6.
Посмотрите решение здесь: https://habrahabr.ru/company/yandex/blog/303282/#comment_9662080
Суть в том, что в конфиге сервера прописано - слушать wildcard IPv6 адрес:
<!-- Listen specified host. :: - is wildcard IPv6 address, allows to accept connections both with IPv4 and IPv6 from everywhere. -->
<listen_host>::</listen_host>
У вас на сервере выключен IPv6, поэтому такой адрес не удаётся отрезолвить.
Пропишите вместо него:
<listen_host>127.0.0.1</listen_host>
Посмотрите решение здесь: https://habrahabr.ru/company/yandex/blog/303282/#comment_9662080
Суть в том, что в конфиге сервера прописано - слушать wildcard IPv6 адрес:
<!-- Listen specified host. :: - is wildcard IPv6 address, allows to accept connections both with IPv4 and IPv6 from everywhere. -->
<listen_host>::</listen_host>
У вас на сервере выключен IPv6, поэтому такой адрес не удаётся отрезолвить.
Пропишите вместо него:
<listen_host>127.0.0.1</listen_host>
1bitforce
Jun 27, 2016, 1:58:28 AM6/27/16
to ClickHouse
Спасибо за помощь. Помимо этого потребовалось еще вручную создать директории
/opt/clickhouse/data/default/ /opt/clickhouse/metadata/default/
Reply all
Reply to author
Forward
0 new messages