[Bug] [AppFlowy-Web] Record Not Found

[smartyhero]

Bug Description

My self-hosted appflowy has many documents on the web page that say Record Not Found

How to Reproduce

I don't know how to reproduce

Expected Behavior

The page can be displayed normally

Operating System

mac，win

AppFlowy Version(s)

0.8.1, 0.1.2

Screenshots

No response

Additional Context

No response

[khorshuheng]

Can you check if the collab id (last part of the URL) exists in the af_collab table? The id column is "oid".

EDIT: Just noticed that the AppFlowy Cloud version is 0.8.1 . The current version of AppFlowy Web (0.1.2) requires minimum AppFlowy Cloud version 0.9.9. I have not verified if it will work with AppFlowy Cloud version 0.8.1, but even if it does, some functionality will not work properly.

[smartyhero]

The data exists

The version of appflowy-cloud is the latest, version 0.9.11

[smartyhero]

This is the log of appflowy-cloud I found

[khorshuheng]

On the developer console - the API request that returns the error about RecordNotFound, is it the get page view API?

[smartyhero]

/api/workspace/4aea66a2-406a-4ebb-bb83-26646234398e/page-view/44c0521d-a514-48e1-92e1-ba489e9f5fe2

[khorshuheng]

Noted. I think i might need to add more descriptive error message on AppFlowy Cloud in order to find out the root cause. Do you remember if this page is a database, or a document?

[smartyhero]

It is a document

[khorshuheng]

Could you use this appflowy cloud image: appflowyinc/appflowy_cloud:4831ce7e65babaf4c36db0c80d03d18c29d62c0a ? This is built from AppFlowy-IO/AppFlowy-Cloud#1166 , which hasn't been merged yet. This does not fix the issue, but it may show error messages which are more useful to troubleshoot the issue.

[smartyhero]

This is the error returned by the api now

{
    "code": 1017,
    "message": "Unable to get user detail for 1: no rows returned by a query that expected to return at least one row"
}

Below is the log of appflowy-cloud

[khorshuheng]

Have you ever deleted/removed some users, who may have edited the document in the past?

Nevertheless, I think we can handle such case, such that it doesn't result in a complete failure of page rendering

[smartyhero]

I may have deleted a user, but I don't remember clearly

I checked my database, and there is no user with uid 1

It seems that 1 is a special uid, and the uids of my existing users are all very long strings of numbers

[khorshuheng]

Yes, you are correct. We only use uid = 1 for integration test, so it's strange that it appears here. But in any case, this scenario (last editor/owner not found) is something that we should have handled on the backend. We will fix this.

[smartyhero]

Thank you for your contribution

[khorshuheng]

Will be fixed by AppFlowy-IO/AppFlowy-Cloud#1171 .