Error building make test

[ekawahyu]

I am on High Sierra. I tried to follow the given instruction to build litetree on my machine and it gave me some errors as follows:

macoss-iMac:litetree macos$ make test
cd test && python test.py -v
test00_read_config (__main__.TestSQLiteBranches) ... ERROR
test01_branches (__main__.TestSQLiteBranches) ... FAIL
test02_branch_info (__main__.TestSQLiteBranches) ... FAIL
test02_branch_tree (__main__.TestSQLiteBranches) ... ERROR
test02b_sql_log (__main__.TestSQLiteBranches) ... ERROR
test03_reading_branches_at_the_same_time (__main__.TestSQLiteBranches) ... FAIL
test04_concurrent_access (__main__.TestSQLiteBranches) ... FAIL
test05_single_connection_uri (__main__.TestSQLiteBranches) ... FAIL
test06_invalid_branch_name (__main__.TestSQLiteBranches) ... ERROR
test07_rename_branch (__main__.TestSQLiteBranches) ... FAIL
test08_truncate_branch (__main__.TestSQLiteBranches) ... ERROR
test09_delete_branch (__main__.TestSQLiteBranches) ... FAIL
test10_rollback (__main__.TestSQLiteBranches) ... ERROR
test11_attached_dbs (__main__.TestSQLiteBranches) ... FAIL
test12_temporary_db (__main__.TestSQLiteBranches) ... FAIL
test13_discard_commits (__main__.TestSQLiteBranches) ... FAIL
test14_forward_merge (__main__.TestSQLiteBranches) ... FAIL
test15_forward_merge (__main__.TestSQLiteBranches) ... FAIL
test18_savepoints (__main__.TestSQLiteBranches) ... ERROR
test19_closed_connection (__main__.TestSQLiteBranches) ... ERROR
test20_open_while_writing (__main__.TestSQLiteBranches) ... ERROR
test21_internal_temporary_dbs (__main__.TestSQLiteBranches) ... ERROR
test22_normal_sqlite (__main__.TestSQLiteBranches) ... ok

Anything I can trace from the log? where are they located?

EDIT: I fixed the formatting, it did not go well with the code tag

[hanlsin]

Hi @ekawahyu,

Sorry for the late response. I will look into the problem and come back soon. Please wait for a moment.

[hanlsin]

When you run make test, is that all the message you found?

I think the detail message should follow this message.

For example, like this

$ make test                                                                                
cd test && python test.py -v                                                               
test00_read_config (__main__.TestSQLiteBranches) ... ERROR                                 
test01_branches (__main__.TestSQLiteBranches) ... FAIL                                     
test02_branch_info (__main__.TestSQLiteBranches) ... FAIL                                  
test02_branch_tree (__main__.TestSQLiteBranches) ... ERROR                                 
test02b_sql_log (__main__.TestSQLiteBranches) ... ERROR                                    
test03_reading_branches_at_the_same_time (__main__.TestSQLiteBranches) ... FAIL            
test04_concurrent_access (__main__.TestSQLiteBranches) ... FAIL                            
test05_single_connection_uri (__main__.TestSQLiteBranches) ... FAIL                        
test06_invalid_branch_name (__main__.TestSQLiteBranches) ... ERROR                                                                                 
test07_rename_branch (__main__.TestSQLiteBranches) ... FAIL                                
test08_truncate_branch (__main__.TestSQLiteBranches) ... ERROR                             
test09_delete_branch (__main__.TestSQLiteBranches) ... FAIL                                                                                                                 
test10_rollback (__main__.TestSQLiteBranches) ... ERROR                                                                                                                                         
test11_attached_dbs (__main__.TestSQLiteBranches) ... FAIL                                 
test12_temporary_db (__main__.TestSQLiteBranches) ... FAIL                                 
test13_discard_commits (__main__.TestSQLiteBranches) ... FAIL                              
test14_forward_merge (__main__.TestSQLiteBranches) ... FAIL                                
test15_forward_merge (__main__.TestSQLiteBranches) ... FAIL                                          
test18_savepoints (__main__.TestSQLiteBranches) ... ERROR                                  
test19_closed_connection (__main__.TestSQLiteBranches) ... ERROR                                        
test20_open_while_writing (__main__.TestSQLiteBranches) ... ERROR                          
test21_internal_temporary_dbs (__main__.TestSQLiteBranches) ... ERROR                      
test22_normal_sqlite (__main__.TestSQLiteBranches) ... FAIL                                
                                                                      
======================================================================                     
ERROR: test00_read_config (__main__.TestSQLiteBranches)                                                                     
----------------------------------------------------------------------                                                       
Traceback (most recent call last):                                                                              
  File "test.py", line 49, in test00_read_config                                           
    if c.fetchone()[0] == "disabled":                                                      
TypeError: 'NoneType' object has no attribute '__getitem__'

...

Please let me know more detail message from it.

[ekawahyu]

This is the errors from make test, sorry it was not formatted properly in github:

macoss-iMac:litetree macos$ make test
cd test && python test.py -v
test00_read_config (__main__.TestSQLiteBranches) ... ERROR
test01_branches (__main__.TestSQLiteBranches) ... FAIL
test02_branch_info (__main__.TestSQLiteBranches) ... FAIL
test02_branch_tree (__main__.TestSQLiteBranches) ... ERROR
test02b_sql_log (__main__.TestSQLiteBranches) ... ERROR
test03_reading_branches_at_the_same_time (__main__.TestSQLiteBranches) ... FAIL
test04_concurrent_access (__main__.TestSQLiteBranches) ... FAIL
test05_single_connection_uri (__main__.TestSQLiteBranches) ... FAIL
test06_invalid_branch_name (__main__.TestSQLiteBranches) ... ERROR
test07_rename_branch (__main__.TestSQLiteBranches) ... FAIL
test08_truncate_branch (__main__.TestSQLiteBranches) ... ERROR
test09_delete_branch (__main__.TestSQLiteBranches) ... FAIL
test10_rollback (__main__.TestSQLiteBranches) ... ERROR
test11_attached_dbs (__main__.TestSQLiteBranches) ... FAIL
test12_temporary_db (__main__.TestSQLiteBranches) ... FAIL
test13_discard_commits (__main__.TestSQLiteBranches) ... FAIL
test14_forward_merge (__main__.TestSQLiteBranches) ... FAIL
test15_forward_merge (__main__.TestSQLiteBranches) ... FAIL
test18_savepoints (__main__.TestSQLiteBranches) ... ERROR
test19_closed_connection (__main__.TestSQLiteBranches) ... ERROR
test20_open_while_writing (__main__.TestSQLiteBranches) ... ERROR
test21_internal_temporary_dbs (__main__.TestSQLiteBranches) ... ERROR
test22_normal_sqlite (__main__.TestSQLiteBranches) ... ok

