Re: [Neo4j] PropertyRecord claims to have more property blocks than can fit in a record

['Mattias Finné' via Neo4j]

Hello, did you by chance migrate this database from standard record format 
to aligned record format? If you're uncertain rather can you share the 
debug.log. There was a recent fix in this area which could manifest in this 
error.

On Monday, December 7, 2020 at 1:04:24 PM UTC+1 Michael Hunger wrote:

> Just create a copy.
>
> Join our new Community Site & Forum 
>
> On Mon, Dec 7, 2020 at 12:56 PM Filippo Grazioli  
> wrote:
>
>> Hello Michael,  thanks for your reply.
>>
>> Version is 4.1.1.
>>
>> Could you please clarify how neo4j-admin copy creates a fixed version?
>>
>> Is there some specific flag I should use to fix it, or simply create a 
>> copy?
>>
>> Thanks,
>> Filippo
>>
>> Il giorno mercoledì 25 novembre 2020 alle 12:13:12 UTC+1 Michael Hunger 
>> ha scritto:
>>
>>> Hi,
>>>
>>> seems to be a issue with your store. 
>>> What is your database version?
>>> Perhaps neo4j-admin copy would help for creating a fixed version of the 
>>> store.
>>>
>>> Michael
>>>
>>> Join our new Community Site & Forum 
>>>
>>>
>>> On Wed, Nov 25, 2020 at 12:10 PM Filippo Grazioli  
>>> wrote:
>>>

 Hello,

 I have a graph with 300k nodes and 4M relationships.

 I'd like to query all triples:
 MATCH p=()-[]->() RETURN p 

 I get the following error:
 Neo.DatabaseError.Statement.ExecutionFailed org.neo4j.io.pagecache
 .CursorException: PropertyRecord claims to have more property blocks 
 than can fit in a record 

 Do you know what goes wrong? 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+un...@googlegroups.com.
 To view this discussion on the web visit 
 https://groups.google.com/d/msgid/neo4j/c180b9f7-ada9-4453-b9e9-1875bc2aac28n%40googlegroups.com
  
 
 .

>>> -- 
>> 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+un...@googlegroups.com.
>>
> To view this discussion on the web visit 
>> https://groups.google.com/d/msgid/neo4j/582f76c6-3a9e-4c0e-84a4-1fc665a06040n%40googlegroups.com
>>  
>> 
>> .
>>
>

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/neo4j/8d34e148-431d-4eca-85a7-cca419d17df0n%40googlegroups.com.

Re: [Neo4j] neo4j 4.1.3 -> Where condition with count not working as expected

['Shanthi Viswanathan' via Neo4j]

Thanks much Michael - your explanation makes sense.

I am using dynamic relationship because this is part of a cypher where my
role  (the "Test" I have in my example) is dynamic.

On Mon, Dec 7, 2020 at 7:02 AM 'Michael Hunger' via Neo4j <
neo4j@googlegroups.com> wrote:

> Best to send questions like this to community.neo4j.com
>
> In general if you aggregate, you must not add the thing you want to count
> / aggregate on as an aggregation key, you can use collect on those.
>
> MATCH (echk:REC {id: 'abcdef'})
> OPTIONAL MATCH (p:Person) WHERE p.name CONTAINS 'Shirley'
> WITH collect(p) as people, echk, count(p) as personcnt where personcnt=1
> UNWIND people as p
> MERGE (p)-[:TEST]->(echk)
>
> You don't need apoc.merge.relationship for your case you can just use
> cypher.
>
>
>
> Join our new Community Site & Forum 
>
>
> On Mon, Dec 7, 2020 at 12:55 PM 'Shanthi Viswanathan' via Neo4j <
> neo4j@googlegroups.com> wrote:
>
>> I am using neo4j 4.1.3. I have 2 labels : Person and Rec. I need to
>> create a relationship between these 2 only when there exists exactly one
>> person with that last name. When I run the below, relationships are created
>> for all persons with that last name. My code is below:
>>
>> MATCH (echk:REC {id: 'abcdef'}) OPTIONAL MATCH (p:Person) WHERE p.name
>> CONTAINS 'Shirley' WITH p, echk, count(p) as personcnt where personcnt=1
>> CALL apoc.merge.relationship(p, 'Test', {}, {}, echk, {}) YIELD rel RETURN
>> p, echk, rel
>>
>> I have 33 people with "Shirley' and 33 relationships are getting created
>> with that REC. However, there should be no relationship because personcnt
>> <> 1. When I just write
>> OPTIONAL MATCH (p:Person) WHERE p.name CONTAINS 'Shirley'  return
>> count(p) -> I get 33 as the value. I am not sure why my where condition is
>> not kicking in.
>>
>>
>> --
>> 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.
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/neo4j/9f5043ee-fec0-4f0b-94e4-85d9b6ee8a45n%40googlegroups.com
>> 
>> .
>>
> --
> 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.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/neo4j/CAKZwuWkzsZDo0pXf1FFyshohXFqOd2%2BAjDimCfGyU0v8q7QjFQ%40mail.gmail.com
> 
> .
>

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/neo4j/CAC8vypZXEd6p%2Bgvdic_i_Odhw2022C8iAOVF_ZpeL2Q-%2BLiGRQ%40mail.gmail.com.

