Log activity before getting the Error - takes more than 5 minutes
13:51:15.055 [main] DEBUG o.s.b.f.s.DefaultListableBeanFactory - Returning
cached instance of singleton bean 'neo4jTransactionManager'
13:51:15.055 [main] DEBUG o.s.t.jta.JtaTransactionManager - Participating
in existing transaction
*13:51:15.055* [main] DEBUG o.s.d.n.s.query.CypherQueryEngine - Executing
cypher query: match (n) where id(n)={nodeId} set
n:`__TYPE__Address`:`Address` params {nodeId=16927}
*13:56:08.833* [main] DEBUG o.s.d.n.s.query.CypherQueryEngine - Executing
cypher query: match (n) where id(n)={nodeId} return labels(n) as labels
params {nodeId=7}
13:56:08.833 [main] DEBUG o.s.d.n.s.query.CypherQueryEngine - Executing
cypher query: match (n) where id(n)={nodeId} return labels(n) as labels
params {nodeId=196}
13:56:08.833 [main] DEBUG o.s.d.n.s.query.CypherQueryEngine - Executing
cypher query: match (n) where id(n)={nodeId} return labels(n) as labels
params {nodeId=7}
13:56:27.792 [main] DEBUG o.s.d.n.s.query.CypherQueryEngine - Executing
cypher query: match (n) where id(n)={nodeId} return labels(n) as labels
params {nodeId=13}
On Tuesday, February 11, 2014 7:39:46 PM UTC-5, Pattabi wrote:
>
>
> Michael, sorry to bother, any idea on what i am doing wrong?. i see
> spatial root, layer and corresponding lucene index are created.
> i also tried the SDN again, removed the max heap size, changed the index
> type of Address from fulltext to Simple, don't ask me the relevance, tried
> all I possibly could. Have the dump as well, if it is of any use.7000
> address nodes got inserted. also, the withidistance works with SDN.
> thanks
>
>
> On Tuesday, February 11, 2014 5:08:45 AM UTC-5, Michael Hunger wrote:
>>
>> I meant for the withindistiance search.
>>
>> Michael
>>
>> Am 11.02.2014 um 10:58 schrieb Pattabi <[email protected]>:
>>
>> Please find below:
>>
>>
>> @SuppressWarnings("deprecation")
>> public void addSpatial(){
>> Transaction tx = graphService.beginTx();
>> IndexImplementation indexImpl = new SpatialIndexImplementation
>> (graphService);
>> Index<Node> nodeIndex = indexImpl.nodeIndex("Geocode",
>> SpatialIndexProvider.SIMPLE_WKT_CONFIG);
>> Label label = DynamicLabel.label("Address");
>> GlobalGraphOperations global = GlobalGraphOperations.at
>> (graphService);
>> Iterable<Node> allNodes = global.getAllNodesWithLabel(label);
>>
>> for(Node node: allNodes){
>>
>> try{
>> if(node.hasProperty("addressLine1")){
>> Node added = graphService.createNode();
>> added.setProperty("wkt", node.getProperty("wkt"));
>> System.out.println("Adding node " + added.getId());
>> nodeIndex.add(added, "addressLine1",
>> node.getProperty("addressLine1"));
>> }
>> }catch(Exception e){
>> e.printStackTrace(System.out);
>> tx.failure();
>> }
>> tx.success();
>>
>> }
>> tx.finish();
>>
>> }
>>
>>
>> On Tuesday, February 11, 2014 4:56:14 AM UTC-5, Michael Hunger wrote:
>>>
>>> Can you share the code you used?
>>>
>>> Thanks so much.
>>>
>>> Michael
>>>
>>> Am 11.02.2014 um 10:47 schrieb Pattabi <[email protected]>:
>>>
>>> Michael,
>>>
>>> Was able to add the nodes to layer.
>>> When I execute 'withinDistance' using the spatial index 'Geocode' I get
>>> index not found exception
>>> I notice that
>>> 'Geocode__neo4j-spatial__LayerNodeIndex__internal__spatialNodeLookup__'
>>> lucene index is created and is not empty. Did I miss anything?
>>>
>>>
>>>
>>> On Monday, February 10, 2014 2:13:15 PM UTC-5, Pattabi wrote:
>>>>
>>>> Thanks :) just noticed that it was a placebo. will fix.
>>>> the WKT is in this format - POINT( %f %.2f )
>>>> wkt field looks fine -
>>>>
>>>> On Monday, February 10, 2014 2:11:02 PM UTC-5, Michael Hunger wrote:
>>>>>
>>>>> You forgot tx.finish();
>>>>>
>>>>> What is the content of your wkt field?
>>>>>
>>>>> Transaction tx = graphService.beginTx();
>>>>> do-stuff
>>>>> tx.succes();
>>>>> tx.finish();
>>>>>
>>>>> Am 10.02.2014 um 19:49 schrieb Pattabi <[email protected]>:
>>>>>
>>>>> > Thanks Michael. I will try this.
>>>>> >
>>>>> > I tried the following and getting an error while adding the
>>>>> SpatialDatabaseRecord to the Spatial Index Impl.
>>>>> > The error is
>>>>> > Caused by: javax.transaction.RollbackException: Tx status is:
>>>>> STATUS_MARKED_ROLLBACK
>>>>> > at
>>>>> org.neo4j.kernel.impl.transaction.TransactionImpl.enlistResource(TransactionImpl.java:237)
>>>>>
>>>>>
>>>>> > at
>>>>> org.neo4j.kernel.impl.transaction.xaframework.XaConnectionHelpImpl.enlistResource(XaConnectionHelpImpl.java:103)
>>>>>
>>>>>
>>>>> > at
>>>>> org.neo4j.kernel.impl.index.IndexConnectionBroker.acquireResourceConnection(IndexConnectionBroker.java:56)
>>>>>
>>>>>
>>>>> > ... 6 more
>>>>> >
>>>>> >
>>>>> >
>>>>> > IndexImplementation indexImpl = new
>>>>> SpatialIndexImplementation (graphService);
>>>>> > Index<Node> nodeIndex = indexImpl.nodeIndex("Geocode",
>>>>> SpatialIndexProvider.SIMPLE_WKT_CONFIG);
>>>>> > Iterable<Node> allNodes = graphService.getAllNodes();
>>>>> > for(Node node: allNodes){
>>>>> > Transaction tx = graphService.beginTx();
>>>>> > try{
>>>>> > if(node.hasProperty("addressLine1")){
>>>>> > Node added = graphService.createNode();
>>>>> > added.setProperty("wkt", node.getProperty("wkt"));
>>>>> > System.out.println("Adding node " + added.getId());
>>>>> > nodeIndex.add(added, "addressLine1",
>>>>> node.getProperty("addressLine1"));
>>>>> > }
>>>>> > }catch(Exception e){
>>>>> > e.printStackTrace(System.out);
>>>>> > tx.failure();
>>>>> > }
>>>>> > tx.success();
>>>>> >
>>>>> >
>>>>> > On Monday, February 10, 2014 1:12:16 PM UTC-5, Michael Hunger wrote:
>>>>> > Just with the core api.
>>>>> >
>>>>> > db.index().forNodes("spatial").add(node, "dummy","dummy");
>>>>> >
>>>>> > depending on the config
>>>>> >
>>>>> > node has to have geo-properties (lat, lon)
>>>>> > or
>>>>> > node has to have geo-properties (point in well-known-text (wkt))
>>>>> >
>>>>> > SDN uses this index-config:
>>>>> >
>>>>> > MapUtil.stringMap(
>>>>> > IndexManager.PROVIDER, "spatial",
>>>>> "geometry_type" , "point","wkt","wkt")
>>>>> >
>>>>> > and "wkt" as property-name for the well-known-text-point.
>>>>> >
>>>>> >
>>>>> http://docs.spring.io/spring-data/data-neo4j/docs/2.3.x/reference/htmlsingle/#reference_spatial
>>>>>
>>>>> >
>>>>> > Michael
>>>>> >
>>>>> > Am 10.02.2014 um 19:08 schrieb Pattabi <[email protected]>:
>>>>> >
>>>>> >> MH,
>>>>> >> If I have to replicate the SDN's behavior for adding a Node to
>>>>> spatial index, do I need to do all the following?
>>>>> >> Create a Geom node, add to index by calling add(node,key, value)
>>>>> and create relationship types - RTREE_REFERENCE?
>>>>> >>
>>>>> >>
>>>>> >>
>>>>> >>
>>>>> >> On Friday, February 7, 2014 9:05:29 PM UTC-5, Michael Hunger wrote:
>>>>> >> How many nodes are you adding at once and how big is your Java
>>>>> heap?
>>>>> >>
>>>>> >> You don't have to create a layer, the index automatically creates
>>>>> the layer.
>>>>> >>
>>>>> >> Michael
>>>>> >>
>>>>> >> Am 07.02.2014 um 21:55 schrieb Pattabi <[email protected]>:
>>>>> >>
>>>>> >>> Getting this error while loading bean which has a 'wkt/spatial'
>>>>> index
>>>>> >>> using - Spring data-neo4j 3.0.0.BUILD-20140207...., neo4j 2.0.0
>>>>> >>>
>>>>> >>> Note: I do not know how to do batch insert a spatial (as it is my
>>>>> understanding that I need to create a layer with that WKT, add these
>>>>> nodes
>>>>> to that layer)
>>>>> >>> I looked at the code 'SpatialIndexImplementation' nodeIndex. If I
>>>>> have to do batch insert, adding to this index would be sufficient?
>>>>> >>>
>>>>> >>> The stack trace is as shown below:
>>>>> >>>
>>>>> >>> Exception in thread "main" java.lang.OutOfMemoryError: Java heap
>>>>> space
>>>>> >>> at
>>>>> org.apache.lucene.store.BufferedIndexOutput.<init>(BufferedIndexOutput.java:26)
>>>>>
>>>>>
>>>>> >>> at
>>>>> org.apache.lucene.store.FSDirectory$FSIndexOutput.<init>(FSDirectory.java:438)
>>>>>
>>>>>
>>>>> >>> at
>>>>> org.apache.lucene.store.FSDirectory.createOutput(FSDirectory.java:306)
>>>>> >>> at
>>>>> org.apache.lucene.index.FormatPostingsPositionsWriter.<init>(FormatPostingsPositionsWriter.java:43)
>>>>>
>>>>>
>>>>> >>> at
>>>>> org.apache.lucene.index.FormatPostingsDocsWriter.<init>(FormatPostingsDocsWriter.java:57)
>>>>>
>>>>>
>>>>> >>> at
>>>>> org.apache.lucene.index.FormatPostingsTermsWriter.<init>(FormatPostingsTermsWriter.java:33)
>>>>>
>>>>>
>>>>> >>> at
>>>>> org.apache.lucene.index.FormatPostingsFieldsWriter.<init>(FormatPostingsFieldsWriter.java:51)
>>>>>
>>>>>
>>>>> >>> at
>>>>> org.apache.lucene.index.FreqProxTermsWriter.flush(FreqProxTermsWriter.java:85)
>>>>>
>>>>>
>>>>> >>> at org.apache.lucene.index.TermsHash.flush(TermsHash.java:113)
>>>>> >>> at
>>>>> org.apache.lucene.index.DocInverter.flush(DocInverter.java:70)
>>>>> >>> at
>>>>> org.apache.lucene.index.DocFieldProcessor.flush(DocFieldProcessor.java:60)
>>>>>
>>>>> >>> at
>>>>> org.apache.lucene.index.DocumentsWriter.flush(DocumentsWriter.java:581)
>>>>> >>> at
>>>>> org.apache.lucene.index.IndexWriter.doFlush(IndexWriter.java:3587)
>>>>> >>> at
>>>>> org.apache.lucene.index.IndexWriter.flush(IndexWriter.java:3552)
>>>>> >>> at
>>>>> org.apache.lucene.index.IndexWriter.getReader(IndexWriter.java:450)
>>>>> >>> at
>>>>> org.apache.lucene.index.IndexWriter.getReader(IndexWriter.java:399)
>>>>> >>> at
>>>>> org.apache.lucene.index.DirectoryReader.doOpenFromWriter(DirectoryReader.java:413)
>>>>>
>>>>>
>>>>> >>> at
>>>>> org.apache.lucene.index.DirectoryReader.doOpenIfChanged(DirectoryReader.java:432)
>>>>>
>>>>>
>>>>> >>> at
>>>>> org.apache.lucene.index.DirectoryReader.doOpenIfChanged(DirectoryReader.java:375)
>>>>>
>>>>>
>>>>> >>> at
>>>>> org.apache.lucene.index.DirectoryReader.doOpenIfChanged(DirectoryReader.java:392)
>>>>>
>>>>>
>>>>> >>> at
>>>>> org.apache.lucene.index.IndexReader.openIfChanged(IndexReader.java:634)
>>>>> >>> at
>>>>> org.neo4j.index.impl.lucene.LuceneDataSource.refreshSearcher(LuceneDataSource.java:505)
>>>>>
>>>>>
>>>>> >>> at
>>>>> org.neo4j.index.impl.lucene.LuceneDataSource.refreshSearcherIfNeeded(LuceneDataSource.java:635)
>>>>>
>>>>>
>>>>> >>> at
>>>>> org.neo4j.index.impl.lucene.LuceneDataSource.getIndexSearcher(LuceneDataSource.java:577)
>>>>>
>>>>>
>>>>> >>> at
>>>>> org.neo4j.index.impl.lucene.LuceneIndex.query(LuceneIndex.java:293)
>>>>> >>> at
>>>>> org.neo4j.index.impl.lucene.LuceneIndex.query(LuceneIndex.java:251)
>>>>> >>> at
>>>>> org.neo4j.gis.spatial.indexprovider.LayerNodeIndex.findExistingNode(LayerNodeIndex.java:152)
>>>>>
>>>>>
>>>>> >>> at
>>>>> org.neo4j.gis.spatial.indexprovider.LayerNodeIndex.add(LayerNodeIndex.java:132)
>>>>>
>>>>>
>>>>> >>> at
>>>>> org.neo4j.gis.spatial.indexprovider.LayerNodeIndex.add(LayerNodeIndex.java:1)
>>>>>
>>>>>
>>>>> >>> at
>>>>> org.springframework.data.neo4j.fieldaccess.IndexingPropertyFieldAccessorListenerFactory$IndexingPropertyFieldAccessorListener.valueChanged(IndexingPropertyFieldAccessorListenerFactory.java:86)
>>>>>
>>>>>
>>>>> >>> at
>>>>> org.springframework.data.neo4j.fieldaccess.DefaultEntityState.notifyListeners(DefaultEntityState.java:137)
>>>>>
>>>>>
>>>>> >>> at
>>>>> org.springframework.data.neo4j.fieldaccess.DefaultEntityState.setValue(DefaultEntityState.java:114)
>>>>>
>>>>>
>>>>> >>>
>>>>> >>>
>>>>> >>> --
>>>>> >>> You received this message because you are subscribed to the Google
>>>>> Groups "Neo4j" group.
>>>>> >>> To unsubscribe from this group and stop receiving emails from it,
>>>>> send an email to [email protected].
>>>>> >>> For more options, visit https://groups.google.com/groups/opt_out.
>>>>> >>
>>>>> >>
>>>>> >> --
>>>>> >> You received this message because you are subscribed to the Google
>>>>> Groups "Neo4j" group.
>>>>> >> To unsubscribe from this group and stop receiving emails from it,
>>>>> send an email to [email protected].
>>>>> >> For more options, visit https://groups.google.com/groups/opt_out.
>>>>> >
>>>>> >
>>>>> > --
>>>>> > You received this message because you are subscribed to the Google
>>>>> Groups "Neo4j" group.
>>>>> > To unsubscribe from this group and stop receiving emails from it,
>>>>> send an email to [email protected].
>>>>> > For more options, visit https://groups.google.com/groups/opt_out.
>>>>>
>>>>>
>>> --
>>> You received this message because you are subscribed to the Google
>>> Groups "Neo4j" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to [email protected].
>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>
>>>
>>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "Neo4j" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to [email protected].
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
--
You received this message because you are subscribed to the Google Groups
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
