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

jenkins at jenkins.debian.net jenkins at jenkins.debian.net
Fri Nov 9 00:36:58 GMT 2018


2018-11-08 00:07:26.473 UTC [41416] jenkins at reproducibledb LOG:  duration: 142977.331 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-11-07 00:05' AND r.architecture='i386'
2018-11-08 00:08:14.658 UTC [43731] jenkins at reproducibledb LOG:  duration: 160208.140 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-11-08 00:08:51.421 UTC [41319] jenkins at reproducibledb LOG:  duration: 213674.053 ms  statement: COPY public.stats_build (id, name, version, suite, architecture, status, build_date, build_duration, node1, node2, job) TO stdout;
2018-11-08 00:09:52.923 UTC [55187] jenkins at reproducibledb LOG:  duration: 143663.178 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-11-07 00:07' AND r.architecture='arm64'
2018-11-08 00:10:19.545 UTC [58301] jenkins at reproducibledb LOG:  duration: 123523.425 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-11-07 00:08' 
2018-11-08 00:15:32.058 UTC [11390] jenkins at reproducibledb LOG:  duration: 122869.696 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-11-02 00:13' AND r.architecture='amd64'
2018-11-08 00:16:02.951 UTC [13737] jenkins at reproducibledb LOG:  duration: 124484.024 ms  statement: SELECT build_date FROM stats_build AS r WHERE ( r.node1='cbxi4b-armhf-rb.debian.net' OR r.node2='cbxi4b-armhf-rb.debian.net' )
2018-11-08 00:17:39.696 UTC [22533] jenkins at reproducibledb LOG:  duration: 127031.918 ms  statement: SELECT build_date FROM stats_build WHERE architecture='i386' ORDER BY build_date ASC LIMIT 1
2018-11-08 00:18:28.375 UTC [27603] jenkins at reproducibledb LOG:  duration: 143269.393 ms  statement: SELECT count(build_date) FROM stats_build AS r WHERE ( r.node1='cbxi4b-armhf-rb.debian.net' OR r.node2='cbxi4b-armhf-rb.debian.net' ) AND r.build_date > '2018-11-07 00:16' 
2018-11-08 00:20:42.628 UTC [39929] jenkins at reproducibledb LOG:  duration: 179647.692 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-11-02 00:17' AND r.architecture='i386'
2018-11-08 00:21:26.849 UTC [45209] jenkins at reproducibledb LOG:  duration: 176187.610 ms  statement: SELECT build_date FROM stats_build AS r WHERE ( r.node1='cbxi4pro0-armhf-rb.debian.net' OR r.node2='cbxi4pro0-armhf-rb.debian.net' )
2018-11-08 00:23:30.965 UTC [60417] jenkins at reproducibledb LOG:  duration: 166824.405 ms  statement: SELECT build_date FROM stats_build WHERE architecture='arm64' ORDER BY build_date ASC LIMIT 1
2018-11-08 00:24:19.844 UTC [64408] jenkins at reproducibledb LOG:  duration: 169852.135 ms  statement: SELECT count(build_date) FROM stats_build AS r WHERE ( r.node1='cbxi4pro0-armhf-rb.debian.net' OR r.node2='cbxi4pro0-armhf-rb.debian.net' ) AND r.build_date > '2018-11-07 00:21' 
2018-11-08 00:26:33.635 UTC [12441] jenkins at reproducibledb LOG:  duration: 180112.276 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-11-02 00:23' AND r.architecture='arm64'
2018-11-08 00:27:29.053 UTC [16392] jenkins at reproducibledb LOG:  duration: 188622.918 ms  statement: SELECT build_date FROM stats_build AS r WHERE ( r.node1='codethink-sled9-arm64.debian.net' OR r.node2='codethink-sled9-arm64.debian.net' )
2018-11-08 00:29:49.898 UTC [27754] jenkins at reproducibledb LOG:  duration: 195327.823 ms  statement: SELECT build_date FROM stats_build WHERE architecture='armhf' ORDER BY build_date ASC LIMIT 1
2018-11-08 00:31:02.609 UTC [37596] jenkins at reproducibledb LOG:  duration: 204860.716 ms  statement: SELECT count(build_date) FROM stats_build AS r WHERE ( r.node1='codethink-sled9-arm64.debian.net' OR r.node2='codethink-sled9-arm64.debian.net' ) AND r.build_date > '2018-11-07 00:27' 
2018-11-08 00:33:56.791 UTC [54555] jenkins at reproducibledb LOG:  duration: 244497.572 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-11-02 00:29' AND r.architecture='armhf'
2018-11-08 00:35:30.006 UTC [59538] jenkins at reproducibledb LOG:  duration: 262613.219 ms  statement: SELECT build_date FROM stats_build AS r WHERE ( r.node1='codethink-sled10-arm64.debian.net' OR r.node2='codethink-sled10-arm64.debian.net' )
2018-11-08 00:36:05.978 UTC [62567] jenkins at reproducibledb LOG:  duration: 225289.916 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-11-08 00:39:03.681 UTC [2584] jenkins at reproducibledb LOG:  duration: 305743.513 ms  statement: SELECT build_date FROM stats_build WHERE architecture='amd64' ORDER BY build_date ASC LIMIT 1
2018-11-08 00:39:23.333 UTC [62567] jenkins at reproducibledb LOG:  duration: 124578.993 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-11-08 00:40:48.573 UTC [7377] jenkins at reproducibledb LOG:  duration: 300979.707 ms  statement: SELECT count(build_date) FROM stats_build AS r WHERE ( r.node1='codethink-sled10-arm64.debian.net' OR r.node2='codethink-sled10-arm64.debian.net' ) AND r.build_date > '2018-11-07 00:35' 
2018-11-08 00:43:55.681 UTC [21255] jenkins at reproducibledb LOG:  duration: 288046.802 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-10-12 00:39' AND r.architecture='amd64'
2018-11-08 00:45:12.723 UTC [27195] jenkins at reproducibledb LOG:  duration: 261194.963 ms  statement: SELECT build_date FROM stats_build AS r WHERE ( r.node1='codethink-sled11-arm64.debian.net' OR r.node2='codethink-sled11-arm64.debian.net' )
2018-11-08 00:48:57.359 UTC [38973] jenkins at reproducibledb LOG:  duration: 301137.998 ms  statement: SELECT build_date FROM stats_build WHERE architecture='i386' ORDER BY build_date ASC LIMIT 1
2018-11-08 00:51:03.583 UTC [46246] jenkins at reproducibledb LOG:  duration: 323597.933 ms  statement: SELECT count(build_date) FROM stats_build AS r WHERE ( r.node1='codethink-sled11-arm64.debian.net' OR r.node2='codethink-sled11-arm64.debian.net' ) AND r.build_date > '2018-11-07 00:45' 
2018-11-08 00:54:03.565 UTC [60423] jenkins at reproducibledb LOG:  duration: 259012.151 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-11-08 00:54:21.512 UTC [58281] jenkins at reproducibledb LOG:  duration: 321398.608 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-10-12 00:48' AND r.architecture='i386'
2018-11-08 00:57:05.112 UTC [1648] jenkins at reproducibledb LOG:  duration: 358910.041 ms  statement: SELECT build_date FROM stats_build AS r WHERE ( r.node1='codethink-sled12-arm64.debian.net' OR r.node2='codethink-sled12-arm64.debian.net' )
2018-11-08 00:58:45.566 UTC [60423] jenkins at reproducibledb LOG:  duration: 138831.203 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-11-08 01:00:52.837 UTC [16421] jenkins at reproducibledb LOG:  duration: 389220.258 ms  statement: SELECT build_date FROM stats_build WHERE architecture='arm64' ORDER BY build_date ASC LIMIT 1
2018-11-08 01:03:14.376 UTC [60423] jenkins at reproducibledb LOG:  duration: 200161.011 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-11-08 01:04:53.822 UTC [24985] jenkins at reproducibledb LOG:  duration: 443859.041 ms  statement: SELECT count(build_date) FROM stats_build AS r WHERE ( r.node1='codethink-sled12-arm64.debian.net' OR r.node2='codethink-sled12-arm64.debian.net' ) AND r.build_date > '2018-11-07 00:57' 
2018-11-08 01:09:35.130 UTC [33960] jenkins at reproducibledb LOG:  duration: 520651.667 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-10-12 01:00' AND r.architecture='arm64'
2018-11-08 01:09:41.220 UTC [60423] jenkins at reproducibledb LOG:  duration: 216268.530 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-11-08 01:12:14.655 UTC [49212] jenkins at reproducibledb LOG:  duration: 438704.894 ms  statement: SELECT build_date FROM stats_build AS r WHERE ( r.node1='codethink-sled13-arm64.debian.net' OR r.node2='codethink-sled13-arm64.debian.net' )
2018-11-08 01:14:50.341 UTC [63937] jenkins at reproducibledb LOG:  duration: 313455.180 ms  statement: SELECT build_date FROM stats_build WHERE architecture='armhf' ORDER BY build_date ASC LIMIT 1
2018-11-08 01:15:14.482 UTC [9454] jenkins at reproducibledb LOG:  duration: 187378.145 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-11-08 01:16:39.523 UTC [11677] jenkins at reproducibledb LOG:  duration: 247301.989 ms  statement: SELECT count(build_date) FROM stats_build AS r WHERE ( r.node1='codethink-sled13-arm64.debian.net' OR r.node2='codethink-sled13-arm64.debian.net' ) AND r.build_date > '2018-11-07 01:12' 
2018-11-08 01:18:41.954 UTC [28617] jenkins at reproducibledb LOG:  duration: 229706.008 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-10-12 01:14' AND r.architecture='armhf'
2018-11-08 01:21:56.480 UTC [39465] jenkins at reproducibledb LOG:  duration: 315901.151 ms  statement: SELECT build_date FROM stats_build AS r WHERE ( r.node1='codethink-sled14-arm64.debian.net' OR r.node2='codethink-sled14-arm64.debian.net' )
2018-11-08 01:24:04.761 UTC [9454] jenkins at reproducibledb LOG:  duration: 199431.962 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-11-08 01:25:30.959 UTC [51917] jenkins at reproducibledb LOG:  duration: 406878.942 ms  statement: SELECT build_date FROM stats_build WHERE architecture='amd64' ORDER BY build_date ASC LIMIT 1
2018-11-08 01:29:59.166 UTC [63749] jenkins at reproducibledb LOG:  duration: 449518.026 ms  statement: SELECT count(build_date) FROM stats_build AS r WHERE ( r.node1='codethink-sled14-arm64.debian.net' OR r.node2='codethink-sled14-arm64.debian.net' ) AND r.build_date > '2018-11-07 01:22' 
2018-11-08 01:31:49.761 UTC [18161] jenkins at reproducibledb LOG:  duration: 140183.755 ms  statement: SELECT s.name FROM sources AS s
2018-11-08 01:35:47.968 UTC [4660] jenkins at reproducibledb LOG:  duration: 615270.975 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-08-10 01:25' AND r.architecture='amd64'
2018-11-08 01:36:56.575 UTC [11965] jenkins at reproducibledb LOG:  duration: 579864.225 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-11-08 01:39:14.953 UTC [9094] jenkins at reproducibledb ERROR:  duplicate key value violates unique constraint "removed_packages_pkey"
2018-11-08 01:39:14.953 UTC [9094] jenkins at reproducibledb DETAIL:  Key (name, suite, architecture)=(llvm-toolchain-7, experimental, amd64) already exists.
2018-11-08 01:39:14.953 UTC [9094] jenkins at reproducibledb STATEMENT:  INSERT INTO removed_packages (name, suite, architecture) VALUES ('llvm-toolchain-7', 'experimental', 'amd64')
2018-11-08 01:41:16.024 UTC [19701] jenkins at reproducibledb LOG:  duration: 671110.530 ms  statement: SELECT build_date FROM stats_build AS r WHERE ( r.node1='codethink-sled15-arm64.debian.net' OR r.node2='codethink-sled15-arm64.debian.net' )
2018-11-08 01:43:33.138 UTC [44491] jenkins at reproducibledb LOG:  duration: 138129.631 ms  statement: SELECT s.name FROM sources AS s
2018-11-08 01:46:50.474 UTC [11965] jenkins at reproducibledb LOG:  duration: 273816.796 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-11-08 01:47:21.024 UTC [30574] jenkins at reproducibledb LOG:  duration: 688035.961 ms  statement: SELECT build_date FROM stats_build WHERE architecture='i386' ORDER BY build_date ASC LIMIT 1
2018-11-08 01:51:20.967 UTC [45515] jenkins at reproducibledb LOG:  duration: 570895.606 ms  statement: SELECT count(build_date) FROM stats_build AS r WHERE ( r.node1='codethink-sled15-arm64.debian.net' OR r.node2='codethink-sled15-arm64.debian.net' ) AND r.build_date > '2018-11-07 01:41' 
2018-11-08 01:51:49.347 UTC [11965] jenkins at reproducibledb LOG:  duration: 193431.942 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-11-08 01:55:07.822 UTC [56404] jenkins at reproducibledb LOG:  duration: 463252.987 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-08-10 01:47' AND r.architecture='i386'
2018-11-08 01:56:30.681 UTC [11965] jenkins at reproducibledb LOG:  duration: 148629.268 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-11-08 02:00:03.085 UTC [5865] jenkins at reproducibledb LOG:  duration: 520702.021 ms  statement: SELECT build_date FROM stats_build AS r WHERE ( r.node1='codethink-sled16-arm64.debian.net' OR r.node2='codethink-sled16-arm64.debian.net' )
2018-11-08 02:04:14.199 UTC [32905] jenkins at reproducibledb LOG:  duration: 153883.326 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-11-08 02:08:09.676 UTC [18890] jenkins at reproducibledb LOG:  duration: 780505.846 ms  statement: SELECT build_date FROM stats_build WHERE architecture='arm64' ORDER BY build_date ASC LIMIT 1
2018-11-08 02:17:15.750 UTC [33607] jenkins at reproducibledb LOG:  duration: 899926.493 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-11-08 02:18:42.208 UTC [59329] jenkins at reproducibledb LOG:  duration: 173062.136 ms  statement: SELECT count(s.name) FROM sources AS s WHERE s.architecture='x86_64' AND s.suite='archlinux_community' AND s.id NOT IN (SELECT package_id FROM results)
2018-11-08 02:20:04.938 UTC [31544] jenkins at reproducibledb LOG:  duration: 1163765.493 ms  statement: SELECT count(build_date) FROM stats_build AS r WHERE ( r.node1='codethink-sled16-arm64.debian.net' OR r.node2='codethink-sled16-arm64.debian.net' ) AND r.build_date > '2018-11-07 02:00' 
2018-11-08 02:25:50.052 UTC [43832] jenkins at reproducibledb LOG:  duration: 1054978.150 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-08-10 02:08' AND r.architecture='arm64'
2018-11-08 02:31:13.450 UTC [33607] jenkins at reproducibledb LOG:  duration: 384758.716 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-11-08 02:36:18.324 UTC [3916] jenkins at reproducibledb LOG:  duration: 961175.727 ms  statement: SELECT build_date FROM stats_build AS r WHERE ( r.node1='ff2a-armhf-rb.debian.net' OR r.node2='ff2a-armhf-rb.debian.net' )
2018-11-08 02:38:08.110 UTC [33607] jenkins at reproducibledb LOG:  duration: 196460.590 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-11-08 02:39:00.660 UTC [22054] jenkins at reproducibledb LOG:  duration: 786923.938 ms  statement: SELECT build_date FROM stats_build WHERE architecture='armhf' ORDER BY build_date ASC LIMIT 1
2018-11-08 02:53:50.513 UTC [50214] jenkins at reproducibledb LOG:  duration: 1044099.877 ms  statement: SELECT count(build_date) FROM stats_build AS r WHERE ( r.node1='ff2a-armhf-rb.debian.net' OR r.node2='ff2a-armhf-rb.debian.net' ) AND r.build_date > '2018-11-07 02:36' 
2018-11-08 02:54:31.024 UTC [33607] jenkins at reproducibledb LOG:  duration: 626156.032 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-11-08 03:00:34.460 UTC [62200] jenkins at reproducibledb LOG:  duration: 1287256.745 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-08-10 02:39' AND r.architecture='armhf'
2018-11-08 03:19:59.392 UTC [24936] jenkins at reproducibledb LOG:  duration: 1561592.056 ms  statement: SELECT build_date FROM stats_build AS r WHERE ( r.node1='ff2b-armhf-rb.debian.net' OR r.node2='ff2b-armhf-rb.debian.net' )
2018-11-08 03:24:13.989 UTC [45397] jenkins at reproducibledb LOG:  duration: 1137745.585 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-11-08 03:24:16.591 UTC [19023] jenkins at reproducibledb LOG:  duration: 147576.173 ms  statement: SELECT s.name FROM sources AS s
2018-11-08 03:35:25.479 UTC [45397] jenkins at reproducibledb LOG:  duration: 413852.420 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-11-08 03:43:20.504 UTC [16713] jenkins at reproducibledb LOG:  duration: 1364462.888 ms  statement: SELECT count(build_date) FROM stats_build AS r WHERE ( r.node1='ff2b-armhf-rb.debian.net' OR r.node2='ff2b-armhf-rb.debian.net' ) AND r.build_date > '2018-11-07 03:20' 
2018-11-08 03:45:38.236 UTC [45397] jenkins at reproducibledb LOG:  duration: 511002.849 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-11-08 03:53:23.818 UTC [60852] jenkins at reproducibledb LOG:  duration: 154283.020 ms  statement: SELECT s.name FROM sources AS s
2018-11-08 04:00:36.414 UTC [45397] jenkins at reproducibledb LOG:  duration: 458696.166 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-11-08 04:09:59.021 UTC [54848] jenkins at reproducibledb LOG:  duration: 1583816.145 ms  statement: SELECT build_date FROM stats_build AS r WHERE ( r.node1='ff4a-armhf-rb.debian.net' OR r.node2='ff4a-armhf-rb.debian.net' )
2018-11-08 04:24:42.161 UTC [50023] jenkins at reproducibledb LOG:  duration: 134143.376 ms  statement: SELECT s.name FROM sources AS s
2018-11-08 04:28:34.132 UTC [26059] jenkins at reproducibledb LOG:  duration: 1020838.610 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-11-08 04:33:18.438 UTC [64544] jenkins at reproducibledb LOG:  duration: 154234.946 ms  statement: SELECT count(s.name) FROM sources AS s WHERE s.architecture='x86_64' AND s.suite='archlinux_core' AND s.id NOT IN (SELECT package_id FROM results)
2018-11-08 04:35:12.118 UTC [25217] jenkins at reproducibledb LOG:  duration: 1492537.055 ms  statement: SELECT count(build_date) FROM stats_build AS r WHERE ( r.node1='ff4a-armhf-rb.debian.net' OR r.node2='ff4a-armhf-rb.debian.net' ) AND r.build_date > '2018-11-07 04:10' 
2018-11-08 04:37:20.494 UTC [8048] jenkins at reproducibledb ERROR:  duplicate key value violates unique constraint "stats_build_tmp_name_version_suite_architecture_build_date_key1"
2018-11-08 04:37:20.494 UTC [8048] jenkins at reproducibledb DETAIL:  Key (name, version, suite, architecture, build_date)=(lib32-libidn11, 1.33-1, archlinux_multilib, x86_64, 2018-11-08 04:31) already exists.
2018-11-08 04:37:20.494 UTC [8048] jenkins at reproducibledb STATEMENT:  INSERT INTO stats_build (name, version, suite, architecture, status, build_date, build_duration, node1, node2, job) 
			VALUES ('lib32-libidn11', '1.33-1', 'archlinux_multilib', 'x86_64', 'GOOD', '2018-11-08 04:31', '332', 'profitbricks-build3-amd64', 'profitbricks-build4-amd64', 'https://jenkins.debian.net/job/reproducible_builder_archlinux_2/103756/');
