SQLInvalidAuthorizationSpecException in TestMultiThreadedKernel

[katzyn]

An unusual random failure in current master on Java 10:

13:52:01 00:00.001 org.h2.test.db.TestMultiThreadedKernel FAIL org.h2.jdbc.JdbcSQLInvalidAuthorizationSpecException: Wrong user name or password [28000-197]
ERROR: FAIL (mvStore AES SOFT_LRU diskUndo diskResult traceLevelFile throttle:1 ) org.h2.jdbc.JdbcSQLInvalidAuthorizationSpecException: Wrong user name or password [28000-197] org.h2.jdbc.JdbcSQLInvalidAuthorizationSpecException: Wrong user name or password [28000-197] ------------------------------
org.h2.jdbc.JdbcSQLInvalidAuthorizationSpecException: Wrong user name or password [28000-197]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:456)
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:425)
	at org.h2.message.DbException.get(DbException.java:203)
	at org.h2.message.DbException.get(DbException.java:179)
	at org.h2.message.DbException.get(DbException.java:168)
	at org.h2.engine.Engine.validateUserAndPassword(Engine.java:362)
	at org.h2.engine.Engine.createSessionAndValidate(Engine.java:186)
	at org.h2.engine.Engine.createSession(Engine.java:161)
	at org.h2.engine.Engine.createSession(Engine.java:31)
	at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:336)
	at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:123)
	at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:102)
	at org.h2.Driver.connect(Driver.java:69)
	at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
	at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:228)
	at org.h2.test.db.TestMultiThreadedKernel.testConcurrentRead(TestMultiThreadedKernel.java:106)
	at org.h2.test.db.TestMultiThreadedKernel.test(TestMultiThreadedKernel.java:48)
	at org.h2.test.TestBase.runTest(TestBase.java:139)
	at org.h2.test.TestAll.addTest(TestAll.java:1018)
	at org.h2.test.TestAll.test(TestAll.java:770)
	at org.h2.test.TestAll.runTests(TestAll.java:665)
	at org.h2.test.TestAll.testAll(TestAll.java:556)
	at org.h2.test.TestAll.run(TestAll.java:506)
	at org.h2.test.TestAll.main(TestAll.java:447)

[forchid]

No concurrent connect() operation in the testConcurrentRead(), this issue looks strange.

[katzyn]

One more in another test case, this time with unencrypted database on Java 7, but there was a previous failure in encrypted mode:

ERROR: FAIL (mvStore AES SOFT_LRU diskUndo diskResult traceLevelFile throttle:1 ) java.lang.Exception: 0 java.lang.Exception: 0 ------------------------------
java.lang.Exception: 0
	at org.h2.test.synth.TestMultiThreaded.test(TestMultiThreaded.java:156)
	at org.h2.test.TestBase.runTest(TestBase.java:139)
	at org.h2.test.TestAll.addTest(TestAll.java:1018)
	at org.h2.test.TestAll.test(TestAll.java:854)
	at org.h2.test.TestAll.runTests(TestAll.java:665)
	at org.h2.test.TestAll.testAll(TestAll.java:556)
	at org.h2.test.TestAll.run(TestAll.java:506)
	at org.h2.test.TestAll.main(TestAll.java:447)
Caused by: java.lang.AssertionError: Expected: 27 got: 29
	at org.h2.test.synth.TestMultiThreaded$Processor.run(TestMultiThreaded.java:87)

2018-09-22 14:52:17 database: wrong user or password; user: "SA"
14:52:17 00:00.000 org.h2.test.synth.TestMultiThreaded FAIL org.h2.jdbc.JdbcSQLInvalidAuthorizationSpecException: Wrong user name or password [28000-197]
ERROR: FAIL (mvStore traceLevelFile defrag ) org.h2.jdbc.JdbcSQLInvalidAuthorizationSpecException: Wrong user name or password [28000-197] org.h2.jdbc.JdbcSQLInvalidAuthorizationSpecException: Wrong user name or password [28000-197] ------------------------------
org.h2.jdbc.JdbcSQLInvalidAuthorizationSpecException: Wrong user name or password [28000-197]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:456)
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:425)
	at org.h2.message.DbException.get(DbException.java:203)
	at org.h2.message.DbException.get(DbException.java:179)
	at org.h2.message.DbException.get(DbException.java:168)
	at org.h2.engine.Engine.validateUserAndPassword(Engine.java:362)
	at org.h2.engine.Engine.createSessionAndValidate(Engine.java:186)
	at org.h2.engine.Engine.createSession(Engine.java:161)
	at org.h2.engine.Engine.createSession(Engine.java:31)
	at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:336)
	at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:123)
	at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:102)
	at org.h2.Driver.connect(Driver.java:69)
	at java.sql.DriverManager.getConnection(DriverManager.java:571)
	at java.sql.DriverManager.getConnection(DriverManager.java:215)
	at org.h2.test.TestDb.getConnectionInternal(TestDb.java:166)
	at org.h2.test.TestDb.getConnection(TestDb.java:38)
	at org.h2.test.synth.TestMultiThreaded.test(TestMultiThreaded.java:131)
	at org.h2.test.TestBase.runTest(TestBase.java:139)
	at org.h2.test.TestAll.addTest(TestAll.java:1018)
	at org.h2.test.TestAll.test(TestAll.java:854)
	at org.h2.test.TestAll.runTests(TestAll.java:674)
	at org.h2.test.TestAll.testAll(TestAll.java:556)
	at org.h2.test.TestAll.run(TestAll.java:506)
	at org.h2.test.TestAll.main(TestAll.java:447)

[katzyn]

Test AES SOFT_LRU diskUndo diskResult traceLevelFile throttle:1  (29625 KB used)

12:08:06 00:00.000 org.h2.test.mvcc.TestMvccMultiThreaded FAIL org.h2.jdbc.JdbcSQLInvalidAuthorizationSpecException: Wrong user name or password [28000-229]
ERROR: FAIL (AES SOFT_LRU diskUndo diskResult traceLevelFile throttle:1 ) org.h2.jdbc.JdbcSQLInvalidAuthorizationSpecException: Wrong user name or password [28000-229] org.h2.jdbc.JdbcSQLInvalidAuthorizationSpecException: Wrong user name or password [28000-229] ------------------------------
org.h2.jdbc.JdbcSQLInvalidAuthorizationSpecException: Wrong user name or password [28000-229]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:522)
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:489)
	at org.h2.message.DbException.get(DbException.java:223)
	at org.h2.message.DbException.get(DbException.java:199)
	at org.h2.message.DbException.get(DbException.java:188)
	at org.h2.engine.Engine.validateUserAndPassword(Engine.java:393)
	at org.h2.engine.Engine.createSession(Engine.java:206)
	at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:338)
	at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:122)
	at org.h2.Driver.connect(Driver.java:59)
	at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
	at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:228)
	at org.h2.test.TestDb.getConnectionInternal(TestDb.java:146)
	at org.h2.test.TestDb.getConnection(TestDb.java:31)
	at org.h2.test.mvcc.TestMvccMultiThreaded.testConcurrentSelectForUpdate(TestMvccMultiThreaded.java:47)
	at org.h2.test.mvcc.TestMvccMultiThreaded.test(TestMvccMultiThreaded.java:39)
	at org.h2.test.TestBase.runTest(TestBase.java:145)
	at org.h2.test.TestAll.addTest(TestAll.java:992)
	at org.h2.test.TestAll.test(TestAll.java:809)
	at org.h2.test.TestAll.runTests(TestAll.java:646)
	at org.h2.test.TestAll.testAll(TestAll.java:550)