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

Ignite TC Bot commented on IGNITE-11177:
----------------------------------------

{panel:title=--> Run :: All: Possible 
Blockers|borderStyle=dashed|borderColor=#ccc|titleBGColor=#F7D6C1}
{color:#d04437}Cache (Restarts) 1{color} [[tests 
15|https://ci.ignite.apache.org/viewLog.html?buildId=3038288]]
* IgniteCacheRestartTestSuite: 
GridCacheReplicatedNodeRestartSelfTest.testRestartWithPutFourNodesNoBackups - 
0,0% fails in last 384 master runs.
* IgniteCacheRestartTestSuite: 
GridCacheReplicatedNodeRestartSelfTest.testRestartWithTxFourNodesOneBackups - 
0,0% fails in last 384 master runs.
* IgniteCacheRestartTestSuite: 
GridCacheReplicatedNodeRestartSelfTest.testRestartWithPutTwoNodesNoBackups - 
0,0% fails in last 384 master runs.
* IgniteCacheRestartTestSuite: 
GridCacheReplicatedNodeRestartSelfTest.testRestartWithTxTwoNodesOneBackup - 
0,0% fails in last 384 master runs.
* IgniteCacheRestartTestSuite: 
GridCacheReplicatedNodeRestartSelfTest.testRestartWithPutTwoNodesOneBackup - 
0,0% fails in last 384 master runs.
* IgniteCacheRestartTestSuite: 
GridCacheReplicatedNodeRestartSelfTest.testRestartWithTxFourNodesOneBackupsOffheapEvict
 - 0,0% fails in last 384 master runs.
* IgniteCacheRestartTestSuite: 
GridCacheReplicatedNodeRestartSelfTest.testRestart - 0,0% fails in last 384 
master runs.

{color:#d04437}Queries 1{color} [[tests 
2|https://ci.ignite.apache.org/viewLog.html?buildId=3038319]]
* IgniteBinaryCacheQueryTestSuite: 
IgniteDynamicSqlRestoreTest.testIndexCreationWhenNodeStopped - 0,0% fails in 
last 399 master runs.

{color:#d04437}Spring{color} [[tests 0 Exit Code 
|https://ci.ignite.apache.org/viewLog.html?buildId=3038254]]

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

> IGNITE.NODE_METRICS view fails with "Cannot parse "TIME" constant" > 24h
> ------------------------------------------------------------------------
>
>                 Key: IGNITE-11177
>                 URL: https://issues.apache.org/jira/browse/IGNITE-11177
>             Project: Ignite
>          Issue Type: Bug
>          Components: sql
>    Affects Versions: 2.7
>            Reporter: Ilya Kasnacheev
>            Assignee: Pavel Kuznetsov
>            Priority: Major
>              Labels: metrics
>             Fix For: 2.8
>
>
> This is because we are using TIME type for several additive measurements:
> {quote}SqlSystemViewNodeMetrics.class:
>                         
> valueTimeFromMillis(metrics.getTotalJobsExecutionTime()),
>                         valueTimeFromMillis(metrics.getTotalBusyTime()),
>                         
> valueTimeFromMillis(metrics.getTotalIdleTime()),{quote}
> which will be hundreds of hours on long-running cluster, but {{TIME}} type is 
> limited to 24 hours and will fail to be converted otherwise, as in:
> {quote}0: jdbc:ignite:thin://localhost> SELECT CAST('40:52:26.548' AS TIME);
> Error: Failed to parse query. Невозможно преобразование строки "40:52:26.548" 
> в тип "TIME"
> Cannot parse "TIME" constant "40:52:26.548"; SQL statement:
> SELECT CAST('40:52:26.548' AS TIME) [22007-197] (state=42000,code=1001){quote}



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

Reply via email to