Does the JDBC thin driver support partition aware execution of INSERT statements?

Does the JDBC thin driver support partition aware execution of INSERT statements?

High speed writing(INSERT) can significantly reduce SQL query performance

Hi team, When performing high-speed writes(INSERT statement), it can lead to a significant decrease in SQL query performance, the execution time will be extended by tens of times. We are using the H2 SQL engine, Ignite 2.16.0. We know that Ignite uses different thread pools for writing and q

Realtime CDC demo

Hi team, We have seen that Ignite's 2.16 version has released the feature of real-time CDC, but we have not seen the relevant documentation and demo code. Does the community have any relevant DEMO code to provide?

Ignite process memory usage continues to grow in docker

Hi team, Start a simple Ignite process using Docker, which is the default configuration and does nothing. After a period of time, you will find that the memory occupied by this Ignite process increases until the OOM Killer is triggered. If Docker is not used and the Ignite process is started

Does SQL Query support TouchedExpiryPolicy?

From javadoc, An ExpiryPolicy that defines the expiry Duration of a Cache Entry based on when it was last touched. A touch includes creation, update or access. So, does SQL queries support this expiration policy?

How to switch a node from normal mode to maintenance mode?

Hi, we found control.sh have '--persistence' and '--defragmentation schedule' command, however, these commands require Ignite to run in maintenance mode. so, how to switch a node from normal mode to maintenance mode?

How to delete data of a specified partition with high performance

hi, How to delete data of a specified partition(or specified affinityKey) with high performance(multi thread)?

CachePartialUpdateCheckedException: Failed to update keys (Tail not found: 0)

Hi team, We encountered an error, as shown in the title. Then we found a ticket in jira, and the issue description was exactly the same as what we encountered: https://issues.apache.org/jira/browse/IGNITE-17734 What are the possible causes of this issue?

Re: partitionLossPolicy confused

t;resolved". I will file a jira ticket in order to address this improvement. Thanks, Slava. пн, 26 сент. 2022 г. в 16:51, 38797715 <38797...@qq.com>: hello, Start two nodes with native persistent enabled, and then activate it. create a table with no backups, sql like

partitionLossPolicy confused

hello, Start two nodes with native persistent enabled, and then activate it. create a table with no backups, sql like follows: CREATE TABLE City (   ID INT,   Name VARCHAR,   CountryCode CHAR(3),   District VARCHAR,   Population INT,   PRIMARY KEY (ID, CountryCode) ) WITH "template=partitioned,

SQL execute method on replicated tables

If all the tables queried by SQL are replicated tables, is the SQL executed on all nodes or only on one node? if SQL executed on one node, what is the algorithm for selecting the execution node?

Re: How to calculate the amount of memory used by a cache or dataregion

need to look at the code or somebody else can give us a hint. On Mon, Sep 19, 2022 at 2:55 PM 38797715 <38797...@qq.com> wrote: if native persistence enabled, the result is the same. It seems that there is a bug in the calculation of the "PagesFillFactor" metrics?

Re: How to calculate the amount of memory used by a cache or dataregion

if native persistence enabled, the result is the same. It seems that there is a bug in the calculation of the "PagesFillFactor" metrics? 在 2022/9/19 17:30, Alexander Polovtcev 写道: Do you have native persistence enabled? On Mon, Sep 19, 2022 at 11:57 AM 38797715 <38797...@

Re: How to calculate the amount of memory used by a cache or dataregion

no, pure memory mode. 在 2022/9/19 17:30, Alexander Polovtcev 写道: Do you have native persistence enabled? On Mon, Sep 19, 2022 at 11:57 AM 38797715 <38797...@qq.com> wrote: 2.10 and 2.13, the same result. 在 2022/9/19 16:54, Alexander Polovtcev 写道: Which version of Ignite

Re: How to calculate the amount of memory used by a cache or dataregion

