2025/12/31 14:28:17
不知道有没有人写过，这里先记一下
oracle 可以使用savepoint，rollback能进行部分回滚，但是注意savepoint前后的事务id本身没有变化。观察v$transaction可以发现在savepoint后发生数据变更时,UBAREC的值会发生变化，UBA是undo block address的缩写，也就是说savepoint后改数据，会使用新的undo块地址，这样回滚时就能明确回滚到哪里截止
2025/12/26 14:01:02
openGauss手动执行单个regress的sql文件并对比输出是否一致
gs_guc reload -c "log_statement='all'"
cd $CODE_BASE/src/test/regress
gsql -q -a <sql/sw_prepare.sql >results/sw_prepare.out 2>&1
diff expected/sw_prepare.out results/sw_prepare.out
gsql -q -a <sql/sw_basic.sql >results/sw_basic.out 2>&1
diff expected/sw_basic.out results/sw_basic.out
gsql -q -a <sql/sw_clearup.sql >results/sw_clearup.out 2>&1
diff expected/sw_clearup.out results/sw_clearup.out
#注意初始化的字符序
gs_initdb --nodename=primary --pwpasswd=Gauss@123 --encoding=UTF-8 --locale=C2025/11/26 20:20:28
2025/11/26 17:01:10
esxi 页面上的状态有时候不对，就会导致很多操作无法进行，需要重启服务 /etc/init.d/hostd restart 这个可以避免重启整个esxi
2025/11/26 10:47:08
vscode copilot被墙了，所有模型均无法选择
https://github.com/microsoft/vscode/issues/278925
目前通过一些测试，我暂时认为是国内网络增加了限制，而非vscode做的限制
2025/11/25 22:22:25
截止到20251125的ip黑名单
1.180.141.166
1.190.192.222
2.57.121.247
8.134.58.222
14.198.6.42
27.129.129.240
27.185.31.75
31.7.56.210
31.7.62.234
36.134.21.102
36.137.195.72
36.140.10.64
36.140.10.145
36.140.160.210
36.140.161.139
36.140.161.208
36.212.233.36
39.150.130.100
42.177.94.52
43.242.202.223
43.249.193.47
45.248.8.157
46.19.142.242
46.19.143.10
46.19.143.50
47.92.197.190
49.0.196.81
58.18.178.243
58.22.243.42
58.48.96.131
58.53.128.39
58.58.7.6
58.211.255.186
58.212.22.130
58.212.22.131
58.221.18.178
58.221.60.78
58.221.177.230
60.205.217.172
60.250.70.187
60.250.70.189
60.250.81.66
79.124.40.94
79.124.56.98
79.124.56.186
79.124.58.158
79.124.58.218
79.124.59.86
82.147.85.152
82.156.52.66
83.222.190.78
88.210.63.16
88.210.63.18
88.214.25.124
91.238.181.92
91.238.181.94
93.123.109.71
93.123.109.72
93.123.109.98
95.214.53.249
95.214.53.251
103.56.154.146
103.85.168.18
103.86.86.248
103.148.58.155
103.151.5.83
103.186.108.229
106.13.214.12
106.54.0.196
110.40.47.161
111.10.223.2
111.23.63.18
111.53.63.134
111.85.83.175
111.225.194.184
111.229.9.22
112.2.55.181
112.26.66.25
112.27.125.137
112.28.149.33
112.51.96.142
112.192.16.55
112.237.143.195
113.45.179.186
113.46.159.125
113.87.163.182
113.106.0.239
113.140.37.86
113.201.37.18
113.204.49.74
114.219.214.47
114.231.165.9
115.182.240.35
115.230.124.37
115.239.160.246
116.114.161.15
116.237.41.143
117.72.87.228
117.82.91.243
117.90.230.46
117.135.195.2
117.156.237.76
117.158.153.125
118.190.103.72
120.41.185.163
120.48.22.39
120.70.15.109
120.220.44.48
121.12.149.101
123.7.18.116
123.139.119.80
123.164.144.10
123.182.152.114
124.28.197.138
124.65.97.230
124.79.120.60
124.117.230.190
124.131.50.55
124.165.238.153
124.232.147.3
124.232.147.204
125.64.244.102
128.14.98.144
141.255.167.50
150.138.72.54
154.89.10.220
175.6.40.66
175.42.33.95
175.153.161.124
175.153.169.51
178.22.24.42
178.22.24.44
180.76.54.9
180.97.238.96
180.143.174.169
182.107.103.82
182.200.3.68
182.200.4.161
182.200.5.77
182.200.6.185
182.200.7.4
182.200.7.20
183.230.200.5
183.232.204.2
183.239.210.213
183.240.197.189
183.241.138.37
183.249.161.117
183.250.134.17
185.7.214.89
185.42.12.98
185.147.124.102
185.147.124.202
185.147.124.203
185.156.73.71
190.211.252.90
192.72.189.195
194.165.16.165
195.3.220.79
195.3.222.252
195.3.222.253
202.61.86.79
202.101.188.54
210.16.65.193
210.45.79.219
210.51.45.106
210.71.163.253
210.83.202.78
211.141.173.254
218.17.143.117
218.27.79.202
218.64.91.173
218.76.62.187
218.78.122.230
218.85.116.202
218.85.191.122
218.89.66.58
218.90.122.42
218.95.37.198
218.108.135.66
218.201.74.254
218.203.238.11
220.78.179.70
220.197.200.154
221.122.121.236
221.144.44.17
221.237.154.89
222.65.118.250
222.75.100.74
222.79.56.194
222.173.131.58
222.249.238.114
223.13.122.170
223.75.187.13
223.83.10.222
223.108.111.194
223.108.111.238
223.241.247.2282025/11/14 09:58:38
docker desktop 修改支持计划了，原本4.49.0版本为最后一个支持win10的版本，现在改成了
Support for Windows 10 21H2 (19044) and 11 22H2 (22621) has ended. Installing Docker Desktop will require Windows 10 22H2 (19045) or Windows 11 23H2 (22631) in the next release.
Windows 10 21H2 (19044) 是开启了扩展安全更新的版本，微软会继续提供一年的安全更新支持
2025/11/05 15:10:14
centos7.9 假设光驱里有操作系统光盘，挂载本地yum源，并屏蔽其他所有源
mkdir /media/cdrom
mount /dev/cdrom /media/cdrom
mv /etc/yum.repos.d /etc/yum.repos.d.bak
mkdir /etc/yum.repos.d
cp /etc/yum.repos.d.bak/CentOS-Media.repo /etc/yum.repos.d
sed -i 's/enabled=0/enabled=1/' /etc/yum.repos.d/CentOS-Media.repo
yum clean all
yum repolist all2025/10/31 08:48:11
docker desktop 4.49.0 (208700) 是最后一个支持win10的版本
Support for Windows 10 and 11 22H2 (19045) has ended. Installing Docker Desktop will require Windows 11 23H2 in the next release.
2025/10/28 10:05:46
查询 duckdb当前运行平台当前版本的 官方插件下载地址
select t.extension_name,installed,
format('http://extensions.duckdb.org/{}/{}/{}.duckdb_extension.gz',
version(),
(SELECT platform FROM pragma_platform()),
t.extension_name)
from duckdb_extensions() t;