Bug#825291: otrs2: fails to upgrade from 'jessie': DBUpdate-to-5.pl: DBD::Pg::db do failed: ERROR: invalid byte sequence for encoding "UTF8"
tag #825291 + moreinfo severity #825291 important tag #825291 + unreproduceable thanks Hi, I can not reproduce your bug report, see attached logs. Am 27.05.2016 um 16:37 schrieb Andreas Beckmann: > 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 -- /* Mit freundlichem Gruß / With kind regards, Patrick Matthäi GNU/Linux Debian Developer Blog: http://www.linux-dev.org/ E-Mail: pmatth...@debian.org patr...@linux-dev.org */ root@debian:/home/me# apt-get install otrs2/jessie-backports Paketlisten werden gelesen... Fertig Abhängigkeitsbaum wird aufgebaut. Statusinformationen werden eingelesen Fertig Version »5.0.10-1~bpo8+1« (Debian Backports:jessie-backports [all]) für »otrs2« gewählt. Die folgenden Pakete wurden automatisch installiert und werden nicht mehr benötigt: javascript-common libjs-jquery libjs-jquery-ui Verwenden Sie »apt-get autoremove«, um sie zu entfernen. Die folgenden zusätzlichen Pakete werden installiert: libappconfig-perl libarchive-zip-perl libexcel-writer-xlsx-perl libhtml-truncate-perl liblingua-translit-perl libnet-smtp-tls-butmaintained-perl libpod-strip-perl libschedule-cron-events-perl libset-crontab-perl libtemplate-perl libxml-libxslt-perl libxslt1.1 Vorgeschlagene Pakete: libtemplate-perl-doc libtemplate-plugin-gd-perl libtemplate-plugin-xml-perl Die folgenden NEUEN Pakete werden installiert: libappconfig-perl libarchive-zip-perl libexcel-writer-xlsx-perl libhtml-truncate-perl liblingua-translit-perl libnet-smtp-tls-butmaintained-perl libpod-strip-perl libschedule-cron-events-perl libset-crontab-perl libtemplate-perl libxml-libxslt-perl libxslt1.1 Die folgenden Pakete werden aktualisiert (Upgrade): otrs2 1 aktualisiert, 12 neu installiert, 0 zu entfernen und 0 nicht aktualisiert. Es müssen 8.472 kB an Archiven heruntergeladen werden. Nach dieser Operation werden 17,2 MB Plattenplatz zusätzlich benutzt. Möchten Sie fortfahren? [J/n] j Holen: 1 http://ftp.de.debian.org/debian/ jessie/main libxslt1.1 amd64 1.1.28-2+b2 [232 kB] Holen: 2 http://ftp.de.debian.org/debian/ jessie/main libappconfig-perl all 1.66-1 [77,8 kB] Holen: 3
Processed (with 1 error): Re: Bug#825291: otrs2: fails to upgrade from 'jessie': DBUpdate-to-5.pl: DBD::Pg::db do failed: ERROR: invalid byte sequence for encoding "UTF8"
Processing commands for cont...@bugs.debian.org: > tag #825291 + moreinfo Bug #825291 [otrs2] otrs2: fails to upgrade from 'jessie': DBUpdate-to-5.pl: DBD::Pg::db do failed: ERROR: invalid byte sequence for encoding "UTF8" Ignoring request to alter tags of bug #825291 to the same tags previously set > severity #825291 important Bug #825291 [otrs2] otrs2: fails to upgrade from 'jessie': DBUpdate-to-5.pl: DBD::Pg::db do failed: ERROR: invalid byte sequence for encoding "UTF8" Severity set to 'important' from 'serious' > tag #825291 + unreproduceable Unknown tag/s: unreproduceable. Recognized are: patch wontfix moreinfo unreproducible fixed potato woody sid help security upstream pending sarge sarge-ignore experimental d-i confirmed ipv6 lfs fixed-in-experimental fixed-upstream l10n newcomer etch etch-ignore lenny lenny-ignore squeeze squeeze-ignore wheezy wheezy-ignore jessie jessie-ignore stretch stretch-ignore buster buster-ignore. Bug #825291 [otrs2] otrs2: fails to upgrade from 'jessie': DBUpdate-to-5.pl: DBD::Pg::db do failed: ERROR: invalid byte sequence for encoding "UTF8" Requested to add no tags; doing nothing. > thanks Stopping processing here. Please contact me if you need assistance. -- 825291: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=825291 Debian Bug Tracking System Contact ow...@bugs.debian.org with problems
Bug#825291: otrs2: fails to upgrade from 'jessie': DBUpdate-to-5.pl: DBD::Pg::db do failed: ERROR: invalid byte sequence for encoding "UTF8"
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
Processed: Re: Bug#825291: otrs2: fails to upgrade from 'jessie': DBUpdate-to-5.pl: DBD::Pg::db do failed: ERROR: invalid byte sequence for encoding "UTF8"
Processing commands for cont...@bugs.debian.org: > tag #825291 + moreinfo Bug #825291 [otrs2] otrs2: fails to upgrade from 'jessie': DBUpdate-to-5.pl: DBD::Pg::db do failed: ERROR: invalid byte sequence for encoding "UTF8" Added tag(s) moreinfo. > tag #825291 + upstream Bug #825291 [otrs2] otrs2: fails to upgrade from 'jessie': DBUpdate-to-5.pl: DBD::Pg::db do failed: ERROR: invalid byte sequence for encoding "UTF8" Added tag(s) upstream. > thanks Stopping processing here. Please contact me if you need assistance. -- 825291: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=825291 Debian Bug Tracking System Contact ow...@bugs.debian.org with problems
Bug#825291: otrs2: fails to upgrade from 'jessie': DBUpdate-to-5.pl: DBD::Pg::db do failed: ERROR: invalid byte sequence for encoding "UTF8"
tag #825291 + moreinfo tag #825291 + upstream thanks Hi, could you also test if it fails on your system if you update to 5.0.8 instead of 5.0.10? I already reported this to upstream: http://bugs.otrs.org/show_bug.cgi?id=12103 Am 25.05.2016 um 17:49 schrieb Andreas Beckmann: > Package: otrs2 > Version: 5.0.10-1 > Severity: serious > User: debian...@lists.debian.org > Usertags: piuparts > > Hi, > > during a test with piuparts I noticed your package fails to upgrade from > 'jessie'. > It installed fine in 'jessie', then the upgrade to 'stretch' fails. > > >From the attached log (scroll to the bottom...): > > [...] > Migration completed! > 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...[Mon May 23 13:17:50 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...[Mon May 23 13:17:51 2016] > DBUpdate-to-5.pl: Subroutine Load redefined at (eval 1736) 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...[Mon May > 23 13:17:51 2016] DBUpdate-to-5.pl: DBD::Pg::db do failed: ERROR: invalid > byte sequence for encoding "UTF8": 0xeb 0x73 0x63 at > /usr/share/otrs/Kernel/System/DB.pm line 449. > ERROR: OTRS-DBUpdate-to-5.pl-10 Perl: 5.22.2 OS: linux Time: Mon May 23 > 13:17:51 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 (13340): > Module: Kernel::System::NotificationEvent::NotificationAdd Line: 375 > Module: main::_MigrateNotifications Line: 1115 > Module: ./scripts/DBUpdate-to-5.pl Line: 162 > > error. > > [Mon May 23 13:17:51 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 > > > > cheers, > > Andreas -- /* Mit freundlichem Gruß / With kind regards, Patrick Matthäi GNU/Linux Debian Developer Blog: http://www.linux-dev.org/ E-Mail: pmatth...@debian.org patr...@linux-dev.org */
Bug#825291: otrs2: fails to upgrade from 'jessie': DBUpdate-to-5.pl: DBD::Pg::db do failed: ERROR: invalid byte sequence for encoding "UTF8"
Package: otrs2 Version: 5.0.10-1 Severity: serious User: debian...@lists.debian.org Usertags: piuparts Hi, during a test with piuparts I noticed your package fails to upgrade from 'jessie'. It installed fine in 'jessie', then the upgrade to 'stretch' fails. >From the attached log (scroll to the bottom...): [...] Migration completed! 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...[Mon May 23 13:17:50 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...[Mon May 23 13:17:51 2016] DBUpdate-to-5.pl: Subroutine Load redefined at (eval 1736) 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...[Mon May 23 13:17:51 2016] DBUpdate-to-5.pl: DBD::Pg::db do failed: ERROR: invalid byte sequence for encoding "UTF8": 0xeb 0x73 0x63 at /usr/share/otrs/Kernel/System/DB.pm line 449. ERROR: OTRS-DBUpdate-to-5.pl-10 Perl: 5.22.2 OS: linux Time: Mon May 23 13:17:51 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 (13340): Module: Kernel::System::NotificationEvent::NotificationAdd Line: 375 Module: main::_MigrateNotifications Line: 1115 Module: ./scripts/DBUpdate-to-5.pl Line: 162 error. [Mon May 23 13:17:51 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 cheers, Andreas otrs2_5.0.10-1.log.gz Description: application/gzip