ChangeSentMessageSynchWorkerIntegrationTest failures

Description

Following the Developer Bootstrap having a freshly cloned repository from the develop branch with an empty database a couple of tests are failing when running (just mvn install) against a local instance of MySQL 8 in the ChangeSentMessageSynchWorkerIntegrationTest, in particular:

  • testPLFM_2844

  • testMissing

Both tests fail for the same reason: the waitForSynchState() due to unsynchded messages. The following stack trace is produced by the ChangeSentMessageSyncWorker:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 2019-06-06T18:26:13,945 [mainScheduler_Worker-30] ERROR org.sagebionetworks.workers.util.semaphore.SemaphoreGatedRunnerImpl - Error on key changeSentMessageSynch: org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [SELECT C.* FROM CHANGES C LEFT OUTER JOIN SENT_MESSAGES S ON (C.CHANGE_NUM = S.CHANGE_NUM)WHERE S.CHANGE_NUM IS NULL AND C.CHANGE_NUM >= ? AND C.CHANGE_NUM <= ? AND C.TIME_STAMP <= ? ORDER BY CHANGE_NUM]; SQL state [HY000]; error code [1525]; Incorrect TIMESTAMP value: '292278994-08-16 23:11:55.807'; nested exception is java.sql.SQLException: Incorrect TIMESTAMP value: '292278994-08-16 23:11:55.807' at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:89) ~[spring-jdbc-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) ~[spring-jdbc-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) ~[spring-jdbc-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1444) ~[spring-jdbc-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:632) ~[spring-jdbc-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:669) ~[spring-jdbc-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:700) ~[spring-jdbc-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:712) ~[spring-jdbc-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:768) ~[spring-jdbc-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.sagebionetworks.repo.model.dbo.dao.DBOChangeDAOImpl.listUnsentMessages(DBOChangeDAOImpl.java:351) ~[classes/:?] at org.sagebionetworks.repo.model.dbo.dao.DBOChangeDAOImpl$$FastClassBySpringCGLIB$$70a75174.invoke(<generated>) ~[classes/:?] at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:749) ~[spring-aop-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:88) ~[spring-aop-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.sagebionetworks.profiler.Profiler.doBasicProfiling(Profiler.java:37) ~[classes/:?] at sun.reflect.GeneratedMethodAccessor21.invoke(Unknown Source) ~[?:?] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_212] at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_212] at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:644) ~[spring-aop-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:633) ~[spring-aop-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70) ~[spring-aop-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:93) ~[spring-aop-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688) ~[spring-aop-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.sagebionetworks.repo.model.dbo.dao.DBOChangeDAOImpl$$EnhancerBySpringCGLIB$$d297a4fb.listUnsentMessages(<generated>) ~[classes/:?] at org.sagebionetworks.change.workers.ChangeSentMessageSynchWorker.run(ChangeSentMessageSynchWorker.java:113) ~[classes/:?]

 

Environment

OS: Windows 10 Pro x64
JDK: 1.8 (from https://adoptopenjdk.net/)
MySQL: 8.0.16
MySQL JDBC Driver: 8.0.11 (from the dependencies)

Status

Assignee

Marco Marasca

Reporter

Marco Marasca

Labels

Validator

Ziming Dong

Release Version History

None

Sprint

None

Fix versions

Priority

Minor