[cisco-voip] CUCM 6.1.3 DB issues

[Wes Sisk]

db locks will not really show up in trace files.  locks happen every 
time there is any attempted update to database.  debugs for locks in an 
active database would be like 'debug all' on a router that is actively 
routing packets.

With that version you already have the fix for this lock issue.

Other causes:
* a BAT update or AXL update running in the background locking the 
table. BAT appears to be a *major* offender on locking the table. This 
changed with "CSCsx48837     BAT upload error message" so BAT uses dirty 
reads rather than locking the table. Fixed in 7.1(2) and later.
* deleting a user with a large number of devices associated 
"CSCtc52250    Deleting End user Causing DB to go into DDR Block". This 
is doc change only recommending to dissociate devices before deleting user.

/Wes



On Monday, August 02, 2010 6:36:46 PM, <Johnny.Crothers at datacraft.co.nz> 
wrote:
>
> Thanks Wes,
>
>  
>
> Customer is running 6.1.3.3190.-1
>
>  
>
> It sounds similar, We have since noticed that adding Phones takes a 
> large amount of time (Havnt confirmed if this ever actually completes).
>
>  
>
> We have since restarted the entire cluster, ran Utils dbreplication 
> clusterreset, still the same.
>
>  
>
> I'm looking through the trace files now to see if this shed's any 
> light on the subject.
>
>  
>
> Cheers,
>
>  
>
> Johnny
>
>  
>
> *From:* Wes Sisk [mailto:wsisk at cisco.com]
> *Sent:* Tuesday, August 03, 2010 1:16 AM
> *To:* Johnny Crothers at Professional Services at DCNZ-WLG
> *Cc:* cisco-voip at puck.nether.net
> *Subject:* Re: [cisco-voip] CUCM 6.1.3 DB issues
>
>  
>
> Looks like something holding lock in database.  Many things can cause 
> locks but in 6.1.3 several of these track back to :
>
> CSCsx79869    AXL Insert User with mobility takes 30 seconds
>
> /Wes
>
> On Sunday, August 01, 2010 7:01:28 PM, 
> <Johnny.Crothers at datacraft.co.nz> 
> <mailto:Johnny.Crothers at datacraft.co.nz> wrote:
>
> Hi All,
>
>  
>
> Anyone seen this?
>
>  
>
> When searching for a device with criteria we get the following output, 
> when searching without criteria, everything is fine.
>
>  
>
> Tried stopping the replication and resetting, still the same issue. 
> Scheduling a Cluster restart, followed by a dbreplication clusterreset 
> if that fails.
>
>  
>
> Any other idea's?
>
>  
>
>  
>
>  cid:image001.png at 01CB322A.FB123200
>
>  
>
> -------------------- utils dbreplication status --------------------
>
>  
>
> ERROR Code -252 Isam -154 File replcheck.ec Line 5945
>
> select count(*) from 'informix'.callmanager
>
>  
>
> Cannot get system information for table.
>
>  
>
> ISAM error: Lock Timeout Expired
>
> Current Connection:conn1 dbenv:@inzwlgscm001_ccm6_1_3_3190_1
>
> Output is in file 
> cm/trace/dbl/sdi/ReplicationStatus.2010_08_02_10_19_23.out
>
>  
>
> Please use "file view activelog 
> cm/trace/dbl/sdi/ReplicationStatus.2010_08_02_10_19_23.out " command 
> to see the output
>
>  
>
> Cheers,
>
>  
>
> Johnny
>
>  
> *****************************************************************************
> This email and all contents are subject to the following disclaimer:
>  
> http://www.datacraft-asia.com/disclaimer
> *****************************************************************************
>   
>  
> ------------------------------------------------------------------------
>
>
>   
>  
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net <mailto:cisco-voip at puck.nether.net>
> https://puck.nether.net/mailman/listinfo/cisco-voip
>   
>
>  
>
> *****************************************************************************
> This email and all contents are subject to the following disclaimer:
>
> http://www.datacraft-asia.com/disclaimer
> *****************************************************************************
>   

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20100803/3e397df7/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 44951 bytes
Desc: not available
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20100803/3e397df7/attachment.png>