Re: [Neo4j] Design Patterns

['Michael Hunger' via Neo4j]

There is a public graph modeling training that you can take and a follow up
(implementing graph models)

https://neo4j.com/graphacademy/training-gdm-40/enrollment/

Join our new Community Site & Forum 


On Mon, Dec 7, 2020 at 12:55 PM mr. Doctor  wrote:

> I'm starting to work with the neo4j and I need info about Design Patterns
> for this database. I would be glad to have any information on the topic.
>
> --
> 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.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/neo4j/98a6b661-cc8a-464a-ac45-e11570317e04n%40googlegroups.com
> 
> .
>

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/neo4j/CAKZwuWnkdQX3f39dWOtcejnvFRCE9C1CEi7qM_EQxw0Xgr3Sgg%40mail.gmail.com.

Re: [Neo4j] PropertyRecord claims to have more property blocks than can fit in a record

['Michael Hunger' via Neo4j]

Just create a copy.

Join our new Community Site & Forum 


On Mon, Dec 7, 2020 at 12:56 PM Filippo Grazioli 
wrote:

> Hello Michael,  thanks for your reply.
>
> Version is 4.1.1.
>
> Could you please clarify how neo4j-admin copy creates a fixed version?
>
> Is there some specific flag I should use to fix it, or simply create a
> copy?
>
> Thanks,
> Filippo
>
> Il giorno mercoledì 25 novembre 2020 alle 12:13:12 UTC+1 Michael Hunger ha
> scritto:
>
>> Hi,
>>
>> seems to be a issue with your store.
>> What is your database version?
>> Perhaps neo4j-admin copy would help for creating a fixed version of the
>> store.
>>
>> Michael
>>
>> Join our new Community Site & Forum 
>>
>>
>> On Wed, Nov 25, 2020 at 12:10 PM Filippo Grazioli 
>> wrote:
>>
>>>
>>> Hello,
>>>
>>> I have a graph with 300k nodes and 4M relationships.
>>>
>>> I'd like to query all triples:
>>> MATCH p=()-[]->() RETURN p
>>>
>>> I get the following error:
>>> Neo.DatabaseError.Statement.ExecutionFailed org.neo4j.io.pagecache
>>> .CursorException: PropertyRecord claims to have more property blocks
>>> than can fit in a record
>>>
>>> Do you know what goes wrong? 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+un...@googlegroups.com.
>>> To view this discussion on the web visit
>>> https://groups.google.com/d/msgid/neo4j/c180b9f7-ada9-4453-b9e9-1875bc2aac28n%40googlegroups.com
>>> 
>>> .
>>>
>> --
> 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.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/neo4j/582f76c6-3a9e-4c0e-84a4-1fc665a06040n%40googlegroups.com
> 
> .
>

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/neo4j/CAKZwuWm1s6QT0Qp8Msigx-8aHrXJdZofDgG-b9OGGhfSOxxQ6g%40mail.gmail.com.

Re: [Neo4j] neo4j 4.1.3 -> Where condition with count not working as expected

['Michael Hunger' via Neo4j]

Best to send questions like this to community.neo4j.com

In general if you aggregate, you must not add the thing you want to count /
aggregate on as an aggregation key, you can use collect on those.

MATCH (echk:REC {id: 'abcdef'})
OPTIONAL MATCH (p:Person) WHERE p.name CONTAINS 'Shirley'
WITH collect(p) as people, echk, count(p) as personcnt where personcnt=1
UNWIND people as p
MERGE (p)-[:TEST]->(echk)

You don't need apoc.merge.relationship for your case you can just use
cypher.



Join our new Community Site & Forum 


