Could you please share some more details regarding your issue?

Hi,

root@m:~# cat /etc/lsb-release
DISTRIB_ID=Ubuntu
DISTRIB_RELEASE=22.04
DISTRIB_CODENAME=jammy
DISTRIB_DESCRIPTION="Ubuntu 22.04.5 LTS"

After upgrade to Carbonio CE 25.6.1, i can't pass step "PGPASSWORD=$DB_ADM_PWD carbonio-message-dispatcher-migration carbonio_adm 127.78.0.10 20000" 

Checking of database schema... Done. The database needs to be updated!
Updating database... Failed!
Cannot run script file ' removed link '

step "pending-setups -a" passed correctly

@ulug79 

Could you please share what process you are following, manual or script?

In either case, after getting this error try to execute followings:

root@mail:~# carbonio-message-dispatcher-db setup
root@mail:~# PGPASSWORD=your-db-password carbonio-message-dispatcher-migration carbonio_adm 127.78.0.10 20000

Note: It is a known issue and our devs are taking a look at it.

Let us know how it goes.

root@m:~# carbonio-message-dispatcher-db setup
Insert the cluster credential password:
ID: b8fe4acd-7715-82c4-7a94-4c9753ded35d
Name: carbonio-message-dispatcher-db-policy
Description: Carbonio Message Dispatcher database service policy for config generation and for sidecar proxy
Datacenters:
Rules:
{
"key_prefix": [
{
"carbonio-message-dispatcher/": {
"policy": "write"
},
"carbonio-message-dispatcher-db/": {
"policy": "read"
}
}
],
"node_prefix": [
{
"": {
"policy": "read"
}
}
],
"service": [
{
"carbonio-message-dispatcher-xmpp": {
"policy": "write"
},
"carbonio-message-dispatcher-http": {
"policy": "write"
},
"carbonio-message-dispatcher-auth": {
"policy": "write"
},
"carbonio-message-dispatcher-http-sidecar-proxy": {
"policy": "write"
},
"carbonio-message-dispatcher-xmpp-sidecar-proxy": {
"policy": "write"
},
"carbonio-message-dispatcher-auth-sidecar-proxy": {
"policy": "write"
}
}
]
}
Config entry written: service-defaults/carbonio-message-dispatcher-db
Config entry written: service-intentions/carbonio-message-dispatcher-db
Configuration reload triggered
root@m:~# PGPASSWORD=$DB_ADM_PWD carbonio-message-dispatcher-migration carbonio_adm 127.78.0.10 20000
Checking of database schema... Done. The database needs to be updated!
Updating database... Failed!
Cannot run script file '/etc/carbonio/message-dispatcher/sql-scripts/migrations//6.0.0.sql'

@ulug79 

Please try this one:

PGPASSWORD=your-db-password carbonio-message-dispatcher-migration carbonio_adm 127.0.0.1

regards,

root@m:~# PGPASSWORD=$DB_ADM_PWD carbonio-message-dispatcher-migration carbonio_adm 127.0.0.1
Checking of database schema... Done. The database is already updated.
root@m:~#

@ulug79 

It looks like the database is updated. We are amending information related to carbonio-message-dispatcher-migration. I would suggest you and our users to check the documentation during the use of this command to avoid any issue.

https://docs.zextras.com/carbonio-ce/html/install/scenarios/single-server-scenario.html#step-8-bootstrap-file-databases

Regards,

Posted by: @sharif

↑

@ulug79 

It looks like the database is updated. We are amending information related to carbonio-message-dispatcher-migration. I would suggest you and our users to check the documentation during the use of this command to avoid any issue.

https://docs.zextras.com/carbonio-ce/html/install/scenarios/single-server-scenario.html#step-8-bootstrap-file-databases

Regards,

As I understand it, my problem is solved?

@ulug79 

Hi,

Could you please share some details of what problem you are facing considering your database seams to be updated based on your previous response? 

Posted by: @ulug79

↑

root@m:~# PGPASSWORD=$DB_ADM_PWD carbonio-message-dispatcher-migration carbonio_adm 127.0.0.1
Checking of database schema... Done. The database is already updated.
root@m:~#

Regards,

In update notes to 25.6.1 one step is:

PGPASSWORD=$DB_ADM_PWD carbonio-message-dispatcher-migration carbonio_adm 127.78.0.10 20000

Because this step not passed, i think database not updated properly 

@ulug79 

Basically the database could be connected and updated several ways and among them two ways are 

1. via consul (via 127.78.0.10 on 20000)
2. via localhost (127.0.0.1)

In case of multi server infrastructure, path 1 works seamlessly. In case of single server, it is being noticed that connecting to localhost is more convenient than via consul.

So if your system is updated via

# PGPASSWORD=$DB_ADM_PWD carbonio-message-dispatcher-migration carbonio_adm 127.0.0.1

that is as good as updating via consul. 

But what you have pointed out is valid and our team is already aligned to update all reference information for carbonio-message-dispatcher-migration. 

Regards