01-30-2024, 04:37 PM | #16 |
Bibliophagist
Posts: 36,697
Karma: 146499190
Join Date: Jul 2010
Location: Vancouver
Device: Kobo Sage, Libra Colour, Lenovo M8 FHD, Paperwhite 4, Tolino epos
|
Rather interesting how the OP managed to conflate the issue with Kindles randomly removing all sideloaded content which has nothing to do with USB connections and the Kobo database corruption issue which is due to the database not being closed before a USB connection is initiated.
|
01-30-2024, 04:59 PM | #17 |
the rook, bossing Never.
Posts: 11,641
Karma: 87590587
Join Date: Jun 2017
Location: Ireland
Device: All 4 Kinds: epub eink, Kindle, android eink, NxtPaper11
|
Indeed even the Kobo issue may not exactly be USB (and thus USB protocol/mode is irrelevant), but purely the system initiating the USB connection and locking the screen without closing the database first. It's a quite strange bug because it seems to afflict certain users, no matter what incantations or OS, other than rebooting. Yet others are fine if they simply make sure the 'home' / 'my books' screen is showing. It also might be that sync has a negative impact and SideloadedMode=true has a positive impact.
I can't see that using MTP or Network USB would stop it happening. It's not specifically misuse of the USB by the host or user, it's a bug in the software that not everyone is suffering, which is no doubt why it's taking time for Kobo to solve it. |
01-30-2024, 05:24 PM | #18 |
Bibliophagist
Posts: 36,697
Karma: 146499190
Join Date: Jul 2010
Location: Vancouver
Device: Kobo Sage, Libra Colour, Lenovo M8 FHD, Paperwhite 4, Tolino epos
|
Nothing like an erratic and likely race issue to make locating a bug fun (for certain values of fun).
|
01-30-2024, 05:40 PM | #19 |
Wizard
Posts: 2,542
Karma: 10479009
Join Date: Feb 2012
Device: Nook NST, Glow2, 3, 4, '21, Kobo Aura2, Poke3, Poke5
|
|
01-30-2024, 05:49 PM | #20 |
Bibliophagist
Posts: 36,697
Karma: 146499190
Join Date: Jul 2010
Location: Vancouver
Device: Kobo Sage, Libra Colour, Lenovo M8 FHD, Paperwhite 4, Tolino epos
|
|
01-30-2024, 07:03 PM | #21 |
Wizard
Posts: 2,542
Karma: 10479009
Join Date: Feb 2012
Device: Nook NST, Glow2, 3, 4, '21, Kobo Aura2, Poke3, Poke5
|
|
01-30-2024, 07:10 PM | #22 |
Grand Sorcerer
Posts: 10,427
Karma: 225537496
Join Date: Jan 2014
Location: Estonia
Device: Kobo Sage & Libra 2
|
|
01-30-2024, 08:35 PM | #23 | |
Custom User Title
Posts: 8,839
Karma: 62032373
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
|
Quote:
Plus we know Kobo is planning to fix it. What the hell is this thread for then? Last edited by ownedbycats; 01-30-2024 at 08:41 PM. |
|
01-31-2024, 06:33 AM | #24 | |
the rook, bossing Never.
Posts: 11,641
Karma: 87590587
Join Date: Jun 2017
Location: Ireland
Device: All 4 Kinds: epub eink, Kindle, android eink, NxtPaper11
|
Quote:
I suspect that while Kindle's OS is multitasking and multiuser the the database and ebook import system is not, so it makes sense that the Kindle Scribe 'locks' the screen even though it uses MTP. Similarly while my Andriod things don't lock the screen, I don't use the GUI on them and also close all apps before connecting USB for MTP. You just don't know how Google PlayBooks, PocketBook, Viber, Kindle app etc actually works. Unlike MSDE, MS SQL, Oracle, DB2, MySQL, MariaDB the SQLight, just like Access or Excel data, is simply files and an API. So two processes / apps accessing the SQLight database will corrupt it, though with Kobo and USB, normally you are only accessing ebook files and cover image files while USB is connected and the Kobo accesses the database when you disconnect USB. It could even be that it's that process that causes the damage because it hasn't checked what last state was, or the process last using the database didn't close it before locking screen and opening USB connection. The fact that the database corruption can occur just by copying a single epub file to the Kobo, without touching the database files, shows it's not specifically a USB issue and that it could occur even if the SQLight files were on the system partition that's not shared. The database import occurs after USB is disconnected, so as the exposed files show the issue is not the kind of USB connection but something amiss when the USB connection request is triggered. I always wait a little before clicking on the connect message when I plug in USB cable. I've no idea if that helps, but I don't have the problem. I also always thought 'auto-connect' sounded like a risky developer tool. Android used to autoconnect and last few versions I have it asks even though a default mode is set. ADB needs Developer mode on for many Android devices and that's not recommended for general use, nor is ADB which I've used as an Android developer and to do funky command line fast transfers or web cam/photo capture modes. ADB is not a system for regular users. Last edited by Quoth; 01-31-2024 at 06:51 AM. |
|
01-31-2024, 10:39 PM | #25 | |||
Bibliophagist
Posts: 36,697
Karma: 146499190
Join Date: Jul 2010
Location: Vancouver
Device: Kobo Sage, Libra Colour, Lenovo M8 FHD, Paperwhite 4, Tolino epos
|
Quote:
Quote:
Quote:
|
|||
01-31-2024, 11:16 PM | #26 | |
Custom User Title
Posts: 8,839
Karma: 62032373
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
|
Quote:
I use NickelMenu to reboot following the import of new books - I've mentioned that some of my random instances of the db being left open were a reconnect immediately following import. It'll automatically reconnect itself right afterwards, which is convenient. |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Clara Is occasional database corruption to be expected? | Desertway | Kobo Reader | 25 | 05-23-2022 07:53 PM |
Database Corruption / FW 3.5.0 | PeterT | Kobo Reader | 7 | 08-26-2014 04:10 PM |
Database Corruption during Installation | aronan | Calibre | 3 | 09-10-2010 01:17 AM |
Problems after database corruption | ficbot | Calibre | 2 | 09-25-2009 02:11 PM |
Database Corruption!! | Alexander Turcic | Announcements | 0 | 07-22-2003 10:08 AM |