sqlite_scanner icon indicating copy to clipboard operation
sqlite_scanner copied to clipboard

undefined symbol

Open blackrez opened this issue 2 years ago • 5 comments

Hello,

duckdb : 0.3.4 OS : Ubuntu 20.04 CPU : arm64

After building the extensions, I load the extensions and after I encounter this error.

D LOAD '../sqlitescanner/build/release/sqlite_scanner.duckdb_extension';

Error: IO Error: File "../sqlitescanner/build/release/sqlite_scanner.duckdb_extension" could not be loaded: ../sqlitescanner/build/release/sqlite_scanner.duckdb_extension: undefined symbol: _ZNK6duckdb17TableFunctionData4CopyEv

blackrez avatar Jun 04 '22 19:06 blackrez

Thanks for the update, I have a new error.

D LOAD '/media/psf/nabil/project/sqlitescanner/build/release/sqlite_scanner.duckdb_extension';
Error: IO Error: File "/media/psf/nabil/project/sqlitescanner/build/release/sqlite_scanner.duckdb_extension" could not be loaded: /media/psf/nabil/project/sqlitescanner/build/release/sqlite_scanner.duckdb_extension: undefined symbol: _ZTIN6duckdb23LocalTableFunctionStateE

blackrez avatar Jun 08 '22 07:06 blackrez

Hello, I upgraded to the 0.4.0 of DuckDB and the loading works but I can't load sqlite3 database.

Use ".open FILENAME" to reopen on a persistent database.
D LOAD 'build/release/sqlite_scanner.duckdb_extension';
D CALL sqlite_attach('sakila.db');
Error: IO Error: The file is not a valid DuckDB database file!

blackrez avatar Jun 20 '22 11:06 blackrez

How are you launching the shell? Please don't put the sqlite file name as a parameter there.

hannes avatar Jun 20 '22 11:06 hannes

I'm launching the shell without parameters, as you can see :

nabil@dev-server:/media/psf/nabil/project/sqlitescanner$ duckdb
v0.0.1-dev0
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
D LOAD 'build/release/sqlite_scanner.duckdb_extension';
D CALL sqlite_attach('sakila.db');
Error: IO Error: The file is not a valid DuckDB database file!
D

blackrez avatar Jun 20 '22 11:06 blackrez

And if I put a duckdb db instead of a sqlite3 db, the extensions seems to accept the duckdb db.

nabil@dev-server:/media/psf/nabil/project/sqlitescanner$ duckdb gnop.db
v0.0.1-dev0
Enter ".help" for usage hints.
D LOAD 'build/release/sqlite_scanner.duckdb_extension';
D CALL sqlite_attach('sakila.db');
Error: IO Error: The file is not a valid DuckDB database file!
D

nabil@dev-server:/media/psf/nabil/project/sqlitescanner$ ls
bench.sql  build       CMakeLists.txt  duckdb   LICENSE   README.md  sakila-examples.sql  sqlite_scanner.cpp  tpch-create.sqlite
borked.db  chinook.db  decimal.db      gnop.db  Makefile  sakila.db  sqlite               test                tpch-export.duckdb
nabil@dev-server:/media/psf/nabil/project/sqlitescanner$ duckdb
v0.0.1-dev0
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
D LOAD 'build/release/sqlite_scanner.duckdb_extension';
D CALL sqlite_attach('gnop.db');
D

blackrez avatar Jun 20 '22 13:06 blackrez

Duplicate of #7 I think

Mause avatar Nov 06 '22 09:11 Mause

This should now be fixed with the latest DuckDB dev version

Mause avatar Nov 07 '22 16:11 Mause