<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: arial,helvetica,sans-serif; font-size: 12pt; color: #000000'>Good morning,<br><br>This is a follow-up of my problem :<br><br>This morning I decided to shred the attachment 602620.<br>But after execution of rt-fulltext-indexer it fails again at the next number of attachment : 602621 !<br><br>So this was clearly not the solution. But now I have not idea of what is the problem.<br><br>Any clue or help is greatly appreciated.<br>Thanks and have a good day,<br>Elisabeth<br><br><hr id="zwchr"><blockquote style="border-left:2px solid rgb(16, 16, 255);margin-left:5px;padding-left:5px;color:#000;font-weight:normal;font-style:normal;text-decoration:none;font-family:Helvetica,Arial,sans-serif;font-size:12pt;"><b>De: </b>elifree@free.fr<br><b>À: </b>rt-users@lists.bestpractical.com<br><b>Envoyé: </b>Jeudi 21 Janvier 2016 15:57:08<br><b>Objet: </b>fulltext index update failure (RT 4.2.12)<br><br><style>p { margin: 0; }</style><div style="font-family: arial,helvetica,sans-serif; font-size: 12pt; color: #000000">Hello,<br><br>We have juste upgraded our RT this morning to version 4.2.12 (from 4.2.6) and MySQL to 5.6 (from 5.5) in order to implement the full text indexing.<br><br>It works, but when running /appli/rt4/sbin/rt-fulltext-indexer to update the table AttachmentsIndex, it stops with an error :<br><br>extract from the log file : <br><br><span style="white-space:pre"> </span>Jan 21 14:50:01 helpdesk.inria.fr CRON[9668]: (root) CMD (/appli/rt4/sbin/rt-fulltext-indexer --quiet)<br><br><span style="white-space:pre"> </span>Jan 21 14:50:03 helpdesk.inria.fr RT: [9669] DBD::mysql::st execute failed: MySQL server has gone away at /appli/rt4/sbin/rt-fulltext-indexer line 216.<br><span style="white-space:pre"> </span>Jan 21 14:50:03 helpdesk.inria.fr RT: [9669] DBD::mysql::st execute failed: MySQL server has gone away at /appli/rt4/sbin/rt-fulltext-indexer line 222.<br><span style="white-space:pre"> </span>Jan 21 14:50:03 helpdesk.inria.fr RT: [9669] Attachment 602620 cannot be indexed: MySQL server has gone away at /appli/rt4/sbin/rt-fulltext-indexer line 254.<br><br>The result is that new attachments are not indexed.<br><br>I don't know what to do : should I just shred the attachment 602620 ? Is this at risk ?<br><br>Thanks a lot for your help, <br>Elisabeth<br><br><br><br><br><br><br><br><br><br></div></blockquote><br></div></body></html>