desktop-packages team mailing list archive

[Martin Pitt <martin.pitt@xxxxxxxxxx>]

Public bug reported:

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

** Affects: postgresql-9.1 (Ubuntu)
     Importance: Undecided
         Status: Invalid

** Affects: postgresql-9.3 (Ubuntu)
     Importance: Undecided
         Status: Invalid

** Affects: postgresql-9.4 (Ubuntu)
     Importance: Undecided
     Assignee: Martin Pitt (pitti)
         Status: In Progress

** Affects: postgresql-9.1 (Ubuntu Precise)
     Importance: High
     Assignee: Martin Pitt (pitti)
         Status: In Progress

** Affects: postgresql-9.1 (Ubuntu Trusty)
     Importance: Undecided
         Status: New

** Affects: postgresql-9.3 (Ubuntu Trusty)
     Importance: Undecided
         Status: New

** Affects: postgresql-9.4 (Ubuntu Utopic)
     Importance: Undecided
         Status: New

** Affects: postgresql-9.4 (Ubuntu Vivid)
     Importance: Undecided
         Status: New

** Affects: postgresql-9.4 (Ubuntu Wily)
     Importance: Undecided
     Assignee: Martin Pitt (pitti)
         Status: In Progress

** Affects: postgresql-9.1 (Debian)
     Importance: Unknown
         Status: Unknown

** Description changed:

- Upstream will push out new microreleases after a pretty severe
+ 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
+   * 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

** Also affects: postgresql-9.3 (Ubuntu)
   Importance: Undecided
       Status: New

** Also affects: postgresql-9.4 (Ubuntu)
   Importance: Undecided
       Status: New

** Also affects: postgresql-9.1 (Ubuntu Trusty)
   Importance: Undecided
       Status: New

** Also affects: postgresql-9.3 (Ubuntu Trusty)
   Importance: Undecided
       Status: New

** Also affects: postgresql-9.4 (Ubuntu Trusty)
   Importance: Undecided
       Status: New

** Also affects: postgresql-9.1 (Ubuntu Vivid)
   Importance: Undecided
       Status: New

** Also affects: postgresql-9.3 (Ubuntu Vivid)
   Importance: Undecided
       Status: New

** Also affects: postgresql-9.4 (Ubuntu Vivid)
   Importance: Undecided
       Status: New

** Also affects: postgresql-9.1 (Ubuntu Wily)
   Importance: Undecided
       Status: New

** Also affects: postgresql-9.3 (Ubuntu Wily)
   Importance: Undecided
       Status: New

** Also affects: postgresql-9.4 (Ubuntu Wily)
   Importance: Undecided
       Status: New

** Also affects: postgresql-9.1 (Ubuntu Precise)
   Importance: Undecided
       Status: New

** Also affects: postgresql-9.3 (Ubuntu Precise)
   Importance: Undecided
       Status: New

** Also affects: postgresql-9.4 (Ubuntu Precise)
   Importance: Undecided
       Status: New

** Also affects: postgresql-9.1 (Ubuntu Utopic)
   Importance: Undecided
       Status: New

** Also affects: postgresql-9.3 (Ubuntu Utopic)
   Importance: Undecided
       Status: New

** Also affects: postgresql-9.4 (Ubuntu Utopic)
   Importance: Undecided
       Status: New

** No longer affects: postgresql-9.1 (Ubuntu Utopic)

** Bug watch added: Debian Bug tracker #786874
   http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=786874

** Also affects: postgresql-9.1 (Debian) via
   http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=786874
   Importance: Unknown
       Status: Unknown

** Summary changed:

- 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

** No longer affects: postgresql-9.1 (Ubuntu Wily)

** No longer affects: postgresql-9.4 (Ubuntu Precise)

** No longer affects: postgresql-9.4 (Ubuntu Trusty)

** No longer affects: postgresql-9.3 (Ubuntu Wily)

** No longer affects: postgresql-9.3 (Ubuntu Vivid)

** No longer affects: postgresql-9.3 (Ubuntu Utopic)

** No longer affects: postgresql-9.3 (Ubuntu Precise)

** Changed in: postgresql-9.3 (Ubuntu)
       Status: New => Invalid

** Changed in: postgresql-9.4 (Ubuntu Wily)
       Status: New => In Progress

** Changed in: postgresql-9.4 (Ubuntu Wily)
     Assignee: (unassigned) => Martin Pitt (pitti)

** Changed in: postgresql-9.1 (Ubuntu Precise)
   Importance: Undecided => High

** Changed in: postgresql-9.1 (Ubuntu Precise)
       Status: New => In Progress

** Changed in: postgresql-9.1 (Ubuntu Precise)
     Assignee: (unassigned) => Martin Pitt (pitti)

** No longer affects: postgresql-9.1 (Ubuntu Vivid)

** Changed in: postgresql-9.1 (Ubuntu)
       Status: New => Invalid

-- 
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to postgresql-9.1 in Ubuntu.
https://bugs.launchpad.net/bugs/1461425

Title:
  New upstream microreleases 9.1.17, 9.3.8, 9.4.3 - fixes regression in
  previous update

Status in postgresql-9.1 package in Ubuntu:
  Invalid
Status in postgresql-9.3 package in Ubuntu:
  Invalid
Status in postgresql-9.4 package in Ubuntu:
  In Progress
Status in postgresql-9.1 source package in Precise:
  In Progress
Status in postgresql-9.1 source package in Trusty:
  New
Status in postgresql-9.3 source package in Trusty:
  New
Status in postgresql-9.4 source package in Utopic:
  New
Status in postgresql-9.4 source package in Vivid:
  New
Status in postgresql-9.4 source package in Wily:
  In Progress
Status in postgresql-9.1 package in Debian:
  Unknown

Bug 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

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/postgresql-9.1/+bug/1461425/+subscriptions