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

[jenkins at jenkins.debian.net]

2019-04-24 06:54:30.972 UTC [52868] jenkins at reproducibledb LOG:  duration: 148948.525 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 
2019-04-24 06:57:12.329 UTC [52868] jenkins at reproducibledb LOG:  duration: 147070.295 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 
2019-04-24 07:07:00.234 UTC [23542] jenkins at reproducibledb LOG:  duration: 198883.922 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2019-04-23 07:03' AND r.architecture='amd64'
2019-04-24 11:56:35.662 UTC [17461] jenkins at reproducibledb LOG:  duration: 273460.477 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 
2019-04-24 12:00:07.294 UTC [17461] jenkins at reproducibledb LOG:  duration: 194306.600 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 
2019-04-24 12:02:34.423 UTC [17461] jenkins at reproducibledb LOG:  duration: 135169.671 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 
2019-04-24 12:07:02.575 UTC [31489] jenkins at reproducibledb LOG:  duration: 195942.165 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2019-04-23 12:03' AND r.architecture='amd64'
2019-04-24 12:09:05.017 UTC [59750] jenkins at reproducibledb LOG:  duration: 122257.929 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2019-04-23 12:07' AND r.architecture='i386'
2019-04-24 16:00:02.717 UTC [52012] jenkins at reproducibledb LOG:  duration: 480520.730 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 
2019-04-24 16:08:53.216 UTC [52012] jenkins at reproducibledb LOG:  duration: 500612.582 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 
2019-04-24 16:10:24.476 UTC [29007] jenkins at reproducibledb LOG:  duration: 366507.003 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2019-04-23 16:04' AND r.architecture='amd64'
2019-04-24 16:13:32.576 UTC [52012] jenkins at reproducibledb LOG:  duration: 259054.881 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 
2019-04-24 16:15:19.182 UTC [19305] jenkins at reproducibledb LOG:  duration: 294520.727 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2019-04-23 16:10' AND r.architecture='i386'
2019-04-24 16:18:03.165 UTC [25272] jenkins at reproducibledb LOG:  duration: 124066.788 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 
2019-04-24 16:20:21.897 UTC [11337] jenkins at reproducibledb LOG:  duration: 302523.867 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2019-04-23 16:15' AND r.architecture='arm64'
2019-04-24 16:21:25.016 UTC [25272] jenkins at reproducibledb LOG:  duration: 186408.437 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 
2019-04-24 17:24:20.027 UTC [44404] jenkins at reproducibledb LOG:  duration: 137348.315 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 
2019-04-24 18:06:10.317 UTC [56325] jenkins at reproducibledb LOG:  duration: 152138.376 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2019-04-23 18:03' AND r.architecture='amd64'
2019-04-24 19:13:55.501 UTC [48524] jenkins at reproducibledb ERROR:  insert or update on table "results" violates foreign key constraint "results_tmp_package_id_fkey1"
2019-04-24 19:13:55.501 UTC [48524] jenkins at reproducibledb DETAIL:  Key (package_id)=(650984) is not present in table "sources".
2019-04-24 19:13:55.501 UTC [48524] jenkins at reproducibledb STATEMENT:  INSERT INTO results (package_id, version, status, build_date, build_duration, node1, node2, job) VALUES ('650984', '3.4.7+dfsg-1~exp1', 'FTBR', '2019-04-24 13:41', '19935', 'profitbricks-build1-amd64.debian.net', 'profitbricks-build15-amd64.debian.net', 'amd64_3/757') ON CONFLICT (package_id) DO UPDATE SET version='3.4.7+dfsg-1~exp1', status='FTBR', build_date='2019-04-24 13:41', build_duration='19935', node1='profitbricks-build1-amd64.debian.net', node2='profitbricks-build15-amd64.debian.net', job='amd64_3/757' WHERE results.package_id='650984'