[jira] [Created] (IGNITE-12692) Calcite integration. DML. Skip reducer optimization.

2020-02-17 Thread Igor Seliverstov (Jira)
Igor Seliverstov created IGNITE-12692:
-

 Summary: Calcite integration. DML. Skip reducer optimization.
 Key: IGNITE-12692
 URL: https://issues.apache.org/jira/browse/IGNITE-12692
 Project: Ignite
  Issue Type: Improvement
Reporter: Igor Seliverstov


Having plan tree we easily can check whether a final modification may be 
executed on data nodes directly or not. We should implement such kind of 
optimization.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Created] (IGNITE-12691) .NET: Native Near Cache

2020-02-17 Thread Pavel Tupitsyn (Jira)
Pavel Tupitsyn created IGNITE-12691:
---

 Summary: .NET: Native Near Cache
 Key: IGNITE-12691
 URL: https://issues.apache.org/jira/browse/IGNITE-12691
 Project: Ignite
  Issue Type: New Feature
  Components: platforms
Reporter: Pavel Tupitsyn
Assignee: Pavel Tupitsyn
 Fix For: 2.9


Implement native .NET Near Cache, which stores deserialized cache data on CLR 
heap.

Right now every cache.Get, every scan query, etc, cause repeated copy and 
deserialization of data from JVM, even for primary keys or near cache entries. 
This often becomes a bottleneck. Keeping up-to-date deserialized values in CLR 
memory can greatly improve performance and reduce latency.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Updated] (IGNITE-12690) Remove deprecation from DataRegionMetrics and mark metrics API with IgniteExperimental

2020-02-17 Thread Maxim Muzafarov (Jira)


 [ 
https://issues.apache.org/jira/browse/IGNITE-12690?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Maxim Muzafarov updated IGNITE-12690:
-
Summary: Remove deprecation from DataRegionMetrics and mark metrics API 
with IgniteExperimental  (was: Remove deprecation from DataRegionMetrics and 
mark ReadOnlyMetricRegistry with IgniteExperimental)

> Remove deprecation from DataRegionMetrics and mark metrics API with 
> IgniteExperimental
> --
>
> Key: IGNITE-12690
> URL: https://issues.apache.org/jira/browse/IGNITE-12690
> Project: Ignite
>  Issue Type: Task
>Reporter: Maxim Muzafarov
>Assignee: Maxim Muzafarov
>Priority: Blocker
> Fix For: 2.8
>
>  Time Spent: 10m
>  Remaining Estimate: 0h
>
> According to the vote [1] results and the discussion thread [2] the following 
> needs to be done:
> 1. Remove @deprecated from DataRegionMetric 
> 2. Mark new metrics API with @IgniteExperimental
> [1] 
> http://apache-ignite-developers.2346864.n4.nabble.com/RESULT-VOTE-Allow-or-prohibit-a-joint-use-of-deprecated-and-IgniteExperimental-td45863.html
> [2] 
> http://apache-ignite-developers.2346864.n4.nabble.com/Internal-classes-are-exposed-in-public-API-td45146.html



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Updated] (IGNITE-7276) .NET: Enable/disable cache statistics in runtime

2020-02-17 Thread Pavel Tupitsyn (Jira)


 [ 
https://issues.apache.org/jira/browse/IGNITE-7276?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Pavel Tupitsyn updated IGNITE-7276:
---
Ignite Flags: Release Notes Required
Release Note: Added ICache.EnableStatistics, ICluster.EnableStatistics.

> .NET: Enable/disable cache statistics in runtime
> 
>
> Key: IGNITE-7276
> URL: https://issues.apache.org/jira/browse/IGNITE-7276
> Project: Ignite
>  Issue Type: Improvement
>  Components: platforms
>Affects Versions: 2.4
>Reporter: Pavel Tupitsyn
>Assignee: Sergey Stronchinskiy
>Priority: Major
>  Labels: .NET, newbie
>  Time Spent: 40m
>  Remaining Estimate: 0h
>
> {{ICache.EnableStatistics}}, {{ICluster.EnableStatistics}}.
> See IGNITE-369.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Commented] (IGNITE-7276) .NET: Enable/disable cache statistics in runtime

2020-02-17 Thread Pavel Tupitsyn (Jira)


[ 
https://issues.apache.org/jira/browse/IGNITE-7276?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17038557#comment-17038557
 ] 

Pavel Tupitsyn commented on IGNITE-7276:


[~GuruStron] checked the PR, looks good in general, please see a few comments 
on GitHub.

> .NET: Enable/disable cache statistics in runtime
> 
>
> Key: IGNITE-7276
> URL: https://issues.apache.org/jira/browse/IGNITE-7276
> Project: Ignite
>  Issue Type: Improvement
>  Components: platforms
>Affects Versions: 2.4
>Reporter: Pavel Tupitsyn
>Assignee: Sergey Stronchinskiy
>Priority: Major
>  Labels: .NET, newbie
>  Time Spent: 40m
>  Remaining Estimate: 0h
>
> {{ICache.EnableStatistics}}, {{ICluster.EnableStatistics}}.
> See IGNITE-369.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Commented] (IGNITE-12638) Classes persisted by DistributedMetaStorage are not IgniteDTO

2020-02-17 Thread Maxim Muzafarov (Jira)


[ 
https://issues.apache.org/jira/browse/IGNITE-12638?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17038540#comment-17038540
 ] 

Maxim Muzafarov commented on IGNITE-12638:
--

I've cherry-picked to 2.8

> Classes persisted by DistributedMetaStorage are not IgniteDTO
> -
>
> Key: IGNITE-12638
> URL: https://issues.apache.org/jira/browse/IGNITE-12638
> Project: Ignite
>  Issue Type: Bug
>Reporter: Ivan Bessonov
>Assignee: Ivan Bessonov
>Priority: Major
> Fix For: 2.8
>
>  Time Spent: 1h
>  Remaining Estimate: 0h
>
> This has to be fixed to simplify future modification of component.
> DistributedMetaStorageHistoryItem and DistributedMetaStorageVersion will be 
> persisted on disc so we need to have a reliable way to read them even when 
> classes will be updated in the future. IgniteDataTransferObject is the 
> standard option for such cases - it allows versioning of serialization format.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Updated] (IGNITE-12690) Remove deprecation from DataRegionMetrics and mark ReadOnlyMetricRegistry with IgniteExperimental

2020-02-17 Thread Maxim Muzafarov (Jira)


 [ 
https://issues.apache.org/jira/browse/IGNITE-12690?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Maxim Muzafarov updated IGNITE-12690:
-
Priority: Blocker  (was: Major)

> Remove deprecation from DataRegionMetrics and mark ReadOnlyMetricRegistry 
> with IgniteExperimental
> -
>
> Key: IGNITE-12690
> URL: https://issues.apache.org/jira/browse/IGNITE-12690
> Project: Ignite
>  Issue Type: Task
>Reporter: Maxim Muzafarov
>Assignee: Maxim Muzafarov
>Priority: Blocker
> Fix For: 2.8
>
>
> According to the vote [1] results and the discussion thread [2] the following 
> needs to be done:
> 1. Remove @deprecated from DataRegionMetric 
> 2. Mark new metrics API with @IgniteExperimental
> [1] 
> http://apache-ignite-developers.2346864.n4.nabble.com/RESULT-VOTE-Allow-or-prohibit-a-joint-use-of-deprecated-and-IgniteExperimental-td45863.html
> [2] 
> http://apache-ignite-developers.2346864.n4.nabble.com/Internal-classes-are-exposed-in-public-API-td45146.html



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Created] (IGNITE-12690) Remove deprecation from DataRegionMetrics and mark ReadOnlyMetricRegistry with IgniteExperimental