2018-11-08 04:38:15.048 UTC [5960] jenkins at reproducibledb LOG:  duration: 163208.759 ms  statement: SELECT count(s.name) FROM sources AS s WHERE s.architecture='x86_64' AND s.suite='archlinux_extra' AND s.id NOT IN (SELECT package_id FROM results)
2018-11-08 04:41:02.653 UTC [26059] jenkins at reproducibledb LOG:  duration: 401332.321 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-11-08 04:49:17.072 UTC [26059] jenkins at reproducibledb LOG:  duration: 404282.900 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-11-08 04:58:30.342 UTC [5832] jenkins at reproducibledb LOG:  duration: 1382733.928 ms  statement: SELECT build_date FROM stats_build AS r WHERE ( r.node1='jtk1a-armhf-rb.debian.net' OR r.node2='jtk1a-armhf-rb.debian.net' )
2018-11-08 05:05:13.271 UTC [26059] jenkins at reproducibledb LOG:  duration: 666451.663 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-11-08 05:24:56.028 UTC [43289] jenkins at reproducibledb LOG:  duration: 1554467.401 ms  statement: SELECT count(build_date) FROM stats_build AS r WHERE ( r.node1='jtk1a-armhf-rb.debian.net' OR r.node2='jtk1a-armhf-rb.debian.net' ) AND r.build_date > '2018-11-07 04:58' 
2018-11-08 05:34:01.865 UTC [2079] jenkins at reproducibledb LOG:  duration: 1221029.675 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-11-08 05:47:14.630 UTC [2079] jenkins at reproducibledb LOG:  duration: 275900.301 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-11-08 05:50:28.090 UTC [9757] jenkins at reproducibledb LOG:  duration: 178201.807 ms  statement: SELECT s.name FROM sources AS s
2018-11-08 05:51:28.376 UTC [22727] jenkins at reproducibledb LOG:  duration: 1589160.551 ms  statement: SELECT build_date FROM stats_build AS r WHERE ( r.node1='jtx1a-armhf-rb.debian.net' OR r.node2='jtx1a-armhf-rb.debian.net' )
2018-11-08 06:03:53.837 UTC [2079] jenkins at reproducibledb LOG:  duration: 588561.732 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-11-08 06:08:04.712 UTC [36921] jenkins at reproducibledb LOG:  duration: 143559.090 ms  statement: SELECT count(s.name) FROM sources AS s
2018-11-08 06:17:25.671 UTC [2079] jenkins at reproducibledb LOG:  duration: 520043.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-11-08 06:18:37.578 UTC [17548] jenkins at reproducibledb LOG:  duration: 1617865.460 ms  statement: SELECT count(build_date) FROM stats_build AS r WHERE ( r.node1='jtx1a-armhf-rb.debian.net' OR r.node2='jtx1a-armhf-rb.debian.net' ) AND r.build_date > '2018-11-07 05:51' 
2018-11-08 06:32:02.014 UTC [17008] jenkins at reproducibledb LOG:  duration: 168734.492 ms  statement: SELECT count(s.name) FROM sources AS s
2018-11-08 06:34:10.116 UTC [23465] jenkins at reproducibledb LOG:  duration: 133742.870 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-11-08 06:44:03.177 UTC [63298] jenkins at reproducibledb LOG:  duration: 1516077.791 ms  statement: SELECT build_date FROM stats_build AS r WHERE ( r.node1='jtx1b-armhf-rb.debian.net' OR r.node2='jtx1b-armhf-rb.debian.net' )
2018-11-08 06:45:57.974 UTC [22885] jenkins at reproducibledb ERROR:  duplicate key value violates unique constraint "removed_packages_pkey"
2018-11-08 06:45:57.974 UTC [22885] jenkins at reproducibledb DETAIL:  Key (name, suite, architecture)=(llvm-toolchain-7, experimental, amd64) already exists.
2018-11-08 06:45:57.974 UTC [22885] jenkins at reproducibledb STATEMENT:  INSERT INTO removed_packages (name, suite, architecture) VALUES ('llvm-toolchain-7', 'experimental', 'amd64')
2018-11-08 06:46:21.821 UTC [22215] jenkins at reproducibledb LOG:  duration: 897694.471 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-11-08 06:52:27.625 UTC [59252] jenkins at reproducibledb LOG:  duration: 132445.862 ms  statement: SELECT count(s.name) FROM sources AS s
2018-11-08 06:58:14.349 UTC [22215] jenkins at reproducibledb LOG:  duration: 437006.743 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-11-08 07:08:16.962 UTC [45514] jenkins at reproducibledb LOG:  duration: 1444394.755 ms  statement: SELECT count(build_date) FROM stats_build AS r WHERE ( r.node1='jtx1b-armhf-rb.debian.net' OR r.node2='jtx1b-armhf-rb.debian.net' ) AND r.build_date > '2018-11-07 06:44' 
2018-11-08 07:09:27.764 UTC [12702] jenkins at reproducibledb LOG:  duration: 146379.956 ms  statement: SELECT count(s.name) FROM sources AS s WHERE s.architecture='x86_64' AND s.suite='archlinux_extra' AND s.id NOT IN (SELECT package_id FROM results)
2018-11-08 07:13:21.456 UTC [22215] jenkins at reproducibledb LOG:  duration: 598533.264 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-11-08 07:18:42.936 UTC [22215] jenkins at reproducibledb LOG:  duration: 223364.676 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-11-08 07:30:00.349 UTC [14182] jenkins at reproducibledb LOG:  duration: 1296225.675 ms  statement: SELECT build_date FROM stats_build AS r WHERE ( r.node1='jtx1c-armhf-rb.debian.net' OR r.node2='jtx1c-armhf-rb.debian.net' )
2018-11-08 07:51:44.235 UTC [48757] jenkins at reproducibledb LOG:  duration: 1377429.763 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-11-08 07:59:22.366 UTC [51502] jenkins at reproducibledb LOG:  duration: 1732583.236 ms  statement: SELECT count(build_date) FROM stats_build AS r WHERE ( r.node1='jtx1c-armhf-rb.debian.net' OR r.node2='jtx1c-armhf-rb.debian.net' ) AND r.build_date > '2018-11-07 07:30' 
2018-11-08 08:06:46.341 UTC [48757] jenkins at reproducibledb LOG:  duration: 463264.181 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-11-08 08:10:22.207 UTC [30035] jenkins at reproducibledb ERROR:  duplicate key value violates unique constraint "stats_build_tmp_name_version_suite_architecture_build_date_key1"
2018-11-08 08:10:22.207 UTC [30035] jenkins at reproducibledb DETAIL:  Key (name, version, suite, architecture, build_date)=(perl-io-socket-ssl, 2.060-1, archlinux_extra, x86_64, 2018-11-08 08:05) already exists.
2018-11-08 08:10:22.207 UTC [30035] jenkins at reproducibledb STATEMENT:  INSERT INTO stats_build (name, version, suite, architecture, status, build_date, build_duration, node1, node2, job) 
			VALUES ('perl-io-socket-ssl', '2.060-1', 'archlinux_extra', 'x86_64', 'GOOD', '2018-11-08 08:05', '264', 'profitbricks-build4-amd64', 'profitbricks-build3-amd64', 'https://jenkins.debian.net/job/reproducible_builder_archlinux_1/102926/');
