Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

backing store failure (SQLITE_CANTOPEN) #691

Open
TheArcaneBrony opened this issue Jan 19, 2025 · 5 comments
Open

backing store failure (SQLITE_CANTOPEN) #691

TheArcaneBrony opened this issue Jan 19, 2025 · 5 comments
Labels
2.0.0 Follow Up Issue discoverd in after the release of Draupnir 2.0.0 bug Something isn't working L2 Few Likelihood P2 Aggravating Priority level T3 Workflow Issue User employs strategies to achieve the task that harm the experience (use minor first).

Comments

@TheArcaneBrony
Copy link
Contributor 

Sat, 18 Jan 2025 22:12:05 GMT [ERROR] [EventBatch] Caught an exception from the callback for an event batch SqliteError: unable to open database file
    at /usr/share/draupnir/lib/backingstore/better-sqlite3/SqliteRoomStateBackingStore.js:54:34
    at sqliteTransaction (/usr/share/draupnir/node_modules/better-sqlite3/lib/methods/transaction.js:65:24)
    at /usr/share/draupnir/lib/backingstore/better-sqlite3/SqliteRoomStateBackingStore.js:63:13
    at sqliteTransaction (/usr/share/draupnir/node_modules/better-sqlite3/lib/methods/transaction.js:65:24)
    at SqliteRoomStateBackingStore.handleRevision (/usr/share/draupnir/lib/backingstore/better-sqlite3/SqliteRoomStateBackingStore.js:68:13)
    at StandardRoomStateRevisionIssuer.emit (node:events:536:35)
    at StandardRoomStateRevisionIssuer.emit (node:domain:489:12)
    at StandardRoomStateRevisionIssuer.createRevisionFromChanges (/usr/share/draupnir/node_modules/matrix-protection-suite/dist/StateTracking/StandardRoomStateRevisionIssuer.js:67:14)
    at StandardRoomStateRevisionIssuer.createBatchedRevision (/usr/share/draupnir/node_modules/matrix-protection-suite/dist/StateTracking/StandardRoomStateRevisionIssuer.js:76:14)
    at process.processTicksAndRejections (node:internal/process/task_queues:105:5) {
  code: 'SQLITE_CANTOPEN'
}

Issue goes away after properly restarting draupnir.
@Gnuxie Gnuxie added bug Something isn't working L2 Few Likelihood P2 Aggravating Priority level T3 Workflow Issue User employs strategies to achieve the task that harm the experience (use minor first). 2.0.0 Follow Up Issue discoverd in after the release of Draupnir 2.0.0 labels Jan 19, 2025
@Gnuxie
Copy link
Member

Gnuxie commented Jan 19, 2025

Related to #687

@Gnuxie Gnuxie mentioned this issue Jan 31, 2025
Closed
@Gnuxie
Copy link
Member

Gnuxie commented Jan 31, 2025

Hmm struggling to reproduce this one by using restart/safe mode commands @TheArcaneBrony , can you think of anything that could be causing it? Did this happen while Draupnir was in safe mode? When in the process did this happen?

@TheArcaneBrony
Copy link
Contributor Author

this happened after normal mode -> safe mode (ie. !draupnir safemode)

@Gnuxie
Copy link
Member

Gnuxie commented Feb 2, 2025

Was this propagating to the top level and causing a crash or was it just something you noticed in the logs?

Gnuxie added a commit that referenced this issue Feb 2, 2025
@Gnuxie
Fix lack of error handling in parts of backing store.
8e22074 
Errors propagating here could cause the bot to have only partially
synced by propagating all the way up to the sync response handling in
the bot-sdk.

#691.
@Gnuxie Gnuxie mentioned this issue Feb 2, 2025
Merged
Gnuxie added a commit that referenced this issue Feb 3, 2025
@Gnuxie
Fix lack of error handling in parts of backing store. (#717)
a497821 
Errors propagating here could cause the bot to have only partially
synced by propagating all the way up to the sync response handling in
the bot-sdk.

#691.
@Gnuxie
Copy link
Member

Gnuxie commented Feb 3, 2025

Developer Context: The errors aren't caused by safe mode because the store is only initialised withinindex.ts.

@Gnuxie Gnuxie changed the title Manual safe mode -> restart causes backing store failure (SQLITE_CANTOPEN) backing store failure (SQLITE_CANTOPEN) Feb 3, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
2.0.0 Follow Up Issue discoverd in after the release of Draupnir 2.0.0 bug Something isn't working L2 Few Likelihood P2 Aggravating Priority level T3 Workflow Issue User employs strategies to achieve the task that harm the experience (use minor first).
Projects
Draupnir planning
Status: No status
Milestone
No milestone
Development

No branches or pull requests
2 participants
@TheArcaneBrony @Gnuxie