Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Does ASA 8.01 or 7.3 support true row locking?

13 posts in General Discussion Last posting was on 2003-02-12 13:50:56.0Z
Jonathan_Lin Posted on 2003-02-08 05:36:12.0Z
From: Jonathan_Lin
Date: Sat, 8 Feb 2003 00:36:12 -0500
Newsgroups: ianywhere.public.general
Subject: Does ASA 8.01 or 7.3 support true row locking?
Message-ID: <4D74442FB667C556001EC7AA85256CC7.001EC7B885256CC7@webforums>
Lines: 15
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:162
Article PK: 1983

Hi,

Does ASA 8.01 or 7.3 support true row locking?

When using ASA 8.01 or 7.3 under isolation level 0, we observed that the
ASA will lock tne next immediate row when updating the columns having
unique constraints in a row. If it supports true row locking, why would it
lock additional row when doing update operation? Is this a known problem or
a misconfiguration? Is there any good workaround for this problem?

Does the ASE 12.5 have the same behavior?

I'm very much appreciated for any help and advice. Thanks in advance.

Jon


Jonathan_Lin Posted on 2003-02-08 21:53:23.0Z
From: Jonathan_Lin
Date: Sat, 8 Feb 2003 16:53:23 -0500
Newsgroups: ianywhere.public.general
Subject: Re: Does ASA 8.01 or 7.3 support true row locking?
Message-ID: <8ED1B73FCBD3DE4200783E7B85256CC7.00230E4B85256CC7@webforums>
References: <4D74442FB667C556001EC7AA85256CC7.001EC7B885256CC7@webforums>
Lines: 20
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:161
Article PK: 1982

Here are the more details about the test results on the row level lockings
I have done:

1. Update unique constrainted column the first time, only one of the
immediate previous or next row is locked randomly.
2. Update unique constrainted column the second time, the whole table is
locked.
3. Insert a new row and update the row on unique constrainted columns, the
whole table is locked.
4. Insert two new rows and update unique constrainted column of the first
new row the first time, no additional lock is found.
5. Insert two new rows and update unique constrainted column of the first
new row the second time, the whole table is locked.
6. Update the normal column on the last row, the previous row is locked if
its unique constrainted column is updated.

Is this caused by a mis-configuration, a bug, or the fundamental design
problem of ANA? Any helps on this is very much appreciated. Thanks.

Jon


Chris Keating Posted on 2003-02-09 17:41:48.0Z
From: "Chris Keating" <Spam_Free_keating@iAnywhere.com>
References: <4D74442FB667C556001EC7AA85256CC7.001EC7B885256CC7@webforums> <8ED1B73FCBD3DE4200783E7B85256CC7.00230E4B85256CC7@webforums>
Subject: Re: Does ASA 8.01 or 7.3 support true row locking?
Date: Sun, 9 Feb 2003 12:41:48 -0500
Lines: 29
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
Message-ID: <kaKB3UG0CHA.198@forums.sybase.com>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: CPE00045af8ce8c-CM012059936305.cpe.net.cable.rogers.com 24.156.62.193
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub ianywhere.public.general:160
Article PK: 1980

This is most likely neither a misconfiguration, bug, or design problem in
ASA. I recommend that you read the documentation related to locks -- phantom
locks in particular.

<Jonathan_Lin> wrote in message
news:8ED1B73FCBD3DE4200783E7B85256CC7.00230E4B85256CC7@webforums...
> Here are the more details about the test results on the row level lockings
> I have done:
>
> 1. Update unique constrainted column the first time, only one of the
> immediate previous or next row is locked randomly.
> 2. Update unique constrainted column the second time, the whole table is
> locked.
> 3. Insert a new row and update the row on unique constrainted columns, the
> whole table is locked.
> 4. Insert two new rows and update unique constrainted column of the first
> new row the first time, no additional lock is found.
> 5. Insert two new rows and update unique constrainted column of the first
> new row the second time, the whole table is locked.
> 6. Update the normal column on the last row, the previous row is locked if
> its unique constrainted column is updated.
>
> Is this caused by a mis-configuration, a bug, or the fundamental design
> problem of ANA? Any helps on this is very much appreciated. Thanks.
>
> Jon


Jonathan_Lin Posted on 2003-02-10 08:18:21.0Z
From: Jonathan_Lin
Date: Mon, 10 Feb 2003 03:18:21 -0500
Newsgroups: ianywhere.public.general
Subject: Re: Does ASA 8.01 or 7.3 support true row locking?
Message-ID: <A6201C20A16060B3002DA03B85256CC9.0065CC3285256CC8@webforums>
References: <4D74442FB667C556001EC7AA85256CC7.001EC7B885256CC7@webforums> <8ED1B73FCBD3DE4200783E7B85256CC7.00230E4B85256CC7@webforums> <kaKB3UG0CHA.198@forums.sybase.com>
Lines: 52
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:159
Article PK: 1978

I'm running the test under isolation level 0. So, why doesn't it have any
different locking behavior from the higher isolation levels? I thought that
the lower isolation level may give us less restrictive locking. Also, the
insertion only from different db connection in my test still works. It's
the following update operations are causing the locking problem.

Please note that the test #1 and test #2 are tested with update operations
only without inserting new rows. And the locking behavior for the first
update and second update are different.

Also, does this mean that ASA doesn't support the true row locking? What I
meant 'true row locking' means that operations on the row only lock the row
itself without affecting other rows.

Does the ASE 12.5 have the same behavior as ASA? Or does ASE support the
true row locking?

Thanks for the help.

Jon

"Chris Keating" <Spam_Free_keating@iAnywhere.com> wrote in message
news:<kaKB3UG0CHA.198@forums.sybase.com>...
> This is most likely neither a misconfiguration, bug, or design problem
in
> ASA. I recommend that you read the documentation related to locks --
phantom
> locks in particular.
>
>
> <Jonathan_Lin> wrote in message
> news:8ED1B73FCBD3DE4200783E7B85256CC7.00230E4B85256CC7@webforums...
> > Here are the more details about the test results on the row level
lockings
> > I have done:
> >
> > 1. Update unique constrainted column the first time, only one of the
> > immediate previous or next row is locked randomly.
> > 2. Update unique constrainted column the second time, the whole table
is
> > locked.
> > 3. Insert a new row and update the row on unique constrainted columns,
the
> > whole table is locked.
> > 4. Insert two new rows and update unique constrainted column of the
first
> > new row the first time, no additional lock is found.
> > 5. Insert two new rows and update unique constrainted column of the
first
> > new row the second time, the whole table is locked.
> > 6. Update the normal column on the last row, the previous row is locked
if
> > its unique constrainted column is updated.
> >
> > Is this caused by a mis-configuration, a bug, or the fundamental design
> > problem of ANA? Any helps on this is very much appreciated. Thanks.
> >
> > Jon
>
>


Chris Keating Posted on 2003-02-10 13:10:56.0Z
From: "Chris Keating" <Fight_Spam_keating@iAnywhere.com>
References: <4D74442FB667C556001EC7AA85256CC7.001EC7B885256CC7@webforums> <8ED1B73FCBD3DE4200783E7B85256CC7.00230E4B85256CC7@webforums> <kaKB3UG0CHA.198@forums.sybase.com> <A6201C20A16060B3002DA03B85256CC9.0065CC3285256CC8@webforums>
Subject: Re: Does ASA 8.01 or 7.3 support true row locking?
Date: Mon, 10 Feb 2003 08:10:56 -0500
Lines: 83
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
Message-ID: <oEyeLiQ0CHA.198@forums.sybase.com>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: 172.31.140.19
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub ianywhere.public.general:156
Article PK: 1976

Call sa_locks when running each of your tests and provide the results. I
suspect that you will find phantom locks.

--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8
iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use CaseXpress to report bugs http://casexpress.sybase.com

<Jonathan_Lin> wrote in message
news:A6201C20A16060B3002DA03B85256CC9.0065CC3285256CC8@webforums...
> I'm running the test under isolation level 0. So, why doesn't it have any
> different locking behavior from the higher isolation levels? I thought
that
> the lower isolation level may give us less restrictive locking. Also, the
> insertion only from different db connection in my test still works. It's
> the following update operations are causing the locking problem.
>
> Please note that the test #1 and test #2 are tested with update operations
> only without inserting new rows. And the locking behavior for the first
> update and second update are different.
>
> Also, does this mean that ASA doesn't support the true row locking? What I
> meant 'true row locking' means that operations on the row only lock the
row
> itself without affecting other rows.
>
> Does the ASE 12.5 have the same behavior as ASA? Or does ASE support the
> true row locking?
>
> Thanks for the help.
>
> Jon
>
> "Chris Keating" <Spam_Free_keating@iAnywhere.com> wrote in message
> news:<kaKB3UG0CHA.198@forums.sybase.com>...
> > This is most likely neither a misconfiguration, bug, or design problem
> in
> > ASA. I recommend that you read the documentation related to locks --
> phantom
> > locks in particular.
> >
> >
> > <Jonathan_Lin> wrote in message
> > news:8ED1B73FCBD3DE4200783E7B85256CC7.00230E4B85256CC7@webforums...
> > > Here are the more details about the test results on the row level
> lockings
> > > I have done:
> > >
> > > 1. Update unique constrainted column the first time, only one of the
> > > immediate previous or next row is locked randomly.
> > > 2. Update unique constrainted column the second time, the whole table
> is
> > > locked.
> > > 3. Insert a new row and update the row on unique constrainted columns,
> the
> > > whole table is locked.
> > > 4. Insert two new rows and update unique constrainted column of the
> first
> > > new row the first time, no additional lock is found.
> > > 5. Insert two new rows and update unique constrainted column of the
> first
> > > new row the second time, the whole table is locked.
> > > 6. Update the normal column on the last row, the previous row is
locked
> if
> > > its unique constrainted column is updated.
> > >
> > > Is this caused by a mis-configuration, a bug, or the fundamental
design
> > > problem of ANA? Any helps on this is very much appreciated. Thanks.
> > >
> > > Jon
> >
> >


Jonathan_Lin Posted on 2003-02-11 02:02:12.0Z
From: Jonathan_Lin
Date: Mon, 10 Feb 2003 21:02:12 -0500
Newsgroups: ianywhere.public.general
Subject: Re: Does ASA 8.01 or 7.3 support true row locking?
Message-ID: <F0F7EF147048A880000B2FF285256CCA.004EE90785256CC9@webforums>
References: <4D74442FB667C556001EC7AA85256CC7.001EC7B885256CC7@webforums> <8ED1B73FCBD3DE4200783E7B85256CC7.00230E4B85256CC7@webforums> <kaKB3UG0CHA.198@forums.sybase.com> <A6201C20A16060B3002DA03B85256CC9.0065CC3285256CC8@webforums> <oEyeLiQ0CHA.198@forums.sybase.com>
Lines: 486
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:151
Article PK: 1971

Hi, Chris,

Here's the results. Thanks for the help.

1. Update unique constrainted column the first time, only one of the
immediate previous or next row is locked randomly.

update t_servicefeatureinfo set servicefeature = 'ttt5' where id=525; --
from jchlin-1 (db connection)

connection,user_id,table_name,lock_type,lock_name
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','E',3534758084620

1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPA0005',3534758084621


Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,NodeAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
1876569969,'jchlin-1','mwcuser',0,'2003-02-10
16:32:41.014',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',2903,0,0,0,7
298937754,'jchlin-2','mwcuser',0,'2003-02-10
16:26:29.878',,,'STMT_DROP','TCPIP','128.107.133.207',1941,0,0,0,0

-- id 526 is the immediate next row to id 525
update t_servicefeatureinfo set servicefeature = 'ttt3' where id=526; --
from jchlin-2 (db connection) got blocked

connection,user_id,table_name,lock_type,lock_name
298937754,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','E',3534758084620

1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPA0005',3534758084621


Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,NodeAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
1876569969,'jchlin-1','mwcuser',0,'2003-02-10
16:33:56.938',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',5844,0,0,0,13
298937754,'jchlin-2','mwcuser',0,'2003-02-10
16:33:29.658',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',8141,0,1876569969,3534758084621,0


2. Update unique constrainted column the second time, the whole table is
locked.