======================================================================
ERROR: test00_read_config (__main__.TestSQLiteBranches)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "test.py", line 47, in test00_read_config
	if c.fetchone()[0] == "disabled":
TypeError: 'NoneType' object has no attribute '__getitem__'
.
.
.

[hanlsin]

Thanks @ekawahyu

This error would come from using Python3 instead of Python2.

Would you check python --version?

[ekawahyu]

Python 2.7.10 is installed:

Python 2.7.10 (default, Oct  6 2017, 22:29:07) 
[GCC 4.2.1 Compatible Apple LLVM 9.0.0 (clang-900.0.31)] on darwin
Type "help", "copyright", "credits" or "license" for more information.
dlopen("/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/lib-dynload/	readline.so", 2);
import readline # dynamically loaded from /System/Library/Frameworks/Python.framework/	Versions/2.7/lib/python2.7/lib-dynload/readline.so
>>> 

[kroggen]

Hi!

You should follow the compilation instructions before running the tests

[ekawahyu]

@kroggen I followed exactly the steps in the README, except the LMDB installation

[kroggen]

Why not? Was it already installed?

Redo all the instructions and send the result of the compilation and installation.

It is clear that the test is using the native SQLite library instead of the new one.

[ekawahyu]

@kroggen Yeah, the LMDB was already installed. However, I did clean up everything per your suggestion and redo every steps in the instruction:

macoss-iMac:others macos$ git clone https://github.com/lmdb/lmdb
Cloning into 'lmdb'...
remote: Enumerating objects: 8189, done.
remote: Total 8189 (delta 0), reused 0 (delta 0), pack-reused 8189
Receiving objects: 100% (8189/8189), 1.95 MiB | 2.45 MiB/s, done.
Resolving deltas: 100% (3524/3524), done.
macoss-iMac:others macos$ cd lmdb/libraries/liblmdb
macoss-iMac:liblmdb macos$ make
gcc -pthread -O2 -g -W -Wall -Wno-unused-parameter -Wbad-function-cast -Wuninitialized   -c mdb.c
mdb.c:10052:20: warning: missing field 'mc_backup' initializer [-Wmissing-field-initializers]
		MDB_cursor mc = {0};
						  ^
mdb.c:10211:18: warning: missing field 'mc_txn' initializer [-Wmissing-field-initializers]
		mdb_copy my = {0};
						^
2 warnings generated.
gcc -pthread -O2 -g -W -Wall -Wno-unused-parameter -Wbad-function-cast -Wuninitialized   -c midl.c
ar rs liblmdb.a mdb.o midl.o
ar: creating archive liblmdb.a
gcc -pthread -O2 -g -W -Wall -Wno-unused-parameter -Wbad-function-cast -Wuninitialized  -fPIC  -c mdb.c -o mdb.lo
mdb.c:10052:20: warning: missing field 'mc_backup' initializer [-Wmissing-field-initializers]
		MDB_cursor mc = {0};
						  ^
mdb.c:10211:18: warning: missing field 'mc_txn' initializer [-Wmissing-field-initializers]
		mdb_copy my = {0};
						^
