ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James <2305958...@qq.com>
Subject Cannot insert data into table using JDBC
Date Mon, 16 Oct 2017 16:11:55 GMT
I am running a local server with native persistence.

		CacheConfiguration cacheConfiguration = new CacheConfiguration<>();
		cacheConfiguration.setSqlSchema("public");
		cacheConfiguration.setName("am_jdbc");
		igniteConfiguration.setCacheConfiguration(cacheConfiguration);

I am using
DriverManager.getConnection("jdbc:ignite:cfg://streaming=true:cache=am_jdbc@file:/E:/ignite-jdbc.xml");

I can run Statement.executeUpdate() to create a table. SQL is listed below:

create table Sample_Superstore(Row_ID decimal, Order_ID varchar, Order_Date
timestamp, Ship_Date timestamp, Ship_Mode varchar, Customer_ID varchar,
Customer_Name varchar, Segment varchar, Country varchar, City varchar, State
varchar, Postal_Code decimal, Region varchar, Product_ID varchar, Category
varchar, Sub_Category varchar, Product_Name varchar, Sales decimal, Quantity
decimal, Discount decimal, Profit decimal, primary key (Row_ID)) with
"template=partitioned,backups=1"

I can confirm a cache is created with a name - SQL_PUBLIC_SAMPLE_SUPERSTORE.

I got the following exception:

class org.apache.ignite.internal.processors.query.IgniteSQLException: Failed
to set schema for DB connection for thread [schema=]

org.h2.jdbc.JdbcSQLException: Schema  not found; SQL statement:
SET SCHEMA "" [90079-195]

The whole log is listed below:
------------------------------------------------------------------------------------

>>>    __________  ________________  
>>>   /  _/ ___/ |/ /  _/_  __/ __/  
>>>  _/ // (7 7    // /  / / / _/    
>>> /___/\___/_/|_/___/ /_/ /___/   
>>> 
>>> ver. 2.1.0#20170721-sha1:a6ca5c8a
>>> 2017 Copyright(C) Apache Software Foundation
>>> 
>>> Ignite documentation: http://ignite.apache.org

