DuckDB JDBC 1.2.0 in DBeaver 25.0.0 cannot connect to db file due to permission errors
Nobody has claimed this yet.
Assessment
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Newbie friendliness
- 30/100
Research direction
Start by reproducing the connection failure with duckdb_jdbc-1.2.0.jar in DBeaver 25.0.0 on Ubuntu 24.04, using the reported memory.max path and permission error. Compare the DuckDB connection with the working PostgreSQL connections; done means the database files connect without the permission-denied failure.
Written by the indexing model from the issue text.
Description
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.
- Dominant language
- C++
- Stars
- 127
- Forks
- 80
- Avg merge
- 13h 41m
- Merged PRs (30d)
- 44
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from duckdb/duckdb-java
-
Difficulty 2/5 1-3 hours Newbie friendliness 72/100
duckdb/duckdb-java#832 · 2 comments ·
-
Native SIGSEGV in DuckDB JDBC when repeatedly executing queries with window functions and LIMIT 0 Open
Difficulty 4/5 3-5 days Newbie friendliness 48/100
duckdb/duckdb-java#871 · 4 comments ·
-
Difficulty 4/5 3-5 days Newbie friendliness 45/100
duckdb/duckdb-java#872 ·
-
Difficulty 5/5 Over a week Newbie friendliness 35/100
duckdb/duckdb-java#837 ·
-
executeBatch()` on a prepared INSERT runs s are ~1–2 orders of magnitude slower than the Appender Open
Difficulty 5/5 Over a week Newbie friendliness 42/100
duckdb/duckdb-java#815 · 1 comment ·
All issues in duckdb/duckdb-java
Similar issues
-
Difficulty 1/5 Under an hour Newbie friendliness 90/100
AXERA-TECH/ax-llm#77 ·
-
Difficulty 1/5 Under an hour Newbie friendliness 90/100
games-on-whales/wolf#509 ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 82/100
-
Difficulty 2/5 1-3 hours Newbie friendliness 74/100
-
bug-unconfirmed
Difficulty 2/5 1-3 hours Newbie friendliness 76/100