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

jenkins at jenkins.debian.net jenkins at jenkins.debian.net
Sat Jun 23 01:34:32 BST 2018


2018-06-22 01:08:18.044 UTC [41340] jenkins at reproducibledb LOG:  duration: 376345.075 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-06-22 01:12:20.337 UTC [48071] jenkins at reproducibledb LOG:  duration: 574015.748 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-06-21 01:02' AND r.architecture='amd64'
2018-06-22 01:13:14.456 UTC [41340] jenkins at reproducibledb LOG:  duration: 287154.920 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-06-22 01:46:05.396 UTC [21389] jenkins at reproducibledb LOG:  duration: 160788.033 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-06-22 01:49:37.941 UTC [21389] jenkins at reproducibledb LOG:  duration: 206941.201 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-06-22 01:53:00.504 UTC [21389] jenkins at reproducibledb LOG:  duration: 189643.482 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-06-22 01:53:36.111 UTC [30344] jenkins at reproducibledb LOG:  duration: 382843.466 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-06-21 01:47' AND r.architecture='amd64'
2018-06-22 04:45:32.287 UTC [48561] jenkins at reproducibledb ERROR:  insert or update on table "results" violates foreign key constraint "results_tmp_package_id_fkey1"
2018-06-22 04:45:32.287 UTC [48561] jenkins at reproducibledb DETAIL:  Key (package_id)=(383257) is not present in table "sources".
2018-06-22 04:45:32.287 UTC [48561] jenkins at reproducibledb STATEMENT:  INSERT INTO results (package_id, version, status, build_date, build_duration, node1, node2, job) VALUES ('383257', '1:2.18.0~rc2+next.20180619-1', 'reproducible', '2018-06-22 03:27', '4678', 'ff4a-armhf-rb.debian.net', 'jtk1a-armhf-rb.debian.net', 'armhf_46/6124') ON CONFLICT (package_id) DO UPDATE SET version='1:2.18.0~rc2+next.20180619-1', status='reproducible', build_date='2018-06-22 03:27', build_duration='4678', node1='ff4a-armhf-rb.debian.net', node2='jtk1a-armhf-rb.debian.net', job='armhf_46/6124' WHERE results.package_id='383257'
2018-06-22 10:44:11.969 UTC [49398] mattia at reproducibledb ERROR:  syntax error at or near "," at character 52
2018-06-22 10:44:11.969 UTC [49398] mattia at reproducibledb STATEMENT:  select * from stats_build where status = "timeout"
2018-06-22 11:58:01.615 UTC [2478] mattia at reproducibledb ERROR:  permission denied for relation results
2018-06-22 11:58:01.615 UTC [2478] mattia at reproducibledb STATEMENT:  UPDATE results set package_id='136193', version='1:20180604-1', status='blacklisted', build_date='2018-06-22 11:58', job='' WHERE id=2481849;
2018-06-22 11:58:02.649 UTC [3110] mattia at reproducibledb ERROR:  permission denied for relation results
2018-06-22 11:58:02.649 UTC [3110] mattia at reproducibledb STATEMENT:  UPDATE results set package_id='4246', version='1:20180604-1', status='blacklisted', build_date='2018-06-22 11:58', job='' WHERE id=2415870;
2018-06-22 11:58:03.742 UTC [3770] mattia at reproducibledb ERROR:  permission denied for relation results
2018-06-22 11:58:03.742 UTC [3770] mattia at reproducibledb STATEMENT:  UPDATE results set package_id='75388', version='1:20180604-1', status='blacklisted', build_date='2018-06-22 11:58', job='' WHERE id=650536;
2018-06-22 12:01:12.798 UTC [37071] mattia at reproducibledb ERROR:  permission denied for relation results
2018-06-22 12:01:12.798 UTC [37071] mattia at reproducibledb STATEMENT:  UPDATE results set package_id='136193', version='1:20180604-1', status='blacklisted', build_date='2018-06-22 12:01', job='' WHERE id=2481849;
2018-06-22 12:01:13.711 UTC [37280] mattia at reproducibledb ERROR:  permission denied for relation results
2018-06-22 12:01:13.711 UTC [37280] mattia at reproducibledb STATEMENT:  UPDATE results set package_id='4246', version='1:20180604-1', status='blacklisted', build_date='2018-06-22 12:01', job='' WHERE id=2415870;
2018-06-22 12:01:14.656 UTC [37573] mattia at reproducibledb ERROR:  permission denied for relation results
2018-06-22 12:01:14.656 UTC [37573] mattia at reproducibledb STATEMENT:  UPDATE results set package_id='75388', version='1:20180604-1', status='blacklisted', build_date='2018-06-22 12:01', job='' WHERE id=650536;
2018-06-22 12:01:15.659 UTC [37903] mattia at reproducibledb ERROR:  permission denied for relation results
2018-06-22 12:01:15.659 UTC [37903] mattia at reproducibledb STATEMENT:  UPDATE results set package_id='211571', version='1:20180604-1', status='blacklisted', build_date='2018-06-22 12:01', job='' WHERE id=2475185;
2018-06-22 12:19:38.535 UTC [8058] jenkins at reproducibledb LOG:  duration: 158277.333 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-06-21 12:17' AND r.architecture='amd64'
2018-06-22 14:06:32.118 UTC [1970] jenkins at reproducibledb LOG:  duration: 252367.269 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-06-21 14:02' AND r.architecture='amd64'
2018-06-22 14:06:59.697 UTC [63524] jenkins at reproducibledb LOG:  duration: 297771.186 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-06-22 14:10:14.887 UTC [58039] jenkins at reproducibledb LOG:  duration: 221151.463 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-06-21 14:06' AND r.architecture='i386'
2018-06-22 14:13:00.110 UTC [3427] jenkins at reproducibledb LOG:  duration: 164965.006 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-06-21 14:10' AND r.architecture='arm64'
2018-06-22 14:46:36.944 UTC [36375] jenkins at reproducibledb LOG:  duration: 186198.549 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-06-22 14:49:44.849 UTC [64114] jenkins at reproducibledb LOG:  duration: 144654.869 ms  statement: 
2018-06-22 14:49:44.844 UTC [64014] jenkins at reproducibledb LOG:  duration: 159345.263 ms  statement: 
2018-06-22 14:49:44.844 UTC [64111] jenkins at reproducibledb LOG:  duration: 144638.425 ms  statement: 
2018-06-22 14:49:51.738 UTC [36375] jenkins at reproducibledb LOG:  duration: 194640.564 ms  statement: SELECT count(results.id) AS count_1 
2018-06-22 14:54:06.673 UTC [11347] jenkins at reproducibledb LOG:  duration: 124204.607 ms  statement: 
2018-06-22 14:54:58.015 UTC [36375] jenkins at reproducibledb LOG:  duration: 306186.577 ms  statement: SELECT sources.id, sources.suite, sources.architecture, sources.name, sources.version, schedule.date_build_started, results.status, results.build_duration, (SELECT coalesce(avg(CAST(stats_build.build_duration AS INTEGER)), 0) AS coalesce_1 
2018-06-22 14:56:08.168 UTC [12350] jenkins at reproducibledb LOG:  duration: 134877.008 ms  statement: 
2018-06-22 14:57:51.531 UTC [10152] jenkins at reproducibledb LOG:  duration: 388278.480 ms  statement: 
2018-06-22 14:57:51.733 UTC [9891] jenkins at reproducibledb LOG:  duration: 412118.766 ms  statement: 
2018-06-22 14:57:52.973 UTC [9920] jenkins at reproducibledb LOG:  duration: 413230.123 ms  statement: 
2018-06-22 14:57:53.543 UTC [9248] jenkins at reproducibledb LOG:  duration: 463240.836 ms  statement: 
2018-06-22 14:57:54.233 UTC [9918] jenkins at reproducibledb LOG:  duration: 414743.462 ms  statement: 
2018-06-22 14:57:54.640 UTC [9919] jenkins at reproducibledb LOG:  duration: 414432.912 ms  statement: 
2018-06-22 15:07:02.704 UTC [44022] jenkins at reproducibledb LOG:  duration: 316469.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-06-22 15:07:10.041 UTC [57358] jenkins at reproducibledb LOG:  duration: 1323764.839 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-06-21 14:45' AND r.architecture='amd64'
2018-06-22 15:11:03.429 UTC [15688] jenkins at reproducibledb LOG:  duration: 233227.258 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-06-21 15:07' AND r.architecture='i386'
2018-06-22 15:35:22.814 UTC [19157] jenkins at reproducibledb LOG:  duration: 181361.288 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-06-21 15:32' AND r.architecture='amd64'
2018-06-22 15:53:09.854 UTC [52109] jenkins at reproducibledb LOG:  duration: 202165.180 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-06-21 15:49' AND r.architecture='amd64'
2018-06-22 15:55:11.157 UTC [3164] jenkins at reproducibledb LOG:  duration: 121144.241 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-06-21 15:53' AND r.architecture='i386'
2018-06-22 16:09:21.962 UTC [33523] jenkins at reproducibledb LOG:  duration: 156810.283 ms  statement: 
2018-06-22 16:13:44.577 UTC [4113] jenkins at reproducibledb LOG:  duration: 158355.539 ms  statement: 
2018-06-22 16:13:46.151 UTC [4115] jenkins at reproducibledb LOG:  duration: 160077.963 ms  statement: 
2018-06-22 16:13:46.170 UTC [3628] jenkins at reproducibledb LOG:  duration: 207838.317 ms  statement: 
2018-06-22 16:13:47.005 UTC [4155] jenkins at reproducibledb LOG:  duration: 159615.747 ms  statement: 
2018-06-22 16:14:39.551 UTC [33520] jenkins at reproducibledb LOG:  duration: 312040.851 ms  statement: SELECT sources.name 
2018-06-22 16:14:54.526 UTC [46300] jenkins at reproducibledb LOG:  duration: 694295.187 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-06-22 16:16:28.757 UTC [49033] jenkins at reproducibledb LOG:  duration: 836402.582 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-06-16 16:02' AND r.architecture='i386'
2018-06-22 16:19:25.709 UTC [46300] jenkins at reproducibledb LOG:  duration: 217095.699 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-06-22 16:30:05.497 UTC [1027] jenkins at reproducibledb LOG:  duration: 574123.049 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-06-22 16:33:38.128 UTC [36113] jenkins at reproducibledb LOG:  duration: 1029204.151 ms  statement: SELECT build_date FROM stats_build WHERE architecture='arm64' ORDER BY build_date ASC LIMIT 1
2018-06-22 16:33:50.589 UTC [1027] jenkins at reproducibledb LOG:  duration: 185390.942 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-06-22 16:36:46.156 UTC [2729] jenkins at reproducibledb LOG:  duration: 186809.448 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-06-16 16:33' AND r.architecture='arm64'
2018-06-22 16:39:30.881 UTC [22922] jenkins at reproducibledb LOG:  duration: 164363.684 ms  statement: SELECT build_date FROM stats_build WHERE architecture='armhf' ORDER BY build_date ASC LIMIT 1
2018-06-22 16:52:20.241 UTC [63102] jenkins at reproducibledb LOG:  duration: 126374.747 ms  statement: 
2018-06-22 16:52:20.257 UTC [62930] jenkins at reproducibledb LOG:  duration: 132337.756 ms  statement: 
2018-06-22 16:52:20.334 UTC [63067] jenkins at reproducibledb LOG:  duration: 126963.338 ms  statement: 
2018-06-22 16:52:20.334 UTC [62982] jenkins at reproducibledb LOG:  duration: 129278.076 ms  statement: 
2018-06-22 16:52:20.353 UTC [63122] jenkins at reproducibledb LOG:  duration: 126373.427 ms  statement: 
2018-06-22 16:52:20.364 UTC [63048] jenkins at reproducibledb LOG:  duration: 127705.166 ms  statement: 
2018-06-22 16:52:20.458 UTC [55270] jenkins at reproducibledb LOG:  duration: 193809.298 ms  statement: 
2018-06-22 16:52:20.586 UTC [62322] jenkins at reproducibledb LOG:  duration: 140452.750 ms  statement: 
2018-06-22 16:52:20.682 UTC [54856] jenkins at reproducibledb LOG:  duration: 201025.109 ms  statement: 
2018-06-22 16:52:20.651 UTC [63016] jenkins at reproducibledb LOG:  duration: 128147.714 ms  statement: 
2018-06-22 16:52:20.680 UTC [54828] jenkins at reproducibledb LOG:  duration: 202554.712 ms  statement: 
2018-06-22 16:52:20.731 UTC [62258] jenkins at reproducibledb LOG:  duration: 140555.625 ms  statement: 
2018-06-22 16:52:20.735 UTC [53990] jenkins at reproducibledb LOG:  duration: 232176.950 ms  statement: 
2018-06-22 16:52:20.774 UTC [63068] jenkins at reproducibledb LOG:  duration: 126942.930 ms  statement: 
2018-06-22 16:55:42.417 UTC [21731] jenkins at reproducibledb LOG:  duration: 773707.817 ms  statement: SELECT sources.name 
2018-06-22 16:55:46.712 UTC [53286] jenkins at reproducibledb LOG:  duration: 761604.040 ms  statement: 
2018-06-22 16:56:44.104 UTC [9202] jenkins at reproducibledb LOG:  duration: 146016.147 ms  statement: 
2018-06-22 17:01:28.941 UTC [17698] jenkins at reproducibledb LOG:  duration: 193190.631 ms  statement: 
2018-06-22 17:01:28.941 UTC [19658] jenkins at reproducibledb LOG:  duration: 124993.854 ms  statement: 
2018-06-22 17:01:29.139 UTC [17017] jenkins at reproducibledb LOG:  duration: 228017.995 ms  statement: 
2018-06-22 17:01:30.357 UTC [17113] jenkins at reproducibledb LOG:  duration: 221764.832 ms  statement: 
2018-06-22 17:02:39.624 UTC [21731] jenkins at reproducibledb LOG:  duration: 416621.769 ms  statement: SELECT count(results.id) AS count_1 
2018-06-22 17:02:49.700 UTC [12416] jenkins at reproducibledb LOG:  duration: 450070.647 ms  statement: SELECT s.name FROM results AS r JOIN sources AS s ON r.package_id=s.id WHERE r.status='FTBR' AND s.suite='stretch'
2018-06-22 17:03:24.212 UTC [53286] jenkins at reproducibledb LOG:  duration: 456777.652 ms  statement: 
2018-06-22 17:09:51.700 UTC [44485] jenkins at reproducibledb LOG:  duration: 1646759.267 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-06-22 17:11:36.920 UTC [36516] jenkins at reproducibledb LOG:  duration: 1925756.399 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-06-16 16:39' AND r.architecture='armhf'



More information about the Qa-jenkins-scm mailing list