2 warnings generated.
gcc -pthread -O2 -g -W -Wall -Wno-unused-parameter -Wbad-function-cast -Wuninitialized  -fPIC  -c midl.c -o midl.lo
gcc  -pthread -shared -o liblmdb.so mdb.lo midl.lo 
clang: warning: argument unused during compilation: '-pthread' [-Wunused-command-line-argument]
gcc -pthread -O2 -g -W -Wall -Wno-unused-parameter -Wbad-function-cast -Wuninitialized   -c mdb_stat.c
gcc -pthread -O2 -g -W -Wall -Wno-unused-parameter -Wbad-function-cast -Wuninitialized   mdb_stat.o liblmdb.a  -o mdb_stat
clang: warning: argument unused during compilation: '-pthread' [-Wunused-command-line-argument]
gcc -pthread -O2 -g -W -Wall -Wno-unused-parameter -Wbad-function-cast -Wuninitialized   -c mdb_copy.c
gcc -pthread -O2 -g -W -Wall -Wno-unused-parameter -Wbad-function-cast -Wuninitialized   mdb_copy.o liblmdb.a  -o mdb_copy
clang: warning: argument unused during compilation: '-pthread' [-Wunused-command-line-argument]
gcc -pthread -O2 -g -W -Wall -Wno-unused-parameter -Wbad-function-cast -Wuninitialized   -c mdb_dump.c
gcc -pthread -O2 -g -W -Wall -Wno-unused-parameter -Wbad-function-cast -Wuninitialized   mdb_dump.o liblmdb.a  -o mdb_dump
clang: warning: argument unused during compilation: '-pthread' [-Wunused-command-line-argument]
gcc -pthread -O2 -g -W -Wall -Wno-unused-parameter -Wbad-function-cast -Wuninitialized   -c mdb_load.c
gcc -pthread -O2 -g -W -Wall -Wno-unused-parameter -Wbad-function-cast -Wuninitialized   mdb_load.o liblmdb.a  -o mdb_load
clang: warning: argument unused during compilation: '-pthread' [-Wunused-command-line-argument]
gcc -pthread -O2 -g -W -Wall -Wno-unused-parameter -Wbad-function-cast -Wuninitialized   -c mdb_drop.c
gcc -pthread -O2 -g -W -Wall -Wno-unused-parameter -Wbad-function-cast -Wuninitialized   mdb_drop.o liblmdb.a  -o mdb_drop
clang: warning: argument unused during compilation: '-pthread' [-Wunused-command-line-argument]
gcc -pthread -O2 -g -W -Wall -Wno-unused-parameter -Wbad-function-cast -Wuninitialized   -c mtest.c
gcc -pthread -O2 -g -W -Wall -Wno-unused-parameter -Wbad-function-cast -Wuninitialized   mtest.o liblmdb.a  -o mtest
clang: warning: argument unused during compilation: '-pthread' [-Wunused-command-line-argument]
gcc -pthread -O2 -g -W -Wall -Wno-unused-parameter -Wbad-function-cast -Wuninitialized   -c mtest2.c
gcc -pthread -O2 -g -W -Wall -Wno-unused-parameter -Wbad-function-cast -Wuninitialized   mtest2.o liblmdb.a  -o mtest2
clang: warning: argument unused during compilation: '-pthread' [-Wunused-command-line-argument]
gcc -pthread -O2 -g -W -Wall -Wno-unused-parameter -Wbad-function-cast -Wuninitialized   -c mtest3.c
gcc -pthread -O2 -g -W -Wall -Wno-unused-parameter -Wbad-function-cast -Wuninitialized   mtest3.o liblmdb.a  -o mtest3
clang: warning: argument unused during compilation: '-pthread' [-Wunused-command-line-argument]
gcc -pthread -O2 -g -W -Wall -Wno-unused-parameter -Wbad-function-cast -Wuninitialized   -c mtest4.c
gcc -pthread -O2 -g -W -Wall -Wno-unused-parameter -Wbad-function-cast -Wuninitialized   mtest4.o liblmdb.a  -o mtest4
clang: warning: argument unused during compilation: '-pthread' [-Wunused-command-line-argument]
gcc -pthread -O2 -g -W -Wall -Wno-unused-parameter -Wbad-function-cast -Wuninitialized   -c mtest5.c
gcc -pthread -O2 -g -W -Wall -Wno-unused-parameter -Wbad-function-cast -Wuninitialized   mtest5.o liblmdb.a  -o mtest5
clang: warning: argument unused during compilation: '-pthread' [-Wunused-command-line-argument]
macoss-iMac:liblmdb macos$ sudo make install
mkdir -p /usr/local/bin
mkdir -p /usr/local/lib
mkdir -p /usr/local/include
mkdir -p /usr/local/share/man/man1
for f in mdb_stat mdb_copy mdb_dump mdb_load mdb_drop; do cp $f /usr/local/bin; done
for f in liblmdb.a liblmdb.so; do cp $f /usr/local/lib; done
for f in lmdb.h; do cp $f /usr/local/include; done
for f in mdb_stat.1 mdb_copy.1 mdb_dump.1 mdb_load.1 mdb_drop.1; do cp $f /usr/local/share/man/man1; done
macoss-iMac:liblmdb macos$ cd ~
macoss-iMac:others macos$ git clone https://github.com/aergoio/litetree
Cloning into 'litetree'...
remote: Enumerating objects: 62, done.
remote: Counting objects: 100% (62/62), done.
remote: Compressing objects: 100% (47/47), done.
remote: Total 555 (delta 36), reused 34 (delta 15), pack-reused 493
Receiving objects: 100% (555/555), 5.64 MiB | 1.79 MiB/s, done.
Resolving deltas: 100% (354/354), done.
macoss-iMac:others macos$ cd litetree/
macoss-iMac:litetree macos$ make

