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

Sun Mar 31 00:53:57 GMT 2019

2019-03-30 01:07:41.666 UTC [10784] jenkins at reproducibledb LOG:  duration: 230489.918 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2019-03-29 01:03' AND r.architecture='amd64'
2019-03-30 01:12:43.118 UTC [30304] jenkins at reproducibledb LOG:  duration: 301167.138 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2019-03-29 01:07' AND r.architecture='i386'
2019-03-30 01:14:24.456 UTC [28008] jenkins at reproducibledb LOG:  duration: 441619.411 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-03-30 01:16:34.173 UTC [63305] jenkins at reproducibledb LOG:  duration: 230864.330 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2019-03-29 01:12' AND r.architecture='arm64'
2019-03-30 01:19:32.722 UTC [36088] jenkins at reproducibledb LOG:  duration: 178337.776 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2019-03-29 01:16' AND r.architecture='armhf'
2019-03-30 01:23:01.460 UTC [59373] jenkins at reproducibledb LOG:  duration: 208257.321 ms  statement: SELECT build_date FROM stats_build WHERE architecture='amd64' ORDER BY build_date ASC LIMIT 1
2019-03-30 05:34:15.311 UTC [11544] jenkins at reproducibledb ERROR:  duplicate key value violates unique constraint "stats_build_tmp_name_version_suite_architecture_build_date_key1"
2019-03-30 05:34:15.311 UTC [11544] jenkins at reproducibledb DETAIL:  Key (name, version, suite, architecture, build_date)=(simavr, 1.6-1, archlinux_community, x86_64, 2019-03-30 05:23:00) already exists.
2019-03-30 05:34:15.311 UTC [11544] jenkins at reproducibledb STATEMENT:  INSERT INTO stats_build (name, version, suite, architecture, distribution, status, build_date, build_duration, node1, node2, job)
			VALUES ('simavr', '1.6-1', 'archlinux_community', 'x86_64', 3, 'GOOD', '2019-03-30 05:23', '618', 'osuosl-build169-amd64', 'osuosl-build170-amd64', 'https://jenkins.debian.net/job/reproducible_builder_archlinux_3/88217/');
2019-03-30 06:29:03.485 UTC [387] jenkins at reproducibledb LOG:  duration: 421222.517 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-03-30 06:31:36.952 UTC [387] jenkins at reproducibledb LOG:  duration: 131503.790 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-03-30 06:36:39.659 UTC [387] jenkins at reproducibledb LOG:  duration: 296477.003 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-03-30 06:40:10.512 UTC [387] jenkins at reproducibledb LOG:  duration: 199394.007 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-03-30 07:05:59.727 UTC [45592] jenkins at reproducibledb LOG:  duration: 139658.483 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2019-03-29 07:03' AND r.architecture='amd64'
2019-03-30 12:09:42.112 UTC [38397] jenkins at reproducibledb LOG:  duration: 158807.361 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-03-30 12:11:05.998 UTC [32495] jenkins at reproducibledb LOG:  duration: 266695.290 ms  statement: SELECT build_date FROM stats_build WHERE architecture='armhf' ORDER BY build_date ASC LIMIT 1
2019-03-30 12:13:20.107 UTC [38397] jenkins at reproducibledb LOG:  duration: 190738.462 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-03-30 12:13:53.124 UTC [27754] jenkins at reproducibledb LOG:  duration: 166858.340 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2019-03-03 12:11' AND r.architecture='armhf'
2019-03-30 16:10:24.249 UTC [59508] jenkins at reproducibledb ERROR:  insert or update on table "results" violates foreign key constraint "results_tmp_package_id_fkey1"
2019-03-30 16:10:24.249 UTC [59508] jenkins at reproducibledb DETAIL:  Key (package_id)=(602931) is not present in table "sources".
2019-03-30 16:10:24.249 UTC [59508] jenkins at reproducibledb STATEMENT:  INSERT INTO results (package_id, version, status, build_date, build_duration, node1, node2, job) VALUES ('602931', '3.4.6+dfsg-1~exp1', 'FTBR', '2019-03-30 01:22', '53289', 'jtk1a-armhf-rb.debian.net', 'ff64a-armhf-rb.debian.net', 'armhf_54/1257') ON CONFLICT (package_id) DO UPDATE SET version='3.4.6+dfsg-1~exp1', status='FTBR', build_date='2019-03-30 01:22', build_duration='53289', node1='jtk1a-armhf-rb.debian.net', node2='ff64a-armhf-rb.debian.net', job='armhf_54/1257' WHERE results.package_id='602931'
2019-03-30 18:43:24.739 UTC [3619] jenkins at reproducibledb LOG:  duration: 416977.871 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-03-30 18:43:24.740 UTC [47695] jenkins at reproducibledb LOG:  duration: 381386.068 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-03-30 18:47:01.529 UTC [3619] jenkins at reproducibledb LOG:  duration: 203606.291 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-03-30 18:47:01.530 UTC [47695] jenkins at reproducibledb LOG:  duration: 203233.576 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-03-30 19:06:09.773 UTC [30623] jenkins at reproducibledb LOG:  duration: 146508.255 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2019-03-29 19:03' AND r.architecture='amd64'
2019-03-30 22:07:16.901 UTC [43753] jenkins at reproducibledb LOG:  duration: 205758.984 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2019-03-29 22:03' AND r.architecture='amd64'
2019-03-30 23:05:53.225 UTC [36596] jenkins at reproducibledb LOG:  duration: 123229.598 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2019-03-29 23:03' AND r.architecture='amd64'