[jira] [Updated] (IGNITE-21841) The FilePageStoreManager constructor should not throw an exception

2024-03-25 Thread Andrey Novikov (Jira)


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

Andrey Novikov updated IGNITE-21841:

Labels: ignite-3  (was: )

> The FilePageStoreManager constructor should not throw an exception
> --
>
> Key: IGNITE-21841
> URL: https://issues.apache.org/jira/browse/IGNITE-21841
> Project: Ignite
>  Issue Type: Improvement
>  Components: persistence
>Affects Versions: 3.0.0-beta2
>Reporter: Andrey Novikov
>Assignee: Andrey Novikov
>Priority: Major
>  Labels: ignite-3
>  Time Spent: 10m
>  Remaining Estimate: 0h
>
> Current implementation of FilePageStoreManager is throw an exception from 
> constructor, which is not recommended.
> Let's create FilePageStoreFactory from the outside and pass it to the 
> constructor.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Created] (IGNITE-21841) The FilePageStoreManager constructor should not throw an exception

2024-03-25 Thread Andrey Novikov (Jira)
Andrey Novikov created IGNITE-21841:
---

 Summary: The FilePageStoreManager constructor should not throw an 
exception
 Key: IGNITE-21841
 URL: https://issues.apache.org/jira/browse/IGNITE-21841
 Project: Ignite
  Issue Type: Improvement
  Components: persistence
Affects Versions: 3.0.0-beta2
Reporter: Andrey Novikov


Current implementation of FilePageStoreManager is throw an exception from 
constructor, which is not recommended.

Let's create FilePageStoreFactory from the outside and pass it to the 
constructor.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Assigned] (IGNITE-21841) The FilePageStoreManager constructor should not throw an exception

2024-03-25 Thread Andrey Novikov (Jira)


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

Andrey Novikov reassigned IGNITE-21841:
---

Assignee: Andrey Novikov

> The FilePageStoreManager constructor should not throw an exception
> --
>
> Key: IGNITE-21841
> URL: https://issues.apache.org/jira/browse/IGNITE-21841
> Project: Ignite
>  Issue Type: Improvement
>  Components: persistence
>Affects Versions: 3.0.0-beta2
>Reporter: Andrey Novikov
>Assignee: Andrey Novikov
>Priority: Major
>
> Current implementation of FilePageStoreManager is throw an exception from 
> constructor, which is not recommended.
> Let's create FilePageStoreFactory from the outside and pass it to the 
> constructor.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Updated] (IGNITE-21840) PersistentPageMemoryStorageEngine#createMvTable should return MvTableStorage

2024-03-25 Thread Andrey Novikov (Jira)


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

Andrey Novikov updated IGNITE-21840:

Labels: ignite-3  (was: )

> PersistentPageMemoryStorageEngine#createMvTable should return MvTableStorage
> 
>
> Key: IGNITE-21840
> URL: https://issues.apache.org/jira/browse/IGNITE-21840
> Project: Ignite
>  Issue Type: Improvement
>  Components: persistence
>Affects Versions: 3.0.0-beta2
>Reporter: Andrey Novikov
>Assignee: Andrey Novikov
>Priority: Major
>  Labels: ignite-3
> Fix For: 3.0.0-beta2
>
>
> Current implementation of PersistentPageMemoryStorageEngine#createMvTable 
> returns PersistentPageMemoryTableStorage which doesn't comply with the 
> contract described in StorageEngine. The use of this is not found in the code.
> Let's return MvTableStorage instead of PersistentPageMemoryTableStorage.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Assigned] (IGNITE-21840) PersistentPageMemoryStorageEngine#createMvTable should return MvTableStorage

2024-03-25 Thread Andrey Novikov (Jira)


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

Andrey Novikov reassigned IGNITE-21840:
---

Assignee: Andrey Novikov

> PersistentPageMemoryStorageEngine#createMvTable should return MvTableStorage
> 
>
> Key: IGNITE-21840
> URL: https://issues.apache.org/jira/browse/IGNITE-21840
> Project: Ignite
>  Issue Type: Improvement
>  Components: persistence
>Affects Versions: 3.0.0-beta2
>Reporter: Andrey Novikov
>Assignee: Andrey Novikov
>Priority: Major
> Fix For: 3.0.0-beta2
>
>
> Current implementation of PersistentPageMemoryStorageEngine#createMvTable 
> returns PersistentPageMemoryTableStorage which doesn't comply with the 
> contract described in StorageEngine. The use of this is not found in the code.
> Let's return MvTableStorage instead of PersistentPageMemoryTableStorage.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Created] (IGNITE-21840) PersistentPageMemoryStorageEngine#createMvTable should return MvTableStorage

2024-03-25 Thread Andrey Novikov (Jira)
Andrey Novikov created IGNITE-21840:
---

 Summary: PersistentPageMemoryStorageEngine#createMvTable should 
return MvTableStorage
 Key: IGNITE-21840
 URL: https://issues.apache.org/jira/browse/IGNITE-21840
 Project: Ignite
  Issue Type: Improvement
  Components: persistence
Affects Versions: 3.0.0-beta2
Reporter: Andrey Novikov
 Fix For: 3.0.0-beta2


Current implementation of PersistentPageMemoryStorageEngine#createMvTable 
returns PersistentPageMemoryTableStorage which doesn't comply with the contract 
described in StorageEngine. The use of this is not found in the code.

Let's return MvTableStorage instead of PersistentPageMemoryTableStorage.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Created] (IGNITE-21817) CriteriaException must keep error code for mapping from SqlException

2024-03-20 Thread Andrey Novikov (Jira)
Andrey Novikov created IGNITE-21817:
---

 Summary: CriteriaException must keep error code for mapping from 
SqlException 
 Key: IGNITE-21817
 URL: https://issues.apache.org/jira/browse/IGNITE-21817
 Project: Ignite
  Issue Type: Improvement
Reporter: Andrey Novikov


Current implementation of 
CriteriaExceptionMapperUtil#mapToPublicCriteriaException
{code:java}
public static Throwable mapToPublicCriteriaException(Throwable origin) {
Throwable e = mapToPublicException(origin);

if (e instanceof Error) {
return e;
}
if (e instanceof CriteriaException) {
return e;
}
if (e instanceof SqlException) {
return new CriteriaException(INTERNAL_ERR, e);
}
...{code}
It looks like we doesn't need to map all SqlException to CriteriaException with 
errorCode = INTERNAL_ERR



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Assigned] (IGNITE-21817) CriteriaException must keep error code for mapping from SqlException

2024-03-20 Thread Andrey Novikov (Jira)


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

Andrey Novikov reassigned IGNITE-21817:
---

Assignee: Andrey Novikov

> CriteriaException must keep error code for mapping from SqlException 
> -
>
> Key: IGNITE-21817
> URL: https://issues.apache.org/jira/browse/IGNITE-21817
> Project: Ignite
>  Issue Type: Improvement
>Reporter: Andrey Novikov
>Assignee: Andrey Novikov
>Priority: Major
>  Labels: ignite-3
>
> Current implementation of 
> CriteriaExceptionMapperUtil#mapToPublicCriteriaException
> {code:java}
> public static Throwable mapToPublicCriteriaException(Throwable origin) {
> Throwable e = mapToPublicException(origin);
> if (e instanceof Error) {
> return e;
> }
> if (e instanceof CriteriaException) {
> return e;
> }
> if (e instanceof SqlException) {
> return new CriteriaException(INTERNAL_ERR, e);
> }
> ...{code}
> It looks like we doesn't need to map all SqlException to CriteriaException 
> with errorCode = INTERNAL_ERR



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Updated] (IGNITE-21817) CriteriaException must keep error code for mapping from SqlException

2024-03-20 Thread Andrey Novikov (Jira)


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

Andrey Novikov updated IGNITE-21817:

Labels: ignite-3  (was: )

> CriteriaException must keep error code for mapping from SqlException 
> -
>
> Key: IGNITE-21817
> URL: https://issues.apache.org/jira/browse/IGNITE-21817
> Project: Ignite
>  Issue Type: Improvement
>Reporter: Andrey Novikov
>Priority: Major
>  Labels: ignite-3
>
> Current implementation of 
> CriteriaExceptionMapperUtil#mapToPublicCriteriaException
> {code:java}
> public static Throwable mapToPublicCriteriaException(Throwable origin) {
> Throwable e = mapToPublicException(origin);
> if (e instanceof Error) {
> return e;
> }
> if (e instanceof CriteriaException) {
> return e;
> }
> if (e instanceof SqlException) {
> return new CriteriaException(INTERNAL_ERR, e);
> }
> ...{code}
> It looks like we doesn't need to map all SqlException to CriteriaException 
> with errorCode = INTERNAL_ERR



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Updated] (IGNITE-21814) Incorrect validation error if configuration value is not initialized

2024-03-20 Thread Andrey Novikov (Jira)


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

Andrey Novikov updated IGNITE-21814:

Labels: ignite-3  (was: )

> Incorrect validation error if configuration value is not initialized
> 
>
> Key: IGNITE-21814
> URL: https://issues.apache.org/jira/browse/IGNITE-21814
> Project: Ignite
>  Issue Type: Improvement
>  Components: cli
>Affects Versions: 3.0.0-beta2
>Reporter: Andrey Novikov
>Priority: Minor
>  Labels: ignite-3
>
> KeysTrackingConfigurationVisitor#validate looks incorrect
> {code:java}
> if (val == null) {
> String message = "'" + (currentKey() + fieldName) + "' configuration 
> value is not initialized.";
> issues.add(new ValidationIssue(currentKey(), message));
> return;
> } {code}
> It throw exception which contains section and full field name in error 
> message:
>  
> {noformat}
> Validation did not pass for keys: [test.providers.basic., 
> 'test.providers.basic.secret' configuration value is not initialized.]
> {noformat}
>  



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Created] (IGNITE-21814) Incorrect validation error if configuration value is not initialized

2024-03-20 Thread Andrey Novikov (Jira)
Andrey Novikov created IGNITE-21814:
---

 Summary: Incorrect validation error if configuration value is not 
initialized
 Key: IGNITE-21814
 URL: https://issues.apache.org/jira/browse/IGNITE-21814
 Project: Ignite
  Issue Type: Improvement
  Components: cli
Affects Versions: 3.0.0-beta2
Reporter: Andrey Novikov


KeysTrackingConfigurationVisitor#validate looks incorrect
{code:java}
if (val == null) {
String message = "'" + (currentKey() + fieldName) + "' configuration value 
is not initialized.";

issues.add(new ValidationIssue(currentKey(), message));

return;
} {code}
It throw exception which contains section and full field name in error message:

 
{noformat}
Validation did not pass for keys: [test.providers.basic., 
'test.providers.basic.secret' configuration value is not initialized.]
{noformat}
 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Comment Edited] (IGNITE-20882) Append performance tests

2024-02-12 Thread Andrey Novikov (Jira)


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

Andrey Novikov edited comment on IGNITE-20882 at 2/12/24 10:34 AM:
---

 
Single-node embedded (CriteriaEmbeddedNodeBenchmark):
||Benchmark||Score(us/op)||
|criteriaGet|114,135 ± 1,129|
|kvGet|72,062 ± 0,309|
|sqlGet|105,260 ± 0,521|

Two nodes, thin client(CriteriaThinClientBenchmark):
||Benchmark||Score(us/op)||
|criteriaGet|1780,171 ± 35,306|
|kvGet|251,105 ± 8,618|
|sqlGet|2694,740 ± 72,396|
|criteriaGetNonNullTxDisablesPartitionAwareness|2935,503 ± 192,479|
|kvGetNonNullTxDisablesPartitionAwareness|352,037 ± 7,819|
|sqlGetNonNullTxDisablesPartitionAwareness|2814,066 ± 88,770|
|sqlIterate|1603991,380 ± 12153,762|
|criteriaIterate|1501173,640 ± 31600,562|

 


was (Author: anovikov):
 
Single-node embedded (CriteriaSingleNodeBenchmark):
||Benchmark||Score(us/op)||
|criteriaGet|1780,171 ± 35,306|
|kvGet|121,114 ±  1,726|
|sqlGet|1703,928 ± 34,945|

Two nodes, thin client(CriteriaThinClientBenchmark):
||Benchmark||Score(us/op)||
|criteriaGet|1780,171 ± 35,306|
|kvGet|251,105 ± 8,618|
|sqlGet|2694,740 ± 72,396|
|criteriaGetNonNullTxDisablesPartitionAwareness|2935,503 ± 192,479|
|kvGetNonNullTxDisablesPartitionAwareness|352,037 ± 7,819|
|sqlGetNonNullTxDisablesPartitionAwareness|2814,066 ± 88,770|
|sqlIterate|1603991,380 ± 12153,762|
|criteriaIterate|1501173,640 ± 31600,562|

 

> Append performance tests
> 
>
> Key: IGNITE-20882
> URL: https://issues.apache.org/jira/browse/IGNITE-20882
> Project: Ignite
>  Issue Type: Improvement
>  Components: sql
>Reporter: Andrey Novikov
>Assignee: Andrey Novikov
>Priority: Major
>  Labels: ignite-3
> Fix For: 3.0.0-beta2
>
>  Time Spent: 20m
>  Remaining Estimate: 0h
>
> # Compare single-key criteria vs single-key SQL vs table.get(PK)
>  * Expect to have similar performance
>  * Check single-node embedded, distributed with no partition awareness, 
> distributed with partition awareness
>  * NOTE: future improvement for criteria query – lookup affinity node if PK 
> or colocation key is in the criteria.
>  # Compare criteria vs SQL when affinity key is specified (unicast when 
> partition pruning is added)
>  # Compare criteria vs SQL for broadcast queries – latency and throughput
>  # Compare criteria vs SQL – time it takes to iterate over 10kk entries



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Assigned] (IGNITE-21453) Fix force index hint test

2024-02-07 Thread Andrey Novikov (Jira)


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

Andrey Novikov reassigned IGNITE-21453:
---

Assignee: Andrey Novikov

> Fix force index hint test
> -
>
> Key: IGNITE-21453
> URL: https://issues.apache.org/jira/browse/IGNITE-21453
> Project: Ignite
>  Issue Type: Bug
>  Components: sql
>Reporter: Vadim Pakhnushev
>Assignee: Andrey Novikov
>Priority: Major
>  Labels: ignite-3
>
> Test in the ForceIndexHintPlannerTest that verify a particular type of 
> relational operator doesn't always work, apparently the planner finds cheaper 
> index scan instead of the table scan.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Updated] (IGNITE-21416) Add documentation for FORCE_INDEX/NO_INDEX hints

2024-02-01 Thread Andrey Novikov (Jira)


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

Andrey Novikov updated IGNITE-21416:

Description: 
Globally it works the same way as in 
[https://ignite.apache.org/docs/latest/SQL/sql-calcite#force_index-no_index], 
but has some difference when FORCE_INDEX and NO_INDEX used together in the same 
query.

When both hints reference to the same index - it is invalid case. SQL is 
declarative language and we shouldn't expect {{hints}} collection is ordered:
{code:java}
SELECT /*+ FORCE_INDEX(IDX_ID), NO_INDEX */ * FROM TBL1 WHERE id = ? AND val = ?
OR
SELECT /*+ NO_INDEX(IDX_VAL), FORCE_INDEX(IDX_VAL) */ * FROM TBL1 WHERE val = 
?{code}
 

*What to do*

We need to fix example section and rewrite "Hint Scope" section.

  was:
Globally it works the same way as in 
[https://ignite.apache.org/docs/latest/SQL/sql-calcite#force_index-no_index], 
but has some difference when FORCE_INDEX and NO_INDEX used together in the same 
query.

When both hints reference to the same index - it is invalid case. SQL is 
declarative language and we shouldn't expect {{hints}} collection is 
ordered:}}{}}}
{code:java}
SELECT /*+ FORCE_INDEX(IDX_ID), NO_INDEX */ * FROM TBL1 WHERE id = ? AND val = ?
OR
SELECT /*+ NO_INDEX(IDX_VAL), FORCE_INDEX(IDX_VAL) */ * FROM TBL1 WHERE val = 
?{code}
 

*What to do*

We need to fix example section and rewrite "Hint Scope" section.


> Add documentation for FORCE_INDEX/NO_INDEX hints
> 
>
> Key: IGNITE-21416
> URL: https://issues.apache.org/jira/browse/IGNITE-21416
> Project: Ignite
>  Issue Type: Improvement
>  Components: documentation, sql
>Reporter: Andrey Novikov
>Priority: Minor
>  Labels: ignite-3
>
> Globally it works the same way as in 
> [https://ignite.apache.org/docs/latest/SQL/sql-calcite#force_index-no_index], 
> but has some difference when FORCE_INDEX and NO_INDEX used together in the 
> same query.
> When both hints reference to the same index - it is invalid case. SQL is 
> declarative language and we shouldn't expect {{hints}} collection is ordered:
> {code:java}
> SELECT /*+ FORCE_INDEX(IDX_ID), NO_INDEX */ * FROM TBL1 WHERE id = ? AND val 
> = ?
> OR
> SELECT /*+ NO_INDEX(IDX_VAL), FORCE_INDEX(IDX_VAL) */ * FROM TBL1 WHERE val = 
> ?{code}
>  
> *What to do*
> We need to fix example section and rewrite "Hint Scope" section.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Updated] (IGNITE-21416) Add documentation for FORCE_INDEX/NO_INDEX hints

2024-02-01 Thread Andrey Novikov (Jira)


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

Andrey Novikov updated IGNITE-21416:

