You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-user@db.apache.org by "palo.liska" <pa...@gmail.com> on 2018/03/29 08:45:03 UTC
Re: Identity column and 40XL1 error
Rick Hillegas-3 wrote
> Hi Abhi,
>
> Here is one more idea. I believe that you said that you are running an
> in-memory database. That means that you do not need to worry about
> leaking pre-allocated sequence numbers when your application exits. You
> can try setting the pre-allocation range to the maximum number with the
> following system property:
>
> -Dderby.language.sequence.preallocator=2147483647
>
> When I try that setting, my repro program runs without any lock
> contention.
>
> Hope this helps,
> -Rick
Hi
I am running derby embedded 10.13.1.1 with preallocator=2147483647, but stil
got 40XL1 error on concurrent inserts. Could you tell me, if there is some
reason to this? In my application, I am not selecting SYSSEQUENCES table.
Only I am doing is connection.prepareStatement("VALUES (NEXT VALUE FOR
SIP_Id_Generator_seq)").executeQuery().
--
Sent from: http://apache-database.10148.n7.nabble.com/Apache-Derby-Users-f95095.html
Re: Identity column and 40XL1 error
Posted by Rick Hillegas <ri...@gmail.com>.
On 6/20/18 2:40 AM, palo.liska wrote:
> Hi,
> bug created: https://issues.apache.org/jira/browse/DERBY-6999
>
> Palo.
>
>
>
> --
> Sent from: http://apache-database.10148.n7.nabble.com/Apache-Derby-Users-f95095.html
>
Thanks, Palo. Let's continue the discussion on DERBY-6999.
Re: Identity column and 40XL1 error
Posted by "palo.liska" <pa...@gmail.com>.
Hi,
bug created: https://issues.apache.org/jira/browse/DERBY-6999
Palo.
--
Sent from: http://apache-database.10148.n7.nabble.com/Apache-Derby-Users-f95095.html
Re: Identity column and 40XL1 error
Posted by Rick Hillegas <ri...@gmail.com>.
Great. Can you log a bug and attach the code to the bug?
Thanks,
-Rick
On 6/8/18 6:59 AM, palo.liska wrote:
> Rick Hillegas-3 wrote
>> On 4/10/18 4:19 AM, palo.liska wrote:
>>> Rick Hillegas-3 wrote
>>>> Can you make this error occur in a new database, one which hasn't
>>>> already exhausted the ranges of its identity columns and sequence
>>>> generators? If you can, then I recommend the following next steps:
>> I was able to reproduce this issue with many concurrent inserts.
>> The setup is set of threads inserting random entries in loop, and another
>> set of threads concurrently updating last entry in table (actually done by
>> count = select count(*) and then update .. where id=count-1).
>> With this setup I have high chance of 40XL1 error.
>> If requested I will share actual code.
>
>
>
>
> --
> Sent from: http://apache-database.10148.n7.nabble.com/Apache-Derby-Users-f95095.html
>
Re: Identity column and 40XL1 error
Posted by "palo.liska" <pa...@gmail.com>.
Rick Hillegas-3 wrote
> On 4/10/18 4:19 AM, palo.liska wrote:
>> Rick Hillegas-3 wrote
>>> Can you make this error occur in a new database, one which hasn't
>>> already exhausted the ranges of its identity columns and sequence
>>> generators? If you can, then I recommend the following next steps:
> I was able to reproduce this issue with many concurrent inserts.
> The setup is set of threads inserting random entries in loop, and another
> set of threads concurrently updating last entry in table (actually done by
> count = select count(*) and then update .. where id=count-1).
> With this setup I have high chance of 40XL1 error.
> If requested I will share actual code.
--
Sent from: http://apache-database.10148.n7.nabble.com/Apache-Derby-Users-f95095.html
Re: Identity column and 40XL1 error
Posted by Rick Hillegas <ri...@gmail.com>.
On 4/10/18 4:19 AM, palo.liska wrote:
> Rick Hillegas-3 wrote
>> Can you make this error occur in a new database, one which hasn't
>> already exhausted the ranges of its identity columns and sequence
>> generators? If you can, then I recommend the following next steps:
> The problem is, that I am not able to isolate the issue. I tried to make new
> app just to test that with no success. But I think I just have to find the
> right way to run it. Do you know some really good concurrency tests?
You might take a look at the performance test framework which we used
for testing the concurrency of sequence generators. The tool is called
org.apache.derbyTesting.perf.clients.Runner. The following issue
describes how we used it: https://issues.apache.org/jira/browse/DERBY-4565
Hope this helps,
-Rick
>
> I tried to run up to 80 threads with inserts to derby, or to run ~10 threads
> indefinitely inserting something, run it on my pc, on CI stack. No success.
>
>
>
>
> --
> Sent from: http://apache-database.10148.n7.nabble.com/Apache-Derby-Users-f95095.html
>
Re: Identity column and 40XL1 error
Posted by "palo.liska" <pa...@gmail.com>.
Rick Hillegas-3 wrote
> Can you make this error occur in a new database, one which hasn't
> already exhausted the ranges of its identity columns and sequence
> generators? If you can, then I recommend the following next steps:
The problem is, that I am not able to isolate the issue. I tried to make new
app just to test that with no success. But I think I just have to find the
right way to run it. Do you know some really good concurrency tests?
I tried to run up to 80 threads with inserts to derby, or to run ~10 threads
indefinitely inserting something, run it on my pc, on CI stack. No success.
--
Sent from: http://apache-database.10148.n7.nabble.com/Apache-Derby-Users-f95095.html
Re: Identity column and 40XL1 error
Posted by Rick Hillegas <ri...@gmail.com>.
Can you make this error occur in a new database, one which hasn't
already exhausted the ranges of its identity columns and sequence
generators? If you can, then I recommend the following next steps:
1) Open a JIRA issue for this problem.
2) Run your application. Make sure that you boot the JVM with the
following system properties so that Derby will snapshot statements and
errors to derby.log:
-Dderby.language.logStatementText=true
-Dderby.stream.error.logSeverityLevel=0
3) After you have tripped the problem, attach derby.log to the JIRA
issue so that we can examine it.
Thanks,
-Rick
On 4/9/18 7:08 AM, palo.liska wrote:
> Rick Hillegas-3 wrote
>> Technically, Hibernate should not be calling getGeneratedKeys() because
>> Derby's DatabaseMetaData says that the method is not supported. But
>> whoever wrote the porting layer on top of Derby must have cribbed the
>> code from another database which does support that method. Derby should
>> raise an exception when that method is called, or Derby should fix the
>> implementation of getGeneratedKeys(). So you are caught between bugs in
>> two layers: Hibernate and Derby.
> hibernate has property hibernate.jdbc.use_get_generated_keys, which for
> DerbyTenSevenDialect is false (that my case). Hibernate is therefor
> generating insert like this:
> "insert into Table (id, value) values (default, 'value')". So I would not
> blame hibernate.
>
>
>
>
> --
> Sent from: http://apache-database.10148.n7.nabble.com/Apache-Derby-Users-f95095.html
>
Re: Identity column and 40XL1 error
Posted by "palo.liska" <pa...@gmail.com>.
Rick Hillegas-3 wrote
> Technically, Hibernate should not be calling getGeneratedKeys() because
> Derby's DatabaseMetaData says that the method is not supported. But
> whoever wrote the porting layer on top of Derby must have cribbed the
> code from another database which does support that method. Derby should
> raise an exception when that method is called, or Derby should fix the
> implementation of getGeneratedKeys(). So you are caught between bugs in
> two layers: Hibernate and Derby.
hibernate has property hibernate.jdbc.use_get_generated_keys, which for
DerbyTenSevenDialect is false (that my case). Hibernate is therefor
generating insert like this:
"insert into Table (id, value) values (default, 'value')". So I would not
blame hibernate.
--
Sent from: http://apache-database.10148.n7.nabble.com/Apache-Derby-Users-f95095.html
Re: Identity column and 40XL1 error
Posted by Rick Hillegas <ri...@gmail.com>.
On 4/6/18 6:07 AM, palo.liska wrote:
> Rick Hillegas-3 wrote
>> 1) Something about the problem description is not clear. The first
>> tooMuchContention exception occurs within a half minute of booting the
>> database. It is very hard to understand how your application could chew
>> through 2 billion sequence numbers in that short time period. Perhaps
>> your identity column has already leaked its entire range due to setting
>> derby.language.sequence.preallocator to a high number and then crashing
>> without bringing the database down gracefully.
> application is under stress test.
>
>
>
> Rick Hillegas-3 wrote
>> 2) From the stack traces, it appears that you are using Hibernate. Under
>> the covers, Hibernate calls a JDBC method which Derby does not support
>> but which, unfortunately, Derby does not reject either
>> (Statement.getGeneratedKeys()). That method causes contention on the
>> sequence generators which back identity columns. See
>> https://issues.apache.org/jira/browse/DERBY-6934. It is likely that you
>> have stumbled over this problem. You may be able to workaround this
>> problem by manually generating your object IDs yourself (e.g., by using
>> a sequence generator) and somehow forcing those object ids down through
>> the Hibernate api. I don't use Hibernate myself, so I don't know what
>> this entails. Maybe you will get better advice from someone who has
>> dealt with this Hibernate/Derby issue.
> ..so could this means that there is issue in hibernate? (meanwhile I will
> try to google it :))
Technically, Hibernate should not be calling getGeneratedKeys() because
Derby's DatabaseMetaData says that the method is not supported. But
whoever wrote the porting layer on top of Derby must have cribbed the
code from another database which does support that method. Derby should
raise an exception when that method is called, or Derby should fix the
implementation of getGeneratedKeys(). So you are caught between bugs in
two layers: Hibernate and Derby.
>
> Nevertheless, I am currious about this tooMuchContetionException. It is
> called in SequenceUpdater.getCurrentValueAndAdvance(..). However, this
> method is synchonized. So concurrent generation of Ids should not be problem
> (correct me if I am wrong). In method body there is comment
>
>
>> ...Lock contention is possible if someone has selected from SYSSEQUENCES
>> contrary to our advice. In that case, we raise a TOO MUCH CONTENTION
>> exception.
> I have one custom sequence in SYSSEQUENCES, and I am getting new value with
> query "VALUES (NEXT VALUE FOR my_seq)". Could this be the problem, or there
> could be some other? Besides this I am not using SYSSEQUENCES explicitly.
Contention occurs when a thread needs to allocate a new block of
sequence numbers. A lock on the relevant row in SYSSEQUENCES is acquired
in this situation. Contention can occur if someone else holds the lock
on that row. Other potential lock holders are sessions which directly
query SYSSEQUENCES, callers of getGeneratedKeys(), and the engine
shutdown thread.
>
>
>
> --
> Sent from: http://apache-database.10148.n7.nabble.com/Apache-Derby-Users-f95095.html
>
Re: Identity column and 40XL1 error
Posted by "palo.liska" <pa...@gmail.com>.
Rick Hillegas-3 wrote
> 1) Something about the problem description is not clear. The first
> tooMuchContention exception occurs within a half minute of booting the
> database. It is very hard to understand how your application could chew
> through 2 billion sequence numbers in that short time period. Perhaps
> your identity column has already leaked its entire range due to setting
> derby.language.sequence.preallocator to a high number and then crashing
> without bringing the database down gracefully.
application is under stress test.
Rick Hillegas-3 wrote
> 2) From the stack traces, it appears that you are using Hibernate. Under
> the covers, Hibernate calls a JDBC method which Derby does not support
> but which, unfortunately, Derby does not reject either
> (Statement.getGeneratedKeys()). That method causes contention on the
> sequence generators which back identity columns. See
> https://issues.apache.org/jira/browse/DERBY-6934. It is likely that you
> have stumbled over this problem. You may be able to workaround this
> problem by manually generating your object IDs yourself (e.g., by using
> a sequence generator) and somehow forcing those object ids down through
> the Hibernate api. I don't use Hibernate myself, so I don't know what
> this entails. Maybe you will get better advice from someone who has
> dealt with this Hibernate/Derby issue.
..so could this means that there is issue in hibernate? (meanwhile I will
try to google it :))
Nevertheless, I am currious about this tooMuchContetionException. It is
called in SequenceUpdater.getCurrentValueAndAdvance(..). However, this
method is synchonized. So concurrent generation of Ids should not be problem
(correct me if I am wrong). In method body there is comment
> ...Lock contention is possible if someone has selected from SYSSEQUENCES
> contrary to our advice. In that case, we raise a TOO MUCH CONTENTION
> exception.
I have one custom sequence in SYSSEQUENCES, and I am getting new value with
query "VALUES (NEXT VALUE FOR my_seq)". Could this be the problem, or there
could be some other? Besides this I am not using SYSSEQUENCES explicitly.
--
Sent from: http://apache-database.10148.n7.nabble.com/Apache-Derby-Users-f95095.html
Re: Identity column and 40XL1 error
Posted by Rick Hillegas <ri...@gmail.com>.
Thanks for attaching derby.log. A couple things jump out at me:
1) Something about the problem description is not clear. The first
tooMuchContention exception occurs within a half minute of booting the
database. It is very hard to understand how your application could chew
through 2 billion sequence numbers in that short time period. Perhaps
your identity column has already leaked its entire range due to setting
derby.language.sequence.preallocator to a high number and then crashing
without bringing the database down gracefully.
2) From the stack traces, it appears that you are using Hibernate. Under
the covers, Hibernate calls a JDBC method which Derby does not support
but which, unfortunately, Derby does not reject either
(Statement.getGeneratedKeys()). That method causes contention on the
sequence generators which back identity columns. See
https://issues.apache.org/jira/browse/DERBY-6934. It is likely that you
have stumbled over this problem. You may be able to workaround this
problem by manually generating your object IDs yourself (e.g., by using
a sequence generator) and somehow forcing those object ids down through
the Hibernate api. I don't use Hibernate myself, so I don't know what
this entails. Maybe you will get better advice from someone who has
dealt with this Hibernate/Derby issue.
Hope this helps,
-Rick
On 4/3/18 1:51 PM, palo.liska wrote:
> Rick Hillegas-3 wrote
>> Can you share the derby.log for this problem?
> Finally, I have derby.log, even with
> derby.language.sequence.preallocator=2147483647.
>
Re: Identity column and 40XL1 error
Posted by "palo.liska" <pa...@gmail.com>.
Rick Hillegas-3 wrote
> Can you share the derby.log for this problem?
Finally, I have derby.log, even with
derby.language.sequence.preallocator=2147483647.
----------------------------------------------------------------
Tue Apr 03 20:32:28 UTC 2018:
Booting Derby version The Apache Software Foundation - Apache Derby -
10.13.1.1 - (1765088): instance a816c00e-0162-8d35-fc2c-0000254dce18
on database directory /home/bamboo/bamboo-agent-home/xml-data/build-dir/***
Loaded from
file:/home/bamboo/.m2/repository/org/apache/derby/derby/10.13.1.1/derby-10.13.1.1.jar
java.vendor=Oracle Corporation
java.runtime.version=1.8.0_112-b15
user.dir=/home/bamboo/bamboo-agent-home/xml-data/build-dir/***
os.name=Linux
os.arch=amd64
os.version=4.4.0-24-generic
derby.system.home=null
Database Class Loader started - derby.database.classpath=''
Tue Apr 03 20:33:03 UTC 2018 Thread[TrnThread,5,Transactions] (XID = 16197),
(SESSIONID = 99), (DATABASE = derbyDB), (DRDAID = null), Cleanup action
starting
Tue Apr 03 20:33:03 UTC 2018 Thread[TrnThread,5,Transactions] (XID = 16197),
(SESSIONID = 99), (DATABASE = derbyDB), (DRDAID = null), Failed Statement
is: /* insert cz.wincor.eps.domain.transaction.ResponseCache */ insert into
ResponseCache (id, posResponse_id, requestId, responseXml, timestamp,
workstationId) values (default, ?, ?, ?, ?, ?) with 5 parameters begin
parameter #1: 85 :end parameter begin parameter #2: fC8m57yy-2 :end
parameter begin parameter #3:
CLOB(org.apache.derby.iapi.types.ReaderToUTF8Stream@4401522f) :end parameter
begin parameter #4: 2014-04-03 20:33:02.435 :end parameter begin parameter
#5: DCR110 :end parameter
ERROR 40XL1: A lock could not be obtained within the time requested
at org.apache.derby.iapi.error.StandardException.newException(Unknown
Source)
at org.apache.derby.iapi.error.StandardException.newException(Unknown
Source)
at
org.apache.derby.impl.sql.catalog.SequenceUpdater.tooMuchContentionException(Unknown
Source)
at
org.apache.derby.impl.sql.catalog.SequenceUpdater.getCurrentValueAndAdvance(Unknown
Source)
at
org.apache.derby.impl.sql.catalog.DataDictionaryImpl.getCurrentValueAndAdvance(Unknown
Source)
at
org.apache.derby.impl.sql.execute.BaseActivation.getCurrentValueAndAdvance(Unknown
Source)
at
org.apache.derby.impl.sql.execute.InsertResultSet.getSetAutoincrementValue(Unknown
Source)
at
org.apache.derby.impl.sql.execute.BaseActivation.getSetAutoincrementValue(Unknown
Source)
at org.apache.derby.exe.ac12da4e0fx0162x8d35xfc2cx0000254dce183.e0(Unknown
Source)
at org.apache.derby.impl.services.reflect.DirectCall.invoke(Unknown Source)
at org.apache.derby.impl.sql.execute.RowResultSet.getNextRowCore(Unknown
Source)
at
org.apache.derby.impl.sql.execute.NormalizeResultSet.getNextRowCore(Unknown
Source)
at
org.apache.derby.impl.sql.execute.DMLWriteResultSet.getNextRowCore(Unknown
Source)
at org.apache.derby.impl.sql.execute.InsertResultSet.getNextRowCore(Unknown
Source)
at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown
Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeLargeUpdate(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown
Source)
at
org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98)
at
org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98)
at
org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:208)
at
org.hibernate.id.insert.AbstractSelectingDelegate.performInsert(AbstractSelectingDelegate.java:61)
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3032)
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3558)
at
org.hibernate.action.internal.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:98)
at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:492)
at
org.hibernate.engine.spi.ActionQueue.addResolvedEntityInsertAction(ActionQueue.java:197)
at
org.hibernate.engine.spi.ActionQueue.addInsertAction(ActionQueue.java:181)
at org.hibernate.engine.spi.ActionQueue.addAction(ActionQueue.java:216)
at
org.hibernate.event.internal.AbstractSaveEventListener.addInsertAction(AbstractSaveEventListener.java:334)
at
org.hibernate.event.internal.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:289)
at
org.hibernate.event.internal.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:195)
at
org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:126)
at
org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:209)
at
org.hibernate.event.internal.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:55)
at
org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:194)
at
org.hibernate.event.internal.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:49)
at
org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:90)
at org.hibernate.internal.SessionImpl.fireSave(SessionImpl.java:715)
at org.hibernate.internal.SessionImpl.save(SessionImpl.java:707)
at org.hibernate.internal.SessionImpl.save(SessionImpl.java:702)
at
***.service.CachedResponseServiceImpl.clearCacheAndSaveResponse(CachedResponseServiceImpl.java:117)
at
***.service.CachedResponseServiceImpl.cacheResponse(CachedResponseServiceImpl.java:49)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at
org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
at
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
at com.sun.proxy.$Proxy194.cacheResponse(Unknown Source)
at
***.PCATSTransactionProcessor.cacheResponse(PCATSTransactionProcessor.java:93)
at
***.PCATSTransactionProcessor.preparePositiveResponse(PCATSTransactionProcessor.java:57)
at
***.PCATSTransactionProcessor.preparePositiveResponse(PCATSTransactionProcessor.java:29)
at
***.AbstractInputTransactionProcessor.run(AbstractInputTransactionProcessor.java:217)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Cleanup action completed
Tue Apr 03 20:33:06 UTC 2018 Thread[CreateJournalThread,5,Transactions] (XID
= 17744), (SESSIONID = 77), (DATABASE = derbyDB), (DRDAID = null), Cleanup
action starting
Tue Apr 03 20:33:06 UTC 2018 Thread[CreateJournalThread,5,Transactions] (XID
= 17744), (SESSIONID = 77), (DATABASE = derbyDB), (DRDAID = null), Failed
Statement is: /* insert cz.wincor.eps.domain.Journal */ insert into Journal
(id, cardEntryMode, createdAt, currentRequestId, data, dataVersion,
invoiceNumber, journalType, keyForMessage_id, requestId) values (default, ?,
?, ?, ?, ?, ?, ?, ?, ?) with 9 parameters begin parameter #1: MOBILE :end
parameter begin parameter #2: 2014-04-03 20:33:05.998 :end parameter begin
parameter #3: 108 :end parameter begin parameter #4: CLOB(40) :end parameter
begin parameter #5: 1 :end parameter begin parameter #6: 100030 :end
parameter begin parameter #7: PRE_AUTH :end parameter begin parameter #8: 1
:end parameter begin parameter #9: 90 :end parameter
ERROR 40XL1: A lock could not be obtained within the time requested
at org.apache.derby.iapi.error.StandardException.newException(Unknown
Source)
at org.apache.derby.iapi.error.StandardException.newException(Unknown
Source)
at
org.apache.derby.impl.sql.catalog.SequenceUpdater.tooMuchContentionException(Unknown
Source)
at
org.apache.derby.impl.sql.catalog.SequenceUpdater.getCurrentValueAndAdvance(Unknown
Source)
at
org.apache.derby.impl.sql.catalog.DataDictionaryImpl.getCurrentValueAndAdvance(Unknown
Source)
at
org.apache.derby.impl.sql.execute.BaseActivation.getCurrentValueAndAdvance(Unknown
Source)
at
org.apache.derby.impl.sql.execute.InsertResultSet.getSetAutoincrementValue(Unknown
Source)
at
org.apache.derby.impl.sql.execute.BaseActivation.getSetAutoincrementValue(Unknown
Source)
at org.apache.derby.exe.aca7819bfdx0162x8d35xfc2cx0000254dce180.e0(Unknown
Source)
at org.apache.derby.impl.services.reflect.DirectCall.invoke(Unknown Source)
at org.apache.derby.impl.sql.execute.RowResultSet.getNextRowCore(Unknown
Source)
at
org.apache.derby.impl.sql.execute.NormalizeResultSet.getNextRowCore(Unknown
Source)
at
org.apache.derby.impl.sql.execute.DMLWriteResultSet.getNextRowCore(Unknown
Source)
at org.apache.derby.impl.sql.execute.InsertResultSet.getNextRowCore(Unknown
Source)
at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown
Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeLargeUpdate(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown
Source)
at
org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98)
at
org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98)
at
org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:208)
at
org.hibernate.id.insert.AbstractSelectingDelegate.performInsert(AbstractSelectingDelegate.java:61)
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3032)
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3558)
at
org.hibernate.action.internal.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:98)
at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:492)
at
org.hibernate.engine.spi.ActionQueue.addResolvedEntityInsertAction(ActionQueue.java:197)
at
org.hibernate.engine.spi.ActionQueue.addInsertAction(ActionQueue.java:181)
at org.hibernate.engine.spi.ActionQueue.addAction(ActionQueue.java:216)
at
org.hibernate.event.internal.AbstractSaveEventListener.addInsertAction(AbstractSaveEventListener.java:334)
at
org.hibernate.event.internal.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:289)
at
org.hibernate.event.internal.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:195)
at
org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:126)
at
org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:209)
at
org.hibernate.event.internal.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:55)
at
org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:194)
at
org.hibernate.event.internal.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:49)
at
org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:90)
at org.hibernate.internal.SessionImpl.fireSave(SessionImpl.java:715)
at org.hibernate.internal.SessionImpl.save(SessionImpl.java:707)
at org.hibernate.internal.SessionImpl.save(SessionImpl.java:702)
at
***.service.impl.EpsJournalServiceImpl.persistJournal(EpsJournalServiceImpl.java:493)
at
***.service.impl.EpsJournalServiceImpl.add(EpsJournalServiceImpl.java:142)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at
org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
at
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
at com.sun.proxy.$Proxy97.add(Unknown Source)
at
***.journal.EpsJournalBuilder.createTransactionEntry(EpsJournalBuilder.java:72)
at
***.service.impl.EpsJournalServiceImpl$1.run(EpsJournalServiceImpl.java:454)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Cleanup action completed
Tue Apr 03 20:33:17 UTC 2018 Thread[TrnThread,5,Transactions] (XID = 21543),
(SESSIONID = 23), (DATABASE = derbyDB), (DRDAID = null), Cleanup action
starting
Tue Apr 03 20:33:17 UTC 2018 Thread[TrnThread,5,Transactions] (XID = 21543),
(SESSIONID = 23), (DATABASE = derbyDB), (DRDAID = null), Failed Statement
is: /* insert cz.wincor.eps.domain.transaction.PosResponseSaleItem */ insert
into PosResponseSaleItem (ID, amount, posResponse_id, productCode, quantity,
serviceLevel, unitOfMeasureCode, unitPrice) values (default, ?, ?, ?, ?, ?,
?, ?) with 7 parameters begin parameter #1: 38.83 :end parameter begin
parameter #2: 256 :end parameter begin parameter #3: 1 :end parameter begin
parameter #4: 13.39 :end parameter begin parameter #5: NULL :end parameter
begin parameter #6: GLL :end parameter begin parameter #7: 2.89 :end
parameter
ERROR 40XL1: A lock could not be obtained within the time requested
at org.apache.derby.iapi.error.StandardException.newException(Unknown
Source)
at org.apache.derby.iapi.error.StandardException.newException(Unknown
Source)
at
org.apache.derby.impl.sql.catalog.SequenceUpdater.tooMuchContentionException(Unknown
Source)
at
org.apache.derby.impl.sql.catalog.SequenceUpdater.getCurrentValueAndAdvance(Unknown
Source)
at
org.apache.derby.impl.sql.catalog.DataDictionaryImpl.getCurrentValueAndAdvance(Unknown
Source)
at
org.apache.derby.impl.sql.execute.BaseActivation.getCurrentValueAndAdvance(Unknown
Source)
at
org.apache.derby.impl.sql.execute.InsertResultSet.getSetAutoincrementValue(Unknown
Source)
at
org.apache.derby.impl.sql.execute.BaseActivation.getSetAutoincrementValue(Unknown
Source)
at org.apache.derby.exe.aca7819bfdx0162x8d35xfc2cx0000254dce181.e0(Unknown
Source)
at org.apache.derby.impl.services.reflect.DirectCall.invoke(Unknown Source)
at org.apache.derby.impl.sql.execute.RowResultSet.getNextRowCore(Unknown
Source)
at
org.apache.derby.impl.sql.execute.NormalizeResultSet.getNextRowCore(Unknown
Source)
at
org.apache.derby.impl.sql.execute.DMLWriteResultSet.getNextRowCore(Unknown
Source)
at org.apache.derby.impl.sql.execute.InsertResultSet.getNextRowCore(Unknown
Source)
at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown
Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeLargeUpdate(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown
Source)
at
org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98)
at
org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98)
at
org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:208)
at
org.hibernate.id.insert.AbstractSelectingDelegate.performInsert(AbstractSelectingDelegate.java:61)
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3032)
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3558)
at
org.hibernate.action.internal.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:98)
at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:492)
at
org.hibernate.engine.spi.ActionQueue.addResolvedEntityInsertAction(ActionQueue.java:197)
at
org.hibernate.engine.spi.ActionQueue.addInsertAction(ActionQueue.java:181)
at org.hibernate.engine.spi.ActionQueue.addAction(ActionQueue.java:216)
at
org.hibernate.event.internal.AbstractSaveEventListener.addInsertAction(AbstractSaveEventListener.java:334)
at
org.hibernate.event.internal.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:289)
at
org.hibernate.event.internal.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:195)
at
org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:126)
at
org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:209)
at
org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:194)
at
org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:114)
at
org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:90)
at
org.hibernate.internal.SessionImpl.fireSaveOrUpdate(SessionImpl.java:684)
at org.hibernate.internal.SessionImpl.saveOrUpdate(SessionImpl.java:676)
at
org.hibernate.engine.spi.CascadingActions$5.cascade(CascadingActions.java:235)
at org.hibernate.engine.internal.Cascade.cascadeToOne(Cascade.java:350)
at
org.hibernate.engine.internal.Cascade.cascadeAssociation(Cascade.java:293)
at org.hibernate.engine.internal.Cascade.cascadeProperty(Cascade.java:161)
at
org.hibernate.engine.internal.Cascade.cascadeCollectionElements(Cascade.java:379)
at
org.hibernate.engine.internal.Cascade.cascadeCollection(Cascade.java:319)
at
org.hibernate.engine.internal.Cascade.cascadeAssociation(Cascade.java:296)
at org.hibernate.engine.internal.Cascade.cascadeProperty(Cascade.java:161)
at org.hibernate.engine.internal.Cascade.cascade(Cascade.java:118)
at
org.hibernate.event.internal.AbstractFlushingEventListener.cascadeOnFlush(AbstractFlushingEventListener.java:167)
at
org.hibernate.event.internal.AbstractFlushingEventListener.prepareEntityFlushes(AbstractFlushingEventListener.java:158)
at
org.hibernate.event.internal.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:91)
at
org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:55)
at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1258)
at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:425)
at
org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.beforeTransactionCommit(JdbcTransaction.java:101)
at
org.hibernate.engine.transaction.spi.AbstractTransactionImpl.commit(AbstractTransactionImpl.java:177)
at
org.springframework.orm.hibernate4.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:584)
at
org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:761)
at
org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:730)
at
org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:504)
at
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:292)
at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
at com.sun.proxy.$Proxy194.isResponseCached(Unknown Source)
at
***.PCATSTransactionProcessor.preparePositiveResponse(PCATSTransactionProcessor.java:46)
at
***.PCATSTransactionProcessor.preparePositiveResponse(PCATSTransactionProcessor.java:29)
at
***.AbstractInputTransactionProcessor.run(AbstractInputTransactionProcessor.java:217)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Cleanup action completed
Tue Apr 03 20:33:17 UTC 2018 Thread[TrnThread,5,Transactions] (XID = 21634),
(SESSIONID = 61), (DATABASE = derbyDB), (DRDAID = null), Cleanup action
starting
Tue Apr 03 20:33:17 UTC 2018 Thread[TrnThread,5,Transactions] (XID = 21634),
(SESSIONID = 61), (DATABASE = derbyDB), (DRDAID = null), Failed Statement
is: /* insert cz.wincor.eps.domain.transaction.PaymentHostRequest */ insert
into PaymentHostRequest (id, batch, epsTimeStamp, invoiceNumber,
posRequest_id) values (default, ?, ?, ?, ?) with 4 parameters begin
parameter #1: 1 :end parameter begin parameter #2: 2014-04-03 20:33:14.316
:end parameter begin parameter #3: 100013 :end parameter begin parameter #4:
246 :end parameter
ERROR 40XL1: A lock could not be obtained within the time requested
at org.apache.derby.iapi.error.StandardException.newException(Unknown
Source)
at org.apache.derby.iapi.error.StandardException.newException(Unknown
Source)
at
org.apache.derby.impl.sql.catalog.SequenceUpdater.tooMuchContentionException(Unknown
Source)
at
org.apache.derby.impl.sql.catalog.SequenceUpdater.getCurrentValueAndAdvance(Unknown
Source)
at
org.apache.derby.impl.sql.catalog.DataDictionaryImpl.getCurrentValueAndAdvance(Unknown
Source)
at
org.apache.derby.impl.sql.execute.BaseActivation.getCurrentValueAndAdvance(Unknown
Source)
at
org.apache.derby.impl.sql.execute.InsertResultSet.getSetAutoincrementValue(Unknown
Source)
at
org.apache.derby.impl.sql.execute.BaseActivation.getSetAutoincrementValue(Unknown
Source)
at org.apache.derby.exe.aca7819bfdx0162x8d35xfc2cx0000254dce182.e0(Unknown
Source)
at org.apache.derby.impl.services.reflect.DirectCall.invoke(Unknown Source)
at org.apache.derby.impl.sql.execute.RowResultSet.getNextRowCore(Unknown
Source)
at
org.apache.derby.impl.sql.execute.NormalizeResultSet.getNextRowCore(Unknown
Source)
at
org.apache.derby.impl.sql.execute.DMLWriteResultSet.getNextRowCore(Unknown
Source)
at org.apache.derby.impl.sql.execute.InsertResultSet.getNextRowCore(Unknown
Source)
at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown
Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeLargeUpdate(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown
Source)
at
org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98)
at
org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98)
at
org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:208)
at
org.hibernate.id.insert.AbstractSelectingDelegate.performInsert(AbstractSelectingDelegate.java:61)
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3032)
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3558)
at
org.hibernate.action.internal.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:98)
at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:492)
at
org.hibernate.engine.spi.ActionQueue.addResolvedEntityInsertAction(ActionQueue.java:197)
at
org.hibernate.engine.spi.ActionQueue.addInsertAction(ActionQueue.java:181)
at org.hibernate.engine.spi.ActionQueue.addAction(ActionQueue.java:216)
at
org.hibernate.event.internal.AbstractSaveEventListener.addInsertAction(AbstractSaveEventListener.java:334)
at
org.hibernate.event.internal.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:289)
at
org.hibernate.event.internal.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:195)
at
org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:126)
at
org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:209)
at
org.hibernate.event.internal.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:55)
at
org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:194)
at
org.hibernate.event.internal.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:49)
at
org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:90)
at org.hibernate.internal.SessionImpl.fireSave(SessionImpl.java:715)
at org.hibernate.internal.SessionImpl.save(SessionImpl.java:707)
at org.hibernate.internal.SessionImpl.save(SessionImpl.java:702)
at
***.service.impl.PaymentServiceImpl.saveTrnObjects(PaymentServiceImpl.java:298)
at sun.reflect.GeneratedMethodAccessor448.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at
org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
at
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
at com.sun.proxy.$Proxy95.saveTrnObjects(Unknown Source)
at
***.AbstractPosTransactionProcessor.persistEPSTransaction(AbstractPosTransactionProcessor.java:145)
at
***.AbstractPosTransactionProcessor.persistEPSTransaction(AbstractPosTransactionProcessor.java:29)
at
***.AbstractInputTransactionProcessor.run(AbstractInputTransactionProcessor.java:251)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Cleanup action completed
Tue Apr 03 20:33:17 UTC 2018 Thread[TrnThread,5,Transactions] (XID = 21662),
(SESSIONID = 71), (DATABASE = derbyDB), (DRDAID = null), Cleanup action
starting
Tue Apr 03 20:33:17 UTC 2018 Thread[TrnThread,5,Transactions] (XID = 21662),
(SESSIONID = 71), (DATABASE = derbyDB), (DRDAID = null), Failed Statement
is: /* insert cz.wincor.eps.domain.transaction.PaymentHostResponse */ insert
into PaymentHostResponse (id, accountBalance, authCode, batch,
cardHolderMessage, invoiceNumber, isNetworkSettlementNeeded,
isNewMailDownloadNeeded, posRequest_id, referenceNumber, responseCode,
responseTime, serverBussinesDate, serverIssuerId, transactionFee,
transactionType) values (default, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?) with 15 parameters begin parameter #1: null :end parameter begin
parameter #2: NULL :end parameter begin parameter #3: 1 :end parameter begin
parameter #4: NULL :end parameter begin parameter #5: 100028 :end parameter
begin parameter #6: 0 :end parameter begin parameter #7: 0 :end parameter
begin parameter #8: 257 :end parameter begin parameter #9: NULL :end
parameter begin parameter #10: 00 :end parameter begin parameter #11:
2014-04-03 20:33:15.863 :end parameter begin parameter #12: 2018-04-03
00:00:00.0 :end parameter begin parameter #13: V :end parameter begin
parameter #14: null :end parameter begin parameter #15: FINANCIAL_ADVICE
:end parameter
ERROR 40XL1: A lock could not be obtained within the time requested
at org.apache.derby.iapi.error.StandardException.newException(Unknown
Source)
at org.apache.derby.iapi.error.StandardException.newException(Unknown
Source)
at
org.apache.derby.impl.sql.catalog.SequenceUpdater.tooMuchContentionException(Unknown
Source)
at
org.apache.derby.impl.sql.catalog.SequenceUpdater.getCurrentValueAndAdvance(Unknown
Source)
at
org.apache.derby.impl.sql.catalog.DataDictionaryImpl.getCurrentValueAndAdvance(Unknown
Source)
at
org.apache.derby.impl.sql.execute.BaseActivation.getCurrentValueAndAdvance(Unknown
Source)
at
org.apache.derby.impl.sql.execute.InsertResultSet.getSetAutoincrementValue(Unknown
Source)
at
org.apache.derby.impl.sql.execute.BaseActivation.getSetAutoincrementValue(Unknown
Source)
at org.apache.derby.exe.ac450f5097x0162x8d35xfc2cx0000254dce183.e0(Unknown
Source)
at org.apache.derby.impl.services.reflect.DirectCall.invoke(Unknown Source)
at org.apache.derby.impl.sql.execute.RowResultSet.getNextRowCore(Unknown
Source)
at
org.apache.derby.impl.sql.execute.NormalizeResultSet.getNextRowCore(Unknown
Source)
at
org.apache.derby.impl.sql.execute.DMLWriteResultSet.getNextRowCore(Unknown
Source)
at org.apache.derby.impl.sql.execute.InsertResultSet.getNextRowCore(Unknown
Source)
at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown
Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeLargeUpdate(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown
Source)
at
org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98)
at
org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98)
at
org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:208)
at
org.hibernate.id.insert.AbstractSelectingDelegate.performInsert(AbstractSelectingDelegate.java:61)
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3032)
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3558)
at
org.hibernate.action.internal.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:98)
at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:492)
at
org.hibernate.engine.spi.ActionQueue.addResolvedEntityInsertAction(ActionQueue.java:197)
at
org.hibernate.engine.spi.ActionQueue.addInsertAction(ActionQueue.java:181)
at org.hibernate.engine.spi.ActionQueue.addAction(ActionQueue.java:216)
at
org.hibernate.event.internal.AbstractSaveEventListener.addInsertAction(AbstractSaveEventListener.java:334)
at
org.hibernate.event.internal.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:289)
at
org.hibernate.event.internal.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:195)
at
org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:126)
at
org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:209)
at
org.hibernate.event.internal.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:55)
at
org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:194)
at
org.hibernate.event.internal.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:49)
at
org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:90)
at org.hibernate.internal.SessionImpl.fireSave(SessionImpl.java:715)
at org.hibernate.internal.SessionImpl.save(SessionImpl.java:707)
at org.hibernate.internal.SessionImpl.save(SessionImpl.java:702)
at
***.service.impl.PaymentServiceImpl.saveTrnObjects(PaymentServiceImpl.java:312)
at sun.reflect.GeneratedMethodAccessor448.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at
org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
at
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
at com.sun.proxy.$Proxy95.saveTrnObjects(Unknown Source)
at
***.AbstractPosTransactionProcessor.persistEPSTransaction(AbstractPosTransactionProcessor.java:145)
at
***.AbstractPosTransactionProcessor.persistEPSTransaction(AbstractPosTransactionProcessor.java:29)
at
***.AbstractInputTransactionProcessor.run(AbstractInputTransactionProcessor.java:251)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Cleanup action completed
Tue Apr 03 20:34:24 UTC 2018 Thread[TrnThread,5,Transactions] (XID = 55150),
(SESSIONID = 111), (DATABASE = derbyDB), (DRDAID = null), Cleanup action
starting
Tue Apr 03 20:34:24 UTC 2018 Thread[TrnThread,5,Transactions] (XID = 55150),
(SESSIONID = 111), (DATABASE = derbyDB), (DRDAID = null), Failed Statement
is: /* insert cz.wincor.eps.domain.transaction.PosRequest */ insert into
PosRequest (id, amount, applicationSender, batch, cashBackAmount, clerkID,
epsTimeStamp, hostConfigId, originalAmount, originalInvoiceNumber,
paymentMethod, popID, posTimeStamp, referenceNumber, reqType, requestID,
resendFlag, shiftNumber, stan, terminalId, transactionNumber,
transactionType, trnSecureDataId, wasPrepayCardInBasket, workstationID)
values (default, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?) with 24 parameters begin parameter #1: null :end parameter begin
parameter #2: NULL :end parameter begin parameter #3: null :end parameter
begin parameter #4: null :end parameter begin parameter #5: NULL :end
parameter begin parameter #6: 2014-04-03 20:34:23.85 :end parameter begin
parameter #7: null :end parameter begin parameter #8: null :end parameter
begin parameter #9: NULL :end parameter begin parameter #10: Credit :end
parameter begin parameter #11: NULL :end parameter begin parameter #12:
2015-01-31 23:00:00.0 :end parameter begin parameter #13: XyglT7H9-3 :end
parameter begin parameter #14: LOYALTY_AWARD :end parameter begin parameter
#15: XyglT7H9-4 :end parameter begin parameter #16: false :end parameter
begin parameter #17: NULL :end parameter begin parameter #18: null :end
parameter begin parameter #19: NULL :end parameter begin parameter #20: NULL
:end parameter begin parameter #21: LOYALTY_AWARD :end parameter begin
parameter #22: null :end parameter begin parameter #23: null :end parameter
begin parameter #24: DCR146 :end parameter
ERROR 40XL1: A lock could not be obtained within the time requested
at org.apache.derby.iapi.error.StandardException.newException(Unknown
Source)
at org.apache.derby.iapi.error.StandardException.newException(Unknown
Source)
at
org.apache.derby.impl.sql.catalog.SequenceUpdater.tooMuchContentionException(Unknown
Source)
at
org.apache.derby.impl.sql.catalog.SequenceUpdater.getCurrentValueAndAdvance(Unknown
Source)
at
org.apache.derby.impl.sql.catalog.DataDictionaryImpl.getCurrentValueAndAdvance(Unknown
Source)
at
org.apache.derby.impl.sql.execute.BaseActivation.getCurrentValueAndAdvance(Unknown
Source)
at
org.apache.derby.impl.sql.execute.InsertResultSet.getSetAutoincrementValue(Unknown
Source)
at
org.apache.derby.impl.sql.execute.BaseActivation.getSetAutoincrementValue(Unknown
Source)
at org.apache.derby.exe.aca85b8c4dx0162x8d35xfc2cx0000254dce184.e0(Unknown
Source)
at org.apache.derby.impl.services.reflect.DirectCall.invoke(Unknown Source)
at org.apache.derby.impl.sql.execute.RowResultSet.getNextRowCore(Unknown
Source)
at
org.apache.derby.impl.sql.execute.NormalizeResultSet.getNextRowCore(Unknown
Source)
at
org.apache.derby.impl.sql.execute.DMLWriteResultSet.getNextRowCore(Unknown
Source)
at org.apache.derby.impl.sql.execute.InsertResultSet.getNextRowCore(Unknown
Source)
at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown
Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeLargeUpdate(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown
Source)
at
org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98)
at
org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98)
at
org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:208)
at
org.hibernate.id.insert.AbstractSelectingDelegate.performInsert(AbstractSelectingDelegate.java:61)
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3032)
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3558)
at
org.hibernate.action.internal.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:98)
at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:492)
at
org.hibernate.engine.spi.ActionQueue.addResolvedEntityInsertAction(ActionQueue.java:197)
at
org.hibernate.engine.spi.ActionQueue.addInsertAction(ActionQueue.java:181)
at org.hibernate.engine.spi.ActionQueue.addAction(ActionQueue.java:216)
at
org.hibernate.event.internal.AbstractSaveEventListener.addInsertAction(AbstractSaveEventListener.java:334)
at
org.hibernate.event.internal.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:289)
at
org.hibernate.event.internal.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:195)
at
org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:126)
at
org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:209)
at
org.hibernate.event.internal.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:55)
at
org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:194)
at
org.hibernate.event.internal.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:49)
at
org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:90)
at org.hibernate.internal.SessionImpl.fireSave(SessionImpl.java:715)
at org.hibernate.internal.SessionImpl.save(SessionImpl.java:707)
at org.hibernate.internal.SessionImpl.save(SessionImpl.java:702)
at
***.connector.api.pos.AbstractPosServiceImpl.savePosRequest(AbstractPosServiceImpl.java:153)
at sun.reflect.GeneratedMethodAccessor413.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at
org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
at
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
at com.sun.proxy.$Proxy92.savePosRequest(Unknown Source)
at
***.AbstractPosTransactionProcessor.initPosRequest(AbstractPosTransactionProcessor.java:243)
at
***.AbstractPosTransactionProcessor.initEPSTransaction(AbstractPosTransactionProcessor.java:97)
at
***.AbstractPosTransactionProcessor.initEPSTransaction(AbstractPosTransactionProcessor.java:29)
at
***.AbstractInputTransactionProcessor.run(AbstractInputTransactionProcessor.java:209)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Cleanup action completed
----------------------------------------------------------------
Tue Apr 03 20:36:30 UTC 2018: Shutting down Derby engine
----------------------------------------------------------------
Tue Apr 03 20:36:30 UTC 2018:
Shutting down instance a816c00e-0162-8d35-fc2c-0000254dce18 on database
directory /home/bamboo/bamboo-agent-home/xml-data/build-dir/***/derbyDB with
class loader sun.misc.Launcher$AppClassLoader@4aa298b7
-----------
--
Sent from: http://apache-database.10148.n7.nabble.com/Apache-Derby-Users-f95095.html
Re: Identity column and 40XL1 error
Posted by "palo.liska" <pa...@gmail.com>.
Sorry, I realized the property was not set. Now I got something else ))
Derby could not obtain the locks needed to release the unused, preallocated
values for the sequence 'SYS'.'Ud13fc25bX0162X8d01Xd787X00000c5ec3e0'. As a
result, unexpected gaps may appear in this sequence.
--
Sent from: http://apache-database.10148.n7.nabble.com/Apache-Derby-Users-f95095.html
Re: Identity column and 40XL1 error
Posted by Rick Hillegas <ri...@gmail.com>.
Can you share the derby.log for this problem?
Thanks,
-Rick
On 3/29/18 1:45 AM, palo.liska wrote:
> Rick Hillegas-3 wrote
>> Hi Abhi,
>>
>> Here is one more idea. I believe that you said that you are running an
>> in-memory database. That means that you do not need to worry about
>> leaking pre-allocated sequence numbers when your application exits. You
>> can try setting the pre-allocation range to the maximum number with the
>> following system property:
>>
>> -Dderby.language.sequence.preallocator=2147483647
>>
>> When I try that setting, my repro program runs without any lock
>> contention.
>>
>> Hope this helps,
>> -Rick
> Hi
>
> I am running derby embedded 10.13.1.1 with preallocator=2147483647, but stil
> got 40XL1 error on concurrent inserts. Could you tell me, if there is some
> reason to this? In my application, I am not selecting SYSSEQUENCES table.
> Only I am doing is connection.prepareStatement("VALUES (NEXT VALUE FOR
> SIP_Id_Generator_seq)").executeQuery().
>
>
>
> --
> Sent from: http://apache-database.10148.n7.nabble.com/Apache-Derby-Users-f95095.html
>