More on ORA-08177: can't serialize access for this transaction

[Lionel Samuel]

From:
https://wiki.shibboleth.net/confluence/display/IDP30/StoredIdConnector?focusedCommentId=24773494#comment-24773494

Updated to below........

 <resolver:DataConnector id="myStoredId" xsi:type="dc:StoredId"
generatedAttributeID="persistentID"
sourceAttributeID="%{idp.persistentId.sourceAttribute}" salt="XXXX"
queryTimeout="PT2S" retryableErrors="#{{'72000'}}">
            <resolver:Dependency ref="%{idp.persistentId.sourceAttribute}"
/>

<dc:BeanManagedConnection>OracleSource</dc:BeanManagedConnection>
          </resolver:DataConnector>

But still getting errors - now obviously with 'Error retryable, but retry
limit exceeded' -- any tips on options?

017-09-13 17:39:18,358 - WARN
[net.shibboleth.idp.saml.nameid.impl.JDBCPersistentIdStoreEx:623] - Stored
Id Store: Error retryable, but retry limit exceeded
2017-09-13 17:39:18,368 - ERROR
[net.shibboleth.idp.profile.impl.ResolveAttributes:299] - Profile Action
ResolveAttributes: Error resolving attributes
net.shibboleth.idp.attribute.resolver.ResolutionException:
org.opensaml.saml.common.SAMLException: ID storage error obtaining
persistent identifier
        at
net.shibboleth.idp.saml.attribute.resolver.impl.StoredIDDataConnector.doDataConnectorResolve(StoredIDDataConnector.java:236)
Caused by: org.opensaml.saml.common.SAMLException: ID storage error
obtaining persistent identifier
        at
net.shibboleth.idp.saml.nameid.impl.StoredPersistentIdGenerationStrategy.generate(StoredPersistentIdGenerationStrategy.java:178)
Caused by: java.io.IOException: java.sql.SQLException: ORA-08177: can't
serialize access for this transaction

        at
net.shibboleth.idp.saml.nameid.impl.JDBCPersistentIdStoreEx.getBySourceValue(JDBCPersistentIdStoreEx.java:624)
Caused by: java.sql.SQLException: ORA-08177: can't serialize access for
this transaction

On Wed, Sep 13, 2017 at 4:11 PM, Cantor, Scott <cantor.2 at osu.edu> wrote:

> On 9/13/17, 4:45 PM, "users on behalf of Lionel Samuel" <
> users-bounces at shibboleth.net on behalf of lionel.samuel01 at gmail.com>
> wrote:
>
> > However the following messages are  appearing in the idp-process.log
> ---- am I missing something?
>
> Whatever you trapped as retryable did not match the error that was thrown,
> so it didn't attempt a retry.
>
> -- Scott
>
>
> --
> To unsubscribe from this list send an email to
> users-unsubscribe at shibboleth.net
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://shibboleth.net/pipermail/users/attachments/20170913/0aba94e9/attachment.html>