Description: 
Globally it works the same way as in 
[https://ignite.apache.org/docs/latest/SQL/sql-calcite#force_index-no_index], 
but has some difference when FORCE_INDEX and NO_INDEX used together in the same 
query.

When both hints reference to the same index - it is invalid case. SQL is 
declarative language and we shouldn't expect {{hints}} collection is 
ordered:{{{}{}}}
{code:java}

{code}
{{SELECT /*+ FORCE_INDEX(IDX_ID), NO_INDEX */ * FROM TBL1 WHERE id = ? AND val 
= ?}}
{{OR}}
{{SELECT /*+ NO_INDEX(IDX_VAL), FORCE_INDEX(IDX_VAL) */ * FROM TBL1 WHERE val = 
?}}

 

 

*What to do*

We need to fix example section and rewrite "Hint Scope" section.

  was:
Globally it works the same way as in 
[https://ignite.apache.org/docs/latest/SQL/sql-calcite#force_index-no_index], 
but has some difference when FORCE_INDEX and NO_INDEX used together in the same 
query. When both hints reference to the same index {{SELECT /*+ 
FORCE_INDEX('idx'), NOINDEX *{*}/,{*} SELECT /*+ NO_INDEX(TBL1_IDX2), 
FORCE_INDEX(TBL2_IDX2) */, ...}}  - it is invalid case. SQL is declarative 
language and we shouldn't expect {{hints}} collection is ordered.

We need to fix example section and rewrite "Hint Scope" section.


> Add documentation for FORCE_INDEX/NO_INDEX hints
> 
>
> Key: IGNITE-21416
> URL: https://issues.apache.org/jira/browse/IGNITE-21416
> Project: Ignite
>  Issue Type: Improvement
>  Components: documentation, sql
>Reporter: Andrey Novikov
>Priority: Minor
>  Labels: ignite-3
>
> Globally it works the same way as in 
> [https://ignite.apache.org/docs/latest/SQL/sql-calcite#force_index-no_index], 
> but has some difference when FORCE_INDEX and NO_INDEX used together in the 
> same query.
> When both hints reference to the same index - it is invalid case. SQL is 
> declarative language and we shouldn't expect {{hints}} collection is 
> ordered:{{{}{}}}
> {code:java}
> {code}
> {{SELECT /*+ FORCE_INDEX(IDX_ID), NO_INDEX */ * FROM TBL1 WHERE id = ? AND 
> val = ?}}
> {{OR}}
> {{SELECT /*+ NO_INDEX(IDX_VAL), FORCE_INDEX(IDX_VAL) */ * FROM TBL1 WHERE val 
> = ?}}
>  
>  
> *What to do*
> We need to fix example section and rewrite "Hint Scope" section.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Updated] (IGNITE-21416) Add documentation for FORCE_INDEX/NO_INDEX hints

2024-02-01 Thread Andrey Novikov (Jira)


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

Andrey Novikov updated IGNITE-21416:

Description: 
Globally it works the same way as in 
[https://ignite.apache.org/docs/latest/SQL/sql-calcite#force_index-no_index], 
but has some difference when FORCE_INDEX and NO_INDEX used together in the same 
query.

When both hints reference to the same index - it is invalid case. SQL is 
declarative language and we shouldn't expect {{hints}} collection is 
ordered:}}{}}}
{code:java}
SELECT /*+ FORCE_INDEX(IDX_ID), NO_INDEX */ * FROM TBL1 WHERE id = ? AND val = ?
OR
SELECT /*+ NO_INDEX(IDX_VAL), FORCE_INDEX(IDX_VAL) */ * FROM TBL1 WHERE val = 
?{code}
 

*What to do*

We need to fix example section and rewrite "Hint Scope" section.

  was:
Globally it works the same way as in 
[https://ignite.apache.org/docs/latest/SQL/sql-calcite#force_index-no_index], 
but has some difference when FORCE_INDEX and NO_INDEX used together in the same 
query.

When both hints reference to the same index - it is invalid case. SQL is 
declarative language and we shouldn't expect {{hints}} collection is 
ordered:{{{}{}}}
{code:java}

{code}
{{SELECT /*+ FORCE_INDEX(IDX_ID), NO_INDEX */ * FROM TBL1 WHERE id = ? AND val 
= ?}}
{{OR}}
{{SELECT /*+ NO_INDEX(IDX_VAL), FORCE_INDEX(IDX_VAL) */ * FROM TBL1 WHERE val = 
?}}

 

 

*What to do*

We need to fix example section and rewrite "Hint Scope" section.


> Add documentation for FORCE_INDEX/NO_INDEX hints
> 
>
> Key: IGNITE-21416
> URL: https://issues.apache.org/jira/browse/IGNITE-21416
> Project: Ignite
>  Issue Type: Improvement
>  Components: documentation, sql
>Reporter: Andrey Novikov
>Priority: Minor
>  Labels: ignite-3
>
> Globally it works the same way as in 
> [https://ignite.apache.org/docs/latest/SQL/sql-calcite#force_index-no_index], 
> but has some difference when FORCE_INDEX and NO_INDEX used together in the 
> same query.
> When both hints reference to the same index - it is invalid case. SQL is 
> declarative language and we shouldn't expect {{hints}} collection is 
> ordered:}}{}}}
> {code:java}
> SELECT /*+ FORCE_INDEX(IDX_ID), NO_INDEX */ * FROM TBL1 WHERE id = ? AND val 
> = ?
> OR
> SELECT /*+ NO_INDEX(IDX_VAL), FORCE_INDEX(IDX_VAL) */ * FROM TBL1 WHERE val = 
> ?{code}
>  
> *What to do*
> We need to fix example section and rewrite "Hint Scope" section.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Updated] (IGNITE-21416) Add documentation for FORCE_INDEX/NO_INDEX hints

2024-01-31 Thread Andrey Novikov (Jira)


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

Andrey Novikov updated IGNITE-21416:

Description: 
Globally it works the same way as in 
[https://ignite.apache.org/docs/latest/SQL/sql-calcite#force_index-no_index], 
but has some difference when FORCE_INDEX and NO_INDEX used together in the same 
query. When both hints reference to the same index {{SELECT /*+ 
FORCE_INDEX('idx'), NOINDEX *{*}/,{*} SELECT /*+ NO_INDEX(TBL1_IDX2), 
FORCE_INDEX(TBL2_IDX2) */, ...}}  - it is invalid case. SQL is declarative 
language and we shouldn't expect {{hints}} collection is ordered.

We need to fix example section and rewrite "Hint Scope" section.

  was:
Globally it works the same way as in 
[https://ignite.apache.org/docs/latest/SQL/sql-calcite#force_index-no_index], 
but has some difference when FORCE_INDEX and NO_INDEX used together in the same 
query. When both hints reference to the same index {{SELECT /+ 
FORCE_INDEX('idx'), NOINDEX */, {{SELECT \{*}/{*}+ NO_INDEX(TBL1_IDX2), 
FORCE_INDEX(TBL2_IDX2) */, ...}} -}} it is invalid case. SQL is declarative 
language and we shouldn't expect {{hints}} collection is ordered.

We need to fix example section and rewrite "Hint Scope" section.


> Add documentation for FORCE_INDEX/NO_INDEX hints
> 
>
> Key: IGNITE-21416
> URL: https://issues.apache.org/jira/browse/IGNITE-21416
> Project: Ignite
>  Issue Type: Improvement
>  Components: documentation, sql
>Reporter: Andrey Novikov
>Priority: Minor
>  Labels: ignite-3
>
> Globally it works the same way as in 
> [https://ignite.apache.org/docs/latest/SQL/sql-calcite#force_index-no_index], 
> but has some difference when FORCE_INDEX and NO_INDEX used together in the 
> same query. When both hints reference to the same index {{SELECT /*+ 
> FORCE_INDEX('idx'), NOINDEX *{*}/,{*} SELECT /*+ NO_INDEX(TBL1_IDX2), 
> FORCE_INDEX(TBL2_IDX2) */, ...}}  - it is invalid case. SQL is declarative 
> language and we shouldn't expect {{hints}} collection is ordered.
> We need to fix example section and rewrite "Hint Scope" section.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Updated] (IGNITE-21416) Add documentation for FORCE_INDEX/NO_INDEX hints

2024-01-31 Thread Andrey Novikov (Jira)


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

Andrey Novikov updated IGNITE-21416:

Priority: Minor  (was: Major)

> Add documentation for FORCE_INDEX/NO_INDEX hints
> 
>
> Key: IGNITE-21416
> URL: https://issues.apache.org/jira/browse/IGNITE-21416
> Project: Ignite
>  Issue Type: Improvement
>  Components: documentation, sql
>Reporter: Andrey Novikov
>Priority: Minor
>  Labels: ignite-3
>
> Globally it works the same way as in 
> [https://ignite.apache.org/docs/latest/SQL/sql-calcite#force_index-no_index], 
> but has some difference when FORCE_INDEX and NO_INDEX used together in the 
> same query. When both hints reference to the same index {{SELECT /+ 
> FORCE_INDEX('idx'), NOINDEX */, {{SELECT \{*}/{*}+ NO_INDEX(TBL1_IDX2), 
> FORCE_INDEX(TBL2_IDX2) */, ...}} -}} it is invalid case. SQL is declarative 
> language and we shouldn't expect {{hints}} collection is ordered.
> We need to fix example section and rewrite "Hint Scope" section.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Updated] (IGNITE-21416) Add documentation for FORCE_INDEX/NO_INDEX hints

2024-01-31 Thread Andrey Novikov (Jira)


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

Andrey Novikov updated IGNITE-21416:

Component/s: sql

> Add documentation for FORCE_INDEX/NO_INDEX hints
> 
>
> Key: IGNITE-21416
> URL: https://issues.apache.org/jira/browse/IGNITE-21416
> Project: Ignite
>  Issue Type: Improvement
>  Components: documentation, sql
>Reporter: Andrey Novikov
>Priority: Major
>  Labels: ignite-3
>
> Globally it works the same way as in 
> [https://ignite.apache.org/docs/latest/SQL/sql-calcite#force_index-no_index], 
> but has some difference when FORCE_INDEX and NO_INDEX used together in the 
> same query. When both hints reference to the same index {{SELECT /+ 
> FORCE_INDEX('idx'), NOINDEX */, {{SELECT \{*}/{*}+ NO_INDEX(TBL1_IDX2), 
> FORCE_INDEX(TBL2_IDX2) */, ...}} -}} it is invalid case. SQL is declarative 
> language and we shouldn't expect {{hints}} collection is ordered.
> We need to fix example section and rewrite "Hint Scope" section.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Updated] (IGNITE-21416) Add documentation for FORCE_INDEX/NO_INDEX hints

2024-01-31 Thread Andrey Novikov (Jira)


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

Andrey Novikov updated IGNITE-21416:

Labels: ignite-3  (was: )

> Add documentation for FORCE_INDEX/NO_INDEX hints
> 
>
> Key: IGNITE-21416
> URL: https://issues.apache.org/jira/browse/IGNITE-21416
> Project: Ignite
>  Issue Type: Improvement
>  Components: documentation
>Reporter: Andrey Novikov
>Priority: Major
>  Labels: ignite-3
>
> Globally it works the same way as in 
> [https://ignite.apache.org/docs/latest/SQL/sql-calcite#force_index-no_index], 
> but has some difference when FORCE_INDEX and NO_INDEX used together in the 
> same query. When both hints reference to the same index {{SELECT /+ 
> FORCE_INDEX('idx'), NOINDEX */, {{SELECT \{*}/{*}+ NO_INDEX(TBL1_IDX2), 
> FORCE_INDEX(TBL2_IDX2) */, ...}} -}} it is invalid case. SQL is declarative 
> language and we shouldn't expect {{hints}} collection is ordered.
> We need to fix example section and rewrite "Hint Scope" section.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Updated] (IGNITE-21416) Add documentation for FORCE_INDEX/NO_INDEX hints

2024-01-31 Thread Andrey Novikov (Jira)


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

Andrey Novikov updated IGNITE-21416:

Description: 
Globally it works the same way as in 
[https://ignite.apache.org/docs/latest/SQL/sql-calcite#force_index-no_index], 
but has some difference when FORCE_INDEX and NO_INDEX used together in the same 
query. When both hints reference to the same index {{SELECT /+ 
FORCE_INDEX('idx'), NOINDEX */, {{SELECT \{*}/{*}+ NO_INDEX(TBL1_IDX2), 
FORCE_INDEX(TBL2_IDX2) */, ...}} -}} it is invalid case. SQL is declarative 
language and we shouldn't expect {{hints}} collection is ordered.

We need to fix example section and rewrite "Hint Scope" section.

  was:
Globally it works the same way as in 
[https://ignite.apache.org/docs/latest/SQL/sql-calcite#force_index-no_index], 
but has some difference when FORCE_INDEX and NO_INDEX used together in the same 
query. When both hints reference to the same index {{SELECT /*+ 
FORCE_INDEX('idx'), NOINDEX */, {{SELECT /*+ NO_INDEX(TBL1_IDX2), 
FORCE_INDEX(TBL2_IDX2) */, ...}} -}} it is invalid case. SQL is declarative 
language and we shouldn't expect {{hints}} collection is ordered.

We need to fix example section and rewrite "Hint Scope" section.


> Add documentation for FORCE_INDEX/NO_INDEX hints
> 
>
> Key: IGNITE-21416
> URL: https://issues.apache.org/jira/browse/IGNITE-21416
> Project: Ignite
>  Issue Type: Improvement
>  Components: documentation
>Reporter: Andrey Novikov
>Priority: Major
>
> Globally it works the same way as in 
> [https://ignite.apache.org/docs/latest/SQL/sql-calcite#force_index-no_index], 
> but has some difference when FORCE_INDEX and NO_INDEX used together in the 
> same query. When both hints reference to the same index {{SELECT /+ 
> FORCE_INDEX('idx'), NOINDEX */, {{SELECT \{*}/{*}+ NO_INDEX(TBL1_IDX2), 
> FORCE_INDEX(TBL2_IDX2) */, ...}} -}} it is invalid case. SQL is declarative 
> language and we shouldn't expect {{hints}} collection is ordered.
> We need to fix example section and rewrite "Hint Scope" section.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Created] (IGNITE-21416) Add documentation for FORCE_INDEX/NO_INDEX hints

2024-01-31 Thread Andrey Novikov (Jira)
Andrey Novikov created IGNITE-21416:
---

 Summary: Add documentation for FORCE_INDEX/NO_INDEX hints
 Key: IGNITE-21416
 URL: https://issues.apache.org/jira/browse/IGNITE-21416
 Project: Ignite
  Issue Type: Improvement
  Components: documentation
Reporter: Andrey Novikov


Globally it works the same way as in 
[https://ignite.apache.org/docs/latest/SQL/sql-calcite#force_index-no_index], 
but has some difference when FORCE_INDEX and NO_INDEX used together in the same 
query. When both hints reference to the same index {{SELECT /*+ 
FORCE_INDEX('idx'), NOINDEX */, {{SELECT /*+ NO_INDEX(TBL1_IDX2), 
FORCE_INDEX(TBL2_IDX2) */, ...}} -}} it is invalid case. SQL is declarative 
language and we shouldn't expect {{hints}} collection is ordered.

We need to fix example section and rewrite "Hint Scope" section.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Updated] (IGNITE-21404) Do not wrap SqlException into RuntimeException for PlannerHelper.optimize

2024-01-31 Thread Andrey Novikov (Jira)


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

Andrey Novikov updated IGNITE-21404:

Labels: ignite-3  (was: )

> Do not wrap SqlException into RuntimeException for PlannerHelper.optimize
> -
>
> Key: IGNITE-21404
> URL: https://issues.apache.org/jira/browse/IGNITE-21404
> Project: Ignite
>  Issue Type: Improvement
>  Components: jdbc, sql
>Affects Versions: 3.0.0-beta1
>Reporter: Andrey Novikov
>Priority: Minor
>  Labels: ignite-3
>
> VolcanoRuleCall.java:250 wrap any exception into RuntimeException, so it can 
> break UX for public API as the actual exception will be in cause
>  
> {code:java}
> Caused by: java.lang.RuntimeException: Error while applying rule 
> ExposeIndexRule, args 
> [rel#27:IgniteLogicalTableScan.NONE.[].any(table=[PUBLIC, 
> TBL1],filters=AND(=($t2, _UTF-8'v'), =($t3, _UTF-8'v')),requiredColumns={0, 
> 1, 2, 3})]
>   at 
> org.apache.calcite.plan.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:250)
>   at 
> org.apache.calcite.plan.volcano.TopDownRuleDriver.applyGenerator(TopDownRuleDriver.java:151)
>   at 
> org.apache.calcite.plan.volcano.TopDownRuleDriver.access$600(TopDownRuleDriver.java:51)
>   at 
> org.apache.calcite.plan.volcano.TopDownRuleDriver$ApplyRule.perform(TopDownRuleDriver.java:532)
>   at 
> org.apache.calcite.plan.volcano.TopDownRuleDriver.drive(TopDownRuleDriver.java:109)
>   at 
> org.apache.calcite.plan.volcano.VolcanoPlanner.findBestExp(VolcanoPlanner.java:524)
>   at 
> org.apache.calcite.tools.Programs$RuleSetProgram.run(Programs.java:328)
>   at 
> org.apache.ignite.internal.sql.engine.prepare.IgnitePlanner.transform(IgnitePlanner.java:386)
>   at 
> org.apache.ignite.internal.sql.engine.prepare.PlannerHelper.optimize(PlannerHelper.java:125)
>   at 
> org.apache.ignite.internal.sql.engine.planner.AbstractPlannerTest.physicalPlan(AbstractPlannerTest.java:384)
>   at 
> org.apache.ignite.internal.sql.engine.planner.AbstractPlannerTest.physicalPlan(AbstractPlannerTest.java:372)
>   at 
> org.apache.ignite.internal.sql.engine.planner.AbstractPlannerTest.physicalPlan(AbstractPlannerTest.java:356)
>   at 
> org.apache.ignite.internal.sql.engine.planner.AbstractPlannerTest.physicalPlan(AbstractPlannerTest.java:344)
>   at 
> org.apache.ignite.internal.sql.engine.planner.AbstractPlannerTest.physicalPlan(AbstractPlannerTest.java:333)
>   at 
> org.apache.ignite.internal.sql.engine.planner.hints.ForceIndexHintPlannerTest.lambda$testWithMultipleIndexHints$0(ForceIndexHintPlannerTest.java:137)
>   at 
> org.apache.ignite.internal.testframework.IgniteTestUtils.assertThrowsWithCause(IgniteTestUtils.java:313)
>  {code}
> h3. Steps to reproduce
>  
> Replace 
> IgniteTestUtils.assertThrowsWithCause to assertThrowsSqlException
> For tests:
> HashIndexPlannerTest#testHashIndexIsNotAppliedWithoutConditions,
> HashIndexPlannerTest#hashIndexIsNotAppliedForRangeCondition
>  
> Expected that SqlException will be thrown, not RuntimeException with 
> SqlException as cause



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Created] (IGNITE-21404) Do not wrap SqlException into RuntimeException for PlannerHelper.optimize

