db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-2010) Unsetting derby.locks.waitTimeout as a database property does not reset the wait timeout to the default value.
Date Wed, 08 Jul 2009 11:41:15 GMT

     [ https://issues.apache.org/jira/browse/DERBY-2010?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Knut Anders Hatlen updated DERBY-2010:
--------------------------------------

    Issue & fix info: [Repro attached]
             Urgency: Normal

Triaged for 10.5.2.

> Unsetting derby.locks.waitTimeout as a database property does not reset the wait timeout
to the default value.
> --------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-2010
>                 URL: https://issues.apache.org/jira/browse/DERBY-2010
>             Project: Derby
>          Issue Type: Bug
>          Components: Services
>    Affects Versions: 10.2.1.6, 10.3.1.4
>            Reporter: Daniel John Debrunner
>            Priority: Minor
>
> Simple script that shows the problem, requires a database db with a table T.
> First timeout wait is 60 seconds (default), next is 4 seconds (the setting), next is
4 seconds when it should be 60 the default.
> connect 'jdbc:derby:db' AS C1;
> AUTOCOMMIT OFF;
> LOCK TABLE T IN EXCLUSIVE MODE;
> connect 'jdbc:derby:db' AS C2;
> -- Default wait;
> VALUES CURRENT TIMESTAMP;
> LOCK TABLE T IN EXCLUSIVE MODE;
> VALUES CURRENT TIMESTAMP;
> -- 4 second wait
> CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(
>     'derby.locks.waitTimeout', '4');
> VALUES CURRENT TIMESTAMP;
> LOCK TABLE T IN EXCLUSIVE MODE;
> VALUES CURRENT TIMESTAMP;
> -- back to default
> CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(
>     'derby.locks.waitTimeout', null);
> VALUES CURRENT TIMESTAMP;
> LOCK TABLE T IN EXCLUSIVE MODE;
> VALUES CURRENT TIMESTAMP;

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message