2017-10-16 23:12:04 INFO 
IgniteKernal%ignite-jdbc-driver-ed1473ab-40b2-47ff-90af-372c3ec22930:475 -
Config URL: n/a
2017-10-16 23:12:04 INFO 
IgniteKernal%ignite-jdbc-driver-ed1473ab-40b2-47ff-90af-372c3ec22930:475 -
Daemon mode: off
2017-10-16 23:12:04 INFO 
IgniteKernal%ignite-jdbc-driver-ed1473ab-40b2-47ff-90af-372c3ec22930:475 -
OS: Windows 7 6.1 amd64
2017-10-16 23:12:04 INFO 
IgniteKernal%ignite-jdbc-driver-ed1473ab-40b2-47ff-90af-372c3ec22930:475 -
OS user: tester
2017-10-16 23:12:04 INFO 
IgniteKernal%ignite-jdbc-driver-ed1473ab-40b2-47ff-90af-372c3ec22930:475 -
PID: 113872
2017-10-16 23:12:04 INFO 
IgniteKernal%ignite-jdbc-driver-ed1473ab-40b2-47ff-90af-372c3ec22930:475 -
Language runtime: Java Platform API Specification ver. 1.8
2017-10-16 23:12:04 INFO 
IgniteKernal%ignite-jdbc-driver-ed1473ab-40b2-47ff-90af-372c3ec22930:475 -
VM information: Java(TM) SE Runtime Environment 1.8.0_102-b14 Oracle
Corporation Java HotSpot(TM) 64-Bit Server VM 25.102-b14
2017-10-16 23:12:04 INFO 
IgniteKernal%ignite-jdbc-driver-ed1473ab-40b2-47ff-90af-372c3ec22930:475 -
VM total memory: 3.5GB
2017-10-16 23:12:04 INFO 
IgniteKernal%ignite-jdbc-driver-ed1473ab-40b2-47ff-90af-372c3ec22930:475 -
Remote Management [restart: off, REST: off, JMX (remote: off)]
2017-10-16 23:12:04 INFO 
IgniteKernal%ignite-jdbc-driver-ed1473ab-40b2-47ff-90af-372c3ec22930:475 -
IGNITE_HOME=D:\apache\ignite\2.0.0
2017-10-16 23:12:04 INFO 
IgniteKernal%ignite-jdbc-driver-ed1473ab-40b2-47ff-90af-372c3ec22930:475 -
VM arguments:
[-agentlib:jdwp=transport=dt_socket,suspend=y,address=localhost:53806,
-Dmaven.home=EMBEDDED,
-Dclassworlds.conf=E:\workspace10062016\.metadata\.plugins\org.eclipse.m2e.launching\launches\m2conf2309621012848687193.tmp,
-Dmaven.multiModuleProjectDirectory=E:\workspace\am-data-analysis,
-javaagent:C:\Users\tester\.p2\pool\plugins\com.ifedorenko.m2e.sourcelookup_1.1.0.201506181114\com.ifedorenko.m2e.sourcelookup.javaagent.jar,
-Xms512m, -XX:MaxPermSize=256m, -Dfile.encoding=UTF-8]
2017-10-16 23:12:04 INFO 
IgniteKernal%ignite-jdbc-driver-ed1473ab-40b2-47ff-90af-372c3ec22930:475 -
Configured caches [in 'sysMemPlc' memoryPolicy: ['ignite-sys-cache']]
2017-10-16 23:12:04 WARN 
IgniteKernal%ignite-jdbc-driver-ed1473ab-40b2-47ff-90af-372c3ec22930:480 -
Peer class loading is enabled (disable it in production for performance and
deployment consistency reasons)
2017-10-16 23:12:04 INFO 
IgniteKernal%ignite-jdbc-driver-ed1473ab-40b2-47ff-90af-372c3ec22930:475 -
3-rd party licenses can be found at: D:\apache\ignite\2.0.0\libs\licenses
2017-10-16 23:12:04 INFO  IgnitePluginProcessor:475 - Configured plugins:
2017-10-16 23:12:04 INFO  IgnitePluginProcessor:475 -   ^-- None
2017-10-16 23:12:04 INFO  IgnitePluginProcessor:475 - 
2017-10-16 23:12:04 INFO  TcpCommunicationSpi:475 - Successfully bound
communication NIO server to TCP port [port=47101, locHost=0.0.0.0/0.0.0.0,
selectorsCnt=4, selectorSpins=0, pairedConn=false]
2017-10-16 23:12:04 WARN  TcpCommunicationSpi:480 - 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.
2017-10-16 23:12:04 WARN  NoopCheckpointSpi:480 - Checkpoints are disabled
(to enable configure any GridCheckpointSpi implementation)
2017-10-16 23:12:04 WARN  GridCollisionManager:480 - Collision resolution is
disabled (all jobs will be activated upon arrival).
2017-10-16 23:12:04 INFO 
IgniteKernal%ignite-jdbc-driver-ed1473ab-40b2-47ff-90af-372c3ec22930:475 -
Security status [authentication=off, tls/ssl=off]
2017-10-16 23:12:04 INFO  IgniteH2Indexing:475 - H2 debug console URL:
http://192.168.1.120:54602/frame.jsp?jsessionid=d84e288f3284c9e8004f6f33540ac416
2017-10-16 23:12:04 WARN  IgniteH2Indexing:480 - Custom H2 serialization is
already configured, will override.
2017-10-16 23:12:04 INFO  SqlListenerProcessor:475 - SQL connector processor
has started on TCP port 10801
2017-10-16 23:12:04 INFO  GridRestProcessor:475 - REST protocols do not
start on client node. To start the protocols on client node set
'-DIGNITE_REST_START_ON_CLIENT=true' system property.
2017-10-16 23:12:05 INFO 
IgniteKernal%ignite-jdbc-driver-ed1473ab-40b2-47ff-90af-372c3ec22930:475 -
Non-loopback local IPs: 192.168.1.120, 2001:0:9d38:6ab8:185f:aff0:2222:6c0a,
2602:306:3276:770:4:6fb6:aba5:a557, fe80:0:0:0:0:5efe:c0a8:178%net5,
fe80:0:0:0:185f:aff0:2222:6c0a%net13, fe80:0:0:0:1bc:aac6:2d33:292e%eth3
2017-10-16 23:12:05 INFO 
IgniteKernal%ignite-jdbc-driver-ed1473ab-40b2-47ff-90af-372c3ec22930:475 -
Enabled local MACs: 00000000000000E0, 18037351158B
2017-10-16 23:12:07 INFO  GridDiscoveryManager:475 - Added new node to
topology: TcpDiscoveryNode [id=94aaeffe-53de-4814-981e-0d403a7a1ebe,
addrs=[0:0:0:0:0:0:0:1, 127.0.0.1, 192.168.1.120,
2001:0:9d38:6ab8:185f:aff0:2222:6c0a, 2602:306:3276:770:4:6fb6:aba5:a557],
sockAddrs=[tester-PC/192.168.1.120:0,
/2001:0:9d38:6ab8:185f:aff0:2222:6c0a:0, /0:0:0:0:0:0:0:1:0, /127.0.0.1:0,
/2602:306:3276:770:4:6fb6:aba5:a557:0], discPort=0, order=2, intOrder=2,
lastExchangeTime=1508166727792, loc=false, ver=2.1.0#20170721-sha1:a6ca5c8a,
isClient=true]
2017-10-16 23:12:07 INFO  GridDiscoveryManager:475 - Topology snapshot
[ver=2, servers=1, clients=1, CPUs=4, heap=3.5GB]
2017-10-16 23:12:07 INFO  time:475 - Started exchange init
[topVer=AffinityTopologyVersion [topVer=2, minorTopVer=0], crd=true, evt=10,
node=TcpDiscoveryNode [id=d586d8eb-300b-44a1-915d-be60d5ab7848,
addrs=[0:0:0:0:0:0:0:1, 127.0.0.1, 192.168.1.120,
2001:0:9d38:6ab8:185f:aff0:2222:6c0a, 2602:306:3276:770:4:6fb6:aba5:a557],
sockAddrs=[tester-PC/192.168.1.120:47500, /0:0:0:0:0:0:0:1:47500,
/127.0.0.1:47500, /2001:0:9d38:6ab8:185f:aff0:2222:6c0a:47500,
/2602:306:3276:770:4:6fb6:aba5:a557:47500], discPort=47500, order=1,
intOrder=1, lastExchangeTime=1508166727802, loc=true,
ver=2.1.0#20170721-sha1:a6ca5c8a, isClient=false], evtNode=TcpDiscoveryNode
[id=d586d8eb-300b-44a1-915d-be60d5ab7848, addrs=[0:0:0:0:0:0:0:1, 127.0.0.1,
192.168.1.120, 2001:0:9d38:6ab8:185f:aff0:2222:6c0a,
2602:306:3276:770:4:6fb6:aba5:a557],
sockAddrs=[tester-PC/192.168.1.120:47500, /0:0:0:0:0:0:0:1:47500,
/127.0.0.1:47500, /2001:0:9d38:6ab8:185f:aff0:2222:6c0a:47500,
/2602:306:3276:770:4:6fb6:aba5:a557:47500], discPort=47500, order=1,
intOrder=1, lastExchangeTime=1508166727802, loc=true,
ver=2.1.0#20170721-sha1:a6ca5c8a, isClient=false], customEvt=null]
2017-10-16 23:12:07 INFO  GridDhtPartitionsExchangeFuture:475 - Snapshot
initialization completed [topVer=AffinityTopologyVersion [topVer=2,
minorTopVer=0], time=0ms]
2017-10-16 23:12:07 INFO  time:475 - Finished exchange init
[topVer=AffinityTopologyVersion [topVer=2, minorTopVer=0], crd=true]
2017-10-16 23:12:07 INFO  GridCachePartitionExchangeManager:475 - Skipping
rebalancing (nothing scheduled) [top=AffinityTopologyVersion [topVer=2,
minorTopVer=0], evt=NODE_JOINED, node=94aaeffe-53de-4814-981e-0d403a7a1ebe]
2017-10-16 23:12:07 INFO  time:475 - Started exchange init
[topVer=AffinityTopologyVersion [topVer=2, minorTopVer=0], crd=false,
evt=10, node=TcpDiscoveryNode [id=94aaeffe-53de-4814-981e-0d403a7a1ebe,
addrs=[0:0:0:0:0:0:0:1, 127.0.0.1, 192.168.1.120,
2001:0:9d38:6ab8:185f:aff0:2222:6c0a, 2602:306:3276:770:4:6fb6:aba5:a557],
sockAddrs=[tester-PC/192.168.1.120:0,
/2001:0:9d38:6ab8:185f:aff0:2222:6c0a:0, /0:0:0:0:0:0:0:1:0, /127.0.0.1:0,
/2602:306:3276:770:4:6fb6:aba5:a557:0], discPort=0, order=2, intOrder=0,
lastExchangeTime=1508166725704, loc=true, ver=2.1.0#20170721-sha1:a6ca5c8a,
isClient=true], evtNode=TcpDiscoveryNode
[id=94aaeffe-53de-4814-981e-0d403a7a1ebe, addrs=[0:0:0:0:0:0:0:1, 127.0.0.1,
192.168.1.120, 2001:0:9d38:6ab8:185f:aff0:2222:6c0a,
2602:306:3276:770:4:6fb6:aba5:a557], sockAddrs=[tester-PC/192.168.1.120:0,
/2001:0:9d38:6ab8:185f:aff0:2222:6c0a:0, /0:0:0:0:0:0:0:1:0, /127.0.0.1:0,
/2602:306:3276:770:4:6fb6:aba5:a557:0], discPort=0, order=2, intOrder=0,
lastExchangeTime=1508166725704, loc=true, ver=2.1.0#20170721-sha1:a6ca5c8a,
isClient=true], customEvt=null]
2017-10-16 23:12:07 INFO  GridCacheProcessor:475 - Started cache
[name=ignite-sys-cache, memoryPolicyName=sysMemPlc, mode=REPLICATED,
atomicity=TRANSACTIONAL]
2017-10-16 23:12:07 INFO  TcpCommunicationSpi:475 - Accepted incoming
communication connection [locAddr=/127.0.0.1:47100,
rmtAddr=/127.0.0.1:54657]
2017-10-16 23:12:07 INFO  TcpCommunicationSpi:475 - Established outgoing
communication connection [locAddr=/127.0.0.1:54657,
rmtAddr=/127.0.0.1:47100]
2017-10-16 23:12:07 INFO  GridDhtPartitionsExchangeFuture:475 - Snapshot
initialization completed [topVer=AffinityTopologyVersion [topVer=2,
minorTopVer=0], time=0ms]
2017-10-16 23:12:07 INFO  time:475 - Finished exchange init
[topVer=AffinityTopologyVersion [topVer=2, minorTopVer=0], crd=false]
2017-10-16 23:12:07 INFO  GridDhtPartitionsExchangeFuture:475 - Snapshot
initialization completed [topVer=AffinityTopologyVersion [topVer=2,
minorTopVer=0], time=0ms]
2017-10-16 23:12:07 INFO 
IgniteKernal%ignite-jdbc-driver-ed1473ab-40b2-47ff-90af-372c3ec22930:475 -
Performance suggestions for grid
'ignite-jdbc-driver-ed1473ab-40b2-47ff-90af-372c3ec22930' (fix if possible)
2017-10-16 23:12:07 INFO 
IgniteKernal%ignite-jdbc-driver-ed1473ab-40b2-47ff-90af-372c3ec22930:475 -
To disable, set -DIGNITE_PERFORMANCE_SUGGESTIONS_DISABLED=true
2017-10-16 23:12:07 INFO 
IgniteKernal%ignite-jdbc-driver-ed1473ab-40b2-47ff-90af-372c3ec22930:475 -  
^-- Enable G1 Garbage Collector (add '-XX:+UseG1GC' to JVM options)
2017-10-16 23:12:07 INFO 
IgniteKernal%ignite-jdbc-driver-ed1473ab-40b2-47ff-90af-372c3ec22930:475 -  
^-- Specify JVM heap max size (add '-Xmx<size>[g|G|m|M|k|K]' to JVM options)
2017-10-16 23:12:07 INFO 
IgniteKernal%ignite-jdbc-driver-ed1473ab-40b2-47ff-90af-372c3ec22930:475 -  
^-- Set max direct memory size if getting 'OOME: Direct buffer memory' (add
'-XX:MaxDirectMemorySize=<size>[g|G|m|M|k|K]' to JVM options)
2017-10-16 23:12:07 INFO 
IgniteKernal%ignite-jdbc-driver-ed1473ab-40b2-47ff-90af-372c3ec22930:475 -  
^-- Disable processing of calls to System.gc() (add '-XX:+DisableExplicitGC'
to JVM options)
2017-10-16 23:12:07 INFO 
IgniteKernal%ignite-jdbc-driver-ed1473ab-40b2-47ff-90af-372c3ec22930:475 -
Refer to this page for more performance suggestions:
https://apacheignite.readme.io/docs/jvm-and-system-tuning
2017-10-16 23:12:07 INFO 
IgniteKernal%ignite-jdbc-driver-ed1473ab-40b2-47ff-90af-372c3ec22930:475 - 
2017-10-16 23:12:07 INFO 
IgniteKernal%ignite-jdbc-driver-ed1473ab-40b2-47ff-90af-372c3ec22930:475 -
To start Console Management & Monitoring run ignitevisorcmd.{sh|bat}
2017-10-16 23:12:07 INFO 
IgniteKernal%ignite-jdbc-driver-ed1473ab-40b2-47ff-90af-372c3ec22930:475 - 
2017-10-16 23:12:07 INFO 
IgniteKernal%ignite-jdbc-driver-ed1473ab-40b2-47ff-90af-372c3ec22930:475 - 

>>> +----------------------------------------------------------------------+
>>> Ignite ver. 2.1.0#20170721-sha1:a6ca5c8a97e9a4c9d73d40ce76d1504c14ba1940
>>> +----------------------------------------------------------------------+
>>> OS name: Windows 7 6.1 amd64
>>> CPU(s): 4
>>> Heap: 3.5GB
>>> VM name: 113872@tester-PC
>>> Ignite instance name:
>>> ignite-jdbc-driver-ed1473ab-40b2-47ff-90af-372c3ec22930
>>> Local node [ID=94AAEFFE-53DE-4814-981E-0D403A7A1EBE, order=2,
>>> clientMode=true]
>>> Local node addresses: [tester-PC/0:0:0:0:0:0:0:1, tester-PC/127.0.0.1,
>>> tester-PC/192.168.1.120, /2001:0:9d38:6ab8:185f:aff0:2222:6c0a,
>>> /2602:306:3276:770:4:6fb6:aba5:a557]
>>> Local ports: TCP:10801 TCP:47101 

2017-10-16 23:12:07 INFO  GridDiscoveryManager:475 - Topology snapshot
[ver=2, servers=1, clients=1, CPUs=4, heap=3.5GB]
2017-10-16 23:12:07 INFO  GridCacheProcessor:475 - Started cache
[name=am_jdbc, memoryPolicyName=null, mode=PARTITIONED, atomicity=ATOMIC]
2017-10-16 23:12:08 INFO  DataTransferDispatcher:106 - dropTableSQL=drop
table Sample_Superstore
2017-10-16 23:12:13 INFO  DataTransferDispatcher:107 - createTableSQL=create
table Sample_Superstore(Row_ID decimal, Order_ID varchar, Order_Date
timestamp, Ship_Date timestamp, Ship_Mode varchar, Customer_ID varchar,
Customer_Name varchar, Segment varchar, Country varchar, City varchar, State
varchar, Postal_Code decimal, Region varchar, Product_ID varchar, Category
varchar, Sub_Category varchar, Product_Name varchar, Sales decimal, Quantity
decimal, Discount decimal, Profit decimal, primary key (Row_ID)) with
"template=partitioned,backups=1"
2017-10-16 23:12:41 INFO  IgniteKernal:475 - 
Metrics for local node (to disable set 'metricsLogFrequency' to 0)
    ^-- Node [id=d586d8eb, name=null, uptime=00:07:00:040]
    ^-- H/N/C [hosts=1, nodes=2, CPUs=4]
    ^-- CPU [cur=0.13%, avg=2.59%, GC=0%]
    ^-- PageMemory [pages=12]
    ^-- Heap [used=163MB, free=95.5%, comm=1579MB]
    ^-- Non heap [used=114MB, free=-1%, comm=117MB]
    ^-- Public thread pool [active=0, idle=0, qSize=0]
    ^-- System thread pool [active=0, idle=7, qSize=0]
    ^-- Outbound messages queue [size=0]
2017-10-16 23:12:54 INFO  time:475 - Started exchange init
[topVer=AffinityTopologyVersion [topVer=2, minorTopVer=1], crd=true, evt=18,
node=TcpDiscoveryNode [id=d586d8eb-300b-44a1-915d-be60d5ab7848,
addrs=[0:0:0:0:0:0:0:1, 127.0.0.1, 192.168.1.120,
2001:0:9d38:6ab8:185f:aff0:2222:6c0a, 2602:306:3276:770:4:6fb6:aba5:a557],
sockAddrs=[tester-PC/192.168.1.120:47500, /0:0:0:0:0:0:0:1:47500,
/127.0.0.1:47500, /2001:0:9d38:6ab8:185f:aff0:2222:6c0a:47500,
/2602:306:3276:770:4:6fb6:aba5:a557:47500], discPort=47500, order=1,
intOrder=1, lastExchangeTime=1508166727802, loc=true,
ver=2.1.0#20170721-sha1:a6ca5c8a, isClient=false], evtNode=TcpDiscoveryNode
[id=d586d8eb-300b-44a1-915d-be60d5ab7848, addrs=[0:0:0:0:0:0:0:1, 127.0.0.1,
192.168.1.120, 2001:0:9d38:6ab8:185f:aff0:2222:6c0a,
2602:306:3276:770:4:6fb6:aba5:a557],
sockAddrs=[tester-PC/192.168.1.120:47500, /0:0:0:0:0:0:0:1:47500,
/127.0.0.1:47500, /2001:0:9d38:6ab8:185f:aff0:2222:6c0a:47500,
/2602:306:3276:770:4:6fb6:aba5:a557:47500], discPort=47500, order=1,
intOrder=1, lastExchangeTime=1508166727802, loc=true,
ver=2.1.0#20170721-sha1:a6ca5c8a, isClient=false],
customEvt=DynamicCacheChangeBatch
[id=f2ef7b52f51-e0b07e67-e383-41ae-9ddf-bbe9ed0831cb,
reqs=[DynamicCacheChangeRequest [cacheName=SQL_PUBLIC_SAMPLE_SUPERSTORE,
hasCfg=true, nodeId=94aaeffe-53de-4814-981e-0d403a7a1ebe,
clientStartOnly=false, stop=false, destroy=false]],
exchangeActions=ExchangeActions [startCaches=[SQL_PUBLIC_SAMPLE_SUPERSTORE],
stopCaches=null, startGrps=[SQL_PUBLIC_SAMPLE_SUPERSTORE], stopGrps=[],
resetParts=null, stateChangeRequest=null], startCaches=false]]
2017-10-16 23:12:54 INFO  time:475 - Started exchange init
[topVer=AffinityTopologyVersion [topVer=2, minorTopVer=1], crd=false,
evt=18, node=TcpDiscoveryNode [id=94aaeffe-53de-4814-981e-0d403a7a1ebe,
addrs=[0:0:0:0:0:0:0:1, 127.0.0.1, 192.168.1.120,
2001:0:9d38:6ab8:185f:aff0:2222:6c0a, 2602:306:3276:770:4:6fb6:aba5:a557],
sockAddrs=[tester-PC/192.168.1.120:0,
/2001:0:9d38:6ab8:185f:aff0:2222:6c0a:0, /0:0:0:0:0:0:0:1:0, /127.0.0.1:0,
/2602:306:3276:770:4:6fb6:aba5:a557:0], discPort=0, order=2, intOrder=0,
lastExchangeTime=1508166725704, loc=true, ver=2.1.0#20170721-sha1:a6ca5c8a,
isClient=true], evtNode=TcpDiscoveryNode
[id=94aaeffe-53de-4814-981e-0d403a7a1ebe, addrs=[0:0:0:0:0:0:0:1, 127.0.0.1,
192.168.1.120, 2001:0:9d38:6ab8:185f:aff0:2222:6c0a,
2602:306:3276:770:4:6fb6:aba5:a557], sockAddrs=[tester-PC/192.168.1.120:0,
/2001:0:9d38:6ab8:185f:aff0:2222:6c0a:0, /0:0:0:0:0:0:0:1:0, /127.0.0.1:0,
/2602:306:3276:770:4:6fb6:aba5:a557:0], discPort=0, order=2, intOrder=0,
lastExchangeTime=1508166725704, loc=true, ver=2.1.0#20170721-sha1:a6ca5c8a,
isClient=true], customEvt=DynamicCacheChangeBatch
[id=f2ef7b52f51-e0b07e67-e383-41ae-9ddf-bbe9ed0831cb,
reqs=[DynamicCacheChangeRequest [cacheName=SQL_PUBLIC_SAMPLE_SUPERSTORE,
hasCfg=true, nodeId=94aaeffe-53de-4814-981e-0d403a7a1ebe,
clientStartOnly=false, stop=false, destroy=false]],
exchangeActions=ExchangeActions [startCaches=[SQL_PUBLIC_SAMPLE_SUPERSTORE],
stopCaches=null, startGrps=[SQL_PUBLIC_SAMPLE_SUPERSTORE], stopGrps=[],
resetParts=null, stateChangeRequest=null], startCaches=false]]
2017-10-16 23:12:54 INFO  GridCacheProcessor:475 - Started cache
[name=SQL_PUBLIC_SAMPLE_SUPERSTORE, memoryPolicyName=null, mode=PARTITIONED,
atomicity=ATOMIC]
2017-10-16 23:12:54 INFO  GridDhtPartitionsExchangeFuture:475 - Snapshot
initialization completed [topVer=AffinityTopologyVersion [topVer=2,
minorTopVer=1], time=0ms]
2017-10-16 23:12:54 INFO  time:475 - Finished exchange init
[topVer=AffinityTopologyVersion [topVer=2, minorTopVer=1], crd=false]
2017-10-16 23:12:54 INFO  GridCacheProcessor:475 - Started cache
[name=SQL_PUBLIC_SAMPLE_SUPERSTORE, memoryPolicyName=default,
mode=PARTITIONED, atomicity=ATOMIC]
2017-10-16 23:12:54 INFO  GridDhtPartitionsExchangeFuture:475 - Finished
waiting for partition release future [topVer=AffinityTopologyVersion
[topVer=2, minorTopVer=1], waitTime=0ms]
2017-10-16 23:12:54 INFO  GridDhtPartitionsExchangeFuture:475 - Snapshot
initialization completed [topVer=AffinityTopologyVersion [topVer=2,
minorTopVer=1], time=0ms]
2017-10-16 23:12:54 INFO  time:475 - Finished exchange init
[topVer=AffinityTopologyVersion [topVer=2, minorTopVer=1], crd=true]
2017-10-16 23:12:54 INFO  GridCachePartitionExchangeManager:475 - Skipping
rebalancing (nothing scheduled) [top=AffinityTopologyVersion [topVer=2,
minorTopVer=1], evt=DISCOVERY_CUSTOM_EVT,
node=94aaeffe-53de-4814-981e-0d403a7a1ebe]
2017-10-16 23:12:54 INFO  GridDhtPartitionsExchangeFuture:475 - Snapshot
initialization completed [topVer=AffinityTopologyVersion [topVer=2,
minorTopVer=1], time=0ms]
2017-10-16 23:13:07 INFO 
IgniteKernal%ignite-jdbc-driver-ed1473ab-40b2-47ff-90af-372c3ec22930:475 - 
Metrics for local node (to disable set 'metricsLogFrequency' to 0)
    ^-- Node [id=94aaeffe,
name=ignite-jdbc-driver-ed1473ab-40b2-47ff-90af-372c3ec22930,
uptime=00:01:00:006]
    ^-- H/N/C [hosts=1, nodes=2, CPUs=4]
    ^-- CPU [cur=1.3%, avg=2.07%, GC=0%]
    ^-- PageMemory [pages=0]
    ^-- Heap [used=190MB, free=94.75%, comm=1579MB]
    ^-- Non heap [used=115MB, free=-1%, comm=118MB]
    ^-- Public thread pool [active=0, idle=0, qSize=0]
    ^-- System thread pool [active=0, idle=3, qSize=0]
    ^-- Outbound messages queue [size=0]
2017-10-16 23:13:23 INFO  DataTransferDispatcher:127 - create table sql
returns 0
2017-10-16 23:13:30 INFO  DataTransferDispatcher:141 - Ignite
insertSQL=insert into Sample_Superstore(Row_ID, Order_ID, Order_Date,
Ship_Date, Ship_Mode, Customer_ID, Customer_Name, Segment, Country, City,
State, Postal_Code, Region, Product_ID, Category, Sub_Category,
Product_Name, Sales, Quantity, Discount, Profit) values (?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2017-10-16 23:13:34 INFO  DataTransferDispatcher:142 - H2 selectSQL=select
Row_ID, Order_ID, Order_Date, Ship_Date, Ship_Mode, Customer_ID,
Customer_Name, Segment, Country, City, State, Postal_Code, Region,
Product_ID, Category, Sub_Category, Product_Name, Sales, Quantity, Discount,
Profit from Sample_Superstore
2017-10-16 23:13:41 INFO  IgniteKernal:475 - 
Metrics for local node (to disable set 'metricsLogFrequency' to 0)
    ^-- Node [id=d586d8eb, name=null, uptime=00:08:00:049]
    ^-- H/N/C [hosts=1, nodes=2, CPUs=4]
    ^-- CPU [cur=0.13%, avg=2.42%, GC=0%]
    ^-- PageMemory [pages=21]
    ^-- Heap [used=196MB, free=94.59%, comm=1579MB]
    ^-- Non heap [used=115MB, free=-1%, comm=118MB]
    ^-- Public thread pool [active=0, idle=1, qSize=0]
    ^-- System thread pool [active=0, idle=8, qSize=0]
    ^-- Outbound messages queue [size=0]
2017-10-16 23:14:07 INFO 
IgniteKernal%ignite-jdbc-driver-ed1473ab-40b2-47ff-90af-372c3ec22930:475 - 
Metrics for local node (to disable set 'metricsLogFrequency' to 0)
    ^-- Node [id=94aaeffe,
name=ignite-jdbc-driver-ed1473ab-40b2-47ff-90af-372c3ec22930,
uptime=00:02:00:013]
    ^-- H/N/C [hosts=1, nodes=2, CPUs=4]
    ^-- CPU [cur=0.13%, avg=1.48%, GC=0%]
    ^-- PageMemory [pages=0]
    ^-- Heap [used=204MB, free=94.37%, comm=1579MB]
    ^-- Non heap [used=116MB, free=-1%, comm=118MB]
    ^-- Public thread pool [active=0, idle=0, qSize=0]
    ^-- System thread pool [active=0, idle=0, qSize=0]
    ^-- Outbound messages queue [size=0]
2017-10-16 23:14:41 INFO  IgniteKernal:475 - 
Metrics for local node (to disable set 'metricsLogFrequency' to 0)
    ^-- Node [id=d586d8eb, name=null, uptime=00:09:00:057]
    ^-- H/N/C [hosts=1, nodes=2, CPUs=4]
    ^-- CPU [cur=0%, avg=2.31%, GC=0%]
    ^-- PageMemory [pages=21]
    ^-- Heap [used=210MB, free=94.2%, comm=1579MB]
    ^-- Non heap [used=116MB, free=-1%, comm=119MB]
    ^-- Public thread pool [active=0, idle=0, qSize=0]
    ^-- System thread pool [active=0, idle=6, qSize=0]
    ^-- Outbound messages queue [size=0]
2017-10-16 23:14:41 INFO  GridCacheDatabaseSharedManager:475 - Checkpoint
started [checkpointId=c97f4c99-4894-4029-b5b0-86384fe27f98,
startPtr=FileWALPointer [idx=0, fileOffset=103030, len=38719,
forceFlush=false], checkpointLockWait=0ms, checkpointLockHoldTime=3ms,
pages=9, reason='timeout']
2017-10-16 23:14:41 INFO  GridCacheDatabaseSharedManager:475 - Checkpoint
finished [cpId=c97f4c99-4894-4029-b5b0-86384fe27f98, pages=9,
markPos=FileWALPointer [idx=0, fileOffset=103030, len=38719,
forceFlush=false], walSegmentsCleared=0, markDuration=14ms, pagesWrite=2ms,
fsync=5ms, total=21ms]
2017-10-16 23:15:07 INFO 
IgniteKernal%ignite-jdbc-driver-ed1473ab-40b2-47ff-90af-372c3ec22930:475 - 
Metrics for local node (to disable set 'metricsLogFrequency' to 0)
    ^-- Node [id=94aaeffe,
name=ignite-jdbc-driver-ed1473ab-40b2-47ff-90af-372c3ec22930,
uptime=00:03:00:014]
    ^-- H/N/C [hosts=1, nodes=2, CPUs=4]
    ^-- CPU [cur=0.4%, avg=1.36%, GC=0%]
    ^-- PageMemory [pages=0]
    ^-- Heap [used=217MB, free=94.01%, comm=1579MB]
    ^-- Non heap [used=116MB, free=-1%, comm=119MB]
    ^-- Public thread pool [active=0, idle=0, qSize=0]
    ^-- System thread pool [active=0, idle=0, qSize=0]
    ^-- Outbound messages queue [size=0]
2017-10-16 23:15:41 INFO  IgniteKernal:475 - 
Metrics for local node (to disable set 'metricsLogFrequency' to 0)
    ^-- Node [id=d586d8eb, name=null, uptime=00:10:00:062]
    ^-- H/N/C [hosts=1, nodes=2, CPUs=4]
    ^-- CPU [cur=0%, avg=2.24%, GC=0%]
    ^-- PageMemory [pages=21]
    ^-- Heap [used=224MB, free=93.81%, comm=1579MB]
    ^-- Non heap [used=117MB, free=-1%, comm=119MB]
    ^-- Public thread pool [active=0, idle=0, qSize=0]
    ^-- System thread pool [active=0, idle=6, qSize=0]
    ^-- Outbound messages queue [size=0]
2017-10-16 23:15:47 INFO  GridDiscoveryManager:475 - Node left topology:
TcpDiscoveryNode [id=94aaeffe-53de-4814-981e-0d403a7a1ebe,
addrs=[0:0:0:0:0:0:0:1, 127.0.0.1, 192.168.1.120,
2001:0:9d38:6ab8:185f:aff0:2222:6c0a, 2602:306:3276:770:4:6fb6:aba5:a557],
sockAddrs=[tester-PC/192.168.1.120:0,
/2001:0:9d38:6ab8:185f:aff0:2222:6c0a:0, /0:0:0:0:0:0:0:1:0, /127.0.0.1:0,
/2602:306:3276:770:4:6fb6:aba5:a557:0], discPort=0, order=2, intOrder=2,
lastExchangeTime=1508166727792, loc=false, ver=2.1.0#20170721-sha1:a6ca5c8a,
isClient=true]
2017-10-16 23:15:47 INFO  GridDiscoveryManager:475 - Topology snapshot
[ver=3, servers=1, clients=0, CPUs=4, heap=3.5GB]
2017-10-16 23:15:47 INFO  time:475 - Started exchange init
[topVer=AffinityTopologyVersion [topVer=3, minorTopVer=0], crd=true, evt=11,
node=TcpDiscoveryNode [id=d586d8eb-300b-44a1-915d-be60d5ab7848,
addrs=[0:0:0:0:0:0:0:1, 127.0.0.1, 192.168.1.120,
2001:0:9d38:6ab8:185f:aff0:2222:6c0a, 2602:306:3276:770:4:6fb6:aba5:a557],
sockAddrs=[tester-PC/192.168.1.120:47500, /0:0:0:0:0:0:0:1:47500,
/127.0.0.1:47500, /2001:0:9d38:6ab8:185f:aff0:2222:6c0a:47500,
/2602:306:3276:770:4:6fb6:aba5:a557:47500], discPort=47500, order=1,
intOrder=1, lastExchangeTime=1508166947338, loc=true,
ver=2.1.0#20170721-sha1:a6ca5c8a, isClient=false], evtNode=TcpDiscoveryNode
[id=d586d8eb-300b-44a1-915d-be60d5ab7848, addrs=[0:0:0:0:0:0:0:1, 127.0.0.1,
192.168.1.120, 2001:0:9d38:6ab8:185f:aff0:2222:6c0a,
2602:306:3276:770:4:6fb6:aba5:a557],
sockAddrs=[tester-PC/192.168.1.120:47500, /0:0:0:0:0:0:0:1:47500,
/127.0.0.1:47500, /2001:0:9d38:6ab8:185f:aff0:2222:6c0a:47500,
/2602:306:3276:770:4:6fb6:aba5:a557:47500], discPort=47500, order=1,
intOrder=1, lastExchangeTime=1508166947338, loc=true,
ver=2.1.0#20170721-sha1:a6ca5c8a, isClient=false], customEvt=null]
2017-10-16 23:15:47 INFO  GridDhtPartitionsExchangeFuture:475 - Snapshot
initialization completed [topVer=AffinityTopologyVersion [topVer=3,
minorTopVer=0], time=0ms]
2017-10-16 23:15:47 INFO  GridCacheProcessor:475 - Stopped cache
[cacheName=ignite-sys-cache]
2017-10-16 23:15:47 INFO  GridCacheProcessor:475 - Stopped cache
[cacheName=SQL_PUBLIC_SAMPLE_SUPERSTORE]
2017-10-16 23:15:47 INFO  time:475 - Finished exchange init
[topVer=AffinityTopologyVersion [topVer=3, minorTopVer=0], crd=true]
2017-10-16 23:15:47 INFO  GridCacheProcessor:475 - Stopped cache
[cacheName=am_jdbc]
2017-10-16 23:15:47 INFO  GridCachePartitionExchangeManager:475 - Skipping
rebalancing (nothing scheduled) [top=AffinityTopologyVersion [topVer=3,
minorTopVer=0], evt=NODE_LEFT, node=94aaeffe-53de-4814-981e-0d403a7a1ebe]
2017-10-16 23:15:47 INFO  GridDeploymentLocalStore:475 - Removed undeployed
class: GridDeployment [ts=1508166727945, depMode=SHARED,
clsLdr=WebAppClassLoader=1946866478@740ad32e,
clsLdrId=c1df7b52f51-94aaeffe-53de-4814-981e-0d403a7a1ebe, userVer=0,
loc=true,
sampleClsName=org.apache.ignite.internal.processors.cache.distributed.dht.preloader.GridDhtPartitionFullMap,
pendingUndeploy=false, undeployed=true, usage=0]
2017-10-16 23:15:47 INFO 
IgniteKernal%ignite-jdbc-driver-ed1473ab-40b2-47ff-90af-372c3ec22930:475 - 

>>> +---------------------------------------------------------------------------------+
>>> Ignite ver. 2.1.0#20170721-sha1:a6ca5c8a97e9a4c9d73d40ce76d1504c14ba1940
>>> stopped OK
>>> +---------------------------------------------------------------------------------+
>>> Ignite instance name:
>>> ignite-jdbc-driver-ed1473ab-40b2-47ff-90af-372c3ec22930
>>> Grid uptime: 00:03:39:443


2017-10-16 23:16:41 INFO  IgniteKernal:475 - 
Metrics for local node (to disable set 'metricsLogFrequency' to 0)
    ^-- Node [id=d586d8eb, name=null, uptime=00:11:00:063]
    ^-- H/N/C [hosts=1, nodes=1, CPUs=4]
    ^-- CPU [cur=0%, avg=2.09%, GC=0%]
    ^-- PageMemory [pages=21]
    ^-- Heap [used=256MB, free=92.94%, comm=1579MB]
    ^-- Non heap [used=117MB, free=-1%, comm=120MB]
    ^-- Public thread pool [active=0, idle=2, qSize=0]
    ^-- System thread pool [active=0, idle=7, qSize=0]
    ^-- Outbound messages queue [size=0]
2017-10-16 23:17:41 INFO  IgniteKernal:475 - 
Metrics for local node (to disable set 'metricsLogFrequency' to 0)
    ^-- Node [id=d586d8eb, name=null, uptime=00:12:00:064]
    ^-- H/N/C [hosts=1, nodes=1, CPUs=4]
    ^-- CPU [cur=0%, avg=2%, GC=0%]
    ^-- PageMemory [pages=21]
    ^-- Heap [used=272MB, free=92.49%, comm=1579MB]
    ^-- Non heap [used=117MB, free=-1%, comm=120MB]
    ^-- Public thread pool [active=0, idle=0, qSize=0]
    ^-- System thread pool [active=0, idle=6, qSize=0]
    ^-- Outbound messages queue [size=0]
2017-10-16 23:17:41 INFO  GridCacheDatabaseSharedManager:475 - Skipping
checkpoint (no pages were modified) [checkpointLockWait=0ms,
checkpointLockHoldTime=4ms, reason='timeout']
2017-10-16 23:18:41 INFO  IgniteKernal:475 - 
Metrics for local node (to disable set 'metricsLogFrequency' to 0)
    ^-- Node [id=d586d8eb, name=null, uptime=00:13:00:073]
    ^-- H/N/C [hosts=1, nodes=1, CPUs=4]
    ^-- CPU [cur=0%, avg=1.9%, GC=0%]
    ^-- PageMemory [pages=21]
    ^-- Heap [used=285MB, free=92.13%, comm=1579MB]
    ^-- Non heap [used=117MB, free=-1%, comm=120MB]
    ^-- Public thread pool [active=0, idle=0, qSize=0]
    ^-- System thread pool [active=0, idle=6, qSize=0]
    ^-- Outbound messages queue [size=0]
2017-10-16 23:19:41 INFO  IgniteKernal:475 - 
Metrics for local node (to disable set 'metricsLogFrequency' to 0)
    ^-- Node [id=d586d8eb, name=null, uptime=00:14:00:079]
    ^-- H/N/C [hosts=1, nodes=1, CPUs=4]
    ^-- CPU [cur=0%, avg=1.82%, GC=0%]
    ^-- PageMemory [pages=21]
    ^-- Heap [used=294MB, free=91.89%, comm=1579MB]
    ^-- Non heap [used=117MB, free=-1%, comm=120MB]
    ^-- Public thread pool [active=0, idle=0, qSize=0]
    ^-- System thread pool [active=0, idle=6, qSize=0]
    ^-- Outbound messages queue [size=0]
2017-10-16 23:20:41 INFO  IgniteKernal:475 - 
Metrics for local node (to disable set 'metricsLogFrequency' to 0)
    ^-- Node [id=d586d8eb, name=null, uptime=00:15:00:088]
    ^-- H/N/C [hosts=1, nodes=1, CPUs=4]
    ^-- CPU [cur=0%, avg=1.74%, GC=0%]
    ^-- PageMemory [pages=21]
    ^-- Heap [used=301MB, free=91.69%, comm=1579MB]
    ^-- Non heap [used=117MB, free=-1%, comm=120MB]
    ^-- Public thread pool [active=0, idle=0, qSize=0]
    ^-- System thread pool [active=0, idle=6, qSize=0]
    ^-- Outbound messages queue [size=0]
2017-10-16 23:20:41 INFO  GridCacheDatabaseSharedManager:475 - Skipping
checkpoint (no pages were modified) [checkpointLockWait=0ms,
checkpointLockHoldTime=2ms, reason='timeout']
2017-10-16 23:21:41 INFO  IgniteKernal:475 - 
Metrics for local node (to disable set 'metricsLogFrequency' to 0)
    ^-- Node [id=d586d8eb, name=null, uptime=00:16:00:089]
    ^-- H/N/C [hosts=1, nodes=1, CPUs=4]
    ^-- CPU [cur=0%, avg=1.68%, GC=0%]
    ^-- PageMemory [pages=21]
    ^-- Heap [used=310MB, free=91.45%, comm=1579MB]
    ^-- Non heap [used=117MB, free=-1%, comm=120MB]
    ^-- Public thread pool [active=0, idle=0, qSize=0]
    ^-- System thread pool [active=0, idle=6, qSize=0]
    ^-- Outbound messages queue [size=0]
2017-10-16 23:22:41 INFO  IgniteKernal:475 - 
Metrics for local node (to disable set 'metricsLogFrequency' to 0)
    ^-- Node [id=d586d8eb, name=null, uptime=00:17:00:097]
    ^-- H/N/C [hosts=1, nodes=1, CPUs=4]
    ^-- CPU [cur=0%, avg=1.62%, GC=0%]
    ^-- PageMemory [pages=21]
    ^-- Heap [used=319MB, free=91.21%, comm=1579MB]
    ^-- Non heap [used=117MB, free=-1%, comm=120MB]
    ^-- Public thread pool [active=0, idle=0, qSize=0]
    ^-- System thread pool [active=0, idle=6, qSize=0]
    ^-- Outbound messages queue [size=0]





--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Mime
View raw message