RE: Turning off deadlock detection

[Thomas Ketter via user]

Hi Ronak,
Make sure you don’t have ATOMIC table updates within your transaction.

Thomas

From: Stephen Darlington 
Sent: Monday, March 25, 2024 2:31 AM
To: user@ignite.apache.org
Subject: Re: Turning off deadlock detection

This is an EXTERNAL EMAIL. Stop and think before clicking a link or opening 
attachments.
Just a reminder that this list is run by volunteers. If you need responses in a 
given time, commercial options are available.

On Sat, 23 Mar 2024 at 17:50, Ronak Shah 
mailto:ronak.malav.s...@gmail.com>> wrote:
Ping again. Can someone answer please? - Ronak

On Mon, Mar 18, 2024 at 12:04 PM Ronak Shah 
mailto:ronak.malav.s...@gmail.com>> wrote:
Hi Ignite users,
I am hitting a situation in a scaled environment where if the transaction 
timeouts for whatever reason, the cluster goes in a deadlock detection mode, 
where it is taking even more time to holding up lock and creating snowball 
effect on queued up transactions before going in a completely dead state.

I am wondering if it is safe to deadlock detection to be turned off by making
IGNITE_TX_DEADLOCK_DETECTION_MAX_ITERS to 0

Based on the guide, this detection is only for the bookkeeping and it is safe 
to turned off.

Any guidance on that would be greatly appreciated.

Ronak
Please follow the hyperlink to important disclosures.
https://www.dodgeandcox.com/disclosures/email_disclosure_funds.html

Re: Turning off deadlock detection

[Stephen Darlington]

Just a reminder that this list is run by volunteers. If you need responses
in a given time, commercial options are available.

On Sat, 23 Mar 2024 at 17:50, Ronak Shah  wrote:

> Ping again. Can someone answer please? - Ronak
>
> On Mon, Mar 18, 2024 at 12:04 PM Ronak Shah 
> wrote:
>
>> Hi Ignite users,
>> I am hitting a situation in a scaled environment where if the transaction
>> timeouts for whatever reason, the cluster goes in a deadlock detection
>> mode, where it is taking even more time to holding up lock and creating
>> snowball effect on queued up transactions before going in a completely dead
>> state.
>>
>> I am wondering if it is safe to deadlock detection to be turned off by
>> making
>> IGNITE_TX_DEADLOCK_DETECTION_MAX_ITERS to 0
>>
>> Based on the guide, this detection is only for the bookkeeping and it is
>> safe to turned off.
>>
>> Any guidance on that would be greatly appreciated.
>>
>> Ronak
>>
>

Re: Turning off deadlock detection

[Ronak Shah]

Thanks Jeremy for the reply. Why does deadlock detection pause all other transaction though for a min? Shouldnt it be a low priority thread job compared to db transactions?RonakOn Mar 24, 2024, at 8:52 PM, Jeremy McMillan  wrote:https://ignite.apache.org/docs/latest/key-value-api/transactions#deadlock-detectionThe property you're asking about is for diagnostics to enable prevention of future deadlocks. Turning it off is fine if you already know or can find out another way what is deadlocked and why.On Sat, Mar 23, 2024 at 12:50 PM Ronak Shah  wrote:Ping again. Can someone answer please? - RonakOn Mon, Mar 18, 2024 at 12:04 PM Ronak Shah  wrote:Hi Ignite users,I am hitting a situation in a scaled environment where if the transaction timeouts for whatever reason, the cluster goes in a deadlock detection mode, where it is taking even more time to holding up lock and creating snowball effect on queued up transactions before going in a completely dead state.I am wondering if it is safe to deadlock detection to be turned off by making IGNITE_TX_DEADLOCK_DETECTION_MAX_ITERS to 0Based on the guide, this detection is only for the bookkeeping and it is safe to turned off. Any guidance on that would be greatly appreciated.Ronak

Re: Turning off deadlock detection

[Jeremy McMillan]

https://ignite.apache.org/docs/latest/key-value-api/transactions#deadlock-detection

The property you're asking about is for diagnostics to enable prevention of
future deadlocks. Turning it off is fine if you already know or can find
out another way what is deadlocked and why.

On Sat, Mar 23, 2024 at 12:50 PM Ronak Shah 
wrote:

> Ping again. Can someone answer please? - Ronak
>
> On Mon, Mar 18, 2024 at 12:04 PM Ronak Shah 
> wrote:
>
>> Hi Ignite users,
>> I am hitting a situation in a scaled environment where if the transaction
>> timeouts for whatever reason, the cluster goes in a deadlock detection
>> mode, where it is taking even more time to holding up lock and creating
>> snowball effect on queued up transactions before going in a completely dead
>> state.
>>
>> I am wondering if it is safe to deadlock detection to be turned off by
>> making
>> IGNITE_TX_DEADLOCK_DETECTION_MAX_ITERS to 0
>>
>> Based on the guide, this detection is only for the bookkeeping and it is
>> safe to turned off.
>>
>> Any guidance on that would be greatly appreciated.
>>
>> Ronak
>>
>

Re: Turning off deadlock detection

[Ronak Shah]

Ping again. Can someone answer please? - Ronak

On Mon, Mar 18, 2024 at 12:04 PM Ronak Shah 
wrote:

> Hi Ignite users,
> I am hitting a situation in a scaled environment where if the transaction
> timeouts for whatever reason, the cluster goes in a deadlock detection
> mode, where it is taking even more time to holding up lock and creating
> snowball effect on queued up transactions before going in a completely dead
> state.
>
> I am wondering if it is safe to deadlock detection to be turned off by
> making
> IGNITE_TX_DEADLOCK_DETECTION_MAX_ITERS to 0
>
> Based on the guide, this detection is only for the bookkeeping and it is
> safe to turned off.
>
> Any guidance on that would be greatly appreciated.
>
> Ronak
>

Turning off deadlock detection

[Ronak Shah]

Hi Ignite users,
I am hitting a situation in a scaled environment where if the transaction
timeouts for whatever reason, the cluster goes in a deadlock detection
mode, where it is taking even more time to holding up lock and creating
snowball effect on queued up transactions before going in a completely dead
state.

I am wondering if it is safe to deadlock detection to be turned off by
making
IGNITE_TX_DEADLOCK_DETECTION_MAX_ITERS to 0

Based on the guide, this detection is only for the bookkeeping and it is
safe to turned off.

Any guidance on that would be greatly appreciated.

Ronak