- Observe-build - mailman.cloud.codelutin.com

Jenkins build is back to normal : observe-nightly » ObServe :: Services #99
by admin+ci-codelutin.com＠codelutin.com Dec. 18, 2016

Dec. 18, 2016

http://ci.codelutin.com/jenkins/job/observe-nightly/fr.ird.observe$services…

1 0

Jenkins build is back to normal : observe-nightly » ObServe :: Entities Migration #99
by admin+ci-codelutin.com＠codelutin.com Dec. 18, 2016

Dec. 18, 2016

http://ci.codelutin.com/jenkins/job/observe-nightly/fr.ird.observe$entities…

1 0

Jenkins build is back to normal : observe-nightly » ObServe :: Services ToPIA Validation #99
by admin+ci-codelutin.com＠codelutin.com Dec. 18, 2016

Dec. 18, 2016

http://ci.codelutin.com/jenkins/job/observe-nightly/fr.ird.observe$services…

1 0

Build failed in Jenkins: observe-nightly » ObServe :: Services ToPIA Implementation #99
by admin+ci-codelutin.com＠codelutin.com Dec. 18, 2016

Dec. 18, 2016

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…> 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…> 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…> 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…> 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…> 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…> Results : Tests run: 11, Failures: 0, Errors: 0, Skipped: 1 [JENKINS] Recording test results [JENKINS] Archiving disabled

1 0

Build failed in Jenkins: observe-technical-site-snapshot #86
by admin+ci-codelutin.com＠codelutin.com Dec. 18, 2016

Dec. 18, 2016

