Project

General

Profile

Bug #4308

Workflow Run Manager - problem with getWorkflowRunsForExecutions in mysql

Added by Derik Barseghian over 10 years ago. Updated about 10 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 about 10 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 over 6 years ago

Original Bugzilla ID was 4308

Also available in: Atom PDF