Forum Discussion

srhs's avatar
srhs
New Contributor
9 years ago
Solved

Database initialization error cause slow launch

When I launch Ready!API the initial splash screen shows. It then takes about 5 mins before the main UI appears.

 

In looking at the Ready! API Log. It shows a DB timeout happening (below).

 

This was an upgrade from 1.3.1. The about screen confirms that I am running 1.4.1. I exclusively use the product for the SOAPUI pro features.

 

The timestamp is from about 25 hours earlier. The PC was shutdown inbetween. AFAIK, Ready! API was gracefully closed yesterday.

 

How do I correct this locking issue?

 

 

  • Fri Oct 02 10:34:48 EDT 2015:INFO:Adding [C:\Program Files\SmartBear\ReadyAPI-1.3.1\bin\ext\sqljdbc4.jar] to extensions classpath
  • Fri Oct 02 10:34:49 EDT 2015:INFO:initialized soapui-settings from [C:\Users\sruland\soapui-settings.xml]
  • Fri Oct 02 10:34:53 EDT 2015:WARN:Missing scripts folder [C:\Program Files\SmartBear\SoapUI-Pro-5.1.1\bin\scripts]
  • Fri Oct 02 10:34:53 EDT 2015:INFO:Adding listeners from [C:\Program Files\SmartBear\ReadyAPI-1.3.1\bin\listeners\demo-listeners.xml]
  • Fri Oct 02 10:34:53 EDT 2015:INFO:Initializing database..
  • Fri Oct 02 10:39:54 EDT 2015:ERROR:Failed to initialize database
  • liquibase.exception.LockException: Could not acquire change log lock. Currently locked by C5PFQ22-PC (192.168.24.152) since 10/1/15 8:14 AM
  • at liquibase.lockservice.StandardLockService.waitForLock(StandardLockService.java:174)
  • at liquibase.Liquibase.update(Liquibase.java:186)
  • at liquibase.Liquibase.update(Liquibase.java:181)
  • at com.smartbear.ready.db.init.liquibase.LiquibaseDbInitializer.initdb(LiquibaseDbInitializer.java:38)
  • at com.smartbear.ready.db.init.liquibase.LiquibaseDbInitializer$$FastClassByGuice$$2a5f2037.invoke()
  • at com.google.inject.internal.cglib.reflect.$FastMethod.invoke(FastMethod.java:53)
  • at com.google.inject.internal.SingleMethodInjector$1.invoke(SingleMethodInjector.java:56)
  • at com.google.inject.internal.SingleMethodInjector.inject(SingleMethodInjector.java:90)
  • at com.google.inject.internal.MembersInjectorImpl.injectMembers(MembersInjectorImpl.java:110)
  • at com.google.inject.internal.ConstructorInjector.construct(ConstructorInjector.java:94)
  • at com.google.inject.internal.ConstructorBindingImpl$Factory.get(ConstructorBindingImpl.java:254)
  • at com.google.inject.internal.FactoryProxy.get(FactoryProxy.java:54)
  • at com.google.inject.internal.ProviderToInternalFactoryAdapter$1.call(ProviderToInternalFactoryAdapter.java:46)
  • at com.google.inject.internal.InjectorImpl.callInContext(InjectorImpl.java:1031)
  • at com.google.inject.internal.ProviderToInternalFactoryAdapter.get(ProviderToInternalFactoryAdapter.java:40)
  • at com.google.inject.Scopes$1$1.get(Scopes.java:65)
  • at com.google.inject.internal.InternalFactoryToProviderAdapter.get(InternalFactoryToProviderAdapter.java:40)
  • at com.google.inject.internal.SingleParameterInjector.inject(SingleParameterInjector.java:38)
  • at com.google.inject.internal.SingleParameterInjector.getAll(SingleParameterInjector.java:62)
  • at com.google.inject.internal.SingleMethodInjector.inject(SingleMethodInjector.java:83)
  • at com.google.inject.internal.MembersInjectorImpl.injectMembers(MembersInjectorImpl.java:110)
  • at com.google.inject.internal.ConstructorInjector.construct(ConstructorInjector.java:94)
  • at com.google.inject.internal.ConstructorBindingImpl$Factory.get(ConstructorBindingImpl.java:254)
  • at com.google.inject.internal.FactoryProxy.get(FactoryProxy.java:54)
  • at com.google.inject.internal.ProviderToInternalFactoryAdapter$1.call(ProviderToInternalFactoryAdapter.java:46)
  • at com.google.inject.internal.InjectorImpl.callInContext(InjectorImpl.java:1031)
  • at com.google.inject.internal.ProviderToInternalFactoryAdapter.get(ProviderToInternalFactoryAdapter.java:40)
  • at com.google.inject.Scopes$1$1.get(Scopes.java:65)
  • at com.google.inject.internal.InternalFactoryToProviderAdapter.get(InternalFactoryToProviderAdapter.java:40)
  • at com.google.inject.internal.ExposedKeyFactory.get(ExposedKeyFactory.java:54)
  • at com.google.inject.internal.SingleParameterInjector.inject(SingleParameterInjector.java:38)
  • at com.google.inject.internal.SingleParameterInjector.getAll(SingleParameterInjector.java:62)
  • at com.google.inject.internal.SingleMethodInjector.inject(SingleMethodInjector.java:83)
  • at com.google.inject.internal.MembersInjectorImpl.injectMembers(MembersInjectorImpl.java:110)
  • at com.google.inject.internal.ConstructorInjector.construct(ConstructorInjector.java:94)
  • at com.google.inject.internal.ConstructorBindingImpl$Factory.get(ConstructorBindingImpl.java:254)
  • at com.google.inject.internal.InjectorImpl$4$1.call(InjectorImpl.java:978)
  • at com.google.inject.internal.InjectorImpl.callInContext(InjectorImpl.java:1031)
  • at com.google.inject.internal.InjectorImpl$4.get(InjectorImpl.java:974)
  • at com.google.inject.internal.InjectorImpl.getInstance(InjectorImpl.java:1013)
  • at com.eviware.soapui.SoapUIPro$SoapUIProCore.initCoreComponents(SoapUIPro.java:718)
  • at com.eviware.soapui.DefaultSoapUICore.init(DefaultSoapUICore.java:141)
  • at com.eviware.soapui.SoapUIPro$SoapUIProCore.init(SoapUIPro.java:574)
  • at com.eviware.soapui.SoapUIPro$SoapUIProCore.(SoapUIPro.java:516)
  • at com.eviware.soapui.SoapUIPro$SoapUIProCore$$FastClassByGuice$$e6b56c2e.newInstance()
  • at com.google.inject.internal.cglib.reflect.$FastConstructor.newInstance(FastConstructor.java:40)
  • at com.google.inject.internal.DefaultConstructionProxyFactory$1.newInstance(DefaultConstructionProxyFactory.java:60)
  • at com.google.inject.internal.ConstructorInjector.construct(ConstructorInjector.java:85)
  • at com.google.inject.internal.ConstructorBindingImpl$Factory.get(ConstructorBindingImpl.java:254)
  • at com.google.inject.internal.FactoryProxy.get(FactoryProxy.java:54)
  • at com.google.inject.internal.ProviderToInternalFactoryAdapter$1.call(ProviderToInternalFactoryAdapter.java:46)
  • at com.google.inject.internal.InjectorImpl.callInContext(InjectorImpl.java:1031)
  • at com.google.inject.internal.ProviderToInternalFactoryAdapter.get(ProviderToInternalFactoryAdapter.java:40)
  • at com.google.inject.Scopes$1$1.get(Scopes.java:65)
  • at com.google.inject.internal.InternalFactoryToProviderAdapter.get(InternalFactoryToProviderAdapter.java:40)
  • at com.google.inject.internal.InjectorImpl$4$1.call(InjectorImpl.java:978)
  • at com.google.inject.internal.InjectorImpl.callInContext(InjectorImpl.java:1031)
  • at com.google.inject.internal.InjectorImpl$4.get(InjectorImpl.java:974)
  • at com.google.inject.spi.ProviderLookup$1.get(ProviderLookup.java:89)
  • at com.google.inject.internal.ProviderMethod.get(ProviderMethod.java:98)
  • at com.google.inject.internal.InternalFactoryToProviderAdapter.get(InternalFactoryToProviderAdapter.java:40)
  • at com.google.inject.internal.SingleParameterInjector.inject(SingleParameterInjector.java:38)
  • at com.google.inject.internal.SingleParameterInjector.getAll(SingleParameterInjector.java:62)
  • at com.google.inject.internal.ConstructorInjector.construct(ConstructorInjector.java:84)
  • at com.google.inject.internal.ConstructorBindingImpl$Factory.get(ConstructorBindingImpl.java:254)
  • at com.google.inject.internal.ProviderToInternalFactoryAdapter$1.call(ProviderToInternalFactoryAdapter.java:46)
  • at com.google.inject.internal.InjectorImpl.callInContext(InjectorImpl.java:1031)
  • at com.google.inject.internal.ProviderToInternalFactoryAdapter.get(ProviderToInternalFactoryAdapter.java:40)
  • at com.google.inject.Scopes$1$1.get(Scopes.java:65)
  • at com.google.inject.internal.InternalFactoryToProviderAdapter.get(InternalFactoryToProviderAdapter.java:40)
  • at com.google.inject.internal.FactoryProxy.get(FactoryProxy.java:54)
  • at com.google.inject.internal.ProviderToInternalFactoryAdapter$1.call(ProviderToInternalFactoryAdapter.java:46)
  • at com.google.inject.internal.InjectorImpl.callInContext(InjectorImpl.java:1031)
  • at com.google.inject.internal.ProviderToInternalFactoryAdapter.get(ProviderToInternalFactoryAdapter.java:40)
  • at com.google.inject.Scopes$1$1.get(Scopes.java:65)
  • at com.google.inject.internal.InternalFactoryToProviderAdapter.get(InternalFactoryToProviderAdapter.java:40)
  • at com.google.inject.internal.SingleParameterInjector.inject(SingleParameterInjector.java:38)
  • at com.google.inject.internal.SingleParameterInjector.getAll(SingleParameterInjector.java:62)
  • at com.google.inject.internal.SingleMethodInjector.inject(SingleMethodInjector.java:83)
  • at com.google.inject.internal.MembersInjectorImpl.injectMembers(MembersInjectorImpl.java:110)
  • at com.google.inject.internal.MembersInjectorImpl$1.call(MembersInjectorImpl.java:75)
  • at com.google.inject.internal.MembersInjectorImpl$1.call(MembersInjectorImpl.java:73)
  • at com.google.inject.internal.InjectorImpl.callInContext(InjectorImpl.java:1024)
  • at com.google.inject.internal.MembersInjectorImpl.injectAndNotify(MembersInjectorImpl.java:73)
  • at com.google.inject.internal.Initializer$InjectableReference.get(Initializer.java:147)
  • at com.google.inject.internal.Initializer.injectAll(Initializer.java:92)
  • at com.google.inject.internal.InternalInjectorCreator.injectDynamically(InternalInjectorCreator.java:173)
  • at com.google.inject.internal.InternalInjectorCreator.build(InternalInjectorCreator.java:109)
  • at com.google.inject.internal.InjectorImpl.createChildInjector(InjectorImpl.java:217)
  • at com.netflix.governator.guice.LifecycleInjector.createChildInjector(LifecycleInjector.java:254)
  • at com.netflix.governator.guice.LifecycleInjector.createInjector(LifecycleInjector.java:321)
  • at com.netflix.governator.guice.LifecycleInjector.createInjector(LifecycleInjector.java:275)
  • at com.smartbear.ready.ui.ReadyApiMain.main(ReadyApiMain.java:59)
  • at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  • at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
  • at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
  • at java.lang.reflect.Method.invoke(Unknown Source)
  • at com.exe4j.runtime.LauncherEngine.launch(Unknown Source)
  • at com.exe4j.runtime.WinLauncher.main(Unknown Source)
  • at com.install4j.runtime.launcher.WinLauncher.main(Unknown Source)
  • Hi Srhs,

     

    If you delete (backup) the content from db folder in .readyapi folder from your user folder, this should increase the load time. Does this help?

     

3 Replies

  • TanyaYatskovska's avatar
    TanyaYatskovska
    SmartBear Alumni (Retired)

    Hi Srhs,

     

    If you delete (backup) the content from db folder in .readyapi folder from your user folder, this should increase the load time. Does this help?

     

    • srhs's avatar
      srhs
      New Contributor
      Thank you Tanya, that seems to have corrected the issue! The UI comes up in only a few seconds again. -Steve