unable to debug "read only database"

Rellwood · 08-11-2018, 07:53 PM

I had moved my libraries to Dropbox some time ago, and hadn't come across this problem. Like the title reads, I can't restart in debug mode because the database is read only.

I went into the permissions on all the parent folders and made sure they were ok for everyone (ie. users, other users, system, etc.). Then I went into the folders to the db file as well as the .json file and confirmed they were ok to write on.

So what gives?

We all know that the general folders holding libraries all have the grayed out read only box, but that never was a problem. Even still I made sure to apply the write settings to the entire folder. This didn't last as it immediately reverted back.

Any suggestions?

Rellwood · 08-11-2018, 08:08 PM

calibre, version 3.29.0
Corrupted database: The library database at C:\Users\MyPC\Dropbox\Calibrefromtoshiba\0.Primary 3 appears to be corrupted. Do you want calibre to try and rebuild it automatically? The rebuild may not be completely successful. If you say No, a new empty calibre library will be created.

Traceback (most recent call last):
File "site-packages\calibre\gui2\main.py", line 305, in initialize_db
File "site-packages\calibre\db\legacy.py", line 81, in __init__
File "site-packages\calibre\db\legacy.py", line 48, in create_backend
File "site-packages\calibre\db\backend.py", line 384, in __init__
File "site-packages\calibre\db\schema_upgrades.py", line 19, in __init__
File "site-packages\calibre\db\backend.py", line 843, in execute
File "c:\t\t\apsw-j1n8vs\apsw-3.23.1-r1\src\cursor.c", line 236, in resetcursor
ReadOnlyError: ReadOnlyError: attempt to write a readonly database

kovidgoyal · 08-11-2018, 08:10 PM

That error can be caused by file permissions, or some program such as an antivirus interfering with calibre or something like dropbox accessing the calibre library folder at the same time as calibre.

Rellwood · 08-11-2018, 08:21 PM

Let me check on another user id.

I have Dropbox exited on my computer, so it isn't updating.

I know that I can open the library if I just open it, but trying to restart it in debug mode is what makes it "corrupt"

Although I do know that I can debug libraries not on Dropbox.
I will check a bit more.

Rellwood · 08-11-2018, 08:40 PM

Quote:

Originally Posted by kovidgoyal

That error can be caused by file permissions, or some program such as an antivirus interfering with calibre or something like dropbox accessing the calibre library folder at the same time as calibre.

Was the Bitdefender Program. I uninstalled it. Thanks!

cHap85Lzwdzr · 08-12-2018, 02:15 PM

Hello All:

I had the same problem. Bitdefender has a "feature" (this caused me a lot of frustration until I found out about it) named "Safe Files" which will protect user directories by default. Excluding the Calibre directory in Bitdefender Anti-Virus will not resolve the issue.

Rather than uninstalling Bitdefender, you can give Calibre access to the "Safe Files" by (in Bitdefender Total Security 2018) Opening Bitdefender, going to "View Features>SAFE FILES>Application Access" and clicking the switch next to "calibre.exe" so that it reads "Allowed."

Hopefully this will resolve the issue for any of you Bitdefender users out there.

08-11-2018, 07:53 PM	#1
Rellwood Library Breeder (She/Her) Posts: 1,156 Karma: 1900479 Join Date: Apr 2015 Location: Fullerton, California Device: Kobo Aura HD (1) PW3 (4) PW3 2019 new edition (1)	unable to debug "read only database" I had moved my libraries to Dropbox some time ago, and hadn't come across this problem. Like the title reads, I can't restart in debug mode because the database is read only. I went into the permissions on all the parent folders and made sure they were ok for everyone (ie. users, other users, system, etc.). Then I went into the folders to the db file as well as the .json file and confirmed they were ok to write on. So what gives? We all know that the general folders holding libraries all have the grayed out read only box, but that never was a problem. Even still I made sure to apply the write settings to the entire folder. This didn't last as it immediately reverted back. Any suggestions?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to fix "Extra Titles" in Database in " Check Library - Problems Found	millan	Library Management	33	07-16-2015 07:12 AM
Touch How transfer "Books Read" and "Hours Read" data	Abrakadabra77	Kobo Reader	5	02-16-2015 03:30 AM
How change "Read" to "UnRead" on a SubForum?	unboggling	Feedback	3	05-20-2012 02:48 AM
How to remove "Fully read" books from "Last Open" list?	pjeanetta	PocketBook	4	12-08-2010 10:30 AM
What happened to calibre-debug "--develop-from" option?	macr0t0r	Calibre	6	12-03-2009 07:22 PM

08-11-2018, 08:08 PM	#2
Rellwood Library Breeder (She/Her) Posts: 1,156 Karma: 1900479 Join Date: Apr 2015 Location: Fullerton, California Device: Kobo Aura HD (1) PW3 (4) PW3 2019 new edition (1)	calibre, version 3.29.0 Corrupted database: The library database at C:\Users\MyPC\Dropbox\Calibrefromtoshiba\0.Primary 3 appears to be corrupted. Do you want calibre to try and rebuild it automatically? The rebuild may not be completely successful. If you say No, a new empty calibre library will be created. Traceback (most recent call last): File "site-packages\calibre\gui2\main.py", line 305, in initialize_db File "site-packages\calibre\db\legacy.py", line 81, in __init__ File "site-packages\calibre\db\legacy.py", line 48, in create_backend File "site-packages\calibre\db\backend.py", line 384, in __init__ File "site-packages\calibre\db\schema_upgrades.py", line 19, in __init__ File "site-packages\calibre\db\backend.py", line 843, in execute File "c:\t\t\apsw-j1n8vs\apsw-3.23.1-r1\src\cursor.c", line 236, in resetcursor ReadOnlyError: ReadOnlyError: attempt to write a readonly database

08-11-2018, 08:10 PM	#3
kovidgoyal creator of calibre Posts: 43,858 Karma: 22666666 Join Date: Oct 2006 Location: Mumbai, India Device: Various	That error can be caused by file permissions, or some program such as an antivirus interfering with calibre or something like dropbox accessing the calibre library folder at the same time as calibre.

08-11-2018, 08:21 PM	#4
Rellwood Library Breeder (She/Her) Posts: 1,156 Karma: 1900479 Join Date: Apr 2015 Location: Fullerton, California Device: Kobo Aura HD (1) PW3 (4) PW3 2019 new edition (1)	Let me check on another user id. I have Dropbox exited on my computer, so it isn't updating. I know that I can open the library if I just open it, but trying to restart it in debug mode is what makes it "corrupt" Although I do know that I can debug libraries not on Dropbox. I will check a bit more.

08-12-2018, 02:15 PM	#6
cHap85Lzwdzr Junior Member Posts: 3 Karma: 10 Join Date: Jul 2018 Device: Windows 10	Hello All: I had the same problem. Bitdefender has a "feature" (this caused me a lot of frustration until I found out about it) named "Safe Files" which will protect user directories by default. Excluding the Calibre directory in Bitdefender Anti-Virus will not resolve the issue. Rather than uninstalling Bitdefender, you can give Calibre access to the "Safe Files" by (in Bitdefender Total Security 2018) Opening Bitdefender, going to "View Features>SAFE FILES>Application Access" and clicking the switch next to "calibre.exe" so that it reads "Allowed." Hopefully this will resolve the issue for any of you Bitdefender users out there.