dify doesn't support postgresql 17 #194

Closed
opened 2026-02-16 00:20:27 -05:00 by yindo · 0 comments
Owner

Originally created by @lx308033262 on GitHub (Sep 29, 2025).

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)
Originally created by @lx308033262 on GitHub (Sep 29, 2025). ### Self Checks - [x] I have read the [Contributing Guide](https://github.com/langgenius/dify/blob/main/CONTRIBUTING.md) and [Language Policy](https://github.com/langgenius/dify/issues/1542). - [x] This is only for bug report, if you would like to ask a question, please head to [Discussions](https://github.com/langgenius/dify/discussions/categories/general). - [x] I have searched for existing issues [search for existing issues](https://github.com/langgenius/dify/issues), including closed ones. - [x] I confirm that I am using English to submit this report, otherwise it will be closed. - [x] 【中文用户 & Non English User】请使用英语提交,否则会被关闭 :) - [x] 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) ``` 3. 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) ```
yindo closed this issue 2026-02-16 00:20:27 -05:00
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: langgenius/dify-plugin-daemon#194