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

[Lionel Samuel]

I followed instructions at:
https://wiki.shibboleth.net/confluence/display/IDP30/PersistentNameIDGenerationConfiguration

And added queryTimeout and retryable error

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

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



However the following messages are  appearing in the idp-process.log ----
am I missing something?

/opt/shibboleth-idp/logs/idp-warn.log
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:629)
Caused by: java.sql.SQLException: ORA-08177: can't serialize access for
this transaction

        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
2017-09-13 13:04:04,236 - ERROR
[net.shibboleth.idp.profile.impl.ResolveAttributes:299] -
[CF4775EF4D4F3793E1DD405613C006FA] - [1111.111.111] - Profile Action
ResolveAtt
ributes: 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:629)
Caused by: java.sql.SQLException: ORA-08177: can't serialize access for
this transaction
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://shibboleth.net/pipermail/users/attachments/20170913/746e3482/attachment.html>