[GH-ISSUE #2152] [Bug] The program cannot run properly. #870

Closed
opened 2026-03-23 20:42:15 +00:00 by mirror · 10 comments
Owner

Originally created by @taylormao on GitHub (Mar 31, 2023).
Original GitHub issue: https://github.com/AppFlowy-IO/AppFlowy/issues/2152

Originally assigned to: @appflowy on GitHub.

Bug Description

I am using the operating system Windows 10 LTSC Version 21H2. I downloaded AppFlowy_0.1.2_windows-x86_64.zip from https://github.com/AppFlowy-IO/appflowy/releases. After I extracted it and clicked on AppFlowy.exe, a white screen appeared without any buttons. This state persisted for about 30 seconds, and then the application suddenly disappeared. In other words, I cannot use this program normally. I am very sad about this.

How to Reproduce

ddownload and unzip ,and click the appflowy.exe

Expected Behavior

I am using the operating system Windows 10 LTSC Version 21H2. I downloaded AppFlowy_0.1.2_windows-x86_64.zip from https://github.com/AppFlowy-IO/appflowy/releases. After I extracted it and clicked on AppFlowy.exe, a white screen appeared without any buttons. This state persisted for about 30 seconds, and then the application suddenly disappeared. In other words, I cannot use this program normally. I am very sad about this.

Operating System

Windows 10 LTSC Version 21H2

AppFlowy Version(s)

AppFlowy_0.1.2

Screenshots

error

nothing,and 30s later, the app shade down

Additional Context

"Is there any missing runtime dependency and how to address it?"

Originally created by @taylormao on GitHub (Mar 31, 2023). Original GitHub issue: https://github.com/AppFlowy-IO/AppFlowy/issues/2152 Originally assigned to: @appflowy on GitHub. ### Bug Description I am using the operating system Windows 10 LTSC Version 21H2. I downloaded AppFlowy_0.1.2_windows-x86_64.zip from https://github.com/AppFlowy-IO/appflowy/releases. After I extracted it and clicked on AppFlowy.exe, a white screen appeared without any buttons. This state persisted for about 30 seconds, and then the application suddenly disappeared. In other words, I cannot use this program normally. I am very sad about this. ### How to Reproduce ddownload and unzip ,and click the appflowy.exe ### Expected Behavior I am using the operating system Windows 10 LTSC Version 21H2. I downloaded AppFlowy_0.1.2_windows-x86_64.zip from https://github.com/AppFlowy-IO/appflowy/releases. After I extracted it and clicked on AppFlowy.exe, a white screen appeared without any buttons. This state persisted for about 30 seconds, and then the application suddenly disappeared. In other words, I cannot use this program normally. I am very sad about this. ### Operating System Windows 10 LTSC Version 21H2 ### AppFlowy Version(s) AppFlowy_0.1.2 ### Screenshots ![error](https://f002.backblazeb2.com/file/images-taylor-pc/ShareX/2023/03/AppFlowy_jLNTRQQnbq.png) nothing,and 30s later, the app shade down ### Additional Context "Is there any missing runtime dependency and how to address it?"
mirror 2026-03-23 20:42:15 +00:00
  • closed this issue
  • added the
    bug
    label
Author
Owner

@LucasXu0 commented on GitHub (Mar 31, 2023):

@a-wallen Can you help to check this issue?

<!-- gh-comment-id:1491322844 --> @LucasXu0 commented on GitHub (Mar 31, 2023): @a-wallen Can you help to check this issue?
Author
Owner

@taylormao commented on GitHub (Mar 31, 2023):

@a-wallen Can you help to check this issue?

thank you

<!-- gh-comment-id:1491632581 --> @taylormao commented on GitHub (Mar 31, 2023): > @a-wallen Can you help to check this issue? thank you
Author
Owner

@a-wallen commented on GitHub (Apr 2, 2023):

I'm unable to reproduce this on Windows 11 and on Windows 10 (22H2). @taylormao are you able to update your computer and try again or, send us additional information from Start > Settings > System > About.

<!-- gh-comment-id:1493189549 --> @a-wallen commented on GitHub (Apr 2, 2023): I'm unable to reproduce this on Windows 11 and on Windows 10 (22H2). @taylormao are you able to update your computer and try again or, send us additional information from Start > Settings > System > About.
Author
Owner

@taylormao commented on GitHub (Apr 2, 2023):

I'm unable to reproduce this on Windows 11 and on Windows 10 (22H2). @taylormao are you able to update your computer and try again or, send us additional information from Start > Settings > System > About.


I have shared the error file that occurred during runtime in another issue.

#2163 This issue contains more detailed runtime errors.

Here is a screenshot of my operating system information.

I am a user in China and I am very much looking forward to the recognition of your products here in China.

thank you a-wallen @a-wallen

<!-- gh-comment-id:1493195504 --> @taylormao commented on GitHub (Apr 2, 2023): > I'm unable to reproduce this on Windows 11 and on Windows 10 (22H2). @taylormao are you able to update your computer and try again or, send us additional information from Start > Settings > System > About. --- I have shared the error file that occurred during runtime in another issue. #2163 This issue contains more detailed runtime errors. Here is a screenshot of my operating system information. ![](https://f002.backblazeb2.com/file/images-taylor-pc/ShareX/2023/04/ApplicationFrameHost_CFyRDbitjJ.png) I am a user in China and I am very much looking forward to the recognition of your products here in China. thank you [a-wallen](https://github.com/a-wallen) @a-wallen
Author
Owner

@taylormao commented on GitHub (Apr 2, 2023):

@a-wallen ,I traced the error message. The content is as follows.

AppFlowy.exe thread '<unnamed>' panicked at 'called Result::unwrap() on an Err value: Error(R2D2(Error(Some("Some kind of disk I/O error occurred"))), State { next_error: None, backtrace: InternalBacktrace { backtrace: None } })', flowy-sqlite\src\kv\kv.rs:91:42
note: run with RUST_BACKTRACE=1 environment variable to display a backtrace
<!-- gh-comment-id:1493198376 --> @taylormao commented on GitHub (Apr 2, 2023): @a-wallen ,I traced the error message. The content is as follows. ```shell AppFlowy.exe thread '<unnamed>' panicked at 'called Result::unwrap() on an Err value: Error(R2D2(Error(Some("Some kind of disk I/O error occurred"))), State { next_error: None, backtrace: InternalBacktrace { backtrace: None } })', flowy-sqlite\src\kv\kv.rs:91:42 note: run with RUST_BACKTRACE=1 environment variable to display a backtrace ```
Author
Owner

@a-wallen commented on GitHub (Apr 4, 2023):

Although I'm unable to reproduce it, it looks like the root of the error is a SQLITE_IOERR from libsqlite3 (see errors.rs). It arises due to how our journal_mode is set. The default configuration sets journal_mode to WAL. Others have run into similar problems on Windows 10 with the same journal_mode setting. It looks like it was fixed by changing the journal mode to DELETE on Windows 10 only.

If the following line fails, github.com/AppFlowy-IO/AppFlowy@cf93e92e64/frontend/rust-lib/flowy-sqlite/src/kv/kv.rs (L91), maybe we should try again with a different journal_mode setting. In this case, the constructor for ConnectionPool must be modified to accept a DatabaseCustomizerConfig github.com/AppFlowy-IO/AppFlowy@cf93e92e64/frontend/rust-lib/flowy-sqlite/src/sqlite/pool.rs (L25-L46).

Nonetheless, I don't have a computer to install Windows 10 LTSC, so I will remove my assignment to this issue as I cannot reproduce it with Windows 10 22H2 and Windows 11.

<!-- gh-comment-id:1495168588 --> @a-wallen commented on GitHub (Apr 4, 2023): Although I'm unable to reproduce it, it looks like the root of the error is a SQLITE_IOERR from libsqlite3 (see [errors.rs](https://docs.rs/libsqlite3-sys/0.9.0/src/libsqlite3_sys/error.rs.html#172)). It arises due to how our `journal_mode` is set. The [default configuration sets `journal_mode` to WAL](https://github.com/AppFlowy-IO/AppFlowy/blob/cf93e92e64ed4b4320d4dbcab4af5f8c5c3f8e53/frontend/rust-lib/flowy-sqlite/src/sqlite/pool.rs#L119-L128). Others have run into [similar problems](https://github.com/askmike/gekko/issues/1375#issuecomment-347717835) on Windows 10 with the same `journal_mode` setting. It looks like it was fixed by changing the journal mode to DELETE on Windows 10 only. If the following line fails, https://github.com/AppFlowy-IO/AppFlowy/blob/cf93e92e64ed4b4320d4dbcab4af5f8c5c3f8e53/frontend/rust-lib/flowy-sqlite/src/kv/kv.rs#L91, maybe we should try again with a different `journal_mode` setting. In this case, the constructor for `ConnectionPool` must be modified to accept a `DatabaseCustomizerConfig` https://github.com/AppFlowy-IO/AppFlowy/blob/cf93e92e64ed4b4320d4dbcab4af5f8c5c3f8e53/frontend/rust-lib/flowy-sqlite/src/sqlite/pool.rs#L25-L46. Nonetheless, I don't have a computer to install Windows 10 LTSC, so I will remove my assignment to this issue as I cannot reproduce it with Windows 10 22H2 and Windows 11.
Author
Owner

@taylormao commented on GitHub (Apr 4, 2023):

What kind of modification should I make to make AppFlowy run normally?

Alex Wallen @.***> 于2023年4月4日周二 08:25写道:

I don't have a computer where I'd like to install Windows 10 LTSC, so I
will remove my assignment to this issue as I cannot reproduce with Windows
10 22H2 and Windows 11.

Although I'm unable to reproduce it, it looks like the error is a
SQLITE_IOERR from libsqlite3 (see errors.rs
https://docs.rs/libsqlite3-sys/0.9.0/src/libsqlite3_sys/error.rs.html#172)
and has to do with the way that we set our journal_mode. It looks like
the default configuration is set to WAL
https://github.com/AppFlowy-IO/AppFlowy/blob/cf93e92e64ed4b4320d4dbcab4af5f8c5c3f8e53/frontend/rust-lib/flowy-sqlite/src/sqlite/pool.rs#L119-L128.
Others have run into similar problems
https://github.com/askmike/gekko/issues/1375#issuecomment-347717835 on
Windows 10 with the same journal_mode settings and looks like it was
fixed by changing the journal mode.

Nonetheless, I cannot reproduce the issue, so I can't confirm if those
changes are adequate.


Reply to this email directly, view it on GitHub
https://github.com/AppFlowy-IO/AppFlowy/issues/2152#issuecomment-1495168588,
or unsubscribe
https://github.com/notifications/unsubscribe-auth/AMD5JMEWQQ7GDHGQVBXA76TW7NS7JANCNFSM6AAAAAAWN7XH4M
.
You are receiving this because you were mentioned.Message ID:
@.***>

<!-- gh-comment-id:1495196430 --> @taylormao commented on GitHub (Apr 4, 2023): What kind of modification should I make to make AppFlowy run normally? Alex Wallen ***@***.***> 于2023年4月4日周二 08:25写道: > I don't have a computer where I'd like to install Windows 10 LTSC, so I > will remove my assignment to this issue as I cannot reproduce with Windows > 10 22H2 and Windows 11. > > Although I'm unable to reproduce it, it looks like the error is a > SQLITE_IOERR from libsqlite3 (see errors.rs > <https://docs.rs/libsqlite3-sys/0.9.0/src/libsqlite3_sys/error.rs.html#172>) > and has to do with the way that we set our journal_mode. It looks like > the default configuration is set to WAL > <https://github.com/AppFlowy-IO/AppFlowy/blob/cf93e92e64ed4b4320d4dbcab4af5f8c5c3f8e53/frontend/rust-lib/flowy-sqlite/src/sqlite/pool.rs#L119-L128>. > Others have run into similar problems > <https://github.com/askmike/gekko/issues/1375#issuecomment-347717835> on > Windows 10 with the same journal_mode settings and looks like it was > fixed by changing the journal mode. > > Nonetheless, I cannot reproduce the issue, so I can't confirm if those > changes are adequate. > > — > Reply to this email directly, view it on GitHub > <https://github.com/AppFlowy-IO/AppFlowy/issues/2152#issuecomment-1495168588>, > or unsubscribe > <https://github.com/notifications/unsubscribe-auth/AMD5JMEWQQ7GDHGQVBXA76TW7NS7JANCNFSM6AAAAAAWN7XH4M> > . > You are receiving this because you were mentioned.Message ID: > ***@***.***> >
Author
Owner

@taylormao commented on GitHub (Apr 4, 2023):

Can this error be fixed in the next release version? I am not an open source contributor, but a user from China. I hope this error can be fixed in the subsequent versions. Thank you very much for your clarification.

<!-- gh-comment-id:1495201482 --> @taylormao commented on GitHub (Apr 4, 2023): Can this error be fixed in the next release version? I am not an open source contributor, but a user from China. I hope this error can be fixed in the subsequent versions. Thank you very much for your clarification.
Author
Owner

@a-wallen commented on GitHub (Apr 4, 2023):

I'd love to fix this, but I can't, given my lack of resources. I'll reach out on Discord to find a contributor that might be running Windows 10 LTSC. Unfortunately, I don't think you can use AppFlowy unless someone contributes a fix or if you update your operating system.

<!-- gh-comment-id:1495227449 --> @a-wallen commented on GitHub (Apr 4, 2023): I'd love to fix this, but I can't, given my lack of resources. I'll reach out on Discord to find a contributor that might be running Windows 10 LTSC. Unfortunately, I don't think you can use AppFlowy unless someone contributes a fix or if you update your operating system.
Author
Owner

@annieappflowy commented on GitHub (Jun 12, 2023):

Please try the latest release and reopen if you still run into the issue.

<!-- gh-comment-id:1587257793 --> @annieappflowy commented on GitHub (Jun 12, 2023): Please try the latest [release](https://github.com/AppFlowy-IO/AppFlowy/releases) and reopen if you still run into the issue.
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
AppFlowy-IO/AppFlowy#870
No description provided.