[Qa-jenkins-scm] postgresql-9.6-main.log found
jenkins at jenkins.debian.net
jenkins at jenkins.debian.net
Wed Jul 10 01:59:38 BST 2019
2019-07-09 00:13:12.804 UTC [1478] jenkins at reproducibledb LOG: duration: 271389.645 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-07-09 00:17:24.763 UTC [1478] jenkins at reproducibledb LOG: duration: 210983.193 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-07-09 00:20:08.177 UTC [1478] jenkins at reproducibledb LOG: duration: 150705.762 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-07-09 00:20:08.178 UTC [15697] jenkins at reproducibledb LOG: duration: 149863.852 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-07-09 00:23:52.172 UTC [20315] jenkins at reproducibledb LOG: duration: 184700.993 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' )
2019-07-09 00:28:34.045 UTC [15009] jenkins at reproducibledb LOG: duration: 505441.738 ms statement: COPY public.stats_build (id, name, version, suite, architecture, status, build_date, build_duration, node1, node2, job, distribution) TO stdout;
2019-07-09 00:46:27.288 UTC [14482] jenkins at reproducibledb LOG: duration: 210395.040 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-07-09 00:49:19.247 UTC [14482] jenkins at reproducibledb LOG: duration: 161355.290 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-07-09 03:44:42.844 UTC [31485] jenkins at reproducibledb LOG: duration: 410538.852 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-07-09 03:55:05.169 UTC [31485] jenkins at reproducibledb LOG: duration: 587946.912 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-07-09 04:04:06.932 UTC [31485] jenkins at reproducibledb LOG: duration: 532965.243 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-07-09 04:05:09.975 UTC [26006] jenkins at reproducibledb LOG: duration: 441971.227 ms statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2019-07-08 03:57' AND r.architecture='amd64'
2019-07-09 04:21:49.238 UTC [27210] jenkins at reproducibledb LOG: duration: 325643.216 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-07-09 04:26:41.631 UTC [27210] jenkins at reproducibledb LOG: duration: 272388.108 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-07-09 04:30:05.493 UTC [27210] jenkins at reproducibledb LOG: duration: 195339.123 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-07-09 04:58:30.574 UTC [24052] jenkins at reproducibledb LOG: duration: 334024.435 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-07-09 05:13:49.493 UTC [24052] jenkins at reproducibledb LOG: duration: 865186.884 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-07-09 05:14:33.429 UTC [2425] jenkins at reproducibledb LOG: duration: 524490.010 ms statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2019-07-08 05:05' AND r.architecture='amd64'
2019-07-09 05:16:56.706 UTC [24052] jenkins at reproducibledb LOG: duration: 179798.196 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-07-09 06:55:36.487 UTC [15383] jenkins at reproducibledb ERROR: duplicate key value violates unique constraint "stats_build_tmp_name_version_suite_architecture_build_date_key1"
2019-07-09 06:55:36.487 UTC [15383] jenkins at reproducibledb DETAIL: Key (name, version, suite, architecture, build_date)=(basket, 2.49a-2, archlinux_extra, x86_64, 2019-07-09 06:52:00) already exists.
2019-07-09 06:55:36.487 UTC [15383] jenkins at reproducibledb STATEMENT: INSERT INTO stats_build (name, version, suite, architecture, distribution, status, build_date, build_duration, node1, node2, job)
VALUES ('basket', '2.49a-2', 'archlinux_extra', 'x86_64', 3, 'reproducible', '2019-07-09 06:52', '200', 'osuosl-build170-amd64', 'osuosl-build169-amd64', 'https://jenkins.debian.net/job/reproducible_builder_archlinux_5/42799/');
2019-07-09 09:06:00.650 UTC [26864] jenkins at reproducibledb LOG: duration: 134588.470 ms statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2019-07-08 09:03' AND r.architecture='amd64'
2019-07-09 14:06:22.936 UTC [22773] jenkins at reproducibledb LOG: duration: 142467.670 ms statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2019-07-08 14:04' AND r.architecture='amd64'
2019-07-09 17:47:06.621 UTC [18734] jenkins at reproducibledb LOG: duration: 409595.887 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-07-09 17:47:06.627 UTC [26296] jenkins at reproducibledb LOG: duration: 193272.173 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-07-09 17:57:24.306 UTC [26296] jenkins at reproducibledb LOG: duration: 587544.638 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-07-09 17:57:24.316 UTC [18734] jenkins at reproducibledb LOG: duration: 586746.051 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-07-09 18:07:39.549 UTC [18734] jenkins at reproducibledb LOG: duration: 589723.744 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-07-09 18:07:39.551 UTC [26296] jenkins at reproducibledb LOG: duration: 590525.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
2019-07-09 18:12:44.751 UTC [26296] jenkins at reproducibledb LOG: duration: 281918.813 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-07-09 18:13:23.705 UTC [18734] jenkins at reproducibledb LOG: duration: 289403.031 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-07-09 18:19:32.350 UTC [19181] jenkins at reproducibledb LOG: duration: 200575.883 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-07-09 18:25:09.670 UTC [19181] jenkins at reproducibledb LOG: duration: 322467.023 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-07-09 18:26:46.262 UTC [64388] jenkins at reproducibledb LOG: duration: 399702.767 ms statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2019-07-08 18:20' AND r.architecture='amd64'
2019-07-09 19:38:22.876 UTC [4531] jenkins at reproducibledb LOG: duration: 591749.520 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-07-09 19:49:59.116 UTC [4531] jenkins at reproducibledb LOG: duration: 664953.978 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-07-09 20:01:20.394 UTC [33950] jenkins at reproducibledb ERROR: canceling statement due to user request
2019-07-09 20:01:20.394 UTC [33950] jenkins at reproducibledb STATEMENT: select from stats_build where status='GOOD';
2019-07-09 20:04:54.340 UTC [4531] jenkins at reproducibledb LOG: duration: 882475.874 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-07-09 20:08:10.098 UTC [60568] jenkins at reproducibledb LOG: duration: 393446.785 ms statement: select name from stats_build where status='GOOD';
2019-07-09 20:08:55.733 UTC [4531] jenkins at reproducibledb LOG: duration: 230545.612 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-07-09 20:20:44.224 UTC [9450] jenkins at reproducibledb LOG: duration: 369575.450 ms statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2019-07-08 20:14' AND r.architecture='amd64'
2019-07-09 20:24:13.341 UTC [45485] jenkins at reproducibledb LOG: duration: 208938.045 ms statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2019-07-08 20:20' AND r.architecture='i386'
2019-07-09 20:29:10.084 UTC [8641] jenkins at reproducibledb LOG: duration: 882691.567 ms statement: UPDATE stats_build SET status='reproducible' WHERE status='GOOD'
2019-07-09 20:31:21.650 UTC [8641] jenkins at reproducibledb LOG: duration: 131466.984 ms statement: UPDATE stats_build SET status='blacklisted' WHERE status='BLACKLISTED'
2019-07-09 20:41:56.609 UTC [1595] jenkins at reproducibledb LOG: duration: 134603.413 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-07-09 20:46:50.276 UTC [1595] jenkins at reproducibledb LOG: duration: 269325.111 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-07-09 20:53:07.239 UTC [1595] jenkins at reproducibledb LOG: duration: 354627.175 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-07-09 20:55:21.035 UTC [53940] jenkins at reproducibledb LOG: duration: 409874.689 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-07-09 20:59:14.535 UTC [1595] jenkins at reproducibledb LOG: duration: 343455.831 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-07-09 20:59:17.769 UTC [53940] jenkins at reproducibledb LOG: duration: 162881.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
2019-07-09 21:03:23.425 UTC [53940] jenkins at reproducibledb LOG: duration: 233287.721 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-07-09 21:08:21.637 UTC [53940] jenkins at reproducibledb LOG: duration: 283555.099 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-07-09 21:24:58.795 UTC [20240] jenkins at reproducibledb LOG: duration: 860895.534 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-07-09 21:26:12.704 UTC [63643] jenkins at reproducibledb LOG: duration: 450506.800 ms statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2019-07-08 21:18' AND r.architecture='amd64'
2019-07-09 21:28:40.187 UTC [11988] jenkins at reproducibledb LOG: duration: 147293.607 ms statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2019-07-08 21:26' AND r.architecture='i386'
2019-07-09 21:42:35.601 UTC [60043] jenkins at reproducibledb LOG: duration: 173988.589 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-07-09 21:57:07.360 UTC [29412] jenkins at reproducibledb LOG: duration: 183033.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
2019-07-09 22:01:43.403 UTC [29412] jenkins at reproducibledb LOG: duration: 141917.394 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-07-09 22:15:07.002 UTC [55760] jenkins at reproducibledb LOG: duration: 395395.225 ms statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2019-07-08 22:08' AND r.architecture='amd64'
2019-07-09 22:17:32.197 UTC [39310] jenkins at reproducibledb LOG: duration: 144808.613 ms statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2019-07-08 22:15' AND r.architecture='i386'
2019-07-09 22:32:20.901 UTC [65145] jenkins at reproducibledb LOG: duration: 333794.504 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-07-09 22:38:28.204 UTC [65145] jenkins at reproducibledb LOG: duration: 356619.428 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-07-09 22:40:50.105 UTC [56974] jenkins at reproducibledb LOG: duration: 127782.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
2019-07-09 22:55:58.804 UTC [37538] jenkins at reproducibledb LOG: duration: 234447.503 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-07-09 23:08:19.468 UTC [44972] jenkins at reproducibledb LOG: duration: 246390.596 ms statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2019-07-08 23:04' AND r.architecture='amd64'
2019-07-09 23:29:12.604 UTC [3806] jenkins at reproducibledb LOG: duration: 429393.933 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-07-09 23:32:39.241 UTC [3806] jenkins at reproducibledb LOG: duration: 183832.945 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-07-09 23:39:20.727 UTC [3806] jenkins at reproducibledb LOG: duration: 386146.290 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-07-09 23:41:56.789 UTC [6426] jenkins at reproducibledb LOG: duration: 150138.774 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-07-09 23:44:02.609 UTC [3806] jenkins at reproducibledb LOG: duration: 264432.688 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-07-09 23:57:26.754 UTC [19732] jenkins at reproducibledb LOG: duration: 214135.724 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-07-10 00:14:41.489 UTC [7048] jenkins at reproducibledb LOG: duration: 357165.977 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 > '2019-07-09 00:08'
2019-07-10 00:27:11.714 UTC [11092] jenkins at reproducibledb LOG: duration: 209734.499 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 > '2019-07-09 00:23'
2019-07-10 00:44:50.802 UTC [3687] jenkins at reproducibledb LOG: duration: 157277.219 ms statement: SELECT count(build_date) FROM stats_build AS r WHERE ( r.node1='profitbricks-build12-i386.debian.net' OR r.node2='profitbricks-build12-i386.debian.net' ) AND r.build_date > '2019-07-09 00:42'
More information about the Qa-jenkins-scm
mailing list