Your message dated Thu, 04 Jun 2015 10:25:00 +0000 with message-id <[email protected]> and subject line Bug#784005: fixed in postgresql-common 169 has caused the Debian Bug report #784005, regarding Document dynamic_shared_memory_type gotchas on upgrade to be marked as done.
This means that you claim that the problem has been dealt with. If this is not the case it is now your responsibility to reopen the Bug report if necessary, and/or fix the problem forthwith. (NB: If you are a system administrator and have no idea what this message is talking about, this may indicate a serious mail system misconfiguration somewhere. Please contact [email protected] immediately.) -- 784005: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=784005 Debian Bug Tracking System Contact [email protected] with problems
--- Begin Message ---Source: postgresql-9.4 Version: 9.4.1-1 Severity: important I upgraded a server (a LXC-based container) from Wheezy to Jessie. After installing, everything looked OK, with the (live) 9.1 and (empty) 9.4 clusters running. Now, following the instructions at /usr/share/doc/postgresql-common/README.Debian.gz (section "Default clusters and upgrading") led to a seemingly correct cluster migration — Just at the final step, at the cluster restart time, I got: 2015-05-02 01:27:01 GMT FATAL: could not open shared memory segment "/PostgreSQL.1804289383": Function not implemented Increasing the log verbosity to DEBUG5 yielded: 2015-05-02 01:57:55 GMT DEBUG: postgres: PostmasterMain: initial environment dump: 2015-05-02 01:57:55 GMT DEBUG: ----------------------------------------- 2015-05-02 01:57:55 GMT DEBUG: PG_GRANDPARENT_PID=2343 2015-05-02 01:57:55 GMT DEBUG: PGLOCALEDIR=/usr/share/locale 2015-05-02 01:57:55 GMT DEBUG: PGSYSCONFDIR=/etc/postgresql-common 2015-05-02 01:57:55 GMT DEBUG: LANG=en_US.UTF-8 2015-05-02 01:57:55 GMT DEBUG: PWD=/var/lib/postgresql 2015-05-02 01:57:55 GMT DEBUG: PGDATA=/var/lib/postgresql/9.4/main 2015-05-02 01:57:55 GMT DEBUG: LC_COLLATE=en_US.UTF-8 2015-05-02 01:57:55 GMT DEBUG: LC_CTYPE=en_US.UTF-8 2015-05-02 01:57:55 GMT DEBUG: LC_MESSAGES=en_US.UTF-8 2015-05-02 01:57:55 GMT DEBUG: LC_MONETARY=C 2015-05-02 01:57:55 GMT DEBUG: LC_NUMERIC=C 2015-05-02 01:57:55 GMT DEBUG: LC_TIME=C 2015-05-02 01:57:55 GMT DEBUG: ----------------------------------------- 2015-05-02 01:57:56 GMT DEBUG: invoking IpcMemoryCreate(size=23822336) 2015-05-02 01:57:56 GMT DEBUG: mmap with MAP_HUGETLB failed, huge pages disabled: Cannot allocate memory 2015-05-02 01:57:56 GMT DEBUG: SlruScanDirectory invoking callback on pg_notify/0000 2015-05-02 01:57:56 GMT DEBUG: removing file "pg_notify/0000" 2015-05-02 01:57:56 GMT DEBUG: dynamic shared memory system will support 288 segments 2015-05-02 01:57:56 GMT FATAL: could not open shared memory segment "/PostgreSQL.1804289383": Function not implemented 2015-05-02 01:57:56 GMT DEBUG: shmem_exit(1): 0 before_shmem_exit callbacks to make 2015-05-02 01:57:56 GMT DEBUG: shmem_exit(1): 3 on_shmem_exit callbacks to make 2015-05-02 01:57:56 GMT DEBUG: proc_exit(1): 2 callbacks to make 2015-05-02 01:57:56 GMT DEBUG: exit(1) 2015-05-02 01:57:56 GMT DEBUG: shmem_exit(-1): 0 before_shmem_exit callbacks to make 2015-05-02 01:57:56 GMT DEBUG: shmem_exit(-1): 0 on_shmem_exit callbacks to make 2015-05-02 01:57:56 GMT DEBUG: proc_exit(-1): 0 callbacks to make Now, looking through the Web, this page gave me the needed insight: http://postgresql.nabble.com/Shared-memory-changes-in-9-4-td5804919.html The problem apparently happened because pg_upgradecluster uses my 9.1 config for 9.4, which does not include a part of the configuration. And following on the quoted webpage, I had to specify: dynamic_shared_memory_type = sysv As posix semantics seem not to work under LXC (or not under its default configuration). Thanks! -- System Information: Debian Release: 8.0 APT prefers unstable APT policy: (500, 'unstable') Architecture: amd64 (x86_64) Kernel: Linux 3.19.0-eudyptula5d12e3524822-00194-gd799964 (SMP w/4 CPU cores) Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/dash Init: systemd (via /run/systemd/system)
--- End Message ---
--- Begin Message ---Source: postgresql-common Source-Version: 169 We believe that the bug you reported is fixed in the latest version of postgresql-common, which is due to be installed in the Debian FTP archive. A summary of the changes between this version and the previous one is attached. Thank you for reporting the bug, which will now be closed. If you have further comments please address them to [email protected], and the maintainer will reopen the bug report if appropriate. Debian distribution maintenance software pp. Christoph Berg <[email protected]> (supplier of updated postgresql-common package) (This message was generated automatically at their request; if you believe that there is a problem with it please contact the archive administrators by mailing [email protected]) -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 Format: 1.8 Date: Thu, 04 Jun 2015 12:09:53 +0200 Source: postgresql-common Binary: postgresql-common postgresql-client-common postgresql-server-dev-all postgresql postgresql-client postgresql-doc postgresql-contrib Architecture: source all Version: 169 Distribution: unstable Urgency: medium Maintainer: Debian PostgreSQL Maintainers <[email protected]> Changed-By: Christoph Berg <[email protected]> Description: postgresql - object-relational SQL database (supported version) postgresql-client - front-end programs for PostgreSQL (supported version) postgresql-client-common - manager for multiple PostgreSQL client versions postgresql-common - PostgreSQL database-cluster manager postgresql-contrib - additional facilities for PostgreSQL (supported version) postgresql-doc - documentation for the PostgreSQL database management system postgresql-server-dev-all - extension build tool for multiple PostgreSQL versions Closes: 784005 Changes: postgresql-common (169) unstable; urgency=medium . * t/022_recovery.t: New recovery tests to catch regression in 9.4.2 and 9.1.16. * pg_upgradecluster: Set default dynamic_shared_memory_type = mmap. (Closes: #784005) * pg_upgradecluster: Complain if --link is used without --method=upgrade. * pg_upgradecluster: Better error message when old and new version are equal. Checksums-Sha1: d0807fae2ff1330342bd45c654f9d5550c71a1cf 2248 postgresql-common_169.dsc 2671f1575467c61f54f26cee11748f63ed662184 190152 postgresql-common_169.tar.xz 7b5d67c8111d5ae444258eaeb741b3163ae52276 59660 postgresql-server-dev-all_169_all.deb b27dd4aa7912d8fe009b00fd8c7303884313e785 52532 postgresql_9.4+169_all.deb 3e62e14d3eeecee91257df4705409eb1bba63f74 52550 postgresql-client_9.4+169_all.deb cbd67ae7281b019ae68eec123196b2c17b44e644 52540 postgresql-doc_9.4+169_all.deb 82e20cdcc68d162cab214bcf658fac0c688501ea 52544 postgresql-contrib_9.4+169_all.deb c5666d4415bce5c303f0bebb9852815e4e421f78 207882 postgresql-common_169_all.deb d1ff8230e4597fe204f98653024941cfc0c6c4d1 74340 postgresql-client-common_169_all.deb Checksums-Sha256: 4c3ebcac85811cf047fd162c18872678385b85e3b10d8bd5b33157bcc9f589df 2248 postgresql-common_169.dsc d2e9ef30c6b28908904b9e1303fa2ea747452c3bbcdb368cb47b1aa73807317b 190152 postgresql-common_169.tar.xz 0d980652a69c367aa6a4bd0438d640de097e9e01928cd0f834c5cc98a47b1003 59660 postgresql-server-dev-all_169_all.deb 532125e4273ea2aa04dab551e866ef4ec63132e52123390584d8a75342f199cc 52532 postgresql_9.4+169_all.deb 2e4379a8b79c82bce9691b202355b406ec8ece48bc010c42fc6647d3729aae62 52550 postgresql-client_9.4+169_all.deb 4378f8bae3a643abc694331efe04a4b3a6f1f664071f32d5e88a531dddf9d3e7 52540 postgresql-doc_9.4+169_all.deb 40bdf2ca2414db9ef2556d9d11d48078a79fa6496ebc2fac198df545f78b9132 52544 postgresql-contrib_9.4+169_all.deb 5ca6bde6257bd3a840c97421dd7d4eb654073fc3058c81495065385fcbb0ab4a 207882 postgresql-common_169_all.deb a50122ba745c468f156d00206375e457f41215225ab465c6fef00c64e28c0cbc 74340 postgresql-client-common_169_all.deb Files: da34ad996fd28e80eb21688c339639be 2248 database optional postgresql-common_169.dsc 0dddf9411633cd4ec48c5b62aa8b8d8f 190152 database optional postgresql-common_169.tar.xz ff599eb4ec47f372a699b25f45b8881b 59660 database optional postgresql-server-dev-all_169_all.deb 331f45a765beeb438776dc9d18c61d7b 52532 database optional postgresql_9.4+169_all.deb 410c5aa10554039d3f69ee187238468b 52550 database optional postgresql-client_9.4+169_all.deb ec1844b47746faff61ed591eb3dc9b74 52540 doc optional postgresql-doc_9.4+169_all.deb 791ba30e503955b42572447f52e3d5b7 52544 database optional postgresql-contrib_9.4+169_all.deb d4b49584f62371bddc2e2a5aa97bc26a 207882 database optional postgresql-common_169_all.deb 8671233563394d954f7609e8733f9e2d 74340 database optional postgresql-client-common_169_all.deb -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBCAAGBQJVcCUOAAoJEExaa6sS0qeuHu8P/jYNeeYI4oGldjsetAlLZn4m 8P8ZwB2CAlbufytzHu5Cim1pGncbnFNomae3f2eSJVoipFzuZCr3bSslCm01ZKHL kVnzcKPGeSf2gid7U99vPBdoZIhqaYmISXob5YdceupUe/cgo7XYPiStgpDTlCGD 3V6Z2/srVvJFBrqVqwUo/ADxWXnq1kWDuyC/sPJ+8v2B4n98fW9XjH79BcLCdGXg iu06+KOggBZpFeNvhDisdU+STSLWigNJWMrvHajZohgYmfVhnHl1GVaI3ceab1v4 8tEWK3S2F7j/1G+MBZfoGutOyqrKm9jYT6m4NcyDonV7G2Z7rM9MORtmOXcbZsBc BKjEt0/fsBmtLclvR97jN0/VvTFz6RBqfrtoZlxxa/uK5xYHv0DN0VfPNcFbh6Zp r5Ywm+T0eJyv5RU3PEy9BMu5ti0h+3jyj5ATQX1oY/wZQ9/s2h/pYf8c1OdELZfQ +N+fB2xs8bIQ4djzsWrfwQ/VRisFDTFiG34oF7Tx/d+yLk7rqPSwg3j4EPxCEjsN boypNxrVxUIwRT4En8Pjn7vedavLiGUxv0/bUV3Iq/fxvb6vZy62uNeg5JS6ljJD UTZDgQ3AmWXZZhpO1LwLP5iivmHkrrFSm8TEP1eLTDCtKCPxYP22KK24JO0lEdWM v7zS+kk2DeNqebeFDmkx =CzTX -----END PGP SIGNATURE-----
--- End Message ---
_______________________________________________ Pkg-postgresql-public mailing list [email protected] http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-postgresql-public
