duerwuyi
duerwuyi
the concrete test log with timestamp, after inserting those data: ``` sql citus test: 2025-02-09 21:41:20.00116 NOTICE: Moving shard 102029 from host.docker.internal:5437 to host.docker.internal:5434 ... --- the following 77 lines...
the log of Master node: ```sql 2025-02-09 21:46:55 UTC [57156] ERROR: cannot colocate tables t7 and t3 2025-02-09 21:46:55 UTC [57156] DETAIL: Distribution column types don't match for t7 and...
the log of worker node: ```sql 2025-02-09 21:47:02 UTC [70304] LOG: logical decoding found consistent point at 9/C5A55C38 2025-02-09 21:47:02 UTC [70304] DETAIL: There are no running transactions. 2025-02-09 21:47:02...
Sure, I modified https://github.com/citusdata/docker . Dockerfile ```yaml # This file is auto generated from it's template, # see citusdata/tools/packaging_automation/templates/docker/latest/latest.tmpl.dockerfile. FROM debian:12-slim FROM postgres:17 ARG VERSION=13.0.1 LABEL maintainer="Citus Data https://citusdata.com" \...
```sql postgres=# SELECT create_distributed_table('t2', 'pkey', colocate_with := 't5'); ERROR: cannot colocate tables t5 and t2 DETAIL: Distribution column types don't match for t5 and t2. ``` this action is expected...
Fortunately, I found another test case and I logged all the steps to reproduce it. This bug only occurs with a certain probability, so I provide the whole docker containers...
btw, `citus_rebalance_stop` returns `ERROR: no ongoing rebalance that can be stopped`
the distributed query plan of this query: Custom Scan (Citus Adaptive) (cost=0.00..0.00 rows=100000 width=4) -> Distributed Subplan 1_1 -> Seq Scan on t3 (cost=0.00..35.50 rows=2550 width=4) -> Distributed Subplan 1_2...
btw, I wonder if shardingsphere-proxy provides any method to query all the names of logic tables and row names they have in a database, e.g. `t_order` above? Thx a lot...
NOTE： `\d` and `\dt` also produced wrong results: ```sql postgres=> \d List of relations Schema | Name | Type | Owner --------+-----------+-------+---------- public | t_order_0 | table | postgres public...