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

Tue Jul 24 01:25:52 BST 2018

2018-07-23 06:51:26.841 UTC [9386] jenkins at reproducibledb LOG:  duration: 262673.119 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-07-22 06:47' AND r.architecture='amd64'
2018-07-23 07:04:34.698 UTC [6939] jenkins at reproducibledb LOG:  duration: 151596.358 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-07-23 07:07:39.260 UTC [6939] jenkins at reproducibledb LOG:  duration: 168254.762 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-07-23 07:10:59.055 UTC [13097] jenkins at reproducibledb LOG:  duration: 484609.026 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-07-22 07:02' AND r.architecture='amd64'
2018-07-23 07:50:26.175 UTC [44168] jenkins at reproducibledb LOG:  duration: 184918.608 ms  statement: SELECT COUNT(package_id) FROM notes AS n JOIN sources AS s ON n.package_id=s.id WHERE s.suite='unstable' AND s.architecture='amd64'
2018-07-23 07:54:37.409 UTC [45969] jenkins at reproducibledb LOG:  duration: 245924.261 ms  statement: SELECT 		(SELECT COUNT(issues) FROM notes AS n JOIN sources AS s ON n.package_id=s.id WHERE s.suite='unstable' AND s.architecture='amd64' AND n.issues = '[]') 		+ 		(SELECT COUNT(issues) FROM notes AS n JOIN sources AS s ON n.package_id=s.id WHERE s.suite='unstable' AND s.architecture='amd64' AND n.issues != '[]' AND n.issues NOT LIKE '%,%') 		+ 		(SELECT COUNT(issues) FROM notes AS n JOIN sources AS s ON n.package_id=s.id WHERE s.suite='unstable' AND s.architecture='amd64' AND n.issues LIKE '%,%') 		+ 		(SELECT COUNT(issues) FROM notes AS n JOIN sources AS s ON n.package_id=s.id WHERE s.suite='unstable' AND s.architecture='amd64' AND n.issues LIKE '%,%,%') 		+ 		(SELECT COUNT(issues) FROM notes AS n JOIN sources AS s ON n.package_id=s.id WHERE s.suite='unstable' AND s.architecture='amd64' AND n.issues LIKE '%,%,%,%') 		+ 		(SELECT COUNT(issues) FROM notes AS n JOIN sources AS s ON n.
 package_id=s.id WHERE s.suite='unstable' AND s.architecture='amd64' AND n.issues LIKE '%,%,%,%,%') 		+ 		(SELECT COUNT(issues) FROM notes AS n JOIN sources AS s ON n.package_id=s.id WHERE s.suite='unstable' AND s.architecture='amd64' AND n.issues LIKE '%,%,%,%,%,%') 		
2018-07-23 07:56:07.918 UTC [42309] jenkins at reproducibledb LOG:  duration: 758989.595 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-07-23 08:00:52.680 UTC [55983] jenkins at reproducibledb LOG:  duration: 212889.636 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-07-22 07:57' AND r.architecture='amd64'
2018-07-23 15:28:10.559 UTC [22373] jenkins at reproducibledb LOG:  duration: 148042.913 ms  statement: 
2018-07-23 15:29:56.782 UTC [22372] jenkins at reproducibledb LOG:  duration: 254526.972 ms  statement: SELECT COUNT(s.name) FROM results AS r JOIN sources AS s ON r.package_id=s.id WHERE s.suite='unstable' AND s.architecture='amd64' AND r.status = 'E404'
2018-07-23 15:32:39.337 UTC [31046] jenkins at reproducibledb LOG:  duration: 161985.336 ms  statement: SELECT COUNT(s.name) FROM results AS r JOIN sources AS s ON r.package_id=s.id WHERE s.suite='unstable' AND s.architecture='amd64' AND r.status = 'NFU'
2018-07-23 15:40:23.264 UTC [20592] jenkins at reproducibledb LOG:  duration: 133385.398 ms  statement: SELECT count(*) FROM sources WHERE suite='buster' AND architecture='amd64'
2018-07-23 15:40:27.422 UTC [37834] jenkins at reproducibledb LOG:  duration: 231389.702 ms  statement: SELECT COUNT(*) FROM (SELECT s.id FROM sources AS s JOIN results AS r ON r.package_id=s.id WHERE r.status IN ('FTBR', 'FTBFS', 'blacklisted') AND s.id NOT IN (SELECT package_id FROM notes) AND s.suite='buster' AND s.architecture='i386') tmp
2018-07-23 15:42:51.155 UTC [19631] jenkins at reproducibledb LOG:  duration: 1221602.258 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-07-23 15:47:40.357 UTC [8460] jenkins at reproducibledb LOG:  duration: 267412.527 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-07-22 15:43' AND r.architecture='amd64'
2018-07-23 17:11:15.673 UTC [16317] jenkins at reproducibledb LOG:  duration: 128709.422 ms  statement: 
2018-07-23 17:11:15.848 UTC [16233] jenkins at reproducibledb LOG:  duration: 132245.910 ms  statement: 
2018-07-23 17:11:17.654 UTC [62185] jenkins at reproducibledb LOG:  duration: 319952.000 ms  statement: SELECT count(results.id) AS count_1 
2018-07-23 17:12:51.233 UTC [13509] jenkins at reproducibledb LOG:  duration: 365416.615 ms  statement: SELECT COUNT(*) FROM results AS r JOIN sources AS s ON r.package_id=s.id WHERE s.suite='unstable' AND s.architecture='i386'
2018-07-23 17:21:25.729 UTC [1860] jenkins at reproducibledb LOG:  duration: 1120010.480 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-07-23 17:26:04.687 UTC [1860] jenkins at reproducibledb LOG:  duration: 257064.371 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-07-23 17:26:20.240 UTC [51489] jenkins at reproducibledb LOG:  duration: 627951.126 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2018-07-22 17:15' AND r.architecture='amd64'