http://ci.codelutin.com/jenkins/job/observe-technical-site-snapshot/86/Chan…: [Tony CHEMIT] Nouvelle icône (Fixes #8886) [Tony CHEMIT] Use Topia 3.2 and Hibernate 5.1.3 (fixes #8889) [Tony CHEMIT] fix cherry-pick [Tony CHEMIT] Le transfert de 4 nouvelles marées de droite à gauche n'aboutit pas [Tony CHEMIT] Plantage de la synchro avancée de référentiel (Fixes #8882) [Tony CHEMIT] Exception si tentative de suppression d'une espèce (Fixes #8878) [Tony CHEMIT] Supprimer la configuration de la mémoire maximum à utiliser (Fixes [Tony CHEMIT] Mauvais chargement de l'action de synchro référentiel dans certains cas [Tony CHEMIT] fix cherry-pick [Tony CHEMIT] Problèmes de fiabilité/rafraichissement sur le formulaire LL Captures [Tony CHEMIT] refs #8863 Bien nettoyer les modèles d'actions à la fin [Tony CHEMIT] fix cherry-pick [Tony CHEMIT] fix cherry-pick [Tony CHEMIT] refs #8863 Prévenir des fuites mémoires quand on change de source + [Tony CHEMIT] Si on ferme la base, il reste des références sur celle-ci, ce qui peut [Tony CHEMIT] fix cherry-pick ------------------------------------------ [...truncated 876 lines...] main: [copy] Copying 1 file to <http://ci.codelutin.com/jenkins/job/observe-technical-site-snapshot/ws/enti…> [copy] Copying <http://ci.codelutin.com/jenkins/job/observe-technical-site-snapshot/ws/enti…> to <http://ci.codelutin.com/jenkins/job/observe-technical-site-snapshot/ws/enti…> [INFO] Executed tasks [INFO] [INFO] --- eugene-maven-plugin:3.0-alpha-10:generate (generate-persistence) @ entities --- [INFO] Process phase [zargo] [INFO] No resources copied. [INFO] Generate 3 files in 2.245s. [INFO] Process phase [xmi] INFO [main] (Resource.java:293) getURLs - search URLs pattern: .*/default-uml14.xmi in 100 urls in 16.251s INFO [main] (Resource.java:293) getURLs - search URLs pattern: .*/default-java.xmi in 100 urls in 1.12s [INFO] No resources copied. [INFO] Generate 3 files in 33.308s. [INFO] Process phase [model] [INFO] Process phase [generator] [INFO] Apply generator TopiaMetaTransformer [INFO] Apply generator TopiaMetadataModelGenerator INFO [main] (TopiaMetadataModelGenerator.java:258) buildMetadataEntity - Found ordered fr.ird.observe.entities.longline.CatchLongline catchLongline<<[ordered]>> tagvalue: {ordered=true, reverseDbName=set} -> set_idx [INFO] Generate 708 files in 1.748s. [INFO] [INFO] --- license-maven-plugin:1.9:update-project-license (attach-licenses) @ entities --- [INFO] Will create or update license file [gpl_v3] to <http://ci.codelutin.com/jenkins/job/observe-technical-site-snapshot/ws/enti…> [INFO] [INFO] --- license-maven-plugin:1.9:add-third-party (attach-licenses) @ entities --- [INFO] Load missing file <http://ci.codelutin.com/jenkins/job/observe-technical-site-snapshot/ws/enti…> [INFO] Missing file <http://ci.codelutin.com/jenkins/job/observe-technical-site-snapshot/ws/enti…> is up-to-date. [INFO] Writing third-party file to <http://ci.codelutin.com/jenkins/job/observe-technical-site-snapshot/ws/enti…> [INFO] Will attach third party file from <http://ci.codelutin.com/jenkins/job/observe-technical-site-snapshot/ws/enti…> [INFO] [INFO] --- maven-resources-plugin:3.0.1:resources (default-resources) @ entities --- [INFO] Using 'UTF-8' encoding to copy filtered resources. [INFO] Copying 0 resource [INFO] Copying 105 resources [INFO] Copying 2 resources [INFO] [INFO] --- license-maven-plugin:1.9:update-file-header (update-file-header) @ entities --- [INFO] Will search files to update from root <http://ci.codelutin.com/jenkins/job/observe-technical-site-snapshot/ws/enti…> [INFO] Will search files to update from root <http://ci.codelutin.com/jenkins/job/observe-technical-site-snapshot/ws/enti…> [INFO] Scan 810 files header done in 1.032m. [INFO] * uptodate header on 102 files. * add header on 708 files. [INFO] [INFO] --- maven-compiler-plugin:3.5.1:compile (default-compile) @ entities --- [INFO] Compiling 700 source files to <http://ci.codelutin.com/jenkins/job/observe-technical-site-snapshot/ws/enti…> [INFO] <http://ci.codelutin.com/jenkins/job/observe-technical-site-snapshot/ws/enti…>: Some input files use unchecked or unsafe operations. [INFO] <http://ci.codelutin.com/jenkins/job/observe-technical-site-snapshot/ws/enti…>: Recompile with -Xlint:unchecked for details. [INFO] [INFO] --- animal-sniffer-maven-plugin:1.15:check (default) @ entities --- [INFO] Checking unresolved references to org.codehaus.mojo.signature:java18:1.0 [INFO] [INFO] --- jredmine-maven-plugin:1.10:generate-changes (jredmine-generate-changes) @ entities --- [INFO] Use already generated changes.xml (<http://ci.codelutin.com/jenkins/job/observe-technical-site-snapshot/ws/targ…)> [INFO] Copying changes.xml to <http://ci.codelutin.com/jenkins/job/observe-technical-site-snapshot/ws/enti…> [INFO] Skipping goal (runOnce flag is on, and was already executed). [INFO] [INFO] --- jredmine-maven-plugin:1.10:generate-changes (generate-changes) @ entities --- [INFO] Skipping goal (runOnce flag is on, and was already executed). [INFO] [INFO] --- maven-resources-plugin:3.0.1:testResources (default-testResources) @ entities --- [INFO] Using 'UTF-8' encoding to copy filtered resources. [INFO] Copying 1 resource [INFO] [INFO] --- maven-compiler-plugin:3.5.1:testCompile (default-testCompile) @ entities --- [INFO] Compiling 4 source files to <http://ci.codelutin.com/jenkins/job/observe-technical-site-snapshot/ws/enti…> [INFO] <http://ci.codelutin.com/jenkins/job/observe-technical-site-snapshot/ws/enti…>: <http://ci.codelutin.com/jenkins/job/observe-technical-site-snapshot/ws/enti…> uses unchecked or unsafe operations. [INFO] <http://ci.codelutin.com/jenkins/job/observe-technical-site-snapshot/ws/enti…>: Recompile with -Xlint:unchecked for details. [INFO] [INFO] --- maven-surefire-plugin:2.19.1:test (default-test) @ entities --- ------------------------------------------------------- T E S T S ------------------------------------------------------- Running fr.ird.observe.entities.longline.SectionTemplateTest Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 15.322 sec - in fr.ird.observe.entities.longline.SectionTemplateTest Running fr.ird.observe.entities.referentiel.FormulaHelperTest Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 17.031 sec - in fr.ird.observe.entities.referentiel.FormulaHelperTest Running fr.ird.observe.RelationRegexTest Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0 sec - in fr.ird.observe.RelationRegexTest Running fr.ird.observe.ScriptTest INFO [main] (fr.ird.observe.ScriptTest:65) init - available factory [engine: Oracle Nashorn v.1.8.0_112] [language: ECMAScript, version:ECMA - 262 Edition 5.1], mime-types : ?[application/javascript, application/ecmascript, text/javascript, text/ecmascript]?[js] INFO [main] (fr.ird.observe.ScriptTest:111) doEvaluate - [js ] 'a*(x^b)' nb eval 1 in 18.819ms (~ 18.819ms) INFO [main] (fr.ird.observe.ScriptTest:111) doEvaluate - [js ] 'a*(x^b)' nb eval 10 in 2.229s (~ 222.901ms) INFO [main] (fr.ird.observe.ScriptTest:111) doEvaluate - [js ] 'a*(x^b)' nb eval 100 in 17.86ms (~ 178596ns) INFO [main] (fr.ird.observe.ScriptTest:111) doEvaluate - [js ] 'a*(x^b)' nb eval 1000 in 77.509ms (~ 77509ns) INFO [main] (fr.ird.observe.ScriptTest:111) doEvaluate - [js ] 'a*(x^b)' nb eval 1000 in 47.655ms (~ 47655ns) INFO [main] (fr.ird.observe.ScriptTest:111) doEvaluate - [js ] 'a*(x^b)' nb eval 100 in 8.715ms (~ 87147ns) INFO [main] (fr.ird.observe.ScriptTest:111) doEvaluate - [js ] 'a*(x^b)' nb eval 10 in 4.664ms (~ 466383ns) INFO [main] (fr.ird.observe.ScriptTest:111) doEvaluate - [js ] 'a*(x^b)' nb eval 1 in 3.898ms (~ 3.898ms) Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 2.103 sec - in fr.ird.observe.ScriptTest Results : Tests run: 6, Failures: 0, Errors: 0, Skipped: 0 [INFO] [INFO] --- maven-jar-plugin:3.0.2:jar (default-jar) @ entities --- [INFO] Building jar: <http://ci.codelutin.com/jenkins/job/observe-technical-site-snapshot/ws/enti…> [INFO] [INFO] >>> maven-source-plugin:3.0.1:jar (attach-sources) > generate-sources @ entities >>> [INFO] [INFO] --- helper-maven-plugin:2.3.2:check-auto-container (check-central-safe) @ entities --- [INFO] Will use repository http://repo1.maven.org/maven2/ [INFO] Will use repository https://nexus.nuiton.org/nexus/content/repositories/central-releases [INFO] 51 dependencies to check. [INFO] 51 artifact(s) resolved by repository http://repo1.maven.org/maven2/ in 115272ns [INFO] All dependencies are safe. [INFO] [INFO] --- maven-enforcer-plugin:1.4.1:enforce (enforce-project-files) @ entities --- [INFO] [INFO] --- maven-enforcer-plugin:1.4.1:enforce (enforce-platform) @ entities --- [INFO] [INFO] --- maven-enforcer-plugin:1.4.1:enforce (enforce-projectId) @ entities --- [INFO] [INFO] --- maven-enforcer-plugin:1.4.1:enforce (enforce-ciViewId) @ entities --- [INFO] [INFO] --- maven-enforcer-plugin:1.4.1:enforce (enforce-javaVersion) @ entities --- [INFO] [INFO] --- maven-enforcer-plugin:1.4.1:enforce (enforce-signatureArtifactId) @ entities --- [INFO] [INFO] --- maven-enforcer-plugin:1.4.1:enforce (enforce-signatureVersion) @ entities --- [INFO] [INFO] --- maven-enforcer-plugin:1.4.1:enforce (enforce-java-versions) @ entities --- [INFO] [INFO] --- maven-enforcer-plugin:1.4.1:enforce (ensure-no-container-api) @ entities --- [INFO] [INFO] --- maven-enforcer-plugin:1.4.1:enforce (enforce-bytecode-version) @ entities --- [INFO] [INFO] --- helper-maven-plugin:2.3.2:share-server-secret (get-redmine-login) @ entities --- [INFO] Skipping goal (runOnce flag is on and goal was already executed). [INFO] [INFO] --- maven-antrun-plugin:1.8:run (copy model files) @ entities --- [INFO] Executing tasks main: [copy] Copying 1 file to <http://ci.codelutin.com/jenkins/job/observe-technical-site-snapshot/ws/enti…> [copy] Copying <http://ci.codelutin.com/jenkins/job/observe-technical-site-snapshot/ws/enti…> to <http://ci.codelutin.com/jenkins/job/observe-technical-site-snapshot/ws/enti…> [INFO] Executed tasks [INFO] [INFO] --- eugene-maven-plugin:3.0-alpha-10:generate (generate-persistence) @ entities --- [INFO] Process phase [zargo] [INFO] No resources copied. [INFO] No file generated. [INFO] Process phase [xmi] [INFO] No resources copied. [INFO] No file generated. [INFO] Process phase [model] [INFO] Process phase [generator] [INFO] Apply generator TopiaMetaTransformer [INFO] Apply generator TopiaMetadataModelGenerator [INFO] No file generated. [INFO] [INFO] <<< maven-source-plugin:3.0.1:jar (attach-sources) < generate-sources @ entities <<< [INFO] [INFO] --- maven-source-plugin:3.0.1:jar (attach-sources) @ entities --- [INFO] Skipping source per configuration. [INFO] [INFO] --- maven-javadoc-plugin:2.10.4:jar (attach-javadocs) @ entities --- [INFO] Skipping javadoc generation [INFO] [INFO] --- maven-site-plugin:3.4:attach-descriptor (attach-descriptor) @ entities --- [INFO] [INFO] --- helper-maven-plugin:2.3.2:share-server-secret (get-pgp-passphrase) @ entities --- [INFO] Exporting server [gpg-signer] username in ${gpg.keyname} [INFO] Exporting server [gpg-signer] password in ${gpg.passphrase} [INFO] [INFO] --- helper-maven-plugin:2.3.2:collect-files (collect-build-artifacts) @ entities --- [INFO] Loaded <http://ci.codelutin.com/jenkins/job/observe-technical-site-snapshot/ws/targ…> [INFO] Copying entities-6.0-SNAPSHOT.jar to <http://ci.codelutin.com/jenkins/job/observe-technical-site-snapshot/ws/targ…> [INFO] Copying THIRD-PARTY.properties to <http://ci.codelutin.com/jenkins/job/observe-technical-site-snapshot/ws/targ…> [INFO] [INFO] --- helper-maven-plugin:2.3.2:collect-files (collect-build-attachements) @ entities --- [WARNING] Skipping goal (No file to collect). [INFO] [INFO] --- maven-gpg-plugin:1.6:sign (sign-artifacts) @ entities --- [INFO] [INFO] --- maven-dependency-plugin:2.10:analyze-only (analyze) @ entities --- [INFO] Used declared dependencies found: [INFO] fr.ird.observe:topia-extension:jar:6.0-SNAPSHOT:compile [INFO] org.nuiton:nuiton-utils:jar:3.0-rc-16:compile [INFO] org.nuiton:nuiton-version:jar:1.0-rc-2:compile [INFO] org.apache.commons:commons-lang3:jar:3.5:compile [INFO] org.apache.commons:commons-collections4:jar:4.1:compile [INFO] commons-logging:commons-logging:jar:1.2:compile [INFO] commons-io:commons-io:jar:2.5:compile [INFO] com.google.guava:guava:jar:20.0:compile [INFO] org.swinglabs.swingx:swingx-common:jar:1.6.5-1:compile [INFO] org.reflections:reflections:jar:0.9.10:compile [INFO] org.nuiton.topia:topia-persistence:jar:3.2:compile [INFO] org.nuiton.topia:topia-service-migration:jar:3.2:compile [INFO] org.hibernate:hibernate-core:jar:5.1.3.Final:compile [INFO] org.hibernate:hibernate-hikaricp:jar:5.1.3.Final:compile [INFO] junit:junit:jar:4.12:test [WARNING] Unused declared dependencies found: [WARNING] com.zaxxer:HikariCP:jar:2.5.1:compile [INFO] ------------------------------------------------------------------------ [INFO] Reactor Summary: [INFO] [INFO] ObServe ............................................ SUCCESS [02:48 min] [INFO] ObServe :: Toolbox Maven plugin .................... SUCCESS [02:05 min] [INFO] ObServe :: ToPIA Extension ......................... SUCCESS [01:12 min] [INFO] ObServe :: ToPIA Templates Extension ............... SUCCESS [01:25 min] [INFO] ObServe :: Test .................................... SUCCESS [ 47.957 s] [INFO] ObServe :: Entities ................................ FAILURE [10:13 min] [INFO] ObServe :: Entities Migration ...................... SKIPPED [INFO] ObServe :: Services Configuration .................. SKIPPED [INFO] ObServe :: Services ToPIA Configuration ............ SKIPPED [INFO] ObServe :: Services REST Configuration ............. SKIPPED [INFO] ObServe :: Services DTO ............................ SKIPPED [INFO] ObServe :: Services DTO References ................. SKIPPED [INFO] ObServe :: Services DTO Gson ....................... SKIPPED [INFO] ObServe :: Services ................................ SKIPPED [INFO] ObServe :: Services ToPIA Validators ............... SKIPPED [INFO] ObServe :: Services ToPIA Validation ............... SKIPPED [INFO] ObServe :: Services ToPIA Binder ................... SKIPPED [INFO] ObServe :: Services ToPIA Implementation ........... SKIPPED [INFO] ObServe :: Services REST Implementation ............ SKIPPED [INFO] ObServe :: Application Swing Decoration ............ SKIPPED [INFO] ObServe :: Application Swing Validators ............ SKIPPED [INFO] ObServe :: Application Swing Validation ............ SKIPPED [INFO] ObServe :: Services Runner ......................... SKIPPED [INFO] ObServe :: Application Web Configuration ........... SKIPPED [INFO] ObServe :: Application Web ......................... SKIPPED [INFO] ObServe :: Application Swing Configuration ......... SKIPPED [INFO] ObServe :: Application Swing ....................... SKIPPED [INFO] ------------------------------------------------------------------------ [INFO] BUILD FAILURE [INFO] ------------------------------------------------------------------------ [INFO] Total time: 18:54 min [INFO] Finished at: 2016-12-16T03:23:42+01:00 [INFO] Final Memory: 119M/536M [INFO] ------------------------------------------------------------------------ [ERROR] Failed to execute goal org.apache.maven.plugins:maven-dependency-plugin:2.10:analyze-only (analyze) on project entities: Dependency problems found -> [Help 1] [ERROR] [ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch. [ERROR] Re-run Maven using the -X switch to enable full debug logging. [ERROR] [ERROR] For more information about the errors and possible solutions, please read the following articles: [ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/MojoExecutionException [ERROR] [ERROR] After correcting the problems, you can resume the build with the command [ERROR] mvn <goals> -rf :entities Build step 'Invoke top-level Maven targets' marked build as failure Started calculate disk usage of build Finished Calculation of disk usage of build in 6 second Started calculate disk usage of workspace Finished Calculation of disk usage of workspace in 22 second

