<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal>Good afternoon,<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>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?<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>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) <o:p></o:p></p><p class=MsoNormal>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) <o:p></o:p></p><p class=MsoNormal>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<o:p></o:p></p><p class=MsoNormal>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) <o:p></o:p></p><p class=MsoNormal>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) <o:p></o:p></p><p class=MsoNormal>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<o:p></o:p></p><p class=MsoNormal>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) <o:p></o:p></p><p class=MsoNormal>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:<o:p></o:p></p><p class=MsoNormal>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) <o:p></o:p></p><p class=MsoNormal>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)<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>--Dale</span><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'> <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>---------------------------------------<br>Dale Poulter<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Coordinator, Search and Core Services<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Library Digital Services<br>Vanderbilt University<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>419 21st Avenue South, Room 812 <br>Nashville, TN 37203-2427<br>(615)343-5388<br>(615)343-8834 (fax)<br>(615)207-9705 (cell)<br><a href="mailto:dale.poulter@vanderbilt.edu"><span style='color:windowtext'>dale.poulter@vanderbilt.edu</span></a></span><o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>