0db273f383
ssb: Do the datbase migrations in immediate transactions. Trying to elimate potential problems from temporarily incompatible databases in multi-process cases.
One other thought crossed my mind - some of the symptoms you gave sound like multiple tildefriends processes fighting over the database. That's generally OK, but there are caveats. I'm wondering…
Another possibly interesting thing to compare:
$ make out/release/sqlite3 && out/release/sqlite3 ~/.local/share/tildefriends/db.sqlite .schema
Building Tilde Friends 0.2026.1-wip…
🤔 That is very puzzling, and I'd love to get to the bottom of all of this before the next release.
Do you have callstacks for the crashes? It tries to print them in the signal handler as it's…
4bcaacb7a0
editor: A fix for removing the last file, as spotted in https://media.tildefriends.net/w/fbf3uHUEbR85r7y5fUE9zH.
The next thing I do when I've encountered this in the past is run slow queries with explain query plan. Here's an approximation of the query that's timing out for you with the placeholders…
Oh, yes, that timeout would be the main query that gets messages for the general tab.
Spitballing:
- If you restart the process, it will re-analyze tables and might find a better strategy. If…
Hmmmm. Anything in the browser console? ctrl+shift+i or such.
That 💻CPU indicator looks pretty busy. Oh, and actually that output is probably from searching for private messages, which is…