Files
Nikita Fomichev a78bcc708e utils: add auto-bisect script for ClickHouse regression bisection
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.
2026-03-28 10:39:03 +01:00

51 lines
1.8 KiB
Bash
Executable File

#!/bin/bash
# not working!!!
export CH_PATH=$(realpath ../../clickhouse2410)
export DATA_DIR="/home/nik/chdata"
set -e
#CH_PATH=../../clickhouse2412
./env/replicated.sh /home/nik/work/clickhouse-private1/
$CH_PATH client --query "
SELECT version();
CREATE DATABASE x;
CREATE TABLE x.src (x UInt64) ENGINE = SharedReplacingMergeTree ORDER BY x;
--SETTINGS shared_merge_tree_disable_merges_and_mutations_assignment=1;
--SYSTEM STOP MERGES ON CLUSTER default x.src;
"
head -c 1000 /dev/zero | $CH_PATH client --insert_deduplicate=0 --max_insert_block_size=1 --min_insert_block_size_rows=1 --min_insert_block_size_bytes=1 -q "INSERT INTO x.src FORMAT RowBinary"
echo 'insert done'
#$CH_PATH client --query "
# ALTER TABLE x.src MODIFY SETTING shared_merge_tree_disable_merges_and_mutations_assignment=0;
# SYSTEM START MERGES ON CLUSTER default x.src;
#"
echo 'alter done'
#
#for ((i = 1; i <= 1000; i++)); do
# head -c 1000 /dev/zero | $CH_PATH client --insert_deduplicate=0 --max_insert_block_size=1 --min_insert_block_size_rows=1 --min_insert_block_size_bytes=1 -q "INSERT INTO x.src FORMAT RowBinary"
#done
#echo 'insert done'
wait
exit 1
$CH_PATH client --query "SELECT count() FROM x.src;
SELECT count() FROM system.parts WHERE table='src';
SELECT * FROM system.virtual_parts WHERE table='src';
"
# do not remove clickhouse data
export CLEAN_CH_DATA=0
CH_PATH=$(realpath ../../clickhouse2412)
./env/replicated.sh /home/nik/work/clickhouse-private1/
head -c 1000 /dev/zero | $CH_PATH client --insert_deduplicate=0 --max_insert_block_size=1 --min_insert_block_size_rows=1 --min_insert_block_size_bytes=1 -q "INSERT INTO x.src FORMAT RowBinary"
$CH_PATH client --query "SELECT count() FROM x.src;
SELECT count() FROM system.parts WHERE table='src';
SELECT * FROM system.virtual_parts WHERE table='src';
"