On 2016-05-27 15:12, Patrick Matthäi wrote:
> could you also test if it fails on your system if you update to 5.0.8
> instead of 5.0.10?
You are lucky, I some old jessie2stretch logfiles:
archive/pass/otrs_4.0.8-1.log.xz
archive/fail/otrs2_5.0.8+dfsg1-1.log.xz
The first one succeeded and second one failed the upgrade in the same way.
All other old logfiles were not helpful, mostly database connection
failures (but these can be caused by the piuparts environment,
i.e. postgresql running on the wrong port).
rerunning the tests with old packages is not trivial and would mean more manual
work
[...]
applying upgrade sql for 3.3.9-3 -> 5.0.0.
applying upgrade script for 3.3.9-3 -> 5.0.1.
Migration started...
Step 1 of 17: Refresh configuration cache...[Thu Apr 7 14:12:20 2016]
DBUpdate-to-5.pl: Subroutine Load redefined at (eval 16) line 2.
If you see warnings about 'Subroutine Load redefined', that's fine, no need
to worry!
done.
Step 2 of 17: Check framework version...[Thu Apr 7 14:12:21 2016]
DBUpdate-to-5.pl: Subroutine Load redefined at (eval 1727) line 2.
done.
Step 3 of 17: Migrate Database Column Types...done.
Step 4 of 17: Migrate charset to UTF-8 on auto_response table...done.
Step 5 of 17: Migrate charset to UTF-8 on notification_event table...done.
Step 6 of 17: Migrate event based notifications to support multiple
languages...done.
Step 7 of 17: Migrate notifications to event based notifications...[Thu Apr
7 14:12:21 2016] DBUpdate-to-5.pl: DBD::Pg::db do failed: ERROR: invalid byte
sequence for encoding "UTF8": 0xeb 0x73 0x63 at /usr/sha
re/otrs/Kernel/System/DB.pm line 449.
ERROR: OTRS-DBUpdate-to-5.pl-10 Perl: 5.22.1 OS: linux Time: Thu Apr 7
14:12:21 2016
Message: ERROR: invalid byte sequence for encoding "UTF8": 0xeb 0x73 0x63,
SQL: '
INSERT INTO notification_event_message
(notification_id, subject, text, content_type, language)
VALUES (?, ?, ?, ?, ?)'
Traceback (10036):
Module: Kernel::System::NotificationEvent::NotificationAdd Line: 375
Module: main::_MigrateNotifications Line: 1115
Module: ./scripts/DBUpdate-to-5.pl Line: 162
error.
[Thu Apr 7 14:12:21 2016] DBUpdate-to-5.pl: Died at
./scripts/DBUpdate-to-5.pl line 167.
error encountered processing
/usr/share/dbconfig-common/scripts/otrs2/upgrade/pgsql/5.0.1:
/usr/share/dbconfig-common/scripts/otrs2/upgrade/pgsql/5.0.1 exited with
non-zero status
dbconfig-common: otrs2 configure: aborted.
dbconfig-common: flushing administrative password
dpkg: error processing package otrs2 (--configure):
subprocess installed post-installation script returned error exit status 1
Andreas