IDP V3: LockTimeoutException with remote PG DB

[Daniel Fisher]

On Tue, Oct 20, 2015 at 12:00 PM, Walter Forbes Hoehn (wassa) <
wassa at memphis.edu> wrote:

> Another perhaps unique thing about my configuration is that I have a
> custom ORM, which I’ve included below.  Most people shouldn’t need this,
> but I was running V3 very early before some of the default table names were
> changed.
>
>
I believe Walter hit on a potential solution. (Although I don't see where
you are overriding any names....) The problem appears to be hibernate doing
a bit more with the @Lob annotation than we would like with Postgres. In
particular it's generating large object OIDs that are not used or needed.
Since that annotation is only necessary to get the column type of 'TEXT'
when generating the DDL, try removing it with a custom mapping:


> <?xml version="1.0" encoding="UTF-8"?>
> <entity-mappings xmlns="http://java.sun.com/xml/ns/persistence/orm"
>                  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>                  xsi:schemaLocation="
> http://java.sun.com/xml/ns/persistence/orm
>
> http://java.sun.com/xml/ns/persistence/orm_1_0.xsd" version="1.0">
>   <package>org.opensaml.storage.impl</package>
>
>   <entity class="JPAStorageRecord" access="PROPERTY">
>     <attributes>
>       <basic name="value">
>         <column name="value" nullable="false"/>
>       </basic>
>     </attributes>
>   </entity>
> </entity-mappings>


Drop this into WEB-INF/classes/META-INF/orm.xml and see if large object
references continue to be generated.

--Daniel Fisher
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://shibboleth.net/pipermail/users/attachments/20151021/9649872a/attachment.html>