leshikus

# dump clothes to a stockpile
multicmd item dump -t armor -c cloth; item dump -t pants -c cloth; item dump -t gloves -c cloth; item dump -t shoes -c cloth
multicmd item dump -t armor -c yarn; item dump -t pants -c yarn; item dump -t gloves -c yarn; item dump -t shoes -c yarn
multicmd item dump -t armor -c silk; item dump -t pants -c silk; item dump -t gloves -c silk; item dump -t shoes -c silk
multicmd item dump -t armor -c plant; item dump -t pants -c plant; item dump -t gloves -c plant; item dump -t shoes -c plant
multicmd item dump -t armor -c silk; item dump -t pants -c leather; item dump -t gloves -c leather; item dump -t shoes -c leather
autodump

# dump unusable large clothes to the depot
multicmd item dump -t armor large; item dump -t pants large; item dump -t gloves large; item dump -t shoes large

leshikus

Global $df_window = "Dwarf Fortress"
Global $sleep_time = 1000
AutoItSetOption("SendKeyDelay", 150)
AutoItSetOption("MouseClickDownDelay", 20)

; use standard scale
; center on your broker

For $i = 1 To 20
    WinWaitActive($df_window)

leshikus

I am an experienced DevOps and Linux engineer with over 20 years' experience in automation, system reliability and operations. I have been involved in several open-source projects, including Apache Harmony, Apache OpenMeetings, and Astra Linux Orel. I am also a fan of the ClickHouse technology and the open-source culture behind the project. I hope to make CI and related services more useful and usable for the team.

leshikus

#!/bin/bash

set -eu

cd $(dirname "$0")/ClickHouse

cur_dir=$(pwd -P)

mkdir -p ci/tmp
mv ci/tmp ci/tmp-del$RANDOM

leshikus

#!/bin/bash

set -eu

#test=03540_system_dashboards
#test=02443_detach_attach_partition
test=01154_move_partition_long
test=01086_odbc_roundtrip
wf="Stateless tests (amd_debug, sequential)"
#wf="Stateless tests (amd_binary, old analyzer, s3 storage, DatabaseReplicated, parallel)"

leshikus

Starting ClickHouse server replica 0, command: clickhouse-server --config-file /etc/clickhouse-server/config.xml --pid-file /etc/clickhouse-server/clickhouse-server.pid -- --path /home/aaf/ClickHouse/ci/tmp/run_r0 --user_files_path /home/aaf/ClickHouse/ci/tmp/run_r0/user_files --top_level_domains_path /etc/clickhouse-server/top_level_domains --logger.stderr /home/aaf/ClickHouse/ci/tmp/var/log/clickhouse-server/stderr.log
rm: cannot remove '/etc/clickhouse-server/clickhouse-server.pid': No such file or directory
Run command: [rm -rf /home/aaf/ClickHouse/ci/tmp/run_r0 && mkdir -p /home/aaf/ClickHouse/ci/tmp/run_r0]
Run command: [rm -rf /home/aaf/ClickHouse/ci/tmp/jemalloc_profiles && mkdir -p /home/aaf/ClickHouse/ci/tmp/jemalloc_profiles]
TSAN_OPTIONS = memory_limit_mb=5146
WARNING: stderr: cat: /etc/clickhouse-server/clickhouse-server.pid: No such file or directory
Got pid from fs [1591]
ClickHouse server replica 0 started successfully, pid [1591]
Run command [clickhouse-client --port 9000 --query "select 1"]

leshikus

2025-08-16 13:00:04 Reason: result differs with reference:  
2025-08-16 13:00:04 --- /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/02443_detach_attach_partition.reference	2025-08-16 12:50:58.728674382 -0400
2025-08-16 13:00:04 +++ /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/02443_detach_attach_partition.3922.stdout	2025-08-16 13:00:04.085598505 -0400
2025-08-16 13:00:04 @@ -1,17 +1,209 @@
2025-08-16 13:00:04 -cluster_1S_2R	1	1	clickhouse-01	9000	\N
2025-08-16 13:00:04 -cluster_1S_2R	1	2	clickhouse-02	9000	\N
2025-08-16 13:00:04 -default	1	1	localhost	9000	\N
2025-08-16 13:00:04 -cluster_1S_2R	1	1	clickhouse-01	9000	\N
2025-08-16 13:00:04 -cluster_1S_2R	1	2	clickhouse-02	9000	\N
2025-08-16 13:00:04 -default	1	1	localhost	9000	\N

leshikus

# specific settings go here

export HTTPS_PROXY="$https_proxy"
export EDITOR=vim

cd
export PS1="\[\033]0;$TITLEPREFIX:$PWD\007\]\n\[\033[32m\]\u@\h \[\033[35m\]$MSYSTEM \[\033[33m\]\w\[\033[36m\] `pwd -P`\[\033[0m\]\n$ "

cat <<EOF >.vimrc
syntax on

leshikus

select test_status, check_start_time from checks where test_status = 'FAIL' and test_name = '02933_group_by_memory_usage' and pull_request_number = 0 and check_start_time > now() - interval 2 month order by check_start_time desc;

leshikus

select test_name, count(test_name) from checks where test_status = 'FAIL' and pull_request_number = 0 and check_start_time > now() - interval 1 month group by test_name order by count(test_name) desc;