gcc -Wall -I/usr/local/include  -fPIC -DSQLITE_USE_URI=1 -DSQLITE_ENABLE_JSON1 -DSQLITE_THREADSAFE=1 -DHAVE_USLEEP -DSQLITE_ENABLE_COLUMN_METADATA -c sqlite3.c -o sqlite3.o
gcc -dynamiclib -install_name "/usr/local/lib/litetree/libsqlite3.dylib" -current_version 1.0.0 -compatibility_version 1.0.0 sqlite3.o -o liblitetree.0.dylib  -L/usr/local/lib -llmdb -lpthread
strip -x liblitetree.0.dylib
install_name_tool -change liblmdb.so /usr/local/lib/liblmdb.so liblitetree.0.dylib
ln -sf liblitetree.0.dylib liblitetree.dylib
ln -sf liblitetree.0.dylib libsqlite3.0.dylib
ln -sf liblitetree.0.dylib libsqlite3.dylib
gcc -c -DHAVE_READLINE shell.c -o shell.o
gcc shell.o -o sqlite3 -L. -lsqlite3 -ldl -lreadline
strip sqlite3
macoss-iMac:litetree macos$ 
macoss-iMac:litetree macos$ sudo make install
mkdir -p /usr/local/lib
mkdir -p /usr/local/lib/litetree
cp liblitetree.0.dylib /usr/local/lib/
cd /usr/local/lib && ln -sf liblitetree.0.dylib liblitetree.dylib
cd /usr/local/lib/litetree && ln -sf ../liblitetree.dylib libsqlite3.0.dylib
cd /usr/local/lib/litetree && ln -sf libsqlite3.0.dylib libsqlite3.dylib
cp sqlite3.h /usr/local/include
cp sqlite3 /usr/local/bin
macoss-iMac:litetree macos$ cd ..
macoss-iMac:others macos$ git clone https://github.com/ghaering/pysqlite
Cloning into 'pysqlite'...
remote: Enumerating objects: 3074, done.
remote: Total 3074 (delta 0), reused 0 (delta 0), pack-reused 3074
Receiving objects: 100% (3074/3074), 2.35 MiB | 1.81 MiB/s, done.
Resolving deltas: 100% (2178/2178), done.
macoss-iMac:others macos$ cd pysqlite/
macoss-iMac:pysqlite macos$ echo "include_dirs=/usr/local/include" >> setup.cfg
macoss-iMac:pysqlite macos$ echo "library_dirs=/usr/local/lib/litetree" >> setup.cfg
macoss-iMac:pysqlite macos$ python setup.py build
running build
running build_py
creating build
creating build/lib.macosx-10.13-intel-2.7
creating build/lib.macosx-10.13-intel-2.7/pysqlite2
copying lib/__init__.py -> build/lib.macosx-10.13-intel-2.7/pysqlite2
copying lib/dump.py -> build/lib.macosx-10.13-intel-2.7/pysqlite2
copying lib/dbapi2.py -> build/lib.macosx-10.13-intel-2.7/pysqlite2
creating build/lib.macosx-10.13-intel-2.7/pysqlite2/test
copying lib/test/hooks.py -> build/lib.macosx-10.13-intel-2.7/pysqlite2/test
copying lib/test/regression.py -> build/lib.macosx-10.13-intel-2.7/pysqlite2/test
copying lib/test/dbapi.py -> build/lib.macosx-10.13-intel-2.7/pysqlite2/test
copying lib/test/transactions.py -> build/lib.macosx-10.13-intel-2.7/pysqlite2/test
copying lib/test/__init__.py -> build/lib.macosx-10.13-intel-2.7/pysqlite2/test
copying lib/test/types.py -> build/lib.macosx-10.13-intel-2.7/pysqlite2/test
copying lib/test/factory.py -> build/lib.macosx-10.13-intel-2.7/pysqlite2/test
copying lib/test/dump.py -> build/lib.macosx-10.13-intel-2.7/pysqlite2/test
copying lib/test/userfunctions.py -> build/lib.macosx-10.13-intel-2.7/pysqlite2/test
running build_ext
building 'pysqlite2._sqlite' extension
creating build/temp.macosx-10.13-intel-2.7
creating build/temp.macosx-10.13-intel-2.7/src
cc -fno-strict-aliasing -fno-common -dynamic -arch x86_64 -arch i386 -g -Os -pipe -fno-common -fno-strict-aliasing -fwrapv -DENABLE_DTRACE -DMACOSX -DNDEBUG -Wall -Wstrict-prototypes -Wshorten-64-to-32 -DNDEBUG -g -fwrapv -Os -Wall -Wstrict-prototypes -DENABLE_DTRACE -arch i386 -arch x86_64 -pipe -DMODULE_NAME="pysqlite2.dbapi2" -I/opt/local/include -I/usr/local/include -I/System/Library/Frameworks/Python.framework/Versions/2.7/include/python2.7 -c src/module.c -o build/temp.macosx-10.13-intel-2.7/src/module.o
In file included from src/module.c:277:
src/sqlite_constants.h:764:19: warning: incompatible pointer to integer conversion initializing 'int' with an expression of type
	  'sqlite3_destructor_type' (aka 'void (*)(void *)') [-Wint-conversion]
{"SQLITE_STATIC", SQLITE_STATIC},
				  ^~~~~~~~~~~~~
/opt/local/include/sqlite3.h:5237:28: note: expanded from macro 'SQLITE_STATIC'
#define SQLITE_STATIC      ((sqlite3_destructor_type)0)
						   ^~~~~~~~~~~~~~~~~~~~~~~~~~~~
In file included from src/module.c:277:
src/sqlite_constants.h:767:22: warning: incompatible pointer to integer conversion initializing 'int' with an expression of type
	  'sqlite3_destructor_type' (aka 'void (*)(void *)') [-Wint-conversion]
{"SQLITE_TRANSIENT", SQLITE_TRANSIENT},
					 ^~~~~~~~~~~~~~~~
/opt/local/include/sqlite3.h:5238:28: note: expanded from macro 'SQLITE_TRANSIENT'
#define SQLITE_TRANSIENT   ((sqlite3_destructor_type)-1)
						   ^~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2 warnings generated.
In file included from src/module.c:277:
src/sqlite_constants.h:764:19: warning: incompatible pointer to integer conversion initializing 'int' with an expression of type
	  'sqlite3_destructor_type' (aka 'void (*)(void *)') [-Wint-conversion]
{"SQLITE_STATIC", SQLITE_STATIC},
				  ^~~~~~~~~~~~~
/opt/local/include/sqlite3.h:5237:28: note: expanded from macro 'SQLITE_STATIC'
#define SQLITE_STATIC      ((sqlite3_destructor_type)0)
						   ^~~~~~~~~~~~~~~~~~~~~~~~~~~~
In file included from src/module.c:277:
src/sqlite_constants.h:767:22: warning: incompatible pointer to integer conversion initializing 'int' with an expression of type
	  'sqlite3_destructor_type' (aka 'void (*)(void *)') [-Wint-conversion]
{"SQLITE_TRANSIENT", SQLITE_TRANSIENT},
					 ^~~~~~~~~~~~~~~~
/opt/local/include/sqlite3.h:5238:28: note: expanded from macro 'SQLITE_TRANSIENT'
#define SQLITE_TRANSIENT   ((sqlite3_destructor_type)-1)
						   ^~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2 warnings generated.
cc -fno-strict-aliasing -fno-common -dynamic -arch x86_64 -arch i386 -g -Os -pipe -fno-common -fno-strict-aliasing -fwrapv -DENABLE_DTRACE -DMACOSX -DNDEBUG -Wall -Wstrict-prototypes -Wshorten-64-to-32 -DNDEBUG -g -fwrapv -Os -Wall -Wstrict-prototypes -DENABLE_DTRACE -arch i386 -arch x86_64 -pipe -DMODULE_NAME="pysqlite2.dbapi2" -I/opt/local/include -I/usr/local/include -I/System/Library/Frameworks/Python.framework/Versions/2.7/include/python2.7 -c src/connection.c -o build/temp.macosx-10.13-intel-2.7/src/connection.o
src/connection.c:514:46: warning: implicit conversion loses integer precision: 'Py_ssize_t' (aka 'long') to 'int'
	  [-Wshorten-64-to-32]
		sqlite3_result_blob(context, buffer, buflen, SQLITE_TRANSIENT);
		~~~~~~~~~~~~~~~~~~~                  ^~~~~~
