[IGNITE-16397] Calcite engine. Failed to insert to table with two or more columns in primary keys

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Labels: calcite
• Assignee: Aleksey Plekhanov
• Reporter: Aleksey Plekhanov
• Created: 26/Jan/22 10:46
• Updated: 18/Feb/22 14:15
• Resolved: 08/Feb/22 10:36

Description

For example:

CREATE TABLE t(id INT, val VARCHAR, PRIMARY KEY(id, val));
INSERT INTO t(id, val) VALUES (1, 'a');

Fails with:

Failed processing message [senderId=8aec0b77-e5a2-49b5-8f77-0f0a77700001, msg=GridNearAtomicUpdateResponse [nodeId=235d7fbc-2a05-4d8b-8e37-3dff3980fc76, futId=1, errs=null, ret=GridCacheReturn [v=HashMap {SQL_PUBLIC_T_a975cf68_1738_43ca_915b_a52e6b89c049_KEY [idHash=1524322354, hash=-904731590, VAL=a, ID=1]=CacheInvokeResult [res=1, err=null]}, cacheObj=null, success=false, invokeRes=true, loc=true, cacheId=-1578586257], remapTopVer=null, nearUpdates=null, partId=552, mapping=ArrayList [], nodeLeft=false, super=GridCacheIdMessage [cacheId=-1578586257, super=GridCacheMessage [msgId=30, depInfo=null, lastAffChangedTopVer=AffinityTopologyVersion [topVer=-1, minorTopVer=0], err=null, skipPrepare=false]]]]
class org.apache.ignite.binary.BinaryInvalidTypeException: SQL_PUBLIC_T_a975cf68_1738_43ca_915b_a52e6b89c049_KEY
    at org.apache.ignite.internal.binary.BinaryContext.descriptorForTypeId(BinaryContext.java:719)
    at org.apache.ignite.internal.binary.BinaryReaderExImpl.deserialize0(BinaryReaderExImpl.java:1772)
    at org.apache.ignite.internal.binary.BinaryReaderExImpl.deserialize(BinaryReaderExImpl.java:1731)
    at org.apache.ignite.internal.binary.BinaryObjectImpl.deserializeValue(BinaryObjectImpl.java:826)
    at org.apache.ignite.internal.binary.BinaryObjectImpl.value(BinaryObjectImpl.java:156)
    at org.apache.ignite.internal.processors.cache.CacheObjectUtils.unwrapBinary(CacheObjectUtils.java:199)
    at org.apache.ignite.internal.processors.cache.CacheObjectUtils.unwrapBinariesIfNeeded(CacheObjectUtils.java:126)
    at org.apache.ignite.internal.processors.cache.CacheObjectUtils.unwrapBinary(CacheObjectUtils.java:205)
    at org.apache.ignite.internal.processors.cache.CacheObjectUtils.unwrapBinaryIfNeeded(CacheObjectUtils.java:78)
    at org.apache.ignite.internal.processors.cache.CacheObjectContext.unwrapBinaryIfNeeded(CacheObjectContext.java:138)
    at org.apache.ignite.internal.processors.cache.GridCacheContext.unwrapBinaryIfNeeded(GridCacheContext.java:1795)
    at org.apache.ignite.internal.processors.cache.GridCacheContext.unwrapBinaryIfNeeded(GridCacheContext.java:1782)
    at org.apache.ignite.internal.processors.cache.distributed.dht.atomic.GridNearAtomicAbstractUpdateFuture.completeFuture(GridNearAtomicAbstractUpdateFuture.java:353)
    at org.apache.ignite.internal.processors.cache.distributed.dht.atomic.GridNearAtomicUpdateFuture.onPrimaryResponse(GridNearAtomicUpdateFuture.java:467)
    at org.apache.ignite.internal.processors.cache.distributed.dht.atomic.GridDhtAtomicCache.processNearAtomicUpdateResponse(GridDhtAtomicCache.java:3207)
    at org.apache.ignite.internal.processors.cache.distributed.dht.atomic.GridDhtAtomicCache.access$500(GridDhtAtomicCache.java:143)
    at org.apache.ignite.internal.processors.cache.distributed.dht.atomic.GridDhtAtomicCache$6.apply(GridDhtAtomicCache.java:303)
    at org.apache.ignite.internal.processors.cache.distributed.dht.atomic.GridDhtAtomicCache$6.apply(GridDhtAtomicCache.java:298)
    at org.apache.ignite.internal.processors.cache.GridCacheIoManager.processMessage(GridCacheIoManager.java:1151)
    at org.apache.ignite.internal.processors.cache.GridCacheIoManager.onMessage0(GridCacheIoManager.java:592)
    at org.apache.ignite.internal.processors.cache.GridCacheIoManager.handleMessage(GridCacheIoManager.java:393)
    at org.apache.ignite.internal.processors.cache.GridCacheIoManager.handleMessage(GridCacheIoManager.java:319)
    at org.apache.ignite.internal.processors.cache.GridCacheIoManager.access$100(GridCacheIoManager.java:110)
    at org.apache.ignite.internal.processors.cache.GridCacheIoManager$1.onMessage(GridCacheIoManager.java:309)
    at org.apache.ignite.internal.managers.communication.GridIoManager.invokeListener(GridIoManager.java:1909)
    at org.apache.ignite.internal.managers.communication.GridIoManager.processRegularMessage0(GridIoManager.java:1530)
    at org.apache.ignite.internal.managers.communication.GridIoManager.access$5300(GridIoManager.java:243)
    at org.apache.ignite.internal.managers.communication.GridIoManager$9.execute(GridIoManager.java:1423)
    at org.apache.ignite.internal.managers.communication.TraceRunnable.run(TraceRunnable.java:55)
    at org.apache.ignite.internal.util.StripedExecutor$Stripe.body(StripedExecutor.java:569)
    at org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:125)
    at java.lang.Thread.run(Thread.java:748)
Caused by: java.lang.ClassNotFoundException: SQL_PUBLIC_T_a975cf68_1738_43ca_915b_a52e6b89c049_KEY
    at java.net.URLClassLoader.findClass(URLClassLoader.java:382)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:418)
    at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:355)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:351)
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Class.java:348)
    at org.apache.ignite.internal.util.IgniteUtils.forName(IgniteUtils.java:9209)
    at org.apache.ignite.internal.util.IgniteUtils.forName(IgniteUtils.java:9147)
    at org.apache.ignite.internal.MarshallerContextImpl.getClass(MarshallerContextImpl.java:376)
    at org.apache.ignite.internal.binary.BinaryContext.descriptorForTypeId(BinaryContext.java:695)
    ... 31 more

Issue Links

• blocks: IGNITE-15436 Calcite engine. Merge Calcite SQL Engine to Ignite 2.x
• is part of: IGNITE-12248 Apache Calcite based query execution engine
• links to: GitHub Pull Request #9804