2020-02-17 Thread Maxim Muzafarov (Jira)
Maxim Muzafarov created IGNITE-12690:


 Summary: Remove deprecation from DataRegionMetrics and mark 
ReadOnlyMetricRegistry with IgniteExperimental
 Key: IGNITE-12690
 URL: https://issues.apache.org/jira/browse/IGNITE-12690
 Project: Ignite
  Issue Type: Task
Reporter: Maxim Muzafarov
Assignee: Maxim Muzafarov
 Fix For: 2.8


According to the vote [1] results and the discussion thread [2] the following 
needs to be done:
1. Remove @deprecated from DataRegionMetric 
2. Mark new metrics API with @IgniteExperimental


[1] 
http://apache-ignite-developers.2346864.n4.nabble.com/RESULT-VOTE-Allow-or-prohibit-a-joint-use-of-deprecated-and-IgniteExperimental-td45863.html
[2] 
http://apache-ignite-developers.2346864.n4.nabble.com/Internal-classes-are-exposed-in-public-API-td45146.html



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Updated] (IGNITE-12690) Remove deprecation from DataRegionMetrics and mark ReadOnlyMetricRegistry with IgniteExperimental

2020-02-17 Thread Maxim Muzafarov (Jira)


 [ 
https://issues.apache.org/jira/browse/IGNITE-12690?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Maxim Muzafarov updated IGNITE-12690:
-
Ignite Flags:   (was: Docs Required,Release Notes Required)

> Remove deprecation from DataRegionMetrics and mark ReadOnlyMetricRegistry 
> with IgniteExperimental
> -
>
> Key: IGNITE-12690
> URL: https://issues.apache.org/jira/browse/IGNITE-12690
> Project: Ignite
>  Issue Type: Task
>Reporter: Maxim Muzafarov
>Assignee: Maxim Muzafarov
>Priority: Blocker
> Fix For: 2.8
>
>
> According to the vote [1] results and the discussion thread [2] the following 
> needs to be done:
> 1. Remove @deprecated from DataRegionMetric 
> 2. Mark new metrics API with @IgniteExperimental
> [1] 
> http://apache-ignite-developers.2346864.n4.nabble.com/RESULT-VOTE-Allow-or-prohibit-a-joint-use-of-deprecated-and-IgniteExperimental-td45863.html
> [2] 
> http://apache-ignite-developers.2346864.n4.nabble.com/Internal-classes-are-exposed-in-public-API-td45146.html



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Commented] (IGNITE-12686) Deprecate obsolete configuration properties

2020-02-17 Thread Ivan Pavlukhin (Jira)


[ 
https://issues.apache.org/jira/browse/IGNITE-12686?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17038495#comment-17038495
 ] 

Ivan Pavlukhin commented on IGNITE-12686:
-

Same {{PDS (Indexing)}} failure as in master.

> Deprecate obsolete configuration properties
> ---
>
> Key: IGNITE-12686
> URL: https://issues.apache.org/jira/browse/IGNITE-12686
> Project: Ignite
>  Issue Type: Bug
>  Components: cache
>Reporter: Ivan Pavlukhin
>Assignee: Ivan Pavlukhin
>Priority: Major
>  Labels: newbie
> Fix For: 2.9
>
>  Time Spent: 10m
>  Remaining Estimate: 0h
>
> Following properties were discovered as obsolete (no usages in codebase):
> * TransactionConfiguration.PessimisticTxLogSize
> * TransactionConfiguration.PessimisticTxLogLinger
> * CacheConfiguration.DefaultLockTimeout
> Let's deprecate them.
> Note that we are not going to remove them at this stage to avoid possible 
> compatibility issues.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Commented] (IGNITE-12686) Deprecate obsolete configuration properties

2020-02-17 Thread Ignite TC Bot (Jira)


[ 
https://issues.apache.org/jira/browse/IGNITE-12686?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17038493#comment-17038493
 ] 

Ignite TC Bot commented on IGNITE-12686:


{panel:title=Branch: [pull/7438/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=5057756]]

{panel}
[TeamCity *-- Run :: All* 
Results|https://ci.ignite.apache.org/viewLog.html?buildId=5057313buildTypeId=IgniteTests24Java8_RunAll]

> Deprecate obsolete configuration properties
> ---
>
> Key: IGNITE-12686
> URL: https://issues.apache.org/jira/browse/IGNITE-12686
> Project: Ignite
>  Issue Type: Bug
>  Components: cache
>Reporter: Ivan Pavlukhin
>Assignee: Ivan Pavlukhin
>Priority: Major
>  Labels: newbie
> Fix For: 2.9
>
>  Time Spent: 10m
>  Remaining Estimate: 0h
>
> Following properties were discovered as obsolete (no usages in codebase):
> * TransactionConfiguration.PessimisticTxLogSize
> * TransactionConfiguration.PessimisticTxLogLinger
> * CacheConfiguration.DefaultLockTimeout
> Let's deprecate them.
> Note that we are not going to remove them at this stage to avoid possible 
> compatibility issues.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Created] (IGNITE-12689) Partitions should become owned after a checkpoint, regardless of a topology change. Nevertheless a rebalance is not required.

2020-02-17 Thread Vladislav Pyatkov (Jira)
Vladislav Pyatkov created IGNITE-12689:
--

 Summary: Partitions should become owned after a checkpoint, 
regardless of a topology change. Nevertheless a rebalance is not required.
 Key: IGNITE-12689
 URL: https://issues.apache.org/jira/browse/IGNITE-12689
 Project: Ignite
  Issue Type: Bug
Reporter: Vladislav Pyatkov


