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

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

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 120363047823811053@g.us: no such table: main.old_user
[Feb  1, 2023 09:32:18] [Database/Portal/WARN] Failed to insert 120363027845409959@g.us: no such table: main.old_user
[Feb  1, 2023 09:32:34] [Database/Backfill/WARN] Failed to insert IMMEDIATE/120363027845409959@g.us with priority 0: <nil>
[Feb  1, 2023 09:32:34] [Database/Backfill/WARN] Failed to insert DEFERRED/120363027845409959@g.us with priority 0: <nil>
[Feb  1, 2023 09:32:34] [Database/Backfill/WARN] Failed to insert DEFERRED/120363027845409959@g.us with priority 1: <nil>
[Feb  1, 2023 09:32:34] [Database/Backfill/WARN] Failed to insert DEFERRED/120363027845409959@g.us with priority 2: <nil>
[Feb  1, 2023 09:32:34] [Database/Backfill/WARN] Failed to insert DEFERRED/120363027845409959@g.us with priority 3: <nil>
[Feb  1, 2023 09:32:34] [Database/Message/WARN] Failed to insert 120363027845409959@g.us@07277798A6667EBEBDAFE8E9766FEF33: FOREIGN KEY constraint failed
[Feb  1, 2023 09:32:39] [Database/Message/WARN] Failed to insert 120363027845409959@g.us@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
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

1 participant