Touch Signing out the reader

touring · 01-23-2016, 03:06 AM

I loaded some new books on my Kobo Touch (Firmware version 1.9.17) via Calibre but the books don't show (although can be seen in Windows Explorer on PC). The Kobo has "processed content" three times taking forever, but fails to find the books.

I've seen a suggestion that I should sign out of the Kobo (via settings/account), but mine simply says "signed in as a@b.com" and gives no option to sign out when it's not connected to a PC.

Do I need to be connected via the Kobo app to sign out? If so how, because it only has a black screen saying "connected"?

Once I manage to sign out and back in, I understand that the Kobo will recreate its database from the existing files without the need to reload them - is that right? I used the Calibre Kobo Utilities plugin to check the database, but it's reported as OK. The utilities give an error message if I try to compress the database.

davidfor · 01-23-2016, 05:31 AM

It's been a long time since I use 1.9.17 on my Touch, but from memory, it didn't have a signout option. That was added a lot later. Once you connect to the PC, there is nothing you can do on the device, all interaction with it is from the computer. And while the desktop application has a signout option, I don't think affect the device when it is connected.

For the compress, I'm surprised there was an error if the check didn't find a problem. What was the error message?

But, the problem you are seeing is probably a problem with a book. If the device doesn't like a book for some reason, the processing stops. And no books are added to the library. And the next time the processing happens, that same book will stop the processing again. Unfortunately, there are no errors displayed and no easy way to work out which book it is.

To get around this, you need to remove the books that are not in the library on the device. Then, add them in smaller batches or one at a time. When you find the book that doesn't work, you remove it and go on to the next.

Fixing the book might be as simple as a epub-to-epub conversion in calibre, or opening in the editor and checking for errors.

touring · 01-23-2016, 05:48 AM

Thank you David. I have rarely posted in this forum, but am speechless at the wonderful support that you have given to me and many others over the years. It's really appreciated.

You confirmed my suspicion that the signout option was only offered later, and I don't think the Kobo app will make any difference. I've always had irritating aspects of my device, so when I found the right firmware I stayed there a couple of years ago - and have enjoyed many books since.

I got 2 different error messages for the compress. One (I think) along the lines of 'database full' and another relating to 'database locked'.

The problem started after I added around 100 books to an 800 book collection which has been static for years. It will probably be a challenge working out how to identify the new books (although Calibre may help), and a previous database backup will be way out of date. Grrr.

Thanks for your advice David. It looks like I'll need to think about identifying the route of least pain. With luck it will be another couple of years before I bother you again!

davidfor · 01-23-2016, 06:29 AM

I'm curious as to what the actual error messages for the compress were. I can't think why you would get a "database full" message and the only reason for a locked message is if something else was using it. Trying to compress the database while the calibre jobs were still running might cause that.

For finding the problem books, you should be able to do a search for recent files when connected to the device. If you sent 100 books, they would all have roughly the same timestamp. The order they are processed in has changed over time. I think 1.9.17 was processing them in filename order. But, it might have been the full path.

touring · 01-23-2016, 07:27 AM

Looking back at my Google searches, it was probably "operational error: database is locked" and "operational error: database or disk is full".

Thanks for the troubleshooting suggestion, I'll try that.

filmo · 01-24-2016, 12:23 PM

Calibre has sort library by date books were added option. Change sort by left clicking on column header name, Title, Date or Author.

touring · 01-24-2016, 05:28 PM

Thanks Filmo

Does this mean that even if there was a way to delete and replace to sqlite file, rebuilding the database would not work anyway? That the only way is to identify the dud book?

jackastor · 01-24-2016, 08:21 PM

Quote:

Originally Posted by touring

Thanks Filmo

Does this mean that even if there was a way to delete and replace to sqlite file, rebuilding the database would not work anyway? That the only way is to identify the dud book?

well if its a bad book, its in the 100 you added.

You can add 5 at a time and see what happens or 20 at a time.
If the first batch get processed ok, you go on to the next 20, or so. If there is a problem in the next batch you can remove the books, and add one at a time till you find the book in that batch that is the issue.
Mind you if its a bad database due to corruption the only way to fix it is to replace it with a known good copy, or to sign out and back in on the device. Might mean you have to update the firmware though, and if your happy with the current firmware you may not want to do that!

