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

Fri Jun 1 01:31:45 BST 2018

2018-05-31 00:22:47.950 UTC [6954] jenkins at reproducibledb LOG:  duration: 131247.927 ms  statement: 
2018-05-31 00:23:37.694 UTC [6397] jenkins at reproducibledb LOG:  duration: 208100.494 ms  statement: SELECT COALESCE(CAST(AVG(r.build_duration) AS INTEGER), 0) FROM results AS r JOIN sources AS s ON r.package_id=s.id WHERE r.build_duration!='0' AND r.build_date LIKE '%2018-05-30%' AND s.architecture='amd64'
2018-05-31 00:27:05.086 UTC [8082] jenkins at reproducibledb LOG:  duration: 265537.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-05-31 00:29:17.743 UTC [22286] jenkins at reproducibledb LOG:  duration: 333087.060 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-05-30 00:23' AND r.architecture='amd64'
2018-05-31 00:50:14.974 UTC [33446] jenkins at reproducibledb LOG:  duration: 161883.934 ms  statement: 
2018-05-31 00:54:56.197 UTC [38596] jenkins at reproducibledb LOG:  duration: 457714.517 ms  statement: SELECT count(*) FROM sources WHERE suite='experimental' AND architecture='i386'
2018-05-31 01:02:48.788 UTC [2678] jenkins at reproducibledb LOG:  duration: 262789.750 ms  statement: 
2018-05-31 01:03:26.487 UTC [1341] jenkins at reproducibledb LOG:  duration: 329499.271 ms  statement: SELECT COUNT(s.name) FROM results AS r JOIN sources AS s ON r.package_id=s.id WHERE s.suite='experimental' AND s.architecture='i386' AND r.status = 'FTBFS'
2018-05-31 01:03:26.852 UTC [1591] jenkins at reproducibledb LOG:  duration: 329955.979 ms  statement: 
2018-05-31 01:03:27.056 UTC [1335] jenkins at reproducibledb LOG:  duration: 330069.607 ms  statement: 
2018-05-31 01:03:27.336 UTC [1337] jenkins at reproducibledb LOG:  duration: 330364.648 ms  statement: 
2018-05-31 01:05:45.071 UTC [5505] jenkins at reproducibledb LOG:  duration: 180258.981 ms  statement: 
2018-05-31 01:06:41.714 UTC [52175] jenkins at reproducibledb LOG:  duration: 675013.955 ms  statement: SELECT s.name FROM results AS r JOIN sources AS s ON r.package_id=s.id WHERE r.status='unreproducible' AND s.suite='stretch'
2018-05-31 01:06:42.062 UTC [8094] jenkins at reproducibledb LOG:  duration: 190818.981 ms  statement: SELECT COUNT(s.name) FROM results AS r JOIN sources AS s ON r.package_id=s.id WHERE s.suite='experimental' AND s.architecture='i386' AND r.status = '404'
2018-05-31 01:07:54.263 UTC [5003] jenkins at reproducibledb LOG:  duration: 352468.909 ms  statement: SELECT sources.name 
2018-05-31 01:15:28.402 UTC [48288] jenkins at reproducibledb LOG:  duration: 128926.231 ms  statement: 
2018-05-31 01:15:28.599 UTC [47834] jenkins at reproducibledb LOG:  duration: 140891.369 ms  statement: 
2018-05-31 01:15:28.733 UTC [47762] jenkins at reproducibledb LOG:  duration: 144023.834 ms  statement: 
2018-05-31 01:15:28.774 UTC [47496] jenkins at reproducibledb LOG:  duration: 149366.045 ms  statement: 
2018-05-31 01:17:12.822 UTC [5003] jenkins at reproducibledb LOG:  duration: 252228.822 ms  statement: SELECT sources.name 
2018-05-31 01:17:13.623 UTC [5505] jenkins at reproducibledb LOG:  duration: 267543.804 ms  statement: 
2018-05-31 01:27:52.193 UTC [46637] jenkins at reproducibledb LOG:  duration: 2044793.403 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-05-31 01:33:52.574 UTC [46637] jenkins at reproducibledb LOG:  duration: 338441.658 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-05-31 01:35:39.746 UTC [36241] jenkins at reproducibledb LOG:  duration: 1564844.078 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-05-30 01:09' AND r.architecture='amd64'
2018-05-31 01:36:33.624 UTC [46637] jenkins at reproducibledb LOG:  duration: 153615.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 
2018-05-31 03:25:16.828 UTC [6557] jenkins at reproducibledb ERROR:  insert or update on table "results" violates foreign key constraint "results_tmp_package_id_fkey1"
2018-05-31 03:25:16.828 UTC [6557] jenkins at reproducibledb DETAIL:  Key (package_id)=(380951) is not present in table "sources".
2018-05-31 03:25:16.828 UTC [6557] jenkins at reproducibledb STATEMENT:  INSERT INTO results (package_id, version, status, build_date, build_duration, node1, node2, job) VALUES ('380951', '1.26.0+dfsg1-1~exp4', '404', '2018-05-31 00:05', '0', 'codethink-sled10-arm64.debian.net', 'codethink-sled15-arm64.debian.net', 'arm64_8/5767')
2018-05-31 03:25:16.989 UTC [6576] jenkins at reproducibledb ERROR:  insert or update on table "results" violates foreign key constraint "results_tmp_package_id_fkey1"
2018-05-31 03:25:16.989 UTC [6576] jenkins at reproducibledb DETAIL:  Key (package_id)=(380951) is not present in table "sources".
2018-05-31 03:25:16.989 UTC [6576] jenkins at reproducibledb STATEMENT:  INSERT INTO results (package_id, version, status, build_date, build_duration, node1, node2, job) VALUES ('380951', '1.26.0+dfsg1-1~exp4', '404', '2018-05-31 00:05', '0', 'codethink-sled10-arm64.debian.net', 'codethink-sled15-arm64.debian.net', 'arm64_8/5767')
2018-05-31 12:45:54.296 UTC [38155] jenkins at reproducibledb ERROR:  insert or update on table "results" violates foreign key constraint "results_tmp_package_id_fkey1"
2018-05-31 12:45:54.296 UTC [38155] jenkins at reproducibledb DETAIL:  Key (package_id)=(381159) is not present in table "sources".
2018-05-31 12:45:54.296 UTC [38155] jenkins at reproducibledb STATEMENT:  INSERT INTO results (package_id, version, status, build_date, build_duration, node1, node2, job) VALUES ('381159', '67.0.3396.57-1', 'unreproducible', '2018-05-31 01:38', '40015', 'profitbricks-build2-i386.debian.net', 'profitbricks-build16-i386.debian.net', 'i386_3/7907')
2018-05-31 12:45:54.440 UTC [38216] jenkins at reproducibledb ERROR:  insert or update on table "results" violates foreign key constraint "results_tmp_package_id_fkey1"
2018-05-31 12:45:54.440 UTC [38216] jenkins at reproducibledb DETAIL:  Key (package_id)=(381159) is not present in table "sources".
2018-05-31 12:45:54.440 UTC [38216] jenkins at reproducibledb STATEMENT:  INSERT INTO results (package_id, version, status, build_date, build_duration, node1, node2, job) VALUES ('381159', '67.0.3396.57-1', 'unreproducible', '2018-05-31 01:38', '40015', 'profitbricks-build2-i386.debian.net', 'profitbricks-build16-i386.debian.net', 'i386_3/7907')