<html>
<head>
<style>
body {
font-family: Verdana, sans-serif;
font-size: 0.8em;
color:#484848;
}
h1, h2, h3 { font-family: "Trebuchet MS", Verdana, sans-serif; margin: 0px; }
h1 { font-size: 1.2em; }
h2, h3 { font-size: 1.1em; }
a, a:link, a:visited { color: #2A5685;}
a:hover, a:active { color: #c61a1a; }
a.wiki-anchor { display: none; }
hr {
width: 100%;
height: 1px;
background: #ccc;
border: 0;
}
.footer {
font-size: 0.8em;
font-style: italic;
}
</style>
</head>
<body>
<span class="header"></span>
Issue #5424 has been updated by Daniel Crawl.
<ul>
<li><strong>Status</strong> changed from <i>New</i> to <i>Resolved</i></li>
<li><strong>Target version</strong> changed from <i>Unspecified</i> to <i>2.5.0</i></li>
</ul>
<p>HSQL updated to v2.</p>
<hr />
<h1><a href="https://projects.ecoinformatics.org/ecoinfo/issues/5424#change-21925">Bug #5424: see if it's worthwhile to upgrade hsql from 1.8</a></h1>
<ul>
<li>Author: Derik Barseghian</li>
<li>Status: Resolved</li>
<li>Priority: Normal</li>
<li>Assignee: Daniel Crawl</li>
<li>Category: provenance</li>
<li>Target version: 2.5.0</li>
<li>Bugzilla-Id: 5424</li>
</ul>
<p>Currently hsql is at v2.2, but we're still using 1.8. There are a number of benefits to upgrading to 2.2. Dan and I discussed it and it seems worthwhile to test, esp to see if performance improves -- we have some really poor performance in some areas. E.g. the growingDegreeDays workflow with days set to 300 can take up to 13m to run with provenance turned on, but <10s with provenance turned off. And bug#5413 discusses how large run deletion from WRM can take way too long.</p>
<p>I tried to upgrade my 1.8 provenance data to 2.2 today, but wasn't able to. I couldn't get a connection made to the db from 2.2. There are errors about the first ALTER line in the provenanceDB.script file:</p>
<p>org.hsqldb.HsqlException: error in script file line: 49 invalid expression in CHECK or GENERATED clause in statement [ALTER TABLE WORKFLOW_EXEC ADD CONSTRAINT WORKFLOW_EXEC_WF_ID_FK FOREIGN <acronym title="WF_ID">KEY</acronym> REFERENCES <acronym title="ID">WORKFLOW</acronym> ON DELETE CASCADE]</p>
<p>I spent some time manually hacking the script file, but wasn't able to figure out what's wrong here...</p>
<hr />
<span class="footer"><p>You have received this notification because you have either subscribed to it, or are involved in it.<br />To change your notification preferences, please click here: <a class="external" href="https://projects.ecoinformatics.org/ecoinfo/my/account">https://projects.ecoinformatics.org/ecoinfo/my/account</a></p></span>
</body>
</html>