After checkpoint completed we try to own all partitions of rebalanced cache 
(see WalStateManager#onGroupRebalanceFinished):
{code}
cpFut.futureFor(FINISHED).listen(new IgniteInClosureX() {
@Override public void applyx(IgniteInternalFuture future) {
if (X.hasCause(future.error(), NodeStoppingException.class))
return;

for (Integer grpId0 : groupsToEnable) {
try {
cctx.database().walEnabled(grpId0, true, true);
}
catch (Exception e) {
if (!X.hasCause(e, NodeStoppingException.class))
throw e;
}

CacheGroupContext grp = cctx.cache().cacheGroup(grpId0);

if (grp != null)
grp.topology().ownMoving(lastGroupTop);
else if (log.isDebugEnabled())
log.debug("Cache group was destroyed before checkpoint 
finished, [grpId=" + grpId0 + ']');
}

if (log.isDebugEnabled())
log.debug("Refresh partitions due to rebalance finished");

// Trigger exchange for switching to ideal assignment when all nodes 
are ready.
cctx.exchange().refreshPartitions();
}
});
{code}
But in case of topology changes during checkpoint pass, we are need to invoke 
rebalance manually (see GridDhtPartitionTopologyImpl#ownMoving):
{code}
if (lastAffChangeVer.compareTo(rebFinishedTopVer) > 0) {
if (log.isInfoEnabled()) {
log.info("Affinity topology changed, no MOVING partitions will be owned 
" +
"[rebFinishedTopVer=" + rebFinishedTopVer +
", lastAffChangeVer=" + lastAffChangeVer + "]");
}
{code}

That will be hardly ever happends, but if it was we restarted whole rebalance 
(over all partitions).I am advice start rebalance only when it needed and mark 
partitions as own if it definitely not need (when change of topology does not 
fluent to assignment).



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Commented] (IGNITE-12433) Possible to create table with duplicate definition of column

2020-02-17 Thread Sergey Uttsel (Jira)


[ 
https://issues.apache.org/jira/browse/IGNITE-12433?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17038393#comment-17038393
 ] 

Sergey Uttsel commented on IGNITE-12433:


[~jooger], OK, done.

> Possible to create table with duplicate definition of column
> 
>
> Key: IGNITE-12433
> URL: https://issues.apache.org/jira/browse/IGNITE-12433
> Project: Ignite
>  Issue Type: Bug
>  Components: sql
>Affects Versions: 2.8
>Reporter: Ilya Kasnacheev
>Assignee: Sergey Uttsel
>Priority: Minor
>  Labels: newbie
>  Time Spent: 2.5h
>  Remaining Estimate: 0h
>
> {code}
> sqlline version 1.3.0
> sqlline> !connect jdbc:ignite:thin://localhost
> Enter username for jdbc:ignite:thin://localhost: 
> Enter password for jdbc:ignite:thin://localhost: 
> 0: jdbc:ignite:thin://localhost> CREATE TABLE Person(ID INTEGER PRIMARY KEY,  
> NAME VARCHAR(100),  NAME
> . . . . . . . . . . . . . . . .> VARCHAR(100),  AGE INTEGER (64));
> No rows affected (0,229 seconds)
> 0: jdbc:ignite:thin://localhost> select * from person;
> ++++
> |   ID   |  NAME  |   
>AGE   |
> ++++
> ++++
> No rows selected (0,073 seconds)
> {code}
> This is on master branch. "NAME VARCHAR(100)" twice.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Commented] (IGNITE-11147) Re-balance cancellation occur by non-affected event

2020-02-17 Thread Alexey Scherbakov (Jira)


[ 
https://issues.apache.org/jira/browse/IGNITE-11147?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17038356#comment-17038356
 ] 

Alexey Scherbakov commented on IGNITE-11147:


[~v.pyatkov]

Check my comments under the PR.

> Re-balance cancellation occur by non-affected event
> ---
>
> Key: IGNITE-11147
> URL: https://issues.apache.org/jira/browse/IGNITE-11147
> Project: Ignite
>  Issue Type: Test
>  Components: cache
>Affects Versions: 2.7
>Reporter: Sergey Antonov
>Assignee: Vladislav Pyatkov
>Priority: Critical
> Fix For: 2.9
>
>  Time Spent: 2h 10m
>  Remaining Estimate: 0h
>
> Re-balance cancels by non-affected events, for examples:
> 1) joining non affinity node
> 2) stating snapshot
> 3) starting/stopping other cache
> Try to skip as more as possible events instead of cancellation.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Commented] (IGNITE-11451) SQL system view for IO indexes statistics

2020-02-17 Thread Nikolay Izhikov (Jira)


[ 
https://issues.apache.org/jira/browse/IGNITE-11451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17038347#comment-17038347
 ] 

Nikolay Izhikov commented on IGNITE-11451:
--

> 2) View INDEXES contains only static information. New one contain dynamic 
> changed information.

Dynamic changes in the SYS.metrics.

> Is it reasonable?

Can we add columns to the existing SYS.INDEXES view? That contains metric 
values for the corresponding indexes.
It seems the most natural improvement for me.

> SQL system view for IO indexes statistics
> -
>
> Key: IGNITE-11451
> URL: https://issues.apache.org/jira/browse/IGNITE-11451
> Project: Ignite
>  Issue Type: Task
>  Components: sql
>Reporter: Yury Gerzhedovich
>Priority: Major
>  Labels: IEP-35, iep-29, newbie
> Fix For: 3.0, 2.9
>
>
> Need to expose system SQL views to be able view IO statistics for SQL indexes.
> Start point to register new views is 
> org.apache.ignite.internal.processors.query.h2.SchemaManager#SchemaManager
> Need to expose information which registered in GridMetricManager at 
> org.apache.ignite.internal.metric.IoStatisticsHolderIndex
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Commented] (IGNITE-11451) SQL system view for IO indexes statistics

2020-02-17 Thread Yury Gerzhedovich (Jira)


[ 
https://issues.apache.org/jira/browse/IGNITE-11451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17038339#comment-17038339
 ] 

Yury Gerzhedovich commented on IGNITE-11451:


[~nizhikov], there at least two reasons to have separate view for index IO 
statistics:
1) It common approach for other vendors (see 
https://cwiki.apache.org/confluence/display/IGNITE/IEP-27%3A+Page+IO+statistics)
 
2) View INDEXES contains only static information. New one contain dynamic 
changed information. 

WDYT?  Is it reasonable?


> SQL system view for IO indexes statistics
> -
>
> Key: IGNITE-11451
> URL: https://issues.apache.org/jira/browse/IGNITE-11451
> Project: Ignite
>  Issue Type: Task
>  Components: sql
>Reporter: Yury Gerzhedovich
>Priority: Major
>  Labels: IEP-35, iep-29, newbie
> Fix For: 3.0, 2.9
>
>
> Need to expose system SQL views to be able view IO statistics for SQL indexes.
> Start point to register new views is 
> org.apache.ignite.internal.processors.query.h2.SchemaManager#SchemaManager
> Need to expose information which registered in GridMetricManager at 
> org.apache.ignite.internal.metric.IoStatisticsHolderIndex
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Commented] (IGNITE-11147) Re-balance cancellation occur by non-affected event

2020-02-17 Thread Maxim Muzafarov (Jira)


[ 
https://issues.apache.org/jira/browse/IGNITE-11147?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17038329#comment-17038329
 ] 

Maxim Muzafarov commented on IGNITE-11147:
--

Folks, 

I'll take a look at these changes soon. 
Please, do not hurry with the merge.

> Re-balance cancellation occur by non-affected event
> ---
>
> Key: IGNITE-11147
> URL: https://issues.apache.org/jira/browse/IGNITE-11147
> Project: Ignite
>  Issue Type: Test
>  Components: cache
>Affects Versions: 2.7
>Reporter: Sergey Antonov
>Assignee: Vladislav Pyatkov
>Priority: Critical
> Fix For: 2.9
>
>  Time Spent: 1h 50m
>  Remaining Estimate: 0h
>
> Re-balance cancels by non-affected events, for examples:
> 1) joining non affinity node
> 2) stating snapshot
> 3) starting/stopping other cache
> Try to skip as more as possible events instead of cancellation.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Commented] (IGNITE-12433) Possible to create table with duplicate definition of column

2020-02-17 Thread Yury Gerzhedovich (Jira)


[ 
https://issues.apache.org/jira/browse/IGNITE-12433?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17038328#comment-17038328
 ] 

Yury Gerzhedovich commented on IGNITE-12433:


[~Sergey Uttsel], thanks. Seems will be better to return your first SQL error 
code for the case. It's general error which we found during parsing. Everything 
else looks good.

