Project

General

Profile

Bug #4308

Workflow Run Manager - problem with getWorkflowRunsForExecutions in mysql

Added by Derik Barseghian almost 10 years ago. Updated over 9 years ago.

Status:
Resolved
Priority:
Normal
Assignee:
Category:
provenance
Target version:
Start date:
08/12/2009
Due date:
% Done:

0%

Estimated time:
Bugzilla-Id:
4308

Description

Dan gets an error from WRM when using a mysql provenance store:

[run] org.kepler.provenance.QueryException: Unable to query workflow runs: Cannot convert value '0000-00-00 00:00:00' from column 6 to TIMESTAMP.
[run] at org.kepler.provenance.sql.SQLQueryV8.getWorkflowRunsForExecutions(SQLQueryV8.java:348)

Also, WRM hasn't been tested with mysql for a very long time (just hsql). We should try to test all functions.

History

#1 Updated by Daniel Crawl over 9 years ago

Fixed. The query for workflow runs was not valid in MySQL. Also, by default MySQL throws an exception when querying the zero time value "0000-00-00 00:00:00". I changed the connection string to instead return null.

#2 Updated by Redmine Admin about 6 years ago

Original Bugzilla ID was 4308

Also available in: Atom PDF