citusdata / citusdata/citus

Cannot create_distributed_table when table is too big.

Open
#7,031 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
C
Stars
12.8k
Forks
794
Avg merge
2d 14h
Merged PRs (30d)
31

Description

the table `label_addresses` is about 1GB

log:
```
2023-06-23 07:43:13.953 CST [1589] ERROR: connection to the remote node localhost:5432 failed with the following error: could not translate host name "localhost" to address: nodename nor servname provided, or not known
2023-06-23 07:43:13.953 CST [1589] STATEMENT: SELECT create_distributed_table('label_addresses', 'address', shard_count := 256);
2023-06-23 07:43:13.954 CST [1589] WARNING: kqueue failed: Too many open files
2023-06-23 07:43:13.954 CST [1589] WARNING: could not issue cancel request
2023-06-23 07:43:13.954 CST [1589] DETAIL: Client error: PQcancel() -- socket() failed: error 24
```

macOS 12.6, with postgres 14.8 - citus11.3-1

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.