DuckDB JDBC 1.2.0 in DBeaver 25.0.0 cannot connect to db file due to permission errors
- Lingua principale
- C++
- Stelle
- 127
- Fork
- 80
- Merge medio
- 13h 49m
- PR unite (30g)
- 48
Descrizione
Hello,
In December, I created a DuckDB database file using a Python script, that was opening fine using DBeaver driver for DuckDB (not sure which version it was). Recently, I switched from Ubuntu 23 to Ubuntu 24.04 and installed everything again. But now I cannot open the database file because of a permission-denied error in what could be a file related to the driver:
> IO Error: Cannot open file "/sys/fs/cgroup//user.slice/user-1000.slice/user@1000.service/app.slice/snap.dbeaver-ce.dbeaver-ce-e26959df-6457-4254-b306-2f6306c55a92.scope/memory.max": Permission denied
I can see that the file and folders exist:
```
$ ll /sys/fs/cgroup//user.slice/user-1000.slice/user@1000.service/app.slice/snap.dbeaver-ce.dbeaver-ce-e26959df-6457-4254-b306-2f6306c55a92.scope/memory.max
-rw-r--r-- 1 fossandon fossandon 0 Mar 3 18:20 '/sys/fs/cgroup//user.slice/user-1000.slice/user@1000.service/app.slice/snap.dbeaver-ce.dbeaver-ce-e26959df-6457-4254-b306-2f6306c55a92.scope/memory.max'
```
However, the permission part is not working for DBeaver, so it fails to connect to my database file. I'm sure that is not the database file's fault, since I tried a few different ones and all got the same error.
A forced reinstallation of the driver (`duckdb_jdbc-1.2.0.jar`) did nothing. Other connections to Postgres databases are working fine, so it seems related to the DuckDB driver.
The file permission above seems fine unless DBeaver or the Driver somehow uses a different user than mine, or it's something else.
Guida per i contributori
Nessuna guida per i contributori indicizzata per questo repository
Direzione di ricerca
Inizia riproducendo il problema di connessione con duckdb_jdbc-1.2.0.jar in DBeaver 25.0.0 su Ubuntu 24.04, utilizzando il percorso memory.max e l’errore di autorizzazione segnalati. Confronta la connessione DuckDB con le connessioni PostgreSQL funzionanti; il lavoro è completato quando i file del database si connettono senza l’errore di autorizzazione negata.
Scritto dal modello di indicizzazione a partire dal testo della issue.
Valutazione
- Stack tecnologico
- java, ubuntu
- Ambito
- databases
- Tipo di issue
- Bug
- Difficoltà
- 4/5
- Tempo stimato
- 3-5 giorni
- Stato di attività
- Ferma
- Chiarezza
- Da chiarire
- Idoneità per principianti
- 30/100