[rt-users] Upgrade-database from 4.0.8 to 4.4.0rc2 fails

Christopher Kunz chrislist at de-punkt.de
Wed Nov 25 05:53:58 EST 2015


Hi,

I'm trying to upgrade an RT 4.0.8 instance (only lightly modified in
RT_SiteConfig.pm, no fancy stuff) to 4.4.0RC2. The 'make
upgrade-database' target fails at the following points:

== 4.0.8 => 4.0.9 ==
Processing 4.0.9
Now inserting data.
[11815] [Wed Nov 25 10:44:34 2015] [warning]: DBD::mysql::st execute
failed: Unknown column 'main.SortOrder' in 'order clause' at
/usr/local/share/perl/5.20.2/DBIx/SearchBuilder/Handle.pm line 586, <>
line 1. (/usr/local/share/perl/5.20.2/DBIx/SearchBuilder/Handle.pm:586)
[11815] [Wed Nov 25 10:44:34 2015] [warning]: RT::Handle=HASH(0x4878b28)
couldn't execute the query 'SELECT main.* FROM Queues main  WHERE
(main.Lifecycle IS NULL OR main.Lifecycle = '' OR main.Lifecycle = '0')
 ORDER BY main.SortOrder ASC, main.Name ASC ' at
/usr/local/share/perl/5.20.2/DBIx/SearchBuilder/Handle.pm line 599, <>
line 1.
	DBIx::SearchBuilder::Handle::SimpleQuery(RT::Handle=HASH(0x4878b28),
"SELECT main.* FROM Queues main  WHERE (main.Lifecycle IS NULL"...)
called at /usr/local/share/perl/5.20.2/DBIx/SearchBuilder.pm line 239
	DBIx::SearchBuilder::_DoSearch(RT::Queues=HASH(0x996a060)) called at
/usr/local/src/rt-4.4/sbin/../lib/RT/SearchBuilder.pm line 982
	RT::SearchBuilder::_DoSearch(RT::Queues=HASH(0x996a060)) called at
/usr/local/share/perl/5.20.2/DBIx/SearchBuilder.pm line 507
	DBIx::SearchBuilder::Next(RT::Queues=HASH(0x996a060)) called at
./etc/upgrade/4.0.9/content line 29
	RT::Handle::__ANON__() called at
/usr/local/src/rt-4.4/sbin/../lib/RT/Handle.pm line 866
	eval {...} called at /usr/local/src/rt-4.4/sbin/../lib/RT/Handle.pm
line 866
	RT::Handle::InsertData(RT::Handle=HASH(0x4878b28),
"./etc/upgrade/4.0.9/content", undef) called at sbin/rt-setup-database
line 390
	main::__ANON__() called at ./etc/upgrade/4.1.13/backcompat line 34
	main::__ANON__(CODE(0x98e2f50)) called at sbin/rt-setup-database line 400
	main::__ANON__() called at sbin/rt-setup-database line 403
	main::action_insert("backcompat", ARRAY(0xe413f0), "action", "upgrade",
"prompt-for-dba-password", 1, "datafile", undef, "datadir", ...) called
at sbin/rt-setup-database line 571
	main::action_upgrade("action", "upgrade", "prompt-for-dba-password", 1,
"package", "RT") called at sbin/rt-setup-database line 210
(/usr/share/perl/5.20/Carp.pm:169)

Then the upgrades to 4.0.12 through 4.1.0 run through without issue, but
after that:

Processing 4.1.1
Now populating database schema.
[11815] [Wed Nov 25 10:44:40 2015] [critical]: DBD::mysql::st execute
failed: Duplicate column name 'Disabled' at
/usr/local/src/rt-4.4/sbin/../lib/RT/Handle.pm line 552.
(/usr/local/src/rt-4.4/sbin/../lib/RT.pm:390)
DBD::mysql::st execute failed: Duplicate column name 'Disabled' at
/usr/local/src/rt-4.4/sbin/../lib/RT/Handle.pm line 552.
Makefile:391: recipe for target 'upgrade-database' failed
make: *** [upgrade-database] Error 255

How can I fix this issue? Can't find anything in the upgrade docs, let
alone UPGRADING.mysql, that points to a possible cause for these errors.

Thanks for any pointers!

Regards,

--ck



More information about the rt-users mailing list