update t_servicefeatureinfo set servicefeature = 'ttt10' where id=525; --
from jchlin-1 (continued from test #1)

connection,user_id,table_name,lock_type,lock_name
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',

1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPA0005',2263447764998

1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','EPA0005',3534758084620

1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPA0005',3534758084621


Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,NodeAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
1876569969,'jchlin-1','mwcuser',0,'2003-02-10
16:37:10.769',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',3730,0,0,0,9
298937754,'jchlin-2','mwcuser',0,'2003-02-10
16:34:23.795',,,'STMT_DROP','TCPIP','128.107.133.207',6402,0,0,0,0


update t_servicefeatureinfo set servicefeature = 'ttt3' where id=526; --
from jchlin-2 got blocked

connection,user_id,table_name,lock_type,lock_name
298937754,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',

1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPA0005',2263447764998

1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','EPA0005',3534758084620

1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPA0005',3534758084621


Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,NodeAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
1876569969,'jchlin-1','mwcuser',0,'2003-02-10
16:38:54.296',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',7852,0,0,0,16
298937754,'jchlin-2','mwcuser',0,'2003-02-10
16:38:00.181',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',9375,0,1876569969,3534758084621,0

3. Insert a new row and update the row on unique constrainted columns, the
whole table is locked.
-- insert a new row from jchlin-1
INSERT INTO t_servicefeatureinfo
(description,serviceprofile,servicefeature,usecasename,featureinstanceid,provisioningerrorstatus,provisioningstate,provisioningmsg,templatename,templateversion,holdertablename,holderid,provisioningid,devicetable,deviceid,cardtable,cardid,peerholdertablename,peerholderid
) VALUES ( 'ttt','ttt','ttt1','ttt',' ',0,2,null,'ttt','
','t_iprouteinfo',2,'406','t_btsrouter',2,'t_btsrouter',2,null,null);

connection,user_id,table_name,lock_type,lock_name
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','E',3612067495936


Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,NodeAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
1876569969,'jchlin-1','mwcuser',0,'2003-02-10
16:47:41.305',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',5266,0,0,0,3
298937754,'jchlin-2','mwcuser',0,'2003-02-10
16:46:53.313',,,'STMT_DROP','TCPIP','128.107.133.207',8789,0,0,0,0

-- update the newly created row from jchlin-1
update t_servicefeatureinfo set servicefeature = 'ttt5' where id=689;
connection,user_id,table_name,lock_type,lock_name
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',

1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPA0005',2263447764998

1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','EPA0005',3612067495936


Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,NodeAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
1876569969,'jchlin-1','mwcuser',0,'2003-02-10
16:49:10.464',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',5221,0,0,0,9
298937754,'jchlin-2','mwcuser',0,'2003-02-10
16:48:11.102',,,'STMT_DROP','TCPIP','128.107.133.207',5560,0,0,0,0

-- insert a new row from jchlin-2 got blocked
INSERT INTO t_servicefeatureinfo
(description,serviceprofile,servicefeature,usecasename,featureinstanceid,provisioningerrorstatus,provisioningstate,provisioningmsg,templatename,templateversion,holdertablename,holderid,provisioningid,devicetable,deviceid,cardtable,cardid,peerholdertablename,peerholderid
) VALUES ('ttt','ttt','ttt4','ttt',' ',0,2,null,'ttt','
','t_iprouteinfo',2,'406','t_btsrouter',2,'t_btsrouter',2,null,null);
connection,user_id,table_name,lock_type,lock_name
298937754,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
298937754,'mwcuser','mwcuser.t_servicefeatureinfo','E',3612067495937
298937754,'mwcuser','mwcuser.t_servicefeatureinfo','E',3612067495937
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',

1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPA0005',2263447764998

1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','EPA0005',3612067495936


Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,NodeAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
1876569969,'jchlin-1','mwcuser',0,'2003-02-10
16:49:59.590',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',6031,0,0,0,17
298937754,'jchlin-2','mwcuser',0,'2003-02-10
16:49:35.620',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',6662,0,1876569969,3612067495936,0

-- update 525's immediate next row from jchlin-2 got blocked
update t_servicefeatureinfo set servicefeature = 'ttt3' where id=526;

connection,user_id,table_name,lock_type,lock_name
298937754,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
298937754,'mwcuser','mwcuser.t_servicefeatureinfo','E',3534758084621
298937754,'mwcuser','mwcuser.t_servicefeatureinfo','SPA0005',3573412790290
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',

1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPA0005',2263447764998

1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','EPA0005',3612067495936


Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,NodeAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
1876569969,'jchlin-1','mwcuser',0,'2003-02-10
16:50:52.850',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',6766,0,0,0,25
298937754,'jchlin-2','mwcuser',0,'2003-02-10
16:50:27.836',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',4711,0,1876569969,3612067495936,0



4. Insert two new rows and update unique constrainted column of the first
new row the first time, no additional lock is found.
-- insert 1st new row from jchlin-1
INSERT INTO t_servicefeatureinfo
(description,serviceprofile,servicefeature,usecasename,featureinstanceid,provisioningerrorstatus,provisioningstate,provisioningmsg,templatename,templateversion,holdertablename,holderid,provisioningid,devicetable,deviceid,cardtable,cardid,peerholdertablename,peerholderid
) VALUES ( 'ttt','ttt','ttt1','ttt',' ',0,2,null,'ttt','
','t_iprouteinfo',2,'406','t_btsrouter',2,'t_btsrouter',2,null,null);
connection,user_id,table_name,lock_type,lock_name
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','E',3612067495936


Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,NodeAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
1876569969,'jchlin-1','mwcuser',0,'2003-02-10
16:52:48.194',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',5844,0,0,0,3
298937754,'jchlin-2','mwcuser',0,'2003-02-10
16:52:00.173',,,'STMT_DROP','TCPIP','128.107.133.207',3078,0,0,0,0

-- insert 2nd new row from jchlin-1 again
INSERT INTO t_servicefeatureinfo
(description,serviceprofile,servicefeature,usecasename,featureinstanceid,provisioningerrorstatus,provisioningstate,provisioningmsg,templatename,templateversion,holdertablename,holderid,provisioningid,devicetable,deviceid,cardtable,cardid,peerholdertablename,peerholderid
) VALUES ('ttt','ttt','ttt2','ttt',' ',0,2,null,'ttt','
','t_iprouteinfo',2,'406','t_btsrouter',2,'t_btsrouter',2,null,null);
connection,user_id,table_name,lock_type,lock_name
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','E',3612067495936
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','E',3612067495937


Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,NodeAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
1876569969,'jchlin-1','mwcuser',0,'2003-02-10
16:53:15.153',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',3319,0,0,0,9
298937754,'jchlin-2','mwcuser',0,'2003-02-10
16:52:00.173',,,'STMT_DROP','TCPIP','128.107.133.207',3078,0,0,0,0

-- update the the first newly created row from jchlin-1
update t_servicefeatureinfo set servicefeature = 'ttt5' where id=693;
connection,user_id,table_name,lock_type,lock_name
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','E',3612067495936

1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','EPA0005',3612067495937


Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,NodeAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
1876569969,'jchlin-1','mwcuser',0,'2003-02-10
16:54:25.200',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',4080,0,0,0,15
298937754,'jchlin-2','mwcuser',0,'2003-02-10
16:52:00.173',,,'STMT_DROP','TCPIP','128.107.133.207',3078,0,0,0,0

-- insert a new row from jchlin-2 successfully
INSERT INTO t_servicefeatureinfo
(description,serviceprofile,servicefeature,usecasename,featureinstanceid,provisioningerrorstatus,provisioningstate,provisioningmsg,templatename,templateversion,holdertablename,holderid,provisioningid,devicetable,deviceid,cardtable,cardid,peerholdertablename,peerholderid
) VALUES ('ttt','ttt','ttt4','ttt',' ',0,2,null,'ttt','
','t_iprouteinfo',2,'406','t_btsrouter',2,'t_btsrouter',2,null,null);
connection,user_id,table_name,lock_type,lock_name
298937754,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
298937754,'mwcuser','mwcuser.t_servicefeatureinfo','E',3612067495938
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','E',3612067495936

1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','EPA0005',3612067495937


Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,NodeAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
1876569969,'jchlin-1','mwcuser',0,'2003-02-10
16:55:22.998',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',5690,0,0,0,22
298937754,'jchlin-2','mwcuser',0,'2003-02-10
16:54:40.596',,,'STMT_DROP','TCPIP','128.107.133.207',5968,0,0,0,1

-- update 525's immediate next row from jchlin-2 successfully
update t_servicefeatureinfo set servicefeature = 'ttt3' where id=526;
connection,user_id,table_name,lock_type,lock_name
298937754,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
298937754,'mwcuser','mwcuser.t_servicefeatureinfo','E',3534758084621
298937754,'mwcuser','mwcuser.t_servicefeatureinfo','SPA0005',3573412790290
298937754,'mwcuser','mwcuser.t_servicefeatureinfo','E',3612067495938
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','E',3612067495936

1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','EPA0005',3612067495937


Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,NodeAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
1876569969,'jchlin-1','mwcuser',0,'2003-02-10
16:57:05.596',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',9344,0,0,0,31
298937754,'jchlin-2','mwcuser',0,'2003-02-10
16:56:00.974',,,'STMT_DROP','TCPIP','128.107.133.207',6424,0,0,0,2



5. Insert two new rows and update unique constrainted column of the first
new row the second time, the whole table is locked.
continue from 4:

-- continue from test #4, update the the first newly created row the 2nd
time from jchlin-1
update t_servicefeatureinfo set servicefeature = 'ttt10' where id=693;
connection,user_id,table_name,lock_type,lock_name
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',

1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPA0005',2263447764998

1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','EPA0005',3612067495936

1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','EPA0005',3612067495937


Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,NodeAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
1876569969,'jchlin-1','mwcuser',0,'2003-02-10
16:58:46.919',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',6048,0,0,0,38
298937754,'jchlin-2','mwcuser',0,'2003-02-10
16:57:49.353',,,'STMT_DROP','TCPIP','128.107.133.207',8789,0,0,0,0

-- insert a new row from jchlin-2 got blocked
INSERT INTO t_servicefeatureinfo
(description,serviceprofile,servicefeature,usecasename,featureinstanceid,provisioningerrorstatus,provisioningstate,provisioningmsg,templatename,templateversion,holdertablename,holderid,provisioningid,devicetable,deviceid,cardtable,cardid,peerholdertablename,peerholderid
) VALUES ('ttt','ttt','ttt4','ttt',' ',0,2,null,'ttt','
','t_iprouteinfo',2,'406','t_btsrouter',2,'t_btsrouter',2,null,null);
connection,user_id,table_name,lock_type,lock_name
298937754,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
298937754,'mwcuser','mwcuser.t_servicefeatureinfo','E',3612067495938
298937754,'mwcuser','mwcuser.t_servicefeatureinfo','E',3612067495938
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',

1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPA0005',2263447764998

1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','EPA0005',3612067495936

1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','EPA0005',3612067495937


Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,NodeAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
1876569969,'jchlin-1','mwcuser',0,'2003-02-10
16:59:23.097',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',5937,0,0,0,47
298937754,'jchlin-2','mwcuser',0,'2003-02-10
16:59:04.094',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',9375,0,1876569969,2263447764998,0

-- update 525's immediate next row from jchlin-2 got blocked
update t_servicefeatureinfo set servicefeature = 'ttt3' where id=526;
connection,user_id,table_name,lock_type,lock_name
298937754,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
298937754,'mwcuser','mwcuser.t_servicefeatureinfo','E',3534758084621
298937754,'mwcuser','mwcuser.t_servicefeatureinfo','SPA0005',3573412790290
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',

1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPA0005',2263447764998

1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','EPA0005',3612067495936

1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','EPA0005',3612067495937


Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,NodeAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
1876569969,'jchlin-1','mwcuser',0,'2003-02-10
16:59:57.368',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',5758,0,0,0,56
298937754,'jchlin-2','mwcuser',0,'2003-02-10
16:59:41.645',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',6768,0,1876569969,2263447764998,0


6. Update the normal column on the last row, the previous row is locked if
its unique constrainted column is updated.
-- update the normal column on the last row from jchlin-1
update t_servicefeatureinfo set provisioningstate = 56 where id=526
connection,user_id,table_name,lock_type,lock_name
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','E',3534758084621


Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,NodeAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
1876569969,'jchlin-1','mwcuser',0,'2003-02-10
17:01:32.517',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',5092,0,0,0,3
298937754,'jchlin-2','mwcuser',0,'2003-02-10
17:00:36.110',,,'STMT_DROP','TCPIP','128.107.133.207',3297,0,0,0,0

-- update the row in front of the last row from jchlin-2 got blocked
update t_servicefeatureinfo set servicefeature = 'ttt3' where id=525;
connection,user_id,table_name,lock_type,lock_name
298937754,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
298937754,'mwcuser','mwcuser.t_servicefeatureinfo','E',3534758084620
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','E',3534758084621


Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,NodeAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
1876569969,'jchlin-1','mwcuser',0,'2003-02-10
17:02:15.051',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',5599,0,0,0,9
298937754,'jchlin-2','mwcuser',0,'2003-02-10
17:01:57.254',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',7652,0,1876569969,3534758084621,0

Jon

"Chris Keating" <Fight_Spam_keating@iAnywhere.com> wrote in message
news:<oEyeLiQ0CHA.198@forums.sybase.com>...
> Call sa_locks when running each of your tests and provide the results. I
> suspect that you will find phantom locks.
>
> --
>
> Chris Keating
> Sybase Adaptive Server Anywhere Professional Version 8
> iAnywhere Solutions http://www.iAnywhere.com
>
> ** Please only post to the newsgroup
>
> ** Whitepapers can be found at http://www.iAnywhere.com/developer
> ** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
> ** Use CaseXpress to report bugs http://casexpress.sybase.com
>
> <Jonathan_Lin> wrote in message
> news:A6201C20A16060B3002DA03B85256CC9.0065CC3285256CC8@webforums...
> > I'm running the test under isolation level 0. So, why doesn't it have
any
> > different locking behavior from the higher isolation levels? I thought
> that
> > the lower isolation level may give us less restrictive locking. Also,
the
> > insertion only from different db connection in my test still works.
It's
> > the following update operations are causing the locking problem.
> >
> > Please note that the test #1 and test #2 are tested with update
operations
> > only without inserting new rows. And the locking behavior for the first
> > update and second update are different.
> >
> > Also, does this mean that ASA doesn't support the true row locking?
What I
> > meant 'true row locking' means that operations on the row only lock the
> row
> > itself without affecting other rows.
> >
> > Does the ASE 12.5 have the same behavior as ASA? Or does ASE support
the
> > true row locking?
> >
> > Thanks for the help.
> >
> > Jon
> >
> > "Chris Keating" <Spam_Free_keating@iAnywhere.com> wrote in message
> > news:<kaKB3UG0CHA.198@forums.sybase.com>...
> > > This is most likely neither a misconfiguration, bug, or design
problem
> > in
> > > ASA. I recommend that you read the documentation related to locks --
> > phantom
> > > locks in particular.
> > >
> > >
> > > <Jonathan_Lin> wrote in message
> > > news:8ED1B73FCBD3DE4200783E7B85256CC7.00230E4B85256CC7@webforums...
> > > > Here are the more details about the test results on the row level
> > lockings
> > > > I have done:
> > > >
> > > > 1. Update unique constrainted column the first time, only one of
the
> > > > immediate previous or next row is locked randomly.
> > > > 2. Update unique constrainted column the second time, the whole
table
> > is
> > > > locked.
> > > > 3. Insert a new row and update the row on unique constrainted
columns,
> > the
> > > > whole table is locked.
> > > > 4. Insert two new rows and update unique constrainted column of the
> > first
> > > > new row the first time, no additional lock is found.
> > > > 5. Insert two new rows and update unique constrainted column of the
> > first
> > > > new row the second time, the whole table is locked.
> > > > 6. Update the normal column on the last row, the previous row is
> locked
> > if
> > > > its unique constrainted column is updated.
> > > >
> > > > Is this caused by a mis-configuration, a bug, or the fundamental
> design
> > > > problem of ANA? Any helps on this is very much appreciated. Thanks.
> > > >
> > > > Jon
> > >
> > >
>
>


Robert Waywell Posted on 2003-02-11 14:08:22.0Z
From: "Robert Waywell" <rwaywell@ianywhere.com>
References: <4D74442FB667C556001EC7AA85256CC7.001EC7B885256CC7@webforums> <8ED1B73FCBD3DE4200783E7B85256CC7.00230E4B85256CC7@webforums> <kaKB3UG0CHA.198@forums.sybase.com> <A6201C20A16060B3002DA03B85256CC9.0065CC3285256CC8@webforums> <oEyeLiQ0CHA.198@forums.sybase.com> <F0F7EF147048A880000B2FF285256CCA.004EE90785256CC9@webforums>
Subject: Re: Does ASA 8.01 or 7.3 support true row locking?
Date: Tue, 11 Feb 2003 09:08:22 -0500
Lines: 641
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <BfVo9md0CHA.351@forums.sybase.com>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: 172.31.143.74
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub ianywhere.public.general:147
Article PK: 1965

Can you post the CREATE TABLE statement plus all CREATE INDEX and Foreign
Key definitions?
Can you provide the details of the records currently in the table at the
time you run these tests?


--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

<Jonathan_Lin> wrote in message
news:F0F7EF147048A880000B2FF285256CCA.004EE90785256CC9@webforums...
> Hi, Chris,
>
> Here's the results. Thanks for the help.
>
> 1. Update unique constrainted column the first time, only one of the
> immediate previous or next row is locked randomly.
>
> update t_servicefeatureinfo set servicefeature = 'ttt5' where id=525; --
> from jchlin-1 (db connection)
>
> connection,user_id,table_name,lock_type,lock_name
> 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','E',3534758084620
>
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPA0005',3534758084621
>
>
>

Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,No
deAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
> 1876569969,'jchlin-1','mwcuser',0,'2003-02-10
>
16:32:41.014',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',2903,0,0,0,
7
> 298937754,'jchlin-2','mwcuser',0,'2003-02-10
> 16:26:29.878',,,'STMT_DROP','TCPIP','128.107.133.207',1941,0,0,0,0
>
> -- id 526 is the immediate next row to id 525
> update t_servicefeatureinfo set servicefeature = 'ttt3' where id=526; --
> from jchlin-2 (db connection) got blocked
>



> connection,user_id,table_name,lock_type,lock_name
> 298937754,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','E',3534758084620
>
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPA0005',3534758084621
>
>
>
Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,No
deAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
> 1876569969,'jchlin-1','mwcuser',0,'2003-02-10
>
16:33:56.938',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',5844,0,0,0,
13
> 298937754,'jchlin-2','mwcuser',0,'2003-02-10
>
16:33:29.658',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',8141,0,1876
569969,3534758084621,0
>
>
> 2. Update unique constrainted column the second time, the whole table is
> locked.
>
> update t_servicefeatureinfo set servicefeature = 'ttt10' where id=525; --
> from jchlin-1 (continued from test #1)
>
> connection,user_id,table_name,lock_type,lock_name
> 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
>
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPA0005',2263447764998
>
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','EPA0005',3534758084620
>
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPA0005',3534758084621
>
>
>
Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,No
deAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
> 1876569969,'jchlin-1','mwcuser',0,'2003-02-10
>
16:37:10.769',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',3730,0,0,0,
9
> 298937754,'jchlin-2','mwcuser',0,'2003-02-10
> 16:34:23.795',,,'STMT_DROP','TCPIP','128.107.133.207',6402,0,0,0,0
>
>
> update t_servicefeatureinfo set servicefeature = 'ttt3' where id=526; --
> from jchlin-2 got blocked
>
> connection,user_id,table_name,lock_type,lock_name
> 298937754,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
>
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPA0005',2263447764998
>
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','EPA0005',3534758084620
>
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPA0005',3534758084621
>
>
>
Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,No
deAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
> 1876569969,'jchlin-1','mwcuser',0,'2003-02-10
>
16:38:54.296',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',7852,0,0,0,
16
> 298937754,'jchlin-2','mwcuser',0,'2003-02-10
>
16:38:00.181',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',9375,0,1876
569969,3534758084621,0
>
> 3. Insert a new row and update the row on unique constrainted columns, the
> whole table is locked.
> -- insert a new row from jchlin-1
> INSERT INTO t_servicefeatureinfo
>
(description,serviceprofile,servicefeature,usecasename,featureinstanceid,pro
visioningerrorstatus,provisioningstate,provisioningmsg,templatename,template
version,holdertablename,holderid,provisioningid,devicetable,deviceid,cardtab
le,cardid,peerholdertablename,peerholderid
> ) VALUES ( 'ttt','ttt','ttt1','ttt',' ',0,2,null,'ttt','
> ','t_iprouteinfo',2,'406','t_btsrouter',2,'t_btsrouter',2,null,null);
>
> connection,user_id,table_name,lock_type,lock_name
> 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','E',3612067495936
>
>
>
Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,No
deAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
> 1876569969,'jchlin-1','mwcuser',0,'2003-02-10
>
16:47:41.305',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',5266,0,0,0,
3
> 298937754,'jchlin-2','mwcuser',0,'2003-02-10
> 16:46:53.313',,,'STMT_DROP','TCPIP','128.107.133.207',8789,0,0,0,0
>
> -- update the newly created row from jchlin-1
> update t_servicefeatureinfo set servicefeature = 'ttt5' where id=689;
> connection,user_id,table_name,lock_type,lock_name
> 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
>
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPA0005',2263447764998
>
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','EPA0005',3612067495936
>
>
>
Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,No
deAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
> 1876569969,'jchlin-1','mwcuser',0,'2003-02-10
>
16:49:10.464',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',5221,0,0,0,
9
> 298937754,'jchlin-2','mwcuser',0,'2003-02-10
> 16:48:11.102',,,'STMT_DROP','TCPIP','128.107.133.207',5560,0,0,0,0
>
> -- insert a new row from jchlin-2 got blocked
> INSERT INTO t_servicefeatureinfo
>
(description,serviceprofile,servicefeature,usecasename,featureinstanceid,pro
visioningerrorstatus,provisioningstate,provisioningmsg,templatename,template
version,holdertablename,holderid,provisioningid,devicetable,deviceid,cardtab
le,cardid,peerholdertablename,peerholderid
> ) VALUES ('ttt','ttt','ttt4','ttt',' ',0,2,null,'ttt','
> ','t_iprouteinfo',2,'406','t_btsrouter',2,'t_btsrouter',2,null,null);
> connection,user_id,table_name,lock_type,lock_name
> 298937754,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> 298937754,'mwcuser','mwcuser.t_servicefeatureinfo','E',3612067495937
> 298937754,'mwcuser','mwcuser.t_servicefeatureinfo','E',3612067495937
> 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
>
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPA0005',2263447764998
>
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','EPA0005',3612067495936
>
>
>
Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,No
deAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
> 1876569969,'jchlin-1','mwcuser',0,'2003-02-10
>
16:49:59.590',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',6031,0,0,0,
17
> 298937754,'jchlin-2','mwcuser',0,'2003-02-10
>
16:49:35.620',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',6662,0,1876
569969,3612067495936,0
>
> -- update 525's immediate next row from jchlin-2 got blocked
> update t_servicefeatureinfo set servicefeature = 'ttt3' where
id=526;
>
> connection,user_id,table_name,lock_type,lock_name
> 298937754,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> 298937754,'mwcuser','mwcuser.t_servicefeatureinfo','E',3534758084621
>
298937754,'mwcuser','mwcuser.t_servicefeatureinfo','SPA0005',3573412790290
> 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
>
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPA0005',2263447764998
>
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','EPA0005',3612067495936
>
>
>
Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,No
deAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
> 1876569969,'jchlin-1','mwcuser',0,'2003-02-10
>
16:50:52.850',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',6766,0,0,0,
25
> 298937754,'jchlin-2','mwcuser',0,'2003-02-10
>
16:50:27.836',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',4711,0,1876
569969,3612067495936,0
>
>
>
> 4. Insert two new rows and update unique constrainted column of the first
> new row the first time, no additional lock is found.
> -- insert 1st new row from jchlin-1
> INSERT INTO t_servicefeatureinfo
>
(description,serviceprofile,servicefeature,usecasename,featureinstanceid,pro
visioningerrorstatus,provisioningstate,provisioningmsg,templatename,template
version,holdertablename,holderid,provisioningid,devicetable,deviceid,cardtab
le,cardid,peerholdertablename,peerholderid
> ) VALUES ( 'ttt','ttt','ttt1','ttt',' ',0,2,null,'ttt','
> ','t_iprouteinfo',2,'406','t_btsrouter',2,'t_btsrouter',2,null,null);
> connection,user_id,table_name,lock_type,lock_name
> 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','E',3612067495936
>
>
>
Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,No
deAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
> 1876569969,'jchlin-1','mwcuser',0,'2003-02-10
>
16:52:48.194',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',5844,0,0,0,
3
> 298937754,'jchlin-2','mwcuser',0,'2003-02-10
> 16:52:00.173',,,'STMT_DROP','TCPIP','128.107.133.207',3078,0,0,0,0
>
> -- insert 2nd new row from jchlin-1 again
> INSERT INTO t_servicefeatureinfo
>
(description,serviceprofile,servicefeature,usecasename,featureinstanceid,pro
visioningerrorstatus,provisioningstate,provisioningmsg,templatename,template
version,holdertablename,holderid,provisioningid,devicetable,deviceid,cardtab
le,cardid,peerholdertablename,peerholderid
> ) VALUES ('ttt','ttt','ttt2','ttt',' ',0,2,null,'ttt','
> ','t_iprouteinfo',2,'406','t_btsrouter',2,'t_btsrouter',2,null,null);
> connection,user_id,table_name,lock_type,lock_name
> 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','E',3612067495936
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','E',3612067495937
>
>
>
Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,No
deAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
> 1876569969,'jchlin-1','mwcuser',0,'2003-02-10
>
16:53:15.153',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',3319,0,0,0,
9
> 298937754,'jchlin-2','mwcuser',0,'2003-02-10
> 16:52:00.173',,,'STMT_DROP','TCPIP','128.107.133.207',3078,0,0,0,0
>
> -- update the the first newly created row from jchlin-1
> update t_servicefeatureinfo set servicefeature = 'ttt5' where id=693;
> connection,user_id,table_name,lock_type,lock_name
> 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','E',3612067495936
>
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','EPA0005',3612067495937
>
>
>
Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,No
deAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
> 1876569969,'jchlin-1','mwcuser',0,'2003-02-10
>
16:54:25.200',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',4080,0,0,0,
15
> 298937754,'jchlin-2','mwcuser',0,'2003-02-10
> 16:52:00.173',,,'STMT_DROP','TCPIP','128.107.133.207',3078,0,0,0,0
>
> -- insert a new row from jchlin-2 successfully
> INSERT INTO t_servicefeatureinfo
>
(description,serviceprofile,servicefeature,usecasename,featureinstanceid,pro
visioningerrorstatus,provisioningstate,provisioningmsg,templatename,template
version,holdertablename,holderid,provisioningid,devicetable,deviceid,cardtab
le,cardid,peerholdertablename,peerholderid
> ) VALUES ('ttt','ttt','ttt4','ttt',' ',0,2,null,'ttt','
> ','t_iprouteinfo',2,'406','t_btsrouter',2,'t_btsrouter',2,null,null);
> connection,user_id,table_name,lock_type,lock_name
> 298937754,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> 298937754,'mwcuser','mwcuser.t_servicefeatureinfo','E',3612067495938
> 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','E',3612067495936
>
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','EPA0005',3612067495937
>
>
>
Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,No
deAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
> 1876569969,'jchlin-1','mwcuser',0,'2003-02-10
>
16:55:22.998',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',5690,0,0,0,
22
> 298937754,'jchlin-2','mwcuser',0,'2003-02-10
> 16:54:40.596',,,'STMT_DROP','TCPIP','128.107.133.207',5968,0,0,0,1
>
> -- update 525's immediate next row from jchlin-2 successfully
> update t_servicefeatureinfo set servicefeature = 'ttt3' where id=526;
> connection,user_id,table_name,lock_type,lock_name
> 298937754,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> 298937754,'mwcuser','mwcuser.t_servicefeatureinfo','E',3534758084621
>
298937754,'mwcuser','mwcuser.t_servicefeatureinfo','SPA0005',3573412790290
> 298937754,'mwcuser','mwcuser.t_servicefeatureinfo','E',3612067495938
> 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','E',3612067495936
>
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','EPA0005',3612067495937
>
>
>
Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,No
deAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
> 1876569969,'jchlin-1','mwcuser',0,'2003-02-10
>
16:57:05.596',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',9344,0,0,0,
31
> 298937754,'jchlin-2','mwcuser',0,'2003-02-10
> 16:56:00.974',,,'STMT_DROP','TCPIP','128.107.133.207',6424,0,0,0,2
>
>
>
> 5. Insert two new rows and update unique constrainted column of the first
> new row the second time, the whole table is locked.
> continue from 4:
>
> -- continue from test #4, update the the first newly created row the 2nd
> time from jchlin-1
> update t_servicefeatureinfo set servicefeature = 'ttt10' where id=693;
> connection,user_id,table_name,lock_type,lock_name
> 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
>
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPA0005',2263447764998
>
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','EPA0005',3612067495936
>
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','EPA0005',3612067495937
>
>
>
Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,No
deAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
> 1876569969,'jchlin-1','mwcuser',0,'2003-02-10
>
16:58:46.919',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',6048,0,0,0,
38
> 298937754,'jchlin-2','mwcuser',0,'2003-02-10
> 16:57:49.353',,,'STMT_DROP','TCPIP','128.107.133.207',8789,0,0,0,0
>
> -- insert a new row from jchlin-2 got blocked
> INSERT INTO t_servicefeatureinfo
>
(description,serviceprofile,servicefeature,usecasename,featureinstanceid,pro
visioningerrorstatus,provisioningstate,provisioningmsg,templatename,template
version,holdertablename,holderid,provisioningid,devicetable,deviceid,cardtab
le,cardid,peerholdertablename,peerholderid
> ) VALUES ('ttt','ttt','ttt4','ttt',' ',0,2,null,'ttt','
> ','t_iprouteinfo',2,'406','t_btsrouter',2,'t_btsrouter',2,null,null);
> connection,user_id,table_name,lock_type,lock_name
> 298937754,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> 298937754,'mwcuser','mwcuser.t_servicefeatureinfo','E',3612067495938
> 298937754,'mwcuser','mwcuser.t_servicefeatureinfo','E',3612067495938
> 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
>
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPA0005',2263447764998
>
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','EPA0005',3612067495936
>
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','EPA0005',3612067495937
>
>
>
Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,No
deAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
> 1876569969,'jchlin-1','mwcuser',0,'2003-02-10
>
16:59:23.097',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',5937,0,0,0,
47
> 298937754,'jchlin-2','mwcuser',0,'2003-02-10
>
16:59:04.094',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',9375,0,1876
569969,2263447764998,0
>
> -- update 525's immediate next row from jchlin-2 got blocked
> update t_servicefeatureinfo set servicefeature = 'ttt3' where id=526;
> connection,user_id,table_name,lock_type,lock_name
> 298937754,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> 298937754,'mwcuser','mwcuser.t_servicefeatureinfo','E',3534758084621
>
298937754,'mwcuser','mwcuser.t_servicefeatureinfo','SPA0005',3573412790290
> 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
>
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPA0005',2263447764998
>
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','EPA0005',3612067495936
>
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','EPA0005',3612067495937
>
>
>
Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,No
deAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
> 1876569969,'jchlin-1','mwcuser',0,'2003-02-10
>
16:59:57.368',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',5758,0,0,0,
56
> 298937754,'jchlin-2','mwcuser',0,'2003-02-10
>
16:59:41.645',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',6768,0,1876
569969,2263447764998,0
>
>
> 6. Update the normal column on the last row, the previous row is locked if
> its unique constrainted column is updated.
> -- update the normal column on the last row from jchlin-1
> update t_servicefeatureinfo set provisioningstate = 56 where id=526
> connection,user_id,table_name,lock_type,lock_name
> 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','E',3534758084621
>
>
>
Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,No
deAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
> 1876569969,'jchlin-1','mwcuser',0,'2003-02-10
>
17:01:32.517',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',5092,0,0,0,
3
> 298937754,'jchlin-2','mwcuser',0,'2003-02-10
> 17:00:36.110',,,'STMT_DROP','TCPIP','128.107.133.207',3297,0,0,0,0
>
> -- update the row in front of the last row from jchlin-2 got blocked
> update t_servicefeatureinfo set servicefeature = 'ttt3' where id=525;
> connection,user_id,table_name,lock_type,lock_name
> 298937754,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> 298937754,'mwcuser','mwcuser.t_servicefeatureinfo','E',3534758084620
> 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','E',3534758084621
>
>
>
Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,No
deAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
> 1876569969,'jchlin-1','mwcuser',0,'2003-02-10
>
17:02:15.051',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',5599,0,0,0,
9
> 298937754,'jchlin-2','mwcuser',0,'2003-02-10
>
17:01:57.254',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',7652,0,1876
569969,3534758084621,0
>
> Jon
>
> "Chris Keating" <Fight_Spam_keating@iAnywhere.com> wrote in message
> news:<oEyeLiQ0CHA.198@forums.sybase.com>...
> > Call sa_locks when running each of your tests and provide the results. I
> > suspect that you will find phantom locks.
> >
> > --
> >
> > Chris Keating
> > Sybase Adaptive Server Anywhere Professional Version 8
> > iAnywhere Solutions http://www.iAnywhere.com
> >
> > ** Please only post to the newsgroup
> >
> > ** Whitepapers can be found at http://www.iAnywhere.com/developer
> > ** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
> > ** Use CaseXpress to report bugs http://casexpress.sybase.com
> >
> > <Jonathan_Lin> wrote in message
> > news:A6201C20A16060B3002DA03B85256CC9.0065CC3285256CC8@webforums...
> > > I'm running the test under isolation level 0. So, why doesn't it have
> any
> > > different locking behavior from the higher isolation levels? I thought
> > that
> > > the lower isolation level may give us less restrictive locking. Also,
> the
> > > insertion only from different db connection in my test still works.
> It's
> > > the following update operations are causing the locking problem.
> > >
> > > Please note that the test #1 and test #2 are tested with update
> operations
> > > only without inserting new rows. And the locking behavior for the
first
> > > update and second update are different.
> > >
> > > Also, does this mean that ASA doesn't support the true row locking?
> What I
> > > meant 'true row locking' means that operations on the row only lock
the
> > row
> > > itself without affecting other rows.
> > >
> > > Does the ASE 12.5 have the same behavior as ASA? Or does ASE support
> the
> > > true row locking?
> > >
> > > Thanks for the help.
> > >
> > > Jon
> > >
> > > "Chris Keating" <Spam_Free_keating@iAnywhere.com> wrote in message
> > > news:<kaKB3UG0CHA.198@forums.sybase.com>...
> > > > This is most likely neither a misconfiguration, bug, or design
> problem
> > > in
> > > > ASA. I recommend that you read the documentation related to locks --
> > > phantom
> > > > locks in particular.
> > > >
> > > >
> > > > <Jonathan_Lin> wrote in message
> > > > news:8ED1B73FCBD3DE4200783E7B85256CC7.00230E4B85256CC7@webforums...
> > > > > Here are the more details about the test results on the row level
> > > lockings
> > > > > I have done:
> > > > >
> > > > > 1. Update unique constrainted column the first time, only one of
> the
> > > > > immediate previous or next row is locked randomly.
> > > > > 2. Update unique constrainted column the second time, the whole
> table
> > > is
> > > > > locked.
> > > > > 3. Insert a new row and update the row on unique constrainted
> columns,
> > > the
> > > > > whole table is locked.
> > > > > 4. Insert two new rows and update unique constrainted column of
the
> > > first
> > > > > new row the first time, no additional lock is found.
> > > > > 5. Insert two new rows and update unique constrainted column of
the
> > > first
> > > > > new row the second time, the whole table is locked.
> > > > > 6. Update the normal column on the last row, the previous row is
> > locked
> > > if
> > > > > its unique constrainted column is updated.
> > > > >
> > > > > Is this caused by a mis-configuration, a bug, or the fundamental
> > design
> > > > > problem of ANA? Any helps on this is very much appreciated.
Thanks.
> > > > >
> > > > > Jon
> > > >
> > > >
> >
> >


Jonathan_Lin Posted on 2003-02-12 01:39:01.0Z
From: Jonathan_Lin
Date: Tue, 11 Feb 2003 20:39:01 -0500
Newsgroups: ianywhere.public.general
Subject: Re: Does ASA 8.01 or 7.3 support true row locking?
Message-ID: <3D3142B9C6DD4B200009109D85256CCB.00521D5A85256CCA@webforums>
References: <4D74442FB667C556001EC7AA85256CC7.001EC7B885256CC7@webforums> <8ED1B73FCBD3DE4200783E7B85256CC7.00230E4B85256CC7@webforums> <kaKB3UG0CHA.198@forums.sybase.com> <A6201C20A16060B3002DA03B85256CC9.0065CC3285256CC8@webforums> <oEyeLiQ0CHA.198@forums.sybase.com> <F0F7EF147048A880000B2FF285256CCA.004EE90785256CC9@webforums> <BfVo9md0CHA.351@forums.sybase.com>
Lines: 635
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:144
Article PK: 1966

Hi, Robert,

Here's the info. Thanks for the help.

There were no foreign key and create index statements defined for this
table when I did the testing.

create table t_servicefeatureinfo (
id bigint not null default
autoincrement,
description varchar(255),
serviceprofile varchar(64),
servicefeature varchar(64),
usecasename varchar(64),
featureinstanceid varchar(32),
provisioningerrorstatus int ,
provisioningstate int ,
provisioningmsg varchar(255),
templatename varchar(64),
templateversion varchar(32),
holdertablename varchar(50),
holderid bigint ,
provisioningid varchar(255),
devicetable varchar(50),
deviceid bigint ,
cardtable varchar(50),
cardid bigint ,
peerholdertablename varchar(50),
peerholderid bigint ,
primary key (id),
unique (servicefeature, holdertablename, holderid)
);

Here are the same records when I did the testing:

id,description,serviceprofile,servicefeature,usecasename,featureinstanceid,provisioningerrorstatus,provisioningstate,provisioningmsg,templatename,templateversion,holdertablename,holderid,provisioningid,devicetable,deviceid,cardtable,cardid,peerholdertablename,peerholderid
429,'INIT_PACKET_BTSRTR_PAIR.Init.','pBTSRTRinit','Init','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_init','
','t_btsrouter',1,'35','t_btsrouter',1,'t_btsrouter',1,,
430,'INIT_MGX.Card_Redundancy.','MGXinit','Card_Redundancy','INIT_MGX','
',0,1,,'mgx:rpm_add_card_redundancy','
','t_rpmcard',1,'36','t_mgxaggregator',1,'t_rpmcard',1,,
431,'INIT_PACKET_BTSRTR_PAIR.Init.','pBTSRTRinit','Init','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_init','
','t_btsrouter',2,'35','t_btsrouter',2,'t_btsrouter',2,,
432,'INIT_MGX.Init.','MGXinit','Init','INIT_MGX',' ',0,1,,'mgx:pxm_init','
','t_pxmcard',1,'36','t_mgxaggregator',1,'t_mgxaggregator',1,,
433,'INIT_PACKET_BTSRTR_PAIR.Enable_Password.','pBTSRTRinit','Enable_Password','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_enable_password','
','t_btsrouter',1,'35','t_btsrouter',1,'t_btsrouter',1,,
434,'INIT_MGX.Init.','MGXinit','Init','INIT_MGX',' ',0,1,,'mgx:rpm_init','
','t_rpmcard',1,'36','t_mgxaggregator',1,'t_rpmcard',1,,
435,'INIT_PACKET_BTSRTR_PAIR.Enable_Password.','pBTSRTRinit','Enable_Password','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_enable_password','
','t_btsrouter',2,'35','t_btsrouter',2,'t_btsrouter',2,,
436,'INIT_PACKET_BTSRTR_PAIR.Snmp.','pBTSRTRinit','Snmp','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_SNMP','
','t_btsrouter',1,'35','t_btsrouter',1,'t_btsrouter',1,,
437,'INIT_MGX.Snmp.','MGXinit','Snmp','INIT_MGX','
',0,1,,'mgx:mgx_add_SNMP','
','t_pxmcard',1,'36','t_mgxaggregator',1,'t_mgxaggregator',1,,
438,'INIT_PACKET_BTSRTR_PAIR.Snmp.','pBTSRTRinit','Snmp','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_SNMP','
','t_btsrouter',2,'35','t_btsrouter',2,'t_btsrouter',2,,
439,'INIT_MGX.Snmp.','MGXinit','Snmp','INIT_MGX','
',0,1,,'mgx:rpm_add_SNMP','
','t_rpmcard',1,'36','t_mgxaggregator',1,'t_rpmcard',1,,
440,'INIT_PACKET_BTSRTR_PAIR.Logging.','pBTSRTRinit','Logging','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_logging','
','t_btsrouter',1,'35','t_btsrouter',1,'t_btsrouter',1,,
441,'INIT_MGX.Trap_Manager.','MGXinit','Trap_Manager','INIT_MGX','
',0,1,,'mgx:pxm_add_trap_mgr','
','t_pxmcard',1,'36','t_mgxaggregator',1,'t_mgxaggregator',1,,
442,'INIT_PACKET_BTSRTR_PAIR.Logging.','pBTSRTRinit','Logging','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_logging','
','t_btsrouter',2,'35','t_btsrouter',2,'t_btsrouter',2,,
443,'INIT_MGX.RPM_PXM_Mgmt_Conn.','MGXinit','RPM_PXM_Mgmt_Conn','INIT_MGX','
',0,1,,'mgx:rpm_add_pxm_mgmt_conn','
','t_rpmswitch1subinterface',4,'36','t_mgxaggregator',1,'t_rpmcard',1,,
444,'INIT_PACKET_BTSRTR_PAIR.Alias.','pBTSRTRinit','Alias','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_aliases','
','t_btsrouter',1,'35','t_btsrouter',1,'t_btsrouter',1,,
445,'INIT_PACKET_BTSRTR_PAIR.Alias.','pBTSRTRinit','Alias','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_aliases','
','t_btsrouter',2,'35','t_btsrouter',2,'t_btsrouter',2,,
446,'INIT_MGX.RPM_Basic_16.1.','MGXinit','RPM_Basic_16.1','INIT_MGX','
',0,1,,'mgx:rpm_add_basic_16.1','
','t_rpmcard',1,'36','t_mgxaggregator',1,'t_rpmcard',1,,
447,'INIT_PACKET_BTSRTR_PAIR.Boot.','pBTSRTRinit','Boot','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_boot','
','t_btsrouter',1,'35','t_btsrouter',1,'t_btsrouter',1,,
448,'INIT_PACKET_BTSRTR_PAIR.Boot.','pBTSRTRinit','Boot','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_boot','
','t_btsrouter',2,'35','t_btsrouter',2,'t_btsrouter',2,,
449,'INIT_MGX.Enable_Password.','MGXinit','Enable_Password','INIT_MGX','
',0,1,,'mgx:rpm_add_enable_password','
','t_rpmcard',1,'36','t_mgxaggregator',1,'t_rpmcard',1,,
450,'INIT_PACKET_BTSRTR_PAIR.Standard_ACL.','pBTSRTRinit','Standard_ACL','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_standard_acl','
','t_btsrouter',1,'35','t_btsrouter',1,'t_btsrouter',1,,
451,'INIT_MGX.Logging.','MGXinit','Logging','INIT_MGX','
',0,1,,'mgx:rpm_add_logging','
','t_rpmcard',1,'36','t_mgxaggregator',1,'t_rpmcard',1,,
452,'INIT_PACKET_BTSRTR_PAIR.Standard_ACL.','pBTSRTRinit','Standard_ACL','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_standard_acl','
','t_btsrouter',2,'35','t_btsrouter',2,'t_btsrouter',2,,
453,'INIT_PACKET_BTSRTR_PAIR.QOS.','pBTSRTRinit','QOS','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_QOS','
','t_btsrouter',1,'35','t_btsrouter',1,'t_btsrouter',1,,
454,'INIT_PACKET_BTSRTR_PAIR.QOS.','pBTSRTRinit','QOS','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_QOS','
','t_btsrouter',2,'35','t_btsrouter',2,'t_btsrouter',2,,
455,'INIT_MGX.Alias.','MGXinit','Alias','INIT_MGX','
',0,1,,'mgx:rpm_add_aliases','
','t_rpmcard',1,'36','t_mgxaggregator',1,'t_rpmcard',1,,
456,'INIT_PACKET_BTSRTR_PAIR.OSPF1_Basic.','pBTSRTRinit','OSPF1_Basic','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_OSPF1_basic','
','t_btsrouter',1,'35','t_btsrouter',1,'t_btsrouter',1,,
457,'INIT_PACKET_BTSRTR_PAIR.OSPF1_Basic.','pBTSRTRinit','OSPF1_Basic','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_OSPF1_basic','
','t_btsrouter',2,'35','t_btsrouter',2,'t_btsrouter',2,,
458,'INIT_MGX.Boot.','MGXinit','Boot','INIT_MGX','
',0,1,,'mgx:rpm_add_boot','
','t_rpmcard',1,'36','t_mgxaggregator',1,'t_rpmcard',1,,
459,'INIT_PACKET_BTSRTR_PAIR.OSPF2_Basic.','pBTSRTRinit','OSPF2_Basic','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_OSPF2_basic','
','t_btsrouter',1,'35','t_btsrouter',1,'t_btsrouter',1,,
460,'INIT_MGX.QOS.','MGXinit','QOS','INIT_MGX',' ',0,1,,'mgx:rpm_add_QOS','
','t_rpmcard',1,'36','t_mgxaggregator',1,'t_rpmcard',1,,
461,'INIT_PACKET_BTSRTR_PAIR.OSPF2_Basic.','pBTSRTRinit','OSPF2_Basic','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_OSPF2_basic','
','t_btsrouter',2,'35','t_btsrouter',2,'t_btsrouter',2,,
462,'INIT_PACKET_BTSRTR_PAIR.OSPF_Area2.','pBTSRTRinit','OSPF_Area2','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_OSPF1_network_area2','
','t_ospfnetworkinfo',5,'35','t_btsrouter',1,'t_btsrouter',1,,
463,'INIT_MGX.OSPF_Basic.','MGXinit','OSPF_Basic','INIT_MGX','
',0,1,,'mgx:rpm_add_OSPF_basic','
','t_rpmcard',1,'36','t_mgxaggregator',1,'t_rpmcard',1,,
464,'INIT_PACKET_BTSRTR_PAIR.OSPF_Area2.','pBTSRTRinit','OSPF_Area2','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_OSPF1_network_area2','
','t_ospfnetworkinfo',6,'35','t_btsrouter',2,'t_btsrouter',2,,
465,'INIT_PACKET_BTSRTR_PAIR.OSPF_Area51.','pBTSRTRinit','OSPF_Area51','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_OSPF2_network_area51','
','t_ospfnetworkinfo',7,'35','t_btsrouter',1,'t_btsrouter',1,,
466,'INIT_MGX.OSPF_Area0.','MGXinit','OSPF_Area0','INIT_MGX','
',0,1,,'mgx:rpm_add_OSPF_network_area0','
','t_ospfnetworkinfo',1,'36','t_mgxaggregator',1,'t_rpmcard',1,,
467,'INIT_MGX.OSPF_Area0.','MGXinit','OSPF_Area0','INIT_MGX','
',0,1,,'mgx:rpm_add_OSPF_network_area0','
','t_ospfnetworkinfo',2,'36','t_mgxaggregator',1,'t_rpmcard',1,,
468,'INIT_PACKET_BTSRTR_PAIR.OSPF_Area51.','pBTSRTRinit','OSPF_Area51','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_OSPF2_network_area51','
','t_ospfnetworkinfo',10,'35','t_btsrouter',2,'t_btsrouter',2,,
469,'INIT_PACKET_BTSRTR_PAIR.OSPF_Area51.','pBTSRTRinit','OSPF_Area51','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_OSPF2_network_area51','
','t_ospfnetworkinfo',8,'35','t_btsrouter',1,'t_btsrouter',1,,
470,'INIT_MGX.OSPF_Area2.','MGXinit','OSPF_Area2','INIT_MGX','
',0,1,,'mgx:rpm_add_OSPF_network_area2','
','t_ospfnetworkinfo',3,'36','t_mgxaggregator',1,'t_rpmcard',1,,
471,'INIT_PACKET_BTSRTR_PAIR.OSPF_Area51.','pBTSRTRinit','OSPF_Area51','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_OSPF2_network_area51','
','t_ospfnetworkinfo',11,'35','t_btsrouter',2,'t_btsrouter',2,,
472,'INIT_PACKET_BTSRTR_PAIR.OSPF_Area51.','pBTSRTRinit','OSPF_Area51','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_OSPF2_network_area51','
','t_ospfnetworkinfo',9,'35','t_btsrouter',1,'t_btsrouter',1,,
473,'INIT_PACKET_BTSRTR_PAIR.OSPF_Area51.','pBTSRTRinit','OSPF_Area51','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_OSPF2_network_area51','
','t_ospfnetworkinfo',12,'35','t_btsrouter',2,'t_btsrouter',2,,
474,'INIT_MGX.OSPF_Area2_Range.','MGXinit','OSPF_Area2_Range','INIT_MGX','
',0,1,,'mgx:rpm_add_OSPF_area2_range','
','t_ospfnetworkinfo',4,'36','t_mgxaggregator',1,'t_rpmcard',1,,
475,'INIT_PACKET_BTSRTR_PAIR.OSPF_Area51_Summary.','pBTSRTRinit','OSPF_Area51_Summary','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_OSPF1_summary_address','
','t_ospfnetworkinfo',13,'35','t_btsrouter',1,'t_btsrouter',1,,
476,'INIT_PACKET_BTSRTR_PAIR.OSPF_Area51_Summary.','pBTSRTRinit','OSPF_Area51_Summary','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_OSPF1_summary_address','
','t_ospfnetworkinfo',15,'35','t_btsrouter',2,'t_btsrouter',2,,
477,'INIT_MGX.L3_Interface.','MGXinit','L3_Interface','INIT_MGX','
',0,1,,'mgx:rpm_add_L3_interface','
','t_rpmfeinterface',1,'36','t_mgxaggregator',1,'t_rpmcard',1,,
478,'INIT_PACKET_BTSRTR_PAIR.MLPPP.','pBTSRTRinit','MLPPP','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_MLPPP','
','t_btsrmlpppbundle',3,'35','t_btsrouter',1,'t_btsrouter',1,,
479,'INIT_MGX.L3_Interface.','MGXinit','L3_Interface','INIT_MGX','
',0,1,,'mgx:rpm_add_L3_interface','
','t_rpmfeinterface',2,'36','t_mgxaggregator',1,'t_rpmcard',1,,
480,'INIT_PACKET_BTSRTR_PAIR.MLPPP.','pBTSRTRinit','MLPPP','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_MLPPP','
','t_btsrmlpppbundle',5,'35','t_btsrouter',2,'t_btsrouter',2,,
481,'INIT_MGX.OSPF_To_Interface.','MGXinit','OSPF_To_Interface','INIT_MGX','
',0,1,,'mgx:rpm_add_OSPF_to_FE_interface','
','t_rpmfeinterface',1,'36','t_mgxaggregator',1,'t_rpmcard',1,,
482,'INIT_PACKET_BTSRTR_PAIR.Hdr_Compression.','pBTSRTRinit','Hdr_Compression','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_hdr_compression','
','t_btsrmlpppbundle',3,'35','t_btsrouter',1,'t_btsrouter',1,,
483,'INIT_MGX.OSPF_To_Interface.','MGXinit','OSPF_To_Interface','INIT_MGX','
',0,1,,'mgx:rpm_add_OSPF_to_FE_interface','
','t_rpmfeinterface',2,'36','t_mgxaggregator',1,'t_rpmcard',1,,
484,'INIT_PACKET_BTSRTR_PAIR.Hdr_Compression.','pBTSRTRinit','Hdr_Compression','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_hdr_compression','
','t_btsrmlpppbundle',5,'35','t_btsrouter',2,'t_btsrouter',2,,
485,'INIT_MGX.OSPF_To_Interface.','MGXinit','OSPF_To_Interface','INIT_MGX','
',0,1,,'mgx:rpm_add_OSPF_to_MLPPP_interface','
','t_rpmmlpppbundle',1,'36','t_mgxaggregator',1,'t_rpmcard',1,,
486,'INIT_PACKET_BTSRTR_PAIR.PPP_Mux.','pBTSRTRinit','PPP_Mux','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_ppp_mux','
','t_btsrmlpppbundle',3,'35','t_btsrouter',1,'t_btsrouter',1,,
487,'INIT_MGX.OSPF_To_Interface.','MGXinit','OSPF_To_Interface','INIT_MGX','
',0,1,,'mgx:rpm_add_OSPF_to_MLPPP_interface','
','t_rpmmlpppbundle',2,'36','t_mgxaggregator',1,'t_rpmcard',1,,
488,'INIT_PACKET_BTSRTR_PAIR.PPP_Mux.','pBTSRTRinit','PPP_Mux','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_ppp_mux','
','t_btsrmlpppbundle',5,'35','t_btsrouter',2,'t_btsrouter',2,,
489,'INIT_MGX.PIM_For_Port.','MGXinit','PIM_For_Port','INIT_MGX','
',0,1,,'mgx:rpm_add_PIM','
','t_rpmfeinterface',1,'36','t_mgxaggregator',1,'t_rpmcard',1,,
490,'INIT_PACKET_BTSRTR_PAIR.OSPF_To_Interface.','pBTSRTRinit','OSPF_To_Interface','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_OSPF_to_MLPPP_interface','
','t_btsrmlpppbundle',3,'35','t_btsrouter',1,'t_btsrouter',1,,
491,'INIT_PACKET_BTSRTR_PAIR.OSPF_To_Interface.','pBTSRTRinit','OSPF_To_Interface','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_OSPF_to_MLPPP_interface','
','t_btsrmlpppbundle',5,'35','t_btsrouter',2,'t_btsrouter',2,,
492,'INIT_PACKET_BTSRTR_PAIR.OSPF_To_Interface.','pBTSRTRinit','OSPF_To_Interface','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_OSPF_to_FE_interface','
','t_btsrfeinterface',1,'35','t_btsrouter',1,'t_btsrcard',1,,
493,'INIT_MGX.PIM_For_Port.','MGXinit','PIM_For_Port','INIT_MGX','
',0,1,,'mgx:rpm_add_PIM','
','t_rpmfeinterface',2,'36','t_mgxaggregator',1,'t_rpmcard',1,,
494,'INIT_PACKET_BTSRTR_PAIR.OSPF_To_Interface.','pBTSRTRinit','OSPF_To_Interface','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_OSPF_to_FE_interface','
','t_btsrfeinterface',3,'35','t_btsrouter',2,'t_btsrcard',2,,
495,'INIT_MGX.IP_Pool.','MGXinit','IP_Pool','INIT_MGX','
',0,1,,'mgx:rpm_add_ip_pool','
','t_ippoolinfo',1,'36','t_mgxaggregator',1,'t_rpmcard',1,,
496,'INIT_PACKET_BTSRTR_PAIR.OSPF_To_Interface.','pBTSRTRinit','OSPF_To_Interface','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_OSPF_to_FE_interface','
','t_btsrfeinterface',2,'35','t_btsrouter',1,'t_btsrcard',1,,
497,'INIT_MGX.MLPPP_For_BTSRTRLink.','MGXinit','MLPPP_For_BTSRTRLink','INIT_MGX','
',0,1,,'mgx:rpm_add_MLPPP_BTSRTRLink','
','t_rpmmlpppbundle',1,'36','t_mgxaggregator',1,'t_rpmcard',1,,
498,'INIT_PACKET_BTSRTR_PAIR.OSPF_To_Interface.','pBTSRTRinit','OSPF_To_Interface','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_OSPF_to_FE_interface','
','t_btsrfeinterface',4,'35','t_btsrouter',2,'t_btsrcard',2,,
499,'INIT_MGX.MLPPP.','MGXinit','MLPPP','INIT_MGX','
',0,1,,'mgx:rpm_add_MLPPP','
','t_rpmmlpppbundle',2,'36','t_mgxaggregator',1,'t_rpmcard',1,,
500,'INIT_PACKET_BTSRTR_PAIR.PIM_For_MLPPP.','pBTSRTRinit','PIM_For_MLPPP','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_PIM_to_MLPPP','
','t_btsrmlpppbundle',3,'35','t_btsrouter',1,'t_btsrouter',1,,
501,'INIT_PACKET_BTSRTR_PAIR.PIM_For_MLPPP.','pBTSRTRinit','PIM_For_MLPPP','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_PIM_to_MLPPP','
','t_btsrmlpppbundle',5,'35','t_btsrouter',2,'t_btsrouter',2,,
502,'INIT_MGX.PPP_Mux.','MGXinit','PPP_Mux','INIT_MGX','
',0,1,,'mgx:rpm_add_ppp_mux','
','t_rpmmlpppbundle',2,'36','t_mgxaggregator',1,'t_rpmcard',1,,
503,'INIT_PACKET_BTSRTR_PAIR.Wan_Controller.','pBTSRTRinit','Wan_Controller','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_T1_shortcbl','
','t_btsrds1interface',1,'35','t_btsrouter',1,'t_btsrcard',3,,
504,'INIT_PACKET_BTSRTR_PAIR.Wan_Controller.','pBTSRTRinit','Wan_Controller','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_T1_shortcbl','
','t_btsrds1interface',3,'35','t_btsrouter',2,'t_btsrcard',4,,
505,'INIT_MGX.Hdr_Compression.','MGXinit','Hdr_Compression','INIT_MGX','
',0,1,,'mgx:rpm_add_hdr_compression','
','t_rpmmlpppbundle',2,'36','t_mgxaggregator',1,'t_rpmcard',1,,
506,'INIT_PACKET_BTSRTR_PAIR.Serial_Channel_Group.','pBTSRTRinit','Serial_Channel_Group','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_T1_channelgroup','
','t_btsrds1channelgroup',2,'35','t_btsrouter',1,'t_btsrcard',3,,
507,'INIT_PACKET_BTSRTR_PAIR.Serial_Channel_Group.','pBTSRTRinit','Serial_Channel_Group','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_T1_channelgroup','
','t_btsrds1channelgroup',5,'35','t_btsrouter',2,'t_btsrcard',4,,
508,'INIT_MGX.PIM_For_MLPPP.','MGXinit','PIM_For_MLPPP','INIT_MGX','
',0,1,,'mgx:rpm_add_PIM','
','t_rpmmlpppbundle',2,'36','t_mgxaggregator',1,'t_rpmcard',1,,
509,'INIT_PACKET_BTSRTR_PAIR.Span_Interface.','pBTSRTRinit','Span_Interface','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_span_interface','
','t_btsrds1serialinterface',2,'35','t_btsrouter',1,'t_btsrcard',3,,
510,'INIT_PACKET_BTSRTR_PAIR.Span_Interface.','pBTSRTRinit','Span_Interface','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_span_interface','
','t_btsrds1serialinterface',5,'35','t_btsrouter',2,'t_btsrcard',4,,
511,'INIT_PACKET_BTSRTR_PAIR.L3_Interface.','pBTSRTRinit','L3_Interface','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_l3_interface','
','t_btsrfeinterface',1,'35','t_btsrouter',1,'t_btsrcard',1,,
512,'INIT_PACKET_BTSRTR_PAIR.L3_Interface.','pBTSRTRinit','L3_Interface','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_l3_interface','
','t_btsrfeinterface',3,'35','t_btsrouter',2,'t_btsrcard',2,,
513,'INIT_PACKET_BTSRTR_PAIR.L3_Interface.','pBTSRTRinit','L3_Interface','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_l3_interface','
','t_btsrfeinterface',2,'35','t_btsrouter',1,'t_btsrcard',1,,
514,'INIT_PACKET_BTSRTR_PAIR.L3_Interface.','pBTSRTRinit','L3_Interface','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_l3_interface','
','t_btsrfeinterface',4,'35','t_btsrouter',2,'t_btsrcard',2,,
515,'INIT_PACKET_BTSRTR_PAIR.PIM_For_Port.','pBTSRTRinit','PIM_For_Port','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_PIM','
','t_btsrfeinterface',1,'35','t_btsrouter',1,'t_btsrcard',1,,
516,'INIT_PACKET_BTSRTR_PAIR.PIM_For_Port.','pBTSRTRinit','PIM_For_Port','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_PIM','
','t_btsrfeinterface',3,'35','t_btsrouter',2,'t_btsrcard',2,,
517,'INIT_PACKET_BTSRTR_PAIR.PIM_For_Port.','pBTSRTRinit','PIM_For_Port','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_PIM','
','t_btsrfeinterface',2,'35','t_btsrouter',1,'t_btsrcard',1,,
518,'INIT_PACKET_BTSRTR_PAIR.PIM_For_Port.','pBTSRTRinit','PIM_For_Port','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_PIM','
','t_btsrfeinterface',4,'35','t_btsrouter',2,'t_btsrcard',2,,
519,'INIT_PACKET_BTSRTR_PAIR.HSRP.','pBTSRTRinit','HSRP','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_HSRP','
','t_btsrfeinterface',1,'35','t_btsrouter',1,'t_btsrcard',1,,
520,'INIT_PACKET_BTSRTR_PAIR.HSRP.','pBTSRTRinit','HSRP','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_HSRP','
','t_btsrfeinterface',3,'35','t_btsrouter',2,'t_btsrcard',2,,
521,'INIT_PACKET_BTSRTR_PAIR.HSRP.','pBTSRTRinit','HSRP','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_HSRP','
','t_btsrfeinterface',2,'35','t_btsrouter',1,'t_btsrcard',1,,
522,'INIT_PACKET_BTSRTR_PAIR.HSRP.','pBTSRTRinit','HSRP','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_HSRP','
','t_btsrfeinterface',4,'35','t_btsrouter',2,'t_btsrcard',2,,
523,'INIT_PACKET_BTSRTR_PAIR.MLPPP_Track.','pBTSRTRinit','MLPPP_Track','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_MLPPP_redundancy','
','t_btsrouter',1,'35','t_btsrouter',1,'t_btsrouter',1,,
524,'INIT_PACKET_BTSRTR_PAIR.MLPPP_Track.','pBTSRTRinit','MLPPP_Track','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_MLPPP_redundancy','
','t_btsrouter',2,'35','t_btsrouter',2,'t_btsrouter',2,,
525,'INIT_PACKET_BTSRTR_PAIR.IP_Route.','pBTSRTRinit','ttt10','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_ip_route','
','t_iprouteinfo',2,'35','t_btsrouter',1,'t_btsrouter',1,,
526,'INIT_PACKET_BTSRTR_PAIR.IP_Route.','pBTSRTRinit','IP_Route','INIT_PACKET_BTSRTR_PAIR','
',0,1,,'btsrtr:btsrtr_add_ip_route','
','t_iprouteinfo',3,'35','t_btsrouter',2,'t_btsrouter',2,,

Jon

"Robert Waywell" <rwaywell@ianywhere.com> wrote in message
news:BfVo9md0CHA.351@forums.sybase.com...
> Can you post the CREATE TABLE statement plus all CREATE INDEX and Foreign
> Key definitions?
> Can you provide the details of the records currently in the table at the
> time you run these tests?
>
>
> --
> -----------------------------------------------
> Robert Waywell
> Sybase Adaptive Server Anywhere Developer - Version 8
> Sybase Certified Professional
>
> Sybase's iAnywhere Solutions
>
> Please respond ONLY to newsgroup
>
> EBF's and Patches: http://downloads.sybase.com
> choose SQL Anywhere Studio >> change 'time frame' to all
>
> To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm
>
> SQL Anywhere Studio Supported Platforms and Support Status
> http://my.sybase.com/detail?id=1002288
>
> Whitepapers, TechDocs, and bug fixes are all available through the
iAnywhere
> Developer Community at www.ianywhere.com/developer
>
> <Jonathan_Lin> wrote in message
> news:F0F7EF147048A880000B2FF285256CCA.004EE90785256CC9@webforums...
> > Hi, Chris,
> >
> > Here's the results. Thanks for the help.
> >
> > 1. Update unique constrainted column the first time, only one of the
> > immediate previous or next row is locked randomly.
> >
> > update t_servicefeatureinfo set servicefeature = 'ttt5' where id=525;
--
> > from jchlin-1 (db connection)
> >
> > connection,user_id,table_name,lock_type,lock_name
> > 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> >
> 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','E',3534758084620
> >
> >
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPA0005',3534758084621
> >
> >
> >
>
Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,No
> deAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
> > 1876569969,'jchlin-1','mwcuser',0,'2003-02-10
> >
>
16:32:41.014',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',2903,0,0,0,
> 7
> > 298937754,'jchlin-2','mwcuser',0,'2003-02-10
> > 16:26:29.878',,,'STMT_DROP','TCPIP','128.107.133.207',1941,0,0,0,0
> >
> > -- id 526 is the immediate next row to id 525
> > update t_servicefeatureinfo set servicefeature = 'ttt3' where id=526;
--
> > from jchlin-2 (db connection) got blocked
> >
>
>
>
> > connection,user_id,table_name,lock_type,lock_name
> > 298937754,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> > 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> >
> 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','E',3534758084620
> >
> >
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPA0005',3534758084621
> >
> >
> >
>
Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,No
> deAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
> > 1876569969,'jchlin-1','mwcuser',0,'2003-02-10
> >
>
16:33:56.938',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',5844,0,0,0,
> 13
> > 298937754,'jchlin-2','mwcuser',0,'2003-02-10
> >
>
16:33:29.658',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',8141,0,1876
> 569969,3534758084621,0
> >
> >
> > 2. Update unique constrainted column the second time, the whole table
is
> > locked.
> >
> > update t_servicefeatureinfo set servicefeature = 'ttt10' where id=525;
--
> > from jchlin-1 (continued from test #1)
> >
> > connection,user_id,table_name,lock_type,lock_name
> > 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> >
> >
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPA0005',2263447764998
> >
> >
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','EPA0005',3534758084620
> >
> >
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPA0005',3534758084621
> >
> >
> >
>
Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,No
> deAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
> > 1876569969,'jchlin-1','mwcuser',0,'2003-02-10
> >
>
16:37:10.769',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',3730,0,0,0,
> 9
> > 298937754,'jchlin-2','mwcuser',0,'2003-02-10
> > 16:34:23.795',,,'STMT_DROP','TCPIP','128.107.133.207',6402,0,0,0,0
> >
> >
> > update t_servicefeatureinfo set servicefeature = 'ttt3' where id=526;
--
> > from jchlin-2 got blocked
> >
> > connection,user_id,table_name,lock_type,lock_name
> > 298937754,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> > 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> >
> >
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPA0005',2263447764998
> >
> >
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','EPA0005',3534758084620
> >
> >
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPA0005',3534758084621
> >
> >
> >
>
Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,No
> deAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
> > 1876569969,'jchlin-1','mwcuser',0,'2003-02-10
> >
>
16:38:54.296',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',7852,0,0,0,
> 16
> > 298937754,'jchlin-2','mwcuser',0,'2003-02-10
> >
>
16:38:00.181',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',9375,0,1876
> 569969,3534758084621,0
> >
> > 3. Insert a new row and update the row on unique constrainted columns,
the
> > whole table is locked.
> > -- insert a new row from jchlin-1
> > INSERT INTO t_servicefeatureinfo
> >
>
(description,serviceprofile,servicefeature,usecasename,featureinstanceid,pro
>
visioningerrorstatus,provisioningstate,provisioningmsg,templatename,template
>
version,holdertablename,holderid,provisioningid,devicetable,deviceid,cardtab
> le,cardid,peerholdertablename,peerholderid
> > ) VALUES ( 'ttt','ttt','ttt1','ttt',' ',0,2,null,'ttt','
> > ','t_iprouteinfo',2,'406','t_btsrouter',2,'t_btsrouter',2,null,null);
> >
> > connection,user_id,table_name,lock_type,lock_name
> > 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> >
> 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','E',3612067495936
> >
> >
> >
>
Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,No
> deAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
> > 1876569969,'jchlin-1','mwcuser',0,'2003-02-10
> >
>
16:47:41.305',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',5266,0,0,0,
> 3
> > 298937754,'jchlin-2','mwcuser',0,'2003-02-10
> > 16:46:53.313',,,'STMT_DROP','TCPIP','128.107.133.207',8789,0,0,0,0
> >
> > -- update the newly created row from jchlin-1
> > update t_servicefeatureinfo set servicefeature = 'ttt5' where id=689;
> > connection,user_id,table_name,lock_type,lock_name
> > 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> >
> >
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPA0005',2263447764998
> >
> >
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','EPA0005',3612067495936
> >
> >
> >
>
Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,No
> deAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
> > 1876569969,'jchlin-1','mwcuser',0,'2003-02-10
> >
>
16:49:10.464',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',5221,0,0,0,
> 9
> > 298937754,'jchlin-2','mwcuser',0,'2003-02-10
> > 16:48:11.102',,,'STMT_DROP','TCPIP','128.107.133.207',5560,0,0,0,0
> >
> > -- insert a new row from jchlin-2 got blocked
> > INSERT INTO t_servicefeatureinfo
> >
>
(description,serviceprofile,servicefeature,usecasename,featureinstanceid,pro
>
visioningerrorstatus,provisioningstate,provisioningmsg,templatename,template
>
version,holdertablename,holderid,provisioningid,devicetable,deviceid,cardtab
> le,cardid,peerholdertablename,peerholderid
> > ) VALUES ('ttt','ttt','ttt4','ttt',' ',0,2,null,'ttt','
> > ','t_iprouteinfo',2,'406','t_btsrouter',2,'t_btsrouter',2,null,null);
> > connection,user_id,table_name,lock_type,lock_name
> > 298937754,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> > 298937754,'mwcuser','mwcuser.t_servicefeatureinfo','E',3612067495937
> > 298937754,'mwcuser','mwcuser.t_servicefeatureinfo','E',3612067495937
> > 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> >
> >
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPA0005',2263447764998
> >
> >
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','EPA0005',3612067495936
> >
> >
> >
>
Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,No
> deAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
> > 1876569969,'jchlin-1','mwcuser',0,'2003-02-10
> >
>
16:49:59.590',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',6031,0,0,0,
> 17
> > 298937754,'jchlin-2','mwcuser',0,'2003-02-10
> >
>
16:49:35.620',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',6662,0,1876
> 569969,3612067495936,0
> >
> > -- update 525's immediate next row from jchlin-2 got blocked
> > update t_servicefeatureinfo set servicefeature = 'ttt3' where
> id=526;
> >
> > connection,user_id,table_name,lock_type,lock_name
> > 298937754,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> > 298937754,'mwcuser','mwcuser.t_servicefeatureinfo','E',3534758084621
> >
>
298937754,'mwcuser','mwcuser.t_servicefeatureinfo','SPA0005',3573412790290
> > 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> >
> >
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPA0005',2263447764998
> >
> >
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','EPA0005',3612067495936
> >
> >
> >
>
Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,No
> deAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
> > 1876569969,'jchlin-1','mwcuser',0,'2003-02-10
> >
>
16:50:52.850',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',6766,0,0,0,
> 25
> > 298937754,'jchlin-2','mwcuser',0,'2003-02-10
> >
>
16:50:27.836',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',4711,0,1876
> 569969,3612067495936,0
> >
> >
> >
> > 4. Insert two new rows and update unique constrainted column of the
first
> > new row the first time, no additional lock is found.
> > -- insert 1st new row from jchlin-1
> > INSERT INTO t_servicefeatureinfo
> >
>
(description,serviceprofile,servicefeature,usecasename,featureinstanceid,pro
>
visioningerrorstatus,provisioningstate,provisioningmsg,templatename,template
>
version,holdertablename,holderid,provisioningid,devicetable,deviceid,cardtab
> le,cardid,peerholdertablename,peerholderid
> > ) VALUES ( 'ttt','ttt','ttt1','ttt',' ',0,2,null,'ttt','
> > ','t_iprouteinfo',2,'406','t_btsrouter',2,'t_btsrouter',2,null,null);
> > connection,user_id,table_name,lock_type,lock_name
> > 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> >
> 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','E',3612067495936
> >
> >
> >
>
Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,No
> deAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
> > 1876569969,'jchlin-1','mwcuser',0,'2003-02-10
> >
>
16:52:48.194',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',5844,0,0,0,
> 3
> > 298937754,'jchlin-2','mwcuser',0,'2003-02-10
> > 16:52:00.173',,,'STMT_DROP','TCPIP','128.107.133.207',3078,0,0,0,0
> >
> > -- insert 2nd new row from jchlin-1 again
> > INSERT INTO t_servicefeatureinfo
> >
>
(description,serviceprofile,servicefeature,usecasename,featureinstanceid,pro
>
visioningerrorstatus,provisioningstate,provisioningmsg,templatename,template
>
version,holdertablename,holderid,provisioningid,devicetable,deviceid,cardtab
> le,cardid,peerholdertablename,peerholderid
> > ) VALUES ('ttt','ttt','ttt2','ttt',' ',0,2,null,'ttt','
> > ','t_iprouteinfo',2,'406','t_btsrouter',2,'t_btsrouter',2,null,null);
> > connection,user_id,table_name,lock_type,lock_name
> > 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> >
> 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','E',3612067495936
> >
> 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','E',3612067495937
> >
> >
> >
>
Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,No
> deAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
> > 1876569969,'jchlin-1','mwcuser',0,'2003-02-10
> >
>
16:53:15.153',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',3319,0,0,0,
> 9
> > 298937754,'jchlin-2','mwcuser',0,'2003-02-10
> > 16:52:00.173',,,'STMT_DROP','TCPIP','128.107.133.207',3078,0,0,0,0
> >
> > -- update the the first newly created row from jchlin-1
> > update t_servicefeatureinfo set servicefeature = 'ttt5' where id=693;
> > connection,user_id,table_name,lock_type,lock_name
> > 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> >
> 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','E',3612067495936
> >
> >
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','EPA0005',3612067495937
> >
> >
> >
>
Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,No
> deAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
> > 1876569969,'jchlin-1','mwcuser',0,'2003-02-10
> >
>
16:54:25.200',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',4080,0,0,0,
> 15
> > 298937754,'jchlin-2','mwcuser',0,'2003-02-10
> > 16:52:00.173',,,'STMT_DROP','TCPIP','128.107.133.207',3078,0,0,0,0
> >
> > -- insert a new row from jchlin-2 successfully
> > INSERT INTO t_servicefeatureinfo
> >
>
(description,serviceprofile,servicefeature,usecasename,featureinstanceid,pro
>
visioningerrorstatus,provisioningstate,provisioningmsg,templatename,template
>
version,holdertablename,holderid,provisioningid,devicetable,deviceid,cardtab
> le,cardid,peerholdertablename,peerholderid
> > ) VALUES ('ttt','ttt','ttt4','ttt',' ',0,2,null,'ttt','
> > ','t_iprouteinfo',2,'406','t_btsrouter',2,'t_btsrouter',2,null,null);
> > connection,user_id,table_name,lock_type,lock_name
> > 298937754,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> > 298937754,'mwcuser','mwcuser.t_servicefeatureinfo','E',3612067495938
> > 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> >
> 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','E',3612067495936
> >
> >
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','EPA0005',3612067495937
> >
> >
> >
>
Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,No
> deAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
> > 1876569969,'jchlin-1','mwcuser',0,'2003-02-10
> >
>
16:55:22.998',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',5690,0,0,0,
> 22
> > 298937754,'jchlin-2','mwcuser',0,'2003-02-10
> > 16:54:40.596',,,'STMT_DROP','TCPIP','128.107.133.207',5968,0,0,0,1
> >
> > -- update 525's immediate next row from jchlin-2 successfully
> > update t_servicefeatureinfo set servicefeature = 'ttt3' where id=526;
> > connection,user_id,table_name,lock_type,lock_name
> > 298937754,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> > 298937754,'mwcuser','mwcuser.t_servicefeatureinfo','E',3534758084621
> >
>
298937754,'mwcuser','mwcuser.t_servicefeatureinfo','SPA0005',3573412790290
> > 298937754,'mwcuser','mwcuser.t_servicefeatureinfo','E',3612067495938
> > 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> >
> 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','E',3612067495936
> >
> >
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','EPA0005',3612067495937
> >
> >
> >
>
Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,No
> deAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
> > 1876569969,'jchlin-1','mwcuser',0,'2003-02-10
> >
>
16:57:05.596',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',9344,0,0,0,
> 31
> > 298937754,'jchlin-2','mwcuser',0,'2003-02-10
> > 16:56:00.974',,,'STMT_DROP','TCPIP','128.107.133.207',6424,0,0,0,2
> >
> >
> >
> > 5. Insert two new rows and update unique constrainted column of the
first
> > new row the second time, the whole table is locked.
> > continue from 4:
> >
> > -- continue from test #4, update the the first newly created row the
2nd
> > time from jchlin-1
> > update t_servicefeatureinfo set servicefeature = 'ttt10' where id=693;
> > connection,user_id,table_name,lock_type,lock_name
> > 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> >
> >
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPA0005',2263447764998
> >
> >
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','EPA0005',3612067495936
> >
> >
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','EPA0005',3612067495937
> >
> >
> >
>
Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,No
> deAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
> > 1876569969,'jchlin-1','mwcuser',0,'2003-02-10
> >
>
16:58:46.919',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',6048,0,0,0,
> 38
> > 298937754,'jchlin-2','mwcuser',0,'2003-02-10
> > 16:57:49.353',,,'STMT_DROP','TCPIP','128.107.133.207',8789,0,0,0,0
> >
> > -- insert a new row from jchlin-2 got blocked
> > INSERT INTO t_servicefeatureinfo
> >
>
(description,serviceprofile,servicefeature,usecasename,featureinstanceid,pro
>
visioningerrorstatus,provisioningstate,provisioningmsg,templatename,template
>
version,holdertablename,holderid,provisioningid,devicetable,deviceid,cardtab
> le,cardid,peerholdertablename,peerholderid
> > ) VALUES ('ttt','ttt','ttt4','ttt',' ',0,2,null,'ttt','
> > ','t_iprouteinfo',2,'406','t_btsrouter',2,'t_btsrouter',2,null,null);
> > connection,user_id,table_name,lock_type,lock_name
> > 298937754,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> > 298937754,'mwcuser','mwcuser.t_servicefeatureinfo','E',3612067495938
> > 298937754,'mwcuser','mwcuser.t_servicefeatureinfo','E',3612067495938
> > 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> >
> >
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPA0005',2263447764998
> >
> >
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','EPA0005',3612067495936
> >
> >
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','EPA0005',3612067495937
> >
> >
> >
>
Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,No
> deAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
> > 1876569969,'jchlin-1','mwcuser',0,'2003-02-10
> >
>
16:59:23.097',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',5937,0,0,0,
> 47
> > 298937754,'jchlin-2','mwcuser',0,'2003-02-10
> >
>
16:59:04.094',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',9375,0,1876
> 569969,2263447764998,0
> >
> > -- update 525's immediate next row from jchlin-2 got blocked
> > update t_servicefeatureinfo set servicefeature = 'ttt3' where id=526;
> > connection,user_id,table_name,lock_type,lock_name
> > 298937754,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> > 298937754,'mwcuser','mwcuser.t_servicefeatureinfo','E',3534758084621
> >
>
298937754,'mwcuser','mwcuser.t_servicefeatureinfo','SPA0005',3573412790290
> > 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> >
> >
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPA0005',2263447764998
> >
> >
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','EPA0005',3612067495936
> >
> >
>
1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','EPA0005',3612067495937
> >
> >
> >
>
Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,No
> deAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
> > 1876569969,'jchlin-1','mwcuser',0,'2003-02-10
> >
>
16:59:57.368',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',5758,0,0,0,
> 56
> > 298937754,'jchlin-2','mwcuser',0,'2003-02-10
> >
>
16:59:41.645',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',6768,0,1876
> 569969,2263447764998,0
> >
> >
> > 6. Update the normal column on the last row, the previous row is locked
if
> > its unique constrainted column is updated.
> > -- update the normal column on the last row from jchlin-1
> > update t_servicefeatureinfo set provisioningstate = 56 where id=526
> > connection,user_id,table_name,lock_type,lock_name
> > 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> >
> 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','E',3534758084621
> >
> >
> >
>
Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,No
> deAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
> > 1876569969,'jchlin-1','mwcuser',0,'2003-02-10
> >
>
17:01:32.517',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',5092,0,0,0,
> 3
> > 298937754,'jchlin-2','mwcuser',0,'2003-02-10
> > 17:00:36.110',,,'STMT_DROP','TCPIP','128.107.133.207',3297,0,0,0,0
> >
> > -- update the row in front of the last row from jchlin-2 got blocked
> > update t_servicefeatureinfo set servicefeature = 'ttt3' where id=525;
> > connection,user_id,table_name,lock_type,lock_name
> > 298937754,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> > 298937754,'mwcuser','mwcuser.t_servicefeatureinfo','E',3534758084620
> > 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> >
> 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','E',3534758084621
> >
> >
> >
>
Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,No
> deAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
> > 1876569969,'jchlin-1','mwcuser',0,'2003-02-10
> >
>
17:02:15.051',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',5599,0,0,0,
> 9
> > 298937754,'jchlin-2','mwcuser',0,'2003-02-10
> >
>
17:01:57.254',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',7652,0,1876
> 569969,3534758084621,0
> >
> > Jon
> >
> > "Chris Keating" <Fight_Spam_keating@iAnywhere.com> wrote in message
> > news:<oEyeLiQ0CHA.198@forums.sybase.com>...
> > > Call sa_locks when running each of your tests and provide the
results. I
> > > suspect that you will find phantom locks.
> > >
> > > --
> > >
> > > Chris Keating
> > > Sybase Adaptive Server Anywhere Professional Version 8
> > > iAnywhere Solutions http://www.iAnywhere.com
> > >
> > > ** Please only post to the newsgroup
> > >
> > > ** Whitepapers can be found at http://www.iAnywhere.com/developer
> > > ** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
> > > ** Use CaseXpress to report bugs http://casexpress.sybase.com
> > >
> > > <Jonathan_Lin> wrote in message
> > > news:A6201C20A16060B3002DA03B85256CC9.0065CC3285256CC8@webforums...
> > > > I'm running the test under isolation level 0. So, why doesn't it
have
> > any
> > > > different locking behavior from the higher isolation levels? I
thought
> > > that
> > > > the lower isolation level may give us less restrictive locking.
Also,
> > the
> > > > insertion only from different db connection in my test still works.
> > It's
> > > > the following update operations are causing the locking problem.
> > > >
> > > > Please note that the test #1 and test #2 are tested with update
> > operations
> > > > only without inserting new rows. And the locking behavior for the
> first
> > > > update and second update are different.
> > > >
> > > > Also, does this mean that ASA doesn't support the true row locking?
> > What I
> > > > meant 'true row locking' means that operations on the row only lock
> the
> > > row
> > > > itself without affecting other rows.
> > > >
> > > > Does the ASE 12.5 have the same behavior as ASA? Or does ASE
support
> > the
> > > > true row locking?
> > > >
> > > > Thanks for the help.
> > > >
> > > > Jon
> > > >
> > > > "Chris Keating" <Spam_Free_keating@iAnywhere.com> wrote in message
> > > > news:<kaKB3UG0CHA.198@forums.sybase.com>...
> > > > > This is most likely neither a misconfiguration, bug, or design
> > problem
> > > > in
> > > > > ASA. I recommend that you read the documentation related to locks
--
> > > > phantom
> > > > > locks in particular.
> > > > >
> > > > >
> > > > > <Jonathan_Lin> wrote in message
> > > > >
news:8ED1B73FCBD3DE4200783E7B85256CC7.00230E4B85256CC7@webforums...
> > > > > > Here are the more details about the test results on the row
level
> > > > lockings
> > > > > > I have done:
> > > > > >
> > > > > > 1. Update unique constrainted column the first time, only one
of
> > the
> > > > > > immediate previous or next row is locked randomly.
> > > > > > 2. Update unique constrainted column the second time, the whole
> > table
> > > > is
> > > > > > locked.
> > > > > > 3. Insert a new row and update the row on unique constrainted
> > columns,
> > > > the
> > > > > > whole table is locked.
> > > > > > 4. Insert two new rows and update unique constrainted column of
> the
> > > > first
> > > > > > new row the first time, no additional lock is found.
> > > > > > 5. Insert two new rows and update unique constrainted column of
> the
> > > > first
> > > > > > new row the second time, the whole table is locked.
> > > > > > 6. Update the normal column on the last row, the previous row
is
> > > locked
> > > > if
> > > > > > its unique constrainted column is updated.
> > > > > >
> > > > > > Is this caused by a mis-configuration, a bug, or the
fundamental
> > > design
> > > > > > problem of ANA? Any helps on this is very much appreciated.
> Thanks.
> > > > > >
> > > > > > Jon
> > > > >
> > > > >
> > >
> > >
>
>


Robert Waywell Posted on 2003-02-12 13:50:56.0Z
From: "Robert Waywell" <rwaywell@ianywhere.com>
References: <4D74442FB667C556001EC7AA85256CC7.001EC7B885256CC7@webforums> <8ED1B73FCBD3DE4200783E7B85256CC7.00230E4B85256CC7@webforums> <kaKB3UG0CHA.198@forums.sybase.com> <A6201C20A16060B3002DA03B85256CC9.0065CC3285256CC8@webforums> <oEyeLiQ0CHA.198@forums.sybase.com> <F0F7EF147048A880000B2FF285256CCA.004EE90785256CC9@webforums> <BfVo9md0CHA.351@forums.sybase.com> <3D3142B9C6DD4B200009109D85256CCB.00521D5A85256CCA@webforums>
Subject: Re: Does ASA 8.01 or 7.3 support true row locking?
Date: Wed, 12 Feb 2003 08:50:56 -0500
Lines: 3051
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_NextPart_000_0028_01C2D273.DBCE5640"
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <mH#f8Bq0CHA.59@forums.sybase.com>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: 172.31.143.74
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub ianywhere.public.general:142
Article PK: 1963

Hi Johnathan,
    Since you already have this case open with Lana, can you e-mail here either database or at least the .dat file to reload this table. That will save us a whole lot of fiddling trying to get the sample data into the table.
 
    Note that your UNIQUE constraint is implemented by ASA as an index:
 

Adaptive Server Anywhere SQL User's Guide

  11. Query Optimization and Execution

    Indexes

Other uses for indexes

...

Enforce column uniqueness

     Without an index, Adaptive Server Anywhere has to scan the entire table every time that a value is inserted to ensure that it is unique. For this reason, Adaptive Server Anywhere automatically builds an index on every column with a uniqueness constraint.

 

    The "servicefeature" column that you update in your test is part of the unique constraint which means that it does have an index on it and the documented behaviour related to locking an index range applies in all of your tests. We can certainly spend some more time explaining the specific cases once we have the repro, but at the moment there is no reason to suspect that any of the observed behaviour is other than expected.


--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional
 
Sybase's iAnywhere Solutions
 
Please respond ONLY to newsgroup
 
EBF's and Patches: http://downloads.sybase.com
 choose SQL Anywhere Studio >> change 'time frame' to all
 
To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm
 
SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288
 
Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer
<Jonathan_Lin> wrote in message news:3D3142B9C6DD4B200009109D85256CCB.00521D5A85256CCA@webforums...
> Hi, Robert,
>
> Here's the info. Thanks for the help.
>
> There were no foreign key and create index statements defined for this
> table when I did the testing.
>
> create table t_servicefeatureinfo  (
>   id                          bigint           not null default
> autoincrement,
>   description                 varchar(255),
>   serviceprofile              varchar(64),
>   servicefeature              varchar(64),
>   usecasename                 varchar(64),
>   featureinstanceid           varchar(32),
>   provisioningerrorstatus     int        ,
>   provisioningstate           int        ,
>   provisioningmsg             varchar(255),
>   templatename                varchar(64),
>   templateversion             varchar(32),
>   holdertablename             varchar(50),
>   holderid                    bigint     ,
>   provisioningid              varchar(255),
>   devicetable                 varchar(50),
>   deviceid                    bigint     ,
>   cardtable                   varchar(50),
>   cardid                      bigint     ,
>   peerholdertablename         varchar(50),
>   peerholderid                bigint     ,
>   primary key (id),
>   unique (servicefeature, holdertablename, holderid)
> );
>
> Here are the same records when I did the testing:
>
> id,description,serviceprofile,servicefeature,usecasename,featureinstanceid,provisioningerrorstatus,provisioningstate,provisioningmsg,templatename,templateversion,holdertablename,holderid,provisioningid,devicetable,deviceid,cardtable,cardid,peerholdertablename,peerholderid
> 429,'INIT_PACKET_BTSRTR_PAIR.Init.','pBTSRTRinit','Init','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_init','
> ','t_btsrouter',1,'35','t_btsrouter',1,'t_btsrouter',1,,
> 430,'INIT_MGX.Card_Redundancy.','MGXinit','Card_Redundancy','INIT_MGX','
> ',0,1,,'mgx:rpm_add_card_redundancy','
> ','t_rpmcard',1,'36','t_mgxaggregator',1,'t_rpmcard',1,,
> 431,'INIT_PACKET_BTSRTR_PAIR.Init.','pBTSRTRinit','Init','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_init','
> ','t_btsrouter',2,'35','t_btsrouter',2,'t_btsrouter',2,,
> 432,'INIT_MGX.Init.','MGXinit','Init','INIT_MGX',' ',0,1,,'mgx:pxm_init','
> ','t_pxmcard',1,'36','t_mgxaggregator',1,'t_mgxaggregator',1,,
> 433,'INIT_PACKET_BTSRTR_PAIR.Enable_Password.','pBTSRTRinit','Enable_Password','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_enable_password','
> ','t_btsrouter',1,'35','t_btsrouter',1,'t_btsrouter',1,,
> 434,'INIT_MGX.Init.','MGXinit','Init','INIT_MGX',' ',0,1,,'mgx:rpm_init','
> ','t_rpmcard',1,'36','t_mgxaggregator',1,'t_rpmcard',1,,
> 435,'INIT_PACKET_BTSRTR_PAIR.Enable_Password.','pBTSRTRinit','Enable_Password','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_enable_password','
> ','t_btsrouter',2,'35','t_btsrouter',2,'t_btsrouter',2,,
> 436,'INIT_PACKET_BTSRTR_PAIR.Snmp.','pBTSRTRinit','Snmp','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_SNMP','
> ','t_btsrouter',1,'35','t_btsrouter',1,'t_btsrouter',1,,
> 437,'INIT_MGX.Snmp.','MGXinit','Snmp','INIT_MGX','
> ',0,1,,'mgx:mgx_add_SNMP','
> ','t_pxmcard',1,'36','t_mgxaggregator',1,'t_mgxaggregator',1,,
> 438,'INIT_PACKET_BTSRTR_PAIR.Snmp.','pBTSRTRinit','Snmp','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_SNMP','
> ','t_btsrouter',2,'35','t_btsrouter',2,'t_btsrouter',2,,
> 439,'INIT_MGX.Snmp.','MGXinit','Snmp','INIT_MGX','
> ',0,1,,'mgx:rpm_add_SNMP','
> ','t_rpmcard',1,'36','t_mgxaggregator',1,'t_rpmcard',1,,
> 440,'INIT_PACKET_BTSRTR_PAIR.Logging.','pBTSRTRinit','Logging','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_logging','
> ','t_btsrouter',1,'35','t_btsrouter',1,'t_btsrouter',1,,
> 441,'INIT_MGX.Trap_Manager.','MGXinit','Trap_Manager','INIT_MGX','
> ',0,1,,'mgx:pxm_add_trap_mgr','
> ','t_pxmcard',1,'36','t_mgxaggregator',1,'t_mgxaggregator',1,,
> 442,'INIT_PACKET_BTSRTR_PAIR.Logging.','pBTSRTRinit','Logging','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_logging','
> ','t_btsrouter',2,'35','t_btsrouter',2,'t_btsrouter',2,,
> 443,'INIT_MGX.RPM_PXM_Mgmt_Conn.','MGXinit','RPM_PXM_Mgmt_Conn','INIT_MGX','
> ',0,1,,'mgx:rpm_add_pxm_mgmt_conn','
> ','t_rpmswitch1subinterface',4,'36','t_mgxaggregator',1,'t_rpmcard',1,,
> 444,'INIT_PACKET_BTSRTR_PAIR.Alias.','pBTSRTRinit','Alias','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_aliases','
> ','t_btsrouter',1,'35','t_btsrouter',1,'t_btsrouter',1,,
> 445,'INIT_PACKET_BTSRTR_PAIR.Alias.','pBTSRTRinit','Alias','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_aliases','
> ','t_btsrouter',2,'35','t_btsrouter',2,'t_btsrouter',2,,
> 446,'INIT_MGX.RPM_Basic_16.1.','MGXinit','RPM_Basic_16.1','INIT_MGX','
> ',0,1,,'mgx:rpm_add_basic_16.1','
> ','t_rpmcard',1,'36','t_mgxaggregator',1,'t_rpmcard',1,,
> 447,'INIT_PACKET_BTSRTR_PAIR.Boot.','pBTSRTRinit','Boot','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_boot','
> ','t_btsrouter',1,'35','t_btsrouter',1,'t_btsrouter',1,,
> 448,'INIT_PACKET_BTSRTR_PAIR.Boot.','pBTSRTRinit','Boot','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_boot','
> ','t_btsrouter',2,'35','t_btsrouter',2,'t_btsrouter',2,,
> 449,'INIT_MGX.Enable_Password.','MGXinit','Enable_Password','INIT_MGX','
> ',0,1,,'mgx:rpm_add_enable_password','
> ','t_rpmcard',1,'36','t_mgxaggregator',1,'t_rpmcard',1,,
> 450,'INIT_PACKET_BTSRTR_PAIR.Standard_ACL.','pBTSRTRinit','Standard_ACL','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_standard_acl','
> ','t_btsrouter',1,'35','t_btsrouter',1,'t_btsrouter',1,,
> 451,'INIT_MGX.Logging.','MGXinit','Logging','INIT_MGX','
> ',0,1,,'mgx:rpm_add_logging','
> ','t_rpmcard',1,'36','t_mgxaggregator',1,'t_rpmcard',1,,
> 452,'INIT_PACKET_BTSRTR_PAIR.Standard_ACL.','pBTSRTRinit','Standard_ACL','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_standard_acl','
> ','t_btsrouter',2,'35','t_btsrouter',2,'t_btsrouter',2,,
> 453,'INIT_PACKET_BTSRTR_PAIR.QOS.','pBTSRTRinit','QOS','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_QOS','
> ','t_btsrouter',1,'35','t_btsrouter',1,'t_btsrouter',1,,
> 454,'INIT_PACKET_BTSRTR_PAIR.QOS.','pBTSRTRinit','QOS','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_QOS','
> ','t_btsrouter',2,'35','t_btsrouter',2,'t_btsrouter',2,,
> 455,'INIT_MGX.Alias.','MGXinit','Alias','INIT_MGX','
> ',0,1,,'mgx:rpm_add_aliases','
> ','t_rpmcard',1,'36','t_mgxaggregator',1,'t_rpmcard',1,,
> 456,'INIT_PACKET_BTSRTR_PAIR.OSPF1_Basic.','pBTSRTRinit','OSPF1_Basic','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_OSPF1_basic','
> ','t_btsrouter',1,'35','t_btsrouter',1,'t_btsrouter',1,,
> 457,'INIT_PACKET_BTSRTR_PAIR.OSPF1_Basic.','pBTSRTRinit','OSPF1_Basic','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_OSPF1_basic','
> ','t_btsrouter',2,'35','t_btsrouter',2,'t_btsrouter',2,,
> 458,'INIT_MGX.Boot.','MGXinit','Boot','INIT_MGX','
> ',0,1,,'mgx:rpm_add_boot','
> ','t_rpmcard',1,'36','t_mgxaggregator',1,'t_rpmcard',1,,
> 459,'INIT_PACKET_BTSRTR_PAIR.OSPF2_Basic.','pBTSRTRinit','OSPF2_Basic','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_OSPF2_basic','
> ','t_btsrouter',1,'35','t_btsrouter',1,'t_btsrouter',1,,
> 460,'INIT_MGX.QOS.','MGXinit','QOS','INIT_MGX',' ',0,1,,'mgx:rpm_add_QOS','
> ','t_rpmcard',1,'36','t_mgxaggregator',1,'t_rpmcard',1,,
> 461,'INIT_PACKET_BTSRTR_PAIR.OSPF2_Basic.','pBTSRTRinit','OSPF2_Basic','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_OSPF2_basic','
> ','t_btsrouter',2,'35','t_btsrouter',2,'t_btsrouter',2,,
> 462,'INIT_PACKET_BTSRTR_PAIR.OSPF_Area2.','pBTSRTRinit','OSPF_Area2','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_OSPF1_network_area2','
> ','t_ospfnetworkinfo',5,'35','t_btsrouter',1,'t_btsrouter',1,,
> 463,'INIT_MGX.OSPF_Basic.','MGXinit','OSPF_Basic','INIT_MGX','
> ',0,1,,'mgx:rpm_add_OSPF_basic','
> ','t_rpmcard',1,'36','t_mgxaggregator',1,'t_rpmcard',1,,
> 464,'INIT_PACKET_BTSRTR_PAIR.OSPF_Area2.','pBTSRTRinit','OSPF_Area2','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_OSPF1_network_area2','
> ','t_ospfnetworkinfo',6,'35','t_btsrouter',2,'t_btsrouter',2,,
> 465,'INIT_PACKET_BTSRTR_PAIR.OSPF_Area51.','pBTSRTRinit','OSPF_Area51','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_OSPF2_network_area51','
> ','t_ospfnetworkinfo',7,'35','t_btsrouter',1,'t_btsrouter',1,,
> 466,'INIT_MGX.OSPF_Area0.','MGXinit','OSPF_Area0','INIT_MGX','
> ',0,1,,'mgx:rpm_add_OSPF_network_area0','
> ','t_ospfnetworkinfo',1,'36','t_mgxaggregator',1,'t_rpmcard',1,,
> 467,'INIT_MGX.OSPF_Area0.','MGXinit','OSPF_Area0','INIT_MGX','
> ',0,1,,'mgx:rpm_add_OSPF_network_area0','
> ','t_ospfnetworkinfo',2,'36','t_mgxaggregator',1,'t_rpmcard',1,,
> 468,'INIT_PACKET_BTSRTR_PAIR.OSPF_Area51.','pBTSRTRinit','OSPF_Area51','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_OSPF2_network_area51','
> ','t_ospfnetworkinfo',10,'35','t_btsrouter',2,'t_btsrouter',2,,
> 469,'INIT_PACKET_BTSRTR_PAIR.OSPF_Area51.','pBTSRTRinit','OSPF_Area51','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_OSPF2_network_area51','
> ','t_ospfnetworkinfo',8,'35','t_btsrouter',1,'t_btsrouter',1,,
> 470,'INIT_MGX.OSPF_Area2.','MGXinit','OSPF_Area2','INIT_MGX','
> ',0,1,,'mgx:rpm_add_OSPF_network_area2','
> ','t_ospfnetworkinfo',3,'36','t_mgxaggregator',1,'t_rpmcard',1,,
> 471,'INIT_PACKET_BTSRTR_PAIR.OSPF_Area51.','pBTSRTRinit','OSPF_Area51','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_OSPF2_network_area51','
> ','t_ospfnetworkinfo',11,'35','t_btsrouter',2,'t_btsrouter',2,,
> 472,'INIT_PACKET_BTSRTR_PAIR.OSPF_Area51.','pBTSRTRinit','OSPF_Area51','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_OSPF2_network_area51','
> ','t_ospfnetworkinfo',9,'35','t_btsrouter',1,'t_btsrouter',1,,
> 473,'INIT_PACKET_BTSRTR_PAIR.OSPF_Area51.','pBTSRTRinit','OSPF_Area51','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_OSPF2_network_area51','
> ','t_ospfnetworkinfo',12,'35','t_btsrouter',2,'t_btsrouter',2,,
> 474,'INIT_MGX.OSPF_Area2_Range.','MGXinit','OSPF_Area2_Range','INIT_MGX','
> ',0,1,,'mgx:rpm_add_OSPF_area2_range','
> ','t_ospfnetworkinfo',4,'36','t_mgxaggregator',1,'t_rpmcard',1,,
> 475,'INIT_PACKET_BTSRTR_PAIR.OSPF_Area51_Summary.','pBTSRTRinit','OSPF_Area51_Summary','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_OSPF1_summary_address','
> ','t_ospfnetworkinfo',13,'35','t_btsrouter',1,'t_btsrouter',1,,
> 476,'INIT_PACKET_BTSRTR_PAIR.OSPF_Area51_Summary.','pBTSRTRinit','OSPF_Area51_Summary','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_OSPF1_summary_address','
> ','t_ospfnetworkinfo',15,'35','t_btsrouter',2,'t_btsrouter',2,,
> 477,'INIT_MGX.L3_Interface.','MGXinit','L3_Interface','INIT_MGX','
> ',0,1,,'mgx:rpm_add_L3_interface','
> ','t_rpmfeinterface',1,'36','t_mgxaggregator',1,'t_rpmcard',1,,
> 478,'INIT_PACKET_BTSRTR_PAIR.MLPPP.','pBTSRTRinit','MLPPP','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_MLPPP','
> ','t_btsrmlpppbundle',3,'35','t_btsrouter',1,'t_btsrouter',1,,
> 479,'INIT_MGX.L3_Interface.','MGXinit','L3_Interface','INIT_MGX','
> ',0,1,,'mgx:rpm_add_L3_interface','
> ','t_rpmfeinterface',2,'36','t_mgxaggregator',1,'t_rpmcard',1,,
> 480,'INIT_PACKET_BTSRTR_PAIR.MLPPP.','pBTSRTRinit','MLPPP','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_MLPPP','
> ','t_btsrmlpppbundle',5,'35','t_btsrouter',2,'t_btsrouter',2,,
> 481,'INIT_MGX.OSPF_To_Interface.','MGXinit','OSPF_To_Interface','INIT_MGX','
> ',0,1,,'mgx:rpm_add_OSPF_to_FE_interface','
> ','t_rpmfeinterface',1,'36','t_mgxaggregator',1,'t_rpmcard',1,,
> 482,'INIT_PACKET_BTSRTR_PAIR.Hdr_Compression.','pBTSRTRinit','Hdr_Compression','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_hdr_compression','
> ','t_btsrmlpppbundle',3,'35','t_btsrouter',1,'t_btsrouter',1,,
> 483,'INIT_MGX.OSPF_To_Interface.','MGXinit','OSPF_To_Interface','INIT_MGX','
> ',0,1,,'mgx:rpm_add_OSPF_to_FE_interface','
> ','t_rpmfeinterface',2,'36','t_mgxaggregator',1,'t_rpmcard',1,,
> 484,'INIT_PACKET_BTSRTR_PAIR.Hdr_Compression.','pBTSRTRinit','Hdr_Compression','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_hdr_compression','
> ','t_btsrmlpppbundle',5,'35','t_btsrouter',2,'t_btsrouter',2,,
> 485,'INIT_MGX.OSPF_To_Interface.','MGXinit','OSPF_To_Interface','INIT_MGX','
> ',0,1,,'mgx:rpm_add_OSPF_to_MLPPP_interface','
> ','t_rpmmlpppbundle',1,'36','t_mgxaggregator',1,'t_rpmcard',1,,
> 486,'INIT_PACKET_BTSRTR_PAIR.PPP_Mux.','pBTSRTRinit','PPP_Mux','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_ppp_mux','
> ','t_btsrmlpppbundle',3,'35','t_btsrouter',1,'t_btsrouter',1,,
> 487,'INIT_MGX.OSPF_To_Interface.','MGXinit','OSPF_To_Interface','INIT_MGX','
> ',0,1,,'mgx:rpm_add_OSPF_to_MLPPP_interface','
> ','t_rpmmlpppbundle',2,'36','t_mgxaggregator',1,'t_rpmcard',1,,
> 488,'INIT_PACKET_BTSRTR_PAIR.PPP_Mux.','pBTSRTRinit','PPP_Mux','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_ppp_mux','
> ','t_btsrmlpppbundle',5,'35','t_btsrouter',2,'t_btsrouter',2,,
> 489,'INIT_MGX.PIM_For_Port.','MGXinit','PIM_For_Port','INIT_MGX','
> ',0,1,,'mgx:rpm_add_PIM','
> ','t_rpmfeinterface',1,'36','t_mgxaggregator',1,'t_rpmcard',1,,
> 490,'INIT_PACKET_BTSRTR_PAIR.OSPF_To_Interface.','pBTSRTRinit','OSPF_To_Interface','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_OSPF_to_MLPPP_interface','
> ','t_btsrmlpppbundle',3,'35','t_btsrouter',1,'t_btsrouter',1,,
> 491,'INIT_PACKET_BTSRTR_PAIR.OSPF_To_Interface.','pBTSRTRinit','OSPF_To_Interface','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_OSPF_to_MLPPP_interface','
> ','t_btsrmlpppbundle',5,'35','t_btsrouter',2,'t_btsrouter',2,,
> 492,'INIT_PACKET_BTSRTR_PAIR.OSPF_To_Interface.','pBTSRTRinit','OSPF_To_Interface','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_OSPF_to_FE_interface','
> ','t_btsrfeinterface',1,'35','t_btsrouter',1,'t_btsrcard',1,,
> 493,'INIT_MGX.PIM_For_Port.','MGXinit','PIM_For_Port','INIT_MGX','
> ',0,1,,'mgx:rpm_add_PIM','
> ','t_rpmfeinterface',2,'36','t_mgxaggregator',1,'t_rpmcard',1,,
> 494,'INIT_PACKET_BTSRTR_PAIR.OSPF_To_Interface.','pBTSRTRinit','OSPF_To_Interface','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_OSPF_to_FE_interface','
> ','t_btsrfeinterface',3,'35','t_btsrouter',2,'t_btsrcard',2,,
> 495,'INIT_MGX.IP_Pool.','MGXinit','IP_Pool','INIT_MGX','
> ',0,1,,'mgx:rpm_add_ip_pool','
> ','t_ippoolinfo',1,'36','t_mgxaggregator',1,'t_rpmcard',1,,
> 496,'INIT_PACKET_BTSRTR_PAIR.OSPF_To_Interface.','pBTSRTRinit','OSPF_To_Interface','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_OSPF_to_FE_interface','
> ','t_btsrfeinterface',2,'35','t_btsrouter',1,'t_btsrcard',1,,
> 497,'INIT_MGX.MLPPP_For_BTSRTRLink.','MGXinit','MLPPP_For_BTSRTRLink','INIT_MGX','
> ',0,1,,'mgx:rpm_add_MLPPP_BTSRTRLink','
> ','t_rpmmlpppbundle',1,'36','t_mgxaggregator',1,'t_rpmcard',1,,
> 498,'INIT_PACKET_BTSRTR_PAIR.OSPF_To_Interface.','pBTSRTRinit','OSPF_To_Interface','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_OSPF_to_FE_interface','
> ','t_btsrfeinterface',4,'35','t_btsrouter',2,'t_btsrcard',2,,
> 499,'INIT_MGX.MLPPP.','MGXinit','MLPPP','INIT_MGX','
> ',0,1,,'mgx:rpm_add_MLPPP','
> ','t_rpmmlpppbundle',2,'36','t_mgxaggregator',1,'t_rpmcard',1,,
> 500,'INIT_PACKET_BTSRTR_PAIR.PIM_For_MLPPP.','pBTSRTRinit','PIM_For_MLPPP','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_PIM_to_MLPPP','
> ','t_btsrmlpppbundle',3,'35','t_btsrouter',1,'t_btsrouter',1,,
> 501,'INIT_PACKET_BTSRTR_PAIR.PIM_For_MLPPP.','pBTSRTRinit','PIM_For_MLPPP','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_PIM_to_MLPPP','
> ','t_btsrmlpppbundle',5,'35','t_btsrouter',2,'t_btsrouter',2,,
> 502,'INIT_MGX.PPP_Mux.','MGXinit','PPP_Mux','INIT_MGX','
> ',0,1,,'mgx:rpm_add_ppp_mux','
> ','t_rpmmlpppbundle',2,'36','t_mgxaggregator',1,'t_rpmcard',1,,
> 503,'INIT_PACKET_BTSRTR_PAIR.Wan_Controller.','pBTSRTRinit','Wan_Controller','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_T1_shortcbl','
> ','t_btsrds1interface',1,'35','t_btsrouter',1,'t_btsrcard',3,,
> 504,'INIT_PACKET_BTSRTR_PAIR.Wan_Controller.','pBTSRTRinit','Wan_Controller','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_T1_shortcbl','
> ','t_btsrds1interface',3,'35','t_btsrouter',2,'t_btsrcard',4,,
> 505,'INIT_MGX.Hdr_Compression.','MGXinit','Hdr_Compression','INIT_MGX','
> ',0,1,,'mgx:rpm_add_hdr_compression','
> ','t_rpmmlpppbundle',2,'36','t_mgxaggregator',1,'t_rpmcard',1,,
> 506,'INIT_PACKET_BTSRTR_PAIR.Serial_Channel_Group.','pBTSRTRinit','Serial_Channel_Group','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_T1_channelgroup','
> ','t_btsrds1channelgroup',2,'35','t_btsrouter',1,'t_btsrcard',3,,
> 507,'INIT_PACKET_BTSRTR_PAIR.Serial_Channel_Group.','pBTSRTRinit','Serial_Channel_Group','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_T1_channelgroup','
> ','t_btsrds1channelgroup',5,'35','t_btsrouter',2,'t_btsrcard',4,,
> 508,'INIT_MGX.PIM_For_MLPPP.','MGXinit','PIM_For_MLPPP','INIT_MGX','
> ',0,1,,'mgx:rpm_add_PIM','
> ','t_rpmmlpppbundle',2,'36','t_mgxaggregator',1,'t_rpmcard',1,,
> 509,'INIT_PACKET_BTSRTR_PAIR.Span_Interface.','pBTSRTRinit','Span_Interface','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_span_interface','
> ','t_btsrds1serialinterface',2,'35','t_btsrouter',1,'t_btsrcard',3,,
> 510,'INIT_PACKET_BTSRTR_PAIR.Span_Interface.','pBTSRTRinit','Span_Interface','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_span_interface','
> ','t_btsrds1serialinterface',5,'35','t_btsrouter',2,'t_btsrcard',4,,
> 511,'INIT_PACKET_BTSRTR_PAIR.L3_Interface.','pBTSRTRinit','L3_Interface','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_l3_interface','
> ','t_btsrfeinterface',1,'35','t_btsrouter',1,'t_btsrcard',1,,
> 512,'INIT_PACKET_BTSRTR_PAIR.L3_Interface.','pBTSRTRinit','L3_Interface','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_l3_interface','
> ','t_btsrfeinterface',3,'35','t_btsrouter',2,'t_btsrcard',2,,
> 513,'INIT_PACKET_BTSRTR_PAIR.L3_Interface.','pBTSRTRinit','L3_Interface','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_l3_interface','
> ','t_btsrfeinterface',2,'35','t_btsrouter',1,'t_btsrcard',1,,
> 514,'INIT_PACKET_BTSRTR_PAIR.L3_Interface.','pBTSRTRinit','L3_Interface','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_l3_interface','
> ','t_btsrfeinterface',4,'35','t_btsrouter',2,'t_btsrcard',2,,
> 515,'INIT_PACKET_BTSRTR_PAIR.PIM_For_Port.','pBTSRTRinit','PIM_For_Port','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_PIM','
> ','t_btsrfeinterface',1,'35','t_btsrouter',1,'t_btsrcard',1,,
> 516,'INIT_PACKET_BTSRTR_PAIR.PIM_For_Port.','pBTSRTRinit','PIM_For_Port','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_PIM','
> ','t_btsrfeinterface',3,'35','t_btsrouter',2,'t_btsrcard',2,,
> 517,'INIT_PACKET_BTSRTR_PAIR.PIM_For_Port.','pBTSRTRinit','PIM_For_Port','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_PIM','
> ','t_btsrfeinterface',2,'35','t_btsrouter',1,'t_btsrcard',1,,
> 518,'INIT_PACKET_BTSRTR_PAIR.PIM_For_Port.','pBTSRTRinit','PIM_For_Port','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_PIM','
> ','t_btsrfeinterface',4,'35','t_btsrouter',2,'t_btsrcard',2,,
> 519,'INIT_PACKET_BTSRTR_PAIR.HSRP.','pBTSRTRinit','HSRP','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_HSRP','
> ','t_btsrfeinterface',1,'35','t_btsrouter',1,'t_btsrcard',1,,
> 520,'INIT_PACKET_BTSRTR_PAIR.HSRP.','pBTSRTRinit','HSRP','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_HSRP','
> ','t_btsrfeinterface',3,'35','t_btsrouter',2,'t_btsrcard',2,,
> 521,'INIT_PACKET_BTSRTR_PAIR.HSRP.','pBTSRTRinit','HSRP','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_HSRP','
> ','t_btsrfeinterface',2,'35','t_btsrouter',1,'t_btsrcard',1,,
> 522,'INIT_PACKET_BTSRTR_PAIR.HSRP.','pBTSRTRinit','HSRP','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_HSRP','
> ','t_btsrfeinterface',4,'35','t_btsrouter',2,'t_btsrcard',2,,
> 523,'INIT_PACKET_BTSRTR_PAIR.MLPPP_Track.','pBTSRTRinit','MLPPP_Track','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_MLPPP_redundancy','
> ','t_btsrouter',1,'35','t_btsrouter',1,'t_btsrouter',1,,
> 524,'INIT_PACKET_BTSRTR_PAIR.MLPPP_Track.','pBTSRTRinit','MLPPP_Track','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_MLPPP_redundancy','
> ','t_btsrouter',2,'35','t_btsrouter',2,'t_btsrouter',2,,
> 525,'INIT_PACKET_BTSRTR_PAIR.IP_Route.','pBTSRTRinit','ttt10','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_ip_route','
> ','t_iprouteinfo',2,'35','t_btsrouter',1,'t_btsrouter',1,,
> 526,'INIT_PACKET_BTSRTR_PAIR.IP_Route.','pBTSRTRinit','IP_Route','INIT_PACKET_BTSRTR_PAIR','
> ',0,1,,'btsrtr:btsrtr_add_ip_route','
> ','t_iprouteinfo',3,'35','t_btsrouter',2,'t_btsrouter',2,,
>
> Jon
>
> "Robert Waywell" <rwaywell@ianywhere.com> wrote in message
> news:BfVo9md0CHA.351@forums.sybase.com...
> > Can you post the CREATE TABLE statement plus all CREATE INDEX and Foreign
> > Key definitions?
> > Can you provide the details of the records currently in the table at the
> > time you run these tests?
> >
> >
> > --
> > -----------------------------------------------
> > Robert Waywell
> > Sybase Adaptive Server Anywhere Developer - Version 8
> > Sybase Certified Professional
> >
> > Sybase's iAnywhere Solutions
> >
> > Please respond ONLY to newsgroup
> >
> > EBF's and Patches: http://downloads.sybase.com
> >  choose SQL Anywhere Studio >> change 'time frame' to all
> >
> > To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm
> >
> > SQL Anywhere Studio Supported Platforms and Support Status
> > http://my.sybase.com/detail?id=1002288
> >
> > Whitepapers, TechDocs, and bug fixes are all available through the
> iAnywhere
> > Developer Community at www.ianywhere.com/developer
> >
> > <Jonathan_Lin> wrote in message
> > news:F0F7EF147048A880000B2FF285256CCA.004EE90785256CC9@webforums...
> > > Hi, Chris,
> > >
> > > Here's the results. Thanks for the help.
> > >
> > > 1. Update unique constrainted column the first time, only one of the
> > > immediate previous or next row is locked randomly.
> > >
> > > update t_servicefeatureinfo set servicefeature = 'ttt5' where id=525;
> --
> > > from jchlin-1 (db connection)
> > >
> > >       connection,user_id,table_name,lock_type,lock_name
> > >       1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> > >
> > 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','E',3534758084620
> > >
> > >
> >
> 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPA0005',3534758084621
> > >
> > >
> > >
> >
> Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,No
> > deAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
> > >       1876569969,'jchlin-1','mwcuser',0,'2003-02-10
> > >
> >
> 16:32:41.014',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',2903,0,0,0,
> > 7
> > >       298937754,'jchlin-2','mwcuser',0,'2003-02-10
> > > 16:26:29.878',,,'STMT_DROP','TCPIP','128.107.133.207',1941,0,0,0,0
> > >
> > > -- id 526 is the immediate next row to id 525
> > > update t_servicefeatureinfo set servicefeature = 'ttt3' where id=526;
> --
> > > from jchlin-2 (db connection) got blocked
> > >
> >
> >
> >
> > >       connection,user_id,table_name,lock_type,lock_name
> > >       298937754,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> > >       1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> > >
> > 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','E',3534758084620
> > >
> > >
> >
> 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPA0005',3534758084621
> > >
> > >
> > >
> >
> Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,No
> > deAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
> > >       1876569969,'jchlin-1','mwcuser',0,'2003-02-10
> > >
> >
> 16:33:56.938',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',5844,0,0,0,
> > 13
> > >       298937754,'jchlin-2','mwcuser',0,'2003-02-10
> > >
> >
> 16:33:29.658',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',8141,0,1876
> > 569969,3534758084621,0
> > >
> > >
> > > 2. Update unique constrainted column the second time, the whole table
> is
> > > locked.
> > >
> > > update t_servicefeatureinfo set servicefeature = 'ttt10' where id=525;
> --
> > > from jchlin-1 (continued from test #1)
> > >
> > >       connection,user_id,table_name,lock_type,lock_name
> > >       1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> > >
> > >
> >
> 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPA0005',2263447764998
> > >
> > >
> >
> 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','EPA0005',3534758084620
> > >
> > >
> >
> 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPA0005',3534758084621
> > >
> > >
> > >
> >
> Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,No
> > deAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
> > >       1876569969,'jchlin-1','mwcuser',0,'2003-02-10
> > >
> >
> 16:37:10.769',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',3730,0,0,0,
> > 9
> > >       298937754,'jchlin-2','mwcuser',0,'2003-02-10
> > > 16:34:23.795',,,'STMT_DROP','TCPIP','128.107.133.207',6402,0,0,0,0
> > >
> > >
> > > update t_servicefeatureinfo set servicefeature = 'ttt3' where id=526;
> --
> > > from jchlin-2 got blocked
> > >
> > >       connection,user_id,table_name,lock_type,lock_name
> > >       298937754,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> > >       1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> > >
> > >
> >
> 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPA0005',2263447764998
> > >
> > >
> >
> 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','EPA0005',3534758084620
> > >
> > >
> >
> 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPA0005',3534758084621
> > >
> > >
> > >
> >
> Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,No
> > deAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
> > >       1876569969,'jchlin-1','mwcuser',0,'2003-02-10
> > >
> >
> 16:38:54.296',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',7852,0,0,0,
> > 16
> > >       298937754,'jchlin-2','mwcuser',0,'2003-02-10
> > >
> >
> 16:38:00.181',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',9375,0,1876
> > 569969,3534758084621,0
> > >
> > > 3. Insert a new row and update the row on unique constrainted columns,
> the
> > > whole table is locked.
> > > -- insert a new row from jchlin-1
> > > INSERT INTO t_servicefeatureinfo
> > >
> >
> (description,serviceprofile,servicefeature,usecasename,featureinstanceid,pro
> >
> visioningerrorstatus,provisioningstate,provisioningmsg,templatename,template
> >
> version,holdertablename,holderid,provisioningid,devicetable,deviceid,cardtab
> > le,cardid,peerholdertablename,peerholderid
> > > ) VALUES ( 'ttt','ttt','ttt1','ttt',' ',0,2,null,'ttt','
> > > ','t_iprouteinfo',2,'406','t_btsrouter',2,'t_btsrouter',2,null,null);
> > >
> > >       connection,user_id,table_name,lock_type,lock_name
> > >       1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> > >
> > 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','E',3612067495936
> > >
> > >
> > >
> >
> Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,No
> > deAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
> > >       1876569969,'jchlin-1','mwcuser',0,'2003-02-10
> > >
> >
> 16:47:41.305',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',5266,0,0,0,
> > 3
> > >       298937754,'jchlin-2','mwcuser',0,'2003-02-10
> > > 16:46:53.313',,,'STMT_DROP','TCPIP','128.107.133.207',8789,0,0,0,0
> > >
> > > -- update the newly created row from jchlin-1
> > > update t_servicefeatureinfo set servicefeature = 'ttt5' where id=689;
> > >       connection,user_id,table_name,lock_type,lock_name
> > >       1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> > >
> > >
> >
> 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPA0005',2263447764998
> > >
> > >
> >
> 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','EPA0005',3612067495936
> > >
> > >
> > >
> >
> Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,No
> > deAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
> > >       1876569969,'jchlin-1','mwcuser',0,'2003-02-10
> > >
> >
> 16:49:10.464',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',5221,0,0,0,
> > 9
> > >       298937754,'jchlin-2','mwcuser',0,'2003-02-10
> > > 16:48:11.102',,,'STMT_DROP','TCPIP','128.107.133.207',5560,0,0,0,0
> > >
> > > -- insert a new row from jchlin-2 got blocked
> > > INSERT INTO t_servicefeatureinfo
> > >
> >
> (description,serviceprofile,servicefeature,usecasename,featureinstanceid,pro
> >
> visioningerrorstatus,provisioningstate,provisioningmsg,templatename,template
> >
> version,holdertablename,holderid,provisioningid,devicetable,deviceid,cardtab
> > le,cardid,peerholdertablename,peerholderid
> > > ) VALUES ('ttt','ttt','ttt4','ttt',' ',0,2,null,'ttt','
> > > ','t_iprouteinfo',2,'406','t_btsrouter',2,'t_btsrouter',2,null,null);
> > >       connection,user_id,table_name,lock_type,lock_name
> > >       298937754,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> > > 298937754,'mwcuser','mwcuser.t_servicefeatureinfo','E',3612067495937
> > > 298937754,'mwcuser','mwcuser.t_servicefeatureinfo','E',3612067495937
> > >       1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> > >
> > >
> >
> 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPA0005',2263447764998
> > >
> > >
> >
> 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','EPA0005',3612067495936
> > >
> > >
> > >
> >
> Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,No
> > deAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
> > >       1876569969,'jchlin-1','mwcuser',0,'2003-02-10
> > >
> >
> 16:49:59.590',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',6031,0,0,0,
> > 17
> > >       298937754,'jchlin-2','mwcuser',0,'2003-02-10
> > >
> >
> 16:49:35.620',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',6662,0,1876
> > 569969,3612067495936,0
> > >
> > > -- update 525's immediate next row  from jchlin-2 got blocked
> > >       update t_servicefeatureinfo set servicefeature = 'ttt3' where
> > id=526;
> > >
> > >       connection,user_id,table_name,lock_type,lock_name
> > >       298937754,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> > > 298937754,'mwcuser','mwcuser.t_servicefeatureinfo','E',3534758084621
> > >
> >
> 298937754,'mwcuser','mwcuser.t_servicefeatureinfo','SPA0005',3573412790290
> > >       1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> > >
> > >
> >
> 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPA0005',2263447764998
> > >
> > >
> >
> 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','EPA0005',3612067495936
> > >
> > >
> > >
> >
> Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,No
> > deAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
> > >       1876569969,'jchlin-1','mwcuser',0,'2003-02-10
> > >
> >
> 16:50:52.850',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',6766,0,0,0,
> > 25
> > >       298937754,'jchlin-2','mwcuser',0,'2003-02-10
> > >
> >
> 16:50:27.836',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',4711,0,1876
> > 569969,3612067495936,0
> > >
> > >
> > >
> > > 4. Insert two new rows and update unique constrainted column of the
> first
> > > new row the first time, no additional lock is found.
> > > -- insert 1st new row from jchlin-1
> > > INSERT INTO t_servicefeatureinfo
> > >
> >
> (description,serviceprofile,servicefeature,usecasename,featureinstanceid,pro
> >
> visioningerrorstatus,provisioningstate,provisioningmsg,templatename,template
> >
> version,holdertablename,holderid,provisioningid,devicetable,deviceid,cardtab
> > le,cardid,peerholdertablename,peerholderid
> > > ) VALUES ( 'ttt','ttt','ttt1','ttt',' ',0,2,null,'ttt','
> > > ','t_iprouteinfo',2,'406','t_btsrouter',2,'t_btsrouter',2,null,null);
> > >       connection,user_id,table_name,lock_type,lock_name
> > >       1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> > >
> > 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','E',3612067495936
> > >
> > >
> > >
> >
> Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,No
> > deAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
> > >       1876569969,'jchlin-1','mwcuser',0,'2003-02-10
> > >
> >
> 16:52:48.194',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',5844,0,0,0,
> > 3
> > >       298937754,'jchlin-2','mwcuser',0,'2003-02-10
> > > 16:52:00.173',,,'STMT_DROP','TCPIP','128.107.133.207',3078,0,0,0,0
> > >
> > > -- insert  2nd new row from jchlin-1 again
> > > INSERT INTO t_servicefeatureinfo
> > >
> >
> (description,serviceprofile,servicefeature,usecasename,featureinstanceid,pro
> >
> visioningerrorstatus,provisioningstate,provisioningmsg,templatename,template
> >
> version,holdertablename,holderid,provisioningid,devicetable,deviceid,cardtab
> > le,cardid,peerholdertablename,peerholderid
> > > ) VALUES ('ttt','ttt','ttt2','ttt',' ',0,2,null,'ttt','
> > > ','t_iprouteinfo',2,'406','t_btsrouter',2,'t_btsrouter',2,null,null);
> > >       connection,user_id,table_name,lock_type,lock_name
> > >       1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> > >
> > 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','E',3612067495936
> > >
> > 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','E',3612067495937
> > >
> > >
> > >
> >
> Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,No
> > deAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
> > >       1876569969,'jchlin-1','mwcuser',0,'2003-02-10
> > >
> >
> 16:53:15.153',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',3319,0,0,0,
> > 9
> > >       298937754,'jchlin-2','mwcuser',0,'2003-02-10
> > > 16:52:00.173',,,'STMT_DROP','TCPIP','128.107.133.207',3078,0,0,0,0
> > >
> > > -- update the the first newly created row from jchlin-1
> > > update t_servicefeatureinfo set servicefeature = 'ttt5' where id=693;
> > >       connection,user_id,table_name,lock_type,lock_name
> > >       1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> > >
> > 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','E',3612067495936
> > >
> > >
> >
> 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','EPA0005',3612067495937
> > >
> > >
> > >
> >
> Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,No
> > deAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
> > >       1876569969,'jchlin-1','mwcuser',0,'2003-02-10
> > >
> >
> 16:54:25.200',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',4080,0,0,0,
> > 15
> > >       298937754,'jchlin-2','mwcuser',0,'2003-02-10
> > > 16:52:00.173',,,'STMT_DROP','TCPIP','128.107.133.207',3078,0,0,0,0
> > >
> > > -- insert a new row from jchlin-2 successfully
> > > INSERT INTO t_servicefeatureinfo
> > >
> >
> (description,serviceprofile,servicefeature,usecasename,featureinstanceid,pro
> >
> visioningerrorstatus,provisioningstate,provisioningmsg,templatename,template
> >
> version,holdertablename,holderid,provisioningid,devicetable,deviceid,cardtab
> > le,cardid,peerholdertablename,peerholderid
> > > ) VALUES ('ttt','ttt','ttt4','ttt',' ',0,2,null,'ttt','
> > > ','t_iprouteinfo',2,'406','t_btsrouter',2,'t_btsrouter',2,null,null);
> > >       connection,user_id,table_name,lock_type,lock_name
> > >       298937754,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> > > 298937754,'mwcuser','mwcuser.t_servicefeatureinfo','E',3612067495938
> > >       1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> > >
> > 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','E',3612067495936
> > >
> > >
> >
> 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','EPA0005',3612067495937
> > >
> > >
> > >
> >
> Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,No
> > deAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
> > >       1876569969,'jchlin-1','mwcuser',0,'2003-02-10
> > >
> >
> 16:55:22.998',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',5690,0,0,0,
> > 22
> > >       298937754,'jchlin-2','mwcuser',0,'2003-02-10
> > > 16:54:40.596',,,'STMT_DROP','TCPIP','128.107.133.207',5968,0,0,0,1
> > >
> > > -- update 525's immediate next row  from jchlin-2 successfully
> > > update t_servicefeatureinfo set servicefeature = 'ttt3' where id=526;
> > >       connection,user_id,table_name,lock_type,lock_name
> > >       298937754,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> > > 298937754,'mwcuser','mwcuser.t_servicefeatureinfo','E',3534758084621
> > >
> >
> 298937754,'mwcuser','mwcuser.t_servicefeatureinfo','SPA0005',3573412790290
> > > 298937754,'mwcuser','mwcuser.t_servicefeatureinfo','E',3612067495938
> > >       1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> > >
> > 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','E',3612067495936
> > >
> > >
> >
> 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','EPA0005',3612067495937
> > >
> > >
> > >
> >
> Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,No
> > deAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
> > >       1876569969,'jchlin-1','mwcuser',0,'2003-02-10
> > >
> >
> 16:57:05.596',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',9344,0,0,0,
> > 31
> > >       298937754,'jchlin-2','mwcuser',0,'2003-02-10
> > > 16:56:00.974',,,'STMT_DROP','TCPIP','128.107.133.207',6424,0,0,0,2
> > >
> > >
> > >
> > > 5. Insert two new rows and update unique constrainted column of the
> first
> > > new row the second time, the whole table is locked.
> > > continue from 4:
> > >
> > > -- continue from test #4, update the the first newly created row the
> 2nd
> > > time from jchlin-1
> > > update t_servicefeatureinfo set servicefeature = 'ttt10' where id=693;
> > >       connection,user_id,table_name,lock_type,lock_name
> > >       1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> > >
> > >
> >
> 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPA0005',2263447764998
> > >
> > >
> >
> 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','EPA0005',3612067495936
> > >
> > >
> >
> 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','EPA0005',3612067495937
> > >
> > >
> > >
> >
> Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,No
> > deAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
> > >       1876569969,'jchlin-1','mwcuser',0,'2003-02-10
> > >
> >
> 16:58:46.919',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',6048,0,0,0,
> > 38
> > >       298937754,'jchlin-2','mwcuser',0,'2003-02-10
> > > 16:57:49.353',,,'STMT_DROP','TCPIP','128.107.133.207',8789,0,0,0,0
> > >
> > > -- insert a new row from jchlin-2 got blocked
> > > INSERT INTO t_servicefeatureinfo
> > >
> >
> (description,serviceprofile,servicefeature,usecasename,featureinstanceid,pro
> >
> visioningerrorstatus,provisioningstate,provisioningmsg,templatename,template
> >
> version,holdertablename,holderid,provisioningid,devicetable,deviceid,cardtab
> > le,cardid,peerholdertablename,peerholderid
> > > ) VALUES ('ttt','ttt','ttt4','ttt',' ',0,2,null,'ttt','
> > > ','t_iprouteinfo',2,'406','t_btsrouter',2,'t_btsrouter',2,null,null);
> > >       connection,user_id,table_name,lock_type,lock_name
> > >       298937754,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> > > 298937754,'mwcuser','mwcuser.t_servicefeatureinfo','E',3612067495938
> > > 298937754,'mwcuser','mwcuser.t_servicefeatureinfo','E',3612067495938
> > >       1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> > >
> > >
> >
> 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPA0005',2263447764998
> > >
> > >
> >
> 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','EPA0005',3612067495936
> > >
> > >
> >
> 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','EPA0005',3612067495937
> > >
> > >
> > >
> >
> Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,No
> > deAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
> > >       1876569969,'jchlin-1','mwcuser',0,'2003-02-10
> > >
> >
> 16:59:23.097',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',5937,0,0,0,
> > 47
> > >       298937754,'jchlin-2','mwcuser',0,'2003-02-10
> > >
> >
> 16:59:04.094',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',9375,0,1876
> > 569969,2263447764998,0
> > >
> > > -- update 525's immediate next row  from jchlin-2 got blocked
> > > update t_servicefeatureinfo set servicefeature = 'ttt3' where id=526;
> > >       connection,user_id,table_name,lock_type,lock_name
> > >       298937754,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> > > 298937754,'mwcuser','mwcuser.t_servicefeatureinfo','E',3534758084621
> > >
> >
> 298937754,'mwcuser','mwcuser.t_servicefeatureinfo','SPA0005',3573412790290
> > >       1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> > >
> > >
> >
> 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPA0005',2263447764998
> > >
> > >
> >
> 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','EPA0005',3612067495936
> > >
> > >
> >
> 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','EPA0005',3612067495937
> > >
> > >
> > >
> >
> Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,No
> > deAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
> > >       1876569969,'jchlin-1','mwcuser',0,'2003-02-10
> > >
> >
> 16:59:57.368',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',5758,0,0,0,
> > 56
> > >       298937754,'jchlin-2','mwcuser',0,'2003-02-10
> > >
> >
> 16:59:41.645',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',6768,0,1876
> > 569969,2263447764998,0
> > >
> > >
> > > 6. Update the normal column on the last row, the previous row is locked
> if
> > > its unique constrainted column is updated.
> > > -- update the normal column on the last row from jchlin-1
> > > update t_servicefeatureinfo set provisioningstate = 56 where id=526
> > >       connection,user_id,table_name,lock_type,lock_name
> > >       1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> > >
> > 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','E',3534758084621
> > >
> > >
> > >
> >
> Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,No
> > deAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
> > >       1876569969,'jchlin-1','mwcuser',0,'2003-02-10
> > >
> >
> 17:01:32.517',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',5092,0,0,0,
> > 3
> > >       298937754,'jchlin-2','mwcuser',0,'2003-02-10
> > > 17:00:36.110',,,'STMT_DROP','TCPIP','128.107.133.207',3297,0,0,0,0
> > >
> > > -- update the row in front of the last row  from jchlin-2 got blocked
> > > update t_servicefeatureinfo set servicefeature = 'ttt3' where id=525;
> > >       connection,user_id,table_name,lock_type,lock_name
> > >       298937754,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> > > 298937754,'mwcuser','mwcuser.t_servicefeatureinfo','E',3534758084620
> > >       1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','SPT',
> > >
> > 1876569969,'mwcuser','mwcuser.t_servicefeatureinfo','E',3534758084621
> > >
> > >
> > >
> >
> Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,No
> > deAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
> > >       1876569969,'jchlin-1','mwcuser',0,'2003-02-10
> > >
> >
> 17:02:15.051',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',5599,0,0,0,
> > 9
> > >       298937754,'jchlin-2','mwcuser',0,'2003-02-10
> > >
> >
> 17:01:57.254',,,'STMT_EXECUTE_ANY_IMM','TCPIP','128.107.133.207',7652,0,1876
> > 569969,3534758084621,0
> > >
> > > Jon
> > >
> > > "Chris Keating" <Fight_Spam_keating@iAnywhere.com> wrote in message
> > > news:<oEyeLiQ0CHA.198@forums.sybase.com>...
> > > > Call sa_locks when running each of your tests and provide the
> results. I
> > > > suspect that you will find phantom locks.
> > > >
> > > > --
> > > >
> > > > Chris Keating
> > > > Sybase Adaptive Server Anywhere Professional Version 8
> > > > iAnywhere Solutions  http://www.iAnywhere.com
> > > >
> > > > ** Please only post to the newsgroup
> > > >
> > > > ** Whitepapers can be found at http://www.iAnywhere.com/developer
> > > > ** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
> > > > ** Use CaseXpress to report bugs http://casexpress.sybase.com
> > > >
> > > > <Jonathan_Lin> wrote in message
> > > > news:A6201C20A16060B3002DA03B85256CC9.0065CC3285256CC8@webforums...
> > > > > I'm running the test under isolation level 0. So, why doesn't it
> have
> > > any
> > > > > different locking behavior from the higher isolation levels? I
> thought
> > > > that
> > > > > the lower isolation level may give us less restrictive locking.
> Also,
> > > the
> > > > > insertion only from different db connection in my test still works.
> > > It's
> > > > > the following update operations are causing the locking problem.
> > > > >
> > > > > Please note that the test #1 and test #2 are tested with update
> > > operations
> > > > > only without inserting new rows. And the locking behavior for the
> > first
> > > > > update and second update are different.
> > > > >
> > > > > Also, does this mean that ASA doesn't support the true row locking?
> > > What I
> > > > > meant 'true row locking' means that operations on the row only lock
> > the
> > > > row
> > > > > itself without affecting other rows.
> > > > >
> > > > > Does the ASE 12.5 have the same behavior as ASA? Or does ASE
> support
> > > the
> > > > > true row locking?
> > > > >
> > > > > Thanks for the help.
> > > > >
> > > > > Jon
> > > > >
> > > > > "Chris Keating" <Spam_Free_keating@iAnywhere.com> wrote in message
> > > > > news:<kaKB3UG0CHA.198@forums.sybase.com>...
> > > > > >  This is most likely neither a misconfiguration, bug, or design
> > > problem
> > > > > in
> > > > > > ASA. I recommend that you read the documentation related to locks
> --
> > > > > phantom
> > > > > > locks in particular.
> > > > > >
> > > > > >
> > > > > > <Jonathan_Lin> wrote in message
> > > > > >
> news:8ED1B73FCBD3DE4200783E7B85256CC7.00230E4B85256CC7@webforums...
> > > > > > > Here are the more details about the test results on the row
> level
> > > > > lockings
> > > > > > > I have done:
> > > > > > >
> > > > > > > 1. Update unique constrainted column the first time, only one
> of
> > > the
> > > > > > > immediate previous or next row is locked randomly.
> > > > > > > 2. Update unique constrainted column the second time, the whole
> > > table
> > > > > is
> > > > > > > locked.
> > > > > > > 3. Insert a new row and update the row on unique constrainted
> > > columns,
> > > > > the
> > > > > > > whole table is locked.
> > > > > > > 4. Insert two new rows and update unique constrainted column of
> > the
> > > > > first
> > > > > > > new row the first time, no additional lock is found.
> > > > > > > 5. Insert two new rows and update unique constrainted column of
> > the
> > > > > first
> > > > > > > new row the second time, the whole table is locked.
> > > > > > > 6. Update the normal column on the last row, the previous row
> is
> > > > locked
> > > > > if
> > > > > > > its unique constrainted column is updated.
> > > > > > >
> > > > > > > Is this caused by a mis-configuration, a bug, or the
> fundamental
> > > > design
> > > > > > > problem of ANA? Any helps on this is very much appreciated.
> > Thanks.
> > > > > > >
> > > > > > > Jon
> > > > > >
> > > > > >
> > > >
> > > >
> >
> >


Robert Waywell Posted on 2003-02-10 14:19:41.0Z
From: "Robert Waywell" <rwaywell@ianywhere.com>
References: <4D74442FB667C556001EC7AA85256CC7.001EC7B885256CC7@webforums> <8ED1B73FCBD3DE4200783E7B85256CC7.00230E4B85256CC7@webforums> <kaKB3UG0CHA.198@forums.sybase.com> <A6201C20A16060B3002DA03B85256CC9.0065CC3285256CC8@webforums> <oEyeLiQ0CHA.198@forums.sybase.com>
Subject: Re: Does ASA 8.01 or 7.3 support true row locking?
Date: Mon, 10 Feb 2003 09:19:41 -0500
Lines: 124
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <q33DmIR0CHA.176@forums.sybase.com>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: 172.31.143.74
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub ianywhere.public.general:154
Article PK: 1975

As Chris suggested, review the docs first. They do a pretty good job
covering the locking and then we will be in a better position to fill in any
remaining blanks. In particular the docs will explain why you can see a
range of values locked.

One thing to keep in mind is that Isolation Level 0 still requires the use
of Write locks. Your UPDATE operations modified the records and created
Write locks.

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

"Chris Keating" <Fight_Spam_keating@iAnywhere.com> wrote in message
news:oEyeLiQ0CHA.198@forums.sybase.com...
> Call sa_locks when running each of your tests and provide the results. I
> suspect that you will find phantom locks.
>
> --
>
> Chris Keating
> Sybase Adaptive Server Anywhere Professional Version 8
> iAnywhere Solutions http://www.iAnywhere.com
>
> ** Please only post to the newsgroup
>
> ** Whitepapers can be found at http://www.iAnywhere.com/developer
> ** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
> ** Use CaseXpress to report bugs http://casexpress.sybase.com
>
> <Jonathan_Lin> wrote in message
> news:A6201C20A16060B3002DA03B85256CC9.0065CC3285256CC8@webforums...
> > I'm running the test under isolation level 0. So, why doesn't it have
any
> > different locking behavior from the higher isolation levels? I thought
> that
> > the lower isolation level may give us less restrictive locking. Also,
the
> > insertion only from different db connection in my test still works. It's
> > the following update operations are causing the locking problem.
> >
> > Please note that the test #1 and test #2 are tested with update
operations
> > only without inserting new rows. And the locking behavior for the first
> > update and second update are different.
> >
> > Also, does this mean that ASA doesn't support the true row locking? What
I
> > meant 'true row locking' means that operations on the row only lock the
> row
> > itself without affecting other rows.
> >
> > Does the ASE 12.5 have the same behavior as ASA? Or does ASE support the
> > true row locking?
> >
> > Thanks for the help.
> >
> > Jon
> >
> > "Chris Keating" <Spam_Free_keating@iAnywhere.com> wrote in message
> > news:<kaKB3UG0CHA.198@forums.sybase.com>...
> > > This is most likely neither a misconfiguration, bug, or design
problem
> > in
> > > ASA. I recommend that you read the documentation related to locks --
> > phantom
> > > locks in particular.
> > >
> > >
> > > <Jonathan_Lin> wrote in message
> > > news:8ED1B73FCBD3DE4200783E7B85256CC7.00230E4B85256CC7@webforums...
> > > > Here are the more details about the test results on the row level
> > lockings
> > > > I have done:
> > > >
> > > > 1. Update unique constrainted column the first time, only one of the
> > > > immediate previous or next row is locked randomly.
> > > > 2. Update unique constrainted column the second time, the whole
table
> > is
> > > > locked.
> > > > 3. Insert a new row and update the row on unique constrainted
columns,
> > the
> > > > whole table is locked.
> > > > 4. Insert two new rows and update unique constrainted column of the
> > first
> > > > new row the first time, no additional lock is found.
> > > > 5. Insert two new rows and update unique constrainted column of the
> > first
> > > > new row the second time, the whole table is locked.
> > > > 6. Update the normal column on the last row, the previous row is
> locked
> > if
> > > > its unique constrainted column is updated.
> > > >
> > > > Is this caused by a mis-configuration, a bug, or the fundamental
> design
> > > > problem of ANA? Any helps on this is very much appreciated. Thanks.
> > > >
> > > > Jon
> > >
> > >
>
>


Jonathan_Lin Posted on 2003-02-11 02:09:38.0Z
From: Jonathan_Lin
Date: Mon, 10 Feb 2003 21:09:38 -0500
Newsgroups: ianywhere.public.general
Subject: Re: Does ASA 8.01 or 7.3 support true row locking?
Message-ID: <526EDFEF5248AB74000BDE3885256CCA.0054962785256CC9@webforums>
References: <4D74442FB667C556001EC7AA85256CC7.001EC7B885256CC7@webforums> <8ED1B73FCBD3DE4200783E7B85256CC7.00230E4B85256CC7@webforums> <kaKB3UG0CHA.198@forums.sybase.com> <A6201C20A16060B3002DA03B85256CC9.0065CC3285256CC8@webforums> <oEyeLiQ0CHA.198@forums.sybase.com> <q33DmIR0CHA.176@forums.sybase.com>
Lines: 139
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:149
Article PK: 1970

Hi, Robert,

We do look into the document. But it doesn't seem to be able to explain the
behavior we have observed. For example, when doing UPDATE operation, it
should acquire write lock on the row being updated. But actually, other
rows get to be locked as well. And the first update and the second update
also behave differently.

Moreover, the INSERT operations coupled with UPDATE operations result in
different locking depending on different sequences of operations.

Jon

"Robert Waywell" <rwaywell@ianywhere.com> wrote in message
news:<q33DmIR0CHA.176@forums.sybase.com>...
> As Chris suggested, review the docs first. They do a pretty good job
> covering the locking and then we will be in a better position to fill in
any
> remaining blanks. In particular the docs will explain why you can see a
> range of values locked.
>
> One thing to keep in mind is that Isolation Level 0 still requires the
use
> of Write locks. Your UPDATE operations modified the records and created
> Write locks.
>
> --
> -----------------------------------------------
> Robert Waywell
> Sybase Adaptive Server Anywhere Developer - Version 8
> Sybase Certified Professional
>
> Sybase's iAnywhere Solutions
>
> Please respond ONLY to newsgroup
>
> EBF's and Patches: http://downloads.sybase.com
> choose SQL Anywhere Studio >> change 'time frame' to all
>
> To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm
>
> SQL Anywhere Studio Supported Platforms and Support Status
> http://my.sybase.com/detail?id=1002288
>
> Whitepapers, TechDocs, and bug fixes are all available through the
iAnywhere
> Developer Community at www.ianywhere.com/developer
>
> "Chris Keating" <Fight_Spam_keating@iAnywhere.com> wrote in message
> news:oEyeLiQ0CHA.198@forums.sybase.com...
> > Call sa_locks when running each of your tests and provide the results.
I
> > suspect that you will find phantom locks.
> >
> > --
> >
> > Chris Keating
> > Sybase Adaptive Server Anywhere Professional Version 8
> > iAnywhere Solutions http://www.iAnywhere.com
> >
> > ** Please only post to the newsgroup
> >
> > ** Whitepapers can be found at http://www.iAnywhere.com/developer
> > ** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
> > ** Use CaseXpress to report bugs http://casexpress.sybase.com
> >
> > <Jonathan_Lin> wrote in message
> > news:A6201C20A16060B3002DA03B85256CC9.0065CC3285256CC8@webforums...
> > > I'm running the test under isolation level 0. So, why doesn't it have
> any
> > > different locking behavior from the higher isolation levels? I
thought
> > that
> > > the lower isolation level may give us less restrictive locking. Also,
> the
> > > insertion only from different db connection in my test still works.
It's
> > > the following update operations are causing the locking problem.
> > >
> > > Please note that the test #1 and test #2 are tested with update
> operations
> > > only without inserting new rows. And the locking behavior for the
first
> > > update and second update are different.
> > >
> > > Also, does this mean that ASA doesn't support the true row locking?
What
> I
> > > meant 'true row locking' means that operations on the row only lock
the
> > row
> > > itself without affecting other rows.
> > >
> > > Does the ASE 12.5 have the same behavior as ASA? Or does ASE support
the
> > > true row locking?
> > >
> > > Thanks for the help.
> > >
> > > Jon
> > >
> > > "Chris Keating" <Spam_Free_keating@iAnywhere.com> wrote in message
> > > news:<kaKB3UG0CHA.198@forums.sybase.com>...
> > > > This is most likely neither a misconfiguration, bug, or design
> problem
> > > in
> > > > ASA. I recommend that you read the documentation related to locks
--
> > > phantom
> > > > locks in particular.
> > > >
> > > >
> > > > <Jonathan_Lin> wrote in message
> > > > news:8ED1B73FCBD3DE4200783E7B85256CC7.00230E4B85256CC7@webforums...
> > > > > Here are the more details about the test results on the row level
> > > lockings
> > > > > I have done:
> > > > >
> > > > > 1. Update unique constrainted column the first time, only one of
the
> > > > > immediate previous or next row is locked randomly.
> > > > > 2. Update unique constrainted column the second time, the whole
> table
> > > is
> > > > > locked.
> > > > > 3. Insert a new row and update the row on unique constrainted
> columns,
> > > the
> > > > > whole table is locked.
> > > > > 4. Insert two new rows and update unique constrainted column of
the
> > > first
> > > > > new row the first time, no additional lock is found.
> > > > > 5. Insert two new rows and update unique constrainted column of
the
> > > first
> > > > > new row the second time, the whole table is locked.
> > > > > 6. Update the normal column on the last row, the previous row is
> > locked
> > > if
> > > > > its unique constrainted column is updated.
> > > > >
> > > > > Is this caused by a mis-configuration, a bug, or the fundamental
> > design
> > > > > problem of ANA? Any helps on this is very much appreciated.
Thanks.
> > > > >
> > > > > Jon
> > > >
> > > >
> >
> >
>
>


Robert Waywell Posted on 2003-02-11 14:03:27.0Z
From: "Robert Waywell" <rwaywell@ianywhere.com>
References: <4D74442FB667C556001EC7AA85256CC7.001EC7B885256CC7@webforums> <8ED1B73FCBD3DE4200783E7B85256CC7.00230E4B85256CC7@webforums> <kaKB3UG0CHA.198@forums.sybase.com> <A6201C20A16060B3002DA03B85256CC9.0065CC3285256CC8@webforums> <oEyeLiQ0CHA.198@forums.sybase.com> <q33DmIR0CHA.176@forums.sybase.com> <526EDFEF5248AB74000BDE3885256CCA.0054962785256CC9@webforums>
Subject: Re: Does ASA 8.01 or 7.3 support true row locking?
Date: Tue, 11 Feb 2003 09:03:27 -0500
Lines: 202
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <AURGNkd0CHA.59@forums.sybase.com>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: 172.31.143.74
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub ianywhere.public.general:148
Article PK: 1969

Adaptive Server Anywhere SQL User's Guide
4. Using Transactions and Isolation Levels
How locking works

Objects that can be locked
...
Insertion points between rows Transactions typically scan rows using the
ordering imposed by an index, or scan rows sequentially. In either case, a
lock can be placed on the scan position. For example, placing a lock in an
index can prevent another transaction from inserting a row with a specific
value or range of values.

Note the reference to a "range of values".

Yes the order of operations can affect which transactions get blocked.
This would be due to the INSERT or UPDATE altering the range locations in
the index.

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

<Jonathan_Lin> wrote in message
news:526EDFEF5248AB74000BDE3885256CCA.0054962785256CC9@webforums...
> Hi, Robert,
>
> We do look into the document. But it doesn't seem to be able to explain
the
> behavior we have observed. For example, when doing UPDATE operation, it
> should acquire write lock on the row being updated. But actually, other
> rows get to be locked as well. And the first update and the second update
> also behave differently.
>
> Moreover, the INSERT operations coupled with UPDATE operations result in
> different locking depending on different sequences of operations.
>
> Jon
>
> "Robert Waywell" <rwaywell@ianywhere.com> wrote in message
> news:<q33DmIR0CHA.176@forums.sybase.com>...
> > As Chris suggested, review the docs first. They do a pretty good job
> > covering the locking and then we will be in a better position to fill in
> any
> > remaining blanks. In particular the docs will explain why you can see a
> > range of values locked.
> >
> > One thing to keep in mind is that Isolation Level 0 still requires the
> use
> > of Write locks. Your UPDATE operations modified the records and created
> > Write locks.
> >
> > --
> > -----------------------------------------------
> > Robert Waywell
> > Sybase Adaptive Server Anywhere Developer - Version 8
> > Sybase Certified Professional
> >
> > Sybase's iAnywhere Solutions
> >
> > Please respond ONLY to newsgroup
> >
> > EBF's and Patches: http://downloads.sybase.com
> > choose SQL Anywhere Studio >> change 'time frame' to all
> >
> > To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm
> >
> > SQL Anywhere Studio Supported Platforms and Support Status
> > http://my.sybase.com/detail?id=1002288
> >
> > Whitepapers, TechDocs, and bug fixes are all available through the
> iAnywhere
> > Developer Community at www.ianywhere.com/developer
> >
> > "Chris Keating" <Fight_Spam_keating@iAnywhere.com> wrote in message
> > news:oEyeLiQ0CHA.198@forums.sybase.com...
> > > Call sa_locks when running each of your tests and provide the results.
> I
> > > suspect that you will find phantom locks.
> > >
> > > --
> > >
> > > Chris Keating
> > > Sybase Adaptive Server Anywhere Professional Version 8
> > > iAnywhere Solutions http://www.iAnywhere.com
> > >
> > > ** Please only post to the newsgroup
> > >
> > > ** Whitepapers can be found at http://www.iAnywhere.com/developer
> > > ** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
> > > ** Use CaseXpress to report bugs http://casexpress.sybase.com
> > >
> > > <Jonathan_Lin> wrote in message
> > > news:A6201C20A16060B3002DA03B85256CC9.0065CC3285256CC8@webforums...
> > > > I'm running the test under isolation level 0. So, why doesn't it
have
> > any
> > > > different locking behavior from the higher isolation levels? I
> thought
> > > that
> > > > the lower isolation level may give us less restrictive locking.
Also,
> > the
> > > > insertion only from different db connection in my test still works.
> It's
> > > > the following update operations are causing the locking problem.
> > > >
> > > > Please note that the test #1 and test #2 are tested with update
> > operations
> > > > only without inserting new rows. And the locking behavior for the
> first
> > > > update and second update are different.
> > > >
> > > > Also, does this mean that ASA doesn't support the true row locking?
> What
> > I
> > > > meant 'true row locking' means that operations on the row only lock
> the
> > > row
> > > > itself without affecting other rows.
> > > >
> > > > Does the ASE 12.5 have the same behavior as ASA? Or does ASE support
> the
> > > > true row locking?
> > > >
> > > > Thanks for the help.
> > > >
> > > > Jon
> > > >
> > > > "Chris Keating" <Spam_Free_keating@iAnywhere.com> wrote in message
> > > > news:<kaKB3UG0CHA.198@forums.sybase.com>...
> > > > > This is most likely neither a misconfiguration, bug, or design
> > problem
> > > > in
> > > > > ASA. I recommend that you read the documentation related to locks
> --
> > > > phantom
> > > > > locks in particular.
> > > > >
> > > > >
> > > > > <Jonathan_Lin> wrote in message
> > > > >
news:8ED1B73FCBD3DE4200783E7B85256CC7.00230E4B85256CC7@webforums...
> > > > > > Here are the more details about the test results on the row
level
> > > > lockings
> > > > > > I have done:
> > > > > >
> > > > > > 1. Update unique constrainted column the first time, only one of
> the
> > > > > > immediate previous or next row is locked randomly.
> > > > > > 2. Update unique constrainted column the second time, the whole
> > table
> > > > is
> > > > > > locked.
> > > > > > 3. Insert a new row and update the row on unique constrainted
> > columns,
> > > > the
> > > > > > whole table is locked.
> > > > > > 4. Insert two new rows and update unique constrainted column of
> the
> > > > first
> > > > > > new row the first time, no additional lock is found.
> > > > > > 5. Insert two new rows and update unique constrainted column of
> the
> > > > first
> > > > > > new row the second time, the whole table is locked.
> > > > > > 6. Update the normal column on the last row, the previous row is
> > > locked
> > > > if
> > > > > > its unique constrainted column is updated.
> > > > > >
> > > > > > Is this caused by a mis-configuration, a bug, or the fundamental
> > > design
> > > > > > problem of ANA? Any helps on this is very much appreciated.
> Thanks.
> > > > > >
> > > > > > Jon
> > > > >
> > > > >
> > >
> > >
> >
> >


Jonathan_Lin Posted on 2003-02-12 01:53:04.0Z
From: Jonathan_Lin
Date: Tue, 11 Feb 2003 20:53:04 -0500
Newsgroups: ianywhere.public.general
Subject: Re: Does ASA 8.01 or 7.3 support true row locking?
Message-ID: <A66213BEDBC6F582000A5A1785256CCB.00521D5C85256CCA@webforums>
References: <4D74442FB667C556001EC7AA85256CC7.001EC7B885256CC7@webforums> <8ED1B73FCBD3DE4200783E7B85256CC7.00230E4B85256CC7@webforums> <kaKB3UG0CHA.198@forums.sybase.com> <A6201C20A16060B3002DA03B85256CC9.0065CC3285256CC8@webforums> <oEyeLiQ0CHA.198@forums.sybase.com> <q33DmIR0CHA.176@forums.sybase.com> <526EDFEF5248AB74000BDE3885256CCA.0054962785256CC9@webforums> <AURGNkd0CHA.59@forums.sybase.com>
Lines: 212
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:143
Article PK: 1964

Hi, Robert,

Inserting a new row from different connections at the same time worked fine
without doing a commit. My test result is that the UPDATE operations caused
the unexpected locking.

Jon

"Robert Waywell" <rwaywell@ianywhere.com> wrote in message
news:<AURGNkd0CHA.59@forums.sybase.com>...
> Adaptive Server Anywhere SQL User's Guide
> 4. Using Transactions and Isolation Levels
> How locking works
>
> Objects that can be locked
> ...
> Insertion points between rows Transactions typically scan rows using
the
> ordering imposed by an index, or scan rows sequentially. In either case,
a
> lock can be placed on the scan position. For example, placing a lock in
an
> index can prevent another transaction from inserting a row with a
specific
> value or range of values.
>
> Note the reference to a "range of values".
>
> Yes the order of operations can affect which transactions get
blocked.
> This would be due to the INSERT or UPDATE altering the range locations in
> the index.
>
> --
> -----------------------------------------------
> Robert Waywell
> Sybase Adaptive Server Anywhere Developer - Version 8
> Sybase Certified Professional
>
> Sybase's iAnywhere Solutions
>
> Please respond ONLY to newsgroup
>
> EBF's and Patches: http://downloads.sybase.com
> choose SQL Anywhere Studio >> change 'time frame' to all
>
> To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm
>
> SQL Anywhere Studio Supported Platforms and Support Status
> http://my.sybase.com/detail?id=1002288
>
> Whitepapers, TechDocs, and bug fixes are all available through the
iAnywhere
> Developer Community at www.ianywhere.com/developer
>
> <Jonathan_Lin> wrote in message
> news:526EDFEF5248AB74000BDE3885256CCA.0054962785256CC9@webforums...
> > Hi, Robert,
> >
> > We do look into the document. But it doesn't seem to be able to explain
> the
> > behavior we have observed. For example, when doing UPDATE operation, it
> > should acquire write lock on the row being updated. But actually, other
> > rows get to be locked as well. And the first update and the second
update
> > also behave differently.
> >
> > Moreover, the INSERT operations coupled with UPDATE operations result
in
> > different locking depending on different sequences of operations.
> >
> > Jon
> >
> > "Robert Waywell" <rwaywell@ianywhere.com> wrote in message
> > news:<q33DmIR0CHA.176@forums.sybase.com>...
> > > As Chris suggested, review the docs first. They do a pretty good job
> > > covering the locking and then we will be in a better position to fill
in
> > any
> > > remaining blanks. In particular the docs will explain why you can see
a
> > > range of values locked.
> > >
> > > One thing to keep in mind is that Isolation Level 0 still requires
the
> > use
> > > of Write locks. Your UPDATE operations modified the records and
created
> > > Write locks.
> > >
> > > --
> > > -----------------------------------------------
> > > Robert Waywell
> > > Sybase Adaptive Server Anywhere Developer - Version 8
> > > Sybase Certified Professional
> > >
> > > Sybase's iAnywhere Solutions
> > >
> > > Please respond ONLY to newsgroup
> > >
> > > EBF's and Patches: http://downloads.sybase.com
> > > choose SQL Anywhere Studio >> change 'time frame' to all
> > >
> > > To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm
> > >
> > > SQL Anywhere Studio Supported Platforms and Support Status
> > > http://my.sybase.com/detail?id=1002288
> > >
> > > Whitepapers, TechDocs, and bug fixes are all available through the
> > iAnywhere
> > > Developer Community at www.ianywhere.com/developer
> > >
> > > "Chris Keating" <Fight_Spam_keating@iAnywhere.com> wrote in message
> > > news:oEyeLiQ0CHA.198@forums.sybase.com...
> > > > Call sa_locks when running each of your tests and provide the
results.
> > I
> > > > suspect that you will find phantom locks.
> > > >
> > > > --
> > > >
> > > > Chris Keating
> > > > Sybase Adaptive Server Anywhere Professional Version 8
> > > > iAnywhere Solutions http://www.iAnywhere.com
> > > >
> > > > ** Please only post to the newsgroup
> > > >
> > > > ** Whitepapers can be found at http://www.iAnywhere.com/developer
> > > > ** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
> > > > ** Use CaseXpress to report bugs http://casexpress.sybase.com
> > > >
> > > > <Jonathan_Lin> wrote in message
> > > > news:A6201C20A16060B3002DA03B85256CC9.0065CC3285256CC8@webforums...
> > > > > I'm running the test under isolation level 0. So, why doesn't it
> have
> > > any
> > > > > different locking behavior from the higher isolation levels? I
> > thought
> > > > that
> > > > > the lower isolation level may give us less restrictive locking.
> Also,
> > > the
> > > > > insertion only from different db connection in my test still
works.
> > It's
> > > > > the following update operations are causing the locking problem.
> > > > >
> > > > > Please note that the test #1 and test #2 are tested with update
> > > operations
> > > > > only without inserting new rows. And the locking behavior for the
> > first
> > > > > update and second update are different.
> > > > >
> > > > > Also, does this mean that ASA doesn't support the true row
locking?
> > What
> > > I
> > > > > meant 'true row locking' means that operations on the row only
lock
> > the
> > > > row
> > > > > itself without affecting other rows.
> > > > >
> > > > > Does the ASE 12.5 have the same behavior as ASA? Or does ASE
support
> > the
> > > > > true row locking?
> > > > >
> > > > > Thanks for the help.
> > > > >
> > > > > Jon
> > > > >
> > > > > "Chris Keating" <Spam_Free_keating@iAnywhere.com> wrote in
message
> > > > > news:<kaKB3UG0CHA.198@forums.sybase.com>...
> > > > > > This is most likely neither a misconfiguration, bug, or design
> > > problem
> > > > > in
> > > > > > ASA. I recommend that you read the documentation related to
locks
> > --
> > > > > phantom
> > > > > > locks in particular.
> > > > > >
> > > > > >
> > > > > > <Jonathan_Lin> wrote in message
> > > > > >
> news:8ED1B73FCBD3DE4200783E7B85256CC7.00230E4B85256CC7@webforums...
> > > > > > > Here are the more details about the test results on the row
> level
> > > > > lockings
> > > > > > > I have done:
> > > > > > >
> > > > > > > 1. Update unique constrainted column the first time, only one
of
> > the
> > > > > > > immediate previous or next row is locked randomly.
> > > > > > > 2. Update unique constrainted column the second time, the
whole
> > > table
> > > > > is
> > > > > > > locked.
> > > > > > > 3. Insert a new row and update the row on unique constrainted
> > > columns,
> > > > > the
> > > > > > > whole table is locked.
> > > > > > > 4. Insert two new rows and update unique constrainted column
of
> > the
> > > > > first
> > > > > > > new row the first time, no additional lock is found.
> > > > > > > 5. Insert two new rows and update unique constrainted column
of
> > the
> > > > > first
> > > > > > > new row the second time, the whole table is locked.
> > > > > > > 6. Update the normal column on the last row, the previous row
is
> > > > locked
> > > > > if
> > > > > > > its unique constrainted column is updated.
> > > > > > >
> > > > > > > Is this caused by a mis-configuration, a bug, or the
fundamental
> > > > design
> > > > > > > problem of ANA? Any helps on this is very much appreciated.
> > Thanks.
> > > > > > >
> > > > > > > Jon
> > > > > >
> > > > > >
> > > >
> > > >
> > >
> > >
>
>