Your message dated Thu, 04 Jun 2015 10:25:00 +0000
with message-id <e1z0ska-00011l...@franck.debian.org>
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 ow...@bugs.debian.org
immediately.)
--
784005: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=784005
Debian Bug Tracking System
Contact ow...@bugs.debian.org 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 784...@bugs.debian.org,
and the maintainer will reopen the bug report if appropriate.
Debian distribution maintenance software
pp.
Christoph Berg <m...@debian.org> (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 ftpmas...@ftp-master.debian.org)
-----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
<pkg-postgresql-public@lists.alioth.debian.org>
Changed-By: Christoph Berg <m...@debian.org>
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
Pkg-postgresql-public@lists.alioth.debian.org
http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-postgresql-public