> Possible to create table with duplicate definition of column
> 
>
> Key: IGNITE-12433
> URL: https://issues.apache.org/jira/browse/IGNITE-12433
> Project: Ignite
>  Issue Type: Bug
>  Components: sql
>Affects Versions: 2.8
>Reporter: Ilya Kasnacheev
>Assignee: Sergey Uttsel
>Priority: Minor
>  Labels: newbie
>  Time Spent: 2.5h
>  Remaining Estimate: 0h
>
> {code}
> sqlline version 1.3.0
> sqlline> !connect jdbc:ignite:thin://localhost
> Enter username for jdbc:ignite:thin://localhost: 
> Enter password for jdbc:ignite:thin://localhost: 
> 0: jdbc:ignite:thin://localhost> CREATE TABLE Person(ID INTEGER PRIMARY KEY,  
> NAME VARCHAR(100),  NAME
> . . . . . . . . . . . . . . . .> VARCHAR(100),  AGE INTEGER (64));
> No rows affected (0,229 seconds)
> 0: jdbc:ignite:thin://localhost> select * from person;
> ++++
> |   ID   |  NAME  |   
>AGE   |
> ++++
> ++++
> No rows selected (0,073 seconds)
> {code}
> This is on master branch. "NAME VARCHAR(100)" twice.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Commented] (IGNITE-12663) Let's limit all thread pools' sizes to 5 in tests

2020-02-17 Thread Stanilovsky Evgeny (Jira)


[ 
https://issues.apache.org/jira/browse/IGNITE-12663?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17038302#comment-17038302
 ] 

Stanilovsky Evgeny commented on IGNITE-12663:
-

[~ilyak] we need i.e. some kind of starvations in common tests coverage, does 
this fix not a simple masquerade of such a problems?

> Let's limit all thread pools' sizes to 5 in tests
> -
>
> Key: IGNITE-12663
> URL: https://issues.apache.org/jira/browse/IGNITE-12663
> Project: Ignite
>  Issue Type: Test
>Reporter: Ilya Kasnacheev
>Assignee: Ilya Kasnacheev
>Priority: Major
>  Time Spent: 10m
>  Remaining Estimate: 0h
>
> The rationale is, it is very painful shoving through thread dumps of test 
> with N CPU threads in every pool.
> Why 5? Rebalance thread pool is 4 by default, and system pool has to be bigger



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Commented] (IGNITE-12687) Sqline throws unexpected exceptions on few specific arguments to !describe and !primarykeys

2020-02-17 Thread Andrey Mashenkov (Jira)


[ 
https://issues.apache.org/jira/browse/IGNITE-12687?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17038298#comment-17038298
 ] 

Andrey Mashenkov commented on IGNITE-12687:
---

[~korlov],  PR LGTM.

> Sqline throws unexpected exceptions on few specific arguments to !describe 
> and !primarykeys
> ---
>
> Key: IGNITE-12687
> URL: https://issues.apache.org/jira/browse/IGNITE-12687
> Project: Ignite
>  Issue Type: Bug
>Reporter: Konstantin Orlov
>Assignee: Konstantin Orlov
>Priority: Major
>
> %subj 
> {noformat}
> 0: jdbc:ignite:thin://127.0.0.1/> !describe '
> java.lang.StringIndexOutOfBoundsException: String index out of range: -1
>   at java.lang.String.substring(String.java:1967)
>   at sqlline.SqlLine.dequote(SqlLine.java:1322)
>   at sqlline.SqlLine.split(SqlLine.java:1335)
>   at sqlline.SqlLine.split(SqlLine.java:1154)
>   at 
> sqlline.AbstractCommandHandler.matches(AbstractCommandHandler.java:65)
>   at sqlline.SqlLine.dispatch(SqlLine.java:774)
>   at sqlline.SqlLine.begin(SqlLine.java:668)
>   at sqlline.SqlLine.start(SqlLine.java:373)
>   at sqlline.SqlLine.main(SqlLine.java:265)
> {noformat}
> when at least one table was created, following command also fails:
> {noformat}
> 0: jdbc:ignite:thin://127.0.0.1/> !describe ?
> [17:19:31,763][SEVERE][client-connector-#110][JdbcRequestHandler] Failed to 
> get columns metadata [reqId=108, req=JdbcMetaColumnsRequest [schemaName=null, 
> tblName=?, colName=%]]
> java.util.regex.PatternSyntaxException: Dangling meta character '?' near 
> index 0
> ?
> ^
>   at java.util.regex.Pattern.error(Pattern.java:1955)
>   at java.util.regex.Pattern.sequence(Pattern.java:2123)
>   at java.util.regex.Pattern.expr(Pattern.java:1996)
>   at java.util.regex.Pattern.compile(Pattern.java:1696)
>   at java.util.regex.Pattern.(Pattern.java:1351)
>   at java.util.regex.Pattern.compile(Pattern.java:1028)
>   at java.util.regex.Pattern.matches(Pattern.java:1133)
>   at java.lang.String.matches(String.java:2121)
>   at 
> org.apache.ignite.internal.processors.query.QueryUtils.matches(QueryUtils.java:1547)
>   at 
> org.apache.ignite.internal.processors.odbc.jdbc.JdbcMetadataInfo.getColumnsMeta(JdbcMetadataInfo.java:170)
>   at 
> org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.getColumnsMeta(JdbcRequestHandler.java:1089)
>   at 
> org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.doHandle(JdbcRequestHandler.java:332)
>   at 
> org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.handle(JdbcRequestHandler.java:241)
>   at 
> org.apache.ignite.internal.processors.odbc.ClientListenerNioListener.onMessage(ClientListenerNioListener.java:180)
>   at 
> org.apache.ignite.internal.processors.odbc.ClientListenerNioListener.onMessage(ClientListenerNioListener.java:47)
>   at 
> org.apache.ignite.internal.util.nio.GridNioFilterChain$TailFilter.onMessageReceived(GridNioFilterChain.java:278)
>   at 
> org.apache.ignite.internal.util.nio.GridNioFilterAdapter.proceedMessageReceived(GridNioFilterAdapter.java:108)
>   at 
> org.apache.ignite.internal.util.nio.GridNioAsyncNotifyFilter$3.body(GridNioAsyncNotifyFilter.java:96)
>   at 
> org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:119)
>   at 
> org.apache.ignite.internal.util.worker.GridWorkerPool$1.run(GridWorkerPool.java:69)
>   at 
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>   at 
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>   at java.lang.Thread.run(Thread.java:748)
> Error: Dangling meta character '?' near index 0
> ?
> ^ (state=5,code=1)
> {noformat}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Updated] (IGNITE-12663) Let's limit all thread pools' sizes to 5 in tests

