[Bug 221672] python27 / sqlite3 /usr/local/lib/libsqlite3.so.0: Undefined symbol "fdatasync"

[bugzilla-noreply at freebsd.org]

https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=221672

            Bug ID: 221672
           Summary: python27 / sqlite3 /usr/local/lib/libsqlite3.so.0:
                    Undefined symbol "fdatasync"
           Product: Ports & Packages
           Version: Latest
          Hardware: Any
                OS: Any
            Status: New
          Severity: Affects Only Me
          Priority: ---
         Component: Individual Port(s)
          Assignee: freebsd-ports-bugs at FreeBSD.org
          Reporter: torlik at mailoo.org
                CC: pavelivolkov at gmail.com, python at FreeBSD.org
                CC: pavelivolkov at gmail.com, python at FreeBSD.org

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 at 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 at 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 at 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"

-- 
You are receiving this mail because:
You are on the CC list for the bug.