Notebook disappeared after failed sharing attempt

Operating system

Windows

Joplin version

3.2.13

Desktop version info

Joplin 3.2.13 (prod, win32)

Client ID: 798dcc9cebae4ab08da69993d2a2107a
Sync Version: 3
Profile Version: 47
Keychain Supported: Yes

Revision: a898e17

Backup: 1.4.2
Freehand Drawing: 2.14.0
Victor: 1.0.3

Sync target

Joplin Cloud

What issue do you have?

I attempted to share one of my notebooks. After adding the recipient email address and clicking the "Share" button, nothing happened and the email did not show up in the recipients list. However, the notebook and sub-folders all turned yellow. After confirming that the recipient never received a sharing approval request, I attempted to share the notebook again. I entered the recipient's email address, clicked the "Share" button, and this time it added the recipient email address to the recipients list, and the recipient received an approval request for the shared folder. The recipient clicked "Accept", but the notebook never showed up for the recipient. Then the prompt for the recipient to accept the share appeared again, and the receipient clicked "Accept" again. It eventually gave the recipient an error, stating the following:
'Could not respond to the invitation. Please try again, or check with the notebook owner if they are still sharing it. The error was "insert into "user items" ("created_time", "Item_id", "updated_time", "user_id") values ($1, $2, $3, $4) - duplicate key value violates unique constraint "user_items_user_id_item_id_unique""'.
The notebook never showed up to the recipient after the recipient synced.

So I went back to the source computer and attempted to unshare the notebook so I could attempt to start the sharing process again. However, when I attempted to unshare the notebook, it gave me an error stating "The recipient could not be removed from the list. Please try again", followed by a similar error immediately afterward (screenshots attached).

Then, after it synced, the whole notebook that I had attempted to share then unshare completely vanished. I could not find any trace of it anywhere.

What happened to the notebook, and how can a notebook suddenly vanish?

Screenshots



Log file

This is definitely a bug. Would you mind creating a bug report on the Joplin repository on GitHub?

In terms of getting your notebook back, the backup plugin which is enabled by default in Joplin should be creating daily backups. Have a look at the recent jex backups, create a new profile in Joplin and import your latest backup which is earlier than when the notebook disappeared. Then you can export the specific notebook as jex from that imported backup, and then import that jex into your main profile.