Skip to content

dify doesn't support postgresql 17 #469

@lx308033262

Description

@lx308033262

Self Checks

  • I have read the Contributing Guide and Language Policy.
  • This is only for bug report, if you would like to ask a question, please head to Discussions.
  • I have searched for existing issues search for existing issues, including closed ones.
  • I confirm that I am using English to submit this report, otherwise it will be closed.
  • 【中文用户 & Non English User】请使用英语提交,否则会被关闭 :)
  • Please do not modify this template :) and fill in all the required fields.

Dify version

image: langgenius/dify-plugin-daemon:0.2.0-local

Cloud or Self Hosted

Cloud

Steps to reproduce

1.install postgresql with pg version 17
2. plugin daemon not runnning

# kubectl  logs -f plugin-daemon-55d56bff6c-cx96m  -n dify
2025/09/29 02:40:21 pool.go:32: [INFO]init routine pool, size: 10000
2025/09/29 02:40:21 init.go:95: [PANIC]failed to init dify plugin db: ERROR: extension "uuid-ossp" is not available (SQLSTATE 0A000)
panic: [PANIC]failed to init dify plugin db: ERROR: extension "uuid-ossp" is not available (SQLSTATE 0A000)

goroutine 1 [running]:
github.com/langgenius/dify-plugin-daemon/internal/utils/log.writeLog({0x2667608, 0x5}, {0x26aef5b?, 0x21a326d?}, 0x1, {0xc0005e3ba0, 0x1, 0x1})
        /app/internal/utils/log/log.go:40 +0x305
github.com/langgenius/dify-plugin-daemon/internal/utils/log.Panic(...)
        /app/internal/utils/log/log.go:66
github.com/langgenius/dify-plugin-daemon/internal/db.Init(0x2710?)
        /app/internal/db/init.go:95 +0x416
github.com/langgenius/dify-plugin-daemon/internal/server.(*App).Run(0xc00011f8d8, 0xc0006f9088)
        /app/internal/server/server.go:93 +0xd2
main.main()
        /app/cmd/server/main.go:28 +0x125
my pg version
dify=# select version();
                                                version                                                
-------------------------------------------------------------------------------------------------------
 PostgreSQL 17.4 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 13.3.0-6ubuntu2~24.04) 13.3.0, 64-bit
(1 row)
  1. change pg version
    when i change postgresql to 15-alpine,it's ok
# k describe pod dify-postgres-0    -n dify  |grep -i image:
    Image:          postgres:15-alpine
# k get pods -n dify
NAME                             READY   STATUS              RESTARTS      AGE
api-0                            1/1     Running             4 (54s ago)   10m
dify-postgres-0                  1/1     Running             0             47m
plugin-daemon-6696dfb678-4zmwq   1/1     Running             0             23m

✔️ Expected Behavior

use pg version 17 ok

❌ Actual Behavior

plugin daemon error

# kubectl  logs -f plugin-daemon-55d56bff6c-cx96m  -n dify
2025/09/29 02:40:21 pool.go:32: [INFO]init routine pool, size: 10000
2025/09/29 02:40:21 init.go:95: [PANIC]failed to init dify plugin db: ERROR: extension "uuid-ossp" is not available (SQLSTATE 0A000)
panic: [PANIC]failed to init dify plugin db: ERROR: extension "uuid-ossp" is not available (SQLSTATE 0A000)

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions