[
http://jira.codehaus.org/browse/CONTINUUM-1241?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_97411
]
Andy Jefferson commented on CONTINUUM-1241:
-------------------------------------------
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)
> Schedule fails to start due to derby database column being too small
> --------------------------------------------------------------------
>
> Key: CONTINUUM-1241
> URL: http://jira.codehaus.org/browse/CONTINUUM-1241
> Project: Continuum
> Issue Type: Bug
> Components: Core system
> Affects Versions: 1.0.3
> Environment: Linux
> Reporter: Derek Clarkson
> Priority: Critical
>
> 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.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira