Bug 221672

Summary: databases/sqlite3: Fails to import -- /usr/local/lib/libsqlite3.so.0: Undefined symbol "fdatasync"
Product: Ports & Packages Reporter: pstk <torlik>
Component: Individual Port(s)Assignee: freebsd-ports-bugs (Nobody) <ports-bugs>
Status: Closed Not A Bug    
Severity: Affects Only Me CC: pavelivolkov, python
Priority: --- Keywords: needs-qa
Version: LatestFlags: koobs: maintainer-feedback? (pavelivolkov)
Hardware: Any   
OS: Any   
See Also: https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=221438

Description pstk 2017-08-20 16:39:58 UTC
Poudriere build. 

# freebsd-version
11.1-RELEASE-p1


service sickrage start
Starting sickrage.
Traceback (most recent call last):
  File "/usr/local/www/sickrage/SickBeard.py", line 69, in <module>
    import sickbeard
  File "/usr/local/www/sickrage/sickbeard/__init__.py", line 43, in <module>
    from sickbeard.indexers import indexer_api
  File "/usr/local/www/sickrage/sickbeard/indexers/__init__.py", line 21, in <module>
    from . import indexer_api
  File "/usr/local/www/sickrage/sickbeard/indexers/indexer_api.py", line 26, in <module>
    from indexer_config import indexerConfig, initConfig
  File "/usr/local/www/sickrage/sickbeard/indexers/indexer_config.py", line 5, in <module>
    from sickbeard import helpers
  File "/usr/local/www/sickrage/sickbeard/helpers.py", line 57, in <module>
    from sickbeard import classes, db, logger
  File "/usr/local/www/sickrage/sickbeard/db.py", line 25, in <module>
    import sqlite3
  File "/usr/local/lib/python2.7/sqlite3/__init__.py", line 24, in <module>
    from dbapi2 import *
  File "/usr/local/lib/python2.7/sqlite3/dbapi2.py", line 28, in <module>
    from _sqlite3 import *
ImportError: /usr/local/lib/libsqlite3.so.0: Undefined symbol "fdatasync"
/usr/local/etc/rc.d/sickrage: WARNING: failed to start sickrage


pkg info py27-sqlite3
py27-sqlite3-2.7.13_7
Name           : py27-sqlite3
Version        : 2.7.13_7
Installed on   : Sun Aug 20 15:17:19 2017 CEST
Origin         : databases/py-sqlite3
Architecture   : FreeBSD:11:amd64
Prefix         : /usr/local
Categories     : python databases
Licenses       : PSFL
Maintainer     : python@FreeBSD.org
WWW            : UNKNOWN
Comment        : Standard Python binding to the SQLite3 library (Python 2.7)
Shared Libs required:
        libsqlite3.so.0
        libpython2.7.so.1
Annotations    :
        repo_type      : binary
        repository     : pkg



pkg info python27                                                                                                            python27-2.7.13_7
Name           : python27
Version        : 2.7.13_7
Installed on   : Mon Aug 14 03:56:42 2017 CEST
Origin         : lang/python27
Architecture   : FreeBSD:11:amd64
Prefix         : /usr/local
Categories     : python lang ipv6
Licenses       : PSFL
Maintainer     : python@FreeBSD.org
WWW            : https://www.python.org/
Comment        : Interpreted object-oriented programming language
Options        :
        DEBUG          : off
        IPV6           : on
        LIBFFI         : on
        NLS            : on
        PYMALLOC       : on
        THREADS        : on
        UCS2           : off
        UCS4           : on
Shared Libs required:
        libreadline.so.7
        libintl.so.8
        libffi.so.6
Shared Libs provided:
        libpython2.7.so.1
Annotations    :
        cpe            : cpe:2.3:a:python:python:2.7.13:::::freebsd11:x64:7
        repo_type      : binary
        repository     : pkg
Flat size      : 67.0MiB


 pkg info sqlite3
sqlite3-3.20.0_2
Name           : sqlite3
Version        : 3.20.0_2
Installed on   : Mon Aug 14 03:56:55 2017 CEST
Origin         : databases/sqlite3
Architecture   : FreeBSD:11:amd64
Prefix         : /usr/local
Categories     : databases
Licenses       : PD
Maintainer     : pavelivolkov@gmail.com
WWW            : https://www.sqlite.org/
Comment        : SQL database engine in a C library
Options        :
        ARMOR          : off
        DBSTAT         : on
        DIRECT_READ    : off
        EDITLINE       : off
        EXTENSION      : on
        FTS3_TOKEN     : on
        FTS4           : on
        FTS5           : off
        ICU            : off
        JSON1          : off
        LIKENOTBLOB    : off
        MEMMAN         : off
        METADATA       : on
        NULL_TRIM      : off
        RBU            : off
        READLINEP      : off
        READLINES      : on
        RTREE          : on
        RTREE_INT      : off
        SECURE_DELETE  : on
        SESSION        : off
        SOUNDEX        : off
        STAT3          : off
        STAT4          : off
        STMT           : off
        STSHELL        : on
        THREADS        : on
        TS0            : off
        TS1            : on
        TS2            : off
        TS3            : off
        UNICODE61      : on
        UNKNOWN_SQL    : off
        UNLOCK_NOTIFY  : on
        UPD_DEL_LIMIT  : off
        URI            : on
        URI_AUTHORITY  : off
Shared Libs required:
        libreadline.so.7
Shared Libs provided:
        libsqlite3.so.0
Annotations    :
        repo_type      : binary
        repository     : pkg
Flat size      : 2.95MiB



Script from #221438

#!/bin/sh
{
cat<< _EOF
create table t1( one varchar(10), two integer );
insert into t1 values( 'FreeBSD', 1 );
insert into t1 values( 'postfix', 2 );
insert into t1 values( 'sqlite3', 3 );
select * from t1
_EOF
} | sqlite3 /tmp/PR221438.sqlite

# sh test.sh
/usr/local/bin/sqlite3: Undefined symbol "fdatasync"
Comment 1 pstk 2017-08-21 09:33:03 UTC
fdatasync() also does not exist in 11.0, it was added in 11.1.
I hit this problem when trying to use packages built on 11.1 (via poudriere) on a 11.0 system.
Once I upgraded the systems to 11.1, the issues went away.

from https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=221438#c5

indeed :

# file /usr/jails/basejail/bin/sh   
/usr/jails/basejail/bin/sh: ELF 64-bit LSB executable, x86-64, version 1 (FreeBSD), dynamically linked, interpreter /libexec/ld-elf.so.1, for FreeBSD 11.0 (1100122), FreeBSD-style, stripped

i don't know why freebsd-version show me
# freebsd-version -u
11.1-RELEASE-p1

anyway, I have correctly update my basejail and issue has gone away.

sorry for your time