Project

General

Profile

Actions

Bug #4308

closed

Workflow Run Manager - problem with getWorkflowRunsForExecutions in mysql

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

Actions #1

Updated by Daniel Crawl about 15 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.

Actions #2

Updated by Redmine Admin over 11 years ago

Original Bugzilla ID was 4308

Actions

Also available in: Atom PDF