Database Schemas & Documentation

Development
1

Hello,

I need to debug an issue I'm having with the Joplin 2.2.7 client on macOS.

I have two macs, and one of them syncs fine with server version 2.2.11-beta.

The client with a problem emits an Unknown error: (400) while attempting to upload resources that haven't been modified.

I'm not asking for help to fix the problem, but rather assistance debugging the problem.

The first thing I tried to do was find documentation on the SQLite schema housed in this file.

$HOME/.config/joplin-desktop/database.sqlite

Is there any documentation on this schema? Is there documentation on the Joplin server schema as well? Documentation on the android app's schema would also be helpful, as I'm dealing with issues on that app.

If necessary, I can infer the purpose of various fields from the code and start some documentation if it doesn't exist. I won't go blindly into debugging without understanding the true meaning of all the various schemas.

Any knowledge beyond this documentation is welcome.

2

I think you should start with the complete error message you got.

3

Sure, though I'm looking for help debugging rather than fixing. :slight_smile:

error.log (92.3 KB)

4

I can't tell from the debug log, but maybe you'll have more luck by checking the server log. Does your server allow resources of that size to be uploaded? (it's not particularly large at 102592 bytes but still worth checking)

The reason I'm asking for the error message is that I think you're not looking in the right place. DB schema, how to build the app, etc. won't help you to figure out that error which is most likely a problem with the server.

5

I looked at the server logs as well and I don't see a smoking gun.

I thought it might be a size restriction and server issue at first, but this isn't happening on my home machine.

It's very odd behavior. When I understand the schema I can start stepping through the code to find the source of the problem.