Re: [GeoNetwork-devel] Multinode Geonetwork

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 454-5900

Hi Francois,

Thanks for checking- I can confirm that in a local install, running under
jetty, it works using the default h2 database, but also that it works using
postgresql. I'll do some comparisons between my two installations to see if
I can isolate the difference.

Regards

Jo

On Tue, Oct 11, 2016 at 12:24 PM, Francois Prunayre <fx....@gm...>
wrote:

> Hi,
>
> 2016-10-11 10:34 GMT+02:00 Jo Cook <jo...@as...>:
>
>> Hi All,
>>
>> Some further research on this- and two issues that might be related. The
>> errors I'm seeing seem to be related to the Lucene Directory, which is
>> currently specified in the tomcat options. My databases are both
>> postgresql, and I'm seeing a lot of errors in the log files related to
>> postgresql:
>>
>> 2016-10-10 14:56:18,131 DEBUG [org.springframework.orm.jpa.JpaTransactionManager]
>> - Resuming suspended transaction after completion of inner transaction
>> 2016-10-10 14:56:18,132 DEBUG [org.springframework.jdbc.datasource.DataSourceUtils]
>> - Setting JDBC Connection [jdbc:postgresql://[myhost]:5432/[mydatabase],
>> UserName=geonetwork3, PostgreSQL Native Driver] read-only
>> 2016-10-10 14:56:18,132 DEBUG [org.springframework.jdbc.datasource.DataSourceUtils]
>> - Could not set JDBC Connection read-only
>> org.postgresql.util.PSQLException: Cannot change transaction read-only
>> property in the middle of a transaction.
>>
>> Could these be related to the multinode errors I'm seeing?
>>
>> Has anyone successfully set up a Geonetwork 3.2.x multinode server, with
>> postgresql as the back end database that could give me some pointers?
>>
>
> After a quick test on H2 it's working fine. Not tested with postgres.
>
> Francois
>
>
>
>>
>> Thanks
>>
>> Jo
>>
>>
>> On Fri, Oct 7, 2016 at 3:03 PM, Jo Cook <jo...@as...>
>> wrote:
>>
>>> Hi Developers,
>>>
>>> I'm forwarding this to the dev list to see if it gets a response- I'm
>>> really keen to get Multinode Geonetwork working and am happy to test/expand
>>> documentation if necessary.
>>>
>>> Thanks
>>>
>>> Jo
>>>
>>> ---------- Forwarded message ----------
>>> From: Jo Cook <jo...@as...>
>>> Date: Thu, Oct 6, 2016 at 4:04 PM
>>> Subject: Multinode Geonetwork
>>> To: "geo...@li..." <
>>> geo...@li...>
>>>
>>>
>>> Hi Developers,
>>>
>>> I'm testing Geonetwork 3.2.x, specifically in multinode format. I've
>>> configured a second node using these instructions: http://geonetwor
>>> k-opensource.org/manuals/trunk/eng/users/maintainer-guide/in
>>> stalling/using-multinode-mode.html
>>>
>>> I've done this manually (ie adding a node to WEB-INF/web.xml and a node
>>> in config-node copied from the example xml in the link above), and also
>>> using the shell script.
>>>
>>> The second database (postgres) is populated on a tomcat restart and I
>>> can visit the home page for the second node, which shows no metadata, as
>>> expected. When I sign in I get the following error in the browser:
>>>
>>> Raised exception while starting the application. Fix the error and
>>> restart.
>>>
>>> Message
>>> org.apache.lucene.store.LockObtainFailedException: Lock obtain timed
>>> out: NativeFSLock@/data/geonetwork/lucene_dir/taxonomy/write.lock
>>> Handler
>>> org.fao.geonet.Geonetwork
>>> Exception
>>> java.lang.RuntimeException: org.apache.lucene.store.LockObtainFailedException:
>>> Lock obtain timed out: NativeFSLock@/data/geonetwork/
>>> lucene_dir/taxonomy/write.lock
>>> Stack
>>> java.lang.RuntimeException: org.apache.lucene.store.LockObtainFailedException:
>>> Lock obtain timed out: NativeFSLock@/data/geonetwork/
>>> lucene_dir/taxonomy/write.lock
>>> at org.fao.geonet.kernel.search.index.LuceneIndexLanguageTracke
>>> r.lazyInit(LuceneIndexLanguageTracker.java:124)
>>> at org.fao.geonet.kernel.search.index.LuceneIndexLanguageTracke
>>> r.acquire(LuceneIndexLanguageTracker.java:187)
>>> at org.fao.geonet.kernel.search.SearchManager.getIndexReader(Se
>>> archManager.java:1210)
>>> at org.fao.geonet.kernel.search.SearchManager.getNewIndexReader
>>> (SearchManager.java:1215)
>>> at org.fao.geonet.kernel.search.SearchManager.getDocsChangeDate
>>> (SearchManager.java:945)
>>> at org.fao.geonet.kernel.DataManager.init(DataManager.java:346)
>>> at org.fao.geonet.Geonetwork.start(Geonetwork.java:345)
>>> at jeeves.server.JeevesEngine.initAppHandler(JeevesEngine.java:448)
>>> at jeeves.server.JeevesEngine.init(JeevesEngine.java:191)
>>> at jeeves.server.sources.http.JeevesServlet.init(JeevesServlet.java:84)
>>> at javax.servlet.GenericServlet.init(GenericServlet.java:158)
>>> at org.apache.catalina.core.StandardWrapper.initServlet(Standar
>>> dWrapper.java:1238)
>>> at org.apache.catalina.core.StandardWrapper.loadServlet(Standar
>>> dWrapper.java:1151)
>>> at org.apache.catalina.core.StandardWrapper.load(StandardWrappe
>>> r.java:1038)
>>> at org.apache.catalina.core.StandardContext.loadOnStartup(Stand
>>> ardContext.java:4997)
>>> at org.apache.catalina.core.StandardContext.startInternal(Stand
>>> ardContext.java:5289)
>>> at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:147)
>>> at org.apache.catalina.core.ContainerBase.addChildInternal(Cont
>>> ainerBase.java:725)
>>> at org.apache.catalina.core.ContainerBase.addChild(ContainerBas
>>> e.java:701)
>>> at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
>>> at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:939)
>>> at org.apache.catalina.startup.HostConfig$DeployWar.run(HostCon
>>> fig.java:1812)
>>> at java.util.concurrent.Executors$RunnableAdapter.call(Executor
>>> s.java:511)
>>> at java.util.concurrent.FutureTask.run(FutureTask.java:266)
>>> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPool
>>> Executor.java:1142)
>>> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoo
>>> lExecutor.java:617)
>>> at java.lang.Thread.run(Thread.java:745)
>>> Caused by: org.apache.lucene.store.LockObtainFailedException: Lock
>>> obtain timed out: NativeFSLock@/data/geonetwork/
>>> lucene_dir/taxonomy/write.lock
>>> at org.apache.lucene.store.Lock.obtain(Lock.java:89)
>>> at org.apache.lucene.index.IndexWriter.<init>(IndexWriter.java:724)
>>> at org.apache.lucene.facet.taxonomy.directory.DirectoryTaxonomy
>>> Writer.openIndexWriter(DirectoryTaxonomyWriter.java:265)
>>> at org.apache.lucene.facet.taxonomy.directory.DirectoryTaxonomy
>>> Writer.<init>(DirectoryTaxonomyWriter.java:192)
>>> at org.apache.lucene.facet.taxonomy.directory.DirectoryTaxonomy
>>> Writer.<init>(DirectoryTaxonomyWriter.java:315)
>>> at org.apache.lucene.facet.taxonomy.directory.DirectoryTaxonomy
>>> Writer.<init>(DirectoryTaxonomyWriter.java:332)
>>> at org.fao.geonet.kernel.search.index.TaxonomyIndexTracker.init
>>> (TaxonomyIndexTracker.java:69)
>>> at org.fao.geonet.kernel.search.index.TaxonomyIndexTracker.<ini
>>> t>(TaxonomyIndexTracker.java:63)
>>> at org.fao.geonet.kernel.search.index.LuceneIndexLanguageTracke
>>> r.lazyInit(LuceneIndexLanguageTracker.java:115)
>>> ... 26 more
>>>
>>> This is also shown in catalina.out. At this point, the URL has dropped
>>> back to the default node rather than the new node. At this point I can't
>>> sign in to either node. I have tried renaming the lucene directory since
>>> that's reported in the error message, and the only way I can sign in to the
>>> default node is to remove the second node from config-node and restart. The
>>> existing records get reindexed and everything works OK.
>>>
>>> What else should I be doing to make this work?
>>>
>>> Thanks
>>>
>>> Jo
>>>
>>>
>>> --
>>> *Jo Cook*
>>> t:+44 7930 524 155/twitter:@archaeogeek
>>>
>>>
>>>
>>>
>>> --
>>> *Jo Cook*
>>> t:+44 7930 524 155/twitter:@archaeogeek
>>>
>>>
>>
>>
>> --
>> *Jo Cook*
>> t:+44 7930 524 155/twitter:@archaeogeek
>>
>>
>> --
>> Astun Technology Ltd, The Coach House, 17 West Street, Epsom, Surrey,
>> KT18 7RL, UK
>> t:+44 1372 744 009 w: astuntechnology.com twitter:@astuntech
>> <https://twitter.com/astuntech>
>>
>> iShare - enterprise geographic intelligence platform
>> <https://astuntechnology.com/ishare/>
>> GeoServer, PostGIS and QGIS training
>> <https://astuntechnology.com/services/#training>
>> Helpdesk and customer portal
>> <http://support.astuntechnology.com/support/login>
>>
>> Company registration no. 5410695. Registered in England and Wales.
>> Registered office: 120 Manor Green Road, Epsom, Surrey, KT19 8LN VAT no.
>> 864201149.
>>
>> ------------------------------------------------------------
>> ------------------
>> Check out the vibrant tech community on one of the world's most
>> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
>> _______________________________________________
>> GeoNetwork-devel mailing list
>> Geo...@li...
>> https://lists.sourceforge.net/lists/listinfo/geonetwork-devel
>> GeoNetwork OpenSource is maintained at http://sourceforge.net/project
>> s/geonetwork
>>
>
>

-- 
*Jo Cook*
t:+44 7930 524 155/twitter:@archaeogeek

-- 
--
Astun Technology Ltd, The Coach House, 17 West Street, Epsom, Surrey, KT18 
7RL, UK 
t:+44 1372 744 009 w: astuntechnology.com twitter:@astuntech 
<https://twitter.com/astuntech>

iShare - enterprise geographic intelligence platform 
<https://astuntechnology.com/ishare/>
GeoServer, PostGIS and QGIS training 
<https://astuntechnology.com/services/#training>
Helpdesk and customer portal 
<http://support.astuntechnology.com/support/login>

Company registration no. 5410695. Registered in England and Wales. 
Registered office: 120 Manor Green Road, Epsom, Surrey, KT19 8LN VAT no. 
864201149.