good luck

Jack

davidfor · 01-24-2016, 10:48 PM

Quote:

Originally Posted by touring

Does this mean that even if there was a way to delete and replace to sqlite file, rebuilding the database would not work anyway? That the only way is to identify the dud book?

If he problem is a bad book, then the only way to fix things is to remove and fix the book.

For the errors when you tried to compress the database, the locked error usually means something else is accessing the database. Make sure you don't do this while he calibre connection jobs are running. The database or disk full error is a bit stranger. Unless the device's disk is full, or the database is very large, it's unexpected. It can mean the temp directory used when compressing the database, but that should be the devices drive, so again, unless that is full, it is not expected.

touring · 01-25-2016, 04:18 AM

Thank you Jack and David.
Fortunately I have some backups with Calibre and Kobo Utilities. It looks like my only solution will be to identify the books that I added within Calibre, then to remove them en masse. Finally add the books back a few at a time.

The Date field in Calibre seems to be the date added, and I have identified the 66 books added on the same day recently. I will remove them and see how I go.

touring · 01-25-2016, 04:40 AM

I just tried to do another compress, and got this error message with no Calibre jobs running:
calibre, version 2.49.0
ERROR: Unhandled exception: <b>OperationalError</b>:database or disk is full

calibre 2.49 isfrozen: True is64bit: False
Windows-7-6.1.7601-SP1 Windows ('32bit', 'WindowsPE')
32bit process running on 64bit windows
('Windows', '7', '6.1.7601')
Python 2.7.9
Windows: ('7', '6.1.7601', 'SP1', 'Multiprocessor Free')
Successfully initialized third party plugins: Find Duplicates && Kobo Utilities
Traceback (most recent call last):
File "calibre_plugins.koboutilities.action", line 1472, in vacuum_device_database
File "calibre_plugins.koboutilities.action", line 3222, in _vacuum_device_database
OperationalError: database or disk is full

davidfor · 01-25-2016, 05:27 AM

Quote:

Originally Posted by touring

The Date field in Calibre seems to be the date added, and I have identified the 66 books added on the same day recently. I will remove them and see how I go.

Yes, the "Date" field in the main calibre library is when the book was added to the calibre library. There is also a date field in the device view. In this case, it is the date it was added to the device. But, that won't help you anything in the device list has been processed successfully by the device.

If what you did was to add 66 books to calibre and then send them to the device, you want to delete all the files for the books from the device that do not have a tick in the "On Device" column when the device is connected.

davidfor · 01-25-2016, 05:35 AM

Quote:

Originally Posted by touring

I just tried to do another compress, and got this error message with no Calibre jobs running:
calibre, version 2.49.0
ERROR: Unhandled exception: <b>OperationalError</b>:database or disk is full

calibre 2.49 isfrozen: True is64bit: False
Windows-7-6.1.7601-SP1 Windows ('32bit', 'WindowsPE')
32bit process running on 64bit windows
('Windows', '7', '6.1.7601')
Python 2.7.9
Windows: ('7', '6.1.7601', 'SP1', 'Multiprocessor Free')
Successfully initialized third party plugins: Find Duplicates && Kobo Utilities
Traceback (most recent call last):
File "calibre_plugins.koboutilities.action", line 1472, in vacuum_device_database
File "calibre_plugins.koboutilities.action", line 3222, in _vacuum_device_database
OperationalError: database or disk is full

How big is the database file? How much space is available on the device? If it isn't to big and there is space available, I don't understand what is happening. Maybe looking at the database would give me an idea? Could I get a copy of the database file? The best thing would be to put it somewhere and send me a PM with the link to the file. Or, if you would prefer to email it, send me a PM and I'll send you the address.

touring · 01-25-2016, 07:54 AM

Success! Thanks all for your advice - as I was looking at the books I had recently installed I noticed that one had the same author name as title. I removed that book from the Touch and corrected it in Calibre. The Kobo processed the books and now shows all books loaded (except that one).

David, the sqlite is file is 40Mb (about 900 books loaded). The database checks OK, and backs up fine. According to Windows Explorer I have used 1.3Gb and have 8k left, although I thought I had an SD card in it. Just looked but the slot seems empty. Doesn't it come with 2 GB internal?

