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

Sun Aug 4 01:41:09 BST 2019

2019-08-03 01:58:44.572 UTC [64984] jenkins at reproducibledb LOG:  duration: 398389.158 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-08-03 02:03:35.450 UTC [64984] jenkins at reproducibledb LOG:  duration: 271913.029 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-08-03 02:06:10.741 UTC [64984] jenkins at reproducibledb LOG:  duration: 147561.601 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-08-03 02:08:30.327 UTC [64984] jenkins at reproducibledb LOG:  duration: 125367.828 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-08-03 02:08:59.520 UTC [15308] jenkins at reproducibledb LOG:  duration: 317853.659 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2019-08-02 02:03' AND r.architecture='amd64'
2019-08-03 02:41:32.200 UTC [5217] jenkins at reproducibledb ERROR:  duplicate key value violates unique constraint "stats_build_tmp_name_version_suite_architecture_build_date_key1"
2019-08-03 02:41:32.200 UTC [5217] jenkins at reproducibledb DETAIL:  Key (name, version, suite, architecture, build_date)=(devhelp, 3.32.0-1, archlinux_extra, x86_64, 2019-08-03 02:38:00) already exists.
2019-08-03 02:41:32.200 UTC [5217] jenkins at reproducibledb STATEMENT:  INSERT INTO stats_build (name, version, suite, architecture, distribution, status, build_date, build_duration, node1, node2, job)
			VALUES ('devhelp', '3.32.0-1', 'archlinux_extra', 'x86_64', 3, 'reproducible', '2019-08-03 02:38', '156', 'osuosl-build170-amd64', 'osuosl-build169-amd64', 'https://jenkins.debian.net/job/reproducible_builder_archlinux_6/48605/');
2019-08-03 07:00:32.942 UTC [35196] jenkins at reproducibledb ERROR:  duplicate key value violates unique constraint "stats_build_tmp_name_version_suite_architecture_build_date_key1"
2019-08-03 07:00:32.942 UTC [35196] jenkins at reproducibledb DETAIL:  Key (name, version, suite, architecture, build_date)=(iproute2, 5.2.0-1, archlinux_core, x86_64, 2019-08-03 06:59:00) already exists.
2019-08-03 07:00:32.942 UTC [35196] jenkins at reproducibledb STATEMENT:  INSERT INTO stats_build (name, version, suite, architecture, distribution, status, build_date, build_duration, node1, node2, job)
			VALUES ('iproute2', '5.2.0-1', 'archlinux_core', 'x86_64', 3, 'reproducible', '2019-08-03 06:59', '79', 'osuosl-build170-amd64', 'osuosl-build169-amd64', 'https://jenkins.debian.net/job/reproducible_builder_archlinux_3/120313/');
2019-08-03 08:13:18.202 UTC [39709] jenkins at reproducibledb ERROR:  duplicate key value violates unique constraint "stats_build_tmp_name_version_suite_architecture_build_date_key1"
2019-08-03 08:13:18.202 UTC [39709] jenkins at reproducibledb DETAIL:  Key (name, version, suite, architecture, build_date)=(zsh-history-substring-search, 1.0.1-2, archlinux_community, x86_64, 2019-08-03 08:12:00) already exists.
2019-08-03 08:13:18.202 UTC [39709] jenkins at reproducibledb STATEMENT:  INSERT INTO stats_build (name, version, suite, architecture, distribution, status, build_date, build_duration, node1, node2, job)
			VALUES ('zsh-history-substring-search', '1.0.1-2', 'archlinux_community', 'x86_64', 3, 'reproducible', '2019-08-03 08:12', '58', 'osuosl-build169-amd64', 'osuosl-build170-amd64', 'https://jenkins.debian.net/job/reproducible_builder_archlinux_2/168570/');
2019-08-03 12:09:13.035 UTC [12024] jenkins at reproducibledb LOG:  duration: 153930.668 ms  statement: SELECT build_date FROM stats_build WHERE architecture='i386' ORDER BY build_date ASC LIMIT 1
2019-08-03 13:08:08.211 UTC [38292] jenkins at reproducibledb LOG:  duration: 267035.818 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2019-08-02 13:03' AND r.architecture='amd64'
2019-08-03 15:16:48.306 UTC [36104] jenkins at reproducibledb LOG:  duration: 120132.256 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2019-08-02 15:14' AND r.architecture='amd64'
2019-08-03 20:55:08.616 UTC [19341] jenkins at reproducibledb LOG:  duration: 175699.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-08-03 21:07:28.653 UTC [17172] jenkins at reproducibledb LOG:  duration: 177380.232 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2019-08-02 21:04' AND r.architecture='amd64'
2019-08-03 21:38:23.063 UTC [56209] jenkins at reproducibledb ERROR:  insert or update on table "results" violates foreign key constraint "results_tmp_package_id_fkey1"
2019-08-03 21:38:23.063 UTC [56209] jenkins at reproducibledb DETAIL:  Key (package_id)=(945748) is not present in table "sources".
2019-08-03 21:38:23.063 UTC [56209] jenkins at reproducibledb STATEMENT:  INSERT INTO results (package_id, version, status, build_date, build_duration, node1, node2, job) VALUES ('945748', '3.4.10+dfsg-1~exp1', 'FTBR', '2019-08-02 16:19', '105547', 'codethink-sled11-arm64.debian.net', 'codethink-sled16-arm64.debian.net', 'arm64_12/1203') ON CONFLICT (package_id) DO UPDATE SET version='3.4.10+dfsg-1~exp1', status='FTBR', build_date='2019-08-02 16:19', build_duration='105547', node1='codethink-sled11-arm64.debian.net', node2='codethink-sled16-arm64.debian.net', job='arm64_12/1203' WHERE results.package_id='945748'