[rt-users] Problems upgrading from 3.9.3

saxmad g.mason at fairfx.com
Tue Apr 23 09:11:33 EDT 2013


Carrying on the upgrade, I have got to version 3.9.3, but with some scary
messages about 3.9.2.

Processing 3.9.2
Now inserting data.
[Tue Apr 23 13:06:53 2013] [warning]: DBD::Pg::st execute failed: ERROR: 
column main.delegatedby does not exist
LINE 1: SELECT main.* FROM ACL main  WHERE (main.DelegatedBy > '0') ...
                                            ^ at
/usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 509, <> line 1.
(/usr/share/perl5/DBIx/SearchBuilder/Handle.pm:509)
[Tue Apr 23 13:06:53 2013] [warning]: RT::Handle=HASH(0x6d06e28) couldn't
execute the query 'SELECT main.* FROM ACL main  WHERE (main.DelegatedBy >
'0') AND (main.DelegatedFrom > '0') ' at
/usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 522
	DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x6d06e28)',
'SELECT main.* FROM ACL main  WHERE (main.DelegatedBy > \'0\')...') called
at /usr/share/perl5/DBIx/SearchBuilder.pm line 235
	DBIx::SearchBuilder::_DoSearch('RT::ACL=HASH(0x4bc3170)') called at
/usr/share/request-tracker4/lib/RT/SearchBuilder.pm line 343
	RT::SearchBuilder::_DoSearch('RT::ACL=HASH(0x4bc3170)') called at
/usr/share/request-tracker4/lib/RT/ACL.pm line 263
	RT::ACL::_DoSearch('RT::ACL=HASH(0x4bc3170)') called at
/usr/share/perl5/DBIx/SearchBuilder.pm line 503
	DBIx::SearchBuilder::Next('RT::ACL=HASH(0x4bc3170)') called at
/usr/share/request-tracker4/lib/RT/ACL.pm line 228
	RT::ACL::Next('RT::ACL=HASH(0x4bc3170)') called at
/usr/share/request-tracker4/etc/upgrade/3.9.2/content line 19
	RT::Handle::__ANON__() called at
/usr/share/request-tracker4/lib/RT/Handle.pm line 769
	eval {...} called at /usr/share/request-tracker4/lib/RT/Handle.pm line 769
	RT::Handle::InsertData('RT::Handle=HASH(0x6d06e28)',
'/usr/share/request-tracker4/etc/upgrade/3.9.2/content', undef) called at
/usr/sbin/rt-setup-database-4 line 291
	main::action_insert('datafile', undef, 'action', 'upgrade', 'datadir',
'/usr/share/request-tracker4/etc/upgrade/3.9.2', 'backcompat',
'ARRAY(0x2165e08)', 'dba', ...) called at /usr/sbin/rt-setup-database-4 line
397
	main::action_upgrade('action', 'upgrade', 'dba', 'postgres') called at
/usr/sbin/rt-setup-database-4 line 196 (/usr/share/perl/5.10/Carp.pm:47)
[Tue Apr 23 13:06:53 2013] [crit]: _DoSearch is not so successful as it
still needs redo search, won't call _BuildHash
(/usr/share/request-tracker4/lib/RT/ACL.pm:266)
Processing 3.9.3
Now populating database schema.
[Tue Apr 23 13:06:53 2013] [crit]: DBD::Pg::st execute failed: ERROR: 
column "delegatedby" of relation "acl" does not exist at
/usr/share/request-tracker4/lib/RT/Handle.pm line 515.
(/usr/share/request-tracker4/lib/RT.pm:351)
DBD::Pg::st execute failed: ERROR:  column "delegatedby" of relation "acl"
does not exist at /usr/share/request-tracker4/lib/RT/Handle.pm line 515.

Firstly, seeing as it tried to do the 3.9.3 upgrade, can I assume that the
3.9.2 upgrade did in fact go through, despite the messages ?

Secondly, what course of action is needed to fix the 3.9.3 upgrade message ? 
It seems to be related to the messages in the 3.9.2 upgrade, so maybe that
didn't got through cleanly.

Thanks.




--
View this message in context: http://requesttracker.8502.n7.nabble.com/Problems-upgrading-from-3-9-3-tp53543p53581.html
Sent from the Request Tracker - User mailing list archive at Nabble.com.



More information about the rt-users mailing list