<style>
/* Changing the layout to use less space for mobiles */
@media screen and (max-device-width: 480px), screen and (-webkit-min-device-pixel-ratio: 2) {
#email-body { min-width: 30em !important; }
#email-page { padding: 8px !important; }
#email-banner { padding: 8px 8px 0 8px !important; }
#email-avatar { margin: 1px 8px 8px 0 !important; padding: 0 !important; }
#email-fields { padding: 0 8px 8px 8px !important; }
#email-gutter { width: 0 !important; }
}
</style>
<div id="email-body">
<table id="email-wrap" align="center" border="0" cellpadding="0" cellspacing="0" style="background-color:#f0f0f0;color:#000000;width:100%;">
<tr valign="top">
<td id="email-page" style="padding:16px !important;">
<table align="center" border="0" cellpadding="0" cellspacing="0" style="background-color:#ffffff;border:1px solid #bbbbbb;color:#000000;width:100%;">
<tr valign="top">
<td bgcolor="#ffffff" style="background-color:#ffffff;color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;line-height:1;"><img src="https://shibboleth.net/images/shib_240x83.png" alt="" style="vertical-align:top;" /></td>
</tr><tr valign="top">
<td id="email-banner" style="padding:32px 32px 0 32px;">
<table align="left" border="0" cellpadding="0" cellspacing="0" width="100%" style="width:100%;">
<tr valign="top">
<td style="color:#505050;font-family:Arial,FreeSans,Helvetica,sans-serif;padding:0;">
<img id="email-avatar" src="https://issues.shibboleth.net/jira/secure/useravatar?ownerId=rdw%40iay.org.uk&avatarId=10124" alt="" height="48" width="48" border="0" align="left" style="padding:0;margin: 0 16px 16px 0;" />
<div id="email-action" style="padding: 0 0 8px 0;font-size:12px;line-height:18px;">
<a class="user-hover" rel="rdw@iay.org.uk" id="email_rdw@iay.org.uk" href="https://issues.shibboleth.net/jira/secure/ViewProfile.jspa?name=rdw%40iay.org.uk" style="color:#326ca6;">Rod Widdowson</a>
created <img src="https://issues.shibboleth.net/jira/images/icons/issuetypes/bug.png" height="16" width="16" border="0" align="absmiddle" alt="Bug"> <a style='color:#326ca6;text-decoration:none;' href='https://issues.shibboleth.net/jira/browse/IDP-426'>IDP-426</a>
</div>
<div id="email-summary" style="font-size:16px;line-height:20px;padding:2px 0 16px 0;">
<a style='color:#326ca6;text-decoration:none;' href='https://issues.shibboleth.net/jira/browse/IDP-426'><strong>Test interaction between pooling and HSQLDB</strong></a>
</div>
</td>
</tr>
</table>
</td>
</tr>
<tr valign="top">
<td id="email-fields" style="padding:0 32px 32px 32px;">
<table border="0" cellpadding="0" cellspacing="0" style="padding:0;text-align:left;width:100%;" width="100%">
<tr valign="top">
<td id="email-gutter" style="width:64px;white-space:nowrap;"></td>
<td>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Issue Type:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
<img src="https://issues.shibboleth.net/jira/images/icons/issuetypes/bug.png" height="16" width="16" border="0" align="absmiddle" alt="Bug"> Bug
</td>
</tr> <tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Affects Versions:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
3.0.0-alpha1 </td>
</tr>
<tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Assignee:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
<a class="user-hover" rel="dfisher@vt.edu" id="email_dfisher@vt.edu" href="https://issues.shibboleth.net/jira/secure/ViewProfile.jspa?name=dfisher%40vt.edu" style="color:#326ca6;">Daniel W Fisher</a>
</td>
</tr> <tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Components:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
Attribute Resolver </td>
</tr>
<tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Created:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
29/Jun/14 7:05 AM
</td>
</tr> <tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Description:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
<p style='margin-top:0;margin-bottom:10px;'>I'll start this with Daniel in the hope that he can see an easy solution.</p>
<p style='margin-top:0;margin-bottom:10px;'>This is test only, but it may indicate a deeper issue.</p>
<p style='margin-top:0;margin-bottom:10px;'>It seems that mchange and HSQLDB have a mismatch somewhere.</p>
<p style='margin-top:0;margin-bottom:10px;'>I was testing the StoredId connector parser and I wanted to do a parser/connector back to back.</p>
<p style='margin-top:0;margin-bottom:10px;'>During operation of the storedID connector we get a hang</p>
<p style='margin-top:0;margin-bottom:10px;'>Object.wait(long) line: not available <span class="error">[native method]</span> <br/>
BasicResourcePool.awaitAvailable(long) line: 1414 <br/>
BasicResourcePool.prelimCheckoutResource(long) line: 606 <br/>
BasicResourcePool.checkoutResource(long) line: 526 <br/>
C3P0PooledConnectionPool.checkoutAndMarkConnectionInUse() line: 755 <br/>
C3P0PooledConnectionPool.checkoutPooledConnection() line: 682 <br/>
ComboPooledDataSource(AbstractPoolBackedDataSource).getConnection() line: 140 <br/>
JDBCPersistentIdStore.getActiveEntry(String, String, String) line: 391 <br/>
StoredPersistentIdGenerationStrategy.generate(String, String, String, String) line: 107 <br/>
StoredIDDataConnector.doDataConnectorResolve(AttributeResolutionContext, AttributeResolverWorkContext) line: 165 <br/>
StoredIDDataConnector(AbstractDataConnector).doResolve(AttributeResolutionContext, AttributeResolverWorkContext) line: 85 <br/>
StoredIDDataConnector(AbstractDataConnector).doResolve(AttributeResolutionContext, AttributeResolverWorkContext) line: 1 <br/>
StoredIDDataConnector(AbstractResolverPlugin<ResolvedType>).resolve(AttributeResolutionContext) line: 194 <br/>
AttributeResolverImpl.resolveDataConnector(String, AttributeResolutionContext) line: 310 <br/>
AttributeResolverImpl.resolveDependencies(ResolverPlugin<?>, AttributeResolutionContext) line: 360 <br/>
AttributeResolverImpl.resolveAttributeDefinition(String, AttributeResolutionContext) line: 263 <br/>
AttributeResolverImpl.resolveAttributes(AttributeResolutionContext) line: 197 </p>
<p style='margin-top:0;margin-bottom:10px;'>Meanwhile one of the worker threads is looping throwing this stack</p>
<p style='margin-top:0;margin-bottom:10px;'>ERROR <span class="error">[hsqldb.db.HSQLDB46E749F0CD.ENGINE:-1]</span> - could not reopen database<br/>
org.hsqldb.HsqlException: Database lock acquisition failure: lockFile: org.hsqldb.persist.LockFile@fce35892<span class="error">[file =null, exists=false, locked=false, valid=false, ]</span> method: setPath reason: java.io.IOException: The filename, directory name, or volume label syntax is incorrect<br/>
at org.hsqldb.error.Error.error(Unknown Source) ~<span class="error">[hsqldb-2.2.9.jar:2.2.9]</span><br/>
at org.hsqldb.error.Error.error(Unknown Source) ~<span class="error">[hsqldb-2.2.9.jar:2.2.9]</span><br/>
at org.hsqldb.persist.LockFile.newLockFileLock(Unknown Source) ~<span class="error">[hsqldb-2.2.9.jar:2.2.9]</span><br/>
at org.hsqldb.persist.Logger.acquireLock(Unknown Source) ~<span class="error">[hsqldb-2.2.9.jar:2.2.9]</span><br/>
at org.hsqldb.persist.Logger.openPersistence(Unknown Source) ~<span class="error">[hsqldb-2.2.9.jar:2.2.9]</span><br/>
at org.hsqldb.Database.reopen(Unknown Source) ~<span class="error">[hsqldb-2.2.9.jar:2.2.9]</span><br/>
at org.hsqldb.Database.open(Unknown Source) ~<span class="error">[hsqldb-2.2.9.jar:2.2.9]</span><br/>
at org.hsqldb.DatabaseManager.getDatabase(Unknown Source) <span class="error">[hsqldb-2.2.9.jar:2.2.9]</span><br/>
at org.hsqldb.DatabaseManager.newSession(Unknown Source) <span class="error">[hsqldb-2.2.9.jar:2.2.9]</span><br/>
at org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source) <span class="error">[hsqldb-2.2.9.jar:2.2.9]</span><br/>
at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source) <span class="error">[hsqldb-2.2.9.jar:2.2.9]</span><br/>
at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source) <span class="error">[hsqldb-2.2.9.jar:2.2.9]</span><br/>
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:131) <span class="error">[c3p0-0.9.2.1.jar:0.9.2.1]</span><br/>
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:156) <span class="error">[c3p0-0.9.2.1.jar:0.9.2.1]</span><br/>
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:145) <span class="error">[c3p0-0.9.2.1.jar:0.9.2.1]</span><br/>
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:200) <span class="error">[c3p0-0.9.2.1.jar:0.9.2.1]</span><br/>
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1086) <span class="error">[c3p0-0.9.2.1.jar:0.9.2.1]</span><br/>
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1073) <span class="error">[c3p0-0.9.2.1.jar:0.9.2.1]</span><br/>
at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:44) <span class="error">[c3p0-0.9.2.1.jar:0.9.2.1]</span><br/>
at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1810) <span class="error">[c3p0-0.9.2.1.jar:0.9.2.1]</span><br/>
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:648) <span class="error">[mchange-commons-java-0.2.3.4.jar:na]</span></p>
<p style='margin-top:0;margin-bottom:10px;'>To provoke this just enable the test reverseMap inside net.shibboleth.idp.attribute.resolver.spring.pc.StoredIdTest</p>
</td>
</tr>
<tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Fix Versions:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
3.0.0 </td>
</tr>
<tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Project:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
<a style="color:#326ca6;" href="https://issues.shibboleth.net/jira/browse/IDP">Identity Provider</a>
</td>
</tr> <tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Priority:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
<img src="https://issues.shibboleth.net/jira/images/icons/priorities/major.png" height="16" width="16" border="0" align="absmiddle" alt="Major"> Major
</td>
</tr>
<tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Reporter:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
<a class="user-hover" rel="rdw@iay.org.uk" id="email_rdw@iay.org.uk" href="https://issues.shibboleth.net/jira/secure/ViewProfile.jspa?name=rdw%40iay.org.uk" style="color:#326ca6;">Rod Widdowson</a>
</td>
</tr> <tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Original Estimate:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
4 hours
</td>
</tr>
<tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Remaining Estimate:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
4 hours
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td><!-- End #email-page -->
</tr>
<tr valign="top">
<td style="color:#505050;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:10px;line-height:14px;padding: 0 16px 16px 16px;text-align:center;">
This message is automatically generated by JIRA.<br />
If you think it was sent incorrectly, please contact your JIRA administrators<br />
For more information on JIRA, see: <a style='color:#326ca6;' href='http://www.atlassian.com/software/jira'>http://www.atlassian.com/software/jira</a>
</td>
</tr>
</table><!-- End #email-wrap -->
</div><!-- End #email-body -->