Dear list,
I have some serious issues with my h2 database in geonetwork 3.0.1. I
recently upgraded from 3.0.0 to 3.0.1. I'm using the jar installer with the
default h2 database, since the amount of data I'm hosting is relatively
small and I'm running geonetwork under Windows server 2008 R2 enterprise
with only 2 GB RAM.
I had a working h2 database in 3.0.0 and I backed it up before the upgrade.
I removed the old GN install before installing 3.0.1. I'm pointing GN to
the data directory in my startup.bat file:
----
java -Xms48m -Xmx256m -Xss2M -XX:MaxPermSize=128m
-Dgeonetwork.dir=e:\gn_data\data
-Dmime-mappings=..\web\geonetwork\WEB-INF\mime-types.properties
-DSTOP.PORT=8079 -Djava.awt.headless=true -DSTOP.KEY=geonetwork -jar
start.jar
----
When GN finally starts and I log in, I cannot see any of my metadata. It
seems the database was not properly migrated to 3.0.1. From the Admin
panel/Information, I can see that the data dir seems to be set correctly,
however:
----
Catalog information
Thesaurus folder: E:\gn_data\data\config\codelist
Configuration folder: E:\gn_data\data\config
Data directory: E:\gn_data\data\data\metadata_data
Formatter directory: E:\gn_data\data\data\formatter
Resources folder: E:\gn_data\data\data\resources
Standard folder: E:\gn_data\data\config\schema_plugins
Subversion repository: E:\gn_data\data\data\metadata_subversion
Database
Status Database Opened Successfully
JDBC URL jdbc:h2:geonetwork
System information
JVM version 1.8.0_45
JVM name Java HotSpot(TM) Client VM
JVM vendor Oracle Corporation
Total free memory 57686
Total memory 253440
System architecture x86
System name Windows Server 2008 R2
XSLT factory de.fzi.dbs.xml.transform.CachingTransformerFactory
In geonetwork.log, the following error appers:
----
2015-08-05 15:20:26,534 WARN [geonetwork.schemamanager] - Cannot resolve
http://www.w3.org/2001/03/xml.xsd: will append last component to current
path (not sure it will help though!)
2015-08-05 15:20:30,131 WARN [geonetwork.schemamanager] - WARNING:
gco:Record is a global element without a type - assuming a string
2015-08-05 15:20:32,591 WARN [geonetwork.schemamanager] - WARNING:
gco:Record is a global element without a type - assuming a string
2015-08-05 15:20:32,605 WARN [geonetwork.schemamanager] - WARNING:
schema-substitutions.xml has wiped out XSD substitution list for
gml:VerticalDatum
2015-08-05 15:20:32,613 WARN [geonetwork.schemamanager] - WARNING:
schema-substitutions.xml has wiped out XSD substitution list for
gml:CoordinateSystemAxis
2015-08-05 15:20:32,618 WARN [geonetwork.schemamanager] - WARNING:
schema-substitutions.xml has wiped out XSD substitution list for
gml:VerticalCS
2015-08-05 15:20:32,627 WARN [geonetwork.schemamanager] - WARNING:
schema-substitutions.xml has wiped out XSD substitution list for
gml:CoordinateSystemAxis
2015-08-05 15:20:52,863 WARN [geonetwork.lucene] - Stopwords file with
incorrect ISO 639-2 language as filename: README
2015-08-05 15:21:01,567 WARN [geonetwork.svnmanager] - Recreating
subversion repository at E:\gn_data\data\data\metadata_subversion as
previous repository was empty
2015-08-05 15:27:38,176 ERROR [jeeves.service] - Exception when executing
service
2015-08-05 15:27:38,386 ERROR [jeeves.service] - (C) Exc :
MetadataNotFoundEx : Metadata not found
2015-08-05 15:27:38,507 ERROR [jeeves] - Error occurred within a transaction
MetadataNotFoundEx : Metadata not found
at
org.fao.geonet.guiservices.metadata.GetRelated.exec(GetRelated.java:282)
at
jeeves.server.dispatchers.ServiceInfo.execService(ServiceInfo.java:226)
at
jeeves.server.dispatchers.ServiceInfo.noTransactionExec(ServiceInfo.java:141)
at jeeves.server.dispatchers.ServiceInfo.access$000(ServiceInfo.java:45)
at
jeeves.server.dispatchers.ServiceInfo$1.doInTransaction(ServiceInfo.java:120)
at
jeeves.server.dispatchers.ServiceInfo$1.doInTransaction(ServiceInfo.java:117)
at
jeeves.transaction.TransactionManager.runInTransaction(TransactionManager.java:63)
at
jeeves.server.dispatchers.ServiceInfo.execServices(ServiceInfo.java:114)
at
jeeves.server.dispatchers.ServiceManager.dispatch(ServiceManager.java:442)
at
jeeves.server.dispatchers.ServiceManager.dispatch(ServiceManager.java:384)
at jeeves.server.JeevesEngine.dispatch(JeevesEngine.java:600)
at
org.fao.geonet.services.main.GenericController.dispatch(GenericController.java:106)
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.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:219)
at
org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)
at
org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
at
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:745)
at
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:686)
at
org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80)
at
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:925)
at
jeeves.config.springutil.JeevesDispatcherServlet.access$001(JeevesDispatcherServlet.java:17)
at
jeeves.config.springutil.JeevesDispatcherServlet$1.doInTransaction(JeevesDispatcherServlet.java:30)
at
jeeves.config.springutil.JeevesDispatcherServlet$1.doInTransaction(JeevesDispatcherServlet.java:27)
at
jeeves.transaction.TransactionManager.runInTransaction(TransactionManager.java:63)
at
jeeves.config.springutil.JeevesDispatcherServlet.doDispatch(JeevesDispatcherServlet.java:24)
at
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:856)
at
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:936)
at
org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:827)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:735)
at
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:812)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)
at
org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:684)
at
org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1496)
at
org.fao.geonet.monitor.webapp.WebappMetricsFilter.doFilter(WebappMetricsFilter.java:96)
at
org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1484)
at
org.fao.geonet.monitor.webapp.MetricsRegistryInitializerFilter.doFilter(MetricsRegistryInitializerFilter.java:31)
at
org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1484)
at
org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176)
at
org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145)
at
org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92)
at
org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:381)
at
org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1484)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
at
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
at
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:183)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
jeeves.config.springutil.PassthroughFilter.doFilter(PassthroughFilter.java:26)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
jeeves.config.springutil.MultiNodeAuthenticationFilter.doFilter(MultiNodeAuthenticationFilter.java:98)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)
at
org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)
at
org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343)
at
org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260)
at
jeeves.config.springutil.JeevesDelegatingFilterProxy.doFilter(JeevesDelegatingFilterProxy.java:64)
at
org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1484)
at
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at
org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1476)
at
org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:501)
at
org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:137)
at
org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:533)
at
org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:231)
at
org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1086)
at
org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:429)
at
org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:193)
at
org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1020)
at
org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135)
at
org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:255)
at
org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:154)
at
org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116)
at org.eclipse.jetty.server.Server.handle(Server.java:370)
at
org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:494)
at
org.eclipse.jetty.server.AbstractHttpConnection.headerComplete(AbstractHttpConnection.java:971)
at
org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.headerComplete(AbstractHttpConnection.java:1033)
at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:644)
at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235)
at
org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82)
at
org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:696)
at
org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:53)
at
org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608)
at
org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543)
at java.lang.Thread.run(Unknown Source)
----
Any ideas? I have wasted already two days trying to solve this, but nothing
works. I tried re-building the index and deleting all database lock files.
I tried defining the data directory in config.xml. I checked srv.xml and h2
database configuration line is uncommented by default.
Pekka
Hello,
I solved it. The problem was that I was totally unaware that the actual h2
database files are *not* in the geonetwork data folder, but in my case in
the jetty folder (...\geonetwork\jetty). By copying the backed-up *.db files
back there I was able to restore my database. Quite confusing, though. Hope
this helps someone with similar problems.
Pekka
Pekka wrote
Dear list,
I have some serious issues with my h2 database in geonetwork 3.0.1. I
recently upgraded from 3.0.0 to 3.0.1. I'm using the jar installer with
the
default h2 database, since the amount of data I'm hosting is relatively
small and I'm running geonetwork under Windows server 2008 R2 enterprise
with only 2 GB RAM.
I had a working h2 database in 3.0.0 and I backed it up before the
upgrade.
I removed the old GN install before installing 3.0.1. I'm pointing GN to
the data directory in my startup.bat file:
----
java -Xms48m -Xmx256m -Xss2M -XX:MaxPermSize=128m
-Dgeonetwork.dir=e:\gn_data\data
-Dmime-mappings=..\web\geonetwork\WEB-INF\mime-types.properties
-DSTOP.PORT=8079 -Djava.awt.headless=true -DSTOP.KEY=geonetwork -jar
start.jar
----
When GN finally starts and I log in, I cannot see any of my metadata. It
seems the database was not properly migrated to 3.0.1. From the Admin
panel/Information, I can see that the data dir seems to be set correctly,
however:
----
Catalog information
Thesaurus folder: E:\gn_data\data\config\codelist
Configuration folder: E:\gn_data\data\config
Data directory: E:\gn_data\data\data\metadata_data
Formatter directory: E:\gn_data\data\data\formatter
Resources folder: E:\gn_data\data\data\resources
Standard folder: E:\gn_data\data\config\schema_plugins
Subversion repository: E:\gn_data\data\data\metadata_subversion
Database
Status Database Opened Successfully
JDBC URL jdbc:h2:geonetwork
System information
JVM version 1.8.0_45
JVM name Java HotSpot(TM) Client VM
JVM vendor Oracle Corporation
Total free memory 57686
Total memory 253440
System architecture x86
System name Windows Server 2008 R2
XSLT factory de.fzi.dbs.xml.transform.CachingTransformerFactory
In geonetwork.log, the following error appers:
----
2015-08-05 15:20:26,534 WARN [geonetwork.schemamanager] - Cannot resolve
http://www.w3.org/2001/03/xml.xsd: will append last component to current
path (not sure it will help though!)
2015-08-05 15:20:30,131 WARN [geonetwork.schemamanager] - WARNING:
gco:Record is a global element without a type - assuming a string
2015-08-05 15:20:32,591 WARN [geonetwork.schemamanager] - WARNING:
gco:Record is a global element without a type - assuming a string
2015-08-05 15:20:32,605 WARN [geonetwork.schemamanager] - WARNING:
schema-substitutions.xml has wiped out XSD substitution list for
gml:VerticalDatum
2015-08-05 15:20:32,613 WARN [geonetwork.schemamanager] - WARNING:
schema-substitutions.xml has wiped out XSD substitution list for
gml:CoordinateSystemAxis
2015-08-05 15:20:32,618 WARN [geonetwork.schemamanager] - WARNING:
schema-substitutions.xml has wiped out XSD substitution list for
gml:VerticalCS
2015-08-05 15:20:32,627 WARN [geonetwork.schemamanager] - WARNING:
schema-substitutions.xml has wiped out XSD substitution list for
gml:CoordinateSystemAxis
2015-08-05 15:20:52,863 WARN [geonetwork.lucene] - Stopwords file with
incorrect ISO 639-2 language as filename: README
2015-08-05 15:21:01,567 WARN [geonetwork.svnmanager] - Recreating
subversion repository at E:\gn_data\data\data\metadata_subversion as
previous repository was empty
2015-08-05 15:27:38,176 ERROR [jeeves.service] - Exception when executing
service
2015-08-05 15:27:38,386 ERROR [jeeves.service] - (C) Exc :
MetadataNotFoundEx : Metadata not found
2015-08-05 15:27:38,507 ERROR [jeeves] - Error occurred within a
transaction
MetadataNotFoundEx : Metadata not found
at
org.fao.geonet.guiservices.metadata.GetRelated.exec(GetRelated.java:282)
at
jeeves.server.dispatchers.ServiceInfo.execService(ServiceInfo.java:226)
at
jeeves.server.dispatchers.ServiceInfo.noTransactionExec(ServiceInfo.java:141)
at
jeeves.server.dispatchers.ServiceInfo.access$000(ServiceInfo.java:45)
at
jeeves.server.dispatchers.ServiceInfo$1.doInTransaction(ServiceInfo.java:120)
at
jeeves.server.dispatchers.ServiceInfo$1.doInTransaction(ServiceInfo.java:117)
at
jeeves.transaction.TransactionManager.runInTransaction(TransactionManager.java:63)
at
jeeves.server.dispatchers.ServiceInfo.execServices(ServiceInfo.java:114)
at
jeeves.server.dispatchers.ServiceManager.dispatch(ServiceManager.java:442)
at
jeeves.server.dispatchers.ServiceManager.dispatch(ServiceManager.java:384)
at jeeves.server.JeevesEngine.dispatch(JeevesEngine.java:600)
at
org.fao.geonet.services.main.GenericController.dispatch(GenericController.java:106)
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.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:219)
at
org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)
at
org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
at
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:745)
at
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:686)
at
org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80)
at
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:925)
at
jeeves.config.springutil.JeevesDispatcherServlet.access$001(JeevesDispatcherServlet.java:17)
at
jeeves.config.springutil.JeevesDispatcherServlet$1.doInTransaction(JeevesDispatcherServlet.java:30)
at
jeeves.config.springutil.JeevesDispatcherServlet$1.doInTransaction(JeevesDispatcherServlet.java:27)
at
jeeves.transaction.TransactionManager.runInTransaction(TransactionManager.java:63)
at
jeeves.config.springutil.JeevesDispatcherServlet.doDispatch(JeevesDispatcherServlet.java:24)
at
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:856)
at
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:936)
at
org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:827)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:735)
at
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:812)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)
at
org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:684)
at
org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1496)
at
org.fao.geonet.monitor.webapp.WebappMetricsFilter.doFilter(WebappMetricsFilter.java:96)
at
org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1484)
at
org.fao.geonet.monitor.webapp.MetricsRegistryInitializerFilter.doFilter(MetricsRegistryInitializerFilter.java:31)
at
org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1484)
at
org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176)
at
org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145)
at
org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92)
at
org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:381)
at
org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1484)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
at
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
at
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:183)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
jeeves.config.springutil.PassthroughFilter.doFilter(PassthroughFilter.java:26)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
jeeves.config.springutil.MultiNodeAuthenticationFilter.doFilter(MultiNodeAuthenticationFilter.java:98)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)
at
org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)
at
org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343)
at
org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260)
at
jeeves.config.springutil.JeevesDelegatingFilterProxy.doFilter(JeevesDelegatingFilterProxy.java:64)
at
org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1484)
at
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at
org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1476)
at
org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:501)
at
org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:137)
at
org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:533)
at
org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:231)
at
org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1086)
at
org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:429)
at
org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:193)
at
org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1020)
at
org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135)
at
org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:255)
at
org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:154)
at
org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116)
at org.eclipse.jetty.server.Server.handle(Server.java:370)
at
org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:494)
at
org.eclipse.jetty.server.AbstractHttpConnection.headerComplete(AbstractHttpConnection.java:971)
at
org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.headerComplete(AbstractHttpConnection.java:1033)
at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:644)
at
org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235)
at
org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82)
at
org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:696)
at
org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:53)
at
org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608)
at
org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543)
at java.lang.Thread.run(Unknown Source)
----
Any ideas? I have wasted already two days trying to solve this, but
nothing
works. I tried re-building the index and deleting all database lock files.
I tried defining the data directory in config.xml. I checked srv.xml and
h2
database configuration line is uncommented by default.
Pekka
------------------------------------------------------------------------------
_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@anonymised.com
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at
http://sourceforge.net/projects/geonetwork
--
View this message in context: http://osgeo-org.1560.x6.nabble.com/Fwd-h2-database-issues-when-migrating-from-3-0-0-to-3-0-1-tp5218721p5218910.html
Sent from the GeoNetwork users mailing list archive at Nabble.com.
Hi,
2015-08-07 14:17 GMT+02:00 Pekka <pekka.hurskainen@anonymised.com>:
Hello,
I solved it. The problem was that I was totally unaware that the actual h2
database files are *not* in the geonetwork data folder, but in my case in
the jetty folder (...\geonetwork\jetty). By copying the backed-up *.db
files
back there I was able to restore my database. Quite confusing, though. Hope
this helps someone with similar problems.
Added to the doc
https://github.com/geonetwork/doc/blob/5a16d2b54345c08b0fd94ad4a0fc01e61f29b508/en/maintainer-guide/installing/configuring-database.rst
(which is currently being updated).
Francois
Pekka
Pekka wrote
> Dear list,
>
> I have some serious issues with my h2 database in geonetwork 3.0.1. I
> recently upgraded from 3.0.0 to 3.0.1. I'm using the jar installer with
> the
> default h2 database, since the amount of data I'm hosting is relatively
> small and I'm running geonetwork under Windows server 2008 R2 enterprise
> with only 2 GB RAM.
>
> I had a working h2 database in 3.0.0 and I backed it up before the
> upgrade.
> I removed the old GN install before installing 3.0.1. I'm pointing GN to
> the data directory in my startup.bat file:
> ----
> java -Xms48m -Xmx256m -Xss2M -XX:MaxPermSize=128m
> -Dgeonetwork.dir=e:\gn_data\data
> -Dmime-mappings=..\web\geonetwork\WEB-INF\mime-types.properties
> -DSTOP.PORT=8079 -Djava.awt.headless=true -DSTOP.KEY=geonetwork -jar
> start.jar
> ----
> When GN finally starts and I log in, I cannot see any of my metadata. It
> seems the database was not properly migrated to 3.0.1. From the Admin
> panel/Information, I can see that the data dir seems to be set correctly,
> however:
> ----
> Catalog information
> Thesaurus folder: E:\gn_data\data\config\codelist
> Configuration folder: E:\gn_data\data\config
> Data directory: E:\gn_data\data\data\metadata_data
> Formatter directory: E:\gn_data\data\data\formatter
> Resources folder: E:\gn_data\data\data\resources
> Standard folder: E:\gn_data\data\config\schema_plugins
> Subversion repository: E:\gn_data\data\data\metadata_subversion
>
> Database
> Status Database Opened Successfully
> JDBC URL jdbc:h2:geonetwork
>
> System information
> JVM version 1.8.0_45
> JVM name Java HotSpot(TM) Client VM
> JVM vendor Oracle Corporation
> Total free memory 57686
> Total memory 253440
> System architecture x86
> System name Windows Server 2008 R2
> XSLT factory de.fzi.dbs.xml.transform.CachingTransformerFactory
>
> In geonetwork.log, the following error appers:
>
> ----
> 2015-08-05 15:20:26,534 WARN [geonetwork.schemamanager] - Cannot resolve
> http://www.w3.org/2001/03/xml.xsd: will append last component to current
> path (not sure it will help though!)
> 2015-08-05 15:20:30,131 WARN [geonetwork.schemamanager] - WARNING:
> gco:Record is a global element without a type - assuming a string
> 2015-08-05 15:20:32,591 WARN [geonetwork.schemamanager] - WARNING:
> gco:Record is a global element without a type - assuming a string
> 2015-08-05 15:20:32,605 WARN [geonetwork.schemamanager] - WARNING:
> schema-substitutions.xml has wiped out XSD substitution list for
> gml:VerticalDatum
> 2015-08-05 15:20:32,613 WARN [geonetwork.schemamanager] - WARNING:
> schema-substitutions.xml has wiped out XSD substitution list for
> gml:CoordinateSystemAxis
> 2015-08-05 15:20:32,618 WARN [geonetwork.schemamanager] - WARNING:
> schema-substitutions.xml has wiped out XSD substitution list for
> gml:VerticalCS
> 2015-08-05 15:20:32,627 WARN [geonetwork.schemamanager] - WARNING:
> schema-substitutions.xml has wiped out XSD substitution list for
> gml:CoordinateSystemAxis
> 2015-08-05 15:20:52,863 WARN [geonetwork.lucene] - Stopwords file with
> incorrect ISO 639-2 language as filename: README
> 2015-08-05 15:21:01,567 WARN [geonetwork.svnmanager] - Recreating
> subversion repository at E:\gn_data\data\data\metadata_subversion as
> previous repository was empty
> 2015-08-05 15:27:38,176 ERROR [jeeves.service] - Exception when executing
> service
> 2015-08-05 15:27:38,386 ERROR [jeeves.service] - (C) Exc :
> MetadataNotFoundEx : Metadata not found
> 2015-08-05 15:27:38,507 ERROR [jeeves] - Error occurred within a
> transaction
> MetadataNotFoundEx : Metadata not found
> at
> org.fao.geonet.guiservices.metadata.GetRelated.exec(GetRelated.java:282)
> at
> jeeves.server.dispatchers.ServiceInfo.execService(ServiceInfo.java:226)
> at
>
jeeves.server.dispatchers.ServiceInfo.noTransactionExec(ServiceInfo.java:141)
> at
> jeeves.server.dispatchers.ServiceInfo.access$000(ServiceInfo.java:45)
> at
>
jeeves.server.dispatchers.ServiceInfo$1.doInTransaction(ServiceInfo.java:120)
> at
>
jeeves.server.dispatchers.ServiceInfo$1.doInTransaction(ServiceInfo.java:117)
> at
>
jeeves.transaction.TransactionManager.runInTransaction(TransactionManager.java:63)
> at
> jeeves.server.dispatchers.ServiceInfo.execServices(ServiceInfo.java:114)
> at
>
jeeves.server.dispatchers.ServiceManager.dispatch(ServiceManager.java:442)
> at
>
jeeves.server.dispatchers.ServiceManager.dispatch(ServiceManager.java:384)
> at jeeves.server.JeevesEngine.dispatch(JeevesEngine.java:600)
> at
>
org.fao.geonet.services.main.GenericController.dispatch(GenericController.java:106)
> 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.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:219)
> at
>
org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)
> at
>
org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
> at
>
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:745)
> at
>
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:686)
> at
>
org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80)
> at
>
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:925)
> at
>
jeeves.config.springutil.JeevesDispatcherServlet.access$001(JeevesDispatcherServlet.java:17)
> at
>
jeeves.config.springutil.JeevesDispatcherServlet$1.doInTransaction(JeevesDispatcherServlet.java:30)
> at
>
jeeves.config.springutil.JeevesDispatcherServlet$1.doInTransaction(JeevesDispatcherServlet.java:27)
> at
>
jeeves.transaction.TransactionManager.runInTransaction(TransactionManager.java:63)
> at
>
jeeves.config.springutil.JeevesDispatcherServlet.doDispatch(JeevesDispatcherServlet.java:24)
> at
>
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:856)
> at
>
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:936)
> at
>
org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:827)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:735)
> at
>
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:812)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)
> at
> org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:684)
> at
>
org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1496)
> at
>
org.fao.geonet.monitor.webapp.WebappMetricsFilter.doFilter(WebappMetricsFilter.java:96)
> at
>
org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1484)
> at
>
org.fao.geonet.monitor.webapp.MetricsRegistryInitializerFilter.doFilter(MetricsRegistryInitializerFilter.java:31)
> at
>
org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1484)
> at
>
org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176)
> at
> org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145)
> at
>
org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92)
> at
>
org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:381)
> at
>
org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1484)
> at
>
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
> at
>
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
> at
>
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
> at
>
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at
>
org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
> at
>
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at
>
org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)
> at
>
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at
>
org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
> at
>
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at
>
org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
> at
>
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at
>
org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:183)
> at
>
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at
>
org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150)
> at
>
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at
>
jeeves.config.springutil.PassthroughFilter.doFilter(PassthroughFilter.java:26)
> at
>
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at
>
jeeves.config.springutil.MultiNodeAuthenticationFilter.doFilter(MultiNodeAuthenticationFilter.java:98)
> at
>
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at
>
org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
> at
>
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at
>
org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
> at
>
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at
>
org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)
> at
>
org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)
> at
>
org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343)
> at
>
org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260)
> at
>
jeeves.config.springutil.JeevesDelegatingFilterProxy.doFilter(JeevesDelegatingFilterProxy.java:64)
> at
>
org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1484)
> at
>
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
> at
>
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
> at
>
org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1476)
> at
>
org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:501)
> at
>
org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:137)
> at
>
org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:533)
> at
>
org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:231)
> at
>
org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1086)
> at
> org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:429)
> at
>
org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:193)
> at
>
org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1020)
> at
>
org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135)
> at
>
org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:255)
> at
>
org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:154)
> at
>
org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116)
> at org.eclipse.jetty.server.Server.handle(Server.java:370)
> at
>
org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:494)
> at
>
org.eclipse.jetty.server.AbstractHttpConnection.headerComplete(AbstractHttpConnection.java:971)
> at
>
org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.headerComplete(AbstractHttpConnection.java:1033)
> at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:644)
> at
> org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235)
> at
>
org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82)
> at
>
org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:696)
> at
>
org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:53)
> at
>
org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608)
> at
>
org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543)
> at java.lang.Thread.run(Unknown Source)
>
> ----
>
> Any ideas? I have wasted already two days trying to solve this, but
> nothing
> works. I tried re-building the index and deleting all database lock
files.
> I tried defining the data directory in config.xml. I checked srv.xml and
> h2
> database configuration line is uncommented by default.
>
> Pekka
>
------------------------------------------------------------------------------
> _______________________________________________
> GeoNetwork-users mailing list
> GeoNetwork-users@anonymised.com
> https://lists.sourceforge.net/lists/listinfo/geonetwork-users
> GeoNetwork OpenSource is maintained at
> http://sourceforge.net/projects/geonetwork
--
View this message in context:
http://osgeo-org.1560.x6.nabble.com/Fwd-h2-database-issues-when-migrating-from-3-0-0-to-3-0-1-tp5218721p5218910.html
Sent from the GeoNetwork users mailing list archive at Nabble.com.
------------------------------------------------------------------------------
_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at
http://sourceforge.net/projects/geonetwork