[
https://issues.apache.org/jira/browse/IGNITE-12584?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17024265#comment-17024265
]
Aditya commented on IGNITE-12584:
---------------------------------
The Igntie metric when the warning is thrown is as follows:
Metrics for local node (to disable set 'metricsLogFrequency' to 0)
^-- Node [id=a7924eda, uptime=04:15:01.531]
^-- H/N/C [hosts=3, nodes=3, CPUs=16]
^-- CPU [cur=78.93%, avg=68.4%, GC=0.1%]
^-- PageMemory [pages=429194]
^-- Heap [used=754MB, free=78.68%, comm=2183MB]
^-- Off-heap [used=1696MB, free=51.32%, comm=3384MB]
^-- sysMemPlc region [used=0MB, free=99.99%, comm=100MB]
^-- default region [used=1696MB, free=46.73%, comm=3184MB]
^-- metastoreMemPlc region [used=0MB, free=99.96%, comm=0MB]
^-- TxLog region [used=0MB, free=100%, comm=100MB]
^-- Ignite persistence [used=1732MB]
^-- sysMemPlc region [used=0MB]
^-- default region [used=1732MB]
^-- metastoreMemPlc region [used=0MB]
^-- TxLog region [used=0MB]
^-- Outbound messages queue [size=0]
^-- Public thread pool [active=0, idle=0, qSize=0]
^-- System thread pool [active=0, idle=6, qSize=0]
> Query execution is too long issue!
> ----------------------------------
>
> Key: IGNITE-12584
> URL: https://issues.apache.org/jira/browse/IGNITE-12584
> Project: Ignite
> Issue Type: Bug
> Reporter: Aditya
> Priority: Major
> Attachments: uploadthis.txt
>
>
> When querying via some java application and if the topology is in such a way
> that two clients connect to one server node, then some times we are getting
> an exception saying query execution is too long.
>
> This is the SQL schema for table
>
> stmt.executeUpdate("CREATE TABLE DOCIDS (" +
> " id LONG PRIMARY KEY, url VARCHAR, score LONG, appname VARCHAR) " +
> " WITH \"template=replicated\"");
>
> stmt.executeUpdate("CREATE INDEX idx_doc_name_url ON DOCIDS (appname, url)");
>
> Query ->
> SqlFieldsQuery query = new SqlFieldsQuery("SELECT count(id) FROM DOCIDS");
> FieldsQueryCursor<List<?>> cursor = cache.query(query);
> For warning prints, please check the attachment.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
