TSTART Connection lost and transaction does not rollback

Question

Question

Alex Kogan · Apr 26, 2021

Hello,

I have a quick question regarding TSTART, however not certain if there is an answer.

If I am inside the transaction and I loose connection - I always assumed that transaction would TROLLBACK, however it does not.

Is there anything special I need to set up with my TSTART, in order for this transaction to safely rollback?

*********

As example: Let's say I am inside the TSTART and setting up / altering some data and my VPN connection got disconnected. I kind of expect all the data to be rolled back.

Thank you,

Alex

Product version: IRIS 2020.1

Discussion (6)2

Log in or sign up to continue

Vic Sun · Apr 26, 2021

Hello Alex,

Have you confirmed that the original transaction process goes away when the VPN disconnects? How are you opening the terminal in the first place?

If disconnecting the VPN leaves the original process around, it won't have a chance to rollback the transaction.

edit: perhaps this is related to your Journal Freeze on error setting?

0 0

Dmitry Maslennikov · Apr 26, 2021

Are you sure, that the process was terminated?

You should check cconsole.log/messages.log

journal records, you should find there where transaction was started, you changed the data, check if change was really in transaction and any other records within the process, it should be commit or rollback.
In any case, when restart Cache, it should terminate any unfinished processes and rollback data.

2 0

score 1 · Answer 1 · 2021-04-26T12:54:16-04:00

It’s connected with a process, until it’s alive, transaction will be open. When process will be finished by any reasons, it should rollback any transactions left open.

score 0 · Answer 2 · 2021-04-26T13:20:19-04:00

I thought so too, but it clearly does not work. Maybe it's a bug in TROLLBACK.

my exact steps to reproduce:

1.Open up terminal session.

2.> TSTART

3. Set any simple global to test: S ^AKTEST=123

4. Disconnect VPN

5. Reconnect VPN

6. Open up new Terminal Session

7. Look up that global - It is still there with my setting.

score 0 · Answer 3 · 2021-04-26T15:19:04-04:00

Thank you yes, I thought the process is done, once I disconnect the VPN and terminal says Inactive, but I figured out that if I reconnect my VPN, go to studio - the process is still there, so once I terminate it - TROLLBACK works fine.

Thank you

score 1 · Answer 4 · 2021-04-26T15:23:33-04:00

The O.S. process associated with the terminal was still running, in READ state, unaware that the terminal had disconnected. Once we found it and terminated it (we used the System Management Portal for that), the transaction was properly rolled back.