srhs
10 years agoNew Contributor
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?