Importing from mantis fails

[EN]

Hello,

we are currently trying to import all(or what is possible) the data from our MantisBT installation.

But as soon as I enter the MySQL credentials, the first step fails with:

Error connecting to the database: Could not create connection to database server. Attempted reconnect 3 times. Giving up.

In the log file I can see(removed some details...):

2018-02-13 16:43:56,002 http-nio-8080-exec-25 INFO XXXXXXX 1003x972x1 13m9r2p XX.XX.XX.XX /secure/admin/ImporterSetupPage.jspa [c.a.j.p.importer.web.JdbcConnection] Connecting to JDBC using connection string: jdbc:mysql://XXXXXXXX:XXXX/USER?useUnicode=true&characterEncoding=UTF8&sessionVariables=default_storage_engine=InnoDB&autoReconnect=true&useUnicode=true&zeroDateTimeBehavior=convertToNull&useCursorFetch=true&defaultFetchSize=100 with username 'USER' and password
2018-02-13 16:44:00,012 http-nio-8080-exec-25 WARN XXXXXXX 1003x972x1 13m9r2p XX.XX.XX.XX /secure/admin/ImporterSetupPage.jspa [c.a.j.p.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(NativeConstructorAccessorImpl.java:62)
 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
 at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
 at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
 at com.mysql.jdbc.Util.getInstance(Util.java:408)
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:918)
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:897)
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:886)
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:860)
 at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2104)
 at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2029)
 at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:779)
 at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
 ... 3 filtered
 at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
 at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
 at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:389)
 at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
 at com.atlassian.jira.plugins.importer.web.JdbcConnection.getConnection(JdbcConnection.java:91)
 at com.atlassian.jira.plugins.importer.web.JdbcConnection.validateConnection(JdbcConnection.java:235)
 at com.atlassian.jira.plugins.importer.web.AbstractDatabaseImporterController.createImportProcessBean(AbstractDatabaseImporterController.java:54)
 at com.atlassian.jira.plugins.importer.web.ImporterSetupPage.doExecute(ImporterSetupPage.java:104)
 ... 1 filtered
 at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:63)
 at com.atlassian.jira.plugins.importer.web.ImporterProcessSupport.execute(ImporterProcessSupport.java:152)
 ... 7 filtered
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
 ... 48 filtered
 at com.atlassian.greenhopper.jira.filters.ClassicBoardRouter.doFilter(ClassicBoardRouter.java:62)
 ... 12 filtered
 at com.atlassian.web.servlet.plugin.request.RedirectInterceptingFilter.doFilter(RedirectInterceptingFilter.java:21)
 ... 62 filtered
 at com.atlassian.jira.security.JiraSecurityFilter.lambda$doFilter$0(JiraSecurityFilter.java:66)
 ... 1 filtered
 at com.atlassian.jira.security.JiraSecurityFilter.doFilter(JiraSecurityFilter.java:64)
 ... 36 filtered
 at com.atlassian.jira.servermetrics.CorrelationIdPopulatorFilter.doFilter(CorrelationIdPopulatorFilter.java:30)
 ... 10 filtered
 at com.atlassian.web.servlet.plugin.request.RedirectInterceptingFilter.doFilter(RedirectInterceptingFilter.java:21)
 ... 4 filtered
 at com.atlassian.web.servlet.plugin.LocationCleanerFilter.doFilter(LocationCleanerFilter.java:36)
 ... 26 filtered
 at com.atlassian.jira.servermetrics.MetricsCollectorFilter.doFilter(MetricsCollectorFilter.java:25)
 ... 23 filtered
 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
 at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
 at java.lang.Thread.run(Thread.java:745)
Caused by: java.sql.SQLException: Unknown system variable 'default_storage_engine'
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964)
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
 at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
 at com.mysql.jdbc.StatementImpl.executeUpdateInternal(StatementImpl.java:1552)
 at com.mysql.jdbc.StatementImpl.executeLargeUpdate(StatementImpl.java:2607)
 at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1480)
 at com.mysql.jdbc.ConnectionImpl.setSessionVariables(ConnectionImpl.java:5038)
 at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:3205)
 at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2067)
 ... 259 more

We are using Mantis Version 1.2.10 and the Jira-importers-plugin shows version 8.0.4

Is it possible that the import plugin is not compatible with the Mantis version?

What is exactly with the Unknown system variable 'default_storage_engine'?

Thank you

[Ziad Bakhiet]

Hello,

I've the same problem connecting to Mantis from Jira 7.0 , does anyone got the solution please ?

Thank you

[EN]

Found something else also...

The Mantis MySQL DB is the 5.1.43. In some websites is mentioned that the default_storage_engine is not compatible with this version. The correct parameter is called storage_engine. And my guess is that Jira is, by-default, using this connection parameter to connect to a MySQL database.

The problem is, I cannot find a way to bypass this given parameter in Jira.

By adding storage_engine into the JDBC connection parameters(in the Mantis import plugin) doesn't help the situation.

Is there a way I can bypass this default Jira parameter?

Thank you

[SEAL]

Same problem here with Mantis DB mysql 5.1.46. Did you get any solution by now?

Thanks,

  Sascha

[Charly [DEISER]]

Hi @EN

Which version of Jira are you currently using? the variable 'default_storage_engine' was introduced in Jira 7.5. If you are using an older version your connection string must use the variable 'storage_engine' instead.

Cheers

[EN]

Hi Carlos,

we are using 7.7.0