Questions tagged [lock-timeout]
10 questions
10
votes
3 answers
Is there a liquibase lock timeout?
You can see in the issue here: (liquibase-lock-reasons) at situation where the client Liquibase locks when a Liquibase operation has been interrupted, leaving liquibase in a locked state.
I'm wondering if there is a way to configure Liquibase to…
hawkeye
- 34,745
- 30
- 150
- 304
2
votes
1 answer
SET LOCAL to a previously stored value
I want to temporarily change the lock_timeout in my PL/pgSQL function, and I thought it would be as simple as this:
CREATE OR REPLACE FUNCTION public.myfunction()
RETURNS void AS
$body$
DECLARE
l_tmp_lock_timeout TEXT;
BEGIN
-- We want this…
Bart Friederichs
- 33,050
- 15
- 95
- 195
2
votes
1 answer
Mysql lock wait timeout exceeded on update query
In the database of production server, a procedure runs by scheduler daily, in that Procedure I have few delete insert and update statements.
but it is throwing lock wait timeout exceeded error sometimes on 1 update that is using some frequently…
Alfaz Gori
- 73
- 1
- 6
1
vote
2 answers
What is alternative to "lock_timeout" in PostgreSQL?
I need to kill my session, if I'm blocking other sessions.But as of now we have only option to kill own session blocked by other sessions using lock_timeout.
Do we have option in postgres to timeout own session, if our session blocked other sessions…
satya prakash
- 21
- 3
1
vote
1 answer
What is locking my stateful bean
I have implemented a circuit breaker pattern in my java EE application and since it holds a state(how many failed requests, average response time, locked/unlocked and so on) I've set inte to be @Stateful.
And to avoid having issues with it being…
munHunger
- 2,572
- 5
- 34
- 63
1
vote
0 answers
SSMS Expanding Tables Lock Timeout for DB_READER
I have a very odd issue.
If a user with public and db_datareader access attempts to expand the tables in SSMS 17.2 they receive a Lock request time out period exceeded. (Microsoft SQL Server, Error: 1222) error.
If a user with sysadmin does the…
Peter Godwin
- 77
- 11
0
votes
1 answer
"SET LOCAL can only be used in transaction blocks" warning in PostgreSQL
When setting lock_timeout 10 seconds locally on psql as shown below:
SET LOCAL lock_timeout = 10000;
I got the warning below on psql:
WARNING: SET LOCAL can only be used in transaction blocks
Then, SET LOCAL lock_timeout = 10000; doesn't apply to…
Super Kai - Kazuya Ito
- 22,221
- 10
- 124
- 129
0
votes
1 answer
db2locktimeout log not found after enable DB2_CAPTURE_LOCKTIMEOUT=ON
Base on the following link:
https://www.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com.ibm.db2.luw.admin.regvars.doc/doc/r0005657.html
I turn on the the DB2_CAPTURE_LOCKTIMEOUT=ON, and then I check whether I successful change it or not by db2set…
Panadol Chong
- 1,793
- 13
- 54
- 119
0
votes
1 answer
transaction ran longer than lock timeout
currently I am trying to learn more on database,
right now I'm on DB2, and have locktimeout setting on 30s
to test it, I ran several thousand transaction simultaneously to stress test the server, and record the time taken for each stored procedure…
Fuad Hanif
- 33
- 7
-1
votes
1 answer
application server CPU go to >80 and hang after nearly 24 hour the same problem repeats every day
I have IBM WebSphere Application 8.5 server work with Db2 11.1 works from 2 years. Since a month the Application server hangs, the dB CPU goes to 0 and the application server CPU go to >80 , and hang after nearly 24 hour the same problem repeats…
noha Abdallah
- 1
- 1