症状

1. When Windows or Windows Server machine restarts, the JIRA service fails to start.
2. The database engine for JIRA is running on the same machine as JIRA.

atlassian-jira.log に次のエラーが返される。

2012-04-11 10:55:04,316 main ERROR      [NoModule] Error getting datasource via DBCP: JdbcDatasourceInfo{uri='jdbc:jtds:sqlserver://localhost:1433/jiradb', driverClassName='net.sourceforge.jtds.jdbc.Driver', username='jiradbuser', password='********', isolationLevel='null', connectionProperties=null, connectionPoolInfo=ConnectionPoolInfo{maxSize=15, minSize=2, maxWait=60000, sleepTime=300000, lifeTime=600000, deadLockMaxWait=600000, deadLockRetryWait=10000, validationQuery='null', minEvictableTimeMillis=null, timeBetweenEvictionRunsMillis=null}}
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Cannot open database "jiradb" requested by the login. The login failed.)

診断

JIRA fails to start every time (or almost every time) the server is restarted. Any other attempts to start JIRA are successful.

原因

Because of the parallel nature of service startups in Windows, it is possible (but unusual) that the SQLSERVER service was not fully started by the time the JIRA service was online.

回避策

To work around this issue, use services.msc to set the JIRA service to restart the service on failure.

ソリューション

1. Open HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\<JIRA_service_name>
2. Add MSSQLSERVER to the REG_MULTI_SZ key DependOnService