1 warning generated.
cc -fno-strict-aliasing -fno-common -dynamic -arch x86_64 -arch i386 -g -Os -pipe -fno-common -fno-strict-aliasing -fwrapv -DENABLE_DTRACE -DMACOSX -DNDEBUG -Wall -Wstrict-prototypes -Wshorten-64-to-32 -DNDEBUG -g -fwrapv -Os -Wall -Wstrict-prototypes -DENABLE_DTRACE -arch i386 -arch x86_64 -pipe -DMODULE_NAME="pysqlite2.dbapi2" -I/opt/local/include -I/usr/local/include -I/System/Library/Frameworks/Python.framework/Versions/2.7/include/python2.7 -c src/cursor.c -o build/temp.macosx-10.13-intel-2.7/src/cursor.o
cc -fno-strict-aliasing -fno-common -dynamic -arch x86_64 -arch i386 -g -Os -pipe -fno-common -fno-strict-aliasing -fwrapv -DENABLE_DTRACE -DMACOSX -DNDEBUG -Wall -Wstrict-prototypes -Wshorten-64-to-32 -DNDEBUG -g -fwrapv -Os -Wall -Wstrict-prototypes -DENABLE_DTRACE -arch i386 -arch x86_64 -pipe -DMODULE_NAME="pysqlite2.dbapi2" -I/opt/local/include -I/usr/local/include -I/System/Library/Frameworks/Python.framework/Versions/2.7/include/python2.7 -c src/cache.c -o build/temp.macosx-10.13-intel-2.7/src/cache.o
cc -fno-strict-aliasing -fno-common -dynamic -arch x86_64 -arch i386 -g -Os -pipe -fno-common -fno-strict-aliasing -fwrapv -DENABLE_DTRACE -DMACOSX -DNDEBUG -Wall -Wstrict-prototypes -Wshorten-64-to-32 -DNDEBUG -g -fwrapv -Os -Wall -Wstrict-prototypes -DENABLE_DTRACE -arch i386 -arch x86_64 -pipe -DMODULE_NAME="pysqlite2.dbapi2" -I/opt/local/include -I/usr/local/include -I/System/Library/Frameworks/Python.framework/Versions/2.7/include/python2.7 -c src/microprotocols.c -o build/temp.macosx-10.13-intel-2.7/src/microprotocols.o
cc -fno-strict-aliasing -fno-common -dynamic -arch x86_64 -arch i386 -g -Os -pipe -fno-common -fno-strict-aliasing -fwrapv -DENABLE_DTRACE -DMACOSX -DNDEBUG -Wall -Wstrict-prototypes -Wshorten-64-to-32 -DNDEBUG -g -fwrapv -Os -Wall -Wstrict-prototypes -DENABLE_DTRACE -arch i386 -arch x86_64 -pipe -DMODULE_NAME="pysqlite2.dbapi2" -I/opt/local/include -I/usr/local/include -I/System/Library/Frameworks/Python.framework/Versions/2.7/include/python2.7 -c src/prepare_protocol.c -o build/temp.macosx-10.13-intel-2.7/src/prepare_protocol.o
cc -fno-strict-aliasing -fno-common -dynamic -arch x86_64 -arch i386 -g -Os -pipe -fno-common -fno-strict-aliasing -fwrapv -DENABLE_DTRACE -DMACOSX -DNDEBUG -Wall -Wstrict-prototypes -Wshorten-64-to-32 -DNDEBUG -g -fwrapv -Os -Wall -Wstrict-prototypes -DENABLE_DTRACE -arch i386 -arch x86_64 -pipe -DMODULE_NAME="pysqlite2.dbapi2" -I/opt/local/include -I/usr/local/include -I/System/Library/Frameworks/Python.framework/Versions/2.7/include/python2.7 -c src/statement.c -o build/temp.macosx-10.13-intel-2.7/src/statement.o
src/statement.c:194:59: warning: implicit conversion loses integer precision: 'Py_ssize_t' (aka 'long') to 'int' [-Wshorten-64-to-32]
			rc = sqlite3_bind_text(self->st, pos, string, buflen, SQLITE_TRANSIENT);
				 ~~~~~~~~~~~~~~~~~                        ^~~~~~
src/statement.c:199:59: warning: implicit conversion loses integer precision: 'Py_ssize_t' (aka 'long') to 'int' [-Wshorten-64-to-32]
			rc = sqlite3_bind_text(self->st, pos, string, buflen, SQLITE_TRANSIENT);
				 ~~~~~~~~~~~~~~~~~                        ^~~~~~
src/statement.c:204:63: warning: implicit conversion loses integer precision: 'Py_ssize_t' (aka 'long') to 'int' [-Wshorten-64-to-32]
				rc = sqlite3_bind_blob(self->st, pos, buffer, buflen, SQLITE_TRANSIENT);
					 ~~~~~~~~~~~~~~~~~                        ^~~~~~
src/statement.c:264:26: warning: implicit conversion loses integer precision: 'Py_ssize_t' (aka 'long') to 'int' [-Wshorten-64-to-32]
			num_params = PyTuple_GET_SIZE(parameters);
					   ~ ^~~~~~~~~~~~~~~~~~~~~~~~~~~~
/System/Library/Frameworks/Python.framework/Versions/2.7/include/python2.7/tupleobject.h:51:33: note: expanded from macro
	  'PyTuple_GET_SIZE'
#define PyTuple_GET_SIZE(op)    Py_SIZE(op)
								^~~~~~~~~~~
/System/Library/Frameworks/Python.framework/Versions/2.7/include/python2.7/object.h:116:56: note: expanded from macro 'Py_SIZE'
#define Py_SIZE(ob)             (((PyVarObject*)(ob))->ob_size)
								 ~~~~~~~~~~~~~~~~~~~~~~^~~~~~~