1 1

Jenkins build is back to normal : observe-nightly » ObServe :: Services ToPIA Configuration #99
by admin+ci-codelutin.com＠codelutin.com Dec. 18, 2016

Dec. 18, 2016

http://ci.codelutin.com/jenkins/job/observe-nightly/fr.ird.observe$services…

1 0

Jenkins build is back to normal : observe-nightly » ObServe :: ToPIA Extension #99
by admin+ci-codelutin.com＠codelutin.com Dec. 18, 2016

Dec. 18, 2016

http://ci.codelutin.com/jenkins/job/observe-nightly/fr.ird.observe$topia-ex…

1 0

Jenkins build is back to normal : observe-nightly » ObServe :: Test #99
by admin+ci-codelutin.com＠codelutin.com Dec. 18, 2016

Dec. 18, 2016

http://ci.codelutin.com/jenkins/job/observe-nightly/fr.ird.observe$test/99/

1 0

Jenkins build is back to normal : observe-nightly » ObServe :: Services REST Configuration #99
by admin+ci-codelutin.com＠codelutin.com Dec. 18, 2016

Dec. 18, 2016

http://ci.codelutin.com/jenkins/job/observe-nightly/fr.ird.observe$services…

1 0

Jenkins build is back to normal : observe-nightly » ObServe :: Entities #99
by admin+ci-codelutin.com＠codelutin.com Dec. 18, 2016

Dec. 18, 2016

http://ci.codelutin.com/jenkins/job/observe-nightly/fr.ird.observe$entities…

1 0