L3 - Default Problem: I can not set a client side statement timeout using Mybatis
In some contexts it is useful to set a client side statement timeout. Example:
The process engine wants to update a row which is locked for a long time by a concurrent transaction which does not release the lock.
A customer (using postgresql) had the situation where an application server crashes with open in-flight transactions. These transactions will hold on to the locks until they are recovered. While those locks are held, concurrent transactions block on these locks potentially indefinitely.
AT:
- As a user, I can configure a client side statement timeout for modifications (update / delete) which allows me to set the maximum time I am willing to wait for an update / delete to succeed.
- The value can not be changed at runtime
This is the controller panel for Smart Panels app
[CAM-3943] I can not set client side statement timeout for SQL UPDATE/DELETE statements
| Description | Original: Problem: I can not set a client side statement timeout using Mybatis |
New:
Problem: I can not set a client side statement timeout using Mybatis In some contexts it is useful to set a client side statement timeout. Example: The process engine wants to update a row which is locked for a long time by a concurrent transaction which does not release the lock. A customer (using postgresql) had the situation where an application server crashes with open in-flight transactions. |
| Description |
Original:
Problem: I can not set a client side statement timeout using Mybatis In some contexts it is useful to set a client side statement timeout. Example: The process engine wants to update a row which is locked for a long time by a concurrent transaction which does not release the lock. A customer (using postgresql) had the situation where an application server crashes with open in-flight transactions. |
New:
Problem: I can not set a client side statement timeout using Mybatis In some contexts it is useful to set a client side statement timeout. Example: The process engine wants to update a row which is locked for a long time by a concurrent transaction which does not release the lock. A customer (using postgresql) had the situation where an application server crashes with open in-flight transactions. These transactions will hold on to the locks until they are recovered. While those locks are held, concurrent transactions block on these locks potentially indefinately |
| Description |
Original:
Problem: I can not set a client side statement timeout using Mybatis In some contexts it is useful to set a client side statement timeout. Example: The process engine wants to update a row which is locked for a long time by a concurrent transaction which does not release the lock. A customer (using postgresql) had the situation where an application server crashes with open in-flight transactions. These transactions will hold on to the locks until they are recovered. While those locks are held, concurrent transactions block on these locks potentially indefinately |
New:
Problem: I can not set a client side statement timeout using Mybatis In some contexts it is useful to set a client side statement timeout. Example: The process engine wants to update a row which is locked for a long time by a concurrent transaction which does not release the lock. A customer (using postgresql) had the situation where an application server crashes with open in-flight transactions. These transactions will hold on to the locks until they are recovered. While those locks are held, concurrent transactions block on these locks potentially indefinitely. AT: - As a user, I can configure a client side statement timeout for modifications (update / delete) which allows me to set the maximum time I am willing to wait for an update / delete to succeed. |
| Summary | Original: I can not set client side statement timeout using Mybatis | New: I can not set client side statement timeout for modifications |
| Description |
Original:
Problem: I can not set a client side statement timeout using Mybatis In some contexts it is useful to set a client side statement timeout. Example: The process engine wants to update a row which is locked for a long time by a concurrent transaction which does not release the lock. A customer (using postgresql) had the situation where an application server crashes with open in-flight transactions. These transactions will hold on to the locks until they are recovered. While those locks are held, concurrent transactions block on these locks potentially indefinitely. AT: - As a user, I can configure a client side statement timeout for modifications (update / delete) which allows me to set the maximum time I am willing to wait for an update / delete to succeed. |
New:
Problem: I can not set a client side statement timeout using Mybatis In some contexts it is useful to set a client side statement timeout. Example: The process engine wants to update a row which is locked for a long time by a concurrent transaction which does not release the lock. A customer (using postgresql) had the situation where an application server crashes with open in-flight transactions. These transactions will hold on to the locks until they are recovered. While those locks are held, concurrent transactions block on these locks potentially indefinitely. AT: - As a user, I can configure a client side statement timeout for modifications (update / delete) which allows me to set the maximum time I am willing to wait for an update / delete to succeed. |
| Description |
Original:
Problem: I can not set a client side statement timeout using Mybatis In some contexts it is useful to set a client side statement timeout. Example: The process engine wants to update a row which is locked for a long time by a concurrent transaction which does not release the lock. A customer (using postgresql) had the situation where an application server crashes with open in-flight transactions. These transactions will hold on to the locks until they are recovered. While those locks are held, concurrent transactions block on these locks potentially indefinitely. AT: - As a user, I can configure a client side statement timeout for modifications (update / delete) which allows me to set the maximum time I am willing to wait for an update / delete to succeed. |
New:
Problem: I can not set a client side statement timeout using Mybatis In some contexts it is useful to set a client side statement timeout. Example: The process engine wants to update a row which is locked for a long time by a concurrent transaction which does not release the lock. A customer (using postgresql) had the situation where an application server crashes with open in-flight transactions. These transactions will hold on to the locks until they are recovered. While those locks are held, concurrent transactions block on these locks potentially indefinitely. AT: - As a user, I can configure a client side statement timeout for modifications (update / delete) which allows me to set the maximum time I am willing to wait for an update / delete to succeed. - The value can be changed at runtime |
| Description |
Original:
Problem: I can not set a client side statement timeout using Mybatis In some contexts it is useful to set a client side statement timeout. Example: The process engine wants to update a row which is locked for a long time by a concurrent transaction which does not release the lock. A customer (using postgresql) had the situation where an application server crashes with open in-flight transactions. These transactions will hold on to the locks until they are recovered. While those locks are held, concurrent transactions block on these locks potentially indefinitely. AT: - As a user, I can configure a client side statement timeout for modifications (update / delete) which allows me to set the maximum time I am willing to wait for an update / delete to succeed. - The value can be changed at runtime |
New:
Problem: I can not set a client side statement timeout using Mybatis In some contexts it is useful to set a client side statement timeout. Example: The process engine wants to update a row which is locked for a long time by a concurrent transaction which does not release the lock. A customer (using postgresql) had the situation where an application server crashes with open in-flight transactions. These transactions will hold on to the locks until they are recovered. While those locks are held, concurrent transactions block on these locks potentially indefinitely. AT: - As a user, I can configure a client side statement timeout for modifications (update / delete) which allows me to set the maximum time I am willing to wait for an update / delete to succeed. - The value can be changed at runtime (?) |
| Link | New: This issue is related to SUPPORT-1563 [ SUPPORT-1563 ] |
| Summary | Original: I can not set client side statement timeout for modifications | New: I can not set client side statement timeout for SQL modifications |