benchmarksql和数据库在同一台机器时使用unix域套接字无法正常测试

【标题描述】:
【测试类型：SQL功能/存储功能/接口功能/工具功能/性能/并发/压力长稳/故障注入/安全/资料/编码规范】【测试版本：5.0.0】 benchmarksql和数据库在同一台机器时使用unix域套接字无法正常测试,提示Unexpected connection error

【操作系统和硬件信息】(查询命令: cat /etc/system-release, uname -a):
openEuler 20.03 LTS
【测试环境】(单机/1主x备x级联备):
单主
【被测功能】:
unix 套接字通信
【测试类型】:
性能测试
【数据库版本】(查询命令: gaussdb -V):
5.1.0每日构建版本。
【预置条件】:
1. 已在benchmarksql lib目录预置 java-unix相关的包。
2.配置使用unix套接字：
db=postgres
driver=org.postgresql.Driver
conn=jdbc:postgresql://localhost:30826/tpcc1000?socketFactory=org.newsclub.net.unix.AFUNIXSocketFactory$FactoryArg&socketFactoryArg=/tmp/.s.PGSQL.30826&loggerLevel=OFF
user=xxx
password=xxx

warehouses=1000
loadWorkers=80

terminals=696
//To run specified transactions per terminal- runMins must equal zero
runTxnsPerTerminal=0
//To run for specified minutes- runTxnsPerTerminal must equal zero
runMins=60
//Number of total transactions per minute
limitTxnsPerMin=0

//Set to true to run in 4.x compatible mode. Set to false to use the
//entire configured database evenly.
terminalWarehouseFixed=false

//The following five values must add up to 100
//The default percentages of 45, 43, 4, 4 & 4 match the TPC-C spec
newOrderWeight=45
paymentWeight=43
orderStatusWeight=4
deliveryWeight=4
stockLevelWeight=4

// Directory name to create for collecting detailed result data.
// Comment this out to suppress.
//resultDirectory=my_result_%tY-%tm-%td_%tH%tM%tS
//osCollectorScript=./misc/os_collector_linux.py
//osCollectorInterval=1
//osCollectorSSHAddr=user@dbhost
//osCollectorDevices=net_eth0 blk_sda
【操作步骤】(请填写详细的操作步骤):
1. 启动benchmarksql测试

【预期输出】:
1. 正常输出结果。
【实际输出】:
INFO: [ce6073c5-9e4c-4230-9d80-e23c128ab7a3] Try to connect. IP: localhost:30826
Aug 26, 2023 10:50:25 AM org.postgresql.core.v3.ConnectionFactoryImpl sendStartupPacket
FINE: [ce6073c5-9e4c-4230-9d80-e23c128ab7a3]  FE=> StartupPacket(user=tpcc_bot, database=tpcc1000, client_encoding=UTF8, DateStyle=ISO, TimeZone=Asia/Shanghai, extra_float_digits=2)
Aug 26, 2023 10:50:25 AM org.postgresql.core.v3.ConnectionFactoryImpl doAuthentication
FINEST: [ce6073c5-9e4c-4230-9d80-e23c128ab7a3] AUTH_REQ_SHA256
Aug 26, 2023 10:50:25 AM org.postgresql.core.v3.ConnectionFactoryImpl doAuthentication
FINE: [ce6073c5-9e4c-4230-9d80-e23c128ab7a3]  <=BE AuthenticationOk
Aug 26, 2023 10:50:25 AM org.postgresql.Driver connect
FINE: Unexpected connection error:
java.lang.NullPointerException
        at org.postgresql.core.PGStream.getConnectInfo(PGStream.java:574)
        at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:287)
        at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:53)
        at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:255)
        at org.postgresql.Driver.makeConnection(Driver.java:561)
        at org.postgresql.Driver.connect(Driver.java:314)
        at java.sql.DriverManager.getConnection(DriverManager.java:664)
        at java.sql.DriverManager.getConnection(DriverManager.java:208)
        at jTPCCUtil.getConfig(jTPCCUtil.java:75)
        at jTPCC.<init>(jTPCC.java:307)
        at jTPCC.main(jTPCC.java:53)

【原因分析】:
1. 这个问题的根因
2. 问题推断过程
3. 还有哪些原因可能造成类似现象
4. 该问题是否有临时规避措施
5. 问题解决方案
6. 预计修复问题时间

【日志信息】(请附上日志文件、截图、coredump信息):

【测试代码】:

openGauss/openGauss-connector-jdbc

内容风险标识

评论 (3)

openGauss/openGauss-connector-jdbc .gitee-modal { width: 500px !important; }

内容风险标识