pkg/44215: postgresql90-client is broken on OpenSolaris

[Aleksej Saushev <asau%inbox.ru@localhost>]

>Number:         44215
>Category:       pkg
>Synopsis:       postgresql90-client is broken on OpenSolaris
>Confidential:   no
>Severity:       serious
>Priority:       high
>Responsible:    pkg-manager
>State:          open
>Class:          sw-bug
>Submitter-Id:   net
>Arrival-Date:   Fri Dec 10 11:55:00 +0000 2010
>Originator:     Aleksej Saushev <asau%inbox.ru@localhost>
>Release:        SunOS 5.11 i86pc
>Organization:
HE CE3OH...
>Environment:
System: SunOS 5.11 i86pc
>Description:
        pg_ctl and psql crash (dump core)

        Sample stack traces:

$ pstack core
core 'core' of 13554:       /opt/pkg/bin/pg_ctl --help
 fe93c135 _init    (fe670b94, feffb334, 1, feffb394, fe93c120, 0) + 15
 fefd13e6 call_init (fe670b78, 1, fef903f8, 10) + 106
 fefd02eb setup    (8047cb8, 8047d18, 0, 8047fdf, 1000, fefbf961) + 154f
 fefde3f8 _setup   (8047c68, 3fb28, 3, 8047cac, 4, 8047cb8) + 310
 fefc46a4 _rt_boot (8047d94, 0, 8047d9b, 8047e00, 8047e04, 8047e20) + 56
 08047d80 ???????? ()

$ pstack core
core 'core' of 11942:       psql -U pgsql template1
 fe93c135 _init    (fe670cf4, feffb334, 1, feffb394, fe93c120, 0) + 15
 fefd13e6 call_init (fe670cd8, 1, fef903f8, 10) + 106
 fefd02eb setup    (8047ca0, 8047cfc, 0, 8047fe1, 1000, fefbf961) + 154f
 fefde3f8 _setup   (8047c48, 3fb28, 3, 8047c8c, 4, 8047ca0) + 310
 fefc46a4 _rt_boot (8047d69, 8047d6c, 8047d72, 0, 8047d7c, 8047d98) + 56
 08047d64 ???????? ()


        Dynamic dependencies list looks suspicious:

$ ldd $(which psql)
  libpq.so.5 =>    /opt/pkg/lib/libpq.so.5
        libssl.so.0.9.8 =>       /lib/libssl.so.0.9.8
   libcrypto.so.0.9.8 =>    /lib/libcrypto.so.0.9.8
        libz.so.1 =>     /lib/libz.so.1
 libreadline.so.6 =>      /opt/pkg/lib/libreadline.so.6
  libnsl.so.1 =>   /lib/libnsl.so.1
       libsocket.so.1 =>        /lib/libsocket.so.1
    libm.so.2 =>     /lib/libm.so.2
 libintl.so.3 =>  /opt/pkg/lib/libintl.so.3
      libc.so.1 =>     /lib/libc.so.1
 libssl.so.0.9.8 =>       /opt/pkg/lib/libssl.so.0.9.8
   libcrypto.so.0.9.8 =>    /opt/pkg/lib/libcrypto.so.0.9.8
        libiconv.so.2 =>         /opt/pkg/lib/libiconv.so.2
     libpthread.so.1 =>       /lib/libpthread.so.1
   librt.so.1 =>    /lib/librt.so.1
        libgcc_s.so.1 =>         /usr/sfw/lib/libgcc_s.so.1
     libcurses.so.1 =>        /lib/libcurses.so.1
    libmp.so.2 =>    /lib/libmp.so.2
        libmd.so.1 =>    /lib/libmd.so.1
        libscf.so.1 =>   /lib/libscf.so.1
       libdl.so.1 =>    /lib/libdl.so.1
        libuutil.so.1 =>         /lib/libuutil.so.1
     libgen.so.1 =>   /lib/libgen.so.1
       libsmbios.so.1 =>        /usr/lib/libsmbios.so.1


        Note two versions of libssl and libcrypto libraries.


        For reference, another client on this machine works fine:

$ /opt/local/bin/psql -U pgsql template1
Welcome to psql 8.3.7 (server 9.0.1), the PostgreSQL interactive terminal.

...

        Its dynamic dependencies are:

$ ldd /opt/local/bin/psql
     libpq.so.5 =>    /opt/local/lib/libpq.so.5
      libintl.so.3 =>  /opt/local/lib/libintl.so.3
    libssl.so.0.9.8 =>       /opt/local/lib/libssl.so.0.9.8
 libcrypto.so.0.9.8 =>    /opt/local/lib/libcrypto.so.0.9.8
      libz.so.1 =>     /lib/libz.so.1
 libreadline.so.6 =>      /opt/local/lib/libreadline.so.6
        libsocket.so.1 =>        /lib/libsocket.so.1
    libm.so.2 =>     /lib/libm.so.2
 libc.so.1 =>     /lib/libc.so.1
 libpthread.so.1 =>       /lib/libpthread.so.1
   librt.so.1 =>    /lib/librt.so.1
        libgcc_s.so.1 =>         /usr/sfw/lib/libgcc_s.so.1
     libiconv.so.2 =>         /opt/local/lib/libiconv.so.2
   libnsl.so.1 =>   /lib/libnsl.so.1
       libdl.so.1 =>    /lib/libdl.so.1
        libncurses.so.5 =>       /opt/local/lib/libncurses.so.5
 libmp.so.2 =>    /lib/libmp.so.2
        libmd.so.1 =>    /lib/libmd.so.1
        libscf.so.1 =>   /lib/libscf.so.1
       libuutil.so.1 =>         /lib/libuutil.so.1
     libgen.so.1 =>   /lib/libgen.so.1
       libsmbios.so.1 =>        /usr/lib/libsmbios.so.1



        Just in case it may be relevant, compiler used:

$ gcc --version
gcc (GCC) 3.4.3 (csl-sol210-3_4-20050802)

>How-To-Repeat:
        Build and install postgresql90-client, to connect to database server.
        Try running either "pg_ctl --help" or "psql --help".
        Observe crashes.
>Fix:
        Not yet.

        Workaround is to build client package without OpenSSL support:

Index: Makefile
===================================================================
RCS file: /cvsroot/pkgsrc/databases/postgresql90-client/Makefile,v
retrieving revision 1.2
diff -u -r1.2 Makefile
--- Makefile       3 Nov 2010 14:36:41 -0000       1.2
+++ Makefile 10 Dec 2010 11:25:18 -0000
@@ -9,7 +9,7 @@
 
 USE_TOOLS+=          gzip tar
 USE_LIBTOOL=           yes
-CONFIGURE_ARGS+=    --with-openssl
+CONFIGURE_ARGS+= --without-openssl
 CONFIGURE_ARGS+=      --with-readline
 CONFIGURE_ARGS+=        --with-zlib
 
@@ -51,7 +51,7 @@
 
 .include "../../devel/readline/buildlink3.mk"
 .include "../../devel/zlib/buildlink3.mk"
-.include "../../security/openssl/buildlink3.mk"
+#.include "../../security/openssl/buildlink3.mk"
 
 SUBST_CLASSES+=                pgxs
 SUBST_STAGE.pgxs=  post-build