 java.io.FileNotFoundException: /usr/lib/jvm/java-11-openjdk-11.0.20.0.8-2.el8.x86_64/lib/tzdb.dat (No such file or directory) full errror log is : ``` # ------------------------------------------------------------ # Loading SQL file ./sql.common/tableCreates.sql # ------------------------------------------------------------ Picked up JAVA_TOOL_OPTIONS: -Dfile.encoding=UTF8 ERROR StatusLogger Error creating converter for d java.lang.reflect.InvocationTargetException at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at org.apache.logging.log4j.core.pattern.PatternParser.createConverter(PatternParser.java:591) at org.apache.logging.log4j.core.pattern.PatternParser.finalizeConverter(PatternParser.java:658) at org.apache.logging.log4j.core.pattern.PatternParser.parse(PatternParser.java:421) at org.apache.logging.log4j.core.pattern.PatternParser.parse(PatternParser.java:177) at org.apache.logging.log4j.core.layout.PatternLayout$SerializerBuilder.build(PatternLayout.java:397) at org.apache.logging.log4j.core.layout.PatternLayout.<init>(PatternLayout.java:139) at org.apache.logging.log4j.core.layout.PatternLayout.<init>(PatternLayout.java:60) at org.apache.logging.log4j.core.layout.PatternLayout$Builder.build(PatternLayout.java:684) at org.apache.logging.log4j.core.config.AbstractConfiguration.setToDefault(AbstractConfiguration.java:623) at org.apache.logging.log4j.core.config.DefaultConfiguration.<init>(DefaultConfiguration.java:47) at org.apache.logging.log4j.core.LoggerContext.<init>(LoggerContext.java:97) at org.apache.logging.log4j.core.selector.ClassLoaderContextSelector.createContext(ClassLoaderContextSelector.java:248) at org.apache.logging.log4j.core.selector.ClassLoaderContextSelector.locateContext(ClassLoaderContextSelector.java:212) at org.apache.logging.log4j.core.selector.ClassLoaderContextSelector.getContext(ClassLoaderContextSelector.java:136) at org.apache.logging.log4j.core.selector.ClassLoaderContextSelector.getContext(ClassLoaderContextSelector.java:123) at org.apache.logging.log4j.core.selector.ClassLoaderContextSelector.getContext(ClassLoaderContextSelector.java:117) at org.apache.logging.log4j.core.impl.Log4jContextFactory.getContext(Log4jContextFactory.java:150) at org.apache.logging.log4j.core.impl.Log4jContextFactory.getContext(Log4jContextFactory.java:47) at org.apache.logging.log4j.LogManager.getContext(LogManager.java:196) at org.apache.logging.log4j.LogManager.getLogger(LogManager.java:599) at com.github.pgsqlio.benchmarksql.jdbc.ExecJDBC.<clinit>(ExecJDBC.java:25) Caused by: java.lang.Error: java.io.FileNotFoundException: /usr/lib/jvm/java-11-openjdk-11.0.20.0.8-2.el8.x86_64/lib/tzdb.dat (No such file or directory) at java.base/sun.util.calendar.ZoneInfoFile$1.run(ZoneInfoFile.java:261) at java.base/sun.util.calendar.ZoneInfoFile$1.run(ZoneInfoFile.java:251) at java.base/java.security.AccessController.doPrivileged(Native Method) at java.base/sun.util.calendar.ZoneInfoFile.<clinit>(ZoneInfoFile.java:251) at java.base/sun.util.calendar.ZoneInfo.getTimeZone(ZoneInfo.java:588) at java.base/java.util.TimeZone.getTimeZone(TimeZone.java:577) at java.base/java.util.TimeZone.setDefaultZone(TimeZone.java:682) at java.base/java.util.TimeZone.getDefaultRef(TimeZone.java:653) at java.base/java.util.TimeZone.getDefault(TimeZone.java:642) at org.apache.logging.log4j.core.util.datetime.FixedDateFormat.createIfSupported(FixedDateFormat.java:451) at org.apache.logging.log4j.core.pattern.DatePatternConverter.createFormatter(DatePatternConverter.java:194) at org.apache.logging.log4j.core.pattern.DatePatternConverter.<init>(DatePatternConverter.java:183) at org.apache.logging.log4j.core.pattern.DatePatternConverter.newInstance(DatePatternConverter.java:208) ... 25 more Caused by: java.io.FileNotFoundException: /usr/lib/jvm/java-11-openjdk-11.0.20.0.8-2.el8.x86_64/lib/tzdb.dat (No such file or directory) at java.base/java.io.FileInputStream.open0(Native Method) at java.base/java.io.FileInputStream.open(FileInputStream.java:219) at java.base/java.io.FileInputStream.<init>(FileInputStream.java:157) at java.base/sun.util.calendar.ZoneInfoFile$1.run(ZoneInfoFile.java:255) ... 37 more ERROR StatusLogger Unrecognized conversion specifier [d] starting at position 16 in conversion pattern. Exception in thread "main" java.lang.NoClassDefFoundError: Could not initialize class sun.util.calendar.ZoneInfoFile at java.base/sun.util.calendar.ZoneInfo.getTimeZone(ZoneInfo.java:588) at java.base/java.util.TimeZone.getTimeZone(TimeZone.java:577) at java.base/java.util.TimeZone.setDefaultZone(TimeZone.java:682) at java.base/java.util.TimeZone.getDefaultRef(TimeZone.java:653) at java.base/java.util.TimeZone.getDefault(TimeZone.java:642) at java.base/java.util.Calendar.defaultTimeZone(Calendar.java:1679) at java.base/java.util.Calendar.getInstance(Calendar.java:1660) at java.base/java.text.SimpleDateFormat.initializeCalendar(SimpleDateFormat.java:676) at java.base/java.text.SimpleDateFormat.<init>(SimpleDateFormat.java:620) at java.base/java.text.SimpleDateFormat.<init>(SimpleDateFormat.java:599) at org.apache.logging.log4j.status.StatusData.getFormattedStatus(StatusData.java:122) at org.apache.logging.log4j.status.StatusConsoleListener.log(StatusConsoleListener.java:81) at org.apache.logging.log4j.status.StatusLogger.logMessage(StatusLogger.java:277) at org.apache.logging.log4j.spi.AbstractLogger.log(AbstractLogger.java:2117) at org.apache.logging.log4j.spi.AbstractLogger.tryLogMessage(AbstractLogger.java:2205) at org.apache.logging.log4j.spi.AbstractLogger.logMessageTrackRecursion(AbstractLogger.java:2159) at org.apache.logging.log4j.spi.AbstractLogger.logMessageSafely(AbstractLogger.java:2142) at org.apache.logging.log4j.spi.AbstractLogger.logMessage(AbstractLogger.java:2017) at org.apache.logging.log4j.spi.AbstractLogger.logIfEnabled(AbstractLogger.java:1983) at org.apache.logging.log4j.spi.AbstractLogger.error(AbstractLogger.java:750) at org.apache.logging.log4j.core.pattern.PatternParser.createConverter(PatternParser.java:600) at org.apache.logging.log4j.core.pattern.PatternParser.finalizeConverter(PatternParser.java:658) at org.apache.logging.log4j.core.pattern.PatternParser.parse(PatternParser.java:421) at org.apache.logging.log4j.core.pattern.PatternParser.parse(PatternParser.java:177) at org.apache.logging.log4j.core.layout.PatternLayout$SerializerBuilder.build(PatternLayout.java:397) at org.apache.logging.log4j.core.layout.PatternLayout.<init>(PatternLayout.java:139) at org.apache.logging.log4j.core.layout.PatternLayout.<init>(PatternLayout.java:60) at org.apache.logging.log4j.core.layout.PatternLayout$Builder.build(PatternLayout.java:684) at org.apache.logging.log4j.core.layout.PatternLayout$Builder.build(PatternLayout.java:541) at org.apache.logging.log4j.core.config.plugins.util.PluginBuilder.build(PluginBuilder.java:122) at org.apache.logging.log4j.core.config.AbstractConfiguration.createPluginObject(AbstractConfiguration.java:1000) at org.apache.logging.log4j.core.config.AbstractConfiguration.createConfiguration(AbstractConfiguration.java:940) at org.apache.logging.log4j.core.config.AbstractConfiguration.createConfiguration(AbstractConfiguration.java:932) at org.apache.logging.log4j.core.config.AbstractConfiguration.createConfiguration(AbstractConfiguration.java:932) at org.apache.logging.log4j.core.config.AbstractConfiguration.doConfigure(AbstractConfiguration.java:551) at org.apache.logging.log4j.core.config.AbstractConfiguration.initialize(AbstractConfiguration.java:241) at org.apache.logging.log4j.core.config.AbstractConfiguration.start(AbstractConfiguration.java:287) at org.apache.logging.log4j.core.LoggerContext.setConfiguration(LoggerContext.java:627) at org.apache.logging.log4j.core.LoggerContext.reconfigure(LoggerContext.java:700) at org.apache.logging.log4j.core.LoggerContext.reconfigure(LoggerContext.java:717) at org.apache.logging.log4j.core.LoggerContext.start(LoggerContext.java:272) at org.apache.logging.log4j.core.impl.Log4jContextFactory.getContext(Log4jContextFactory.java:155) at org.apache.logging.log4j.core.impl.Log4jContextFactory.getContext(Log4jContextFactory.java:47) at org.apache.logging.log4j.LogManager.getContext(LogManager.java:196) at org.apache.logging.log4j.LogManager.getLogger(LogManager.java:599) at com.github.pgsqlio.benchmarksql.jdbc.ExecJDBC.<clinit>(ExecJDBC.java:25) BenchmarkSQL terminated with exit code 1 ``` my config is ``` db=postgres //驱动程序,每种数据库有对应的驱动 driver=org.postgresql.Driver conn= jdbc:postgresql//172.23.250.45:5432/benchmark user=postgres password=mysecretpassword //仓库数量 warehouses=4 //初始化数据的加载进程数量,默认为4,实际使用可以结合os性能做配置 loadWorkers=4 //终端数,即并发客户端数量,通常设置为CPU线程总数的2~6倍 terminals=4 //每个终端运行的固定事务数量,如该值为10, 则每个terminal运行10个事务,如果有32个终端,那整体运行320个事务后,测试结束。该参数配置为非0值时,下面的runMins参数必须设置为0。 runTxnsPerTerminal=0 //runMins表示要压测的时间长度,单位为分钟。该值为非0值时,runTxnsPerTerminal参数必须设置为0。这两个参数不能同时设置为正整数,如果设置其中一个,另一个必须为0,主要区别是runMins定义时间长度来控制测试时间;runTxnsPerTerminal定义事务总数来控制时间。 runMins=5 //Number of total transactions per minute limitTxnsPerMin=0 //终端和仓库的绑定模式,设置为true时可以运行4.x兼容模式,意思为每个终端都有一个固定的仓库。设置为false时可以均匀的使用数据库整体配置。TPCC规定每个终端都必须有一个绑定的仓库,所以一般使用默认值true。 terminalWarehouseFixed=true //下面五个值的总和必须等于100,默认值为:45, 43, 4, 4,4 ,与TPC-C测试定义的比例一致,实际操作过程中,可以调整比重来适应各种场景。 newOrderWeight=45 paymentWeight=43 orderStatusWeight=4 deliveryWeight=4 stockLevelWeight=4 ```