Denis Volkov
Denis Volkov
**Describe the bug** The local log [iterates](https://github.com/pg-sharding/spqr/blob/master/router/qlog/provider/local.go#L63) over the file line by line, but it should iterate statement by statement. **To Reproduce** ``` CREATE KEY RANGE uid_range_1 FROM 00000000-0000-0000-0000-000000000000 ROUTE...
When you are adding a new table, you can specify a schema. For example: ``` ALTER DISTRIBUTION ds1 ATTACH RELATION schema_name.table_name DISTRIBUTION KEY id; ``` In fact, during query/transaction routing,...
There is no "HASH" keyword in the ["ALTER DISTRIBUTION" command definition](https://pg-sharding.tech/sharding/console/sql_commands#create-distribution.). Therefore, when using a key-range-based approach, we use the int64 golang type, but when using a hash-based approach, the...
Based on #789, the REDISTRIBUTE and MOVE KEY RANGE commands will not work and should not be used in installations without a coordinator. We have to prohibit REDISTRIBUTING KEY RANGES...
In #789 was added `REDISTRIBUTE` command. It would be more user friendly if `BATCH SIZE` parameter has some default value, so the command syntax will be. ``` REDISTRIBUTE KEY RANGE...
## How we got here Hello there! SPQR started as an internal project at Yandex Cloud. Our goal was to help developers avoid writing repetitive code and provide a managed...
No panic
We have to make SPQR as stable as possible. One of the problems that prevents us from doing this is a lot of `panic()` calls. We need to audit our...
If the default_route_behaviour is set to BLOCK, the router will send a message to the client: ``` ERROR: client processing error: error processing query 'CREATE TABLE test_pers (puid INT, data...
Problem: you may add now shards that is not reachably by coordinator or router: ``` regress=> CREATE SHARD sh5 WITH HOSTS oooops:6432; add shard ----------------- shard id -> sh5 (1...
What happened: evaluateTSAMatch will not work correctly with different TSA. https://github.com/pg-sharding/spqr/pull/1544/files#diff-f23fbd18734bff32c8af5b12bb02d8d70e666dd1ce077af21b0db1efd7409d6bR188 How to solve it: rewrite evaluateTSAMatch should return a score instead of bool.