Continuum

Schedule fails to start due to derby database column being too small

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Critical Critical
  • Resolution: Fixed
  • Affects Version/s: 1.0.3
  • Fix Version/s: 1.1-beta-1
  • Component/s: Core system
  • Labels:
    None
  • Environment:
    Linux
  • Complexity:
    Intermediate
  • Number of attachments :
    0

Description

When the schedular trys to start a build we get the following error:

INFO | jvm 1 | 2007/04/10 10:30:08 | ERROR 22001: A truncation error was encountered trying to shrink VARCHAR '/Magrathea/trunk/bizstation-magrathea/customer-core/src/main&' to length 255.
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.apache.derby.iapi.types.SQLChar.hasNonBlankChars(Unknown Source)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.apache.derby.iapi.types.SQLVarchar.normalize(Unknown Source)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.apache.derby.iapi.types.SQLVarchar.normalize(Unknown Source)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.apache.derby.iapi.types.DataTypeDescriptor.normalize(Unknown Source)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.apache.derby.impl.sql.execute.NormalizeResultSet.normalizeRow(Unknown Source)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.apache.derby.impl.sql.execute.NormalizeResultSet.getNextRowCore(Unknown Source)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.apache.derby.impl.sql.execute.DMLWriteResultSet.getNextRowCore(Unknown Source)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(Unknown Source)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.jpox.store.rdbms.request.Request.executeUpdate(Request.java:78)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.jpox.store.rdbms.request.InsertRequest.execute(InsertRequest.java:258)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java:2146)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.jpox.store.StoreManager.insert(StoreManager.java:739)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.jpox.state.StateManagerImpl.internalMakePersistent(StateManagerImpl.java:3415)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.jpox.state.StateManagerImpl.makePersistent(StateManagerImpl.java:3388)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.jpox.AbstractPersistenceManager.internalMakePersistent(AbstractPersistenceManager.java:1146)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.jpox.AbstractPersistenceManager.makePersistentInternal(AbstractPersistenceManager.java:1187)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.jpox.store.rdbms.scostore.InverseListStore.validateElementForWriting(InverseListStore.java:1061)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.jpox.store.rdbms.scostore.InverseListStore.internalAdd(InverseListStore.java:672)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.jpox.store.rdbms.scostore.AbstractListStore.addAll(AbstractListStore.java:322)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.jpox.store.mapping.CollectionMapping.postInsert(CollectionMapping.java:236)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.jpox.store.rdbms.request.InsertRequest.execute(InsertRequest.java:396)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java:2146)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.jpox.store.StoreManager.insert(StoreManager.java:739)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.jpox.state.StateManagerImpl.internalMakePersistent(StateManagerImpl.java:3415)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.jpox.state.StateManagerImpl.makePersistent(StateManagerImpl.java:3388)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.jpox.AbstractPersistenceManager.internalMakePersistent(AbstractPersistenceManager.java:1146)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.jpox.AbstractPersistenceManager.makePersistentInternal(AbstractPersistenceManager.java:1187)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.jpox.store.rdbms.scostore.InverseListStore.validateElementForWriting(InverseListStore.java:1061)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.jpox.store.rdbms.scostore.InverseListStore.internalAdd(InverseListStore.java:672)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.jpox.store.rdbms.scostore.AbstractListStore.addAll(AbstractListStore.java:322)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.jpox.store.mapping.CollectionMapping.postInsert(CollectionMapping.java:236)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.jpox.store.rdbms.request.InsertRequest.execute(InsertRequest.java:396)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java:2146)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.jpox.store.StoreManager.insert(StoreManager.java:739)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.jpox.state.StateManagerImpl.internalMakePersistent(StateManagerImpl.java:3415)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.jpox.state.StateManagerImpl.makePersistent(StateManagerImpl.java:3388)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.jpox.AbstractPersistenceManager.internalMakePersistent(AbstractPersistenceManager.java:1146)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.jpox.AbstractPersistenceManager.makePersistentInternal(AbstractPersistenceManager.java:1187)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.jpox.store.mapping.PersistenceCapableMapping.setObject(PersistenceCapableMapping.java:409)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.jpox.store.rdbms.fieldmanager.ParameterSetter.storeObjectField(ParameterSetter.java:132)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.jpox.state.StateManagerImpl.providedObjectField(StateManagerImpl.java:2627)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.apache.maven.continuum.model.project.BuildResult.jdoProvideField(BuildResult.java)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.apache.maven.continuum.model.project.BuildResult.jdoProvideFields(BuildResult.java)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.jpox.state.StateManagerImpl.provideFields(StateManagerImpl.java:2964)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.jpox.store.rdbms.request.InsertRequest.execute(InsertRequest.java:231)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java:2146)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.jpox.store.StoreManager.insert(StoreManager.java:739)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.jpox.state.StateManagerImpl.internalMakePersistent(StateManagerImpl.java:3415)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.jpox.state.StateManagerImpl.makePersistent(StateManagerImpl.java:3388)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.jpox.AbstractPersistenceManager.internalMakePersistent(AbstractPersistenceManager.java:1146)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.jpox.AbstractPersistenceManager.makePersistent(AbstractPersistenceManager.java:1201)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.codehaus.plexus.jdo.PlexusJdoUtils.makePersistent(PlexusJdoUtils.java:97)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.apache.maven.continuum.store.JdoContinuumStore.makePersistent(JdoContinuumStore.java:524)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.apache.maven.continuum.store.JdoContinuumStore.addBuildResult(JdoContinuumStore.java:265)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.apache.maven.continuum.core.action.ExecuteBuilderContinuumAction.execute(ExecuteBuilderContinuumAction.java:115)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.apache.maven.continuum.buildcontroller.DefaultBuildController.build(DefaultBuildController.java:275)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.apache.maven.continuum.buildcontroller.BuildProjectTaskExecutor.executeTask(BuildProjectTaskExecutor.java:47)
INFO | jvm 1 | 2007/04/10 10:30:08 | at org.codehaus.plexus.taskqueue.execution.ThreadedTaskQueueExecutor$ExecutorRunnable.run(ThreadedTaskQueueExecutor.java:103)
INFO | jvm 1 | 2007/04/10 10:30:08 | at java.lang.Thread.run(Thread.java:595)
INFO | jvm 1 | 2007/04/10 10:30:08 | 2007-04-10 10:30:08,210 [Thread-2] ERROR BuildController - Error while building project.
INFO | jvm 1 | 2007/04/10 10:30:08 | javax.jdo.JDODataStoreException: Insert request failed: INSERT INTO CHANGEFILE (CHANGEFILE_ID,REVISION,MODEL_ENCODING,"NAME",STATUS) VALUES (?,?,?,?,?)

