AIX Open Source

 View Only
Expand all | Collapse all

Symbol _GLOBAL__AIXD_libsqlite3_so error after applying AIX 7100-05-06-2016

Archive User

Archive UserSun May 17, 2020 10:23 PM

  • 1.  Symbol _GLOBAL__AIXD_libsqlite3_so error after applying AIX 7100-05-06-2016

    Posted Sun May 17, 2020 10:23 PM

    Originally posted by: kristianmilos


    Hi All,

     

    IBM over the weekend released service packs for AIX 7100-05-06-2016 and 7200-04-02-2016.

     

    After applying the service pack on some test LPAR's, and doing a yum update all, I get the following error on the 7100-05-06-2016 LPAR.
    The LPAR running 7200-04-02-2016 has no such issues and yum is functional.

     

    # oslevel -s
    7100-05-06-2016
    # yum
    exec(): 0509-036 Cannot load program /opt/freeware/bin/python2 because of the following errors:
            0509-130 Symbol resolution failed for /opt/freeware/lib/libpython2.7.so because:
            0509-136   Symbol _GLOBAL__AIXI_libsqlite3_so (number 219) is not exported from
                       dependent module /opt/freeware/lib/libsqlite3.so.
            0509-136   Symbol _GLOBAL__AIXD_libsqlite3_so (number 220) is not exported from
                       dependent module /opt/freeware/lib/libsqlite3.so.
            0509-026 System error: Error 0
            0509-192 Examine .loader section symbols with the
                     'dump -Tv' command.
    

    Any thoughts?

     

    Regards,
    Kristian



  • 2.  Re: Symbol _GLOBAL__AIXD_libsqlite3_so error after applying AIX 7100-05-06-2016

    Posted Mon May 18, 2020 02:39 AM

    Originally posted by: sangameshm


    Please let me know the output of below commands.

    ls -l /opt/freeware/lib/libsqlite3.so

    rpm -qf /opt/freeware/lib/libsqlite3.so

    lslpp -Lc rpm.rte

     

    Thanks,

    Sangamesh



  • 3.  Re: Symbol _GLOBAL__AIXD_libsqlite3_so error after applying AIX 7100-05-06-2016

    Posted Mon May 18, 2020 02:46 AM

    Originally posted by: kristianmilos


    Output below.

     

    # ls -l /opt/freeware/lib/libsqlite3.so
    -rwxr-xr-x    1 root     system      1929034 Jul 09 2017  /opt/freeware/lib/libsqlite3.so
    # rpm -qf /opt/freeware/lib/libsqlite3.so
    sqlite-3.28.0-1.ppc
    # lslpp -Lc rpm.rte
    #Package Name:Fileset:Level:State:PTF Id:Fix State:Type:Description:Destination Dir.:Uninstaller:Message Catalog:Message Set:Message Number:Parent:Automatic:EFIX Locked:Install Path:Build Date
    rpm.rte:rpm.rte:4.13.0.3: : :C: :RPM Package Manager: : : : : : :0:0:/:
    

     



  • 4.  Re: Symbol _GLOBAL__AIXD_libsqlite3_so error after applying AIX 7100-05-06-2016

    Posted Mon May 18, 2020 03:42 AM

    Originally posted by: sangameshm


    It looks like the rpm.rte update overwrote the rpm package libsqlite3.so which is incompatible with python.

    We resolved this kind of overwrite issue starting from 4.13.0.4 https://ftp.software.ibm.com/aix/freeSoftware/aixtoolbox/INSTALLP/ppc/README_rpm.rte.4.13.0.10

    What's the output of sum /opt/freeware/lib/libsqlite3.so ?

    As of now to resolve this YUM error please reinstall sqlite.

     

    Thanks,

    Sangamesh

     

     



  • 5.  Re: Symbol _GLOBAL__AIXD_libsqlite3_so error after applying AIX 7100-05-06-2016

    Posted Mon May 18, 2020 04:54 AM

    Originally posted by: sanket


    Hi Kristian,

     

    Just to be clear please reinstall sqlite rpm from AIX toolbox or from your repo.

    Lets us know if that resolve your issue or not. 



  • 6.  Re: Symbol _GLOBAL__AIXD_libsqlite3_so error after applying AIX 7100-05-06-2016

    Posted Mon May 18, 2020 07:43 PM

    Originally posted by: kristianmilos


    I reinstalled sqlite, but that then threw another error with bz.so (see below), so I needed to also reinstall bzip2, and now YUM is functional again.

     

    rtld: 0712-001 Symbol _GLOBAL__AIXI_libbz2_so was referenced
          from module /opt/freeware/lib/python2.7/lib-dynload/bz2.so(), but a runtime definition
          of the symbol was not found.
    rtld: 0712-001 Symbol _GLOBAL__AIXD_libbz2_so was referenced
          from module /opt/freeware/lib/python2.7/lib-dynload/bz2.so(), but a runtime definition
          of the symbol was not found.
    

     

    The broader question I'd like to ask though, is that 7100-05-06-2016 via FixCentral contains rpm.rte.4.13.0.3.I. I'd say many people are going to follow a similar upgrade path like I did. Apply the service pack, and then perform a yum update all (resulting in the problem I had above). Shouldn't the updated rpm.rte be delivered via the service pack downloaded from FixCentral?



  • 7.  Re: Symbol _GLOBAL__AIXD_libsqlite3_so error after applying AIX 7100-05-06-2016

    Posted Mon May 18, 2020 10:54 PM

    Originally posted by: kristianmilos


    I've done some further testing, and it appears YUM is functional after the AIX patching...it's only after the yum update does it break.

    See the output below.

     

    Before apply AIX patch.

    # oslevel -s
    7100-05-05-1939
    # lslpp -l | grep rpm.rte
      rpm.rte                   4.13.0.3  COMMITTED  RPM Package Manager
      rpm.rte                   4.13.0.3  COMMITTED  RPM Package Manager
    # yum --version
    3.4.3
      Installed: yum-3.4.3-7.noarch at 2019-12-03 04:03
      Built    : None at 2019-03-04 11:12
      Committed: Sangamesh Mallayya <sangamesh.swamy@in.ibm.com> at 2019-03-05
    

     

    Updated AIX from 7100-05-05-1939 to 7100-05-06-2016 and YUM is still functional

     

    # oslevel -s
    7100-05-06-2016
    # lslpp -l | grep rpm.rte
      rpm.rte                  4.13.0.11  COMMITTED  RPM Package Manager
      rpm.rte                  4.13.0.11  COMMITTED  RPM Package Manager
    # yum --version
    3.4.3
      Installed: yum-3.4.3-7.noarch at 2019-12-03 04:03
      Built    : None at 2019-03-04 11:12
      Committed: Sangamesh Mallayya <sangamesh.swamy@in.ibm.com> at 2019-03-05
    

     

    It's only after a yum update does YUM break.

     

    # yum check-update
    bzip2.ppc              1.0.8-2
    coreutils.ppc          8.29-4
    curl.ppc               7.67.0-2
    expat.ppc              2.2.9-1
    expect.ppc             5.45.4-1
    gettext.ppc            0.19.8.1-5
    git.ppc                2.20.2-1
    info.ppc               6.6-2
    krb5-libs.ppc          1.16.1-4
    libgcc.ppc             8.3.0-2
    libpcap.ppc            1.9.1-1
    libstdc++.ppc          8.3.0-2
    logrotate.ppc          3.14.0-4
    ncurses.ppc            6.2-1
    pcre.ppc               8.43-1
    perl.ppc               1:5.28.1-2
    python.ppc             2.7.17-1
    python-devel.ppc       2.7.17-1
    python-tools.ppc       2.7.17-1
    python3.ppc            3.7.6-1
    python3-devel.ppc      3.7.6-1
    python3-docs.ppc       3.7.6-1
    python3-test.ppc       3.7.6-1
    rsync.ppc              3.1.3-5
    screen.ppc             4.7.0-1
    tcl.ppc                8.6.8-3
    tk.ppc                 8.6.8-3
    vim-common.ppc         8.1.2130-2
    vim-enhanced.ppc       8.1.2130-2
    zsh.ppc                5.5.1-1
    # yum -y update
    ...
    ...
    ...
    << output supressed, but it completed successfully >>
    # yum --version
    exec(): 0509-036 Cannot load program /opt/freeware/bin/python2 because of the following errors:
            0509-130 Symbol resolution failed for /opt/freeware/lib/libpython2.7.so because:
            0509-136   Symbol _GLOBAL__AIXI_libsqlite3_so (number 219) is not exported from
                       dependent module /opt/freeware/lib/libsqlite3.so.
            0509-136   Symbol _GLOBAL__AIXD_libsqlite3_so (number 220) is not exported from
                       dependent module /opt/freeware/lib/libsqlite3.so.
            0509-026 System error: Error 0
            0509-192 Examine .loader section symbols with the
                     'dump -Tv' command.
    

     



  • 8.  Re: Symbol _GLOBAL__AIXD_libsqlite3_so error after applying AIX 7100-05-06-2016

    Posted Tue May 19, 2020 09:28 AM

    Originally posted by: sanket


    Thank you Kristian for info. We will look into it.



  • 9.  Re: Symbol _GLOBAL__AIXD_libsqlite3_so error after applying AIX 7100-05-06-2016

    Posted Thu May 21, 2020 01:46 AM

    Originally posted by: sangameshm


    Hi Kristian,

     

    Could you please provide the complete output of yum update ?

    The version of rpm.rte in 7100-05-05-1939 & also in 7100-05-06-2016 is 4.13.0.3. Not sure how you have got the version 4.13.0.11 installed after AIX update.

    The one possibility where the python2 could fails is that after SP update it would have updated rpm.rte to 4.13.0.3 which would overwrite the libsqlite installed by an sqlite rpm package.

    Please provide the output of  "sum /opt/freeware/lib/libsqlite3.so"

    As we have fixed this overwrite issue from rpm.rte-4.13.0.4, this kind of issues won't be seen if user installed rpm.rte higher than 4.13.0.3 through YUM or other way in 7.1 TL5.

    Workaround solution in case is to reinstall sqlite and may be other library rpm.rte-4.13.0.3 is overwriting.

     

    Thanks,

    Sangamesh

     

     



  • 10.  RE: Re: Symbol _GLOBAL__AIXD_libsqlite3_so error after applying AIX 7100-05-06-2016

    Posted Wed March 17, 2021 05:51 AM
    Hi, are there any news to this subject?
    Today I finally got yum running on AIX 7.2 Tl3 SP3 with latest rpm.rte - after I installed some additional packages using yum, yum updated some of the existing ones which ended up in breaking up yum itself. Actually it is paython2 which is now broken but which is used by yum:

    >python
    exec(): 0509-036 Cannot load program python because of the following errors:
    0509-130 Symbol resolution failed for /opt/freeware/lib/libpython2.7.so because:
    0509-136 Symbol _GLOBAL__AIXI_libsqlite3_so (number 219) is not exported from
    dependent module /usr/opt/rpm/lib/libsqlite3.so.
    0509-136 Symbol _GLOBAL__AIXD_libsqlite3_so (number 220) is not exported from
    dependent module /usr/opt/rpm/lib/libsqlite3.so.
    0509-192 Examine .loader section symbols with the
    'dump -Tv' command.

    Any reinstallation, downgrading or wahtever of the sqlite package could not solve this issue.

    Current version of RPM is 4.15.1.1

    Best,
    Frank



    ------------------------------
    Fiducia und GAD IT AG AIX-Admins
    ------------------------------



  • 11.  RE: Re: Symbol _GLOBAL__AIXD_libsqlite3_so error after applying AIX 7100-05-06-2016

    Posted Wed March 17, 2021 05:57 AM
    Please reinstall the sqlite rpm package and let us know if it works.

    ------------------------------
    SANGAMESH
    ------------------------------



  • 12.  RE: Re: Symbol _GLOBAL__AIXD_libsqlite3_so error after applying AIX 7100-05-06-2016

    Posted Wed March 17, 2021 06:26 AM
    root@gxpnim02:/ltb/RPMS/ppc >rpm -qa|grep -i sql
    pysqlite-1.1.7-2.ppc
    sqlite-3.15.2-1.ppc
    root@gxpnim02:/ltb/RPMS/ppc >ls sqlit*
    sqlite-3.32.3-1.aix6.1.ppc.rpm sqlite-devel-3.32.3-1.aix6.1.ppc.rpm sqlite-doc-3.32.3-1.aix6.1.ppc.rpm
    root@gxpnim02:/ltb/RPMS/ppc >rpm -Uhv sqlite-3.32.3-1.aix6.1.ppc.rpm
    Verifying... ################################# [100%]
    Preparing... ################################# [100%]
    Updating / installing...
    1:sqlite-3.32.3-1 ################################# [ 50%]
    Cleaning up / removing...
    2:sqlite-3.15.2-1 ################################# [100%]
    root@gxpnim02:/ltb/RPMS/ppc >yum search all
    There was a problem importing one of the Python modules
    required to run yum. The error leading to this problem was:

    0509-022 Cannot load module /usr/opt/rpm/lib/librpm.so.
    0509-150 Dependent module /opt/freeware/lib/liblua.a(liblua-5.3.so) could not be loaded.
    0509-152 Member liblua-5.3.so is not found in archive
    0509-022 Cannot load module /opt/freeware/lib/python2.7/site-packages/rpm/_rpm.so.
    0509-150 Dependent module /usr/opt/rpm/lib/librpm.so could not be loaded.

    Please install a package which provides this module, or
    verify that the module is installed correctly.

    It's possible that the above module doesn't match the
    current version of Python, which is:
    2.7.18 (default, May 4 2020, 03:46:51)
    [GCC 8.3.0]

    If you cannot solve this problem yourself, please go to
    the yum faq at:
    http://yum.baseurl.org/wiki/Faq


    Actually I've removed sqlite before, than reinstalled 3.15 - that did not fix the issue (same behavior as before). I have now tried to upgrade (as above) and now the next package seems to be in error

    ------------------------------
    Frank
    ------------------------------



  • 13.  RE: Re: Symbol _GLOBAL__AIXD_libsqlite3_so error after applying AIX 7100-05-06-2016

    Posted Wed March 17, 2021 07:17 AM
    You might also need to reinstall the Lua with the latest version.
    Could you please paste the output of "rpm -qa" ?

    ------------------------------
    SANGAMESH
    ------------------------------



  • 14.  RE: Re: Symbol _GLOBAL__AIXD_libsqlite3_so error after applying AIX 7100-05-06-2016

    Posted Thu March 18, 2021 04:51 AM
    Edited by Fiducia und GAD IT AG AIX-Admins Thu March 18, 2021 07:34 AM
    Actually everything ends up in a complete mess: I've reinstalled the lua package, next error message was reagrding python - after having reinstalled python as well I am now at this point:

    root@gxpnim02:/ltb/RPMS/ppc >yum search all
    ERROR:root:code for hash md5 was not found.
    Traceback (most recent call last):
    File "/opt/freeware/lib/python2.7/hashlib.py", line 147, in <module>
    globals()[__func_name] = __get_hash(__func_name)
    File "/opt/freeware/lib/python2.7/hashlib.py", line 97, in __get_builtin_constructor
    raise ValueError('unsupported hash type ' + name)
    ValueError: unsupported hash type md5
    ERROR:root:code for hash sha1 was not found.
    Traceback (most recent call last):
    File "/opt/freeware/lib/python2.7/hashlib.py", line 147, in <module>
    globals()[__func_name] = __get_hash(__func_name)
    File "/opt/freeware/lib/python2.7/hashlib.py", line 97, in __get_builtin_constructor
    raise ValueError('unsupported hash type ' + name)
    ValueError: unsupported hash type sha1
    ERROR:root:code for hash sha224 was not found.
    Traceback (most recent call last):
    File "/opt/freeware/lib/python2.7/hashlib.py", line 147, in <module>
    globals()[__func_name] = __get_hash(__func_name)
    File "/opt/freeware/lib/python2.7/hashlib.py", line 97, in __get_builtin_constructor
    raise ValueError('unsupported hash type ' + name)
    ValueError: unsupported hash type sha224
    ERROR:root:code for hash sha256 was not found.
    Traceback (most recent call last):
    File "/opt/freeware/lib/python2.7/hashlib.py", line 147, in <module>
    globals()[__func_name] = __get_hash(__func_name)
    File "/opt/freeware/lib/python2.7/hashlib.py", line 97, in __get_builtin_constructor
    raise ValueError('unsupported hash type ' + name)
    ValueError: unsupported hash type sha256
    ERROR:root:code for hash sha384 was not found.
    Traceback (most recent call last):
    File "/opt/freeware/lib/python2.7/hashlib.py", line 147, in <module>
    globals()[__func_name] = __get_hash(__func_name)
    File "/opt/freeware/lib/python2.7/hashlib.py", line 97, in __get_builtin_constructor
    raise ValueError('unsupported hash type ' + name)
    ValueError: unsupported hash type sha384
    ERROR:root:code for hash sha512 was not found.
    Traceback (most recent call last):
    File "/opt/freeware/lib/python2.7/hashlib.py", line 147, in <module>
    globals()[__func_name] = __get_hash(__func_name)
    File "/opt/freeware/lib/python2.7/hashlib.py", line 97, in __get_builtin_constructor
    raise ValueError('unsupported hash type ' + name)
    ValueError: unsupported hash type sha512
    There was a problem importing one of the Python modules
    required to run yum. The error leading to this problem was:

    0509-022 Cannot load module /opt/freeware/lib/python2.7/site-packages/pycurl.so.
    0509-150 Dependent module /opt/freeware/lib/libcrypto.a(libcrypto.so) could not be loaded.
    0509-152 Member libcrypto.so is not found in archive
    0509-022 Cannot load module /opt/freeware/lib/python2.7/site-packages/pycurl.so.
    0509-150 Dependent module /opt/freeware/lib/python2.7/site-packages/pycurl.so could not be loaded.

    Please install a package which provides this module, or
    verify that the module is installed correctly.


    Output of rpm -qa:
     >rpm -qa
    bash-doc-3.2-8.ppc
    freetype2-2.3.9-1.ppc
    libart_lgpl-2.3.21-1.ppc
    openssl-0.9.7d-2.ppc
    pci.df1000fd-0002-271304-1.noarch
    rsync-64bit-3.0.6-1.ppc
    xcursor-1.1.7-3.ppc
    tk-8.4.7-3.ppc
    pcre-8.33-1.ppc
    lpar2rrd-agent-6.10-0.ppc
    ca-certificates-2020.06.01-1.ppc
    pysqlite-1.1.7-2.ppc
    yum-3.4.3-8.noarch
    xz-libs-5.2.5-1.ppc
    libffi-3.2.1-3.ppc
    libtextstyle-0.20.2-1.ppc
    info-6.6-2.ppc
    createrepo-0.10.3-3.noarch
    bash-4.3-12.ppc
    gtk2-2.10.6-3.ppc
    libtiff-3.8.2-1.ppc
    pci.df1000fa-1-191A5.noarch
    rrdtool-1.2.30-5.ppc
    wget-1.9-2.ppc
    tcl-8.4.7-3.ppc
    pci.1014034a.51-18518200-1.noarch
    netsnmp-5.7.3-1.1.ppc
    libnghttp2-1.41.0-1.ppc
    yum-metadata-parser-1.1.4-2.ppc
    python-urlgrabber-3.10.1-1.noarch
    libgcc-8-1.ppc
    ncurses-6.2-2.ppc
    libgomp-8-1.ppc
    libunistring-0.9.10-1.ppc
    readline-8.0-2.ppc
    bzip2-1.0.8-2.ppc
    python-deltarpm-3.6-1.ppc
    sqlite-3.32.3-1.ppc
    python-2.7.18-1.ppc
    atk-1.12.3-2.ppc
    cairo-1.8.6-3.ppc
    ibm.scsi.disk.CH15K5-C80F-1.noarch
    libpng-1.2.32-2.ppc
    pci.14101103-CN0120-1.noarch
    popt-1.14-1.ppc
    unzip-64bit-6.0-3.ppc
    zip-3.0-2.ppc
    openldap-2.4.40-1.ppc
    httpd-2.4.18-1.ppc
    jq-1.5-1.ppc
    zlib-1.2.11-1.ppc
    python-pycurl-7.19.3-1.ppc
    libgcc8-8.3.0-4.ppc
    libstdc++-8-1.ppc
    libgomp8-8.3.0-4.ppc
    libxml2-2.9.10-1.ppc
    gettext-0.20.2-1.ppc
    xz-5.2.5-1.ppc
    deltarpm-3.6-1.ppc
    python-tools-2.7.18-1.ppc
    fontconfig-2.4.2-1.ppc
    libjpeg-6b-6.ppc
    pango-1.14.5-3.ppc
    pixman-0.12.0-3.ppc
    screen-4.0.3-1.ppc
    xft-2.1.6-5.ppc
    expect-5.42.1-3.ppc
    db-4.8.24-3.ppc
    mod_ssl-2.4.18-1.ppc
    wazuh-agent-4.1.0-1.ppc
    libssh2-1.9.0-1.ppc
    python-iniparse-0.4-1.noarch
    curl-7.52.1-1.ppc
    libstdc++8-8.3.0-4.ppc
    expat-2.2.9-2.ppc
    libiconv-1.16-1.ppc
    glib2-2.56.1-2.ppc
    gdbm-1.18.1-1.ppc
    libxml2-python-2.9.10-1.ppc
    python-devel-2.7.18-1.ppc
    lua-5.3.4-2.ppc
    AIX-rpm-7.2.3.15-14.ppc

    ------------------------------
    Fiducia und GAD IT AG AIX-Admins
    ------------------------------



  • 15.  RE: Re: Symbol _GLOBAL__AIXD_libsqlite3_so error after applying AIX 7100-05-06-2016

    Posted Thu March 18, 2021 12:28 PM
    Please check this
    https://community.ibm.com/community/user/power/communities/community-home/digestviewer/viewthread?MessageKey=220d7f91-8824-42ec-8af9-c081d245b533&CommunityKey=10c1d831-47ee-4d92-a138-b03f7896f7c9&tab=digestviewer#bm220d7f91-8824-42ec-8af9-c081d245b533.

    You need to remove openssl rpm and install latest openssl fileset.

    ------------------------------
    SANGAMESH
    ------------------------------