[Qa-jenkins-scm] postgresql-9.6-main.log found
jenkins at jenkins.debian.net
jenkins at jenkins.debian.net
Wed Oct 24 01:39:17 BST 2018
2018-10-23 00:08:51.618 UTC [36597] jenkins at reproducibledb ERROR: duplicate key value violates unique constraint "stats_build_tmp_name_version_suite_architecture_build_date_key1"
2018-10-23 00:08:51.618 UTC [36597] jenkins at reproducibledb DETAIL: Key (name, version, suite, architecture, build_date)=(libnotify, 0.7.7-1, archlinux_extra, x86_64, 2018-10-23 00:06) already exists.
2018-10-23 00:08:51.618 UTC [36597] jenkins at reproducibledb STATEMENT: INSERT INTO stats_build (name, version, suite, architecture, status, build_date, build_duration, node1, node2, job)
VALUES ('libnotify', '0.7.7-1', 'archlinux_extra', 'x86_64', '404_C', '2018-10-23 00:06', '170', 'profitbricks-build3-amd64', 'profitbricks-build4-amd64', 'https://jenkins.debian.net/job/reproducible_builder_archlinux_4/50181/');
2018-10-23 07:06:02.034 UTC [55183] jenkins at reproducibledb LOG: duration: 241033.267 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-23 07:06:58.017 UTC [55181] jenkins at reproducibledb LOG: duration: 297633.095 ms statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-10-22 07:02' AND r.architecture='amd64'
2018-10-23 07:28:01.708 UTC [62422] jenkins at reproducibledb LOG: duration: 252161.955 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-23 07:34:20.862 UTC [35534] jenkins at reproducibledb LOG: duration: 139814.579 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-23 07:34:36.210 UTC [36306] jenkins at reproducibledb LOG: duration: 135960.324 ms statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-10-22 07:32' AND r.architecture='amd64'
2018-10-23 10:05:34.163 UTC [40501] jenkins at reproducibledb LOG: duration: 200381.258 ms statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-10-22 10:02' AND r.architecture='amd64'
2018-10-23 10:07:52.254 UTC [38360] jenkins at reproducibledb LOG: duration: 128017.277 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-23 10:08:47.698 UTC [15189] jenkins at reproducibledb LOG: duration: 193031.918 ms statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-10-22 10:05' AND r.architecture='i386'
2018-10-23 11:34:44.901 UTC [35263] jenkins at reproducibledb LOG: duration: 147808.471 ms statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-09-26 11:32' AND r.architecture='arm64'
2018-10-23 11:35:55.136 UTC [33745] jenkins at reproducibledb LOG: duration: 127315.330 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-23 11:38:36.845 UTC [33745] jenkins at reproducibledb LOG: duration: 150576.288 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-23 11:38:41.086 UTC [54741] jenkins at reproducibledb LOG: duration: 234935.918 ms statement: SELECT build_date FROM stats_build WHERE architecture='armhf' ORDER BY build_date ASC LIMIT 1
2018-10-23 11:41:45.952 UTC [22870] jenkins at reproducibledb LOG: duration: 184528.397 ms statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-09-26 11:38' AND r.architecture='armhf'
2018-10-23 11:45:26.884 UTC [48866] jenkins at reproducibledb LOG: duration: 202368.332 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-23 11:45:34.765 UTC [46731] jenkins at reproducibledb LOG: duration: 228337.252 ms statement: SELECT build_date FROM stats_build WHERE architecture='amd64' ORDER BY build_date ASC LIMIT 1
2018-10-23 11:48:43.253 UTC [6516] jenkins at reproducibledb LOG: duration: 187684.809 ms statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-07-25 11:45' AND r.architecture='amd64'
2018-10-23 11:51:38.044 UTC [41263] jenkins at reproducibledb LOG: duration: 173980.885 ms statement: SELECT build_date FROM stats_build WHERE architecture='i386' ORDER BY build_date ASC LIMIT 1
2018-10-23 12:40:42.953 UTC [58185] jenkins at reproducibledb LOG: duration: 124416.048 ms statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-07-25 12:38' AND r.architecture='arm64'
2018-10-23 13:14:08.921 UTC [59806] jenkins at reproducibledb LOG: duration: 126829.449 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-23 13:15:38.743 UTC [64238] jenkins at reproducibledb LOG: duration: 189926.413 ms statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-10-22 13:12' AND r.architecture='amd64'
2018-10-23 13:52:36.272 UTC [24741] jenkins at reproducibledb LOG: duration: 328577.764 ms statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-07-25 13:47' AND r.architecture='armhf'
2018-10-23 13:56:40.941 UTC [53102] jenkins at reproducibledb LOG: duration: 150856.775 ms statement:
2018-10-23 13:57:53.147 UTC [53091] jenkins at reproducibledb LOG: duration: 225129.724 ms statement:
2018-10-23 13:57:53.232 UTC [53689] jenkins at reproducibledb LOG: duration: 207899.233 ms statement:
2018-10-23 13:57:53.507 UTC [53244] jenkins at reproducibledb LOG: duration: 223354.687 ms statement:
2018-10-23 13:57:53.609 UTC [53969] jenkins at reproducibledb LOG: duration: 196665.316 ms statement:
2018-10-23 13:57:54.716 UTC [52553] jenkins at reproducibledb LOG: duration: 228803.847 ms statement:
2018-10-23 13:57:57.711 UTC [53229] jenkins at reproducibledb LOG: duration: 223581.192 ms statement:
2018-10-23 14:00:28.388 UTC [57886] jenkins at reproducibledb LOG: duration: 150761.433 ms statement:
2018-10-23 14:00:28.692 UTC [57935] jenkins at reproducibledb LOG: duration: 151466.762 ms statement:
2018-10-23 14:00:28.891 UTC [59181] jenkins at reproducibledb LOG: duration: 134409.119 ms statement:
2018-10-23 14:02:46.451 UTC [63497] jenkins at reproducibledb LOG: duration: 218102.710 ms statement:
2018-10-23 14:02:46.461 UTC [63669] jenkins at reproducibledb LOG: duration: 211852.584 ms statement:
2018-10-23 14:02:46.461 UTC [64376] jenkins at reproducibledb LOG: duration: 206915.161 ms statement:
2018-10-23 14:02:46.584 UTC [64877] jenkins at reproducibledb LOG: duration: 186823.145 ms statement:
2018-10-23 14:02:46.593 UTC [63498] jenkins at reproducibledb LOG: duration: 218206.832 ms statement:
2018-10-23 14:02:46.750 UTC [63470] jenkins at reproducibledb LOG: duration: 218209.851 ms statement:
2018-10-23 14:02:46.758 UTC [63628] jenkins at reproducibledb LOG: duration: 213432.441 ms statement:
2018-10-23 14:02:46.856 UTC [65019] jenkins at reproducibledb LOG: duration: 180586.387 ms statement:
2018-10-23 14:02:46.856 UTC [63624] jenkins at reproducibledb LOG: duration: 213392.410 ms statement:
2018-10-23 14:02:46.595 UTC [65355] jenkins at reproducibledb LOG: duration: 170110.911 ms statement:
2018-10-23 14:02:46.882 UTC [64743] jenkins at reproducibledb LOG: duration: 195843.782 ms statement:
2018-10-23 14:04:17.246 UTC [487] jenkins at reproducibledb LOG: duration: 232580.886 ms statement:
2018-10-23 14:04:17.332 UTC [1576] jenkins at reproducibledb LOG: duration: 184085.877 ms statement:
2018-10-23 14:04:17.543 UTC [1293] jenkins at reproducibledb LOG: duration: 201473.617 ms statement:
2018-10-23 14:04:17.713 UTC [442] jenkins at reproducibledb LOG: duration: 233381.192 ms statement:
2018-10-23 14:05:24.829 UTC [2889] jenkins at reproducibledb LOG: duration: 170215.410 ms statement:
2018-10-23 14:05:57.230 UTC [2482] jenkins at reproducibledb LOG: duration: 244724.336 ms statement: SELECT suite, name, version FROM sources WHERE architecture='x86_64';
2018-10-23 14:05:57.365 UTC [3040] jenkins at reproducibledb LOG: duration: 238380.981 ms statement:
2018-10-23 14:05:57.385 UTC [1947] jenkins at reproducibledb LOG: duration: 254594.394 ms statement:
2018-10-23 14:07:18.638 UTC [4733] jenkins at reproducibledb LOG: duration: 267226.859 ms statement:
2018-10-23 14:08:08.032 UTC [2889] jenkins at reproducibledb LOG: duration: 162704.163 ms statement:
2018-10-23 14:08:30.969 UTC [11225] jenkins at reproducibledb LOG: duration: 149368.229 ms statement:
2018-10-23 14:08:31.035 UTC [12363] jenkins at reproducibledb LOG: duration: 123511.807 ms statement:
2018-10-23 14:08:31.035 UTC [12189] jenkins at reproducibledb LOG: duration: 131880.333 ms statement:
2018-10-23 14:08:31.229 UTC [9493] jenkins at reproducibledb LOG: duration: 218696.192 ms statement:
2018-10-23 14:08:31.351 UTC [10276] jenkins at reproducibledb LOG: duration: 185101.245 ms statement:
2018-10-23 14:08:31.498 UTC [12543] jenkins at reproducibledb LOG: duration: 121144.947 ms statement:
2018-10-23 14:08:31.713 UTC [9129] jenkins at reproducibledb LOG: duration: 229272.736 ms statement:
2018-10-23 14:08:49.632 UTC [62338] jenkins at reproducibledb LOG: duration: 603334.884 ms statement: SELECT count(*) FROM sources AS s
2018-10-23 14:09:51.465 UTC [14984] jenkins at reproducibledb LOG: duration: 132175.267 ms statement:
2018-10-23 14:09:52.812 UTC [14116] jenkins at reproducibledb LOG: duration: 154918.476 ms statement:
2018-10-23 14:11:50.352 UTC [18976] jenkins at reproducibledb LOG: duration: 185429.654 ms statement:
2018-10-23 14:11:50.634 UTC [18984] jenkins at reproducibledb LOG: duration: 185205.121 ms statement:
2018-10-23 14:11:50.734 UTC [17625] jenkins at reproducibledb LOG: duration: 200620.515 ms statement:
2018-10-23 14:11:50.751 UTC [17642] jenkins at reproducibledb LOG: duration: 200680.442 ms statement:
2018-10-23 14:11:50.849 UTC [55386] jenkins at reproducibledb LOG: duration: 870441.485 ms statement: SELECT s.name FROM results AS r JOIN sources AS s ON r.package_id = s.id WHERE r.status = 'FTBR' AND s.suite = 'unstable' AND s.architecture = 'amd64' AND s.id NOT IN (SELECT package_id FROM notes) ORDER BY build_date DESC LIMIT 23
2018-10-23 14:11:51.240 UTC [18936] jenkins at reproducibledb LOG: duration: 186928.777 ms statement:
2018-10-23 14:11:52.651 UTC [18104] jenkins at reproducibledb LOG: duration: 198751.577 ms statement:
2018-10-23 14:13:34.581 UTC [2889] jenkins at reproducibledb LOG: duration: 236873.438 ms statement:
2018-10-23 14:14:02.134 UTC [20666] jenkins at reproducibledb LOG: duration: 277977.527 ms statement:
2018-10-23 14:14:03.363 UTC [20644] jenkins at reproducibledb LOG: duration: 279951.488 ms statement:
2018-10-23 14:14:04.530 UTC [20409] jenkins at reproducibledb LOG: duration: 291669.943 ms statement:
2018-10-23 14:14:04.589 UTC [19411] jenkins at reproducibledb LOG: duration: 309740.591 ms statement: SELECT s.name FROM sources AS s
2018-10-23 14:17:35.394 UTC [27404] jenkins at reproducibledb LOG: duration: 338132.384 ms statement: SELECT count(*) FROM sources WHERE suite='stretch' AND architecture='amd64'
2018-10-23 14:17:36.014 UTC [27156] jenkins at reproducibledb LOG: duration: 339879.996 ms statement:
2018-10-23 14:18:36.311 UTC [34765] jenkins at reproducibledb LOG: duration: 231088.447 ms statement:
2018-10-23 14:18:36.313 UTC [34766] jenkins at reproducibledb LOG: duration: 230951.916 ms statement:
2018-10-23 14:18:36.456 UTC [2960] jenkins at reproducibledb LOG: duration: 984519.504 ms statement: SELECT sources.name
2018-10-23 14:18:37.240 UTC [30909] jenkins at reproducibledb LOG: duration: 266198.573 ms statement: SELECT s.name FROM sources AS s
2018-10-23 14:19:14.076 UTC [3438] jenkins at reproducibledb LOG: duration: 1008554.948 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-10-23 14:23:55.142 UTC [46106] jenkins at reproducibledb LOG: duration: 1876484.341 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-23 14:28:03.270 UTC [46106] jenkins at reproducibledb LOG: duration: 234363.250 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-23 14:29:54.087 UTC [20394] jenkins at reproducibledb LOG: duration: 271315.110 ms statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-10-22 14:25' AND r.architecture='amd64'
2018-10-23 19:45:15.237 UTC [1662] LOG: using stale statistics instead of current ones because stats collector is not responding
2018-10-23 19:49:19.424 UTC [21075] jenkins at reproducibledb LOG: duration: 133071.487 ms statement: SELECT COUNT(s.name) FROM results AS r JOIN sources AS s ON r.package_id=s.id WHERE s.suite='unstable' AND s.architecture='arm64' AND r.status = 'NFU'
2018-10-23 19:51:50.975 UTC [45309] jenkins at reproducibledb LOG: duration: 543956.042 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-23 19:58:56.123 UTC [45309] jenkins at reproducibledb LOG: duration: 323780.097 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-23 19:59:37.973 UTC [48964] jenkins at reproducibledb LOG: duration: 530492.882 ms statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-10-22 19:50' AND r.architecture='amd64'
2018-10-23 20:10:25.095 UTC [22521] jenkins at reproducibledb LOG: duration: 187859.317 ms statement: SELECT build_date FROM stats_build WHERE architecture='i386' ORDER BY build_date ASC LIMIT 1
2018-10-23 20:34:55.822 UTC [16352] jenkins at reproducibledb LOG: duration: 156269.084 ms statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-10-22 20:32' AND r.architecture='amd64'
More information about the Qa-jenkins-scm
mailing list