ddl upgrade does not make columns non - null

Michael Gettes  14 minutes ago

tomee;catalina.out;dev;dev;2021-10-21 12:47:15,818 [ajp-nio-0.0.0.0-8009-exec-2] ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper- Batch entry 0 insert into grouper_password_recently_used (hibernate_version_number, grouper_password_id, jwt_jti, jwt_iat, attempt_millis, ip_address, status, id) values (0, ‘255001b753134c958f5d6fe83a9e61eb’, NULL, NULL, 1634834835793, ‘173.1.3.234’, ‘S’, ‘00a7c4f23c6b4499b63db5bc278f181b’) was aborted: ERROR: null value in column “jwt_jti” violates not-null constraint

  Detail: Failing row contains (00a7c4f23c6b4499b63db5bc278f181b, 255001b753134c958f5d6fe83a9e61eb, null, null, 1634834835793, 173.1.3.234, S, 0).  Call getNextException to see other errors in the batch.

tomee;catalina.out;dev;dev;2021-10-21 12:47:15,818 [ajp-nio-0.0.0.0-8009-exec-2] WARN  org.hibernate.engine.jdbc.spi.SqlExceptionHelper- SQL Error: 0, SQLState: 23502

tomee;catalina.out;dev;dev;2021-10-21 12:47:15,819 [ajp-nio-0.0.0.0-8009-exec-2] ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper- ERROR: null value in column “jwt_jti” violates not-null constraint

  Detail: Failing row contains (00a7c4f23c6b4499b63db5bc278f181b, 255001b753134c958f5d6fe83a9e61eb, null, null, 1634834835793, 173.1.3.234, S, 0).

tomee;catalina.out;dev;dev;2021-10-21 12:47:15,820 [ajp-nio-0.0.0.0-8009-exec-2] ERROR org.hibernate.engine.jdbc.batch.internal.BatchingBatch- HHH000315: Exception executing batch [could not execute batch]

grouper;grouper_error.log;dev;dev;2021-10-21 12:47:15,823: [ajp-nio-0.0.0.0-8009-exec-2] ERROR GrouperUtil.logErrorNextException(1084) -  - Next exception

org.postgresql.util.PSQLException: ERROR: null value in column “jwt_jti” violates not-null constraint

  Detail: Failing row contains (00a7c4f23c6b4499b63db5bc278f181b, 255001b753134c958f5d6fe83a9e61eb, null, null, 1634834835793, 173.1.3.234, S, 0).

	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2553)

	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2285)

	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:521)

	at org.postgresql.jdbc.PgStatement.internalExecuteBatch(PgStatement.java:878)

	at org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:901)

	at org.postgresql.jdbc.PgPreparedStatement.executeBatch(PgPreparedStatement.java:1644)

	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:2544)

	at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:110)

	at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExecuteBatch(BatchingBatch.java:97)

	at org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.execute(AbstractBatchImpl.java:147)

	at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.executeBatch(JdbcCoordinatorImpl.java:214)

	at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:611)

	at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:456)

	at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:337)

	at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39)

	at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1282)

	at edu.internet2.middleware.grouper.hibernate.ByObject.saveOrUpdate(ByObject.java:479)

	at edu.internet2.middleware.grouper.hibernate.ByObjectStatic$5.callback(ByObjectStatic.java:376)

	at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:703)

	at edu.internet2.middleware.grouper.hibernate.ByObjectStatic.saveOrUpdate(ByObjectStatic.java:363)

	at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3GrouperPasswordRecentlyUsedDAO.saveOrUpdate(Hib3GrouperPasswordRecentlyUsedDAO.java:84)

	at edu.internet2.middleware.grouper.j2ee.Authentication.authenticate(Authentication.java:279)

	at edu.internet2.middleware.grouper.ui.GrouperUiFilter.doFilter(GrouperUiFilter.java:1104)

	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)

	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)

	at org.apache.tomee.catalina.OpenEJBValve.invoke(OpenEJBValve.java:44)

	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:543)

	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)

	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)

	at org.apache.tomee.catalina.OpenEJBSecurityListener$RequestCapturer.invoke(OpenEJBSecurityListener.java:97)

	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)

	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)

	at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:524)

	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)

	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:818)

	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1626)

	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)

	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

	at java.lang.Thread.run(Thread.java:748)