william

Keep Calm and Markdown.

Clickhouse 连接错误次数

问题:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
>     DBI::dbSendQuery(conn, sql)
Error in select(conn@ptr, statement) :
DB::Exception: All attempts to get table structure failed. Log:
Code: 279, e.displayText() = DB::NetException: All connection tries failed. Log:
Code: 209, e.displayText() = DB::NetException: Timeout: connect timed out: 10.20.140.3:9000 (10.20.140.3:9000) (version 21.4.7.3 (official bui
ld))
Code: 209, e.displayText() = DB::NetException: Timeout: connect timed out: 10.20.140.3:9000 (10.20.140.3:9000) (version 21.4.7.3 (official bui
ld))
Code: 209, e.displayText() = DB::NetException: Timeout: connect timed out: 10.20.140.3:9000 (10.20.140.3:9000) (version 21.4.7.3 (official bui
ld))

解决方案参考:Inconsistent behaviour of Distributed table engine and remote table function when called with cluster and with list of addresses

1
SET connections_with_failover_max_tries = 5

Docker 运维小记

安装 Docker

删除旧版本

1
2
3
4
5
6
7
8
sudo yum remove docker \
	docker-client \
	docker-client-latest \
	docker-common \
	docker-latest \
	docker-latest-logrotate \
	docker-logrotate \
	docker-engine

python 打包 packages

项目结构

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
├── readme.md
├── wepy
│   ├── ch
│   ├── __init__.py
│   ├── __pycache__
│   ├── requirements.txt
│   ├── setup.py
│   ├── utils
│   ├── __version__.py
│   └── wechat
0%