Re: Query timeout

Hello! Turns out, "?queryTimeout=" will only be available in 2.9: https://issues.apache.org/jira/browse/IGNITE-12462 However, you can already use (Statement)ps.setQueryTimeout(1), it works in your case as well (checked on 2.8). Regards, -- Ilya Kasnacheev вт, 24 мар. 2020 г. в 11:05, breathem

Re: CPP: Query timeout

Hello! Unfortunately, this is not trivial, you should search your nodes' logs for locNodeId=022a7f53 or localNodeId=022a7f53 Regards, -- Ilya Kasnacheev ср, 8 апр. 2020 г. в 11:51, nidhinms : > Hi > > Do ignite provide a method to find ip address from this ID. > 022a7f53-8628-409a-851a-e8ef62

Re: CPP: Query timeout

Hi Do ignite provide a method to find ip address from this ID. 022a7f53-8628-409a-851a-e8ef62d050f7. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: CPP: Query timeout

Hello! I can see the following messages repeating: [10:17:09,530][WARNING][grid-timeout-worker-#23][diagnostic] Found long running cache future [startTime=10:15:10.302, curTime=10:17:09.523, fut=GridNearAtomicSingleUpdateFuture [reqState=Primary [id=936138d2-e6e5-44f8-b731-7576c83e9334, opRes=fals

Re: CPP: Query timeout

Issue happened because one of ignite server nodes was down. Queries were successful after servers restarted. Attaching logs from client. ignite-1835519d.log -- Sent from: http://apache-ignite-users.70518.x6.nabbl

Re: CPP: Query timeout

Hello! Can you please provide logs and thread dumps (collectible with jstack ) of all your Apache Ignite nodes? Hard to pinpoint it otherwise. Thanks, -- Ilya Kasnacheev пн, 6 апр. 2020 г. в 13:22, nidhinms : > I tried to execute an INSERT query to my ignite cluster. It was working > fine. >

CPP: Query timeout

I tried to execute an INSERT query to my ignite cluster. It was working fine. After they update the ignite server instance with some new jars the query is not returning. Can some one guide me to rectify this issue. 1. Does peerLoadingEnabled=true has omething to do with this issue. Or does peerCla

Re: Query timeout

Hi, Taras. We try to connect to server via NetBeans 8.2 for development purposes. In Services tab we add Ignite 2.8.0 JDBC driver (ignite-core-2.8.0.jar) and choose org.apache.ignite.IgniteJdbcThinDriver. To reproduce long running query we create 2 tables: create table if not exists TEST (kField l

Re: Query timeout

Hi, Hm.. It works for me. Looks at the Ignite test: JdbcThinStatementTimeoutSelfTest#testQueryTimeoutRetrival [1]. Please share your simple reproducer or test. [1]. https://github.com/apache/ignite/blob/9f19e0160b1ca43a27908849ad46c65ebd8689f1/modules/clients/src/test/java/org/apache/ignite/

Re: Query timeout

I try jdbc:ignite:thin://192.168.1.138:10800;queryTimeout=1 and jdbc:ignite:thin://192.168.1.138:10800?queryTimeout=1 both. Query is still executed more then 1 sec without exception. Is this parameter supported in 2.8.0? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Query timeout

Hi, queryTimeout=N in seconds according with JDBC specification: java.sql.Statement#setQueryTimeout On 23.03.2020 12:47, breathem wrote: Hi all, Is there any way to set query timeout parameter in JDBC url? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/ -- Taras Ledkov

Query timeout

Hi all, Is there any way to set query timeout parameter in JDBC url? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: How to set query timeout or cancel query when submit SQL query from SQL tool like DBweaver and sqlline?

Hi Ray, As far as I know query timeout can be configured only for SqlQuery/SqlFieldsQuery API. Mentioned global timeout configuration through "jdbc:h2..." URL was not implemented.

How to set query timeout or cancel query when submit SQL query from SQL tool like DBweaver and sqlline?

When I go through this document https://apacheignite-sql.readme.io/docs/query-cancellation, it seems query can set timeout if the query submitted through java API(SqlQuery, SqlFieldsQuery). So my question is how to set query timeout or cancel query when submit SQL query from SQL tool like DBweaver

Re: setting query timeout and getting partial result instead of exception.

this message in context: http://apache-ignite-users. > 70518.x6.nabble.com/setting-query-timeout-and-getting- > partial-result-instead-of-exception-tp12266.html > Sent from the Apache Ignite Users mailing list archive at Nabble.com. > -- Best regards, Andrey V. Mashenkov

setting query timeout and getting partial result instead of exception.

timeout, the data is returned from rest of the nodes. This way, we will get partial data, instead of exception. -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/setting-query-timeout-and-getting-partial-result-instead-of-exception-tp12266.html Sent from the Apache