Vikunja freezes

nesges · 11 April 2024 21:42

With the current unstable v0.23.0+491-61ee0bd5e2 Vikunja freezes from time to time, when I click on a project. It seems to only occur after a not very long time (minutes) of inactivity, but I’m still trying to figure that out. The logs show nothing peculiar (see below) and the browser tab doesn’t come back.

I recently imported a small number of tasks (~ 200) with comments from Trello and have no other activity on the vikunja installation so far

Occurs in Chrome and Firefox (others not tested yet)

tail -f database.log & tail -f events.log & tail -f http.log & tail -f mail.log & tail -f standard.log

2024-04-11T23:37:13.10978708+02:00: INFO        ▶ [DATABASE] 186d [SQL] SELECT `id`, `notifiable_id`, `notification`, `name`, `subject_id`, `read_at`, `created` FROM `notifications` WHERE (notifiable_id = ?) ORDER BY id DESC LIMIT 50 [2] - 3.280939ms
2024-04-11T23:37:13.111109078+02:00: INFO       ▶ [DATABASE] 186e [SQL] SELECT count(*) FROM `notifications` WHERE (notifiable_id = ?) [2] - 786.304µs
2024-04-11T23:37:13.111441187+02:00: WEB        ▶ 127.0.0.1  GET 200 /api/v1/notifications?page=1 6.117187ms - Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Mobile Safari/537.36
2024-04-11T23:38:00.009340435+02:00: DEBUG      ▶ models/getTasksWithRemindersDueAndTheirUsers 186f [Task Reminder Cron] Looking for reminders between 2024-04-11 23:38:00 +0200 CEST and 2024-04-11 23:39:00 +0200 CEST to send...
2024-04-11T23:38:00.013783069+02:00: INFO       ▶ [DATABASE] 1870 [SQL] SELECT * FROM `task_reminders` INNER JOIN `tasks` ON tasks.id = task_reminders.task_id WHERE (reminder >= ? and reminder < ?) AND (tasks.done = false) [2024-04-11 11:38:00 2024-04-12 13:39:00] - 4.039324ms
2024-04-11T23:38:00.014125735+02:00: DEBUG      ▶ models/getTasksWithRemindersDueAndTheirUsers 1871 [Task Reminder Cron] Found 0 reminders
2024-04-11T23:38:00.014282812+02:00: INFO       ▶ [DATABASE] 1872 [SQL] SELECT * FROM `tasks` LEFT JOIN `projects` ON projects.id = tasks.project_id WHERE (due_date is not null AND due_date < ? AND projects.is_archived = false) AND (done = false) [2024-04-12 13:39:00] - 4.808867ms
2024-04-11T23:38:00.016071577+02:00: INFO       ▶ [DATABASE] 1873 [SQL] SELECT `id`, `name`, `description`, `created_by_id`, `oidc_id`, `issuer`, `created`, `updated`, `is_public` FROM `teams` WHERE id NOT IN (select team_members.team_id from team_members) AND (oidc_id<>? OR oidc_id IS NOT NULL) [] - 6.410024ms
2024-04-11T23:38:00.01622048+02:00: DEBUG       ▶ openid/RemoveEmptySSOTeams 1874 Deleting empty teams: []
2024-04-11T23:38:00.016544756+02:00: INFO       ▶ [DATABASE] 1875 [SQL] DELETE FROM `teams` WHERE 0=1 [] - 190.698µs
2024-04-11T23:38:00.017592518+02:00: INFO       ▶ [DATABASE] 1876 [SQL] SELECT users.* FROM `users` LEFT JOIN `tasks` ON tasks.created_by_id = users.id WHERE `tasks`.`id` IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND users.overdue_tasks_reminders_enabled=? GROUP BY tasks.id, users.id, users.username, users.email, users.name, users.timezone [666 689 705 706 709 711 712 746 787 788 790 791 797 798 804 831 true] - 1.593557ms
2024-04-11T23:38:00.018393846+02:00: INFO       ▶ [DATABASE] 1877 [SQL] SELECT `id`, `title`, `description`, `done`, `done_at`, `due_date`, `project_id`, `repeat_after`, `repeat_mode`, `priority`, `start_date`, `end_date`, `hex_color`, `percent_done`, `index`, `uid`, `cover_image_attachment_id`, `created`, `updated`, `created_by_id` FROM `tasks` WHERE `id` IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) [666 689 705 706 709 711 712 746 787 788 790 791 797 798 804 831] - 517.224µs
2024-04-11T23:38:00.019728288+02:00: INFO       ▶ [DATABASE] 1878 [SQL] SELECT task_id, users.* FROM `task_assignees` INNER JOIN `users` ON task_assignees.user_id = users.id WHERE `task_id` IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND users.overdue_tasks_reminders_enabled=? [666 689 705 706 709 711 712 746 787 788 790 791 797 798 804 831 true] - 529.773µs
2024-04-11T23:38:00.019880725+02:00: DEBUG      ▶ models/func1 1879 [Undone Overdue Tasks Reminder] Sending reminders to 0 users
2024-04-11T23:38:00.020313269+02:00: INFO       ▶ [DATABASE] 187a [SQL] SELECT projects.* FROM `projects` INNER JOIN `tasks` ON projects.id = tasks.project_id WHERE 0=1 [] - 307.614µs
2024-04-11T23:39:00.021478862+02:00: DEBUG      ▶ models/getTasksWithRemindersDueAndTheirUsers 187b [Task Reminder Cron] Looking for reminders between 2024-04-11 23:39:00 +0200 CEST and 2024-04-11 23:40:00 +0200 CEST to send...
2024-04-11T23:39:00.026215141+02:00: INFO       ▶ [DATABASE] 187c [SQL] SELECT * FROM `task_reminders` INNER JOIN `tasks` ON tasks.id = task_reminders.task_id WHERE (reminder >= ? and reminder < ?) AND (tasks.done = false) [2024-04-11 11:39:00 2024-04-12 13:40:00] - 4.270428ms
2024-04-11T23:39:00.026782892+02:00: INFO       ▶ [DATABASE] 187e [SQL] SELECT `id`, `name`, `description`, `created_by_id`, `oidc_id`, `issuer`, `created`, `updated`, `is_public` FROM `teams` WHERE id NOT IN (select team_members.team_id from team_members) AND (oidc_id<>? OR oidc_id IS NOT NULL) [] - 4.729108ms
2024-04-11T23:39:00.026665577+02:00: DEBUG      ▶ models/getTasksWithRemindersDueAndTheirUsers 187d [Task Reminder Cron] Found 0 reminders
2024-04-11T23:39:00.026811498+02:00: INFO       ▶ [DATABASE] 187f [SQL] SELECT * FROM `tasks` LEFT JOIN `projects` ON projects.id = tasks.project_id WHERE (due_date is not null AND due_date < ? AND projects.is_archived = false) AND (done = false) [2024-04-12 13:40:00] - 5.008055ms
2024-04-11T23:39:00.027044134+02:00: DEBUG      ▶ openid/RemoveEmptySSOTeams 1880 Deleting empty teams: []
2024-04-11T23:39:00.027774125+02:00: INFO       ▶ [DATABASE] 1881 [SQL] DELETE FROM `teams` WHERE 0=1 [] - 437.43µs
2024-04-11T23:39:00.031945384+02:00: INFO       ▶ [DATABASE] 1882 [SQL] SELECT users.* FROM `users` LEFT JOIN `tasks` ON tasks.created_by_id = users.id WHERE `tasks`.`id` IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND users.overdue_tasks_reminders_enabled=? GROUP BY tasks.id, users.id, users.username, users.email, users.name, users.timezone [666 689 705 706 709 711 712 746 787 788 790 791 797 798 804 831 true] - 2.68231ms
2024-04-11T23:39:00.033764712+02:00: INFO       ▶ [DATABASE] 1883 [SQL] SELECT `id`, `title`, `description`, `done`, `done_at`, `due_date`, `project_id`, `repeat_after`, `repeat_mode`, `priority`, `start_date`, `end_date`, `hex_color`, `percent_done`, `index`, `uid`, `cover_image_attachment_id`, `created`, `updated`, `created_by_id` FROM `tasks` WHERE `id` IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) [666 689 705 706 709 711 712 746 787 788 790 791 797 798 804 831] - 1.227159ms
2024-04-11T23:39:00.035731845+02:00: INFO       ▶ [DATABASE] 1884 [SQL] SELECT task_id, users.* FROM `task_assignees` INNER JOIN `users` ON task_assignees.user_id = users.id WHERE `task_id` IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND users.overdue_tasks_reminders_enabled=? [666 689 705 706 709 711 712 746 787 788 790 791 797 798 804 831 true] - 887.918µs
2024-04-11T23:39:00.035905559+02:00: DEBUG      ▶ models/func1 1885 [Undone Overdue Tasks Reminder] Sending reminders to 0 users
2024-04-11T23:39:00.036416825+02:00: INFO       ▶ [DATABASE] 1886 [SQL] SELECT projects.* FROM `projects` INNER JOIN `tasks` ON projects.id = tasks.project_id WHERE 0=1 [] - 384.472µs

