duckservability icon indicating copy to clipboard operation
duckservability copied to clipboard

Can you update the `duckservability.duckdb`?

Open onnimonni opened this issue 9 months ago • 1 comments

Hey,

I tried to use this but ran into following issue:

$ duckdb duckservability.duckdb
Error: unable to open database "duckservability.duckdb": IO Error: Trying to read a database file with version number 43, but we can only read versions between 64 and 65.
The database file was created with DuckDB version v0.7.0 or v0.7.1.

Newer DuckDB version might introduce backward incompatible changes (possibly guarded by compatibility settings)See the storage page for migration strategy and more information: https://duckdb.org/internals/storage

onnimonni avatar May 08 '25 08:05 onnimonni

Hey! Looks like the issue is that the latestduckservability.duckdb file released was using a version of DuckDB that's pretty old at this point. I tried updating it in the project dependencies, but it looks like there have also been some changes to the DuckDB CSV Parser that broke the underlying SQL queries. There's also some issues with the build environment in that the Github actions no longer seem to be giving access to system files it had in the past. This is project was largerly a proof of concept so I'm unlikely to debug it further. I'd be happy to accept a pull request if you did. Note that if you just want the duckdb file to play around with rather than fixing this build, you might try running the dbt project locally yourself to see if you can build it. Thanks for calling this out, and sorry I couldn't be of more help!

MarkRoddy avatar May 08 '25 23:05 MarkRoddy