2024-01-31 Thread Andrey Novikov (Jira)
Andrey Novikov created IGNITE-21404:
---

 Summary: Do not wrap SqlException into RuntimeException for 
PlannerHelper.optimize
 Key: IGNITE-21404
 URL: https://issues.apache.org/jira/browse/IGNITE-21404
 Project: Ignite
  Issue Type: Improvement
  Components: jdbc, sql
Affects Versions: 3.0.0-beta1
Reporter: Andrey Novikov


VolcanoRuleCall.java:250 wrap any exception into RuntimeException, so it can 
break UX for public API as the actual exception will be in cause

 
{code:java}
Caused by: java.lang.RuntimeException: Error while applying rule 
ExposeIndexRule, args [rel#27:IgniteLogicalTableScan.NONE.[].any(table=[PUBLIC, 
TBL1],filters=AND(=($t2, _UTF-8'v'), =($t3, _UTF-8'v')),requiredColumns={0, 1, 
2, 3})]
at 
org.apache.calcite.plan.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:250)
at 
org.apache.calcite.plan.volcano.TopDownRuleDriver.applyGenerator(TopDownRuleDriver.java:151)
at 
org.apache.calcite.plan.volcano.TopDownRuleDriver.access$600(TopDownRuleDriver.java:51)
at 
org.apache.calcite.plan.volcano.TopDownRuleDriver$ApplyRule.perform(TopDownRuleDriver.java:532)
at 
org.apache.calcite.plan.volcano.TopDownRuleDriver.drive(TopDownRuleDriver.java:109)
at 
org.apache.calcite.plan.volcano.VolcanoPlanner.findBestExp(VolcanoPlanner.java:524)
at 
org.apache.calcite.tools.Programs$RuleSetProgram.run(Programs.java:328)
at 
org.apache.ignite.internal.sql.engine.prepare.IgnitePlanner.transform(IgnitePlanner.java:386)
at 
org.apache.ignite.internal.sql.engine.prepare.PlannerHelper.optimize(PlannerHelper.java:125)
at 
org.apache.ignite.internal.sql.engine.planner.AbstractPlannerTest.physicalPlan(AbstractPlannerTest.java:384)
at 
org.apache.ignite.internal.sql.engine.planner.AbstractPlannerTest.physicalPlan(AbstractPlannerTest.java:372)
at 
org.apache.ignite.internal.sql.engine.planner.AbstractPlannerTest.physicalPlan(AbstractPlannerTest.java:356)
at 
org.apache.ignite.internal.sql.engine.planner.AbstractPlannerTest.physicalPlan(AbstractPlannerTest.java:344)
at 
org.apache.ignite.internal.sql.engine.planner.AbstractPlannerTest.physicalPlan(AbstractPlannerTest.java:333)
at 
org.apache.ignite.internal.sql.engine.planner.hints.ForceIndexHintPlannerTest.lambda$testWithMultipleIndexHints$0(ForceIndexHintPlannerTest.java:137)
at 
org.apache.ignite.internal.testframework.IgniteTestUtils.assertThrowsWithCause(IgniteTestUtils.java:313)
 {code}
h3. Steps to reproduce

 

Replace 
IgniteTestUtils.assertThrowsWithCause to assertThrowsSqlException
For tests:
HashIndexPlannerTest#testHashIndexIsNotAppliedWithoutConditions,
HashIndexPlannerTest#hashIndexIsNotAppliedForRangeCondition
 
Expected that SqlException will be thrown, not RuntimeException with 
SqlException as cause



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Comment Edited] (IGNITE-20882) Append performance tests

2024-01-24 Thread Andrey Novikov (Jira)


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

Andrey Novikov edited comment on IGNITE-20882 at 1/24/24 8:28 AM:
--

 
Single-node embedded (CriteriaSingleNodeBenchmark):
||Benchmark||Score(us/op)||
|criteriaGet|1780,171 ± 35,306|
|kvGet|121,114 ±  1,726|
|sqlGet|1703,928 ± 34,945|

Two nodes, thin client(CriteriaThinClientBenchmark):
||Benchmark||Score(us/op)||
|criteriaGet|1780,171 ± 35,306|
|kvGet|251,105 ± 8,618|
|sqlGet|2694,740 ± 72,396|
|criteriaGetNonNullTxDisablesPartitionAwareness|2935,503 ± 192,479|
|kvGetNonNullTxDisablesPartitionAwareness|352,037 ± 7,819|
|sqlGetNonNullTxDisablesPartitionAwareness|2814,066 ± 88,770|
|sqlIterate|1603991,380 ± 12153,762|
|criteriaIterate|1501173,640 ± 31600,562|

 


was (Author: anovikov):
 
Single-node embedded:
||Benchmark||Score(us/op)||
|CriteriaSingleNodeBenchmark.criteriaGet|1780,171 ± 35,306|
|CriteriaSingleNodeBenchmark.kvGet|121,114 ±  1,726|
|CriteriaSingleNodeBenchmark.sqlGet|1703,928 ± 34,945|

 

 

> Append performance tests
> 
>
> Key: IGNITE-20882
> URL: https://issues.apache.org/jira/browse/IGNITE-20882
> Project: Ignite
>  Issue Type: Improvement
>  Components: sql
>Reporter: Andrey Novikov
>Assignee: Andrey Novikov
>Priority: Major
>  Labels: ignite-3
>  Time Spent: 10m
>  Remaining Estimate: 0h
>
> # Compare single-key criteria vs single-key SQL vs table.get(PK)
>  * Expect to have similar performance
>  * Check single-node embedded, distributed with no partition awareness, 
> distributed with partition awareness
>  * NOTE: future improvement for criteria query – lookup affinity node if PK 
> or colocation key is in the criteria.
>  # Compare criteria vs SQL when affinity key is specified (unicast when 
> partition pruning is added)
>  # Compare criteria vs SQL for broadcast queries – latency and throughput
>  # Compare criteria vs SQL – time it takes to iterate over 10kk entries



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Assigned] (IGNITE-21278) Add FORCE_INDEX/NO_INDEX hints for calcite engine

2024-01-17 Thread Andrey Novikov (Jira)


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

Andrey Novikov reassigned IGNITE-21278:
---

Assignee: Andrey Novikov

> Add FORCE_INDEX/NO_INDEX hints for calcite engine
> -
>
> Key: IGNITE-21278
> URL: https://issues.apache.org/jira/browse/IGNITE-21278
> Project: Ignite
>  Issue Type: Improvement
>  Components: sql
>Reporter: Andrey Novikov
>Assignee: Andrey Novikov
>Priority: Major
>  Labels: ignite-3
>
> As part of hints for Calcite, we could try to implement simple hint like 
> FORCE_INDEX/NO_INDEX.
> As reference ignite 2.x documentation can be used 
> [https://ignite.apache.org/docs/latest/SQL/sql-calcite#force_index-no_index]



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Updated] (IGNITE-21278) Add FORCE_INDEX/NO_INDEX hints for calcite engine

2024-01-16 Thread Andrey Novikov (Jira)


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

Andrey Novikov updated IGNITE-21278:

Description: 
As part of hints for Calcite, we could try to implement simple hint like 
FORCE_INDEX/NO_INDEX.

As reference ignite 2.x documentation can be used 
[https://ignite.apache.org/docs/latest/SQL/sql-calcite#force_index-no_index]

  was:As part of hints for Calcite, we could try to implement simple hint like 
FORCE_INDEX/NO_INDEX.


> Add FORCE_INDEX/NO_INDEX hints for calcite engine
> -
>
> Key: IGNITE-21278
> URL: https://issues.apache.org/jira/browse/IGNITE-21278
> Project: Ignite
>  Issue Type: Improvement
>  Components: sql
>Reporter: Andrey Novikov
>Priority: Major
>  Labels: ignite-3
>
> As part of hints for Calcite, we could try to implement simple hint like 
> FORCE_INDEX/NO_INDEX.
> As reference ignite 2.x documentation can be used 
> [https://ignite.apache.org/docs/latest/SQL/sql-calcite#force_index-no_index]



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Updated] (IGNITE-21278) Add FORCE_INDEX/NO_INDEX hints for calcite engine

2024-01-16 Thread Andrey Novikov (Jira)


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

Andrey Novikov updated IGNITE-21278:

Labels: ignite-3  (was: )

> Add FORCE_INDEX/NO_INDEX hints for calcite engine
> -
>
> Key: IGNITE-21278
> URL: https://issues.apache.org/jira/browse/IGNITE-21278
> Project: Ignite
>  Issue Type: Improvement
>  Components: sql
>Reporter: Andrey Novikov
>Priority: Major
>  Labels: ignite-3
>
> As part of hints for Calcite, we could try to implement simple hint like 
> FORCE_INDEX/NO_INDEX.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Created] (IGNITE-21278) Add FORCE_INDEX/NO_INDEX hints for calcite engine

2024-01-16 Thread Andrey Novikov (Jira)
Andrey Novikov created IGNITE-21278:
---

 Summary: Add FORCE_INDEX/NO_INDEX hints for calcite engine
 Key: IGNITE-21278
 URL: https://issues.apache.org/jira/browse/IGNITE-21278
 Project: Ignite
  Issue Type: Improvement
  Components: sql
Reporter: Andrey Novikov


As part of hints for Calcite, we could try to implement simple hint like 
FORCE_INDEX/NO_INDEX.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Updated] (IGNITE-20881) Add ability to enforce an index to be used

2024-01-16 Thread Andrey Novikov (Jira)


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

Andrey Novikov updated IGNITE-20881:

Description: 
*What to do:*
 * Extend criteria api with index hint

 * Generate SQL with hint

 * Add a test that verifies that the passed index is used in the query

As reference ignite 2.x implementation can be used 
[https://ignite.apache.org/docs/latest/SQL/sql-calcite#force_index-no_index]

> Add ability to enforce an index to be used
> --
>
> Key: IGNITE-20881
> URL: https://issues.apache.org/jira/browse/IGNITE-20881
> Project: Ignite
>  Issue Type: Improvement
>  Components: sql
>Reporter: Andrey Novikov
>Assignee: Andrey Novikov
>Priority: Major
>  Labels: ignite-3
>
> *What to do:*
>  * Extend criteria api with index hint
>  * Generate SQL with hint
>  * Add a test that verifies that the passed index is used in the query
> As reference ignite 2.x implementation can be used 
> [https://ignite.apache.org/docs/latest/SQL/sql-calcite#force_index-no_index]



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Updated] (IGNITE-20881) Add ability to enforce an index to be used

2024-01-16 Thread Andrey Novikov (Jira)


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

Andrey Novikov updated IGNITE-20881:

Description: 
*What to do:*
 * Extend criteria api with index hint

 * Generate SQL with hint

 * Add a test that verifies that the passed index is used in the query

As reference ignite 2.x documentation can be used 
[https://ignite.apache.org/docs/latest/SQL/sql-calcite#force_index-no_index]

  was:
*What to do:*
 * Extend criteria api with index hint

 * Generate SQL with hint

 * Add a test that verifies that the passed index is used in the query

As reference ignite 2.x implementation can be used 
[https://ignite.apache.org/docs/latest/SQL/sql-calcite#force_index-no_index]


> Add ability to enforce an index to be used
> --
>
> Key: IGNITE-20881
> URL: https://issues.apache.org/jira/browse/IGNITE-20881
> Project: Ignite
>  Issue Type: Improvement
>  Components: sql
>Reporter: Andrey Novikov
>Assignee: Andrey Novikov
>Priority: Major
>  Labels: ignite-3
>
> *What to do:*
>  * Extend criteria api with index hint
>  * Generate SQL with hint
>  * Add a test that verifies that the passed index is used in the query
> As reference ignite 2.x documentation can be used 
> [https://ignite.apache.org/docs/latest/SQL/sql-calcite#force_index-no_index]



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Updated] (IGNITE-20878) Basic criteria queries for record view

2024-01-04 Thread Andrey Novikov (Jira)


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

Andrey Novikov updated IGNITE-20878:

Fix Version/s: 3.0.0-beta2

> Basic criteria queries for record view
> --
>
> Key: IGNITE-20878
> URL: https://issues.apache.org/jira/browse/IGNITE-20878
> Project: Ignite
>  Issue Type: New Feature
>  Components: sql
>Reporter: Andrey Novikov
>Assignee: Andrey Novikov
>Priority: Major
>  Labels: ignite-3
> Fix For: 3.0.0-beta2
>
>  Time Spent: 18h 20m
>  Remaining Estimate: 0h
>
> Implement basic criteria query for record view.
> The only field in {{CreteriaQueryOptions}} should be {{{}pageSize{}}}.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Commented] (IGNITE-20882) Append performance tests

2023-12-26 Thread Andrey Novikov (Jira)


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

Andrey Novikov commented on IGNITE-20882:
-

 
Single-node embedded:
||Benchmark||Score(us/op)||
|CriteriaSingleNodeBenchmark.criteriaGet|1780,171 ± 35,306|
|CriteriaSingleNodeBenchmark.kvGet|121,114 ±  1,726|
|CriteriaSingleNodeBenchmark.sqlGet|1703,928 ± 34,945|

 

 

> Append performance tests
> 
>
> Key: IGNITE-20882
> URL: https://issues.apache.org/jira/browse/IGNITE-20882
> Project: Ignite
>  Issue Type: Improvement
>  Components: sql
>Reporter: Andrey Novikov
>Assignee: Andrey Novikov
>Priority: Major
>  Labels: ignite-3
>
> # Compare single-key criteria vs single-key SQL vs table.get(PK)
>  * Expect to have similar performance
>  * Check single-node embedded, distributed with no partition awareness, 
> distributed with partition awareness
>  * NOTE: future improvement for criteria query – lookup affinity node if PK 
> or colocation key is in the criteria.
>  # Compare criteria vs SQL when affinity key is specified (unicast when 
> partition pruning is added)
>  # Compare criteria vs SQL for broadcast queries – latency and throughput
>  # Compare criteria vs SQL – time it takes to iterate over 10kk entries



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Assigned] (IGNITE-21146) Error handling in Criteria queries

2023-12-24 Thread Andrey Novikov (Jira)


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

Andrey Novikov reassigned IGNITE-21146:
---

Assignee: Andrey Novikov

> Error handling in Criteria queries
> --
>
> Key: IGNITE-21146
> URL: https://issues.apache.org/jira/browse/IGNITE-21146
> Project: Ignite
>  Issue Type: Improvement
>  Components: sql
>Reporter: Andrey Novikov
>Assignee: Andrey Novikov
>Priority: Major
>  Labels: ignite-3
>
> Criteria query as a part of public Ignite API should throw only public 
> exceptions to end users that not depend from implementation.
> *What to do:*
>  * add exception conversation from SqlException to public one
>  * add tests to check exceptions along with error messages, groups, codes



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Updated] (IGNITE-21146) Error handling in Criteria queries

2023-12-24 Thread Andrey Novikov (Jira)


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

Andrey Novikov updated IGNITE-21146:

Labels: ignite-3  (was: )

> Error handling in Criteria queries
> --
>
> Key: IGNITE-21146
> URL: https://issues.apache.org/jira/browse/IGNITE-21146
> Project: Ignite
>  Issue Type: Improvement
>  Components: sql
>Reporter: Andrey Novikov
>Priority: Major
>  Labels: ignite-3
>
> Criteria query as a part of public Ignite API should throw only public 
> exceptions to end users that not depend from implementation.
> *What to do:*
>  * add exception conversation from SqlException to public one
>  * add tests to check exceptions along with error messages, groups, codes



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Created] (IGNITE-21146) Error handling in Criteria queries

2023-12-24 Thread Andrey Novikov (Jira)
Andrey Novikov created IGNITE-21146:
---

 Summary: Error handling in Criteria queries
 Key: IGNITE-21146
 URL: https://issues.apache.org/jira/browse/IGNITE-21146
 Project: Ignite
  Issue Type: Improvement
  Components: sql
Reporter: Andrey Novikov


Criteria query as a part of public Ignite API should throw only public 
exceptions to end users that not depend from implementation.

*What to do:*
 * add exception conversation from SqlException to public one
 * add tests to check exceptions along with error messages, groups, codes



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Updated] (IGNITE-20878) Basic criteria queries for record view

