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

Thu Oct 25 01:48:13 BST 2018

2018-10-24 02:49:54.345 UTC [32027] jenkins at reproducibledb LOG:  duration: 169629.792 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-10-23 02:47' AND r.architecture='amd64'
2018-10-24 07:44:27.694 UTC [2941] jenkins at reproducibledb LOG:  duration: 145542.182 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-10-24 07:50:19.457 UTC [2941] jenkins at reproducibledb LOG:  duration: 229525.897 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-10-24 07:51:34.500 UTC [11135] jenkins at reproducibledb LOG:  duration: 266492.282 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-10-23 07:47' AND r.architecture='amd64'
2018-10-24 09:20:55.223 UTC [51538] jenkins at reproducibledb LOG:  duration: 210402.993 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-10-23 09:17' AND r.architecture='amd64'
2018-10-24 09:35:47.255 UTC [12262] jenkins at reproducibledb LOG:  duration: 202286.834 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-10-23 09:32' AND r.architecture='amd64'
2018-10-24 09:39:12.176 UTC [32739] jenkins at reproducibledb LOG:  duration: 129974.784 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-10-24 10:57:06.714 UTC [31765] jenkins at reproducibledb LOG:  duration: 226381.127 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-10-24 11:02:22.878 UTC [31765] jenkins at reproducibledb LOG:  duration: 304065.055 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-10-24 11:05:46.575 UTC [36929] jenkins at reproducibledb LOG:  duration: 171149.896 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-10-23 11:02' AND r.architecture='amd64'
2018-10-24 12:20:45.292 UTC [38543] jenkins at reproducibledb ERROR:  duplicate key value violates unique constraint "stats_build_tmp_name_version_suite_architecture_build_date_key1"
2018-10-24 12:20:45.292 UTC [38543] jenkins at reproducibledb DETAIL:  Key (name, version, suite, architecture, build_date)=(otf-ipafont, 003.03-5, archlinux_community, x86_64, 2018-10-24 12:18) already exists.
2018-10-24 12:20:45.292 UTC [38543] jenkins at reproducibledb STATEMENT:  INSERT INTO stats_build (name, version, suite, architecture, status, build_date, build_duration, node1, node2, job) 
			VALUES ('otf-ipafont', '003.03-5', 'archlinux_community', 'x86_64', 'GOOD', '2018-10-24 12:18', '131', 'profitbricks-build3-amd64', 'profitbricks-build4-amd64', 'https://jenkins.debian.net/job/reproducible_builder_archlinux_3/53625/');
2018-10-24 12:38:21.779 UTC [3266] jenkins at reproducibledb LOG:  duration: 295657.359 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-10-23 12:33' AND r.architecture='amd64'
2018-10-24 12:41:34.510 UTC [49566] jenkins at reproducibledb LOG:  duration: 192130.637 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-10-23 12:38' AND r.architecture='i386'
2018-10-24 12:54:37.786 UTC [1809] jenkins at reproducibledb LOG:  duration: 138158.918 ms  statement: SELECT build_date FROM stats_build WHERE architecture='amd64' ORDER BY build_date ASC LIMIT 1
2018-10-24 15:30:11.209 UTC [20385] jenkins at reproducibledb LOG:  duration: 304069.118 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-10-24 15:34:22.803 UTC [65223] jenkins at reproducibledb LOG:  duration: 141309.180 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-10-24 15:38:07.907 UTC [65223] jenkins at reproducibledb LOG:  duration: 211461.062 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-10-24 15:38:17.964 UTC [7045] jenkins at reproducibledb LOG:  duration: 334167.591 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-10-23 15:32' AND r.architecture='amd64'
2018-10-24 15:39:15.328 UTC [36464] jenkins at reproducibledb LOG:  duration: 255857.789 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-10-24 20:26:09.217 UTC [57524] jenkins at reproducibledb LOG:  duration: 154693.596 ms  statement: 
2018-10-24 20:26:09.188 UTC [59575] jenkins at reproducibledb LOG:  duration: 131299.449 ms  statement: 
2018-10-24 20:26:09.189 UTC [58550] jenkins at reproducibledb LOG:  duration: 147949.130 ms  statement: 
2018-10-24 20:26:09.300 UTC [59226] jenkins at reproducibledb LOG:  duration: 141363.721 ms  statement: 
2018-10-24 20:26:09.223 UTC [58490] jenkins at reproducibledb LOG:  duration: 147873.539 ms  statement: 
2018-10-24 20:26:09.393 UTC [57245] jenkins at reproducibledb LOG:  duration: 157509.153 ms  statement: SELECT count(*) FROM sources AS s
2018-10-24 20:26:09.393 UTC [56540] jenkins at reproducibledb LOG:  duration: 158966.969 ms  statement: 
2018-10-24 20:26:09.614 UTC [59129] jenkins at reproducibledb LOG:  duration: 142639.745 ms  statement: 
2018-10-24 20:26:09.620 UTC [55541] jenkins at reproducibledb LOG:  duration: 173039.180 ms  statement: 
2018-10-24 20:26:22.824 UTC [46094] jenkins at reproducibledb LOG:  duration: 329685.617 ms  statement: SELECT COUNT(*) FROM results AS r JOIN sources AS s ON r.package_id=s.id WHERE s.suite='stretch' AND s.architecture='armhf'
2018-10-24 20:35:14.718 UTC [1725] jenkins at reproducibledb LOG:  duration: 564477.318 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-10-24 20:36:08.737 UTC [31823] jenkins at reproducibledb LOG:  duration: 433144.230 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-10-23 20:28' AND r.architecture='amd64'
2018-10-24 23:05:39.419 UTC [34332] jenkins at reproducibledb LOG:  duration: 218196.224 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-10-24 23:07:36.855 UTC [34948] jenkins at reproducibledb LOG:  duration: 333917.215 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-10-23 23:02' AND r.architecture='amd64'