portainer: Migration of db fails when upgrading to 2.19.4 when using network file system for data volume

Before you start please confirm the following.

• Yes, I’ve searched similar issues on GitHub.
• Yes, I’ve checked whether this issue is covered in the Portainer documentation or knowledge base.

Problem Description

Error when deploying 2.19.4 CE docker image. Failed migration | error=“while backing up database: read /data/portainer.db: permission denied”

I am able to rollback to the image 2.19.4 CE and access the db fine and container starts. I had this issue previously here: https://github.com/portainer/portainer/issues/7144

Expected Behavior

Able to apply latest version.

Actual Behavior

Error when migrating.

Steps to Reproduce

Pulled new image (2.19.4) using docker-compose and started container.

Portainer logs or screenshots

2023/12/07 12:45AM INF github.com/portainer/portainer/api/cmd/portainer/main.go:369 > encryption key file not present | filename=portainer
2023/12/07 12:45AM INF github.com/portainer/portainer/api/cmd/portainer/main.go:392 > proceeding without encryption key |
2023/12/07 12:45AM INF github.com/portainer/portainer/api/database/boltdb/db.go:125 > loading PortainerDB | filename=portainer.db
2023/12/07 12:45AM INF github.com/portainer/portainer/api/datastore/backup.go:16 > Backing up database | from=/data/portainer.db to=/data/backups/portainer.db.bak
2023/12/07 12:45AM WRN github.com/portainer/portainer/api/datastore/backup.go:19 > failed to create backup file | error="read /data/portainer.db: permission denied"
2023/12/07 12:45AM FTL github.com/portainer/portainer/api/cmd/portainer/main.go:142 > failed migration | error="while backing up database: read /data/portainer.db: permission denied" stack_trace=[{"func":"(*Store).MigrateData","line":"45","source":"migrate_data.go"},{"func":"initDataStore","line":"140","source":"main.go"},{"func":"buildServer","line":"395","source":"main.go"},{"func":"main","line":"640","source":"main.go"},{"func":"main","line":"250","source":"proc.go"},{"func":"goexit","line":"1598","source":"asm_amd64.s"}]

Portainer version

2.19.4

Portainer Edition

Community Edition (CE)

Platform and Version

24.0.5, build ced0996

OS and Architecture

Ubuntu 22.04 AMD64

Browser

No response

What command did you use to deploy Portainer?

services:
  portainer:
    container_name: portainer
    image: portainer/portainer-ce:latest
    ports:
      - "$PORTAINER_PORT:9000/tcp"
    volumes:
      - portainer_data:/data

volumes:
  portainer_data:
    driver_opts:
      o: "username=xyz,password=xyz"
      type: "cifs"
      device: \\10.1.1.1\portainer\data

Additional Information

No response