Rt 3.2.3 -> 3.4.4

RT Users
1

I’ve upgraded from 3.2.3 to 3.4.4 and things are not quite working out.
The DB was upgraded with the updates from 3.3.0 then 3.3.11 updates the perl
deps passed but when restarting I have outgoing email issues (not mta related).

(ie.)

rt-setup-database --dba root --prompt-for-dba-password --action schema --datadir
etc/upgrade/3.3.0
rt-setup-database --dba root --prompt-for-dba-password --action acl --datadir
etc/upgrade/3.3.0
rt-setup-database --dba root --prompt-for-dba-password --action insert --datadir
etc/upgrade/3.3.0
rt-setup-database --dba root --prompt-for-dba-password --action schema --datadir
etc/upgrade/3.3.11
rt-setup-database --dba root --prompt-for-dba-password --action acl --datadir
etc/upgrade/3.3.11
rt-setup-database --dba root --prompt-for-dba-password --action insert --datadir
etc/upgrade/3.3.11

The tickets get created but I receive the following errors in syslog as well as
having ‘update multiple’ and the ‘query builder’ hang until it times out with an
error 550.

Oct 20 12:31:31 ticket RT: Scrip Prepare 3 died. - Can’t locate object method
“ScripActionObj” via package “RT::Action::Notify” at
/opt/rt/lib/RT/Action/SendEmail.pm line 456.

Oct 20 12:24:55 ticket RT: Scrip Prepare 8 died. - Can’t locate object method
“ScripActionObj” via package “RT::Action::NotifyAsComment” at
/opt/rt/lib/RT/Action/SendEmail.pm line 447.

Did I miss something obvious upgrading the upgrade? Perl is 5.8.5 with the
rt-bundle installed.

Suggestions? Thank you.

J.P. Racine
racinejp@vianet.ca

2

The speed issues are related to SELECT DISTICT where using the query builder
causes a timeout ( past what fastcgi is set to 120-240 )

FastCGI 2.4.2
Apache 1.3.34
Mysql 4.1.15

3 Query SELECT DISTINCT main.* FROM Users main , Principals Principals_1,
ACL ACL_2, Groups Groups_3, CachedGroupMembers CachedGroupMembers_4 WHERE
((ACL_2.RightName = ‘OwnTicket’)) AND ((CachedGroupMembers_4.MemberId =
Principals_1.id)) AND ((Groups_3.id = CachedGroupMembers_4.GroupId)) AND
((Principals_1.Disabled = ‘0’)or(Principals_1.Disabled = ‘0’)) AND
((Principals_1.id != ‘1’)) AND ((main.id = Principals_1.id)) AND ( (
ACL_2.PrincipalId = Groups_3.id AND ACL_2.PrincipalType = ‘Group’
AND ( Groups_3.Domain = ‘SystemInternal’ OR Groups_3.Domain =
‘UserDefined’ OR Groups_3.Domain = ‘ACLEquivalence’))
OR ( ( (Groups_3.Domain = ‘RT::Queue-Role’ ) ) AND
Groups_3.Type = ACL_2.PrincipalType) ) AND (ACL_2.ObjectType = ‘RT::System’ OR
(ACL_2.ObjectType = ‘RT::Queue’) ) ORDER BY main.Name ASC
051021 18:31:59

4 Query SELECT * FROM Users WHERE id = ‘1’

Should I be flushing tables of cached Principle/Group data? Would the procedure
be to list deleted then shred them? If not how are the rest of you doing it?