You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Ignite TC Bot (Jira)" <ji...@apache.org> on 2020/07/08 12:23:00 UTC
[jira] [Commented] (IGNITE-13200) SQL create index on invalid data
type
[ https://issues.apache.org/jira/browse/IGNITE-13200?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17153552#comment-17153552 ]
Ignite TC Bot commented on IGNITE-13200:
----------------------------------------
{panel:title=Branch: [pull/7982/head] Base: [master] : Possible Blockers (1)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#F7D6C1}
{color:#d04437}PDS (Indexing){color} [[tests 0 Exit Code |https://ci.ignite.apache.org/viewLog.html?buildId=5448357]]
{panel}
{panel:title=Branch: [pull/7982/head] Base: [master] : New Tests (10)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}
{color:#00008b}Queries 2{color} [tests 2]
* {color:#013220}IgniteBinaryCacheQueryTestSuite2: CreateIndexOnInvalidDataTypeTest.testAddInvalidDataToIndex - PASSED{color}
* {color:#013220}IgniteBinaryCacheQueryTestSuite2: CreateIndexOnInvalidDataTypeTest.testCreateIndexOnInvalidData - PASSED{color}
{color:#00008b}Service Grid{color} [tests 4]
* {color:#013220}IgniteServiceGridTestSuite: ServiceDeploymentProcessIdSelfTest.topologyVersion[Test event=IgniteBiTuple [val1=DiscoveryCustomEvent [customMsg=ServiceChangeBatchRequest [id=987239a2371-79390b11-3632-4d85-9e95-a7e1376d8b8e, reqs=SingletonList [ServiceUndeploymentRequest []]], affTopVer=null, super=DiscoveryEvent [evtNode=a2d0036f-5db7-47db-b473-ca3e4ae0a2e6, topVer=0, nodeId8=a2d0036f, msg=null, type=DISCOVERY_CUSTOM_EVT, tstamp=1594147153797]], val2=AffinityTopologyVersion [topVer=7601406044098132898, minorTopVer=0]]] - PASSED{color}
* {color:#013220}IgniteServiceGridTestSuite: ServiceDeploymentProcessIdSelfTest.requestId[Test event=IgniteBiTuple [val1=DiscoveryCustomEvent [customMsg=ServiceChangeBatchRequest [id=987239a2371-79390b11-3632-4d85-9e95-a7e1376d8b8e, reqs=SingletonList [ServiceUndeploymentRequest []]], affTopVer=null, super=DiscoveryEvent [evtNode=a2d0036f-5db7-47db-b473-ca3e4ae0a2e6, topVer=0, nodeId8=a2d0036f, msg=null, type=DISCOVERY_CUSTOM_EVT, tstamp=1594147153797]], val2=AffinityTopologyVersion [topVer=7601406044098132898, minorTopVer=0]]] - PASSED{color}
* {color:#013220}IgniteServiceGridTestSuite: ServiceDeploymentProcessIdSelfTest.topologyVersion[Test event=IgniteBiTuple [val1=DiscoveryEvent [evtNode=4b15f9e7-19e4-4d4a-bb0f-1b2a62060f2b, topVer=0, nodeId8=a3f3937f, msg=, type=NODE_JOINED, tstamp=1594147153797], val2=AffinityTopologyVersion [topVer=-2262562060701615165, minorTopVer=0]]] - PASSED{color}
* {color:#013220}IgniteServiceGridTestSuite: ServiceDeploymentProcessIdSelfTest.requestId[Test event=IgniteBiTuple [val1=DiscoveryEvent [evtNode=4b15f9e7-19e4-4d4a-bb0f-1b2a62060f2b, topVer=0, nodeId8=a3f3937f, msg=, type=NODE_JOINED, tstamp=1594147153797], val2=AffinityTopologyVersion [topVer=-2262562060701615165, minorTopVer=0]]] - PASSED{color}
{color:#00008b}Service Grid (legacy mode){color} [tests 4]
* {color:#013220}IgniteServiceGridTestSuite: ServiceDeploymentProcessIdSelfTest.topologyVersion[Test event=IgniteBiTuple [val1=DiscoveryEvent [evtNode=7eb6990e-ed38-42dd-b1ae-f4cb8f33956e, topVer=0, nodeId8=7904b65e, msg=, type=NODE_JOINED, tstamp=1594127065232], val2=AffinityTopologyVersion [topVer=-590633232614788648, minorTopVer=0]]] - PASSED{color}
* {color:#013220}IgniteServiceGridTestSuite: ServiceDeploymentProcessIdSelfTest.requestId[Test event=IgniteBiTuple [val1=DiscoveryEvent [evtNode=7eb6990e-ed38-42dd-b1ae-f4cb8f33956e, topVer=0, nodeId8=7904b65e, msg=, type=NODE_JOINED, tstamp=1594127065232], val2=AffinityTopologyVersion [topVer=-590633232614788648, minorTopVer=0]]] - PASSED{color}
* {color:#013220}IgniteServiceGridTestSuite: ServiceDeploymentProcessIdSelfTest.topologyVersion[Test event=IgniteBiTuple [val1=DiscoveryCustomEvent [customMsg=ServiceChangeBatchRequest [id=1b48a692371-20368e63-1380-47f7-a15e-81c80f14d2d7, reqs=SingletonList [ServiceUndeploymentRequest []]], affTopVer=null, super=DiscoveryEvent [evtNode=6b04be02-f370-4c26-b3c0-934a046489b6, topVer=0, nodeId8=6b04be02, msg=null, type=DISCOVERY_CUSTOM_EVT, tstamp=1594127065232]], val2=AffinityTopologyVersion [topVer=8130921099951580873, minorTopVer=0]]] - PASSED{color}
* {color:#013220}IgniteServiceGridTestSuite: ServiceDeploymentProcessIdSelfTest.requestId[Test event=IgniteBiTuple [val1=DiscoveryCustomEvent [customMsg=ServiceChangeBatchRequest [id=1b48a692371-20368e63-1380-47f7-a15e-81c80f14d2d7, reqs=SingletonList [ServiceUndeploymentRequest []]], affTopVer=null, super=DiscoveryEvent [evtNode=6b04be02-f370-4c26-b3c0-934a046489b6, topVer=0, nodeId8=6b04be02, msg=null, type=DISCOVERY_CUSTOM_EVT, tstamp=1594127065232]], val2=AffinityTopologyVersion [topVer=8130921099951580873, minorTopVer=0]]] - PASSED{color}
{panel}
[TeamCity *--> Run :: All* Results|https://ci.ignite.apache.org/viewLog.html?buildId=5446157&buildTypeId=IgniteTests24Java8_RunAll]
> SQL create index on invalid data type
> -------------------------------------
>
> Key: IGNITE-13200
> URL: https://issues.apache.org/jira/browse/IGNITE-13200
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Affects Versions: 2.8.1
> Reporter: Taras Ledkov
> Assignee: Taras Ledkov
> Priority: Major
> Fix For: 2.9
>
>
> *Reproduce*
> - Create cache with value class
> {code}
> private static class Value {
> @QuerySqlField
> int val_int;
> java.util.Date val_date;
> }
> {code}
> - alter table with command
> {{ALTER TABLE TEST ADD COLUMN (VAL_DATE DATE)}}
> - try to create index with command
> {{CREATE INDEX TEST_VAL_DATE_IDX ON TEST(VAL_DATE)}}
> {{CorruptedTreeException}} is thrown, the node is stopped.
> {code}
> class org.apache.ignite.IgniteCheckedException: Runtime failure on row: Row@6a2853cd[ key: 0, val: org.apache.ignite.internal.processors.query.CreateIndexOnInvalidDataTypeTest$Value [idHash=1693430008, hash=1583713321, val_int=0, val_date=Thu Jan 01 03:00:00 MSK 1970] ][ 0, <value skipped on error: Failed to wrap object into H2 Value. java.util.Date cannot be cast to java.sql.Date> ]
> at org.apache.ignite.internal.processors.cache.persistence.tree.BPlusTree.doPut(BPlusTree.java:2438)
> at org.apache.ignite.internal.processors.cache.persistence.tree.BPlusTree.putx(BPlusTree.java:2388)
> at org.apache.ignite.internal.processors.query.h2.database.H2TreeIndex.putx(H2TreeIndex.java:434)
> at org.apache.ignite.internal.processors.query.h2.IndexBuildClosure.apply(IndexBuildClosure.java:52)
> at org.apache.ignite.internal.processors.query.schema.SchemaIndexCachePartitionWorker$SchemaIndexCacheVisitorClosureWrapper.apply(SchemaIndexCachePartitionWorker.java:298)
> at org.apache.ignite.internal.processors.cache.GridCacheMapEntry.updateIndex(GridCacheMapEntry.java:4494)
> at org.apache.ignite.internal.processors.query.schema.SchemaIndexCachePartitionWorker.processKey(SchemaIndexCachePartitionWorker.java:231)
> at org.apache.ignite.internal.processors.query.schema.SchemaIndexCachePartitionWorker.processPartition(SchemaIndexCachePartitionWorker.java:188)
> at org.apache.ignite.internal.processors.query.schema.SchemaIndexCachePartitionWorker.body(SchemaIndexCachePartitionWorker.java:127)
> at org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:120)
> 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)
> Caused by: class org.apache.ignite.internal.processors.query.IgniteSQLException: Failed to wrap object into H2 Value. java.util.Date cannot be cast to java.sql.Date
> at org.apache.ignite.internal.processors.query.h2.opt.H2CacheRow.wrap(H2CacheRow.java:177)
> at org.apache.ignite.internal.processors.query.h2.opt.H2CacheRow.getValue0(H2CacheRow.java:109)
> at org.apache.ignite.internal.processors.query.h2.opt.H2CacheRow.getValue(H2CacheRow.java:91)
> at org.apache.ignite.internal.processors.query.h2.database.io.AbstractH2ExtrasLeafIO.storeByOffset(AbstractH2ExtrasLeafIO.java:115)
> at org.apache.ignite.internal.processors.query.h2.database.io.AbstractH2ExtrasLeafIO.storeByOffset(AbstractH2ExtrasLeafIO.java:37)
> at org.apache.ignite.internal.processors.cache.persistence.tree.io.BPlusIO.store(BPlusIO.java:185)
> at org.apache.ignite.internal.processors.cache.persistence.tree.io.BPlusIO.insert(BPlusIO.java:272)
> at org.apache.ignite.internal.processors.cache.persistence.tree.BPlusTree$Put.insertSimple(BPlusTree.java:3685)
> at org.apache.ignite.internal.processors.cache.persistence.tree.BPlusTree$Put.insert(BPlusTree.java:3667)
> at org.apache.ignite.internal.processors.cache.persistence.tree.BPlusTree$Put.access$1900(BPlusTree.java:3539)
> at org.apache.ignite.internal.processors.cache.persistence.tree.BPlusTree$Insert.run0(BPlusTree.java:452)
> at org.apache.ignite.internal.processors.cache.persistence.tree.BPlusTree$Insert.run0(BPlusTree.java:433)
> at org.apache.ignite.internal.processors.cache.persistence.tree.BPlusTree$GetPageHandler.run(BPlusTree.java:5889)
> at org.apache.ignite.internal.processors.cache.persistence.tree.BPlusTree$GetPageHandler.run(BPlusTree.java:5875)
> at org.apache.ignite.internal.processors.cache.persistence.tree.util.PageHandler.writePage(PageHandler.java:360)
> at org.apache.ignite.internal.processors.cache.persistence.DataStructure.write(DataStructure.java:297)
> at org.apache.ignite.internal.processors.cache.persistence.tree.BPlusTree.access$11300(BPlusTree.java:99)
> at org.apache.ignite.internal.processors.cache.persistence.tree.BPlusTree$Put.tryInsert(BPlusTree.java:3859)
> at org.apache.ignite.internal.processors.cache.persistence.tree.BPlusTree$Put.access$7100(BPlusTree.java:3539)
> at org.apache.ignite.internal.processors.cache.persistence.tree.BPlusTree.putDown(BPlusTree.java:2803)
> at org.apache.ignite.internal.processors.cache.persistence.tree.BPlusTree.doPut(BPlusTree.java:2408)
> ... 12 more
> Caused by: java.lang.ClassCastException: java.util.Date cannot be cast to java.sql.Date
> at org.apache.ignite.internal.processors.query.h2.H2Utils.wrap(H2Utils.java:625)
> at org.apache.ignite.internal.processors.query.h2.opt.H2CacheRow.wrap(H2CacheRow.java:174)
> ... 32 more
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)