On Mon, Dec 7, 2020 at 12:55 PM 'Shanthi Viswanathan' via Neo4j <
neo4j@googlegroups.com> wrote:

> I am using neo4j 4.1.3. I have 2 labels : Person and Rec. I need to create
> a relationship between these 2 only when there exists exactly one person
> with that last name. When I run the below, relationships are created for
> all persons with that last name. My code is below:
>
> MATCH (echk:REC {id: 'abcdef'}) OPTIONAL MATCH (p:Person) WHERE p.name
> CONTAINS 'Shirley' WITH p, echk, count(p) as personcnt where personcnt=1
> CALL apoc.merge.relationship(p, 'Test', {}, {}, echk, {}) YIELD rel RETURN
> p, echk, rel
>
> I have 33 people with "Shirley' and 33 relationships are getting created
> with that REC. However, there should be no relationship because personcnt
> <> 1. When I just write
> OPTIONAL MATCH (p:Person) WHERE p.name CONTAINS 'Shirley'  return
> count(p) -> I get 33 as the value. I am not sure why my where condition is
> not kicking in.
>
>
> --
> 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.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/neo4j/9f5043ee-fec0-4f0b-94e4-85d9b6ee8a45n%40googlegroups.com
> 
> .
>

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/neo4j/CAKZwuWkzsZDo0pXf1FFyshohXFqOd2%2BAjDimCfGyU0v8q7QjFQ%40mail.gmail.com.

Re: [Neo4j] PropertyRecord claims to have more property blocks than can fit in a record

[Filippo Grazioli]

Hello Michael,  thanks for your reply.

Version is 4.1.1.

Could you please clarify how neo4j-admin copy creates a fixed version?

Is there some specific flag I should use to fix it, or simply create a copy?

Thanks,
Filippo

Il giorno mercoledì 25 novembre 2020 alle 12:13:12 UTC+1 Michael Hunger ha 
scritto:

> Hi,
>
> seems to be a issue with your store. 
> What is your database version?
> Perhaps neo4j-admin copy would help for creating a fixed version of the 
> store.
>
> Michael
>
> Join our new Community Site & Forum 
>
>
> On Wed, Nov 25, 2020 at 12:10 PM Filippo Grazioli  
> wrote:
>
>>
>> Hello,
>>
>> I have a graph with 300k nodes and 4M relationships.
>>
>> I'd like to query all triples:
>> MATCH p=()-[]->() RETURN p 
>>
>> I get the following error:
>> Neo.DatabaseError.Statement.ExecutionFailed org.neo4j.io.pagecache
>> .CursorException: PropertyRecord claims to have more property blocks than 
>> can fit in a record 
>>
>> Do you know what goes wrong? 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+un...@googlegroups.com.
>> To view this discussion on the web visit 
>> https://groups.google.com/d/msgid/neo4j/c180b9f7-ada9-4453-b9e9-1875bc2aac28n%40googlegroups.com
>>  
>> 
>> .
>>
>

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/neo4j/582f76c6-3a9e-4c0e-84a4-1fc665a06040n%40googlegroups.com.

[Neo4j] Design Patterns

[mr. Doctor]

I'm starting to work with the neo4j and I need info about Design Patterns 
for this database. I would be glad to have any information on the topic.

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/neo4j/98a6b661-cc8a-464a-ac45-e11570317e04n%40googlegroups.com.

[Neo4j] neo4j 4.1.3 -> Where condition with count not working as expected

['Shanthi Viswanathan' via Neo4j]

I am using neo4j 4.1.3. I have 2 labels : Person and Rec. I need to create 
a relationship between these 2 only when there exists exactly one person 
with that last name. When I run the below, relationships are created for 
all persons with that last name. My code is below: 

MATCH (echk:REC {id: 'abcdef'}) OPTIONAL MATCH (p:Person) WHERE p.name 
CONTAINS 'Shirley' WITH p, echk, count(p) as personcnt where personcnt=1 
CALL apoc.merge.relationship(p, 'Test', {}, {}, echk, {}) YIELD rel RETURN 
p, echk, rel

I have 33 people with "Shirley' and 33 relationships are getting created 
with that REC. However, there should be no relationship because personcnt 
<> 1. When I just write 
OPTIONAL MATCH (p:Person) WHERE p.name CONTAINS 'Shirley'  return count(p) 
-> I get 33 as the value. I am not sure why my where condition is not 
kicking in. 
 

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/neo4j/9f5043ee-fec0-4f0b-94e4-85d9b6ee8a45n%40googlegroups.com.