[Neo4j] Re: Neo4j 3.5 fails creaing index

2019-01-03 Thread unrealadmin23 via Neo4j
version 3.5.

Yes, I saw the mod for this.  

On Wednesday, 2 January 2019 19:55:03 UTC, Mattias Finné wrote:
>
> Unfortunately the exception message doesn't include vital information 
> about node and value. This has recently been added and will be available in 
> an upcoming release. Which version are you on?
>
> On Friday, December 28, 2018 at 4:14:32 PM UTC+1, unreal...@googlemail.com 
> wrote:
>>
>>
>> Hi,
>>
>> A little while after 
>> neo4j> CREATE INDEX ON :Temporal_Event(name);
>>
>> I got:
>>
>> 2018-12-28 08:37:05.791+ INFO  Remote interface available at 
>> http://localhost:7474/
>> 2018-12-28 11:11:46.963+ ERROR Client triggered an unexpected error 
>> [Neo.DatabaseError.General.IndexCorruptionDetected]: Index `Index( GENERAL, 
>> :Temporal_Event(name) )` has failed. Drop and recreate it to get it back 
>> online. Actual failure:
>> ==
>> java.lang.RuntimeException: java.lang.IllegalArgumentException: Index 
>> key-value size it to large. Please see index documentation for limitations. 
>> | 
>> GB+Tree[file:/SSD/data/databases/neo4j-dbpedia-AI.db/schema/index/native-btree-1.0/8/index-8,
>>  
>> layout:GenericLayout[version:0.5, identifier:5643935348791705600, 
>> fixedSize:false], generation:2/4]
>> at 
>> org.neo4j.kernel.impl.index.schema.WorkSyncedNativeIndexPopulator.add(WorkSyncedNativeIndexPopulator.java:94)
>> at 
>> org.neo4j.kernel.impl.api.index.BatchingMultipleIndexPopulator.lambda$flush$2(BatchingMultipleIndexPopulator.java:170)
>> at 
>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
>> at 
>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
>> at java.lang.Thread.run(Thread.java:748)
>> at 
>> org.neo4j.helpers.NamedThreadFactory$2.run(NamedThreadFactory.java:122)
>> Caused by: java.lang.IllegalArgumentException: Index key-value size it to 
>> large. Please see index documentation for limitations. | 
>> GB+Tree[file:/SSD/data/databases/neo4j-dbpedia-AI.db/schema/index/native-btree-1.0/8/index-8,
>>  
>> layout:GenericLayout[version:0.5, identifier:5643935348791705600, 
>> fixedSize:false], generation:2/4]
>> at 
>> org.neo4j.index.internal.gbptree.TreeNodeDynamicSize.validateKeyValueSize(TreeNodeDynamicSize.java:369)
>> at 
>> org.neo4j.index.internal.gbptree.InternalTreeLogic.insert(InternalTreeLogic.java:353)
>> at 
>> org.neo4j.index.internal.gbptree.GBPTree$SingleWriter.merge(GBPTree.java:1281)
>> at 
>> org.neo4j.kernel.impl.index.schema.NativeIndexUpdater.processAdd(NativeIndexUpdater.java:133)
>> at 
>> org.neo4j.kernel.impl.index.schema.NativeIndexUpdater.processUpdate(NativeIndexUpdater.java:88)
>> at 
>> org.neo4j.kernel.impl.index.schema.NativeIndexPopulator.processUpdates(NativeIndexPopulator.java:286)
>> at 
>> org.neo4j.kernel.impl.index.schema.NativeIndexPopulator.add(NativeIndexPopulator.java:164)
>> at 
>> org.neo4j.kernel.impl.index.schema.WorkSyncedNativeIndexPopulator$IndexUpdateApply.process(WorkSyncedNativeIndexPopulator.java:144)
>> at 
>> org.neo4j.kernel.impl.index.schema.WorkSyncedNativeIndexPopulator$IndexUpdateWork.apply(WorkSyncedNativeIndexPopulator.java:168)
>> at 
>> org.neo4j.kernel.impl.index.schema.WorkSyncedNativeIndexPopulator$IndexUpdateWork.apply(WorkSyncedNativeIndexPopulator.java:148)
>> at 
>> org.neo4j.util.concurrent.WorkSync.doSynchronizedWork(WorkSync.java:231)
>> at org.neo4j.util.concurrent.WorkSync.tryDoWork(WorkSync.java:157)
>> at org.neo4j.util.concurrent.WorkSync.apply(WorkSync.java:91)
>> at 
>> org.neo4j.kernel.impl.index.schema.WorkSyncedNativeIndexPopulator.add(WorkSyncedNativeIndexPopulator.java:81)
>> ... 5 more
>>
>> ==, reference 40308cf1-008c-4580-a7d4-19610e3a712d.
>>
>>
>> I dropped the index as per the message.
>>
>> How do I delete the offending node such that the index will work ?
>>
>> Thanks.
>>
>

