Adding this property for key [~T$SchemaName] and value [...] violates a uniqueness constraint


Matteo Lissandrini <matteo.l...@...>
 

Hello,

I'm having this error thrown at me during loading of a large graph (dbpedia)
and I cannot understand what is it complaining about.

Can you help me?

Thanks,
Matteo


Boxuan Li <libo...@...>
 

Hi Matteo,

The error log is indeed a bit counter-intuitive. Looks like your program was trying to create a new property (or label), but the property (or label) already existed in the database.

You may want to check your program. I would suggest checking the existence of property (label) before trying to create one.

Regards,
Boxuan

On Friday, August 7, 2020 at 11:21:07 PM UTC+8 Matteo Lissandrini wrote:
Hello,

I'm having this error thrown at me during loading of a large graph (dbpedia)
and I cannot understand what is it complaining about.

Can you help me?

Thanks,
Matteo


Matteo Lissandrini <matteo.l...@...>
 

Hi Boxuan,
thanks for the reply.

This is the full error:

org.janusgraph.core.SchemaViolationException: Adding this property for key [~T$SchemaName] and value [rtns8_designation] violates a uniqueness constraint [SystemIndex#~T$SchemaName]

I actually run a distinct before creating the schema
here is the relevant piece of code
https://pastebin.com/BaYc5ej5

So I am quite sure I am not creating it twice. Any ideas?

Thanks,
Matteo





On Sunday, 9 August 2020 at 04:57:43 UTC+2 li...@... wrote:
Hi Matteo,

The error log is indeed a bit counter-intuitive. Looks like your program was trying to create a new property (or label), but the property (or label) already existed in the database.

You may want to check your program. I would suggest checking the existence of property (label) before trying to create one.

Regards,
Boxuan
On Friday, August 7, 2020 at 11:21:07 PM UTC+8 Matteo Lissandrini wrote:
Hello,

I'm having this error thrown at me during loading of a large graph (dbpedia)
and I cannot understand what is it complaining about.

Can you help me?

Thanks,
Matteo


BO XUAN LI <libo...@...>
 

Are you running the code against a clean database? Does the property already exist before you run this piece of code?

On Aug 11, 2020, at 12:14 AM, Matteo Lissandrini <matteo.l...@...> wrote:

Hi Boxuan,
thanks for the reply.

This is the full error:

org.janusgraph.core.SchemaViolationException: Adding this property for key [~T$SchemaName] and value [rtns8_designation] violates a uniqueness constraint [SystemIndex#~T$SchemaName]

I actually run a distinct before creating the schema
here is the relevant piece of code

So I am quite sure I am not creating it twice. Any ideas?

Thanks,
Matteo





On Sunday, 9 August 2020 at 04:57:43 UTC+2 libo...@connect.hku.hk wrote:
Hi Matteo,

The error log is indeed a bit counter-intuitive. Looks like your program was trying to create a new property (or label), but the property (or label) already existed in the database.

You may want to check your program. I would suggest checking the existence of property (label) before trying to create one.

Regards,
Boxuan
On Friday, August 7, 2020 at 11:21:07 PM UTC+8 Matteo Lissandrini wrote:
Hello,

I'm having this error thrown at me during loading of a large graph (dbpedia)
and I cannot understand what is it complaining about.

Can you help me?

Thanks,
Matteo

-- 
You received this message because you are subscribed to the Google Groups "JanusGraph users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to janusgra...@....
To view this discussion on the web visit https://groups.google.com/d/msgid/janusgraph-users/87e2ab14-63d5-4e3d-afa5-a020adad8dfan%40googlegroups.com.


Matteo Lissandrini <matteo.l...@...>
 

I am loading a graph from scratch in an empty database.
Could it be that there may be an edge label and a property name with the same name?


On Monday, 10 August 2020 at 18:21:36 UTC+2 li...@... wrote:
Are you running the code against a clean database? Does the property already exist before you run this piece of code?

On Aug 11, 2020, at 12:14 AM, Matteo Lissandrini <matt...@...> wrote:

Hi Boxuan,
thanks for the reply.

This is the full error:

org.janusgraph.core.SchemaViolationException: Adding this property for key [~T$SchemaName] and value [rtns8_designation] violates a uniqueness constraint [SystemIndex#~T$SchemaName]

I actually run a distinct before creating the schema
here is the relevant piece of code

So I am quite sure I am not creating it twice. Any ideas?

Thanks,
Matteo





On Sunday, 9 August 2020 at 04:57:43 UTC+2 libo...@connect.hku.hk wrote:
Hi Matteo,

The error log is indeed a bit counter-intuitive. Looks like your program was trying to create a new property (or label), but the property (or label) already existed in the database.

You may want to check your program. I would suggest checking the existence of property (label) before trying to create one.

Regards,
Boxuan
On Friday, August 7, 2020 at 11:21:07 PM UTC+8 Matteo Lissandrini wrote:
Hello,

I'm having this error thrown at me during loading of a large graph (dbpedia)
and I cannot understand what is it complaining about.

Can you help me?

Thanks,
Matteo

-- 
You received this message because you are subscribed to the Google Groups "JanusGraph users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to janusgr...@....
To view this discussion on the web visit https://groups.google.com/d/msgid/janusgraph-users/87e2ab14-63d5-4e3d-afa5-a020adad8dfan%40googlegroups.com.


Boxuan Li <libo...@...>
 

Yeah, that's possible. You need to make sure properties and labels don't have the same name.
On Tuesday, August 11, 2020 at 12:25:46 AM UTC+8 Matteo Lissandrini wrote:

I am loading a graph from scratch in an empty database.
Could it be that there may be an edge label and a property name with the same name?


On Monday, 10 August 2020 at 18:21:36 UTC+2 li...@... wrote:
Are you running the code against a clean database? Does the property already exist before you run this piece of code?

On Aug 11, 2020, at 12:14 AM, Matteo Lissandrini <matt...@...> wrote:

Hi Boxuan,
thanks for the reply.

This is the full error:

org.janusgraph.core.SchemaViolationException: Adding this property for key [~T$SchemaName] and value [rtns8_designation] violates a uniqueness constraint [SystemIndex#~T$SchemaName]

I actually run a distinct before creating the schema
here is the relevant piece of code

So I am quite sure I am not creating it twice. Any ideas?

Thanks,
Matteo





On Sunday, 9 August 2020 at 04:57:43 UTC+2 libo...@connect.hku.hk wrote:
Hi Matteo,

The error log is indeed a bit counter-intuitive. Looks like your program was trying to create a new property (or label), but the property (or label) already existed in the database.

You may want to check your program. I would suggest checking the existence of property (label) before trying to create one.

Regards,
Boxuan
On Friday, August 7, 2020 at 11:21:07 PM UTC+8 Matteo Lissandrini wrote:
Hello,

I'm having this error thrown at me during loading of a large graph (dbpedia)
and I cannot understand what is it complaining about.

Can you help me?

Thanks,
Matteo

-- 
You received this message because you are subscribed to the Google Groups "JanusGraph users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to janusgr...@....
To view this discussion on the web visit https://groups.google.com/d/msgid/janusgraph-users/87e2ab14-63d5-4e3d-afa5-a020adad8dfan%40googlegroups.com.


Matteo Lissandrini <matteo.l...@...>
 

So there is no way to have a graph with a property name and an edge label with the same name?


On Monday, 10 August 2020 at 18:28:48 UTC+2 li...@... wrote:
Yeah, that's possible. You need to make sure properties and labels don't have the same name.
On Tuesday, August 11, 2020 at 12:25:46 AM UTC+8 Matteo Lissandrini wrote:
I am loading a graph from scratch in an empty database.
Could it be that there may be an edge label and a property name with the same name?


On Monday, 10 August 2020 at 18:21:36 UTC+2 li...@... wrote:
Are you running the code against a clean database? Does the property already exist before you run this piece of code?

On Aug 11, 2020, at 12:14 AM, Matteo Lissandrini <matt...@...> wrote:

Hi Boxuan,
thanks for the reply.

This is the full error:

org.janusgraph.core.SchemaViolationException: Adding this property for key [~T$SchemaName] and value [rtns8_designation] violates a uniqueness constraint [SystemIndex#~T$SchemaName]

I actually run a distinct before creating the schema
here is the relevant piece of code

So I am quite sure I am not creating it twice. Any ideas?

Thanks,
Matteo





On Sunday, 9 August 2020 at 04:57:43 UTC+2 libo...@connect.hku.hk wrote:
Hi Matteo,

The error log is indeed a bit counter-intuitive. Looks like your program was trying to create a new property (or label), but the property (or label) already existed in the database.

You may want to check your program. I would suggest checking the existence of property (label) before trying to create one.

Regards,
Boxuan
On Friday, August 7, 2020 at 11:21:07 PM UTC+8 Matteo Lissandrini wrote:
Hello,

I'm having this error thrown at me during loading of a large graph (dbpedia)
and I cannot understand what is it complaining about.

Can you help me?

Thanks,
Matteo

-- 
You received this message because you are subscribed to the Google Groups "JanusGraph users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to janusgr...@....
To view this discussion on the web visit https://groups.google.com/d/msgid/janusgraph-users/87e2ab14-63d5-4e3d-afa5-a020adad8dfan%40googlegroups.com.


BO XUAN LI <libo...@...>
 

On Aug 11, 2020, at 1:03 AM, Matteo Lissandrini <matteo.l...@...> wrote:

So there is no way to have a graph with a property name and an edge label with the same name?

On Monday, 10 August 2020 at 18:28:48 UTC+2 libo...@connect.hku.hk wrote:
Yeah, that's possible. You need to make sure properties and labels don't have the same name.
On Tuesday, August 11, 2020 at 12:25:46 AM UTC+8 Matteo Lissandrini wrote:
I am loading a graph from scratch in an empty database.
Could it be that there may be an edge label and a property name with the same name?


On Monday, 10 August 2020 at 18:21:36 UTC+2 li...@... wrote:
Are you running the code against a clean database? Does the property already exist before you run this piece of code?

On Aug 11, 2020, at 12:14 AM, Matteo Lissandrini <matt...@...> wrote:

Hi Boxuan,
thanks for the reply.

This is the full error:

org.janusgraph.core.SchemaViolationException: Adding this property for key [~T$SchemaName] and value [rtns8_designation] violates a uniqueness constraint [SystemIndex#~T$SchemaName]

I actually run a distinct before creating the schema
here is the relevant piece of code

So I am quite sure I am not creating it twice. Any ideas?

Thanks,
Matteo





On Sunday, 9 August 2020 at 04:57:43 UTC+2 libo...@connect.hku.hk wrote:
Hi Matteo,

The error log is indeed a bit counter-intuitive. Looks like your program was trying to create a new property (or label), but the property (or label) already existed in the database.

You may want to check your program. I would suggest checking the existence of property (label) before trying to create one.

Regards,
Boxuan
On Friday, August 7, 2020 at 11:21:07 PM UTC+8 Matteo Lissandrini wrote:
Hello,

I'm having this error thrown at me during loading of a large graph (dbpedia)
and I cannot understand what is it complaining about.

Can you help me?

Thanks,
Matteo

-- 
You received this message because you are subscribed to the Google Groups "JanusGraph users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to janusgr...@....
To view this discussion on the web visit https://groups.google.com/d/msgid/janusgraph-users/87e2ab14-63d5-4e3d-afa5-a020adad8dfan%40googlegroups.com.


-- 
You received this message because you are subscribed to the Google Groups "JanusGraph users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to janusgra...@....
To view this discussion on the web visit https://groups.google.com/d/msgid/janusgraph-users/3fc2b92b-936c-4a2c-bec0-c6134a749370n%40googlegroups.com.


Matteo Lissandrini <matteo.l...@...>
 

Is this just an arbitrary design decision or is it technically impossible in this architecture?


On Tuesday, 11 August 2020 at 03:19:16 UTC+2 li...@... wrote:
On Aug 11, 2020, at 1:03 AM, Matteo Lissandrini <matt...@...> wrote:

So there is no way to have a graph with a property name and an edge label with the same name?

On Monday, 10 August 2020 at 18:28:48 UTC+2 libo...@connect.hku.hk wrote:
Yeah, that's possible. You need to make sure properties and labels don't have the same name.
On Tuesday, August 11, 2020 at 12:25:46 AM UTC+8 Matteo Lissandrini wrote:
I am loading a graph from scratch in an empty database.
Could it be that there may be an edge label and a property name with the same name?


On Monday, 10 August 2020 at 18:21:36 UTC+2 li...@... wrote:
Are you running the code against a clean database? Does the property already exist before you run this piece of code?

On Aug 11, 2020, at 12:14 AM, Matteo Lissandrini <matt...@...> wrote:

Hi Boxuan,
thanks for the reply.

This is the full error:

org.janusgraph.core.SchemaViolationException: Adding this property for key [~T$SchemaName] and value [rtns8_designation] violates a uniqueness constraint [SystemIndex#~T$SchemaName]

I actually run a distinct before creating the schema
here is the relevant piece of code

So I am quite sure I am not creating it twice. Any ideas?

Thanks,
Matteo





On Sunday, 9 August 2020 at 04:57:43 UTC+2 libo...@connect.hku.hk wrote:
Hi Matteo,

The error log is indeed a bit counter-intuitive. Looks like your program was trying to create a new property (or label), but the property (or label) already existed in the database.

You may want to check your program. I would suggest checking the existence of property (label) before trying to create one.

Regards,
Boxuan
On Friday, August 7, 2020 at 11:21:07 PM UTC+8 Matteo Lissandrini wrote:
Hello,

I'm having this error thrown at me during loading of a large graph (dbpedia)
and I cannot understand what is it complaining about.

Can you help me?

Thanks,
Matteo

-- 
You received this message because you are subscribed to the Google Groups "JanusGraph users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to janusgr...@....
To view this discussion on the web visit https://groups.google.com/d/msgid/janusgraph-users/87e2ab14-63d5-4e3d-afa5-a020adad8dfan%40googlegroups.com.


-- 
You received this message because you are subscribed to the Google Groups "JanusGraph users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to janusgr...@....