New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

TestSuite fails with -DpreferQueryMode=extendedCacheEverything #955

Closed
jorsol opened this Issue Sep 22, 2017 · 1 comment

Comments

Projects
None yet
2 participants
@jorsol
Contributor

jorsol commented Sep 22, 2017

Test Suite fails with with -DpreferQueryMode=extendedCacheEverything
A bug in extendedCacheEverything?

Running org.postgresql.test.jdbc2.AutoRollbackTestSuite
Tests run: 96, Failures: 0, Errors: 2, Skipped: 0, Time elapsed: 1.174 sec <<< FAILURE! - in org.postgresql.test.jdbc2.AutoRollbackTestSuite
run[37: autorollback(autoSave=ALWAYS, autoCommit=YES, failMode=DEALLOCATE, continueMode=COMMIT, flushOnDeallocate=false)](org.postgresql.test.jdbc2.AutoRollbackTestSuite)  Time elapsed: 0.042 sec  <<< ERROR!
org.postgresql.util.PSQLException: ERROR: transacción abortada, las órdenes serán ignoradas hasta el fin de bloque de transacción
  Location: File: postgres.c, Routine: exec_parse_message, Line: 1295
  SQLState del servidor: 25P02.
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2477)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2190)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:300)
	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:428)
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:354)
	at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:301)
	at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:287)
	at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:264)
	at org.postgresql.jdbc.PgStatement.executeUpdate(PgStatement.java:244)
	at org.postgresql.test.jdbc2.AutoRollbackTestSuite.doCommit(AutoRollbackTestSuite.java:345)
	at org.postgresql.test.jdbc2.AutoRollbackTestSuite.run(AutoRollbackTestSuite.java:225)

run[43: autorollback(autoSave=ALWAYS, autoCommit=YES, failMode=DISCARD, continueMode=COMMIT, flushOnDeallocate=false)](org.postgresql.test.jdbc2.AutoRollbackTestSuite)  Time elapsed: 0.014 sec  <<< ERROR!
org.postgresql.util.PSQLException: ERROR: transacción abortada, las órdenes serán ignoradas hasta el fin de bloque de transacción
  Location: File: postgres.c, Routine: exec_parse_message, Line: 1295
  SQLState del servidor: 25P02.
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2477)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2190)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:300)
	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:428)
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:354)
	at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:301)
	at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:287)
	at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:264)
	at org.postgresql.jdbc.PgStatement.executeUpdate(PgStatement.java:244)
	at org.postgresql.test.jdbc2.AutoRollbackTestSuite.doCommit(AutoRollbackTestSuite.java:345)
	at org.postgresql.test.jdbc2.AutoRollbackTestSuite.run(AutoRollbackTestSuite.java:225)
testSetLocalDateTime(org.postgresql.test.jdbc42.SetObject310Test)  Time elapsed: 0.217 sec  <<< FAILURE!
org.junit.ComparisonFailure: expected:<2000-03-26 0[2]:00:00> but was:<2000-03-26 0[3]:00:00>
	at org.junit.Assert.assertEquals(Assert.java:115)
	at org.junit.Assert.assertEquals(Assert.java:144)
	at org.postgresql.test.jdbc42.SetObject310Test.localTimestamps(SetObject310Test.java:244)
	at org.postgresql.test.jdbc42.SetObject310Test.testSetLocalDateTime(SetObject310Test.java:182)
@vlsi

This comment has been minimized.

Member

vlsi commented Jan 8, 2018

@jorsol , good catch.
Timezone issue will be covered in #1053

@vlsi vlsi added this to the 42.2.0 milestone Jan 8, 2018

rhavermans added a commit to bolcom/pgjdbc that referenced this issue Jul 13, 2018

fix: execute autosave/rollback savepoint via simple queries always to…
… prevent "statement S_xx not exists" when autosaving

Fixes AutoRollbackTestSuite in extendedCacheEverything mode

fixes pgjdbc#955

rhavermans added a commit to bolcom/pgjdbc that referenced this issue Jul 13, 2018

fix: execute autosave/rollback savepoint via simple queries always to…
… prevent "statement S_xx not exists" when autosaving

Fixes AutoRollbackTestSuite in extendedCacheEverything mode

fixes pgjdbc#955
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment