<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 #5278 has been updated by Daniel Crawl.
<ul>
<li><strong>Status</strong> changed from <i>New</i> to <i>Resolved</i></li>
</ul>
<p>This is now fixed: separate HSQL servers are launched for each user. To prevent port conflicts, the port number is randomly chosen before the server starts.</p>
<hr />
<h1><a href="https://projects.ecoinformatics.org/ecoinfo/issues/5278#change-20375">Bug #5278: HSQL database is shared between users</a></h1>
<ul>
<li>Author: Daniel Crawl</li>
<li>Status: Resolved</li>
<li>Priority: Normal</li>
<li>Assignee: Daniel Crawl</li>
<li>Category: core</li>
<li>Target version: Unspecified</li>
<li>Bugzilla-Id: 5278</li>
</ul>
<p>Kepler starts an HSQL database server so that multiple instances of Kepler can run on the same machine. (For more info on this, see bug 2315). However, this is problematic on machines shared by<br />different users: the server started by the first user is accessed by subsequent Kepler instances run by other users. (This causes several problems including: the actor tree displayed in subsequent Kepler instances displays the actors in the suite of the first instance, the default directory for File->Open in subsequent Kepler instances belongs to the first user, etc.).</p>
<p>To fix this bug, different database servers should be started for different users to prevent sharing. Additionally, the same database server must be used for multiple instances of Kepler ran by the<br />same user otherwise the database files will be corrupted. (Note that a single Kepler instance may run three different servers: one for the cache, one for LSID stuff, and one for provenance. None of these should be shared between different users).</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>