2023-12-13 Thread Andrey Novikov (Jira)


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

Andrey Novikov updated IGNITE-20878:

Description: 
Implement basic criteria query for record view.

The only field in {{CreteriaQueryOptions}} should be {{{}pageSize{}}}.

  was:
Implement basic criteria query for record view.

The only field in {{CreteriaQueryOptions}} should be {{{}pageSize{}}}.

Criteria to implement: equals


> Basic criteria queries for record view
> --
>
> Key: IGNITE-20878
> URL: https://issues.apache.org/jira/browse/IGNITE-20878
> Project: Ignite
>  Issue Type: New Feature
>  Components: sql
>Reporter: Andrey Novikov
>Assignee: Andrey Novikov
>Priority: Major
>  Labels: ignite-3
>  Time Spent: 4h 40m
>  Remaining Estimate: 0h
>
> Implement basic criteria query for record view.
> The only field in {{CreteriaQueryOptions}} should be {{{}pageSize{}}}.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Assigned] (IGNITE-20977) Basic criteria queries for keyValue view

2023-11-28 Thread Andrey Novikov (Jira)


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

Andrey Novikov reassigned IGNITE-20977:
---

Assignee: Andrey Novikov

> Basic criteria queries for keyValue view
> 
>
> Key: IGNITE-20977
> URL: https://issues.apache.org/jira/browse/IGNITE-20977
> Project: Ignite
>  Issue Type: Improvement
>  Components: sql
>Reporter: Andrey Novikov
>Assignee: Andrey Novikov
>Priority: Major
>  Labels: ignite-3
>
> Implement basic criteria query for keyValue view.
> For binary view manually map SqlRow to Entry using a schema, 
> e.g. like {{RecordView.put()}}  does.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Updated] (IGNITE-20977) Basic criteria queries for keyValue view

2023-11-28 Thread Andrey Novikov (Jira)


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

Andrey Novikov updated IGNITE-20977:

Labels: ignite-3  (was: )

> Basic criteria queries for keyValue view
> 
>
> Key: IGNITE-20977
> URL: https://issues.apache.org/jira/browse/IGNITE-20977
> Project: Ignite
>  Issue Type: Improvement
>  Components: sql
>Reporter: Andrey Novikov
>Priority: Major
>  Labels: ignite-3
>
> Implement basic criteria query for keyValue view.
> For binary view manually map SqlRow to Entry using a schema, 
> e.g. like {{RecordView.put()}}  does.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Created] (IGNITE-20977) Basic criteria queries for keyValue view

2023-11-28 Thread Andrey Novikov (Jira)
Andrey Novikov created IGNITE-20977:
---

 Summary: Basic criteria queries for keyValue view
 Key: IGNITE-20977
 URL: https://issues.apache.org/jira/browse/IGNITE-20977
 Project: Ignite
  Issue Type: Improvement
  Components: sql
Reporter: Andrey Novikov


Implement basic criteria query for keyValue view.

For binary view manually map SqlRow to Entry using a schema, e.g. 
like {{RecordView.put()}}  does.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Updated] (IGNITE-20878) Basic criteria queries for record view

2023-11-27 Thread Andrey Novikov (Jira)


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

Andrey Novikov updated IGNITE-20878:

Summary: Basic criteria queries for record view  (was: Basic criteria 
queries)

> Basic criteria queries for record view
> --
>
> Key: IGNITE-20878
> URL: https://issues.apache.org/jira/browse/IGNITE-20878
> Project: Ignite
>  Issue Type: New Feature
>  Components: sql
>Reporter: Andrey Novikov
>Assignee: Andrey Novikov
>Priority: Major
>  Labels: ignite-3
>  Time Spent: 10m
>  Remaining Estimate: 0h
>
> Implement basic criteria query for record view.
> The only field in {{CreteriaQueryOptions}} should be {{{}pageSize{}}}.
> Criteria to implement: equals



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Updated] (IGNITE-20878) Basic criteria queries

2023-11-27 Thread Andrey Novikov (Jira)


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

Andrey Novikov updated IGNITE-20878:

Description: 
Implement basic criteria query for record view.

The only field in {{CreteriaQueryOptions}} should be {{{}pageSize{}}}.

Criteria to implement: equals

  was:
Implement basic criteria query. The only field in {{CreteriaQueryOptions}} 
should be {{{}pageSize{}}}.

Criteria to implement: equals


> Basic criteria queries
> --
>
> Key: IGNITE-20878
> URL: https://issues.apache.org/jira/browse/IGNITE-20878
> Project: Ignite
>  Issue Type: New Feature
>  Components: sql
>Reporter: Andrey Novikov
>Assignee: Andrey Novikov
>Priority: Major
>  Labels: ignite-3
>  Time Spent: 10m
>  Remaining Estimate: 0h
>
> Implement basic criteria query for record view.
> The only field in {{CreteriaQueryOptions}} should be {{{}pageSize{}}}.
> Criteria to implement: equals



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Assigned] (IGNITE-20879) Additional criterions for queries

2023-11-23 Thread Andrey Novikov (Jira)


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

Andrey Novikov reassigned IGNITE-20879:
---

Assignee: Andrey Novikov

> Additional criterions for queries
> -
>
> Key: IGNITE-20879
> URL: https://issues.apache.org/jira/browse/IGNITE-20879
> Project: Ignite
>  Issue Type: Improvement
>  Components: sql
>Reporter: Andrey Novikov
>Assignee: Andrey Novikov
>Priority: Major
>  Labels: ignite-3
>
> Suggested Predicates List:
>  * Comparisons: >, <, >=, <=, IN
>  * Combination: AND, OR, NOT
>  * Nulls: IS NULL, IS NOT NULL



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Assigned] (IGNITE-20881) Add ability to enforce an index to be used

2023-11-23 Thread Andrey Novikov (Jira)


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

Andrey Novikov reassigned IGNITE-20881:
---

Assignee: Andrey Novikov

> Add ability to enforce an index to be used
> --
>
> Key: IGNITE-20881
> URL: https://issues.apache.org/jira/browse/IGNITE-20881
> Project: Ignite
>  Issue Type: Improvement
>  Components: sql
>Reporter: Andrey Novikov
>Assignee: Andrey Novikov
>Priority: Major
>  Labels: ignite-3
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Assigned] (IGNITE-20882) Append performance tests

2023-11-23 Thread Andrey Novikov (Jira)


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

Andrey Novikov reassigned IGNITE-20882:
---

Assignee: Andrey Novikov

> Append performance tests
> 
>
> Key: IGNITE-20882
> URL: https://issues.apache.org/jira/browse/IGNITE-20882
> Project: Ignite
>  Issue Type: Improvement
>  Components: sql
>Reporter: Andrey Novikov
>Assignee: Andrey Novikov
>Priority: Major
>  Labels: ignite-3
>
> # Compare single-key criteria vs single-key SQL vs table.get(PK)
>  * Expect to have similar performance
>  * Check single-node embedded, distributed with no partition awareness, 
> distributed with partition awareness
>  * NOTE: future improvement for criteria query – lookup affinity node if PK 
> or colocation key is in the criteria.
>  # Compare criteria vs SQL when affinity key is specified (unicast when 
> partition pruning is added)
>  # Compare criteria vs SQL for broadcast queries – latency and throughput
>  # Compare criteria vs SQL – time it takes to iterate over 10kk entries



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Assigned] (IGNITE-20878) Basic criteria queries

2023-11-17 Thread Andrey Novikov (Jira)


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

Andrey Novikov reassigned IGNITE-20878:
---

Assignee: Andrey Novikov

> Basic criteria queries
> --
>
> Key: IGNITE-20878
> URL: https://issues.apache.org/jira/browse/IGNITE-20878
> Project: Ignite
>  Issue Type: New Feature
>  Components: sql
>Reporter: Andrey Novikov
>Assignee: Andrey Novikov
>Priority: Major
>
> Implement basic criteria query. The only field in {{CreteriaQueryOptions}} 
> should be {{{}pageSize{}}}.
> Criteria to implement: equals



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Created] (IGNITE-20882) Append performance tests

2023-11-16 Thread Andrey Novikov (Jira)
Andrey Novikov created IGNITE-20882:
---

 Summary: Append performance tests
 Key: IGNITE-20882
 URL: https://issues.apache.org/jira/browse/IGNITE-20882
 Project: Ignite
  Issue Type: Improvement
  Components: sql
Reporter: Andrey Novikov


# Compare single-key criteria vs single-key SQL vs table.get(PK)
 * Expect to have similar performance
 * Check single-node embedded, distributed with no partition awareness, 
distributed with partition awareness
 * NOTE: future improvement for criteria query – lookup affinity node if PK or 
colocation key is in the criteria.


 # Compare criteria vs SQL when affinity key is specified (unicast when 
partition pruning is added)
 # Compare criteria vs SQL for broadcast queries – latency and throughput
 # Compare criteria vs SQL – time it takes to iterate over 10kk entries



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Created] (IGNITE-20881) Add ability to enforce an index to be used

2023-11-16 Thread Andrey Novikov (Jira)
Andrey Novikov created IGNITE-20881:
---

 Summary: Add ability to enforce an index to be used
 Key: IGNITE-20881
 URL: https://issues.apache.org/jira/browse/IGNITE-20881
 Project: Ignite
  Issue Type: Improvement
  Components: sql
Reporter: Andrey Novikov






--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Created] (IGNITE-20879) Additional criterions for queries

2023-11-16 Thread Andrey Novikov (Jira)
Andrey Novikov created IGNITE-20879:
---

 Summary: Additional criterions for queries
 Key: IGNITE-20879
 URL: https://issues.apache.org/jira/browse/IGNITE-20879
 Project: Ignite
  Issue Type: Improvement
  Components: sql
Reporter: Andrey Novikov


Suggested Predicates List:
 * Comparisons: >, <, >=, <=, IN
 * Combination: AND, OR, NOT
 * Nulls: IS NULL, IS NOT NULL



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Created] (IGNITE-20878) Basic criteria queries

2023-11-16 Thread Andrey Novikov (Jira)
Andrey Novikov created IGNITE-20878:
---

 Summary: Basic criteria queries
 Key: IGNITE-20878
 URL: https://issues.apache.org/jira/browse/IGNITE-20878
 Project: Ignite
  Issue Type: New Feature
  Components: sql
Reporter: Andrey Novikov


Implement basic criteria query. The only field in {{CreteriaQueryOptions}} 
should be {{{}pageSize{}}}.

Criteria to implement: equals



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Updated] (IGNITE-20865) Ignite 3.0: Criteria API queries

2023-11-15 Thread Andrey Novikov (Jira)


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

Andrey Novikov updated IGNITE-20865:

Labels: ignite-3  (was: )

> Ignite 3.0: Criteria API queries
> 
>
> Key: IGNITE-20865
> URL: https://issues.apache.org/jira/browse/IGNITE-20865
> Project: Ignite
>  Issue Type: Epic
>  Components: sql
>Reporter: Andrey Novikov
>Priority: Major
>  Labels: ignite-3
>
> Criteria Query is logically just a facade for SQL – same way as Criteria API 
> is a facade for SQL in JPA. The easiest way to implement this feature then is 
> to just generate SQL queries.
> There are different gateways to a table called Table Views. Currently we have 
> RecordView and KeyValueView. *Each view* should have the Criteria Query API. 
> The only difference is the type of objects the query result maps to.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Created] (IGNITE-20865) Ignite 3.0: Criteria API queries

2023-11-15 Thread Andrey Novikov (Jira)
Andrey Novikov created IGNITE-20865:
---

 Summary: Ignite 3.0: Criteria API queries
 Key: IGNITE-20865
 URL: https://issues.apache.org/jira/browse/IGNITE-20865
 Project: Ignite
  Issue Type: Epic
  Components: sql
Reporter: Andrey Novikov


Criteria Query is logically just a facade for SQL – same way as Criteria API is 
a facade for SQL in JPA. The easiest way to implement this feature then is to 
just generate SQL queries.

There are different gateways to a table called Table Views. Currently we have 
RecordView and KeyValueView. *Each view* should have the Criteria Query API. 
The only difference is the type of objects the query result maps to.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Updated] (IGNITE-18302) ignite-spring-sessions: IgniteSession serialization drags its parent class

2023-09-10 Thread Andrey Novikov (Jira)


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

Andrey Novikov updated IGNITE-18302:

Fix Version/s: (was: 2.16)