-- 
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 neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[Neo4j] Re: Neo4j 3.5 fails creaing index

2019-01-02 Thread 'Mattias Finné' via Neo4j
Unfortunately the exception message doesn't include vital information about 
node and value. This has recently been added and will be available in an 
upcoming release. Which version are you on?

On Friday, December 28, 2018 at 4:14:32 PM UTC+1, unreal...@googlemail.com 
wrote:
>
>
> Hi,
>
> A little while after 
> neo4j> CREATE INDEX ON :Temporal_Event(name);
>
> I got:
>
> 2018-12-28 08:37:05.791+ INFO  Remote interface available at 
> http://localhost:7474/
> 2018-12-28 11:11:46.963+ ERROR Client triggered an unexpected error 
> [Neo.DatabaseError.General.IndexCorruptionDetected]: Index `Index( GENERAL, 
> :Temporal_Event(name) )` has failed. Drop and recreate it to get it back 
> online. Actual failure:
> ==
> java.lang.RuntimeException: java.lang.IllegalArgumentException: Index 
> key-value size it to large. Please see index documentation for limitations. 
> | 
> GB+Tree[file:/SSD/data/databases/neo4j-dbpedia-AI.db/schema/index/native-btree-1.0/8/index-8,
>  
> layout:GenericLayout[version:0.5, identifier:5643935348791705600, 
> fixedSize:false], generation:2/4]
> at 
> org.neo4j.kernel.impl.index.schema.WorkSyncedNativeIndexPopulator.add(WorkSyncedNativeIndexPopulator.java:94)
> at 
> org.neo4j.kernel.impl.api.index.BatchingMultipleIndexPopulator.lambda$flush$2(BatchingMultipleIndexPopulator.java:170)
> at 
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
> at 
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
> at java.lang.Thread.run(Thread.java:748)
> at 
> org.neo4j.helpers.NamedThreadFactory$2.run(NamedThreadFactory.java:122)
> Caused by: java.lang.IllegalArgumentException: Index key-value size it to 
> large. Please see index documentation for limitations. | 
> GB+Tree[file:/SSD/data/databases/neo4j-dbpedia-AI.db/schema/index/native-btree-1.0/8/index-8,
>  
> layout:GenericLayout[version:0.5, identifier:5643935348791705600, 
> fixedSize:false], generation:2/4]
> at 
> org.neo4j.index.internal.gbptree.TreeNodeDynamicSize.validateKeyValueSize(TreeNodeDynamicSize.java:369)
> at 
> org.neo4j.index.internal.gbptree.InternalTreeLogic.insert(InternalTreeLogic.java:353)
> at 
> org.neo4j.index.internal.gbptree.GBPTree$SingleWriter.merge(GBPTree.java:1281)
> at 
> org.neo4j.kernel.impl.index.schema.NativeIndexUpdater.processAdd(NativeIndexUpdater.java:133)
> at 
> org.neo4j.kernel.impl.index.schema.NativeIndexUpdater.processUpdate(NativeIndexUpdater.java:88)
> at 
> org.neo4j.kernel.impl.index.schema.NativeIndexPopulator.processUpdates(NativeIndexPopulator.java:286)
> at 
> org.neo4j.kernel.impl.index.schema.NativeIndexPopulator.add(NativeIndexPopulator.java:164)
> at 
> org.neo4j.kernel.impl.index.schema.WorkSyncedNativeIndexPopulator$IndexUpdateApply.process(WorkSyncedNativeIndexPopulator.java:144)
> at 
> org.neo4j.kernel.impl.index.schema.WorkSyncedNativeIndexPopulator$IndexUpdateWork.apply(WorkSyncedNativeIndexPopulator.java:168)
> at 
> org.neo4j.kernel.impl.index.schema.WorkSyncedNativeIndexPopulator$IndexUpdateWork.apply(WorkSyncedNativeIndexPopulator.java:148)
> at 
> org.neo4j.util.concurrent.WorkSync.doSynchronizedWork(WorkSync.java:231)
> at org.neo4j.util.concurrent.WorkSync.tryDoWork(WorkSync.java:157)
> at org.neo4j.util.concurrent.WorkSync.apply(WorkSync.java:91)
> at 
> org.neo4j.kernel.impl.index.schema.WorkSyncedNativeIndexPopulator.add(WorkSyncedNativeIndexPopulator.java:81)
> ... 5 more
>
> ==, reference 40308cf1-008c-4580-a7d4-19610e3a712d.
>
>
> I dropped the index as per the message.
>
> How do I delete the offending node such that the index will work ?
>
> Thanks.
>

-- 
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 neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.