You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@oodt.apache.org by "Verma, Rishi (317I)" <Ri...@jpl.nasa.gov> on 2011/08/23 01:35:02 UTC
CAS-Workflow 04-SNAPSHOT maven test failure
Hi everyone,
I'm receiving a maven test failure when attempting to build (mvn package) CAS-Workflow (the latest trunk code). Does anyone have insight into this particular failure or is anyone able to reproduce?
TEST FAILURE:
Running org.apache.oodt.cas.workflow.repository.TestWorkflowDataSourceRepository
Tests run: 2, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 0.273 sec <<< FAILURE!
STACKTRACE:
java.sql.SQLException: Attempt to insert null into a non-nullable column: column: WORKFLOW_TASK_ID table: WORKFLOW_TASKS
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.execute(Unknown Source)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
at org.apache.oodt.cas.workflow.repository.DataSourceWorkflowRepository.commitTask(DataSourceWorkflowRepository.java:1393)
at org.apache.oodt.cas.workflow.repository.DataSourceWorkflowRepository.getGlobalWorkflowConditionsTask(DataSourceWorkflowRepository.java:1587)
at org.apache.oodt.cas.workflow.repository.DataSourceWorkflowRepository.handleGlobalWorkflowConditions(DataSourceWorkflowRepository.java:1572)
at org.apache.oodt.cas.workflow.repository.DataSourceWorkflowRepository.getWorkflowById(DataSourceWorkflowRepository.java:195)
at org.apache.oodt.cas.workflow.repository.DataSourceWorkflowRepository.getWorkflowById(DataSourceWorkflowRepository.java:165)
at org.apache.oodt.cas.workflow.repository.TestWorkflowDataSourceRepository.testWorkflowConditions(TestWorkflowDataSourceRepository.java:114)
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:164)
at junit.framework.TestCase.runBare(TestCase.java:130)
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:120)
at junit.framework.TestSuite.runTest(TestSuite.java:230)
at junit.framework.TestSuite.run(TestSuite.java:225)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
Re: CAS-Workflow 04-SNAPSHOT maven test failure
Posted by "Mattmann, Chris A (388J)" <ch...@jpl.nasa.gov>.
Hey Guys,
This should be fixed in the latest trunk, see:
https://issues.apache.org/jira/browse/OODT-311
Cheers,
Chris
On Aug 22, 2011, at 4:35 PM, Verma, Rishi (317I) wrote:
> Hi everyone,
>
> I'm receiving a maven test failure when attempting to build (mvn package) CAS-Workflow (the latest trunk code). Does anyone have insight into this particular failure or is anyone able to reproduce?
>
> TEST FAILURE:
> Running org.apache.oodt.cas.workflow.repository.TestWorkflowDataSourceRepository
> Tests run: 2, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 0.273 sec <<< FAILURE!
>
> STACKTRACE:
> java.sql.SQLException: Attempt to insert null into a non-nullable column: column: WORKFLOW_TASK_ID table: WORKFLOW_TASKS
> at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
> at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
> at org.hsqldb.jdbc.jdbcStatement.execute(Unknown Source)
> at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
> at org.apache.oodt.cas.workflow.repository.DataSourceWorkflowRepository.commitTask(DataSourceWorkflowRepository.java:1393)
> at org.apache.oodt.cas.workflow.repository.DataSourceWorkflowRepository.getGlobalWorkflowConditionsTask(DataSourceWorkflowRepository.java:1587)
> at org.apache.oodt.cas.workflow.repository.DataSourceWorkflowRepository.handleGlobalWorkflowConditions(DataSourceWorkflowRepository.java:1572)
> at org.apache.oodt.cas.workflow.repository.DataSourceWorkflowRepository.getWorkflowById(DataSourceWorkflowRepository.java:195)
> at org.apache.oodt.cas.workflow.repository.DataSourceWorkflowRepository.getWorkflowById(DataSourceWorkflowRepository.java:165)
> at org.apache.oodt.cas.workflow.repository.TestWorkflowDataSourceRepository.testWorkflowConditions(TestWorkflowDataSourceRepository.java:114)
> 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:164)
> at junit.framework.TestCase.runBare(TestCase.java:130)
> 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:120)
> at junit.framework.TestSuite.runTest(TestSuite.java:230)
> at junit.framework.TestSuite.run(TestSuite.java:225)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Chris Mattmann, Ph.D.
Senior Computer Scientist
NASA Jet Propulsion Laboratory Pasadena, CA 91109 USA
Office: 171-266B, Mailstop: 171-246
Email: chris.a.mattmann@nasa.gov
WWW: http://sunset.usc.edu/~mattmann/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Adjunct Assistant Professor, Computer Science Department
University of Southern California, Los Angeles, CA 90089 USA
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Re: CAS-Workflow 04-SNAPSHOT maven test failure
Posted by "Verma, Rishi (317I)" <Ri...@jpl.nasa.gov>.
Hi Cecilia,
Thanks for your response. Could you elaborate what you mean by "creating them"?
I would expect building & testing WM would not require any extra work by a user.
I think the problem is the test-case [1] (look at method testWorkflowConditions()) may need some modification. That test-case queries DataSourceWorkflowRepository to get a workflow by the ID number "1". Perhaps some pre-conditions need to be set here? JIRA issue OODT-205 [2] talks about this. Sure enough though, if I ignore this particular test, the build is successful and all other WM tests succeed.
[1] http://svn.apache.org/repos/asf/oodt/trunk/workflow/src/test/org/apache/oodt/cas/workflow/repository/TestWorkflowDataSourceRepository.java
[2] https://issues.apache.org/jira/browse/OODT-205
Thanks,
rishi
On Aug 22, 2011, at 10:16 PM, Cheng, Cecilia S (388K) wrote:
> Hi,
>
> I think the WORKFLOW_TASK_ID is created upon a trigger, using a sequence.
> Have you created them? WORKFLOW_INSTANCES_SEQ and
> WORKFLOW_INSTANCES_TRIGGER?
>
> -- cecilia
>
> On 8/22/11 6:18 PM, "Verma, Rishi (317I)" <Ri...@jpl.nasa.gov> wrote:
>
>> Hi everyone,
>>
>> I'm receiving a maven test failure when attempting to build (mvn package)
>> CAS-Workflow (the latest trunk code). Does anyone have insight into this
>> particular failure or is anyone able to reproduce?
>>
>> TEST FAILURE:
>> Running
>> org.apache.oodt.cas.workflow.repository.TestWorkflowDataSourceRepository
>> Tests run: 2, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 0.273 sec <<<
>> FAILURE!
>>
>> STACKTRACE:
>> java.sql.SQLException: Attempt to insert null into a non-nullable column:
>> column: WORKFLOW_TASK_ID table: WORKFLOW_TASKS
>> at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
>> at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
>> at org.hsqldb.jdbc.jdbcStatement.execute(Unknown Source)
>> at
>> org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:2
>> 61)
>> at
>> org.apache.oodt.cas.workflow.repository.DataSourceWorkflowRepository.commitTas
>> k(DataSourceWorkflowRepository.java:1393)
>> at
>> org.apache.oodt.cas.workflow.repository.DataSourceWorkflowRepository.getGlobal
>> WorkflowConditionsTask(DataSourceWorkflowRepository.java:1587)
>> at
>> org.apache.oodt.cas.workflow.repository.DataSourceWorkflowRepository.handleGlo
>> balWorkflowConditions(DataSourceWorkflowRepository.java:1572)
>> at
>> org.apache.oodt.cas.workflow.repository.DataSourceWorkflowRepository.getWorkfl
>> owById(DataSourceWorkflowRepository.java:195)
>> at
>> org.apache.oodt.cas.workflow.repository.DataSourceWorkflowRepository.getWorkfl
>> owById(DataSourceWorkflowRepository.java:165)
>> at
>> org.apache.oodt.cas.workflow.repository.TestWorkflowDataSourceRepository.testW
>> orkflowConditions(TestWorkflowDataSourceRepository.java:114)
>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>> at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.j
>> ava:25)
>> at java.lang.reflect.Method.invoke(Method.java:597)
>> at junit.framework.TestCase.runTest(TestCase.java:164)
>> at junit.framework.TestCase.runBare(TestCase.java:130)
>> 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:120)
>> at junit.framework.TestSuite.runTest(TestSuite.java:230)
>> at junit.framework.TestSuite.run(TestSuite.java:225)
>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>
Re: CAS-Workflow 04-SNAPSHOT maven test failure
Posted by "Mattmann, Chris A (388J)" <ch...@jpl.nasa.gov>.
Hi Guys,
This test failure appears related to Cecilia's comment below, and I've
been able to reproduce it locally:
-------------------------------------------------------------------------------
Test set: org.apache.oodt.cas.workflow.repository.TestWorkflowDataSourceRepository
-------------------------------------------------------------------------------
Tests run: 2, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 0.38 sec <<< FAILURE!
testWorkflowConditions(org.apache.oodt.cas.workflow.repository.TestWorkflowDataSourceRepository) Time elapsed: 0.282 sec <<< FAILURE!
junit.framework.AssertionFailedError: Attempt to insert null into a non-nullable column: column: WORKFLOW_TASK_ID table: WORKFLOW_TASKS
at junit.framework.Assert.fail(Assert.java:47)
at org.apache.oodt.cas.workflow.repository.TestWorkflowDataSourceRepository.testWorkflowConditions(TestWorkflowDataSourceRepository.java:117)
[chipotle:~/src/oodt/trunk] mattmann%
This seems to be related to some recent Workflow2 (OODT-215 [1]) issues I've been working
on. I'll open up a JIRA and get a fix going for it.
Cheers,
Chris
[1] http://issues.apache.org/jira/browse/OODT-215
On Aug 22, 2011, at 10:16 PM, Cheng, Cecilia S (388K) wrote:
> Hi,
>
> I think the WORKFLOW_TASK_ID is created upon a trigger, using a sequence.
> Have you created them? WORKFLOW_INSTANCES_SEQ and
> WORKFLOW_INSTANCES_TRIGGER?
>
> -- cecilia
>
> On 8/22/11 6:18 PM, "Verma, Rishi (317I)" <Ri...@jpl.nasa.gov> wrote:
>
>> Hi everyone,
>>
>> I'm receiving a maven test failure when attempting to build (mvn package)
>> CAS-Workflow (the latest trunk code). Does anyone have insight into this
>> particular failure or is anyone able to reproduce?
>>
>> TEST FAILURE:
>> Running
>> org.apache.oodt.cas.workflow.repository.TestWorkflowDataSourceRepository
>> Tests run: 2, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 0.273 sec <<<
>> FAILURE!
>>
>> STACKTRACE:
>> java.sql.SQLException: Attempt to insert null into a non-nullable column:
>> column: WORKFLOW_TASK_ID table: WORKFLOW_TASKS
>> at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
>> at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
>> at org.hsqldb.jdbc.jdbcStatement.execute(Unknown Source)
>> at
>> org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:2
>> 61)
>> at
>> org.apache.oodt.cas.workflow.repository.DataSourceWorkflowRepository.commitTas
>> k(DataSourceWorkflowRepository.java:1393)
>> at
>> org.apache.oodt.cas.workflow.repository.DataSourceWorkflowRepository.getGlobal
>> WorkflowConditionsTask(DataSourceWorkflowRepository.java:1587)
>> at
>> org.apache.oodt.cas.workflow.repository.DataSourceWorkflowRepository.handleGlo
>> balWorkflowConditions(DataSourceWorkflowRepository.java:1572)
>> at
>> org.apache.oodt.cas.workflow.repository.DataSourceWorkflowRepository.getWorkfl
>> owById(DataSourceWorkflowRepository.java:195)
>> at
>> org.apache.oodt.cas.workflow.repository.DataSourceWorkflowRepository.getWorkfl
>> owById(DataSourceWorkflowRepository.java:165)
>> at
>> org.apache.oodt.cas.workflow.repository.TestWorkflowDataSourceRepository.testW
>> orkflowConditions(TestWorkflowDataSourceRepository.java:114)
>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>> at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.j
>> ava:25)
>> at java.lang.reflect.Method.invoke(Method.java:597)
>> at junit.framework.TestCase.runTest(TestCase.java:164)
>> at junit.framework.TestCase.runBare(TestCase.java:130)
>> 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:120)
>> at junit.framework.TestSuite.runTest(TestSuite.java:230)
>> at junit.framework.TestSuite.run(TestSuite.java:225)
>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Chris Mattmann, Ph.D.
Senior Computer Scientist
NASA Jet Propulsion Laboratory Pasadena, CA 91109 USA
Office: 171-266B, Mailstop: 171-246
Email: chris.a.mattmann@nasa.gov
WWW: http://sunset.usc.edu/~mattmann/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Adjunct Assistant Professor, Computer Science Department
University of Southern California, Los Angeles, CA 90089 USA
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Re: CAS-Workflow 04-SNAPSHOT maven test failure
Posted by "Cheng, Cecilia S (388K)" <ce...@jpl.nasa.gov>.
Hi,
I think the WORKFLOW_TASK_ID is created upon a trigger, using a sequence.
Have you created them? WORKFLOW_INSTANCES_SEQ and
WORKFLOW_INSTANCES_TRIGGER?
-- cecilia
On 8/22/11 6:18 PM, "Verma, Rishi (317I)" <Ri...@jpl.nasa.gov> wrote:
> Hi everyone,
>
> I'm receiving a maven test failure when attempting to build (mvn package)
> CAS-Workflow (the latest trunk code). Does anyone have insight into this
> particular failure or is anyone able to reproduce?
>
> TEST FAILURE:
> Running
> org.apache.oodt.cas.workflow.repository.TestWorkflowDataSourceRepository
> Tests run: 2, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 0.273 sec <<<
> FAILURE!
>
> STACKTRACE:
> java.sql.SQLException: Attempt to insert null into a non-nullable column:
> column: WORKFLOW_TASK_ID table: WORKFLOW_TASKS
> at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
> at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
> at org.hsqldb.jdbc.jdbcStatement.execute(Unknown Source)
> at
> org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:2
> 61)
> at
> org.apache.oodt.cas.workflow.repository.DataSourceWorkflowRepository.commitTas
> k(DataSourceWorkflowRepository.java:1393)
> at
> org.apache.oodt.cas.workflow.repository.DataSourceWorkflowRepository.getGlobal
> WorkflowConditionsTask(DataSourceWorkflowRepository.java:1587)
> at
> org.apache.oodt.cas.workflow.repository.DataSourceWorkflowRepository.handleGlo
> balWorkflowConditions(DataSourceWorkflowRepository.java:1572)
> at
> org.apache.oodt.cas.workflow.repository.DataSourceWorkflowRepository.getWorkfl
> owById(DataSourceWorkflowRepository.java:195)
> at
> org.apache.oodt.cas.workflow.repository.DataSourceWorkflowRepository.getWorkfl
> owById(DataSourceWorkflowRepository.java:165)
> at
> org.apache.oodt.cas.workflow.repository.TestWorkflowDataSourceRepository.testW
> orkflowConditions(TestWorkflowDataSourceRepository.java:114)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.j
> ava:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at junit.framework.TestCase.runTest(TestCase.java:164)
> at junit.framework.TestCase.runBare(TestCase.java:130)
> 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:120)
> at junit.framework.TestSuite.runTest(TestSuite.java:230)
> at junit.framework.TestSuite.run(TestSuite.java:225)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
CAS-Workflow 04-SNAPSHOT maven test failure
Posted by "Verma, Rishi (317I)" <Ri...@jpl.nasa.gov>.
Hi everyone,
I'm receiving a maven test failure when attempting to build (mvn package) CAS-Workflow (the latest trunk code). Does anyone have insight into this particular failure or is anyone able to reproduce?
TEST FAILURE:
Running org.apache.oodt.cas.workflow.repository.TestWorkflowDataSourceRepository
Tests run: 2, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 0.273 sec <<< FAILURE!
STACKTRACE:
java.sql.SQLException: Attempt to insert null into a non-nullable column: column: WORKFLOW_TASK_ID table: WORKFLOW_TASKS
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.execute(Unknown Source)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
at org.apache.oodt.cas.workflow.repository.DataSourceWorkflowRepository.commitTask(DataSourceWorkflowRepository.java:1393)
at org.apache.oodt.cas.workflow.repository.DataSourceWorkflowRepository.getGlobalWorkflowConditionsTask(DataSourceWorkflowRepository.java:1587)
at org.apache.oodt.cas.workflow.repository.DataSourceWorkflowRepository.handleGlobalWorkflowConditions(DataSourceWorkflowRepository.java:1572)
at org.apache.oodt.cas.workflow.repository.DataSourceWorkflowRepository.getWorkflowById(DataSourceWorkflowRepository.java:195)
at org.apache.oodt.cas.workflow.repository.DataSourceWorkflowRepository.getWorkflowById(DataSourceWorkflowRepository.java:165)
at org.apache.oodt.cas.workflow.repository.TestWorkflowDataSourceRepository.testWorkflowConditions(TestWorkflowDataSourceRepository.java:114)
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:164)
at junit.framework.TestCase.runBare(TestCase.java:130)
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:120)
at junit.framework.TestSuite.runTest(TestSuite.java:230)
at junit.framework.TestSuite.run(TestSuite.java:225)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)