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)
[email protected]<mailto:[email protected]>
