[rt-users] RT 4.0.5 fulltext errors

[Poulter, Dale]

Good afternoon,

We have just install 4.0.5 in a test environment and migrated our data from 3.8.7.  The system was working with 4.0.4 with the same configuration before our dev server crashed. The system seems to be working well until we attempt to do a full text search.  Sphinx is enabled in mysql and the indexer has ran successfully.  I can do a basic simple search without any problems but when I do a fulltext search (fulltext: test) mysql restarts and I get the error below.  Has anyone encountered this issue?




Mar 23 11:14:26 libk RT: _DoSearch is not so successful as it still needs redo search, won't call _BuildAccessTable (/apps/rtdev/sbin/../lib/RT/Attributes.pm:85)
Mar 23 11:14:26 libk RT: DBD::mysql::st execute failed: MySQL server has gone away 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)
Mar 23 11:14:26 libk RT: RT::Handle=HASH(0xd146ca0) couldn't execute the query 'SELECT main.* FROM Attributes main  WHERE (main.ObjectType = 'RT::System') AND (main.ObjectId = 1)  ORDER BY main.id ASC ' at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 600   DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0xd146ca0)', 'SELECT main.* FROM Attributes main  WHERE (main.ObjectType = ...') called at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder.pm line 235   DBIx::SearchBuilder::_DoSearch('RT::Attributes=HASH(0xd4dd120)') called at /apps/rtdev/sbin/../lib/RT/SearchBuilder.pm line 320      RT::SearchBuilder::_DoSearch('RT::Attributes=HASH(0xd4dd120)') called at /apps/rtdev/sbin/../lib/RT/Attributes.pm line 81    RT::Attributes::_DoSearch('RT::Attributes=HASH(0xd4dd120)') called at /apps/rtdev/sbin/../lib/RT/Attributes.pm line 106      RT::Attributes::_AttrHash('RT::Attributes=HASH(0xd4dd120)') called at /apps/rtdev/sbin/../lib/RT/Attributes.pm line 137         RT::Attributes::Named('RT::Attributes=HAS
Mar 23 11:14:26 libk RT: _DoSearch is not so successful as it still needs redo search, won't call _BuildAccessTable (/apps/rtdev/sbin/../lib/RT/Attributes.pm:85)
Mar 23 11:14:26 libk RT: DBD::mysql::st execute failed: MySQL server has gone away 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)
Mar 23 11:14:26 libk RT: RT::Handle=HASH(0xd146ca0) couldn't execute the query 'SELECT COUNT(DISTINCT main.id) FROM Tickets main JOIN Transactions Transactions_1  ON ( Transactions_1.ObjectType = 'RT::Ticket' ) AND ( Transactions_1.ObjectId = main.id ) JOIN Attachments Attachments_2  ON ( Attachments_2.TransactionId = Transactions_1.id ) JOIN attachmentsindex attachmentsindex_3  ON ( attachmentsindex_3.id = Attachments_2.id )  WHERE (main.Status != 'deleted') AND ( (  ( attachmentsindex_3.query = 'test;limit=10000;maxmatches=10000' )  )  AND  ( main.Status = 'new' OR main.Status = 'open' OR main.Status = 'stalled' ) ) AND (main.Type = 'ticket') AND (main.EffectiveId = main.id) ' at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 600     DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0xd146ca0)', 'SELECT COUNT(DISTINCT main.id) FROM Tickets main JOIN Transac...') called at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder.pm line 291   DBIx::SearchBuilder::_DoCount('RT::Tickets=HASH(0x
Mar 23 11:14:26 libk RT: DBD::mysql::st execute failed: MySQL server has gone away 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)
Mar 23 11:14:26 libk RT: RT::Handle=HASH(0xd146ca0) couldn't execute the query 'SELECT  * FROM Attributes WHERE Name = ? AND ObjectType = ? AND ObjectId = ?' at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 600        DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0xd146ca0)', 'SELECT  * FROM Attributes WHERE Name = ? AND ObjectType = ? A...', 'Pref-RT::System-1', 'RT::User', 205) called at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Record.pm line 1206     DBIx::SearchBuilder::Record::_LoadFromSQL('RT::Attribute=HASH(0xd6b3e20)', 'SELECT  * FROM Attributes WHERE Name = ? AND ObjectType = ? A...', 'Pref-RT::System-1', 'RT::User', 205) called at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Record.pm line 1125      DBIx::SearchBuilder::Record::LoadByCols('RT::Attribute=HASH(0xd6b3e20)', 'Name', 'Pref-RT::System-1', 'ObjectId', 205, 'ObjectType', 'RT::User') called at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Record/Cachable.pm line 120     DBIx::SearchBuilder::Record::Cachable:
Mar 23 11:14:26 libk RT: DBD::mysql::st execute failed: MySQL server has gone away at /usr/lib/perl5/site_perl/5.8.8/Apache/Session/Store/DBI.pm line 67. (/usr/lib/perl5/site_perl/5.8.8/Apache/Session/Store/DBI.pm:67)
Mar 23 11:14:26 libk RT: DBD::mysql::st execute failed: MySQL server has gone away at /usr/lib/perl5/site_perl/5.8.8/Apache/Session/Lock/MySQL.pm line 71. (/usr/lib/perl5/site_perl/5.8.8/Apache/Session/Lock/MySQL.pm:71)

--Dale

---------------------------------------
Dale Poulter
Coordinator, Search and Core Services
Library Digital Services
Vanderbilt University
419 21st Avenue South, Room 812
Nashville, TN  37203-2427
(615)343-5388
(615)343-8834 (fax)
(615)207-9705 (cell)
dale.poulter at vanderbilt.edu<mailto:dale.poulter at vanderbilt.edu>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20120323/7fe3dc94/attachment.htm>