2020-02-17 Thread Ilya Kasnacheev (Jira)


 [ 
https://issues.apache.org/jira/browse/IGNITE-12663?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Ilya Kasnacheev updated IGNITE-12663:
-
Summary: Let's limit all thread pools' sizes to 5 in tests  (was: Let's 
limit all thread pools' sizes to 3 in tests)

> Let's limit all thread pools' sizes to 5 in tests
> -
>
> Key: IGNITE-12663
> URL: https://issues.apache.org/jira/browse/IGNITE-12663
> Project: Ignite
>  Issue Type: Test
>Reporter: Ilya Kasnacheev
>Assignee: Ilya Kasnacheev
>Priority: Major
>  Time Spent: 10m
>  Remaining Estimate: 0h
>
> The rationale is, it is very painful shoving through thread dumps of test 
> with N CPU threads in every pool.
> Why 3? It should allow all kinds of race conditions to still happen. Of 
> course, we should allow specific tests to override this value.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Updated] (IGNITE-12663) Let's limit all thread pools' sizes to 5 in tests

2020-02-17 Thread Ilya Kasnacheev (Jira)


 [ 
https://issues.apache.org/jira/browse/IGNITE-12663?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Ilya Kasnacheev updated IGNITE-12663:
-
Description: 
The rationale is, it is very painful shoving through thread dumps of test with 
N CPU threads in every pool.

Why 5? Rebalance thread pool is 4 by default, and system pool has to be bigger

  was:
The rationale is, it is very painful shoving through thread dumps of test with 
N CPU threads in every pool.

Why 3? It should allow all kinds of race conditions to still happen. Of course, 
we should allow specific tests to override this value.


> Let's limit all thread pools' sizes to 5 in tests
> -
>
> Key: IGNITE-12663
> URL: https://issues.apache.org/jira/browse/IGNITE-12663
> Project: Ignite
>  Issue Type: Test
>Reporter: Ilya Kasnacheev
>Assignee: Ilya Kasnacheev
>Priority: Major
>  Time Spent: 10m
>  Remaining Estimate: 0h
>
> The rationale is, it is very painful shoving through thread dumps of test 
> with N CPU threads in every pool.
> Why 5? Rebalance thread pool is 4 by default, and system pool has to be bigger



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Commented] (IGNITE-12687) Sqline throws unexpected exceptions on few specific arguments to !describe and !primarykeys

2020-02-17 Thread Konstantin Orlov (Jira)


[ 
https://issues.apache.org/jira/browse/IGNITE-12687?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17038290#comment-17038290
 ] 

Konstantin Orlov commented on IGNITE-12687:
---

Pull request: https://github.com/apache/ignite/pull/7439

> Sqline throws unexpected exceptions on few specific arguments to !describe 
> and !primarykeys
> ---
>
> Key: IGNITE-12687
> URL: https://issues.apache.org/jira/browse/IGNITE-12687
> Project: Ignite
>  Issue Type: Bug
>Reporter: Konstantin Orlov
>Assignee: Konstantin Orlov
>Priority: Major
>
> %subj 
> {noformat}
> 0: jdbc:ignite:thin://127.0.0.1/> !describe '
> java.lang.StringIndexOutOfBoundsException: String index out of range: -1
>   at java.lang.String.substring(String.java:1967)
>   at sqlline.SqlLine.dequote(SqlLine.java:1322)
>   at sqlline.SqlLine.split(SqlLine.java:1335)
>   at sqlline.SqlLine.split(SqlLine.java:1154)
>   at 
> sqlline.AbstractCommandHandler.matches(AbstractCommandHandler.java:65)
>   at sqlline.SqlLine.dispatch(SqlLine.java:774)
>   at sqlline.SqlLine.begin(SqlLine.java:668)
>   at sqlline.SqlLine.start(SqlLine.java:373)
>   at sqlline.SqlLine.main(SqlLine.java:265)
> {noformat}
> when at least one table was created, following command also fails:
> {noformat}
> 0: jdbc:ignite:thin://127.0.0.1/> !describe ?
> [17:19:31,763][SEVERE][client-connector-#110][JdbcRequestHandler] Failed to 
> get columns metadata [reqId=108, req=JdbcMetaColumnsRequest [schemaName=null, 
> tblName=?, colName=%]]
> java.util.regex.PatternSyntaxException: Dangling meta character '?' near 
> index 0
> ?
> ^
>   at java.util.regex.Pattern.error(Pattern.java:1955)
>   at java.util.regex.Pattern.sequence(Pattern.java:2123)
>   at java.util.regex.Pattern.expr(Pattern.java:1996)
>   at java.util.regex.Pattern.compile(Pattern.java:1696)
>   at java.util.regex.Pattern.(Pattern.java:1351)
>   at java.util.regex.Pattern.compile(Pattern.java:1028)
>   at java.util.regex.Pattern.matches(Pattern.java:1133)
>   at java.lang.String.matches(String.java:2121)
>   at 
> org.apache.ignite.internal.processors.query.QueryUtils.matches(QueryUtils.java:1547)
>   at 
> org.apache.ignite.internal.processors.odbc.jdbc.JdbcMetadataInfo.getColumnsMeta(JdbcMetadataInfo.java:170)
>   at 
> org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.getColumnsMeta(JdbcRequestHandler.java:1089)
>   at 
> org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.doHandle(JdbcRequestHandler.java:332)
>   at 
> org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.handle(JdbcRequestHandler.java:241)
>   at 
> org.apache.ignite.internal.processors.odbc.ClientListenerNioListener.onMessage(ClientListenerNioListener.java:180)
>   at 
> org.apache.ignite.internal.processors.odbc.ClientListenerNioListener.onMessage(ClientListenerNioListener.java:47)
>   at 
> org.apache.ignite.internal.util.nio.GridNioFilterChain$TailFilter.onMessageReceived(GridNioFilterChain.java:278)
>   at 
> org.apache.ignite.internal.util.nio.GridNioFilterAdapter.proceedMessageReceived(GridNioFilterAdapter.java:108)
>   at 
> org.apache.ignite.internal.util.nio.GridNioAsyncNotifyFilter$3.body(GridNioAsyncNotifyFilter.java:96)
>   at 
> org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:119)
>   at 
> org.apache.ignite.internal.util.worker.GridWorkerPool$1.run(GridWorkerPool.java:69)
>   at 
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>   at 
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>   at java.lang.Thread.run(Thread.java:748)
> Error: Dangling meta character '?' near index 0
> ?
> ^ (state=5,code=1)
> {noformat}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Created] (IGNITE-12688) Improve performance of index inline JAVA_OBJECT fields

2020-02-17 Thread Konstantin Orlov (Jira)
Konstantin Orlov created IGNITE-12688:
-

 Summary: Improve performance of index inline JAVA_OBJECT fields
 Key: IGNITE-12688
 URL: https://issues.apache.org/jira/browse/IGNITE-12688
 Project: Ignite
  Issue Type: Bug
Reporter: Konstantin Orlov
Assignee: Konstantin Orlov


Inline JAVA_OBJECT may be reason of performance drop on index creation.

The *root cause* is the low selectivity of current part of JAVA_OBJECT that is 
inlined.
Now first N bytes of binary view of object is placed into inline space of the 
index.
But the first offset where the two objects with the same type may be different 
is 8 (HASH_CODE_POS).
With default inline = 10 we NEVER inline it:
Inline format:
1 byte - type,
2 bytes - size
>> 7 bytes - data;

*My proposal:*
- For metapage v4 (BPlusMetaIO) add flag *inlineObjectHash*;
- use this flag to work in compatibility mode.
- inline ONLY hash for JAVA_OBJECT fields for new indexes;

Also this approach solves the inconsistent between comparison JAVA_OBJECT by 
inline and full value, because value comparator uses hash to compare object 
before compare byte arrays.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Commented] (IGNITE-10698) Get rid of @MXBeanParametersNames and @MXBeanParametersDescriptions

2020-02-17 Thread Andrey N. Gura (Jira)


