Get the App
SLTechnology News&Howtos  ›  Database  › 

IGNITE TROUBLESHOOT

Shulou Source: shulou.com Published: 2022-06-01 08:27:52 10月03日 Update

H2 Console sets the system variable set IGNITE_H2_DEBUG_CONSOLE=true, and when you start IGNITE, an h3 console browser pops up automatically, and you can see the established index and specific data.

Reference https://apacheignite.readme.io/docs/sql-performance-and-debugging

Client programs can add System.setProperty ("IGNITE_QUIET", "false")

SqlFieldsQuery query = new SqlFieldsQuery ("explain [original query]") you can see the SQL execution plan, mainly the use of the index

JMX jconsole can see the basic information of CACHE. The name of JMXBean is: org.apache.[ cacheId] .[ gridName] .memory usage: org.apache.[ cacheId] .memoryMetrics needs to set IGNITE_JMX_PORT.

The remote DEBUG modifies the JVM_OPTS in ignite.bat/ignite.sh:

Set JVM_OPTS=-Xms1g-Xmx1g-server-XX:+AggressiveOpts-XX:MaxMetaspaceSize=256m-agentlib:jdwp=transport=dt_socket,server=y,suspend=n,address=9527

Log level adjustment IGNITE supports log4j, log4j2, slf, etc. You need to copy the ignite-log4j,ignite-log4j2 or ignite-slf4j under the [ignite_home] / libs/optional directory to the libs directory, and then modify the spring configuration file:

...

Java.util.log [ignite_home] / config/java.util.logging.properties. The log is recorded under [ignite_home]\ work\ log\. Reference: https://apacheignite.readme.io/docs/logging

Core log:

Query:

Client IgniteH2Indexing.queryDistributedSqlFields

If (log.isDebugEnabled ()) log.debug ("Parsed query: `" + sqlQry + "` into two step query:" + twoStepQry)

Server GridQueryProcessor.store

If (log.isDebugEnabled ()) log.debug ("Store [cache=" + cacheName + ", key=" + key + ", val=" + val + "]")

REBALANCE:

Server GridDhtPartitionSupplier.handleDemandMessage

If (log.isDebugEnabled) log.debug ("Starting supplying rebalancing [cache=" + grp.cacheOrGroupName () + ", fromNode=" + node.id () + ", partitionsCount=" + d.partitions (). Size () + ", topology=" + d.topologyVersion () + ", updateSeq=" + d.updateSequence () + ", idx=" + idx + "]") If (log.isDebugEnabled ()) log.debug ("Finished supplying rebalancing [cache=" + grp.cacheOrGroupName () + ", fromNode=" + node.id () + ", topology=" + d.topologyVersion () + ", updateSeq=" + d.updateSequence () + ", idx=" + idx + "]")

NETWORK:

Org.apache.ignite.internal.util.nio.GridTcpNioCommunicationClient org.apache.ignite.spi.communication.tcp.TcpCommunicationSpi

Tags: Log customer client directory index reference service information memory variable name situation data file time core browser program system level Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno vpn Linux Shulou Technology Huawei MariaDB