sqlite3.OperationalError: database is locked

[grolma]

OS=Ubuntu 20.04

It downloads (an updated, I assume) daemon and then doesnt start

 heres the error log

bn.BUILD_KEY: Dropbox
bn.VERSION: 115.4.601
bn.constants.WINDOWS_SHELL_EXT_VERSION: 46
bn.is_frozen: True
machine_id: b9b8c191-f519-4a4e-aecb-8337ab59b28e
pid: 2560
ppid: 1
ppid exe: failed
uid: 1000
user_info: pwd.struct_passwd(pw_name='MyPC', pw_passwd='x', pw_uid=1000, pw_gid=1000, pw_gecos='paul,,,', pw_dir='/home/MyPC', pw_shell='/bin/bash')
effective_user_info: pwd.struct_passwd(pw_name='MyPC', pw_passwd='x', pw_uid=1000, pw_gid=1000, pw_gecos='paul,,,', pw_dir='/home/MyPC', pw_shell='/bin/bash')
euid: 1000
gid: 1000
egid: 1000
group_info: grp.struct_group(gr_name='MyPC', gr_passwd='x', gr_gid=1000, gr_mem=[])
effective_group_info: grp.struct_group(gr_name='MyPC', gr_passwd='x', gr_gid=1000, gr_mem=[])
LD_LIBRARY_PATH: None
cwd: '/home/MyPC'
real_path='/home/MyPC'
mode=0o40755 uid=1000 gid=1000
parent mode=0o40755 uid=1000 gid=1000
HOME: '/home/MyPC'
appdata: '/home/MyPC/.dropbox/instance1'
real_path='/home/MyPC/.dropbox/instance1'
mode=0o40700 uid=1000 gid=1000
parent mode=0o40700 uid=1000 gid=1000
dropbox_path: '/home/MyPC/Dropbox'
real_path='/home/MyPC/Dropbox'
mode=0o40700 uid=1000 gid=1000
parent mode=0o40755 uid=1000 gid=1000
sys_executable: '/home/MyPC/.dropbox-dist/dropbox-lnx.x86_64-115.4.601/dropbox'
real_path='/home/MyPC/.dropbox-dist/dropbox-lnx.x86_64-115.4.601/dropbox'
mode=0o100755 uid=1000 gid=1000
parent mode=0o40755 uid=1000 gid=1000
trace.__file__: '/home/MyPC/.dropbox-dist/dropbox-lnx.x86_64-115.4.601/python-packages.zip/dropbox/client/ui/common/boot_error.pyc'
real_path='/home/MyPC/.dropbox-dist/dropbox-lnx.x86_64-115.4.601/python-packages.zip/dropbox/client/ui/common/boot_error.pyc'
not found
parent not found
tempdir: '/tmp'
real_path='/tmp'
mode=0o41777 uid=0 gid=0
parent mode=0o40755 uid=0 gid=0
Traceback (most recent call last):
File "dropbox/client/main.pyc", line 817, in wrapper
File "dropbox/client/main.pyc", line 6619, in finish_dropbox_boot
File "dropbox/client/main.pyc", line 6084, in _init_components_for_account
File "dropbox/client/main.pyc", line 6023, in create_sync_engine
File "dropbox/sync_engine_boundary/factory.pyc", line 262, in make_sync_engine
File "dropbox/sync_engine/nucleus/classic_client/sync_engine.pyc", line 357, in __init__
File "dropbox/sync_engine_boundary/nucleus_p2p.pyc", line 218, in add_preferences_callback
File "dropbox/client/configuration/local_configuration.pyc", line 114, in __getitem__
File "_collections_abc.pyc", line 660, in get
File "dropbox/client/configuration/context_aware_config_dict.pyc", line 25, in __getitem__
File "dropbox/gui.pyc", line 131, in _trace_warn_if_called_on_main_thread
File "dropbox/client/config.pyc", line 366, in __contains__
File "dropbox/client/config.pyc", line 112, in __contains__
File "dropbox/sqlite3_helpers.pyc", line 301, in execute
File "dropbox/sqlite3_helpers.pyc", line 267, in _raise_better_operational_exception
File "six.pyc", line 696, in reraise
File "dropbox/sqlite3_helpers.pyc", line 296, in execute
sqlite3.OperationalError: database is locked

[Jay]

Hi @grolma, thanks for posting on the Community!

Do you have an security programs which could be preventing the app from updating?

If so, try temporarily disabling them to see if this helps.

Keep me updated with any progress!

[pcooper]

This login system seems completely borked !

Posts/updates are disappearing

No additional security software  installed

heres the whole lot ( again)