[ 
https://issues.apache.org/jira/browse/IGNITE-10698?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17038262#comment-17038262
 ] 

Andrey N. Gura commented on IGNITE-10698:
-

[~l4ndsc4pe] Thanks for your effort. Tests set is impressive ) Nevertheless, I 
have comments to PR (most of them just cosmetic). Could you please fix them?

Also I found that new tests expect {{AssertionError}} which will not be thrown 
if assertions are disabled (it's default). I believe it is out of scope and 
could be solved as separate issue if you wish.

> Get rid of @MXBeanParametersNames and @MXBeanParametersDescriptions
> ---
>
> Key: IGNITE-10698
> URL: https://issues.apache.org/jira/browse/IGNITE-10698
> Project: Ignite
>  Issue Type: Task
>Reporter: Yakov Zhdanov
>Assignee: Lev Kiselev
>Priority: Major
>  Labels: newbie, usability
> Fix For: 2.9
>
>  Time Spent: 11h 50m
>  Remaining Estimate: 0h
>
> {noformat}
> @MXBeanDescription("Returns or kills transactions matching the filter 
> conditions.")
> @MXBeanParametersNames(
> {
> "minDuration",
> "minSize",
> "prj",
> "consistentIds",
> "xid",
> "lbRegex",
> "limit",
> "order",
> "detailed",
> "kill"
> }
> )
> @MXBeanParametersDescriptions(
> {
> "Minimum duration (seconds).",
> "Minimum size.",
> "Projection (servers|clients).",
> "Consistent ids (separated by comma).",
> "Transaction XID.",
> "Label regexp.",
> "Limit a number of transactions collected on each node.",
> "Order by DURATION|SIZE.",
> "Show detailed description, otherwise only count.",
> "Kill matching transactions (be careful)."
> }
> )
> {noformat}
> Above looks pretty ugly and is very error prone due to messing names and 
> descr order or number of strings.
> I would suggest to introduce individual parameters annotations and get them 
> via mtd.getParamterAnnotations() at runtime.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Created] (IGNITE-12687) Sqline throws unexpected exceptions on few specific arguments to !describe and !primarykeys

2020-02-17 Thread Konstantin Orlov (Jira)
Konstantin Orlov created IGNITE-12687:
-

 Summary: Sqline throws unexpected exceptions on few specific 
arguments to !describe and !primarykeys
 Key: IGNITE-12687
 URL: https://issues.apache.org/jira/browse/IGNITE-12687
 Project: Ignite
  Issue Type: Bug
Reporter: Konstantin Orlov
Assignee: Konstantin Orlov


%subj 

{noformat}
0: jdbc:ignite:thin://127.0.0.1/> !describe '
java.lang.StringIndexOutOfBoundsException: String index out of range: -1
at java.lang.String.substring(String.java:1967)
at sqlline.SqlLine.dequote(SqlLine.java:1322)
at sqlline.SqlLine.split(SqlLine.java:1335)
at sqlline.SqlLine.split(SqlLine.java:1154)
at 
sqlline.AbstractCommandHandler.matches(AbstractCommandHandler.java:65)
at sqlline.SqlLine.dispatch(SqlLine.java:774)
at sqlline.SqlLine.begin(SqlLine.java:668)
at sqlline.SqlLine.start(SqlLine.java:373)
at sqlline.SqlLine.main(SqlLine.java:265)
{noformat}

when at least one table was created, following command also fails:

{noformat}
0: jdbc:ignite:thin://127.0.0.1/> !describe ?
[17:19:31,763][SEVERE][client-connector-#110][JdbcRequestHandler] Failed to get 
columns metadata [reqId=108, req=JdbcMetaColumnsRequest [schemaName=null, 
tblName=?, colName=%]]
java.util.regex.PatternSyntaxException: Dangling meta character '?' near index 0
?
^
at java.util.regex.Pattern.error(Pattern.java:1955)
at java.util.regex.Pattern.sequence(Pattern.java:2123)
at java.util.regex.Pattern.expr(Pattern.java:1996)
at java.util.regex.Pattern.compile(Pattern.java:1696)
at java.util.regex.Pattern.(Pattern.java:1351)
at java.util.regex.Pattern.compile(Pattern.java:1028)
at java.util.regex.Pattern.matches(Pattern.java:1133)
at java.lang.String.matches(String.java:2121)
at 
org.apache.ignite.internal.processors.query.QueryUtils.matches(QueryUtils.java:1547)
at 
org.apache.ignite.internal.processors.odbc.jdbc.JdbcMetadataInfo.getColumnsMeta(JdbcMetadataInfo.java:170)
at 
org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.getColumnsMeta(JdbcRequestHandler.java:1089)
at 
org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.doHandle(JdbcRequestHandler.java:332)
at 
org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.handle(JdbcRequestHandler.java:241)
at 
org.apache.ignite.internal.processors.odbc.ClientListenerNioListener.onMessage(ClientListenerNioListener.java:180)
at 
org.apache.ignite.internal.processors.odbc.ClientListenerNioListener.onMessage(ClientListenerNioListener.java:47)
at 
org.apache.ignite.internal.util.nio.GridNioFilterChain$TailFilter.onMessageReceived(GridNioFilterChain.java:278)
at 
org.apache.ignite.internal.util.nio.GridNioFilterAdapter.proceedMessageReceived(GridNioFilterAdapter.java:108)
at 
org.apache.ignite.internal.util.nio.GridNioAsyncNotifyFilter$3.body(GridNioAsyncNotifyFilter.java:96)
at 
org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:119)
at 
org.apache.ignite.internal.util.worker.GridWorkerPool$1.run(GridWorkerPool.java:69)
at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:748)
Error: Dangling meta character '?' near index 0
?
^ (state=5,code=1)

{noformat}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Resolved] (IGNITE-11422) Remove H2 console from documentation

2020-02-17 Thread Artem Budnikov (Jira)


 [ 
https://issues.apache.org/jira/browse/IGNITE-11422?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Artem Budnikov resolved IGNITE-11422.
-
Resolution: Fixed

> Remove H2 console from documentation
> 
>
> Key: IGNITE-11422
> URL: https://issues.apache.org/jira/browse/IGNITE-11422
> Project: Ignite
>  Issue Type: Task
>  Components: documentation
>Reporter: Vladimir Ozerov
>Assignee: Artem Budnikov
>Priority: Major
>
> H2 console was deprecated as a part of IGNITE-11333. Need to remove all 
> mentions of "H2 console" from documentation.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Commented] (IGNITE-11422) Remove H2 console from documentation

2020-02-17 Thread Artem Budnikov (Jira)


[ 
https://issues.apache.org/jira/browse/IGNITE-11422?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17038217#comment-17038217
 ] 

Artem Budnikov commented on IGNITE-11422:
-

removed H2 Console section from 
https://apacheignite-sql.readme.io/docs/performance-and-debugging

> Remove H2 console from documentation
> 
>
> Key: IGNITE-11422
> URL: https://issues.apache.org/jira/browse/IGNITE-11422
> Project: Ignite
>  Issue Type: Task
>  Components: documentation
>Reporter: Vladimir Ozerov
>Assignee: Artem Budnikov
>Priority: Major
>
> H2 console was deprecated as a part of IGNITE-11333. Need to remove all 
> mentions of "H2 console" from documentation.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Commented] (IGNITE-11847) Change note on the capacity planning page about memory usage

