http://ci.codelutin.com/jenkins/job/observe-sonar/fr.ird.observe$services-to... [...truncated 8493 lines...] DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction:183) newInsertStatementSql - Insert sql: INSERT INTO observe_longline.stomacfullness(topiaid, topiaversion, topiacreatedate, lastupdatedate, code, uri, needcomment, status, label1, label2, label3, label4, label5, label6, label7, label8) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.stomacfullness (size: 7) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [410528ns] for method 'Execute on table', SELECT stomacfullness.* FROM observe_longline.stomacfullness stomacfullness (total call 218, total time 2.37s, min time 239359ns, max time 212.704ms, avg time 10.873ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [786658ns] for method 'Executed on table.', observe_longline.stomacfullness (total call 218, total time 5.384s, min time 648021ns, max time 466.996ms, avg time 24.698ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:208) createReadStatement - Read sql: SELECT triptype.* FROM observe_longline.triptype triptype DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [18213ns] for method 'Read statement', SELECT triptype.* FROM observe_longline.triptype triptype (total call 219, total time 458.103ms, min time 10516ns, max time 23.834ms, avg time 2.092ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction:183) newInsertStatementSql - Insert sql: INSERT INTO observe_longline.triptype(topiaid, topiaversion, topiacreatedate, lastupdatedate, code, uri, needcomment, status, label1, label2, label3, label4, label5, label6, label7, label8) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.triptype (size: 3) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [341342ns] for method 'Execute on table', SELECT triptype.* FROM observe_longline.triptype triptype (total call 219, total time 2.371s, min time 239359ns, max time 212.704ms, avg time 10.825ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [709231ns] for method 'Executed on table.', observe_longline.triptype (total call 219, total time 5.385s, min time 648021ns, max time 466.996ms, avg time 24.589ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:208) createReadStatement - Read sql: SELECT vesselactivity.* FROM observe_longline.vesselactivity vesselactivity DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [23336ns] for method 'Read statement', SELECT vesselactivity.* FROM observe_longline.vesselactivity vesselactivity (total call 220, total time 458.127ms, min time 10516ns, max time 23.834ms, avg time 2.082ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction:183) newInsertStatementSql - Insert sql: INSERT INTO observe_longline.vesselactivity(topiaid, topiaversion, topiacreatedate, lastupdatedate, code, uri, needcomment, status, label1, label2, label3, label4, label5, label6, label7, label8) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.vesselactivity (size: 5) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [378081ns] for method 'Execute on table', SELECT vesselactivity.* FROM observe_longline.vesselactivity vesselactivity (total call 220, total time 2.371s, min time 239359ns, max time 212.704ms, avg time 10.777ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [758564ns] for method 'Executed on table.', observe_longline.vesselactivity (total call 220, total time 5.386s, min time 648021ns, max time 466.996ms, avg time 24.481ms) WARN [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:237) log - [206.588ms] for method 'Action executed', org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction (total call 10, total time 25.563s, min time 206.588ms, max time 18.964s, avg time 2.556s) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:208) createReadStatement - Read sql: SELECT trip.* FROM observe_seine.trip trip DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [8170ns] for method 'Read statement', SELECT trip.* FROM observe_seine.trip trip (total call 221, total time 458.135ms, min time 8170ns, max time 23.834ms, avg time 2.073ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction:183) newInsertStatementSql - Insert sql: INSERT INTO observe_seine.trip(topiaid, topiaversion, topiacreatedate, lastupdatedate, comment, startdate, enddate, checklevel, formsurl, reportsurl, historicaldata, ersid, ocean, vessel, program, observer, captain, dataentryoperator, departureharbour, landingharbour) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_seine.trip (size: 0) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [234308ns] for method 'Execute on table', SELECT trip.* FROM observe_seine.trip trip (total call 221, total time 2.371s, min time 234308ns, max time 212.704ms, avg time 10.729ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [677989ns] for method 'Executed on table.', observe_seine.trip (total call 221, total time 5.386s, min time 648021ns, max time 466.996ms, avg time 24.373ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:208) createReadStatement - Read sql: SELECT route.* FROM observe_seine.route route DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [7123ns] for method 'Read statement', SELECT route.* FROM observe_seine.route route (total call 222, total time 458.142ms, min time 7123ns, max time 23.834ms, avg time 2.064ms) 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:97) flush - Flush for : observe_seine.route (size: 0) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [223697ns] for method 'Execute on table', SELECT route.* FROM observe_seine.route route (total call 222, total time 2.371s, min time 223697ns, max time 212.704ms, avg time 10.682ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [578423ns] for method 'Executed on table.', observe_seine.route (total call 222, total time 5.387s, min time 578423ns, max time 466.996ms, avg time 24.266ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:208) 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 DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [10788ns] for method 'Read statement', 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 (total call 223, total time 458.153ms, min time 7123ns, max time 23.834ms, avg time 2.054ms) 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, supportvesselname, targetdiscarded, nontargetdiscarded, currentmeasuredepth, schooltype, targetcatchcompositionestimatedbyobserver, targetdiscardcatchcompositionestimatedbyobserver, reasonfornullset) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_seine.set (size: 0) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [245565ns] for method 'Execute on table', 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 (total call 223, total time 2.372s, min time 223697ns, max time 212.704ms, avg time 10.635ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [752240ns] for method 'Executed on table.', observe_seine.set (total call 223, total time 5.388s, min time 578423ns, max time 466.996ms, avg time 24.16ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:208) createReadStatement - Read sql: SELECT activity.* FROM observe_seine.route route INNER JOIN observe_seine.activity activity ON activity.route = route.topiaId DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [7628ns] for method 'Read statement', SELECT activity.* FROM observe_seine.route route INNER JOIN observe_seine.activity activity ON activity.route = route.topiaId (total call 224, total time 458.16ms, min time 7123ns, max time 23.834ms, avg time 2.045ms) 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:97) flush - Flush for : observe_seine.activity (size: 0) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [270008ns] for method 'Execute on table', SELECT activity.* FROM observe_seine.route route INNER JOIN observe_seine.activity activity ON activity.route = route.topiaId (total call 224, total time 2.372s, min time 223697ns, max time 212.704ms, avg time 10.589ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [665892ns] for method 'Executed on table.', observe_seine.activity (total call 224, total time 5.388s, min time 578423ns, max time 466.996ms, avg time 24.055ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:208) 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 DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [19287ns] for method 'Read statement', 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 (total call 225, total time 458.179ms, min time 7123ns, max time 23.834ms, avg time 2.036ms) 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, well, reasonfordiscard, species, speciesfate, set) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_seine.nontargetcatch (size: 0) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [258677ns] for method 'Execute on table', 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 (total call 225, total time 2.372s, min time 223697ns, max time 212.704ms, avg time 10.543ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [740287ns] for method 'Executed on table.', observe_seine.nontargetcatch (total call 225, total time 5.389s, min time 578423ns, max time 466.996ms, avg time 23.952ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:208) 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 DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [13138ns] for method 'Read statement', 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 (total call 226, total time 458.193ms, min time 7123ns, max time 23.834ms, avg time 2.027ms) 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:97) flush - Flush for : observe_seine.nontargetsample (size: 0) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [236181ns] for method 'Execute on table', 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 (total call 226, total time 2.372s, min time 223697ns, max time 212.704ms, avg time 10.498ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [794397ns] for method 'Executed on table.', observe_seine.nontargetsample (total call 226, total time 5.39s, min time 578423ns, max time 466.996ms, avg time 23.849ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:208) 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 DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [20092ns] for method 'Read statement', 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 (total call 227, total time 458.213ms, min time 7123ns, max time 23.834ms, avg time 2.019ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction:183) newInsertStatementSql - Insert sql: INSERT INTO observe_seine.nontargetlength(topiaid, topiaversion, topiacreatedate, lastupdatedate, length, islengthcomputed, picturesreferences, weight, isweightcomputed, count, acquisitionmode, tagnumber, species, sex, speciesfate, sizemeasuretype, nontargetsample) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_seine.nontargetlength (size: 0) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [412799ns] for method 'Execute on table', 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 (total call 227, total time 2.373s, min time 223697ns, max time 212.704ms, avg time 10.453ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [1.395ms] for method 'Executed on table.', observe_seine.nontargetlength (total call 227, total time 5.391s, min time 578423ns, max time 466.996ms, avg time 23.75ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:208) 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 DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [16545ns] for method 'Read statement', 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 (total call 228, total time 458.229ms, min time 7123ns, max time 23.834ms, avg time 2.01ms) 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:97) flush - Flush for : observe_seine.targetsample (size: 0) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [245776ns] for method 'Execute on table', 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 (total call 228, total time 2.373s, min time 223697ns, max time 212.704ms, avg time 10.408ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [757545ns] for method 'Executed on table.', observe_seine.targetsample (total call 228, total time 5.392s, min time 578423ns, max time 466.996ms, avg time 23.649ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:208) 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 DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [14052ns] for method 'Read statement', 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 (total call 229, total time 458.243ms, min time 7123ns, max time 23.834ms, avg time 2.001ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction:183) newInsertStatementSql - Insert sql: INSERT INTO observe_seine.targetlength(topiaid, topiaversion, topiacreatedate, lastupdatedate, length, islengthcomputed, count, weight, isweightcomputed, acquisitionmode, tagnumber, targetsample, species, sizemeasuretype, sex) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_seine.targetlength (size: 0) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [263650ns] for method 'Execute on table', 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 (total call 229, total time 2.373s, min time 223697ns, max time 212.704ms, avg time 10.364ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [1.07ms] for method 'Executed on table.', observe_seine.targetlength (total call 229, total time 5.393s, min time 578423ns, max time 466.996ms, avg time 23.551ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:208) 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 DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [13779ns] for method 'Read statement', 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 (total call 230, total time 458.257ms, min time 7123ns, max time 23.834ms, avg time 1.992ms) 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:97) flush - Flush for : observe_seine.targetcatch (size: 0) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [237287ns] for method 'Execute on table', 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 (total call 230, total time 2.374s, min time 223697ns, max time 212.704ms, avg time 10.32ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [733538ns] for method 'Executed on table.', observe_seine.targetcatch (total call 230, total time 5.394s, min time 578423ns, max time 466.996ms, avg time 23.452ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:208) 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 DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [13700ns] for method 'Read statement', 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 (total call 231, total time 458.271ms, min time 7123ns, max time 23.834ms, avg time 1.984ms) 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:97) flush - Flush for : observe_seine.schoolestimate (size: 0) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [985124ns] for method 'Execute on table', 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 (total call 231, total time 2.375s, min time 223697ns, max time 212.704ms, avg time 10.28ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [1.498ms] for method 'Executed on table.', observe_seine.schoolestimate (total call 231, total time 5.395s, min time 578423ns, max time 466.996ms, avg time 23.357ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:208) 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 DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [18101ns] for method 'Read statement', 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 (total call 232, total time 458.289ms, min time 7123ns, max time 23.834ms, avg time 1.975ms) 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, objecttype, objectoperation, objectfate, activity) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_seine.floatingobject (size: 0) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [244248ns] for method 'Execute on table', 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 (total call 232, total time 2.375s, min time 223697ns, max time 212.704ms, avg time 10.236ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [725949ns] for method 'Executed on table.', observe_seine.floatingobject (total call 232, total time 5.396s, min time 578423ns, max time 466.996ms, avg time 23.259ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:208) 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 DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [8856ns] for method 'Read statement', 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 (total call 233, total time 458.298ms, min time 7123ns, max time 23.834ms, avg time 1.967ms) 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:97) flush - Flush for : observe_seine.objectschoolestimate (size: 0) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [222062ns] for method 'Execute on table', 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 (total call 233, total time 2.375s, min time 222062ns, max time 212.704ms, avg time 10.193ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [674521ns] for method 'Executed on table.', observe_seine.objectschoolestimate (total call 233, total time 5.397s, min time 578423ns, max time 466.996ms, avg time 23.162ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:208) 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 DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [9106ns] for method 'Read statement', 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 (total call 234, total time 458.307ms, min time 7123ns, max time 23.834ms, avg time 1.959ms) 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:97) flush - Flush for : observe_seine.objectobservedspecies (size: 0) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [263029ns] for method 'Execute on table', 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 (total call 234, total time 2.375s, min time 222062ns, max time 212.704ms, avg time 10.151ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [727485ns] for method 'Executed on table.', observe_seine.objectobservedspecies (total call 234, total time 5.398s, min time 578423ns, max time 466.996ms, avg time 23.066ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:208) 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 DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [8949ns] for method 'Read statement', 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 (total call 235, total time 458.316ms, min time 7123ns, max time 23.834ms, avg time 1.95ms) 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:97) flush - Flush for : observe_seine.transmittingbuoy (size: 0) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [310918ns] for method 'Execute on table', 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 (total call 235, total time 2.376s, min time 222062ns, max time 212.704ms, avg time 10.109ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [813591ns] for method 'Executed on table.', observe_seine.transmittingbuoy (total call 235, total time 5.398s, min time 578423ns, max time 466.996ms, avg time 22.972ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:208) 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 DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [8541ns] for method 'Read statement', 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 (total call 236, total time 458.324ms, min time 7123ns, max time 23.834ms, avg time 1.942ms) 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:97) flush - Flush for : observe_seine.activity_observedsystem (size: 0) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [265474ns] for method 'Execute on table', 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 (total call 236, total time 2.376s, min time 222062ns, max time 212.704ms, avg time 10.067ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [688831ns] for method 'Executed on table.', observe_seine.activity_observedsystem (total call 236, total time 5.399s, min time 578423ns, max time 466.996ms, avg time 22.877ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:208) createReadStatement - Read sql: SELECT gearusefeatures.* FROM observe_seine.gearusefeatures gearusefeatures DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [7508ns] for method 'Read statement', SELECT gearusefeatures.* FROM observe_seine.gearusefeatures gearusefeatures (total call 237, total time 458.332ms, min time 7123ns, max time 23.834ms, avg time 1.934ms) 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:97) flush - Flush for : observe_seine.gearusefeatures (size: 0) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [219923ns] for method 'Execute on table', SELECT gearusefeatures.* FROM observe_seine.gearusefeatures gearusefeatures (total call 237, total time 2.376s, min time 219923ns, max time 212.704ms, avg time 10.026ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [588020ns] for method 'Executed on table.', observe_seine.gearusefeatures (total call 237, total time 5.4s, min time 578423ns, max time 466.996ms, avg time 22.783ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:208) createReadStatement - Read sql: SELECT gearusefeaturesmeasurement.* FROM observe_seine.gearusefeatures gearusefeatures INNER JOIN observe_seine.gearusefeaturesmeasurement gearusefeaturesmeasurement ON gearusefeaturesmeasurement.gearusefeatures = gearusefeatures.topiaId DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [7126ns] for method 'Read statement', SELECT gearusefeaturesmeasurement.* FROM observe_seine.gearusefeatures gearusefeatures INNER JOIN observe_seine.gearusefeaturesmeasurement gearusefeaturesmeasurement ON gearusefeaturesmeasurement.gearusefeatures = gearusefeatures.topiaId (total call 238, total time 458.339ms, min time 7123ns, max time 23.834ms, avg time 1.926ms) 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:97) flush - Flush for : observe_seine.gearusefeaturesmeasurement (size: 0) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [213260ns] for method 'Execute on table', SELECT gearusefeaturesmeasurement.* FROM observe_seine.gearusefeatures gearusefeatures INNER JOIN observe_seine.gearusefeaturesmeasurement gearusefeaturesmeasurement ON gearusefeaturesmeasurement.gearusefeatures = gearusefeatures.topiaId (total call 238, total time 2.376s, min time 213260ns, max time 212.704ms, avg time 9.985ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [579675ns] for method 'Executed on table.', observe_seine.gearusefeaturesmeasurement (total call 238, total time 5.4s, min time 578423ns, max time 466.996ms, avg time 22.69ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [16.368ms] for method 'Action executed', org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction (total call 11, total time 25.58s, min time 16.368ms, max time 18.964s, avg time 2.325s) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:208) createReadStatement - Read sql: SELECT trip.* FROM observe_longline.trip trip DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [47848ns] for method 'Read statement', SELECT trip.* FROM observe_longline.trip trip (total call 239, total time 458.387ms, min time 7123ns, max time 23.834ms, avg time 1.918ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction:183) newInsertStatementSql - Insert sql: INSERT INTO observe_longline.trip(topiaid, topiaversion, topiacreatedate, lastupdatedate, comment, startdate, enddate, totalfishingoperationsnumber, homeid, triptype, observer, vessel, captain, dataentryoperator, program, ocean, departureharbour, landingharbour) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.trip (size: 3) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [589808ns] for method 'Execute on table', SELECT trip.* FROM observe_longline.trip trip (total call 239, total time 2.377s, min time 213260ns, max time 212.704ms, avg time 9.945ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [1.048ms] for method 'Executed on table.', observe_longline.trip (total call 239, total time 5.401s, min time 578423ns, max time 466.996ms, avg time 22.599ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:208) createReadStatement - Read sql: SELECT set.* FROM observe_longline.activity activity INNER JOIN observe_longline.set set ON set.topiaId = activity.set DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [511520ns] for method 'Read statement', SELECT set.* FROM observe_longline.activity activity INNER JOIN observe_longline.set set ON set.topiaId = activity.set (total call 240, total time 458.898ms, min time 7123ns, max time 23.834ms, avg time 1.912ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction:183) newInsertStatementSql - Insert sql: INSERT INTO observe_longline.set(topiaid, topiaversion, topiacreatedate, lastupdatedate, comment, homeid, number, basketspersectioncount, branchlinesperbasketcount, totalsectionscount, totalbasketscount, totalhookscount, weightedsnap, snapweight, weightedswivel, swivelweight, lightsticksperbasketcount, timebetweenhooks, shooterused, shooterspeed, maxdepthtargeted, settingstarttimestamp, settingstartlatitude, settingstartlongitude, settingendtimestamp, settingendlatitude, settingendlongitude, settingvesselspeed, haulingdirectionsameassetting, haulingstarttimestamp, haulingstartlatitude, haulingstartlongitude, haulingendtimestamp, haulingendlatitude, haulingendlongitude, haulingbreaks, monitored, settingshape, linetype, lightstickstype, lightstickscolor) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.set (size: 32) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [3.193ms] for method 'Execute on table', SELECT set.* FROM observe_longline.activity activity INNER JOIN observe_longline.set set ON set.topiaId = activity.set (total call 240, total time 2.38s, min time 213260ns, max time 212.704ms, avg time 9.917ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [4.119ms] for method 'Executed on table.', observe_longline.set (total call 240, total time 5.405s, min time 578423ns, max time 466.996ms, avg time 22.522ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:208) createReadStatement - Read sql: SELECT activity.* FROM observe_longline.activity activity DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [36972ns] for method 'Read statement', SELECT activity.* FROM observe_longline.activity activity (total call 241, total time 458.935ms, min time 7123ns, max time 23.834ms, avg time 1.904ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction:183) newInsertStatementSql - Insert sql: INSERT INTO observe_longline.activity(topiaid, topiaversion, topiacreatedate, lastupdatedate, comment, timestamp, latitude, longitude, seasurfacetemperature, set, vesselactivity, fpazone, trip) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.activity (size: 32) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [1.447ms] for method 'Execute on table', SELECT activity.* FROM observe_longline.activity activity (total call 241, total time 2.382s, min time 213260ns, max time 212.704ms, avg time 9.882ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [1.89ms] for method 'Executed on table.', observe_longline.activity (total call 241, total time 5.407s, min time 578423ns, max time 466.996ms, avg time 22.437ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:208) createReadStatement - Read sql: SELECT baitscomposition.* FROM observe_longline.activity activity INNER JOIN observe_longline.set set ON set.topiaId = activity.set INNER JOIN observe_longline.baitscomposition baitscomposition ON baitscomposition.set = set.topiaId DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [309853ns] for method 'Read statement', SELECT baitscomposition.* FROM observe_longline.activity activity INNER JOIN observe_longline.set set ON set.topiaId = activity.set INNER JOIN observe_longline.baitscomposition baitscomposition ON baitscomposition.set = set.topiaId (total call 242, total time 459.245ms, min time 7123ns, max time 23.834ms, avg time 1.898ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction:183) newInsertStatementSql - Insert sql: INSERT INTO observe_longline.baitscomposition(topiaid, topiaversion, topiacreatedate, lastupdatedate, proportion, individualsize, individualweight, baitsettingstatus, baittype, set) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.baitscomposition (size: 37) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [1.368ms] for method 'Execute on table', SELECT baitscomposition.* FROM observe_longline.activity activity INNER JOIN observe_longline.set set ON set.topiaId = activity.set INNER JOIN observe_longline.baitscomposition baitscomposition ON baitscomposition.set = set.topiaId (total call 242, total time 2.383s, min time 213260ns, max time 212.704ms, avg time 9.847ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [2.162ms] for method 'Executed on table.', observe_longline.baitscomposition (total call 242, total time 5.409s, min time 578423ns, max time 466.996ms, avg time 22.353ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:208) createReadStatement - Read sql: SELECT floatlinescomposition.* FROM observe_longline.activity activity INNER JOIN observe_longline.set set ON set.topiaId = activity.set INNER JOIN observe_longline.floatlinescomposition floatlinescomposition ON floatlinescomposition.set = set.topiaId DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [605704ns] for method 'Read statement', SELECT floatlinescomposition.* FROM observe_longline.activity activity INNER JOIN observe_longline.set set ON set.topiaId = activity.set INNER JOIN observe_longline.floatlinescomposition floatlinescomposition ON floatlinescomposition.set = set.topiaId (total call 243, total time 459.851ms, min time 7123ns, max time 23.834ms, avg time 1.892ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction:183) newInsertStatementSql - Insert sql: INSERT INTO observe_longline.floatlinescomposition(topiaid, topiaversion, topiacreatedate, lastupdatedate, length, proportion, linetype, set) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.floatlinescomposition (size: 101) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [2.554ms] for method 'Execute on table', SELECT floatlinescomposition.* FROM observe_longline.activity activity INNER JOIN observe_longline.set set ON set.topiaId = activity.set INNER JOIN observe_longline.floatlinescomposition floatlinescomposition ON floatlinescomposition.set = set.topiaId (total call 243, total time 2.385s, min time 213260ns, max time 212.704ms, avg time 9.817ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [3.632ms] for method 'Executed on table.', observe_longline.floatlinescomposition (total call 243, total time 5.413s, min time 578423ns, max time 466.996ms, avg time 22.276ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:208) createReadStatement - Read sql: SELECT hookscomposition.* FROM observe_longline.activity activity INNER JOIN observe_longline.set set ON set.topiaId = activity.set INNER JOIN observe_longline.hookscomposition hookscomposition ON hookscomposition.set = set.topiaId DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [646984ns] for method 'Read statement', SELECT hookscomposition.* FROM observe_longline.activity activity INNER JOIN observe_longline.set set ON set.topiaId = activity.set INNER JOIN observe_longline.hookscomposition hookscomposition ON hookscomposition.set = set.topiaId (total call 244, total time 460.498ms, min time 7123ns, max time 23.834ms, avg time 1.887ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction:183) newInsertStatementSql - Insert sql: INSERT INTO observe_longline.hookscomposition(topiaid, topiaversion, topiacreatedate, lastupdatedate, proportion, hookoffset, hooktype, hooksize, set) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.hookscomposition (size: 91) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [2.564ms] for method 'Execute on table', SELECT hookscomposition.* FROM observe_longline.activity activity INNER JOIN observe_longline.set set ON set.topiaId = activity.set INNER JOIN observe_longline.hookscomposition hookscomposition ON hookscomposition.set = set.topiaId (total call 244, total time 2.388s, min time 213260ns, max time 212.704ms, avg time 9.787ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [3.723ms] for method 'Executed on table.', observe_longline.hookscomposition (total call 244, total time 5.417s, min time 578423ns, max time 466.996ms, avg time 22.2ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:208) createReadStatement - Read sql: SELECT section.* FROM observe_longline.activity activity INNER JOIN observe_longline.set set ON set.topiaId = activity.set INNER JOIN observe_longline.section section ON section.set = set.topiaId DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [2.789ms] for method 'Read statement', SELECT section.* FROM observe_longline.activity activity INNER JOIN observe_longline.set set ON set.topiaId = activity.set INNER JOIN observe_longline.section section ON section.set = set.topiaId (total call 245, total time 463.287ms, min time 7123ns, max time 23.834ms, avg time 1.891ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction:183) newInsertStatementSql - Insert sql: INSERT INTO observe_longline.section(topiaid, topiaversion, topiacreatedate, lastupdatedate, settingidentifier, haulingidentifier, set) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.section (size: 572) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [10.952ms] for method 'Execute on table', SELECT section.* FROM observe_longline.activity activity INNER JOIN observe_longline.set set ON set.topiaId = activity.set INNER JOIN observe_longline.section section ON section.set = set.topiaId (total call 245, total time 2.399s, min time 213260ns, max time 212.704ms, avg time 9.792ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [14.227ms] for method 'Executed on table.', observe_longline.section (total call 245, total time 5.431s, min time 578423ns, max time 466.996ms, avg time 22.167ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:208) createReadStatement - Read sql: SELECT basket.* FROM observe_longline.activity activity INNER JOIN observe_longline.set set ON set.topiaId = activity.set INNER JOIN observe_longline.basket basket ON basket.set = set.topiaId DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:241) log - [36.885ms] for method 'Read statement', SELECT basket.* FROM observe_longline.activity activity INNER JOIN observe_longline.set set ON set.topiaId = activity.set INNER JOIN observe_longline.basket basket ON basket.set = set.topiaId (total call 246, total time 500.172ms, min time 7123ns, max time 36.885ms, avg time 2.033ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction:183) newInsertStatementSql - Insert sql: INSERT INTO observe_longline.basket(topiaid, topiaversion, topiacreatedate, lastupdatedate, settingidentifier, haulingidentifier, floatline1length, floatline2length, set, section) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.basket (size: 1000) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.basket (size: 2000) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.basket (size: 3000) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.basket (size: 4000) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.basket (size: 5000) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.basket (size: 6000) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.basket (size: 7000) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.basket (size: 7411) WARN [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:237) log - [164.217ms] for method 'Execute on table', SELECT basket.* FROM observe_longline.activity activity INNER JOIN observe_longline.set set ON set.topiaId = activity.set INNER JOIN observe_longline.basket basket ON basket.set = set.topiaId (total call 246, total time 2.563s, min time 213260ns, max time 212.704ms, avg time 10.42ms) WARN [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:237) log - [201.763ms] for method 'Executed on table.', observe_longline.basket (total call 246, total time 5.633s, min time 578423ns, max time 466.996ms, avg time 22.897ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:208) createReadStatement - Read sql: SELECT branchline.* FROM observe_longline.activity activity INNER JOIN observe_longline.set set ON set.topiaId = activity.set INNER JOIN observe_longline.basket basket ON basket.set = set.topiaId INNER JOIN observe_longline.branchline branchline ON branchline.basket = basket.topiaId WARN [main] (org.nuiton.topia.service.sql.batch.actions.AbstractSqlAction.TimeLog:237) log - [734.38ms] for method 'Read statement', SELECT branchline.* FROM observe_longline.activity activity INNER JOIN observe_longline.set set ON set.topiaId = activity.set INNER JOIN observe_longline.basket basket ON basket.set = set.topiaId INNER JOIN observe_longline.branchline branchline ON branchline.basket = basket.topiaId (total call 247, total time 1.235s, min time 7123ns, max time 734.38ms, avg time 4.998ms) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.ReplicateTablesAction:183) newInsertStatementSql - Insert sql: INSERT INTO observe_longline.branchline(topiaid, topiaversion, topiacreatedate, lastupdatedate, comment, settingidentifier, haulingidentifier, depthrecorder, timer, timesincecontact, hookoffset, branchlinelength, weightedswivel, timertimeonboard, weightedsnap, swivelweight, snapweight, tracelinelength, hooklost, tracecutoff, hooktype, baittype, toptype, tracelinetype, baitsettingstatus, baithaulingstatus, hooksize, basket) VALUES (%s); DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.branchline (size: 1000) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.branchline (size: 2000) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.branchline (size: 3000) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.branchline (size: 4000) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.branchline (size: 5000) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.branchline (size: 6000) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.branchline (size: 7000) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.branchline (size: 8000) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.branchline (size: 9000) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.branchline (size: 10000) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.branchline (size: 11000) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.branchline (size: 12000) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.branchline (size: 13000) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.branchline (size: 14000) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.branchline (size: 15000) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.branchline (size: 16000) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.branchline (size: 17000) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.branchline (size: 18000) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.branchline (size: 19000) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.branchline (size: 20000) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.branchline (size: 21000) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.branchline (size: 22000) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.branchline (size: 23000) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.branchline (size: 24000) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.branchline (size: 25000) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.branchline (size: 26000) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.branchline (size: 27000) DEBUG [main] (org.nuiton.topia.service.sql.batch.actions.AbstractTablesAction:97) flush - Flush for : observe_longline.branchline (size: 28000) Results : Tests run: 31, Failures: 0, Errors: 0, Skipped: 3 [JENKINS] Recording test results [JENKINS] Archiving disabled