> ignite-spring-sessions: IgniteSession serialization drags its parent class
> --
>
> Key: IGNITE-18302
> URL: https://issues.apache.org/jira/browse/IGNITE-18302
> Project: Ignite
>  Issue Type: Bug
>  Components: extensions
>Affects Versions: 2.15
>Reporter: Alexandr Shapkin
>Assignee: Andrey Novikov
>Priority: Major
>
> In short, there is a bug in ignite-spring-session-ext implementation.
> We store IgniteIndexedSessionRepository${{{}IgniteSession{}}} in the cache, 
> but it’s an internal non-static class, having a reference to the parent 
> [\{{{}IgniteIndexedSessionRepository{}}}] indirectly.
> Hence, during the serialization Ignite also writes {{{}name=this$0, 
> type=Object, fieldId=0xCBDD23AA (-874699862){}}}, which is the reference to 
> {{{}IgniteIndexedSessionRepository{}}}. That leads to the following issues:
>  * we are serializing and saving internal utility data, like}} Ignite 
> ignite{}}}, {{private IndexResolver indexResolver}} etc
>  * one of the IgniteIndexedSessionRepository’s fields is IgniteCache itself - 
> {{IgniteCache sessions}} that basically keeps every 
> session so far leading to a StackOverflow error after some time. 
>  
> {code:java}
> [2022-11-25T17:27:29,268][ERROR][sys-stripe-0-#1%USERS_IGNITE%][GridCacheIoManager]
>  Failed processing message [senderId=0f0ca915-d6cd-4580-92a3-1fbc3d2a5722, 
> msg=GridNearSingleGetResponse [futId=1669397231378, res=-547701325, 
> topVer=null, err=null, flags=0]] 2java.lang.StackOverflowError: null 3 at 
> org.apache.ignite.internal.marshaller.optimized.OptimizedMarshallerUtils.descriptorFromCache(OptimizedMarshallerUtils.java:328)
>  ~[ignite-core-8.8.22.jar:8.8.22] 4 at 
> org.apache.ignite.internal.marshaller.optimized.OptimizedMarshallerUtils.classDescriptor(OptimizedMarshallerUtils.java:273)
>  ~[ignite-core-8.8.22.jar:8.8.22] 5 at 
> org.apache.ignite.internal.marshaller.optimized.OptimizedObjectInputStream.readObject0(OptimizedObjectInputStream.java:354)
>  ~[ignite-core-8.8.22.jar:8.8.22] 6 at 
> org.apache.ignite.internal.marshaller.optimized.OptimizedObjectInputStream.readObjectOverride(OptimizedObjectInputStream.java:211)
>  ~[ignite-core-8.8.22.jar:8.8.22] 7 at 
> java.io.ObjectInputStream.readObject(ObjectInputStream.java:480) ~[?:?] 8 at 
> java.io.ObjectInputStream.readObject(ObjectInputStream.java:447) ~[?:?] 9 at 
> org.apache.ignite.internal.processors.cache.GridCacheProxyImpl.readExternal(GridCacheProxyImpl.java:1662)
>  ~[ignite-core-8.8.22.jar:8.8.22] 10 at 
> org.apache.ignite.internal.marshaller.optimized.OptimizedObjectInputStream.readExternalizable(OptimizedObjectInputStream.java:569)
>  ~[ignite-core-8.8.22.jar:8.8.22] 11 at 
> org.apache.ignite.internal.marshaller.optimized.OptimizedClassDescriptor.read(OptimizedClassDescriptor.java:979)
>  ~[ignite-core-8.8.22.jar:8.8.22] 12 at 
> org.apache.ignite.internal.marshaller.optimized.OptimizedObjectInputStream.readObject0(OptimizedObjectInputStream.java:359)
>  ~[ignite-core-8.8.22.jar:8.8.22] 13 at 
> org.apache.ignite.internal.marshaller.optimized.OptimizedObjectInputStream.readObjectOverride(OptimizedObjectInputStream.java:211)
>  ~[ignite-core-8.8.22.jar:8.8.22] 14 at 
> java.io.ObjectInputStream.readObject(ObjectInputStream.java:480) ~[?:?] 15 at 
> java.io.ObjectInputStream.readObject(ObjectInputStream.java:447) ~[?:?] 16... 
> 17[2022-11-25T17:27:29,276][ERROR][sys-stripe-0-#1%USERS_IGNITE%][] Critical 
> system error detected. Will be handled accordingly to configured handler 
> [hnd=StopNodeOrHaltFailureHandler [tryStop=false, timeout=0, 
> super=AbstractFailureHandler [ignoredFailureTypes=UnmodifiableSet 
> [SYSTEM_WORKER_BLOCKED, SYSTEM_CRITICAL_OPERATION_TIMEOUT]]], 
> failureCtx=FailureContext [type=CRITICAL_ERROR, 
> err=java.lang.StackOverflowError]]{code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Commented] (IGNITE-18302) ignite-spring-sessions: IgniteSession serialization drags its parent class

2023-09-01 Thread Andrey Novikov (Jira)


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

Andrey Novikov commented on IGNITE-18302:
-

[~ashapkin] Can I take this issue? I see you can enough time to finish it.

> ignite-spring-sessions: IgniteSession serialization drags its parent class
> --
>
> Key: IGNITE-18302
> URL: https://issues.apache.org/jira/browse/IGNITE-18302
> Project: Ignite
>  Issue Type: Bug
>  Components: extensions
>Reporter: Alexandr Shapkin
>Assignee: Alexandr Shapkin
>Priority: Major
>
> In short, there is a bug in ignite-spring-session-ext implementation.
> We store IgniteIndexedSessionRepository${{{}IgniteSession{}}} in the cache, 
> but it’s an internal non-static class, having a reference to the parent 
> [\{{{}IgniteIndexedSessionRepository{}}}] indirectly.
> Hence, during the serialization Ignite also writes {{{}name=this$0, 
> type=Object, fieldId=0xCBDD23AA (-874699862){}}}, which is the reference to 
> {{{}IgniteIndexedSessionRepository{}}}. That leads to the following issues:
>  * we are serializing and saving internal utility data, like}} Ignite 
> ignite{}}}, {{private IndexResolver indexResolver}} etc
>  * one of the IgniteIndexedSessionRepository’s fields is IgniteCache itself - 
> {{IgniteCache sessions}} that basically keeps every 
> session so far leading to a StackOverflow error after some time. 
>  
> {code:java}
> [2022-11-25T17:27:29,268][ERROR][sys-stripe-0-#1%USERS_IGNITE%][GridCacheIoManager]
>  Failed processing message [senderId=0f0ca915-d6cd-4580-92a3-1fbc3d2a5722, 
> msg=GridNearSingleGetResponse [futId=1669397231378, res=-547701325, 
> topVer=null, err=null, flags=0]] 2java.lang.StackOverflowError: null 3 at 
> org.apache.ignite.internal.marshaller.optimized.OptimizedMarshallerUtils.descriptorFromCache(OptimizedMarshallerUtils.java:328)
>  ~[ignite-core-8.8.22.jar:8.8.22] 4 at 
> org.apache.ignite.internal.marshaller.optimized.OptimizedMarshallerUtils.classDescriptor(OptimizedMarshallerUtils.java:273)
>  ~[ignite-core-8.8.22.jar:8.8.22] 5 at 
> org.apache.ignite.internal.marshaller.optimized.OptimizedObjectInputStream.readObject0(OptimizedObjectInputStream.java:354)
>  ~[ignite-core-8.8.22.jar:8.8.22] 6 at 
> org.apache.ignite.internal.marshaller.optimized.OptimizedObjectInputStream.readObjectOverride(OptimizedObjectInputStream.java:211)
>  ~[ignite-core-8.8.22.jar:8.8.22] 7 at 
> java.io.ObjectInputStream.readObject(ObjectInputStream.java:480) ~[?:?] 8 at 
> java.io.ObjectInputStream.readObject(ObjectInputStream.java:447) ~[?:?] 9 at 
> org.apache.ignite.internal.processors.cache.GridCacheProxyImpl.readExternal(GridCacheProxyImpl.java:1662)
>  ~[ignite-core-8.8.22.jar:8.8.22] 10 at 
> org.apache.ignite.internal.marshaller.optimized.OptimizedObjectInputStream.readExternalizable(OptimizedObjectInputStream.java:569)
>  ~[ignite-core-8.8.22.jar:8.8.22] 11 at 
> org.apache.ignite.internal.marshaller.optimized.OptimizedClassDescriptor.read(OptimizedClassDescriptor.java:979)
>  ~[ignite-core-8.8.22.jar:8.8.22] 12 at 
> org.apache.ignite.internal.marshaller.optimized.OptimizedObjectInputStream.readObject0(OptimizedObjectInputStream.java:359)
>  ~[ignite-core-8.8.22.jar:8.8.22] 13 at 
> org.apache.ignite.internal.marshaller.optimized.OptimizedObjectInputStream.readObjectOverride(OptimizedObjectInputStream.java:211)
>  ~[ignite-core-8.8.22.jar:8.8.22] 14 at 
> java.io.ObjectInputStream.readObject(ObjectInputStream.java:480) ~[?:?] 15 at 
> java.io.ObjectInputStream.readObject(ObjectInputStream.java:447) ~[?:?] 16... 
> 17[2022-11-25T17:27:29,276][ERROR][sys-stripe-0-#1%USERS_IGNITE%][] Critical 
> system error detected. Will be handled accordingly to configured handler 
> [hnd=StopNodeOrHaltFailureHandler [tryStop=false, timeout=0, 
> super=AbstractFailureHandler [ignoredFailureTypes=UnmodifiableSet 
> [SYSTEM_WORKER_BLOCKED, SYSTEM_CRITICAL_OPERATION_TIMEOUT]]], 
> failureCtx=FailureContext [type=CRITICAL_ERROR, 
> err=java.lang.StackOverflowError]]{code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Commented] (IGNITE-18302) ignite-spring-sessions: IgniteSession serialization drags its parent class

2023-08-02 Thread Andrey Novikov (Jira)


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

Andrey Novikov commented on IGNITE-18302:
-

Let's move IgniteSession class to upper level as it will be used as value 
object in SQL. 
https://github.com/apache/ignite-extensions/pull/222#discussion_r1281232708 

> ignite-spring-sessions: IgniteSession serialization drags its parent class
> --
>
> Key: IGNITE-18302
> URL: https://issues.apache.org/jira/browse/IGNITE-18302
> Project: Ignite
>  Issue Type: Bug
>  Components: extensions
>Reporter: Alexandr Shapkin
>Assignee: Alexandr Shapkin
>Priority: Major
>
> In short, there is a bug in ignite-spring-session-ext implementation.
> We store IgniteIndexedSessionRepository${{{}IgniteSession{}}} in the cache, 
> but it’s an internal non-static class, having a reference to the parent 
> [\{{{}IgniteIndexedSessionRepository{}}}] indirectly.
> Hence, during the serialization Ignite also writes {{{}name=this$0, 
> type=Object, fieldId=0xCBDD23AA (-874699862){}}}, which is the reference to 
> {{{}IgniteIndexedSessionRepository{}}}. That leads to the following issues:
>  * we are serializing and saving internal utility data, like}} Ignite 
> ignite{}}}, {{private IndexResolver indexResolver}} etc
>  * one of the IgniteIndexedSessionRepository’s fields is IgniteCache itself - 
> {{IgniteCache sessions}} that basically keeps every 
> session so far leading to a StackOverflow error after some time. 
>  
> {code:java}
> [2022-11-25T17:27:29,268][ERROR][sys-stripe-0-#1%USERS_IGNITE%][GridCacheIoManager]
>  Failed processing message [senderId=0f0ca915-d6cd-4580-92a3-1fbc3d2a5722, 
> msg=GridNearSingleGetResponse [futId=1669397231378, res=-547701325, 
> topVer=null, err=null, flags=0]] 2java.lang.StackOverflowError: null 3 at 
> org.apache.ignite.internal.marshaller.optimized.OptimizedMarshallerUtils.descriptorFromCache(OptimizedMarshallerUtils.java:328)
>  ~[ignite-core-8.8.22.jar:8.8.22] 4 at 
> org.apache.ignite.internal.marshaller.optimized.OptimizedMarshallerUtils.classDescriptor(OptimizedMarshallerUtils.java:273)
>  ~[ignite-core-8.8.22.jar:8.8.22] 5 at 
> org.apache.ignite.internal.marshaller.optimized.OptimizedObjectInputStream.readObject0(OptimizedObjectInputStream.java:354)
>  ~[ignite-core-8.8.22.jar:8.8.22] 6 at 
> org.apache.ignite.internal.marshaller.optimized.OptimizedObjectInputStream.readObjectOverride(OptimizedObjectInputStream.java:211)
>  ~[ignite-core-8.8.22.jar:8.8.22] 7 at 
> java.io.ObjectInputStream.readObject(ObjectInputStream.java:480) ~[?:?] 8 at 
> java.io.ObjectInputStream.readObject(ObjectInputStream.java:447) ~[?:?] 9 at 
> org.apache.ignite.internal.processors.cache.GridCacheProxyImpl.readExternal(GridCacheProxyImpl.java:1662)
>  ~[ignite-core-8.8.22.jar:8.8.22] 10 at 
> org.apache.ignite.internal.marshaller.optimized.OptimizedObjectInputStream.readExternalizable(OptimizedObjectInputStream.java:569)
>  ~[ignite-core-8.8.22.jar:8.8.22] 11 at 
> org.apache.ignite.internal.marshaller.optimized.OptimizedClassDescriptor.read(OptimizedClassDescriptor.java:979)
>  ~[ignite-core-8.8.22.jar:8.8.22] 12 at 
> org.apache.ignite.internal.marshaller.optimized.OptimizedObjectInputStream.readObject0(OptimizedObjectInputStream.java:359)
>  ~[ignite-core-8.8.22.jar:8.8.22] 13 at 
> org.apache.ignite.internal.marshaller.optimized.OptimizedObjectInputStream.readObjectOverride(OptimizedObjectInputStream.java:211)
>  ~[ignite-core-8.8.22.jar:8.8.22] 14 at 
> java.io.ObjectInputStream.readObject(ObjectInputStream.java:480) ~[?:?] 15 at 
> java.io.ObjectInputStream.readObject(ObjectInputStream.java:447) ~[?:?] 16... 
> 17[2022-11-25T17:27:29,276][ERROR][sys-stripe-0-#1%USERS_IGNITE%][] Critical 
> system error detected. Will be handled accordingly to configured handler 
> [hnd=StopNodeOrHaltFailureHandler [tryStop=false, timeout=0, 
> super=AbstractFailureHandler [ignoredFailureTypes=UnmodifiableSet 
> [SYSTEM_WORKER_BLOCKED, SYSTEM_CRITICAL_OPERATION_TIMEOUT]]], 
> failureCtx=FailureContext [type=CRITICAL_ERROR, 
> err=java.lang.StackOverflowError]]{code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Created] (IGNITE-19921) Add thin client support for Spring Session.

2023-07-06 Thread Andrey Novikov (Jira)
Andrey Novikov created IGNITE-19921:
---

 Summary: Add thin client support for Spring Session.
 Key: IGNITE-19921
 URL: https://issues.apache.org/jira/browse/IGNITE-19921
 Project: Ignite
  Issue Type: Improvement
  Components: extensions
Reporter: Andrey Novikov


It's needed to add thin client support for Spring Session.

To work with a thin client it proposed:
 # Configure the bean of IgniteClient type
 # Mark the bean from step 1 with SpringSessionIgnite annotation.
 # Create session cache over create table query.

At the moment, the repository configuration which uses node to access the 
cluster is performed in the same way.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Assigned] (IGNITE-19921) Add thin client support for Spring Session.

2023-07-06 Thread Andrey Novikov (Jira)


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

Andrey Novikov reassigned IGNITE-19921:
---

Assignee: Andrey Novikov

> Add thin client support for Spring Session.
> ---
>
> Key: IGNITE-19921
> URL: https://issues.apache.org/jira/browse/IGNITE-19921
> Project: Ignite
>  Issue Type: Improvement
>  Components: extensions
>Reporter: Andrey Novikov
>Assignee: Andrey Novikov
>Priority: Major
>
> It's needed to add thin client support for Spring Session.
> To work with a thin client it proposed:
>  # Configure the bean of IgniteClient type
>  # Mark the bean from step 1 with SpringSessionIgnite annotation.
>  # Create session cache over create table query.
> At the moment, the repository configuration which uses node to access the 
> cluster is performed in the same way.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Created] (IGNITE-18352) ignite-spring-sessions: Unsupported default cache name for Windows platform

2022-12-07 Thread Andrey Novikov (Jira)
Andrey Novikov created IGNITE-18352:
---

 Summary: ignite-spring-sessions: Unsupported default cache name 
for Windows platform
 Key: IGNITE-18352
 URL: https://issues.apache.org/jira/browse/IGNITE-18352
 Project: Ignite
  Issue Type: Bug
  Components: extensions
Affects Versions: 1.0
Reporter: Andrey Novikov


IgniteIndexedSessionRepository#DEFAULT_SESSION_MAP_NAME contains unsupported 
character `:` in cache name for Windows platform.

*What to do:*

Rename default name of map to `IgniteSessionCache`



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Commented] (IGNITE-17594) Provide ability to register listeners for query start/finish events

2022-09-01 Thread Andrey Novikov (Jira)


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

Andrey Novikov commented on IGNITE-17594:
-

[~jooger]  Can you please review this PR as maintainer of sql?

> Provide ability to register listeners for query start/finish events
> ---
>
> Key: IGNITE-17594
> URL: https://issues.apache.org/jira/browse/IGNITE-17594
> Project: Ignite
>  Issue Type: Improvement
>  Components: sql
>Reporter: Andrey Novikov
>Assignee: Andrey Novikov
>Priority: Major
> Fix For: 2.15
>
>  Time Spent: 10m
>  Remaining Estimate: 0h
>
> Need to expose internal API to provide ability to listen query start/finish 
> events. This allow to monitor query execution in monitoring tools.
> Need to pass following properties: query, queryType,
> schemaName, startTime, finishTime, local, {{{}cancellable{}}}, 
> {{{}enforceJoinOrder{}}}, {{{}lazy{}}}, {{{}distributedJoins{}}}, 
> {{failedReason}} 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Updated] (IGNITE-17594) Provide ability to register listeners for query start/finish events

2022-09-01 Thread Andrey Novikov (Jira)


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

Andrey Novikov updated IGNITE-17594:

Description: 
Need to expose internal API to provide ability to listen query start/finish 
events. This allow to monitor query execution in monitoring tools.

Need to pass following properties: query, queryType,

schemaName, startTime, finishTime, local, {{{}cancellable{}}}, 
{{{}enforceJoinOrder{}}}, {{{}lazy{}}}, {{{}distributedJoins{}}}, 
{{failedReason}} 

  was:
Need to expose internal API to provide ability to listen query start/finish 
events.

Need to pass following properties: query, queryType,

schemaName, startTime, finishTime, local, {{{}cancellable{}}}, 
{{{}enforceJoinOrder{}}}, {{{}lazy{}}}, {{{}distributedJoins{}}}, 
{{failedReason}} 


> Provide ability to register listeners for query start/finish events
> ---
>
> Key: IGNITE-17594
> URL: https://issues.apache.org/jira/browse/IGNITE-17594
> Project: Ignite
>  Issue Type: Improvement
>  Components: sql
>Reporter: Andrey Novikov
>Assignee: Andrey Novikov
>Priority: Major
> Fix For: 2.15
>
>  Time Spent: 10m
>  Remaining Estimate: 0h
>
> Need to expose internal API to provide ability to listen query start/finish 
> events. This allow to monitor query execution in monitoring tools.
> Need to pass following properties: query, queryType,
> schemaName, startTime, finishTime, local, {{{}cancellable{}}}, 
> {{{}enforceJoinOrder{}}}, {{{}lazy{}}}, {{{}distributedJoins{}}}, 
> {{failedReason}} 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Updated] (IGNITE-17594) Provide ability to register listeners for query start/finish events

2022-08-31 Thread Andrey Novikov (Jira)


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

Andrey Novikov updated IGNITE-17594:

Description: 
Need to expose internal API to provide ability to listen query start/finish 
events.

Need to pass following properties: query, queryType,

schemaName, startTime, finishTime, local, {{{}cancellable{}}}, 
{{{}enforceJoinOrder{}}}, {{{}lazy{}}}, {{{}distributedJoins{}}}, 
{{failedReason}} 

  was:
Need to expose internal API to provide ability to listen query start/finish 
events.

Need to pass following properties: local, {{{}cancellable{}}}, 
{{{}enforceJoinOrder{}}}, {{{}lazy{}}}, {{{}distributedJoins{}}}, 
{{failedReason}} 


> Provide ability to register listeners for query start/finish events
> ---
>
> Key: IGNITE-17594
> URL: https://issues.apache.org/jira/browse/IGNITE-17594
> Project: Ignite
>  Issue Type: Improvement
>  Components: sql
>Reporter: Andrey Novikov
>Assignee: Andrey Novikov
>Priority: Major
> Fix For: 2.15
>
>
> Need to expose internal API to provide ability to listen query start/finish 
> events.
> Need to pass following properties: query, queryType,
> schemaName, startTime, finishTime, local, {{{}cancellable{}}}, 
> {{{}enforceJoinOrder{}}}, {{{}lazy{}}}, {{{}distributedJoins{}}}, 
> {{failedReason}} 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Updated] (IGNITE-17594) Provide ability to register listeners for query start/finish events

2022-08-31 Thread Andrey Novikov (Jira)


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

Andrey Novikov updated IGNITE-17594:

Description: 
Need to expose internal API to provide ability to listen query start/finish 
events.

Need to pass following properties: local, {{{}cancellable{}}}, 
{{{}enforceJoinOrder{}}}, {{{}lazy{}}}, {{{}distributedJoins{}}}, 
{{failedReason}} 

  was:
To improve monitor of running queries on node we need to pass following 
properties {{{}cancellable{}}}, 
{{{}enforceJoinOrder{}}},{{{}lazy{}}},{{{}distributedJoins{}}},{{{}failedReason{}}}
 to existing listeners IgniteH2Indexing#registerQueryStartedListener, 
IgniteH2Indexing#registerQueryFinishedListener.

*What to do:*

Add 
{{{}enforceJoinOrder{}}},{{{}lazy{}}},{{{}distributedJoins{}}},{{{}failedReason{}}}
 to GridQueryFinishedInfo

Add {{{}cancellable{}}}, 
{{{}enforceJoinOrder{}}},{{{}lazy{}}},{{{}distributedJoins{}}} to 
GridQueryStartedInfo