kolaente · 12 April 2024 13:21

Maybe similar to this? Frontend hangs when opening a task (process crash/eternal loop) · Issue #233 · go-vikunja/vikunja · GitHub

nesges · 12 April 2024 13:44

It’s very similar to the described problem, but I think I can rule out parent/child problems, since my user has access to all projects.

But: I just reverted back to some older versions and with unstable v0.23.0+413-ecd002dca3 (March 21) I wasn’t able to reproduce the error. v0.23.0+478-af3b0bbea1 (April 8) ist the oldest binary in my store that showed the freezing

kolaente · 12 April 2024 21:15

I’ve pushed a potential fix for this in 0bc9a670d7. Can you check with the latest unstable build if the problem still exists?

nesges · 12 April 2024 23:06

v0.23.0+497-73bf119409 freezes as soon as I visit a project via it’s tile under “Projekte” (upper part of the sidebar). It doesn’t freeze, when I visit a project via it’s link in the lower part of the sidebar

kolaente · 13 April 2024 11:06

Looks similar to #2246 - TypeError when opening specific projects - vikunja - Gitea

kolaente · 13 April 2024 11:20

This should now be fixed in 9eb19e0362. Please check with the next unstable build (ready in ~45min, also on try) if the problem went away.

nesges · 14 April 2024 22:45

Thar seems to have fixed it. Thank you!