You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-user@db.apache.org by Xavier Vigouroux <Xa...@Sun.COM> on 2005/07/04 18:47:32 UTC
locktable with null XID
hi,
I have some problems with the lock tables. here are my questions?
o In which conditions locktable() contains entries with NULL XIds?
o How can we get rid of them as the lock may not be relevant?
Thanks
--
Xavier VIGOUROUX - sun microsystems
Re: locktable with null XID
Posted by nexus <ne...@studcs.uni-sb.de>.
Sunitha Kambhampati <ks...@...> writes:
> > Could this be related to this issue that got fixed after 10.0.
> >
> > http://nagoya.apache.org/jira/browse/DERBY-94
> >
> Actually the correct link is http://issues.apache.org/jira/browse/DERBY-94
>
> Sunitha.
>
>
yes, indeed. the problem is gone with 10.1.
thanx!
nexus.
Re: locktable with null XID
Posted by Sunitha Kambhampati <ks...@gmail.com>.
Sunitha Kambhampati wrote:
> nexus wrote:
>
>>> I have the same problem here. It seems that the problem arises only if
>>> the "derby.locks.escalationThreshold" is too small?
>>>
>>> Is there a way to release such a lock? At the moment I handle the
>>> problem by shutting down cloudscape-server and restarting it again
>>> (very ugly).
>>>
>>> The Cloudscape-API tells that XID is never allowed to be "NULL". Thus
>>> I assume that is a bug? I am using Cloudscape_10.0.
>>
>>
> Could this be related to this issue that got fixed after 10.0.
>
> http://nagoya.apache.org/jira/browse/DERBY-94
>
Actually the correct link is http://issues.apache.org/jira/browse/DERBY-94
Sunitha.
Re: locktable with null XID
Posted by Sunitha Kambhampati <ks...@gmail.com>.
nexus wrote:
>> I have the same problem here. It seems that the problem arises only if
>> the "derby.locks.escalationThreshold" is too small?
>>
>> Is there a way to release such a lock? At the moment I handle the
>> problem by shutting down cloudscape-server and restarting it again
>> (very ugly).
>>
>> The Cloudscape-API tells that XID is never allowed to be "NULL". Thus
>> I assume that is a bug? I am using Cloudscape_10.0.
>
Could this be related to this issue that got fixed after 10.0.
http://nagoya.apache.org/jira/browse/DERBY-94
Could you try if you can reproduce this problem with a later version of Derby, ie 10.1 ?
Thanks,
Sunitha.
Re: locktable with null XID
Posted by Stanley Bradbury <St...@gmail.com>.
nexus wrote:
>Xavier Vigouroux <Xa...@...> writes:
>
>
>
>>hi,
>>
>>I have some problems with the lock tables. here are my questions?
>>
>>o In which conditions locktable() contains entries with NULL XIds?
>>o How can we get rid of them as the lock may not be relevant?
>>
>>Thanks
>>
>>
>
>
>I have the same problem here. It seems that the problem arises only if
>the "derby.locks.escalationThreshold" is too small?
>
>Is there a way to release such a lock? At the moment I handle the
>problem by shutting down cloudscape-server and restarting it again
>(very ugly).
>
>The Cloudscape-API tells that XID is never allowed to be "NULL". Thus
>I assume that is a bug? I am using Cloudscape_10.0.
>
>Help is appreciated!
>
>greetings
>
>nexus.
>
>
>
>
>
Hi Nexus -
I can't think what might cause this off the top of my head but if you
would post the lock information list and any errors you are getting I
would be happy to look into it. If you can make this happen at will
would you please post the escalationThreshold you are using and , if
possible, the code running that creates the problem?
Thanks
Re: locktable with null XID
Posted by nexus <ne...@studcs.uni-sb.de>.
Xavier Vigouroux <Xa...@...> writes:
>
> hi,
>
> I have some problems with the lock tables. here are my questions?
>
> o In which conditions locktable() contains entries with NULL XIds?
> o How can we get rid of them as the lock may not be relevant?
>
> Thanks
I have the same problem here. It seems that the problem arises only if
the "derby.locks.escalationThreshold" is too small?
Is there a way to release such a lock? At the moment I handle the
problem by shutting down cloudscape-server and restarting it again
(very ugly).
The Cloudscape-API tells that XID is never allowed to be "NULL". Thus
I assume that is a bug? I am using Cloudscape_10.0.
Help is appreciated!
greetings
nexus.