Felix021

Dec 19

Gitea cleanup

felix021 @ 2025-12-19 22:37 [IT » 软件] 评论(0) , 引用(0) , 阅读(37) | Via 本站原创

Gitea does not provide official way to cleanup action running history.

Had to do it manually by

#!/bin/bash

mysql giteadb -e "delete from action where created_unix < UNIX_TIMESTAMP(date_sub(now(), interval 45 day))"
mysql giteadb -e "delete from action_run where created < UNIX_TIMESTAMP(date_sub(now(), interval 45 day))"
mysql giteadb -e "delete from action_task where created < UNIX_TIMESTAMP(date_sub(now(), interval 45 day))"
mysql giteadb -e "delete from action_run_job where created < UNIX_TIMESTAMP(date_sub(now(), interval 45 day))"
mysql giteadb -e "delete from action_task_step where created < UNIX_TIMESTAMP(date_sub(now(), interval 45 day))"

find /home/gitea/.cache/act -maxdepth 1 -ctime +45 | xargs rm -rf

Dec 18

Maven: 阿里云镜像

felix021 @ 2025-12-18 18:30 [IT » 程序设计] 评论(0) , 引用(0) , 阅读(49) | Via 本站原创

引用

<settings>

<servers>
<server>
<id>private_repo</id>
<username>USERNAME</username>
<password>PASSWORD</password>
</server>
</servers>
<mirrors>
<mirror>
<id>aliyunmaven</id>
<mirrorOf>*,!private_repo</mirrorOf>
<name>阿里云公共仓库</name>
<url>https://maven.aliyun.com/repository/public</url>
</mirror>
</mirrors>
</settings>

Dec 16

Intellij IDEA: cannot resolve symbol

felix021 @ 2025-12-16 11:07 [IT » 程序设计] 评论(0) , 引用(0) , 阅读(71) | Via 本站原创

结论：IDEA 是 SH*T.

问题：报错，找不到符号，通常是 Lombok annotation 生成的，比如 @Builder 生成的 XXXBuilder。

【可能】的解决方案

(1) IDE 参数，玄学，可能有用

Help -> Custom VM Option

引用

-Xms2g
-Xmx16g

Settings -> Compiler:
- Shared VM Options: "-Xss1024m"
- Heap Size: 16384 (Mbytes)

(2) 将 IDE 构建/运行操作委托给 Maven
Settings -> Build Tools -> Delegate IDE Build/Run actions to Maven.

(3) 跳过 IDE 的编译

- 使用 mvn compile -T 4 、 mvn test-compile -T 4（编译测试代码）
- 在Run Configuration的 "Modify options" 里选择 "Do not build before run"

Dec 14

MySQL/MariaDB 主从同步

felix021 @ 2025-12-14 19:12 [IT » 数据库] 评论(0) , 引用(0) , 阅读(69) | Via 本站原创

== Master ==

$ vi /etc/mysql/mariadb.conf.d/50-server.cnf

引用

server-id = 1
log_bin = /var/log/mysql/mysql-bin.log
expire_logs_days = 10
max_binlog_size = 1024M
binlog_do_db = testdb

$ mysql

