Activity log for bug #1461425

Date Who What changed Old value New value Message
2015-06-03 07:18:54 Martin Pitt bug added bug
2015-06-03 07:19:25 Martin Pitt description Upstream will push out new microreleases after a pretty severe regression in the previous rounds of updates: https://wiki.postgresql.org/wiki/May_2015_Fsync_Permissions_Bug#I.27ve_hit_this_bug_and_I_can.27t_restart_Postgres._What_do_I_do.3F This particularly affects 9.1 due to the way we handle SSL certificates, i. e. Ubuntu 12.04. Later releases are much less affected as we don't have to symlink the certificate there any more. Reproducer: * install postgresql-9.1 * pkill -SEGV postgres * service postgresql start With 9.1.16 this will fail with The PostgreSQL server failed to start. Please check the log output: 2015-06-03 09:16:35 CEST LOG: database system was interrupted; last known up at 2015-06-03 09:15:27 CEST 2015-06-03 09:16:35 CEST FATAL: could not open file "/etc/ssl/private/ssl-cert-snakeoil.key": Permission denied 2015-06-03 09:16:35 CEST LOG: startup process (PID 10527) exited with exit code 1 2015-06-03 09:16:35 CEST LOG: aborting startup due to startup process failure Upstream will push out new microreleases tomrorw after a pretty severe regression in the previous rounds of updates: https://wiki.postgresql.org/wiki/May_2015_Fsync_Permissions_Bug#I.27ve_hit_this_bug_and_I_can.27t_restart_Postgres._What_do_I_do.3F This particularly affects 9.1 due to the way we handle SSL certificates, i. e. Ubuntu 12.04. Later releases are much less affected as we don't have to symlink the certificate there any more. Reproducer:   * install postgresql-9.1   * pkill -SEGV postgres   * service postgresql start With 9.1.16 this will fail with The PostgreSQL server failed to start. Please check the log output: 2015-06-03 09:16:35 CEST LOG: database system was interrupted; last known up at 2015-06-03 09:15:27 CEST 2015-06-03 09:16:35 CEST FATAL: could not open file "/etc/ssl/private/ssl-cert-snakeoil.key": Permission denied 2015-06-03 09:16:35 CEST LOG: startup process (PID 10527) exited with exit code 1 2015-06-03 09:16:35 CEST LOG: aborting startup due to startup process failure
2015-06-03 07:19:34 Martin Pitt bug task added postgresql-9.3 (Ubuntu)
2015-06-03 07:19:39 Martin Pitt bug task added postgresql-9.4 (Ubuntu)
2015-06-03 07:19:49 Martin Pitt nominated for series Ubuntu Trusty
2015-06-03 07:19:49 Martin Pitt bug task added postgresql-9.1 (Ubuntu Trusty)
2015-06-03 07:19:49 Martin Pitt bug task added postgresql-9.3 (Ubuntu Trusty)
2015-06-03 07:19:49 Martin Pitt bug task added postgresql-9.4 (Ubuntu Trusty)
2015-06-03 07:19:49 Martin Pitt nominated for series Ubuntu Vivid
2015-06-03 07:19:49 Martin Pitt bug task added postgresql-9.1 (Ubuntu Vivid)
2015-06-03 07:19:49 Martin Pitt bug task added postgresql-9.3 (Ubuntu Vivid)
2015-06-03 07:19:49 Martin Pitt bug task added postgresql-9.4 (Ubuntu Vivid)
2015-06-03 07:19:49 Martin Pitt nominated for series Ubuntu Wily
2015-06-03 07:19:49 Martin Pitt bug task added postgresql-9.1 (Ubuntu Wily)
2015-06-03 07:19:49 Martin Pitt bug task added postgresql-9.3 (Ubuntu Wily)
2015-06-03 07:19:49 Martin Pitt bug task added postgresql-9.4 (Ubuntu Wily)
2015-06-03 07:19:49 Martin Pitt nominated for series Ubuntu Precise
2015-06-03 07:19:49 Martin Pitt bug task added postgresql-9.1 (Ubuntu Precise)
2015-06-03 07:19:49 Martin Pitt bug task added postgresql-9.3 (Ubuntu Precise)
2015-06-03 07:19:49 Martin Pitt bug task added postgresql-9.4 (Ubuntu Precise)
2015-06-03 07:19:49 Martin Pitt nominated for series Ubuntu Utopic
2015-06-03 07:19:49 Martin Pitt bug task added postgresql-9.1 (Ubuntu Utopic)
2015-06-03 07:19:49 Martin Pitt bug task added postgresql-9.3 (Ubuntu Utopic)
2015-06-03 07:19:49 Martin Pitt bug task added postgresql-9.4 (Ubuntu Utopic)
2015-06-03 07:20:01 Martin Pitt bug task deleted postgresql-9.1 (Ubuntu Utopic)
2015-06-03 07:21:29 Martin Pitt bug watch added http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=786874
2015-06-03 07:21:29 Martin Pitt bug task added postgresql-9.1 (Debian)
2015-06-03 07:21:52 Martin Pitt summary New upstream microreleases 9.1.17, 9.3.8, 9.4.3 New upstream microreleases 9.1.17, 9.3.8, 9.4.3 - fixes regression in previous update
2015-06-03 07:22:10 Martin Pitt bug task deleted postgresql-9.1 (Ubuntu Wily)
2015-06-03 07:24:06 Martin Pitt bug task deleted postgresql-9.4 (Ubuntu Precise)
2015-06-03 07:24:11 Martin Pitt bug task deleted postgresql-9.4 (Ubuntu Trusty)
2015-06-03 07:24:19 Martin Pitt bug task deleted postgresql-9.3 (Ubuntu Wily)
2015-06-03 07:24:25 Martin Pitt bug task deleted postgresql-9.3 (Ubuntu Vivid)
2015-06-03 07:24:30 Martin Pitt bug task deleted postgresql-9.3 (Ubuntu Utopic)
2015-06-03 07:24:37 Martin Pitt bug task deleted postgresql-9.3 (Ubuntu Precise)
2015-06-03 07:24:46 Martin Pitt postgresql-9.3 (Ubuntu): status New Invalid
2015-06-03 07:24:59 Martin Pitt postgresql-9.4 (Ubuntu Wily): status New In Progress
2015-06-03 07:24:59 Martin Pitt postgresql-9.4 (Ubuntu Wily): assignee Martin Pitt (pitti)
2015-06-03 07:25:16 Martin Pitt postgresql-9.1 (Ubuntu Precise): importance Undecided High
2015-06-03 07:25:16 Martin Pitt postgresql-9.1 (Ubuntu Precise): status New In Progress
2015-06-03 07:25:16 Martin Pitt postgresql-9.1 (Ubuntu Precise): assignee Martin Pitt (pitti)
2015-06-03 07:25:26 Martin Pitt bug task deleted postgresql-9.1 (Ubuntu Vivid)
2015-06-03 07:25:35 Martin Pitt postgresql-9.1 (Ubuntu): status New Invalid
2015-06-03 07:31:43 Martin Pitt description Upstream will push out new microreleases tomrorw after a pretty severe regression in the previous rounds of updates: https://wiki.postgresql.org/wiki/May_2015_Fsync_Permissions_Bug#I.27ve_hit_this_bug_and_I_can.27t_restart_Postgres._What_do_I_do.3F This particularly affects 9.1 due to the way we handle SSL certificates, i. e. Ubuntu 12.04. Later releases are much less affected as we don't have to symlink the certificate there any more. Reproducer:   * install postgresql-9.1   * pkill -SEGV postgres   * service postgresql start With 9.1.16 this will fail with The PostgreSQL server failed to start. Please check the log output: 2015-06-03 09:16:35 CEST LOG: database system was interrupted; last known up at 2015-06-03 09:15:27 CEST 2015-06-03 09:16:35 CEST FATAL: could not open file "/etc/ssl/private/ssl-cert-snakeoil.key": Permission denied 2015-06-03 09:16:35 CEST LOG: startup process (PID 10527) exited with exit code 1 2015-06-03 09:16:35 CEST LOG: aborting startup due to startup process failure Upstream will push out new microreleases tomrorw after a pretty severe regression in the previous rounds of updates: https://wiki.postgresql.org/wiki/May_2015_Fsync_Permissions_Bug#I.27ve_hit_this_bug_and_I_can.27t_restart_Postgres._What_do_I_do.3F This particularly affects 9.1 due to the way we handle SSL certificates, i. e. Ubuntu 12.04. Later releases are much less affected as we don't have to symlink the certificate there any more. SRU TEST CASE:   * install postgresql-9.1   * pkill -SEGV postgres   * service postgresql start With 9.1.16 this will fail with The PostgreSQL server failed to start. Please check the log output: 2015-06-03 09:16:35 CEST LOG: database system was interrupted; last known up at 2015-06-03 09:15:27 CEST 2015-06-03 09:16:35 CEST FATAL: could not open file "/etc/ssl/private/ssl-cert-snakeoil.key": Permission denied 2015-06-03 09:16:35 CEST LOG: startup process (PID 10527) exited with exit code 1 2015-06-03 09:16:35 CEST LOG: aborting startup due to startup process failure With 9.1.17 (or earlier versions than 9.1.16) this should succeed.
2015-06-03 07:31:52 Martin Pitt bug added subscriber Ubuntu Stable Release Updates Team
2015-06-03 07:31:57 Martin Pitt tags regression-release
2015-06-03 07:39:11 Martin Pitt description Upstream will push out new microreleases tomrorw after a pretty severe regression in the previous rounds of updates: https://wiki.postgresql.org/wiki/May_2015_Fsync_Permissions_Bug#I.27ve_hit_this_bug_and_I_can.27t_restart_Postgres._What_do_I_do.3F This particularly affects 9.1 due to the way we handle SSL certificates, i. e. Ubuntu 12.04. Later releases are much less affected as we don't have to symlink the certificate there any more. SRU TEST CASE:   * install postgresql-9.1   * pkill -SEGV postgres   * service postgresql start With 9.1.16 this will fail with The PostgreSQL server failed to start. Please check the log output: 2015-06-03 09:16:35 CEST LOG: database system was interrupted; last known up at 2015-06-03 09:15:27 CEST 2015-06-03 09:16:35 CEST FATAL: could not open file "/etc/ssl/private/ssl-cert-snakeoil.key": Permission denied 2015-06-03 09:16:35 CEST LOG: startup process (PID 10527) exited with exit code 1 2015-06-03 09:16:35 CEST LOG: aborting startup due to startup process failure With 9.1.17 (or earlier versions than 9.1.16) this should succeed. Upstream will push out new microreleases tomorrow after a pretty severe regression in the previous rounds of updates: https://wiki.postgresql.org/wiki/May_2015_Fsync_Permissions_Bug#I.27ve_hit_this_bug_and_I_can.27t_restart_Postgres._What_do_I_do.3F This particularly affects 9.1 due to the way we handle SSL certificates, i. e. Ubuntu 12.04. Later releases are much less affected as we don't have to symlink the certificate there any more. SRU TEST CASE:   * install postgresql-9.1   * pkill -SEGV postgres   * service postgresql start With 9.1.16 this will fail with The PostgreSQL server failed to start. Please check the log output: 2015-06-03 09:16:35 CEST LOG: database system was interrupted; last known up at 2015-06-03 09:15:27 CEST 2015-06-03 09:16:35 CEST FATAL: could not open file "/etc/ssl/private/ssl-cert-snakeoil.key": Permission denied 2015-06-03 09:16:35 CEST LOG: startup process (PID 10527) exited with exit code 1 2015-06-03 09:16:35 CEST LOG: aborting startup due to startup process failure With 9.1.17 (or earlier versions than 9.1.16) this should succeed.
2015-06-03 08:09:38 Martin Pitt postgresql-9.4 (Ubuntu Utopic): status New In Progress
2015-06-03 08:09:48 Martin Pitt postgresql-9.4 (Ubuntu Vivid): status New In Progress
2015-06-03 08:17:55 Martin Pitt postgresql-9.1 (Ubuntu Trusty): status New In Progress
2015-06-03 08:22:49 Martin Pitt postgresql-9.3 (Ubuntu Trusty): status New In Progress
2015-06-03 15:09:40 Chris J Arges postgresql-9.3 (Ubuntu Trusty): status In Progress Fix Committed
2015-06-03 15:09:44 Chris J Arges bug added subscriber SRU Verification
2015-06-03 15:09:50 Chris J Arges tags regression-release regression-release verification-needed
2015-06-03 15:11:03 Chris J Arges postgresql-9.1 (Ubuntu Precise): status In Progress Fix Committed
2015-06-03 15:11:37 Chris J Arges postgresql-9.1 (Ubuntu Trusty): status In Progress Fix Committed
2015-06-03 15:12:42 Chris J Arges postgresql-9.4 (Ubuntu Utopic): status In Progress Fix Committed
2015-06-03 16:18:49 Martin Pitt postgresql-9.4 (Ubuntu Utopic): status Fix Committed In Progress
2015-06-03 16:35:35 Bug Watch Updater postgresql-9.1 (Debian): status Unknown New
2015-06-04 17:34:20 Bug Watch Updater postgresql-9.1 (Debian): status New Fix Released
2015-06-06 10:13:47 Martin Pitt postgresql-9.4 (Ubuntu Wily): status In Progress Fix Committed
2015-06-06 11:10:56 Martin Pitt postgresql-9.4 (Ubuntu Wily): status Fix Committed Fix Released
2015-06-06 19:33:20 Ubuntu Foundations Team Bug Bot bug added subscriber Brian Murray
2015-06-06 19:33:22 Ubuntu Foundations Team Bug Bot tags regression-release verification-needed regression-release verification-failed verification-needed
2015-06-07 19:31:04 Martin Pitt tags regression-release verification-failed verification-needed regression-release verification-needed
2015-06-07 20:49:01 Paul Collins bug added subscriber The Canonical Sysadmins
2015-06-08 07:37:23 Åsmund Grammeltvedt bug added subscriber Åsmund Grammeltvedt
2015-06-09 11:28:33 Martin Pitt tags regression-release verification-needed regression-release verification-done-precise
2015-06-09 11:29:08 Martin Pitt tags regression-release verification-done-precise regression-release verification-done-precise verification-done-trusty
2015-06-09 12:54:32 Chris J Arges postgresql-9.4 (Ubuntu Utopic): status In Progress Fix Committed
2015-06-09 12:54:40 Chris J Arges tags regression-release verification-done-precise verification-done-trusty regression-release verification-done-precise verification-done-trusty verification-needed
2015-06-09 12:56:54 Chris J Arges postgresql-9.4 (Ubuntu Vivid): status In Progress Fix Committed
2015-06-09 13:04:29 Launchpad Janitor postgresql-9.1 (Ubuntu Precise): status Fix Committed Fix Released
2015-06-09 13:04:51 Launchpad Janitor postgresql-9.1 (Ubuntu Trusty): status Fix Committed Fix Released
2015-06-10 12:20:28 Martin Pitt tags regression-release verification-done-precise verification-done-trusty verification-needed regression-release verification-done
2015-06-10 18:14:43 Launchpad Janitor postgresql-9.3 (Ubuntu Trusty): status Fix Committed Fix Released
2015-06-10 18:14:49 Chris J Arges removed subscriber Ubuntu Stable Release Updates Team
2015-06-17 17:22:06 Launchpad Janitor postgresql-9.4 (Ubuntu Utopic): status Fix Committed Fix Released
2015-06-17 17:22:33 Launchpad Janitor postgresql-9.4 (Ubuntu Vivid): status Fix Committed Fix Released
2015-06-22 18:09:36 Launchpad Janitor branch linked lp:ubuntu/trusty-proposed/postgresql-9.3
2015-06-22 18:09:51 Launchpad Janitor branch linked lp:ubuntu/trusty-updates/postgresql-9.3
2015-06-22 20:42:53 Launchpad Janitor branch linked lp:ubuntu/vivid-proposed/postgresql-9.4
2015-06-22 20:43:09 Launchpad Janitor branch linked lp:ubuntu/utopic-proposed/postgresql-9.4