You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ignite.apache.org by Philippe CEROU <ph...@gfi.fr> on 2019/02/06 15:12:40 UTC
Insert failover on cluster with Java JDBC client do not seems to run.
Hi,
We are testing Ignite failover capabilities and it seems that if we create a table in a replicated/partitioned region and then we proceed to insertion we experiment insertion exception.
When a collection of 100 rows insertion statements fail we try again three time in a loop reconnecting at third try.
Any idea ?
Test log :
Wed Feb 06 15:55:37 CET 2019 [TRC] Connect to : jdbc:ignite:thin://nx101c,nx102a,nx103b/KSDATA?user=CLUSER&password=clpassword
Wed Feb 06 15:55:38 CET 2019 [TRC] Connected.
Wed Feb 06 15:55:38 CET 2019 [TRC] Diconnecting.
Wed Feb 06 15:55:38 CET 2019 [TRC] Diconnected.
Wed Feb 06 15:55:38 CET 2019 [INF] ---------------------------------------------------------
Wed Feb 06 15:55:38 CET 2019 [INF] Amorce test [1 x 1000 : 100], itération #1
Wed Feb 06 15:55:38 CET 2019 [INF] Suppression de la table de travail.
Wed Feb 06 15:55:38 CET 2019 [TRC] Diconnecting.
Wed Feb 06 15:55:38 CET 2019 [WRN] Try to close closed/non-existent connection.
Wed Feb 06 15:55:38 CET 2019 [TRC] Connect to : jdbc:ignite:thin://nx101c,nx102a,nx103b/KSDATA?user=CLUSER&password=clpassword
Wed Feb 06 15:55:38 CET 2019 [TRC] Connected.
Wed Feb 06 15:55:38 CET 2019 [TRC] Run query : drop table if exists benchmark
Wed Feb 06 15:55:38 CET 2019 [TRC] Query executed.
Wed Feb 06 15:55:38 CET 2019 [TRC] Committing.
Wed Feb 06 15:55:39 CET 2019 [TRC] Committed.
Wed Feb 06 15:55:39 CET 2019 [TRC] Diconnecting.
Wed Feb 06 15:55:39 CET 2019 [TRC] Diconnected.
Wed Feb 06 15:55:39 CET 2019 [INF] Création instance SSH.
Wed Feb 06 15:55:39 CET 2019 [INF] Purge de la base de données.
Wed Feb 06 15:55:39 CET 2019 [INF] Création de la table de travail.
Wed Feb 06 15:55:39 CET 2019 [TRC] Diconnecting.
Wed Feb 06 15:55:39 CET 2019 [WRN] Try to close closed/non-existent connection.
Wed Feb 06 15:55:39 CET 2019 [TRC] Connect to : jdbc:ignite:thin://nx101c,nx102a,nx103b/KSDATA?user=CLUSER&password=clpassword
Wed Feb 06 15:55:39 CET 2019 [WRN] Connection error, retry.
Wed Feb 06 15:55:40 CET 2019 [TRC] Connect to : jdbc:ignite:thin://nx101c,nx102a,nx103b/KSDATA?user=CLUSER&password=clpassword
Wed Feb 06 15:55:40 CET 2019 [TRC] Connected.
Wed Feb 06 15:55:40 CET 2019 [TRC] Run query : create table benchmark (id NUMERIC(10) primary key,C001 VARCHAR(30),C002 float,C003 float,C004 NUMERIC(10),C005 NUMERIC(10),C006 NUMERIC(10),C007 NUMERIC(10),C008 NUMERIC(10),C009 VARCHAR(30),C010 VARCHAR(30),C011 DATE,C012 VARCHAR(30),C013 VARCHAR(30),C014 VARCHAR(30),C015 NUMERIC(10),C016 float,C017 VARCHAR(30),C018 VARCHAR(30),C019 VARCHAR(30)) WITH "BACKUPS=1, WRITE_SYNCHRONIZATION_MODE=FULL_ASYNC, ATOMICITY=ATOMIC, AFFINITYKEY=id"
Wed Feb 06 15:55:40 CET 2019 [TRC] Query executed.
Wed Feb 06 15:55:40 CET 2019 [TRC] Committing.
Wed Feb 06 15:55:40 CET 2019 [TRC] Committed.
Wed Feb 06 15:55:40 CET 2019 [TRC] Run query : create index benchmarkc001 on benchmark(c001)
Wed Feb 06 15:55:40 CET 2019 [TRC] Query executed.
Wed Feb 06 15:55:40 CET 2019 [TRC] Committing.
Wed Feb 06 15:55:40 CET 2019 [TRC] Committed.
Wed Feb 06 15:55:40 CET 2019 [TRC] Run query : create index benchmarkc002 on benchmark(c002)
Wed Feb 06 15:55:40 CET 2019 [TRC] Query executed.
Wed Feb 06 15:55:40 CET 2019 [TRC] Committing.
Wed Feb 06 15:55:40 CET 2019 [TRC] Committed.
Wed Feb 06 15:55:40 CET 2019 [TRC] Run query : create index benchmarkc003 on benchmark(c003)
Wed Feb 06 15:55:40 CET 2019 [TRC] Query executed.
Wed Feb 06 15:55:40 CET 2019 [TRC] Committing.
Wed Feb 06 15:55:40 CET 2019 [TRC] Committed.
Wed Feb 06 15:55:40 CET 2019 [TRC] Run query : create index benchmarkc011 on benchmark(c011)
Wed Feb 06 15:55:40 CET 2019 [TRC] Query executed.
Wed Feb 06 15:55:40 CET 2019 [TRC] Committing.
Wed Feb 06 15:55:40 CET 2019 [TRC] Committed.
Wed Feb 06 15:55:40 CET 2019 [TRC] Diconnecting.
Wed Feb 06 15:55:40 CET 2019 [TRC] Diconnected.
Wed Feb 06 15:55:41 CET 2019 [INF] Relance du cluster.
Wed Feb 06 15:55:42 CET 2019 [INF] Initialisation indicateurs
Wed Feb 06 15:55:42 CET 2019 [INF] Préparation des processus.
Wed Feb 06 15:55:42 CET 2019 [TRC] Connect to : jdbc:ignite:thin://nx101c,nx102a,nx103b/KSDATA?user=CLUSER&password=clpassword
Wed Feb 06 15:55:43 CET 2019 [TRC] Connected.
Wed Feb 06 15:55:43 CET 2019 [INF] Activation des processus.
Wed Feb 06 15:55:43 CET 2019 [INF] Progress : 0%
Wed Feb 06 15:55:43 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[1, 78076E, 35.39261, -120.0947, 328, 30000, 462, 7246, 200, B77W, B-2088, Tue Oct 16 07:56:30 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
Wed Feb 06 15:55:43 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[5, 78076E, 34.77266, -119.643, 329, 29900, 452, 7246, 200, B77W, B-2088, Tue Oct 16 07:50:51 UTC 2018, LAX, PEK, CA984, 0, 1152.0, 0000000, null, 0]]
Wed Feb 06 15:55:44 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[9, 78076E, 35.37574, -120.08237, 328, 30000, 462, 7246, 200, B77W, B-2088, Tue Oct 16 07:56:21 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
Wed Feb 06 15:55:45 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[30, 78076E, 35.73808, -120.35001, 328, 30000, 461, 7246, 5000, B77W, B-2088, Tue Oct 16 07:59:39 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
Wed Feb 06 15:55:45 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[35, 78076E, 35.14856, -119.91589, 329, 30000, 459, 7246, 200, B77W, B-2088, Tue Oct 16 07:54:16 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
Wed Feb 06 15:55:46 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[47, 78076E, 35.25854, -119.99635, 328, 30000, 462, 7246, 200, B77W, B-2088, Tue Oct 16 07:55:17 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
Wed Feb 06 15:55:46 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[49, 78076E, 34.77266, -119.643, 329, 29900, 452, 7246, 200, B77W, B-2088, Tue Oct 16 07:50:51 UTC 2018, LAX, PEK, CA984, 0, 1152.0, 0000000, null, 0]]
Wed Feb 06 15:55:47 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[61, 78076E, 35.02721, -119.82754, 329, 30000, 457, 7246, 200, B77W, B-2088, Tue Oct 16 07:53:11 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
Wed Feb 06 15:55:48 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[83, 78076E, 34.81073, -119.67054, 329, 30000, 457, 7246, 200, B77W, B-2088, Tue Oct 16 07:51:11 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
Wed Feb 06 15:55:48 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[94, 78076E, 35.17044, -119.93186, 328, 30000, 459, 7246, 200, B77W, B-2088, Tue Oct 16 07:54:28 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
Wed Feb 06 15:55:48 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[96, 78076E, 35.15988, -119.92412, 328, 30000, 459, 7246, 200, B77W, B-2088, Tue Oct 16 07:54:23 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
Wed Feb 06 15:55:48 CET 2019 [TRC] Close statement.
Wed Feb 06 15:55:48 CET 2019 [TRC] Rollback.
Wed Feb 06 15:55:48 CET 2019 [TRC] Rollbacked.
Wed Feb 06 15:55:48 CET 2019 [WRN] Sleep & retry.
Wed Feb 06 15:55:49 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[1, 78076E, 35.39261, -120.0947, 328, 30000, 462, 7246, 200, B77W, B-2088, Tue Oct 16 07:56:30 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
Wed Feb 06 15:55:50 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[5, 78076E, 34.77266, -119.643, 329, 29900, 452, 7246, 200, B77W, B-2088, Tue Oct 16 07:50:51 UTC 2018, LAX, PEK, CA984, 0, 1152.0, 0000000, null, 0]]
Wed Feb 06 15:55:50 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[9, 78076E, 35.37574, -120.08237, 328, 30000, 462, 7246, 200, B77W, B-2088, Tue Oct 16 07:56:21 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
Wed Feb 06 15:55:51 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[30, 78076E, 35.73808, -120.35001, 328, 30000, 461, 7246, 5000, B77W, B-2088, Tue Oct 16 07:59:39 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
Wed Feb 06 15:55:51 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[35, 78076E, 35.14856, -119.91589, 329, 30000, 459, 7246, 200, B77W, B-2088, Tue Oct 16 07:54:16 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
Wed Feb 06 15:55:51 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[47, 78076E, 35.25854, -119.99635, 328, 30000, 462, 7246, 200, B77W, B-2088, Tue Oct 16 07:55:17 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
Wed Feb 06 15:55:51 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[49, 78076E, 34.77266, -119.643, 329, 29900, 452, 7246, 200, B77W, B-2088, Tue Oct 16 07:50:51 UTC 2018, LAX, PEK, CA984, 0, 1152.0, 0000000, null, 0]]
Wed Feb 06 15:55:52 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[61, 78076E, 35.02721, -119.82754, 329, 30000, 457, 7246, 200, B77W, B-2088, Tue Oct 16 07:53:11 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
Wed Feb 06 15:55:53 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[83, 78076E, 34.81073, -119.67054, 329, 30000, 457, 7246, 200, B77W, B-2088, Tue Oct 16 07:51:11 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
Wed Feb 06 15:55:53 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[94, 78076E, 35.17044, -119.93186, 328, 30000, 459, 7246, 200, B77W, B-2088, Tue Oct 16 07:54:28 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
Wed Feb 06 15:55:53 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[96, 78076E, 35.15988, -119.92412, 328, 30000, 459, 7246, 200, B77W, B-2088, Tue Oct 16 07:54:23 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
Wed Feb 06 15:55:54 CET 2019 [TRC] Close statement.
Wed Feb 06 15:55:54 CET 2019 [TRC] Rollback.
Wed Feb 06 15:55:54 CET 2019 [TRC] Rollbacked.
Wed Feb 06 15:55:54 CET 2019 [WRN] Sleep & retry.
Wed Feb 06 15:55:55 CET 2019 [TRC] Diconnecting.
Wed Feb 06 15:55:55 CET 2019 [TRC] Diconnected.
Wed Feb 06 15:55:55 CET 2019 [TRC] Connect to : jdbc:ignite:thin://nx101c,nx102a,nx103b/KSDATA?user=CLUSER&password=clpassword
Wed Feb 06 15:55:55 CET 2019 [WRN] Connection error, retry.
Wed Feb 06 15:55:56 CET 2019 [TRC] Connect to : jdbc:ignite:thin://nx101c,nx102a,nx103b/KSDATA?user=CLUSER&password=clpassword
Wed Feb 06 15:55:56 CET 2019 [TRC] Connected.
Wed Feb 06 15:55:56 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[1, 78076E, 35.39261, -120.0947, 328, 30000, 462, 7246, 200, B77W, B-2088, Tue Oct 16 07:56:30 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
Wed Feb 06 15:55:56 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[5, 78076E, 34.77266, -119.643, 329, 29900, 452, 7246, 200, B77W, B-2088, Tue Oct 16 07:50:51 UTC 2018, LAX, PEK, CA984, 0, 1152.0, 0000000, null, 0]]
Wed Feb 06 15:55:56 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[9, 78076E, 35.37574, -120.08237, 328, 30000, 462, 7246, 200, B77W, B-2088, Tue Oct 16 07:56:21 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
Wed Feb 06 15:55:57 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[30, 78076E, 35.73808, -120.35001, 328, 30000, 461, 7246, 5000, B77W, B-2088, Tue Oct 16 07:59:39 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
Wed Feb 06 15:55:57 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[35, 78076E, 35.14856, -119.91589, 329, 30000, 459, 7246, 200, B77W, B-2088, Tue Oct 16 07:54:16 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
Wed Feb 06 15:55:58 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[47, 78076E, 35.25854, -119.99635, 328, 30000, 462, 7246, 200, B77W, B-2088, Tue Oct 16 07:55:17 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
Wed Feb 06 15:55:58 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[49, 78076E, 34.77266, -119.643, 329, 29900, 452, 7246, 200, B77W, B-2088, Tue Oct 16 07:50:51 UTC 2018, LAX, PEK, CA984, 0, 1152.0, 0000000, null, 0]]
Wed Feb 06 15:55:59 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[61, 78076E, 35.02721, -119.82754, 329, 30000, 457, 7246, 200, B77W, B-2088, Tue Oct 16 07:53:11 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
Wed Feb 06 15:56:00 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[83, 78076E, 34.81073, -119.67054, 329, 30000, 457, 7246, 200, B77W, B-2088, Tue Oct 16 07:51:11 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
Wed Feb 06 15:56:00 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[94, 78076E, 35.17044, -119.93186, 328, 30000, 459, 7246, 200, B77W, B-2088, Tue Oct 16 07:54:28 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
Wed Feb 06 15:56:00 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[96, 78076E, 35.15988, -119.92412, 328, 30000, 459, 7246, 200, B77W, B-2088, Tue Oct 16 07:54:23 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
Wed Feb 06 15:56:01 CET 2019 [TRC] Close statement.
Wed Feb 06 15:56:01 CET 2019 [TRC] Rollback.
Wed Feb 06 15:56:01 CET 2019 [TRC] Rollbacked.
Wed Feb 06 15:56:01 CET 2019 [WRN] Sleep & retry.
Wed Feb 06 15:56:02 CET 2019 [TRC] Diconnecting.
Wed Feb 06 15:56:02 CET 2019 [TRC] Diconnected.
Wed Feb 06 15:56:02 CET 2019 [TRC] Connect to : jdbc:ignite:thin://nx101c,nx102a,nx103b/KSDATA?user=CLUSER&password=clpassword
Wed Feb 06 15:56:02 CET 2019 [TRC] Connected.
Wed Feb 06 15:56:02 CET 2019 [ERR] Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[96, 78076E, 35.15988, -119.92412, 328, 30000, 459, 7246, 200, B77W, B-2088, Tue Oct 16 07:54:23 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
Wed Feb 06 15:56:02 CET 2019 [INF] Progress : 10%
...
Wed Feb 06 15:58:44 CET 2019 [TRC] Diconnecting.
Wed Feb 06 15:58:44 CET 2019 [TRC] Diconnected.
Wed Feb 06 15:58:44 CET 2019 [INF] Progress : 100%
Wed Feb 06 15:58:44 CET 2019 [INF] Durée : 180801ms
Wed Feb 06 15:58:44 CET 2019 [INF] Metrics : 1 ; 1000 ; 100 ; 1 ; 180801
Wed Feb 06 15:58:44 CET 2019 [INF] Purge des processus.
Wed Feb 06 15:58:44 CET 2019 [INF] Synchronisation des disques du cluster.
Wed Feb 06 15:58:44 CET 2019 [TRC] Diconnecting.
Wed Feb 06 15:58:44 CET 2019 [WRN] Try to close closed/non-existent connection.
Wed Feb 06 15:58:44 CET 2019 [INF] Relance du cluster.
Wed Feb 06 15:58:44 CET 2019 [INF] Récupération des derniers indicateurs systéme.
Wed Feb 06 15:58:44 CET 2019 [INF] Sauvegarde des données.
Wed Feb 06 15:58:44 CET 2019 [INF] FILEOUTPUT : results/benchmark.insert_csv_1_1000_100_ignite-jdbc_nx101c,nx102a,nx103b_KSDATA.ser
Wed Feb 06 15:58:44 CET 2019 [INF] Fin du test.
Wed Feb 06 15:58:44 CET 2019 [INF] ---------------------------------------------------------
Wed Feb 06 15:58:44 CET 2019 [TRC] Diconnecting.
Wed Feb 06 15:58:44 CET 2019 [WRN] Try to close closed/non-existent connection.
If we control DATA :
0: jdbc:ignite:thin://nx102a:10800> select count(*) from KSDATA.BENCHMARK;
+--------------------------------+
| COUNT(*) |
+--------------------------------+
| 899 |
+--------------------------------+
1 row selected (0.01 seconds)
We have only 899 rows versus 1 000 inserted !
Cordialement,
-
NOTE : n/a
-
Gfi Informatique
Philippe Cerou
Architecte & Expert Système
GFI Production / Toulouse
philippe.cerou @gfi.fr
-
1 Rond-point du Général Eisenhower, 31400 Toulouse
Tél. : +33 (0)5.62.85.11.55
Mob. : +33 (0)6.03.56.48.62
www.gfi.world<http://www.gfi.world/>
-
[Facebook]<https://www.facebook.com/gfiinformatique> [Twitter] <https://twitter.com/gfiinformatique> [Instagram] <https://www.instagram.com/gfiinformatique/> [LinkedIn] <https://www.linkedin.com/company/gfi-informatique> [YouTube] <https://www.youtube.com/user/GFIinformatique>
-
[cid:image006.jpg@01D2F97F.AA6ABB50]<http://www.gfi.world/>
Re: Insert failover on cluster with Java JDBC client do not seems to run.
Posted by Ilya Kasnacheev <il...@gmail.com>.
Hello!
See 'excludeNeighbors' implementation for this. By default it will exclude
nodes running on same machine but I guess you could make something DC-aware
out of it.
Regards,
--
Ilya Kasnacheev
пт, 15 февр. 2019 г. в 18:34, Philippe CEROU <ph...@gfi.fr>:
> Hi,
>
>
>
> In fact I found that in one node logs :
>
>
>
> [14:12:04,767][SEVERE][client-connector-#69][JdbcRequestHandler] Failed to
> execute SQL query [reqId=0, req=JdbcQueryExecuteRequest [schemaName=KSDATA,
> pageSize=1024, maxRows=0, sqlQry=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), args=[5908856, A3244F,
> 32.94908, -96.7905, 143, 10050, 312, 6227, 5000, B738, N301PA, Tue Oct 16
> 22:06:43 UTC 2018, DFW, GUA, AA1013, 0, 1152.0, AAL1013, null, 1539737840],
> stmtType=ANY_STATEMENT_TYPE, autoCommit=false]]
>
> class org.apache.ignite.internal.processors.query.IgniteSQLException:
> Failed to execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[5908856, A3244F,
> 32.94908, -96.7905, 143, 10050, 312, 6227, 5000, B738, N301PA, Tue Oct 16
> 22:06:43 UTC 2018, DFW, GUA, AA1013, 0, 1152.0, AAL1013, null, 1539737840]]
>
> at
> org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.doRunPrepared(IgniteH2Indexing.java:2284)
>
> at
> org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.querySqlFields(IgniteH2Indexing.java:2178)
>
> at
> org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:2135)
>
> at
> org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:2130)
>
> at
> org.apache.ignite.internal.util.lang.IgniteOutClosureX.apply(IgniteOutClosureX.java:36)
>
> at
> org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:2707)
>
> at
> org.apache.ignite.internal.processors.query.GridQueryProcessor.querySqlFields(GridQueryProcessor.java:2144)
>
> 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.JdbcRequestHandler.handle(JdbcRequestHandler.java:208)
>
> at
> org.apache.ignite.internal.processors.odbc.ClientListenerNioListener.onMessage(ClientListenerNioListener.java:162)
>
> at
> org.apache.ignite.internal.processors.odbc.ClientListenerNioListener.onMessage(ClientListenerNioListener.java:45)
>
> at
> org.apache.ignite.internal.util.nio.GridNioFilterChain$TailFilter.onMessageReceived(GridNioFilterChain.java:279)
>
> at
> org.apache.ignite.internal.util.nio.GridNioFilterAdapter.proceedMessageReceived(GridNioFilterAdapter.java:109)
>
> at
> org.apache.ignite.internal.util.nio.GridNioAsyncNotifyFilter$3.body(GridNioAsyncNotifyFilter.java:97)
>
> at
> org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:120)
>
> at
> org.apache.ignite.internal.util.worker.GridWorkerPool$1.run(GridWorkerPool.java:70)
>
> 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)
>
> Caused by: class
> org.apache.ignite.internal.cluster.ClusterTopologyServerNotFoundException:
> Failed to map keys for cache (all partition nodes left the grid).
>
> at
> org.apache.ignite.internal.processors.cache.distributed.dht.atomic.GridNearAtomicSingleUpdateFuture.mapSingleUpdate(GridNearAtomicSingleUpdateFuture.java:562)
>
> at
> org.apache.ignite.internal.processors.cache.distributed.dht.atomic.GridNearAtomicSingleUpdateFuture.map(GridNearAtomicSingleUpdateFuture.java:454)
>
> at
> org.apache.ignite.internal.processors.cache.distributed.dht.atomic.GridNearAtomicSingleUpdateFuture.mapOnTopology(GridNearAtomicSingleUpdateFuture.java:443)
>
> at
> org.apache.ignite.internal.processors.cache.distributed.dht.atomic.GridNearAtomicAbstractUpdateFuture.map(GridNearAtomicAbstractUpdateFuture.java:248)
>
> at
> org.apache.ignite.internal.processors.cache.distributed.dht.atomic.GridDhtAtomicCache.update0(GridDhtAtomicCache.java:1153)
>
> at
> org.apache.ignite.internal.processors.cache.distributed.dht.atomic.GridDhtAtomicCache.put0(GridDhtAtomicCache.java:611)
>
> at
> org.apache.ignite.internal.processors.cache.GridCacheAdapter.put(GridCacheAdapter.java:2449)
>
> at
> org.apache.ignite.internal.processors.cache.GridCacheAdapter.putIfAbsent(GridCacheAdapter.java:2876)
>
> at
> org.apache.ignite.internal.processors.query.h2.DmlStatementsProcessor.doInsert(DmlStatementsProcessor.java:925)
>
> at
> org.apache.ignite.internal.processors.query.h2.DmlStatementsProcessor.processDmlSelectResult(DmlStatementsProcessor.java:704)
>
> at
> org.apache.ignite.internal.processors.query.h2.DmlStatementsProcessor.executeUpdateStatement(DmlStatementsProcessor.java:653)
>
> at
> org.apache.ignite.internal.processors.query.h2.DmlStatementsProcessor.updateSqlFields(DmlStatementsProcessor.java:185)
>
> at
> org.apache.ignite.internal.processors.query.h2.DmlStatementsProcessor.updateSqlFieldsDistributed(DmlStatementsProcessor.java:358)
>
> at
> org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.doRunPrepared(IgniteH2Indexing.java:2263)
>
> ... 19 more
>
>
>
> It seems that I forgot to configure something like
> ‘topology-aware-replication » where a DATA is replicated N times accros N
> datacenters (I’m on AWS and I can target 3 datacenters and I so want to
> have my DATA replicated on the three).
>
>
>
> I search in the documentation but found nothing like that ☹
>
>
>
> Anybody know if it is possible and if yes how to configure that ?
>
>
>
> Cordialement,
>
>
> *— NOTE : n/a*
> —
> Gfi Informatique
> *Philippe Cerou*
> Architecte & Expert Système
> GFI Production / Toulouse
> philippe.cerou @gfi.fr
>
> —
>
> 1 Rond-point du Général Eisenhower, 31400 Toulouse
>
> Tél. : +33 (0)5.62.85.11.55
> Mob. : +33 (0)6.03.56.48.62
> *www.gfi.world* <http://www.gfi.world/>
>
> —
>
> [image: Facebook] <https://www.facebook.com/gfiinformatique> [image:
> Twitter] <https://twitter.com/gfiinformatique> [image: Instagram]
> <https://www.instagram.com/gfiinformatique/> [image: LinkedIn]
> <https://www.linkedin.com/company/gfi-informatique> [image: YouTube]
> <https://www.youtube.com/user/GFIinformatique>
> —
> [image: cid:image006.jpg@01D2F97F.AA6ABB50] <http://www.gfi.world/>
>
>
>
>
>
> *De :* Ilya Kasnacheev [mailto:ilya.kasnacheev@gmail.com]
> *Envoyé :* jeudi 7 février 2019 14:01
> *À :* user@ignite.apache.org
> *Objet :* Re: Insert failover on cluster with Java JDBC client do not
> seems to run.
>
>
>
> Hello!
>
>
>
> 1) Can you provide logs from server nodes?
>
>
>
> 2) Are you sure you have enough backups so there is no data loss when you
> do failover?
>
>
>
> Regards,
>
> --
>
> Ilya Kasnacheev
>
>
>
>
>
> ср, 6 февр. 2019 г. в 18:12, Philippe CEROU <ph...@gfi.fr>:
>
> Hi,
>
>
>
> We are testing Ignite failover capabilities and it seems that if we create
> a table in a replicated/partitioned region and then we proceed to insertion
> we experiment insertion exception.
>
>
>
> When a collection of 100 rows insertion statements fail we try again three
> time in a loop reconnecting at third try.
>
>
>
> Any idea ?
>
>
>
> Test log :
>
>
>
> Wed Feb 06 15:55:37 CET 2019 [TRC] Connect to :
> jdbc:ignite:thin://nx101c,nx102a,nx103b/KSDATA?user=CLUSER&password=clpassword
>
> Wed Feb 06 15:55:38 CET 2019 [TRC] Connected.
>
> Wed Feb 06 15:55:38 CET 2019 [TRC] Diconnecting.
>
> Wed Feb 06 15:55:38 CET 2019 [TRC] Diconnected.
>
> Wed Feb 06 15:55:38 CET 2019 [INF]
> ---------------------------------------------------------
>
> Wed Feb 06 15:55:38 CET 2019 [INF] Amorce test [1 x 1000 : 100], itération
> #1
>
> Wed Feb 06 15:55:38 CET 2019 [INF] Suppression de la table de travail.
>
> Wed Feb 06 15:55:38 CET 2019 [TRC] Diconnecting.
>
> Wed Feb 06 15:55:38 CET 2019 [WRN] Try to close closed/non-existent
> connection.
>
> Wed Feb 06 15:55:38 CET 2019 [TRC] Connect to :
> jdbc:ignite:thin://nx101c,nx102a,nx103b/KSDATA?user=CLUSER&password=clpassword
>
> Wed Feb 06 15:55:38 CET 2019 [TRC] Connected.
>
> Wed Feb 06 15:55:38 CET 2019 [TRC] Run query : drop table if exists
> benchmark
>
> Wed Feb 06 15:55:38 CET 2019 [TRC] Query executed.
>
> Wed Feb 06 15:55:38 CET 2019 [TRC] Committing.
>
> Wed Feb 06 15:55:39 CET 2019 [TRC] Committed.
>
> Wed Feb 06 15:55:39 CET 2019 [TRC] Diconnecting.
>
> Wed Feb 06 15:55:39 CET 2019 [TRC] Diconnected.
>
> Wed Feb 06 15:55:39 CET 2019 [INF] Création instance SSH.
>
> Wed Feb 06 15:55:39 CET 2019 [INF] Purge de la base de données.
>
> Wed Feb 06 15:55:39 CET 2019 [INF] Création de la table de travail.
>
> Wed Feb 06 15:55:39 CET 2019 [TRC] Diconnecting.
>
> Wed Feb 06 15:55:39 CET 2019 [WRN] Try to close closed/non-existent
> connection.
>
> Wed Feb 06 15:55:39 CET 2019 [TRC] Connect to :
> jdbc:ignite:thin://nx101c,nx102a,nx103b/KSDATA?user=CLUSER&password=clpassword
>
> Wed Feb 06 15:55:39 CET 2019 [WRN] Connection error, retry.
>
> Wed Feb 06 15:55:40 CET 2019 [TRC] Connect to :
> jdbc:ignite:thin://nx101c,nx102a,nx103b/KSDATA?user=CLUSER&password=clpassword
>
> Wed Feb 06 15:55:40 CET 2019 [TRC] Connected.
>
> Wed Feb 06 15:55:40 CET 2019 [TRC] Run query : create table benchmark (id
> NUMERIC(10) primary key,C001 VARCHAR(30),C002 float,C003 float,C004
> NUMERIC(10),C005 NUMERIC(10),C006 NUMERIC(10),C007 NUMERIC(10),C008
> NUMERIC(10),C009 VARCHAR(30),C010 VARCHAR(30),C011 DATE,C012
> VARCHAR(30),C013 VARCHAR(30),C014 VARCHAR(30),C015 NUMERIC(10),C016
> float,C017 VARCHAR(30),C018 VARCHAR(30),C019 VARCHAR(30)) WITH "BACKUPS=1,
> WRITE_SYNCHRONIZATION_MODE=FULL_ASYNC, ATOMICITY=ATOMIC, AFFINITYKEY=id"
>
> Wed Feb 06 15:55:40 CET 2019 [TRC] Query executed.
>
> Wed Feb 06 15:55:40 CET 2019 [TRC] Committing.
>
> Wed Feb 06 15:55:40 CET 2019 [TRC] Committed.
>
> Wed Feb 06 15:55:40 CET 2019 [TRC] Run query : create index benchmarkc001
> on benchmark(c001)
>
> Wed Feb 06 15:55:40 CET 2019 [TRC] Query executed.
>
> Wed Feb 06 15:55:40 CET 2019 [TRC] Committing.
>
> Wed Feb 06 15:55:40 CET 2019 [TRC] Committed.
>
> Wed Feb 06 15:55:40 CET 2019 [TRC] Run query : create index benchmarkc002
> on benchmark(c002)
>
> Wed Feb 06 15:55:40 CET 2019 [TRC] Query executed.
>
> Wed Feb 06 15:55:40 CET 2019 [TRC] Committing.
>
> Wed Feb 06 15:55:40 CET 2019 [TRC] Committed.
>
> Wed Feb 06 15:55:40 CET 2019 [TRC] Run query : create index benchmarkc003
> on benchmark(c003)
>
> Wed Feb 06 15:55:40 CET 2019 [TRC] Query executed.
>
> Wed Feb 06 15:55:40 CET 2019 [TRC] Committing.
>
> Wed Feb 06 15:55:40 CET 2019 [TRC] Committed.
>
> Wed Feb 06 15:55:40 CET 2019 [TRC] Run query : create index benchmarkc011
> on benchmark(c011)
>
> Wed Feb 06 15:55:40 CET 2019 [TRC] Query executed.
>
> Wed Feb 06 15:55:40 CET 2019 [TRC] Committing.
>
> Wed Feb 06 15:55:40 CET 2019 [TRC] Committed.
>
> Wed Feb 06 15:55:40 CET 2019 [TRC] Diconnecting.
>
> Wed Feb 06 15:55:40 CET 2019 [TRC] Diconnected.
>
> Wed Feb 06 15:55:41 CET 2019 [INF] Relance du cluster.
>
> Wed Feb 06 15:55:42 CET 2019 [INF] Initialisation indicateurs
>
> Wed Feb 06 15:55:42 CET 2019 [INF] Préparation des processus.
>
> Wed Feb 06 15:55:42 CET 2019 [TRC] Connect to :
> jdbc:ignite:thin://nx101c,nx102a,nx103b/KSDATA?user=CLUSER&password=clpassword
>
> Wed Feb 06 15:55:43 CET 2019 [TRC] Connected.
>
> Wed Feb 06 15:55:43 CET 2019 [INF] Activation des processus.
>
> Wed Feb 06 15:55:43 CET 2019 [INF] Progress : 0%
>
> Wed Feb 06 15:55:43 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[1, 78076E,
> 35.39261, -120.0947, 328, 30000, 462, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:56:30 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
>
> Wed Feb 06 15:55:43 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[5, 78076E,
> 34.77266, -119.643, 329, 29900, 452, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:50:51 UTC 2018, LAX, PEK, CA984, 0, 1152.0, 0000000, null, 0]]
>
> Wed Feb 06 15:55:44 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[9, 78076E,
> 35.37574, -120.08237, 328, 30000, 462, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:56:21 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
>
> Wed Feb 06 15:55:45 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[30, 78076E,
> 35.73808, -120.35001, 328, 30000, 461, 7246, 5000, B77W, B-2088, Tue Oct 16
> 07:59:39 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
>
> Wed Feb 06 15:55:45 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[35, 78076E,
> 35.14856, -119.91589, 329, 30000, 459, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:54:16 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
>
> Wed Feb 06 15:55:46 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[47, 78076E,
> 35.25854, -119.99635, 328, 30000, 462, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:55:17 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
>
> Wed Feb 06 15:55:46 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[49, 78076E,
> 34.77266, -119.643, 329, 29900, 452, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:50:51 UTC 2018, LAX, PEK, CA984, 0, 1152.0, 0000000, null, 0]]
>
> Wed Feb 06 15:55:47 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[61, 78076E,
> 35.02721, -119.82754, 329, 30000, 457, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:53:11 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
>
> Wed Feb 06 15:55:48 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[83, 78076E,
> 34.81073, -119.67054, 329, 30000, 457, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:51:11 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
>
> Wed Feb 06 15:55:48 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[94, 78076E,
> 35.17044, -119.93186, 328, 30000, 459, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:54:28 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
>
> Wed Feb 06 15:55:48 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[96, 78076E,
> 35.15988, -119.92412, 328, 30000, 459, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:54:23 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
>
> Wed Feb 06 15:55:48 CET 2019 [TRC] Close statement.
>
> Wed Feb 06 15:55:48 CET 2019 [TRC] Rollback.
>
> Wed Feb 06 15:55:48 CET 2019 [TRC] Rollbacked.
>
> Wed Feb 06 15:55:48 CET 2019 [WRN] Sleep & retry.
>
> Wed Feb 06 15:55:49 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[1, 78076E,
> 35.39261, -120.0947, 328, 30000, 462, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:56:30 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
>
> Wed Feb 06 15:55:50 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[5, 78076E,
> 34.77266, -119.643, 329, 29900, 452, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:50:51 UTC 2018, LAX, PEK, CA984, 0, 1152.0, 0000000, null, 0]]
>
> Wed Feb 06 15:55:50 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[9, 78076E,
> 35.37574, -120.08237, 328, 30000, 462, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:56:21 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
>
> Wed Feb 06 15:55:51 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[30, 78076E,
> 35.73808, -120.35001, 328, 30000, 461, 7246, 5000, B77W, B-2088, Tue Oct 16
> 07:59:39 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
>
> Wed Feb 06 15:55:51 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[35, 78076E,
> 35.14856, -119.91589, 329, 30000, 459, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:54:16 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
>
> Wed Feb 06 15:55:51 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[47, 78076E,
> 35.25854, -119.99635, 328, 30000, 462, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:55:17 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
>
> Wed Feb 06 15:55:51 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[49, 78076E,
> 34.77266, -119.643, 329, 29900, 452, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:50:51 UTC 2018, LAX, PEK, CA984, 0, 1152.0, 0000000, null, 0]]
>
> Wed Feb 06 15:55:52 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[61, 78076E,
> 35.02721, -119.82754, 329, 30000, 457, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:53:11 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
>
> Wed Feb 06 15:55:53 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[83, 78076E,
> 34.81073, -119.67054, 329, 30000, 457, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:51:11 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
>
> Wed Feb 06 15:55:53 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[94, 78076E,
> 35.17044, -119.93186, 328, 30000, 459, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:54:28 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
>
> Wed Feb 06 15:55:53 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[96, 78076E,
> 35.15988, -119.92412, 328, 30000, 459, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:54:23 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
>
> Wed Feb 06 15:55:54 CET 2019 [TRC] Close statement.
>
> Wed Feb 06 15:55:54 CET 2019 [TRC] Rollback.
>
> Wed Feb 06 15:55:54 CET 2019 [TRC] Rollbacked.
>
> Wed Feb 06 15:55:54 CET 2019 [WRN] Sleep & retry.
>
> Wed Feb 06 15:55:55 CET 2019 [TRC] Diconnecting.
>
> Wed Feb 06 15:55:55 CET 2019 [TRC] Diconnected.
>
> Wed Feb 06 15:55:55 CET 2019 [TRC] Connect to :
> jdbc:ignite:thin://nx101c,nx102a,nx103b/KSDATA?user=CLUSER&password=clpassword
>
> Wed Feb 06 15:55:55 CET 2019 [WRN] Connection error, retry.
>
> Wed Feb 06 15:55:56 CET 2019 [TRC] Connect to :
> jdbc:ignite:thin://nx101c,nx102a,nx103b/KSDATA?user=CLUSER&password=clpassword
>
> Wed Feb 06 15:55:56 CET 2019 [TRC] Connected.
>
> Wed Feb 06 15:55:56 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[1, 78076E,
> 35.39261, -120.0947, 328, 30000, 462, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:56:30 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
>
> Wed Feb 06 15:55:56 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[5, 78076E,
> 34.77266, -119.643, 329, 29900, 452, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:50:51 UTC 2018, LAX, PEK, CA984, 0, 1152.0, 0000000, null, 0]]
>
> Wed Feb 06 15:55:56 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[9, 78076E,
> 35.37574, -120.08237, 328, 30000, 462, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:56:21 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
>
> Wed Feb 06 15:55:57 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[30, 78076E,
> 35.73808, -120.35001, 328, 30000, 461, 7246, 5000, B77W, B-2088, Tue Oct 16
> 07:59:39 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
>
> Wed Feb 06 15:55:57 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[35, 78076E,
> 35.14856, -119.91589, 329, 30000, 459, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:54:16 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
>
> Wed Feb 06 15:55:58 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[47, 78076E,
> 35.25854, -119.99635, 328, 30000, 462, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:55:17 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
>
> Wed Feb 06 15:55:58 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[49, 78076E,
> 34.77266, -119.643, 329, 29900, 452, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:50:51 UTC 2018, LAX, PEK, CA984, 0, 1152.0, 0000000, null, 0]]
>
> Wed Feb 06 15:55:59 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[61, 78076E,
> 35.02721, -119.82754, 329, 30000, 457, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:53:11 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
>
> Wed Feb 06 15:56:00 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[83, 78076E,
> 34.81073, -119.67054, 329, 30000, 457, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:51:11 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
>
> Wed Feb 06 15:56:00 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[94, 78076E,
> 35.17044, -119.93186, 328, 30000, 459, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:54:28 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
>
> Wed Feb 06 15:56:00 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[96, 78076E,
> 35.15988, -119.92412, 328, 30000, 459, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:54:23 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
>
> Wed Feb 06 15:56:01 CET 2019 [TRC] Close statement.
>
> Wed Feb 06 15:56:01 CET 2019 [TRC] Rollback.
>
> Wed Feb 06 15:56:01 CET 2019 [TRC] Rollbacked.
>
> Wed Feb 06 15:56:01 CET 2019 [WRN] Sleep & retry.
>
> Wed Feb 06 15:56:02 CET 2019 [TRC] Diconnecting.
>
> Wed Feb 06 15:56:02 CET 2019 [TRC] Diconnected.
>
> Wed Feb 06 15:56:02 CET 2019 [TRC] Connect to :
> jdbc:ignite:thin://nx101c,nx102a,nx103b/KSDATA?user=CLUSER&password=clpassword
>
> Wed Feb 06 15:56:02 CET 2019 [TRC] Connected.
>
> Wed Feb 06 15:56:02 CET 2019 [ERR] Failed to execute DML statement
> [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[96, 78076E,
> 35.15988, -119.92412, 328, 30000, 459, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:54:23 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
>
> Wed Feb 06 15:56:02 CET 2019 [INF] Progress : 10%
>
> ...
>
> Wed Feb 06 15:58:44 CET 2019 [TRC] Diconnecting.
>
> Wed Feb 06 15:58:44 CET 2019 [TRC] Diconnected.
>
> Wed Feb 06 15:58:44 CET 2019 [INF] Progress : 100%
>
> Wed Feb 06 15:58:44 CET 2019 [INF] Durée : 180801ms
>
> Wed Feb 06 15:58:44 CET 2019 [INF] Metrics : 1 ; 1000 ; 100 ; 1 ; 180801
>
> Wed Feb 06 15:58:44 CET 2019 [INF] Purge des processus.
>
> Wed Feb 06 15:58:44 CET 2019 [INF] Synchronisation des disques du cluster.
>
> Wed Feb 06 15:58:44 CET 2019 [TRC] Diconnecting.
>
> Wed Feb 06 15:58:44 CET 2019 [WRN] Try to close closed/non-existent
> connection.
>
> Wed Feb 06 15:58:44 CET 2019 [INF] Relance du cluster.
>
> Wed Feb 06 15:58:44 CET 2019 [INF] Récupération des derniers indicateurs
> systéme.
>
> Wed Feb 06 15:58:44 CET 2019 [INF] Sauvegarde des données.
>
> Wed Feb 06 15:58:44 CET 2019 [INF] FILEOUTPUT :
> results/benchmark.insert_csv_1_1000_100_ignite-jdbc_nx101c,nx102a,nx103b_KSDATA.ser
>
> Wed Feb 06 15:58:44 CET 2019 [INF] Fin du test.
>
> Wed Feb 06 15:58:44 CET 2019 [INF]
> ---------------------------------------------------------
>
> Wed Feb 06 15:58:44 CET 2019 [TRC] Diconnecting.
>
> Wed Feb 06 15:58:44 CET 2019 [WRN] Try to close closed/non-existent
> connection.
>
>
>
> If we control DATA :
>
>
>
> 0: jdbc:ignite:thin://nx102a:10800> select count(*) from KSDATA.BENCHMARK;
>
> +--------------------------------+
>
> | COUNT(*) |
>
> +--------------------------------+
>
> | 899 |
>
> +--------------------------------+
>
> 1 row selected (0.01 seconds)
>
>
>
> We have only 899 rows versus 1 000 inserted !
>
>
>
> Cordialement,
>
>
> *— NOTE : n/a*
> —
> Gfi Informatique
> *Philippe Cerou*
> Architecte & Expert Système
> GFI Production / Toulouse
> philippe.cerou @gfi.fr
>
> —
>
> 1 Rond-point du Général Eisenhower, 31400 Toulouse
>
> Tél. : +33 (0)5.62.85.11.55
> Mob. : +33 (0)6.03.56.48.62
> *www.gfi.world* <http://www.gfi.world/>
>
> —
>
> [image: Facebook] <https://www.facebook.com/gfiinformatique> [image:
> Twitter] <https://twitter.com/gfiinformatique> [image: Instagram]
> <https://www.instagram.com/gfiinformatique/> [image: LinkedIn]
> <https://www.linkedin.com/company/gfi-informatique> [image: YouTube]
> <https://www.youtube.com/user/GFIinformatique>
> —
> [image: cid:image006.jpg@01D2F97F.AA6ABB50] <http://www.gfi.world/>
>
>
>
>
>
>
RE: Insert failover on cluster with Java JDBC client do not seems to
run.
Posted by Philippe CEROU <ph...@gfi.fr>.
Hi,
In fact I found that in one node logs :
[14:12:04,767][SEVERE][client-connector-#69][JdbcRequestHandler] Failed to execute SQL query [reqId=0, req=JdbcQueryExecuteRequest [schemaName=KSDATA, pageSize=1024, maxRows=0, sqlQry=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), args=[5908856, A3244F, 32.94908, -96.7905, 143, 10050, 312, 6227, 5000, B738, N301PA, Tue Oct 16 22:06:43 UTC 2018, DFW, GUA, AA1013, 0, 1152.0, AAL1013, null, 1539737840], stmtType=ANY_STATEMENT_TYPE, autoCommit=false]]
class org.apache.ignite.internal.processors.query.IgniteSQLException: Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[5908856, A3244F, 32.94908, -96.7905, 143, 10050, 312, 6227, 5000, B738, N301PA, Tue Oct 16 22:06:43 UTC 2018, DFW, GUA, AA1013, 0, 1152.0, AAL1013, null, 1539737840]]
at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.doRunPrepared(IgniteH2Indexing.java:2284)
at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.querySqlFields(IgniteH2Indexing.java:2178)
at org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:2135)
at org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:2130)
at org.apache.ignite.internal.util.lang.IgniteOutClosureX.apply(IgniteOutClosureX.java:36)
at org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:2707)
at org.apache.ignite.internal.processors.query.GridQueryProcessor.querySqlFields(GridQueryProcessor.java:2144)
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.JdbcRequestHandler.handle(JdbcRequestHandler.java:208)
at org.apache.ignite.internal.processors.odbc.ClientListenerNioListener.onMessage(ClientListenerNioListener.java:162)
at org.apache.ignite.internal.processors.odbc.ClientListenerNioListener.onMessage(ClientListenerNioListener.java:45)
at org.apache.ignite.internal.util.nio.GridNioFilterChain$TailFilter.onMessageReceived(GridNioFilterChain.java:279)
at org.apache.ignite.internal.util.nio.GridNioFilterAdapter.proceedMessageReceived(GridNioFilterAdapter.java:109)
at org.apache.ignite.internal.util.nio.GridNioAsyncNotifyFilter$3.body(GridNioAsyncNotifyFilter.java:97)
at org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:120)
at org.apache.ignite.internal.util.worker.GridWorkerPool$1.run(GridWorkerPool.java:70)
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)
Caused by: class org.apache.ignite.internal.cluster.ClusterTopologyServerNotFoundException: Failed to map keys for cache (all partition nodes left the grid).
at org.apache.ignite.internal.processors.cache.distributed.dht.atomic.GridNearAtomicSingleUpdateFuture.mapSingleUpdate(GridNearAtomicSingleUpdateFuture.java:562)
at org.apache.ignite.internal.processors.cache.distributed.dht.atomic.GridNearAtomicSingleUpdateFuture.map(GridNearAtomicSingleUpdateFuture.java:454)
at org.apache.ignite.internal.processors.cache.distributed.dht.atomic.GridNearAtomicSingleUpdateFuture.mapOnTopology(GridNearAtomicSingleUpdateFuture.java:443)
at org.apache.ignite.internal.processors.cache.distributed.dht.atomic.GridNearAtomicAbstractUpdateFuture.map(GridNearAtomicAbstractUpdateFuture.java:248)
at org.apache.ignite.internal.processors.cache.distributed.dht.atomic.GridDhtAtomicCache.update0(GridDhtAtomicCache.java:1153)
at org.apache.ignite.internal.processors.cache.distributed.dht.atomic.GridDhtAtomicCache.put0(GridDhtAtomicCache.java:611)
at org.apache.ignite.internal.processors.cache.GridCacheAdapter.put(GridCacheAdapter.java:2449)
at org.apache.ignite.internal.processors.cache.GridCacheAdapter.putIfAbsent(GridCacheAdapter.java:2876)
at org.apache.ignite.internal.processors.query.h2.DmlStatementsProcessor.doInsert(DmlStatementsProcessor.java:925)
at org.apache.ignite.internal.processors.query.h2.DmlStatementsProcessor.processDmlSelectResult(DmlStatementsProcessor.java:704)
at org.apache.ignite.internal.processors.query.h2.DmlStatementsProcessor.executeUpdateStatement(DmlStatementsProcessor.java:653)
at org.apache.ignite.internal.processors.query.h2.DmlStatementsProcessor.updateSqlFields(DmlStatementsProcessor.java:185)
at org.apache.ignite.internal.processors.query.h2.DmlStatementsProcessor.updateSqlFieldsDistributed(DmlStatementsProcessor.java:358)
at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.doRunPrepared(IgniteH2Indexing.java:2263)
... 19 more
It seems that I forgot to configure something like ‘topology-aware-replication » where a DATA is replicated N times accros N datacenters (I’m on AWS and I can target 3 datacenters and I so want to have my DATA replicated on the three).
I search in the documentation but found nothing like that ☹
Anybody know if it is possible and if yes how to configure that ?
Cordialement,
—
NOTE : n/a
—
Gfi Informatique
Philippe Cerou
Architecte & Expert Système
GFI Production / Toulouse
philippe.cerou @gfi.fr
—
1 Rond-point du Général Eisenhower, 31400 Toulouse
Tél. : +33 (0)5.62.85.11.55
Mob. : +33 (0)6.03.56.48.62
www.gfi.world<http://www.gfi.world/>
—
[Facebook]<https://www.facebook.com/gfiinformatique> [Twitter] <https://twitter.com/gfiinformatique> [Instagram] <https://www.instagram.com/gfiinformatique/> [LinkedIn] <https://www.linkedin.com/company/gfi-informatique> [YouTube] <https://www.youtube.com/user/GFIinformatique>
—
[cid:image006.jpg@01D2F97F.AA6ABB50]<http://www.gfi.world/>
De : Ilya Kasnacheev [mailto:ilya.kasnacheev@gmail.com]
Envoyé : jeudi 7 février 2019 14:01
À : user@ignite.apache.org
Objet : Re: Insert failover on cluster with Java JDBC client do not seems to run.
Hello!
1) Can you provide logs from server nodes?
2) Are you sure you have enough backups so there is no data loss when you do failover?
Regards,
--
Ilya Kasnacheev
ср, 6 февр. 2019 г. в 18:12, Philippe CEROU <ph...@gfi.fr>>:
Hi,
We are testing Ignite failover capabilities and it seems that if we create a table in a replicated/partitioned region and then we proceed to insertion we experiment insertion exception.
When a collection of 100 rows insertion statements fail we try again three time in a loop reconnecting at third try.
Any idea ?
Test log :
Wed Feb 06 15:55:37 CET 2019 [TRC] Connect to : jdbc:ignite:thin://nx101c,nx102a,nx103b/KSDATA?user=CLUSER&password=clpassword
Wed Feb 06 15:55:38 CET 2019 [TRC] Connected.
Wed Feb 06 15:55:38 CET 2019 [TRC] Diconnecting.
Wed Feb 06 15:55:38 CET 2019 [TRC] Diconnected.
Wed Feb 06 15:55:38 CET 2019 [INF] ---------------------------------------------------------
Wed Feb 06 15:55:38 CET 2019 [INF] Amorce test [1 x 1000 : 100], itération #1
Wed Feb 06 15:55:38 CET 2019 [INF] Suppression de la table de travail.
Wed Feb 06 15:55:38 CET 2019 [TRC] Diconnecting.
Wed Feb 06 15:55:38 CET 2019 [WRN] Try to close closed/non-existent connection.
Wed Feb 06 15:55:38 CET 2019 [TRC] Connect to : jdbc:ignite:thin://nx101c,nx102a,nx103b/KSDATA?user=CLUSER&password=clpassword
Wed Feb 06 15:55:38 CET 2019 [TRC] Connected.
Wed Feb 06 15:55:38 CET 2019 [TRC] Run query : drop table if exists benchmark
Wed Feb 06 15:55:38 CET 2019 [TRC] Query executed.
Wed Feb 06 15:55:38 CET 2019 [TRC] Committing.
Wed Feb 06 15:55:39 CET 2019 [TRC] Committed.
Wed Feb 06 15:55:39 CET 2019 [TRC] Diconnecting.
Wed Feb 06 15:55:39 CET 2019 [TRC] Diconnected.
Wed Feb 06 15:55:39 CET 2019 [INF] Création instance SSH.
Wed Feb 06 15:55:39 CET 2019 [INF] Purge de la base de données.
Wed Feb 06 15:55:39 CET 2019 [INF] Création de la table de travail.
Wed Feb 06 15:55:39 CET 2019 [TRC] Diconnecting.
Wed Feb 06 15:55:39 CET 2019 [WRN] Try to close closed/non-existent connection.
Wed Feb 06 15:55:39 CET 2019 [TRC] Connect to : jdbc:ignite:thin://nx101c,nx102a,nx103b/KSDATA?user=CLUSER&password=clpassword
Wed Feb 06 15:55:39 CET 2019 [WRN] Connection error, retry.
Wed Feb 06 15:55:40 CET 2019 [TRC] Connect to : jdbc:ignite:thin://nx101c,nx102a,nx103b/KSDATA?user=CLUSER&password=clpassword
Wed Feb 06 15:55:40 CET 2019 [TRC] Connected.
Wed Feb 06 15:55:40 CET 2019 [TRC] Run query : create table benchmark (id NUMERIC(10) primary key,C001 VARCHAR(30),C002 float,C003 float,C004 NUMERIC(10),C005 NUMERIC(10),C006 NUMERIC(10),C007 NUMERIC(10),C008 NUMERIC(10),C009 VARCHAR(30),C010 VARCHAR(30),C011 DATE,C012 VARCHAR(30),C013 VARCHAR(30),C014 VARCHAR(30),C015 NUMERIC(10),C016 float,C017 VARCHAR(30),C018 VARCHAR(30),C019 VARCHAR(30)) WITH "BACKUPS=1, WRITE_SYNCHRONIZATION_MODE=FULL_ASYNC, ATOMICITY=ATOMIC, AFFINITYKEY=id"
Wed Feb 06 15:55:40 CET 2019 [TRC] Query executed.
Wed Feb 06 15:55:40 CET 2019 [TRC] Committing.
Wed Feb 06 15:55:40 CET 2019 [TRC] Committed.
Wed Feb 06 15:55:40 CET 2019 [TRC] Run query : create index benchmarkc001 on benchmark(c001)
Wed Feb 06 15:55:40 CET 2019 [TRC] Query executed.
Wed Feb 06 15:55:40 CET 2019 [TRC] Committing.
Wed Feb 06 15:55:40 CET 2019 [TRC] Committed.
Wed Feb 06 15:55:40 CET 2019 [TRC] Run query : create index benchmarkc002 on benchmark(c002)
Wed Feb 06 15:55:40 CET 2019 [TRC] Query executed.
Wed Feb 06 15:55:40 CET 2019 [TRC] Committing.
Wed Feb 06 15:55:40 CET 2019 [TRC] Committed.
Wed Feb 06 15:55:40 CET 2019 [TRC] Run query : create index benchmarkc003 on benchmark(c003)
Wed Feb 06 15:55:40 CET 2019 [TRC] Query executed.
Wed Feb 06 15:55:40 CET 2019 [TRC] Committing.
Wed Feb 06 15:55:40 CET 2019 [TRC] Committed.
Wed Feb 06 15:55:40 CET 2019 [TRC] Run query : create index benchmarkc011 on benchmark(c011)
Wed Feb 06 15:55:40 CET 2019 [TRC] Query executed.
Wed Feb 06 15:55:40 CET 2019 [TRC] Committing.
Wed Feb 06 15:55:40 CET 2019 [TRC] Committed.
Wed Feb 06 15:55:40 CET 2019 [TRC] Diconnecting.
Wed Feb 06 15:55:40 CET 2019 [TRC] Diconnected.
Wed Feb 06 15:55:41 CET 2019 [INF] Relance du cluster.
Wed Feb 06 15:55:42 CET 2019 [INF] Initialisation indicateurs
Wed Feb 06 15:55:42 CET 2019 [INF] Préparation des processus.
Wed Feb 06 15:55:42 CET 2019 [TRC] Connect to : jdbc:ignite:thin://nx101c,nx102a,nx103b/KSDATA?user=CLUSER&password=clpassword
Wed Feb 06 15:55:43 CET 2019 [TRC] Connected.
Wed Feb 06 15:55:43 CET 2019 [INF] Activation des processus.
Wed Feb 06 15:55:43 CET 2019 [INF] Progress : 0%
Wed Feb 06 15:55:43 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[1, 78076E, 35.39261, -120.0947, 328, 30000, 462, 7246, 200, B77W, B-2088, Tue Oct 16 07:56:30 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
Wed Feb 06 15:55:43 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[5, 78076E, 34.77266, -119.643, 329, 29900, 452, 7246, 200, B77W, B-2088, Tue Oct 16 07:50:51 UTC 2018, LAX, PEK, CA984, 0, 1152.0, 0000000, null, 0]]
Wed Feb 06 15:55:44 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[9, 78076E, 35.37574, -120.08237, 328, 30000, 462, 7246, 200, B77W, B-2088, Tue Oct 16 07:56:21 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
Wed Feb 06 15:55:45 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[30, 78076E, 35.73808, -120.35001, 328, 30000, 461, 7246, 5000, B77W, B-2088, Tue Oct 16 07:59:39 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
Wed Feb 06 15:55:45 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[35, 78076E, 35.14856, -119.91589, 329, 30000, 459, 7246, 200, B77W, B-2088, Tue Oct 16 07:54:16 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
Wed Feb 06 15:55:46 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[47, 78076E, 35.25854, -119.99635, 328, 30000, 462, 7246, 200, B77W, B-2088, Tue Oct 16 07:55:17 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
Wed Feb 06 15:55:46 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[49, 78076E, 34.77266, -119.643, 329, 29900, 452, 7246, 200, B77W, B-2088, Tue Oct 16 07:50:51 UTC 2018, LAX, PEK, CA984, 0, 1152.0, 0000000, null, 0]]
Wed Feb 06 15:55:47 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[61, 78076E, 35.02721, -119.82754, 329, 30000, 457, 7246, 200, B77W, B-2088, Tue Oct 16 07:53:11 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
Wed Feb 06 15:55:48 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[83, 78076E, 34.81073, -119.67054, 329, 30000, 457, 7246, 200, B77W, B-2088, Tue Oct 16 07:51:11 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
Wed Feb 06 15:55:48 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[94, 78076E, 35.17044, -119.93186, 328, 30000, 459, 7246, 200, B77W, B-2088, Tue Oct 16 07:54:28 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
Wed Feb 06 15:55:48 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[96, 78076E, 35.15988, -119.92412, 328, 30000, 459, 7246, 200, B77W, B-2088, Tue Oct 16 07:54:23 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
Wed Feb 06 15:55:48 CET 2019 [TRC] Close statement.
Wed Feb 06 15:55:48 CET 2019 [TRC] Rollback.
Wed Feb 06 15:55:48 CET 2019 [TRC] Rollbacked.
Wed Feb 06 15:55:48 CET 2019 [WRN] Sleep & retry.
Wed Feb 06 15:55:49 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[1, 78076E, 35.39261, -120.0947, 328, 30000, 462, 7246, 200, B77W, B-2088, Tue Oct 16 07:56:30 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
Wed Feb 06 15:55:50 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[5, 78076E, 34.77266, -119.643, 329, 29900, 452, 7246, 200, B77W, B-2088, Tue Oct 16 07:50:51 UTC 2018, LAX, PEK, CA984, 0, 1152.0, 0000000, null, 0]]
Wed Feb 06 15:55:50 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[9, 78076E, 35.37574, -120.08237, 328, 30000, 462, 7246, 200, B77W, B-2088, Tue Oct 16 07:56:21 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
Wed Feb 06 15:55:51 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[30, 78076E, 35.73808, -120.35001, 328, 30000, 461, 7246, 5000, B77W, B-2088, Tue Oct 16 07:59:39 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
Wed Feb 06 15:55:51 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[35, 78076E, 35.14856, -119.91589, 329, 30000, 459, 7246, 200, B77W, B-2088, Tue Oct 16 07:54:16 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
Wed Feb 06 15:55:51 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[47, 78076E, 35.25854, -119.99635, 328, 30000, 462, 7246, 200, B77W, B-2088, Tue Oct 16 07:55:17 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
Wed Feb 06 15:55:51 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[49, 78076E, 34.77266, -119.643, 329, 29900, 452, 7246, 200, B77W, B-2088, Tue Oct 16 07:50:51 UTC 2018, LAX, PEK, CA984, 0, 1152.0, 0000000, null, 0]]
Wed Feb 06 15:55:52 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[61, 78076E, 35.02721, -119.82754, 329, 30000, 457, 7246, 200, B77W, B-2088, Tue Oct 16 07:53:11 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
Wed Feb 06 15:55:53 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[83, 78076E, 34.81073, -119.67054, 329, 30000, 457, 7246, 200, B77W, B-2088, Tue Oct 16 07:51:11 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
Wed Feb 06 15:55:53 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[94, 78076E, 35.17044, -119.93186, 328, 30000, 459, 7246, 200, B77W, B-2088, Tue Oct 16 07:54:28 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
Wed Feb 06 15:55:53 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[96, 78076E, 35.15988, -119.92412, 328, 30000, 459, 7246, 200, B77W, B-2088, Tue Oct 16 07:54:23 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
Wed Feb 06 15:55:54 CET 2019 [TRC] Close statement.
Wed Feb 06 15:55:54 CET 2019 [TRC] Rollback.
Wed Feb 06 15:55:54 CET 2019 [TRC] Rollbacked.
Wed Feb 06 15:55:54 CET 2019 [WRN] Sleep & retry.
Wed Feb 06 15:55:55 CET 2019 [TRC] Diconnecting.
Wed Feb 06 15:55:55 CET 2019 [TRC] Diconnected.
Wed Feb 06 15:55:55 CET 2019 [TRC] Connect to : jdbc:ignite:thin://nx101c,nx102a,nx103b/KSDATA?user=CLUSER&password=clpassword
Wed Feb 06 15:55:55 CET 2019 [WRN] Connection error, retry.
Wed Feb 06 15:55:56 CET 2019 [TRC] Connect to : jdbc:ignite:thin://nx101c,nx102a,nx103b/KSDATA?user=CLUSER&password=clpassword
Wed Feb 06 15:55:56 CET 2019 [TRC] Connected.
Wed Feb 06 15:55:56 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[1, 78076E, 35.39261, -120.0947, 328, 30000, 462, 7246, 200, B77W, B-2088, Tue Oct 16 07:56:30 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
Wed Feb 06 15:55:56 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[5, 78076E, 34.77266, -119.643, 329, 29900, 452, 7246, 200, B77W, B-2088, Tue Oct 16 07:50:51 UTC 2018, LAX, PEK, CA984, 0, 1152.0, 0000000, null, 0]]
Wed Feb 06 15:55:56 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[9, 78076E, 35.37574, -120.08237, 328, 30000, 462, 7246, 200, B77W, B-2088, Tue Oct 16 07:56:21 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
Wed Feb 06 15:55:57 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[30, 78076E, 35.73808, -120.35001, 328, 30000, 461, 7246, 5000, B77W, B-2088, Tue Oct 16 07:59:39 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
Wed Feb 06 15:55:57 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[35, 78076E, 35.14856, -119.91589, 329, 30000, 459, 7246, 200, B77W, B-2088, Tue Oct 16 07:54:16 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
Wed Feb 06 15:55:58 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[47, 78076E, 35.25854, -119.99635, 328, 30000, 462, 7246, 200, B77W, B-2088, Tue Oct 16 07:55:17 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
Wed Feb 06 15:55:58 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[49, 78076E, 34.77266, -119.643, 329, 29900, 452, 7246, 200, B77W, B-2088, Tue Oct 16 07:50:51 UTC 2018, LAX, PEK, CA984, 0, 1152.0, 0000000, null, 0]]
Wed Feb 06 15:55:59 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[61, 78076E, 35.02721, -119.82754, 329, 30000, 457, 7246, 200, B77W, B-2088, Tue Oct 16 07:53:11 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
Wed Feb 06 15:56:00 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[83, 78076E, 34.81073, -119.67054, 329, 30000, 457, 7246, 200, B77W, B-2088, Tue Oct 16 07:51:11 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
Wed Feb 06 15:56:00 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[94, 78076E, 35.17044, -119.93186, 328, 30000, 459, 7246, 200, B77W, B-2088, Tue Oct 16 07:54:28 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
Wed Feb 06 15:56:00 CET 2019 [TRC] Error during insertion : Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[96, 78076E, 35.15988, -119.92412, 328, 30000, 459, 7246, 200, B77W, B-2088, Tue Oct 16 07:54:23 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
Wed Feb 06 15:56:01 CET 2019 [TRC] Close statement.
Wed Feb 06 15:56:01 CET 2019 [TRC] Rollback.
Wed Feb 06 15:56:01 CET 2019 [TRC] Rollbacked.
Wed Feb 06 15:56:01 CET 2019 [WRN] Sleep & retry.
Wed Feb 06 15:56:02 CET 2019 [TRC] Diconnecting.
Wed Feb 06 15:56:02 CET 2019 [TRC] Diconnected.
Wed Feb 06 15:56:02 CET 2019 [TRC] Connect to : jdbc:ignite:thin://nx101c,nx102a,nx103b/KSDATA?user=CLUSER&password=clpassword
Wed Feb 06 15:56:02 CET 2019 [TRC] Connected.
Wed Feb 06 15:56:02 CET 2019 [ERR] Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[96, 78076E, 35.15988, -119.92412, 328, 30000, 459, 7246, 200, B77W, B-2088, Tue Oct 16 07:54:23 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
Wed Feb 06 15:56:02 CET 2019 [INF] Progress : 10%
...
Wed Feb 06 15:58:44 CET 2019 [TRC] Diconnecting.
Wed Feb 06 15:58:44 CET 2019 [TRC] Diconnected.
Wed Feb 06 15:58:44 CET 2019 [INF] Progress : 100%
Wed Feb 06 15:58:44 CET 2019 [INF] Durée : 180801ms
Wed Feb 06 15:58:44 CET 2019 [INF] Metrics : 1 ; 1000 ; 100 ; 1 ; 180801
Wed Feb 06 15:58:44 CET 2019 [INF] Purge des processus.
Wed Feb 06 15:58:44 CET 2019 [INF] Synchronisation des disques du cluster.
Wed Feb 06 15:58:44 CET 2019 [TRC] Diconnecting.
Wed Feb 06 15:58:44 CET 2019 [WRN] Try to close closed/non-existent connection.
Wed Feb 06 15:58:44 CET 2019 [INF] Relance du cluster.
Wed Feb 06 15:58:44 CET 2019 [INF] Récupération des derniers indicateurs systéme.
Wed Feb 06 15:58:44 CET 2019 [INF] Sauvegarde des données.
Wed Feb 06 15:58:44 CET 2019 [INF] FILEOUTPUT : results/benchmark.insert_csv_1_1000_100_ignite-jdbc_nx101c,nx102a,nx103b_KSDATA.ser
Wed Feb 06 15:58:44 CET 2019 [INF] Fin du test.
Wed Feb 06 15:58:44 CET 2019 [INF] ---------------------------------------------------------
Wed Feb 06 15:58:44 CET 2019 [TRC] Diconnecting.
Wed Feb 06 15:58:44 CET 2019 [WRN] Try to close closed/non-existent connection.
If we control DATA :
0: jdbc:ignite:thin://nx102a:10800> select count(*) from KSDATA.BENCHMARK;
+--------------------------------+
| COUNT(*) |
+--------------------------------+
| 899 |
+--------------------------------+
1 row selected (0.01 seconds)
We have only 899 rows versus 1 000 inserted !
Cordialement,
—
NOTE : n/a
—
Gfi Informatique
Philippe Cerou
Architecte & Expert Système
GFI Production / Toulouse
philippe.cerou @gfi.fr<http://gfi.fr>
—
1 Rond-point du Général Eisenhower, 31400 Toulouse
Tél. : +33 (0)5.62.85.11.55
Mob. : +33 (0)6.03.56.48.62
www.gfi.world<http://www.gfi.world/>
—
[Facebook]<https://www.facebook.com/gfiinformatique> [Twitter] <https://twitter.com/gfiinformatique> [Instagram] <https://www.instagram.com/gfiinformatique/> [LinkedIn] <https://www.linkedin.com/company/gfi-informatique> [YouTube] <https://www.youtube.com/user/GFIinformatique>
—
[cid:image006.jpg@01D2F97F.AA6ABB50]<http://www.gfi.world/>
Re: Insert failover on cluster with Java JDBC client do not seems to run.
Posted by Ilya Kasnacheev <il...@gmail.com>.
Hello!
1) Can you provide logs from server nodes?
2) Are you sure you have enough backups so there is no data loss when you
do failover?
Regards,
--
Ilya Kasnacheev
ср, 6 февр. 2019 г. в 18:12, Philippe CEROU <ph...@gfi.fr>:
> Hi,
>
>
>
> We are testing Ignite failover capabilities and it seems that if we create
> a table in a replicated/partitioned region and then we proceed to insertion
> we experiment insertion exception.
>
>
>
> When a collection of 100 rows insertion statements fail we try again three
> time in a loop reconnecting at third try.
>
>
>
> Any idea ?
>
>
>
> Test log :
>
>
>
> Wed Feb 06 15:55:37 CET 2019 [TRC] Connect to :
> jdbc:ignite:thin://nx101c,nx102a,nx103b/KSDATA?user=CLUSER&password=clpassword
>
> Wed Feb 06 15:55:38 CET 2019 [TRC] Connected.
>
> Wed Feb 06 15:55:38 CET 2019 [TRC] Diconnecting.
>
> Wed Feb 06 15:55:38 CET 2019 [TRC] Diconnected.
>
> Wed Feb 06 15:55:38 CET 2019 [INF]
> ---------------------------------------------------------
>
> Wed Feb 06 15:55:38 CET 2019 [INF] Amorce test [1 x 1000 : 100], itération
> #1
>
> Wed Feb 06 15:55:38 CET 2019 [INF] Suppression de la table de travail.
>
> Wed Feb 06 15:55:38 CET 2019 [TRC] Diconnecting.
>
> Wed Feb 06 15:55:38 CET 2019 [WRN] Try to close closed/non-existent
> connection.
>
> Wed Feb 06 15:55:38 CET 2019 [TRC] Connect to :
> jdbc:ignite:thin://nx101c,nx102a,nx103b/KSDATA?user=CLUSER&password=clpassword
>
> Wed Feb 06 15:55:38 CET 2019 [TRC] Connected.
>
> Wed Feb 06 15:55:38 CET 2019 [TRC] Run query : drop table if exists
> benchmark
>
> Wed Feb 06 15:55:38 CET 2019 [TRC] Query executed.
>
> Wed Feb 06 15:55:38 CET 2019 [TRC] Committing.
>
> Wed Feb 06 15:55:39 CET 2019 [TRC] Committed.
>
> Wed Feb 06 15:55:39 CET 2019 [TRC] Diconnecting.
>
> Wed Feb 06 15:55:39 CET 2019 [TRC] Diconnected.
>
> Wed Feb 06 15:55:39 CET 2019 [INF] Création instance SSH.
>
> Wed Feb 06 15:55:39 CET 2019 [INF] Purge de la base de données.
>
> Wed Feb 06 15:55:39 CET 2019 [INF] Création de la table de travail.
>
> Wed Feb 06 15:55:39 CET 2019 [TRC] Diconnecting.
>
> Wed Feb 06 15:55:39 CET 2019 [WRN] Try to close closed/non-existent
> connection.
>
> Wed Feb 06 15:55:39 CET 2019 [TRC] Connect to :
> jdbc:ignite:thin://nx101c,nx102a,nx103b/KSDATA?user=CLUSER&password=clpassword
>
> Wed Feb 06 15:55:39 CET 2019 [WRN] Connection error, retry.
>
> Wed Feb 06 15:55:40 CET 2019 [TRC] Connect to :
> jdbc:ignite:thin://nx101c,nx102a,nx103b/KSDATA?user=CLUSER&password=clpassword
>
> Wed Feb 06 15:55:40 CET 2019 [TRC] Connected.
>
> Wed Feb 06 15:55:40 CET 2019 [TRC] Run query : create table benchmark (id
> NUMERIC(10) primary key,C001 VARCHAR(30),C002 float,C003 float,C004
> NUMERIC(10),C005 NUMERIC(10),C006 NUMERIC(10),C007 NUMERIC(10),C008
> NUMERIC(10),C009 VARCHAR(30),C010 VARCHAR(30),C011 DATE,C012
> VARCHAR(30),C013 VARCHAR(30),C014 VARCHAR(30),C015 NUMERIC(10),C016
> float,C017 VARCHAR(30),C018 VARCHAR(30),C019 VARCHAR(30)) WITH "BACKUPS=1,
> WRITE_SYNCHRONIZATION_MODE=FULL_ASYNC, ATOMICITY=ATOMIC, AFFINITYKEY=id"
>
> Wed Feb 06 15:55:40 CET 2019 [TRC] Query executed.
>
> Wed Feb 06 15:55:40 CET 2019 [TRC] Committing.
>
> Wed Feb 06 15:55:40 CET 2019 [TRC] Committed.
>
> Wed Feb 06 15:55:40 CET 2019 [TRC] Run query : create index benchmarkc001
> on benchmark(c001)
>
> Wed Feb 06 15:55:40 CET 2019 [TRC] Query executed.
>
> Wed Feb 06 15:55:40 CET 2019 [TRC] Committing.
>
> Wed Feb 06 15:55:40 CET 2019 [TRC] Committed.
>
> Wed Feb 06 15:55:40 CET 2019 [TRC] Run query : create index benchmarkc002
> on benchmark(c002)
>
> Wed Feb 06 15:55:40 CET 2019 [TRC] Query executed.
>
> Wed Feb 06 15:55:40 CET 2019 [TRC] Committing.
>
> Wed Feb 06 15:55:40 CET 2019 [TRC] Committed.
>
> Wed Feb 06 15:55:40 CET 2019 [TRC] Run query : create index benchmarkc003
> on benchmark(c003)
>
> Wed Feb 06 15:55:40 CET 2019 [TRC] Query executed.
>
> Wed Feb 06 15:55:40 CET 2019 [TRC] Committing.
>
> Wed Feb 06 15:55:40 CET 2019 [TRC] Committed.
>
> Wed Feb 06 15:55:40 CET 2019 [TRC] Run query : create index benchmarkc011
> on benchmark(c011)
>
> Wed Feb 06 15:55:40 CET 2019 [TRC] Query executed.
>
> Wed Feb 06 15:55:40 CET 2019 [TRC] Committing.
>
> Wed Feb 06 15:55:40 CET 2019 [TRC] Committed.
>
> Wed Feb 06 15:55:40 CET 2019 [TRC] Diconnecting.
>
> Wed Feb 06 15:55:40 CET 2019 [TRC] Diconnected.
>
> Wed Feb 06 15:55:41 CET 2019 [INF] Relance du cluster.
>
> Wed Feb 06 15:55:42 CET 2019 [INF] Initialisation indicateurs
>
> Wed Feb 06 15:55:42 CET 2019 [INF] Préparation des processus.
>
> Wed Feb 06 15:55:42 CET 2019 [TRC] Connect to :
> jdbc:ignite:thin://nx101c,nx102a,nx103b/KSDATA?user=CLUSER&password=clpassword
>
> Wed Feb 06 15:55:43 CET 2019 [TRC] Connected.
>
> Wed Feb 06 15:55:43 CET 2019 [INF] Activation des processus.
>
> Wed Feb 06 15:55:43 CET 2019 [INF] Progress : 0%
>
> Wed Feb 06 15:55:43 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[1, 78076E,
> 35.39261, -120.0947, 328, 30000, 462, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:56:30 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
>
> Wed Feb 06 15:55:43 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[5, 78076E,
> 34.77266, -119.643, 329, 29900, 452, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:50:51 UTC 2018, LAX, PEK, CA984, 0, 1152.0, 0000000, null, 0]]
>
> Wed Feb 06 15:55:44 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[9, 78076E,
> 35.37574, -120.08237, 328, 30000, 462, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:56:21 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
>
> Wed Feb 06 15:55:45 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[30, 78076E,
> 35.73808, -120.35001, 328, 30000, 461, 7246, 5000, B77W, B-2088, Tue Oct 16
> 07:59:39 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
>
> Wed Feb 06 15:55:45 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[35, 78076E,
> 35.14856, -119.91589, 329, 30000, 459, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:54:16 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
>
> Wed Feb 06 15:55:46 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[47, 78076E,
> 35.25854, -119.99635, 328, 30000, 462, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:55:17 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
>
> Wed Feb 06 15:55:46 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[49, 78076E,
> 34.77266, -119.643, 329, 29900, 452, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:50:51 UTC 2018, LAX, PEK, CA984, 0, 1152.0, 0000000, null, 0]]
>
> Wed Feb 06 15:55:47 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[61, 78076E,
> 35.02721, -119.82754, 329, 30000, 457, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:53:11 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
>
> Wed Feb 06 15:55:48 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[83, 78076E,
> 34.81073, -119.67054, 329, 30000, 457, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:51:11 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
>
> Wed Feb 06 15:55:48 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[94, 78076E,
> 35.17044, -119.93186, 328, 30000, 459, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:54:28 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
>
> Wed Feb 06 15:55:48 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[96, 78076E,
> 35.15988, -119.92412, 328, 30000, 459, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:54:23 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
>
> Wed Feb 06 15:55:48 CET 2019 [TRC] Close statement.
>
> Wed Feb 06 15:55:48 CET 2019 [TRC] Rollback.
>
> Wed Feb 06 15:55:48 CET 2019 [TRC] Rollbacked.
>
> Wed Feb 06 15:55:48 CET 2019 [WRN] Sleep & retry.
>
> Wed Feb 06 15:55:49 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[1, 78076E,
> 35.39261, -120.0947, 328, 30000, 462, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:56:30 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
>
> Wed Feb 06 15:55:50 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[5, 78076E,
> 34.77266, -119.643, 329, 29900, 452, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:50:51 UTC 2018, LAX, PEK, CA984, 0, 1152.0, 0000000, null, 0]]
>
> Wed Feb 06 15:55:50 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[9, 78076E,
> 35.37574, -120.08237, 328, 30000, 462, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:56:21 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
>
> Wed Feb 06 15:55:51 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[30, 78076E,
> 35.73808, -120.35001, 328, 30000, 461, 7246, 5000, B77W, B-2088, Tue Oct 16
> 07:59:39 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
>
> Wed Feb 06 15:55:51 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[35, 78076E,
> 35.14856, -119.91589, 329, 30000, 459, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:54:16 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
>
> Wed Feb 06 15:55:51 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[47, 78076E,
> 35.25854, -119.99635, 328, 30000, 462, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:55:17 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
>
> Wed Feb 06 15:55:51 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[49, 78076E,
> 34.77266, -119.643, 329, 29900, 452, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:50:51 UTC 2018, LAX, PEK, CA984, 0, 1152.0, 0000000, null, 0]]
>
> Wed Feb 06 15:55:52 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[61, 78076E,
> 35.02721, -119.82754, 329, 30000, 457, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:53:11 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
>
> Wed Feb 06 15:55:53 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[83, 78076E,
> 34.81073, -119.67054, 329, 30000, 457, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:51:11 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
>
> Wed Feb 06 15:55:53 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[94, 78076E,
> 35.17044, -119.93186, 328, 30000, 459, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:54:28 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
>
> Wed Feb 06 15:55:53 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[96, 78076E,
> 35.15988, -119.92412, 328, 30000, 459, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:54:23 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
>
> Wed Feb 06 15:55:54 CET 2019 [TRC] Close statement.
>
> Wed Feb 06 15:55:54 CET 2019 [TRC] Rollback.
>
> Wed Feb 06 15:55:54 CET 2019 [TRC] Rollbacked.
>
> Wed Feb 06 15:55:54 CET 2019 [WRN] Sleep & retry.
>
> Wed Feb 06 15:55:55 CET 2019 [TRC] Diconnecting.
>
> Wed Feb 06 15:55:55 CET 2019 [TRC] Diconnected.
>
> Wed Feb 06 15:55:55 CET 2019 [TRC] Connect to :
> jdbc:ignite:thin://nx101c,nx102a,nx103b/KSDATA?user=CLUSER&password=clpassword
>
> Wed Feb 06 15:55:55 CET 2019 [WRN] Connection error, retry.
>
> Wed Feb 06 15:55:56 CET 2019 [TRC] Connect to :
> jdbc:ignite:thin://nx101c,nx102a,nx103b/KSDATA?user=CLUSER&password=clpassword
>
> Wed Feb 06 15:55:56 CET 2019 [TRC] Connected.
>
> Wed Feb 06 15:55:56 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[1, 78076E,
> 35.39261, -120.0947, 328, 30000, 462, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:56:30 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
>
> Wed Feb 06 15:55:56 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[5, 78076E,
> 34.77266, -119.643, 329, 29900, 452, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:50:51 UTC 2018, LAX, PEK, CA984, 0, 1152.0, 0000000, null, 0]]
>
> Wed Feb 06 15:55:56 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[9, 78076E,
> 35.37574, -120.08237, 328, 30000, 462, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:56:21 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
>
> Wed Feb 06 15:55:57 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[30, 78076E,
> 35.73808, -120.35001, 328, 30000, 461, 7246, 5000, B77W, B-2088, Tue Oct 16
> 07:59:39 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
>
> Wed Feb 06 15:55:57 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[35, 78076E,
> 35.14856, -119.91589, 329, 30000, 459, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:54:16 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
>
> Wed Feb 06 15:55:58 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[47, 78076E,
> 35.25854, -119.99635, 328, 30000, 462, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:55:17 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
>
> Wed Feb 06 15:55:58 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[49, 78076E,
> 34.77266, -119.643, 329, 29900, 452, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:50:51 UTC 2018, LAX, PEK, CA984, 0, 1152.0, 0000000, null, 0]]
>
> Wed Feb 06 15:55:59 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[61, 78076E,
> 35.02721, -119.82754, 329, 30000, 457, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:53:11 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
>
> Wed Feb 06 15:56:00 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[83, 78076E,
> 34.81073, -119.67054, 329, 30000, 457, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:51:11 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
>
> Wed Feb 06 15:56:00 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[94, 78076E,
> 35.17044, -119.93186, 328, 30000, 459, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:54:28 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
>
> Wed Feb 06 15:56:00 CET 2019 [TRC] Error during insertion : Failed to
> execute DML statement [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[96, 78076E,
> 35.15988, -119.92412, 328, 30000, 459, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:54:23 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
>
> Wed Feb 06 15:56:01 CET 2019 [TRC] Close statement.
>
> Wed Feb 06 15:56:01 CET 2019 [TRC] Rollback.
>
> Wed Feb 06 15:56:01 CET 2019 [TRC] Rollbacked.
>
> Wed Feb 06 15:56:01 CET 2019 [WRN] Sleep & retry.
>
> Wed Feb 06 15:56:02 CET 2019 [TRC] Diconnecting.
>
> Wed Feb 06 15:56:02 CET 2019 [TRC] Diconnected.
>
> Wed Feb 06 15:56:02 CET 2019 [TRC] Connect to :
> jdbc:ignite:thin://nx101c,nx102a,nx103b/KSDATA?user=CLUSER&password=clpassword
>
> Wed Feb 06 15:56:02 CET 2019 [TRC] Connected.
>
> Wed Feb 06 15:56:02 CET 2019 [ERR] Failed to execute DML statement
> [stmt=insert into
> benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[96, 78076E,
> 35.15988, -119.92412, 328, 30000, 459, 7246, 200, B77W, B-2088, Tue Oct 16
> 07:54:23 UTC 2018, LAX, PEK, CA984, 0, 0.0, 0000000, null, 0]]
>
> Wed Feb 06 15:56:02 CET 2019 [INF] Progress : 10%
>
> ...
>
> Wed Feb 06 15:58:44 CET 2019 [TRC] Diconnecting.
>
> Wed Feb 06 15:58:44 CET 2019 [TRC] Diconnected.
>
> Wed Feb 06 15:58:44 CET 2019 [INF] Progress : 100%
>
> Wed Feb 06 15:58:44 CET 2019 [INF] Durée : 180801ms
>
> Wed Feb 06 15:58:44 CET 2019 [INF] Metrics : 1 ; 1000 ; 100 ; 1 ; 180801
>
> Wed Feb 06 15:58:44 CET 2019 [INF] Purge des processus.
>
> Wed Feb 06 15:58:44 CET 2019 [INF] Synchronisation des disques du cluster.
>
> Wed Feb 06 15:58:44 CET 2019 [TRC] Diconnecting.
>
> Wed Feb 06 15:58:44 CET 2019 [WRN] Try to close closed/non-existent
> connection.
>
> Wed Feb 06 15:58:44 CET 2019 [INF] Relance du cluster.
>
> Wed Feb 06 15:58:44 CET 2019 [INF] Récupération des derniers indicateurs
> systéme.
>
> Wed Feb 06 15:58:44 CET 2019 [INF] Sauvegarde des données.
>
> Wed Feb 06 15:58:44 CET 2019 [INF] FILEOUTPUT :
> results/benchmark.insert_csv_1_1000_100_ignite-jdbc_nx101c,nx102a,nx103b_KSDATA.ser
>
> Wed Feb 06 15:58:44 CET 2019 [INF] Fin du test.
>
> Wed Feb 06 15:58:44 CET 2019 [INF]
> ---------------------------------------------------------
>
> Wed Feb 06 15:58:44 CET 2019 [TRC] Diconnecting.
>
> Wed Feb 06 15:58:44 CET 2019 [WRN] Try to close closed/non-existent
> connection.
>
>
>
> If we control DATA :
>
>
>
> 0: jdbc:ignite:thin://nx102a:10800> select count(*) from KSDATA.BENCHMARK;
>
> +--------------------------------+
>
> | COUNT(*) |
>
> +--------------------------------+
>
> | 899 |
>
> +--------------------------------+
>
> 1 row selected (0.01 seconds)
>
>
>
> We have only 899 rows versus 1 000 inserted !
>
>
>
> Cordialement,
>
>
> *— NOTE : n/a*
> —
> Gfi Informatique
> *Philippe Cerou*
> Architecte & Expert Système
> GFI Production / Toulouse
> philippe.cerou @gfi.fr
>
> —
>
> 1 Rond-point du Général Eisenhower, 31400 Toulouse
>
> Tél. : +33 (0)5.62.85.11.55
> Mob. : +33 (0)6.03.56.48.62
> *www.gfi.world* <http://www.gfi.world/>
>
> —
>
> [image: Facebook] <https://www.facebook.com/gfiinformatique> [image:
> Twitter] <https://twitter.com/gfiinformatique> [image: Instagram]
> <https://www.instagram.com/gfiinformatique/> [image: LinkedIn]
> <https://www.linkedin.com/company/gfi-informatique> [image: YouTube]
> <https://www.youtube.com/user/GFIinformatique>
> —
> [image: cid:image006.jpg@01D2F97F.AA6ABB50] <http://www.gfi.world/>
>
>
>
>
>