Cannot create_distributed_table when table is too big.
- 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
Assessment
This issue has not been assessed yet.