cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Announcements
Learn all about how Alex on the Community team used Dropbox in college here!

Dropbox installs & integrations

Connect your tools and content together with help from the Dropbox Community. Join a discussion or post a question of your own to get started.

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

sqlite3.OperationalError: database is locked

sqlite3.OperationalError: database is locked

grolma
New member | Level 2

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

6 Replies 6

Re: sqlite3.OperationalError: database is locked

Jay
Dropboxer
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!

Jay
Community Moderator @ Dropbox
dropbox.com/support


Heart Did this post help you? If so, please give it a Like below.
:arrows_counterclockwise: Still stuck? Ask me a question!
:pushpin: Tips & Tricks Find new ways to stay in flow or share your tips on how you work smarter with Dropbox.

Re: sqlite3.OperationalError: database is locked

pcooper
Explorer | Level 3

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)

Re: sqlite3.OperationalError: database is locked

Здравко
Super Collaborator | Level 20

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.

Re: sqlite3.OperationalError: database is locked

pcooper
Explorer | Level 3

$ 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.

 

Re: sqlite3.OperationalError: database is locked

Здравко
Super Collaborator | Level 20

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.

Re: sqlite3.OperationalError: database is locked

pcooper
Explorer | Level 3

thanks - fixed

 

Who's talking

Top contributors to this post

What do Dropbox user levels mean?
Need more support?