mirror of
https://github.com/hanzoai/datastore.git
synced 2026-09-26 13:55:07 +00:00
Nikita Fomichev
a78bcc708e
Adds `utils/auto-bisect/` — a shell-based bisection framework that downloads pre-built CI binaries and runs a user-supplied test script to find the first bad commit. Key features: - Downloads public CI binaries from S3 by default; private CloudFront builds with `--private` (credentials via `CH_CI_BASIC_AUTH` env var, `CH_CI_USER`/`CH_CI_PASSWORD`, or `/etc/netrc`) - Three environment modes: `single` (one server), `replicateddb` (two nodes + Keeper, Replicated database), `sharedcatalog` (two nodes + Keeper, SharedCatalog) - Uses `git bisect --no-checkout` by default so the work tree is not modified during bisection - Walker mode (`--walker`) for linear commit-by-commit testing - Example test scripts in `tests/` Tested locally: `--env nothing`, `--env single`, and `--env replicateddb` all verified working.
49 lines
1.4 KiB
Bash
Executable File
49 lines
1.4 KiB
Bash
Executable File
#!/bin/bash
|
|
set -e
|
|
|
|
WORK_TREE="$1"
|
|
(
|
|
cd $WORK_TREE || exit 1
|
|
|
|
echo "$PWD"
|
|
|
|
cat << EOF > /tmp/query.sql
|
|
WITH
|
|
1600000000 AS start_uts,
|
|
1600000450 AS end_uts,
|
|
8 AS step_sec
|
|
SELECT *
|
|
FROM
|
|
(
|
|
WITH
|
|
120 AS vector_range_sec,
|
|
0 AS offset,
|
|
toUInt32(start_uts - offset) AS start_uts_with_offset, -- This start_uts_with_offset is a UInt32, different from the inner WITH clause
|
|
toUInt32(end_uts - offset) AS end_uts_with_offset -- This end_uts_with_offset is a UInt32, different from the inner WITH clause
|
|
SELECT *
|
|
FROM
|
|
(
|
|
WITH
|
|
toUInt32(ceiling((start_uts_with_offset - vector_range_sec) / step_sec) * step_sec) AS start_uts,
|
|
toUInt32(end_uts_with_offset) AS end_uts,
|
|
15 AS step_sec
|
|
SELECT *
|
|
FROM
|
|
(
|
|
WITH
|
|
180 AS vector_range_sec,
|
|
0 AS offset,
|
|
toDateTime(start_uts, 'UTC') - toIntervalSecond(offset) AS start_uts_with_offset, -- This start_uts_with_offset is a DateTime, different from the outer WITH clause
|
|
toDateTime(end_uts, 'UTC') - toIntervalSecond(offset) AS end_uts_with_offset -- This end_uts_with_offset is a DateTime, different from the outer WITH clause
|
|
SELECT
|
|
start_uts,
|
|
end_uts
|
|
)
|
|
)
|
|
)
|
|
EOF
|
|
|
|
# CH_PATH is the path to downloaded binary
|
|
$CH_PATH client --queries-file /tmp/query.sql
|
|
)
|