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.

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

Failled to insert #592

Closed
erdnaxeli opened this issue Feb 1, 2023 · 0 comments
Closed

Failled to insert #592

erdnaxeli opened this issue Feb 1, 2023 · 0 comments
Labels
bug Something isn't working

Comments

@erdnaxeli
Copy link

Hi,

I have some issue with SQL requests. I am using an SQLite database and the latest version of the docker image (up to date). Here are the errors:

[Feb  1, 2023 09:31:30] [WARN] Using SQLite without _txlock=immediate is not recommended (e.g. `uri: file:mautrix-whatsapp.db?_txlock=immediate`)
[Feb  1, 2023 09:32:12] [Database/Portal/WARN] Failed to insert [email protected]: no such table: main.old_user
[Feb  1, 2023 09:32:18] [Database/Portal/WARN] Failed to insert [email protected]: no such table: main.old_user
[Feb  1, 2023 09:32:34] [Database/Backfill/WARN] Failed to insert IMMEDIATE/[email protected] with priority 0: <nil>
[Feb  1, 2023 09:32:34] [Database/Backfill/WARN] Failed to insert DEFERRED/[email protected] with priority 0: <nil>
[Feb  1, 2023 09:32:34] [Database/Backfill/WARN] Failed to insert DEFERRED/[email protected] with priority 1: <nil>
[Feb  1, 2023 09:32:34] [Database/Backfill/WARN] Failed to insert DEFERRED/[email protected] with priority 2: <nil>
[Feb  1, 2023 09:32:34] [Database/Backfill/WARN] Failed to insert DEFERRED/[email protected] with priority 3: <nil>
[Feb  1, 2023 09:32:34] [Database/Message/WARN] Failed to insert [email protected]@07277798A6667EBEBDAFE8E9766FEF33: FOREIGN KEY constraint failed
[Feb  1, 2023 09:32:39] [Database/Message/WARN] Failed to insert [email protected]@9AEBAD46E8E71496A4F6FC41B1B0EE0F: FOREIGN KEY constraint failed

It works perfectly for almost all of my rooms, but the last two created can't be saved in the database due to those errors. It means that reactions do not work and that rebooting the bridge loose the information of the room and so it is created again when receiving a message.

@erdnaxeli erdnaxeli added the bug Something isn't working label Feb 1, 2023
@tulir tulir closed this as completed Sep 24, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Development

No branches or pull requests

2 participants