| Re: [geogig-dev] Loading of GeoGig repositories fails after restart of Geoserver |
Hi Erik, We have now tried to install the build of the GeoServer 2.10 plugin provided in your link on a GeoServer with the following information:
GeoServer 2.10 is installed on a Tomcat server with the following configuration:
We have removed the PostgreSQL driver postgresql-9.4.1211.jar before installing the GeoServer 2.10 plugin. The GeoGig menu items in the left side loads as expected after restarting the GeoServer but when we try to create a file based GeoGig repository we get an error of this kind “Could not initialize class org.rocksdb.RocksDB” (further information is included in the attached file java_errors.txt). We have also tried to install the GeoServer 2.10 plugin from this link: https://github.com/locationtech/geogig/releases/download/v1.1.1/geoserver-2.10.x-geogig-plugin.zip but unfortunately with the same result. Do you know the cause of this issue or a workaround? Best regards
Fra: geogig-dev-bounces@xxxxxxxxxxxxxxxx [mailto:geogig-dev-bounces@xxxxxxxxxxxxxxxx] På vegne af Erik Merkle Erik, The latest GeoServer 2.10 plugin build is here: Be aware, there is an updated PostgreSQL driver bundled in the plugin (version 42.1.1) and it will conflict with the PostgreSQL driver that comes with GeoServer 2.10. If you chose to use the nightly plugin build, you will have to remove the older PostgreSQL driver currently in your GeoServer install (likely postgresql-9.4.1211.jar). Regards, Erik Merkle On Thu, Jun 29, 2017 at 12:46 AM, Erik Martinsen <ema@xxxxxxxxxx> wrote: Hi Gabriel, Thank you for the information. Is it possible for you to provide a similar link to the latest build of the GeoServer 2.10 plugin? Or do you know when this plugin will be released in final mode? We have yesterday tested the build we can download from this link https://github.com/locationtech/geogig/releases/download/v1.1.1-RC1/geoserver-2.10-SNAPSHOT-geogig-plugin.zip . It solves some of our problems but we still cannot load the GeoGig repositories after restart of the GeoServer. Best regards
Fra: geogig-dev-bounces@xxxxxxxxxxxxxxxx [mailto:geogig-dev-bounces@xxxxxxxxxxxxxxxx] På vegne af Gabriel Roldan
Hello, just a heads that this bug has been fixed and will be released with 1.1.1. while we wait for 1.1.1 final to come out, you can get the fix from the latest nightly build [1] Cheers, Gabriel On Wed, Jun 21, 2017 at 4:57 AM, Erik Martinsen <ema@xxxxxxxxxx> wrote: Hi Erik, Yes, usually we create the GeoGig repository from the GeoServer UI. But we have now tried to create a repository directly from the GeoGig plugin in QGIS. From QGIS we access the GeoServer using this URL
So the URL to the repository is like in your example: http://server3x2:8082/geoserver/geogig/repos/EMA_REPOS_2/ In QGIS the GeoGig plugin is configured with user name and email:
Even though we create the repository directly from QGIS and GeoGig configured with user name and email the first time we try to add a layer to the repository we get this error:
We have tried to configure globally through command line but we have manually to edit the local repository config file on the server by adding these lines:
The repository then works as expected. After restart of the GeoServer ensuring no QGIS sessions is running that are connected to the repository (so only one single process) the access to the repository from QGIS afterward fails with the following error: 2017-06-21T09:48:13 0 QGIS starter... 2017-06-21T09:48:14 0 Python-understøttelse SLÅET TIL :-) 2017-06-21T09:50:01 0 Application state: QGIS_PREFIX_PATH env var: C:/PROGRA~2/QGIS2~1.18/apps/qgis Prefix: C:/PROGRA~2/QGIS2~1.18/apps/qgis Plugin Path: C:/PROGRA~2/QGIS2~1.18/apps/qgis/plugins Package Data Path: C:/PROGRA~2/QGIS2~1.18/apps/qgis/. Active Theme Name: default Active Theme Path: C:/Users/erik.martinsen/.qgis2///themes\default\icons/ Default Theme Path: :/images/themes/default/ SVG Search Paths: C:/PROGRA~2/QGIS2~1.18/apps/qgis/./svg/ C:/Users/erik.martinsen/.qgis2//svg/ User DB Path: C:/PROGRA~2/QGIS2~1.18/apps/qgis/./resources/qgis.db Auth DB Path: C:/Users/erik.martinsen/.qgis2//qgis-auth.db 2017-06-21T09:50:01 0 QGIS er klar! 2017-06-21T09:50:23 2 An error occurred while fetching repository data! 500 Server Error: for url: http://server3x2:8082/geoserver/geogig/repos/EMA_REPOS_2/ls-tree?path=HEAD&output_format=json&_onlyTrees_=True Best regards
Fra: geogig-dev-bounces@xxxxxxxxxxxxxxxx [mailto:geogig-dev-bounces@xxxxxxxxxxxxxxxx] På vegne af Erik Merkle Hi Erik, C an you clarify a few things for me? It sounds like your GeoGig repository is created via GeoServer, correct? Then you are accessing the repository via QGIS. I'm assuming you are using the GeoGig plugin in QGIS to connect. If so, are you exposing the repository via command line "geogig serve", or are you accessing the repository as exposed via GeoServer (using a URL similar to http://localhost/geoserver/geogig/repos/myRepo)? The error you are seeing may be related to one of a couple of issues that have been raised: The problem with issue #309 is that there are 2 processes trying to access a single RocksDB database at the same time. Currently, the RocksDB integration in GeoGig is such that GeoGig will maintain an exclusive lock on the RocksDB database as long as the repository remains open in a given process. This means that GeoServer can serve out the repository, or "geogig serve" from the command line can serve out the repository, but not both at the same time. I suspect this may be the issue, if you have a QGIS session open and connected to the repository (via geogig serve), and then you try to restart GeoServer, which will try to open the repository as well. If this is not the case, that is you only have a single process accessing the repository, then it may be related to issue #302, or it may be a new issue we have not come across. If you would, could you please reply back and let us know if your issue is being caused by more than one process trying to access the database. If that is not the issue, we can collect more details and open a new ticket in GitHub. Many thanks, Erik Merkle On Tue, Jun 20, 2017 at 12:25 AM, Erik Martinsen <ema@xxxxxxxxxx> wrote: Hi, We are testing GeoGig on a Windows Server 2012R2 with GeoServer 2.10.0. The server is installed with Java version 1.8.0_121. After creating file based GeoGig repositories we access them from QGIS Desktop 2.18.2. From QGIS we can successfully add new layers to the repositories and make layer versioning and merging in master and branches. However after a restart of the GeoServer the repositories fails with an error message of the following type for one and each of them when we try to access them from QGIS: 2017-06-19 13:39:31,954 WARN [geoserver.config] - Error loading GeoGig repository instance for id 5f646e20-aaee-4cd5-8f35-92045ed9c831 java.lang.RuntimeException: org.rocksdb.RocksDBException: × Further details is available from the attached geoserver.log file. After restart of the GeoServer we can create a new repository that will be operating as expected until next time the GeoServer is restarted. Are there some kind of close down or start up procedure for the GeoServer we are not aware of? Best regards
-- Gabriel Roldán
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
org.apache.wicket.WicketRuntimeException: Method onRequest of interface org.apache.wicket.behavior.IBehaviorListener targeted at org.apache.wicket.ajax.markup.html.form.AjaxSubmitLink$1@397e1f0 on component [AjaxSubmitLink [Component id = save]] threw an exception at org.apache.wicket.RequestListenerInterface.internalInvoke(RequestListenerInterface.java:268) at org.apache.wicket.RequestListenerInterface.invoke(RequestListenerInterface.java:241) at org.apache.wicket.core.request.handler.ListenerInterfaceRequestHandler.invokeListener(ListenerInterfaceRequestHandler.java:248) at org.apache.wicket.core.request.handler.ListenerInterfaceRequestHandler.respond(ListenerInterfaceRequestHandler.java:234) at org.apache.wicket.request.cycle.RequestCycle$HandlerExecutor.respond(RequestCycle.java:865) at org.apache.wicket.request.RequestHandlerStack.execute(RequestHandlerStack.java:64) at org.apache.wicket.request.cycle.RequestCycle.execute(RequestCycle.java:265) at org.apache.wicket.request.cycle.RequestCycle.processRequest(RequestCycle.java:222) at org.apache.wicket.request.cycle.RequestCycle.processRequestAndDetach(RequestCycle.java:293) at org.apache.wicket.protocol.http.WicketFilter.processRequestCycle(WicketFilter.java:261) at org.apache.wicket.protocol.http.WicketFilter.processRequest(WicketFilter.java:203) at org.apache.wicket.protocol.http.WicketServlet.doPost(WicketServlet.java:159) at javax.servlet.http.HttpServlet.service(HttpServlet.java:648) at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) at org.springframework.web.servlet.mvc.ServletWrappingController.handleRequestInternal(ServletWrappingController.java:158) at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:147) at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:50) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:959) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:893) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:968) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:870) at javax.servlet.http.HttpServlet.service(HttpServlet.java:648) at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:844) at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:184) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:217) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:184) at org.geoserver.filters.ThreadLocalsCleanupFilter.doFilter(ThreadLocalsCleanupFilter.java:28) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:217) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:184) at org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:75) at org.geoserver.wms.animate.AnimatorFilter.doFilter(AnimatorFilter.java:71) at org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:71) at org.geoserver.filters.SpringDelegatingFilter.doFilter(SpringDelegatingFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:217) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:184) at org.geoserver.platform.AdvancedDispatchFilter.doFilter(AdvancedDispatchFilter.java:50) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:217) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:184) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:316) at org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:69) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:126) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:90) at org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:73) at org.geoserver.security.filter.GeoServerCompositeFilter.doFilter(GeoServerCompositeFilter.java:92) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:69) at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114) at org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:73) at org.geoserver.security.filter.GeoServerCompositeFilter.doFilter(GeoServerCompositeFilter.java:92) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.geoserver.security.filter.GeoServerAnonymousAuthenticationFilter.doFilter(GeoServerAnonymousAuthenticationFilter.java:54) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:69) at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:205) at org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:73) at org.geoserver.security.filter.GeoServerCompositeFilter.doFilter(GeoServerCompositeFilter.java:92) at org.geoserver.security.filter.GeoServerUserNamePasswordAuthenticationFilter.doFilter(GeoServerUserNamePasswordAuthenticationFilter.java:116) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:69) at org.springframework.security.web.authentication.rememberme.RememberMeAuthenticationFilter.doFilter(RememberMeAuthenticationFilter.java:157) at org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:73) at org.geoserver.security.filter.GeoServerCompositeFilter.doFilter(GeoServerCompositeFilter.java:92) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:69) at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:91) at org.geoserver.security.filter.GeoServerSecurityContextPersistenceFilter$1.doFilter(GeoServerSecurityContextPersistenceFilter.java:53) at org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:73) at org.geoserver.security.filter.GeoServerCompositeFilter.doFilter(GeoServerCompositeFilter.java:92) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:213) at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:176) at org.geoserver.security.GeoServerSecurityFilterChainProxy.doFilter(GeoServerSecurityFilterChainProxy.java:152) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:217) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:184) at org.geoserver.filters.LoggingFilter.doFilter(LoggingFilter.java:87) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:217) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:184) at org.geoserver.filters.GZIPFilter.doFilter(GZIPFilter.java:42) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:217) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:184) at org.geoserver.filters.SessionDebugFilter.doFilter(SessionDebugFilter.java:48) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:217) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:184) at org.geoserver.filters.FlushSafeFilter.doFilter(FlushSafeFilter.java:44) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:217) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:184) at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:121) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:217) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:184) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:105) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:361) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:1080) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:75) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:757) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1515) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source) Caused by: java.lang.reflect.InvocationTargetException 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 org.apache.wicket.RequestListenerInterface.internalInvoke(RequestListenerInterface.java:258) ... 110 more Caused by: java.lang.NoClassDefFoundError: Could not initialize class org.rocksdb.RocksDB at org.locationtech.geogig.rocksdb.RocksConnectionManager.connect(RocksConnectionManager.java:57) at org.locationtech.geogig.rocksdb.RocksConnectionManager.connect(RocksConnectionManager.java:36) at org.locationtech.geogig.storage.impl.ConnectionManager.acquire(ConnectionManager.java:61) at org.locationtech.geogig.rocksdb.RocksdbObjectStore.open(RocksdbObjectStore.java:102) at org.locationtech.geogig.rocksdb.RocksdbObjectStore.open(RocksdbObjectStore.java:91) at org.locationtech.geogig.rocksdb.RocksdbObjectDatabase.open(RocksdbObjectDatabase.java:70) at org.locationtech.geogig.storage.impl.ForwardingObjectDatabase.open(ForwardingObjectDatabase.java:43) at org.locationtech.geogig.repository.impl.RepositoryImpl.open(RepositoryImpl.java:127) at org.locationtech.geogig.porcelain.InitOp._call(InitOp.java:179) at org.locationtech.geogig.porcelain.InitOp._call(InitOp.java:64) at org.locationtech.geogig.repository.AbstractGeoGigOp.call(AbstractGeoGigOp.java:154) at org.geogig.geoserver.config.RepositoryManager.create(RepositoryManager.java:341) at org.geogig.geoserver.config.RepositoryManager.save(RepositoryManager.java:320) at org.geogig.geoserver.web.repository.RepositoryEditFormPanel.onSave(RepositoryEditFormPanel.java:250) at org.geogig.geoserver.web.repository.RepositoryEditFormPanel.access$000(RepositoryEditFormPanel.java:54) at org.geogig.geoserver.web.repository.RepositoryEditFormPanel$2.onSubmit(RepositoryEditFormPanel.java:133) at org.apache.wicket.ajax.markup.html.form.AjaxSubmitLink$1.onSubmit(AjaxSubmitLink.java:110) at org.apache.wicket.ajax.form.AjaxFormSubmitBehavior$AjaxFormSubmitter.onSubmit(AjaxFormSubmitBehavior.java:215) at org.apache.wicket.markup.html.form.Form.delegateSubmit(Form.java:1307) at org.apache.wicket.markup.html.form.Form.process(Form.java:974) at org.apache.wicket.markup.html.form.Form.onFormSubmitted(Form.java:795) at org.apache.wicket.ajax.form.AjaxFormSubmitBehavior.onEvent(AjaxFormSubmitBehavior.java:171) at org.apache.wicket.ajax.AjaxEventBehavior.respond(AjaxEventBehavior.java:155) at org.apache.wicket.ajax.AbstractDefaultAjaxBehavior.onRequest(AbstractDefaultAjaxBehavior.java:588) ... 115 more
