DBUpdate-to-3.3.pl for postgresql fails at step 6

[mathiask]

Hi,

I just tried to upgrade from 3.2.11 to 3.3.4 but when I run the DBUpdate-to-3.3.pl I get an error at step 3 but it continues to run but shortly after, at step 6 it dies completely. Here is the output generated by the script:

$ /opt/otrs/scripts/DBUpdate-to-3.3.pl
perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
LANGUAGE = (unset),
LC_ALL = (unset),
LC_CTYPE = "UTF-8",
LANG = "de_DE.UTF-8"
are supported and installed on your system.
perl: warning: Falling back to the standard locale ("C").

Migration started...

Step 1 of 13: Refresh configuration cache...
If you see warnings about 'Subroutine Load redefined', that's fine, no need to worry!
Subroutine Load redefined at /opt/otrs/Kernel/Config/Files/ZZZAAuto.pm line 7.
Subroutine Load redefined at /opt/otrs/Kernel/Config/Files/ZZZAuto.pm line 7.
done.

Step 2 of 13: Check framework version... done.

Step 3 of 13: Generate MessageID md5sums... DBD::Pg::db do failed: ERROR: column "a_message_id_md5" of relation "article" does not exist
LINE 3: SET a_message_id_md5 = MD5(a_message_id)
^ at /opt/otrs/Kernel/System/DB.pm line 499.
ERROR: OTRS-DBUpdate-to-3.3-10 Perl: 5.14.2 OS: linux Time: Wed Feb 19 15:43:36 2014

Message: ERROR: column "a_message_id_md5" of relation "article" does not exist
LINE 3: SET a_message_id_md5 = MD5(a_message_id)
^, SQL: '
UPDATE article
SET a_message_id_md5 = MD5(a_message_id)
WHERE a_message_id IS NOT NULL
'

Traceback (1832):
Module: main::_GenerateMessageIDMD5 (unknown version) Line: 582
Module: /opt/otrs/scripts/DBUpdate-to-3.3.pl (unknown version) Line: 99

done.

Step 4 of 13: Migrate old settings... done.

Step 5 of 13: Migrate OTRSExternalTicketNumberRecognition... done.

Step 6 of 13: Checking Standard Template table columns...
Check if 'template_type' columns exists.
'template_type' column not found, create it.
ALTER TABLE standard_template ADD template_type VARCHAR (100) NULL
DBD::Pg::db do failed: ERROR: relation "standard_template" does not exist at /opt/otrs/Kernel/System/DB.pm line 499.
ERROR: OTRS-DBUpdate-to-3.3-10 Perl: 5.14.2 OS: linux Time: Wed Feb 19 15:43:37 2014

Message: ERROR: relation "standard_template" does not exist, SQL: 'ALTER TABLE standard_template ADD template_type VARCHAR (100) NULL'

Traceback (1832):
Module: main::_AddTemplateTypeColumn (unknown version) Line: 478
Module: /opt/otrs/scripts/DBUpdate-to-3.3.pl (unknown version) Line: 126

ERROR: OTRS-DBUpdate-to-3.3-10 Perl: 5.14.2 OS: linux Time: Wed Feb 19 15:43:37 2014

Message: Error during execution of 'ALTER TABLE standard_template ADD template_type VARCHAR (100) NULL'!

Traceback (1832):
Module: main::_AddTemplateTypeColumn (unknown version) Line: 480
Module: /opt/otrs/scripts/DBUpdate-to-3.3.pl (unknown version) Line: 126

Died at /opt/otrs/scripts/DBUpdate-to-3.3.pl line 126.

The system runs on ubuntu 12.04 LTS with postgresql 9.1 on a seperate machine.

I'm grateful for any help! Thanks!

Mathias

[mathiask]

I solved my issue. The problem was that the database is running on another server and therefore no psql client was installed on the machine wich runs otrs. So the following line did nothing, not even throwing an exception

Code: Select all

    shell> cat scripts/DBUpdate-to-3.3.postgresql.sql | psql otrs otrs

I had to install the postgresql-client package and change above into this one (had to append the hostname)

Code: Select all

    shell> cat scripts/DBUpdate-to-3.3.postgresql.sql | psql -h hostname otrs otrs

After that everything ran smoothly.