Upgrade von 3.1.21.1 --> 3.2.16.01 schlägt fehl...

[MichiS]

Hallo zusammen,

derzeit kämpfe ich mit einem Problem, das mein Upgrade von 3.1.21.1 auf 3.2.16.01 fehl schlägt. Ich habe hier auch schon gesucht, aber den Entscheidenen Tip für mein Problem konnte ich nicht finden.

Wenn ich die index.pl aufrufe bekomme ich folgenden Fehler angezeigt:

Serverfehler!

Die Anfrage kann nicht beantwortet werden, da im Server ein interner Fehler aufgetreten ist.

Fehlermeldung:
Premature end of script headers: index.pl

Vorgegangen bin ich nach folgender Anleitung:

viewtopic.php?f=62&t=25939&p=103765&hil ... rs#p103765

Dies hat bis zum Punkt 4.4 DBUpdate-to-3.2.pl gut geklappt.

otrs@vm-srv08:~/scripts> ./DBUpdate-to-3.2.pl

Migration started...

Step 1 of 10: 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.
done.

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

Step 3 of 10: Cleanup UserPreferences... done.

Step 4 of 10: Updating toolbar configuration... done.

Step 5 of 10: Updating AgentTicketZoom window configuration... done.

Step 6 of 10: Dropping obsolete columns from article_search... Check if columns exist.
Columns are not present, no need to drop them.
done.

Step 7 of 10: Dropping unused indexes on article_flag... SET @FKExists := (SELECT COUNT(*) FROM information_schema.table_constraints WHERE table_schema = DATABASE() AND table_name = 'article_flag' AND constraint_name = 'FK_article_flag_article_id_id')
OK
SET @FKSQLStatement := IF( @FKExists > 0, 'ALTER TABLE article_flag DROP FOREIGN KEY FK_article_flag_article_id_id', 'SELECT ''INFO: Foreign key constraint FK_article_flag_article_id_id does not exist, skipping.''' )
OK
PREPARE FKStatement FROM @FKSQLStatement
OK
EXECUTE FKStatement
OK
SET @FKExists := (SELECT COUNT(*) FROM information_schema.table_constraints WHERE table_schema = DATABASE() AND table_name = 'article_flag' AND constraint_name = 'FK_article_flag_create_by_id')
OK
SET @FKSQLStatement := IF( @FKExists > 0, 'ALTER TABLE article_flag DROP FOREIGN KEY FK_article_flag_create_by_id', 'SELECT ''INFO: Foreign key constraint FK_article_flag_create_by_id does not exist, skipping.''' )
OK
PREPARE FKStatement FROM @FKSQLStatement
OK
EXECUTE FKStatement
OK
DROP INDEX article_flag_create_by ON article_flag
DBD::mysql::db do failed: Can't DROP 'article_flag_create_by'; check that column/key exists at /opt/otrs/Kernel/System/DB.pm line 476.
ERROR: OTRS-DBUpdate-to-3.2-10 Perl: 5.12.3 OS: linux Time: Thu Aug 7 13:30:25 2014

Message: Can't DROP 'article_flag_create_by'; check that column/key exists, SQL: 'DROP INDEX article_flag_create_by ON article_flag'

Traceback (13003):
Module: main::_DropArticleFlagIndexes (unknown version) Line: 486
Module: ./DBUpdate-to-3.2.pl (unknown version) Line: 107

Index was not present
DROP INDEX article_flag_article_id_article_key ON article_flag
DBD::mysql::db do failed: Can't DROP 'article_flag_article_id_article_key'; check that column/key exists at /opt/otrs/Kernel/System/DB.pm line 476.
ERROR: OTRS-DBUpdate-to-3.2-10 Perl: 5.12.3 OS: linux Time: Thu Aug 7 13:30:25 2014

Message: Can't DROP 'article_flag_article_id_article_key'; check that column/key exists, SQL: 'DROP INDEX article_flag_article_id_article_key ON article_flag'

Traceback (13003):
Module: main::_DropArticleFlagIndexes (unknown version) Line: 486
Module: ./DBUpdate-to-3.2.pl (unknown version) Line: 107

Index was not present
ALTER TABLE article_flag ADD CONSTRAINT FK_article_flag_article_id_id FOREIGN KEY (article_id) REFERENCES article (id)
OK
ALTER TABLE article_flag ADD CONSTRAINT FK_article_flag_create_by_id FOREIGN KEY (create_by) REFERENCES users (id)
OK
Step 8 of 10: Migration cache backend configuration... done.

Step 9 of 10: Clean up the cache... done.

Step 10 of 10: Refresh configuration cache another time...
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.
done.

Migration completed!

den RebuildConfig und DeleteCache habe ich ebenfalls gemacht.

Die Datenbank ist auf InnoDB eingestellt:

+------------+---------+------------------------------------------------------------+--------------+------+------------+
| Engine | Support | Comment | Transactions | XA | Savepoints |
+------------+---------+------------------------------------------------------------+--------------+------+------------+
| ARCHIVE | YES | Archive storage engine | NO | NO | NO |
| MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO |
| CSV | YES | CSV storage engine | NO | NO | NO |
| MyISAM | YES | Default engine as of MySQL 3.23 with great performance | NO | NO | NO |
| InnoDB | DEFAULT | Supports transactions, row-level locking, and foreign keys | YES | YES | YES |
| MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO |
+------------+---------+------------------------------------------------------------+--------------+------+------------+
6 rows in set (0.00 sec)


und in der my.cnf auch als default-storage-engine festgelgt.

Das System läuft unter:

Suse 11.4,
uname -a = Linux vm-srv08 2.6.37.1-1.2-desktop #1 SMP PREEMPT 2011-02-21 10:34:10 +0100 x86_64 x86_64 x86_64 GNU/Linux
Perl -v = This is perl 5, version 12, subversion 3 (v5.12.3) built for x86_64-linux-thread-multi
mysql Ver 14.14 Distrib 5.1.63, for suse-linux-gnu (x86_64) using readline 6.1

Ich hoffe, ihr könnt mir weiterhelfen, Vielen Dank schonmal im Voraus.

Gruss
Michi

[wurzel]

Hi,

das Upgrade sieht gut aus.

Evtl. hilft ein Blick in die apache error log?

Flo

[MichiS]

Hallo,

danke für den Tip, an die Apache log Files habe ich in dem Moment gar nicht gedacht. Dieses Verzeichnis war komischerweise leer, habe den Inhalt reinkopiert vom anderen System und jetzt geht es.
Vielen Dankfür die schnelle Hilfe

Viele Grüsse
Michi