[BUG] Deleting a Task created through the relation-manager crashes the entire list #1810

Closed
opened 2021-07-14 10:56:55 +00:00 by Gensokian · 6 comments

Basically creating a new Item through Relations (Be it accidental or on purpose) and deleting that, creates a 500 Error and the list is no longer viewable.

Steps to reproduce;

  1. Create a TESTING list
    image

  2. Open ANY task
    image

  3. Press "Add a relationship"
    image

  4. Add some Task as a new task (Important, must be a NEW task indicated with "Add this task as new related task"
    image

  5. Go to the newly created task
    image

  6. Delete the Task
    image

  7. Aaaaand all the tasks are gone! (They are still in the database, but the lookup just.. fails.)
    image

Heres the database entry
image

Basically creating a new Item through Relations (Be it accidental or on purpose) and deleting that, creates a 500 Error and the list is no longer viewable. Steps to reproduce; 1. Create a TESTING list ![image](/attachments/75bd89f6-a91a-4543-8212-ec4b38ef329c) 2. Open ANY task ![image](/attachments/37048d73-430b-4923-8c7e-72e8e3fe8061) 3. Press "Add a relationship" ![image](/attachments/d54de6ad-ac67-45b0-ad3f-8398d8003094) 4. Add some Task as a new task (Important, must be a NEW task indicated with "Add this task as new related task" ![image](/attachments/4aac89a5-ec96-4dd6-ab1c-5d5c2c6c22d0) 5. Go to the newly created task ![image](/attachments/2dc703be-13d1-4513-a7ab-1ee1c26757a4) 6. Delete the Task ![image](/attachments/4fde6401-7f1e-4734-9c2c-435122a0834c) 7. Aaaaand all the tasks are gone! (They are still in the database, but the lookup just.. fails.) ![image](/attachments/cb3fa48f-4c87-4405-8991-cda0a29b8a35) Heres the database entry ![image](/attachments/e7d9b293-2cfe-44e7-b9eb-388993dacb0e)
Owner

Is that reproducable with the latest version on try?

I saw a bug something like that a few days ago and put in a fix, but I wasn't really able to reproduce it.

Anything in the logs?

Is that reproducable with the latest version on [try](https://try.vikunja.io)? I saw a bug something like that a few days ago and put in a fix, but I wasn't really able to reproduce it. Anything in the logs?
konrad added the
kind/bug
label 2021-07-14 10:59:31 +00:00
Author

Update, I was able to fix the issue, by creating a "Filler task" and manually assigning it the ID of the "broken" task. thus replacing that task. It also inherits the relations since those seem to be in a different table. I was able to delete those normally

Update, I was able to fix the issue, by creating a "Filler task" and manually assigning it the ID of the "broken" task. thus replacing that task. It also inherits the relations since those seem to be in a different table. I was able to delete those normally
Author

Just saw your entry, yes; it is reproducable. I think I am running the latest version but i'll check soon.

Interesting, on the "Try" page it doesn't crash it

Just saw your entry, yes; it is reproducable. I think I am running the latest version but i'll check soon. Interesting, on the "Try" page it doesn't crash it
Author

I am running this on a docker enviroment, using this docker-compose file:

version: '3'

services:
  db:
    image: mariadb:10
    ports:
      - 3306:3306
    command: --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci
    environment:
      MYSQL_ROOT_PASSWORD: supersecret
      MYSQL_USER: vikunja
      MYSQL_PASSWORD: secret
      MYSQL_DATABASE: vikunja
    volumes:
      - /volume3/docker/docker_vikunja/db:/var/lib/mysql
    restart: unless-stopped
  api:
    image: vikunja/api:latest
    environment:
      VIKUNJA_SERVICE_TIMEZONE: CET
      VIKUNJA_MAILER_FROMEMAIL: ---------
      VIKUNJA_MAILER_PASSWORD: ---------
      VIKUNJA_MAILER_USERNAME: ---------
      VIKUNJA_MAILER_HOST: smtp.gmail.com
      VIKUNJA_MAILER_ENABLED: "true"
 #     VIKUNJA_SERVICE_ENABLEREGISTRATION: "false"
      VIKUNJA_BACKGROUNDS_PROVIDERS_UNSPLASH_APPLICATIONID: ----------
      VIKUNJA_BACKGROUNDS_PROVIDERS_UNSPLASH_ACCESSTOKEN: '-------------'
      VIKUNJA_BACKGROUNDS_PROVIDERS_UNSPLASH_ENABLED: "true"
      VIKUNJA_BACKGROUNDS_PROVIDERS_UPLOAD_ENABLED: "false"
      VIKUNJA_SERVICE_FRONTENDURL: '---------'
      VIKUNJA_DATABASE_HOST: db
      VIKUNJA_DATABASE_PASSWORD: ---------
      VIKUNJA_DATABASE_TYPE: mysql
      VIKUNJA_DATABASE_USER: ---------
      VIKUNJA_DATABASE_DATABASE: ---------
    volumes:
      - /volume3/docker/docker_vikunja/files:/app/vikunja/files
    depends_on:
      - db
    restart: unless-stopped
  frontend:
    image: vikunja/frontend:latest
    restart: unless-stopped
  proxy:
    image: nginx
    ports:
      - 65432:80
    depends_on:
      - api
      - frontend
    restart: unless-stopped

FRONTEND LOG:

...

192.168.32.5 - - [14/Jul/2021:11:03:11 +0000] "GET /lists/31/list HTTP/1.0" 304 0 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36" "164.128.141.50"
192.168.32.5 - - [14/Jul/2021:11:03:11 +0000] "GET /images/icons/favicon-32x32.png HTTP/1.0" 200 1723 "https://projects.james-things.com/lists/31/list" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36" "164.128.141.50"
192.168.32.5 - - [14/Jul/2021:11:03:13 +0000] "GET /sw.js HTTP/1.0" 304 0 "https://projects.james-things.com/sw.js" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36" "164.128.141.50"
192.168.32.5 - - [14/Jul/2021:11:03:24 +0000] "GET /lists/31/list HTTP/1.0" 304 0 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36" "164.128.141.50"
192.168.32.5 - - [14/Jul/2021:11:03:25 +0000] "GET /images/icons/favicon-32x32.png HTTP/1.0" 200 1723 "https://projects.james-things.com/lists/31/list" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36" "164.128.141.50"
192.168.32.5 - - [14/Jul/2021:11:03:27 +0000] "GET /sw.js HTTP/1.0" 304 0 "https://projects.james-things.com/sw.js" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36" "164.128.141.50"
192.168.32.5 - - [14/Jul/2021:11:03:40 +0000] "GET /images/icons/favicon-32x32.png HTTP/1.0" 200 1723 "https://projects.james-things.com/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36" "164.128.141.50"
192.168.32.5 - - [14/Jul/2021:11:03:42 +0000] "GET /sw.js HTTP/1.0" 304 0 "https://projects.james-things.com/sw.js" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36" "164.128.141.50"
192.168.32.5 - - [14/Jul/2021:11:06:08 +0000] "GET /lists/29/list HTTP/1.0" 200 3935 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36" "164.128.141.50"
192.168.32.5 - - [14/Jul/2021:11:06:08 +0000] "GET /images/icons/favicon-32x32.png HTTP/1.0" 200 1723 "https://projects.james-things.com/lists/29/list" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36" "164.128.141.50"
192.168.32.5 - - [14/Jul/2021:11:06:10 +0000] "GET /sw.js HTTP/1.0" 304 0 "https://projects.james-things.com/sw.js" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36" "164.128.141.50"
192.168.32.5 - - [14/Jul/2021:11:06:25 +0000] "GET /lists/29/list HTTP/1.0" 304 0 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36" "164.128.141.50"
192.168.32.5 - - [14/Jul/2021:11:06:26 +0000] "GET /images/icons/favicon-32x32.png HTTP/1.0" 200 1723 "https://projects.james-things.com/lists/29/list" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36" "164.128.141.50"
192.168.32.5 - - [14/Jul/2021:11:06:27 +0000] "GET /sw.js HTTP/1.0" 304 0 "https://projects.james-things.com/sw.js" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36" "164.128.141.50"
192.168.32.5 - - [14/Jul/2021:11:22:25 +0000] "GET /images/icons/favicon-32x32.png HTTP/1.0" 200 1723 "https://projects.james-things.com/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.114 Safari/537.36 OPR/77.0.4054.172" "77.22.250.193"
192.168.32.5 - - [14/Jul/2021:11:22:27 +0000] "GET /sw.js HTTP/1.0" 304 0 "https://projects.james-things.com/sw.js" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.114 Safari/537.36 OPR/77.0.4054.172" "77.22.250.193"
192.168.32.5 - - [14/Jul/2021:11:22:27 +0000] "GET /images/icons/favicon-32x32.png HTTP/1.0" 200 1723 "https://projects.james-things.com/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.114 Safari/537.36 OPR/77.0.4054.172" "77.22.250.193"
192.168.32.5 - - [14/Jul/2021:11:22:29 +0000] "GET /sw.js HTTP/1.0" 304 0 "https://projects.james-things.com/sw.js" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.114 Safari/537.36 OPR/77.0.4054.172" "77.22.250.193"
192.168.32.5 - - [14/Jul/2021:11:40:46 +0000] "GET /tasks/94 HTTP/1.0" 200 3935 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36" "164.128.141.50"
192.168.32.5 - - [14/Jul/2021:11:40:46 +0000] "GET /images/icons/favicon-32x32.png HTTP/1.0" 200 1723 "https://projects.james-things.com/tasks/94" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36" "164.128.141.50"
192.168.32.5 - - [14/Jul/2021:11:40:48 +0000] "GET /sw.js HTTP/1.0" 304 0 "https://projects.james-things.com/sw.js" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36" "164.128.141.50"
192.168.32.5 - - [14/Jul/2021:11:40:48 +0000] "GET /lists/-2/null HTTP/1.0" 200 3935 "https://projects.james-things.com/lists/-2/kanban" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36" "164.128.141.50"
192.168.32.5 - - [14/Jul/2021:11:45:25 +0000] "GET /sw.js HTTP/1.0" 304 0 "https://projects.james-things.com/sw.js" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36" "164.128.141.50"
192.168.32.5 - - [14/Jul/2021:11:45:26 +0000] "GET /lists/32/null HTTP/1.0" 200 3935 "https://projects.james-things.com/lists/32/list" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36" "164.128.141.50"
192.168.32.5 - - [14/Jul/2021:11:45:27 +0000] "GET /lists/32/list HTTP/1.0" 200 3935 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36" "164.128.141.50"
192.168.32.5 - - [14/Jul/2021:11:45:27 +0000] "GET /images/icons/favicon-32x32.png HTTP/1.0" 200 1723 "https://projects.james-things.com/lists/32/list" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36" "164.128.141.50"
192.168.32.5 - - [14/Jul/2021:11:45:27 +0000] "GET /lists/32/list HTTP/1.0" 304 0 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36" "164.128.141.50"
192.168.32.5 - - [14/Jul/2021:11:45:28 +0000] "GET /images/icons/favicon-32x32.png HTTP/1.0" 200 1723 "https://projects.james-things.com/lists/32/list" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36" "164.128.141.50"
192.168.32.5 - - [14/Jul/2021:11:45:28 +0000] "GET /lists/32/list HTTP/1.0" 304 0 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36" "164.128.141.50"
192.168.32.5 - - [14/Jul/2021:11:45:28 +0000] "GET /images/icons/favicon-32x32.png HTTP/1.0" 200 1723 "https://projects.james-things.com/lists/32/list" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36" "164.128.141.50"
192.168.32.5 - - [14/Jul/2021:11:45:30 +0000] "GET /sw.js HTTP/1.0" 304 0 "https://projects.james-things.com/sw.js" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36" "164.128.141.50"

API LOG:

...

021-07-14T11:45:27.588896236Z: WEB     ▶ 164.128.141.50  GET 500 /api/v1/lists/32/tasks?sort_by[]=done&sort_by[]=id&order_by[]=asc&order_by[]=desc&filter_by[]=done&filter_value[]=false&filter_comparator[]=equals&filter_concat=and&page=1 26.919167ms - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36
2021-07-14T11:45:27.926105696Z: WEB     ▶ 164.128.141.50  GET 200 /api/v1/avatar/James?size=50 1.240527ms - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36
2021-07-14T11:45:27.97858809Z: WEB      ▶ 164.128.141.50  GET 200 /api/v1/info 269.047µs - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36
2021-07-14T11:45:27.980358526Z: WEB     ▶ 164.128.141.50  GET 200 /api/v1/user 2.039244ms - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36
2021-07-14T11:45:27.99140475Z: WEB      ▶ 164.128.141.50  GET 200 /api/v1/notifications?page=1 7.824004ms - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36
2021-07-14T11:45:27.995020555Z: WEB     ▶ 164.128.141.50  GET 200 /api/v1/lists/32 8.511616ms - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36
2021-07-14T11:45:27.99960863Z: WEB      ▶ 164.128.141.50  GET 200 /api/v1/labels?page=1 17.188957ms - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36
2021-07-14T11:45:28.007926758Z: -       ▶ echo recover.go:92 [PANIC RECOVER] runtime error: invalid memory address or nil pointer dereference goroutine 3415 [running]:
github.com/labstack/echo/v4/middleware.RecoverWithConfig.func1.1.1(0x1524e80, 0x1000, 0x0, 0x16a5098, 0xc0008e4000)
        /go/pkg/mod/github.com/labstack/echo/v4@v4.3.0/middleware/recover.go:77 +0x105
panic(0x11ead20, 0x1d08260)
        /usr/local/go/src/runtime/panic.go:965 +0x1b9
code.vikunja.io/api/pkg/models.addRelatedTasksToTasks(0xc00051b6c0, 0xc000570aa0, 0x4, 0x4, 0xc00081d078, 0x16765e0, 0xc00091c500, 0xc0006ebff6, 0x2)
        /go/src/code.vikunja.io/api/pkg/models/tasks.go:673 +0x4fb
code.vikunja.io/api/pkg/models.addMoreInfoToTasks(0xc00051b6c0, 0xc00081d078, 0x16765e0, 0xc00091c500, 0x16765e0, 0xc00091c500)
        /go/src/code.vikunja.io/api/pkg/models/tasks.go:754 +0x8a8
code.vikunja.io/api/pkg/models.getTasksForLists(0xc00051b6c0, 0xc0000c6d98, 0x1, 0x1, 0x16765e0, 0xc00091c500, 0xc00043e620, 0x0, 0x4154db, 0xc00051b6c0, ...)
        /go/src/code.vikunja.io/api/pkg/models/tasks.go:503 +0x228
code.vikunja.io/api/pkg/models.(*TaskCollection).ReadAll(0xc00091e840, 0xc00051b6c0, 0x16765e0, 0xc00091c500, 0x0, 0x0, 0x1, 0x32, 0x0, 0x0, ...)
        /go/src/code.vikunja.io/api/pkg/models/task_collection.go:199 +0x37c
code.vikunja.io/web/handler.(*WebHandler).ReadAllWeb(0xc000010cf8, 0x16a5098, 0xc0008e4000, 0x0, 0x0)
        /go/pkg/mod/code.vikunja.io/web@v0.0.0-20210706160506-d85def955bd3/handler/read_all.go:94 +0xa72
github.com/labstack/echo/v4/middleware.JWTWithConfig.func1.1(0x16a5098, 0xc0008e4000, 0x1, 0x1)
        /go/pkg/mod/github.com/labstack/echo/v4@v4.3.0/middleware/jwt.go:229 +0x456
github.com/labstack/echo/v4.(*Echo).add.func1(0x16a5098, 0xc0008e4000, 0x0, 0x0)
        /go/pkg/mod/github.com/labstack/echo/v4@v4.3.0/echo.go:536 +0x62
github.com/labstack/echo/v4/middleware.CORSWithConfig.func1.1(0x16a5098, 0xc0008e4000, 0x0, 0x203000)
        /go/pkg/mod/github.com/labstack/echo/v4@v4.3.0/middleware/cors.go:118 +0x15a5
github.com/labstack/echo/v4/middleware.RecoverWithConfig.func1.1(0x16a5098, 0xc0008e4000, 0x0, 0x0)
        /go/pkg/mod/github.com/labstack/echo/v4@v4.3.0/middleware/recover.go:98 +0x142
github.com/labstack/echo/v4/middleware.LoggerWithConfig.func2.1(0x16a5098, 0xc0008e4000, 0x0, 0x0)
        /go/pkg/mod/github.com/labstack/echo/v4@v4.3.0/middleware/logger.go:117 +0x12c
github.com/labstack/echo/v4.(*Echo).ServeHTTP(0xc0002bc600, 0x168aaf8, 0xc0014fa8c0, 0xc00091c400)
        /go/pkg/mod/github.com/labstack/echo/v4@v4.3.0/echo.go:646 +0x2bc
net/http.serverHandler.ServeHTTP(0xc0001920e0, 0x168aaf8, 0xc0014fa8c0, 0xc00091c400)
        /usr/local/go/src/net/http/server.go:2887 +0xa3
net/http.(*conn).serve(0xc000982c80, 0x168e7f8, 0xc0012a9680)
        /usr/local/go/src/net/http/server.go:1952 +0x8cd
created by net/http.(*Server).Serve
        /usr/local/go/src/net/http/server.go:3013 +0x39b

goroutine 1 [chan receive, 69 minutes]:
code.vikunja.io/api/pkg/cmd.glob..func2(0x1d18b80, 0x1dee008, 0x0, 0x0)
        /go/src/code.vikunja.io/api/pkg/cmd/web.go:102 +0x1dc
github.com/spf13/cobra.(*Command).execute(0x1d18b80, 0xc0000a01f0, 0x0, 0x0, 0x1d18b80, 0xc0000a01f0)
        /go/pkg/mod/github.com/spf13/cobra@v1.2.1/command.go:860 +0x2c2
github.com/spf13/cobra.(*Command).ExecuteC(0x1d18b80, 0xc000000180, 0x200000003, 0xc000000180)
        /go/pkg/mod/github.com/spf13/cobra@v1.2.1/command.go:974 +0x375
github.com/spf13/cobra.(*Command).Execute(...)
        /go/pkg/mod/github.com/spf13/cobra@v1.2.1/command.go:902
code.vikunja.io/api/pkg/cmd.Execute()
        /go/src/code.vikunja.io/api/pkg/cmd/cmd.go:44 +0x31
main.main()
        /go/src/code.vikunja.io/api/main.go:22 +0x25

goroutine 37 [select, 69 minutes]:
database/sql.(*DB).connectionOpener(0xc0001b92b0, 0x168e750, 0xc0003655c0)
        /usr/local/go/src/database/sql/sql.go:1133 +0xb5
created by database/sql.OpenDB
        /usr/local/go/src/database/sql/sql.go:740 +0x12a

goroutine 54 [select]:
code.vikunja.io/api/pkg/mail.StartMailDaemon.func1()
        /go/src/code.vikunja.io/api/pkg/mail/mail.go:62 +0x125
created by code.vikunja.io/api/pkg/mail.StartMailDaemon
        /go/src/code.vikunja.io/api/pkg/mail/mail.go:55 +0x167

goroutine 55 [select]:
github.com/robfig/cron/v3.(*Cron).run(0xc0004705a0)
        /go/pkg/mod/github.com/robfig/cron/v3@v3.0.1/cron.go:263 +0x509
created by github.com/robfig/c

2021-07-14T11:45:28.00800704Z: WEB      ▶ 164.128.141.50  GET 500 /api/v1/lists/32/tasks?sort_by[]=done&sort_by[]=id&order_by[]=asc&order_by[]=desc&filter_by[]=done&filter_value[]=false&filter_comparator[]=equals&filter_concat=and&page=1 23.970833ms - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36
2021-07-14T11:45:28.018335918Z: WEB     ▶ 164.128.141.50  GET 200 /api/v1/namespaces?is_archived=true&page=1 35.916515ms - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36
2021-07-14T11:45:28.508716705Z: WEB     ▶ 164.128.141.50  GET 200 /api/v1/avatar/James?size=50 1.288931ms - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36
2021-07-14T11:45:28.60392276Z: WEB      ▶ 164.128.141.50  GET 200 /api/v1/info 311.823µs - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36
2021-07-14T11:45:28.605692629Z: WEB     ▶ 164.128.141.50  GET 200 /api/v1/user 1.926803ms - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36
2021-07-14T11:45:28.617675321Z: WEB     ▶ 164.128.141.50  GET 200 /api/v1/notifications?page=1 8.836249ms - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36
2021-07-14T11:45:28.623964264Z: WEB     ▶ 164.128.141.50  GET 200 /api/v1/labels?page=1 16.467355ms - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36
2021-07-14T11:45:28.62527508Z: WEB      ▶ 164.128.141.50  GET 200 /api/v1/lists/32 15.744358ms - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36
2021-07-14T11:45:28.633191006Z: WEB     ▶ 164.128.141.50  GET 200 /api/v1/namespaces?is_archived=true&page=1 25.130786ms - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36
2021-07-14T11:45:28.635476776Z: -       ▶ echo recover.go:92 [PANIC RECOVER] runtime error: invalid memory address or nil pointer dereference goroutine 3423 [running]:
github.com/labstack/echo/v4/middleware.RecoverWithConfig.func1.1.1(0x1524e80, 0x1000, 0x0, 0x16a5098, 0xc000982e60)
        /go/pkg/mod/github.com/labstack/echo/v4@v4.3.0/middleware/recover.go:77 +0x105
panic(0x11ead20, 0x1d08260)
        /usr/local/go/src/runtime/panic.go:965 +0x1b9
code.vikunja.io/api/pkg/models.addRelatedTasksToTasks(0xc00120e680, 0xc000570f40, 0x4, 0x4, 0xc00073f078, 0x16765e0, 0xc001593f00, 0xc0006d9ea6, 0x2)
        /go/src/code.vikunja.io/api/pkg/models/tasks.go:673 +0x4fb
code.vikunja.io/api/pkg/models.addMoreInfoToTasks(0xc00120e680, 0xc00073f078, 0x16765e0, 0xc001593f00, 0x16765e0, 0xc001593f00)
        /go/src/code.vikunja.io/api/pkg/models/tasks.go:754 +0x8a8
code.vikunja.io/api/pkg/models.getTasksForLists(0xc00120e680, 0xc000296d78, 0x1, 0x1, 0x16765e0, 0xc001593f00, 0xc0003140e0, 0x0, 0x4154db, 0xc00120e680, ...)
        /go/src/code.vikunja.io/api/pkg/models/tasks.go:503 +0x228
code.vikunja.io/api/pkg/models.(*TaskCollection).ReadAll(0xc00121ec60, 0xc00120e680, 0x16765e0, 0xc001593f00, 0x0, 0x0, 0x1, 0x32, 0x0, 0x0, ...)
        /go/src/code.vikunja.io/api/pkg/models/task_collection.go:199 +0x37c
code.vikunja.io/web/handler.(*WebHandler).ReadAllWeb(0xc000010cf8, 0x16a5098, 0xc000982e60, 0x0, 0x0)
        /go/pkg/mod/code.vikunja.io/web@v0.0.0-20210706160506-d85def955bd3/handler/read_all.go:94 +0xa72
github.com/labstack/echo/v4/middleware.JWTWithConfig.func1.1(0x16a5098, 0xc000982e60, 0x1, 0x1)
        /go/pkg/mod/github.com/labstack/echo/v4@v4.3.0/middleware/jwt.go:229 +0x456
github.com/labstack/echo/v4.(*Echo).add.func1(0x16a5098, 0xc000982e60, 0x0, 0x0)
        /go/pkg/mod/github.com/labstack/echo/v4@v4.3.0/echo.go:536 +0x62
github.com/labstack/echo/v4/middleware.CORSWithConfig.func1.1(0x16a5098, 0xc000982e60, 0x48f900, 0xc00014cae0)
        /go/pkg/mod/github.com/labstack/echo/v4@v4.3.0/middleware/cors.go:118 +0x15a5
github.com/labstack/echo/v4/middleware.RecoverWithConfig.func1.1(0x16a5098, 0xc000982e60, 0x0, 0x0)
        /go/pkg/mod/github.com/labstack/echo/v4@v4.3.0/middleware/recover.go:98 +0x142
github.com/labstack/echo/v4/middleware.LoggerWithConfig.func2.1(0x16a5098, 0xc000982e60, 0x0, 0x0)
        /go/pkg/mod/github.com/labstack/echo/v4@v4.3.0/middleware/logger.go:117 +0x12c
github.com/labstack/echo/v4.(*Echo).ServeHTTP(0xc0002bc600, 0x168aaf8, 0xc000988460, 0xc001593e00)
        /go/pkg/mod/github.com/labstack/echo/v4@v4.3.0/echo.go:646 +0x2bc
net/http.serverHandler.ServeHTTP(0xc0001920e0, 0x168aaf8, 0xc000988460, 0xc001593e00)
        /usr/local/go/src/net/http/server.go:2887 +0xa3
net/http.(*conn).serve(0xc0009834a0, 0x168e7f8, 0xc0008d1d80)
        /usr/local/go/src/net/http/server.go:1952 +0x8cd
created by net/http.(*Server).Serve
        /usr/local/go/src/net/http/server.go:3013 +0x39b

goroutine 1 [chan receive, 69 minutes]:
code.vikunja.io/api/pkg/cmd.glob..func2(0x1d18b80, 0x1dee008, 0x0, 0x0)
        /go/src/code.vikunja.io/api/pkg/cmd/web.go:102 +0x1dc
github.com/spf13/cobra.(*Command).execute(0x1d18b80, 0xc0000a01f0, 0x0, 0x0, 0x1d18b80, 0xc0000a01f0)
        /go/pkg/mod/github.com/spf13/cobra@v1.2.1/command.go:860 +0x2c2
github.com/spf13/cobra.(*Command).ExecuteC(0x1d18b80, 0xc000000180, 0x200000003, 0xc000000180)
        /go/pkg/mod/github.com/spf13/cobra@v1.2.1/command.go:974 +0x375
github.com/spf13/cobra.(*Command).Execute(...)
        /go/pkg/mod/github.com/spf13/cobra@v1.2.1/command.go:902
code.vikunja.io/api/pkg/cmd.Execute()
        /go/src/code.vikunja.io/api/pkg/cmd/cmd.go:44 +0x31
main.main()
        /go/src/code.vikunja.io/api/main.go:22 +0x25

goroutine 37 [select, 69 minutes]:
database/sql.(*DB).connectionOpener(0xc0001b92b0, 0x168e750, 0xc0003655c0)
        /usr/local/go/src/database/sql/sql.go:1133 +0xb5
created by database/sql.OpenDB
        /usr/local/go/src/database/sql/sql.go:740 +0x12a

goroutine 54 [select]:
code.vikunja.io/api/pkg/mail.StartMailDaemon.func1()
        /go/src/code.vikunja.io/api/pkg/mail/mail.go:62 +0x125
created by code.vikunja.io/api/pkg/mail.StartMailDaemon
        /go/src/code.vikunja.io/api/pkg/mail/mail.go:55 +0x167

goroutine 55 [select]:
github.com/robfig/cron/v3.(*Cron).run(0xc0004705a0)
        /go/pkg/mod/github.com/robfig/cron/v3@v3.0.1/cron.go:263 +0x509
created by github.com

2021-07-14T11:45:28.635557444Z: WEB     ▶ 164.128.141.50  GET 500 /api/v1/lists/32/tasks?sort_by[]=done&sort_by[]=id&order_by[]=asc&order_by[]=desc&filter_by[]=done&filter_value[]=false&filter_comparator[]=equals&filter_concat=and&page=1 26.709371ms - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36
2021-07-14T11:45:33.51890598Z: WEB      ▶ 164.128.141.50  POST 200 /api/v1/user/token 1.636433ms - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36
2021-07-14T11:45:33.540195086Z: WEB     ▶ 164.128.141.50  GET 200 /api/v1/user 1.350898ms - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36
2021-07-14T11:45:38.536790854Z: WEB     ▶ 164.128.141.50  GET 200 /api/v1/notifications?page=1 7.509789ms - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36
2021-07-14T11:45:48.539263079Z: WEB     ▶ 164.128.141.50  GET 200 /api/v1/notifications?page=1 5.520801ms - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36
2021-07-14T11:45:58.537332749Z: WEB     ▶ 164.128.141.50  GET 200 /api/v1/notifications?page=1 4.433513ms - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36
2021-07-14T11:46:08.542601098Z: WEB     ▶ 164.128.141.50  GET 200 /api/v1/notifications?page=1 4.321623ms - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36
2021-07-14T11:46:14.709587163Z: WEB     ▶ 77.22.250.193  GET 200 /api/v1/notifications?page=1 3.424973ms - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.114 Safari/537.36 OPR/77.0.4054.172
I am running this on a docker enviroment, using this docker-compose file: ```yml version: '3' services: db: image: mariadb:10 ports: - 3306:3306 command: --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci environment: MYSQL_ROOT_PASSWORD: supersecret MYSQL_USER: vikunja MYSQL_PASSWORD: secret MYSQL_DATABASE: vikunja volumes: - /volume3/docker/docker_vikunja/db:/var/lib/mysql restart: unless-stopped api: image: vikunja/api:latest environment: VIKUNJA_SERVICE_TIMEZONE: CET VIKUNJA_MAILER_FROMEMAIL: --------- VIKUNJA_MAILER_PASSWORD: --------- VIKUNJA_MAILER_USERNAME: --------- VIKUNJA_MAILER_HOST: smtp.gmail.com VIKUNJA_MAILER_ENABLED: "true" # VIKUNJA_SERVICE_ENABLEREGISTRATION: "false" VIKUNJA_BACKGROUNDS_PROVIDERS_UNSPLASH_APPLICATIONID: ---------- VIKUNJA_BACKGROUNDS_PROVIDERS_UNSPLASH_ACCESSTOKEN: '-------------' VIKUNJA_BACKGROUNDS_PROVIDERS_UNSPLASH_ENABLED: "true" VIKUNJA_BACKGROUNDS_PROVIDERS_UPLOAD_ENABLED: "false" VIKUNJA_SERVICE_FRONTENDURL: '---------' VIKUNJA_DATABASE_HOST: db VIKUNJA_DATABASE_PASSWORD: --------- VIKUNJA_DATABASE_TYPE: mysql VIKUNJA_DATABASE_USER: --------- VIKUNJA_DATABASE_DATABASE: --------- volumes: - /volume3/docker/docker_vikunja/files:/app/vikunja/files depends_on: - db restart: unless-stopped frontend: image: vikunja/frontend:latest restart: unless-stopped proxy: image: nginx ports: - 65432:80 depends_on: - api - frontend restart: unless-stopped ``` FRONTEND LOG: ``` ... 192.168.32.5 - - [14/Jul/2021:11:03:11 +0000] "GET /lists/31/list HTTP/1.0" 304 0 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36" "164.128.141.50" 192.168.32.5 - - [14/Jul/2021:11:03:11 +0000] "GET /images/icons/favicon-32x32.png HTTP/1.0" 200 1723 "https://projects.james-things.com/lists/31/list" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36" "164.128.141.50" 192.168.32.5 - - [14/Jul/2021:11:03:13 +0000] "GET /sw.js HTTP/1.0" 304 0 "https://projects.james-things.com/sw.js" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36" "164.128.141.50" 192.168.32.5 - - [14/Jul/2021:11:03:24 +0000] "GET /lists/31/list HTTP/1.0" 304 0 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36" "164.128.141.50" 192.168.32.5 - - [14/Jul/2021:11:03:25 +0000] "GET /images/icons/favicon-32x32.png HTTP/1.0" 200 1723 "https://projects.james-things.com/lists/31/list" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36" "164.128.141.50" 192.168.32.5 - - [14/Jul/2021:11:03:27 +0000] "GET /sw.js HTTP/1.0" 304 0 "https://projects.james-things.com/sw.js" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36" "164.128.141.50" 192.168.32.5 - - [14/Jul/2021:11:03:40 +0000] "GET /images/icons/favicon-32x32.png HTTP/1.0" 200 1723 "https://projects.james-things.com/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36" "164.128.141.50" 192.168.32.5 - - [14/Jul/2021:11:03:42 +0000] "GET /sw.js HTTP/1.0" 304 0 "https://projects.james-things.com/sw.js" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36" "164.128.141.50" 192.168.32.5 - - [14/Jul/2021:11:06:08 +0000] "GET /lists/29/list HTTP/1.0" 200 3935 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36" "164.128.141.50" 192.168.32.5 - - [14/Jul/2021:11:06:08 +0000] "GET /images/icons/favicon-32x32.png HTTP/1.0" 200 1723 "https://projects.james-things.com/lists/29/list" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36" "164.128.141.50" 192.168.32.5 - - [14/Jul/2021:11:06:10 +0000] "GET /sw.js HTTP/1.0" 304 0 "https://projects.james-things.com/sw.js" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36" "164.128.141.50" 192.168.32.5 - - [14/Jul/2021:11:06:25 +0000] "GET /lists/29/list HTTP/1.0" 304 0 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36" "164.128.141.50" 192.168.32.5 - - [14/Jul/2021:11:06:26 +0000] "GET /images/icons/favicon-32x32.png HTTP/1.0" 200 1723 "https://projects.james-things.com/lists/29/list" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36" "164.128.141.50" 192.168.32.5 - - [14/Jul/2021:11:06:27 +0000] "GET /sw.js HTTP/1.0" 304 0 "https://projects.james-things.com/sw.js" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36" "164.128.141.50" 192.168.32.5 - - [14/Jul/2021:11:22:25 +0000] "GET /images/icons/favicon-32x32.png HTTP/1.0" 200 1723 "https://projects.james-things.com/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.114 Safari/537.36 OPR/77.0.4054.172" "77.22.250.193" 192.168.32.5 - - [14/Jul/2021:11:22:27 +0000] "GET /sw.js HTTP/1.0" 304 0 "https://projects.james-things.com/sw.js" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.114 Safari/537.36 OPR/77.0.4054.172" "77.22.250.193" 192.168.32.5 - - [14/Jul/2021:11:22:27 +0000] "GET /images/icons/favicon-32x32.png HTTP/1.0" 200 1723 "https://projects.james-things.com/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.114 Safari/537.36 OPR/77.0.4054.172" "77.22.250.193" 192.168.32.5 - - [14/Jul/2021:11:22:29 +0000] "GET /sw.js HTTP/1.0" 304 0 "https://projects.james-things.com/sw.js" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.114 Safari/537.36 OPR/77.0.4054.172" "77.22.250.193" 192.168.32.5 - - [14/Jul/2021:11:40:46 +0000] "GET /tasks/94 HTTP/1.0" 200 3935 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36" "164.128.141.50" 192.168.32.5 - - [14/Jul/2021:11:40:46 +0000] "GET /images/icons/favicon-32x32.png HTTP/1.0" 200 1723 "https://projects.james-things.com/tasks/94" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36" "164.128.141.50" 192.168.32.5 - - [14/Jul/2021:11:40:48 +0000] "GET /sw.js HTTP/1.0" 304 0 "https://projects.james-things.com/sw.js" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36" "164.128.141.50" 192.168.32.5 - - [14/Jul/2021:11:40:48 +0000] "GET /lists/-2/null HTTP/1.0" 200 3935 "https://projects.james-things.com/lists/-2/kanban" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36" "164.128.141.50" 192.168.32.5 - - [14/Jul/2021:11:45:25 +0000] "GET /sw.js HTTP/1.0" 304 0 "https://projects.james-things.com/sw.js" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36" "164.128.141.50" 192.168.32.5 - - [14/Jul/2021:11:45:26 +0000] "GET /lists/32/null HTTP/1.0" 200 3935 "https://projects.james-things.com/lists/32/list" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36" "164.128.141.50" 192.168.32.5 - - [14/Jul/2021:11:45:27 +0000] "GET /lists/32/list HTTP/1.0" 200 3935 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36" "164.128.141.50" 192.168.32.5 - - [14/Jul/2021:11:45:27 +0000] "GET /images/icons/favicon-32x32.png HTTP/1.0" 200 1723 "https://projects.james-things.com/lists/32/list" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36" "164.128.141.50" 192.168.32.5 - - [14/Jul/2021:11:45:27 +0000] "GET /lists/32/list HTTP/1.0" 304 0 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36" "164.128.141.50" 192.168.32.5 - - [14/Jul/2021:11:45:28 +0000] "GET /images/icons/favicon-32x32.png HTTP/1.0" 200 1723 "https://projects.james-things.com/lists/32/list" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36" "164.128.141.50" 192.168.32.5 - - [14/Jul/2021:11:45:28 +0000] "GET /lists/32/list HTTP/1.0" 304 0 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36" "164.128.141.50" 192.168.32.5 - - [14/Jul/2021:11:45:28 +0000] "GET /images/icons/favicon-32x32.png HTTP/1.0" 200 1723 "https://projects.james-things.com/lists/32/list" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36" "164.128.141.50" 192.168.32.5 - - [14/Jul/2021:11:45:30 +0000] "GET /sw.js HTTP/1.0" 304 0 "https://projects.james-things.com/sw.js" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36" "164.128.141.50" ``` API LOG: ``` ... 021-07-14T11:45:27.588896236Z: WEB ▶ 164.128.141.50 GET 500 /api/v1/lists/32/tasks?sort_by[]=done&sort_by[]=id&order_by[]=asc&order_by[]=desc&filter_by[]=done&filter_value[]=false&filter_comparator[]=equals&filter_concat=and&page=1 26.919167ms - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36 2021-07-14T11:45:27.926105696Z: WEB ▶ 164.128.141.50 GET 200 /api/v1/avatar/James?size=50 1.240527ms - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36 2021-07-14T11:45:27.97858809Z: WEB ▶ 164.128.141.50 GET 200 /api/v1/info 269.047µs - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36 2021-07-14T11:45:27.980358526Z: WEB ▶ 164.128.141.50 GET 200 /api/v1/user 2.039244ms - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36 2021-07-14T11:45:27.99140475Z: WEB ▶ 164.128.141.50 GET 200 /api/v1/notifications?page=1 7.824004ms - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36 2021-07-14T11:45:27.995020555Z: WEB ▶ 164.128.141.50 GET 200 /api/v1/lists/32 8.511616ms - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36 2021-07-14T11:45:27.99960863Z: WEB ▶ 164.128.141.50 GET 200 /api/v1/labels?page=1 17.188957ms - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36 2021-07-14T11:45:28.007926758Z: - ▶ echo recover.go:92 [PANIC RECOVER] runtime error: invalid memory address or nil pointer dereference goroutine 3415 [running]: github.com/labstack/echo/v4/middleware.RecoverWithConfig.func1.1.1(0x1524e80, 0x1000, 0x0, 0x16a5098, 0xc0008e4000) /go/pkg/mod/github.com/labstack/echo/v4@v4.3.0/middleware/recover.go:77 +0x105 panic(0x11ead20, 0x1d08260) /usr/local/go/src/runtime/panic.go:965 +0x1b9 code.vikunja.io/api/pkg/models.addRelatedTasksToTasks(0xc00051b6c0, 0xc000570aa0, 0x4, 0x4, 0xc00081d078, 0x16765e0, 0xc00091c500, 0xc0006ebff6, 0x2) /go/src/code.vikunja.io/api/pkg/models/tasks.go:673 +0x4fb code.vikunja.io/api/pkg/models.addMoreInfoToTasks(0xc00051b6c0, 0xc00081d078, 0x16765e0, 0xc00091c500, 0x16765e0, 0xc00091c500) /go/src/code.vikunja.io/api/pkg/models/tasks.go:754 +0x8a8 code.vikunja.io/api/pkg/models.getTasksForLists(0xc00051b6c0, 0xc0000c6d98, 0x1, 0x1, 0x16765e0, 0xc00091c500, 0xc00043e620, 0x0, 0x4154db, 0xc00051b6c0, ...) /go/src/code.vikunja.io/api/pkg/models/tasks.go:503 +0x228 code.vikunja.io/api/pkg/models.(*TaskCollection).ReadAll(0xc00091e840, 0xc00051b6c0, 0x16765e0, 0xc00091c500, 0x0, 0x0, 0x1, 0x32, 0x0, 0x0, ...) /go/src/code.vikunja.io/api/pkg/models/task_collection.go:199 +0x37c code.vikunja.io/web/handler.(*WebHandler).ReadAllWeb(0xc000010cf8, 0x16a5098, 0xc0008e4000, 0x0, 0x0) /go/pkg/mod/code.vikunja.io/web@v0.0.0-20210706160506-d85def955bd3/handler/read_all.go:94 +0xa72 github.com/labstack/echo/v4/middleware.JWTWithConfig.func1.1(0x16a5098, 0xc0008e4000, 0x1, 0x1) /go/pkg/mod/github.com/labstack/echo/v4@v4.3.0/middleware/jwt.go:229 +0x456 github.com/labstack/echo/v4.(*Echo).add.func1(0x16a5098, 0xc0008e4000, 0x0, 0x0) /go/pkg/mod/github.com/labstack/echo/v4@v4.3.0/echo.go:536 +0x62 github.com/labstack/echo/v4/middleware.CORSWithConfig.func1.1(0x16a5098, 0xc0008e4000, 0x0, 0x203000) /go/pkg/mod/github.com/labstack/echo/v4@v4.3.0/middleware/cors.go:118 +0x15a5 github.com/labstack/echo/v4/middleware.RecoverWithConfig.func1.1(0x16a5098, 0xc0008e4000, 0x0, 0x0) /go/pkg/mod/github.com/labstack/echo/v4@v4.3.0/middleware/recover.go:98 +0x142 github.com/labstack/echo/v4/middleware.LoggerWithConfig.func2.1(0x16a5098, 0xc0008e4000, 0x0, 0x0) /go/pkg/mod/github.com/labstack/echo/v4@v4.3.0/middleware/logger.go:117 +0x12c github.com/labstack/echo/v4.(*Echo).ServeHTTP(0xc0002bc600, 0x168aaf8, 0xc0014fa8c0, 0xc00091c400) /go/pkg/mod/github.com/labstack/echo/v4@v4.3.0/echo.go:646 +0x2bc net/http.serverHandler.ServeHTTP(0xc0001920e0, 0x168aaf8, 0xc0014fa8c0, 0xc00091c400) /usr/local/go/src/net/http/server.go:2887 +0xa3 net/http.(*conn).serve(0xc000982c80, 0x168e7f8, 0xc0012a9680) /usr/local/go/src/net/http/server.go:1952 +0x8cd created by net/http.(*Server).Serve /usr/local/go/src/net/http/server.go:3013 +0x39b goroutine 1 [chan receive, 69 minutes]: code.vikunja.io/api/pkg/cmd.glob..func2(0x1d18b80, 0x1dee008, 0x0, 0x0) /go/src/code.vikunja.io/api/pkg/cmd/web.go:102 +0x1dc github.com/spf13/cobra.(*Command).execute(0x1d18b80, 0xc0000a01f0, 0x0, 0x0, 0x1d18b80, 0xc0000a01f0) /go/pkg/mod/github.com/spf13/cobra@v1.2.1/command.go:860 +0x2c2 github.com/spf13/cobra.(*Command).ExecuteC(0x1d18b80, 0xc000000180, 0x200000003, 0xc000000180) /go/pkg/mod/github.com/spf13/cobra@v1.2.1/command.go:974 +0x375 github.com/spf13/cobra.(*Command).Execute(...) /go/pkg/mod/github.com/spf13/cobra@v1.2.1/command.go:902 code.vikunja.io/api/pkg/cmd.Execute() /go/src/code.vikunja.io/api/pkg/cmd/cmd.go:44 +0x31 main.main() /go/src/code.vikunja.io/api/main.go:22 +0x25 goroutine 37 [select, 69 minutes]: database/sql.(*DB).connectionOpener(0xc0001b92b0, 0x168e750, 0xc0003655c0) /usr/local/go/src/database/sql/sql.go:1133 +0xb5 created by database/sql.OpenDB /usr/local/go/src/database/sql/sql.go:740 +0x12a goroutine 54 [select]: code.vikunja.io/api/pkg/mail.StartMailDaemon.func1() /go/src/code.vikunja.io/api/pkg/mail/mail.go:62 +0x125 created by code.vikunja.io/api/pkg/mail.StartMailDaemon /go/src/code.vikunja.io/api/pkg/mail/mail.go:55 +0x167 goroutine 55 [select]: github.com/robfig/cron/v3.(*Cron).run(0xc0004705a0) /go/pkg/mod/github.com/robfig/cron/v3@v3.0.1/cron.go:263 +0x509 created by github.com/robfig/c 2021-07-14T11:45:28.00800704Z: WEB ▶ 164.128.141.50 GET 500 /api/v1/lists/32/tasks?sort_by[]=done&sort_by[]=id&order_by[]=asc&order_by[]=desc&filter_by[]=done&filter_value[]=false&filter_comparator[]=equals&filter_concat=and&page=1 23.970833ms - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36 2021-07-14T11:45:28.018335918Z: WEB ▶ 164.128.141.50 GET 200 /api/v1/namespaces?is_archived=true&page=1 35.916515ms - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36 2021-07-14T11:45:28.508716705Z: WEB ▶ 164.128.141.50 GET 200 /api/v1/avatar/James?size=50 1.288931ms - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36 2021-07-14T11:45:28.60392276Z: WEB ▶ 164.128.141.50 GET 200 /api/v1/info 311.823µs - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36 2021-07-14T11:45:28.605692629Z: WEB ▶ 164.128.141.50 GET 200 /api/v1/user 1.926803ms - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36 2021-07-14T11:45:28.617675321Z: WEB ▶ 164.128.141.50 GET 200 /api/v1/notifications?page=1 8.836249ms - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36 2021-07-14T11:45:28.623964264Z: WEB ▶ 164.128.141.50 GET 200 /api/v1/labels?page=1 16.467355ms - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36 2021-07-14T11:45:28.62527508Z: WEB ▶ 164.128.141.50 GET 200 /api/v1/lists/32 15.744358ms - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36 2021-07-14T11:45:28.633191006Z: WEB ▶ 164.128.141.50 GET 200 /api/v1/namespaces?is_archived=true&page=1 25.130786ms - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36 2021-07-14T11:45:28.635476776Z: - ▶ echo recover.go:92 [PANIC RECOVER] runtime error: invalid memory address or nil pointer dereference goroutine 3423 [running]: github.com/labstack/echo/v4/middleware.RecoverWithConfig.func1.1.1(0x1524e80, 0x1000, 0x0, 0x16a5098, 0xc000982e60) /go/pkg/mod/github.com/labstack/echo/v4@v4.3.0/middleware/recover.go:77 +0x105 panic(0x11ead20, 0x1d08260) /usr/local/go/src/runtime/panic.go:965 +0x1b9 code.vikunja.io/api/pkg/models.addRelatedTasksToTasks(0xc00120e680, 0xc000570f40, 0x4, 0x4, 0xc00073f078, 0x16765e0, 0xc001593f00, 0xc0006d9ea6, 0x2) /go/src/code.vikunja.io/api/pkg/models/tasks.go:673 +0x4fb code.vikunja.io/api/pkg/models.addMoreInfoToTasks(0xc00120e680, 0xc00073f078, 0x16765e0, 0xc001593f00, 0x16765e0, 0xc001593f00) /go/src/code.vikunja.io/api/pkg/models/tasks.go:754 +0x8a8 code.vikunja.io/api/pkg/models.getTasksForLists(0xc00120e680, 0xc000296d78, 0x1, 0x1, 0x16765e0, 0xc001593f00, 0xc0003140e0, 0x0, 0x4154db, 0xc00120e680, ...) /go/src/code.vikunja.io/api/pkg/models/tasks.go:503 +0x228 code.vikunja.io/api/pkg/models.(*TaskCollection).ReadAll(0xc00121ec60, 0xc00120e680, 0x16765e0, 0xc001593f00, 0x0, 0x0, 0x1, 0x32, 0x0, 0x0, ...) /go/src/code.vikunja.io/api/pkg/models/task_collection.go:199 +0x37c code.vikunja.io/web/handler.(*WebHandler).ReadAllWeb(0xc000010cf8, 0x16a5098, 0xc000982e60, 0x0, 0x0) /go/pkg/mod/code.vikunja.io/web@v0.0.0-20210706160506-d85def955bd3/handler/read_all.go:94 +0xa72 github.com/labstack/echo/v4/middleware.JWTWithConfig.func1.1(0x16a5098, 0xc000982e60, 0x1, 0x1) /go/pkg/mod/github.com/labstack/echo/v4@v4.3.0/middleware/jwt.go:229 +0x456 github.com/labstack/echo/v4.(*Echo).add.func1(0x16a5098, 0xc000982e60, 0x0, 0x0) /go/pkg/mod/github.com/labstack/echo/v4@v4.3.0/echo.go:536 +0x62 github.com/labstack/echo/v4/middleware.CORSWithConfig.func1.1(0x16a5098, 0xc000982e60, 0x48f900, 0xc00014cae0) /go/pkg/mod/github.com/labstack/echo/v4@v4.3.0/middleware/cors.go:118 +0x15a5 github.com/labstack/echo/v4/middleware.RecoverWithConfig.func1.1(0x16a5098, 0xc000982e60, 0x0, 0x0) /go/pkg/mod/github.com/labstack/echo/v4@v4.3.0/middleware/recover.go:98 +0x142 github.com/labstack/echo/v4/middleware.LoggerWithConfig.func2.1(0x16a5098, 0xc000982e60, 0x0, 0x0) /go/pkg/mod/github.com/labstack/echo/v4@v4.3.0/middleware/logger.go:117 +0x12c github.com/labstack/echo/v4.(*Echo).ServeHTTP(0xc0002bc600, 0x168aaf8, 0xc000988460, 0xc001593e00) /go/pkg/mod/github.com/labstack/echo/v4@v4.3.0/echo.go:646 +0x2bc net/http.serverHandler.ServeHTTP(0xc0001920e0, 0x168aaf8, 0xc000988460, 0xc001593e00) /usr/local/go/src/net/http/server.go:2887 +0xa3 net/http.(*conn).serve(0xc0009834a0, 0x168e7f8, 0xc0008d1d80) /usr/local/go/src/net/http/server.go:1952 +0x8cd created by net/http.(*Server).Serve /usr/local/go/src/net/http/server.go:3013 +0x39b goroutine 1 [chan receive, 69 minutes]: code.vikunja.io/api/pkg/cmd.glob..func2(0x1d18b80, 0x1dee008, 0x0, 0x0) /go/src/code.vikunja.io/api/pkg/cmd/web.go:102 +0x1dc github.com/spf13/cobra.(*Command).execute(0x1d18b80, 0xc0000a01f0, 0x0, 0x0, 0x1d18b80, 0xc0000a01f0) /go/pkg/mod/github.com/spf13/cobra@v1.2.1/command.go:860 +0x2c2 github.com/spf13/cobra.(*Command).ExecuteC(0x1d18b80, 0xc000000180, 0x200000003, 0xc000000180) /go/pkg/mod/github.com/spf13/cobra@v1.2.1/command.go:974 +0x375 github.com/spf13/cobra.(*Command).Execute(...) /go/pkg/mod/github.com/spf13/cobra@v1.2.1/command.go:902 code.vikunja.io/api/pkg/cmd.Execute() /go/src/code.vikunja.io/api/pkg/cmd/cmd.go:44 +0x31 main.main() /go/src/code.vikunja.io/api/main.go:22 +0x25 goroutine 37 [select, 69 minutes]: database/sql.(*DB).connectionOpener(0xc0001b92b0, 0x168e750, 0xc0003655c0) /usr/local/go/src/database/sql/sql.go:1133 +0xb5 created by database/sql.OpenDB /usr/local/go/src/database/sql/sql.go:740 +0x12a goroutine 54 [select]: code.vikunja.io/api/pkg/mail.StartMailDaemon.func1() /go/src/code.vikunja.io/api/pkg/mail/mail.go:62 +0x125 created by code.vikunja.io/api/pkg/mail.StartMailDaemon /go/src/code.vikunja.io/api/pkg/mail/mail.go:55 +0x167 goroutine 55 [select]: github.com/robfig/cron/v3.(*Cron).run(0xc0004705a0) /go/pkg/mod/github.com/robfig/cron/v3@v3.0.1/cron.go:263 +0x509 created by github.com 2021-07-14T11:45:28.635557444Z: WEB ▶ 164.128.141.50 GET 500 /api/v1/lists/32/tasks?sort_by[]=done&sort_by[]=id&order_by[]=asc&order_by[]=desc&filter_by[]=done&filter_value[]=false&filter_comparator[]=equals&filter_concat=and&page=1 26.709371ms - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36 2021-07-14T11:45:33.51890598Z: WEB ▶ 164.128.141.50 POST 200 /api/v1/user/token 1.636433ms - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36 2021-07-14T11:45:33.540195086Z: WEB ▶ 164.128.141.50 GET 200 /api/v1/user 1.350898ms - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36 2021-07-14T11:45:38.536790854Z: WEB ▶ 164.128.141.50 GET 200 /api/v1/notifications?page=1 7.509789ms - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36 2021-07-14T11:45:48.539263079Z: WEB ▶ 164.128.141.50 GET 200 /api/v1/notifications?page=1 5.520801ms - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36 2021-07-14T11:45:58.537332749Z: WEB ▶ 164.128.141.50 GET 200 /api/v1/notifications?page=1 4.433513ms - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36 2021-07-14T11:46:08.542601098Z: WEB ▶ 164.128.141.50 GET 200 /api/v1/notifications?page=1 4.321623ms - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.76 Safari/537.36 2021-07-14T11:46:14.709587163Z: WEB ▶ 77.22.250.193 GET 200 /api/v1/notifications?page=1 3.424973ms - Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.114 Safari/537.36 OPR/77.0.4054.172 ```
Owner

Interesting, on the "Try" page it doesn't crash it

Then it is fixed in the latest (unstable) version. The logs seems to confirm that's the error I noticed and fixed in 7adbd21698.
Please update your instance to verify.

You can check the api version running in the frontend under the about dialoge (top left).

> Interesting, on the "Try" page it doesn't crash it Then it is fixed in the latest (unstable) version. The logs seems to confirm that's the error I noticed and fixed in https://kolaente.dev/vikunja/api/commit/7adbd2169850a945fbeba5d27b0ca51aa270d756. Please update your instance to verify. You can check the api version running in the frontend under the about dialoge (top left).
Author

That seemed to have fixed it; plus it seems to have also fixed other lists that were messed up.

Thanks!

That seemed to have fixed it; plus it seems to have also fixed other lists that were messed up. Thanks!
konrad referenced this issue from a commit 2024-02-07 14:00:33 +00:00
Sign in to join this conversation.
No Milestone
No Assignees
2 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: vikunja/vikunja#1810
No description provided.