src/statement.c:266:26: warning: implicit conversion loses integer precision: 'Py_ssize_t' (aka 'long') to 'int' [-Wshorten-64-to-32]
			num_params = PyList_GET_SIZE(parameters);
					   ~ ^~~~~~~~~~~~~~~~~~~~~~~~~~~
/System/Library/Frameworks/Python.framework/Versions/2.7/include/python2.7/listobject.h:63:32: note: expanded from macro
	  'PyList_GET_SIZE'
#define PyList_GET_SIZE(op)    Py_SIZE(op)
							   ^~~~~~~~~~~
/System/Library/Frameworks/Python.framework/Versions/2.7/include/python2.7/object.h:116:56: note: expanded from macro 'Py_SIZE'
#define Py_SIZE(ob)             (((PyVarObject*)(ob))->ob_size)
								 ~~~~~~~~~~~~~~~~~~~~~~^~~~~~~
src/statement.c:268:26: warning: implicit conversion loses integer precision: 'Py_ssize_t' (aka 'long') to 'int' [-Wshorten-64-to-32]
			num_params = PySequence_Size(parameters);
					   ~ ^~~~~~~~~~~~~~~~~~~~~~~~~~~
6 warnings generated.
cc -fno-strict-aliasing -fno-common -dynamic -arch x86_64 -arch i386 -g -Os -pipe -fno-common -fno-strict-aliasing -fwrapv -DENABLE_DTRACE -DMACOSX -DNDEBUG -Wall -Wstrict-prototypes -Wshorten-64-to-32 -DNDEBUG -g -fwrapv -Os -Wall -Wstrict-prototypes -DENABLE_DTRACE -arch i386 -arch x86_64 -pipe -DMODULE_NAME="pysqlite2.dbapi2" -I/opt/local/include -I/usr/local/include -I/System/Library/Frameworks/Python.framework/Versions/2.7/include/python2.7 -c src/util.c -o build/temp.macosx-10.13-intel-2.7/src/util.o
src/util.c:135:27: warning: implicit conversion loses integer precision: 'sqlite_int64' (aka 'long long') to 'long'
	  [-Wshorten-64-to-32]
	return PyInt_FromLong(value);
		   ~~~~~~~~~~~~~~ ^~~~~
1 warning generated.
cc -fno-strict-aliasing -fno-common -dynamic -arch x86_64 -arch i386 -g -Os -pipe -fno-common -fno-strict-aliasing -fwrapv -DENABLE_DTRACE -DMACOSX -DNDEBUG -Wall -Wstrict-prototypes -Wshorten-64-to-32 -DNDEBUG -g -fwrapv -Os -Wall -Wstrict-prototypes -DENABLE_DTRACE -arch i386 -arch x86_64 -pipe -DMODULE_NAME="pysqlite2.dbapi2" -I/opt/local/include -I/usr/local/include -I/System/Library/Frameworks/Python.framework/Versions/2.7/include/python2.7 -c src/row.c -o build/temp.macosx-10.13-intel-2.7/src/row.o
src/row.c:110:18: warning: implicit conversion loses integer precision: 'Py_ssize_t' (aka 'long') to 'int' [-Wshorten-64-to-32]
		nitems = PyTuple_Size(self->description);
			   ~ ^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
src/row.c:168:14: warning: implicit conversion loses integer precision: 'Py_ssize_t' (aka 'long') to 'int' [-Wshorten-64-to-32]
	nitems = PyTuple_Size(self->description);
		   ~ ^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2 warnings generated.