2020-02-17 Thread Artem Budnikov (Jira)


[ 
https://issues.apache.org/jira/browse/IGNITE-11847?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17038210#comment-17038210
 ] 

Artem Budnikov commented on IGNITE-11847:
-

[~ezhuravl]  What is the correct value? Or should this statement be removed 
completely?

> Change note on the capacity planning page about memory usage
> 
>
> Key: IGNITE-11847
> URL: https://issues.apache.org/jira/browse/IGNITE-11847
> Project: Ignite
>  Issue Type: Bug
>  Components: documentation
>Affects Versions: 2.7
>Reporter: Evgenii Zhuravlev
>Assignee: Artem Budnikov
>Priority: Major
>
> https://apacheignite.readme.io/docs/capacity-planning#calculating-memory-usage
> It says that "Apache Ignite will typically add around 200 bytes overhead to 
> each entry.", but it's not true, I think it was applicable only for 1.x 
> versions, where everything was stored in heap



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Commented] (IGNITE-12638) Classes persisted by DistributedMetaStorage are not IgniteDTO

2020-02-17 Thread Maxim Muzafarov (Jira)


[ 
https://issues.apache.org/jira/browse/IGNITE-12638?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17038202#comment-17038202
 ] 

Maxim Muzafarov commented on IGNITE-12638:
--

[~agura], [~ibessonov]

Thank you, I'll cherry-pick the issue today to 2.8

> Classes persisted by DistributedMetaStorage are not IgniteDTO
> -
>
> Key: IGNITE-12638
> URL: https://issues.apache.org/jira/browse/IGNITE-12638
> Project: Ignite
>  Issue Type: Bug
>Reporter: Ivan Bessonov
>Assignee: Ivan Bessonov
>Priority: Major
> Fix For: 2.8
>
>  Time Spent: 1h
>  Remaining Estimate: 0h
>
> This has to be fixed to simplify future modification of component.
> DistributedMetaStorageHistoryItem and DistributedMetaStorageVersion will be 
> persisted on disc so we need to have a reliable way to read them even when 
> classes will be updated in the future. IgniteDataTransferObject is the 
> standard option for such cases - it allows versioning of serialization format.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Commented] (IGNITE-12663) Let's limit all thread pools' sizes to 3 in tests

2020-02-17 Thread Ignite TC Bot (Jira)


[ 
https://issues.apache.org/jira/browse/IGNITE-12663?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17038201#comment-17038201
 ] 

Ignite TC Bot commented on IGNITE-12663:


{panel:title=Branch: [pull/7429/head] Base: [master] : No blockers 
found!|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}{panel}
[TeamCity *-- Run :: All* 
Results|https://ci.ignite.apache.org/viewLog.html?buildId=5050920buildTypeId=IgniteTests24Java8_RunAll]

> Let's limit all thread pools' sizes to 3 in tests
> -
>
> Key: IGNITE-12663
> URL: https://issues.apache.org/jira/browse/IGNITE-12663
> Project: Ignite
>  Issue Type: Test
>Reporter: Ilya Kasnacheev
>Assignee: Ilya Kasnacheev
>Priority: Major
>  Time Spent: 10m
>  Remaining Estimate: 0h
>
> The rationale is, it is very painful shoving through thread dumps of test 
> with N CPU threads in every pool.
> Why 3? It should allow all kinds of race conditions to still happen. Of 
> course, we should allow specific tests to override this value.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Assigned] (IGNITE-12384) [ML] Add an Encoder examples for all supported versions

2020-02-17 Thread Lev Kiselev (Jira)


 [ 
https://issues.apache.org/jira/browse/IGNITE-12384?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Lev Kiselev reassigned IGNITE-12384:


Assignee: Lev Kiselev

> [ML] Add an Encoder examples for all supported versions
> ---
>
> Key: IGNITE-12384
> URL: https://issues.apache.org/jira/browse/IGNITE-12384
> Project: Ignite
>  Issue Type: Sub-task
>  Components: ml
>Reporter: Alexey Zinoviev
>Assignee: Lev Kiselev
>Priority: Major
>  Labels: examples, newbie
>
> We have a few Encoders like OHE, StringIndexer and so on.
> Please provide separate examples to illustrate the power of different encoders



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Updated] (IGNITE-11147) Re-balance cancellation occur by non-affected event

2020-02-17 Thread Alexey Scherbakov (Jira)


 [ 
https://issues.apache.org/jira/browse/IGNITE-11147?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Alexey Scherbakov updated IGNITE-11147:
---
Reviewer: Alexey Scherbakov

> Re-balance cancellation occur by non-affected event
> ---
>
> Key: IGNITE-11147
> URL: https://issues.apache.org/jira/browse/IGNITE-11147
> Project: Ignite
>  Issue Type: Test
>  Components: cache
>Affects Versions: 2.7
>Reporter: Sergey Antonov
>Assignee: Vladislav Pyatkov
>Priority: Critical
> Fix For: 2.9
>
>  Time Spent: 20m
>  Remaining Estimate: 0h
>
> Re-balance cancels by non-affected events, for examples:
> 1) joining non affinity node
> 2) stating snapshot
> 3) starting/stopping other cache
> Try to skip as more as possible events instead of cancellation.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Commented] (IGNITE-12590) MERGE INTO query is failing on Ignite client node

2020-02-17 Thread Taras Ledkov (Jira)


[ 
https://issues.apache.org/jira/browse/IGNITE-12590?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17038173#comment-17038173
 ] 

Taras Ledkov commented on IGNITE-12590:
---

The review issues are fixed.
[~amashenkov], please review and merge the patch.

> MERGE INTO query is failing on Ignite client node
> -
>
> Key: IGNITE-12590
> URL: https://issues.apache.org/jira/browse/IGNITE-12590
> Project: Ignite
>  Issue Type: Bug
>  Components: sql
>Affects Versions: 2.7
>Reporter: Taras Ledkov
>Assignee: Taras Ledkov
>Priority: Major
> Fix For: 2.9
>
>  Time Spent: 0.5h
>  Remaining Estimate: 0h
>
> Precondition: server nodes (any amount), webconsole is running.
> 1. Create the table as following:
> CREATE TABLE USERPUBSTATICDATA (BOOK VARCHAR, DESK VARCHAR, TRADERS VARCHAR, 
> REGION VARCHAR, LOB VARCHAR, EXCLUDE VARCHAR, TRANSIT VARCHAR, 
> MAPBOOKTOTHISBOOK VARCHAR, CONSTRAINT USERPUBSTATICDATA_PK PRIMARY KEY 
> (BOOK,DESK)) WITH "template=replicated"
> 2. Execute merge into query:
> MERGE INTO USERPUBSTATICDATA(BOOK, DESK, TRADERS, REGION, LOB, EXCLUDE, 
> TRANSIT, MAPBOOKTOTHISBOOK) VALUES('CADOIS', 'FRT TOR', 'Robin Das/Dave 
> Carlson', 'Toronto', 'FRT', null, null, 'CADOIS');
> Step 2 is successfull on Web Console and called on IgniteCache from the 
> server node, but fails when called from the Ignite client node with exception:
> {code}
> javax.cache.CacheException: Invalid column name in KEYS clause of MERGE - it 
> may include only key and/or affinity columns: BOOK
> {code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Commented] (IGNITE-12433) Possible to create table with duplicate definition of column

2020-02-17 Thread Sergey Uttsel (Jira)


[ 
https://issues.apache.org/jira/browse/IGNITE-12433?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17038160#comment-17038160
 ] 

Sergey Uttsel commented on IGNITE-12433:


[~jooger], please review new changes.

> Possible to create table with duplicate definition of column
> 
>
> Key: IGNITE-12433
> URL: https://issues.apache.org/jira/browse/IGNITE-12433
> Project: Ignite
>  Issue Type: Bug
>  Components: sql
>Affects Versions: 2.8
>Reporter: Ilya Kasnacheev
>Assignee: Sergey Uttsel
>Priority: Minor
>  Labels: newbie
>  Time Spent: 2h 20m
>  Remaining Estimate: 0h
>
> {code}
> sqlline version 1.3.0
> sqlline> !connect jdbc:ignite:thin://localhost
> Enter username for jdbc:ignite:thin://localhost: 
> Enter password for jdbc:ignite:thin://localhost: 
> 0: jdbc:ignite:thin://localhost> CREATE TABLE Person(ID INTEGER PRIMARY KEY,  
> NAME VARCHAR(100),  NAME
> . . . . . . . . . . . . . . . .> VARCHAR(100),  AGE INTEGER (64));
> No rows affected (0,229 seconds)
> 0: jdbc:ignite:thin://localhost> select * from person;
> ++++
> |   ID   |  NAME  |   
>AGE   |
> ++++
> ++++
> No rows selected (0,073 seconds)
> {code}
> This is on master branch. "NAME VARCHAR(100)" twice.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Commented] (IGNITE-12433) Possible to create table with duplicate definition of column

