ERROR: duplicate key value violates unique constraint "dinky_sys_menu_pkey"

[caesar168]

Search before asking

• I had searched in the issues and found no similar issues.

What happened

---

SQL State : 23505
Error Code : 0
Message : ERROR: duplicate key value violates unique constraint "dinky_sys_menu_pkey"
Detail: Key (id)=(2) already exists.
Location : db/migration/pgsql/V20240729.1.1.0__release.sql (/home/vcs/dinky-release-1.19-1.1.0/file:/home/vcs/dinky-release-1.19-1.1.0/lib/dinky-admin-1.1.0.jar!/db/migration/pgsql/V20240729.1.1.0__release.sql)
Line : 6
Statement : INSERT INTO public.dinky_sys_menu (parent_id, name, path, component, perms, icon, type, display, order_num,
create_time, update_time, note)
VALUES (164, '仪表盘列表', '/dashboard/list', './Dashboard', 'dashboard:list', 'UnorderedListOutlined', 'F', 0, 167,
'2024-07-29 15:37:46', '2024-07-29 15:37:46', NULL)

What you expected to happen

Using PG as the backend database, an error was reported when starting the service, and I executed the PG initialization SQL script

How to reproduce

Use PG as the backend database, use PG16.4, and start DINKY

Anything else

No response

Version

1.1.0

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[github-actions]

Hello @caesar168, thank you for your feedback, but this issue has been fixed. You can search for keywords in the Issue list to view it. Issues are marked as `Fixed`.

你好 @caesar168, 感谢你的反馈, 但是此问题已经被修复了，你可以在 Issue 列表中搜索关键字来查看, Issues 标注为 `Fixed` 。

[github-actions]

Hi @, Since this issue was marked as fixed, no response has been received for 2 days. The issue is now closed. If you have any questions, please comment and reply.

Hi @, 由于该 issue 被标记为已修复，却 2 天未收到回应。现关闭 issue，若有任何问题，可评论回复。