> Provide ability to register listeners for query start/finish events
> ---
>
> Key: IGNITE-17594
> URL: https://issues.apache.org/jira/browse/IGNITE-17594
> Project: Ignite
>  Issue Type: Improvement
>  Components: sql
>Reporter: Andrey Novikov
>Assignee: Andrey Novikov
>Priority: Major
> Fix For: 2.15
>
>
> Need to expose internal API to provide ability to listen query start/finish 
> events.
> Need to pass following properties: local, {{{}cancellable{}}}, 
> {{{}enforceJoinOrder{}}}, {{{}lazy{}}}, {{{}distributedJoins{}}}, 
> {{failedReason}} 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Updated] (IGNITE-17594) Provide ability to register listeners for query start/finish events

2022-08-31 Thread Andrey Novikov (Jira)


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

Andrey Novikov updated IGNITE-17594:

Summary: Provide ability to register listeners for query start/finish 
events  (was: Improve structures for query monitoring)

> Provide ability to register listeners for query start/finish events
> ---
>
> Key: IGNITE-17594
> URL: https://issues.apache.org/jira/browse/IGNITE-17594
> Project: Ignite
>  Issue Type: Improvement
>  Components: sql
>Reporter: Andrey Novikov
>Assignee: Andrey Novikov
>Priority: Major
> Fix For: 2.15
>
>
> To improve monitor of running queries on node we need to pass following 
> properties {{{}cancellable{}}}, 
> {{{}enforceJoinOrder{}}},{{{}lazy{}}},{{{}distributedJoins{}}},{{{}failedReason{}}}
>  to existing listeners IgniteH2Indexing#registerQueryStartedListener, 
> IgniteH2Indexing#registerQueryFinishedListener.
> *What to do:*
> Add 
> {{{}enforceJoinOrder{}}},{{{}lazy{}}},{{{}distributedJoins{}}},{{{}failedReason{}}}
>  to GridQueryFinishedInfo
> Add {{{}cancellable{}}}, 
> {{{}enforceJoinOrder{}}},{{{}lazy{}}},{{{}distributedJoins{}}} to 
> GridQueryStartedInfo



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Assigned] (IGNITE-17594) Improve structures for query monitoring

2022-08-30 Thread Andrey Novikov (Jira)


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

Andrey Novikov reassigned IGNITE-17594:
---

Assignee: Andrey Novikov

> Improve structures for query monitoring
> ---
>
> Key: IGNITE-17594
> URL: https://issues.apache.org/jira/browse/IGNITE-17594
> Project: Ignite
>  Issue Type: Improvement
>  Components: sql
>Reporter: Andrey Novikov
>Assignee: Andrey Novikov
>Priority: Major
> Fix For: 2.15
>
>
> To improve monitor of running queries on node we need to pass following 
> properties {{{}cancellable{}}}, 
> {{{}enforceJoinOrder{}}},{{{}lazy{}}},{{{}distributedJoins{}}},{{{}failedReason{}}}
>  to existing listeners IgniteH2Indexing#registerQueryStartedListener, 
> IgniteH2Indexing#registerQueryFinishedListener.
> *What to do:*
> Add 
> {{{}enforceJoinOrder{}}},{{{}lazy{}}},{{{}distributedJoins{}}},{{{}failedReason{}}}
>  to GridQueryFinishedInfo
> Add {{{}cancellable{}}}, 
> {{{}enforceJoinOrder{}}},{{{}lazy{}}},{{{}distributedJoins{}}} to 
> GridQueryStartedInfo



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Created] (IGNITE-17594) Improve structures for query monitoring

2022-08-29 Thread Andrey Novikov (Jira)
Andrey Novikov created IGNITE-17594:
---

 Summary: Improve structures for query monitoring
 Key: IGNITE-17594
 URL: https://issues.apache.org/jira/browse/IGNITE-17594
 Project: Ignite
  Issue Type: Improvement
  Components: sql
Reporter: Andrey Novikov
 Fix For: 2.15


To improve monitor of running queries on node we need to pass following 
properties {{{}cancellable{}}}, 
{{{}enforceJoinOrder{}}},{{{}lazy{}}},{{{}distributedJoins{}}},{{{}failedReason{}}}
 to existing listeners IgniteH2Indexing#registerQueryStartedListener, 
IgniteH2Indexing#registerQueryFinishedListener.

*What to do:*

Add 
{{{}enforceJoinOrder{}}},{{{}lazy{}}},{{{}distributedJoins{}}},{{{}failedReason{}}}
 to GridQueryFinishedInfo

Add {{{}cancellable{}}}, 
{{{}enforceJoinOrder{}}},{{{}lazy{}}},{{{}distributedJoins{}}} to 
GridQueryStartedInfo



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Created] (IGNITE-17187) Make SecurityPermission extendable in plugins

2022-06-17 Thread Andrey Novikov (Jira)
Andrey Novikov created IGNITE-17187:
---

 Summary: Make SecurityPermission extendable in plugins
 Key: IGNITE-17187
 URL: https://issues.apache.org/jira/browse/IGNITE-17187
 Project: Ignite
  Issue Type: Improvement
  Components: security
Reporter: Andrey Novikov


For now it not possible to define custom permission for the API that 
implemented in plugin.

enum SecurityPermission can't be extended without changes in core product.

 

 



--
This message was sent by Atlassian Jira
(v8.20.7#820007)


[jira] [Commented] (IGNITE-15868) Unexpected command: PROBE when authorization is enabled

2021-11-09 Thread Andrey Novikov (Jira)


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

Andrey Novikov commented on IGNITE-15868:
-

Merged to master.

[Dmitriy 
Borunov|https://issues.apache.org/jira/secure/ViewProfile.jspa?name=dmitriy.borunov]
 thanks for the contribution.

> Unexpected command: PROBE when authorization is enabled
> ---
>
> Key: IGNITE-15868
> URL: https://issues.apache.org/jira/browse/IGNITE-15868
> Project: Ignite
>  Issue Type: Bug
>  Components: platforms, thin client
>Affects Versions: 2.12
>Reporter: Dmitriy Borunov
>Priority: Major
> Fix For: 2.13
>
>  Time Spent: 40m
>  Remaining Estimate: 0h
>
> Rest API Probe is not working when Control Center authorisation is enabled
> {noformat}
> [2021-11-01T13:35:33,550][ERROR][rest-#125%nebula-node%][GridRestProcessor] 
> Runtime error caught during grid runnable execution: GridWorker 
> [name=rest-proc-work
> er, igniteInstanceName=nebula-node, finished=false, 
> heartbeatTs=1635773733544, hashCode=1386655371, interrupted=false, 
> runner=rest-#125%nebula-node%]
> java.lang.AssertionError: Unexpected command: PROBE
> at 
> org.apache.ignite.internal.processors.rest.GridRestProcessor.authorize(GridRestProcessor.java:968)
>  ~[ignite-core-8.8.10.jar:8.8.10]
> at 
> org.apache.ignite.internal.processors.rest.GridRestProcessor.handleRequest(GridRestProcessor.java:286)
>  ~[ignite-core-8.8.10.jar:8.8.10]
> at 
> org.apache.ignite.internal.processors.rest.GridRestProcessor.access$100(GridRestProcessor.java:108)
>  ~[ignite-core-8.8.10.jar:8.8.10]
> at 
> org.apache.ignite.internal.processors.rest.GridRestProcessor$2.body(GridRestProcessor.java:183)
>  ~[ignite-core-8.8.10.jar:8.8.10]
> at 
> org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:119) 
> [ignite-core-8.8.10.jar:8.8.10]
> at 
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
>  [?:?]
> at 
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
>  [?:?]
> at java.lang.Thread.run(Thread.java:829) [?:?]{noformat}



--
This message was sent by Atlassian Jira
(v8.20.1#820001)


[jira] [Updated] (IGNITE-15868) Unexpected command: PROBE when authorization is enabled

2021-11-09 Thread Andrey Novikov (Jira)


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

Andrey Novikov updated IGNITE-15868:

Summary: Unexpected command: PROBE when authorization is enabled  (was: 
Unexpected command: PROBE when Control Center authorisation is enabled)

> Unexpected command: PROBE when authorization is enabled
> ---
>
> Key: IGNITE-15868
> URL: https://issues.apache.org/jira/browse/IGNITE-15868
> Project: Ignite
>  Issue Type: Bug
>  Components: platforms, thin client
>Affects Versions: 2.12
>Reporter: Dmitriy Borunov
>Priority: Major
> Fix For: 2.13
>
>  Time Spent: 0.5h
>  Remaining Estimate: 0h
>
> Rest API Probe is not working when Control Center authorisation is enabled
> {noformat}
> [2021-11-01T13:35:33,550][ERROR][rest-#125%nebula-node%][GridRestProcessor] 
> Runtime error caught during grid runnable execution: GridWorker 
> [name=rest-proc-work
> er, igniteInstanceName=nebula-node, finished=false, 
> heartbeatTs=1635773733544, hashCode=1386655371, interrupted=false, 
> runner=rest-#125%nebula-node%]
> java.lang.AssertionError: Unexpected command: PROBE
> at 
> org.apache.ignite.internal.processors.rest.GridRestProcessor.authorize(GridRestProcessor.java:968)
>  ~[ignite-core-8.8.10.jar:8.8.10]
> at 
> org.apache.ignite.internal.processors.rest.GridRestProcessor.handleRequest(GridRestProcessor.java:286)
>  ~[ignite-core-8.8.10.jar:8.8.10]
> at 
> org.apache.ignite.internal.processors.rest.GridRestProcessor.access$100(GridRestProcessor.java:108)
>  ~[ignite-core-8.8.10.jar:8.8.10]
> at 
> org.apache.ignite.internal.processors.rest.GridRestProcessor$2.body(GridRestProcessor.java:183)
>  ~[ignite-core-8.8.10.jar:8.8.10]
> at 
> org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:119) 
> [ignite-core-8.8.10.jar:8.8.10]
> at 
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
>  [?:?]
> at 
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
>  [?:?]
> at java.lang.Thread.run(Thread.java:829) [?:?]{noformat}



--
This message was sent by Atlassian Jira
(v8.20.1#820001)


[jira] [Commented] (IGNITE-15868) Unexpected command: PROBE when Control Center authorisation is enabled

2021-11-09 Thread Andrey Novikov (Jira)


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

Andrey Novikov commented on IGNITE-15868:
-

LGTM.

> Unexpected command: PROBE when Control Center authorisation is enabled
> --
>
> Key: IGNITE-15868
> URL: https://issues.apache.org/jira/browse/IGNITE-15868
> Project: Ignite
>  Issue Type: Bug
>  Components: platforms, thin client
>Affects Versions: 2.12
>Reporter: Dmitriy Borunov
>Priority: Major
> Fix For: 2.13
>
>  Time Spent: 0.5h
>  Remaining Estimate: 0h
>
> Rest API Probe is not working when Control Center authorisation is enabled
> {noformat}
> [2021-11-01T13:35:33,550][ERROR][rest-#125%nebula-node%][GridRestProcessor] 
> Runtime error caught during grid runnable execution: GridWorker 
> [name=rest-proc-work
> er, igniteInstanceName=nebula-node, finished=false, 
> heartbeatTs=1635773733544, hashCode=1386655371, interrupted=false, 
> runner=rest-#125%nebula-node%]
> java.lang.AssertionError: Unexpected command: PROBE
> at 
> org.apache.ignite.internal.processors.rest.GridRestProcessor.authorize(GridRestProcessor.java:968)
>  ~[ignite-core-8.8.10.jar:8.8.10]
> at 
> org.apache.ignite.internal.processors.rest.GridRestProcessor.handleRequest(GridRestProcessor.java:286)
>  ~[ignite-core-8.8.10.jar:8.8.10]
> at 
> org.apache.ignite.internal.processors.rest.GridRestProcessor.access$100(GridRestProcessor.java:108)
>  ~[ignite-core-8.8.10.jar:8.8.10]
> at 
> org.apache.ignite.internal.processors.rest.GridRestProcessor$2.body(GridRestProcessor.java:183)
>  ~[ignite-core-8.8.10.jar:8.8.10]
> at 
> org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:119) 
> [ignite-core-8.8.10.jar:8.8.10]
> at 
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
>  [?:?]
> at 
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
>  [?:?]
> at java.lang.Thread.run(Thread.java:829) [?:?]{noformat}



--
This message was sent by Atlassian Jira
(v8.20.1#820001)


[jira] [Assigned] (IGNITE-5387) Web console: Agent should report version of internal demo nodes

2019-06-06 Thread Andrey Novikov (JIRA)


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

Andrey Novikov reassigned IGNITE-5387:
--

Assignee: (was: Andrey Novikov)

> Web console: Agent should report version of internal demo nodes
> ---
>
> Key: IGNITE-5387
> URL: https://issues.apache.org/jira/browse/IGNITE-5387
> Project: Ignite
>  Issue Type: Bug
>  Components: wizards
>Affects Versions: 2.0
>Reporter: Vasiliy Sisko
>Priority: Major
>




--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Commented] (IGNITE-5177) Failed javadoc generation for web-agent

2019-05-28 Thread Andrey Novikov (JIRA)


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

Andrey Novikov commented on IGNITE-5177:


I think this is correct fix. Agent should not be deployed into maven and it 
don't introduce any public api.

> Failed javadoc generation for web-agent
> ---
>
> Key: IGNITE-5177
> URL: https://issues.apache.org/jira/browse/IGNITE-5177
> Project: Ignite
>  Issue Type: Bug
>Reporter: Oleg Ostanin
>Assignee: Andrey Novikov
>Priority: Major
>
> [ERROR] Failed to execute goal 
> org.apache.maven.plugins:maven-antrun-plugin:1.7:run 
> (javadoc-postprocessing-new) on project apache-ignite: An Ant BuildException 
> has occured: Execution failed due to: Class doesn't have description in file: 
> /home/oostanin/gg/incubator-ignite/target/javadoc/core/org/apache/ignite/console/agent/handlers/ClusterListener.html
> [ERROR] Class doesn't have description in file: 
> /home/oostanin/gg/incubator-ignite/target/javadoc/core/org/apache/ignite/console/agent/handlers/DemoListener.html
> [ERROR] Class doesn't have description in file: 
> /home/oostanin/gg/incubator-ignite/target/javadoc/core/org/apache/ignite/console/agent/rest/RestExecutor.html



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Closed] (IGNITE-5177) Failed javadoc generation for web-agent

2019-05-28 Thread Andrey Novikov (JIRA)


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

Andrey Novikov closed IGNITE-5177.
--

> Failed javadoc generation for web-agent
> ---
>
> Key: IGNITE-5177
> URL: https://issues.apache.org/jira/browse/IGNITE-5177
> Project: Ignite
>  Issue Type: Bug
>Reporter: Oleg Ostanin
>Assignee: Andrey Novikov
>Priority: Major
>
> [ERROR] Failed to execute goal 
> org.apache.maven.plugins:maven-antrun-plugin:1.7:run 
> (javadoc-postprocessing-new) on project apache-ignite: An Ant BuildException 
> has occured: Execution failed due to: Class doesn't have description in file: 
> /home/oostanin/gg/incubator-ignite/target/javadoc/core/org/apache/ignite/console/agent/handlers/ClusterListener.html
> [ERROR] Class doesn't have description in file: 
> /home/oostanin/gg/incubator-ignite/target/javadoc/core/org/apache/ignite/console/agent/handlers/DemoListener.html
> [ERROR] Class doesn't have description in file: 
> /home/oostanin/gg/incubator-ignite/target/javadoc/core/org/apache/ignite/console/agent/rest/RestExecutor.html



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Resolved] (IGNITE-5177) Failed javadoc generation for web-agent

2019-05-28 Thread Andrey Novikov (JIRA)


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

Andrey Novikov resolved IGNITE-5177.

Resolution: Won't Fix

> Failed javadoc generation for web-agent
> ---
>
> Key: IGNITE-5177
> URL: https://issues.apache.org/jira/browse/IGNITE-5177
> Project: Ignite
>  Issue Type: Bug
>Reporter: Oleg Ostanin
>Assignee: Andrey Novikov
>Priority: Major
>
> [ERROR] Failed to execute goal 
> org.apache.maven.plugins:maven-antrun-plugin:1.7:run 
> (javadoc-postprocessing-new) on project apache-ignite: An Ant BuildException 
> has occured: Execution failed due to: Class doesn't have description in file: 
> /home/oostanin/gg/incubator-ignite/target/javadoc/core/org/apache/ignite/console/agent/handlers/ClusterListener.html
> [ERROR] Class doesn't have description in file: 
> /home/oostanin/gg/incubator-ignite/target/javadoc/core/org/apache/ignite/console/agent/handlers/DemoListener.html
> [ERROR] Class doesn't have description in file: 
> /home/oostanin/gg/incubator-ignite/target/javadoc/core/org/apache/ignite/console/agent/rest/RestExecutor.html



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Assigned] (IGNITE-10847) Web console: failed to download the mongodb on Ubuntu 18.04

2019-04-18 Thread Andrey Novikov (JIRA)


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

Andrey Novikov reassigned IGNITE-10847:
---

Assignee: Vasiliy Sisko  (was: Andrey Novikov)

Fixed mongo connection in test. Please restore broken tests

> Web console: failed to download the mongodb on Ubuntu 18.04
> ---
>
> Key: IGNITE-10847
> URL: https://issues.apache.org/jira/browse/IGNITE-10847
> Project: Ignite
>  Issue Type: Bug
>Affects Versions: 2.7
>Reporter: Pavel Konstantinov
>Assignee: Vasiliy Sisko
>Priority: Major
>
> I tried to run 'web console direct install' and faced with an error 
> downloading of MongoDB due to there is no corresponding version for that OS.
> {code}
>   name: 'StatusCodeError',
>   statusCode: 403,
>   message: '403 - " encoding=\\"UTF-8\\"?>\\nAccessDeniedAccess 
> Denied4B7715F9CDA5127BzuhNAWP7FGOgDLjkNJ3y71iU+wxcWKR5F5kI4LoO1SqCdt+aPeLZXnJko5S0ji2zx5zkJaCZX3g="',
>   error: ' encoding="UTF-8"?>\nAccessDeniedAccess 
> Denied4B7715F9CDA5127BzuhNAWP7FGOgDLjkNJ3y71iU+wxcWKR5F5kI4LoO1SqCdt+aPeLZXnJko5S0ji2zx5zkJaCZX3g=',
>   options: 
>{ uri: 
> 'https://fastdl.mongodb.org/linux/mongodb-linux-x86_64-ubuntu1804-3.4.7.tgz.md5',
> {code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Commented] (IGNITE-10847) Web console: failed to download the mongodb on Ubuntu 18.04

2019-04-15 Thread Andrey Novikov (JIRA)


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

Andrey Novikov commented on IGNITE-10847:
-

Upgraded deps in order to support mongodb 4. Almost works, except some warnings 
on logs on start: `DeprecationWarning: collection.update is deprecated. Use 
updateOne, updateMany, or bulkWrite instead.` Also test-suites was broken.

[~vsisko], can you help me to with warnings and tests?

> Web console: failed to download the mongodb on Ubuntu 18.04
> ---
>
> Key: IGNITE-10847
> URL: https://issues.apache.org/jira/browse/IGNITE-10847
> Project: Ignite
>  Issue Type: Bug
>Affects Versions: 2.7
>Reporter: Pavel Konstantinov
>Assignee: Andrey Novikov
>Priority: Major
>
> I tried to run 'web console direct install' and faced with an error 
> downloading of MongoDB due to there is no corresponding version for that OS.
> {code}
>   name: 'StatusCodeError',
>   statusCode: 403,
>   message: '403 - " encoding=\\"UTF-8\\"?>\\nAccessDeniedAccess 
> Denied4B7715F9CDA5127BzuhNAWP7FGOgDLjkNJ3y71iU+wxcWKR5F5kI4LoO1SqCdt+aPeLZXnJko5S0ji2zx5zkJaCZX3g="',
>   error: ' encoding="UTF-8"?>\nAccessDeniedAccess 
> Denied4B7715F9CDA5127BzuhNAWP7FGOgDLjkNJ3y71iU+wxcWKR5F5kI4LoO1SqCdt+aPeLZXnJko5S0ji2zx5zkJaCZX3g=',
>   options: 
>{ uri: 
> 'https://fastdl.mongodb.org/linux/mongodb-linux-x86_64-ubuntu1804-3.4.7.tgz.md5',
> {code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Assigned] (IGNITE-10847) Web console: failed to download the mongodb on Ubuntu 18.04

2019-04-15 Thread Andrey Novikov (JIRA)


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

Andrey Novikov reassigned IGNITE-10847:
---

Assignee: Andrey Novikov

> Web console: failed to download the mongodb on Ubuntu 18.04
> ---
>
> Key: IGNITE-10847
> URL: https://issues.apache.org/jira/browse/IGNITE-10847
> Project: Ignite
>  Issue Type: Bug
>Affects Versions: 2.7
>Reporter: Pavel Konstantinov
>Assignee: Andrey Novikov
>Priority: Major
>
> I tried to run 'web console direct install' and faced with an error 
> downloading of MongoDB due to there is no corresponding version for that OS.
> {code}
>   name: 'StatusCodeError',
>   statusCode: 403,
>   message: '403 - " encoding=\\"UTF-8\\"?>\\nAccessDeniedAccess 
> Denied4B7715F9CDA5127BzuhNAWP7FGOgDLjkNJ3y71iU+wxcWKR5F5kI4LoO1SqCdt+aPeLZXnJko5S0ji2zx5zkJaCZX3g="',
>   error: ' encoding="UTF-8"?>\nAccessDeniedAccess 
> Denied4B7715F9CDA5127BzuhNAWP7FGOgDLjkNJ3y71iU+wxcWKR5F5kI4LoO1SqCdt+aPeLZXnJko5S0ji2zx5zkJaCZX3g=',
>   options: 
>{ uri: 
> 'https://fastdl.mongodb.org/linux/mongodb-linux-x86_64-ubuntu1804-3.4.7.tgz.md5',
> {code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Commented] (IGNITE-11638) Web console: 'Export All' in query result table doesn't work

2019-03-27 Thread Andrey Novikov (JIRA)


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

Andrey Novikov commented on IGNITE-11638:
-

Fixed broken code. [~vsisko], please review.

> Web console: 'Export All' in query result table doesn't work
> 
>
> Key: IGNITE-11638
> URL: https://issues.apache.org/jira/browse/IGNITE-11638
> Project: Ignite
>  Issue Type: Test
>  Components: wizards
>Affects Versions: 2.8
>Reporter: Andrey Novikov
>Assignee: Andrey Novikov
>Priority: Minor
> Fix For: 2.8
>
> Attachments: image.png
>
>
> Execute any EXPLAIN
> Try to 'Export All'



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Assigned] (IGNITE-11638) Web console: 'Export All' in query result table doesn't work

2019-03-27 Thread Andrey Novikov (JIRA)


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

Andrey Novikov reassigned IGNITE-11638:
---

Assignee: Andrey Novikov

> Web console: 'Export All' in query result table doesn't work
> 
>
> Key: IGNITE-11638
> URL: https://issues.apache.org/jira/browse/IGNITE-11638
> Project: Ignite
>  Issue Type: Test
>  Components: wizards
>Affects Versions: 2.8
>Reporter: Andrey Novikov
>Assignee: Andrey Novikov
>Priority: Minor
> Attachments: image.png
>
>
> Execute any EXPLAIN
> Try to 'Export All'



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Created] (IGNITE-11638) Web console: 'Export All' in query result table doesn't work

2019-03-27 Thread Andrey Novikov (JIRA)
Andrey Novikov created IGNITE-11638:
---

 Summary: Web console: 'Export All' in query result table doesn't 
work
 Key: IGNITE-11638
 URL: https://issues.apache.org/jira/browse/IGNITE-11638
 Project: Ignite
  Issue Type: Test
  Components: wizards
Affects Versions: 2.8
Reporter: Andrey Novikov
 Attachments: image.png

Execute any EXPLAIN
Try to 'Export All'



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Updated] (IGNITE-11638) Web console: 'Export All' in query result table doesn't work

2019-03-27 Thread Andrey Novikov (JIRA)


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

Andrey Novikov updated IGNITE-11638:

Attachment: image.png

> Web console: 'Export All' in query result table doesn't work
> 
>
> Key: IGNITE-11638
> URL: https://issues.apache.org/jira/browse/IGNITE-11638
> Project: Ignite
>  Issue Type: Test
>  Components: wizards
>Affects Versions: 2.8
>Reporter: Andrey Novikov
>Priority: Minor
> Attachments: image.png
>
>
> Execute any EXPLAIN
> Try to 'Export All'



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Assigned] (IGNITE-11636) Web console: incorrect value is restored after Refresh

2019-03-27 Thread Andrey Novikov (JIRA)


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

Andrey Novikov reassigned IGNITE-11636:
---

Assignee: Andrey Novikov

> Web console: incorrect value is restored after Refresh
> --
>
> Key: IGNITE-11636
> URL: https://issues.apache.org/jira/browse/IGNITE-11636
> Project: Ignite
>  Issue Type: Bug
>Reporter: Pavel Konstantinov
>Assignee: Andrey Novikov
>Priority: Major
>  Labels: wizard
>
> Start two clusters with the same caches.
> Load some data in the first.
> Leave caches in the second cluster empty.
> Open SQL, select the first cluster, execute any select
> Press F5 to refresh the page
> Expected - the first cluster must be selected
> Actual - the second cluster is selected



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Closed] (IGNITE-11496) Long running SQL queries could be randomly canceled from WC

2019-03-12 Thread Andrey Novikov (JIRA)


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

Andrey Novikov closed IGNITE-11496.
---
Assignee: Vasiliy Sisko  (was: Andrey Novikov)

> Long running SQL queries could be randomly canceled from WC
> ---
>
> Key: IGNITE-11496
> URL: https://issues.apache.org/jira/browse/IGNITE-11496
> Project: Ignite
>  Issue Type: Bug
>  Components: wizards
>Affects Versions: 2.5
>Reporter: Evgenii Zhuravlev
>Assignee: Vasiliy Sisko
>Priority: Major
> Fix For: 2.8
>
>
> I've tried to run some long-running queries from WC(more than a couple of 
> minutes) and I've faced a behavior when the query was canceled without 
> clicking on the cancel button.
> I've opened different browser tabs at this moment, maybe it could be the 
> reason.
> {code}
> javax.cache.CacheException: Failed to run reduce query locally.
> at 
> org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.query(GridReduceQueryExecutor.java:883)
> at 
> org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing$7.iterator(IgniteH2Indexing.java:1494)
> at 
> org.apache.ignite.internal.processors.cache.QueryCursorImpl.iterator(QueryCursorImpl.java:95)
> at 
> org.apache.ignite.internal.visor.query.VisorQueryHolder.getIterator(VisorQueryHolder.java:97)
> at 
> org.apache.ignite.internal.visor.query.VisorQueryFetchFirstPageTask$VisorQueryFetchFirstPageJob.run(VisorQueryFetchFirstPageTask.java:85)
> at 
> org.apache.ignite.internal.visor.query.VisorQueryFetchFirstPageTask$VisorQueryFetchFirstPageJob.run(VisorQueryFetchFirstPageTask.java:51)
> at org.apache.ignite.internal.visor.VisorJob.execute(VisorJob.java:69)
> at 
> org.apache.ignite.internal.processors.job.GridJobWorker$2.call(GridJobWorker.java:568)
> at 
> org.apache.ignite.internal.util.IgniteUtils.wrapThreadLoader(IgniteUtils.java:6750)
> at 
> org.apache.ignite.internal.processors.job.GridJobWorker.execute0(GridJobWorker.java:562)
> at 
> org.apache.ignite.internal.processors.job.GridJobWorker.body(GridJobWorker.java:491)
> at 
> org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110)
> at 
> org.apache.ignite.internal.processors.job.GridJobProcessor.processJobExecuteRequest(GridJobProcessor.java:1123)
> at 
> org.apache.ignite.internal.processors.job.GridJobProcessor$JobExecutionListener.onMessage(GridJobProcessor.java:1921)
> at 
> org.apache.ignite.internal.managers.communication.GridIoManager.invokeListener(GridIoManager.java:1556)
> at 
> org.apache.ignite.internal.managers.communication.GridIoManager.processRegularMessage0(GridIoManager.java:1184)
> at 
> org.apache.ignite.internal.managers.communication.GridIoManager.access$4200(GridIoManager.java:125)
> at 
> org.apache.ignite.internal.managers.communication.GridIoManager$9.run(GridIoManager.java:1091)
> 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.cache.query.QueryCancelledException: The 
> query was cancelled while executing.
> at 
> org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQuery(IgniteH2Indexing.java:1240)
> at 
> org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQueryWithTimer(IgniteH2Indexing.java:1303)
> at 
> org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQueryWithTimer(IgniteH2Indexing.java:1281)
> at 
> org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.query(GridReduceQueryExecutor.java:835)
> ... 20 more
> {code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Assigned] (IGNITE-11035) Web console: Implemement improvements for query page controller.