2.10 and 2.13, the same result. 在 2022/9/19 16:54, Alexander Polovtcev 写道: Which version of Ignite do you use? On Mon, Sep 19, 2022 at 11:38 AM 38797715 <38797...@qq.com> wrote: for example: start a node by ignite.sh. then: CREATE TABLE City (   ID INT,

Re: How to calculate the amount of memory used by a cache or dataregion

aregion.default.CheckpointBufferSize    0 TotalUsedSize - (TotalAllocatedSize - PagesFillFactor * TotalAllocatedSize) =8549000 - (8549000 - 1.0 * 8549000) = 8549000 Instead, the value becomes larger? 在 2022/9/19 15:13, Alexander Polovtcev 写道: Sorry, I messed up the metric names a little bit,

Re: How to calculate the amount of memory used by a cache or dataregion

Pages" and "TotalUsedSize" metrics that can be found in the Data Region metrics. However, please keep in mind that this does not take page fragmentation into account. On Sat, Sep 17, 2022 at 2:35 PM 38797715 <38797...@qq.com> wrote: Hi team, We found that if the delete op

Re: How to calculate the amount of memory used by a cache or dataregion

mind that this does not take page fragmentation into account. On Sat, Sep 17, 2022 at 2:35 PM 38797715 <38797...@qq.com> wrote: Hi team, We found that if the delete operation is executed, the memory space corresponding to the data will not be released, and this space

How to calculate the amount of memory used by a cache or dataregion

Hi team, We found that if the delete operation is executed, the memory space corresponding to the data will not be released, and this space will be reused later. Therefore, metrics such as OffheapUsedSize will become inaccurate. So, how to calculate the exact amount of memory occupied by dat

Page replacement priority

hello, When there is insufficient memory, if a page replacement occurs, will the data be swapped out of memory first, or will the index also be swapped out of memory? Or are there any optimized algorithms?

Re: Cursor in ThinClient failure

Does the thin client have a mechanism like Session?

Cursor in ThinClient failure

Hi team, FieldsQueryCursor> cursor = client.query(new SqlFieldsQuery("SELECT name from Person WHERE id=?").setArgs(key).setSchema("PUBLIC")); If the thin client fails during the execution of the above code, will it leave an unclosed cursor on the server side?

Re: HASH_JOIN: Index "HASH_JOIN_IDX" not found

oks like this feature implementation is absent in Ignite (or was removed for some reasons). On 2022/01/06 09:34:41 38797715 wrote: > Execute the following script and the error will occur: > > CREATE TABLE Country ( >   Code CHAR(3) PRIMARY KEY, >   Name VARCHAR, >   Continent VARCHAR, >

HASH_JOIN: Index "HASH_JOIN_IDX" not found

Execute the following script and the error will occur: CREATE TABLE Country (   Code CHAR(3) PRIMARY KEY,   Name VARCHAR,   Continent VARCHAR,   Region VARCHAR,   SurfaceArea DECIMAL(10,2),   IndepYear SMALLINT,   Population INT,   LifeExpectancy DECIMAL(3,1),   GNP DECIMAL(10,2),   GNPOld DECIMA

IgniteBiPredicate in ThinClient ScanQuery:java.lang.ClassNotFoundException

An exception will be throw when the following code is executed: The ScanQuery in the thin client does not support IgniteBiPredicate? publicclassThinClient{ publicstaticvoidmain(String[] args) throwsClientException, Exception{ ClientConfigurationcfg= newClientConfiguration().setAddresses("local

Re: The code inside the CacheEntryProcessor executes multiple times. Why?

er to register this class by self. On Tue, Oct 19, 2021 at 3:52 AM 38797715 <38797...@qq.com> wrote: Any feedback? 在 2021/10/14 15:03, 38797715 写道: Hi, The internal code of CacheEntryProcessor in the attachment has been executed multiple times. Why? Is there

Re: The code inside the CacheEntryProcessor executes multiple times. Why?

Any feedback? 在 2021/10/14 15:03, 38797715 写道: Hi, The internal code of CacheEntryProcessor in the attachment has been executed multiple times. Why? Is there any simple way to solve this problem? package com.test; import java.util.Collections; import java.util.HashMap; import java.util.Map

The code inside the CacheEntryProcessor executes multiple times. Why?

Hi, The internal code of CacheEntryProcessor in the attachment has been executed multiple times. Why? Is there any simple way to solve this problem? package com.test; import java.util.Collections; import java.util.HashMap; import java.util.Map; import org.apache.ignite.Ignite; import org.apac

Re: Does ignite cluster need at least 3 nodes?

No, it's completely the default implementation. I understand that if the cluster has only two nodes, node1 (Coordinator) and node2, and if two nodes are disconnected due to long GC, node2 should be shut down due to split brain, but it doesn't seem to be so now. AFAIK, if the cluster is 3 node

Re: Does ignite cluster need at least 3 nodes?

My question is, does the current behavior seem to be inconsistent with the default SegmentationPolicy = STOP?

Re: Does ignite cluster need at least 3 nodes?

Any feedback?

Does ignite cluster need at least 3 nodes?

Hi team, There is a cluster with 2 server nodes and 1 client node. It can be seen from the attached log that the two server nodes are disconnected from about 20:18:15. However, it is strange that the node with IP 10.97.32.53 did not shut down due to split brain. Instead, it is split into two

Received incoming connection from remote node while connecting to this node, rejecting(2.7.5)

Hi team, Our cluster has node failure after frequent occurrence of the following messages: 2021-07-07_12:54:04.773[INFO] [grid-nio-worker-tcp-comm-25-#353%PROD_JET_default_SZ%] [o.a.i.s.c.tcp.TcpCommunicationSpi] Accepted incoming communication connection [locAddr=/29.21.68.48:47100, rmtAdd

Thin client access Ignite cluster with ZooKeeper Discovery

Hello, For the Ignite cluster with ZooKeeper Discovery, if want to access the cluster through thin client, is there an example of ClientAddressFinder?

How to deal with data expiration time flexibly

Hello team, At present, only a few simple expiration policies can be configured, such as CreatedExpiryPolicy. If want to use a field value to determine the expiration time of the data, what should we do? Or what interface is there for extension?

Re: Data synchronization after node restart

Hello, We know that the control script has an idle_verify command can be used to verify the potential inconsistency between the primary and backup. Well, since there are WAL and WAL archives, they can be used for historical data balancing. So why can't WAL ensure the consistency between the p

when persistence enabled,MaxDirectMemorySize = walSegmentSize * 4

hello team, doc says: If you use Ignite native persistence, we recommend that you set the MaxDirectMemorySize JVM parameter to walSegmentSize * 4 why? In addition, for the following configuration and code: "vmArgs": "-XX:+PrintGCDetails -XX:MaxDirectMemorySize=5m" ByteBuffer bb = ByteBuffe

Data synchronization after node restart

Hi team, If persistence is enabled and the number of backups is 1. At this time, if a node fails, and the data writing is still normal. If the previously failed node restarts, it joins the cluster again. So is this restored node synchronizing all data from other nodes or only the differential

Re: [2.10]If affinityKey is used as a where condition, cannot retrieve the result set

try to change fields order in the PK to the same which is used in the cache fields list: CREATE TABLE IF NOT EXISTS VIEWSORTCONTROL (  TABLEID VARCHAR NOT NULL,  ID VARCHAR,  ...  PRIMARY KEY (TABLEID, ID) ) Igor On Mon, Apr 12, 2021 at 1:03 PM 38797715 <38797...@qq.com <mailto:38797...@qq

Re: NPE on control.sh --cache indexes_force_rebuild

. 2021 г. в 14:57, 38797715 <38797...@qq.com <mailto:38797...@qq.com>>:  Hello, Does indexes_force_rebuild command have a demo to run? The following error will be thrown during current execution: ./control.sh --cache indexes_force_rebuild --cache_names City T

NPE on control.sh --cache indexes_force_rebuild

 Hello, Does indexes_force_rebuild command have a demo to run? The following error will be thrown during current execution: ./control.sh --cache indexes_force_rebuild --cache_names City Time: 2021-04-14T14:46:10.485 java.lang.NullPointerException Command [] finished with code: 4 Error stack tr

[2.10]If affinityKey is used as a where condition, cannot retrieve the result set

Hi team, test.zip Is a single node snapshot compressed file. Unzip the file to the work directory of ignite, and then use the example.xml start a node and activate the cluster. You will see a table called viewsortcontrol. Execute the following SQL, the result is normal: SELECT * FROM viewso

[2.10]Binary type has different affinity key fields

Hello Ilya, Our approach is not to empty binary_meta directory, because if you empty this directory, the data of all tables may be lost. We use the cat *.bin file to find the specific bin file of a table, and then delete it on all nodes. After this operation, the following error appears. We

[2.10]Binary type has different affinity key fields

Hello, Ignite turns on native persistence,3 nodes. We changed the name of the table primary key (unexpected operation), as follows: CREATE TABLE WORKSPACE (     NAME VARCHAR,     WORKSPACEID VARCHAR,     PRIMARY KEY (WORKSPACEID) ) WITH "template=cache-replicated, cache_name=Workspace, key_typ

Re: [2.10 branch]cpp thin client transaction :Transaction with id 1 not found.

Hello Igor, Thank you very much for your hard work! 在 2021/3/5 下午6:50, Igor Sapego 写道: Guys, I just want to notify you that the issue is fixed and is included in Ignite-2.10 Best Regards, Igor On Thu, Feb 18, 2021 at 3:41 AM 18624049226 <18624049...@163.com > wr

Re: [2.9.1]Failed to find DHT update future for deferred update response

ev 写道: Hello! Do you happen to have a reproducer for this issue? I've not seen anything similar. Regards, -- Ilya Kasnacheev ср, 3 мар. 2021 г. в 12:31, 38797715 <38797...@qq.com <mailto:38797...@qq.com>>: Hi team, When using DataStreamer to write a large amount of

[2.9.1]Failed to find DHT update future for deferred update response

Hi team, When using DataStreamer to write a large amount of data at high speed, if one server node fails, then other nodes will appear a lot of following information, and finally they will also fail: [2021-03-03 15:49:44,516][WARN ][sys-stripe-6-#7][atomic] Failed to find DHT update future f

Cluster-wide snapshot operation finished successfully

Hello team, You can see the following message from the log: [17:30:19,227][INFO][disco-notifier-worker-#44][IgniteSnapshotManager] Cluster-wide snapshot operation finished successfully [req=SnapshotOperationRequest [rqId=2d9baefa-eee4-4c13-ae78-750f0b1e1cd4, srcNodeId=dfa3ed59-4042-4431-8e0d

Re: [2.9.1]in SYS.METRICS View some data is always 0

 |    | | cache.SQL_PUBLIC_PERSON.QueryMaximumTime | 63 |    | | cache.SQL_PUBLIC_PERSON.QueryMinimalTime | 21 |    | | cache.SQL_PUBLIC_PERSON.QuerySumTime | 84     |    

Re: [2.9.1]in SYS.METRICS View some data is always 0

e | 20 |    | | cache.foo.QuerySumTime | 424    |    | Regards, -- Ilya Kasnacheev чт, 28 янв. 2021 г. в 14:42, 38797715 <38797...@qq.com <mailto:38797...@qq.com>>: Hello Ilya, if use sqlline execute sql,the feedback r

Re: [2.9.1]in SYS.METRICS View some data is always 0

' ORDER BY name; Regards, -- Ilya Kasnacheev ср, 27 янв. 2021 г. в 15:29, 38797715 <38797...@qq.com <mailto:38797...@qq.com>>: Hello Ilya, The test method is as follows: Start 2 nodes on the localhost. Use the CREATE TABLE statement to create a table;

Re: [2.9.1]in SYS.METRICS View some data is always 0

Hello, I know SQL_ QUERIES and SQL_ QUERY_ HISTORY. I opened *org.apache.ignite.spi.metric.sql.SqlViewMetricExporterSpi* in the configuration file A new METRICS view will be added. 在 2021/1/28 上午7:02, akorensh 写道: Hi, there is not a view called metrics, only node_metrics, see below Here are

Re: [2.9.1]in SYS.METRICS View some data is always 0

在 2021/1/27 下午6:24, Ilya Kasnacheev 写道: Hello! These values are per-node, as far as I know. Is it possible that you have connected to a node which does not handle any queries (as reducer, anyway)? Regards, -- Ilya Kasnacheev вт, 26 янв. 2021 г. в 13:48, 38797715 <38797...@qq.com

[2.9.1]in SYS.METRICS View some data is always 0

Hi, We found that SYS.METRICS View some data is always 0, such as QueryCompleted,QueryExecuted,QuerySumTime,QueryCompleted,QuerySumTime and QueryMaximumTime. This is a bug? Or what configuration is needed? Or the related functions have not been implemented yet?

Re: Regarding Partition Map exchange Triggers

Hi, According to the exception log of the following topic, a client node joins the cluster and blocks a SQL query on the transactional cache. Is this true? http://apache-ignite-users.70518.x6.nabble.com/Failed-to-wait-for-affinity-ready-future-for-topology-version-AffinityTopologyVersion-td34

Re: Failed to wait for affinity ready future for topology version: AffinityTopologyVersion

eleases/latest/javadoc/org/apache/ignite/configuration/TransactionConfiguration.html#setDefaultTxTimeout-long- If not, your logs are required. BR, Andrei 12/9/2020 4:15 PM, 38797715 пишет: Hi community, When a new client node is joining the cluster, other client nodes cannot perform SQL query. Is

Re: Failed to wait for affinity ready future for topology version: AffinityTopologyVersion

/configuration/TransactionConfiguration.html#setTxTimeoutOnPartitionMapExchange-long- https://ignite.apache.org/releases/latest/javadoc/org/apache/ignite/configuration/TransactionConfiguration.html#setDefaultTxTimeout-long- If not, your logs are required. BR, Andrei 12/9/2020 4:15 PM, 38797715 пишет

Failed to wait for affinity ready future for topology version: AffinityTopologyVersion

Hi community, When a new client node is joining the cluster, other client nodes cannot perform SQL query. Is this true? log are as follows: [19:15:34,959][SEVERE][query-#44319][GridMapQueryExecutor] Failed to execute local query. class org.apache.ignite.IgniteException: Failed to wait for aff

Re: [2.9.0]NPE on invoke IgniteCache.destroy()

? - Ilya Kazakov пн, 7 дек. 2020 г. в 21:31, 38797715 <38797...@qq.com <mailto:38797...@qq.com>>: Hi community, Call IgniteCache.destroy Method, NPE appears,logs are as follows: 2020-12-0717:32:18.870[] [exchange-worker-#54%tradecore%] INFOo.a.i.i.e.time- Star

[2.9.0]NPE on invoke IgniteCache.destroy()

Hi community, Call IgniteCache.destroy Method, NPE appears,logs are as follows: 2020-12-0717:32:18.870[] [exchange-worker-#54%tradecore%] INFOo.a.i.i.e.time- Started exchange init [topVer=AffinityTopologyVersion [topVer=1, minorTopVer=279], crd=true, evt=DISCOVERY_CUSTOM_EVT, evtNode=320935f6

Re: [2.8.1]Checking optimistic transaction state on remote nodes

? 在 2020/11/20 下午7:50, Ilya Kasnacheev 写道: Hello! It will happen when the node has left but the transaction has to be committed. Most operations on transactional cache will involve implicit transactions so there you go. Regards, -- Ilya Kasnacheev чт, 19 нояб. 2020 г. в 16:46, 38797715

[2.8.1]Checking optimistic transaction state on remote nodes

Hi community, Although there is a transactional cache, no transaction operation is performed, but there is a lot of output below in the log. Why? [2020-11-16 14:01:44,947][INFO ][sys-stripe-8-#9][IgniteTxManager] Checking optimistic transaction state on remote nodes [tx=GridDhtTxLocal [nearN

Re: High availability of local listeners for ContinuousQuery or Events

at 4:46 PM 38797715 <38797...@qq.com <mailto:38797...@qq.com>> wrote: Hi community, For local listeners registered for ContinuousQuery and Events, is there a corresponding high availability mechanism design? That is, if the node registering the local listener fail

High availability of local listeners for ContinuousQuery or Events

Hi community, For local listeners registered for ContinuousQuery and Events, is there a corresponding high availability mechanism design? That is, if the node registering the local listener fails, what state will the cluster be? If do not register a local listener, but write the business code

Re: ZookeeperClusterNode memory leak(potential)

Hi, 2.8.1 在 2020/10/14 下午4:06, Stephen Darlington 写道: What version of Ignite are you using? On 14 Oct 2020, at 08:36, 38797715 <38797...@qq.com <mailto:38797...@qq.com>> wrote: Hi team, About 50 nodes (including client nodes) were discovered by zookeeper. After running for

ZookeeperClusterNode memory leak(potential)

Hi team, About 50 nodes (including client nodes) were discovered by zookeeper. After running for about 2 days, you will find that the number of ZookeeperClusterNode instances increases significantly (about 1.6 million). After running for a longer time, it may cause memory overflow.

Re: How to confirm that disk compression is in effect?

Ilya Kasnacheev вт, 8 сент. 2020 г. в 05:18, 38797715 <38797...@qq.com <mailto:38797...@qq.com>>: Hi Ilya, This module has already been imported. We re tested three scenarios: 1.pageSize=4096 2.pageSize=8192 3.pageSize=8192,disk compression and wal compressi

Re: How to confirm that disk compression is in effect?

you tried WAL compression instead? Please check https://apacheignite.readme.io/docs/write-ahead-log#section-wal-records-compression <https://apacheignite.readme.io/docs/write-ahead-log#section-wal-records-compression> Regards, -- Ilya Kasnacheev пт, 28 авг. 2020 г. в 06:52, 38797715

Re: How to confirm that disk compression is in effect?

your benchmark code? I believe compression might depend on data you write, if it full random, it's difficult to compress the data. On Wed, Aug 26, 2020, 8:26 PM 38797715 <38797...@qq.com <mailto:38797...@qq.com>> wrote: Hi, We turn on disk compression to see the trend

How to confirm that disk compression is in effect?

Hi, We turn on disk compression to see the trend of execution time and disk space. Our expectation is that after disk compression is turned on, although more CPU is used, the disk space is less occupied. Because more data is written per unit time, the overall execution time will be shortened

Re: How to solve the problem of single quotes in SQL statements?

ok,solved. INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (1,'Ka''bul','AFG','Kabol',178); 在 2020/8/26 下午7:10, 38797715 写道: Hi, for example: CREATE TABLE City (   ID INT(11),   Name CHAR(35),   CountryCode CHAR(3), 

How to solve the problem of single quotes in SQL statements?

Hi, for example: CREATE TABLE City (   ID INT(11),   Name CHAR(35),   CountryCode CHAR(3),   District CHAR(20),   Population INT(11),   PRIMARY KEY (ID, CountryCode) ) WITH "template=partitioned, backups=1, affinityKey=CountryCode, CACHE_NAME=City, KEY_TYPE=demo.model.CityKey, VALUE_TYPE=dem

Uncommitted data within the scope of a transaction cannot be read within the same thread(2.8.1)

Hi guys, If you execute the following code, you will find that cache.iterator() does not return a result. If the transaction is not started, the returned result is correct. Is this a bug or a known technical limitation? server side just start ignite.sh public class CacheTransactionExample {

Re: Enabling swapPath causes invoking shutdown hook

hould scale out your cluster and wait while the cluster rebalances a part of the data to a new node. When the rebalancing completes, the performance will be recovered and swapping won’t longer be needed. Denis On Thursday, August 13, 2020, 38797715 <38797...@qq.com <mailto:38797...@qq.

Re: Enabling swapPath causes invoking shutdown hook

the documentation if you like. Regards, -- Ilya Kasnacheev ср, 5 авг. 2020 г. в 06:00, 38797715 <38797...@qq.com <mailto:38797...@qq.com>>: Hi Ilya, If so, there are two ways to implement ignite's swap space: 1. maxSize > physical memory, which will use the swap

Re: Enabling swapPath causes invoking shutdown hook

e Persistence instead. Regards, -- Ilya Kasnacheev сб, 25 июл. 2020 г. в 04:49, 38797715 <38797...@qq.com <mailto:38797...@qq.com>>: Hi, https://apacheignite.readme.io/docs/swap-space <https://apacheignite.readme.io/docs/swap-space> According to the above docu

integrated with Ignite and HBase

Hi community, Does the community have a demo integrated with Ignite and HBase? Such as the implementation of CacheStore or other implementation patterns?

Re: Enabling swapPath causes invoking shutdown hook

Hi, https://apacheignite.readme.io/docs/swap-space According to the above document, if the physical memory is small, you can solve this problem by opening the swap space,The specific method is to configure maxSize to a larger value (i.e. larger than the physical memory), and the swapPath prop

Enabling swapPath causes invoking shutdown hook

Hi community, When swapPath is configured in DataRegionConfiguration and maxSize is greater than the physical memory (that is, swap space is enabled), if the amount of data exceeds the physical memory, a node failure will occur. The log is as follows: [08:29:14,212][INFO][Thread-24][G] Invok

GridIoManager compile error(2.8.0)

Hi team, I downloaded the source code of version 2.8.1, but found that it could not be compiled successfully, and there were compilation errors in the code. for example: org.apache.ignite.internal.managers.communication.GridIoManager line 395: The method register(String, BooleanSupplier, St

Re: Binary recovery for a very long time

index [cacheId=1684722246, idxName=_key_PK] [2020-05-23T21:43:59,081][DEBUG][main][IgniteH2Indexing] Creating cache index [cacheId=1684722246, idxName=IDX_CO_CUST_SALE_CENTER_ID] [2020-05-23T21:43:59,088][DEBUG][main][IgniteH2Indexing] Creating cache index [cacheId=1684722246, idxName=IDX_CO_CUST_S

Data loading during startup

Hi community, I know that during the startup process of ignite node, cached data will not be loaded, that is, there is no warm up process. However, we can see from the top command that during the startup of ignite, the memory usage has been increasing, which will increase by more than 10g, w

Re: Binary recovery for a very long time

performance is tested first, in your specific use case. Regards, -- Ilya Kasnacheev пн, 18 мая 2020 г. в 16:47, 38797715 <38797...@qq.com <mailto:38797...@qq.com>>: Hi, If direct IO is disabled, the startup speed will be doubled, including some other tests. I find that dir

Re: Binary recovery for a very long time

Hi, If direct IO is disabled, the startup speed will be doubled, including some other tests. I find that direct IO has a great impact on the read performance. 在 2020/5/14 上午5:16, Evgenii Zhuravlev 写道: Can you share full logs from all nodes? вт, 12 мая 2020 г. в 18:24, 38797715 <38

Re: About index inline size of primary key

-DIGNITE_MAX_INDEX_PAYLOAD_SIZE=33 Regards, Stephen On 14 May 2020, at 14:23, 38797715 <38797...@qq.com <mailto:38797...@qq.com>> wrote: Hi, Today, I see the following information in the log: [2020-05-14T16:42:04,346][WARN][query-#7759][IgniteH2Indexing] Indexed columns of a row cannot be fully inlined int

About index inline size of primary key

Hi, Today, I see the following information in the log: [2020-05-14T16:42:04,346][WARN][query-#7759][IgniteH2Indexing] Indexed columns of a row cannot be fully inlined into index what may lead to slowdown due to additional data page reads, increase index inline size if needed (set system prope

Re: Binary recovery for a very long time

aLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd";> 在 2020/5/13 上午4:45, Evgenii Zhuravlev 写道: Hi, Can you share full logs and configuration? What disk so you use? Evgenii вт, 12 мая 2020

Re: Binary recovery for a very long time

Among them: CO_CO_NEW: ~ 48 minutes(partitioned,backup=1,33M) Ignite sys cache: ~ 27 minutes PLM_ITEM:~3 minutes(repicated,1.9K) 在 2020/5/12 下午9:08, 38797715 写道: Hi community, We have 5 servers, 16 cores, 256g memory, and 200g off-heap memory. We have 7 tables to test, and the data volume

Binary recovery for a very long time

Hi community, We have 5 servers, 16 cores, 256g memory, and 200g off-heap memory. We have 7 tables to test, and the data volume is respectively:31.8M,495.2M,552.3M,33M,873.3K,28M,1.9K(replicated),others are partitioned(backup = 1) VM args:-server -Xms20g -Xmx20g -XX:+AlwaysPreTouch -XX:+UseG1