Project

General

Profile

Actions
Copy link

Bug #4308

closed

Workflow Run Manager - problem with getWorkflowRunsForExecutions in mysql

Added by Derik Barseghian over 14 years ago. Updated over 14 years ago.

Status:
Resolved
Priority:
Normal
Assignee:
Daniel Crawl
Category:
provenance
Target version:
2.X.Y
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
Copy link
 #1

Updated by Daniel Crawl over 14 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
Copy link
 #2

Updated by Redmine Admin about 11 years ago

Original Bugzilla ID was 4308

Actions
Copy link

Also available in: Atom PDF