davidfor · 01-25-2016, 08:24 AM

Quote:

Originally Posted by touring

Success! Thanks all for your advice - as I was looking at the books I had recently installed I noticed that one had the same author name as title. I removed that book from the Touch and corrected it in Calibre. The Kobo processed the books and now shows all books loaded (except that one).

That shouldn't have caused a problem, but it was probably a sign that something else wrong.

Quote:

David, the sqlite is file is 40Mb (about 900 books loaded). The database checks OK, and backs up fine. According to Windows Explorer I have used 1.3Gb and have 8k left, although I thought I had an SD card in it. Just looked but the slot seems empty. Doesn't it come with 2 GB internal?

You have 8KB left on the device? In that case, your lucky anything is working. And the compress would definitely not work. I would recommend trying to keep at least 10MB free, and preferably around 50MB free. As this is FW 1.9.17, I would run the "Clean images" function in the Kobo Utilities. From memory, the likelihood of cover images being left behind was fairly high with this.

The Touch has 2GB of internal memory. For the N905 model, this is fixed memory. For the N905B and N905C, it is a micro SD card. The memory is divided into three partitions; the root partition with the OS, the recovery partition and the data partition. The first two are about 256KB each. That leaves about 1.3GB for the data partition.

01-23-2016, 03:06 AM	#1
touring Connoisseur Posts: 69 Karma: 10 Join Date: Jan 2012 Location: Australia Device: Kobo Clara	Signing out the reader I loaded some new books on my Kobo Touch (Firmware version 1.9.17) via Calibre but the books don't show (although can be seen in Windows Explorer on PC). The Kobo has "processed content" three times taking forever, but fails to find the books. I've seen a suggestion that I should sign out of the Kobo (via settings/account), but mine simply says "signed in as a@b.com" and gives no option to sign out when it's not connected to a PC. Do I need to be connected via the Kobo app to sign out? If so how, because it only has a black screen saying "connected"? Once I manage to sign out and back in, I understand that the Kobo will recreate its database from the existing files without the need to reload them - is that right? I used the Calibre Kobo Utilities plugin to check the database, but it's reported as OK. The utilities give an error message if I try to compress the database.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
got booted when I was signing up	logie0310	Introduce Yourself	4	07-31-2012 03:06 AM
Dutch (e-)reader signing in	frodonl	Introduce Yourself	5	04-27-2011 07:29 AM
eBook Signing?	MickeyC	General Discussions	14	08-05-2010 12:13 PM
Signing on...	WigglePig	Introduce Yourself	24	09-11-2008 07:46 PM
Signing the Reader	bingle	Sony Reader	24	02-16-2007 03:18 PM

01-23-2016, 05:31 AM	#2
davidfor Grand Sorcerer Posts: 24,905 Karma: 47303824 Join Date: Jul 2011 Location: Sydney, Australia Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos	It's been a long time since I use 1.9.17 on my Touch, but from memory, it didn't have a signout option. That was added a lot later. Once you connect to the PC, there is nothing you can do on the device, all interaction with it is from the computer. And while the desktop application has a signout option, I don't think affect the device when it is connected. For the compress, I'm surprised there was an error if the check didn't find a problem. What was the error message? But, the problem you are seeing is probably a problem with a book. If the device doesn't like a book for some reason, the processing stops. And no books are added to the library. And the next time the processing happens, that same book will stop the processing again. Unfortunately, there are no errors displayed and no easy way to work out which book it is. To get around this, you need to remove the books that are not in the library on the device. Then, add them in smaller batches or one at a time. When you find the book that doesn't work, you remove it and go on to the next. Fixing the book might be as simple as a epub-to-epub conversion in calibre, or opening in the editor and checking for errors.

