[19:19:55,595][INFO][main][IgniteKernal] >>> __________ ________________ >>> / _/ ___/ |/ / _/_ __/ __/ >>> _/ // (7 7 // / / / / _/ >>> /___/\___/_/|_/___/ /_/ /___/ >>> >>> ver. 2.7.1#20181029-sha1:83c27088 >>> 2018 Copyright(C) Apache Software Foundation >>> >>> Ignite documentation: http://ignite.apache.org [19:19:55,596][INFO][main][IgniteKernal] Config URL: file:/c:/Work/gridgain-professional-2.7.1-bin/server.xml [19:19:55,613][INFO][main][IgniteKernal] IgniteConfiguration [igniteInstanceName=null, pubPoolSize=8, svcPoolSize=8, callbackPoolSize=8, stripedPoolSize=8, sysPoolSize=8, mgmtPoolSize=4, igfsPoolSize=8, dataStreamerPoolSize=8, utilityCachePoolSize=8, utilityCacheKeepAliveTime=60000, p2pPoolSize=2, qryPoolSize=8, igniteHome=c:\Work\gridgain-professional-2.7.1-bin, igniteWorkDir=c:\Work\gridgain-professional-2.7.1-bin\work, mbeanSrv=com.sun.jmx.mbeanserver.JmxMBeanServer@6f94fa3e, nodeId=c9ddebdb-c328-4283-97c5-a6634444887a, marsh=BinaryMarshaller [], marshLocJobs=false, daemon=false, p2pEnabled=false, netTimeout=5000, sndRetryDelay=1000, sndRetryCnt=3, metricsHistSize=10000, metricsUpdateFreq=2000, metricsExpTime=9223372036854775807, discoSpi=TcpDiscoverySpi [addrRslvr=null, sockTimeout=0, ackTimeout=0, marsh=null, reconCnt=10, reconDelay=2000, maxAckTimeout=600000, forceSrvMode=false, clientReconnectDisabled=false, internalLsnr=null], segPlc=STOP, segResolveAttempts=2, waitForSegOnStart=true, allResolversPassReq=true, segChkFreq=10000, commSpi=TcpCommunicationSpi [connectGate=null, connPlc=org.apache.ignite.spi.communication.tcp.TcpCommunicationSpi$FirstConnectionPolicy@2d1ef81a, enableForcibleNodeKill=false, enableTroubleshootingLog=false, locAddr=null, locHost=null, locPort=47100, locPortRange=100, shmemPort=-1, directBuf=true, directSndBuf=false, idleConnTimeout=600000, connTimeout=5000, maxConnTimeout=600000, reconCnt=10, sockSndBuf=32768, sockRcvBuf=32768, msgQueueLimit=0, slowClientQueueLimit=0, nioSrvr=null, shmemSrv=null, usePairedConnections=false, connectionsPerNode=1, tcpNoDelay=true, filterReachableAddresses=false, ackSndThreshold=32, unackedMsgsBufSize=0, sockWriteTimeout=2000, boundTcpPort=-1, boundTcpShmemPort=-1, selectorsCnt=4, selectorSpins=0, addrRslvr=null, ctxInitLatch=java.util.concurrent.CountDownLatch@4c402120[Count = 1], stopping=false], evtSpi=org.apache.ignite.spi.eventstorage.NoopEventStorageSpi@327514f, colSpi=NoopCollisionSpi [], deploySpi=LocalDeploymentSpi [], indexingSpi=org.apache.ignite.spi.indexing.noop.NoopIndexingSpi@5542c4ed, addrRslvr=null, encryptionSpi=org.apache.ignite.spi.encryption.noop.NoopEncryptionSpi@1573f9fc, clientMode=false, rebalanceThreadPoolSize=1, txCfg=TransactionConfiguration [txSerEnabled=false, dfltIsolation=REPEATABLE_READ, dfltConcurrency=PESSIMISTIC, dfltTxTimeout=0, txTimeoutOnPartitionMapExchange=0, pessimisticTxLogSize=0, pessimisticTxLogLinger=10000, tmLookupClsName=null, txManagerFactory=null, useJtaSync=false], cacheSanityCheckEnabled=true, discoStartupDelay=60000, deployMode=SHARED, p2pMissedCacheSize=100, locHost=127.0.0.1, timeSrvPortBase=31100, timeSrvPortRange=100, failureDetectionTimeout=10000, sysWorkerBlockedTimeout=null, clientFailureDetectionTimeout=30000, metricsLogFreq=60000, hadoopCfg=null, connectorCfg=ConnectorConfiguration [jettyPath=null, host=null, port=11211, noDelay=true, directBuf=false, sndBufSize=32768, rcvBufSize=32768, idleQryCurTimeout=600000, idleQryCurCheckFreq=60000, sndQueueLimit=0, selectorCnt=4, idleTimeout=7000, sslEnabled=false, sslClientAuth=false, sslCtxFactory=null, sslFactory=null, portRange=100, threadPoolSize=8, msgInterceptor=null], odbcCfg=null, warmupClos=null, atomicCfg=AtomicConfiguration [seqReserveSize=1000, cacheMode=PARTITIONED, backups=1, aff=null, grpName=null], classLdr=null, sslCtxFactory=null, platformCfg=null, binaryCfg=BinaryConfiguration [idMapper=null, nameMapper=null, serializer=null, compactFooter=true], memCfg=null, pstCfg=null, dsCfg=DataStorageConfiguration [sysRegionInitSize=52428800, sysRegionMaxSize=104857600, pageSize=0, concLvl=0, dfltDataRegConf=DataRegionConfiguration [name=default, maxSize=209715200, initSize=104857600, swapPath=null, pageEvictionMode=DISABLED, evictionThreshold=0.9, emptyPagesPoolSize=100, metricsEnabled=false, metricsSubIntervalCount=5, metricsRateTimeInterval=60000, persistenceEnabled=true, checkpointPageBufSize=0], dataRegions=DataRegionConfiguration[] [DataRegionConfiguration [name=dataRegion1, maxSize=209715200, initSize=104857600, swapPath=null, pageEvictionMode=RANDOM_LRU, evictionThreshold=0.9, emptyPagesPoolSize=100, metricsEnabled=false, metricsSubIntervalCount=5, metricsRateTimeInterval=60000, persistenceEnabled=true, checkpointPageBufSize=0], DataRegionConfiguration [name=dataRegion2, maxSize=104857600, initSize=52428800, swapPath=null, pageEvictionMode=RANDOM_LRU, evictionThreshold=0.9, emptyPagesPoolSize=100, metricsEnabled=false, metricsSubIntervalCount=5, metricsRateTimeInterval=60000, persistenceEnabled=true, checkpointPageBufSize=0]], storagePath=null, checkpointFreq=1000, lockWaitTime=10000, checkpointThreads=4, checkpointWriteOrder=SEQUENTIAL, walHistSize=20, maxWalArchiveSize=1073741824, walSegments=10, walSegmentSize=67108864, walPath=db/wal, walArchivePath=db/wal/archive, metricsEnabled=false, walMode=FSYNC, walTlbSize=131072, walBuffSize=0, walFlushFreq=2000, walFsyncDelay=1000, walRecordIterBuffSize=67108864, alwaysWriteFullPages=false, fileIOFactory=org.apache.ignite.internal.processors.cache.persistence.file.AsyncFileIOFactory@1fa121e2, metricsSubIntervalCnt=5, metricsRateTimeInterval=60000, walAutoArchiveAfterInactivity=-1, writeThrottlingEnabled=false, walCompactionEnabled=false, walCompactionLevel=1, checkpointReadLockTimeout=null], activeOnStart=true, autoActivation=true, longQryWarnTimeout=3000, sqlConnCfg=null, cliConnCfg=ClientConnectorConfiguration [host=null, port=10800, portRange=100, sockSndBufSize=0, sockRcvBufSize=0, tcpNoDelay=true, maxOpenCursorsPerConn=128, threadPoolSize=8, idleTimeout=0, jdbcEnabled=true, odbcEnabled=true, thinCliEnabled=true, sslEnabled=false, useIgniteSslCtxFactory=true, sslClientAuth=false, sslCtxFactory=null], mvccVacuumThreadCnt=2, mvccVacuumFreq=5000, authEnabled=false, failureHnd=null, commFailureRslvr=null] [19:19:55,614][INFO][main][IgniteKernal] Daemon mode: off [19:19:55,615][INFO][main][IgniteKernal] OS: Windows 10 10.0 amd64 [19:19:55,615][INFO][main][IgniteKernal] OS user: gridgain [19:19:55,615][INFO][main][IgniteKernal] PID: 16696 [19:19:55,616][INFO][main][IgniteKernal] Language runtime: Java Platform API Specification ver. 1.8 [19:19:55,621][INFO][main][IgniteKernal] VM information: Java(TM) SE Runtime Environment 1.8.0_181-b13 Oracle Corporation Java HotSpot(TM) 64-Bit Server VM 25.181-b13 [19:19:55,622][INFO][main][IgniteKernal] VM total memory: 0.96GB [19:19:55,622][INFO][main][IgniteKernal] Remote Management [restart: on, REST: on, JMX (remote: on, port: 49293, auth: off, ssl: off)] [19:19:55,622][INFO][main][IgniteKernal] Logger: JavaLogger [quiet=false, config=null] [19:19:55,623][INFO][main][IgniteKernal] IGNITE_HOME=c:\Work\gridgain-professional-2.7.1-bin [19:19:55,623][INFO][main][IgniteKernal] VM arguments: [-XX:+AggressiveOpts, -Xms1g, -Xmx1g, -XX:MaxMetaspaceSize=256m, -DIGNITE_QUIET=false, -DIGNITE_SUCCESS_FILE=c:\Work\gridgain-professional-2.7.1-bin\work\ignite_success_2517d220-4caf-498d-b69e-2b4f04e785e8, -Dcom.sun.management.jmxremote, -Dcom.sun.management.jmxremote.port=49293, -Dcom.sun.management.jmxremote.authenticate=false, -Dcom.sun.management.jmxremote.ssl=false, -DIGNITE_HOME=c:\Work\gridgain-professional-2.7.1-bin, -DIGNITE_PROG_NAME=ignite.bat, -DID=1] [19:19:55,623][INFO][main][IgniteKernal] System cache's DataRegion size is configured to 50 MB. Use DataStorageConfiguration.systemRegionInitialSize property to change the setting. [19:19:55,629][INFO][main][IgniteKernal] Configured caches [in 'sysMemPlc' dataRegion: ['ignite-sys-cache']] [19:19:55,631][WARNING][main][IgniteKernal] Please set system property '-Djava.net.preferIPv4Stack=true' to avoid possible problems in mixed environments. [19:19:55,632][WARNING][pub-#19][GridDiagnostic] This operating system has been tested less rigorously: Windows 10 10.0 amd64. Our team will appreciate the feedback if you experience any problems running ignite in this environment. [19:19:55,633][INFO][main][IgniteKernal] 3-rd party licenses can be found at: c:\Work\gridgain-professional-2.7.1-bin\libs\licenses [19:19:55,691][INFO][main][IgnitePluginProcessor] Configured plugins: [19:19:55,691][INFO][main][IgnitePluginProcessor] ^-- None [19:19:55,692][INFO][main][IgnitePluginProcessor] [19:19:55,694][INFO][main][FailureProcessor] Configured failure handler: [hnd=StopNodeOrHaltFailureHandler [tryStop=false, timeout=0, super=AbstractFailureHandler [ignoredFailureTypes=UnmodifiableSet [SYSTEM_WORKER_BLOCKED]]]] [19:19:55,730][INFO][main][TcpCommunicationSpi] Successfully bound communication NIO server to TCP port [port=47100, locHost=/127.0.0.1, selectorsCnt=4, selectorSpins=0, pairedConn=false] [19:19:55,731][WARNING][main][TcpCommunicationSpi] Message queue limit is set to 0 which may lead to potential OOMEs when running cache operations in FULL_ASYNC or PRIMARY_SYNC modes due to message queues growth on sender and receiver sides. [19:19:55,746][WARNING][main][NoopCheckpointSpi] Checkpoints are disabled (to enable configure any GridCheckpointSpi implementation) [19:19:55,765][WARNING][main][GridCollisionManager] Collision resolution is disabled (all jobs will be activated upon arrival). [19:19:55,772][INFO][main][IgniteKernal] Security status [authentication=off, tls/ssl=off] [19:19:55,856][INFO][main][CacheObjectBinaryProcessorImpl] Resolved directory for serialized binary metadata: c:\Work\gridgain-professional-2.7.1-bin\work\binary_meta\1 [19:19:55,986][INFO][main][FilePageStoreManager] Resolved page store work directory: c:\Work\gridgain-professional-2.7.1-bin\work\db\1 [19:19:55,987][INFO][main][FsyncModeFileWriteAheadLogManager] Resolved write ahead log work directory: c:\Work\gridgain-professional-2.7.1-bin\work\db\wal\1 [19:19:55,989][INFO][main][FsyncModeFileWriteAheadLogManager] Resolved write ahead log archive directory: c:\Work\gridgain-professional-2.7.1-bin\work\db\wal\archive\1 [19:19:56,237][INFO][main][FsyncModeFileWriteAheadLogManager] Started write-ahead log manager [mode=FSYNC] [19:19:56,246][WARNING][main][GridCacheDatabaseSharedManager] Page eviction mode set for [dataRegion1] data will have no effect because the oldest pages are evicted automatically if Ignite persistence is enabled. [19:19:56,247][WARNING][main][GridCacheDatabaseSharedManager] Page eviction mode set for [dataRegion2] data will have no effect because the oldest pages are evicted automatically if Ignite persistence is enabled. [19:19:56,252][WARNING][main][GridCacheDatabaseSharedManager] DataRegionConfiguration.maxWalArchiveSize instead DataRegionConfiguration.walHistorySize would be used for removing old archive wal files [19:19:56,300][INFO][main][PartitionsEvictManager] Evict partition permits=2 [19:19:56,423][INFO][main][ClientListenerProcessor] Client connector processor has started on TCP port 10800 [19:19:56,455][INFO][main][GridTcpRestProtocol] Command protocol successfully started [name=TCP binary, host=/127.0.0.1, port=11211] [19:19:56,553][INFO][main][IgniteKernal] Non-loopback local IPs: 172.25.4.52, fe80:0:0:0:2d2b:5bfb:e052:9fb0%eth5 [19:19:56,553][INFO][main][IgniteKernal] Enabled local MACs: 54A050520B61 [19:19:56,558][INFO][main][GridCacheDatabaseSharedManager] Read checkpoint status [startMarker=null, endMarker=null] [19:19:56,567][INFO][main][PageMemoryImpl] Started page memory [memoryAllocated=100,0 MiB, pages=24808, tableSize=1,9 MiB, checkpointBuffer=100,0 MiB] [19:19:56,567][INFO][main][GridCacheDatabaseSharedManager] Checking memory state [lastValidPos=FileWALPointer [idx=0, fileOff=0, len=0], lastMarked=FileWALPointer [idx=0, fileOff=0, len=0], lastCheckpointId=00000000-0000-0000-0000-000000000000] [19:19:56,577][INFO][main][GridCacheDatabaseSharedManager] Applying lost cache updates since last checkpoint record [lastMarked=FileWALPointer [idx=0, fileOff=0, len=0], lastCheckpointId=00000000-0000-0000-0000-000000000000] [19:19:56,579][INFO][main][GridCacheDatabaseSharedManager] Finished applying WAL changes [updatesApplied=0, time=0ms] [19:19:56,612][INFO][main][TcpDiscoverySpi] Connection check threshold is calculated: 10000 [19:19:56,614][INFO][main][TcpDiscoverySpi] Successfully bound to TCP port [port=47500, localHost=127.0.0.1/127.0.0.1, locNodeId=c9ddebdb-c328-4283-97c5-a6634444887a] [19:19:59,408][INFO][tcp-disco-srvr-#3][TcpDiscoverySpi] TCP discovery accepted incoming connection [rmtAddr=/127.0.0.1, rmtPort=49330] [19:19:59,416][INFO][tcp-disco-srvr-#3][TcpDiscoverySpi] TCP discovery spawning a new thread for connection [rmtAddr=/127.0.0.1, rmtPort=49330] [19:19:59,416][INFO][tcp-disco-sock-reader-#4][TcpDiscoverySpi] Started serving remote node connection [rmtAddr=/127.0.0.1:49330, rmtPort=49330] [19:19:59,441][INFO][tcp-disco-sock-reader-#4][TcpDiscoverySpi] Finished serving remote node connection [rmtAddr=/127.0.0.1:49330, rmtPort=49330 [19:20:04,788][INFO][disco-notifier-worker-#41][MvccProcessorImpl] Assigned mvcc coordinator [crd=MvccCoordinator [nodeId=c9ddebdb-c328-4283-97c5-a6634444887a, crdVer=1540830004768, topVer=AffinityTopologyVersion [topVer=1, minorTopVer=0]], crdNode=TcpDiscoveryNode [id=c9ddebdb-c328-4283-97c5-a6634444887a, addrs=ArrayList [127.0.0.1], sockAddrs=HashSet [/127.0.0.1:47500], discPort=47500, order=1, intOrder=1, lastExchangeTime=1540829996604, loc=true, ver=2.7.1#20181029-sha1:83c27088, isClient=false]] [19:20:04,857][INFO][main][IgniteKernal] Performance suggestions for grid (fix if possible) [19:20:04,857][INFO][main][IgniteKernal] To disable, set -DIGNITE_PERFORMANCE_SUGGESTIONS_DISABLED=true [19:20:04,858][INFO][main][IgniteKernal] ^-- Enable G1 Garbage Collector (add '-XX:+UseG1GC' to JVM options) [19:20:04,858][INFO][main][IgniteKernal] ^-- Set max direct memory size if getting 'OOME: Direct buffer memory' (add '-XX:MaxDirectMemorySize=[g|G|m|M|k|K]' to JVM options) [19:20:04,858][INFO][main][IgniteKernal] ^-- Disable processing of calls to System.gc() (add '-XX:+DisableExplicitGC' to JVM options) [19:20:04,858][INFO][main][IgniteKernal] Refer to this page for more performance suggestions: https://apacheignite.readme.io/docs/jvm-and-system-tuning [19:20:04,859][INFO][main][IgniteKernal] [19:20:04,859][INFO][main][IgniteKernal] To start Console Management & Monitoring run ignitevisorcmd.{sh|bat} [19:20:04,859][INFO][main][IgniteKernal] Data Regions Configured: [19:20:04,860][INFO][main][IgniteKernal] ^-- default [initSize=100,0 MiB, maxSize=200,0 MiB, persistence=true] [19:20:04,860][INFO][main][IgniteKernal] ^-- dataRegion1 [initSize=100,0 MiB, maxSize=200,0 MiB, persistence=true] [19:20:04,860][INFO][main][IgniteKernal] ^-- dataRegion2 [initSize=50,0 MiB, maxSize=100,0 MiB, persistence=true] [19:20:04,861][INFO][main][IgniteKernal] >>> +----------------------------------------------------------------------+ >>> Ignite ver. 2.7.1#20181029-sha1:83c270883cf385aed6ea4b8c4a0bafabf4529491 >>> +----------------------------------------------------------------------+ >>> OS name: Windows 10 10.0 amd64 >>> CPU(s): 8 >>> Heap: 1.0GB >>> VM name: 16696@work-pc >>> Local node [ID=C9DDEBDB-C328-4283-97C5-A6634444887A, order=1, clientMode=false] >>> Local node addresses: [127.0.0.1] >>> Local ports: TCP:10800 TCP:11211 TCP:47100 TCP:47500 [19:20:04,861][INFO][main][IgniteKernal] >>> Ignite cluster is not active (limited functionality available). Use control.(sh|bat) script or IgniteCluster interface to activate. [19:20:04,862][INFO][main][GridDiscoveryManager] Topology snapshot [ver=1, locNode=c9ddebdb, servers=1, clients=0, state=INACTIVE, CPUs=8, offheap=0.49GB, heap=1.0GB] [19:20:13,588][INFO][tcp-disco-srvr-#3][TcpDiscoverySpi] TCP discovery accepted incoming connection [rmtAddr=/127.0.0.1, rmtPort=49353] [19:20:13,589][INFO][tcp-disco-srvr-#3][TcpDiscoverySpi] TCP discovery spawning a new thread for connection [rmtAddr=/127.0.0.1, rmtPort=49353] [19:20:13,592][INFO][tcp-disco-sock-reader-#5][TcpDiscoverySpi] Started serving remote node connection [rmtAddr=/127.0.0.1:49353, rmtPort=49353] [19:20:13,613][INFO][tcp-disco-sock-reader-#5][TcpDiscoverySpi] Finished serving remote node connection [rmtAddr=/127.0.0.1:49353, rmtPort=49353 [19:20:13,626][INFO][tcp-disco-msg-worker-#2][GridEncryptionManager] Joining node doesn't have encryption data [node=24507fea-b571-48e6-b28d-cc38cf82ba21] [19:20:13,649][INFO][tcp-disco-msg-worker-#2][TcpDiscoverySpi] New next node [newNext=TcpDiscoveryNode [id=24507fea-b571-48e6-b28d-cc38cf82ba21, addrs=ArrayList [127.0.0.1], sockAddrs=HashSet [/127.0.0.1:47501], discPort=47501, order=0, intOrder=2, lastExchangeTime=1540830013603, loc=false, ver=2.7.1#20181029-sha1:83c27088, isClient=false]] [19:20:13,697][INFO][tcp-disco-srvr-#3][TcpDiscoverySpi] TCP discovery accepted incoming connection [rmtAddr=/127.0.0.1, rmtPort=49355] [19:20:13,698][INFO][tcp-disco-srvr-#3][TcpDiscoverySpi] TCP discovery spawning a new thread for connection [rmtAddr=/127.0.0.1, rmtPort=49355] [19:20:13,699][INFO][tcp-disco-sock-reader-#6][TcpDiscoverySpi] Started serving remote node connection [rmtAddr=/127.0.0.1:49355, rmtPort=49355] [19:20:13,706][INFO][disco-event-worker-#42][GridDiscoveryManager] Added new node to topology: TcpDiscoveryNode [id=24507fea-b571-48e6-b28d-cc38cf82ba21, addrs=ArrayList [127.0.0.1], sockAddrs=HashSet [/127.0.0.1:47501], discPort=47501, order=2, intOrder=2, lastExchangeTime=1540830013603, loc=false, ver=2.7.1#20181029-sha1:83c27088, isClient=false] [19:20:13,707][INFO][disco-event-worker-#42][GridDiscoveryManager] Topology snapshot [ver=2, locNode=c9ddebdb, servers=2, clients=0, state=INACTIVE, CPUs=8, offheap=0.98GB, heap=2.0GB] [19:20:16,207][INFO][rest-#46][GridClusterStateProcessor] Sending activate request with BaselineTopology BaselineTopology [id=0, branchingHash=99, branchingType='New BaselineTopology', baselineNodes=[1, 2]] [19:20:16,214][INFO][disco-notifier-worker-#41][GridClusterStateProcessor] Received activate request with BaselineTopology[id=0] [19:20:16,215][INFO][disco-notifier-worker-#41][GridClusterStateProcessor] Started state transition: true [19:20:16,235][INFO][exchange-worker-#43][time] Started exchange init [topVer=AffinityTopologyVersion [topVer=2, minorTopVer=1], mvccCrd=MvccCoordinator [nodeId=c9ddebdb-c328-4283-97c5-a6634444887a, crdVer=1540830004768, topVer=AffinityTopologyVersion [topVer=1, minorTopVer=0]], mvccCrdChange=true, crd=true, evt=DISCOVERY_CUSTOM_EVT, evtNode=c9ddebdb-c328-4283-97c5-a6634444887a, customEvt=ChangeGlobalStateMessage [id=fe0ef90c661-fc7d5e5b-e33f-459d-b45d-eba6a540ea0d, reqId=935943fa-6280-4239-ab1e-6da2064b7061, initiatingNodeId=c9ddebdb-c328-4283-97c5-a6634444887a, activate=true, baselineTopology=BaselineTopology [id=0, branchingHash=99, branchingType='New BaselineTopology', baselineNodes=[1, 2]], forceChangeBaselineTopology=false, timestamp=1540830016207], allowMerge=false] [19:20:16,236][INFO][exchange-worker-#43][GridDhtPartitionsExchangeFuture] Start activation process [nodeId=c9ddebdb-c328-4283-97c5-a6634444887a, client=false, topVer=AffinityTopologyVersion [topVer=2, minorTopVer=1]] [19:20:16,238][INFO][exchange-worker-#43][FilePageStoreManager] Resolved page store work directory: c:\Work\gridgain-professional-2.7.1-bin\work\db\1 [19:20:16,239][INFO][exchange-worker-#43][FsyncModeFileWriteAheadLogManager] Resolved write ahead log work directory: c:\Work\gridgain-professional-2.7.1-bin\work\db\wal\1 [19:20:16,240][INFO][exchange-worker-#43][FsyncModeFileWriteAheadLogManager] Resolved write ahead log archive directory: c:\Work\gridgain-professional-2.7.1-bin\work\db\wal\archive\1 [19:20:16,241][INFO][exchange-worker-#43][FsyncModeFileWriteAheadLogManager] Started write-ahead log manager [mode=FSYNC] [19:20:16,250][INFO][exchange-worker-#43][PageMemoryImpl] Started page memory [memoryAllocated=200,0 MiB, pages=49624, tableSize=3,9 MiB, checkpointBuffer=200,0 MiB] [19:20:16,265][INFO][exchange-worker-#43][PageMemoryImpl] Started page memory [memoryAllocated=100,0 MiB, pages=24808, tableSize=1,9 MiB, checkpointBuffer=100,0 MiB] [19:20:16,269][INFO][exchange-worker-#43][PageMemoryImpl] Started page memory [memoryAllocated=200,0 MiB, pages=49624, tableSize=3,9 MiB, checkpointBuffer=200,0 MiB] [19:20:16,271][INFO][exchange-worker-#43][PageMemoryImpl] Started page memory [memoryAllocated=100,0 MiB, pages=24808, tableSize=1,9 MiB, checkpointBuffer=100,0 MiB] [19:20:16,278][INFO][exchange-worker-#43][PageMemoryImpl] Started page memory [memoryAllocated=100,0 MiB, pages=24808, tableSize=1,9 MiB, checkpointBuffer=100,0 MiB] [19:20:16,280][INFO][exchange-worker-#43][PageMemoryImpl] Started page memory [memoryAllocated=100,0 MiB, pages=24808, tableSize=1,9 MiB, checkpointBuffer=100,0 MiB] [19:20:16,294][INFO][exchange-worker-#43][msg] Components activation performed in 56 ms. [19:20:16,312][INFO][exchange-worker-#43][GridCacheDatabaseSharedManager] Read checkpoint status [startMarker=null, endMarker=null] [19:20:16,313][INFO][exchange-worker-#43][GridCacheDatabaseSharedManager] Checking memory state [lastValidPos=FileWALPointer [idx=0, fileOff=0, len=0], lastMarked=FileWALPointer [idx=0, fileOff=0, len=0], lastCheckpointId=00000000-0000-0000-0000-000000000000] [19:20:16,319][INFO][exchange-worker-#43][FsyncModeFileWriteAheadLogManager] Resuming logging to WAL segment [file=c:\Work\gridgain-professional-2.7.1-bin\work\db\wal\1\0000000000000000.wal, offset=0, ver=2] [19:20:16,362][INFO][exchange-worker-#43][GridClusterStateProcessor] Writing BaselineTopology[id=0] [19:20:16,389][INFO][exchange-worker-#43][GridCacheDatabaseSharedManager] Binary recovery performed in 93 ms. [19:20:16,396][INFO][exchange-worker-#43][CacheAffinitySharedManager] Updating caches registry performed in 6 ms. [19:20:16,530][INFO][exchange-worker-#43][GridCacheProcessor] Started cache [name=ignite-sys-cache, id=-2100569601, memoryPolicyName=sysMemPlc, mode=REPLICATED, atomicity=TRANSACTIONAL, backups=2147483647, mvcc=false], encryptionEnabled=false] [19:20:16,531][INFO][exchange-worker-#43][CacheAffinitySharedManager] Caches starting performed in 133 ms. [19:20:16,535][INFO][exchange-worker-#43][CacheAffinitySharedManager] Affinity initialization for started caches performed in 3 ms. [19:20:16,535][INFO][exchange-worker-#43][GridDhtPartitionsExchangeFuture] Successfully activated caches [nodeId=c9ddebdb-c328-4283-97c5-a6634444887a, client=false, topVer=AffinityTopologyVersion [topVer=2, minorTopVer=1]] [19:20:16,543][INFO][exchange-worker-#43][GridDhtPartitionsExchangeFuture] Finished waiting for partition release future [topVer=AffinityTopologyVersion [topVer=2, minorTopVer=1], waitTime=0ms, futInfo=NA, mode=LOCAL] [19:20:16,544][INFO][exchange-worker-#43][GridCacheDatabaseSharedManager] Read checkpoint status [startMarker=null, endMarker=null] [19:20:16,545][INFO][exchange-worker-#43][GridCacheDatabaseSharedManager] Applying lost cache updates since last checkpoint record [lastMarked=FileWALPointer [idx=0, fileOff=0, len=0], lastCheckpointId=00000000-0000-0000-0000-000000000000] [19:20:16,663][INFO][exchange-worker-#43][GridCacheDatabaseSharedManager] Restoring partition state for local groups [cntPartStateWal=0, lastCheckpointId=00000000-0000-0000-0000-000000000000] [19:20:16,669][INFO][exchange-worker-#43][GridCacheDatabaseSharedManager] Finished restoring partition state for local groups [cntProcessed=100, cntPartStateWal=0, time=11ms] [19:20:16,683][INFO][exchange-worker-#43][GridCacheDatabaseSharedManager] Finished applying WAL changes [updatesApplied=0, time=131ms] [19:20:16,684][INFO][exchange-worker-#43][GridCacheDatabaseSharedManager] Logical recovery performed in 140 ms. [19:20:16,740][INFO][exchange-worker-#43][GridCacheDatabaseSharedManager] Checkpointer initilialzation performed in 20 ms. [19:20:16,745][INFO][exchange-worker-#43][time] Finished exchange init [topVer=AffinityTopologyVersion [topVer=2, minorTopVer=1], crd=true] [19:20:16,762][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=5e393548-9743-4ac5-9692-d45b60e6b6b2, startPtr=FileWALPointer [idx=0, fileOff=207783, len=1947], checkpointLockWait=0ms, checkpointLockHoldTime=18ms, walCpRecordFsyncDuration=5ms, pages=23, reason='timeout'] [19:20:16,791][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=5e393548-9743-4ac5-9692-d45b60e6b6b2, pages=23, markPos=FileWALPointer [idx=0, fileOff=207783, len=1947], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=41ms, pagesWrite=6ms, fsync=21ms, total=68ms] [19:20:16,831][INFO][grid-nio-worker-tcp-comm-0-#24][TcpCommunicationSpi] Accepted incoming communication connection [locAddr=/127.0.0.1:47100, rmtAddr=/127.0.0.1:49377] [19:20:16,870][INFO][sys-#54][GridDhtPartitionsExchangeFuture] Coordinator received single message [ver=AffinityTopologyVersion [topVer=2, minorTopVer=1], node=24507fea-b571-48e6-b28d-cc38cf82ba21, allReceived=true] [19:20:16,871][INFO][sys-#54][GridDhtPartitionsExchangeFuture] finishExchangeOnCoordinator [topVer=AffinityTopologyVersion [topVer=2, minorTopVer=1], resVer=AffinityTopologyVersion [topVer=2, minorTopVer=1]] [19:20:16,874][INFO][sys-#54][GridDhtPartitionsExchangeFuture] Affinity changes (coordinator) applied in 0 ms. [19:20:16,878][INFO][sys-#54][GridDhtPartitionsExchangeFuture] Partitions validation performed in 4 ms. [19:20:16,880][INFO][sys-#54][GridDhtPartitionsExchangeFuture] Partitions assignment performed in 1 ms. [19:20:16,884][INFO][sys-#54][CacheAffinitySharedManager] Affinity recalculation (custom message) performed in 4 ms. [19:20:16,890][INFO][sys-#54][GridDhtPartitionsExchangeFuture] Preparing Full Message performed in 6 ms. [19:20:16,896][INFO][sys-#54][GridDhtPartitionsExchangeFuture] Sending Full Message performed in 1 ms. [19:20:16,896][INFO][sys-#54][GridDhtPartitionsExchangeFuture] Sending Full Message to all nodes performed in 5 ms. [19:20:16,897][INFO][sys-#54][GridDhtPartitionsExchangeFuture] Finish exchange future [startVer=AffinityTopologyVersion [topVer=2, minorTopVer=1], resVer=AffinityTopologyVersion [topVer=2, minorTopVer=1], err=null] [19:20:16,897][INFO][disco-notifier-worker-#41][GridClusterStateProcessor] Received state change finish message: true [19:20:16,899][INFO][sys-#54][GridCachePartitionExchangeManager] Sending Full Message for AffinityTopologyVersion [topVer=2, minorTopVer=1] performed in 1 ms. [19:20:16,901][INFO][sys-#54][MvccProcessorImpl] Initialize local node as mvcc coordinator [node=c9ddebdb-c328-4283-97c5-a6634444887a, crdVer=1540830004768] [19:20:16,909][INFO][sys-#54][GridCacheProcessor] Finish proxy initialization, cacheName=ignite-sys-cache, localNodeId=c9ddebdb-c328-4283-97c5-a6634444887a [19:20:16,916][INFO][sys-#54][GridDhtPartitionsExchangeFuture] Completed partition exchange [localNode=c9ddebdb-c328-4283-97c5-a6634444887a, exchange=GridDhtPartitionsExchangeFuture [topVer=AffinityTopologyVersion [topVer=2, minorTopVer=1], evt=DISCOVERY_CUSTOM_EVT, evtNode=TcpDiscoveryNode [id=c9ddebdb-c328-4283-97c5-a6634444887a, addrs=ArrayList [127.0.0.1], sockAddrs=HashSet [/127.0.0.1:47500], discPort=47500, order=1, intOrder=1, lastExchangeTime=1540830016894, loc=true, ver=2.7.1#20181029-sha1:83c27088, isClient=false], done=true], topVer=AffinityTopologyVersion [topVer=2, minorTopVer=1], durationFromInit=691] [19:20:16,924][INFO][exchange-worker-#43][GridCachePartitionExchangeManager] Skipping rebalancing (nothing scheduled) [top=AffinityTopologyVersion [topVer=2, minorTopVer=1], force=false, evt=DISCOVERY_CUSTOM_EVT, node=c9ddebdb-c328-4283-97c5-a6634444887a] [19:20:16,947][INFO][sys-#55][GridClusterStateProcessor] Successfully performed final activation steps [nodeId=c9ddebdb-c328-4283-97c5-a6634444887a, client=false, topVer=AffinityTopologyVersion [topVer=2, minorTopVer=1]] [19:20:17,729][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Skipping checkpoint (no pages were modified) [checkpointLockWait=0ms, checkpointLockHoldTime=0ms, reason='timeout'] [19:20:18,436][INFO][sys-#58][GridCachePartitionExchangeManager] Sending Full Message for AffinityTopologyVersion [topVer=2, minorTopVer=1] performed in 3 ms. [19:20:18,733][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Skipping checkpoint (no pages were modified) [checkpointLockWait=0ms, checkpointLockHoldTime=4ms, reason='timeout'] [19:20:19,740][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Skipping checkpoint (no pages were modified) [checkpointLockWait=0ms, checkpointLockHoldTime=3ms, reason='timeout'] [19:20:22,544][INFO][exchange-worker-#43][time] Started exchange init [topVer=AffinityTopologyVersion [topVer=2, minorTopVer=2], mvccCrd=MvccCoordinator [nodeId=c9ddebdb-c328-4283-97c5-a6634444887a, crdVer=1540830004768, topVer=AffinityTopologyVersion [topVer=1, minorTopVer=0]], mvccCrdChange=false, crd=true, evt=DISCOVERY_CUSTOM_EVT, evtNode=c9ddebdb-c328-4283-97c5-a6634444887a, customEvt=DynamicCacheChangeBatch [id=e31ef90c661-fc7d5e5b-e33f-459d-b45d-eba6a540ea0d, reqs=ArrayList [DynamicCacheChangeRequest [cacheName=SQL_PUBLIC_T1, hasCfg=true, nodeId=c9ddebdb-c328-4283-97c5-a6634444887a, clientStartOnly=false, stop=false, destroy=false, disabledAfterStartfalse]], exchangeActions=ExchangeActions [startCaches=[SQL_PUBLIC_T1], stopCaches=null, startGrps=[SQL_PUBLIC_T1], stopGrps=[], resetParts=null, stateChangeRequest=null], startCaches=false], allowMerge=false] [19:20:22,546][INFO][exchange-worker-#43][CacheAffinitySharedManager] Updating caches registry performed in 1 ms. [19:20:22,616][INFO][exchange-worker-#43][MvccProcessorImpl] Mvcc processor started. [19:20:22,644][INFO][exchange-worker-#43][GridCacheProcessor] Started cache [name=SQL_PUBLIC_T1, id=-1691533662, memoryPolicyName=default, mode=PARTITIONED, atomicity=TRANSACTIONAL_SNAPSHOT, backups=1, mvcc=true], encryptionEnabled=false] [19:20:22,644][INFO][exchange-worker-#43][CacheAffinitySharedManager] Caches starting performed in 98 ms. [19:20:22,650][INFO][exchange-worker-#43][CacheAffinitySharedManager] Affinity initialization for started caches performed in 5 ms. [19:20:22,654][INFO][exchange-worker-#43][GridDhtPartitionsExchangeFuture] Finished waiting for partition release future [topVer=AffinityTopologyVersion [topVer=2, minorTopVer=2], waitTime=0ms, futInfo=NA, mode=DISTRIBUTED] [19:20:22,677][INFO][exchange-worker-#43][GridDhtPartitionsExchangeFuture] Finished waiting for partitions release latch: ServerLatch [permits=0, pendingAcks=HashSet [], super=CompletableLatch [id=exchange, topVer=AffinityTopologyVersion [topVer=2, minorTopVer=2]]] [19:20:22,677][INFO][exchange-worker-#43][GridDhtPartitionsExchangeFuture] Finished waiting for partition release future [topVer=AffinityTopologyVersion [topVer=2, minorTopVer=2], waitTime=0ms, futInfo=NA, mode=LOCAL] [19:20:22,691][INFO][exchange-worker-#43][GridCacheDatabaseSharedManager] Logical recovery performed in 13 ms. [19:20:22,729][INFO][exchange-worker-#43][time] Finished exchange init [topVer=AffinityTopologyVersion [topVer=2, minorTopVer=2], crd=true] [19:20:22,735][INFO][sys-#44][GridDhtPartitionsExchangeFuture] Coordinator received single message [ver=AffinityTopologyVersion [topVer=2, minorTopVer=2], node=24507fea-b571-48e6-b28d-cc38cf82ba21, allReceived=true] [19:20:22,735][INFO][sys-#44][GridDhtPartitionsExchangeFuture] finishExchangeOnCoordinator [topVer=AffinityTopologyVersion [topVer=2, minorTopVer=2], resVer=AffinityTopologyVersion [topVer=2, minorTopVer=2]] [19:20:22,735][INFO][sys-#44][GridDhtPartitionsExchangeFuture] Affinity changes (coordinator) applied in 0 ms. [19:20:22,737][INFO][sys-#44][GridDhtPartitionsExchangeFuture] Partitions validation performed in 2 ms. [19:20:22,740][INFO][sys-#44][GridDhtPartitionsExchangeFuture] Partitions assignment performed in 3 ms. [19:20:22,746][INFO][sys-#44][GridDhtPartitionsExchangeFuture] Preparing Full Message performed in 4 ms. [19:20:22,746][INFO][sys-#44][GridDhtPartitionsExchangeFuture] Sending Full Message performed in 0 ms. [19:20:22,746][INFO][sys-#44][GridDhtPartitionsExchangeFuture] Sending Full Message to all nodes performed in 0 ms. [19:20:22,747][INFO][sys-#44][GridDhtPartitionsExchangeFuture] Finish exchange future [startVer=AffinityTopologyVersion [topVer=2, minorTopVer=2], resVer=AffinityTopologyVersion [topVer=2, minorTopVer=2], err=null] [19:20:22,752][INFO][sys-#44][GridCacheProcessor] Finish proxy initialization, cacheName=SQL_PUBLIC_T1, localNodeId=c9ddebdb-c328-4283-97c5-a6634444887a [19:20:22,765][INFO][pub-#68][GridCacheDatabaseSharedManager] Finished indexes rebuilding for cache [name=SQL_PUBLIC_T1, grpName=null] [19:20:22,766][INFO][sys-#44][GridDhtPartitionsExchangeFuture] Completed partition exchange [localNode=c9ddebdb-c328-4283-97c5-a6634444887a, exchange=GridDhtPartitionsExchangeFuture [topVer=AffinityTopologyVersion [topVer=2, minorTopVer=2], evt=DISCOVERY_CUSTOM_EVT, evtNode=TcpDiscoveryNode [id=c9ddebdb-c328-4283-97c5-a6634444887a, addrs=ArrayList [127.0.0.1], sockAddrs=HashSet [/127.0.0.1:47500], discPort=47500, order=1, intOrder=1, lastExchangeTime=1540830022551, loc=true, ver=2.7.1#20181029-sha1:83c27088, isClient=false], done=true], topVer=AffinityTopologyVersion [topVer=2, minorTopVer=2], durationFromInit=224] [19:20:22,774][INFO][exchange-worker-#43][GridCachePartitionExchangeManager] Skipping rebalancing (nothing scheduled) [top=AffinityTopologyVersion [topVer=2, minorTopVer=2], force=false, evt=DISCOVERY_CUSTOM_EVT, node=c9ddebdb-c328-4283-97c5-a6634444887a] [19:20:22,797][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=403a8d85-6fe9-48cb-9840-85d95d22d306, startPtr=FileWALPointer [idx=0, fileOff=297317, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=15ms, walCpRecordFsyncDuration=15ms, pages=13, reason='timeout'] [19:20:22,804][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=403a8d85-6fe9-48cb-9840-85d95d22d306, pages=13, markPos=FileWALPointer [idx=0, fileOff=297317, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=42ms, pagesWrite=1ms, fsync=6ms, total=49ms] [19:20:23,784][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=e9453eaa-bc52-42f5-a4d8-40c00881d8cf, startPtr=FileWALPointer [idx=0, fileOff=640680, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=5ms, walCpRecordFsyncDuration=8ms, pages=122, reason='timeout'] [19:20:23,809][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=e9453eaa-bc52-42f5-a4d8-40c00881d8cf, pages=122, markPos=FileWALPointer [idx=0, fileOff=640680, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=27ms, pagesWrite=7ms, fsync=18ms, total=52ms] [19:20:24,780][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=6fcf06b3-1ab8-4833-9c0e-c1dc84cd13a7, startPtr=FileWALPointer [idx=0, fileOff=1455357, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=3ms, walCpRecordFsyncDuration=3ms, pages=62, reason='timeout'] [19:20:24,802][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=6fcf06b3-1ab8-4833-9c0e-c1dc84cd13a7, pages=62, markPos=FileWALPointer [idx=0, fileOff=1455357, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=15ms, pagesWrite=2ms, fsync=19ms, total=36ms] [19:20:25,790][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=f4a28c2a-361e-4a71-948d-2762c5d6d347, startPtr=FileWALPointer [idx=0, fileOff=2428422, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=3ms, walCpRecordFsyncDuration=3ms, pages=62, reason='timeout'] [19:20:25,811][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=f4a28c2a-361e-4a71-948d-2762c5d6d347, pages=62, markPos=FileWALPointer [idx=0, fileOff=2428422, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=17ms, pagesWrite=2ms, fsync=19ms, total=38ms] [19:20:26,214][SEVERE][jdbc-request-handler-worker-#76][JdbcRequestHandler] Failed to execute SQL query [reqId=0, req=JdbcQueryExecuteRequest [schemaName=PUBLIC, pageSize=1024, maxRows=0, sqlQry=update t1 set b=b-1, args=Object[] [], stmtType=ANY_STATEMENT_TYPE, autoCommit=true]] class org.apache.ignite.internal.processors.query.IgniteSQLException: Cannot serialize transaction due to write conflict (transaction is marked for rollback) at org.apache.ignite.internal.processors.cache.GridCacheMapEntry.serializationError(GridCacheMapEntry.java:6712) at org.apache.ignite.internal.processors.cache.GridCacheMapEntry.mvccSet(GridCacheMapEntry.java:1117) at org.apache.ignite.internal.processors.cache.distributed.dht.GridDhtTxAbstractEnlistFuture.continueLoop(GridDhtTxAbstractEnlistFuture.java:460) at org.apache.ignite.internal.processors.cache.distributed.dht.GridDhtTxAbstractEnlistFuture.init(GridDhtTxAbstractEnlistFuture.java:368) at org.apache.ignite.internal.processors.cache.distributed.dht.GridDhtTransactionalCacheAdapter.processNearTxQueryEnlistRequest(GridDhtTransactionalCacheAdapter.java:771) at org.apache.ignite.internal.processors.cache.distributed.dht.GridDhtTransactionalCacheAdapter.access$500(GridDhtTransactionalCacheAdapter.java:112) at org.apache.ignite.internal.processors.cache.distributed.dht.GridDhtTransactionalCacheAdapter$8.apply(GridDhtTransactionalCacheAdapter.java:188) at org.apache.ignite.internal.processors.cache.distributed.dht.GridDhtTransactionalCacheAdapter$8.apply(GridDhtTransactionalCacheAdapter.java:186) at org.apache.ignite.internal.processors.cache.GridCacheIoManager.processMessage(GridCacheIoManager.java:1056) at org.apache.ignite.internal.processors.cache.GridCacheIoManager.onMessage0(GridCacheIoManager.java:581) at org.apache.ignite.internal.processors.cache.GridCacheIoManager.handleMessage(GridCacheIoManager.java:380) at org.apache.ignite.internal.processors.cache.GridCacheIoManager.handleMessage(GridCacheIoManager.java:306) at org.apache.ignite.internal.processors.cache.GridCacheIoManager.access$100(GridCacheIoManager.java:101) at org.apache.ignite.internal.processors.cache.GridCacheIoManager$1.onMessage(GridCacheIoManager.java:295) at org.apache.ignite.internal.managers.communication.GridIoManager.invokeListener(GridIoManager.java:1569) at org.apache.ignite.internal.managers.communication.GridIoManager.processRegularMessage0(GridIoManager.java:1197) at org.apache.ignite.internal.managers.communication.GridIoManager.access$4200(GridIoManager.java:127) at org.apache.ignite.internal.managers.communication.GridIoManager$9.run(GridIoManager.java:1093) at org.apache.ignite.internal.util.StripedExecutor$Stripe.body(StripedExecutor.java:505) at org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:120) at java.lang.Thread.run(Thread.java:748) [19:20:26,224][SEVERE][jdbc-request-handler-worker-#76][JdbcRequestHandler] Failed to execute SQL query [reqId=0, req=JdbcQueryExecuteRequest [schemaName=PUBLIC, pageSize=1024, maxRows=0, sqlQry=commit, args=Object[] [], stmtType=ANY_STATEMENT_TYPE, autoCommit=true]] class org.apache.ignite.internal.processors.query.IgniteSQLException: Failed to execute DDL statement [stmt=commit, err=Failed to finish transaction because it has been rolled back [timeout=0, tx=GridNearTxLocal[xid=261ff90c661-00000000-0914-10f6-0000-000000000001, xidVersion=GridCacheVersion [topVer=152310006, order=1540829999458, nodeOrder=1], concurrency=PESSIMISTIC, isolation=REPEATABLE_READ, state=MARKED_ROLLBACK, invalidate=false, rollbackOnly=true, nodeId=c9ddebdb-c328-4283-97c5-a6634444887a, timeout=0, duration=22, label=null]]] at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.tryQueryDistributedSqlFieldsNative(IgniteH2Indexing.java:1988) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.querySqlFields(IgniteH2Indexing.java:2120) at org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:2141) at org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:2136) at org.apache.ignite.internal.util.lang.IgniteOutClosureX.apply(IgniteOutClosureX.java:36) at org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:2713) at org.apache.ignite.internal.processors.query.GridQueryProcessor.querySqlFields(GridQueryProcessor.java:2150) at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.executeQuery(JdbcRequestHandler.java:511) at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.doHandle(JdbcRequestHandler.java:245) at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandlerWorker.body(JdbcRequestHandlerWorker.java:90) at org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:120) at java.lang.Thread.run(Thread.java:748) Caused by: class org.apache.ignite.internal.transactions.IgniteTxRollbackCheckedException: Failed to finish transaction because it has been rolled back [timeout=0, tx=GridNearTxLocal[xid=261ff90c661-00000000-0914-10f6-0000-000000000001, xidVersion=GridCacheVersion [topVer=152310006, order=1540829999458, nodeOrder=1], concurrency=PESSIMISTIC, isolation=REPEATABLE_READ, state=MARKED_ROLLBACK, invalidate=false, rollbackOnly=true, nodeId=c9ddebdb-c328-4283-97c5-a6634444887a, timeout=0, duration=22, label=null]] at org.apache.ignite.internal.processors.cache.transactions.IgniteTxAdapter.rollbackException(IgniteTxAdapter.java:763) at org.apache.ignite.internal.processors.cache.distributed.near.GridNearPessimisticTxPrepareFuture.prepare(GridNearPessimisticTxPrepareFuture.java:180) at org.apache.ignite.internal.processors.cache.distributed.near.GridNearTxLocal.prepareNearTxLocal(GridNearTxLocal.java:3734) at org.apache.ignite.internal.processors.cache.distributed.near.GridNearTxLocal.commitNearTxLocalAsync(GridNearTxLocal.java:3780) at org.apache.ignite.internal.processors.cache.distributed.near.GridNearTxLocal.commit(GridNearTxLocal.java:3761) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.doCommit(IgniteH2Indexing.java:2076) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.processTxCommand(IgniteH2Indexing.java:2055) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.tryQueryDistributedSqlFieldsNative(IgniteH2Indexing.java:1982) ... 11 more [19:20:26,245][SEVERE][jdbc-request-handler-worker-#76][JdbcRequestHandler] Failed to execute SQL query [reqId=0, req=JdbcQueryExecuteRequest [schemaName=PUBLIC, pageSize=1024, maxRows=0, sqlQry=update t1 set b=b-1, args=Object[] [], stmtType=ANY_STATEMENT_TYPE, autoCommit=true]] class org.apache.ignite.internal.processors.query.IgniteSQLException: Cannot serialize transaction due to write conflict (transaction is marked for rollback) at org.apache.ignite.internal.processors.cache.GridCacheMapEntry.serializationError(GridCacheMapEntry.java:6712) at org.apache.ignite.internal.processors.cache.GridCacheMapEntry.access$700(GridCacheMapEntry.java:130) at org.apache.ignite.internal.processors.cache.GridCacheMapEntry$MvccUpdateLockListener.apply(GridCacheMapEntry.java:5416) at org.apache.ignite.internal.processors.cache.GridCacheMapEntry$MvccUpdateLockListener.apply(GridCacheMapEntry.java:5274) at org.apache.ignite.internal.util.future.GridFutureAdapter.notifyListener(GridFutureAdapter.java:385) at org.apache.ignite.internal.util.future.GridFutureAdapter.unblock(GridFutureAdapter.java:349) at org.apache.ignite.internal.util.future.GridFutureAdapter.unblockAll(GridFutureAdapter.java:337) at org.apache.ignite.internal.util.future.GridFutureAdapter.onDone(GridFutureAdapter.java:497) at org.apache.ignite.internal.util.future.GridFutureAdapter.onDone(GridFutureAdapter.java:476) at org.apache.ignite.internal.util.future.GridFutureAdapter.onDone(GridFutureAdapter.java:442) at org.apache.ignite.internal.processors.cache.mvcc.MvccProcessorImpl$LockFuture.run(MvccProcessorImpl.java:1960) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) [19:20:26,250][SEVERE][jdbc-request-handler-worker-#76][JdbcRequestHandler] Failed to execute SQL query [reqId=0, req=JdbcQueryExecuteRequest [schemaName=PUBLIC, pageSize=1024, maxRows=0, sqlQry=commit, args=Object[] [], stmtType=ANY_STATEMENT_TYPE, autoCommit=true]] class org.apache.ignite.internal.processors.query.IgniteSQLException: Failed to execute DDL statement [stmt=commit, err=Failed to finish transaction because it has been rolled back [timeout=0, tx=GridNearTxLocal[xid=b61ff90c661-00000000-0914-10f6-0000-000000000001, xidVersion=GridCacheVersion [topVer=152310006, order=1540829999467, nodeOrder=1], concurrency=PESSIMISTIC, isolation=REPEATABLE_READ, state=MARKED_ROLLBACK, invalidate=false, rollbackOnly=true, nodeId=c9ddebdb-c328-4283-97c5-a6634444887a, timeout=0, duration=22, label=null]]] at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.tryQueryDistributedSqlFieldsNative(IgniteH2Indexing.java:1988) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.querySqlFields(IgniteH2Indexing.java:2120) at org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:2141) at org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:2136) at org.apache.ignite.internal.util.lang.IgniteOutClosureX.apply(IgniteOutClosureX.java:36) at org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:2713) at org.apache.ignite.internal.processors.query.GridQueryProcessor.querySqlFields(GridQueryProcessor.java:2150) at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.executeQuery(JdbcRequestHandler.java:511) at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.doHandle(JdbcRequestHandler.java:245) at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandlerWorker.body(JdbcRequestHandlerWorker.java:90) at org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:120) at java.lang.Thread.run(Thread.java:748) Caused by: class org.apache.ignite.internal.transactions.IgniteTxRollbackCheckedException: Failed to finish transaction because it has been rolled back [timeout=0, tx=GridNearTxLocal[xid=b61ff90c661-00000000-0914-10f6-0000-000000000001, xidVersion=GridCacheVersion [topVer=152310006, order=1540829999467, nodeOrder=1], concurrency=PESSIMISTIC, isolation=REPEATABLE_READ, state=MARKED_ROLLBACK, invalidate=false, rollbackOnly=true, nodeId=c9ddebdb-c328-4283-97c5-a6634444887a, timeout=0, duration=22, label=null]] at org.apache.ignite.internal.processors.cache.transactions.IgniteTxAdapter.rollbackException(IgniteTxAdapter.java:763) at org.apache.ignite.internal.processors.cache.distributed.near.GridNearPessimisticTxPrepareFuture.prepare(GridNearPessimisticTxPrepareFuture.java:180) at org.apache.ignite.internal.processors.cache.distributed.near.GridNearTxLocal.prepareNearTxLocal(GridNearTxLocal.java:3734) at org.apache.ignite.internal.processors.cache.distributed.near.GridNearTxLocal.commitNearTxLocalAsync(GridNearTxLocal.java:3780) at org.apache.ignite.internal.processors.cache.distributed.near.GridNearTxLocal.commit(GridNearTxLocal.java:3761) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.doCommit(IgniteH2Indexing.java:2076) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.processTxCommand(IgniteH2Indexing.java:2055) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.tryQueryDistributedSqlFieldsNative(IgniteH2Indexing.java:1982) ... 11 more [19:20:26,275][SEVERE][jdbc-request-handler-worker-#60][JdbcRequestHandler] Failed to execute SQL query [reqId=0, req=JdbcQueryExecuteRequest [schemaName=PUBLIC, pageSize=1024, maxRows=0, sqlQry=update t1 set b=b+1, args=Object[] [], stmtType=ANY_STATEMENT_TYPE, autoCommit=true]] class org.apache.ignite.internal.processors.query.IgniteSQLException: Cannot serialize transaction due to write conflict (transaction is marked for rollback) at org.apache.ignite.internal.processors.cache.GridCacheMapEntry.serializationError(GridCacheMapEntry.java:6712) at org.apache.ignite.internal.processors.cache.GridCacheMapEntry.access$700(GridCacheMapEntry.java:130) at org.apache.ignite.internal.processors.cache.GridCacheMapEntry$MvccUpdateLockListener.apply(GridCacheMapEntry.java:5416) at org.apache.ignite.internal.processors.cache.GridCacheMapEntry$MvccUpdateLockListener.apply(GridCacheMapEntry.java:5274) at org.apache.ignite.internal.util.future.GridFutureAdapter.notifyListener(GridFutureAdapter.java:385) at org.apache.ignite.internal.util.future.GridFutureAdapter.unblock(GridFutureAdapter.java:349) at org.apache.ignite.internal.util.future.GridFutureAdapter.unblockAll(GridFutureAdapter.java:337) at org.apache.ignite.internal.util.future.GridFutureAdapter.onDone(GridFutureAdapter.java:497) at org.apache.ignite.internal.util.future.GridFutureAdapter.onDone(GridFutureAdapter.java:476) at org.apache.ignite.internal.util.future.GridFutureAdapter.onDone(GridFutureAdapter.java:442) at org.apache.ignite.internal.processors.cache.mvcc.MvccProcessorImpl$LockFuture.run(MvccProcessorImpl.java:1960) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) [19:20:26,279][SEVERE][jdbc-request-handler-worker-#60][JdbcRequestHandler] Failed to execute SQL query [reqId=0, req=JdbcQueryExecuteRequest [schemaName=PUBLIC, pageSize=1024, maxRows=0, sqlQry=commit, args=Object[] [], stmtType=ANY_STATEMENT_TYPE, autoCommit=true]] class org.apache.ignite.internal.processors.query.IgniteSQLException: Failed to execute DDL statement [stmt=commit, err=Failed to finish transaction because it has been rolled back [timeout=0, tx=GridNearTxLocal[xid=471ff90c661-00000000-0914-10f6-0000-000000000001, xidVersion=GridCacheVersion [topVer=152310006, order=1540829999476, nodeOrder=1], concurrency=PESSIMISTIC, isolation=REPEATABLE_READ, state=MARKED_ROLLBACK, invalidate=false, rollbackOnly=true, nodeId=c9ddebdb-c328-4283-97c5-a6634444887a, timeout=0, duration=22, label=null]]] at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.tryQueryDistributedSqlFieldsNative(IgniteH2Indexing.java:1988) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.querySqlFields(IgniteH2Indexing.java:2120) at org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:2141) at org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:2136) at org.apache.ignite.internal.util.lang.IgniteOutClosureX.apply(IgniteOutClosureX.java:36) at org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:2713) at org.apache.ignite.internal.processors.query.GridQueryProcessor.querySqlFields(GridQueryProcessor.java:2150) at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.executeQuery(JdbcRequestHandler.java:511) at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.doHandle(JdbcRequestHandler.java:245) at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandlerWorker.body(JdbcRequestHandlerWorker.java:90) at org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:120) at java.lang.Thread.run(Thread.java:748) Caused by: class org.apache.ignite.internal.transactions.IgniteTxRollbackCheckedException: Failed to finish transaction because it has been rolled back [timeout=0, tx=GridNearTxLocal[xid=471ff90c661-00000000-0914-10f6-0000-000000000001, xidVersion=GridCacheVersion [topVer=152310006, order=1540829999476, nodeOrder=1], concurrency=PESSIMISTIC, isolation=REPEATABLE_READ, state=MARKED_ROLLBACK, invalidate=false, rollbackOnly=true, nodeId=c9ddebdb-c328-4283-97c5-a6634444887a, timeout=0, duration=22, label=null]] at org.apache.ignite.internal.processors.cache.transactions.IgniteTxAdapter.rollbackException(IgniteTxAdapter.java:763) at org.apache.ignite.internal.processors.cache.distributed.near.GridNearPessimisticTxPrepareFuture.prepare(GridNearPessimisticTxPrepareFuture.java:180) at org.apache.ignite.internal.processors.cache.distributed.near.GridNearTxLocal.prepareNearTxLocal(GridNearTxLocal.java:3734) at org.apache.ignite.internal.processors.cache.distributed.near.GridNearTxLocal.commitNearTxLocalAsync(GridNearTxLocal.java:3780) at org.apache.ignite.internal.processors.cache.distributed.near.GridNearTxLocal.commit(GridNearTxLocal.java:3761) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.doCommit(IgniteH2Indexing.java:2076) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.processTxCommand(IgniteH2Indexing.java:2055) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.tryQueryDistributedSqlFieldsNative(IgniteH2Indexing.java:1982) ... 11 more [19:20:26,304][SEVERE][jdbc-request-handler-worker-#76][JdbcRequestHandler] Failed to execute SQL query [reqId=0, req=JdbcQueryExecuteRequest [schemaName=PUBLIC, pageSize=1024, maxRows=0, sqlQry=update t1 set b=b-1, args=Object[] [], stmtType=ANY_STATEMENT_TYPE, autoCommit=true]] class org.apache.ignite.internal.processors.query.IgniteSQLException: Cannot serialize transaction due to write conflict (transaction is marked for rollback) at org.apache.ignite.internal.processors.cache.GridCacheMapEntry.serializationError(GridCacheMapEntry.java:6712) at org.apache.ignite.internal.processors.cache.GridCacheMapEntry.access$700(GridCacheMapEntry.java:130) at org.apache.ignite.internal.processors.cache.GridCacheMapEntry$MvccUpdateLockListener.apply(GridCacheMapEntry.java:5416) at org.apache.ignite.internal.processors.cache.GridCacheMapEntry$MvccUpdateLockListener.apply(GridCacheMapEntry.java:5274) at org.apache.ignite.internal.util.future.GridFutureAdapter.notifyListener(GridFutureAdapter.java:385) at org.apache.ignite.internal.util.future.GridFutureAdapter.unblock(GridFutureAdapter.java:349) at org.apache.ignite.internal.util.future.GridFutureAdapter.unblockAll(GridFutureAdapter.java:337) at org.apache.ignite.internal.util.future.GridFutureAdapter.onDone(GridFutureAdapter.java:497) at org.apache.ignite.internal.util.future.GridFutureAdapter.onDone(GridFutureAdapter.java:476) at org.apache.ignite.internal.util.future.GridFutureAdapter.onDone(GridFutureAdapter.java:442) at org.apache.ignite.internal.processors.cache.mvcc.MvccProcessorImpl$LockFuture.run(MvccProcessorImpl.java:1960) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) [19:20:26,307][SEVERE][jdbc-request-handler-worker-#76][JdbcRequestHandler] Failed to execute SQL query [reqId=0, req=JdbcQueryExecuteRequest [schemaName=PUBLIC, pageSize=1024, maxRows=0, sqlQry=commit, args=Object[] [], stmtType=ANY_STATEMENT_TYPE, autoCommit=true]] class org.apache.ignite.internal.processors.query.IgniteSQLException: Failed to execute DDL statement [stmt=commit, err=Failed to finish transaction because it has been rolled back [timeout=0, tx=GridNearTxLocal[xid=d71ff90c661-00000000-0914-10f6-0000-000000000001, xidVersion=GridCacheVersion [topVer=152310006, order=1540829999485, nodeOrder=1], concurrency=PESSIMISTIC, isolation=REPEATABLE_READ, state=MARKED_ROLLBACK, invalidate=false, rollbackOnly=true, nodeId=c9ddebdb-c328-4283-97c5-a6634444887a, timeout=0, duration=11, label=null]]] at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.tryQueryDistributedSqlFieldsNative(IgniteH2Indexing.java:1988) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.querySqlFields(IgniteH2Indexing.java:2120) at org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:2141) at org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:2136) at org.apache.ignite.internal.util.lang.IgniteOutClosureX.apply(IgniteOutClosureX.java:36) at org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:2713) at org.apache.ignite.internal.processors.query.GridQueryProcessor.querySqlFields(GridQueryProcessor.java:2150) at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.executeQuery(JdbcRequestHandler.java:511) at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.doHandle(JdbcRequestHandler.java:245) at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandlerWorker.body(JdbcRequestHandlerWorker.java:90) at org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:120) at java.lang.Thread.run(Thread.java:748) Caused by: class org.apache.ignite.internal.transactions.IgniteTxRollbackCheckedException: Failed to finish transaction because it has been rolled back [timeout=0, tx=GridNearTxLocal[xid=d71ff90c661-00000000-0914-10f6-0000-000000000001, xidVersion=GridCacheVersion [topVer=152310006, order=1540829999485, nodeOrder=1], concurrency=PESSIMISTIC, isolation=REPEATABLE_READ, state=MARKED_ROLLBACK, invalidate=false, rollbackOnly=true, nodeId=c9ddebdb-c328-4283-97c5-a6634444887a, timeout=0, duration=11, label=null]] at org.apache.ignite.internal.processors.cache.transactions.IgniteTxAdapter.rollbackException(IgniteTxAdapter.java:763) at org.apache.ignite.internal.processors.cache.distributed.near.GridNearPessimisticTxPrepareFuture.prepare(GridNearPessimisticTxPrepareFuture.java:180) at org.apache.ignite.internal.processors.cache.distributed.near.GridNearTxLocal.prepareNearTxLocal(GridNearTxLocal.java:3734) at org.apache.ignite.internal.processors.cache.distributed.near.GridNearTxLocal.commitNearTxLocalAsync(GridNearTxLocal.java:3780) at org.apache.ignite.internal.processors.cache.distributed.near.GridNearTxLocal.commit(GridNearTxLocal.java:3761) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.doCommit(IgniteH2Indexing.java:2076) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.processTxCommand(IgniteH2Indexing.java:2055) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.tryQueryDistributedSqlFieldsNative(IgniteH2Indexing.java:1982) ... 11 more [19:20:26,315][SEVERE][jdbc-request-handler-worker-#76][JdbcRequestHandler] Failed to execute SQL query [reqId=0, req=JdbcQueryExecuteRequest [schemaName=PUBLIC, pageSize=1024, maxRows=0, sqlQry=update t1 set b=b-1, args=Object[] [], stmtType=ANY_STATEMENT_TYPE, autoCommit=true]] class org.apache.ignite.internal.processors.query.IgniteSQLException: Cannot serialize transaction due to write conflict (transaction is marked for rollback) at org.apache.ignite.internal.processors.cache.GridCacheMapEntry.serializationError(GridCacheMapEntry.java:6712) at org.apache.ignite.internal.processors.cache.GridCacheMapEntry.access$700(GridCacheMapEntry.java:130) at org.apache.ignite.internal.processors.cache.GridCacheMapEntry$MvccUpdateLockListener.apply(GridCacheMapEntry.java:5416) at org.apache.ignite.internal.processors.cache.GridCacheMapEntry$MvccUpdateLockListener.apply(GridCacheMapEntry.java:5274) at org.apache.ignite.internal.util.future.GridFutureAdapter.notifyListener(GridFutureAdapter.java:385) at org.apache.ignite.internal.util.future.GridFutureAdapter.unblock(GridFutureAdapter.java:349) at org.apache.ignite.internal.util.future.GridFutureAdapter.unblockAll(GridFutureAdapter.java:337) at org.apache.ignite.internal.util.future.GridFutureAdapter.onDone(GridFutureAdapter.java:497) at org.apache.ignite.internal.util.future.GridFutureAdapter.onDone(GridFutureAdapter.java:476) at org.apache.ignite.internal.util.future.GridFutureAdapter.onDone(GridFutureAdapter.java:442) at org.apache.ignite.internal.processors.cache.mvcc.MvccProcessorImpl$LockFuture.run(MvccProcessorImpl.java:1960) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) [19:20:26,323][SEVERE][jdbc-request-handler-worker-#76][JdbcRequestHandler] Failed to execute SQL query [reqId=0, req=JdbcQueryExecuteRequest [schemaName=PUBLIC, pageSize=1024, maxRows=0, sqlQry=commit, args=Object[] [], stmtType=ANY_STATEMENT_TYPE, autoCommit=true]] class org.apache.ignite.internal.processors.query.IgniteSQLException: Failed to execute DDL statement [stmt=commit, err=Failed to finish transaction because it has been rolled back [timeout=0, tx=GridNearTxLocal[xid=281ff90c661-00000000-0914-10f6-0000-000000000001, xidVersion=GridCacheVersion [topVer=152310006, order=1540829999490, nodeOrder=1], concurrency=PESSIMISTIC, isolation=REPEATABLE_READ, state=MARKED_ROLLBACK, invalidate=false, rollbackOnly=true, nodeId=c9ddebdb-c328-4283-97c5-a6634444887a, timeout=0, duration=22, label=null]]] at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.tryQueryDistributedSqlFieldsNative(IgniteH2Indexing.java:1988) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.querySqlFields(IgniteH2Indexing.java:2120) at org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:2141) at org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:2136) at org.apache.ignite.internal.util.lang.IgniteOutClosureX.apply(IgniteOutClosureX.java:36) at org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:2713) at org.apache.ignite.internal.processors.query.GridQueryProcessor.querySqlFields(GridQueryProcessor.java:2150) at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.executeQuery(JdbcRequestHandler.java:511) at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.doHandle(JdbcRequestHandler.java:245) at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandlerWorker.body(JdbcRequestHandlerWorker.java:90) at org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:120) at java.lang.Thread.run(Thread.java:748) Caused by: class org.apache.ignite.internal.transactions.IgniteTxRollbackCheckedException: Failed to finish transaction because it has been rolled back [timeout=0, tx=GridNearTxLocal[xid=281ff90c661-00000000-0914-10f6-0000-000000000001, xidVersion=GridCacheVersion [topVer=152310006, order=1540829999490, nodeOrder=1], concurrency=PESSIMISTIC, isolation=REPEATABLE_READ, state=MARKED_ROLLBACK, invalidate=false, rollbackOnly=true, nodeId=c9ddebdb-c328-4283-97c5-a6634444887a, timeout=0, duration=22, label=null]] at org.apache.ignite.internal.processors.cache.transactions.IgniteTxAdapter.rollbackException(IgniteTxAdapter.java:763) at org.apache.ignite.internal.processors.cache.distributed.near.GridNearPessimisticTxPrepareFuture.prepare(GridNearPessimisticTxPrepareFuture.java:180) at org.apache.ignite.internal.processors.cache.distributed.near.GridNearTxLocal.prepareNearTxLocal(GridNearTxLocal.java:3734) at org.apache.ignite.internal.processors.cache.distributed.near.GridNearTxLocal.commitNearTxLocalAsync(GridNearTxLocal.java:3780) at org.apache.ignite.internal.processors.cache.distributed.near.GridNearTxLocal.commit(GridNearTxLocal.java:3761) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.doCommit(IgniteH2Indexing.java:2076) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.processTxCommand(IgniteH2Indexing.java:2055) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.tryQueryDistributedSqlFieldsNative(IgniteH2Indexing.java:1982) ... 11 more [19:20:26,332][SEVERE][jdbc-request-handler-worker-#76][JdbcRequestHandler] Failed to execute SQL query [reqId=0, req=JdbcQueryExecuteRequest [schemaName=PUBLIC, pageSize=1024, maxRows=0, sqlQry=update t1 set b=b-1, args=Object[] [], stmtType=ANY_STATEMENT_TYPE, autoCommit=true]] class org.apache.ignite.internal.processors.query.IgniteSQLException: Cannot serialize transaction due to write conflict (transaction is marked for rollback) at org.apache.ignite.internal.processors.cache.GridCacheMapEntry.serializationError(GridCacheMapEntry.java:6712) at org.apache.ignite.internal.processors.cache.GridCacheMapEntry.access$700(GridCacheMapEntry.java:130) at org.apache.ignite.internal.processors.cache.GridCacheMapEntry$MvccUpdateLockListener.apply(GridCacheMapEntry.java:5416) at org.apache.ignite.internal.processors.cache.GridCacheMapEntry$MvccUpdateLockListener.apply(GridCacheMapEntry.java:5274) at org.apache.ignite.internal.util.future.GridFutureAdapter.notifyListener(GridFutureAdapter.java:385) at org.apache.ignite.internal.util.future.GridFutureAdapter.unblock(GridFutureAdapter.java:349) at org.apache.ignite.internal.util.future.GridFutureAdapter.unblockAll(GridFutureAdapter.java:337) at org.apache.ignite.internal.util.future.GridFutureAdapter.onDone(GridFutureAdapter.java:497) at org.apache.ignite.internal.util.future.GridFutureAdapter.onDone(GridFutureAdapter.java:476) at org.apache.ignite.internal.util.future.GridFutureAdapter.onDone(GridFutureAdapter.java:442) at org.apache.ignite.internal.processors.cache.mvcc.MvccProcessorImpl$LockFuture.run(MvccProcessorImpl.java:1960) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) [19:20:26,338][SEVERE][jdbc-request-handler-worker-#76][JdbcRequestHandler] Failed to execute SQL query [reqId=0, req=JdbcQueryExecuteRequest [schemaName=PUBLIC, pageSize=1024, maxRows=0, sqlQry=commit, args=Object[] [], stmtType=ANY_STATEMENT_TYPE, autoCommit=true]] class org.apache.ignite.internal.processors.query.IgniteSQLException: Failed to execute DDL statement [stmt=commit, err=Failed to finish transaction because it has been rolled back [timeout=0, tx=GridNearTxLocal[xid=781ff90c661-00000000-0914-10f6-0000-000000000001, xidVersion=GridCacheVersion [topVer=152310006, order=1540829999495, nodeOrder=1], concurrency=PESSIMISTIC, isolation=REPEATABLE_READ, state=MARKED_ROLLBACK, invalidate=false, rollbackOnly=true, nodeId=c9ddebdb-c328-4283-97c5-a6634444887a, timeout=0, duration=11, label=null]]] at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.tryQueryDistributedSqlFieldsNative(IgniteH2Indexing.java:1988) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.querySqlFields(IgniteH2Indexing.java:2120) at org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:2141) at org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:2136) at org.apache.ignite.internal.util.lang.IgniteOutClosureX.apply(IgniteOutClosureX.java:36) at org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:2713) at org.apache.ignite.internal.processors.query.GridQueryProcessor.querySqlFields(GridQueryProcessor.java:2150) at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.executeQuery(JdbcRequestHandler.java:511) at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.doHandle(JdbcRequestHandler.java:245) at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandlerWorker.body(JdbcRequestHandlerWorker.java:90) at org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:120) at java.lang.Thread.run(Thread.java:748) Caused by: class org.apache.ignite.internal.transactions.IgniteTxRollbackCheckedException: Failed to finish transaction because it has been rolled back [timeout=0, tx=GridNearTxLocal[xid=781ff90c661-00000000-0914-10f6-0000-000000000001, xidVersion=GridCacheVersion [topVer=152310006, order=1540829999495, nodeOrder=1], concurrency=PESSIMISTIC, isolation=REPEATABLE_READ, state=MARKED_ROLLBACK, invalidate=false, rollbackOnly=true, nodeId=c9ddebdb-c328-4283-97c5-a6634444887a, timeout=0, duration=11, label=null]] at org.apache.ignite.internal.processors.cache.transactions.IgniteTxAdapter.rollbackException(IgniteTxAdapter.java:763) at org.apache.ignite.internal.processors.cache.distributed.near.GridNearPessimisticTxPrepareFuture.prepare(GridNearPessimisticTxPrepareFuture.java:180) at org.apache.ignite.internal.processors.cache.distributed.near.GridNearTxLocal.prepareNearTxLocal(GridNearTxLocal.java:3734) at org.apache.ignite.internal.processors.cache.distributed.near.GridNearTxLocal.commitNearTxLocalAsync(GridNearTxLocal.java:3780) at org.apache.ignite.internal.processors.cache.distributed.near.GridNearTxLocal.commit(GridNearTxLocal.java:3761) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.doCommit(IgniteH2Indexing.java:2076) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.processTxCommand(IgniteH2Indexing.java:2055) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.tryQueryDistributedSqlFieldsNative(IgniteH2Indexing.java:1982) ... 11 more [19:20:26,350][SEVERE][jdbc-request-handler-worker-#76][JdbcRequestHandler] Failed to execute SQL query [reqId=0, req=JdbcQueryExecuteRequest [schemaName=PUBLIC, pageSize=1024, maxRows=0, sqlQry=update t1 set b=b-1, args=Object[] [], stmtType=ANY_STATEMENT_TYPE, autoCommit=true]] class org.apache.ignite.internal.processors.query.IgniteSQLException: Cannot serialize transaction due to write conflict (transaction is marked for rollback) at org.apache.ignite.internal.processors.cache.GridCacheMapEntry.serializationError(GridCacheMapEntry.java:6712) at org.apache.ignite.internal.processors.cache.GridCacheMapEntry.access$700(GridCacheMapEntry.java:130) at org.apache.ignite.internal.processors.cache.GridCacheMapEntry$MvccUpdateLockListener.apply(GridCacheMapEntry.java:5416) at org.apache.ignite.internal.processors.cache.GridCacheMapEntry$MvccUpdateLockListener.apply(GridCacheMapEntry.java:5274) at org.apache.ignite.internal.util.future.GridFutureAdapter.notifyListener(GridFutureAdapter.java:385) at org.apache.ignite.internal.util.future.GridFutureAdapter.unblock(GridFutureAdapter.java:349) at org.apache.ignite.internal.util.future.GridFutureAdapter.unblockAll(GridFutureAdapter.java:337) at org.apache.ignite.internal.util.future.GridFutureAdapter.onDone(GridFutureAdapter.java:497) at org.apache.ignite.internal.util.future.GridFutureAdapter.onDone(GridFutureAdapter.java:476) at org.apache.ignite.internal.util.future.GridFutureAdapter.onDone(GridFutureAdapter.java:442) at org.apache.ignite.internal.processors.cache.mvcc.MvccProcessorImpl$LockFuture.run(MvccProcessorImpl.java:1960) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) [19:20:26,355][SEVERE][jdbc-request-handler-worker-#76][JdbcRequestHandler] Failed to execute SQL query [reqId=0, req=JdbcQueryExecuteRequest [schemaName=PUBLIC, pageSize=1024, maxRows=0, sqlQry=commit, args=Object[] [], stmtType=ANY_STATEMENT_TYPE, autoCommit=true]] class org.apache.ignite.internal.processors.query.IgniteSQLException: Failed to execute DDL statement [stmt=commit, err=Failed to finish transaction because it has been rolled back [timeout=0, tx=GridNearTxLocal[xid=c81ff90c661-00000000-0914-10f6-0000-000000000001, xidVersion=GridCacheVersion [topVer=152310006, order=1540829999500, nodeOrder=1], concurrency=PESSIMISTIC, isolation=REPEATABLE_READ, state=MARKED_ROLLBACK, invalidate=false, rollbackOnly=true, nodeId=c9ddebdb-c328-4283-97c5-a6634444887a, timeout=0, duration=22, label=null]]] at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.tryQueryDistributedSqlFieldsNative(IgniteH2Indexing.java:1988) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.querySqlFields(IgniteH2Indexing.java:2120) at org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:2141) at org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:2136) at org.apache.ignite.internal.util.lang.IgniteOutClosureX.apply(IgniteOutClosureX.java:36) at org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:2713) at org.apache.ignite.internal.processors.query.GridQueryProcessor.querySqlFields(GridQueryProcessor.java:2150) at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.executeQuery(JdbcRequestHandler.java:511) at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.doHandle(JdbcRequestHandler.java:245) at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandlerWorker.body(JdbcRequestHandlerWorker.java:90) at org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:120) at java.lang.Thread.run(Thread.java:748) Caused by: class org.apache.ignite.internal.transactions.IgniteTxRollbackCheckedException: Failed to finish transaction because it has been rolled back [timeout=0, tx=GridNearTxLocal[xid=c81ff90c661-00000000-0914-10f6-0000-000000000001, xidVersion=GridCacheVersion [topVer=152310006, order=1540829999500, nodeOrder=1], concurrency=PESSIMISTIC, isolation=REPEATABLE_READ, state=MARKED_ROLLBACK, invalidate=false, rollbackOnly=true, nodeId=c9ddebdb-c328-4283-97c5-a6634444887a, timeout=0, duration=22, label=null]] at org.apache.ignite.internal.processors.cache.transactions.IgniteTxAdapter.rollbackException(IgniteTxAdapter.java:763) at org.apache.ignite.internal.processors.cache.distributed.near.GridNearPessimisticTxPrepareFuture.prepare(GridNearPessimisticTxPrepareFuture.java:180) at org.apache.ignite.internal.processors.cache.distributed.near.GridNearTxLocal.prepareNearTxLocal(GridNearTxLocal.java:3734) at org.apache.ignite.internal.processors.cache.distributed.near.GridNearTxLocal.commitNearTxLocalAsync(GridNearTxLocal.java:3780) at org.apache.ignite.internal.processors.cache.distributed.near.GridNearTxLocal.commit(GridNearTxLocal.java:3761) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.doCommit(IgniteH2Indexing.java:2076) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.processTxCommand(IgniteH2Indexing.java:2055) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.tryQueryDistributedSqlFieldsNative(IgniteH2Indexing.java:1982) ... 11 more [19:20:26,367][SEVERE][jdbc-request-handler-worker-#76][JdbcRequestHandler] Failed to execute SQL query [reqId=0, req=JdbcQueryExecuteRequest [schemaName=PUBLIC, pageSize=1024, maxRows=0, sqlQry=update t1 set b=b-1, args=Object[] [], stmtType=ANY_STATEMENT_TYPE, autoCommit=true]] class org.apache.ignite.internal.processors.query.IgniteSQLException: Cannot serialize transaction due to write conflict (transaction is marked for rollback) at org.apache.ignite.internal.processors.cache.GridCacheMapEntry.serializationError(GridCacheMapEntry.java:6712) at org.apache.ignite.internal.processors.cache.GridCacheMapEntry.access$700(GridCacheMapEntry.java:130) at org.apache.ignite.internal.processors.cache.GridCacheMapEntry$MvccUpdateLockListener.apply(GridCacheMapEntry.java:5416) at org.apache.ignite.internal.processors.cache.GridCacheMapEntry$MvccUpdateLockListener.apply(GridCacheMapEntry.java:5274) at org.apache.ignite.internal.util.future.GridFutureAdapter.notifyListener(GridFutureAdapter.java:385) at org.apache.ignite.internal.util.future.GridFutureAdapter.unblock(GridFutureAdapter.java:349) at org.apache.ignite.internal.util.future.GridFutureAdapter.unblockAll(GridFutureAdapter.java:337) at org.apache.ignite.internal.util.future.GridFutureAdapter.onDone(GridFutureAdapter.java:497) at org.apache.ignite.internal.util.future.GridFutureAdapter.onDone(GridFutureAdapter.java:476) at org.apache.ignite.internal.util.future.GridFutureAdapter.onDone(GridFutureAdapter.java:442) at org.apache.ignite.internal.processors.cache.mvcc.MvccProcessorImpl$LockFuture.run(MvccProcessorImpl.java:1960) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) [19:20:26,375][SEVERE][jdbc-request-handler-worker-#76][JdbcRequestHandler] Failed to execute SQL query [reqId=0, req=JdbcQueryExecuteRequest [schemaName=PUBLIC, pageSize=1024, maxRows=0, sqlQry=commit, args=Object[] [], stmtType=ANY_STATEMENT_TYPE, autoCommit=true]] class org.apache.ignite.internal.processors.query.IgniteSQLException: Failed to execute DDL statement [stmt=commit, err=Failed to finish transaction because it has been rolled back [timeout=0, tx=GridNearTxLocal[xid=191ff90c661-00000000-0914-10f6-0000-000000000001, xidVersion=GridCacheVersion [topVer=152310006, order=1540829999505, nodeOrder=1], concurrency=PESSIMISTIC, isolation=REPEATABLE_READ, state=MARKED_ROLLBACK, invalidate=false, rollbackOnly=true, nodeId=c9ddebdb-c328-4283-97c5-a6634444887a, timeout=0, duration=11, label=null]]] at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.tryQueryDistributedSqlFieldsNative(IgniteH2Indexing.java:1988) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.querySqlFields(IgniteH2Indexing.java:2120) at org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:2141) at org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:2136) at org.apache.ignite.internal.util.lang.IgniteOutClosureX.apply(IgniteOutClosureX.java:36) at org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:2713) at org.apache.ignite.internal.processors.query.GridQueryProcessor.querySqlFields(GridQueryProcessor.java:2150) at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.executeQuery(JdbcRequestHandler.java:511) at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.doHandle(JdbcRequestHandler.java:245) at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandlerWorker.body(JdbcRequestHandlerWorker.java:90) at org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:120) at java.lang.Thread.run(Thread.java:748) Caused by: class org.apache.ignite.internal.transactions.IgniteTxRollbackCheckedException: Failed to finish transaction because it has been rolled back [timeout=0, tx=GridNearTxLocal[xid=191ff90c661-00000000-0914-10f6-0000-000000000001, xidVersion=GridCacheVersion [topVer=152310006, order=1540829999505, nodeOrder=1], concurrency=PESSIMISTIC, isolation=REPEATABLE_READ, state=MARKED_ROLLBACK, invalidate=false, rollbackOnly=true, nodeId=c9ddebdb-c328-4283-97c5-a6634444887a, timeout=0, duration=11, label=null]] at org.apache.ignite.internal.processors.cache.transactions.IgniteTxAdapter.rollbackException(IgniteTxAdapter.java:763) at org.apache.ignite.internal.processors.cache.distributed.near.GridNearPessimisticTxPrepareFuture.prepare(GridNearPessimisticTxPrepareFuture.java:180) at org.apache.ignite.internal.processors.cache.distributed.near.GridNearTxLocal.prepareNearTxLocal(GridNearTxLocal.java:3734) at org.apache.ignite.internal.processors.cache.distributed.near.GridNearTxLocal.commitNearTxLocalAsync(GridNearTxLocal.java:3780) at org.apache.ignite.internal.processors.cache.distributed.near.GridNearTxLocal.commit(GridNearTxLocal.java:3761) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.doCommit(IgniteH2Indexing.java:2076) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.processTxCommand(IgniteH2Indexing.java:2055) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.tryQueryDistributedSqlFieldsNative(IgniteH2Indexing.java:1982) ... 11 more [19:20:26,393][SEVERE][jdbc-request-handler-worker-#60][JdbcRequestHandler] Failed to execute SQL query [reqId=0, req=JdbcQueryExecuteRequest [schemaName=PUBLIC, pageSize=1024, maxRows=0, sqlQry=update t1 set b=b+1, args=Object[] [], stmtType=ANY_STATEMENT_TYPE, autoCommit=true]] class org.apache.ignite.internal.processors.query.IgniteSQLException: Cannot serialize transaction due to write conflict (transaction is marked for rollback) at org.apache.ignite.internal.processors.cache.GridCacheMapEntry.serializationError(GridCacheMapEntry.java:6712) at org.apache.ignite.internal.processors.cache.GridCacheMapEntry.access$700(GridCacheMapEntry.java:130) at org.apache.ignite.internal.processors.cache.GridCacheMapEntry$MvccUpdateLockListener.apply(GridCacheMapEntry.java:5416) at org.apache.ignite.internal.processors.cache.GridCacheMapEntry$MvccUpdateLockListener.apply(GridCacheMapEntry.java:5274) at org.apache.ignite.internal.util.future.GridFutureAdapter.notifyListener(GridFutureAdapter.java:385) at org.apache.ignite.internal.util.future.GridFutureAdapter.unblock(GridFutureAdapter.java:349) at org.apache.ignite.internal.util.future.GridFutureAdapter.unblockAll(GridFutureAdapter.java:337) at org.apache.ignite.internal.util.future.GridFutureAdapter.onDone(GridFutureAdapter.java:497) at org.apache.ignite.internal.util.future.GridFutureAdapter.onDone(GridFutureAdapter.java:476) at org.apache.ignite.internal.util.future.GridFutureAdapter.onDone(GridFutureAdapter.java:442) at org.apache.ignite.internal.processors.cache.mvcc.MvccProcessorImpl$LockFuture.run(MvccProcessorImpl.java:1960) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) [19:20:26,400][SEVERE][jdbc-request-handler-worker-#60][JdbcRequestHandler] Failed to execute SQL query [reqId=0, req=JdbcQueryExecuteRequest [schemaName=PUBLIC, pageSize=1024, maxRows=0, sqlQry=commit, args=Object[] [], stmtType=ANY_STATEMENT_TYPE, autoCommit=true]] class org.apache.ignite.internal.processors.query.IgniteSQLException: Failed to execute DDL statement [stmt=commit, err=Failed to finish transaction because it has been rolled back [timeout=0, tx=GridNearTxLocal[xid=a91ff90c661-00000000-0914-10f6-0000-000000000001, xidVersion=GridCacheVersion [topVer=152310006, order=1540829999514, nodeOrder=1], concurrency=PESSIMISTIC, isolation=REPEATABLE_READ, state=MARKED_ROLLBACK, invalidate=false, rollbackOnly=true, nodeId=c9ddebdb-c328-4283-97c5-a6634444887a, timeout=0, duration=11, label=null]]] at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.tryQueryDistributedSqlFieldsNative(IgniteH2Indexing.java:1988) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.querySqlFields(IgniteH2Indexing.java:2120) at org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:2141) at org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:2136) at org.apache.ignite.internal.util.lang.IgniteOutClosureX.apply(IgniteOutClosureX.java:36) at org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:2713) at org.apache.ignite.internal.processors.query.GridQueryProcessor.querySqlFields(GridQueryProcessor.java:2150) at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.executeQuery(JdbcRequestHandler.java:511) at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.doHandle(JdbcRequestHandler.java:245) at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandlerWorker.body(JdbcRequestHandlerWorker.java:90) at org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:120) at java.lang.Thread.run(Thread.java:748) Caused by: class org.apache.ignite.internal.transactions.IgniteTxRollbackCheckedException: Failed to finish transaction because it has been rolled back [timeout=0, tx=GridNearTxLocal[xid=a91ff90c661-00000000-0914-10f6-0000-000000000001, xidVersion=GridCacheVersion [topVer=152310006, order=1540829999514, nodeOrder=1], concurrency=PESSIMISTIC, isolation=REPEATABLE_READ, state=MARKED_ROLLBACK, invalidate=false, rollbackOnly=true, nodeId=c9ddebdb-c328-4283-97c5-a6634444887a, timeout=0, duration=11, label=null]] at org.apache.ignite.internal.processors.cache.transactions.IgniteTxAdapter.rollbackException(IgniteTxAdapter.java:763) at org.apache.ignite.internal.processors.cache.distributed.near.GridNearPessimisticTxPrepareFuture.prepare(GridNearPessimisticTxPrepareFuture.java:180) at org.apache.ignite.internal.processors.cache.distributed.near.GridNearTxLocal.prepareNearTxLocal(GridNearTxLocal.java:3734) at org.apache.ignite.internal.processors.cache.distributed.near.GridNearTxLocal.commitNearTxLocalAsync(GridNearTxLocal.java:3780) at org.apache.ignite.internal.processors.cache.distributed.near.GridNearTxLocal.commit(GridNearTxLocal.java:3761) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.doCommit(IgniteH2Indexing.java:2076) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.processTxCommand(IgniteH2Indexing.java:2055) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.tryQueryDistributedSqlFieldsNative(IgniteH2Indexing.java:1982) ... 11 more [19:20:26,410][SEVERE][jdbc-request-handler-worker-#60][JdbcRequestHandler] Failed to execute SQL query [reqId=0, req=JdbcQueryExecuteRequest [schemaName=PUBLIC, pageSize=1024, maxRows=0, sqlQry=update t1 set b=b+1, args=Object[] [], stmtType=ANY_STATEMENT_TYPE, autoCommit=true]] class org.apache.ignite.internal.processors.query.IgniteSQLException: Cannot serialize transaction due to write conflict (transaction is marked for rollback) at org.apache.ignite.internal.processors.cache.GridCacheMapEntry.serializationError(GridCacheMapEntry.java:6712) at org.apache.ignite.internal.processors.cache.GridCacheMapEntry.access$700(GridCacheMapEntry.java:130) at org.apache.ignite.internal.processors.cache.GridCacheMapEntry$MvccUpdateLockListener.apply(GridCacheMapEntry.java:5416) at org.apache.ignite.internal.processors.cache.GridCacheMapEntry$MvccUpdateLockListener.apply(GridCacheMapEntry.java:5274) at org.apache.ignite.internal.util.future.GridFutureAdapter.notifyListener(GridFutureAdapter.java:385) at org.apache.ignite.internal.util.future.GridFutureAdapter.unblock(GridFutureAdapter.java:349) at org.apache.ignite.internal.util.future.GridFutureAdapter.unblockAll(GridFutureAdapter.java:337) at org.apache.ignite.internal.util.future.GridFutureAdapter.onDone(GridFutureAdapter.java:497) at org.apache.ignite.internal.util.future.GridFutureAdapter.onDone(GridFutureAdapter.java:476) at org.apache.ignite.internal.util.future.GridFutureAdapter.onDone(GridFutureAdapter.java:442) at org.apache.ignite.internal.processors.cache.mvcc.MvccProcessorImpl$LockFuture.run(MvccProcessorImpl.java:1960) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) [19:20:26,419][SEVERE][jdbc-request-handler-worker-#60][JdbcRequestHandler] Failed to execute SQL query [reqId=0, req=JdbcQueryExecuteRequest [schemaName=PUBLIC, pageSize=1024, maxRows=0, sqlQry=commit, args=Object[] [], stmtType=ANY_STATEMENT_TYPE, autoCommit=true]] class org.apache.ignite.internal.processors.query.IgniteSQLException: Failed to execute DDL statement [stmt=commit, err=Failed to finish transaction because it has been rolled back [timeout=0, tx=GridNearTxLocal[xid=f91ff90c661-00000000-0914-10f6-0000-000000000001, xidVersion=GridCacheVersion [topVer=152310006, order=1540829999519, nodeOrder=1], concurrency=PESSIMISTIC, isolation=REPEATABLE_READ, state=MARKED_ROLLBACK, invalidate=false, rollbackOnly=true, nodeId=c9ddebdb-c328-4283-97c5-a6634444887a, timeout=0, duration=11, label=null]]] at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.tryQueryDistributedSqlFieldsNative(IgniteH2Indexing.java:1988) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.querySqlFields(IgniteH2Indexing.java:2120) at org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:2141) at org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:2136) at org.apache.ignite.internal.util.lang.IgniteOutClosureX.apply(IgniteOutClosureX.java:36) at org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:2713) at org.apache.ignite.internal.processors.query.GridQueryProcessor.querySqlFields(GridQueryProcessor.java:2150) at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.executeQuery(JdbcRequestHandler.java:511) at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.doHandle(JdbcRequestHandler.java:245) at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandlerWorker.body(JdbcRequestHandlerWorker.java:90) at org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:120) at java.lang.Thread.run(Thread.java:748) Caused by: class org.apache.ignite.internal.transactions.IgniteTxRollbackCheckedException: Failed to finish transaction because it has been rolled back [timeout=0, tx=GridNearTxLocal[xid=f91ff90c661-00000000-0914-10f6-0000-000000000001, xidVersion=GridCacheVersion [topVer=152310006, order=1540829999519, nodeOrder=1], concurrency=PESSIMISTIC, isolation=REPEATABLE_READ, state=MARKED_ROLLBACK, invalidate=false, rollbackOnly=true, nodeId=c9ddebdb-c328-4283-97c5-a6634444887a, timeout=0, duration=11, label=null]] at org.apache.ignite.internal.processors.cache.transactions.IgniteTxAdapter.rollbackException(IgniteTxAdapter.java:763) at org.apache.ignite.internal.processors.cache.distributed.near.GridNearPessimisticTxPrepareFuture.prepare(GridNearPessimisticTxPrepareFuture.java:180) at org.apache.ignite.internal.processors.cache.distributed.near.GridNearTxLocal.prepareNearTxLocal(GridNearTxLocal.java:3734) at org.apache.ignite.internal.processors.cache.distributed.near.GridNearTxLocal.commitNearTxLocalAsync(GridNearTxLocal.java:3780) at org.apache.ignite.internal.processors.cache.distributed.near.GridNearTxLocal.commit(GridNearTxLocal.java:3761) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.doCommit(IgniteH2Indexing.java:2076) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.processTxCommand(IgniteH2Indexing.java:2055) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.tryQueryDistributedSqlFieldsNative(IgniteH2Indexing.java:1982) ... 11 more [19:20:26,799][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=2e9eade2-3897-4061-96af-d5eb7c9e73cf, startPtr=FileWALPointer [idx=0, fileOff=3115129, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=4ms, walCpRecordFsyncDuration=4ms, pages=72, reason='timeout'] [19:20:26,818][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=2e9eade2-3897-4061-96af-d5eb7c9e73cf, pages=72, markPos=FileWALPointer [idx=0, fileOff=3115129, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=20ms, pagesWrite=2ms, fsync=17ms, total=39ms] [19:20:27,824][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=55b3fe14-693b-4fa6-95a6-f7c61b52adea, startPtr=FileWALPointer [idx=0, fileOff=3190134, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=8ms, walCpRecordFsyncDuration=7ms, pages=11, reason='timeout'] [19:20:27,842][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=55b3fe14-693b-4fa6-95a6-f7c61b52adea, pages=11, markPos=FileWALPointer [idx=0, fileOff=3190134, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=40ms, pagesWrite=0ms, fsync=17ms, total=57ms] [19:20:28,799][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Skipping checkpoint (no pages were modified) [checkpointLockWait=0ms, checkpointLockHoldTime=8ms, reason='timeout'] [19:20:29,796][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Skipping checkpoint (no pages were modified) [checkpointLockWait=0ms, checkpointLockHoldTime=5ms, reason='timeout'] [19:20:32,817][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=b44abf13-fe6a-4884-912f-edf427749487, startPtr=FileWALPointer [idx=0, fileOff=3252833, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=4ms, walCpRecordFsyncDuration=4ms, pages=10, reason='timeout'] [19:20:32,838][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=b44abf13-fe6a-4884-912f-edf427749487, pages=10, markPos=FileWALPointer [idx=0, fileOff=3252833, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=19ms, pagesWrite=0ms, fsync=20ms, total=39ms] [19:20:35,821][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Skipping checkpoint (no pages were modified) [checkpointLockWait=0ms, checkpointLockHoldTime=6ms, reason='timeout'] [19:20:37,862][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=4375351d-f1ee-44eb-b637-ed5dd438e59d, startPtr=FileWALPointer [idx=0, fileOff=3315532, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=6ms, walCpRecordFsyncDuration=5ms, pages=10, reason='timeout'] [19:20:37,897][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=4375351d-f1ee-44eb-b637-ed5dd438e59d, pages=10, markPos=FileWALPointer [idx=0, fileOff=3315532, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=35ms, pagesWrite=1ms, fsync=33ms, total=69ms] [19:20:42,886][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=28f729f9-b55a-4830-a263-1fa59f57f8c0, startPtr=FileWALPointer [idx=0, fileOff=3378231, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=6ms, walCpRecordFsyncDuration=5ms, pages=10, reason='timeout'] [19:20:42,917][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=28f729f9-b55a-4830-a263-1fa59f57f8c0, pages=10, markPos=FileWALPointer [idx=0, fileOff=3378231, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=36ms, pagesWrite=2ms, fsync=28ms, total=66ms] [19:20:47,900][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=f23d0c61-1438-4d9a-aeeb-08af791a4f3c, startPtr=FileWALPointer [idx=0, fileOff=3440930, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=6ms, walCpRecordFsyncDuration=5ms, pages=10, reason='timeout'] [19:20:47,930][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=f23d0c61-1438-4d9a-aeeb-08af791a4f3c, pages=10, markPos=FileWALPointer [idx=0, fileOff=3440930, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=35ms, pagesWrite=1ms, fsync=28ms, total=64ms] [19:20:52,916][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=3d0b31e7-20a5-43b5-9b4e-efb28dc0bd5d, startPtr=FileWALPointer [idx=0, fileOff=3503629, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=5ms, walCpRecordFsyncDuration=5ms, pages=10, reason='timeout'] [19:20:52,957][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=3d0b31e7-20a5-43b5-9b4e-efb28dc0bd5d, pages=10, markPos=FileWALPointer [idx=0, fileOff=3503629, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=34ms, pagesWrite=1ms, fsync=39ms, total=74ms] [19:20:54,900][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Skipping checkpoint (no pages were modified) [checkpointLockWait=0ms, checkpointLockHoldTime=1ms, reason='timeout'] [19:20:57,958][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=360e1810-d9a7-4835-ae7f-ee156cf54650, startPtr=FileWALPointer [idx=0, fileOff=3566328, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=5ms, walCpRecordFsyncDuration=6ms, pages=10, reason='timeout'] [19:20:57,983][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=360e1810-d9a7-4835-ae7f-ee156cf54650, pages=10, markPos=FileWALPointer [idx=0, fileOff=3566328, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=39ms, pagesWrite=1ms, fsync=24ms, total=64ms] [19:21:02,985][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=92fc938e-957b-42f1-bb1b-5061cf46b102, startPtr=FileWALPointer [idx=0, fileOff=3629027, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=6ms, walCpRecordFsyncDuration=7ms, pages=10, reason='timeout'] [19:21:03,010][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=92fc938e-957b-42f1-bb1b-5061cf46b102, pages=10, markPos=FileWALPointer [idx=0, fileOff=3629027, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=38ms, pagesWrite=1ms, fsync=23ms, total=62ms] [19:21:03,955][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Skipping checkpoint (no pages were modified) [checkpointLockWait=0ms, checkpointLockHoldTime=7ms, reason='timeout'] [19:21:04,866][INFO][grid-timeout-worker-#23][IgniteKernal] Metrics for local node (to disable set 'metricsLogFrequency' to 0) ^-- Node [id=c9ddebdb, uptime=00:01:00.005] ^-- H/N/C [hosts=1, nodes=2, CPUs=8] ^-- CPU [cur=0,77%, avg=3,46%, GC=0%] ^-- PageMemory [pages=166] ^-- Heap [used=155MB, free=84,11%, comm=981MB] ^-- Off-heap [used=0MB, free=99,92%, comm=800MB] ^-- dataRegion1 region [used=0MB, free=100%, comm=200MB] ^-- sysMemPlc region [used=0MB, free=99,98%, comm=100MB] ^-- default region [used=0MB, free=99,73%, comm=200MB] ^-- metastoreMemPlc region [used=0MB, free=99,93%, comm=100MB] ^-- dataRegion2 region [used=0MB, free=100%, comm=100MB] ^-- TxLog region [used=0MB, free=99,98%, comm=100MB] ^-- Ignite persistence [used=0MB] ^-- dataRegion1 region [used=0MB] ^-- sysMemPlc region [used=0MB] ^-- default region [used=0MB] ^-- metastoreMemPlc region [used=unknown] ^-- dataRegion2 region [used=0MB] ^-- TxLog region [used=0MB] ^-- Outbound messages queue [size=0] ^-- Public thread pool [active=0, idle=1, qSize=0] ^-- System thread pool [active=0, idle=8, qSize=0] [19:21:07,987][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=308b9251-9c48-4ed3-b22b-ee9abb7d062d, startPtr=FileWALPointer [idx=0, fileOff=3691726, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=5ms, pages=10, reason='timeout'] [19:21:08,010][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=308b9251-9c48-4ed3-b22b-ee9abb7d062d, pages=10, markPos=FileWALPointer [idx=0, fileOff=3691726, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=21ms, pagesWrite=1ms, fsync=22ms, total=44ms] [19:21:09,973][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Skipping checkpoint (no pages were modified) [checkpointLockWait=0ms, checkpointLockHoldTime=2ms, reason='timeout'] [19:21:13,022][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=53b92644-7770-4a78-ae5f-8744c74ed44a, startPtr=FileWALPointer [idx=0, fileOff=3754425, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=4ms, walCpRecordFsyncDuration=6ms, pages=10, reason='timeout'] [19:21:13,049][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=53b92644-7770-4a78-ae5f-8744c74ed44a, pages=10, markPos=FileWALPointer [idx=0, fileOff=3754425, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=34ms, pagesWrite=1ms, fsync=24ms, total=59ms] [19:21:18,019][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=fdb85481-83cd-4956-8e5b-e3984bced894, startPtr=FileWALPointer [idx=0, fileOff=3817124, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=0ms, walCpRecordFsyncDuration=3ms, pages=10, reason='timeout'] [19:21:18,031][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=fdb85481-83cd-4956-8e5b-e3984bced894, pages=10, markPos=FileWALPointer [idx=0, fileOff=3817124, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=10ms, pagesWrite=0ms, fsync=12ms, total=22ms] [19:21:23,057][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=117c2c26-0854-43a7-817b-111b8e7bc35b, startPtr=FileWALPointer [idx=0, fileOff=3879823, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=3ms, walCpRecordFsyncDuration=6ms, pages=10, reason='timeout'] [19:21:23,091][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=117c2c26-0854-43a7-817b-111b8e7bc35b, pages=10, markPos=FileWALPointer [idx=0, fileOff=3879823, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=33ms, pagesWrite=2ms, fsync=32ms, total=67ms] [19:21:28,071][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=125fb9ac-6f98-4b08-8a62-8e2a12ce2d81, startPtr=FileWALPointer [idx=0, fileOff=3942522, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=3ms, walCpRecordFsyncDuration=6ms, pages=10, reason='timeout'] [19:21:28,100][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=125fb9ac-6f98-4b08-8a62-8e2a12ce2d81, pages=10, markPos=FileWALPointer [idx=0, fileOff=3942522, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=32ms, pagesWrite=1ms, fsync=28ms, total=61ms] [19:21:33,102][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=8987a77e-8df9-4e9a-9e0e-7b9b8c9f7a9d, startPtr=FileWALPointer [idx=0, fileOff=4005221, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=3ms, walCpRecordFsyncDuration=6ms, pages=10, reason='timeout'] [19:21:33,136][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=8987a77e-8df9-4e9a-9e0e-7b9b8c9f7a9d, pages=10, markPos=FileWALPointer [idx=0, fileOff=4005221, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=33ms, pagesWrite=1ms, fsync=31ms, total=65ms] [19:21:38,117][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=b046d80e-b334-4d7f-9a7c-697e396af401, startPtr=FileWALPointer [idx=0, fileOff=4067920, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=5ms, pages=10, reason='timeout'] [19:21:38,151][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=b046d80e-b334-4d7f-9a7c-697e396af401, pages=10, markPos=FileWALPointer [idx=0, fileOff=4067920, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=30ms, pagesWrite=1ms, fsync=33ms, total=64ms] [19:21:43,122][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=3c44bf86-4e60-4cca-825f-94cbfe823754, startPtr=FileWALPointer [idx=0, fileOff=4130619, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=1ms, walCpRecordFsyncDuration=3ms, pages=10, reason='timeout'] [19:21:43,147][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=3c44bf86-4e60-4cca-825f-94cbfe823754, pages=10, markPos=FileWALPointer [idx=0, fileOff=4130619, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=20ms, pagesWrite=1ms, fsync=24ms, total=45ms] [19:21:48,153][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=6e733d9f-afff-4a11-84f9-663d532c620d, startPtr=FileWALPointer [idx=0, fileOff=4193318, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=6ms, pages=10, reason='timeout'] [19:21:48,192][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=6e733d9f-afff-4a11-84f9-663d532c620d, pages=10, markPos=FileWALPointer [idx=0, fileOff=4193318, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=32ms, pagesWrite=1ms, fsync=38ms, total=71ms] [19:21:53,151][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=8aee55ff-4cb9-4140-913d-287b41136be4, startPtr=FileWALPointer [idx=0, fileOff=4256017, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=6ms, pages=10, reason='timeout'] [19:21:53,164][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=8aee55ff-4cb9-4140-913d-287b41136be4, pages=10, markPos=FileWALPointer [idx=0, fileOff=4256017, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=15ms, pagesWrite=0ms, fsync=13ms, total=28ms] [19:21:58,202][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=22ead6c9-cfc8-4ce8-a5c9-21c2b3f0b319, startPtr=FileWALPointer [idx=0, fileOff=4318716, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=5ms, pages=10, reason='timeout'] [19:21:58,228][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=22ead6c9-cfc8-4ce8-a5c9-21c2b3f0b319, pages=10, markPos=FileWALPointer [idx=0, fileOff=4318716, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=33ms, pagesWrite=1ms, fsync=24ms, total=58ms] [19:22:03,221][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=57f3c82a-986b-4750-af28-b6df93902270, startPtr=FileWALPointer [idx=0, fileOff=4381415, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=5ms, pages=10, reason='timeout'] [19:22:03,261][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=57f3c82a-986b-4750-af28-b6df93902270, pages=10, markPos=FileWALPointer [idx=0, fileOff=4381415, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=31ms, pagesWrite=1ms, fsync=38ms, total=70ms] [19:22:04,876][INFO][grid-timeout-worker-#23][IgniteKernal] Metrics for local node (to disable set 'metricsLogFrequency' to 0) ^-- Node [id=c9ddebdb, uptime=00:02:00.013] ^-- H/N/C [hosts=1, nodes=2, CPUs=8] ^-- CPU [cur=0,2%, avg=2%, GC=0%] ^-- PageMemory [pages=166] ^-- Heap [used=176MB, free=81,98%, comm=981MB] ^-- Off-heap [used=0MB, free=99,92%, comm=800MB] ^-- dataRegion1 region [used=0MB, free=100%, comm=200MB] ^-- sysMemPlc region [used=0MB, free=99,98%, comm=100MB] ^-- default region [used=0MB, free=99,73%, comm=200MB] ^-- metastoreMemPlc region [used=0MB, free=99,93%, comm=100MB] ^-- dataRegion2 region [used=0MB, free=100%, comm=100MB] ^-- TxLog region [used=0MB, free=99,98%, comm=100MB] ^-- Ignite persistence [used=0MB] ^-- dataRegion1 region [used=0MB] ^-- sysMemPlc region [used=0MB] ^-- default region [used=0MB] ^-- metastoreMemPlc region [used=unknown] ^-- dataRegion2 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=5, qSize=0] [19:22:04,891][WARNING][grid-timeout-worker-#23][diagnostic] Found long running transaction [startTime=19:20:26.420, curTime=19:22:04.879, tx=GridNearTxLocal [mappings=IgniteTxMappingsImpl [], nearLocallyMapped=false, colocatedLocallyMapped=true, needCheckBackup=null, hasRemoteLocks=true, trackTimeout=false, lb=null, mvccTracker=null, mvccOp=true, thread=jdbc-request-handler-worker-#76, mappings=IgniteTxMappingsImpl [], super=GridDhtTxLocalAdapter [nearOnOriginatingNode=false, nearNodes=KeySetView [], dhtNodes=KeySetView [], explicitLock=false, super=IgniteTxLocalAdapter [completedBase=null, sndTransformedVals=false, depEnabled=false, txState=IgniteTxStateImpl [activeCacheIds=[-1691533662], recovery=false, mvccEnabled=true, txMap=HashSet []], mvccWaitTxs=null, qryEnlisted=true, forceSkipCompletedVers=false, super=IgniteTxAdapter [xidVer=GridCacheVersion [topVer=152310006, order=1540829999528, nodeOrder=1], writeVer=null, implicit=false, loc=true, threadId=112, startTime=1540830026420, nodeId=c9ddebdb-c328-4283-97c5-a6634444887a, startVer=GridCacheVersion [topVer=152310006, order=1540829999528, nodeOrder=1], endVer=null, isolation=REPEATABLE_READ, concurrency=PESSIMISTIC, timeout=0, sysInvalidate=false, sys=false, plc=2, commitVer=GridCacheVersion [topVer=152310006, order=1540829999528, nodeOrder=1], finalizing=NONE, invalidParts=null, state=ACTIVE, timedOut=false, topVer=AffinityTopologyVersion [topVer=2, minorTopVer=2], txCounters=null, duration=98459ms, onePhaseCommit=false], size=0]]]] [19:22:04,894][WARNING][grid-timeout-worker-#23][diagnostic] Found long running transaction [startTime=19:20:26.420, curTime=19:22:04.879, tx=GridDhtTxRemote [nearNodeId=c9ddebdb-c328-4283-97c5-a6634444887a, rmtFutId=1deef90c661-03ec9836-0022-44c1-b831-7bef9e75ff4c, nearXidVer=GridCacheVersion [topVer=152310006, order=1540829999528, nodeOrder=1], storeWriteThrough=false, super=GridDistributedTxRemoteAdapter [explicitVers=null, started=true, commitAllowed=0, txState=IgniteTxRemoteStateImpl [readMap=EmptyMap {}, writeMap=ConcurrentLinkedHashMap {}], skipCompletedVers=false, super=IgniteTxAdapter [xidVer=GridCacheVersion [topVer=152310006, order=1540829999529, nodeOrder=2], writeVer=null, implicit=false, loc=false, threadId=20, startTime=1540830026420, nodeId=24507fea-b571-48e6-b28d-cc38cf82ba21, startVer=GridCacheVersion [topVer=152310006, order=1540829999528, nodeOrder=1], endVer=null, isolation=REPEATABLE_READ, concurrency=PESSIMISTIC, timeout=0, sysInvalidate=false, sys=false, plc=2, commitVer=GridCacheVersion [topVer=152310006, order=1540829999529, nodeOrder=2], finalizing=NONE, invalidParts=null, state=ACTIVE, timedOut=false, topVer=AffinityTopologyVersion [topVer=2, minorTopVer=2], txCounters=o.a.i.i.processors.cache.transactions.TxCounters@7f859258, duration=98470ms, onePhaseCommit=false]]]] [19:22:04,896][WARNING][grid-timeout-worker-#23][diagnostic] Found long running transaction [startTime=19:20:26.420, curTime=19:22:04.879, tx=GridNearTxLocal [mappings=IgniteTxMappingsImpl [], nearLocallyMapped=false, colocatedLocallyMapped=true, needCheckBackup=null, hasRemoteLocks=false, trackTimeout=false, lb=null, mvccTracker=null, mvccOp=true, thread=jdbc-request-handler-worker-#60, mappings=IgniteTxMappingsImpl [], super=GridDhtTxLocalAdapter [nearOnOriginatingNode=false, nearNodes=KeySetView [], dhtNodes=KeySetView [24507fea-b571-48e6-b28d-cc38cf82ba21], explicitLock=false, super=IgniteTxLocalAdapter [completedBase=null, sndTransformedVals=false, depEnabled=false, txState=IgniteTxStateImpl [activeCacheIds=[-1691533662], recovery=false, mvccEnabled=true, txMap=HashSet []], mvccWaitTxs=null, qryEnlisted=true, forceSkipCompletedVers=false, super=IgniteTxAdapter [xidVer=GridCacheVersion [topVer=152310006, order=1540829999527, nodeOrder=1], writeVer=null, implicit=false, loc=true, threadId=96, startTime=1540830026420, nodeId=c9ddebdb-c328-4283-97c5-a6634444887a, startVer=GridCacheVersion [topVer=152310006, order=1540829999527, nodeOrder=1], endVer=null, isolation=REPEATABLE_READ, concurrency=PESSIMISTIC, timeout=0, sysInvalidate=false, sys=false, plc=2, commitVer=GridCacheVersion [topVer=152310006, order=1540829999527, nodeOrder=1], finalizing=NONE, invalidParts=null, state=ACTIVE, timedOut=false, topVer=AffinityTopologyVersion [topVer=2, minorTopVer=2], txCounters=o.a.i.i.processors.cache.transactions.TxCounters@2124e4c6, duration=98470ms, onePhaseCommit=false], size=0]]]] [19:22:04,898][WARNING][grid-timeout-worker-#23][diagnostic] Found long running cache future [startTime=19:20:26.420, curTime=19:22:04.879, fut=GridNearTxQueryEnlistFuture [schema=PUBLIC, qry=update t1 set b=b-1, flags=0, pageSize=1024, super=GridCompoundIdentityFuture [super=GridCompoundFuture [rdc=Long reducer: 6, initFlag=1, lsnrCalls=1, done=false, cancelled=false, err=null, futs=TransformCollectionView [false, true]]]]] [19:22:04,899][WARNING][grid-timeout-worker-#23][diagnostic] Found long running cache future [startTime=19:20:26.420, curTime=19:22:04.879, fut=GridNearTxQueryEnlistFuture [schema=PUBLIC, qry=update t1 set b=b+1, flags=0, pageSize=1024, super=GridCompoundIdentityFuture [super=GridCompoundFuture [rdc=Long reducer: 4, initFlag=1, lsnrCalls=1, done=false, cancelled=false, err=null, futs=TransformCollectionView [true, false]]]]] [19:22:04,900][WARNING][grid-timeout-worker-#23][diagnostic] Found long running cache future [startTime=19:20:26.420, curTime=19:22:04.879, fut=GridDhtTxQueryEnlistFuture [schema=PUBLIC, qry=update t1 set b=b-1, flags=0, pageSize=1024]] [19:22:08,250][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=a46adc97-d979-489d-9762-07ddcb4b8f94, startPtr=FileWALPointer [idx=0, fileOff=4444114, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=5ms, pages=10, reason='timeout'] [19:22:08,290][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=a46adc97-d979-489d-9762-07ddcb4b8f94, pages=10, markPos=FileWALPointer [idx=0, fileOff=4444114, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=32ms, pagesWrite=1ms, fsync=37ms, total=70ms] [19:22:13,285][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=ddf1b89b-739c-410d-a0d5-d62364f7f2af, startPtr=FileWALPointer [idx=0, fileOff=4506813, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=6ms, pages=10, reason='timeout'] [19:22:13,313][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=ddf1b89b-739c-410d-a0d5-d62364f7f2af, pages=10, markPos=FileWALPointer [idx=0, fileOff=4506813, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=45ms, pagesWrite=0ms, fsync=26ms, total=71ms] [19:22:18,292][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=24aed7bb-8e6f-4dd1-b96f-d398af1b45f5, startPtr=FileWALPointer [idx=0, fileOff=4569512, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=5ms, pages=10, reason='timeout'] [19:22:18,323][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=24aed7bb-8e6f-4dd1-b96f-d398af1b45f5, pages=10, markPos=FileWALPointer [idx=0, fileOff=4569512, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=32ms, pagesWrite=1ms, fsync=30ms, total=63ms] [19:22:23,313][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=1e59b60e-528b-443e-8c77-a451fad34874, startPtr=FileWALPointer [idx=0, fileOff=4632211, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=6ms, pages=10, reason='timeout'] [19:22:23,355][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=1e59b60e-528b-443e-8c77-a451fad34874, pages=10, markPos=FileWALPointer [idx=0, fileOff=4632211, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=33ms, pagesWrite=1ms, fsync=41ms, total=75ms] [19:22:28,342][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=a48a7833-0f45-48c4-b622-19523eff4689, startPtr=FileWALPointer [idx=0, fileOff=4694910, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=5ms, pages=10, reason='timeout'] [19:22:28,373][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=a48a7833-0f45-48c4-b622-19523eff4689, pages=10, markPos=FileWALPointer [idx=0, fileOff=4694910, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=32ms, pagesWrite=1ms, fsync=30ms, total=63ms] [19:22:33,376][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=d7f52651-f071-45c1-846b-6cb002526d8f, startPtr=FileWALPointer [idx=0, fileOff=4757609, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=6ms, pages=10, reason='timeout'] [19:22:33,410][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=d7f52651-f071-45c1-846b-6cb002526d8f, pages=10, markPos=FileWALPointer [idx=0, fileOff=4757609, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=33ms, pagesWrite=1ms, fsync=32ms, total=66ms] [19:22:38,402][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=a4e4ccaf-fb9e-4d6a-9891-ad47f06e6ffa, startPtr=FileWALPointer [idx=0, fileOff=4820308, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=5ms, pages=10, reason='timeout'] [19:22:38,440][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=a4e4ccaf-fb9e-4d6a-9891-ad47f06e6ffa, pages=10, markPos=FileWALPointer [idx=0, fileOff=4820308, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=31ms, pagesWrite=1ms, fsync=37ms, total=69ms] [19:22:43,423][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=2db00e5d-b0fb-431c-a3b3-2f3d9818cfde, startPtr=FileWALPointer [idx=0, fileOff=4883007, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=5ms, pages=10, reason='timeout'] [19:22:43,457][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=2db00e5d-b0fb-431c-a3b3-2f3d9818cfde, pages=10, markPos=FileWALPointer [idx=0, fileOff=4883007, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=35ms, pagesWrite=1ms, fsync=33ms, total=69ms] [19:22:48,445][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=6b883c01-3c27-4acf-81c2-bfe33683ecde, startPtr=FileWALPointer [idx=0, fileOff=4945706, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=5ms, pages=10, reason='timeout'] [19:22:48,475][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=6b883c01-3c27-4acf-81c2-bfe33683ecde, pages=10, markPos=FileWALPointer [idx=0, fileOff=4945706, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=33ms, pagesWrite=1ms, fsync=29ms, total=63ms] [19:22:53,466][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=ed18712a-6188-483c-b873-19a6873f8f5d, startPtr=FileWALPointer [idx=0, fileOff=5008405, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=5ms, pages=10, reason='timeout'] [19:22:53,503][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=ed18712a-6188-483c-b873-19a6873f8f5d, pages=10, markPos=FileWALPointer [idx=0, fileOff=5008405, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=31ms, pagesWrite=1ms, fsync=36ms, total=68ms] [19:22:58,495][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=027a67df-088c-4939-b68b-dabcc5fc8149, startPtr=FileWALPointer [idx=0, fileOff=5071104, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=5ms, pages=10, reason='timeout'] [19:22:58,525][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=027a67df-088c-4939-b68b-dabcc5fc8149, pages=10, markPos=FileWALPointer [idx=0, fileOff=5071104, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=33ms, pagesWrite=1ms, fsync=29ms, total=63ms] [19:23:03,497][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=1b0940d5-137f-476a-83a8-729950109395, startPtr=FileWALPointer [idx=0, fileOff=5133803, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=1ms, walCpRecordFsyncDuration=5ms, pages=10, reason='timeout'] [19:23:03,522][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=1b0940d5-137f-476a-83a8-729950109395, pages=10, markPos=FileWALPointer [idx=0, fileOff=5133803, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=22ms, pagesWrite=0ms, fsync=24ms, total=46ms] [19:23:04,880][INFO][grid-timeout-worker-#23][IgniteKernal] Metrics for local node (to disable set 'metricsLogFrequency' to 0) ^-- Node [id=c9ddebdb, uptime=00:03:00.023] ^-- H/N/C [hosts=1, nodes=2, CPUs=8] ^-- CPU [cur=0%, avg=1,43%, GC=0%] ^-- PageMemory [pages=166] ^-- Heap [used=199MB, free=79,67%, comm=981MB] ^-- Off-heap [used=0MB, free=99,92%, comm=800MB] ^-- dataRegion1 region [used=0MB, free=100%, comm=200MB] ^-- sysMemPlc region [used=0MB, free=99,98%, comm=100MB] ^-- default region [used=0MB, free=99,73%, comm=200MB] ^-- metastoreMemPlc region [used=0MB, free=99,93%, comm=100MB] ^-- dataRegion2 region [used=0MB, free=100%, comm=100MB] ^-- TxLog region [used=0MB, free=99,98%, comm=100MB] ^-- Ignite persistence [used=0MB] ^-- dataRegion1 region [used=0MB] ^-- sysMemPlc region [used=0MB] ^-- default region [used=0MB] ^-- metastoreMemPlc region [used=unknown] ^-- dataRegion2 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] [19:23:04,912][WARNING][grid-timeout-worker-#23][diagnostic] Found long running transaction [startTime=19:20:26.420, curTime=19:23:04.910, tx=GridNearTxLocal [mappings=IgniteTxMappingsImpl [], nearLocallyMapped=false, colocatedLocallyMapped=true, needCheckBackup=null, hasRemoteLocks=true, trackTimeout=false, lb=null, mvccTracker=null, mvccOp=true, thread=jdbc-request-handler-worker-#76, mappings=IgniteTxMappingsImpl [], super=GridDhtTxLocalAdapter [nearOnOriginatingNode=false, nearNodes=KeySetView [], dhtNodes=KeySetView [], explicitLock=false, super=IgniteTxLocalAdapter [completedBase=null, sndTransformedVals=false, depEnabled=false, txState=IgniteTxStateImpl [activeCacheIds=[-1691533662], recovery=false, mvccEnabled=true, txMap=HashSet []], mvccWaitTxs=null, qryEnlisted=true, forceSkipCompletedVers=false, super=IgniteTxAdapter [xidVer=GridCacheVersion [topVer=152310006, order=1540829999528, nodeOrder=1], writeVer=null, implicit=false, loc=true, threadId=112, startTime=1540830026420, nodeId=c9ddebdb-c328-4283-97c5-a6634444887a, startVer=GridCacheVersion [topVer=152310006, order=1540829999528, nodeOrder=1], endVer=null, isolation=REPEATABLE_READ, concurrency=PESSIMISTIC, timeout=0, sysInvalidate=false, sys=false, plc=2, commitVer=GridCacheVersion [topVer=152310006, order=1540829999528, nodeOrder=1], finalizing=NONE, invalidParts=null, state=ACTIVE, timedOut=false, topVer=AffinityTopologyVersion [topVer=2, minorTopVer=2], txCounters=null, duration=158490ms, onePhaseCommit=false], size=0]]]] [19:23:04,913][WARNING][grid-timeout-worker-#23][diagnostic] Found long running transaction [startTime=19:20:26.420, curTime=19:23:04.910, tx=GridDhtTxRemote [nearNodeId=c9ddebdb-c328-4283-97c5-a6634444887a, rmtFutId=1deef90c661-03ec9836-0022-44c1-b831-7bef9e75ff4c, nearXidVer=GridCacheVersion [topVer=152310006, order=1540829999528, nodeOrder=1], storeWriteThrough=false, super=GridDistributedTxRemoteAdapter [explicitVers=null, started=true, commitAllowed=0, txState=IgniteTxRemoteStateImpl [readMap=EmptyMap {}, writeMap=ConcurrentLinkedHashMap {}], skipCompletedVers=false, super=IgniteTxAdapter [xidVer=GridCacheVersion [topVer=152310006, order=1540829999529, nodeOrder=2], writeVer=null, implicit=false, loc=false, threadId=20, startTime=1540830026420, nodeId=24507fea-b571-48e6-b28d-cc38cf82ba21, startVer=GridCacheVersion [topVer=152310006, order=1540829999528, nodeOrder=1], endVer=null, isolation=REPEATABLE_READ, concurrency=PESSIMISTIC, timeout=0, sysInvalidate=false, sys=false, plc=2, commitVer=GridCacheVersion [topVer=152310006, order=1540829999529, nodeOrder=2], finalizing=NONE, invalidParts=null, state=ACTIVE, timedOut=false, topVer=AffinityTopologyVersion [topVer=2, minorTopVer=2], txCounters=o.a.i.i.processors.cache.transactions.TxCounters@7f859258, duration=158490ms, onePhaseCommit=false]]]] [19:23:04,914][WARNING][grid-timeout-worker-#23][diagnostic] Found long running transaction [startTime=19:20:26.420, curTime=19:23:04.910, tx=GridNearTxLocal [mappings=IgniteTxMappingsImpl [], nearLocallyMapped=false, colocatedLocallyMapped=true, needCheckBackup=null, hasRemoteLocks=false, trackTimeout=false, lb=null, mvccTracker=null, mvccOp=true, thread=jdbc-request-handler-worker-#60, mappings=IgniteTxMappingsImpl [], super=GridDhtTxLocalAdapter [nearOnOriginatingNode=false, nearNodes=KeySetView [], dhtNodes=KeySetView [24507fea-b571-48e6-b28d-cc38cf82ba21], explicitLock=false, super=IgniteTxLocalAdapter [completedBase=null, sndTransformedVals=false, depEnabled=false, txState=IgniteTxStateImpl [activeCacheIds=[-1691533662], recovery=false, mvccEnabled=true, txMap=HashSet []], mvccWaitTxs=null, qryEnlisted=true, forceSkipCompletedVers=false, super=IgniteTxAdapter [xidVer=GridCacheVersion [topVer=152310006, order=1540829999527, nodeOrder=1], writeVer=null, implicit=false, loc=true, threadId=96, startTime=1540830026420, nodeId=c9ddebdb-c328-4283-97c5-a6634444887a, startVer=GridCacheVersion [topVer=152310006, order=1540829999527, nodeOrder=1], endVer=null, isolation=REPEATABLE_READ, concurrency=PESSIMISTIC, timeout=0, sysInvalidate=false, sys=false, plc=2, commitVer=GridCacheVersion [topVer=152310006, order=1540829999527, nodeOrder=1], finalizing=NONE, invalidParts=null, state=ACTIVE, timedOut=false, topVer=AffinityTopologyVersion [topVer=2, minorTopVer=2], txCounters=o.a.i.i.processors.cache.transactions.TxCounters@2124e4c6, duration=158490ms, onePhaseCommit=false], size=0]]]] [19:23:04,914][WARNING][grid-timeout-worker-#23][diagnostic] Found long running cache future [startTime=19:20:26.420, curTime=19:23:04.910, fut=GridNearTxQueryEnlistFuture [schema=PUBLIC, qry=update t1 set b=b-1, flags=0, pageSize=1024, super=GridCompoundIdentityFuture [super=GridCompoundFuture [rdc=Long reducer: 6, initFlag=1, lsnrCalls=1, done=false, cancelled=false, err=null, futs=TransformCollectionView [false, true]]]]] [19:23:04,915][WARNING][grid-timeout-worker-#23][diagnostic] Found long running cache future [startTime=19:20:26.420, curTime=19:23:04.910, fut=GridNearTxQueryEnlistFuture [schema=PUBLIC, qry=update t1 set b=b+1, flags=0, pageSize=1024, super=GridCompoundIdentityFuture [super=GridCompoundFuture [rdc=Long reducer: 4, initFlag=1, lsnrCalls=1, done=false, cancelled=false, err=null, futs=TransformCollectionView [true, false]]]]] [19:23:04,915][WARNING][grid-timeout-worker-#23][diagnostic] Found long running cache future [startTime=19:20:26.420, curTime=19:23:04.910, fut=GridDhtTxQueryEnlistFuture [schema=PUBLIC, qry=update t1 set b=b-1, flags=0, pageSize=1024]] [19:23:08,516][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=ae66fe79-e1ef-4284-934d-6ea3862c0896, startPtr=FileWALPointer [idx=0, fileOff=5196502, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=4ms, pages=10, reason='timeout'] [19:23:08,535][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=ae66fe79-e1ef-4284-934d-6ea3862c0896, pages=10, markPos=FileWALPointer [idx=0, fileOff=5196502, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=20ms, pagesWrite=0ms, fsync=18ms, total=38ms] [19:23:13,541][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=666b6921-2434-4073-9bc2-fa85470e6f30, startPtr=FileWALPointer [idx=0, fileOff=5259201, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=0ms, walCpRecordFsyncDuration=4ms, pages=10, reason='timeout'] [19:23:13,559][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=666b6921-2434-4073-9bc2-fa85470e6f30, pages=10, markPos=FileWALPointer [idx=0, fileOff=5259201, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=12ms, pagesWrite=1ms, fsync=17ms, total=30ms] [19:23:18,575][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=3562e05e-20f0-469e-965d-04f98453e0a0, startPtr=FileWALPointer [idx=0, fileOff=5321900, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=5ms, pages=10, reason='timeout'] [19:23:18,613][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=3562e05e-20f0-469e-965d-04f98453e0a0, pages=10, markPos=FileWALPointer [idx=0, fileOff=5321900, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=24ms, pagesWrite=1ms, fsync=36ms, total=61ms] [19:23:23,599][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=1d6cd00d-1437-4e2b-9e5b-c9b1cab2f47f, startPtr=FileWALPointer [idx=0, fileOff=5384599, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=4ms, pages=10, reason='timeout'] [19:23:23,630][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=1d6cd00d-1437-4e2b-9e5b-c9b1cab2f47f, pages=10, markPos=FileWALPointer [idx=0, fileOff=5384599, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=21ms, pagesWrite=1ms, fsync=30ms, total=52ms] [19:23:28,619][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=ec1501f3-b364-47b3-a7fd-7c30a85c37ad, startPtr=FileWALPointer [idx=0, fileOff=5447298, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=4ms, pages=10, reason='timeout'] [19:23:28,648][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=ec1501f3-b364-47b3-a7fd-7c30a85c37ad, pages=10, markPos=FileWALPointer [idx=0, fileOff=5447298, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=21ms, pagesWrite=1ms, fsync=26ms, total=48ms] [19:23:33,644][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=9fed3c17-da6c-40d1-8509-ffd7819ec49f, startPtr=FileWALPointer [idx=0, fileOff=5509997, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=4ms, pages=10, reason='timeout'] [19:23:33,678][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=9fed3c17-da6c-40d1-8509-ffd7819ec49f, pages=10, markPos=FileWALPointer [idx=0, fileOff=5509997, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=22ms, pagesWrite=1ms, fsync=33ms, total=56ms] [19:23:37,675][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=29ec2db1-9a54-4021-882f-bdc18de5603e, startPtr=FileWALPointer [idx=0, fileOff=5572696, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=5ms, pages=10, reason='timeout'] [19:23:37,714][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=29ec2db1-9a54-4021-882f-bdc18de5603e, pages=10, markPos=FileWALPointer [idx=0, fileOff=5572696, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=32ms, pagesWrite=0ms, fsync=38ms, total=70ms] [19:23:42,692][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=6cbdc6b0-f05b-47a1-8c04-d5183a967d03, startPtr=FileWALPointer [idx=0, fileOff=5635395, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=4ms, pages=10, reason='timeout'] [19:23:42,732][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=6cbdc6b0-f05b-47a1-8c04-d5183a967d03, pages=10, markPos=FileWALPointer [idx=0, fileOff=5635395, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=33ms, pagesWrite=1ms, fsync=38ms, total=72ms] [19:23:47,709][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=8dbec46d-0d6c-4b2e-9b97-85c31d6827b1, startPtr=FileWALPointer [idx=0, fileOff=5698094, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=1ms, walCpRecordFsyncDuration=4ms, pages=10, reason='timeout'] [19:23:47,737][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=8dbec46d-0d6c-4b2e-9b97-85c31d6827b1, pages=10, markPos=FileWALPointer [idx=0, fileOff=5698094, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=24ms, pagesWrite=0ms, fsync=27ms, total=51ms] [19:23:52,724][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=f97ae17e-33cb-42ce-8123-472261a793ff, startPtr=FileWALPointer [idx=0, fileOff=5760793, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=0ms, walCpRecordFsyncDuration=3ms, pages=10, reason='timeout'] [19:23:52,738][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=f97ae17e-33cb-42ce-8123-472261a793ff, pages=10, markPos=FileWALPointer [idx=0, fileOff=5760793, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=11ms, pagesWrite=0ms, fsync=13ms, total=24ms] [19:23:57,777][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=2ae9fd72-6c3a-4aa8-89c7-1e6bbb0b78c9, startPtr=FileWALPointer [idx=0, fileOff=5823492, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=4ms, pages=10, reason='timeout'] [19:23:57,823][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=2ae9fd72-6c3a-4aa8-89c7-1e6bbb0b78c9, pages=10, markPos=FileWALPointer [idx=0, fileOff=5823492, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=31ms, pagesWrite=1ms, fsync=44ms, total=76ms] [19:24:02,802][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=c9bc3e67-2961-441f-b0cc-355f20e2b3a0, startPtr=FileWALPointer [idx=0, fileOff=5886191, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=4ms, pages=10, reason='timeout'] [19:24:02,837][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=c9bc3e67-2961-441f-b0cc-355f20e2b3a0, pages=10, markPos=FileWALPointer [idx=0, fileOff=5886191, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=31ms, pagesWrite=1ms, fsync=33ms, total=65ms] [19:24:04,887][INFO][grid-timeout-worker-#23][IgniteKernal] Metrics for local node (to disable set 'metricsLogFrequency' to 0) ^-- Node [id=c9ddebdb, uptime=00:04:00.031] ^-- H/N/C [hosts=1, nodes=2, CPUs=8] ^-- CPU [cur=0,6%, avg=1,18%, GC=0%] ^-- PageMemory [pages=166] ^-- Heap [used=221MB, free=77,46%, comm=981MB] ^-- Off-heap [used=0MB, free=99,92%, comm=800MB] ^-- dataRegion1 region [used=0MB, free=100%, comm=200MB] ^-- sysMemPlc region [used=0MB, free=99,98%, comm=100MB] ^-- default region [used=0MB, free=99,73%, comm=200MB] ^-- metastoreMemPlc region [used=0MB, free=99,93%, comm=100MB] ^-- dataRegion2 region [used=0MB, free=100%, comm=100MB] ^-- TxLog region [used=0MB, free=99,98%, comm=100MB] ^-- Ignite persistence [used=0MB] ^-- dataRegion1 region [used=0MB] ^-- sysMemPlc region [used=0MB] ^-- default region [used=0MB] ^-- metastoreMemPlc region [used=unknown] ^-- dataRegion2 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] [19:24:07,821][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=999800d4-01d5-4f37-97ba-f3d26f9572cb, startPtr=FileWALPointer [idx=0, fileOff=5948890, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=4ms, pages=10, reason='timeout'] [19:24:07,860][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=999800d4-01d5-4f37-97ba-f3d26f9572cb, pages=10, markPos=FileWALPointer [idx=0, fileOff=5948890, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=31ms, pagesWrite=1ms, fsync=37ms, total=69ms] [19:24:12,843][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=6cc1ef50-6402-4553-9f38-d12a63d9a727, startPtr=FileWALPointer [idx=0, fileOff=6011589, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=5ms, pages=10, reason='timeout'] [19:24:12,881][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=6cc1ef50-6402-4553-9f38-d12a63d9a727, pages=10, markPos=FileWALPointer [idx=0, fileOff=6011589, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=32ms, pagesWrite=0ms, fsync=37ms, total=69ms] [19:24:17,873][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=17de18eb-0a11-4414-9939-cb8da32f08b4, startPtr=FileWALPointer [idx=0, fileOff=6074288, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=4ms, pages=10, reason='timeout'] [19:24:17,912][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=17de18eb-0a11-4414-9939-cb8da32f08b4, pages=10, markPos=FileWALPointer [idx=0, fileOff=6074288, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=31ms, pagesWrite=0ms, fsync=37ms, total=68ms] [19:24:22,899][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=a6818189-be4e-4ef4-b835-c826070efee4, startPtr=FileWALPointer [idx=0, fileOff=6136987, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=4ms, pages=10, reason='timeout'] [19:24:22,934][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=a6818189-be4e-4ef4-b835-c826070efee4, pages=10, markPos=FileWALPointer [idx=0, fileOff=6136987, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=31ms, pagesWrite=0ms, fsync=34ms, total=65ms] [19:24:27,938][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=f54678ec-d843-4f33-be76-f77251afd597, startPtr=FileWALPointer [idx=0, fileOff=6199686, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=4ms, pages=10, reason='timeout'] [19:24:27,969][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=f54678ec-d843-4f33-be76-f77251afd597, pages=10, markPos=FileWALPointer [idx=0, fileOff=6199686, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=32ms, pagesWrite=1ms, fsync=30ms, total=63ms] [19:24:32,961][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=9893b652-ffac-46e8-b997-6637e01f1064, startPtr=FileWALPointer [idx=0, fileOff=6262385, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=4ms, pages=10, reason='timeout'] [19:24:32,986][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=9893b652-ffac-46e8-b997-6637e01f1064, pages=10, markPos=FileWALPointer [idx=0, fileOff=6262385, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=29ms, pagesWrite=0ms, fsync=24ms, total=53ms] [19:24:37,981][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=6bc43451-4b9f-4e6d-83d3-75648fd10173, startPtr=FileWALPointer [idx=0, fileOff=6325084, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=1ms, walCpRecordFsyncDuration=3ms, pages=10, reason='timeout'] [19:24:38,007][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=6bc43451-4b9f-4e6d-83d3-75648fd10173, pages=10, markPos=FileWALPointer [idx=0, fileOff=6325084, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=19ms, pagesWrite=1ms, fsync=24ms, total=44ms] [19:24:43,003][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=0128c96f-2f43-4e69-95b5-4e2434e8a53b, startPtr=FileWALPointer [idx=0, fileOff=6387783, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=4ms, pages=10, reason='timeout'] [19:24:43,043][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=0128c96f-2f43-4e69-95b5-4e2434e8a53b, pages=10, markPos=FileWALPointer [idx=0, fileOff=6387783, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=30ms, pagesWrite=1ms, fsync=39ms, total=70ms] [19:24:48,033][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=5056f2a3-21c7-4cee-8bbc-9c7ebd966593, startPtr=FileWALPointer [idx=0, fileOff=6450482, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=4ms, pages=10, reason='timeout'] [19:24:48,061][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=5056f2a3-21c7-4cee-8bbc-9c7ebd966593, pages=10, markPos=FileWALPointer [idx=0, fileOff=6450482, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=32ms, pagesWrite=1ms, fsync=27ms, total=60ms] [19:24:53,044][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=cc524943-8661-48d6-87bc-c553c595f4ca, startPtr=FileWALPointer [idx=0, fileOff=6513181, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=3ms, pages=10, reason='timeout'] [19:24:53,082][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=cc524943-8661-48d6-87bc-c553c595f4ca, pages=10, markPos=FileWALPointer [idx=0, fileOff=6513181, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=30ms, pagesWrite=0ms, fsync=37ms, total=67ms] [19:24:58,071][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=1a1b0ad2-cd60-4646-bced-8e4dd506a012, startPtr=FileWALPointer [idx=0, fileOff=6575880, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=5ms, pages=10, reason='timeout'] [19:24:58,101][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=1a1b0ad2-cd60-4646-bced-8e4dd506a012, pages=10, markPos=FileWALPointer [idx=0, fileOff=6575880, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=32ms, pagesWrite=1ms, fsync=29ms, total=62ms] [19:25:03,099][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=a604a56f-d9aa-43e3-82b9-19d1dc1db3c8, startPtr=FileWALPointer [idx=0, fileOff=6638579, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=5ms, pages=10, reason='timeout'] [19:25:03,134][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=a604a56f-d9aa-43e3-82b9-19d1dc1db3c8, pages=10, markPos=FileWALPointer [idx=0, fileOff=6638579, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=32ms, pagesWrite=0ms, fsync=34ms, total=66ms] [19:25:04,891][INFO][grid-timeout-worker-#23][IgniteKernal] Metrics for local node (to disable set 'metricsLogFrequency' to 0) ^-- Node [id=c9ddebdb, uptime=00:05:00.031] ^-- H/N/C [hosts=1, nodes=2, CPUs=8] ^-- CPU [cur=0,4%, avg=0,99%, GC=0%] ^-- PageMemory [pages=166] ^-- Heap [used=242MB, free=75,29%, comm=981MB] ^-- Off-heap [used=0MB, free=99,92%, comm=800MB] ^-- dataRegion1 region [used=0MB, free=100%, comm=200MB] ^-- sysMemPlc region [used=0MB, free=99,98%, comm=100MB] ^-- default region [used=0MB, free=99,73%, comm=200MB] ^-- metastoreMemPlc region [used=0MB, free=99,93%, comm=100MB] ^-- dataRegion2 region [used=0MB, free=100%, comm=100MB] ^-- TxLog region [used=0MB, free=99,98%, comm=100MB] ^-- Ignite persistence [used=0MB] ^-- dataRegion1 region [used=0MB] ^-- sysMemPlc region [used=0MB] ^-- default region [used=0MB] ^-- metastoreMemPlc region [used=unknown] ^-- dataRegion2 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] [19:25:04,930][WARNING][grid-timeout-worker-#23][diagnostic] Found long running transaction [startTime=19:20:26.420, curTime=19:25:04.929, tx=GridNearTxLocal [mappings=IgniteTxMappingsImpl [], nearLocallyMapped=false, colocatedLocallyMapped=true, needCheckBackup=null, hasRemoteLocks=true, trackTimeout=false, lb=null, mvccTracker=null, mvccOp=true, thread=jdbc-request-handler-worker-#76, mappings=IgniteTxMappingsImpl [], super=GridDhtTxLocalAdapter [nearOnOriginatingNode=false, nearNodes=KeySetView [], dhtNodes=KeySetView [], explicitLock=false, super=IgniteTxLocalAdapter [completedBase=null, sndTransformedVals=false, depEnabled=false, txState=IgniteTxStateImpl [activeCacheIds=[-1691533662], recovery=false, mvccEnabled=true, txMap=HashSet []], mvccWaitTxs=null, qryEnlisted=true, forceSkipCompletedVers=false, super=IgniteTxAdapter [xidVer=GridCacheVersion [topVer=152310006, order=1540829999528, nodeOrder=1], writeVer=null, implicit=false, loc=true, threadId=112, startTime=1540830026420, nodeId=c9ddebdb-c328-4283-97c5-a6634444887a, startVer=GridCacheVersion [topVer=152310006, order=1540829999528, nodeOrder=1], endVer=null, isolation=REPEATABLE_READ, concurrency=PESSIMISTIC, timeout=0, sysInvalidate=false, sys=false, plc=2, commitVer=GridCacheVersion [topVer=152310006, order=1540829999528, nodeOrder=1], finalizing=NONE, invalidParts=null, state=ACTIVE, timedOut=false, topVer=AffinityTopologyVersion [topVer=2, minorTopVer=2], txCounters=null, duration=278509ms, onePhaseCommit=false], size=0]]]] [19:25:04,932][WARNING][grid-timeout-worker-#23][diagnostic] Found long running transaction [startTime=19:20:26.420, curTime=19:25:04.929, tx=GridDhtTxRemote [nearNodeId=c9ddebdb-c328-4283-97c5-a6634444887a, rmtFutId=1deef90c661-03ec9836-0022-44c1-b831-7bef9e75ff4c, nearXidVer=GridCacheVersion [topVer=152310006, order=1540829999528, nodeOrder=1], storeWriteThrough=false, super=GridDistributedTxRemoteAdapter [explicitVers=null, started=true, commitAllowed=0, txState=IgniteTxRemoteStateImpl [readMap=EmptyMap {}, writeMap=ConcurrentLinkedHashMap {}], skipCompletedVers=false, super=IgniteTxAdapter [xidVer=GridCacheVersion [topVer=152310006, order=1540829999529, nodeOrder=2], writeVer=null, implicit=false, loc=false, threadId=20, startTime=1540830026420, nodeId=24507fea-b571-48e6-b28d-cc38cf82ba21, startVer=GridCacheVersion [topVer=152310006, order=1540829999528, nodeOrder=1], endVer=null, isolation=REPEATABLE_READ, concurrency=PESSIMISTIC, timeout=0, sysInvalidate=false, sys=false, plc=2, commitVer=GridCacheVersion [topVer=152310006, order=1540829999529, nodeOrder=2], finalizing=NONE, invalidParts=null, state=ACTIVE, timedOut=false, topVer=AffinityTopologyVersion [topVer=2, minorTopVer=2], txCounters=o.a.i.i.processors.cache.transactions.TxCounters@7f859258, duration=278509ms, onePhaseCommit=false]]]] [19:25:04,933][WARNING][grid-timeout-worker-#23][diagnostic] Found long running transaction [startTime=19:20:26.420, curTime=19:25:04.929, tx=GridNearTxLocal [mappings=IgniteTxMappingsImpl [], nearLocallyMapped=false, colocatedLocallyMapped=true, needCheckBackup=null, hasRemoteLocks=false, trackTimeout=false, lb=null, mvccTracker=null, mvccOp=true, thread=jdbc-request-handler-worker-#60, mappings=IgniteTxMappingsImpl [], super=GridDhtTxLocalAdapter [nearOnOriginatingNode=false, nearNodes=KeySetView [], dhtNodes=KeySetView [24507fea-b571-48e6-b28d-cc38cf82ba21], explicitLock=false, super=IgniteTxLocalAdapter [completedBase=null, sndTransformedVals=false, depEnabled=false, txState=IgniteTxStateImpl [activeCacheIds=[-1691533662], recovery=false, mvccEnabled=true, txMap=HashSet []], mvccWaitTxs=null, qryEnlisted=true, forceSkipCompletedVers=false, super=IgniteTxAdapter [xidVer=GridCacheVersion [topVer=152310006, order=1540829999527, nodeOrder=1], writeVer=null, implicit=false, loc=true, threadId=96, startTime=1540830026420, nodeId=c9ddebdb-c328-4283-97c5-a6634444887a, startVer=GridCacheVersion [topVer=152310006, order=1540829999527, nodeOrder=1], endVer=null, isolation=REPEATABLE_READ, concurrency=PESSIMISTIC, timeout=0, sysInvalidate=false, sys=false, plc=2, commitVer=GridCacheVersion [topVer=152310006, order=1540829999527, nodeOrder=1], finalizing=NONE, invalidParts=null, state=ACTIVE, timedOut=false, topVer=AffinityTopologyVersion [topVer=2, minorTopVer=2], txCounters=o.a.i.i.processors.cache.transactions.TxCounters@2124e4c6, duration=278509ms, onePhaseCommit=false], size=0]]]] [19:25:04,934][WARNING][grid-timeout-worker-#23][diagnostic] Found long running cache future [startTime=19:20:26.420, curTime=19:25:04.929, fut=GridNearTxQueryEnlistFuture [schema=PUBLIC, qry=update t1 set b=b-1, flags=0, pageSize=1024, super=GridCompoundIdentityFuture [super=GridCompoundFuture [rdc=Long reducer: 6, initFlag=1, lsnrCalls=1, done=false, cancelled=false, err=null, futs=TransformCollectionView [false, true]]]]] [19:25:04,935][WARNING][grid-timeout-worker-#23][diagnostic] Found long running cache future [startTime=19:20:26.420, curTime=19:25:04.929, fut=GridNearTxQueryEnlistFuture [schema=PUBLIC, qry=update t1 set b=b+1, flags=0, pageSize=1024, super=GridCompoundIdentityFuture [super=GridCompoundFuture [rdc=Long reducer: 4, initFlag=1, lsnrCalls=1, done=false, cancelled=false, err=null, futs=TransformCollectionView [true, false]]]]] [19:25:04,935][WARNING][grid-timeout-worker-#23][diagnostic] Found long running cache future [startTime=19:20:26.420, curTime=19:25:04.929, fut=GridDhtTxQueryEnlistFuture [schema=PUBLIC, qry=update t1 set b=b-1, flags=0, pageSize=1024]] [19:25:08,130][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=bf8d269e-fd9c-48f0-985e-80ca787d5243, startPtr=FileWALPointer [idx=0, fileOff=6701278, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=5ms, pages=10, reason='timeout'] [19:25:08,168][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=bf8d269e-fd9c-48f0-985e-80ca787d5243, pages=10, markPos=FileWALPointer [idx=0, fileOff=6701278, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=31ms, pagesWrite=1ms, fsync=36ms, total=68ms] [19:25:13,165][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=2e7573f7-0ec8-462f-b1ef-827c5978318a, startPtr=FileWALPointer [idx=0, fileOff=6763977, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=4ms, pages=10, reason='timeout'] [19:25:13,205][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=2e7573f7-0ec8-462f-b1ef-827c5978318a, pages=10, markPos=FileWALPointer [idx=0, fileOff=6763977, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=31ms, pagesWrite=1ms, fsync=38ms, total=70ms] [19:25:18,190][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=c1e07ba0-15c4-43df-87bc-5d0a8a45a005, startPtr=FileWALPointer [idx=0, fileOff=6826676, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=3ms, pages=10, reason='timeout'] [19:25:18,225][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=c1e07ba0-15c4-43df-87bc-5d0a8a45a005, pages=10, markPos=FileWALPointer [idx=0, fileOff=6826676, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=30ms, pagesWrite=0ms, fsync=34ms, total=64ms] [19:25:23,213][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=4b7f14af-0986-4a72-87f2-d0507b4137a6, startPtr=FileWALPointer [idx=0, fileOff=6889375, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=5ms, pages=10, reason='timeout'] [19:25:23,244][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=4b7f14af-0986-4a72-87f2-d0507b4137a6, pages=10, markPos=FileWALPointer [idx=0, fileOff=6889375, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=31ms, pagesWrite=1ms, fsync=30ms, total=62ms] [19:25:28,232][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=07628d3c-1182-4a98-9494-0e2750a4a2b9, startPtr=FileWALPointer [idx=0, fileOff=6952074, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=5ms, pages=10, reason='timeout'] [19:25:28,272][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=07628d3c-1182-4a98-9494-0e2750a4a2b9, pages=10, markPos=FileWALPointer [idx=0, fileOff=6952074, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=32ms, pagesWrite=1ms, fsync=38ms, total=71ms] [19:25:31,222][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Skipping checkpoint (no pages were modified) [checkpointLockWait=0ms, checkpointLockHoldTime=0ms, reason='timeout'] [19:25:33,253][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=0e34e6c5-8b6f-4d01-af36-d6881e92e31f, startPtr=FileWALPointer [idx=0, fileOff=7014773, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=1ms, walCpRecordFsyncDuration=3ms, pages=10, reason='timeout'] [19:25:33,277][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=0e34e6c5-8b6f-4d01-af36-d6881e92e31f, pages=10, markPos=FileWALPointer [idx=0, fileOff=7014773, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=20ms, pagesWrite=0ms, fsync=24ms, total=44ms] [19:25:38,297][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=9ed240fe-0c20-46f4-80a7-eb252aa885a4, startPtr=FileWALPointer [idx=0, fileOff=7077472, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=4ms, pages=10, reason='timeout'] [19:25:38,323][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=9ed240fe-0c20-46f4-80a7-eb252aa885a4, pages=10, markPos=FileWALPointer [idx=0, fileOff=7077472, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=31ms, pagesWrite=0ms, fsync=25ms, total=56ms] [19:25:43,325][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=80683ac7-fa24-4bfe-8309-a9a0489b2805, startPtr=FileWALPointer [idx=0, fileOff=7140171, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=4ms, pages=10, reason='timeout'] [19:25:43,364][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=80683ac7-fa24-4bfe-8309-a9a0489b2805, pages=10, markPos=FileWALPointer [idx=0, fileOff=7140171, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=31ms, pagesWrite=1ms, fsync=38ms, total=70ms] [19:25:48,352][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=35e52b4e-3393-4923-818b-c850a5485f84, startPtr=FileWALPointer [idx=0, fileOff=7202870, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=5ms, pages=10, reason='timeout'] [19:25:48,390][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=35e52b4e-3393-4923-818b-c850a5485f84, pages=10, markPos=FileWALPointer [idx=0, fileOff=7202870, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=34ms, pagesWrite=1ms, fsync=37ms, total=72ms] [19:25:53,383][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=77fab252-c722-4b21-a5d5-18d357cb4e5c, startPtr=FileWALPointer [idx=0, fileOff=7265569, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=4ms, pages=10, reason='timeout'] [19:25:53,406][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=77fab252-c722-4b21-a5d5-18d357cb4e5c, pages=10, markPos=FileWALPointer [idx=0, fileOff=7265569, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=32ms, pagesWrite=1ms, fsync=22ms, total=55ms] [19:25:54,355][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Skipping checkpoint (no pages were modified) [checkpointLockWait=0ms, checkpointLockHoldTime=3ms, reason='timeout'] [19:25:58,383][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=ba99ab06-34e9-4184-8e68-ceacdb9c2823, startPtr=FileWALPointer [idx=0, fileOff=7328268, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=0ms, walCpRecordFsyncDuration=3ms, pages=10, reason='timeout'] [19:25:58,396][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=ba99ab06-34e9-4184-8e68-ceacdb9c2823, pages=10, markPos=FileWALPointer [idx=0, fileOff=7328268, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=11ms, pagesWrite=0ms, fsync=13ms, total=24ms] [19:26:03,431][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=8f393f45-698c-42e0-805a-db4c37ca2809, startPtr=FileWALPointer [idx=0, fileOff=7390967, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=4ms, pages=10, reason='timeout'] [19:26:03,466][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=8f393f45-698c-42e0-805a-db4c37ca2809, pages=10, markPos=FileWALPointer [idx=0, fileOff=7390967, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=31ms, pagesWrite=1ms, fsync=32ms, total=64ms] [19:26:04,897][INFO][grid-timeout-worker-#23][IgniteKernal] Metrics for local node (to disable set 'metricsLogFrequency' to 0) ^-- Node [id=c9ddebdb, uptime=00:06:00.041] ^-- H/N/C [hosts=1, nodes=2, CPUs=8] ^-- CPU [cur=1,03%, avg=0,88%, GC=0%] ^-- PageMemory [pages=166] ^-- Heap [used=264MB, free=73,08%, comm=981MB] ^-- Off-heap [used=0MB, free=99,92%, comm=800MB] ^-- dataRegion1 region [used=0MB, free=100%, comm=200MB] ^-- sysMemPlc region [used=0MB, free=99,98%, comm=100MB] ^-- default region [used=0MB, free=99,73%, comm=200MB] ^-- metastoreMemPlc region [used=0MB, free=99,93%, comm=100MB] ^-- dataRegion2 region [used=0MB, free=100%, comm=100MB] ^-- TxLog region [used=0MB, free=99,98%, comm=100MB] ^-- Ignite persistence [used=0MB] ^-- dataRegion1 region [used=0MB] ^-- sysMemPlc region [used=0MB] ^-- default region [used=0MB] ^-- metastoreMemPlc region [used=unknown] ^-- dataRegion2 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] [19:26:08,445][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=bc69b76a-7b8b-45ca-963b-72bd1d434045, startPtr=FileWALPointer [idx=0, fileOff=7453666, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=5ms, pages=10, reason='timeout'] [19:26:08,479][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=bc69b76a-7b8b-45ca-963b-72bd1d434045, pages=10, markPos=FileWALPointer [idx=0, fileOff=7453666, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=33ms, pagesWrite=1ms, fsync=33ms, total=67ms] [19:26:10,411][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Skipping checkpoint (no pages were modified) [checkpointLockWait=0ms, checkpointLockHoldTime=2ms, reason='timeout'] [19:26:13,461][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=026f3e0b-c8fb-4000-a249-8da7f3bba6e7, startPtr=FileWALPointer [idx=0, fileOff=7516365, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=4ms, pages=10, reason='timeout'] [19:26:13,492][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=026f3e0b-c8fb-4000-a249-8da7f3bba6e7, pages=10, markPos=FileWALPointer [idx=0, fileOff=7516365, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=31ms, pagesWrite=0ms, fsync=30ms, total=61ms] [19:26:18,469][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=83b5fce8-22f0-4ea8-a6ae-9c8e59383a39, startPtr=FileWALPointer [idx=0, fileOff=7579064, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=1ms, walCpRecordFsyncDuration=3ms, pages=10, reason='timeout'] [19:26:18,484][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=83b5fce8-22f0-4ea8-a6ae-9c8e59383a39, pages=10, markPos=FileWALPointer [idx=0, fileOff=7579064, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=14ms, pagesWrite=1ms, fsync=14ms, total=29ms] [19:26:23,517][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=a631bfb7-6421-4c97-9fe7-dd56fa49f1ba, startPtr=FileWALPointer [idx=0, fileOff=7641763, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=5ms, pages=10, reason='timeout'] [19:26:23,555][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=a631bfb7-6421-4c97-9fe7-dd56fa49f1ba, pages=10, markPos=FileWALPointer [idx=0, fileOff=7641763, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=32ms, pagesWrite=1ms, fsync=37ms, total=70ms] [19:26:25,490][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Skipping checkpoint (no pages were modified) [checkpointLockWait=0ms, checkpointLockHoldTime=1ms, reason='timeout'] [19:26:28,536][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=0ff16dbe-04c8-4f81-9490-ca633856b8db, startPtr=FileWALPointer [idx=0, fileOff=7704462, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=4ms, pages=10, reason='timeout'] [19:26:28,574][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=0ff16dbe-04c8-4f81-9490-ca633856b8db, pages=10, markPos=FileWALPointer [idx=0, fileOff=7704462, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=30ms, pagesWrite=1ms, fsync=37ms, total=68ms] [19:26:33,541][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=48f338c1-2a2a-4121-8104-d57239f20b6d, startPtr=FileWALPointer [idx=0, fileOff=7767161, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=1ms, walCpRecordFsyncDuration=3ms, pages=10, reason='timeout'] [19:26:33,570][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=48f338c1-2a2a-4121-8104-d57239f20b6d, pages=10, markPos=FileWALPointer [idx=0, fileOff=7767161, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=26ms, pagesWrite=1ms, fsync=28ms, total=55ms] [19:26:38,569][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=aac3684e-ad6f-4ecb-b770-7e7e41cbd36c, startPtr=FileWALPointer [idx=0, fileOff=7829860, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=4ms, pages=10, reason='timeout'] [19:26:38,608][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=aac3684e-ad6f-4ecb-b770-7e7e41cbd36c, pages=10, markPos=FileWALPointer [idx=0, fileOff=7829860, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=30ms, pagesWrite=1ms, fsync=37ms, total=68ms] [19:26:43,576][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=a614521a-69b0-418a-9811-4e4aa0904dd7, startPtr=FileWALPointer [idx=0, fileOff=7892559, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=3ms, walCpRecordFsyncDuration=5ms, pages=10, reason='timeout'] [19:26:43,608][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=a614521a-69b0-418a-9811-4e4aa0904dd7, pages=10, markPos=FileWALPointer [idx=0, fileOff=7892559, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=32ms, pagesWrite=1ms, fsync=31ms, total=64ms] [19:26:48,589][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=d385e436-e372-4570-9834-9e2d69026249, startPtr=FileWALPointer [idx=0, fileOff=7955258, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=18ms, walCpRecordFsyncDuration=5ms, pages=10, reason='timeout'] [19:26:48,602][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=d385e436-e372-4570-9834-9e2d69026249, pages=10, markPos=FileWALPointer [idx=0, fileOff=7955258, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=29ms, pagesWrite=1ms, fsync=12ms, total=42ms] [19:26:53,618][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=19471a8d-386f-4545-a13e-8d74a0bbedd1, startPtr=FileWALPointer [idx=0, fileOff=8017957, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=5ms, pages=10, reason='timeout'] [19:26:53,659][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=19471a8d-386f-4545-a13e-8d74a0bbedd1, pages=10, markPos=FileWALPointer [idx=0, fileOff=8017957, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=22ms, pagesWrite=1ms, fsync=40ms, total=63ms] [19:26:58,635][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=376cb556-fabf-4bb9-a2aa-429568b11342, startPtr=FileWALPointer [idx=0, fileOff=8080656, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=1ms, walCpRecordFsyncDuration=4ms, pages=10, reason='timeout'] [19:26:58,668][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=376cb556-fabf-4bb9-a2aa-429568b11342, pages=10, markPos=FileWALPointer [idx=0, fileOff=8080656, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=20ms, pagesWrite=1ms, fsync=32ms, total=53ms] [19:27:03,649][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=49813fec-7380-4607-9373-8f2d69ca158f, startPtr=FileWALPointer [idx=0, fileOff=8143355, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=1ms, walCpRecordFsyncDuration=5ms, pages=10, reason='timeout'] [19:27:03,681][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=49813fec-7380-4607-9373-8f2d69ca158f, pages=10, markPos=FileWALPointer [idx=0, fileOff=8143355, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=22ms, pagesWrite=1ms, fsync=30ms, total=53ms] [19:27:04,906][INFO][grid-timeout-worker-#23][IgniteKernal] Metrics for local node (to disable set 'metricsLogFrequency' to 0) ^-- Node [id=c9ddebdb, uptime=00:07:00.047] ^-- H/N/C [hosts=1, nodes=2, CPUs=8] ^-- CPU [cur=0,27%, avg=0,8%, GC=0%] ^-- PageMemory [pages=166] ^-- Heap [used=54MB, free=94,41%, comm=981MB] ^-- Off-heap [used=0MB, free=99,92%, comm=800MB] ^-- dataRegion1 region [used=0MB, free=100%, comm=200MB] ^-- sysMemPlc region [used=0MB, free=99,98%, comm=100MB] ^-- default region [used=0MB, free=99,73%, comm=200MB] ^-- metastoreMemPlc region [used=0MB, free=99,93%, comm=100MB] ^-- dataRegion2 region [used=0MB, free=100%, comm=100MB] ^-- TxLog region [used=0MB, free=99,98%, comm=100MB] ^-- Ignite persistence [used=0MB] ^-- dataRegion1 region [used=0MB] ^-- sysMemPlc region [used=0MB] ^-- default region [used=0MB] ^-- metastoreMemPlc region [used=unknown] ^-- dataRegion2 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] [19:27:08,673][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=5d675e0d-de4a-46fa-8bf6-1261bec28764, startPtr=FileWALPointer [idx=0, fileOff=8206054, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=5ms, pages=10, reason='timeout'] [19:27:08,700][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=5d675e0d-de4a-46fa-8bf6-1261bec28764, pages=10, markPos=FileWALPointer [idx=0, fileOff=8206054, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=22ms, pagesWrite=1ms, fsync=25ms, total=48ms] [19:27:12,705][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=46526ea4-3aef-4851-b10d-62472c0aec27, startPtr=FileWALPointer [idx=0, fileOff=8268753, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=1ms, walCpRecordFsyncDuration=3ms, pages=10, reason='timeout'] [19:27:12,730][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=46526ea4-3aef-4851-b10d-62472c0aec27, pages=10, markPos=FileWALPointer [idx=0, fileOff=8268753, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=26ms, pagesWrite=1ms, fsync=23ms, total=50ms] [19:27:17,735][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=059bc7f5-f873-484a-8110-76fb5beefa7f, startPtr=FileWALPointer [idx=0, fileOff=8331452, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=1ms, walCpRecordFsyncDuration=4ms, pages=10, reason='timeout'] [19:27:17,772][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=059bc7f5-f873-484a-8110-76fb5beefa7f, pages=10, markPos=FileWALPointer [idx=0, fileOff=8331452, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=29ms, pagesWrite=1ms, fsync=36ms, total=66ms] [19:27:22,745][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=706a0e7d-98d4-4f2c-aec5-f5c3640da76d, startPtr=FileWALPointer [idx=0, fileOff=8394151, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=1ms, walCpRecordFsyncDuration=3ms, pages=10, reason='timeout'] [19:27:22,772][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=706a0e7d-98d4-4f2c-aec5-f5c3640da76d, pages=10, markPos=FileWALPointer [idx=0, fileOff=8394151, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=20ms, pagesWrite=1ms, fsync=26ms, total=47ms] [19:27:27,765][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=6e17feb1-2125-4dd0-968c-10da201ad90d, startPtr=FileWALPointer [idx=0, fileOff=8456850, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=4ms, pages=10, reason='timeout'] [19:27:27,787][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=6e17feb1-2125-4dd0-968c-10da201ad90d, pages=10, markPos=FileWALPointer [idx=0, fileOff=8456850, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=27ms, pagesWrite=1ms, fsync=21ms, total=49ms] [19:27:32,775][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=81f96d08-bcb4-4eb1-bc0c-b0add501f401, startPtr=FileWALPointer [idx=0, fileOff=8519549, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=1ms, walCpRecordFsyncDuration=3ms, pages=10, reason='timeout'] [19:27:32,801][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=81f96d08-bcb4-4eb1-bc0c-b0add501f401, pages=10, markPos=FileWALPointer [idx=0, fileOff=8519549, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=20ms, pagesWrite=1ms, fsync=25ms, total=46ms] [19:27:37,823][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=7bc38b90-b016-4ece-9a6c-c6c361ad2f72, startPtr=FileWALPointer [idx=0, fileOff=8582248, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=5ms, pages=10, reason='timeout'] [19:27:37,855][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=7bc38b90-b016-4ece-9a6c-c6c361ad2f72, pages=10, markPos=FileWALPointer [idx=0, fileOff=8582248, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=31ms, pagesWrite=1ms, fsync=31ms, total=63ms] [19:27:42,843][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=cfa7f544-6792-437f-98e6-63ecbcdf3bf2, startPtr=FileWALPointer [idx=0, fileOff=8644947, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=1ms, walCpRecordFsyncDuration=4ms, pages=10, reason='timeout'] [19:27:42,881][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=cfa7f544-6792-437f-98e6-63ecbcdf3bf2, pages=10, markPos=FileWALPointer [idx=0, fileOff=8644947, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=29ms, pagesWrite=1ms, fsync=36ms, total=66ms] [19:27:47,876][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=0e1f1b0f-c062-4c09-8222-4b108cd08eaa, startPtr=FileWALPointer [idx=0, fileOff=8707646, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=4ms, pages=10, reason='timeout'] [19:27:47,903][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=0e1f1b0f-c062-4c09-8222-4b108cd08eaa, pages=10, markPos=FileWALPointer [idx=0, fileOff=8707646, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=23ms, pagesWrite=0ms, fsync=26ms, total=49ms] [19:27:52,905][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=7fd18386-3cbd-41e3-b7f5-dd4dd48868fd, startPtr=FileWALPointer [idx=0, fileOff=8770345, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=4ms, pages=10, reason='timeout'] [19:27:52,933][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=7fd18386-3cbd-41e3-b7f5-dd4dd48868fd, pages=10, markPos=FileWALPointer [idx=0, fileOff=8770345, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=31ms, pagesWrite=1ms, fsync=27ms, total=59ms] [19:27:57,933][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=9bf19886-9b46-4fc4-b3dd-cb9f06f1c629, startPtr=FileWALPointer [idx=0, fileOff=8833044, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=5ms, pages=10, reason='timeout'] [19:27:57,972][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=9bf19886-9b46-4fc4-b3dd-cb9f06f1c629, pages=10, markPos=FileWALPointer [idx=0, fileOff=8833044, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=33ms, pagesWrite=0ms, fsync=38ms, total=71ms] [19:28:02,969][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=1c2a16ce-4dda-4ffe-8d54-8b9483d616e6, startPtr=FileWALPointer [idx=0, fileOff=8895743, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=5ms, pages=10, reason='timeout'] [19:28:02,995][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=1c2a16ce-4dda-4ffe-8d54-8b9483d616e6, pages=10, markPos=FileWALPointer [idx=0, fileOff=8895743, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=39ms, pagesWrite=1ms, fsync=25ms, total=65ms] [19:28:04,913][INFO][grid-timeout-worker-#23][IgniteKernal] Metrics for local node (to disable set 'metricsLogFrequency' to 0) ^-- Node [id=c9ddebdb, uptime=00:08:00.056] ^-- H/N/C [hosts=1, nodes=2, CPUs=8] ^-- CPU [cur=0,33%, avg=0,71%, GC=0%] ^-- PageMemory [pages=166] ^-- Heap [used=82MB, free=91,55%, comm=981MB] ^-- Off-heap [used=0MB, free=99,92%, comm=800MB] ^-- dataRegion1 region [used=0MB, free=100%, comm=200MB] ^-- sysMemPlc region [used=0MB, free=99,98%, comm=100MB] ^-- default region [used=0MB, free=99,73%, comm=200MB] ^-- metastoreMemPlc region [used=0MB, free=99,93%, comm=100MB] ^-- dataRegion2 region [used=0MB, free=100%, comm=100MB] ^-- TxLog region [used=0MB, free=99,98%, comm=100MB] ^-- Ignite persistence [used=0MB] ^-- dataRegion1 region [used=0MB] ^-- sysMemPlc region [used=0MB] ^-- default region [used=0MB] ^-- metastoreMemPlc region [used=unknown] ^-- dataRegion2 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] [19:28:07,995][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=ecf4e028-c817-4dfe-8c5a-d18cfc40367a, startPtr=FileWALPointer [idx=0, fileOff=8958442, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=4ms, pages=10, reason='timeout'] [19:28:08,018][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=ecf4e028-c817-4dfe-8c5a-d18cfc40367a, pages=10, markPos=FileWALPointer [idx=0, fileOff=8958442, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=26ms, pagesWrite=1ms, fsync=22ms, total=49ms] [19:28:12,994][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=6bc0648e-35d3-4c7d-be25-bb089bf36366, startPtr=FileWALPointer [idx=0, fileOff=9021141, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=0ms, walCpRecordFsyncDuration=4ms, pages=10, reason='timeout'] [19:28:13,014][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=6bc0648e-35d3-4c7d-be25-bb089bf36366, pages=10, markPos=FileWALPointer [idx=0, fileOff=9021141, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=14ms, pagesWrite=1ms, fsync=19ms, total=34ms] [19:28:18,036][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=5025cc1b-8d20-48aa-ada6-c883926cdfba, startPtr=FileWALPointer [idx=0, fileOff=9083840, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=1ms, walCpRecordFsyncDuration=6ms, pages=10, reason='timeout'] [19:28:18,073][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=5025cc1b-8d20-48aa-ada6-c883926cdfba, pages=10, markPos=FileWALPointer [idx=0, fileOff=9083840, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=31ms, pagesWrite=1ms, fsync=35ms, total=67ms] [19:28:23,066][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=c6810a43-a6a5-4544-b77b-1736a0cb3ec7, startPtr=FileWALPointer [idx=0, fileOff=9146539, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=4ms, pages=10, reason='timeout'] [19:28:23,104][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=c6810a43-a6a5-4544-b77b-1736a0cb3ec7, pages=10, markPos=FileWALPointer [idx=0, fileOff=9146539, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=31ms, pagesWrite=0ms, fsync=37ms, total=68ms] [19:28:28,088][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=4bfbe4d1-39fd-4829-8b93-4875d93f9be8, startPtr=FileWALPointer [idx=0, fileOff=9209238, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=1ms, walCpRecordFsyncDuration=5ms, pages=10, reason='timeout'] [19:28:28,124][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=4bfbe4d1-39fd-4829-8b93-4875d93f9be8, pages=10, markPos=FileWALPointer [idx=0, fileOff=9209238, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=30ms, pagesWrite=0ms, fsync=35ms, total=65ms] [19:28:33,128][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=93ffab33-b5b1-4ac7-977b-a3efe333a2db, startPtr=FileWALPointer [idx=0, fileOff=9271937, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=0ms, walCpRecordFsyncDuration=5ms, pages=10, reason='timeout'] [19:28:33,153][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=93ffab33-b5b1-4ac7-977b-a3efe333a2db, pages=10, markPos=FileWALPointer [idx=0, fileOff=9271937, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=30ms, pagesWrite=1ms, fsync=24ms, total=55ms] [19:28:38,149][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=b251c128-dda9-466d-abc4-05ef1492c7a8, startPtr=FileWALPointer [idx=0, fileOff=9334636, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=4ms, pages=10, reason='timeout'] [19:28:38,178][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=b251c128-dda9-466d-abc4-05ef1492c7a8, pages=10, markPos=FileWALPointer [idx=0, fileOff=9334636, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=30ms, pagesWrite=1ms, fsync=28ms, total=59ms] [19:28:43,181][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=c06c576b-cf7e-496f-bf75-7054bf362148, startPtr=FileWALPointer [idx=0, fileOff=9397335, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=4ms, pages=10, reason='timeout'] [19:28:43,219][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=c06c576b-cf7e-496f-bf75-7054bf362148, pages=10, markPos=FileWALPointer [idx=0, fileOff=9397335, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=30ms, pagesWrite=1ms, fsync=36ms, total=67ms] [19:28:48,181][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=4639cfca-4e95-4fed-a867-8be6ac062283, startPtr=FileWALPointer [idx=0, fileOff=9460034, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=1ms, walCpRecordFsyncDuration=3ms, pages=10, reason='timeout'] [19:28:48,209][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=4639cfca-4e95-4fed-a867-8be6ac062283, pages=10, markPos=FileWALPointer [idx=0, fileOff=9460034, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=27ms, pagesWrite=1ms, fsync=27ms, total=55ms] [19:28:53,205][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=2c18c18e-c12b-46c2-aa6b-cad3977bbb92, startPtr=FileWALPointer [idx=0, fileOff=9522733, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=5ms, pages=10, reason='timeout'] [19:28:53,239][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=2c18c18e-c12b-46c2-aa6b-cad3977bbb92, pages=10, markPos=FileWALPointer [idx=0, fileOff=9522733, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=34ms, pagesWrite=1ms, fsync=33ms, total=68ms] [19:28:58,233][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=35ff487f-8a6d-4fde-941e-e4737fa6eb0f, startPtr=FileWALPointer [idx=0, fileOff=9585432, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=1ms, walCpRecordFsyncDuration=4ms, pages=10, reason='timeout'] [19:28:58,271][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=35ff487f-8a6d-4fde-941e-e4737fa6eb0f, pages=10, markPos=FileWALPointer [idx=0, fileOff=9585432, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=31ms, pagesWrite=1ms, fsync=36ms, total=68ms] [19:29:03,253][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=0ad1a50b-5aa0-42da-9ebd-01e7b39672c3, startPtr=FileWALPointer [idx=0, fileOff=9648131, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=5ms, pages=10, reason='timeout'] [19:29:03,287][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=0ad1a50b-5aa0-42da-9ebd-01e7b39672c3, pages=10, markPos=FileWALPointer [idx=0, fileOff=9648131, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=31ms, pagesWrite=1ms, fsync=33ms, total=65ms] [19:29:04,914][INFO][grid-timeout-worker-#23][IgniteKernal] Metrics for local node (to disable set 'metricsLogFrequency' to 0) ^-- Node [id=c9ddebdb, uptime=00:09:00.056] ^-- H/N/C [hosts=1, nodes=2, CPUs=8] ^-- CPU [cur=0,07%, avg=0,66%, GC=0%] ^-- PageMemory [pages=166] ^-- Heap [used=103MB, free=89,42%, comm=981MB] ^-- Off-heap [used=0MB, free=99,92%, comm=800MB] ^-- dataRegion1 region [used=0MB, free=100%, comm=200MB] ^-- sysMemPlc region [used=0MB, free=99,98%, comm=100MB] ^-- default region [used=0MB, free=99,73%, comm=200MB] ^-- metastoreMemPlc region [used=0MB, free=99,93%, comm=100MB] ^-- dataRegion2 region [used=0MB, free=100%, comm=100MB] ^-- TxLog region [used=0MB, free=99,98%, comm=100MB] ^-- Ignite persistence [used=0MB] ^-- dataRegion1 region [used=0MB] ^-- sysMemPlc region [used=0MB] ^-- default region [used=0MB] ^-- metastoreMemPlc region [used=unknown] ^-- dataRegion2 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] [19:29:04,950][WARNING][grid-timeout-worker-#23][diagnostic] Found long running transaction [startTime=19:20:26.420, curTime=19:29:04.944, tx=GridNearTxLocal [mappings=IgniteTxMappingsImpl [], nearLocallyMapped=false, colocatedLocallyMapped=true, needCheckBackup=null, hasRemoteLocks=true, trackTimeout=false, lb=null, mvccTracker=null, mvccOp=true, thread=jdbc-request-handler-worker-#76, mappings=IgniteTxMappingsImpl [], super=GridDhtTxLocalAdapter [nearOnOriginatingNode=false, nearNodes=KeySetView [], dhtNodes=KeySetView [], explicitLock=false, super=IgniteTxLocalAdapter [completedBase=null, sndTransformedVals=false, depEnabled=false, txState=IgniteTxStateImpl [activeCacheIds=[-1691533662], recovery=false, mvccEnabled=true, txMap=HashSet []], mvccWaitTxs=null, qryEnlisted=true, forceSkipCompletedVers=false, super=IgniteTxAdapter [xidVer=GridCacheVersion [topVer=152310006, order=1540829999528, nodeOrder=1], writeVer=null, implicit=false, loc=true, threadId=112, startTime=1540830026420, nodeId=c9ddebdb-c328-4283-97c5-a6634444887a, startVer=GridCacheVersion [topVer=152310006, order=1540829999528, nodeOrder=1], endVer=null, isolation=REPEATABLE_READ, concurrency=PESSIMISTIC, timeout=0, sysInvalidate=false, sys=false, plc=2, commitVer=GridCacheVersion [topVer=152310006, order=1540829999528, nodeOrder=1], finalizing=NONE, invalidParts=null, state=ACTIVE, timedOut=false, topVer=AffinityTopologyVersion [topVer=2, minorTopVer=2], txCounters=null, duration=518524ms, onePhaseCommit=false], size=0]]]] [19:29:04,952][WARNING][grid-timeout-worker-#23][diagnostic] Found long running transaction [startTime=19:20:26.420, curTime=19:29:04.944, tx=GridDhtTxRemote [nearNodeId=c9ddebdb-c328-4283-97c5-a6634444887a, rmtFutId=1deef90c661-03ec9836-0022-44c1-b831-7bef9e75ff4c, nearXidVer=GridCacheVersion [topVer=152310006, order=1540829999528, nodeOrder=1], storeWriteThrough=false, super=GridDistributedTxRemoteAdapter [explicitVers=null, started=true, commitAllowed=0, txState=IgniteTxRemoteStateImpl [readMap=EmptyMap {}, writeMap=ConcurrentLinkedHashMap {}], skipCompletedVers=false, super=IgniteTxAdapter [xidVer=GridCacheVersion [topVer=152310006, order=1540829999529, nodeOrder=2], writeVer=null, implicit=false, loc=false, threadId=20, startTime=1540830026420, nodeId=24507fea-b571-48e6-b28d-cc38cf82ba21, startVer=GridCacheVersion [topVer=152310006, order=1540829999528, nodeOrder=1], endVer=null, isolation=REPEATABLE_READ, concurrency=PESSIMISTIC, timeout=0, sysInvalidate=false, sys=false, plc=2, commitVer=GridCacheVersion [topVer=152310006, order=1540829999529, nodeOrder=2], finalizing=NONE, invalidParts=null, state=ACTIVE, timedOut=false, topVer=AffinityTopologyVersion [topVer=2, minorTopVer=2], txCounters=o.a.i.i.processors.cache.transactions.TxCounters@7f859258, duration=518524ms, onePhaseCommit=false]]]] [19:29:04,953][WARNING][grid-timeout-worker-#23][diagnostic] Found long running transaction [startTime=19:20:26.420, curTime=19:29:04.944, tx=GridNearTxLocal [mappings=IgniteTxMappingsImpl [], nearLocallyMapped=false, colocatedLocallyMapped=true, needCheckBackup=null, hasRemoteLocks=false, trackTimeout=false, lb=null, mvccTracker=null, mvccOp=true, thread=jdbc-request-handler-worker-#60, mappings=IgniteTxMappingsImpl [], super=GridDhtTxLocalAdapter [nearOnOriginatingNode=false, nearNodes=KeySetView [], dhtNodes=KeySetView [24507fea-b571-48e6-b28d-cc38cf82ba21], explicitLock=false, super=IgniteTxLocalAdapter [completedBase=null, sndTransformedVals=false, depEnabled=false, txState=IgniteTxStateImpl [activeCacheIds=[-1691533662], recovery=false, mvccEnabled=true, txMap=HashSet []], mvccWaitTxs=null, qryEnlisted=true, forceSkipCompletedVers=false, super=IgniteTxAdapter [xidVer=GridCacheVersion [topVer=152310006, order=1540829999527, nodeOrder=1], writeVer=null, implicit=false, loc=true, threadId=96, startTime=1540830026420, nodeId=c9ddebdb-c328-4283-97c5-a6634444887a, startVer=GridCacheVersion [topVer=152310006, order=1540829999527, nodeOrder=1], endVer=null, isolation=REPEATABLE_READ, concurrency=PESSIMISTIC, timeout=0, sysInvalidate=false, sys=false, plc=2, commitVer=GridCacheVersion [topVer=152310006, order=1540829999527, nodeOrder=1], finalizing=NONE, invalidParts=null, state=ACTIVE, timedOut=false, topVer=AffinityTopologyVersion [topVer=2, minorTopVer=2], txCounters=o.a.i.i.processors.cache.transactions.TxCounters@2124e4c6, duration=518524ms, onePhaseCommit=false], size=0]]]] [19:29:04,954][WARNING][grid-timeout-worker-#23][diagnostic] Found long running cache future [startTime=19:20:26.420, curTime=19:29:04.944, fut=GridNearTxQueryEnlistFuture [schema=PUBLIC, qry=update t1 set b=b-1, flags=0, pageSize=1024, super=GridCompoundIdentityFuture [super=GridCompoundFuture [rdc=Long reducer: 6, initFlag=1, lsnrCalls=1, done=false, cancelled=false, err=null, futs=TransformCollectionView [false, true]]]]] [19:29:04,955][WARNING][grid-timeout-worker-#23][diagnostic] Found long running cache future [startTime=19:20:26.420, curTime=19:29:04.944, fut=GridNearTxQueryEnlistFuture [schema=PUBLIC, qry=update t1 set b=b+1, flags=0, pageSize=1024, super=GridCompoundIdentityFuture [super=GridCompoundFuture [rdc=Long reducer: 4, initFlag=1, lsnrCalls=1, done=false, cancelled=false, err=null, futs=TransformCollectionView [true, false]]]]] [19:29:04,956][WARNING][grid-timeout-worker-#23][diagnostic] Found long running cache future [startTime=19:20:26.420, curTime=19:29:04.944, fut=GridDhtTxQueryEnlistFuture [schema=PUBLIC, qry=update t1 set b=b-1, flags=0, pageSize=1024]] [19:29:08,272][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=1bf29e12-68b5-443d-9a36-e983673e2402, startPtr=FileWALPointer [idx=0, fileOff=9710830, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=1ms, walCpRecordFsyncDuration=5ms, pages=10, reason='timeout'] [19:29:08,301][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=1bf29e12-68b5-443d-9a36-e983673e2402, pages=10, markPos=FileWALPointer [idx=0, fileOff=9710830, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=32ms, pagesWrite=1ms, fsync=28ms, total=61ms] [19:29:13,313][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=58ffe916-b29e-4497-993b-0db179c21ff0, startPtr=FileWALPointer [idx=0, fileOff=9773529, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=1ms, walCpRecordFsyncDuration=5ms, pages=10, reason='timeout'] [19:29:13,337][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=58ffe916-b29e-4497-993b-0db179c21ff0, pages=10, markPos=FileWALPointer [idx=0, fileOff=9773529, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=34ms, pagesWrite=0ms, fsync=23ms, total=57ms] [19:29:18,323][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=1b03462e-358f-4822-a3c3-d128cbfe09d0, startPtr=FileWALPointer [idx=0, fileOff=9836228, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=4ms, pages=10, reason='timeout'] [19:29:18,354][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=1b03462e-358f-4822-a3c3-d128cbfe09d0, pages=10, markPos=FileWALPointer [idx=0, fileOff=9836228, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=30ms, pagesWrite=1ms, fsync=30ms, total=61ms] [19:29:23,326][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=6a469934-3fae-4ce1-92df-d60ab676e06f, startPtr=FileWALPointer [idx=0, fileOff=9898927, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=0ms, walCpRecordFsyncDuration=4ms, pages=10, reason='timeout'] [19:29:23,339][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=6a469934-3fae-4ce1-92df-d60ab676e06f, pages=10, markPos=FileWALPointer [idx=0, fileOff=9898927, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=11ms, pagesWrite=0ms, fsync=13ms, total=24ms] [19:29:28,368][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=41925aa7-b6a4-4c1f-9a66-4bc36602da3f, startPtr=FileWALPointer [idx=0, fileOff=9961626, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=4ms, pages=10, reason='timeout'] [19:29:28,399][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=41925aa7-b6a4-4c1f-9a66-4bc36602da3f, pages=10, markPos=FileWALPointer [idx=0, fileOff=9961626, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=31ms, pagesWrite=0ms, fsync=30ms, total=61ms] [19:29:33,400][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=c4094cc7-0be3-490f-8353-eb5b52a3f8c3, startPtr=FileWALPointer [idx=0, fileOff=10024325, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=5ms, pages=10, reason='timeout'] [19:29:33,435][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=c4094cc7-0be3-490f-8353-eb5b52a3f8c3, pages=10, markPos=FileWALPointer [idx=0, fileOff=10024325, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=31ms, pagesWrite=1ms, fsync=34ms, total=66ms] [19:29:38,411][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=a152c741-51f8-4c4a-9641-3e4d969ca9d0, startPtr=FileWALPointer [idx=0, fileOff=10087024, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=1ms, walCpRecordFsyncDuration=3ms, pages=10, reason='timeout'] [19:29:38,446][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=a152c741-51f8-4c4a-9641-3e4d969ca9d0, pages=10, markPos=FileWALPointer [idx=0, fileOff=10087024, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=18ms, pagesWrite=1ms, fsync=34ms, total=53ms] [19:29:43,447][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=239cae00-6233-4579-a227-b2f44ffe4b8d, startPtr=FileWALPointer [idx=0, fileOff=10149723, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=4ms, pages=10, reason='timeout'] [19:29:43,484][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=239cae00-6233-4579-a227-b2f44ffe4b8d, pages=10, markPos=FileWALPointer [idx=0, fileOff=10149723, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=30ms, pagesWrite=1ms, fsync=35ms, total=66ms] [19:29:48,463][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=b1162c9f-d06d-470b-95ac-5e8071d7bc52, startPtr=FileWALPointer [idx=0, fileOff=10212422, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=1ms, walCpRecordFsyncDuration=4ms, pages=10, reason='timeout'] [19:29:48,487][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=b1162c9f-d06d-470b-95ac-5e8071d7bc52, pages=10, markPos=FileWALPointer [idx=0, fileOff=10212422, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=29ms, pagesWrite=1ms, fsync=23ms, total=53ms] [19:29:53,475][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=e46d32c2-bfe1-4162-9f60-67ec5c9a89ae, startPtr=FileWALPointer [idx=0, fileOff=10275121, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=5ms, pages=10, reason='timeout'] [19:29:53,496][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=e46d32c2-bfe1-4162-9f60-67ec5c9a89ae, pages=10, markPos=FileWALPointer [idx=0, fileOff=10275121, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=30ms, pagesWrite=0ms, fsync=21ms, total=51ms] [19:29:58,494][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=848c7341-50ce-438c-8278-44fe9b462073, startPtr=FileWALPointer [idx=0, fileOff=10337820, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=1ms, walCpRecordFsyncDuration=4ms, pages=10, reason='timeout'] [19:29:58,531][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=848c7341-50ce-438c-8278-44fe9b462073, pages=10, markPos=FileWALPointer [idx=0, fileOff=10337820, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=32ms, pagesWrite=1ms, fsync=36ms, total=69ms] [19:30:03,537][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=739e5631-a9ed-476b-8a1e-4c55dcb15d88, startPtr=FileWALPointer [idx=0, fileOff=10400519, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=1ms, walCpRecordFsyncDuration=4ms, pages=10, reason='timeout'] [19:30:03,555][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=739e5631-a9ed-476b-8a1e-4c55dcb15d88, pages=10, markPos=FileWALPointer [idx=0, fileOff=10400519, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=55ms, pagesWrite=0ms, fsync=18ms, total=73ms] [19:30:04,921][INFO][grid-timeout-worker-#23][IgniteKernal] Metrics for local node (to disable set 'metricsLogFrequency' to 0) ^-- Node [id=c9ddebdb, uptime=00:10:00.065] ^-- H/N/C [hosts=1, nodes=2, CPUs=8] ^-- CPU [cur=0,67%, avg=0,62%, GC=0%] ^-- PageMemory [pages=166] ^-- Heap [used=125MB, free=87,26%, comm=981MB] ^-- Off-heap [used=0MB, free=99,92%, comm=800MB] ^-- dataRegion1 region [used=0MB, free=100%, comm=200MB] ^-- sysMemPlc region [used=0MB, free=99,98%, comm=100MB] ^-- default region [used=0MB, free=99,73%, comm=200MB] ^-- metastoreMemPlc region [used=0MB, free=99,93%, comm=100MB] ^-- dataRegion2 region [used=0MB, free=100%, comm=100MB] ^-- TxLog region [used=0MB, free=99,98%, comm=100MB] ^-- Ignite persistence [used=0MB] ^-- dataRegion1 region [used=0MB] ^-- sysMemPlc region [used=0MB] ^-- default region [used=0MB] ^-- metastoreMemPlc region [used=unknown] ^-- dataRegion2 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] [19:30:08,536][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=0e7e75c8-915f-44b3-a9ff-cfb5b582cff2, startPtr=FileWALPointer [idx=0, fileOff=10463218, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=1ms, walCpRecordFsyncDuration=4ms, pages=10, reason='timeout'] [19:30:08,560][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=0e7e75c8-915f-44b3-a9ff-cfb5b582cff2, pages=10, markPos=FileWALPointer [idx=0, fileOff=10463218, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=30ms, pagesWrite=1ms, fsync=23ms, total=54ms] [19:30:13,555][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=da19e8b8-34fd-49be-95a4-579ee5c65dfe, startPtr=FileWALPointer [idx=0, fileOff=10525917, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=1ms, walCpRecordFsyncDuration=4ms, pages=10, reason='timeout'] [19:30:13,583][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=da19e8b8-34fd-49be-95a4-579ee5c65dfe, pages=10, markPos=FileWALPointer [idx=0, fileOff=10525917, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=21ms, pagesWrite=0ms, fsync=27ms, total=48ms] [19:30:18,572][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=31e13a04-84ba-411a-99a7-888da1562c38, startPtr=FileWALPointer [idx=0, fileOff=10588616, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=4ms, pages=10, reason='timeout'] [19:30:18,597][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=31e13a04-84ba-411a-99a7-888da1562c38, pages=10, markPos=FileWALPointer [idx=0, fileOff=10588616, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=22ms, pagesWrite=1ms, fsync=24ms, total=47ms] [19:30:23,599][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=556ba049-6014-40da-9c7f-57edafeb793d, startPtr=FileWALPointer [idx=0, fileOff=10651315, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=1ms, walCpRecordFsyncDuration=4ms, pages=10, reason='timeout'] [19:30:23,631][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=556ba049-6014-40da-9c7f-57edafeb793d, pages=10, markPos=FileWALPointer [idx=0, fileOff=10651315, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=20ms, pagesWrite=1ms, fsync=31ms, total=52ms] [19:30:28,639][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint started [checkpointId=71a3c0db-cdce-4362-8d45-bc3b12bf831f, startPtr=FileWALPointer [idx=0, fileOff=10714014, len=21409], checkpointLockWait=0ms, checkpointLockHoldTime=2ms, walCpRecordFsyncDuration=5ms, pages=10, reason='timeout'] [19:30:28,678][INFO][db-checkpoint-thread-#49][GridCacheDatabaseSharedManager] Checkpoint finished [cpId=71a3c0db-cdce-4362-8d45-bc3b12bf831f, pages=10, markPos=FileWALPointer [idx=0, fileOff=10714014, len=21409], walSegmentsCleared=0, walSegmentsCovered=[], markDuration=24ms, pagesWrite=1ms, fsync=38ms, total=63ms]