Insert failover on cluster with Java JDBC client do not seems to run.

classic Classic list List threaded Threaded
4 messages Options
philcero philcero
Reply | Threaded
Open this post in threaded view
|

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 

 

Facebook Twitter Instagram LinkedIn YouTube

cid:image006.jpg@01D2F97F.AA6ABB50

 

 

ilya.kasnacheev ilya.kasnacheev
Reply | Threaded
Open this post in threaded view
|

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 <[hidden email]>:

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 

 

Facebook Twitter Instagram LinkedIn YouTube

cid:image006.jpg@01D2F97F.AA6ABB50

 

 

philcero philcero
Reply | Threaded
Open this post in threaded view
|

RE: Insert failover on cluster with Java JDBC client do not seems to run.

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 

 

Facebook Twitter Instagram LinkedIn YouTube

cid:image006.jpg@01D2F97F.AA6ABB50

 

 

De : Ilya Kasnacheev [mailto:[hidden email]]
Envoyé : jeudi 7 février 2019 14:01
À : [hidden email]
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 <[hidden email]>:

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 

 

Facebook Twitter Instagram LinkedIn YouTube

cid:image006.jpg@01D2F97F.AA6ABB50

 

 

ilya.kasnacheev ilya.kasnacheev
Reply | Threaded
Open this post in threaded view
|

Re: Insert failover on cluster with Java JDBC client do not seems to run.

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 <[hidden email]>:

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 

 

Facebook Twitter Instagram LinkedIn YouTube

cid:image006.jpg@01D2F97F.AA6ABB50

 

 

De : Ilya Kasnacheev [mailto:[hidden email]]
Envoyé : jeudi 7 février 2019 14:01
À : [hidden email]
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 <[hidden email]>:

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 

 

Facebook Twitter Instagram LinkedIn YouTube

cid:image006.jpg@01D2F97F.AA6ABB50