cc -bundle -undefined dynamic_lookup -arch x86_64 -arch i386 -Wl,-F. build/temp.macosx-10.13-intel-2.7/src/module.o build/temp.macosx-10.13-intel-2.7/src/connection.o build/temp.macosx-10.13-intel-2.7/src/cursor.o build/temp.macosx-10.13-intel-2.7/src/cache.o build/temp.macosx-10.13-intel-2.7/src/microprotocols.o build/temp.macosx-10.13-intel-2.7/src/prepare_protocol.o build/temp.macosx-10.13-intel-2.7/src/statement.o build/temp.macosx-10.13-intel-2.7/src/util.o build/temp.macosx-10.13-intel-2.7/src/row.o -L/opt/local/lib -L/usr/local/lib/litetree -lsqlite3 -o build/lib.macosx-10.13-intel-2.7/pysqlite2/_sqlite.so
macoss-iMac:pysqlite macos$ sudo python setup.py install
running install
running build
running build_py
running build_ext
running install_lib
copying build/lib.macosx-10.13-intel-2.7/pysqlite2/_sqlite.so -> /Library/Python/2.7/site-packages/pysqlite2
copying build/lib.macosx-10.13-intel-2.7/pysqlite2/test/hooks.py -> /Library/Python/2.7/site-packages/pysqlite2/test
copying build/lib.macosx-10.13-intel-2.7/pysqlite2/test/regression.py -> /Library/Python/2.7/site-packages/pysqlite2/test
copying build/lib.macosx-10.13-intel-2.7/pysqlite2/test/dbapi.py -> /Library/Python/2.7/site-packages/pysqlite2/test
copying build/lib.macosx-10.13-intel-2.7/pysqlite2/test/transactions.py -> /Library/Python/2.7/site-packages/pysqlite2/test
copying build/lib.macosx-10.13-intel-2.7/pysqlite2/test/__init__.py -> /Library/Python/2.7/site-packages/pysqlite2/test
copying build/lib.macosx-10.13-intel-2.7/pysqlite2/test/types.py -> /Library/Python/2.7/site-packages/pysqlite2/test
copying build/lib.macosx-10.13-intel-2.7/pysqlite2/test/factory.py -> /Library/Python/2.7/site-packages/pysqlite2/test
copying build/lib.macosx-10.13-intel-2.7/pysqlite2/test/dump.py -> /Library/Python/2.7/site-packages/pysqlite2/test
copying build/lib.macosx-10.13-intel-2.7/pysqlite2/test/userfunctions.py -> /Library/Python/2.7/site-packages/pysqlite2/test
copying build/lib.macosx-10.13-intel-2.7/pysqlite2/__init__.py -> /Library/Python/2.7/site-packages/pysqlite2
copying build/lib.macosx-10.13-intel-2.7/pysqlite2/dump.py -> /Library/Python/2.7/site-packages/pysqlite2
copying build/lib.macosx-10.13-intel-2.7/pysqlite2/dbapi2.py -> /Library/Python/2.7/site-packages/pysqlite2
byte-compiling /Library/Python/2.7/site-packages/pysqlite2/test/hooks.py to hooks.pyc
byte-compiling /Library/Python/2.7/site-packages/pysqlite2/test/regression.py to regression.pyc
byte-compiling /Library/Python/2.7/site-packages/pysqlite2/test/dbapi.py to dbapi.pyc
byte-compiling /Library/Python/2.7/site-packages/pysqlite2/test/transactions.py to transactions.pyc
byte-compiling /Library/Python/2.7/site-packages/pysqlite2/test/__init__.py to __init__.pyc
byte-compiling /Library/Python/2.7/site-packages/pysqlite2/test/types.py to types.pyc
byte-compiling /Library/Python/2.7/site-packages/pysqlite2/test/factory.py to factory.pyc
byte-compiling /Library/Python/2.7/site-packages/pysqlite2/test/dump.py to dump.pyc
byte-compiling /Library/Python/2.7/site-packages/pysqlite2/test/userfunctions.py to userfunctions.pyc
byte-compiling /Library/Python/2.7/site-packages/pysqlite2/__init__.py to __init__.pyc
byte-compiling /Library/Python/2.7/site-packages/pysqlite2/dump.py to dump.pyc
byte-compiling /Library/Python/2.7/site-packages/pysqlite2/dbapi2.py to dbapi2.pyc
running install_data
copying doc/default.css -> /System/Library/Frameworks/Python.framework/Versions/2.7/pysqlite2-doc
copying doc/docutils.css -> /System/Library/Frameworks/Python.framework/Versions/2.7/pysqlite2-doc
running install_egg_info
Removing /Library/Python/2.7/site-packages/pysqlite-2.8.3-py2.7.egg-info
Writing /Library/Python/2.7/site-packages/pysqlite-2.8.3-py2.7.egg-info
macoss-iMac:pysqlite macos$ cd ../litetree/
macoss-iMac:litetree macos$ make test
cd test && python test.py -v
test00_read_config (__main__.TestSQLiteBranches) ... ERROR
test01_branches (__main__.TestSQLiteBranches) ... FAIL
test02_branch_info (__main__.TestSQLiteBranches) ... FAIL
test02_branch_tree (__main__.TestSQLiteBranches) ... ERROR
test02b_sql_log (__main__.TestSQLiteBranches) ... ERROR
test03_reading_branches_at_the_same_time (__main__.TestSQLiteBranches) ... FAIL
test04_concurrent_access (__main__.TestSQLiteBranches) ... FAIL
test05_single_connection_uri (__main__.TestSQLiteBranches) ... FAIL
test06_invalid_branch_name (__main__.TestSQLiteBranches) ... ERROR
test07_rename_branch (__main__.TestSQLiteBranches) ... FAIL
test08_truncate_branch (__main__.TestSQLiteBranches) ... ERROR
test09_delete_branch (__main__.TestSQLiteBranches) ... FAIL
test10_rollback (__main__.TestSQLiteBranches) ... ERROR
test11_attached_dbs (__main__.TestSQLiteBranches) ... FAIL
test12_temporary_db (__main__.TestSQLiteBranches) ... FAIL
test13_discard_commits (__main__.TestSQLiteBranches) ... FAIL
test14_forward_merge (__main__.TestSQLiteBranches) ... FAIL
test15_forward_merge (__main__.TestSQLiteBranches) ... FAIL
test18_savepoints (__main__.TestSQLiteBranches) ... ERROR
test19_closed_connection (__main__.TestSQLiteBranches) ... ERROR
test20_open_while_writing (__main__.TestSQLiteBranches) ... ERROR
test21_internal_temporary_dbs (__main__.TestSQLiteBranches) ... ERROR
test22_normal_sqlite (__main__.TestSQLiteBranches) ... ok

======================================================================
ERROR: test00_read_config (__main__.TestSQLiteBranches)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "test.py", line 47, in test00_read_config
	if c.fetchone()[0] == "disabled":
TypeError: 'NoneType' object has no attribute '__getitem__'

======================================================================
ERROR: test02_branch_tree (__main__.TestSQLiteBranches)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "test.py", line 220, in test02_branch_tree
	self.assertIn(c.fetchone()[0], [tree1,tree2])
TypeError: 'NoneType' object has no attribute '__getitem__'

======================================================================
ERROR: test02b_sql_log (__main__.TestSQLiteBranches)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "test.py", line 234, in test02b_sql_log
	self.assertEqual(c.fetchone()[0], "master")
TypeError: 'NoneType' object has no attribute '__getitem__'

======================================================================
ERROR: test06_invalid_branch_name (__main__.TestSQLiteBranches)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "test.py", line 878, in test06_invalid_branch_name
	self.assertEqual(c.fetchone()[0], "master")
TypeError: 'NoneType' object has no attribute '__getitem__'

======================================================================
ERROR: test08_truncate_branch (__main__.TestSQLiteBranches)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "test.py", line 1049, in test08_truncate_branch
	shutil.copy("test.db","test3.db")
  File "/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/shutil.py", line 119, in copy
	copyfile(src, dst)
  File "/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/shutil.py", line 82, in copyfile
	with open(src, 'rb') as fsrc:
IOError: [Errno 2] No such file or directory: 'test.db'

======================================================================
ERROR: test10_rollback (__main__.TestSQLiteBranches)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "test.py", line 1324, in test10_rollback
	self.assertEqual(c.fetchone()[0], "master")
TypeError: 'NoneType' object has no attribute '__getitem__'

======================================================================
ERROR: test18_savepoints (__main__.TestSQLiteBranches)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "test.py", line 2862, in test18_savepoints
	c1.execute("pragma branch_log master")
