[RESOLVED] Failed to run migration '005_120_to_130'

Hi team,
I’m trying to migrate my Kong from 0.14.1 to 1.5.0 and got this error when running migration up. Is there anything I could do to fix this? I checked the certificates table, it’s empty:

Error: [PostgreSQL error] cluster_mutex callback threw an error: /usr/local/share/lua/5.1/kong/cmd/utils/migrations.lua:158: [PostgreSQL error] failed to run migration '005_120_to_130' up: ERROR: there is no unique constraint matching given keys for referenced table "certificates"

stack traceback:
[C]: in function ‘assert’
/usr/local/share/lua/5.1/kong/cmd/utils/migrations.lua:158: in function </usr/local/share/lua/5.1/kong/cmd/utils/migrations.lua:124>
[C]: in function ‘xpcall’
/usr/local/share/lua/5.1/kong/db/init.lua:358: in function </usr/local/share/lua/5.1/kong/db/init.lua:308>
[C]: in function ‘pcall’
/usr/local/share/lua/5.1/kong/concurrency.lua:45: in function ‘cluster_mutex’
/usr/local/share/lua/5.1/kong/cmd/utils/migrations.lua:124: in function ‘up’
/usr/local/share/lua/5.1/kong/cmd/migrations.lua:202: in function ‘cmd_exec’
/usr/local/share/lua/5.1/kong/cmd/init.lua:87: in function </usr/local/share/lua/5.1/kong/cmd/init.lua:87>
[C]: in function ‘xpcall’
/usr/local/share/lua/5.1/kong/cmd/init.lua:87: in function </usr/local/share/lua/5.1/kong/cmd/init.lua:44>
/usr/local/bin/kong:9: in function ‘file_gen’
init_worker_by_lua:47: in function <init_worker_by_lua:45>
[C]: in function ‘xpcall’
init_worker_by_lua:54: in function <init_worker_by_lua:52>

Many thanks.

This is resolved in https://github.com/Kong/kong/issues/5686.

Please do not cross post on multiple forums.

Because this thread is unresponsive (noone response me) and I thought it is a bug so I posted it there. I will never come here again.


© 2019 Kong Inc.    Terms  •  Privacy  •  FAQ