Is the OTRS/Znuny DBUpdate-to-X.pl script idempotent/re-run-able?

In our case we have seldom the luck, that the upgrade of OTRS / Znuny is working like charm and runs of first execution.
We are using OTRS / Znuny since version 1.0 and we have never had a clean upgrade!

Before going on, lets clarify idempotent. This means you can re-run multiple times a function, a script or code which will ensure that you have exactly one result independently if you have issues on the path in between.

Luckily the developer of OTRS / Znuny have implemented a clean idempotent upgrade script, which you can run multiple times. E.g. DDLs for databases are not idempotent and thus once they have been executed the re-execution is not possible. But it depends if the developers have included some detection for execution. If you want to dig deeper here is a very good article how to manage a database like a source repository with liquibase

But getting back to OTRS / Znuny let us do following example.
You execute the upgrade from OTRS 5 to 6, for this you have to execute:

cd /opt/otrs
sudo -u otrs scripts/DBUpdate-to-6.pl

This script is is idempotent, that means if the script fails you can re-run the script once more.

Related articles

Related articles may be:

Do you need help with Znuny / OTRS?
We have lot of experiences with OTRS and Znuny and can help you with your issues. Get in touch with us and we will check if and how we can help you.

Leave a Comment

Do you need help with Znuny / OTRS?​

We have lot of experiences with OTRS and Znuny.
We can help you with your issues to solve them.

From giving you support up to implementing integrations to your existing systems.

Get in touch with us and we will check if and how we can help you.​

Get OTRS/Znuny/OTOBO Support
Step 1 of 2
To get a quick and efficient clearance of your needs, our experts will call you.
We communicate in English.
Maybe we can communicate in your native language too. So please let us know your native written and spoken language.

Your environment

We have different partners for different tasks and company sizes.
To assign you the right partner and thus the proper system engineers, we would like to ask you for more details about your environment.
The more details we get the quicker we can narrow down to the right persons.