[rt-users] strange MySQL problem

Jens Porup Jens.Porup at strategicdata.com.au
Mon Dec 19 01:21:54 EST 2005


Dear All,

I am replicating a production RT install on a development box.
The mysqldump produces ~600MB of data. 

The production box is running RT 3.4.1 on Debian Sarge. So is
the dev box. Both use the RT debian packages, i.e. not the tarball.

This produces two problems. 

The first problem is that 'Create Ticket' scrips fail to work.

The second problem is that the rt.log file is filling up with
errors I don't understand. See below.

The rt.log on the production box is sweet as. No errors. Very
happy. It purrs along.

But on the dev box, it is very grumpy.

What does all of this mean?

Thanks,

Jens


[Mon Dec 19 05:50:00 2005] [warning]: DBD::mysql::st execute failed: Table 'rtdb_test_copy2._2' doesn't exist at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 480.
 (/usr/share/request-tracker3.4/lib/RT.pm:277)
[Mon Dec 19 05:50:00 2005] [warning]: RT::Handle=HASH(0x8770298) couldn't execute the query 'SELECT DISTINCT main.* FROM (Users main  JOIN  _2  ON ( _2.id = CachedGroupMembers_1.MemberId)) , CachedGroupMembers CachedGroupMembers_1  WHERE ((CachedGroupMembers_1.GroupId = '147751')) AND ((main.Disabled = '0')) ' at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 494.
 (/usr/share/request-tracker3.4/lib/RT.pm:277)
[Mon Dec 19 05:50:00 2005] [warning]: DBD::mysql::st execute failed: Table 'rtdb_test_copy2._2' doesn't exist at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 480.
 (/usr/share/request-tracker3.4/lib/RT.pm:277)
[Mon Dec 19 05:50:00 2005] [warning]: RT::Handle=HASH(0x8770298) couldn't execute the query 'SELECT DISTINCT main.* FROM (Users main  JOIN  _2  ON ( _2.id = CachedGroupMembers_1.MemberId)) , CachedGroupMembers CachedGroupMembers_1  WHERE ((CachedGroupMembers_1.GroupId = '147755')) AND ((main.Disabled = '0')) ' at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 494.
 (/usr/share/request-tracker3.4/lib/RT.pm:277)
[Mon Dec 19 05:50:03 2005] [warning]: DBD::mysql::st execute failed: Table 'rtdb_test_copy2._4' doesn't exist at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 480.
 (/usr/share/request-tracker3.4/lib/RT.pm:277)
[Mon Dec 19 05:50:03 2005] [warning]: RT::Handle=HASH(0x87702e0) couldn't execute the query 'SELECT DISTINCT main.* FROM (Users main  JOIN  _4  ON ( _4.id = CachedGroupMembers_3.MemberId)) , ACL ACL_1, Groups Groups_2, CachedGroupMembers CachedGroupMembers_3  WHERE ((ACL_1.RightName = 'OwnTicket')) AND ((Groups_2.id = CachedGroupMembers_3.GroupId)) AND ((main.Disabled = '0')or(main.Disabled = '0')) AND ((main.id != '1')) AND  ( (    ACL_1.PrincipalId = Groups_2.id AND ACL_1.PrincipalType = 'Group'
                AND (   Groups_2.Domain = 'SystemInternal' OR Groups_2.Domain = 'UserDefined' OR Groups_2.Domain = 'ACLEquivalence'))
                 OR ( ( (Groups_2.Domain = 'RT::Queue-Role' AND Groups_2.Instance = 21)  )  AND Groups_2.Type = ACL_1.PrincipalType) )  AND (ACL_1.ObjectType = 'RT::System' OR  (ACL_1.ObjectType = 'RT::Queue' AND ACL_1.ObjectId = 21) ) ' at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 494.
 (/usr/share/request-tracker3.4/lib/RT.pm:277)
[Mon Dec 19 05:50:08 2005] [debug]: RT::Date used date::parse to make 2005-12-24 05:50:03 1135363803
 (/usr/share/request-tracker3.4/lib/RT/Date.pm:211)
[Mon Dec 19 05:50:08 2005] [warning]: DBD::mysql::st execute failed: Column 'TimeTaken' cannot be null at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 480.
 (/usr/share/request-tracker3.4/lib/RT.pm:277)
[Mon Dec 19 05:50:08 2005] [warning]: RT::Handle=HASH(0x8770298) couldn't execute the query 'INSERT INTO Transactions (OldReference, TimeTaken, Type, Field, OldValue, NewReference, NewValue, Creator, ObjectId, ReferenceType, Created, Data, ObjectType) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 494.
 (/usr/share/request-tracker3.4/lib/RT.pm:277)








More information about the rt-users mailing list