See <http://ci.codelutin.com/jenkins/job/observe-ci/fr.ird.observe$services-topia/468/display/redirect> ------------------------------------------ [...truncated 182.83 KB...] DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:208) createReadStatement - Read sql: SELECT hooktype.* FROM observe_longline.hooktype hooktype DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [216720ns] for method 'Read statement', SELECT hooktype.* FROM observe_longline.hooktype hooktype (total call 51, total time 151.944ms, min time 34249ns, max time 55.333ms, avg time 2.979ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction:183) newInsertStatementSql - Insert sql: INSERT INTO observe_longline.hooktype(topiaid, topiaversion, topiacreatedate, lastupdatedate, code, uri, needcomment, status, label1, label2, label3, label4, label5, label6, label7, label8) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.hooktype (size: 13) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [2.406ms] for method 'Execute on table', SELECT hooktype.* FROM observe_longline.hooktype hooktype (total call 51, total time 1.979s, min time 854658ns, max time 647.649ms, avg time 38.794ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [3.22ms] for method 'Executed on table.', observe_longline.hooktype (total call 51, total time 7.771s, min time 1.513ms, max time 4.556s, avg time 152.379ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:208) createReadStatement - Read sql: SELECT itemverticalposition.* FROM observe_longline.itemverticalposition itemverticalposition DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [48021ns] for method 'Read statement', SELECT itemverticalposition.* FROM observe_longline.itemverticalposition itemverticalposition (total call 52, total time 151.992ms, min time 34249ns, max time 55.333ms, avg time 2.923ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction:183) newInsertStatementSql - Insert sql: INSERT INTO observe_longline.itemverticalposition(topiaid, topiaversion, topiacreatedate, lastupdatedate, code, uri, needcomment, status, label1, label2, label3, label4, label5, label6, label7, label8) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.itemverticalposition (size: 3) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [889012ns] for method 'Execute on table', SELECT itemverticalposition.* FROM observe_longline.itemverticalposition itemverticalposition (total call 52, total time 1.979s, min time 854658ns, max time 647.649ms, avg time 38.065ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [1.525ms] for method 'Executed on table.', observe_longline.itemverticalposition (total call 52, total time 7.773s, min time 1.513ms, max time 4.556s, avg time 149.478ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:208) createReadStatement - Read sql: SELECT itemhorizontalposition.* FROM observe_longline.itemhorizontalposition itemhorizontalposition DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [33113ns] for method 'Read statement', SELECT itemhorizontalposition.* FROM observe_longline.itemhorizontalposition itemhorizontalposition (total call 53, total time 152.025ms, min time 33113ns, max time 55.333ms, avg time 2.868ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction:183) newInsertStatementSql - Insert sql: INSERT INTO observe_longline.itemhorizontalposition(topiaid, topiaversion, topiacreatedate, lastupdatedate, code, uri, needcomment, status, label1, label2, label3, label4, label5, label6, label7, label8) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.itemhorizontalposition (size: 3) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [790873ns] for method 'Execute on table', SELECT itemhorizontalposition.* FROM observe_longline.itemhorizontalposition itemhorizontalposition (total call 53, total time 1.98s, min time 790873ns, max time 647.649ms, avg time 37.362ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [1.384ms] for method 'Executed on table.', observe_longline.itemhorizontalposition (total call 53, total time 7.774s, min time 1.384ms, max time 4.556s, avg time 146.684ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:208) createReadStatement - Read sql: SELECT lightstickscolor.* FROM observe_longline.lightstickscolor lightstickscolor DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [50365ns] for method 'Read statement', SELECT lightstickscolor.* FROM observe_longline.lightstickscolor lightstickscolor (total call 54, total time 152.076ms, min time 33113ns, max time 55.333ms, avg time 2.816ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction:183) newInsertStatementSql - Insert sql: INSERT INTO observe_longline.lightstickscolor(topiaid, topiaversion, topiacreatedate, lastupdatedate, code, uri, needcomment, status, label1, label2, label3, label4, label5, label6, label7, label8) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.lightstickscolor (size: 7) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [1.261ms] for method 'Execute on table', SELECT lightstickscolor.* FROM observe_longline.lightstickscolor lightstickscolor (total call 54, total time 1.981s, min time 790873ns, max time 647.649ms, avg time 36.694ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [1.833ms] for method 'Executed on table.', observe_longline.lightstickscolor (total call 54, total time 7.776s, min time 1.384ms, max time 4.556s, avg time 144.001ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:208) createReadStatement - Read sql: SELECT lightstickstype.* FROM observe_longline.lightstickstype lightstickstype DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [42987ns] for method 'Read statement', SELECT lightstickstype.* FROM observe_longline.lightstickstype lightstickstype (total call 55, total time 152.119ms, min time 33113ns, max time 55.333ms, avg time 2.766ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction:183) newInsertStatementSql - Insert sql: INSERT INTO observe_longline.lightstickstype(topiaid, topiaversion, topiacreatedate, lastupdatedate, code, uri, needcomment, status, label1, label2, label3, label4, label5, label6, label7, label8) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.lightstickstype (size: 2) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [689476ns] for method 'Execute on table', SELECT lightstickstype.* FROM observe_longline.lightstickstype lightstickstype (total call 55, total time 1.982s, min time 689476ns, max time 647.649ms, avg time 36.039ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [1.259ms] for method 'Executed on table.', observe_longline.lightstickstype (total call 55, total time 7.777s, min time 1.259ms, max time 4.556s, avg time 141.406ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:208) createReadStatement - Read sql: SELECT linetype.* FROM observe_longline.linetype linetype DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [78619ns] for method 'Read statement', SELECT linetype.* FROM observe_longline.linetype linetype (total call 56, total time 152.197ms, min time 33113ns, max time 55.333ms, avg time 2.718ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction:183) newInsertStatementSql - Insert sql: INSERT INTO observe_longline.linetype(topiaid, topiaversion, topiacreatedate, lastupdatedate, code, uri, needcomment, status, label1, label2, label3, label4, label5, label6, label7, label8) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.linetype (size: 8) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [1.388ms] for method 'Execute on table', SELECT linetype.* FROM observe_longline.linetype linetype (total call 56, total time 1.984s, min time 689476ns, max time 647.649ms, avg time 35.42ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [2.042ms] for method 'Executed on table.', observe_longline.linetype (total call 56, total time 7.779s, min time 1.259ms, max time 4.556s, avg time 138.917ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:208) createReadStatement - Read sql: SELECT maturitystatus.* FROM observe_longline.maturitystatus maturitystatus DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [70364ns] for method 'Read statement', SELECT maturitystatus.* FROM observe_longline.maturitystatus maturitystatus (total call 57, total time 152.268ms, min time 33113ns, max time 55.333ms, avg time 2.671ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction:183) newInsertStatementSql - Insert sql: INSERT INTO observe_longline.maturitystatus(topiaid, topiaversion, topiacreatedate, lastupdatedate, code, uri, needcomment, status, label1, label2, label3, label4, label5, label6, label7, label8, lowervalue, uppervalue) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.maturitystatus (size: 12) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [1.944ms] for method 'Execute on table', SELECT maturitystatus.* FROM observe_longline.maturitystatus maturitystatus (total call 57, total time 1.985s, min time 689476ns, max time 647.649ms, avg time 34.833ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [2.55ms] for method 'Executed on table.', observe_longline.maturitystatus (total call 57, total time 7.782s, min time 1.259ms, max time 4.556s, avg time 136.525ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:208) createReadStatement - Read sql: SELECT mitigationtype.* FROM observe_longline.mitigationtype mitigationtype DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [229813ns] for method 'Read statement', SELECT mitigationtype.* FROM observe_longline.mitigationtype mitigationtype (total call 58, total time 152.497ms, min time 33113ns, max time 55.333ms, avg time 2.629ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction:183) newInsertStatementSql - Insert sql: INSERT INTO observe_longline.mitigationtype(topiaid, topiaversion, topiacreatedate, lastupdatedate, code, uri, needcomment, status, label1, label2, label3, label4, label5, label6, label7, label8) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.mitigationtype (size: 15) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [2.342ms] for method 'Execute on table', SELECT mitigationtype.* FROM observe_longline.mitigationtype mitigationtype (total call 58, total time 1.988s, min time 689476ns, max time 647.649ms, avg time 34.273ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [3.101ms] for method 'Executed on table.', observe_longline.mitigationtype (total call 58, total time 7.785s, min time 1.259ms, max time 4.556s, avg time 134.225ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:208) createReadStatement - Read sql: SELECT sensorbrand.* FROM observe_longline.sensorbrand sensorbrand DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [32632ns] for method 'Read statement', SELECT sensorbrand.* FROM observe_longline.sensorbrand sensorbrand (total call 59, total time 152.53ms, min time 32632ns, max time 55.333ms, avg time 2.585ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction:183) newInsertStatementSql - Insert sql: INSERT INTO observe_longline.sensorbrand(topiaid, topiaversion, topiacreatedate, lastupdatedate, code, uri, needcomment, status, brandname) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.sensorbrand (size: 4) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [779413ns] for method 'Execute on table', SELECT sensorbrand.* FROM observe_longline.sensorbrand sensorbrand (total call 59, total time 1.989s, min time 689476ns, max time 647.649ms, avg time 33.705ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [1.317ms] for method 'Executed on table.', observe_longline.sensorbrand (total call 59, total time 7.786s, min time 1.259ms, max time 4.556s, avg time 131.972ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:208) createReadStatement - Read sql: SELECT sensordataformat.* FROM observe_longline.sensordataformat sensordataformat DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [25761ns] for method 'Read statement', SELECT sensordataformat.* FROM observe_longline.sensordataformat sensordataformat (total call 60, total time 152.556ms, min time 25761ns, max time 55.333ms, avg time 2.543ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction:183) newInsertStatementSql - Insert sql: INSERT INTO observe_longline.sensordataformat(topiaid, topiaversion, topiacreatedate, lastupdatedate, code, uri, needcomment, status, label1, label2, label3, label4, label5, label6, label7, label8) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.sensordataformat (size: 2) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [628630ns] for method 'Execute on table', SELECT sensordataformat.* FROM observe_longline.sensordataformat sensordataformat (total call 60, total time 1.989s, min time 628630ns, max time 647.649ms, avg time 33.154ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [1.163ms] for method 'Executed on table.', observe_longline.sensordataformat (total call 60, total time 7.788s, min time 1.163ms, max time 4.556s, avg time 129.792ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:208) createReadStatement - Read sql: SELECT sensortype.* FROM observe_longline.sensortype sensortype DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [33562ns] for method 'Read statement', SELECT sensortype.* FROM observe_longline.sensortype sensortype (total call 61, total time 152.589ms, min time 25761ns, max time 55.333ms, avg time 2.501ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction:183) newInsertStatementSql - Insert sql: INSERT INTO observe_longline.sensortype(topiaid, topiaversion, topiacreatedate, lastupdatedate, code, uri, needcomment, status, label1, label2, label3, label4, label5, label6, label7, label8) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.sensortype (size: 4) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [873746ns] for method 'Execute on table', SELECT sensortype.* FROM observe_longline.sensortype sensortype (total call 61, total time 1.99s, min time 628630ns, max time 647.649ms, avg time 32.625ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [1.424ms] for method 'Executed on table.', observe_longline.sensortype (total call 61, total time 7.789s, min time 1.163ms, max time 4.556s, avg time 127.687ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:208) createReadStatement - Read sql: SELECT settingshape.* FROM observe_longline.settingshape settingshape DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [44911ns] for method 'Read statement', SELECT settingshape.* FROM observe_longline.settingshape settingshape (total call 62, total time 152.634ms, min time 25761ns, max time 55.333ms, avg time 2.462ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction:183) newInsertStatementSql - Insert sql: INSERT INTO observe_longline.settingshape(topiaid, topiaversion, topiacreatedate, lastupdatedate, code, uri, needcomment, status, label1, label2, label3, label4, label5, label6, label7, label8) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.settingshape (size: 6) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [1.115ms] for method 'Execute on table', SELECT settingshape.* FROM observe_longline.settingshape settingshape (total call 62, total time 1.991s, min time 628630ns, max time 647.649ms, avg time 32.116ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [1.74ms] for method 'Executed on table.', observe_longline.settingshape (total call 62, total time 7.791s, min time 1.163ms, max time 4.556s, avg time 125.656ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:208) createReadStatement - Read sql: SELECT stomacfullness.* FROM observe_longline.stomacfullness stomacfullness DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [50350ns] for method 'Read statement', SELECT stomacfullness.* FROM observe_longline.stomacfullness stomacfullness (total call 63, total time 152.685ms, min time 25761ns, max time 55.333ms, avg time 2.424ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction:183) newInsertStatementSql - Insert sql: INSERT INTO observe_longline.stomacfullness(topiaid, topiaversion, topiacreatedate, lastupdatedate, code, uri, needcomment, status, label1, label2, label3, label4, label5, label6, label7, label8) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.stomacfullness (size: 7) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [1.239ms] for method 'Execute on table', SELECT stomacfullness.* FROM observe_longline.stomacfullness stomacfullness (total call 63, total time 1.992s, min time 628630ns, max time 647.649ms, avg time 31.626ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [1.803ms] for method 'Executed on table.', observe_longline.stomacfullness (total call 63, total time 7.792s, min time 1.163ms, max time 4.556s, avg time 123.69ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:208) createReadStatement - Read sql: SELECT triptype.* FROM observe_longline.triptype triptype DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [34695ns] for method 'Read statement', SELECT triptype.* FROM observe_longline.triptype triptype (total call 64, total time 152.719ms, min time 25761ns, max time 55.333ms, avg time 2.386ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction:183) newInsertStatementSql - Insert sql: INSERT INTO observe_longline.triptype(topiaid, topiaversion, topiacreatedate, lastupdatedate, code, uri, needcomment, status, label1, label2, label3, label4, label5, label6, label7, label8) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.triptype (size: 3) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [848253ns] for method 'Execute on table', SELECT triptype.* FROM observe_longline.triptype triptype (total call 64, total time 1.993s, min time 628630ns, max time 647.649ms, avg time 31.145ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [1.571ms] for method 'Executed on table.', observe_longline.triptype (total call 64, total time 7.794s, min time 1.163ms, max time 4.556s, avg time 121.782ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:208) createReadStatement - Read sql: SELECT vesselactivity.* FROM observe_longline.vesselactivity vesselactivity DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [42579ns] for method 'Read statement', SELECT vesselactivity.* FROM observe_longline.vesselactivity vesselactivity (total call 65, total time 152.762ms, min time 25761ns, max time 55.333ms, avg time 2.35ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction:183) newInsertStatementSql - Insert sql: INSERT INTO observe_longline.vesselactivity(topiaid, topiaversion, topiacreatedate, lastupdatedate, code, uri, needcomment, status, label1, label2, label3, label4, label5, label6, label7, label8) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.vesselactivity (size: 5) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [1.007ms] for method 'Execute on table', SELECT vesselactivity.* FROM observe_longline.vesselactivity vesselactivity (total call 65, total time 1.994s, min time 628630ns, max time 647.649ms, avg time 30.682ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [1.554ms] for method 'Executed on table.', observe_longline.vesselactivity (total call 65, total time 7.796s, min time 1.163ms, max time 4.556s, avg time 119.932ms) WARN [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:237) log - [7.846s] for method 'Action executed', org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction (total call 1, total time 7.846s, min time 2.147s, max time 7.846s, avg time 7.846s) observe_common.shipowner , 27 Found: observe_common.country , 72 Found: observe_common.fpazone , 42 Found: observe_common.gear , 26 Found: observe_common.gear_gearcaracteristic , 29 Found: observe_common.gearcaracteristic , 22 Found: observe_common.gearcaracteristictype , 6 Found: observe_common.harbour , 74 Found: observe_common.lastupdatedate , 97 Found: observe_common.lengthlengthparameter , 0 Found: observe_common.lengthweightparameter , 365 Found: observe_common.ocean , 3 Found: observe_common.ocean_species , 500 Found: observe_common.organism , 9 Found: observe_common.person , 512 Found: observe_common.program , 27 Found: observe_common.sex , 5 Found: observe_common.shipOwner , 27 Found: observe_common.sizemeasuretype , 17 Found: observe_common.species , 285 Found: observe_common.species_specieslist , 401 Found: observe_common.speciesgroup , 11 Found: observe_common.specieslist , 6 Found: observe_common.vessel , 1172 Found: observe_common.vesselsizecategory , 13 Found: observe_common.vesseltype , 14 Found: observe_common.weightmeasuretype , 3 Found: observe_longline.baithaulingstatus , 5 Found: observe_longline.baitsettingstatus , 5 Found: observe_longline.baittype , 16 Found: observe_longline.catchfate , 5 Found: observe_longline.encountertype , 12 Found: observe_longline.healthness , 6 Found: observe_longline.hookposition , 13 Found: observe_longline.hooksize , 22 Found: observe_longline.hooktype , 13 Found: observe_longline.itemhorizontalposition , 3 Found: observe_longline.itemverticalposition , 3 Found: observe_longline.lightstickscolor , 7 Found: observe_longline.lightstickstype , 2 Found: observe_longline.linetype , 8 Found: observe_longline.maturitystatus , 12 Found: observe_longline.mitigationtype , 15 Found: observe_longline.sensorbrand , 4 Found: observe_longline.sensordataformat , 2 Found: observe_longline.sensortype , 4 Found: observe_longline.settingshape , 6 Found: observe_longline.stomacfullness , 7 Found: observe_longline.triptype , 3 Found: observe_longline.vesselactivity , 5 Found: observe_seine.detectionmode , 11 Found: observe_seine.objectfate , 9 Found: observe_seine.objectoperation , 4 Found: observe_seine.objecttype , 27 Found: observe_seine.observedsystem , 21 Found: observe_seine.reasonfordiscard , 5 Found: observe_seine.reasonfornofishing , 13 Found: observe_seine.reasonfornullset , 10 Found: observe_seine.speciesfate , 10 Found: observe_seine.speciesstatus , 4 Found: observe_seine.surroundingactivity , 8 Found: observe_seine.transmittingbuoyoperation , 3 Found: observe_seine.transmittingbuoytype , 12 Found: observe_seine.vesselactivity , 23 Found: observe_seine.weightcategory , 110 Found: observe_seine.wind , 13 INFO [main] (fr.ird.observe.services.topia.entity.ReplicateTestSupport:128) testReplicate0 - Replicate to script (length: 2.422Mo) : <http://ci.codelutin.com/jenkins/job/observe-ci/fr.ird.observe$services-topia/ws/target/surefire-workdir/tests/17978762829726405/ReplicateReferentialsTest/testReplicate/script.sql> Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 51.163 sec - in fr.ird.observe.services.topia.entity.ReplicateReferentialsTest Running fr.ird.observe.services.topia.entity.ReplicateTripSeineTest INFO [main] (fr.ird.observe.services.topia.ObserveTopiaApplicationContextFactory:195) createTopiaApplicationContext - H2 Topia configuration: jdbc:h2:<http://ci.codelutin.com/jenkins/job/observe-ci/fr.ird.observe$services-topia/ws/target/surefire-workdir/commons/6_0/dataForTestSeine/obstuna;FILE_LOCK=file;LOG=0;MODE=postgresql;DEFAULT_LOCK_TIMEOUT=100;DB_CLOSE_DELAY=0;LOCK_MODE=3;TRACE_LEVEL_FILE=0;TRACE_LEVEL_SYSTEM_OUT=0;CACHE_SIZE=65536;MVCC=true> INFO [main] (org.nuiton.topia.persistence.internal.support.TopiaServiceSupportImpl:99) initServices - instantiated service migration: fr.ird.observe.persistence.migration.ObserveMigrationEngine@200aa590 INFO [main] (org.nuiton.topia.persistence.internal.support.TopiaServiceSupportImpl:99) initServices - instantiated service sqlBatch: org.nuiton.topia.service.sql.batch.TopiaSqlBatchServiceImpl@33d4065f INFO [main] (org.nuiton.topia.persistence.internal.support.TopiaServiceSupportImpl:125) initServices - will init service migration with configuration {callback=fr.ird.observe.persistence.migration.H2DataSourceMigration, showProgression=true, showSql=true} INFO [main] (org.nuiton.topia.persistence.internal.support.TopiaServiceSupportImpl:125) initServices - will init service sqlBatch with configuration {} INFO [main] (org.nuiton.topia.persistence.internal.AbstractTopiaApplicationContext:148) init - Schema initialization disabled INFO [main] (org.nuiton.topia.persistence.internal.HibernateProvider:159) newHibernateConfiguration - will start hibernate with configuration {hibernate.c3p0.timeout=1800, hibernate.hikari.autoCommit=false, hibernate.hikari.minimumIdle=2, hibernate.use_sql_comments=true, hibernate.connection.driver_class=org.h2.Driver, hibernate.c3p0.max_statements=50, hibernate.c3p0.max_size=20, hibernate.dialect=org.hibernate.dialect.H2Dialect, hibernate.format_sql=true, hibernate.c3p0.min_size=5, hibernate.hikari.registerMbeans=true, hibernate.ejb.naming_strategy=org.hibernate.cfg.ImprovedNamingStrategy, hibernate.connection.username=sa, hibernate.connection.url=jdbc:h2:<http://ci.codelutin.com/jenkins/job/observe-ci/fr.ird.observe$services-topia/ws/target/surefire-workdir/commons/6_0/dataForTestSeine/obstuna;FILE_LOCK=file;LOG=0;MODE=postgresql;DEFAULT_LOCK_TIMEOUT=100;DB_CLOSE_DELAY=0;LOCK_MODE=3;TRACE_LEVEL_FILE=0;TRACE_LEVEL_SYSTEM_OUT=0;CACHE_SIZE=65536;MVCC=true,> hibernate.connection.provider_class=org.hibernate.hikaricp.internal.HikariCPConnectionProvider, hibernate.connection.password=sa, hibernate.hikari.maximumPoolSize=20} INFO [main] (fr.ird.observe.persistence.ObserveTopiaApplicationContext:252) getTripSeineTables - Loading tripSeineTables. DEBUG [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTablesFactory:115) visitEntiyStart - E → TripSeine INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTables:247) registerTable - new TopiaTable: TopiaSqlTable{fullyTableName=observe_seine.trip, associationTable=false} DEBUG [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTablesFactory:158) visitOneToManyAssociation - TripSeine/route→Route (withShell: true) INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTables:247) registerTable - new TopiaTable: TopiaSqlTable{fullyTableName=observe_seine.route, associationTable=false} DEBUG [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTablesFactory:158) visitOneToManyAssociation - Route/activitySeine→ActivitySeine (withShell: true) INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTables:247) registerTable - new TopiaTable: TopiaSqlTable{fullyTableName=observe_seine.activity, associationTable=false} DEBUG [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTablesFactory:140) visitReversedAssociation - ActivitySeine/setSeine→SetSeine (withShell: true) INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTables:247) registerTable - new TopiaTable: TopiaSqlTable{fullyTableName=observe_seine.set, associationTable=false} DEBUG [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTablesFactory:158) visitOneToManyAssociation - SetSeine/nonTargetCatch→NonTargetCatch (withShell: false) INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTables:247) registerTable - new TopiaTable: TopiaSqlTable{fullyTableName=observe_seine.nontargetcatch, associationTable=false} DEBUG [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTablesFactory:158) visitOneToManyAssociation - SetSeine/nonTargetSample→NonTargetSample (withShell: true) INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTables:247) registerTable - new TopiaTable: TopiaSqlTable{fullyTableName=observe_seine.nontargetsample, associationTable=false} DEBUG [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTablesFactory:158) visitOneToManyAssociation - NonTargetSample/nonTargetLength→NonTargetLength (withShell: false) INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTables:247) registerTable - new TopiaTable: TopiaSqlTable{fullyTableName=observe_seine.nontargetlength, associationTable=false} DEBUG [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTablesFactory:128) visitEntiyEnd - E ← NonTargetSample DEBUG [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTablesFactory:158) visitOneToManyAssociation - SetSeine/targetSample→TargetSample (withShell: true) INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTables:247) registerTable - new TopiaTable: TopiaSqlTable{fullyTableName=observe_seine.targetsample, associationTable=false} DEBUG [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTablesFactory:158) visitOneToManyAssociation - TargetSample/targetLength→TargetLength (withShell: false) INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTables:247) registerTable - new TopiaTable: TopiaSqlTable{fullyTableName=observe_seine.targetlength, associationTable=false} DEBUG [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTablesFactory:128) visitEntiyEnd - E ← TargetSample DEBUG [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTablesFactory:158) visitOneToManyAssociation - SetSeine/targetCatch→TargetCatch (withShell: false) INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTables:247) registerTable - new TopiaTable: TopiaSqlTable{fullyTableName=observe_seine.targetcatch, associationTable=false} DEBUG [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTablesFactory:158) visitOneToManyAssociation - SetSeine/schoolEstimate→SchoolEstimate (withShell: false) INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTables:247) registerTable - new TopiaTable: TopiaSqlTable{fullyTableName=observe_seine.schoolestimate, associationTable=false} DEBUG [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTablesFactory:128) visitEntiyEnd - E ← SetSeine DEBUG [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTablesFactory:158) visitOneToManyAssociation - ActivitySeine/floatingObject→FloatingObject (withShell: true) INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTables:247) registerTable - new TopiaTable: TopiaSqlTable{fullyTableName=observe_seine.floatingobject, associationTable=false} DEBUG [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTablesFactory:158) visitOneToManyAssociation - FloatingObject/objectSchoolEstimate→ObjectSchoolEstimate (withShell: false) INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTables:247) registerTable - new TopiaTable: TopiaSqlTable{fullyTableName=observe_seine.objectschoolestimate, associationTable=false} DEBUG [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTablesFactory:158) visitOneToManyAssociation - FloatingObject/objectObservedSpecies→ObjectObservedSpecies (withShell: false) INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTables:247) registerTable - new TopiaTable: TopiaSqlTable{fullyTableName=observe_seine.objectobservedspecies, associationTable=false} DEBUG [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTablesFactory:158) visitOneToManyAssociation - FloatingObject/transmittingBuoy→TransmittingBuoy (withShell: false) INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTables:247) registerTable - new TopiaTable: TopiaSqlTable{fullyTableName=observe_seine.transmittingbuoy, associationTable=false} DEBUG [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTablesFactory:128) visitEntiyEnd - E ← FloatingObject INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTablesFactory:180) visitManyToManyAssociation - ActivitySeine/observedSystem→ObservedSystem INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTables:247) registerTable - new TopiaTable: TopiaSqlTable{fullyTableName=observe_seine.activity_observedsystem, associationTable=true} DEBUG [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTablesFactory:128) visitEntiyEnd - E ← ActivitySeine DEBUG [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTablesFactory:128) visitEntiyEnd - E ← Route DEBUG [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTablesFactory:158) visitOneToManyAssociation - TripSeine/gearUseFeaturesSeine→GearUseFeaturesSeine (withShell: true) INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTables:247) registerTable - new TopiaTable: TopiaSqlTable{fullyTableName=observe_seine.gearusefeatures, associationTable=false} DEBUG [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTablesFactory:158) visitOneToManyAssociation - GearUseFeaturesSeine/gearUseFeaturesMeasurement→GearUseFeaturesMeasurementSeine (withShell: false) INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTables:247) registerTable - new TopiaTable: TopiaSqlTable{fullyTableName=observe_seine.gearusefeaturesmeasurement, associationTable=false} DEBUG [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTablesFactory:128) visitEntiyEnd - E ← GearUseFeaturesSeine DEBUG [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTablesFactory:128) visitEntiyEnd - E ← TripSeine INFO [main] (fr.ird.observe.services.topia.TopiaTestClassResource:132) createDataSourceConfiguration - Copy database: 6.0/referentiel to <http://ci.codelutin.com/jenkins/job/observe-ci/fr.ird.observe$services-topia/ws/target/surefire-workdir/tests/17978762829726405/ReplicateTripSeineTest/testReplicateTripSeine1/targetReplication/obstuna.h2.db> INFO [main] (fr.ird.observe.services.topia.ObserveTopiaApplicationContextFactory:195) createTopiaApplicationContext - H2 Topia configuration: jdbc:h2:<http://ci.codelutin.com/jenkins/job/observe-ci/fr.ird.observe$services-topia/ws/target/surefire-workdir/tests/17978762829726405/ReplicateTripSeineTest/testReplicateTripSeine1/targetReplication/obstuna;FILE_LOCK=file;LOG=0;MODE=postgresql;DEFAULT_LOCK_TIMEOUT=100;DB_CLOSE_DELAY=0;LOCK_MODE=3;TRACE_LEVEL_FILE=0;TRACE_LEVEL_SYSTEM_OUT=0;CACHE_SIZE=65536;MVCC=true> INFO [main] (org.nuiton.topia.persistence.internal.support.TopiaServiceSupportImpl:99) initServices - instantiated service migration: fr.ird.observe.persistence.migration.ObserveMigrationEngine@1567ee0a INFO [main] (org.nuiton.topia.persistence.internal.support.TopiaServiceSupportImpl:99) initServices - instantiated service sqlBatch: org.nuiton.topia.service.sql.batch.TopiaSqlBatchServiceImpl@20ad0885 INFO [main] (org.nuiton.topia.persistence.internal.support.TopiaServiceSupportImpl:125) initServices - will init service migration with configuration {callback=fr.ird.observe.persistence.migration.H2DataSourceMigration, showProgression=true, showSql=true} INFO [main] (org.nuiton.topia.persistence.internal.support.TopiaServiceSupportImpl:125) initServices - will init service sqlBatch with configuration {} INFO [main] (org.nuiton.topia.persistence.internal.AbstractTopiaApplicationContext:148) init - Schema initialization disabled INFO [main] (org.nuiton.topia.persistence.internal.HibernateProvider:159) newHibernateConfiguration - will start hibernate with configuration {hibernate.c3p0.timeout=1800, hibernate.hikari.autoCommit=false, hibernate.hikari.minimumIdle=2, hibernate.use_sql_comments=true, hibernate.connection.driver_class=org.h2.Driver, hibernate.c3p0.max_statements=50, hibernate.c3p0.max_size=20, hibernate.dialect=org.hibernate.dialect.H2Dialect, hibernate.format_sql=true, hibernate.c3p0.min_size=5, hibernate.hikari.registerMbeans=true, hibernate.ejb.naming_strategy=org.hibernate.cfg.ImprovedNamingStrategy, hibernate.connection.username=sa, hibernate.connection.url=jdbc:h2:<http://ci.codelutin.com/jenkins/job/observe-ci/fr.ird.observe$services-topia/ws/target/surefire-workdir/tests/17978762829726405/ReplicateTripSeineTest/testReplicateTripSeine1/targetReplication/obstuna;FILE_LOCK=file;LOG=0;MODE=postgresql;DEFAULT_LOCK_TIMEOUT=100;DB_CLOSE_DELAY=0;LOCK_MODE=3;TRACE_LEVEL_FILE=0;TRACE_LEVEL_SYSTEM_OUT=0;CACHE_SIZE=65536;MVCC=true,> hibernate.connection.provider_class=org.hibernate.hikaricp.internal.HikariCPConnectionProvider, hibernate.connection.password=sa, hibernate.hikari.maximumPoolSize=20} INFO [main] (fr.ird.observe.services.topia.entity.ReplicateTestSupport:118) testReplicate0 - TopiaSqlTables{orderedTables=[TopiaSqlTable{fullyTableName=observe_seine.trip, associationTable=false}, TopiaSqlTable{fullyTableName=observe_seine.route, associationTable=false}, TopiaSqlTable{fullyTableName=observe_seine.set, associationTable=false}, TopiaSqlTable{fullyTableName=observe_seine.activity, associationTable=false}, TopiaSqlTable{fullyTableName=observe_seine.nontargetcatch, associationTable=false}, TopiaSqlTable{fullyTableName=observe_seine.nontargetsample, associationTable=false}, TopiaSqlTable{fullyTableName=observe_seine.nontargetlength, associationTable=false}, TopiaSqlTable{fullyTableName=observe_seine.targetsample, associationTable=false}, TopiaSqlTable{fullyTableName=observe_seine.targetlength, associationTable=false}, TopiaSqlTable{fullyTableName=observe_seine.targetcatch, associationTable=false}, TopiaSqlTable{fullyTableName=observe_seine.schoolestimate, associationTable=false}, TopiaSqlTable{fullyTableName=observe_seine.floatingobject, associationTable=false}, TopiaSqlTable{fullyTableName=observe_seine.objectschoolestimate, associationTable=false}, TopiaSqlTable{fullyTableName=observe_seine.objectobservedspecies, associationTable=false}, TopiaSqlTable{fullyTableName=observe_seine.transmittingbuoy, associationTable=false}, TopiaSqlTable{fullyTableName=observe_seine.activity_observedsystem, associationTable=true}, TopiaSqlTable{fullyTableName=observe_seine.gearusefeatures, associationTable=false}, TopiaSqlTable{fullyTableName=observe_seine.gearusefeaturesmeasurement, associationTable=false}]} DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:208) createReadStatement - Read sql: SELECT trip.* FROM observe_seine.trip trip WHERE trip.topiaid = ? DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [121771ns] for method 'Read statement', SELECT trip.* FROM observe_seine.trip trip WHERE trip.topiaid = ? -> [fr.ird.observe.entities.seine.TripSeine#1359167789871#0.6765335978809843] (total call 66, total time 152.884ms, min time 25761ns, max time 55.333ms, avg time 2.316ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction:183) newInsertStatementSql - Insert sql: INSERT INTO observe_seine.trip(topiaid, topiaversion, topiacreatedate, lastupdatedate, comment, startdate, enddate, checklevel, formsurl, reportsurl, historicaldata, ersid, ocean, vessel, program, observer, captain, dataentryoperator, departureharbour, landingharbour) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_seine.trip (size: 1) Results : Tests run: 5, Failures: 0, Errors: 0, Skipped: 1 [JENKINS] Recording test results [JENKINS] Archiving disabled