OperationalError: near "master": syntax error

======================================================================
ERROR: test19_closed_connection (__main__.TestSQLiteBranches)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "test.py", line 2965, in test19_closed_connection
	obj = json.loads(c1.fetchone()[0])
TypeError: 'NoneType' object has no attribute '__getitem__'

======================================================================
ERROR: test20_open_while_writing (__main__.TestSQLiteBranches)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "test.py", line 2999, in test20_open_while_writing
	obj = json.loads(c1.fetchone()[0])
TypeError: 'NoneType' object has no attribute '__getitem__'

======================================================================
ERROR: test21_internal_temporary_dbs (__main__.TestSQLiteBranches)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "test.py", line 3035, in test21_internal_temporary_dbs
	c1.execute("create table t1 (val int)")
OperationalError: table t1 already exists

======================================================================
FAIL: test01_branches (__main__.TestSQLiteBranches)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "test.py", line 64, in test01_branches
	self.assertEqual(c.fetchone()[0], "branches")
AssertionError: u'delete' != 'branches'

======================================================================
FAIL: test02_branch_info (__main__.TestSQLiteBranches)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "test.py", line 172, in test02_branch_info
	self.assertEqual(c.fetchone()[0], "branches")
AssertionError: u'delete' != 'branches'

======================================================================
FAIL: test03_reading_branches_at_the_same_time (__main__.TestSQLiteBranches)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "test.py", line 679, in test03_reading_branches_at_the_same_time
	self.assertEqual(c1.fetchone()[0], "branches")
AssertionError: u'delete' != 'branches'

======================================================================
FAIL: test04_concurrent_access (__main__.TestSQLiteBranches)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "test.py", line 747, in test04_concurrent_access
	self.assertEqual(c1.fetchone()[0], "branches")
AssertionError: u'delete' != 'branches'

======================================================================
FAIL: test05_single_connection_uri (__main__.TestSQLiteBranches)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "test.py", line 833, in test05_single_connection_uri
	self.assertEqual(c1.fetchone()[0], "branches")
AssertionError: u'delete' != 'branches'

======================================================================
FAIL: test07_rename_branch (__main__.TestSQLiteBranches)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "test.py", line 956, in test07_rename_branch
	self.assertListEqual(c1.fetchall(), [("master",),("test",),("sub-test1",),("sub-test2",)])
AssertionError: Lists differ: [] != [('master',), ('test',), ('sub...

Second list contains 4 additional elements.
First extra element 0:
('master',)

- []
+ [('master',), ('test',), ('sub-test1',), ('sub-test2',)]

======================================================================
FAIL: test09_delete_branch (__main__.TestSQLiteBranches)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "test.py", line 1189, in test09_delete_branch
	self.assertListEqual(c1.fetchall(), [("master",),("test",),("sub-test1",),("sub-test2",),("renamed-branch",),("test2",)])
AssertionError: Lists differ: [] != [('master',), ('test',), ('sub...

Second list contains 6 additional elements.
First extra element 0:
('master',)

- []
+ [('master',),
+  ('test',),
+  ('sub-test1',),
+  ('sub-test2',),
+  ('renamed-branch',),
+  ('test2',)]

======================================================================
FAIL: test11_attached_dbs (__main__.TestSQLiteBranches)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "test.py", line 1393, in test11_attached_dbs
	self.assertEqual(c1.fetchone()[0], "branches")
AssertionError: u'delete' != 'branches'

======================================================================
FAIL: test12_temporary_db (__main__.TestSQLiteBranches)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "test.py", line 1529, in test12_temporary_db
	self.assertEqual(c1.fetchone()[0], "branches")
AssertionError: u'delete' != 'branches'

======================================================================
FAIL: test13_discard_commits (__main__.TestSQLiteBranches)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "test.py", line 1609, in test13_discard_commits
	self.assertEqual(c.fetchone()[0], "branches")
AssertionError: u'delete' != 'branches'

======================================================================
FAIL: test14_forward_merge (__main__.TestSQLiteBranches)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "test.py", line 1994, in test14_forward_merge
	self.assertEqual(c1.fetchone()[0], "branches")
AssertionError: u'delete' != 'branches'

======================================================================
FAIL: test15_forward_merge (__main__.TestSQLiteBranches)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "test.py", line 2552, in test15_forward_merge
	self.assertEqual(c1.fetchone()[0], "branches")
AssertionError: u'delete' != 'branches'

----------------------------------------------------------------------
Ran 23 tests in 0.038s

FAILED (failures=12, errors=10)
make: *** [test] Error 1
macoss-iMac:litetree macos$ find -name libsqlite3
find: illegal option -- n
usage: find [-H | -L | -P] [-EXdsx] [-f path] path ... [expression]
	   find [-H | -L | -P] [-EXdsx] -f path [path ...] [expression]
macoss-iMac:litetree macos$ find / -name libsqlite3
find: /usr/sbin/authserver: Permission denied
^C
macoss-iMac:litetree macos$ sudo find / -name libsqlite3
find: /dev/fd/3: Not a directory
find: /dev/fd/4: Not a directory
macoss-iMac:litetree macos$ 

[kroggen]

It compiles well on Mac as you can see on the last CI log.

One difference is that on the CI the pysqlite is installed automatically by the makefile when running make test

You can check if the pysqlite module is using the right sqlite3 library by issuing this command:

otool -L /Library/Python/2.7/site-packages/pysqlite2/_sqlite.so

It should display /usr/local/lib/litetree/libsqlite3.dylib on the list.

[ekawahyu]

Apparently, mine does not show like above:

/Library/Python/2.7/site-packages/pysqlite2/_sqlite.so:
/opt/local/lib/libsqlite3.0.dylib (compatibility version 9.0.0, current version 9.6.0)
/usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current version 1252.50.4)

[kroggen]

A simple solution for now:

sudo install_name_tool -change /opt/local/lib/libsqlite3.0.dylib /usr/local/lib/litetree/libsqlite3.dylib /Library/Python/2.7/site-packages/pysqlite2/_sqlite.so