Bugzilla import fails with "Could not create connection to database server. Attempted reconnect 3 times. Giving up"
Symptoms
The following appears in the atlassian-jira.log
:
2013-09-23 16:21:07,373 http-bio-8080-exec-20 WARN admin 981x67x1 1rd5vun 10.1.1.10 /secure/admin/views/ImporterSetupPage.jspa [plugins.importer.web.JdbcConnection] Error connecting to the database: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2238)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2159)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:792)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) <+3>
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:381)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
at com.atlassian.jira.plugins.importer.web.JdbcConnection.getConnection(JdbcConnection.java:87)
at com.atlassian.jira.plugins.importer.web.JdbcConnection.validateConnection(JdbcConnection.java:191)
at com.atlassian.jira.plugins.importer.web.AbstractDatabaseImporterController.createImportProcessBean(AbstractDatabaseImporterController.java:57)
at com.atlassian.jira.plugins.importer.web.ImporterSetupPage.doExecute(ImporterSetupPage.java:130) <+1> (ActionSupport.java:165)
at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:83)
at com.atlassian.jira.plugins.importer.web.ImporterProcessSupport.execute(ImporterProcessSupport.java:143) <+7> (DefaultInterceptorChain.java:39)
Cause
JIRA is not being able to connect with Bugzilla's database because of lack of permissions of the Bugzilla database user or problems with the connections from Bugzilla's DB.
Resolution
You can use a bulleted or numbered list
GRANT ALL PRIVILEGES ON * . * TO 'bugzilla'@'%' IDENTIFIED BY PASSWORD '52819c504481470a' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
Where "bugzilla" is the database user and the hash password specified will be your password.
- Check the database connection with any kind of DB Visualizer to confirm that the Bugzilla database is accessible from external sources.
Last modified on Mar 30, 2016
Powered by Confluence and Scroll Viewport.