2020-02-17 Thread Ignite TC Bot (Jira)


[ 
https://issues.apache.org/jira/browse/IGNITE-12433?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17038161#comment-17038161
 ] 

Ignite TC Bot commented on IGNITE-12433:


{panel:title=Branch: [pull/7404/head] Base: [master] : No blockers 
found!|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}{panel}
[TeamCity *-- Run :: All* 
Results|https://ci.ignite.apache.org/viewLog.html?buildId=5050660buildTypeId=IgniteTests24Java8_RunAll]

> Possible to create table with duplicate definition of column
> 
>
> Key: IGNITE-12433
> URL: https://issues.apache.org/jira/browse/IGNITE-12433
> Project: Ignite
>  Issue Type: Bug
>  Components: sql
>Affects Versions: 2.8
>Reporter: Ilya Kasnacheev
>Assignee: Sergey Uttsel
>Priority: Minor
>  Labels: newbie
>  Time Spent: 2h 20m
>  Remaining Estimate: 0h
>
> {code}
> sqlline version 1.3.0
> sqlline> !connect jdbc:ignite:thin://localhost
> Enter username for jdbc:ignite:thin://localhost: 
> Enter password for jdbc:ignite:thin://localhost: 
> 0: jdbc:ignite:thin://localhost> CREATE TABLE Person(ID INTEGER PRIMARY KEY,  
> NAME VARCHAR(100),  NAME
> . . . . . . . . . . . . . . . .> VARCHAR(100),  AGE INTEGER (64));
> No rows affected (0,229 seconds)
> 0: jdbc:ignite:thin://localhost> select * from person;
> ++++
> |   ID   |  NAME  |   
>AGE   |
> ++++
> ++++
> No rows selected (0,073 seconds)
> {code}
> This is on master branch. "NAME VARCHAR(100)" twice.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Updated] (IGNITE-9325) Add an ability to make a sound after a complete execution to all command-line utilities

2020-02-17 Thread Alexey Goncharuk (Jira)


 [ 
https://issues.apache.org/jira/browse/IGNITE-9325?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Alexey Goncharuk updated IGNITE-9325:
-
Summary: Add an ability to make a sound after a complete execution to all 
command-line utilities  (was: Add to all command-line utility ability to make 
sound after complite execution)

> Add an ability to make a sound after a complete execution to all command-line 
> utilities
> ---
>
> Key: IGNITE-9325
> URL: https://issues.apache.org/jira/browse/IGNITE-9325
> Project: Ignite
>  Issue Type: Improvement
>  Components: examples
>Affects Versions: 2.5
>Reporter: ARomantsov
>Assignee: Artsiom Panko
>Priority: Major
>  Labels: command-line, newbie
> Fix For: 2.9
>
>
> Often I work simultaneously on several clusters over ssh and there are 
> situations when I forget to check that the first cluster has completed the 
> command (for example, activation), while working on the second. 
> It would be great if there was an option to ignite command-line utilities 
> that would allow some sort of sound (or system beep) to be played after the 
> command got executed.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Updated] (IGNITE-9325) Add to all command-line utility ability to make sound after complite execution

2020-02-17 Thread Alexey Goncharuk (Jira)


 [ 
https://issues.apache.org/jira/browse/IGNITE-9325?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Alexey Goncharuk updated IGNITE-9325:
-
Description: 
Often I work simultaneously on several clusters over ssh and there are 
situations when I forget to check that the first cluster has completed the 
command (for example, activation), while working on the second. 
It would be great if there was an option to ignite command-line utilities that 
would allow some sort of sound (or system beep) to be played after the command 
got executed.

  was:
Often I work simultaneously on several clusters over ssh and there are 
situations when I forget to check that the first cluster has completed the 
command (for example, activation), while working on the second. 
Because of this, I would like to have same functionality in the product


> Add to all command-line utility ability to make sound after complite execution
> --
>
> Key: IGNITE-9325
> URL: https://issues.apache.org/jira/browse/IGNITE-9325
> Project: Ignite
>  Issue Type: Improvement
>  Components: examples
>Affects Versions: 2.5
>Reporter: ARomantsov
>Assignee: Artsiom Panko
>Priority: Major
>  Labels: command-line, newbie
> Fix For: 2.9
>
>
> Often I work simultaneously on several clusters over ssh and there are 
> situations when I forget to check that the first cluster has completed the 
> command (for example, activation), while working on the second. 
> It would be great if there was an option to ignite command-line utilities 
> that would allow some sort of sound (or system beep) to be played after the 
> command got executed.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Commented] (IGNITE-9325) Add to all command-line utility ability to make sound after complite execution

2020-02-17 Thread Ilya Kasnacheev (Jira)


[ 
https://issues.apache.org/jira/browse/IGNITE-9325?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17038152#comment-17038152
 ] 

Ilya Kasnacheev commented on IGNITE-9325:
-

[~artsiom_panko] you don't need to reproduce this. Have you checked the title 
of this ticket? I think it's self-explanatory.

> Add to all command-line utility ability to make sound after complite execution
> --
>
> Key: IGNITE-9325
> URL: https://issues.apache.org/jira/browse/IGNITE-9325
> Project: Ignite
>  Issue Type: Improvement
>  Components: examples
>Affects Versions: 2.5
>Reporter: ARomantsov
>Assignee: Artsiom Panko
>Priority: Major
>  Labels: command-line, newbie
> Fix For: 2.9
>
>
> Often I work simultaneously on several clusters over ssh and there are 
> situations when I forget to check that the first cluster has completed the 
> command (for example, activation), while working on the second. 
> Because of this, I would like to have same functionality in the product



--
This message was sent by Atlassian Jira
(v8.3.4#803005)