JPA Storage Test

[Tom Zeller]

On Thu, Feb 12, 2015 at 2:51 PM, Tom Zeller <tzeller at dragonacea.biz> wrote:
> On Thu, Feb 12, 2015 at 2:27 PM, Daniel Fisher <dfisher at vt.edu> wrote:
>> On Wed, Feb 11, 2015 at 10:03 PM, Tom Zeller <tzeller at dragonacea.biz> wrote:
>>>
>>> > I still have issues with Postgres passing the strings() test, but I'm
>>> > wondering how MySQL fares.
>>>
>>> Well, the strings() test on MySQL fails :
>>>
>>>  at
>>> org.opensaml.storage.StorageServiceTest.strings(StorageServiceTest.java:90)
>>
>>
>> Anything in the MySQL logs that would indicate what is happening?
>> I've been chasing my tail on this, so I'm not sure if it's a Spring bean
>> issue, a Hibernate config issue, or a coding problem.
>
> Just a note that if I run the strings() test by itself it passes, but
> if strings() is run as part of a suite then it fails.

No, sorry, I misspoke. The strings() test fails if invocationCount >
1, which it wasn't when I last posted. Here's a log snippet :

DEBUG [org.hibernate.SQL:109] - insert into StorageRecords (expires,
value, version, context, id) values (?, ?, ?, ?, ?)
DEBUG [org.hibernate.engine.jdbc.spi.SqlExceptionHelper:139] - could
not execute statement [n/a]
WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper:144] - SQL
Error: 1213, SQLState: 40001
ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper:146] -
Deadlock found when trying to get lock; try restarting transaction
INFO [org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl:208]
- HHH000010: On release of batch it still contained JDBC statements
ERROR [org.opensaml.storage.impl.JPAStorageService:140] - Error
committing transaction