×

Warning message

  • Cisco Support Forums is in Read Only mode while the site is being migrated.
  • Cisco Support Forums is in Read Only mode while the site is being migrated.

cobras import error Error=Timed out waiting for DB lock to free and unable to fetch mailbox details for user in RestoreMailbox on VoiceMessages.cs,

Answered Question
Aug 14th, 2014
User Badges:

Hi 

Just wondering if anyone has had these errors before from a cobras import, 

[Thread 015], [14/08/15 12:24:16], (error) unable to fetch mailbox details for user in RestoreMailbox on VoiceMessages.cs:99bd3ae9-d32b-483b-bce8-ac675e62aea5
[Thread 015], [14/08/15 12:24:36], (error) Could not get lock for database access in FillDataTableBlocking
[Thread 015], [14/08/15 12:24:36], (error) in GetMailboxInfoForUser on VoiceMessages.cs fetching data:Query= 
 Error=Timed out waiting for DB lock to free
[Thread 015], [14/08/15 12:24:36], (error) unable to fetch mailbox details for user in RestoreMailbox on VoiceMessages.cs:270e1c0f-9991-4026-ab25-587701313f8d
[Thread 015], [14/08/15 12:24:56], (error) Could not get lock for database access in FillDataTableBlocking
[Thread 015], [14/08/15 12:24:57], (error) in GetMailboxInfoForUser on VoiceMessages.cs fetching data:Query= 
 Error=Timed out waiting for DB lock to free
[Thread 015], [14/08/15 12:24:57], (error) unable to fetch mailbox details for user in RestoreMailbox on VoiceMessages.cs:e929578d-54d3-40b6-98c7-36a67e032eb4

 

It appears to get stuck on one call handler greeting, I have confirmed CUC accessibilty is still active and the database proxy services are still running.

Any info on the above errors would me much appreciated

Correct Answer by lindborg about 3 years 3 days ago

What version of COBRAS Import are you running?  If you're not at 8.0.57 go out and grab that:

http://www.ciscounitytools.com/Applications/General/COBRAS/COBRAS.html

the lock issue comes up when Informix gets cranky about table locking (happens each time you ask for a new row - for greeting/voice name uploads this happens for each recording added - a new row in the streams table is added to store it) - I added additional timeout and monitor clearing logic in 57 that handles a few scenarios here - another site had a similiar error it and cleared it for them.

if you are running into this on build 57 ping me off list and see about getting me your backup (without messages) I can do a test restore against here with if possible.  lindborg at cisco dot com.

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (1 ratings)
Loading.
Correct Answer
lindborg Fri, 08/15/2014 - 08:16
User Badges:
  • Cisco Employee,

What version of COBRAS Import are you running?  If you're not at 8.0.57 go out and grab that:

http://www.ciscounitytools.com/Applications/General/COBRAS/COBRAS.html

the lock issue comes up when Informix gets cranky about table locking (happens each time you ask for a new row - for greeting/voice name uploads this happens for each recording added - a new row in the streams table is added to store it) - I added additional timeout and monitor clearing logic in 57 that handles a few scenarios here - another site had a similiar error it and cleared it for them.

if you are running into this on build 57 ping me off list and see about getting me your backup (without messages) I can do a test restore against here with if possible.  lindborg at cisco dot com.

David Keogh Tue, 08/26/2014 - 01:42
User Badges:

Thanks lindborg 

Would have got back to you sooner, yes I was using 8.0.57, I ran it again twice then I realized i was working on a remote machine over a VPN that seemed to cause issues, I stopped that and used a local machine which worked normally.  

lindborg Mon, 12/08/2014 - 19:11
User Badges:
  • Cisco Employee,

59 has the same code 57 does - all my tools are "Forward only" in that respect (i.e. I don't "branch" tools and do separate code base changes on different lines).  The same additional checks, timeouts and lock clearing.  To be clear it's the ODBC driver from IBM that's throwing the error - my timeouts and clearing mechanisms are merely a way to try and mitigate that behavior on record locking (Informix has some maddening behavior in that respect).  The VPN issue seems to cause the driver more difficulty than it should, it's not about ping times it doesn't appear - just so you know.

michael.taylor Fri, 12/05/2014 - 06:45
User Badges:

Hello,

I am experiencing identical issues running 8.0.59; and I cannot locate 8.0.57.  Moreover, my ICMP response times to the CUC server do not exceed 1ms; therefore closing the airgap is not an option.

Please advise.

Regards

 

Actions

This Discussion

Related Content