Errors encountered when running JDBC testcases from OptionalTestSuite against vPG10.2

From: cathryn <9333724(at)qq(dot)com>
To: pgsql-jdbc <pgsql-jdbc(at)postgresql(dot)org>
Subject: Errors encountered when running JDBC testcases from OptionalTestSuite against vPG10.2
Date: 2018-03-01 04:48:17
Message-ID: tencent_331EEFC93A7B2B8E3297EED1FE23CFF7C607@qq.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Dear Sir/Mandam
I am running JDBC testsuites against vPG10.2, but encounter below error:
test: [junit] Testsuite: org.postgresql.test.jdbc2.optional.OptionalTestSuite [junit] Tests run: 58, Failures: 6, Errors: 2, Skipped: 1, Time elapsed: 4.175 sec
[junit] Mar 01, 2018 3:42:42 AM org.postgresql.ds.common.BaseDataSource getConnection [junit] SEVERE: Failed to create a Non-Pooling DataSource from PostgreSQL JDBC Driver 42.2.1 for test at jdbc:postgresql://10.143.17.239:5432/test?loggerLevel=null&prepareThreshold=5&preparedStatementCacheQueries=256&preparedStatementCacheSizeMiB=5&databaseMetadataCacheFields=65536&databaseMetadataCacheFieldsMiB=5&defaultRowFetchSize=0&binaryTransfer=true&readOnly=false&binaryTransferEnable=&binaryTransferDisable=&unknownLength=2147483647&logUnclosedConnections=false&disableColumnSanitiser=false&tcpKeepAlive=false&loginTimeout=0&connectTimeout=10&socketTimeout=0&cancelSignalTimeout=10&receiveBufferSize=-1&sendBufferSize=-1&ApplicationName=PostgreSQL JDBC Driver&jaasLogin=true&useSpnego=false&gsslib=auto&sspiServiceClass=POSTGRES&allowEncodingChanges=false&targetServerType=any&loadBalanceHosts=false&hostRecheckSeconds=10&preferQueryMode=extended&autosave=never&reWriteBatchedInserts=false: org.postgresql.util.PSQLException: Something unusual has occurred to cause the driver to fail. Please report this exception. [junit] Mar 01, 2018 3:42:42 AM org.postgresql.Driver connect [junit] SEVERE: Unexpected connection error: [junit] java.lang.NullPointerException [junit] at java.util.logging.Handler.setLevel(Handler.java:263) [junit] at org.postgresql.Driver.setupLoggerFromProperties(Driver.java:342) [junit] at org.postgresql.Driver.connect(Driver.java:240) [junit] at java.sql.DriverManager.getConnection(DriverManager.java:664) [junit] at java.sql.DriverManager.getConnection(DriverManager.java:247) [junit] at org.postgresql.ds.common.BaseDataSource.getConnection(BaseDataSource.java:94) [junit] at org.postgresql.ds.common.BaseDataSource.getConnection(BaseDataSource.java:79) [junit] at org.postgresql.test.jdbc2.optional.BaseDataSourceTest.getDataSourceConnection(BaseDataSourceTest.java:76) [junit] at org.postgresql.test.jdbc2.optional.BaseDataSourceTest.testUseConnection(BaseDataSourceTest.java:125) [junit] at org.postgresql.test.jdbc2.optional.BaseDataSourceTest.testJndi(BaseDataSourceTest.java:210) [junit] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [junit] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [junit] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [junit] at java.lang.reflect.Method.invoke(Method.java:498) [junit] at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50) [junit] at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) [junit] at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47) [junit] at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17) [junit] at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26) [junit] at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27) [junit] at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325) [junit] at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78) [junit] at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57) [junit] at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290) [junit] at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71) [junit] at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288) [junit] at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58) [junit] at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268) [junit] at org.junit.runners.ParentRunner.run(ParentRunner.java:363) [junit] at org.junit.runners.Suite.runChild(Suite.java:128) [junit] at org.junit.runners.Suite.runChild(Suite.java:27) [junit] at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290) [junit] at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71) [junit] at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288) [junit] at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58) [junit] at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268) [junit] at org.junit.runners.ParentRunner.run(ParentRunner.java:363) [junit] at junit.framework.JUnit4TestAdapter.run(JUnit4TestAdapter.java:38) [junit] at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.run(JUnitTestRunner.java:535) [junit] at org.apache.tools.ant.taskdefs.optional.junit.JUnitTask.executeInVM(JUnitTask.java:1647) [junit] at org.apache.tools.ant.taskdefs.optional.junit.JUnitTask.execute(JUnitTask.java:1047) [junit] at org.apache.tools.ant.taskdefs.optional.junit.JUnitTask.executeOrQueue(JUnitTask.java:2207) [junit] at org.apache.tools.ant.taskdefs.optional.junit.JUnitTask.execute(JUnitTask.java:858) [junit] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:293) [junit] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [junit] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [junit] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [junit] at java.lang.reflect.Method.invoke(Method.java:498) [junit] at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) [junit] at org.apache.tools.ant.Task.perform(Task.java:348) [junit] at org.apache.tools.ant.Target.execute(Target.java:435) [junit] at org.apache.tools.ant.Target.performTasks(Target.java:456) [junit] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1405) [junit] at org.apache.tools.ant.Project.executeTarget(Project.java:1376) [junit] at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41) [junit] at org.apache.tools.ant.Project.executeTargets(Project.java:1260) [junit] at org.apache.tools.ant.Main.runBuild(Main.java:857) [junit] at org.apache.tools.ant.Main.startAnt(Main.java:236) [junit] at org.apache.tools.ant.launch.Launcher.run(Launcher.java:287) [junit] at org.apache.tools.ant.launch.Launcher.main(Launcher.java:113)

