首先,我意识到有人问过类似的问题,但似乎没有一个有同样的问题,我找不到解决方案。
我可以在访问我的SQLlite数据库的Python中很好地创建表和执行读/写操作。但是,在尝试通过dbeaver访问数据库时,我遇到了以下问题:
1.首先,当尝试连接到db文件时,它会问我“已经存在一个名为lobase.db的文件。您想要替换它吗?”
1.尝试通过图形用户界面查看表格时,它会加载几秒钟,然后显示错误
我还没有找到解决这个问题的方法。有谁有这方面的经验和解决方案吗?
编辑:我想添加SQLLITE对给定错误的看法:https://www.sqlite.org/rescode.html#busy
它指出,该错误是“由于其他数据库连接的并发活动”而发生的。不过,我不知道这种并发活动是从哪里来的,因为我正在关闭所有东西,而我只是试图查看图形用户界面中的表。我认为这个问题与第一个问题有关,在第一个问题中,它询问我是否要替换该文件。
2条答案
按热度按时间0kjbasz61#
根据前面的评论,卸载DBeaver Snap
并从官方站点使用.deb包进行安装
这对我很管用。
前一条评论的所有积分=)
afdcj2ne2#
TLTR: If your database file is located in a mountable filesystem, you need to give dbeaver permission to read files from a mountable filesystem.
I have found 2 ways to solve this issue on ubuntu:
1: Make sure your database file is in home directory. Since dbeaver has permission to access your home directory, it will work.
OR
2: If you have downloaded dbeaver from:
ubuntu software center
directly orsnap install
and your database file is located in a mountable filesystem, heard over to ubuntu software center => installed, find dbeaver in the list then click on it, on the next window top left, click on the permissions and toggle
Read system mount information and disk quotas
, put in your password in the authentication prompt and you're good to go.