[cisco-voip] Anybody seen DataBase corruption on 5.1.2.X before?

Tue Apr 8 12:15:59 EDT 2008

I am waiting for a change window before I can issue "heavier" commands
:)

> -----Original Message-----
> From: Wes Sisk [mailto:wsisk at cisco.com] 
> Sent: Tuesday, April 08, 2008 3:55 PM
> To: Mayr, Thorsten: IT (LDN)
> Cc: cisco-voip at puck-nether.net
> Subject: Re: [cisco-voip] Anybody seen DataBase corruption on 
> 5.1.2.X before?
> 
> Unfortunately that is not a complete view of things.  
> Informix, as currently configured by cisco, uses asynchronous 
> replication.  Basically just because the Replicate_State is 
> good does not mean the data is actually synchronized.  you 
> need to use 'utils dbreplication status'. this actually 
> compares all rows in all tables to verify data is in sync.
> 
> /Wes
> 
> Thorsten.Mayr at barclayscapital.com wrote: 
> 
> 	On all subscribers:
> 	
> 	admin:show perf query class "Number of Replicates 
> Created and State of
> 	Replication"
> 	==>query class :
> 	
> 	 - Perf class (Number of Replicates Created and State 
> of Replication)
> 	has instances and values:
> 	    ReplicateCount  -> Number of Replicates Created   = 344
> 	    ReplicateCount  -> Replicate_State                = 2
> 	
> 	
> 	However I had a similar issue on a different cluster where the
> 	subscribers where showing a sate of 2, but I could see loads of
> 	notifications requests queued up on a pub. Once this 
> had gone down to 0
> 	various things like the EM service started working...
> 	
> 	
> 	
> 	 
> 	
> 	  
> 
> 		-----Original Message-----
> 		From: Wes Sisk [mailto:wsisk at cisco.com] 
> 		Sent: Tuesday, April 08, 2008 2:11 PM
> 		To: Mayr, Thorsten: IT (LDN)
> 		Cc: cisco-voip at puck.nether.net
> 		Subject: Re: [cisco-voip] Anybody seen DataBase 
> corruption on 
> 		5.1.2.X before?
> 		
> 		Thorsten,
> 		
> 		This sounds like your database replication was 
> not working.  
> 		This would cause subscriber database to contain 
> different 
> 		data that publisher or other subscriber databases.
> 		
> http://www.cisco.com/en/US/customer/products/sw/voicesw/ps556/
> 		products_tech_note09186a00809643e8.shtml
> 		
> 		/Wes
> 		
> 		Thorsten.Mayr at barclayscapital.com wrote:
> 		    
> 
> 			Guys,
> 			
> 			Just wondering if anybody seen anything 
> like that before:
> 			
> 			Phones lose connectivity to subscriber 
> (memory leak - still 
> 			      
> 
> 		trying to 
> 		    
> 
> 			find out what triggered them to 
> failover in the end) and 
> 			      
> 
> 		fail over to 
> 		    
> 
> 			their backup subscriber.
> 			When the phones come back up, their 
> phone button template is 
> 			different, same for the device profiles.
> 			
> 			All devices (UDP's/Phones) that were 
> configured with a particular 
> 			phone button template changed to a 
> different phone button 
> 			      
> 
> 		template....
> 		    
> 
> 			some sort of database corruption must 
> have happened... Anybody ever 
> 			seen the DB on a CUCM 5.1.X morphing in 
> such a way?
> 			
> 			Just interested if there is any 
> knowledge relating to 
> 			      
> 
> 		similar issues 
> 		    
> 
> 			maybe..
> 			
> 			In case, pls let me know
> 			
> 			Thanks
> 			Thorsten
> 			_______________________________________________
> 			
> 			This e-mail may contain information 
> that is confidential, 
> 			      
> 
> 		privileged or otherwise protected from 
> disclosure. If you are 
> 		not an intended recipient of this e-mail, do 
> not duplicate or 
> 		redistribute it by any means. Please delete it and any 
> 		attachments and notify the sender that you have 
> received it 
> 		in error. Unless specifically indicated, this 
> e-mail is not 
> 		an offer to buy or sell or a solicitation to 
> buy or sell any 
> 		securities, investment products or other 
> financial product or 
> 		service, an official confirmation of any 
> transaction, or an 
> 		official statement of Barclays. Any views or opinions 
> 		presented are solely those of the author and do not 
> 		necessarily represent those of Barclays. This e-mail is 
> 		subject to terms available at the following link: 
> 		www.barcap.com/emaildisclaimer. By messaging 
> with Barclays 
> 		you consent to the foregoing.  Barclays Capital is the 
> 		investment banking division of Barclays Bank 
> PLC, a company 
> 		registered in England (number 1026167) with its 
> registered offi!
> 		    
> 
> 			 ce at 1 Churchill Place, London, E14 
> 5HP.  This email may 
> 			      
> 
> 		relate to or be sent from other members of the 
> Barclays Group.
> 		    
> 
> 			_______________________________________________
> 			_______________________________________________
> 			cisco-voip mailing list
> 			cisco-voip at puck.nether.net
> 			
> https://puck.nether.net/mailman/listinfo/cisco-voip
> 			  
> 			      
> 
> 		
> 		    
> 
> 	_______________________________________________
> 	
> 	This e-mail may contain information that is 
> confidential, privileged or otherwise protected from 
> disclosure. If you are not an intended recipient of this 
> e-mail, do not duplicate or redistribute it by any means. 
> Please delete it and any attachments and notify the sender 
> that you have received it in error. Unless specifically 
> indicated, this e-mail is not an offer to buy or sell or a 
> solicitation to buy or sell any securities, investment 
> products or other financial product or service, an official 
> confirmation of any transaction, or an official statement of 
> Barclays. Any views or opinions presented are solely those of 
> the author and do not necessarily represent those of 
> Barclays. This e-mail is subject to terms available at the 
> following link: www.barcap.com/emaildisclaimer. By messaging 
> with Barclays you consent to the foregoing.  Barclays Capital 
> is the investment banking division of Barclay
> 	s Bank PLC, a company registered in England (number 
> 1026167) with its registered office at 1 Churchill Place, 
> London, E14 5HP.  This email may relate to or be sent from 
> other members of the Barclays Group.
> 	_______________________________________________
> 	  
> 
> 
_______________________________________________

This e-mail may contain information that is confidential, privileged or otherwise protected from disclosure. If you are not an intended recipient of this e-mail, do not duplicate or redistribute it by any means. Please delete it and any attachments and notify the sender that you have received it in error. Unless specifically indicated, this e-mail is not an offer to buy or sell or a solicitation to buy or sell any securities, investment products or other financial product or service, an official confirmation of any transaction, or an official statement of Barclays. Any views or opinions presented are solely those of the author and do not necessarily represent those of Barclays. This e-mail is subject to terms available at the following link: www.barcap.com/emaildisclaimer. By messaging with Barclays you consent to the foregoing.  Barclays Capital is the investment banking division of Barclays Bank PLC, a company registered in England (number 1026167) with its registered office at 1 Churchill Place, London, E14 5HP.  This email may relate to or be sent from other members of the Barclays Group.
_______________________________________________