[teiid-issues] [JBoss JIRA] (TEIID-5205) Infinispan hotrod translator timeout on UPDATE

[Van Halbert (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-5205?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Work on TEIID-5205 stopped by Van Halbert.
------------------------------------------
> Infinispan hotrod translator timeout on UPDATE
> ----------------------------------------------
>
>                 Key: TEIID-5205
>                 URL: https://issues.jboss.org/browse/TEIID-5205
>             Project: Teiid
>          Issue Type: Bug
>          Components: JDG Connector, Misc. Connectors
>    Affects Versions: 8.12.x-6.4
>            Reporter: Jan Stastny
>            Assignee: Van Halbert
>            Priority: Blocker
>
> I encounter timeout issue when performing UPDATE operation using Infinispan Hotrod translator.
> For query
> {code:sql}
> UPDATE SmallA SET IntKey = 100 WHERE StringKey = '1'
> {code}
> with cache filled with:
> {code:sql}
> INSERT INTO SmallA (IntKey, StringKey, IntNum, StringNum, FloatNum, LongNum, DoubleNum, ByteNum, DateValue, TimeValue, TimestampValue, BooleanValue, CharValue, ShortValue, BigIntegerValue, BigDecimalValue, ObjectValue) VALUES
> (1,  '1',  1,  '1', convert(1.01, float), 1, convert(-1.001, double), convert(1, byte), {d '1111-11-11'}, {t '01:01:01'}, {ts '1111-11-11 01:01:01'}, true,  convert('1', char), convert(1, short), 1, 1.01, '1'),
> (2,  '2',  2,  '2', convert(2.02, float), 2, convert(-2.002, double), convert(2, byte), {d '2222-12-22'}, {t '02:02:02'}, {ts '2222-12-22 02:02:02'}, false, convert('2', char), convert(2, short), 2, 2.02, '2')
> {code}
> results in ARJUNA timeout after 5 minutes:
> {code}
> 14:44:45,068 WARN  [com.arjuna.ats.arjuna] (Transaction Reaper) ARJUNA012117: TransactionReaper::check timeout for TX 0:ffff0a2804a2:45f23ecc:5a54c5e8:f in state  RUN
> 14:44:45,070 WARN  [com.arjuna.ats.arjuna] (Transaction Reaper Worker 0) ARJUNA012095: Abort of action id 0:ffff0a2804a2:45f23ecc:5a54c5e8:f invoked while multiple threads active within it.
> 14:44:45,071 WARN  [com.arjuna.ats.arjuna] (Transaction Reaper Worker 0) ARJUNA012108: CheckedAction::check - atomic action 0:ffff0a2804a2:45f23ecc:5a54c5e8:f aborting with 1 threads active!
> 14:44:45,072 WARN  [com.arjuna.ats.arjuna] (Transaction Reaper Worker 0) ARJUNA012121: TransactionReaper::doCancellations worker Thread[Transaction Reaper Worker 0,5,main] successfully canceled TX 0:ffff0a2804a2:45f23ecc:5a54c5e8:f
> {code}
> and the query hangs.
> Interestingly, the changes get promoted to the cache. Just the query doesn't return.
> Command log for the update query:
> {code}
> 14:39:45,304 DEBUG [org.teiid.COMMAND_LOG] (Worker0_QueryProcessorQueue10) yl6LbuQEyWKk         START DATA SRC COMMAND: startTime=2018-01-09 14:39:45.304       requestID=yl6LbuQEyWKk.3        sourceCommandID=2       executionID=5   txID=TransactionImple < ac, BasicAction: 0:ffff0a2804a2:45f23ecc:5a54c5e8:f status: ActionStatus.RUNNING >      modelName=Source        translatorName=infinispan-hotrod        sessionID=yl6LbuQEyWKk  principal=user at teiid-security   sql=UPDATE Source.SmallA SET IntKey = 100, IntNum = 1, StringNum = '1', FloatNum = 1.01, LongNum = 1, DoubleNum = -1.001, ByteNum = 1, DateValue = '1111-11-11', TimeValue = '01:01:01', TimestampValue = '1111-11-11 01:01:01.0', BooleanValue = TRUE, CharValue = '1', ShortValue = 1, BigIntegerValue = '1', BigDecimalValue = '1.01', ObjectValue = '1' WHERE StringKey = '1'
> {code}



--
This message was sent by Atlassian JIRA
(v7.5.0#75005)