2019-03-11 Thread Andrey Novikov (JIRA)


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

Andrey Novikov reassigned IGNITE-11035:
---

   Resolution: Fixed
 Assignee: Vasiliy Sisko  (was: Pavel Konstantinov)
Fix Version/s: 2.8

> Web console: Implemement improvements for query page controller.
> 
>
> Key: IGNITE-11035
> URL: https://issues.apache.org/jira/browse/IGNITE-11035
> Project: Ignite
>  Issue Type: Improvement
>Reporter: Vasiliy Sisko
>Assignee: Vasiliy Sisko
>Priority: Major
> Fix For: 2.8
>
>  Time Spent: 5h 35m
>  Remaining Estimate: 0h
>
> # Implement processing of query result task without one level recursion.
>  # Explicit serialization to JSON of Paragraph object. Possible 
> {{Paragraph.prototype.toJSON should be implemented.}}
>  # {{Try to use RXJS operator chain instead of direct usage of subscription 
> object.}}
>  # {{On query cancel task unlock UI in Promise.prototype.finally.}}
>  # {{Check initialization of queryId and resultNodeId on execute of refresh 
> in auto refresh mode.}}
>  # {{Some paragraph manipulation methods should be moved into Paragraph 
> class: _initQueryResult}}{{{color:#00}_, _showLoading._ 
> {color}}}{{{color:#00}Check other methods with paragraph as 
> argument.{color}}}
>  # {{{color:#00}Check clearing of data in _initQueryResult method. 
> {color}}}{{{color:#00}Try to not use direct calling of grid 
> API{color}}}{{{color:#00}. Possible we should show 
> “{color}}}{{{color:#00}Query execution{color}}}{{{color:#00}” stub 
> {color}}}{{{color:#00}instead.{color}}}
>  # {{{color:#00}Remove “beforeunload” listener on leave of Queries 
> page.{color}}}
>  # {{{color:#00}Possible we should cancel queries when client session is 
> over.{color}}}
>  # {{{color:#00}Add docs for return values of queries task in agent 
> manager. F.e:{color}}}
> {code:java}
> /*
> @returns {Promise}
> */{code}
>  # Confirm on leaving of Queries page when running queries exist:
> {code:java}
> You have running queries. Are you sure you want to cancel them?
> {code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Created] (IGNITE-11519) Web Console: Pack configuration tests in test-jar

2019-03-11 Thread Andrey Novikov (JIRA)
Andrey Novikov created IGNITE-11519:
---

 Summary: Web Console: Pack configuration tests in test-jar
 Key: IGNITE-11519
 URL: https://issues.apache.org/jira/browse/IGNITE-11519
 Project: Ignite
  Issue Type: Test
  Components: wizards
Affects Versions: 2.7
Reporter: Andrey Novikov
 Fix For: 2.8


IGNITE-8145 has introduced tests for covering the configuration. I think it 
would be better to pack these tests into a test-jar, in order to be able to 
expand in other modules.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Assigned] (IGNITE-11500) Web Console: All emails to user should have template

2019-03-07 Thread Andrey Novikov (JIRA)


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

Andrey Novikov reassigned IGNITE-11500:
---

Assignee: Andrey Novikov

> Web Console: All emails to user should have template
> 
>
> Key: IGNITE-11500
> URL: https://issues.apache.org/jira/browse/IGNITE-11500
> Project: Ignite
>  Issue Type: Improvement
>  Components: wizards
>Affects Versions: 2.7
>Reporter: Andrey Novikov
>Assignee: Andrey Novikov
>Priority: Major
> Fix For: 2.8
>
>  Time Spent: 10m
>  Remaining Estimate: 0h
>




--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Created] (IGNITE-11500) Web Console: All emails to user should have template

2019-03-06 Thread Andrey Novikov (JIRA)
Andrey Novikov created IGNITE-11500:
---

 Summary: Web Console: All emails to user should have template
 Key: IGNITE-11500
 URL: https://issues.apache.org/jira/browse/IGNITE-11500
 Project: Ignite
  Issue Type: Improvement
  Components: wizards
Affects Versions: 2.7
Reporter: Andrey Novikov
 Fix For: 2.8






--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Resolved] (IGNITE-5254) Add web-console folder structure description

2019-03-06 Thread Andrey Novikov (JIRA)


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

Andrey Novikov resolved IGNITE-5254.

Resolution: Won't Fix

Ticket is out of date.

> Add web-console folder structure description
> 
>
> Key: IGNITE-5254
> URL: https://issues.apache.org/jira/browse/IGNITE-5254
> Project: Ignite
>  Issue Type: Task
>  Components: UI, wizards
>Affects Versions: 2.0
>Reporter: Dmitriy Shabalin
>Assignee: Andrey Novikov
>Priority: Major
>
> structure example
> Web Console Frontend
> -- components 
> -- -- index.js [web-console.components]
> -- -- some-component
> -- -- -- index.js (imports)
> -- -- -- controller.js
> -- -- -- directive.js
> -- -- -- service.js
> -- -- -- style.scss
> -- -- -- template.tpl.pug (components template)
> -- filters
> -- -- index.js [web-console.filters]
> -- -- some filter.js
> -- models
> -- -- index.js [web-console.models]
> -- ignite_modules
> -- -- index.js (states, deps) [web-console.modules]
> -- -- components
> -- -- -- index.js [web-console.modules.components]
> -- -- pages
> -- -- -- index.js [web-console.modules.pages]
> -- -- -- page_1
> -- -- -- -- index.js (imports)
> -- -- -- -- components
> -- -- -- -- -- some-page-component
> -- -- -- -- -- -- index.js (imports)
> -- -- -- -- -- -- decorator.js
> -- -- -- -- style.scss
> 
> -- services
> -- -- index.js [web-console.services]
> -- -- some service.js
> -- -- some services group
> -- -- -- some service1.js
> -- -- -- some service2.js
> -- pages
> -- -- index.js (imports) [web-console.pages]
> -- -- page_1
> -- -- -- index.js (states, deps) [web-console.pages.page_1]
> -- -- -- template.tpl.pug (page template)
> -- -- -- components
> -- -- -- -- index.js (imports)
> -- -- -- -- some-page-component
> -- -- -- -- -- index.js (imports)
> -- -- -- -- -- controller.js
> -- -- -- -- -- directive.js
> -- -- -- -- -- service.js
> -- -- -- -- -- template.tpl.pug
> -- -- -- -- -- models
> -- -- -- -- -- -- index.js (imports)
> -- -- -- services
> -- -- -- -- some page service.js
> -- index.tpl.pug (index page)
> -- index.js (app enter point, bootstraps app component) [web-console]
> -- variables.scss
> -- vendors.js
> -- style.scss



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Resolved] (IGNITE-8613) Web console: investigate E2E tests on Node.js 10