...

Please fix as continuous builds are broken.

Issue Links

This issue depends upon:
CONTINUUM-1338 field name in class org.apache.maven.continuum.model.scm is too small Major Closed

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Andy Jefferson added a comment -

The JPOX log defines what SQL is invoked, with what values passed in. You can easily consult your schema for what the table is defined as. So why not post them back here so there is basis for comment? Probably there is some column that only accepts data up to a particular size and maybe Continuum is alowing input to be greater? (guessing)

Show
Andy Jefferson added a comment - The JPOX log defines what SQL is invoked, with what values passed in. You can easily consult your schema for what the table is defined as. So why not post them back here so there is basis for comment? Probably there is some column that only accepts data up to a particular size and maybe Continuum is alowing input to be greater? (guessing)
Hide
Permalink
Derek Clarkson added a comment -

Actually never heard of JPOX before this and wasn't aware it produced any log. We basically established through experimentation that it's the length of a svn log line that causes the issue. Keeping them under 255 seems to avoid the bug.

Show
Derek Clarkson added a comment - Actually never heard of JPOX before this and wasn't aware it produced any log. We basically established through experimentation that it's the length of a svn log line that causes the issue. Keeping them under 255 seems to avoid the bug.

People

Vote (0)
Watch (0)

Dates

  • Created:
    Updated:
    Resolved:
Atlassian JIRA (v4.4.3#663-r165197) | Report a problem
Powered by a free Atlassian JIRA open source license for Codehaus. Try JIRA - bug tracking software for your team.