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

Sat Dec 22 00:38:57 GMT 2018

2018-12-21 00:01:51.591 UTC [8756] jenkins at reproducibledb LOG:  duration: 890015.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-12-21 00:03:58.971 UTC [52293] jenkins at reproducibledb LOG:  duration: 140972.011 ms  statement: SELECT s.name, r.version, s.suite, s.architecture, r.status, r.build_date FROM results AS r JOIN sources AS s ON r.package_id = s.id WHERE status != '' AND status NOT IN ('NFU', 'E404', 'blacklisted' ) AND (( status != 'FTBFS' ) OR  ( status = 'FTBFS' and r.package_id NOT IN (SELECT n.package_id FROM NOTES AS n WHERE n.issues LIKE '%ftbfs_in_jenkins_setup%' OR n.issues LIKE '%ftbfs_build_depends_not_available_on_amd64%' OR n.issues LIKE '%ftbfs_build-indep_not_build_on_some_archs%' )))
2018-12-21 00:11:27.825 UTC [8756] jenkins at reproducibledb LOG:  duration: 294506.253 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-12-21 00:23:25.313 UTC [8756] jenkins at reproducibledb LOG:  duration: 470324.537 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-12-21 00:26:32.716 UTC [49239] jenkins at reproducibledb LOG:  duration: 1541839.473 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-12-20 00:00' AND r.architecture='amd64'
2018-12-21 00:29:52.477 UTC [24574] jenkins at reproducibledb LOG:  duration: 1041022.990 ms  statement: SELECT build_date FROM stats_build AS r WHERE ( r.node1='bbx15-armhf-rb.debian.net' OR r.node2='bbx15-armhf-rb.debian.net' )
2018-12-21 00:31:13.539 UTC [8756] jenkins at reproducibledb LOG:  duration: 293005.603 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-12-21 00:34:00.450 UTC [11953] jenkins at reproducibledb LOG:  duration: 441991.512 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-12-20 00:26' AND r.architecture='i386'
2018-12-21 00:35:43.952 UTC [28024] jenkins at reproducibledb LOG:  duration: 329351.114 ms  statement: SELECT count(build_date) FROM stats_build AS r WHERE ( r.node1='bbx15-armhf-rb.debian.net' OR r.node2='bbx15-armhf-rb.debian.net' ) AND r.build_date > '2018-12-20 00:30' 
2018-12-21 00:37:13.436 UTC [47459] jenkins at reproducibledb LOG:  duration: 143608.094 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-12-21 00:38:24.349 UTC [44399] jenkins at reproducibledb LOG:  duration: 259611.601 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-12-20 00:34' AND r.architecture='arm64'
2018-12-21 00:40:03.967 UTC [4639] jenkins at reproducibledb LOG:  duration: 1856006.382 ms  statement: COPY public.stats_build (id, name, version, suite, architecture, status, build_date, build_duration, node1, node2, job, distribution) TO stdout;
2018-12-21 00:40:21.004 UTC [52490] jenkins at reproducibledb LOG:  duration: 273379.818 ms  statement: SELECT build_date FROM stats_build AS r WHERE ( r.node1='cb3a-armhf-rb.debian.net' OR r.node2='cb3a-armhf-rb.debian.net' )
2018-12-21 00:42:11.385 UTC [63364] jenkins at reproducibledb LOG:  duration: 223499.100 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-12-20 00:38' AND r.architecture='armhf'
2018-12-21 00:43:17.334 UTC [8219] jenkins at reproducibledb LOG:  duration: 169992.749 ms  statement: SELECT count(build_date) FROM stats_build AS r WHERE ( r.node1='cb3a-armhf-rb.debian.net' OR r.node2='cb3a-armhf-rb.debian.net' ) AND r.build_date > '2018-12-20 00:40' 
2018-12-21 00:44:15.070 UTC [19942] jenkins at reproducibledb LOG:  duration: 121615.018 ms  statement: SELECT build_date FROM stats_build WHERE architecture='amd64' ORDER BY build_date ASC LIMIT 1
2018-12-21 03:34:58.374 UTC [30713] jenkins at reproducibledb LOG:  duration: 165829.122 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-12-20 03:32' AND r.architecture='amd64'
2018-12-21 03:35:07.119 UTC [30311] jenkins at reproducibledb LOG:  duration: 186046.152 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-12-21 08:04:40.019 UTC [42349] jenkins at reproducibledb LOG:  duration: 158692.209 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-12-21 08:05:48.754 UTC [47489] jenkins at reproducibledb LOG:  duration: 217719.348 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-12-20 08:02' AND r.architecture='amd64'
2018-12-21 18:14:36.582 UTC [47228] jenkins at reproducibledb LOG:  duration: 155237.491 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-12-21 18:19:02.566 UTC [42929] jenkins at reproducibledb LOG:  duration: 122127.376 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-12-20 18:17' AND r.architecture='amd64'
2018-12-21 22:20:25.778 UTC [28914] jenkins at reproducibledb ERROR:  duplicate key value violates unique constraint "stats_build_tmp_name_version_suite_architecture_build_date_key1"
2018-12-21 22:20:25.778 UTC [28914] jenkins at reproducibledb DETAIL:  Key (name, version, suite, architecture, build_date)=(portsmf, 228-3, archlinux_extra, x86_64, 2018-12-21 22:20:00) already exists.
2018-12-21 22:20:25.778 UTC [28914] jenkins at reproducibledb STATEMENT:  INSERT INTO stats_build (name, version, suite, architecture, distribution, status, build_date, build_duration, node1, node2, job) 
			VALUES ('portsmf', '228-3', 'archlinux_extra', 'x86_64', 3, '404_0', '2018-12-21 22:20', '25', 'profitbricks-build4-amd64', 'profitbricks-build3-amd64', 'https://jenkins.debian.net/job/reproducible_builder_archlinux_2/113649/');
2018-12-21 22:34:26.423 UTC [21631] jenkins at reproducibledb LOG:  duration: 145297.372 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