2018-11-08 08:22:32.790 UTC [48757] jenkins at reproducibledb LOG:  duration: 508139.741 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-11-08 08:28:38.658 UTC [3389] jenkins at reproducibledb LOG:  duration: 181990.153 ms  statement: SELECT count(s.name) FROM sources AS s
2018-11-08 08:29:03.308 UTC [18223] jenkins at reproducibledb LOG:  duration: 1768867.877 ms  statement: SELECT build_date FROM stats_build AS r WHERE ( r.node1='odu3a-armhf-rb.debian.net' OR r.node2='odu3a-armhf-rb.debian.net' )
2018-11-08 08:31:17.191 UTC [9923] jenkins at reproducibledb LOG:  duration: 132807.331 ms  statement: SELECT s.name FROM sources AS s
2018-11-08 08:35:31.764 UTC [14652] jenkins at reproducibledb LOG:  duration: 225747.974 ms  statement: SELECT s.name FROM sources AS s
2018-11-08 08:36:47.793 UTC [48757] jenkins at reproducibledb LOG:  duration: 597796.363 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-11-08 08:45:46.158 UTC [35890] jenkins at reproducibledb LOG:  duration: 155599.264 ms  statement: SELECT count(s.name) FROM sources AS s
2018-11-08 08:49:19.128 UTC [38820] jenkins at reproducibledb LOG:  duration: 151838.836 ms  statement: SELECT s.name FROM sources AS s
2018-11-08 08:53:12.183 UTC [57705] jenkins at reproducibledb LOG:  duration: 382655.870 ms  statement: SELECT s.name, r.version, s.suite, s.architecture
2018-11-08 08:56:04.627 UTC [10585] jenkins at reproducibledb LOG:  duration: 1602075.713 ms  statement: SELECT count(build_date) FROM stats_build AS r WHERE ( r.node1='odu3a-armhf-rb.debian.net' OR r.node2='odu3a-armhf-rb.debian.net' ) AND r.build_date > '2018-11-07 08:29' 
2018-11-08 09:05:22.199 UTC [36746] jenkins at reproducibledb LOG:  duration: 1263731.863 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-11-08 09:06:33.664 UTC [3819] jenkins at reproducibledb LOG:  duration: 164603.805 ms  statement: SELECT count(s.name) FROM sources AS s
2018-11-08 09:10:06.952 UTC [8856] jenkins at reproducibledb LOG:  duration: 171411.375 ms  statement: SELECT s.name FROM sources AS s
2018-11-08 09:15:38.312 UTC [36746] jenkins at reproducibledb LOG:  duration: 277105.797 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-11-08 09:15:41.462 UTC [22700] jenkins at reproducibledb LOG:  duration: 158119.586 ms  statement: SELECT count(s.name) FROM sources AS s
2018-11-08 09:21:09.217 UTC [54432] jenkins at reproducibledb LOG:  duration: 1500422.487 ms  statement: SELECT build_date FROM stats_build AS r WHERE ( r.node1='odxu4a-armhf-rb.debian.net' OR r.node2='odxu4a-armhf-rb.debian.net' )
2018-11-08 09:28:05.579 UTC [57705] jenkins at reproducibledb LOG:  duration: 247539.613 ms  statement: SELECT s.name, r.version, s.suite, s.architecture
2018-11-08 09:28:36.755 UTC [36746] jenkins at reproducibledb LOG:  duration: 445420.120 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-11-08 09:38:11.567 UTC [36746] jenkins at reproducibledb LOG:  duration: 514619.183 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-11-08 09:43:46.360 UTC [34646] jenkins at reproducibledb LOG:  duration: 1326800.516 ms  statement: SELECT count(build_date) FROM stats_build AS r WHERE ( r.node1='odxu4a-armhf-rb.debian.net' OR r.node2='odxu4a-armhf-rb.debian.net' ) AND r.build_date > '2018-11-07 09:21' 
2018-11-08 09:54:42.541 UTC [10666] jenkins at reproducibledb LOG:  duration: 166677.131 ms  statement: SELECT count(s.name) FROM sources AS s WHERE s.architecture='x86_64' AND s.suite='archlinux_core' AND s.id NOT IN (SELECT package_id FROM results)
2018-11-08 10:00:59.150 UTC [18119] jenkins at reproducibledb LOG:  duration: 186148.098 ms  statement: SELECT count(s.name) FROM sources AS s WHERE s.architecture='x86_64' AND s.suite='archlinux_multilib' AND s.id NOT IN (SELECT package_id FROM results)
2018-11-08 10:06:53.692 UTC [7842] jenkins at reproducibledb LOG:  duration: 1081610.960 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-11-08 10:09:20.851 UTC [4135] jenkins at reproducibledb LOG:  duration: 1530580.365 ms  statement: SELECT build_date FROM stats_build AS r WHERE ( r.node1='odxu4b-armhf-rb.debian.net' OR r.node2='odxu4b-armhf-rb.debian.net' )
2018-11-08 10:14:46.417 UTC [59962] jenkins at reproducibledb ERROR:  duplicate key value violates unique constraint "removed_packages_pkey"
2018-11-08 10:14:46.417 UTC [59962] jenkins at reproducibledb DETAIL:  Key (name, suite, architecture)=(llvm-toolchain-7, experimental, amd64) already exists.
2018-11-08 10:14:46.417 UTC [59962] jenkins at reproducibledb STATEMENT:  INSERT INTO removed_packages (name, suite, architecture) VALUES ('llvm-toolchain-7', 'experimental', 'amd64')
2018-11-08 10:17:08.894 UTC [7842] jenkins at reproducibledb LOG:  duration: 230157.995 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-11-08 10:29:40.119 UTC [7842] jenkins at reproducibledb LOG:  duration: 451378.965 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-11-08 10:31:07.463 UTC [30632] jenkins at reproducibledb LOG:  duration: 1285189.524 ms  statement: SELECT count(build_date) FROM stats_build AS r WHERE ( r.node1='odxu4b-armhf-rb.debian.net' OR r.node2='odxu4b-armhf-rb.debian.net' ) AND r.build_date > '2018-11-07 10:09' 
2018-11-08 10:34:23.737 UTC [7842] jenkins at reproducibledb LOG:  duration: 174713.238 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-11-08 10:36:25.699 UTC [10671] jenkins at reproducibledb LOG:  could not send data to client: Broken pipe
2018-11-08 10:36:25.699 UTC [10671] jenkins at reproducibledb STATEMENT:  SELECT build_date FROM stats_build AS r WHERE ( r.node1='odxu4c-armhf-rb.debian.net' OR r.node2='odxu4c-armhf-rb.debian.net' )
2018-11-08 10:36:25.702 UTC [10671] jenkins at reproducibledb FATAL:  connection to client lost
2018-11-08 10:36:25.702 UTC [10671] jenkins at reproducibledb STATEMENT:  SELECT build_date FROM stats_build AS r WHERE ( r.node1='odxu4c-armhf-rb.debian.net' OR r.node2='odxu4c-armhf-rb.debian.net' )
2018-11-08 10:36:27.743 UTC [43557] jenkins at reproducibledb LOG:  unexpected EOF on client connection with an open transaction
2018-11-08 10:36:28.474 UTC [57705] jenkins at reproducibledb LOG:  unexpected EOF on client connection with an open transaction
2018-11-08 10:36:28.525 UTC [50341] jenkins at reproducibledb LOG:  unexpected EOF on client connection with an open transaction
2018-11-08 10:36:28.645 UTC [29212] jenkins at reproducibledb LOG:  unexpected EOF on client connection with an open transaction
2018-11-08 10:36:33.451 UTC [21314] jenkins at reproducibledb LOG:  could not receive data from client: Connection reset by peer
2018-11-08 10:36:33.451 UTC [21314] jenkins at reproducibledb LOG:  unexpected EOF on client connection with an open transaction
2018-11-08 10:36:34.714 UTC [23465] jenkins at reproducibledb LOG:  unexpected EOF on client connection with an open transaction
2018-11-08 10:36:40.574 UTC [905] LOG:  received fast shutdown request
2018-11-08 10:36:40.575 UTC [905] LOG:  aborting any active transactions
2018-11-08 10:36:40.577 UTC [1163] LOG:  autovacuum launcher shutting down
2018-11-08 10:36:41.170 UTC [1160] LOG:  shutting down
2018-11-08 10:37:22.204 UTC [905] LOG:  database system is shut down
2018-11-08 10:40:45.191 UTC [974] LOG:  database system was shut down at 2018-11-08 10:36:43 UTC
2018-11-08 10:40:45.191 UTC [975] [unknown]@[unknown] LOG:  incomplete startup packet
2018-11-08 10:40:45.768 UTC [1008] postgres at postgres FATAL:  the database system is starting up
2018-11-08 10:40:45.875 UTC [974] LOG:  MultiXact member wraparound protections are now enabled
2018-11-08 10:40:45.945 UTC [1021] LOG:  autovacuum launcher started
2018-11-08 10:40:45.947 UTC [886] LOG:  database system is ready to accept connections
2018-11-08 10:48:09.028 UTC [23612] jenkins at reproducibledb LOG:  duration: 302594.791 ms  statement: COPY public.stats_build (id, name, version, suite, architecture, status, build_date, build_duration, node1, node2, job) TO stdout;
2018-11-08 10:49:39.838 UTC [24091] jenkins at reproducibledb LOG:  duration: 409136.145 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-11-08 10:53:09.143 UTC [13353] jenkins at reproducibledb LOG:  duration: 137747.672 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-11-07 10:50' AND r.architecture='amd64'
2018-11-08 10:54:31.285 UTC [24091] jenkins at reproducibledb LOG:  duration: 172839.817 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-11-08 10:57:52.378 UTC [22580] jenkins at reproducibledb LOG:  duration: 282240.030 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-11-07 10:53' AND r.architecture='i386'
2018-11-08 10:58:17.275 UTC [24091] jenkins at reproducibledb LOG:  duration: 150272.414 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-11-08 11:00:24.611 UTC [35862] jenkins at reproducibledb LOG:  duration: 150865.471 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-11-07 10:57' AND r.architecture='arm64'
2018-11-08 11:04:38.765 UTC [17417] jenkins at reproducibledb LOG:  duration: 137961.366 ms  statement: SELECT build_date FROM stats_build WHERE architecture='amd64' ORDER BY build_date ASC LIMIT 1
2018-11-08 11:07:06.308 UTC [33968] jenkins at reproducibledb LOG:  duration: 146819.852 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-11-02 11:04' AND r.architecture='amd64'
2018-11-08 11:09:31.860 UTC [57419] jenkins at reproducibledb LOG:  duration: 145049.042 ms  statement: SELECT build_date FROM stats_build WHERE architecture='i386' ORDER BY build_date ASC LIMIT 1
2018-11-08 11:12:33.487 UTC [14362] jenkins at reproducibledb LOG:  duration: 180977.753 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-11-02 11:09' AND r.architecture='i386'
2018-11-08 11:14:18.540 UTC [38129] jenkins at reproducibledb LOG:  duration: 126128.707 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-11-08 11:15:51.104 UTC [42591] jenkins at reproducibledb LOG:  duration: 194404.753 ms  statement: SELECT build_date FROM stats_build WHERE architecture='arm64' ORDER BY build_date ASC LIMIT 1
2018-11-08 11:18:42.419 UTC [65398] jenkins at reproducibledb LOG:  duration: 168683.886 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-11-02 11:15' AND r.architecture='arm64'
2018-11-08 11:21:37.352 UTC [18862] jenkins at reproducibledb LOG:  duration: 172504.464 ms  statement: SELECT build_date FROM stats_build WHERE architecture='armhf' ORDER BY build_date ASC LIMIT 1
2018-11-08 11:24:16.582 UTC [32106] jenkins at reproducibledb LOG:  duration: 156511.447 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-11-02 11:21' AND r.architecture='armhf'
2018-11-08 11:27:01.072 UTC [46268] jenkins at reproducibledb LOG:  duration: 163966.188 ms  statement: SELECT build_date FROM stats_build WHERE architecture='amd64' ORDER BY build_date ASC LIMIT 1
2018-11-08 11:30:07.961 UTC [58924] jenkins at reproducibledb LOG:  duration: 185646.233 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-10-12 11:27' AND r.architecture='amd64'
2018-11-08 11:32:25.061 UTC [7665] jenkins at reproducibledb LOG:  duration: 135984.458 ms  statement: SELECT build_date FROM stats_build WHERE architecture='i386' ORDER BY build_date ASC LIMIT 1
2018-11-08 11:35:30.780 UTC [24166] jenkins at reproducibledb LOG:  duration: 184709.884 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-10-12 11:32' AND r.architecture='i386'
2018-11-08 11:38:28.255 UTC [37763] jenkins at reproducibledb LOG:  duration: 176234.477 ms  statement: SELECT build_date FROM stats_build WHERE architecture='arm64' ORDER BY build_date ASC LIMIT 1
2018-11-08 11:41:09.185 UTC [55123] jenkins at reproducibledb LOG:  duration: 160231.780 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-10-12 11:38' AND r.architecture='arm64'
2018-11-08 11:43:58.194 UTC [7451] jenkins at reproducibledb LOG:  duration: 168331.762 ms  statement: SELECT build_date FROM stats_build WHERE architecture='armhf' ORDER BY build_date ASC LIMIT 1
2018-11-08 11:47:03.651 UTC [21592] jenkins at reproducibledb LOG:  duration: 182111.805 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-10-12 11:43' AND r.architecture='armhf'
2018-11-08 11:50:24.860 UTC [43455] jenkins at reproducibledb LOG:  duration: 198092.691 ms  statement: SELECT build_date FROM stats_build WHERE architecture='amd64' ORDER BY build_date ASC LIMIT 1
2018-11-08 11:53:54.934 UTC [59448] jenkins at reproducibledb LOG:  duration: 209409.538 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-08-10 11:50' AND r.architecture='amd64'
2018-11-08 11:57:54.641 UTC [11137] jenkins at reproducibledb LOG:  duration: 239078.623 ms  statement: SELECT build_date FROM stats_build WHERE architecture='i386' ORDER BY build_date ASC LIMIT 1
2018-11-08 12:02:33.359 UTC [31102] jenkins at reproducibledb LOG:  duration: 277275.004 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-08-10 11:57' AND r.architecture='i386'
2018-11-08 12:04:48.860 UTC [46560] jenkins at reproducibledb LOG:  unexpected EOF on client connection with an open transaction
2018-11-08 12:04:49.323 UTC [24262] jenkins at reproducibledb LOG:  could not receive data from client: Connection reset by peer
2018-11-08 12:04:49.323 UTC [24262] jenkins at reproducibledb LOG:  unexpected EOF on client connection with an open transaction
2018-11-08 12:04:51.454 UTC [55381] jenkins at reproducibledb LOG:  could not send data to client: Broken pipe
2018-11-08 12:04:51.454 UTC [55381] jenkins at reproducibledb STATEMENT:  
2018-11-08 12:04:51.456 UTC [55381] jenkins at reproducibledb FATAL:  connection to client lost
2018-11-08 12:04:51.456 UTC [55381] jenkins at reproducibledb STATEMENT:  
2018-11-08 12:04:51.648 UTC [53411] jenkins at reproducibledb LOG:  could not receive data from client: Connection reset by peer
2018-11-08 12:04:51.649 UTC [53411] jenkins at reproducibledb LOG:  unexpected EOF on client connection with an open transaction
2018-11-08 12:05:43.947 UTC [56130] jenkins at reproducibledb LOG:  duration: 189630.203 ms  statement: SELECT build_date FROM stats_build WHERE architecture='arm64' ORDER BY build_date ASC LIMIT 1
2018-11-08 12:05:43.971 UTC [56130] jenkins at reproducibledb LOG:  could not send data to client: Broken pipe
2018-11-08 12:05:43.971 UTC [56130] jenkins at reproducibledb FATAL:  connection to client lost
2018-11-08 12:06:18.127 UTC [3612] jenkins at reproducibledb LOG:  could not send data to client: Broken pipe
2018-11-08 12:06:18.127 UTC [3612] jenkins at reproducibledb 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-11-08 12:06:18.128 UTC [3612] jenkins at reproducibledb FATAL:  connection to client lost
2018-11-08 12:06:18.128 UTC [3612] jenkins at reproducibledb 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-11-08 12:08:25.881 UTC [886] LOG:  received fast shutdown request
2018-11-08 12:08:25.891 UTC [886] LOG:  aborting any active transactions
2018-11-08 12:08:27.239 UTC [1021] LOG:  autovacuum launcher shutting down
2018-11-08 12:08:28.316 UTC [1017] LOG:  shutting down
2018-11-08 12:08:38.434 UTC [886] LOG:  database system is shut down
2018-11-08 12:10:16.901 UTC [959] [unknown]@[unknown] LOG:  incomplete startup packet
2018-11-08 12:10:16.903 UTC [956] LOG:  database system was shut down at 2018-11-08 12:08:30 UTC
2018-11-08 12:10:17.176 UTC [986] postgres at postgres FATAL:  the database system is starting up
2018-11-08 12:10:17.378 UTC [956] LOG:  MultiXact member wraparound protections are now enabled
2018-11-08 12:10:17.406 UTC [899] LOG:  database system is ready to accept connections
2018-11-08 12:10:17.406 UTC [996] LOG:  autovacuum launcher started
2018-11-08 12:19:41.170 UTC [1328] LOG:  database system was interrupted; last known up at 2018-11-08 12:10:17 UTC
2018-11-08 12:19:41.171 UTC [1329] [unknown]@[unknown] LOG:  incomplete startup packet
2018-11-08 12:19:41.609 UTC [1348] postgres at postgres FATAL:  the database system is starting up
2018-11-08 12:19:41.806 UTC [1328] LOG:  database system was not properly shut down; automatic recovery in progress
2018-11-08 12:19:41.899 UTC [1328] LOG:  invalid record length at 32/8D471A0: wanted 24, got 0
2018-11-08 12:19:41.899 UTC [1328] LOG:  redo is not required
2018-11-08 12:19:42.133 UTC [1502] postgres at postgres FATAL:  the database system is starting up
2018-11-08 12:19:42.312 UTC [1328] LOG:  MultiXact member wraparound protections are now enabled
2018-11-08 12:19:42.320 UTC [1509] LOG:  autovacuum launcher started
2018-11-08 12:19:42.320 UTC [1265] LOG:  database system is ready to accept connections
2018-11-08 12:29:17.054 UTC [19873] jenkins at reproducibledb LOG:  duration: 208903.169 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-11-07 12:25' AND r.architecture='amd64'
2018-11-08 12:33:44.016 UTC [8148] jenkins at reproducibledb ERROR:  duplicate key value violates unique constraint "removed_packages_pkey"
2018-11-08 12:33:44.016 UTC [8148] jenkins at reproducibledb DETAIL:  Key (name, suite, architecture)=(llvm-toolchain-7, experimental, amd64) already exists.
2018-11-08 12:33:44.016 UTC [8148] jenkins at reproducibledb STATEMENT:  INSERT INTO removed_packages (name, suite, architecture) VALUES ('llvm-toolchain-7', 'experimental', 'amd64')
2018-11-08 15:32:12.366 UTC [45507] jenkins at reproducibledb ERROR:  duplicate key value violates unique constraint "removed_packages_pkey"
2018-11-08 15:32:12.366 UTC [45507] jenkins at reproducibledb DETAIL:  Key (name, suite, architecture)=(llvm-toolchain-7, experimental, amd64) already exists.
2018-11-08 15:32:12.366 UTC [45507] jenkins at reproducibledb STATEMENT:  INSERT INTO removed_packages (name, suite, architecture) VALUES ('llvm-toolchain-7', 'experimental', 'amd64')
2018-11-08 18:33:02.288 UTC [30002] jenkins at reproducibledb ERROR:  duplicate key value violates unique constraint "removed_packages_pkey"
2018-11-08 18:33:02.288 UTC [30002] jenkins at reproducibledb DETAIL:  Key (name, suite, architecture)=(llvm-toolchain-7, experimental, amd64) already exists.
2018-11-08 18:33:02.288 UTC [30002] jenkins at reproducibledb STATEMENT:  INSERT INTO removed_packages (name, suite, architecture) VALUES ('llvm-toolchain-7', 'experimental', 'amd64')
2018-11-08 21:33:50.138 UTC [15537] jenkins at reproducibledb ERROR:  duplicate key value violates unique constraint "removed_packages_pkey"
2018-11-08 21:33:50.138 UTC [15537] jenkins at reproducibledb DETAIL:  Key (name, suite, architecture)=(llvm-toolchain-7, experimental, amd64) already exists.
2018-11-08 21:33:50.138 UTC [15537] jenkins at reproducibledb STATEMENT:  INSERT INTO removed_packages (name, suite, architecture) VALUES ('llvm-toolchain-7', 'experimental', 'amd64')
2018-11-08 22:04:40.984 UTC [41616] jenkins at reproducibledb LOG:  duration: 158987.158 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-11-07 22:02' AND r.architecture='amd64'



More information about the Qa-jenkins-scm mailing list