Upgrading from .88 to 408 sql issues

RT Users
1

Hey all,

I’ve been scouring the net as well as our config docs trying to figure out
what maybe causing my upgrade issues with DelegatedBy. We have mysql setup
with the innodb settings and 3.8.8 working great with RTIR.

Specifically there are two warnings. Which the upgrade script passed on,
then two critical errors.

Any suggestions would be greatly appreciated.

Full log below:

3.8.9 ok
3.9.1 ok
Processing 3.9.2
Now inserting data.
[Thu Jan 3 16:46:18 2013] [warning]: DBD::mysql::st execute failed:
Unknown column ‘main.DelegatedBy’ in ‘where clause’ at
/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 587.
(/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:587)
[Thu Jan 3 16:46:18 2013] [warning]: RT::Handle=HASH(0x1f53e620) couldn’t
execute the query 'SELECT main.* FROM ACL main WHERE (main.DelegatedBy >
‘0’) AND (main.DelegatedFrom > ‘0’) ’ at
/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 600

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x1f53e620)’,
‘SELECT main.* FROM ACL main WHERE (main.DelegatedBy > '0')…’) called
at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder.pm line 236
DBIx::SearchBuilder::_DoSearch(‘RT::ACL=HASH(0x1f1db0d0)’) called
at /tmp/rt-4.0.8/sbin/…/lib/RT/SearchBuilder.pm line 343
RT::SearchBuilder::_DoSearch(‘RT::ACL=HASH(0x1f1db0d0)’) called at
/tmp/rt-4.0.8/sbin/…/lib/RT/ACL.pm line 263
RT::ACL::_DoSearch(‘RT::ACL=HASH(0x1f1db0d0)’) called at
/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder.pm line 504
DBIx::SearchBuilder::Next(‘RT::ACL=HASH(0x1f1db0d0)’) called at
/tmp/rt-4.0.8/sbin/…/lib/RT/ACL.pm line 228
RT::ACL::Next(‘RT::ACL=HASH(0x1f1db0d0)’) called at
./etc/upgrade/3.9.2/content line 19
RT::Handle::ANON() called at
/tmp/rt-4.0.8/sbin/…/lib/RT/Handle.pm line 769
eval {…} called at /tmp/rt-4.0.8/sbin/…/lib/RT/Handle.pm line 769
RT::Handle::InsertData(‘RT::Handle=HASH(0x1f53e620)’,
‘./etc/upgrade/3.9.2/content’, ‘undef’) called at sbin/rt-setup-database
line 293
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’,
‘undef’, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/3.9.2’,
‘backcompat’, …) called at sbin/rt-setup-database line 399
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’,
‘upgrade’, ‘dba’, ‘root’) called at sbin/rt-setup-database line 198
(/usr/lib/perl5/5.8.8/Carp.pm:272)
[Thu Jan 3 16:46:18 2013] [critical]: _DoSearch is not so successful as it
still needs redo search, won’t call _BuildHash
(/tmp/rt-4.0.8/sbin/…/lib/RT/ACL.pm:266)
Processing 3.9.3
Now populating database schema.
[Thu Jan 3 16:46:18 2013] [critical]: DBD::mysql::st execute failed: Can’t
DROP ‘DelegatedBy’; check that column/key exists at
/tmp/rt-4.0.8/sbin/…/lib/RT/Handle.pm line 515.
(/tmp/rt-4.0.8/sbin/…/lib/RT.pm:341)
DBD::mysql::st execute failed: Can’t DROP ‘DelegatedBy’; check that
column/key exists at /tmp/rt-4.0.8/sbin/…/lib/RT/Handle.pm line 515.
make: *** [upgrade-database] Error 255

Thanks
Mike of Many Stories, Ideas, and Ramblings
Game Chef 2009, 2010
NaNoWriMo 2008, 2009,2010

http://mikeofmanystories.blogspot.com/

2

I’ve been scouring the net as well as our config docs trying to figure
out what maybe causing my upgrade issues with DelegatedBy. We have mysql
setup with the innodb settings and 3.8.8 working great with RTIR.

Specifically there are two warnings. Which the upgrade script passed on,
then two critical errors.

The errors below are consistent with those upgrade steps having already
been run at least once. Did you or someone else attempt an upgrade
previously and fail before trying again on the same (partially upgraded)
database?