ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Philippe CEROU <philippe.ce...@gfi.fr>
Subject Insert failover on cluster with Java JDBC client do not seems to run.
Date Wed, 06 Feb 2019 15:12:40 GMT
Hi,

We are testing Ignite failover capabilities and it seems that if we create a table in a replicated/partitioned
region and then we proceed to insertion we experiment insertion exception.

When a collection of 100 rows insertion statements fail we try again three time in a loop
reconnecting at third try.

Any idea ?

Test log :

Wed Feb 06 15:55:37 CET 2019 [TRC] Connect to : jdbc:ignite:thin://nx101c,nx102a,nx103b/KSDATA?user=CLUSER&password=clpassword
Wed Feb 06 15:55:38 CET 2019 [TRC] Connected.
Wed Feb 06 15:55:38 CET 2019 [TRC] Diconnecting.
Wed Feb 06 15:55:38 CET 2019 [TRC] Diconnected.
Wed Feb 06 15:55:38 CET 2019 [INF] ---------------------------------------------------------
Wed Feb 06 15:55:38 CET 2019 [INF] Amorce test [1 x 1000 : 100], itération #1
Wed Feb 06 15:55:38 CET 2019 [INF] Suppression de la table de travail.
Wed Feb 06 15:55:38 CET 2019 [TRC] Diconnecting.
Wed Feb 06 15:55:38 CET 2019 [WRN] Try to close closed/non-existent connection.
Wed Feb 06 15:55:38 CET 2019 [TRC] Connect to : jdbc:ignite:thin://nx101c,nx102a,nx103b/KSDATA?user=CLUSER&password=clpassword
Wed Feb 06 15:55:38 CET 2019 [TRC] Connected.
Wed Feb 06 15:55:38 CET 2019 [TRC] Run query : drop table if exists benchmark
Wed Feb 06 15:55:38 CET 2019 [TRC] Query executed.
Wed Feb 06 15:55:38 CET 2019 [TRC] Committing.
Wed Feb 06 15:55:39 CET 2019 [TRC] Committed.
Wed Feb 06 15:55:39 CET 2019 [TRC] Diconnecting.
Wed Feb 06 15:55:39 CET 2019 [TRC] Diconnected.
Wed Feb 06 15:55:39 CET 2019 [INF] Création instance SSH.
Wed Feb 06 15:55:39 CET 2019 [INF] Purge de la base de données.
Wed Feb 06 15:55:39 CET 2019 [INF] Création de la table de travail.
Wed Feb 06 15:55:39 CET 2019 [TRC] Diconnecting.
Wed Feb 06 15:55:39 CET 2019 [WRN] Try to close closed/non-existent connection.
Wed Feb 06 15:55:39 CET 2019 [TRC] Connect to : jdbc:ignite:thin://nx101c,nx102a,nx103b/KSDATA?user=CLUSER&password=clpassword
Wed Feb 06 15:55:39 CET 2019 [WRN] Connection error, retry.
Wed Feb 06 15:55:40 CET 2019 [TRC] Connect to : jdbc:ignite:thin://nx101c,nx102a,nx103b/KSDATA?user=CLUSER&password=clpassword
Wed Feb 06 15:55:40 CET 2019 [TRC] Connected.
Wed Feb 06 15:55:40 CET 2019 [TRC] Run query : create table benchmark (id NUMERIC(10) primary
key,C001 VARCHAR(30),C002 float,C003 float,C004 NUMERIC(10),C005 NUMERIC(10),C006 NUMERIC(10),C007
NUMERIC(10),C008 NUMERIC(10),C009 VARCHAR(30),C010 VARCHAR(30),C011 DATE,C012 VARCHAR(30),C013
VARCHAR(30),C014 VARCHAR(30),C015 NUMERIC(10),C016 float,C017 VARCHAR(30),C018 VARCHAR(30),C019
VARCHAR(30)) WITH "BACKUPS=1, WRITE_SYNCHRONIZATION_MODE=FULL_ASYNC, ATOMICITY=ATOMIC, AFFINITYKEY=id"
Wed Feb 06 15:55:40 CET 2019 [TRC] Query executed.
Wed Feb 06 15:55:40 CET 2019 [TRC] Committing.
Wed Feb 06 15:55:40 CET 2019 [TRC] Committed.
Wed Feb 06 15:55:40 CET 2019 [TRC] Run query : create index benchmarkc001 on benchmark(c001)
Wed Feb 06 15:55:40 CET 2019 [TRC] Query executed.
Wed Feb 06 15:55:40 CET 2019 [TRC] Committing.
Wed Feb 06 15:55:40 CET 2019 [TRC] Committed.
Wed Feb 06 15:55:40 CET 2019 [TRC] Run query : create index benchmarkc002 on benchmark(c002)
Wed Feb 06 15:55:40 CET 2019 [TRC] Query executed.
Wed Feb 06 15:55:40 CET 2019 [TRC] Committing.
Wed Feb 06 15:55:40 CET 2019 [TRC] Committed.
Wed Feb 06 15:55:40 CET 2019 [TRC] Run query : create index benchmarkc003 on benchmark(c003)
Wed Feb 06 15:55:40 CET 2019 [TRC] Query executed.
Wed Feb 06 15:55:40 CET 2019 [TRC] Committing.
Wed Feb 06 15:55:40 CET 2019 [TRC] Committed.
Wed Feb 06 15:55:40 CET 2019 [TRC] Run query : create index benchmarkc011 on benchmark(c011)
Wed Feb 06 15:55:40 CET 2019 [TRC] Query executed.
Wed Feb 06 15:55:40 CET 2019 [TRC] Committing.
Wed Feb 06 15:55:40 CET 2019 [TRC] Committed.
Wed Feb 06 15:55:40 CET 2019 [TRC] Diconnecting.
Wed Feb 06 15:55:40 CET 2019 [TRC] Diconnected.
Wed Feb 06 15:55:41 CET 2019 [INF] Relance du cluster.
Wed Feb 06 15:55:42 CET 2019 [INF] Initialisation indicateurs
Wed Feb 06 15:55:42 CET 2019 [INF] Préparation des processus.
Wed Feb 06 15:55:42 CET 2019 [TRC] Connect to : jdbc:ignite:thin://nx101c,nx102a,nx103b/KSDATA?user=CLUSER&password=clpassword
Wed Feb 06 15:55:43 CET 2019 [TRC] Connected.
Wed Feb 06 15:55:43 CET 2019 [INF] Activation des processus.
Wed Feb 06 15:55:43 CET 2019 [INF] Progress : 0%
Wed Feb 06 15:55:43 CET 2019 [TRC] Error during insertion : Failed to execute DML statement
[stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[1, 78076E, 35.39261, -120.0947,
328, 30000, 462, 7246, 200, B77W, B-2088, Tue Oct 16 07:56:30 UTC 2018, LAX, PEK, CA984, 0,
0.0, 0000000, null, 0]]
Wed Feb 06 15:55:43 CET 2019 [TRC] Error during insertion : Failed to execute DML statement
[stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[5, 78076E, 34.77266, -119.643, 329,
29900, 452, 7246, 200, B77W, B-2088, Tue Oct 16 07:50:51 UTC 2018, LAX, PEK, CA984, 0, 1152.0,
0000000, null, 0]]
Wed Feb 06 15:55:44 CET 2019 [TRC] Error during insertion : Failed to execute DML statement
[stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[9, 78076E, 35.37574, -120.08237,
328, 30000, 462, 7246, 200, B77W, B-2088, Tue Oct 16 07:56:21 UTC 2018, LAX, PEK, CA984, 0,
0.0, 0000000, null, 0]]
Wed Feb 06 15:55:45 CET 2019 [TRC] Error during insertion : Failed to execute DML statement
[stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[30, 78076E, 35.73808, -120.35001,
328, 30000, 461, 7246, 5000, B77W, B-2088, Tue Oct 16 07:59:39 UTC 2018, LAX, PEK, CA984,
0, 0.0, 0000000, null, 0]]
Wed Feb 06 15:55:45 CET 2019 [TRC] Error during insertion : Failed to execute DML statement
[stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[35, 78076E, 35.14856, -119.91589,
329, 30000, 459, 7246, 200, B77W, B-2088, Tue Oct 16 07:54:16 UTC 2018, LAX, PEK, CA984, 0,
0.0, 0000000, null, 0]]
Wed Feb 06 15:55:46 CET 2019 [TRC] Error during insertion : Failed to execute DML statement
[stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[47, 78076E, 35.25854, -119.99635,
328, 30000, 462, 7246, 200, B77W, B-2088, Tue Oct 16 07:55:17 UTC 2018, LAX, PEK, CA984, 0,
0.0, 0000000, null, 0]]
Wed Feb 06 15:55:46 CET 2019 [TRC] Error during insertion : Failed to execute DML statement
[stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[49, 78076E, 34.77266, -119.643,
329, 29900, 452, 7246, 200, B77W, B-2088, Tue Oct 16 07:50:51 UTC 2018, LAX, PEK, CA984, 0,
1152.0, 0000000, null, 0]]
Wed Feb 06 15:55:47 CET 2019 [TRC] Error during insertion : Failed to execute DML statement
[stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[61, 78076E, 35.02721, -119.82754,
329, 30000, 457, 7246, 200, B77W, B-2088, Tue Oct 16 07:53:11 UTC 2018, LAX, PEK, CA984, 0,
0.0, 0000000, null, 0]]
Wed Feb 06 15:55:48 CET 2019 [TRC] Error during insertion : Failed to execute DML statement
[stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[83, 78076E, 34.81073, -119.67054,
329, 30000, 457, 7246, 200, B77W, B-2088, Tue Oct 16 07:51:11 UTC 2018, LAX, PEK, CA984, 0,
0.0, 0000000, null, 0]]
Wed Feb 06 15:55:48 CET 2019 [TRC] Error during insertion : Failed to execute DML statement
[stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[94, 78076E, 35.17044, -119.93186,
328, 30000, 459, 7246, 200, B77W, B-2088, Tue Oct 16 07:54:28 UTC 2018, LAX, PEK, CA984, 0,
0.0, 0000000, null, 0]]
Wed Feb 06 15:55:48 CET 2019 [TRC] Error during insertion : Failed to execute DML statement
[stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[96, 78076E, 35.15988, -119.92412,
328, 30000, 459, 7246, 200, B77W, B-2088, Tue Oct 16 07:54:23 UTC 2018, LAX, PEK, CA984, 0,
0.0, 0000000, null, 0]]
Wed Feb 06 15:55:48 CET 2019 [TRC] Close statement.
Wed Feb 06 15:55:48 CET 2019 [TRC] Rollback.
Wed Feb 06 15:55:48 CET 2019 [TRC] Rollbacked.
Wed Feb 06 15:55:48 CET 2019 [WRN] Sleep & retry.
Wed Feb 06 15:55:49 CET 2019 [TRC] Error during insertion : Failed to execute DML statement
[stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[1, 78076E, 35.39261, -120.0947,
328, 30000, 462, 7246, 200, B77W, B-2088, Tue Oct 16 07:56:30 UTC 2018, LAX, PEK, CA984, 0,
0.0, 0000000, null, 0]]
Wed Feb 06 15:55:50 CET 2019 [TRC] Error during insertion : Failed to execute DML statement
[stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[5, 78076E, 34.77266, -119.643, 329,
29900, 452, 7246, 200, B77W, B-2088, Tue Oct 16 07:50:51 UTC 2018, LAX, PEK, CA984, 0, 1152.0,
0000000, null, 0]]
Wed Feb 06 15:55:50 CET 2019 [TRC] Error during insertion : Failed to execute DML statement
[stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[9, 78076E, 35.37574, -120.08237,
328, 30000, 462, 7246, 200, B77W, B-2088, Tue Oct 16 07:56:21 UTC 2018, LAX, PEK, CA984, 0,
0.0, 0000000, null, 0]]
Wed Feb 06 15:55:51 CET 2019 [TRC] Error during insertion : Failed to execute DML statement
[stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[30, 78076E, 35.73808, -120.35001,
328, 30000, 461, 7246, 5000, B77W, B-2088, Tue Oct 16 07:59:39 UTC 2018, LAX, PEK, CA984,
0, 0.0, 0000000, null, 0]]
Wed Feb 06 15:55:51 CET 2019 [TRC] Error during insertion : Failed to execute DML statement
[stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[35, 78076E, 35.14856, -119.91589,
329, 30000, 459, 7246, 200, B77W, B-2088, Tue Oct 16 07:54:16 UTC 2018, LAX, PEK, CA984, 0,
0.0, 0000000, null, 0]]
Wed Feb 06 15:55:51 CET 2019 [TRC] Error during insertion : Failed to execute DML statement
[stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[47, 78076E, 35.25854, -119.99635,
328, 30000, 462, 7246, 200, B77W, B-2088, Tue Oct 16 07:55:17 UTC 2018, LAX, PEK, CA984, 0,
0.0, 0000000, null, 0]]
Wed Feb 06 15:55:51 CET 2019 [TRC] Error during insertion : Failed to execute DML statement
[stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[49, 78076E, 34.77266, -119.643,
329, 29900, 452, 7246, 200, B77W, B-2088, Tue Oct 16 07:50:51 UTC 2018, LAX, PEK, CA984, 0,
1152.0, 0000000, null, 0]]
Wed Feb 06 15:55:52 CET 2019 [TRC] Error during insertion : Failed to execute DML statement
[stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[61, 78076E, 35.02721, -119.82754,
329, 30000, 457, 7246, 200, B77W, B-2088, Tue Oct 16 07:53:11 UTC 2018, LAX, PEK, CA984, 0,
0.0, 0000000, null, 0]]
Wed Feb 06 15:55:53 CET 2019 [TRC] Error during insertion : Failed to execute DML statement
[stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[83, 78076E, 34.81073, -119.67054,
329, 30000, 457, 7246, 200, B77W, B-2088, Tue Oct 16 07:51:11 UTC 2018, LAX, PEK, CA984, 0,
0.0, 0000000, null, 0]]
Wed Feb 06 15:55:53 CET 2019 [TRC] Error during insertion : Failed to execute DML statement
[stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[94, 78076E, 35.17044, -119.93186,
328, 30000, 459, 7246, 200, B77W, B-2088, Tue Oct 16 07:54:28 UTC 2018, LAX, PEK, CA984, 0,
0.0, 0000000, null, 0]]
Wed Feb 06 15:55:53 CET 2019 [TRC] Error during insertion : Failed to execute DML statement
[stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[96, 78076E, 35.15988, -119.92412,
328, 30000, 459, 7246, 200, B77W, B-2088, Tue Oct 16 07:54:23 UTC 2018, LAX, PEK, CA984, 0,
0.0, 0000000, null, 0]]
Wed Feb 06 15:55:54 CET 2019 [TRC] Close statement.
Wed Feb 06 15:55:54 CET 2019 [TRC] Rollback.
Wed Feb 06 15:55:54 CET 2019 [TRC] Rollbacked.
Wed Feb 06 15:55:54 CET 2019 [WRN] Sleep & retry.
Wed Feb 06 15:55:55 CET 2019 [TRC] Diconnecting.
Wed Feb 06 15:55:55 CET 2019 [TRC] Diconnected.
Wed Feb 06 15:55:55 CET 2019 [TRC] Connect to : jdbc:ignite:thin://nx101c,nx102a,nx103b/KSDATA?user=CLUSER&password=clpassword
Wed Feb 06 15:55:55 CET 2019 [WRN] Connection error, retry.
Wed Feb 06 15:55:56 CET 2019 [TRC] Connect to : jdbc:ignite:thin://nx101c,nx102a,nx103b/KSDATA?user=CLUSER&password=clpassword
Wed Feb 06 15:55:56 CET 2019 [TRC] Connected.
Wed Feb 06 15:55:56 CET 2019 [TRC] Error during insertion : Failed to execute DML statement
[stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[1, 78076E, 35.39261, -120.0947,
328, 30000, 462, 7246, 200, B77W, B-2088, Tue Oct 16 07:56:30 UTC 2018, LAX, PEK, CA984, 0,
0.0, 0000000, null, 0]]
Wed Feb 06 15:55:56 CET 2019 [TRC] Error during insertion : Failed to execute DML statement
[stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[5, 78076E, 34.77266, -119.643, 329,
29900, 452, 7246, 200, B77W, B-2088, Tue Oct 16 07:50:51 UTC 2018, LAX, PEK, CA984, 0, 1152.0,
0000000, null, 0]]
Wed Feb 06 15:55:56 CET 2019 [TRC] Error during insertion : Failed to execute DML statement
[stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[9, 78076E, 35.37574, -120.08237,
328, 30000, 462, 7246, 200, B77W, B-2088, Tue Oct 16 07:56:21 UTC 2018, LAX, PEK, CA984, 0,
0.0, 0000000, null, 0]]
Wed Feb 06 15:55:57 CET 2019 [TRC] Error during insertion : Failed to execute DML statement
[stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[30, 78076E, 35.73808, -120.35001,
328, 30000, 461, 7246, 5000, B77W, B-2088, Tue Oct 16 07:59:39 UTC 2018, LAX, PEK, CA984,
0, 0.0, 0000000, null, 0]]
Wed Feb 06 15:55:57 CET 2019 [TRC] Error during insertion : Failed to execute DML statement
[stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[35, 78076E, 35.14856, -119.91589,
329, 30000, 459, 7246, 200, B77W, B-2088, Tue Oct 16 07:54:16 UTC 2018, LAX, PEK, CA984, 0,
0.0, 0000000, null, 0]]
Wed Feb 06 15:55:58 CET 2019 [TRC] Error during insertion : Failed to execute DML statement
[stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[47, 78076E, 35.25854, -119.99635,
328, 30000, 462, 7246, 200, B77W, B-2088, Tue Oct 16 07:55:17 UTC 2018, LAX, PEK, CA984, 0,
0.0, 0000000, null, 0]]
Wed Feb 06 15:55:58 CET 2019 [TRC] Error during insertion : Failed to execute DML statement
[stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[49, 78076E, 34.77266, -119.643,
329, 29900, 452, 7246, 200, B77W, B-2088, Tue Oct 16 07:50:51 UTC 2018, LAX, PEK, CA984, 0,
1152.0, 0000000, null, 0]]
Wed Feb 06 15:55:59 CET 2019 [TRC] Error during insertion : Failed to execute DML statement
[stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[61, 78076E, 35.02721, -119.82754,
329, 30000, 457, 7246, 200, B77W, B-2088, Tue Oct 16 07:53:11 UTC 2018, LAX, PEK, CA984, 0,
0.0, 0000000, null, 0]]
Wed Feb 06 15:56:00 CET 2019 [TRC] Error during insertion : Failed to execute DML statement
[stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[83, 78076E, 34.81073, -119.67054,
329, 30000, 457, 7246, 200, B77W, B-2088, Tue Oct 16 07:51:11 UTC 2018, LAX, PEK, CA984, 0,
0.0, 0000000, null, 0]]
Wed Feb 06 15:56:00 CET 2019 [TRC] Error during insertion : Failed to execute DML statement
[stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[94, 78076E, 35.17044, -119.93186,
328, 30000, 459, 7246, 200, B77W, B-2088, Tue Oct 16 07:54:28 UTC 2018, LAX, PEK, CA984, 0,
0.0, 0000000, null, 0]]
Wed Feb 06 15:56:00 CET 2019 [TRC] Error during insertion : Failed to execute DML statement
[stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[96, 78076E, 35.15988, -119.92412,
328, 30000, 459, 7246, 200, B77W, B-2088, Tue Oct 16 07:54:23 UTC 2018, LAX, PEK, CA984, 0,
0.0, 0000000, null, 0]]
Wed Feb 06 15:56:01 CET 2019 [TRC] Close statement.
Wed Feb 06 15:56:01 CET 2019 [TRC] Rollback.
Wed Feb 06 15:56:01 CET 2019 [TRC] Rollbacked.
Wed Feb 06 15:56:01 CET 2019 [WRN] Sleep & retry.
Wed Feb 06 15:56:02 CET 2019 [TRC] Diconnecting.
Wed Feb 06 15:56:02 CET 2019 [TRC] Diconnected.
Wed Feb 06 15:56:02 CET 2019 [TRC] Connect to : jdbc:ignite:thin://nx101c,nx102a,nx103b/KSDATA?user=CLUSER&password=clpassword
Wed Feb 06 15:56:02 CET 2019 [TRC] Connected.
Wed Feb 06 15:56:02 CET 2019 [ERR] Failed to execute DML statement [stmt=insert into benchmark(id,C001,C002,C003,C004,C005,C006,C007,C008,C009,C010,C011,C012,C013,C014,C015,C016,C017,C018,C019)
values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), params=[96, 78076E, 35.15988, -119.92412,
328, 30000, 459, 7246, 200, B77W, B-2088, Tue Oct 16 07:54:23 UTC 2018, LAX, PEK, CA984, 0,
0.0, 0000000, null, 0]]
Wed Feb 06 15:56:02 CET 2019 [INF] Progress : 10%
...
Wed Feb 06 15:58:44 CET 2019 [TRC] Diconnecting.
Wed Feb 06 15:58:44 CET 2019 [TRC] Diconnected.
Wed Feb 06 15:58:44 CET 2019 [INF] Progress : 100%
Wed Feb 06 15:58:44 CET 2019 [INF] Durée : 180801ms
Wed Feb 06 15:58:44 CET 2019 [INF] Metrics : 1 ; 1000 ; 100 ; 1 ; 180801
Wed Feb 06 15:58:44 CET 2019 [INF] Purge des processus.
Wed Feb 06 15:58:44 CET 2019 [INF] Synchronisation des disques du cluster.
Wed Feb 06 15:58:44 CET 2019 [TRC] Diconnecting.
Wed Feb 06 15:58:44 CET 2019 [WRN] Try to close closed/non-existent connection.
Wed Feb 06 15:58:44 CET 2019 [INF] Relance du cluster.
Wed Feb 06 15:58:44 CET 2019 [INF] Récupération des derniers indicateurs systéme.
Wed Feb 06 15:58:44 CET 2019 [INF] Sauvegarde des données.
Wed Feb 06 15:58:44 CET 2019 [INF] FILEOUTPUT : results/benchmark.insert_csv_1_1000_100_ignite-jdbc_nx101c,nx102a,nx103b_KSDATA.ser
Wed Feb 06 15:58:44 CET 2019 [INF] Fin du test.
Wed Feb 06 15:58:44 CET 2019 [INF] ---------------------------------------------------------
Wed Feb 06 15:58:44 CET 2019 [TRC] Diconnecting.
Wed Feb 06 15:58:44 CET 2019 [WRN] Try to close closed/non-existent connection.

If we control DATA :

0: jdbc:ignite:thin://nx102a:10800> select count(*) from KSDATA.BENCHMARK;
+--------------------------------+
|            COUNT(*)            |
+--------------------------------+
| 899                            |
+--------------------------------+
1 row selected (0.01 seconds)

We have only 899 rows versus 1 000 inserted !

Cordialement,

-
NOTE : n/a
-
Gfi Informatique
Philippe Cerou
Architecte & Expert Système
GFI Production / Toulouse
philippe.cerou @gfi.fr
-
1 Rond-point du Général Eisenhower, 31400 Toulouse
Tél. : +33 (0)5.62.85.11.55
Mob. : +33 (0)6.03.56.48.62
www.gfi.world<http://www.gfi.world/>
-
[Facebook]<https://www.facebook.com/gfiinformatique> [Twitter] <https://twitter.com/gfiinformatique>
 [Instagram] <https://www.instagram.com/gfiinformatique/>  [LinkedIn] <https://www.linkedin.com/company/gfi-informatique>
 [YouTube] <https://www.youtube.com/user/GFIinformatique>
-
[cid:image006.jpg@01D2F97F.AA6ABB50]<http://www.gfi.world/>



Mime
View raw message