Re: [Treebase-devel] Hibernate_sequence need a bigger value

[youjun g. <you...@ya...>]

Vladimir,

Look at the end of this error massage which I got minutes ago, hibernate get
this  id from sequence:

TAXONLABEL_ID =14220 that is far less than the max id in the table and it is
already exist.

To make change on the sequence run this sql query: alter sequence
hibernate_sequence restart with 300000.

300000 just a example, you can find the max id in these tables and make it
the bigest + 1.

Youjun

Tests run: 2, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 4.047 sec
<<< FAILURE!
testAddDelete(org.cipres.treebase.service.matrix.MatrixServiceImplTest)
Time elapsed: 1.016 sec  <<< ERROR!
org.springframework.dao.DataIntegrityViolationException: Could not execute
JDBC batch update; nested exception is
org.hibernate.exception.ConstraintViolationException: Could not execute JDBC
batch update
Caused by: org.hibernate.exception.ConstraintViolationException: Could not
execute JDBC batch update
    at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
    at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
    at
org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)
    at
org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:92)
    at
org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:87)
    at
org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:222)
    at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2229)
    at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2665)
    at
org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:60)
    at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
    at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
    at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
    at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
    at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
    at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
    at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
    at
org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
    at
org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:578)
    at
org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:662)
    at
org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:632)
    at
org.springframework.test.AbstractTransactionalSpringContextTests.endTransaction(AbstractTransactionalSpringContextTests.java:293)
    at
org.cipres.treebase.service.matrix.MatrixServiceImplTest.testAddDelete(MatrixServiceImplTest.java:232)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at junit.framework.TestCase.runTest(TestCase.java:154)
    at junit.framework.TestCase.runBare(TestCase.java:127)
    at
org.springframework.test.ConditionalTestCase.runBare(ConditionalTestCase.java:69)
    at junit.framework.TestResult$1.protect(TestResult.java:106)
    at junit.framework.TestResult.runProtected(TestResult.java:124)
    at junit.framework.TestResult.run(TestResult.java:109)
    at junit.framework.TestCase.run(TestCase.java:118)
    at junit.framework.TestSuite.runTest(TestSuite.java:208)
    at junit.framework.TestSuite.run(TestSuite.java:203)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at
org.apache.maven.surefire.junit.JUnitTestSet.execute(JUnitTestSet.java:213)
    at
org.apache.maven.surefire.suite.AbstractDirectoryTestSuite.executeTestSet(AbstractDirectoryTestSuite.java:140)
    at
org.apache.maven.surefire.suite.AbstractDirectoryTestSuite.execute(AbstractDirectoryTestSuite.java:127)
    at org.apache.maven.surefire.Surefire.run(Surefire.java:177)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at
org.apache.maven.surefire.booter.SurefireBooter.runSuitesInProcess(SurefireBooter.java:338)
    at
org.apache.maven.surefire.booter.SurefireBooter.main(SurefireBooter.java:997)
Caused by: java.sql.BatchUpdateException: Batch entry 0 insert into
TAXONLABEL (VERSION, LINKED, STUDY_ID, TaxonLabel, TAXONVARIANT_ID,
TAXONLABEL_ID) values (0, 0, NULL, testAddDelete test 0.3318026555702662,
NULL, 14220) was aborted.  Call getNextException to see the cause.