Importing xml backup from HSQLDB into new SQL Server 2008 DB - Import stuck at 90%?

I am running the import but it looks like it is stuck at 90% for the last 30 minutes.  It was a small xml file to begin with activeobjects.xml being 128KB and entities 2075kb - has this crashed or how can i check - is there any log file?

3 answers

Ok found a log file and there was nothing happening so looks like it hung so stopped it - then stopped jira server but now the service won't start again!

However, there are issues missing from backlogs and boards - so there must have been an issue with the install - here are the details from the logs - any ideas - do I need to re-import - also it is giving a message on indexing 2015-03-12 05:47:52,161 JiraImportTaskExecutionThread-1 INFO anonymous 347x93x1 7xttoo 10.92.96.167 /secure/SetupImport.jspa [atlassian.plugin.manager.DefaultPluginManager] Shutting down the plugin system 2015-03-12 05:47:52,505 Timer-3 INFO anonymous 278x16x1 7xttoo 10.92.96.167 /secure/SetupDatabase.jspa [greenhopper.service.logging.LogSupport] ********************************************************************************* Atlassian GreenHopper v6.3.13.1 #a73d75f118867c66 built 2014-05-07T21:52:18.123-06:00 - plugin stopping... ********************************************************************************* 2015-03-12 05:47:52,520 Timer-3 WARN anonymous 278x16x1 7xttoo 10.92.96.167 /secure/SetupDatabase.jspa [atlassian.greenhopper.service.BridgeServiceLocator] The GreenHopper BridgeServiceLocator has been unwired and is no longer usable 2015-03-12 05:47:52,520 Timer-3 INFO anonymous 278x16x1 7xttoo 10.92.96.167 /secure/SetupDatabase.jspa [greenhopper.service.logging.LogSupport] ********************************************************************************* Atlassian GreenHopper v6.3.13.1 #a73d75f118867c66 built 2014-05-07T21:52:18.123-06:00 - plugin stopped ********************************************************************************* 2015-03-12 05:47:54,735 Timer-3 INFO anonymous 278x16x1 7xttoo 10.92.96.167 /secure/SetupDatabase.jspa [plugins.dvcs.listener.DvcsAddUserListener] Attempting to unregister listener ... 2015-03-12 05:47:54,735 Timer-3 INFO anonymous 278x16x1 7xttoo 10.92.96.167 /secure/SetupDatabase.jspa [plugins.dvcs.listener.DvcsAddUserListener] Listener unregistered ... 2015-03-12 05:47:54,751 Timer-3 INFO anonymous 278x16x1 7xttoo 10.92.96.167 /secure/SetupDatabase.jspa [plugins.dvcs.scheduler.DvcsScheduler] DvcsScheduler job handler unregistered 2015-03-12 05:47:56,264 Timer-3 INFO anonymous 278x16x1 7xttoo 10.92.96.167 /secure/SetupDatabase.jspa [jira.plugins.monitor.MonitoringScheduler] Unscheduling metrics collector... 2015-03-12 05:47:56,264 Timer-3 INFO anonymous 278x16x1 7xttoo 10.92.96.167 /secure/SetupDatabase.jspa [jira.plugins.monitor.MonitorLauncher] Stopped JIRA monitoring 2015-03-12 05:47:56,436 Timer-3 ERROR anonymous 278x16x1 7xttoo 10.92.96.167 /secure/SetupDatabase.jspa [atlassian.event.internal.AsynchronousAbleEventDispatcher] There was an exception thrown trying to dispatch event '[com.atlassian.plugin.event.events.PluginModuleUnavailableEvent@7b87c01c, SingleParameterMethodListenerInvoker{method=public void com.atlassian.plugin.manager.DefaultPluginManager.onPluginModuleUnavailable(com.atlassian.plugin.event.events.PluginModuleUnavailableEvent), listener=com.atlassian.jira.plugin.JiraPluginManager@35787ffa}]' from the invoker 'java.lang.RuntimeException: service proxy has been destroyed' 2015-03-12 05:47:58,479 FelixStartLevel ERROR anonymous 278x16x1 7xttoo 10.92.96.167 /secure/SetupDatabase.jspa [atlassian.plugin.module.PrefixDelegatingModuleFactory] Detected an error instantiating the module via Spring. This usually means that you haven't created a <component-import> for the interface you're trying to use. https://developer.atlassian.com/x/TAEr for more details. 2015-03-12 05:47:58,479 FelixStartLevel ERROR anonymous 278x16x1 7xttoo 10.92.96.167 /secure/SetupDatabase.jspa [atlassian.event.internal.AsynchronousAbleEventDispatcher] There was an exception thrown trying to dispatch event '[com.atlassian.plugin.event.events.PluginModuleUnavailableEvent@182b084f, SingleParameterMethodListenerInvoker{method=public void com.atlassian.plugin.manager.DefaultPluginManager.onPluginModuleUnavailable(com.atlassian.plugin.event.events.PluginModuleUnavailableEvent), listener=com.atlassian.jira.plugin.JiraPluginManager@35787ffa}]' from the invoker 'java.lang.RuntimeException: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'com.atlassian.jira.plugin.devstatus.summary.indexing.DevSummaryIssueSearchExtractor': Unsatisfied dependency expressed through constructor argument with index 0 of type [com.atlassian.jira.plugin.devstatus.summary.cache.DevSummaryCache]: : Error creating bean with name 'applicationLinkService': FactoryBean threw exception on object creation; nested exception is org.springframework.osgi.service.ServiceUnavailableException: service matching filter=[(&(objectClass=com.atlassian.applinks.api.ApplicationLinkService)(objectClass=com.atlassian.applinks.api.ApplicationLinkService))] unavailable; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'applicationLinkService': FactoryBean threw exception on object creation; nested exception is org.springframework.osgi.service.ServiceUnavailableException: service matching filter=[(&(objectClass=com.atlassian.applinks.api.ApplicationLinkService)(objectClass=com.atlassian.applinks.api.ApplicationLinkService))] unavailable' 2015-03-12 05:48:29,383 JiraImportTaskExecutionThread-1 INFO anonymous 347x93x1 7xttoo 10.92.96.167 /secure/SetupImport.jspa [jira.config.database.SystemDatabaseConfigurationLoader] Reading database configuration from C:\Program Files\Atlassian\Application Data\JIRA\dbconfig.xml

0 vote

Hi Joanne, 

It looks like this log is showing a bad shutdown. Unfortunately it's tough to say what happened before this event. Can you post in your full atlassian-jira.log for us? 

I verified it and it seems to have imported with no problems as everything working as it was. Thanks.

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published yesterday in Jira Software

How large do you think Jira Software can grow?

Hi Atlassian Community! My name is Shana, and I’m on the Jira Software team. One of the many reasons this Community exists is to connect you to others on similar product journeys or with comparabl...

216 views 4 9
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you