bn.BUILD_KEY: Dropbox
bn.VERSION: 88.4.172
bn.DROPBOXEXT_VERSION: failed
bn.is_frozen: True
machine_id: b9b8c191-f519-4a4e-aecb-8337ab59b28e
pid: 8699
ppid: 1
ppid exe: failed
uid: 1000
user_info: pwd.struct_passwd(pw_name='myPC', pw_passwd='x', pw_uid=1000, pw_gid=1000, pw_gecos='paul,,,', pw_dir='/home/myPC', pw_shell='/bin/bash')
effective_user_info: pwd.struct_passwd(pw_name='myPC', pw_passwd='x', pw_uid=1000, pw_gid=1000, pw_gecos='paul,,,', pw_dir='/home/myPC', pw_shell='/bin/bash')
euid: 1000
gid: 1000
egid: 1000
group_info: grp.struct_group(gr_name='myPC', gr_passwd='x', gr_gid=1000, gr_mem=[])
effective_group_info: grp.struct_group(gr_name='myPC', gr_passwd='x', gr_gid=1000, gr_mem=[])
LD_LIBRARY_PATH: None
cwd: '/home/myPC'
real_path='/home/myPC'
mode=0o40755 uid=1000 gid=1000
parent mode=0o40755 uid=999 gid=999
HOME: '/home/myPC'
appdata: '/home/myPC/.dropbox/instance1'
real_path='/home/myPC/.dropbox/instance1'
mode=0o40700 uid=1000 gid=1000
parent mode=0o40775 uid=1000 gid=1000
dropbox_path: '/home/myPC/Dropbox'
real_path='/home/myPC/Dropbox'
mode=0o40700 uid=1000 gid=1000
parent mode=0o40755 uid=1000 gid=1000
sys_executable: '/home/myPC/.dropbox-dist/dropbox-lnx.x86_64-88.4.172/dropbox'
real_path='/home/myPC/.dropbox-dist/dropbox-lnx.x86_64-88.4.172/dropbox'
mode=0o100775 uid=1000 gid=1000
parent mode=0o40775 uid=1000 gid=1000
trace.__file__: '/home/myPC/.dropbox-dist/dropbox-lnx.x86_64-88.4.172/python-packages.zip/dropbox/client/ui/common/boot_error.pyc'
real_path='/home/myPC/.dropbox-dist/dropbox-lnx.x86_64-88.4.172/python-packages.zip/dropbox/client/ui/common/boot_error.pyc'
not found
parent not found
tempdir: '/tmp'
real_path='/tmp'
mode=0o41777 uid=0 gid=0
parent mode=0o40755 uid=0 gid=0
Traceback (most recent call last):
File "dropbox/client/main.pyc", line 7977, in main_startup
File "dropbox/client/main.pyc", line 3526, in run
File "dropbox/client/ui/common/uikit.pyc", line 860, in create_ui_kit
File "dropbox/client/ui/qt/uikit.pyc", line 53, in <module>
File "<_bootstrap_overrides>", line 153, in load_module
ImportError: /home/myPC/.dropbox-dist/dropbox-lnx.x86_64-88.4.172/libQt5Core.so.5: version `Qt_5.12' not found (required by /usr/lib/x86_64-linux-gnu/libQt5Gui.so.5)

[Здравко]

Hi @pcooper,

Seems there is a complete mess in your install. I'll propose a reinstall of the application, entirely. Your data are on safe. Use following commands (one by one):

sudo apt-get purge dropbox
wget -O /tmp/dropbox.deb https://www.dropbox.com/download?dl=packages/ubuntu/dropbox_2020.03.04_amd64.deb
sudo dpkg -i /tmp/dropbox.deb
dropbox stop
rm -rf ~/.dropbox* /tmp/dropbox*
dropbox start -i

Your application is unlinked from the account, so the last command will ask for link it back. Let's see if this will help you. 🤔

Good luck.

[pcooper]

$ sudo apt-get purge dropbox
[sudo] password for myPC:
Reading package lists... Done
Building dependency tree
Reading state information... Done
Package 'dropbox' is not installed, so not removed
0 to upgrade, 0 to newly install, 0 to remove and 0 not to upgrade.
myPC@myPC:~$ sudo apt-get purge dropbox
[sudo] password for myPC:
Reading package lists... Done
Building dependency tree
Reading state information... Done
Package 'dropbox' is not installed, so not removed
0 to upgrade, 0 to newly install, 0 to remove and 0 not to upgrade.

myPC@myPC:~$ wget -O /tmp/dropbox.deb https://www.dropbox.com/download?dl=packages/ubuntu/dropbox_2020.03.04_amd64.deb
--2021-02-18 16:51:48-- https://www.dropbox.com/download?dl=packages/ubuntu/dropbox_2020.03.04_amd64.deb
Resolving www.dropbox.com (www.dropbox.com)... 162.125.64.18, 2620:100:6020:18::a27d:4012
Connecting to www.dropbox.com (www.dropbox.com)|162.125.64.18|:443... connected.
HTTP request sent, awaiting response... 301 Moved Permanently
Location: https://linux.dropbox.com/packages/ubuntu/dropbox_2020.03.04_amd64.deb [following]
--2021-02-18 16:51:48-- https://linux.dropbox.com/packages/ubuntu/dropbox_2020.03.04_amd64.deb
Resolving linux.dropbox.com (linux.dropbox.com)... 52.84.95.113, 52.84.95.51, 52.84.95.31, ...
Connecting to linux.dropbox.com (linux.dropbox.com)|52.84.95.113|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 69360 (68K) [application/octet-stream]
Saving to: ‘/tmp/dropbox.deb’

/tmp/dropbox.deb 100%[========================================================================================================================================>] 67.73K --.-KB/s in 0.04s

2021-02-18 16:51:49 (1.70 MB/s) - ‘/tmp/dropbox.deb’ saved [69360/69360]

myPC@myPC:~$ sudo dpkg -i /tmp/dropbox.deb
dpkg: regarding /tmp/dropbox.deb containing dropbox:
dropbox breaks nautilus-dropbox
nautilus-dropbox (version 2019.02.14-1ubuntu1) is present and installed.

dpkg: error processing archive /tmp/dropbox.deb (--install):
installing dropbox would break nautilus-dropbox, and
deconfiguration is not permitted (--auto-deconfigure might help)
Errors were encountered while processing:
/tmp/dropbox.deb
myPC@myPC:~$

and Ive gone no further at the moment.

[Здравко]

Seems you have installed older package that conflicts - as mentioned in the error message. Just remove it in advance, using following:

sudo apt-get purge nautilus-dropbox

... and continue where you stopped - the 'dpkg' command.

[pcooper]

thanks - fixed

[SerBer]

I have a problem launching the dropbox program, namely, it displays the following message:
the dropbox program failed to start. This is usually due to a lack of access rights. The error can also occur if the home folder is on a network share. There is also a link to this attached file. Help restore the normal operation of the application

n.BUILD_KEY: Dropbox
bn.VERSION: 126.4.4618
bn.constants.WINDOWS_SHELL_EXT_VERSION: 48
bn.is_frozen: True
machine_id: 85c9dd7c-7401-4f2b-bb11-2b6e27658fb7
pid: 12784
cwd: 'C:\\Program Files (x86)\\Dropbox\\Client'
real_path='C:\\Program Files (x86)\\Dropbox\\Client'
mode=0o40777 uid=0 gid=0
parent mode=0o40777 uid=0 gid=0
HOME: None
appdata: 'C:\\Users\\SerBer\\AppData\\Local\\Dropbox\\instance1'
real_path='C:\\Users\\SerBer\\AppData\\Local\\Dropbox\\instance1'
mode=0o40777 uid=0 gid=0
parent mode=0o40777 uid=0 gid=0
dropbox_path: 'C:\\Users\\SerBer\\Dropbox'
real_path='C:\\Users\\SerBer\\Dropbox'
mode=0o40555 uid=0 gid=0
parent mode=0o40777 uid=0 gid=0
sys_executable: 'C:\\Program Files (x86)\\Dropbox\\Client\\Dropbox.exe'
real_path='C:\\Program Files (x86)\\Dropbox\\Client\\Dropbox.exe'
mode=0o100777 uid=0 gid=0
parent mode=0o40777 uid=0 gid=0
trace.__file__: 'C:\\Program Files (x86)\\Dropbox\\Client\\126.4.4618\\python-packages.zip\\dropbox\\client\\ui\\common\\boot_error.pyc'
real_path='C:\\Program Files (x86)\\Dropbox\\Client\\126.4.4618\\python-packages.zip\\dropbox\\client\\ui\\common\\boot_error.pyc'
not found
parent not found
TMP: C:\Users\SerBer\AppData\Local\Temp
TEMP: C:\Users\SerBer\AppData\Local\Temp
tempdir: 'C:\\Users\\SerBer\\AppData\\Local\\Temp'
real_path='C:\\Users\\SerBer\\AppData\\Local\\Temp'
mode=0o40777 uid=0 gid=0
parent mode=0o40777 uid=0 gid=0
Traceback (most recent call last):
File "dropbox\client\authentication\register_host_helper.pyc", line 503, in _try_register_host
File "dropbox\client\authentication\register_host_helper.pyc", line 673, in _on_register_host_success
File "dropbox\client\multiaccount\instance_database.pyc", line 1131, in set_shared_config
File "dropbox\sqlite3_helpers.pyc", line 1059, in _runner
File "dropbox\client\multiaccount\instance_database.pyc", line 459, in set_shared_config
File "dropbox\sqlite3_helpers.pyc", line 301, in execute
File "dropbox\sqlite3_helpers.pyc", line 267, in _raise_better_operational_exception
File "six.pyc", line 696, in reraise
File "dropbox\sqlite3_helpers.pyc", line 296, in execute
sqlite3.OperationalError: attempt to write a readonly database

[Megan]

Hi @SerBer! Thanks for posting your error, let's see what we can do here. 

Let's try something.

Press the Windows Key + R (at the same time) then type "cmd" and press enter to open the Command prompt.

Copy and paste the following lines into the Command Prompt, one at a time, and press return after each one.

Make sure you copy and paste these commands. Don't worry if one of the instructions below fail or you can't find the folder in one of these locations. This is normal.

icacls "%HOMEPATH%\Dropbox" /grant "%USERNAME%":(F) /T

icacls "%APPDATA%\Dropbox" /grant "%USERNAME%":(F) /T

icacls "%LOCALAPPDATA%\Dropbox" /grant "%USERNAME%":(F) /T

If you have any questions before you do this, or if you see an error after running one of these commands, please let us know!