个人 BUG 汇总记录

1Caused by: java.lang.IllegalAccessException: class com.alibaba.fastjson.parser.deserializer.JavaBeanDeserializer cannot access a member of class com.jzh.test.json.SubmitTime with modifiers "public"

1Caused by: java.lang.Exception: No native library is found for os.name=Mac and os.arch=aarch64. path=/org/sqlite/native/Mac/aarch64

 1Description:
 2
 3An attempt was made to call a method that does not exist. The attempt was made from the following location:
 4
 5    org.sqlite.hibernate.dialect.SQLiteDialect.<init>(SQLiteDialect.java:57)
 6
 7The following method did not exist:
 8
 9    'void org.sqlite.hibernate.dialect.SQLiteDialect.registerColumnType(int, java.lang.String)'
10
11The calling method's class, org.sqlite.hibernate.dialect.SQLiteDialect, was loaded from the following location:
12
13    jar:file:/Users/zh/.m2/repository/com/github/gwenn/sqlite-dialect/0.1.2/sqlite-dialect-0.1.2.jar!/org/sqlite/hibernate/dialect/SQLiteDialect.class
14
15The called method's class, org.sqlite.hibernate.dialect.SQLiteDialect, is available from the following locations:
16
17    jar:file:/Users/zh/.m2/repository/com/github/gwenn/sqlite-dialect/0.1.2/sqlite-dialect-0.1.2.jar!/org/sqlite/hibernate/dialect/SQLiteDialect.class
18
19The called method's class hierarchy was loaded from the following locations:
20
21    org.sqlite.hibernate.dialect.SQLiteDialect: file:/Users/zh/.m2/repository/com/github/gwenn/sqlite-dialect/0.1.2/sqlite-dialect-0.1.2.jar
22    org.hibernate.dialect.Dialect: file:/Users/zh/.m2/repository/org/hibernate/orm/hibernate-core/6.4.1.Final/hibernate-core-6.4.1.Final.jar
23
24
25Action:
26
27Correct the classpath of your application so that it contains a single, compatible version of org.sqlite.hibernate.dialect.SQLiteDialect

1<dependency>
2    <groupId>org.hibernate.orm</groupId>
3    <artifactId>hibernate-community-dialects</artifactId>
4</dependency>

1spring.jpa.database-platform=org.hibernate.community.dialect.SQLiteDialect

 1        <!--jpa-->
 2        <dependency>
 3            <groupId>org.springframework.boot</groupId>
 4            <artifactId>spring-boot-starter-data-jpa</artifactId>
 5        </dependency>
 6        <!-- sqlite -->
 7        <dependency>
 8            <groupId>org.xerial</groupId>
 9            <artifactId>sqlite-jdbc</artifactId>
10            <version>3.34.0</version>
11        </dependency>
12<!--        <dependency>-->
13<!--            <groupId>com.github.gwenn</groupId>-->
14<!--            <artifactId>sqlite-dialect</artifactId>-->
15<!--            <version>0.1.4</version>-->
16<!--        </dependency>-->
17        <dependency>
18            <groupId>org.hibernate.orm</groupId>
19            <artifactId>hibernate-community-dialects</artifactId>
20        </dependency>

1spring:
2    resources:
3        static-locations:
4            - classpath:static/
5            - file:/app/static/

1cd conf/2m-2s-sync
2
3vim broker-a.properties
4diskMaxUsedSpaceRatio=99

1# userId
2{"code":200,"msg":"ok","obj":{"userId":"hello"}}
3# uId
4{"code":200,"msg":"ok","obj":{"uid":"hello"}}
5# Id
6{"code":200,"msg":"ok","obj":{"id":"hello"}}
7# uuId
8{"code":200,"msg":"ok","obj":{"uuId":"hello"}}

1BigDecimal amount1 = new BigDecimal(0.02);
2BigDecimal amount2 = new BigDecimal(0.03);
3System.out.println(amount2.subtract(amount1));
4// 0.0099999999999999984734433411404097569175064563751220703125

