[Qa-jenkins-scm] postgresql-9.6-main.log found

Mon Jun 4 01:35:35 BST 2018

2018-06-03 08:34:38.571 UTC [46537] jenkins at reproducibledb LOG:  duration: 144332.498 ms  statement: SELECT schedule.date_scheduled, sources.suite, sources.architecture, sources.name, results.status, results.build_duration, (SELECT coalesce(avg(CAST(stats_build.build_duration AS INTEGER)), 0) AS coalesce_1 
2018-06-03 08:37:54.187 UTC [46537] jenkins at reproducibledb LOG:  duration: 165740.353 ms  statement: SELECT schedule.date_scheduled, sources.suite, sources.architecture, sources.name, results.status, results.build_duration, (SELECT coalesce(avg(CAST(stats_build.build_duration AS INTEGER)), 0) AS coalesce_1 
2018-06-03 08:41:13.173 UTC [46537] jenkins at reproducibledb LOG:  duration: 169236.833 ms  statement: SELECT schedule.date_scheduled, sources.suite, sources.architecture, sources.name, results.status, results.build_duration, (SELECT coalesce(avg(CAST(stats_build.build_duration AS INTEGER)), 0) AS coalesce_1 
2018-06-03 08:46:31.019 UTC [46537] jenkins at reproducibledb LOG:  duration: 285478.696 ms  statement: SELECT schedule.date_scheduled, sources.suite, sources.architecture, sources.name, results.status, results.build_duration, (SELECT coalesce(avg(CAST(stats_build.build_duration AS INTEGER)), 0) AS coalesce_1 
2018-06-03 08:47:29.143 UTC [61412] jenkins at reproducibledb LOG:  duration: 309451.574 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-06-02 08:42' AND r.architecture='amd64'
2018-06-03 09:03:19.227 UTC [38978] jenkins at reproducibledb LOG:  duration: 135264.285 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-06-02 09:01' AND r.architecture='amd64'
2018-06-03 09:34:48.059 UTC [13173] jenkins at reproducibledb LOG:  duration: 142637.127 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-06-02 09:32' AND r.architecture='amd64'
2018-06-03 09:40:00.775 UTC [2082] jenkins at reproducibledb LOG:  duration: 232317.486 ms  statement: SELECT schedule.date_scheduled, sources.suite, sources.architecture, sources.name, results.status, results.build_duration, (SELECT coalesce(avg(CAST(stats_build.build_duration AS INTEGER)), 0) AS coalesce_1 
2018-06-03 09:40:29.764 UTC [32858] jenkins at reproducibledb LOG:  duration: 341573.108 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-06-02 09:34' AND r.architecture='i386'
2018-06-03 14:06:31.908 UTC [32275] jenkins at reproducibledb LOG:  duration: 129130.752 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-06-02 14:04' AND r.architecture='amd64'
2018-06-03 16:04:42.351 UTC [44247] jenkins at reproducibledb LOG:  duration: 156658.285 ms  statement: SELECT schedule.date_scheduled, sources.suite, sources.architecture, sources.name, results.status, results.build_duration, (SELECT coalesce(avg(CAST(stats_build.build_duration AS INTEGER)), 0) AS coalesce_1 
2018-06-03 16:04:50.140 UTC [49340] jenkins at reproducibledb LOG:  duration: 143059.516 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-06-02 16:02' AND r.architecture='amd64'
2018-06-03 17:46:34.943 UTC [10122] jenkins at reproducibledb LOG:  duration: 158358.588 ms  statement: SELECT schedule.date_scheduled, sources.suite, sources.architecture, sources.name, results.status, results.build_duration, (SELECT coalesce(avg(CAST(stats_build.build_duration AS INTEGER)), 0) AS coalesce_1 
2018-06-03 17:48:48.924 UTC [10122] jenkins at reproducibledb LOG:  duration: 127922.740 ms  statement: SELECT schedule.date_scheduled, sources.suite, sources.architecture, sources.name, results.status, results.build_duration, (SELECT coalesce(avg(CAST(stats_build.build_duration AS INTEGER)), 0) AS coalesce_1 
2018-06-03 17:50:41.609 UTC [12355] jenkins at reproducibledb LOG:  duration: 216573.568 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-06-02 17:47' AND r.architecture='amd64'
2018-06-03 21:58:47.063 UTC [32436] jenkins at reproducibledb LOG:  duration: 144838.040 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-05-07 21:56' AND r.architecture='amd64'
2018-06-03 22:01:13.861 UTC [39546] jenkins at reproducibledb LOG:  duration: 144046.248 ms  statement: SELECT build_date FROM stats_build WHERE architecture='i386' ORDER BY build_date ASC LIMIT 1
2018-06-03 22:04:07.116 UTC [47893] jenkins at reproducibledb LOG:  duration: 170793.871 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-05-07 22:01' AND r.architecture='i386'
2018-06-03 22:15:10.587 UTC [49667] jenkins at reproducibledb ERROR:  insert or update on table "results" violates foreign key constraint "results_tmp_package_id_fkey1"
2018-06-03 22:15:10.587 UTC [49667] jenkins at reproducibledb DETAIL:  Key (package_id)=(381851) is not present in table "sources".
2018-06-03 22:15:10.587 UTC [49667] jenkins at reproducibledb STATEMENT:  INSERT INTO results (package_id, version, status, build_date, build_duration, node1, node2, job) VALUES ('381851', '0.27.0-1~exp1', 'unreproducible', '2018-06-03 21:22', '3145', 'codethink-sled13-arm64.debian.net', 'codethink-sled12-arm64.debian.net', 'arm64_18/7005')
2018-06-03 22:15:10.716 UTC [49750] jenkins at reproducibledb ERROR:  insert or update on table "results" violates foreign key constraint "results_tmp_package_id_fkey1"
2018-06-03 22:15:10.716 UTC [49750] jenkins at reproducibledb DETAIL:  Key (package_id)=(381851) is not present in table "sources".
2018-06-03 22:15:10.716 UTC [49750] jenkins at reproducibledb STATEMENT:  INSERT INTO results (package_id, version, status, build_date, build_duration, node1, node2, job) VALUES ('381851', '0.27.0-1~exp1', 'unreproducible', '2018-06-03 21:22', '3145', 'codethink-sled13-arm64.debian.net', 'codethink-sled12-arm64.debian.net', 'arm64_18/7005')