[
https://issues.apache.org/jira/browse/IGNITE-24212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17927169#comment-17927169
]
Ignite TC Bot commented on IGNITE-24212:
----------------------------------------
{panel:title=Branch: [pull/11824/head] Base: [master] : No blockers
found!|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}{panel}
{panel:title=Branch: [pull/11824/head] Base: [master] : New Tests
(36)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}
{color:#00008b}Continuous Query 4{color} [[tests
36|https://ci2.ignite.apache.org/viewLog.html?buildId=8308351]]
* {color:#013220}IgniteCacheQuerySelfTestSuite6:
RejoinWithLostDynamicDdlTest.testRejoinWithLostDynamicSchemaPersistentActive[gridToRestart=0,
recreateTable=false] - PASSED{color}
* {color:#013220}IgniteCacheQuerySelfTestSuite6:
RejoinWithLostDynamicDdlTest.testRejoinWithLostDynamicSchemaInmemoryInactive[gridToRestart=0,
recreateTable=false] - PASSED{color}
* {color:#013220}IgniteCacheQuerySelfTestSuite6:
RejoinWithLostDynamicDdlTest.testRejoinWithLostDynamicSchemaInmemoryActive[gridToRestart=0,
recreateTable=false] - PASSED{color}
* {color:#013220}IgniteCacheQuerySelfTestSuite6:
RejoinWithLostDynamicDdlTest.testRejoinWithLostDynamicSchemaPersistentActiveClear[gridToRestart=0,
recreateTable=false] - PASSED{color}
* {color:#013220}IgniteCacheQuerySelfTestSuite6:
RejoinWithLostDynamicDdlTest.testRejoinWithLostDynamicSchemaInmemoryActive[gridToRestart=0,
recreateTable=true] - PASSED{color}
* {color:#013220}IgniteCacheQuerySelfTestSuite6:
RejoinWithLostDynamicDdlTest.testRejoinWithLostDynamicSchemaPersistentActiveClear[gridToRestart=0,
recreateTable=true] - PASSED{color}
* {color:#013220}IgniteCacheQuerySelfTestSuite6:
RejoinWithLostDynamicDdlTest.testRejoinWithLostLostDynamicTablePersistentInactive[gridToRestart=0,
recreateTable=false] - PASSED{color}
* {color:#013220}IgniteCacheQuerySelfTestSuite6:
RejoinWithLostDynamicDdlTest.testRejoinWithLostDynamicSchemaPersistentInactiveClear[gridToRestart=0,
recreateTable=false] - PASSED{color}
* {color:#013220}IgniteCacheQuerySelfTestSuite6:
RejoinWithLostDynamicDdlTest.testRejoinWithLostLostDynamicTablePersistentInactive[gridToRestart=0,
recreateTable=true] - PASSED{color}
* {color:#013220}IgniteCacheQuerySelfTestSuite6:
RejoinWithLostDynamicDdlTest.testRejoinWithLostDynamicSchemaPersistentInactiveClear[gridToRestart=0,
recreateTable=true] - PASSED{color}
* {color:#013220}IgniteCacheQuerySelfTestSuite6:
RejoinWithLostDynamicDdlTest.testRejoinWithLostDynamicSchemaPersistentActive[gridToRestart=0,
recreateTable=true] - PASSED{color}
... and 25 new tests
{panel}
[TeamCity *--> Run :: All*
Results|https://ci2.ignite.apache.org/viewLog.html?buildId=8308427&buildTypeId=IgniteTests24Java8_RunAll]
> SQL schema might not be merged on node join.
> --------------------------------------------
>
> Key: IGNITE-24212
> URL: https://issues.apache.org/jira/browse/IGNITE-24212
> Project: Ignite
> Issue Type: Bug
> Affects Versions: 2.14, 2.16, 2.17
> Reporter: Vladimir Steshin
> Assignee: Vladimir Steshin
> Priority: Minor
> Labels: ise, sql
> Attachments: TestNonPersistentNodeRestartsWithDynamicSQLTable.java
>
>
> *Consider:*
> 1) There is a working non-persistent cluster with defined caches in
> _IgniteConfiguration_.
> 2) The caches have no SQL-entities set.
> 3) Node creates table over one of these cache with `_CREATE TABLE IF NOT
> EXISTS_`. A SQL table and a schema appear in the cluster.
> 4) One of the nodes restarts.
> 5) Next `_SELECT_` queries to the table may fail with '_TABLE NOT FOUND'_
> 6) Restarted node has no tables in system view '_TABLES_'.
> *Cause:*
> The node restarts with defined cache configurations having no SQL entities
> set. When node joins cluster, dynamic tables/schema seem not merged or
> validated. The restarting node takes own cache configuration as is, without
> dynamically created schema and tables and has no the tables.
> +This works+ with the persistence because node stores and reads the cache
> meta holding the schema/entities.
> +Same happens+ with the persistence but with erased node's data.
> *Workarounds:*
> 1) Do not predefine caches, create them with `_CREATE TABLE_`
> 2) Set matching SQL entities in the predefined cache config.
> 3) Use other cache names with `_CREATE TABLE_` (_WITH "CACHE_NAME=._..).
> *Suggestions:*
> 1) Validate schema/caches and do not allow node join cluster.
> or
> 2) Merge static and dynamic schemas/cache configs and send them to the
> joining node.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