CREATE USER 'username'@'%' IDENTIFIED BY '12345678';
GRANT ALL PRIVILEGES ON giteadb.* TO 'username'@'%';
GRANT REPLICATION SLAVE ON testdb.* TO 'username'@'%';
[/code

[code]
mysqldump --databases testdb --master-data > testdb.sql

== Slave ==

$ vi /etc/mysql/mariadb.conf.d/50-server.cnf

引用

server-id = 2
relay_log = /var/log/mysql/mysql-relay-bin.log
log_bin = /var/log/mysql/mysql-bin.log
binlog_do_db = testdb
read_only = 1

mysql> CHANGE MASTER TO
MASTER_HOST='HOSTNAME',
MASTER_USER='testdb',
MASTER_PASSWORD='12345678',

$ mysql < testdb.sql

mysql> start slave;

mysql> SHOW SLAVE STATUS\G

另：如果报错

引用

mysql error 1273 (hy000) at line 33: unknown collation: 'utf8mb4_0900_as_cs'

需要把 sql 里的 utf8mb4_0900_as_cs 替换成 MariaDB 的 utf8mb4_unicode_520_ci

Dec 12

备查：MySQL Client CLI - CTRL+W 只删除一个单词

felix021 @ 2025-12-12 00:22 [IT » shell] 评论(0) , 引用(0) , 阅读(88) | Via 本站原创

ref: https://unix.stackexchange.com/questions/252546/control-w-delete-word-deletes-whole-line-in-mariadb-client

vi ~/.editrc

引用

bind "^W" ed-delete-prev-word

Dec 3

git pre-commit hook

felix021 @ 2025-12-3 21:06 [IT » 软件] 评论(0) , 引用(0) , 阅读(127) | Via 本站原创

vi .git/hooks/pre-commit

#!/bin/bash

function color() {
scheme=$1
shift
echo -e "\e[${scheme}m"$*"\e[0m"
}

rebasing=`git status | grep 'currently rebasing'`
if [ ! -z "$rebasing" ]; then
color '31;43' "currently rebasing, commit not allowed"
echo
exit 1
fi

Oct 22

Ollama API example

felix021 @ 2025-10-22 18:48 [随想] 评论(0) , 引用(0) , 阅读(329) | Via 本站原创

引用

curl -X POST http://localhost:11434/api/chat \
-H "Content-Type: application/json" \
-d '{
"model": "hf.co/Triangle104/Qwen3-30B-A3B-abliterated-Q5_K_M-GGUF:Q5_K_M",
"messages": [
{
"role": "user",
"content": "Pourquoi le ciel est-il bleu? Reponds en anglais, svp."
}
],
"options": {
"num_ctx": 40960
},
"stream": false
}'

# HOWTO

1. 让模型一直加载在内存/显存中

$ vi /etc/systemd/system/ollama.service

增加配置 Environment="OLLAMA_KEEP_ALIVE=-1"

然后 service ollama restart ，加载模型后 ollama ps 看 UTIL 列，值是 Forever 说明生效了。

2. 改变监听的 IP、端口允许来自外部的请求

新增环境变量

- 允许来自外部的请求：

OLLAMA_HOST=0.0.0.0

- 更换端口：

OLLAMA_HOST=0.0.0.0:8080

Oct 21

ClickHouse Playground

felix021 @ 2025-10-21 16:39 [IT » 数据库] 评论(0) , 引用(0) , 阅读(446) | Via 本站原创

docker-compose.yml

引用

services:
clickhouse:
image: clickhouse/clickhouse-server:latest
container_name: my-clickhouse
ports:
- "8123:8123" # HTTP API 端口，用于Web界面和HTTP请求
- "9000:9000" # 原生TCP协议端口，用于clickhouse-client连接
volumes:
- ./data:/var/lib/clickhouse # 数据持久化到主机的 ./data 目录
environment:
- CLICKHOUSE_DB=default
- CLICKHOUSE_USER=default
- CLICKHOUSE_PASSWORD=123456
- CLICKHOUSE_DEFAULT_ACCESS_MANAGEMENT=1
deploy:
resources:
limits:
cpus: '4.0'
memory: 8G
reservations:
cpus: '1.0'
memory: 2G

启动

$ docker compose up -d

连接

$ docker exec -it my-clickhouse clickhouse-client --user default --password 123456

CREATE DATABASE learn;

CREATE USER 'learn' IDENTIFIED WITH sha256_password BY '123456';

GRANT ALL ON learn.* to 'learn';

Playground:

$ git clone https://github.com/VKCOM/lighthouse.git

访问（替换 $CLICKHOUSE 为部署的 IP 或域名）
http://127.0.0.1/lighthouse/#http://$CLICKHOUSE:8123/?user=learn&password=123456