Below testcases from suite OptionalTestSuite failed or error:

[junit] Testcase: testGetURL took 0.093 sec [junit] Caused an ERROR [junit] Something unusual has occurred to cause the driver to fail. Please report this exception. [junit] org.postgresql.util.PSQLException: Something unusual has occurred to cause the driver to fail. Please report this exception. [junit] at org.postgresql.Driver.connect(Driver.java:275) [junit] at java.sql.DriverManager.getConnection(DriverManager.java:664) [junit] at java.sql.DriverManager.getConnection(DriverManager.java:247) [junit] at org.postgresql.ds.common.BaseDataSource.getConnection(BaseDataSource.java:94) [junit] at org.postgresql.ds.common.BaseDataSource.getConnection(BaseDataSource.java:79) [junit] at org.postgresql.test.jdbc2.optional.BaseDataSourceTest.getDataSourceConnection(BaseDataSourceTest.java:76) [junit] at org.postgresql.test.jdbc2.optional.SimpleDataSourceWithSetURLTest.testGetURL(SimpleDataSourceWithSetURLTest.java:40) [junit] Caused by: java.lang.NullPointerException [junit] at java.util.logging.Handler.setLevel(Handler.java:263) [junit] at org.postgresql.Driver.setupLoggerFromProperties(Driver.java:342) [junit] at org.postgresql.Driver.connect(Driver.java:240) [junit] [junit] Testcase: testSetURL took 0.041 sec [junit] FAILED [junit] expected: null<null> but was: java.lang.String<null> [junit] junit.framework.AssertionFailedError: expected: null<null> but was: java.lang.String<null> [junit] at org.postgresql.test.jdbc2.optional.SimpleDataSourceWithSetURLTest.testSetURL(SimpleDataSourceWithSetURLTest.java:60) [junit] [junit] Testcase: testJndi took 0.056 sec [junit] FAILED [junit] Something unusual has occurred to cause the driver to fail. Please report this exception. [junit] junit.framework.AssertionFailedError: Something unusual has occurred to cause the driver to fail. Please report this exception. [junit] at org.postgresql.test.jdbc2.optional.BaseDataSourceTest.testUseConnection(BaseDataSourceTest.java:143) [junit] at org.postgresql.test.jdbc2.optional.BaseDataSourceTest.testJndi(BaseDataSourceTest.java:210) [junit] [junit] Testcase: testUseConnection took 0.063 sec [junit] FAILED [junit] Something unusual has occurred to cause the driver to fail. Please report this exception. [junit] junit.framework.AssertionFailedError: Something unusual has occurred to cause the driver to fail. Please report this exception. [junit] at org.postgresql.test.jdbc2.optional.BaseDataSourceTest.testUseConnection(BaseDataSourceTest.java:143) [junit] [junit] Testcase: testPGConnection took 0.049 sec [junit] FAILED [junit] Unable to call PGConnection method on pooled connection due to org.postgresql.util.PSQLException (Something unusual has occurred to cause the driver to fail. Please report this exception.) [junit] junit.framework.AssertionFailedError: Unable to call PGConnection method on pooled connection due to org.postgresql.util.PSQLException (Something unusual has occurred to cause the driver to fail. Please report this exception.) [junit] at org.postgresql.test.jdbc2.optional.BaseDataSourceTest.testPGConnection(BaseDataSourceTest.java:186) [junit] [junit] Testcase: testGetConnection took 0.054 sec [junit] FAILED [junit] Something unusual has occurred to cause the driver to fail. Please report this exception. [junit] junit.framework.AssertionFailedError: Something unusual has occurred to cause the driver to fail. Please report this exception. [junit] at org.postgresql.test.jdbc2.optional.BaseDataSourceTest.testGetConnection(BaseDataSourceTest.java:115) [junit] [junit] Testcase: testNotPooledConnection took 0.063 sec [junit] Caused an ERROR [junit] Something unusual has occurred to cause the driver to fail. Please report this exception. [junit] org.postgresql.util.PSQLException: Something unusual has occurred to cause the driver to fail. Please report this exception. [junit] at org.postgresql.Driver.connect(Driver.java:275) [junit] at java.sql.DriverManager.getConnection(DriverManager.java:664) [junit] at java.sql.DriverManager.getConnection(DriverManager.java:247) [junit] at org.postgresql.ds.common.BaseDataSource.getConnection(BaseDataSource.java:94) [junit] at org.postgresql.ds.common.BaseDataSource.getConnection(BaseDataSource.java:79) [junit] at org.postgresql.test.jdbc2.optional.BaseDataSourceTest.getDataSourceConnection(BaseDataSourceTest.java:76) [junit] at org.postgresql.test.jdbc2.optional.BaseDataSourceTest.testNotPooledConnection(BaseDataSourceTest.java:167) [junit] Caused by: java.lang.NullPointerException [junit] at java.util.logging.Handler.setLevel(Handler.java:263) [junit] at org.postgresql.Driver.setupLoggerFromProperties(Driver.java:342) [junit] at org.postgresql.Driver.connect(Driver.java:240) [junit] [junit] Testcase: testDdlOverConnection took 0.051 sec [junit] FAILED [junit] Something unusual has occurred to cause the driver to fail. Please report this exception. [junit] junit.framework.AssertionFailedError: Something unusual has occurred to cause the driver to fail. Please report this exception. [junit] at org.postgresql.test.jdbc2.optional.BaseDataSourceTest.testDdlOverConnection(BaseDataSourceTest.java:157)

Could you give me guidence about this error? Thanks in advance.

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Andres Freund 2018-03-02 04:10:01 Re: [HACKERS] Statement-level rollback
Previous Message Chris Dole 2018-02-27 21:19:21 MyBatis Batch Update Leads to PSQLException "Too many update results were returned"