duckdb / duckdb/duckdb-sqlite

db Loads in Windows but not Linux

Open
#100 5 comments 0 reactions 0 assignees View on GitHub
Dominant language
C
Stars
291
Forks
45
Avg merge
10h 13m
Merged PRs (30d)
18

Description

### What happens?

Using DuckDB CLI, both v0.10.3 70fd6a8a24 and sqlite_scanner version 50b7870.

On Linux, receive file error. Exact same file (16GB) on Windows loads.

D ATTACH '~/DataAnalysis/Research/DNAGedcom.db'as dna (TYPE SQLITE);
D use dna;
Invalid Error: Unable to open database "~/DataAnalysis/Research/DNAGedcom.db": unable to open database file

PS D:\Program Files (x86)\Incline Software\Ancestral Quest 14\DNA\Software\DNAGedcom> duckdb 'DNAGedcom.db'
v0.10.3 70fd6a8a24
Enter ".help" for usage hints.
D .tables

Posted the issue on Discord in the DuckDB server, extensions channel. User carlop suggested I post the issue here.

https://discord.com/channels/909674491309850675/1209495191380172862/1246457421178605709

### To Reproduce

PS D:\Program Files (x86)\Incline Software\Ancestral Quest 14\DNA\Software\DNAGedcom> duckdb 'DNAGedcom.db'

In Linux:
D ATTACH '~/DataAnalysis/Research/DNAGedcom.db'as dna (TYPE SQLITE);
D use dna;

### OS:

Linux Mint 21.3 x86_64 Kernel: 5.15.0-107-generic

### SQLite Version:

3.33.0

### DuckDB Version:

v0.10.3 70fd6a8a24

### DuckDB Client:

CLI

### Full Name:

Patrick Logan

### Affiliation:

Personal Use

### Have you tried this on the latest `main` branch?

- [X] I agree

### Have you tried the steps to reproduce? Do they include all relevant data and configuration? Does the issue you report still appear there?

- [X] I agree

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.