[IGNITE-13230] Ignite duplicate key and NullPointerException

• Type: Bug
• Status: Patch Available
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 2.9.1
• Component/s: clients
• Assignee: Unassigned
• Reporter: Abhay
• Created: 09/Jul/20 07:36
• Updated: 31/Dec/21 10:42

Description

logFile.txt

Following steps lead to crash 

1. Start ignite node with persistence enabled , and use ODBC client like isql or pyignite
2. Fire create table command e.g
   1. CREATE TABLE ct_countries(id bigint PRIMARY KEY NOT NULL,code VARCHAR(50) DEFAULT '',name VARCHAR(100) DEFAULT '',timezonecheck VARCHAR DEFAULT 'N',dstcheck VARCHAR DEFAULT 'N',phonecodelength VARCHAR(20) DEFAULT '',status varchar(10) DEFAULT 'INACTIVE')WITH "template=partitioned,backups=0,affinity_key=id";
3. Create index without giving index name and create two such index
   1. CREATE INDEX ON ct_countries(code);
   2. CREATE INDEX ON ct_countries(name);

Restart ignite and it will crash with the follolwing logs 

java.lang.IllegalStateException: Duplicate key
at org.apache.ignite.cache.QueryEntity.checkIndexes(QueryEntity.java:233)
at org.apache.ignite.cache.QueryEntity.makePatch(QueryEntity.java:184)
at org.apache.ignite.internal.processors.query.QuerySchema.makePatch(QuerySchema.java:114)

 

java.lang.IllegalStateException: Duplicate key
at org.apache.ignite.cache.QueryEntity.checkIndexes(QueryEntity.java:233)
at org.apache.ignite.cache.QueryEntity.makePatch(QueryEntity.java:184)
at org.apache.ignite.internal.processors.query.QuerySchema.makePatch(QuerySchema.java:114)