Kong error upgrading from 2.2.0 to 2.3.0-dev.102

[farshidtz]

🐞 Bug Report

Affected Services [REQUIRED]

The issue is located in: kong

The kong upgrade from 2.6.0 to 2.8.0 results in error. This upgrade was introduced in the snap by #4210 .

Is this a regression?

Yes, the previous version in which this bug was not present was: 2.3.0-dev.99

Description and Minimal Reproduction [REQUIRED]

$ snap install edgexfoundry --stable
edgexfoundry 2.2.0+2 from Canonical✓ installed

$ snap refresh edgexfoundry --edge
error: cannot perform the following tasks:
- Start snap "edgexfoundry" (4059) services (systemctl command [start snap.edgexfoundry.kong-daemon.service] failed with exit status 1: Job for snap.edgexfoundry.kong-daemon.service failed because the control process exited with error code.
See "systemctl status snap.edgexfoundry.kong-daemon.service" and "journalctl -xeu snap.edgexfoundry.kong-daemon.service" for details.
)

🔥 Exception or Error

2022-10-26T14:28:47+02:00 systemd[1]: Starting Service for snap application edgexfoundry.kong-daemon...
2022-10-26T14:28:48+02:00 edgexfoundry.kong-daemon[11058]: 2022/10/26 14:28:48 [warn] ulimit is currently set to "1024". For better performance set it to at least "4096" using "ulimit -n"
2022-10-26T14:28:48+02:00 edgexfoundry.kong-daemon[11058]: Database already bootstrapped
2022-10-26T14:28:49+02:00 edgexfoundry.kong-daemon[11070]: Error: Failed importing:
2022-10-26T14:28:49+02:00 edgexfoundry.kong-daemon[11070]: [postgres] ERROR: column "enabled" does not exist (345)
2022-10-26T14:28:49+02:00 edgexfoundry.kong-daemon[11070]:   Run with --v (verbose) or --vv (debug) for more details
2022-10-26T14:28:49+02:00 edgexfoundry.kong-daemon[11070]: parse successful, beginning import
2022-10-26T14:28:49+02:00 edgexfoundry.kong-daemon[11083]: 2022/10/26 14:28:49 [warn] ulimit is currently set to "1024". For better performance set it to at least "4096" using "ulimit -n"
2022-10-26T14:28:49+02:00 edgexfoundry.kong-daemon[11083]: Error:
2022-10-26T14:28:49+02:00 edgexfoundry.kong-daemon[11083]: /usr/local/share/lua/5.1/kong/cmd/start.lua:75: /usr/local/share/lua/5.1/kong/cmd/utils/migrations.lua:20: New migrations available; run 'kong migrations up' to proceed
2022-10-26T14:28:49+02:00 edgexfoundry.kong-daemon[11083]: stack traceback:
2022-10-26T14:28:49+02:00 edgexfoundry.kong-daemon[11083]: 	[C]: in function 'error'
2022-10-26T14:28:49+02:00 edgexfoundry.kong-daemon[11083]: 	/usr/local/share/lua/5.1/kong/cmd/start.lua:75: in function 'cmd_exec'
2022-10-26T14:28:49+02:00 edgexfoundry.kong-daemon[11083]: 	/usr/local/share/lua/5.1/kong/cmd/init.lua:89: in function </usr/local/share/lua/5.1/kong/cmd/init.lua:89>
2022-10-26T14:28:49+02:00 edgexfoundry.kong-daemon[11083]: 	[C]: in function 'xpcall'
2022-10-26T14:28:49+02:00 edgexfoundry.kong-daemon[11083]: 	/usr/local/share/lua/5.1/kong/cmd/init.lua:89: in function </usr/local/share/lua/5.1/kong/cmd/init.lua:46>
2022-10-26T14:28:49+02:00 edgexfoundry.kong-daemon[11083]: 	/usr/local/bin/kong:9: in function 'file_gen'
2022-10-26T14:28:49+02:00 edgexfoundry.kong-daemon[11083]: 	init_worker_by_lua:49: in function <init_worker_by_lua:47>
2022-10-26T14:28:49+02:00 edgexfoundry.kong-daemon[11083]: 	[C]: in function 'xpcall'
2022-10-26T14:28:49+02:00 edgexfoundry.kong-daemon[11083]: 	init_worker_by_lua:56: in function <init_worker_by_lua:54>
2022-10-26T14:28:49+02:00 edgexfoundry.kong-daemon[11083]: 2022/10/26 14:28:49 [verbose] Kong: 2.8.0
2022-10-26T14:28:49+02:00 edgexfoundry.kong-daemon[11083]: 2022/10/26 14:28:49 [verbose] reading config file at /var/snap/edgexfoundry/4059/config/security-proxy-setup/kong.conf
2022-10-26T14:28:49+02:00 edgexfoundry.kong-daemon[11083]: 2022/10/26 14:28:49 [verbose] prefix in use: /var/snap/edgexfoundry/current/kong
2022-10-26T14:28:49+02:00 edgexfoundry.kong-daemon[11083]: 2022/10/26 14:28:49 [verbose] preparing nginx prefix directory at /var/snap/edgexfoundry/current/kong
2022-10-26T14:28:49+02:00 edgexfoundry.kong-daemon[11083]: 2022/10/26 14:28:49 [verbose] SSL enabled on
2022-10-26T14:28:49+02:00 edgexfoundry.kong-daemon[11083]: 2022/10/26 14:28:49 [verbose] proxy SSL certificate found at /var/snap/edgexfoundry/current/kong/ssl/kong-default.crt
2022-10-26T14:28:49+02:00 edgexfoundry.kong-daemon[11083]: 2022/10/26 14:28:49 [verbose] proxy SSL certificate found at /var/snap/edgexfoundry/current/kong/ssl/kong-default-ecdsa.crt
2022-10-26T14:28:49+02:00 edgexfoundry.kong-daemon[11083]: 2022/10/26 14:28:49 [verbose] SSL enabled on
2022-10-26T14:28:49+02:00 edgexfoundry.kong-daemon[11083]: 2022/10/26 14:28:49 [verbose] admin SSL certificate found at /var/snap/edgexfoundry/current/kong/ssl/admin-kong-default.crt
2022-10-26T14:28:49+02:00 edgexfoundry.kong-daemon[11083]: 2022/10/26 14:28:49 [verbose] admin SSL certificate found at /var/snap/edgexfoundry/current/kong/ssl/admin-kong-default-ecdsa.crt
2022-10-26T14:28:49+02:00 edgexfoundry.kong-daemon[11083]: 2022/10/26 14:28:49 [verbose] retrieving database schema state...
2022-10-26T14:28:49+02:00 edgexfoundry.kong-daemon[11083]: 2022/10/26 14:28:49 [verbose] schema state retrieved
2022-10-26T14:28:49+02:00 edgexfoundry.kong-daemon[11083]: 2022/10/26 14:28:49 [verbose] could not start Kong, stopping services
2022-10-26T14:28:49+02:00 edgexfoundry.kong-daemon[11083]: 2022/10/26 14:28:49 [verbose] stopped services
2022-10-26T14:28:49+02:00 systemd[1]: snap.edgexfoundry.kong-daemon.service: Control process exited, code=exited, status=1/FAILURE
2022-10-26T14:28:49+02:00 systemd[1]: snap.edgexfoundry.kong-daemon.service: Failed with result 'exit-code'.
2022-10-26T14:28:49+02:00 systemd[1]: Failed to start Service for snap application edgexfoundry.kong-daemon.

🌍 Your Environment

Deployment Environment:
Snaps

EdgeX Version [REQUIRED]:
2.3.0-dev.102

Anything else relevant?