1BigDecimal amount1 = BigDecimal.valueOf(0.02);
2BigDecimal amount2 = BigDecimal.valueOf(0.03);

 1public class FastJsonTest {
 2    @Test
 3    public void test1() {
 4        Vote vote = new Vote();
 5        vote.setTitle("test");
 6        vote.setIsOverdue(true);
 7        vote.setDeleted(false);
 8        vote.setImportant(true);
 9        String voteJson = JSON.toJSONString(vote);
10        System.out.println(voteJson);
11        // {"deleted":false,"important":true,"isOverdue":true,"title":"test"}
12
13        // ok
14        Vote voteFromJson = JSON.parseObject(voteJson, Vote.class);
15        System.out.println(voteFromJson);
16
17        // {"deleted":false,"isImportant":true,"isOverdue":true,"title":"test"}
18        String anotherVoteJson = "{\"deleted\":false,\"isImportant\":true,\"isOverdue\":true,\"title\":\"test\"}";
19        Vote anotherVote = JSON.parseObject(anotherVoteJson, Vote.class);
20        System.out.println(anotherVote);
21        // 反序列化失败：
22        // Vote(isOverdue=true, deleted=false, isImportant=false, title=test)
23    }
24}
25
26@NoArgsConstructor
27@Data
28class Vote {
29    // ok
30    private Boolean isOverdue;
31    // ok
32    private Boolean deleted;
33    // fail
34    private boolean isImportant;
35
36    private String title;
37}