01-23-2016, 05:48 AM	#3
touring Connoisseur Posts: 69 Karma: 10 Join Date: Jan 2012 Location: Australia Device: Kobo Clara	Thank you David. I have rarely posted in this forum, but am speechless at the wonderful support that you have given to me and many others over the years. It's really appreciated. You confirmed my suspicion that the signout option was only offered later, and I don't think the Kobo app will make any difference. I've always had irritating aspects of my device, so when I found the right firmware I stayed there a couple of years ago - and have enjoyed many books since. I got 2 different error messages for the compress. One (I think) along the lines of 'database full' and another relating to 'database locked'. The problem started after I added around 100 books to an 800 book collection which has been static for years. It will probably be a challenge working out how to identify the new books (although Calibre may help), and a previous database backup will be way out of date. Grrr. Thanks for your advice David. It looks like I'll need to think about identifying the route of least pain. With luck it will be another couple of years before I bother you again!

01-23-2016, 06:29 AM	#4
davidfor Grand Sorcerer Posts: 24,905 Karma: 47303824 Join Date: Jul 2011 Location: Sydney, Australia Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos	I'm curious as to what the actual error messages for the compress were. I can't think why you would get a "database full" message and the only reason for a locked message is if something else was using it. Trying to compress the database while the calibre jobs were still running might cause that. For finding the problem books, you should be able to do a search for recent files when connected to the device. If you sent 100 books, they would all have roughly the same timestamp. The order they are processed in has changed over time. I think 1.9.17 was processing them in filename order. But, it might have been the full path.

01-23-2016, 07:27 AM	#5
touring Connoisseur Posts: 69 Karma: 10 Join Date: Jan 2012 Location: Australia Device: Kobo Clara	Looking back at my Google searches, it was probably "operational error: database is locked" and "operational error: database or disk is full". Thanks for the troubleshooting suggestion, I'll try that.

01-24-2016, 12:23 PM	#6
filmo Wizard Posts: 1,326 Karma: 1077205 Join Date: Jun 2011 Device: Kobo Touch, Sony T1, Kobo Mini	Calibre has sort library by date books were added option. Change sort by left clicking on column header name, Title, Date or Author.

01-24-2016, 05:28 PM	#7
touring Connoisseur Posts: 69 Karma: 10 Join Date: Jan 2012 Location: Australia Device: Kobo Clara	Thanks Filmo Does this mean that even if there was a way to delete and replace to sqlite file, rebuilding the database would not work anyway? That the only way is to identify the dud book?

01-25-2016, 04:18 AM	#10
touring Connoisseur Posts: 69 Karma: 10 Join Date: Jan 2012 Location: Australia Device: Kobo Clara	Thank you Jack and David. Fortunately I have some backups with Calibre and Kobo Utilities. It looks like my only solution will be to identify the books that I added within Calibre, then to remove them en masse. Finally add the books back a few at a time. The Date field in Calibre seems to be the date added, and I have identified the 66 books added on the same day recently. I will remove them and see how I go.

01-25-2016, 04:40 AM	#11
touring Connoisseur Posts: 69 Karma: 10 Join Date: Jan 2012 Location: Australia Device: Kobo Clara	I just tried to do another compress, and got this error message with no Calibre jobs running: calibre, version 2.49.0 ERROR: Unhandled exception: <b>OperationalError</b>:database or disk is full calibre 2.49 isfrozen: True is64bit: False Windows-7-6.1.7601-SP1 Windows ('32bit', 'WindowsPE') 32bit process running on 64bit windows ('Windows', '7', '6.1.7601') Python 2.7.9 Windows: ('7', '6.1.7601', 'SP1', 'Multiprocessor Free') Successfully initialized third party plugins: Find Duplicates && Kobo Utilities Traceback (most recent call last): File "calibre_plugins.koboutilities.action", line 1472, in vacuum_device_database File "calibre_plugins.koboutilities.action", line 3222, in _vacuum_device_database OperationalError: database or disk is full

01-25-2016, 07:54 AM	#14
touring Connoisseur Posts: 69 Karma: 10 Join Date: Jan 2012 Location: Australia Device: Kobo Clara	Success! Thanks all for your advice - as I was looking at the books I had recently installed I noticed that one had the same author name as title. I removed that book from the Touch and corrected it in Calibre. The Kobo processed the books and now shows all books loaded (except that one). David, the sqlite is file is 40Mb (about 900 books loaded). The database checks OK, and backs up fine. According to Windows Explorer I have used 1.3Gb and have 8k left, although I thought I had an SD card in it. Just looked but the slot seems empty. Doesn't it come with 2 GB internal?