com.atlassian.jira.plugins.importer.SQLRuntimeException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • On import from Bugzilla 2.20 hosted on MySQL 3.23.58 with help of JIM 3.5.3 the following error is reported: {noformat} 2011-12-09 13:26:29,384 ERROR - Unexpected failure occurred. Importer will stop immediately. Data maybe in an unstable state com.atlassian.jira.plugins.importer.SQLRuntimeException: You have an error in your SQL syntax near 'ON (b.reporter = prof.userid OR b.assigned_to = prof.userid) WHERE b.product_id ' at line 1 at com.atlassian.jira.plugins.importer.web.JdbcConnection.queryDb(JdbcConnection.java:177) at com.atlassian.jira.plugins.importer.web.JdbcConnection.queryDb(JdbcConnection.java:146) at com.atlassian.jira.plugins.importer.imports.bugzilla.BugzillaDataBean.getRequiredUsers(BugzillaDataBean.java:60) at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.importUsers(DefaultJiraDataImporter.java:485) at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.doImport(DefaultJiraDataImporter.java:243) at com.atlassian.jira.plugins.importer.imports.importer.impl.ImporterCallable.call(ImporterCallable.java:25) at com.atlassian.jira.plugins.importer.imports.importer.impl.ImporterCallable.call(ImporterCallable.java:14) at com.atlassian.jira.task.TaskManagerImpl$TaskCallableDecorator.call(TaskManagerImpl.java:359) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at com.atlassian.multitenant.impl.DefaultMultiTenantManager.runForTenant(DefaultMultiTenantManager.java:61) at com.atlassian.multitenant.juc.MultiTenantExecutors$WrappedRunnable.run(MultiTenantExecutors.java:160) at com.atlassian.jira.task.ForkedThreadExecutor$ForkedRunnableDecorator.run(ForkedThreadExecutor.java:249) at java.lang.Thread.run(Thread.java:662) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax near 'ON (b.reporter = prof.userid OR b.assigned_to = prof.userid) WHERE b.product_id ' at line 1 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) 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:1052) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2624) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2127) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2293) at com.atlassian.jira.plugins.importer.web.JdbcConnection.queryDb(JdbcConnection.java:162) ... 16 more {noformat} *Workaround* Upgrade database server to more modern release e.g. 4.1+.
    via by Bogdan Dziedzic,
  • On import from Bugzilla 2.20 hosted on MySQL 3.23.58 with help of JIM 3.5.3 the following error is reported: {noformat} 2011-12-09 13:26:29,384 ERROR - Unexpected failure occurred. Importer will stop immediately. Data maybe in an unstable state com.atlassian.jira.plugins.importer.SQLRuntimeException: You have an error in your SQL syntax near 'ON (b.reporter = prof.userid OR b.assigned_to = prof.userid) WHERE b.product_id ' at line 1 at com.atlassian.jira.plugins.importer.web.JdbcConnection.queryDb(JdbcConnection.java:177) at com.atlassian.jira.plugins.importer.web.JdbcConnection.queryDb(JdbcConnection.java:146) at com.atlassian.jira.plugins.importer.imports.bugzilla.BugzillaDataBean.getRequiredUsers(BugzillaDataBean.java:60) at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.importUsers(DefaultJiraDataImporter.java:485) at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.doImport(DefaultJiraDataImporter.java:243) at com.atlassian.jira.plugins.importer.imports.importer.impl.ImporterCallable.call(ImporterCallable.java:25) at com.atlassian.jira.plugins.importer.imports.importer.impl.ImporterCallable.call(ImporterCallable.java:14) at com.atlassian.jira.task.TaskManagerImpl$TaskCallableDecorator.call(TaskManagerImpl.java:359) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at com.atlassian.multitenant.impl.DefaultMultiTenantManager.runForTenant(DefaultMultiTenantManager.java:61) at com.atlassian.multitenant.juc.MultiTenantExecutors$WrappedRunnable.run(MultiTenantExecutors.java:160) at com.atlassian.jira.task.ForkedThreadExecutor$ForkedRunnableDecorator.run(ForkedThreadExecutor.java:249) at java.lang.Thread.run(Thread.java:662) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax near 'ON (b.reporter = prof.userid OR b.assigned_to = prof.userid) WHERE b.product_id ' at line 1 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) 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:1052) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2624) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2127) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2293) at com.atlassian.jira.plugins.importer.web.JdbcConnection.queryDb(JdbcConnection.java:162) ... 16 more {noformat} *Workaround* Upgrade database server to more modern release e.g. 4.1+.
    via by Bogdan Dziedzic [Atlassian],
  • On import from Bugzilla 2.20 hosted on MySQL 3.23.58 with help of JIM 3.5.3 the following error is reported: {noformat} 2011-12-09 13:26:29,384 ERROR - Unexpected failure occurred. Importer will stop immediately. Data maybe in an unstable state com.atlassian.jira.plugins.importer.SQLRuntimeException: You have an error in your SQL syntax near 'ON (b.reporter = prof.userid OR b.assigned_to = prof.userid) WHERE b.product_id ' at line 1 at com.atlassian.jira.plugins.importer.web.JdbcConnection.queryDb(JdbcConnection.java:177) at com.atlassian.jira.plugins.importer.web.JdbcConnection.queryDb(JdbcConnection.java:146) at com.atlassian.jira.plugins.importer.imports.bugzilla.BugzillaDataBean.getRequiredUsers(BugzillaDataBean.java:60) at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.importUsers(DefaultJiraDataImporter.java:485) at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.doImport(DefaultJiraDataImporter.java:243) at com.atlassian.jira.plugins.importer.imports.importer.impl.ImporterCallable.call(ImporterCallable.java:25) at com.atlassian.jira.plugins.importer.imports.importer.impl.ImporterCallable.call(ImporterCallable.java:14) at com.atlassian.jira.task.TaskManagerImpl$TaskCallableDecorator.call(TaskManagerImpl.java:359) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at com.atlassian.multitenant.impl.DefaultMultiTenantManager.runForTenant(DefaultMultiTenantManager.java:61) at com.atlassian.multitenant.juc.MultiTenantExecutors$WrappedRunnable.run(MultiTenantExecutors.java:160) at com.atlassian.jira.task.ForkedThreadExecutor$ForkedRunnableDecorator.run(ForkedThreadExecutor.java:249) at java.lang.Thread.run(Thread.java:662) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax near 'ON (b.reporter = prof.userid OR b.assigned_to = prof.userid) WHERE b.product_id ' at line 1 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) 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:1052) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2624) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2127) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2293) at com.atlassian.jira.plugins.importer.web.JdbcConnection.queryDb(JdbcConnection.java:162) ... 16 more {noformat} *Workaround* Upgrade database server to more modern release e.g. 4.1+.
    via by Bogdan Dziedzic [Atlassian],
  • Hi there, When I try to use an existing configuration file to migrate bugs from Fogbugs into Jira I get the following error: Unexpected failure occurred. Importer will stop immediately. Data maybe in an unstable state The log says: {code} 2013-12-10 17:16:28,888 ERROR - Unexpected failure occurred. Importer will stop immediately. Data maybe in an unstable state com.atlassian.jira.plugins.importer.SQLRuntimeException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 at com.atlassian.jira.plugins.importer.web.JdbcConnection.queryDb(JdbcConnection.java:177) at com.atlassian.jira.plugins.importer.web.JdbcConnection.queryDb(JdbcConnection.java:146) at com.atlassian.jira.plugins.importer.imports.fogbugz.FogBugzDataBean.getTotalIssues(FogBugzDataBean.java:96) at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.doImport(DefaultJiraDataImporter.java:408) at com.atlassian.jira.plugins.importer.imports.importer.impl.ImporterCallable.call(ImporterCallable.java:26) at com.atlassian.jira.plugins.importer.imports.importer.impl.ImporterCallable.call(ImporterCallable.java:15) at com.atlassian.jira.task.TaskManagerImpl$TaskCallableDecorator.call(TaskManagerImpl.java:365) at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at com.atlassian.jira.task.ForkedThreadExecutor$ForkedRunnableDecorator.run(ForkedThreadExecutor.java:249) at java.lang.Thread.run(Unknown Source) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 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:1053) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4096) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4028) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2490) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2734) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2322) at com.atlassian.jira.plugins.importer.web.JdbcConnection.queryDb(JdbcConnection.java:162) ... 13 more 2013-12-10 17:16:28,943 INFO - No issues need to be reindexed. {code} This appears when I save the configuration file for one project, but want to import bugs from another project using the same config file (which doesn't seem to be a highly unlikely scenario). I can of course carry on with the migration not using a previously saved file, but this is makes the feature a bit useless. Currently we're using v 6.0.23 of JIRA Importers Plugin (JIM). Kind regards Marcin
    via by Marcin Boguslawski,
  • Hi there, When I try to use an existing configuration file to migrate bugs from Fogbugs into Jira I get the following error: Unexpected failure occurred. Importer will stop immediately. Data maybe in an unstable state The log says: {code} 2013-12-10 17:16:28,888 ERROR - Unexpected failure occurred. Importer will stop immediately. Data maybe in an unstable state com.atlassian.jira.plugins.importer.SQLRuntimeException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 at com.atlassian.jira.plugins.importer.web.JdbcConnection.queryDb(JdbcConnection.java:177) at com.atlassian.jira.plugins.importer.web.JdbcConnection.queryDb(JdbcConnection.java:146) at com.atlassian.jira.plugins.importer.imports.fogbugz.FogBugzDataBean.getTotalIssues(FogBugzDataBean.java:96) at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.doImport(DefaultJiraDataImporter.java:408) at com.atlassian.jira.plugins.importer.imports.importer.impl.ImporterCallable.call(ImporterCallable.java:26) at com.atlassian.jira.plugins.importer.imports.importer.impl.ImporterCallable.call(ImporterCallable.java:15) at com.atlassian.jira.task.TaskManagerImpl$TaskCallableDecorator.call(TaskManagerImpl.java:365) at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at com.atlassian.jira.task.ForkedThreadExecutor$ForkedRunnableDecorator.run(ForkedThreadExecutor.java:249) at java.lang.Thread.run(Unknown Source) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 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:1053) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4096) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4028) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2490) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2734) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2322) at com.atlassian.jira.plugins.importer.web.JdbcConnection.queryDb(JdbcConnection.java:162) ... 13 more 2013-12-10 17:16:28,943 INFO - No issues need to be reindexed. {code} This appears when I save the configuration file for one project, but want to import bugs from another project using the same config file (which doesn't seem to be a highly unlikely scenario). I can of course carry on with the migration not using a previously saved file, but this is makes the feature a bit useless. Currently we're using v 6.0.23 of JIRA Importers Plugin (JIM). Kind regards Marcin
    via by Marcin Boguslawski,
  • MySQL SQL syntax error
    via Stack Overflow by tungi52
    ,
  • Data nucleus spatial mapping error
    via Stack Overflow by Dawid D
    ,
    • com.atlassian.jira.plugins.importer.SQLRuntimeException: You have an error in your SQL syntax near 'ON (b.reporter = prof.userid OR b.assigned_to = prof.userid) WHERE b.product_id ' at line 1 at com.atlassian.jira.plugins.importer.web.JdbcConnection.queryDb(JdbcConnection.java:177) at com.atlassian.jira.plugins.importer.web.JdbcConnection.queryDb(JdbcConnection.java:146) at com.atlassian.jira.plugins.importer.imports.bugzilla.BugzillaDataBean.getRequiredUsers(BugzillaDataBean.java:60) at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.importUsers(DefaultJiraDataImporter.java:485) at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.doImport(DefaultJiraDataImporter.java:243) at com.atlassian.jira.plugins.importer.imports.importer.impl.ImporterCallable.call(ImporterCallable.java:25) at com.atlassian.jira.plugins.importer.imports.importer.impl.ImporterCallable.call(ImporterCallable.java:14) at com.atlassian.jira.task.TaskManagerImpl$TaskCallableDecorator.call(TaskManagerImpl.java:359) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at com.atlassian.multitenant.impl.DefaultMultiTenantManager.runForTenant(DefaultMultiTenantManager.java:61) at com.atlassian.multitenant.juc.MultiTenantExecutors$WrappedRunnable.run(MultiTenantExecutors.java:160) at com.atlassian.jira.task.ForkedThreadExecutor$ForkedRunnableDecorator.run(ForkedThreadExecutor.java:249) at java.lang.Thread.run(Thread.java:662) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax near 'ON (b.reporter = prof.userid OR b.assigned_to = prof.userid) WHERE b.product_id ' at line 1 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) 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:1052) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2624) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2127) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2293) at com.atlassian.jira.plugins.importer.web.JdbcConnection.queryDb(JdbcConnection.java:162) ... 16 more

    Users with the same issue

    Михайло ТітовМихайло Тітов
    5 times, last one,
    slashslash
    2 times, last one,
    ivanszkypeterivanszkypeter
    58 times, last one,
    aidoanaidoan
    4 times, last one,
    CasperCasper
    11 times, last one,
    115 more bugmates