1maven-default-http-blocker (http://0.0.0.0/): Blocked mirror for repositories

1<mirror>
2    <id>maven-default-http-blocker</id>
3    <mirrorOf>dummy</mirrorOf>
4    <name>Dummy mirror to override default blocking mirror that blocks http</name>
5    <url>http://0.0.0.0/</url>
6</mirror>

 12023-05-31T16:52:18.233+08:00  WARN 28432 --- [           main] ConfigServletWebServerApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in class path resource [org/springframework/boot/autoconfigure/jdbc/DataSourceConfiguration$Hikari.class]: Failed to instantiate [com.zaxxer.hikari.HikariDataSource]: Factory method 'dataSource' threw exception with message: Failed to determine a suitable driver class
 22023-05-31T16:52:18.235+08:00  INFO 28432 --- [           main] o.apache.catalina.core.StandardService   : Stopping service [Tomcat]
 32023-05-31T16:52:18.250+08:00  INFO 28432 --- [           main] .s.b.a.l.ConditionEvaluationReportLogger : 
 4
 5......
 6
 7Failed to configure a DataSource: 'url' attribute is not specified and no embedded datasource could be configured.
 8
 9Reason: Failed to determine a suitable driver class
10
11
12Action:
13
14Consider the following:
15  If you want an embedded database (H2, HSQL or Derby), please put it on the classpath.
16  If you have database settings to be loaded from a particular profile you may need to activate it (no profiles are currently active).

1Error creating bean with name 'dataSource' defined in class path resource [org/springframework/boot/autoconfigure/jdbc/DataSourceConfiguration$Hikari.class]: Failed to instantiate [com.zaxxer.hikari.HikariDataSource]: Factory method 'dataSource' threw exception with message: Failed to determine a suitable driver class

1@SpringBootApplication(exclude = {DataSourceAutoConfiguration.class})

 1try (
 2        BufferedReader in = new BufferedReader(new InputStreamReader(socket.getInputStream()));
 3        BufferedWriter out = new BufferedWriter(new OutputStreamWriter(socket.getOutputStream()))
 4) {
 5    String message;
 6    while((message = stdIn.readLine()) != null) {
 7        out.write(message);
 8        out.flush();
 9        System.out.println("Receive from server: " + in.readLine());
10    }
11} catch (Exception e) {
12    System.out.println(e.getMessage());
13}

 1try (
 2        BufferedReader in = new BufferedReader(new InputStreamReader(socket.getInputStream()));
 3        BufferedWriter out = new BufferedWriter(new OutputStreamWriter(socket.getOutputStream()))
 4) {
 5    String message;
 6    while((message = in.readLine()) != null) {
 7        System.out.println(Thread.currentThread().getName() + ": receive from port " + socket.getPort() + ": " + message);
 8        out.write(message);
 9        out.flush();
10    }
11} catch (Exception e) {
12    System.out.println(e.getMessage());
13}

1out.write(message); // 如果使用BufferedWriter，则需要添加换行符
2out.newLine();

1# 清理缓存
2pnpm store prune
3# 删除 node_modules 和 lock 文件
4rm -rf node_modules pnpm-lock.yaml
5# 重新安装依赖
6pnpm install

1spark.sql.storeAssignmentPolicy=LEGACY

1export NODE_OPTIONS=--openssl-legacy-provider

1go build -v -o bepusdt ./main
2github.com/goccy/go-json/internal/encoder/vm
3
4# stuck here

1go clean -cache -modcache -i -r

1ssh-add -K ~/.ssh/id_rsa

1\usepackage{CJKutf8}
2
3\begin{document}
4\begin{CJK}{UTF8}{gbsn}
5...
6\end{CJK}
7\end{document}

1pip install --upgrade --force-reinstall 'requests==2.6.0' urllib3

1<if test="employeeIds != null and employeeIds.size > 0">
2    AND A.EmployeeId in
3    <foreach collection="employeeIds" index="index" item="item" open="(" separator="," close=")">
4        #{item}
5    </foreach>
6</if>
7
8ORDER BY A.FeedId DESC

1org.springframework.jdbc.BadSqlGrammarException

1"-Djdk.tls.disabledAlgorithms=SSLv3, TLSv1.1, RC4, DES, MD5withRSA, DH keySize < 1024, EC keySize < 224, 3DES_EDE_CBC, anon, NULL"

12024-02-05 15:27:34.532 [error]     from typing_extensions import Literal, NotRequired, TypedDict
2  File "/Users/zh/.vscode/extensions/ms-python.python-2024.0.0/pythonFiles/lib/python/typing_extensions.py", line 916
3    def TypedDict(typename, fields=_marker, /, *, total=True, **kwargs):
4                                            ^
5SyntaxError: invalid syntax
6
72024-02-05 15:27:34.544 [error] Subprocess exited unsuccessfully with exit code 1 and signal null on workspace /Users/zh/Codes/jvav. Creating and sending error discovery payload 
8
92024-02-05 15:27:34.544 [error] Unittest test discovery error for workspace:  /Users/zh/Codes/jvav 

1// settings.json
2"python.experiments.optOutFrom": ["pythonTestAdapter"]

1git rm -rf --cached .
2git add .

1location /pay/usdt/ {
2  sub_filter 'src="/img/'  'src="/pay/usdt/img/';
3  sub_filter 'src="/js/' 'src="/pay/usdt/js/' ;
4  sub_filter 'src="/css/' 'src="/pay/usdt/css/' ;
5  sub_filter_once off;
6  
7  proxy_pass http://127.0.0.1:8080/;
8}

1http {
2    include /etc/nginx/mime.types;
3}

1# enter dujiaoka container
2echo "ok" > /dujiaoka/install.lock

1LANG=en_US.utf-8
2LC_ALL=en_US.utf-8

 1version: "3"
 2
 3services:
 4  cache:
 5    image: redis
 6    command: bash -c "mkdir -p ${PATH_REDIS} && touch ${PATH_REDIS}/redis.conf && redis-server ${PATH_REDIS}/redis.conf"
 7    ports:
 8      - "6379:6379"
 9    volumes:
10      - ${HOST_PATH_ROOT}/redis:${PATH_REDIS}
11      - ${HOST_PATH_ROOT}/redis/data:/data
12  web:
13    build: .
14    volumes:
15      - ${HOST_PATH_ROOT}:${PATH_ROOT}
16    depends_on:
17      - cache
18    # network_mode: "host"

1ERROR: 无法连接到 redis 服务: 127.0.0.1:6379 : Error 111 connecting to 127.0.0.1:6379. Connection refused.

1execution error: “System Events”遇到一个错误：“osascript”不允许发送按键。 (1002)

1/.xxx/*
2!/.xxx/jvm.cfg

1git config --global http.sslVerify "false"
2git config --global https.sslVerify "false"

1mv "Menlo for Powerline.ttf" ~/Library/Fonts

1sqlite> select * from t_record where comment != "";
2Parse error: no such column:
3  select * from t_record where comment != "";
4                            error here ---^

1# server side
2vim .zprofile
3export iterm2_hostname=your_server_global_ip
4# then relogin

1ulimit -n 50000

1python3 manage.py migrate --fake <app-name> zero
2python3 manage.py makemigrations <app-name>
3python3 manage.py migrate

1Error while installing lxml through pip: Microsoft Visual C++ 14.0 is required

1ModuleNotFoundError: No module named 'utils.util_bus'; 'utils' is not a package

1(Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:997)')))

1requests.get('https://kennethreitz.com', verify=True)

1PS C:\Users\akyna\Codes\test\test_py> pipenv install
2Usage: pipenv install [OPTIONS] [PACKAGES]...
3
4ERROR:: --system is intended to be used for pre-existing Pipfile installation, not installation of specific packages. Aborting.

1PS C:\Users\akyna\Codes\test\test_py> pipenv --rm
2Removing virtualenv (C:\Users\akyna\.virtualenvs\test_py-_qApXuy4)...

1UnicodeEncodeError: 'latin-1' codec can't encode characters in position 30-34: ordinal not in range(256)

1return {
2    'User-Agent':
3    'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/41.0.2272.101 Safari/537.36',
4    'Host': HOST,
5    'Connection': 'close',
6    'X-Requested-With': 'XMLHttpRequest',
7    'Referer': url.encode('utf-8'), ## fix bug
8}

1## backup
20 1 * * * env code=/root/Codes /bin/bash /root/Codes/scripts/unix/bbak
3## tg send
40 8 * * * env code=/root/Codes /bin/python3 ~/Codes/scripts/py/submit_tg_send.py