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

Sun Jun 9 01:42:30 BST 2019

2019-06-08 02:30:36.279 UTC [7338] jenkins at reproducibledb LOG:  duration: 514000.379 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-06-08 02:36:05.999 UTC [7338] jenkins at reproducibledb LOG:  duration: 309085.344 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-06-08 02:38:27.877 UTC [7338] jenkins at reproducibledb LOG:  duration: 136267.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 
2019-06-08 03:05:59.530 UTC [25740] jenkins at reproducibledb LOG:  duration: 146120.307 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2019-06-07 03:03' AND r.architecture='amd64'
2019-06-08 14:07:01.875 UTC [39332] jenkins at reproducibledb LOG:  duration: 206920.728 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2019-06-07 14:03' AND r.architecture='amd64'
2019-06-08 14:09:31.108 UTC [2807] jenkins at reproducibledb LOG:  duration: 148309.329 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-06-08 15:23:28.570 UTC [40936] jenkins at reproducibledb ERROR:  update or delete on table "sources" violates foreign key constraint "schedule_tmp_package_id_fkey" on table "schedule"
2019-06-08 15:23:28.570 UTC [40936] jenkins at reproducibledb DETAIL:  Key (id)=(723378) is still referenced from table "schedule".
2019-06-08 15:23:28.570 UTC [40936] jenkins at reproducibledb STATEMENT:  DELETE FROM sources WHERE suite LIKE 'alpine_%';
2019-06-08 15:26:43.181 UTC [60771] jenkins at reproducibledb ERROR:  update or delete on table "sources" violates foreign key constraint "results_tmp_package_id_fkey1" on table "results"
2019-06-08 15:26:43.181 UTC [60771] jenkins at reproducibledb DETAIL:  Key (id)=(724595) is still referenced from table "results".
2019-06-08 15:26:43.181 UTC [60771] jenkins at reproducibledb STATEMENT:  DELETE FROM sources WHERE suite LIKE 'alpine_%';
2019-06-08 15:27:18.429 UTC [62615] jenkins at reproducibledb ERROR:  update or delete on table "sources" violates foreign key constraint "results_tmp_package_id_fkey1" on table "results"
2019-06-08 15:27:18.429 UTC [62615] jenkins at reproducibledb DETAIL:  Key (id)=(724595) is still referenced from table "results".
2019-06-08 15:27:18.429 UTC [62615] jenkins at reproducibledb STATEMENT:  DELETE FROM sources WHERE suite LIKE 'alpine_%';
2019-06-08 19:07:30.784 UTC [339] jenkins at reproducibledb LOG:  duration: 241473.545 ms  statement: SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > '2019-06-07 19:03' AND r.architecture='amd64'
2019-06-08 19:16:12.802 UTC [56121] jenkins at reproducibledb ERROR:  duplicate key value violates unique constraint "stats_build_tmp_name_version_suite_architecture_build_date_key1"
2019-06-08 19:16:12.802 UTC [56121] jenkins at reproducibledb DETAIL:  Key (name, version, suite, architecture, build_date)=(perl-log-log4perl, 1.49-5, archlinux_extra, x86_64, 2019-06-08 19:14:00) already exists.
2019-06-08 19:16:12.802 UTC [56121] jenkins at reproducibledb STATEMENT:  INSERT INTO stats_build (name, version, suite, architecture, distribution, status, build_date, build_duration, node1, node2, job)
			VALUES ('perl-log-log4perl', '1.49-5', 'archlinux_extra', 'x86_64', 3, 'GOOD', '2019-06-08 19:14', '109', 'osuosl-build170-amd64', 'osuosl-build169-amd64', 'https://jenkins.debian.net/job/reproducible_builder_archlinux_6/35060/');
2019-06-08 23:34:09.177 UTC [47868] jenkins at reproducibledb ERROR:  null value in column "name" violates not-null constraint
2019-06-08 23:34:09.177 UTC [47868] jenkins at reproducibledb DETAIL:  Failing row contains (731509, null, null, trunk, null, 0, 5).
2019-06-08 23:34:09.177 UTC [47868] jenkins at reproducibledb STATEMENT:  INSERT INTO sources (name, version, suite, architecture, distribution) VALUES (NULL, NULL, 'trunk', NULL, 5) RETURNING sources.id
2019-06-08 23:34:10.149 UTC [47961] jenkins at reproducibledb ERROR:  null value in column "name" violates not-null constraint
2019-06-08 23:34:10.149 UTC [47961] jenkins at reproducibledb DETAIL:  Failing row contains (731510, null, null, trunk, null, 0, 5).
2019-06-08 23:34:10.149 UTC [47961] jenkins at reproducibledb STATEMENT:  INSERT INTO sources (name, version, suite, architecture, distribution) VALUES (NULL, NULL, 'trunk', NULL, 5) RETURNING sources.id
2019-06-08 23:34:11.124 UTC [48017] jenkins at reproducibledb ERROR:  null value in column "name" violates not-null constraint
2019-06-08 23:34:11.124 UTC [48017] jenkins at reproducibledb DETAIL:  Failing row contains (731511, null, null, trunk, null, 0, 5).
2019-06-08 23:34:11.124 UTC [48017] jenkins at reproducibledb STATEMENT:  INSERT INTO sources (name, version, suite, architecture, distribution) VALUES (NULL, NULL, 'trunk', NULL, 5) RETURNING sources.id
2019-06-08 23:34:12.157 UTC [48050] jenkins at reproducibledb ERROR:  null value in column "name" violates not-null constraint
2019-06-08 23:34:12.157 UTC [48050] jenkins at reproducibledb DETAIL:  Failing row contains (731512, null, null, trunk, null, 0, 5).
2019-06-08 23:34:12.157 UTC [48050] jenkins at reproducibledb STATEMENT:  INSERT INTO sources (name, version, suite, architecture, distribution) VALUES (NULL, NULL, 'trunk', NULL, 5) RETURNING sources.id