org.postgresql.util.PSQLException: ERROR: null value in column "priority" violates not-null constraint

Terracotta | brad1973 | 7 years ago
  1. 0

    ERROR: null value in column "priority" violates not-null constraint

    terracotta.org | 6 months ago
    org.postgresql.util.PSQLException: ERROR: null value in column "priority" violates not-null constraint
  2. 0

    ERROR: null value in column "priority" violates not-null constraint

    Terracotta | 7 years ago | brad1973
    org.postgresql.util.PSQLException: ERROR: null value in column "priority" violates not-null constraint
  3. 0

    JBOSS and JPA query- Adding a new customer

    Stack Overflow | 2 years ago | Lalin Pethiyagoda
    javax.ejb.EJBException: javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not insert: [com.shop.entity.Customer]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    WARN [org.jboss.tm.TransactionImpl] Transaction TransactionImpl:XidImpl[FormatId=257, GlobalId=nutxt-db1/3, BranchQual=, localId=3] timed out. status=STATUS_ACTIVE When restarting Jboss, it took about 12minutes before showing "timed out" and after a while a postgres sql error occurs : 2008-07-01 10:03:09,563 WARN [org.jboss.tm.TransactionImpl] XAException: tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=nutxt-db1/154326, BranchQual=, localId=154326] errorCode=XAER_RMERR org.jboss.mq.SpyXAException: Resource manager error during commit; - nested throwable: (org.jboss.mq.SpyTransactionRolledBackException: Transaction was rolled back.; - nested throwable: (org.jboss.mq.SpyJMSException: Could not store message: 56987 msg=9191 hard NOT_STORED PERSISTENT queue=TOPIC.NXPMessages.ID:10.-2147483648 priority=4 lateClone=false hashCode=22499078; - nested throwable: (org.postgresql.util.PSQLException: ERROR: duplicate key violates unique constraint "jms_messages_pkey"))) at org.jboss.mq.SpyXAException.getAsXAException(SpyXAException.java:72) at org.jboss.mq.SpyXAResource.commit(SpyXAResource.java:92) at org.jboss.tm.TransactionImpl$Resource.commit(TransactionImpl.java:2253) at org.jboss.tm.TransactionImpl.commitResources(TransactionImpl.java:1784) at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:340) at org.jboss.tm.TxManager.commit(TxManager.java:240) at org.jboss.aspects.tx.TxPolicy.endTransaction(TxPolicy.java:175) at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:87) at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:191) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:76) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.ejb3.stateful.StatefulInstanceInterceptor.invoke(StatefulInstanceInterceptor.java:83) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.aspects.security.RoleBasedAuthorizationInterceptor.invoke(RoleBasedAuthorizationInterceptor.java:166) at org.jboss.ejb3.security.RoleBasedAuthorizationInterceptor.invoke(RoleBasedAuthorizationInterceptor.java:108) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:77) at org.jboss.ejb3.security.Ejb3AuthenticationInterceptor.invoke(Ejb3AuthenticationInterceptor.java:102) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:47) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:106) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101) at org.jboss.ejb3.stateful.StatefulContainer.dynamicInvoke(StatefulContainer.java:319) at org.jboss.aop.Dispatcher.invoke(Dispatcher.java:106) at org.jboss.aspects.remoting.AOPRemotingInvocationHandler.invoke(AOPRemotingInvocationHandler.java:82) at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:828) at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:681) at org.jboss.remoting.transport.socket.ServerThread.processInvocation(ServerThread.java:358) at org.jboss.remoting.transport.socket.ServerThread.dorun(ServerThread.java:412) at org.jboss.remoting.transport.socket.ServerThread.run(ServerThread.java:239) Caused by: org.jboss.mq.SpyTransactionRolledBackException: Transaction was rolled back.; - nested throwable: (org.jboss.mq.SpyJMSException: Could not store message: 56987 msg=9191 hard NOT_STORED PERSISTENT queue=TOPIC.NXPMessages.ID:10.-2147483648 priority=4 lateClone=false hashCode=22499078; - nested throwable: (org.postgresql.util.PSQLException: ERROR: duplicate key violates unique constraint "jms_messages_pkey")) at org.jboss.mq.server.JMSDestinationManager.transact(JMSDestinationManager.java:450) at org.jboss.mq.server.JMSServerInterceptorSupport.transact(JMSServerInterceptorSupport.java:126) at org.jboss.mq.security.ServerSecurityInterceptor.transact(ServerSecurityInterceptor.java:197) at org.jboss.mq.server.TracingInterceptor.transact(TracingInterceptor.java:352) at org.jboss.mq.server.JMSServerInvoker.transact(JMSServerInvoker.java:132) at org.jboss.mq.il.uil2.ServerSocketManagerHandler.handleMsg(ServerSocketManagerHandler.java:191) at org.jboss.mq.il.uil2.SocketManager$ReadTask.handleMsg(SocketManager.java:395) at org.jboss.mq.il.uil2.msgs.BaseMsg.run(BaseMsg.java:398) at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:748) at java.lang.Thread.run(Thread.java:595) Caused by: org.jboss.mq.SpyJMSException: Could not store message: 56987 msg=9191 hard NOT_STORED PERSISTENT queue=TOPIC.NXPMessages.ID:10.-2147483648 priority=4 lateClone=false hashCode=22499078; - nested throwable: (org.postgresql.util.PSQLException: ERROR: duplicate key violates unique constraint "jms_messages_pkey") at org.jboss.mq.pm.jdbc2.PersistenceManager.saveToStorage(PersistenceManager.java:1646) at org.jboss.mq.server.MessageCache.saveToStorage(MessageCache.java:420) at org.jboss.mq.server.MessageReference.makeSoft(MessageReference.java:312) at org.jboss.mq.server.MessageCache.validateSoftReferenceDepth(MessageCache.java:367) at org.jboss.mq.server.MessageCache.addInternal(MessageCache.java:158) at org.jboss.mq.server.MessageCache.add(MessageCache.java:128) at org.jboss.mq.server.JMSTopic.addMessage(JMSTopic.java:416) at org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationManager.java:415) at org.jboss.mq.server.JMSDestinationManager.transact(JMSDestinationManager.java:434) ... 9 more Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key violates unique constraint "jms_messages_pkey" at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:305) at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:251) at org.jboss.mq.pm.jdbc2.PersistenceManager.add(PersistenceManager.java:1136) at org.jboss.mq.pm.jdbc2.PersistenceManager.saveToStorage(PersistenceManager.java:1632) ... 17 more

    JIRA | 8 years ago | Sun Tan
    org.jboss.mq.SpyXAException: Resource manager error during commit; - nested throwable: (org.jboss.mq.SpyTransactionRolledBackException: Transaction was rolled back.; - nested throwable: (org.jboss.mq.SpyJMSException: Could not store message: 56987 msg=9191 hard NOT_STORED PERSISTENT queue=TOPIC.NXPMessages.ID:10.-2147483648 priority=4 lateClone=false hashCode=22499078; - nested throwable: (org.postgresql.util.PSQLException: ERROR: duplicate key violates unique constraint "jms_messages_pkey")))
  6. 0

    jBPM exception logging can block execution of all processes

    https://bugzilla.redhat.com/bugzilla/ | 7 years ago | Jiri Pechanec
    org.hibernate.exception.DataException: could not update: [org.jbpm.job.ExecuteActionJob#35]

  1. silex 2 times, last 2 weeks ago
  2. silex 18 times, last 6 months ago
20 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. org.postgresql.util.PSQLException

    ERROR: null value in column "priority" violates not-null constraint

    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse()
  2. PostgreSQL JDBC Driver
    AbstractJdbc2Statement.executeUpdate
    1. org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
    2. org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
    3. org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
    4. org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
    5. org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
    6. org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321)
    6 frames
  3. JBoss Application Server Connector
    WrappedPreparedStatement.executeUpdate
    1. org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:365)
    1 frame
  4. quartz
    QuartzSchedulerThread.run
    1. org.quartz.impl.jdbcjobstore.StdJDBCDelegate.insertFiredTrigger(StdJDBCDelegate.java:3360)
    2. org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:1771)
    3. org.quartz.impl.jdbcjobstore.JobStoreCMT.acquireNextTrigger(JobStoreCMT.java:1177)
    4. org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:233)
    4 frames