2026/01/19 09:31:07
配置vscode的java调试环境语言为英文，避免中文乱码:
打开设置，搜索`java.debug.settings.vmArgs`，配置值为`-Duser.language=en -Duser.country=US`
2026/01/16 14:12:05
一个神奇的ORACLE BUG
select d.dummy
from (select case when exists (select 1 from dual) then '1' end c1 from dual) v
left join dual d
on (d.dummy = v.c1 or d.dummy = '2');执行后，连接直接断开
2026/01/10 19:50:53
停电几个小时，UPS的电都没了，本网站服务器不间断工作一年多，终于也重启了一回
2026/01/09 15:23:46
oracle如果对分区表append insert,没提交，再次insert会报错
ORA-12838: cannot read/modify an object after modifying it in parallel
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.228