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

Sun Sep 23 01:41:35 BST 2018

2018-09-22 02:44:18.475 UTC [1348] jenkins at reproducibledb LOG:  duration: 136333.509 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-09-22 02:48:07.752 UTC [1348] jenkins at reproducibledb LOG:  duration: 218495.405 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-09-22 02:51:22.418 UTC [1348] jenkins at reproducibledb LOG:  duration: 188547.506 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-09-22 05:35:05.872 UTC [27072] jenkins at reproducibledb LOG:  duration: 168118.779 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-09-22 11:44:35.680 UTC [39011] jenkins at reproducibledb LOG:  duration: 743012.671 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-09-22 11:50:47.784 UTC [39011] jenkins at reproducibledb LOG:  duration: 327501.753 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-09-22 11:51:34.353 UTC [16684] jenkins at reproducibledb LOG:  duration: 373004.806 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-09-21 11:45' AND r.architecture='amd64'
2018-09-22 11:53:08.926 UTC [39011] jenkins at reproducibledb LOG:  duration: 134718.597 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-09-22 11:54:10.809 UTC [16275] jenkins at reproducibledb LOG:  duration: 155602.381 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-09-21 11:51' AND r.architecture='i386'
2018-09-22 11:57:35.400 UTC [58096] jenkins at reproducibledb LOG:  duration: 125003.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 
2018-09-22 16:18:41.389 UTC [15257] jenkins at reproducibledb ERROR:  column "x86_64" does not exist at character 100
2018-09-22 16:18:41.389 UTC [15257] jenkins at reproducibledb STATEMENT:  SELECT count(*) FROM sources AS s JOIN schedule AS sch ON s.id=sch.package_id WHERE s.architecture="x86_64";
2018-09-22 17:03:55.584 UTC [37816] jenkins at reproducibledb ERROR:  duplicate key value violates unique constraint "sources_new_name_suite_architecture_key"
2018-09-22 17:03:55.584 UTC [37816] jenkins at reproducibledb DETAIL:  Key (name, suite, architecture)=(python-fonttools, archlinux_community, x86_64) already exists.
2018-09-22 17:03:55.584 UTC [37816] jenkins at reproducibledb STATEMENT:  INSERT into sources (name, version, suite, architecture) VALUES ('python-fonttools', '', 'archlinux_community', 'x86_64');
2018-09-22 17:08:20.769 UTC [8328] jenkins at reproducibledb ERROR:  missing FROM-clause entry for table "s" at character 44
2018-09-22 17:08:20.769 UTC [8328] jenkins at reproducibledb STATEMENT:  SELECT * FROM sources WHERE version='' AND s.architecture='x86_64';
2018-09-22 17:09:10.327 UTC [16829] jenkins at reproducibledb ERROR:  canceling statement due to user request
2018-09-22 17:09:10.327 UTC [16829] jenkins at reproducibledb STATEMENT:  SELECT s.id, s.name, max(r.build_date) max_date
	                AND r.build_date < '2018-09-22 17:09'
2018-09-22 18:14:51.454 UTC [33485] jenkins at reproducibledb LOG:  duration: 164334.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-09-22 18:22:58.977 UTC [33485] jenkins at reproducibledb LOG:  duration: 224932.404 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-09-22 18:24:55.789 UTC [42692] jenkins at reproducibledb LOG:  duration: 413671.098 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-09-21 18:18' AND r.architecture='amd64'
2018-09-22 18:26:10.044 UTC [45798] jenkins at reproducibledb LOG:  duration: 186572.735 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' )
2018-09-22 18:27:59.130 UTC [51735] jenkins at reproducibledb LOG:  duration: 160096.888 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-09-22 18:34:13.381 UTC [14168] jenkins at reproducibledb LOG:  duration: 126121.498 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-06-24 18:32' AND r.architecture='armhf'
2018-09-22 18:34:33.157 UTC [18360] jenkins at reproducibledb LOG:  duration: 127045.701 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-09-21 18:32' 
2018-09-22 18:56:02.978 UTC [12623] jenkins at reproducibledb LOG:  duration: 130675.336 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-09-22 18:56:02.979 UTC [46882] jenkins at reproducibledb LOG:  duration: 130351.146 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-09-22 18:58:15.820 UTC [47167] jenkins at reproducibledb LOG:  duration: 256240.271 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-09-21 18:53' AND r.architecture='amd64'
2018-09-22 21:47:27.986 UTC [7292] jenkins at reproducibledb ERROR:  duplicate key value violates unique constraint "schedule_tmp_package_id_key"
2018-09-22 21:47:27.986 UTC [7292] jenkins at reproducibledb DETAIL:  Key (package_id)=(395175) already exists.
2018-09-22 21:47:27.986 UTC [7292] jenkins at reproducibledb STATEMENT:  INSERT INTO schedule (package_id, date_scheduled) VALUES ('395175', '2018-09-22 21:47');
2018-09-22 22:21:51.248 UTC [43969] jenkins at reproducibledb ERROR:  duplicate key value violates unique constraint "schedule_tmp_package_id_key"
2018-09-22 22:21:51.248 UTC [43969] jenkins at reproducibledb DETAIL:  Key (package_id)=(401023) already exists.
2018-09-22 22:21:51.248 UTC [43969] jenkins at reproducibledb STATEMENT:  INSERT INTO schedule (package_id, date_scheduled) VALUES ('401023', '2018-09-22 22:21');