2019-03-06 Thread Andrey Novikov (JIRA)


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

Andrey Novikov resolved IGNITE-8613.

Resolution: Fixed

> Web console: investigate E2E tests on Node.js 10
> 
>
> Key: IGNITE-8613
> URL: https://issues.apache.org/jira/browse/IGNITE-8613
> Project: Ignite
>  Issue Type: Improvement
>  Components: wizards
>Reporter: Ilya Borisov
>Assignee: Andrey Novikov
>Priority: Minor
> Fix For: 2.8
>
>  Time Spent: 10m
>  Remaining Estimate: 0h
>
> Web console E2E tests fail spontaneously when run under Node.js 10. We should 
> investigate what causes it: Testcafe incompatibility or something in the web 
> console code. If new, compatible version of Testcafe becomes available, let's 
> update to it as a part of this issue.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Closed] (IGNITE-8613) Web console: investigate E2E tests on Node.js 10

2019-03-06 Thread Andrey Novikov (JIRA)


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

Andrey Novikov closed IGNITE-8613.
--

> Web console: investigate E2E tests on Node.js 10
> 
>
> Key: IGNITE-8613
> URL: https://issues.apache.org/jira/browse/IGNITE-8613
> Project: Ignite
>  Issue Type: Improvement
>  Components: wizards
>Reporter: Ilya Borisov
>Assignee: Andrey Novikov
>Priority: Minor
> Fix For: 2.8
>
>  Time Spent: 10m
>  Remaining Estimate: 0h
>
> Web console E2E tests fail spontaneously when run under Node.js 10. We should 
> investigate what causes it: Testcafe incompatibility or something in the web 
> console code. If new, compatible version of Testcafe becomes available, let's 
> update to it as a part of this issue.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Closed] (IGNITE-11374) Web console: fix frontend audit issues

2019-02-24 Thread Andrey Novikov (JIRA)


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

Andrey Novikov closed IGNITE-11374.
---

> Web console: fix frontend audit issues
> --
>
> Key: IGNITE-11374
> URL: https://issues.apache.org/jira/browse/IGNITE-11374
> Project: Ignite
>  Issue Type: Improvement
>  Components: wizards
>Reporter: Ilya Borisov
>Assignee: Andrey Novikov
>Priority: Major
> Fix For: 2.8
>
>  Time Spent: 56m
>  Remaining Estimate: 0h
>
> The issue:
> npm audit outputs several vulnerabilities in frontend dependencies, mostly 
> related to unit tests. 
> What to do:
> Install packages suggested by `npm audit`. Ensure no regressions happen 
> (anything besides unit tests?). It might be necessary to add 
> package-lock.json.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Commented] (IGNITE-11374) Web console: fix frontend audit issues

2019-02-21 Thread Andrey Novikov (JIRA)


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

Andrey Novikov commented on IGNITE-11374:
-

Looks good to me.

> Web console: fix frontend audit issues
> --
>
> Key: IGNITE-11374
> URL: https://issues.apache.org/jira/browse/IGNITE-11374
> Project: Ignite
>  Issue Type: Improvement
>  Components: wizards
>Reporter: Ilya Borisov
>Assignee: Andrey Novikov
>Priority: Major
>  Time Spent: 0.6h
>  Remaining Estimate: 0h
>
> The issue:
> npm audit outputs several vulnerabilities in frontend dependencies, mostly 
> related to unit tests. 
> What to do:
> Install packages suggested by `npm audit`. Ensure no regressions happen 
> (anything besides unit tests?). It might be necessary to add 
> package-lock.json.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Commented] (IGNITE-8613) Web console: investigate E2E tests on Node.js 10

2019-02-13 Thread Andrey Novikov (JIRA)


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

Andrey Novikov commented on IGNITE-8613:


Merged to master.

> Web console: investigate E2E tests on Node.js 10
> 
>
> Key: IGNITE-8613
> URL: https://issues.apache.org/jira/browse/IGNITE-8613
> Project: Ignite
>  Issue Type: Improvement
>  Components: wizards
>Reporter: Ilya Borisov
>Assignee: Andrey Novikov
>Priority: Minor
>  Time Spent: 10m
>  Remaining Estimate: 0h
>
> Web console E2E tests fail spontaneously when run under Node.js 10. We should 
> investigate what causes it: Testcafe incompatibility or something in the web 
> console code. If new, compatible version of Testcafe becomes available, let's 
> update to it as a part of this issue.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Updated] (IGNITE-8613) Web console: investigate E2E tests on Node.js 10

2019-02-13 Thread Andrey Novikov (JIRA)


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

Andrey Novikov updated IGNITE-8613:
---
Fix Version/s: 2.8

> Web console: investigate E2E tests on Node.js 10
> 
>
> Key: IGNITE-8613
> URL: https://issues.apache.org/jira/browse/IGNITE-8613
> Project: Ignite
>  Issue Type: Improvement
>  Components: wizards
>Reporter: Ilya Borisov
>Assignee: Andrey Novikov
>Priority: Minor
> Fix For: 2.8
>
>  Time Spent: 10m
>  Remaining Estimate: 0h
>
> Web console E2E tests fail spontaneously when run under Node.js 10. We should 
> investigate what causes it: Testcafe incompatibility or something in the web 
> console code. If new, compatible version of Testcafe becomes available, let's 
> update to it as a part of this issue.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Assigned] (IGNITE-11183) Web console: Unexpected java.net.SocketTimeoutException: connect timed out

2019-02-03 Thread Andrey Novikov (JIRA)


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

Andrey Novikov reassigned IGNITE-11183:
---

Assignee: Andrey Novikov

> Web console: Unexpected java.net.SocketTimeoutException: connect timed out 
> ---
>
> Key: IGNITE-11183
> URL: https://issues.apache.org/jira/browse/IGNITE-11183
> Project: Ignite
>  Issue Type: Task
>  Components: wizards
>Affects Versions: 1.9
>Reporter: Andrey Novikov
>Assignee: Andrey Novikov
>Priority: Major
> Fix For: 2.8
>
>
> While running the agent 1.9 jar, connection timed out error occurs.
> Caused by: java.net.SocketTimeoutException: connect timed out
> at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)
> at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
> at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
> at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
> at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
> at java.net.PlainSocketImpl.connect(Unknown Source)
> at java.net.SocksSocketImpl.connect(Unknown Source)
> at java.net.Socket.connect(Unknown Source)
> at sun.security.ssl.SSLSocketImpl.connect(Unknown Source)
> at sun.net.NetworkClient.doConnect(Unknown Source)
> at sun.net.www.http.HttpClient.openServer(Unknown Source)
> at sun.net.www.http.HttpClient.openServer(Unknown Source)
> at sun.net.www.protocol.https.HttpsClient.(Unknown Source)
> at sun.net.www.protocol.https.HttpsClient.New(Unknown Source)
> at 
> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(Unknown
>  Source)
> at sun.net.www.protocol.http.HttpURLConnection.plainConnect(Unknown Source)
> at 
> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(Unknown 
> Source)
> at sun.net.www.protocol.http.HttpURLConnection.getInputStream(Unknown Source)
> at sun.net.www.protocol.http.HttpURLConnection.getHeaderFields(Unknown Source)
> at sun.net.www.protocol.https.HttpsURLConnectionImpl.getHeaderFields(Unknown 
> Source)
> at 
> io.socket.engineio.client.transports.PollingXHR$Request$1.run(PollingXHR.java:211)
> ... 1 more
> [11:33:04,423][ERROR][EventThread][AgentLauncher] Connection closed: 
> transport error.
> [11:33:05,523][INFO ][EventThread][AgentLauncher] Connecting to: 
> https://web-console
> [11:33:23,177][INFO ][EventThread][AgentLauncher] Connection established.
> [11:33:27,251][INFO ][EventThread][AgentLauncher] Authentication success.
> [11:34:29,170][ERROR][EventThread][AgentLauncher] Failed to establish 
> connection to server, due to proxy requires authentication.
> In the same time, https://web-console can be reached via curl providing the 
> proxy configuration



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Created] (IGNITE-11183) Web console: Unexpected java.net.SocketTimeoutException: connect timed out

2019-02-03 Thread Andrey Novikov (JIRA)
Andrey Novikov created IGNITE-11183:
---

 Summary: Web console: Unexpected java.net.SocketTimeoutException: 
connect timed out 
 Key: IGNITE-11183
 URL: https://issues.apache.org/jira/browse/IGNITE-11183
 Project: Ignite
  Issue Type: Task
  Components: wizards
Affects Versions: 1.9
Reporter: Andrey Novikov
 Fix For: 2.8


While running the agent 1.9 jar, connection timed out error occurs.

Caused by: java.net.SocketTimeoutException: connect timed out
at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)
at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at sun.security.ssl.SSLSocketImpl.connect(Unknown Source)
at sun.net.NetworkClient.doConnect(Unknown Source)
at sun.net.www.http.HttpClient.openServer(Unknown Source)
at sun.net.www.http.HttpClient.openServer(Unknown Source)
at sun.net.www.protocol.https.HttpsClient.(Unknown Source)
at sun.net.www.protocol.https.HttpsClient.New(Unknown Source)
at 
sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(Unknown
 Source)
at sun.net.www.protocol.http.HttpURLConnection.plainConnect(Unknown Source)
at 
sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(Unknown 
Source)
at sun.net.www.protocol.http.HttpURLConnection.getInputStream(Unknown Source)
at sun.net.www.protocol.http.HttpURLConnection.getHeaderFields(Unknown Source)
at sun.net.www.protocol.https.HttpsURLConnectionImpl.getHeaderFields(Unknown 
Source)
at 
io.socket.engineio.client.transports.PollingXHR$Request$1.run(PollingXHR.java:211)
... 1 more
[11:33:04,423][ERROR][EventThread][AgentLauncher] Connection closed: transport 
error.
[11:33:05,523][INFO ][EventThread][AgentLauncher] Connecting to: 
https://web-console
[11:33:23,177][INFO ][EventThread][AgentLauncher] Connection established.
[11:33:27,251][INFO ][EventThread][AgentLauncher] Authentication success.
[11:34:29,170][ERROR][EventThread][AgentLauncher] Failed to establish 
connection to server, due to proxy requires authentication.

In the same time, https://web-console can be reached via curl providing the 
proxy configuration



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Updated] (IGNITE-11183) Web console: Unexpected java.net.SocketTimeoutException: connect timed out

2019-02-03 Thread Andrey Novikov (JIRA)


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

Andrey Novikov updated IGNITE-11183:

Ignite Flags:   (was: Docs Required)

> Web console: Unexpected java.net.SocketTimeoutException: connect timed out 
> ---
>
> Key: IGNITE-11183
> URL: https://issues.apache.org/jira/browse/IGNITE-11183
> Project: Ignite
>  Issue Type: Task
>  Components: wizards
>Affects Versions: 1.9
>Reporter: Andrey Novikov
>Priority: Major
> Fix For: 2.8
>
>
> While running the agent 1.9 jar, connection timed out error occurs.
> Caused by: java.net.SocketTimeoutException: connect timed out
> at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)
> at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
> at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
> at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
> at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
> at java.net.PlainSocketImpl.connect(Unknown Source)
> at java.net.SocksSocketImpl.connect(Unknown Source)
> at java.net.Socket.connect(Unknown Source)
> at sun.security.ssl.SSLSocketImpl.connect(Unknown Source)
> at sun.net.NetworkClient.doConnect(Unknown Source)
> at sun.net.www.http.HttpClient.openServer(Unknown Source)
> at sun.net.www.http.HttpClient.openServer(Unknown Source)
> at sun.net.www.protocol.https.HttpsClient.(Unknown Source)
> at sun.net.www.protocol.https.HttpsClient.New(Unknown Source)
> at 
> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(Unknown
>  Source)
> at sun.net.www.protocol.http.HttpURLConnection.plainConnect(Unknown Source)
> at 
> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(Unknown 
> Source)
> at sun.net.www.protocol.http.HttpURLConnection.getInputStream(Unknown Source)
> at sun.net.www.protocol.http.HttpURLConnection.getHeaderFields(Unknown Source)
> at sun.net.www.protocol.https.HttpsURLConnectionImpl.getHeaderFields(Unknown 
> Source)
> at 
> io.socket.engineio.client.transports.PollingXHR$Request$1.run(PollingXHR.java:211)
> ... 1 more
> [11:33:04,423][ERROR][EventThread][AgentLauncher] Connection closed: 
> transport error.
> [11:33:05,523][INFO ][EventThread][AgentLauncher] Connecting to: 
> https://web-console
> [11:33:23,177][INFO ][EventThread][AgentLauncher] Connection established.
> [11:33:27,251][INFO ][EventThread][AgentLauncher] Authentication success.
> [11:34:29,170][ERROR][EventThread][AgentLauncher] Failed to establish 
> connection to server, due to proxy requires authentication.
> In the same time, https://web-console can be reached via curl providing the 
> proxy configuration



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Closed] (IGNITE-10839) Web Console: Email confirmation

2019-01-23 Thread Andrey Novikov (JIRA)


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

Andrey Novikov closed IGNITE-10839.
---

Merged to master

> Web Console: Email confirmation
> ---
>
> Key: IGNITE-10839
> URL: https://issues.apache.org/jira/browse/IGNITE-10839
> Project: Ignite
>  Issue Type: Improvement
>  Components: wizards
>Affects Versions: 2.7
>Reporter: Alexey Kuznetsov
>Assignee: Andrey Novikov
>Priority: Major
> Fix For: 2.8
>
>
> Any user can register on Web Console, but it may be not desired behavior.
> Lets add an option to enable registration via e-mail confirmation.
> This will also ensure that e-mail is correct and can be used for password 
> reset.
> By default, this option should be disabled.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Comment Edited] (IGNITE-10839) Web Console: Email confirmation

2019-01-15 Thread Andrey Novikov (JIRA)


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

Andrey Novikov edited comment on IGNITE-10839 at 1/15/19 8:44 AM:
--

* Fixed error in sign in logic when activation enabled

 * Added clean-up for e-mail confirmation flags.

[~pkonstantinov], please retest:
 * activation enabled, sign in for activated account without activation token.
 * reset password should not work for not activated account.
 * all case with activation.

 


was (Author: anovikov):
* Fixed error in sign in logic when activation enabled

 * Added clean-up for e-mail confirmation flags.

[~pkonstantinov], please retest.

> Web Console: Email confirmation
> ---
>
> Key: IGNITE-10839
> URL: https://issues.apache.org/jira/browse/IGNITE-10839
> Project: Ignite
>  Issue Type: Improvement
>  Components: wizards
>Affects Versions: 2.7
>Reporter: Alexey Kuznetsov
>Assignee: Pavel Konstantinov
>Priority: Major
> Fix For: 2.8
>
>
> Any user can register on Web Console, but it may be not desired behavior.
> Lets add an option to enable registration via e-mail confirmation.
> This will also ensure that e-mail is correct and can be used for password 
> reset.
> By default, this option should be disabled.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Comment Edited] (IGNITE-10839) Web Console: Email confirmation

2019-01-15 Thread Andrey Novikov (JIRA)


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

Andrey Novikov edited comment on IGNITE-10839 at 1/15/19 8:39 AM:
--

* Fixed error in sign in logic when activation enabled

 * Added clean-up for e-mail confirmation flags.

[~pkonstantinov], please retest.


was (Author: anovikov):
* Fixed error in sign in logic when activation enabled

* Added clean-up for e-mail confirmation flags.

> Web Console: Email confirmation
> ---
>
> Key: IGNITE-10839
> URL: https://issues.apache.org/jira/browse/IGNITE-10839
> Project: Ignite
>  Issue Type: Improvement
>  Components: wizards
>Affects Versions: 2.7
>Reporter: Alexey Kuznetsov
>Assignee: Andrey Novikov
>Priority: Major
> Fix For: 2.8
>
>
> Any user can register on Web Console, but it may be not desired behavior.
> Lets add an option to enable registration via e-mail confirmation.
> This will also ensure that e-mail is correct and can be used for password 
> reset.
> By default, this option should be disabled.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Assigned] (IGNITE-10839) Web Console: Email confirmation

2019-01-15 Thread Andrey Novikov (JIRA)


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

Andrey Novikov reassigned IGNITE-10839:
---

Assignee: Pavel Konstantinov  (was: Andrey Novikov)

> Web Console: Email confirmation
> ---
>
> Key: IGNITE-10839
> URL: https://issues.apache.org/jira/browse/IGNITE-10839
> Project: Ignite
>  Issue Type: Improvement
>  Components: wizards
>Affects Versions: 2.7
>Reporter: Alexey Kuznetsov
>Assignee: Pavel Konstantinov
>Priority: Major
> Fix For: 2.8
>
>
> Any user can register on Web Console, but it may be not desired behavior.
> Lets add an option to enable registration via e-mail confirmation.
> This will also ensure that e-mail is correct and can be used for password 
> reset.
> By default, this option should be disabled.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


  1   2   3   4   5   6   7   8   9   10   >