http://ci.codelutin.com/jenkins/job/observe-nightly/fr.ird.observe$services-...: [Tony CHEMIT] Il existe encore des validations qui ne passent pas (Fixes #8898) ------------------------------------------ [...truncated 909 lines...] DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction:183) newInsertStatementSql - Insert sql: INSERT INTO observe_seine.nontargetlength(topiaid, topiaversion, topiacreatedate, lastupdatedate, length, lengthsource, picturesreferences, weight, weightsource, count, acquisitionmode, species, sex, nontargetsample) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:99) flush - Flush for : observe_seine.nontargetlength (size: 767) INFO [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:239) log - [60.733ms] for method 'Executed on table.', observe_seine.nontargetlength (total call 70, total time 2.001s, min time 675355ns, max time 1.116s, avg time 28.584ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:186) createReadStatement - Read sql: SELECT targetsample.* FROM observe_seine.route route INNER JOIN observe_seine.activity activity ON activity.route = route.topiaId INNER JOIN observe_seine.set set ON set.topiaId = activity.set INNER JOIN observe_seine.targetsample targetsample ON targetsample.set = set.topiaId WHERE route.trip = ? DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction:183) newInsertStatementSql - Insert sql: INSERT INTO observe_seine.targetsample(topiaid, topiaversion, topiacreatedate, lastupdatedate, comment, nature, discarded, set) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:99) flush - Flush for : observe_seine.targetsample (size: 10) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [3.307ms] for method 'Executed on table.', observe_seine.targetsample (total call 71, total time 2.004s, min time 675355ns, max time 1.116s, avg time 28.228ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:186) createReadStatement - Read sql: SELECT targetlength.* FROM observe_seine.route route INNER JOIN observe_seine.activity activity ON activity.route = route.topiaId INNER JOIN observe_seine.set set ON set.topiaId = activity.set INNER JOIN observe_seine.targetsample targetsample ON targetsample.set = set.topiaId INNER JOIN observe_seine.targetlength targetlength ON targetlength.targetsample = targetsample.topiaId WHERE route.trip = ? DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction:183) newInsertStatementSql - Insert sql: INSERT INTO observe_seine.targetlength(topiaid, topiaversion, topiacreatedate, lastupdatedate, measuretype, length, lengthsource, count, weight, weightsource, acquisitionmode, targetsample, species) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:99) flush - Flush for : observe_seine.targetlength (size: 85) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [9.206ms] for method 'Executed on table.', observe_seine.targetlength (total call 72, total time 2.013s, min time 675355ns, max time 1.116s, avg time 27.963ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:186) createReadStatement - Read sql: SELECT targetcatch.* FROM observe_seine.route route INNER JOIN observe_seine.activity activity ON activity.route = route.topiaId INNER JOIN observe_seine.set set ON set.topiaId = activity.set INNER JOIN observe_seine.targetcatch targetcatch ON targetcatch.set = set.topiaId WHERE route.trip = ? DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction:183) newInsertStatementSql - Insert sql: INSERT INTO observe_seine.targetcatch(topiaid, topiaversion, topiacreatedate, lastupdatedate, comment, catchweight, well, broughtondeck, discarded, set, weightcategory, reasonfordiscard) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:99) flush - Flush for : observe_seine.targetcatch (size: 73) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [8.306ms] for method 'Executed on table.', observe_seine.targetcatch (total call 73, total time 2.022s, min time 675355ns, max time 1.116s, avg time 27.694ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:186) createReadStatement - Read sql: SELECT schoolestimate.* FROM observe_seine.route route INNER JOIN observe_seine.activity activity ON activity.route = route.topiaId INNER JOIN observe_seine.set set ON set.topiaId = activity.set INNER JOIN observe_seine.schoolestimate schoolestimate ON schoolestimate.set = set.topiaId WHERE route.trip = ? DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction:183) newInsertStatementSql - Insert sql: INSERT INTO observe_seine.schoolestimate(topiaid, topiaversion, topiacreatedate, lastupdatedate, totalweight, meanweight, set, species) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:99) flush - Flush for : observe_seine.schoolestimate (size: 27) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [4.558ms] for method 'Executed on table.', observe_seine.schoolestimate (total call 74, total time 2.026s, min time 675355ns, max time 1.116s, avg time 27.381ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:186) createReadStatement - Read sql: SELECT floatingobject.* FROM observe_seine.route route INNER JOIN observe_seine.activity activity ON activity.route = route.topiaId INNER JOIN observe_seine.floatingobject floatingobject ON floatingobject.activity = activity.topiaId WHERE route.trip = ? DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction:183) newInsertStatementSql - Insert sql: INSERT INTO observe_seine.floatingobject(topiaid, topiaversion, topiacreatedate, lastupdatedate, comment, daysatseacount, supportvesselname, objecttype, objectoperation, objectfate, activity) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:99) flush - Flush for : observe_seine.floatingobject (size: 54) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [7.231ms] for method 'Executed on table.', observe_seine.floatingobject (total call 75, total time 2.033s, min time 675355ns, max time 1.116s, avg time 27.113ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:186) createReadStatement - Read sql: SELECT objectschoolestimate.* FROM observe_seine.route route INNER JOIN observe_seine.activity activity ON activity.route = route.topiaId INNER JOIN observe_seine.floatingobject floatingobject ON floatingobject.activity = activity.topiaId INNER JOIN observe_seine.objectschoolestimate objectschoolestimate ON objectschoolestimate.floatingobject = floatingobject.topiaId WHERE route.trip = ? DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction:183) newInsertStatementSql - Insert sql: INSERT INTO observe_seine.objectschoolestimate(topiaid, topiaversion, topiacreatedate, lastupdatedate, totalweight, species, floatingobject) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:99) flush - Flush for : observe_seine.objectschoolestimate (size: 1) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [3.03ms] for method 'Executed on table.', observe_seine.objectschoolestimate (total call 76, total time 2.036s, min time 675355ns, max time 1.116s, avg time 26.796ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:186) createReadStatement - Read sql: SELECT objectobservedspecies.* FROM observe_seine.route route INNER JOIN observe_seine.activity activity ON activity.route = route.topiaId INNER JOIN observe_seine.floatingobject floatingobject ON floatingobject.activity = activity.topiaId INNER JOIN observe_seine.objectobservedspecies objectobservedspecies ON objectobservedspecies.floatingobject = floatingobject.topiaId WHERE route.trip = ? DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction:183) newInsertStatementSql - Insert sql: INSERT INTO observe_seine.objectobservedspecies(topiaid, topiaversion, topiacreatedate, lastupdatedate, count, statut, species, speciesstatus, floatingobject) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:99) flush - Flush for : observe_seine.objectobservedspecies (size: 3) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [2.984ms] for method 'Executed on table.', observe_seine.objectobservedspecies (total call 77, total time 2.039s, min time 675355ns, max time 1.116s, avg time 26.487ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:186) createReadStatement - Read sql: SELECT transmittingbuoy.* FROM observe_seine.route route INNER JOIN observe_seine.activity activity ON activity.route = route.topiaId INNER JOIN observe_seine.floatingobject floatingobject ON floatingobject.activity = activity.topiaId INNER JOIN observe_seine.transmittingbuoy transmittingbuoy ON transmittingbuoy.floatingobject = floatingobject.topiaId WHERE route.trip = ? DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction:183) newInsertStatementSql - Insert sql: INSERT INTO observe_seine.transmittingbuoy(topiaid, topiaversion, topiacreatedate, lastupdatedate, code, brand, ownership, transmittingbuoytype, transmittingbuoyoperation, country, floatingobject) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:99) flush - Flush for : observe_seine.transmittingbuoy (size: 62) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [8.033ms] for method 'Executed on table.', observe_seine.transmittingbuoy (total call 78, total time 2.048s, min time 675355ns, max time 1.116s, avg time 26.25ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:186) createReadStatement - Read sql: SELECT activity_observedsystem.* FROM observe_seine.route route INNER JOIN observe_seine.activity activity ON activity.route = route.topiaId INNER JOIN observe_seine.activity_observedsystem activity_observedsystem ON activity_observedsystem.activity = activity.topiaId WHERE route.trip = ? DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction:183) newInsertStatementSql - Insert sql: INSERT INTO observe_seine.activity_observedsystem(activity, observedsystem) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:99) flush - Flush for : observe_seine.activity_observedsystem (size: 1000) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:99) flush - Flush for : observe_seine.activity_observedsystem (size: 1182) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [34.803ms] for method 'Executed on table.', observe_seine.activity_observedsystem (total call 79, total time 2.082s, min time 675355ns, max time 1.116s, avg time 26.358ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:186) createReadStatement - Read sql: SELECT gearusefeatures.* FROM observe_seine.gearusefeatures gearusefeatures WHERE gearusefeatures.trip = ? DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction:183) newInsertStatementSql - Insert sql: INSERT INTO observe_seine.gearusefeatures(topiaid, topiaversion, topiacreatedate, lastupdatedate, comment, number, usedintrip, gear, trip) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:99) flush - Flush for : observe_seine.gearusefeatures (size: 2) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [1.021ms] for method 'Executed on table.', observe_seine.gearusefeatures (total call 80, total time 2.083s, min time 675355ns, max time 1.116s, avg time 26.042ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:186) createReadStatement - Read sql: SELECT gearusefeaturesmeasurement.* FROM observe_seine.gearusefeatures gearusefeatures INNER JOIN observe_seine.gearusefeaturesmeasurement gearusefeaturesmeasurement ON gearusefeaturesmeasurement.gearusefeatures = gearusefeatures.topiaId WHERE gearusefeatures.trip = ? DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction:183) newInsertStatementSql - Insert sql: INSERT INTO observe_seine.gearusefeaturesmeasurement(topiaid, topiaversion, topiacreatedate, lastupdatedate, measurementvalue, gearcaracteristic, gearusefeatures) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:99) flush - Flush for : observe_seine.gearusefeaturesmeasurement (size: 4) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [912226ns] for method 'Executed on table.', observe_seine.gearusefeaturesmeasurement (total call 81, total time 2.084s, min time 675355ns, max time 1.116s, avg time 25.731ms) WARN [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:237) log - [625.526ms] for method 'Action executed', org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction (total call 2, total time 2.108s, min time 625.526ms, max time 1.483s, avg time 1.054s) Found: observe_seine.trip , 1 Found: observe_seine.gearusefeatures , 2 Found: observe_seine.gearusefeaturesmeasurement , 4 Found: observe_seine.route , 34 Found: observe_seine.set , 35 Found: observe_seine.activity , 862 Found: observe_seine.floatingobject , 54 Found: observe_seine.schoolestimate , 27 Found: observe_seine.nontargetcatch , 109 Found: observe_seine.nontargetsample , 20 Found: observe_seine.nontargetlength , 767 Found: observe_seine.targetcatch , 73 Found: observe_seine.targetsample , 10 Found: observe_seine.targetlength , 85 Found: observe_seine.objectobservedspecies , 3 Found: observe_seine.objectschoolestimate , 1 Found: observe_seine.transmittingbuoy , 62 Found: observe_seine.activity_observedsystem , 1182 INFO [main] (fr.ird.observe.services.topia.entity.ReplicateTestSupport:128) testReplicate0 - Replicate to script (length: 1.868Mo) : <http://ci.codelutin.com/jenkins/job/observe-nightly/fr.ird.observe$services-topia/ws/target/surefire-workdir/tests/12329575390307807/ReplicateTripSeineTest/testReplicateTripSeine1/script.sql> INFO [main] (fr.ird.observe.services.topia.ObserveTopiaApplicationContextFactory:168) createTopiaApplicationContext - H2 Topia configuration: jdbc:h2:<http://ci.codelutin.com/jenkins/job/observe-nightly/fr.ird.observe$services-topia/ws/target/surefire-workdir/commons/5_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] (fr.ird.observe.ObserveTopiaApplicationContext:244) getTripSeineTables - Loading tripSeineTables. INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTablesFactory:117) visitEntiyStart - E → TripSeine INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTables:226) registerTable - new TopiaTable: TopiaSqlTable{fullyTableName=observe_seine.trip, associationTable=false} INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTablesFactory:160) visitOneToManyAssociation - TripSeine/route→Route (withShell: true) INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTables:226) registerTable - new TopiaTable: TopiaSqlTable{fullyTableName=observe_seine.route, associationTable=false} INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTablesFactory:160) visitOneToManyAssociation - Route/activitySeine→ActivitySeine (withShell: true) INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTables:226) registerTable - new TopiaTable: TopiaSqlTable{fullyTableName=observe_seine.activity, associationTable=false} INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTablesFactory:142) visitReversedAssociation - ActivitySeine/setSeine→SetSeine (withShell: true) INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTables:226) registerTable - new TopiaTable: TopiaSqlTable{fullyTableName=observe_seine.set, associationTable=false} INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTablesFactory:160) visitOneToManyAssociation - SetSeine/nonTargetCatch→NonTargetCatch (withShell: false) INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTables:226) registerTable - new TopiaTable: TopiaSqlTable{fullyTableName=observe_seine.nontargetcatch, associationTable=false} INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTablesFactory:160) visitOneToManyAssociation - SetSeine/nonTargetSample→NonTargetSample (withShell: true) INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTables:226) registerTable - new TopiaTable: TopiaSqlTable{fullyTableName=observe_seine.nontargetsample, associationTable=false} INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTablesFactory:160) visitOneToManyAssociation - NonTargetSample/nonTargetLength→NonTargetLength (withShell: false) INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTables:226) registerTable - new TopiaTable: TopiaSqlTable{fullyTableName=observe_seine.nontargetlength, associationTable=false} INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTablesFactory:130) visitEntiyEnd - E ← NonTargetSample INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTablesFactory:160) visitOneToManyAssociation - SetSeine/targetSample→TargetSample (withShell: true) INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTables:226) registerTable - new TopiaTable: TopiaSqlTable{fullyTableName=observe_seine.targetsample, associationTable=false} INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTablesFactory:160) visitOneToManyAssociation - TargetSample/targetLength→TargetLength (withShell: false) INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTables:226) registerTable - new TopiaTable: TopiaSqlTable{fullyTableName=observe_seine.targetlength, associationTable=false} INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTablesFactory:130) visitEntiyEnd - E ← TargetSample INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTablesFactory:160) visitOneToManyAssociation - SetSeine/targetCatch→TargetCatch (withShell: false) INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTables:226) registerTable - new TopiaTable: TopiaSqlTable{fullyTableName=observe_seine.targetcatch, associationTable=false} INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTablesFactory:160) visitOneToManyAssociation - SetSeine/schoolEstimate→SchoolEstimate (withShell: false) INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTables:226) registerTable - new TopiaTable: TopiaSqlTable{fullyTableName=observe_seine.schoolestimate, associationTable=false} INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTablesFactory:130) visitEntiyEnd - E ← SetSeine INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTablesFactory:160) visitOneToManyAssociation - ActivitySeine/floatingObject→FloatingObject (withShell: true) INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTables:226) registerTable - new TopiaTable: TopiaSqlTable{fullyTableName=observe_seine.floatingobject, associationTable=false} INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTablesFactory:160) visitOneToManyAssociation - FloatingObject/objectSchoolEstimate→ObjectSchoolEstimate (withShell: false) INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTables:226) registerTable - new TopiaTable: TopiaSqlTable{fullyTableName=observe_seine.objectschoolestimate, associationTable=false} INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTablesFactory:160) visitOneToManyAssociation - FloatingObject/objectObservedSpecies→ObjectObservedSpecies (withShell: false) INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTables:226) registerTable - new TopiaTable: TopiaSqlTable{fullyTableName=observe_seine.objectobservedspecies, associationTable=false} INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTablesFactory:160) visitOneToManyAssociation - FloatingObject/transmittingBuoy→TransmittingBuoy (withShell: false) INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTables:226) registerTable - new TopiaTable: TopiaSqlTable{fullyTableName=observe_seine.transmittingbuoy, associationTable=false} INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTablesFactory:130) visitEntiyEnd - E ← FloatingObject INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTablesFactory:182) visitManyToManyAssociation - ActivitySeine/observedSystem→ObservedSystem INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTables:226) registerTable - new TopiaTable: TopiaSqlTable{fullyTableName=observe_seine.activity_observedsystem, associationTable=true} INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTablesFactory:130) visitEntiyEnd - E ← ActivitySeine INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTablesFactory:130) visitEntiyEnd - E ← Route INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTablesFactory:160) visitOneToManyAssociation - TripSeine/gearUseFeaturesSeine→GearUseFeaturesSeine (withShell: true) INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTables:226) registerTable - new TopiaTable: TopiaSqlTable{fullyTableName=observe_seine.gearusefeatures, associationTable=false} INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTablesFactory:160) visitOneToManyAssociation - GearUseFeaturesSeine/gearUseFeaturesMeasurement→GearUseFeaturesMeasurementSeine (withShell: false) INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTables:226) registerTable - new TopiaTable: TopiaSqlTable{fullyTableName=observe_seine.gearusefeaturesmeasurement, associationTable=false} INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTablesFactory:130) visitEntiyEnd - E ← GearUseFeaturesSeine INFO [main] (org.nuiton.topia.service.sql.batch.tables.TopiaSqlTablesFactory:130) visitEntiyEnd - E ← TripSeine INFO [main] (fr.ird.observe.services.topia.TopiaTestClassResource:132) createDataSourceConfiguration - Copy database: 5.0/referentiel to <http://ci.codelutin.com/jenkins/job/observe-nightly/fr.ird.observe$services-topia/ws/target/surefire-workdir/tests/12329575390307807/ReplicateTripSeineTest/testReplicateTripSeine2/targetReplication/obstuna.h2.db> INFO [main] (fr.ird.observe.services.topia.ObserveTopiaApplicationContextFactory:168) createTopiaApplicationContext - H2 Topia configuration: jdbc:h2:<http://ci.codelutin.com/jenkins/job/observe-nightly/fr.ird.observe$services-topia/ws/target/surefire-workdir/tests/12329575390307807/ReplicateTripSeineTest/testReplicateTripSeine2/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] (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:186) createReadStatement - Read sql: SELECT trip.* FROM observe_seine.trip trip WHERE trip.topiaid = ? 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:99) flush - Flush for : observe_seine.trip (size: 1) WARN [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:237) log - [319.931ms] for method 'Executed on table.', observe_seine.trip (total call 82, total time 2.404s, min time 675355ns, max time 1.116s, avg time 29.319ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:186) createReadStatement - Read sql: SELECT route.* FROM observe_seine.route route WHERE route.trip = ? DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction:183) newInsertStatementSql - Insert sql: INSERT INTO observe_seine.route(topiaid, topiaversion, topiacreatedate, lastupdatedate, comment, date, startlogvalue, endlogvalue, checklevel, trip) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:99) flush - Flush for : observe_seine.route (size: 46) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [3.779ms] for method 'Executed on table.', observe_seine.route (total call 83, total time 2.408s, min time 675355ns, max time 1.116s, avg time 29.011ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:186) createReadStatement - Read sql: SELECT set.* FROM observe_seine.route route INNER JOIN observe_seine.activity activity ON activity.route = route.topiaId INNER JOIN observe_seine.set set ON set.topiaId = activity.set WHERE route.trip = ? DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction:183) newInsertStatementSql - Insert sql: INSERT INTO observe_seine.set(topiaid, topiaversion, topiacreatedate, lastupdatedate, comment, starttime, endpursingtimestamp, endsettimestamp, maxgeardepth, currentspeed, currentdirection, schooltopdepth, schoolmeandepth, schoolthickness, sonarused, supportvesselname, targetdiscarded, nontargetdiscarded, currentmeasuredepth, schooltype, reasonfornullset) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:99) flush - Flush for : observe_seine.set (size: 42) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [10.704ms] for method 'Executed on table.', observe_seine.set (total call 84, total time 2.419s, min time 675355ns, max time 1.116s, avg time 28.794ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:186) createReadStatement - Read sql: SELECT activity.* FROM observe_seine.route route INNER JOIN observe_seine.activity activity ON activity.route = route.topiaId WHERE route.trip = ? DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction:183) newInsertStatementSql - Insert sql: INSERT INTO observe_seine.activity(topiaid, topiaversion, topiacreatedate, lastupdatedate, comment, time, latitude, longitude, vesselspeed, seasurfacetemperature, observedsystemdistance, ersid, vesselactivity, surroundingactivity, wind, detectionmode, reasonfornofishing, set, currentfpazone, previousfpazone, nextfpazone, route) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:99) flush - Flush for : observe_seine.activity (size: 657) INFO [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:239) log - [66.243ms] for method 'Executed on table.', observe_seine.activity (total call 85, total time 2.485s, min time 675355ns, max time 1.116s, avg time 29.234ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:186) createReadStatement - Read sql: SELECT nontargetcatch.* FROM observe_seine.route route INNER JOIN observe_seine.activity activity ON activity.route = route.topiaId INNER JOIN observe_seine.set set ON set.topiaId = activity.set INNER JOIN observe_seine.nontargetcatch nontargetcatch ON nontargetcatch.set = set.topiaId WHERE route.trip = ? DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction:183) newInsertStatementSql - Insert sql: INSERT INTO observe_seine.nontargetcatch(topiaid, topiaversion, topiacreatedate, lastupdatedate, comment, catchweight, catchweightcomputedsource, meanweight, meanweightcomputedsource, meanlength, meanlengthcomputedsource, totalcount, totalcountcomputedsource, reasonfordiscard, species, speciesfate, set) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:99) flush - Flush for : observe_seine.nontargetcatch (size: 112) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [11.566ms] for method 'Executed on table.', observe_seine.nontargetcatch (total call 86, total time 2.496s, min time 675355ns, max time 1.116s, avg time 29.029ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:186) createReadStatement - Read sql: SELECT nontargetsample.* FROM observe_seine.route route INNER JOIN observe_seine.activity activity ON activity.route = route.topiaId INNER JOIN observe_seine.set set ON set.topiaId = activity.set INNER JOIN observe_seine.nontargetsample nontargetsample ON nontargetsample.set = set.topiaId WHERE route.trip = ? DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction:183) newInsertStatementSql - Insert sql: INSERT INTO observe_seine.nontargetsample(topiaid, topiaversion, topiacreatedate, lastupdatedate, comment, set) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:99) flush - Flush for : observe_seine.nontargetsample (size: 19) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [3.259ms] for method 'Executed on table.', observe_seine.nontargetsample (total call 87, total time 2.5s, min time 675355ns, max time 1.116s, avg time 28.732ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:186) createReadStatement - Read sql: SELECT nontargetlength.* FROM observe_seine.route route INNER JOIN observe_seine.activity activity ON activity.route = route.topiaId INNER JOIN observe_seine.set set ON set.topiaId = activity.set INNER JOIN observe_seine.nontargetsample nontargetsample ON nontargetsample.set = set.topiaId INNER JOIN observe_seine.nontargetlength nontargetlength ON nontargetlength.nontargetsample = nontargetsample.topiaId WHERE route.trip = ? DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction:183) newInsertStatementSql - Insert sql: INSERT INTO observe_seine.nontargetlength(topiaid, topiaversion, topiacreatedate, lastupdatedate, length, lengthsource, picturesreferences, weight, weightsource, count, acquisitionmode, species, sex, nontargetsample) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:99) flush - Flush for : observe_seine.nontargetlength (size: 242) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [18.908ms] for method 'Executed on table.', observe_seine.nontargetlength (total call 88, total time 2.519s, min time 675355ns, max time 1.116s, avg time 28.621ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:186) createReadStatement - Read sql: SELECT targetsample.* FROM observe_seine.route route INNER JOIN observe_seine.activity activity ON activity.route = route.topiaId INNER JOIN observe_seine.set set ON set.topiaId = activity.set INNER JOIN observe_seine.targetsample targetsample ON targetsample.set = set.topiaId WHERE route.trip = ? DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction:183) newInsertStatementSql - Insert sql: INSERT INTO observe_seine.targetsample(topiaid, topiaversion, topiacreatedate, lastupdatedate, comment, nature, discarded, set) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:99) flush - Flush for : observe_seine.targetsample (size: 0) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [2.417ms] for method 'Executed on table.', observe_seine.targetsample (total call 89, total time 2.521s, min time 675355ns, max time 1.116s, avg time 28.326ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:186) createReadStatement - Read sql: SELECT targetlength.* FROM observe_seine.route route INNER JOIN observe_seine.activity activity ON activity.route = route.topiaId INNER JOIN observe_seine.set set ON set.topiaId = activity.set INNER JOIN observe_seine.targetsample targetsample ON targetsample.set = set.topiaId INNER JOIN observe_seine.targetlength targetlength ON targetlength.targetsample = targetsample.topiaId WHERE route.trip = ? DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction:183) newInsertStatementSql - Insert sql: INSERT INTO observe_seine.targetlength(topiaid, topiaversion, topiacreatedate, lastupdatedate, measuretype, length, lengthsource, count, weight, weightsource, acquisitionmode, targetsample, species) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:99) flush - Flush for : observe_seine.targetlength (size: 0) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [2.853ms] for method 'Executed on table.', observe_seine.targetlength (total call 90, total time 2.524s, min time 675355ns, max time 1.116s, avg time 28.043ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:186) createReadStatement - Read sql: SELECT targetcatch.* FROM observe_seine.route route INNER JOIN observe_seine.activity activity ON activity.route = route.topiaId INNER JOIN observe_seine.set set ON set.topiaId = activity.set INNER JOIN observe_seine.targetcatch targetcatch ON targetcatch.set = set.topiaId WHERE route.trip = ? DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction:183) newInsertStatementSql - Insert sql: INSERT INTO observe_seine.targetcatch(topiaid, topiaversion, topiacreatedate, lastupdatedate, comment, catchweight, well, broughtondeck, discarded, set, weightcategory, reasonfordiscard) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:99) flush - Flush for : observe_seine.targetcatch (size: 73) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [8.815ms] for method 'Executed on table.', observe_seine.targetcatch (total call 91, total time 2.533s, min time 675355ns, max time 1.116s, avg time 27.832ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:186) createReadStatement - Read sql: SELECT schoolestimate.* FROM observe_seine.route route INNER JOIN observe_seine.activity activity ON activity.route = route.topiaId INNER JOIN observe_seine.set set ON set.topiaId = activity.set INNER JOIN observe_seine.schoolestimate schoolestimate ON schoolestimate.set = set.topiaId WHERE route.trip = ? DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction:183) newInsertStatementSql - Insert sql: INSERT INTO observe_seine.schoolestimate(topiaid, topiaversion, topiacreatedate, lastupdatedate, totalweight, meanweight, set, species) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:99) flush - Flush for : observe_seine.schoolestimate (size: 10) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [2.948ms] for method 'Executed on table.', observe_seine.schoolestimate (total call 92, total time 2.536s, min time 675355ns, max time 1.116s, avg time 27.562ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:186) createReadStatement - Read sql: SELECT floatingobject.* FROM observe_seine.route route INNER JOIN observe_seine.activity activity ON activity.route = route.topiaId INNER JOIN observe_seine.floatingobject floatingobject ON floatingobject.activity = activity.topiaId WHERE route.trip = ? DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction:183) newInsertStatementSql - Insert sql: INSERT INTO observe_seine.floatingobject(topiaid, topiaversion, topiacreatedate, lastupdatedate, comment, daysatseacount, supportvesselname, objecttype, objectoperation, objectfate, activity) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:99) flush - Flush for : observe_seine.floatingobject (size: 50) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [5.907ms] for method 'Executed on table.', observe_seine.floatingobject (total call 93, total time 2.542s, min time 675355ns, max time 1.116s, avg time 27.329ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:186) createReadStatement - Read sql: SELECT objectschoolestimate.* FROM observe_seine.route route INNER JOIN observe_seine.activity activity ON activity.route = route.topiaId INNER JOIN observe_seine.floatingobject floatingobject ON floatingobject.activity = activity.topiaId INNER JOIN observe_seine.objectschoolestimate objectschoolestimate ON objectschoolestimate.floatingobject = floatingobject.topiaId WHERE route.trip = ? DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction:183) newInsertStatementSql - Insert sql: INSERT INTO observe_seine.objectschoolestimate(topiaid, topiaversion, topiacreatedate, lastupdatedate, totalweight, species, floatingobject) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:99) flush - Flush for : observe_seine.objectschoolestimate (size: 3) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [2.532ms] for method 'Executed on table.', observe_seine.objectschoolestimate (total call 94, total time 2.544s, min time 675355ns, max time 1.116s, avg time 27.065ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:186) createReadStatement - Read sql: SELECT objectobservedspecies.* FROM observe_seine.route route INNER JOIN observe_seine.activity activity ON activity.route = route.topiaId INNER JOIN observe_seine.floatingobject floatingobject ON floatingobject.activity = activity.topiaId INNER JOIN observe_seine.objectobservedspecies objectobservedspecies ON objectobservedspecies.floatingobject = floatingobject.topiaId WHERE route.trip = ? DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction:183) newInsertStatementSql - Insert sql: INSERT INTO observe_seine.objectobservedspecies(topiaid, topiaversion, topiacreatedate, lastupdatedate, count, statut, species, speciesstatus, floatingobject) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:99) flush - Flush for : observe_seine.objectobservedspecies (size: 2) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [2.391ms] for method 'Executed on table.', observe_seine.objectobservedspecies (total call 95, total time 2.546s, min time 675355ns, max time 1.116s, avg time 26.805ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:186) createReadStatement - Read sql: SELECT transmittingbuoy.* FROM observe_seine.route route INNER JOIN observe_seine.activity activity ON activity.route = route.topiaId INNER JOIN observe_seine.floatingobject floatingobject ON floatingobject.activity = activity.topiaId INNER JOIN observe_seine.transmittingbuoy transmittingbuoy ON transmittingbuoy.floatingobject = floatingobject.topiaId WHERE route.trip = ? DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction:183) newInsertStatementSql - Insert sql: INSERT INTO observe_seine.transmittingbuoy(topiaid, topiaversion, topiacreatedate, lastupdatedate, code, brand, ownership, transmittingbuoytype, transmittingbuoyoperation, country, floatingobject) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:99) flush - Flush for : observe_seine.transmittingbuoy (size: 68) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [7.177ms] for method 'Executed on table.', observe_seine.transmittingbuoy (total call 96, total time 2.554s, min time 675355ns, max time 1.116s, avg time 26.601ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:186) createReadStatement - Read sql: SELECT activity_observedsystem.* FROM observe_seine.route route INNER JOIN observe_seine.activity activity ON activity.route = route.topiaId INNER JOIN observe_seine.activity_observedsystem activity_observedsystem ON activity_observedsystem.activity = activity.topiaId WHERE route.trip = ? DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction:183) newInsertStatementSql - Insert sql: INSERT INTO observe_seine.activity_observedsystem(activity, observedsystem) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:99) flush - Flush for : observe_seine.activity_observedsystem (size: 652) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [18.775ms] for method 'Executed on table.', observe_seine.activity_observedsystem (total call 97, total time 2.572s, min time 675355ns, max time 1.116s, avg time 26.52ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:186) createReadStatement - Read sql: SELECT gearusefeatures.* FROM observe_seine.gearusefeatures gearusefeatures WHERE gearusefeatures.trip = ? DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction:183) newInsertStatementSql - Insert sql: INSERT INTO observe_seine.gearusefeatures(topiaid, topiaversion, topiacreatedate, lastupdatedate, comment, number, usedintrip, gear, trip) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:99) flush - Flush for : observe_seine.gearusefeatures (size: 0) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [628564ns] for method 'Executed on table.', observe_seine.gearusefeatures (total call 98, total time 2.573s, min time 628564ns, max time 1.116s, avg time 26.256ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:186) createReadStatement - Read sql: SELECT gearusefeaturesmeasurement.* FROM observe_seine.gearusefeatures gearusefeatures INNER JOIN observe_seine.gearusefeaturesmeasurement gearusefeaturesmeasurement ON gearusefeaturesmeasurement.gearusefeatures = gearusefeatures.topiaId WHERE gearusefeatures.trip = ? DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction:183) newInsertStatementSql - Insert sql: INSERT INTO observe_seine.gearusefeaturesmeasurement(topiaid, topiaversion, topiacreatedate, lastupdatedate, measurementvalue, gearcaracteristic, gearusefeatures) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:99) flush - Flush for : observe_seine.gearusefeaturesmeasurement (size: 0) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [514294ns] for method 'Executed on table.', observe_seine.gearusefeaturesmeasurement (total call 99, total time 2.574s, min time 514294ns, max time 1.116s, avg time 25.996ms) WARN [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:237) log - [493.464ms] for method 'Action executed', org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction (total call 3, total time 2.602s, min time 493.464ms, max time 1.483s, avg time 867.268ms) Found: observe_seine.trip , 1 Found: observe_seine.gearusefeatures , 0 Found: observe_seine.gearusefeaturesmeasurement , 0 Found: observe_seine.route , 46 Found: observe_seine.set , 42 Found: observe_seine.activity , 657 Found: observe_seine.activity_observedsystem , 652 Found: observe_seine.floatingobject , 50 Found: observe_seine.schoolestimate , 10 Found: observe_seine.nontargetcatch , 112 Found: observe_seine.nontargetsample , 19 Found: observe_seine.nontargetlength , 242 Found: observe_seine.targetcatch , 73 Found: observe_seine.targetsample , 0 Found: observe_seine.targetlength , 0 Found: observe_seine.objectobservedspecies , 2 Found: observe_seine.objectschoolestimate , 3 Found: observe_seine.transmittingbuoy , 68 INFO [main] (fr.ird.observe.services.topia.entity.ReplicateTestSupport:128) testReplicate0 - Replicate to script (length: 1.146Mo) : <http://ci.codelutin.com/jenkins/job/observe-nightly/fr.ird.observe$services-topia/ws/target/surefire-workdir/tests/12329575390307807/ReplicateTripSeineTest/testReplicateTripSeine2/script.sql> INFO [main] (fr.ird.observe.services.topia.ObserveTopiaApplicationContextFactory:168) createTopiaApplicationContext - H2 Topia configuration: jdbc:h2:<http://ci.codelutin.com/jenkins/job/observe-nightly/fr.ird.observe$services-topia/ws/target/surefire-workdir/commons/5_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> Results : Tests run: 11, Failures: 0, Errors: 0, Skipped: 1 [JENKINS] Recording test results [JENKINS] Archiving disabled