backup hangs until shedule restart

[foobar2devnull]

Windows 2003 R2 SP2 - TSM Client 6.2.2.2 - TDP MS SQL 5.5.4.2

Hello,

I'm having a problem I just can not figure out. Maybe one of you faced the same problem?

The system is a windows box with MS SQL running. See above for details

If I run a backup manually, it will work.

If the backup is run through the scheduler, the system backup will fail with an error 12:

[...]
04/04/2011 19:04:50 ANS0106E Message index not found for message 1688.
04/04/2011 19:04:50 ANS0106E Message index not found for message 1688.
04/04/2011 19:04:50 ANS0106E Message index not found for message 1688.
04/04/2011 19:04:55 ANS0361I DIAG: Mutex lock failed (abandoned): 122.
04/04/2011 19:04:55 ANS0361I DIAG: Acquire Mutex failed: invalid mutex.
04/04/2011 19:04:55 ANS9999E GlobalRC.cpp(206): Unable to acquire global rc mutex

04/04/2011 19:05:02 ANS1512E Scheduled event 'INC_1900' failed.  Return code = 12.

Then the TDP will run and succeed. The next day however, the system backup will simply hang until I restart the scheduler:

Scheduled Start          Actual Start             Schedule Name     Node Name         Status   
--------------------     --------------------     -------------     -------------     ---------
04/04/2011 19:00:00      04/04/2011 19:00:31      INC_1900          SQL01             Failed 12
04/04/2011 20:00:00      04/04/2011 20:00:14      SQL_2000_FULL     SQL01             Completed
04/05/2011 19:00:00      04/05/2011 19:00:36      INC_1900          SQL01             In Progr-
                                                                                       ess     
04/05/2011 20:00:00                               SQL_2000_FULL     SQL01             Missed   
04/06/2011 19:00:00                               INC_1900          SQL01             Missed   
04/06/2011 20:00:00                               SQL_2000_FULL     SQL01             Missed   
04/07/2011 19:00:00                               INC_1900          SQL01             Missed   
04/07/2011 20:00:00                               SQL_2000_FULL     SQL01             Missed

Has anyone experienced anything like this?

[moon-buddy]

This link explains the error ANS0361I: http://publib.boulder.ibm.com/infoce.../msgs5307.html

A call to IBM is in order as this maybe a bug

[fazil]

Check the DSM.opt file

MANAGEDSERVICES

[fazil]

Check the DSM.opt file and check the managed service and session inititation option

MANAGEDSERVICES WEBCLIENT or SCHEDULER

SESSIONINTITATION CLIENT OR SERVER

[foobar2devnull]

Sorry for the late reply but I was answering when my box went down... then got side tracked on other issues

Thank you both for your feedback.

This link explains the error ANS0361I: http://publib.boulder.ibm.com/infoce.../msgs5307.html

A call to IBM is in order as this maybe a bug

Hi moon-buddy,

This is looking more and more like a system problem. System state backups are now failing too.

If I do find a solution other than the re-installation of the box, I'll post it.

Thanks for your help.

Check the DSM.opt file and check the managed service and session inititation option

MANAGEDSERVICES WEBCLIENT or SCHEDULER

SESSIONINTITATION CLIENT OR SERVER

Hi Fazil,

Neither of these settings are in my 'dsm.opt' file (see bellow) but I suspect the defaults are 'MANAGEDSERVICES SCHEDULER' and 'SESSIONINTITATION SERVER'. The dsm.opt file bellow is the template I use for all my windows boxes.

Commmethod         tcpip
tcpport         1500
TCPCLIENTPORT        31501
TCPSERVERADDRESS     tsmserver.domain.com
NODENAME             sql01
schedmod         prompted
passwordaccess         generate
schedlogname         dsmsched.log
errorlogname         dsmerror.log

SCHEDLOGRETENTION    30 D
ERRORLOGRETENTION    30 D

QUIET

domain all-local -systemstate

exclude *:\...\*.mdf
exclude *:\...\*.ldf

[brianr]

A long shot ... but did you happen to figure out what the issue was?

We had a very similar error recently.