I understand that resources larger than 10 MB are not currently supported and crash the application. This really limits what I had intended to use Joplin for (a knowledge base) and I will have to rethink some things however I understand this limitation.
I do not believe that this caused my sync issue. I am not experiencing any type of app crash either. Rather, I think the issue was caused by a large note (not an attachment). One I followed the instructions from the other user here: Synchronization error on Android and deleted my large note (which didn’t have any resource attachment), many of my links did unencrypt on mobile right away. What I still don’t understand is that I have eliminated all the large notes, I don’t have any resources over 10mb but I am still getting the sync error, I still have encrypted notes on mobile and I have stranded resources in dropbox now.
I would like to know, what is the maximum size of a note that is supported? I have read it might be 1mb, 2mb, 10mb or 50mb in previous posts but I don’t know what the current limitation is.
So I am not speaking about limiting the size of the attachment but limiting the size of the note. If there is a known database limit on how many characters can be stored in the body field of the note table then Joplin should enforce this. Right now the web clipper will allow me to save a large webpage. When I looked at the notes table I had several notes that had 500,000+ characters and were 8mb large. This is data that is stored inside the database not a link to an attachment.
Laurent, can you confirm if the “Row too big to fit into CursorWindow requiredPos=16, totalRows=17” error is caused by a large resource or large note and if so what are the current limits of note size (the inline data)?